Spreadsheet Formula Builder
НачальныйproductivityМинимальный контекст: 16K
Builds and explains spreadsheet formulas for Excel and Google Sheets from a plain-language description of the goal. Handles lookups, conditional aggregation, date math, text parsing, array formulas, and pivot-style summaries, explains how each part works, and debugs formulas that return errors or wrong values.
Варианты использования
- Translating a plain-language requirement into a working formula
- Debugging
- Replacing fragile nested IFs with a cleaner approach
- Building conditional aggregations and lookups across sheets
Пример промпта
I need a Google Sheets formula for this. Sheet "Orders" has columns: date (A), customer (B), region (C), amount (D). I want, for a given region in cell F1, the total amount for the current month only, ignoring blank rows. Give me the formula, explain each part, note any assumption about date formats, and show how it would differ in Excel.
Рекомендуемые модели
Совместимые инструменты
claude-codekiroany
Модальности
Вход: text
→Выход: text
Похожие Skills
Автор
OpenModels Community