Golden Ratio <=> Volume Calculator

Seyeklopz · 9th November 2010, 05:02 PM

Wasn't sure where to post this spreadsheet tool for calculating golden ratio and volume.

golden ratio.zip

Enter value in yellow field and it calculates white fields.

grvc.png

Seyeklopz · 9th November 2010, 10:36 PM

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

Seyeklopz · 10th November 2010, 12:57 AM

Corrected file.

golden ratio.zip

planet10 · 10th November 2010, 03:22 AM

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 · 06:54 PM

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

gldnr.png

golden ratio.zip

planet10 · 15th November 2010, 07:20 PM

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 · 08:04 PM

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

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 · 15th November 2010, 08:49 PM

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 · 10:25 PM

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]

9th November 2010, 05:02 PM	#1
Seyeklopz diyAudio Member Join Date: Oct 2010	Golden Ratio <=> Volume Calculator Wasn't sure where to post this spreadsheet tool for calculating golden ratio and volume. golden ratio.zip Enter value in yellow field and it calculates white fields. grvc.png

10th November 2010, 03:22 AM	#4
planet10 frugal-phile(tm) diyAudio Moderator Join Date: Oct 2001 Location: Victoria, BC, NA, Sol III Blog Entries: 4	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 __________________ community sites t-linespeakers.org, frugal-horn.com ........ commercial site planet10-HiFi p10-hifi forum here at diyA

15th November 2010, 06:47 PM	#5
Seyeklopz diyAudio Member Join Date: Oct 2010	How's that then? Wish I could figure out how to do it in one line. gldnr.png golden ratio.zip Last edited by Seyeklopz; 15th November 2010 at 06:54 PM.

15th November 2010, 07:20 PM	#6
planet10 frugal-phile(tm) diyAudio Moderator Join Date: Oct 2001 Location: Victoria, BC, NA, Sol III Blog Entries: 4	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 __________________ community sites t-linespeakers.org, frugal-horn.com ........ commercial site planet10-HiFi p10-hifi forum here at diyA

15th November 2010, 07:55 PM	#7
Seyeklopz diyAudio Member Join Date: Oct 2010	Might be because I'm using Open Office. Tried saving it as xls 'Excel 2003' this time. 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. Last edited by Seyeklopz; 15th November 2010 at 08:04 PM.


	Please consider donating to help us continue to serve you. Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving

9th November 2010, 10:36 PM	#2
Seyeklopz diyAudio Member Join Date: Oct 2010	Crap, my gf messed up the spreadsheet, fixing it.

10th November 2010, 12:57 AM	#3
Seyeklopz diyAudio Member Join Date: Oct 2010	Corrected file. golden ratio.zip

15th November 2010, 10:04 PM	#9
Seyeklopz diyAudio Member Join Date: Oct 2010	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 [=B4C4D4] B5 [=C5/D2], C5 [Blank-Enter Length], D5 [=C5D2], E5 [=B5C5D5] B6 [Blank-Enter Width], C6 [=B6D2], D6 [=C6D2], E6 [=B6C6D6] Last edited by Seyeklopz; 15th November 2010 at 10:25 PM.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Circuit Maker <<questions>>	bogdan_borko	Solid State	23	24th January 2011 10:31 AM
>>> Project Floorstanding Cabinet Wanted <<<	presscot	Multi-Way	2	28th July 2010 12:20 AM
> Audio <> music <> quick <> synergy <> angst>?	rick57	Everything Else	0	4th May 2007 04:03 PM
guitar<--->???<--->chipamp	ultrachrome	Instruments and Amps	3	2nd November 2005 03:56 AM
Golden ratio - Example?	icebear	Multi-Way	5	17th April 2004 08:40 PM

New To Site?	Need Help?
Register to Participate Search Privacy Statement Contact Us	Frequently Asked Questions Did you forget your password? Mark Forums Read