This site under reconstruction.
Revising a code is way different from creating a code from scratch. My company switched over to a new payroll vendor and the new vendor’s data file is almost – but not quite – the same as the old data layout, but it is that tiny little variance that broke the code. Most of the…
I appear to be going through a stretch where whatever I do, I’m not happy with: either it looks or works awful or just doesn’t plain work or it just takes too long. Any idea I have just doesn’t come like the way I imagine it. Anyway I still have to push on. I’m currently…
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…