{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Software Technical Assessment","Documentation","SOP 14","Instructions","Report Pages 1-3","Report Page 4","Data Entry","Control Data","Calculations","CIPM Air Density","Uncertainty Analysis","Tables & Lists"],"not_rendered":{"charts":1,"images":11,"external_links":4,"defined_names":180,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Software Technical Assessment","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"merged":[[5,0,17,0],[18,0,21,0],[22,0,25,0],[26,0,28,0],[29,0,34,0],[35,0,38,0],[39,0,40,0],[43,0,48,0],[56,4,56,5]]}
["Software Technical Assessment"]
[]
["Software Description","WAMRF-005 (Rev. 32), Volume Gravimetric Calibration Workbook","Approval Date","2015-11-06"]
["Assessed By","Dan Wright","Approved By","Dan Wright"]
["Codes","Assessment","Pass/Fail","Evidence"]
["A. Software Inspection","Spreadsheet is clear and makes sense","Pass","All worksheet are appropriately named and easy to understand"]
[null,"There are instructions for use ","Pass","Instructions worksheet"]
[null,"Instructions and data input appear on the visible portion of the first worksheet","Pass","The workbook opens to the instruction worksheet"]
[null,"Data-entry fields are labeled and color coded (it is recommended to avoid red and green)","Pass","Light yellow for blank, light blue for non-blank cells"]
[null,"The Standard Operating Procedure (SOP) used is clearly specified","Pass","Specified on Uncertainty worksheet"]
[null,"The number of digits to be rounded to is specified","Pass","Air Density and Water Density are rounded according to SOP 14 and the volume correction and uncertainty are rounded according to NISTIR 6969, GLP 9"]
[null,"The user is warned/notified whenever data-entry fields are left blank","Pass","In data validation cells only"]
[null,"Data-entry fields are “blank” when opened, preventing loss of old data and ensuring that old data is not used with the current calculations","Pass","Data entry fields on the workbook template are blank. Instructions tell user to break links before saving after a calibration is performed"]
[null,"The software opens at the right location within the file","Pass","Opens to the Instruction worksheet"]
[null,"Unused fields/cells are locked","Pass","Unused cells are locked and worksheets are protected"]
[null,"Rows/columns that the operator need not see are hidden","N/A","No hidden cells or worksheets"]
[null,"Unused sheets are removed","Pass","No unused worksheets"]
[null,"Worksheets are named appropriately","Pass","Worksheets are appropriately named"]
["B. Mathematical Specification","The correct SOP is used","Pass","SOP 14 in embedded"]
[null,"The formulae and methods chosen from that SOP are specified","Pass","Methods for option A or option B are selectable and formulae are show on the SOP 14 and Uncertainty worksheet"]
[null,"Sources and references for formulae are specified","Pass","As specified in SOP"]
[null,"The chosen SOP, its methods, and its formulae, are appropriate to the level of precision/uncertainty","Pass","For Volume I Gravimetric calibrations"]
["C. Code review","The formulae in the fields exactly match the SOP","Pass","Formulae on calculation worksheet match SOP"]
[null,"Repeated calculations appropriately reference the correct cells","Pass"]
[null,"Calculations, when tested using standard data or reference test data, show appropriate accuracy","Pass","Tested using SOP example "]
[null,"Rounding is done at the appropriate locations in the file","Pass","Air Density, Water Density, and end volume results rounded"]
["D. Numerical Stability","Calculations are stable as determined by an evaluation that uses large numbers and small differences","Pass","No issues encountered"]
[null,"Fields, therefore their content, are categorized as “Number” and not “General” when appropriate, and vice versa","Pass","Formatted correctly throughout workbook"]
[null,"“Number” cells are locked to a limited number of decimal places; this limit is appropriate to the values being used","Pass","Where appropriate"]
["E. Component Testing","Each macro used is functional","N/A","No Macros"]
[null,"Each command/button is functional","N/A","No command buttons"]
[null,"Combinations of interdependent macros are functional","Pass","No issues encountered"]
[null,"Plotted graphs are accurate","Pass","Graphs on uncertainty worksheet display properly"]
[null,"Worksheets/reports print properly, if needed to","Pass","Worksheets formatted for printing as necessary"]
[null,"Conditional (color and non-color) formatting is functional","Pass","On data entry and calculation worksheets"]
["F. Numerical Reference","Look-up tables and lists match the latest calibration report.","Pass","Linked tables are validated and up to date"]
[null,"Uncertainties match the latest Scope","Pass","Test on uncertainty worksheet will not allow an uncertainty that is better than the latest published scope"]
[null,"Values that reference another workbook or spreadsheet are dated","N/A","Linked references have been validated and are up to date"]
[null,"When a master list’s date is updated, the file references (A) an old value, (B) a default value, (C) displays zero or (D) an error message, as desired by the user","N/A"]
["G. Embedded Data Evaluation","Embedded data (conversion factors, reference values, etc) is correct","Pass","All embedded data has been validated"]
[null,"The evaluation of the embedded data is dated and documented","Pass","Records keep in Software Validation folder on computer hard drive"]
["H. Back-to-Back Testing","Newer spreadsheets and older spreadsheets agree down to the level of intermediate calculations; this evaluation is dated and documented","Pass","Evaluated and filed"]
["I. Analysis With Out Computer Assistance","Hand calculations agree with those generated by the spreadsheet, or if they disagree, the differences are significantly smaller than the reported uncertainty","N/A","No hand calculations were done"]
["J. Security","Equation and calculation cells are protected against inadvertent editing","Pass","Cells are locked and worksheets are password protected"]
[null,"Cells are locked in place; they cannot be moved/dragged","Pass","Locked and password protected"]
[null,"Confidentiality of passwords is appropriate","Pass","State Metrologist and Program Manager only have access"]
[null,"Files are backed up automatically","Pass","Backed up to agency servers weekly"]
[null,"Additional back-up is available at alternate facilities","Pass","Agency IT backs up servers weekly"]
[null,"Files on network drives cannot be accidentally deleted","Pass","Agency IT keeps an additional back up at a remote location"]

{"sheet":"Documentation","index":1,"n_rows":90,"n_cols":3,"rows_kept":90}
["Documentation"]
["Date","Description","Initials"]
["2001-06-14","This workbook was developed by Dan Wright, Washington State Department of Agriculture, Weights and Measures Program,  Metrology Laboratory. It follows the procedure documented in NISTIR 7383, SOP 14. NIST WMD has evaluated this spreadsheet and provided useful feedback in its development.","DAW"]
["2004-03-03","Updated water density formula to the Patterson/Morris equation provided by NIST, WMD.","DAW"]
["2004-05-12","Changed entire workbook to be more user friendly. Updated uncertainties.","DAW"]
["2004-09-07","Added new uncertainty analysis.","DAW"]
["2007-02-06","Corrected errors found during validation. Changed uncertainty analysis to the Kragten spreadsheet. Added tolerances for volumetric vessels.","DAW"]
["2007-03-30","Added unit column to temperature standards. Reformatted standards tables to make it easier to enter or delete standards.","DAW"]
["2007-09-24","Rounded air density formula to 6 places and water density formula to 8 places.","DAW"]
["2008-02-20","Removed 'Standards' worksheet. Linked customer and standards cells to the 'Customer' and 'Standards' workbooks. Reformatted 'Documentation' worksheet.","DAW"]
["2008-11-25","Modified row 21 of 'Data Entry' worksheet to reflect standard deviation of trials instead of range of trials.","DAW"]
["2008-11-25","Renamed 'Rmean' to 'PooledSD' in cell I21 on 'Data Entry' worksheet.","DAW"]
["2008-11-25","Modified row 33 of 'Calculations' worksheet to reflect standard deviation of trials instead of range of trials.","DAW"]
["2008-11-25","Changed cell 26 of 'Uncertainty Analysis' worksheet to reflect 'PooledSD' instead of 'Rmean'.","DAW"]
["2008-11-25","Deleted Table 9.1 on 'Tables & Lists' worksheet.","DAW"]
["2008-11-25","Added NIST standard to procedure on 'Reports Pages 1-3' worksheet.","DAW"]
["2009-01-22","Converted to Excel 2007, updated links.","DAW"]
["2009-01-22","Color coded data entry cells. Edited all comments.","DAW"]
["2009-01-22","Added Standards Used table on Data Entry worksheet.","DAW"]
["2009-01-22","Reformatted conditional formatting.","DAW"]
["2009-01-22","Redefined water temperature cells, added water temperature to Calculations sheet for each trial.","DAW"]
["2009-10-29","Removed tolerance worksheet. Linked to Volume Tolerances workbook.","DAW"]
["2009-10-29","Added information worksheet.","DAW"]
["2009-10-29","Validated links and updated data.","DAW"]
["2009-10-29","Validated workbook, file name \"WA2009-10-29 WAMRF-005 (Rev. 18), SOP 14 Workbook V&V.pdf\". Electronic files in laboratory computer C:\\ drive and agency server H:\\ drive and a paper copy in lab files.","DAW"]
["2010-03-19","Added water purity test to data entry sheet, modified sentence for water quality in report. (AR0166)","DAW"]
["2010-03-19","Validated workbook, file name \"WA2010-03-19 WAMRF-005 (Rev. 19), SOP 14 Workbook V&V.pdf\". Electronic files in laboratory computer C:\\ drive and agency server H:\\ drive and a paper copy in lab files.","DAW"]
["2010-09-02","Modified data entry cells for internal references verses external references where possible. Deleted unnecessary list on the Tables & Lists worksheet.","DAW"]
["2010-09-02","Modified Observations area of the Data Entry worksheet to clarify water temperature measurements.","DAW"]
["2010-09-02","Added Software Technical Assessment worksheet. Embedded latest version of SOP 14 in SOP 14 worksheet.","DAW"]
["2010-09-03","Validated external links. Updated NIST 105-3 uncertainty requirement on the calculations worksheet.","DAW"]
["2010-09-03","Validated workbook, file name \"WA2010-09-03 WAMRF-005 (Rev. 19), SOP 14 Workbook V&V.pdf\". Electronic files in laboratory computer C:\\ drive and agency server H:\\ drive and a paper copy in lab files.","DAW"]
["2012-02-15","Added FORMAT_CX and ROUND_UNC visual basic modules for rounding results and uncertainties IAW NISTIR 6969, GLP 9 using the FmtCX() and Rnd2() functions.","DAW"]
["2012-02-15","Added SI statement and conversion factors on the Report Pages 1-3 spreadsheet."]
["2012-02-15","Validated links and ranges.","DAW"]
["2012-02-15","Validated workbook, file name \"WA2012-02-15 WAMRF-005 (Rev. 21), SOP 14 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-04-06","Changed \"Certification Statement\" to \"Accreditation Statement\" on Report Pages 1-3 worksheet to be in compliance with NVLAP requirement Annex A, l). ","DAW"]
["2012-05-28","Embedded 2012 SOP","DAW"]
["2012-06-18","Updated water density formula on Calculations worksheet","DAW"]
["2012-06-18","Updated air density formula on CIPM Air Density worksheet","DAW"]
["2012-06-18","Modified Data Entry worksheet observations section and added degrees of freedom and best uncertainty k factor entries","DAW"]
["2012-06-18","Modified Uncertainty Analysis worksheet and references to water and air density formula uncertainties","DAW"]
["2012-06-18","Updated k factor based on degrees of freedom IAW SOP 29 (2012 edition)","DAW"]
["2012-06-18","Validated ranges and links","DAW"]
["2012-06-18","Validated workbook, file name \"WA2012-06-18 WAMRF-005 (Rev. 22), SOP 14 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-08-13","Inserted new WSDA Logo on \"Report Pages 1-3\" worksheet.","DAW"]
["2013-02-18","Removed GLP Rounding macros","DAW"]
["2013-02-18","Entered new rounding technique and corrected formulas","DAW"]
["2013-02-18","Validated links and range names.","DAW"]
["2013-02-18","Validated workbook, file name \"WA2013-02-18 WAMRF-005 (Rev. 23), SOP 14 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2013-09-18","Changed all ISBLANK() statements.","DAW"]
["2013-09-18","Redefined uncertainty components, added the Welch-Satterthwaite formula for effective degrees of freedom.","DAW"]
["2013-09-18","Revised the Control Data worksheet","DAW"]
["2013-09-18","Validated links and range names and spell checked.","DAW"]
["2013-09-18","Split Uncertainty Analysis to two worksheets, one for Option A and one for Option B.","DAW"]
["2013-09-18","Validated workbook, file name \"WA2013-09-18 WAMRF-005 (Rev. 24), SOP 14 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-05-30","Modified Data Entry sheet Mass Standards Data cells and names","DAW"]
["2014-05-30","Deleted Uncertainty Analysis Option A and Option B sheets and added new Uncertainty Analysis sheet","DAW"]
["2014-05-30","Validated range names and spell checked.","DAW"]
["2014-05-30","Validated workbook, file name \"WA2014-05-30 WAMRF-005 (Rev. 25), SOP 14 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-06-05","Added uncertainty for reading the meniscus.","DAW"]
["2014-06-05","Validated range names and spell checked.","DAW"]
["2014-06-05","Validated workbook, file name \"WA2014-06-05 WAMRF-005 (Rev. 26), SOP 14 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-06-06","Corrected uncertainty conversions for Mass and Mass Density uncertainties to mL.","DAW"]
["2014-06-06","Revised measurement process and uncertainties in-accordance-with SOP 14, dated April 2013."]
["2014-06-06","Validated range names and spell checked.","DAW"]
["2014-06-06","Validated workbook, file name \"WA2014-06-06 WAMRF-005 (Rev. 27), SOP 14 Workbook V&V (Option A & B).pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-06-12","Changed units on Uncertainty worksheet cells L94, L97, L100 & L103 to \"mL\" instead of \"mg\" & \"g\"","DAW"]
["2014-06-12","Validated range names and spell checked.","DAW"]
["2014-06-12","Validated workbook, file name \"WA2014-06-12 WAMRF-005 (Rev. 28), SOP 14 Workbook V&V (Option A & B).pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-06-30","Fixed formula in cell K101 on the Uncertainty Analysis worksheet which referenced the BestUk instead of the BestUdf value.","DAW"]
["2014-06-30","Made minor formatting changes to Calculations and Uncertainty worksheets.","DAW"]
["2014-06-30","Reworded the Uncertainty statement in the Report.","DAW"]
["2014-06-03","Validated range names and spell checked.","DAW"]
["2014-06-30","Validated workbook, file name \"WA2014-06-30 WAMRF-005 (Rev. 29), SOP 14 Workbook V&V (Option A & B).pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-10-29","Changed statistical df from 100 to 10000.","DAW"]
["2014-12-10","Deleted viscosity uncertainty, not enough information to analyze this uncertainty.","DAW"]
["2014-12-10","Corrected reference in effective degrees of freedom on Uncertainty worksheet and deleted extra plus sign. Changed J85^4/L86 to J85^4/L85.","DAW"]
["2014-12-10","Validated range names and spell checked.","DAW"]
["2014-12-10","Validated workbook, file name \"WA2014-12-10 WAMRF-005 (Rev. 30), SOP 14 Workbook V&V (Option A & B).pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-10-02","Based the Measurement Assurance Evaluation on the Calculations worksheet on SOP 17.","DAW"]
["2015-10-02","Changed PA1, PA2, PW1, PW2, tw1 & tw2 to PA_1, PA_2, PW_1, PW_2, tw_1 & tw_2 to prevent any excel errors.","DAW"]
["2015-10-02","Validated range names and spell checked.","DAW"]
["2015-10-02","Validated workbook, file name \"WA2015-10-02 WAMRF-005 (Rev. 31), SOP 14 Workbook V&V (Option A & B).pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-10-30","Corrected formulas for the Final U, Final df and Final k on the Uncertainty Analysis worksheet so it would correctly pick the Measured U or the Accredited U, whichever is greater.","DAW"]
["2015-10-30","Validated range names.","DAW"]
["2015-10-30","Validated workbook, file name \"WA2015-10-30 WAMRF-005 (Rev. 32), SOP 14 Workbook V&V (Option A & B).pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-11-06","Corrected formulas for the Final U, Final df and Final k on the Uncertainty Analysis worksheet so it would correctly pick the Measured U or the Accredited U, whichever is greater.","DAW"]
["2015-11-06","Validated range names.","DAW"]
["2015-11-06","Validated workbook, file name \"WA2015-11-06 WAMRF-005 (Rev. 32), SOP 14 Workbook V&V (Option A & B).pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]

{"sheet":"SOP 14","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Instructions","index":3,"n_rows":151,"n_cols":2,"rows_kept":151,"merged":[[0,0,0,1],[10,0,10,1]]}
["Instructions"]
["No.","Description"]
[1,"The uncertainty analysis used in this workbook is only one way of determining uncertainties for this measurement. Please review and insure this method meets your requirements and expectations. Modify as necessary."]
[2,"This workbook must be validated by the user before use and after any changes or modifications."]
[3,"The worksheets are password protected. Password is password. You should protect each sheet with your own unique password. Place a password hint here so you don't forget it. Password hint is: \"?\""]
[4,"Validate all ranges after any changes and during annual reviews."]
[5,"Open as a new workbook and save using the Report Number and customer name."]
[6,"Enter the appropriate data in the light yellow cells on the Data Entry worksheet."]
[7,"Modify both report worksheets for your laboratory and audit to insure the report meets requirements of ISO/IEC 17025. (hint: I convert the report worksheets to a .pdf file to keep as a permanent copy)."]
[8,"To view the SOP, unprotect the worksheet then double click on it. "]
["Range Names"]
["Name","Range"]
["a","='Data Entry'!$J$12"]
["A_tw1after","='Data Entry'!$I$69"]
["A_tw1before","='Data Entry'!$I$67"]
["A_tw2after","='Data Entry'!$I$84"]
["A_tw2before","='Data Entry'!$I$82"]
["B_tw1after","='Data Entry'!$I$101"]
["B_tw1before","='Data Entry'!$I$99"]
["B_tw2after","='Data Entry'!$I$117"]
["B_tw2before","='Data Entry'!$I$115"]
["BalUnits","='Data Entry'!$K$22"]
["BestU","='Data Entry'!$F$24"]
["BestUdf","='Data Entry'!$K$24"]
["BestUk","='Data Entry'!$I$24"]
["Cal_Date","='Data Entry'!$D$21"]
["CCE","='Tables & Lists'!$L$5:$M$14"]
["CIPM_Pa1","='CIPM Air Density'!$D$7"]
["CIPM_Pa2","='CIPM Air Density'!$D$13"]
["Condition","='Data Entry'!$D$16"]
["Cs_empty","='Data Entry'!$D$45"]
["Cs_filled","='Data Entry'!$D$41"]
["CustomerID","='Data Entry'!$K$4"]
["Description","='Data Entry'!$C$10"]
["Description_list","='Tables & Lists'!$A$4:$A$9"]
["df","='Data Entry'!$K$23"]
["df_Ms_empty","='Data Entry'!$I$45"]
["df_Ms_filled","='Data Entry'!$I$41"]
["Final_k","='Uncertainty Analysis'!$K$100"]
["Final_U","='Uncertainty Analysis'!$K$101"]
["Final_Veff","='Uncertainty Analysis'!$K$99"]
["Interval","='Data Entry'!$K$18"]
["IntervalQ","='Data Entry'!$F$18"]
["JO_No","='Data Entry'!$J$16"]
["k","='Uncertainty Analysis'!$K$94"]
["k_Ms_empty","='Data Entry'!$H$45"]
["k_Ms_filled","='Data Entry'!$H$41"]
["Line_w","='Data Entry'!$K$15"]
["Material","='Data Entry'!$C$12"]
["Material_List","='Tables & Lists'!$L$5:$L$14"]
["mcr","='Uncertainty Analysis'!$B$68"]
["MeasuredU","='Uncertainty Analysis'!$K$95"]
["MFG","='Data Entry'!$C$11"]
["Ms_empty","=Calculations!$C$17"]
["Ms_empty_nom","='Data Entry'!$C$45"]
["Ms_filled","=Calculations!$C$16"]
["Ms_filled_nom","='Data Entry'!$C$41"]
["Neck_d","='Data Entry'!$C$15"]
["Nom_Val_List","='Tables & Lists'!$C$5:$C$12"]
["NomVal","='Data Entry'!$D$13"]
["NomValueUnit","='Data Entry'!$A$13"]
["Obs1_Run1","=Calculations!$B$21"]
["Obs1_Run2","=Calculations!$F$21"]
["Obs2_Run1","=Calculations!$B$22"]
["Obs2_Run2","=Calculations!$F$22"]
["Obs3_Run1","=Calculations!$B$23"]
["Obs3_Run2","=Calculations!$F$23"]
["Obs4_Run1","=Calculations!$B$24"]
["Obs4_Run2","=Calculations!$F$24"]
["option","='Data Entry'!$J$25"]
["P_0","='Uncertainty Analysis'!$B$73"]
["P_1_Aend","='Data Entry'!$I$72"]
["P_1_Astart","='Data Entry'!$I$63"]
["P_1_Bend","='Data Entry'!$I$104"]
["P_1_Bstart","='Data Entry'!$I$94"]
["P_2_Aend","='Data Entry'!$I$87"]
["P_2_Astart","='Data Entry'!$I$78"]
["P_2_Bend","='Data Entry'!$I$120"]
["P_2_Bstart","='Data Entry'!$I$110"]
["P_corr","='Data Entry'!$D$51"]
["P_Ms_empty","='Data Entry'!$J$45"]
["P_Ms_filled","='Data Entry'!$J$41"]
["Pa_1","=Calculations!$C$5"]
["Pa_2","=Calculations!$C$6"]
["Pn","='Uncertainty Analysis'!$D$69"]
["PO_Number","='Data Entry'!$I$5"]
["POC_Name","='Data Entry'!$I$6"]
["POC_Phone","='Data Entry'!$I$7"]
["PooledSD","='Data Entry'!$F$23"]
["Pr","='Uncertainty Analysis'!$B$69"]
["Print_Titles","=Instructions!$11:$12"]
["Pt","='Uncertainty Analysis'!$B$70"]
["Pw_1","=Calculations!$C$12"]
["Pw_2","=Calculations!$C$13"]
["RefTemp","='Data Entry'!$J$13"]
["RefTempUnit","='Data Entry'!$G$13"]
["Reported_df","='Tables & Lists'!$H$13"]
["Reportedk","='Tables & Lists'!$F$13"]
["ReportedUnc","='Tables & Lists'!$D$13"]
["rh_corr","='Data Entry'!$D$52"]
["RptNo","='Data Entry'!$I$1"]
["SG_d","='Data Entry'!$G$15"]
["Slicker_Stmt","='Tables & Lists'!$A$21"]
["SN","='Data Entry'!$J$11"]
["Spec","='Data Entry'!$D$14"]
["Spec_List","='Tables & Lists'!$J$5:$J$15"]
["t_air_corr","='Data Entry'!$D$50"]
["t_air1_Aend","='Data Entry'!$I$71"]
["t_air1_Astart","='Data Entry'!$I$62"]
["t_air1_Bend","='Data Entry'!$I$103"]
["t_air1_Bstart","='Data Entry'!$I$93"]
["t_air2_Aend","='Data Entry'!$I$86"]
["t_air2_Astart","='Data Entry'!$I$77"]
["t_air2_Bend","='Data Entry'!$I$119"]
["t_air2_Bstart","='Data Entry'!$I$109"]
["t_water_corr","='Data Entry'!$D$49"]
["Tech","='Data Entry'!$G$21"]
["Tech_Int","='Data Entry'!$K$21"]
["ToContain_Stmt","='Tables & Lists'!$A$20"]
["ToDeliver_Stmt","='Tables & Lists'!$A$19"]
["Tol","='Data Entry'!$J$14"]
["tw_1","=Calculations!$C$10"]
["tw_2","=Calculations!$C$11"]
["TypeCal","='Data Entry'!$J$17"]
["TypeCal_List","='Tables & Lists'!$A$10:$A$11"]
["U_1_Aend","='Data Entry'!$I$73"]
["U_1_Astart","='Data Entry'!$I$64"]
["U_1_Bend","='Data Entry'!$I$105"]
["U_1_Bstart","='Data Entry'!$I$95"]
["U_2_Aend","='Data Entry'!$I$88"]
["U_2_Astart","='Data Entry'!$I$79"]
["U_2_Bend","='Data Entry'!$I$121"]
["U_2_Bstart","='Data Entry'!$I$111"]
["U_Ms_empty","='Data Entry'!$F$45"]
["U_Ms_filled","='Data Entry'!$F$41"]
["U_P","='Data Entry'!$F$51"]
["U_P_k","='Data Entry'!$H$51"]
["U_P_Ms_empty","='Data Entry'!$K$45"]
["U_P_Ms_filled","='Data Entry'!$K$41"]
["U_rh","='Data Entry'!$F$52"]
["U_rh_k","='Data Entry'!$H$52"]
["U_t","='Data Entry'!$F$50"]
["U_t_a_k","='Data Entry'!$H$50"]
["U_t_w","='Data Entry'!$F$49"]
["U_t_w_k","='Data Entry'!$H$49"]
["UCL","=Calculations!$C$45"]
["UPa","='Uncertainty Analysis'!$B$71"]
["Veff","='Uncertainty Analysis'!$K$93"]
["VolTable","='Tables & Lists'!$C$5:$H$12"]
["WL","=Calculations!$C$46"]
["WODate","='Data Entry'!$J$10"]

{"sheet":"Report Pages 1-3","index":4,"n_rows":94,"n_cols":7,"rows_kept":94,"merged":[[32,0,33,6],[37,5,37,6],[40,0,40,1],[40,2,40,6],[41,0,41,6],[57,3,57,4],[58,0,58,1],[58,3,58,4],[59,0,59,1],[59,3,59,4],[60,0,60,1],[60,3,60,4],[61,0,61,1],[61,3,61,4],[62,0,62,1],[62,3,62,4],[63,0,63,1],[63,3,63,4],[64,0,64,1],[64,3,64,4],[66,0,66,6],[68,0,68,6],[70,0,70,6],[71,0,71,6],[75,0,75,6],[76,0,76,6],[77,0,77,6],[78,0,78,6],[79,0,79,6],[80,0,80,6],[81,0,81,6],[86,0,86,2],[86,3,86,4],[86,5,86,6],[87,0,87,2],[87,3,87,4],[87,5,87,6],[89,0,89,2],[89,3,89,4],[89,5,89,6],[91,0,91,2],[91,3,91,4],[91,5,91,6],[92,0,92,2],[92,3,92,4],[92,5,92,6],[93,0,93,2],[93,3,93,4],[93,5,93,6]]}
{"$rows_empty":10}
[{"$nulls":3},"REPORT OF CALIBRATION"]
[]
[{"$nulls":3},"Issued To:"]
[{"$nulls":3},{"$f":"IF('Data Entry'!A4=\"\",\"\",'Data Entry'!A4)","v":""}]
[{"$nulls":3},{"$f":"IF('Data Entry'!A5=\"\",\"\",'Data Entry'!A5)","v":""}]
[{"$nulls":3},{"$f":"IF('Data Entry'!A6=\"\",\"\",'Data Entry'!A6)","v":""}]
[{"$nulls":3},{"$f":"IF('Data Entry'!A7=\"\",\"\",'Data Entry'!A7)","v":""}]
[]
[{"$nulls":3},"Point of Contact:"]
[{"$nulls":3},{"$f":"IF(POC_Name=\"\",\"\",POC_Name)","v":""}]
[{"$nulls":3},{"$f":"IF(POC_Phone=\"\",\"\",\"Ph. \"&POC_Phone)","v":""}]
[]
[{"$nulls":3},"Purchase Order Number:"]
[{"$nulls":3},{"$f":"IF(PO_Number=\"\",\"\",PO_Number)","v":""}]
[]
[{"$nulls":3},"Report Number:"]
[{"$nulls":3},{"$f":"IF(RptNo=\"\",\"\",RptNo)","v":""}]
[]
[{"$nulls":3},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
[]
[{"$nulls":3},{"$f":"IF(Cal_Date=\"\",\"Calibration Due Date\",IF(IntervalQ=\"yes\",\"Calibration Due Date: \"&TEXT(DATE(YEAR(Cal_Date),MONTH(Cal_Date)+Interval,DAY(Cal_Date)),\"mmmm d, yyyy\"),\"\"))","v":"Calibration Due Date"}]
[]
["This is to certify that the information contained in this report is true and correct as of the date of calibration."]
[]
[]
[]
[]
["Dan Wright, Program Specialist 3",{"$nulls":4},"Date of Issue"]
[]
[]
["Accreditation LOGO",null,"Accredited by the Accreditation Authority for the specific scope of accreditation under lab code XXXXXX-X. This report may not be used to claim product endorsement by Accreditation Authority or any other government agency, and may not be reproduced, except in full, without written approval from the laboratory."]
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":5},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
[]
["Artifact(s) Description"]
["Test Item:",{"$f":"IF(Description=\"\",\"\",Description)","v":""},null,null,"Date Received:",{"$f":"IF(WODate=\"\",\"\",TEXT(WODate,\"mmmm d, yyyy\"))","v":""}]
["Specification:",{"$f":"IF(Spec=\"\",\"\",Spec)","v":""},null,null,"Condition:",{"$f":"IF(Condition=\"\",\"\",Condition)","v":""}]
["Serial Number:",{"$f":"IF(SN=\"\",\"\",SN)","v":""},null,null,"Manufacture:",{"$f":"IF(MFG=\"\",\"\",MFG)","v":""}]
["Material:",{"$f":"IF(Material=\"\",\"\",Material)","v":""},null,null,"Delivery Type:",{"$f":"IF(TypeCal=\"\",\"\",TypeCal)","v":""}]
[]
["Calibration Information"]
["Job Order #:",{"$f":"IF(JO_No=\"\",\"\",JO_No)","v":""},null,null,"Temperature:",{"$f":"IF('CIPM Air Density'!D5=\"\",\"\",FIXED(AVERAGE('CIPM Air Density'!D5,'CIPM Air Density'!D11),1)&\" \"&CHAR(186)&\"C\")","v":""}]
["Metrologist:",{"$f":"IF(Tech=\"\",\"\",Tech)","v":""},null,null,"Humidity:",{"$f":"IF('CIPM Air Density'!D6=\"\",\"\",FIXED(AVERAGE('CIPM Air Density'!D6,'CIPM Air Density'!D12),1)&\" % RH\")","v":""}]
["Procedure:",{"$f":"\"NISTIR 7383, SOP 14, \"&option","v":"NISTIR 7383, SOP 14, "},null,null,"Pressure:",{"$f":"IF('CIPM Air Density'!D4=\"\",\"\",FIXED(AVERAGE('CIPM Air Density'!D4,'CIPM Air Density'!D10),1)&\" mm Hg\")","v":""}]
["Balance:",{"$f":"IF('Data Entry'!E22=\"\",\"\",'Data Entry'!E22)","v":""},null,null,"Water Temperature:",{"$f":"IF(tw_1=\"\",\"\",FIXED(AVERAGE(tw_1,tw_2),3)&\" \"&CHAR(186)&\"C\")","v":""}]
[]
["Laboratory Reference Standards Used"]
["Description",null,"Serial Number","Cert. Number",null,"Cal Date","Cal Due"]
[{"$f":"'Data Entry'!B29","v":0},null,{"$f":"'Data Entry'!F29","v":0},{"$f":"'Data Entry'!H29","v":0},null,{"$f":"'Data Entry'!J29","v":"00:00:00"},{"$f":"'Data Entry'!K29","v":"00:00:00"}]
[{"$f":"'Data Entry'!B30","v":0},null,{"$f":"'Data Entry'!F30","v":0},{"$f":"'Data Entry'!H30","v":0},null,{"$f":"'Data Entry'!J30","v":"00:00:00"},{"$f":"'Data Entry'!K30","v":"00:00:00"}]
[{"$f":"'Data Entry'!B31","v":0},null,{"$f":"'Data Entry'!F31","v":0},{"$f":"'Data Entry'!H31","v":0},null,{"$f":"'Data Entry'!J31","v":"00:00:00"},{"$f":"'Data Entry'!K31","v":"00:00:00"}]
[{"$f":"'Data Entry'!B32","v":0},null,{"$f":"'Data Entry'!F32","v":0},{"$f":"'Data Entry'!H32","v":0},null,{"$f":"'Data Entry'!J32","v":"00:00:00"},{"$f":"'Data Entry'!K32","v":"00:00:00"}]
[{"$f":"'Data Entry'!B33","v":0},null,{"$f":"'Data Entry'!F33","v":0},{"$f":"'Data Entry'!H33","v":0},null,{"$f":"'Data Entry'!J33","v":"00:00:00"},{"$f":"'Data Entry'!K33","v":"00:00:00"}]
[{"$f":"'Data Entry'!B34","v":0},null,{"$f":"'Data Entry'!F34","v":0},{"$f":"'Data Entry'!H34","v":0},null,{"$f":"'Data Entry'!J34","v":"00:00:00"},{"$f":"'Data Entry'!K34","v":"00:00:00"}]
[]
["Traceability Statement"]
["The artifact(s) described in this report have been compared to the Standards of the State of Washington. The Standards of the State of Washington 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 International System of Units (SI) for volume is the cubic meter (m³) (see Conversion Factors on page 3). The report number for this report is the only unique report number to be used in referencing measurement traceability for the artifact(s) described in this report."]
["Uncertainty Statement"]
["The combined standard uncertainty includes uncertainties for the standard(s), for the measurement process, for reading the meniscus, for the material cubical coefficient of expansion, for water density corrections, for air density corrections, for viscosity and for the environmental equipment used. The combined standard uncertainty is multiplied by a coverage factor, k, to give the expanded uncertainty, which defines an interval with a 95.45 % level of confidence. The expanded uncertainty presented in this report is consistent with NIST Technical Note 1297. A component for the effects of viscosity was not included in the uncertainty budget."]
["Accreditation Statement"]
["Accredited by the Accreditation Authority for the specified scope of accreditation under lab code XXXXXX-X. This laboratory meets the requirements of ISO/IEC 17025 and ANSI/NCSL Z540-1."]
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":5},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
[]
["Pertinent Information"]
["● In-accordance-with ISO/IEC FDIS 17025, General Requirements for the Competence of Testing and Calibration Laboratories, paragraph 5.10.4.4 ‘A calibration certificate (or calibration label) shall not contain any recommendation on the calibration interval except where this has been agreed with the client. This requirement may be superseded by legal regulations.’ "]
["●  In-accordance-with Washington Administrative Code (WAC) Chapter 16-663, Service Agents -- Reporting, Test Procedures, Standards And Calibration Of Weighing And Measuring Devices, Section 16-663-130, Adequacy of standards and submission of standards for certification, paragraph 2, ‘… All standards used for servicing, repairing and/or calibrating commercial weighing and measuring devices must be submitted at least every two years for examination and certification…’"]
[{"$f":"\"● \"&IF(AND('Data Entry'!D56<=5,'Data Entry'!D56>0.2),\"The artifact described above was calibrated using water that meets or exceeds ASTM D-1193 Type IV Reagent Water specifications.\",IF('Data Entry'!D56<0.3,\"The artifact described above was calibrated using water that meets or exceeds ASTM D-1193 Type III Reagent Water specifications.\"))","v":"● The artifact described above was calibrated using water that meets or exceeds ASTM D-1193 Type III Reagent Water specifications."}]
[{"$f":"IF(ISBLANK(TypeCal),\"\",IF(AND(TypeCal=\"To Deliver\",OR(Description=\"Slicker Plate Standard\",Description=\"Prover\")),Slicker_Stmt,IF(AND(TypeCal=\"To Deliver\",OR(Description=\"Graduated Cylinder\",Description=\"Volumetric Flask\",Description=\"Test Measure\")),ToDeliver_Stmt,IF(TypeCal=\"To Contain\",ToContain_Stmt))))","v":""}]
["● The results listed in this report relate only to the artifacts described and extent of calibrations performed."]
[{"$f":"IF(Description=\"Slicker Plate Standard\",\"\",\"●  The \"&Description&\" is considered in-tolerance when the error is equal to or less than the specified tolerance minus the measurement uncertainty.\")","v":"●  The  is considered in-tolerance when the error is equal to or less than the specified tolerance minus the measurement uncertainty."}]
[{"$f":"IF(Description=\"Slicker Plate Standard\",\"\",IF(ABS(Calculations!C40)<=ABS(Calculations!C41),\"●  The \"&Description&\" was found 'In-Tolerance', the \"&Description&\" may be used in testing without a correction.\",\"●  The \"&Description&\" was found 'Out-of-Tolerance', the user must use a correction for all testing.\"))","v":{"$error":"#VALUE!"}}]
[]
["Conversion Factors"]
["From NIST Special Publication 811, Guide for the Use of the International System of Units (SI)"]
["Factors in boldface are exact"]
["To convert from",null,null,"to",null,"multiply by"]
["cubic inch (in³)",null,null,"to cubic meter (m³)",null,"1.638 706 4 E-05"]
["fluid ounce (U.S.) (fl oz)",null,null,"to cubic meter (m³)",null,"2.957 353 E-05"]
["gallon (U.S.) (gal)",null,null,"to cubic meter (m³)",null,"3.875 412 E-03"]
["gill (U.S.) (gi)",null,null,"to cubic meter (m³)",null,"1.182 941 E-04"]
["liter (L)",null,null,"to cubic meter (m³)",null,"1.0 E-03"]
["pint (U.S. liquid) (liq pt)",null,null,"to cubic meter (m³)",null,"4.731 765 E-04"]
["quart (U.S. liquid) (liq qt)",null,null,"to cubic meter (m³)",null,"9.463 529 E-04"]

{"sheet":"Report Page 4","index":5,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,0,0,5]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":4},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
["Calibration Results"]
[{"$f":"IF(NomVal=\"\",\"Nominal Volume\",\"Nominal Volume (\"&VLOOKUP(NomValueUnit,VolTable,5)&\")\")","v":"Nominal Volume"},{"$f":"IF(NomVal=\"\",\"As Found/Left\",\"As Found/Left \n\"&TypeCal&\"\n (\"&VLOOKUP(NomValueUnit,VolTable,5)&\")\")","v":"As Found/Left"},"Reference\nTemperature",{"$f":"IF(Spec=\"\",\"Specification Tolerance\",IF(Spec=\"Not Applicable\",\"Tolerance \"&Spec,Spec&\" Specification \nTolerance\n± (\"&VLOOKUP(NomValueUnit,VolTable,5)&\")\"))","v":"Specification Tolerance"},{"$f":"IF(NomVal=\"\",\"Uncertainty\n\",\"Uncertainty\nk=\"&Reportedk&\"\ndf=\"&Reported_df&\"\n± (\"&VLOOKUP(NomValueUnit,VolTable,5)&\")\")","v":"Uncertainty\n"},"Cubical Coefficient of Expansion"]
[{"$f":"IF(NomVal=\"\",\"\",NomVal)","v":""},{"$f":"IF(Calculations!C50=\"\",\"\",Calculations!C50)","v":""},{"$f":"IF(RefTemp=\"\",\"\",IF(RefTempUnit=\"Reference Temperature (ºC)\",RefTemp&\" ºC\",RefTemp&\" ºF\"))","v":""},{"$f":"IF(OR(Spec=\"Not Applicable\",NomVal=\"\"),\"\",VLOOKUP(NomValueUnit,VolTable,4,FALSE))","v":""},{"$f":"IF(Calculations!C53=\"\",\"\",Calculations!C53)","v":""},{"$f":"IF(Material=\"\",\"\",IF(RefTempUnit=\"Reference Temperature (ºF)\",FIXED(a/1.8,7)&\" / ºF\",a&\" / ºC\"))","v":""}]

{"sheet":"Data Entry","index":6,"n_rows":122,"n_cols":11,"rows_kept":122,"merged":[[0,8,0,10],[3,0,3,6],[3,7,3,9],[4,0,4,6],[4,8,4,10],[5,0,5,6],[5,8,5,10],[6,0,6,6],[6,8,6,10],[9,0,9,1],[9,2,9,5],[9,6,9,8],[9,9,9,10],[10,0,10,1],[10,2,10,5],[10,6,10,8],[10,9,10,10],[11,0,11,1],[11,2,11,5],[11,6,11,8],[11,9,11,10],[12,0,12,2],[12,3,12,5],[12,6,12,8],[12,9,12,10],[13,0,13,2],[13,3,13,6],[13,7,13,8],[13,9,13,10],[14,0,14,1],[14,3,14,5],[14,7,14,9],[15,0,15,2],[15,3,15,7],[15,9,15,10],[16,0,16,8],[16,9,16,10],[17,0,17,4],[17,6,17,9],[20,0,20,2],[20,3,20,4],[20,6,20,8],[21,0,21,1],[21,4,21,7],[21,8,21,9],[22,0,22,4],[22,5,22,7],[22,8,22,9],[23,0,23,4],[23,5,23,6],[24,0,24,8],[24,9,24,10],[27,1,27,4],[27,5,27,6],[27,7,27,8],[28,1,28,4],[28,5,28,6],[28,7,28,8],[29,1,29,4],[29,5,29,6],[29,7,29,8],[30,1,30,4],[30,5,30,6],[30,7,30,8],[31,1,31,4],[31,5,31,6],[31,7,31,8],[32,1,32,4],[32,5,32,6],[32,7,32,8],[33,1,33,4],[33,5,33,6],[33,7,33,8],[36,3,36,4],[36,5,36,6],[37,0,40,0],[37,3,37,4],[37,5,37,6],[38,3,38,4],[38,5,38,6],[39,3,39,4],[39,5,39,6],[40,3,40,4],[40,5,40,6],[41,0,44,0],[41,3,41,4],[41,5,41,6],[42,3,42,4],[42,5,42,6],[43,3,43,4],[43,5,43,6],[44,3,44,4],[44,5,44,6],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[54,0,54,10],[55,0,55,2],[55,3,55,4],[55,5,55,10],[56,0,56,10],[59,0,59,7],[59,8,59,10],[60,0,63,3],[60,4,60,7],[60,8,60,10],[61,4,61,7],[61,8,61,10],[62,4,62,7],[62,8,62,10],[63,4,63,7],[63,8,63,10],[64,1,64,7],[64,8,64,10],[65,1,65,7],[65,8,65,10],[66,0,66,7],[66,8,66,10],[67,1,67,7],[67,8,67,10],[68,0,68,7],[68,8,68,10],[69,0,69,10],[70,0,73,3],[70,4,70,7],[70,8,70,10],[71,4,71,7],[71,8,71,10],[72,4,72,7],[72,8,72,10],[73,4,73,7],[73,8,73,10],[74,0,74,7],[74,8,74,10],[75,0,78,3],[75,4,75,7],[75,8,75,10],[76,4,76,7],[76,8,76,10],[77,4,77,7],[77,8,77,10],[78,4,78,7],[78,8,78,10],[79,1,79,7],[79,8,79,10],[80,1,80,7],[80,8,80,10],[81,0,81,7],[81,8,81,10],[82,1,82,7],[82,8,82,10],[83,0,83,7],[83,8,83,10],[84,0,84,10],[85,0,88,3],[85,4,85,7],[85,8,85,10],[86,4,86,7],[86,8,86,10],[87,4,87,7],[87,8,87,10],[88,4,88,7],[88,8,88,10],[89,0,89,10],[90,0,90,7],[90,8,90,10],[91,0,94,3],[91,4,91,7],[91,8,91,10],[92,4,92,7],[92,8,92,10],[93,4,93,7],[93,8,93,10],[94,4,94,7],[94,8,94,10],[95,1,95,7],[95,8,95,10],[96,1,96,7],[96,8,96,10],[97,1,97,7],[97,8,97,10],[98,0,98,7],[98,8,98,10],[99,1,99,7],[99,8,99,10],[100,0,100,7],[100,8,100,10],[101,0,101,10],[102,0,105,3],[102,4,102,7],[102,8,102,10],[103,4,103,7],[103,8,103,10],[104,4,104,7],[104,8,104,10],[105,4,105,7],[105,8,105,10],[106,0,106,7],[106,8,106,10],[107,0,110,3],[107,4,107,7],[107,8,107,10],[108,4,108,7],[108,8,108,10],[109,4,109,7],[109,8,109,10],[110,4,110,7],[110,8,110,10],[111,1,111,7],[111,8,111,10],[112,1,112,7],[112,8,112,10],[113,1,113,7],[113,8,113,10],[114,0,114,7],[114,8,114,10],[115,1,115,7],[115,8,115,10],[116,0,116,7],[116,8,116,10],[117,0,117,10],[118,0,121,3],[118,4,118,7],[118,8,118,10],[119,4,119,7],[119,8,119,10],[120,4,120,7],[120,8,120,10],[121,4,121,7],[121,8,121,10]]}
["Data Entry",{"$nulls":6},"Report Number:"]
[]
["Customer Information"]
[{"$nulls":7},"Customer ID"]
[{"$nulls":7},"PO#"]
[{"$nulls":7},"POC"]
[{"$nulls":7},"Phone"]
[]
["Artifact Information"]
["Description",{"$nulls":5},"Date Received"]
["Manufacture",{"$nulls":5},"Serial Number"]
["Material",{"$nulls":5},"Cubical Coefficient of Exp. (/ºC) =",null,null,{"$f":"IF(ISERROR(VLOOKUP(C12,CCE,2)),\"\",VLOOKUP(C12,CCE,2))","v":""}]
[]
["Artifact Specifications",{"$nulls":6},"Tolerance (mL)"]
["Neck Inside Dia. (mm)",null,null,"Sight Glass Inside Dia. (mm)",{"$nulls":3},"Graduation Line Width (mm)"]
["Artifact Condition",{"$nulls":7},"JO#"]
["Type of Volume Container (To Deliver for Wet Calibration or To Contain for Dry Calibration)"]
["Was a Calibration Interval Requested or is one Required?",{"$nulls":5},"What is the Calibration Interval (months)?"]
[]
["Measurement Information"]
["Date of Calibration",{"$nulls":4},"Technician",{"$nulls":3},"Tech. Int."]
["Balance ID Code",null,null,"Balance:",{"$nulls":4},"Balance Unit:"]
["Pooled Std Dev of the Trials from Control Chart (mL)",{"$nulls":7},"Degrees of Freedom"]
["Accredited U (e.g. NVLAP, A2LA, etc.) (mL)",{"$nulls":6},"U k factor",null,"U df"]
["Measurement Option (A = one point balance calibration; B = two point balance calibration)"]
[]
["Standards Used"]
["Standard Item ID","Description",{"$nulls":3},"Serial Number",null,"Report Number",null,"Calibration Date","Calibration Due"]
{"$rows_empty":7}
["Mass Standard(s) Data"]
["Mass ID","ID Code","Nominal Mass (g)","True Mass Correction (mg)",null,"Us (mg)",null,"k-factor","Degrees of Freedom","Density (g/cm3)","Uρs (g/cm3) k=1"]
[{"$f":"IF(option=\"\",\"\",\"Ms (filled)\")","v":""}]
[]
[]
[null,{"$f":"IF(option=\"\",\"\",\"Ms filled =\")","v":""},{"$f":"IF(C38=\"\",\"\",SUM(C38:C40))","v":""},{"$f":"IF(C38=\"\",\"\",SUM(D38:E40))","v":""},null,{"$f":"IF(C38=\"\",\"\",IF(AND(C39=\"\",C40=\"\"),F38/H38,IF(AND(ISNUMBER(F38),ISNUMBER(F39),F40=\"\"),SUM(F38/H38+F39/H39),SUM(F38/H38+F39/H39+F40/H40))))","v":""},null,{"$f":"IF(C38=\"\",\"\",1)","v":""},{"$f":"IF(C38=\"\",\"\",IF(AND(C39=\"\",C40=\"\"),I38,IF(AND(ISNUMBER(C38),ISNUMBER(C39),C40=\"\"),ROUNDDOWN(SQRT(((F38/H38)*I38^2+(F39/H39)*I39^2)/SUM((F38/H38)+(F38/H38))),0),ROUNDDOWN(SQRT(((F38/H38)*I38^2+(F39/H39)*I39^2+(F40/H40)*I40^2)/SUM((F38/H38)+(F39/H39)+(F40/H40))),0))))","v":""},{"$f":"IF(C38=\"\",\"\",IF(AND(ISNUMBER(C38),C39=\"\"),(Ms_filled_nom+Cs_filled/1000)/((C38+D38/1000)/J38),IF(AND(ISNUMBER(C38),ISNUMBER(C39),C40=\"\"),(Ms_filled_nom+Cs_filled/1000)/((C38+D38/1000)/J38+(C39+D39/1000)/J39),(Ms_filled_nom+Cs_filled/1000)/((C38+D38/1000)/J38+(C39+D39/1000)/J39+(C40+D40/1000)/J40))))","v":""},{"$f":"IF(C38=\"\",\"\",IF(AND(ISNUMBER(C38),C39=\"\"),(Ms_filled_nom+Cs_filled/1000)/((C38+D38/1000)/K38),IF(AND(ISNUMBER(C38),ISNUMBER(C39),C40=\"\"),(Ms_filled_nom+Cs_filled/1000)/((C38+D38/1000)/K38+(C39+D39/1000)/K39),(Ms_filled_nom+Cs_filled/1000)/((C38+D38/1000)/K38+(C39+D39/1000)/K39+(C40+D40/1000)/K40))))","v":""}]
[{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"Ms (empty/\ndrained)\")","v":""}]
[]
[]
[null,{"$f":"IF(OR(option=\"Option A\",option=\"\"),\"\",\"Ms empty =\")","v":""},{"$f":"IF(OR(option=\"Option A\",C42=\"\"),\"\",SUM(C42:C44))","v":""},{"$f":"IF(OR(option=\"Option A\",C42=\"\"),\"\",SUM(D42:E44))","v":""},null,{"$f":"IF(C42=\"\",\"\",IF(AND(C43=\"\",C44=\"\"),F42/H42,IF(AND(ISNUMBER(F42),ISNUMBER(F43),F44=\"\"),SUM(F42/H42+F43/H43),SUM(F42/H42+F43/H43+F44/H44))))","v":""},null,{"$f":"IF(OR(option=\"Option A\",C42=\"\"),\"\",1)","v":""},{"$f":"IF(C42=\"\",\"\",IF(AND(C43=\"\",C44=\"\"),I42,IF(AND(ISNUMBER(C42),ISNUMBER(C43),C44=\"\"),ROUNDDOWN(SQRT(((F42/H42)*I42^2+(F43/H43)*I43^2)/SUM((F42/H42)+(F42/H42))),0),ROUNDDOWN(SQRT(((F42/H42)*I42^2+(F43/H43)*I43^2+(F44/H44)*I44^2)/SUM((F42/H42)+(F43/H43)+(F44/H44))),0))))","v":""},{"$f":"IF(C42=\"\",\"\",IF(AND(ISNUMBER(C42),C43=\"\"),(Ms_empty_nom+Cs_empty/1000)/((C42+D42/1000)/J42),IF(AND(ISNUMBER(C42),ISNUMBER(C43),C44=\"\"),(Ms_empty_nom+Cs_empty/1000)/((C42+D42/1000)/J42+(C43+D43/1000)/J43),(Ms_empty_nom+Cs_empty/1000)/((C42+D42/1000)/J42+(C43+D43/1000)/J43+(C44+D44/1000)/J44))))","v":""},{"$f":"IF(C42=\"\",\"\",IF(AND(ISNUMBER(C42),C43=\"\"),(Ms_empty_nom+Cs_empty/1000)/((C42+D42/1000)/K42),IF(AND(ISNUMBER(C42),ISNUMBER(C43),C44=\"\"),(Ms_empty_nom+Cs_empty/1000)/((C42+D42/1000)/K42+(C43+D43/1000)/K43),(Ms_empty_nom+Cs_empty/1000)/((C42+D42/1000)/K42+(C43+D43/1000)/K43+(C44+D44/1000)/K44))))","v":""}]
[]
["Environmental Standard(s) Data"]
["Parameter",null,"ID Code","Correction",null,"U",null,"k factor",null,"Unit"]
["Temperature, Water",{"$nulls":8},"ºC"]
["Temperature, Air",{"$nulls":8},"ºC"]
["Barometric Pressure",{"$nulls":8},"mm Hg"]
["Humidity",{"$nulls":8},"% RH"]
[]
["Water Conductivity Test"]
["According to NISTIR 7383, SOP 14 and GLP 10, ASTM Type III or IV Reagent Water is recommended as adequate for gravimetric calibration purposes."]
["Conductivity Meter Indication",{"$nulls":4},"µS/cm @ 25 ºC"]
[{"$f":"IF(D56=\"\",\"\",IF(AND(D56<=5,D56>0.2),\"The water tested meets or exceeds ASTM D-1193 specifications for Type IV Reagent Water.\",IF(D56<0.3,\"The water tested meets or exceeds ASTM D-1193 specifications for Type III Reagent Water.\",\"The water tested is not suitable for gravimetric calibrations, find another source of water.\")))","v":""}]
[]
["Observations"]
[{"$f":"IF(option=\"Option B\",\"USE Option B Below!\",\"Option A - One Point Balance Calibration Trial 1\")","v":"Option A - One Point Balance Calibration Trial 1"},{"$nulls":7},{"$f":"\"Balance Unit = \"&BalUnits","v":"Balance Unit = "}]
["Starting Conditions Trial 1",{"$nulls":3},"Start Time (hh:mm)"]
[{"$nulls":4},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
["O1","Zero the balance, then place standard(s), MS filled, slightly larger than the mass of the filled vessel"]
["O2","Zero the balance, then place dry/wet-down vessel on balance"]
["Record temperature of water used to fill the vessel (ºC)"]
["O3","Zero the balance, then place filled vessel on balance"]
["Record temperature of water in vessel (ºC)"]
[{"$f":"IF(A_tw1after=\"\",\"\",IF(ABS(A_tw1before-A_tw1after)>0.2,\" ***Water Temperature is Outside Parameters, Redo Trial 1 ***\",\"*** Water Temperature is Within Parameters, Continue With Trial 2 Measurements ***\"))","v":""}]
["Ending Conditions Trial 1",{"$nulls":3},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
[{"$nulls":4},"End Time (hh:mm)"]
[{"$f":"IF(option=\"Option B\",\"USE Option B Below!\",\"Option A - One Point Balance Calibration Trial 2\")","v":"Option A - One Point Balance Calibration Trial 2"},{"$nulls":7},{"$f":"\"Balance Unit = \"&BalUnits","v":"Balance Unit = "}]
["Starting Conditions Trial 2",{"$nulls":3},"Start Time (hh:mm)"]
[{"$nulls":4},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
["O1","Zero the balance, then place standard(s), MS filled, slightly larger than the mass of the filled vessel"]
["O2","Zero the balance, then place dry/wet-down vessel on balance"]
["Record temperature of water used to fill the vessel (ºC)"]
["O3","Zero the balance, then place filled vessel on balance"]
["Record temperature of water in vessel (ºC)"]
[{"$f":"IF(A_tw2after=\"\",\"\",IF(ABS(A_tw2before-A_tw2after)>0.2,\" ***Water Temperature is Outside Parameters, Redo Trial 1 ***\",\"*** Water Temperature is Within Parameters, Continue With Trial 2 Measurements ***\"))","v":""}]
["Ending Conditions Trial 2",{"$nulls":3},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
[{"$nulls":4},"End Time (hh:mm)"]
[]
[{"$f":"IF(option=\"Option A\",\"USE Option A Above!\",\"Option B - One Point Balance Calibration Trial 1\")","v":"Option B - One Point Balance Calibration Trial 1"},{"$nulls":7},{"$f":"\"Balance Unit = \"&BalUnits","v":"Balance Unit = "}]
["Starting Conditions Trial 1",{"$nulls":3},"Start Time (hh:mm)"]
[{"$nulls":4},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
["O1","Zero the balance, then place standard(s), MS empty, slightly larger than the mass of the dry/wet-down vessel"]
["O2","Zero the balance, then place dry/wet-down vessel on balance"]
["O3","Zero the balance, then place standard(s), MS filled, slightly larger than the mass of the filled vessel"]
["Record temperature of water used to fill the vessel (ºC)"]
["O4","Zero the balance, then place filled vessel on balance"]
["Record temperature of water in vessel (ºC)"]
[{"$f":"IF(B_tw1after=\"\",\"\",IF(ABS(B_tw1before-B_tw1after)>0.2,\" ***Water Temperature is Outside Parameters, Redo Trial 1 ***\",\"*** Water Temperature is Within Parameters, Continue With Trial 2 Measurements ***\"))","v":""}]
["Ending Conditions Trial 1",{"$nulls":3},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
[{"$nulls":4},"End Time (hh:mm)"]
[{"$f":"IF(option=\"Option A\",\"USE Option A Above!\",\"Option B - One Point Balance Calibration Trial 2\")","v":"Option B - One Point Balance Calibration Trial 2"},{"$nulls":7},{"$f":"\"Balance Unit = \"&BalUnits","v":"Balance Unit = "}]
["Starting Conditions Trial 2",{"$nulls":3},"Start Time (hh:mm)"]
[{"$nulls":4},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
["O1","Zero the balance, then place standard(s), MS empty, slightly larger than the mass of the dry/wet-down vessel"]
["O2","Zero the balance, then place dry/wet-down vessel on balance"]
["O3","Zero the balance, then place standard(s), MS filled, slightly larger than the mass of the filled vessel"]
["Record temperature of water used to fill the vessel (ºC)"]
["O4","Zero the balance, then place filled vessel on balance"]
["Record temperature of water in vessel (ºC)"]
[{"$f":"IF(B_tw2after=\"\",\"\",IF(ABS(B_tw2before-B_tw2after)>0.2,\" ***Water Temperature is Outside Parameters, Redo Trial 1 ***\",\"*** Water Temperature is Within Parameters, Continue With Trial 2 Measurements ***\"))","v":""}]
["Ending Conditions Trial 2",{"$nulls":3},"Air Temperature (ºC)"]
[{"$nulls":4},"Barometric Pressure (mm Hg)"]
[{"$nulls":4},"Relative Humidity (% RH)"]
[{"$nulls":4},"End Time (hh:mm)"]

{"sheet":"Control Data","index":7,"n_rows":6,"n_cols":11,"rows_kept":6}
["Control Chart Information",{"$nulls":9},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Note: Copy and Paste Appropriate Row(s) to Control Chart"]
[]
["R-Chart Information"]
["Tech. Initials","Date","Test Number",{"$f":"IF(RefTempUnit=\"Reference Temerature (ºF)\",\"Volume (Trial 1) @ \"&RefTemp&\" ºF (mL)\",\"Volume (Trial 1) @ \"&RefTemp&\" ºC (mL)\")","v":"Volume (Trial 1) @  ºC (mL)"},{"$f":"IF(RefTempUnit=\"Reference Temerature (ºF)\",\"Volume (Trial 2) @ \"&RefTemp&\" ºF (mL)\",\"Volume (Trial 2) @ \"&RefTemp&\" ºC (mL)\")","v":"Volume (Trial 2) @  ºC (mL)"},"Start Humidity (% RH)","Finish Humidity (% RH)","Start Air Temp. (ºC)","Finish Air Temp. (ºC)","Water Temp. (Trial 1) (ºC)","Water Temp. (Trial 2) (ºC)"]
[{"$f":"IF(Tech_Int=\"\",\"\",Tech_Int)","v":""},{"$f":"IF(Cal_Date=\"\",\"\",Cal_Date)","v":""},{"$f":"IF(RptNo=\"\",\"\",RptNo)","v":""},{"$f":"Calculations!C29","v":""},{"$f":"Calculations!C30","v":""},{"$f":"'CIPM Air Density'!D6","v":""},{"$f":"'CIPM Air Density'!D12","v":""},{"$f":"'CIPM Air Density'!D5","v":""},{"$f":"'CIPM Air Density'!D11","v":""},{"$f":"IF(ISERROR(tw_1),\"\",tw_1)","v":""},{"$f":"IF(ISERROR(tw_2),\"\",tw_2)","v":""}]

{"sheet":"Calculations","index":8,"n_rows":53,"n_cols":8,"rows_kept":53,"merged":[[3,0,3,7],[4,2,4,3],[4,5,5,7],[5,2,5,3],[8,0,8,7],[9,2,9,3],[9,5,12,7],[10,2,10,3],[11,2,11,3],[12,2,12,3],[15,2,15,3],[16,2,16,3],[19,0,19,3],[19,4,19,7],[20,1,20,2],[20,5,20,6],[21,1,21,2],[21,5,21,6],[22,1,22,2],[22,5,22,6],[23,1,23,2],[23,5,23,6],[26,2,26,3],[26,5,27,7],[27,2,27,3],[28,2,28,3],[28,5,29,7],[29,2,29,3],[30,2,30,3],[33,0,33,7],[34,2,34,3],[34,5,35,7],[35,2,35,3],[38,0,38,7],[39,2,39,3],[39,5,40,7],[40,2,40,3],[43,0,43,7],[44,2,44,3],[44,5,46,7],[45,2,45,3],[46,2,46,3],[56,2,56,3]]}
["Calculations",{"$nulls":6},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Air Density Determinations"]
["Air density results are rounded to 9 digits (g/cm³) according to SOP 14 "]
[null,"Run 1 ρa =",{"$f":"IF(ISERROR(CIPM_Pa1/1000),\"\",CIPM_Pa1/1000)","v":""},null,"g/cm3","Air Density, SOP 2, Option B, 2012 (CIPM 2007)"]
[null,"Run 2 ρa =",{"$f":"IF(ISERROR(CIPM_Pa2/1000),\"\",CIPM_Pa2/1000)","v":""},null,"g/cm3"]
[]
["Water Density Determinations"]
["Water density results are rounded to 8 digits (g/cm³) according to SOP 14 "]
[null,"Water temperature Trial 1 =",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(A_tw1before+t_water_corr,A_tw1after+t_water_corr),AVERAGE(B_tw1before+t_water_corr,B_tw1after+t_water_corr)))","v":""},null,"º C","M. Tanaka, G. Girard, R. Davis, A. Peuto, and N. Bignell equation, Metrologia, 38, 301-309 (2001) Water Density Formula for Air Saturated Water"]
[null,"Water temperature Trial 2 =",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(A_tw2before+t_water_corr,A_tw2after+t_water_corr),AVERAGE(B_tw2before+t_water_corr,B_tw2after+t_water_corr)))","v":""},null,"º C"]
[null,"Run 1 ρw =",{"$f":"IF(option=\"\",\"\",ROUND((999.97495*(1-((tw_1-3.983035)^2*(tw_1+301.797))/(522528.9*(tw_1+69.34881))))/1000+(-4.612+0.106*tw_1)/1000000,8))","v":""},null,"g/cm3"]
[null,"Run 2 ρw =",{"$f":"IF(option=\"\",\"\",ROUND((999.97495*(1-((tw_2-3.983035)^2*(tw_2+301.797))/(522528.9*(tw_2+69.34881))))/1000+(-4.612+0.106*tw_2)/1000000,8))","v":""},null,"g/cm3"]
[]
["Mass Standards Report Values"]
[null,"Ms (filled) =",{"$f":"IF(option=\"\",\"\",Ms_filled_nom+Cs_filled/1000)","v":""},null,"g","true mass of standard(s)"]
[null,{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"Ms (empty/drained) =\")","v":""},{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",Ms_empty_nom+Cs_empty/1000)","v":""},null,{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"g\")","v":""},{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"true mass of standard(s)\")","v":""}]
[]
["Observation Values"]
["Trial 1",{"$nulls":3},"Trial 2"]
[{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",\"Option A\",\"Option B\"))&\" O1 =\"","v":" O1 ="},{"$f":"IF(option=\"\",\"\",IF(AND(BalUnits=\"mg\",option=\"Option A\"),'Data Entry'!I65/1000,IF(AND(BalUnits=\"mg\",option=\"Option B\"),'Data Entry'!I96/1000,IF(AND(BalUnits=\"g\",option=\"Option A\"),'Data Entry'!I65,'Data Entry'!I96))))","v":""},null,"g",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",\"Option A\",\"Option B\"))&\" O1 =\"","v":" O1 ="},{"$f":"IF(option=\"\",\"\",IF(AND(BalUnits=\"mg\",option=\"option a\"),'Data Entry'!I80/1000,IF(AND(BalUnits=\"mg\",option=\"option b\"),'Data Entry'!I112/1000,IF(AND(BalUnits=\"g\",option=\"option a\"),'Data Entry'!I80,'Data Entry'!I112))))","v":""},null,"g"]
[{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",\"Option A\",\"Option B\"))&\" O2 =\"","v":" O2 ="},{"$f":"IF(option=\"\",\"\",IF(AND(BalUnits=\"mg\",option=\"option a\"),'Data Entry'!I66/1000,IF(AND(BalUnits=\"mg\",option=\"option b\"),'Data Entry'!I97/1000,IF(AND(BalUnits=\"g\",option=\"option a\"),'Data Entry'!I66,'Data Entry'!I97))))","v":""},null,"g",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",\"Option A\",\"Option B\"))&\" O2 =\"","v":" O2 ="},{"$f":"IF(option=\"\",\"\",IF(AND(BalUnits=\"mg\",option=\"option a\"),'Data Entry'!I81/1000,IF(AND(BalUnits=\"mg\",option=\"option b\"),'Data Entry'!I113/1000,IF(AND(BalUnits=\"g\",option=\"option a\"),'Data Entry'!I81,'Data Entry'!I113))))","v":""},null,"g"]
[{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",\"Option A\",\"Option B\"))&\" O3 =\"","v":" O3 ="},{"$f":"IF(option=\"\",\"\",IF(AND(BalUnits=\"mg\",option=\"Option A\"),'Data Entry'!I68/1000,IF(AND(BalUnits=\"mg\",option=\"Option B\"),'Data Entry'!I98/1000,IF(AND(BalUnits=\"g\",option=\"Option A\"),'Data Entry'!I68,'Data Entry'!I98))))","v":""},null,"g",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",\"Option A\",\"Option B\"))&\" O3 =\"","v":" O3 ="},{"$f":"IF(option=\"\",\"\",IF(AND(BalUnits=\"mg\",option=\"option a\"),'Data Entry'!I83/1000,IF(AND(BalUnits=\"mg\",option=\"option b\"),'Data Entry'!I114/1000,IF(AND(BalUnits=\"g\",option=\"option a\"),'Data Entry'!I83,'Data Entry'!I114))))","v":""},null,"g"]
[{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"Option B\"&\" O4 =\")","v":""},{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",IF(AND(BalUnits=\"mg\",option=\"Option B\"),'Data Entry'!I100/1000,'Data Entry'!I100))","v":""},null,{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"g\")","v":""},{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"Option B\"&\" O4 =\")","v":""},{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",IF(AND(BalUnits=\"mg\",option=\"Option B\"),'Data Entry'!I116/1000,'Data Entry'!I116))","v":""},null,{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",\"g\")","v":""}]
[]
["Volume Determinations"]
[null,"Trial 1 Vt =",{"$f":"IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-Pa_1/P_Ms_filled)/Obs1_Run1))*(1/(Pw_1-Pa_1)),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-Pa_1/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-Pa_1/P_Ms_empty))))*(1/(Pw_1-Pa_1))))","v":""},null,"mL","trial 1 & 2 volume at measured temperature"]
[null,"Trial 2 Vt =",{"$f":"IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run2-Obs2_Run2)*(Ms_filled*(1-Pa_2/P_Ms_filled)/Obs1_Run2))*(1/(Pw_2-Pa_2)),(((Obs4_Run2/Obs3_Run2)*(Ms_filled*(1-Pa_2/P_Ms_filled)))-((Obs2_Run2/Obs1_Run2)*(Ms_empty*(1-Pa_2/P_Ms_empty))))*(1/(Pw_2-Pa_2))))","v":""},null,"mL"]
[null,{"$f":"IF(RefTempUnit=\"Reference Temperature (ºF)\",\"Trial 1 V @ \"&RefTemp&\" \"&CHAR(186)&\"F =\",\"Trial 1 V @ \"&RefTemp&\" \"&CHAR(186)&\"C =\")","v":"Trial 1 V @  ºC ="},{"$f":"IF(option=\"\",\"\",IF(RefTempUnit=\"Reference Temperature (ºF)\",C27*(1-a*(tw_1-((RefTemp-32)/1.8))),C27*(1-a*(tw_1-RefTemp))))","v":""},null,"mL","trial 1 & 2 volume at reference temperature"]
[null,{"$f":"IF(RefTempUnit=\"Reference Temperature (ºF)\",\"Trial 2 V @ \"&RefTemp&\" \"&CHAR(186)&\"F =\",\"Trial 2 V @ \"&RefTemp&\" \"&CHAR(186)&\"C =\")","v":"Trial 2 V @  ºC ="},{"$f":"IF(option=\"\",\"\",IF(RefTempUnit=\"Reference Temperature (ºF)\",C28*(1-a*(tw_2-((RefTemp-32)/1.8))),C28*(1-a*(tw_2-RefTemp))))","v":""},null,"mL"]
[null,{"$f":"IF(RefTempUnit=\"Reference Temperature (ºF)\",\"V @ \"&RefTemp&\" \"&CHAR(186)&\"F =\",\"V @ \"&RefTemp&\" \"&CHAR(186)&\"C =\")","v":"V @  ºC ="},{"$f":"IF(ISERROR(AVERAGE(C29,C30)),\"\",AVERAGE(C29,C30))","v":""},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.05 % of the measured volume."]
[null,{"$f":"IF(Spec=\"NIST HB 105-3\",\"0.05 % of Measured Volume =\",\"1/3 of Tolerance =\")","v":"1/3 of Tolerance ="},{"$f":"IF(Spec=\"\",\"\",IF(Spec=\"Not Applicable\",\"N/A\",IF(Spec=\"NIST HB 105-3\",0.05%*C31,Tol/3)))","v":""},null,"mL",{"$f":"IF(OR(C35=\"\",C35=\"N/A\"),\"\",IF(C36<C35,\"Uncertainty Meets Criteria.\",\"Uncertainty Fails Criteria, Re-evaluate or Use Different Calibration Method.\"))","v":""}]
[null,"Expanded Uncertainty =",{"$f":"IF(C31=\"\",\"\",IF(Spec=\"Not Applicable\",\"N/A\",ReportedUnc))","v":""},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 =",{"$f":"IF(C31=\"\",\"\",IF(Spec=\"Not Applicable\",\"N/A\",C31-VLOOKUP(NomValueUnit,VolTable,6,FALSE)))","v":""},null,"mL",{"$f":"IF(C40=\"\",\"\",IF(ABS(C40)<=ABS(C41),Description&\" is Within Tolerence.\",Description&\" is Out-Of-Tolerance.\"))","v":""}]
[null,"Tolerance - U (k≈2)=",{"$f":"IF(C31=\"\",\"\",IF(Spec=\"Not Applicable\",\"N/A\",Tol-ReportedUnc))","v":""},null,"mL"]
[]
["Measurement Control"]
["Criteria: If the values for the standard deviation chart fall outside of the warning limits but inside of the control limits, a decrease in precision is indicated. Other problems should be investigated. (NISTIR 7383,SOP 17, 4.3.3)"]
[null,"Upper Control Limit=",{"$f":"IF(ISBLANK(PooledSD),\"\",PooledSD*3)","v":""},null,"mL",{"$f":"IF(C47=\"\",\"\",IF(C47>UCL,\"The Standard Deviation Is Outside The Control Limits, Investigate The Problem, Then Redo The Measurements\",IF(AND(C47<=UCL,C47>WL),\"The Standard Deviation Is outside the Warning Limit but inside the Control Limit, Investigate The Problem, Then Redo The Measurements As Necessary\",IF(C47<=WL,\"The Standard Deviation Is In Control, Plot The Value On The Control Chart\"))))","v":""}]
[null,"Warning Limit =",{"$f":"IF(ISBLANK(PooledSD),\"\",PooledSD*2)","v":""},null,"mL"]
[null,"Std. Deviation of the Trials = ",{"$f":"IF(ISERROR(STDEV(C29,C30)),\"\",STDEV(C29,C30))","v":""},null,"mL"]
[]
["Results Formatted For Calibration Report"]
[null,{"$f":"IF(RefTempUnit=\"Reference Temerature (ºF)\",\"Volume @ \"&RefTemp&\" \"&CHAR(186)&\"F =\",\"Volume @ \"&RefTemp&\" \"&CHAR(186)&\"C =\")","v":"Volume @  ºC ="},{"$f":"IF(C31=\"\",\"\",VLOOKUP(NomValueUnit,VolTable,2,FALSE))","v":""},{"$f":"IF(C31=\"\",\"\",VLOOKUP(NomValueUnit,VolTable,5,FALSE))","v":""}]
[null,"Effective Degrees of Freedom =",{"$f":"Reported_df","v":""}]
[null,"k factor",{"$f":"Reportedk","v":""}]
[null,"Uncertainty (uc*k) =",{"$f":"IF(C31=\"\",\"\",VLOOKUP(NomValueUnit,VolTable,3,FALSE))","v":""},{"$f":"IF(C31=\"\",\"\",VLOOKUP(NomValueUnit,VolTable,5,FALSE))","v":""}]

{"sheet":"CIPM Air Density","index":9,"n_rows":13,"n_cols":5,"rows_kept":13,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2],[6,3,6,4],[8,0,8,4],[9,0,9,2],[9,3,9,4],[10,0,10,2],[10,3,10,4],[11,0,11,2],[11,3,11,4],[12,0,12,2],[12,3,12,4]]}
["CIPM Air Density",{"$nulls":3},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Air Density, SOP 2, Option B, 2012 (CIPM 2007)"]
["Air Density Calculation Run 1"]
[" Barometric Pressure (mm Hg)",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(P_1_Astart+P_corr,P_1_Aend+P_corr),AVERAGE(P_1_Bstart+P_corr,P_1_Bend+P_corr)))","v":""}]
[" Temperature (ºC)",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(t_air1_Astart+t_air_corr,t_air1_Aend+t_air_corr),AVERAGE(t_air1_Bstart+t_air_corr,t_air1_Bend+t_air_corr)))","v":""}]
[" Relative Humidity (%)",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(U_1_Astart+rh_corr,U_1_Aend+rh_corr),AVERAGE(U_1_Bstart+rh_corr,U_1_Bend+rh_corr)))","v":""}]
[" Calculated Air Density (mg/cm3)",null,null,{"$f":"IF(D6=\"\",\"\",((((D4*(133.322368421053))*(0.02896546))/((1-(((D4*133.322368421053)/(D5+273.15))*((0.00000158123)+((-0.000000029331)*(D5))+(0.00000000011043*D5^2)+(((0.000005707)+(-0.00000002051*D5))*((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316*(D5+273.15))+33.93711047+(-6343.1645/(D5+273.15))))/(D4*133.322368421053)))))+((0.00019898+(-0.000002376*D5))*(((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053))))^2))))+(((D4*133.322368421053)^2/((D5+273.15)^2)*(0.0000000000183+(-0.00000000765*(((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053))))^2))))))*(8.314472)*(D5+273.15)))*(1-((0.378*((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053)))))))))","v":""}]
[]
["Air Density Calculation Run 2"]
[" Barometric Pressure (mm Hg)",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(P_2_Astart+P_corr,P_2_Aend+P_corr),AVERAGE(P_2_Bstart+P_corr,P_2_Bend+P_corr)))","v":""}]
[" Temperature (ºC)",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(t_air2_Astart+t_air_corr,t_air2_Aend+t_air_corr),AVERAGE(t_air2_Bstart+t_air_corr,t_air2_Bend+t_air_corr)))","v":""}]
[" Relative Humidity (%)",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(U_2_Astart+rh_corr,U_2_Aend+rh_corr),AVERAGE(U_2_Bstart+rh_corr,U_2_Bend+rh_corr)))","v":""}]
[" Calculated Air Density (mg/cm3)",null,null,{"$f":"IF(D12=\"\",\"\",((((D10*(133.322368421053))*(0.02896546))/((1-(((D10*133.322368421053)/(D11+273.15))*((0.00000158123)+((-0.000000029331)*(D11))+(0.00000000011043*D11^2)+(((0.000005707)+(-0.00000002051*D11))*((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316*(D11+273.15))+33.93711047+(-6343.1645/(D11+273.15))))/(D10*133.322368421053)))))+((0.00019898+(-0.000002376*D11))*(((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316)*(D11+273.15)+33.93711047+(-6343.1645)/(D11+273.15)))/(D10*133.322368421053))))^2))))+(((D10*133.322368421053)^2/((D11+273.15)^2)*(0.0000000000183+(-0.00000000765*(((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316)*(D11+273.15)+33.93711047+(-6343.1645)/(D11+273.15)))/(D10*133.322368421053))))^2))))))*(8.314472)*(D11+273.15)))*(1-((0.378*((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316)*(D11+273.15)+33.93711047+(-6343.1645)/(D11+273.15)))/(D10*133.322368421053)))))))))","v":""}]

{"sheet":"Uncertainty Analysis","index":10,"n_rows":101,"n_cols":12,"rows_kept":101,"merged":[[0,2,0,5],[10,1,10,11],[21,1,21,11],[47,1,47,5],[47,6,47,11],[48,1,48,5],[48,6,48,11],[49,1,49,5],[49,6,49,11],[50,1,50,5],[50,6,50,11],[51,1,51,5],[51,6,51,11],[52,1,52,5],[52,6,52,11],[53,1,53,5],[53,6,53,11],[54,1,54,5],[54,6,54,11],[55,1,55,5],[55,6,55,11],[56,1,56,5],[56,6,56,11],[57,1,57,5],[57,6,57,11],[58,1,58,5],[58,6,58,11],[61,0,61,2],[61,3,61,5],[62,0,62,2],[62,3,62,5],[63,0,63,2],[63,3,63,5],[64,0,64,2],[64,3,64,5],[65,0,65,2],[65,3,65,5],[66,0,66,2],[66,3,66,5],[66,6,66,7],[67,0,67,2],[67,3,67,5],[67,6,67,7],[68,0,68,2],[68,3,68,5],[68,6,68,7],[69,0,69,2],[69,3,69,5],[69,6,69,7],[70,0,70,2],[70,3,70,5],[70,6,70,7],[71,0,71,2],[72,0,72,2],[72,5,72,6],[72,8,72,9],[72,10,72,11],[73,0,73,2],[73,5,73,6],[73,8,73,9],[73,10,73,11],[74,0,74,2],[74,5,74,6],[74,8,74,9],[74,10,74,11],[77,0,77,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[84,0,84,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[90,0,90,1]]}
["Uncertainty Analysis",{"$nulls":10},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Specify Procedure"]
["NISTIR 7383, SOP 14 Option A, Gravimetric Calibration of Volumetric Ware Using an Electronic Balance"]
[]
["Specify Equation(s)"]
["Measurement Option A - One Point Balance Calibration"]
[]
[]
["where"]
["Vt =","Represents either the \"to contain\" or \"to deliver\" volume (depending on whether O3 represents a dry or a \"wet down\" container at the temperature of measurement) (cm³ or mL)"]
["MS =","Mass standard(s) slightly more than the mass of the filled vessel (i.e., true mass, vacuum mass) (g)"]
["On =","Balance Observations"]
["ρa =","Density of air at the conditions of calibration (g/cm³)"]
["ρs =","Density of mass standards (g/cm³)"]
["ρw =","Density of water at temperature of measurement (g/cm³)"]
[]
["Measurement Option B - Two Point Balance Calibration"]
[]
[]
["where"]
["Vt =","Represents either the \"to contain\" or \"to deliver\" volume (depending on whether O3 represents a dry or a \"wet down\" container at the temperature of measurement) (cm³ or mL)"]
["MS1 =","Mass standard(s) slightly more than the mass of the empty/drained vessel (i.e., true mass, vacuum mass) (g)"]
["MS2 =","Mass standard(s) slightly more than the mass of the filled vessel (i.e., true mass, vacuum mass) (g)"]
["On =","Balance Observations"]
["ρa =","Density of air at the conditions of calibration (g/cm³)"]
["ρs =","Density of mass standards (g/cm³)"]
["ρw =","Density of water at temperature of measurement (g/cm³)"]
[]
["Volume at Reference Temperature"]
[]
[]
["where"]
["Vref =","Volume at reference temperature  (cm³ or mL @ ºF or ºC)"]
["α =","Coefficient of cubical expansion of the container being calibrated (see NISTIR 6969, Table 9.10)"]
["t =","Temperature of water (ºC)"]
["tref =","Reference temperature for the calibration (ºF of ºC)"]
[]
["Error in Reading Meniscus"]
[]
["where"]
["Vol =","Volume error in reading the meniscus"]
["=","The value of PI, 3.141 592 653 589 79"]
["r =","The radius of the internal diameter"]
["h =","The height of the graduation line or volume in question"]
[]
["Identify Components"]
["Component","Description",{"$nulls":4},"Reference"]
["s(p)","Uncertainty associated with the measurement process from the standard deviation of replicate measurements, normal distribution, 1s",{"$nulls":4},"NISTIR 7383, SOP 17, 4.1.3, A standard deviation may be calculated for each set of runs according to the appropriate SOP. A pooled standard deviation is then determined for the measurement process (value divided by 1.003 mL/g to convert sp from mL to g), Type A evaluation"]
["u(s)","Uncertainty associated with the weights used, normal distribution, k =1",{"$nulls":4},"Calibration Report divided by the k-factor, Type B Evaluation"]
["u(ρS)","Uncertainty associated with the density of the weights used,  rectangular distribution, k =1",{"$nulls":4},"Use reported or typical from manufactures stated density (typical range is 0.05 g/cm³). (See OIML R111-1:2004(E) B.7.9 Test Method F), Type B evaluation"]
["u(m)","Uncertainty associated with reading the meniscus of the standard and unknown vessel, triangular distribution",{"$nulls":4}," NISTIR 7383, GMP 3, page 4, equation for volume of a cylinder, Type B evaluation"]
["u(ρa)","Density of air using the CIPM 2007 Air Density Formula, rectangular distribution",{"$nulls":4},"Uncertainty for air buoyancy correction, NISTIR 6969, SOP 2, Para. 4, the uncertainty in the CIPM 2007 air density equation is 0.000 026 4 mg/cm³ or 0.002 2 % of normal air density, uniform distribution."]
["u(ρw)","Uncertainty in the density of water measurement, rectangular distribution",{"$nulls":4},"Metrologia, 46 (2009), 196-198, Density of water: roles of the CIPM and IAPWS standards, paragraph 2, 0.88 ppm (0.00000088 g/cm3), Type B evaluation"]
["u(tw)","Uncertainty of the thermometer used for measuring water temperature, rectangular distribution",{"$nulls":4},"NISTIR 7383, SOP 14, accurate to ± 0.1 ºC, Calibration Report divided by the k-factor, Type B evaluation"]
["u(CCE)","Uncertainty of the Coefficient of Cubical Expansion for the vessel material, rectangular distribution",{"$nulls":4},"EURAMET cg-19, paragraph 5.3.6 5 % to 10 % of CCE"]
["u(P)","Uncertainty of the thermometer used for measuring water temperature, rectangular distribution",{"$nulls":4},"NIST IR 7383, SOP 14, accurate to ± 135 Pa (1 mm Hg), Calibration Report divided by the k-factor, Type B evaluation"]
["u(t)","Uncertainty of the thermometer used for measuring air temperature, rectangular distribution",{"$nulls":4},"NISTIR 7383, SOP 14, accurate to ± 0.5 ºC, Calibration Report divided by the k-factor, Type B evaluation"]
["u(RH)","Uncertainty of the thermometer used for measuring water temperature, rectangular distribution",{"$nulls":4},"NISTIR 7383, SOP 14, accurate to ± 10 % RH, Calibration Report divided by the k-factor, Type B evaluation"]
[]
["Uncertainty Intermediate Calculations"]
["Meniscus",null,null,"Volume error in Neck (mL) =",null,null,{"$f":"IF(Neck_d=\"\",\"\",PI()*(Neck_d/2)^2*Line_w/1000)","v":""}]
[{"$nulls":3},"Volume error in Sight Glass (mL) =",null,null,{"$f":"IF(SG_d=\"\",\"\",PI()*(SG_d/2)^2*Line_w/1000)","v":""}]
[]
["Mass Density",null,null,"Trial 1 Vt (ρSE+uρSE) mL =",null,null,{"$f":"IF(OR(option=\"\",option=\"Option A\"),\"\",(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-Pa_1/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-Pa_1/(P_Ms_empty+D81)))))*(1/(Pw_1-Pa_1)))","v":""}]
[{"$nulls":3},"Trial 1 Vt (ρSF+uρSF) mL =",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-Pa_1/(P_Ms_filled+D83))/Obs1_Run1))*(1/(Pw_1-Pa_1)),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-Pa_1/(P_Ms_filled+D83))))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-Pa_1/P_Ms_empty))))*(1/(Pw_1-Pa_1))))","v":""}]
[]
["Air Density",null,null,"Trial 1 Vt (ρa+uρa) mL =",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-(Pa_1+D85/1000)/P_Ms_filled)/Obs1_Run1))*(1/(Pw_1-(Pa_1+D85/1000))),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-(Pa_1+D85/1000)/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-(Pa_1+D85/1000)/P_Ms_empty))))*(1/(Pw_1-(Pa_1+D85/1000)))))","v":""}]
["Water Density",null,null,"Trial 1 Vt (ρw+uρw) mL =",null,null,{"$f":"IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-Pa_1/P_Ms_filled)/Obs1_Run1))*(1/((Pw_1+D86)-Pa_1)),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-Pa_1/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-Pa_1/P_Ms_empty))))*(1/((Pw_1+D86)-Pa_1))))","v":""}]
["Water Temperature",null,null,"Run 1 ρw (tw + utw) g/cm³ =",null,null,{"$f":"IF(option=\"\",\"\",ROUND((999.97495*(1-(((tw_1+D87)-3.983035)^2*((tw_1+D87)+301.797))/(522528.9*((tw_1+D87)+69.34881))))/1000+(-4.612+0.106*(tw_1+D87))/1000000,8))","v":""}]
["Coefficient of Expansion",null,null,{"$f":"IF(RefTempUnit=\"Reference Temperature (ºF)\",\"Trial 1 V @ \"&RefTemp&\" \"&CHAR(186)&\"F =\",\"Trial 1 V @ \"&RefTemp&\" \"&CHAR(186)&\"C =\")&\" (CCE + uCCE) mL =\"","v":"Trial 1 V @  ºC = (CCE + uCCE) mL ="},null,null,{"$f":"IF(option=\"\",\"\",IF(RefTempUnit=\"Reference Temperature (ºF)\",Calculations!C27*(1-(a+D88)*(tw_1-((RefTemp-32)/1.8))),Calculations!C27*(1-(a+D88)*(tw_1-RefTemp))))","v":""}]
[]
["Barometric Pressure",null,null,"P (mm Hg) =",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(P_1_Astart+P_corr,P_1_Aend+P_corr),AVERAGE(P_1_Bstart+P_corr,P_1_Bend+P_corr)))","v":""},"P + uP (mm Hg) =",null,{"$f":"IF(E73=\"\",\"\",E73-D89)","v":""},"Run 1 ρa (P + uP) g/cm³ = ",null,{"$f":"IF(E73=\"\",\"\",((((H73*(133.322368421053))*(0.02896546))/((1-(((H73*133.322368421053)/(E74+273.15))*((0.00000158123)+((-0.000000029331)*(E74))+(0.00000000011043*E74^2)+(((0.000005707)+(-0.00000002051*E74))*((E75/100)*((1.00062+0.0000000314*(H73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316*(E74+273.15))+33.93711047+(-6343.1645/(E74+273.15))))/(H73*133.322368421053)))))+((0.00019898+(-0.000002376*E74))*(((E75/100)*((1.00062+0.0000000314*(H73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316)*(E74+273.15)+33.93711047+(-6343.1645)/(E74+273.15)))/(H73*133.322368421053))))^2))))+(((H73*133.322368421053)^2/((E74+273.15)^2)*(0.0000000000183+(-0.00000000765*(((E75/100)*((1.00062+0.0000000314*(H73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316)*(E74+273.15)+33.93711047+(-6343.1645)/(E74+273.15)))/(H73*133.322368421053))))^2))))))*(8.314472)*(E74+273.15)))*(1-((0.378*((E75/100)*((1.00062+0.0000000314*(H73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316)*(E74+273.15)+33.93711047+(-6343.1645)/(E74+273.15)))/(H73*133.322368421053)))))))))/1000","v":{"$error":"#VALUE!"}}]
["Air Temperature",null,null,"t (ºC) =",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(t_air1_Astart+t_air_corr,t_air1_Aend+t_air_corr),AVERAGE(t_air1_Bstart+t_air_corr,t_air1_Bend+t_air_corr)))","v":""},"t + ut (ºC) =",null,{"$f":"IF(E74=\"\",\"\",E74-D90)","v":""},"Run 1 ρa (t + ut) g/cm³ = ",null,{"$f":"IF(E74=\"\",\"\",((((E73*(133.322368421053))*(0.02896546))/((1-(((E73*133.322368421053)/(H74+273.15))*((0.00000158123)+((-0.000000029331)*(H74))+(0.00000000011043*H74^2)+(((0.000005707)+(-0.00000002051*H74))*((E75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*H74^2)*((EXP(0.000012378847*(H74+273.15)^2+(-0.019121316*(H74+273.15))+33.93711047+(-6343.1645/(H74+273.15))))/(E73*133.322368421053)))))+((0.00019898+(-0.000002376*H74))*(((E75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*H74^2)*((EXP(0.000012378847*(H74+273.15)^2+(-0.019121316)*(H74+273.15)+33.93711047+(-6343.1645)/(H74+273.15)))/(E73*133.322368421053))))^2))))+(((E73*133.322368421053)^2/((H74+273.15)^2)*(0.0000000000183+(-0.00000000765*(((E75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*H74^2)*((EXP(0.000012378847*(H74+273.15)^2+(-0.019121316)*(H74+273.15)+33.93711047+(-6343.1645)/(H74+273.15)))/(E73*133.322368421053))))^2))))))*(8.314472)*(H74+273.15)))*(1-((0.378*((E75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*H74^2)*((EXP(0.000012378847*(H74+273.15)^2+(-0.019121316)*(H74+273.15)+33.93711047+(-6343.1645)/(H74+273.15)))/(E73*133.322368421053)))))))))/1000","v":{"$error":"#VALUE!"}}]
["Relative Humidity",null,null,"RH (%) =",{"$f":"IF(option=\"\",\"\",IF(option=\"option a\",AVERAGE(U_1_Astart+rh_corr,U_1_Aend+rh_corr),AVERAGE(U_1_Bstart+rh_corr,U_1_Bend+rh_corr)))","v":""},"RH + uRH (%) =",null,{"$f":"IF(E75=\"\",\"\",E75-D91)","v":""},"Run 1 ρa (RH + uRH) g/cm³ = ",null,{"$f":"IF(E75=\"\",\"\",((((E73*(133.322368421053))*(0.02896546))/((1-(((E73*133.322368421053)/(E74+273.15))*((0.00000158123)+((-0.000000029331)*(E74))+(0.00000000011043*E74^2)+(((0.000005707)+(-0.00000002051*E74))*((H75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316*(E74+273.15))+33.93711047+(-6343.1645/(E74+273.15))))/(E73*133.322368421053)))))+((0.00019898+(-0.000002376*E74))*(((H75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316)*(E74+273.15)+33.93711047+(-6343.1645)/(E74+273.15)))/(E73*133.322368421053))))^2))))+(((E73*133.322368421053)^2/((E74+273.15)^2)*(0.0000000000183+(-0.00000000765*(((H75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316)*(E74+273.15)+33.93711047+(-6343.1645)/(E74+273.15)))/(E73*133.322368421053))))^2))))))*(8.314472)*(E74+273.15)))*(1-((0.378*((H75/100)*((1.00062+0.0000000314*(E73*133.322368421053)+0.00000056*E74^2)*((EXP(0.000012378847*(E74+273.15)^2+(-0.019121316)*(E74+273.15)+33.93711047+(-6343.1645)/(E74+273.15)))/(E73*133.322368421053)))))))))/1000","v":{"$error":"#VALUE!"}}]
[]
["Quantity, Convert, Combined, Expand & Report"]
["Component Description",null,"Component Symbol","Estimated Uncertainty","Units","Reported Unc\n(mL)","Type","Distribution","Factor to Normalize","Standard Unc\n(mL)","% Contribution","Degrees of Freedom"]
["Process Standard Deviation",null,{"$f":"A49","v":"s(p)"},{"$f":"IF(PooledSD=\"\",0,PooledSD)","v":0},"mL",{"$f":"D79","v":0},"A","Normal",1,{"$f":"F79/I79","v":0},{"$f":"IF($K$92=\"\",\"\",J79^2/$K$92^2)","v":""},{"$f":"IF(J79=0,1,df)","v":1}]
["Mass Standards (Empty)",null,"u(sE)",{"$f":"IF(OR(option=\"\",option=\"Option A\"),0,U_Ms_empty/1000)","v":0},"g",{"$f":"D80*1.003","v":0},"B","Normal",1,0,"",{"$f":"IF(J80=0,1,df_Ms_empty)","v":1}]
["Standards Density (Empty)",null,"u(ρSE)",{"$f":"IF(OR(option=\"\",option=\"Option A\"),0,U_P_Ms_empty)","v":0},"g/cm³",{"$f":"IF(D81=0,0,ABS(Calculations!C27-G65))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",{"$f":"IF(J81=0,1,df_Ms_empty)","v":1}]
["Mass Standards (Filled)",null,"u(sF)",{"$f":"IF(option=\"\",0,U_Ms_filled/1000)","v":0},"g",{"$f":"D82*1.003","v":0},"B","Normal",1,{"$f":"F82/I82","v":0},"",{"$f":"IF(J82=0,1,df_Ms_filled)","v":1}]
["Standards Density (Filled)",null,"u(ρSF)",{"$f":"IF(option=\"\",0,U_P_Ms_filled)","v":0},"g/cm³",{"$f":"IF(D83=0,0,ABS(Calculations!C27-G66))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},{"$f":"F83/I83","v":0},"",{"$f":"IF(J83=0,1,df_Ms_filled)","v":1}]
["Meniscus",null,{"$f":"A52","v":"u(m)"},{"$f":"IF(option=\"\",0,SUM(G62:G63))","v":0},"mL",{"$f":"D84","v":0},"B","Triangular",{"$f":"SQRT(6)","v":2.449489742783178},{"$f":"F84/I84","v":0},"",{"$f":"IF(J84=0,1,10000)","v":1}]
["Air Density",null,{"$f":"A53","v":"u(ρa)"},{"$f":"IF(Pa_1=\"\",0,0.000022*AVERAGE(Pa_1,Pa_2)*1000)","v":0},"mg/cm³",{"$f":"IF(D85=0,0,ABS(Calculations!C27-G68))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Water Density",null,"u(ρw)",{"$f":"IF(tw_1=\"\",0,0.00000088)","v":0},"g/cm³",{"$f":"IF(D86=0,0,ABS(Calculations!C27-G69))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Water Temperature",null,"u(tw)",{"$f":"IF(U_t_w=\"\",0,U_t_w/U_t_w_k)","v":0},"ºC",{"$f":"IF(D87=0,0,ABS(Calculations!C27-IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-Pa_1/P_Ms_filled)/Obs1_Run1))*(1/(G70-Pa_1)),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-Pa_1/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-Pa_1/P_Ms_empty))))*(1/(G70-Pa_1))))))","v":0},"B","Rectangular",1.7320508075688772,0,"",1]
["Coefficient of Expansion",null,"u(CCE)",{"$f":"IF(a=\"\",0,a*5%)","v":0},"/ºC",{"$f":"IF(D88=0,0,ABS(Calculations!C29-G71))","v":0},"B","Rectangular",1.7320508075688772,0,"",1]
["Barometric Pressure",null,"u(P)",{"$f":"IF(U_P=\"\",0,U_P/U_P_k)","v":0},"mm Hg",{"$f":"IF(D89=0,0,ABS(Calculations!C27-IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-K73/P_Ms_filled)/Obs1_Run1))*(1/(Pw_1-K73)),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-K73/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-K73/P_Ms_empty))))*(1/(Pw_1-K73))))))","v":0},"B","Rectangular",1.7320508075688772,0,"",1]
["Air Temperature",null,"u(t)",{"$f":"IF(U_t=\"\",0,U_t/U_t_a_k)","v":0},"ºC",{"$f":"IF(D90=0,0,ABS(Calculations!C27-IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-K74/P_Ms_filled)/Obs1_Run1))*(1/(Pw_1-K74)),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-K74/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-K74/P_Ms_empty))))*(1/(Pw_1-K74))))))","v":0},"B","Rectangular",1.7320508075688772,{"$f":"F90/I90","v":0},"",1]
["Relative Humidity",null,"u(RH)",{"$f":"IF(U_rh=\"\",0,U_rh/U_rh_k)","v":0},"% RH",{"$f":"IF(D91=0,0,ABS(Calculations!C27-IF(option=\"\",\"\",IF(option=\"Option A\",((Obs3_Run1-Obs2_Run1)*(Ms_filled*(1-K75/P_Ms_filled)/Obs1_Run1))*(1/(Pw_1-K75)),(((Obs4_Run1/Obs3_Run1)*(Ms_filled*(1-K75/P_Ms_filled)))-((Obs2_Run1/Obs1_Run1)*(Ms_empty*(1-K75/P_Ms_empty))))*(1/(Pw_1-K75))))))","v":0},"B","Rectangular",1.7320508075688772,0,"",1]
[{"$nulls":9},"Combined U (uc) =",{"$f":"IF(SUM(J79:J91)=0,\"\",SQRT(SUMSQ(J79:J91)))","v":""},"mL"]
[{"$nulls":9},"Effective Degrees of Freedom, Welch-Satterthwaite formula, NIST Technical Note 1297, (B-1) (veff) =",{"$f":"IF(MAX(L79:L91)=1,\"\",ROUNDDOWN(K92^4/((J79^4/L79)+(J80^4/L80)+(J81^4/L81)+(J82^4/L82)+(J83^4/L83)+(J84^4/L84)+(J85^4/L85)+(J86^4/L86)+(J87^4/L87)+(J88^4/L88)+(J89^4/L89)+(J90^4/L90)+(J91^4/L91)),0))","v":""}]
[{"$nulls":9},"k factor =",{"$f":"IF(Veff=\"\",\"\",ROUND(TINV(0.0455,Veff),3))","v":""}]
[{"$nulls":9},"Expanded U (uc*k) =",{"$f":"IF(k=\"\",\"\",k*K92)","v":""},"mL"]
[{"$nulls":9},"Accredited Effective Degrees of Freedom (veff) =",{"$f":"IF(G87=\"\",\"\",IF(BestU=\"\",0,BestUdf))","v":0}]
[{"$nulls":9},"Accredited k factor =",{"$f":"IF(G87=\"\",\"\",IF(BestU=\"\",0,BestUk))","v":0}]
[{"$nulls":9},"Accredited U =",{"$f":"IF(G87=\"\",\"\",IF(BestU=\"\",0,BestU))","v":0},"mL"]
[{"$nulls":9},"Final Effective Degrees of Freedom (veff) =",{"$f":"IF(Veff=\"\",\"\",IF(MeasuredU>K98,Veff,K96))","v":""}]
[{"$nulls":9},"Final k factor =",{"$f":"IF(k=\"\",\"\",IF(MeasuredU>K98,k,K97))","v":""}]
[{"$nulls":9},"Final U (uc*k) =",{"$f":"IF(MeasuredU=\"\",\"\",IF(MeasuredU>K98,MeasuredU,K98))","v":""},"mL"]

{"sheet":"Tables & Lists","index":11,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[2,2,2,7],[2,11,2,12],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[17,0,17,6],[18,0,18,6],[19,0,19,6],[20,0,20,6]]}
["Tables & Lists",{"$nulls":6},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""},null,"Tables & Lists",null,null,{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
[" Pick Lists\nfor\nData Validation Cells",null,"Volume Conversion Table\n(VolTable) &\nNominal Value Unit\n(Nom_Val_List)",{"$nulls":6},"Specification List",null,"Cubical Coefficient of Expansion Table\n(CCE_Table)\n&\nMaterial List\n(Materal_List)"]
["Graduated Cylinder",null,"NomValueUnit","Vref",{"$f":"\"U (k=\"&Reportedk&\")\"","v":"U (k=)"},"Tolerance","Symbol","Nominal Value (mL)",null,"Specification",null,"Material","cm³/ºC"]
["Volumetric Flask",null,"Nominal Value (cubic inch)",{"$f":"FIXED(Calculations!$C$31/16.38706,2-1-INT(LOG10(ABS(ReportedUnc/16.38706))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc/16.38706,2-1-INT(LOG10(ABS(ReportedUnc/16.38706))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol/16.38706,2-1-INT(LOG10(ABS(ReportedUnc/16.38706))),TRUE)","v":{"$error":"#VALUE!"}},"in³",{"$f":"NomVal*16.38706","v":0},null,"ASTM E 1272, Class A",null,"Glass, Borosilicate (TICA)",1e-05]
["Volumetric Container",null,"Nominal Value (fluid ounce)",{"$f":"FIXED(Calculations!$C$31/29.57353,2-1-INT(LOG10(ABS(ReportedUnc/29.57353))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc/29.57353,2-1-INT(LOG10(ABS(ReportedUnc/29.57353))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol/29.57353,2-1-INT(LOG10(ABS(ReportedUnc/29.57353))),TRUE)","v":{"$error":"#VALUE!"}},"fl oz",{"$f":"NomVal*29.57353","v":0},null,"ASTM E 1272, Class B",null,"Glass, Borosilicate (TICB)",1.5E-5]
["Slicker Plate Standard",null,"Nominal Value (gallon)",{"$f":"FIXED(Calculations!$C$31/3785.412,2-1-INT(LOG10(ABS(ReportedUnc/3785.412))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc/3785.412,2-1-INT(LOG10(ABS(ReportedUnc/3785.412))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol/3785.412,2-1-INT(LOG10(ABS(ReportedUnc/3785.412))),TRUE)","v":{"$error":"#VALUE!"}},"gal",{"$f":"NomVal*3785.412","v":0},null,"ASTM E 288, Class A",null,"Glass, Soda-Lime",2.5e-05]
["Prover",null,"Nominal Value (gill)",{"$f":"FIXED(Calculations!$C$31/118.2941,2-1-INT(LOG10(ABS(ReportedUnc/118.2941))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc/118.2941,2-1-INT(LOG10(ABS(ReportedUnc/118.2941))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol/118.2941,2-1-INT(LOG10(ABS(ReportedUnc/118.2941))),TRUE)","v":{"$error":"#VALUE!"}},"gi",{"$f":"NomVal*118.2941","v":0},null,"ASTM E 288, Class A \"Wide Mouth\"",null,"Plastic, Polycarbonate",0.00045]
["Test Measure",null,"Nominal Value (liquid pint)",{"$f":"FIXED(Calculations!$C$31/473.1765,2-1-INT(LOG10(ABS(ReportedUnc/473.1765))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc/473.1765,2-1-INT(LOG10(ABS(ReportedUnc/473.1765))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol/473.1765,2-1-INT(LOG10(ABS(ReportedUnc/473.1765))),TRUE)","v":{"$error":"#VALUE!"}},"liq pt",{"$f":"NomVal*473.1765","v":0},null,"ASTM E 288, Class B",null,"Plastic, Polypropylene",0.00024]
[null,null,"Nominal Value (liquid quart)",{"$f":"FIXED(Calculations!$C$31/946.3529,2-1-INT(LOG10(ABS(ReportedUnc/946.3529))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc/946.3529,2-1-INT(LOG10(ABS(ReportedUnc/946.3529))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol/946.3529,2-1-INT(LOG10(ABS(ReportedUnc/946.3529))),TRUE)","v":{"$error":"#VALUE!"}},"liq qt",{"$f":"NomVal*946.3529","v":0},null,"ASTM E 288, Class B \"Wide Mouth\"",null,"Plastic, Polystyrene",0.00021]
[null,null,"Nominal Value (liter)",{"$f":"FIXED(Calculations!$C$31/1000,2-1-INT(LOG10(ABS(ReportedUnc/1000))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc/1000,2-1-INT(LOG10(ABS(ReportedUnc/1000))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol/1000,2-1-INT(LOG10(ABS(ReportedUnc/1000))),TRUE)","v":{"$error":"#VALUE!"}},"L",{"$f":"NomVal*1000","v":0},null,"NIST HB 105-2",null,"Silica, Fused (Quartz)",1.6e-06]
[null,null,"Nominal Value (milliliter)",{"$f":"FIXED(Calculations!$C$31,2-1-INT(LOG10(ABS(ReportedUnc))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(ReportedUnc,2-1-INT(LOG10(ABS(ReportedUnc))),TRUE)","v":{"$error":"#VALUE!"}},{"$f":"FIXED(Tol,2-1-INT(LOG10(ABS(ReportedUnc))),TRUE)","v":{"$error":"#VALUE!"}},"mL",{"$f":"NomVal","v":0},null,"NIST HB 105-3",null,"Steel, Prover, Low Carbon",3.35e-05]
[null,null,"Final Unformatted Uncertainty =",{"$f":"Final_U","v":""},"mL            k =",{"$f":"Final_k","v":""},"df =",{"$f":"Final_Veff","v":""},null,"Not Applicable",null,"Steel, Stainless",4.77e-05]
[{"$nulls":9},"OIML R 43",null,"Steel, Terneplate",3.5e-05]
[{"$nulls":9},"User Specified"]
[]
[]
["Calibration Report Statements"]
[{"$f":"\"● The \"&Description&\" delivers the stated volume at the reference temperature from the specified graduation line when it is emptied gradually within a 30 (± 5 seconds) pour and a 10-second drain while held at a 10º to 15º angle from vertical.\"","v":"● The  delivers the stated volume at the reference temperature from the specified graduation line when it is emptied gradually within a 30 (± 5 seconds) pour and a 10-second drain while held at a 10º to 15º angle from vertical."}]
[{"$f":"\"● The \"&Description&\", when cleaned and dried, contains the stated volume at the reference temperature when filled to its nominal graduation line. The \"&Description&\" must always be cleaned and dried between successive uses for purposes of accuracy.\"","v":"● The , when cleaned and dried, contains the stated volume at the reference temperature when filled to its nominal graduation line. The  must always be cleaned and dried between successive uses for purposes of accuracy."}]
[{"$f":"\"● The \"&Description&\" delivers the stated volume at the reference temperature is when it is drained for a 30 (± 5) second period after cessation of the main flow.\"","v":"● The  delivers the stated volume at the reference temperature is when it is drained for a 30 (± 5) second period after cessation of the main flow."}]