Shift Calculator
Shift Calculator
Shift Pay Calculator (Excel-Driven Payroll Tool) This project is a custom-built web application designed to replicate real-world payroll tracking using structured Excel data. The tool allows users to upload a payroll schedule and automatically calculates earnings based on shifts worked within each pay period. Unlike basic calculators, this system is fully driven by the uploaded spreadsheet. Each pay period is defined by its “From” date, ensuring that period transitions match the original document exactly. When a new pay period begins, the application automatically resets previous earnings, mirroring how real payroll cycles operate. Key features include automatic period detection, local data persistence for pay schedules, and a clean, mobile-friendly interface. The application also calculates deductions such as pension contributions and provides a clear net pay figure for each session. The result is a lightweight but powerful payroll tool that removes manual tracking and aligns precisely with real rota and payslip structures.
Overview
Upload your payroll spreadsheet and automatically extract pay periods and dates.
Data is saved locally so you don’t need to re-upload files.
The system detects current and upcoming pay periods automatically.
Calculate earnings based on the number of shifts worked, with support for custom rates.
How It Works
Upload your Excel file containing pay periods, cut-off dates, and paydays.
The system reads and processes your data to identify relevant pay periods.
Your data is stored securely on your device for future use.
Enter the number of shifts worked to estimate your upcoming pay.