# austintropa/integrativaprogramacion architecture

> Architecture diagram of the GitHub repository austintropa/integrativaprogramacion, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/austintropa/integrativaprogramacion
- Repository: https://github.com/austintropa/integrativaprogramacion

## Overview

A small Python script for inspecting an Excel workbook and validating its weekly sales data. On execution, it prints workbook sheet summaries, reads the Ventas sheet, checks required columns and quantities, builds a product-by-week sales matrix, and prints the result. The workbook is the local data source and printed text is the output. The repository also contains a separate CSV-printing example, but it is not part of the main workflow.

Main entry points: [`main.py`](https://github.com/austintropa/integrativaprogramacion/blob/main/main.py) (Script entry), [`02_CodigoPrueba/main.py`](https://github.com/austintropa/integrativaprogramacion/blob/main/02_CodigoPrueba/main.py) (CSV example), [`datos/tienda.xlsx`](https://github.com/austintropa/integrativaprogramacion/blob/main/datos/tienda.xlsx) (Store workbook), [`02_CodigoPrueba/paquetes.csv`](https://github.com/austintropa/integrativaprogramacion/blob/main/02_CodigoPrueba/paquetes.csv) (Package CSV)

## Diagram (Mermaid)

```mermaid
flowchart TD

node_user(("User"))
node_runner["Script entry<br/>[main.py]"]
node_workbook_summary["Sheet summaries<br/>[main.py]"]
node_sales_reader["Sales reader<br/>[main.py]"]
node_matrix_builder["Matrix validation<br/>[main.py]"]
node_workbook[("Store workbook<br/>[tienda.xlsx]")]
node_console["Console output"]
node_csv_example["CSV example<br/>[main.py]"]
node_csv_data[("Package CSV<br/>[paquetes.csv]")]

node_user -.->|"runs"| node_runner
node_runner -->|"calls"| node_workbook_summary
node_workbook_summary -->|"reads"| node_workbook
node_workbook_summary -->|"prints"| node_console
node_runner -->|"reads"| node_sales_reader
node_sales_reader -->|"loads Ventas"| node_workbook
node_runner -->|"calls"| node_matrix_builder
node_matrix_builder -->|"prints matrix"| node_console
node_csv_example -->|"reads"| node_csv_data
node_csv_example -->|"prints data"| node_console

click node_runner "https://github.com/austintropa/integrativaprogramacion/blob/main/main.py"
click node_workbook_summary "https://github.com/austintropa/integrativaprogramacion/blob/main/main.py"
click node_sales_reader "https://github.com/austintropa/integrativaprogramacion/blob/main/main.py"
click node_matrix_builder "https://github.com/austintropa/integrativaprogramacion/blob/main/main.py"
click node_workbook "https://github.com/austintropa/integrativaprogramacion/blob/main/datos/tienda.xlsx"
click node_csv_example "https://github.com/austintropa/integrativaprogramacion/blob/main/02_CodigoPrueba/main.py"
click node_csv_data "https://github.com/austintropa/integrativaprogramacion/blob/main/02_CodigoPrueba/paquetes.csv"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_user toneBlue
class node_runner,node_workbook_summary,node_sales_reader,node_matrix_builder,node_csv_example toneTeal
class node_workbook,node_csv_data toneAmber
class node_console toneIndigo
```

## Components

### Other components

- **User**
- [Script entry](https://github.com/austintropa/integrativaprogramacion/blob/main/main.py): `main.py`
- [Sheet summaries](https://github.com/austintropa/integrativaprogramacion/blob/main/main.py): `main.py`
- [Sales reader](https://github.com/austintropa/integrativaprogramacion/blob/main/main.py): `main.py`
- [Matrix validation](https://github.com/austintropa/integrativaprogramacion/blob/main/main.py): `main.py`
- [Store workbook](https://github.com/austintropa/integrativaprogramacion/blob/main/datos/tienda.xlsx): `datos/tienda.xlsx`
- **Console output**
- [CSV example](https://github.com/austintropa/integrativaprogramacion/blob/main/02_CodigoPrueba/main.py): `02_CodigoPrueba/main.py`
- [Package CSV](https://github.com/austintropa/integrativaprogramacion/blob/main/02_CodigoPrueba/paquetes.csv): `02_CodigoPrueba/paquetes.csv`

## Connections

- User → Script entry: runs
- Script entry → Sheet summaries: calls (evidence: `main.py`)
- Sheet summaries → Store workbook: reads (evidence: `main.py`)
- Sheet summaries → Console output: prints (evidence: `main.py`)
- Script entry → Sales reader: reads (evidence: `main.py`)
- Sales reader → Store workbook: loads Ventas (evidence: `main.py`)
- Script entry → Matrix validation: calls (evidence: `main.py`)
- Matrix validation → Console output: prints matrix (evidence: `main.py`)
- CSV example → Package CSV: reads (evidence: `02_CodigoPrueba/main.py`)
- CSV example → Console output: prints data (evidence: `02_CodigoPrueba/main.py`)
