Generally, many scientists use a program which came from a plate reader. I agree that It is very useful. However, it sometimes does not fit to an assay layout for assay optimization when we add many combinations of reagent tests. It is very important that we can analyze data with Excel which we want to know the results of.
In duplicate assays, make an average of OD values, then subtract OD values of standard (and samples) with the averaged blank OD values. We use the OD values for the analysis.
In many cases, a log-log analysis fits with making a standard curve for a regression analysis. To make it easy, we can plot OD values in the x-axis, and standard concentration in the y-axis.
Choose “Format Axis” then “Logarithmic scale (base 10)”
Choose “Trendline” then “POWER” and “Display Equation on Chart”
Now you can make a calculation.
“=slope values x POWER (OD value of samples, power value)”
Then multiply the results with sample dilution factors to obtain real values of analytes.
DONE (1)
1. M. F. Clark, D. J. Barbara, A method for the quantitative analysis of ELISA data. J. Virol. Methods. 15, 213–222 (1987).