This site under reconstruction.
My eyes are starting to swim from looking at rows upon rows upon rows of data. I’m working on that ACA reporting again this year, using my Excel spreadsheet to assign the code 1 and code 2 series, based upon hire/term dates and medical enrollment dates. Last year’s set of algorithms got me through about…
Sometimes, people just want to do things manually.There is a weekly report that I created almost 2 years ago that pulled in data via macro. It basically does the job for you in 5 minutes and all you have to do is review the numbers. Now. sometimes you have to fix some errors but those errors are…
This election was a perfect example of how data could lead you astray if you are not careful. Before the results of the election came in, all of the polls predicted Clinton had around 85% chance of winning. Well, the 15% chance that he would win happened. This was a black swan event, and I…
This past week I’ve been off on vacation with the hope of getting a lot of stuff done: lots of art, revamping my website, revamping LinkedIn, educational stuff, and learning some stuff on data and visualization. Of course, I always plan for more than I can actually do. I have not done nearly as much…
This is a very short post. I just wanted to say what I’m reading now. I’m reading a book right now, Good Charts by Scott Berinato. It’s a beautiful book that discusses the theory of what makes a good chart and how to go about making good charts. I’m in the section talking about the…
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…