qodex-ai avatar

Spreadsheet Processor

This handles Excel file operations with a strong focus on financial modeling conventions. It enforces zero formula errors, uses openpyxl for preserving formulas and formatting, and includes a LibreOffice-based recalculation script to compute formula values. The color coding standards are straight from investment banking (blue for inputs, black for formulas, green for internal links), and it pushes you to use Excel formulas instead of hardcoding Python calculations so spreadsheets stay dynamic. The formula verification workflow is solid, with detailed error detection for REF, DIV/0, and other common issues. If you're building financial models or need bulletproof spreadsheet processing where formulas matter, this gives you the guardrails and tooling to do it right.

skills.sh installs
626
GitHub stars
48
last updated
Aug 21, 2026

Install

$ npx -y skills add qodex-ai/ai-agent-skills --skill spreadsheet-processor --agent claude-code

Installs into .claude/skills of the current project.

Files

Requirements for Outputs

All Excel files

Zero Formula Errors

  • Every Excel model MUST be delivered with ZERO formula errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?)

Preserve Existing Templates (when updating templates)

  • Study and EXACTLY match existing format, style, and conventions when modifying files
  • Never impose standardized formatting on files with established patterns
  • Existing template conventions ALWAYS override these guidelines

Financial models

Color Coding Standards

Unless otherwise stated by the user or existing template

Industry-Standard Color Conventions
  • Blue text (RGB: 0,0,255): Hardcoded inputs, and numbers users will change for scenarios
  • Black text (RGB: 0,0,0): ALL formulas and calculations
  • Green text (RGB: 0,128,0): Links pulling from other worksheets within same workbook
  • Red text (RGB: 255,0,0): External links to other files
  • Yellow background (RGB: 255,255,0): Key assumptions needing attention or cells that need to be updated

Number Formatting Standards

Sponsors

Details

Repository
github.com/qodex-ai/ai-agent-skills
Categories
AI & Agent Building, Office & Documents
First seen
Jun 3, 2026

More from qodex-ai/ai-agent-skills

All 24
1yoanbernabeu avatargrepai-mcp-claudeyoanbernabeu/grepai-skillsIntegrate GrepAI with Claude Code via MCP. Use this skill to enable semantic code search in Claude Code.618skills.sh installs
2moizibnyousaf avatardatabase-designmoizibnyousaf/ai-agent-skillsDatabase schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optim615skills.sh installs
3yoanbernabeu avatargrepai-mcp-cursoryoanbernabeu/grepai-skillsIntegrate GrepAI with Cursor IDE via MCP. Use this skill to enable semantic code search in Cursor.601skills.sh installs
4alirezarezvani avatarautoresearch-agentalirezarezvani/claude-skillsAutonomous experiment loop that optimizes any file by a measurable metric. Inspired by Karpathy's autoresearch. The agent edits a target file, runs a fixed eval599skills.sh installs
5skillcreatorai avatarcode-refactoringskillcreatorai/ai-agent-skillscode refactoring596skills.sh installs
6moizibnyousaf avatarcode-documentationmoizibnyousaf/ai-agent-skillsWriting effective code documentation - API docs, README files, inline comments, and technical guides. Use for documenting codebases, APIs, or writing developer 569skills.sh installs