Skip Navigation

Spreadsheet

Training & ILUO Skills Matrix — Coverage & Key-Person Risk (Excel + Google Sheets)

An ILUO skills matrix for Excel & Google Sheets — track each operator's level on every task, see coverage at a glance, and flag key-person risk.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Four-step ILUO scale with quarter-fill icons (In training, Limited, Unsupervised, Operator)
  • Per-task coverage counts and single-point-of-failure flags
  • Turns into a prioritised cross-training plan
  • Dated, signed quarterly review log for audit evidence
  • One owned file — Excel, Google Sheets & LibreOffice, no monthly fee

You probably know who your strong people are. The trouble is that the knowledge lives in your head, it walks out the door when they do, and you find out a station has only one qualified operator the week that operator hands in their notice. The Training & ILUO Skills Matrix turns that knowledge into a board anyone can read — and flags the gaps before they become a stoppage.

What is an ILUO matrix?

An ILUO matrix — also called a skills matrix or training matrix — puts every person down one side and every task across the top, and records how far each person has got on each task using four steps: In training, Limited, Unsupervised, Operator. Each step fills another quarter of a circle, so a wall of cells reads as a heat map: dark columns are well-covered tasks, pale columns are the gaps, and a column with a single dark cell is a single point of failure. Coverage only counts once someone reaches Unsupervised — the first step where they can work the task alone.

See who can run what, at a glance

The Training Matrix tab is the board. Put your people down the side, your tasks across the top, and pick an ILUO icon for each cell from a dropdown. Every cell colours itself by level, each person’s row counts how many tasks they can run alone, and the rows below each task count coverage and flag the single points of failure — automatically. It ships pre-loaded with a fictional ten-person production line so you can see the method working before you enter your own team.

Find the key-person risk before it finds you

The Coverage & Risk tab sorts every task into No coverage, Single point of failure, or Covered, with how many people can run it, how many can train it, and a summary that counts how many tasks are at risk. Every Single on a critical task is your next cross-training job — sort by status and criticality and you have a prioritised plan without a meeting. One person who can run a task but can’t teach it is its own risk: the bench can’t grow, only shrink. The board tracks both.

Built on your real tasks — and ready for an audit

The Stations & Tasks tab documents each task, how critical coverage is, and the evidence behind a sign-off, so an Operator rating is defensible, not just a colour on a grid. The Quarterly Review Log gives you a dated, signed record of each review — the kind of evidence an audit asks to see that competence is defined, assessed, and kept current. (What your standard or auditor actually requires is theirs to set; this is the place to record and present it.)

What you get

  • A 6-tab workbook (.xlsx): Read Me, Legend & Levels, Training Matrix, Coverage & Risk, Stations & Tasks, and a Quarterly Review Log.
  • Four PDF guides: a Start Here guide, an ILUO Levels & Assessment guide, a Coverage & Key-Person-Risk guide, and a Printable Wall Chart & Legend for the wall.
  • A worked example you overwrite with your own team and tasks.

Own it, don’t rent it

A blank spreadsheet is free, but you build the whole thing yourself. A per-seat HR or LMS platform is overkill for tracking who’s signed off on what — and it locks your team’s capability data behind a monthly fee. This sits in between: a structured board you own outright, edited offline, shared however your IT policy allows. One purchase, yours forever — no seats, no subscription.

Works in Excel, Google Sheets, and LibreOffice Calc — one file that opens in all three. Your purchase licenses the file for use within your own organization — use it across your whole team; just please don’t resell or redistribute the template itself.

New to ILUO? Try the free single-station starter board first — it shows the icon system on one task before you roll out the full board.

The example team, tasks, and assessments are fictional and illustrative. This is a record-keeping and planning template, not HR, legal, safety, or compliance advice, and not a certification of anyone’s competence. ILUO is a generic, widely-used training scale; this product is not affiliated with or endorsed by any standards body.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings (unlock with provided password)

In the download

This digital product is delivered as a zip file containing the following items:

  • 6-tab workbook (.xlsx): Read Me, Legend & Levels, Training Matrix, Coverage & Risk, Stations & Tasks, Quarterly Review Log
  • Start Here guide (PDF)
  • ILUO Levels & Assessment guide (PDF)
  • Coverage & Key-Person-Risk guide (PDF)
  • Printable Wall Chart & Legend (PDF)
  • Pre-loaded worked example you overwrite with your team

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$19.95 USD
Buy now

Pairs well with

From the blog

Hand-picked reading on how to actually use a tool like this.