◆ Excel · formulas

Risk Scoring

Score and rank products by regulatory risk: create a Risk Score column using weighted inputs for Likelihood and Impact…

2heights

4tasks

2roles do it

The same job, four heights

do it · improve it · decide · become

AExecute — “help me do it”Score and rank products by regulatory risk: create a Risk Score column using weighted inputs…+

Score and rank products by regulatory risk: create a Risk Score column using weighted inputs for Likelihood and Impact, rank products by that score, and produce a sorted table showing top 20 high-risk products for mitigation planning.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

BImprove — “do it better”Before I brief senior leaders, make prioritisation defensible: document the scoring weights,…+

Before I brief senior leaders, make prioritisation defensible: document the scoring weights, calculate Risk Score with SUMPRODUCT across Likelihood, Impact and Exposure, add a Rank column, and produce a short sensitivity column showing how a one-point change in Likelihood would move each product's rank.

when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

2 of them

Score and rank products by regulatory risk so senior leaders can prioritise mitigation work.

Score new development sites on a simple risk index so planners know which need detailed studies.

Who does this

2 roles

Compliance ManagerEnvironmental Scientist

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.