rkidaten

geschätzte R - Werte
NOW-Casting

Tag 0     04.03.2020
Tag 10   14.03.2020
Tag 30   03.04.2020
Tag 50   23.04.2020
Tag 60   03.05.2020
Tag 100 12.06.2020

RKI-Schätzung

R bezieht sich immer auf 4 Tage!

08.04.2021

09.04.2021

10.04.2021

11.04.2021

12.04.2021

13.04.2021

14.04.2021

15.04.2021

16.04.2021

17.04.2021

18.04.2021

19.04.2021

20.04.2021

21.04.2021

22.04.2021

23.04.2021

24.04.2021

25.04.2021

26.04.2021

27.04.2021

28.04.2021

29.04.2021

30.04.2021

01.05.2021

02.05.2021

03.05.2021

04.05.2021

05.05.2021

06.05.2021

07.05.2021

08.05.2021

09.05.2021

10.05.2021

11.05.2021

12.05.2021

13.05.2021

14.05.2021

15.05.2021

16.05.2021

17.05.2021

18.05.2021

19.05.2021

20.05.2021

21.05.2021

22.05.2021

23.05.2021

24.05.2021

25.05.2021

26.05.2021

27.05.2021

28.05.2021

29.05.2021

30.05.2021

31.05.2021

01.06.2021

02.06.2021

03.06.2021

04.06.2021

05.06.2021

06.06.2021

07.06.2021

08.06.2021

09.06.2021

10.06.2021

11.06.2021

12.06.2021

13.06.2021

14.06.2021

15.06.2021

16.06.2021

17.06.2021

18.06.2021

19.06.2021

20.06.2021

21.06.2021

22.06.2021

23.06.2021

24.06.2021

25.06.2021

26.06.2021

27.06.2021

28.06.2021

29.06.2021

30.06.2021

01.07.2021

02.07.2021

03.07.2021

04.07.2021

05.07.2021

06.07.2021

07.07.2021

08.07.2021

09.07.2021

10.07.2021

11.07.2021

12.07.2021

13.07.2021

14.07.2021

15.07.2021

16.07.2021

17.07.2021

geglättete R-Werte

Neuinfizierte

