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

@openmodelsrun