Shiftmate
Monthly shift plan health check
Scan for risks of overlap, 45 hours, long shift and short rest in CSV or Excel shift file.
Prepared by:Shiftmate Product and Operations Team · Son kontrol:
Step by step usage
Enter actual period data
Replace the sample values with your own business's data for the same date range and the same unit of measure.
Read the result and assumptions together
The loaded CSV or Excel rows are sorted by running and date in the browser. The tool generates operational alerts for invalid registration, time conflict, shift longer than 12 hours, rest less than 11 hours, and a total of more than 45 hours per week. Examine the result not just as a single number but for its sensitivity to change in inputs.
Save the scenario and measure again
Once you make a decision, write down the input and the date. Correct the invalid dates and times first. Standardize the same employee's writing style. Verify the warning with the employee contract and expert opinion.
What does this tool calculate?
Scan for risks of overlap, 45 hours, long shift and short rest in CSV or Excel shift file.
formula
Controls = overlap + long shift + short rest + weekly hours threshold
Calculation method
The loaded CSV or Excel rows are sorted by running and date in the browser. The tool generates operational alerts for invalid registration, time conflict, shift longer than 12 hours, rest less than 11 hours, and a total of more than 45 hours per week.
Worked example
7-day file for an employee. 49 hours total. 8 hours between two shifts. Result: Weekly threshold and short rest are exported as separate alerts; the administrator finds the source rows directly.
How should the result be interpreted?
Correct the invalid dates and times first. Standardize the same employee's writing style. Verify warning with employee agreement and expert opinion
Common usage mistakes
Dividing the same employee with a name-surname spelling difference. Using free text instead of date-time. Writing CSV headers differently from the example
Limits of the model
Screening is not a certification of legal compliance and does not cover all industry, contract or specific employee exceptions.
Is your data safe?
Calculation and file analysis runs in your browser. The operation files you upload are not sent to a server by this tool.
Relevant official and technical resources
Frequently asked questions
Is the file uploaded to the server?
Analysis runs in the browser; The lines of the file you select are not sent to a server by the tool.
What titles are required?
Base on the sample file in the tool and retain the employee, date, start and end headers.