by
Karen01 » Sun Feb 13, 2011 6:32 am
I'm a self-professed computer idiot and I can do very well on ChemStation, including automated Sequence Summary Reports and automated System Suitability Reports, as well as copying chromatograms very nicely into Word for my validation reports. So I like it, but note that I haven't tried others.
Having your data and methods (and method versions) in a database gives you a lot of potential for streamlining a lot of stuff that needs to be done AFTER the chromatography is finshed.
BTW in another thread I asked about a certain type of summary report... As I did not want to take the time to learn the macro language, what i did was write a program in a language i know and I am almost finished with the first version.
I created a report layout in ChemStation that was both easily human readable (and had a chromatogram for each injection) but also easy to parse in code. I had ChemStation spit out the report to files as both Text and PDF. Unfortunately those files go into the individual injection data folders (Not exactly convenient for compiling and distributing them!!!)
My program finds the text file versions of the reports ACROSS sequences that it presents to me as a list in reverse chronological order that i select using checkboxes, and parses them to extract the relevant data.
It then presents me a list of injections from those sequences with columns for:
sample names
files names
date aquired
analyte results (usually amount Or area) for all analytes found in any injection in the set
It then lets me on the fly pick which injections i want to include in a 'printed' summary report. It also lets me pick which analytes to summarize results for in that final report.
Double clicking an injection also brings up the PDF version of the report for me to do a quickly review the "raw data" and chromatogram if I want.
Once I chose the injections it then creates a folder on the desktop, writes the summary report to it as graphic AND also as a tab delimited file that can be imported into excel. It then copies the individual PDF report files for those injection to that folder, renaming then with sample names (with stuff added to make them unique but easily human readable), Zips the folder and Emails it to the internal customer(s) I pick from a list.
It does a few more things as well. This will make my life a lot easier when I finish it! If there is a version 2 I think i'll put the data into a database, but that requires more thought/work.
- Karen