--- name: sheet-cog description: "Create spreadsheets and Excel files. Financial models, budgets, data trackers, projections, pivot tables, complex formulas, charts. Full Python access. Also works well for general document and data tasks. Use for spreadsheets, financial models, or calculations. Outputs: XLSX. Powered by CellCog." metadata: openclaw: emoji: "📋" os: [darwin, linux, windows] author: CellCog homepage: https://cellcog.ai dependencies: [cellcog] ---

Sheet Cog - AI Spreadsheet & Excel Generation

Create spreadsheets with financial models, formulas, charts, and professional formatting.

---

Prerequisites

This skill requires the cellcog skill for SDK setup and API calls.

clawhub install cellcog

Read the cellcog skill first for SDK setup. This skill shows you what's possible.

OpenClaw agents (fire-and-forget — recommended for long tasks):

result = client.create_chat(
    prompt="[your task prompt]",
    notify_session_key="agent:main:main",  # OpenClaw only
    task_label="my-task",
    chat_mode="agent",  # See cellcog skill for all modes
)

All other agents (blocks until done):

result = client.create_chat(
    prompt="[your task prompt]",
    task_label="my-task",
    chat_mode="agent",
)

See the cellcog mothership skill for complete SDK API reference — delivery modes, timeouts, file handling, and more.

---

What CellCog Has Internally

1. XLSX Generation (openpyxl) — Full Excel file creation with formulas, formatting, conditional formatting, data validation, charts.
2. Full Python Access — pandas, numpy for data manipulation before writing to Excel.
3. LibreOffice Recalculation — Recalculates all formulas before delivering to ensure correctness.
4. Multi-Sheet Structure — Summary/Dashboard + Detail/Data + Assumptions sheets.

---

What Spreadsheets You Can Create

• Financial models (SaaS metrics, DCF, revenue projections)
• Budget templates (personal, project, marketing)
• Data trackers (sales pipeline, inventory, time tracking)
• Analysis tools (break-even, scenario analysis, loan amortization)
• Pivot tables, charts, and conditional formatting

---

Key Rule

CellCog always uses Excel formulas — never hardcodes calculated values in Python. This means the spreadsheet stays dynamic and editable.

---

Chat Mode

| Scenario | Recommended Mode | |----------|------------------| | Budget templates, trackers, basic calculations | "agent" | | Complex financial models, multi-scenario analysis | "agent team" |

---

Related Skills

• docs-cog — General document generation (all formats)
• fin-cog — Financial analysis and stock research
• data-cog — Data analysis from uploaded files