CSV Fields

NameDescription
Date
Date the sheet occurred
Datasource
Name of the Machine
Shift
Name of the Shift
Operator
Name of the Operator attached to the sheet
Part
Name of the Part attached to the sheet
Job
Text of the "Job" field entered on the sheet
Up Hours
Total uptime hours for the sheet (rounded to two decimals)
Down Hours
Total downtime hours for the sheet (rounded to two decimals)
Part Count
Total good parts
Scrap Count
Total scrap parts
Scrap %
scrap parts / (good parts + scrap parts)
Cycle Time (Ideal)
The target cycle time (currently sourced from the part definition)
Cycle Time (Actual)
uptime seconds / (good parts + scrap parts)
Cycle Time (Entered)
Cycle time attached to the tallysheet. Will match "Cycle Time (Ideal)" if no changes are made and the part has a target. Otherwise, shows the difference between the part-based target and what the operator says the cycle time "should be." Meant to account for variations by machine, etc.
Availability
uptime seconds / (uptime seconds + downtime seconds)
Performance
(entered cycle time * total_parts) / uptime seconds
Quality
good parts / (good parts + scrap parts)
OEE
availability * performance * quality
Notes
Content of the notes field from the tally sheet