Excel Marksman™
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 links to web sites where good information about small arms, ballistics, cartridges, hunting and shooting resides has been moved here.
Hans Cronander
Total number of unique visits since start Oct. 2005:
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.
Miscelleanous
Link to www.cronander.net - "copy & paste"-HTML code (with neat button)
My professional profile - Classfield
My great seal - Hans an der Chrönika
Magical drink recipes (in Swedish)
Link to www.cronander.net
cronander.net privacy policy
IE Color Names - and corresponding RGB Codes
Camera Brokers - buy a second hand lens or body
Universal Currency Converter - also converts noble metal values
MySpace - find me there and be my friend!
www.stayfriends.se - Find old friends (in Swedish)
Trading in Options & Futures - Informative Articles About Trading Options & Futures
Search the web
Website Ranking
All rights reserved. Reproduction in whole or in part without permission prohibited.
Ballistics and Stock Options at Hans Cronander's free Excel models page by Hans Cronander Copyright© 2005
