Surely this has been done before, but I wanted to have an Excel formula that I could use to determine a new lamination stack (for a glass bow) to arrive at a different weight.
This is a simple formula, based on the idea that when you double the lamination stack the weight will increase 8 fold. Of course, as designs vary so will the effecitveness of this formula, but it should get you close.
Thought I would post as I am sure a few others can use this as well.
Try this link..
http://tradgang.com/noncgi/ultimatebb.php?ubb=get_topic;f=125;t=011875
Good information, better than the guess and miss system I am using. Thank you
what program do you open this up in, or use to view it.
Very nice, great idea.
Pretty cool Brad!!
Joe- it is a Microsoft Excel file, if you don't have Microsoft Office, you can download OpenOffice for free, it is an open-source software, and I use it instead of Microsoft Office.
Just search for OpenOffice online if you want to get it.
Mike
Nice, I checked it against some of the records in my note book I've kept over the last 6 years and it computes. Thanks. This will save me some time. I've been doing everything on paper with a calculator.
Brad - That's great.
Back in December I built my first r/d and it came in at 47# whan I wanted 55#. I upped my stack thickenss and glued up another last weekend. Well, that one ended up at 73# and I could hardly sting it. I did some figuring this past week given my two "experiments" and figured I needed 0.400 total stack. Your calculator came out with dang near the same total stack, so this is very reassuring. Too bad you didn't post this about a week and a half ago....
Good stuff Brad.
got it, this is neat, can't wait to start building again.
Good deal. I am glad it checks out with your statistics as well. It checked out to my longbow formulas quite well.
Thanks for the information, this will be very helpful.
-Jay
I'm gonna copy a link of this post and put in the thread stickied at the top titled newbie vocabulary and other useful info.
Stiks
Thanks Brad I will be using it.
Terry
Must just be me, but I can't get this to open with Excel. Could you save it as the older version too? I thought I had the newer one, but I've downloaded it four times and none of them will open for me.
Sure, I will post the old excel version too..check the first post again
That is cool stuff. I checked it with my one piece longbows and it is dead nuts! I am going to be using my old calculations along with this for a while and if all works you may start getting a Christmas card from me! Thanks.
I opened it with no problem using Open Office. As previously mentioned here. If you don't have Microsoft office or yours is out of date, you can download the office suite for free at http://www.openoffice.org/
I got it to work. Apparently Excel does not like to load stuff from the downloads folder. I moved the file to a folder in my documents, and it opened right up. :dunno:
I need some help. When I click on the link it opens up in Exel, but from there I cannot figure it out. Where I put the cursor it is usually an arrow , but now there is a cross and I don't know what to do. Will somebody take me through it? Thank you. Bue--.
When you open it up, there should be 3 colored cells, with numbers in them (C7,C8,C9). All you need to do is click the cells and input your numbers. The answer is automatic when you hit enter.
Works perfect!
Thanks.
Thanks Brad!
Has anyone developed a similar tool for all-wood laminated bows?
It should work exactly the same....same concept
Great stuff Brad.
Thanks very much!!! :thumbsup:
Ha, even Mr. big idiot, myself, got it to work. Thanks a lot. Bue--. :banghead:
Thanks Brad and after trying the program out I now understand your response!
I know that this is an old thread, but it is referenced in the stickie at the top of the page, so thought I'd post here.
The files seem to have 'disappeared'. I get error messages that the files are not available when clicked on. If anyone still has these files, I'd love to get a copy.
Thank you.
Gordon
Make that two of us who would like the calculator. The response I get for either of the links is:
NoSuchBucket
The specified bucket does not exist
images.imagelinky.com
ED3A4B530E4DF658
1gXvoiHNTT+PJTCcmgEGXV7/ZPDtZ3TS8gDM36R2/6N7EOvLRq0KAHkLWwzD3XHe
Unfortunetly, even I get the same message. I have tried a couple times to re-load the file but image linky simply doesnt work.
I am happy to send it to anyone if you send me an email, and better yet if anyone else knows how to re-post the link in another format I would be happy to send you the file or try it myself.
Thanks
Imagelinky is not working, it says upload error but gives a url anyway which does not work as we found out.
The following at file dropper works but who knows for how long. Enjoy.
XLXS VERSION (http://www.filedropper.com/lamstackcalculator-bjansen)
XLS (OLDER) VERSION (http://www.filedropper.com/lamstackcalculator-bjansen_1)
Best regards,
Pago
Perfect. It worked great. Thank you Pago.
Gordon
Thanks, but thank Brad Jansen. I received the file from him awhile back after requesting it.
Thanks Brad.
Thanx Pago and Brad both!
I must of missed it but what length bow is this set up for.This is awesome just what I was looking for. Thank-you
This is not for a specific length or style, but more of a tool if you had made one bow and want to build another (same model/style) but a different draw weight.
It works very well, I use all the time. Brad is due a big thanks for making it available.
The calculator has nothing to do with length or shape of a bow.
The idea is that if you build one bow of a given shape and stack thickness, and it comes out X pounds draw; if you double the stack thickness on a second bow of the same shape, the draw weight of the new bow will increase 8 fold.
The calculator works great -- it confirmed my S.W.A.G. when working the calculation backwards. A prototype Scythian replica I made was 'way out of my desired draw weight. I wanted 30# but got in excess of 75#.
I chose the lam stack for the Mark II prototype based on my Scientific Wild Ass Guess of that 'rule of thumb' backwards. I'll be doing the final glue up n the next few days so we'll see what draw weight I actually get.