skills.rest
Wizarck
WizarckCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

cpq

Generates CPQ pricing calculator Excel specs from commercial playbook rate cards.

2|Updated Apr 19, 2026
Search Tags:#openpyxl#excel#cpq#rate card#margin formulas#pricing calculator#quote generation
One-click install
npx skills add https://github.com/Wizarck/nexandro --skill cpq-wizarck
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cpq
Source: https://github.com/Wizarck/nexandro/tree/main/skills/cpq
Command: npx skills add https://github.com/Wizarck/nexandro --skill cpq-wizarck

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve? Building a Configure-Price-Quote calculator by hand from a commercial playbook is error-prone: prices drift from the published rate card, margin formulas get misapplied, and volume discount logic is inconsistent. This Skill derives a CPQ calculator spec directly from the offering's COMMERCIAL_PLAYBOOK.md and LEAN_BUSINESS_CASE.md so every price traces back to the approved rate card. ## Core Features & Use Cases - Rate Card Extraction: Parses published rates, volume discount schedules, and bundle pricing logic from COMMERCIAL_PLAYBOOK.md sections. - Three-Sheet Calculator Design: Produces Input, Calculator, and Quote Output sheet layouts with Excel formulas, validation rules, and conditional formatting. - Optional .xlsx Generation: Generates the actual Excel file via openpyxl when available, otherwise delivers a markdown specification. - QA Gate: Runs a financial QA validation pass with a maximum of two rework cycles before escalating. - Use Case: Given an offering folder like OFFER-001, produce a CPQ_CALCULATOR.xlsx whose prices, margins, and discounts exactly match the commercial playbook, ready for IOF/COF quote generation. ## Quick Start Run the cpq skill with argument 001 to generate the CPQ calculator spec for offering OFFER-001 from its commercial playbook.

Frequently Asked Questions about cpq

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a CPQ pricing calculator from a rate card?▼

Invoke the skill with the offering number, and it parses the COMMERCIAL_PLAYBOOK.md rate card, volume discounts, and bundle logic to produce a three-sheet calculator spec with Excel formulas, validation rules, and a quote output layout.

How to generate an Excel pricing calculator with openpyxl?▼

The skill writes a markdown calculator specification first, then optionally generates the actual CPQ_CALCULATOR.xlsx file using openpyxl if the library is available in the environment. Without openpyxl, the markdown spec is the deliverable.

What inputs does the CPQ calculator skill require?▼

It requires an offering folder containing COMMERCIAL_PLAYBOOK.md with published rates and discount schedules, plus LEAN_BUSINESS_CASE.md section 4.5 for SKU pricing inputs. If the playbook is missing, the skill cannot proceed and asks the user.

Does the CPQ calculator support multiple currencies?▼

Yes, if the commercial playbook defines multiple currencies, the generated calculator includes currency selection with FX conversion logic. Currency support is derived from the playbook rather than hardcoded.

What happens if the CPQ calculator fails QA validation?▼

The skill invokes a financial QA gate after generation. If issues are found, it follows a reflection loop with a maximum of two rework cycles, then pauses and escalates to the user rather than looping indefinitely.

Related Skills

Explore More Marketing & Sales Skills→
WizarckWizarck
2

cpq

Generates CPQ pricing calculator Excel specs from commercial playbook rate cards.

Community
Intermediate
modu-aimodu-ai
267

proposal-maker

Generate Korean B2B proposals, quotes, and contract drafts in .docx, .pptx, .xlsx, and .pdf formats.

Official
Intermediate
WizarckWizarck

commercial-playbook

Create a commercial playbook defining pricing, licensing, and channel economics.

Community
Advanced
skills-ilskills-il
6

israeli-paid-ads

Plan and optimize paid advertising campaigns for the Israeli market across multiple platforms.

Official
Advanced