Training matrix software

Training matrix software that keeps itself up to date

Appello's training matrix shows every worker and every ticket on one screen, coloured Active, Expiring Soon, Expired or Missing, straight from your certification records. It's live today for insulation, mechanical, HVAC, plumbing, sheet metal, electrical, concrete and other ICI trade contractors, with nothing to retype.

Before · tickets_matrix_FINAL_v7.xlsxLast edited 7 months ago
NameWHMISWAHConf. SpaceAWPFirst Aid
J. Alvarez20272028?20272028
D. Nguyen202720292026-08-30Oct?2028
S. Okafor2027see email2026-09—
R. Singh20272026202720282028
M. Tremblay2027Oct 202620272028
  • · Years, not dates. Question marks where someone wasn't sure.
  • · Updated when someone remembers, by whoever has it open.
  • · The card itself is in a wallet, a truck or an inbox.
After · Employee Training MatrixReport Date: Thu September 10, 2026
  • · Built from the certification records, every time it opens.
  • · A renewal added from a phone shows up the next time anyone looks.
  • · Export CSV with your filters applied.

The spreadsheet is an illustration. App screens use a fictional sample company.

Try it: the same filters as the real report

Pick Confined Space to see who can go into a vessel today. Pick Expiring Soon to get this month's renewal list. Search a name for one worker's row.

Expire Status
Employee Training Matrix, report date Thursday September 10, 2026
NamePositionWHMISWorking at HeightsConfined SpaceAerial Work PlatformFirst Aid CPR
J. AlvarezJourneyperson●●●●●
A. BouchardLead●●●○○
L. FerreiraProject Manager●○○○●
K. FitzgeraldForeman●●●●●
M. FraserPurchasing●○○○▲
T. LaroseLead●●●●●
L. MoreauSuperintendent●●●○●
D. NguyenJourneyperson●●✕!●
S. OkaforApprentice●●!●○
R. SinghJourneyperson●!●●●
M. TremblayForeman●!●●●
P. WilsonJourneyperson●●●●●
Active12 / 100.00%8 / 66.67%8 / 66.67%7 / 58.33%9 / 75.00%
Expiring Soon0 / 0.00%2 / 16.67%1 / 8.33%1 / 8.33%0 / 0.00%
Expired0 / 0.00%0 / 0.00%1 / 8.33%0 / 0.00%0 / 0.00%
Missing0 / 0.00%2 / 16.67%2 / 16.67%4 / 33.33%3 / 25.00%

● Active! Expiring Soon✕ Expired▲ Missing - Required○ Not on fileTotals always count all twelve workers, as the report does.

A working copy of the sample matrix above. Fictional workers.

Read it in ten seconds

Across the bottom first. Each ticket's column ends with four counts. Working at Heights: 8 active, 2 expiring soon, 0 expired, 2 missing. That's your renewal workload for the course.

Then the colours. Amber cells are the calls to make this month: R. Singh and M. Tremblay for Working at Heights, S. Okafor for Confined Space, D. Nguyen for Aerial Work Platform. Red is already late: D. Nguyen's Confined Space.

Then the warning triangles. M. Fraser needs First Aid CPR and doesn't have it. Grey isn't a problem; it means the worker doesn't hold that ticket, and Show only required certifications hides it.

2 expiring soonTotals per ticket

Training reports

Three views of the same records

The matrix is one of three training reports in Appello's Reports area. They read the same certification records, so they never disagree. Pick the one that fits the question.

Appello training reports compared
ReportAnswers forWhat it showsExport
Employee Training MatrixEveryone at onceWorkers down, certification types across, each cell coloured by status, with totals and percentages per ticket.CSV
Certification Status ReportOne ticket type at a timeTickets grouped by type with status, certified date, expiry, days left and training provider. Filter by Active, Expiring Soon, Expired or Missing - Required.CSV · PDF
Employee Training ReportOne workerEvery certificate a worker holds, with type, date certified, expiry, days left and status.CSV · PDF

The Certification Status Report is the one most offices open on Monday, filtered to Expiring Soon and Expired; see Expiring Soon. The matrix is the one that goes to a GC or an auditor. All three sit alongside payroll, job cost and safety reports in Reporting & Dashboards.

The matrix, in a sentence

Through the Appello connector, Claude, ChatGPT, Microsoft Copilot and Grok read the same certification records, limited to your Appello role. Useful when you're on site and the question is about tomorrow's crew, not the whole company.

  1. 1“Show the training matrix for everyone scheduled at Lakeshore General tomorrow.”get_schedule_for_date · search_user_certifications
  2. 2“Which certs is the Huron Generating crew missing for the outage?”get_schedule_for_date · get_user_certification_status
  3. 3“How many of our people hold a current Confined Space ticket?”search_user_certifications
  4. 4“List every Expiring Soon ticket by training provider, so I can book courses in batches.”get_user_certification_status · search_training_providers

9,890

certifications tracked in Appello, each one a cell in someone's matrix

Counted across every Appello customer account on 2 September 2026.

Questions about the training matrix

What is a training matrix?

A grid with your people down the side and the tickets they need across the top, so you can see at a glance who holds what and what's about to lapse. In Appello it's the Employee Training Matrix report: every worker's position and start date, every certification type, and each cell coloured by status, with totals at the bottom.

How is this different from a spreadsheet template?

A spreadsheet matrix is only as current as the last person who updated it. Appello's matrix is a report on the certification records themselves, so when a worker adds a renewed card from their phone or the office records a new ticket, the matrix changes the next time anyone opens it. There's nothing to maintain and no version to email around.

What do the colours mean?

Green is Active. Amber is Expiring Soon, meaning inside the warning window set for that ticket type. Red with a cross is Expired. A red warning marks a ticket that's required for that worker and missing. Grey means the worker doesn't hold that ticket. The bottom rows count each status per certification, with a percentage.

Can I filter it to one ticket or one worker?

Yes. Filter by employee, by certification and by expire status, and switch on Show only required certifications to hide tickets a worker doesn't need. Pick Confined Space and Expiring Soon, and you have this month's renewal list for that course in two clicks.

Can I export the matrix?

Yes. Export CSV from the top of the report, with your filters applied. Most safety coordinators send it to a GC or an auditor, or keep a dated copy for the safety file. For one worker's full record, the Employee Training Report exports to CSV or PDF.

Can I see the matrix for just the crew on one job?

Not as a job filter on the matrix itself. Filter it by the employees you're sending, or use the daily schedule, which shows a certification compliance check for each scheduled worker with their required tickets and status. Through the Appello connector you can also ask your AI for the tickets of everyone scheduled on a job.

Who can see the training matrix?

People whose Appello role includes training reports, usually the safety coordinator, office and managers. Workers see their own tickets in the mobile app, not everyone's. The same role limits apply when someone asks an AI assistant for the matrix through the Appello connector.