{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Software Technical Assessment","Documentation","SOP 4","OIML Unc Estimates","Instructions","Report Pages 1-3","Report Page 4","Data Entry","Control Data","Calculations","Uncertainty Analysis","CIPM Air Density","Tables and Lists"],"not_rendered":{"charts":1,"images":19,"external_links":4,"defined_names":197,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Software Technical Assessment","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"merged":[[5,0,17,0],[18,0,21,0],[22,0,25,0],[26,0,28,0],[29,0,34,0],[35,0,38,0],[39,0,40,0],[43,0,48,0],[56,4,56,5]]}
["Software Technical Assessment"]
[]
["Software Description","WAMRF-008 (Rev. 24), Weighing by Double Substitution, SOP 4","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 4 is embedded"]
[null,"The formulae and methods chosen from that SOP are specified","Pass","Formulae are show in SOP 4 and Uncertainty Analysis worksheets"]
[null,"Sources and references for formulae are specified","Pass","As specified in SOP 4"]
[null,"The chosen SOP, its methods, and its formulae, are appropriate to the level of precision/uncertainty","Pass","For all Mass Echelon II and III calibrations"]
["C. Code review","The formulae in the fields exactly match the SOP","Pass","Formulae on calculation worksheet match SOP 4"]
[null,"Repeated calculations appropriately reference the correct cells","Pass"]
[null,"Calculations, when tested using standard data or reference test data, show appropriate accuracy","Pass","Tested using SOP 4 example and Data Sets"]
[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","N/A","No Macros"]
[null,"Each command/button is functional","N/A","No command buttons"]
[null,"Combinations of interdependent macros are functional","Pass","No issues encountered"]
[null,"Plotted graphs are accurate","Pass","Graphs on uncertainty worksheet display properly"]
[null,"Worksheets/reports print properly, if needed to","Pass","Worksheets formatted for printing as necessary"]
[null,"Conditional (color and non-color) formatting is functional","Pass","On data entry and calculation worksheets"]
["F. Numerical Reference","Look-up tables and lists match the latest calibration report.","Pass","Linked tables are validated and up to date"]
[null,"Uncertainties match the latest Scope","Pass","Test on uncertainty worksheet will not allow an uncertainty that is better than the latest published scope"]
[null,"Values that reference another workbook or spreadsheet are dated","N/A","Linked references have been validated and are up to date"]
[null,"When a master list’s date is updated, the file references (A) an old value, (B) a default value, (C) displays zero or (D) an error message, as desired by the user","N/A"]
["G. Embedded Data Evaluation","Embedded data (conversion factors, reference values, etc) is correct","Pass","All embedded data has been validated"]
[null,"The evaluation of the embedded data is dated and documented","Pass","Records keep in Software Validation folder on computer hard drive"]
["H. Back-to-Back Testing","Newer spreadsheets and older spreadsheets agree down to the level of intermediate calculations; this evaluation is dated and documented","Pass","Evaluated and filed"]
["I. Analysis With Out Computer Assistance","Hand calculations agree with those generated by the spreadsheet, or if they disagree, the differences are significantly smaller than the reported uncertainty","N/A","No hand calculations were done"]
["J. Security","Equation and calculation cells are protected against inadvertent editing","Pass","Cells are locked and worksheets are password protected"]
[null,"Cells are locked in place; they cannot be moved/dragged","Pass","Locked and password protected"]
[null,"Confidentiality of passwords is appropriate","Pass","State Metrologist and Program Manager only have access"]
[null,"Files are backed up automatically","Pass","Backed up to agency servers weekly"]
[null,"Additional back-up is available at alternate facilities","Pass","Agency IT backs up servers weekly"]
[null,"Files on network drives cannot be accidentally deleted","Pass","Agency IT keeps an additional back up at a remote location"]

{"sheet":"Documentation","index":1,"n_rows":107,"n_cols":3,"rows_kept":107}
["Documentation",null,{"$f":"IF(ISBLANK(RptNo),\"\",\"Report Number: \"&RptNo)","v":""}]
["Date","Description","Initials"]
["2002-10-04","This spreadsheet was developed by Dan Wright, WA Dept of Agriculture. This workbook follows the procedure documented in NISTIR 6969, SOP 4.","DAW"]
["2004-09-29","Changed uncertainty analysis","DAW"]
["2006-10-06","Total revision and reissue","DAW"]
["2007-07-20","Changed check standard test to include control chart bias/drift","DAW"]
["2007-09-24","Rounded air density formula to 6 places and water density to 8 places","DAW"]
["2008-02-04","Deleted 'Standards' worksheet. Re-referenced vlookups to global standards workbooks","DAW"]
["2008-07-15","changed range controls to pooled standard deviations","DAW"]
["2008-09-11","Deleted triplicate measurement. Added 'Control Data' worksheet. Revised \"Documentation' worksheet.","DAW"]
["2008-11-13","Changed \"BalID\" to \"BalUnit\" in cells F18 and A19 on Data Entry worksheet","DAW"]
["2008-11-13","Corrected headers and footers on 'Documentation' and both 'Reports' worksheets","DAW"]
["2008-11-13","Updated Balance ID comment in cell A14 and created lookup for balance process standard deviation in I19 on 'Data Entry' worksheet","DAW"]
["2008-11-13","Changed 'Pts' to 'Ptx' in cell A50 on 'Uncertainty Analysis' worksheet","DAW"]
["2008-11-13","Added IF statement in cell H61 for 'Not Applicable' on 'Calculations' worksheet","DAW"]
["2008-11-13","Copied formulas for weight identification from 'Data Entry' to 'Equal-Arm Balance Data Entry' worksheets","DAW"]
["2008-11-13","Added 'Job Order Number' on 'Data Entry' sheet","DAW"]
["2008-11-13","Corrected procedure selection formula on 'Report Pages 1-3' worksheet","DAW"]
["2009-01-21","Converted to Excel 2007, updated links.","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-01-21","Reformatted colors and conditional formatting.","DAW"]
["2009-11-01","Deleted Tolerances worksheet, linked to Mass Tolerances workbook, and updated formulas in the Tolerance Lookup Table on the Tables and Lists worksheet.","DAW"]
["2009-11-01","Validated range names.","DAW"]
["2009-11-01","Validated workbook, file name \"WA2009-11-01 WAMRF-008 (Rev. 08), SOP 4 & 7 Workbook V&V.pdf\". Electronic copy on laboratory C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2010-09-27","Revised the Uncertainty Analysis worksheet and added Software Technical Assessment and SOP worksheets.","DAW"]
["2010-09-27","Validated range names.","DAW"]
["2010-09-27","Validated workbook, file name \"WA2010-09-27 WAMRF-008 (Rev. 09), SOP 4 & 7 Workbook V&V.pdf\". Electronic copy on laboratory C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-01-06","Reformatted Control Data worksheet.","DAW"]
["2012-01-06","Cleaned up formulas on Calculations worksheet cells H20, J20, H29, & J29.","DAW"]
["2012-01-06","Validated range names.","DAW"]
["2012-01-06","Validated workbook, file name \"WA2012-01-06 WAMRF-008 (Rev. 10), SOP 4 & 7 Workbook V&V.pdf\". Electronic copy on laboratory C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-02-24","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-24","Added SI statement and conversion factors on the Report Pages 1-3 spreadsheet."]
["2012-02-24","Validated range names.","DAW"]
["2012-02-24","Validated workbook, file name \"WA2012-02-24 WAMRF-008 (Rev. 11), SOP 4 & 7 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-08-13","Inserted new WSDA Logo on \"Report Pages 1-3\" worksheet.","DAW"]
["2012-09-15","Revised for SOP 4 only","DAW"]
["2012-09-15","Embedded 2012 SOP"]
["2012-09-15","Updated air density formula on CIPM Air Density worksheet","DAW"]
["2012-09-15","Modified Data Entry worksheet observations section and added degrees of freedom and best uncertainty k factor entries","DAW"]
["2012-09-15","Updated k factor based on degrees of freedom IAW SOP 29 (2012 edition)","DAW"]
["2012-09-15","Validated range names.","DAW"]
["2012-09-15","Validated workbook, file name \"WA2012-09-15 WAMRF-008 (Rev. 12), SOP 4 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2012-10-24","Corrected equation reference for tx combined density, Data Entry worksheet, cell I56, Sc combined density, Data Entry worksheet, cell J66 & tsc combined density, Data Entry worksheet, cell K72.","DAW"]
["2012-10-24","Validated range names.","DAW"]
["2012-10-24","Validated workbook, file name \"WA2012-10-24 WAMRF-008 (Rev. 13), SOP 4 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-008 (Rev. 14), SOP 4 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-12","Corrected and updated the uncertainty of the air buoyancy correction formula.","DAW"]
["2013-07-12","Updated input for and added the Welch-Satterthwaite formula for effective degrees of freedom.","DAW"]
["2013-07-12","Revised Data Entry, Control Data, Calculations and Uncertainty Analysis worksheets."]
["2013-07-12","Included essential information on Report page 4 ","DAW"]
["2013-07-12","Validated range names."]
["2013-07-12","Validated workbook, file name \"WA2013-07-12 WAMRF-008 (Rev. 15), SOP 4 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-06","Fixed the double substitution differences tests in cells J82 through J108 on the Data Entry spreadsheet.","DAW"]
["2013-08-06","Validated range names.","DAW"]
["2013-08-06","Validated workbook, file name \"WA2013-08-06 WAMRF-008 (Rev. 16), SOP 4 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-12","Corrected formulas in cells C46 & C47 on Calculations spreadsheet to correctly convert from milligrams to grams","DAW"]
["2013-08-12","Validated range names.","DAW"]
["2013-08-12","Validated workbook, file name \"WA2013-08-12 WAMRF-008 (Rev. 17), SOP 4 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-22","Corrected fomula for the Csc calculation on the Calculations worksheet.","DAW"]
["2013-08-22","Modified the Tolerance List and Units of Measure to fit the  OIML, ASTM & NIST specifications","DAW"]
["2013-08-22","Deleted Equal-Arm Balance Data sheet","DAW"]
["2013-08-22","Changed tolerance to maximum permissible error (MPE)","DAW"]
["2013-08-22","Validated range names.","DAW"]
["2013-08-22","Validated workbook, file name \"WA2013-08-22 WAMRF-008 (Rev. 18), SOP 4 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2014-05-07","Made Ub calculation an absolute in D135 of Uncertainty worksheet.","DAW"]
["2014-05-07","Defined nominal values in Report Page 4 worksheet.","DAW"]
["2014-10-29","Changed statistical df from 100 to 10000.","DAW"]
["2014-11-25","Updated bias test to the 2014 NISTIR 6969, SOP 29, paragraph 3.2.5.2","DAW"]
["2014-11-25","Created an evaluation of the standard deviation vs the balance resolution per NISTIR 6969, SOP 4, paragraph 5.2.2.","DAW"]
["2014-11-25","Embedded the NISTIR 6969, SOP 4 2014 version.","DAW"]
["2014-11-25","Corrected reference in effective degrees of freedom on Uncertainty worksheet. Changed H133^4/J134 to H133^4/J133."]
["2014-11-25","Moved uncertainty evaluation to Data Entry worksheet and added Precision Test.","DAW"]
["2014-11-25","Pa was defaulted to nominal (0.0012 g/cm³) so the uncertainty evaluation calculate before measurement are made.","DAW"]
["2014-11-25","Calculations, conditional formatting and wording for the Measurement Assurance evaluation were corrected.","DAW"]
["2014-11-25","Validated range names.","DAW"]
["2014-11-25","Validated workbook, file name \"WA2014-11-25 WAMRF-008 (Rev. 19), SOP 4 Workbook V&V.pdf\". Electronic copies in laboratory computer C:\\ drive and agency server H:\\ drive and paper copy in laboratory files.","DAW"]
["2015-02-04","Changed bias uncertainty distribution to ½ Rectangular","DAW"]
["2015-05-08","Fixed error in cell D129 on the Uncertainty Analysis worksheet. Sp was being multiplied by 1000 when unit is gram. Sp is always entered as mg on the Data Entry sheet.","DAW"]
["2015-05-08","Validated workbook, file name \"WA2015-05-08 WAMRF-008 (Rev. 20), SOP 4 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-09","Calculations worksheet lines 46 & 47 formula changed Px to Psc.","DAW"]
["2015-09-09","Corrected ub² addition to the uc calculation and changed to a normal distribution on the Uncertainty worksheet. Corrected the % Contribution and Effective Degrees of Freedom formulas for the ub².","DAW"]
["2015-09-09","Corrected formula in F28 on Calculations worksheet to subtract from check nominal (Sc) instead of unknown nominal for Check measurement and from the unknown nominal (Xnom) for a Duplicate measurement.","DAW"]
["2015-09-09","Added option on the Data Entry worksheet to select True or Conventional Mass for the Check Standard value.","DAW"]
["2015-09-09","Corrected formulas on Calculations worksheet for the Measurement Assurance calculations.","DAW"]
["2015-09-09","Corrected formulas on Control Data worksheet for the Check Standard values.","DAW"]
["2015-09-09","Updated duplicate measurement assurance to NISTIR 7383, SOP 17.","DAW"]
["2015-09-09","Renamed Pa1 to Pa_1.","DAW"]
["2015-09-09","Based the Component Impact graph on the Uncertainty Analysis worksheet on the component percentages.","DAW"]
["2015-09-09","Validated range names.","DAW"]
["2015-09-09","Validated workbook, file name \"WA2015-09-09 WAMRF-008 (Rev. 21), SOP 4 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-12","Corrected the uc formula in cell C112 on the Uncertainty Analysis worksheet for just the addition and not the squared addition of the u(b)².","DAW"]
["2015-10-12","Validated range names.","DAW"]
["2015-10-12","Validated workbook, file name \"WA2015-10-12 WAMRF-008 (Rev. 22), SOP 4 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","Changed 'Balance Description' to 'Balance ID' in cells F5 & F6 on the Control data worksheet.","DAW"]
["2015-11-06","Corrected the formulas in J89, J95 J105 & J 112 of the Data Entry worksheet from 'sp*2' to 'OR(sp*2,10*Resolution)'.","DAW"]
["2015-11-06","Validated range names.","DAW"]
["2015-11-06","Validated workbook, file name \"WA2015-11-06 WAMRF-008 (Rev. 23), SOP 4 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 J89, J95 J105 & J 112 of the Data Entry worksheet from 'OR(sp*2,10*Resolution)' to 'MAX(sp*2,10*Resolution)'.","DAW"]
["2015-12-23","Validated range names.","DAW"]
["2015-12-23","Validated workbook, file name \"WA2015-12-23 WAMRF-008 (Rev. 24), SOP 4 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 4","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"OIML Unc Estimates","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Instructions","index":4,"n_rows":167,"n_cols":2,"rows_kept":167,"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"]
[3,"The Check nominal value needs to be the same as the Standard nominal."]
[4,"Update Report worksheets with your laboratory information."]
[5,"Update all worksheet headers and the Report pages footers with your unique form numbers to make it part of your document system."]
[6,"Be sure to document all your changes on the Document worksheet."]
["Range Names"]
["Name","Range"]
["ABC","='Data Entry'!$J$20"]
["Balance","='Data Entry'!$E$15"]
["BalID","='Data Entry'!$C$15"]
["BalUnit","='Data Entry'!$J$15"]
["Best_df","='Data Entry'!$H$22"]
["Best_k","='Data Entry'!$J$22"]
["Best_U","='Data Entry'!$E$22"]
["Cal_Date","='Data Entry'!$C$24"]
["CIPM_Pa_found","='CIPM Air Density'!$D$7"]
["CIPM_Pa_left","='CIPM Air Density'!$D$13"]
["Class_Spec","='Data Entry'!$C$17"]
["Class_Spec_List","='Tables and Lists'!$A$4:$A$33"]
["Condition","='Data Entry'!$C$14"]
["ConvTable","='Tables and Lists'!$O$5:$W$16"]
["Cs","='Data Entry'!$D$43"]
["Csc","='Data Entry'!$D$65"]
["CsUnit","='Data Entry'!$D$39"]
["Csw","='Data Entry'!$D$60"]
["Cts","='Data Entry'!$D$50"]
["Ctsc","='Data Entry'!$D$71"]
["Ctx","='Data Entry'!$D$56"]
["CustomerID","='Data Entry'!$J$4"]
["Description","='Data Entry'!$C$10"]
["drift_or_Rmean","='Data Entry'!$F$20"]
["Final_k","='Uncertainty Analysis'!$I$145"]
["Final_U","='Uncertainty Analysis'!$I$146"]
["Final_Veff","='Uncertainty Analysis'!$I$144"]
["hr_1","='Data Entry'!$I$87"]
["hr_1_left","='Data Entry'!$I$103"]
["hr_2","='Data Entry'!$I$99"]
["hr_2_left","='Data Entry'!$I$109"]
["hr_3_left","='Data Entry'!$I$116"]
["hr_corr","='Data Entry'!$D$77"]
["hr_found","='CIPM Air Density'!$D$6"]
["hr_left","='CIPM Air Density'!$D$12"]
["ID","='Data Entry'!$C$13"]
["Interval","='Data Entry'!$J$23"]
["IntervalQ","='Data Entry'!$F$23"]
["JobNo","='Data Entry'!$I$14"]
["k","='Uncertainty Analysis'!$I$139"]
["k_hr","='Data Entry'!$H$77"]
["k_P","='Data Entry'!$H$76"]
["k_S","='Data Entry'!$F$43"]
["k_Sc","='Data Entry'!$H$65"]
["k_sw","='Data Entry'!$H$60"]
["k_t","='Data Entry'!$H$75"]
["k_ts","='Data Entry'!$H$50"]
["k_tsc","='Data Entry'!$H$71"]
["k_tx","='Data Entry'!$H$56"]
["LCL","=Calculations!$C$47"]
["Left_Start","='Data Entry'!$C$103"]
["Material","='Data Entry'!$I$13"]
["mcr","='Uncertainty Analysis'!$B$116"]
["Meas_Option","='Tables and Lists'!$C$4:$G$5"]
["MeasuredU","='Uncertainty Analysis'!$I$140"]
["Mfg","='Data Entry'!$C$11"]
["MPE","='Data Entry'!$I$17"]
["Ms","=Calculations!$C$18"]
["Msc","=Calculations!$C$20"]
["Msw","=Calculations!$C$23"]
["Mts","=Calculations!$C$19"]
["Mtsc","=Calculations!$C$21"]
["Mtx","=Calculations!$C$22"]
["Nom_Val_List","='Tables and Lists'!$O$4:$O$16"]
["Nx","='Data Entry'!$I$12"]
["Obs1_1","='Data Entry'!$G$89"]
["Obs1_2","='Data Entry'!$G$90"]
["Obs1_3","='Data Entry'!$G$91"]
["Obs1_4","='Data Entry'!$G$92"]
["Obs2_1","='Data Entry'!$G$95"]
["Obs2_2","='Data Entry'!$G$96"]
["Obs2_3","='Data Entry'!$G$97"]
["Obs2_4","='Data Entry'!$G$98"]
["Obs3_1","='Data Entry'!$G$105"]
["Obs3_2","='Data Entry'!$G$106"]
["Obs3_3","='Data Entry'!$G$107"]
["Obs3_4","='Data Entry'!$G$108"]
["Obs4_1","='Data Entry'!$G$112"]
["Obs4_2","='Data Entry'!$G$113"]
["Obs4_3","='Data Entry'!$G$114"]
["Obs4_4","='Data Entry'!$G$115"]
["Option","='Data Entry'!$I$18"]
["P_0","='Uncertainty Analysis'!$B$121"]
["P_1","='Data Entry'!$G$87"]
["P_1_left","='Data Entry'!$G$103"]
["P_2","='Data Entry'!$G$99"]
["P_2_left","='Data Entry'!$G$109"]
["P_3_left","='Data Entry'!$G$116"]
["P_corr","='Data Entry'!$D$76"]
["P_found","='CIPM Air Density'!$D$4"]
["P_left","='CIPM Air Density'!$D$10"]
["Pa","=Calculations!$C$9"]
["Pa_1","='Data Entry'!$J$43"]
["Pa_left","=Calculations!$C$15"]
["Pn","='Uncertainty Analysis'!$E$117"]
["PO_No","='Data Entry'!$H$5"]
["POC","='Data Entry'!$H$6"]
["POC_Phone","='Data Entry'!$H$7"]
["Pr","='Uncertainty Analysis'!$B$117"]
["Print_Titles","=Instructions!$8:$9"]
["Process","='Data Entry'!$C$18"]
["Ps","='Data Entry'!$H$43"]
["Psc","='Data Entry'!$J$65"]
["Psw","='Data Entry'!$J$60"]
["Pt","='Uncertainty Analysis'!$B$118"]
["Pts","='Data Entry'!$J$50"]
["Ptsc","='Data Entry'!$J$71"]
["Ptx","='Data Entry'!$J$56"]
["Px","='Data Entry'!$D$16"]
["Receive_Date","='Data Entry'!$I$11"]
["Resolution","='Data Entry'!$H$15"]
["Rpt_Units","='Data Entry'!$I$25"]
["RptNo","='Data Entry'!$H$1"]
["S","='Data Entry'!$B$43"]
["Sc","='Data Entry'!$B$65"]
["Sc_Meas_Option","='Tables and Lists'!$I$4:$M$5"]
["Sdf","='Data Entry'!$G$43"]
["SN","='Data Entry'!$C$12"]
["sp","='Data Entry'!$F$21"]
["sp_df","='Data Entry'!$J$21"]
["sp_unit","='Data Entry'!$A$21"]
["StUnit","='Data Entry'!$A$21"]
["sw","='Data Entry'!$B$60"]
["sw_df","='Data Entry'!$I$60"]
["sw_list","='Tables and Lists'!$W$4:$W$10"]
["t_1","='Data Entry'!$E$87"]
["t_1_left","='Data Entry'!$E$103"]
["t_2","='Data Entry'!$E$99"]
["t_2_left","='Data Entry'!$E$109"]
["t_3_left","='Data Entry'!$E$116"]
["t_corr","='Data Entry'!$D$75"]
["t_found","='CIPM Air Density'!$D$5"]
["t_left","='CIPM Air Density'!$D$11"]
["Tech","='Data Entry'!$F$24"]
["Tech_Int","='Data Entry'!$J$24"]
["TM_or_CM","='Data Entry'!$I$19"]
["ts","='Data Entry'!$B$50"]
["ts_df","='Data Entry'!$I$50"]
["tsc","='Data Entry'!$B$71"]
["tx","='Data Entry'!$B$56"]
["tx_df","='Data Entry'!$I$56"]
["U_hr","='Data Entry'!$F$77"]
["U_P","='Data Entry'!$F$76"]
["U_t","='Data Entry'!$F$75"]
["ub","='Uncertainty Analysis'!$B$125"]
["UCL","=Calculations!$C$46"]
["uPa","='Uncertainty Analysis'!$B$119"]
["uPr","='Data Entry'!$I$43"]
["uPt","='Data Entry'!$I$16"]
["Us","='Data Entry'!$E$43"]
["Usc","='Data Entry'!$F$65"]
["Usw","='Data Entry'!$F$60"]
["Uts","='Data Entry'!$F$50"]
["Utsc","='Data Entry'!$F$71"]
["Utx","='Data Entry'!$F$56"]
["Veff","='Uncertainty Analysis'!$I$138"]
["Xnom","='Data Entry'!$F$12"]

{"sheet":"Report Pages 1-3","index":5,"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],[65,0,65,6],[68,0,68,6],[71,0,71,6],[72,0,72,6],[76,0,76,6],[77,0,77,6],[78,0,78,6],[79,0,79,6],[80,0,80,6],[86,0,86,2],[86,3,86,4],[86,5,86,6],[87,0,87,2],[87,3,87,4],[87,5,87,6],[89,0,89,2],[89,5,89,6],[93,0,93,2],[93,5,93,6],[94,0,94,2],[94,5,94,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=\"\",\"\",Description)","v":""},null,null,"Date Received:",{"$f":"IF(Receive_Date=\"\",\"\",TEXT(Receive_Date,\"mmmm d, yyyy\"))","v":""}]
["Serial Number:",{"$f":"IF(SN=\"\",\"\",SN)","v":""},null,null,"ID/Asset Number:",{"$f":"IF(ID=\"\",\"\",ID)","v":""}]
["Manufacture:",{"$f":"IF(Mfg=\"\",\"\",Mfg)","v":""},null,null,"Class Specification:",{"$f":"IF(Class_Spec=\"\",\"\",Class_Spec)","v":""}]
["Condition:",{"$f":"IF(Condition=\"\",\"\",Condition)","v":""},null,null,"Material:",{"$f":"IF(Material=\"\",\"\",Material)","v":""}]
[]
["Calibration Information"]
["Job Order #:",{"$f":"IF(JobNo=\"\",\"\",JobNo)","v":""},null,null,"Temperature:",{"$f":"IF(t_found=\"\",\"\",IF(t_left=\"\",FIXED(t_found,1),FIXED(AVERAGE(t_found,t_left),1)))&\" ºC\"","v":" ºC"}]
["Metrologist:",{"$f":"IF(Tech=\"\",\"\",Tech)","v":""},null,null,"Pressure:",{"$f":"IF(P_found=\"\",\"\",IF(P_left=\"\",FIXED(P_found,1),FIXED(AVERAGE(P_found,P_left),1)))&\" mm Hg\"","v":" mm Hg"}]
["Procedure:",{"$f":"IF(Option=\"\",\"\",\"NIST IR 6969, SOP 4\")","v":""},null,null,"Humidity:",{"$f":"IF(hr_found=\"\",\"\",IF(hr_left=\"\",FIXED(hr_found,1),FIXED(AVERAGE(hr_found,hr_left),1)))&\" % RH\"","v":" % RH"}]
[]
["Laboratory Reference Standards Used"]
["Description",null,"Serial Number","Cert. Number",null,"Cal Date","Cal Due"]
[{"$f":"IF('Data Entry'!A30=\"\",\"\",'Data Entry'!A30)","v":""},null,{"$f":"IF('Data Entry'!C30=\"\",\"\",'Data Entry'!C30)","v":""},{"$f":"IF('Data Entry'!E30=\"\",\"\",'Data Entry'!E30)","v":""},null,{"$f":"IF('Data Entry'!G30=\"\",\"\",'Data Entry'!G30)","v":""},{"$f":"IF('Data Entry'!I30=\"\",\"\",'Data Entry'!I30)","v":""}]
[{"$f":"IF('Data Entry'!A31=\"\",\"\",'Data Entry'!A31)","v":""},null,{"$f":"IF('Data Entry'!C31=\"\",\"\",'Data Entry'!C31)","v":""},{"$f":"IF('Data Entry'!E31=\"\",\"\",'Data Entry'!E31)","v":""},null,{"$f":"IF('Data Entry'!G31=\"\",\"\",'Data Entry'!G31)","v":""},{"$f":"IF('Data Entry'!I31=\"\",\"\",'Data Entry'!I31)","v":""}]
[{"$f":"IF('Data Entry'!A32=\"\",\"\",'Data Entry'!A32)","v":""},null,{"$f":"IF('Data Entry'!C32=\"\",\"\",'Data Entry'!C32)","v":""},{"$f":"IF('Data Entry'!E32=\"\",\"\",'Data Entry'!E32)","v":""},null,{"$f":"IF('Data Entry'!G32=\"\",\"\",'Data Entry'!G32)","v":""},{"$f":"IF('Data Entry'!I32=\"\",\"\",'Data Entry'!I32)","v":""}]
[{"$f":"IF('Data Entry'!A33=\"\",\"\",'Data Entry'!A33)","v":""},null,{"$f":"IF('Data Entry'!C33=\"\",\"\",'Data Entry'!C33)","v":""},{"$f":"IF('Data Entry'!E33=\"\",\"\",'Data Entry'!E33)","v":""},null,{"$f":"IF('Data Entry'!G33=\"\",\"\",'Data Entry'!G33)","v":""},{"$f":"IF('Data Entry'!I33=\"\",\"\",'Data Entry'!I33)","v":""}]
[{"$f":"IF('Data Entry'!A34=\"\",\"\",'Data Entry'!A34)","v":""},null,{"$f":"IF('Data Entry'!C34=\"\",\"\",'Data Entry'!C34)","v":""},{"$f":"IF('Data Entry'!E34=\"\",\"\",'Data Entry'!E34)","v":""},null,{"$f":"IF('Data Entry'!G34=\"\",\"\",'Data Entry'!G34)","v":""},{"$f":"IF('Data Entry'!I34=\"\",\"\",'Data Entry'!I34)","v":""}]
[{"$f":"IF('Data Entry'!A35=\"\",\"\",'Data Entry'!A35)","v":""},null,{"$f":"IF('Data Entry'!C35=\"\",\"\",'Data Entry'!C35)","v":""},{"$f":"IF('Data Entry'!E35=\"\",\"\",'Data Entry'!E35)","v":""},null,{"$f":"IF('Data Entry'!G35=\"\",\"\",'Data Entry'!G35)","v":""},{"$f":"IF('Data Entry'!I35=\"\",\"\",'Data Entry'!I35)","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. Surface Roughness and Magnetic testing has not been performed, therefore, there are no components for the effects of either 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(s) listed above have been found and/or left within the maximum permissible error for the specification stated above, except as noted. An artifact is considered in-compliance when the correction plus the measurement uncertainty is equal to or less than the maximum permissible error. RED print indicates an out-of-compliance reading."]
["●  “Conventional Mass” (CM), also known as ‘apparent mass”, values stated in this report correlate to a scale verses 8.0 g/cm³ reference mass density and an air density of 1.2 mg/cm³ at 20 ºC. \"True mass\" values are based on an explicit treatment of displacement volumes."]
["●  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."]
[]
["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"]
["carat, metric",null,null,"to kilogram (kg)",null,"2.0 E-04"]
["grain (gr)",null,null,"to kilogram (kg)",null,"6.479 891 E-05"]
["ounce (avoirdupois) (oz)",null,null,"to kilogram (kg)",null,"2.834 952 E-02"]
["ounce (troy or apothecary) (oz)",null,null,"to kilogram (kg)",null,"3.110 348 E-02"]
["dram (apothecary) (dr)",null,null,"to kilogram (kg)",null,"3.8879346 E-03"]
["scruple (apothecary) (s)",null,null,"to kilogram (kg)",null,"1.2959782 E-03"]
["pennyweight (dwt)",null,null,"to kilogram (kg)",null,"1.555 174 E-03"]
["pound (avoirdupois) (lb)",null,null,"to kilogram (kg)",null,"4.535 923 7 E-01"]

{"sheet":"Report Page 4","index":6,"n_rows":9,"n_cols":11,"rows_kept":9,"merged":[[0,0,0,10]]}
["WSDA Weights and Measures Metrology Laboratory"]
[{"$f":"\"Report Number: \"&RptNo","v":"Report Number: "},{"$nulls":9},{"$f":"IF(Cal_Date=\"\",\"Calibration Date:\",\"Calibration Date: \"&TEXT(Cal_Date,\"mmmm d, yyyy\"))","v":"Calibration Date:"}]
[{"$f":"IF(Obs3_1=\"\",\"As Found / Left Calibration Results\",\"As Found Calibration Results\")","v":"As Found / Left Calibration Results"}]
["Nominal Mass","ID",{"$f":"IF(Nx=\"\",\"True Mass Correction\",IF(Rpt_Units=\"Nominal Value\",\"True Mass Correction (\"&Calculations!D55&\")\",\"True Mass Correction (\"&Calculations!D70&\")\"))","v":"True Mass Correction"},{"$f":"IF(Nx=\"\",\"Conventional Mass Correction\",IF(Rpt_Units=\"Nominal Value\",\"Conventional Mass Correction (\"&Calculations!D57&\")\",\"Conventional Mass Correction (\"&Calculations!D72&\")\"))","v":"Conventional Mass Correction"},{"$f":"IF(Nx=\"\",\"Uncertainty\",IF(Rpt_Units=\"Nominal Value\",\"Uncertainty ± (\"&Calculations!D61&\")\",\"Uncertainty ± (\"&Calculations!D76&\")\"))","v":"Uncertainty"},"k-factor","Degrees of Freedom",{"$f":"IF(Nx=\"\",\"MPE\",IF(Rpt_Units=\"Nominal Value\",Class_Spec&\" MPE ± (\"&Calculations!D62&\")\",Class_Spec&\" MPE ± (\"&Calculations!D77&\")\"))","v":"MPE"},"Assumed Density (g/cm³)","Uncertainty of Assumed Density (g/cm³)","Air Density (g/cm³)"]
[{"$f":"IF(Nx=\"\",\"\",Nx&\" \"&VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""},null,{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C55,Calculations!C70))","v":""},{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C57,Calculations!C72))","v":""},{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C61,Calculations!C76))","v":""},{"$f":"IF(Nx=\"\",\"\",Final_k)","v":""},{"$f":"IF(Nx=\"\",\"\",Final_Veff)","v":""},{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C62,Calculations!C77))","v":""},{"$f":"IF(Nx=\"\",\"\",Px)","v":""},{"$f":"IF(Nx=\"\",\"\",uPt)","v":""},{"$f":"IF(Nx=\"\",\"\",Pa)","v":""}]
[]
["As Left Calibration Results"]
["Nominal Mass","ID",{"$f":"IF(Nx=\"\",\"True Mass Correction\",IF(Rpt_Units=\"Nominal Value\",\"True Mass Correction (\"&Calculations!D56&\")\",\"True Mass Correction (\"&Calculations!D71&\")\"))","v":"True Mass Correction"},{"$f":"IF(Nx=\"\",\"Conventional Mass Correction\",IF(Rpt_Units=\"Nominal Value\",\"Conventional Mass Correction (\"&Calculations!D58&\")\",\"Conventional Mass Correction (\"&Calculations!D73&\")\"))","v":"Conventional Mass Correction"},{"$f":"IF(Nx=\"\",\"Uncertainty\",IF(Rpt_Units=\"Nominal Value\",\"Uncertainty ± (\"&Calculations!D61&\")\",\"Uncertainty ± (\"&Calculations!D76&\")\"))","v":"Uncertainty"},"k-factor","Degrees of Freedom",{"$f":"IF(Nx=\"\",\"Tolerance\",IF(Rpt_Units=\"Nominal Value\",Class_Spec&\" Tolerance ± (\"&Calculations!D62&\")\",Class_Spec&\" Tolerance ± (\"&Calculations!D77&\")\"))","v":"Tolerance"},"Assumed Density (g/cm³)","Uncertainty of Assumed Density (g/cm³)","Air Density (g/cm³)"]
[{"$f":"IF(Nx=\"\",\"\",Nx&\" \"&VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""},null,{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C56,Calculations!C71))","v":""},{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C58,Calculations!C73))","v":""},{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C61,Calculations!C76))","v":""},{"$f":"IF(Nx=\"\",\"\",Final_k)","v":""},{"$f":"IF(Nx=\"\",\"\",Final_Veff)","v":""},{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Nominal Value\",Calculations!C62,Calculations!C77))","v":""},{"$f":"IF(Nx=\"\",\"\",Px)","v":""},{"$f":"IF(Nx=\"\",\"\",uPt)","v":""},{"$f":"IF(Nx=\"\",\"\",Pa_left)","v":""}]

{"sheet":"Data Entry","index":7,"n_rows":116,"n_cols":10,"rows_kept":116,"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,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,4,14,5],[15,0,15,2],[15,3,15,4],[15,5,15,7],[15,8,15,9],[16,0,16,1],[16,2,16,4],[16,5,16,7],[16,8,16,9],[17,0,17,1],[17,2,17,5],[17,6,17,7],[17,8,17,9],[18,0,18,7],[18,8,18,9],[19,0,19,4],[19,5,19,6],[19,7,19,8],[20,0,20,4],[20,5,20,6],[20,7,20,8],[21,0,21,3],[21,4,21,5],[22,0,22,4],[22,6,22,8],[23,0,23,1],[23,2,23,3],[23,5,23,7],[24,0,24,7],[24,8,24,9],[27,0,27,9],[28,0,28,1],[28,2,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[33,0,33,1],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[34,0,34,1],[34,2,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[37,0,37,9],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,0,43,9],[44,1,44,2],[44,3,44,4],[44,5,44,6],[45,1,45,2],[45,3,45,4],[45,5,45,6],[46,1,46,2],[46,3,46,4],[46,5,46,6],[47,1,47,2],[47,3,47,4],[47,5,47,6],[48,1,48,2],[48,3,48,4],[48,5,48,6],[49,1,49,2],[49,3,49,4],[49,5,49,6],[50,0,50,9],[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],[56,0,56,9],[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],[60,0,60,9],[61,1,61,2],[61,3,61,4],[61,5,61,6],[62,1,62,2],[62,3,62,4],[62,5,62,6],[63,1,63,2],[63,3,63,4],[63,5,63,6],[64,1,64,2],[64,3,64,4],[64,5,64,6],[65,0,65,9],[66,1,66,2],[66,3,66,4],[66,5,66,6],[67,1,67,2],[67,3,67,4],[67,5,67,6],[68,1,68,2],[68,3,68,4],[68,5,68,6],[69,1,69,2],[69,3,69,4],[69,5,69,6],[70,1,70,2],[70,3,70,4],[70,5,70,6],[73,0,73,2],[73,3,73,4],[73,5,73,6],[73,7,73,8],[74,0,74,2],[74,3,74,4],[74,5,74,6],[74,7,74,8],[75,0,75,2],[75,3,75,4],[75,5,75,6],[75,7,75,8],[76,0,76,2],[76,3,76,4],[76,5,76,6],[76,7,76,8],[78,0,78,9],[79,0,79,9],[80,3,80,4],[80,6,81,9],[81,3,81,4],[82,3,82,4],[82,6,82,9],[85,9,87,9],[86,0,86,1],[87,0,87,2],[87,3,87,5],[87,6,87,7],[88,0,88,2],[88,3,88,5],[88,6,88,8],[88,9,91,9],[89,0,89,2],[89,3,89,5],[89,6,89,8],[90,0,90,2],[90,3,90,5],[90,6,90,8],[91,0,91,2],[91,3,91,5],[91,6,91,8],[92,9,93,9],[93,0,93,2],[93,3,93,5],[93,6,93,7],[94,0,94,2],[94,3,94,5],[94,6,94,8],[94,9,97,9],[95,0,95,2],[95,3,95,5],[95,6,95,8],[96,0,96,2],[96,3,96,5],[96,6,96,8],[97,0,97,2],[97,3,97,5],[97,6,97,8],[98,0,98,1],[99,0,99,9],[101,9,103,9],[102,0,102,1],[103,0,103,2],[103,3,103,5],[103,6,103,7],[104,0,104,2],[104,3,104,5],[104,6,104,8],[104,9,107,9],[105,0,105,2],[105,3,105,5],[105,6,105,8],[106,0,106,2],[106,3,106,5],[106,6,106,8],[107,0,107,2],[107,3,107,5],[107,6,107,8],[108,0,108,1],[110,0,110,2],[110,3,110,5],[110,6,110,7],[111,0,111,2],[111,3,111,5],[111,6,111,8],[111,9,114,9],[112,0,112,2],[112,3,112,5],[112,6,112,8],[113,0,113,2],[113,3,113,5],[113,6,113,8],[114,0,114,2],[114,3,114,5],[114,6,114,8],[115,0,115,1],[116,0,116,9]]}
["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"]
["Manufacture",{"$nulls":4},"Date Received"]
["Serial Number",{"$nulls":4},"Nominal Value (pick from list)"]
["ID/Asset Number",{"$nulls":4},"Artifact Material"]
["Artifact Condition",{"$nulls":4},"Job Order Number"]
["Balance ID",null,null,"Balance",null,null,"Resolution",null,"Bal Unit"]
["Assumed Density (g/cm³)",{"$nulls":4},"Unc. Of Assumed Density (g/cm³)"]
["Class Specification",{"$nulls":4},"Maximum Permissible Error (mg)"]
["Measurement Type",{"$nulls":5},"Measurement Option"]
["What are your Control Chart values based on, True or Conventional Mass?"]
[{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"Standard Drift as indicated on the Control Chart (mg)\",\"Not Applicable for Duplicate Measurements\"))","v":""},{"$nulls":6},"Use SOP 2 ABC?"]
[{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"Process Standard Deviation for Balance (mg)\",\"Pooled Standard Deviation of the Replicates (mg)\"))","v":""},{"$nulls":6},"Degrees of Freedom"]
[{"$f":"IF(BalUnit=\"\",\"Accredited U (e.g, NVLAP,A2LA, etc.)\",IF(BalUnit=\"g\",\"Accredited U (e.g, NVLAP,A2LA, etc.) (g)\",\"Accredited U (e.g, NVLAP, A2LA, etc.) (mg)\"))","v":"Accredited U (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"]
["Reported corrections and uncertainty in nominal value units or metric units?"]
[]
["Standards Used"]
["Note: If the 'Calibration Due' date turns RED the standard calibration is void, calibrate before use."]
["Description",null,"Serial Number",null,"Report Number",null,"Calibration Date",null,"Calibration Due"]
{"$rows_empty":7}
["Mass Standard(s) Data"]
["Enter the information for the reference weight(s) (S)"]
["Std ID","Nominal Mass (g)",null,{"$f":"IF(ABC=\"\",\"Correction (mg)\",IF(ABC=\"Yes\",\"True Mass Correction (mg)\",\"CM Correction (mg)\"))","v":"Correction (mg)"},"Us (mg)","k factor","Degrees of Freedom (df)","Density (g/cm³)","u(ρr) (g/cm³) k=1","ρa1 (g/cm³)"]
["S1"]
["S2"]
["S3"]
["S =",{"$f":"IF(B40=\"\",\"\",SUM(B40:B42))","v":""},null,{"$f":"IF(B40=\"\",\"\",SUM(D40:D42))","v":""},{"$f":"IF(B40=\"\",\"\",IF(AND(ISNUMBER(B40),B41=\"\"),E40/F40,IF(AND(ISNUMBER(B40),ISNUMBER(B41),B42=\"\"),SUM(E40/F40+E41/F41),SUM(E40/F40+E41/F41+E42/F42))))","v":""},{"$f":"IF(B40=\"\",\"\",1)","v":""},{"$f":"IF(B40=\"\",\"\",IF(AND(B41=\"\",B42=\"\"),G40,IF(AND(ISNUMBER(B40),ISNUMBER(B41),B42=\"\"),ROUNDDOWN(SQRT(((E40/F40)*G40^2+(E41/F41)*G41^2)/SUM((E40/F40)+(E41/F41))),0),ROUNDDOWN(SQRT(((E40/F40)*G40^2+(E41/F41)*G41^2+(E42/F42)*G42^2)/SUM((E40/F40)+(E41/F41)+(E42/F42))),0))))","v":""},{"$f":"IF(B40=\"\",\"\",IF(AND(ISNUMBER(B40),B41=\"\"),H40,IF(AND(ISNUMBER(B40),ISNUMBER(B41),B42=\"\"),(S+Cs/1000)/((B40+D40/1000)/H40+(B41+D41/1000)/H41),(S+Cs/1000)/((B40+D40/1000)/H40+(B41+D41/1000)/H41+(B42+D42/1000)/H42))))","v":""},{"$f":"IF(B40=\"\",\"\",IF(AND(ISNUMBER(B40),B41=\"\"),I40,IF(AND(ISNUMBER(B40),ISNUMBER(B41),B42=\"\"),(S+Cs/1000)/((B40+D40/1000)/I40+(B41+D41/1000)/I41),(S+Cs/1000)/((B40+D40/1000)/I40+(B41+D41/1000)/I41+(B42+D42/1000)/I42))))","v":""},{"$f":"IF(B40=\"\",\"\",AVERAGE(J40:J42))","v":""}]
["Enter the information for the tare weight(s) (ts)"]
["Std ID","Nominal Mass (g)",null,{"$f":"IF(ABC=\"\",\"Correction (mg)\",IF(ABC=\"Yes\",\"True Mass Correction (mg)\",\"CM Correction (mg)\"))","v":"Correction (mg)"},null,"Uncertainty (mg)",null,"k factor","Degrees of Freedom (df)","Density (g/cm³)"]
["ts1"]
["ts2"]
["ts3"]
["ts4"]
["ts =",{"$f":"IF(B46=\"\",\"\",SUM(B46:B49))","v":""},null,{"$f":"IF(B46=\"\",\"\",SUM(D46:E49))","v":""},null,{"$f":"IF(B46=\"\",\"\",IF(AND(ISNUMBER(B46),B47=\"\"),F46/H46,IF(AND(ISNUMBER(B46),ISNUMBER(B47),B48=\"\"),SUM(F46/H46+F47/H47),IF(AND(ISNUMBER(B46),ISNUMBER(B47),ISNUMBER(B48),B49=\"\"),SUM(F46/H46+F47/H47+F48/H48),SUM(F46/H46+F47/H47+F48/H48+F49/H49)))))","v":""},null,{"$f":"IF(B46=\"\",\"\",1)","v":""},{"$f":"IF(B46=\"\",\"\",IF(AND(B47=\"\",B48=\"\",B49=\"\"),I46,IF(AND(ISNUMBER(B46),ISNUMBER(B47),B48=\"\",B49=\"\"),ROUNDDOWN(SQRT(((F46/H46)*I46^2+(F47/H47)*I47^2)/SUM((F46/H46)+(F47/H47))),0),IF(AND(ISNUMBER(B46),ISNUMBER(B47),ISNUMBER(B48),B49=\"\"),ROUNDDOWN(SQRT(((F46/H46)*I46^2+(F47/H47)*I47^2+(F48/H48)*I48^2)/SUM((F46/H46)+(F47/H47)+(F48/H48))),0),ROUNDDOWN(SQRT(((F46/H46)*I46^2+(F47/H47)*I47^2+(F48/H48)*I48^2+(F49/H49)*I49^2)/SUM((F46/H46)+(F47/H47)+(F48/H48)+(F49/H49))),0)))))","v":""},{"$f":"IF(B46=\"\",1,IF(AND(ISNUMBER(B46),B47=\"\"),J46,IF(AND(ISNUMBER(B46),ISNUMBER(B47),B48=\"\"),(ts+Cts/1000)/((B46+D46/1000)/J46+(B47+D47/1000)/J47),IF(AND(ISNUMBER(B46),ISNUMBER(B47),ISNUMBER(B48),B49=\"\"),(ts+Cts/1000)/((B46+D46/1000)/J46+(B47+D47/1000)/J47+(B48+D48/1000)/J48),(ts+Cts/1000)/((B46+D46/1000)/J46+(B47+D47/1000)/J47+(B48+D48/1000)/J48+(B49+D49/1000)/J49)))))","v":1}]
["Enter the information  for the tare weight(s) (tx)"]
["tx1"]
["tx2"]
["tx3"]
["tx4"]
["tx =",{"$f":"IF(B52=\"\",\"\",SUM(B52:B55))","v":""},null,{"$f":"IF(B52=\"\",\"\",SUM(D52:E55))","v":""},null,{"$f":"IF(B52=\"\",\"\",IF(AND(ISNUMBER(B52),B53=\"\"),F52/H52,IF(AND(ISNUMBER(B52),ISNUMBER(B53),B54=\"\"),SUM(F52/H52+F53/H53),IF(AND(ISNUMBER(B52),ISNUMBER(B53),ISNUMBER(B54),B55=\"\"),SUM(F52/H52+F53/H53+F54/H54),SUM(F52/H52+F53/H53+F54/H54+F55/H55)))))","v":""},null,{"$f":"IF(B52=\"\",\"\",1)","v":""},{"$f":"IF(B52=\"\",\"\",IF(AND(B53=\"\",B54=\"\",B55=\"\"),I52,IF(AND(ISNUMBER(B52),ISNUMBER(B53),B54=\"\",B55=\"\"),ROUNDDOWN(SQRT(((F52/H52)*I52^2+(F53/H53)*I53^2)/SUM((F52/H52)+(F53/H53))),0),IF(AND(ISNUMBER(B52),ISNUMBER(B53),ISNUMBER(B54),B55=\"\"),ROUNDDOWN(SQRT(((F52/H52)*I52^2+(F53/H53)*I53^2+(F54/H54)*I54^2)/SUM((F52/H52)+(F53/H53)+(F54/H54))),0),ROUNDDOWN(SQRT(((F52/H52)*I52^2+(F53/H53)*I53^2+(F54/H54)*I54^2+(F55/H55)*I55^2)/SUM((F52/H52)+(F53/H53)+(F54/H54)+(F55/H55))),0)))))","v":""},{"$f":"IF(B52=\"\",1,IF(AND(ISNUMBER(B52),B53=\"\"),J52,IF(AND(ISNUMBER(B52),ISNUMBER(B53),B54=\"\"),(tx+Ctx/1000)/((B52+D52/1000)/J52+(B53+D53/1000)/J53),IF(AND(ISNUMBER(B52),ISNUMBER(B53),ISNUMBER(B54),B55=\"\"),(tx+Ctx/1000)/((B52+D52/1000)/J52+(B53+D53/1000)/J53+(B54+D54/1000)/J54),(tx+Ctx/1000)/((B52+D52/1000)/J52+(B53+D53/1000)/J53+(B54+D54/1000)/J54+(B55+D55/1000)/J55)))))","v":1}]
["Enter the 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":""}]
["Enter the information  for the control standard weight(s) (Sc)"]
["Sc1"]
["Sc2"]
["Sc3"]
["Sc =",{"$f":"IF(B62=\"\",\"\",SUM(B62:B64))","v":""},null,{"$f":"IF(B62=\"\",\"\",SUM(D62:E64))","v":""},null,{"$f":"IF(B62=\"\",\"\",IF(AND(ISNUMBER(B62),B63=\"\"),F62/H62,IF(AND(ISNUMBER(B62),ISNUMBER(B63),B64=\"\"),SUM(F62/H62+F63/H63),SUM(F62/H62+F63/H63+F64/H64))))","v":""},null,{"$f":"IF(B62=\"\",\"\",1)","v":""},null,{"$f":"IF(B62=\"\",\"\",IF(AND(ISNUMBER(B62),B63=\"\"),J62,IF(AND(ISNUMBER(B62),ISNUMBER(B63),B64=\"\"),(Sc+Csc/1000)/((B62+D62/1000)/J62+(B63+D63/1000)/J63),(Sc+Csc/1000)/((B62+D62/1000)/J62+(B63+D63/1000)/J63+(B64+D64/1000)/J64))))","v":""}]
["Enter the information  for the tare weight(s) carried with the control standard weight(s) (tsc)"]
["tsc1"]
["tsc2"]
["tsc3"]
["tsc4"]
["tsc =",{"$f":"IF(B67=\"\",\"\",SUM(B67:B70))","v":""},null,{"$f":"IF(B67=\"\",\"\",SUM(D67:E70))","v":""},null,{"$f":"IF(B67=\"\",\"\",IF(AND(ISNUMBER(B67),B68=\"\"),F67/H67,IF(AND(ISNUMBER(B67),ISNUMBER(B68),B69=\"\"),SUM(F67/H67+F68/H68),IF(AND(ISNUMBER(B67),ISNUMBER(B68),ISNUMBER(B69),B70=\"\"),SUM(F67/H67+F68/H68+F69/H69),SUM(F67/H67+F68/H68+F69/H69+F70/H70)))))","v":""},null,{"$f":"IF(B67=\"\",\"\",1)","v":""},null,{"$f":"IF(B67=\"\",1,IF(AND(ISNUMBER(B67),B68=\"\"),J67,IF(AND(ISNUMBER(B67),ISNUMBER(B68),B69=\"\"),(tsc+Ctsc/1000)/((B67+D67/1000)/J67+(B68+D68/1000)/J68),IF(AND(ISNUMBER(B67),ISNUMBER(B68),ISNUMBER(B69),B70=\"\"),(tsc+Ctsc/1000)/((B67+D67/1000)/J67+(B68+D68/1000)/J68+(B69+D69/1000)/J69),(tsc+Ctsc/1000)/((B67+D67/1000)/J67+(B68+D68/1000)/J68+(B69+D69/1000)/J69+(B70+D70/1000)/J70)))))","v":1}]
[]
["Environmental Standard(s) Data"]
["Parameter",null,null,"Correction",null,"Uncertainty",null,"k factor",null,"Unit"]
["Temperature (t)",{"$nulls":8},"ºC"]
["Barometric Pressure (P)",{"$nulls":8},"mm Hg"]
["Humidity (hr)",{"$nulls":8},"% RH"]
[]
["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 of \"&Class_Spec&\" mpe =\"","v":"1/3 of  mpe ="},{"$f":"IF(MPE=\"\",\"\",IF(Class_Spec=\"Not Specified\",\"N/A\",IF(BalUnit=\"g\",MPE/1000,MPE)))","v":""},null,{"$f":"IF(OR(BalUnit=\"\",Class_Spec=\"Not Specified\"),\"\",BalUnit)","v":""},{"$f":"IF(OR(Class_Spec=\"Not Specified\",D81=\"\"),\"\",IF(D82<D81,\"The Uncertainty Meets the Criteria, Continue Measurements & Report Findings.\",\"The Uncertainty Does Not Meet the Criteria! Use a Different Balance or SOP\"))","v":""}]
[null,null,"Expanded Uncertainty =",{"$f":"IF(MPE=\"\",\"\",IF(BalUnit=\"g\",Final_U,Final_U*1000))","v":""},null,{"$f":"IF(BalUnit=\"\",\"\",BalUnit)","v":""}]
[null,null,"Precision Test (Pn) =",{"$f":"IF(D81=\"\",\"\",D82/D81)","v":""},null,null,{"$f":"IF(D81=\"\",\"\",IF(D83<0.8,\"Precision Test is less than 1, Passed\",IF(AND(D83>=0.8,D83<1),\"Precision Test is less than 1, Passed but high\",IF(D83>1,\"Precision Test is greater than 1, Failed\"))))","v":""}]
[]
["As Found Measurements"]
[{"$f":"\"Artifact Measurement \"&Option","v":"Artifact Measurement "},{"$nulls":8},{"$f":"IF(Obs1_4=\"\",\"\",\"SOP 4, 2.5.2.5 Check\")","v":""}]
["Start Time",null,null,"t (ºC)",null,"P (mm Hg)",null,"hr (% RH)"]
["Observation No.",null,null,"Weights",null,null,"Balance Units:",null,{"$f":"IF(BalUnit=\"\",\"\",BalUnit)","v":""}]
[1,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,2,FALSE))","v":""},{"$nulls":5},{"$f":"IF(Obs1_4=\"\",\"\",IF(AND(BalUnit=\"g\",ABS((Obs1_2-Obs1_1)-(Obs1_3-Obs1_4))*1000<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"mg\",ABS((Obs1_2-Obs1_1)-(Obs1_3-Obs1_4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
[2,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,3,FALSE))","v":""}]
[3,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,4,FALSE))","v":""}]
[4,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,5,FALSE))","v":""}]
[{"$f":"IF(Option=\"\",\"Duplicate Measurement\",IF(Process=\"Duplicate Measurements\",\"Duplicate Measurement \"&Option,\"Measurement Assurance \"&Option))","v":"Duplicate Measurement"}]
["Observation No.",null,null,"Weights",null,null,"Balance Units:",null,{"$f":"IF(BalUnit=\"\",\"\",BalUnit)","v":""}]
[1,null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Duplicate Measurements\",VLOOKUP(Option,Meas_Option,2,FALSE),VLOOKUP(Option,Sc_Meas_Option,2,FALSE)))","v":""},{"$nulls":5},{"$f":"IF(Obs2_4=\"\",\"\",IF(AND(BalUnit=\"g\",ABS((Obs2_2-Obs2_1)-(Obs2_3-Obs2_4))*1000<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"mg\",ABS((Obs2_2-Obs2_1)-(Obs2_3-Obs2_4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
[2,null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Duplicate Measurements\",VLOOKUP(Option,Meas_Option,3,FALSE),VLOOKUP(Option,Sc_Meas_Option,3,FALSE)))","v":""}]
[3,null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Duplicate Measurements\",VLOOKUP(Option,Meas_Option,4,FALSE),VLOOKUP(Option,Sc_Meas_Option,4,FALSE)))","v":""}]
[4,null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Duplicate Measurements\",VLOOKUP(Option,Meas_Option,5,FALSE),VLOOKUP(Option,Sc_Meas_Option,5,FALSE)))","v":""}]
["Finish Time",null,null,"t (ºC)",null,"P (mm Hg)",null,"hr (% RH)"]
[]
["As Left Measurements"]
[{"$f":"\"Artifact Measurement \"&Option","v":"Artifact Measurement "},{"$nulls":8},{"$f":"IF(Obs3_4=\"\",\"\",\"SOP 4, 2.5.2.5 Check\")","v":""}]
["Start Time",null,null,"t (ºC)",null,"P (mm Hg)",null,"hr (% RH)"]
["Observation No.",null,null,"Weights",null,null,"Balance Units:",null,{"$f":"IF(BalUnit=\"\",\"\",BalUnit)","v":""}]
[1,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,2,FALSE))","v":""},{"$nulls":5},{"$f":"IF(Obs3_4=\"\",\"\",IF(AND(BalUnit=\"g\",ABS((Obs3_2-Obs3_1)-(Obs3_3-Obs3_4))*1000<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"mg\",ABS((Obs3_2-Obs3_1)-(Obs3_3-Obs3_4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
[2,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,3,FALSE))","v":""}]
[3,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,4,FALSE))","v":""}]
[4,null,null,{"$f":"IF(Option=\"\",\"\",VLOOKUP(Option,Meas_Option,5,FALSE))","v":""}]
[{"$f":"IF(Process=\"Duplicate Measurements\",\"\",\"Finish Time\")","v":"Finish Time"},null,null,{"$f":"IF(Process=\"Duplicate Measurements\",\"\",\"t (ºC)\")","v":"t (ºC)"},null,{"$f":"IF(Process=\"Duplicate Measurements\",\"\",\"P (mm Hg)\")","v":"P (mm Hg)"},null,{"$f":"IF(Process=\"Duplicate Measurements\",\"\",\"hr (% RH)\")","v":"hr (% RH)"}]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"Duplicate Measurement \"&Option)","v":"Duplicate Measurement "}]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"Observation No.\")","v":"Observation No."},null,null,{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"Weights\")","v":"Weights"},null,null,{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"Balance Units:\")","v":"Balance Units:"},null,{"$f":"IF(OR(BalUnit=\"\",Process=\"Check Standard Measurement\"),\"\",BalUnit)","v":""}]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"1\")","v":"1"},null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"\",VLOOKUP(Option,Meas_Option,2,FALSE)))","v":""},{"$nulls":5},{"$f":"IF(Obs4_4=\"\",\"\",IF(AND(BalUnit=\"g\",ABS((Obs4_2-Obs4_1)-(Obs4_3-Obs4_4))*1000<MAX(2*sp,10*Resolution)),\"GO\",IF(AND(BalUnit=\"mg\",ABS((Obs4_2-Obs4_1)-(Obs4_3-Obs4_4))<MAX(2*sp,10*Resolution)),\"GO\",\"REPEAT\")))","v":""}]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"2\")","v":"2"},null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"\",VLOOKUP(Option,Meas_Option,3,FALSE)))","v":""}]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"3\")","v":"3"},null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"\",VLOOKUP(Option,Meas_Option,4,FALSE)))","v":""}]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"4\")","v":"4"},null,null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"\",VLOOKUP(Option,Meas_Option,5,FALSE)))","v":""}]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"Finsh Time\")","v":"Finsh Time"},null,null,{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"t (ºC)\")","v":"t (ºC)"},null,{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"P (mm Hg)\")","v":"P (mm Hg)"},null,{"$f":"IF(Process=\"Check Standard Measurement\",\"\",\"hr (% RH)\")","v":"hr (% RH)"}]

{"sheet":"Control Data","index":8,"n_rows":11,"n_cols":13,"rows_kept":11,"merged":[[1,0,1,12]]}
["Control Chart Information",{"$nulls":11},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Note: Copy and Paste Appropriate Row(s) to Control Chart"]
[]
["X-Chart Information"]
[null,"Technician Initials","Date","Report Number",{"$f":"IF(TM_or_CM=\"Conventional Mass\",\"Csc vs 8.0 (\"&BalUnit&\")\",\"Csc (\"&BalUnit&\")\")","v":"Csc ()"},"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)"]
[null,{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",Tech_Int)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",Cal_Date)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",RptNo)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"g\"),Calculations!F30,IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"mg\"),Calculations!F30*1000,IF(AND(TM_or_CM=\"True Mass\",BalUnit=\"g\"),Calculations!F28,Calculations!F28*1000))))","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",BalID)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",t_1)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",t_2)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",P_1)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",P_2)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",hr_1)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Duplicate Measurements\"),\"\",hr_2)","v":""}]
[]
["R-Chart Information"]
[null,"Technician Initials","Date","Report Number",{"$f":"IF(TM_or_CM=\"Conventional Mass\",\"Cx vs 8.0 (corr. 1)\n(\"&BalUnit&\")\",\"Cx (corr. 1)\n(\"&BalUnit&\")\")","v":"Cx (corr. 1)\n()"},{"$f":"IF(TM_or_CM=\"Conventional Mass\",\"Cx vs 8.0 (corr. 2)\n(\"&BalUnit&\")\",\"Cx (corr. 2)\n(\"&BalUnit&\")\")","v":"Cx (corr. 2)\n()"},"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)"]
["As Found",{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",Tech_Int)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",Cal_Date)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",RptNo)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"g\"),Calculations!C30,IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"mg\"),Calculations!C30*1000,IF(AND(TM_or_CM=\"True Mass\",BalUnit=\"g\"),Calculations!C28,Calculations!C28*1000))))","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"g\"),Calculations!F30,IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"mg\"),Calculations!F30*1000,IF(AND(TM_or_CM=\"True Mass\",BalUnit=\"g\"),Calculations!F28,Calculations!F28*1000))))","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",BalID)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",t_1)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",t_2)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",P_1)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",P_2)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",hr_1)","v":""},{"$f":"IF(OR(Process=\"\",Process=\"Check Standard Measurement\"),\"\",hr_2)","v":""}]
["As Left",{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",Tech_Int)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",Cal_Date)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",RptNo)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"g\"),Calculations!C35,IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"mg\"),Calculations!C35*1000,IF(AND(TM_or_CM=\"True Mass\",BalUnit=\"g\"),Calculations!C33,Calculations!C33*1000))))","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"g\"),Calculations!F35,IF(AND(TM_or_CM=\"Conventional Mass\",BalUnit=\"mg\"),Calculations!F35*1000,IF(AND(TM_or_CM=\"True Mass\",BalUnit=\"g\"),Calculations!F33,Calculations!F33*1000))))","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",BalID)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",t_1_left)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",t_3_left)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",P_1_left)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",P_3_left)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",hr_1_left)","v":""},{"$f":"IF(OR(Obs3_1=\"\",Process=\"Check Standard Measurement\"),\"\",hr_3_left)","v":""}]

{"sheet":"Calculations","index":9,"n_rows":81,"n_cols":7,"rows_kept":81,"merged":[[3,0,3,6],[4,0,4,5],[10,0,10,5],[37,0,37,6],[38,4,40,6],[41,4,41,6],[44,0,44,6],[45,4,47,6],[48,4,48,6],[51,0,51,6],[52,0,52,6],[67,0,67,6]]}
["Calculations",{"$nulls":5},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Air Density Calculation"]
["Air density results are rounded to 9 digits (g/cm³)"]
["As Found Air Density"]
[null,"tAVERAGE =",{"$f":"IF(t_found=\"\",\"\",t_found)","v":""},"ºC"]
[null,"PAVERAGE =",{"$f":"IF(P_found=\"\",\"\",P_found)","v":""},"mm Hg"]
[null,"hrAVERAGE =",{"$f":"IF(hr_found=\"\",\"\",hr_found)","v":""},"% RH"]
[null,"ρa =",{"$f":"IF(CIPM_Pa_found=\"\",0.0012,ROUND(CIPM_Pa_found/1000,9))","v":0.0012},"g/cm³"]
[]
["As Left Air Density"]
[null,"tAVERAGE =",{"$f":"IF(t_left=\"\",\"\",t_left)","v":""},"ºC"]
[null,"PAVERAGE =",{"$f":"IF(P_left=\"\",\"\",P_left)","v":""},"mm Hg"]
[null,"hrAVERAGE =",{"$f":"IF(hr_left=\"\",\"\",hr_left)","v":""},"% RH"]
[null,"ρa =",{"$f":"IF(CIPM_Pa_left=\"\",\"\",ROUND(CIPM_Pa_left/1000,9))","v":""},"g/cm³"]
[]
[{"$f":"IF(ABC=\"Yes\",\"Standard(s) True Mass Values\",\"Standard(s) Conventionals\")","v":"Standard(s) Conventionals"}]
[null,{"$f":"IF(ABC=\"Yes\",\"Reference Standard (Ms) =\",\"Reference Standard (CMs) =\")","v":"Reference Standard (CMs) ="},{"$f":"IF(S=\"\",\"\",S+Cs/1000)","v":""},"g"]
[null,{"$f":"IF(ABC=\"Yes\",\"Tare w/Reference Standard (Mts) =\",\"Tare w/Reference Standard (CMts) =\")","v":"Tare w/Reference Standard (CMts) ="},{"$f":"IF(S=\"\",\"\",IF(ts=\"\",0,ts+Cts/1000))","v":""},"g"]
[null,{"$f":"IF(ABC=\"Yes\",\"Check Standard (Msc) =\",\"Check Standard (CMsc) =\")","v":"Check Standard (CMsc) ="},{"$f":"IF(Sc=\"\",\"\",Sc+Csc/1000)","v":""},"g"]
[null,{"$f":"IF(ABC=\"Yes\",\"Tare w/Check Standard (Mtsc) =\",\"Tare w/Check Standard (CMtsc) =\")","v":"Tare w/Check Standard (CMtsc) ="},{"$f":"IF(Sc=\"\",\"\",IF(tsc=\"\",0,tsc+Ctsc/1000))","v":""},"g"]
[null,{"$f":"IF(ABC=\"Yes\",\"Tare w/Unknown Weight (Mtx) =\",\"Tare w/Unknown Weight (CMtx) =\")","v":"Tare w/Unknown Weight (CMtx) ="},{"$f":"IF(S=\"\",\"\",IF(tx=\"\",0,tx+Ctx/1000))","v":""},"g"]
[null,{"$f":"IF(ABC=\"Yes\",\"Sensitivity Weight (Msw) =\",\"Sensitivity Weight (CMsw) =\")","v":"Sensitivity Weight (CMsw) ="},{"$f":"IF(sw=\"\",\"\",sw+Csw/1000)","v":""},"g"]
[]
["Measurement Calculations"]
["As Found Determinations",{"$nulls":3},{"$f":"IF(Process=\"Duplicate Measurements\",\"As Found Duplicate Determinations\",\"Check Standard Determinations\")","v":"Check Standard Determinations"}]
[null,"Mx =",{"$f":"IF(OR(ABC=\"\",ABC=\"No\"),\"\",IF(Option=\"Option A (SXXS)\",(Ms*(1-Pa/Ps)+Mts*(1-Pa/Pts)-Mtx*(1-Pa/Px)+((((Obs1_2-Obs1_1)+(Obs1_3-Obs1_4))/2)*((Msw*(1-Pa/Psw))/(Obs1_3-Obs1_2))))/(1-(Pa/Px)),(Ms*(1-Pa/Ps)+Mts*(1-Pa/Pts)-Mtx*(1-Pa/Px)+((((Obs1_1-Obs1_2)+(Obs1_4-Obs1_3))/2)*((Msw*(1-Pa/Psw))/(Obs1_3-Obs1_2))))/(1-(Pa/Px))))","v":""},"g",{"$f":"IF(Process=\"Duplicate Measurements\",\"Mx =\",\"Msc\")","v":"Msc"},{"$f":"IF(OR(ABC=\"\",ABC=\"No\"),\"\",IF(AND(Process=\"Check Standard Measurement\",Option=\"Option A (SXXS)\"),(Ms*(1-Pa/Ps)+Mts*(1-Pa/Pts)-Mtsc*(1-Pa/Psc)+((((Obs2_2-Obs2_1)+(Obs2_3-Obs2_4))/2)*((Msw*(1-Pa/Psw))/(Obs2_3-Obs2_2))))/(1-(Pa/Psc)),IF(AND(Process=\"Check Standard Measurement\",Option=\"Option B (XSSX)\"),(Ms*(1-Pa/Ps)+Mts*(1-Pa/Pts)-Mtsc*(1-Pa/Psc)+((((Obs2_1-Obs2_2)+(Obs2_4-Obs2_3))/2)*((Msw*(1-Pa/Psw))/(Obs2_3-Obs2_2))))/(1-(Pa/Psc)),IF(AND(Process=\"Duplicate Measurements\",Option=\"Option A (SXXS)\"),(Ms*(1-Pa/Ps)+Mts*(1-Pa/Pts)-Mtx*(1-Pa/Px)+((((Obs2_2-Obs2_1)+(Obs2_3-Obs2_4))/2)*((Msw*(1-Pa/Psw))/(Obs2_3-Obs2_2))))/(1-(Pa/Px)),(Ms*(1-Pa/Ps)+Mts*(1-Pa/Pts)-Mtx*(1-Pa/Px)+((((Obs2_1-Obs2_2)+(Obs2_4-Obs2_3))/2)*((Msw*(1-Pa/Psw))/(Obs2_3-Obs2_2))))/(1-(Pa/Px))))))","v":""},"g"]
[null,"Cx =",{"$f":"IF(OR(ABC=\"\",ABC=\"No\"),\"\",C27-VLOOKUP(Xnom,ConvTable,2,FALSE))","v":""},"g",{"$f":"IF(Process=\"Duplicate Measurements\",\"Cx =\",\"Csc\")","v":"Csc"},{"$f":"IF(OR(ABC=\"\",ABC=\"No\"),\"\",IF(Process=\"Check Standard Measurement\",F27-Sc,F27-VLOOKUP(Xnom,ConvTable,2,FALSE)))","v":""},"g"]
[null,"CMx vs 8.0 g/cm³ =",{"$f":"IF(ABC=\"\",\"\",IF(ABC=\"Yes\",(C27*(1-(0.0012/Px)))/0.99985,IF(AND(ABC=\"No\",Option=\"Option A (SXXS)\"),Ms+Mts-Mtx+((((Obs1_2-Obs1_1)+(Obs1_3-Obs1_4))/2)*((Msw)/(Obs1_3-Obs1_2))),Ms+Mts-Mtx+((((Obs1_1-Obs1_2)+(Obs1_4-Obs1_3))/2)*((Msw)/(Obs1_3-Obs1_2))))))","v":""},"g",{"$f":"IF(Process=\"Duplicate Measurements\",\"CMx vs 8.0 g/cm³ =\",\"CMsc vs 8.0 g/cm³ =\")","v":"CMsc vs 8.0 g/cm³ ="},{"$f":"IF(ABC=\"\",\"\",IF(AND(ABC=\"Yes\",Process=\"Check Standard Measurement\"),(F27*(1-(0.0012/Psc)))/0.99985,IF(AND(ABC=\"Yes\",Process=\"Duplicate Measurements\"),(F27*(1-(0.0012/Px)))/0.99985,IF(AND(ABC=\"No\",Process=\"Check Standard Measurement\",Option=\"Option A (SXXS)\"),Ms+Mts-Mtsc+((((Obs2_2-Obs2_1)+(Obs2_3-Obs2_4))/2)*((Msw)/(Obs2_3-Obs2_2))),IF(AND(ABC=\"No\",Process=\"Check Standard Measurement\",Option=\"Option B (XSSX)\"),Ms+Mts-Mtsc+((((Obs2_1-Obs2_2)+(Obs2_4-Obs2_3))/2)*((Msw)/(Obs2_3-Obs2_2))),IF(AND(ABC=\"No\",Process=\"Duplicate Measurements\",Option=\"Option A (SXXS)\"),Ms+Mts-Mtx+((((Obs2_2-Obs2_1)+(Obs2_3-Obs2_4))/2)*((Msw)/(Obs2_3-Obs2_2))),Ms+Mts-Mtx+((((Obs2_1-Obs2_2)+(Obs2_4-Obs2_3))/2)*((Msw)/(Obs2_3-Obs2_2)))))))))","v":""},"g"]
[null,"Cx vs 8.0 g/cm³ =",{"$f":"IF(ABC=\"\",\"\",C29-VLOOKUP(Xnom,ConvTable,2,FALSE))","v":""},"g",{"$f":"IF(Process=\"Duplicate Measurements\",\"Cx vs 8.0 g/cm³ =\",\"Csc vs 8.0 g/cm³ =\")","v":"Csc vs 8.0 g/cm³ ="},{"$f":"IF(ABC=\"\",\"\",IF(Process=\"Check Standard Measurement\",F29-Sc,F29-VLOOKUP(Xnom,ConvTable,2,FALSE)))","v":""},"g"]
["As Left Determinations",{"$nulls":3},{"$f":"IF(Process=\"Duplicate Measurements\",\"As Left Duplicate Determinations\",\"\")","v":""}]
[null,{"$f":"IF(Obs3_1=\"\",\"\",\"Mx =\")","v":""},{"$f":"IF(OR(ABC=\"No\",Obs3_1=\"\"),\"\",IF(AND(ABC=\"Yes\",Option=\"Option A (SXXS)\"),(Ms*(1-Pa_left/Ps)+Mts*(1-Pa_left/Pts)-Mtx*(1-Pa_left/Px)+((((Obs3_2-Obs3_1)+(Obs3_3-Obs3_4))/2)*((Msw*(1-Pa_left/Psw))/(Obs3_3-Obs3_2))))/(1-(Pa_left/Px)),(Ms*(1-Pa_left/Ps)+Mts*(1-Pa_left/Pts)-Mtx*(1-Pa_left/Px)+((((Obs3_1-Obs3_2)+(Obs3_4-Obs3_3))/2)*((Msw*(1-Pa_left/Psw))/(Obs3_3-Obs3_2))))/(1-(Pa_left/Px))))","v":""},{"$f":"IF(Obs3_1=\"\",\"\",\"g\")","v":""},{"$f":"IF(Obs4_1=\"\",\"\",IF(Process=\"Duplicate Measurements\",\"Mx =\",\"\"))","v":""},{"$f":"IF(OR(Obs4_1=\"\",Process=\"Check Standard Measurement\",ABC=\"No\"),\"\",IF(Option=\"Option A (SXXS)\",(Ms*(1-Pa_left/Ps)+Mts*(1-Pa_left/Pts)-Mtx*(1-Pa_left/Px)+((((Obs4_2-Obs4_1)+(Obs4_3-Obs4_4))/2)*((Msw*(1-Pa_left/Psw))/(Obs4_3-Obs4_2))))/(1-(Pa_left/Px)),(Ms*(1-Pa_left/Ps)+Mts*(1-Pa_left/Pts)-Mtx*(1-Pa_left/Px)+((((Obs4_1-Obs4_2)+(Obs4_4-Obs4_3))/2)*((Msw*(1-Pa_left/Psw))/(Obs4_3-Obs4_2))))/(1-(Pa_left/Px))))","v":""},{"$f":"IF(Obs4_1=\"\",\"\",IF(Process=\"Duplicate Measurements\",\"g\",\"\"))","v":""}]
[null,{"$f":"IF(Obs3_1=\"\",\"\",\"Cx =\")","v":""},{"$f":"IF(OR(ABC=\"No\",Obs3_1=\"\"),\"\",C32-VLOOKUP(Xnom,ConvTable,2,FALSE))","v":""},"g",{"$f":"IF(Obs4_1=\"\",\"\",IF(Process=\"Duplicate Measurements\",\"Cx =\",\"\"))","v":""},{"$f":"IF(OR(Obs4_1=\"\",Process=\"Check Standard Measurement\",ABC=\"No\"),\"\",F32-VLOOKUP(Xnom,ConvTable,2,FALSE))","v":""},"g"]
[null,{"$f":"IF(Obs3_1=\"\",\"\",\"CMx vs 8.0 g/cm³ =\")","v":""},{"$f":"IF(Obs3_1=\"\",\"\",IF(ABC=\"Yes\",(C32*(1-(0.0012/Px)))/0.99985,IF(AND(ABC=\"No\",Option=\"Option A (SXXS)\"),Ms+Mts-Mtx+((((Obs3_2-Obs3_1)+(Obs3_3-Obs3_4))/2)*((Msw)/(Obs3_3-Obs3_2))),Ms+Mts-Mtx+((((Obs3_1-Obs3_2)+(Obs3_4-Obs3_3))/2)*((Msw)/(Obs3_3-Obs3_2))))))","v":""},{"$f":"IF(Obs3_1=\"\",\"\",\"g\")","v":""},{"$f":"IF(Obs4_1=\"\",\"\",IF(Process=\"Duplicate Measurements\",\"CMx vs 8.0 g/cm³ =\",\"\"))","v":""},{"$f":"IF(OR(Obs4_1=\"\",Process=\"Check Standard Measurement\"),\"\",IF(ABC=\"Yes\",(F32*(1-(0.0012/Px)))/0.99985,IF(AND(ABC=\"No\",Option=\"Option A (SXXS)\"),Ms+Mts-Mtx+((((Obs4_2-Obs4_1)+(Obs4_3-Obs4_4))/2)*((Msw)/(Obs4_3-Obs4_2))),Ms+Mts-Mtx+((((Obs4_1-Obs4_2)+(Obs4_4-Obs4_3))/2)*((Msw)/(Obs4_3-Obs4_2))))))","v":""},{"$f":"IF(Obs4_1=\"\",\"\",IF(Process=\"Duplicate Measurements\",\"g\",\"\"))","v":""}]
[null,{"$f":"IF(Obs3_1=\"\",\"\",\"Cx vs 8.0 g/cm³ =\")","v":""},{"$f":"IF(Obs3_1=\"\",\"\",C34-VLOOKUP(Xnom,ConvTable,2,FALSE))","v":""},"g",{"$f":"IF(Obs4_1=\"\",\"\",IF(Process=\"Duplicate Measurements\",\"Cx vs 8.0 g/cm³ =\",\"\"))","v":""},{"$f":"IF(OR(Obs4_1=\"\",Process=\"Check Standard Measurement\"),\"\",F34-VLOOKUP(Xnom,ConvTable,2,FALSE))","v":""},"g"]
[]
["Maximum Permissible Error 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. (NIST HB 105-1, ASTM E 617 & OIML R 111)"]
[null,{"$f":"Class_Spec&\" MPE (\"&CHAR(177)&\") =\"","v":" MPE (±) ="},{"$f":"IF(MPE=\"\",\"\",IF(Class_Spec=\"Not Specified\",\"N/A\",IF(BalUnit=\"g\",MPE/1000,MPE)))","v":""},{"$f":"IF(OR(BalUnit=\"\",Class_Spec=\"Not Specified\"),\"\",BalUnit)","v":""},{"$f":"IF(OR(Nx=\"\",Class_Spec=\"Not Specified\"),\"\",IF(ABS(C41)<=ABS(C39-C40),\"The As Found Conventional Mass Is IN-COMPLIANCE\",\"The As Found Conventional Mass Is OUT-OF-COMPLIANCE, Adjust And Re-Test\"))","v":""}]
[null,{"$f":"IF(Class_Spec=\"Not Specified\",\"\",\"Expanded Uncertainty (\"&CHAR(177)&\") =\")","v":"Expanded Uncertainty (±) ="},{"$f":"IF(OR(Class_Spec=\"Not Specified\",Final_U=\"\"),\"\",IF(BalUnit=\"g\",Final_U,Final_U*1000))","v":""},{"$f":"IF(OR(BalUnit=\"\",Class_Spec=\"Not Specified\"),\"\",BalUnit)","v":""}]
[null,{"$f":"IF(Class_Spec=\"Not Specified\",\"\",\"As Found Cx vs 8.0 =\")","v":"As Found Cx vs 8.0 ="},{"$f":"IF(OR(Class_Spec=\"Not Specified\",Obs1_1=\"\"),\"\",IF(AND(BalUnit=\"g\",Process=\"Check Standard Measurement\"),C30,IF(AND(BalUnit=\"g\",Process=\"Duplicate Measurements\"),AVERAGE(C30,F30),IF(AND(BalUnit=\"mg\",Process=\"Check Standard Measurement\"),C30*1000,AVERAGE(C30,F30)*1000))))","v":""},{"$f":"IF(OR(BalUnit=\"\",Class_Spec=\"Not Specified\"),\"\",BalUnit)","v":""}]
[null,{"$f":"IF(OR(Class_Spec=\"Not Specified\",Obs4_1=\"\"),\"\",\"As Left Cx vs 8.0 =\")","v":""},{"$f":"IF(OR(Class_Spec=\"Not Specified\",Obs4_1=\"\"),\"\",IF(AND(BalUnit=\"g\",Process=\"Check Standard Measurement\"),C35,IF(AND(BalUnit=\"g\",Process=\"Duplicate Measurements\"),AVERAGE(C35,F35),IF(AND(BalUnit=\"mg\",Process=\"Check Standard Measurement\"),C35*1000,AVERAGE(C35,F35)*1000))))","v":""},{"$f":"IF(OR(Class_Spec=\"Not Specified\",Obs4_1=\"\"),\"\",BalUnit)","v":""},{"$f":"IF(OR(Class_Spec=\"Not Specified\",Obs4_1=\"\"),\"\",IF(ABS(C42)<=ABS(C39-C40),\"The As Left Conventional Mass Is IN-COMPLIANCE\",\"The As Left Conventional Mass Is OUT-OF-COMPLIANCE, Adjust And Re-Test\"))","v":""}]
[]
["Measurement Assurance Evaluations"]
[{"$f":"IF(Process=\"Check Standard Measurement\",\"Criteria: If a plotted point is outside the warning limits but within the control limits, investigate the presence of calculation errors. If none were made, re-measure the check standard.(NISTIR 6969, SOP 9, paragraph 4.1.2)\",\"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)\")","v":"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,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"Upper Warning Limit =\",\"Control Limit =\"))","v":""},{"$f":"IF(Process=\"\",\"\",IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"Conventional Mass\"),Msc*(1-(0.0012/Psc))/0.99985-Sc+drift_or_Rmean/1000+2*sp/1000,IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"True Mass\"),Msc-Sc+drift_or_Rmean/1000+2*sp/1000,sp/1000*3)))","v":""},{"$f":"IF(Process=\"\",\"\",\"g\")","v":""},{"$f":"IF(Process=\"\",\"\",IF(AND(Process=\"Check Standard Measurement\",OR(C48>UCL,C48<LCL)),\"The Check Standard Is Outside The Warning Limits, Investigate The Problem, Then Redo The Measurements As Necessary\",IF(AND(Process=\"Check Standard Measurement\",OR(C48<=UCL,C48>=LCL)),\"The Check Standard Is In Control, Plot The Value On The Control Chart\",IF(AND(Process=\"Duplicate Measurements\",C48>UCL),\"The Standard Deviation Is Outside The Control Limits, Investigate The Problem, Then Redo The Measurements\",IF(AND(Process=\"Duplicate Measurements\",C48<=LCL),\"The Standard Deviation Is In Control, Plot The Value On The Control Chart\",IF(AND(Process=\"Duplicate Measurements\",C48>LCL,C48<=UCL),\"The Standard Deviation Is outside the Warning Limit but inside the Control Limit, Investigate The Problem, Then Redo The Measurements As Necessary\"))))))","v":""}]
[null,{"$f":"IF(Process=\"\",\"\",IF(Process=\"Check Standard Measurement\",\"Lower Warning Limit =\",\"Warning Limit =\"))","v":""},{"$f":"IF(Process=\"\",\"\",IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"Conventional Mass\"),Msc*(1-(0.0012/Psc))/0.99985-Sc+drift_or_Rmean/1000-2*sp/1000,IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"True Mass\"),Msc-Sc+drift_or_Rmean/1000-2*sp/1000,sp/1000*2)))","v":""},{"$f":"IF(Process=\"\",\"\",\"g\")","v":""}]
[null,{"$f":"IF(Process=\"\",\"\",IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"Conventional Mass\"),\"Csc vs 8.0 =\",IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"True Mass\"),\"Csc =\",\"As Found Standard Deviation =\")))","v":""},{"$f":"IF(Process=\"\",\"\",IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"Conventional Mass\"),F30,IF(AND(Process=\"Check Standard Measurement\",TM_or_CM=\"True Mass\"),F28,IF(AND(Process=\"Duplicate Measurements\",TM_or_CM=\"Conventional Mass\"),STDEV(C30,F30),STDEV(C28,F28)))))","v":""},{"$f":"IF(Process=\"\",\"\",\"g\")","v":""}]
[null,{"$f":"IF(OR(Process=\"\",Obs4_1=\"\",Process=\"Check Standard Measurement\"),\"\",\"As Left Standard Deviation =\")","v":""},{"$f":"IF(OR(Process=\"\",Obs4_1=\"\",Process=\"Check Standard Measurement\"),\"\",IF(TM_or_CM=\"Conventional Mass\",STDEV(C35,F35),STDEV(C33,F33)))","v":""},{"$f":"IF(OR(Process=\"\",Obs4_1=\"\",Process=\"Check Standard Measurement\"),\"\",\"g\")","v":""},{"$f":"IF(OR(Process=\"\",Obs4_1=\"\",Process=\"Check Standard Measurement\"),\"\",IF(C49>UCL,\"The Standard Deviation Is Outside The Control Limits, Investigate The Problem, Then Redo The Measurements As Necessary\",IF(C49<=LCL,\"The Standard Deviation Is In Control, Plot The Value On The Control Chart\",IF(AND(C49>LCL,C49<=UCL),\"The Standard Deviation Is outside the Warning Limit but inside the Control Limit, Investigate The Problem, Then Redo The Measurements As Necessary\"))))","v":""}]
[]
["Report Conventional Mass Correction and Uncertainty (uc*k) As Follows:"]
["Mass corrections and uncertainties are rounded according to NISTIR 6969, GLP 9"]
["Mass Values in Nominal Value Units"]
[null,"Nominal Value =",{"$f":"IF(Nx=\"\",\"\",Nx)","v":""},{"$f":"IF(Nx=\"\",\"\",VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""}]
[null,"As Found True Mass Correction (Cx) =",{"$f":"IF(OR(ABC=\"No\",ABC=\"\"),\"\",FIXED(VLOOKUP(Xnom,ConvTable,3,FALSE)-Nx,2-1-INT(LOG10(ABS(VLOOKUP(Xnom,ConvTable,7,FALSE)))),TRUE))","v":""},{"$f":"IF(OR(ABC=\"No\",ABC=\"\"),\"\",VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""}]
[null,"As Left True Mass Correction (Cx) =",{"$f":"IF(OR(ABC=\"No\",C33=\"\"),\"\",FIXED(VLOOKUP(Xnom,ConvTable,4,FALSE)-Nx,2-1-INT(LOG10(ABS(VLOOKUP(Xnom,ConvTable,7,FALSE)))),TRUE))","v":""},{"$f":"IF(OR(ABC=\"No\",ABC=\"\"),\"\",VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""}]
[null,"As Found Conventional Mass Correction =",{"$f":"IF(Nx=\"\",\"\",FIXED(VLOOKUP(Xnom,ConvTable,5,FALSE)-Nx,2-1-INT(LOG10(ABS(VLOOKUP(Xnom,ConvTable,7,FALSE)))),TRUE))","v":""},{"$f":"IF(Nx=\"\",\"\",VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""}]
[null,"As Left Conventional Mass Correction =",{"$f":"IF(OR(Obs3_1=\"\",C35=\"\"),\"\",FIXED(VLOOKUP(Xnom,ConvTable,6,FALSE)-Nx,2-1-INT(LOG10(ABS(VLOOKUP(Xnom,ConvTable,7,FALSE)))),TRUE))","v":""},{"$f":"IF(Nx=\"\",\"\",VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""}]
[null,"Effective Degrees of Freedom =",{"$f":"IF(Final_Veff=\"\",\"\",Final_Veff)","v":""}]
[null,"k factor =",{"$f":"IF(Final_k=\"\",\"\",Final_k)","v":""}]
[null,"Uncertainty (uc*k) =",{"$f":"IF(Nx=\"\",\"\",FIXED(VLOOKUP(Xnom,ConvTable,7,FALSE),2-1-INT(LOG10(ABS(VLOOKUP(Xnom,ConvTable,7,FALSE)))),TRUE))","v":""},{"$f":"IF(Nx=\"\",\"\",VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""}]
[null,{"$f":"Class_Spec&\" MPE (\"&CHAR(177)&\") =\"","v":" MPE (±) ="},{"$f":"IF(Nx=\"\",\"\",IF(Class_Spec=\"Not Specified\",\"N/A\",FIXED(VLOOKUP(Xnom,ConvTable,8,FALSE),2-1-INT(LOG10(ABS(VLOOKUP(Xnom,ConvTable,7,FALSE)))),TRUE)))","v":""},{"$f":"IF(OR(Class_Spec=\"Not Specified\",Nx=\"\"),\"\",VLOOKUP(Xnom,ConvTable,9,FALSE))","v":""}]
[null,"Assumed Density =",{"$f":"IF(Px=\"\",\"\",Px)","v":""},"g/cm³"]
[null,"Uncertainty of Assumed Density =",{"$f":"IF(uPt=\"\",\"\",uPt)","v":""},"g/cm³"]
[null,"As Found Air Density =",{"$f":"IF(Pa=\"\",\"\",Pa)","v":0.0012},"g/cm³"]
[null,"As Left Air Density =",{"$f":"IF(Pa_left=\"\",\"\",Pa_left)","v":""},"g/cm³"]
[]
["Mass Values in Metric Units"]
[null,"Nominal Value =",{"$f":"IF(Nx=\"\",\"\",VLOOKUP(Xnom,ConvTable,2,FALSE))","v":""},{"$f":"IF(Nx=\"\",\"\",\"g\")","v":""}]
[null,"As Found True Mass Correction (Cx) =",{"$f":"IF(C28=\"\",\"\",IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Check Standard Measurement\"),FIXED(C28*1000,2-1-INT(LOG10(ABS($C$76))),TRUE),IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Duplicate Measurements\"),FIXED(AVERAGE(C28*1000,F28*1000),2-1-INT(LOG10(ABS($C$76))),TRUE),IF(OR(Rpt_Units=\"Nominal Value\",AND(Rpt_Units=\"Metric (g)\",Process=\"Check Standard Measurement\")),FIXED(C28,2-1-INT(LOG10(ABS($C$76))),TRUE),FIXED(AVERAGE(C28,F28),2-1-INT(LOG10(ABS($C$76))),TRUE)))))","v":""},{"$f":"IF(Rpt_Units=\"\",\"\",IF(Rpt_Units=\"Metric (mg)\",\"mg\",\"g\"))","v":""}]
[null,"As Left True Mass Correction (Cx) =",{"$f":"IF(C33=\"\",\"\",IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Check Standard Measurement\"),FIXED(C33*1000,2-1-INT(LOG10(ABS($C$76))),TRUE),IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Duplicate Measurements\"),FIXED(AVERAGE(C33*1000,F33*1000),2-1-INT(LOG10(ABS($C$76))),TRUE),IF(OR(Rpt_Units=\"Nominal Value\",AND(Rpt_Units=\"Metric (g)\",Process=\"Check Standard Measurement\")),FIXED(C33,2-1-INT(LOG10(ABS($C$76))),TRUE),FIXED(AVERAGE(C33,F33),2-1-INT(LOG10(ABS($C$76))),TRUE)))))","v":""},{"$f":"IF(Rpt_Units=\"\",\"\",IF(Rpt_Units=\"Metric (mg)\",\"mg\",\"g\"))","v":""}]
[null,"As Found Conventional Mass Correction =",{"$f":"IF(C30=\"\",\"\",IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Check Standard Measurement\"),FIXED(C30*1000,2-1-INT(LOG10(ABS($C$76))),TRUE),IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Duplicate Measurements\"),FIXED(AVERAGE(C30,F30)*1000,2-1-INT(LOG10(ABS($C$76))),TRUE),IF(OR(Rpt_Units=\"Nominal Value\",AND(Rpt_Units=\"Metric (g)\",Process=\"Check Standard Measurement\")),FIXED(C30,2-1-INT(LOG10(ABS($C$76))),TRUE),FIXED(AVERAGE(C30,F30),2-1-INT(LOG10(ABS($C$76))),TRUE)))))","v":""},{"$f":"IF(Rpt_Units=\"\",\"\",IF(Rpt_Units=\"Metric (mg)\",\"mg\",\"g\"))","v":""}]
[null,"As Left Conventional Mass Correction =",{"$f":"IF(C35=\"\",\"\",IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Check Standard Measurement\"),FIXED(C35*1000,2-1-INT(LOG10(ABS($C$76))),TRUE),IF(AND(Rpt_Units=\"Metric (mg)\",Process=\"Duplicate Measurements\"),FIXED(AVERAGE(C35,F35)*1000,2-1-INT(LOG10(ABS($C$76))),TRUE),IF(OR(Rpt_Units=\"Nominal Value\",AND(Rpt_Units=\"Metric (g)\",Process=\"Check Standard Measurement\")),FIXED(C35,2-1-INT(LOG10(ABS($C$76))),TRUE),FIXED(AVERAGE(C35,F35),2-1-INT(LOG10(ABS($C$76))),TRUE)))))","v":""},{"$f":"IF(Rpt_Units=\"\",\"\",IF(Rpt_Units=\"Metric (mg)\",\"mg\",\"g\"))","v":""}]
[null,"Effective Degrees of Freedom =",{"$f":"IF(Nx=\"\",\"\",Final_Veff)","v":""}]
[null,"k factor =",{"$f":"IF(Nx=\"\",\"\",Final_k)","v":""}]
[null,"Uncertainty (uc*k) =",{"$f":"IF(Nx=\"\",\"\",IF(Rpt_Units=\"Metric (mg)\",FIXED(Final_U,2-1-INT(LOG10(ABS(Final_U))),TRUE)*1000,FIXED(Final_U,2-1-INT(LOG10(ABS(Final_U))),TRUE)))","v":""},{"$f":"IF(Rpt_Units=\"\",\"\",IF(Rpt_Units=\"Metric (mg)\",\"mg\",\"g\"))","v":""}]
[null,{"$f":"Class_Spec&\" MPE (\"&CHAR(177)&\") =\"","v":" MPE (±) ="},{"$f":"IF(MPE=\"\",\"\",IF(Class_Spec=\"Not Specified\",\"N/A\",IF(Rpt_Units=\"Metric (mg)\",FIXED(MPE/1000,2-1-INT(LOG10(ABS(Final_U))),TRUE)*1000,FIXED(MPE/1000,2-1-INT(LOG10(ABS(Final_U))),TRUE))))","v":""},{"$f":"IF(OR(Class_Spec=\"Not Specified\",Rpt_Units=\"\"),\"\",IF(Rpt_Units=\"Metric (mg)\",\"mg\",\"g\"))","v":""}]
[null,"Assumed Density =",{"$f":"IF(Px=\"\",\"\",Px)","v":""},"g/cm³"]
[null,"Uncertainty of Assumed Density =",{"$f":"IF(Px=\"\",\"\",uPt)","v":""},"g/cm³"]
[null,"As Found Air Density =",{"$f":"IF(Pa=\"\",\"\",Pa)","v":0.0012},"g/cm³"]
[null,"As Left Air Density =",{"$f":"IF(Pa_left=\"\",\"\",Pa_left)","v":""},"g/cm³"]

{"sheet":"Uncertainty Analysis","index":10,"n_rows":146,"n_cols":10,"rows_kept":146,"merged":[[0,2,0,3],[89,0,89,9],[93,1,93,4],[93,5,93,8],[94,1,94,4],[94,5,94,9],[95,1,95,4],[95,5,95,9],[96,1,96,4],[96,5,96,9],[97,1,97,4],[97,5,97,9],[98,1,98,4],[98,5,98,9],[99,1,99,4],[99,5,99,9],[100,1,100,4],[100,5,100,9],[101,1,101,4],[101,5,101,9],[102,1,102,4],[102,5,102,9],[103,1,103,4],[103,5,103,9],[104,1,104,4],[104,5,104,9],[105,1,105,4],[105,5,105,9],[106,1,106,4],[106,5,106,9],[110,0,110,9],[111,0,111,1],[111,3,112,9],[112,0,112,1],[127,0,127,1],[128,0,128,1],[129,0,129,1],[130,0,130,1],[131,0,131,1],[132,0,132,1],[133,0,133,1],[134,0,134,1],[135,0,135,1]]}
["Uncertainty Analysis",{"$nulls":8},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Specify Procedure"]
["NISTIR 6969, SOP 4,Weighing by Double Substitution"]
[]
["Specify Equation(s)"]
["Double Substitution Optional Sequence A (SXXS) w/o Air Buoyancy Correction"]
[]
["Double Substitution Optional Sequence B (XSSX) w/o Air Buoyancy Correction"]
[]
["Double Substitution Optional Sequence A (SXXS) with Air Buoyancy Correction"]
[]
["Double Substitution Optional Sequence B (XSSX) with Air Buoyancy Correction"]
[]
["Conventional Mass"]
[]
["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"]
["M =","the mass (true mass) of a specific weight.  Subscripts s, x, t, sw are used to identify the weight (equals Nominal plus Correction)"]
["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"]
["ρn =","density of normal air (1.2 kg/m³)"]
["ρ =","density of masses; subscripts s, x, ts, tx, sw are used to identify the weight"]
[]
["CIPM 2007 Air Density Formula, NISTIR 6969, SOP 2, Paragraph 8.2, Option B"]
[]
[]
[]
[]
[]
["where"]
[" Mv =","18.015 28 (17) x 10-3 kg m-3"]
[" Ma =","molar mass of the air within laboratory 28.965 46 x 10-3 kg/mol"]
["p =","ambient barometric pressure in Pascal"]
["T =","ambient temperature in Kelvin"]
["R =","universal gas constant: 8.314 472 J mol-1 K-1"]
["h =","relative humidity in %"]
["f =","1.000 62 + (3.14 x 10-8) p + (5.16 x 10-7) t2"]
["t =","ambient temperature in degrees Celsius"]
["ρsv =","1 Pascal x exp (AT2 + BT + C + D/T)"]
["A =","1.237 884 7 x 10-5 K-2"]
["B =","-1.912 131 6 x 10-2 K-1"]
["C =","33.937 110 47"]
["D =","-6.343 164 5 x 103 K"]
["a0 =","1.581 23 x 10-6 K Pa-1"]
["a1 =","-2.933 1 x 10-8 Pa-1"]
["a2 =","1.104 3 x 10-10 K-1 Pa-1"]
["b0 =","5.707 x 10-6 K Pa-1"]
["b1 =","-2.051 x 10-8 Pa-1"]
["c0 =","1.989 8 x 10-4 K Pa-1"]
["c1 =","-2.376 x 10-6 Pa-1"]
["d =","1.83 x 10-11 K2 Pa-2"]
["e =","-0.765 x 10-8 K2 Pa-2"]
[]
["Uncertainty of the Air Buoyancy Correction, OIML R111-1:2004(E), (C.6.3-1)"]
[]
["where"]
["mcr =","conventional mass of the reference weight (g)"]
["pr =","density of the reference weight (g/cm³)"]
["u(pa) =","uncertainty associated with the variance of the air density (g/cm³)"]
["pt =","density of weight being tested"]
["pa =","density of moist air (g/cm³)"]
["p0 =","density of air as a reference value equal to 0.0012 g/cm³"]
["u(pr) =","uncertainty associated with the density of the reference weight (g/cm³)"]
["u(pt) =","uncertainty associated with the density of the test weight (g/cm³)"]
["pa1 =","air density during (previous) calibration of the reference weight (g/cm³)"]
[]
["Uncertainty associated with the variance of the air density, OIML R111-1:2004(E), (C.6.3-3)"]
[]
["where"]
["uF =","uncertainty of the CIPM formula"]
[null,"10-5ρaPa-1"]
[null,"3.4 x 10-3K-1ρa"]
[null,"10-2ρa"]
[]
["Estimating the Magnitude of the Air Buoyancy Correction, NISTIR 6969, SOP 2, Paragraph 2.3.2."]
[]
["where"]
["m0 =","nominal mass in grams"]
["ρa =","density of air at time of measurement or normally found in the laboratory, i.e., 0.00119 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"]
[]
["Standard uncertainty for disparity due to standard deviation over time, NISTIR 6969, SOP 29, Paragraph 3.2.5.4."]
[]
[]
["Identify Components"]
["Component","Description",{"$nulls":3},"Reference"]
["s(p)","Uncertainty associated with the  measurement process using a check standard",{"$nulls":3},"NISTIR 6969, SOP 29, Para. 3.2.1.1. Standard deviation of a check standard from a control chart"]
["s(p)","Uncertainty associated with the measurement process from the average range of several sets of measurements",{"$nulls":3},"NISTIR 6969, SOP 29, Para. 3.2.1.2. Standard deviation from a set of replicate measurements and NISTIR 6969, Statistical Techniques, paragraphs 8.3 & 8.4, Pooled standard deviation from standard deviation for each set of replicates from a control chart"]
["u(s)","Uncertainty associated with the  mass standards",{"$nulls":3},"Calibration Report divided by the k factor"]
["u(b)","Uncertainty of the air buoyancy correction",{"$nulls":3},"OIML R 111-1: 2004(E), para. C.6.3, formula (C.6.3-1)"]
["u(pa)","Uncertainty associated with the variance of the air density",{"$nulls":3},"OIML R 111-1: 2004(E), para. C.6.3, formula (C.6.3-3)"]
["u(F)","Uncertainty associated air density equation, NISTIR 6969, SOP 2, Option B",{"$nulls":3},"2007 CIPM Air Density paper, 22 ppm"]
["u(t)","Uncertainty associated with device used to take the air temperature",{"$nulls":3},"Calibration Report divided by the k factor"]
["u(hr)","Uncertainty associated with device used to take the relative humidity",{"$nulls":3},"Calibration Report divided by the k factor"]
["u(P)","Uncertainty associated with device used to take barometric pressure",{"$nulls":3},"Calibration Report divided by the k factor"]
["u(ρr)","Uncertainty associated with the density of the reference weight",{"$nulls":3},"Use reported or typical from manufactures stated density (typical range noted by NIST Mass Group on densities of 8.0 g/cm³ is 0.008 % or 0.00064 g/cm3)"]
["u(ρt)","Uncertainty associated with the density of the test weight",{"$nulls":3},"Use reported or typical from manufactures stated density (typical range is 0.05 g/cm³). (See OIML R111-1:2004(E) B.7.9 Test Method F)"]
["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"]
["u(d)","Standard uncertainty for disparity due to standard drift over time",{"$nulls":3},"NISTIR 6969, SOP 29, Assignment of Uncertainty, para. 3.2.5.4. (0.29 * d - where d is the observed standard bias)"]
[]
["Quantify & Convert"]
["Standard Deviation (drift/bias) Test"]
["Criteria: Can be combined if less than the combined uncertainty, \nnot including the drift/bias. (NISTIR 6969, SOP 29, para. 3.2.5.2.2)"]
["uc (mg) =",null,{"$f":"IF(OR(Process=\"Duplicate Measurements\",drift_or_Rmean=\"\"),\"\",IF(ISERROR(SQRT(H129^2+H130^2+H131^2+H132^2+H133^2+H134^2+H135)),0,SQRT(H129^2+H130^2+H131^2+H132^2+H133^2+H134^2+H135)))","v":""},{"$f":"IF(OR(Process=\"Duplicate Measurements\",drift_or_Rmean=\"\"),\"\",IF(C113<C112,\"Drift/Bias is less than the combined uncertainty and can be included in the uncertainty calculation.\",\"Drift/Bias is more than the combined uncertainty, correct the error before any futher calibration are performed\"))","v":""}]
["Drift/Bias (mg) =",null,{"$f":"IF(OR(Process=\"Duplicate Measurements\",drift_or_Rmean=\"\"),\"\",ABS(drift_or_Rmean))","v":""}]
[]
["Uncertainty of the Air Buoyancy Correction"]
["mcr =",{"$f":"IF(ABC=\"Yes\",(Ms*(1-0.0012/Ps))/0.99985,Ms)","v":""},"g"]
["pr =",{"$f":"Ps","v":""},"g/cm³"]
["pt =",{"$f":"IF(Px=\"\",\"\",Px)","v":""},"g/cm³"]
["u(pa) =",{"$f":"IF(k_hr=\"\",\"\",SQRT((0.00001*Pa*(U_P/k_P)/760*101325)^2+(0.000022*Pa)^2+(-0.0034*Pa*(U_t/k_t))^2+(-0.01*(U_hr/k_hr)/100*Pa)^2))","v":""},"g/cm³"]
["pa =",{"$f":"Pa","v":0.0012},"g/cm³"]
["p0 =",0.0012,"g/cm³"]
["u(pr) =",{"$f":"uPr","v":""},"g/cm³"]
["u(pt) =",{"$f":"IF(uPt=\"\",\"\",uPt)","v":""},"g/cm³"]
["pa1 =",{"$f":"Pa_1","v":""},"g/cm³"]
["ub² =",{"$f":"IF(B124=\"\",\"\",((mcr*((Pr-Pt)/(Pr*Pt)*uPa))^2+(mcr*(Pa-P_0))^2*(uPt^2/Pt^4)+mcr^2*(Pa-P_0)*((Pa-P_0)-2*(Pa_1-P_0))*(uPr^2/Pr^4))*1000000)","v":""},"mg"]
[]
["Combined & Expand"]
["Component Description",null,"Component Symbol","Reported Unc\n(mg)","Type","Distribution","Factor to Normalize","Standard Unc\n(mg)","% Contribution","Degrees of Freedom"]
["Standard Deviation from CC",null,"s(p)",{"$f":"IF(sp=\"\",0,IF(BalUnit=\"g\",MAX(sp,Resolution*1000/2/SQRT(3)),MAX(sp,Resolution/2/SQRT(3))))","v":0},"A","Normal",1,{"$f":"D129/G129","v":0},{"$f":"IF($I$137=\"\",\"\",H129^2/$I$137^2)","v":""},{"$f":"IF(H129=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":"D130/G130","v":0},"",{"$f":"IF(H130=0,1,Sdf)","v":1}]
["Report U divided by k-factor",null,"u(ts)",{"$f":"IF(Uts=\"\",0,Uts)","v":0},"B","Normal",1,0,"",{"$f":"IF(H131=0,1,ts_df)","v":1}]
["Report U divided by k-factor",null,"u(tx)",{"$f":"IF(Utx=\"\",0,Utx)","v":0},"B","Normal",1,0,"",{"$f":"IF(H132=0,1,tx_df)","v":1}]
["Report U divided by k-factor",null,"u(sw)",{"$f":"IF(Usw=\"\",0,Usw)","v":0},"B","Normal",1,0,"",{"$f":"IF(H133=0,1,sw_df)","v":1}]
["Magnitude of ABC",null,"u(MABC)",{"$f":"IF(OR(ABC=\"\",ABC=\"Yes\"),0,ABS(VLOOKUP(Xnom,ConvTable,2,FALSE)*(Pa-0.0012)*((1/Px)-(1/Ps)))*1000)","v":0},"B","Rectangular",{"$f":"SQRT(3)","v":1.7320508075688772},0,"",{"$f":"IF(H134=0,1,10000)","v":1}]
["Air Buoyancy Correction Unc",null,"u(b)²",{"$f":"IF(OR(ABC=\"\",ABC=\"No\"),0,ub)","v":0},"B","Normal",1,0,{"$f":"IF($I$137=\"\",\"\",H135/$I$137^2)","v":""},{"$f":"IF(H135=0,1,10000)","v":1}]
["Standard Drift/Bias",null,"u(d)",{"$f":"IF(OR(Process=\"Duplicate Measurements\",drift_or_Rmean=\"\"),0,ABS(drift_or_Rmean))","v":0},"B","½ Rectangular",{"$f":"SQRT(12)","v":3.4641016151377544},0,"",{"$f":"IF(H136=0,1,sp_df)","v":1}]
[{"$nulls":7},"Combined U (uc) =",{"$f":"IF(SUM(H129:H136)=0,\"\",SQRT(H129^2+H130^2+H131^2+H132^2+H133^2+H134^2+H135+H136^2))","v":""},"mg"]
[{"$nulls":7},"Effective Degrees of Freedom, Welch-Satterthwaite formula, NIST Technical Note 1297, (B-1) (veff) =",{"$f":"IF(MAX(J129:J136)=1,\"\",ROUNDDOWN(I137^4/((H129^4/J129)+(H130^4/J130)+(H131^4/J131)+(H132^4/J132)+(H133^4/J133)+(H134^4/J134)+(H135^2/J135)+(H136^4/J136)),0))","v":""}]
[{"$nulls":7},"k factor =",{"$f":"IF(Veff=\"\",\"\",ROUND(TINV(0.0455,Veff),3))","v":""}]
[{"$nulls":7},"Expanded U (uc*k) =",{"$f":"IF(k=\"\",\"\",k*I137)","v":""},"mg"]
[{"$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=\"\",\"\",IF(BalUnit=\"g\",Best_U*1000,Best_U))","v":""},"mg"]
[{"$nulls":7},"Final Effective Degrees of Freedom (veff) =",{"$f":"IF(Veff=\"\",\"\",IF(MeasuredU>I143,Veff,I141))","v":""}]
[{"$nulls":7},"Final k factor =",{"$f":"IF(k=\"\",\"\",IF(MeasuredU>I143,k,I142))","v":""}]
[{"$nulls":7},"Final U (uc*k) =",{"$f":"IF(MeasuredU=\"\",\"\",IF(MeasuredU>I143,MeasuredU/1000,I143/1000))","v":""},"g"]

{"sheet":"CIPM Air Density","index":11,"n_rows":13,"n_cols":5,"rows_kept":13,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2],[6,3,6,4],[8,0,8,4],[9,0,9,2],[9,3,9,4],[10,0,10,2],[10,3,10,4],[11,0,11,2],[11,3,11,4],[12,0,12,2],[12,3,12,4]]}
["CIPM Air Density",{"$nulls":3},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
["Air Density, SOP 2, Option B, 2012 (CIPM 2007)"]
["Air Density For As Found Measurement Observations"]
[" Barometric Pressure (mm Hg)",null,null,{"$f":"IF(P_1=\"\",\"\",AVERAGE(P_1+P_corr,P_2+P_corr))","v":""}]
[" Temperature (ºC)",null,null,{"$f":"IF(t_1=\"\",\"\",AVERAGE(t_1+t_corr,t_2+t_corr))","v":""}]
[" Relative Humidity (%)",null,null,{"$f":"IF(hr_1=\"\",\"\",AVERAGE(hr_1+hr_corr,hr_2+hr_corr))","v":""}]
[" Calculated Air Density (mg/cm³)",null,null,{"$f":"IF(D6=\"\",\"\",((((D4*(133.322368421053))*(0.02896546))/((1-(((D4*133.322368421053)/(D5+273.15))*((0.00000158123)+((-0.000000029331)*(D5))+(0.00000000011043*D5^2)+(((0.000005707)+(-0.00000002051*D5))*((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316*(D5+273.15))+33.93711047+(-6343.1645/(D5+273.15))))/(D4*133.322368421053)))))+((0.00019898+(-0.000002376*D5))*(((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053))))^2))))+(((D4*133.322368421053)^2/((D5+273.15)^2)*(0.0000000000183+(-0.00000000765*(((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053))))^2))))))*(8.314472)*(D5+273.15)))*(1-((0.378*((D6/100)*((1.00062+0.0000000314*(D4*133.322368421053)+0.00000056*D5^2)*((EXP(0.000012378847*(D5+273.15)^2+(-0.019121316)*(D5+273.15)+33.93711047+(-6343.1645)/(D5+273.15)))/(D4*133.322368421053)))))))))","v":""}]
[]
["Air Density For As Left Measurement Observations"]
[" Barometric Pressure (mm Hg)",null,null,{"$f":"IF(P_1_left=\"\",\"\",IF(Process=\"Duplicate Measurements\",AVERAGE(P_1_left+P_corr,P_3_left+P_corr),AVERAGE(P_1_left+P_corr,P_2_left+P_corr)))","v":""}]
[" Temperature (ºC)",null,null,{"$f":"IF(t_1_left=\"\",\"\",IF(Process=\"Duplicate Measurements\",AVERAGE(t_1_left+t_corr,t_3_left+t_corr),AVERAGE(t_1_left+t_corr,t_2_left+t_corr)))","v":""}]
[" Relative Humidity (%)",null,null,{"$f":"IF(hr_1_left=\"\",\"\",IF(Process=\"Duplicate Measurements\",AVERAGE(hr_1_left+hr_corr,hr_3_left+hr_corr),AVERAGE(hr_1_left+hr_corr,hr_2_left+hr_corr)))","v":""}]
[" Calculated Air Density (mg/cm³)",null,null,{"$f":"IF(D12=\"\",\"\",((((D10*(133.322368421053))*(0.02896546))/((1-(((D10*133.322368421053)/(D11+273.15))*((0.00000158123)+((-0.000000029331)*(D11))+(0.00000000011043*D11^2)+(((0.000005707)+(-0.00000002051*D11))*((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316*(D11+273.15))+33.93711047+(-6343.1645/(D11+273.15))))/(D10*133.322368421053)))))+((0.00019898+(-0.000002376*D11))*(((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316)*(D11+273.15)+33.93711047+(-6343.1645)/(D11+273.15)))/(D10*133.322368421053))))^2))))+(((D10*133.322368421053)^2/((D11+273.15)^2)*(0.0000000000183+(-0.00000000765*(((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316)*(D11+273.15)+33.93711047+(-6343.1645)/(D11+273.15)))/(D10*133.322368421053))))^2))))))*(8.314472)*(D11+273.15)))*(1-((0.378*((D12/100)*((1.00062+0.0000000314*(D10*133.322368421053)+0.00000056*D11^2)*((EXP(0.000012378847*(D11+273.15)^2+(-0.019121316)*(D11+273.15)+33.93711047+(-6343.1645)/(D11+273.15)))/(D10*133.322368421053)))))))))","v":""}]

{"sheet":"Tables and Lists","index":12,"n_rows":33,"n_cols":23,"rows_kept":33,"merged":[[2,2,2,6],[2,8,2,12],[2,14,2,22]]}
["Tables & Lists",{"$nulls":11},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""},null,"Tables & Lists",{"$nulls":7},{"$f":"IF(RptNo=\"\",\"\",\"Report Number: \"&RptNo)","v":""}]
[]
["Class Specification\nDropdown List\n(Class_Spec_List)",null,"Measurement Option Lookup Table\n(Meas_Option)",{"$nulls":5},"Measurement Option Lookup Table\n(Sc_Meas_Option)",{"$nulls":5},"Conversion Table\n(ConvTable) &\nNominal Value Unit\n(Nom_Val_List)"]
["ASTM E 617, Class 000",null,"Option A (SXXS)","S + ts","X + tx","X + tx + sw","S + ts + sw",null,"Option A (SXXS)","S + ts","Sc + tsc","Sc + tsc + sw","S + ts + sw",null,"Nominal Value (pick from list)","Nominal Value (g)","True Mass As Found","True Mass As Left","CM As Found","CM As Left",{"$f":"IF(ISERROR(Final_k),\"Uncertainty\",\"Uncertainty (k=\"&Final_k&\")\")","v":"Uncertainty (k=)"},"Tolerance","Symbol"]
["ASTM E 617, Class 00",null,"Option B (XSSX)","X + tx","S + ts","S + ts + sw","X + tx + sw",null,"Option B (XSSX)","Sc + tsc","S + ts","S + ts + sw","Sc + tsc + sw",null,"Nominal Value (carat)",{"$f":"IF(Xnom=O5,Nx*0.2,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/0.2,AVERAGE(Calculations!$C$27,Calculations!$F$27)/0.2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/0.2,AVERAGE(Calculations!$C$32,Calculations!$F$32)/0.2))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/0.2,AVERAGE(Calculations!$C$29,Calculations!$F$29)/0.2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/0.2,AVERAGE(Calculations!$C$34,Calculations!$F$34)/0.2))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/0.2)","v":""},{"$f":"MPE/1000/0.2","v":0},"carat"]
["ASTM E 617, Class 0",{"$nulls":13},"Nominal Value (grain)",{"$f":"IF(Xnom=O6,Nx*0.06479891,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/0.06479891,AVERAGE(Calculations!$C$27,Calculations!$F$27)/0.06479891)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/0.06479891,AVERAGE(Calculations!$C$32,Calculations!$F$32)/0.06479891))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/0.06479891,AVERAGE(Calculations!$C$29,Calculations!$F$29)/0.06479891)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/0.06479891,AVERAGE(Calculations!$C$34,Calculations!$F$34)/0.06479891))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/0.06479891)","v":""},{"$f":"MPE/1000/0.06479891","v":0},"gr"]
["ASTM E 617, Class 1",{"$nulls":13},"Nominal Value (avdp. ounce)",{"$f":"IF(Xnom=O7,Nx*28.349523125,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/28.349523125,AVERAGE(Calculations!$C$27,Calculations!$F$27)/28.349523125)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/28.349523125,AVERAGE(Calculations!$C$32,Calculations!$F$32)/28.349523125))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/28.349523125,AVERAGE(Calculations!$C$29,Calculations!$F$29)/28.349523125)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/28.349523125,AVERAGE(Calculations!$C$34,Calculations!$F$34)/28.349523125))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/28.349523125)","v":""},{"$f":"MPE/1000/28.349523125","v":0},"oz"]
["ASTM E 617, Class 2",{"$nulls":13},"Nominal Value (apoth. ounce)",{"$f":"IF(Xnom=O8,Nx*31.1034768,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/31.1034768,AVERAGE(Calculations!$C$27,Calculations!$F$27)/31.1034768)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/31.1034768,AVERAGE(Calculations!$C$32,Calculations!$F$32)/31.1034768))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/31.1034768,AVERAGE(Calculations!$C$29,Calculations!$F$29)/31.1034768)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/31.1034768,AVERAGE(Calculations!$C$34,Calculations!$F$34)/31.1034768))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/31.1034768)","v":""},{"$f":"MPE/1000/31.1034768","v":0},"oz ap"]
["ASTM E 617, Class 3",{"$nulls":13},"Nominal Value (apoth. dram)",{"$f":"IF(Xnom=O9,Nx*3.8879346,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/3.8879346,AVERAGE(Calculations!$C$27,Calculations!$F$27)/3.8879346)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/3.8879346,AVERAGE(Calculations!$C$32,Calculations!$F$32)/3.8879346))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/3.8879346,AVERAGE(Calculations!$C$29,Calculations!$F$29)/3.8879346)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/3.8879346,AVERAGE(Calculations!$C$34,Calculations!$F$34)/3.8879346))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/3.8879346)","v":""},{"$f":"MPE/1000/3.8879346","v":0},"dr ap"]
["ASTM E 617, Class 4",{"$nulls":13},"Nominal Value (apoth. scruple)",{"$f":"IF(Xnom=O10,Nx*1.2959782,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/1.2959782,AVERAGE(Calculations!$C$27,Calculations!$F$27)/1.2959782)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/1.2959782,AVERAGE(Calculations!$C$32,Calculations!$F$32)/1.2959782))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/1.2959782,AVERAGE(Calculations!$C$29,Calculations!$F$29)/1.2959782)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/1.2959782,AVERAGE(Calculations!$C$34,Calculations!$F$34)/1.2959782))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/1.2959782)","v":""},{"$f":"MPE/1000/1.2959782","v":0},"s ap"]
["ASTM E 617, Class 5",{"$nulls":13},"Nominal Value (troy ounce)",{"$f":"IF(Xnom=O11,Nx*31.1034768,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/31.1034768,AVERAGE(Calculations!$C$27,Calculations!$F$27)/31.1034768)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/31.1034768,AVERAGE(Calculations!$C$32,Calculations!$F$32)/31.1034768))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/31.1034768,AVERAGE(Calculations!$C$29,Calculations!$F$29)/31.1034768)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/31.1034768,AVERAGE(Calculations!$C$34,Calculations!$F$34)/31.1034768))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/31.1034768)","v":""},{"$f":"MPE/1000/31.1034768","v":0},"oz t"]
["ASTM E 617, Class 6",{"$nulls":13},"Nominal Value (pennyweight)",{"$f":"IF(Xnom=O12,Nx*1.55517384,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/1.555517384,AVERAGE(Calculations!$C$27,Calculations!$F$27)/1.55517384)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/1.55517384,AVERAGE(Calculations!$C$32,Calculations!$F$32)/1.55517384))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/1.555517384,AVERAGE(Calculations!$C$29,Calculations!$F$29)/1.55517384)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/1.55517384,AVERAGE(Calculations!$C$34,Calculations!$F$34)/1.55517384))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/1.55517384)","v":""},{"$f":"MPE/1000/1.55517384","v":0},"pwt"]
["ASTM E 617, Class 7",{"$nulls":13},"Nominal Value (avdp. pound)",{"$f":"IF(Xnom=O13,Nx*453.59237,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/453.59237,AVERAGE(Calculations!$C$27,Calculations!$F$27)/453.59237)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/453.59237,AVERAGE(Calculations!$C$32,Calculations!$F$32)/453.59237))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/453.59237,AVERAGE(Calculations!$C$29,Calculations!$F$29)/453.59237)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/453.59237,AVERAGE(Calculations!$C$34,Calculations!$F$34)/453.59237))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/453.59237)","v":""},{"$f":"MPE/1000/453.59237","v":0},"lb"]
["NIST HB 105-1, Class F",{"$nulls":13},"Nominal Value (gram)",{"$f":"IF(Xnom=O14,Nx,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27,AVERAGE(Calculations!$C$27,Calculations!$F$27))","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32,AVERAGE(Calculations!$C$32,Calculations!$F$32)))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29,AVERAGE(Calculations!$C$29,Calculations!$F$29))","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34,AVERAGE(Calculations!$C$34,Calculations!$F$34)))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U)","v":""},{"$f":"MPE/1000","v":0},"g"]
["NIST HB 105-1, Class E1",{"$nulls":13},"Nominal Value (kilogram)",{"$f":"IF(Xnom=O15,Nx*1000,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27/1000,AVERAGE(Calculations!$C$27,Calculations!$F$27)/1000)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32/1000,AVERAGE(Calculations!$C$32,Calculations!$F$32)/1000))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29/1000,AVERAGE(Calculations!$C$29,Calculations!$F$29)/1000)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34/1000,AVERAGE(Calculations!$C$34,Calculations!$F$34)/1000))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U/1000)","v":""},{"$f":"MPE/1000/1000","v":0},"kg"]
["NIST HB 105-1, Class E2",{"$nulls":13},"Nominal Value (milligram)",{"$f":"IF(Xnom=O16,Nx/1000,\"\")","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$27*1000,AVERAGE(Calculations!$C$27,Calculations!$F$27)*1000)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$32*1000,AVERAGE(Calculations!$C$32,Calculations!$F$32)*1000))","v":""},{"$f":"IF(Process=\"Check Standard Measurement\",Calculations!$C$29*1000,AVERAGE(Calculations!$C$29,Calculations!$F$29)*1000)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Obs3_1=\"\",\"\",IF(AND(ISNUMBER(Obs3_1),Process=\"Check Standard Measurement\"),Calculations!$C$34*1000,AVERAGE(Calculations!$C$34,Calculations!$F$34)*1000))","v":""},{"$f":"IF(Final_U=\"\",\"\",Final_U*1000)","v":""},{"$f":"MPE/1000*1000","v":0},"mg"]
["NIST HB 105-1, Class F1"]
["NIST HB 105-1, Class F2"]
["NIST HB 105-1, Class M1-2"]
["NIST HB 105-1, Class M2"]
["NIST HB 105-1, Class M2-3"]
["NIST HB 105-1, Class M3"]
["Not Specified"]
["OIML R 111, Class E1"]
["OIML R 111, Class  E2"]
["OIML R 111, Class  F1"]
["OIML R 111, Class  F2"]
["OIML R 111, Class  M1"]
["OIML R 111, Class  M1-2"]
["OIML R 111, Class  M2"]
["OIML R 111, Class  M2-3"]
["OIML R 111, Class  M3"]
["User Specified"]