Skill: sheet-cog

Owner: nitishgargiitd

Summary: CellCog is built by its own Coding Agent. That same agent builds your spreadsheets. Full Python access for complex data manipulation, formulas, pivot tables, financial models, budget templates, data trackers, projections, and Excel/XLSX generation — powered by the engineering brain that develops an entire AI platform daily.

Tags: latest:1.0.3

Version history:

v1.0.3 | 2026-02-11T01:47:16.749Z | user

• Added explicit author and dependencies fields to metadata for better attribution and install clarity.
• Minor text improvements, such as clarifying that CellCog is required as a dependency.
• No code or feature changes; documentation only.

v1.0.2 | 2026-02-06T23:19:47.787Z | auto

• Updated skill description to emphasize that spreadsheets are built by the same agent that develops CellCog, highlighting full Python capability for advanced data and automation.
• Reframed messaging to focus on agent-driven construction rather than template generation.
• Improved emphasis on custom programming, complex data manipulation, and platform-grade engineering.
• No changes to spreadsheet capabilities, usage instructions, or examples.

v1.0.1 | 2026-02-05T05:48:57.814Z | user

Sheet-cog v1.0.1 Changelog:

• Added a new emoji icon (📈) in skill metadata for easier identification.
• Revised the prerequisites and usage examples to highlight the preferred create_chat pattern and notification-based execution (fire-and-forget, no polling).
• Clarified chat mode recommendations, defaulting to "agent" for most spreadsheets and reserving "agent team" for complex financial models.
• Refined explanations and reorganized some guidance to improve clarity, especially for new users.
• No code changes; documentation enhancements only.

v1.0.0 | 2026-02-04T03:40:43.809Z | user

• Initial release of sheet-cog skill for AI-powered spreadsheet generation via CellCog.
• Supports creation of financial models, budget templates, data trackers, analysis tools, and business spreadsheets.
• Requires CellCog SDK setup; integrates with the cellcog skill for API calls.
• Offers example prompts covering a wide range of spreadsheet types (finance, personal, business, analytics).
• Details advanced spreadsheet features: formulas, formatting, charts, multi-sheet workbooks, data validation, and printing layouts.
• Output options include XLSX files for Excel/Sheets and interactive HTML formats.

Archive index:

Archive v1.0.3: 2 files, 3832 bytes

Files: SKILL.md (8405b), _meta.json (128b)

File v1.0.3:SKILL.md

---

name: sheet-cog description: "CellCog is built by its own Coding Agent. That same agent builds your spreadsheets. Full Python access for complex data manipulation, formulas, pivot tables, financial models, budget templates, data trackers, projections, and Excel/XLSX generation — powered by the engineering brain that develops an entire AI platform daily." metadata: openclaw: emoji: "📈" author: CellCog dependencies: [cellcog]

Sheet Cog - Built by the Agent That Builds CellCog

CellCog is built by its own Coding Agent. That same agent builds your spreadsheets.

Full Python access, complex data manipulation, formulas, pivot tables, and financial models — powered by the engineering brain that develops an entire AI platform daily. Not a template filler. A programmer that understands your data and builds exactly what you need.

---

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.

Quick pattern (v1.0+):

# Fire-and-forget - returns immediately
result = client.create_chat(
    prompt="[your spreadsheet request]",
    notify_session_key="agent:main:main",
    task_label="spreadsheet-task",
    chat_mode="agent"  # Agent mode handles most spreadsheets well
)
# Daemon notifies you when complete - do NOT poll

---

What Spreadsheets You Can Create

Financial Models

Professional financial analysis and projections:

• Startup Financial Model: "Create a 3-year financial model for a SaaS startup including revenue projections, expenses, and cash flow"
• DCF Model: "Build a discounted cash flow model for valuing a company"
• Investment Analysis: "Create a real estate investment analysis spreadsheet with ROI calculations"
• Revenue Model: "Build a revenue forecasting model with multiple scenarios (base, optimistic, pessimistic)"
• Unit Economics: "Create a unit economics spreadsheet showing CAC, LTV, payback period"

Budget Templates

Personal and business budgets:

• Personal Budget: "Create a monthly personal budget tracker with income, fixed expenses, variable expenses, and savings goals"
• Household Budget: "Build a family budget spreadsheet with categories for housing, food, transportation, etc."
• Project Budget: "Create a project budget template with phases, resources, and variance tracking"
• Marketing Budget: "Build a marketing budget spreadsheet with channels, planned vs actual, and ROI tracking"
• Event Budget: "Create a wedding budget spreadsheet with vendor categories and payment tracking"

