🧮
ROI Calculator from CRO Request
Build
⏱️
~2.5 hours
The CRO asks for an ROI calculator with no template. You need to spec it, build it, QA it, and publish documentation.
The Prompt
Copy this prompt to Claude Code
CRO asks: "Can you build me an ROI calculator for sales to use in demos?" I have no template. Need to spec it, build it, QA it, document it. (Planner mode) Spec out full ROI model: - What inputs does sales need to provide? - What's our pricing structure? - What are the value drivers? - What does competition charge? - What outputs does the calc produce? Then: 1. Build the sheet with all tabs, formulas, named ranges 2. Push all sheet data + Apps Script files via Gremlin 3. QA: lint for broken formulas, fix any #REF! or errors 4. Create snapshot for version control 5. Publish full documentation to RevOps portal
How It Works
Spec
Claude Code defines inputs, outputs, formulas
Build
Generate tabs, formulas, named ranges
Sync
Push to Sheets + Apps Script files
QA
Lint, fix errors, validate schema
Snapshot
Versioned backup for rollback
Document
Publish "How to Use" guide to Notion
How Claude Code Executes It
💭 thinking
Spec the model first, then build and QA.
$ command
g-gremlin write SHEET_ID --tab "ROI Model" --csv roi_model.csv --formulas
✓ Created ROI calculator with 23 formulas
$ command
g-gremlin lint SHEET_ID --rules "all" --output lint_report.json
✓ Found 2 #REF! errors
$ command
g-gremlin lint SHEET_ID --rules "quoting,dead-refs" --fix
✓ Fixed all errors
✓ success
Calculator ready, validated, and documented.
Results
4
Tabs built
23
Formulas created
2
Errors fixed
0
QA errors remaining
Try This Workflow
Start with the quickstart guide, then build your own ROI calculator.