Evaluating Data
You have a number of filter options to extract the desired data.
The filter options and the meaning of the report columns are described in the SKR3 documentation.
Overview of Reports
Evaluating Data
- You have setup the ODBC interface successfully, have added machines to the SKR management and operated them for some time. Now, you want to evaluate the data.
- You have installed Excel, version 2007 or higher and started the Excel program under D:\PPS\ODBC_Examples\Excel\StollReportFromSkrToExcel.xlsb.
- 1
- In the field enter the data source, which you have set up for the 32 bit application.
Even if you have installed the 64Bit version of Excel, you must use the 32 Bit ODBC connection for the Excel report.
- 2
- Enter an appropriate evaluation time period under Start Date/time and End Date/Time.
- 3
- Click on Update Machine Selection List.
- The Selected Machines list now contains all machines managed by the SKR3.
The status field displays a green color bar and the text: Successfully retrieved McList. - 4
- Select the machines, whose data you want to evaluate.
Multiple selection
Click with the Ctrl key pressed.
Click the first desired machine and with the Shift key pressed click on the last machines to select a range of machines.
- 5
- Click on the orange arrow Create Secondary Database.
- In the status bar on the bottom left you see a progress bar running upward and at the and in the status field appears: Successfully generated secondary DB. Now you can evaluate the collected data via one of the 4 report functions, which you can find in the tab bar at the bottom.
- You can access four different reports:
-
Event List
List of events with all operations recorded by the SKR software -
Production Report
Evaluation of production data - When was knitted which order?
- How long did it take to knit which order?
- Pattern Statistic
- How many pieces were produced completely?
- How much time did it take on average?
- Stop Statistic
- Down times sorted by cause
- Stop History
- Down times sorted by cause in percent and absolute
- Efficiency with and without power-on state
- Efficiency Report
- Down times sorted by cause
- Efficiency with and without power-on state
- Operator, productive, unproductive times
- Operator, efficiency by percentage
- Expected Pieces Report
- You can group the expected quantity according to machine, knitting program, sequence, production ID, customer ID, article number, day, week, month and year
- For this evaluation, the auxiliary database (SecDB) does not need to be created
- Yarn Demand Report
- Determine the yarn demand for a production. The knitting program of the order must have metadata provided by the pattern workstation.
- You can group the report according to time and machine name, pattern, sequence, production ID, customer ID, article number
- For this evaluation, the auxiliary database (SecDB) does not need to be created
- 24h Efficiency Report
- Efficiency evaluation over the last 24 hours for each machine individually or averaged over all machines.
- The evaluation can optionally include times when the machines were switched off.
- For this evaluation, the auxiliary database (SecDB) does not need to be created
- 6
- Switch from the tab at the bottom to one of the reports and click on Generate <Name of the Report>.
- Under the grey parameter block is displayed a table with the data of you machines. A maximum of 140 rows of the data are shown.
- 7
- Via the field you can have listed the next 140 rows.
- 8
- Each tab has a field at right that displays the executed SQL commands. This will help you to create programs by yourself with these SQL commands.
You have a number of filter options to extract the desired data.
The filter options and the meaning of the report columns are described in the SKR3 documentation. Event definitions