◆ Excel · formulas

Violation Assessment

Rank properties by severity and number of past complaints by adding a Rank column that combines violation severity and…

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 properties by severity and number of past complaints by adding a Rank column that combines…+
Rank properties by severity and number of past complaints by adding a Rank column that combines violation severity and complaint count so I can filter the top targets for enforcement visits this week.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Help me prioritize enforcement this week: create a composite priority score that weights…+
Help me prioritize enforcement this week: create a composite priority score that weights severity and complaint history, add a Rank column, highlight the top 25 properties, and provide a filter view showing contact, last inspection, and enforcement status so I can hand the list to an inspector on Monday morning.
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 properties by severity of violation and past complaints so I can prioritize enforcement visits this week.

Who does this

1 roles
Zoning Inspector

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.