excel-author

To generate auditable financial models, this skill uses openpyxl to build .xlsx workbooks that enforce banker-grade conventions, applying color-coded styling to separate hardcoded inputs from formulas. It structures your models with balance checks and source documentation for reliable peer review.

Yes, you can build DCF projections and sensitivity tables with openpyxl. This skill supports complex financial analysis tasks by enforcing Excel formulas over hardcoded values and utilizing named ranges for cross-sheet references to maintain calculation integrity.

Yes, you need LibreOffice for headless formula recalculation to ensure data integrity. While openpyxl constructs the workbook and writes the formulas, LibreOffice processes these calculations outside of a standard desktop Excel environment.

The best way to automate a 3-statement model with balance sheet reconciliation is using this skill, which generates structured .xlsx workbooks featuring built-in balance checks and automated formatting to distinguish inputs, formulas, and external links.

Openpyxl supports banker-grade formatting when driven by this skill, which automatically applies color-coded cell styling to distinguish hardcoded inputs, formulas, and external links, ensuring the resulting spreadsheet is fully auditable.