BDC Subtention/Range CALC Excel

[FreQRiDeR]

I've been playing with Excel Ballistic calculators and started writing my own for kicks. I made this BDC Calc to recalculate published scope subtentions at 9x/100 yards to various magnifications. You can then use the table on the bottom to calculate range from the various subtentions. I have Excel on my Smart-ass phone so I can run it in the field and range with the BDC reticle.

BDC SUBTENTION CALC.xlsx

[FreQRiDeR]

Sorry, version with directions. 

 

BDC SUBTENTION CALC 2.xlsx

[FreQRiDeR]

Updated moa to equal 95.5 inch instead of rounded to 1" (more accurate) and zoom/subtentions formula improvements.

 

BDC SUBTENTION CALC2.xlsx

[FreQRiDeR]

19 minutes ago, FreQRiDeR said:

Updated moa to equal 95.5 inch instead of rounded to 1" (more accurate) and zoom/subtentions formula improvements.

 

BDC SUBTENTION CALC2.xlsx

Disregard this last version! I got confused. Subtentions on this scope are in inches already so no need to multiply by moa! Sorry Admins, can you delete this last post?

[FreQRiDeR]

Final version here. Sorry, work in progress. 

 

BDC SUBTENTION CALC FINAL.xlsx

[FreQRiDeR]

I have updated the Bdc Calc to have upper and lower subtentions, better directions, nicer reticle diagram and the sheet is now protected so you can't inadvertently modify things. I have also added my MOA CALC as well. Let me know if you find any of these tools useful. Enjoy! 

 

BDC SUBTENTION CALC II.xls

MY MOA.xlsx

[longfisher]

Is the above on 10-/27 the final version?

[FreQRiDeR]

4 hours ago, longfisher said:

Is the above on 10-/27 the final version?

Yes, sorry, sight wouldn't let me edit/delete posts. Work in progress :)