Forums
New posts
Search forums
What's new
Articles
Latest reviews
Author list
Classifieds
Log in
Register
What's new
Search
Search
Search titles and first posts only
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Rifles, Reloading, Optics, Equipment
Rifles, Bullets, Barrels & Ballistics
MERC - Maximum Effective Range Calculator
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="entoptics" data-source="post: 1966506" data-attributes="member: 104268"><p>w00000h0000! <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin :D" loading="lazy" data-shortname=":D" /></p><p></p><p>Just a couple things to add.</p><p></p><p>1) [USER=112986]@speedengineer[/USER] put in a herculean effort in developing the code, interweaving all the calculations, and overall implementation, so throw him a few likes (and perhaps buy him a beer via the instructions page)!</p><p></p><p>2) You must have an Excel version that supports <em>VBA Macros </em>and, as SE mentioned above, phone versions won't. Don't know about tablets.</p><p></p><p>3) If you're not familiar with Excel, there are tabs at the bottom, which are each of the sheets needed to use the tool. Click on them to switch between tabs (e.g. Instructions, Simulation A, JBM Paste).</p><p></p><p><strong>Also, when you first open the workbook, make sure to hit the "Enable Macros" button (on some versions of Excel there may be a little yellow header row that says "Enable Content" instead of a popup dialogue).</strong></p><p></p><p><em><u>For those of you who don't read instructions...(most of us?), a few quick tips to get started.</u></em></p><p></p><p>A) <strong>Every cell with a little red triangle in the corner has a "hover over" tip. Hold your mouse over the cell, and instructions/tips will pop up.</strong></p><p></p><p>B) You must calculate 2 trajectories with your ballistic calculator, which MERC then interpolates between to calculate the effects of your uncertainties. BE CAREFUL IN THIS STEP AND JUST READ THE FN INSTRUCTIONS. Crap in = Crap out!</p><p></p><p>C) We recommend using a fixed zero angle (angle between scope LOS and bore), and not a fixed zero distance, when calculating your trajectories. JBM ballistics allows this, and is our recommended calculator. We also added a convenient "auto paste" feature for use with JBM. READ THE JBM PASTE instructions for this.</p><p></p><p>A fixed zero distance will force your bullet through the bullseye at that distance, so when you calculate a trajectory at a different velocity, it will raise/lower the scope to make it pass through whatever distance you have this set at. This isn't how the real world works. If your ammo speed changes from shot to shot (it all does), if you go up 5000 feet in elevation, or if it gets cold outside, your gun won't magically correct your zero for you in the field.</p><p></p><p>If your preferred calculator doesn't have a zero angle feature, that's fine, just make sure to set your zero pretty close (say 10-20% of the distance you are most interested in studying), to mitigate the errors this causes.</p><p></p><p>That's all for now. We eagerly await your feedback. This is hopefully an evolving project, so let us know the good/bad/ugly, and maybe we'll fix it...or maybe not...<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /></p></blockquote><p></p>
[QUOTE="entoptics, post: 1966506, member: 104268"] w00000h0000! :D Just a couple things to add. 1) [USER=112986]@speedengineer[/USER] put in a herculean effort in developing the code, interweaving all the calculations, and overall implementation, so throw him a few likes (and perhaps buy him a beer via the instructions page)! 2) You must have an Excel version that supports [I]VBA Macros [/I]and, as SE mentioned above, phone versions won't. Don't know about tablets. 3) If you're not familiar with Excel, there are tabs at the bottom, which are each of the sheets needed to use the tool. Click on them to switch between tabs (e.g. Instructions, Simulation A, JBM Paste). [B]Also, when you first open the workbook, make sure to hit the "Enable Macros" button (on some versions of Excel there may be a little yellow header row that says "Enable Content" instead of a popup dialogue).[/B] [I][U]For those of you who don't read instructions...(most of us?), a few quick tips to get started.[/U][/I] A) [B]Every cell with a little red triangle in the corner has a "hover over" tip. Hold your mouse over the cell, and instructions/tips will pop up.[/B] B) You must calculate 2 trajectories with your ballistic calculator, which MERC then interpolates between to calculate the effects of your uncertainties. BE CAREFUL IN THIS STEP AND JUST READ THE FN INSTRUCTIONS. Crap in = Crap out! C) We recommend using a fixed zero angle (angle between scope LOS and bore), and not a fixed zero distance, when calculating your trajectories. JBM ballistics allows this, and is our recommended calculator. We also added a convenient "auto paste" feature for use with JBM. READ THE JBM PASTE instructions for this. A fixed zero distance will force your bullet through the bullseye at that distance, so when you calculate a trajectory at a different velocity, it will raise/lower the scope to make it pass through whatever distance you have this set at. This isn't how the real world works. If your ammo speed changes from shot to shot (it all does), if you go up 5000 feet in elevation, or if it gets cold outside, your gun won't magically correct your zero for you in the field. If your preferred calculator doesn't have a zero angle feature, that's fine, just make sure to set your zero pretty close (say 10-20% of the distance you are most interested in studying), to mitigate the errors this causes. That's all for now. We eagerly await your feedback. This is hopefully an evolving project, so let us know the good/bad/ugly, and maybe we'll fix it...or maybe not...;) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Rifles, Reloading, Optics, Equipment
Rifles, Bullets, Barrels & Ballistics
MERC - Maximum Effective Range Calculator
Top