I'm a Genius - ACA News
|

ACA Success! I Have Succeeded with XML!

I'm a Genius - ACA News

This will be a short post but I just wanted to celebrate. I may have gone overboard with the genius thing but I feel like one! My ACA XML file went through! So the only thing we have to do is resolve the name/SSN errors, of which there are 40. As far as I'm concerned, I've succeeded. The name/SSN is something our benefits folks will have to investigate. I will send corrections upon receipt of the new changes.

But I have succeeded!

So now I will write up a series of posts on what you need to do in order to get your data into XML format.

Similar Posts

Hints of an Upsurge?
| |

Hints of an Upsurge?

While I’m still converting my data pull from the Covid Tracking Project to the CDC data, let’s take a look at where the US stands in regards to the pandemic. I have done enough to be able to start seeing trends – although yesterday I did run into a little problem. Now, I admit it…

A look at where we are in regards to Coronavirus – 6/27/2021
| |

A look at where we are in regards to Coronavirus – 6/27/2021

It’s been a while since I’ve written anything about the pandemic but I have still kept up with the nightly data review in case the Delta variant starts to rip through the US. Although the news say that the Delta variant may be the dominant in the US, I haven’t seen any signs of pending…

Accounting Changes
|

Changing the Accounting Again

This gets old – the company that is in or was just in bankruptcy keeps changing its books. Every month my boss does variance analysis against the budget that was created earlier in the year (and not forwarded to the sites that have to manage their money, go figure). I gather the data for her since…

What is going on with California?
| |

What is going on with California?

Every night when I pull in numbers for the day, California just keeps topping the list. The data lately has been just eye-popping. California was the first state to impose some kind of lockdown and they’ve had some mask mandates and some restrictions on social gatherings, and yet, the case counts are in the stratosphere….

Testing Software

Testing a Revamped Budget File

The past week I’ve been reviewing a revamped budget file. The budget file is totally revamped which means extensive testing is required. I was able to design an automated checking of whether cells are appropriately locked (or unlocked) using the CELL(“protect”, ref) function. I also have a user defined function CellFormula (a macro) that shows…

So, I was not crazy…
| |

So, I was not crazy…

That’s a sad statistic. Since roughly around July 21, 2020, we’ve sustained a roughly consistent death rate of over 1000 deaths per day. And while the South (Texas and Florida mainly) and Arizona (in the West) look to be declining in infection rates, the Midwest appears to be surging – the surge started in July…