The Excel Marksman™. I am an Excel guru, and I will here publish my Excel based Gâvre and Monte Carlo calculators. Anyone devoted to VBA programming is welcome to further develop these calculators, as long as they share the improved code with me. The VBA source code in the Excel 3DOF / R.L. McCoy CFD based trajectory model includes an ODE engine based on a Bulirsch-Stoer variable step length numerical integration method for rational functions. If my models or code from them are being used or sold commercially, I claim a $50 per copy royalty.
I'll also use this webspace to publish links to web sites where good information about small arms, ballistics, cartridges, hunting and shooting resides.
Hans Cronander
Total number of visits:
02046
My VBA coded Excel models
Send me an e-mail if you are interested in taking the VBA code one step further.
2DOF excel model - requires Form Factor and G1 Ballistic Coefficient. 3DOF excel model - requires Ballistic Coefficient. Supports the G1, G2, G5, G6, G7, G8, GS, GL, GI, GB and RA4 models. The source code includes an ODE engine based on a Bulirsch-Stoer variable step length numerical integration method for rational functions. The model needs to be complemented with more retardation forces. Drag models for G1, G2, G5, G6, G7, G8, GS, GC, GL, GI, GB, RA4 and CFD calculation of drag model for measured bullets. Drag functions - CFD calculation of the aerodynamic coefficients embraced by the 6DOF model. Monte Carlo - Stock and Option analysis (including Black & Scholes famous option pricing model). Single file download - the five free excel models above in a single .zip archive.
GRACO - Adjustable Stock Hardware and BreaKO Recoil Reduction System Peltor - level dependent tactical hearing protection Minox NV300 - affordable Night Vision Cabela's - World's Foremost Outfitter Garmin 60CS - handy, lightweight, rugged, waterproof GPS unit
Targets
Älgklockan - airgun (10 m) moose clock in 1 km to target scale My Targets - collection of more than 50 targets Thomas Haller - Photos, Targets and other Art
