{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["Software Technical Assessment","Documentation","SOP 21","Instructions","Report Pages 1-3","Report Pages 4-5","Report Page 6","Report Page 7","Report Page 8","Prover Data Entry","Control Data","Calculations","Pressure Corrections","Water Compressability","Uncertainty Analysis","Tables & Lists"],"not_rendered":{"charts":2,"images":10,"external_links":5,"defined_names":155,"comments":3},"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-014 (Rev. 35), SOP 21 Workbook","Approval Date","2015-12-28"]
["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 21 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","Pass","FORMAT_CX and ROUND_UNC"]
[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":93,"n_cols":3,"rows_kept":93}
["Documentation"]
["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 21. 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. Revised pressure measurements.","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-03-16","Major revision. Updated to Kragten uncertainty spreadsheet, added tolerances, added metric vessel capability, etc.","DAW"]
["2007-03-30","Reformatted standards tables, corrected errors in 'LPG Data Entry' worksheet.","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-014 (Rev. 20), SOP 21 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 criteria for tolerance and uncertainty evaluations on the \"Calculations' sheet to NIST HB 105-4(2010) specifications.","DAW"]
["2010-03-26","Removed NSCV value. The neck scale either meets the new specification tolerances or it is rejected.","DAW"]
["2011-03-26","Removed '/NSCV' from cell H82 formula on the Data Entry worksheet.","DAW"]
["2011-03-26","Added drain time and drain method data to 'Report Pages 1-3', 'Data Entry', and 'Tables and Lists' worksheets.","DAW"]
["2010-03-26","Added Software Technical Assessment and SOP 21 worksheets, renamed Information worksheet to Instructions.","DAW"]
["2011-03-26","Validated ranges.","DAW"]
["2010-03-26","Validated workbook, file name \"WA2010-03-26 WAMRF-014 (Rev. 21), SOP 21 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-13","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-13","Added SI statement and conversion to the Traceability paragraph on the Report Pages 1-3 spreadsheet."]
["2012-02-13","Validated ranges.","DAW"]
["2012-02-13","Validated workbook, file name \"WA2012-02-13 WAMRF-014 (Rev. 22), SOP 21 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-04-06","Changed \"Certification Statement\" to \"Accreditation Statement\" on Report Pages 1-3 worksheet to be in compliance with NVLAP requirement Annex A, l). ","DAW"]
["2012-05-28","Embedded 2012 SOP","DAW"]
["2012-06-03","Updated water density formula on Calculations worksheet","DAW"]
["2012-06-03","Updated reference to the new water density formula on the Uncertainty Analysis worksheet","DAW"]
["2012-06-03","Added degrees of freedom and best uncertainty k factor to the Data Entry worksheet","DAW"]
["2012-06-03","Updated k factor based on degrees of freedom IAW SOP 29 (2012 edition)","DAW"]
["2012-06-03","Added k factor column to report page 4 and updated uncertainty statement on report page 1-3","DAW"]
["2012-06-03","Validated ranges.","DAW"]
["2012-06-03","Validated workbook, file name \"WA2012-06-03 WAMRF-013 (Rev. 23), SOP 21 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-08-13","Inserted new WSDA Logo on \"Report Pages 1-3\" worksheet.","DAW"]
["2013-02-18","Removed GLP Rounding macros","DAW"]
["2013-02-18","Entered new rounding technique and corrected formulas","DAW"]
["2013-02-18","Validated range names.","DAW"]
["2013-02-18","Validated workbook, file name \"WA2013-02-18 WAMRF-013 (Rev. 24), SOP 21 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-5, cells B5 & C5, Calculations, row 42, cells H45 & H44.","DAW"]
["2013-04-02","Validated range names.","DAW"]
["2013-04-02","Validated workbook, file name \"WA2013-04-02 WAMRF-014 (Rev. 25), SOP 21 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 93 of the Report Pages 1-3 spreadsheet.","DAW"]
["2013-09-01","Changed all ISBLANK() statements.","DAW"]
["2013-09-01","Redefined uncertainty components, added the Welch-Satterthwaite formula for effective degrees of freedom.","DAW"]
["2013-09-01","Revised the Control Data worksheet","DAW"]
["2013-09-01","Validated links and range names and spell checked.","DAW"]
["2013-09-01","Validated workbook, file name \"WA2013-09-01 WAMRF-014 (Rev. 26), SOP 21 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 LPG Data Entry cells F18, H18 & J18 to the YYYY_BEST_UNC workbook.","DAW"]
["2014-06-30","Updated data input and uncertainties in accordance with NISTIR 7383, SOP 21 (2013 edition).","DAW"]
["2014-06-30","Validated range names and spell checked.","DAW"]
["2014-06-30","Validated workbook, file name \"WA2014-06-30 WAMRF-014 (Rev. 27), SOP 21 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-08-25","Changed the reference in cell B31 on the Pressure Corrections worksheet from J96 to E102 of the Prover Data Entry worksheet.","DAW"]
["2014-08-25","Validated range names and spell checked.","DAW"]
["2014-08-25","Validated workbook, file name \"WA2014-08-25 WAMRF-014 (Rev. 28), SOP 21 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-22","Changed statistical df from 100 to 10000.","DAW"]
["2014-10-22","Validated range names and spell checked.","DAW"]
["2014-10-22","Validated workbook, file name \"WA2014-10-22 WAMRF-014 (Rev. 29), SOP 21 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-01-18","Embedded NISTIR 7383, SOP 21 (2015 edition).","DAW"]
["2015-01-18","Changed the formulas on 'Prover Data Entry' sheet cells G88 & I91 to match equations 2 and 3 of NISTIR 7383, SOP 21 (2015 edition).","DAW"]
["2015-01-18","Validated range names and spell checked.","DAW"]
["2015-01-18","Validated workbook, file name \"WA2015-01-18 WAMRF-014 (Rev. 30), SOP 21 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-03-06","Added tables 2, 3 & 4 as defined in the LPG Course 305 Inspector Manual.","DAW"]
["2015-03-06","Added Nominal Volume to Table 1 title.","DAW"]
["2015-03-06","Set RefT default as 60 ºF.","DAW"]
["2015-03-06","Validated range names and spell checked.","DAW"]
["2015-03-06","Validated workbook, file name \"WA2015-03-06 WAMRF-014 (Rev. 31), SOP 21 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","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-014 (Rev. 32), SOP 21 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","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-014 (Rev. 33), SOP 21 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-014 (Rev. 34), SOP 21 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-12-28","Corrected formula for calculating bottom scale adjustment on the Prover Data Entry spreadsheet cell I90.","DAW"]
["2015-12-28","Validated range names.","DAW"]
["2015-12-28","Validated workbook, file name \"WA2015-12-28 WAMRF-014 (Rev. 35), SOP 21 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 21","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Instructions","index":3,"n_rows":107,"n_cols":2,"rows_kept":107,"merged":[[0,0,0,1],[9,0,9,1]]}
["Instructions"]
["No.","Description"]
[1,"This workbook is for calibration of LPG provers at a reference temperature of 60 ºF which is the US industry standard for LP Gases."]
[null,"Tables 2 and 4 are based on a Specific Gravity 60/60 ºF 0.505, which is the approximate specific gravity for commerical grade LP Propane."]
[null,"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"]
["Date","Description"]
["_unc1","='Prover Data Entry'!$H$36"]
["_unc2","='Prover Data Entry'!$H$37"]
["_unc3","='Prover Data Entry'!$H$38"]
["_unc4","='Prover Data Entry'!$H$39"]
["a_1","='Prover Data Entry'!$F$42"]
["a_2","='Prover Data Entry'!$F$43"]
["a_3","='Prover Data Entry'!$F$44"]
["a_4","='Prover Data Entry'!$F$45"]
["Address_1","='Prover Data Entry'!$C$5"]
["Adjusted","='Prover Data Entry'!$J$96"]
["AirTemp","='Prover Data Entry'!$D$53"]
["AirTemp_F","='Prover Data Entry'!$D$107"]
["answer_list","='Tables & Lists'!$D$14:$D$15"]
["AsFound","=Calculations!$E$65"]
["AsLeft","=Calculations!$E$66"]
["B","='Prover Data Entry'!$I$14"]
["BestU","='Prover Data Entry'!$F$19"]
["BestUdf","='Prover Data Entry'!$K$19"]
["BestUk","='Prover Data Entry'!$I$19"]
["Bottom_Neck_id","='Prover Data Entry'!$G$15"]
["BottomZero","='Prover Data Entry'!$J$84"]
["Cal_Date","='Prover Data Entry'!$C$21"]
["CCE_Table","='Tables & Lists'!$A$5:$B$7"]
["CL","=Calculations!$E$54"]
["Condition","='Prover Data Entry'!$C$16"]
["CustomerID","='Prover Data Entry'!$K$4"]
["Description","='Prover Data Entry'!$C$10"]
["df","='Prover Data Entry'!$K$18"]
["drops1","='Prover Data Entry'!$E$36"]
["drops2","='Prover Data Entry'!$E$37"]
["drops3","='Prover Data Entry'!$E$38"]
["drops4","='Prover Data Entry'!$E$39"]
["Eff_df","=Calculations!$E$67"]
["Final_k","='Uncertainty Analysis'!$K$102"]
["Final_U","='Uncertainty Analysis'!$K$103"]
["Final_Veff","='Uncertainty Analysis'!$K$101"]
["GradNeckVol","='Prover Data Entry'!$J$12"]
["Humidity","='Prover Data Entry'!$G$53"]
["Humidity_F","='Prover Data Entry'!$G$107"]
["increment","='Prover Data Entry'!$J$13"]
["interval","='Prover Data Entry'!$K$20"]
["intervalQ","='Prover Data Entry'!$F$20"]
["JobNo","='Prover Data Entry'!$J$16"]
["k","='Uncertainty Analysis'!$K$96"]
["k_1","='Prover Data Entry'!$J$36"]
["k_2","='Prover Data Entry'!$J$37"]
["k_3","='Prover Data Entry'!$J$38"]
["k_4","='Prover Data Entry'!$J$39"]
["kfactor","=Calculations!$E$68"]
["Line_w","='Prover Data Entry'!$K$15"]
["Material","='Prover Data Entry'!$C$14"]
["Material_list","='Tables & Lists'!$A$5:$A$7"]
["MeasuredU","='Uncertainty Analysis'!$K$97"]
["MFG","='Prover Data Entry'!$C$11"]
["mmHg","='Prover Data Entry'!$J$17"]
["Nom_Val","='Prover Data Entry'!$C$12"]
["NomVal_list","='Tables & Lists'!$D$17:$D$18"]
["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$18"]
["Print_Titles","=Instructions!$7:$8"]
["ProverTempCorr","='Prover Data Entry'!$F$50"]
["ProverTempk","='Prover Data Entry'!$J$50"]
["ProverTempU","='Prover Data Entry'!$H$50"]
["RangeMean_list","='Tables & Lists'!$D$9:$D$12"]
["Rmean","='Prover Data Entry'!$F$18"]
["RptNo","='Prover Data Entry'!$I$1"]
["Scale_list","='Tables & Lists'!$D$4:$D$7"]
["Scale_Unit","='Prover Data Entry'!$E$12"]
["SealNoBottom","='Prover Data Entry'!$I$104"]
["SealNoTop","='Prover Data Entry'!$D$104"]
["SN","='Prover Data Entry'!$J$11"]
["Standards_Table_A","='Prover Data Entry'!$A$35:$K$39"]
["Standards_Table_B","='Prover Data Entry'!$A$41:$K$45"]
["StdTempCorr","='Prover Data Entry'!$F$49"]
["StdTempk","='Prover Data Entry'!$J$49"]
["StdTempU","='Prover Data Entry'!$H$49"]
["t_1","='Prover Data Entry'!$E$80"]
["t_2","='Prover Data Entry'!$J$80"]
["Tech","='Prover Data Entry'!$F$21"]
["Tolerance","=Calculations!$E$64"]
["Top_Neck_id","='Prover Data Entry'!$C$15"]
["U60_1","=Calculations!$E$21"]
["U60_2","=Calculations!$J$21"]
["Unc","=Calculations!$E$69"]
["V_1","='Prover Data Entry'!$F$36"]
["V_2","='Prover Data Entry'!$F$37"]
["V_3","='Prover Data Entry'!$F$38"]
["V_4","='Prover Data Entry'!$F$39"]
["Veff","='Uncertainty Analysis'!$K$95"]
["WL","=Calculations!$E$55"]
["WODate","='Prover Data Entry'!$J$10"]
["Z60_1","=Calculations!$E$27"]
["Z60_2","=Calculations!$E$28"]

{"sheet":"Report Pages 1-3","index":4,"n_rows":95,"n_cols":7,"rows_kept":95,"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],[84,0,84,6],[85,0,85,6],[86,0,86,6],[91,0,91,2],[91,3,91,4],[91,5,91,6],[92,0,92,2],[92,3,92,4],[92,5,92,6],[93,0,93,2],[93,3,93,4],[93,5,93,6],[94,0,94,2],[94,3,94,4],[94,5,94,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":" L LPG Prover"},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,"Material CCE:",{"$f":"IF(Material=\"\",\"\",VLOOKUP(Material,CCE_Table,2)&\" / ºF\")","v":""}]
["Condition:",{"$f":"IF(Condition=\"\",\"\",Condition)","v":""},null,null,"Specification:","NIST HB 105-4"]
[]
["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:","NISTIR 7383, SOP 21",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'!B25","v":0},null,{"$f":"'Prover Data Entry'!F25","v":0},{"$f":"'Prover Data Entry'!H25","v":0},null,{"$f":"'Prover Data Entry'!J25","v":"00:00:00"},{"$f":"'Prover Data Entry'!K25","v":"00:00:00"}]
[{"$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"}]
[]
["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 meniscus, for the pressure gauge, 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(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!E45)+Unc>Calculations!E43,\"●  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 LPG Prover 'As Left' volume is 'In-Tolerance', the prover may be used in meter testing without a correction."}]
["●  Enter the Pressure Correction from Table 1 that corresponds with the pressure being tested on your LPG Meter Test form."]
[{"$f":"\"●  The calibration item was calibrated in a 'wet down' condition using water. \"&IF(BottomZero=\"Yes\",\"The calibration data above applies when the prover bottom zero is obtained during a 30 (± 5) second period after cessation of the main flow.\",\"The calibration data above applies when the prover 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 calibration data above applies when the prover is drained for a 30 (± 5) second period after cessation of the main flow."}]
[{"$f":"\"●  The drain time (using \"&'Prover Data Entry'!E111&\") \"&IF(BottomZero=\"Yes\",\"to the bottom zero was approximately \",\"was approximately \")&'Prover Data Entry'!E110&\" minute(s) \"&'Prover Data Entry'!G110&\" seconds.\"","v":"●  The drain time (using ) was approximately  minute(s)  seconds."}]
[{"$f":"IF(AND(SealNoTop=\"\",ISTEXT(SealNoBottom)),\"●  The Bottom Securty Seal Number is \"&SealNoBottom&\".\",IF(AND(ISTEXT(SealNoTop),SealNoBottom=\"\"),\"●  The Top Securty Seal Number is \"&SealNoTop&\".\",\"●  The Top Securty Seal Number is \"&SealNoTop&\" and the Bottom Security Seal Number is \"&SealNoBottom&\".\"))","v":"●  The Top Securty Seal Number is  and the Bottom Security Seal Number is ."}]
["● 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.875 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 Pages 4-5","index":5,"n_rows":32,"n_cols":5,"rows_kept":32,"merged":[[0,0,0,4]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":3},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
["Calibration Results"]
["Nominal Volume\n(at zero mark on gauge)",{"$f":"\"Prover Volume As Found @ 60 ºF and 100 psig\"&IF(NomValUnit=\"Nominal Volume (L)\",\" (L)\",\" (gal)\")","v":"Prover Volume As Found @ 60 ºF and 100 psig (gal)"},{"$f":"\"Prover Volume As Left @ 60 ºF and 100 psig\"&IF(NomValUnit=\"Nominal Volume (L)\",\" (L)\",\" (gal)\")","v":"Prover Volume As Left @ 60 ºF and 100 psig (gal)"},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"NIST HB 105-4\nSpecification Tolerance\n\"&CHAR(177)&\" (L)\",\"NIST HB 105-4\nSpecification Tolerance\n\"&CHAR(177)&\" (gal)\")","v":"NIST HB 105-4\nSpecification Tolerance\n± (gal)"},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Uncertainty\n(k=\"&kfactor&\")\n± (L)\",\"Uncertainty\n(k=\"&kfactor&\")\n(df=\"&Eff_df&\")\n± (gal)\")","v":"Uncertainty\n(k=)\n(df=)\n± (gal)"}]
[{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",Nom_Val&\" L\",Nom_Val&\" gal\"))","v":""},{"$f":"IF(AsFound=\"\",\"\",AsFound)","v":""},{"$f":"IF(AsLeft=\"\",\"\",IF(Adjusted=\"Yes\",FIXED(Nom_Val,2-1-INT(LOG10(ABS(Final_U))),TRUE),AsLeft))","v":""},{"$f":"IF(Tolerance=\"\",\"\",Tolerance)","v":""},{"$f":"Unc","v":""}]
[]
[{"$f":"\"Table 1 - \"&IF(NomValUnit=\"Nominal Volume (L)\",Nom_Val&\" L LPG Prover Corrections @ 60 ºF\",Nom_Val&\" gal LPG Prover Corrections @ 60 ºF\")","v":"Table 1 -  gal LPG Prover Corrections @ 60 ºF"}]
[{"$f":"'Pressure Corrections'!A20","v":"psig"},{"$f":"'Pressure Corrections'!B20","v":"Prover Scale Reading \n(in³)"},{"$f":"'Pressure Corrections'!C20","v":"Pressure Correction (Pcorr) \n(in³)"},{"$f":"IF(Adjusted=\"Yes\",'Pressure Corrections'!D20,'Pressure Corrections'!E20)","v":"Prover Error \n(Not Adjusted) \n(gal)"},{"$f":"'Pressure Corrections'!F20","v":"Prover Volume \n(Not Adjusted) \n(gal)"}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A21)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B21)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C21,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D21,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E21,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F21,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A22)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B22)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C22,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D22,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E22,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F22,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A23)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B23)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C23,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D23,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E23,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F23,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A24)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B24)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C24,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D24,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E24,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F24,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A25)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B25)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C25,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D25,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E25,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F25,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A26)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B26)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C26,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D26,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E26,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F26,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A27)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B27)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C27,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D27,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E27,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F27,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A28)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B28)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C28,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D28,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E28,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F28,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A29)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B29)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C29,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D29,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E29,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F29,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A30)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B30)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C30,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D30,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E30,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F30,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A31)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B31)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C31,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D31,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E31,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F31,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A32)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B32)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C32,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D32,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E32,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F32,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A33)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B33)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C33,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D33,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E33,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F33,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A34)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B34)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C34,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D34,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E34,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F34,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A35)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B35)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C35,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D35,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E35,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F35,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A36)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B36)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C36,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D36,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E36,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F36,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A37)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B37)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C37,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D37,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E37,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F37,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A38)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B38)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C38,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D38,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E38,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F38,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A39)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B39)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C39,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D39,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E39,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F39,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A40)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B40)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C40,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D40,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E40,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F40,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!A41)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",'Pressure Corrections'!B41)","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!C41,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(Adjusted=\"Yes\",FIXED('Pressure Corrections'!D41,2-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED('Pressure Corrections'!E41,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED('Pressure Corrections'!F41,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
["Highlighted column to be used in the LPG Meter Examination Report, item 12."]
[]
[{"$f":"\"Chart 1 - LPG Pressure Corrections \"&IF(NomValUnit=\"Nominal Volume (L)\",\"(L) @ 60 ºF\",\"(gal) @ 60 ºF\")","v":"Chart 1 - LPG Pressure Corrections (gal) @ 60 ºF"},{"$nulls":3},{"$f":"\"Correction \"&RIGHT(C8,5)","v":"Correction (in³)"}]

{"sheet":"Report Page 6","index":6,"n_rows":34,"n_cols":12,"rows_kept":34,"merged":[[0,0,0,11],[1,5,1,6],[4,0,4,11],[5,0,5,11]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":4},{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val&\" \"&IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\")&\" LPG Prover\")","v":""},{"$nulls":5},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
[]
["Table 2 - LPG Temperature Corrections"]
["Correction Per ºF Difference between Meter Temperature and Prover Temperature"]
["Propane Specific Gravity 60/60 ºF 0.505*"]
["Liquid in Prover Temp. ºF","in³ / ºF","gal / ºF","Liquid in Prover Temp. ºF","in³ / ºF","gal / ºF","Liquid in Prover Temp. ºF","in³ / ºF","gal / ºF","Liquid in Prover Temp. ºF","in³ / ºF","gal / ºF"]
[0,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B7)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B7)*Nom_Val*231,3)))","v":""},{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED(B8/1000,3-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED(B8/231,3-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},26,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D7)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D7)*Nom_Val*231,3)))","v":""},{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED(E8/1000,3-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED(E8/231,3-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},52,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F7)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F7)*Nom_Val*231,3)))","v":""},{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED(H8/1000,3-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED(H8/231,3-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},78,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H7)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H7)*Nom_Val*231,3)))","v":""},{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED(K8/1000,3-1-INT(LOG10(ABS(Final_U))),TRUE),FIXED(K8/231,3-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""}]
[1,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B8)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B8)*Nom_Val*231,3)))","v":""},"",27,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D8)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D8)*Nom_Val*231,3)))","v":""},"",53,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F8)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F8)*Nom_Val*231,3)))","v":""},"",79,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H8)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H8)*Nom_Val*231,3)))","v":""},""]
[2,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B9)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B9)*Nom_Val*231,3)))","v":""},"",28,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D9)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D9)*Nom_Val*231,3)))","v":""},"",54,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F9)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F9)*Nom_Val*231,3)))","v":""},"",80,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H9)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H9)*Nom_Val*231,3)))","v":""},""]
[3,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B10)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B10)*Nom_Val*231,3)))","v":""},"",29,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D10)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D10)*Nom_Val*231,3)))","v":""},"",55,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F10)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F10)*Nom_Val*231,3)))","v":""},"",81,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H10)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H10)*Nom_Val*231,3)))","v":""},""]
[4,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B11)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B11)*Nom_Val*231,3)))","v":""},"",30,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D11)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D11)*Nom_Val*231,3)))","v":""},"",56,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F11)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F11)*Nom_Val*231,3)))","v":""},"",82,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H11)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H11)*Nom_Val*231,3)))","v":""},""]
[5,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B12)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B12)*Nom_Val*231,3)))","v":""},"",31,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D12)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D12)*Nom_Val*231,3)))","v":""},"",57,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F12)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F12)*Nom_Val*231,3)))","v":""},"",83,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H12)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H12)*Nom_Val*231,3)))","v":""},""]
[6,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B13)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B13)*Nom_Val*231,3)))","v":""},"",32,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D13)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D13)*Nom_Val*231,3)))","v":""},"",58,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F13)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F13)*Nom_Val*231,3)))","v":""},"",84,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H13)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H13)*Nom_Val*231,3)))","v":""},""]
[7,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B14)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B14)*Nom_Val*231,3)))","v":""},"",33,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D14)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D14)*Nom_Val*231,3)))","v":""},"",59,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F14)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F14)*Nom_Val*231,3)))","v":""},"",85,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H14)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H14)*Nom_Val*231,3)))","v":""},""]
[8,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B15)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B15)*Nom_Val*231,3)))","v":""},"",34,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D15)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D15)*Nom_Val*231,3)))","v":""},"",60,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F15)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F15)*Nom_Val*231,3)))","v":""},"",86,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H15)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H15)*Nom_Val*231,3)))","v":""},""]
[9,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B16)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B16)*Nom_Val*231,3)))","v":""},"",35,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D16)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D16)*Nom_Val*231,3)))","v":""},"",61,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F16)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F16)*Nom_Val*231,3)))","v":""},"",87,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H16)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H16)*Nom_Val*231,3)))","v":""},""]
[10,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B17)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B17)*Nom_Val*231,3)))","v":""},"",36,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D17)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D17)*Nom_Val*231,3)))","v":""},"",62,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F17)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F17)*Nom_Val*231,3)))","v":""},"",88,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H17)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H17)*Nom_Val*231,3)))","v":""},""]
[11,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B18)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B18)*Nom_Val*231,3)))","v":""},"",37,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D18)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D18)*Nom_Val*231,3)))","v":""},"",63,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F18)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F18)*Nom_Val*231,3)))","v":""},"",89,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H18)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H18)*Nom_Val*231,3)))","v":""},""]
[12,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B19)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B19)*Nom_Val*231,3)))","v":""},"",38,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D19)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D19)*Nom_Val*231,3)))","v":""},"",64,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F19)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F19)*Nom_Val*231,3)))","v":""},"",90,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H19)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H19)*Nom_Val*231,3)))","v":""},""]
[13,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B20)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B20)*Nom_Val*231,3)))","v":""},"",39,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D20)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D20)*Nom_Val*231,3)))","v":""},"",65,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F20)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F20)*Nom_Val*231,3)))","v":""},"",91,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H20)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H20)*Nom_Val*231,3)))","v":""},""]
[14,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B21)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B21)*Nom_Val*231,3)))","v":""},"",40,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D21)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D21)*Nom_Val*231,3)))","v":""},"",66,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F21)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F21)*Nom_Val*231,3)))","v":""},"",92,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H21)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H21)*Nom_Val*231,3)))","v":""},""]
[15,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B22)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B22)*Nom_Val*231,3)))","v":""},"",41,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D22)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D22)*Nom_Val*231,3)))","v":""},"",67,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F22)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F22)*Nom_Val*231,3)))","v":""},"",93,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H22)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H22)*Nom_Val*231,3)))","v":""},""]
[16,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B23)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B23)*Nom_Val*231,3)))","v":""},"",42,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D23)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D23)*Nom_Val*231,3)))","v":""},"",68,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F23)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F23)*Nom_Val*231,3)))","v":""},"",94,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H23)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H23)*Nom_Val*231,3)))","v":""},""]
[17,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B24)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B24)*Nom_Val*231,3)))","v":""},"",43,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D24)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D24)*Nom_Val*231,3)))","v":""},"",69,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F24)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F24)*Nom_Val*231,3)))","v":""},"",95,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H24)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H24)*Nom_Val*231,3)))","v":""},""]
[18,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B25)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B25)*Nom_Val*231,3)))","v":""},"",44,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D25)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D25)*Nom_Val*231,3)))","v":""},"",70,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F25)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F25)*Nom_Val*231,3)))","v":""},"",96,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H25)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H25)*Nom_Val*231,3)))","v":""},""]
[19,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B26)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B26)*Nom_Val*231,3)))","v":""},"",45,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D26)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D26)*Nom_Val*231,3)))","v":""},"",71,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F26)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F26)*Nom_Val*231,3)))","v":""},"",97,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H26)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H26)*Nom_Val*231,3)))","v":""},""]
[20,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B27)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B27)*Nom_Val*231,3)))","v":""},"",46,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D27)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D27)*Nom_Val*231,3)))","v":""},"",72,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F27)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F27)*Nom_Val*231,3)))","v":""},"",98,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H27)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H27)*Nom_Val*231,3)))","v":""},""]
[21,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B28)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B28)*Nom_Val*231,3)))","v":""},"",47,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D28)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D28)*Nom_Val*231,3)))","v":""},"",73,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F28)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F28)*Nom_Val*231,3)))","v":""},"",99,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H28)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H28)*Nom_Val*231,3)))","v":""},""]
[22,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B29)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B29)*Nom_Val*231,3)))","v":""},"",48,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D29)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D29)*Nom_Val*231,3)))","v":""},"",74,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F29)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F29)*Nom_Val*231,3)))","v":""},"",100,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!H29)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!H29)*Nom_Val*231,3)))","v":""},""]
[23,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B30)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B30)*Nom_Val*231,3)))","v":""},"",49,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D30)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D30)*Nom_Val*231,3)))","v":""},"",75,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F30)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F30)*Nom_Val*231,3)))","v":""},""]
[24,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B31)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B31)*Nom_Val*231,3)))","v":""},"",50,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D31)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D31)*Nom_Val*231,3)))","v":""},"",76,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F31)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F31)*Nom_Val*231,3)))","v":""},""]
[25,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!B32)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!B32)*Nom_Val*231,3)))","v":""},"",51,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!D32)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!D32)*Nom_Val*231,3)))","v":""},"",77,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((0.00163/'Report Page 8'!F32)*Nom_Val*1000,3),FIXED((0.00163/'Report Page 8'!F32)*Nom_Val*231,3)))","v":""},""]
["* Approximate specific gravity for a commercial LPG product."]

