excel-pivot-wizard

Create 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'.

Quality

—

Does it follow best practices?

Impact

—

No eval scenarios have been run

Securityby

Passed

No known issues

Quality

Content

57%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The body is well-organized with a clean step sequence and a properly signaled one-level reference, but the instructions stay abstract — describing capabilities rather than giving concrete executable syntax or validation checkpoints, with some redundancy between the Overview and description.

Suggestions

Inline a concrete calculated-field example (e.g., = 'Revenue' - 'Cost') in the Instructions rather than only deferring to the reference, so the core action is immediately executable.

Add an explicit validation checkpoint to the workflow (e.g., 'Verify the pivot refreshes and slicers filter all connected pivots before styling') to turn the step list into a verify-then-proceed sequence.

Trim the Overview/Prerequisites sections to remove content that restates the description or states obvious prerequisites Claude already knows.

Dimension	Reasoning	Score
Conciseness	The body is mostly lean and avoids explaining what a pivot table is, but the Overview repeats the description and the Prerequisites section ('Clear understanding of analysis dimensions and measures') pads with guidance Claude already knows.	2 / 3
Actionability	Steps like 'Configure rows, columns, values, and filters' and 'Add calculated fields for custom metrics' describe rather than instruct — there is no concrete formula syntax, UI path, or code in the body, with the executable detail deferred to the reference file.	2 / 3
Workflow Clarity	A clear six-step sequence is present, but there are no validation checkpoints or feedback loops; the Error Handling table is separate troubleshooting rather than embedded verify-then-proceed gating.	2 / 3
Progressive Disclosure	The body is a concise overview that signals one-level-deep navigation to the real ${CLAUDE_SKILL_DIR}/references/pivot-formulas.md file for calculated-field syntax, with content appropriately split and easy to locate.	3 / 3
	Total	9 / 12 Passed

Description

100%

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

The description is strong: it states concrete capabilities, gives an explicit 'Use when' trigger clause, and lists natural trigger phrases in third-person voice. It cleanly satisfies the what/when requirement with minimal padding.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions — 'Create advanced Excel pivot tables with calculated fields and slicers' — naming the domain and the specific capabilities, matching the anchor for listing several specific concrete actions.	3 / 3
Completeness	Clearly answers both what (create pivot tables with calculated fields and slicers) and when via an explicit 'Use when building data summaries or creating interactive dashboards' clause, with third-person voice and no first/second-person penalty.	3 / 3
Trigger Term Quality	Explicit trigger phrases 'excel pivot', 'create pivot table', 'data summary' are natural terms a user would say, giving good coverage of common variations.	3 / 3
Distinctiveness Conflict Risk	Excel pivot tables with calculated fields and slicers is a clear niche with distinct triggers ('excel pivot', 'create pivot table') unlikely to fire for unrelated skills.	3 / 3
	Total	12 / 12 Passed

Validation

87%

Warnings & errors only

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 14 / 16 Passed

Validation for skill structure

Criteria	Description	Result
allowed_tools_field	'allowed-tools' contains unusual tool name(s)	Warning
frontmatter_unknown_keys	Unknown frontmatter key(s) found; consider removing or moving to metadata	Warning

	Total	14 / 16 Passed

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 2cafb23

Reviewed: 2 days ago

Table of Contents

Discovery Implementation Validation

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.