{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["ELISA DATA"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"ELISA DATA","index":0,"n_rows":35,"n_cols":24,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,23,5,23],[0,0,0,7],[4,4,4,13],[4,2,5,2],[2,1,2,13],[4,22,5,22],[4,21,5,21],[4,16,4,17],[3,15,3,20],[4,15,5,15],[4,18,5,18],[4,20,5,20],[4,19,5,19],[18,1,18,3],[19,1,20,3],[18,5,18,7],[19,5,20,7],[19,9,20,11]]}
["Master Spreadsheet for percent alpha-hemolysin production calculations"]
[]
[null,"OD 650 nm from Plate Reader"]
[null,"Plate 1",{"$nulls":13},"Growth"]
[null,null,"Blank","Solvent","Compounds of Interest",{"$nulls":10},"Treatment","# of Colonies",null,"Average","StDev","CFU/mL (Step 41)","StDev","Normalized to DMSO","StDev"]
[null,null,null,"DMSO","I","II","III","IV","V","VI","VII","VIII","IX","X",null,null,"10^4 plate","10^5 plate"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,"Zero hour time point",40,null,{"$f":"AVERAGE(Q7:R7)","v":40},{"$f":"STDEV(Q7:R7)","v":{"$error":"#DIV/0!"}},{"$f":"S7*100*10^5/0.1","v":4000000000},{"$f":"T7*100*10^5/0.1","v":{"$error":"#DIV/0!"}},{"$f":"(U7/$U$8)*100","v":80},{"$error":"#DIV/0!"}]
[null,"A",2E-3,0.501,0.29420000000000002,0.25900000000000001,0.23430000000000001,0.498,0.7,0.56000000000000005,0.42499999999999999,0.33210000000000001,0.56200000000000006,0.42399999999999999,null,"DMSO",null,50,50,{"$f":"STDEV(Q8:R8)","v":{"$error":"#DIV/0!"}},{"$f":"S8*100*10^5/0.1","v":5000000000},{"$f":"T8*100*10^5/0.1","v":{"$error":"#DIV/0!"}},100,{"$error":"#DIV/0!"}]
[null,"B",1E-3,0.56200000000000006,0.2752,0.27800000000000002,0.23930000000000001,0.55000000000000004,0.72399999999999998,0.55300000000000005,0.41,0.34,0.54200000000000004,0.39850000000000002,null,"I",null,69,69,{"$error":"#DIV/0!"},6900000000,{"$error":"#DIV/0!"},138,{"$error":"#DIV/0!"}]
[null,"C",3.0000000000000001E-3,0.52500000000000002,0.27629999999999999,0.24429999999999999,0.24579999999999999,0.47,0.75,0.54200000000000004,0.45,0.314,0.58740000000000003,0.4108,null,"II",null,45,45,{"$error":"#DIV/0!"},4500000000,{"$error":"#DIV/0!"},90,{"$error":"#DIV/0!"}]
[null,"D",5.0000000000000001E-3,0.53600000000000003,0.26200000000000001,0.25700000000000001,0.23219999999999999,0.45,0.73499999999999999,0.58599999999999997,0.40300000000000002,0.36799999999999999,0.56210000000000004,0.49519999999999997,null,"III",null,37,37,{"$error":"#DIV/0!"},3700000000,{"$error":"#DIV/0!"},74,{"$error":"#DIV/0!"}]
[null,"E",1E-3,0.54500000000000004,0.25700000000000001,0.26300000000000001,0.2235,0.49,0.68400000000000005,0.57399999999999995,0.46210000000000001,0.35680000000000001,0.58199999999999996,0.45200000000000001,null,"IV",null,81,81,{"$error":"#DIV/0!"},8100000000,{"$error":"#DIV/0!"},162,{"$error":"#DIV/0!"}]
[null,"F",4.0000000000000001E-3,0.57099999999999995,0.2429,0.3,0.22639999999999999,0.53200000000000003,0.71499999999999997,0.51239999999999997,0.42799999999999999,0.34239999999999998,0.498,0.39700000000000002,null,"V",null,48,48,{"$error":"#DIV/0!"},4800000000,{"$error":"#DIV/0!"},96,{"$error":"#DIV/0!"}]
[null,"G",7.0000000000000001E-3,0.55800000000000005,0.24460000000000001,0.28000000000000003,0.21479999999999999,0.52400000000000002,0.67500000000000004,0.57799999999999996,0.438,0.36980000000000002,0.621,0.47199999999999998,null,"VI",null,52,52,{"$error":"#DIV/0!"},5200000000,{"$error":"#DIV/0!"},{"$f":"(U14/$U$8)*100","v":104},{"$f":"(V14/$U$8)*100","v":{"$error":"#DIV/0!"}}]
[null,"H",1.0999999999999999E-2,0.56200000000000006,0.22450000000000001,0.33200000000000002,0.2361,0.51,0.72399999999999998,0.54300000000000004,0.443,0.3785,0.59799999999999998,0.5071,null,"VII",null,54,54,{"$error":"#DIV/0!"},5400000000,{"$error":"#DIV/0!"},{"$f":"(U15/$U$8)*100","v":108},{"$error":"#DIV/0!"}]
[null,"average",{"$f":"AVERAGE(C8:C15)","v":4.2500000000000003E-3},0.54500000000000004,0.25958750000000003,0.27666249999999998,0.23154999999999998,0.503,0.71337499999999998,0.55604999999999993,0.43238750000000004,0.35019999999999996,0.56906250000000003,{"$f":"AVERAGE(N8:N15)","v":0.44457499999999994},null,"VIII",null,62,62,{"$error":"#DIV/0!"},6200000000,{"$error":"#DIV/0!"},{"$f":"(U16/$U$8)*100","v":124},{"$error":"#DIV/0!"}]
[null,"stdev",{"$f":"STDEV(C8:C15)","v":3.4121631178560528E-3},2.3421601750764801E-2,2.2257675241202909E-2,2.8163752666960317E-2,9.7372627423873998E-3,3.3019474773014111E-2,2.5500350137652152E-2,2.3901404621007993E-2,1.9913415255622461E-2,2.1870985345886908E-2,3.7643323729827191E-2,{"$f":"STDEV(N8:N15)","v":4.3473957721836168E-2},null,"IX",null,73,73,{"$error":"#DIV/0!"},7300000000,{"$error":"#DIV/0!"},{"$f":"(U17/$U$8)*100","v":146},{"$error":"#DIV/0!"}]
[{"$nulls":15},"X",null,78,78,{"$error":"#DIV/0!"},7800000000,{"$error":"#DIV/0!"},{"$f":"(U18/$U$8)*100","v":156},{"$error":"#DIV/0!"}]
[null,"Units Hla/mL (Step 42)",null,null,null,"Units Hla/CFU (Step 43)",null,null,null,"Percent Hla production (Step 44)",{"$nulls":5},"Note: Both plates can be counted if you wish to obtain statistical power in the growth calculations."]
[null,"[(average OD sample) – (average OD blank)] x (sample dilution factor) / ( # ml sample added)",null,null,null,"(# units/ml) / (# CFU/ml) ",null,null,null,"(units/CFU treated) / (units/CFU DMSO) x 100"]
[]
[null,"Compounds of Interest","Average","StDev",null,"Compounds of Interest","Average","StDev",null,"Compounds of Interest","Average","StDev"]
[null,"DMSO",{"$f":"((D16-$C$16)*$C$35)/$C$34","v":43.260000000000005},{"$f":"((D17-$C$17)*$C$35)/$C$34","v":1.6007550906326997},null,"DMSO",{"$f":"C23/'ELISA DATA'!U8","v":8.6520000000000003E-9},{"$f":"D23/'ELISA DATA'!U8","v":3.2015101812653995E-10},null,"DMSO",{"$f":"G23/$G$23*100","v":100},3.7003122760811364]
[null,"I",{"$f":"((E16-$C$16)*$C$35)/$C$34","v":20.427000000000003},{"$f":"((E17-$C$17)*$C$35)/$C$34","v":1.5076409698677484},null,"I",{"$f":"C24/'ELISA DATA'!U9","v":2.9604347826086961E-9},{"$f":"D24/'ELISA DATA'!U9","v":2.1849869128518093E-10},null,"I",34.216768176244756,2.525412520633159]
[null,"II",{"$f":"((F16-$C$16)*$C$35)/$C$34","v":21.792999999999999},{"$f":"((F17-$C$17)*$C$35)/$C$34","v":1.9801271639283409},null,"II",{"$f":"C25/'ELISA DATA'!U10","v":4.8428888888888891E-9},{"$f":"D25/'ELISA DATA'!U10","v":4.4002825865074241E-10},null,"II",55.974212770329281,5.0858559714602682]
[null,"III",{"$f":"((G16-$C$16)*$C$35)/$C$34","v":18.183999999999997},{"$f":"((G17-$C$17)*$C$35)/$C$34","v":0.50600796996250774},null,"III",{"$f":"C26/'ELISA DATA'!U11","v":4.9145945945945942E-9},{"$f":"D26/'ELISA DATA'!U11","v":1.3675891080067778E-10},null,"III",56.80298884182379,1.5806623994530489]
[null,"IV",{"$f":"((H16-$C$16)*$C$35)/$C$34","v":39.9},{"$f":"((H17-$C$17)*$C$35)/$C$34","v":2.3685849324126442},null,"IV",{"$f":"C27/'ELISA DATA'!U12","v":4.9259259259259258E-9},{"$f":"D27/'ELISA DATA'!U12","v":2.9241789289044991E-10},null,"IV",56.933956610332018,3.3797722248087139]
[null,"V",{"$f":"((I16-$C$16)*$C$35)/$C$34","v":56.73},{"$f":"((I17-$C$17)*$C$35)/$C$34","v":1.7670549615836877},null,"V",{"$f":"C28/'ELISA DATA'!U13","v":1.181875E-8},{"$f":"D28/'ELISA DATA'!U13","v":3.6813645032993493E-10},null,"V",136.60136384650946,4.2549289219826045]
[null,"VI",{"$f":"((J16-$C$16)*$C$35)/$C$34","v":44.143999999999991},{"$f":"((J17-$C$17)*$C$35)/$C$34","v":1.6391393202521549},null,"VI",{"$f":"C29/'ELISA DATA'!U14","v":8.4892307692307671E-9},{"$f":"D29/'ELISA DATA'!U14","v":3.1521910004849134E-10},null,"VI",98.118709769195178,3.6433090620491368]
[null,"VII",{"$f":"((K16-$C$16)*$C$35)/$C$34","v":34.251000000000005},{"$f":"((K17-$C$17)*$C$35)/$C$34","v":1.3201001710213125},null,"VII",{"$f":"C30/'ELISA DATA'!U15","v":6.3427777777777784E-9},{"$f":"D30/'ELISA DATA'!U15","v":2.4446299463357636E-10},null,"VII",73.30996044588278,2.825508490910499]
[null,"VIII",{"$f":"((L16-$C$16)*$C$35)/$C$34","v":27.675999999999998},{"$f":"((L17-$C$17)*$C$35)/$C$34","v":1.4767057782424682},null,"VIII",{"$f":"C31/'ELISA DATA'!U16","v":4.4638709677419353E-9},{"$f":"D31/'ELISA DATA'!U16","v":2.3817835132943035E-10},null,"VIII",{"$f":"G31/$G$23*100","v":51.593515577229944},{"$f":"H31/$G$23*100","v":2.7528704499471837}]
[null,"IX",{"$f":"((M16-$C$16)*$C$35)/$C$34","v":45.185000000000002},{"$f":"((M17-$C$17)*$C$35)/$C$34","v":2.7384928489576907},null,"IX",{"$f":"C32/'ELISA DATA'!U17","v":6.1897260273972607E-9},{"$f":"D32/'ELISA DATA'!U17","v":3.75136006706533E-10},null,"IX",{"$f":"G32/$G$23*100","v":71.540985060070057},4.3358299434412046]
[null,"X",{"$f":"((N16-$C$16)*$C$35)/$C$34","v":35.225999999999992},{"$f":"((N17-$C$17)*$C$35)/$C$34","v":3.2049435683184089},null,"X",{"$f":"C33/'ELISA DATA'!U18","v":4.516153846153845E-9},{"$f":"D33/'ELISA DATA'!U18","v":4.1089020106646269E-10},null,"X",{"$f":"G33/$G$23*100","v":52.197802197802176},4.7490776822291112]
[null,"Volume of flitrate added (mL)",0.1]
[null,"Filtrate dilution factor",8]