Once the data is typed into the actual spreadsheet, it can be used in the other spreadsheets automatically. I usually load up ten rounds each of ten different loadings, so the spreadsheets are designed around that, though they could be modified for whatever protocol a person wanted.
By entering 'A' through 'J' on this page I can pull up one specific load (of the ten) and look at the data to see if there are any obvious odd-balls that I should legitimately 'skip' when analyzing the data. I can also skip an entire load, if for instance I shot it in a different firearm (as happened with the 300 Blk range session). If I decide to skip a particular shot as an outlier, it is omitted from the subsequent sheets, but can be restored by simply un-checking the 'skip' box.
Then I can look at the velocity trends vs. powder charge for all loads; interesting how much more consistent the loads got with 'hotter' charges, AND how they were pretty consistent with the semiautos vs. the Encore.
Finally it displays ALL the hundred shots on one scatter-graph so I can get an idea once again of consistency and outliers.
I know many reloading software programs do this type stuff, but I just wanted to do it my particular way. If anyone is interested in the specifics, I think I can email the spreadsheet(s).
