文档

Excel Spreadsheet

试用

用自然语言描述需求即可生成 XLSX 电子表格——财务模型、预算表、跟踪表与分析工具,内置公式与图表。

它能做什么

通过 SDK 提交一段提示词,说明表格结构、字段、公式和假设条件,即可拿到 XLSX 或交互式 HTML 文件。可生成财务模型、预算模板、销售跟踪、库存管理等表格,内置 SUM、VLOOKUP 等公式、条件格式、柱状/折线/饼图以及多张关联工作表。常规任务使用 agent 模式即可;涉及多情景财务模型、公式准确性要求较高的场景,建议切换到 agent team 模式。

什么时候用它

  • 构建 SaaS 三年财务模型,包含营收预测、关键指标与情景切换
  • 制作个人或家庭月度预算表,按类目汇总并加入饼图与超支高亮
  • 生成销售管线跟踪表,带阶段下拉、加权预测与看板表
  • 输出盈亏平衡、贷款摊销或现金流折现分析,含敏感性表格与图表

技能文档

Excel Spreadsheets - 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):

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):

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:

FeatureDescription
FormulasSUM, AVERAGE, IF, VLOOKUP, and complex calculations
FormattingHeaders, colors, borders, number formats, conditional formatting
ChartsBar, line, pie charts embedded in sheets
Multiple SheetsOrganized workbooks with linked sheets
Data ValidationDropdowns, input restrictions
Named RangesFor cleaner formulas
Print LayoutReady for printing/PDF

Output Formats

FormatBest For
XLSXEditable in Excel, Google Sheets, Numbers
Interactive HTMLWeb-based calculators and tools

Chat Mode for Spreadsheets

ScenarioRecommended 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

Claude Code, Cursor, Codex + 70 more agents: npx skills add cellcog/skills --skill cellcog OpenClaw: clawhub install cellcog CellCog plugin users: run /cellcog-setup (or /cellcog:cellcog-setup depending on your tool) Manual setup: pip install -U cellcog and set CELLCOG_API_KEY. See the cellcog skill for SDK reference.

相关技能

把自然语言描述转为结构化 JSON,并由 mcp-diagram-generator MCP 服务生成 Draw.io、Mermaid 或 Excalidraw 图表文件。

作者 nssa.io1.0k 次安装47 星标

诊断生产力系统反复失效的根因,给出最小干预——容量测算、瓶颈定位、可靠的本地记录。

作者 Iván855 次安装69 星标

以 AI 机器人身份加入视频会议,提供语音、虚拟形象与屏幕共享四种模式。

作者 johnpatternai22 次安装8 星标

在本地磁盘以分类纯 Markdown 文件保存需要长期留存的事实,与智能体内置记忆并存。

作者 Iván559 次安装18 星标

从 AdMapix API 拉取广告创意、应用、榜单和收入预估等数据,原样返回结构化 JSON。

作者 fly0pants4.3k 次安装296 星标

cellcog 的更多技能

浏览全部技能

一条提示词生成最长 4 分钟的视频 —— 自动完成脚本、配音、配乐与剪辑。

作者 cellcog302 次安装25 星标

通过 CellCog 智能体完成跨市场、竞品、投资与学术主题的深度研究报告。

作者 cellcog230 次安装7 星标

获得多角度拆解知识点的辅导:图表、类比、详解题例、练习题与完整学习指南。

作者 cellcog163 次安装9 星标

通过文本提示和三家语音服务商,生成配音、音乐、音效及克隆语音音频。

作者 cellcog225 次安装4 星标

用提示词生成专业 PDF 与 DOCX 文档——涵盖简历、合同、报告、方案等多种类型。

作者 cellcog146 次安装6 星标

通过多轮对话打磨复杂想法的思考伙伴。

作者 cellcog130 次安装7 星标