@Prarie Bowyer
Yeah I wish I could do clever stuff with excel. It took me long enough to plot 2 graphs on the same sheet .
The techical stuff is fun for those times when you can't can't play with the real wood .
That bow pistol is about 35-40 years old now! It still comes in hand for test work or entertaining visitors who've never seen such stuff, even the little kids can manage to aim it and pull the trigger while I keep hold of the tip of the butt.
I'm toying with the idea of making a nice target crossbow, I made a laminated prod many years ago and I have a big baulk of hardwood fro the stock too.
So many things to make!
I shall google New World Arbolast.
Cheers
Del
If you go to options>addins> enable addins> Solver, analysis VBA and analysis tool pack and camparative statics. check them all.
Then you can begin to do basic econometric analysis.
IE: Say you have Draw weights in one column, arrow speed in another collmn, limb length in another, arrow weight in another you could go to the data tab click analysis, click "regression" then select arrow speed in the first dialoge and the other factors in the second dialogue. Click any graphs you want and the result will be something resuembling an equation that will project with in a range of error, what an arrow speed will be given various inputs. So if you had limb length , limb type (wood), design (recurve or long bow as dummy variables), draw weight and arrow weight as known variables say for a project, then you would know where arrow speeds are likley to fall. There are statistic acrobatics necessary to minimize the error term that inflates the range of error but it's a start.
Given the equation you could also use the solver and a variant given constraints to give you the best arrow speeds given some fixed input via a linear program.
You would need to keep data for all that stuff or obtain it for at least 30 points. T-tests and various descriptive statistics are readily available there also with out needing to hand calculate all the averages.
Ah well fun stuff. I have leaves to rake.