Control Charts

[[Mo...]]

We Currently use QC Calc and looking at alternatives. Can the standard PiWeb that comes with Calypso 8 replace QC Calc?

I need to see control charts, would like to share results as an excel file with engineers, and would like to send automatic notifications when a part is out of tolerance.

[[Ri...]]

Absolutely!

These are the standard reports that come with PiWeb, but you can custom tailor one to whatever your wildest dreams might be. 

 

 

 

PiWeb > everything else. Data management and reporting is unmatched. 

Edited October 22

[[Do...]]

Hi Monika,

PiWeb can provide control charts and export measurement results as CSV files for further processing in Excel. These functions are available with PiWeb Reporting Plus and PiWeb Essential.

However, automatic notifications when a part is out of tolerance require PiWeb Enterprise. Therefore, the standard PiWeb version included with CALYPSO 8 would not cover all the listed requirements.

[[Mo...]]

Please sign in to view this quote.

I can export into Excel for each individual part. 1 part, 1 excel file.

What I need to do is figure out how to save all the parts ran with the same program into the same excel file. Each part with it's own row, and headers.

Can someone help me figure it out? I do not have pcm, and I'm not allowed to run python scripts on the computer. How do I do this with just PiWeb Reporting Plus?

 

 

[[Mo...]]

Please sign in to view this quote.

I tried the TrenProtocol, and it is close to what I need, but engineers would like to see the raw data as an excel or csv file.

I can export into Excel for each individual part. 1 part, 1 excel file.

What I need to do is figure out how to save all the parts ran with the same program into the same excel file. Each part with it's own row, and headers.

Can someone help me figure it out? I do not have pcm, and I'm not allowed to run python scripts on the computer. How do I do this with just PiWeb Reporting Plus?

[[Ri...]]

Please follow these steps:

 

1. Open PiWeb Reporting Plus
2. 
3. Inside of PiWeb Reporting Plus, the Columns on the Left Hand side are your measurement plans. You can scroll to find the one you are looking for, or you can search for it in the top left window.
   1. Please scroll down and find the measurement plan you are looking for – select it.
4. 
5. Right click on the measurement plan, and select Show measurements.
   1. 
6. When the Edit measurements dialogue opens, either select all the data (as shown) or shift click the particular data set you are looking for (you will see time stamps)
   1. 
7. Once your data set is selected, click on the measured values button as shown below.
   1. 
8. When the Measured value dialogue is open, first make sure “Show measurement attributes” and “Show characteristic attributes” are turned on – this is a one time thing, so the next time you select data they will already be turned on.
   1. 
9. Click on the Export measured value table button as shown below. It will prompt you asking where you want to save the data.
   1. 

 

You will need to know how to use PivotTables inside of Excel. Let me know of any issues or concerns.

[[Ri...]]

You can also do this by modifying a report, but it is limited on what header fields get saved into the output. 

https://portal.zeiss.com/knowledge-base?id=513250