Skip to content

formula-generator.md

Latest commit

 

History

History
84 lines (59 loc) · 1.55 KB

formula-generator.md

File metadata and controls

84 lines (59 loc) · 1.55 KB

Spreadsheet Formula Generator

Creates Excel/Google Sheets formulas from natural language descriptions with explanations.

Category: Data Skills: builtin_calculator Streaming: Final step only

Steps

Step 1: Understand Requirement

Prompt:

Analyze this formula request:

{{input}}

Identify:
1. The spreadsheet platform (Excel, Google Sheets, or both)
2. What calculation or operation is needed
3. Input data locations (columns, ranges)
4. Expected output format
5. Any conditions or special cases
6. Error handling requirements

Step 2: Generate Formula

Prompt:

Based on the analysis:
{{previous_output}}

Create the formula for: {{input}}

Provide:

**Formula (Excel):**

[formula]


**Formula (Google Sheets):** (if different)

[formula]


**How It Works:**
Step-by-step explanation of each part of the formula

**Example:**
Show with sample data how the formula works

**Tips:**
- Common mistakes to avoid
- Performance considerations for large datasets

Settings

Setting Value
Reasoning Enabled
Timeout 60 seconds
Max Steps 5

When to Use

  • Creating complex spreadsheet formulas
  • Converting business logic to formulas
  • Learning how formulas work
  • Cross-platform formula translation (Excel vs Google Sheets)

How It Works

  1. Understand Requirement — Identifies the platform, calculation needed, data locations, and special conditions
  2. Generate Formula — Creates the formula with step-by-step explanation, sample data example, and tips