{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["A1-Planktonic Test","A2-Modified (Viscous) Soak Test","A3-Sessile Swab Test","A4-Sessile Soak Test","Tools"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":4,"comments":0,"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":"A1-Planktonic Test","index":0,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,7,1,10],[2,7,2,10],[3,0,4,1],[3,2,4,10],[0,0,0,1],[1,0,1,1],[2,0,2,1],[0,2,0,4],[1,2,1,4],[2,2,2,4],[0,5,0,6],[1,5,1,6],[2,5,2,6],[0,7,0,10]]}
["Company:",null,null,null,null,"Analysis Tech:"]
["Contact:",null,null,null,null,"Testing Date:"]
["Phone Number:",null,null,null,null,"Testing Time:"]
["Notes: "]
[]
[]
["Sample ID","Sample\nDescription","Sampling\nDate","Sampling Time","Background\nbRLU","Standard\nsRLU","Sample\nRLU","Volume\n(mL)","ATP Conc. (pg/mL)","Microbial Count (ME/mL)","Log # of microbes (ME/mL)"]
[null,"Example 1 - Low","2018-07-05","10:00:00",8,21184,50,50,{"$f":"IF(OR(F8=\"\",G8=\"\",H8=\"\"),\"\",IF(F8<5000,\"sRLU Too Low\",IF(G8-E8<1,\"BRL\",(G8-E8)/(F8-E8)*10000/H8)))","v":0.3966754816773706},{"$f":"IF(OR($F8=\"\",$G8=\"\",$H8=\"\"),\"\",IF(F8<5000,\"sRLU Too Low\",IF(G8-E8<1,\"BRL\",I8*1000)))","v":396.67548167737061},{"$f":"IF(OR($F8=\"\",$G8=\"\",$H8=\"\"),\"\",IF(F8<5000,\"sRLU Too Low\",IF(G8-E8<1,\"BRL\",TRUNC(LOG(J8)))))","v":2}]
[null,"Example 2 - Low","2018-07-05","10:00:00",8,21184,500,50,{"$f":"IF(OR(F9=\"\",G9=\"\",H9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",(G9-E9)/(F9-E9)*10000/H9)))","v":4.6467699282206274},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",I9*1000)))","v":4646.7699282206277},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",TRUNC(LOG(J9)))))","v":3}]
[null,"Example 3 - Low","2018-07-05","10:00:00",8,21184,5000,50,{"$f":"IF(OR(F10=\"\",G10=\"\",H10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",(G10-E10)/(F10-E10)*10000/H10)))","v":47.147714393653196},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",I10*1000)))","v":47147.714393653194},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",TRUNC(LOG(J10)))))","v":4}]
[null,"Example 4 - Moderate","2018-07-05","10:00:00",8,21184,50000,50,472.15715904797884,472157.15904797881,5]
[null,"Example 5 - High","2018-07-05","10:00:00",8,21184,500000,50,4722.2516055912347,4722251.6055912348,6]
[null,"Example 6 - High","2018-07-05","10:00:00",8,21184,5000000,50,47223.196071023798,47223196.071023799,7]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,"","",""]

{"sheet":"A2-Modified (Viscous) Soak Test","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,2,4,11],[0,2,0,4],[1,2,1,4],[0,5,0,6],[1,5,1,6],[2,5,2,6],[0,7,0,11],[1,7,1,11],[2,7,2,11],[2,2,2,4],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,4,1],[6,11,7,11],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
["Company:",null,null,null,null,"Analysis Tech:"]
["Contact:",null,null,null,null,"Testing Date:"]
["Phone Number:",null,null,null,null,"Testing Time:"]
["Notes: "]
[]
[]
["Sample ID","Sample Description","Sampling\nDate","Sampling\nTime","Background\nbRLU","Standard\nsRLU","Sample\nRLU","Viscous\nLiquid\nVolume\n(mL)","Reagent X\nVolume\n(mL)","ATP Conc.\n(pg/mL)","Microbial Count (ME/mL)","Log # of microbes (ME/mL)"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",((($G9*$H9)-$E9)/($F9-$E9))*(10000*I9/$H9))))","v":""},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",J9*1000)))","v":""},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",TRUNC(LOG(K9)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",((($G10*$H10)-$E10)/($F10-$E10))*(10000*I10/$H10))))","v":""},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",J10*1000)))","v":""},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",TRUNC(LOG(K10)))))","v":""}]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[]
[]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]