Tag = 100 (slider from 1 to 100, step 1)
LiAI = Sequence((Cell[1, a], Cell[5, a]), a, 7, Tag + 1)
LiAL = Sequence((Cell[1, a], Cell[12, a]), a, 1, Tag + 1)
LiAJ = Sequence((Cell[1, a], Cell[10, a]), a, 18, Tag + 1)
LiAD = Sequence((Cell[1, a], Cell[4, a]), a, 12, Tag + 1)
LiAB = Sequence((Cell[1, a], Cell[2, a]), a, 1, Tag + 1)
LiCgesamt = Sequence(Cell[3, a], a, 1, Tag + 1)
A6 = 5
A5 = 4
A4 = 3
A3 = 2
A2: 1
A1: 0
A94 = 93 (slider from -5 to 100)
A93 = 92 (slider from -5 to 100)
A92 = 91 (slider from -5 to 100)
A91 = 90 (slider from -5 to 100)
A90 = 89 (slider from -5 to 100)
A89 = 88 (slider from -5 to 100)
A88 = 87 (slider from -5 to 100)
A87 = 86 (slider from -5 to 100)
A86 = 85 (slider from -5 to 100)
A85 = 84 (slider from -5 to 100)
A84 = 83 (slider from -5 to 100)
A83 = 82 (slider from -5 to 100)
A82 = 81 (slider from -5 to 100)
A81 = 80 (slider from -5 to 100)
A80 = 79 (slider from -5 to 100)
A79 = 78 (slider from -5 to 100)
A78 = 77 (slider from -5 to 100)
A77 = 76 (slider from -5 to 100)
A76 = 75 (slider from -5 to 100)
A75 = 74 (slider from -5 to 100)
A74 = 73 (slider from -5 to 100)
A73 = 72 (slider from -5 to 100)
A72 = 71 (slider from -5 to 100)
A70 = 69 (slider from -5 to 100)
A68 = 67 (slider from -5 to 100)
A66 = 65 (slider from -5 to 100)
A65 = 64 (slider from -5 to 100)
A18 = 17
A19 = 18
A20 = 19
A21 = 20
A22 = 21
A23 = 22
A24 = 23
A25 = 24
A26 = 25
A27 = 26
A28 = 27
A29 = 28
A30 = 29
A31 = 30
A32 = 31
A33 = 32
A34 = 33
A35 = 34
A36 = 35 (slider from -5 to 50)
A37 = 36 (slider from -5 to 50)
A38 = 37 (slider from -5 to 50)
A39 = 38 (slider from -5 to 50)
A40 = 39 (slider from -5 to 50)
A41 = 40 (slider from -5 to 50)
A42 = 41 (slider from -5 to 50)
A43 = 42 (slider from -5 to 50)
A44 = 43 (slider from -5 to 50)
A45 = 44 (slider from -5 to 50)
A46 = 45 (slider from -5 to 50)
A47 = 46 (slider from -5 to 50)
A48 = 47 (slider from -5 to 50)
A49 = 48 (slider from -5 to 50)
A50 = 49 (slider from -5 to 50)
A51 = 50 (slider from -5 to 50)
A52 = 51 (slider from -5 to 100)
A53 = 52 (slider from -5 to 100)
A54 = 53 (slider from -5 to 100)
A55 = 54 (slider from -5 to 100)
A56 = 55 (slider from -5 to 100)
A57 = 56 (slider from -5 to 100)
A58 = 57 (slider from -5 to 100)
A59 = 58 (slider from -5 to 100)
A60 = 59 (slider from -5 to 100)
A61 = 60 (slider from -5 to 100)
A62 = 61 (slider from -5 to 100)
A63 = 62 (slider from -5 to 100)
A64 = 63 (slider from -5 to 100)
A67 = 66 (slider from -5 to 100)
A69 = 68 (slider from -5 to 100)
A71 = 70 (slider from -5 to 100)
A95 = 94 (slider from -5 to 100)
A96 = 95 (slider from -5 to 100)
A97 = 96 (slider from -5 to 100)
A98 = 97 (slider from -5 to 100)
A99 = 98 (slider from -5 to 100)
A100 = 99 (slider from -5 to 100)
A101 = 100 (slider from -5 to 200)
A11 = 10
A7 = 6
A10 = 9
A9 = 8
A8 = 7
A12 = 11
A13 = 12
A14 = 13
A15 = 14
A16 = 15
A17 = 16
P1: 0
O95: 6
O94: 35
O93: 49
O92: 31
O91: 48
O90: 31
O89: 1
O88: 7
O87: 16
O86: 69
O85: 63
O84: 56
O83: 57
O82: 8
O81: 8
O80: 68
O79: 62
O78: 93
O77: 51
O76: 77
O75: 10
O74: 16
O73: 99
O72: 91
O71: 105
O70: 137
O69: 93
O68: 10
O67: 18
O66: 129
O65: 102
O64: 94
O63: 107
O62: 140
O61: 22
O60: 74
O59: 122
O58: 86
O57: 166
O56: 179
O55: 153
O54: 36
O53: 56
O52: 163
O51: 192
O50: 269
O49: 270
O48: 33
O47: 43
O46: 82
O45: 170
O44: 226
O43: 237
O42: 284
O41: 221
O40: 64
O39: 71
O38: 177
O37: 190
O36: 278
O35: 268
O34: 283
O33: 54
O32: 127
O31: 238
O30: 284
O29: 250
O28: 285
O27: 315
O26: 84
O25: 110
O24: 232
O23: 306
O22: 264
O21: 312
O20: 344
O19: 60
O18: 120
O17: 286
O16: 265
O15: 259
O14: 331
O13: 297
O12: 92
O11: 67
O10: 219
O9: 247
O8: 293
O7: 342
O6: 294
O5: 99
O4: 104
O3: 246
O2: 296
P2: P1 + O2
P3: P2 + O3
P4: P3 + O4
P5: P4 + O5
P6: P5 + O6
P7: P6 + O7
P8: P7 + O8
P9: P8 + O9
P10: P9 + O10
P11: P10 + O11
P12: P11 + O12
P13: P12 + O13
P14: P13 + O14
P15: P14 + O15
P16: P15 + O16
P17: P16 + O17
P18: P17 + O18
P19: P18 + O19
P20: P19 + O20
P21: P20 + O21
P22: P21 + O22
P23: P22 + O23
P24: P23 + O24
P25: P24 + O25
P26: P25 + O26
P27: P26 + O27
P28: P27 + O28
P29: P28 + O29
P30: P29 + O30
P31: P30 + O31
P32: P31 + O32
P33: P32 + O33
P34: P33 + O34
P35: P34 + O35
P36: P35 + O36
P37: P36 + O37
P38: P37 + O38
P39: P38 + O39
P40: P39 + O40
P41: P40 + O41
P42: P41 + O42
P43: P42 + O43
P44: P43 + O44
P45: P44 + O45
P46: P45 + O46
P47: P46 + O47
P48: P47 + O48
P49: P48 + O49
P50: P49 + O50
P51: P50 + O51
P52: P51 + O52
P53: P52 + O53
P54: P53 + O54
P55: P54 + O55
P56: P55 + O56
P57: P56 + O57
P58: P57 + O58
P59: P58 + O59
P60: P59 + O60
P61: P60 + O61
P62: P61 + O62
P63: P62 + O63
P64: P63 + O64
P65: P64 + O65
P66: P65 + O66
P67: P66 + O67
P68: P67 + O68
P69: P68 + O69
P70: P69 + O70
P71: P70 + O71
P72: P71 + O72
P73: P72 + O73
P74: P73 + O74
P75: P74 + O75
P76: P75 + O76
P77: P76 + O77
P78: P77 + O78
P79: P78 + O79
P80: P79 + O80
P81: P80 + O81
P82: P81 + O82
P83: P82 + O83
P84: P83 + O84
P85: P84 + O85
P86: P85 + O86
P87: P86 + O87
P88: P87 + O88
P89: P88 + O89
P90: P89 + O90
P91: P90 + O91
P92: P91 + O92
P93: P92 + O93
P94: P93 + O94
P95: P94 + O95
B1: 20407
B94: 952
B89: 212
B87: 671
B85: 892
B83: 404
B81: 538
B71: 1330
B69: 652
B67: 1489
B64: 3187
B63: 3254
B62: 1204
B61: 1117
B60: 2440
B59: 2294
B58: 3165
L64: round((B58 + B59 + B60 + B61 + B62 + B63 + B64) / 7, 0)
B57: 4640
L63: round((B57 + B58 + B59 + B60 + B61 + B62 + B63) / 7, 0)
B56: 4917
L62: round((B56 + B57 + B58 + B59 + B60 + B61 + B62) / 7, 0)
B55: 1785
L61: round((B55 + B56 + B57 + B58 + B59 + B60 + B61) / 7, 0)
B54: 1978
L60: round((B54 + B55 + B56 + B57 + B58 + B59 + B60) / 7, 0)
B53: 3852
L59: round((B53 + B54 + B55 + B56 + B57 + B58 + B59) / 7, 0)
B52: 5426
L58: round((B52 + B53 + B54 + B55 + B56 + B57 + B58) / 7, 0)
B51: 7380
L57: round((B51 + B52 + B53 + B54 + B55 + B56 + B57) / 7, 0)
B50: 6313
L56: round((B50 + B51 + B52 + B53 + B54 + B55 + B56) / 7, 0)
B49: 2626
L55: round((B49 + B50 + B51 + B52 + B53 + B54 + B55) / 7, 0)
B48: 1911
L54: round((B48 + B49 + B50 + B51 + B52 + B53 + B54) / 7, 0)
B47: 2682
L53: round((B47 + B48 + B49 + B50 + B51 + B52 + B53) / 7, 0)
B46: 6714
L52: round((B46 + B47 + B48 + B49 + B50 + B51 + B52) / 7, 0)
B45: 7082
L51: round((B45 + B46 + B47 + B48 + B49 + B50 + B51) / 7, 0)
B44: 8769
L50: round((B44 + B45 + B46 + B47 + B48 + B49 + B50) / 7, 0)
B43: 12298
L49: round((B43 + B44 + B45 + B46 + B47 + B48 + B49) / 7, 0)
B42: 11040
L48: round((B42 + B43 + B44 + B45 + B46 + B47 + B48) / 7, 0)
B41: 4209
L47: round((B41 + B42 + B43 + B44 + B45 + B46 + B47) / 7, 0)
B40: 5412
L46: round((B40 + B41 + B42 + B43 + B44 + B45 + B46) / 7, 0)
B39: 8500
L45: round((B39 + B40 + B41 + B42 + B43 + B44 + B45) / 7, 0)
B38: 7894
L44: round((B38 + B39 + B40 + B41 + B42 + B43 + B44) / 7, 0)
B37: 11336
L43: round((B37 + B38 + B39 + B40 + B41 + B42 + B43) / 7, 0)
B36: 17419
L42: round((B36 + B37 + B38 + B39 + B40 + B41 + B42) / 7, 0)
B35: 14909
L41: round((B35 + B36 + B37 + B38 + B39 + B40 + B41) / 7, 0)
B34: 6125
L40: round((B34 + B35 + B36 + B37 + B38 + B39 + B40) / 7, 0)
B33: 6922
L39: round((B33 + B34 + B35 + B36 + B37 + B38 + B39) / 7, 0)
B32: 12656
L38: round((B32 + B33 + B34 + B35 + B36 + B37 + B38) / 7, 0)
B31: 15685
L37: round((B31 + B32 + B33 + B34 + B35 + B36 + B37) / 7, 0)
B30: 18485
L36: round((B30 + B31 + B32 + B33 + B34 + B35 + B36) / 7, 0)
B29: 21953
L35: round((B29 + B30 + B31 + B32 + B33 + B34 + B35) / 7, 0)
B28: 18034
L34: round((B28 + B29 + B30 + B31 + B32 + B33 + B34) / 7, 0)
B27: 7534
L33: round((B27 + B28 + B29 + B30 + B31 + B32 + B33) / 7, 0)
B26: 9160
L32: round((B26 + B27 + B28 + B29 + B30 + B31 + B32) / 7, 0)
B25: 16290
L31: round((B25 + B26 + B27 + B28 + B29 + B30 + B31) / 7, 0)
B24: 18935
L30: round((B24 + B25 + B26 + B27 + B28 + B29 + B30) / 7, 0)
B23: 24329
L29: round((B23 + B24 + B25 + B26 + B27 + B28 + B29) / 7, 0)
B22: 24736
L28: round((B22 + B23 + B24 + B25 + B26 + B27 + B28) / 7, 0)
B21: 22231
L27: round((B21 + B22 + B23 + B24 + B25 + B26 + B27) / 7, 0)
B20: 10976
L26: round((B20 + B21 + B22 + B23 + B24 + B25 + B26) / 7, 0)
B19: 11907
L25: round((B19 + B20 + B21 + B22 + B23 + B24 + B25) / 7, 0)
B18: 18773
L24: round((B18 + B19 + B20 + B21 + B22 + B23 + B24) / 7, 0)
B17: 23392
L23: round((B17 + B18 + B19 + B20 + B21 + B22 + B23) / 7, 0)
B16: 27543
L22: round((B16 + B17 + B18 + B19 + B20 + B21 + B22) / 7, 0)
B15: 29518
L21: round((B15 + B16 + B17 + B18 + B19 + B20 + B21) / 7, 0)
B14: 24884
L20: round((B14 + B15 + B16 + B17 + B18 + B19 + B20) / 7, 0)
B13: 9609
L19: round((B13 + B14 + B15 + B16 + B17 + B18 + B19) / 7, 0)
B12: 11437
L18: round((B12 + B13 + B14 + B15 + B16 + B17 + B18) / 7, 0)
B11: 19185
L17: round((B11 + B12 + B13 + B14 + B15 + B16 + B17) / 7, 0)
B10: 23804
L16: round((B10 + B11 + B12 + B13 + B14 + B15 + B16) / 7, 0)
B9: 25831
L15: round((B9 + B10 + B11 + B12 + B13 + B14 + B15) / 7, 0)
B8: 29426
L14: round((B8 + B9 + B10 + B11 + B12 + B13 + B14) / 7, 0)
B7: 21693
L13: round((B7 + B8 + B9 + B10 + B11 + B12 + B13) / 7, 0)
B6: 10810
L12: round((B6 + B7 + B8 + B9 + B10 + B11 + B12) / 7, 0)
B5: 13245
L11: round((B5 + B6 + B7 + B8 + B9 + B10 + B11) / 7, 0)
B4: 17855
L10: round((B4 + B5 + B6 + B7 + B8 + B9 + B10) / 7, 0)
B3: 24097
L9: round((B3 + B4 + B5 + B6 + B7 + B8 + B9) / 7, 0)
B2: 25464
L8: round((B2 + B3 + B4 + B5 + B6 + B7 + B8) / 7, 0)
L7: round((B1 + B2 + B3 + B4 + B5 + B6 + B7) / 7, 0)
B65: 2440
L65: round((B59 + B60 + B61 + B62 + B63 + B64 + B65) / 7, 0)
B66: 1911
L67: round((B61 + B62 + B63 + B64 + B65 + B66 + B67) / 7, 0)
L66: round((B60 + B61 + B62 + B63 + B64 + B65 + B66) / 7, 0)
B68: 549
L69: round((B63 + B64 + B65 + B66 + B67 + B68 + B69) / 7, 0)
L68: round((B62 + B63 + B64 + B65 + B66 + B67 + B68) / 7, 0)
B70: 1455
L71: round((B65 + B66 + B67 + B68 + B69 + B70 + B71) / 7, 0)
L70: round((B64 + B65 + B66 + B67 + B68 + B69 + B70) / 7, 0)
B72: 1076
L72: round((B66 + B67 + B68 + B69 + B70 + B71 + B72) / 7, 0)
B73: 1108
L73: round((B67 + B68 + B69 + B70 + B71 + B72 + B73) / 7, 0)
B74: 842
L74: round((B68 + B69 + B70 + B71 + B72 + B73 + B74) / 7, 0)
B75: 346
L75: round((B69 + B70 + B71 + B72 + B73 + B74 + B75) / 7, 0)
B76: 455
L76: round((B70 + B71 + B72 + B73 + B74 + B75 + B76) / 7, 0)
B77: 1016
L77: round((B71 + B72 + B73 + B74 + B75 + B76 + B77) / 7, 0)
B78: 1008
L78: round((B72 + B73 + B74 + B75 + B76 + B77 + B78) / 7, 0)
B79: 774
L79: round((B73 + B74 + B75 + B76 + B77 + B78 + B79) / 7, 0)
B80: 592
L81: round((B75 + B76 + B77 + B78 + B79 + B80 + B81) / 7, 0)
L80: round((B74 + B75 + B76 + B77 + B78 + B79 + B80) / 7, 0)
B82: 219
L83: round((B77 + B78 + B79 + B80 + B81 + B82 + B83) / 7, 0)
L82: round((B76 + B77 + B78 + B79 + B80 + B81 + B82) / 7, 0)
B84: 808
L85: round((B79 + B80 + B81 + B82 + B83 + B84 + B85) / 7, 0)
L84: round((B78 + B79 + B80 + B81 + B82 + B83 + B84) / 7, 0)
B86: 649
L87: round((B81 + B82 + B83 + B84 + B85 + B86 + B87) / 7, 0)
L86: round((B80 + B81 + B82 + B83 + B84 + B85 + B86) / 7, 0)
B88: 559
L89: round((B83 + B84 + B85 + B86 + B87 + B88 + B89) / 7, 0)
L88: round((B82 + B83 + B84 + B85 + B86 + B87 + B88) / 7, 0)
B90: 440
L90: round((B84 + B85 + B86 + B87 + B88 + B89 + B90) / 7, 0)
B91: 985
L91: round((B85 + B86 + B87 + B88 + B89 + B90 + B91) / 7, 0)
B92: 970
L92: round((B86 + B87 + B88 + B89 + B90 + B91 + B92) / 7, 0)
B93: 949
L94: round((B88 + B89 + B90 + B91 + B92 + B93 + B94) / 7, 0)
L93: round((B87 + B88 + B89 + B90 + B91 + B92 + B93) / 7, 0)
B95: 745
L95: round((B89 + B90 + B91 + B92 + B93 + B94 + B95) / 7, 0)
D84: (B80 + B79 + B78 + B77) / (B76 + B75 + B74 + B73)
D83: (B79 + B78 + B77 + B76) / (B75 + B74 + B73 + B72)
D13: (B9 + B8 + B7 + B6) / (B5 + B4 + B3 + B2)
D14: (B10 + B9 + B8 + B7) / (B6 + B5 + B4 + B3)
D15: (B11 + B10 + B9 + B8) / (B7 + B6 + B5 + B4)
D16: (B12 + B11 + B10 + B9) / (B8 + B7 + B6 + B5)
D17: (B13 + B12 + B11 + B10) / (B9 + B8 + B7 + B6)
D18: (B14 + B13 + B12 + B11) / (B10 + B9 + B8 + B7)
D19: (B15 + B14 + B13 + B12) / (B11 + B10 + B9 + B8)
J19: (D13 + D14 + D15 + D16 + D17 + D18 + D19) / 7
D20: (B16 + B15 + B14 + B13) / (B12 + B11 + B10 + B9)
J20: (D14 + D15 + D16 + D17 + D18 + D19 + D20) / 7
D21: (B17 + B16 + B15 + B14) / (B13 + B12 + B11 + B10)
J21: (D15 + D16 + D17 + D18 + D19 + D20 + D21) / 7
D22: (B18 + B17 + B16 + B15) / (B14 + B13 + B12 + B11)
J22: (D16 + D17 + D18 + D19 + D20 + D21 + D22) / 7
D23: (B19 + B18 + B17 + B16) / (B15 + B14 + B13 + B12)
J23: (D17 + D18 + D19 + D20 + D21 + D22 + D23) / 7
D24: (B20 + B19 + B18 + B17) / (B16 + B15 + B14 + B13)
J24: (D18 + D19 + D20 + D21 + D22 + D23 + D24) / 7
D25: (B21 + B20 + B19 + B18) / (B17 + B16 + B15 + B14)
J25: (D19 + D20 + D21 + D22 + D23 + D24 + D25) / 7
D26: (B22 + B21 + B20 + B19) / (B18 + B17 + B16 + B15)
J26: (D20 + D21 + D22 + D23 + D24 + D25 + D26) / 7
D27: (B23 + B22 + B21 + B20) / (B19 + B18 + B17 + B16)
J27: (D21 + D22 + D23 + D24 + D25 + D26 + D27) / 7
D28: (B24 + B23 + B22 + B21) / (B20 + B19 + B18 + B17)
J28: (D22 + D23 + D24 + D25 + D26 + D27 + D28) / 7
D29: (B25 + B24 + B23 + B22) / (B21 + B20 + B19 + B18)
J29: (D23 + D24 + D25 + D26 + D27 + D28 + D29) / 7
D30: (B26 + B25 + B24 + B23) / (B22 + B21 + B20 + B19)
J30: (D24 + D25 + D26 + D27 + D28 + D29 + D30) / 7
D31: (B27 + B26 + B25 + B24) / (B23 + B22 + B21 + B20)
J31: (D25 + D26 + D27 + D28 + D29 + D30 + D31) / 7
D32: (B28 + B27 + B26 + B25) / (B24 + B23 + B22 + B21)
J32: (D26 + D27 + D28 + D29 + D30 + D31 + D32) / 7
D33: (B29 + B28 + B27 + B26) / (B25 + B24 + B23 + B22)
J33: (D27 + D28 + D29 + D30 + D31 + D32 + D33) / 7
D34: (B30 + B29 + B28 + B27) / (B26 + B25 + B24 + B23)
J34: (D28 + D29 + D30 + D31 + D32 + D33 + D34) / 7
D35: (B31 + B30 + B29 + B28) / (B27 + B26 + B25 + B24)
J35: (D29 + D30 + D31 + D32 + D33 + D34 + D35) / 7
D36: (B32 + B31 + B30 + B29) / (B28 + B27 + B26 + B25)
J36: (D30 + D31 + D32 + D33 + D34 + D35 + D36) / 7
D37: (B33 + B32 + B31 + B30) / (B29 + B28 + B27 + B26)
J37: (D31 + D32 + D33 + D34 + D35 + D36 + D37) / 7
D38: (B34 + B33 + B32 + B31) / (B30 + B29 + B28 + B27)
J38: (D32 + D33 + D34 + D35 + D36 + D37 + D38) / 7
D39: (B35 + B34 + B33 + B32) / (B31 + B30 + B29 + B28)
J39: (D33 + D34 + D35 + D36 + D37 + D38 + D39) / 7
D40: (B36 + B35 + B34 + B33) / (B32 + B31 + B30 + B29)
J40: (D34 + D35 + D36 + D37 + D38 + D39 + D40) / 7
D41: (B37 + B36 + B35 + B34) / (B33 + B32 + B31 + B30)
J41: (D35 + D36 + D37 + D38 + D39 + D40 + D41) / 7
D42: (B38 + B37 + B36 + B35) / (B34 + B33 + B32 + B31)
J42: (D36 + D37 + D38 + D39 + D40 + D41 + D42) / 7
D43: (B39 + B38 + B37 + B36) / (B35 + B34 + B33 + B32)
J43: (D37 + D38 + D39 + D40 + D41 + D42 + D43) / 7
D44: (B40 + B39 + B38 + B37) / (B36 + B35 + B34 + B33)
J44: (D38 + D39 + D40 + D41 + D42 + D43 + D44) / 7
D45: (B41 + B40 + B39 + B38) / (B37 + B36 + B35 + B34)
J45: (D39 + D40 + D41 + D42 + D43 + D44 + D45) / 7
D46: (B42 + B41 + B40 + B39) / (B38 + B37 + B36 + B35)
J46: (D40 + D41 + D42 + D43 + D44 + D45 + D46) / 7
D47: (B43 + B42 + B41 + B40) / (B39 + B38 + B37 + B36)
J47: (D41 + D42 + D43 + D44 + D45 + D46 + D47) / 7
D48: (B44 + B43 + B42 + B41) / (B40 + B39 + B38 + B37)
J48: (D42 + D43 + D44 + D45 + D46 + D47 + D48) / 7
D49: (B45 + B44 + B43 + B42) / (B41 + B40 + B39 + B38)
J49: (D43 + D44 + D45 + D46 + D47 + D48 + D49) / 7
D50: (B46 + B45 + B44 + B43) / (B42 + B41 + B40 + B39)
J50: (D44 + D45 + D46 + D47 + D48 + D49 + D50) / 7
D51: (B47 + B46 + B45 + B44) / (B43 + B42 + B41 + B40)
J51: (D45 + D46 + D47 + D48 + D49 + D50 + D51) / 7
D52: (B48 + B47 + B46 + B45) / (B44 + B43 + B42 + B41)
J52: (D46 + D47 + D48 + D49 + D50 + D51 + D52) / 7
D53: (B49 + B48 + B47 + B46) / (B45 + B44 + B43 + B42)
J53: (D47 + D48 + D49 + D50 + D51 + D52 + D53) / 7
D54: (B50 + B49 + B48 + B47) / (B46 + B45 + B44 + B43)
J54: (D48 + D49 + D50 + D51 + D52 + D53 + D54) / 7
D55: (B51 + B50 + B49 + B48) / (B47 + B46 + B45 + B44)
J55: (D49 + D50 + D51 + D52 + D53 + D54 + D55) / 7
D56: (B52 + B51 + B50 + B49) / (B48 + B47 + B46 + B45)
J56: (D50 + D51 + D52 + D53 + D54 + D55 + D56) / 7
D57: (B53 + B52 + B51 + B50) / (B49 + B48 + B47 + B46)
J57: (D51 + D52 + D53 + D54 + D55 + D56 + D57) / 7
D58: (B54 + B53 + B52 + B51) / (B50 + B49 + B48 + B47)
J58: (D52 + D53 + D54 + D55 + D56 + D57 + D58) / 7
D59: (B55 + B54 + B53 + B52) / (B51 + B50 + B49 + B48)
J59: (D53 + D54 + D55 + D56 + D57 + D58 + D59) / 7
D60: (B56 + B55 + B54 + B53) / (B52 + B51 + B50 + B49)
J60: (D54 + D55 + D56 + D57 + D58 + D59 + D60) / 7
D61: (B57 + B56 + B55 + B54) / (B53 + B52 + B51 + B50)
J61: (D55 + D56 + D57 + D58 + D59 + D60 + D61) / 7
D62: (B58 + B57 + B56 + B55) / (B54 + B53 + B52 + B51)
J62: (D56 + D57 + D58 + D59 + D60 + D61 + D62) / 7
D63: (B59 + B58 + B57 + B56) / (B55 + B54 + B53 + B52)
J63: (D57 + D58 + D59 + D60 + D61 + D62 + D63) / 7
D64: (B60 + B59 + B58 + B57) / (B56 + B55 + B54 + B53)
J64: (D58 + D59 + D60 + D61 + D62 + D63 + D64) / 7
D65: (B61 + B60 + B59 + B58) / (B57 + B56 + B55 + B54)
J65: (D59 + D60 + D61 + D62 + D63 + D64 + D65) / 7
D66: (B62 + B61 + B60 + B59) / (B58 + B57 + B56 + B55)
J66: (D60 + D61 + D62 + D63 + D64 + D65 + D66) / 7
D67: (B63 + B62 + B61 + B60) / (B59 + B58 + B57 + B56)
J67: (D61 + D62 + D63 + D64 + D65 + D66 + D67) / 7
D68: (B64 + B63 + B62 + B61) / (B60 + B59 + B58 + B57)
J68: (D62 + D63 + D64 + D65 + D66 + D67 + D68) / 7
D69: (B65 + B64 + B63 + B62) / (B61 + B60 + B59 + B58)
J69: (D63 + D64 + D65 + D66 + D67 + D68 + D69) / 7
D70: (B66 + B65 + B64 + B63) / (B62 + B61 + B60 + B59)
J70: (D64 + D65 + D66 + D67 + D68 + D69 + D70) / 7
D71: (B67 + B66 + B65 + B64) / (B63 + B62 + B61 + B60)
J71: (D65 + D66 + D67 + D68 + D69 + D70 + D71) / 7
D72: (B68 + B67 + B66 + B65) / (B64 + B63 + B62 + B61)
J72: (D66 + D67 + D68 + D69 + D70 + D71 + D72) / 7
D73: (B69 + B68 + B67 + B66) / (B65 + B64 + B63 + B62)
J73: (D67 + D68 + D69 + D70 + D71 + D72 + D73) / 7
D74: (B70 + B69 + B68 + B67) / (B66 + B65 + B64 + B63)
J74: (D68 + D69 + D70 + D71 + D72 + D73 + D74) / 7
D75: (B71 + B70 + B69 + B68) / (B67 + B66 + B65 + B64)
J75: (D69 + D70 + D71 + D72 + D73 + D74 + D75) / 7
D76: (B72 + B71 + B70 + B69) / (B68 + B67 + B66 + B65)
J76: (D70 + D71 + D72 + D73 + D74 + D75 + D76) / 7
D77: (B73 + B72 + B71 + B70) / (B69 + B68 + B67 + B66)
J77: (D71 + D72 + D73 + D74 + D75 + D76 + D77) / 7
D78: (B74 + B73 + B72 + B71) / (B70 + B69 + B68 + B67)
J78: (D72 + D73 + D74 + D75 + D76 + D77 + D78) / 7
D79: (B75 + B74 + B73 + B72) / (B71 + B70 + B69 + B68)
J79: (D73 + D74 + D75 + D76 + D77 + D78 + D79) / 7
D80: (B76 + B75 + B74 + B73) / (B72 + B71 + B70 + B69)
J80: (D74 + D75 + D76 + D77 + D78 + D79 + D80) / 7
D81: (B77 + B76 + B75 + B74) / (B73 + B72 + B71 + B70)
J81: (D75 + D76 + D77 + D78 + D79 + D80 + D81) / 7
D82: (B78 + B77 + B76 + B75) / (B74 + B73 + B72 + B71)
J84: (D78 + D79 + D80 + D81 + D82 + D83 + D84) / 7
J83: (D77 + D78 + D79 + D80 + D81 + D82 + D83) / 7
J82: (D76 + D77 + D78 + D79 + D80 + D81 + D82) / 7
D85: (B81 + B80 + B79 + B78) / (B77 + B76 + B75 + B74)
J85: (D79 + D80 + D81 + D82 + D83 + D84 + D85) / 7
D86: (B82 + B81 + B80 + B79) / (B78 + B77 + B76 + B75)
J86: (D80 + D81 + D82 + D83 + D84 + D85 + D86) / 7
D87: (B83 + B82 + B81 + B80) / (B79 + B78 + B77 + B76)
J87: (D81 + D82 + D83 + D84 + D85 + D86 + D87) / 7
D88: (B84 + B83 + B82 + B81) / (B80 + B79 + B78 + B77)
J88: (D82 + D83 + D84 + D85 + D86 + D87 + D88) / 7
D89: (B85 + B84 + B83 + B82) / (B81 + B80 + B79 + B78)
J89: (D83 + D84 + D85 + D86 + D87 + D88 + D89) / 7
D90: (B86 + B85 + B84 + B83) / (B82 + B81 + B80 + B79)
J90: (D84 + D85 + D86 + D87 + D88 + D89 + D90) / 7
D91: (B87 + B86 + B85 + B84) / (B83 + B82 + B81 + B80)
J91: (D85 + D86 + D87 + D88 + D89 + D90 + D91) / 7
D92: (B88 + B87 + B86 + B85) / (B84 + B83 + B82 + B81)
J92: (D86 + D87 + D88 + D89 + D90 + D91 + D92) / 7
D93: (B89 + B88 + B87 + B86) / (B85 + B84 + B83 + B82)
J93: (D87 + D88 + D89 + D90 + D91 + D92 + D93) / 7
D94: (B90 + B89 + B88 + B87) / (B86 + B85 + B84 + B83)
J94: (D88 + D89 + D90 + D91 + D92 + D93 + D94) / 7
D95: (B91 + B90 + B89 + B88) / (B87 + B86 + B85 + B84)
J95: (D89 + D90 + D91 + D92 + D93 + D94 + D95) / 7
D12: (B8 + B7 + B6 + B5) / (B4 + B3 + B2 + B1)
J18: (D12 + D13 + D14 + D15 + D16 + D17 + D18) / 7
E64: (B58 + B59 + B60 + B61 + B62 + B63 + B64) / 830
E63: (B57 + B58 + B59 + B60 + B61 + B62 + B63) / 830
E62: (B56 + B57 + B58 + B59 + B60 + B61 + B62) / 830
E61: (B55 + B56 + B57 + B58 + B59 + B60 + B61) / 830
E60: (B54 + B55 + B56 + B57 + B58 + B59 + B60) / 830
E59: (B53 + B54 + B55 + B56 + B57 + B58 + B59) / 830
E58: (B52 + B53 + B54 + B55 + B56 + B57 + B58) / 830
E57: (B51 + B52 + B53 + B54 + B55 + B56 + B57) / 830
E56: (B50 + B51 + B52 + B53 + B54 + B55 + B56) / 830
E55: (B49 + B50 + B51 + B52 + B53 + B54 + B55) / 830
E54: (B48 + B49 + B50 + B51 + B52 + B53 + B54) / 830
E53: (B47 + B48 + B49 + B50 + B51 + B52 + B53) / 830
E52: (B46 + B47 + B48 + B49 + B50 + B51 + B52) / 830
E51: (B45 + B46 + B47 + B48 + B49 + B50 + B51) / 830
E50: (B44 + B45 + B46 + B47 + B48 + B49 + B50) / 830
E49: (B43 + B44 + B45 + B46 + B47 + B48 + B49) / 830
E48: (B42 + B43 + B44 + B45 + B46 + B47 + B48) / 830
E47: (B41 + B42 + B43 + B44 + B45 + B46 + B47) / 830
E46: (B40 + B41 + B42 + B43 + B44 + B45 + B46) / 830
E45: (B39 + B40 + B41 + B42 + B43 + B44 + B45) / 830
E44: (B38 + B39 + B40 + B41 + B42 + B43 + B44) / 830
E43: (B37 + B38 + B39 + B40 + B41 + B42 + B43) / 830
E42: (B36 + B37 + B38 + B39 + B40 + B41 + B42) / 830
E41: (B35 + B36 + B37 + B38 + B39 + B40 + B41) / 830
E40: (B34 + B35 + B36 + B37 + B38 + B39 + B40) / 830
E39: (B33 + B34 + B35 + B36 + B37 + B38 + B39) / 830
E38: (B32 + B33 + B34 + B35 + B36 + B37 + B38) / 830
E37: (B31 + B32 + B33 + B34 + B35 + B36 + B37) / 830
E36: (B30 + B31 + B32 + B33 + B34 + B35 + B36) / 830
E35: (B29 + B30 + B31 + B32 + B33 + B34 + B35) / 830
E34: (B28 + B29 + B30 + B31 + B32 + B33 + B34) / 830
E33: (B27 + B28 + B29 + B30 + B31 + B32 + B33) / 830
E32: (B26 + B27 + B28 + B29 + B30 + B31 + B32) / 830
E31: (B25 + B26 + B27 + B28 + B29 + B30 + B31) / 830
E30: (B24 + B25 + B26 + B27 + B28 + B29 + B30) / 830
E29: (B23 + B24 + B25 + B26 + B27 + B28 + B29) / 830
E28: (B22 + B23 + B24 + B25 + B26 + B27 + B28) / 830
E27: (B21 + B22 + B23 + B24 + B25 + B26 + B27) / 830
E26: (B20 + B21 + B22 + B23 + B24 + B25 + B26) / 830
E25: (B19 + B20 + B21 + B22 + B23 + B24 + B25) / 830
E24: (B18 + B19 + B20 + B21 + B22 + B23 + B24) / 830
E23: (B17 + B18 + B19 + B20 + B21 + B22 + B23) / 830
E22: (B16 + B17 + B18 + B19 + B20 + B21 + B22) / 830
E21: (B15 + B16 + B17 + B18 + B19 + B20 + B21) / 830
E20: (B14 + B15 + B16 + B17 + B18 + B19 + B20) / 830
E19: (B13 + B14 + B15 + B16 + B17 + B18 + B19) / 830
E18: (B12 + B13 + B14 + B15 + B16 + B17 + B18) / 830
E17: (B11 + B12 + B13 + B14 + B15 + B16 + B17) / 830
E16: (B10 + B11 + B12 + B13 + B14 + B15 + B16) / 830
E15: (B9 + B10 + B11 + B12 + B13 + B14 + B15) / 830
E14: (B8 + B9 + B10 + B11 + B12 + B13 + B14) / 830
E13: (B7 + B8 + B9 + B10 + B11 + B12 + B13) / 830
E12: (B6 + B7 + B8 + B9 + B10 + B11 + B12) / 830
E11: (B5 + B6 + B7 + B8 + B9 + B10 + B11) / 830
E10: (B4 + B5 + B6 + B7 + B8 + B9 + B10) / 830
E9: (B3 + B4 + B5 + B6 + B7 + B8 + B9) / 830
E8: (B2 + B3 + B4 + B5 + B6 + B7 + B8) / 830
E7: (B1 + B2 + B3 + B4 + B5 + B6 + B7) / 830
E65: (B59 + B60 + B61 + B62 + B63 + B64 + B65) / 830
E67: (B61 + B62 + B63 + B64 + B65 + B66 + B67) / 830
E66: (B60 + B61 + B62 + B63 + B64 + B65 + B66) / 830
E69: (B63 + B64 + B65 + B66 + B67 + B68 + B69) / 830
E68: (B62 + B63 + B64 + B65 + B66 + B67 + B68) / 830
E71: (B65 + B66 + B67 + B68 + B69 + B70 + B71) / 830
E70: (B64 + B65 + B66 + B67 + B68 + B69 + B70) / 830
E72: (B66 + B67 + B68 + B69 + B70 + B71 + B72) / 830
E73: (B67 + B68 + B69 + B70 + B71 + B72 + B73) / 830
E74: (B68 + B69 + B70 + B71 + B72 + B73 + B74) / 830
E75: (B69 + B70 + B71 + B72 + B73 + B74 + B75) / 830
E76: (B70 + B71 + B72 + B73 + B74 + B75 + B76) / 830
E77: (B71 + B72 + B73 + B74 + B75 + B76 + B77) / 830
E78: (B72 + B73 + B74 + B75 + B76 + B77 + B78) / 830
E79: (B73 + B74 + B75 + B76 + B77 + B78 + B79) / 830
E81: (B75 + B76 + B77 + B78 + B79 + B80 + B81) / 830
E80: (B74 + B75 + B76 + B77 + B78 + B79 + B80) / 830
E83: (B77 + B78 + B79 + B80 + B81 + B82 + B83) / 830
E82: (B76 + B77 + B78 + B79 + B80 + B81 + B82) / 830
E85: (B79 + B80 + B81 + B82 + B83 + B84 + B85) / 830
E84: (B78 + B79 + B80 + B81 + B82 + B83 + B84) / 830
E87: (B81 + B82 + B83 + B84 + B85 + B86 + B87) / 830
E86: (B80 + B81 + B82 + B83 + B84 + B85 + B86) / 830
E89: (B83 + B84 + B85 + B86 + B87 + B88 + B89) / 830
E88: (B82 + B83 + B84 + B85 + B86 + B87 + B88) / 830
E90: (B84 + B85 + B86 + B87 + B88 + B89 + B90) / 830
E91: (B85 + B86 + B87 + B88 + B89 + B90 + B91) / 830
E92: (B86 + B87 + B88 + B89 + B90 + B91 + B92) / 830
E94: (B88 + B89 + B90 + B91 + B92 + B93 + B94) / 830
E93: (B87 + B88 + B89 + B90 + B91 + B92 + B93) / 830
E95: (B89 + B90 + B91 + B92 + B93 + B94 + B95) / 830
C1444 = NaN
C1: 240
C2: C1 + B2
C3: C2 + B3
C4: C3 + B4
C5: C4 + B5
C6: C5 + B6
C7: C6 + B7
C8: C7 + B8
C9: C8 + B9
C10: C9 + B10
C11: C10 + B11
C12: C11 + B12
C13: C12 + B13
C14: C13 + B14
C15: C14 + B15
C16: C15 + B16
C17: C16 + B17
C18: C17 + B18
C19: C18 + B19
C20: C19 + B20
C21: C20 + B21
C22: C21 + B22
C23: C22 + B23
C24: C23 + B24
C25: C24 + B25
C26: C25 + B26
C27: C26 + B27
C28: C27 + B28
C29: C28 + B29
C30: C29 + B30
C31: C30 + B31
C32: C31 + B32
C33: C32 + B33
C34: C33 + B34
C35: C34 + B35
C36: C35 + B36
C37: C36 + B37
C38: C37 + B38
C39: C38 + B39
C40: C39 + B40
C41: C40 + B41
C42: C41 + B42
C43: C42 + B43
C44: C43 + B44
C45: C44 + B45
C46: C45 + B46
C47: C46 + B47
C48: C47 + B48
C49: C48 + B49
C50: C49 + B50
C51: C50 + B51
C52: C51 + B52
C53: C52 + B53
C54: C53 + B54
C55: C54 + B55
C56: C55 + B56
C57: C56 + B57
C58: C57 + B58
C59: C58 + B59
C60: C59 + B60
C61: C60 + B61
C62: C61 + B62
C63: C62 + B63
C64: C63 + B64
C65: C64 + B65
C66: C65 + B66
C67: C66 + B67
C68: C67 + B68
C69: C68 + B69
C70: C69 + B70
C71: C70 + B71
C72: C71 + B72
C73: C72 + B73
C74: C73 + B74
C75: C74 + B75
C76: C75 + B76
C77: C76 + B77
C78: C77 + B78
C79: C78 + B79
C80: C79 + B80
C81: C80 + B81
C82: C81 + B82
C83: C82 + B83
C84: C83 + B84
C85: C84 + B85
C86: C85 + B86
C87: C86 + B87
C88: C87 + B88
C89: C88 + B89
C90: C89 + B90
C91: C90 + B91
C92: C91 + B92
C93: C92 + B93
C94: C93 + B94
C95: C94 + B95
D9: (B9 + B8 + B7 + B6) / (B5 + B4 + B3 + B2)
D10: (B10 + B9 + B8 + B7) / (B6 + B5 + B4 + B3)
D11: (B11 + B10 + B9 + B8) / (B7 + B6 + B5 + B4)
D8: (B8 + B7 + B6 + B5) / (B4 + B3 + B2 + B1)
J17: (D11 + D12 + D13 + D14 + D15 + D16 + D17) / 7
J16: (D10 + D11 + D12 + D13 + D14 + D15 + D16) / 7
J15: (D9 + D10 + D11 + D12 + D13 + D14 + D15) / 7
J14: (D8 + D9 + D10 + D11 + D12 + D13 + D14) / 7
h: y = 1
rwert: y(Element[LiAD, Tag - 10])
wert: y(Element[LiAB, Tag + 1])
R = 1 (slider from 0 to 5, step 0.01)
q(x) = If[Tag ≤ x ≤ Tag + 8, (wert * (rwert^(0.25))^(x - Tag))]
E1: 830
Text4: "R-Wert   RKI ≈ " + rwert + ""
duwert: y(Element[LiAI, Tag - 5])
Text5: "Durchschnitt pro 100000 ≈ " + duwert + ""
A: (Tag, wert)
grwert: y(Element[LiAJ, Tag - 16])
Text7: "gR-Wert RKI ≈ " + grwert + ""
B: (Tag, 0)
C: (Tag, 6)
k = Segment(B, C)
geszahl = Element(LiCgesamt, Tag + 1)
Text10: "Gesamtzahl: " + geszahl + ""
L7_1: round((B1 + B2 + B3 + B4 + B5 + B6 + B7) / 7, 0)
wowert: y(Element[LiAL, Tag + 1])
Text11: "Wochendurchschnitt = " + wowert + ""
LiMdatum = Sequence(Cell[13, a], a, 1, Tag + 1)
Text8 = Element(LiMdatum, Tag + 1)
O1: 306
LiPtotegesamt = Sequence(Cell[16, a], a, 1, Tag + 1)
totegesamt = Element(LiPtotegesamt, Tag + 1)
Text12: "Tote gesamt: " + totegesamt + ""
f = PolyLine(LiAB)
a = 1 (slider from -5 to 5)
g = PolyLine(LiAD)
j = PolyLine(LiAJ)
L1: 0
L2: 0
L3: 0
L4: 0
L5: 0
L6: 0
l = PolyLine(LiAL)
LiAP = Sequence((Cell[1, a], Cell[16, a]), a, 1, Tag + 1)
m = PolyLine(LiAP)
maxtageswerte = Max(y(LiAB))
p(x) = If[Tag ≤ x ≤ Tag + 30, (wert * (R^(0.25))^(x - Tag))]
B96: 324
L96: round((B90 + B91 + B92 + B93 + B94 + B95 + B96) / 7, 0)
D96: (B92 + B91 + B90 + B89) / (B88 + B87 + B86 + B85)
J96: (D90 + D91 + D92 + D93 + D94 + D95 + D96) / 7
E96: (B90 + B91 + B92 + B93 + B94 + B95 + B96) / 830
C96: C95 + B96
O96: 2
P96: P95 + O96
B97: 646
L97: round((B91 + B92 + B93 + B94 + B95 + B96 + B97) / 7, 0)
D97: (B93 + B92 + B91 + B90) / (B89 + B88 + B87 + B86)
J97: (D91 + D92 + D93 + D94 + D95 + D96 + D97) / 7
E97: (B91 + B92 + B93 + B94 + B95 + B96 + B97) / 830
C97: C96 + B97
O97: 26
P97: P96 + O97
B98: 1548
L98: round((B92 + B93 + B94 + B95 + B96 + B97 + B98) / 7, 0)
D98: (B94 + B93 + B92 + B91) / (B90 + B89 + B88 + B87)
J98: (D92 + D93 + D94 + D95 + D96 + D97 + D98) / 7
E98: (B92 + B93 + B94 + B95 + B96 + B97 + B98) / 830
C98: C97 + B98
O98: 28
P98: P97 + O98
B99: 1642
L99: round((B93 + B94 + B95 + B96 + B97 + B98 + B99) / 7, 0)
D99: (B95 + B94 + B93 + B92) / (B91 + B90 + B89 + B88)
J99: (D93 + D94 + D95 + D96 + D97 + D98 + D99) / 7
E99: (B93 + B94 + B95 + B96 + B97 + B98 + B99) / 830
C99: C98 + B99
O99: 32
P99: P98 + O99
B100: 1456
L100: round((B94 + B95 + B96 + B97 + B98 + B99 + B100) / 7, 0)
D100: (B96 + B95 + B94 + B93) / (B92 + B91 + B90 + B89)
J100: (D94 + D95 + D96 + D97 + D98 + D99 + D100) / 7
E100: (B94 + B95 + B96 + B97 + B98 + B99 + B100) / 830
C100: C99 + B100
O100: 18
P100: P99 + O100
B101: 1608
L101: round((B95 + B96 + B97 + B98 + B99 + B100 + B101) / 7, 0)
D101: (B97 + B96 + B95 + B94) / (B93 + B92 + B91 + B90)
J101: (D95 + D96 + D97 + D98 + D99 + D100 + D101) / 7
E101: (B95 + B96 + B97 + B98 + B99 + B100 + B101) / 830
C101: C100 + B101
O101: 22
P101: P100 + O101