cwicr-material-substitution

# CWICR Material Substitution ## Business Case ### Problem Statement Material substitution challenges: - Supply chain issues - Cost optimization - Specification compliance - Equivalent performance ### Solution Systematic material substitution using CWICR data to find functionally equivalent alternatives with cost and performance analysis. ### Business Value - **Supply flexibility** - Alternative sources - **Cost savings** - Lower-cost equivalents - **Compliance** - Specification matching - **Quick decisions** - Rapid alternative search ## Technical Implementation ```python import pandas as pd import numpy as np from typing import Dict, Any, List, Optional, Tuple from dataclasses import dataclass from enum import Enum from difflib import SequenceMatcher class SubstitutionType(Enum): """Types of substitution.""" DIRECT = "direct" # Drop-in replacement EQUIVALENT = "equivalent" # Same function, different material UPGRADE = "upgrade" # Better performance DOWNGRADE = "downgrade" # Lower performance (cost saving) class CompatibilityLevel(Enum): """Compatibility levels.""" EXACT = "exact" # Identical specs HIGH = "high" # Minor differences MEDIUM = "medium" # Requires review LOW = "low" # Significant differences @dataclass class MaterialSubstitute: """Material substitution option.""" original_code: str original_description: str substitute_code: str substitute...