Golden Ratio <=> Volume Calculator - diyAudio
Go Back   Home > Forums > Design & Build > Software Tools

Software Tools SPICE, PCB CAD, speaker design and measurement software, calculators

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
Reply
 
Thread Tools Search this Thread
Old 9th November 2010, 06:02 PM   #1
diyAudio Member
 
Join Date: Oct 2010
Default 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
  Reply With Quote
Old 9th November 2010, 11:36 PM   #2
diyAudio Member
 
Join Date: Oct 2010
Crap, my gf messed up the spreadsheet, fixing it.
  Reply With Quote
Old 10th November 2010, 01:57 AM   #3
diyAudio Member
 
Join Date: Oct 2010
Corrected file.

golden ratio.zip
  Reply With Quote
Old 10th November 2010, 04:22 AM   #4
frugal-phile(tm)
diyAudio Moderator
 
planet10's Avatar
 
Join Date: Oct 2001
Location: Victoria, BC, NA, Sol III
Blog Entries: 5
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, frugal-phile.com ........ commercial site planet10-HiFi
p10-hifi forum here at diyA
  Reply With Quote
Old 15th November 2010, 07:47 PM   #5
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 07:54 PM.
  Reply With Quote
Old 15th November 2010, 08:20 PM   #6
frugal-phile(tm)
diyAudio Moderator
 
planet10's Avatar
 
Join Date: Oct 2001
Location: Victoria, BC, NA, Sol III
Blog Entries: 5
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, frugal-phile.com ........ commercial site planet10-HiFi
p10-hifi forum here at diyA
  Reply With Quote
Old 15th November 2010, 08:55 PM   #7
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 09:04 PM.
  Reply With Quote
Old 15th November 2010, 09:49 PM   #8
frugal-phile(tm)
diyAudio Moderator
 
planet10's Avatar
 
Join Date: Oct 2001
Location: Victoria, BC, NA, Sol III
Blog Entries: 5
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
Attached Files
File Type: zip golden-ratio.xls.zip (7.2 KB, 71 views)
__________________
community sites t-linespeakers.org, frugal-horn.com, frugal-phile.com ........ commercial site planet10-HiFi
p10-hifi forum here at diyA
  Reply With Quote
Old 15th November 2010, 11:04 PM   #9
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 [=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 by Seyeklopz; 15th November 2010 at 11:25 PM.
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


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


New To Site? Need Help?

All times are GMT. The time now is 02:23 PM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright 1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2