{"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":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Name","Conc","Resp","Dil","Result","Average","Del Result","ELISA Logit regression V08Dec2021",null,null,null,"Testdate:","08-Dec-2021 14:33:12"]
[null,null,null,null,null,null,null,"Correlation",null,0.15,"Max CV% for bad average)"]
[null,null,null,null,null,null,null,"Slope",null,0,"Extrapolate (0=no, 1=yes, 2=between blank and highest dose)"]
[null,null,null,null,null,null,null,"Intercept",null,0,"Matrix? (0=no, 1=yes)"]
[null,null,null,null,null,null,null,"Blank",null,0,"Linear between blank and lowest dose (0=No, 1=yes, 2=spline)"]
[null,null,null,null,null,null,null,"Bmax",null,3,"Significant digits"]
[null,null,null,null,null,null,null,"[1/2Bmax]",null,1,"> or < result displayed (0=no, 1=yes)"]
[null,null,null,null,null,null,null,"Iterations",null,"Separator",0,"0=Space, 1=Comma, 2=Semicolon "]
[null,null,null,null,null,null,null,null,null,"Export file",null,null,null,null,"dd-mmm-yyyy hh:mm:ss"]
[null,null,null,null,null,null,null,null,null,"Abs file"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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,1,2,3,4,5,6,7,8,9,10,11,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Put here the dilutions of the samples (B36 - M43)"]
["Dilution matrix"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]