{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","General Info","SASS_SuperSASS","SASS_Super SASS collocated","URG","URG_collocated","Reference"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":455,"comments":5,"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":"Instructions","index":0,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Instructions for CSN Sampler Flow Rate Audit and Monthly Flow Check Worksheets"]
[]
["Overview"]
["This workbook contains worksheets needed for audits of up to two SASS samplers and/or two URG 3000N samplers and monthly flow checks for up to two SASS samplers and up two URG 3000N samplers at a single site. The purpose of this workbook is to assist state, local, and/or tribal air agencies in recordkeeping and reporting of flow rate audits and flow checks to AQS.  "]
[]
["You must fill out all infomation in the 'General Info' worksheet.  This is because the basic site information (name, AQS code, etc.) are taken from the 'General Info' worksheet and automatically applied in all other sheets where applicable. In selecting your particular use for this workbook (Sampler Flow Check Audit or Sampler Monthly Flow Check) from the dropdown option in cell F3 of 'General Info' worksheet, cells not needed for your purpose will black out. Cell F3 should be the first entry you make in the workbook."]
[]
["Protected Document"]
["These worksheets are protected to prevent accidental edits to formulas, etc. To remove the worksheet protections, go to the Review tab, and click \"Unprotect Sheet.\" No password is needed to unprotect the worksheets."]
[]
["Cell Color Coding"]
["White cells contain labels and other text. Do NOT overwrite any white cell."]
["Orange cells require user input - all your data should be placed in the appropriate orange cells."]
["Blue cells contain data entered from another sheet or calculated using formulae. Do NOT overwrite any blue cell. "]
["Black cells mark out info not needed for your particular use of the workbook. These cells can be ignored/skipped."]
[]
["Special Instructions for Selected Cells"]
["Many cells have comments, as indicated by the red triangle in the upper left corner. These comments contain information on acceptable input values for that cell. The comments will be visible when you place your mouse cursor over or in the cell."]
[]
["Dropdown Boxes"]
["Some cells are dropdown boxes. When you place your cursor in the field, a small triangle will appear on the right-hand side of the box. You may click on the box and a list of acceptable values will appear. Note that only the values in the list may be selected. All other values are invalid."]
[]
["Dropdown Box Color Coding"]
["Green cells indicate a good or acceptable value."]
["Orange cells indicate an unfilled or neutral value (e.g., Not evaluated)"]
["Red cells indicate a problem at the site - enter a note in the questions section to explain the problem."]
[]
["% Difference Color Coding"]
["Green cells indicate a good or acceptable value, and no corrective action required."]
["Yellow cells indicate a recalibration is required but affected data do not need to be invalidated."]
["Red cells indicate a recalibration is required and affected data must be invalidated."]

{"sheet":"General Info","index":1,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,5,2,6],[6,1,6,4],[7,1,7,4],[9,1,9,4],[8,5,8,10],[8,1,8,4],[3,5,3,10],[4,5,4,6],[6,5,6,10],[7,5,7,10],[9,5,9,6],[10,1,10,4],[10,5,10,6],[13,1,13,4],[11,1,11,4],[11,5,11,6],[12,5,12,6],[13,5,13,6],[12,1,12,4]]}
[null,"Chemical Speciation Network",null,null,null,null,"Version Date:","2024-10-16"]
[null,"General Information - Used by all Spreadsheets"]
[null,"Purpose/Use of Worksheet: ",null,null,null,"Select From Dropdown List"]
[null,"Monitoring Site Name/Location:"]
[null,"AQS Site ID:",null,null,null,null,null,{"$f":"IF(OR(ISBLANK(Location_Name),ISBLANK(AQS_Site_Code)),\"Missing Site Name or Site Code!\",\"\")","v":""}]
[]
[null,{"$f":"IF($F$3=\"Sampler Monthly Flow Check\",\"\",\"Auditor Name:\")","v":"Auditor Name:"}]
[null,{"$f":"IF($F$3=\"Sampler Monthly Flow Check\",\"\",\"Auditor Affiliation:\")","v":"Auditor Affiliation:"}]
[null,{"$f":"IF($F$3=\"Sampler Monthly Flow Check\",\"\",\"Observer(s) Name and Affiliation:\")","v":"Observer(s) Name and Affiliation:"}]
[null,"Operator Name:"]
[null,{"$f":"IF($F$3=\"Sampler Audit\",\"\",\"Operator Affiliation:\")","v":"Operator Affiliation:"}]
[null,{"$f":"IF($F$3=\"Sampler Monthly Flow Check\",\"\",IF($F$3=\"Sampler Audit\",\"\",\"Operator Phone Number:\"))","v":"Operator Phone Number:"}]
[null,{"$f":"IF(F3=\"Sampler Monthly Flow Check\",\"Agency Type:\",IF(F3=\"Sampler Audit\",\"Auditing Agency Type\",IF(F3=\"Technical System Audit\",\"Auditing Agency Type\",\"Agency Type\")))","v":"Agency Type"},null,null,null,"Select From Dropdown List",null,{"$f":"IF(OR(ISBLANK(F13),F13=\"Select From Dropdown List\"),\"Missing Agency Type!\",\"\")","v":"Missing Agency Type!"}]
[null,"Assessment Date:",null,null,null,null,null,{"$f":"IF(ISBLANK(F14),\"Missing Assessment Date!\",\"\")","v":"Missing Assessment Date!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Select From Dropdown List"]
["Sampler Flow Rate Audit"]
["Sampler Monthly Flow Check"]
[]
["Select From Dropdown List"]
["PQAO"]
["Collecting Org"]
["EPA Regional Office"]
["EPA Contractor"]
[]
["Select From Dropdown List"]
["PQAO"]
["Collecting Org"]

{"sheet":"SASS_SuperSASS","index":2,"n_rows":141,"n_cols":11,"rows_kept":141,"cut":false,"hidden":false,"merged":[[22,3,22,5],[24,3,24,5],[23,4,23,5],[113,8,113,9],[135,8,135,9],[104,8,104,9],[36,6,37,6],[36,2,36,4],[1,4,2,4],[15,7,15,9],[4,7,4,9],[24,8,24,9],[43,7,43,9],[12,7,12,9],[23,8,23,9],[22,8,22,9],[33,1,35,9],[25,8,25,9],[19,8,19,9],[27,8,27,9],[25,4,25,5],[26,8,26,9],[27,4,27,5],[26,3,26,5],[19,3,19,5],[4,2,4,5],[13,2,13,5],[8,4,8,6],[15,1,15,2],[10,2,10,5],[11,2,11,5],[16,7,16,9],[15,3,15,5],[12,2,12,5],[5,2,5,5],[17,7,17,9],[10,7,10,9]]}
[null,"Chemical Speciation Network",null,null,null,null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", IF(Op_Aff=\"\",\"\",Op_Aff), IF(A_Aff=\"\",\"\",A_Aff))","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check Worksheet\",\"Performance Audit Worksheet\")","v":"Performance Audit Worksheet"},null,null,"Version Date:"]
[null,"Met One SASS/Super SASS - Primary Sampler",null,null,null,{"$f":"IF(V_Date=\"\",\"\",V_Date)","v":"2024-10-16"}]
[null,"Note - blue fields are entered from 'General Info' worksheet or calculated - orange fields are to be filled in here"]
[null,"Location",{"$f":"IF(M_site=\"\",\"\",M_site)","v":""},null,null,null,"Date",{"$f":"IF('General Info'!F14=\"\",\"\",'General Info'!F14)","v":""}]
[null,"AQS Site ID",{"$f":"IF(S_ID=\"\",\"\",S_ID)","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(Location_Name),ISBLANK(AQS_Site_Code),ISBLANK(D7),H5=\"\"),\"Missing Date, Site Name, Site Code, or POC\",\"\")","v":"Missing Date, Site Name, Site Code, or POC"}]
[null,"AQS Sampler POC"]
[null,"Site Information"]
[null,null,null,"Sampler Type (Model)","Select From Dropdown List"]
[]
[null,"Auditor(s)",{"$f":"IF(A_Name=\"\",\"\",A_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(A_Aff=\"\",\"\",A_Aff)","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Agency Type\",\"Audit Type\")","v":"Audit Type"},{"$f":"IF(A_Type=\"\",\"\",IF(A_Type=\"Select From Dropdown List\",\"\",A_Type))","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(C12),'General Info'!F13=\"Select From Dropdown List\"),\"Missing Agency Type!\",\"\")","v":"Missing Agency Type!"}]
[null,"Operator(s)",{"$f":"IF(OP_Name=\"\",\"\",OP_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(Op_Aff=\"\",\"\",Op_Aff)","v":""}]
[null,"Phone No.",{"$f":"IF(Phone=\"\",\"\",Phone)","v":""}]
[]
[null,null,null,null,null,null,"Sampler S/N"]
[null,null,null,null,null,null,"Head S/N"]
[null,null,null,null,null,null,"Pump S/N"]
[]
[null,null,"Last Calibration Date"]
[]
[null,"Reference Standards"]
[null,null,"Flow Reference Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"Temperature Ref Std Model",null,null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"BP Std Model",null,null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[]
[]
[]
[null,{"$f":"B3","v":"Met One SASS/Super SASS - Primary Sampler"}]
[null,"Clock/timer Verification"]
[null,"If local time is under daylight saving, convert Ref Std to Local Standard Time. Daylight Saving Time begins for most of the United States at 2:00 a.m. on the second Sunday of March. Time reverts to standard time at 2:00 a.m. on the first Sunday of November."]
[]
[]
[null,null,"Time (hh:mm)",null,null,null,"Difference Minutes",null,"     1 minutes or less?"]
[null,null,"Ref Std",null,"SASS",null,null,null,"Pass","Fail"]
[null,"Check Time",null,null,null,null,{"$f":"IF(ISBLANK(SA_01_00_TI_S),\"\",ROUND(((SA_01_00_D_S+SA_01_00_TI_S)-(SA_01_00_D_R+SA_01_00_TI_R))*24*60,0))","v":""},null,{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date","v":""},null,null,{"$f":"IF(ISBLANK(E40), \"Missing Sampler Date!\",IF(INT(C40)<>INT(E40),\"Sampler and Audit Clock Dates Don't Match!\",\"\"))","v":"Missing Sampler Date!"}]
[null,"Recalib Time",null,null,null,null,{"$f":"IF(E41=\"\",\"\",ROUND(((E42+E41) -(C42+C41))*24*60,0))","v":""},null,{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date","v":""},null,null,{"$f":"IF(AND(G39>1,OR(ISBLANK(E41), ISBLANK(E42))),\"Missing Recalib Time or Date!\",\"\")","v":"Missing Recalib Time or Date!"}]
[null,"Leak Test"]
[null,null,"Initial Check",null,null,"After Correction",null,"   Greater than 0.10 L/min fails"]
[null,null,"A  L/min",null,null,"B  L/min",null,"Pass","Fail A","Fail B"]
[null,"Channel 1",null,null,"Channel 1",null,null,{"$f":"IF(AND(F46<>\"\",F46<=0.1),\"X\",IF(F46>0.1,\"\",IF(AND(C46<>\"\",C46<=0.1),\"X\",\" \")))","v":" "},{"$f":"IF((C46>0.1),\"X\",\"\")","v":""},{"$f":"IF((F46>0.1),\"X\",\"\")","v":""}]
[null,"Channel 2",null,null,"Channel 2",null,null,{"$f":"IF(AND(F47<>\"\",F47<=0.1),\"X\",IF(F47>0.1,\"\",IF(AND(C47<>\"\",C47<=0.1),\"X\",\" \")))","v":" "},{"$f":"IF((C47>0.1),\"X\",\"\")","v":""},{"$f":"IF((F47>0.1),\"X\",\"\")","v":""}]
[null,"Channel 3",null,null,"Channel 3",null,null," ",{"$f":"IF((C48>0.1),\"X\",\"\")","v":""},""]
[null,"Channel 4",null,null,"Channel 4",null,null," ","",""]
[null,"Channel 5",null,null,"Channel 5",null,null," ","",""]
[null,"Channel 6",null,null,"Channel 6",null,null," ","",""]
[null,"Channel 7",null,null,"Channel 7",null,null," ","",""]
[null,"Channel 8",null,null,"Channel 8",null,null," ","",""]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check\", \"Flow Audit\")","v":"Flow Audit"}]
[null,"For the reference standard, enter \"UR\" for under range and \"OR\" for over range flow readings."]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","SASS - Ref",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D59),\"NA\",D59*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D59),\"NA\",D59*1.1)","v":"NA"},null,{"$f":"IF((D59>0),(F59-D59)/D59*100,\" \")","v":" "},null,{"$f":"IF(D59=\"\",\"\",IF(OR(D59=\"UR\",D59=\"OR\"),\"\",IF(ABS(G59)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D59=\"\",\"\",IF(OR(D59=\"UR\",D59=\"OR\",D59=\"\"),\"X\",IF(AND(ABS(G59)>10,G59<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D59),\"\",ABS(G59)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G59)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G59)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2","NA",null,"NA",null,{"$f":"IF((D60>0),(F60-D60)/D60*100,\" \")","v":" "},null,{"$f":"IF(D60=\"\",\"\",IF(OR(D60=\"UR\",D60=\"OR\"),\"\",IF(ABS(G60)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D60=\"\",\"\",IF(OR(D60=\"UR\",D60=\"OR\",D60=\"\"),\"X\",IF(AND(ABS(G60)>10,G60<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D60),\"\",ABS(G60)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G60)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G60)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"","",""]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","SASS - Ref",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D70),\"NA\",D70*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D70),\"NA\",D70*1.1)","v":"NA"},null,{"$f":"IF((D70>0),(F70-D70)/D70*100,\" \")","v":" "},null,{"$f":"IF(D70=\"\",\"\",IF(OR(D70=\"UR\",D70=\"OR\"),\"\",IF(ABS(G70)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D70=\"\",\"\",IF(OR(D70=\"UR\",D70=\"OR\",D70=\"\"),\"X\",IF(AND(ABS(G70)>10,G70<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D70),\"\",ABS(G70)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G70)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G70)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2","NA",null,"NA",null," ",null,"","",{"$f":"_xlfn.IFS(ISBLANK(D71),\"\",ABS(G71)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G71)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G71)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"","",""]
[]
[]
[null,{"$f":"B3","v":"Met One SASS/Super SASS - Primary Sampler"}]
[null,null,null,null,"Reference Standard vs Design Flow"]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","SASS","Upper Limit","Ref Std","Ref-Design",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D84),\"NA\",D84*0.9)","v":6.03},6.7,{"$f":"IF(ISBLANK(D84),\"NA\",D84*1.1)","v":7.370000000000001},{"$f":"IF(D59<>\"\",D59,\"\")","v":""},{"$f":"IF((F84<>\"\"),(F84-D84)/D84*100,\" \")","v":" "},null,{"$f":"IF(F84=\"\",\"\",IF(OR(F84=\"UR\",F84=\"OR\"),\"\",IF(ABS(G84)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F84=\"\",\"\",IF(OR(F84=\"UR\",F84=\"OR\"),\"X\",IF(AND(ABS(G84)>10,G84<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D59),\"\",ABS(G84)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G84)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G84)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2",6.03,6.7,7.370000000000001,{"$f":"IF(D60<>\"\",D60,\"\")","v":""},{"$f":"IF((F85<>\"\"),(F85-D85)/D85*100,\" \")","v":" "},null,{"$f":"IF(F85=\"\",\"\",IF(OR(F85=\"UR\",F85=\"OR\"),\"\",IF(ABS(G85)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F85=\"\",\"\",IF(OR(F85=\"UR\",F85=\"OR\"),\"X\",IF(AND(ABS(G85)>10,G85<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D60),\"\",ABS(G85)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G85)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G85)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3",6.03,6.7,7.370000000000001,{"$f":"IF(D61<>\"\",D61,\"\")","v":""}," ",null,"","",""]
[null,"Channel 4",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 5",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 6",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 7",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 8",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","SASS","Upper Limit","Ref Std","Ref-Design",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D95),\"NA\",D95*0.9)","v":6.03},6.7,{"$f":"IF(ISBLANK(D95),\"NA\",D95*1.1)","v":7.370000000000001},null,{"$f":"IF((F95<>\"\"),(F95-D95)/D95*100,\" \")","v":" "},null,{"$f":"IF(F95=\"\",\"\",IF(OR(F95=\"UR\",F95=\"OR\"),\"\",IF(ABS(G95)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F95=\"\",\"\",IF(OR(F95=\"UR\",F95=\"OR\"),\"X\",IF(AND(ABS(G95)>10,G95<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D70),\"\",ABS(G95)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G95)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G95)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2",6.03,6.7,7.370000000000001,{"$f":"IF(D71<>\"\",D71,\"\")","v":""}," ",null,"","",{"$f":"_xlfn.IFS(ISBLANK(D71),\"\",ABS(G96)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G96)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G96)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 4",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 5",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 6",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 7",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 8",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Ambient Temperature Check\", \"Ambient Temperature Audit\")","v":"Ambient Temperature Audit"}]
[null,null,null,"Degrees C",null,null,null,null,"Within ± 2 degrees C?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D107),\"NA\",D107-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D107),\"NA\",D107+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D107))),(F107-D107),\" \")","v":" "},null,{"$f":"IF(F107=\"\",\"\",IF(OR(F107=\"UR\",F107=\"OR\"),\"\",IF(ABS(G107)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F107=\"\",\"\",IF(OR(F107=\"UR\",F107=\"OR\"),\"X\",IF(AND(ABS(G107)>2,G107<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest After Recalibration"]
[null,null,{"$f":"IF(ISBLANK(D109),\"NA\",D109-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D109),\"NA\",D109+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D109))),(F109-D109),\" \")","v":" "},null,{"$f":"IF(F109=\"\",\"\",IF(OR(F109=\"UR\",F109=\"OR\"),\"\",IF(ABS(G109)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F109=\"\",\"\",IF(OR(F109=\"UR\",F109=\"OR\"),\"X\",IF(AND(ABS(G109)>2,G109<>\" \"),\"X\",\" \")))","v":""}]
[]
[]
[null,{"$f":"B3","v":"Met One SASS/Super SASS - Primary Sampler"}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Filter Temperature Check\", \"Filter Temperature Audit\")","v":"Filter Temperature Audit"}]
[null,null,null,"Degrees C",null,null,null,null,"Within ± 2 degrees C?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D116),\"NA\",D116-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D116),\"NA\",D116+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D116))),(F116-D116),\" \")","v":" "},null,{"$f":"IF(F116=\"\",\"\",IF(OR(F116=\"UR\",F116=\"OR\"),\"\",IF(ABS(G116)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F116=\"\",\"\",IF(OR(F116=\"UR\",F116=\"OR\"),\"X\",IF(AND(ABS(G116)>2,G116<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 2","NA",null,"NA",null," ",null,{"$f":"IF(F117=\"\",\"\",IF(OR(F117=\"UR\",F117=\"OR\"),\"\",IF(ABS(G117)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F117=\"\",\"\",IF(OR(F117=\"UR\",F117=\"OR\"),\"X\",IF(AND(ABS(G117)>2,G117<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"",""]
[]
[null,"Retest After Recalibration"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D126),\"NA\",D126-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D126),\"NA\",D126+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D126))),(F126-D126),\" \")","v":" "},null,{"$f":"IF(F126=\"\",\"\",IF(OR(F126=\"UR\",F126=\"OR\"),\"\",IF(ABS(G126)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F126=\"\",\"\",IF(OR(F126=\"UR\",F126=\"OR\"),\"X\",IF(AND(ABS(G126)>2,G126<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 2","NA",null,"NA",null," ",null,{"$f":"IF(F127=\"\",\"\",IF(OR(F127=\"UR\",F127=\"OR\"),\"\",IF(ABS(G127)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F127=\"\",\"\",IF(OR(F127=\"UR\",F127=\"OR\"),\"X\",IF(AND(ABS(G127)>2,G127<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"",""]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Pressure Check\",\"Pressure Audit\")","v":"Pressure Audit"}]
[null,null,null,"mm Hg",null,null,null,null," Within ± 10 mm Hg?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D138),\"NA\",D138-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D138),\"NA\",D138+10)","v":"NA"},null,{"$f":"IF((D138>0),(F138-D138),\" \")","v":" "},null,{"$f":"IF(F138=\"\",\"\",IF(OR(F138=\"UR\",F138=\"OR\"),\"\",IF(ABS(G138)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F138=\"\",\"\",IF(OR(F138=\"UR\",F138=\"OR\"),\"X\",IF(AND(ABS(G138)>10,G138<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest after recalibration"]
[]
[null,null,{"$f":"IF(ISBLANK(D141),\"NA\",D141-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D141),\"NA\",D141+10)","v":"NA"},null,{"$f":"IF((D141>0),(F141-D141),\" \")","v":" "},null,{"$f":"IF(F141=\"\",\"\",IF(OR(F141=\"UR\",F141=\"OR\"),\"\",IF(ABS(G141)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F141=\"\",\"\",IF(OR(F141=\"UR\",F141=\"OR\"),\"X\",IF(AND(ABS(G141)>10,G141<>\" \"),\"X\",\" \")))","v":""}]

{"sheet":"SASS_Super SASS collocated","index":3,"n_rows":141,"n_cols":11,"rows_kept":141,"cut":false,"hidden":false,"merged":[[135,8,135,9],[33,1,35,9],[36,2,36,4],[36,6,37,6],[43,7,43,9],[104,8,104,9],[113,8,113,9],[26,3,26,5],[26,8,26,9],[25,8,25,9],[23,4,23,5],[25,4,25,5],[24,3,24,5],[27,4,27,5],[27,8,27,9],[4,2,4,5],[12,2,12,5],[12,7,12,9],[13,2,13,5],[15,1,15,2],[15,3,15,5],[8,4,8,6],[15,7,15,9],[4,7,4,9],[5,2,5,5],[16,7,16,9],[17,7,17,9],[19,3,19,5],[19,8,19,9],[1,4,2,4],[24,8,24,9],[23,8,23,9],[22,8,22,9],[10,2,10,5],[11,2,11,5],[22,3,22,5],[10,7,10,9]]}
[null,"Chemical Speciation Network",null,null,null,null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", IF(Op_Aff=\"\",\"\",Op_Aff), IF(A_Aff=\"\",\"\",A_Aff))","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check Worksheet\",\"Performance Audit Worksheet\")","v":"Performance Audit Worksheet"},null,null,"Version Date:"]
[null,"Met One SASS/Super SASS - Collocated Sampler",null,null,null,{"$f":"IF(V_Date=\"\",\"\",V_Date)","v":"2024-10-16"}]
[null,"Note - blue fields are entered from 'General Info' worksheet or calculated - orange fields are to be filled in here"]
[null,"Location",{"$f":"IF(M_site=\"\",\"\",M_site)","v":""},null,null,null,"Date",{"$f":"IF('General Info'!F14=\"\",\"\",'General Info'!F14)","v":""}]
[null,"AQS Site ID",{"$f":"IF(S_ID=\"\",\"\",S_ID)","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(Location_Name),ISBLANK(AQS_Site_Code),ISBLANK(D7),H5=\"\"),\"Missing Date, Site Name, Site Code, or POC\",\"\")","v":"Missing Date, Site Name, Site Code, or POC"}]
[null,"AQS Sampler POC"]
[null,"Site Information"]
[null,null,null,"Sampler Type (Model)","Select From Dropdown List"]
[]
[null,"Auditor(s)",{"$f":"IF(A_Name=\"\",\"\",A_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(A_Aff=\"\",\"\",A_Aff)","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Agency Type\",\"Audit Type\")","v":"Audit Type"},{"$f":"IF(A_Type=\"\",\"\",IF(A_Type=\"Select From Dropdown List\",\"\",A_Type))","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(C12),'General Info'!F13=\"Select From Dropdown List\"),\"Missing Agency Type!\",\"\")","v":"Missing Agency Type!"}]
[null,"Operator(s)",{"$f":"IF(OP_Name=\"\",\"\",OP_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(Op_Aff=\"\",\"\",Op_Aff)","v":""}]
[null,"Phone No.",{"$f":"IF(Phone=\"\",\"\",Phone)","v":""}]
[]
[null,null,null,null,null,null,"Sampler S/N"]
[null,null,null,null,null,null,"Head S/N"]
[null,null,null,null,null,null,"Pump S/N"]
[]
[null,null,"Last Calibration Date"]
[]
[null,"Reference Standards"]
[null,null,"Flow Reference Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"Temperature Ref Std Model",null,null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"BP Std Model",null,null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[]
[]
[]
[null,{"$f":"B3","v":"Met One SASS/Super SASS - Collocated Sampler"}]
[null,"Clock/timer Verification"]
[null,"If local time is under daylight saving, convert Ref Std to Local Standard Time. Daylight Saving Time begins for most of the United States at 2:00 a.m. on the second Sunday of March. Time reverts to standard time at 2:00 a.m. on the first Sunday of November."]
[]
[]
[null,null,"Time (hh:mm)",null,null,null,"Difference Minutes",null,"     1 minutes or less?"]
[null,null,"Ref Std",null,"SASS",null,null,null,"Pass","Fail"]
[null,"Check Time",null,null,null,null,{"$f":"IF(ISBLANK(SA_02_00_D_S),\"\",ROUND(((SA_02_00_D_S+SA_02_00_TI_S_R)-(SA_02_00_D_R+SA_02_00_TI_R_R))*24*60,0))","v":""},null,{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date","v":""},null,null,{"$f":"IF(ISBLANK(E40), \"Missing Sampler Date!\",IF(INT(C40)<>INT(E40),\"Sampler and Audit Clock Dates Don't Match!\",\"\"))","v":"Missing Sampler Date!"}]
[null,"Recalib Time",null,null,null,null,{"$f":"IF(E41=\"\",\"\",ROUND(((E42+E41) -(C42+C41))*24*60,0))","v":""},null,{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date","v":""},null,null,{"$f":"IF(AND(G39>1,OR(ISBLANK(E41), ISBLANK(E42))),\"Missing Recalib Time or Date!\",\"\")","v":"Missing Recalib Time or Date!"}]
[null,"Leak Test"]
[null,null,"Initial Check",null,null,"After Correction",null,"   Greater than 0.10 L/min fails"]
[null,null,"A  L/min",null,null,"B  L/min",null,"Pass","Fail A","Fail B"]
[null,"Channel 1",null,null,"Channel 1",null,null,{"$f":"IF(AND(F46<>\"\",F46<=0.1),\"X\",IF(F46>0.1,\"\",IF(AND(C46<>\"\",C46<=0.1),\"X\",\" \")))","v":" "},{"$f":"IF((C46>0.1),\"X\",\"\")","v":""},{"$f":"IF((F46>0.1),\"X\",\"\")","v":""}]
[null,"Channel 2",null,null,"Channel 2",null,null,{"$f":"IF(AND(F47<>\"\",F47<=0.1),\"X\",IF(F47>0.1,\"\",IF(AND(C47<>\"\",C47<=0.1),\"X\",\" \")))","v":" "},{"$f":"IF((C47>0.1),\"X\",\"\")","v":""},{"$f":"IF((F47>0.1),\"X\",\"\")","v":""}]
[null,"Channel 3",null,null,"Channel 3",null,null," ",{"$f":"IF((C48>0.1),\"X\",\"\")","v":""},""]
[null,"Channel 4",null,null,"Channel 4",null,null," ","",""]
[null,"Channel 5",null,null,"Channel 5",null,null," ","",""]
[null,"Channel 6",null,null,"Channel 6",null,null," ","",""]
[null,"Channel 7",null,null,"Channel 7",null,null," ","",""]
[null,"Channel 8",null,null,"Channel 8",null,null," ","",""]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check\", \"Flow Audit\")","v":"Flow Audit"}]
[null,"For the reference standard, enter \"UR\" for under range and \"OR\" for over range flow readings."]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","SASS - Ref",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D59),\"NA\",D59*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D59),\"NA\",D59*1.1)","v":"NA"},null,{"$f":"IF((D59>0),(F59-D59)/D59*100,\" \")","v":" "},null,{"$f":"IF(D59=\"\",\"\",IF(OR(D59=\"UR\",D59=\"OR\"),\"\",IF(ABS(G59)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D59=\"\",\"\",IF(OR(D59=\"UR\",D59=\"OR\",D59=\"\"),\"X\",IF(AND(ABS(G59)>10,G59<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D59),\"\",ABS(G59)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G59)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G59)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2","NA",null,"NA",null,{"$f":"IF((D60>0),(F60-D60)/D60*100,\" \")","v":" "},null,{"$f":"IF(D60=\"\",\"\",IF(OR(D60=\"UR\",D60=\"OR\"),\"\",IF(ABS(G60)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D60=\"\",\"\",IF(OR(D60=\"UR\",D60=\"OR\",D60=\"\"),\"X\",IF(AND(ABS(G60)>10,G60<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D60),\"\",ABS(G60)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G60)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G60)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"","",""]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","SASS - Ref",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D70),\"NA\",D70*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D70),\"NA\",D70*1.1)","v":"NA"},null,{"$f":"IF((D70>0),(F70-D70)/D70*100,\" \")","v":" "},null,{"$f":"IF(D70=\"\",\"\",IF(OR(D70=\"UR\",D70=\"OR\"),\"\",IF(ABS(G70)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D70=\"\",\"\",IF(OR(D70=\"UR\",D70=\"OR\",D70=\"\"),\"X\",IF(AND(ABS(G70)>10,G70<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D70),\"\",ABS(G70)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G70)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G70)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2","NA",null,"NA",null," ",null,"","",{"$f":"_xlfn.IFS(ISBLANK(D71),\"\",ABS(G71)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G71)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G71)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"","",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"","",""]
[]
[]
[null,{"$f":"B3","v":"Met One SASS/Super SASS - Collocated Sampler"}]
[null,null,null,null,"Reference Standard vs Design Flow"]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","SASS","Upper Limit","Ref Std","Ref-Design",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D84),\"NA\",D84*0.9)","v":6.03},6.7,{"$f":"IF(ISBLANK(D84),\"NA\",D84*1.1)","v":7.370000000000001},{"$f":"IF(D59<>\"\",D59,\"\")","v":""},{"$f":"IF((F84<>\"\"),(F84-D84)/D84*100,\" \")","v":" "},null,{"$f":"IF(F84=\"\",\"\",IF(OR(F84=\"UR\",F84=\"OR\"),\"\",IF(ABS(G84)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F84=\"\",\"\",IF(OR(F84=\"UR\",F84=\"OR\"),\"X\",IF(AND(ABS(G84)>10,G84<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D59),\"\",ABS(G84)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G84)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G84)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2",6.03,6.7,7.370000000000001,{"$f":"IF(D60<>\"\",D60,\"\")","v":""},{"$f":"IF((F85<>\"\"),(F85-D85)/D85*100,\" \")","v":" "},null,{"$f":"IF(F85=\"\",\"\",IF(OR(F85=\"UR\",F85=\"OR\"),\"\",IF(ABS(G85)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F85=\"\",\"\",IF(OR(F85=\"UR\",F85=\"OR\"),\"X\",IF(AND(ABS(G85)>10,G85<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D60),\"\",ABS(G85)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G85)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G85)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3",6.03,6.7,7.370000000000001,{"$f":"IF(D61<>\"\",D61,\"\")","v":""}," ",null,"","",""]
[null,"Channel 4",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 5",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 6",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 7",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 8",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,"% Difference",null,"     Within ± 10%?"]
[null,null,"Lower Limit","SASS","Upper Limit","Ref Std","Ref-Design",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D95),\"NA\",D95*0.9)","v":6.03},6.7,{"$f":"IF(ISBLANK(D95),\"NA\",D95*1.1)","v":7.370000000000001},{"$f":"IF(D70<>\"\",D70,\"\")","v":""},{"$f":"IF((F95<>\"\"),(F95-D95)/D95*100,\" \")","v":" "},null,{"$f":"IF(F95=\"\",\"\",IF(OR(F95=\"UR\",F95=\"OR\"),\"\",IF(ABS(G95)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F95=\"\",\"\",IF(OR(F95=\"UR\",F95=\"OR\"),\"X\",IF(AND(ABS(G95)>10,G95<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D70),\"\",ABS(G95)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G95)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G95)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 2",6.03,6.7,7.370000000000001,""," ",null,"","",{"$f":"_xlfn.IFS(ISBLANK(D71),\"\",ABS(G96)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G96)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G96)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[null,"Channel 3",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 4",6.03,6.7,7.370000000000001,null," ",null,"","",""]
[null,"Channel 5",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 6",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 7",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[null,"Channel 8",6.03,6.7,7.370000000000001,""," ",null,"","",""]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Ambient Temperature Check\", \"Ambient Temperature Audit\")","v":"Ambient Temperature Audit"}]
[null,null,null,"Degrees C",null,null,null,null,"Within ± 2 degrees C?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D107),\"NA\",D107-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D107),\"NA\",D107+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D107))),(F107-D107),\" \")","v":" "},null,{"$f":"IF(F107=\"\",\"\",IF(OR(F107=\"UR\",F107=\"OR\"),\"\",IF(ABS(G107)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F107=\"\",\"\",IF(OR(F107=\"UR\",F107=\"OR\"),\"X\",IF(AND(ABS(G107)>2,G107<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest After Recalibration"]
[null,null,{"$f":"IF(ISBLANK(D109),\"NA\",D109-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D109),\"NA\",D109+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D109))),(F109-D109),\" \")","v":" "},null,{"$f":"IF(F109=\"\",\"\",IF(OR(F109=\"UR\",F109=\"OR\"),\"\",IF(ABS(G109)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F109=\"\",\"\",IF(OR(F109=\"UR\",F109=\"OR\"),\"X\",IF(AND(ABS(G109)>2,G109<>\" \"),\"X\",\" \")))","v":""}]
[]
[]
[null,{"$f":"B3","v":"Met One SASS/Super SASS - Collocated Sampler"}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Filter Temperature Check\", \"Filter Temperature Audit\")","v":"Filter Temperature Audit"}]
[null,null,null,"Degrees C",null,null,null,null,"Within ± 2 degrees C?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D116),\"NA\",D116-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D116),\"NA\",D116+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D116))),(F116-D116),\" \")","v":" "},null,{"$f":"IF(F116=\"\",\"\",IF(OR(F116=\"UR\",F116=\"OR\"),\"\",IF(ABS(G116)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F116=\"\",\"\",IF(OR(F116=\"UR\",F116=\"OR\"),\"X\",IF(AND(ABS(G116)>2,G116<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 2","NA",null,"NA",null," ",null,{"$f":"IF(F117=\"\",\"\",IF(OR(F117=\"UR\",F117=\"OR\"),\"\",IF(ABS(G117)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F117=\"\",\"\",IF(OR(F117=\"UR\",F117=\"OR\"),\"X\",IF(AND(ABS(G117)>2,G117<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"",""]
[]
[null,"Retest After Recalibration"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D126),\"NA\",D126-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D126),\"NA\",D126+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D126))),(F126-D126),\" \")","v":" "},null,{"$f":"IF(F126=\"\",\"\",IF(OR(F126=\"UR\",F126=\"OR\"),\"\",IF(ABS(G126)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F126=\"\",\"\",IF(OR(F126=\"UR\",F126=\"OR\"),\"X\",IF(AND(ABS(G126)>2,G126<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 2","NA",null,"NA",null," ",null,{"$f":"IF(F127=\"\",\"\",IF(OR(F127=\"UR\",F127=\"OR\"),\"\",IF(ABS(G127)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F127=\"\",\"\",IF(OR(F127=\"UR\",F127=\"OR\"),\"X\",IF(AND(ABS(G127)>2,G127<>\" \"),\"X\",\" \")))","v":""}]
[null,"Channel 3","NA",null,"NA",null," ",null,"",""]
[null,"Channel 4","NA",null,"NA",null," ",null,"",""]
[null,"Channel 5","NA",null,"NA",null," ",null,"",""]
[null,"Channel 6","NA",null,"NA",null," ",null,"",""]
[null,"Channel 7","NA",null,"NA",null," ",null,"",""]
[null,"Channel 8","NA",null,"NA",null," ",null,"",""]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Pressure Check\",\"Pressure Audit\")","v":"Pressure Audit"}]
[null,null,null,"mm Hg",null,null,null,null," Within ± 10 mm Hg?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","SASS","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D138),\"NA\",D138-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D138),\"NA\",D138+10)","v":"NA"},null,{"$f":"IF((D138>0),(F138-D138),\" \")","v":" "},null,{"$f":"IF(F138=\"\",\"\",IF(OR(F138=\"UR\",F138=\"OR\"),\"\",IF(ABS(G138)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F138=\"\",\"\",IF(OR(F138=\"UR\",F138=\"OR\"),\"X\",IF(AND(ABS(G138)>10,G138<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest after recalibration"]
[]
[null,null,{"$f":"IF(ISBLANK(D141),\"NA\",D141-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D141),\"NA\",D141+10)","v":"NA"},null,{"$f":"IF((D141>0),(F141-D141),\" \")","v":" "},null,{"$f":"IF(F141=\"\",\"\",IF(OR(F141=\"UR\",F141=\"OR\"),\"\",IF(ABS(G141)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F141=\"\",\"\",IF(OR(F141=\"UR\",F141=\"OR\"),\"X\",IF(AND(ABS(G141)>10,G141<>\" \"),\"X\",\" \")))","v":""}]

