{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Documentation","Report","Prover Data Entry","NSCV Data Entry","Calculations","Uncertainty Analysis","Standards","Tables & Lists"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":3,"defined_names":101,"comments":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Documentation","index":0,"n_rows":1,"n_cols":8,"rows_kept":1,"flags":["formulas_cached_only"]}
["Documentation",{"$nulls":6},""]

{"sheet":"Report","index":1,"n_rows":55,"n_cols":5,"rows_kept":55,"merged":[[2,4,3,4],[13,0,16,2],[15,3,15,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[29,0,29,4],[42,0,42,4],[45,0,45,4],[47,0,47,4],[49,0,49,4]],"flags":["formulas_cached_only"]}
[null,null,"YOUR"]
[null,null,"LABORATORY"]
[null,null,"ADDRESS"]
[null,null,"AND CONTACT INFORMATION"]
[]
[null,null,"Report of Calibration #: "]
["Calibration Date",{"$nulls":3},"Calibration Due Date"]
["Artifact"]
["Test Item…….:",null,null,"Manufacture.:"]
["Volume…........:",null,null,"Material…….:"]
["Serial Number.:",null,null,"Specification:  "]
["Date Received:"]
["Submitted By"]
["Name & Address:",null,null,"Purchase Order #:"]
[{"$nulls":3},"Point of Contact..:"]
[{"$nulls":3},""]
[]
["Artifact Calibration Results"]
["\nNominal\nVolume"," Volume\nAs Found @  ºF\n (gal)"," Volume\nAs Left @  ºF\n (gal)","Specification\nTolerance\n± (gal)","Uncertainty\nk=2\n± (gal)"]
["","","","",""]
["Calibration Notes"]
["●  The artifact is considered in-tolerance when the error is equal to or less than the specified tolerance minus the measurement\n    uncertainty. Bold print indicates an out-of-tolerance reading."]
["●  The  'As Left' volume is 'In-Tolerance', the prover may be used in meter testing without a correction."]
["●  The Scale Calibration Seal Number is "]
["●  The Neck Scale Calibration Value (NSCV) = "]
["●  To use the Neck Scale Plate Calibration Factor, multiply the reading you see on the neck scale plate times the calibration factor.\n    The result is the reading you would use. A Neck Scale Plate Calibration Factor of 1.0 means the neck scale can be read directly."]
["●  The calibration item was calibrated in a wet down condition using water. The  delivers the stated volume\n    at the reference temperature is when it is drained for a 30 (± 5) second period after cessation of the main flow."]
["Calibration Conditions"]
["Technician……...…...:",{"$nulls":3},"Procedure:  NIST HB 145, SOP 19"]
["Condition of Artifact:"]
["Temperature………....:",null,"Humidity:",null,"Water Temperature:"]
["Laboratory Volume Standard(s) Used"]
["Description","Serial Number","Report Number","Date Calibrated","Date Calibration Due"]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["Laboratory Temperature Standard(s) Used"]
["Description","Serial Number","Report Number","Date Calibrated","Date Calibration Due"]
["","","","",""]
["","","","",""]
["Relevant Information"]
["●  In-accordance-with ISO/IEC FDIS 17025, General Requirements for the Competence of Testing and Calibration\n    Laboratories, paragraph 5.10.4.4 ‘A calibration certificate (or calibration label) shall not contain any\n    recommendation on the calibration interval except where this has been agreed with the client. This requirement\n    may be superseded by legal regulations.’ "]
["●  The results listed in this report relate only to the artifacts described and extent of calibrations performed."]
["Traceability Statement"]
["The item(s) listed above have been compared to the Standards of the State of YOUR-STATE. The Standards of the State of YOUR-STATE are traceable to the National Institute of Standards and Technology (NIST) and are part of a comprehensive measurement assurance program for ensuring continued accuracy and measurement traceability within the level of uncertainty reported by this laboratory. The report of calibration number identified in the title of this report is the unique report number to be used in referencing measurement traceability for the artifact(s) identified in this report only."]
["Uncertainty Statement"]
["The combined standard uncertainty includes uncertainties reported for the standard, uncertainties associated with the measurement process,  uncertainties for any observed deviations from reference values which are less than surveillance limits, and other uncertainties associated with the particular artifact (i.e., reading meniscus, air buoyancy corrections, etc.). A component for viscosity is not included in the uncertainty budget. The combined standard uncertainty is multiplied by k, a coverage factor of 2, to give the expanded uncertainty (which defines an interval with an approximate 95 percent level of confidence). The expanded uncertainty presented in this report is consistent with NIST Technical Note 1297."]
["Certification Statement"]
["Accredited by the National Institute of Standards and Technology (NIST) through the National Voluntary Laboratory Accreditation Program (NVLAP) for the specified scope of accreditation under lab code YOUR-LAB-CODE. This laboratory meets the requirements of ISO/IEC 17025 and ANSI/NCSL Z540-1. This report may not be used to claim product endorsement by NVLAP or any other government agency, and may not be reproduced, except in full, without written approval from the laboratory."]
[]
[]
[]
[]
["State Metrologist"]

{"sheet":"Prover Data Entry","index":2,"n_rows":71,"n_cols":10,"rows_kept":71,"merged":[[0,8,0,9],[3,0,6,1],[3,2,6,6],[3,8,3,9],[4,8,4,9],[5,8,5,9],[9,0,9,1],[9,2,9,5],[9,6,9,7],[9,8,9,9],[10,0,10,1],[10,2,10,5],[10,6,10,8],[11,0,11,1],[11,2,11,5],[11,6,11,8],[12,0,12,1],[12,2,12,5],[12,6,12,7],[12,8,12,9],[13,0,13,1],[13,2,13,9],[14,0,14,1],[14,2,14,4],[14,5,14,7],[14,8,14,9],[15,0,15,7],[15,8,15,9],[16,0,16,2],[16,3,16,4],[16,5,16,7],[16,8,16,9],[17,0,17,7],[17,8,17,9],[18,0,18,4],[18,6,18,8],[19,0,19,2],[19,3,19,4],[19,5,19,6],[19,7,19,9],[22,0,22,9],[23,1,23,2],[23,6,23,7],[24,1,24,2],[24,6,24,7],[25,1,25,2],[25,6,25,7],[26,1,26,2],[26,6,26,7],[27,1,27,2],[27,6,27,7],[30,0,30,3],[30,4,30,5],[30,6,30,7],[30,8,32,9],[31,0,31,2],[31,4,31,5],[31,6,31,7],[32,0,32,2],[32,4,32,5],[32,6,32,7],[34,0,34,9],[35,0,35,9],[36,0,36,3],[36,4,36,5],[36,6,36,9],[37,0,37,9],[38,0,38,9],[41,0,41,1],[41,2,41,4],[41,5,41,6],[41,7,41,9],[44,0,44,4],[44,5,44,9],[63,0,63,4],[63,5,63,9],[64,0,64,3],[64,5,64,8],[65,0,65,3],[65,5,65,8],[66,0,66,3],[66,5,66,8],[67,0,67,3],[67,5,67,8],[68,0,68,3],[68,5,68,8],[69,0,69,4],[69,5,69,9],[70,0,70,3],[70,5,70,7],[70,8,70,9]],"flags":["formulas_cached_only"]}
["Prover Data Entry",{"$nulls":6},"Report Number:"]
[]
["Customer Information"]
["Name and Address\n(use ALT+ENTER\n for line breaks)",{"$nulls":6},"PO#"]
[{"$nulls":7},"POC"]
[{"$nulls":7},"Phone"]
[]
[]
["Artifact and Measurement Information"]
["Description",{"$nulls":5},"Date Received"]
["Manufacture",{"$nulls":5},"Nominal Volume (gal)"]
["Serial Number",{"$nulls":5},"Scale Graduations (in³)"]
["Prover Material",{"$nulls":5},"CCE (β) (/ ºF) =",null,""]
["Artifact Condition"]
["Artifact Specification",{"$nulls":4},"Specification Tolerance (% of capacity)"]
["Designated Reference Temperature For This Calibration (ºF)"]
["Range Mean from CC (in³)",{"$nulls":4},"No. of Duplicate Sets from CC"]
["Accredited (e.g. NVLAP, A2LA, etc.) Best Uncertainty for this Calibration (gal)"]
["Was a Calibration Interval Requested or is one Required?",{"$nulls":5},"What is the Interval (months)?"]
["Calibration Date",{"$nulls":4},"Technician"]
[]
["Volume Standard(s) Data"]
["Note: If ID Code cell turns RED the standard calibration is void, calibrate before use."]
["ID Code","Description",null,"Volume (Vs @ trefs) \n(gal)","Scale\nGraduations \n(gal)","Drops","Cubical Coefficient of Expansion (α)\n(/ ºF)",null,"Unc\n(gal)","k-factor"]
[null,"",null,0,0,null,0,null,0,1]
[null,"",null,0,0,null,0,null,0,1]
[null,"",null,0,0,null,0,null,0,1]
[null,"",null,0,0,null,0,null,0,1]
[]
["Temperature Standard(s) Data"]
["Water Temperature Standard ID Code",{"$nulls":3},"Correction\n(ºC)",null,"Accuracy\n(ºC)",null,"Note: If ID Code cell turns RED the standard calibration is void, calibrate before use."]
["Used For Volume Standand(s)",{"$nulls":3},"",null,""]
["Used For Prover",{"$nulls":3},"",null,""]
[]
["Neck Scale Plate Verification"]
["Note: If not previously performed complete  Neck Scale Plate Verification (NSCV Data Entry tab)"]
["Enter Neck Scale Calibration Value (NSCV)",{"$nulls":5},"Must equal at least 1 for nominal NSCV"]
["NOTICE: If the NSCV is anything other than nominal (1) you must include it in the\n Report of Calibration along with the following statement or something similar:"]
["\"To use the Neck Scale Plate Calibration Value, multiply the reading you see on the neck\n scale plate times the calibration value. The result is the reading you would use.\n A Neck Scale Plate Calibration Value of 1.0 means the neck scale can be read directly.\""]
[]
["Laboratory Test Conditions"]
["Temperature (ºC)",{"$nulls":4},"Humidity (% RH)"]
[]
["Standard(s) Observations"]
["Trial 1",{"$nulls":4},"Trial 2"]
["Drop Number","ID\nCode","Volume \n(Vs @ trefS) \n(gal)","Water Temp.\n(ºC)","Delta (Δ)\n(in³)","Drop Number","ID\nCode","Volume \n(Vs @ trefS) \n(gal)","Water Temp.\n(ºC)","Delta (Δ)\n(in³)"]
[1,null,"",null,null,1,null,""]
[2,null,"",null,null,2,null,""]
[3,null,"",null,null,3,null,""]
[4,null,"",null,null,4,null,""]
[5,null,"",null,null,5,null,""]
[6,null,"",null,null,6,null,""]
[7,null,"",null,null,7,null,""]
[8,null,"",null,null,8,null,""]
[9,null,"",null,null,9,null,""]
[10,null,"",null,null,10,null,""]
[11,null,"",null,null,11,null,""]
[12,null,"",null,null,12,null,""]
[13,null,"",null,null,13,null,""]
[14,null,"",null,null,14,null,""]
[15,null,"",null,null,15,null,""]
[]
["Artifact Observations"]
["Trial 1",{"$nulls":4},"Trial 2"]
["Neck Scale Reading As Found (in³)",{"$nulls":4},"Neck Scale Reading (in³)"]
["Water Temperature, Bottom (ºC)",{"$nulls":4},"Water Temperature, Bottom (ºC)"]
["Water Temperature, Middle (ºC)",{"$nulls":4},"Water Temperature, Middle (ºC)"]
["Water Temperature, Top (ºC)",{"$nulls":4},"Water Temperature, Top (ºC)"]
["Water Temperature, Average (ºC)",{"$nulls":3},"","Water Temperature, Average (ºC)",{"$nulls":3},""]
["",{"$nulls":4},"If the Range of the Trials is in Control, Seal \nNeck Scale Plate and Print Report of Calibration. If Not Conduct Another Trial (Trial 2 Becomes Trial 1)"]
["Neck Scale Reading As Left (in³)",{"$nulls":4},"Scale Security Seal #"]

{"sheet":"NSCV Data Entry","index":3,"n_rows":39,"n_cols":10,"rows_kept":39,"merged":[[3,0,6,1],[3,2,6,6],[3,8,3,9],[4,8,4,9],[5,8,5,9],[9,0,9,1],[9,2,9,5],[9,6,9,8],[10,0,10,1],[10,2,10,5],[10,6,10,8],[11,0,11,1],[11,2,11,5],[14,1,14,2],[14,3,14,4],[14,5,15,9],[15,1,15,2],[15,3,15,4],[18,0,18,2],[18,3,18,4],[18,5,20,9],[19,0,19,2],[19,3,19,4],[20,0,20,2],[20,3,20,4],[23,0,23,2],[23,3,23,4],[23,5,34,9],[24,1,24,2],[24,3,24,4],[25,1,25,2],[25,3,25,4],[26,1,26,2],[26,3,26,4],[27,1,27,2],[27,3,27,4],[28,1,28,2],[28,3,28,4],[29,1,29,2],[29,3,29,4],[30,1,30,2],[30,3,30,4],[31,1,31,2],[31,3,31,4],[32,1,32,2],[32,3,32,4],[33,1,33,2],[33,3,33,4],[34,0,34,2],[34,3,34,4],[37,0,37,2],[37,3,37,5],[37,6,38,9],[38,0,38,2],[38,3,38,5]],"flags":["formulas_cached_only"]}
["NSCV Data Entry",{"$nulls":8},""]
[]
["Customer Information"]
["Name and Address",null,"",{"$nulls":4},"PO#",""]
[{"$nulls":7},"POC",""]
[{"$nulls":7},"Phone",""]
[]
[]
["Artifact and Measurement Information"]
["Description",null,"",{"$nulls":3},"Nominal Volume (gal)",null,null,""]
["Manufacture",null,"",{"$nulls":3},"Scale Graduations (in³)",null,null,""]
["Serial Number",null,""]
[]
["Volume Standard(s) Data"]
["ID Code","Description",null,"Delivered Volume\n(gal)",null,"Note:  If ID Code cell turns RED the standard calibration\n          is void, calibrate before use."]
[null,"",null,""]
[]
["Determine Neck Volume"]
["Neck radius (r) (in)"]
["Neck height (h) (in)"]
["Neck Volume (Nv) (in³) =",null,null,""]
[]
["Neck Calibration Data"]
["Scale Reading (sr) (in³)",null,null,"Volume Added (in³)",null,"Note:  If you have less\n          than 9 readings,\n          your last reading\n          taken must be\n          entered as srfinal"]
["srinitial",null,null,""]
["1st",null,null,""]
["2nd",null,null,""]
["3rd",null,null,""]
["4th",null,null,""]
["5th",null,null,""]
["6th",null,null,""]
["7th",null,null,""]
["8th",null,null,""]
["srfinal"]
["Total Volume Added (Vw) =",null,null,""]
[]
["Neck Scale Plate Error and Calibration Value Calculation"]
["Neck Scale Plate Error\nvs\nNeck Volume\n% error = [(srf - sri) - Vw] / Nv",null,null,"Neck Scale Calibration Value (NSCV)\nNSCV = Vw / (srf - sri)",null,null," "]
[" ",null,null," "]

{"sheet":"Calculations","index":4,"n_rows":55,"n_cols":10,"rows_kept":55,"merged":[[3,0,3,4],[3,5,3,9],[20,0,20,3],[20,5,20,8],[21,0,21,4],[21,5,21,9],[22,0,22,2],[22,3,22,4],[22,5,22,7],[22,8,22,9],[23,0,23,2],[23,3,23,4],[23,5,23,7],[23,8,23,9],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[33,0,33,9],[34,4,34,5],[34,7,35,9],[35,4,35,5],[38,0,38,9],[39,4,39,5],[40,4,40,5],[40,7,40,9],[41,4,41,5],[41,7,41,9],[44,0,44,9],[45,4,45,5],[45,7,45,9],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[54,4,54,5]],"flags":["formulas_cached_only"]}
["Calculations",{"$nulls":8},""]
[]
["Measurement Trial Calculations"]
["Volume Standard(s) Trial 1",{"$nulls":4},"Volume Standard(s) Trial 2"]
["Drop #","Std. Ref. Temp. (trefS ºF)","Water Temp.\n(ºF)","Water Density (g/cm³)","Delivered\nVolume\n(gal)","Drop #","Std. Ref. Temp. (trefS ºF)","Water Temp.\n(ºF)","Water Density (g/cm³)","Delivered\nVolume\n(gal)"]
[1,"","","","",1,"","","",""]
[2,"","","","",2,"","","",""]
[3,"","","","",3,"","","",""]
[4,"","","","",4,"","","",""]
[5,"","","","",5,"","","",""]
[6,"","","","",6,"","","",""]
[7,"","","","",7,"","","",""]
[8,"","","","",8,"","","",""]
[9,"","","","",9,"","","",""]
[10,"","","","",10,"","","",""]
[11,"","","","",11,"","","",""]
[12,"","","","",12,"","","",""]
[13,"","","","",13,"","","",""]
[14,"","","","",14,"","","",""]
[15,"","","","",15,"","","",""]
["Trial 1 Delivered Volume (gal) =",{"$nulls":3},"","Trial 2 Delivered Volume (gal) =",{"$nulls":3},""]
[" Trial 1",{"$nulls":4}," Trial 2"]
["Water Density (g/cm³) =",null,null,"",null,"Water Density (g/cm³) =",null,null,""]
["Water Temperature (ºF) =",null,null,"",null,"Water Temperature (ºF) =",null,null,""]
[]
[" Volume Determinations At The Designated Reference Temperature"]
[{"$nulls":3},"Trial 1 VXtrefX =","",null,""]
[{"$nulls":3},"Trial 2 VXtrefX =","",null,""]
[{"$nulls":3}," Volume As Found =","",null,""]
[{"$nulls":3}," Volume As Adjusted =","",null,""]
[{"$nulls":3},"Trial 2  Volume =","",null,""]
[]
["Uncertainty Evaluation"]
["Criteria: The expanded uncertainty must be less than 0.07 % of the measured volume."]
[{"$nulls":3},"0.07 % of Measured Volume =","",null,"",""]
[{"$nulls":3},"Expanded Uncertainty =","",null,""]
[]
["Tolerance Evaluation"]
["Criteria: The volume error shall not differ more than the\n maximum permissible error (tolerance minus the expanded uncertainty)."]
[{"$nulls":3},"Tolerance - Expanded Uncertainty =","",null,""]
[{"$nulls":3}," Volume Error As Found =","",null,"",""]
[{"$nulls":3}," Volume Error As Left =","",null,"",""]
[]
["Measurement Control Evaluation"]
["Criteria: The range of the trials must be within 0.02 % of the measured volume."]
[{"$nulls":3},"Measurement Range =","",null,"",""]
[]
["Results Formatted For Calibration Report"]
[{"$nulls":3},"Rounding factor =",""]
[{"$nulls":3}," Nominal Value =","",null,""]
[{"$nulls":3}," Tolerance =","",null,""]
[{"$nulls":3}," Volume As Found =","",null,""]
[{"$nulls":3}," Volume As Left =","",null,""]
[{"$nulls":3},"U (k=2) =","",null,""]
[{"$nulls":3},"Neck Scale Calibration Value =",""]

{"sheet":"Uncertainty Analysis","index":5,"n_rows":91,"n_cols":14,"rows_kept":91,"merged":[[11,2,11,13],[12,2,12,13],[13,2,13,13],[14,2,14,13],[15,2,15,13],[16,2,16,13],[17,2,17,13],[18,2,18,13],[19,2,19,13],[22,0,22,5],[22,6,22,13],[23,2,23,5],[23,8,23,13],[24,2,24,5],[24,8,24,13],[25,2,25,5],[25,8,25,13],[26,2,26,5],[26,8,26,13],[27,2,27,5],[27,8,27,13],[28,2,28,5],[28,8,28,13],[29,2,29,5],[29,8,29,13],[30,2,30,5],[30,8,30,13],[31,2,31,5],[31,8,31,13],[32,2,32,5],[32,8,32,13],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[48,0,50,0],[48,1,49,1],[48,12,62,13],[51,2,51,11],[63,13,64,13],[67,5,67,13],[87,0,87,13],[88,0,88,4],[89,0,89,4],[90,0,90,4]],"flags":["formulas_cached_only"]}
["Uncertainty Analysis",{"$nulls":12},""]
[]
["Specify Procedure"]
["NIST HB 145, SOP 19, Calibration of Large Neck-Type Metal Provers - Volumetric Method"]
[]
["Specify Equation(s)"]
["Volume at the Reference Temperature"]
[]
[" Volume = VXtrefX - gauge reading"]
[]
[null,"where"]
[null,"VXtrefX =","Volume of the unknown vessel, VX at its designated reference temperature, trefX"]
[null,"VStrefS =","Volume of the standard vessel, VS at its designated reference temperature, trefS"]
[null,"ρ1, ρ2, …, ρN =","Density of the water in the standard where ρ1 is the density of the water for the first delivery, ρ2 is the density of the water for the second delivery, and so on until all N deliveries are completed"]
[null,"Δ1, Δ2,…,ΔN =","Volume differences between the water level and the reference mark on the standard where the subscripts 1, 2,…,N, represent each delivery as above. If the water level is below the reference line, Δ is negitive. If the water level is above the reference line, Δ is positive. If the water level is at the reference line, Δ is zero\nNOTE: units must match volume units for the standard"]
[null,"t1, t2, …, tN =","Temperature of water for each delivery with the subscripts as above"]
[null,"α =","Coefficient of cubical expansion for the standard in its designated units"]
[null,"β =","Coefficient of cubical expansion for the unknown vessel in its designated units"]
[null,"tx =","Temperature of water in the filled unknown vessel in designated units"]
[null,"ρx =","Density of water in the prover in g/cm3"]
[]
["Identify Components Their Uncertainties"]
["Data Values (based on trial 1)",{"$nulls":5},"Reported Uncertainties"]
["","gal","(VS) Delivered Volume of the standard(s)",{"$nulls":3},"","gal","Uncertainty of standard(s), VS, from calibration report, normal distribution, k =1"]
["","gal","(Δ) Volume differences between the water level and the reference mark on the standard ",{"$nulls":3},"","gal","(sp) Uncertainty associated with the measurement process from the mean range divided by the d*2 value from NIST HB 145, Table 9.1, normal distribution"]
["","/ºF","(α) Cubic Coefficient of Expansion for the standard material",{"$nulls":3},"","/ºF","NBS Report 10 081, Uncertainties in the calibration of large vessels, p. 10 (0.000009 /ºC or 0.000005 /ºF), uniform distribution"]
["","/ºF","(β) Coefficient of cubical expansion for the unknown vessel",{"$nulls":3},"","/ºF","NBS Report 10 081, Uncertainties in the calibration of large vessels, p. 10 (0.000009 /ºC or 0.000005 /ºF), uniform distribution"]
["","ºF","(tS) Temperarure of water in the standard",{"$nulls":3},"","ºF","Accuracy for thermometer used for measuring water temperature (NIST HB 145, SOP 19, accurate to ± 0.1 ºC), uniform distribution"]
["","ºF","(tX) Temperature of water in the filled unknown vessel",{"$nulls":3},"","ºF","Accuracy for thermometer used for measuring water temperature (NIST HB 145, SOP 19, accurate to ± 0.1 ºC), uniform distribution"]
["","g/cm³","(ρwS) Density of water in the standard in g/cm3",{"$nulls":3},"","g/cm³","Combined standard uncertainty of the Patterson Morris equation, [J. Res., NIST 97, 335 (1992), 10ppm  (0.0000 10 g/cm³)], and possible uncorrected systematic error, k = 1"]
["","g/cm³","(ρwX) Density of water in the unknown vessel in g/cm3",{"$nulls":3},"","g/cm³","Combined standard uncertainty of the Patterson Morris equation, [J. Res., NIST 97, 335 (1992), 10ppm  (0.0000 10 g/cm³)], and possible uncorrected systematic error, k = 1"]
["","gal","(Sr) Unknown vessel scale reading",{"$nulls":3},"","gal","Uncertainty associated with reading the meniscus of the standard(s), for each transfer, and unknown vessel, ASTM E 694, paragraph A1.6.2, estimation of 1/10 of smallest scale increment, uniform distribution"]
["","ºF","(tref) Reference Temperature for this calibration",{"$nulls":3},"","ºF","Treated as constant, no uncertainty"]
[]
["Input Table (Convert Component Uncertainties For Use In Kragten Spreadsheet)"]
["Input description",null,"Variable name, symbol","Value","units","Reported uncer.","Type","Distribution","Factor to normalize","Standard uncer., ui","Rel. ui (%)","df"]
["Volume Standards",null,"VStrefS","","gal","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["delta",null,"Δ (sp)","","gal","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Standard Cubic Coefficient\n of Expansion",null,"α","","/ºF","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unknown Vessel Cubic Coefficient of Expansion",null,"β","","/ºF","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Standard Water Temperature",null,"tS","","ºF","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unknown Vessel Water Temperature",null,"tX","","ºF","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Standard Water Density",null,"ρwS","","g/cm³","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unknown Vessel\n Water Density",null,"ρwX","","g/cm³","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Unknown vessel scale reading",null,"Sr","","gal","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Reference Temperature",null,"trefX","","ºF","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Kragten Spreadsheet (Calculate Each Component Uncertainty Impact, Combine and Expand)"]
[null,null,"u(VStrefS)","u(Δ (sp))","u(α)","u(β)","u(tS)","u(tX)","u(ρwS)","u(ρwX)","u(Sr)","u(trefX)"]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"df"]
["Measurement\nEquation\n Inputs","Value"]
["VStrefS","",{"$error":"#VALUE!"},"","","","","","","","",""]
["Δ (sp)","","",{"$error":"#VALUE!"},"","","","","","","",""]
["α","","","",{"$error":"#VALUE!"},"","","","","","",""]
["β","","","","",{"$error":"#VALUE!"},"","","","","",""]
["tS","","","","","",{"$error":"#VALUE!"},"","","","",""]
["tX","","","","","","",{"$error":"#VALUE!"},"","","",""]
["ρwS","","","","","","","",{"$error":"#VALUE!"},"","",""]
["ρwX","","","","","","","","",{"$error":"#VALUE!"},"",""]
["Sr","","","","","","","","","",{"$error":"#VALUE!"},""]
["trefX","","","","","","","","","","",{"$error":"#VALUE!"}]
["Result",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"ciui"]
["uc",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"(ciui)2"]
["df",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"<--rel (ciui)2",{"$error":"#VALUE!"}]
["k",2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"ci","∑ (ciui)2"]
["U",{"$error":"#VALUE!"},"gal",{"$error":"#VALUE!"},"(Urelative, %)"]
[]
["Weight of Each Component Uncertainty"]
{"$rows_empty":17}
["Determine Expanded Uncertainty For This Calibration"]
["Expand uncertainty for this calibration (k=2) =",{"$nulls":4},"","gal"]
["Accredited best uncertainty (e.g. NVLAP, A2LA, etc.) (k=2) =",{"$nulls":4},0,"gal"]
["Uncertainty to be reported for this calibration (k=2) =",{"$nulls":4},"","gal"]

{"sheet":"Standards","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"flags":["formulas_cached_only"]}
["Standards",{"$nulls":11},""]
[]
[]
[]
["CustomaryVol.Stds Vlookup Table"]
["ID\nCode","Description","Serial\nNumber","Volume (VS)\n(gal)","Reference\nTemperature\n(trefS) (ºF)","Scale\nGraduations\n(in³)","Material","CCE / ºF","Unc\n(gal)","k-factor","Report\n#","Cal\nDate","Due\nDate"]
[]
[]
["MetricVol.Stds Vlookup Table"]
["ID\nCode","Description","Serial\nNumber","Volume (VS)\n(L)","Reference\nTemperature\n(trefS) (ºF)","Scale\nGraduations\n(mL)","Material","CCE / ºF","Unc\n(L)","k-factor","Report\n#","Cal\nDate","Due\nDate"]
[]
[]
["Temp.Stds Vlookup Table"]
["ID\nCode","Description","Serial\nNumber","Correction\n(ºC)","Manufacture\nStated\nAccuracy\n(ºC)","Unc\n(ºC)","k-factor","Report\n#","Cal\nDate","Due\nDate"]

{"sheet":"Tables & Lists","index":7,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[2,0,2,1],[2,3,2,4],[2,6,2,7],[35,0,35,9],[36,0,36,9],[37,0,37,9]],"flags":["formulas_cached_only"]}
["Tables & Lists",{"$nulls":8},""]
[]
["Rounding Table\n(Rnd.Table)",null,null,"NISTIR 6969 Table 9.1\n(Table_9.1)",null,null,"Cubical Coefficient of Expansion Table\n(CCE.Table) &\nMaterial List\n(Material.List)",null,null," Pick Lists\nfor\nData Validation Cells"]
[0,"TableError",null,1,1.41,null,"Material","cm³/ºF",null,"Scale Graduations (in³)"]
[1e-12,13,null,2,1.32,null,"Aluminum",3.8e-05,null,"Scale Graduations (gal)"]
[1e-11,12,null,3,1.23,null,"Plastic, Polypropylene",0.00024,null,"Scale Graduations (L)"]
[1e-10,11,null,4,1.21,null,"Steel, Prover, Low Carbon",1.86e-05,null,"Scale Graduations (mL)"]
[1e-09,10,null,5,1.19,null,"Steel, Stainless",2.65e-05]
[1e-08,9,null,6,1.184,null,"Steel, Terneplate",1.95e-05,null,"Range Mean from CC (in³)"]
[1e-07,8,null,7,1.178,{"$nulls":4},"Range Mean from CC (gal)"]
[1e-06,7,null,8,1.172,{"$nulls":4},"Range Mean from CC (L)"]
[1e-05,6,null,9,1.166,{"$nulls":4},"Range Mean from CC (mL)"]
[0.0001,5,null,10,1.16]
[0.001,4,null,11,1.158,{"$nulls":4},"Yes"]
[0.01,3,null,12,1.156,{"$nulls":4},"No"]
[0.1,2,null,13,1.154]
[1,1,null,14,1.152,{"$nulls":4},"Nominal Volume (gal)"]
[10,0,null,15,1.15,{"$nulls":4},"Nominal Volume (L)"]
[100,-1,null,16,1.148]
[1000,-2,null,17,1.146,{"$nulls":4},"Designated Reference Temperature For This Calibration (ºF)"]
[10000,-3,null,18,1.144,{"$nulls":4},"Designated Reference Temperature For This Calibration (ºC)"]
[100000,-4,null,19,1.142]
[1000000,-5,null,20,1.14,{"$nulls":4},"Prover"]
[10000000,-6,null,21,1.1389999999999998,{"$nulls":4},"Test Measure"]
[100000000,-7,null,22,1.138]
[1000000000,-8,null,23,1.137,{"$nulls":4},"Manufacture"]
[10000000000,-9,null,24,1.1360000000000001,{"$nulls":4},"NIST HB 105-3"]
[100000000000,-10,null,25,1.135,{"$nulls":4},"User"]
[1000000000000,-11,null,26,1.1340000000000003]
[10000000000000,-12,null,27,1.1330000000000005]
[100000000000000,-13,null,28,1.1320000000000006]
[1000000000000000,"TableError",null,29,1.1310000000000007]
[{"$nulls":3},30,1.13]
[{"$nulls":3},"31 to infinity",1.13]
[]
["Calibration Report Statements"]
["●  The calibration item was calibrated in a wet down condition using water. The  delivers the stated volume\n    at the reference temperature from the specified graduation line when it is emptied gradually with in a 30 (± 5 seconds) pour\n    and a 10-second drain while held at a 10º to 15º angle from vertical."]
["●  The calibration item was calibrated in a wet down condition using water. The  delivers the stated volume\n    at the reference temperature is when it is drained for a 30 (± 5) second period after cessation of the main flow."]