excel-pivot-wizard
tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill excel-pivot-wizardCreate advanced Excel pivot tables with calculated fields and slicers. Use when building data summaries or creating interactive dashboards. Trigger with phrases like 'excel pivot', 'create pivot table', 'data summary'.
Validation
81%| Criteria | Description | Result |
|---|---|---|
allowed_tools_field | 'allowed-tools' contains unusual tool name(s) | Warning |
metadata_version | 'metadata' field is not a dictionary | Warning |
frontmatter_unknown_keys | Unknown frontmatter key(s) found; consider removing or moving to metadata | Warning |
Total | 13 / 16 Passed | |
Implementation
42%This skill provides good structure and organization but fails on actionability - the core instructions are too abstract to be useful. Claude needs concrete examples of calculated field formulas, specific slicer configuration steps, and actual Excel operations rather than high-level descriptions of what a pivot table should contain.
Suggestions
Add concrete calculated field formula examples (e.g., '=Revenue/Units for unit price, =[Sales]-[Cost] for margin')
Include specific step-by-step instructions for slicer creation and connection to pivot tables
Provide actual Excel menu paths or VBA/Office Scripts code for programmatic pivot creation
Add a validation checkpoint after pivot creation to verify data aggregations are correct before adding calculated fields
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | Content is reasonably efficient but includes some unnecessary sections like 'Prerequisites' that state obvious requirements Claude would know. The structure is clean but could be tighter. | 2 / 3 |
Actionability | Instructions are vague and abstract ('Create pivot table from data range', 'Configure rows, columns, values'). No concrete code, formulas, or step-by-step executable guidance. Describes what to do rather than how to do it. | 1 / 3 |
Workflow Clarity | Steps are listed in sequence but lack validation checkpoints. No verification steps between creating the pivot and adding calculated fields. Error handling table is helpful but reactive rather than preventive. | 2 / 3 |
Progressive Disclosure | Well-organized sections with clear headers. References external resource appropriately (pivot-formulas.md). Content is appropriately scoped for a SKILL.md overview without being monolithic. | 3 / 3 |
Total | 8 / 12 Passed |
Activation
100%This is a well-crafted skill description that excels across all dimensions. It provides specific capabilities (pivot tables, calculated fields, slicers), clear use cases (data summaries, interactive dashboards), and explicit trigger phrases. The description uses proper third-person voice and maintains a clear, distinct niche that minimizes conflict risk with other skills.
| Dimension | Reasoning | Score |
|---|---|---|
Specificity | Lists multiple specific concrete actions: 'Create advanced Excel pivot tables with calculated fields and slicers.' This clearly describes concrete capabilities including pivot tables, calculated fields, and slicers. | 3 / 3 |
Completeness | Clearly answers both what (create pivot tables with calculated fields and slicers) AND when (building data summaries, creating interactive dashboards) with explicit trigger guidance in a dedicated 'Trigger with phrases' clause. | 3 / 3 |
Trigger Term Quality | Explicitly includes natural trigger phrases users would say: 'excel pivot', 'create pivot table', 'data summary'. Also mentions 'interactive dashboards' and 'data summaries' which are common user terms. | 3 / 3 |
Distinctiveness Conflict Risk | Clear niche focused specifically on Excel pivot tables with distinct triggers like 'excel pivot' and 'create pivot table'. Unlikely to conflict with general Excel skills or other data tools due to specific pivot table focus. | 3 / 3 |
Total | 12 / 12 Passed |
Reviewed
Table of Contents
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.