Generate auditable Excel workbooks with openpyxl for financial modeling.
npx skills add https://github.com/devMoez/titan --skill excel-author-devmoez
Please help me install this Agent Skill. Skill: excel-author Source: https://github.com/devMoez/titan/tree/main/optional-skills/finance/excel-author Command: npx skills add https://github.com/devMoez/titan --skill excel-author-devmoez
This Skill solves the problem of producing financial Excel workbooks that are hard to audit, fragile to edits, and opaque about what is an input versus a calculation.
Ask the agent to build a complete financial Excel model workbook and save it to the out folder following the banker-grade conventions, then recalculate formulas before returning the output path.
High-intent search queries and answers about installing and using this skill.
To generate auditable Excel financial models, this Skill uses openpyxl to write formula strings directly into .xlsx files rather than pasting static computed values, ensuring every derived metric remains reviewable and editable across downstream spreadsheet tools.
Banker-grade cell color conventions use blue for hardcoded assumptions, black for formula-driven results, and green for external links, allowing reviewers to instantly distinguish inputs from calculations and maintain auditability across the workbook.
You can add balance checks by generating a dedicated Checks tab that surfaces TRUE/FALSE validation results for reconciliations, utilizing named ranges for cross-sheet references to ensure formulas remain transparent and auditable during headless generation.
Yes, openpyxl supports writing formula strings for sensitivity analysis tables, allowing you to programmatically generate DCF-style projections and sensitivity outputs where computed values are resolved by the spreadsheet engine rather than static entry.
Yes, you can recalculate formulas headlessly using a LibreOffice headless recalc workflow after generating the workbook with openpyxl, enabling downstream tooling to obtain computed values instead of encountering blank formula caches.
Using named ranges for cross-sheet references in financial modeling improves auditability by making formulas readable and resilient to structural edits, ensuring reviewers can trace calculation logic without deciphering raw cell coordinates.
RheasilviaGenerate auditable .xlsx financial workbooks with openpyxl and banker-grade conventions.
WyRainBowCreate and edit XLSX files with pandas and dynamic formulas.
daloopaCreate end-to-end Excel financial models from a single ticker input.
NONEitnonameCreate and edit Excel workbooks with formulas using OpenPyXL.
