This site under reconstruction.
For me, one of the hardest data format to handle is the date because it can come in many formats: text, date format, space, maybe a null space, zero or the word blank. It can come in different varieties that the IF, OR, and AND formulas can get complicated to handle the different formats. And…
I uploaded the ACA 1095C forms for 2017 tax year and am now done. There were some changes to the electronic transfer but not much. I’m only going to discuss briefly the changes because I will be updating my ACA pages that can be accessed from the home pages. I’d give you the link but…
A couple of months ago, our managers started to have problems with their Excel files from our 3rd Party Vendor: the Excel downloads were invisible to my macros so our reporting system was failing. Our tech guy and I think the change had something to do with Microsoft updating their operating system to combat security…
The week before last week I had been going through a book on Excel simulations but then I got sick and work became busier, so I had to put the book aside. The last set of simulations that I had been going through were centered on statistics. In going through these simulations, there were some…
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…