Wrong formula-calculation of the bullet's range

[chipxx]

Hi everyone, I'm going crazy because I can't understand why this formula gives me wrong values. The calculation of the bullet's range.
This is the formula:
mathcad

Please Login or Register  to view this content.

excel

Please Login or Register  to view this content.

Velocity = 100m/s
degrees = 65°

$A$2 = Velocity
$B$2 = degrees

result mathcad 781,148 m
result excel 34.72964 m (:

Thank you very much
chipxx

[Richard Buttrey]

Hi and welcome to the forum.

You've not copied the Git formula faithfully into Excel

Use

Please Login or Register  to view this content.

[chipxx]

Thank you Richard is now correct, but why do I have to multiply it by 2 radians?

[Richard Buttrey]

I think that's because the formula is calculating the time and distance to the peak of the parabola, i.e. half way and that involves one Sin component and then the other half of the parabola involves another Sin component, hence two in total.

The formula of course assumes the time and distance on a level plain. It doesn't allow for the end point being higher or lower than the start point.