{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Calibration Data","Calibration Curve Chart New","Instructions"],"not_rendered":{"charts":2,"defined_names":2},"unopened":[{"sheet":"Calibration Curve Chart New","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1904"}

{"sheet":"Calibration Data","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[5,9,5,11],[6,9,6,10],[7,9,7,10]]}
[]
["Powder:","Win 231",null,null,"Note: Data for Win 231 if only an example. You must generate data using your own powder bar."]
["Powder Bar:","Small"]
["Brass:",".357 Magnum",null,null,"Note: Use a cartridge case with enough capacity to hold the largest powder charge thrown."]
[]
["Micrometer\nSetting **","Charge #1","Charge #2","Charge #3","Charge #4","Charge #5","Avg. Charge\nWeight","Avg. Charge\nWeight",null,"Micrometer Setting Calculator"]
[{"v":0,"d":"0.00"},2.6,2.6,2.6,null,null,{"$f":"IF(SUM(B7:F7)=0,\"\",AVERAGE(B7:F7))","v":{"v":2.6,"d":"2.60"}},{"$f":"IF(SUM(B7:F7)=0,#N/A,AVERAGE(B7:F7))","v":{"v":2.6,"d":"2.60"}},null,"Enter Desired Grains:",null,{"v":10,"d":"10.00"}]
[0.25,3.3,3.3,3.3,null,null,{"v":3.2999999999999994,"d":"3.30"},{"$f":"IF(SUM(B8:F8)=0,#N/A,AVERAGE(B8:F8))","v":{"v":3.2999999999999994,"d":"3.30"}},null,"Micrometer Setting =",null,{"$f":"(L7-G39)/G38","v":{"v":2.939577683658857,"d":"2.94"}}]
[{"v":0.5,"d":"0.50"},{"v":4,"d":"4.0"},3.9,{"v":4,"d":"4.0"},null,null,{"v":3.966666666666667,"d":"3.97"},{"$f":"IF(SUM(B9:F9)=0,#N/A,AVERAGE(B9:F9))","v":{"v":3.966666666666667,"d":"3.97"}}]
[0.75,4.5,4.6,4.6,null,null,{"v":4.566666666666666,"d":"4.57"},{"$f":"IF(SUM(B10:F10)=0,#N/A,AVERAGE(B10:F10))","v":{"v":4.566666666666666,"d":"4.57"}},null,"To calculate micrometer settings manually use "]
[{"v":1,"d":"1.00"},5.2,5.2,5.2,null,null,{"v":5.2,"d":"5.20"},{"$f":"IF(SUM(B11:F11)=0,#N/A,AVERAGE(B11:F11))","v":{"v":5.2,"d":"5.20"}},null,"this equation:"]
[1.25,5.9,5.9,5.8,null,null,{"v":5.866666666666667,"d":"5.87"},{"v":5.866666666666667,"d":"5.87"},null,"Micrometer Setting = (Powder Weight – b)"]
[{"v":1.5,"d":"1.50"},6.5,6.4,6.4,null,null,{"v":6.433333333333334,"d":"6.43"},{"v":6.433333333333334,"d":"6.43"},{"$nulls":3},"m"]
[1.75,7.1,7.1,7.1,null,null,{"v":7.099999999999999,"d":"7.10"},{"v":7.099999999999999,"d":"7.10"},null,"b = y-intercept"]
[{"v":2,"d":"2.00"},7.7,7.7,7.7,null,null,{"v":7.7,"d":"7.70"},{"v":7.7,"d":"7.70"},null,"m = slope"]
[2.25,8.4,8.4,8.4,null,null,{"v":8.4,"d":"8.40"},{"v":8.4,"d":"8.40"}]
[{"v":2.5,"d":"2.50"},{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},null,null,{"v":9,"d":"9.00"},{"v":9,"d":"9.00"}]
[2.75,9.6,9.6,9.6,null,null,{"v":9.6,"d":"9.60"},{"v":9.6,"d":"9.60"}]
[{"v":3,"d":"3.00"},10.2,10.2,10.2,null,null,{"v":10.2,"d":"10.20"},{"v":10.2,"d":"10.20"}]
[3.25,10.8,10.9,10.8,null,null,{"v":10.833333333333334,"d":"10.83"},{"v":10.833333333333334,"d":"10.83"}]
[{"v":3.5,"d":"3.50"},11.4,11.4,11.4,null,null,{"v":11.4,"d":"11.40"},{"v":11.4,"d":"11.40"}]
[3.75,{"v":12,"d":"12.0"},{"v":12,"d":"12.0"},{"v":12,"d":"12.0"},null,null,{"v":12,"d":"12.00"},{"v":12,"d":"12.00"}]
[{"v":4,"d":"4.00"},12.6,12.5,12.6,null,null,{"v":12.566666666666668,"d":"12.57"},{"v":12.566666666666668,"d":"12.57"}]
[4.25,13.2,13.3,13.2,null,null,{"v":13.233333333333334,"d":"13.23"},{"v":13.233333333333334,"d":"13.23"}]
[{"v":4.5,"d":"4.50"},13.7,13.8,13.8,null,null,{"v":13.766666666666666,"d":"13.77"},{"v":13.766666666666666,"d":"13.77"}]
[4.75,14.4,14.4,14.5,null,null,{"v":14.433333333333332,"d":"14.43"},{"v":14.433333333333332,"d":"14.43"}]
[{"v":5,"d":"5.00"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},15.1,null,null,{"v":15.033333333333333,"d":"15.03"},{"v":15.033333333333333,"d":"15.03"}]
[5.25,15.7,15.7,15.7,null,null,{"v":15.699999999999998,"d":"15.70"},{"v":15.699999999999998,"d":"15.70"},"←Note: Maximum micrometer setting possible with Small Powder Bar"]
[{"v":5.5,"d":"5.50"},{"$nulls":5},"",{"$error":"#N/A"}]
[5.75,{"$nulls":5},"",{"$error":"#N/A"}]
[{"v":6,"d":"6.00"},{"$nulls":5},"",{"$error":"#N/A"}]
[6.25,{"$nulls":5},"",{"$error":"#N/A"}]
[{"v":6.5,"d":"6.50"},{"$nulls":5},"",{"$error":"#N/A"}]
[6.75,{"$nulls":5},"",{"$error":"#N/A"}]
[{"v":7,"d":"7.00"},{"$nulls":5},"",{"$error":"#N/A"}]
[7.25,{"$nulls":5},"",{"$error":"#N/A"}]
[{"v":7.5,"d":"7.50"},{"$nulls":5},"",{"$error":"#N/A"}]
[{"$nulls":5},"Slope (m)",{"$f":"IF(SUM(G7:G37)=0,\"\",SLOPE(G7:G37,A7:A37))","v":{"v":2.4708450969320537,"d":"2.4708"}}]
["© 2004-2012 UniqueTek, Inc.",{"$nulls":4},"y-intercept (b)",{"$f":"IF(SUM(G7:G37)=0,\"\",INTERCEPT(G7:G37,A7:A37))","v":{"v":2.73675889328063,"d":"2.7368"}}]
["Rev. 4   4/16/12",{"$nulls":4},"R2",{"$f":"IF(SUM(G7:G37)=0,\"\",RSQ(G7:G37,A7:A37))","v":{"v":0.9997870226040091,"d":"0.999787"}},null,"Charge weight values should be considered supspect if R2 is less than 0.995."]

{"sheet":"Instructions","index":2,"n_rows":41,"n_cols":1,"rows_kept":41}
["Instructions for using the Calibration Curve spread sheet"]
[]
["1.  Clear any charge weight data already in the data cells. "]
["    Note: The data for Win 231 included in this spread sheet is only an example.  Due to the small differences"]
["             between powder bars, you must generate data for Win 231 using your own powder bar."]
[]
["2.  Enter data into the Charge Weight cells."]
["     • Weigh at least 3 powder charges at each micrometer setting."]
["     • Cells for up to 5 charge weights at each micrometer setting have been included, but you don't have to fill them all."]
["     • If you are creating a Calibration Curve for the entire micrometer setting range, you can weigh charges at just the"]
["        micrometer settings in bold. This will yield sufficient accuracy to target new powder charge weights with the "]
["        minimum work."]
[]
["3.  When all charge weight data has been entered, you can calculate the micrometer setting for any charge weight you "]
["     desire by entering the charge weight into the Micrometer Setting Calculator to the right of the data table."]
[]
["Caution:  Even when using a Calibration Curve containing data you generated yourself, you must weigh the powder to"]
["              confirm the powder weight every time you change the micrometer setting."]
[]
["A Word On Accuracy "]
["Due to the numerous factors that influence powder bar accuracy, a single calibration curve covering the entire range"]
["of micrometer settings, may not yield the best accuracy over a narrow range of powder weights. When loading a narrow"]
["range of powder weights (e.g. 4.0 to 5.0 grains), you will obtain much better accuracy if you make a Calibration Curve"]
["that covers a limited range of powder weights (say from 3.5 to 5.5 grains), and measure powder charges at more "]
["closely spaced micrometer settings (e.g. 0.25 or 0.20 increments)."]
[]
["Modifying This Spread Sheet"]
["You are free to modify this spread sheet in any manner that suits you for your own personal use."]
["You may not distribute modified versions of this spread sheet in any form either electronic or paper."]
["You must turn off \"protection\" first by selecting Tools>Protection>Unprotect Sheet. There is no password protection."]
["This spread sheet is provided as an Excel \"template\", so every time you open it, it will open with the set of example data."]
["You can delete the example data, then save the sheet again as a template by selecting File>Save As and setting the "]
["File Type to Template.  The new template will open with empty data cells."]
[]
["Disclaimer: The author of this spread sheet (UniqueTek, Inc.) believes all information and formulas to be true and accurate. However, UniqueTek, Inc. assumues"]
["no liability for damages or personal injury that may be incurred as a result of using this spread sheet or the Micrometer Powder Bar Kit in an improper way, or"]
["in an reloading press that has been improperly maintained or operated. It is your responsibility to ensure that your reloading equipment is properly assembled, is "]
["maintained in proper working condition, and is used according to the manufacturer’s instructions and safe reloading practices."]
[]
["© 2004-2012 by UniqueTek, Inc."]
["Rev. 4    4/16/12"]