How to Export Data Collected from Tallysheets
Watch 3.5 minute video 👇
CSV Output Explained
Below outlines the fields in the CSV and what they correspond to:
Name | Description |
|---|---|
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 |
Work Order | Text of the "Work Order" 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 |