Skip to content
Ed Nieuwenhuys edited this page Jun 17, 2024 · 2 revisions

Button “Open Abs file” (Alt + O)

image

Various lay-outs of ASCII file, that are created by ELISA readers, can be read by the program. The program removes all lines that are shorter than 50 characters and only read lines that start with A, B, C, D, E, F, G or H.

The imported absorbances are placed in the "Data sheet" in the "Absorbance matrix".

The absorbances in the file can be separated by a space, a comma or a semicolon.

This absorbance-“delimiter” can be specified in the separator field. Separator 0 = Space, 1 = Comma, 2 = Semicolon

If a path\filename is typed after “Abs file”, this file is automatically imported after pressing the “Open Abs file” button. If the field is left blank, the program asks for a file name.

If a path with filename is typed after “Export file”, an export file is created with all entered data and calculated results.

image

Button “Get ELISA data” (Alt + E)

image

If the Datasheet is filled with absorbances , sample names, calibration line concentrations and dilutions, the calculation can be started with the “Get ELISA data” button.

The sample names as text or as a number in the "Concentration matrix" are copied in column "A Name" is d font is not bold. The bold concentrations from the "Concentration matrix" are placed in column "B Conc". These are the concentrations of the calibration points.

The measured responses (absorbances, counts etc.) are placed in column "C Resp".The corresponding dilutions are placed in the “D Dil” column.

The program calculates the logit curve and calculates the results for each sample.

The data has not yet been sorted. For this, the "Sort on name" button must be pressed.

Button “Logit” (Alt + L)

image

If points in the calibration line are invalidated by making the Response italic or bold, the calculation can / must be made again using the “Logit” button.

Button “Sort on name” button (Alt + E)

image

With this button the data in the sheet "Logit" is sorted by column "B conc", then on "A Name" and then by "D Dil". After this sort the samples are then sorted together by sample name and the average can be calculated with the "Calc average" button.

Button “Calc Average” (Alt + A)

image

This button calculates the average of all sorted sample names in column A. First press “Sort on Name” to sort the sample names together.

Button “Clean Datasheet” (Alt + D)

image

This red button erases all data from all sheets. The worksheet sheet is completely clean. It can be used when developing a test. It is recommended to start with an empty original template when entering a new test.