{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Logit","Datasheet","Absorbance","Import","Instructions"],"not_rendered":{"charts":2,"images":9,"macros":1,"external_links":0,"defined_names":1,"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":"Logit","index":0,"n_rows":98,"n_cols":58,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Name","Conc","Resp","Dil","Result","Average","Del Result","ELISA Logit regression V01Jul2018",null,null,null,"Testdate:","14-Aug-2019 13:37:55",null,null,null,null,null,null,null,null,null,2.4974128934178058E-7,211.501,"Iterations",437,"Name","Conc","Resp","Dil","Result","Average",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Log(X)","Logit(Y)","Del Logit(Y)","Logit(Y)","Conc","Resp"]
[null,0,211,1,"<<",null,null,"Correlation",0.99833715709624693,0.15,"Max CV% for bad average)",null,null,null,null,null,null,null,null,null,null,null,1.8695397094422763E-3,250.96599000000001,"Corr oud",0.99833715714072291,null,0,211,1,"<<"]
[null,0,212,1,"<0.00812",null,null,"Slope",1.1867819411871718,0,"Extrapolate (0=no, 1=yes, 2=between blank and highest dose)",null,null,null,null,null,null,null,null,null,null,null,3.3634631710251208E-3,290.43097999999998,null,null,null,0,212,1,"<0.00812",null,8.1200000000000005E-3]
[null,8.1250000000000003E-3,423,1,"<0.00812",null,null,"Intercept",1.8906050249845046,0,"Matrix? (0=no, 1=yes)",null,null,null,null,null,null,null,null,null,null,null,4.7486693870490227E-3,329.89596999999998,null,null,null,8.1250000000000003E-3,423,1,"<0.00812",null,8.1200000000000005E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.8128095507663362,null,null,-3.8692111784703189,8.1250000000000003E-3,423]
[null,8.1250000000000003E-3,445,1,8.5000000000000006E-3,null,null,"Blank",211.5,0,"Linear between blank and lowest dose (0=No, 1=yes, 2=spline)",null,null,null,null,null,null,null,null,null,null,null,6.0710183355930664E-3,369.36095999999998,null,null,null,8.1250000000000003E-3,445,1,8.5000000000000006E-3,null,8.5000000000000006E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.8128095507663362,null,null,-3.7680803619320322,8.1250000000000003E-3,445]
[null,1.6250000000000001E-2,682,1,1.5600000000000001E-2,null,null,"Bmax",10554.819305852359,3,"Significant digits",null,null,null,null,null,null,null,null,null,null,null,7.3508835227880437E-3,408.82594999999998,null,null,null,1.6250000000000001E-2,682,1,1.5600000000000001E-2,null,1.5600000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.1196623702063908,null,null,-3.0437447765702976,1.6250000000000001E-2,682]
[null,1.6250000000000001E-2,732,1,1.7100000000000001E-2,null,null,"[1/2Bmax]",0.20330423437123465,1,"> or < result displayed (0=no, 1=yes)",null,null,null,null,null,null,null,null,null,null,null,8.5997278621946678E-3,448.29093999999998,null,null,null,1.6250000000000001E-2,732,1,1.7100000000000001E-2,null,1.7100000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4.1196623702063908,null,null,-2.9376735704442787,1.6250000000000001E-2,732]
[null,3.2500000000000001E-2,1156,1,2.93E-2,null,null,"Iterations",437,"Separator",0,"0=Space, 1=Comma, 2=Semicolon ",null,null,null,null,null,null,null,null,null,null,9.8248654117982521E-3,487.75592999999998,null,null,null,3.2500000000000001E-2,1156,1,2.93E-2,null,2.93E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.4265151896464454,null,null,-2.2976836676670795,3.2500000000000001E-2,1156]
[null,3.2500000000000001E-2,1316,1,3.4000000000000002E-2,null,null,null,null,"Export file",null,null,null,null,"dd-mmm-yyyy hh:mm:ss",null,null,null,null,null,null,null,1.1031351109800396E-2,527.22091999999998,null,null,null,3.2500000000000001E-2,1316,1,3.4000000000000002E-2,null,3.4000000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.4265151896464454,null,null,-2.1240213528589931,3.2500000000000001E-2,1316]
[null,6.5000000000000002E-2,2499,1,7.0400000000000004E-2,null,null,null,null,"Abs file",null,null,null,null,null,null,null,null,null,null,null,null,1.2222878941533934E-2,566.68590999999992,null,null,null,6.5000000000000002E-2,2499,1,7.0400000000000004E-2,null,7.0400000000000004E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.7333680090865,null,null,-1.258935207237037,6.5000000000000002E-2,2499]
[null,6.5000000000000002E-2,2299,1,6.3800000000000009E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.340226245509229E-2,606.15089999999987,null,null,null,6.5000000000000002E-2,2299,1,6.3800000000000009E-2,null,6.3800000000000009E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.7333680090865,null,null,-1.3749511443532809,6.5000000000000002E-2,2299]
[null,0.13,3872,1,0.122,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.457171451768839E-2,645.61588999999981,null,null,null,0.13,3872,1,0.122,null,0.122,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.0402208285265546,null,null,-0.60194020017950101,0.13,3872]
[null,0.13,4158,1,">0.13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5733020916792906E-2,685.08087999999975,null,null,null,0.13,4158,1,">0.13",null,0.13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2.0402208285265546,null,null,-0.48297177320152479,0.13,4158]
[15124,null,2614,20,1.48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6887653608647652E-2,724.5458699999997,null,null,15124,null,2614,20,1.48,null,1.48]
[15124,null,2527,20,1.43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8036847634212764E-2,764.01085999999964,null,null,15124,null,2527,20,1.43,null,1.43]
[15124,null,1031,50,1.29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.91816551240932E-2,803.47584999999958,null,null,15124,null,1031,50,1.29,null,1.29]
[15124,null,1089,50,1.37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0322984289831217E-2,842.94083999999953,null,null,15124,null,1089,50,1.37,null,1.37]
[15124,null,526,100,1.1000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.146162825277164E-2,882.40582999999947,null,null,15124,null,526,100,1.1000000000000001,null,1.1000000000000001]
[15124,null,549,100,1.1700000000000002,1.31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2598286800995487E-2,921.87081999999941,null,null,15124,null,549,100,1.1700000000000002,null,1.1700000000000002]
[749351,null,2450,4,0.27500000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3733583105615783E-2,961.33580999999936,null,null,749351,null,2450,4,0.27500000000000002,null,0.27500000000000002]
[749351,null,2516,4,0.28399999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4868076768237771E-2,1000.8007999999993,null,null,749351,null,2516,4,0.28399999999999997,null,0.28399999999999997]
[749351,null,608,20,0.26900000000000002,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,2.600227414828787E-2,1040.2657899999992,null,null,749351,null,608,20,0.26900000000000002,null,0.26900000000000002]
[749351,null,623,20,0.27800000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7136636640241716E-2,1079.7307799999992,null,null,749351,null,623,20,0.27800000000000002,null,0.27800000000000002]
[749351,null,244,100,"<0.812",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8271587382903605E-2,1119.1957699999991,null,null,749351,null,244,100,"<0.812",null,0.81200000000000006]
[749351,null,238,100,"<0.812",0.27600000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9407516753563123E-2,1158.6607599999991,null,null,749351,null,238,100,"<0.812",null,0.81200000000000006]
[749367,null,4950,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.054478690915291E-2,1198.125749999999,null,null,749367,null,4950,4,">0.52",null,0.52]
[749367,null,4821,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1683735571836867E-2,1237.590739999999,null,null,749367,null,4821,4,">0.52",null,0.52]
[749367,null,4683,20,">2.6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2824679209599965E-2,1277.0557299999989,null,null,749367,null,4683,20,">2.6",null,2.6]
[749367,null,4597,20,">2.6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3967915727994312E-2,1316.5207199999988,null,null,749367,null,4597,20,">2.6",null,2.6]
[749367,null,1982,100,5.3800000000000008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5113726763592715E-2,1355.9857099999988,null,null,749367,null,1982,100,5.3800000000000008,null,5.3800000000000008]
[749367,null,2057,100,5.61,5.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6262379650427182E-2,1395.4506999999987,null,null,749367,null,2057,100,5.61,null,5.61]
[749385,null,4479,20,">2.6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7414129116023542E-2,1434.9156899999987,null,null,749385,null,4479,20,">2.6",null,2.6]
[749385,null,4708,20,">2.6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.8569218752369773E-2,1474.3806799999986,null,null,749385,null,4708,20,">2.6",null,2.6]
[749385,null,4120,100,">13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9727882298408797E-2,1513.8456699999986,null,null,749385,null,4120,100,">13",null,13]
[749385,null,3969,100,12.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0890344763801566E-2,1553.3106599999985,null,null,749385,null,3969,100,12.7,null,12.7]
[749385,null,1244,500,15.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2056823418304572E-2,1592.7756499999984,null,null,749385,null,1244,500,15.9,null,15.9]
[749385,null,1296,500,16.7,15.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3227528666813418E-2,1632.2406399999984,null,null,749385,null,1296,500,16.7,null,16.7]
[749402,null,4402,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4402664826684674E-2,1671.7056299999983,null,null,749402,null,4402,4,">0.52",null,0.52]
[749402,null,4205,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5582430821179264E-2,1711.1706199999983,null,null,749402,null,4205,4,">0.52",null,0.52]
[749402,null,1739,20,0.92800000000000005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.6767020800621874E-2,1750.6356099999982,null,null,749402,null,1739,20,0.92800000000000005,null,0.92800000000000005]
[749402,null,1567,20,0.82599999999999996,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7956624701037835E-2,1790.1005999999982,null,null,749402,null,1567,20,0.82599999999999996,null,0.82599999999999996]
[749402,null,469,100,0.92500000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9151428748524829E-2,1829.5655899999981,null,null,749402,null,469,100,0.92500000000000004,null,0.92500000000000004]
[749402,null,461,100,0.9,0.89500000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.035161591637545E-2,1869.0305799999981,null,null,749402,null,461,100,0.9,null,0.9]
[749403,null,4833,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1557366340938993E-2,1908.495569999998,null,null,749403,null,4833,4,">0.52",null,0.52]
[749403,null,4865,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2768857701353651E-2,1947.9605599999979,null,null,749403,null,4865,4,">0.52",null,0.52]
[749403,null,2825,20,1.6300000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3986265567564286E-2,1987.4255499999979,null,null,749403,null,2825,20,1.6300000000000001,null,1.6300000000000001]
[749403,null,2784,20,1.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5209763720438926E-2,2026.8905399999978,null,null,749403,null,2784,20,1.6,null,1.6]
[749403,null,603,100,1.33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.6439524447289564E-2,2066.355529999998,null,null,749403,null,603,100,1.33,null,1.33]
[749403,null,608,100,1.35,1.48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.76757188156726E-2,2105.8205199999979,null,null,749403,null,608,100,1.35,null,1.35]
[749404,null,4368,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8918516927979551E-2,2145.2855099999979,null,null,749404,null,4368,4,">0.52",null,0.52]
[749404,null,4132,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.0168088159016572E-2,2184.7504999999978,null,null,749404,null,4132,4,">0.52",null,0.52]
[749404,null,3716,20,2.31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1424601378505771E-2,2224.2154899999978,null,null,749404,null,3716,20,2.31,null,2.31]
[749404,null,3761,20,2.3499999999999996,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.2688225160211178E-2,2263.6804799999977,null,null,749404,null,3761,20,2.3499999999999996,null,2.3499999999999996]
[749404,null,919,100,2.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3959127979197339E-2,2303.1454699999977,null,null,749404,null,919,100,2.25,null,2.25]
[749404,null,870,100,2.11,2.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5237478398556592E-2,2342.6104599999976,null,null,749404,null,870,100,2.11,null,2.11]
[749531,null,205,4,"<<",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.6523445246796417E-2,2382.0754499999975,null,null,749531,null,205,4,"<<"]
[749531,null,199,4,"<<",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.781719778694828E-2,2421.5404399999975,null,null,749531,null,199,4,"<<"]
[749531,null,215,20,"<0.162",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.9118905878351081E-2,2461.0054299999974,null,null,749531,null,215,20,"<0.162",null,0.16200000000000001]
[749531,null,210,20,"<<",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0428740131963721E-2,2500.4704199999974,null,null,749531,null,210,20,"<<"]
[749531,null,220,100,"<0.812",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.1746872059978511E-2,2539.9354099999973,null,null,749531,null,220,100,"<0.812",null,0.81200000000000006]
[749531,null,214,100,"<0.812","<0.162",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.3073474220432741E-2,2579.4003999999973,null,null,749531,null,214,100,"<0.812",null,0.81200000000000006]
[749562,null,4451,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4408720357451372E-2,2618.8653899999972,null,null,749562,null,4451,4,">0.52",null,0.52]
[749562,null,4053,4,0.52200000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5752785537697431E-2,2658.3303799999971,null,null,749562,null,4053,4,0.52200000000000002,null,0.52200000000000002]
[749562,null,3717,20,2.3200000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.7105846283556989E-2,2697.7953699999971,null,null,749562,null,3717,20,2.3200000000000003,null,2.3200000000000003]
[749562,null,3769,20,2.36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.8468080703541845E-2,2737.260359999997,null,null,749562,null,3769,20,2.36,null,2.36]
[749562,null,1206,100,3.08,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.9839668620354923E-2,2776.725349999997,null,null,749562,null,1206,100,3.08,null,3.08]
[749562,null,1330,100,3.4399999999999995,2.3400000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1220791697029435E-2,2816.1903399999969,null,null,749562,null,1330,100,3.4399999999999995,null,3.4399999999999995]
[749563,null,2450,20,1.3800000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.2611633561523831E-2,2855.6553299999969,null,null,749563,null,2450,20,1.3800000000000001,null,1.3800000000000001]
[749563,null,2516,20,1.42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.4012379930127362E-2,2895.1203199999968,null,null,749563,null,2516,20,1.42,null,1.42]
[749563,null,608,100,1.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.5423218730010103E-2,2934.5853099999968,null,null,749563,null,608,100,1.35,null,1.35]
[749563,null,623,100,1.3900000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.6844340221228833E-2,2974.0502999999967,null,null,749563,null,623,100,1.3900000000000001,null,1.3900000000000001]
[749563,null,244,500,"<4.06",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.8275937118485345E-2,3013.5152899999966,null,null,749563,null,244,500,"<4.06",null,4.0600000000000005]
[749563,null,238,500,"<4.06",1.3800000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.9718204712916208E-2,3052.9802799999966,null,null,749563,null,238,500,"<4.06",null,4.0600000000000005]
[749564,null,2450,4,0.27500000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1171340994181282E-2,3092.4452699999965,null,null,749564,null,2450,4,0.27500000000000002,null,0.27500000000000002]
[749564,null,2516,4,0.28399999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.2635546773106245E-2,3131.9102599999965,null,null,749564,null,2516,4,0.28399999999999997,null,0.28399999999999997]
[749564,null,608,20,0.26900000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4111025805125009E-2,3171.3752499999964,null,null,749564,null,608,20,0.26900000000000002,null,0.26900000000000002]
[749564,null,623,20,0.27800000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5597984914759127E-2,3210.8402399999964,null,null,749564,null,623,20,0.27800000000000002,null,0.27800000000000002]
[749564,null,244,100,"<0.812",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.7096634121364919E-2,3250.3052299999963,null,null,749564,null,244,100,"<0.812",null,0.81200000000000006]
[749564,null,238,100,"<0.812",0.27600000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.8607186766373242E-2,3289.7702199999962,null,null,749564,null,238,100,"<0.812",null,0.81200000000000006]
[749565,null,4950,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.10012985964224244,3329.2352099999962,null,null,749565,null,4950,4,">0.52",null,0.52]
[749565,null,4821,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.10166487312334098,3368.7001999999961,null,null,749565,null,4821,4,">0.52",null,0.52]
[749565,null,4683,20,">2.6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.10321245129897491,3408.1651899999961,null,null,749565,null,4683,20,">2.6",null,2.6]
[749565,null,4597,20,">2.6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1047728221087731,3447.630179999996,null,null,749565,null,4597,20,">2.6",null,2.6]
[749565,null,1982,100,5.3800000000000008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.10634621748064231,3487.095169999996,null,null,749565,null,1982,100,5.3800000000000008,null,5.3800000000000008]
[749565,null,2057,100,5.61,5.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.10793287347150519,3526.5601599999959,null,null,749565,null,2057,100,5.61,null,5.61]
[749566,null,4479,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.10953303041103483,3566.0251499999958,null,null,749566,null,4479,4,">0.52",null,0.52]
[749566,null,4708,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11114693304860072,3605.4901399999958,null,null,749566,null,4708,4,">0.52",null,0.52]
[749566,null,4120,20,">2.6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11277483070364504,3644.9551299999957,null,null,749566,null,4120,20,">2.6",null,2.6]
[749566,null,3969,20,2.5300000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11441697741970906,3684.4201199999957,null,null,749566,null,3969,20,2.5300000000000002,null,2.5300000000000002]
[749566,null,1244,100,3.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11607363212233598,3723.8851099999956,null,null,749566,null,1244,100,3.19,null,3.19]
[749566,null,1296,100,3.3400000000000003,3.02,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11774505878107873,3763.3500999999956,null,null,749566,null,1296,100,3.3400000000000003,null,3.3400000000000003]
[749567,null,4402,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11943152657584864,3802.8150899999955,null,null,749567,null,4402,4,">0.52",null,0.52]
[749567,null,4205,4,">0.52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12113331006784457,3842.2800799999955,null,null,749567,null,4205,4,">0.52",null,0.52]
[749567,null,1739,20,0.92800000000000005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1228506893753115,3881.7450699999954,null,null,749567,null,1739,20,0.92800000000000005,null,0.92800000000000005]
[749567,null,1567,20,0.82599999999999996,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12458395035438274,3921.2100599999953,null,null,749567,null,1567,20,0.82599999999999996,null,0.82599999999999996]
[749567,null,469,100,0.92500000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12633338478526784,3960.6750499999953,null,null,749567,null,469,100,0.92500000000000004,null,0.92500000000000004]
[749567,null,461,100,0.9,0.89500000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12809929056406036,4000.1400399999952,null,null,749567,null,461,100,0.9,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12988197190044395,4039.6050299999952]

{"sheet":"Datasheet","index":1,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Put here the Absorbances (B6 - M13)"]
["If the data are in ASCII then: File, open, select in 'files of type' \"text files\" and import the data. Select the proper delimiter to get every absorbtion in a separate excel cell."]
["Then select the data, press copy and return to this sheet. Put the cursor in cell B6 and press paste."]
["Absorbance matrix"]
[]
[null,423,445,682,732,1156,1316,2499,2299,3872,4158,211,212]
[null,2614,2527,1031,1089,526,549,205,215,220,199,210,214]
[null,2450,608,244,2516,623,238,4451,3717,1206,4053,3769,1330]
[null,4950,4683,1982,4821,4597,2057,2450,608,244,2516,623,238]
[null,4479,4120,1244,4708,3969,1296,2450,608,244,2516,623,238]
[null,4402,1739,469,4205,1567,461,4950,4683,1982,4821,4597,2057]
[null,4833,2825,603,4865,2784,608,4479,4120,1244,4708,3969,1296]
[null,4368,3716,919,4132,3761,870,4402,1739,469,4205,1567,461]
[]
[]
[]
[]
[]
["Put here the concentration of the calibration curve in bold fontface. Do not forget a blank with concentration 0 !! Enter the name of the samples in normal font (B22 - M29)"]
["Concentration matrix"]
[null,"Vul de jobnummers in de kaders in. De andere vijf velden worden dan vanzelf ingevoerd"]
[null,8.1250000000000003E-3,8.1250000000000003E-3,1.6250000000000001E-2,1.6250000000000001E-2,3.2500000000000001E-2,3.2500000000000001E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.13,0.13,0,0]
[null,15124,15124,15124,15124,15124,15124,749531,{"$f":"$H23","v":749531},749531,749531,749531,749531]
[null,749351,{"$f":"$B24","v":749351},749351,749351,749351,749351,749562,749562,749562,749562,749562,749562]
[null,749367,749367,749367,749367,749367,749367,749563,749563,749563,749563,749563,749563]
[null,749385,749385,749385,749385,749385,749385,749564,749564,749564,749564,749564,749564]
[null,749402,749402,749402,749402,749402,749402,749565,749565,749565,749565,749565,749565]
[null,749403,749403,749403,749403,749403,749403,749566,749566,749566,749566,749566,749566]
[null,749404,749404,749404,749404,749404,749404,749567,749567,749567,749567,749567,749567]
[]
[]
[]
["Put here the dilutions of the samples (B36 - M43)"]
["Dilution matrix"]
[]
[null,1,1,1,1,1,1,1,1,1,1,1,1]
[null,20,20,50,50,100,100,4,20,100,4,20,100]
[null,4,20,100,4,20,100,4,20,100,4,20,100]
[null,4,20,100,4,20,100,20,100,500,20,100,500]
[null,20,100,500,20,100,500,4,20,100,4,20,100]
[null,4,20,100,4,20,100,4,20,100,4,20,100]
[null,4,20,100,4,20,100,4,20,100,4,20,100]
[null,4,20,100,4,20,100,4,20,100,4,20,100]
[]
[]
["Results"]
[]
[null,">",8.5000000000000006E-3,1.5600000000000001E-2,1.7100000000000001E-2,2.93E-2,3.4000000000000002E-2,7.0400000000000004E-2,6.3800000000000009E-2,0.122,">0.13","<<",">"]
[null,1.48,1.43,1.29,1.37,1.1000000000000001,1.1700000000000002,"<<",">",">","<<","<<",">"]
[null,0.27500000000000002,0.26900000000000002,">",0.28399999999999997,0.27800000000000002,">",">0.52",2.3200000000000003,3.08,0.52200000000000002,2.36,3.4399999999999995]
[null,">0.52",">2.6",5.3800000000000008,">0.52",">2.6",5.61,1.3800000000000001,1.35,">",1.42,1.3900000000000001,">"]
[null,">2.6",">13",15.9,">2.6",12.7,16.7,0.27500000000000002,0.26900000000000002,">",0.28399999999999997,0.27800000000000002,">"]
[null,">0.52",0.92800000000000005,0.92500000000000004,">0.52",0.82599999999999996,0.9,">0.52",">2.6",5.3800000000000008,">0.52",">2.6",5.61]
[null,">0.52",1.6300000000000001,1.33,">0.52",1.6,1.35,">0.52",">2.6",3.19,">0.52",2.5300000000000002,3.3400000000000003]
[null,">0.52",2.31,2.25,">0.52",2.3499999999999996,2.11,">0.52",0.92800000000000005,0.92500000000000004,">0.52",0.82599999999999996,0.9]
[]
[]
[null,"."]
[]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["A","l","l","l","l","l","l","l","l","l","l","l","l"]
["B","l","l","l","l","l","l","l","l","l","l","l","l"]
["C","l","l","l","l","l","l","l","l","l","l","l","l"]
["D","l","l","l","l","l","l","l","l","l","l","l","l"]
["E","l","l","l","l","l","l","l","l","l","l","l","l"]
["F","l","l","l","l","l","l","l","l","l","l","l","l"]
["G","l","l","l","l","l","l","l","l","l","l","l","l"]
["H","l","l","l","l","l","l","l","l","l","l","l","l"]

{"sheet":"Absorbance","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Import","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instructions","index":4,"n_rows":181,"n_cols":13,"rows_kept":181,"cut":false,"hidden":false,"merged":[]}
["ELISA LOGIT short manual"]
[]
["The 'Get ELISA data' button copies data from the Datasheet sheet in the Logit sheet and performs a logit regression on the calibration line data."]
["After pressing the 'Logit' button a logit regression is performed and results are calculated. If there is a 1 in cell J4 a result matrix is printed. (NB Matrix is sorted after \"Sort on Name\")"]
["The 'Calc average' button calculates the mean of samples with the same name adjacent to each other. Cell J2 contains the max Coefficient of Variation value for flagging \"Bad Average\""]
["Column AA-AD contains the data before deleting results as backup."]
["The 'Sort on Name' button sorts the calibration line to top and sorts the sample names. (NB The result matrices are also sorted and become unusable)"]
["Enter in cell J3 a 0 if no results should be calculated outside the lowest and highest point a the calibration curve. (recommended)"]
["Enter a 1 for extrapolation of the results or a zero for no extrapolation. Enter 2 for Spline curve fit"]
["Enter in cell J3 a 2  if no results should be calculated outside the Blank and highest point a the calibration curve."]
["It is possible to calculate results between the lowest calibration dose and the blank with linear regression. Enter a 1 before the field \"Linear between blank and lowest dose\""]
["The linear calculated results will be underlined. "]
["Enter a zero before \"'> or < result displayed (0=no, 1= yes)\" if the range values should not be displayed"]
[]
[0.15,"Max deviation for bad average"]
[0,"Extrapolate (0=no, 1=yes, 2=between blank and highest doset)"]
[null,"Matrix? Empty = no"]
[0,"Linear between blank and lowest dose (0=No, 1=yes, 2=spline)"]
[3,"significant digits"]
[0,"> or < result disp[ayed (0=no, 1= yes)"]
[]
["File names"]
[null,"Separator",1,"0 = Space, 1=Comma, 2=Semicolon "]
[null,"Export","export.txt"]
[null,"Abs file"]
[]
["Absorbances in a file are separated by a character, the delimiter. The space, comma and semicolon are often used for the separation."]
["Choose the type of separator with a 0, 1 or 2"]
["The export file name can be given, including a path if needed"]
["If the cell \"Abs file\" is empty a file open dialog box is opened and a filename is asked for."]
["If an absorbance file name is given than the program does not ask for a file name."]
[]
["ELISA data"]
["Place the absorbances in B6-M13"]
["Put the concentrations and sample names in area B22-M29. "]
["Put the dilutions in range B36-M43. If blank no dilution is assumed"]
[]
["Manual input of data"]
["Enter a sample name/number in column A. Samples can be sorted on the name entered in this column. "]
["Enter the concentrations of the standard curve in column B. A blank is obligatory (concentration = 0)."]
["If more than one blank is entered the average of these blanks is used in the regression."]
["Enter the responses in column C."]
["Enter a dilution in column D. If no dilution is entered then 1 is assumed"]
["Press ALT+L or the Logit button to start the calculation."]
["Remove a response in the calibration line by selecting it and pressing the 'Italic' (CTRL+I) button. This point will be omitted and moved to column E after Logit for recalculation has been pressed"]
[]
["Keep your data between 1 and 1000 to avoid awful graphs. Use milli Abs instead of Abs (234 instead of 0.234)"]
[null,null,null,"Dil","Result"]
["The sheet will look something like this:"]
["Name","Conc","Meas"]
[null,0,0]
[null,1,3]
[null,2,5]
[null,4,22]
[null,8,42,1]
[null,16,77,2]
[null,32,110]
["Sample1",null,66,2]
["Sample2",null,44,1]
["Sample3",null,22,1]
["Sample4",null,11]
["Sample5",null,77]
[]
["Results"]
["The folowing parameters are calculated"]
["ELISA Logit regression V01Jul2018",null,null,null,"Version of the program"]
["Correlation",0.9995620333276819,null,null,"Measure of the fit.( Best practice: >0.9900 with 5 data points in duplo) "]
["Slope",1.0093123421520256,null,null,"Ln(( reponse-Blank) / (Bmax-response)) = slope * Ln conc + intercept"]
["Intercept",-2.8993860738259287]
["Blank",1.35E-2,null,null,"Repsonse of the blank"]
["Bmax",3.5504102710376744,null,null,"Response if concentration is infinite"]
["[1/2Bmax]",17.683555019814214,null,null,"Concentration at 1/2 Bmax"]
["Iterations",28,null,null,"Iterations used to optimise the fit"]
[]
[]
["Ed Nieuwenhuys"]
["ednieuw@xs4all.nl"]
["https://ednieuw.home.xs4all.nl"]
[]
[]
["V22082003 --> V12032004 Improved sorting dilutions"]
["V12032004 --> V21042005 Added linear interpolation, significant digits, > and < than concentration"]
["V21042005 --> V04apr2007 absorbance file input directly from two types of ELISA-readers. Validated release D-VR-512-EN-005657"]
["V04apr2007 --> V25Oct2009 Corrected some type errors in text. Validated release D-VR-512-EN-008349"]
["V25Oct2009 --> V18jun2011 Corrected some type errors in text; added example files; added < or > result in average column "]
["V18Jun2011 --> V14Apr2012 Added calculation of result > or < range times dilution "]
["V01Sep2012 --> Added logit-log graph. Corrected minor issues"]
["V19Jan 2013 --> Added Logit-Log graph hard coded in VB"]
["V03Feb2013 --> Clean for Template button added; default no export.txt file. Validated release D-VR-512-EN-008651"]
["V03Feb2013'_1 ---> Bugfix 10 jan 2014 Removed sorting after \"Get ELISA data\". Removed text with white font from cell in column K,L M and N. GAMP-5 validated release"]
["V24May2017 --> Bug fix in matrices in Logit and Datasheet. They will not be sorted after sorting. Some textual changes. GAMP-5 validated release "]
["V01Jan2018 --> Added Spline curve fit, date format under export button (O9)"]
["V01Feb2018 -->  Changed > and < limits, ie LLOQ and ULOQ, now based on concentration instead of min and max respons."]
["V01Mrt2018 --> Added p non-linearity calculation from \"Inleiding tot de medische statistiek, 2de druk 1964, Preventieve Geneeskunde, Leiden\", hoofdstuk 19 Made iteration steps smaller resulting is a slightly better fit (correlation)"]
["V01Jul2018 --> Final validated release. Disabled p non-linearity calculation"]
[]
["Demo data: Copy them in the Datasheet."]
["Absorbance matrix"]
[]
[null,3794,3061,2264,1478,911,573,425,303,293,264,245,244]
[null,3815,3202,2205,1570,891,543,390,301,274,257,231,281]
[null,4831,4831,4831,4144,3192,2147,1288,743,464,311,258,237]
[null,4803,4985,4985,4985,4487,3772,2526,1427,776,459,336,237]
[null,3273,2598,1838,1086,625,382,266,228,214,198,250,232]
[null,4461,4634,4238,4078,3156,2074,1307,722,409,294,236,216]
[null,4411,4399,4055,3329,2568,1874,1129,646,407,285,239,163]
[null,4342,3720,3577,2992,2298,1543,983,550,352,264,370,222]
[]
[]
[]
[]
[]
["Put here the concentration of the calibration curve in bold fontface. Do not forget a blank!! Enter the name of the samples in normal font (B22 - M29)"]
["Concentration matrix"]
[]
[null,5.4399999999999997E-2,2.7199999999999998E-2,1.3599999999999999E-2,6.7999999999999996E-3,3.3999999999999998E-3,1.6999999999999999E-3,8.4999999999999995E-4,0,"Empty","Empty","Empty","Empty"]
[null,5.4399999999999997E-2,2.7199999999999998E-2,1.3599999999999999E-2,6.7999999999999996E-3,3.3999999999999998E-3,1.6999999999999999E-3,8.4999999999999995E-4,0,"Empty","Empty","Empty","Empty"]
[null,15105,15105,15105,15105,15105,15105,15105,15105,15105,15105,"Empty","Empty"]
[null,758416,758416,758416,758416,758416,758416,758416,758416,758416,758416,"Empty","Empty"]
[null,758426,758426,758426,758426,758426,758426,758426,758426,758426,758426,"Empty","Empty"]
[null,15105,15105,15105,15105,15105,15105,15105,15105,15105,15105,"Empty","Empty"]
[null,758829,758829,758829,758829,758829,758829,758829,758829,758829,758829,"Empty","Empty"]
[null,758879,758879,758879,758879,758879,758879,758879,758879,758879,758879,"Empty","Empty"]
[]
[]
[]
["Put here the dilutions of the samples (B36 - M43)"]
["Dilution matrix"]
[]
[null,1,1,1,1,1,1,1,1,1,1,1,1]
[null,1,1,1,1,1,1,1,1,1,1,1,1]
[null,50,100,200,400,800,1600,3200,6400,12800,25600,1,1]
[null,50,100,200,400,800,1600,3200,6400,12800,25600,1,1]
[null,50,100,200,400,800,1600,3200,6400,12800,25600,1,1]
[null,50,100,200,400,800,1600,3200,6400,12800,25600,1,1]
[null,50,100,200,400,800,1600,3200,6400,12800,25600,1,1]
[null,50,100,200,400,800,1600,3200,6400,12800,25600,1,1]
[]
[]
[]
[]
[null,"Spline test"]
[]
[null,858,877,69,35,106,125,469,414,175,516,854,689]
[null,900,802,65,39,109,164,454,398,179,564,804,649]
[null,165,138,90,97,338,144,164,464,606,632,201,696]
[null,154,543,90,93,344,144,166,448,572,651,197,727]
[null,42,302,133,139,74,108,759,475,658,564,182,440]
[null,32,319,150,153,78,110,693,52,678,513,199,442]
[null,394,159,45,237,161,154,459,466,169,173,730,308]
[null,420,168,48,247,155,151,438,50,166,184,693,255]
[]
[]
[]
[]
[]
[]
[]
[]
[null,200,"Hoog ctrl (15-93)",754212,754768,758057,753136,755364,747297,751342,757093,748671,750512]
[null,200,"Midden ctrl (15-91)",754212,754768,758057,753136,755364,747297,751342,757093,748671,750512]
[null,20,"Laag ctrl (15-132)",754243,755325,747817,753812,981079,748432,751492,758388,748983,751093]
[null,20,"Anti C1q st. ",754243,755325,747817,753812,981079,748432,751492,758388,748983,751093]
[null,2,753922,754399,755461,752300,754159,747901,749431,754254,758202,749071,751958]
[null,"neg ctrl",753922,754399,755461,752300,754159,747901,749877,754254,758202,749071,751958]
[null,"Pos ctrl",754027,754492,755821,752410,755067,746708,749431,755786,746943,749879,752233]
[null,"Pos ctrl",754027,754492,755821,752410,755067,746708,749877,755786,746943,749879,752233]
[]
[]
[]
[]
[]
[]
[null,1,1,1,1,1,1,1,1,1,1,1,100]
[null,1,1,1,1,1,1,1,1,1,1,1,100]
[null,1,1,1,1,1,1,1,1,1,1,1,1]
[null,1,1,1,1,1,1,1,1,1,1,1,1]
[null,1,5,10,1,1,1,1,1,1,1,1,1]
[null,1,5,10,1,1,1,1,1,1,1,1,1]
[null,40,1,1,1,1,1,1,1,1,1,1,20]
[null,40,1,1,1,1,1,1,1,1,1,1,20]