◆ Excel · formulas

Impact Assessment

Calculate for each proposed development the projected stormwater load using area and runoff coefficients, sum total lo…

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

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Calculate for each proposed development the projected stormwater load using area and runoff…+
Calculate for each proposed development the projected stormwater load using area and runoff coefficients, sum total load per storm event, flag any projects where load exceeds the system safe limit, and handle errors so the result grid shows which inputs need checking before advice is drafted.
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 prepare recommendations, make the engineering review faster — add a column showing…+
Before I prepare recommendations, make the engineering review faster — add a column showing which input drove the exceedance (impervious area, coefficient), include a sensitivity column showing how much reduction would bring the project under limit, and keep clear error messages and an assumptions sheet so the director can defend conditions or denials.
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
Calculate which proposed developments would push stormwater capacity above safe limits so I can recommend conditions or denial.

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.