{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Summary","DataSheet","Lookup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Summary","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,1],[18,2,18,5],[18,6,18,8],[5,5,5,6],[4,5,4,6],[9,3,9,4],[10,6,10,7],[9,6,9,7],[7,0,7,8],[8,3,8,5],[15,6,15,7],[14,6,14,8],[16,0,16,1],[16,3,16,4],[17,6,17,7],[6,1,6,8],[17,3,17,4],[17,0,17,1],[16,6,16,7],[15,0,15,1],[15,3,15,4],[12,6,12,7],[11,3,11,4],[14,1,14,2],[14,3,14,5],[13,0,13,8],[9,0,9,1],[0,0,0,8],[11,0,11,1],[12,0,12,1],[8,6,8,8],[8,1,8,2],[10,0,10,1],[10,3,10,4],[5,7,5,8],[1,0,1,2],[1,6,1,8],[1,3,1,5],[2,0,2,8],[3,4,3,5],[3,6,3,8],[11,6,11,7]]}
["Monthly Operating Report (MOR) Summary Form\nSubmit Online at www.wqcdcompliance.com/login"]
["Yellow Background = PWS Input Value",null,null,"Blue Background = Calculated Value",null,null,"Red Background = Violation"]
["Public Water System Information Section"]
["PWS ID:","CO0207504","PWS Name:","Meadow Mtn Water Supply","MOR Type:",null,"Membrane"]
["Facility ID:","001","Facility Name:","Meadow Mtn SWTP01","Month:","Oct (10)",null,"Year:",2015]
["Contact Person: ","Rachel Barkworth","Email:","rcbarkworth@yahoo.com","Phone:","303-823-2318",null,"Save as Final State (xlsx)"]
["Comments:"]
[{"$f":"\"Turbidity Combined Filter Effluent (CFE) Summary Section\" & CHAR(10) &\n\"*If at ANY time the turbidity rises above \" & VLOOKUP(G4,Lookup!$C$2:$E$6,3,FALSE) & \" NTU the PWS must contact the department within 24 hours.\"","v":"Turbidity Combined Filter Effluent (CFE) Summary Section\n*If at ANY time the turbidity rises above 0.5 NTU the PWS must contact the department within 24 hours."}]
["Facility ID:","001",null,"Required Number of Samples Per Day:",null,null,1]
["Number of Samples Required:",null,31,"Number of Samples Taken:",null,31,"Number of Plant Offs:",null,0]
["Number of Days Sampling Required:",null,31,"Number of Days Sampling Met:",null,31,"M&R Complied:",null,"Yes"]
[{"$f":"\"Number of Samples Exceeding \" & VLOOKUP(G4,Lookup!$C$2:$E$6,3,FALSE) & \" NTU:\"","v":"Number of Samples Exceeding 0.5 NTU:"},null,0,"Highest Sample:",null,2.1999999999999999E-2,"Max TT Complied:",null,"Yes"]
[{"$f":"\"Number of Samples Exceeding \" & VLOOKUP(G4,Lookup!$C$2:$E$6,2,FALSE) & \" NTU:\"","v":"Number of Samples Exceeding 0.1 NTU:"},null,0,"% Samples Exceeding:",null,0,"95% TT Complied:",null,"Yes"]
[{"$f":"\"Microbial Treatment - Minimum Disinfection Summary Section\" & CHAR(10) &\n\"*If at ANY time the residual falls below \" & DataSheet!R4 & \" mg/L the PWS must contact the department within 48 hours.\"","v":"Microbial Treatment - Minimum Disinfection Summary Section\n*If at ANY time the residual falls below 1.2 mg/L the PWS must contact the department within 48 hours."}]
["Facility ID:","001",null,"Required Number of Samples Per Day:",null,null,1]
["Number of Samples Required:",null,31,"Number of Samples Taken:",null,31,"Number of Plant Offs:",null,0]
["Number of Days Sampling Required:",null,31,"Number of Days Sampling Met:",null,31,"M&R Complied:",null,"Yes"]
[{"$f":"\"Number of Samples Below \" &  DataSheet!R4 & \" mg/L:\"","v":"Number of Samples Below 1.2 mg/L:"},null,0,"Lowest Sample:",null,1.3,"Min TT Complied:",null,"Yes"]
["Longest Duration Below Minimum:",null,"N/A (No Values Below Minimum)"]

