biochrom EZ Read 400, Quick Start Manual

Page: 3 / 5

Technical Tip: Transferring quantitative data from ADAP to MS Excel Version 2.0 3
select Options>Copy all data on to clipboard . Now open Excel. Select Paste or control (v) to paste
into the empty workbook. Data will paste as a matrix with filter wavelength, with time and date.
9. In a new Excel spreadsheet, layout the page with the plate layout and raw data:
Data Export
1 2 3 4 5 6 7 8 9 10 11 12
A
1.453 1.446 1.398 1.432 0.240 0.085 0.503 0.082 0.086 0.440 0.085 0.091
B
0.729 0.720 0.714 0.615 0.595 0.118 0.082 0.648 0.130 0.088 0.435 0.082
C
0.431 0.432 0.420 0.386 0.087 0.084 0.570 0.129 0.084 0.082 0.084 0.085
D
0.239 0.234 0.235 0.217 0.237 0.334 0.081 0.084 0.090 0.173 0.086 0.088
E
0.146 0.145 0.148 0.156 0.090 0.086 0.081 0.256 0.084 0.085 0.578 0.601
F
0.109 0.115 0.115 0.108 0.508 0.086 0.500 0.083 0.336 0.085 0.092 0.085
G
0.096 0.150 0.099 0.097 0.082 0.337 0.082 0.156 0.414 0.088 0.084 0.088
H
0.088 0.090 0.092 0.086 0.166 0.085 0.634 0.088 0.101 0.091 0.089 0.082
10. Determine the average absorbance of the blank wells and subtract this value from the remaining
wells:
Average Blank Absorbance:
B1 B2 B3 B4 Mean (OD)
0.088 0.09 0.092 0.086 0.089
Blank Corrected Absorbance:
1 2 3 4 5 6 7 8 9 10 11 12
A 1.364 1.357 1.309 1.343 0.151 -0.004 0.414 -0.007 -0.003 0.351 -0.004 0.002
B 0.640 0.631 0.625 0.526 0.506 0.029 -0.007 0.559 0.041 -0.001 0.346 -0.007
C 0.342 0.343 0.331 0.297 -0.002 -0.005 0.481 0.040 -0.005 -0.007 -0.005 -0.004
D 0.150 0.145 0.146 0.128 0.148 0.245 -0.008 -0.005 0.001 0.084 -0.003 -0.001
E 0.057 0.056 0.059 0.067 0.001 -0.003 -0.008 0.167 -0.005 -0.004 0.489 0.512
F 0.020 0.026 0.026 0.019 0.419 -0.003 0.411 -0.006 0.247 -0.004 0.003 -0.004
G 0.007 0.061 0.010 0.008 -0.007 0.248 -0.007 0.067 0.325 -0.001 -0.005 -0.001
H -0.001 0.001 0.003 -0.003 0.077 -0.004 0.545 -0.001 0.012 0.002 0.000 -0.007
Plate Layout
1 2 3 4 5 6 7 8 9 10 11 12
A S1 S1 S1 S1
1 9 17 25 33 41 49 57
Standards
B S2 S3 S4 S5
2 10 18 26 34 42 50 58
Blank
C S3 S4 S5 S6
3 11 19 27 35 43 51 59
Samples
D S4 S4 S4 S4
4 12 20 28 36 44 52 60
E S5 S5 S5 S5
5 13 21 29 37 45 53 61
F S6 S6 S6 S6
6 14 22 30 38 46 54 62
G S7 S7 S7 S7
7 15 23 31 39 47 55 63
H Blank Blank Blank Blank
8 16 24 32 40 48 56 64