Skill228 estrellas del repoactualizado yesterday

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 for Word documents, PDFs, presentations, or database pipelines.

Ver fuente Repositorio: code-abyss

Instalar en Claude Code

Copiar

git clone --depth 1 https://github.com/telagod/code-abyss /tmp/analyzing-spreadsheets && cp -r /tmp/analyzing-spreadsheets/skills/analyzing-spreadsheets ~/.claude/skills/analyzing-spreadsheets

Después abre una sesión nueva de Claude Code; el skill carga automáticamente.

Definición

SKILL.md

# 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.

Del mismo repositorio

analyzing-changesSkill

Analyzes code changes, detects documentation drift, and evaluates change impact scope. Use when reviewing diffs, checking doc sync, or running pre-commit analysis. Automatically triggered after design-level changes or refactoring.

analyzing-securitySkill

Scans code for security vulnerabilities, detects dangerous patterns, and ensures security decisions are documented. Use when running security scans, auditing code, or checking for OWASP issues, injection risks, or sensitive data leaks. Automatically triggered on new modules, security-related changes, or post-refactor.

applying-ui-design-systemSkill

Frontend UI design system selector and implementation guide covering Glassmorphism, Liquid Glass (Apple-style), Neubrutalism, and Claymorphism. Use when building UI components, choosing a visual aesthetic, implementing design tokens, or auditing accessibility/contrast on themed surfaces. Provides per-style tokens, component patterns, dark mode, and a11y constraints.

architecting-securitySkill

安全架构与治理：威胁建模 (STRIDE/PASTA/LINDDUN)、零信任身份架构、IAM/SSO/MFA/PAM、合规框架 (SOC2/PCI/HIPAA/GDPR)、DLP、隐私工程、安全控制设计。Use when designing security architecture, threat modeling new systems, implementing zero-trust identity, designing IAM/SSO/PAM, building compliance evidence chains, or planning privacy-by-design.

automating-devopsSkill

DevOps knowledge reference covering Git workflows, testing strategies, DevSecOps, release pipeline orchestration (release.yml, multi-arch images, cosign integration), CI/CD pipelines, database management, observability, and performance optimization. Use when working with Git, CI/CD, release pipelines, ghcr image publishing, testing, monitoring, or infrastructure automation.

building-agent-systemsSkill

AI agent and LLM system engineering reference covering single-agent dev (ReAct, tool calling, plan-execute), multi-agent coordination (swarm, role decomposition, file locking), LLM security (prompt injection, jailbreak defense, output filtering), RAG architecture (chunking, hybrid retrieval, rerank), and prompt engineering / evaluation (RAGAS, LLM-as-Judge). Use when building AI agents, designing RAG pipelines, orchestrating multi-agent workflows, hardening LLM apps, or writing prompts.

checking-code-qualitySkill

Checks code quality metrics including complexity, duplication, naming conventions, and function length. Use when running quality gates, reviewing code smells, or checking lint rules. Automatically triggered on complex modules or post-refactor.

creating-presentationsSkill

Processes PowerPoint presentation files (.pptx). Creates slides, rewrites templates, converts HTML to presentations, validates thumbnails, swaps layouts, and performs deep OOXML editing. Use when working with presentation files or slide decks. Do NOT use for Word documents, spreadsheets, or PDF files.