PDA

View Full Version : looking for spiral tree video



ben&bobbi
01-13-2010, 11:46 PM
sorry, i didn't know which section to post. a few nights ago, i found a thread with a link to a spiral mega tree, but for the past few nights of searching, i can't find it again.

it was pretty tall looking and had a shorter and much wider tree, the wider tree "beams" would sweep and at the ends, was a mini tree that lit.

i tried searching, but still can't find it.
Ben

cbell
01-13-2010, 11:49 PM
This?

http://www.youtube.com/user/theweber300#p/u/9/pKL9gVZurCc

Edit:
Here is his home page with some info on it.
http://weberchristmas.snappages.com/

ben&bobbi
01-14-2010, 12:25 AM
This?

http://www.youtube.com/user/theweber300#p/u/9/pKL9gVZurCc

Edit:
Here is his home page with some info on it.
http://weberchristmas.snappages.com/

Yes - that is it! thank you!

kwdelre
01-14-2010, 12:44 AM
This?

http://www.youtube.com/user/theweber300#p/u/9/pKL9gVZurCc

Edit:
Here is his home page with some info on it.
http://weberchristmas.snappages.com/

Ummmmm....I want

olingerjccj
01-14-2010, 01:20 AM
I am also going to attempt to build this one too 32ft more like 15 or 12 one color 12 channels. Just trying to calculate it all.

John

manrmark
01-14-2010, 01:57 AM
I don't want to take away from DIYC but somebody on Planet Christmas forum has made a calculator for the weber tree.

olingerjccj
01-14-2010, 02:25 AM
I don't want to take away from DIYC but somebody on Planet Christmas forum has made a calculator for the weber tree.

A calculator or just a diagram?

John

smartalec
01-14-2010, 11:57 AM
http://forums.planetchristmas.com/showthread.php?t=39539
is the link you might be looking for

olingerjccj
01-14-2010, 12:32 PM
I think I need to set up a mock tree in my back yard. With the string in a kinda s pattern there are a bunch of variables + I need to find a copy of excel. I formated one of my computers last week and cannot find my copy of excel. I have some time to mess with it.

John

Capt'n Jack
01-14-2010, 09:05 PM
http://forums.planetchristmas.com/showthread.php?t=39539
is the link you might be looking for

Does anyone here have this guy's spiral tree spreadsheet? I am not a member at Planet Christmas and cannot access it.

folksy
01-14-2010, 10:06 PM
Well I think I have attached the SS.

Please note I did not create this SS I just uploaded it here from

http://forums.planetchristmas.com/sh...ad.php?t=39539

Capt'n Jack
01-15-2010, 10:43 AM
Thanks matey, that be the one. And where might Camden NC be?

manrmark
01-15-2010, 11:02 AM
A calculator or just a diagram?

John

I think it's a Excell spreadsheet/calculator with digrams.

Enter your info how tall, wide ect. and it does the rest.
It's a very help full

Mark

folksy
01-18-2010, 02:43 PM
Camden NC is close to Elizabeth City NC, 45 west of the Kitty Hawk and about 1 hour south of Virginia Beach. So North-eastern NC.

ben&bobbi
01-26-2010, 01:52 PM
I have started laying out the yard, and here is my spiral tree. I used the spreadsheet to get started, but it is estimate only, so here is what i came up with.

Lighted area is 15' tall, 7' base, 1.6 turns (will have to check real lighted length of light string - assuming 25'), 16 strings of lights - 16 channels, sparkle ball for topper (not sure how many colors).

Planning to use an old basketball pole, extended with PVC. 16 guy wires to hold pole and support light strings. turnbuckles to keep tension. I still need to find anchors. first thought was spiral stakes like the inflatables use, but i can't find them for sale.

http://www.doityourselfchristmas.com/forums/picture.php?albumid=135&pictureid=665

kychristmas
01-26-2010, 02:05 PM
Very cool.

Harbor Freight has those Stakes for around $4 in the Pet Area. I bought a few of them this year for my Mega Tree support wires.

ben&bobbi
01-26-2010, 02:17 PM
Looking for a cheaper way, with needing 16 of them! maybe i only need a few of those as the main supports, then use regular tent stakes through the end of the turnbuckles for the rest.

kychristmas
01-26-2010, 02:30 PM
Looking for a cheaper way, with needing 16 of them! maybe i only need a few of those as the main supports, then use regular tent stakes through the end of the turnbuckles for the rest.

Then I would look at making stakes out of the PVC Conduit. I had a ton of scraps left from my arches and I cut them into 18-24" lengths. I used a number techniques depending on requirement.

If I were you, I would look at building a simple frame at the bottom as many of us do. Mine was simpler than most here and it worked great. I just finsihed taking it down and it was as solid as when I put it up in November.

My tree was 8ft at the base and 13ft for the light section. The cost of my Megatree was far less than $60 with the framework being around $25. I did make a mistake and leave the cost of my support stakes from my cost. Those were around $16. So I guess with lights, the cost of my tree was around $60

Here's a link to a post where I showed it:
http://doityourselfchristmas.com/forums/showthread.php?t=9645&highlight=megatree

ben&bobbi
04-06-2010, 07:32 AM
i think i have this thing worked out.

http://doityourselfchristmas.com/forums/picture.php?albumid=135&pictureid=756

Center pole -
I have an old 11' basketball post, using a 3" PVC union, i will add the additional 62" 3" PVC to get 15' of lighted tree.

The base -
1' tall PVC that will come apart to store.

LIght supports -
16 1/8" wire rope light string supports, running to top of the PVC extension.

4 1/8" guy wires attached to the top of the basketball pole.

Most of the piece parts have been delivered, and hope to start building it soon. Hardest part was trying to figure out how to store this thing! Now i have to figure out how to get the light strings to the top to spiral them down!

http://doityourselfchristmas.com/forums/picture.php?albumid=135&pictureid=757

run off 16 channels, 4 more used to sparkle ball topper. rest of the REN24SS will be for strobe lights once i figure them out.

Wayne J
04-06-2010, 06:46 PM
Looks good! What is you plan to attach the turnbuckles to the bottom ring?

Braveit1
04-06-2010, 07:00 PM
Does anyone here have this guy's spiral tree spreadsheet? I am not a member at Planet Christmas and cannot access it.

Don't need to be a member. Just click the first link.
http://www.lightsonsixth.com/stuff/spiraltreespreadsheet-97.xls

DIY Guy
04-06-2010, 07:37 PM
Amazing.. Also appears the spiral tree is all multis.. it looks awesome. Sequencing is spot on as well.. truly a masterpiece.

Skunberg
04-07-2010, 01:44 PM
ben&bobbi Your tree idea looks great! In the drawing it looks like three turns and in another post you said one and a half turns. Did it change for some reason?

ben&bobbi
04-08-2010, 12:36 PM
ben&bobbi Your tree idea looks great! In the drawing it looks like three turns and in another post you said one and a half turns. Did it change for some reason?

must be an illusion - but i had to check. My model file (pictures) is actually 1.6 turns, but i will make it layout at 1.5 turns and not have the little hook at the top. see top view below. When i measure the curve, i get 25' (300.4"), i think the light strings are 24.?' so i may have to cheat a little more.

http://doityourselfchristmas.com/forums/picture.php?albumid=135&pictureid=758


Looks good! What is you plan to attach the turnbuckles to the bottom ring?

right now i plan to drill a hole in the PVC and use a zip tie - until i think of a better way, not much more costly. Any suggestions?



I plan to attach the PVC frame to the 4 guide wires to help hold the shape.
Also planning to add a ring of the white really flexible CPVC higher up, and attach the wire rope. i am thinking this will allow me to take it down and keep wire rope spaced for reassembly next year.

Final is to figure out how to attach the 4 color sparkle ball to the top.

stanward
04-09-2010, 04:48 AM
What is this "4 color sparkle ball" you refer to?

ben&bobbi
04-10-2010, 08:00 PM
What is this "4 color sparkle ball" you refer to?

http://www.instructables.com/id/no_melt_Sparkleball/

not sure what cups they used, but i found clear flexible 9oz at Sams. i was not able to punch out more the 20 cups before my hand got sore. Guy at worked teased me until he tried it! i ended up drilling them on the drill press.

for the tree topper, i switched to a much softer "cloudy" 8oz cup. i was able to punch the sides by hand, but had to be carefull drilling the bottoms - very soft for a drill. I ended up with 50 cups on each side, and 4 colors per cup. The colors don't blend as nice as i thought they would, but maybe they will look better on in the dark.

bobbert
06-17-2010, 02:32 PM
If my math serves me right here how to calculate the length of a line around a conical spiral.

Add together the greater and lesser diameters; divide their sum by 2 and multiply the quotient by Pii (3.1416). To get the square of the product of this circumference and the number of revolutions of the spiral add the square of the height of its axis and take the square root of the sum.

SQRT( p * n* ((d+d')/2)^2+h^2)

ben&bobbi
06-17-2010, 02:52 PM
If my math serves me right here how to calculate the length of a line around a conical spiral.

Add together the greater and lesser diameters; divide their sum by 2 and multiply the quotient by Pii (3.1416). To get the square of the product of this circumference and the number of revolutions of the spiral add the square of the height of its axis and take the square root of the sum.

SQRT( p * n* ((d+d')/2)^2+h^2)

Welcome to DIYC, or at least your first posting!

I worked mine on with the cad program. several people have used to excel spreadsheet and seems to get close enough. I am sure the actual equation is in the excel form.

dirknerkle
06-17-2010, 02:57 PM
To get the square of the product of this circumference and the number of revolutions of the spiral add the square of the height of its axis and take the square root of the sum.


...and a partridge in a pear tree.....


Wow, I'm impressed. It sure is nice to have smart people here! Welcome to DIYC!

Aproct
06-17-2010, 03:00 PM
Okay, I built one last Thursday for the NJ Mini...yes I built it in one day...My tree has 84 strands of lights, 28 strands of Red, Blue and Green lights. I will tell you this from my experience, don't over think it...I pre made 16 1/16 cable strands that come down from my header to the gray pvc conduit on the ground that formed the ring at the bottom. The biggest issue that I discovered was how to keep the pvc ring tight to the ground to make the cables tight. This is why Scott Weber used anchors that went into the ground so he wouldn't worry about the cables becoming loose. To give you an idea, my tree is 18 1/2 feet tall without the star on top. The diameter of ring is 8 feet across. With this measurement I was able to take a string of 100 bulb strand and wrap to just shy of 1 1/2 revolutions. I wrapped all one color first and made sure my spacing was correct. This way I could just drop the other two colors into the voids of the first color strands...Honestly the wrapping of the tree took me 6 hours. So make sure you have enough time...Oh by the way I did it myself...no help.

christmas-light
06-17-2010, 03:16 PM
okay, i built one last thursday for the nj mini...yes i built it in one day...my tree has 84 strands of lights, 28 strands of red, blue and green lights. I will tell you this from my experience, don't over think it...i pre made 16 1/16 cable strands that come down from my header to the gray pvc conduit on the ground that formed the ring at the bottom. The biggest issue that i discovered was how to keep the pvc ring tight to the ground to make the cables tight. This is why scott weber used anchors that went into the ground so he wouldn't worry about the cables becoming loose. To give you an idea, my tree is 18 1/2 feet tall without the star on top. The diameter of ring is 8 feet across. With this measurement i was able to take a string of 100 bulb strand and wrap to just shy of 1 1/2 revolutions. I wrapped all one color first and made sure my spacing was correct. This way i could just drop the other two colors into the voids of the first color strands...honestly the wrapping of the tree took me 6 hours. So make sure you have enough time...oh by the way i did it myself...no help.

WE NEED A VIDEO OF IT !!! :D !!! :d

bobkeyes
06-17-2010, 05:05 PM
Did you have a bucket truck?

Superfreak3
06-18-2010, 04:41 PM
This looks way cool!

I wonder how much it would cost to build a conical frame of maybe 10-12 feet entirely of pvc. In other words just wrap the lights around a pvc frame. I guess maybe the 10 foot spanning of the 16 or so supports wouldn't stand up to the wind. A central pole would be needed.

My thinking is to make something that is easy to dismantle/re-assemble.

Superfreak3
06-18-2010, 04:41 PM
This looks way cool!

I wonder how much it would cost to build a conical frame of maybe 10-12 feet entirely of pvc. In other words just wrap the lights around a pvc frame. I guess maybe the 10 foot spanning of the 16 or so supports wouldn't stand up to the wind. A central pole would be needed.

My thinking is to make something that is easy to dismantle/re-assemble.

Superfreak3
06-18-2010, 04:43 PM
This looks way cool!

I wonder how much it would cost to build a conical frame of maybe 10-12 feet entirely of pvc. In other words just wrap the lights around a pvc frame. I guess maybe the 10 foot spanning of the 16 or so supports wouldn't stand up to the wind. A central pole would be needed.

My thinking is to make something that is easy to dismantle/re-assemble.

Oh, by the way, the diagrams and instructions would make a great wiki topic.

Superfreak3
06-18-2010, 07:43 PM
No idea why my last post posted 3 times. I guess I really wanted to get me point across!! :-P

Skunberg
06-22-2010, 07:32 PM
I thought maybe you were working on your post count ;-)

Superfreak3
06-29-2010, 02:11 PM
I have to slow that video down to see if it helps me with sequencing ideas.

I wish there was some software out there where you could mock up a spiral tree with some ability to see the thing in motion. I don't know if one could do that with a CAD app or not.

I don't know if I should go with a two color tree (8 channels per) or bump to a three color tree at 6 channels per.

Keebler
11-23-2010, 08:57 PM
i think i have this thing worked out.

http://doityourselfchristmas.com/forums/picture.php?albumid=135&pictureid=756

Center pole -
I have an old 11' basketball post, using a 3" PVC union, i will add the additional 62" 3" PVC to get 15' of lighted tree.

The base -
1' tall PVC that will come apart to store.

LIght supports -
16 1/8" wire rope light string supports, running to top of the PVC extension.

4 1/8" guy wires attached to the top of the basketball pole.

Most of the piece parts have been delivered, and hope to start building it soon. Hardest part was trying to figure out how to store this thing! Now i have to figure out how to get the light strings to the top to spiral them down!

http://doityourselfchristmas.com/forums/picture.php?albumid=135&pictureid=757

run off 16 channels, 4 more used to sparkle ball topper. rest of the REN24SS will be for strobe lights once i figure them out.

do you have a program that will calculate this. i like this graphic, is there a program that creates this? more specifically the spacing between each line coming down the guy lines?

thank you

ben&bobbi
11-24-2010, 11:36 AM
don't tell my boss! i use a CAD program here at work to lay it out.

It took me 2 full days (by myself) to build and redesign the structure. Including 4 hrs to figure out how to wrap the lights, then 30 minutes to do it the easy way!

easy way - had all lights attached at the top. Pulled half to one side, half to the other. I took 1 strand and went round and round the mulberry pole, then the next, etc. This weekend i will measure over and up and add zip ties to space them better. right now they are sagging and slipping.

hard way - line each strand up with the support wire, and move them one position at a time. this pulled the top of the tree so tight (too much weight at top) that it pulled tight to the pole.

take down - not sure how this will work - time will tell, right now i need to finish it up!

what didn't work - the PVC frame would NOT hold the support wires tight. I had to add anchors from the top ring to the ground. The PVC union could use a little reinforcement. Support wires need to be tight to hold shape out. I am not sure how the Weber's tree worked using polyrope, i can't find their pictures.

kychristmas
11-24-2010, 11:43 AM
Pictures! We need Pictures and Video!

Keebler
11-24-2010, 02:37 PM
don't tell my boss! i use a CAD program here at work to lay it out.

It took me 2 full days (by myself) to build and redesign the structure. Including 4 hrs to figure out how to wrap the lights, then 30 minutes to do it the easy way!

easy way - had all lights attached at the top. Pulled half to one side, half to the other. I took 1 strand and went round and round the mulberry pole, then the next, etc. This weekend i will measure over and up and add zip ties to space them better. right now they are sagging and slipping.

hard way - line each strand up with the support wire, and move them one position at a time. this pulled the top of the tree so tight (too much weight at top) that it pulled tight to the pole.

take down - not sure how this will work - time will tell, right now i need to finish it up!

what didn't work - the PVC frame would NOT hold the support wires tight. I had to add anchors from the top ring to the ground. The PVC union could use a little reinforcement. Support wires need to be tight to hold shape out. I am not sure how the Weber's tree worked using polyrope, i can't find their pictures.

i copied your pictures.. and they are GREAT!!! thank you for posting them!

i will post my results and pics as they come availalble.

Keebler
11-24-2010, 07:31 PM
GOOD NEWS!!!
the new plans are a success!!!
i have got exactly half the mega tree up :)
thank you ben&bobbi (http://doityourselfchristmas.com/forums/member.php?u=5152) !!!!


pics to follow soon...
i added a bit of information to my process, but it works great and went up quick

i made 16 ropes (cheap crap at walmart >$3). i picked it because its waterproof and strength to 25lbs. heck sounds good to me!
each of the stakes i numbered 1-16

then took and went to the tree calculator and found that the string spacing was 8 1/2". so i took an old paint stirrer and marked 8 1/2" on the stirrer. went down the string and marked the WHOLE string at 8 1/2 all the way down. separated the bunch of strings in half at the top and secured them to the top with a couple of zip ties.

then started my spiral string 1 ended at stake 10, string 2 ended at stake 11 and so on.
i used black vinyl tape to secure the strings at each of the marks on the nylon string.
IT LOOKS GREAT!!!!
i am so thrilled!

ben&bobbi
11-25-2010, 10:27 PM
sounds great, waiting on pics.

i need to attach mine to the cables, they are really sagging today! i need to finish the rest of the setup. Found out my laptop (WAY OLD) is not enough to play the show, so trying to find plan B!

Keebler
11-26-2010, 11:05 PM
here are some fresh vids.
my spiral tree is up and running.

this is a video of the megatree from the street.
http://vimeo.com/17229406

this is a close up
http://vimeo.com/17229592


please tell me what ya think.

i am just running a test program for now... not my show

ben&bobbi
11-26-2010, 11:15 PM
looks really good, i may have to reverse engineer some of those patterns! that test sequence available to share?

the lights look much fuller than mine. i will take a pic tomorrow. what type & how many strands did you use? I tried the 25 C9 strands. I have yet to see it run except very choppy

Keebler
11-26-2010, 11:42 PM
sure, i will post it...

keep in mind that i am using several ren24ss boards.. including two in my mega tree....

--pm me for file please--

if you have any questions/.. let me know...

i have been running test patters all night....

i am using 16 strands of 100 count LED multi
16 strands of 100 count clear incad bulbs
for a total (SEEN) of 32 channels.

there are two more sets of lights that are not installed yet...

5 strings of strobes and 16 strands of 100 count clear that will run vertically.

tonypgst
11-27-2010, 12:17 AM
Looking good. I finished my setup and tested the last few nights. Launch tomorrow then I'll take video and share my spiral tree. It doesn't necessarily have the wow factor I expected, but puts a new "twist" on things.

Keebler
11-27-2010, 07:12 AM
i didnt think mine had the wow factor, but my neighbors and the people that have seen this first hand say it is very impressive...
i thank them for their kind words
lol

dirknerkle
11-27-2010, 10:19 AM
Very, Very nice work! The megatree is definitely eye-catching and mezmerizing to watch!!! (pardon me while I wipe the drool off my keyboard...) ;)

Keebler
11-27-2010, 01:14 PM
thank you DN. my wife said the same thing.. the tree is hypnotizing. lol

thank you :)

ben&bobbi
11-29-2010, 08:47 AM
here's a link to another example

http://doityourselfchristmas.com/forums/showthread.php?t=13504

ben&bobbi
11-29-2010, 08:48 AM
Tried to uplaod last night, but site was pretty busy i guess - can't imagine why that is this time of year!

Here are a couple shots of ours.

http://i155.photobucket.com/albums/s289/ben-stang/christmas/DSC06947.jpg

http://i155.photobucket.com/albums/s289/ben-stang/christmas/DSC06948.jpg

ishane
11-30-2010, 01:53 PM
Here is a video of my tree this year. It is 40 channels. 20 for the green and 20 for the white. The tree is 15ft tall and I used the calculator to help plan the spiral. All in all, it has been a HUGE hit.

http://www.youtube.com/watch?v=mlS0DIPcQ4I

kychristmas
11-30-2010, 01:59 PM
What "Calculator" did you use? I have a Megatree calculator, but don't recall a Sprial feature. I would definitely love to add a Spiral to my Megatree. I had plans, but the trying to wrap it correctly was making my brain hurt.

ishane
11-30-2010, 02:12 PM
I used the excel spreadsheet that is posted earlier in this thread. It certainly helped get the project started.

kychristmas
11-30-2010, 02:31 PM
I used the excel spreadsheet that is posted earlier in this thread. It certainly helped get the project started.

Doh! Sorry

Superfreak3
11-30-2010, 03:41 PM
Here is a video of my tree this year. It is 40 channels. 20 for the green and 20 for the white. The tree is 15ft tall and I used the calculator to help plan the spiral. All in all, it has been a HUGE hit.

http://www.youtube.com/watch?v=mlS0DIPcQ4I

That looks awesome! I didn't do the spiral this year because I didn't have time to go out and get materials to create the "frame" or structure to wrap the spiral arrangement around. I never thought of using other colors (your green) as the supports. I was too wraped up in making every color spiral.

Like I said, it looks great and you've already given me good ideas for next year. What did you use to sequence, Vixen? If so, could you share at least the sequence for the video tune?

Man, I wish I would have seen this about a month ago!!

Next year I might use green and red as my base, structure colors and wrap that in white spirals. Oh, I guess I should just enjoy this year's display for a while.

ben&bobbi
12-16-2010, 08:28 AM
here are the videos to our display this year. I still have another song or 2 to get uploaded - didn't turn out too bad for a rookie. But special thanks to my co-worker Tim for making the snowflake wall and Merry Christmas sign - not to mention the boards he loaned me to run them!

http://vimeo.com/user5477571/videos

Mactayl
12-16-2010, 09:39 AM
Very nice, I like the Spiral Tree and Merry Christmas sign, btw who's version of Jingle Bell is that I haven't heard that one. Oh!! Happy Birthday. :):):)

Macrosill
12-16-2010, 10:44 AM
That version of Jingle Bells is from Basshunter.

Mactayl
12-16-2010, 10:46 AM
That version of Jingle Bells is from Basshunter.

Thanks Brian,

smoothice
12-29-2010, 03:03 AM
Here is a video of my tree this year. It is 40 channels. 20 for the green and 20 for the white. The tree is 15ft tall and I used the calculator to help plan the spiral. All in all, it has been a HUGE hit.

http://www.youtube.com/watch?v=mlS0DIPcQ4I

WOW. That is amazing.

dirknerkle
12-29-2010, 12:09 PM
Here is a video of my tree this year. It is 40 channels. 20 for the green and 20 for the white. The tree is 15ft tall and I used the calculator to help plan the spiral. All in all, it has been a HUGE hit.

http://www.youtube.com/watch?v=mlS0DIPcQ4I

Beautiful work! Not hard to see how that would turn heads! Very, very nice! What I also liked was the rest of your display, too. Tasteful, not overdone, balanced, colorful, well-crafted and nicely sequenced. Terrific display!!! :cool:

tweist
12-29-2010, 01:46 PM
Very impressive work. and I love the snow flakes on the roof.
The real question is, how long are your stands for the spiral part of your tree and how many times to you go around.

Oh and your sequencing is dead on. Great work.

ishane
01-03-2011, 12:04 AM
The length of the strands for both the green and white are 24ft. They are standard 100ct minis from Lowes. I wrap the spirals 1.5 times.

deanathpc
01-06-2011, 05:12 PM
The length of the strands for both the green and white are 24ft. They are standard 100ct minis from Lowes. I wrap the spirals 1.5 times.

You know the KISS method here... I have been trying to figure out three colors for both the spiral and the mega combined like yours but I love the all white for the spiral and green for the mega side of it. Simple. 2 colors and that's is. Unless you have more colors on there that we didn't see?

So what are the dimensions of your tree then?

Dean

ishane
01-07-2011, 11:20 PM
You know the KISS method here... I have been trying to figure out three colors for both the spiral and the mega combined like yours but I love the all white for the spiral and green for the mega side of it. Simple. 2 colors and that's is. Unless you have more colors on there that we didn't see?

So what are the dimensions of your tree then?

Dean


Dean,
You are dead on with the KISS method, and you are also correct about the colors on the tree. I use green for the mega tree and white for the spirals. The tree is 15ft tall (not including the star) and 7ft diam. If I change anything, I might add another color to the mega tree portion, but I will most likely stick with the single color for the spirals. Once the weather clears up here, I plan to take some photos during the take down to post.

ben&bobbi
01-20-2011, 09:37 PM
Very nice, I like the Spiral Tree and Merry Christmas sign, btw who's version of Jingle Bell is that I haven't heard that one. Oh!! Happy Birthday. :):):)

basshunter is correct, with a little poor editing! thank you for the birthday notice! i have been having trouble getting around on here since the upgrade!

smoothice
02-09-2011, 11:24 AM
So I finally got around to playing with the spiral tree calculator that I found in this thread. It was giving me some crazy numbers.

So I just wanted to warn others that may have downloaded the same incorrect calculator that I did.

To see if you have the incorrect one go to cell (i17) of the spreadsheet. The equation should look like this:

Right=.........=SQRT(4*(3.1415926535898^2)*((F7/4)^2)+(I16^2))

and should not look like this:

Wrong =......=SQRT(4*(3.1415926535898^2)*((F7/2)^2)+(I16^2))

That one simple error was giving me a light strand length difference of 14 feet!!!!

To see my crazy numbers and download the correct version you can look here ---http://doityourselfchristmas.com/forums/showthread.php?15007-Spiral-Mega-Tree-Advice-Needed!