corona-al.csv
ABC
1
2
source:
3
4
11 add data
in the sheet "Data", add another row with information with the following sequence
5
New cases, new deaths, recoveries total, new cases by qark, total cases for bashkia (Tropoja BC, Fier FR, Has HS, Kavaja KA, Lushnja LU, Rrogozhina RR, Tirana TR), total deaths by qark
6
in columns B-G, in Qarks Durres, Fier, Kukës and Tirana, you can copy values from last row for automatic calculation
7
8
2update data+
go to sheet "Data+"
9
not necessary anymore
in row 4, change value +1 by the marked values: "=Data!I19"
10
in row 5, change value +1 by the marked values: "=Data!AB19"
11
12
3Check charts
Usually, the charts update by themselves where needed. But Check in "other charts" if end of chart shows correct date, if all 12 Qarks show up (BR-VL) in other charts
13
14
+ Update if needed
in the sheet "Other Charts", click on chart 1, click on the bullets in the top right corner, choose "Edit chart", change "Data range" by adding +1 by the marked values: "Data!A1:A17,Data!C1:C17"
15
16
in the sheet "Other Charts", click on chart 2 click on the bullets in the top right corner, choose "Edit chart", change "Data range" by adding +1 by the marked values: "Data!A1:A17,Data!F1:F17"
17
18
in the sheet "Cases Qark", click on the button "Edit chart" on the top menu, change "Data range" by adding +1 by the marked values: "Data!A1:A17,Data!C1:C17,Data!I1:T17"
19
20
in the sheet "Map", click on the button "Edit chart" on the top menu, change "Data range" by adding +1 by the marked values: "'Data+'!A2:L3,Data!I17:T17"
21
this chart is sometimes a little bit tricky: it should be horizontally
22
23
in the sheet "Prevalence", no change should be necessary if you updated the sheet "Data+"
24
the code should be: "'Data+'!B1:N1,'Data+'!B7:N7"
25
26
in the sheet "Fatalities", no change should be necessary if you updated the sheet "Data+"
27
the code should be: "'Data+'!B1:N1,'Data+'!B8:N8"
28
29
4Cache leeren
30