{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Title","Home","Guide","Data Dictionary","Data","Trend Analysis","Background"],"not_rendered":{"charts":1,"images":14,"macros":1,"external_links":1,"defined_names":16,"comments":0,"pivot_tables":1},"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":"Title","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Home","index":1,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,3,2,17],[9,3,14,3],[9,4,9,5],[15,4,15,5],[15,3,19,3],[22,3,25,3],[22,4,22,5],[3,4,3,5],[3,3,8,3],[32,4,32,5],[32,3,35,3]]}
[null,null,null,"Water Management Program Data Template"]
[]
[]
[null,null,null,null,"Objective"]
[]
[]
[]
[]
[]
[null,null,null,null,"Data Overview"]
[]
[]
[]
[]
[]
[null,null,null,null,"Analysis"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Guide"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Summary"]

{"sheet":"Guide","index":2,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,2,2,16],[3,2,31,16]]}
[null,null,"Guide"]

{"sheet":"Data Dictionary","index":3,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,0,47,0],[36,3,36,5],[0,3,2,5]]}
[null,null,null,"Data Dictionary"]
[]
[]
[null,null,null,"Variable","Description","Example"]
[null,null,null,"Location ID","Identification code of a specific location where a sample was or samples were collected","1_E663SINK"]
[null,null,null,"Sample ID","Identification code of a specific sample ","GA010117_001"]
[null,null,null,"Date collected","Collection date","2017-01-01"]
[null,null,null,"Building","Building name of sample collection","Building 1"]
[null,null,null,"Water Loop Description","Name of water loop where sample was collected","Water Loop E"]
[null,null,null,"Floor","Floor number of sample collection ","Floor 6"]
[null,null,null,"Room/location number","Room number or location name of sample collection","Room 663"]
[null,null,null,"Room/location description","Specific description of sample collection in a room or location","Room 663 sink"]
[null,null,null,"Fixture type","Type of fixture sample was collected from","Sink/Shower/Fountain"]
[null,null,null,"Fixture description","Description of fixture ","Paddled/Tempered/Shower Head"]
[null,null,null,"Sample type","Type of sample collected (1L Bulk Water Sample/Swab)","Bulk/Swab"]
[null,null,null,"Cold/Hot/Swab","Description of sample water temperature or type","Cold/Hot/Swab"]
[null,null,null,"Pre/Post Flush","Sample collected before or after water system flushed?","Pre-Flush/Post-Flush"]
[null,null,null,"Total Cl2 (mg/L)","Total chlorine concentration of water sample","1.2 mg/L"]
[null,null,null,"Free Cl2 (mg/L)","Free chlorine concentration of water sample","0.05 mg/L"]
[null,null,null,"ClO2 (mg/L)","Chlorine dioxide concentration of water sample (if applicable)","0.65 mg/L"]
[null,null,null,"Cu","Copper concentration of water sample (if applicable)",0.4]
[null,null,null,"Ag","Silver concentration of water sample (if applicable)",0.5]
[null,null,null,"pH","pH value of water sample",7.65]
[null,null,null,"Temp (F°)","Water temperature","110.3 F"]
[null,null,null,"Time to max temp (sec)","Time to reach maximum water temperature ","5 sec"]
[null,null,null,"Other Water Parameter #1","(Fill in Parameter Description Here)","(Fill in example here)"]
[null,null,null,"Other Water Parameter #2","(Fill in Parameter Description Here)","(Fill in example here)"]
[null,null,null,"Other Water Parameter #3","(Fill in Parameter Description Here)","(Fill in example here)"]
[null,null,null,"Pathogen Tested","Which pathogen was this sample tested for?","Legionella"]
[null,null,null,"Result","Test result ","Positive/Not Detected/Pending/Not Tested*"]
[null,null,null,"Species/Serogroup","Species/serogroup detected (ex. Legionella pneumophila serogroup 1)","Legionella pneumophila serogroup 1"]
[null,null,null,"CFU/mL","Number of colony-forming units (CFUs) detected","3.5 cfu/mL"]
[null,null,null,"Other Detection Unit #1","(Fill in Detection Unit here)","(Fill in example here)"]
[null,null,null,"Other Detection Unit #2","(Fill in Detection Unit here)","(Fill in example here)"]
[null,null,null,"Other Detection Unit #3","(Fill in Detection Unit here)","(Fill in example here)"]
[null,null,null,"Notes","Additional Details","Case patient's room"]
[null,null,null,"* Indicates only allowable responses"]

