Help with graphs for COVID-19 case tracking

[ilovequiche]

Hi all,

I am tracking a few COVID19 cases using the attached spreadsheet and am physically counting the data to produce a graph. Is there a way of automating this data and graph updates to speed things up please?

The graph in my spreadsheet shows the data i use to track but any additional suggested graphs or tricks would be most welcome.

Thank you in advance. Much appreciated.

STAY HOME AND STAY SAFE

[Kaper]

You could probably use formulas like: D24:

Please Login or Register  to view this content.

and similar in next cells But ast there is no data (of course dummy :P) in a sheet I'm not sure if it's what you are looking for. For these with two conditions to be checked - countifs shall be used, like D26:

Please Login or Register  to view this content.

Attaching a file observe such set of hints:

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If there are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, empty cells between data, mixed text/numbers, etc. - please show them all, or at least indicate in text). The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!