NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1159639
Record Type: Journal
Publication Date: 2017-Aug
Pages: 7
Abstractor: As Provided
ISSN: ISSN-0021-9584
Teaching Simulation and Computer-Aided Separation Optimization in Liquid Chromatography by Means of Illustrative Microsoft Excel Spreadsheets
Fasoula, S.; Nikitas, P.; Pappa-Louisi, A.
Journal of Chemical Education, v94 n8 p1167-1173 Aug 2017
A series of Microsoft Excel spreadsheets were developed to simulate the process of separation optimization under isocratic and simple gradient conditions. The optimization procedure is performed in a stepwise fashion using simple macros for an automatic application of this approach. The proposed optimization approach involves modeling of the peak shapes in order for the simulation of predicted chromatograms to be possible. The performance of the selected optimization procedure was tested by means of experiments performed on a reversed-phase column that produced Gaussian peaks for all solutes, providing benefits for computational simplicity. The separation optimization by Microsoft Excel especially with simple and easily implemented macros is a challenging pedagogical tool for advanced analytical chemistry courses. An illustrative video given in the Supporting Information supports a novice Excel practitioner in following the proposed separation optimization procedure.
Division of Chemical Education, Inc and ACS Publications Division of the American Chemical Society. 1155 Sixteenth Street NW, Washington, DC 20036. Tel: 800-227-5558; Tel: 202-872-4600; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A