confronto

Name: confronto
Availability: InStock
Author: roycolumbia-code

Compare YoY shipment, revenue, cost, and MOL metrics from sped.db into an HTML report.

Updated Mar 23, 2026

Search Tags:#data visualization #financial metrics #HTML report #YoY comparison #shipment data

Ready to run

npx skills add https://github.com/roycolumbia-code/claude-global-config --skill confronto

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: confronto
Source: https://github.com/roycolumbia-code/claude-global-config/tree/main/skills/confronto
Command: npx skills add https://github.com/roycolumbia-code/claude-global-config --skill confronto

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3, and includes scripts (resource) components.

What problem does it solve?

This Skill provides a quick and comprehensive comparison of year-over-year shipment, revenue, cost, and MOL metrics between two specified months, facilitating data-driven decision-making.

Core Features & Use Cases

Year-Over-Year Comparison: Compare shipment, revenue, cost, and MOL metrics between any two months.
Dynamic Input: Accepts month and year combinations in various formats, including full month names and abbreviations, as well as 2-digit and 4-digit years.
Automated Data Extraction: Pulls data from the 'sped.db' database on the Mac mini and performs calculations to generate comparative metrics.
HTML Report Generation: Generates an HTML report with a dark theme, showcasing the comparison and insights.

Quick Start

Use the confronto command followed by "mese1 anno1 - mese2 anno2" (e.g., confronto "febbraio 2025 - febbraio 2026").

Frequently Asked Questions about confronto

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

FAQPage Schema

How do I generate an HTML report comparing YoY financial metrics between two months?▼

To generate an HTML report comparing YoY financial metrics, use the confronto command with two month-year pairs, such as confronto "febbraio 2025 - febbraio 2026". The tool calculates shipment, revenue, cost, and MOL metrics automatically.

What is the best way to compare shipment and revenue data from a SQLite database?▼

The best way to compare shipment and revenue data from a SQLite database is using a command-line tool that extracts metrics from your database file and generates a detailed HTML report for quick year-over-year analysis.

Can I use abbreviations or different year formats when specifying months for YoY comparison?▼

Yes, you can use abbreviations and different year formats for YoY comparison. The tool accepts full month names, abbreviations, and both 2-digit and 4-digit years, allowing flexible input like "feb 25 - feb 26".

Do I need Python and a specific database file to run year-over-year data comparisons?▼

Yes, you need Python and a specific SQLite database file named 'sped.db' to run year-over-year data comparisons. The script requires this database to extract shipment, revenue, cost, and MOL data for processing.

Does this data visualization tool work with SQLite databases stored on a Mac mini?▼

Yes, this data visualization tool works with SQLite databases stored on a Mac mini. It directly accesses the 'sped.db' file on the Mac mini to perform calculations and generate comparative metric reports.

What specific financial metrics are included in the year-over-year comparison report?▼

The specific financial metrics included in the year-over-year comparison report are shipment volume, revenue, cost, and MOL (Margin of Loss). These metrics are calculated from extracted data and displayed in a dark-themed HTML format.