excel-author

Generate auditable .xlsx workbooks with formula-first modeling and named ranges.

4|Updated May 18, 2026
One-click install
npx skills add https://github.com/ZardLi1115/zedclaw --skill excel-author-zardli1115
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/ZardLi1115/zedclaw/tree/main/optional-skills/finance/excel-author
Command: npx skills add https://github.com/ZardLi1115/zedclaw --skill excel-author-zardli1115

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Excel models often end up as hard-to-audit spreadsheets where assumptions are indistinguishable from calculations and values silently break when inputs change. This Skill produces reviewable workbooks that keep formulas live and inputs clearly sourced.

Core Features & Use Cases

  • Auditable cell conventions: Blue fonts mark hardcoded human inputs, black fonts mark formula-driven outputs, and green fonts indicate links.
  • Formula-first modeling: Ensures every derived number is written as an Excel formula string rather than computed in Python and pasted as a value.
  • Built-in review guardrails: Adds named ranges for cross-sheet references and a dedicated Checks tab with TRUE/FALSE balance checks to validate model integrity.
  • Recalculation-ready output: Provides a helper script to recalculate the workbook headlessly using LibreOffice so downstream tooling can read computed results.

Quick Start

Generate an auditable financial workbook by asking the agent to create the required Inputs, DCF/calc, and Checks tabs and save the resulting .xlsx to out/ using the Skill’s blue/black/green and formula-over-hardcodes conventions.

Frequently Asked Questions about excel-author

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

FAQPage Schema
How do I generate Excel financial models with live formulas instead of pasted values?

Building auditable Excel financial models requires writing every derived number as an Excel formula string rather than computing values in Python. This formula-first approach ensures calculations remain transparent and dynamically update when hardcoded inputs change.

What are standard cell conventions for building auditable Excel workbooks?

Auditable Excel workbooks use specific cell conventions: blue fonts mark hardcoded human inputs, black fonts indicate formula-driven outputs, and green fonts represent cross-sheet links. This visual separation clarifies model structure during financial review.

How do I add balance checks and validation logic to a DCF model in Excel?

Adding balance checks to a DCF model involves creating a dedicated Checks tab with TRUE/FALSE validation logic. Applying named ranges for cross-sheet references ensures these audit checks dynamically validate model integrity and catch calculation errors.

Can I recalculate an openpyxl generated xlsx file headlessly using LibreOffice?

Yes, you can recalculate an openpyxl generated xlsx file headlessly using a LibreOffice recalc script. Since openpyxl writes formula strings without computing results, this headless recomputation allows downstream tooling to read the final calculated values.

Does openpyxl support sensitivity analysis and named ranges for financial modeling?

openpyxl supports financial modeling by enabling programmatic generation of sensitivity tables and defined named ranges for cross-sheet references. Combined with formula-first conventions, it produces structured xlsx outputs for DCFs and reconciliations.