[Rich Jenkins]

Here are a pair of simple Google spreadsheets that perform sight windage and elevation calculations. Although the computations are not complex, I refer to these often when evaluating target holds and selecting sights to zero a gun. I put them online in case you find them useful.

For the elevation spreadsheet, you enter distance to target, sight radius, observed error and your current sight height, and it will compute the new front sight height to achieve "zero".

Same for windage, you enter distance, sight radius, and your error, and it will calculate both the rear sight movement you need, as well as how much of a turn you need to make on the sight tool, to correct windage errors.

The sheets area protected from edit, except for the entry values. The sheets are "live", in that anybody with the link can get to it to use the tool. Boxes you can edit are GREEN, anything in YELLOW is a computation. Additional help text is provided in each sheet, so they are hopefully self-explanatory. Please let me know if you have any questions or comments.


Link to the Sight Elevation spreadsheet:

Sight_Elevation_Calculator_2023

Sheet1 Variable Name,Function,Step 1 : Start here: Enter the data into the GREEN cells:,Value,Notes R,Enter,What is the distance to the target, in yards?,25.0,yards SR,Enter,What is the pistol sight radius, in inches?,6.00,inches E,Enter,What is the observed elevation error, at the target, in in...

docs.google.com

Picture of what you should see:

Link to the Sight Deflection (windage) spreadsheet:

Sight_Deflection_Calculator_2023

Picture of what you should see:

 

[Rich Jenkins]

Thanks Rich! This is helpful. The computation for a new sight height is great for changing front sights, right? I've experimented with Trijicon HD nights sights for a while and end up buying various ones to see which one would get me on target with my current rounds. This would get me in the ballpark at very least. Very cool. 👍 👍

No problem! I mean, the math is not complicated but I was always using my calculator, and finally decided to stuff it all in a spreadsheet so I could access the computations easily and quickly. These have evolved a bit over the years with explanations etc. but I tried to make it as simple to use as possible. I'm happy if someone gets some use out of them besides me.

 

[Rich Jenkins]

Appreciate the sticky by the mod team. Many thanks.