{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Software Technical Assessment","Documentation","SOP 33","Instructions","Report Pages 1-3","Inspection Checklist","Control Data","Data Entry","SOP 4 Observations","SOP 8 Observations","Calculations","SOP 8 Uncertainty Analysis","SOP 4 Uncertainty Analysis","CIPM Air Density","Tables and Lists"],"not_rendered":{"charts":2,"images":6,"external_links":4,"defined_names":159,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Software Technical Assessment","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"merged":[[5,0,17,0],[18,0,21,0],[22,0,25,0],[26,0,28,0],[29,0,34,0],[35,0,38,0],[39,0,40,0],[43,0,48,0],[56,4,56,5]]}
["Software Technical Assessment"]
[]
["Software Description","WAMRF-010 (Rev. 10), Calibration of Weight Carts, SOP 33","Approval Date","2015-12-23"]
["Assessed By","Dan Wright","Approved By","Dan Wright"]
["Codes","Assessment","Pass/Fail","Evidence"]
["A. Software Inspection","Spreadsheet is clear and makes sense","Pass","All worksheet are appropriately named and easy to understand"]
[null,"There are instructions for use ","Pass","Instructions worksheet"]
[null,"Instructions and data input appear on the visible portion of the first worksheet","Pass","The workbook opens to the instruction worksheet"]
[null,"Data-entry fields are labeled and color coded (it is recommended to avoid red and green)","Pass","Light yellow for blank, light blue for non-blank cells"]
[null,"The Standard Operating Procedure (SOP) used is clearly specified","Pass","Specified on Uncertainty Analysis worksheet"]
[null,"The number of digits to be rounded to is specified","Pass","Mass corrections and uncertainties are rounded according to NISTIR 6969, GLP 9"]
[null,"The user is warned/notified whenever data-entry fields are left blank","Pass","In data validation cells only"]
[null,"Data-entry fields are “blank” when opened, preventing loss of old data and ensuring that old data is not used with the current calculations","Pass","Data entry fields on the workbook template are blank. Instructions tell user to break links before saving after a calibration is performed"]
[null,"The software opens at the right location within the file","Pass","Opens to the Instruction worksheet"]
[null,"Unused fields/cells are locked","Pass","Unused cells are locked and worksheets are protected"]
[null,"Rows/columns that the operator need not see are hidden","N/A","No hidden cells or worksheets"]
[null,"Unused sheets are removed","Pass","No unused worksheets"]
[null,"Worksheets are named appropriately","Pass","Worksheets are appropriately named"]
["B. Mathematical Specification","The correct SOP is used","Pass","SOP 33 is embedded"]
[null,"The formulae and methods chosen from that SOP are specified","Pass","Formulae are show in the SOP 33 and Uncertainty Analysis worksheets"]
[null,"Sources and references for formulae are specified","Pass","As specified in SOP 33"]
[null,"The chosen SOP, its methods, and its formulae, are appropriate to the level of precision/uncertainty","Pass","For Weight Cart Mass Echelon III 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","No issues encountered"]
[null,"Calculations, when tested using standard data or reference test data, show appropriate accuracy","Pass","Tested using data set"]
[null,"Rounding is done at the appropriate locations in the file","Pass","Specified on Calculations worksheet"]
["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","Pass","Hand calculations match"]
["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":41,"n_cols":3,"rows_kept":41}
["Documentation",null,{"$f":"IF(ISBLANK(RptNo),\"\",\"Report Number: \"&RptNo)","v":""}]
["Date","Description","Initials"]
["2012-08-15","This spreadsheet was developed by Dan Wright, WA Dept of Agriculture. This workbook follows the procedure documented in NISTIR 6969, SOP 33.","DAW"]
["2012-08-15","Validated ranges.","DAW"]
["2012-08-15","Validated workbook, file name \"WA2012-08-15 WAMRF-010 (Rev. 03), SOP 33 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2013-02-17","Removed GLP Rounding macros","DAW"]
["2013-02-17","Entered new rounding technique and corrected formulas","DAW"]
["2013-02-17","Validated range names.","DAW"]
["2013-02-17","Validated workbook, file name \"WA2013-02-17 WAMRF-010 (Rev. 04), SOP 33 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2013-07-29","Updated input for and added the Welch-Satterthwaite formula for effective degrees of freedom.","DAW"]
["2013-07-29","Revised all ISBLANK() statements.","DAW"]
["2013-07-29","Modified Uncertainty worksheet","DAW"]
["2013-07-29","Validated range names and spell checked.","DAW"]
["2013-07-29","Validated workbook, file name \"WA2013-07-29 WAMRF-010 (Rev. 05), SOP 33 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2013-08-28","Fixed standard uncertainty formulas in cells D39 & D40 on the Uncertainty Analysis worksheet","DAW"]
["2013-08-28","Fixed % Contibution formulas in cells I38 to I41 on the Uncertainty Analysis worksheet","DAW"]
["2013-08-28","Fixed Final U formula in cell I51 on the Uncertainty Analysis worksheet","DAW"]
["2013-08-28","Changed mg to g in the chart legend on the Uncertainty Analysis worksheet","DAW"]
["2013-08-28","Validated range names and spell checked.","DAW"]
["2013-08-28","Validated workbook, file name \"WA2013-08-28 WAMRF-010 (Rev. 06), SOP 33 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2013-11-22","Changed Start to Finish in cell A110 on Data Entry sheet","DAW"]
["2014-04-10","Referenced As Left Conventional Mass and Conventional Mass Correction to the As Found value when no adjustment is required on the Calculations worksheet.","DAW"]
["2014-10-29","Changed statistical df from 100 to 10000.","DAW"]
["2014-11-04","Embedded 2014 edition of SOP 33."]
["2014-11-04","Added note 5 in Instructions concerning dependent and independent standards."]
["2014-11-04","Created an evaluation of the standard deviation vs the balance resolution per NISTIR 6969, SOP 4, paragraph 5.2.1.","DAW"]
["2014-11-06","Moved uncertainty evaluation to Data Entry worksheet and added Precision Test.","DAW"]
["2014-11-06","CIPM_Pa was defaulted to nominal (0.0012 g/cm³) so the uncertainty evaluation calculate before measurement are made.","DAW"]
["2014-11-06","Validated range names.","DAW"]
["2014-11-06","Validated workbook, file name \"WA2014-11-06 WAMRF-010 (Rev. 07), SOP 33 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-10-01","Based the Measurement Assurance Evaluation on the Calculations worksheet on SOP 17.","DAW"]
["2015-10-01","Validated range names.","DAW"]
["2015-10-01","Validated workbook, file name \"WA2015-10-01 WAMRF-010 (Rev. 08), SOP 33 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-010 (Rev. 09), SOP 33 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-23","Corrected the formulas in J76, J82, J88, J99, J105 & J 111 of the Data Entry worksheet from 'sp*2' to 'MAX(sp*2,10*Resolution)'.","DAW"]
["2015-12-23","Modified so user can select measurement sequence of SXXS or XSSX.","DAW"]
["2015-12-23","Added an option to use either a modified SOP 4 or SOP 8 procedure, created separate observation spreadsheets and added an uncertainty analysis for the SOP 8 procedure.","DAW"]
["2015-12-23","Validated range names.","DAW"]
["2015-12-23","Validated workbook, file name \"WA2015-12-23 WAMRF-010 (Rev. 10), SOP 33 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 33","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Instructions","index":3,"n_rows":125,"n_cols":2,"rows_kept":125,"merged":[[0,0,0,1],[8,0,8,1]]}
["Instructions"]
["No.","Description"]
[1,"Validate this workbook after any changes."]
[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,"This workbook has links to the Standards, Customer List, and Mass Tolerances workbooks"]
[4,"Break links after calibration to lock in the data from linked workbooks."]
[5,"The calibration of the standards are treated as dependent in the Data Entry worksheet. If you are using independent calibrated standards you need to change the formula in cell F56 on the Data Entry worksheet to a root sum square calculation. The same for cell F60 for the sensitivity weights."]
[]
["Range Names"]
["Name","Range"]
["Balance","='Data Entry'!$E$16"]
["BalID","='Data Entry'!$C$16"]
["BalUnit","='Data Entry'!$J$16"]
["Best_df","='Data Entry'!$H$19"]
["Best_k","='Data Entry'!$J$19"]
["Best_U","='Data Entry'!$E$19"]
["Cal_Date","='Data Entry'!$C$21"]
["CIPM_Pa","='CIPM Air Density'!$D$7"]
["CMx","=Calculations!$H$9"]
["Condition","='Data Entry'!$C$14"]
["Cs","='Data Entry'!$D$56"]
["Csw","='Data Entry'!$D$60"]
["CustomerID","='Data Entry'!$J$4"]
["Cx","=Calculations!$H$10"]
["Description","='Data Entry'!$C$10"]
["Final_k_SOP4","='SOP 4 Uncertainty Analysis'!$I$50"]
["Final_k_SOP8","='SOP 8 Uncertainty Analysis'!$I$55"]
["Final_U_SOP4","='SOP 4 Uncertainty Analysis'!$I$51"]
["Final_U_SOP8","='SOP 8 Uncertainty Analysis'!$I$56"]
["Final_Veff_SOP4","='SOP 4 Uncertainty Analysis'!$I$49"]
["Final_Veff_SOP8","='SOP 8 Uncertainty Analysis'!$I$54"]
["ID","='Data Entry'!$C$13"]
["Interval","='Data Entry'!$J$20"]
["IntervalQ","='Data Entry'!$F$20"]
["JobNo","='Data Entry'!$I$12"]
["k_S","='Data Entry'!$H$56"]
["k_sw","='Data Entry'!$H$60"]
["Mfg","='Data Entry'!$C$11"]
["Mfg_Date","='Data Entry'!$I$11"]
["Nx","='Data Entry'!$I$13"]
["P","='CIPM Air Density'!$D$4"]
["P_corr","='Data Entry'!$D$65"]
["PO_No","='Data Entry'!$H$5"]
["POC","='Data Entry'!$H$6"]
["POC_Phone","='Data Entry'!$H$7"]
["Print_Titles","=Instructions!$7:$8"]
["Procedure","='Data Entry'!$H$18"]
["Ps","='Data Entry'!$J$56"]
["Psw","='Data Entry'!$J$60"]
["Px","='Data Entry'!$I$14"]
["Receive_Date","='Data Entry'!$I$10"]
["Resolution","='Data Entry'!$H$16"]
["RptNo","='Data Entry'!$H$1"]
["S","='Data Entry'!$B$56"]
["S_df","='Data Entry'!$I$56"]
["SN","='Data Entry'!$C$12"]
["SOP4_P1","='SOP 4 Observations'!$G$22"]
["SOP4_P2","='SOP 4 Observations'!$G$38"]
["SOP4_t1","='SOP 4 Observations'!$E$22"]
["SOP4_t2","='SOP 4 Observations'!$E$38"]
["SOP4_U1","='SOP 4 Observations'!$I$22"]
["SOP4_U2","='SOP 4 Observations'!$I$38"]
["SOP4DubSub1_O1","='SOP 4 Observations'!$G$24"]
["SOP4DubSub1_O2","='SOP 4 Observations'!$G$25"]
["SOP4DubSub1_O3","='SOP 4 Observations'!$G$26"]
["SOP4DubSub1_O4","='SOP 4 Observations'!$G$27"]
["SOP4DubSub2_O1","='SOP 4 Observations'!$G$29"]
["SOP4DubSub2_O2","='SOP 4 Observations'!$G$30"]
["SOP4DubSub2_O3","='SOP 4 Observations'!$G$31"]
["SOP4DubSub2_O4","='SOP 4 Observations'!$G$32"]
["SOP4DubSub3_O1","='SOP 4 Observations'!$G$34"]
["SOP4DubSub3_O2","='SOP 4 Observations'!$G$35"]
["SOP4DubSub3_O3","='SOP 4 Observations'!$G$36"]
["SOP4DubSub3_O4","='SOP 4 Observations'!$G$37"]
["SOP4InitObs_1","='SOP 4 Observations'!$G$12"]
["SOP4InitObs_2","='SOP 4 Observations'!$G$13"]
["SOP4InitObs_3","='SOP 4 Observations'!$G$14"]
["SOP4InitObs_4","='SOP 4 Observations'!$G$15"]
["SOP4SealNo","='SOP 4 Observations'!$I$19"]
["SOP8_O1","='SOP 8 Observations'!$G$25"]
["SOP8_O2","='SOP 8 Observations'!$G$26"]
["SOP8_O3","='SOP 8 Observations'!$G$27"]
["SOP8_O4","='SOP 8 Observations'!$G$28"]
["SOP8_O5","='SOP 8 Observations'!$G$30"]
["SOP8_O6","='SOP 8 Observations'!$G$32"]
["SOP8_O7","='SOP 8 Observations'!$G$33"]
["SOP8_P1","='SOP 8 Observations'!$G$23"]
["SOP8_P2","='SOP 8 Observations'!$G$34"]
["SOP8_t1","='SOP 8 Observations'!$E$23"]
["SOP8_t2","='SOP 8 Observations'!$E$34"]
["SOP8_U1","='SOP 8 Observations'!$I$23"]
["SOP8_U2","='SOP 8 Observations'!$I$34"]
["SOP8InitObs_O1","='SOP 8 Observations'!$G$12"]
["SOP8InitObs_O2","='SOP 8 Observations'!$G$13"]
["SOP8InitObs_O3","='SOP 8 Observations'!$G$14"]
["SOP8InitObs_O4","='SOP 8 Observations'!$G$15"]
["SOP8InitObs_O5","='SOP 8 Observations'!$G$16"]
["SOP8SealNo","='SOP 8 Observations'!$I$20"]
["sp","='Data Entry'!$F$17"]
["sp_df","='Data Entry'!$J$17"]
["sp_unit","='Data Entry'!$A$17"]
["StUnit","='Data Entry'!$A$17"]
["sw","='Data Entry'!$B$60"]
["sw_df","='Data Entry'!$I$60"]
["t","='CIPM Air Density'!$D$5"]
["t_corr","='Data Entry'!$D$64"]
["Tech","='Data Entry'!$F$21"]
["Tech_Int","='Data Entry'!$J$21"]
["Tol","='Tables and Lists'!$A$4:$B$8"]
["Tol_Class","='Data Entry'!$C$15"]
["Tol_List","='Tables and Lists'!$A$4:$A$22"]
["Tolerance","='Data Entry'!$I$15"]
["U","='CIPM Air Density'!$D$6"]
["U_corr","='Data Entry'!$D$66"]
["U_P","='Data Entry'!$F$65"]
["U_P_k","='Data Entry'!$H$65"]
["U_t","='Data Entry'!$F$64"]
["U_t_k","='Data Entry'!$H$64"]
["U_U","='Data Entry'!$F$66"]
["U_U_k","='Data Entry'!$H$66"]
["UCL","=Calculations!$D$20"]
["Us","='Data Entry'!$F$56"]
["Usw","='Data Entry'!$F$60"]
["WL","=Calculations!$D$21"]
["Xnom","='Data Entry'!$F$13"]

{"sheet":"Report Pages 1-3","index":4,"n_rows":89,"n_cols":7,"rows_kept":89,"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],[61,0,61,6],[63,0,63,6],[65,0,65,6],[69,0,69,2],[69,3,69,4],[69,5,69,6],[70,0,70,2],[70,5,70,6],[71,0,71,6],[75,0,75,6],[76,0,76,6],[77,0,77,6],[78,0,78,6],[79,0,79,6],[80,0,80,6],[83,0,83,6],[84,0,84,6],[85,0,85,6]]}
{"$rows_empty":10}
[{"$nulls":3},"REPORT OF CALIBRATION"]
[]
[{"$nulls":3},"Issued To:"]
[{"$nulls":3},{"$f":"IF('Data Entry'!A4=\"\",\"\",'Data Entry'!A4)","v":""}]
[{"$nulls":3},{"$f":"IF('Data Entry'!A5=\"\",\"\",'Data Entry'!A5)","v":""}]
[{"$nulls":3},{"$f":"IF('Data Entry'!A6=\"\",\"\",'Data Entry'!A6)","v":""}]
[{"$nulls":3},{"$f":"IF('Data Entry'!A7=\"\",\"\",'Data Entry'!A7)","v":""}]
[]
[{"$nulls":3},"Point of Contact:"]
[{"$nulls":3},{"$f":"IF(POC=\"\",\"\",POC)","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=\"\",\"\",Nx&\" lb \"&Description)","v":" lb Weight Cart"},null,null,"Date Received:",{"$f":"IF(Receive_Date=\"\",\"\",TEXT(Receive_Date,\"mmmm d, yyyy\"))","v":""}]
["Serial Number:",{"$f":"IF(SN=\"\",\"\",SN)","v":""},null,null,"Model Number:",{"$f":"IF(ID=\"\",\"\",ID)","v":""}]
["Manufacture:",{"$f":"IF(Mfg=\"\",\"\",Mfg)","v":""},null,null,"Weight Cart Manufacture Date:",{"$f":"IF(Mfg_Date=\"\",\"\",TEXT(Mfg_Date,\"mmmm d, yyyy\"))","v":""}]
["Condition:",{"$f":"IF(Condition=\"\",\"\",Condition)","v":"See Inspection Checklist"},null,null,"Tolerance Specification:",{"$f":"IF(Tol_Class=\"\",\"\",Tol_Class)","v":"NIST HB 105-8"}]
[]
["Calibration Information"]
["Job Order #:",{"$f":"IF(JobNo=\"\",\"\",JobNo)","v":""},null,null,"Temperature:",{"$f":"IF(t=\"\",\"\",FIXED(t,1)&\" ºC\")","v":""}]
["Metrologist:",{"$f":"IF(Tech=\"\",\"\",Tech)","v":""},null,null,"Pressure:",{"$f":"IF(P=\"\",\"\",FIXED(P,1)&\" mm Hg\")","v":""}]
["Procedure:","NIST IR 6969, SOP 33",null,null,"Humidity:",{"$f":"IF(U=\"\",\"\",FIXED(U,1)&\" % RH\")","v":""}]
[]
["Laboratory Reference Standards Used"]
["Description",null,"Serial Number","Cert. Number",null,"Cal Date","Cal Due"]
[{"$f":"IF('Data Entry'!A45=\"\",\"\",'Data Entry'!A45)","v":""},null,{"$f":"IF('Data Entry'!D45=\"\",\"\",'Data Entry'!D45)","v":""},{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""},null,{"$f":"IF('Data Entry'!H45=\"\",\"\",'Data Entry'!H45)","v":""},{"$f":"IF('Data Entry'!I45=\"\",\"\",'Data Entry'!I45)","v":""}]
[{"$f":"IF('Data Entry'!A46=\"\",\"\",'Data Entry'!A46)","v":""},null,{"$f":"IF('Data Entry'!D46=\"\",\"\",'Data Entry'!D46)","v":""},{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""},null,{"$f":"IF('Data Entry'!H46=\"\",\"\",'Data Entry'!H46)","v":""},{"$f":"IF('Data Entry'!I46=\"\",\"\",'Data Entry'!I46)","v":""}]
[]
["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 mass is the kilogram (kg) (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 reported for the standard, uncertainties associated with the measurement process,  uncertainties for any observed deviations from reference values which are less than surveillance limits, and other uncertainties associated with the particular artifact (i.e., material density, air buoyancy corrections, etc.). 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."]
["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."]
["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"]
["pound (avoirdupois) (lb)",null,null,"to kilogram (kg)",null,"4.535 923 7 E-01"]
["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 weight cart listed above has been adjusted as close to nominal as possible and left within the tolerances for the specification stated above, except as noted. An artifact is considered in-tolerance when the correction plus the measurement uncertainty is equal to or less than the specified tolerance."]
[{"$f":"\"●  The adjusting cavity was sealed after adjustment with Seal Number \"&IF(Procedure=\"SOP 8\",SOP8SealNo,SOP4SealNo)","v":"●  The adjusting cavity was sealed after adjustment with Seal Number "}]
["●  All corrections stated in this report correlate to a “Conventional Mass” (CM), also known as ‘apparent mass”, scale verses 8.0 g/cm³ reference mass density and an air density of 1.2 mg/cm3 at 20 ºC."]
["●  The results listed in this report relate only to the artifacts described and extent of calibrations performed."]
[]
["Inspection Checklist"]
["The weight cart was allowed to come to thermal and environmental equilibrium in the laboratory prior to calibration. The weight cart was adjusted (as needed and noted above) as close as possible to zero error. All fluid levels stated in the Inspection Checklist on page 4 were adjusted as close as possible to the full/reference marks and sealed. Liquid levels must be maintained as close to reference levels as possible during use."]
["The attached Inspection Checklist is an integral component of this Calibration Report and a copy\nmust be maintained with the cart and reviewed prior to use."]
["Any maintenance, repairs, replacement of parts, or damage to weight cart or its components will likely result in an out-of-tolerance condition; therefore, maintenance or replacement of components such as batteries, tires, filters, or other items listed on the checklist, require calibration of the weight cart prior to subsequent use."]
["Calibration Results"]
["Nominal Mass (lb)","Conventional Mass (lb)","Conventional Mass Correction (lb)","Uncertainty ± (lb)","k-factor","Degrees of Freedom","NIST HB 105-8 Tolerance ± (lb)"]
[{"$f":"IF(Nx=\"\",\"\",Nx)","v":""},{"$f":"IF(Nx=\"\",\"\",Calculations!E27)","v":""},{"$f":"IF(Nx=\"\",\"\",Calculations!E28)","v":""},{"$f":"IF(Nx=\"\",\"\",Calculations!E31)","v":""},{"$f":"IF(Nx=\"\",\"\",Calculations!E30)","v":""},{"$f":"IF(Nx=\"\",\"\",Calculations!E29)","v":""},{"$f":"IF(Nx=\"\",\"\",Calculations!E32)","v":""}]

{"sheet":"Inspection Checklist","index":5,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,0,0,6],[7,0,7,6],[8,0,8,6],[12,0,12,6],[13,0,13,6],[16,0,16,6],[17,0,17,6],[27,0,27,6],[28,0,28,6],[29,0,29,6],[30,0,30,6],[31,0,31,6],[32,0,32,6]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":5},{"$f":"IF(Cal_Date=\"\",\"Inspection Date:\",\"Inspection Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Inspection Date:"}]
["Inspection Checklist for Weight Cart"]
[]
[null,"Manufacturer:",{"$f":"IF(Mfg=\"\",\"\",Mfg)","v":""},null,null,"Date of Manufacture:",{"$f":"IF(Mfg_Date=\"\",\"\",Mfg_Date)","v":""}]
[null,"Model Number:",{"$f":"IF(ID=\"\",\"\",ID)","v":""},null,null,"ID/SN Number:",{"$f":"IF(SN=\"\",\"\",SN)","v":""}]
[null,"Nominal Mass of Weight Cart:",{"$f":"IF(Nx=\"\",\"\",Nx)&\" lb\"","v":" lb"},null,null,"Nominal Mass Suitably Marked:",{"$f":"IF('Data Entry'!I29=\"\",\"\",'Data Entry'!I29)","v":""}]
[]
[]
["Power Source:",{"$f":"IF('Data Entry'!C24=\"\",\"\",'Data Entry'!C24)","v":""},null,null,"Power Source Reference Level:",{"$f":"IF('Data Entry'!H24=\"\",\"\",'Data Entry'!H24)","v":""}]
["Engine Oil:",{"$f":"IF('Data Entry'!C25=\"\",\"\",'Data Entry'!C25)","v":""},null,null,"Engine Oil Reference Mark:",{"$f":"IF('Data Entry'!H25=\"\",\"\",'Data Entry'!H25)","v":""}]
["Hydraulic Oil:",{"$f":"IF('Data Entry'!C26=\"\",\"\",'Data Entry'!C26)","v":""},null,null,"Hydraulic Oil Reference Mark:",{"$f":"IF('Data Entry'!H26=\"\",\"\",'Data Entry'!H26)","v":""}]
[]
[]
["No. of Axles:",{"$f":"IF('Data Entry'!C27=\"\",\"\",'Data Entry'!C27)","v":""},"No. of Tires:",{"$f":"IF('Data Entry'!F27=\"\",\"\",'Data Entry'!F27)","v":""},null,"Sealed  Wheel Bearings?:",{"$f":"IF('Data Entry'!J27=\"\",\"\",'Data Entry'!J27)","v":""}]
["Tire Sizes:","Front:",{"$f":"IF('Data Entry'!C28=\"\",\"\",'Data Entry'!C28)","v":""},"Middle:",{"$f":"IF('Data Entry'!F28=\"\",\"\",'Data Entry'!F28)","v":""},"Rear:",{"$f":"IF('Data Entry'!I28=\"\",\"\",'Data Entry'!I28)","v":""}]
[]
[]
[{"$nulls":3},"Fluid drain tubes extend beyond the body of the cart:",{"$f":"IF('Data Entry'!I30=\"\",\"\",'Data Entry'!I30)","v":""}]
[{"$nulls":3},"Drain holes present in locations where water may accumulate:",{"$f":"IF('Data Entry'!I31=\"\",\"\",'Data Entry'!I31)","v":""}]
[{"$nulls":3},"Weight restraint railing permanently fixed and solid:",{"$f":"IF('Data Entry'!I32=\"\",\"\",'Data Entry'!I32)","v":""}]
[{"$nulls":3},"Adjusting Cavity Accessible:",{"$f":"IF('Data Entry'!D33=\"\",\"\",'Data Entry'!D33)","v":""}]
[{"$nulls":3},"Adjusting Cavity Sealed:",{"$f":"IF('Data Entry'!F33=\"\",\"\",'Data Entry'!F33)","v":""}]
[{"$nulls":3},"Adjusting cavity approximate capacity:",{"$f":"IF('Data Entry'!J33=\"\",\"\",'Data Entry'!J33)&\" lb\"","v":" lb"}]
[{"$nulls":3},"Service brakes functioning properly:",{"$f":"IF('Data Entry'!I34=\"\",\"\",'Data Entry'!I34)","v":""}]
[{"$nulls":3},"Parking brakes functioning properly:",{"$f":"IF('Data Entry'!I35=\"\",\"\",'Data Entry'!I35)","v":""}]
[{"$nulls":3},"Remote control functioning properly:",{"$f":"IF('Data Entry'!I36=\"\",\"\",'Data Entry'!I36)","v":""}]
[]
[]
["General condition at time of calibration (note any accumulated dirt/debris, damage, loose parts, or evidence of tampering or unauthorized entry of seals)."]
[{"$f":"IF('Data Entry'!A38=\"\",\"\",'Data Entry'!A38)","v":""}]
["List and report any repair and maintenance performed, parts replaced, etc., Leaks repaired, new battery, carburetor, exhaust system, wheels changed, welding performed, etc.. Include any comments or changes since the last calibration."]
[{"$f":"IF('Data Entry'!A40=\"\",\"\",'Data Entry'!A40)","v":""}]

{"sheet":"Control Data","index":6,"n_rows":3,"n_cols":12,"rows_kept":3}
["Control Chart Information",{"$nulls":10},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Technician Initials","Date","Report Number",{"$f":"\" Cx vs 8.0 (MAX)\n(g)\"","v":" Cx vs 8.0 (MAX)\n(g)"},{"$f":"\"Cx vs 8.0 (MIN)\n(g)\"","v":"Cx vs 8.0 (MIN)\n(g)"},"Balance ID","Start Air Temperature (ºC)","Finish Air Temperature (ºC)","Start Pressure (g/cm³)","Finish Pressure (g/cm³)","Start Humidity\n(% RH)","Finish Humidity\n(% RH)"]
[{"$f":"IF(Tech_Int=\"\",\"\",Tech_Int)","v":""},{"$f":"IF(Cal_Date=\"\",\"\",Cal_Date)","v":""},{"$f":"IF(RptNo=\"\",\"\",RptNo&\" AF\")","v":""},{"$f":"IF(Nx=\"\",\"\",(MAX(Calculations!H5:I7)-Nx)*453.59237)","v":""},{"$f":"IF(Nx=\"\",\"\",(MIN(Calculations!H5:I7)-Nx)*453.59237)","v":""},{"$f":"IF(BalID=\"\",\"\",BalID)","v":""},{"$f":"IF(SOP4_t1=\"\",\"\",SOP4_t1)","v":""},{"$f":"IF(SOP4_t2=\"\",\"\",SOP4_t2)","v":""},{"$f":"IF(SOP4_P1=\"\",\"\",SOP4_P1)","v":""},{"$f":"IF(SOP4_P2=\"\",\"\",SOP4_P2)","v":""},{"$f":"IF(SOP4_U1=\"\",\"\",SOP4_U1)","v":""},{"$f":"IF(SOP4_U2=\"\",\"\",SOP4_U2)","v":""}]

