Update to CellCog

{
  "description": "AI Excel spreadsheet generation powered by CellCog. Financial models, budget templates, data trackers, projections, pivot tables, complex formulas — XLSX output. Data manipulation, analysis, charts, and professional formatting.",
  "included_files": [],
  "name": "excel-spreadsheet-cellcog",
  "skill_md_contents": "---\nname: excel-spreadsheet-cellcog\ndescription: \"AI Excel spreadsheet generation powered by CellCog. Financial models, budget templates, data trackers, projections, pivot tables, complex formulas — XLSX output. Data manipulation, analysis, charts, and professional formatting.\"\n---\n# Excel Spreadsheets - Built by the Agent That Builds CellCog\n\n**CellCog is built by its own Coding Agent. That same agent builds your spreadsheets.**\n\nFull 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.\n\n## How to Use\n\nUse the CellCog tools from this plugin's connector (`https://cellcog.ai/mcp`). The first time a tool runs, the user signs in with their CellCog account and clicks Approve.\n\n1. `cellcog_chat_create` with the brief as `prompt` (optionally `chat_mode` and `chat_tier`). It returns a chat id at once; the work runs in the background.\n2. Poll `cellcog_get_result` with that `chat_id` about once a minute. While it runs you get progress notes; when `complete` is true you get the final message and file links (valid 30 days), with previews of images and PDF pages.\n3. To iterate, `cellcog_chat_send` into the same chat. For files on the user's computer, open `cellcog_upload` and pass `upload:<upload_id>` in `attachments`; public https links can go in `attachments` directly.\n\nFor files, modes and tiers in depth, read the **cellcog** skill.\n\n---\n\n## What Spreadsheets You Can Create\n\n### Financial Models\n\nProfessional financial analysis and projections:\n\n- **Startup Financial Model**: \"Create a 3-year financial model for a SaaS startup including revenue projections, expenses, and cash flow\"\n- **DCF Model**: \"Build a discounted cash flow model for valuing a company\"\n- **Investment Analysis**: \"Create a real estate investment analysis spreadsheet with ROI calculations\"\n- **Revenue Model**: \"Build a revenue forecasting model with multiple scenarios (base, optimistic, pessimistic)\"\n- **Unit Economics**: \"Create a unit economics spreadsheet showing CAC, LTV, payback period\"\n\n### Budget Templates\n\nPersonal and business budgets:\n\n- **Personal Budget**: \"Create a monthly personal budget tracker with income, fixed expenses, variable expenses, and savings goals\"\n- **Household Budget**: \"Build a family budget spreadsheet with categories for housing, food, transportation, etc.\"\n- **Project Budget**: \"Create a project budget template with phases, resources, and variance tracking\"\n- **Marketing Budget**: \"Build a marketing budget spreadsheet with channels, planned vs actual, and ROI tracking\"\n- **Event Budget**: \"Create a wedding budget spreadsheet with vendor categories and payment tracking\"\n\n### Data Trackers\n\nOrganized tracking for any data:\n\n- **Fitness Tracker**: \"Create a workout log spreadsheet with exercises, sets, reps, weights, and progress charts\"\n- **Habit Tracker**: \"Build a daily habit tracking spreadsheet with monthly overview\"\n- **Inventory Tracker**: \"Create an inventory management spreadsheet with stock levels, reorder points, and valuation\"\n- **Sales Tracker**: \"Build a sales pipeline tracker with stages, probabilities, and forecasting\"\n- **Time Tracker**: \"Create a timesheet template with projects, hours, and billing calculations\"\n\n### Business Tools\n\nOperational spreadsheets:\n\n- **Invoice Template**: \"Create a professional invoice template with automatic calculations\"\n- **Employee Directory**: \"Build an employee directory spreadsheet with contact info, departments, and start dates\"\n- **Vendor Comparison**: \"Create a vendor comparison spreadsheet for evaluating suppliers\"\n- **OKR Tracker**: \"Build an OKR tracking spreadsheet for quarterly goals\"\n- **Meeting Agenda**: \"Create a meeting agenda template with action items tracking\"\n\n### Analysis Templates\n\nData analysis and calculations:\n\n- **Break-Even Analysis**: \"Create a break-even analysis spreadsheet with charts\"\n- **Scenario Analysis**: \"Build a scenario planning spreadsheet with what-if analysis\"\n- **Pricing Calculator**: \"Create a pricing model spreadsheet with cost-plus and value-based options\"\n- **Loan Calculator**: \"Build a loan amortization schedule with payment breakdown\"\n- **Commission Calculator**: \"Create a sales commission calculator with tiered rates\"\n\n---\n\n## Spreadsheet Features\n\nCellCog spreadsheets can include:\n\n| Feature | Description |\n|---------|-------------|\n| **Formulas** | SUM, AVERAGE, IF, VLOOKUP, and complex calculations |\n| **Formatting** | Headers, colors, borders, number formats, conditional formatting |\n| **Charts** | Bar, line, pie charts embedded in sheets |\n| **Multiple Sheets** | Organized workbooks with linked sheets |\n| **Data Validation** | Dropdowns, input restrictions |\n| **Named Ranges** | For cleaner formulas |\n| **Print Layout** | Ready for printing/PDF |\n\n---\n\n## Output Formats\n\n| Format | Best For |\n|--------|----------|\n| **XLSX** | Editable in Excel, Google Sheets, Numbers |\n| **Interactive HTML** | Web-based calculators and tools |\n\n---\n\n## Choosing Mode & Tier\n\n**Use `chat_mode=\"agent\", chat_tier=\"max\"` for spreadsheet work.** Financial models and formula correctness are coding-grade work where errors are costly.\n\n| Scenario | Recommended |\n|----------|-------------|\n| Financial models, multi-sheet workbooks | `chat_mode=\"agent\", chat_tier=\"max\"` |\n| Simple one-table sheets | `chat_mode=\"agent\", chat_tier=\"flash\"` |\n\nAgent Team (`chat_mode=\"team\"`) is reserved for deep research — spreadsheet work runs best on Agent max.\n\n---\n\n## Example Spreadsheet Prompts\n\n**SaaS financial model:**\n> \"Create a 3-year SaaS financial model with:\n> \n> **Assumptions Sheet:**\n> - Starting MRR: $10,000\n> - Monthly growth rate: 15%\n> - Churn rate: 3%\n> - Average revenue per customer: $99\n> - CAC: $500\n> - Gross margin: 80%\n> \n> **Monthly P&L:** Revenue, COGS, Gross Profit, Operating Expenses (broken down), Net Income\n> \n> **Key Metrics:** MRR, ARR, Customers, Churn, LTV, CAC, LTV:CAC ratio\n> \n> **Charts:** MRR growth, customer growth, profitability timeline\n> \n> Include scenario toggles for growth rate (10%, 15%, 20%).\"\n\n**Personal budget:**\n> \"Create a monthly personal budget spreadsheet:\n> \n> **Income Section:** Salary, side income, other\n> \n> **Fixed Expenses:** Rent, utilities, insurance, subscriptions, loan payments\n> \n> **Variable Expenses:** Groceries, dining out, transportation, entertainment, shopping, health\n> \n> **Savings:** Emergency fund, retirement, vacation fund\n> \n> Include:\n> - Monthly summary with % of income per category\n> - Year-at-a-glance sheet with monthly totals\n> - Pie chart showing expense breakdown\n> - Conditional formatting (red if over budget)\n> \n> Assume $5,000/month income.\"\n\n**Sales tracker:**\n> \"Build a sales pipeline tracker spreadsheet with:\n> \n> **Columns:** Company, Contact, Deal Value, Stage (dropdown: Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost), Probability, Expected Close Date, Notes, Last Contact\n> \n> **Calculations:** Weighted pipeline value, deals by stage, win rate\n> \n> **Dashboard Sheet:** Pipeline by stage (funnel chart), monthly forecast, top 10 deals, activity metrics\n> \n> Include sample data for 20 deals.\"\n\n**Break-even analysis:**\n> \"Create a break-even analysis spreadsheet:\n> \n> **Inputs:**\n> - Fixed costs (rent, salaries, etc.)\n> - Variable cost per unit\n> - Selling price per unit\n> \n> **Calculations:**\n> - Break-even units\n> - Break-even revenue\n> - Margin of safety\n> \n> **Sensitivity table:** Show break-even at different price points\n> \n> **Chart:** Cost-volume-profit graph showing break-even point\n> \n> Default values: Fixed costs $50,000/month, variable cost $15/unit, price $25/unit.\"\n\n---\n\n## Tips for Better Spreadsheets\n\n1. **Specify the structure**: List the sheets, columns, and calculations you need.\n\n2. **Provide assumptions**: For financial models, give starting numbers and growth rates.\n\n3. **Mention formulas needed**: \"Include VLOOKUP for...\", \"Calculate running totals\", \"Show variance vs plan.\"\n\n4. **Request sample data**: \"Include realistic sample data for testing\" helps see it in action.\n\n5. **Describe formatting**: \"Conditional formatting for negative values\", \"Currency format\", \"Freeze header row.\"\n\n6. **Chart preferences**: \"Include a line chart showing trend\", \"Pie chart for breakdown.\"\n"
}