◆ Excel · formulas

Mitigation Prioritization

Rank potential mitigation sites by ecological benefit and logistics for the season planning team — create a table with…

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”Rank potential mitigation sites by ecological benefit and logistics for the season planning…+
Rank potential mitigation sites by ecological benefit and logistics for the season planning team — create a table with Site, Benefit score, Access difficulty, Distance to depot, Cost estimate; add a computed Rank using SUMPRODUCT weighting and sort the table by Rank descending.
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 planning committee, make trade-offs clear — expose the weighting used…+
Before I show this to the planning committee, make trade-offs clear — expose the weighting used for Benefit vs Logistics, add columns showing normalized scores and the top three drivers for each site, allow the committee to toggle weightings and see Rank recalc, and include a short ranked shortlist with notes on constraints for the top five sites.
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
Rank potential mitigation sites by ecological benefit and logistics to pick the best candidates for next season.

Who does this

1 roles
Habitat Restoration Worker

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.