{"sheet":"Data Entry","index":7,"n_rows":66,"n_cols":10,"rows_kept":66,"merged":[[0,7,0,9],[3,0,3,5],[3,6,3,8],[4,0,4,5],[4,7,4,9],[5,0,5,5],[5,7,5,9],[6,0,6,5],[6,7,6,9],[9,0,9,1],[9,2,9,4],[9,5,9,7],[9,8,9,9],[10,0,10,1],[10,2,10,4],[10,5,10,7],[10,8,10,9],[11,0,11,1],[11,2,11,4],[11,5,11,7],[11,8,11,9],[12,0,12,1],[12,2,12,4],[12,5,12,7],[12,8,12,9],[13,0,13,1],[13,2,13,4],[13,5,13,7],[13,8,13,9],[14,0,14,1],[14,2,14,4],[14,5,14,7],[14,8,14,9],[15,0,15,1],[15,4,15,5],[16,0,16,4],[16,5,16,6],[16,7,16,8],[17,0,17,6],[17,7,17,9],[18,0,18,3],[18,4,18,5],[19,0,19,4],[19,6,19,8],[20,0,20,1],[20,2,20,3],[20,5,20,7],[23,0,23,1],[23,2,23,3],[23,4,23,6],[23,7,23,9],[24,0,24,1],[24,2,24,3],[24,4,24,6],[24,7,24,9],[25,0,25,1],[25,2,25,3],[25,4,25,6],[25,7,25,9],[26,0,26,1],[26,3,26,4],[26,6,26,8],[27,2,27,3],[27,5,27,6],[27,8,27,9],[28,0,28,7],[28,8,28,9],[29,0,29,7],[29,8,29,9],[30,0,30,7],[30,8,30,9],[31,0,31,7],[31,8,31,9],[32,0,32,1],[32,6,32,8],[33,0,33,7],[33,8,33,9],[34,0,34,7],[34,8,34,9],[35,0,35,7],[35,8,35,9],[36,0,36,9],[37,0,37,9],[38,0,38,9],[39,0,39,9],[42,0,42,8],[43,0,43,2],[43,3,43,4],[43,5,43,6],[44,0,44,2],[44,3,44,4],[44,5,44,6],[45,0,45,2],[45,3,45,4],[45,5,45,6],[49,1,49,2],[49,3,49,4],[49,5,49,6],[50,1,50,2],[50,3,50,4],[50,5,50,6],[51,1,51,2],[51,3,51,4],[51,5,51,6],[52,1,52,2],[52,3,52,4],[52,5,52,6],[53,1,53,2],[53,3,53,4],[53,5,53,6],[54,1,54,2],[54,3,54,4],[54,5,54,6],[55,1,55,2],[55,3,55,4],[55,5,55,6],[57,1,57,2],[57,3,57,4],[57,5,57,6],[58,1,58,2],[58,3,58,4],[58,5,58,6],[59,1,59,2],[59,3,59,4],[59,5,59,6],[62,0,62,1],[62,3,62,4],[62,5,62,6],[63,0,63,1],[63,3,63,4],[63,5,63,6],[64,0,64,1],[64,3,64,4],[64,5,64,6],[65,0,65,1],[65,3,65,4],[65,5,65,6]]}
["Data Entry",{"$nulls":5},"Report Number:"]
[]
["Customer Information"]
[{"$nulls":6},"Customer ID"]
[{"$nulls":6},"PO#"]
[{"$nulls":6},"POC"]
[{"$nulls":6},"Phone"]
[]
["Calibration Item & Measurement Information"]
["Item Description",null,"Weight Cart",null,null,"Date Received"]
["Manufacture",{"$nulls":4},"Weight Cart Manufacture Date"]
["Serial Number",{"$nulls":4},"Job Order Number"]
["ID/Model Number",{"$nulls":4},"Nominal Value (avdp. pound)"]
["Artifact Condition",null,"See Inspection Checklist",null,null,"Assumed Density (g/cm³)"]
["Tol. Specification",null,"NIST HB 105-8",null,null,"Tolerance (± lb)",null,null,{"$f":"IF(Nx=\"\",\"\",VLOOKUP(Nx,Tol,2))","v":""}]
["Balance ID",null,null,"Balance",null,null,"Resolution",null,"Bal Unit"]
["Process Standard Deviation for Balance (g)",{"$nulls":6},"Degrees of Freedom"]
["Measurement Procedure"]
[{"$f":"IF(BalUnit=\"\",\"Accredited Unc (e.g, NVLAP,A2LA, etc.)\",\"Accredited Unc (e.g, NVLAP,A2LA, etc.) (g)\")","v":"Accredited Unc (e.g, NVLAP,A2LA, etc.)"},{"$nulls":5},"df",null,"k factor"]
["Was a Calibration Interval Requested or is one Required?",{"$nulls":5},"What is the Interval (months)?"]
["Calibration Date",{"$nulls":3},"Technician",{"$nulls":3},"Initials"]
[]
["Inspection Checklist Information"]
["Power Source",{"$nulls":3},"Power Source Reference Level"]
["Engine Oil",{"$nulls":3},"Engine Oil Reference Mark"]
["Hydraulic Oil",{"$nulls":3},"Hydraulic Oil Reference Mark"]
["Number of Axles",null,null,"Number of Tires",null,null,"Sealed Wheel Bearings"]
["Tire Size:","Front",null,null,"Middle",null,null,"Rear"]
["Nominal mass of the weight cart is suitably marked"]
["Fluid drain tubes extend beyond the body of the cart"]
["Drain holes are present in locations where water may accumulate"]
["Weight restraint railing is permanently fixed and solid"]
["Adjusting cavity is:",null," Accessible",null,"Sealed",null,"Approximate capacity (lb)"]
["Service brakes are functioning properly"]
["Parking brakes are functioning properly"]
["Remote control is functioning properly"]
["General condition at time of calibration (note any accumulated dirt/debris, damage, loose parts, or evidence of tampering or unauthorized entry of seals)"]
[]
["List and report any repair and maintenance performed since the last calibration (i.e., parts replaced, leaks repaired, wheels changed, welding performed, etc.)"]
[]
[]
["Standards Used"]
["Note: If the 'Calibration Due' date turns RED the standard calibration is void, calibrate before use."]
["Description",null,null,"Serial Number",null,"Report Number",null,"Calibration Date","Calibration Due"]
[]
[]
[]
["Mass Standard(s) Data"]
["Enter information for the reference weight(s) (S)"]
["ID Code(s) for S","Nominal Mass (g)",null,"CM Correction (g)",null,"Us (g)",null,"k factor","Degrees of Freedom (df)","Density (g/cm³)"]
["S1"]
["S2"]
["S3"]
["S4"]
["S5"]
["S =",{"$f":"IF(B51=\"\",\"\",SUM(B51:B55))","v":""},null,{"$f":"IF(B51=\"\",\"\",SUM(D51:D55))","v":""},null,{"$f":"IF(B51=\"\",\"\",IF(AND(ISNUMBER(B51),B52=\"\"),F51/H51,IF(AND(ISNUMBER(B51),ISNUMBER(B52),B53=\"\"),SUM(F51/H51+F52/H52),IF(AND(ISNUMBER(B51),ISNUMBER(B52),ISNUMBER(B53),B54=\"\"),SUM(F51/H51+F52/H52+F53/H53),IF(AND(ISNUMBER(B51),ISNUMBER(B52),ISNUMBER(B53),ISNUMBER(B54),B55=\"\"),SUM(F51/H51+F52/H52+F53/H53+F54/H54),SUM(F51/H51+F52/H52+F53/H53+F54/H54+F55/H55))))))","v":""},null,{"$f":"IF(B51=\"\",\"\",1)","v":""},{"$f":"IF(B51=\"\",\"\",IF(AND(B52=\"\",B53=\"\",B54=\"\"),I51,IF(AND(ISNUMBER(B51),ISNUMBER(B52),B53=\"\",B54=\"\"),ROUNDDOWN(SQRT(((F51/H51)*I51^2+(F52/H52)*I52^2)/SUM((F51/H51)+(F52/H52))),0),IF(AND(ISNUMBER(B51),ISNUMBER(B52),ISNUMBER(B53),B54=\"\"),ROUNDDOWN(SQRT(((F51/H51)*I51^2+(F52/H52)*I52^2+(F53/H53)*I53^2)/SUM((F51/H51)+(F52/H52)+(F53/H53))),0),IF(AND(ISNUMBER(B51),ISNUMBER(B52),ISNUMBER(B53),ISNUMBER(B54),B55=\"\"),ROUNDDOWN(SQRT(((F51/H51)*I51^2+(F52/H52)*I52^2+(F53/H53)*I53^2+(F54/H54)*I54^2)/SUM((F51/H51)+(F52/H52)+(F53/H53)+(F54/H54))),0),ROUNDDOWN(SQRT(((F51/H51)*I51^2+(F52/H52)*I52^2+(F53/H53)*I53^2+(F54/H54)*I54^2+(F55/H55)*I55^2)/SUM((F51/H51)+(F52/H52)+(F53/H53)+(F54/H54)+(F55/H55))),0))))))","v":""},{"$f":"IF(B51=\"\",\"\",IF(AND(ISNUMBER(B51),B52=\"\"),J51,IF(AND(ISNUMBER(B51),ISNUMBER(B52),B53=\"\"),(S+Cs/1000)/((B51+D51/1000)/J51+(B52+D52/1000)/J52),IF(AND(ISNUMBER(B51),ISNUMBER(B52),ISNUMBER(B53),B54=\"\"),(S+Cs/1000)/((B51+D51/1000)/J51+(B52+D52/1000)/J52+(B53+D53/1000)/J53),IF(AND(ISNUMBER(B51),ISNUMBER(B52),ISNUMBER(B53),ISNUMBER(B54),B55=\"\"),(S+Cs/1000)/((B51+D51/1000)/J51+(B52+D52/1000)/J52+(B53+D53/1000)/J53+(B54+D54/1000)/J54),(S+Cs/1000)/((B51+D51/1000)/J51+(B52+D52/1000)/J52+(B53+D53/1000)/J53+(B54+D54/1000)/J54+(B55+D55/1000)/J55))))))","v":""}]
["Enter information for the sensitivity weight(s) (sw)"]
["sw1"]
["sw2"]
["sw =",{"$f":"IF(B58=\"\",\"\",SUM(B58:B59))","v":""},null,{"$f":"IF(B58=\"\",\"\",SUM(D58:E59))","v":""},null,{"$f":"IF(B58=\"\",\"\",IF(AND(ISNUMBER(B58),B59=\"\"),F58/H58,SUM(F58/H58+F59/H59)))","v":""},null,{"$f":"IF(B58=\"\",\"\",1)","v":""},{"$f":"IF(B58=\"\",\"\",IF(B59=\"\",I58,ROUNDDOWN(SQRT(((F58/H58)*I58^2+(F59/H59)*I59^2)/SUM((F58/H58)+(F59/H59))),0)))","v":""},{"$f":"IF(B58=\"\",\"\",IF(AND(ISNUMBER(B58),B59=\"\"),J58,(sw+Csw/1000)/((B58+D58/1000)/J58+(B59+D59/1000)/J59)))","v":""}]
[]
["Environmental Standard(s) Data (used for MABC calculation)"]
["Parameter",null,"ID Code","Correction",null,"Uncertainty",null,"k factor","Unit"]
["Temperature, Air",null,"t",{"$nulls":5},"ºC"]
["Barometric Pressure",null,"P",{"$nulls":5},"mm Hg"]
["Humidity",null,"U",{"$nulls":5},"% RH"]

