(07-01-2024, 11:18 PM)BD1 Wrote: happy to give you feedback, but you will need to explain to this luddite how it works. I can copy it, but I still cannot modify any of the values
Well, first of all, I,m not sure what a luddite is, and may be one myself. Im assuming that you can open the file and that you see the table I generated ( see attached image).
At the very top of each column are letters … A throo J that has stuff below them. In the sheet you should be able to modify any cell(box) in columns A throo E and the rest of the numbers will be calculated.
Each row is a barrel and cartridge parameters comb that you plan on using.
First enter your barrel length by clicking in the …. A2 box and change the number to reflect the barrel length of your rifle. B2 … enter your COAL you just loaded; C2 bullet length you loaded and D2 …. your CBTO. In E2 you start with a guess as to which node will work … so guess node 7 to start
Go to the range and shoot 3-5 rounds of the ammo you just loaded and get the average MV.
Compare your average MV to the value in H2. When you are close to a node, measured MV will be close to the H2 value. If your MV is far from the node MV, change the node number to the nodes closest to your initial measured MV.
Then create a ladder test that will cover the MV from min I2 to max J2. Your ladder test you should hit a load recipe that produces statistical consistent results.