{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget","Lists"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,3,40,4],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,7],[39,3,39,4],[2,1,2,9],[3,1,3,9],[0,0,0,9],[1,1,1,9],[17,8,17,9]]}
["Measurement Uncertainty Budget Template"]
["Laboratory Method and Title"]
["Analyte(s) and Range Encountered"]
["Data Reference(s) and Date(s)"]
["Uncertainty Contributor","Magnitude    (use consistent units)","Type (A or B)","Distribution","Divisor","df","Std. Uncert","Variance (Std. Uncert^2)","% Contribution","u^4/df"]
["Reproducibility (Validation)",{"$f":"F41","v":" "},{"$f":"IF(B6<>\" \",\"A\",\"\")","v":""},{"$f":"IF(C6=\"A\",\"Normal\",IF(C6=\"B\",\"Rectangular\",\"None\"))","v":"None"},{"$f":"IF(D6=\"Normal\",1,IF(D6=\"Rectangular\",1.732,\"\"))","v":""},{"$f":"COUNT(E38:J38)-1","v":-1},{"$f":"IF(ISERROR(B6/E6), \" \", (B6/E6))","v":" "},{"$f":"IF(ISERROR(G6^2), \" \", G6^2)","v":" "},{"$f":"IF(ISERROR(H6/$H$15), \" \", (H6/$H$15))","v":" "},{"$f":"IF(ISERROR(G6^4/F6), \" \", (G6^4/F6))","v":" "}]
["Repeatability (Validation)",{"$f":"F40","v":" "},{"$f":"IF(AND(B7<>\" \",Lists!D3=FALSE),\"A\",\"\")","v":""},"None",{"$f":"IF(D7=\"Normal\",1,IF(D7=\"Rectangular\",1.732,\"\"))","v":""},{"$f":"SUM(E36:J36)-COUNT(E38:J38)","v":0},{"$f":"IF(ISERROR(B7/E7), \" \", (B7/E7))","v":" "}," ",{"$f":"IF(ISERROR(H7/$H$15), \" \", (H7/$H$15))","v":" "}," "]
["Reproducibility (LCS)",null,{"$f":"IF(AND(C6<>\"A\",B8<>\"\"),\"A\",\"\")","v":""},"None","",null," "," ",{"$f":"IF(ISERROR(H8/$H$15), \" \", (H8/$H$15))","v":" "}," "]
["Repeatability (MSD)",null,{"$f":"IF(AND(C7<>\"A\",B9<>\"\",Lists!D3=FALSE),\"A\",\"\")","v":""},"None","",null," "," "," "," "]
["Sample Repeatability                                      If > Repeatability, then check box",null,{"$f":"IF(AND(Lists!D3=TRUE,B10<>\"\"),\"A\",\"\")","v":""},"None","",null," "," "," "," "]
["e.g. Standard Tolerance",null,"Select A or B",{"$f":"IF(C11=\"A\",\"Normal\",IF(C11=\"B\",\"Rectangular\",\"None\"))","v":"None"},"",null," "," "," "," "]
["e.g. Instrument MU",null,"Select A or B",{"$f":"IF(C12=\"A\",\"Normal\",IF(C12=\"B\",\"Rectangular\",\"None\"))","v":"None"},"",null," "," "," "," "]
["e.g. Instrument Resolution",null,"Select A or B",{"$f":"IF(C13=\"A\",\"Normal\",IF(C13=\"B\",\"Rectangular\",\"None\"))","v":"None"},"",null," "," "," "," "]
["e.g. Glassware Tolerance",null,"Select A or B",{"$f":"IF(C14=\"A\",\"Normal\",IF(C14=\"B\",\"Rectangular\",\"None\"))","v":"None"},{"$f":"IF(D14=\"Normal\",1,IF(D14=\"Rectangular\",1.732,\"\"))","v":""},null,{"$f":"IF(ISERROR(B14/E14), \" \", (B14/E14))","v":" "}," "," ",{"$f":"IF(ISERROR(G14^4/F14), \" \", (G14^4/F14))","v":" "}]
["Notes",null,null,"Combined Uncertainty (Uc) =",null,null,{"$f":"SQRT(H15)","v":0},{"$f":"SUM(H6:H14)","v":0},{"$f":"SUM(I6:I14)","v":0},{"$f":"SUM(J6:J14)","v":0}]
["Use consistent Units, e.g. ppm, %RSD",null,null,"Effective Degrees of Freedom (df')",null,null,{"$f":"IF(ISERROR(INT(G15^4/J15)), \" \", INT(G15^4/J15))","v":" "}]
["Type A (LSD Derived Data)",null,null,"95% Coverage Factor, k = (TINV(0.05,df')",null,null,{"$f":"IF(ISERROR(TINV(0.05,G16)), \" \", TINV(0.05,G16))","v":" "}]
["Type B (Not LSD Derived Data)",null,null,"Expanded / Measurement Uncertainty (Uc x k) =",null,null,{"$f":"IF(ISERROR(G15*G17), \" \", G15*G17)","v":" "}]
["Data Group Default naming is 'TBD', enter Group Name to Unlock",null,null,"Method Validation / Verification (Repeatability and Reproducibility)"]
["Reproducibility (Validation) from Spiked Recovery Data",null,null,"Data Group Names","TBD","TBD","TBD","TBD","TBD","TBD"]
["Repeatability (Validation) from Spiked Recorvery Data",null,null,1]
["Reproducibility can alternatively be from LCS Chart",null,null,2]
["Repeatability can alternatively be from Matrix Spiked Duplicates (MSD)",null,null,3]
["Sample Repeatability can be from Sample Duplicates or Validation",null,null,4]
["k assumes 95% Confidence Interval",null,null,5]
["Effective Degrees of Freedom, df', from Welch-Saterthwaite equation",null,null,6]
["  -  df' ~ (Uc^2)^2) / summa((Sdi^2)^2/dfi), where",null,null,7]
["  -  df' = nearest truncated integer and (i) = individual contributor",null,null,8]
["For Type B Contributors",null,null,9]
[" - indicate major sources that are not already captured by Type A variability",null,null,10]
[" - set df at 99 as calculation placeholder",null,null,11]
[" - if Tolerance is ± 0.1, then Magnitude is 0.1",null,null,12]
[" - if Instrument MU is ± 0.2, then Magnitude is 0.2",null,null,13]
[" - if Instrument Resolution is ± 0.2, then Magnitude is 0.2",null,null,14]
[null,null,null,15]
[null,null,null,"Count",{"$f":"IF(E20<>\"TBD\",COUNT(E21:E35),\"\")","v":""},"","","","",""]
[null,null,null,"Std. Dev.",{"$f":"IF(OR(E20=\"TBD\",ISERROR(STDEV(E21:E35))),\" \", STDEV(E21:E35))","v":" "}," "," "," "," "," "]
[null,null,null,"Average",{"$f":"IF(OR(E20=\"TBD\",ISERROR(AVERAGE(E21:E35))), \" \", AVERAGE(E21:E35))","v":" "}," "," "," "," "," "]
[null,null,null,"Variance",{"$f":"IF(OR(E20=\"TBD\",ISERROR(VAR(E21:E35))), \" \", VAR(E21:E35))","v":" "}," "," "," "," "," "]
[null,null,null,"Repeatability (sqrt(Average Variance))",null,{"$f":"IF(ISERROR(SQRT(AVERAGE(E39:J39))), \" \", SQRT(AVERAGE(E39:J39)))","v":" "}]
[null,null,null,"Reproducibility (stdev(Averages))",null,{"$f":"IF(ISERROR(STDEV(E38:J38)), \" \", STDEV(E38:J38))","v":" "},null,"Calculated MU:",{"$f":"G18","v":" "}]

{"sheet":"Lists","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Drop Down",null,"Checkbox","Used For"]
[null,"Select A or B",null,false,"Sample Repeatability"]
[null,"A"]
[null,"B"]