Math, For Fun!!!

So in order to be safe and make sure we don't kill/maim anyone, I am trying to do as many calculations ahead of time as possible. Below I have embedded a google spreadsheet that lets me calculate the distance the cantaloupe will travel in the air, how long it will be in the air, it's speed at impact, and how many feet we will miss by for every sec we are off. I am estimating we will be between 200ft and 500ft when we drop, and traveling 60-80 knots. The recon missions will determine the exact height and speed.


As you can see if we are traveling at 60 knots we can expect to miss by 100 feet for every second we screw up. Wow, you say if you drop it 1 second early you will miss by 100 feet! Really if you think about its not that much. If you look at the photo below you can see we have 4,400 feet to work with, which will give us a window of 44 seconds of safety. As long as we don't drop it more than 26 seconds early or 18 seconds late, we are safe. Also all of you who are asking the question, "What about wind?", my fighter pilot friends have told me that a bomb that is in the air for less than 6 seconds will not be affect by the wind. If you look above 500 feet gives us a time of 5.59 seconds.
Note: So I don't get ten comments, wind will affect the ground speed so I will factor that in.