Chemstation automatic %RSD help needed for internal standard

[Consumer Products Guy]

(1) OK, I have Agilent ChemStation (mine happen to be A.09, but shouldn't matter). I know how to use the automated sequence functions to get a summary report for Extended Parameters like peak retention time %RSD, peak area %RSD, tailing, resolution, etc., when using external standard quantitation. However, with internal standard quantitation the %RSD becomes the RSD for analyte peak area divided by internal standard peak area for each injection; is there a way to get the ChemStation software to do this for me? Right now I get the areas for each peak in the summary report (both in Calibration Table, like with external standard) and I've been entering those numbers into an Excel spreadsheet which divides them and calculates the %RSD of the analyte/I.S. ratio. Anybody know how to do this, or have a macro?

(2) Also, anybody have any suggestions on how to have ChemStation automatically or a macro average results for multiple injections in a Sequence Summary Report?

Thanks, computers and software are NOT my stronger areas...

[mbicking]

I have an Excel export macro that will transfer the data directly. You have some control over what information goes through. It can't do everything, but at least it gets the information across, and then you can work on it in Excel.