Best For
- Starting from a structured, reusable prompt instead of a blank chat.
- Adapting the prompt to your own inputs while keeping the original intent intact.
- Workflows related to Data & Excel.
Excel Formula Generator
Translates a plain-language calculation goal into a ready-to-use Excel or Google Sheets formula, with a brief explanation of how it works.
Prompt Template
I need an Excel/Google Sheets formula to accomplish the following:
Calculation goal: {{Calculation Goal: e.g. calculate the average sales for rows where region is 'North'}}
Data description: {{Data Description: e.g. Column A = Region names, Column B = Sales values, row 1 is headers, data starts at row 2}}
Provide the formula and a short explanation of each function used.
Prompt Guide
How To Use It
- Copy the full prompt template.
- Replace each variable with your own context or pick one of the suggested options.
- Paste the completed prompt into ChatGPT, Claude, Gemini, or another AI assistant.
Variables In This Prompt
Calculation Goal
e.g. calculate the average sales for rows where region is 'North'
Data Description
e.g. Column A = Region names, Column B = Sales values, row 1 is headers, data starts at row 2
Example Starting Point
I need an Excel/Google Sheets formula to accomplish the following: Calculation goal: e.g. calculate the average sales for rows where region is 'North' Data description: e.g. Column A = Region names Provide the formula and a short explanation of each function used.
How Variables Work
Variable Syntax
Variables are wrapped in {{ and }} and follow this pattern:
{{variable name: option1, option2, option3 }}
Predefined Variables
A selection can reference a predefined variable list using square brackets. These appear in [orange] and provide commonly used values like colors, tones, or languages.
{{Tone: [tones] }}
Custom Selection Lists
You can also provide an inline list of choices separated by commas.
{{Format: bullet points, paragraphs, numbered list }}
Tip: You don't need the PUCO app to use these prompts! Simply copy the template and replace each {{…}} section with your own text directly in ChatGPT, Claude, Gemini, or any other AI assistant.