Skip Navigation

RIF Selection Spreadsheet vs HR Consulting

When a reduction becomes real, the choice usually narrows quickly to two options: build something in a spreadsheet, or call someone. They are not rivals — they are different halves of one job: a selection workbook produces the structure and the record, a consultant brings judgment and capacity, and a qualified employment lawyer brings the legal read, which nothing here replaces. Framing them as alternatives is what leads to the expensive mistake — paying consulting hours to produce a criteria memo and a scoring grid, or building a scoring grid and skipping the legal review.

A reduction in force (RIF) splits cleanly into two halves. One is structure and record: what the criteria are, who is compared with whom, how everyone scored, who the result lands on, what it costs, and where the paperwork lives. The other is judgment and law: whether this is the right plan, how to handle the specific person whose situation does not fit the grid, and what your obligations actually are. A spreadsheet does the first half very well and the second half not at all. The mistake is assuming you have to buy both together.

What a selection workbook, a consultant and a lawyer are each for

  • A RIF selection workbook is a structured artifact. It puts the criteria and their weights first, before the names, applies them identically to everyone in a comparator pool, ranks each pool against a target set in advance, and shows you who the selection lands on by department, site and length of service. Then it prices the severance and keeps the index of the file. It is the same discipline every time, at two in the morning as at ten in the morning.
  • HR consulting is judgment and capacity. Someone who has run reductions before, can tell you when your operating plan does not actually absorb the work, will sit in the notification meetings, and can manage outplacement and communications. On a large or multi-site reduction, or one with a union or an executive involved, that experience is worth a great deal.
  • An employment lawyer is neither. Advance-notice rules, release agreements, final pay timing, benefits notices, protected leave and accommodations, contract obligations, records retention. Nothing in this comparison replaces that, and a workbook explicitly does not try.

What a RIF costs: workbook versus consulting engagement

An engagement that runs your selection works from the same four artifacts: a written business case and criteria memo, a definition of the comparator pools, a completed scoring grid for everyone in them, and a checklist of the documents the file needs. The first three have to exist before anyone can be ranked; the fourth is what turns the decision into a file. A workbook gives you the criteria, the pools, the scoring and the file index, and prompts the business case. Doing them yourself does not remove the need for advice; it changes what you are buying advice about. You stop paying for setup and start paying for judgment — and the legal review, which you need either way, can be shorter because you walk in with a finished file rather than a conversation.

When to call someone anyway

  • Any reduction at all — take the completed file to a qualified employment lawyer before you notify a single person. This is not the optional one.
  • You may be over an advance-notice threshold by headcount or by the number affected at one site. That answer sets your whole calendar, so ask early.
  • Anyone affected is on protected leave, has an open accommodation, a live complaint or investigation, a work visa, or a contract or collective agreement. Raise those names in a direct conversation with counsel rather than an emailed or shared list, before the decision — and keep the reason out of the selection file and the scoring grid.
  • The reduction spans several sites or countries, or involves executives. The rules stop being uniform and the stakes stop being small.
  • Nobody internally can deliver the notifications. That is a genuine reason to bring someone in, and it has nothing to do with the spreadsheet.

The honest limits of a RIF selection workbook

  • It cannot tell you whether your reduction is lawful, and it does not try.
  • Its composition review is your own check on who the selection lands on — it applies no statistical test, and it knows nothing about protected characteristics, because it deliberately does not collect them. You should never score anyone on one, or on a proxy for one.
  • Its severance model prices payroll and separation only, not lost output, cover, rehiring, unemployment-insurance effects, or the productivity of a team that has just watched colleagues leave.
  • Its ratings are yours. A careful-looking process built on unfair inputs is an unfair decision with better paperwork.

Start with the free single-factor selection starter

If you want to see what a criteria-first selection feels like before you decide anything, the free single-factor selection starter ranks one comparator pool on one factor against a target you set first — no signup, and it deliberately shows you where one factor runs out. The full Reduction in Force (RIF) Layoff Workbook weights eight criteria across every pool at once, adds the composition review, the cost model, the decision log, the notification checklist and the twenty-document file index, and will not say “ready to notify” until the evidence and the file are complete — a completeness check on your process, not a legal clearance. Learn the vocabulary first on what a reduction in force is, or see the templates for HR & team leads hub for the rest of the toolset.

Nothing on this page is legal advice. Employment rules vary by country, state and locality, and by the size of your business and of the reduction. Take your completed selection file to a qualified employment lawyer before you notify anyone.

Frequently asked questions

What's the difference between a RIF selection spreadsheet and hiring an HR consultant?
They are not alternatives so much as different halves of the same job. A RIF selection spreadsheet is the artifact — the criteria and their weights, the comparator pools and their targets, the scoring for everyone in each pool, the ranking that follows, a composition review of who the selection lands on, a severance cost model, and an index of the documents the file should contain. An HR consultant is a person. They bring judgment, often experience of having done this before, and — depending on the engagement — take some of the work off your plate. The workbook produces the structure and the record; a consultant and a qualified employment lawyer bring the judgment and the legal read.
Can a spreadsheet replace an HR consultant for a layoff?
For the structured part, yes: writing criteria before the names, weighting them, defining who is genuinely comparable with whom, scoring the whole pool consistently, ranking against a target set in advance, checking the composition of the result, and building an organized file. That is exactly what a workbook does well, and it does not get tired or apply the criteria differently on the fifth person than the first. What a spreadsheet cannot do is tell you whether your reduction is lawful, whether an advance-notice rule reaches you, what a release agreement must contain, or how to handle the person on protected leave — those are questions for a qualified employment lawyer, and no template of any kind answers them.
How much does a RIF workbook cost versus an HR consulting engagement?
An owned workbook is a one-time cost: the Reduction in Force (RIF) Layoff Workbook is $29.95, and you keep the workbook if you ever have to do it again. Consulting and outplacement engagements are typically quoted per project or per hour and tend to scale with headcount, and a legal review is usually billed separately again. The difference people miss is not the sticker but what each one buys: an engagement that runs your selection works from the same four artifacts described above — a criteria memo, defined pools, completed scoring, and a document checklist — and builds any that do not already exist, so walking in with them finished moves your spend from setup to judgment.
Do I still need a lawyer if I use a RIF selection workbook?
Yes, and that is not a hedge — it is the point of building the file. A workbook cannot tell you whether a reduction is lawful, whether an advance-notice rule applies at your size, when final pay is due in your state, what a severance or release agreement has to contain, or what to do about someone on leave, with an open accommodation, on a work visa, or covered by a collective agreement. What it can do is turn the review from “please look at our layoff” into “here is the dated criteria memo, the pool definitions, the completed scoring for everyone, and the composition review — what have we missed?” That is usually a shorter and much better conversation.
Isn't a scoring spreadsheet risky in a layoff?
The risk people worry about is a number standing in for a decision. But the alternative to a written, weighted, evenly-applied set of criteria is not “no criteria” — it is unwritten criteria applied differently to each person, which is harder to explain afterwards and impossible to reconstruct. The genuine risks in a scoring sheet are specific and avoidable: criteria written after the names, a pool drawn to contain one person, ratings from memory rather than records, a tie broken on preference, and scoring only the people you selected. A workbook that dates the criteria, scores the whole pool, flags a tie rather than breaking it, and refuses to call the file complete while evidence is missing is designed around those failure modes.

Where we fit

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