HPLC Teaching Assistant

A Free Spreadsheet-Based Program for Learning and Teaching Liquid Chromatography
Developed by Davy Guillarme & Jean-Luc Veuthey
University of Geneva · University of Lausanne
Web Edition v1.41 — rebuilt 2026
Resolution
Van Deemter
Log P
pKa
Temperature
Isocratic mode
Gradient mode
Injected volume
Tubing
Molecular weight
CHROMATOGRAPHIC RESOLUTION — Impact of k, α and N
INPUT PARAMETERS
Retention factor of the first peak (k1)—
Selectivity factor (α)—
Number of theoretical plates (N)plates
Dead time (t0)min
OUTPUT — RESOLUTION
QuantityValueUnit
Retention factor (k2)——
Retention time of peak 1 (tR1)—min
Retention time of peak 2 (tR2)—min
Peak width (w)—min
Resolution (RS)——
Separation quality——
The fundamental resolution equation: RS = (√N/4) · [(α−1)/α] · [k/(1+k)]
CHROMATOGRAM
IMPACT OF k, α AND N ON RESOLUTION
RS vs Retention factor k
RS vs Selectivity α
RS vs Plate number N
VAN DEEMTER EQUATION — Kinetic Performance
COLUMN PARAMETERS
Column length (L)mm
Column internal diameter (dc)mm
Particle size (dp)µm
Flow rate (F)mL/min
Mobile phase —
Temperature (T)°C
OUTPUT — KINETIC PERFORMANCE
QuantityValueUnit
Column dead time (t0)—min
Linear velocity (u)—mm/s
Reduced velocity (ν)——
Optimal linear velocity (uopt)—mm/s
Plate number (N)—plates
Plate height (H)—µm
Minimum plate height (Hmin)—µm
Pressure drop (ΔP)—bar
Maximum flow rate (ΔP=1000 bar)—mL/min
H vs u VAN DEEMTER CURVE
N vs F PLATE NUMBER VS FLOW RATE
LOG P — Retention in Reversed-Phase LC
INPUT PARAMETERS
Analyte log P (octanol-water)—
% Methanol in mobile phase% MeOH
Column dead time (t0)min
OUTPUT — RETENTION
QuantityValueUnit
S parameter (slope)——
log kw (100% water)——
Retention factor (k)——
Retention time (tR)—min
Elution strength evaluation——
Snyder-Dolan LSS model: log k = log kw − S·φ
log kw ≈ 0.94 + 0.74·log P    S ≈ 0.25·log kw + 1.5
LOG P APPLICABILITY RANGE
RETENTION MAP — log k vs % METHANOL
PKA — Mobile Phase pH and Analyte Ionization
INPUT PARAMETERS
Analyte type —
pKa value—
Mobile phase pHpH
Column dead time (t0)min
log P (neutral form)—
% Methanol%
OUTPUT — IONIZATION & RETENTION
QuantityValueUnit
% Ionized—%
% Neutral—%
Retention factor (k)——
Retention time (tR)—min
Ionization state——
% IONIZATION vs pH
RETENTION FACTOR vs pH
TEMPERATURE — Thermodynamic & Kinetic Effects
INPUT PARAMETERS
Column temperature (T)°C
ΔH (enthalpy of retention)kJ/mol
log k at 30 °C—
Column length (L)mm
Particle size (dp)µm
Flow rate (F)mL/min
Analyte MWg/mol
OUTPUT
QuantityValueUnit
Retention factor k (at T)——
Diffusion coefficient (Dm)—cm²/s ×10⁻⁵
Mobile phase viscosity (η)—cP
Plate number N—plates
Pressure drop ΔP—bar
VAN'T HOFF PLOT — log k vs 1/T
PRESSURE & EFFICIENCY vs TEMPERATURE
ISOCRATIC MODE — LSS Retention Modeling
INPUT PARAMETERS
Column length (L)mm
Column i.d.mm
Particle size (dp)µm
Flow rate (F)mL/min
% Methanol (φ)% MeOH
Temperature (T)°C
COMPOUNDS (log P & S)
#Namelog PS
CHROMATOGRAM (ISOCRATIC)
SEPARATION QUALITY
MetricValue
Dead time t0 (min)—
Last peak tR (min)—
Minimum resolution RS,min—
Critical pair—
RS,min vs % METHANOL (METHOD OPTIMIZATION)
GRADIENT MODE — Linear Solvent Gradient Elution
COLUMN & INSTRUMENT
Column length (L)mm
Column i.d.mm
Particle size (dp)µm
Flow rate (F)mL/min
Dwell volume (VD)mL
GRADIENT PROFILE
Initial % MeOH (φ0)%
Final % MeOH (φf)%
Gradient time (tG)min
Column re-equilibrationmin
GRADIENT CHROMATOGRAM
PERFORMANCE
t0 (min)—
Dwell time (min)—
Gradient steepness b—
Peak capacity nc—
Cycle time (min)—
RS,min—
Peak capacity vs tG
RS,min vs tG
INJECTED VOLUME — Sensitivity vs Band Broadening
COLUMN & INJECTION
Column length (L)mm
Column i.d.mm
Particle size (dp)µm
Retention factor (k)—
Injection volume (Vinj)µL
Flow rate (F)mL/min
OUTPUT
QuantityValueUnit
Intrinsic plate number (N)—plates
Column volume (Vcol)—µL
Peak volume (VR)—µL
Max recommended Vinj—µL
Observed plates (Nobs)—plates
Efficiency loss—%
Verdict——
OBSERVED PLATES vs INJECTION VOLUME
TUBING — Extra-Column Band Broadening & Pressure Drop
CONNECTING TUBING PARAMETERS
Tubing length (Ltub)mm
Tubing i.d.mm
Flow rate (F)mL/min
Retention factor (k)—
Column intrinsic Nplates
Column i.d.mm
Column Lmm
Mobile phase viscosity (η)cP
Diffusion coeff Dm×10⁻⁵ cm²/s
OUTPUT — BAND BROADENING & PRESSURE
QuantityValueUnit
Tubing volume (Vtub)—µL
Linear velocity in tubing (utub)—mm/s
Tubing variance σ²tub—µL²
Column variance σ²col—µL²
Nobs after tubing—plates
Efficiency loss from tubing—%
Tubing pressure drop (ΔPtub)—bar
Nobs vs TUBING DIAMETER
EXTRA-COLUMN VARIANCE CONTRIBUTION
MOLECULAR WEIGHT — Thermodynamic & Kinetic Impacts
INPUT PARAMETERS
Analyte molecular weight (MW)g/mol
Temperature (T)°C
Mobile phase viscosity (η)cP
log P—
% Methanol%
Column t0min
OUTPUT
QuantityValueUnit
Diffusion coefficient Dm—×10⁻⁵ cm²/s
S parameter——
log kw——
Retention factor k——
Retention time tR—min
Opt. linear velocity uopt—mm/s
Dm vs MOLECULAR WEIGHT
OPTIMAL u & k vs MW