Golden Ratio <=> Volume Calculator

Seyeklopz

Member
2010-10-22 10:57 am
Wasn't sure where to post this spreadsheet tool for calculating golden ratio and volume.

View attachment golden ratio.zip

Enter value in yellow field and it calculates white fields.

grvc.png
 
The image looks good. The Zip didn't keep the package togther thou (so is a useless mess). You should save out as a pre-xml Excel file so that it is more compatiable

Excel sucks as a spreadsheet (a good example of how world dominance stifles innovation). It should be possible to put it on 1 visible line (but would likely require some temporary cells elsewhere)

dave
 

Seyeklopz

Member
2010-10-22 10:57 am
Gee, thanks Mister! :happy2:

Formulas I used are a little different.. Columns B-E, Rows 3-6

B3 [=E3^(1/3)/D2], C3 [=E3^(1/3)], D3 [=E3^(1/3)*D2], E3 [Blank-Enter Volume]
B4 [=D4/D2/D2], C4 [=D4/D2], D4 [Blank-Enter Height], E4 [=B4*C4*D4]
B5 [=C5/D2], C5 [Blank-Enter Length], D5 [=C5*D2], E5 [=B5*C5*D5]
B6 [Blank-Enter Width], C6 [=B6*D2], D6 [=C6*D2], E6 [=B6*C6*D6]
 
Last edited: