{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CofA","LIMSData","AnalysisData","Customer","Settings","Read Me"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"CofA","index":0,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[6,1,6,10],[0,1,4,4],[8,1,12,4],[15,9,15,10]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Report Date:",{"$f":"TODAY()","v":"2020-10-27"}]
[]
[null,"Certificate of Analysis"]
[null,"To:"]
[null,{"$f":"CustomerMailingLabel","v":"\n\n  "},null,null,null,null,null,"Sample ID:",{"$f":"INDEX(SampleID,1,1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,"Completed:",{"$f":"IF(ISBLANK(INDEX(CompletedDate,1,1)), \"\", INDEX(CompletedDate,1,1))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,"Sample Type:",{"$f":"INDEX(SampleType.Name,1,1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,"Customer Sample ID:",{"$f":"IF(ISBLANK(INDEX(CustomerSampleID,1,1)), \"\", INDEX(CustomerSampleID,1,1))","v":{"$error":"#NAME?"}}]
[]
[]
[null,"Analyte",null,null,"Result","Units","Spec","Date","Tech","Method"]
[null,{"$f":"IF(NOT(OR(ISBLANK(INDEX(INDIRECT(\"AnalysisData!ReportName\"), MATCH($A16, SampleAnalysisID, 0))), ISERROR(INDEX(INDIRECT(\"AnalysisData!ReportName\"), MATCH($A16, SampleAnalysisID, 0))))), INDEX(INDIRECT(\"AnalysisData!ReportName\"), MATCH($A16, SampleAnalysisID, 0)), IF(ISERROR(INDEX(Analyte, MATCH($A16, SampleAnalysisID, 0))), \"\", IF(ISBLANK(INDEX(Analyte, MATCH($A16, SampleAnalysisID, 0))), \"\", INDEX(Analyte, MATCH($A16, SampleAnalysisID, 0)))))","v":""},null,null,{"$f":"IF(ISERROR(INDEX(AnalysisResultFormatted, MATCH($A16, SampleAnalysisID, 0))), \"\", IF(ISBLANK(INDEX(AnalysisResultFormatted, MATCH($A16, SampleAnalysisID, 0))), \"\", INDEX(AnalysisResultFormatted, MATCH($A16, SampleAnalysisID, 0))))","v":""},{"$f":"IF(ISERROR(INDEX(Abbreviation, MATCH($A16, SampleAnalysisID, 0))), \"\", IF(ISBLANK(INDEX(Abbreviation, MATCH($A16, SampleAnalysisID, 0))), \"\", INDEX(Abbreviation, MATCH($A16, SampleAnalysisID, 0))))","v":""},{"$f":"IF(ISERROR(INDEX(ReportSpecs, MATCH($A16, SampleAnalysisID, 0))), \"\", IF(ISBLANK(INDEX(ReportSpecs, MATCH($A16, SampleAnalysisID, 0))), \"\", INDEX(ReportSpecs, MATCH($A16, SampleAnalysisID, 0))))","v":""},{"$f":"IF(ISERROR(INDEX(AnalysisDate, MATCH($A16, SampleAnalysisID, 0))), \"\", IF(ISBLANK(INDEX(AnalysisDate, MATCH($A16, SampleAnalysisID, 0))), \"\", INDEX(AnalysisDate, MATCH($A16, SampleAnalysisID, 0))))","v":""},{"$f":"IF(ISERROR(INDEX(Technician, MATCH($A16, SampleAnalysisID, 0))), \"\", IF(ISBLANK(INDEX(Technician, MATCH($A16, SampleAnalysisID, 0))), \"\", INDEX(Technician, MATCH($A16, SampleAnalysisID, 0))))","v":""},{"$f":"IF(ISERROR(INDEX(Method.Name, MATCH($A16, SampleAnalysisID, 0))), \"\", IF(ISBLANK(INDEX(Method.Name, MATCH($A16, SampleAnalysisID, 0))), \"\", INDEX(Method.Name, MATCH($A16, SampleAnalysisID, 0))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Direct Inquiries to:"]
[null,"Wind River Labs"]
[null,"Ph: 307-733-1442"]
[null,null,null,null,null,null,null,"Analyst Signature"]

{"sheet":"LIMSData","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AnalysisData","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Customer","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,3,6,6],[10,3,14,6],[18,3,22,6]]}
[null,null,null,"CustomerMailingLabel:"]
[null,null,null,{"$f":"IF(ISBLANK(B32), B3, B32) & CHAR(10) & IF(LEN(D19) > 3, D19, D11)","v":"\n\n  "}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"BillingAddress:"]
[null,null,null,{"$f":"B7 & IF(ISBLANK(B9), \"\", CHAR(10) & B9) & CHAR(10) & B11 & IF(ISBLANK(B13), \"\", \", \" & B13) & \"  \" & B15 & IF(ISBLANK(B17), \"\", CHAR(10) & B17)","v":"\n  "}]
[]
[]
[]
[]
[]
[]
[null,null,null,"ShippingAddress:"]
[null,null,null,{"$f":"B8 & IF(ISBLANK(B10), \"\", CHAR(10) & B10) & CHAR(10) & B12 & IF(ISBLANK(B14), \"\", \", \" & B14) & \"  \" & B16 & IF(ISBLANK(B18), \"\", CHAR(10) & B18)","v":"\n  "}]

{"sheet":"Settings","index":4,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["MSC-LIMS Access Version:",14]
["Remove Infrastructure Sheets:","Yes"]
["Prevent Screen Updating:","Yes"]
["Exclude \"Internal Data\" Analyses:","No"]
["Requirement Header Format:","Requirement"]

{"sheet":"Read Me","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}