I recently created a Microsoft Excel based tool that calculates your probability of hitting a target. It allows study of the effects of rifle and environmental variables and uncertainties on hit percentage.
Read below, and check out the screenshot to see what it’s all about. I am sharing this with the community for free.
Note - you will need Microsoft Excel on a computer in order to run this tool. Versions of Excel for your phone will not work, as they don’t support Excel Macros.
MERC Download Link
Introduction to MERC - Maximum Effective Range Calculator
In a perfect world, the bullets would always leave your barrel in the direction you intended with identical velocities, and there would be no uncertainty in your wind or range estimation - you would hit your target's center with every shot. Unfortunately, we have to contend with variation and uncertainty in the real world.
This calculator lets the user specify information about their rifle and the shooting conditions, including the uncertainty in each input. The calculator applies an amount of random variation based on those specified uncertainties, and determines where the bullet would have hit. It then repeats this process for many hundreds of shots, and calculates a hit probability based on the number of hits and misses. It also plots the hit locations for the first 300 of these shots on a graph, to visually show the distribution of their impacts.
What can I use MERC for?
MERC can be used to study many shooting situations. Here are some examples to get you started:
Special thanks to Scott B. (entoptics on LRH), who convinced me that it would be worthwhile to release this tool to the shooting community. Together, we jazzed up the user interface, design/layout, instructions, and many other details. Hopefully you find it useful!
Read below, and check out the screenshot to see what it’s all about. I am sharing this with the community for free.
Note - you will need Microsoft Excel on a computer in order to run this tool. Versions of Excel for your phone will not work, as they don’t support Excel Macros.
MERC Download Link
Introduction to MERC - Maximum Effective Range Calculator
In a perfect world, the bullets would always leave your barrel in the direction you intended with identical velocities, and there would be no uncertainty in your wind or range estimation - you would hit your target's center with every shot. Unfortunately, we have to contend with variation and uncertainty in the real world.
This calculator lets the user specify information about their rifle and the shooting conditions, including the uncertainty in each input. The calculator applies an amount of random variation based on those specified uncertainties, and determines where the bullet would have hit. It then repeats this process for many hundreds of shots, and calculates a hit probability based on the number of hits and misses. It also plots the hit locations for the first 300 of these shots on a graph, to visually show the distribution of their impacts.
What can I use MERC for?
MERC can be used to study many shooting situations. Here are some examples to get you started:
- Comparison of one cartridge/rifle/bullet to another. For a given set of conditions, which has better hit%, etc.
- Identify the longest range you would be comfortable hunting at, given a specific set of conditions and uncertainties.
- Estimating what hit rates to expect for a yardage that's farther than you've shot before.
- Comprehend how errors in your scope zero affect hit probability.
- How much does "x" variable matter. For example, does a 0.5 MOA rifle help my hit% for my shooting scenario? How about StdDev in MV?
- How accurately do you need to estimate range and wind in order to have consistent hits?
- For a desired hit percentage, how much extra range does using a higher BC bullet provide?
- Understanding how wind angle uncertainty can cause groups that aren't centered around your point of aim.
Special thanks to Scott B. (entoptics on LRH), who convinced me that it would be worthwhile to release this tool to the shooting community. Together, we jazzed up the user interface, design/layout, instructions, and many other details. Hopefully you find it useful!
Last edited: