working-with-spreadsheets

SKILL.md

| Blue text | 0,0,255 | Hardcoded inputs, scenario values | | Black text | 0,0,0 | ALL formulas and calculations | | Green text | 0,128,0 | Links from other worksheets | | Red text | 255,0,0 | External links to other files | | Yellow background | 255,255,0 | Key assumptions needing attention |

| Data analysis | pandas | df = pd.readexcel('file.xlsx') | | Formulas & formatting | openpyxl | sheet['A1'] = '=SUM(B:B)' | | Large files (read) | openpyxl | loadworkbook('file.xlsx', readonly=True) | | Large files (write) | openpyxl | Workbook(writeonly=True) |

openpyxl writes formulas but doesn't calculate values. Use LibreOffice to recalculate:

Creates and edits Excel spreadsheets with formulas, formatting, and financial modeling standards. Use when working with .xlsx files, financial models, data analysis, or formula-heavy spreadsheets. Covers formula recalculation, color coding standards, and common pitfalls. Source: mjunaidca/mjs-agent-skills.

View raw