{"sheet":"A3-Sessile Swab Test","index":2,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,11,7,11],[6,4,7,4],[6,8,7,8],[6,0,7,0],[6,10,7,10],[6,5,7,5],[6,6,7,6],[6,9,7,9],[6,1,7,1],[6,2,7,2],[6,3,7,3],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,4,1],[0,7,0,11],[1,7,1,11],[2,7,2,11],[3,2,4,11],[0,5,0,6],[1,5,1,6],[2,5,2,6],[0,2,0,4],[1,2,1,4],[2,2,2,4]]}
["Company:",null,null,null,null,"Analysis Tech:"]
["Contact:",null,null,null,null,"Testing Date:"]
["Phone Number:",null,null,null,null,"Testing Time:"]
["Notes: "]
[]
[]
["Sample ID","Sample Description","Sampling\nDate","Sampling\nTime","Background\nbRLU","Standard\nsRLU","Sample\nRLU","Sample\namount","Reagent X\nVolume\n(mL)",{"$f":"\"ATP Conc. pg/\"&H8","v":"ATP Conc. pg/Units"},{"$f":"\"Microbial Count/\"&H8","v":"Microbial Count/Units"},{"$f":"\"Log # of microbes ME/\"&H8","v":"Log # of microbes ME/Units"}]
[null,null,null,null,null,null,null,"Units"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",(($G9-$E9)/($F9-$E9))*(10000*I9/$H9))))","v":""},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",J9*1000)))","v":""},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",TRUNC(LOG(K9)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",(($G10-$E10)/($F10-$E10))*(10000*I10/$H10))))","v":""},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",J10*1000)))","v":""},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",TRUNC(LOG(K10)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F11=\"\",$G11=\"\",$H11=\"\",$I11=\"\"),\"\",IF(F11<5000,\"sRLU Too Low\",IF(G11-E11<1,\"BRL\",(($G11-$E11)/($F11-$E11))*(10000*I11/$H11))))","v":""},{"$f":"IF(OR($F11=\"\",$G11=\"\",$H11=\"\",$I11=\"\"),\"\",IF(F11<5000,\"sRLU Too Low\",IF(G11-E11<1,\"BRL\",J11*1000)))","v":""},{"$f":"IF(OR($F11=\"\",$G11=\"\",$H11=\"\",$I11=\"\"),\"\",IF(F11<5000,\"sRLU Too Low\",IF(G11-E11<1,\"BRL\",TRUNC(LOG(K11)))))","v":""}]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]

{"sheet":"A4-Sessile Soak Test","index":3,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,11,7,11],[6,7,7,7],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,8,7,8],[6,9,7,9],[6,10,7,10],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,4,1],[0,5,0,6],[1,5,1,6],[2,5,2,6],[3,2,4,11],[0,2,0,4],[1,2,1,4],[0,7,0,11],[1,7,1,11],[2,7,2,11],[2,2,2,4]]}
["Company:",null,null,null,null,"Analysis Tech:"]
["Contact:",null,null,null,null,"Testing Date:"]
["Phone Number:",null,null,null,null,"Testing Time:"]
["Notes: "]
[]
[]
["Sample ID","Sample Description","Sampling\nDate","Sampling\nTime","Background\nbRLU","Standard\nsRLU","Sample\nRLU","Mass\n(g)","Reagent X\nVolume\n(mL)","ATP Conc. (pg/g)","Microbial Count (ME/g)","Log # of microbes\n(ME/g)"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",(($G9-$E9)/($F9-$E9))*(10000*I9/$H9))))","v":""},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",J9*1000)))","v":""},{"$f":"IF(OR($F9=\"\",$G9=\"\",$H9=\"\",$I9=\"\"),\"\",IF(F9<5000,\"sRLU Too Low\",IF(G9-E9<1,\"BRL\",TRUNC(LOG(K9)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",(($G10-$E10)/($F10-$E10))*(10000*I10/$H10))))","v":""},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",J10*1000)))","v":""},{"$f":"IF(OR($F10=\"\",$G10=\"\",$H10=\"\",$I10=\"\"),\"\",IF(F10<5000,\"sRLU Too Low\",IF(G10-E10<1,\"BRL\",TRUNC(LOG(K10)))))","v":""}]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",""]

{"sheet":"Tools","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Units"]
["cm²"]
["in²"]