skills.rest
icyzh
icyzhCOMMUNITY
Explore all skills by this author →
Website𝕏@icyzhbeGitHub

excel-author

Construct auditable financial workbooks with openpyxl using strict cell-styling conventions and formula-based calculations.

1|Updated Jul 31, 2026
Search Tags:#audit#finance#openpyxl#spreadsheet#excel#modeling
One-click install
npx skills add https://github.com/icyzh/hermes-web --skill excel-author-icyzh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/icyzh/hermes-web/tree/main/optional-skills/finance/excel-author
Command: npx skills add https://github.com/icyzh/hermes-web --skill excel-author-icyzh

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the problem of creating opaque, error-prone financial models by enforcing strict, banker-grade auditing standards and automated formula-based construction.

Core Features & Use Cases

  • Auditable Construction: Enforces color-coded cell standards (blue for inputs, black for formulas, green for links) to ensure transparency.
  • Automated Recalculation: Includes a headless LibreOffice integration to ensure all Excel formulas are computed before delivery.
  • Use Case: Use this to build a complex DCF or LBO model where you need to ensure every assumption is sourced, every calculation is a formula, and the final output is ready for immediate review by a third party.

Quick Start

Use the excel-author skill to generate a new financial model workbook in the out directory based on the provided revenue and growth assumptions.

Frequently Asked Questions about excel-author

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

FAQPage Schema
How do I build auditable financial models in Excel using Python?▼

You build auditable financial models in Excel by enforcing strict color-coded cell conventions for inputs and formulas using openpyxl, ensuring every calculation is transparent and ready for third-party review.

How do I ensure Excel formulas are calculated when generating spreadsheets with openpyxl?▼

To ensure Excel formulas are calculated when generating spreadsheets with openpyxl, you need a headless LibreOffice integration to recalculate the workbook, guaranteeing data integrity for downstream automated pipelines.

Can I create complex DCF and LBO financial models programmatically?▼

Yes, you can programmatically create complex DCF and LBO models by generating workbooks with openpyxl that feature integrated balance checks and automated formula-based calculations.

Do I need LibreOffice to build financial spreadsheets with this approach?▼

Yes, LibreOffice is required for headless formula recalculation to ensure all Excel formulas are computed before delivery, guaranteeing data integrity in automated pipelines.

What are the limitations of using openpyxl for financial modeling?▼

A limitation of using openpyxl for financial modeling is that it cannot evaluate formulas natively, requiring a headless LibreOffice setup to recalculate workbooks and verify outputs before downstream usage.

Related Skills

Explore More Finance & Accounting Skills→
zeronx798zeronx798

excel-author

Generate auditable Excel workbooks with openpyxl for financial modeling.

Community
Advanced
projectedanxprojectedanx
1

pptx-author

Generate PowerPoint presentations by binding slide content to Excel workbook data.

Community
Intermediate
kwoekelkwoekel

complex-excel-builder

Automate creation of complex Excel workbooks with calculations and pivot tables.

Community
Advanced
InverterNetworkInverterNetwork

excel-author

Generate auditable financial workbooks with openpyxl and strict modeling conventions.

Official
Advanced