{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Software Technical Assessment","Documentation","SOP 19","Instructions","Report Pages 1-3","Report Page 4","Prover Data Entry","Control Data","Calculations","Uncertainty Analysis","Tables & Lists"],"not_rendered":{"charts":1,"images":8,"external_links":4,"defined_names":136,"comments":2},"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-013 (Rev. 31), SOP 19 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 instructions 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","Water Density is rounded to 9 places and the volume correction and uncertainty are rounded according to NISTIR 6969, GLP 9 rounding rules"]
[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 19 in embedded"]
[null,"The formulae and methods chosen from that SOP are specified","Pass","Volume Transfer method"]
[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 II 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","Calculation worksheet"]
[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","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","Mo 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","Pass","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":79,"n_cols":3,"rows_kept":79}
["Documentation",null,{"$f":"IF(ISBLANK(RptNo),\"\",\"Report Number: \"&RptNo)","v":""}]
["Date","Description","Initials"]
["2004-01-30","This workbook was developed by Dan Wright, Washington State Department of Agriculture Metrology Laboratory. It follows the procedure documented in NISTIR 7383, SOP 19. 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.","DAW"]
["2004-03-05","Updated water density formula to the Patterson/Morris equation on the 'Uncertainty Analysis' worksheet.","DAW"]
["2004-03-11","Made suggested changed from NIST, WMD.","DAW"]
["2004-07-06","Updated uncertainty analysis to new format.","DAW"]
["2004-09-10","Updated uncertainty analysis.","DAW"]
["2005-03-22","Corrected Z60 formula on 'Uncertainty Analysis' worksheet.","DAW"]
["2005-10-16","Removed unnecessary information on 'NSCV Data Entry' worksheet.","DAW"]
["2006-09-01","Complete revision.","DAW"]
["2006-11-14","Changed reference to ASTM 674 to ASTM 694 on 'Uncertainty Analysis' worksheet.","DAW"]
["2006-11-14","Deleted uncertainty for viscosity and added statement to report of calibration.","DAW"]
["2006-11-14","Deleted note about standard reference temperature.","DAW"]
["2007-02-07","Major revision. Updated to Kragten uncertainty spreadsheet, added tolerances, added metric vessel capability, etc.","DAW"]
["2007-03-30","Reformatted standards tables.","DAW"]
["2007-04-05","Fixed conditional formatting in uncertainty test on the 'Calculations' worksheet.","DAW"]
["2007-09-24","Rounded water density formulas to 8 places, revised tolerance evaluation, and revised 'NSCV Data Entry' worksheet.","DAW"]
["2008-01-10","Revised 'NSCV Data Entry' worksheet.","DAW"]
["2008-02-07","Removed 'NSCV Data Entry' worksheet.","DAW"]
["2008-06-10","Added 'Control Data' worksheet, removed 'Standards' worksheet, reformatted vlookup formulas to global standards workbooks, and revised 'Documentation' worksheet.","DAW"]
["2009-01-21","Color coded data entry cells. Edited all comments.","DAW"]
["2009-01-21","Added Standards Used table on Data Entry worksheet.","DAW"]
["2009-10-30","Added Information worksheet.","DAW"]
["2009-10-30","Validated ranges.","DAW"]
["2009-10-30","Validated workbook, file name \"WA2009-10-30 WAMRF-013 (Rev. 20), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2010-03-26","Updated tolerance and uncertainty criteria on 'Calculations' sheet to NIST HB 105-3(2010) specifications.","DAW"]
["2010-03-26","Removed NSCV value. The neck scale either meets the new specification tolerances or it is rejected.","DAW"]
["2010-03-26","Updated links and formulas in Volume Standard(s) data to changes in Standards workbook, Volume Standards worksheet.","DAW"]
["2010-03-26","Added Software Technical Assessment and SOP 19 worksheets, renamed Information worksheet to Instructions.","DAW"]
["2010-03-26","Validated ranges.","DAW"]
["2010-03-26","Validated workbook, file name \"WA2010-03-26 WAMRF-013 (Rev. 21), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-02-14","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-14","Added SI statement and conversion to the Traceability paragraph on the Report Pages 1-3 spreadsheet."]
["2012-02-14","Validated ranges.","DAW"]
["2012-02-14","Validated workbook, file name \"WA2012-02-14 WAMRF-013 (Rev. 22), SOP 19 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-05-31","Updated water density formula on Calculations worksheet","DAW"]
["2012-06-01","Updated reference to the new water density formula on the Uncertainty Analysis worksheet","DAW"]
["2012-06-01","Added degrees of freedom and best uncertainty k factor to the Data Entry worksheet","DAW"]
["2012-06-01","Updated k factor based on degrees of freedom IAW SOP 29 (2012 edition)","DAW"]
["2012-06-01","Added k factor column to report page 4 and updated uncertainty statement on report page 1-3","DAW"]
["2012-06-01","Validated ranges.","DAW"]
["2012-06-01","Validated workbook, file name \"WA2012-06-01 WAMRF-013 (Rev. 23), SOP 19 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-15","Removed GLP Rounding macros","DAW"]
["2013-02-15","Entered new rounding technique and corrected formulas.","DAW"]
["2013-02-15","Validated range names.","DAW"]
["2013-02-15","Validated workbook, file name \"WA2013-02-15 WAMRF-013 (Rev. 24), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2013-04-02","Updated the tolerance test formulas and conditional formatting to include the uncertainty on Report Pages 1-3, row 82, Report Page 4, cells B5 & C5, Calculations, row 39, cells H41 & H42.","DAW"]
["2013-04-02","Validated range names.","DAW"]
["2013-04-02","Validated workbook, file name \"WA2013-04-02 WAMRF-013 (Rev. 25), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2013-06-26","Corrected gallon to cubic meter conversion on line 90 of the Report Pages 1-3 spreadsheet.","DAW"]
["2013-08-29","Changed all ISBLANK() statements.","DAW"]
["2013-08-29","Redefined uncertainty components, added the Welch-Satterthwaite formula for effective degrees of freedom.","DAW"]
["2013-08-29","Revised the Control Data worksheet","DAW"]
["2013-08-29","Validated range names and spell checked.","DAW"]
["2013-08-29","Validated workbook, file name \"WA2013-08-29 WAMRF-013 (Rev. 26), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-01-10","Linked Data Entry cells F18, H18 & J18 to the YYYY_BEST_UNC workbook.","DAW"]
["2014-06-26","Updated data input and uncertainties in accordance with NISTIR 7383, SOP 19 (2013 edition).","DAW"]
["2014-06-26","Validated range names and spell checked.","DAW"]
["2014-06-26","Validated workbook, file name \"WA2014-06-26 WAMRF-013 (Rev. 27), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-10-22","Deleted viscosity uncertainty, not enough information to analyze this uncertainty.","DAW"]
["2014-10-29","Changed statistical df from 100 to 10000.","DAW"]
["2014-10-31","Validated range names.","DAW"]
["2014-10-31","Validated workbook, file name \"WA2014-10-31 WAMRF-013 (Rev. 28), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-02-20","Modified Table 2 description and narrative on Report Pages 4 (Linked to Prover Data Entry Description.).","DAW"]
["2015-07-14","Corrected formula for effective degrees of freedom on the Uncertainty Analysis worksheet for the standards used. Was not accounting for all the drops.","DAW"]
["2015-07-14","Validated range names.","DAW"]
["2015-07-14","Validated workbook, file name \"WA2015-07-14 WAMRF-013 (Rev. 29), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-09-24","Changed 'Neck Scale Reading As Left' to  'Trial 1 Final Neck Scale Reading' in cell A83 of the Data Entry worksheet to make it less confusing.","DAW"]
["2015-09-24","Based the Measurement Assurance Evaluation on the Calculations worksheet on SOP 17.","DAW"]
["2015-09-24","Updated Control Chart worksheet.","DAW"]
["2015-09-24","Validated range names.","DAW"]
["2015-09-24","Validated workbook, file name \"WA2015-09-24 WAMRF-013 (Rev. 30), SOP 19 Workbook V&V.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-013 (Rev. 31), SOP 19 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]

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

{"sheet":"Instructions","index":3,"n_rows":105,"n_cols":2,"rows_kept":105,"merged":[[0,0,0,1],[7,0,7,1]]}
["Instructions"]
["No.","Description"]
[1,"This workbook must be validated after any changes or modifications."]
[2,"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: \"?\""]
[3,"Validate all links and ranges after any changes and during annual reviews."]
[4,"Modify the report pages with your laboratory and accreditation authority information."]
[5,"Modify the footer information on the report sheets and the header information on all other sheets if you want to use your own form number for the template."]
["Range Names"]
["Name","Range"]
["_unc1","='Prover Data Entry'!$H$37"]
["_unc2","='Prover Data Entry'!$H$38"]
["_unc3","='Prover Data Entry'!$H$39"]
["_unc4","='Prover Data Entry'!$H$40"]
["a_1","='Prover Data Entry'!$F$43"]
["a_2","='Prover Data Entry'!$F$44"]
["a_3","='Prover Data Entry'!$F$45"]
["a_4","='Prover Data Entry'!$F$46"]
["AirTemp","='Prover Data Entry'!$D$54"]
["AirTemp_F","='Prover Data Entry'!$D$86"]
["Answer_List","='Tables & Lists'!$D$15:$D$16"]
["AsFound","=Calculations!$E$58"]
["AsLeft","=Calculations!$E$59"]
["B","='Prover Data Entry'!$J$14"]
["BestU","='Prover Data Entry'!$F$20"]
["BestUdf","='Prover Data Entry'!$K$20"]
["BestUk","='Prover Data Entry'!$I$20"]
["Bus_Name","='Prover Data Entry'!$C$4"]
["Cal_Date","='Prover Data Entry'!$C$22"]
["CCE_Table","='Tables & Lists'!$A$5:$B$9"]
["CL","=Calculations!$E$51"]
["Condition","='Prover Data Entry'!$C$16"]
["CustomerID","='Prover Data Entry'!$K$4"]
["Description","='Prover Data Entry'!$C$10"]
["Description_list","='Tables & Lists'!$D$24:$D$25"]
["df","='Prover Data Entry'!$K$19"]
["drops1","='Prover Data Entry'!$E$37"]
["drops2","='Prover Data Entry'!$E$38"]
["drops3","='Prover Data Entry'!$E$39"]
["drops4","='Prover Data Entry'!$E$40"]
["Eff_df","=Calculations!$E$60"]
["Final_k","='Uncertainty Analysis'!$K$100"]
["Final_U","='Uncertainty Analysis'!$K$101"]
["Final_Veff","='Uncertainty Analysis'!$K$99"]
["GradNeck_List","='Tables & Lists'!$D$4:$D$5"]
["GradNeckVol","='Prover Data Entry'!$J$12"]
["Humidity","='Prover Data Entry'!$G$54"]
["Humidity_F","='Prover Data Entry'!$G$86"]
["Interval","='Prover Data Entry'!$K$21"]
["IntervalQ","='Prover Data Entry'!$F$21"]
["JobNo","='Prover Data Entry'!$J$16"]
["k","='Uncertainty Analysis'!$K$94"]
["k_1","='Prover Data Entry'!$J$37"]
["k_2","='Prover Data Entry'!$J$38"]
["k_3","='Prover Data Entry'!$J$39"]
["k_4","='Prover Data Entry'!$J$40"]
["kfactor","=Calculations!$E$61"]
["Line_w","='Prover Data Entry'!$K$15"]
["Material","='Prover Data Entry'!$C$14"]
["Material_List","='Tables & Lists'!$A$5:$A$9"]
["MeasuredU","='Uncertainty Analysis'!$K$95"]
["MFG","='Prover Data Entry'!$C$11"]
["Nom_Val","='Prover Data Entry'!$C$12"]
["NomVal_list","='Tables & Lists'!$D$18:$D$19"]
["NomValUnit","='Prover Data Entry'!$A$12"]
["PO_No","='Prover Data Entry'!$I$5"]
["POC_Name","='Prover Data Entry'!$I$6"]
["POC_Phone","='Prover Data Entry'!$I$7"]
["PooledSD","='Prover Data Entry'!$F$19"]
["PooledSD_List","='Tables & Lists'!$D$12:$D$13"]
["PooledSD_Unit","='Prover Data Entry'!$A$19"]
["Print_Titles","=Instructions!$5:$6"]
["Prover_Stmt","='Tables & Lists'!$A$32"]
["ProverTempCorr","='Prover Data Entry'!$F$51"]
["ProverTempk","='Prover Data Entry'!$J$51"]
["ProverTempU","='Prover Data Entry'!$H$51"]
["RefT","='Prover Data Entry'!$J$18"]
["RefTemp_list","='Tables & Lists'!$D$21:$D$22"]
["RefTempUnit","='Prover Data Entry'!$A$18"]
["RptNo","='Prover Data Entry'!$I$1"]
["ScaleUnit","='Prover Data Entry'!$E$12"]
["ScaleUnit.List","='Tables & Lists'!$D$7:$D$10"]
["SealNo","='Prover Data Entry'!$I$83"]
["Sight_Glass_id","='Prover Data Entry'!$G$15"]
["SN","='Prover Data Entry'!$J$11"]
["Specification","='Prover Data Entry'!$C$17"]
["Specification_list","='Tables & Lists'!$D$27:$D$28"]
["Standards_Table_A","='Prover Data Entry'!$A$36:$K$40"]
["Standards_Table_B","='Prover Data Entry'!$A$42:$K$46"]
["StdTempCorr","='Prover Data Entry'!$F$50"]
["StdTempk","='Prover Data Entry'!$J$50"]
["StdTempU","='Prover Data Entry'!$H$50"]
["t_1","='Prover Data Entry'!$E$81"]
["t_2","='Prover Data Entry'!$J$81"]
["Tech","='Prover Data Entry'!$F$22"]
["TestMeasure_Stmt","='Tables & Lists'!$A$31"]
["Tolerance","=Calculations!$E$57"]
["Top_Neck_id","='Prover Data Entry'!$C$15"]
["Unc","=Calculations!$E$62"]
["V_1","='Prover Data Entry'!$F$37"]
["V_2","='Prover Data Entry'!$F$38"]
["V_3","='Prover Data Entry'!$F$39"]
["V_4","='Prover Data Entry'!$F$40"]
["Veff","='Uncertainty Analysis'!$K$93"]
["WL","=Calculations!$E$52"]
["WODate","='Prover Data Entry'!$J$10"]

{"sheet":"Report Pages 1-3","index":4,"n_rows":92,"n_cols":7,"rows_kept":92,"merged":[[32,0,33,6],[37,5,37,6],[40,0,40,1],[40,2,40,6],[41,0,41,6],[56,3,56,4],[57,0,57,1],[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],[67,0,67,6],[70,0,70,6],[73,0,73,6],[74,0,74,6],[78,0,78,6],[79,0,79,6],[80,0,80,6],[81,0,81,6],[82,0,82,6],[83,0,83,6],[88,0,88,2],[88,3,88,4],[88,5,88,6],[89,0,89,2],[89,3,89,4],[89,5,89,6],[90,0,90,2],[90,3,90,4],[90,5,90,6],[91,0,91,2],[91,3,91,4],[91,5,91,6]]}
{"$rows_empty":10}
[{"$nulls":3},"REPORT OF CALIBRATION"]
[]
[{"$nulls":3},"Issued To:"]
[{"$nulls":3},{"$f":"IF('Prover Data Entry'!A4=\"\",\"\",'Prover Data Entry'!A4)","v":""}]
[{"$nulls":3},{"$f":"IF('Prover Data Entry'!A5=\"\",\"\",'Prover Data Entry'!A5)","v":""}]
[{"$nulls":3},{"$f":"IF('Prover Data Entry'!A6=\"\",\"\",'Prover Data Entry'!A6)","v":""}]
[{"$nulls":3},{"$f":"IF('Prover Data Entry'!A7=\"\",\"\",'Prover 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_No=\"\",\"\",PO_No)","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=\"\",\"\",Nom_Val&IF(NomValUnit=\"Nominal Volume (gal)\",\" gal \",\" L \")&Description)","v":""},null,null,"Date Received:",{"$f":"IF(WODate=\"\",\"\",TEXT(WODate,\"mmmm d, yyyy\"))","v":""}]
["Serial Number:",{"$f":"IF(SN=\"\",\"\",SN)","v":""},null,null,"Manufacture:",{"$f":"IF(MFG=\"\",\"\",MFG)","v":""}]
["Material:",{"$f":"IF(Material=\"\",\"\",Material)","v":""},null,null,"Cubical Coefficient of Expansion:",{"$f":"IF(Material=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",VLOOKUP(Material,CCE_Table,2)*1.8&\" / ºC\",VLOOKUP(Material,CCE_Table,2)&\" / ºF\"))","v":""}]
["Condition:",{"$f":"IF(Condition=\"\",\"\",Condition)","v":""},null,null,"Specification:",{"$f":"IF(Specification=\"\",\"\",Specification)","v":""}]
[]
["Calibration Information"]
["Job Order #:",{"$f":"IF(JobNo=\"\",\"\",JobNo)","v":""},null,null,"Temperature:",{"$f":"IF(AirTemp=\"\",\"\",FIXED(AVERAGE(AirTemp,AirTemp_F),1)&\" ºC\")","v":""}]
["Metrologist:",{"$f":"IF(Tech=\"\",\"\",Tech)","v":""},null,null,"Humidity:",{"$f":"IF(Humidity=\"\",\"\",FIXED(AVERAGE(Humidity,Humidity_F),1)&\" % RH\")","v":""}]
["Procedure:","NIST IR 7383, SOP 19",null,null,"Water Temperature:",{"$f":"IF(t_1=\"\",\"\",FIXED(AVERAGE(t_1,t_2),1)&\" \"&CHAR(186)&\"C\")","v":""}]
[]
["Laboratory Reference Standards Used"]
["Description",null,"Serial Number","Cert. Number",null,"Cal Date","Cal Due"]
[{"$f":"'Prover Data Entry'!B26","v":0},null,{"$f":"'Prover Data Entry'!F26","v":0},{"$f":"'Prover Data Entry'!H26","v":0},null,{"$f":"'Prover Data Entry'!J26","v":"00:00:00"},{"$f":"'Prover Data Entry'!K26","v":"00:00:00"}]
[{"$f":"'Prover Data Entry'!B27","v":0},null,{"$f":"'Prover Data Entry'!F27","v":0},{"$f":"'Prover Data Entry'!H27","v":0},null,{"$f":"'Prover Data Entry'!J27","v":"00:00:00"},{"$f":"'Prover Data Entry'!K27","v":"00:00:00"}]
[{"$f":"'Prover Data Entry'!B28","v":0},null,{"$f":"'Prover Data Entry'!F28","v":0},{"$f":"'Prover Data Entry'!H28","v":0},null,{"$f":"'Prover Data Entry'!J28","v":"00:00:00"},{"$f":"'Prover Data Entry'!K28","v":"00:00:00"}]
[{"$f":"'Prover Data Entry'!B29","v":0},null,{"$f":"'Prover Data Entry'!F29","v":0},{"$f":"'Prover Data Entry'!H29","v":0},null,{"$f":"'Prover Data Entry'!J29","v":"00:00:00"},{"$f":"'Prover Data Entry'!K29","v":"00:00:00"}]
[{"$f":"'Prover Data Entry'!B30","v":0},null,{"$f":"'Prover Data Entry'!F30","v":0},{"$f":"'Prover Data Entry'!H30","v":0},null,{"$f":"'Prover Data Entry'!J30","v":"00:00:00"},{"$f":"'Prover Data Entry'!K30","v":"00:00:00"}]
[{"$f":"'Prover Data Entry'!B31","v":0},null,{"$f":"'Prover Data Entry'!F31","v":0},{"$f":"'Prover Data Entry'!H31","v":0},null,{"$f":"'Prover Data Entry'!J31","v":"00:00:00"},{"$f":"'Prover Data Entry'!K31","v":"00:00:00"}]
[{"$f":"'Prover Data Entry'!B32","v":0},null,{"$f":"'Prover Data Entry'!F32","v":0},{"$f":"'Prover Data Entry'!H32","v":0},null,{"$f":"'Prover Data Entry'!J32","v":"00:00:00"},{"$f":"'Prover Data Entry'!K32","v":"00:00:00"}]
[{"$f":"'Prover Data Entry'!B33","v":0},null,{"$f":"'Prover Data Entry'!F33","v":0},{"$f":"'Prover Data Entry'!H33","v":0},null,{"$f":"'Prover Data Entry'!J33","v":"00:00:00"},{"$f":"'Prover Data Entry'!K33","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 viscosity, for the material cubical coefficient of expansion, for reading the meniscus, for graduated neck errors and for the thermometer(s) used for measuring the water temperature. 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(ISBLANK(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…’"]
["● The artifact is considered in-tolerance when the error is equal to or less than the specified tolerance minus the measurement uncertainty. RED print indicates an out-of-tolerance reading."]
[{"$f":"IF(Nom_Val=\"\",\"● The \"&Description&\" 'As Left' volume is 'In-Tolerance', the prover may be used in meter testing without a correction.\",IF(ABS(Calculations!E42)+Unc>Calculations!E40,\"●  The \"&Description&\" 'As Left' volume is 'Out-of-Tolerance', the user must use a correction for all meter testing.\",\"● The \"&Description&\" 'As Left' volume is 'In-Tolerance', the \"&Description&\" may be used in meter testing without a correction.\"))","v":"● The  'As Left' volume is 'In-Tolerance', the prover may be used in meter testing without a correction."}]
[{"$f":"IF(Description=\"Test Measure\",TestMeasure_Stmt,Prover_Stmt)","v":"● The calibration item was calibrated in a wet down condition using water. 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."}]
["● The results listed in this report relate only to the artifacts described and extent of calibrations performed."]
[]
["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"]
["gallon (U.S.) (gal)",null,null,"to cubic meter (m³)",null,"3.785 412 E-03"]
["cubic inch (in³)",null,null,"to cubic meter (m³)",null,"1.638 706 4 E-05"]
["liter (L)",null,null,"to cubic meter (m³)",null,"1.0 E-03"]

{"sheet":"Report Page 4","index":5,"n_rows":38,"n_cols":8,"rows_kept":38,"merged":[[0,0,0,7],[7,0,7,2],[7,3,37,7]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":6},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
["Table 1 - Calibration Results"]
["Nominal Volume",{"$f":"Description&\" Volume\nAs Found \"&IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºC\n (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºF\n (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºC\n (gal)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºF\n (gal)\"))))","v":" Volume\nAs Found FALSE"},{"$f":"Description&\" Volume\nAs Left \"&IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºC\n (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºF\n (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºC\n (gal)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºF\n (gal)\"))))","v":" Volume\nAs Left FALSE"},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Specification\nTolerance\n\"&CHAR(177)&\" (L)\",\"Specification\nTolerance\n\"&CHAR(177)&\" (gal)\")","v":"Specification\nTolerance\n± (gal)"},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Uncertainty\n\"&CHAR(177)&\" (L)\",\"Uncertainty\n\"&CHAR(177)&\" (gal)\")","v":"Uncertainty\n± (gal)"},"k factor","Degrees of Freedom","Calibration Seal Number"]
[{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",Nom_Val&\" L\",Nom_Val&\" gal\"))","v":""},{"$f":"IF(AsFound=\"\",\"\",AsFound)","v":""},{"$f":"IF(AsLeft=\"\",\"\",AsLeft)","v":""},{"$f":"IF(Tolerance=\"\",\"\",Tolerance)","v":""},{"$f":"IF(Unc=\"\",\"\",Unc)","v":""},{"$f":"IF(kfactor=\"\",\"\",kfactor)","v":""},{"$f":"IF(Eff_df=\"\",\"\",Eff_df)","v":""},{"$f":"IF(SealNo=\"\",\"\",SealNo)","v":""}]
[]
[{"$f":"\"Table 2 - \"&Description&\" Temperature Correction Chart\"","v":"Table 2 -  Temperature Correction Chart"}]
[{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Coefficient of Cubical Expansion = \"&B&\" / ºC\",\"Coefficient of Cubical Expansion = \"&B&\" / ºF\")","v":"Coefficient of Cubical Expansion =  / ºF"},null,null,{"$f":"\"A negative error means the \"&Description&\" is small\n\n\n\nA \"&Description&\" is smaller at temperatures lower than the reference temperature\"","v":"A negative error means the  is small\n\n\n\nA  is smaller at temperatures lower than the reference temperature"}]
[{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Temperature\"&\" ºC\",\"Temperature\"&\" ºF\")","v":"Temperature ºF"},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Correction (mL)\",\"Correction (in³)\")","v":"Correction (in³)"},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Correction (L)\",\"Correction (gal)\")","v":"Correction (gal)"}]
[{"$f":"A11-5","v":-10},{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((Nom_Val*(1+(B*(A10-RefT)))-Nom_Val)*1000,1),FIXED((Nom_Val*(1+(B*(A10-RefT)))-Nom_Val)*231,1)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED(Nom_Val*(1+(B*(A10-RefT)))-Nom_Val,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[-5,"",""]
[0,"",""]
[5,"",""]
[10,"",""]
[15,"",""]
[20,"",""]
[25,"",""]
[30,"",""]
[35,"",""]
[40,"",""]
[45,"",""]
[50,"",""]
[{"$f":"A24-5","v":55},"",""]
[{"$f":"IF(RefT=\"\",60,RefT)","v":60},"",""]
[{"$f":"A24+5","v":65},"",""]
[{"$f":"A25+5","v":70},"",""]
[75,"",""]
[80,"",""]
[85,"",""]
[90,"",""]
[95,"",""]
[100,"",""]
[105,"",""]
[110,"",""]
[115,"",""]
[120,"",""]
[125,"",""]
[130,"",""]

{"sheet":"Prover Data Entry","index":6,"n_rows":86,"n_cols":11,"rows_kept":86,"merged":[[0,8,0,10],[2,0,2,1],[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,3],[11,4,11,5],[11,6,11,8],[11,9,11,10],[12,0,12,4],[12,6,12,10],[13,0,13,1],[13,2,13,5],[13,6,13,8],[13,9,13,10],[14,0,14,1],[14,3,14,5],[14,7,14,9],[15,0,15,1],[15,2,15,6],[15,7,15,8],[15,9,15,10],[16,0,16,1],[16,2,16,4],[16,5,16,8],[16,9,16,10],[17,0,17,8],[17,9,17,10],[18,0,18,4],[18,5,18,6],[18,7,18,9],[19,0,19,4],[19,5,19,6],[20,0,20,4],[20,6,20,9],[21,0,21,1],[21,2,21,3],[21,5,21,7],[21,8,21,9],[24,1,24,4],[24,5,24,6],[24,7,24,8],[25,1,25,4],[25,5,25,6],[25,7,25,8],[26,1,26,4],[26,5,26,6],[26,7,26,8],[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],[35,1,35,3],[35,5,35,6],[35,7,35,8],[36,1,36,3],[36,5,36,6],[36,7,36,8],[37,1,37,3],[37,5,37,6],[37,7,37,8],[38,1,38,3],[38,5,38,6],[38,7,38,8],[39,1,39,3],[39,5,39,6],[39,7,39,8],[41,1,41,3],[41,5,41,6],[42,1,42,3],[42,5,42,6],[43,1,43,3],[43,5,43,6],[44,1,44,3],[44,5,44,6],[45,1,45,3],[45,5,45,6],[48,0,48,3],[48,5,48,6],[48,7,48,8],[48,9,48,10],[49,0,49,3],[49,5,49,6],[49,7,49,8],[49,9,49,10],[50,0,50,3],[50,5,50,6],[50,7,50,8],[50,9,50,10],[53,1,53,2],[53,4,53,5],[56,0,56,4],[56,5,56,9],[75,0,75,4],[75,5,75,9],[76,0,76,3],[76,5,76,8],[77,0,77,3],[77,5,77,8],[78,0,78,3],[78,5,78,8],[79,0,79,3],[79,5,79,8],[80,0,80,3],[80,5,80,8],[81,0,81,4],[81,5,81,9],[82,0,82,3],[82,5,82,7],[82,8,82,9],[85,1,85,2],[85,4,85,5]]}
["Prover Data Entry",{"$nulls":6},"Report Number:"]
[]
["Customer Information"]
[{"$nulls":7},"Customer ID"]
[{"$nulls":7},"PO#"]
[{"$nulls":7},"POC"]
[{"$nulls":7},"Phone"]
[]
["Artifact and Measurement Information"]
["Description",{"$nulls":5},"Date Received"]
["Manufacture",{"$nulls":5},"Serial Number"]
[{"$nulls":6},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"Graduated Neck Volume (gal)\",\"Graduated Neck Volume (L)\")","v":"Graduated Neck Volume (L)"}]
["Did the Neck Scale Plate Verification pass?",{"$nulls":5},{"$f":"IF(F13=\"\",\"\",IF(F13=\"Yes\",\"Continue with the Calibration\",\"Reject or Issue Neck Scale Correction Value (NSCV)\"))","v":""}]
["Prover Material",{"$nulls":5},{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"CCE (β) (/ ºC) =\",\"CCE (β) (/ ºF) =\")","v":"CCE (β) (/ ºF) ="},null,null,{"$f":"IF(Material=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",VLOOKUP(Material,CCE_Table,2,FALSE)*1.8,VLOOKUP(Material,CCE_Table,2,FALSE)))","v":""}]
["Neck Inside Dia. (mm)",null,null,"Sight Glass Inside Dia. (mm)",{"$nulls":3},"Graduation Line Width (mm)"]
["Artifact Condition",{"$nulls":6},"Job Order Number"]
["Artifact Specification",{"$nulls":4},"Specification Tolerance (% of capacity)"]
[]
[{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"Process Standard Deviation of Trials from Control Chart (gal)\",\"Process Standard Deviation of Trials from Control Chart (L)\")","v":"Process Standard Deviation of Trials from Control Chart (L)"},{"$nulls":6},"s(p) Degrees of Freedom"]
[{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"Accredited Best Uncertainty for this Calibration (gal)\",\"Accredited Best Uncertainty for this Calibration (L)\")","v":"Accredited Best Uncertainty for this Calibration (L)"},{"$nulls":6},"k factor",null,"df"]
["Was a Calibration Interval Requested or is one Required?",{"$nulls":5},"What is the Calibration Interval (months)?"]
["Calibration Date",{"$nulls":3},"Technician",{"$nulls":3},"Technician Initials"]
[]
["Standards Used"]
["Standard Item ID","Description",{"$nulls":3},"Serial Number",null,"Report Number",null,"Calibration Date","Calibration Due"]
{"$rows_empty":9}
["Volume Standard(s) Data"]
["ID Code","Description",null,null,"Drops",{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Volume (Vs @ trefs) \n(L)\",\"Volume (Vs @ trefs) \n(gal)\")","v":"Volume (Vs @ trefs) \n(gal)"},null,{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Unc\n(L)\",\"Unc\n(gal)\")","v":"Unc\n(gal)"},null,"k-factor","df"]
[{"$nulls":5},0,null,0,null,1,1]
[{"$nulls":5},0,null,0,null,1,1]
[{"$nulls":5},0,null,0,null,1,1]
[{"$nulls":5},0,null,0,null,1,1]
[]
["ID Code","Description",null,null,{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Std. Ref. Temp. (trefS ºC)\",\"Std. Ref. Temp. (trefS ºF)\")","v":"Std. Ref. Temp. (trefS ºF)"},{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"CCE (α)\n(/ ºC)\",\"CCE (α)\n(/ ºF)\")","v":"CCE (α)\n(/ ºF)"},null,{"$f":"\"Graduated Neck Volume \"&IF(NomValUnit=\"Nominal Volume (L)\",\"(L)\",\"(gal)\")","v":"Graduated Neck Volume (gal)"},{"$f":"\"Inside Neck Diameter (mm)\"","v":"Inside Neck Diameter (mm)"},{"$f":"\"Sight Glass Inside Dia. (mm)\"","v":"Sight Glass Inside Dia. (mm)"},{"$f":"\"Graduation Line Width (mm)\"","v":"Graduation Line Width (mm)"}]
[{"$f":"IF(A37=\"\",\"\",A37)","v":""},"",null,null,0,0,null,0,0,0,0]
["","",null,null,0,0,null,0,0,0,0]
["","",null,null,0,0,null,0,0,0,0]
["","",null,null,0,0,null,0,0,0,0]
[]
["Temperature Standard(s) Data"]
["Description",{"$nulls":3},"ID Code","Correction\n(ºC)",null,"Uncertainty\n(ºC)",null,"k factor"]
["Temp. Standard Used For Volume Standard(s):"]
["Temperature Standard Used For Unit-Under-Test:"]
[]
["Laboratory Test Conditions"]
["Start","Temperature (ºC)",null,null,"Humidity (% RH)"]
[]
["Standard(s) Observations"]
["Trial 1",{"$nulls":4},"Trial 2"]
["Drop Number","ID\nCode",{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Volume \n(Vs @ trefS) \n(L)\",\"Volume \n(Vs @ trefS) \n(gal)\")","v":"Volume \n(Vs @ trefS) \n(gal)"},"Water Temp.\n(ºC)",{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Delta (Δ)\n(mL)\",\"Delta (Δ)\n(in³)\")","v":"Delta (Δ)\n(in³)"},"Drop Number","ID\nCode",{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Volume \n(Vs @ trefS) \n(L)\",\"Volume \n(Vs @ trefS) \n(gal)\")","v":"Volume \n(Vs @ trefS) \n(gal)"},"Water Temp.\n(ºC)",{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Delta (Δ)\n(mL)\",\"Delta (Δ)\n(in³)\")","v":"Delta (Δ)\n(in³)"}]
[1,null,{"$f":"IF(B59=\"\",\"\",VLOOKUP(B59,Standards_Table_A,6,FALSE))","v":""},null,null,1,null,{"$f":"IF(G59=\"\",\"\",VLOOKUP(G59,Standards_Table_A,6,FALSE))","v":""}]
[2,null,"",null,null,2,null,""]
[3,null,"",null,null,3,null,""]
[4,null,"",null,null,4,null,""]
[5,null,"",null,null,5,null,""]
[6,null,"",null,null,6,null,""]
[7,null,"",null,null,7,null,""]
[8,null,"",null,null,8,null,""]
[9,null,"",null,null,9,null,""]
[10,null,"",null,null,10,null,""]
[11,null,"",null,null,11,null,""]
[12,null,"",null,null,12,null,""]
[13,null,"",null,null,13,null,""]
[14,null,"",null,null,14,null,""]
[15,null,"",null,null,15,null,""]
[]
["Artifact Observations"]
["Trial 1",{"$nulls":4},"Trial 2"]
[{"$f":"IF(ScaleUnit=\"Scale Graduations (L)\",\"Neck Scale Reading As Found (L)\",IF(ScaleUnit=\"Scale Graduations (mL)\",\"Neck Scale Reading As Found (mL)\",IF(ScaleUnit=\"Scale Graduations (gal)\",\"Neck Scale Reading As Found (gal)\",\"Neck Scale Reading As Found (in³)\")))","v":"Neck Scale Reading As Found (in³)"},{"$nulls":4},{"$f":"IF(ScaleUnit=\"Scale Graduations (L)\",\"Neck Scale Reading (L)\",IF(ScaleUnit=\"Scale Graduations (mL)\",\"Neck Scale Reading (mL)\",IF(ScaleUnit=\"Scale Graduations (gal)\",\"Neck Scale Reading (gal)\",\"Neck Scale Reading (in³)\")))","v":"Neck Scale Reading (in³)"}]
["Water Temperature, Bottom (ºC)",{"$nulls":4},"Water Temperature, Bottom (ºC)"]
["Water Temperature, Middle (ºC)",{"$nulls":4},"Water Temperature, Middle (ºC)"]
["Water Temperature, Top (ºC)",{"$nulls":4},"Water Temperature, Top (ºC)"]
["Water Temperature, Average (ºC)",{"$nulls":3},{"$f":"IF(ISERROR(AVERAGE(E78:E80)),\"\",AVERAGE(E78:E80))","v":""},"Water Temperature, Average (ºC)",{"$nulls":3},{"$f":"IF(ISERROR(AVERAGE(J78:J80)),\"\",AVERAGE(J78:J80))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",IF(ScaleUnit=\"Scale Graduations (L)\",\"  To Adjust \"&Description&\" To Deliver Exactly \"&FIXED(Nom_Val,0,TRUE)&\" liters @ \"&RefT&\" ºF, Adjust Scale To Read \"&FIXED(Calculations!E27-Nom_Val,3,TRUE)&\" liters.\",IF(ScaleUnit=\"Scale Graduations (mL)\",\"  To Adjust \"&Description&\" To Deliver Exactly \"&FIXED(Nom_Val,0,TRUE)&\" liters @ \"&RefT&\" ºF, Adjust Scale To Read \"&FIXED((Calculations!E27-Nom_Val)*1000,3,TRUE)&\" milliliters.\",IF(ScaleUnit=\"Scale Graduations (gal)\",\"  To Adjust \"&Description&\" To Deliver Exactly \"&FIXED(Nom_Val,0,TRUE)&\" gallons @ \"&RefT&\" ºF, Adjust Scale To Read \"&FIXED(Calculations!E27-Nom_Val,3,TRUE)&\" gallons\",\"  To Adjust \"&Description&\" To Deliver Exactly \"&FIXED(Nom_Val,0,TRUE)&\" gallons @ \"&RefT&\" ºF, Adjust Scale To Read \"&FIXED((Calculations!E27-Nom_Val)*231,3,TRUE)&\" cubic inchs.\"))))","v":""},{"$nulls":4},{"$f":"IF(t_2=\"\",\"\",\"If the Range of the Trials is in Control, Seal \"&Description&\"\nNeck Scale Plate and Print Report of Calibration. If Not Conduct Another Trial (Trial 2 Becomes Trial 1)\")","v":""}]
[{"$f":"IF(ScaleUnit=\"Scale Graduations (L)\",\"Trial 1 Final Neck Scale Reading (L)\",IF(ScaleUnit=\"Scale Graduations (mL)\",\"Trial 1 Final Neck Scale Reading (mL)\",IF(ScaleUnit=\"Scale Graduations (gal)\",\"Trial 1 Final Neck Scale Reading (gal)\",\"Trial 1 Final Neck Scale Reading (in³)\")))","v":"Trial 1 Final Neck Scale Reading (in³)"},{"$nulls":4},"Scale Security Seal #"]
[]
["Laboratory Test Conditions"]
["Finish","Temperature (ºC)",null,null,"Humidity (% RH)"]

{"sheet":"Control Data","index":7,"n_rows":4,"n_cols":11,"rows_kept":4}
["Control Chart Information",{"$nulls":9},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Note: Copy and Paste to Control Chart"]
["Tech. Initials","Date","Test Number",{"$f":"\"Volume (Trial 1) \"&IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºC (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºF (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºC (gal)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºF (gal)\"))))","v":"Volume (Trial 1) FALSE"},{"$f":"\"Volume (Trial 2) \"&IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºC (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"@ \"&RefT&\" ºF (L)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºC (gal)\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"@ \"&RefT&\" ºF (gal)\"))))","v":"Volume (Trial 2) FALSE"},"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('Prover Data Entry'!K22=\"\",\"\",'Prover Data Entry'!K22)","v":""},{"$f":"IF(Cal_Date=\"\",\"\",Cal_Date)","v":""},{"$f":"IF(RptNo=\"\",\"\",RptNo)","v":""},{"$f":"Calculations!E30","v":""},{"$f":"Calculations!E31","v":""},{"$f":"IF(Humidity=\"\",\"\",Humidity)","v":""},{"$f":"IF(Humidity_F=\"\",\"\",Humidity_F)","v":""},{"$f":"IF(AirTemp=\"\",\"\",AirTemp)","v":""},{"$f":"IF(AirTemp_F=\"\",\"\",AirTemp_F)","v":""},{"$f":"IF(ISERROR(t_1+ProverTempCorr),\"\",t_1+ProverTempCorr)","v":""},{"$f":"IF(ISERROR(t_2+ProverTempCorr),\"\",t_2+ProverTempCorr)","v":""}]

{"sheet":"Calculations","index":8,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[3,0,3,4],[3,5,3,9],[20,0,20,3],[20,5,20,8],[21,0,21,4],[21,5,21,9],[22,0,22,2],[22,3,22,4],[22,5,22,7],[22,8,22,9],[23,0,23,2],[23,3,23,4],[23,5,23,7],[23,8,23,9],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[33,0,33,9],[34,4,34,5],[34,7,35,9],[35,4,35,5],[38,0,38,9],[39,4,39,5],[40,4,40,5],[40,7,40,9],[41,4,41,5],[41,7,41,9],[44,0,44,9],[45,4,45,5],[45,7,46,9],[46,4,46,5],[49,0,49,9],[50,4,50,5],[50,7,52,9],[51,4,51,5],[52,4,52,5],[55,4,55,5],[56,4,56,5],[57,4,57,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[61,4,61,5]]}
["Calculations",{"$nulls":8},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Measurement Trial Calculations"]
["Volume Standard(s) Trial 1",{"$nulls":4},"Volume Standard(s) Trial 2"]
["Drop #",{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Std. Ref. Temp. (trefS ºC)\",\"Std. Ref. Temp. (trefS ºF)\")","v":"Std. Ref. Temp. (trefS ºF)"},{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Water Temp.\n(ºC)\",\"Water Temp.\n(ºF)\")","v":"Water Temp.\n(ºF)"},"Water Density (g/cm³)",{"$f":"IF(NomValUnit=\"\",\"Delivered\nVolume\",IF(NomValUnit=\"Nominal Volume (L)\",\"Delivered\nVolume\n(L)\",\"Delivered\nVolume\n(gal)\"))","v":"Delivered\nVolume"},"Drop #",{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Std. Ref. Temp. (trefS ºC)\",\"Std. Ref. Temp. (trefS ºF)\")","v":"Std. Ref. Temp. (trefS ºF)"},{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Water Temp.\n(ºC)\",\"Water Temp.\n(ºF)\")","v":"Water Temp.\n(ºF)"},"Water Density (g/cm³)",{"$f":"IF(NomValUnit=\"\",\"Delivered\nVolume\",IF(NomValUnit=\"Nominal Volume (L)\",\"Delivered\nVolume\n(L)\",\"Delivered\nVolume\n(gal)\"))","v":"Delivered\nVolume"}]
[1,{"$f":"IF('Prover Data Entry'!B59=\"\",\"\",VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B59=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D59+StdTempCorr,('Prover Data Entry'!D59+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B59=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D59+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D59+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D59+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D59+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B59=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D6*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/1000))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*(C6-B6))),D6*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/231))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*(C6-B6)))))","v":""},1,{"$f":"IF('Prover Data Entry'!G59=\"\",\"\",VLOOKUP('Prover Data Entry'!G59,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G59=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I59+StdTempCorr,('Prover Data Entry'!I59+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G59=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I59+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I59+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I59+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I59+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G59=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I6*(('Prover Data Entry'!H59+('Prover Data Entry'!J59/1000))*(1+(VLOOKUP('Prover Data Entry'!G59,Standards_Table_B,6,FALSE))*(H6-G6))),I6*(('Prover Data Entry'!H59+('Prover Data Entry'!J59/231))*(1+(VLOOKUP('Prover Data Entry'!G59,Standards_Table_B,6,FALSE))*(H6-G6)))))","v":""}]
[2,{"$f":"IF('Prover Data Entry'!B60=\"\",\"\",VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B60=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D60+StdTempCorr,('Prover Data Entry'!D60+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B60=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D60+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D60+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D60+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D60+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B60=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D7*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/1000))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*(C7-B7))),D7*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/231))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*(C7-B7)))))","v":""},2,{"$f":"IF('Prover Data Entry'!G60=\"\",\"\",VLOOKUP('Prover Data Entry'!G60,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G60=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I60+StdTempCorr,('Prover Data Entry'!I60+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G60=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I60+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I60+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I60+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I60+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G60=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I7*(('Prover Data Entry'!H60+('Prover Data Entry'!J60/1000))*(1+(VLOOKUP('Prover Data Entry'!G60,Standards_Table_B,6,FALSE))*(H7-G7))),I7*(('Prover Data Entry'!H60+('Prover Data Entry'!J60/231))*(1+(VLOOKUP('Prover Data Entry'!G60,Standards_Table_B,6,FALSE))*(H7-G7)))))","v":""}]
[3,{"$f":"IF('Prover Data Entry'!B61=\"\",\"\",VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B61=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D61+StdTempCorr,('Prover Data Entry'!D61+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B61=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D61+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D61+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D61+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D61+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B61=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D8*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/1000))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*(C8-B8))),D8*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/231))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*(C8-B8)))))","v":""},3,{"$f":"IF('Prover Data Entry'!G61=\"\",\"\",VLOOKUP('Prover Data Entry'!G61,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G61=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I61+StdTempCorr,('Prover Data Entry'!I61+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G61=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I61+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I61+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I61+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I61+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G61=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I8*(('Prover Data Entry'!H61+('Prover Data Entry'!J61/1000))*(1+(VLOOKUP('Prover Data Entry'!G61,Standards_Table_B,6,FALSE))*(H8-G8))),I8*(('Prover Data Entry'!H61+('Prover Data Entry'!J61/231))*(1+(VLOOKUP('Prover Data Entry'!G61,Standards_Table_B,6,FALSE))*(H8-G8)))))","v":""}]
[4,{"$f":"IF('Prover Data Entry'!B62=\"\",\"\",VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B62=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D62+StdTempCorr,('Prover Data Entry'!D62+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B62=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D62+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D62+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D62+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D62+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B62=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D9*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/1000))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*(C9-B9))),D9*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/231))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*(C9-B9)))))","v":""},4,{"$f":"IF('Prover Data Entry'!G62=\"\",\"\",VLOOKUP('Prover Data Entry'!G62,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G62=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I62+StdTempCorr,('Prover Data Entry'!I62+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G62=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I62+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I62+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I62+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I62+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G62=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I9*(('Prover Data Entry'!H62+('Prover Data Entry'!J62/1000))*(1+(VLOOKUP('Prover Data Entry'!G62,Standards_Table_B,6,FALSE))*(H9-G9))),I9*(('Prover Data Entry'!H62+('Prover Data Entry'!J62/231))*(1+(VLOOKUP('Prover Data Entry'!G62,Standards_Table_B,6,FALSE))*(H9-G9)))))","v":""}]
[5,{"$f":"IF('Prover Data Entry'!B63=\"\",\"\",VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B63=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D63+StdTempCorr,('Prover Data Entry'!D63+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B63=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D63+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D63+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D63+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D63+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B63=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D10*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/1000))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*(C10-B10))),D10*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/231))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*(C10-B10)))))","v":""},5,{"$f":"IF('Prover Data Entry'!G63=\"\",\"\",VLOOKUP('Prover Data Entry'!G63,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G63=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I63+StdTempCorr,('Prover Data Entry'!I63+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G63=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I63+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I63+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I63+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I63+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G63=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I10*(('Prover Data Entry'!H63+('Prover Data Entry'!J63/1000))*(1+(VLOOKUP('Prover Data Entry'!G63,Standards_Table_B,6,FALSE))*(H10-G10))),I10*(('Prover Data Entry'!H63+('Prover Data Entry'!J63/231))*(1+(VLOOKUP('Prover Data Entry'!G63,Standards_Table_B,6,FALSE))*(H10-G10)))))","v":""}]
[6,{"$f":"IF('Prover Data Entry'!B64=\"\",\"\",VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B64=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D64+StdTempCorr,('Prover Data Entry'!D64+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B64=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D64+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D64+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D64+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D64+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B64=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D11*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/1000))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*(C11-B11))),D11*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/231))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*(C11-B11)))))","v":""},6,{"$f":"IF('Prover Data Entry'!G64=\"\",\"\",VLOOKUP('Prover Data Entry'!G64,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G64=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I64+StdTempCorr,('Prover Data Entry'!I64+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G64=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I64+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I64+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I64+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I64+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G64=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I11*(('Prover Data Entry'!H64+('Prover Data Entry'!J64/1000))*(1+(VLOOKUP('Prover Data Entry'!G64,Standards_Table_B,6,FALSE))*(H11-G11))),I11*(('Prover Data Entry'!H64+('Prover Data Entry'!J64/231))*(1+(VLOOKUP('Prover Data Entry'!G64,Standards_Table_B,6,FALSE))*(H11-G11)))))","v":""}]
[7,{"$f":"IF('Prover Data Entry'!B65=\"\",\"\",VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B65=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D65+StdTempCorr,('Prover Data Entry'!D65+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B65=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D65+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D65+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D65+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D65+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B65=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D12*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/1000))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*(C12-B12))),D12*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/231))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*(C12-B12)))))","v":""},7,{"$f":"IF('Prover Data Entry'!G65=\"\",\"\",VLOOKUP('Prover Data Entry'!G65,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G65=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I65+StdTempCorr,('Prover Data Entry'!I65+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G65=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I65+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I65+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I65+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I65+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G65=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I12*(('Prover Data Entry'!H65+('Prover Data Entry'!J65/1000))*(1+(VLOOKUP('Prover Data Entry'!G65,Standards_Table_B,6,FALSE))*(H12-G12))),I12*(('Prover Data Entry'!H65+('Prover Data Entry'!J65/231))*(1+(VLOOKUP('Prover Data Entry'!G65,Standards_Table_B,6,FALSE))*(H12-G12)))))","v":""}]
[8,{"$f":"IF('Prover Data Entry'!B66=\"\",\"\",VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B66=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D66+StdTempCorr,('Prover Data Entry'!D66+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B66=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D66+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D66+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D66+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D66+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B66=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D13*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/1000))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*(C13-B13))),D13*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/231))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*(C13-B13)))))","v":""},8,{"$f":"IF('Prover Data Entry'!G66=\"\",\"\",VLOOKUP('Prover Data Entry'!G66,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G66=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I66+StdTempCorr,('Prover Data Entry'!I66+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G66=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I66+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I66+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I66+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I66+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G66=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I13*(('Prover Data Entry'!H66+('Prover Data Entry'!J66/1000))*(1+(VLOOKUP('Prover Data Entry'!G66,Standards_Table_B,6,FALSE))*(H13-G13))),I13*(('Prover Data Entry'!H66+('Prover Data Entry'!J66/231))*(1+(VLOOKUP('Prover Data Entry'!G66,Standards_Table_B,6,FALSE))*(H13-G13)))))","v":""}]
[9,{"$f":"IF('Prover Data Entry'!B67=\"\",\"\",VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B67=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D67+StdTempCorr,('Prover Data Entry'!D67+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B67=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D67+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D67+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D67+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D67+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B67=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D14*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/1000))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*(C14-B14))),D14*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/231))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*(C14-B14)))))","v":""},9,{"$f":"IF('Prover Data Entry'!G67=\"\",\"\",VLOOKUP('Prover Data Entry'!G67,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G67=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I67+StdTempCorr,('Prover Data Entry'!I67+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G67=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I67+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I67+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I67+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I67+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G67=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I14*(('Prover Data Entry'!H67+('Prover Data Entry'!J67/1000))*(1+(VLOOKUP('Prover Data Entry'!G67,Standards_Table_B,6,FALSE))*(H14-G14))),I14*(('Prover Data Entry'!H67+('Prover Data Entry'!J67/231))*(1+(VLOOKUP('Prover Data Entry'!G67,Standards_Table_B,6,FALSE))*(H14-G14)))))","v":""}]
[10,{"$f":"IF('Prover Data Entry'!B68=\"\",\"\",VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B68=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D68+StdTempCorr,('Prover Data Entry'!D68+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B68=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D68+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D68+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D68+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D68+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B68=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D15*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/1000))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*(C15-B15))),D15*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/231))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*(C15-B15)))))","v":""},10,{"$f":"IF('Prover Data Entry'!G68=\"\",\"\",VLOOKUP('Prover Data Entry'!G68,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G68=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I68+StdTempCorr,('Prover Data Entry'!I68+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G68=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I68+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I68+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I68+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I68+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G68=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I15*(('Prover Data Entry'!H68+('Prover Data Entry'!J68/1000))*(1+(VLOOKUP('Prover Data Entry'!G68,Standards_Table_B,6,FALSE))*(H15-G15))),I15*(('Prover Data Entry'!H68+('Prover Data Entry'!J68/231))*(1+(VLOOKUP('Prover Data Entry'!G68,Standards_Table_B,6,FALSE))*(H15-G15)))))","v":""}]
[11,{"$f":"IF('Prover Data Entry'!B69=\"\",\"\",VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B69=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D69+StdTempCorr,('Prover Data Entry'!D69+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B69=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D69+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D69+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D69+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D69+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B69=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D16*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/1000))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*(C16-B16))),D16*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/231))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*(C16-B16)))))","v":""},11,{"$f":"IF('Prover Data Entry'!G69=\"\",\"\",VLOOKUP('Prover Data Entry'!G69,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G69=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I69+StdTempCorr,('Prover Data Entry'!I69+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G69=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I69+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I69+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I69+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I69+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G69=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I16*(('Prover Data Entry'!H69+('Prover Data Entry'!J69/1000))*(1+(VLOOKUP('Prover Data Entry'!G69,Standards_Table_B,6,FALSE))*(H16-G16))),I16*(('Prover Data Entry'!H69+('Prover Data Entry'!J69/231))*(1+(VLOOKUP('Prover Data Entry'!G69,Standards_Table_B,6,FALSE))*(H16-G16)))))","v":""}]
[12,{"$f":"IF('Prover Data Entry'!B70=\"\",\"\",VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B70=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D70+StdTempCorr,('Prover Data Entry'!D70+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B70=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D70+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D70+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D70+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D70+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B70=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D17*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/1000))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*(C17-B17))),D17*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/231))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*(C17-B17)))))","v":""},12,{"$f":"IF('Prover Data Entry'!G70=\"\",\"\",VLOOKUP('Prover Data Entry'!G70,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G70=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I70+StdTempCorr,('Prover Data Entry'!I70+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G70=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I70+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I70+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I70+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I70+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G70=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I17*(('Prover Data Entry'!H70+('Prover Data Entry'!J70/1000))*(1+(VLOOKUP('Prover Data Entry'!G70,Standards_Table_B,6,FALSE))*(H17-G17))),I17*(('Prover Data Entry'!H70+('Prover Data Entry'!J70/231))*(1+(VLOOKUP('Prover Data Entry'!G70,Standards_Table_B,6,FALSE))*(H17-G17)))))","v":""}]
[13,{"$f":"IF('Prover Data Entry'!B71=\"\",\"\",VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B71=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D71+StdTempCorr,('Prover Data Entry'!D71+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B71=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D71+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D71+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D71+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D71+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B71=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D18*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/1000))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*(C18-B18))),D18*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/231))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*(C18-B18)))))","v":""},13,{"$f":"IF('Prover Data Entry'!G71=\"\",\"\",VLOOKUP('Prover Data Entry'!G71,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G71=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I71+StdTempCorr,('Prover Data Entry'!I71+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G71=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I71+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I71+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I71+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I71+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G71=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I18*(('Prover Data Entry'!H71+('Prover Data Entry'!J71/1000))*(1+(VLOOKUP('Prover Data Entry'!G71,Standards_Table_B,6,FALSE))*(H18-G18))),I18*(('Prover Data Entry'!H71+('Prover Data Entry'!J71/231))*(1+(VLOOKUP('Prover Data Entry'!G71,Standards_Table_B,6,FALSE))*(H18-G18)))))","v":""}]
[14,{"$f":"IF('Prover Data Entry'!B72=\"\",\"\",VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B72=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D72+StdTempCorr,('Prover Data Entry'!D72+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B72=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D72+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D72+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D72+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D72+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B72=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D19*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/1000))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*(C19-B19))),D19*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/231))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*(C19-B19)))))","v":""},14,{"$f":"IF('Prover Data Entry'!G72=\"\",\"\",VLOOKUP('Prover Data Entry'!G72,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G72=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I72+StdTempCorr,('Prover Data Entry'!I72+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G72=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I72+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I72+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I72+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I72+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G72=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I19*(('Prover Data Entry'!H72+('Prover Data Entry'!J72/1000))*(1+(VLOOKUP('Prover Data Entry'!G72,Standards_Table_B,6,FALSE))*(H19-G19))),I19*(('Prover Data Entry'!H72+('Prover Data Entry'!J72/231))*(1+(VLOOKUP('Prover Data Entry'!G72,Standards_Table_B,6,FALSE))*(H19-G19)))))","v":""}]
[15,{"$f":"IF('Prover Data Entry'!B73=\"\",\"\",VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B73=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!D73+StdTempCorr,('Prover Data Entry'!D73+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!B73=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D73+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D73+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D73+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D73+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B73=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D20*(('Prover Data Entry'!C73+('Prover Data Entry'!E73/1000))*(1+(VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE))*(C20-B20))),D20*(('Prover Data Entry'!C73+('Prover Data Entry'!E73/231))*(1+(VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE))*(C20-B20)))))","v":""},15,{"$f":"IF('Prover Data Entry'!G73=\"\",\"\",VLOOKUP('Prover Data Entry'!G73,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G73=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",'Prover Data Entry'!I73+StdTempCorr,('Prover Data Entry'!I73+StdTempCorr)*1.8+32))","v":""},{"$f":"IF('Prover Data Entry'!G73=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I73+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I73+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I73+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I73+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G73=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I20*(('Prover Data Entry'!H73+('Prover Data Entry'!J73/1000))*(1+(VLOOKUP('Prover Data Entry'!G73,Standards_Table_B,6,FALSE))*(H20-G20))),I20*(('Prover Data Entry'!H73+('Prover Data Entry'!J73/231))*(1+(VLOOKUP('Prover Data Entry'!G73,Standards_Table_B,6,FALSE))*(H20-G20)))))","v":""}]
[{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Trial 1 Delivered Volume (L) =\",\"Trial 1 Delivered Volume (gal) =\")","v":"Trial 1 Delivered Volume (gal) ="},{"$nulls":3},{"$f":"IF(t_1=\"\",\"\",SUM(E6:E20))","v":""},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Trial 2 Delivered Volume (L) =\",\"Trial 2 Delivered Volume (gal) =\")","v":"Trial 2 Delivered Volume (gal) ="},{"$nulls":3},{"$f":"IF(t_2=\"\",\"\",SUM(J6:J20))","v":""}]
[{"$f":"Description&\" Trial 1\"","v":" Trial 1"},{"$nulls":4},{"$f":"Description&\" Trial 2\"","v":" Trial 2"}]
["Water Density (g/cm³) =",null,null,{"$f":"IF(t_1=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!E81+ProverTempCorr)-3.983035)^2*(('Prover Data Entry'!E81+ProverTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!E81+ProverTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!E81+ProverTempCorr))/1000000,8))","v":""},null,"Water Density (g/cm³) =",null,null,{"$f":"IF(t_2=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!J81+ProverTempCorr)-3.983035)^2*(('Prover Data Entry'!J81+ProverTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!J81+ProverTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!J81+ProverTempCorr))/1000000,8))","v":""}]
[{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Water Temperature (ºC) =\",\"Water Temperature (ºF) =\")","v":"Water Temperature (ºF) ="},null,null,{"$f":"IF(t_1=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",t_1+ProverTempCorr,(t_1+ProverTempCorr)*1.8+32))","v":""},null,{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"Water Temperature (ºC) =\",\"Water Temperature (ºF) =\")","v":"Water Temperature (ºF) ="},null,null,{"$f":"IF(t_2=\"\",\"\",IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",t_2+ProverTempCorr,(t_2+ProverTempCorr)*1.8+32))","v":""}]
[]
[{"$f":"Description&\" Volume Determinations At The Designated Reference Temperature\"","v":" Volume Determinations At The Designated Reference Temperature"}]
[{"$nulls":3},"Trial 1 VXtrefX =",{"$f":"IF(E21=\"\",\"\",E21/(D23*(1+B*(D24-RefT))))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºF\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºF\")))))","v":""}]
[{"$nulls":3},"Trial 2 VXtrefX =",{"$f":"IF(J21=\"\",\"\",J21/(I23*(1+B*(I24-RefT))))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºF\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºF\")))))","v":""}]
[{"$nulls":3},{"$f":"Description&\" Volume As Found =\"","v":" Volume As Found ="},{"$f":"IF(E27=\"\",\"\",IF(OR(ScaleUnit=\"Scale Graduations (gal)\",ScaleUnit=\"Scale Graduations (L)\"),E27-'Prover Data Entry'!E77,IF(ScaleUnit=\"Scale Graduations (mL)\",E27-'Prover Data Entry'!E77/1000,E27-'Prover Data Entry'!E77/231)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºF\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºF\")))))","v":""}]
[{"$nulls":3},{"$f":"Description&\" Volume As Adjusted =\"","v":" Volume As Adjusted ="},{"$f":"IF(E27=\"\",\"\",IF(OR(ScaleUnit=\"Scale Graduations (gal)\",ScaleUnit=\"Scale Graduations (L)\"),E27-'Prover Data Entry'!E83,IF(ScaleUnit=\"Scale Graduations (mL)\",E27-'Prover Data Entry'!E83/1000,E27-'Prover Data Entry'!E83/231)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºF\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºF\")))))","v":""}]
[{"$nulls":3},{"$f":"\"Trial 2 \"&Description&\" Volume =\"","v":"Trial 2  Volume ="},{"$f":"IF(E28=\"\",\"\",IF(OR(ScaleUnit=\"Scale Graduations (gal)\",ScaleUnit=\"Scale Graduations (L)\"),E28-'Prover Data Entry'!J77,IF(ScaleUnit=\"Scale Graduations (mL)\",E28-'Prover Data Entry'!J77/1000,E28-'Prover Data Entry'!J77/231)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºF\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºF\")))))","v":""}]
[]
["Uncertainty Evaluation"]
[{"$f":"Specification&\" Criteria: The expanded uncertainty must be less than \"&IF(Specification=\"NIST HB 105-3\",'Prover Data Entry'!J17&\"% of the measured volume.\",\"one third the tolerance.\")","v":" Criteria: The expanded uncertainty must be less than one third the tolerance."}]
[{"$nulls":3},{"$f":"IF(Specification=\"NIST HB 105-3\",'Prover Data Entry'!J17&\" % of Measured Volume =\",\"Tolerance =\")","v":"Tolerance ="},{"$f":"IF(E29=\"\",\"\",'Prover Data Entry'!J17%*E29)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""},{"$f":"IF(OR(E35=\"\",E35=\"N/A\"),\"\",IF(E36<E35,\"Uncertainty Meets Criteria.\",\"Uncertainty Fails Criteria, Re-evaluate or Use Different Calibration Method.\"))","v":""}]
[{"$nulls":3},"Expanded Uncertainty =",{"$f":"IF(Final_U=\"\",\"\",Final_U)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[]
["Tolerance Evaluation"]
[{"$f":"\"Criteria: The maximum permissible error shall be ± \"&'Prover Data Entry'!J17&\" % of the nominal capacity minus the uncertainty.\"","v":"Criteria: The maximum permissible error shall be ±  % of the nominal capacity minus the uncertainty."}]
[{"$nulls":3},"Tolerance =",{"$f":"IF('Prover Data Entry'!J17=\"\",\"\",Nom_Val*'Prover Data Entry'!J17%)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[{"$nulls":3},{"$f":"Description&\" Volume Error As Found =\"","v":" Volume Error As Found ="},{"$f":"IF(E29=\"\",\"\",E29-Nom_Val)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""},{"$f":"IF(E41=\"\",\"\",IF(ABS(E41)+Unc<=E40,\"Artifact Found Within Tolerence.\",\"Artifact Found Out-Of-Tolerance.\"))","v":""}]
[{"$nulls":3},{"$f":"Description&\" Volume Error As Left =\"","v":" Volume Error As Left ="},{"$f":"IF(E31=\"\",\"\",IF('Prover Data Entry'!E77='Prover Data Entry'!E83,AVERAGE(E29,E31)-Nom_Val,AVERAGE(E30,E31)-Nom_Val))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""},{"$f":"IF(E42=\"\",\"\",IF(ABS(E42)+Unc<=E40,\"Artifact Left Within Tolerence.\",\"Artifact Left Out-Of-Tolerance.\"))","v":""}]
[]
["Repeatability Evaluation"]
["Criteria: Volumetric values obtained during repeated runs of a single calibration must agree within 0.02 % of the test volume."]
[{"$nulls":3},"0.02 % of Measured Volume = ",{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val*0.0002)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""},{"$f":"IF(E47=\"\",\"\",IF(E47<E46,\"The Range Test Meets Criteria.\",\"Range Test Fails, Investigate and Correct Any Problems, Then Redo Measurements\"))","v":""}]
[{"$nulls":3},"Measurement Range =",{"$f":"IF(ISERROR(ABS(E30-E31)),\"\",ABS(E30-E31))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[]
["Measurement Assurance Evaluation"]
["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)"]
[{"$nulls":3},"Control Limit =",{"$f":"IF(PooledSD=\"\",\"\",PooledSD*3)","v":""},null,null,{"$f":"IF(E53=\"\",\"\",IF(E53>CL,\"The Standard Deviation Is Outside The Control Limits, Investigate The Problem, Then Redo The Measurements\",IF(E53<=WL,\"The Standard Deviation Is In Control, Plot The Value On The Control Chart\",IF(AND(E53>WL,E53<=CL),\"The Standard Deviation Is outside the Warning Limit but inside the Control Limit, Investigate The Problem, Then Redo The Measurements As Necessary\"))))","v":""}]
[{"$nulls":3},"Warning Limit =",{"$f":"IF(PooledSD=\"\",\"\",PooledSD*2)","v":""}]
[{"$nulls":3},"Standard Deviation of the Trials = ",{"$f":"IF(ISERROR(STDEV(E30,E31)),\"\",STDEV(E30,E31))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[]
["Results Formatted For Calibration Report"]
[{"$nulls":3},{"$f":"Description&\" Nominal Value =\"","v":" Nominal Value ="},{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[{"$nulls":3},{"$f":"Specification&\" Tolerance =\"","v":" Tolerance ="},{"$f":"IF(Nom_Val=\"\",\"\",FIXED(Nom_Val*'Prover Data Entry'!J17%,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[{"$nulls":3},{"$f":"Description&\" Volume As Found =\"","v":" Volume As Found ="},{"$f":"IF(E29=\"\",\"\",IF('Prover Data Entry'!E77='Prover Data Entry'!E83,FIXED(AVERAGE(E29,E31),2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED(E29,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºF\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºF\")))))","v":""}]
[{"$nulls":3},{"$f":"Description&\" Volume As Left =\"","v":" Volume As Left ="},{"$f":"IF(E31=\"\",\"\",IF('Prover Data Entry'!E77='Prover Data Entry'!E83,FIXED(AVERAGE(E29,E31),2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED(AVERAGE(E30,E31),2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (L)\"),\"L @ \"&RefT&\" ºF\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºC\",IF(AND(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",NomValUnit=\"Nominal Volume (gal)\"),\"gal @ \"&RefT&\" ºF\")))))","v":""}]
[{"$nulls":3},"Effective Degrees of Freedom =",{"$f":"IF(E56=\"\",\"\",Final_Veff)","v":""}]
[{"$nulls":3},"k factor =",{"$f":"IF(E56=\"\",\"\",Final_k)","v":""}]
[{"$nulls":3},"Uncertainty (uc*k) =",{"$f":"IF(E56=\"\",\"\",FIXED(Final_U,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]

{"sheet":"Uncertainty Analysis","index":9,"n_rows":102,"n_cols":12,"rows_kept":102,"merged":[[0,2,0,5],[11,2,11,11],[12,2,12,11],[13,2,13,11],[14,2,14,11],[15,2,15,11],[16,2,16,11],[17,2,17,11],[18,2,18,11],[19,2,19,11],[22,1,22,5],[22,6,22,11],[23,1,23,5],[23,6,23,11],[24,1,24,5],[24,6,24,11],[25,1,25,5],[25,6,25,11],[26,1,26,5],[26,6,26,11],[27,1,27,5],[27,6,27,11],[28,1,28,5],[28,6,28,11],[31,0,31,2],[31,3,31,4],[31,8,31,9],[32,0,32,2],[33,0,33,2],[35,0,35,2],[35,3,35,5],[35,6,35,7],[36,0,36,2],[36,3,36,4],[36,8,36,9],[38,0,38,2],[42,0,42,2],[42,3,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[43,0,43,2],[58,10,58,11],[59,0,59,2],[59,3,59,5],[61,0,61,2],[77,0,77,2],[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 19, Calibration of Large Neck-Type Metal Provers - Volumetric Method"]
[]
["Specify Equation(s)"]
["Volume at the Reference Temperature"]
[]
[{"$f":"Description&\" Volume = VXtrefX - gauge reading\"","v":" Volume = VXtrefX - gauge reading"}]
[]
[null,"where"]
[null,"VXtrefX =","Volume of the unknown vessel, VX at its designated reference temperature, trefX"]
[null,"VStrefS =","Volume of the standard vessel, VS at its designated reference temperature, trefS"]
[null,"ρ1, ρ2, …, ρN =","Density of the water in the standard where ρ1 is the density of the water for the first delivery, ρ2 is the density of the water for the second delivery, and so on until all N deliveries are completed using the M. Tanaka, G. Girard, R. Davis, A. Peuto, and N. Bignell equation, Metrologia, 38, 301-309 (2001) as referenced in NISTIR 7383, GLP 10."]
[null,"Δ1, Δ2,…,ΔN =","Volume differences between the water level and the reference mark on the standard where the subscripts 1, 2,…,N, represent each delivery as above. If the water level is below the reference line, Δ is negative. If the water level is above the reference line, Δ is positive. If the water level is at the reference line, Δ is zero\nNOTE: units must match volume units for the standard"]
[null,"t1, t2, …, tN =","Temperature of water for each delivery with the subscripts as above"]
[null,"α =","Coefficient of cubical expansion for the standard in its designated units"]
[null,"β =","Coefficient of cubical expansion for the unknown vessel in its designated units"]
[null,"tx =","Temperature of water in the filled unknown vessel in designated units"]
[null,"ρx =","Density of water in the prover in g/cm3"]
[]
["Identify Components"]
["Component","Description",{"$nulls":4},"Reference"]
["s(p)","Uncertainty associated with the measurement process from the standard deviation of replicate measurements, normal distribution",{"$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."]
["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(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(n)","Uncertainty associated with the graduated neck calibration of the standard and unknown vessel, triangular distribution",{"$nulls":4},"NISTIR 7383, SOP 19, paragraph 2.4.2.7 and SOP 21, paragraph 2.4.3.7, 0.5 % of graduated neck volume (if passes neck scale verification), Type B evaluation"]
["u(CCE)","Uncertainty of the Cubic Coefficient of Expansion for the vessel material of the standard and the unknown, rectangular distribution",{"$nulls":4},"EURAMET cg-19, paragraph 5.3.6 5 % to 10 % of CCE"]
["u(tw)","Uncertainty of the thermometer used for measuring water temperature, rectangular distribution",{"$nulls":4},"NIST HB 143, Table 11, accurate to ± 0.5 ºC, Type B evaluation"]
[]
["Uncertainty Intermediate Calculations"]
["Standard Meniscus",null,null,"Neck (mL)",null,"u(mS1) =",{"$f":"IF('Prover Data Entry'!A37=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A37,Standards_Table_B,9,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A37,Standards_Table_B,11,FALSE)/1000*drops1)","v":0},null,"Sight Glass (mL)",null,"u(mS1) =",{"$f":"IF('Prover Data Entry'!A37=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A37,Standards_Table_B,10,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A37,Standards_Table_B,11,FALSE)/1000*drops1)","v":0}]
[{"$nulls":5},"u(mS2) =",{"$f":"IF('Prover Data Entry'!A38=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A38,Standards_Table_B,9,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A38,Standards_Table_B,11,FALSE)/1000*drops2)","v":0},{"$nulls":3},"u(mS2) =",{"$f":"IF('Prover Data Entry'!A38=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A38,Standards_Table_B,10,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A38,Standards_Table_B,11,FALSE)/1000*drops2)","v":0}]
[{"$nulls":5},"u(mS3) =",{"$f":"IF('Prover Data Entry'!A39=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A39,Standards_Table_B,9,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A39,Standards_Table_B,11,FALSE)/1000*drops3)","v":0},{"$nulls":3},"u(mS3) =",{"$f":"IF('Prover Data Entry'!A39=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A39,Standards_Table_B,10,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A39,Standards_Table_B,11,FALSE)/1000*drops3)","v":0}]
[{"$nulls":5},"u(mS4) =",{"$f":"IF('Prover Data Entry'!A40=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A40,Standards_Table_B,9,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A40,Standards_Table_B,11,FALSE)/1000*drops4)","v":0},{"$nulls":3},"u(mS4) =",{"$f":"IF('Prover Data Entry'!A40=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A40,Standards_Table_B,10,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A40,Standards_Table_B,11,FALSE)/1000*drops4)","v":0}]
[]
["Unknown Meniscus",null,null,"Neck (mL)",null,"u(mU1) =",{"$f":"IF(Top_Neck_id=\"\",0,PI()*(Top_Neck_id/2)^2*Line_w/1000)","v":0},null,"Sight Glass (mL)",null,"u(mU1) =",{"$f":"IF(Sight_Glass_id=\"\",0,PI()*(Sight_Glass_id/2)^2*Line_w/1000)","v":0}]
[]
["Standard Graduated Neck",null,null,"u(nS1) =",{"$f":"IF('Prover Data Entry'!A37=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A37,Standards_Table_B,8,FALSE)*0.5%*drops1))","v":0}]
[{"$nulls":3},"u(nS2) =",{"$f":"IF('Prover Data Entry'!A38=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A38,Standards_Table_B,8,FALSE)*0.5%*drops2))","v":0}]
[{"$nulls":3},"u(nS3) =",{"$f":"IF('Prover Data Entry'!A39=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A39,Standards_Table_B,8,FALSE)*0.5%*drops3))","v":0}]
[{"$nulls":3},"u(nS4) =",{"$f":"IF('Prover Data Entry'!A40=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A40,Standards_Table_B,8,FALSE)*0.5%*drops4))","v":0}]
[]
["Standard Coefficient of Expansion",null,null,"Drop # 1",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B59=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D6*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/1000))*(1+((VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE)*5%))*(Calculations!C6-Calculations!B6))),Calculations!D6*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/231))*(1+((VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE)*5%))*(Calculations!C6-Calculations!B6)))))","v":0},null,null,"Delivered Volume [base value] =",{"$f":"Calculations!E21","v":""}]
[{"$nulls":3},"Drop # 2",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B60=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D7*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/1000))*(1+((VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE)*5%))*(Calculations!C7-Calculations!B7))),Calculations!D7*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/231))*(1+((VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE)*5%))*(Calculations!C7-Calculations!B7)))))","v":0}]
[{"$nulls":3},"Drop # 3",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B61=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D8*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/1000))*(1+((VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE)*5%))*(Calculations!C8-Calculations!B8))),Calculations!D8*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/231))*(1+((VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE)*5%))*(Calculations!C8-Calculations!B8)))))","v":0}]
[{"$nulls":3},"Drop # 4",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B62=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D9*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/1000))*(1+((VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE)*5%))*(Calculations!C9-Calculations!B9))),Calculations!D9*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/231))*(1+((VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE)*5%))*(Calculations!C9-Calculations!B9)))))","v":0}]
[{"$nulls":3},"Drop # 5",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B63=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D10*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/1000))*(1+((VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE)*5%))*(Calculations!C10-Calculations!B10))),Calculations!D10*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/231))*(1+((VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE)*5%))*(Calculations!C10-Calculations!B10)))))","v":0}]
[{"$nulls":3},"Drop # 6",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B64=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D11*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/1000))*(1+((VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE)*5%))*(Calculations!C11-Calculations!B11))),Calculations!D11*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/231))*(1+((VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE)*5%))*(Calculations!C11-Calculations!B11)))))","v":0}]
[{"$nulls":3},"Drop # 7",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B65=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D12*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/1000))*(1+((VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE)*5%))*(Calculations!C12-Calculations!B12))),Calculations!D12*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/231))*(1+((VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE)*5%))*(Calculations!C12-Calculations!B12)))))","v":0}]
[{"$nulls":3},"Drop # 8",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B66=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D13*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/1000))*(1+((VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE)*5%))*(Calculations!C13-Calculations!B13))),Calculations!D13*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/231))*(1+((VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE)*5%))*(Calculations!C13-Calculations!B13)))))","v":0}]
[{"$nulls":3},"Drop # 9",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B67=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D14*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/1000))*(1+((VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE)*5%))*(Calculations!C14-Calculations!B14))),Calculations!D14*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/231))*(1+((VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE)*5%))*(Calculations!C14-Calculations!B14)))))","v":0}]
[{"$nulls":3},"Drop # 10",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B68=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D15*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/1000))*(1+((VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE)*5%))*(Calculations!C15-Calculations!B15))),Calculations!D15*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/231))*(1+((VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE)*5%))*(Calculations!C15-Calculations!B15)))))","v":0}]
[{"$nulls":3},"Drop # 11",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B69=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D16*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/1000))*(1+((VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE)*5%))*(Calculations!C16-Calculations!B16))),Calculations!D16*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/231))*(1+((VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE)*5%))*(Calculations!C16-Calculations!B16)))))","v":0}]
[{"$nulls":3},"Drop # 12",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B70=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D17*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/1000))*(1+((VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE)*5%))*(Calculations!C17-Calculations!B17))),Calculations!D17*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/231))*(1+((VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE)*5%))*(Calculations!C17-Calculations!B17)))))","v":0}]
[{"$nulls":3},"Drop # 13",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B71=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D18*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/1000))*(1+((VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE)*5%))*(Calculations!C18-Calculations!B18))),Calculations!D18*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/231))*(1+((VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE)*5%))*(Calculations!C18-Calculations!B18)))))","v":0}]
[{"$nulls":3},"Drop # 14",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B72=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D19*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/1000))*(1+((VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE)*5%))*(Calculations!C19-Calculations!B19))),Calculations!D19*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/231))*(1+((VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE)*5%))*(Calculations!C19-Calculations!B19)))))","v":0}]
[{"$nulls":3},"Drop # 15",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B73=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D20*(('Prover Data Entry'!C73+('Prover Data Entry'!E73/1000))*(1+((VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE)*5%))*(Calculations!C20-Calculations!B20))),Calculations!D20*(('Prover Data Entry'!C73+('Prover Data Entry'!E73/231))*(1+((VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE)*5%))*(Calculations!C20-Calculations!B20)))))","v":0}]
[]
["Unknown Coefficient of Expansion",null,null,"Volume Trial 1 [β + u(CCEβ)] =",null,null,{"$f":"IF(B=\"\",0,Calculations!E21/(Calculations!D23*(1+(B+D89)*(Calculations!D24-RefT))))","v":0},null,null,"Volume Trial 1 [base value] =",{"$f":"Calculations!E27","v":""}]
[]
["Standard Water Temperature",null,null,"Drop # 1",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B59=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D6*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/1000))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*((Calculations!C6+$D$90)-Calculations!B6))),Calculations!D6*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/231))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*((Calculations!C6+$D$90)-Calculations!B6)))))","v":0}]
[{"$nulls":3},"Drop # 2",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B60=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D7*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/1000))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*((Calculations!C7+$D$90)-Calculations!B7))),Calculations!D7*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/231))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*((Calculations!C7+$D$90)-Calculations!B7)))))","v":0}]
[{"$nulls":3},"Drop # 3",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B61=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D8*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/1000))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*((Calculations!C8+$D$90)-Calculations!B8))),Calculations!D8*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/231))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*((Calculations!C8+$D$90)-Calculations!B8)))))","v":0}]
[{"$nulls":3},"Drop # 4",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B62=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D9*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/1000))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*((Calculations!C9+$D$90)-Calculations!B9))),Calculations!D9*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/231))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*((Calculations!C9+$D$90)-Calculations!B9)))))","v":0}]
[{"$nulls":3},"Drop # 5",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B63=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D10*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/1000))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*((Calculations!C10+$D$90)-Calculations!B10))),Calculations!D10*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/231))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*((Calculations!C10+$D$90)-Calculations!B10)))))","v":0}]
[{"$nulls":3},"Drop # 6",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B64=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D11*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/1000))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*((Calculations!C11+$D$90)-Calculations!B11))),Calculations!D11*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/231))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*((Calculations!C11+$D$90)-Calculations!B11)))))","v":0}]
[{"$nulls":3},"Drop # 7",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B65=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D12*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/1000))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*((Calculations!C12+$D$90)-Calculations!B12))),Calculations!D12*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/231))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*((Calculations!C12+$D$90)-Calculations!B12)))))","v":0}]
[{"$nulls":3},"Drop # 8",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B66=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D13*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/1000))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*((Calculations!C13+$D$90)-Calculations!B13))),Calculations!D13*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/231))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*((Calculations!C13+$D$90)-Calculations!B13)))))","v":0}]
[{"$nulls":3},"Drop # 9",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B67=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D14*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/1000))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*((Calculations!C14+$D$90)-Calculations!B14))),Calculations!D14*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/231))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*((Calculations!C14+$D$90)-Calculations!B14)))))","v":0}]
[{"$nulls":3},"Drop # 10",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B68=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D15*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/1000))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*((Calculations!C15+$D$90)-Calculations!B15))),Calculations!D15*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/231))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*((Calculations!C15+$D$90)-Calculations!B15)))))","v":0}]
[{"$nulls":3},"Drop # 11",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B69=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D16*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/1000))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*((Calculations!C16+$D$90)-Calculations!B16))),Calculations!D16*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/231))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*((Calculations!C16+$D$90)-Calculations!B16)))))","v":0}]
[{"$nulls":3},"Drop # 12",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B70=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D17*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/1000))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*((Calculations!C17+$D$90)-Calculations!B17))),Calculations!D17*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/231))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*((Calculations!C17+$D$90)-Calculations!B17)))))","v":0}]
[{"$nulls":3},"Drop # 13",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B71=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D18*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/1000))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*((Calculations!C18+$D$90)-Calculations!B18))),Calculations!D18*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/231))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*((Calculations!C18+$D$90)-Calculations!B18)))))","v":0}]
[{"$nulls":3},"Drop # 14",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B72=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D19*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/1000))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*((Calculations!C19+$D$90)-Calculations!B19))),Calculations!D19*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/231))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*((Calculations!C19+$D$90)-Calculations!B19)))))","v":0}]
[{"$nulls":3},"Drop # 15",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B73=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D20*(('Prover Data Entry'!C73+('Prover Data Entry'!E73/1000))*(1+(VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE))*((Calculations!C20+$D$90)-Calculations!B20))),Calculations!D20*(('Prover Data Entry'!C73+('Prover Data Entry'!E73/231))*(1+(VLOOKUP('Prover Data Entry'!B73,Standards_Table_B,6,FALSE))*((Calculations!C20+$D$90)-Calculations!B20)))))","v":0}]
[]
["Unknown Water Temperature",{"$nulls":4},"Volume  Trial 1[t + u(txX)] =",{"$f":"IF(RefT=\"\",0,Calculations!E21/(Calculations!D23*(1+B*((Calculations!D24+D91)-RefT))))","v":0}]
[]
["Quantity, Convert, Combined, Expand & Report"]
["Component Description",null,"Component Symbol","Estimated Uncertainty","Units",{"$f":"\"Reported Unc \n\"&IF(NomValUnit=\"Nominal Volume (gal)\",\"(gal)\",\"(L)\")","v":"Reported Unc \n(L)"},"Type","Distribution","Factor to Normalize",{"$f":"\"Standard Unc \n\"&IF(NomValUnit=\"Nominal Volume (gal)\",\"(gal)\",\"(L)\")","v":"Standard Unc \n(L)"},"% Contribution","Degrees of Freedom"]
["Process Standard Deviation",null,{"$f":"A24","v":"s(p)"},{"$f":"IF(PooledSD=\"\",0,PooledSD)","v":0},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"},{"$f":"D82","v":0},"A","Normal",1,{"$f":"F82/I82","v":0},{"$f":"IF($K$92=\"\",\"\",J82^2/$K$92^2)","v":""},{"$f":"IF(J82=0,1,df)","v":1}]
["Volume Standards",null,{"$f":"A25","v":"u(s)"},{"$f":"IF(_unc1=0,0,_unc1/k_1*drops1+_unc2/k_2*drops2+_unc3/k_3*drops3+_unc4/k_4*drops4)","v":0},"L",0,"B","Normal",1,0,"",{"$f":"IF(J83=0,1,ROUNDDOWN(SQRT(((_unc1*drops1/k_1)*('Prover Data Entry'!K37*drops1)^2+(_unc2*drops2/k_2)*('Prover Data Entry'!K38*drops2)^2+(_unc3*drops3/k_3)*('Prover Data Entry'!K39*drops3)^2+(_unc4*drops4/k_4)*('Prover Data Entry'!K40*drops4)^2)/SUM((_unc1*drops1/k_1)+(_unc2*drops2/k_2)+(_unc3*drops3/k_3)+(_unc4*drops4/k_4))),0))","v":1}]
["Standard Meniscus",null,"u(mS)",{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",SUM(G32:G35,L32:L35)/3785.412,SUM(G32:G35,L32:L35)/1000)","v":0},"L",0,"B","Triangular",{"$f":"SQRT(6)","v":2.449489742783178},0,"",{"$f":"IF(J84=0,1,10000)","v":1}]
["Unknown Meniscus",null,"u(mU)",{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",SUM(G37,L37)/3785.412,SUM(G37,L37)/1000)","v":0},"L",0,"B","Triangular",{"$f":"SQRT(6)","v":2.449489742783178},0,"",1]
["Std Graduated Neck",null,"u(nS)",{"$f":"SUM(E39:E42)","v":0},"L",0,"B","Triangular",{"$f":"SQRT(6)","v":2.449489742783178},0,"",1]
["Ukn Graduated Neck",null,"u(nU)",{"$f":"IF(GradNeckVol=\"\",0,GradNeckVol*0.5%)","v":0},"L",0,"B","Triangular",{"$f":"SQRT(6)","v":2.449489742783178},0,"",1]
["Std Coefficient of Expansion",null,"u(CCEα)",{"$f":"IF(ISERROR(ABS(SUM(G44:G58)-K44)),0,ABS(SUM(G44:G58)-K44))","v":0},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"},{"$f":"IF(D88=0,0,D88)","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Ukn Coefficient of Expansion",null,"u(CCEβ)",{"$f":"IF(B=\"\",0,B*5%)","v":0},{"$f":"IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºC)\",\"/ ºC\",\"/ ºF\")","v":"/ ºF"},{"$f":"IF(D89=0,0,ABS(G60-K60))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Std Water Temperature",null,"u(twS)",{"$f":"IF('Prover Data Entry'!E50=\"\",0,IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",(StdTempU/StdTempk)*1.8,StdTempU/StdTempk))","v":0},"ºC",{"$f":"IF(D90=0,0,ABS(SUM(G62:G76)-K44))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Ukn Water Temperature",null,"u(twU)",{"$f":"IF('Prover Data Entry'!E51=\"\",0,IF(RefTempUnit=\"Designated Reference Temperature For This Calibration (ºF)\",(ProverTempU/ProverTempk)*1.8,ProverTempU/ProverTempk))","v":0},"ºC",{"$f":"IF(D91=0,0,ABS(G78-Calculations!E27))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
[{"$nulls":9},"Combined U (uc) =",{"$f":"IF(SUM(J82:J91)=0,\"\",SQRT(SUMSQ(J82:J91)))","v":""},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"}]
[{"$nulls":9},"Effective Degrees of Freedom, Welch-Satterthwaite formula, NIST Technical Note 1297, (B-1) (veff) =",{"$f":"IF(MAX(L82:L91)=1,\"\",ROUNDDOWN(K92^4/((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":""},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"}]
[{"$nulls":9},"NVLAP Effective Degrees of Freedom (veff) =",{"$f":"IF(G91=\"\",\"\",IF(BestU=\"\",0,BestUdf))","v":0}]
[{"$nulls":9},"NVLAP k factor =",{"$f":"IF(G91=\"\",\"\",IF(BestU=\"\",0,BestUk))","v":0}]
[{"$nulls":9},"NVLAP U =",{"$f":"IF(G91=\"\",\"\",IF(BestU=\"\",0,BestU))","v":0},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"}]
[{"$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":""},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"}]
[{"$f":"\"Values in \"&L101","v":"Values in L"}]

{"sheet":"Tables & Lists","index":10,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[2,0,2,1],[29,0,29,6],[30,0,30,6],[31,0,31,6]]}
["Tables & Lists",{"$nulls":5},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Cubical Coefficient of Expansion Table\n(CCE_Table) &\nMaterial List\n(Material_List)",null,null," Pick Lists\nfor\nData Validation Cells"]
["Material","cm³/ºF",null,"Graduated Neck Volume (gal)"]
["Aluminum",3.8e-05,null,"Graduated Neck Volume (L)"]
["Plastic, Polypropylene",0.00024]
["Steel, Prover, Low Carbon",1.86e-05,null,"Scale Graduations (L)"]
["Steel, Stainless",2.65E-5,null,"Scale Graduations (mL)"]
["Steel, Terneplate",1.95E-5,null,"Scale Graduations (gal)"]
[{"$nulls":3},"Scale Graduations (in³)"]
[]
[{"$nulls":3},"Pooled Standard Deviation of the Trials from Control Chart (gal)"]
[{"$nulls":3},"Pooled Standard Deviation of the Trials from Control Chart (L)"]
[]
[{"$nulls":3},"Yes"]
[{"$nulls":3},"No"]
[]
[{"$nulls":3},"Nominal Volume (gal)"]
[{"$nulls":3},"Nominal Volume (L)"]
[]
[{"$nulls":3},"Designated Reference Temperature For This Calibration (ºF)"]
[{"$nulls":3},"Designated Reference Temperature For This Calibration (ºC)"]
[]
[{"$nulls":3},"Prover"]
[{"$nulls":3},"Test Measure"]
[]
[{"$nulls":3},"NIST HB 105-3"]
[{"$nulls":3},"User/Manufacture"]
[]
["Calibration Report Statements"]
[{"$f":"\"● The calibration item was calibrated in a wet down condition using water. The \"&Description&\" delivers the stated volume at the reference temperature from the specified graduation line when it is emptied gradually with in a 30 (± 5 seconds) pour and a 10-second drain while held at a 10º to 15º angle from vertical.\"","v":"● The calibration item was calibrated in a wet down condition using water. The  delivers the stated volume at the reference temperature from the specified graduation line when it is emptied gradually with in a 30 (± 5 seconds) pour and a 10-second drain while held at a 10º to 15º angle from vertical."}]
[{"$f":"\"● The calibration item was calibrated in a wet down condition using water. 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 calibration item was calibrated in a wet down condition using water. 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."}]