Okay - big ugly spreadsheet post.
History: On March 20, I started a spreadsheet. I took the total number of deaths in America as of that day (from the Worldmeter site), and multiplied times 1.2, compounding each day (a 20% daily increase). I picked 1.2 more or less out of my butt, because just looking at the numbers for the previous week 1.2 seemed to be a bit lower than the actual rate of growth. Also, it made a nice comparison to 1.1, which seemed to be about the daily rate of growth for the worldwide total deaths (but I didn't put that into a spreadsheet because I was really just playing around).
I ran out the spreadsheet for sixty days (the total for May 19 was 14,368,616 deaths). But the rate of spread was actually a fair bit above 20%, so the numbers got off pretty quickly. Here's the numbers from that first set of calculations compared to actual numbers:
date|projected|actual
date|deaths|deaths
20-Mar|255|255
21-Mar|306|301
22-Mar|367|458
23-Mar|441|555
24-Mar|528|780
25-Mar|634|1027
26-Mar|761|1295
27-Mar|913|1695
28-Mar|1096|2220
29-Mar|1315|2583
30-Mar|1578|3141
31-Mar|1894|4053
By March 31, the two columns were pretty far off. In a bad way - actual deaths by then were more than twice as high as projected. The death total was increasing at well above 20% daily.
So I restarted the column on March 31. I posted that to the forum, but I had started it with the total as of mid-day. I should have picked an end-of-day total instead. So that's what I have below (starting with end of day numbers for March 31, so it is a bit off compared to the numbers I posted last week). This is the calculation of a 20% daily increase in total deaths for the U.S., run out for three weeks of projection with the actual included up to yesterday:
Date|20% growth|
Actual
date|projection|
Numbers
31-Mar
| 4053|
4053
1-Apr
| 4864|
5102
2-Apr
| 5836|
6076
3-Apr
| 7003|
7121
4-Apr
| 8404|
8451
5-Apr
| 10,085|
9616
6-Apr
| 12,102
7-Apr
| 14,522
8-Apr
| 17,427
9-Apr
| 20,913
10-Apr
| 25,095
11-Apr
| 30,114
12-Apr
| 36,137
13-Apr
| 43,364
14-Apr
| 52,037
15-Apr
| 62,445
16-Apr
| 74,934
17-Apr
| 89,920
18-Apr
| 107,904
19-Apr
| 129,485
20-Apr
| 155,382
21-Apr
| 186,459
This is actually "better" so far - things are sticking closer to 20% growth. I mean, 20% daily growth in total deaths is horrible - but the numbers since March 31 suggests that the rate of acceleration of total deaths is slowing down. Most days, more people die than did the previous day - but not by as wide of a margin.
(The table does look very good, I could not figure out how to make a decent looking table in the forum post. I would be happy if someone with better forum-format juju could make it look prettier.)(ETA: Nevermind, I made it look better by looking at the formatting in one of Novaphile's posts. Now it looks better)