Skip to content

Free tool

Task fit scoring sheet

List the tasks in one person’s week. The sheet scores each one on three tests and ranks them. The point values are on this page, so you can check every score.

Download the spreadsheetIt opens in Excel and Numbers. It sends nothing anywhere.

How the score works

Each task gets points on three tests. Multiply the three numbers. The highest possible score is 36. Multiplying means a zero on any test makes the score zero. Software cannot do a task whose information it cannot reach, however often the task comes up.

Test 1: Volume (minutes a week = times a week × minutes each time)
Minutes a weekPointsIn a year
Under 151Under 13 hours
15 to 59213 to 51 hours
60 to 179352 to 155 hours
180 or more4156 hours or more (about four 40-hour weeks)
How often → times a week
How oftenTimes a week
Many times a day25 (five times a day, five days a week)
Once a day5
A few times a week3
Once a week1
Every two weeks0.5
Once a month0.25
Test 2: Variability
ChoicePoints
Same every time3
Mostly the same2
Different each time1
Test 3: System access
ChoicePointsWhat it means
Tool or spreadsheet3Accounting software, a CRM, a project tool, a dashboard or a spreadsheet.
Email or documents2Searchable, but not sorted into fields.
Paper or in my head0Software cannot reach it yet.
The label (checked in this order)
LabelWhen
Write it down firstThe information is on paper or in your head, and the task is the same or mostly the same every time.
Hand to softwareThe score is 18 or more.
Look closerThe score is 6 to 17.
Keep with a personEverything else. That includes a task that is different each time and lives on paper or in your head.

Highest score first. A tie goes to the task with more minutes a week. If those match too, the task listed first ranks first. The cut points are a judgment call, not an industry standard.

Nothing earns Hand to software on volume alone. A score of 18 or more needs at least 2 points on variability and on system access. Write it down first means the task could fit if software could reach the information. The first step costs nothing: write the steps down, or put the information in a tool or spreadsheet.

A worked example

Example only. This week is made up, for an office that does not exist. It is not a client.

RankTaskHow often, minutesMin/wkVolumeVariabilityAccessScoreLabel
1Build the weekly client reportOnce a week, 909032318Hand to software
2Send late-invoice remindersOnce a week, 202023318Hand to software
3Copy order details from email into a spreadsheetOnce a day, 105023212Look closer
4Answer customer emailMany times a day, 61503126Look closer
5Call a client upset about a delayOnce a week, 30302100Keep with a person
6File paper receiptsOnce a month, 4511.251300Write it down first

Ranks 1 and 2 tie on score. The report ranks first because it takes 90 minutes a week against 20. Paper receipts are the same every time, but they live on paper, so the label is Write it down first. The call with an upset client is different each time, so it stays with a person.

What this did not see

  • Whether the tool you named really allows an export or a connection.
  • What a mistake would cost you or a client.
  • Whether the task involves private or confidential information.
  • How the person on the other end would feel about it.
  • What it would cost to build and run.

A high score means the task fits the three tests. It does not mean you should automate it. To weigh the cost, use the Automation Payback Calculator. No spreadsheet? Paste your week into the Task Check instead — it uses this same rubric and runs in your browser.

$1,750 · 5 days

Free 30-min call

Book call