EXCEL

[[Di...]]

need to export data to excel format with nominal and deviation from nominal.
Please guide me.

[[Ma...]]

Dilip

Here is an explanation of how to export to excel

Mark

[[Ph...]]

Hello Mark,

Thank you for the guide.
Is there any way for us to export data into Excel with multiple measurements?
Something like if I run 10 samples, I want the Excel report shows measurement data of those 10 samples at a time on a same page.
Please see the attached screenshot.

Thank you,
Phuong

Capture.PNG

[[Ma...]]

Sorry just saw this.

Yes there is a way but you would have to write something in PCM to export the data or get PiWeb Reporting.

Mark

[[Is...]]

Please sign in to view this quote.

We do it with excel macro, you can extract the values from the Compact print out or the Default print out...

[[Ph...]]

Thank you, Israel. I have never done anything with macro before. But I will try it out.

Best regards,
Phuong Nguyen

[[Ph...]]

Thank you, Mark.

Best regards,
Phuong Nguyen

[[Ph...]]

Hi Mark/Israel,

If it is possible, could you please show me how to get more than 12 measurements showing on PiWeb table template, and those data will be automatically generated on following pages?

Best regards,
Phuong Nguyen

[[Ra...]]

Hallo,
ich benutze diesen Sammelreport um mehrere Excel-Dateien zusammenzuführen.
Gruß Ralph

Vorlage_Calypso_ Excel Sammelreport1.xlsx

[[Ph...]]

Hello Ralph,

Thank you very much for your excel template. It's very helpful for my work.
Also, do you have any template looks like the one I attached below? Or do you have any manual guide regarding how to create a template like that?

Best Regards,
Phuong Nguyen

Excel sample_Calypso.PNG

[[Ra...]]

Hallo,
anbei ein Auswertungsbeispiel. Die Vorlage ist individuell anpassbar.
Gruß Ralph

Anleitung.pdfExcel-Sammelreport-Auswertungsbeispiel.xls

[[Kl...]]

For sample Jobs I use the attached template (zip), its flexible by runs and characteristics

Sample_20_A4h_manual_selection.pdfSample_20_A4h.pdfSample_20_A4h.zip

[[Sa...]]

I know I am late to this thread, but it is something I struggled through recently. The issue I had was finding a built-in mechanism to allow for multiple measurements across multiple characteristics.

The solution I found was using a characteristic table and defining the measured values in each column with descending measurement references. (see image for example callouts)

It takes some time to setup, but the only limit is the number of columns you have.... I have found around 100 sample columns is the max our system can go without lag.

[[Jo...]]

You can use a "Table File" which will add a new row for each measurement.  (You must enable table files and click the button to initialize the table file before it will work)