ORIGINAL: bigdawgwill44
the spreadsheet is nice and all but i don't see where it shows the Point Blank Range. Also i want a +/- of 2", will this show that? thanks.
All Max point black range
is the furthest distance you can zero your rifle for, at which your bullet is never above or below your line of sight by more than a certain amount. On the spreadsheet enter in your scope hieght (middle of scope to middle of bore), velocity, and Ballistic coef. From there just change your zero range in increments of 10yards, and look at the bullet path where it does not exceed 2". For my 204 ruger, took me a total of 10 sec.
Or if you are good at formulas in excel, just use the tools section (excel) to do a conditional format. You can program excel to do just about anything you need. Especially if you know visual basic. Just use if/and boolean statements to do a goal seek to not exceed whatever you want your MPBR to be.
The good news with the excel sheet, you have much more control. A generic program on the web is usually off by quite a bunch due to the scope ht, and over estimated BC.
Give me your velocity, BC, and measured scope ht, and altitude if you are really high and I can calculate it for you in a few seconds.