xlsx

Comprehensive spreadsheet creation, editing, and analysis with dynamic formulas and strict error prevention.

• Create, edit, and analyze spreadsheets with formulas and formatting
• Preserve existing templates and formatting conventions
• Ensure zero formula errors and dynamic recalculations
• Support for data analysis and visualization via pandas

• Zero Formula Errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?)
• Preserve Existing Templates (format, style, conventions)
• Color Coding Standards (blue, black, green, red, yellow)
• Number Formatting Standards (years as text, currency, zeros as '-', percentages as 0.0%)
• Use Formulas, Not Hardcoded Values (dynamic, recalculable spreadsheets)
• Mandatory recalc.py script for formula recalibration
• Documentation of hardcodes with source, date, reference, URL
• Critical: Verify cell references, avoid off-by-one errors

1. 1.Use pandas for data analysis and visualization
2. 2.Use openpyxl for formula and formatting operations
3. 3.Modify existing files while preserving formulas and style
4. 4.Recalculate formulas using recalc.py (MANDATORY IF USING FORMULAS)
5. 5.Verify and fix errors from recalc.py output
6. 6.Always use cell references, not hardcoded values