Golden Ratio <=> Volume Calculator - diyAudio
 Golden Ratio <=> Volume Calculator
 User Name Stay logged in? Password
 Home Forums Rules Articles diyAudio Store Gallery Wiki Blogs Register Donations FAQ Calendar Search Today's Posts Mark Forums Read Search

 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
 9th November 2010, 05:02 PM #1 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
 9th November 2010, 10:36 PM #2 diyAudio Member   Join Date: Oct 2010 Crap, my gf messed up the spreadsheet, fixing it.
 10th November 2010, 12:57 AM #3 diyAudio Member   Join Date: Oct 2010 Corrected file. golden ratio.zip
 10th November 2010, 03:22 AM #4 frugal-phile(tm) diyAudio Moderator     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
 15th November 2010, 06: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 06:54 PM.
 15th November 2010, 07:20 PM #6 frugal-phile(tm) diyAudio Moderator     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
 15th November 2010, 07: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 08:04 PM.
frugal-phile(tm)
diyAudio Moderator

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
 golden-ratio.xls.zip (7.2 KB, 79 views)
__________________
community sites t-linespeakers.org, frugal-horn.com, frugal-phile.com ........ commercial site planet10-HiFi
p10-hifi forum here at diyA

 15th November 2010, 10: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 10:25 PM.

 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 OffTrackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post bogdan_borko Solid State 23 24th January 2011 10:31 AM presscot Multi-Way 2 28th July 2010 12:20 AM rick57 Everything Else 0 4th May 2007 04:03 PM ultrachrome Instruments and Amps 3 2nd November 2005 03:56 AM icebear Multi-Way 5 17th April 2004 08:40 PM

 New To Site? Need Help?

All times are GMT. The time now is 07:27 AM.

 Home - Contact Us - Advertise - Rules - diyAudio Store - Sponsors - Archive - Privacy Statement - Terms of Service - Top - Opt-out policy

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