Rockwell-automation FactoryTalk Metrics User Guide Uživatelský manuál stáhnout pdf (Strana 245)

Advanced Reporting Topics Chapter 7

2. Under Data Type, leave Number.

3. In the Columns list, click dRunSec.

4. Click Add Column to Expression.

5. Under SQL Expression..., edit the expression as follows:

User.OEEQWorkCell.dRunSec/60

6. Click Validate to check for errors.

If there are no errors, the Validate button becomes inactive.

7. Click Add.

The Column Selection page appears.

The derived field is displayed under Columns in Report

Data Source.

8. Repeat the steps 1-7 to create the following derived fields:

Field name ActualCycleTime

Data type

Number

Add these columns to the expression

•

dTotalParts

• dRunSec

Complete SQL expression

CASE WHEN

User.OEEQWorkCell.dTotalParts=0 THEN 0

ELSE

User.OEEQWorkCell.dRunSec/User.OEEQWorkCell.dTotalParts

END

Notes ActualCycleTime is the number of seconds in which one part was made. The actual cycle

time will only be measured when the workcell is running, and both good and scrap parts

are counted. The actual cycle time will be compared to the ideal cycle time. The

ActualCycleTime formula is as follows: dRunSec/dTotalParts

When creating the ActualCycleTime field, use a CASE statement to exclude records where

dTotalParts equal zero.

Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014 245

1 2 ... 240 241 242 243 244 245 246 247 248 249 250 ... 271 272

Žádné komentáře

Rockwell-automation FactoryTalk Metrics User Guide Uživatelský manuál Strana 245