- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Daily COVID Updated as of 11/2/20 8:00 PM
Posted on 3/23/20 at 9:43 am to Chromdome35
Posted on 3/23/20 at 9:43 am to Chromdome35
quote:
the size of the spreadsheet is getting so large that when I take the screen shots and then link them in here, the size is getting pretty small to read.
I don't want to speak for everyone, but most folks are focused on total active cases, new cases, deaths and new deaths.
If I were you, I would keep expanding the charts and graphs any way you see fit and allow folks who want to drill down more access it through a link to your Google Docs. That's a little more work, but once you figure out the links, you can do that a heck of a lot faster than making a bunch of specialty graphs.
Then, folks who want to highlight various bits can do that - you would be crowd sourcing the presentation that way. And the thread would still be based on a common operating picture - your hard work at the data collection/input level.
(And to keep it from adding a lot of inline posts, once you get a base package of Google Docs - just keep updating the link in the OP, as another efficiency method).
This post was edited on 3/23/20 at 9:44 am
Posted on 3/23/20 at 9:48 am to Chromdome35
quote:
I could use some feedback from you guys
I can't help with the presentation but my feedback is that this information is awesome!
I haven't said it yet but thank you. I know this must be time consuming but it is greatly appreciated.
Posted on 3/23/20 at 9:55 am to lsumatt
Dude me too. Hope you’re well. Seriously that was super great work back then. I literally hand write a list of what you said needed to happen and as they did I scratched them off and met myself get excited. You’re a hero to me 
Posted on 3/23/20 at 10:35 am to Chromdome35
WorldOMeter just updated their numbers.
The U.S. mortality rate continues to fall, now down to 1.19%.
The U.S. mortality rate continues to fall, now down to 1.19%.
Posted on 3/23/20 at 10:52 am to LSURussian
quote:
The U.S. mortality rate continues to fall, now down to 1.19%.
And as a continued reminder for those new to following the crisis at this level of detail, CFR (and it had a headstart because of a single, poorly run nursing home in Washington State, that sole source is still a respectable percentage of current U.S. Wuhan flu deaths) IS NOT the "infection mortality rate". Over time, the two numbers converge a bit, but the "C" in "CFR" represents a documented case under medical supervision/treatment.
Understandably it cannot capture the significant numbers of purely asymptomatic or only mildly symptomatic (unless caught by monitoring of those with known exposure, health care providers, etc.) who do not seek treatment, or even those with more moderate symptoms that treat with self-care.
And, we probably still have many scores (although the number is probably dropping) of presumptive cases that have not been confirmed/denied by testing yet.
So, the actual fatality rate of all infections (IFR) will likely have to be estimated when this is all over and a reasonable number of asymptomatic/never treated folks get antibody testing down the line (could take years).
And when it is so estimated, it will be no more than a few tenths of a percentage. Yes, that means roughly equivalent to a really strong strain of seasonal flu.
Amazing how that comparison comes up again and again, isn't it?
This post was edited on 3/23/20 at 10:53 am
Posted on 3/23/20 at 10:59 am to Ace Midnight
quote:
And as a continued reminder for those new to following the crisis at this level of detail, CFR (and it had a headstart because of a single, poorly run nursing home in Washington State, that sole source is still a respectable percentage of current U.S. Wuhan flu deaths) IS NOT the "infection mortality rate". Over time, the two numbers converge a bit, but the "C" in "CFR" represents a documented case under medical supervision/treatment.
Understandably it cannot capture the significant numbers of purely asymptomatic or only mildly symptomatic (unless caught by monitoring of those with known exposure, health care providers, etc.) who do not seek treatment, or even those with more moderate symptoms that treat with self-care.
And, we probably still have many scores (although the number is probably dropping) of presumptive cases that have not been confirmed/denied by testing yet.
So, the actual fatality rate of all infections (IFR) will likely have to be estimated when this is all over and a reasonable number of asymptomatic/never treated folks get antibody testing down the line (could take years).
And when it is so estimated, it will be no more than a few tenths of a percentage. Yes, that means roughly equivalent to a really strong strain of seasonal flu.
Amazing how that comparison comes up again and again, isn't it?
Well said sir.
Posted on 3/23/20 at 11:05 am to NYNolaguy1
But they'll say its because we shut down the country... otherwise it would have been 25% cfr
Posted on 3/23/20 at 11:20 am to bogeypro
quote:
But they'll say its because we shut down the country... otherwise it would have been 25% cfr
Thats assuming theres been no effect due to the measures taken. Obviously there has been some effect, but thats a much harder number to calculate.
Posted on 3/23/20 at 11:34 am to Ace Midnight
Guys, bear with me while I figure out the best way to link this google sheet in.
https://docs.google.com/spreadsheets/d/17R0Z5T063iqskP--0VXYtbnJqtkhU8RJ-5jL5_V1OZM/edit?usp=sharing
https://docs.google.com/spreadsheets/d/17R0Z5T063iqskP--0VXYtbnJqtkhU8RJ-5jL5_V1OZM/edit?usp=sharing
This post was edited on 3/23/20 at 11:45 am
Posted on 3/23/20 at 11:39 am to Chromdome35
I can't see it, but it looks like you tried to paste an image.
You want to go into Google Docs itself and get a link from that file and then paste it as a link, not an image.
Image is for your graphs and that's fine, but the actual data is better as a link, IMHO.
I would protect that file from changes other than yourself, though. You don't want thousands of yahoos accidentally altering your data.
You want to go into Google Docs itself and get a link from that file and then paste it as a link, not an image.
Image is for your graphs and that's fine, but the actual data is better as a link, IMHO.
I would protect that file from changes other than yourself, though. You don't want thousands of yahoos accidentally altering your data.
Posted on 3/23/20 at 11:43 am to Chromdome35
Huh. That image worked for me a minute ago. Now shows up as a link.
Posted on 3/23/20 at 12:13 pm to nerd guy
He's experimenting with links to Google Docs - so if folks want to drill down or pull out different data sets, they can do that and Chrome doesn't have to feel like he needs to format it 100 different ways.
We're just testing the process here, baw.
We're just testing the process here, baw.
Posted on 3/23/20 at 12:14 pm to Chromdome35
Yeah, that looks like that works. I can look at the whole thing and I can't make any changes that I can tell.
Posted on 3/23/20 at 12:16 pm to Ace Midnight
Italy reports 602 deaths yesterday. A decrease in death count two days in a row!
Posted on 3/23/20 at 12:19 pm to Freight Joker
Looking at their trend that's not surprising. They look to be on the backside of the curve at the moment.
Posted on 3/23/20 at 12:23 pm to Ace Midnight
Thanks, I've created a whole new tracking doc that is the link posted. I needed to clean up my old file, decided it was just easier to create a new one.
I can create any graph and add it if anyone has a request.
I can create any graph and add it if anyone has a request.
Posted on 3/23/20 at 12:23 pm to NYNolaguy1
quote:
Looking at their trend that's not surprising. They look to be on the backside of the curve at the moment.
Unreal how it ran over their country. Hopefully they are on the backside of it for good.
Posted on 3/23/20 at 12:25 pm to Chromdome35
Thanks. My only word of advice is to try and figure out a way of posting it while making sure you aren't doxxing yourself.
Google sheets has a function where you can see others who have viewed the document you made.
Google sheets has a function where you can see others who have viewed the document you made.
Posted on 3/23/20 at 12:26 pm to nerd guy
Looks like Mexico is starting to experience a lot of spread. That could be bad for the US as well if they overrun their healthcare system.
Posted on 3/23/20 at 12:27 pm to NYNolaguy1
Can you see anything reveling? I am not an expert at this?
Popular
Back to top



1




