[Hidden-tech] Excel or Google Sheets Expert? For Covid Risk Calculator, and other work.

[Chris Duncan, GISmatters]

Hi Rob,

I poked around on that github site and most or all of the data files are 
CSV files -- comma-separated value format -- which are readily imported 
into Excel, OpenOffice Calc... I don't know about Google Sheets b/c I 
avoid all things Google as much as possible but I'd be surprised if it 
doesn't open them as well.

One thing I noticed is that right-clicking on a single .csv filename and 
choosing "Save As..." saved the HTML for the github page that you get if 
you click on those filename links rather than the actual CSV file 
contents... to get (only) the actual CSV file, you need to either:
* download the entire repository (all the folders and files) from 
https://github.com/CSSEGISandData/COVID-19 -- on that page there is a 
green "Code" button which offers you a zip file download option; once 
you unzip that file you will have the entire directory structure with 
all the .csv files in it
* download individual files by clicking on the .csv filename, and then 
on the next github page where you see the file listed in the main part 
of the page (unless it's too large to list), clicking the "Raw" option 
to get *just* the csv file contents, then save that "page" as a .csv file

Once you have one or more .csv files, you can just double-click them to 
open with your default spreadsheet application.

Chris


On 5/8/21 6:13 PM, Rob Laporte via Hidden-discuss wrote:
> Hi All,
> 
> *I�ve long thought the public should have a Covid risk calculato*r in 
> which one could enter or click their age and comorbidities to get a 
> probability of hospitalization, critical care, and death upon infection. 
> Given the year plus of official date now, it should be relatively easy 
> to make a one that accurately reflects official data. For example, the 
> CDC recently updated their �survival rates by age� behind which they 
> provide more detailed data then this CDC summary::
> 
>     0-17:� � � �99.997%
>     18-49:� � �99.95%
>     50-64:� � �99.4%
>     65+:� � � � 91%
> 
> 
> Backing out all comorbidities makes risks dramatically lower than the 
> above. For example, the CDC reports that 78% of deaths come from the 
> overweight and obese cohort. *Many people would like to know their 
> individual risk*.
> 
> You would think our governments would provide this, but I could find 
> nothing of the sort.*This Github project may be it*, but if it is a 
> spreadsheet, my upload to Google Sheets didn�t make it work; perhaps it 
> would work on Excel. 
> https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data <https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data>�.
> 
> *For anyone who could handle the above, I have other Google Sheet work 
> for my firm I�d pay for.*
> 
> Take Care,
> 
> 
> Rob Laporte
> 
> Chief Business Development Officer | Founder | Chairman
> 
> DISC - Making Websites Make Money
> 
> 413-584-6500
> 
> rob at 2disc.com <mailto:rob at 2disc.com>�| LinkedIn 
> <https://www.linkedin.com/in/2disc/> | 2DISC.com <https://www.2disc.com>
> 
> 
> *NOTE:*�Emails can be blocked by spam filters throughout the web. If you 
> don�t get a reply within an expected span of time, please call.
> 
> 
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
> 
> You are receiving this because you are on the Hidden-Tech Discussion list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
> 

-- 

Chris Duncan, Ph.D.
President, GISmatters
duncan at gismatters.com

http://www.gismatters.com/

Tel: +1 413.549.2052
Fax: +1 413.658.0346