Looks good. Congrats! Maybe I have to learn VB and macros.
Video has no audio which makes it tough!
Keyboard command to run macros did not work. Probably because stupid Microsoft changes things every version. Opening the macro pulldown and selecting which macro did work, and then 'run' it.
Took me a bit to figure out both sheets must (?) be open to run the macro. And Excel attention needs (?) to be focused on the tracking sheet.
The green and red boxes truncated my V to only 3 digits.
Just started playing with it, so I may have other comments.
Want to check my hypothesis with you on how LabRadar works:
At the core measurement level, all it is doing is capturing V (based on doppler return) every millisecond.
It DOES NOT capture distance downrange. In other words, x(t) is not captured.
Just like we know it back calculates vMuzzle, it also back calculates the 'distance' column in the track file. So, x(t) is a derived column, not measured.
LR knows distance from muzzle to LR because user enters it as a setting. Given ballpark value of c, if you are one foot away, LR adjusts its time values accordingly by about one ms. The error introduced here, if any, can be ignored - it's only a couple fps.
When trigger signal arrives, an internal counter is started. For some number of ms (10 to 20ms) the LR is not seeing radar returns until the bullet gets in the radar cone cleanly. Then it's off to the races filling its internal array. I suspect this is done in software as hardware would be painful to design cheaply.
To state my above point on x(t) differently: If you know v(t), you can integrate to determine x(t). Just like if you know x(t) you can differentiate to get v(t). (Or a(t) for that matter.)
Separate point based on above: YOUR analysis should not use the distance column because it is based on LR's computed values for distance. If you suspect LR is producing 'some' bad data, your algorithm should not use data (the distance column) based on said bad data. I have no idea if your alg does in fact use the LR distance data.
Again, nice job!
--jim