I came very close to the BREAKING header but resisted temptation.
I'll be posting updates to this diary (and this one) over the next hour or so as I plug in the data, but here's the bottom line:
--If you look at Week 13 on the spreadsheet, you'll see that ACASignups.net had 2,137,630 private enrollments as of 12/31.
--According to the official December HHS report, the total number of exchange-based private enrollments was 2,153,421 as of 12/28.
--ACASignups.net was, therefore, appx. 99.2% accurate (ok, knock 0.2% off for the missing 3 days of data...call it 99% even).
I have no idea why the HHS report doesn't include the last 3 days of the year; perhaps a lack of personnel during the holidays? Will post something about this if/when I find out what the deal was there.
OK, I've plugged the individual state numbers into the spreadsheet; here's what it looks like:
UPDATE x2: OK, I've plugged in the state-by-state percentages for the CMS projections over at the actual site. Will try to fill it in here later but it's a lot of work just doing it once and the code is wonky.
UPDATE x3: I've now updated the spreadsheet to include BOTH the 12/28 HHS numbers for all states AS WELL AS the post-12/28 updates that I've received from some states.
See the detailed write-up here. The short version is, I'm not sure where about 1.24 million of the Medicaid total comes from.
Update x5: OK, this may seem a little petty, but I can't help but be somewhat amused/irked that the New York Times has FINALLY decided to jump into the pool.
In the words of John "Die Hard" McClaine, Welcome to the party, pal!