Automatización del proceso de elaboración de Fiber Routing mediante VBA y extracción de atributos desde AutoCAD en redes FTTH

Abstract

The deployment of passive optical networks (FTTH) requires accurate documentation management to certify the constructed infrastructure. In the COLOMBIA Claro FTTH 2024 project by Huawei Technologies, creating the Fiber Routing report is essential to organize the physical topology, installed passive elements, and their capacity. However, this process was traditionally done by manually typing attributes from AutoCAD drawings into Excel templates. This manual work caused long processing times and a high risk of typing errors. To solve this problem, this degree thesis aims to propose and develop an automation tool to optimize the creation of this deliverable. The methodology includes three main phases: first, designing a parameterization interface in Excel that automatically generates the work template based on selected equipment; second, extracting data from topological AutoCAD drawings using the native ATTOUT command; and third, implementing a VBA algorithm to match names and clean references, isolating metric distances and removing redundant rows. The results from pilot tests show a reduction in processing times and a direct decrease in typing errors, which helps reduce mistakes and rejections during quality audits by the operator. In conclusion, the project confirms the feasibility and efficiency of process automation in the technical acceptance phase, converting a manual task into a structured and reliable workflow.