Tools / Roster & reporting
Trainer OT Tracker
From an authorised roster to an overtime report—without the manual download step.
Internal desktop toolWhat it does
Trainer OT Tracker is maintained by Darryl Wang for authorised internal operations use. It runs on the operator's computer, exports a configured native Google Sheet as an Excel workbook, and applies the existing roster-based overtime rules to produce a monthly report.
The output includes the roster worksheets and an overtime summary. It must be reviewed in Excel before payroll use. This is not a public payroll service, and no tracker download or account sign-in is offered on this website.
How the workflow runs
- Authorise access. On the computer running the tracker, the operator signs in to a Google account already permitted to read and export the roster.
- Read and process locally. The tracker exports the configured spreadsheet through Google Drive API and processes the workbook in memory.
- Save and review. It saves an Excel report locally. The operator reviews hours, classifications and calculated amounts.
About the Google permission
The app requests drive.readonly. This permits reading and downloading all files visible to the signed-in account, not just the roster. The current code targets the configured spreadsheet ID and does not edit, delete or upload files to Google Drive.
Existing sharing restrictions and the organisation's authorisation requirements still apply. The website does not receive your Google token or roster.
Where the data goes
The Google connection is made by the locally running tracker, not this website. Account authorisation tokens and generated reports are stored on the operator's computer. The report contains staff-related roster and overtime information and must be stored privately.
Read the full privacy policySupport
For access, privacy or support questions, contact darryl.wang@activa.sg. Do not email Google credentials, tokens, complete rosters or payroll files unless an appropriate authorised channel has been agreed.