skills.rest
loteiron
loteironCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

excel-author

Generate auditable financial Excel workbooks with openpyxl using banker-grade conventions.

Updated Sep 10, 2026
Search Tags:#financial modeling#Excel#openpyxl#spreadsheet#xlsx#DCF#sensitivity analysis
One-click install
npx skills add https://github.com/loteiron/ZeusAgent --skill excel-author-loteiron
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/loteiron/ZeusAgent/tree/main/optional-skills/finance/excel-author
Command: npx skills add https://github.com/loteiron/ZeusAgent --skill excel-author-loteiron

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve? Building financial models in Excel by hand leads to silent errors: hardcoded values where formulas should be, undocumented assumptions, and no way for a reviewer to audit the work. This Skill produces .xlsx files headlessly via openpyxl that follow strict banker-grade conventions so any reviewer can immediately distinguish inputs from calculations. ## Core Features & Use Cases - Auditable color conventions: Blue fonts for hardcoded inputs, black for live formulas, green for cross-sheet links, plus cell comments documenting the source of every hardcoded number. - Formula-first modeling: Every derived cell is a live Excel formula, with named ranges for cross-sheet references and a Checks tab that surfaces TRUE/FALSE balance validations. - Sensitivity tables and recalc: Builds odd-sized sensitivity grids with a highlighted base-case center cell, and includes a script to recalculate formulas via headless LibreOffice before delivery. - Use Case: Ask the agent to build a DCF model for a company. It creates an Inputs tab with sourced assumptions, a DCF tab of live formulas, a Checks tab, and a 5x5 WACC/terminal-growth sensitivity table, saved to ./out/model.xlsx. ## Quick Start Use the excel-author skill to build a DCF valuation workbook for Acme Corp with sourced inputs, live formulas, a checks tab, and a WACC sensitivity table saved to ./out/acme-dcf.xlsx.

Frequently Asked Questions about excel-author

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an Excel financial model with openpyxl in Python?▼

Install openpyxl, create a Workbook, and write inputs as hardcoded values with blue fonts while writing every calculated cell as a formula string like "=D19*(1+$B$8)". Save the workbook to ./out/ and recalculate it with LibreOffice headless before delivery.

How to build a WACC sensitivity table in Excel with Python?▼

Build the table with loops over WACC and terminal growth axes using an odd grid size like 5x5 so the center cell equals the base case. Populate every cell with a full recalculation formula and highlight the center cell with a medium-blue fill and bold font.

Why do openpyxl formulas show as None when reading with data_only?▼

openpyxl writes formula strings but never computes them, so data_only reads return None until a calculation engine runs. Recalculate the file with LibreOffice headless using the included recalc.py script or open it once in Excel.

Does openpyxl support named ranges and cell comments?▼

Yes, openpyxl supports defined names via wb.defined_names with DefinedName objects pointing to absolute cell references, and comments via the Comment class attached to cells. Both are used here for cross-sheet references and input sourcing.

When should I not use openpyxl for Excel automation?▼

Avoid it when a user has a live Excel session with an Office MCP available, when exporting pure tabular data without formulas where pandas.to_excel is simpler, or when building interactive dashboards that belong in a BI tool.

Related Skills

Explore More Finance & Accounting Skills→
faisalanjumfaisalanjum
3

guidance-inventory

Extract forward-looking financial guidance from SEC filings and earnings call transcripts into a graph database.

Community
Advanced
SignmanalSignmanal
1

pptx-author

Generate PowerPoint decks with python-pptx and bind values to Excel cells.

Community
Intermediate
jwangkunjwangkun
705

china-audit-xls

Audit Chinese equity financial models and Excel workbooks for CAS compliance.

Community
Advanced
TeiNamTeiNam
12

xlsx-generation

Generate Excel workbooks with formulas and charts using openpyxl, XlsxWriter, or pandas.

Community
Intermediate