Skip to content
Development
Skill

/analyzing-spreadsheets

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

From plugin
code-abyss
24530 skills

Claude Code

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

SKILL.md

analyzing-spreadsheets.SKILL.md
name: analyzing-spreadsheets
description: 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.
user-invocable: false
allowed-tools: Bash, Read, Write, Edit, Glob
argument-hint: <file.xlsx | task>

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](references/recipes.md) | | Formulas, formatting, Excel features | openpyxl | [recipes.md](references/recipes.md) | | Financial model standards | — | [financial-model.md](references/financial-model.md) | | Recalculate formulas | `recalc.py` | [recipes.md](references/recipes.md) |

Common Workflow

1. **Choose tool**: pandas for data, openpyxl for formulas/formatting 2. **Create/Load** workbook 3. **Modify** data, formulas, formatting 4. **Save** 5. **Recalculate** (MANDATORY if formulas): `python recalc.py output.xlsx` 6. **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](references/recipes.md#critical-use-formulas-not-hardcoded-values).
  • **Preserve existing templates** — match existing format/style EXACTLY when updating; user template overrides defaults.
  • **Financial models** — follow color/format conventions in [financial-model.md](references/financial-model.md).

Code Style

  • Concise Python, no unnecessary comments or print statements.
  • Excel files: comment cells with complex formulas, document hardcode sources.
Read more
@telagod
Ships withcode-abyss

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.

Stars on GitHub

Momentum

stars in total
245
Star history of telagod/code-abyss on GitHub, a chart by star-history.com

Other skills on code-abyss.

analyzing-changes

analyzing-changes

Analyzes code changes, detects documentation drift, and evaluates change impact scope. Use when reviewing diffs, checking doc…

@telagod@telagodInstall Skill
analyzing-security

analyzing-security

Scans code for security vulnerabilities, detects dangerous patterns, and ensures security decisions are documented. Use when…

@telagod@telagodInstall Skill
architecting-security

architecting-security

安全架构与治理:威胁建模 (STRIDE/PASTA/LINDDUN)、零信任身份架构、IAM/SSO/MFA/PAM、合规框架 (SOC2/PCI/HIPAA/GDPR)、DLP、隐私工程、安全控制设计。Use when designing…

@telagod@telagodInstall Skill
automating-devops

automating-devops

DevOps knowledge reference covering Git workflows, testing strategies, DevSecOps, release pipeline orchestration (release.yml,…

@telagod@telagodInstall Skill

More skills from other plugins.

brainstorming
Auto-invoked

brainstorming

You MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or…

@obra@obraInstall Skill
ask-matt

ask-matt

Ask which skill or flow fits your situation. A router over the skills in this repo.

skills12d309k
@mattpocock@mattpocockInstall Skill
accessibility
Auto-invoked

accessibility

Design, implement, and audit accessible UI to WCAG 2.2 Level AA across Web, iOS, and Android — semantic ARIA roles and labels,…

ecc13d293k
@affaan-m@affaan-mInstall Skill
compiler-commit

compiler-commit

Use when you want to verify compiler changes and commit with the correct convention. Runs tests, lint, and format, then commits…

react2d252k
@facebook@facebookInstall Skill

Questions about analyzing-spreadsheets.

Which coding agents can use analyzing-spreadsheets?
analyzing-spreadsheets installs in Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, OpenCode and Windsurf with the skills CLI, using each agent's flag shown on this page. Flowy's auto-invocation, which fires a skill when your prompt matches, runs in Claude Code only.