-
If you are being asked to change your password, and unsure how to do it, follow these instructions. Click here
MERC - Maximum Effective Range Calculator
- Thread starter speedengineer
- Start date
Help Support Long Range Hunting Forum
speedengineer
Well-Known Member
Glad to hear you like the calculator.
Hopefully you can get used to the English units of yards, inches, fps, and mph! Perhaps eventually I will release a metric version. I guess that depends on how popular the tool becomes.
Really an outstanding tool. Thanks so much for sharing!
speedengineer
Well-Known Member
Released a minor update. So significant changes.
v2.07.04 - Minor revisions to instructions. Include user defined simulation Titles in the results table headings. Updates to the "Results Output" worksheet.
v2.07.04 - Minor revisions to instructions. Include user defined simulation Titles in the results table headings. Updates to the "Results Output" worksheet.
speedengineer
Well-Known Member
FYI, I added a Download Link for MERC to the first post (and removed the attached zip file).
Since I've shared this on a couple other websites now, having a single download link means I don't have to maintain current file versions across multiple websites.
Since I've shared this on a couple other websites now, having a single download link means I don't have to maintain current file versions across multiple websites.
Thanks for the update.
Minor suggestion for convenience: add a macro/button on the Scenario B sheet to copy over inputs from Scenario A (all but velocities). I find that much of the scenario examination I've done with the tool so far has been with the same load under different conditions, so almost all Scenario A & B inputs are the same. The current sheet layout doesn't allow for grabbing all inputs at once to copy/paste (need to do it in several blocks).
That's the best I can up with so far. Fun tool.
Minor suggestion for convenience: add a macro/button on the Scenario B sheet to copy over inputs from Scenario A (all but velocities). I find that much of the scenario examination I've done with the tool so far has been with the same load under different conditions, so almost all Scenario A & B inputs are the same. The current sheet layout doesn't allow for grabbing all inputs at once to copy/paste (need to do it in several blocks).
That's the best I can up with so far. Fun tool.
speedengineer
Well-Known Member
Thank you for the feedback! Scott and I had discussed that exact topic! We decided to choose the path of least resistance (option 4).
- Add a button to copy the inputs from the other simulation worksheet. Negative - yet another button = more confusing to use the tool.
- Unlock the narrow cells in between each block of inputs, so you can select the whole block of inputs, and then copy/paste. Negative - users could accidentally type stuff in those narrow cells, since they aren't locked.
- Delete the narrow rows between each input block, thus all inputs can be copy/pasted at once. Negative - it looks ugly
- Do nothing, and see if anyone complains about it.
For the time being, here is a trick!
On the SimB tab, reference each user input cell to equal the value from the SimA tab. For example, the MVSD input on the SimB tab would contain the following formula:
='Simulation A - (Baseline)'!E10
This way, whatever you type into the SimA inputs, the SimB inputs will match. Or you could do vise-versa to make simA match what you type into simB.
For those who don't know, you don't have to type all this out. The follow steps are how to reference a cell from another worksheet:
- Click a SimA input cell.
- Hit "="
- Click the SimB worksheet
- Click the SimB input cell you want to reference
- Hit Enter
Certainly should not be logged into the "complaint" bin, merely suggestion. And the cell reference fix works fine.Joe-boy
Well-Known Member
This is just plain awesome. I've been thinking about programming something like this myself, but would not have been able to do it nearly this well.
Also, if more people were using this, people would understand it doesn't mean THAT much if your rifle shoots 0,8 or 1,1 MOA. As the range gets longer, the more it is about the ambient conditions and less about the mechanical accuracy.
Also, if more people were using this, people would understand it doesn't mean THAT much if your rifle shoots 0,8 or 1,1 MOA. As the range gets longer, the more it is about the ambient conditions and less about the mechanical accuracy.
Braunschweiger
Well-Known Member
Hi all! I was curious if there was a new link available to download this. Luckily I saved the version from several years ago, but, unsure if it has been updated since then. Any help is appreciated. Good luck to all hunters out there!
speedengineer
Well-Known Member
Thanks for letting me know the download link has broken, I will update the link in the first post!
speedengineer
Well-Known Member
Odd, it seems the option to edit the older posts is missing. Perhaps after a certain age that option is removed.
So, please use the following download link for merc:
Download MERC
So, please use the following download link for merc:
Download MERC
Braunschweiger
Well-Known Member
Outstanding. Thanks for the quick work!
