Perhaps the BEST B1G Forum anywhere, here at College Football Fan Site, CFB51!!!

Not gonna quibble? You feeling OK?

Well, I'm quibbling that the original claim "it's more like 10%" is therefore inaccurate. I claim vindication on that point. 16% is closer to 20% than it is to 10%, so even if I accept the numbers, 16% is "more like 20%" than it is like 10%. 

But I think he's using a different dataset than I am, so a few percent difference can show up. Especially when if I use the same Oct 1->Oct12 window (not actually two weeks) I get 17.6%. 

But there's no point in quibbling when I've already been shown to be right. 

Here is the daily data on new cases from worldometer

That's odd. If you look at their actual graph and mouse over the dates, their daily numbers don't line up with what you posted...

https://www.worldometers.info/coronavirus/country/us

Most are close (within a few hundred), but some are a couple thousand off.

I recorded these numbers after they closed out the day

it may be that they update the day numbers after closing it out not sure

I recorded these numbers after they closed out the day

it may be that they update the day numbers after closing it out not sure

Yeah, there are various adjustments. Sometimes states and counties don't report as timely as every day, and there are times that they've had to parse those reports to make sure that cases get applied to the appropriate day.

There have also been big numbers where a state will report some numbers they'd been missing. For example a state will say "we're reporting 5,000 today that were not reported over the past 30 days", and worldometers usually has that 5,000 in their total the first day but then revise and apply it to the previous 30 days weighted against the rest of the state's volume across those 30 days. 

I don't know what happened Oct 7, but apparently a bunch of states did that. Their explanation will give you a good idea of what they do with the numbers:

Oct 7
Updates

• 49,358 new cases and 930 new deaths in the United States
  
  NOTES:
  Lousiana: "LDH is reporting 1,052 new cases, including a backlog of 406 cases with collection dates before 9/16" [source]  Worldometer has distributed the backlog cases accordingly.
  North Dakota: of the 24 newly reported deaths, 16 occurred in the past few days and were redistributed by Worldometer according to the information gathered.
  South Dakota: DOH added “probable cases” to case counts. A probably case includes persons with positive antigen test for SARS-CoV-2, which causes COVID-19. There were 47 “probable cases” announced with 562 new confirmed cases. Confirmed cases are people with positive RT-PCR tests. The state added 421 new “probable cases” to the total case count on Wednesday. [source]  Worldometer has distributed these 421 cases over the time series.
  Kentucky: of the 2,393 reported cases today, 1,467 occurred in the past and have been therefore redistributed by Worldometer over the time series ("*Due to an upload of a significant backlog of case data from one jurisdiction, the majority of today's cases are from weeks past. The actual number of new cases today without the backlog is 926." [source])
  Texas:
  Denton County: "CPH is including 1,181 positive COVID-19 antigen tests that have been reported and investigated within the last few weeks.  In response to the change in testing trends, DCPH will also report antigen positive tests daily." [source] Worldometer has distributed the additional cases over the time series based on the historical graph of daily antigen cases provided by DCPH.
  Harris County: of the 625 cases reported today, 434 occurred in the past. [source] Worldometer has redistributed them accordingly.

On their chart, Oct 7 now reports 49,358 new daily cases nationally. Your spreadsheet above shows 53,478.

That's a difference of 4120. If you look at the above, they reference 406, 421, 1467, 1181, and 434 cases that occurred in the past. That's 3909 cases, pretty close to the 4120.

They're constantly trying to revise to get the numbers assigned to the right dates, even when states don't actually report things on time accurately reflecting the dates that cases/deaths occurred.

kinda like trying to hit a moving target

I’m sad to report my dad has passed from COVID-19. He was in the hospital for 2 weeks on a ventilator. It attacked his lungs. We knew after the first week that it was grim. Thank you for all your thoughts and prayers. 

Be careful out there. I know that it’s mostly the old and vulnerable who are dying but you never know how your body will respond. 

I’m sad to report my dad has passed from COVID-19. He was in the hospital for 2 weeks on a ventilator. It attacked his lungs. We knew after the first week that it was grim. Thank you for all your thoughts and prayers.

Be careful out there. I know that it’s mostly the old and vulnerable who are dying but you never know how your body will respond.

I'm truly sorry for your loss. And yes, definitely being careful, even though I've had it already. You never know.