◆ Excel · forecast

Sensitivity Analysis

Run a sensitivity test on material prices: create a scenario table that increases key material unit rates by 10% and 2…

2heights

34tasks

10roles do it

The same job, four heights

do it · improve it · decide · become

AExecute — “help me do it”Run a sensitivity test on material prices: create a scenario table that increases key material…+

Run a sensitivity test on material prices: create a scenario table that increases key material unit rates by 10% and 20%, recalculate total project cost under each scenario, and summarise the change in absolute and percentage terms for the client.

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 show this to the client, make the sensitivity clear and actionable — list which…+

Before I show this to the client, make the sensitivity clear and actionable — list which materials drive the difference, show the change to the contingency and contract sum, produce a tornado chart of material-by-material impact, and include a short recommendation on procurement timing or hedging to limit exposure.

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

The real tasks

8 of them

Run a sensitivity test to show the client how total cost changes if key material prices rise 10–20%.

Run a sensitivity check on the budget to show how cost increases in concrete or steel change the overall project contingency need.

Run a sensitivity check on outcome measures to see how much a client's progress changes if a session is missed or a medium is swapped so I can prioritise interventions.

Run a sensitivity check on elevation corrections to see how small changes in control points affect contour placement on the finished sheet.

Run a sensitivity analysis on expected sediment reduction when changing buffer width so we can make a defensible recommendation.

Run a sensitivity check showing how conversion rate changes would affect ROI so we can advise the client on bid strategy.

Run a short sensitivity check to see how long lead times affect project completion dates for a new instrument.

Run a sensitivity check that shows which assumptions change site risk the most so legal staff can see the uncertainty bounds.

Who does this

10 roles

Architectural Project ManagerDigital Campaign ManagerFinance ManagerLegal AdvisorSales ExecutiveTransportation PlannerArchitectArt TherapistCartographerConservation 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.