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