[Di...] Posted October 7, 2019 Share Posted October 7, 2019 need to export data to excel format with nominal and deviation from nominal. Please guide me. Link to comment Share on other sites More sharing options...
[Ma...] Posted October 8, 2019 Share Posted October 8, 2019 Dilip Here is an explanation of how to export to excel Mark Link to comment Share on other sites More sharing options...
[Ph...] Posted October 13, 2019 Share Posted October 13, 2019 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, PhuongCapture.PNG Link to comment Share on other sites More sharing options...
[Ma...] Posted November 7, 2019 Share Posted November 7, 2019 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 Link to comment Share on other sites More sharing options...
[Is...] Posted November 8, 2019 Share Posted November 8, 2019 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... Link to comment Share on other sites More sharing options...
[Ph...] Posted November 14, 2019 Share Posted November 14, 2019 Thank you, Israel. I have never done anything with macro before. But I will try it out. Best regards, Phuong Nguyen Link to comment Share on other sites More sharing options...
[Ph...] Posted November 14, 2019 Share Posted November 14, 2019 Thank you, Mark. Best regards, Phuong Nguyen Link to comment Share on other sites More sharing options...
[Ph...] Posted November 14, 2019 Share Posted November 14, 2019 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 Link to comment Share on other sites More sharing options...
[Ra...] Posted November 20, 2019 Share Posted November 20, 2019 Hallo, ich benutze diesen Sammelreport um mehrere Excel-Dateien zusammenzuführen. Gruß RalphVorlage_Calypso_ Excel Sammelreport1.xlsx Link to comment Share on other sites More sharing options...
[Ph...] Posted November 20, 2019 Share Posted November 20, 2019 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 NguyenExcel sample_Calypso.PNG Link to comment Share on other sites More sharing options...
[Ra...] Posted November 27, 2019 Share Posted November 27, 2019 Hallo, anbei ein Auswertungsbeispiel. Die Vorlage ist individuell anpassbar. Gruß RalphAnleitung.pdfExcel-Sammelreport-Auswertungsbeispiel.xls Link to comment Share on other sites More sharing options...
[Kl...] Posted December 6, 2019 Share Posted December 6, 2019 For sample Jobs I use the attached template (zip), its flexible by runs and characteristicsSample_20_A4h_manual_selection.pdfSample_20_A4h.pdfSample_20_A4h.zip Link to comment Share on other sites More sharing options...
[Sa...] Posted 17 hours ago Share Posted 17 hours ago 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in