In modern mechanical design environments, frequent design changes make maintaining consistency between CAD data and BOM(Bill of Materials) a significant challenge. In Excel-based BOM management environments, designers often need to manually update 3D assembly models and 2D drawings whenever component information changes, leading to human errors and increased design lead time. This study proposes a reverse data synchronization automation system integrating the CATIA Automation API with Excel macros. When a BOM is modified, the system automatically detects and applies the changes. Using the NewFrom method and a recursive traversal algorithm, the assembly structure can be safely regenerated without reference-link breakage. Experimental results using an assembly model with 72 sub-components showed that the time required for design modification and drawing updates was reduced from approximately 60 minutes to under 2 minutes, achieving about 97% time savings. In addition, the system prevented title block input errors and reference-link failures, ensuring data integrity. The proposed framework provides a practical and cost-effective alternative for implementing a Digital Thread environment without expensive PLM(Product Lifecycle Management) systems.

Abstract
1. 서 론
2. BOM 및 설계 변경 관리 체계
    2.1 BOM(Bill of Materials)의 개념과 역할
    2.2 설계 변경과 데이터 정합성 문제
3. BOM-CAD 동기화 자동화 시스템 설계및 구현
    3.1 시스템 아키텍쳐 및 작업 흐름
    3.2 양방향 데이터 동기화 기반 BOM 추출 및 엑셀 연동
    3.3 파생 객체 기반 3D 모델 재생성 및 재귀적링크 복구 알고리즘
    3.4 표준 도면 자동 생성 및 속성 매핑BOM
4. 자동화 시스템 실험 및 성능 분석
    4.1 실험 모델의 구성 및 복잡도
    4.2 마이크로 프로세스 단위 알고리즘 구동 및 성능 추적
    4.3 데이터 정합성 검증 및 시스템 무결성 고찰
    4.4 실질적 성능 지표 비교 분석
5. 결 론
References

• 이현석(Development of HW, NSquare Company) | Hyun-Seok Lee
• 이정훈(professor, Dept. of Control & Robotics Engineering, Gyeongsang National University) | Jung-Hoon Lee Corresponding author