{"sheet":"Data","index":4,"n_rows":1,"n_cols":34,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Location ID","Sample ID","Date collected","Building","Water Loop Description","Floor","Room/location number","Room/location description","Fixture type","Fixture description","Sample Type","Cold/Hot/Swab","Pre/Post Flush","Total Cl2","Free Cl2","ClO2","Cu","Ag","pH","Temp","Time to max temp","Other Water Parameter #1","Other Water Parameter #2","Other Water Parameter #3","Pathogen Tested","Result (Positive/Not Detected/Pending/Not Tested)","Species/Serogroup","CFU/mL","Other Detection Unit #1","Other Detection Unit #2","Other Detection Unit #3","Notes","Number of Positive Samples"]

{"sheet":"Trend Analysis","index":5,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,22,19,24],[25,7,25,8],[4,15,19,17],[5,1,6,1],[0,1,3,11],[0,13,3,16]]}
[null,"Trend Analysis",null,null,null,null,null,null,null,null,null,null,null,"Help"]
[]
[]
[]
[]
[null,"Result Type"]
[]
[null,"Pathogen Tested","(blank)"]
[null,"Location ID","(blank)"]
[null,"Sample ID","(blank)"]
[null,"Building","(blank)"]
[null,"Water Loop Description","(blank)"]
[null,"Floor","(blank)"]
[null,"Room/location number","(blank)"]
[null,"Room/location description","(blank)"]
[null,"Fixture type","(blank)"]
[null,"Fixture description","(blank)"]
[null,"Sample Type","(blank)"]
[null,"Pre/Post Flush","(blank)"]
[null,"Cold/Hot/Swab","(blank)"]
[]
[null,"Row Labels","Average of CFU/mL"]
[null,"(blank)",{"$error":"#DIV/0!"}]

{"sheet":"Background","index":6,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Pivot Table",null,"Result Options",null,"L Result Options"]
[null,{"$f":"RIGHT('Trend Analysis'!C22,LEN('Trend Analysis'!C22)-SEARCH(\"of\",'Trend Analysis'!C22)-2)","v":"CFU/mL"},null,{"$f":"Table1[[#Headers],[CFU/mL]]","v":"CFU/mL"},null,"Positive"]
[null,null,null,"Number of Positive Samples",null,"Not Detected"]
[null,null,null,{"$f":"Table1[[#Headers],[Total Cl2]]","v":"Total Cl2"},null,"Pending"]
[null,null,null,{"$f":"Table1[[#Headers],[Free Cl2]]","v":"Free Cl2"},null,"Not Tested"]
[null,null,null,{"$f":"Table1[[#Headers],[ClO2]]","v":"ClO2"}]
[null,null,null,{"$f":"Table1[[#Headers],[Cu]]","v":"Cu"}]
[null,null,null,{"$f":"Table1[[#Headers],[Ag]]","v":"Ag"}]
[null,null,null,{"$f":"Table1[[#Headers],[pH]]","v":"pH"}]
[null,null,null,{"$f":"Table1[[#Headers],[Temp]]","v":"Temp"}]
[null,null,null,{"$f":"Table1[[#Headers],[Time to max temp]]","v":"Time to max temp"}]
[null,null,null,{"$f":"Table1[[#Headers],[Other Water Parameter '#1]]","v":"Other Water Parameter #1"}]
[null,null,null,{"$f":"Table1[[#Headers],[Other Water Parameter '#2]]","v":"Other Water Parameter #2"}]
[null,null,null,{"$f":"Table1[[#Headers],[Other Water Parameter '#3]]","v":"Other Water Parameter #3"}]
[null,null,null,{"$f":"Table1[[#Headers],[Other Detection Unit '#1]]","v":"Other Detection Unit #1"}]
[null,null,null,{"$f":"Table1[[#Headers],[Other Detection Unit '#2]]","v":"Other Detection Unit #2"}]
[null,null,null,{"$f":"Table1[[#Headers],[Other Detection Unit '#3]]","v":"Other Detection Unit #3"}]