skills.rest
alongor666
alongor666COMMUNITY
Explore all skills by this author →
GitHub

kpi-calculator

Calculate 16 car insurance KPIs from cumulative weekly CSV data.

2|Updated Nov 2, 2025
Search Tags:#business intelligence#data aggregation#performance analysis#KPI calculation#margin contribution#financial metrics#car insurance#loss ratio
One-click install
npx skills add https://github.com/alongor666/chexianduoweifenxi --skill kpi-calculator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: kpi-calculator
Source: https://github.com/alongor666/chexianduoweifenxi/tree/main/.claude/skills/kpi-calculator
Command: npx skills add https://github.com/alongor666/chexianduoweifenxi --skill kpi-calculator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the complex and precise calculation of 16 core car insurance Key Performance Indicators (KPIs) from cumulative weekly CSV data. It eliminates manual spreadsheet errors and ensures consistent, accurate metrics for business performance evaluation, saving significant time for financial analysts.

Core Features & Use Cases

  • 16 Core KPI Calculations: Accurately computes critical metrics like Matured Margin Contribution Rate, Premium Time Progress Achievement Rate, Matured Loss Ratio, and Average Premium per Policy.
  • Cumulative & Incremental Modes: Supports both year-to-date cumulative data processing and week-over-week incremental analysis, with clear rules for ratio calculations.
  • Robust Data Handling: Accepts raw CSV data, performs necessary aggregation, and applies safe division for robust results.
  • Standardized Output: Generates a clear, structured Markdown report of all KPIs, including calculation verifications.
  • Use Case: A finance team needs to quickly assess the weekly performance of the car insurance business. They upload the latest cumulative CSV data, and this skill instantly provides a comprehensive report of all 16 KPIs, highlighting key financial and operational metrics without any manual calculation.

Quick Start

Calculate the KPIs for the attached 'weekly_cumulative_data.csv' file.

Frequently Asked Questions about kpi-calculator

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

FAQPage Schema
How do I calculate KPIs from weekly cumulative CSV data for car insurance?▼

KPI calculation from cumulative CSV data automates the derivation of 16 core insurance metrics—including Matured Margin Contribution Rate, Matured Loss Ratio, and Average Premium per Policy—from weekly aggregates. This Skill processes raw CSV, applies safe division and unit conversions, and outputs a structured report without manual spreadsheet work.

What's the difference between cumulative and incremental KPI calculation modes?▼

Cumulative mode processes year-to-date aggregated data to compute rolling KPIs, while incremental mode calculates week-over-week changes. The Skill supports both, with distinct ratio calculation rules for each, enabling finance teams to track performance by either total progress or weekly variation.

Can I use this for business intelligence and performance analysis of insurance metrics?▼

Yes. This Skill is designed for business intelligence workflows, aggregating financial and operational metrics—margin contribution, loss ratio, premium progress, and 12 others—into a single report. It fits performance analysis at scale by eliminating manual calculation errors and providing data-driven KPI summaries instantly.

What data format and structure do I need to provide?▼

Provide weekly cumulative data as a CSV file containing the raw insurance metrics required for the 16 KPI formulas. The Skill handles data aggregation, applies necessary transformations, and ensures alignment with existing KPI engine formulas through standardized input validation.

How does this Skill handle division by zero or missing data?▼

The Skill uses safe division logic to prevent errors when denominators are zero or data is incomplete. It applies robust data handling techniques to ensure accurate ratio calculations even with gaps, maintaining calculation integrity across both cumulative and incremental modes.

Related Skills

Explore More Finance & Accounting Skills→
alongor666alongor666
2

weekly-kpi-report

Extract, validate, and calculate KPIs from weekly auto insurance data into a McKinsey-style PPT report.

Community
Advanced
2nth-ai2nth-ai
1

fin/reporting

Automate financial KPI extraction, calculation, and reporting from ERP and CRM systems.

Official
Advanced
hoanghd218hoanghd218

xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with formulas and pivot tables.

Community
Intermediate
davekim917davekim917
1

analytics

Analyze dashboards, metrics, and BI artifacts for clarity and accuracy.

Community
Advanced