Calculating Water Rocket Performance: Thrust, Velocity & More

[Alcubierre]

Help. Anyone? This is due in a few hours and I don't know how you got the volume of air so low when I get 0.001 cubic meters and that ruins the whole spreadsheet as it must be, apparently, at least 0.0001 cubic meters to take any effect.

 

[haruspex]

Help. Anyone? This is due in a few hours and I don't know how you got the volume of air so low when I get 0.001 cubic meters and that ruins the whole spreadsheet as it must be, apparently, at least 0.0001 cubic meters to take any effect.

This is probably too late. I plugged in Vf = .002, P0 = 4*atmospheric ("=4*I2"), M = 0.5, A = 0.002 (pi*.025^2). I played around with V0 to maximise height. I got nearly 5m at V0 = 0.00113. But go just a fraction over that and you lose big time.
Not sure about P0. If your gauge says 45 psi, is that 3 atmospheres, or 3 atmospheres in addition to the background 1 atmosphere? I'm assuming it's the second.