# bbrunossf/orcaobras architecture

> Architecture diagram of the GitHub repository bbrunossf/orcaobras, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-04-23). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/bbrunossf/orcaobras
- Repository: https://github.com/bbrunossf/orcaobras

## Overview

##### Project type and purpose
- This is a small Python‑based data‑processing tool (essentially a CLI/desktop “budget‑calculator” utility) that:
- Reads construction unit‑price data from a SINAPI Excel sheet
- Presents an interactive interface for the user to pick service groups and specify quantities
- Computes unit and total costs and writes out a result table

##### File structure
- Top level contains only two Python scripts (13-04 de casa.py, 13-04casa.py), the data file (SINAPI.xls), a requirements.txt and README.md
- No separate frontend/backend folders—this is a single‑process, single‑module or dual‑script application
- requirements.txt will list your Python dependencies (likely pandas/openpyxl for Excel I/O, maybe tabulate or click for CLI)

##### README for additional insights
- Confirms the workflow: load → filter by group → collect qty → compute → output

##### Diagramming recommendations
- Blue for Data layer (Excel file, reader)
- Green for Business Logic
- Orange for UI/Presentation
- Gray for External dependencies
- Rectangles for processing modules
- Parallelograms for I/O components

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Data Layer
    DataSource["SINAPI.xls"]:::data
    ExcelReader["Excel Reader<br/>(pandas/openpyxl)"]:::data

    %% Business Logic
    BusinessLogic["Business Logic Layer<br/>(filtering, calculations)"]:::logic

    %% Presentation Layer
    UI["User Interface<br/>(CLI prompts/input)"]:::ui

    %% Output Layer
    Exporter["Output Generation<br/>(tabulate/Excel export)"]:::logic

    %% External & Docs
    ExternalDeps["External Dependencies<br/>(requirements.txt)"]:::ext
    Documentation["Project Documentation<br/>(README.md)"]:::ext

    %% Flow
    DataSource -->|"loads Excel sheet"| ExcelReader
    ExcelReader -->|"provides raw data"| BusinessLogic
    UI -->|"user selections"| BusinessLogic
    BusinessLogic -->|"computed items & totals"| UI
    BusinessLogic -->|"result dataset"| Exporter
    Exporter -->|"writes console/Excel"| Documentation

    ExternalDeps -.-> DataSource
    ExternalDeps -.-> ExcelReader
    ExternalDeps -.-> BusinessLogic
    ExternalDeps -.-> UI
    ExternalDeps -.-> Exporter

    %% Click Events
    click DataSource "https://github.com/bbrunossf/orcaobras/blob/master/SINAPI.xls"
    click ExcelReader "https://github.com/bbrunossf/orcaobras/blob/master/13-04 de casa.py"
    click BusinessLogic "https://github.com/bbrunossf/orcaobras/blob/master/13-04 de casa.py"
    click UI "https://github.com/bbrunossf/orcaobras/blob/master/13-04 de casa.py"
    click Exporter "https://github.com/bbrunossf/orcaobras/blob/master/13-04 de casa.py"
    click ExternalDeps "https://github.com/bbrunossf/orcaobras/blob/master/requirements.txt"
    click Documentation "https://github.com/bbrunossf/orcaobras/blob/master/README.md"

    %% Styles
    classDef data fill:#bbdefb,stroke:#1e88e5,color:#0d47a1;
    classDef logic fill:#c8e6c9,stroke:#43a047,color:#1b5e20;
    classDef ui fill:#ffe0b2,stroke:#fb8c00,color:#e65100;
    classDef ext fill:#eeeeee,stroke:#757575,color:#424242;
```
