You can export readings for various jobs to Excel. Use this facility for Data Analysis based on the Excel Sheets.
Where jobs have more than one parameter, each parameter is displayed on a separate sheet. Both Variable and Attributive parameter details can be exported.
The data displayed in Excel is all the data related to the job along with all calculated data.
For Variable parameters, the following details are displayed:
From Date, To Date, From Time, To Time, Work Order Number and Date, Part, Process, Parameter, Machine Number, UsL, LsL, UcLx, LcLx, UcLr, LcLr, Nominal Value, Sample Size, Cp, Cpk, Pp, Ppk, S Sqrt, S Rbar/d2, X Double bar, R bar, Number Of Readings, Sample Number, Reading Serial Number, Reading Date, Reading Time, Readings.
For Attributive parameters, the following details are displayed:
From Date, To Date, From Time, To Time, Work Order Number and Date, Part, Process, Parameter, Machine Number, UcL, LcL, Number Of Readings, Subgroup Size, PBar, UBar, NpBar, Cbar, Reading Serial Number, Reading Time, Readings.
For jobs which have not been closed, select a job from the Local Monitoring or Global Monitoring screen. Click File|Export to Excel from the Main Menu. The Export to Excel screen is displayed.
You may enter Date and Time ranges. If multiple jobs exist, the Job Selections screen is displayed.
Select a job and click OK to launch the readings worksheet in Excel.
For jobs which have been closed, click Reports-History|Export to Excel from the Reports Menu. The History Summary Report screen is displayed.
Enter the required selection criteria. If multiple jobs exist, the Job Selections screen is displayed.
Select a job and click OK to launch the readings worksheet in Excel.
If you wish to save the worksheet, you must manually save it using the File|Save option in Excel.