Import data from Excel

You can import reading data from an excel file and provide the facility for the statistical analysis using the tools provided by PROQMS.

The screen also provides a facility to select parameter details to create QAPs, Jobs and calculate Cp, Cpk, Pp, and Ppk at the background.

Click on File -> Import Data menu item. A screen for accepting data required for the Import will be launched.

Select Parameter code and Parameter Type. The user has to select the Parameter Type – Attributive or Variable. Depending on the Parameter type the user has to define/select certain properties of variable or attributive parameters and the charts.

If Variable type is selected then the Variable properties of the parameter will be enabled for the user to select or

enter-

- Decimal - By default the decimal place will be set to 4. The decimal places should be from 0 to 5 only.

- UOM - By default the UOM will be set to MM

- Tolerance - Tolerance is set to Both side by default. The user can change it to Upper side also.

- The user has to specify the LSL, USL and Nominal values. If Upper option is selected then LSL will be disabled. The value of LSL will be 0.

- Nominal Value - The Nominal value should be less than or equal to USL. In case of Both Sided option, USL should be always greater than or equal to LSL. Nominal value should be between LSL and USL.

- Inspection Technique - By default the Inspection Technique will be set to Sampling. The user can change it to 100% Inspection mode also.

In case of Sampling, Sample size will be enabled and it will accept value greater than 1. User cannot enter 0 for Sample Size. The sample size is set to 5 by default .If Sample Size is greater than 25 then it is acceptable only if Sample Size mod 5 = 0.

If 100% inspection option is selected then Moving Range Size will be enabled in place of Sample Size. For 100% Inspection, the Moving Range Size can be 2,3 or 4.Bydefault the Moving range will be set to 3.

- Charts - For variable type of parameter, X Bar R Chart, X Bar S Chart, Histogram, X Chart, X-MR chart and Median Chart can be selected. If 100% Inspection under Inspection technique has been selected then X Bar S chart under chart tab will be disabled and deselected and only Histogram will be selected by default. If Sample Size is greater than 10 then Median chart option will be disabled and deselected. If Sampling is selected then by default the Histogram and X bar R chart are shown selected.

If Attributive option is selected then the Attributive properties of the parameter will be enabled for the user to

select or enter –

Subgroup Size

Charts -

For Attributive type of parameter, P chart, Np chart, U chart and C chart can be selected. If subgroup size is greater than 0 then all charts P, Np, U and C are enabled. If user selects P chart or Np chart then U and C chart are disabled. Similarly, if U chart or C chart is selected then P and Np chart are disabled.

If Subgroup Size is 0 then P Chart and U Chart options are enabled, Np and C chart are disabled. If the user selects P chart then U chart is disabled and if U chart is selected then P chart is disabled.

Select the Excel file from where the reading data wants to import. Click on the "…" button provided to open a file dialog box. Select an .xls file. After the file is selected, the user can either specify the range of data to be selected or select print Area.

After selecting the file and specifying the range Click on Import button, if no errors then display the ‘Data successfully imported in Job Date and Current time’ and display the Import Monitoring screen. User can select the job and try to launch the measurement screen to see the chart details.

Part COde,Process Code,Parameter Code, Machine No. and Job date fields are provided for the user selection. If user selects Part,Process and Parameter which is exist in Qap then software display the message 'Duplicate QAP' and populate the respective controls from the the existing QAP.