Is there a way to batch tabulate retention times for a run and perform calculations either with a user macro or with the ChemStation batch reports? I am performing an indirect measurement of Log P with an Agilent 7100 CE using retention times and known Log P standards. Currently I'm manually transcribing the times into Excel and performing the below calculations for both calibration curves and samples. It would be nice to either perform the calculations in ChemStation or be able to export or copy/paste the times into an Excel file. I know that there are user submitted macros for data manipulation, but I cannot seem to find an appropriate one to use. I attached an example Excel sheet to demonstrate the format of my calculations; it's a lot of number to accurately transcribe!

Calculate a retention factor, k, for each of the Reference Standard compounds according to the below formula:

k = (t_{R} – t_{eo})/(1-t_{R}/t_{mc})t_{eo}

Where k = retention factor

t_{R } = solute migration time, min

t_{mc} = micelle marker migration time, min

t_{eo} = electroosmotic flow migration time, min

Generate a calibration curve by performing a linear regression of log k for each standard compound and the respective literature Log P values.

Log P (CE) = m(log k sample)+b

Where

k = sample retention factor

m = slope from regression of log P literature values /measured log k for standards

b = y-intercept from regression of log P literature values /measured log k for standards

Thanks for the quick reply.

Unfortunately, there is no simple way to accomplish what you are looking for in OpenLab CDS ChemStation that I can outline easily in a reply here on the Community. This would require a custom macro if it is possible at all.

If you are interested in being quoted for a custom macro, please contact your local Agilent representatives: https://www.agilent.com/en-us/contact-us/page