Thanks: 0
Likes: 0
Needs Pictures: 0
Picture(s) thanks: 0
Results 1 to 15 of 74
Thread: Golden Rule Worksheet
-
19th November 2007, 10:50 PM #1
Golden Rule Worksheet
I've attached a Golden Rule Worksheet for box calculations.
Here's the story:
Once a month, I sit at a market stall flogging the boxes I make.....some good months .....some bad months.
I made two boxes last month using the Golden Rule.........both went in the first hour.
So this month all the boxes made will be using the Golden Rule, just to test the theory, that it is the most pleasing shape.
I'll post pics of the finished boxes later in the week.
In the past, I've used a calculator to work out the ratio, but took the leap into a simple Excel worksheet.
The ratio I've used is:
Width = 1
Depth = .62
Length = 1.62
There are three calculators in the worksheet, depending on what dimension stock you have, or what size you have to fit.
If you have the depth known enter the depth at B3
If you have the width known enter the width at B7
If you have the length known enter the length at B9
The other dimensions are supplied in the same rows, and need to be rounded up.
Comments are gratefully accepted.
-
19th November 2007 10:50 PM # ADSGoogle Adsense Advertisement
- Join Date
- Always
- Location
- Advertising world
- Age
- 2010
- Posts
- Many
-
19th November 2007, 11:06 PM #2
Beauty Noel, thanks for sharing.
Cliff.
If you find a post of mine that is missing a pic that you'd like to see, let me know & I'll see if I can find a copy.
-
20th November 2007, 07:25 AM #3Awaiting Email Confirmation
- Join Date
- Jan 2007
- Location
- Goulburn NSW
- Age
- 89
- Posts
- 913
Thanks for the info... if the customers choose the boxes made to the golden rule there must be something in it.. looking forward to seeing the new boxes
les
-
20th November 2007, 07:29 AM #4
My thanks as well.
However with the weather conditions we have up here I wont be in the shed for a while.woody U.K.
"Common looking people are the best in the world: that is the reason the Lord makes so many of them." ~ Abraham Lincoln
-
20th November 2007, 08:00 AM #5
Thanks for sharing Noel
Cheers,
Howdya
Proudly supporting research into the therapeutic benefits of the Friday Thread
-
20th November 2007, 09:08 AM #6
Thanks Noel
A few thousand years of architectural and art history with the beauty of the golden ratio obviously can't be too wrong.
Des
-
20th November 2007, 09:16 AM #7
Looks good Noel, thanks.
I have a question about rounding, you say "need to be rounded up".
OK, I enter 2 for the Depth, I get 3.2258 for the Width and 5.2258 for the Length. To how many (or few) decimal places do you round up, or do you round up to the next integer?
-
20th November 2007, 10:14 AM #8
Thanks Noel, I am going to measure all my boxes now and see which ones are close to test the theory in terms of appeal.
Well done.
Regards
-
20th November 2007, 01:46 PM #9
Thanks Fred,
For inches I would try for two decimal places. so you could guesstimate a 1/4" plus a little, and for metric I'd correct to the nearest millimetre integer, as my eyes aren't that good any more.
When I get better at Excel I'll find the automatic rounder-upperer.Last edited by watson; 20th November 2007 at 01:54 PM. Reason: Messed up the quote - deleted quote
-
20th November 2007, 02:04 PM #10
My version of the Golden Rule worksheet
Firstly thanks to Watson for putting this worksheet up.
I've been having a bit of a play with it and... well, here is my version.
I've changed the format a bit, so no matter which value you want to calculate, the columns are the same. And I added a box where you can change the number of decimal places.
All cells are protected except the 4 white cells. You can select a calculated field (so you can paste it into another document for instance), but can't accidently delete the formula.
If you want to have a play with it, the password is my id - switt775. Just be aware that once you have un-protected it, you can accidently wipe out a formula
Hope some of you find this useful. And again thanks to Watson for getting the ball rolling.
-
20th November 2007, 02:38 PM #11
-
20th November 2007, 02:43 PM #12
There is just too many excel freaks on this forum. Beat me to it switt. I like your version and thanks to Noel for thinking of it.
-
20th November 2007, 02:47 PM #13
Love the changes
I'd better do some study and get up to speed on Excel.
Thanks again
-
20th November 2007, 02:54 PM #14
Yeah, far too many, just sent you a similar change using the round(result, decimal places), but too late she cried!
-
20th November 2007, 02:58 PM #15
Similar Threads
-
Seeking the Golden Ratio
By labolle in forum BOX MAKINGReplies: 17Last Post: 1st December 2007, 12:22 AM -
Help with info on these old Planes? Golden Lane?
By Lane in forum HAND TOOLS - UNPOWEREDReplies: 5Last Post: 28th April 2006, 10:03 AM -
FWW Steel Rule Arc Jig
By MajorPanic in forum WOODWORK PICSReplies: 2Last Post: 29th December 2004, 09:36 PM -
The golden rule
By Eastie in forum WOODWORK - GENERALReplies: 9Last Post: 3rd November 2002, 08:54 PM