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.
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.