Title: Forensic acoustic proof of SECOND shooter in the Las Vegas massacre Source:
[None] URL Source:https://www.youtube.com/watch?v=JxmEFeKy8aI Published:Oct 11, 2017 Author:Mike Adams TheHealthRanger Post Date:2017-10-11 00:40:47 by A K A Stone Keywords:None Views:45833 Comments:148
Why do you keep posting this chartoon when all your data is not only wrong, but farcical? The only things you proved is that you do not know how to calculate the average velocity of an imaginary bullet and you are hopeless at spreadsheets. Your entertainment value as a useful idiot is over for now, and you will never figure it out without more help. Help is on the way, grasshopper.
Columns 1, 2, and 3 are direct entry of data generated by entering imaginary data into a generator at http://www.shooterscalculator.com/. I replicated the data taken from the calculator with My BB's. If I input initial velocity as 3240 fps, and other data, and call it My BB's, I can show a chart for magical bbs.
The Shooters Calculator only provides a result based on user input. It does not present a spreadsheet with the formulas to generate the data. The data from the Calculator can be cut and pasted into a spreadsheet, or entered by direct entry; this produces data in the cells, but no spreadsheet formulas in the cells. The chart states the speed of sound as 1130 feet per second (fps).
The remaining 4 columns, (4, 5, 6, 7) were generated by VxH.
Column 6 uses 1130.8 fps to calculate the time for sound to travel the distance stated in Column 1.
Column 4 is labeled as (Avg V) Vb. This column purports to present the average velocity of the bullet to cover the distance for the row it is in. All of the data in this column is epically wrong as the methodology of calculation is absurdly wrong.
To calculate the average velocity of the bullet, divide distance by time.
Instead of this, a personal misbegotten formula was used. Probably a pocket calculator for each cell in Column 4 was used to perform the calculations, and the data was directly entered into the cells by hand.
For the first two data rows, sum 3240 and 3163 and divide by 2. 6403/2 yields the 3201 in Column 4.
For the first three data rows, sum 3240+3163+3088 for 9491. 9491 / 3 yields the 3163.6667 in Column 4.
And so on, and so forth. All the calculated Column 4 data (average Vb), is garbage.
The chosen methodology was to sum the velocity given for each distance, and divide by the number of elements summed. This produces nonsensical data.
Example: You drive a car 100 miles at 80 mph. You drive another 100 miles at 20 mph. With this bogus methodology, 80 + 20 = 100, divide by 2, and your average velocity was 50 mph. Not.
In the real world, you drove 100/80 or 1.25 hours at 80 mph. You drove 100/20 or 5 hours at 20 mph. And you drove 200 miles in 6.25 hours. Your average speed was 200/6.25, or 32 mph.
Column 4, in addition to using an absurd methodology for its calculations, also incorporates two summing errors for the velocities taken from Column 3, at 900 feet and 1275 ft. In each case, the actual sum was 1 less than that calculated.
Spreadsheet formulas are not prone to fat finger syndrome, and do not make such errors, but someone with a pocket calculator or pen and paper does. The data was typed in after external calculation.
Where you calculate 2367.5926 average Vb at 1950 feet, 1950/1.211933 (the velocity of the bullet in Column 5), it yields 1608.9998 fps, remarkably close to the 1609 in Column 3. But then, the elapsed time in Column 2 is 0.86, not 1.21933. It is a conundrum how the bullet traveled for 1.21933 seconds in an elapsed time of 0.86 seconds.
Of course, when you use Column 1 1950 ft and Column 3 1609 fps to derive the time of flight, the formula is d/Vb, and Vb is the Average Velocity.
The bullet will travel 1905 feet distance (Col 1) in 0.86 sec time (Col 2) in 1905/0.86 or 2267.4418 average Vb. Stated in your headnote is Tb is d/Vb.
It is noteworthy that you used Column 3 as the "average" velocity of the bullet in order to derive the other average velocity of the bullet in Column 4.
Column 5 (Tb) incorporates the garbage data from Column 4 into its calculations, and all the resulting calculated data is wrong. GIGO.
Column 7 (T = Tb Ts) incorporates the garbage data from Column 5 and all the calculated data is wrong. GIGO.
The chart is multicolor and pretty, but the data for the imaginary bullet is demonstrably wrong in every column you created, except for column 6 where you succeeded in dividing the distance by 1130.8.
Some dirty rotten no good chopped the formulas off your chart.
d is the target distance.(range) Vs is the velocity of sound, and Vb is the average bullet velocity over the distance Tb is d / Vb (time to cover distance @ Vb) Ts is d/Vs (time to cover distance @Vs)
LOL please tell the class why the bullet accelerates / decelerates / accelerates repeatedly when your "analysis" is applied?
The time in the chart rendered by the ballistic calculator only has 2 decimals of precision.
Calculating the average per the reported velocity is thus more accurate.
More accurate is to divide the distance by the velocity and get the time to more decimal places and eliminate the rounding error. Your bullshit methodology of summing velocities and dividing does not work. It is bullshit.
Your chart in Column 2 from btgresearch indicates Tb for range 1950 is 0.86 seconds. Column 5 for 1950 range indicates Tb is 0.823621. You call that fixing a rounding error???? How did displaying only two decimal places to 0.86 convert to 0.823621.
Of course, the time of 0.02 could represent a figure rounded to two decimal places for presentation, and actually represent anything from 0.0150 to 0.0249.
75 feet divided by Vel[x] 3239 75/3239 feet, taken to six decimal places gives 0.0231552 seconds bullet travel time. Hot damn, it's within the rounding error.
At Vel[x+y] 3240 feet per second, and 75 feet distance, the time to six decimal places would be 0.0231481 seconds bullet travel time and hot damn, that's within the rounding error too.
You have the distance and velocity as a given from btgresearch. Divide the distance by the velocity d/V, and you can calculate the time to however many decimal places you desire.
The stupid... it hurts!
The chart results are based on the data you entered.
As I demonstratred, the same data entered for My BB's produces a chart with the same data for BB's.
If the chart correctly calculated the ballistic data for the parameters you entered,
Come on. Question my analysis of how you made a botch of the Average Bullet Velocity. Give us your methodology and formula.
Why were all your calculations wrong except for distance divided by time?
The data which you input did not come from any real life ammunition, you just entered stuff, as I did for My BB's. I just entered the same stuff you did, proving my bb's have an initial Vel[x+y] of 3240 fps. My BB's perform precisely as do your imaginary cartridge. Are you saying the ballistics chart you used produced invalid results?
If the chart results are valid, please tell the class why the chart indicates the bullet traveled 75 ft. in 0.02 seconds and that indicates average velocity d/time of 750/.02 = 3750 fps.
It's your data. If the ballistics chart calculated correctly, you should understand the chart you presented, and be able to explain the results given.
Do you think you are entitled to just use a nonsense formula which produces nosense results because you do not understand the chart data that you selected and presented?
and the data was directly entered into the cells by hand.
Bzzzt. Fail again.
Nope. You said you created spreadsheet and used their formulas. Had you used their formulas you would not have bullshit results, including arithmetic errors in the columns.
Which formula of theirs did you use to manufacture the wrong bullet velocities?
Cite any source that says to find average velocity with the method you used.
When you introduced this bullshit on the other thread at your #19 to A K A Stone, you said:
I found/took their formula, built a spreadsheet, and plugged in 223 balistic data generated via shooterscalculator.com:
Only you did not use their formulas or you would not have gotten all the data you derived bass ackwards wrong, and you did not create formulas and drag them down through the rows, or you would not have the calculation errors the are apparent.
I created a spreadsheet using the same data and created formulas and dragged them down through the rows. They work. That is how I can pinpoint where you made calculating errors in your data entry.
All you did was cut and paste the chart data into a spreadsheet workbook.
Columns 1 thru 3 were cut and paste.
For Column 4, there is no chance that you created a formula and dragged it down through the rows. You go off at range 900 where you summed to 36497 instead of 36496. This error of 1 continues through to range 1275, where you summed to 47,572 instead of 45,570. This put the summing error at 2, which continued through range 1950 where you ended.
This is not a spreadsheet error. I used two different formulas to sum the velocities, with results identical to each other. You used no formula. You sat there with your pocket calculator and added the first two and typed in the result. Then you added the third velocity and typed in the result. And you did this for each data entry in that column. If you have any spreadsheet formula that can replicate your results, produce it.
As Column 4 calculates the sum of the velocities divided by the number of velocities, and the sum of the velocities was not created by a formula on a spreadsheet column, the column was manual data entry.
In Column 5, d/Vb, the distance is correctly divided by the bogus average velocity, yielding a bogus result. When it is as simple as programming one column divided by another, good job. When it is summing a changing number of rows, fuhgetaboutit. That was direct data entry with arithmetic errors.
In Column 6, I stated you were able to divide distance by 1130.8. When it is summing a changing number of rows, fuhgetaboutit. That was direct data entry with arithmetic errors.
In Column 7, you managed to correctly subtract the bogus data in Column 5 from the bogus data in Column 6, yielding all bogus results. When it is as simple as programming one column subtracted from another, good job. It should have included an ABS function to avoid getting negative time results.When it is summing a changing number of rows, fuhgetaboutit. That was direct data entry with arithmetic errors.
As Columns 5 and 7 incorporate the brain dead data in Column 4, with a double whammy of a bogus formula and calculation errors, all data in Columns 5 and 7 is bogus.
Your chart in Column 2 from btgresearch indicates Tb for range 1950 is 0.86 seconds. Column 5 for 1950 range indicates Tb is 0.823621. You call that fixing a rounding error???? How did displaying only two decimal places to 0.86 convert to 0.823621????
As Column 4 calculates the sum of the velocities divided by the number of velocities, and the sum of the velocities was not created by a formula on a spreadsheet column, the column was manual data entry.
Bzzzt. Another Nolu-FAIL.
=SUM(C9:C10)/L9 =SUM(C$9:C11)/L10 =SUM(C$9:C12)/L11 etc. Where column L contains 1 @ row 8 and =+L8+1, =+L9+1 etc for rows 9..34
Now please tell us how Nolu-Time works and then explain why the values of Column J are closer to Time (Column B) than Nolu-Time(Column I)?
decoration-
style: initial; text-decoration-color: initial">more accurate is to divide the distance by the velocity and get the time to more decimal places
I correctly illustrate the flaw inherent in taking a momentary point velocity of a continuously decelerating proctile and ASSuming it to be an average.
There's a question regarding whether the value of Vel[x+y] for a given 75ft vector segment is the average Velocity OR whether it's just the momentry V at point d.
Here is the spreadsheet updated with Tcalc where Tcalc is an attempt to reconstruct the elapsed Time for a given Vector:
We're moving in the right direction - but the calculation for Tcalc could be even more accurate by deriving it from the slope of the DIFFERENCE between Vmin and Vmax for a given vector segment, rather than taking momentary V at point d and ASSuming it's a constant velocity over the entire 75ft segment... like you are.
If you care about truth why don't you find a list of all the posts yoy made with errors
In this case, the truth is still a work in process.
For the next step in the process - Maybe "yoy" and Noluchan's donkey can tell us why applying a linear calculation (d/v) to a non-linear velocity produces values for Time which are farther away from the Ballistic chart's value for T than rounding can explain?
Maybe you and Noluchan's donkey can tell us why applying a linear calculation (d/v) to a non-linear velocity produces values for Time which are farther away from the Ballistic chart's value for T than rounding can explain?
#119. To: A K A Stone, noluchan, buckeroo (#117)(Edited)
{ crickets crickets crickets }
So,
Illustration A: Vb calculated from d/Tcalc, where Tcalc= (d=75ft)/Vel Illustration B: Vb using my original Average of summed Velocity values.
A:B:
Please explain how, in the context of the highlighted range of interest on the concert field, Noluchan's idea to reconstruct Time by taking (d=75ft)/Vel[x+y] does not seem to produce results that magically render the values produced by summing and averaging Vel[x+y] into "bullshit"
?
Feel free to consult Noluchan's Donkey, since it probably has better temperament and reading comprehension skills than either of you two have demonstrated.
I correctly illustrate the flaw inherent in taking a momentary point velocity of a continuously decelerating proctile and ASSuming it to be an average.
There's a question regarding whether the value of Vel[x+y] for a given 75ft vector segment is the average Velocity OR whether it's just the momentry V at point d.
The problem is that you are clueless and do not know what your are doing and do not know what a vector is.
Here is a correct spreadsheet:
BALLISTICS DATA SPREADSHEET
A1
AVERAGE VELOCITY AND TIME DIFF OVER TOTAL DISTANCE
AVERAGE VELOCITY FOR EACH 75 FEET SEGMENT
2
3
B
C
D
E
F
G
H
I
J
K
L
4
d
Time
(avg) Vel[x+y]
Ts=d/Vs
T=Tb - Ts
Tb 75 ft
Avg Velocity for
Segment
Segment
Segment
5
(ft)
d/Vel[x+y]
(ft/s)
d/Vs
ABS(Tb-Ts)
+C7-C6
75 foot segment
distance
begin
end
6
0
0.0000
3240
+75/H4
+B7-B6
+K7+75
A7
7
75
0.0237
3163
0.0664
0.0427
0.0237
3163.0000
75
0
75
8
150
0.0486
3088
0.1327
0.0842
0.0249
3016.4744
75
75
150
9
225
0.0747
3014
0.1991
0.1245
0.0261
2876.1533
75
150
225
10
300
0.1020
2941
0.2655
0.1635
0.0274
2741.7798
75
225
300
11
375
0.1307
2870
0.3319
0.2012
0.0287
2617.2620
75
300
375
12
450
0.1608
2799
0.3982
0.2375
0.0301
2490.8930
75
375
450
13
525
0.1923
2730
0.4646
0.2723
0.0315
2378.2353
75
450
525
14
600
0.2254
2662
0.5310
0.3056
0.0331
2266.7686
75
525
600
15
675
0.2601
2595
0.5973
0.3372
0.0347
2160.0657
75
600
675
16
750
0.2966
2529
0.6637
0.3672
0.0364
2057.9351
75
675
750
17
825
0.3347
2465
0.7301
0.3954
0.0381
1967.1773
75
750
825
18
900
0.3750
2400
0.7965
0.4215
0.0403
1860.3774
75
825
900
19
975
0.4172
2337
0.8628
0.4456
0.0422
1777.1863
75
900
975
20
1050
0.4615
2275
0.9292
0.4677
0.0443
1691.5924
75
975
1050
21
1125
0.5081
2214
0.9956
0.4874
0.0466
1609.7315
75
1050
1125
22
1200
0.5571
2154
1.0619
0.5048
0.0490
1531.4566
75
1125
1200
23
1275
0.6089
2094
1.1283
0.5194
0.0518
1448.4509
75
1200
1275
24
1350
0.6631
2036
1.1947
0.5316
0.0542
1384.2156
75
1275
1350
25
1425
0.7201
1979
1.2611
0.5410
0.0570
1315.8863
75
1350
1425
26
1500
0.7800
1923
1.3274
0.5474
0.0600
1250.6135
75
1425
1500
27
1575
0.8436
1867
1.3938
0.5502
0.0636
1179.8360
75
1500
1575
28
1650
0.9101
1813
1.4602
0.5501
0.0665
1127.9144
75
1575
1650
29
1725
0.9801
1760
1.5265
0.5464
0.0700
1071.1245
75
1650
1725
30
1800
1.0539
1708
1.5929
0.5391
0.0738
1016.9418
75
1725
1800
31
1875
1.1309
1658
1.6593
0.5284
0.0770
973.8184
75
1800
1875
32
1950
1.2119
1609
1.7257
0.5137
0.0811
925.3285
75
1875
1950
33
2025
1.2972
1561
1.7920
0.4948
0.0853
879.1211
75
1950
2025
34
2100
1.3861
1515
1.8584
0.4723
0.0889
843.7085
75
2025
2100
35
2175
1.4796
1470
1.9248
0.4452
0.0935
802.5405
75
2100
2175
36
2250
1.5778
1426
1.9912
0.4133
0.0982
763.3722
75
2175
2250
37
38
Total
39
1.5780
40
SUM G7:G36
As a vector is described by a line and not a point, the Column D velocity at 75 feet describes the average bullet velocity for the segment from 0 to 75 feet, and the velocity at 150 feet describes the average bullet velocity from 0 to 150 feet, and so on.
The time for 75 feet indicates the elapsed time for 0 to 75 feet. The time for 150 feet indicates the elapsed time for 0 to 150 feet.
Column C, the time, is derived by dividing Column B (distance) by Column D. In your chart it is was rounded off to two decimal places. I took it to four decimal places.
Your added Rube Goldberg nonsense was not only wrong but unecessary. Average velocity at the stated distances was staring you in the face.
In Columns H thru L, I have provided the data for each 75-foot segment.
At 1575 feet, the bullet opens its largest gap on sound at 0.05502 seconds.
From 1575 to 1650 feet, the bullet travels at an average velocity of 1127.9144 fps, dipping below the speed of sound. After that, sound is traveling faster than the bullet and the gap diminishes.
Please explain how, in the context of the highlighted range of interest on the concert field, Your idea to reconstruct Time by taking (d=75ft)/Vel[x+y] does not seem to produce results that magically render the values produced by summing and averaging Vel[x+y] into " bullshit"
?
Illustration A: Vb calculated from d/Tcalc, where Tcalc= (d=75ft)/Vel Illustration B: Vb using my original Average of summed Velocity values.
A: B:
Please explain how, in the context of the highlighted range of interest on the concert field, Noluchan's idea to reconstruct Time by taking (d=75ft)/Vel[x+y] does not seem to produce results that magically render the values produced by summing and averaging Vel[x+y] into " bullshit"
It surprises me a little that we have seen no attempts at forensic reconstruction of the shooting by recognized shooting experts and/or audio experts. Other than that sad-sack attempt by the NYSlimes, I haven't seen anything along these lines.
There are experts out there. So why aren't we hearing from them? Is it because they find the audio data to be ambiguous? Who knows.
"our standard operating procedure is to avoid public comments on shooting events. This better protects our neutrality and value of our analysis in the event that we are retained by an agency or party to subsequent legal proceedings. We also like to restrict our analysis to materials that come into our possession following a proper and documented chain of custody regarding handling of evidence.
When it comes time for depositions or courtroom testimony, most experts who have made prior public comments on a matter find that opposing legal counsel, opposing experts, and the blogosphere find ways to make them regret earlier public comments."
===============
In light of what can be observed here - that makes sense.
Yeah. In the meantime, I've found this exercise to be a worthwhile learning experience.
I'm not telling you to stop or that you're wasting your time. You might stumble over something unnoticed by everyone. Recall how Dan Rather was brought down by a persistent guy that noticed the fonts in the fake documents about Dumbya's military service.
As per what I said in https://libertysflame.com/cgi-bin/readart.cgi? ArtNum=53046&Disp=105#C105 the next step in the quest is to explore methods of deriving Time relative to the slope of the DIFFERENCE between Vmin and Vmax for a given vector segment.
To find what is at your source, we go to the link, which, like the link to the Khan Academy, only shows that you are bullshitting.
You seem to have a special affinity in providing cut and paste bullshit as as some sort of profound knowledge.
The instantaneous slope of a curve is the slope of that curve at a single point. In calculus, this is called the derivative. It also might be called the line tangent to the curve at a point.
If you imagine an arbitrary curve (just any curve) with two points on it (point P and point Q), the slope between P and Q is the slope of the line connecting those two points. This is called a secant line. If you keep P where it is and slide Q closer and closer to P along the curve, the secant line will change slope as it gets smaller and smaller. When Q gets extremely close to P (so that there is an infinitesimal space between P and Q), then the slope of the secant line approximates the slope at P. When we take the limit of that tiny distance as it approaches zero (meaning we make the space disappear) we get the slope of the curve at P. This is the instantaneous slope or the derivative of the curve at P.
Mathematically, we say that the slope at P = limh>0 [f(x+h) - f(x)]÷h = df/dx, where h is the distance between P and Q, f(x) is the position of P, f(x+h) is the position of Q, and df/dx is the derivative of the curve with respect to x.
The formula above is a specific case where the derivative is in terms of x and we're dealing with two dimensions. In physics, the instantaneous slope (derivative) of a position function is velocity, the derivative of velocity is acceleration, and the derivative of acceleration is jerk.
Of course, the calculus formula P = limh>0 [f(x+h) - f(x)]÷h = df/dx, where h is the distance between P and Q, f(x) is the position of P, f(x+h) is the position of Q, and df/dx is the derivative of the curve with respect to x was not used anywhere in your spreadsheet, so you are just bullshitting.
Also,
When Q gets extremely close to P (so that there is an infinitesimal space between P and Q), then the slope of the secant line approximates the slope at P. When we take the limit of that tiny distance as it approaches zero (meaning we make the space disappear) we get the slope of the curve at P. This is the instantaneous slope or the derivative of the curve at P.
However, the slope of a bullet in flight is constantly changing, the deceleration is not constant, and the slope contains an infinite number of points.
Moreover, you have merely bullshitted and have not described any formula to obtain the average velocity of the bullet over a given range, using instantaneous velocities.
While you claim calculus formulas in your spreadsheet, you have yet to show a formula to sum changing parts of a spreadsheet column, i.e., sum row 1 and 2, sum row 1 thru 3, then row 1 thru 4, and so forth. I used such a formula and it showed that your column contained arithmetical errors not created by a spreadsheet formula. When you can program adding sums, I'll consider you doing calculus. As it is, you have not demostrated the ability to consistently add two numbers together, which is what you did to to sum that column. You added rows 1 and 2 to get the row 2 total; then you added row 3 to get the row 3 total, and so on, making two errors in 26 rows. You are fortunate it was now a thousand rows on a spreadsheet in a finance office.
The formula for calculating average velocity (d/t) is given by the Khan Academy in the video you referenced. In their example, they divide a distance fo 1000m by 200s and get an average velocity of 5 m/s, and then they explicitly state, that siad result "doesn't necessarily equal the instantaneous velocities at particular points."
The Khan Academy does not say that you can sum two instantaneous velocities and divide by two, and get an average velocity between the two points. See what you referenced. The first sentence is important pretend you are a physics student.
- [Instructor] Pretend you are a physics student. You are just getting out of class. You were walking home when you remembered that there was a Galaxy Wars marathon on tonight, so you'd do what every physics student would do: run. You're pretty motivated to get home, so say you start running at six meters per second. Maybe it's been a while since the last time you ran, so you have to slow down a little bit to two meters per second. When you get a little closer to home, you say: "No, Captain Antares wouldn't give up "and I'm not giving up either", and you start running at eight meters per second and you make it home just in time for the opening music. These numbers are values of the instantaneous speed. The instantaneous speed is the speed of an object at a particular moment in time.
And if you include the direction with that speed, you get the instantaneous velocity. In other words, eight meters per second to the right was the instantaneously velocity of this person at that particular moment in time.
Note that this is different from the average velocity. If your home was 1,000 meters away from school and it took you a total of 200 seconds to get there, your average velocity would be five meters per second, which doesn't necessarily equal the instantaneous velocities at particular points on your trip.
In other words, let's say you jogged 60 meters in a time of 15 seconds. During this time you were speeding up and slowing down and changing your speed at every moment. Regardless of the speeding up or slowing down that took place during this path, your average velocity's still just gonna be four meters per second to the right; or, if you like, positive four meters per second.
Just as your instantaneous velocity at two discrete and infinitesimal points can not be summed and divided by two to obtain average velocity, the instantaneous slope at two discrete and infinitesimal points will be different and cannot be used to calculate the slope of a traveling bullet whose velocity is contantly changing.
While this bullshit about instantaneous slopes has diverted from your other bullshit about instantaneous velocities, you are still left searching to explain
(1) your calculation used to derive average velocity over the specified distances,
(2) your calculation used to change the formula for calculating average velocity over distance.
Your chart stipulated distance and time.
For 75 feet, you stipulated 0.02 seconds. This is your data, not mine.
Using the formula, d/t=V(avg), that is 3,750 feet per second average velocity.
If we assume that you meant the time to be anything between 0.015 and 0.025 seconds, that is 3000 - 5000 feet per second average velocity.
For 1950 feet, you stipulated 0.86 seconds, and an average velocity of 2367.5926 feet per second, obtained by a formula you can neither present nor explain, nor can you provide any citation to any authority for your bullshit calculation.
V(avg) = d/t = 1950/0.86 = 2267.4418 feet per second average velocity.
If we assume that you meant the time to be anything between 0.855 and 0.865, then,
V(avg) may equal 1950/0.0855 = 2280.7017
V(avg) may equal 1950/0.0865 = 2254.3353
Meanwhile, your bullshit 2367.5926 average velocity allows one to derive the time required to travel 1950 feet. 1950/2367.5926 = 0.823621429 seconds.
Indeed, your second time for Tb, the time of the bullet, in your column E, reflects a bullet flight time of 0.823621 seconds, giving three less decimal points than I did, but rounding the the same precise thing at your chosen four decimal places, indicating how you derived that bullshit Tb from the bullshit average velocity.
To check whether this bullshit time is not impossible with the stipulated data, one need only check if it is within the rounding possibilities of the stipulated data, i.e., from 0.855 to 0.865 seconds. Oh noes, your bullshit average velocity (0.823621) is not possible to reconcile with the stiplulated time, even allowing for the maximum rounding error. Your misbegotten time would round to 0.82 instead of 0.86.
You have yet to explain how you can stipulate a bullet time of 0.86 seconds, and through the magic of VxH formulas, transform that time into 0.823621 seconds, and then use that visibly bullshit time to perform further bullshit calculations.
If the bullet flew 1950 feet in 0.823621, why sure enough it went at an average velocity of 2367.5938 and covered 1950 feet.
However, at the stipulated time of 0.86 seconds, at the bullshit average velocity of 2367.5938 feet per second, the bullet would have flown 2036.1307 feet. The stipulated distance is 1950 feet.
At the maximum rounding down error to 0.855 seconds, at your bullshit average velocity of 2367.5926, the bullet would have flown 2024.292699 feet (0.855 x 2367.5926). The stipulated distance is 1950 feet.
With your stipulated data, you may not have more or less than 1950 feet. You may not have less than 0.855 seconds flight time, nor more than 0.865 seconds flight time. You cannot change the distance the bullet flew, nor do more than consider a rounding error on the time. Your calculated numbers fail miserably.
Your bullshit calculated numbers fall outside the maximum possible error attributable to a rounding error.
Your bullshit calculations result in a new time, not within any rounding error, replacing 0.86 with 0.823621.
Your bullshit average velocity over 1950 feet (2367.5926), at the maximum rounding error for stipulated time (0.86 rounded down to 0.855), requires the bullet to fly a minimum of 2024.292699 feet.
WHY IS YOUR CALCULATED DATA OUTSIDE THE POSSIBLE LIMITS OF A TIME ROUNDING ERROR???
WHY IS YOUR CALCULATED DATA OUTSIDE THE POSSIBLE LIMITS OF A TIME ROUNDING ERROR???
Distance and time specified
Time rounded to plus or minus maximum
Avg velocity
Avg velocity
Avg velocity
time for sound
ABS Tb - Ts
ABS Tb - Ts
ABS Tb - Ts
time as given
max possible
min possible
to travel dist
time as given
max possible
min possible
B
C
D
E
F
G
H
I
J
K
L
N
O
P
d
Time
Time -.005
Time +.005
Avg Vel unadj
Avg Vel max
Avg Vel min
t for sound
ABS Tdiff unadj
ABS Tdiff MAX
ABS Tdiff MIN
VxH Avg Vel
VxH Instant
VxH Tdiff
(ft)
(seconds)
(seconds)
b/c
b/d
b/e
b/1130
ABS(c8-i8)
ABS(d8-i8)
ABS(E8-I8)
Velocity
Tb-Ts
7
0
0.00
3240
8
75
0.02
0.015
0.025
3750.00
5000.00
3000.0000
0.0664
0.0464
0.0514
0.0414
3201.5000
3163
0.0429
9
150
0.05
0.045
0.055
3000.00
3333.33
2727.2727
0.1327
0.0827
0.0877
0.0777
3163.6667
3088
0.0852
10
225
0.07
0.065
0.075
3214.29
3461.54
3000.0000
0.1991
0.1291
0.1341
0.1241
3126.2500
3014
0.1270
11
300
0.10
0.095
0.105
3000.00
3157.89
2857.1429
0.2655
0.1655
0.1705
0.1605
3089.2000
2941
0.1682
12
375
0.12
0.115
0.125
3125.00
3260.87
3000.0000
0.3319
0.2119
0.2169
0.2069
3052.6667
2870
0.2088
13
450
0.15
0.145
0.155
3000.00
3103.45
2903.2258
0.3982
0.2482
0.2532
0.2432
3016.4286
2799
0.2488
14
525
0.18
0.175
0.185
2916.67
3000.00
2837.8378
0.4646
0.2846
0.2896
0.2796
2980.6250
2730
0.2881
15
600
0.20
0.195
0.205
3000.00
3076.92
2926.8293
0.5310
0.3310
0.3360
0.3260
2945.2222
2662
0.3269
16
675
0.23
0.225
0.235
2934.78
3000.00
2872.3404
0.5973
0.3673
0.3723
0.3623
2910.2000
2595
0.3650
17
750
0.26
0.255
0.265
2884.62
2941.18
2830.1887
0.6637
0.4037
0.4087
0.3987
2875.5455
2529
0.4024
18
825
0.29
0.285
0.295
2844.83
2894.74
2796.6102
0.7301
0.4401
0.4451
0.4351
2841.3333
2465
0.4392
19
900
0.32
0.315
0.325
2812.50
2857.14
2769.2308
0.7965
0.4765
0.4815
0.4715
2807.4615
2401
0.4753
20
975
0.36
0.355
0.365
2708.33
2746.48
2671.2329
0.8628
0.5028
0.5078
0.4978
2773.8571
2337
0.5107
21
1050
0.39
0.385
0.395
2692.31
2727.27
2658.2278
0.9292
0.5392
0.5442
0.5342
2740.6000
2275
0.5454
22
1125
0.42
0.415
0.425
2678.57
2710.84
2647.0588
0.9956
0.5756
0.5806
0.5706
2707.6875
2214
0.5794
23
1200
0.46
0.455
0.465
2608.70
2637.36
2580.6452
1.0619
0.6019
0.6069
0.5969
2675.1176
2154
0.6260
24
1275
0.49
0.485
0.495
2602.04
2628.87
2575.7576
1.1283
0.6383
0.6433
0.6333
2642.8889
2095
0.6451
25
1350
0.53
0.525
0.535
2547.17
2571.43
2523.3645
1.1947
0.6647
0.6697
0.6597
2610.9474
2036
0.6768
26
1425
0.56
0.555
0.565
2544.64
2567.57
2522.1239
1.2611
0.7011
0.7061
0.6961
2579.3500
1979
0.7077
27
1500
0.60
0.595
0.605
2500.00
2521.01
2479.3388
1.3274
0.7274
0.7324
0.7224
2548.0952
1923
0.7378
28
1575
0.64
0.635
0.645
2460.94
2480.31
2441.8605
1.3938
0.7538
0.7588
0.7488
2517.1364
1867
0.7671
29
1650
0.68
0.675
0.685
2426.47
2444.44
2408.7591
1.4602
0.7802
0.7852
0.7752
2486.5217
1813
0.7956
30
1725
0.73
0.725
0.735
2363.01
2379.31
2346.9388
1.5265
0.7965
0.8015
0.7915
2456.2500
1760
0.8232
31
1800
0.77
0.765
0.775
2337.66
2352.94
2322.5806
1.5929
0.8229
0.8279
0.8179
2426.3200
1708
0.8499
32
1875
0.81
0.805
0.815
2314.81
2329.19
2300.6135
1.6593
0.8493
0.8543
0.8443
2395.7692
1658
0.8758
33
1950
0.86
0.855
0.865
2267.44
2280.70
2254.3353
1.7257
0.8657
0.8707
0.8607
2367.5926
1609
0.9008
34
2025
0.91
0.905
0.915
2225.27
2237.57
2213.1148
1.7920
0.8820
0.8870
0.8770
35
2100
0.96
0.955
0.965
2187.50
2198.95
2176.1658
1.8584
0.8984
0.9034
0.8934
36
2175
1.01
1.005
1.015
2153.47
2164.18
2142.8571
1.9248
0.9148
0.9198
0.9098
37
2250
1.06
1.055
1.065
2122.64
2132.70
2112.6761
1.9912
0.9312
0.9362
0.9262
Column B of above spreadsheet shows the specified distance and the specified time for that distance.
Column C shows the specified time for the distance traveled.
Column D shows the time rounded down to the minimum time possibly explained by rounding.
Column E shows the time rounded up to the maximum time possibly explained by rounding.
Column F shows the Average Velocity (d/t) calculated with the unadjusted time from Column C.
Column G shows the Average Velocity (d/t) calculated with the minimum time possible from Column D. This minimum time of flight shows the maximum possible average velocity of the bullet.
Column H shows the Average Velocity (d/t) calculsted with the maximum time possible from Column E. This maximum time of flight show the minimum average velocity of the bullet.
Column I shows the time for sound to travel the distance at 1130 fps.
Column J shows the time difference between the bullet and the sound using unadjusted time from Column C.
Column K shows the maximum possible time difference between the bullet and the sound using the time rounded down in Column D.
Column L shows the minimum possible time difference between the bullet and the sound using the time rounded up in Column E.
Column N states VXH Average Velocity using undisclosed math, presumably of Klingon origin.
Column O states the instantaneous velocities at the distances specified in Column B. These velocities reflect a specific and infinitesimal point it time only, and do not describe velocity at any other point in time.
Comparing Columns H and N, Column H calculates the maximum possible average velocity with the time round down as far is is possible. Column N is the average velocity claimed by VxH, using his secret Klingon mathematics.
Notice his secret method obtain an average velocity well below the maximum possible for 75 feet, but comes nearer to the maximum possible with every calculation, and at 1200 feet his calculations leave the realm of the possible.
At 1200 feet, at the specified time of 0.46 seconds, the average velocity would be 2608.70 feet per second (1200/0.46). Anyone can do the arithmetic. At 1200 feet, at 0.46 seconds rounded down as far as possible to 0.455 seconds (Column D), the maximum average veocity of 2637.36 feet per second (Column G) is achieved (2637.36/0.455). Anyone can still do the arithmetic. At this point, the VxH calculations exceed the possibilities of reality and achieve 2675.1176 feet per second.
After this point, every VxH calculation widens the error.
At 1950 feet, the Column G max average velocity is 2280.70 (1950/0.0855). After more calculations, the VxH error expands the difference to 2367.5926 feet per second.
If carried on to further distances, the error will simply keep increasing. He started with 64% of the maximum possible average velocity, and surpassed 100% of the maximum on his 16th calculation, and continued to surpass the maximum possible average velocity by a greater and greater amount.
Notice how VxH, in his calculations, at and after 1200 feet, reduces the time of flight of the bullet by more than any possible amount of rounding from two decimal places.
By 1950 feet, VxH has "rounded off" 0.86 and amazingly reduced the stated flight time to his own preferred 0.82621.
Corrected For Atmosphere Adjusted BC: 0.33 Altitude: 2000 ft Barometric Pressure: 29.92 Hg Temperature: 72° F Relative Humidity: 21% Speed of Sound: 1130 fps
Range
Time
Vel[x+y]
(ft)
(s)
(ft/s)
1875
0.81
1658
1878
0.81
1656
1881
0.82
1654
1884
0.82
1652
1887
0.82
1650
1890
0.82
1648
1893
0.82
1646
1896
0.83
1644
1899
0.83
1642
1902
0.83
1640
1905
0.83
1638
1908
0.83
1636
1911
0.83
1634
1914
0.84
1632
1917
0.84
1630
1920
0.84
1628
1923
0.84
1626
1926
0.84
1624
1929
0.85
1622
1932
0.85
1621
1935
0.85
1619
1938
0.85
1617
1941
0.85
1615
1944
0.86
1613
1947
0.86
1611
1950
0.86
1609
Now tell us, Professor DonkeyChan - from the data provided, what is the average Velocity for the 75 ft segment ending at 1950 ft (1950ft, being the point at which, BTW, the instantaneous velocity is 1609fps)?
Incomplete charts wilt errors constantly changing the data. Yet magically every time you change your numbers they still ,magically work. Give it up you are looking foolish. There is no way for you to prove anything from your keyboard using this method.
Nah, foolish is not knowing that in order to recreate the ballistic data curve (and thus the average Velocity over a given distance) with complete accuracy would require duplicating the function used in the Ballistic chart generator.
Meanwhile, averaging via various methods to get an approximation is completely acceptable - and USEFUL for gaining an understanding into what the audio is telling us.