- #1

swemek

- 1

- 1

Hello!

I'm doing some research for a small project that I hope you can help me with. I'm not a math genius, I just have an idea.

I have an Excel document of a projectile trajectory with an angle of 8 degrees. (Can be any angle.) Blue projectile trajectory.

What I want to do is enter the maximum height (green dashed line) and get a new angle. Red projectile trajectory. Calculated on a different tab.

I only tried my way up to the angle of 6.68 degrees.

Formulas used in Excel:

X-pos =B3+D3*t

Y-pos =C3+E3*t

X-Velocity =V0*COS(LA) =D3+H3*t

Y-Velocity =V0*SIN(LA) =E3+I3*t

X-Drag =-1/2*Dc*A*p*D3^2

Y-Drag =-1/2*Dc*A*p*E3^2

X-Accel =F3/m

Y-Accel =(G3+m*g)/m

Is this doable?

Hope you can help me.

Thanks in advance /M

I'm doing some research for a small project that I hope you can help me with. I'm not a math genius, I just have an idea.

I have an Excel document of a projectile trajectory with an angle of 8 degrees. (Can be any angle.) Blue projectile trajectory.

What I want to do is enter the maximum height (green dashed line) and get a new angle. Red projectile trajectory. Calculated on a different tab.

I only tried my way up to the angle of 6.68 degrees.

Formulas used in Excel:

X-pos =B3+D3*t

Y-pos =C3+E3*t

X-Velocity =V0*COS(LA) =D3+H3*t

Y-Velocity =V0*SIN(LA) =E3+I3*t

X-Drag =-1/2*Dc*A*p*D3^2

Y-Drag =-1/2*Dc*A*p*E3^2

X-Accel =F3/m

Y-Accel =(G3+m*g)/m

Is this doable?

Hope you can help me.

Thanks in advance /M