Hi @roger-knight
I can see you’re upset, it wasn’t my intention. That spreadsheet was made to test out scenarios, and your latest data passed with flying colors against ballistic drop for the 55grains 5.56 ammo that I use, btw. (HowDoIKnow’s scenario flopped on that Aug15th try). About the spreasheet, I use the “extra” lines on the spreadsheet to add or subtract many values while I check theories against ballistic data, without having to delete the values that are being agreed upon by the community. As you have explained, the ground elevations you use on your drawings, ALREADY have those “AGRdifference” heights for trump and rail in them, so what you see there on that previous post 1123 is that I tested out a scenario where I add them again, for a second time, (as you have observed and pointed out), and I found it curious that when I did so, the Crooks trajectory worked. Both theories work with that particular alteration to the testing spreadsheet (p. It doesn’t mean one or the other is already wrong, we would just need to confirm those elevations. Your elevations being correct, I will agree with you on the vent theory. Should elevations be flatter, then Crooks seems more likely to me. After elevations then we could test windage, but I believe elevations need to work out first, otherwise it could be pointless to do more complicated work before the simpler work fits.
How about this, I’ll upload a new one right below that I made with better wording, what do you think? This one also has some change tracking of your drawings to the right of the ballistic data. Maybe I could ask some questions about those AGRdifferences and also about the recent changes since Aug15th?
a) how did you get to those AGRdifferences for Trump and Rail? (Ref 402 and Ref 690). I know they’re offsets from considering AGR6 on ground level 0, and what their purpose is (to backtrace), but how did you get to those numbers 2,185 and 1,17 mathematically? As you mentioned you used data provided by a company for the elevation of AGR6, but why did you have to come up with an offset if the company had topographical data of the area?
b) I noticed you changed the position of the vent 0,14 feet up since August 15th. What did I miss? I also noticed some increases on some items (see columns AC to AE on the spreadsheet below, please).
Oh, and for @sonjax6 and @kincses-zsolt, our math wizards, if you guys could, when you have a little time, could you check the approach for rotating the trajectory of the bullet on columns X and AA, please ? (angle and radians above the header). No need to summon R. Feynman for ultra high-end precision work, just a reasonable-sanity-check…