CWICR Quantity Matcher

CWICR Quantity Matcher

Business Case

Problem Statement

BIM exports contain quantities but:

• Element categories don't match cost codes
• Manual mapping is error-prone
• Different naming conventions
• Need consistent code assignment

Solution

Intelligent matching of BIM element quantities to CWICR work items using category mapping, semantic matching, and rule-based assignment.

Business Value

• Automation - Reduce manual mapping effort
• Consistency - Standard code assignment
• Accuracy - Validated quantity linkage
• Integration - BIM-to-cost data flow

Technical Implementation

import pandas as pd
import numpy as np
from typing import Dict, Any, List, Optional, Tuple
from dataclasses import dataclass, field
from enum import Enum
import re
from difflib import SequenceMatcher


class MatchMethod(Enum):
    """Methods for matching BIM elements to work items."""
    EXACT = "exact"
    CATEGORY = "category"
    SEMANTIC = "semantic"
    RULE_BASED = "rule_based"
    MANUAL = "manual"