{"sheet":"URG","index":4,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[69,8,69,9],[76,8,76,9],[82,1,82,9],[33,1,35,9],[36,2,36,4],[36,6,37,6],[43,7,43,9],[25,4,25,5],[23,4,23,5],[25,8,25,9],[24,3,24,5],[20,8,20,9],[21,8,21,9],[22,8,22,9],[22,3,22,5],[24,8,24,9],[1,4,2,4],[4,2,4,5],[5,2,5,5],[4,7,4,9],[21,4,21,5],[9,2,9,5],[14,7,14,9],[9,7,9,9],[14,3,14,5],[10,2,10,5],[15,7,15,9],[18,3,18,5],[11,2,11,5],[11,7,11,9],[12,2,12,5],[16,7,16,9],[20,3,20,5],[23,8,23,9]]}
[null,"Chemical Speciation Network",null,null,null,null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", IF(Op_Aff=\"\",\"\",Op_Aff), IF(A_Aff=\"\",\"\",A_Aff))","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check Worksheet\",\"Performance Audit Worksheet\")","v":"Performance Audit Worksheet"},null,null,"Version Date:"]
[null,"URG 3000N - Primary Sampler",null,null,null,{"$f":"IF(V_Date=\"\",\"\",V_Date)","v":"2024-10-16"}]
[null,"Note - blue fields are entered from 'General Info' worksheet or calculated - orange fields are to be filled in here"]
[null,"Location",{"$f":"IF(M_site=\"\",\"\",M_site)","v":""},null,null,null,"Date",{"$f":"IF('General Info'!F14=\"\",\"\",'General Info'!F14)","v":""}]
[null,"AQS Site ID",{"$f":"IF(S_ID=\"\",\"\",S_ID)","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(Location_Name),ISBLANK(AQS_Site_Code),ISBLANK(D7),H5=\"\"),\"Missing Date, Site Name, Site Code, or POC\",\"\")","v":"Missing Date, Site Name, Site Code, or POC"}]
[null,"AQS Sampler POC"]
[null,"Site Information"]
[]
[null,"Auditor(s)",{"$f":"IF(A_Name=\"\",\"\",A_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(A_Aff=\"\",\"\",A_Aff)","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Agency Type\",\"Audit Type\")","v":"Audit Type"},{"$f":"IF(A_Type=\"\",\"\",IF(A_Type=\"Select From Dropdown List\",\"\",A_Type))","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(C12),'General Info'!F13=\"Select From Dropdown List\"),\"Missing Agency Type!\",\"\")","v":"Missing Agency Type!"}]
[null,"Operator(s)",{"$f":"IF(OP_Name=\"\",\"\",OP_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(Op_Aff=\"\",\"\",Op_Aff)","v":""}]
[null,"Phone No.",{"$f":"IF(Phone=\"\",\"\",Phone)","v":""}]
[]
[null,null,"Sampler Model","URG 3000 N",null,null,"Controller S/N"]
[null,null,null,null,null,null,"Pump S/N"]
[null,null,null,null,null,null,"Sampler S/N"]
[]
[null,null,"Last Calibration Date"]
[null,"Reference Standards"]
[null,null,"Flow Reference Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"Temperature Ref Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"BP Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[]
[]
[]
[]
[]
[null,{"$f":"B3","v":"URG 3000N - Primary Sampler"}]
[null,"Clock/timer Verification"]
[null,"If local time is under daylight saving, convert Ref Std to Local Standard Time. Daylight Saving Time begins for most of the United States at 2:00 a.m. on the second Sunday of March. Time reverts to standard time at 2:00 a.m. on the first Sunday of November."]
[]
[]
[null,null,"Time (hh:mm)",null,null,null,"Difference Minutes",null,"     1 minutes or less?"]
[null,null,"Ref Std",null,"URG",null,null,null,"Pass","Fail"]
[null,"Check Time",null,null,null,null,{"$f":"IF(ISBLANK(URG_01_00_TI_S),\"\",ROUND(((URG_01_00_D_S+URG_01_00_TI_S)-(URG_01_00_D_R+URG_01_00_TI_R))*24*60,0))","v":""},null,{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date3","v":""},null,null,{"$f":"IF(ISBLANK(E40), \"Missing Sampler Date!\",IF(INT(C40)<>INT(E40),\"Sampler and Audit Clock Dates Don't Match!\",\"\"))","v":"Missing Sampler Date!"}]
[null,"Recalib Time",null,null,null,null,{"$f":"IF(E41=\"\",\"\",ROUND(((E42+E41) -(C42+C41))*24*60,0))","v":""},null,{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date","v":""},null,null,{"$f":"IF(AND(G39>1,OR(ISBLANK(E41), ISBLANK(E42))),\"Missing Recalib Time or Date!\",\"\")","v":"Missing Recalib Time or Date!"}]
[null,"Leak Test"]
[null,null,"Initial Check",null,null,"After Correction",null,"  Fails if drop > 225 mm Hg"]
[null,null,"A  mm Hg",null,null,"B  mm Hg",null,"Pass","Fail A","Fail B"]
[null,"Channel 1",null,null,"Channel 1",null,null,{"$f":"IF(AND(F46<>\"\",F46<=225),\"X\",IF(F46>225,\"\",IF(AND(C46<>\"\",C46<=225),\"X\",\" \")))","v":" "},{"$f":"IF((C46>225),\"X\",\"\")","v":""},{"$f":"IF((F46>225),\"X\",\"\")","v":""}]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check\", \"Flow Audit\")","v":"Flow Audit"}]
[null,"For the reference standard, enter \"UR\" for under range and \"OR\" for over range flow readings."]
[null,null,null,"L/min",null,null,null,null,"     Less than 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D52),\"NA\",D52*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D52),\"NA\",D52*1.1)","v":"NA"},null,{"$f":"IF((D52>0),(F52-D52)/D52*100,\" \")","v":" "},null,{"$f":"IF(D52=\"\",\"\",IF(OR(D52=\"UR\",D52=\"OR\"),\"\",IF(ABS(G52)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D52=\"\",\"\",IF(OR(D52=\"UR\",D52=\"OR\",D52=\"\"),\"X\",IF(AND(ABS(G52)>10,G52<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D52),\"\",ABS(G52)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G52)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G52)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,null,null,"      Less than 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D57),\"NA\",D57*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D57),\"NA\",D57*1.1)","v":"NA"},null,{"$f":"IF((D57>0),(F57-D57)/D57*100,\" \")","v":" "},null,{"$f":"IF(D57=\"\",\"\",IF(OR(D57=\"UR\",D57=\"OR\"),\"\",IF(ABS(G57)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D57=\"\",\"\",IF(OR(D57=\"UR\",D57=\"OR\",D57=\"\"),\"X\",IF(AND(ABS(G57)>10,G57<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D57),\"\",ABS(G57)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G57)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G57)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,null,null,null,"Reference Standard vs Design Flow"]
[null,null,null,"L/min",null,null,null,null,"       Less than 10%?"]
[null,null,"Lower Limit","URG","Upper Limit","Ref Std","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D62),\"NA\",D62*0.9)","v":19.8},22,{"$f":"IF(ISBLANK(D62),\"NA\",D62*1.1)","v":24.200000000000003},{"$f":"IF(D52<>\"\",D52,\"\")","v":""},{"$f":"IF((F62<>\"\"),(F62-D62)/D62*100,\" \")","v":" "},null,{"$f":"IF(F62=\"\",\"\",IF(OR(F62=\"UR\",F62=\"OR\"),\"\",IF(ABS(G62)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F62=\"\",\"\",IF(OR(F62=\"UR\",F62=\"OR\"),\"X\",IF(AND(ABS(G62)>10,G62<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D52),\"\",ABS(G62)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G62)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G62)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,null,null,"       Less than 10%?"]
[null,null,"Lower Limit","URG","Upper Limit","Ref Std","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D67),\"NA\",D67*0.9)","v":19.8},22,{"$f":"IF(ISBLANK(D67),\"NA\",D67*1.1)","v":24.200000000000003},{"$f":"IF(D57<>\"\",D57,\"\")","v":""},{"$f":"IF((F67<>\"\"),(F67-D67)/D67*100,\" \")","v":" "},null,{"$f":"IF(F67=\"\",\"\",IF(OR(F67=\"UR\",F67=\"OR\"),\"\",IF(ABS(G67)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F67=\"\",\"\",IF(OR(F67=\"UR\",F67=\"OR\"),\"X\",IF(AND(ABS(G67)>10,G67<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D57),\"\",ABS(G67)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G67)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G67)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Ambient Temperature Check\", \"Ambient Temperature Audit\")","v":"Ambient Temperature Audit"}]
[null,null,null,"Degrees C",null,null,null,null,"Within ± 2 degrees C?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D72),\"NA\",D72-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D72),\"NA\",D72+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D72))),(F72-D72),\" \")","v":" "},null,{"$f":"IF(F72=\"\",\"\",IF(OR(F72=\"UR\",F72=\"OR\"),\"\",IF(ABS(G72)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F72=\"\",\"\",IF(OR(F72=\"UR\",F72=\"OR\"),\"X\",IF(AND(ABS(G72)>2,G72<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest After Recalibration"]
[null,null,{"$f":"IF(ISBLANK(D74),\"NA\",D74-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D74),\"NA\",D74+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D74))),(F74-D74),\" \")","v":" "},null,{"$f":"IF(F74=\"\",\"\",IF(OR(F74=\"UR\",F74=\"OR\"),\"\",IF(ABS(G74)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F74=\"\",\"\",IF(OR(F74=\"UR\",F74=\"OR\"),\"X\",IF(AND(ABS(G74)>2,G74<>\" \"),\"X\",\" \")))","v":""}]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Pressure Check\",\"Pressure Audit\")","v":"Pressure Audit"}]
[null,null,null,"mm Hg",null,null,null,null," Within ± 10 mm Hg?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D79),\"NA\",D79-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D79),\"NA\",D79+10)","v":"NA"},null,{"$f":"IF((D79>0),(F79-D79),\" \")","v":" "},null,{"$f":"IF(F79=\"\",\"\",IF(OR(F79=\"UR\",F79=\"OR\"),\"\",IF(ABS(G79)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F79=\"\",\"\",IF(OR(F79=\"UR\",F79=\"OR\"),\"X\",IF(AND(ABS(G79)>10,G79<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest after recalibration"]
[null,null,{"$f":"IF(ISBLANK(D81),\"NA\",D81-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D81),\"NA\",D81+10)","v":"NA"},null,{"$f":"IF((D81>0),(F81-D81),\" \")","v":" "},null,{"$f":"IF(F81=\"\",\"\",IF(OR(F81=\"UR\",F81=\"OR\"),\"\",IF(ABS(G81)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F81=\"\",\"\",IF(OR(F81=\"UR\",F81=\"OR\"),\"X\",IF(AND(ABS(G81)>10,G81<>\" \"),\"X\",\" \")))","v":""}]

