FCM Timesheet is a work-management and timesheet system I designed and built for a civil and mining company, to replace the Excel spreadsheets they were using to run their day-to-day operations. I designed it in Figma, then built it across 2024 and 2025.
The business runs off two key documents that were previously kept in Excel: a daysheet and a supervisor timesheet. The daysheet pulls the list of jobs out of SAP (their enterprise work-management platform), and from there they assign workers to each job, estimate hours, and record things like overtime and higher/lower duties. The supervisor timesheet builds on the daysheet but is more granular, capturing specific hours, leave, and so on.
The system covers:
- User management
- Core data management the system needed – leave types and employee leave, employee qualifications, and vehicle and equipment management
- The daysheet, with drag-and-drop of workers, equipment and jobs onto it
- CSV and Excel import of jobs from SAP
- The supervisor timesheet – a fast, Excel-like grid for entering time across many columns
It was built with Ruby on Rails, Docker, PostgreSQL and GraphQL on the backend, and React and Tailwind on the frontend, deployed to DigitalOcean with GitHub Actions handling CI and deployment.