google-sheets-cr5-analyzer
Calculates CR5 concentration indices for World Bank geographical regions from Google Sheets GDP data. Reads country and region data, maps countries to regions, identifies top 5 GDP countries per region, computes CR5 ratio, and creates a new spreadsheet with sorted results.
npx skills add majiayu000/claude-skill-registry --skill google-sheets-cr5-analyzer --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Skill: Google Sheets CR5 Analyzer ## Purpose Calculate the CR5 (Concentration Ratio of top 5) economic index for the seven major World Bank geographical regions using GDP data from Google Sheets. The skill reads source data, performs calculations, and outputs results to a new spreadsheet. ## Trigger Phrases - "Calculate CR5 index" - "Concentration ratio analysis" - "Top 5 countries by GDP per region" - "World Bank regional GDP concentration" - "CR5 analysis from Google Sheets" - "Regional economic concentration metrics" ## Required Input Data Structure The skill expects a Google Sheets spreadsheet containing: 1. **Country sheet**: Must include columns for Country Code, Country Name, and GDP (in millions of US dollars) 2. **Region sheet**: Must include columns for Region Code, Region Name, and Regional GDP total ## Core Workflow ### 1. Data Acquisition - Locate the source spreadsheet by title or ID - Read both Country and Region sheet data - Extract country names, GDP values, and regional totals ### 2. Country-Region Mapping - Use the World Bank's official geographical classification for 7 regions: - East Asia & Pacific (EAS) - Europe & Central Asia (ECS) - Latin America & Caribbe
- Purpose
- Trigger Phrases
- Required Input Data Structure
- Core Workflow
- 1. Data Acquisition
- 2. Country-Region Mapping
- 3. CR5 Calculation
- 4. Output Generation
- Error Handling
- Quality Checks
- Notes
What does the google-sheets-cr5-analyzer skill do?
Calculates CR5 concentration indices for World Bank geographical regions from Google Sheets GDP data. Reads country and region data, maps countries to regions, identifies top 5 GDP countries per region, computes CR5 ratio, and creates a new spreadsheet with sorted results.
How do I install it?
Run `npx skills add majiayu000/claude-skill-registry --skill google-sheets-cr5-analyzer --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From majiayu000/claude-skill-registry, a repository with 534 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.