# sheet-cog

Sheet Cog - AI-Powered Spreadsheet Builder via SkillBoss API Hub SkillBoss API Hub powers your spreadsheets. Full Python access, complex data manipulation, formulas, pivot tables, and financial models — powered by SkillBoss API Hub's intelligent routing. Not a template filler. A programmer that understands your data and builds exactly what you need. Prerequisites This skill requires a SKILLBOSS_API_KEY environment variable to call SkillBoss API Hub.

export SKILLBOSS_API_KEY=your_skillboss_api_key_here

Quick pattern: import requests, os SKILLBOSS_API_KEY = os.environ["SKILLBOSS_API_KEY"] def pilot(body: dict) -> dict: r = requests.post( "https://api.heybossai.com/v1/pilot", headers={ "Authorization": f"Bearer {SKILLBOSS_API_KEY}", "Content-Type": "application/json" }, json=body, timeout=120, ) return r.json()

# Build a spreadsheet — returns Python openpyxl code or direct XLSX

result = pilot({ "type": "chat", "inputs": { "messages": [ { "role": "system", "content": "You are an expert spreadsheet builder. Generate complete Python openpyxl code to create the requested spreadsheet as an XLSX file." }, { "role": "user", "content": "[your spreadsheet request]" } ] }, "prefer": "quality" }) text = result["result"]["choices"][0]["message"]["content"] 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 SkillBoss API Hub spreadsheets can include: FeatureDescriptionFormulasSUM, AVERAGE, IF, VLOOKUP, and complex calculationsFormattingHeaders, colors, borders, number formats, conditional formattingChartsBar, line, pie charts embedded in sheetsMultiple SheetsOrganized workbooks with linked sheetsData ValidationDropdowns, input restrictionsNamed RangesFor cleaner formulasPrint LayoutReady for printing/PDF Output Formats FormatBest ForXLSXEditable in Excel, Google Sheets, NumbersInteractive HTMLWeb-based calculators and tools Request Complexity Guide ScenarioRecommended preferBudget templates, trackers, data tables, basic calculations"balanced"Complex financial models with multi-scenario analysis, intricate formulas"quality" Default to "balanced" for most spreadsheet requests. SkillBoss API Hub handles formulas, formatting, charts, and data organization efficiently. Use "quality" 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 Specify the structure: List the sheets, columns, and calculations you need. Provide assumptions: For financial models, give starting numbers and growth rates. Mention formulas needed: "Include VLOOKUP for...", "Calculate running totals", "Show variance vs plan." Request sample data: "Include realistic sample data for testing" helps see it in action. Describe formatting: "Conditional formatting for negative values", "Currency format", "Freeze header row." Chart preferences: "Include a line chart showing trend", "Pie chart for breakdown."