Gun convergence calculator

[pstyle]

Hi everyone,

I've drafted a spreadsheet that should help folks with their (edit) HORIZONTAL convergence settings. It is attached to this post in a zip file. I have posted this very gingerly - see last sentence on this post.

It calculates the range to an optimum firing area (impact zone) in terms of distance from your aircraft both in meters and in yards (for allied gunsights) based on three variables that you enter yourself.

The variables you enter are
1. your convergence setting, and
2. the desired size of the impacts zone/ spread of your bullets.
3. the distance between your outer guns (current set to 7m to approximate spitfires)

The default in the sheet is set to s convergence of 150m and a desired impact spread of 1m. It shows that you can fire on any aircraft from between 128 and 171m distance and still achieve the desired bullet spread.

I don't know if this will help anyone.... it's kinda useful to me to get some quick results on likely convergence cones before going through the laborious process of in-game testing.

I'm not a mathematician, and this sheet is just based on my memory of high school maths.... so it might have errors.... but it seems to check out to me. I'd happily accept corrections.

[5./JG27.Farber]

Cant open it. .xls what is that? Microsoft offices or something (yes I know its a spread sheet).

Ive started using google docs for displaying spreadsheets online, its quite good. However I assume you made this to be interactive which it would not be wth google docs.

So what can I use to open it? Open orafice?

[Ailantd]

Originally Posted by 5./JG27.Farber

Cant open it. .xls what is that? Microsoft offices or something (yes I know its a spread sheet).

Ive started using google docs for displaying spreadsheets online, its quite good. However I assume you made this to be interactive which it would not be wth google docs.

So what can I use to open it? Open orafice?

Try here:
http://office.microsoft.com/en-us/

[pstyle]

Originally Posted by 5./JG27.Farber

Cant open it. .xls what is that? Microsoft offices or something (yes I know its a spread sheet).

sorry, it's a Microsoft XL spreadsheet.

But open office will open it...

[ATAG_Septic]

Thanks for sharing this, it opens fine with Openoffice.

Forgive my complete ignorance of mathematics and partial ignorance about convergence but is this calculation for horizontal convergence only? Or, does it take into account the distance parabola as well?

Cheers,

Septic.

[pstyle]

Originally Posted by ATAG_Septic

Thanks for sharing this, it opens fine with Openoffice.

Forgive my complete ignorance of mathematics and partial ignorance about convergence but is this calculation for horizontal convergence only? Or, does it take into account the distance parabola as well?

Cheers,

Septic.

good point.
horizontal only.
I think the parabola arc (vertical drop) has some more complex math (for my skills level).

[Ailantd]

Originally Posted by pstyle

good point.
horizontal only.
I think the parabola arc (vertical drop) has some more complex math (for my skills level).

The parabola arc is also influenced by the plane angle itself, so I don´t see the point trying to adress that for a generic case.

[AbortedMan]

Anyone know the gun to gun span on the Hurricane?

[Insuber]

i remember an excellent series in SimHQ about convergence and deflection:

http://www.simhq.com/_air10/air_312a.html

And there is another tool in excel, including plane speeds and angle allowing to calculate deflection.

http://www.mission4today.com/index.p...p=show&kid=296

Cheers!

[gpang788]

Originally Posted by pstyle

Hi everyone,

I've drafted a spreadsheet that should help folks with their (edit) HORIZONTAL convergence settings. It is attached to this post in a zip file. I have posted this very gingerly - see last sentence on this post.

It calculates the range to an optimum firing area (impact zone) in terms of distance from your aircraft both in meters and in yards (for allied gunsights) based on three variables that you enter yourself.

The variables you enter are
1. your convergence setting, and
2. the desired size of the impacts zone/ spread of your bullets.
3. the distance between your outer guns (current set to 7m to approximate spitfires)

The default in the sheet is set to s convergence of 150m and a desired impact spread of 1m. It shows that you can fire on any aircraft from between 128 and 171m distance and still achieve the desired bullet spread.

I don't know if this will help anyone.... it's kinda useful to me to get some quick results on likely convergence cones before going through the laborious process of in-game testing.

I'm not a mathematician, and this sheet is just based on my memory of high school maths.... so it might have errors.... but it seems to check out to me. I'd happily accept corrections.

Pardon me but I am a complete mathematics idiot. Any instructions on how to use this?