A Macro-Based Solution for Addressing Structure Gap Reporting Challenges SBAP-581829-GMFI-MP-002 February 2024 ***** Background Currently, the Aircraft Data Group (TED) relies on a manually created Excel report to track the daily status of aircraft structure gaps. This report heavily depends on various Excel functions and formulas. However, this manual process presents several challenges: Lack of Automation : The current process relies on manual intervention and increases the potential for errors in the reporting process. Data Exclusion Challenges : As customer requirements evolve and are documented in a formal document such as Engineering Information, there's a growing need to exclude specific structure gap data from the report. The current manual process makes it difficult to accommodate these exclusions efficiently. Inconsistent Plant Data : Inconsistencies during the removal order creation process often lead to errors in Plant data, resulting in incorrect unit in charge (UIC) a......