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

Interesting Questions
|

Interesting Questions

A couple of posts ago I wrote about why I was tracking the coronavirus using Power BI. One of my goal was to practice asking interesting questions that would bring out something unusual or astonishing or just plain interesting. In other words, try to think of something that no one else was doing because I…

Cases declining but so are testing?
| |

Cases declining but so are testing?

The last two weeks or so, I noticed that case infections were declining or stabilizing in Florida, Georgia, Texas and Arizona and hospitalization capacity stabilizing – neither going up or down dramatically. And this was after our President said he asked “to slow down the testing” because if you test too well, you will get…

Two topics: hurricane weather and the need to double check your Excel results.
|

Two topics: hurricane weather and the need to double check your Excel results.

This post is going to be very short because I have a headache, probably from lack of sleep over worry about this storm. We’re supposed to have tremendous amount of flooding over the weekend – between 15 -20 inches.  The weather is coming in via hurricane and it is supposed to stall in our area for…

163 vs 32

Special characters: 160 versus 32

I ran across a new variation on hidden characters. In the past, I have written about invisible characters such as an “insert line” in this post. I wrote about how to use the function “code” to get at the hidden character and how to use function “char” to create that hidden character. I also may have…

GRRR : Microsoft protection and the zone identifier - problems with downloaded files from the internet

Microsoft’s Zone Identifier

Grrrrrrrr. There has been so many obstacles lately where things just don’t work. It’s been discouraging. This time it is a Windows machine that won’t allow my macro to recognize files downloaded from the internet which is where our vendor site lies. Let’s call the person with a machine that won’t see the downloaded files…

Where Do Ideas Come From?

How Do Ideas Form? I had a great one for testing protected/unprotected cells.

Where do ideas some from? Because I had a great one this past week. I was testing a budget file and my creative genius figured out a way to test for protected cells versus unprotected cells. This method works if you designate input cells as one or two colors. If you want to make sure…