KW

X

X

X

X

d

KW

2020

2021

Durchschnitt  2016-2019

Differenz

Differenz

2020Covid

2021Covid

Covid-Tote 2020

Covid-Tote2021

B1: 2021
C1: 2020
D1: 2019
E1: 2018
F1: 2017
G1: 2016
A2: 1
B2: 24643
C2: 18903
D2: 18686
E2: 19342
F2: 20918
G2: 18467
A3: 2
B3: 24288
C3: 19432
D3: 19170
E3: 18770
F3: 22070
G3: 18439
A4: 3
B4: 23981
C4: 19186
D4: 19163
E4: 19187
F4: 21236
G4: 18627
A5: 4
B5: 22554
C5: 18947
D5: 19505
E5: 19171
F5: 22083
G5: 18707
A6: 5
B6: 21504
C6: 19822
D6: 19812
E6: 19558
F6: 23640
G6: 18493
A7: 6
B7: 20668
C7: 19038
D7: 19981
E7: 20086
F7: 22744
G7: 18541
A8: 7
B8: 20162
C8: 19664
D8: 20150
E8: 21254
F8: 22683
G8: 18483
A9: 8
C9: 18958
D9: 20349
E9: 22888
F9: 22266
G9: 18475
A10: 9
C10: 19498
D10: 20790
E10: 25535
F10: 20930
G10: 18926
A11: 10
C11: 19647
D11: 20453
E11: 26777
F11: 19102
G11: 18888
A12: 11
C12: 19890
D12: 19795
E12: 24385
F12: 18665
G12: 18971
A13: 12
C13: 19743
D13: 19016
E13: 22777
F13: 17640
G13: 18826
A14: 13
C14: 19707
D14: 18562
E14: 20906
F14: 17731
G14: 18617
A15: 14
C15: 20652
D15: 18671
E15: 20038
F15: 17028
G15: 18244
A16: 15
C16: 20516
D16: 17852
E16: 19165
F16: 16901
G16: 17712
A17: 16
C17: 19285
D17: 18089
E17: 17992
F17: 16637
G17: 16775
A18: 17
C18: 18559
D18: 17894
E18: 17093
F18: 17634
G18: 17053
A19: 18
C19: 17918
D19: 17090
E19: 16789
F19: 17129
G19: 16901
A20: 19
C20: 17641
D20: 17118
E20: 17226
F20: 17343
G20: 17629
A21: 20
C21: 16989
D21: 17315
E21: 16488
F21: 17079
G21: 16601
A22: 21
C22: 17161
D22: 17080
E22: 16513
F22: 16451
G22: 16286
A23: 22
C23: 16764
D23: 16921
E23: 17039
F23: 16902
G23: 16346
A24: 23
C24: 17273
D24: 17491
E24: 16714
F24: 15846
G24: 15799
A25: 24
C25: 16605
D25: 16484
E25: 15582
F25: 16087
G25: 15717
A26: 25
C26: 16396
D26: 16639
E26: 15843
F26: 16819
G26: 16910
A27: 26
C27: 17287
D27: 17918
E27: 16569
F27: 16076
G27: 15699
A28: 27
C28: 16438
D28: 16552
E28: 16622
F28: 16424
G28: 16229
A29: 28
C29: 16162
D29: 16319
E29: 16070
F29: 15603
G29: 16172
A30: 29
C30: 16523
D30: 16856
E30: 16702
F30: 16589
G30: 16985
A31: 30
C31: 16908
D31: 19630
E31: 18340
F31: 16058
G31: 16157
A32: 31
C32: 17406
D32: 17034
E32: 20371
F32: 16494
G32: 15439
A33: 32
C33: 17479
D33: 16540
E33: 18478
F33: 15784
G33: 15487
A34: 33
C34: 19682
D34: 15934
E34: 16890
F34: 16148
G34: 16258
A35: 34
C35: 17552
D35: 16263
E35: 16612
F35: 15880
G35: 17147
A36: 35
C36: 16633
D36: 17637
E36: 16000
F36: 16064
G36: 16101
A37: 36
C37: 16727
D37: 15988
E37: 16390
F37: 15706
G37: 16116
A38: 37
C38: 17094
D38: 16303
E38: 16292
F38: 16146
G38: 16372
A39: 38
C39: 17531
D39: 16500
E39: 16651
F39: 16505
G39: 15606
A40: 39
C40: 17392
D40: 17402
E40: 15969
F40: 16747
G40: 16336
A41: 40
C41: 17571
D41: 16899
E41: 16622
F41: 16664
G41: 16352
A42: 41
C42: 17448
D42: 17666
E42: 16993
F42: 17470
G42: 17427
A43: 42
C43: 17700
D43: 17713
E43: 16552
F43: 17139
G43: 17599
A44: 43
C44: 18546
D44: 17327
E44: 16608
F44: 17059
G44: 17586
A45: 44
C45: 18535
D45: 17488
E45: 16895
F45: 16762
G45: 17580
A46: 45
C46: 19021
D46: 17859
E46: 17604
F46: 17371
G46: 17782
A47: 46
C47: 19710
D47: 18242
E47: 16842
F47: 17594
G47: 18591
A48: 47
C48: 20145
D48: 18535
E48: 17785
F48: 17676
G48: 17911
A49: 48
C49: 21242
D49: 18581
E49: 18091
F49: 17877
G49: 18146
A50: 49
C50: 22580
D50: 19143
E50: 18342
F50: 18295
G50: 18793
A51: 50
C51: 23876
D51: 19101
E51: 17943
F51: 18504
G51: 18885
A52: 51
C52: 24615
D52: 19062
E52: 18990
F52: 18500
G52: 19376
A53: 52
C53: 25383
D53: 18204
E53: 17954
F53: 18652
G53: 19744
A54: 53
C54: 25267
H3 = mean(D3:G3)
H4 = mean(D4:G4)
H5 = mean(D5:G5)
H6 = mean(D6:G6)
H7 = mean(D7:G7)
H8 = mean(D8:G8)
H9 = mean(D9:G9)
H10 = mean(D10:G10)
H11 = mean(D11:G11)
H12 = mean(D12:G12)
H13 = mean(D13:G13)
H14 = mean(D14:G14)
H15 = mean(D15:G15)
H16 = mean(D16:G16)
H17 = mean(D17:G17)
H18 = mean(D18:G18)
H19 = mean(D19:G19)
H20 = mean(D20:G20)
H21 = mean(D21:G21)
H22 = mean(D22:G22)
H23 = mean(D23:G23)
H24 = mean(D24:G24)
H25 = mean(D25:G25)
H26 = mean(D26:G26)
H27 = mean(D27:G27)
H28 = mean(D28:G28)
H29 = mean(D29:G29)
H30 = mean(D30:G30)
H31 = mean(D31:G31)
H32 = mean(D32:G32)
H33 = mean(D33:G33)
H34 = mean(D34:G34)
H35 = mean(D35:G35)
H36 = mean(D36:G36)
H37 = mean(D37:G37)
H38 = mean(D38:G38)
H39 = mean(D39:G39)
H40 = mean(D40:G40)
H41 = mean(D41:G41)
H42 = mean(D42:G42)
H43 = mean(D43:G43)
H44 = mean(D44:G44)
H45 = mean(D45:G45)
H46 = mean(D46:G46)
H47 = mean(D47:G47)
H48 = mean(D48:G48)
H49 = mean(D49:G49)
H50 = mean(D50:G50)
H51 = mean(D51:G51)
H52 = mean(D52:G52)
H53 = mean(D53:G53)
H54 = mean(D54:G54)
H2 = mean(D2:G2)
a = 1 (slider from 1 to 53, step 1)
LiAH = Sequence((Cell[1, a], Cell[8, a]), a, 2, 52)
LiH = Sequence(Cell[8, a], a, 2, 53)
f = PolyLine(LiAH)
LiAC = Sequence((Cell[1, a], Cell[3, a]), a, 2, 54)
g = PolyLine(LiAC)
LiAB = Sequence((Cell[1, a], Cell[2, a]), a, 2, 8)
h = PolyLine(LiAB)
Li2020 = Sequence(Cell[3, a], a, 2, 54)
LiKW = Sequence(Cell[1, a], a, 2, 53)
b = BarChart(LiKW, LiH, 1)
Li2021 = Sequence(Cell[2, a], a, 2, 8)
A: (a, Element[Li2020, a])
B: (a, Element[Li2021, a])
C: (a, Element[LiH, a])
Li2016 = Sequence(Cell[7, a], a, 2, 53)
Li2017 = Sequence(Cell[6, a], a, 2, 53)
Li2018 = Sequence(Cell[5, a], a, 2, 53)
LI2019 = Sequence(Cell[4, a], a, 2, 53)
kw2020 = Element(Li2020, a)
kw2019 = Element(LI2019, a)
kw2018 = Element(Li2018, a)
kw2017 = Element(Li2017, a)
kw2016 = Element(Li2016, a)
kw2021 = Element(Li2021, a)
kwschnitt = Element(LiH, a)
Text2: "2016\; \; →\; \; " + (LaTeX[kw2016]) + "\\  2017\; \; →\; \;  " + (LaTeX[kw2017]) + "\\2018\; \; →\; \; " + (LaTeX[kw2018]) + "\\2019\; \; →\; \;  " + (LaTeX[kw2019]) + "\\Schnitt\; \; →\; \;" + (LaTeX[kwschnitt]) + ""
Text3: "2020\; \; →\; \;  " + (LaTeX[kw2020]) + "\\2021\; \; →\; \;" + (LaTeX[kw2021]) + ""
Text1: "Sterbedaten\;\;  Kalenderwoche\; " + (LaTeX[a]) + ""
i = Segment(A, C)
j = Segment(B, C)
c: y(B) - y(C)
d: y(A) - y(C)
Text5: "Differenz = " + (LaTeX[c]) + ""
Text4: "Differenz = " + (LaTeX[d]) + ""
I2: 0
I3: 0
I4: 0
I5: 0
I6: 0
I7: 0
I8: 0
I9: 0
I10: 0
I11: 0
I12: 12
I13: 43
I14: 334
I15: 953
I16: 1331
I17: 1621
I18: 1346
I19: 1009
I20: 746
I21: 519
I22: 333
I23: 253
I24: 168
I25: 119
I26: 95
I27: 75
I28: 55
I29: 51
I30: 21
I31: 34
I32: 23
I33: 55
I34: 35
I35: 38
I36: 26
I37: 30
I38: 24
I39: 37
I40: 71
I41: 72
I42: 86
I43: 162
I44: 255
I45: 449
I46: 808
I47: 1196
I48: 1537
I49: 2101
I50: 2649
I51: 3015
I52: 4262
I53: 3729
I54: 4494
J2: 6071
J3: 6076
J4: 5451
J5: 5075
J6: 4572
J7: 3443
J8: 2881
J9: 2204
J10: 1855
LiCov2020 = Sequence(Cell[9, a], a, 2, 54)
LiCov2021 = Sequence(Cell[10, a], a, 2, 8)
LiAJ = Sequence((Cell[1, a], Cell[10, a]), a, 2, 8)
LiAI = Sequence((Cell[1, a], Cell[9, a]), a, 2, 54)
k = PolyLine(LiAI)
l = PolyLine(LiAJ)
D: (a, Element[LiCov2020, a])
E: (a, Element[LiCov2021, a])
Text6: "davon Cov " + (y(D)) + ""
Text7: "davon Cov " + (y(E)) + ""
m = Segment(E, (x(E), 0))
n = Segment(D, (x(D), 0))