Xlsx

This handles Excel file creation and manipulation with openpyxl and pandas, enforcing financial modeling conventions like color-coded inputs (blue for hardcoded, black for formulas, green for internal links) and proper number formatting. The core workflow is straightforward: build spreadsheets with formulas instead of hardcoded values, then run the included recalc.py script to calculate everything and scan for errors like #REF! or #DIV/0!. It's opinionated about financial model standards, requiring zero formula errors on delivery and documented sources for all hardcoded data. Worth using if you're building models that need to stay dynamic and follow industry formatting conventions, though the strict color coding might feel heavy-handed for simple spreadsheets.