16 Replies Latest reply on Jun 7, 2018 1:41 AM by wydnaa

    Chemstation 3d file conversion


      We use chemstation software on our HPLC and monitor 5 different wavelengths in our method. We were told that the software monitors at all wavelengths in the background but we are unsure of how to extract that information from the program. What we are needing is all the monitored wavelength data such as retention time, area and height. Is there a way to get this information in an excel type file? What is the process?



        • Re: Chemstation 3d file conversion

          Hi Debbie,


          I marked this post as a questions and added tags to increase visibility.


          Before jumping into this, would you mind sharing the revision of ChemStation that you are using (go to Help>About) as well as the model number of your detector module?

            • Re: Chemstation 3d file conversion

              Thanks for your help

              The revision number for ChemStation is C.01.07[27] and the detector model is the Agilent 1260 infinity.

                • Re: Chemstation 3d file conversion

                  When you say that you monitor 5 wavelengths, do you mean that you acquire the signals for these wavelengths? In other words, are these wavelengths defined in your detector method as signals and is the Acquire checkbox checked for each signal?


                  If you are collecting the data of interest as signals, then a simple report should be all you need to get the result information (RT, height, area, etc...) into an Excel format. To check your report settings in Data Analysis, go to Report>Specify Report. For a file that is readable in Excel, you would want to select a file type of either .CSV or .XLS after you select the destination as File:


                  If you do not have a calibration table built for all of your peaks of interest in all of your signals, then the best report format for you would most likely be an Area Percent report. You can set this in the Quantitation Settings tab in the Specify Report window:



                  After saving the method, you can then print the report by going to Report>Print Report. When printing to a File, the report file will be generated in the *.D folder for the loaded data file. If you would like to automate this process, you will need save the report settings to your Master Method (Method>Update Master Method) and make sure that you are choosing to perform Standard Data Analysis in the Master Method's Run Time Checklist (Method> Run Time Checklist).


                  Hopefully this helps.

              • Re: Chemstation 3d file conversion

                Hi Debbie


                Sounds to me like you want to extract chromatograms that you didn't collect as signals in the DAD part of your method.  The simple answer is that this is not simple in Chemstation.  You can use the isoabsorbance plot, instead of the 3D plot to extract chromatograms at whatever wavelength you want, and display this as a chromatogram and use that signal to get peak areas etc, but you can't then save this signal for further processing.  This feature is best used in method development, to identify which signals you should collect as part of your method.



                The functionality to extract data from spectra as you describe it was just made available in the recently released version 2.3 of OpenLab CDS.