SIG Talk banner
  • Notice image

    SigTalk is a forum community dedicated to SIG Sauer enthusiasts. Come join the discussion about Sig Sauer pistols and rifles, optics, hunting, gunsmithing, styles, reviews, accessories, classifieds, and more!

1 - 3 of 6 Posts

Registered
Joined
1,808 Posts
Reaction score
3,082
Discussion Starter · #1 · (Edited)
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:


Picture of what you should see:
Font Rectangle Screenshot Parallel Number


Link to the Sight Deflection (windage) spreadsheet:

Sight_Deflection_Calculator_2023

Picture of what you should see:
Font Rectangle Parallel Number Screenshot
 

Registered
Joined
1,808 Posts
Reaction score
3,082
Discussion Starter · #3 ·
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.
 
1 - 3 of 6 Posts
Top