Back to the menu
Espresso Bar · 11
Flat White Spreadsheet
Broken formula fixed, or the view you actually wanted built.
- Time
- 10 to 15 minutes
- Tools
- Excel or Sheets, plus Claude or ChatGPT
Before you start
The messy spreadsheet, or a representative sample of it.
Steps
- 1
Decide what you want: a formula that has stopped working, or a number you want to see at a glance.
- 2
Describe your columns and your goal to the AI using the prompt below.
- 3
Apply the formula in your sheet and check the answer against something you already know is right.
The prompt
Here are my columns and what I want to calculate or display. Write the formula or formulas and explain what each one does. Columns: [list them]. What I want: [describe it].