{"sheet":"Report Page 7","index":7,"n_rows":32,"n_cols":12,"rows_kept":32,"merged":[[0,0,0,11],[1,5,1,6],[4,0,4,11]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":4},{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val&\" \"&IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\")&\" LPG Prover\")","v":""},{"$nulls":5},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
[]
["Table 3 - Volume Corrections for Thermal Expansion or Contraction of Prover"]
[{"$f":"\"Coefficient of Cubical Expansion = \"&B&\" / ºF\"","v":"Coefficient of Cubical Expansion =  / ºF"}]
["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)"},"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)"},"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)"},"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)"}]
[0,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((Nom_Val*(1+(B*(A7-60)))-Nom_Val)*1000,1),FIXED((Nom_Val*(1+(B*(A7-60)))-Nom_Val)*231,1)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED(Nom_Val*(1+(B*(A7-60)))-Nom_Val,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},26,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((Nom_Val*(1+(B*(D7-60)))-Nom_Val)*1000,1),FIXED((Nom_Val*(1+(B*(D7-60)))-Nom_Val)*231,1)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED(Nom_Val*(1+(B*(D7-60)))-Nom_Val,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},52,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((Nom_Val*(1+(B*(G7-60)))-Nom_Val)*1000,1),FIXED((Nom_Val*(1+(B*(G7-60)))-Nom_Val)*231,1)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED(Nom_Val*(1+(B*(G7-60)))-Nom_Val,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},78,{"$f":"IF(NomValUnit=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",FIXED((Nom_Val*(1+(B*(J7-60)))-Nom_Val)*1000,1),FIXED((Nom_Val*(1+(B*(J7-60)))-Nom_Val)*231,1)))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",FIXED(Nom_Val*(1+(B*(J7-60)))-Nom_Val,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""}]
[1,"","",27,"","",53,"","",79,"",""]
[2,"","",28,"","",54,"","",80,"",""]
[3,"","",29,"","",55,"","",81,"",""]
[4,"","",30,"","",56,"","",82,"",""]
[5,"","",31,"","",57,"","",83,"",""]
[6,"","",32,"","",58,"","",84,"",""]
[7,"","",33,"","",59,"","",85,"",""]
[8,"","",34,"","",60,"","",86,"",""]
[9,"","",35,"","",61,"","",87,"",""]
[10,"","",36,"","",62,"","",88,"",""]
[11,"","",37,"","",63,"","",89,"",""]
[12,"","",38,"","",64,"","",90,"",""]
[13,"","",39,"","",65,"","",91,"",""]
[14,"","",40,"","",66,"","",92,"",""]
[15,"","",41,"","",67,"","",93,"",""]
[16,"","",42,"","",68,"","",94,"",""]
[17,"","",43,"","",69,"","",95,"",""]
[18,"","",44,"","",70,"","",96,"",""]
[19,"","",45,"","",71,"","",97,"",""]
[20,"","",46,"","",72,"","",98,"",""]
[21,"","",47,"","",73,"","",99,"",""]
[22,"","",48,"","",74,"","",100,"",""]
[23,"","",49,"","",75,"",""]
[24,"","",50,"","",76,"",""]
[25,"","",51,"","",77,"",""]

{"sheet":"Report Page 8","index":8,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[0,0,0,7],[1,3,1,4],[4,0,4,7]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},null,null,{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val&\" \"&IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\")&\" LPG Prover\")","v":""},{"$nulls":3},{"$f":"IF(Cal_Date=\"\",\"Calibration Date\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date"}]
[]
["Table 4 - Volume Correction Factors to 60 ºF"]
["Propane Specific Gravity 60/60 ºF 0.505*"]
["Temperature ºF","Correction Factor","Temperature ºF","Correction Factor","Temperature ºF","Correction Factor","Temperature ºF","Correction Factor"]
[0,1.09008,26,1.05283,52,1.01293,78,0.96955]
[1,1.08869,27,1.05134,53,1.01133,79,{"v":0.9678,"d":"0.96780"}]
[2,1.08729,28,1.04986,54,1.00973,80,0.96604]
[3,{"v":1.0859,"d":"1.08590"},29,1.04837,55,1.00812,81,0.96427]
[4,1.08449,30,1.04688,56,1.00651,82,0.96249]
[5,1.08309,31,1.04538,57,1.00489,83,0.96071]
[6,1.08168,32,1.04388,58,1.00326,84,0.95892]
[7,1.08027,33,1.04237,59,1.00163,85,0.95712]
[8,1.07889,34,1.04086,60,{"v":1,"d":"1.00000"},86,0.95532]
[9,1.07744,35,1.03935,61,0.99836,87,0.95351]
[10,1.07602,36,1.03783,62,0.99671,88,0.95168]
[11,{"v":1.0746,"d":"1.07460"},37,1.03631,63,0.99506,89,0.94986]
[12,1.07317,38,1.03478,64,{"v":0.9934,"d":"0.99340"},90,0.94802]
[13,1.07174,39,1.03325,65,0.99174,91,0.94617]
[14,1.07031,40,1.03172,66,0.99007,92,0.94432]
[15,1.06887,41,1.03018,67,{"v":0.9884,"d":"0.98840"},93,0.94246]
[16,1.06743,42,1.02863,68,0.98671,94,0.94059]
[17,1.06599,43,1.02708,69,0.98503,95,0.93871]
[18,1.06454,44,1.02553,70,0.98333,96,0.93682]
[19,1.06309,45,1.02397,71,0.98163,97,0.93493]
[20,1.06163,46,1.02241,72,0.97993,98,0.93302]
[21,1.06017,47,1.02084,73,0.97821,99,{"v":0.9311,"d":"0.93110"}]
[22,1.05871,48,1.01927,74,0.97649,100,0.92918]
[23,1.05725,49,1.01769,75,0.97477]
[24,1.05578,50,1.01611,76,0.97307]
[25,{"v":1.0543,"d":"1.05430"},51,1.01452,77,{"v":0.9713,"d":"0.97130"}]
["* Approximate specific gravity for a commercial LPG product."]

