Analyzing spreadsheets

Skill telagod/code-abyss/skills/analyzing-spreadsheets

Give your AI coding agent a personality. Composable persona + style + skills for Claude Code, Codex, Gemini CLI & OpenClaw. Ships Tech Persona Card v1.0 spec.

Install

npx -y skills add telagod/code-abyss --skill analyzing-spreadsheets

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

Processes Excel spreadsheet files (.xlsx, .xlsm, .csv). Creates workbooks, builds formulas, preserves formatting, analyzes tabular data, and validates financial models with zero-formula-error delivery. Use when working with spreadsheet files or tabular data analysis. Do NOT use for Word documents, PDFs, presentations, or database pipelines.

SKILL.md

2.1 KB, as published. Nobody here has run it

XLSX Processing

Create, edit, analyze .xlsx files. LibreOffice required for formula recalculation via recalc.py.

Iron Rule

Zero formula errors at delivery. All formulas must compute — no #REF!, #DIV/0!, #VALUE!, #N/A, #NAME?. Always run recalc.py after writing formulas.

Decision Matrix

Task	Tool	Reference
Data analysis, bulk ops, simple export	pandas	recipes.md
Formulas, formatting, Excel features	openpyxl	recipes.md
Financial model standards	—	financial-model.md
Recalculate formulas	`recalc.py`	recipes.md

Common Workflow

Choose tool: pandas for data, openpyxl for formulas/formatting
Create/Load workbook
Modify data, formulas, formatting
Save
Recalculate (MANDATORY if formulas): python recalc.py output.xlsx
Verify & fix errors — check JSON output, fix #REF! / #DIV/0! / #VALUE! / #NAME?

Hard Constraints

Use formulas, not hardcoded values — calculations stay dynamic. See recipes.md.
Preserve existing templates — match existing format/style EXACTLY when updating; user template overrides defaults.
Financial models — follow color/format conventions in financial-model.md.

Code Style

Concise Python, no unnecessary comments or print statements.
Excel files: comment cells with complex formulas, document hardcode sources.