I am basically lazy, so I don't like to redo things.
So I made up the attached Excel form to figure out the powder charge increments to run an OCW.
On the top section, there are spaces to fill in the various information so if you print or save it, you know what caliber, bullet, and powder it is for.
The only field that is required, is the Max charge weight field. From that, the spreadsheet calculates based on the OCW instructions page. The first weight is 10% less than Max. The next is 2% above that, the next is another 2% jump. Then you have a choice of .7% .85% or 1% increases for the next rounds. OCW instructions say use .7 - 1.0% increases, and .85% is the middle point between .7 and 1.0.
The spreadsheet checks the previous charge weight, and if it is above the Max, then it shows 0.0 for the rest of the increments. The OCW instructions say to load to the increment that just exceeds the max.
It tells you how many to load at each increment and a running total of rounds to a given increment.
Enjoy.
Version 1.02 - I added a section to put in the data from several sources for Min and Max Charge Weight. The spreadsheet then gives you the Average Max Charge Weight, the Low and High Max Charge Weights. YOU have to pick the one you want and put in the lower Max box to calculate the OCW loads.
Version 1.02a - Fixed problem with 1% column. Also added .xls version for those with older versions of Excel.
Version 1.02b - Fixed problem with indicating the highest max charge.
View attachment OCW v1.02b.zip
So I made up the attached Excel form to figure out the powder charge increments to run an OCW.
On the top section, there are spaces to fill in the various information so if you print or save it, you know what caliber, bullet, and powder it is for.
The only field that is required, is the Max charge weight field. From that, the spreadsheet calculates based on the OCW instructions page. The first weight is 10% less than Max. The next is 2% above that, the next is another 2% jump. Then you have a choice of .7% .85% or 1% increases for the next rounds. OCW instructions say use .7 - 1.0% increases, and .85% is the middle point between .7 and 1.0.
The spreadsheet checks the previous charge weight, and if it is above the Max, then it shows 0.0 for the rest of the increments. The OCW instructions say to load to the increment that just exceeds the max.
It tells you how many to load at each increment and a running total of rounds to a given increment.
Enjoy.
Version 1.02 - I added a section to put in the data from several sources for Min and Max Charge Weight. The spreadsheet then gives you the Average Max Charge Weight, the Low and High Max Charge Weights. YOU have to pick the one you want and put in the lower Max box to calculate the OCW loads.
Version 1.02a - Fixed problem with 1% column. Also added .xls version for those with older versions of Excel.
Version 1.02b - Fixed problem with indicating the highest max charge.
View attachment OCW v1.02b.zip
Last edited: