While waiting & prepping to go to the range later this week decided to play with a spreadsheet Just for Load development and have it actually do a graph.
At first I attempted to attach the file in this post ... nope not supported (fully understand why too.) being lazy I didn't "zip" it so it would attach...
so figured I would just do a cut and paste of the first ladder so I'll show the graph first then data below ... (just to give a idea , I used data from the first post in the make up of this spreadsheet as it was still relevant).
ladder 1 LC LR Brass CBTO 2.360" CCI primer (TAC powder)..
41.0 = 2557
41.3 = 2584
41.6 = 2589
41.9 = 2643
42.2 = 2604
42.5 = 2702
42.8 = 2717
43.1 = 2694
43.4 = 2699
43.7 = 2716
44.0 = 2786
44.3 = 2764
Like below the spreadsheet is way cleaner easier to read and the graph of the incremental shot makes way more sense and easier to see the velocity node / plateau than what is shown above.
----------------------------------------------------------------------------------------------------------------------------------------------
Then I went and actually configured one sheet to calculate 5 shot groups (as in group #'s) into Mean Radius, and then MOA
SAMPLE with made up data just to check function and see if it will cleanly paste on here...
Caliber | .308 Win | Powder | TAC | Charge Wgt(gr) | 42.3 | Primer | CCI LR | NOTE: setup for 5 shot groups only NO 3 shot groups | | | | | | |
CBTO | 2.360 | COAL | -------- | Case | Lake City LR M118 | | | | | | | | | |
Bullet | 175gr SMK BTHP | SKU | 2155 | SUMMARY | | | | | | | | | | |
Group # | Caliber Bore (in) | Distance | Unit (Y/M) | Horizontal Spread (in) | Vertical Spread (in) | Diagonal Spread | Est. Mean Radius | Est. MOA | Average Mean Rad | Best mean Radius | Worst mean radius | Average MOA | Best MOA | Worst MOA |
1 | 0.308 | 100 | Y | 1.000 | 0.350 | 0.693 | 0.201 | 0.661 | 0.257 | 0.149 | 0.386 | 0.521 | 0.358 | 0.661 |
2 | 0.308 | 100 | Y | 0.950 | 0.350 | 0.643 | 0.187 | 0.613 | | | | | | |
3 | 0.308 | 100 | Y | 0.800 | 0.450 | 0.512 | 0.149 | 0.470 | | | | | | |
4 | 0.308 | 200 | Y | 1.500 | 0.900 | 1.331 | 0.386 | 0.569 | | | | | | |
5 | 0.308 | 200 | Y | 1.058 | 0.900 | 0.955 | 0.277 | 0.358 | | | | | | |
6 | 0.308 | 200 | Y | 1.260 | 1.000 | 1.177 | 0.341 | 0.455 | | | | | | |
Not exactly as it looks in the spreadsheet which IMHO looks cleaner and easier to read. But that cut and paste sorta works to get the idea across. and yes the math in the spreadsheet WILL Correct for meters, but I sort of Locked the group measurements to inches (imperial decimal) , Yes the column with Caliber bore (in) does subtract the bore dia of the bullet from the group measurement. Also MOA is calculate at 1.047" not 1.0". Yes when you input say 100 or 200 or even 25 yards the formulas will actually calculate the MOA based on input distance, as one can note above when I changed the yardage to 200. Just a tool for ease, tracking data points on the load I suppose . In what I used above 6 groups of five shots is demonstrative of a 30 shot string. Which honestly doesn't have to be fired back to back. One could take what ever time they desired say over a week, a month, or even the life of the rifle..
There is actually a purpose to this thread even if it's drifting a bit it is to show the homework of evaluating TAC for my rifle in that caliber and my methods.
The reason I'm doin 0.3 increments VS what say Gavin on Ultimate Reloader (youtube) system of 0.1 increments is actually simple . HIS scale (laboratory grade) is accurate to +/- 0.01 grs , mine yeah I don't have that amount of money mine is accurate to +/- 0.1grs (which honestly is well good enough for my pursuits).