{"id":3741,"date":"2026-04-23T18:51:54","date_gmt":"2026-04-23T18:51:54","guid":{"rendered":"https:\/\/jpbydesign.com\/?p=3741"},"modified":"2026-04-27T16:45:52","modified_gmt":"2026-04-27T16:45:52","slug":"power-automate-desktop-data-flow-example","status":"publish","type":"post","link":"https:\/\/jpbydesign.com\/index.php\/2026\/04\/23\/power-automate-desktop-data-flow-example\/","title":{"rendered":"Power Automate Desktop Data Flow Example"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Project title: SomeBusiness Process Excel XLSM to Output XLS for eBuilder<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">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&#8230; which would create the necessary reports.  Our process reduced the days spent to about 30 minutes of processing &#8211; it also validates and identifies entries that are not acceptable per business rules.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Below is a summary of the flow and an example of the output. The <a href=\"https:\/\/jpbydesign.com\/index.php\/2026\/04\/21\/mermaid-data-flow-model\/\" data-type=\"link\" data-id=\"https:\/\/jpbydesign.com\/index.php\/2026\/04\/21\/mermaid-data-flow-model\/\">following post<\/a> is a mermaid drawing of the flow.<\/p>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/jpbydesign.com\/wp-content\/uploads\/2026\/04\/SomeBusiness-Process-Excel-XLSM-to-Output-XLS-eBuilder-flow-Documentation.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Embed of SomeBusiness Process Excel XLSM to Output XLS eBuilder - flow Documentation.\"><\/object><a id=\"wp-block-file--media-2186cca5-3ba1-45c0-a6ac-2dbbe0b59fc9\" href=\"https:\/\/jpbydesign.com\/wp-content\/uploads\/2026\/04\/SomeBusiness-Process-Excel-XLSM-to-Output-XLS-eBuilder-flow-Documentation.pdf\">SomeBusiness Process Excel XLSM to Output XLS eBuilder &#8211; flow Documentation<\/a><a href=\"https:\/\/jpbydesign.com\/wp-content\/uploads\/2026\/04\/SomeBusiness-Process-Excel-XLSM-to-Output-XLS-eBuilder-flow-Documentation.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-2186cca5-3ba1-45c0-a6ac-2dbbe0b59fc9\">Download<\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Output<\/h2>\n\n\n\n<\/br>\n<div Style=\"all:unset;font-family:'Times New Roman', Times, serif;font-size:small;\">\n<h1 style=\"font-family:'Times New Roman', Times, serif;\"><font color=\"#3366ff\">Results from process run on 12\/4\/2025<\/font><\/h1>\n<p>8:59 AM<\/p>\n<hr>\nStatus:\n<\/br><b>1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness HT West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls\n<\/br><b>25-0831 19010-151 BRIC Sub Utilization ACCUM .xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness Rock Creek Library Remodel Phase II \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 5 |Valid Rec Count: 5\n<\/br>&emsp;&ensp; ==> SomeBusiness_Rock_Creek_Library_Remodel_Phase_II_RC5_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 0 |Valid Rec Count: 0\n<\/br>&emsp;&ensp; ==> SomeBusiness_Rock_Creek_Library_Remodel_Phase_II_RC0_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24026 SY2313 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24026 &#8211; SomeBusiness Sylvania CT Buildingc\n2022 Bond Sylvania CT Building Renovation: SD Phase SY2313 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 36 |Valid Rec Count: 32\n<\/br>&emsp;&ensp; ==> BRIC_24026___SomeBusiness_Sylvania_CT_Buildingc_2022_Bond_Sylvania_CT_Building_Renovation__SD_Phase_SY2313_RC32_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 105 |Valid Rec Count: 88\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 7<\/span>\n<\/br>&emsp;&ensp; ==> BRIC_24026___SomeBusiness_Sylvania_CT_Buildingc_2022_Bond_Sylvania_CT_Building_Renovation__SD_Phase_SY2313_RC88_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24027 SY2355 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24027 &#8211; SomeBusiness Sylvania CT Site Redesign SD Phase\n2022 Bond Sylvania Campus East Entry Site Improvements: SD Phase SY2355  \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 10 |Valid Rec Count: 10\n<\/br>&emsp;&ensp; ==> BRIC_24027___SomeBusiness_Sylvania_CT_Site_Redesign_SD_Phase_2022__Site_Redesign_SD_Phase_2022_Bond_Sylvania_Campus_East_En_RC10_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 78 |Valid Rec Count: 61\n<\/br>&emsp;&ensp; ==> BRIC_24027___SomeBusiness_Sylvania_CT_Site_Redesign_SD_Phase_2022__Site_Redesign_SD_Phase_2022_Bond_Sylvania_Campus_East_En_RC61_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24029 SY2361 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24029 &#8211; SomeBusiness Sylvania Social Sciences Building\n2022 Bond SY SS Building Renovation &#8211; Language &#038; Humanities (CT) SY2361 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8\n<\/br>&emsp;&ensp; ==> BRIC_24029___SomeBusiness_Sylvania_Social_Sciences_Building_2022___SY2361_RC8_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 82 |Valid Rec Count: 66\n<\/br>&emsp;&ensp; ==> BRIC_24029___SomeBusiness_Sylvania_Social_Sciences_Building_2022___SY2361_RC66_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24030 SY2366 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24030 &#8211; SomeBusiness Sylvania Book Store Building\n2022 Bond SY CT Ceramics Building (CT) SY2366 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 8 |Valid Rec Count: 7\n<\/br>&emsp;&ensp; ==> BRIC_24030___SomeBusiness_Sylvania_Book_Store_Building_2022_Bond_SY_CT_Ceramics_Building__CT__SY2366_RC7_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 70 |Valid Rec Count: 58\n<\/br>&emsp;&ensp; ==> BRIC_24030___SomeBusiness_Sylvania_Book_Store_Building_2022_Bond_SY_CT_Ceramics_Building__CT__SY2366_RC58_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24031 SY2362 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24031 &#8211; SomeBusiness Sylvania Science &#038; Tech Building\n2022 Bond SY ST Building Renovation-Music &#038; Sonic Arts Swing Spaces (CT) SY2362 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8\n<\/br>&emsp;&ensp; ==> BRIC_24031___SomeBusiness_Sylvania_Science___Tech_Building_2022___SY2362_RC8_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 105 |Valid Rec Count: 76\n<\/br>&emsp;&ensp; ==> BRIC_24031___SomeBusiness_Sylvania_Science___Tech_Building_2022___SY2362_RC76_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24032 SY2369 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24032 &#8211; SomeBusiness Sylvania Automotive Building\n2022 Bond SY AM Swing Space Remodel for CT Music (CT) SY2369 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6\n<\/br>&emsp;&ensp; ==> BRIC_24032___SomeBusiness_Sylvania_Automotive_Building_2022_Bond_SY_AM_Swing_Space_Remodel_for_CT_Music__CT__SY2369_RC6_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 65 |Valid Rec Count: 53\n<\/br>&emsp;&ensp; ==> BRIC_24032___SomeBusiness_Sylvania_Automotive_Building_2022_Bond_SY_AM_Swing_Space_Remodel_for_CT_Music__CT__SY2369_RC53_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24033 SY2365 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24033 &#8211; SomeBusiness Sylvania South Classroom Building\n2022 Bond SY SCB Renovation &#8211; Painting &#038; Drawings Swing Space (CT) SY2365 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8\n<\/br>&emsp;&ensp; ==> BRIC_24033___SomeBusiness_Sylvania_South_Classroom_Building_2022___SY2365_RC8_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 78 |Valid Rec Count: 65\n<\/br>&emsp;&ensp; ==> BRIC_24033___SomeBusiness_Sylvania_South_Classroom_Building_2022___SY2365_RC65_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24034 SY2364 BRIC P&#038;C Arch Util -Labor form ACCUM (1).xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24034 &#8211; SomeBusiness Sylvania Heat Plant Building\n2022 Bond SY HP Building Renovation &#8211; Printmaking Swing Space (CT) SY2364 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6\n<\/br>&emsp;&ensp; ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC6_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 71 |Valid Rec Count: 57\n<\/br>&emsp;&ensp; ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC57_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24034 SY2364 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24034 &#8211; SomeBusiness Sylvania Heat Plant Building\n2022 Bond SY HP Building Renovation &#8211; Printmaking Swing Space (CT) SY2364 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6\n<\/br>&emsp;&ensp; ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC6_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 71 |Valid Rec Count: 57\n<\/br>&emsp;&ensp; ==> BRIC_24034___SomeBusiness_Sylvania_Heat_Plant_Building_2022___SY2364_RC57_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24035 SY2367 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24035 &#8211; SomeBusiness Sylvania Health Tech Building\n2022 Bond SY HT East Building Swing Space Renovation (CT) SY2367 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 9 |Valid Rec Count: 8\n<\/br>&emsp;&ensp; ==> BRIC_24035___SomeBusiness_Sylvania_Health_Tech_Building_2022_Bond_SY_HT_East_Building_Swing_Space_Renovation__CT__SY2367_RC8_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 68 |Valid Rec Count: 56\n<\/br>&emsp;&ensp; ==> BRIC_24035___SomeBusiness_Sylvania_Health_Tech_Building_2022_Bond_SY_HT_East_Building_Swing_Space_Renovation__CT__SY2367_RC56_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-0930 24037 SY2363 BRIC P&#038;C Arch Util -Labor form ACCUM.xlsm <\/b>\n<\/br>&ensp;-Project: BRIC 24037 &#8211; SomeBusiness Sylvania Tech Classroom Building\n2022 Bond SY TCB Building &#8211; ESOL &#038; ASL Renovation Project (CT) SY2363 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 7 |Valid Rec Count: 6\n<\/br>&emsp;&ensp; ==> BRIC_24037___SomeBusiness_Sylvania_Tech_Classroom_Building_2022___SY2363_RC6_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 80 |Valid Rec Count: 65\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 48<\/span>\n<\/br>&emsp;&ensp; ==> BRIC_24037___SomeBusiness_Sylvania_Tech_Classroom_Building_2022___SY2363_RC65_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>25-1106 SomeBusiness Architect Utilization and Labor form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness Sylvania Health Technology West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |0|Orig Count: 16 |Valid Rec Count: -3\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_Sylvania_Health_Technology_West_Side_Renovation_RC0_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |0|Orig Count: 58 |Valid Rec Count: 58\n<\/br>&emsp;&ensp; ==> SomeBusiness_Sylvania_Health_Technology_West_Side_Renovation_RC58_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>3- P&#038;CC Subcontractor Utilization Form v3 (6).xlsm <\/b>\n<\/br>&ensp;-Project: RC Intersection ADA Improvements \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |0|Orig Count: 1 |Valid Rec Count: 1\n<\/br>&emsp;&ensp; ==> RC_Intersection_ADA_Improvements_RC1_20251204_ContractorEquitySheetName.xls\n<\/br><b>HSW October 2025  Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness Building Roof Replacement  \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |0|Orig Count: 34 |Valid Rec Count: 34\n<\/br>&emsp;&ensp; ==> SomeBusiness_Building_Roof_Replacement__RC34_20251204_ContractorEquitySheetName.xls\n<\/br><b>Oct, 2025 Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness Rock Creek Library \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |0|Orig Count: 12 |Valid Rec Count: 12\n<\/br>&emsp;&ensp; ==> SomeBusiness_Rock_Creek_Library_RC12_20251204_ContractorEquitySheetName.xls\n<\/br><b>P&#038;CC Utilization and Labor_cumulative_11.1.25.xlsm <\/b>\n<\/br>&ensp;-Project: 2017 Bond Deferred Maintenance Sylvania CC Building Roof Replacement SY1952 \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |1|Orig Count: 14 |Valid Rec Count: 11\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 15, 9, 3<\/span>\n<\/br>&emsp;&ensp; ==> 2017_Bond_Deferred_Maintenance_Sylvania_CC_Building_Roof_Replacement_SY1952_RC12_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |1|Orig Count: 32 |Valid Rec Count: 32\n<\/br>&emsp;&ensp; ==> 2017_Bond_Deferred_Maintenance_Sylvania_CC_Building_Roof_Replacement_SY1952_RC32_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>SomeBusiness HC Subcontractor Utilization Report (2025.11.05).xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness Health Clinic \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Utilization |1|Orig Count: 13 |Valid Rec Count: 8\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 14, 13, 12, 11<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_Health_Clinic_RC10_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Labor Utilization |1|Orig Count: 0 |Valid Rec Count: 0\n<\/br>&emsp;&ensp; ==> SomeBusiness_Health_Clinic_RC0_20251204_ArchitectWorkforceSheetName.xls\n<\/br><b>SomeBusiness RC Subcontractor Utilization Report (2025.11.04).xlsx <\/b>\n<\/br>&ensp;-Project: SomeBusiness Rock Creek \n<\/br>&emsp; &#8212;  Worksheet: Subconsultant Contracts |0|Orig Count: 11 |Valid Rec Count: 11\n<\/br>&emsp;&ensp; ==> SomeBusiness_Rock_Creek_RC11_20251204_ArchitectEquitySheetName.xls\n<\/br>&emsp; &#8212;  Worksheet: Workforce |0|Orig Count: 58 |Valid Rec Count: 46\n<\/br>&emsp;&ensp; ==> SomeBusiness_Rock_Creek_RC46_20251204_ArchitectWorkforceSheetName.xls\n\n<h1 style=\"font-family:'Times New Roman', Times, serif;\"><font color=\"#3366ff\">Results from process run on 12\/4\/2025<\/font><\/h1>\n<p>10:25 AM<\/p>\n<hr>\nStatus:\n<\/br><b>1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness HT West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls\n<h2>Recommend restarting computer as some excel files may not have closed correctly<\/h2>\n\n<h1 style=\"font-family:'Times New Roman', Times, serif;\"><font color=\"#3366ff\">Results from process run on 12\/4\/2025<\/font><\/h1>\n<p>10:29 AM<\/p>\n<hr>\nStatus:\n<\/br><b>1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness HT West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls\n\n<h1 style=\"font-family:'Times New Roman', Times, serif;\"><font color=\"#3366ff\">Results from process run on 12\/4\/2025<\/font><\/h1>\n<p>11:07 AM<\/p>\n<hr>\nStatus:\n<\/br><b>1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness HT West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls\n<\/br><span style=\"color:red;\">Unable to delete file.  See Instructions for next steps<\/span>\n\n<h1 style=\"font-family:'Times New Roman', Times, serif;\"><font color=\"#3366ff\">Results from process run on 12\/4\/2025<\/font><\/h1>\n<p>11:10 AM<\/p>\n<hr>\nStatus:\n<\/br><b>1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness HT West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls\n<\/br><span style=\"color:red;\">Unable to delete file.  See Instructions for next steps<\/span>\n\n<h1 style=\"font-family:'Times New Roman', Times, serif;\"><font color=\"#3366ff\">Results from process run on 12\/4\/2025<\/font><\/h1>\n<p>11:13 AM<\/p>\n<hr>\nStatus:\n<\/br><b>1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness HT West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls\n<\/br><span style=\"color:red;\">Unable to delete file.  See Instructions for next steps<\/span>\n\n<h1 style=\"font-family:'Times New Roman', Times, serif;\"><font color=\"#3366ff\">Results from process run on 12\/4\/2025<\/font><\/h1>\n<p>11:18 AM<\/p>\n<hr>\nStatus:\n<\/br><b>1025 22062 SomeBusiness Subcontractor Utilization Form.xlsm <\/b>\n<\/br>&ensp;-Project: SomeBusiness HT West Side Renovation \n<\/br>&emsp; &#8212;  Worksheet: Subcontracts |-1|Orig Count: 57 |Valid Rec Count: 37\n <span style=\"color:red;\"> | <span style=\"color:red;\">Non-Blank Lines removed: <\/span> 56, 55, 54, 51, 50, 49, 35, 34, 33, 32, 31, 24, 23, 22, 21, 20, 19, 18, 15, 14<\/span>\n<\/br>&emsp;&ensp; ==> SomeBusiness_HT_West_Side_Renovation_RC37_20251204_ContractorEquitySheetName.xls\n<\/br><span style=\"color:red;\">Unable to delete file.  See Instructions for next steps<\/span>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3764,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[4,89],"tags":[97,96,90,94,95],"class_list":["post-3741","post","type-post","status-publish","format-standard","has-post-thumbnail","category-database","category-professional-portfolio","tag-dataflow","tag-excel","tag-portfolio","tag-power-automate","tag-power-automate-desktop","czr-hentry"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7Ze6V-Yl","jetpack-related-posts":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/jpbydesign.com\/wp-content\/uploads\/2026\/04\/microsoft-power-automate-seeklogo.png?fit=2000%2C1589&ssl=1","_links":{"self":[{"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/posts\/3741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/comments?post=3741"}],"version-history":[{"count":5,"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/posts\/3741\/revisions"}],"predecessor-version":[{"id":3886,"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/posts\/3741\/revisions\/3886"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/media\/3764"}],"wp:attachment":[{"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/media?parent=3741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/categories?post=3741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpbydesign.com\/index.php\/wp-json\/wp\/v2\/tags?post=3741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}