Excel

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…

A couple of weeks ago, our software vendor updated their software, especially the front page of their product. Unbeknownst to us, Microsoft also did some security updates during the same week. Grrrrrrr. #!%#$@!#. Double grrrrrr. Problems pop up sporadically and then clears up. The problem is in the downloads. Microsoft will apply the usual protection…