Data Trackers

Organized tracking for any data:

• Fitness Tracker: "Create a workout log spreadsheet with exercises, sets, reps, weights, and progress charts"
• Habit Tracker: "Build a daily habit tracking spreadsheet with monthly overview"
• Inventory Tracker: "Create an inventory management spreadsheet with stock levels, reorder points, and valuation"
• Sales Tracker: "Build a sales pipeline tracker with stages, probabilities, and forecasting"
• Time Tracker: "Create a timesheet template with projects, hours, and billing calculations"

Business Tools

Operational spreadsheets:

• Invoice Template: "Create a professional invoice template with automatic calculations"
• Employee Directory: "Build an employee directory spreadsheet with contact info, departments, and start dates"
• Vendor Comparison: "Create a vendor comparison spreadsheet for evaluating suppliers"
• OKR Tracker: "Build an OKR tracking spreadsheet for quarterly goals"
• Meeting Agenda: "Create a meeting agenda template with action items tracking"

Analysis Templates

Data analysis and calculations:

• Break-Even Analysis: "Create a break-even analysis spreadsheet with charts"
• Scenario Analysis: "Build a scenario planning spreadsheet with what-if analysis"
• Pricing Calculator: "Create a pricing model spreadsheet with cost-plus and value-based options"
• Loan Calculator: "Build a loan amortization schedule with payment breakdown"
• Commission Calculator: "Create a sales commission calculator with tiered rates"

---

Spreadsheet Features

CellCog spreadsheets can include:

| Feature | Description | |---------|-------------| | Formulas | SUM, AVERAGE, IF, VLOOKUP, and complex calculations | | Formatting | Headers, colors, borders, number formats, conditional formatting | | Charts | Bar, line, pie charts embedded in sheets | | Multiple Sheets | Organized workbooks with linked sheets | | Data Validation | Dropdowns, input restrictions | | Named Ranges | For cleaner formulas | | Print Layout | Ready for printing/PDF |

---

Output Formats

| Format | Best For | |--------|----------| | XLSX | Editable in Excel, Google Sheets, Numbers | | Interactive HTML | Web-based calculators and tools |

---

Chat Mode for Spreadsheets

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

Default to "agent" for most spreadsheet requests. CellCog's agent mode handles formulas, formatting, charts, and data organization efficiently.

Reserve "agent team" for complex financial modeling requiring deep accuracy validation—like DCF models, multi-scenario projections, or interconnected workbooks where formula correctness is critical.

---

Example Spreadsheet Prompts

SaaS financial model:

"Create a 3-year SaaS financial model with:

Assumptions Sheet:

• Starting MRR: $10,000
• Monthly growth rate: 15%
• Churn rate: 3%
• Average revenue per customer: $99
• CAC: $500
• Gross margin: 80%

Monthly P&L: Revenue, COGS, Gross Profit, Operating Expenses (broken down), Net Income

Key Metrics: MRR, ARR, Customers, Churn, LTV, CAC, LTV:CAC ratio

Charts: MRR growth, customer growth, profitability timeline

Include scenario toggles for growth rate (10%, 15%, 20%)."

Personal budget:

"Create a monthly personal budget spreadsheet:

Income Section: Salary, side income, other

Fixed Expenses: Rent, utilities, insurance, subscriptions, loan payments

Variable Expenses: Groceries, dining out, transportation, entertainment, shopping, health

Savings: Emergency fund, retirement, vacation fund

Include:

• Monthly summary with % of income per category
• Year-at-a-glance sheet with monthly totals
• Pie chart showing expense breakdown
• Conditional formatting (red if over budget)

Assume $5,000/month income."

Sales tracker:

"Build a sales pipeline tracker spreadsheet with:

Columns: Company, Contact, Deal Value, Stage (dropdown: Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost), Probability, Expected Close Date, Notes, Last Contact

Calculations: Weighted pipeline value, deals by stage, win rate

Dashboard Sheet: Pipeline by stage (funnel chart), monthly forecast, top 10 deals, activity metrics

Include sample data for 20 deals."

Break-even analysis:

"Create a break-even analysis spreadsheet:

Inputs:

