Spreadsheet Formula Builder

EinfachproductivityMindestens 16K Kontext

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.

spreadsheetexcelgoogle-sheetsformulasdata-analysis

Anwendungsfälle

  • 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

Beispiel-Prompt

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.

Empfohlene Modelle

claude-opus-5gemini-3-6-flashgemini-3-5-flash-lite

Kompatible Werkzeuge

claude-codekiroany

Modalitäten

Eingabe: text
→
Ausgabe: text

Ähnliche Skills

data-analysiscsv-data-cleanerchart-generator

Autor

OpenModels Community

@openmodelsrun