Golden Ratio <=> Volume Calculator

[Seyeklopz]

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.

 

[Seyeklopz]

Crap, my gf messed up the spreadsheet, fixing it.

 

[Seyeklopz]

Corrected file.

View attachment golden ratio.zip

 

[planet10]

From just the screenshot, you'd be better/more elegant to set your constants across the top to 0.618, 1, 1.618, 1. (ie 1/GR, 1, GR, V=1)

Since most boxes start with volume then dimensions = (cube root V)/GR, (cube root V), (cube root V)*GR.

dave

 

[Seyeklopz]

How's that then? Wish I could figure out how to do it in one line.



View attachment golden ratio.zip

 

[planet10]

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]

Might be because I'm using Open Office. Tried saving it as xls 'Excel 2003' this time.

View attachment golden ratio.zip

Edit. OK, maybe 7zip is at fault here. Corrupting its archives

I checked the earlier files I uploaded, they are not corrupt. Its a problem with the open office calc / m$ office excel format conversion.

 

[planet10]

Just double clicking it opens it in Illustrator as a text file. When i opened it in Excel (2004) all the formulas were gone.

I redid it for you, here saved as Excel 2004 WorkBook. If anyone needs older format ask

dave

 

[Seyeklopz]

Gee, thanks Mister!

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]