{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Cover Sheet","Summary","Data","Chart"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart","index":4,"reason":"not_a_worksheet"}],"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":"Instructions","index":0,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[2,12,5,15],[13,1,13,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[7,2,7,3],[15,5,17,7],[19,1,19,2],[1,1,1,3],[14,1,14,2],[6,2,6,3],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2]]}
[]
[null,"INSTRUCTIONS"]
[null,"Step 1","Go to ProRAE Studio II and open your downloaded data"]
[null,"Step 2","Click Datalog on the left"]
[null,"Step 3","Highlight only those events pertaining to the sampling period"]
[null,"Step 4","Click the \"Export selected event(s)\" arrow, just right of STEL icon"]
[null,"Step 5","Save the exported file to any location, noting where"]
[null,"Step 6","Return to this template"]
[null,"Step 7","Click the \"LOAD FILE\" button to the right"]
[null,"Step 8","Choose the same file you exported in Step 5"]
[null,"Step 9","Click \"Load\" in the file chooser"]
[null,"Step 10","Make sure the other sheets transferred the data"]
[]
[null,"SAMPLING INFORMATION"]
[null,"Employer"]
[null,"FIN"]
[null,"Sample Date"]
[null,"Sample Type"]
[null,"Location"]
[null,"Analyte"]
[]
["v5"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Peak",null,18,24,47,23]
[null,null,null,null,null,"Min",null,0,1,2,1]
[null,null,null,null,null,"Average",null,8,9,12,10]

{"sheet":"Cover Sheet","index":1,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,15,34],[16,0,21,34],[33,0,33,34],[34,0,34,34],[35,0,35,34],[32,0,32,34],[31,0,31,34],[25,0,26,34],[29,0,29,34]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Division of\nOSH Compliance"]
[]
[]
[]
[]
[]
[]
[]
[]
["Area Sampling Report"]
[]
[]
[]
["for"]

{"sheet":"Summary","index":2,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Summary"]
["Unit Name"]
["Unit SN"]
["Unit Firmware Ver"]
["Running Mode"]
["Measure Type"]
["Datalog Mode"]
["Datalog Type"]
["Diagnostic Mode"]
["Stop Reason"]
["Site ID"]
["User ID"]
["Sensor"]
["Span"]
["Span 2"]
["Low Alarm"]
["High Alarm"]
["Over Alarm"]
["STEL Alarm"]
["TWA Alarm"]
["Measurement Gas"]
["Calibration Time"]
["Start Time",{"$f":"MIN(Data!B:B)","v":"00:00:00"}]
["Stop Time",{"$f":"MAX(Data!B:B)","v":"00:00:00"}]
["Run Time (Actual)",{"$f":"INT(Data!I5/60) & \" Hours \" & Data!I5-INT(Data!I5/60)*60 & \" Minutes\"","v":"0 Hours 0 Minutes"}]
["Peak",{"$f":"MAX(Data!C:F) & \" PPM\"","v":"0 PPM"}]
["Minimum",{"$f":"MIN(Data!C:F) & \" PPM\"","v":"0 PPM"}]
["TWA (8-Hour)",{"$f":"Data!I9","v":"0 PPM"}]

{"sheet":"Data","index":3,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,8,3,8],[2,9,3,9],[2,10,3,10],[6,8,7,10],[8,8,9,10]]}
["Index","Time","(Min)","1-Minute Avg","(Max)","(Real)","STEL"]
[]
[null,null,null,null,null,null,null,null,"Periods","Avg of\nAverages","Avg of \nReal"]
[]
[null,null,null,null,null,null,null,null,{"$f":"COUNT(A:A)","v":0},{"$f":"IF(COUNT(D:D)>0,AVERAGE(D:D),0)","v":0},{"$f":"IF(COUNT(F:F)>0,AVERAGE(F:F),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TWA (8-Hour)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"ROUND(J12,0) & \" PPM\"","v":"0 PPM"}]
[]
[null,null,null,null,null,null,null,null,null,"Raw"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I5>0,IF(COUNT(D:D)>0,AVERAGE(D:D),AVERAGE(F:F))*I5/480,0)","v":0}]