• Fixed costs (rent, salaries, etc.)
• Variable cost per unit
• Selling price per unit

Calculations:

• Break-even units
• Break-even revenue
• Margin of safety

Sensitivity table: Show break-even at different price points

Chart: Cost-volume-profit graph showing break-even point

Default values: Fixed costs $50,000/month, variable cost $15/unit, price $25/unit."

---

Tips for Better Spreadsheets

1. Specify the structure: List the sheets, columns, and calculations you need.

2. Provide assumptions: For financial models, give starting numbers and growth rates.

3. Mention formulas needed: "Include VLOOKUP for...", "Calculate running totals", "Show variance vs plan."

4. Request sample data: "Include realistic sample data for testing" helps see it in action.

5. Describe formatting: "Conditional formatting for negative values", "Currency format", "Freeze header row."

6. Chart preferences: "Include a line chart showing trend", "Pie chart for breakdown."

File v1.0.3:_meta.json

{ "ownerId": "kn7a96cj9q65e0bhmzahv790en80ffqm", "slug": "sheet-cog", "version": "1.0.3", "publishedAt": 1770774436749 }

Archive v1.0.2: 2 files, 3814 bytes

Files: SKILL.md (8374b), _meta.json (128b)

File v1.0.2:SKILL.md

---

name: sheet-cog description: "CellCog is built by its own Coding Agent. That same agent builds your spreadsheets. Full Python access for complex data manipulation, formulas, pivot tables, financial models, budget templates, data trackers, projections, and Excel/XLSX generation — powered by the engineering brain that develops an entire AI platform daily." metadata: openclaw: emoji: "📈"

Sheet Cog - Built by the Agent That Builds CellCog

CellCog is built by its own Coding Agent. That same agent builds your spreadsheets.

Full Python access, complex data manipulation, formulas, pivot tables, and financial models — powered by the engineering brain that develops an entire AI platform daily. Not a template filler. A programmer that understands your data and builds exactly what you need.

---

Prerequisites

This skill requires the CellCog mothership 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.

Quick pattern (v1.0+):

# Fire-and-forget - returns immediately
result = client.create_chat(
    prompt="[your spreadsheet request]",
    notify_session_key="agent:main:main",
    task_label="spreadsheet-task",
    chat_mode="agent"  # Agent mode handles most spreadsheets well
)
# Daemon notifies you when complete - do NOT poll

---

What Spreadsheets You Can Create

Financial Models

Professional financial analysis and projections:

• Startup Financial Model: "Create a 3-year financial model for a SaaS startup including revenue projections, expenses, and cash flow"
• DCF Model: "Build a discounted cash flow model for valuing a company"
• Investment Analysis: "Create a real estate investment analysis spreadsheet with ROI calculations"
• Revenue Model: "Build a revenue forecasting model with multiple scenarios (base, optimistic, pessimistic)"
• Unit Economics: "Create a unit economics spreadsheet showing CAC, LTV, payback period"

Budget Templates

Personal and business budgets:

• Personal Budget: "Create a monthly personal budget tracker with income, fixed expenses, variable expenses, and savings goals"
• Household Budget: "Build a family budget spreadsheet with categories for housing, food, transportation, etc."
• Project Budget: "Create a project budget template with phases, resources, and variance tracking"
• Marketing Budget: "Build a marketing budget spreadsheet with channels, planned vs actual, and ROI tracking"
• Event Budget: "Create a wedding budget spreadsheet with vendor categories and payment tracking"

Data Trackers

Organized tracking for any data:

• Fitness Tracker: "Create a workout log spreadsheet with exercises, sets, reps, weights, and progress charts"
• Habit Tracker: "Build a daily habit tracking spreadsheet with monthly overview"
• Inventory Tracker: "Create an inventory management spreadsheet with stock levels, reorder points, and valuation"
• Sales Tracker: "Build a sales pipeline tracker with stages, probabilities, and forecasting"
• Time Tracker: "Create a timesheet template with projects, hours, and billing calculations"

Business Tools

Operational spreadsheets:

• Invoice Template: "Create a professional invoice template with automatic calculations"
• Employee Directory: "Build an employee directory spreadsheet with contact info, departments, and start dates"
• Vendor Comparison: "Create a vendor comparison spreadsheet for evaluating suppliers"
• OKR Tracker: "Build an OKR tracking spreadsheet for quarterly goals"
• Meeting Agenda: "Create a meeting agenda template with action items tracking"

