Stu does it again: New Revised Release Dynamic Spine Calculator

[metsastaja]

The Question  Posted 1/7/2011
I have used the calculator to determine arrow selection for a number of bows. I noticed the data library tab at the bottom and thought that would be a great place to store everything as opposed to saving multiple versions of the calculator with the data entered. I was just wondering if there was an easy way to transport data from the calculator to the data library area without completely re-typing it there.

The answer Posted 1/7/2011 six hours later

Hello Guys,
I think I have worked up a decent solution to the issue of getting your data easily into the library page. I added a "header" line to the data library page that is automatically filled out with as much detail as possible of your setup that has been entered in the main calculator page. You can now simply copy and paste that data into any of the archived rows below the header....this info then stays put and becomes your historical data. The added bonus is that I have made it so the AMO deflection and spine as well as the shaft diameter now shows in the header line for any shaft selected. This was a previous request from someone who mentioned that fining this information on all the various shafts is sometimes difficult. Now you can see all the data at will!
Les is testing it out now and if he gives it a thumbs up then it will be released on the website very soon.

The Results is 2011 Dynamic Spine Calculator Rev 12-25-10 v1 (2).xls
I tested the program on Mac excel, and Open Office and Microsoft Excel on Windows 7.  It works well in all.

You cannot do a line copy paste the first cell is protected. You may need to play with paste options.

1.   Microsoft Excel Users You will need to click on Make Type “shift key” and click on Dynamic Spine Required. This will highlight all the cells in the row. Right click to bring up copy function and copy.  Scroll back to the cell under Make Type on the line you want to copy the information to.  Use Paste Options and select values.

2.   Open Office Users You will need to click on Make Type “shift key” and click on Dynamic Spine Required. This will highlight all the cells in the row. Right click to bring up copy function and copy.  Scroll back to the cell under Make Type on the line you want to copy the information to.  Use Paste Special and make sure that only text and numbers is checked.

3.   MAC Excel Users You will need to click on Make Type “shift key” and click on Dynamic Spine Required. This will highlight all the cells in the row. Right click to bring up copy function and copy.  Scroll back to the cell under Make Type on the line you want to copy the information to.  Use Paste Options and select values.

You can down load the new revised version at
   Dynamic Spine Calculator 12-25-2010 V1

[Green]

Something great gets even better!  My Thanks go out to both of you for enhancing and bringing us this spreadsheet.

[Night Wing]

Stu's calculator keeps getting better and better. Just when I think it can't any better, it does. Thank you.    

[SveinD]

Amazing! A genuine thank you and a "cheers" goes to Stu!

[Friend]

Both useable and valueable improvement! Thank you.

[Green]

Les - having trouble getting this function to work with MS Excel and Windows XP...PM sent.
Thanks

[metsastaja]

i will keep eyes open nothing yet.

Sent reply hope it helps.  Keep me in the loop please

[snag]

           

[Green]

FYI - Was having trouble getting the new function to work.  Les had me download open office, then started a new spreadsheet for one of my bows and everything works like a charm.  It only took 4 or 5 emails with Les to get to the root of the problem...my 2003 version of Office.

Thanks again Les and Stu!

[Lone Ranger]

I am totally confused- my comp isn't wanting to work I guess. I DL'd the chart, and I have put in as much info as I know and the calc isn't blowing anything in for me.

L.R.

[Killdeer]

Huh?   :confused:  

I'm using a MAC, and had to get Open Office to use the spreadsheet. I don't think anybody can help you if they don't know what computer and operating system/application you are using.

Killdeer