◆ Excel · forecast

Traffic Modeling

Run a sensitivity analysis on projected traffic volumes: build a two-way what-if data table varying trip rate and deve…

2heights
2tasks
1roles do it
See the prompt↓More forecast workflows

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Run a sensitivity analysis on projected traffic volumes: build a two-way what-if data table…+
Run a sensitivity analysis on projected traffic volumes: build a two-way what-if data table varying trip rate and development size, calculate resulting peak hour volumes, add a chart with trendline, and summarise scenarios where capacity is exceeded.
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 present to transport, reduce confusion and challenge — label scenario axes clearly…+
Before I present to transport, reduce confusion and challenge — label scenario axes clearly with units, show the baseline assumption row, highlight any scenarios that breach capacity in red and list the breaching assumptions, and add a short table of mitigation options tied to each breach so traffic engineers can see consequences and fixes.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

1 of them
Run a sensitivity analysis on projected traffic volumes so we can see how small changes affect road capacity needs.

Who does this

1 roles
Urban Planner

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.