Related Experiment Video
Updated: Apr 15, 2026

Large Scale Non-targeted Metabolomic Profiling of Serum by Ultra Performance Liquid Chromatography-Mass Spectrometry UPLC-MS
Published on: March 14, 2013
Retention prediction and separation optimization under multilinear gradient elution in liquid chromatography with
1Department of Chemistry, Aristotle University of Thessaloniki, 54124, Greece.
Excel VBA macros model gradient elution chromatography data for improved separation. These tools facilitate fitting, prediction, and optimization of chromatographic conditions, enhancing analytical workflows.
Area of Science:
- Analytical Chemistry
- Chromatography
Background:
- Gradient elution chromatography is vital for separating complex mixtures.
- Accurate modeling of retention data is crucial for optimizing separation.
- Existing methods for modeling gradient elution can be complex and time-consuming.
Purpose of the Study:
- To develop and evaluate Excel VBA macros for modeling multilinear gradient retention data.
- To implement and compare four distinct methods for applying chromatographic models.
- To create fitting and optimization platforms for enhanced chromatographic analysis.
Main Methods:
- Development of Excel VBA macros for ten chromatographic models.
- Application of four methods: analytical expression, Nikitas-Pappa approach, stepwise approximation, and numerical integration (trapezoid rule).
- Implementation on fitting and optimization platforms using experimental and artificial data.
Main Results:
- The developed VBA macros effectively perform fitting, prediction, and optimization of chromatographic data.
- Both fitting and optimization platforms demonstrated ease of use and effectiveness across various conditions.
- The analytical and Nikitas-Pappa methods showed the best performance for modeling gradient elution data.
Conclusions:
- Excel VBA macros provide a powerful and accessible tool for modeling gradient elution chromatography.
- The developed fitting and optimization platforms streamline the analysis and optimization of chromatographic separations.
- The analytical and Nikitas-Pappa approaches are recommended for their superior performance in modeling retention data.
More Related Videos
11:25Multi-step Preparation Technique to Recover Multiple Metabolite Compound Classes for In-depth and Informative Metabolomic Analysis
Published on: July 11, 2014
10:41Ion Exchange Chromatography IEX Coupled to Multi-angle Light Scattering MALS for Protein Separation and Characterization
Published on: April 5, 2019
Related Concept Videos
Optimizing Chromatographic Separations
Band broadening refers to spreading solute bands as they travel through the column. This broadening can impact resolution. Plate height (H) represents the length required for one theoretical plate. A lower plate height corresponds to...
High-Performance Liquid Chromatography: Elution Process
Chromatographic Methods: Terminology
High-Performance Liquid Chromatography: Introduction
In HPLC, two phases play a critical role in the separation process:
Chromatographic Resolution
The effectiveness of separation can be evaluated by determining the level of separation between two neighboring peaks in a chromatogram, which represents the individual components of a sample.
In chromatography,...
Principles Of Column Chromatography