Chromatography Forum

Hello,
Currently the report that I get out of the LC software gives me the area , retention time, ID, concentration%. However i have some calculations that I do in an excel sheet( concentration=area/detector response and normalization calculations) . I would like to be able to generate these values using the software itself, so that the report will show these calculated values. I am trying to make this easy for the QC people. Please let me know.
Thank You
Prithi

Hello,

If you are dealing with the LC-Solutions software from Shimadzu, the best you can probably do is to export all the data in .csv (comma separated values) or .tsv (tab separated values) and import them directly into excel or another spread sheet. From there you would just probably need to highlight the pertinent columns. Another way if your software allows, is to export the file in the .CDF (ANDI) / .netCDF format, which can be opened by other programs (the .CDF format is suppose to be the open access format for chromatograms/mass spectra). If you want, you may also be able to import the .CDF file in R or Matlab to automate the process. Good Luck.

Also you can try our approach
Download UniChrom http://www.unichrom.com/dle.php
Import your file http://www.unichrom.com/chrom/uc-ffe.shtml
Use internal spreadsheet-like calculator (View/Work Area/Add/Calculator)
http://www.unichrom.com/solutions/fame-shot.png

Or install Excel Add-In from UniChrom/reports/xla/unichrom.xla
And use in your Excel sheet something like this:

Get the peak area: