xlsx

Create, edit, and analyze spreadsheets with dynamic formulas, strict formatting, and error-free recalculation.

• Comprehensive spreadsheet creation, editing, and analysis
• Support for formulas, formatting, data analysis, and visualization
• Zero formula errors required in all outputs
• Preserve existing templates and formatting conventions

• Zero Formula Errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?)
• Preserve existing templates and formatting
• Color coding standards for inputs, formulas, links, and key assumptions
• Number formatting rules for years, currency, zeros, percentages, multiples, negatives
• Use cell references, not hardcoded values in formulas
• Mandatory recalculation with recalc.py after formula changes
• All calculations must be dynamic and formula-driven
• Critical: Never hardcode calculated values in Python

1. 1.Choose tool (pandas for data, openpyxl for formulas/formatting)
2. 2.Create/load workbook, modify data/formulas/formatting, save file
3. 3.Run recalc.py to recalculate formulas (MANDATORY if using formulas)
4. 4.Verify and fix errors from recalc.py output
5. 5.Apply color coding and formatting standards
6. 6.Use cell references, not hardcoded values in formulas