Repeatability
High
This is a structurally identical problem every time: date column, revenue column, 30-day window, skip blanks. There is no meaningful variation in judgment required across instances.
Ambiguity Tolerance
Medium
The core requirement is clear, but minor ambiguities exist — such as whether 'rolling 30 days' means a calendar-day window or 30 prior rows, and which exact columns are in use. These are easily resolved with a brief clarifying question or a reasonable default assumption.
Data & Tool Availability
High
No file access or API is needed — the agent only needs to know the column layout to produce a correct formula. The user can supply that in a single sentence.
Error Cost
Low
A wrong formula produces an obviously incorrect number or an error cell, which is immediately visible and trivially corrected. No irreversible damage is possible.
Human Judgment Required
Low
This is a pure technical construction task. No taste, ethics, or relationship context is involved — just Excel function knowledge and logic.