{"sheet":"URG_collocated","index":5,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[82,1,82,9],[33,1,35,9],[36,2,36,4],[36,6,37,6],[43,7,43,9],[69,8,69,9],[76,8,76,9],[24,3,24,5],[24,8,24,9],[25,4,25,5],[25,8,25,9],[22,3,22,5],[23,8,23,9],[23,4,23,5],[22,8,22,9],[9,2,9,5],[11,2,11,5],[11,7,11,9],[12,2,12,5],[1,4,2,4],[4,2,4,5],[5,2,5,5],[4,7,4,9],[9,7,9,9],[10,2,10,5],[18,3,18,5],[14,7,14,9],[20,3,20,5],[21,8,21,9],[21,4,21,5],[14,3,14,5],[15,7,15,9],[16,7,16,9],[20,8,20,9]]}
[null,"Chemical Speciation Network",null,null,null,null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", IF(Op_Aff=\"\",\"\",Op_Aff), IF(A_Aff=\"\",\"\",A_Aff))","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check Worksheet\",\"Performance Audit Worksheet\")","v":"Performance Audit Worksheet"},null,null,"Version Date:"]
[null,"URG 3000N - Collocated Sampler",null,null,null,{"$f":"IF(V_Date=\"\",\"\",V_Date)","v":"2024-10-16"}]
[null,"Note - blue fields are entered from 'General Info' worksheet or calculated - orange fields are to be filled in here"]
[null,"Location",{"$f":"IF(M_site=\"\",\"\",M_site)","v":""},null,null,null,"Date",{"$f":"IF('General Info'!F14=\"\",\"\",'General Info'!F14)","v":""}]
[null,"AQS Site ID",{"$f":"IF(S_ID=\"\",\"\",S_ID)","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(Location_Name),ISBLANK(AQS_Site_Code),ISBLANK(D7),H5=\"\"),\"Missing Date, Site Name, Site Code, or POC\",\"\")","v":"Missing Date, Site Name, Site Code, or POC"}]
[null,"AQS Sampler POC"]
[null,"Site Information"]
[]
[null,"Auditor(s)",{"$f":"IF(A_Name=\"\",\"\",A_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(A_Aff=\"\",\"\",A_Aff)","v":""}]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Agency Type\",\"Audit Type\")","v":"Audit Type"},{"$f":"IF(A_Type=\"\",\"\",IF(A_Type=\"Select From Dropdown List\",\"\",A_Type))","v":""},null,null,null,{"$f":"IF(OR(ISBLANK(C12),'General Info'!F13=\"Select From Dropdown List\"),\"Missing Agency Type!\",\"\")","v":"Missing Agency Type!"}]
[null,"Operator(s)",{"$f":"IF(OP_Name=\"\",\"\",OP_Name)","v":""},null,null,null,"Affiliation",{"$f":"IF(Op_Aff=\"\",\"\",Op_Aff)","v":""}]
[null,"Phone No.",{"$f":"IF(Phone=\"\",\"\",Phone)","v":""}]
[]
[null,null,"Sampler Model","URG 3000 N",null,null,"Controller S/N"]
[null,null,null,null,null,null,"Pump S/N"]
[null,null,null,null,null,null,"Sampler S/N"]
[]
[null,null,"Last Calibration Date"]
[null,"Reference Standards"]
[null,null,"Flow Reference Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"Temperature Ref Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[null,null,"BP Std Model","Select From Dropdown List",null,null,null,"Standard S/N"]
[null,null,null,"Specify if \"Other\"",null,null,null,"Calibration Date"]
[]
[]
[]
[]
[]
[null,{"$f":"B3","v":"URG 3000N - Collocated Sampler"}]
[null,"Clock/timer Verification"]
[null,"If local time is under daylight saving, convert Ref Std to Local Standard Time. Daylight Saving Time begins for most of the United States at 2:00 a.m. on the second Sunday of March. Time reverts to standard time at 2:00 a.m. on the first Sunday of November."]
[]
[]
[null,null,"Time (hh:mm)",null,null,null,"Difference Minutes",null,"     1 minutes or less?"]
[null,null,"Ref Std",null,"URG",null,null,null,"Pass","Fail"]
[null,"Check Time",null,null,null,null,{"$f":"IF(ISBLANK(URG_01_00_TI_S),\"\",ROUND(((URG_01_00_D_S+URG_01_00_TI_S)-(URG_01_00_D_R+URG_01_00_TI_R))*24*60,0))","v":""},null,{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C39=\"\",\"\",IF(ABS(G39)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date3","v":""},null,null,{"$f":"IF(ISBLANK(E40), \"Missing Sampler Date!\",IF(INT(C40)<>INT(E40),\"Sampler and Audit Clock Dates Don't Match!\",\"\"))","v":"Missing Sampler Date!"}]
[null,"Recalib Time",null,null,null,null,{"$f":"IF(E41=\"\",\"\",ROUND(((E42+E41) -(C42+C41))*24*60,0))","v":""},null,{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)<=1,\"X\",\"\"))","v":""},{"$f":"IF(C41=\"\",\"\",IF(ABS(G41)>1,\"X\",\"\"))","v":""}]
[null,"Date",{"$f":"Audit_Date3","v":""},null,null,{"$f":"IF(AND(G39>1,OR(ISBLANK(E41), ISBLANK(E42))),\"Missing Recalib Time or Date!\",\"\")","v":"Missing Recalib Time or Date!"}]
[null,"Leak Test"]
[null,null,"Initial Check",null,null,"After Correction",null,"  Fails if drop > 225 mm Hg"]
[null,null,"A  mm Hg",null,null,"B  mm Hg",null,"Pass","Fail A","Fail B"]
[null,"Channel 1",null,null,"Channel 1",null,null,{"$f":"IF(AND(F46<>\"\",F46<=225),\"X\",IF(F46>225,\"\",IF(AND(C46<>\"\",C46<=225),\"X\",\" \")))","v":" "},{"$f":"IF((C46>225),\"X\",\"\")","v":""},{"$f":"IF((F46>225),\"X\",\"\")","v":""}]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\",\"Flow Check\", \"Flow Audit\")","v":"Flow Audit"}]
[null,"For the reference standard, enter \"UR\" for under range and \"OR\" for over range flow readings."]
[null,null,null,"L/min",null,null,null,null,"     Less than 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D52),\"NA\",D52*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D52),\"NA\",D52*1.1)","v":"NA"},null,{"$f":"IF((D52>0),(F52-D52)/D52*100,\" \")","v":" "},null,{"$f":"IF(D52=\"\",\"\",IF(OR(D52=\"UR\",D52=\"OR\"),\"\",IF(ABS(G52)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D52=\"\",\"\",IF(OR(D52=\"UR\",D52=\"OR\",D52=\"\"),\"X\",IF(AND(ABS(G52)>10,G52<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D52),\"\",ABS(G52)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G52)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G52)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,null,null,"      Less than 10%?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D57),\"NA\",D57*0.9)","v":"NA"},null,{"$f":"IF(ISBLANK(D57),\"NA\",D57*1.1)","v":"NA"},null,{"$f":"IF((D57>0),(F57-D57)/D57*100,\" \")","v":" "},null,{"$f":"IF(D57=\"\",\"\",IF(OR(D57=\"UR\",D57=\"OR\"),\"\",IF(ABS(G57)<=10,\"X\",\"\")))","v":""},{"$f":"IF(D57=\"\",\"\",IF(OR(D57=\"UR\",D57=\"OR\",D57=\"\"),\"X\",IF(AND(ABS(G57)>10,G57<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D57),\"\",ABS(G57)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G57)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G57)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,null,null,null,"Reference Standard vs Design Flow"]
[null,null,null,"L/min",null,null,null,null,"       Less than 10%?"]
[null,null,"Lower Limit","URG","Upper Limit","Ref Std","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D62),\"NA\",D62*0.9)","v":19.8},22,{"$f":"IF(ISBLANK(D62),\"NA\",D62*1.1)","v":24.200000000000003},{"$f":"IF(D52<>\"\",D52,\"\")","v":""},{"$f":"IF((F62<>\"\"),(F62-D62)/D62*100,\" \")","v":" "},null,{"$f":"IF(F62=\"\",\"\",IF(OR(F62=\"UR\",F62=\"OR\"),\"\",IF(ABS(G62)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F62=\"\",\"\",IF(OR(F62=\"UR\",F62=\"OR\"),\"X\",IF(AND(ABS(G62)>10,G62<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D52),\"\",ABS(G62)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G62)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G62)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,"Retest after Calibration"]
[null,null,null,"L/min",null,null,null,null,"       Less than 10%?"]
[null,null,"Lower Limit","URG","Upper Limit","Ref Std","% Difference",null,"Pass","Fail"]
[null,"Channel 1",{"$f":"IF(ISBLANK(D67),\"NA\",D67*0.9)","v":19.8},22,{"$f":"IF(ISBLANK(D67),\"NA\",D67*1.1)","v":24.200000000000003},{"$f":"IF(D57<>\"\",D57,\"\")","v":""},{"$f":"IF((F67<>\"\"),(F67-D67)/D67*100,\" \")","v":" "},null,{"$f":"IF(F67=\"\",\"\",IF(OR(F67=\"UR\",F67=\"OR\"),\"\",IF(ABS(G67)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F67=\"\",\"\",IF(OR(F67=\"UR\",F67=\"OR\"),\"X\",IF(AND(ABS(G67)>10,G67<>\" \"),\"X\",\" \")))","v":""},{"$f":"_xlfn.IFS(ISBLANK(D57),\"\",ABS(G67)>10,\"Red cells indicate a recalibration is needed and affected data must be invalidated.\",ABS(G67)>5,\"A yellow cell indicates a recalibration is needed, but affected data do not need to be invalidated\",ABS(G67)<=5,\"Green cells indicate a good or acceptable value, and no corrective action is needed.\")","v":""}]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Ambient Temperature Check\", \"Ambient Temperature Audit\")","v":"Ambient Temperature Audit"}]
[null,null,null,"Degrees C",null,null,null,null,"Within ± 2 degrees C?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D72),\"NA\",D72-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D72),\"NA\",D72+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D72))),(F72-D72),\" \")","v":" "},null,{"$f":"IF(F72=\"\",\"\",IF(OR(F72=\"UR\",F72=\"OR\"),\"\",IF(ABS(G72)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F72=\"\",\"\",IF(OR(F72=\"UR\",F72=\"OR\"),\"X\",IF(AND(ABS(G72)>2,G72<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest After Recalibration"]
[null,null,{"$f":"IF(ISBLANK(D74),\"NA\",D74-2)","v":"NA"},null,{"$f":"IF(ISBLANK(D74),\"NA\",D74+2)","v":"NA"},null,{"$f":"IF(NOT(ISBLANK((D74))),(F74-D74),\" \")","v":" "},null,{"$f":"IF(F74=\"\",\"\",IF(OR(F74=\"UR\",F74=\"OR\"),\"\",IF(ABS(G74)<=2,\"X\",\"\")))","v":""},{"$f":"IF(F74=\"\",\"\",IF(OR(F74=\"UR\",F74=\"OR\"),\"X\",IF(AND(ABS(G74)>2,G74<>\" \"),\"X\",\" \")))","v":""}]
[]
[null,{"$f":"IF(Purpose=\"Sampler Monthly Flow Check\", \"Pressure Check\",\"Pressure Audit\")","v":"Pressure Audit"}]
[null,null,null,"mm Hg",null,null,null,null," Within ± 10 mm Hg?"]
[null,null,"Lower Limit","Ref Std","Upper Limit","URG","Difference",null,"Pass","Fail"]
[null,null,{"$f":"IF(ISBLANK(D79),\"NA\",D79-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D79),\"NA\",D79+10)","v":"NA"},null,{"$f":"IF((D79>0),(F79-D79),\" \")","v":" "},null,{"$f":"IF(F79=\"\",\"\",IF(OR(F79=\"UR\",F79=\"OR\"),\"\",IF(ABS(G79)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F79=\"\",\"\",IF(OR(F79=\"UR\",F79=\"OR\"),\"X\",IF(AND(ABS(G79)>10,G79<>\" \"),\"X\",\" \")))","v":""}]
[null,"Retest after recalibration"]
[null,null,{"$f":"IF(ISBLANK(D81),\"NA\",D81-10)","v":"NA"},null,{"$f":"IF(ISBLANK(D81),\"NA\",D81+10)","v":"NA"},null,{"$f":"IF((D81>0),(F81-D81),\" \")","v":" "},null,{"$f":"IF(F81=\"\",\"\",IF(OR(F81=\"UR\",F81=\"OR\"),\"\",IF(ABS(G81)<=10,\"X\",\"\")))","v":""},{"$f":"IF(F81=\"\",\"\",IF(OR(F81=\"UR\",F81=\"OR\"),\"X\",IF(AND(ABS(G81)>10,G81<>\" \"),\"X\",\" \")))","v":""}]

