Skip to content
AtheronLABS

You're visiting from the United States. Prices are shown in US dollars. Not right?

labs@atheron:~/industries/security-services/rescue$ recover --codebase --modernise

Scheduling rescue

Off the macro spreadsheet, without losing a shift.

Many guard companies run on a spreadsheet only one person truly understands. We read how it works, move its data across, and replace it with a scheduling app your whole office can use, running side by side until you are ready to switch.

// what matters here

What is different in this industry.

01

We learn the old one first

We read the spreadsheet's rules and macros, and write them down with you before anything changes.

02

Side by side

The new schedule runs beside the old one for a period you choose, so no shift is missed in the switch.

03

Licences tracked

Expiry dates for licences, first aid and site training, with warnings before they lapse.

04

Hours to payroll

Approved hours sent to your payroll system, not retyped.

// example projects

Priced examples for this service.

Each one is hypothetical, labelled as such, and priced live from our rate card. Open any of them in the estimator and make it yours.

Example projectWeb app

Scheduling with licence tracking

Hypothetical. Not a client, not a result.

// The problem

A security firm builds its schedule in an old spreadsheet full of macros that one person understands, and finds out a guard's licence has lapsed only when a client asks.

// What we would build

We replace the spreadsheet with a scheduling app that fills posts from qualified guards, tracks licence, first aid and site training expiry dates, warns before anything lapses, and sends approved hours to payroll. Licence rules come from your compliance lead.

// What is in it

  • Posts and shifts filled only from guards qualified for the site
  • Licence, first aid and site training expiry tracked with warnings
  • Shift offers and swaps by text message
  • Approved hours sent to payroll
  • The old spreadsheet's data moved across and checked with you

// Stack

  • Next.js
  • PostgreSQL
  • Twilio
  • Payroll API
  • DigitalOcean Toronto

// estimate

Build
≈ US$59,300 to US$90,700, delivered within 16 weeksCAD 84,500 to 129,200
Hosting
≈ US$176 a monthCAD 250 a month
Support
≈ US$2,500 a monthCAD 3,565 a month

Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.

Timeline by milestone

Discovery
2.9 to 3.4 weeks
Design approved
2.9 to 4.9 weeks
Core features
1.9 to 3.4 weeks
Full build
1.4 to 2.4 weeks
Testing and fixes
0.9 to 1.4 weeks
Launch
0.9 to 1.4 weeks

How it is paid

Deposit 20%
CAD 16,900 to 25,840
Discovery 7.7%
CAD 6,506.50 to 9,948.40
Design approved 7.7%
CAD 6,506.50 to 9,948.40
Core features 23.3%
CAD 19,688.50 to 30,103.60
Full build 15.5%
CAD 13,097.50 to 20,026.00
Testing and fixes 7.7%
CAD 6,506.50 to 9,948.40
Launch 8.1%
CAD 6,844.50 to 10,465.20
Holdback, 30 days after launch (10%)
CAD 8,450 to 12,920

// questions

Questions we get about this.

What if the person who built our spreadsheet has left?

We can usually work out the rules from the spreadsheet itself, then confirm them with your office.

Do you set the licensing rules for our province?

No. Your compliance lead sets the rules; we build the tracking and warnings to match.

Can guards accept shifts from their phones?

Yes, by text message or in the browser, with no app to install.

// next

Not quite your project?

Tell us what you have in mind. We will come back to you with a range and the questions that would narrow it. Or book a call and talk it through.

Replacing a security company's spreadsheet schedule with a scheduling app | Atheron Network Labs