- #1
aidenpryde
- 3
- 0
Hello,
I'm new to these forums but hope to be here awhile to gather information about various aspects of weapon performance. I'll let you know right now I'm not really good at math, which is why I'm looking for a solution, or how to set up a solution, so that I can just input variables and get the proper result.
I am a indie game developer and am currently working on getting the naval side of our game together. In addition to modeling (currently working on the Type 34A German Destroyer) I am also responsible for writing the game design document, which means that I need accurate stats for different types of artillery.
I've been looking around the internet and have been able to find several excel spreadsheets that have the calculations set up in different fields already. But these spreadsheets really only pertain to small arms and not to the larger caliber weapons (such as the 15cm main guns on the Type 34A). Indeed the spreadsheets seem to freak out and break down when I try to input the types of ranges that you would see in game (20km, etc). They also do not display the velocity of the shell as it moves downrange.
This is important because our game needs to know the velocity of a shell at a given range in order to (at least with Armor Piercing ordinance) calculate how much energy it directs at the target. An important consideration when determining whether or not a shell will penetrate a given thickness of armor (angle of impact, angle of armor, thickness of armor, and size of the shell will be a different calculation).
So basically I am looking for an excel sheet that will allow me to input things like muzzle velocity and then generate fields that will break down how fast the shell is moving at different ranges.
I found one that will tell me how far the shell will travel (inputs are: angle of the gun at firing, height of gun, and muzzle velocity, and gravity) but it doesn't break down the velocity at different ranges.
Any help or workarounds would be appreciated.
I'm new to these forums but hope to be here awhile to gather information about various aspects of weapon performance. I'll let you know right now I'm not really good at math, which is why I'm looking for a solution, or how to set up a solution, so that I can just input variables and get the proper result.
I am a indie game developer and am currently working on getting the naval side of our game together. In addition to modeling (currently working on the Type 34A German Destroyer) I am also responsible for writing the game design document, which means that I need accurate stats for different types of artillery.
I've been looking around the internet and have been able to find several excel spreadsheets that have the calculations set up in different fields already. But these spreadsheets really only pertain to small arms and not to the larger caliber weapons (such as the 15cm main guns on the Type 34A). Indeed the spreadsheets seem to freak out and break down when I try to input the types of ranges that you would see in game (20km, etc). They also do not display the velocity of the shell as it moves downrange.
This is important because our game needs to know the velocity of a shell at a given range in order to (at least with Armor Piercing ordinance) calculate how much energy it directs at the target. An important consideration when determining whether or not a shell will penetrate a given thickness of armor (angle of impact, angle of armor, thickness of armor, and size of the shell will be a different calculation).
So basically I am looking for an excel sheet that will allow me to input things like muzzle velocity and then generate fields that will break down how fast the shell is moving at different ranges.
I found one that will tell me how far the shell will travel (inputs are: angle of the gun at firing, height of gun, and muzzle velocity, and gravity) but it doesn't break down the velocity at different ranges.
Any help or workarounds would be appreciated.