excel-author

Generate auditable Excel financial models with openpyxl conventions.

1|Updated Jun 25, 2026
One-click install
npx skills add https://github.com/Signmanal/VIGIL --skill excel-author-signmanal
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: excel-author
Source: https://github.com/Signmanal/VIGIL/tree/main/optional-skills/finance/excel-author
Command: npx skills add https://github.com/Signmanal/VIGIL --skill excel-author-signmanal

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill eliminates the risk of creating inconsistent, non-auditable Excel financial models that lack traceability for review, have fragile hardcoded values that break when assumptions change, and fail to meet finance team audit standards.

Core Features & Use Cases

  • Banker-grade cell conventions: Automatically applies blue/black/green color coding to distinguish hardcoded inputs, live formulas, and cross-sheet/external links for instant auditability.
  • Audit-ready model structure: Enforces formula-only calculation cells, named ranges for cross-references, dedicated balance check tabs, and mandatory source comments on all hardcoded inputs.
  • Use Case: A financial analyst building a DCF model can use this Skill to generate a fully auditable workbook with sensitivity tables, balance checks, and properly sourced assumptions, reducing review time and eliminating manual formula errors.

Quick Start

Use the excel-author skill to build an auditable DCF financial model with WACC sensitivity tables and balance checks, saved to the ./out directory for your team's review.

Frequently Asked Questions about excel-author

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

FAQPage Schema
How do I build an auditable Excel financial model with openpyxl?

Build an auditable Excel financial model by enforcing standardized modeling conventions via openpyxl, applying formula-over-hardcode rules, blue/black/green cell color conventions, named ranges, and balance check tabs for full audit compliance.

What are the best practices for color coding cells in financial modeling?

Best practices for color coding in financial modeling involve using blue for hardcoded inputs, black for live formulas, and green for cross-sheet or external links, allowing reviewers to instantly trace calculation origins and audit assumptions.

How do I generate a DCF model with sensitivity tables in Excel?

Generate a DCF model with sensitivity tables by enforcing structured, headless Excel workbook creation that includes automated sensitivity table construction, balance checks, and properly sourced assumptions to reduce manual formula errors.

Can I use openpyxl to create a 3-statement model with balance checks?

Yes, you can use openpyxl to create a 3-statement model with balance checks by programmatically enforcing formula-only calculation cells, cross-sheet named ranges, and dedicated balance check tabs to ensure audit readiness.

Why does my Excel reconciliation model fail audit reviews?

Excel reconciliation models fail audit reviews due to fragile hardcoded values, lack of traceability, and missing source comments on inputs, which can be resolved by enforcing formula-over-hardcode rules and mandatory standardized conventions.

Does openpyxl support enforcing named ranges and formula conventions for LBO models?

openpyxl supports enforcing named ranges and formula conventions for LBO models by programmatically applying standardized modeling rules, ensuring all calculation cells use live formulas instead of static values for formal review compliance.