Project title: SomeBusiness Process Excel XLSM to Output XLS for eBuilder
My client would receive 100+ macro enabled Excel files every month that calculated information necessary for government and internal reporting from construction contractors. They would spend 3-5 days, after receiving all of the files, to extract the data from the excel files and put the data into non-macro Excel files for upload into eBuilder… which would create the necessary reports. Our process reduced the days spent to about 30 minutes of processing – it also validates and identifies entries that are not acceptable per business rules.
Below is a summary of the flow and an example of the output. The following post is a mermaid drawing of the flow.
Output
Results from process run on 12/4/2025
8:59 AM
Status: 1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm -Project: SomeBusiness HT West Side Renovation — Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37 | Non-Blank Lines removed: 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14 ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls 25-0831 19010-151 BRIC Sub Utilization ACCUM .xlsm -Project: SomeBusiness Rock Creek Library Remodel Phase II — Worksheet: Subconsultant Utilization |0|Orig Count: 5 |Valid Rec Count: 5 ==> SomeBusiness_Rock_Creek_Library_Remodel_Phase_II_RC5_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 0 |Valid Rec Count: 0 ==> SomeBusiness_Rock_Creek_Library_Remodel_Phase_II_RC0_20251204_ArchitectWorkforceSheetName.xls 25-0930 24026 SY2313 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24026 – SomeBusiness Sylvania CT Buildingc 2022 Bond Sylvania CT Building Renovation: SD Phase SY2313 — Worksheet: Subconsultant Utilization |0|Orig Count: 36 |Valid Rec Count: 32 ==> BRIC_24026___SomeBusiness_Sylvania_CT_Buildingc_2022_Bond_Sylvania_CT_Building_Renovation__SD_Phase_SY2313_RC32_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 105 |Valid Rec Count: 88 | Non-Blank Lines removed: 7 ==> BRIC_24026___SomeBusiness_Sylvania_CT_Buildingc_2022_Bond_Sylvania_CT_Building_Renovation__SD_Phase_SY2313_RC88_20251204_ArchitectWorkforceSheetName.xls 25-0930 24027 SY2355 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24027 – SomeBusiness Sylvania CT Site Redesign SD Phase 2022 Bond Sylvania Campus East Entry Site Improvements: SD Phase SY2355 — Worksheet: Subconsultant Utilization |0|Orig Count: 10 |Valid Rec Count: 10 ==> BRIC_24027___SomeBusiness_Sylvania_CT_Site_Redesign_SD_Phase_2022__Site_Redesign_SD_Phase_2022_Bond_Sylvania_Campus_East_En_RC10_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 78 |Valid Rec Count: 61 ==> BRIC_24027___SomeBusiness_Sylvania_CT_Site_Redesign_SD_Phase_2022__Site_Redesign_SD_Phase_2022_Bond_Sylvania_Campus_East_En_RC61_20251204_ArchitectWorkforceSheetName.xls 25-0930 24029 SY2361 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24029 – SomeBusiness Sylvania Social Sciences Building 2022 Bond SY SS Building Renovation – Language & Humanities (CT) SY2361 — Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8 ==> BRIC_24029___SomeBusiness_Sylvania_Social_Sciences_Building_2022___SY2361_RC8_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 82 |Valid Rec Count: 66 ==> BRIC_24029___SomeBusiness_Sylvania_Social_Sciences_Building_2022___SY2361_RC66_20251204_ArchitectWorkforceSheetName.xls 25-0930 24030 SY2366 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24030 – SomeBusiness Sylvania Book Store Building 2022 Bond SY CT Ceramics Building (CT) SY2366 — Worksheet: Subconsultant Utilization |0|Orig Count: 8 |Valid Rec Count: 7 ==> BRIC_24030___SomeBusiness_Sylvania_Book_Store_Building_2022_Bond_SY_CT_Ceramics_Building__CT__SY2366_RC7_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 70 |Valid Rec Count: 58 ==> BRIC_24030___SomeBusiness_Sylvania_Book_Store_Building_2022_Bond_SY_CT_Ceramics_Building__CT__SY2366_RC58_20251204_ArchitectWorkforceSheetName.xls 25-0930 24031 SY2362 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24031 – SomeBusiness Sylvania Science & Tech Building 2022 Bond SY ST Building Renovation-Music & Sonic Arts Swing Spaces (CT) SY2362 — Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8 ==> BRIC_24031___SomeBusiness_Sylvania_Science___Tech_Building_2022___SY2362_RC8_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 105 |Valid Rec Count: 76 ==> BRIC_24031___SomeBusiness_Sylvania_Science___Tech_Building_2022___SY2362_RC76_20251204_ArchitectWorkforceSheetName.xls 25-0930 24032 SY2369 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24032 – SomeBusiness Sylvania Automotive Building 2022 Bond SY AM Swing Space Remodel for CT Music (CT) SY2369 — Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6 ==> BRIC_24032___SomeBusiness_Sylvania_Automotive_Building_2022_Bond_SY_AM_Swing_Space_Remodel_for_CT_Music__CT__SY2369_RC6_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 65 |Valid Rec Count: 53 ==> BRIC_24032___SomeBusiness_Sylvania_Automotive_Building_2022_Bond_SY_AM_Swing_Space_Remodel_for_CT_Music__CT__SY2369_RC53_20251204_ArchitectWorkforceSheetName.xls 25-0930 24033 SY2365 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24033 – SomeBusiness Sylvania South Classroom Building 2022 Bond SY SCB Renovation – Painting & Drawings Swing Space (CT) SY2365 — Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8 ==> BRIC_24033___SomeBusiness_Sylvania_South_Classroom_Building_2022___SY2365_RC8_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 78 |Valid Rec Count: 65 ==> BRIC_24033___SomeBusiness_Sylvania_South_Classroom_Building_2022___SY2365_RC65_20251204_ArchitectWorkforceSheetName.xls 25-0930 24034 SY2364 BRIC P&C Arch Util -Labor form ACCUM (1).xlsm -Project: BRIC 24034 – SomeBusiness Sylvania Heat Plant Building 2022 Bond SY HP Building Renovation – Printmaking Swing Space (CT) SY2364 — Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6 ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC6_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 71 |Valid Rec Count: 57 ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC57_20251204_ArchitectWorkforceSheetName.xls 25-0930 24034 SY2364 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24034 – SomeBusiness Sylvania Heat Plant Building 2022 Bond SY HP Building Renovation – Printmaking Swing Space (CT) SY2364 — Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6 ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC6_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 71 |Valid Rec Count: 57 ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC57_20251204_ArchitectWorkforceSheetName.xls 25-0930 24035 SY2367 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24035 – SomeBusiness Sylvania Health Tech Building 2022 Bond SY HT East Building Swing Space Renovation (CT) SY2367 — Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8 ==> BRIC_24035___SomeBusiness_Sylvania_Health_Tech_Building_2022_Bond_SY_HT_East_Building_Swing_Space_Renovation__CT__SY2367_RC8_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 68 |Valid Rec Count: 56 ==> BRIC_24035___SomeBusiness_Sylvania_Health_Tech_Building_2022_Bond_SY_HT_East_Building_Swing_Space_Renovation__CT__SY2367_RC56_20251204_ArchitectWorkforceSheetName.xls 25-0930 24037 SY2363 BRIC P&C Arch Util -Labor form ACCUM.xlsm -Project: BRIC 24037 – SomeBusiness Sylvania Tech Classroom Building 2022 Bond SY TCB Building – ESOL & ASL Renovation Project (CT) SY2363 — Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6 ==> BRIC_24037___SomeBusiness_Sylvania_Tech_Classroom_Building_2022___SY2363_RC6_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 80 |Valid Rec Count: 65 | Non-Blank Lines removed: 48 ==> BRIC_24037___SomeBusiness_Sylvania_Tech_Classroom_Building_2022___SY2363_RC65_20251204_ArchitectWorkforceSheetName.xls 25-1106 SomeBusiness Architect Utilization and Labor form.xlsm -Project: SomeBusiness Sylvania Health Technology West Side Renovation — Worksheet: Subconsultant Utilization |0|Orig Count: 16 |Valid Rec Count: -3 | Non-Blank Lines removed: 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1 ==> SomeBusiness_Sylvania_Health_Technology_West_Side_Renovation_RC0_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |0|Orig Count: 58 |Valid Rec Count: 58 ==> SomeBusiness_Sylvania_Health_Technology_West_Side_Renovation_RC58_20251204_ArchitectWorkforceSheetName.xls 3- P&CC Subcontractor Utilization Form v3 (6).xlsm -Project: RC Intersection ADA Improvements — Worksheet: Subcontracts |0|Orig Count: 1 |Valid Rec Count: 1 ==> RC_Intersection_ADA_Improvements_RC1_20251204_ContractorEquitySheetName.xls HSW October 2025 Subcontractor Utilization Form.xlsm -Project: SomeBusiness Building Roof Replacement — Worksheet: Subcontracts |0|Orig Count: 34 |Valid Rec Count: 34 ==> SomeBusiness_Building_Roof_Replacement__RC34_20251204_ContractorEquitySheetName.xls Oct, 2025 Utilization Form.xlsm -Project: SomeBusiness Rock Creek Library — Worksheet: Subcontracts |0|Orig Count: 12 |Valid Rec Count: 12 ==> SomeBusiness_Rock_Creek_Library_RC12_20251204_ContractorEquitySheetName.xls P&CC Utilization and Labor_cumulative_11.1.25.xlsm -Project: 2017 Bond Deferred Maintenance Sylvania CC Building Roof Replacement SY1952 — Worksheet: Subconsultant Utilization |1|Orig Count: 14 |Valid Rec Count: 11 | Non-Blank Lines removed: 15, 9, 3 ==> 2017_Bond_Deferred_Maintenance_Sylvania_CC_Building_Roof_Replacement_SY1952_RC12_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |1|Orig Count: 32 |Valid Rec Count: 32 ==> 2017_Bond_Deferred_Maintenance_Sylvania_CC_Building_Roof_Replacement_SY1952_RC32_20251204_ArchitectWorkforceSheetName.xls SomeBusiness HC Subcontractor Utilization Report (2025.11.05).xlsm -Project: SomeBusiness Health Clinic — Worksheet: Subconsultant Utilization |1|Orig Count: 13 |Valid Rec Count: 8 | Non-Blank Lines removed: 14, 13, 12, 11 ==> SomeBusiness_Health_Clinic_RC10_20251204_ArchitectEquitySheetName.xls — Worksheet: Labor Utilization |1|Orig Count: 0 |Valid Rec Count: 0 ==> SomeBusiness_Health_Clinic_RC0_20251204_ArchitectWorkforceSheetName.xls SomeBusiness RC Subcontractor Utilization Report (2025.11.04).xlsx -Project: SomeBusiness Rock Creek — Worksheet: Subconsultant Contracts |0|Orig Count: 11 |Valid Rec Count: 11 ==> SomeBusiness_Rock_Creek_RC11_20251204_ArchitectEquitySheetName.xls — Worksheet: Workforce |0|Orig Count: 58 |Valid Rec Count: 46 ==> SomeBusiness_Rock_Creek_RC46_20251204_ArchitectWorkforceSheetName.xls
Results from process run on 12/4/2025
10:25 AM
Status: 1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm -Project: SomeBusiness HT West Side Renovation — Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37 | Non-Blank Lines removed: 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14 ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls
Recommend restarting computer as some excel files may not have closed correctly
Results from process run on 12/4/2025
10:29 AM
Status: 1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm -Project: SomeBusiness HT West Side Renovation — Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37 | Non-Blank Lines removed: 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14 ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls
Results from process run on 12/4/2025
11:07 AM
Status: 1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm -Project: SomeBusiness HT West Side Renovation — Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37 | Non-Blank Lines removed: 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14 ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls Unable to delete file. See Instructions for next steps
Results from process run on 12/4/2025
11:10 AM
Status: 1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm -Project: SomeBusiness HT West Side Renovation — Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37 | Non-Blank Lines removed: 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14 ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls Unable to delete file. See Instructions for next steps
Results from process run on 12/4/2025
11:13 AM
Status: 1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm -Project: SomeBusiness HT West Side Renovation — Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37 | Non-Blank Lines removed: 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14 ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls Unable to delete file. See Instructions for next steps
Results from process run on 12/4/2025
11:18 AM
Status: 1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm -Project: SomeBusiness HT West Side Renovation — Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37 | Non-Blank Lines removed: 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14 ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls Unable to delete file. See Instructions for next steps