Page 1 of 1

Excel - export Clarity result table, compare with limits

Posted: Tue Jun 16, 2009 7:15 pm
by Petr Kohutek
The uploaded macro (xls-export.zip) can do:
  • automatically export the result table after the analysis (by setting the postrun settings)
  • open the exported file in MS Excel,
  • format it and add custom calculations (formulas and a table of limits loaded from the other sheet (limits)
Detailed description is included in the ZIP file.

Can you have a look at it and let me know if it works for you?
Eventually can you send me a description or a sample of the outputs that your customers want to have in Excel?

Actually everybody who has some excel sheets and want to use them with Clarity, please send them in, it will help us to focus the planned excel support to cover these requirements.

Re: Excel - export Clarity result table, compare with limits

Posted: Wed Nov 01, 2017 12:32 pm
by Daniel Randula
Macro updated!

New version of the Excel macro for exporting chromatograms and their subsequent comparing with limits is out now.
You can download the new version in the post above.

It is yours now to give it a try.

Happy with the macro or any hints/tips/wishes? Please let us know.