excel-to-bim

# Excel to BIM Update ## Business Case ### Problem Statement After extracting BIM data to Excel and enriching it (cost codes, classifications, custom data): - Changes need to flow back to the BIM model - Manual re-entry is error-prone - Updates must match by element ID ### Solution Push Excel data back to BIM models, updating element parameters and properties from spreadsheet changes. ### Business Value - **Bi-directional workflow** - BIM → Excel → BIM - **Bulk updates** - Change thousands of parameters - **Data enrichment** - Add classifications, codes, costs - **Consistency** - Spreadsheet as single source of truth ## Technical Implementation ### Workflow ``` BIM Model (Revit/IFC) → Excel Export → Data Enrichment → Excel Update → BIM Model ``` ### Python Implementation ```python import pandas as pd from pathlib import Path from typing import Dict, Any, List, Optional, Tuple from dataclasses import dataclass, field from enum import Enum import json class UpdateType(Enum): """Type of BIM parameter update.""" TEXT = "text" NUMBER = "number" BOOLEAN = "boolean" ELEMENT_ID = "element_id" @dataclass class ParameterMapping: """Mapping between Excel column and BIM parameter.""" excel_column: str bim_parameter: str update_type: UpdateType transform: Optional[str] = None # Optional transformation @dataclass class UpdateResult: """Result of single element update.""" element_id: str parameters_updated: List[str] suc...