{"sheet":"Reference","index":6,"n_rows":54,"n_cols":1,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["This spreadsheet will be hidden in the final version"]
["YNO Box Values"]
["Not_Evaluated"]
["Yes"]
["No"]
["Not_Applicable"]
["Other"]
[]
[]
["SASS Channel Configurations"]
["Select From Dropdown List"]
["SASS "]
["Super SASS"]
[]
[]
["Audit Types"]
["Flow Verification by Site Operator"]
["PQAO"]
["Reporting Org"]
["Federal"]
["Federal Contractor"]
[]
["Flow Reference Methods"]
["Select From Dropdown List"]
["BGI DELTACAL"]
["BGI TETRACAL"]
["BGI TRI CAL"]
["BIOS 20K"]
["BIOS 30K"]
["BIOS 40K"]
["BIOS DEFENDER"]
["BUBBLE FLOW METER"]
["CERTIFIED ORIFICE DEVICE"]
["CHINOOK FTS"]
["DRY TEST METER"]
["DRYCAL DC2 FLOWMETER"]
["ROOTSMETER (CERTIFIED)"]
["WET TEST METER"]
["OTHER FLOW STANDARDS"]
[]
["Temperature Reference Methods"]
["Select From Dropdown List"]
["BGI DELTACAL"]
["BGI TETRACAL"]
["BGI TRI CAL"]
["NIST TRACEABLE THERMOMETER"]
["OTHER"]
[]
["BP Reference Methods"]
["Select From Dropdown List"]
["BGI DELTACAL"]
["BGI TETRACAL"]
["BGI TRI CAL"]
["OTHER"]