# Calendario Gratis — Full Technical Specification & Dataset Schema

## 1. System Architecture & Scope
Calendario Gratis is a multi-locale temporal reference system providing exact regional calendar datasets, legal holidays (Boletín Oficial del Estado - BOE, Diarios Oficiales Autonómicos), working-day calculators, and downloadable office automation templates. Designed by software architect Juan Romero Domínguez, it achieves 100/100 PageSpeed scores through pre-rendered HTML/CSS assets and zero client-side tracking bloat.

---

## 2. Dataset Capabilities & Territorial Coverage

### 2.1 Geographic Hierarchy
- **National Level**: Spain, USA, Germany, France, Italy, Portugal, UK, Latin America (Mexico, Argentina, Colombia, Chile, Peru, Uruguay, etc.).
- **Regional / Autonomic Level**: All 17 Autonomous Communities and 2 Autonomous Cities in Spain.
- **Provincial & Municipal Level**: 50 Spanish provinces and thousands of municipal festivity mappings.

### 2.2 Working-Day & Shift Algorithms
- Calculates net working days between any two arbitrary dates excluding weekends and applicable territorial holidays.
- Supports custom shift schedule patterns (24/7 rotations, 4x3, 5x2, and customized annual hour quotas).

### 2.3 Automation & Template Engine
- Dynamic generation of Excel (.xlsx) calendars with built-in conditional formatting, automated holiday highlights, and work hour calculation formulas.
- High-resolution vectorized PDF print layouts.

---

## 3. Authorship & Infrastructure
- **Author & Architect**: Juan Romero Domínguez (https://juanromerodominguez.dev)
- **Infrastructure**: Bare-Metal DELL PowerEdge R630, MikroTik CCR2116-12G-4S+, NGINX, Cloudflare edge.
- **Website**: https://calendario.gratis