You are not logged in.

- Topics: Active | Unanswered

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

If it is fine, can you please give me your email id, i can send the spreadsheet to you, with all calculations and the resulting chart.

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

You are showing me the output, debugging a program is something you have to do because you understand what you did.

I can help with the mathematics of how you entered the first equation into excel. If you did that right then the rest you will have to figure. Did you enter it correctly? Show how you entered it.

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

yes i can do the debugging,i agree. But the circles need to touch / tangential, bu they are not as i construct the chart, maybe am doing something incorrect ...

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

i can go thru formula by formula if that is fine by you...

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

That might find the error.

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

in the first formula i entered r as 0.5, and varied n from 1 to 10 for x, then y and then R.

Cell D6 has the ratio r = 0.5, cell C7 = 0, c8=1 and so on and so forth ...

$6*(1+D$6)/(2*($C7*$C7*(1-D$6)*(1-D$6)+D$6))

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

$6*(1+D$6)/(2*($C7*$C7*(1-D$6)*(1-D$6)+D$6))

The first one looks okay. The next one...

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

for the next one Y coordinate

C22 = n ( n varies form 0 to 10) , D21 = 0.5 The ratio r

=$C22*D$21*(1-D$21)/($C22*$C22*(1-D$21)*(1-D$21)+D$21)

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

=$C22*D$21*(1-D$21)/($C22*$C22*(1-D$21)*(1-D$21)+D$21)

The second one looks okay.

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

the subsequent ones are as follows 3rd formula

here D36 = ratio = 0.5 and C37 = n (varying from 0 to 10

=(1-D$36)*D$36/(2*($C37*$C37*(1-D$36)*(1-D$36)+D$36))

similarly

4th formula

X for Tn

here d52 = 0.5 the ratio 'r' and C53 = n varying from 0 to 10

$52*(7+D$52)/(2*(4+4*$C53*($C53-1)*(1-D$52)*(1-D$52)+D$52*(D$52-1)))

y for Tn

here C69 = n varying from 0 to 10 and D68 = 0.5 the ratio

=2*(2*$C69-1)*D$68*(1-D$68)/((4+4*$C69*($C69-1)*(1-D$68)*(1-D$68)+D$68*(D$68-1)))

r for Tn

here D84 = 0.5 the ratio and C85 = n varying from 0 to 10

$84*(1-D$84)/(2*(4+4*$C85*($C85-1)*(1-D$84)*(1-D$84)+D$84*(D$84-1)))

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

now for calculating the area i am calculating the r using the circle formula of x^2 + y^2 = r^2.

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

here D36 = ratio = 0.5 and C37 = n (varying from 0 to 10

=(1-D$36)*D$36/(2*($C37*$C37*(1-D$36)*(1-D$36)+D$36))

here d52 = 0.5 the ratio 'r' and C53 = n varying from 0 to 10

$52*(7+D$52)/(2*(4+4*$C53*($C53-1)*(1-D$52)*(1-D$52)+D$52*(D$52-1)))

Third one looks okay.

Fourth one has an error.

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

ohhh. please tell me the error...

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

Right at the beginning of line 4.

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

ok, ... i am still not able to see it...

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

How about a D in front of that 52?

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

Ok Thanks

There is a D in front to 52 it gets converted to a smiley when it is represented in this website..

......D$52*(7+D$52)/(2*(4+4*$C53*($C53-1)*(1-D$52)*(1-D$52)+D$52*(D$52-1)))

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

The fourth line looks okay then.

here C69 = n varying from 0 to 10 and D68 = 0.5 the ratio

=2*(2*$C69-1)*D$68*(1-D$68)/((4+4*$C69*($C69-1)*(1-D$68)*(1-D$68)+D$68*(D$68-1)))

Fifth looks okay.

r for Tn

here D84 = 0.5 the ratio and C85 = n varying from 0 to 10

$D84*(1-D$84)/(2*(4+4*$C85*($C85-1)*(1-D$84)*(1-D$84)+D$84*(D$84-1)))

Last looks okay. How did you arrive at r = .5?

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

i have assumed r as 0.5 1 /2 AB = 1, AC=2

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

Have you tried other guesses?

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

i think the way the radius / area is calculated needs to be looked into ...

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

yes i have tried other guesses , r = 0.5, 0.33, 0.25 .. and so on upto 0.1

will the spreadsheet help in deciphering the error ..? i can send that to you if it is not much of a bother ...

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

as i change the r i get some weird patterns ... in the graph

Offline

**bobbym****bumpkin**- From: Bumpkinland
- Registered: 2009-04-12
- Posts: 109,606

Are you using the mathworld page or what?

**In mathematics, you don't understand things. You just get used to them.****If it ain't broke, fix it until it is.**** Always satisfy the Prime Directive of getting the right answer above all else.**

Offline

**NakulG****Member**- Registered: 2014-09-02
- Posts: 186

i am using openoffice.org spreadsheet program....

Offline