Shift report
from a CSV file.
Import data for one or more shifts. Review five operational KPIs, select a priority and download a concise shift brief.
Import and settings
CSV column definitions
- CSV
- A tabular file: the first row contains column names and the following rows contain area-level data. Separate fields with semicolons or commas, as shown in the template.
- date · shift · area
- Operating date (YYYY-MM-DD), shift identifier and process area. Rows with the same date and shift are grouped into one report, also by warehouse when that column is provided.
- planned_tasks · completed_tasks
- Tasks planned and completed in the area. Use one consistent task definition in both columns.
- sla_shipments · on_time_shipments
- Shipments covered by the service window and those dispatched on time. On-time shipments must be a subset of SLA-covered shipments.
- errors
- Number of recorded errors. The KPI divides this value by completed tasks; it is not a percentage of tasks containing an error.
- processed_lines · labour_hours
- Processed order lines and total labour hours. Two people working for eight hours represent 16 labour hours.
- backlog
- Tasks remaining at the end of the shift. Do not duplicate the same backlog across several areas.
- warehouse · owner · comment
- Optional columns for site, accountable person or role, and an operational note. The warehouse column separates reports for different locations.
KPI thresholds
These are sample values. Set them in line with the definitions and service levels used in your operation.
Shift brief
Results and KPI definitions
- Shipment SLA
- Service Level Agreement performance, measured here as on-time shipments ÷ SLA-covered shipments. When the denominator is zero, the KPI remains unassessed.
- Plan attainment
- Completed tasks ÷ planned tasks. The area table presents this result separately for each process area.
- Error rate
- Recorded errors ÷ completed tasks. One task may contain more than one error.
- Backlog
- Total outstanding tasks across all rows in the selected shift, displayed as a count rather than a percentage.
- Productivity
- Processed lines ÷ labour hours, expressed as lines per labour hour.
- Minimum / maximum
- The threshold configured on the left. Outside threshold means below the minimum or above the maximum. The user selects the priority and action.
- TXT brief
- The downloaded text file contains the KPIs, selected priority, action and operational comments from the CSV.
After import, you will see the deviations, area comments and a shift brief ready to download.
Priority and action
Areas and comments
| Area | Plan attainment | Backlog | Owner | CSV comment |
|---|
We can build a tool around your process.
Do you use different KPI definitions, thresholds, shift structures, multiple sites or a different source-file layout? We can build a tool that imports your CSV/XLSX file, validates the data, calculates the required KPIs and produces a report in your format.
If your team combines files, repairs formulas or rebuilds the same report every week, you probably do not need another spreadsheet — you need a repeatable tool built around the process.
- CSV/XLSX import and analysis
- Data validation and business rules
- Calculators and prioritisation
- Dashboards and operational reports
- PDF/CSV exports
- Prototype or private browser version
How should the result be interpreted?
Shift KPIs are calculated from the totals across its area rows. If areas use different task definitions, interpret overall plan attainment together with the individual area results.
A threshold deviation does not establish a root cause. Validate both the source data and the operating process before assigning an action.