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)?
The difference in time, 0.6126, is an ABSOLUTE value. Sign is irrelevant.
It is relevant when calculated and displayed on a spreadsheet. You explicitly calculated for and displayed the negative value. Had you calculated for an absolute value, a negative value would not appear. If your formula in the cell does not say it is an absolute value, you do not produce an absolute value.