Chemistry Formatter Add-ins for Microsoft Word and Excel - Journal of

Jul 1, 2002 - MS Word and Excel add-ins that automatically convert chemistry symbols and notations. Keywords (Audience):. High School / Introductory ...
0 downloads 0 Views 126KB Size
Information • Textbooks • Media • Resources edited by

JCE WebWare

William F. Coleman

Abstracts of Recent Articles

Wellesley College Wellesley, MA 02481

W

Randall J. Wildman University of Wisconsin–Madison Madison, WI 53715

Christopher King, Department of Chemistry, Troy State University, Troy, AL 36082

A chemistry formatter is software that does some of the formatting a chemist would otherwise have to do by hand. Chemistry formatters for Microsoft Excel and Word are provided that perform the five functions described below.

appears. The formatters are written in Visual Basic and are packaged as add-ins. The code is not protected, making these add-ins possible templates for new add-ins. A macro and 19 “AutoCorrect” entries are also provided, which can easily be added or removed. After these entries are installed, Word will automatically convert, for example, pKa to pKa, Dgo to ∆G°, . Co-60 to 60Co, and is converted to →. 5. Numbers in the form of 3.2E8 are converted to 3.2 ⫻ 108.

Users select the material to be formatted, click the chemistry formatter button, and the reformatted material

JCE WebWare

896

Figure1. Results of applying the chemistry formatter to cells in an Excel spreadsheet. To run the formatter, users select cells (or other objects), and then click the chemistry formatter button (the O 2 2- button shown at the top).

http://jchemed.chem.wisc.edu/JCEWWW/Features/WebWare/

Journal of Chemical Education • Vol. 79 No. 7 July 2002 • JChemEd.chem.wisc.edu