07-31-2018, 11:21 PM
For ease of range cards you could use a rounding formula in Excel. The one used here is MROUND. It rounds up or down to the nearest multiple. If you're dealing with MOA tactical scopes they are typically either 1/4 or 1/2MOA clicks. In decimal-speak that's multiples of 0.25 or 0.5.
Fill a column with what the ballistics program is predicting. Then fill the next column with what your scope clicks are (1/4 or 1/2). Then in the next column type =MROUND(a,b)
a is the cell with the ballistics prediction and,
b is the cell with the click graduations. Fill down to populate all the predictions.
[ATTACH=CONFIG]12388[/ATTACH]
Fill a column with what the ballistics program is predicting. Then fill the next column with what your scope clicks are (1/4 or 1/2). Then in the next column type =MROUND(a,b)
a is the cell with the ballistics prediction and,
b is the cell with the click graduations. Fill down to populate all the predictions.
[ATTACH=CONFIG]12388[/ATTACH]