{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Calibration Data","Cal. Curve Chart (general)","Cal. Curve Chart (<2grain)","Instructions"],"not_rendered":{"charts":4,"defined_names":2},"unopened":[{"sheet":"Cal. Curve Chart (general)","index":1,"reason":"not_a_worksheet"},{"sheet":"Cal. Curve Chart (<2grain)","index":2,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1904"}

{"sheet":"Calibration Data","index":0,"n_rows":45,"n_cols":12,"rows_kept":45,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2]]}
["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:","Arredondo"]
["Brass:  ",".38 Special",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"]
[0.05,0.6,0.6,0.6,null,null,{"$f":"IF(SUM(B6:F6)=0,\"\",AVERAGE(B6:F6))","v":{"v":0.6,"d":"0.60"}},{"$f":"IF(SUM(B6:F6)=0,#N/A,AVERAGE(B6:F6))","v":{"v":0.6,"d":"0.60"}},null,null,"Micrometer Setting Calculator"]
[0.15,0.9,0.9,0.9,null,null,{"v":0.9,"d":"0.90"},null,null,"For ≥2.0 Grains:"]
[0.25,1.1,1.1,1.1,null,null,{"v":1.1,"d":"1.10"},{"$f":"IF(SUM(B8:F8)=0,#N/A,AVERAGE(B8:F8))","v":{"v":1.1,"d":"1.10"}},null,null,"Enter Desired Grains:",{"v":5,"d":"5.0"}]
[0.32,1.4,1.4,1.4,null,null,{"v":1.3999999999999997,"d":"1.40"},{"$nulls":3},"Micrometer Setting =",{"$f":"(L8-G43)/G42","v":{"v":1.995162044842321,"d":"2.00"}}]
[{"v":0.4,"d":"0.40"},1.5,1.5,1.5,null,null,{"v":1.5,"d":"1.50"}]
[{"v":0.5,"d":"0.50"},1.6,1.7,1.6,null,null,{"v":1.6333333333333335,"d":"1.63"},{"$f":"IF(SUM(B11:F11)=0,#N/A,AVERAGE(B11:F11))","v":{"v":1.6333333333333335,"d":"1.63"}},null,"For <2.0 Grains:"]
[0.65,2.1,2.1,2.1,null,null,{"v":2.1,"d":"2.10"},{"$nulls":3},"Enter Desired Grains:",1.5]
[0.75,2.2,2.2,2.2,null,null,{"v":2.2,"d":"2.20"},{"$f":"IF(SUM(B13:F13)=0,#N/A,AVERAGE(B13:F13))","v":{"v":2.2,"d":"2.20"}},null,null,"Micrometer Setting =",{"$f":"(L12-I43)/I42","v":{"v":0.40668802250175784,"d":"0.41"}}]
[0.85,2.6,2.6,2.6,null,null,{"v":2.6,"d":"2.60"}]
[{"v":1,"d":"1.00"},2.8,2.8,2.8,null,null,{"v":2.7999999999999994,"d":"2.80"},{"$f":"IF(SUM(B15:F15)=0,#N/A,AVERAGE(B15:F15))","v":{"v":2.7999999999999994,"d":"2.80"}}]
[1.25,3.4,3.4,3.4,null,null,{"v":3.4,"d":"3.40"},{"v":3.4,"d":"3.40"}]
[{"v":1.5,"d":"1.50"},{"v":4,"d":"4.0"},{"v":4,"d":"4.0"},{"v":4,"d":"4.0"},null,null,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"}]
[1.75,4.6,4.5,4.5,null,null,{"v":4.533333333333333,"d":"4.53"},{"v":4.533333333333333,"d":"4.53"}]
[{"v":2,"d":"2.00"},{"v":5,"d":"5.0"},5.1,{"v":5,"d":"5.0"},null,null,{"v":5.033333333333333,"d":"5.03"},{"v":5.033333333333333,"d":"5.03"}]
[2.25,5.7,5.6,5.7,null,null,{"v":5.666666666666667,"d":"5.67"},{"v":5.666666666666667,"d":"5.67"}]
[{"v":2.5,"d":"2.50"},6.2,6.2,6.2,null,null,{"v":6.2,"d":"6.20"},{"v":6.2,"d":"6.20"}]
[2.75,6.7,6.7,6.7,null,null,{"v":6.7,"d":"6.70"},{"v":6.7,"d":"6.70"}]
[{"v":3,"d":"3.00"},7.3,7.3,7.3,null,null,{"v":7.3,"d":"7.30"},{"v":7.3,"d":"7.30"}]
[3.25,7.9,7.9,7.9,null,null,{"v":7.900000000000001,"d":"7.90"},{"v":7.900000000000001,"d":"7.90"}]
[{"v":3.5,"d":"3.50"},8.4,8.4,8.4,null,null,{"v":8.4,"d":"8.40"},{"v":8.4,"d":"8.40"}]
[3.75,8.9,8.9,8.9,null,null,{"v":8.9,"d":"8.90"},{"v":8.9,"d":"8.90"}]
[{"v":4,"d":"4.00"},9.4,9.4,9.4,null,null,{"v":9.4,"d":"9.40"},{"v":9.4,"d":"9.40"}]
[4.25,{"v":10,"d":"10.0"},9.9,{"v":10,"d":"10.0"},null,null,{"v":9.966666666666667,"d":"9.97"},{"v":9.966666666666667,"d":"9.97"}]
[{"v":4.5,"d":"4.50"},10.5,10.5,10.5,null,null,{"v":10.5,"d":"10.50"},{"v":10.5,"d":"10.50"}]
[4.75,{"v":11,"d":"11.0"},{"v":11,"d":"11.0"},{"v":11,"d":"11.0"},null,null,{"v":11,"d":"11.00"},{"v":11,"d":"11.00"}]
[{"v":5,"d":"5.00"},11.5,11.5,11.5,null,null,{"v":11.5,"d":"11.50"},{"v":11.5,"d":"11.50"}]
[5.25,{"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":5.5,"d":"5.50"},12.6,12.5,12.6,null,null,{"v":12.566666666666668,"d":"12.57"},{"v":12.566666666666668,"d":"12.57"}]
[5.75,13.1,13.1,13.1,null,null,{"v":13.1,"d":"13.10"},{"v":13.1,"d":"13.10"}]
[{"v":6,"d":"6.00"},13.6,13.6,13.6,null,null,{"v":13.6,"d":"13.60"},{"v":13.6,"d":"13.60"}]
[6.25,{"v":14,"d":"14.0"},14.1,14.1,null,null,{"v":14.066666666666668,"d":"14.07"},{"v":14.066666666666668,"d":"14.07"}]
[{"v":6.5,"d":"6.50"},14.5,14.5,14.5,null,null,{"v":14.5,"d":"14.50"},{"v":14.5,"d":"14.50"}]
[6.75,14.9,{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},null,null,{"v":14.966666666666667,"d":"14.97"},{"v":14.966666666666667,"d":"14.97"},"< Maximum micrometer setting possible with Arredondo Powder Drop Slide"]
[{"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"},"<2.0 Grains"]
[{"$nulls":5},"Slope (m) =",{"$f":"IF(SUM(G6:G41)=0,\"\",SLOPE(G6:G41,A6:A41))","v":{"v":2.1568237704639115,"d":"2.1568"}},null,{"$f":"IF(SUM(G6:G12)=0,\"\",SLOPE(G6:G12,A6:A12))","v":{"v":2.404380823564773,"d":"2.4044"}}]
["Copyright 2004 by UniqueTek, Inc.",{"$nulls":4},"y-intercept =",{"$f":"IF(SUM(G6:G41)=0,\"\",INTERCEPT(G6:G41,A6:A41))","v":{"v":0.6967870757566974,"d":"0.6968"}},null,{"$f":"IF(SUM(G6:G12)=0,\"\",INTERCEPT(G6:G12,A6:A12))","v":{"v":0.5221671175232946,"d":"0.5222"}}]
["Rev. 3   3/2/07",{"$nulls":4},"R2 =",{"$f":"IF(SUM(G6:G41)=0,\"\",RSQ(G6:G41,A6:A41))","v":{"v":0.9993898043041517,"d":"0.999390"}},null,{"$f":"IF(SUM(G6:G12)=0,\"\",RSQ(G6:G12,A6:A12))","v":{"v":0.9844424235702346,"d":"0.984442"}},"Charge weight values should be considered supspect if R2 values "]
[{"$nulls":9}," are less than .995."]

{"sheet":"Instructions","index":3,"n_rows":48,"n_cols":1,"rows_kept":48}
["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 incriments)."]
[]
["Powder Weights Below 2.0 Grains"]
["If you are loading powder weights below about 2.0 grains, it is highly recommend that you generate a calibration curve"]
["covering just that range of powder weights and use smaller micrometer increments. It is also recommended that you use"]
["a high-precision powder scale with accuracy better than 0.1 grain. A scale with 0.05 grain or, better yet, 0.02 grain "]
["accuracy is recommended. It should be noted that ony fine grained gunpowders are likely to meter accurately at these  "]
["small powder wieghts."]
[]
["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."]
[]
["Copyright 2004 by UniqueTek, Inc."]
["Rev. 3   3/2/07"]