Analysis Templates

Data analysis and calculations:

• Break-Even Analysis: "Create a break-even analysis spreadsheet with charts"
• Scenario Analysis: "Build a scenario planning spreadsheet with what-if analysis"
• Pricing Calculator: "Create a pricing model spreadsheet with cost-plus and value-based options"
• Loan Calculator: "Build a loan amortization schedule with payment breakdown"
• Commission Calculator: "Create a sales commission calculator with tiered rates"

---

Spreadsheet Features

CellCog spreadsheets can include:

| Feature | Description | |---------|-------------| | Formulas | SUM, AVERAGE, IF, VLOOKUP, and complex calculations | | Formatting | Headers, colors, borders, number formats, conditional formatting | | Charts | Bar, line, pie charts embedded in sheets | | Multiple Sheets | Organized workbooks with linked sheets | | Data Validation | Dropdowns, input restrictions | | Named Ranges | For cleaner formulas | | Print Layout | Ready for printing/PDF |

---

Output Formats

| Format | Best For | |--------|----------| | XLSX | Editable in Excel, Google Sheets, Numbers | | Interactive HTML | Web-based calculators and tools |

---

Chat Mode for Spreadsheets

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

Default to "agent" for most spreadsheet requests. CellCog's agent mode handles formulas, formatting, charts, and data organization efficiently.

Reserve "agent team" for complex financial modeling requiring deep accuracy validation—like DCF models, multi-scenario projections, or interconnected workbooks where formula correctness is critical.

---

Example Spreadsheet Prompts

SaaS financial model:

"Create a 3-year SaaS financial model with:

Assumptions Sheet:

• Starting MRR: $10,000
• Monthly growth rate: 15%
• Churn rate: 3%
• Average revenue per customer: $99
• CAC: $500
• Gross margin: 80%

Monthly P&L: Revenue, COGS, Gross Profit, Operating Expenses (broken down), Net Income

Key Metrics: MRR, ARR, Customers, Churn, LTV, CAC, LTV:CAC ratio

Charts: MRR growth, customer growth, profitability timeline

Include scenario toggles for growth rate (10%, 15%, 20%)."

Personal budget:

"Create a monthly personal budget spreadsheet:

Income Section: Salary, side income, other

Fixed Expenses: Rent, utilities, insurance, subscriptions, loan payments

Variable Expenses: Groceries, dining out, transportation, entertainment, shopping, health

Savings: Emergency fund, retirement, vacation fund

Include:

• Monthly summary with % of income per category
• Year-at-a-glance sheet with monthly totals
• Pie chart showing expense breakdown
• Conditional formatting (red if over budget)

Assume $5,000/month income."

Sales tracker:

"Build a sales pipeline tracker spreadsheet with:

Columns: Company, Contact, Deal Value, Stage (dropdown: Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost), Probability, Expected Close Date, Notes, Last Contact

Calculations: Weighted pipeline value, deals by stage, win rate

Dashboard Sheet: Pipeline by stage (funnel chart), monthly forecast, top 10 deals, activity metrics

Include sample data for 20 deals."

Break-even analysis:

"Create a break-even analysis spreadsheet:

Inputs:

• Fixed costs (rent, salaries, etc.)
• Variable cost per unit
• Selling price per unit

Calculations:

• Break-even units
• Break-even revenue
• Margin of safety

Sensitivity table: Show break-even at different price points

Chart: Cost-volume-profit graph showing break-even point

Default values: Fixed costs $50,000/month, variable cost $15/unit, price $25/unit."

---

Tips for Better Spreadsheets

1. Specify the structure: List the sheets, columns, and calculations you need.

2. Provide assumptions: For financial models, give starting numbers and growth rates.

3. Mention formulas needed: "Include VLOOKUP for...", "Calculate running totals", "Show variance vs plan."

4. Request sample data: "Include realistic sample data for testing" helps see it in action.

5. Describe formatting: "Conditional formatting for negative values", "Currency format", "Freeze header row."

6. Chart preferences: "Include a line chart showing trend", "Pie chart for breakdown."

File v1.0.2:_meta.json

{ "ownerId": "kn7a96cj9q65e0bhmzahv790en80ffqm", "slug": "sheet-cog", "version": "1.0.2", "publishedAt": 1770419987787 }