Excel

This week I had a request for help in designing a report for submission to owners. Previously, the managers have been pulling a bunch of reports and trying to manually produce the report, but on Thursday I got a cry for help. Understandably, they just got tired of doing it manually. And this request wasn’t…

Since Saturday I’ve been working on reviewing data for the ACA forms (healthcare reporting for employees) which I just completed today. The forms are now in the process of being printed and put into envelopes for mailing. As part of my review I was looking at the internal logic of timelines for each employee to…

Every day I encounter another article or two discussing the impact of automation on jobs. I’m sure most people are hearing or reading about such things, but outside of IT, do they really understand how blindingly fast computers can go, performing flawlessly (once programming has been tested and perfected) without tiring? And the IT guys,…

Last year, or maybe it was two years ago, I tried to go through this simulation book, Excel Simulations by Dr. Gerard M. Verschuuren, and blog at the same time about it, but it ended up being too much. I was trying to come up with good examples to use with the simulation exercises and…

A little quick note on that issue I had where the vendor’s exported Excel files were not cooperating with Microsoft: my macro no longer could “see” the downloaded files, even when “open”. The security warning message never showed up to say that the file was in Protected View mode. I even created another macro to…