What would the Elapsed time between the Last Report sound event and the Last Bullet sound event be if, as the video alleged, the guy "dressed as police" was shooting?
What would the Elapsed time between the Last Report sound event and the Last Bullet sound event be....
It would be a positive number expression of time.
On your spreadsheet chartoon, notice that you calculate T = Tb - Ts.
You calculate elapsed time as the time it took the bullet to travel, minus the time it took the sound to travel.
The correct formula should be T = Ts Tb = d/Vs d/Vb.
As the bullet is supersonic, and sound is a constant, the sound would travel 400 yards in 1.06s and the bullet would travel in less than 1.06s. Subtracting 1.06 from a smaller number will always yield a negative number.
At 1200 feet, you calculate Tb as 0.448578s, and Ts as 1.062s and calculate the T as -0.6126, negative 0.6126 seconds. The average donkey could recognize that something is wrong when the result is negative time.
Just what do you think happens in negative 0.6126 seconds?
You could at least recognize that if you get a negative number, you have stated the required formula backwards, and you proceeded to perform the calculation backwards, and present the bass ackwards result of your misunderstanding of the study you looked at.
Moreover, while you state backwards that T = Tb - Ts, your spreadsheet never defines what T is supposed to represent. Negative 0.6126 is the time of what? What is the significance of this negative 0.6126 seconds (other than to demonstrate you did not understand the reference study)?
your spreadsheet never defines what T is supposed to represent.
T is the absolute value of the difference between Tb and Ts -- which corresponds to the elapsed time between T1 and T2 that is OBSERVED in the audio recording's amplitude graph.
It is that correspondence that is then used to find the range - which was generated from the ballistic data for intervals of 75 feet.