{"sheet":"Prover Data Entry","index":9,"n_rows":111,"n_cols":11,"rows_kept":111,"merged":[[0,8,0,10],[3,0,3,6],[3,7,3,9],[4,0,4,6],[4,8,4,10],[5,0,5,6],[5,8,5,10],[6,0,6,6],[6,8,6,10],[9,0,9,1],[9,2,9,5],[9,6,9,8],[9,9,9,10],[10,0,10,1],[10,2,10,5],[10,6,10,8],[10,9,10,10],[11,0,11,1],[11,2,11,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,7],[13,8,13,9],[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,8],[16,9,16,10],[17,0,17,4],[17,5,17,6],[17,7,17,9],[18,0,18,4],[18,5,18,6],[19,0,19,4],[19,6,19,9],[20,0,20,1],[20,2,20,3],[20,5,20,7],[20,8,20,9],[23,1,23,4],[23,5,23,6],[23,7,23,8],[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],[34,1,34,3],[34,5,34,6],[34,7,34,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],[40,1,40,3],[40,5,40,6],[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],[47,0,47,3],[47,5,47,6],[47,7,47,8],[47,9,47,10],[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],[52,1,52,2],[52,4,52,5],[55,0,55,4],[55,5,55,9],[74,0,74,4],[74,5,74,9],[75,0,75,3],[75,5,75,8],[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],[82,0,82,9],[83,0,83,8],[84,0,84,8],[85,0,85,8],[86,0,86,5],[86,6,86,9],[87,0,87,9],[88,1,88,9],[89,1,89,6],[89,8,89,9],[90,0,90,9],[91,1,91,9],[92,1,92,9],[93,1,93,9],[94,0,94,8],[95,0,95,8],[96,0,96,9],[97,0,97,4],[97,5,97,9],[98,0,98,3],[98,5,98,8],[99,0,99,3],[99,5,99,8],[100,0,100,3],[100,5,100,8],[101,0,101,3],[101,5,101,8],[102,0,102,3],[102,5,102,9],[103,0,103,2],[103,3,103,4],[103,5,103,7],[103,8,103,9],[106,1,106,2],[106,4,106,5],[109,0,109,3],[110,0,110,3],[110,4,110,7]]}
["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",null,"LPG Prover",{"$nulls":3},"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(OR(F13=\"\",F13=\"Yes\"),\"\",\"Reject or Issue Neck Scale Correction Value (NSCV)\")","v":""}]
["Prover Material",{"$nulls":5},"CCE (β) (/ ºF) =",null,{"$f":"IF(Material=\"\",\"\",VLOOKUP(Material,CCE_Table,2))","v":""}]
["Top Neck Inside Dia. (mm)",null,null,"Bottom Neck Inside Dia. (mm)",{"$nulls":3},"Graduation Line Width (mm)"]
["Artifact Condition",{"$nulls":6},"Job Order Number"]
["Normal Barometric Pressure for Location of Calibration (mm Hg)"]
[{"$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)?"]
["Date of Calibration",{"$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,"Std. Ref. Temp. (trefS ºF)","CCE (α) (/ º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(A36=\"\",\"\",A36)","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]
[]
["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 @ tref) \n(L)\",\"Volume \n(Vs @ tref) \n(gal)\")","v":"Volume \n(Vs @ tref) \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 @ tref) \n(L)\",\"Volume \n(Vs @ tref) \n(gal)\")","v":"Volume \n(Vs @ tref) \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(B58=\"\",\"\",VLOOKUP(B58,Standards_Table_A,6,FALSE))","v":""},null,null,1,null,{"$f":"IF(G58=\"\",\"\",VLOOKUP(G58,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(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 0 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 0 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 0 psig (gal)\",\"Neck Scale Reading @ 0 psig (in³)\")))","v":"Neck Scale Reading @ 0 psig (in³)"},{"$nulls":4},{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 0 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 0 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 0 psig (gal)\",\"Neck Scale Reading @ 0 psig (in³)\")))","v":"Neck Scale Reading @ 0 psig (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(E77:E79)),\"\",AVERAGE(E77:E79))","v":""},"Water Temperature, Average (ºC)",{"$nulls":3},{"$f":"IF(ISERROR(AVERAGE(J77:J79)),\"\",AVERAGE(J77:J79))","v":""}]
[]
["Pressure Measurements"]
["Adjust prover for Nominal Volume at 60 ºF and 100 psig"]
["Does the prover have a bottom scale plate?:"]
["If bottom gauge scale plate is adjustable, enter inside diameter of the lower neck (in)"]
[{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading As Found @ 100 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading As Found @ 100 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading As Found @ 100 psig (gal)\",\"Neck Scale Reading As Found @ 100 psig (in³)\")))","v":"Neck Scale Reading As Found @ 100 psig (in³)"}]
["Desired Neck Scale Reading at 60 ºF and 100 psig is",{"$nulls":5},{"$f":"IF(ISERROR(FIXED(Z60_2/'Water Compressability'!C51-Nom_Val,3,TRUE)),\"TBD\",IF(NomValUnit=\"Nominal Volume (gal)\",FIXED(Z60_2/'Water Compressability'!C51-Nom_Val,3,TRUE)&\" gallons or \"&FIXED(Z60_2/'Water Compressability'!C51-Nom_Val,3,TRUE)*231&\" in³\",FIXED(Z60_2/'Water Compressability'!C51-Nom_Val,3,TRUE)&\" liters or \"&FIXED(Z60_2/'Water Compressability'!C51-Nom_Val,3,TRUE)*1000&\" mL\"))","v":"TBD"}]
["If the upper and/or lower gauge scale plate is adjustable\nperform only ONE of the following adjustments:"]
["A. ","If the top scale is adjustable, then adjust the upper scale to read the Desired Gauge Reading at 60 ºF and 100 psig."]
["B. ","If the bottom scale is adjustable, adjust the bottom scale:",{"$nulls":5},{"$f":"IF(OR(J85=0,J85=\"\"),\"\",IF(AND(Scale_Unit=\"Scale Graduations (in³)\",(Z60_2*231)-(Nom_Val*231)*'Water Compressability'!C51-J86)>0,\"UP \",IF(AND(Scale_Unit=\"Scale Graduations (mL)\",(Z60_2*1000)-(Nom_Val*1000)*'Water Compressability'!C51-J86)>0,\"UP \",IF(AND(OR(Scale_Unit=\"Scale Graduations (L)\",Scale_Unit=\"Scale Graduations (gal)\"),Z60_2-Nom_Val*'Water Compressability'!C51-J86)>0,\"UP \",\"DOWN \"))))","v":""},{"$f":"IF(OR(J85=0,J85=\"\"),\"N/A\",IF(Scale_Unit=\"Scale Graduations (L)\",FIXED(4*(ABS((Z60_2/'Water Compressability'!C51-Nom_Val)-J86)*61.02374)/(PI()*J85^2),2,TRUE),IF(Scale_Unit=\"Scale Graduations (mL)\",FIXED(4*(ABS((Z60_2/'Water Compressability'!C51-Nom_Val)-J86/1000)*61.02374)/(PI()*J85^2),2,TRUE),IF(Scale_Unit=\"Scale Graduations (gal)\",FIXED(4*(ABS((Z60_2/'Water Compressability'!C51-Nom_Val)-J86)*231)/(PI()*J85^2),2,TRUE),FIXED(4*(ABS((Z60_2/'Water Compressability'!C51-Nom_Val)-J86/231)*231)/(PI()*J85^2),2,TRUE))))&\" inches\")","v":"N/A"}]
["Note:  If lower scale was adjusted, print this form, including calculations sheet,\n drain, rezero, and retest before the Increasing / Decreasing Pressure Test."]
["i","It is recommended that LPG provers be adjusted, as close as possible, to the nominal volume at 100 psig. If neither scale is adjustable, a prover volume at 100 psig must be calculated and reported."]
["i","It is best to report the actual volume at 100 psig to ensure that the owner/user applies the correction properly. (A high neck scale reading at 100 psig means the prover is small and the volume reported at 60 ºF and 100 psig should be less than the nominal value of the prover.) The prover error is added to the nominal volume to determine the prover volume (see the Pressure Corrections worksheet)."]
["i","Include a Pressure Correction Table 1 and Chart with your Report of Calibration for the owner/user\nto use during their testing of LPG Meters (see the Report spreadsheet)."]
[{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading As Left @ 100 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading As Left @ 100 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading As Left @ 100 psig (gal)\",\"Neck Scale Reading As Left @ 100 psig (in³)\")))","v":"Neck Scale Reading As Left @ 100 psig (in³)"}]
["Was upper or lower scale adjusted for nominal volume @ 100 psig during this calibration?"]
["Increasing / Decreasing Pressure Test."]
["Increasing Pressure",{"$nulls":4},"Decreasing Pressure"]
[{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 0 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 0 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 0 psig (gal)\",\"Neck Scale Reading @ 0 psig (in³)\")))","v":"Neck Scale Reading @ 0 psig (in³)"},{"$nulls":4},{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 150 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 150 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 150 psig (gal)\",\"Neck Scale Reading @ 150 psig (in³)\")))","v":"Neck Scale Reading @ 150 psig (in³)"}]
[{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 50 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 50 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 50 psig (gal)\",\"Neck Scale Reading @ 50 psig (in³)\")))","v":"Neck Scale Reading @ 50 psig (in³)"},{"$nulls":4},{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 100 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 100 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 100 psig (gal)\",\"Neck Scale Reading @ 100 psig (in³)\")))","v":"Neck Scale Reading @ 100 psig (in³)"}]
[{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 100 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 100 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 100 psig (gal)\",\"Neck Scale Reading @ 100 psig (in³)\")))","v":"Neck Scale Reading @ 100 psig (in³)"},{"$nulls":4},{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 50 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 50 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 50 psig (gal)\",\"Neck Scale Reading @ 50 psig (in³)\")))","v":"Neck Scale Reading @ 50 psig (in³)"}]
[{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 150 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 150 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 150 psig (gal)\",\"Neck Scale Reading @ 150 psig (in³)\")))","v":"Neck Scale Reading @ 150 psig (in³)"},{"$nulls":4},{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 0 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 0 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 0 psig (gal)\",\"Neck Scale Reading @ 0 psig (in³)\")))","v":"Neck Scale Reading @ 0 psig (in³)"}]
[{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Neck Scale Reading @ 200 psig (L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Neck Scale Reading @ 200 psig (mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Neck Scale Reading @ 200 psig (gal)\",\"Neck Scale Reading @ 200 psig (in³)\")))","v":"Neck Scale Reading @ 200 psig (in³)"}]
["Top Scale Security Seal #",{"$nulls":4},"Bottom Scale Security Seal #"]
[]
["Laboratory Test Conditions"]
["Finish","Temperature (ºC)",null,null,"Humidity (% RH)"]
[]
["Prover Drain Time/Method"]
["The prover drain time was:",{"$nulls":4},"minute(s)",null,"seconds(s)"]
["The prover was drained using:"]

{"sheet":"Control Data","index":10,"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) @ 60 ºF\"&IF(NomValUnit=\"Nominal Volume (L)\",\" (L)\",\" (gal)\")","v":"Volume (Trial 1) @ 60 ºF (gal)"},{"$f":"\"Volume (Trial 2) @ 60 ºF\"&IF(NomValUnit=\"Nominal Volume (L)\",\" (L)\",\" (gal)\")","v":"Volume (Trial 2) @ 60 ºF (gal)"},"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'!K21=\"\",\"\",'Prover Data Entry'!K21)","v":""},{"$f":"IF(Cal_Date=\"\",\"\",Cal_Date)","v":""},{"$f":"IF(RptNo=\"\",\"\",RptNo)","v":""},{"$f":"Calculations!E29","v":""},{"$f":"Calculations!E30","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":11,"n_rows":69,"n_cols":10,"rows_kept":69,"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],[32,4,32,5],[33,4,33,5],[36,0,36,9],[37,4,37,5],[37,7,38,9],[38,4,38,5],[41,0,41,9],[42,4,42,5],[43,4,43,5],[43,7,43,9],[44,4,44,5],[44,7,44,9],[47,0,47,9],[48,4,48,5],[48,7,49,9],[49,4,49,5],[52,0,52,9],[53,4,53,5],[53,7,55,9],[54,4,54,5],[55,4,55,5],[58,2,58,8],[59,0,59,9],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[66,4,66,5],[67,4,67,5],[68,4,68,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 #","Std. Ref. Temp. (trefS ºF)","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 #","Std. Ref. Temp. (trefS ºF)","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'!B58=\"\",\"\",VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B58=\"\",\"\",('Prover Data Entry'!D58+StdTempCorr)*1.8+32)","v":""},{"$f":"IF('Prover Data Entry'!B58=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!D58+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!D58+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!D58+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!D58+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!B58=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",D6*(('Prover Data Entry'!C58+('Prover Data Entry'!E58/1000))*(1+(VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,6,FALSE))*(C6-B6))),D6*(('Prover Data Entry'!C58+('Prover Data Entry'!E58/231))*(1+(VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,6,FALSE))*(C6-B6)))))","v":""},1,{"$f":"IF('Prover Data Entry'!G58=\"\",\"\",VLOOKUP('Prover Data Entry'!G58,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G58=\"\",\"\",('Prover Data Entry'!I58+StdTempCorr)*1.8+32)","v":""},{"$f":"IF('Prover Data Entry'!G58=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!I58+StdTempCorr)-3.983035)^2*(('Prover Data Entry'!I58+StdTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!I58+StdTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!I58+StdTempCorr))/1000000,8))","v":""},{"$f":"IF('Prover Data Entry'!G58=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",I6*(('Prover Data Entry'!H58+('Prover Data Entry'!J58/1000))*(1+(VLOOKUP('Prover Data Entry'!G58,Standards_Table_B,6,FALSE))*(H6-G6))),I6*(('Prover Data Entry'!H58+('Prover Data Entry'!J58/231))*(1+(VLOOKUP('Prover Data Entry'!G58,Standards_Table_B,6,FALSE))*(H6-G6)))))","v":""}]
[2,{"$f":"IF('Prover Data Entry'!B59=\"\",\"\",VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B59=\"\",\"\",('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)\",D7*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/1000))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*(C7-B7))),D7*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/231))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*(C7-B7)))))","v":""},2,{"$f":"IF('Prover Data Entry'!G59=\"\",\"\",VLOOKUP('Prover Data Entry'!G59,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G59=\"\",\"\",('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)\",I7*(('Prover Data Entry'!H59+('Prover Data Entry'!J59/1000))*(1+(VLOOKUP('Prover Data Entry'!G59,Standards_Table_B,6,FALSE))*(H7-G7))),I7*(('Prover Data Entry'!H59+('Prover Data Entry'!J59/231))*(1+(VLOOKUP('Prover Data Entry'!G59,Standards_Table_B,6,FALSE))*(H7-G7)))))","v":""}]
[3,{"$f":"IF('Prover Data Entry'!B60=\"\",\"\",VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B60=\"\",\"\",('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)\",D8*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/1000))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*(C8-B8))),D8*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/231))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*(C8-B8)))))","v":""},3,{"$f":"IF('Prover Data Entry'!G60=\"\",\"\",VLOOKUP('Prover Data Entry'!G60,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G60=\"\",\"\",('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)\",I8*(('Prover Data Entry'!H60+('Prover Data Entry'!J60/1000))*(1+(VLOOKUP('Prover Data Entry'!G60,Standards_Table_B,6,FALSE))*(H8-G8))),I8*(('Prover Data Entry'!H60+('Prover Data Entry'!J60/231))*(1+(VLOOKUP('Prover Data Entry'!G60,Standards_Table_B,6,FALSE))*(H8-G8)))))","v":""}]
[4,{"$f":"IF('Prover Data Entry'!B61=\"\",\"\",VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B61=\"\",\"\",('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)\",D9*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/1000))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*(C9-B9))),D9*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/231))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*(C9-B9)))))","v":""},4,{"$f":"IF('Prover Data Entry'!G61=\"\",\"\",VLOOKUP('Prover Data Entry'!G61,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G61=\"\",\"\",('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)\",I9*(('Prover Data Entry'!H61+('Prover Data Entry'!J61/1000))*(1+(VLOOKUP('Prover Data Entry'!G61,Standards_Table_B,6,FALSE))*(H9-G9))),I9*(('Prover Data Entry'!H61+('Prover Data Entry'!J61/231))*(1+(VLOOKUP('Prover Data Entry'!G61,Standards_Table_B,6,FALSE))*(H9-G9)))))","v":""}]
[5,{"$f":"IF('Prover Data Entry'!B62=\"\",\"\",VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B62=\"\",\"\",('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)\",D10*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/1000))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*(C10-B10))),D10*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/231))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*(C10-B10)))))","v":""},5,{"$f":"IF('Prover Data Entry'!G62=\"\",\"\",VLOOKUP('Prover Data Entry'!G62,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G62=\"\",\"\",('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)\",I10*(('Prover Data Entry'!H62+('Prover Data Entry'!J62/1000))*(1+(VLOOKUP('Prover Data Entry'!G62,Standards_Table_B,6,FALSE))*(H10-G10))),I10*(('Prover Data Entry'!H62+('Prover Data Entry'!J62/231))*(1+(VLOOKUP('Prover Data Entry'!G62,Standards_Table_B,6,FALSE))*(H10-G10)))))","v":""}]
[6,{"$f":"IF('Prover Data Entry'!B63=\"\",\"\",VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B63=\"\",\"\",('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)\",D11*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/1000))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*(C11-B11))),D11*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/231))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*(C11-B11)))))","v":""},6,{"$f":"IF('Prover Data Entry'!G63=\"\",\"\",VLOOKUP('Prover Data Entry'!G63,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G63=\"\",\"\",('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)\",I11*(('Prover Data Entry'!H63+('Prover Data Entry'!J63/1000))*(1+(VLOOKUP('Prover Data Entry'!G63,Standards_Table_B,6,FALSE))*(H11-G11))),I11*(('Prover Data Entry'!H63+('Prover Data Entry'!J63/231))*(1+(VLOOKUP('Prover Data Entry'!G63,Standards_Table_B,6,FALSE))*(H11-G11)))))","v":""}]
[7,{"$f":"IF('Prover Data Entry'!B64=\"\",\"\",VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B64=\"\",\"\",('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)\",D12*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/1000))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*(C12-B12))),D12*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/231))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*(C12-B12)))))","v":""},7,{"$f":"IF('Prover Data Entry'!G64=\"\",\"\",VLOOKUP('Prover Data Entry'!G64,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G64=\"\",\"\",('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)\",I12*(('Prover Data Entry'!H64+('Prover Data Entry'!J64/1000))*(1+(VLOOKUP('Prover Data Entry'!G64,Standards_Table_B,6,FALSE))*(H12-G12))),I12*(('Prover Data Entry'!H64+('Prover Data Entry'!J64/231))*(1+(VLOOKUP('Prover Data Entry'!G64,Standards_Table_B,6,FALSE))*(H12-G12)))))","v":""}]
[8,{"$f":"IF('Prover Data Entry'!B65=\"\",\"\",VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B65=\"\",\"\",('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)\",D13*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/1000))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*(C13-B13))),D13*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/231))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*(C13-B13)))))","v":""},8,{"$f":"IF('Prover Data Entry'!G65=\"\",\"\",VLOOKUP('Prover Data Entry'!G65,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G65=\"\",\"\",('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)\",I13*(('Prover Data Entry'!H65+('Prover Data Entry'!J65/1000))*(1+(VLOOKUP('Prover Data Entry'!G65,Standards_Table_B,6,FALSE))*(H13-G13))),I13*(('Prover Data Entry'!H65+('Prover Data Entry'!J65/231))*(1+(VLOOKUP('Prover Data Entry'!G65,Standards_Table_B,6,FALSE))*(H13-G13)))))","v":""}]
[9,{"$f":"IF('Prover Data Entry'!B66=\"\",\"\",VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B66=\"\",\"\",('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)\",D14*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/1000))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*(C14-B14))),D14*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/231))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*(C14-B14)))))","v":""},9,{"$f":"IF('Prover Data Entry'!G66=\"\",\"\",VLOOKUP('Prover Data Entry'!G66,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G66=\"\",\"\",('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)\",I14*(('Prover Data Entry'!H66+('Prover Data Entry'!J66/1000))*(1+(VLOOKUP('Prover Data Entry'!G66,Standards_Table_B,6,FALSE))*(H14-G14))),I14*(('Prover Data Entry'!H66+('Prover Data Entry'!J66/231))*(1+(VLOOKUP('Prover Data Entry'!G66,Standards_Table_B,6,FALSE))*(H14-G14)))))","v":""}]
[10,{"$f":"IF('Prover Data Entry'!B67=\"\",\"\",VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B67=\"\",\"\",('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)\",D15*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/1000))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*(C15-B15))),D15*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/231))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*(C15-B15)))))","v":""},10,{"$f":"IF('Prover Data Entry'!G67=\"\",\"\",VLOOKUP('Prover Data Entry'!G67,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G67=\"\",\"\",('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)\",I15*(('Prover Data Entry'!H67+('Prover Data Entry'!J67/1000))*(1+(VLOOKUP('Prover Data Entry'!G67,Standards_Table_B,6,FALSE))*(H15-G15))),I15*(('Prover Data Entry'!H67+('Prover Data Entry'!J67/231))*(1+(VLOOKUP('Prover Data Entry'!G67,Standards_Table_B,6,FALSE))*(H15-G15)))))","v":""}]
[11,{"$f":"IF('Prover Data Entry'!B68=\"\",\"\",VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B68=\"\",\"\",('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)\",D16*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/1000))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*(C16-B16))),D16*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/231))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*(C16-B16)))))","v":""},11,{"$f":"IF('Prover Data Entry'!G68=\"\",\"\",VLOOKUP('Prover Data Entry'!G68,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G68=\"\",\"\",('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)\",I16*(('Prover Data Entry'!H68+('Prover Data Entry'!J68/1000))*(1+(VLOOKUP('Prover Data Entry'!G68,Standards_Table_B,6,FALSE))*(H16-G16))),I16*(('Prover Data Entry'!H68+('Prover Data Entry'!J68/231))*(1+(VLOOKUP('Prover Data Entry'!G68,Standards_Table_B,6,FALSE))*(H16-G16)))))","v":""}]
[12,{"$f":"IF('Prover Data Entry'!B69=\"\",\"\",VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B69=\"\",\"\",('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)\",D17*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/1000))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*(C17-B17))),D17*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/231))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*(C17-B17)))))","v":""},12,{"$f":"IF('Prover Data Entry'!G69=\"\",\"\",VLOOKUP('Prover Data Entry'!G69,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G69=\"\",\"\",('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)\",I17*(('Prover Data Entry'!H69+('Prover Data Entry'!J69/1000))*(1+(VLOOKUP('Prover Data Entry'!G69,Standards_Table_B,6,FALSE))*(H17-G17))),I17*(('Prover Data Entry'!H69+('Prover Data Entry'!J69/231))*(1+(VLOOKUP('Prover Data Entry'!G69,Standards_Table_B,6,FALSE))*(H17-G17)))))","v":""}]
[13,{"$f":"IF('Prover Data Entry'!B70=\"\",\"\",VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B70=\"\",\"\",('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)\",D18*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/1000))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*(C18-B18))),D18*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/231))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*(C18-B18)))))","v":""},13,{"$f":"IF('Prover Data Entry'!G70=\"\",\"\",VLOOKUP('Prover Data Entry'!G70,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G70=\"\",\"\",('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)\",I18*(('Prover Data Entry'!H70+('Prover Data Entry'!J70/1000))*(1+(VLOOKUP('Prover Data Entry'!G70,Standards_Table_B,6,FALSE))*(H18-G18))),I18*(('Prover Data Entry'!H70+('Prover Data Entry'!J70/231))*(1+(VLOOKUP('Prover Data Entry'!G70,Standards_Table_B,6,FALSE))*(H18-G18)))))","v":""}]
[14,{"$f":"IF('Prover Data Entry'!B71=\"\",\"\",VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B71=\"\",\"\",('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)\",D19*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/1000))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*(C19-B19))),D19*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/231))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*(C19-B19)))))","v":""},14,{"$f":"IF('Prover Data Entry'!G71=\"\",\"\",VLOOKUP('Prover Data Entry'!G71,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G71=\"\",\"\",('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)\",I19*(('Prover Data Entry'!H71+('Prover Data Entry'!J71/1000))*(1+(VLOOKUP('Prover Data Entry'!G71,Standards_Table_B,6,FALSE))*(H19-G19))),I19*(('Prover Data Entry'!H71+('Prover Data Entry'!J71/231))*(1+(VLOOKUP('Prover Data Entry'!G71,Standards_Table_B,6,FALSE))*(H19-G19)))))","v":""}]
[15,{"$f":"IF('Prover Data Entry'!B72=\"\",\"\",VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!B72=\"\",\"\",('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)\",D20*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/1000))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*(C20-B20))),D20*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/231))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*(C20-B20)))))","v":""},15,{"$f":"IF('Prover Data Entry'!G72=\"\",\"\",VLOOKUP('Prover Data Entry'!G72,Standards_Table_B,5,FALSE))","v":""},{"$f":"IF('Prover Data Entry'!G72=\"\",\"\",('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)\",I20*(('Prover Data Entry'!H72+('Prover Data Entry'!J72/1000))*(1+(VLOOKUP('Prover Data Entry'!G72,Standards_Table_B,6,FALSE))*(H20-G20))),I20*(('Prover Data Entry'!H72+('Prover Data Entry'!J72/231))*(1+(VLOOKUP('Prover Data Entry'!G72,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":""}]
["LPG Prover Trial 1",{"$nulls":4},"LPG Prover Trial 2"]
["Water Density (g/cm³) =",null,null,{"$f":"IF(t_1=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!E80+ProverTempCorr)-3.983035)^2*(('Prover Data Entry'!E80+ProverTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!E80+ProverTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!E80+ProverTempCorr))/1000000,8))","v":""},null,"Water Density (g/cm³) =",null,null,{"$f":"IF(t_2=\"\",\"\",ROUND((999.97495*(1-((('Prover Data Entry'!J80+ProverTempCorr)-3.983035)^2*(('Prover Data Entry'!J80+ProverTempCorr)+301.797))/(522528.9*(('Prover Data Entry'!J80+ProverTempCorr)+69.34881))))/1000+(-4.612+0.106*('Prover Data Entry'!J80+ProverTempCorr))/1000000,8))","v":""}]
["Water Temperature (ºF) =",null,null,{"$f":"IF(t_1=\"\",\"\",(t_1+ProverTempCorr)*1.8+32)","v":""},null,"Water Temperature (ºF) =",null,null,{"$f":"IF(t_2=\"\",\"\",(t_2+ProverTempCorr)*1.8+32)","v":""}]
[]
["LPG Prover Volume Determinations At The Designated Reference Temperature"]
[{"$nulls":3},"Trial 1 VXtrefX =",{"$f":"IF(E21=\"\",\"\",E21/(D23*(1+B*(D24-60))))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF\",\"gal @ 60 ºF\"))","v":""}]
[{"$nulls":3},"Trial 2 VXtrefX =",{"$f":"IF(J21=\"\",\"\",J21/(I23*(1+B*(I24-60))))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF\",\"gal @ 60 ºF\"))","v":""}]
[{"$nulls":3},"Trial 1 LPG Prover Volume =",{"$f":"IF(E27=\"\",\"\",IF(OR(Scale_Unit=\"Scale Graduations (gal)\",Scale_Unit=\"Scale Graduations (L)\"),E27-'Prover Data Entry'!E76,IF(Scale_Unit=\"Scale Graduations (mL)\",E27-'Prover Data Entry'!E76/1000,E27-'Prover Data Entry'!E76/231)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF\",\"gal @ 60 ºF\"))","v":""}]
[{"$nulls":3},"Trial 2 LPG Prover Volume =",{"$f":"IF(E28=\"\",\"\",IF(OR(Scale_Unit=\"Scale Graduations (gal)\",Scale_Unit=\"Scale Graduations (L)\"),E28-'Prover Data Entry'!J76,IF(Scale_Unit=\"Scale Graduations (mL)\",E28-'Prover Data Entry'!J76/1000,E28-'Prover Data Entry'!J76/231)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF\",\"gal @ 60 ºF\"))","v":""}]
[]
["LPG Volume Determinations @ 60 ºF and 100 psig"]
[{"$nulls":3},"Prover Volume As Found =",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",Z60_2-Nom_Val*'Water Compressability'!C51-'Prover Data Entry'!J86/231+Nom_Val,IF(Scale_Unit=\"Scale Graduations (mL)\",Z60_2-Nom_Val*'Water Compressability'!C51-'Prover Data Entry'!J86/1000+Nom_Val,Z60_2-Nom_Val*'Water Compressability'!C51-'Prover Data Entry'!J86+Nom_Val)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF and 100 psig\",\"gal @ 60 ºF and 100 psig\"))","v":""}]
[{"$nulls":3},"Prover Volume As Left =",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",Z60_2-Nom_Val*'Water Compressability'!C51-'Prover Data Entry'!J95/231+Nom_Val,IF(Scale_Unit=\"Scale Graduations (mL)\",Z60_2-Nom_Val*'Water Compressability'!C51-'Prover Data Entry'!J95/1000+Nom_Val,Z60_2-Nom_Val*'Water Compressability'!C51-'Prover Data Entry'!J95+Nom_Val)))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF and 100 psig\",\"gal @ 60 ºF and 100 psig\"))","v":""}]
[]
["Uncertainty Evaluation"]
["NIST HB 105-4 Criteria: The expanded uncertainty for calibration must be less than 0.2 % of the measured volume."]
[{"$nulls":3},"0.2 % of Measured Volume =",{"$f":"IF(E34=\"\",\"\",0.2%*E34)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""},{"$f":"IF(OR(E38=\"\",E38=\"N/A\"),\"\",IF(E39<E38,\"Uncertainty Meets Criteria.\",\"Uncertainty Fails Criteria, Re-evaluate or Use Different Calibration Method.\"))","v":""}]
[{"$nulls":3},"Expanded Uncertainty =",{"$f":"Final_U","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[]
["Tolerance Evaluation"]
["NIST HB 105-4 Criteria: The maximum permissible errors shall be ± 0.2 % of the nominal capacity minus the uncertainty."]
[{"$nulls":3},"Tolerance =",{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val*0.2%)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[{"$nulls":3},"Volume Error As Found =",{"$f":"IF(E33=\"\",\"\",E33-Nom_Val)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""},{"$f":"IF(E44=\"\",\"\",IF(ABS(E44)+Unc<=E43,\"Artifact Found Within Tolerence.\",\"Artifact Found Out-Of-Tolerance.\"))","v":""}]
[{"$nulls":3},"Volume Error As Left =",{"$f":"IF(E34=\"\",\"\",E34-Nom_Val)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""},{"$f":"IF(E45=\"\",\"\",IF(ABS(E45)+Unc<=E43,\"Artifact Left Within Tolerence.\",\"Artifact Left Out-Of-Tolerance.\"))","v":""}]
[]
["Measurement Evaluation"]
["NIST HB 105-4 Criteria: Must be capable of repeating within 0.02 % of the test volume."]
[{"$nulls":3},"0.02 % of measure 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(E50=\"\",\"\",IF(E50<E49,\"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(E29-E30)),\"\",ABS(E29-E30))","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(E56=\"\",\"\",IF(E56>CL,\"The Standard Deviation Is Outside The Control Limits, Investigate The Problem, Then Redo The Measurements\",IF(E56<=WL,\"The Standard Deviation Is In Control, Plot The Value On The Control Chart\",IF(AND(E56>WL,E56<=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(E33,E34)),\"\",STDEV(E33,E34))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L\",\"gal\"))","v":""}]
[]
["Increasing / Decreasing Pressure Test"]
[{"$f":"IF(OR(Nom_Val=\"\",NomValUnit=\"Nominal Volume (gal)\"),\"\",IF(Scale_Unit=\"Scale Graduations (L)\",AND(ABS('Prover Data Entry'!E99-'Prover Data Entry'!J102)<=0.0002*Nom_Val,ABS('Prover Data Entry'!E100-'Prover Data Entry'!J101)<=0.0002*Nom_Val,ABS('Prover Data Entry'!E101-'Prover Data Entry'!J100)<=0.0002*Nom_Val,ABS('Prover Data Entry'!E102-'Prover Data Entry'!J99)<=0.0002*Nom_Val),AND(ABS('Prover Data Entry'!E99-'Prover Data Entry'!J102)<=0.0002*Nom_Val*1000,ABS('Prover Data Entry'!E100-'Prover Data Entry'!J101)<=0.0002*Nom_Val*1000,ABS('Prover Data Entry'!E101-'Prover Data Entry'!J100)<=0.0002*Nom_Val*1000,ABS('Prover Data Entry'!E102-'Prover Data Entry'!J99)<=0.0002*Nom_Val*1000)))","v":""},null,"Criteria: Must agree within 0.02 % of prover nominal volume.",{"$nulls":6},{"$f":"IF(OR(Nom_Val=\"\",NomValUnit=\"Nominal Volume (L)\"),\"\",IF(Scale_Unit=\"Scale Graduations (gal)\",AND(ABS('Prover Data Entry'!E99-'Prover Data Entry'!J102)<=0.0002*Nom_Val,ABS('Prover Data Entry'!E100-'Prover Data Entry'!J101)<=0.0002*Nom_Val,ABS('Prover Data Entry'!E101-'Prover Data Entry'!J100)<=0.0002*Nom_Val,ABS('Prover Data Entry'!E102-'Prover Data Entry'!J99)<=0.0002*Nom_Val),AND(ABS('Prover Data Entry'!E99-'Prover Data Entry'!J102)<=0.0002*Nom_Val*231,ABS('Prover Data Entry'!E100-'Prover Data Entry'!J101)<=0.0002*Nom_Val*231,ABS('Prover Data Entry'!E101-'Prover Data Entry'!J100)<=0.0002*Nom_Val*231,ABS('Prover Data Entry'!E102-'Prover Data Entry'!J99)<=0.0002*Nom_Val*231)))","v":""}]
[{"$f":"IF('Prover Data Entry'!E99=\"\",\"\",IF(AND(NomValUnit=\"Nominal Volume (L)\",A59=TRUE),\"Pressure test passed, all like pressure points are within \"&0.0002*Nom_Val&\" L or \"&0.0002*Nom_Val*1000&\" mL. Issue Report of Calibration.\",IF(AND(NomValUnit=\"Nominal Volume (gal)\",J59=TRUE),\"Pressure test passed, all like pressure points are within \"&0.0002*Nom_Val&\" gal or \"&0.0002*Nom_Val*231&\" in³. Issue Report of Calibration.\",IF(AND(NomValUnit=\"Nominal Volume (L)\",A59=FALSE),\"Pressure test failed, some or all like pressure points are not within \"&0.0002*Nom_Val&\" L or \"&0.0002*Nom_Val*1000&\" mL.  Investigate the problem (i.e., check for leaks or loose fittings), correct the problem then rerun the test.\",IF(AND(NomValUnit=\"Nominal Volume (gal)\",J59=FALSE),\"Pressure test failed, some or all like pressure points are not within \"&0.0002*Nom_Val&\" gal or \"&0.0002*Nom_Val*231&\" in³.  Investigate the problem (i.e., check for leaks or loose fittings), correct the problem then rerun the test.\")))))","v":""}]
[]
["Results Formatted For Calibration Report"]
[{"$nulls":3},"LPG Prover Nominal Value =",{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val)","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\"))","v":""}]
[{"$nulls":3},"Tolerance =",{"$f":"IF(Nom_Val=\"\",\"\",FIXED(Nom_Val*0.2%,2-1-INT(LOG10(ABS(Final_U))),TRUE))","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\"))","v":""}]
[{"$nulls":3},"LPG Prover Volume As Found =",{"$f":"IF(ISNUMBER(E33),FIXED(E33,2-1-INT(LOG10(ABS(Final_U))),TRUE),\"\")","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF and 100 psig\",\"gal @ 60 ºF and 100 psig\"))","v":""}]
[{"$nulls":3},"LPG Prover Volume As Left =",{"$f":"IF(ISNUMBER(E34),FIXED(E34,2-1-INT(LOG10(ABS(Final_U))),TRUE),\"\")","v":""},null,{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (L)\",\"L @ 60 ºF and 100 psig\",\"gal @ 60 ºF and 100 psig\"))","v":""}]
[{"$nulls":3},"Effective Degrees of Freedom =",{"$f":"IF(E63=\"\",\"\",Final_Veff)","v":""}]
[{"$nulls":3},"k factor =",{"$f":"IF(E63=\"\",\"\",Final_k)","v":""}]
[{"$nulls":3},"Uncertainty (uc*k) =",{"$f":"IF(E63=\"\",\"\",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":"Pressure Corrections","index":12,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[8,2,8,5]]}
["Pressure Corrections",{"$nulls":4},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Pressure Correction Formulas"]
["Prover Error at Reference Temperature and Selected Pressure"]
[]
[null,"where"]
[null,"VXtrefX =","Prover volume at reference temperature and 0 psig"]
[null,"VNominal =","Nominal volume of prover"]
[null,"Wcf =","Water compressibility correction factor (See SOP 21, paragraph 3.3)"]
[null,"Sr =","Scale reading"]
[null,"Npsig =","Selected applied pressure"]
[]
["Pressure Correction"]
[]
[null,"where"]
[null,"Pcorr @ Npsig=","Prover correction at selected psig"]
[null,"Wcv =",{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Water compressibility value L/L at 100 psig\",\"Water compressibility value gal/gal at 100 psig\")","v":"Water compressibility value gal/gal at 100 psig"}]
[]
["Pressure Correction Calculations"]
["psig",{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Prover Scale Reading \n(L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Prover Scale Reading \n(mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Prover Scale Reading \n(gal)\",\"Prover Scale Reading \n(in³)\")))","v":"Prover Scale Reading \n(in³)"},{"$f":"IF(Scale_Unit=\"Scale Graduations (L)\",\"Pressure Correction (Pcorr) \n(L)\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"Pressure Correction (Pcorr) \n(mL)\",IF(Scale_Unit=\"Scale Graduations (gal)\",\"Pressure Correction (Pcorr) \n(gal)\",\"Pressure Correction (Pcorr) \n(in³)\")))","v":"Pressure Correction (Pcorr) \n(in³)"},{"$f":"\"Prover Error (Adjusted) \"&\nIF(NomValUnit=\"Nominal Value (L)\",\"\n(L)\",\"\n(gal)\")","v":"Prover Error (Adjusted) \n(gal)"},{"$f":"\"Prover Error \n(Not Adjusted) \"&\nIF(NomValUnit=\"Nominal Value (L)\",\"\n(L)\",\"\n(gal)\")","v":"Prover Error \n(Not Adjusted) \n(gal)"},{"$f":"IF(AND(Adjusted=\"Yes\",NomValUnit=\"Nominal Volume (gal)\"),\"Prover Volume \n(Adjusted) \n(gal)\",IF(AND(Adjusted=\"Yes\",NomValUnit=\"Nominal Volume (L)\"),\"Prover Volume \n(Adjusted) \n(L)\",IF(AND(Adjusted=\"No\",NomValUnit=\"Nominal Volume (L)\"),\"Prover Volume \n(Not Adjusted) \n(L)\",\"Prover Volume \n(Not Adjusted) \n(gal)\")))","v":"Prover Volume \n(Not Adjusted) \n(gal)"}]
[0,{"$f":"IF(Z60_2=\"\",\"\",'Prover Data Entry'!E99)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B21+('Water Compressability'!$D$39*Nom_Val*231)*((100-A21)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B21+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A21)/100),$B$31-B21+('Water Compressability'!$D$39*Nom_Val)*((100-A21)/100))))","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",C21/231,IF(Scale_Unit=\"Scale Graduations (mL)\",C21/1000,C21)))","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C41)*231-B21)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C41)*1000-B21)/1000,Z60_2-Nom_Val*'Water Compressability'!C41-B21)))","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Adjusted=\"Yes\",Nom_Val+D21,Nom_Val+E21))","v":""}]
[10,{"$f":"IF(Z60_2=\"\",\"\",(($B$26-$B$21)/5)+B21)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B22+('Water Compressability'!$D$39*Nom_Val*231)*((100-A22)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B22+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A22)/100),$B$31-B22+('Water Compressability'!$D$39*Nom_Val)*((100-A22)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C42)*231-B22)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C42)*1000-B22)/1000,Z60_2-Nom_Val*'Water Compressability'!C42-B22)))","v":""},""]
[20,{"$f":"IF(Z60_2=\"\",\"\",(($B$26-$B$21)/5)+B22)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B23+('Water Compressability'!$D$39*Nom_Val*231)*((100-A23)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B23+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A23)/100),$B$31-B23+('Water Compressability'!$D$39*Nom_Val)*((100-A23)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C43)*231-B23)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C43)*1000-B23)/1000,Z60_2-Nom_Val*'Water Compressability'!C43-B23)))","v":""},""]
[30,{"$f":"IF(Z60_2=\"\",\"\",(($B$26-$B$21)/5)+B23)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B24+('Water Compressability'!$D$39*Nom_Val*231)*((100-A24)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B24+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A24)/100),$B$31-B24+('Water Compressability'!$D$39*Nom_Val)*((100-A24)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C44)*231-B24)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C44)*1000-B24)/1000,Z60_2-Nom_Val*'Water Compressability'!C44-B24)))","v":""},""]
[40,{"$f":"IF(Z60_2=\"\",\"\",(($B$26-$B$21)/5)+B24)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B25+('Water Compressability'!$D$39*Nom_Val*231)*((100-A25)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B25+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A25)/100),$B$31-B25+('Water Compressability'!$D$39*Nom_Val)*((100-A25)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C45)*231-B25)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C45)*1000-B25)/1000,Z60_2-Nom_Val*'Water Compressability'!C45-B25)))","v":""},""]
[50,{"$f":"IF(Z60_2=\"\",\"\",'Prover Data Entry'!E100)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B26+('Water Compressability'!$D$39*Nom_Val*231)*((100-A26)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B26+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A26)/100),$B$31-B26+('Water Compressability'!$D$39*Nom_Val)*((100-A26)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C46)*231-B26)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C46)*1000-B26)/1000,Z60_2-Nom_Val*'Water Compressability'!C46-B26)))","v":""},""]
[60,{"$f":"IF(Z60_2=\"\",\"\",(($B$31-$B$26)/5)+B26)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B27+('Water Compressability'!$D$39*Nom_Val*231)*((100-A27)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B27+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A27)/100),$B$31-B27+('Water Compressability'!$D$39*Nom_Val)*((100-A27)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C47)*231-B27)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C47)*1000-B27)/1000,Z60_2-Nom_Val*'Water Compressability'!C47-B27)))","v":""},""]
[70,{"$f":"IF(Z60_2=\"\",\"\",(($B$31-$B$26)/5)+B27)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B28+('Water Compressability'!$D$39*Nom_Val*231)*((100-A28)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B28+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A28)/100),$B$31-B28+('Water Compressability'!$D$39*Nom_Val)*((100-A28)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C48)*231-B28)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C48)*1000-B28)/1000,Z60_2-Nom_Val*'Water Compressability'!C48-B28)))","v":""},""]
[80,{"$f":"IF(Z60_2=\"\",\"\",(($B$31-$B$26)/5)+B28)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B29+('Water Compressability'!$D$39*Nom_Val*231)*((100-A29)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B29+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A29)/100),$B$31-B29+('Water Compressability'!$D$39*Nom_Val)*((100-A29)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C49)*231-B29)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C49)*1000-B29)/1000,Z60_2-Nom_Val*'Water Compressability'!C49-B29)))","v":""},""]
[90,{"$f":"IF(Z60_2=\"\",\"\",(($B$31-$B$26)/5)+B29)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B30+('Water Compressability'!$D$39*Nom_Val*231)*((100-A30)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B30+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A30)/100),$B$31-B30+('Water Compressability'!$D$39*Nom_Val)*((100-A30)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C50)*231-B30)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C50)*1000-B30)/1000,Z60_2-Nom_Val*'Water Compressability'!C50-B30)))","v":""},""]
[100,{"$f":"IF(Z60_2=\"\",\"\",'Prover Data Entry'!E101)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B31+('Water Compressability'!$D$39*Nom_Val*231)*((100-A31)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B31+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A31)/100),$B$31-B31+('Water Compressability'!$D$39*Nom_Val)*((100-A31)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C51)*231-B31)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C51)*1000-B31)/1000,Z60_2-Nom_Val*'Water Compressability'!C51-B31)))","v":""},""]
[110,{"$f":"IF(Z60_2=\"\",\"\",(($B$36-$B$31)/5)+B31)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B32+('Water Compressability'!$D$39*Nom_Val*231)*((100-A32)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B32+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A32)/100),$B$31-B32+('Water Compressability'!$D$39*Nom_Val)*((100-A32)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C52)*231-B32)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C52)*1000-B32)/1000,Z60_2-Nom_Val*'Water Compressability'!C52-B32)))","v":""},""]
[120,{"$f":"IF(Z60_2=\"\",\"\",(($B$36-$B$31)/5)+B32)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B33+('Water Compressability'!$D$39*Nom_Val*231)*((100-A33)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B33+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A33)/100),$B$31-B33+('Water Compressability'!$D$39*Nom_Val)*((100-A33)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C53)*231-B33)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C53)*1000-B33)/1000,Z60_2-Nom_Val*'Water Compressability'!C53-B33)))","v":""},""]
[130,{"$f":"IF(Z60_2=\"\",\"\",(($B$36-$B$31)/5)+B33)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B34+('Water Compressability'!$D$39*Nom_Val*231)*((100-A34)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B34+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A34)/100),$B$31-B34+('Water Compressability'!$D$39*Nom_Val)*((100-A34)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C54)*231-B34)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C54)*1000-B34)/1000,Z60_2-Nom_Val*'Water Compressability'!C54-B34)))","v":""},""]
[140,{"$f":"IF(Z60_2=\"\",\"\",(($B$36-$B$31)/5)+B34)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B35+('Water Compressability'!$D$39*Nom_Val*231)*((100-A35)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B35+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A35)/100),$B$31-B35+('Water Compressability'!$D$39*Nom_Val)*((100-A35)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C55)*231-B35)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C55)*1000-B35)/1000,Z60_2-Nom_Val*'Water Compressability'!C55-B35)))","v":""},""]
[150,{"$f":"IF(Z60_2=\"\",\"\",'Prover Data Entry'!E102)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B36+('Water Compressability'!$D$39*Nom_Val*231)*((100-A36)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B36+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A36)/100),$B$31-B36+('Water Compressability'!$D$39*Nom_Val)*((100-A36)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C56)*231-B36)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C56)*1000-B36)/1000,Z60_2-Nom_Val*'Water Compressability'!C56-B36)))","v":""},""]
[160,{"$f":"IF(Z60_2=\"\",\"\",(($B$41-$B$36)/5)+B36)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B37+('Water Compressability'!$D$39*Nom_Val*231)*((100-A37)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B37+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A37)/100),$B$31-B37+('Water Compressability'!$D$39*Nom_Val)*((100-A37)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C57)*231-B37)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C57)*1000-B37)/1000,Z60_2-Nom_Val*'Water Compressability'!C57-B37)))","v":""},""]
[170,{"$f":"IF(Z60_2=\"\",\"\",(($B$41-$B$36)/5)+B37)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B38+('Water Compressability'!$D$39*Nom_Val*231)*((100-A38)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B38+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A38)/100),$B$31-B38+('Water Compressability'!$D$39*Nom_Val)*((100-A38)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C58)*231-B38)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C58)*1000-B38)/1000,Z60_2-Nom_Val*'Water Compressability'!C58-B38)))","v":""},""]
[180,{"$f":"IF(Z60_2=\"\",\"\",(($B$41-$B$36)/5)+B38)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B39+('Water Compressability'!$D$39*Nom_Val*231)*((100-A39)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B39+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A39)/100),$B$31-B39+('Water Compressability'!$D$39*Nom_Val)*((100-A39)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C59)*231-B39)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C59)*1000-B39)/1000,Z60_2-Nom_Val*'Water Compressability'!C59-B39)))","v":""},""]
[190,{"$f":"IF(Z60_2=\"\",\"\",(($B$41-$B$36)/5)+B39)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B40+('Water Compressability'!$D$39*Nom_Val*231)*((100-A40)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B40+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A40)/100),$B$31-B40+('Water Compressability'!$D$39*Nom_Val)*((100-A40)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C60)*231-B40)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C60)*1000-B40)/1000,Z60_2-Nom_Val*'Water Compressability'!C60-B40)))","v":""},""]
[200,{"$f":"IF(Z60_2=\"\",\"\",'Prover Data Entry'!E103)","v":""},{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",$B$31-B41+('Water Compressability'!$D$39*Nom_Val*231)*((100-A41)/100),IF(Scale_Unit=\"Scale Graduations (mL)\",$B$31-B41+('Water Compressability'!$D$39*Nom_Val*1000)*((100-A41)/100),$B$31-B41+('Water Compressability'!$D$39*Nom_Val)*((100-A41)/100))))","v":""},"",{"$f":"IF(Z60_2=\"\",\"\",IF(Scale_Unit=\"Scale Graduations (in³)\",((Z60_2-Nom_Val*'Water Compressability'!C61)*231-B41)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",((Z60_2-Nom_Val*'Water Compressability'!C61)*1000-B41)/1000,Z60_2-Nom_Val*'Water Compressability'!C61-B41)))","v":""},""]

{"sheet":"Water Compressability","index":13,"n_rows":61,"n_cols":5,"rows_kept":61,"merged":[[3,0,3,4],[12,0,12,4],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[38,0,38,2]]}
["Compressibility of Water",{"$nulls":3},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Compressibility of Water Equations and Calculations"]
["The Thermal Compressibility of Water (kT) equation is from the article by Frank E. Jones and Georgia L. Harris, \"ITS-90 Density of Water Formulation for Volumetric Standards Calibration\", as published in the Journal of Research of the National Institution of Standards and Technology, Vol. 97, No. 3, 1992."]
["kT (kPa)-1 =","50.831 01x10-8 - 3.682 93x10-9t + 7.263 725x10-11t2 - 6.597 702x10-13t3 + 2.877 67x10-15t4"]
["kT (kPa)-1 =",{"$f":"IF(D34=\"\",\"\",0.0000005083101-0.00000000368293*D34+0.00000000007263725*D34^2-0.0000000000006597702*D34^3+2.87767E-15*D34^4)","v":4.6628157738881265E-7}]
[]
["where"]
[null,"t = temperature of water"]
[]
["Thermal Compressibility of Water Based on Calibration Location Atmospheric Pressure"]
["kT (atm) =",{"$f":"IF(B6=\"\",\"\",B6*D36/1000)","v":{"$error":"#VALUE!"}}]
["Note: This worksheet takes into account the typical atmospheric pressure at the location of the calibration."]
[]
["Water Compressibility Value"]
["Wcv =  ( Vnom ) ( kT ) ( P )"]
[]
["Water Compressibility Factor"]
["Wcf =  1 + ( kT ) ( P )"]
[]
["where"]
["Vnom = ","Nominal volume of the prover in gallons or liters"]
["kT =","Thermal compressibility of water in atmospheres (atm)"]
["P =","Pressure in atm"]
[]
["Conversion Factors (from NIST SP 811)"]
["To Convert From",null,"To","Multiply By"]
["atmosphere (standard)",null,"Pascal (Pa) (exactly)",{"v":101325,"d":"101 325"}]
["pounds per square inch (psi)",null,"Pascal Pa",6894.757]
["millimeter of mercury (0 ºC) (mm Hg)",null,"Pascal Pa",133.322]
[]
["Calibration Data"]
[{"$f":"NomValUnit&\" =\"","v":" ="},null,null,{"$f":"IF(Nom_Val=\"\",\"\",Nom_Val)","v":""}]
["Designated Reference Temperature (ºC) =",null,null,{"$f":"(60-32)/1.8","v":15.555555555555555}]
["Typical Barometric Pressure at Your Location (mm Hg) =",null,null,{"$f":"IF(mmHg=\"\",\"\",mmHg)","v":""}]
["or Pascal (Pa) =",null,null,{"$f":"IF(D35=\"\",\"\",D35*D30)","v":""}]
[]
["Compressibility of Water Versus Pressure Calculations"]
[{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Compressability Value per liter at \"&mmHg&\" mm Hg =\",\"Compressability Value per gallon at \"&mmHg&\" mm Hg =\")","v":"Compressability Value per gallon at  mm Hg ="},null,null,{"$f":"IF(B12=\"\",\"\",$B$12*B51)","v":{"$error":"#VALUE!"}}]
["Pressure (psig)","Pressure (atm)","Wcf",{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Wcv (mL)\",\"Wcv (in³)\")","v":"Wcv (in³)"},{"$f":"IF(NomValUnit=\"Nominal Volume (L)\",\"Wcv (L)\",\"Wcv (gal)\")","v":"Wcv (gal)"}]
[0,{"$f":"A41*$D$29/$D$28","v":0},{"$f":"IF($B$12=\"\",\"\",1+$B$12*B41)","v":{"$error":"#VALUE!"}},{"$f":"IF($D$33=\"\",\"\",IF(NomValUnit=\"Nominal Volume (gal)\",$D$33*231*$B$12*B41,$D$33*1000*$B$12*B41))","v":""},{"$f":"IF(Nom_Val=\"\",\"\",IF(NomValUnit=\"Nominal Volume (gal)\",D41/231,D41/1000))","v":""}]
[10,{"$f":"A42*$D$29/$D$28","v":0.6804596101653095},{"$f":"IF($B$12=\"\",\"\",1+$B$12*B42)","v":{"$error":"#VALUE!"}},"",""]
[20,{"$f":"A43*$D$29/$D$28","v":1.360919220330619},{"$error":"#VALUE!"},"",""]
[30,2.041378830495929,{"$error":"#VALUE!"},"",""]
[40,2.721838440661238,{"$error":"#VALUE!"},"",""]
[50,3.402298050826548,{"$error":"#VALUE!"},"",""]
[60,4.082757660991858,{"$error":"#VALUE!"},"",""]
[70,4.763217271157168,{"$error":"#VALUE!"},"",""]
[80,5.443676881322476,{"$error":"#VALUE!"},"",""]
[90,6.1241364914877865,{"$error":"#VALUE!"},"",""]
[100,6.804596101653096,{"$error":"#VALUE!"},"",""]
[110,7.485055711818405,{"$error":"#VALUE!"},"",""]
[120,8.165515321983715,{"$error":"#VALUE!"},"",""]
[130,8.845974932149025,{"$error":"#VALUE!"},"",""]
[140,9.526434542314336,{"$error":"#VALUE!"},"",""]
[150,10.206894152479643,{"$error":"#VALUE!"},"",""]
[160,10.887353762644953,{"$error":"#VALUE!"},"",""]
[170,11.567813372810264,{"$error":"#VALUE!"},"",""]
[180,12.248272982975573,{"$error":"#VALUE!"},"",""]
[190,12.928732593140882,{"$error":"#VALUE!"},"",""]
[200,13.609192203306192,{"$error":"#VALUE!"},"",""]

{"sheet":"Uncertainty Analysis","index":14,"n_rows":104,"n_cols":12,"rows_kept":104,"merged":[[0,2,0,5],[9,2,9,11],[10,2,10,11],[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],[20,1,20,5],[20,6,20,11],[21,1,21,5],[21,6,21,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],[30,0,30,2],[30,3,30,4],[30,8,30,9],[31,0,31,2],[32,0,32,2],[34,0,34,2],[34,3,34,5],[34,6,34,7],[35,0,35,2],[35,3,35,4],[35,8,35,9],[37,0,37,2],[41,0,41,2],[41,3,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[42,0,42,2],[57,10,57,11],[58,0,58,2],[58,3,58,5],[60,0,60,2],[76,0,76,2],[77,0,77,2],[78,0,78,2],[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],[91,0,91,1],[92,0,92,1]]}
["Uncertainty Analysis",{"$nulls":10},""]
[]
["Specify Procedure"]
["NISTIR 7383, SOP 21, Calibration of LPG Provers"]
[]
["Specify Equation(s)"]
["Volume at the Reference Temperature"]
[]
[null,"where"]
[null,"VX60 =","Volume of the unknown vessel at 60 ºF"]
[null,"VS60 =","Volume of the standard vessel(s) at 60 ºF"]
[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"]
["u(psig)","Uncertainty associated with the pressure gauge, rectangular distribution",{"$nulls":4},"NIST HB 105-4, paragraph 3.12.2, 5 psig or smaller graduations (used 2.5 psig for calculation), Type B evaluation"]
[]
["Uncertainty Intermediate Calculations"]
["Standard Meniscus",null,null,"Neck (mL)",null,"u(mS1) =",{"$f":"IF('Prover Data Entry'!A36=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A36,Standards_Table_B,9,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A36,Standards_Table_B,11,FALSE)/1000*drops1)","v":0},null,"Sight Glass (mL)",null,"u(mS1) =",{"$f":"IF('Prover Data Entry'!A36=\"\",0,PI()*(VLOOKUP('Prover Data Entry'!A36,Standards_Table_B,10,FALSE)/2)^2*VLOOKUP('Prover Data Entry'!A36,Standards_Table_B,11,FALSE)/1000*drops1)","v":0}]
[{"$nulls":5},"u(mS2) =",{"$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*drops2)","v":0},{"$nulls":3},"u(mS2) =",{"$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*drops2)","v":0}]
[{"$nulls":5},"u(mS3) =",{"$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*drops3)","v":0},{"$nulls":3},"u(mS3) =",{"$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*drops3)","v":0}]
[{"$nulls":5},"u(mS4) =",{"$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*drops4)","v":0},{"$nulls":3},"u(mS4) =",{"$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*drops4)","v":0}]
[]
["Unknown Meniscus",null,null,"Top Neck (mL)",null,"u(mU1) =",{"$f":"IF(Top_Neck_id=\"\",0,PI()*(Top_Neck_id/2)^2*Line_w/1000)","v":0},null,"Bottom Neck (mL)",null,"u(mU1) =",{"$f":"IF(Bottom_Neck_id=\"\",0,PI()*(Bottom_Neck_id/2)^2*Line_w/1000)","v":0}]
[]
["Standard Graduated Neck",null,null,"u(nS1) =",{"$f":"IF('Prover Data Entry'!A36=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A36,Standards_Table_B,8,FALSE)*0.5%*drops1))","v":0}]
[{"$nulls":3},"u(nS2) =",{"$f":"IF('Prover Data Entry'!A37=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A37,Standards_Table_B,8,FALSE)*0.5%*drops2))","v":0}]
[{"$nulls":3},"u(nS3) =",{"$f":"IF('Prover Data Entry'!A38=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A38,Standards_Table_B,8,FALSE)*0.5%*drops3))","v":0}]
[{"$nulls":3},"u(nS4) =",{"$f":"IF('Prover Data Entry'!A39=\"\",0,SUM(VLOOKUP('Prover Data Entry'!A39,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'!B58=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D6*(('Prover Data Entry'!C58+('Prover Data Entry'!E58/1000))*(1+((VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,6,FALSE)*5%))*(Calculations!C6-Calculations!B6))),Calculations!D6*(('Prover Data Entry'!C58+('Prover Data Entry'!E58/231))*(1+((VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,6,FALSE)+VLOOKUP('Prover Data Entry'!B58,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'!B59=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D7*(('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!C7-Calculations!B7))),Calculations!D7*(('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!C7-Calculations!B7)))))","v":0}]
[{"$nulls":3},"Drop # 3",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B60=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D8*(('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!C8-Calculations!B8))),Calculations!D8*(('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!C8-Calculations!B8)))))","v":0}]
[{"$nulls":3},"Drop # 4",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B61=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D9*(('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!C9-Calculations!B9))),Calculations!D9*(('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!C9-Calculations!B9)))))","v":0}]
[{"$nulls":3},"Drop # 5",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B62=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D10*(('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!C10-Calculations!B10))),Calculations!D10*(('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!C10-Calculations!B10)))))","v":0}]
[{"$nulls":3},"Drop # 6",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B63=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D11*(('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!C11-Calculations!B11))),Calculations!D11*(('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!C11-Calculations!B11)))))","v":0}]
[{"$nulls":3},"Drop # 7",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B64=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D12*(('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!C12-Calculations!B12))),Calculations!D12*(('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!C12-Calculations!B12)))))","v":0}]
[{"$nulls":3},"Drop # 8",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B65=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D13*(('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!C13-Calculations!B13))),Calculations!D13*(('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!C13-Calculations!B13)))))","v":0}]
[{"$nulls":3},"Drop # 9",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B66=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D14*(('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!C14-Calculations!B14))),Calculations!D14*(('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!C14-Calculations!B14)))))","v":0}]
[{"$nulls":3},"Drop # 10",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B67=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D15*(('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!C15-Calculations!B15))),Calculations!D15*(('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!C15-Calculations!B15)))))","v":0}]
[{"$nulls":3},"Drop # 11",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B68=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D16*(('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!C16-Calculations!B16))),Calculations!D16*(('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!C16-Calculations!B16)))))","v":0}]
[{"$nulls":3},"Drop # 12",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B69=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D17*(('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!C17-Calculations!B17))),Calculations!D17*(('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!C17-Calculations!B17)))))","v":0}]
[{"$nulls":3},"Drop # 13",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B70=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D18*(('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!C18-Calculations!B18))),Calculations!D18*(('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!C18-Calculations!B18)))))","v":0}]
[{"$nulls":3},"Drop # 14",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B71=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D19*(('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!C19-Calculations!B19))),Calculations!D19*(('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!C19-Calculations!B19)))))","v":0}]
[{"$nulls":3},"Drop # 15",null,"Volume [α + u(CCEα)] =",{"$f":"IF('Prover Data Entry'!B72=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D20*(('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!C20-Calculations!B20))),Calculations!D20*(('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!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+D90)*(Calculations!D24-60))))","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'!B58=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D6*(('Prover Data Entry'!C58+('Prover Data Entry'!E58/1000))*(1+(VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,6,FALSE))*((Calculations!C6+$D$91)-Calculations!B6))),Calculations!D6*(('Prover Data Entry'!C58+('Prover Data Entry'!E58/231))*(1+(VLOOKUP('Prover Data Entry'!B58,Standards_Table_B,6,FALSE))*((Calculations!C6+$D$91)-Calculations!B6)))))","v":0}]
[{"$nulls":3},"Drop # 2",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B59=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D7*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/1000))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*((Calculations!C7+$D$91)-Calculations!B7))),Calculations!D7*(('Prover Data Entry'!C59+('Prover Data Entry'!E59/231))*(1+(VLOOKUP('Prover Data Entry'!B59,Standards_Table_B,6,FALSE))*((Calculations!C7+$D$91)-Calculations!B7)))))","v":0}]
[{"$nulls":3},"Drop # 3",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B60=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D8*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/1000))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*((Calculations!C8+$D$91)-Calculations!B8))),Calculations!D8*(('Prover Data Entry'!C60+('Prover Data Entry'!E60/231))*(1+(VLOOKUP('Prover Data Entry'!B60,Standards_Table_B,6,FALSE))*((Calculations!C8+$D$91)-Calculations!B8)))))","v":0}]
[{"$nulls":3},"Drop # 4",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B61=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D9*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/1000))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*((Calculations!C9+$D$91)-Calculations!B9))),Calculations!D9*(('Prover Data Entry'!C61+('Prover Data Entry'!E61/231))*(1+(VLOOKUP('Prover Data Entry'!B61,Standards_Table_B,6,FALSE))*((Calculations!C9+$D$91)-Calculations!B9)))))","v":0}]
[{"$nulls":3},"Drop # 5",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B62=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D10*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/1000))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*((Calculations!C10+$D$91)-Calculations!B10))),Calculations!D10*(('Prover Data Entry'!C62+('Prover Data Entry'!E62/231))*(1+(VLOOKUP('Prover Data Entry'!B62,Standards_Table_B,6,FALSE))*((Calculations!C10+$D$91)-Calculations!B10)))))","v":0}]
[{"$nulls":3},"Drop # 6",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B63=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D11*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/1000))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*((Calculations!C11+$D$91)-Calculations!B11))),Calculations!D11*(('Prover Data Entry'!C63+('Prover Data Entry'!E63/231))*(1+(VLOOKUP('Prover Data Entry'!B63,Standards_Table_B,6,FALSE))*((Calculations!C11+$D$91)-Calculations!B11)))))","v":0}]
[{"$nulls":3},"Drop # 7",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B64=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D12*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/1000))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*((Calculations!C12+$D$91)-Calculations!B12))),Calculations!D12*(('Prover Data Entry'!C64+('Prover Data Entry'!E64/231))*(1+(VLOOKUP('Prover Data Entry'!B64,Standards_Table_B,6,FALSE))*((Calculations!C12+$D$91)-Calculations!B12)))))","v":0}]
[{"$nulls":3},"Drop # 8",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B65=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D13*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/1000))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*((Calculations!C13+$D$91)-Calculations!B13))),Calculations!D13*(('Prover Data Entry'!C65+('Prover Data Entry'!E65/231))*(1+(VLOOKUP('Prover Data Entry'!B65,Standards_Table_B,6,FALSE))*((Calculations!C13+$D$91)-Calculations!B13)))))","v":0}]
[{"$nulls":3},"Drop # 9",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B66=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D14*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/1000))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*((Calculations!C14+$D$91)-Calculations!B14))),Calculations!D14*(('Prover Data Entry'!C66+('Prover Data Entry'!E66/231))*(1+(VLOOKUP('Prover Data Entry'!B66,Standards_Table_B,6,FALSE))*((Calculations!C14+$D$91)-Calculations!B14)))))","v":0}]
[{"$nulls":3},"Drop # 10",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B67=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D15*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/1000))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*((Calculations!C15+$D$91)-Calculations!B15))),Calculations!D15*(('Prover Data Entry'!C67+('Prover Data Entry'!E67/231))*(1+(VLOOKUP('Prover Data Entry'!B67,Standards_Table_B,6,FALSE))*((Calculations!C15+$D$91)-Calculations!B15)))))","v":0}]
[{"$nulls":3},"Drop # 11",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B68=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D16*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/1000))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*((Calculations!C16+$D$91)-Calculations!B16))),Calculations!D16*(('Prover Data Entry'!C68+('Prover Data Entry'!E68/231))*(1+(VLOOKUP('Prover Data Entry'!B68,Standards_Table_B,6,FALSE))*((Calculations!C16+$D$91)-Calculations!B16)))))","v":0}]
[{"$nulls":3},"Drop # 12",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B69=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D17*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/1000))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*((Calculations!C17+$D$91)-Calculations!B17))),Calculations!D17*(('Prover Data Entry'!C69+('Prover Data Entry'!E69/231))*(1+(VLOOKUP('Prover Data Entry'!B69,Standards_Table_B,6,FALSE))*((Calculations!C17+$D$91)-Calculations!B17)))))","v":0}]
[{"$nulls":3},"Drop # 13",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B70=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D18*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/1000))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*((Calculations!C18+$D$91)-Calculations!B18))),Calculations!D18*(('Prover Data Entry'!C70+('Prover Data Entry'!E70/231))*(1+(VLOOKUP('Prover Data Entry'!B70,Standards_Table_B,6,FALSE))*((Calculations!C18+$D$91)-Calculations!B18)))))","v":0}]
[{"$nulls":3},"Drop # 14",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B71=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D19*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/1000))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*((Calculations!C19+$D$91)-Calculations!B19))),Calculations!D19*(('Prover Data Entry'!C71+('Prover Data Entry'!E71/231))*(1+(VLOOKUP('Prover Data Entry'!B71,Standards_Table_B,6,FALSE))*((Calculations!C19+$D$91)-Calculations!B19)))))","v":0}]
[{"$nulls":3},"Drop # 15",null,"Volume [t + u(txS)] =",{"$f":"IF('Prover Data Entry'!B72=\"\",0,IF(NomValUnit=\"Nominal Volume (L)\",Calculations!D20*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/1000))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*((Calculations!C20+$D$91)-Calculations!B20))),Calculations!D20*(('Prover Data Entry'!C72+('Prover Data Entry'!E72/231))*(1+(VLOOKUP('Prover Data Entry'!B72,Standards_Table_B,6,FALSE))*((Calculations!C20+$D$91)-Calculations!B20)))))","v":0}]
[]
["Unknown Water Temperature",{"$nulls":4},"Volume  Trial 1[t + u(txX)] =",{"$f":"IF(B=\"\",0,Calculations!E21/(Calculations!D23*(1+B*((Calculations!D24+D93)-60))))","v":0}]
[]
["Pressure Gauge",{"$nulls":4},"Pcorr @ (100psig + 2.5psig) =",{"$f":"IF(Z60_2=\"\",0,IF(Scale_Unit=\"Scale Graduations (in³)\",('Pressure Corrections'!B31-'Pressure Corrections'!B31+('Water Compressability'!$D$39*Nom_Val*231)*((100-('Pressure Corrections'!A31+2.5))/100)),IF(Scale_Unit=\"Scale Graduations (mL)\",('Pressure Corrections'!B31-'Pressure Corrections'!B31+('Water Compressability'!$D$39*Nom_Val*1000)*((100-('Pressure Corrections'!A31+2.5))/100)),('Pressure Corrections'!B31-'Pressure Corrections'!B31+('Water Compressability'!$D$39*Nom_Val)*((100-('Pressure Corrections'!A31+2.5))/100)))))","v":0},null,null,"Base Value Pcorr @ 100psig =",{"$f":"'Pressure Corrections'!C31","v":""}]
[]
["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":"A22","v":"s(p)"},{"$f":"IF(PooledSD=\"\",0,PooledSD)","v":0},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"},{"$f":"D83","v":0},"A","Normal",1,{"$f":"F83/I83","v":0},{"$f":"IF($K$94=\"\",\"\",J83^2/$K$94^2)","v":""},{"$f":"IF(J83=0,1,df)","v":1}]
["Volume Standards",null,{"$f":"A23","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(J84=0,1,ROUNDDOWN(SQRT(((_unc1*drops1/k_1)*('Prover Data Entry'!K36*drops1)^2+(_unc2*drops2/k_2)*('Prover Data Entry'!K37*drops2)^2+(_unc3*drops3/k_3)*('Prover Data Entry'!K38*drops3)^2+(_unc4*drops4/k_4)*('Prover Data Entry'!K39*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(G31:G34,L31:L34)/3785.412,SUM(G31:G34,L31:L34)/1000)","v":0},"L",0,"B","Triangular",{"$f":"SQRT(6)","v":2.449489742783178},0,"",{"$f":"IF(J85=0,1,10000)","v":1}]
["Unknown Meniscus",null,"u(mU)",{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",SUM(G36,L36)/3785.412,SUM(G36,L36)/1000)","v":0},"L",0,"B","Triangular",{"$f":"SQRT(6)","v":2.449489742783178},0,"",1]
["Std Graduated Neck",null,"u(nS)",{"$f":"SUM(E38:E41)","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(G43:G57)-K43)),0,ABS(SUM(G43:G57)-K43))","v":0},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"},{"$f":"IF(D89=0,0,D89)","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",{"$f":"IF(D90=0,0,ABS(G59-K59))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Std Water Temperature",null,"u(twS)",{"$f":"IF('Prover Data Entry'!E49=\"\",0,(StdTempU/StdTempk)*1.8)","v":0},"ºC",{"$f":"IF(D91=0,0,ABS(SUM(G61:G75)-K43))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Ukn Water Temperature",null,"u(twU)",{"$f":"IF('Prover Data Entry'!E50=\"\",0,(ProverTempU/ProverTempk)*1.8)","v":0},"ºC",{"$f":"IF(D92=0,0,ABS(G77-Calculations!E27))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
["Pressure Gauge",null,{"$f":"A28","v":"u(psig)"},{"$f":"IF(ISERROR(G79-K79),0,G79-K79)","v":0},{"$f":"IF(Scale_Unit=\"Scale Graduations (gal)\",\"gal\",IF(Scale_Unit=\"Scale Graduations (in³)\",\"in³\",IF(Scale_Unit=\"Scale Graduations (mL)\",\"mL\",\"L\")))","v":"L"},{"$f":"IF(D93=0,0,IF(Scale_Unit=\"Scale Graduations (in³)\",ABS(D93)/231,IF(Scale_Unit=\"Scale Graduations (mL)\",ABS(D93)/1000,ABS(D93))))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
[{"$nulls":9},"Combined U (uc) =",{"$f":"IF(SUM(J83:J93)=0,\"\",SQRT(SUMSQ(J83:J93)))","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(L83:L93)=1,\"\",ROUNDDOWN(K94^4/((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)+(J92^4/L92)+(J93^4/L93)),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*K94)","v":""},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"}]
[{"$nulls":9},"NVLAP Effective Degrees of Freedom (veff) =",{"$f":"IF(G93=\"\",\"\",IF(BestU=\"\",0,BestUdf))","v":0}]
[{"$nulls":9},"NVLAP k factor =",{"$f":"IF(G93=\"\",\"\",IF(BestU=\"\",0,BestUk))","v":0}]
[{"$nulls":9},"NVLAP U =",{"$f":"IF(G93=\"\",\"\",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>K100,Veff,K98))","v":""}]
[{"$nulls":9},"Final k factor =",{"$f":"IF(k=\"\",\"\",IF(MeasuredU>K100,k,K99))","v":""}]
[{"$nulls":9},"Final U (uc*k) =",{"$f":"IF(MeasuredU=\"\",\"\",IF(MeasuredU>K100,MeasuredU,K100))","v":""},{"$f":"IF(NomValUnit=\"Nominal Volume (gal)\",\"gal\",\"L\")","v":"L"}]
[{"$f":"\"Values in \"&L103","v":"Values in L"}]

{"sheet":"Tables & Lists","index":15,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[2,0,2,1]]}
["Tables & Lists",null,null,{"$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,"Scale Graduations (in³)"]
["Steel, Pressure Vessel, Low Carbon",1.6e-05,null,"Scale Graduations (gal)"]
["Steel, Prover, Low Carbon",1.86e-05,null,"Scale Graduations (L)"]
["Steel, Stainless",2.65E-5,null,"Scale Graduations (mL)"]
[]
[{"$nulls":3},"Range Mean from CC (in³)"]
[{"$nulls":3},"Range Mean from CC (gal)"]
[{"$nulls":3},"Range Mean from CC (L)"]
[{"$nulls":3},"Range Mean from CC (mL)"]
[]
[{"$nulls":3},"Yes"]
[{"$nulls":3},"No"]
[]
[{"$nulls":3},"Nominal Volume (gal)"]
[{"$nulls":3},"Nominal Volume (L)"]