Afrexai Spreadsheet Engineering

# Spreadsheet Engineering — AfrexAI

> Build bulletproof spreadsheets: financial models, dashboards, data systems, and automation. Platform-agnostic methodology for Google Sheets, Excel, and LibreOffice.

## Quick Health Check

Score your spreadsheet /16:

| Signal | Healthy | Sick |
|---|---|---|
| Named ranges for all key inputs | ✅ Uses named ranges | ❌ Raw cell references everywhere |
| Inputs separated from calculations | ✅ Clear input section | ❌ Hardcoded values in formulas |
| No circular references | ✅ Clean dependency chain | ❌ Iterative calculation warnings |
| Documentation/comments exist | ✅ README sheet + cell notes | ❌ "What does this formula do?" |
| Error handling in formulas | ✅ IFERROR/IFNA wrapping | ❌ #REF! #N/A scattered everywhere |
| Consistent formatting | ✅ Style guide followed | ❌ Random fonts, colors, sizes |
| Version history/backup | ✅ Named versions + changelog | ❌ "Final_v3_REAL_final.xlsx" |
| Data validation on inputs | ✅ Dropdowns + range constraints | ❌ Free-text in structured fields |

**Score:** 0-4 🔴 rebuild | 5-8 🟡 refactor | 9-12 🟢 optimize | 13-16 🔵 production-grade

---

## Phase 1: Architecture & Planning

### Spreadsheet Strategy Brief

```yaml
spreadsheet_brief:
  name: "[Descriptive Name]"
  purpose: "[What decision does this support?]"
  owner: "[Who maintains this]"
  audience: "[Who uses this — technical level]"
  update_frequency: "[Real-time / Daily / Weekly / Monthly / Ad-hoc]"
  data_sources:
    - source: "[Where data comes from]"
      method: "[Manual / Import / API / IMPORTRANGE / Power Query]"
      refresh: "[How often]"
  outputs:
    - "[Dashboard / Report / Export / Decision support]"
  complexity_tier: "[Simple / Standard / Complex / Enterprise]"
  platform: "[Google Sheets / Excel / Both]"
  kill_criteria:
    - "If >50 users need simultaneous editing → move to database"
    - "If >100K rows → move to database or BI tool"
    - "If requires audit trail → move to proper system"
```...

# afrexai-spreadsheet-engineering

> Build bulletproof spreadsheets: financial models, dashboards, data systems, and automation. Platform-agnostic methodology for Google Sheets, Excel, and LibreOffice.

## Install

```bash
clawhub install afrexai-spreadsheet-engineering
```

## What's Inside

- **29KB** single SKILL.md — complete spreadsheet engineering methodology
- 12-phase system covering architecture → formulas → dashboards → automation
- Formula patterns library (L1-L4 complexity) with XLOOKUP, QUERY, LAMBDA, LET
- Financial modeling architecture with SaaS revenue models and scenario analysis
- Dashboard design system with KPI cards, chart selection guide, and interactive controls
- Google Apps Script and Excel VBA automation patterns
- Data validation and quality pipeline
- Performance optimization guide (volatile function elimination, bounded ranges)
- 4 ready-to-use templates (budget, project, pipeline, OKR)
- 100-point quality rubric across 8 weighted dimensions
- Platform-agnostic: works for Google Sheets, Excel 365, and LibreOffice

## Quick Start

Ask your agent:
- "Design a financial model for my SaaS business"
- "Audit this spreadsheet for quality issues"
- "Build a dashboard for tracking monthly KPIs"
- "Write a QUERY formula to aggregate sales by region"

## ⚡ Level Up

For industry-specific financial models and templates, check out our **AI Agent Context Packs** ($47 each):

👉 [**Browse All Packs →**](https://afrexai-cto.github.io/context-packs/)

## 🔗 More Free Skills by AfrexAI

- [afrexai-data-storytelling](https://clawhub.com/afrexai-cto/afrexai-data-storytelling) — Data visualization methodology
- [afrexai-personal-finance](https://clawhub.com/afrexai-cto/afrexai-personal-finance) — Personal finance operating system
- [afrexai-automation-strategy](https://clawhub.com/afrexai-cto/afrexai-automation-strategy) — Workflow automation
- [afrexai-fpa-engine](https://clawhub.com/afrexai-cto/afrexai-fpa-engine) — Financial planning & analysis
- [afre...