{"sheet":"DataSheet","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,15,5,15],[0,1,0,17],[3,2,3,8],[3,9,3,15],[2,1,2,17],[4,16,4,17],[3,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[1,15,1,17],[4,11,5,11],[4,12,5,12],[4,9,5,9],[4,10,5,10],[1,1,1,8],[1,9,1,14],[4,8,5,8],[4,13,5,13],[4,14,5,14]]}
[null,"Monthly Operating Report (MOR) - Data Sheet"]
[null,{"$f":"\"PWS: \" & Summary!B4 & \" - \" & Summary!D4","v":"PWS: CO0207504 - Meadow Mtn Water Supply"},null,null,null,null,null,null,null,{"$f":"\"Facility: \" & Summary!B5 & \" - \" & Summary!D5","v":"Facility: 001 - Meadow Mtn SWTP01"},null,null,null,null,null,{"$f":"\"Time Period: \" &Summary!F5 & \" - \"  & Summary!I5","v":"Time Period: Oct (10) - 2015"}]
[null,"Accepted Values: Numeric >= 0, NS (No Sample), and PO (Plant Off). Blanks automatically converted to NS.\nC (Continuous) is allowed for Disinfection time periods only. If used, the Lowest Residual Sample Column must be completed.\n"]
[null,"Day","Combined Filter Effluent Turbidity (NTU)\n*Highest Hourly & Daily Value Must be Entered*",null,null,null,null,null,null,"Microbial Disinfection (mg/L)\n*Lowest Daily Value Must be Entered*",null,null,null,null,null,null,"Minimum mg/L:","1.2"]
[null,null,"12a-4a","4a-8a","8a-12p","12p-4p","4p-8p","8p-12a","Highest Turbidity Sample ","12a-4a","4a-8a","8a-12p","12p-4p","4p-8p","8p-12a","Lowest Residual Sample","Longest Duration Below Minimum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours","Minutes"]
[null,1,"NS","NS","NS","NS","NS",2.1000000000000001E-2,2.1000000000000001E-2,"NS","NS","NS","NS","NS",1.8,1.8]
[null,2,"NS","NS","NS",0.02,"NS","NS",0.02,"NS","NS","NS",1.8,"NS","NS",1.8]
[null,3,"NS","NS","NS","NS",0.02,"NS",0.02,"NS","NS","NS","NS",1.6,"NS",1.6]
[null,4,"NS","NS","NS",2.1000000000000001E-2,"NS","NS",2.1000000000000001E-2,"NS","NS","NS",1.8,"NS","NS",1.8]
[null,5,"NS","NS","NS","NS",0.02,"NS",0.02,"NS","NS","NS","NS",1.6,"NS",1.6]
[null,6,"NS","NS","NS","NS","NS",0.02,0.02,"NS","NS","NS","NS","NS",1.7,1.7]
[null,7,"NS","NS",2.1000000000000001E-2,"NS","NS","NS",2.1000000000000001E-2,"NS","NS",1.7,"NS","NS","NS",1.7]
[null,8,"NS","NS","NS",2.1000000000000001E-2,"NS","NS",2.1000000000000001E-2,"NS","NS","NS",1.7,"NS","NS",1.7]
[null,9,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.8,"NS",1.8]
[null,10,"NS","NS","NS","NS",0.02,"NS",0.02,"NS","NS","NS","NS",1.6,"NS",1.6]
[null,11,"NS","NS",0.02,"NS","NS","NS",0.02,"NS","NS",1.7,"NS","NS","NS",1.7]
[null,12,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.7,"NS",1.7]
[null,13,"NS","NS","NS","NS",0.02,"NS",0.02,"NS","NS","NS","NS",1.6,"NS",1.6]
[null,14,"NS","NS",0.02,"NS","NS","NS",0.02,"NS","NS",1.8,"NS","NS","NS",1.8]
[null,15,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.7,"NS",1.7]
[null,16,"NS","NS","NS","NS",0.02,"NS",0.02,"NS","NS","NS","NS",1.8,"NS",1.8]
[null,17,"NS","NS","NS",2.1000000000000001E-2,"NS","NS",2.1000000000000001E-2,"NS","NS","NS",1.5,"NS","NS",1.5]
[null,18,"NS","NS","NS",0.02,"NS","NS",0.02,"NS","NS","NS",1.6,"NS","NS",1.6]
[null,19,"NS","NS","NS","NS",2.1999999999999999E-2,"NS",2.1999999999999999E-2,"NS","NS","NS","NS",1.6,"NS",1.6]
[null,20,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.5,"NS",1.5]
[null,21,"NS","NS",0.02,"NS","NS","NS",0.02,"NS","NS",1.5,"NS","NS","NS",1.5]
[null,22,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.5,"NS",1.5]
[null,23,"NS","NS",2.1000000000000001E-2,"NS","NS","NS",2.1000000000000001E-2,"NS","NS",1.6,"NS","NS","NS",1.6]
[null,24,"NS","NS",2.1000000000000001E-2,"NS","NS","NS",2.1000000000000001E-2,"NS","NS",1.5,"NS","NS","NS",1.5]
[null,25,"NS","NS","NS",0.02,"NS","NS",0.02,"NS","NS","NS",1.5,"NS","NS",1.5]
[null,26,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.5,"NS",1.5]
[null,27,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.5,"NS",1.5]
[null,28,"NS","NS",2.1000000000000001E-2,"NS","NS","NS",2.1000000000000001E-2,"NS","NS",1.5,"NS","NS","NS",1.5]
[null,29,"NS","NS","NS","NS",0.02,"NS",0.02,"NS","NS","NS","NS",1.3,"NS",1.3]
[null,30,"NS","NS","NS","NS",2.1999999999999999E-2,"NS",2.1999999999999999E-2,"NS","NS","NS","NS",1.4,"NS",1.4]
[null,31,"NS","NS","NS","NS",2.1000000000000001E-2,"NS",2.1000000000000001E-2,"NS","NS","NS","NS",1.4,"NS",1.4]

{"sheet":"Lookup","index":2,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
["Month","Answer","Facilty Type","95% Turbidity","Max Turbidity","Daily Frequency","Hours","Minutes","Save Options"]
["Jan (1)","Yes","Bag/Cartridge","1","5","0",0,0,"Save as In-Progress (xlsm)"]
["Feb (2)","No","Conventional/Direct","0.3","1",1,1,1,"Save as Final State (xlsx)"]
["Mar (3)","N/A","Membrane","0.1","0.5",2,2,2]
["Apr (4)",null,"Slow Sand/Diatomaceous Earth","1","5",3,3,3]
["May (5)",null,"Disinfection Only","N/A","N/A",4,4,4]
["Jun (6)",null,null,null,null,5,5,5]
["Jul (7)",null,null,null,null,6,6,6]
["Aug (8)",null,null,null,null,null,7,7]
["Sep (9)",null,null,null,null,null,8,8]
["Oct (10)",null,null,null,null,null,9,9]
["Nov (11)",null,null,null,null,null,10,10]
["Dec (12)",null,null,null,null,null,11,11]
[null,null,null,null,null,null,12,12]
[null,null,null,null,null,null,13,13]
[null,null,null,null,null,null,14,14]
[null,null,null,null,null,null,15,15]
[null,null,null,null,null,null,16,16]
[null,null,null,null,null,null,17,17]
[null,null,null,null,null,null,18,18]
[null,null,null,null,null,null,19,19]
[null,null,null,null,null,null,20,20]
[null,null,null,null,null,null,21,21]
[null,null,null,null,null,null,22,22]
[null,null,null,null,null,null,23,23]
[null,null,null,null,null,null,24,24]
[null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,59]