¿100 CFDI en 40 segundos? Valida XML del SAT con Excel

Imagen
🤯 ¿100 CFDI en 40 segundos? Automatiza la validación de XML con Excel ¿Cuánto tiempo dedicas a revisar archivos XML de facturas electrónicas? Si trabajas con contabilidad, cuentas por pagar, cuentas por cobrar o administración, sabes que validar muchos comprobantes fiscales puede convertirse en una tarea repetitiva. 🚀 ¿Y si pudieras procesar 100 archivos XML en aproximadamente 40 segundos? En esta demostración utilizo una macro de Excel diseñada para automatizar la validación masiva de CFDI y consultar su estado ante el Servicio de Administración Tributaria (SAT). 📊 ¿Qué hace esta macro de Excel? La herramienta permite seleccionar una carpeta con archivos XML y procesar múltiples comprobantes sin tener que revisarlos individualmente. Procesa varios archivos XML de CFDI. Extrae información de los comprobantes fiscales. Consulta el estado de los CFDI ante el servicio del SAT....

Can Data Measure Football Excitement? Ranking FIFA World Cup 2026 Matches with Python

Can Data Measure Football Excitement? Ranking FIFA World Cup 2026 Matches with Python

When fans remember a great football match, they usually think about unforgettable goals, dramatic comebacks and emotional moments. But from a Sports Analytics perspective, another question appears.

Can we measure how exciting a football match was using only data?

In this project I analyzed the FIFA World Cup 2026 using Python, Pandas and Matplotlib to create a simple metric called Excitement Score.


Dataset

The analysis uses the Football World Cup 2026 Dataset from Kaggle containing:

  • Match events
  • Expected Goals (xG)
  • Possession
  • Shots
  • Shots on target
  • Big Chances
  • Player information
  • Momentum

Dataset: Football World Cup 2026 Dataset


Building the Excitement Score

Goals alone do not tell the whole story. I combined multiple offensive statistics into a simple metric.

Excitement Score =
Shots
+ (Big Chances × 2)
+ (Goals × 3)

The weights are intentionally simple and can easily be adjusted for future experiments.


Top 15 Most Exciting Matches

Using the Excitement Score, every match was ranked according to its offensive production.



  • X-axis: Shots Inside the Box
  • Y-axis: Shots on Target
  • Bubble Size: Goals
  • Bubble Color: Big Chances

Does the Model Match My Favorite Games?

After generating the ranking, I compared it with the matches I personally enjoyed the most.

  1. 🇦🇷 Argentina vs 🇨🇻 Cape Verde
  2. 🇲🇽 Mexico vs 🏴 England
  3. 🇳🇱 Netherlands vs 🇯🇵 Japan
  4. 🇪🇸 Spain vs 🇦🇷 Argentina
  5. 🏴 England vs 🇫🇷 France
  6. 🇪🇸 Spain vs 🇧🇪 Belgium
  7. 🇪🇸 Spain vs 🇨🇻 Cape Verde
  8. 🇪🇬 Egypt vs 🇦🇷 Argentina
  9. 🇳🇴 Norway vs 🏴 England
  10. 🇳🇴 Norway vs 🇸🇳 Senegal



Several of my favorite matches also received high Excitement Scores, suggesting that offensive statistics capture an important part of what fans perceive as an exciting game.


Key Findings

  • More goals do not always mean a more exciting match.
  • Big Chances strongly influence match excitement.
  • Simple analytics can identify memorable games.
  • Sports Analytics complements, rather than replaces, the fan experience.

Technology Stack

  • Python
  • Pandas
  • NumPy
  • Matplotlib
  • Jupyter Notebook

GitHub Repository

The complete project includes data preparation, feature engineering, Excitement Score calculation and visualization code.

GitHub: GITHUB_URL


Final Thoughts

This experiment shows that even a simple metric based on football statistics can identify many of the matches fans remember as the most entertaining.

Future versions could include xG, match momentum, cards, game state and win probability to build a more advanced model.

How would you build an Excitement Score? Which variables would you include?

Comentarios

🚀 Mantener este blog funcionando requiere tiempo y café. ¡Puedes contribuir con uno aquí!

Entradas más populares de este blog

Guía Práctica: Ejemplo Completo de ASPX para Desarrolladores Web

👉 Cómo obtener el tipo de cambio en Excel con API de Banxico (paso a paso)

Cómo crear un Predictor de Partidos de Fútbol con JavaScript y API-Football