Issue 8, 1998

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

Abstract

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.

Article information

Article type
Paper

Analyst, 1998,123, 1661-1668

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

P. J. Zielinski and S. Buckner, Analyst, 1998, 123, 1661 DOI: 10.1039/A804438D

To request permission to reproduce material from this article, please go to the Copyright Clearance Center request page.

If you are an author contributing to an RSC publication, you do not need to request permission provided correct acknowledgement is given.

If you are the author of this article, you do not need to request permission to reproduce figures and diagrams provided correct acknowledgement is given. If you want to reproduce the whole article in a third-party publication (excluding your thesis/dissertation for which permission is not required) please go to the Copyright Clearance Center request page.

Read more about how to correctly acknowledge RSC content.

Social activity

Spotlight

Advertisements