CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

return home

 

I programmed a little Excel sheet that allows an improved calibration curve fit for Enzyme Linked Immuno Assays (ELISA): it works in Excel versions 2002 - 2010. Please follow the installation guide and the instructions to be sure that Solver works.

 

The semi-automatic version: 4- and 5- Parameter Calibration for Excel versions 2002 - 2003. This version allows for 8 calibration points.

The semi-automatic version: 4- and 5- Parameter Calibration for Excel versions 2007 - 2010. This version allows for 8 calibration points.

The fully automated version: ELISA AUTO CURVE FIT for Excel versions 2002 - 2003. This version now allows for 12 calibration points.

The fully automated version: ELISA AUTO CURVE FIT for Excel versions 2007 - 2010. This version now allows for 12 calibration points.

 

This spreadsheet uses Excel Solver to optimize fitting of the calibration curve. Instructions are included, google for "Findlay, J.W.A. and Dillard, R.F., The AAPS Journal, 2007, E260ff." for a good source on the background.

 

This version is fully functional and you may freely use it as long as you don't sell or exploit it commercially. All rights on this sheet reserved Andreas Swart 2012 - 2014.

 

Screenshot of the automatic spreadsheet:

 

screenshot