{"sheet":"SOP 4 Observations","index":8,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[2,0,2,9],[3,0,3,9],[4,3,4,4],[4,6,5,9],[5,3,5,4],[6,0,6,2],[6,3,6,4],[6,6,6,9],[9,0,10,2],[9,3,10,5],[9,6,10,8],[9,9,10,9],[11,0,11,2],[11,3,11,5],[11,6,11,8],[11,9,14,9],[12,0,12,2],[12,3,12,5],[12,6,12,8],[13,0,13,2],[13,3,13,5],[13,6,13,8],[14,0,14,2],[14,3,14,5],[14,6,14,8],[16,0,16,5],[16,6,16,8],[17,0,17,9],[18,0,18,7],[18,8,18,9],[21,0,21,1],[21,9,22,9],[22,0,22,2],[22,3,22,5],[22,6,22,8],[23,0,23,2],[23,3,23,5],[23,6,23,8],[23,9,26,9],[24,0,24,2],[24,3,24,5],[24,6,24,8],[25,0,25,2],[25,3,25,5],[25,6,25,8],[26,0,26,2],[26,3,26,5],[26,6,26,8],[27,0,27,9],[28,0,28,2],[28,3,28,5],[28,6,28,8],[28,9,31,9],[29,0,29,2],[29,3,29,5],[29,6,29,8],[30,0,30,2],[30,3,30,5],[30,6,30,8],[31,0,31,2],[31,3,31,5],[31,6,31,8],[32,0,32,9],[33,0,33,2],[33,3,33,5],[33,6,33,8],[33,9,36,9],[34,0,34,2],[34,3,34,5],[34,6,34,8],[35,0,35,2],[35,3,35,5],[35,6,35,8],[36,0,36,2],[36,3,36,5],[36,6,36,8],[37,0,37,1],[38,0,38,9]]}
["SOP 4 Observations",{"$nulls":8},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Uncertainty Evaluation"]
["Criteria: NIST HB 143, Table 4, \"The expanded uncertainty\n must be less than 1/3 of the maximum permissible error.\""]
[null,null,{"$f":"\"1/3 \"&Tol_Class&\" Tolerence =\"","v":"1/3 NIST HB 105-8 Tolerence ="},{"$f":"IF(Tolerance=\"\",\"\",Tolerance/3)","v":""},null,"lb",{"$f":"IF(D6=\"\",\"\",IF(D6<D5,\"The Uncertainty Meets the Criteria, Report Findings.\",\"The Uncertainty Does Not Meet the Criteria!\"))","v":""}]
[null,null,"Expanded Uncertainty =",{"$f":"IF(Final_U_SOP4=\"\",\"\",Final_U_SOP4/453.59237)","v":""},null,"lb"]
["Precision Test (Pn) =",null,null,{"$f":"IF(D5=\"\",\"\",D6/D5)","v":""},null,null,{"$f":"IF(D5=\"\",\"\",IF(D7<0.8,\"Precision Test is less than 1, Passed\",IF(AND(D7>=0.8,D7<1),\"Precision Test is less than 1, Passed but high\",IF(D7>1,\"Precision Test is greater than 1, Failed\"))))","v":""}]
[]
["Initial Observations and Mass Adjustment"]
["Observation Number",null,null,"Weights",null,null,{"$f":"\"Balance Readings (\"&IF(BalUnit=\"\",\"\",BalUnit)&\")\"","v":"Balance Readings ()"},null,null,"SOP 4, 2.5.2.5 Check"]
[]
["O1",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S\",\"X\")","v":"X"},{"$nulls":5},{"$f":"IF(SOP4InitObs_4=\"\",\"\",IF(AND(BalUnit=\"lb\",ABS((SOP4InitObs_2-SOP4InitObs_1)-(SOP4InitObs_3-SOP4InitObs_4))*453.59237<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"g\",ABS((SOP4InitObs_2-SOP4InitObs_1)-(SOP4InitObs_3-SOP4InitObs_4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
["O2",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X\",\"S\")","v":"S"}]
["O3",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X + sw\",\"S + sw\")","v":"S + sw"}]
["O4",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S + sw\",\"X + sw\")","v":"X + sw"}]
[]
["Conventional Mass Correction, CX vs 8.0 g/cm³ =",{"$nulls":5},{"$f":"IF(SOP4InitObs_4=\"\",\"\",IF(Procedure=\"SOP 4 - Option A (SXXS)\",FIXED(((Cs+(SOP4InitObs_2-SOP4InitObs_1+SOP4InitObs_3-SOP4InitObs_4)/2*((sw+Csw)/(SOP4InitObs_3-SOP4InitObs_2))+S-(Nx*453.59237))/453.59237),3,TRUE),FIXED(((Cs+(SOP4InitObs_1-SOP4InitObs_2+SOP4InitObs_4-SOP4InitObs_3)/2*((sw+Csw)/(SOP4InitObs_3-SOP4InitObs_2))+S-(Nx*453.59237))/453.59237),3,TRUE)))&\" lb\"","v":" lb"}]
["Adjust As Close To Zero Error As Possible And Continue With Final Observations"]
["Adjusting Cavity Calibration Seal Number:"]
[]
["Final Observations"]
["Start Time",null,null,"t (ºC)",null,"P (mm Hg)",null,"U (% RH)",null,"SOP 4, 2.5.2.5 Check"]
["Observation Number",null,null,"Weight",null,null,{"$f":"\"Balance Readings (\"&IF(BalUnit=\"\",\"\",BalUnit)&\")\"","v":"Balance Readings ()"}]
["O1",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S\",\"X\")","v":"X"},{"$nulls":5},{"$f":"IF(SOP4DubSub1_O4=\"\",\"\",IF(AND(BalUnit=\"lb\",ABS((SOP4DubSub1_O2-SOP4DubSub1_O1)-(SOP4DubSub1_O3-SOP4DubSub1_O4))*453.59237<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"g\",ABS((SOP4DubSub1_O2-SOP4DubSub1_O1)-(SOP4DubSub1_O3-SOP4DubSub1_O4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
["O2",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X\",\"S\")","v":"S"}]
["O3",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X + sw\",\"S + sw\")","v":"S + sw"}]
["O4",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S + sw\",\"X + sw\")","v":"X + sw"}]
["ROTATE WEIGHT CART 180º"]
["O1",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S\",\"X\")","v":"X"},{"$nulls":5},{"$f":"IF(SOP4DubSub2_O4=\"\",\"\",IF(AND(BalUnit=\"lb\",ABS((SOP4DubSub2_O2-SOP4DubSub2_O1)-(SOP4DubSub2_O3-SOP4DubSub2_O4))*453.59237<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"g\",ABS((SOP4DubSub2_O2-SOP4DubSub2_O1)-(SOP4DubSub2_O3-SOP4DubSub2_O4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
["O2",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X\",\"S\")","v":"S"}]
["O3",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X + sw\",\"S + sw\")","v":"S + sw"}]
["O4",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S + sw\",\"X + sw\")","v":"X + sw"}]
["ROTATE WEIGHT CART 180º"]
["O1",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S\",\"X\")","v":"X"},{"$nulls":5},{"$f":"IF(SOP4DubSub3_O4=\"\",\"\",IF(AND(BalUnit=\"lb\",ABS((SOP4DubSub3_O2-SOP4DubSub3_O1)-(SOP4DubSub3_O3-SOP4DubSub3_O4))*453.59237<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"g\",ABS((SOP4DubSub3_O2-SOP4DubSub3_O1)-(SOP4DubSub3_O3-SOP4DubSub3_O4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
["O2",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X\",\"S\")","v":"S"}]
["O3",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"X + sw\",\"S + sw\")","v":"S + sw"}]
["O4",null,null,{"$f":"IF(Procedure=\"SOP 4 - Option A (SXXS)\",\"S + sw\",\"X + sw\")","v":"X + sw"}]
["Finish Time",null,null,"t (ºC)",null,"P (mm Hg)",null,"U (% RH)"]

{"sheet":"SOP 8 Observations","index":9,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[2,0,2,9],[3,0,3,9],[4,3,4,4],[4,6,5,9],[5,3,5,4],[6,0,6,2],[6,3,6,4],[6,6,6,9],[9,0,10,2],[9,3,10,5],[9,6,10,8],[9,9,11,9],[11,0,11,2],[11,3,11,5],[11,6,11,8],[12,0,12,2],[12,3,12,5],[12,6,12,8],[13,0,13,2],[13,3,13,5],[13,6,13,8],[13,9,14,9],[14,0,14,2],[14,3,14,5],[14,6,14,8],[15,0,15,2],[15,3,15,5],[15,6,15,8],[17,0,17,5],[17,6,17,8],[18,0,18,9],[19,0,19,7],[19,8,19,9],[22,0,22,1],[22,9,24,9],[23,0,23,2],[23,3,23,5],[23,6,23,8],[24,0,24,2],[24,3,24,5],[24,6,24,8],[25,0,25,2],[25,3,25,5],[25,6,25,8],[26,0,26,2],[26,3,26,5],[26,6,26,8],[26,9,29,9],[27,0,27,2],[27,3,27,5],[27,6,27,8],[28,0,28,8],[29,0,29,2],[29,3,29,5],[29,6,29,8],[30,0,30,8],[30,9,31,9],[31,0,31,2],[31,3,31,5],[31,6,31,8],[32,0,32,2],[32,3,32,5],[32,6,32,8],[33,0,33,1],[34,0,34,9]]}
["SOP 8 Observations",{"$nulls":8},""]
[]
["Uncertainty Evaluation"]
["Criteria: NIST HB 143, Table 4, \"The expanded uncertainty\n must be less than 1/3 of the maximum permissible error.\""]
[null,null,"1/3 NIST HB 105-8 Tolerence =",{"$f":"IF(Tolerance=\"\",\"\",Tolerance/3)","v":""},null,"lb",{"$f":"IF(D6=\"\",\"\",IF(D6<D5,\"The Uncertainty Meets the Criteria, Report Findings.\",\"The Uncertainty Does Not Meet the Criteria!\"))","v":""}]
[null,null,"Expanded Uncertainty =",{"$f":"IF(Final_U_SOP8=\"\",\"\",Final_U_SOP8/453.59237)","v":""},null,"lb"]
["Precision Test (Pn) =",null,null,{"$f":"IF(D5=\"\",\"\",D6/D5)","v":""},null,null,{"$f":"IF(D5=\"\",\"\",IF(D7<0.8,\"Precision Test is less than 1, Passed\",IF(AND(D7>=0.8,D7<1),\"Precision Test is less than 1, Passed but high\",IF(D7>1,\"Precision Test is greater than 1, Failed\"))))","v":""}]
[]
["Initial Observations and Mass Adjustment"]
["Observation Number",null,null,"Weights",null,null,"Balance Readings (g)",null,null,"SOP 8 Sensitivity Check"]
[]
["O1",null,null,"S"]
["O2",null,null,"S + sw",{"$nulls":5},{"$f":"IF(G13=\"\",\"\",IF(BalUnit=\"lb\",IF(ABS((sw+Csw)/((G13-G12)*453.59237)-1)*100<=2,\"GO\",\"REPEAT\"),IF(ABS((sw+Csw)/(G13-G12)-1)*100<=2,\"GO\",\"REPEAT\")))","v":""}]
["O3",null,null,"S",{"$nulls":5},"SOP 8 Drift Check"]
["O4",null,null,"X"]
["O5",null,null,"S",{"$nulls":5},{"$f":"IF(G16=\"\",\"\",IF(AND(BalUnit=\"g\",ABS(G16-G14)*((sw+Csw)/(G13-G12))<=Tolerance*453.59237/10),\"GO\",IF(AND(BalUnit=\"lb\",ABS(G16-G14)*(((sw+Csw)/453.59237)/(G13-G12))<=Tolerance/10),\"GO\",\"REPEAT\")))","v":""}]
[]
["Conventional Mass Correction, CX vs 8.0 g/cm³ =",{"$nulls":5},{"$f":"IF(SOP8InitObs_O3=\"\",\"\",IF(BalUnit=\"lb\",FIXED(Cs/453.59237+(SOP8InitObs_O4-SOP8InitObs_O3),3,TRUE),FIXED((Cs+(SOP8InitObs_O4-SOP8InitObs_O3))/453.59237,3,TRUE)))&\" lb\"","v":" lb"}]
["Adjust As Close To Zero Error As Possible And Continue With Final Observations"]
["Adjusting Cavity Calibration Seal Number:"]
[]
["Final Observations"]
["Start Time",null,null,"t (ºC)",null,"P (mm Hg)",null,"U (% RH)",null,"SOP 8 Sensitivity Check"]
["Observation Number",null,null,"Weight",null,null,"Balance Readings (g)"]
["O1",null,null,"S"]
["O2",null,null,"S + sw",{"$nulls":5},{"$f":"IF(G26=\"\",\"\",IF(BalUnit=\"lb\",IF(ABS((sw+Csw)/((G26-G25)*453.59237)-1)*100<=2,\"GO\",\"REPEAT\"),IF(ABS((sw+Csw)/(G26-G25)-1)*100<=2,\"GO\",\"REPEAT\")))","v":""}]
["O3",null,null,"S"]
["O4",null,null,"X"]
["ROTATE WEIGHT CART 180º"]
["O5",null,null,"X"]
["ROTATE WEIGHT CART 180º",{"$nulls":8},"SOP 8 Drift Check"]
["O6",null,null,"X"]
["O7",null,null,"S",{"$nulls":5},{"$f":"IF(G33=\"\",\"\",IF(AND(BalUnit=\"g\",ABS(G33-G27)*((sw+Csw)/(G26-G25))<=Tolerance*453.59237/10),\"GO\",IF(AND(BalUnit=\"lb\",ABS(G33-G27)*(((sw+Csw)/453.59237)/(G26-G25))<=Tolerance/10),\"GO\",\"REPEAT\")))","v":""}]
["Finish Time",null,null,"t (ºC)",null,"P (mm Hg)",null,"U (% RH)"]

{"sheet":"Calculations","index":10,"n_rows":33,"n_cols":10,"rows_kept":33,"merged":[[3,0,3,9],[4,7,4,8],[5,7,5,8],[6,7,6,8],[8,7,8,8],[9,7,9,8],[12,0,12,9],[15,5,15,9],[18,0,18,9],[21,5,21,9],[24,0,24,9],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5]]}
["Calculations",{"$nulls":8},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Measurement Determinations"]
[{"$f":"\"Measurement Observations Procedure - \"&Procedure","v":"Measurement Observations Procedure - "}]
[{"$nulls":6},"Measurement 1 - Weight Cart Conventional Mass, CM vs 8.0 g/cm³ =",{"$f":"IF(Procedure=\"\",\"\",IF(AND(Procedure=\"SOP 8\",BalUnit=\"lb\"),(S+Cs)/453.59237+(SOP8_O4-SOP8_O3),IF(AND(Procedure=\"SOP 8\",BalUnit=\"g\"),((S+Cs)+(SOP8_O4-SOP8_O3))/453.59237,IF(Procedure=\"SOP 4 - Option A (SXXS)\",((S+Cs+(SOP4DubSub1_O2-SOP4DubSub1_O1+SOP4DubSub1_O3-SOP4DubSub1_O4)/2*((sw+Csw)/(SOP4DubSub1_O3-SOP4DubSub1_O2))+S-(Nx*453.59237))/453.59237),((S+Cs+(SOP4DubSub1_O1-SOP4DubSub1_O2+SOP4DubSub1_O4-SOP4DubSub1_O3)/2*((sw+Csw)/(SOP4DubSub1_O3-SOP4DubSub1_O2))+S-(Nx*453.59237))/453.59237)))))","v":""},null,"lb"]
[{"$nulls":6},"Measurement 2 - Weight Cart Conventional Mass, CM vs 8.0 g/cm³ =",{"$f":"IF(Procedure=\"\",\"\",IF(AND(Procedure=\"SOP 8\",BalUnit=\"lb\"),(S+Cs)/453.59237+(SOP8_O5-SOP8_O3),IF(AND(Procedure=\"SOP 8\",BalUnit=\"g\"),((S+Cs)+(SOP8_O5-SOP8_O3))/453.59237,IF(Procedure=\"SOP 4 - Option A (SXXS)\",((S+Cs+(SOP4DubSub2_O2-SOP4DubSub2_O1+SOP4DubSub2_O3-SOP4DubSub2_O4)/2*((sw+Csw)/(SOP4DubSub2_O3-SOP4DubSub2_O2))+S-(Nx*453.59237))/453.59237),((S+Cs+(SOP4DubSub2_O1-SOP4DubSub2_O2+SOP4DubSub2_O4-SOP4DubSub2_O3)/2*((sw+Csw)/(SOP4DubSub2_O3-SOP4DubSub2_O2))+S-(Nx*453.59237))/453.59237)))))","v":""},null,"lb"]
[{"$nulls":6},"Measurement 3 - Weight Cart Conventional Mass, CM vs 8.0 g/cm³ =",{"$f":"IF(Procedure=\"\",\"\",IF(AND(Procedure=\"SOP 8\",BalUnit=\"lb\"),(S+Cs)/453.59237+(SOP8_O6-SOP8_O3),IF(AND(Procedure=\"SOP 8\",BalUnit=\"g\"),((S+Cs)+(SOP8_O6-SOP8_O3))/453.59237,IF(Procedure=\"SOP 4 - Option A (SXXS)\",((S+Cs+(SOP4DubSub3_O2-SOP4DubSub3_O1+SOP4DubSub3_O3-SOP4DubSub3_O4)/2*((sw+Csw)/(SOP4DubSub3_O3-SOP4DubSub3_O2))+S-(Nx*453.59237))/453.59237),((S+Cs+(SOP4DubSub3_O1-SOP4DubSub3_O2+SOP4DubSub3_O4-SOP4DubSub3_O3)/2*((sw+Csw)/(SOP4DubSub3_O3-SOP4DubSub3_O2))+S-(Nx*453.59237))/453.59237)))))","v":""},null,"lb"]
[]
[{"$nulls":6},"Average Weight Cart Conventional Mass, CMx vs 8.0 g/cm³ = ",{"$f":"IF(H7=\"\",\"\",AVERAGE(H5:I7))","v":""},null,"lb"]
[{"$nulls":6},"Weight Cart Conventional Mass Correction, Cx vs 8.0 g/cm³ = ",{"$f":"IF(CMx=\"\",\"\",H9-Nx)","v":""},null,"lb"]
[]
["Tolerance Compliance Evaluation"]
["Criteria: The conventional mass shall not differ more than the maximum permissible error minus the\nexpanded uncertainty from the nominal value of weight. (ASTM E 617, NIST HB 105-1 & OIML R 111)"]
[null,null,{"$f":"Tol_Class&\" Tolerence (\"&CHAR(177)&\") =\"","v":"NIST HB 105-8 Tolerence (±) ="},{"$f":"IF(Tolerance=\"\",\"\",Tolerance)","v":""},"lb"]
[null,null,{"$f":"\"Expanded Uncertainty (\"&CHAR(177)&\") =\"","v":"Expanded Uncertainty (±) ="},{"$f":"IF(Final_U_SOP4=\"\",\"\",Final_U_SOP4/453.59237)","v":""},"lb"]
[null,null,"Conventional Mass Correction, Cx vs 8.0 =",{"$f":"IF(Cx=\"\",\"\",Cx)","v":""},"lb",{"$f":"IF(Cx=\"\",\"\",IF(ABS(D16)<=ABS(D14-D15),\"The As Found Conventional Mass Is IN-TOLERANCE\",\"The As Found Conventional Mass Is OUT-OF-TOLERANCE, Adjust And Re-Test\"))","v":""}]
[]
["Measurement Assurance Evaluations"]
["Criteria: If the values for the standard deviation chart fall outside of the warning limits but inside of the control limits, a decrease in precision is indicated. Other problems should be investigated. (NISTIR 7383,SOP 17, 4.3.3)"]
[null,null,"Upper Control Limit=",{"$f":"IF(sp=\"\",\"\",sp*3/453.59237)","v":""},"lb"]
[null,null,"Warning Limit =",{"$f":"IF(sp=\"\",\"\",sp*2/453.59237)","v":""},"lb"]
[null,null,"Standard Deviation of Range =",{"$f":"IF(H7=\"\",\"\",MAX(H5:H7)-MIN(H5:H7))","v":""},"lb",{"$f":"IF(D22=\"\",\"\",IF(D22>UCL,\"The Standard Deviation Is Outside The Control Limits, Investigate The Problem, Then Redo The Measurements\",IF(AND(D22<=UCL,D22>WL),\"The Standard Deviation Is outside the Warning Limit but inside the Control Limit, Investigate The Problem, Then Redo The Measurements As Necessary\",IF(D22<=WL,\"The Standard Deviation Is In Control, Plot The Value On The Control Chart\"))))","v":""}]
[]
["Report Conventional Mass Correction and Uncertainty (uc*k) As Follows:"]
["Mass corrections and uncertainties are rounded according to NISTIR 6969, GLP 9"]
[{"$nulls":3},"Nominal Value =",{"$f":"IF(Nx=\"\",\"\",Nx)","v":""},null,"lb"]
[{"$nulls":3},"Conventional Mass =",{"$f":"IF(CMx=\"\",\"\",IF(Procedure=\"SOP 8\",FIXED(CMx,2-1-INT(LOG10(ABS(Final_U_SOP8/453.59237))),TRUE),FIXED(CMx,2-1-INT(LOG10(ABS(Final_U_SOP4/453.59237))),TRUE)))","v":""},null,"lb"]
[{"$nulls":3},"Conventional Mass Correction =",{"$f":"IF(Cx=\"\",\"\",IF(Procedure=\"SOP 8\",FIXED(Cx,2-1-INT(LOG10(ABS(Final_U_SOP8/453.59237))),TRUE),FIXED(Cx,2-1-INT(LOG10(ABS(Final_U_SOP4/453.59237))),TRUE)))","v":""},null,"lb"]
[{"$nulls":3},"Effective Degrees of Freedom (veff) =",{"$f":"IF(Procedure=\"\",\"\",IF(Procedure=\"SOP 8\",Final_Veff_SOP8,Final_Veff_SOP4))","v":""}]
[{"$nulls":3},"k factor =",{"$f":"IF(Procedure=\"\",\"\",IF(Procedure=\"SOP 8\",Final_k_SOP8,Final_k_SOP4))","v":""}]
[{"$nulls":3},"Uncertainty (uc*k) =",{"$f":"IF(Procedure=\"\",\"\",IF(Procedure=\"SOP 8\",FIXED(Final_U_SOP8/453.59237,2-1-INT(LOG10(ABS(Final_U_SOP8/453.59237))),TRUE),FIXED(Final_U_SOP4/453.59237,2-1-INT(LOG10(ABS(Final_U_SOP4/453.59237))),TRUE)))","v":""},null,"lb"]
[{"$nulls":3},{"$f":"Tol_Class&\" Tolerence (\"&CHAR(177)&\") =\"","v":"NIST HB 105-8 Tolerence (±) ="},{"$f":"IF(Tolerance=\"\",\"\",Tolerance)","v":""},null,"lb"]
[{"$nulls":3},"Assumed Density =",{"$f":"IF(Px=\"\",\"\",Px)","v":""},null,"g/cm³"]

{"sheet":"SOP 8 Uncertainty Analysis","index":11,"n_rows":58,"n_cols":10,"rows_kept":58,"merged":[[0,2,0,3],[24,0,24,9],[27,0,27,9],[31,1,31,4],[31,5,31,8],[32,1,32,4],[32,5,32,9],[33,1,33,4],[33,5,33,9],[34,1,34,4],[34,5,34,9],[35,1,35,4],[35,5,35,9],[36,1,36,4],[36,5,36,9],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1]]}
["Uncertainty Analysis",{"$nulls":8},""]
[]
["Specify Procedure"]
["NISTIR 6969, SOP 33, Calibration of Weight Carts using SOP 8 (Modified for triple modified substitution measurements)"]
[]
["Specify Equation(s)"]
["Modified Substitution"]
["Cx = Cs + ( Xn – O1 ) + Ns – Nx"]
["where"]
["Cs =","the conventional mass correction of the standard weight"]
["Cx =","the conventional mass correction of the weight calibrated"]
["CM =","the conventional mass of a specific weight.  Subscripts s, x, t, sw are used to identify the weight."]
["sw =","small calibrated weight used to evaluate the sensitivity of the balance"]
[]
[]
["Estimating the Magnitude of the Air Buoyancy Correction, NISTIR 6969, SOP 2."]
[]
["where"]
["m0 =","nominal mass in grams"]
["ρa =","density of air at time of measurement, SOP 2, Option B, 2012 (CIPM 2007)"]
["ρn =","density of \"normal\" air, i.e., 0.0012 g/cm³"]
["ρX =","density of the unknown mass"]
["ρS =","density of the mass standard"]
[]
["Standard uncertainty for the 2% sensitivity error allowed by NISTIR 6969, SOP 8."]
[null,null,"where U equals 2 times the combined uncertainty, not including sensitivity error."]
[]
["Standard uncertainty for the 10% drift error allowed by NISTIR 6969, SOP 8."]
[]
[]
["Identify Components"]
["Component","Description",{"$nulls":3},"Reference"]
["s(p)","Uncertainty associated with the measurement process",{"$nulls":3},"Standard deviation associated with the measurement process from an X-Chart or R-Chart, normal distribution"]
["u(s)","Uncertainty associated with the  mass standards",{"$nulls":3},"Uncertainty of mass standard(s) from calibration report, normal distribution, k =1"]
["u(MABC)","Uncertainty associated with the magnitude of the air buoyancy correction where air buoyancy is not used",{"$nulls":3},"NISTIR 6969, SOP 2, Paragraph 2.3.2, Estimating the Magnitude of the Air Buoyancy Correction, rectangular distribution"]
["u(se)","Uncertainty associated with the Sensitivity Error",{"$nulls":3},"Uncertainty associated with 2% sensitivity error allowed by NISTIR 6969, SOP 8, Paragraph 5.4, rectangular distribution"]
["u(de)","Uncertainty associated with the Drift Error",{"$nulls":3},"Uncertainty associated with 10% drift error allowed by NISTIR 6969, SOP 8, Paragraph 5.3, rectangular distribution"]
[]
["Quantify, Convert, Combined & Expand"]
["Component Description",null,"Component Symbol","Rpt Unc (g)","Type","Distribution","Factor to Normalize","Std Unc (g)","% Contribution","Degrees of Freedom"]
["Standard Deviation from CC",null,"s(p)",{"$f":"IF(sp=\"\",0,MAX(sp,Resolution/SQRT(3)))","v":0},"A","Normal",1,{"$f":"D41/G41","v":0},{"$f":"IF($I$47=0,\"\",H41^2/$I$47^2)","v":""},{"$f":"IF(H41=0,1,sp_df)","v":1}]
["Report U divided by k-factor",null,"u(s)",{"$f":"IF(Us=\"\",0,Us)","v":0},"B","Normal",1,0,"",{"$f":"IF(H42=0,1,S_df)","v":1}]
["Report U divided by k-factor",null,"u(sw)",{"$f":"IF(Usw=\"\",0,Usw)","v":0},"B","Normal",3,0,"",{"$f":"IF(H43=0,1,sw_df)","v":1}]
["Magnitude of ABC",null,"u(MABC)",{"$f":"IF(Nx=\"\",0,ABS(Nx*453.59237*(CIPM_Pa-0.0012)*(1/Px-1/Ps)))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",{"$f":"IF(H44=0,1,10000)","v":1}]
["Sensitivity Error",null,"u(se)",{"$f":"IF(Tolerance=\"\",0,2%*ABS(Tolerance*453.59237-(2*SQRT(SUMSQ(H41:H44,H46)))))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",{"$f":"IF(H45=0,1,10000)","v":1}]
["Drift Error",null,"u(de)",{"$f":"IF(Tolerance=\"\",0,Tolerance*453.59237*10%)","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",1]
[{"$nulls":7},"Combined U (uc) =",{"$f":"SQRT(SUMSQ(H41:H46))","v":0}," (g)"]
[{"$nulls":7},"Effective Degrees of Freedom, Welch-Satterthwaite formula, NIST Technical Note 1297, (B-1) (veff) =",{"$f":"IF(I47=0,\"\",ROUNDDOWN(I47^4/((H41^4/J41)+(H42^4/J42)+(H43^4/J43)+(H44^4/J44)+(H45^4/J45)+(H46^4/J46)),0))","v":""}]
[{"$nulls":7},"k factor =",{"$f":"IF(I48=\"\",\"\",ROUND(TINV(0.0455,I48),3))","v":""}]
[{"$nulls":7},"Expanded U (uc*k) =",{"$f":"IF(I49=\"\",\"\",I49*I47)","v":""}," (g)"]
[{"$nulls":7},"NVLAP Effective Degrees of Freedom (veff) =",{"$f":"IF(Best_df=\"\",\"\",Best_df)","v":""}]
[{"$error":"#REF!"},{"$nulls":6},"NVLAP k factor =",{"$f":"IF(Best_k=\"\",\"\",Best_k)","v":""}]
[{"$error":"#REF!"},{"$nulls":6},"NVLAP U =",{"$f":"IF(Best_U=\"\",\"\",Best_U)","v":""}," (g)"]
[{"$nulls":7},"Final Effective Degrees of Freedom (veff) =",{"$f":"IF(I50>I53,I48,I52)","v":""}]
[{"$nulls":7},"Final k factor =",{"$f":"IF(I50>I53,I49,I52)","v":""}]
[{"$nulls":7},"Final U (uc*k) =",{"$f":"IF(I50>I53,I50,I53)","v":""}," (g)"]
[]
["Impact of Uncertainty Components"]

{"sheet":"SOP 4 Uncertainty Analysis","index":12,"n_rows":53,"n_cols":10,"rows_kept":53,"merged":[[0,2,0,3],[30,1,30,4],[30,5,30,9],[31,1,31,4],[31,5,31,9],[32,1,32,4],[32,5,32,9],[33,1,33,4],[33,5,33,9],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1]]}
["Uncertainty Analysis",{"$nulls":8},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Specify Procedure"]
["NISTIR 6969, SOP 33, Calibration of Weight Carts using SOP 4 (Modified for triple double substitution measurements)"]
[]
["Specify Equation(s)"]
["Double Substitution Optional Sequence B (XSSX) w/o Air Buoyancy Correction"]
[]
["where"]
["S =","standard weight"]
["X =","weight calibrated"]
["t =","small calibrated tare weight, A subscript s or x is used to indicate the larger weight with which it is associated"]
["sw =","small calibrated weight used to evaluate the sensitivity of the balance"]
["N =","the nominal value of a specific weight.  Subscripts s, x, are used to identify the weight."]
["C =","the correction for a specific weight.  Subscripts s, x, are used to identify the weight."]
["CM =","the conventional mass of a specific weight.  Subscripts s, x, t, sw are used to identify the weight."]
["ρa =","density of air at time of calibration"]
["rn =","density of normal air (1.2 kg/m³)"]
["ρ =","density of masses; subscripts s, x, ts, tx, sw are used to identify the weight"]
[]
["Estimating the Magnitude of the Air Buoyancy Correction"]
[]
["where"]
["m0 =","nominal mass in grams"]
["ρa =","density of air at time of measurement or normally found in the laboratory in g/cm³"]
["ρn =","density of \"normal\" air, i.e., 0.0012 g/cm³"]
["ρX =","density of the unknown mass"]
["ρS =","density of the mass standard"]
[]
["Identify Components"]
["Component","Description",{"$nulls":3},"Reference"]
["s(p)","Uncertainty associated with the measurement process from the standard deviation of replicate measurements, normal distribution",{"$nulls":3},"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  mass standards, k=1",{"$nulls":3},"Calibration Report divided by the k factor"]
["u(MABC)","Uncertainty associated with the magnitude of the air buoyancy correction where air buoyancy is not used, rectangular distribution",{"$nulls":3},"NISTIR 6969, SOP 2, Paragraph 2.3.2, Estimating the Magnitude of the Air Buoyancy Correction"]
[]
["Quantify, Convert, Combined & Expand"]
["Component Description",null,"Component Symbol","Reported Unc\n(g)","Type","Distribution","Factor to Normalize","Standard Unc\n(g)","% Contribution","Degrees of Freedom"]
["Standard Deviation from CC",null,"s(p)",{"$f":"IF(sp=\"\",0,IF(BalUnit=\"lb\",MAX(sp,Resolution*453.59237/SQRT(3)),MAX(sp,Resolution/SQRT(3))))","v":0},"A","Normal",1,{"$f":"D38/G38","v":0},{"$f":"IF($I$42=\"\",\"\",H38^2/$I$42^2)","v":""},{"$f":"IF(H38=0,1,sp_df)","v":1}]
["Report U divided by k-factor",null,"u(s)",{"$f":"IF(Us=\"\",0,Us)","v":0},"B","Normal",1,{"$f":"D39/G39","v":0},{"$f":"IF($I$42=\"\",\"\",H39^2/$I$42^2)","v":""},{"$f":"IF(H39=0,1,S_df)","v":1}]
["Report U divided by k-factor",null,"u(sw)",{"$f":"IF(Usw=\"\",0,Usw)","v":0},"B","Normal",1,{"$f":"D40/G40","v":0},{"$f":"IF($I$42=\"\",\"\",H40^2/$I$42^2)","v":""},{"$f":"IF(H40=0,1,sw_df)","v":1}]
["Magnitude of ABC",null,"u(MABC)",{"$f":"IF(Nx=\"\",0,ABS(Nx*453.59237*(CIPM_Pa-0.0012)*(1/Px-1/Ps)))","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},{"$f":"D41/G41","v":0},{"$f":"IF($I$42=\"\",\"\",H41^2/$I$42^2)","v":""},{"$f":"IF(H41=0,1,10000)","v":1}]
[{"$nulls":7},"Combined U (uc) =",{"$f":"IF(SUM(H38:H41)=0,\"\",SQRT(SUMSQ(H38:H41)))","v":""},"g"]
[{"$nulls":7},"Effective Degrees of Freedom, Welch-Satterthwaite formula, NIST Technical Note 1297, (B-1) (veff) =",{"$f":"IF(MAX(J38:J41)=1,\"\",ROUNDDOWN(I42^4/((H38^4/J38)+(H39^4/J39)+(H40^4/J40)+(H41^4/J41)),0))","v":""}]
[{"$nulls":7},"k factor =",{"$f":"IF(I43=\"\",\"\",ROUND(TINV(0.0455,I43),3))","v":""}]
[{"$nulls":7},"Expanded U (uc*k) =",{"$f":"IF(I44=\"\",\"\",I44*I42)","v":""},"g"]
[{"$nulls":7},"NVLAP Effective Degrees of Freedom (veff) =",{"$f":"IF(Best_df=\"\",\"\",Best_df)","v":""}]
[{"$nulls":7},"NVLAP k factor =",{"$f":"IF(Best_k=\"\",\"\",Best_k)","v":""}]
[{"$nulls":7},"NVLAP U =",{"$f":"IF(Best_U=\"\",\"\",Best_U)","v":""},"g"]
[{"$nulls":7},"Final Effective Degrees of Freedom (veff) =",{"$f":"IF(I45>I48,I43,I46)","v":""}]
[{"$nulls":7},"Final k factor =",{"$f":"IF(I45>I48,I44,I47)","v":""}]
[{"$nulls":7},"Final U (uc*k) =",{"$f":"IF(I45>I48,I45,I48)","v":""},"g"]
[]
["Impact of Uncertainty Components"]

{"sheet":"CIPM Air Density","index":13,"n_rows":7,"n_cols":5,"rows_kept":7,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2],[6,3,6,4]]}
["CIPM Air Density",{"$nulls":3},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Air Density, SOP 2, Option B, 2012 (CIPM 2007)"]
["Air Density\nNote: Air density results are rounded to 9 digits (g/cm³) and used for MABC calculation."]
[" Barometric Pressure (mm Hg)",null,null,{"$f":"IF(AND(SOP4_P1=\"\",SOP8_P1=\"\"),\"\",IF(Procedure=\"SOP 8\",AVERAGE(SOP8_P1+P_corr,SOP8_P2+P_corr),AVERAGE(SOP4_P1+P_corr,SOP4_P2+P_corr)))","v":""}]
[" Temperature (ºC)",null,null,{"$f":"IF(AND(SOP4_t1=\"\",SOP8_t1=\"\"),\"\",IF(Procedure=\"SOP 8\",AVERAGE(SOP8_t1+t_corr,SOP8_t2+t_corr),AVERAGE(SOP4_t1+t_corr,SOP4_t2+t_corr)))","v":""}]
[" Relative Humidity (%)",null,null,{"$f":"IF(AND(SOP4_U1=\"\",SOP8_U1=\"\"),\"\",IF(Procedure=\"SOP 8\",AVERAGE(SOP8_U1+U_corr,SOP8_U2+U_corr),AVERAGE(SOP4_U1+U_corr,SOP4_U2+U_corr)))","v":""}]
[" Calculated Air Density (mg/cm³)",null,null,{"$f":"IF(D6=\"\",0.0012,ROUND(((((D4*(133.322368421053))*(0.02896546))/((1-(((D4*133.322368421053)/(D5+273.15))*((0.00000158123)+((-0.000000029331)*(D5))+(0.00000000011043*D5^2)+(((0.000005707)+(-0.00000002051*D5))*((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316*(D5+273.15))+33.93711047+(-6343.1645/(D5+273.15))))/(D4*133.322368421053)))))+((0.00019898+(-0.000002376*D5))*(((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053))))^2))))+(((D4*133.322368421053)^2/((D5+273.15)^2)*(0.0000000000183+(-0.00000000765*(((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053))))^2))))))*(8.314472)*(D5+273.15)))*(1-((0.378*((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053))))))))/1000,9))","v":0.0012}]

{"sheet":"Tables and Lists","index":14,"n_rows":8,"n_cols":2,"rows_kept":8,"merged":[[2,0,2,1]]}
["Tables & Lists"]
[{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Tolerance Lookup Table\n(Tol)\n(lb)"]
[2000,0.5]
[3000,1]
[4000,1.25]
[5000,1.5]
[6000,2]