spreadsheets-cog

# Spreadsheets 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. ## How to Use For your first CellCog task in a session, read the **cellcog** skill for the full SDK reference — file handling, chat modes, timeouts, and more. **OpenClaw (fire-and-forget):** ```python result = client.create_chat( prompt="[your task prompt]", notify_session_key="agent:main:main", task_label="my-task", chat_mode="agent", ) ``` **All agents except OpenClaw (blocks until done):** ```python from cellcog import CellCogClient client = CellCogClient(agent_provider="openclaw|cursor|claude-code|codex|...") result = client.create_chat( prompt="[your task prompt]", task_label="my-task", chat_mode="agent", ) print(result["message"]) ``` --- ## 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." --- ## If CellCog is not installed Run `/cellcog-setup` (or `/cellcog:cellcog-setup` depending on your tool) to install and authenticate. **OpenClaw users:** Run `clawhub install cellcog` instead. **Manual setup:** `pip install -U cellcog` and set `CELLCOG_API_KEY`. See the **cellcog** skill for SDK reference.