{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Documentation","Report","Data Entry","CIPM Air Density","Calculations","Uncertainty Analysis","Standards","Tables & Lists"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":4,"defined_names":135,"comments":3},"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":58,"n_cols":5,"rows_kept":58,"merged":[[2,4,3,4],[13,0,16,2],[15,3,15,4],[20,0,20,4],[22,0,22,4],[23,0,23,4],[26,0,26,4],[44,0,44,4],[47,0,47,4],[49,0,49,4],[51,0,51,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,"Delivery Type.:"]
["Date Received:",null,null,"Specification...:"]
["Submitted By"]
["Name & Address:",null,null,"Purchase Order #:"]
[{"$nulls":3},"Point of Contact..:"]
[{"$nulls":3},""]
[]
["Artifact Calibration Results"]
["The  was found   ±  gal @  ºF"]
["Calibration Notes"]
[{"$error":"#N/A"}]
[{"$error":"#VALUE!"}]
[""]
["●  The artifact described above was calibrated using ASTM Type III or IV Reagent Water."]
["Calibration Conditions"]
["Technician….….…....:",{"$nulls":3},"Procedure:  NIST HB 145, SOP 14"]
["Condition of Artifact:"]
["Temperature…..….....:",null,"Pressure",null,"Humidity:"]
["Water Temperature...:"]
["Laboratory Mass Standard(s) Used"]
["Description","Serial Number","Report Number","Date Calibrated","Date Calibration Due"]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["","","","",""]
["Laboratory Environmental 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 YOUT-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":"Data Entry","index":2,"n_rows":88,"n_cols":10,"rows_kept":88,"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,4],[9,5,9,7],[9,8,9,9],[10,0,10,1],[10,2,10,4],[10,5,10,7],[10,8,10,9],[11,0,11,1],[11,2,11,4],[11,5,11,7],[11,8,11,9],[12,0,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,9],[13,0,13,1],[13,2,13,4],[13,5,13,7],[13,8,13,9],[14,0,14,7],[14,8,14,9],[15,0,15,4],[15,6,15,8],[18,0,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,9],[19,0,19,1],[19,4,19,6],[19,7,19,8],[20,0,20,2],[20,3,20,4],[20,5,20,7],[20,8,20,9],[21,0,21,7],[21,8,21,9],[22,0,22,7],[22,8,22,9],[25,0,25,9],[26,3,26,4],[26,5,26,6],[27,0,30,0],[27,3,27,4],[27,5,27,6],[28,3,28,4],[28,5,28,6],[29,3,29,4],[29,5,29,6],[30,3,30,4],[30,5,30,6],[31,0,34,0],[31,3,31,4],[31,5,31,6],[32,3,32,4],[32,5,32,6],[33,3,33,4],[33,5,33,6],[34,3,34,4],[34,5,34,6],[37,0,37,9],[38,0,38,2],[38,4,38,5],[38,6,38,7],[38,8,38,9],[39,0,39,2],[39,4,39,5],[39,6,39,7],[39,8,39,9],[40,0,40,2],[40,4,40,5],[40,6,40,7],[40,8,40,9],[41,0,41,2],[41,4,41,5],[41,6,41,7],[41,8,41,9],[42,0,42,2],[42,4,42,5],[42,6,42,7],[42,8,42,9],[45,0,45,9],[46,0,50,4],[46,5,46,7],[46,8,46,9],[47,5,47,7],[47,8,47,9],[48,5,48,7],[48,8,48,9],[49,5,49,7],[49,8,49,9],[50,5,50,7],[50,8,50,9],[51,0,51,9],[52,0,53,7],[52,8,53,9],[54,0,55,7],[54,8,55,9],[56,0,57,7],[56,8,57,9],[58,0,59,7],[58,8,59,9],[60,0,64,4],[60,5,60,7],[60,8,60,9],[61,5,61,7],[61,8,61,9],[62,5,62,7],[62,8,62,9],[63,5,63,7],[63,8,63,9],[64,5,64,7],[64,8,64,9],[65,0,65,9],[67,0,67,9],[68,0,72,4],[68,5,68,7],[68,8,68,9],[69,5,69,7],[69,8,69,9],[70,5,70,7],[70,8,70,9],[71,5,71,7],[71,8,71,9],[72,5,72,7],[72,8,72,9],[73,0,73,9],[74,0,75,7],[74,8,75,9],[76,0,77,7],[76,8,77,9],[78,0,79,7],[78,8,79,9],[80,0,81,7],[80,8,81,9],[82,0,86,4],[82,5,82,7],[82,8,82,9],[83,5,83,7],[83,8,83,9],[84,5,84,7],[84,8,84,9],[85,5,85,7],[85,8,85,9],[86,5,86,7],[86,8,86,9],[87,0,87,9]],"flags":["formulas_cached_only"]}
["Data Entry",{"$nulls":6},"Report Number:"]
[]
["Customer Information"]
["Name  and Address (use Alt+Enter for line breaks)",{"$nulls":6},"PO#"]
[{"$nulls":7},"POC"]
[{"$nulls":7},"Phone"]
[]
[]
["Artifact Information"]
["Description",{"$nulls":4},"Date Received"]
["Manufacture",{"$nulls":4},"Nominal Value (gallon)"]
["Material",{"$nulls":4},"Serial Number"]
["Cubical Coefficient of Exp. (/ºC) =",null,null,"",null,"Artifact Specifications"]
["Artifact Condition",{"$nulls":4},"Reference Temperature (ºF)"]
["Type of Volume Container (To Deliver - Wet Calibration or To Contain - Dry Calibration)"]
["Was a Calibration Interval Requested or is one Required?",{"$nulls":5},"What is the Interval (months)?"]
[]
["Measurement Information"]
["Date of Calibration",{"$nulls":4},"Technician"]
["Balance ID Code",null,null,"Balance","",null,null,"Balance Unit:",null,""]
["Range Mean from CC (mL)",{"$nulls":4},"No. of Duplicate Sets from CC"]
["Accredited (e.g. NVLAP, A2LA, etc.) Best Uncertainty for this Calibration (mL)"]
["Measurement Option (A = three observations; B = four observations)"]
[]
["Mass Standard(s) Data"]
["Note: If ID Code cell turns RED the standard calibration is void, calibrate before use."]
["Mass ID","ID Code","Nominal Mass (g)","True Mass Correction (mg)",null,"Us (mg)",null,"k-factor","Density (g/cm3)","Uρs (g/cm3) k=1"]
["",null,"","",null,"",null,"","",""]
[null,null,"","",null,"",null,"","",""]
[null,null,"","",null,"",null,"","",""]
[null,"","","",null,"",null,"","",""]
["",null,"","",null,"",null,"","",""]
[null,null,"","",null,"",null,"","",""]
[null,null,"","",null,"",null,"","",""]
[null,"","","",null,"",null,"","",""]
[]
["Environmental Standard(s) Data"]
["Note: If ID Code cell turns RED the standards calibration is void, calibrate before use."]
["Parameter",null,null,"ID Code","Correction",null,"Accuracy",null,"Unit"]
["Temperature, Water",{"$nulls":3},"",null,"",null,""]
["Temperature, Air",{"$nulls":3},"",null,"",null,""]
["Barometric Pressure",{"$nulls":3},"",null,"",null,""]
["Humidity",{"$nulls":3},"",null,"",null,""]
[]
["Observations"]
["Trial 1"]
["Starting Time and Environmental Conditions",{"$nulls":4},"Start Time (hh:mm)"]
[{"$nulls":5},"Air Temperature (ºC)"]
[{"$nulls":5},"Barometric Pressure (mm Hg)"]
[{"$nulls":5},"Relative Humidity (% RH)"]
[{"$nulls":5},"Water Temperature (ºC)"]
["!!! Zero Balance Before Each Observation !!!"]
[""]
[]
[""]
[]
[""]
[]
[""]
[]
["Ending Time and Environmental Conditions",{"$nulls":4},"Water Temperature (ºC)"]
[{"$nulls":5},"Air Temperature (ºC)"]
[{"$nulls":5},"Barometric Pressure (mm Hg)"]
[{"$nulls":5},"Relative Humidity (% RH)"]
[{"$nulls":5},"End Time (hh:mm)"]
[""]
[]
["Trial 2"]
["Starting Time and Environmental Conditions",{"$nulls":4},"Start Time (hh:mm)"]
[{"$nulls":5},"Air Temperature (ºC)"]
[{"$nulls":5},"Barometric Pressure (mm Hg)"]
[{"$nulls":5},"Relative Humidity (% RH)"]
[{"$nulls":5},"Water Temperature (ºC)"]
["!!! Zero Balance Before Each Reading !!!"]
[""]
[]
[""]
[]
[""]
[]
[""]
[]
["Ending Time and Environmental Conditions",{"$nulls":4},"Water Temperature (ºC)"]
[{"$nulls":5},"Air Temperature (ºC)"]
[{"$nulls":5},"Barometric Pressure (mm Hg)"]
[{"$nulls":5},"Relative Humidity (% RH)"]
[{"$nulls":5},"End Time (hh:mm)"]
[""]

{"sheet":"CIPM Air Density","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[2,0,2,7],[3,0,3,4],[3,5,4,7],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[5,5,5,6],[6,0,6,2],[6,3,6,4],[6,5,6,6],[7,0,7,2],[7,3,7,4],[7,5,7,6],[9,0,9,4],[9,5,10,7],[10,0,10,2],[10,3,10,4],[11,0,11,2],[11,3,11,4],[11,5,11,6],[12,0,12,2],[12,3,12,4],[12,5,12,6],[13,0,13,2],[13,3,13,4],[13,5,13,6]],"flags":["formulas_cached_only"]}
["CIPM Air Density",{"$nulls":6},""]
[]
["Air Density Calculations, CIPM 1981/91 Formula, R. S. Davis"]
["Air Density Calculation Run 1",{"$nulls":4},"Do not delete these cells!\nThey are used to calculate air density."]
[" Barometric Pressure (mm Hg)",null,null,""]
[" Temperature (ºC)",null,null,"",null,"",null,"Pa"]
[" Relative Humidity (%)",null,null,"",null,"",null,"°K"]
[" Calculated Air Density (mg/cm3)",null,null,"",null,"",null,"%"]
[]
["Air Density Calculation Run 2",{"$nulls":4},"Do not delete these cells!\nThey are used to calculate air density."]
[" Barometric Pressure (mm Hg)",null,null,""]
[" Temperature (ºC)",null,null,"",null,"",null,"Pa"]
[" Relative Humidity (%)",null,null,"",null,"",null,"°K"]
[" Calculated Air Density (mg/cm3)",null,null,"",null,"",null,"%"]

{"sheet":"Calculations","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[3,2,3,3],[3,5,4,7],[4,2,4,3],[7,2,7,3],[7,5,8,7],[8,2,8,3],[11,2,11,3],[12,2,12,3],[15,2,15,3],[15,5,16,7],[16,2,16,3],[17,2,17,3],[17,5,18,7],[18,2,18,3],[19,2,19,3],[22,0,22,7],[23,2,23,3],[23,5,24,7],[24,2,24,3],[27,0,27,7],[28,2,28,3],[28,5,29,7],[29,2,29,3],[32,2,32,3],[32,5,32,7],[42,2,42,3]],"flags":["formulas_cached_only"]}
["Calculations",{"$nulls":6},""]
[]
["Air Density Determinations"]
[null,"Run 1 ρa =","",null,"g/cm3","CIPM 1981/1991 Air Density Formula, R.S. Davis"]
[null,"Run 2 ρa =","",null,"g/cm3"]
[]
["Water Density Determinations"]
[null,"Run 1 ρw =","",null,"g/cm3","Patterson/Morris 1994 Water Density Formula"]
[null,"Run 2 ρw =","",null,"g/cm3"]
[]
["Mass Standards Report Values"]
[null,"Ms","",null,"g","true mass of standard(s)"]
[null,"","",null,"",""]
[]
["Volume Determinations"]
[null,"Trial 1 Vt =","",null,"mL","trial 1 & 2 volume at measured temperature"]
[null,"Trial 2 Vt =","",null,"mL"]
[null,"Trial 1 V @  ºF =","",null,"mL","trial 1 & 2 volume at reference temperature"]
[null,"Trial 2 V @  ºF =","",null,"mL"]
[null,"V @  ºF =","",null,"mL","average of trial 1 & 2 at reference temp."]
[]
["Uncertainty Evaluation"]
["Criteria: The expanded uncertainty must be less than 1/3 of the stated tolerance. For NIST HB 105-3, the expanded uncertainty must be less than 0.07 % of the measured volume."]
[null,"1/3 of Tolerance =","",null,"mL",""]
[null,"Expanded Uncertainty =","",null,"mL"]
[]
["Tolerance Evaluation"]
["Criteria: The measured volume minus the nominal volume shall not differ more than the maximum permissible error minus the expanded uncertainty."]
[null,"Volume Error =","",null,"mL",""]
[null,"Tolerance - U (k=2)=","",null,"mL"]
[]
["Measurement Control"]
[null,"Range of Trials =","",null,"mL",""]
[]
["Results Formatted For Calibration Report"]
[null,"Rounding factor =",""]
[null,"V @  ºC =","",""]
[null,"U (k=2) =","",""]

{"sheet":"Uncertainty Analysis","index":5,"n_rows":151,"n_cols":17,"rows_kept":151,"merged":[[2,0,2,16],[5,0,5,16],[19,0,19,16],[20,0,20,6],[20,7,20,16],[21,2,21,6],[21,9,21,16],[22,2,22,6],[22,9,22,16],[23,2,23,6],[23,9,23,16],[24,2,24,6],[24,9,24,16],[25,2,25,6],[25,9,25,16],[26,2,26,6],[26,9,26,16],[27,2,27,6],[27,9,27,16],[28,2,28,6],[28,9,28,16],[29,2,29,6],[29,9,29,16],[30,2,30,6],[30,9,30,16],[31,2,31,6],[31,9,31,16],[32,2,32,6],[32,9,32,16],[33,2,33,6],[33,9,33,16],[35,0,35,16],[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],[46,0,46,1],[48,0,48,16],[49,0,51,0],[49,1,50,1],[49,12,63,13],[52,2,52,11],[64,13,65,13],[68,5,68,13],[88,0,88,16],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[99,0,99,1],[100,0,100,1],[101,0,101,1],[102,0,102,1],[104,0,104,16],[105,0,107,0],[105,1,106,1],[105,15,122,16],[108,2,108,14],[123,16,124,16],[127,5,127,16],[147,0,147,16],[148,0,148,4],[149,0,149,4],[150,0,150,4]],"flags":["formulas_cached_only"]}
["Uncertainty Analysis",{"$nulls":15},""]
[]
["Specify Procedure"]
["NIST HB 145, SOP 14, Gravimetric Calibration of Volumeteric Ware Using an Electronic Balance"]
[]
["Specify Equation(s)"]
["Measurement Option A",{"$nulls":3},"Measurement Option B",{"$nulls":6},"Volume at Reference Temperature"]
[]
[{"$nulls":11},"where"]
["where",{"$nulls":10},"Vref =","Volume at reference temperature"]
["Vt =","Result at measured temerature",{"$nulls":9},"α =","Coefficient of cubical expansion of vessel"]
["MS =","Mass standard(s) slightly more than the mass of the filled vessel",{"$nulls":9},"t =","Water temperature"]
["MS1 =","Mass standard(s) slightly more than the mass of the empty/drained vessel",{"$nulls":9},"tref =","Reference temperature"]
["MS2 =","Mass standard(s) slightly more than the mass of the filled vessel"]
["On =","Balance Observations"]
["ρa =","Density of air (CIPM equation)"]
["ρs =","Density of mass standards"]
["ρw =","Density of water (Patterson/Morris equation)"]
[]
["Identify Components Their Uncertainties"]
["Data Values (based on trial 1)",{"$nulls":6},"Reported Uncertainties"]
["","g","(Ms) Mass standard(s)",{"$nulls":4},"","g","Uncertainty of mass standard(s), Ms, from calibration report, normal distribution, k =1"]
["","g/cm³","(ρs) Density of mass standard(s) - Ms",{"$nulls":4},"","g/cm³","Uncertainty of the density of the standard(s), ρs, from the calibration report or from OIML R 111-1: 2004(E) para. B.7.9.3 and Table B.7, uniform distribution"]
["","","",{"$nulls":4},"","",""]
["","","",{"$nulls":4},"","",""]
["","g","(O1) Balance Obsevation 1",{"$nulls":4},"","g","(sp) Uncertainty associated with the measurement process from the mean range divided by the d*2 value from NIST HB 145, Table 9.1 (value divided by 1.003 mL/g to convert sp from mL to g), normal distribution"]
["","g","(O2) Balance Obsevation 2",{"$nulls":4},"","g","Uncertainty of balance observation 2, included in sp and entered as u(O1 (sp))"]
["","g","(O3) Balance Obsevation 3",{"$nulls":4},"","g","Uncertainty of balance observation 3, included in sp and entered as u(O1 (sp))"]
["","","",{"$nulls":4},"","",""]
["","g/cm³","(ρa) Density of air using the CIPM 1981/1991 Air Density Formula, R.S. Davis",{"$nulls":4},"","g/cm³","Given maximum uncertainty, as long as instrument accuracies for temperature ≤ 0.5 ºC, for barometer ≤ 1.0 mm Hg, and for hygrometer ≤ 10 %, uniform distribution"]
["","g/cm³","(ρw) Density of water using the Patterson/Morris 1994 Water Density Formula",{"$nulls":4},"","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"]
["","/ºC","(α) Cubic Coefficient of Expansion for the vessel material",{"$nulls":4},"","/ºC","NBS Report 10 081, Uncertainties in the calibration of large vessels, p. 10 (0.000009 /ºC or 0.000005 /ºF), uniform distribution"]
["","ºC","(tw) Temperature of water in vessel",{"$nulls":4},"","ºC","Accuracy for thermometer used for measuring water temperature (NIST HB 145, SOP 14, accuracy must be ≤ 0.1 ºC), uniform distribution"]
["","ºC","(tref) Reference Temperature for this calibration",{"$nulls":4},"","ºC","Treated as constant, no uncertainty"]
[]
["Input Table -Measurement Option A (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"]
["Mass Standards\n(matching filled container)",null,"Ms","","g","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Mass Standards Density\n(matching filled container)",null,"ρs","","g/cm³","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Mass Standards Balance Observation",null,"O1 (sp)","","g","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Empty/Drained Vessel Balance Observation",null,"O2","","g","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Filled Vessel Balance Observation",null,"O3","","g","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Air Density",null,"ρa","","g/cm³","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Water Density",null,"ρw","","g/cm³","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Vessel Cubic Coefficient of Expansion",null,"α","","/ºC","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Final Water Temperature",null,"tw","","ºC","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Reference Temperature",null,"tref","","ºC","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Kragten Spreadsheet - Measurement Option A (Calculate Each Component Uncertainty Impact, Combine and Expand)"]
[null,null,"u(Ms)","u(ρs)","u(O1 (sp))","u(O2)","u(O3)","u(ρa)","u(ρw)","u(α)","u(tw)","u(tref)"]
[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 Equation Inputs","Value"]
["Ms","",{"$error":"#VALUE!"},"","","","","","","","",""]
["ρs","","",{"$error":"#VALUE!"},"","","","","","","",""]
["O1 (sp)","","","",{"$error":"#VALUE!"},"","","","","","",""]
["O2","","","","",{"$error":"#VALUE!"},"","","","","",""]
["O3","","","","","",{"$error":"#VALUE!"},"","","","",""]
["ρa","","","","","","",{"$error":"#VALUE!"},"","","",""]
["ρw","","","","","","","",{"$error":"#VALUE!"},"","",""]
["α","","","","","","","","",{"$error":"#VALUE!"},"",""]
["tw","","","","","","","","","",{"$error":"#VALUE!"},""]
["tref","","","","","","","","","","",{"$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!"},"mL",{"$error":"#VALUE!"},"(Urelative, %)"]
[]
["Weight of Each Component Uncertainty"]
{"$rows_empty":17}
["Input Table -Measurement Option B (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"]
["Mass Standards\n(matching filled container)",null,"Ms1","","g","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Mass Standards Density\n(matching filled container)",null,"ρs1","","g/cm³","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Mass Standards\n(matching filled container)",null,"Ms2","","","","B","U",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Mass Standards Density\n(matching filled container)",null,"ρs2","","","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Mass Standards Balance Observation",null,"O1 (sp)","","g","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Empty/Drained Vessel Balance Observation",null,"O2","","g","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Filled Vessel Balance Observation",null,"O3","","g","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Filled Vessel Balance Observation",null,"O4","","","","A","Normal",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Air Density",null,"ρa","","g/cm³","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Water Density",null,"ρw","","g/cm³","","B","uc",1,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Vessel Cubic Coefficient of Expansion",null,"α","","/ºC","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Final Water Temperature",null,"tw","","ºC","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Reference Temperature",null,"tref","","ºC","","B","Uniform",1.7320508075688772,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Kragten Spreadsheet - Measurement Option B (Calculate Each Component Uncertainty Impact, Combine and Expand)"]
[null,null,"u(Ms1)","u(ρs1)","u(Ms2)","u(ρs2)","u(O1 (sp))","u(O2)","u(O3)","u(O4)","u(ρa)","u(ρw)","u(α)","u(tw)","u(tref)"]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"df"]
["Measurement Equation Inputs","Value"]
["Ms1","",{"$error":"#VALUE!"},"","","","","","","","","","","",""]
["ρs1","","",{"$error":"#VALUE!"},"","","","","","","","","","",""]
["Ms2","","","",{"$error":"#VALUE!"},"","","","","","","","","",""]
["ρs2","","","","",{"$error":"#VALUE!"},"","","","","","","","",""]
["O1 (sp)","","","","","",{"$error":"#VALUE!"},"","","","","","","",""]
["O2","","","","","","",{"$error":"#VALUE!"},"","","","","","",""]
["O3","","","","","","","",{"$error":"#VALUE!"},"","","","","",""]
["O4","","","","","","","","",{"$error":"#VALUE!"},"","","","",""]
["ρa","","","","","","","","","",{"$error":"#VALUE!"},"","","",""]
["ρw","","","","","","","","","","",{"$error":"#VALUE!"},"","",""]
["α","","","","","","","","","","","",{"$error":"#VALUE!"},"",""]
["tw","","","","","","","","","","","","",{"$error":"#VALUE!"},""]
["tref","","","","","","","","","","","","","",{"$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!"},{"$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!"},{"$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!"},{"$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!"},{"$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!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"ci","∑ (ciui)2"]
["U",{"$error":"#VALUE!"},"mL",{"$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},"","mL"]
["Accredited best uncertainty (e.g. NVLAP, A2LA, etc.) (k=2) =",{"$nulls":4},0,"mL"]
["Uncertainty to be reported for this calibration (k=2) =",{"$nulls":4},"","mL"]

{"sheet":"Standards","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"flags":["formulas_cached_only"]}
["Standards",{"$nulls":10},""]
[]
[]
[]
["Stds.Table"]
["ID\nCode","Description","Serial\nNumber","Nominal\nValue\n(gram)","True Mass Correction (mg)","Uncertainty\n(mg)","k\nfactor","Density\n(g/cm3)","Density\nUncertainty\nk=1\n(g/cm3)","Report\nNumber","Date\nCalibrated","Date\nCalibration\nDue"]
[]
[]
["Enviro.Stds Vlookup Table"]
["ID\nCode","Description","Serial\nNumber","Correction","Accuracy","Units","Report\n#","Cal\nDate","Due\nDate"]
[]
[]
["Balance Vlookup Table"]
["ID\nCode","Balance","Units"]

{"sheet":"Tables & Lists","index":7,"n_rows":39,"n_cols":46,"rows_kept":39,"merged":[[2,0,2,1],[2,3,2,4],[2,8,2,15],[2,18,2,19],[2,21,2,25],[2,27,2,29],[2,31,2,33],[2,35,2,38],[2,40,2,42],[2,44,2,45],[35,0,35,6],[36,0,36,6],[37,0,37,6],[38,0,38,6]],"flags":["formulas_cached_only"]}
["Tables & Lists",{"$nulls":5},"",null,"Tables & Lists",{"$nulls":7},"",null,"Tables & Lists",{"$nulls":6},"",null,"Tables & Lists",{"$nulls":5},"",null,"Tables & Lists",{"$nulls":6},"",null,"Tables & Lists",""]
[]
["Rounding Table\n(Rnd.Table)\n(Used to round the uncertainty to two significant digits, and rounds the as found/left values to the same number of decimal places that are in the uncertainty.)",null,null,"NISTIR 6969 Table 9.1\n(Table_9.1)\nUse of Range to Estimate Standard Deviation (two replicates)",null,null," Pick Lists\nfor\nData Validation Cells",null,"Volume Conversion Table\n(VolTable) &\nNominal Value Unit\n(Nom_Val.List)",{"$nulls":9},"Cubical Coefficient of Expansion Table\n(CCE.Table)\n&\nMaterial List\n(Materal.List)",null,null,"ASTM E 288-06 Standard Specification For Laboratory Glass Volumetric Flasks",{"$nulls":5},"ASTM E 1272-02 Standard Specification For Laboratory Glass Graduated Cylinders",{"$nulls":3},"OIML R 43-1981 Standard Graduated Glass Flasks For Verification Officers",{"$nulls":3},"NIST Handbook 105-2 Specifications and Tolerances for Field Standard Measuring Flasks",{"$nulls":4},"NIST Handbook 105-3 Specifications and Tolerances for Graduated Neck Type Volumetric Field Standards",{"$nulls":3},"Tolerance Vlookup Table (tolerance)"]
[0,"TableError",null,1,1.41,null,"Reference Temperature (ºF)",null,"NomValueUnit","Vref Trial 1","Vref Trial","Vref","U (k=2)","RndFactor","Tolerance","Symbol","Nominal Value (mL)",null,"Material","cm³/ºC",null,null,"Class A","Class B","Class A \"Wide Mouth\"","Class B \"Wide Mouth\"",null,null,"Class A","Class B",null,null,"To Contain","To Deliver",null,"Capacity","Capacity (mL)","Tolerance (mL)","Type",null,"Capacity","Capacity (mL)","Tolerance (mL)",null,"Specification","Tolerance (mL)"]
[1e-12,13,null,2,1.3199999999999998,null,"Reference Temperature (ºC)",null,"Nominal Value (cubic inch)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},"in³",0,null,"Glass, Borosilicate (TICA)",1e-05,null,"Capacity (mL)","Tolerance (mL)","Tolerance (mL)","Tolerance (mL)","Tolerance (mL)",null,"Capacity (mL)","Tolerance (mL)","Tolerance (mL)",null,"Capacity (mL)","Tolerance (mL)","Tolerance (mL)",null,"50 mL",50,0.3,"cylinder",null,"1 gal",3785.412,0.7570824,null,"ASTM E 1272, Class A",{"$error":"#N/A"}]
[1e-11,12,null,3,1.23,{"$nulls":3},"Nominal Value (fluid ounce)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},"fl oz",0,null,"Glass, Borosilicate (TICB)",1.5e-05,null,5,0.02,0.04,0.08,0.16,null,5,0.05,0.1,null,10,0.05,0.075,null,"2 fl oz",59.14706,0.3,"cylinder",null,"5 L",5000,1,null,"ASTM E 1272, Class B",{"$error":"#N/A"}]
[1e-10,11,null,4,1.21,null,"Option A",null,"Nominal Value (gallon)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},"gal",0,null,"Glass, Soda-Lime",2.5e-05,null,10,0.02,0.04,0.08,0.16,null,10,0.1,0.2,null,20,0.08,0.12,null,"100 mL",100,0.2,"flask",null,"10 L",10000,2,null,"ASTM E 288, Class A",{"$error":"#N/A"}]
[1e-09,10,null,5,1.19,null,"Option B",null,"Nominal Value (gill)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},"gi",0,null,"Plastic, Polycarbonate",0.00045,null,25,0.03,0.06,0.08,0.16,null,25,0.17,0.34,null,50,0.12,0.18,null,"1 gill",118.2941,0.2,"flask",null,"5 gal",18927.059999999998,3.7854119999999996,null,"ASTM E 288, Class A \"Wide Mouth\"",{"$error":"#N/A"}]
[1e-08,9,null,6,1.184,{"$nulls":3},"Nominal Value (liquid pint)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},"pt",0,null,"Plastic, Polypropylene",0.00024,null,50,0.05,0.1,0.08,0.16,null,50,0.25,0.5,null,100,0.2,0.3,null,"1/2 pint",236.58825,0.3,"flask",null,"10 gal",37854.119999999995,7.570823999999999,null,"ASTM E 288, Class B",{"$error":"#N/A"}]
[1e-07,8,null,7,1.178,null,"To Deliver",null,"Nominal Value (liquid quart)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},"qt",0,null,"Plastic, Polystyrene",0.00021,null,100,0.08,0.16,0.1,0.2,null,100,0.5,1,null,200,0.3,0.4,null,"250 mL",250,0.3,"flask",null,"20 L",20000,4,null,"ASTM E 288, Class B \"Wide Mouth\"",{"$error":"#N/A"}]
[1e-06,7,null,8,1.172,null,"To Contain",null,"Nominal Value (liter)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},"L",0,null,"Silica, Fused (Quartz)",1.6e-06,null,200,0.1,0.2,0.2,0.4,null,250,1,2,null,250,0.3,0.45,null,"1 pt",473.1765,0.4,"flask",null,"50 L",50000,10,null,"NIST HB 105-2",{"$error":"#N/A"}]
[1e-05,6,null,9,1.166,{"$nulls":3},"Nominal Value (milliliter)",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#N/A"},{"$error":"#N/A"},"mL",0,null,"Steel, Prover, Low Carbon",3.35e-05,null,250,0.12,0.24,0.2,0.4,null,500,2,4,null,500,0.5,0.75,null,"1 qt",946.3529,0.7,"flask",null,"25 gal",94635.29999999999,18.927059999999997,null,"NIST HB 105-3",0.1]
[0.0001,5,null,10,1.16,null,"Yes",{"$nulls":11},"Steel, Stainless",4.77e-05,null,500,0.2,0.4,{"$nulls":3},1000,3,6,null,1000,0.8,1.2,null,"1000 mL",1000,0.8,"flask",null,"100 L",100000,20,null,"Not Applicable","N/A"]
[0.001,4,null,11,1.158,null,"No",{"$nulls":11},"Steel, Terneplate",3.5e-05,null,1000,0.3,0.6,{"$nulls":3},2000,6,12,null,2000,1.2,1.8,null,"1/2 gal",1892.706,1,"flask",null,"200 L",200000,40,null,"OIML R 43",{"$error":"#N/A"}]
[0.01,3,null,12,1.156,{"$nulls":16},2000,0.5,1,{"$nulls":3},4000,14.5,29,null,2500,1.4,2.1,null,"2000 mL",2000,1.2,"flask",null,"100 gal",378541.19999999995,75.70823999999999,null,"User Specified"]
[0.1,2,null,13,1.154,null,"Graduated Cylinder",{"$nulls":24},5000,2.5,3.75,null,"1 gal",3785.412,1.2,"flask",null,"500 L",500000,100]
[1,1,null,14,1.152,null,"Volumetric Flask",{"$nulls":24},10000,5,7.5,{"$nulls":6},"200 gal",757082.3999999999,151.41647999999998]
[10,0,null,15,1.15,null,"Volumetric Container",{"$nulls":33},"1000 L",1000000,200]
[100,-1,null,16,1.148,null,"Slicker Plate Standard",{"$nulls":33},"500 gal",1892706,378.5412]
[1000,-2,null,17,1.146,null,"Prover",{"$nulls":33},"2000 L",2000000,400]
[10000,-3,null,18,1.144,null,"Test Measure",{"$nulls":33},"3000 L",3000000,600]
[100000,-4,null,19,1.142,{"$nulls":35},"1000 gal",3785412,757.0824]
[1000000,-5,null,20,1.14,{"$nulls":35},"5000 L",5000000,1000]
[10000000,-6,null,21,1.1389999999999998,{"$nulls":35},"1500 gal",5678118,1135.6236000000001]
[100000000,-7,null,22,1.138]
[1000000000,-8,null,23,1.137]
[10000000000,-9,null,24,1.1360000000000001]
[100000000000,-10,null,25,1.1350000000000002]
[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  delivers the stated volume at the reference temperature from the specified graduation line\n    when it is emptied gradually within a 30 (± 5 seconds) pour and a 10-second drain while held at a 10º to 15º angle\n    from vertical."]
["●  The , when cleaned and dried, contains the stated volume at the reference temperature when\n    filled to its nominal graduation line. The  must always be cleaned and dried between successive\n    uses for purposes of accuracy."]
["●  The  delivers the stated volume at the reference temperature is when it is drained for a 30 (± 5)\n    second period after cessation of the main flow."]