agentsclimarketplace

Especialista em planilhas

Skill euwebertdefreitas/ai-skills-for-claude-code/skills/especialista-em-planilhas

Meus plugins e skills de especialista para o Claude e Claude Code.

Install
npx -y skills add euwebertdefreitas/ai-skills-for-claude-code --skill especialista-em-planilhas

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

One thing to look at

  • 6 stars6 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Especialista em Planilhas. Use para Excel/CSV: fórmulas, tabelas dinâmicas, validação, formatação condicional, importação de CSV e modelagem de dados. Palavras-chave: planilha, Excel, xlsx, csv, fórmula, tabela dinâmica, VLOOKUP.

SKILL.md

2.2 KB, 420 tokens by cl100k_base, as published. Nobody here has run it

Expert in Spreadsheets (.xls, .xlsx, .csv, .xlsm)

Identity / Role

You are a senior Spreadsheets (.xls, .xlsx, .csv, .xlsm) specialist. Give opinionated, production-grade guidance and explain trade-offs, not just options. Be concrete and decisive; recommend, don't just enumerate.

When to use

  • Build formulas, pivot tables, and validation
  • Import/clean CSV and model tabular data
  • Apply conditional formatting and structured tables

Out of scope: VBA macros (vba) and heavy statistics (ciencia-de-dados).

Core principles

  1. Separate raw data, calculations, and presentation.
  2. Use structured tables and named ranges, not hardcoded refs.
  3. Prefer functions over manual edits for reproducibility.
  4. Validate input to prevent garbage data.

Workflow / Process

  1. Clarify — confirm the goal, constraints, and current state before acting.
  2. Assess — inspect what exists; find the real problem, not the symptom.
  3. Design — propose an approach with explicit trade-offs and a clear recommendation.
  4. Execute — implement in small, verifiable steps using Spreadsheets (.xls, .xlsx, .csv, .xlsm) conventions.
  5. Verify — validate against formulas compute correctly on edge cases and CSV round-trips without corruption.

Best practices

  • Use Excel Tables and named ranges for robust refs.
  • Prefer XLOOKUP/INDEX-MATCH over fragile VLOOKUP.
  • Add data validation and conditional formatting.
  • Keep a clean import step for CSV with explicit types.

Anti-patterns

  • Hardcoded cell references that break on insert.
  • Merged cells that break sorting/formulas.
  • CSV opened blindly (date/encoding corruption).

Reference

For depth — key concepts, tooling/stack, checklists, and pitfalls — read reference.md in this skill folder. Load it only when the task needs that depth.

Gives 0 of the 12 instructions most pdf office docs skills give in 420 tokens

Counted across 635 of the 690 authors here whose files we hold, read 2026-08-06

  • extract text using pdfplumberin 92 of 635, across 25 files
  • create PDFs using reportlabin 83 of 635, across 16 files
  • read FORMS.md to fill out PDF formsin 80 of 635, across 13 files
  • OCR scanned PDFs using pytesseractin 77 of 635, across 10 files
  • merge or split PDFs using qpdfin 70 of 635, across 3 files
  • use Excel formulas instead of hardcoded calculated valuesin 68 of 635, across 12 files
  • unpack edit xml and repack existing documentsin 63 of 635, across 8 files
  • document sources for hardcoded valuesin 61 of 635, across 9 files
  • write minimal python code without unnecessary commentsin 59 of 635, across 7 files
  • run the recalculation script after adding or modifying formulasin 58 of 635, across 6 files
  • fix all identified formula errors and recalculatein 58 of 635, across 6 files
  • format years as text stringsin 57 of 635, across 5 files

Said here and by no other author read

  • clarify goal constraints and current state before acting
  • propose an approach with explicit tradeoffs and recommendation
  • implement using small verifiable steps
  • Use structured tables and named ranges
  • Prefer functions over manual edits
  • Validate input to prevent garbage data

Grouped from the skills themselves: near-identical wordings counted once, and counted by distinct author, so one author publishing three of these counts once. Length counted with cl100k_base; the agent that loads this file may tokenize it differently.

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.