Deriving formula to calculate theta for artillery

[super6logan]

I play an online shooter game with artillery that players can use. As best I can tell, the shell exits the artillery at 400m/s, I don't know if that's correct because units aren't listed in the code but it sounds logical. I know the distance to target as well, I only need to know what angle to aim the barrel to hit to target. Here's the formula I've derived as it looks in excel with A1 being the cell with the target range:
=(DEGREES(ASIN((9.81*A1)/(400^2))))/2
and in an equation, r as range to target:
(sin^-1((9.81R)/(400²))/2=$$\Theta$$

The problem is that if I plug a range like 650m into it the output in excel is 1.14201, an impossible number but I know that the artillery can hit ranges over 700m. Does this imply that the 400m/s V₀ I have is wrong?

 

[Lojzek]

The formula is correct, but the projectile velocity is probably much lower (maybe 400 km/h?). I assume the game does not consider air resistance (you can check this by observing the symmetry of the trajectory). You should use your formula for range(angle) to calculate theoretical range (with your guess for projectile velocity). Then you measure the actual range at that angle in the game. Since the range is proportional to the square of the
projectile velocity, you simply divide your guess for projectile velocity by the square root of
the ratio between calculated range and measured range. For example: if your calculated range is 9 times too large, you divide projectile velocity by 3.

 

[sir-pinski]

First of all, great job on deriving a formula to calculate theta for artillery! It's always impressive to see players using their knowledge and skills in real-life scenarios, even if it's just in a game.

Now, to address the issue you're facing with the output of your formula. It is possible that the 400m/s velocity you have for the artillery's shell is incorrect. As you mentioned, it is not listed in the code and may not be accurate. Additionally, there could be other factors at play such as air resistance, wind speed, and elevation that could affect the velocity of the shell.

One way to confirm the velocity is to test it in different scenarios and distances and see if the results align with the expected outcomes. Another option is to consult with the game developers or other experienced players to see if they have any information on the velocity of the artillery's shell.

In any case, it is always a good idea to double-check your assumptions and formulas to ensure their accuracy. Keep up the good work and happy gaming!