Scientists from Analytical Sciences at Geneva University and the Institute of Analytical Sciences (ISA CNRS / UCBL Lyon1)  developped a calculator tool as an an alternative solution to the use of HPLC modeling software for those who are not equipped.

This Excel tool allows to calculate the LSS parameters (log k0 and S) to model retention of compounds in liquid chromatography, based on a minimum number of two gradients (up to four gradients can be considered). Besides providing the log k0 and S values, it also allows to predict retention time under different gradient conditions. Due to the fact the log ki has to be higher than 2.1, this excel tool is particularly well adapted for proteins which possess a on/off mechanism of retention.

More information on the mathematical procedure employed in the calculator can be found in: D. Guillarme, T. Bouvarel, F. Rouviere, S. Heinisch, A simple mathematical treatment for predicting linear solvent strength behaviour in gradient elution: application to biomolecules, Journal of Separation Science, 2022, Submitted for publication

Calculation of LSS parameters in LC v1 (English): download the file (Licence: freeware – date added 28 February 2022 – Version1)

Open the file « Calculation of LSS parameters in LC v1.XLSX » with Excel – Compatible system: Excel 2007 2016 (Office 365)