skills.rest
roycolumbia-code
roycolumbia-codeCOMMUNITY
Explore all skills by this author →
GitHub

confronto

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
One-click install
npx skills add https://github.com/roycolumbia-code/claude-global-config --skill confronto
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
dankoflydankofly

codebase-navigator

Map code symbols, API endpoints, and data flows across a monorepo.

Community
Intermediate
OpenLaborOpenLabor
4

Financial Reports

Generate standardized financial reports from accounting data with variance analysis.

Official
Intermediate
roycolumbia-coderoycolumbia-code

analisi-spedizioni

Analyze SQLite transportation database data for shipment counts, margins, and breakdowns.

Community
Intermediate
GratefulJinx77GratefulJinx77

AnnualReports

Aggregate and analyze annual security reports from major vendors.

Community
Advanced