Jump to content

[yet another] MegaTree Calculator!

Recommended Posts

Hi All,

Ok, so I know there are a few of these floating around. For my own use I was looking for two things:

1. I bought my minis for my tree, I know the lighted length, what should be the height and diameter of the tree? I found calculators that will calculate height based on string length and diameter. I found calculators that would calculate diameter based on string length and height.

My calculator requires that you only input the lighted length. It then calculates the height and diameter based on the accepted standard that the diameter is 1/2 the height.

2. I wanted to be able to play around with various tree sizes without having to write down numbers or load different pages.

So I made 4 different calculators that operate independently and fit on my screen without having to scroll.

For example, if I enter a lighted length of 12', it calculates a recommended height of 10.73' and a diameter of 5.37'. Well, maybe I really wanted a 12' tree, so I can go to the next calculator and enter 12' height and 12' lighted length to see what the diameter is (without losing the recommended values in the first calculator).

It will also calculate circumference in each case, so maybe the circumference comes out to 21', but hey 20' is so much easier. Proceed to the next calculator and enter 20 in the circumference box. Again, your previousl numbers are retained in the other calculators.

Anyway, it was useful for my own situation, and I hope it can help you too. It is an Excel spreadsheet. My brain hurts from figuring out the algebra for the recommended height and width :)

20091204 MegaTree Calculator.zip

Edited by Mr.Tim
had to zip xls
Link to post
Share on other sites
  • 2 weeks later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...