Excel - export Clarity result table, compare with limits

You can discuss anything concerning Clarity in this section.
Post Reply
User avatar
Petr Kohutek
DataApex Support
DataApex Support
Posts: 57
Joined: Fri Mar 27, 2009 3:15 pm
Location: Praha
Contact:

Excel - export Clarity result table, compare with limits

Post 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.
Attachments
Screenshot of the Excel sheet created using the macro
Screenshot of the Excel sheet created using the macro
xls-export.zip
Macro for export
(417.38 KiB) Downloaded 196 times
Petr Kohutek
DataApex

Daniel Randula
Posts: 6
Joined: Mon Jul 17, 2017 1:42 pm

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

Post 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.
Daniel Randula

Post Reply