AGANTG: a Microsoft EXCEL 5.0–Visual Basic routine for the analysis of dose–response data

(Note: The full text of this document is currently only available in the PDF Version )

Peter J. Zielinski and Steve Buckner

A Microsoft EXCEL 5.0 program was developed to evaluate data from biochemical and functional bioassays, an important step in drug discovery. The program accommodates both agonist and antagonist data. The program, written entirely in Visual Basic, is compatible with both Macintosh and PC platforms. Data are conveniently entered into a worksheet following only a few simple rules. The program performs complex data analysis and outputs calculated and graphic results to EXCEL worksheets. A set-up routine with a convenient dialog box offers the user controls regarding data analysis and results formats. After determining if the data are from an agonist or antagonist assay, the program automatically performs the analysis and outputs results in the proper format. Calculations support Schild analysis for antagonists. An agonist and antagonist were analyzed to illustrate program usage and results generated by the analsis. EXCEL–Visual Basic is a useful and convenient tool for evaluating bioassay data. Data entry is greatly simplified and custom reports can be generated with relative ease. Data are stored in a format that allows for easy editing re-analysis.


  1. G. Tack, K. A. Roselli, A. Overhoser and T. R. Harris, Comput. Biomed. Res., 1995, 28, 24 CrossRef CAS.
  2. O. Arunlakshana and H. O. Schild, Br. J. Pharmacol., 1959, 14, 48 Search PubMed.
  3. D. R. Waud and R. B. Parker, J. Pharmacol. Exp. Ther., 1971, 177 Search PubMed.
  4. D. Rodbard and S. W. McClean, Clin. Chem., 1977, 23, 112 CAS.
  5. D. Rodbard, Clin. Chem., 1974, 20, 1255 CAS.
  6. A. Delean, P. J. Munson and D. Rodbard, Am. J. Physiol., 1978, 4, e97 Search PubMed.
  7. W. H. Press, B. P. Flannery, S. A. Teukolsky and W. T. Vetterling, Numerical Recipes, The Art of Scientific Computing, Cambridge University Press, Cambridge, 1986 Search PubMed.
  8. G. Dahlquist and A. Bjorck, Numerical Methods, Prentice-Hall, Englewood Cliffs, NJ, 1974 Search PubMed.
  9. R. R. Furchgott, in Handbook of Experimental Pharmacology, ed. Blaschko, H., and Muscholl, E., Springer, Berlin, 1972, vol. 33, pp. 283–335 Search PubMed.
  10. R. J. Tallarida and R. B. Murray, Manual of Pharmacologic Calculation with Computer Programs, Springer, New York, 2nd edn., 1987 Search PubMed.
  11. G. W. Snedecor and W. G. Cochran, Statistical Methods, Iowa State University Press, Ames, IA, 7th edn., 1980 Search PubMed.