Daily Archives: April 23, 2026

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 […]

Power Automate Desktop Data Flow Example

The purpose of this plan is to ingest SomeCompany product data submissions from multiple sources.

Example File Load Plan

I worked on this for a government related agency – for their construction department. The need was to pivot source data- a very wide, hard to decipher column data – into hours data by craft, trade, gender, race and by a derived row key (a tall, narrow data table). There […]

SQL Example Workforce Grid