Empower - Export result tables to Excel

[AdrianF]

I have been told its not possible, maybe somewhere out there knows differently.

[bartjoosen]

You can make an export method which exports your desired data to an ascii file, which can be imported by Excel.
I often do this.


Bart

[AdrianF]

Thanks for your rapid reply - could you go into some more detail as my Empower administrator has told me it can't be done.

How is an Export method set up?

[bartjoosen]

I'm not at my office for the moment (it's weekend ), but I will give it a try.

There are a few options: go to browse project, in your project, right-click, new method > export method.
From here, you can add anything you need: the complete raw data, only the areas and amounts of a table (you can setup this table in the dialog box).

If you work with tables, you can choose which character is the column separator, and which is the line feed. If I remember correctly, you have to use [cr][lf] as line end, but not sure of this.


Good luck, and if it doesn't turn out as you would, please let me know

Bart

[DR]

Possible shortcut: If you are in a Preview/Publisher print-preview screen, right click on a table or page of interest, copy it to the clipboard, paste it in excel. It is not perfect, but it's pretty close.

Also - you should be able to save as a pdf from print preview. Cutting and pasting from the PDF can be a real chore as data from complicated tables tends to fall into the first column instead of several columns.

re: your Emp. Admin - either you're in a highly regulated environment and you really should not be using Excel to report stuff or s/he needs further instruction.

[bartjoosen]

Possible shortcut: If you are in a Preview/Publisher print-preview screen, right click on a table or page of interest, copy it to the clipboard, paste it in excel. It is not perfect, but it's pretty close.

That's right, it's a bit faster, but if you have multipage tables, you have to copy paste more than once.
Also, as you say it isn't perfect, sometimes some rows are ended not right, for example: 3 columns: Sample name, Area, Amount, and at a certain row, you have Sample name, and then the next line Amount and area.

For this reason I mostly choose to use the export method, but when I have small data tables, and it should really go fast, I sometimes use the copy paste method (which also works for chroms btw).

But as DR stated, maybe there is a reason your admin doesn't allow you to export to excel: regulatory issues. Please keep this in mind.

Bart

[AdrianF]

Many thanks for your help. I can use copy and paste from Preview Publisher.

The export method is not available in our set up however the administrator hadn't said it shouldn't be done but it couldn't be done.

We are in a regulated environment but some results need to to be transferred to Excel to produce reports not available in Empower eg dissolution traces and Ita summaries. Of coursethe original reports are available as well to check the inputs.

[abell1234]

I agree with 'bartjoosen' and 'AdrianF'on this matter of exporting results to excel (regulatory issues). Im abit confused why you want to export to excel. I am very much a beginner with using Empower (our lab is in the process of installing Empower 2) but to me exporting data is another step that should not be required(all done on CDS). I am also surprised that Empower cannot create dissolution profiles. Can anybody out there explain this?The majority of my CDS experience is using Chromeleon (Ver 6.2 -6. and it would be great to know what Empower 2 can do (or cannot do!!) versus Chromeleon CDS package. (or indeed have we choosen Empower 2 in error!!)
Thanks in advance for your help !

[DR]

Empower can do dissolution profiles, provided the option was purchased.

[Dan]

Abell1234,

The answer to your question about the dissolution profile results is that those results (as provided by Empower or any CDS) must be corrected for volume withdrawn and not replaced and amount of API withdrawn at previous time points. These calculations can be complicated and cannot be done by any CDS (at least I have not found one that can do it). These calculations can be done by Excel (which can also then plot the results in a chart). You can read about these correction equations on the forum for the Dissolution Discussion Group:

http://www.dissolution.com/vbulletin/sh ... d.php?t=16

To all,

I also agree with the comments about the regulatory issues involved. If you are in the regulated area, then you would need to validate the export function in the CDS and validate the spreadsheet itself. Alternatively, you can go through the manual review of the data transfer for the export and the review of the spreadsheet calculations each time those procedures are performed. There was a discussion thread about the validation of spreadsheets on this forum:

http://www.sepsci.com/chromforum/viewtopic.php?t=7819

Regards,
Dan

[Dan]

DR,

Thanks for the information. I was preparing my post when yours came through. I did not know that Empower had that option; it's good to know (and have that ability).

Regards,
Dan

[bartjoosen]

I haven't tried it yet, but can't the dissolution profiles be calculated with the use of intersample calculations and custom fields? I think it should be possible (without purchasing the dissolution option).
Other possibility is to use the Empower Toolkit, to select your results, and import the right data in excel through a VBA script.


@AdrianF:
You admin can give you acces to the export methods if he wants (Config mgr> user types> methods > Save export methods)
So if you haven't this access, he does't want you to give the access.

Bart

[abell1234]

Hi All,
From my past experience using Chromeleon, dissolution calculations (volume ,mass and volume and replacement) can easily be performed using 'Dymanic calculation' and ,as the reports are Excel based the calculation (link as supplied by Dan ) can then be added along with dissolution profiles by administrator ,then report locked for compliance. (again no reason to export to Empower). Im assuming these 'add ons' are available in Empower 2?
Also is anybody out there using Empower 2 as a total peperless system (ERES)? Any pros and cons on this CDS would be much appreciated

Thanks in advance

Andy

[AdrianF]

Input to exceel will be manually checked againt the results in Empower tables.

It is more accurate to copy and paste than to manually transcribe into Excel. We don't do this routinely so it is not worth too much effort.

[DR]

Right-click, copy, paste into excel, delete extraneous rows - is probably the best for you, then.