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!

17.07.2021

18.07.2021

19.07.2021

20.07.2021

21.07.2021

22.07.2021

23.07.2021

24.07.2021

25.07.2021

26.07.2021

27.07.2021

28.07.2021

29.07.2021

30.07.2021

31.07.2021

01.08.2021

02.08.2021

03.08.2021

04.08.2021

05.08.2021

06.08.2021

07.08.2021

08.08.2021

09.08.2021

10.08.2021

11.08.2021

12.08.2021

13.08.2021

14.08.2021

15.08.2021

16.08.2021

17.08.2021

18.08.2021

19.08.2021

20.08.2021

21.08.2021

22.08.2021

23.08.2021

24.08.2021

25.08.2021

27.08.2021

28.08.2021

29.08.2021

30.08.2021

31.08.2021

01.09.2021

02.09.2021

03.09.2021

04.09.2021

05.09.2021

06.09.2021

07.09.2021

08.09.2021

09.09.2021

10.09.2021

11.09.2021

12.09.2021

13.09.2021

14.09.2021

15.09.2021

16.09.2021

17.09.2021

18.09.2021

19.09.2021

20.09.2021

21.09.2021

22.09.2021

23.09.2021

24.09.2021

25.09.2021

26.09.2021

27.09.2021

28.09.2021

29.09.2021

30.09.2021

01.10.2021

02.10.2021

03.10.2021

04.10.2021

05.10.2021

06.10.2021

07.10.2021

08.10.2021

09.10.2021

10.10.2021

11.10.2021

12.10.2021

13.10.2021

14.10.2021

15.10.2021

16.10.2021

17.10.2021

18.10.2021

19.10.2021

20.10.2021

21.10.2021

22.10.2021

23.10.2021

24.10.2021

25.10.2021

geglättete R-Werte

Neuinfizierte

26.08.2021

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: 91359
O2: 3
P2: P1 + O2
B1: 1608
B2: 1292
C1444 = NaN
C1: 3744184
C2: C1 + B2
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: 9.60120481927712
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 + ""
wowert: y(Element[LiAL, Tag + 1])
Text11: "Wochendurchschnitt = " + wowert + ""
LiMdatum = Sequence(Cell[13, a], a, 1, Tag + 1)
Text8 = Element(LiMdatum, Tag + 1)
O1: 22
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: 1138
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))]
D1: 0.797547846889953
J1: 1.27135792565606
B3: 546
C3: C2 + B3
O3: 1
P3: P2 + O3
B4: 1183
C4: C3 + B4
O4: 34
P4: P3 + O4
B5: 2203
C5: C4 + B5
O5: 19
P5: P4 + O5
B6: 1890
C6: C5 + B6
O6: 42
P6: P5 + O6
B7: 2089
C7: C6 + B7
O7: 34
P7: P6 + O7
B8: 1919
C8: C7 + B8
O8: 28
P8: P7 + O8
B9: 1387
C9: C8 + B9
O9: 4
P9: P8 + O9
B10: 958
C10: C9 + B10
O10: 3
P10: P9 + O10
B11: 1545
C11: C10 + B11
O11: 38
P11: P10 + O11
E9: (B3 + B4 + B5 + B6 + B7 + B8 + B9) / 830
D9: (B9 + B8 + B7 + B6) / (B5 + B4 + B3 + B2)
E8: (B2 + B3 + B4 + B5 + B6 + B7 + B8) / 830
E10: (B4 + B5 + B6 + B7 + B8 + B9 + B10) / 830
D10: (B10 + B9 + B8 + B7) / (B6 + B5 + B4 + B3)
E11: (B5 + B6 + B7 + B8 + B9 + B10 + B11) / 830
D11: (B11 + B10 + B9 + B8) / (B7 + B6 + B5 + B4)
L7: round((B1 + B2 + B3 + B4 + B5 + B6 + B7) / 7, 0)
L8: round((B2 + B3 + B4 + B5 + B6 + B7 + B8) / 7, 0)
L9: round((B3 + B4 + B5 + B6 + B7 + B8 + B9) / 7, 0)
L10: round((B4 + B5 + B6 + B7 + B8 + B9 + B10) / 7, 0)
L11: round((B5 + B6 + B7 + B8 + B9 + B10 + B11) / 7, 0)
B12: 2768
C12: C11 + B12
E12: (B6 + B7 + B8 + B9 + B10 + B11 + B12) / 830
D12: (B12 + B11 + B10 + B9) / (B8 + B7 + B6 + B5)
L12: round((B6 + B7 + B8 + B9 + B10 + B11 + B12) / 7, 0)
O12: 21
P12: P11 + O12
B13: 3142
C13: C12 + B13
E13: (B7 + B8 + B9 + B10 + B11 + B12 + B13) / 830
D13: (B13 + B12 + B11 + B10) / (B9 + B8 + B7 + B6)
L13: round((B7 + B8 + B9 + B10 + B11 + B12 + B13) / 7, 0)
O13: 21
P13: P12 + O13
B14: 2454
C14: C13 + B14
E14: (B8 + B9 + B10 + B11 + B12 + B13 + B14) / 830
D14: (B14 + B13 + B12 + B11) / (B10 + B9 + B8 + B7)
L14: round((B8 + B9 + B10 + B11 + B12 + B13 + B14) / 7, 0)
O14: 30
P14: P13 + O14
B15: 2400
C15: C14 + B15
E15: (B9 + B10 + B11 + B12 + B13 + B14 + B15) / 830
D15: (B15 + B14 + B13 + B12) / (B11 + B10 + B9 + B8)
L15: round((B9 + B10 + B11 + B12 + B13 + B14 + B15) / 7, 0)
O15: 21
P15: P14 + O15
E7: (B1 + B2 + B3 + B4 + B5 + B6 + B7) / 830
D8: (B8 + B7 + B6 + B5) / (B4 + B3 + B2 + B1)
J14: (D8 + D9 + D10 + D11 + D12 + D13 + D14) / 7
J15: (D9 + D10 + D11 + D12 + D13 + D14 + D15) / 7
B16: 2097
C16: C15 + B16
E16: (B10 + B11 + B12 + B13 + B14 + B15 + B16) / 830
D16: (B16 + B15 + B14 + B13) / (B12 + B11 + B10 + B9)
L16: round((B10 + B11 + B12 + B13 + B14 + B15 + B16) / 7, 0)
J16: (D10 + D11 + D12 + D13 + D14 + D15 + D16) / 7
O16: 1
P16: P15 + O16
B17: 847
C17: C16 + B17
E17: (B11 + B12 + B13 + B14 + B15 + B16 + B17) / 830
D17: (B17 + B16 + B15 + B14) / (B13 + B12 + B11 + B10)
L17: round((B11 + B12 + B13 + B14 + B15 + B16 + B17) / 7, 0)
J17: (D11 + D12 + D13 + D14 + D15 + D16 + D17) / 7
O17: 1
P17: P16 + O17
B18: 1766
C18: C17 + B18
E18: (B12 + B13 + B14 + B15 + B16 + B17 + B18) / 830
D18: (B18 + B17 + B16 + B15) / (B14 + B13 + B12 + B11)
L18: round((B12 + B13 + B14 + B15 + B16 + B17 + B18) / 7, 0)
J18: (D12 + D13 + D14 + D15 + D16 + D17 + D18) / 7
O18: 19
P18: P17 + O18
B19: 3571
C19: C18 + B19
E19: (B13 + B14 + B15 + B16 + B17 + B18 + B19) / 830
D19: (B19 + B18 + B17 + B16) / (B15 + B14 + B13 + B12)
L19: round((B13 + B14 + B15 + B16 + B17 + B18 + B19) / 7, 0)
J19: (D13 + D14 + D15 + D16 + D17 + D18 + D19) / 7
O19: 25
P19: P18 + O19
B20: 3539
C20: C19 + B20
E20: (B14 + B15 + B16 + B17 + B18 + B19 + B20) / 830
D20: (B20 + B19 + B18 + B17) / (B16 + B15 + B14 + B13)
L20: round((B14 + B15 + B16 + B17 + B18 + B19 + B20) / 7, 0)
J20: (D14 + D15 + D16 + D17 + D18 + D19 + D20) / 7
O20: 26
P20: P19 + O20
B21: 3448
C21: C20 + B21
E21: (B15 + B16 + B17 + B18 + B19 + B20 + B21) / 830
D21: (B21 + B20 + B19 + B18) / (B17 + B16 + B15 + B14)
L21: round((B15 + B16 + B17 + B18 + B19 + B20 + B21) / 7, 0)
J21: (D15 + D16 + D17 + D18 + D19 + D20 + D21) / 7
O21: 24
P21: P20 + O21
B22: 3206
C22: C21 + B22
E22: (B16 + B17 + B18 + B19 + B20 + B21 + B22) / 830
D22: (B22 + B21 + B20 + B19) / (B18 + B17 + B16 + B15)
L22: round((B16 + B17 + B18 + B19 + B20 + B21 + B22) / 7, 0)
J22: (D16 + D17 + D18 + D19 + D20 + D21 + D22) / 7
O22: 24
P22: P21 + O22
B23: 3127
C23: C22 + B23
E23: (B17 + B18 + B19 + B20 + B21 + B22 + B23) / 830
D23: (B23 + B22 + B21 + B20) / (B19 + B18 + B17 + B16)
L23: round((B17 + B18 + B19 + B20 + B21 + B22 + B23) / 7, 0)
J23: (D17 + D18 + D19 + D20 + D21 + D22 + D23) / 7
O23: 4
P23: P22 + O23
B24: 1183
C24: C23 + B24
E24: (B18 + B19 + B20 + B21 + B22 + B23 + B24) / 830
D24: (B24 + B23 + B22 + B21) / (B20 + B19 + B18 + B17)
L24: round((B18 + B19 + B20 + B21 + B22 + B23 + B24) / 7, 0)
J24: (D18 + D19 + D20 + D21 + D22 + D23 + D24) / 7
O24: 2
P24: P23 + O24
B25: 2480
C25: C24 + B25
E25: (B19 + B20 + B21 + B22 + B23 + B24 + B25) / 830
D25: (B25 + B24 + B23 + B22) / (B21 + B20 + B19 + B18)
L25: round((B19 + B20 + B21 + B22 + B23 + B24 + B25) / 7, 0)
J25: (D19 + D20 + D21 + D22 + D23 + D24 + D25) / 7
O25: 19
P25: P24 + O25
B26: 4996
C26: C25 + B26
E26: (B20 + B21 + B22 + B23 + B24 + B25 + B26) / 830
D26: (B26 + B25 + B24 + B23) / (B22 + B21 + B20 + B19)
L26: round((B20 + B21 + B22 + B23 + B24 + B25 + B26) / 7, 0)
J26: (D20 + D21 + D22 + D23 + D24 + D25 + D26) / 7
O26: 14
P26: P25 + O26
B27: 5638
C27: C26 + B27
E27: (B21 + B22 + B23 + B24 + B25 + B26 + B27) / 830
D27: (B27 + B26 + B25 + B24) / (B23 + B22 + B21 + B20)
L27: round((B21 + B22 + B23 + B24 + B25 + B26 + B27) / 7, 0)
J27: (D21 + D22 + D23 + D24 + D25 + D26 + D27) / 7
O27: 17
P27: P26 + O27
B28: 5578
C28: C27 + B28
E28: (B22 + B23 + B24 + B25 + B26 + B27 + B28) / 830
D28: (B28 + B27 + B26 + B25) / (B24 + B23 + B22 + B21)
L28: round((B22 + B23 + B24 + B25 + B26 + B27 + B28) / 7, 0)
J28: (D22 + D23 + D24 + D25 + D26 + D27 + D28) / 7
O28: 19
P28: P27 + O28
B29: 5644
C29: C28 + B29
E29: (B23 + B24 + B25 + B26 + B27 + B28 + B29) / 830
D29: (B29 + B28 + B27 + B26) / (B25 + B24 + B23 + B22)
L29: round((B23 + B24 + B25 + B26 + B27 + B28 + B29) / 7, 0)
J29: (D23 + D24 + D25 + D26 + D27 + D28 + D29) / 7
O29: 11
P29: P28 + O29
B30: 4728
C30: C29 + B30
E30: (B24 + B25 + B26 + B27 + B28 + B29 + B30) / 830
D30: (B30 + B29 + B28 + B27) / (B26 + B25 + B24 + B23)
L30: round((B24 + B25 + B26 + B27 + B28 + B29 + B30) / 7, 0)
J30: (D24 + D25 + D26 + D27 + D28 + D29 + D30) / 7
O30: 3
P30: P29 + O30
B31: 2126
C31: C30 + B31
E31: (B25 + B26 + B27 + B28 + B29 + B30 + B31) / 830
D31: (B31 + B30 + B29 + B28) / (B27 + B26 + B25 + B24)
L31: round((B25 + B26 + B27 + B28 + B29 + B30 + B31) / 7, 0)
J31: (D25 + D26 + D27 + D28 + D29 + D30 + D31) / 7
O31: 4
P31: P30 + O31
B32: 3912
C32: C31 + B32
E32: (B26 + B27 + B28 + B29 + B30 + B31 + B32) / 830
D32: (B32 + B31 + B30 + B29) / (B28 + B27 + B26 + B25)
L32: round((B26 + B27 + B28 + B29 + B30 + B31 + B32) / 7, 0)
J32: (D26 + D27 + D28 + D29 + D30 + D31 + D32) / 7
O32: 28
P32: P31 + O32
B33: 8324
C33: C32 + B33
E33: (B27 + B28 + B29 + B30 + B31 + B32 + B33) / 830
D33: (B33 + B32 + B31 + B30) / (B29 + B28 + B27 + B26)
L33: round((B27 + B28 + B29 + B30 + B31 + B32 + B33) / 7, 0)
J33: (D27 + D28 + D29 + D30 + D31 + D32 + D33) / 7
O33: 22
P33: P32 + O33
B34: 8400
C34: C33 + B34
E34: (B28 + B29 + B30 + B31 + B32 + B33 + B34) / 830
D34: (B34 + B33 + B32 + B31) / (B30 + B29 + B28 + B27)
L34: round((B28 + B29 + B30 + B31 + B32 + B33 + B34) / 7, 0)
J34: (D28 + D29 + D30 + D31 + D32 + D33 + D34) / 7
O34: 22
P34: P33 + O34
B35: 9280
C35: C34 + B35
E35: (B29 + B30 + B31 + B32 + B33 + B34 + B35) / 830
D35: (B35 + B34 + B33 + B32) / (B31 + B30 + B29 + B28)
L35: round((B29 + B30 + B31 + B32 + B33 + B34 + B35) / 7, 0)
J35: (D29 + D30 + D31 + D32 + D33 + D34 + D35) / 7
O35: 13
P35: P34 + O35
B36: 8092
C36: C35 + B36
E36: (B30 + B31 + B32 + B33 + B34 + B35 + B36) / 830
D36: (B36 + B35 + B34 + B33) / (B32 + B31 + B30 + B29)
L36: round((B30 + B31 + B32 + B33 + B34 + B35 + B36) / 7, 0)
J36: (D30 + D31 + D32 + D33 + D34 + D35 + D36) / 7
O36: 17
P36: P35 + O36
B37: 7050
C37: C36 + B37
E37: (B31 + B32 + B33 + B34 + B35 + B36 + B37) / 830
D37: (B37 + B36 + B35 + B34) / (B33 + B32 + B31 + B30)
L37: round((B31 + B32 + B33 + B34 + B35 + B36 + B37) / 7, 0)
J37: (D31 + D32 + D33 + D34 + D35 + D36 + D37) / 7
O37: 3
P37: P36 + O37
B38: 3668
C38: C37 + B38
E38: (B32 + B33 + B34 + B35 + B36 + B37 + B38) / 830
D38: (B38 + B37 + B36 + B35) / (B34 + B33 + B32 + B31)
L38: round((B32 + B33 + B34 + B35 + B36 + B37 + B38) / 7, 0)
J38: (D32 + D33 + D34 + D35 + D36 + D37 + D38) / 7
O38: 4
P38: P37 + O38
B39: 5747
C39: C38 + B39
E39: (B33 + B34 + B35 + B36 + B37 + B38 + B39) / 830
D39: (B39 + B38 + B37 + B36) / (B35 + B34 + B33 + B32)
L39: round((B33 + B34 + B35 + B36 + B37 + B38 + B39) / 7, 0)
J39: (D33 + D34 + D35 + D36 + D37 + D38 + D39) / 7
O39: 42
P39: P38 + O39
B40: 11561
C40: C39 + B40
E40: (B34 + B35 + B36 + B37 + B38 + B39 + B40) / 830
D40: (B40 + B39 + B38 + B37) / (B36 + B35 + B34 + B33)
L40: round((B34 + B35 + B36 + B37 + B38 + B39 + B40) / 7, 0)
J40: (D34 + D35 + D36 + D37 + D38 + D39 + D40) / 7
O40: 39
P40: P39 + O40
B41: 12626
C41: C40 + B41
E41: (B35 + B36 + B37 + B38 + B39 + B40 + B41) / 830
D41: (B41 + B40 + B39 + B38) / (B37 + B36 + B35 + B34)
L41: round((B35 + B36 + B37 + B38 + B39 + B40 + B41) / 7, 0)
J41: (D35 + D36 + D37 + D38 + D39 + D40 + D41) / 7
O41: 21
P41: P40 + O41
B42: 12029
C42: C41 + B42
E42: (B36 + B37 + B38 + B39 + B40 + B41 + B42) / 830
D42: (B42 + B41 + B40 + B39) / (B38 + B37 + B36 + B35)
L42: round((B36 + B37 + B38 + B39 + B40 + B41 + B42) / 7, 0)
J42: (D36 + D37 + D38 + D39 + D40 + D41 + D42) / 7
O42: 14
P42: P41 + O42
B43: 10303
C43: C42 + B43
E43: (B37 + B38 + B39 + B40 + B41 + B42 + B43) / 830
D43: (B43 + B42 + B41 + B40) / (B39 + B38 + B37 + B36)
L43: round((B37 + B38 + B39 + B40 + B41 + B42 + B43) / 7, 0)
J43: (D37 + D38 + D39 + D40 + D41 + D42 + D43) / 7
O43: 22
P43: P42 + O43
B44: 8416
C44: C43 + B44
E44: (B38 + B39 + B40 + B41 + B42 + B43 + B44) / 830
D44: (B44 + B43 + B42 + B41) / (B40 + B39 + B38 + B37)
L44: round((B38 + B39 + B40 + B41 + B42 + B43 + B44) / 7, 0)
J44: (D38 + D39 + D40 + D41 + D42 + D43 + D44) / 7
O44: 12
P44: P43 + O44
B45: 4559
C45: C44 + B45
E45: (B39 + B40 + B41 + B42 + B43 + B44 + B45) / 830
D45: (B45 + B44 + B43 + B42) / (B41 + B40 + B39 + B38)
L45: round((B39 + B40 + B41 + B42 + B43 + B44 + B45) / 7, 0)
J45: (D39 + D40 + D41 + D42 + D43 + D44 + D45) / 7
O45: 10
P45: P44 + O45
B46: 5750
C46: C45 + B46
E46: (B40 + B41 + B42 + B43 + B44 + B45 + B46) / 830
D46: (B46 + B45 + B44 + B43) / (B42 + B41 + B40 + B39)
L46: round((B40 + B41 + B42 + B43 + B44 + B45 + B46) / 7, 0)
J46: (D40 + D41 + D42 + D43 + D44 + D45 + D46) / 7
O46: 60
P46: P45 + O46
B47: 13531
C47: C46 + B47
E47: (B41 + B42 + B43 + B44 + B45 + B46 + B47) / 830
D47: (B47 + B46 + B45 + B44) / (B43 + B42 + B41 + B40)
L47: round((B41 + B42 + B43 + B44 + B45 + B46 + B47) / 7, 0)
J47: (D41 + D42 + D43 + D44 + D45 + D46 + D47) / 7
O47: 23
P47: P46 + O47
B48: 13715
C48: C47 + B48
E48: (B42 + B43 + B44 + B45 + B46 + B47 + B48) / 830
D48: (B48 + B47 + B46 + B45) / (B44 + B43 + B42 + B41)
L48: round((B42 + B43 + B44 + B45 + B46 + B47 + B48) / 7, 0)
J48: (D42 + D43 + D44 + D45 + D46 + D47 + D48) / 7
O48: 33
P48: P47 + O48
B49: 14251
C49: C48 + B49
E49: (B43 + B44 + B45 + B46 + B47 + B48 + B49) / 830
D49: (B49 + B48 + B47 + B46) / (B45 + B44 + B43 + B42)
L49: round((B43 + B44 + B45 + B46 + B47 + B48 + B49) / 7, 0)
J49: (D43 + D44 + D45 + D46 + D47 + D48 + D49) / 7
O49: 45
P49: P48 + O49
B50: 10835
C50: C49 + B50
E50: (B44 + B45 + B46 + B47 + B48 + B49 + B50) / 830
D50: (B50 + B49 + B48 + B47) / (B46 + B45 + B44 + B43)
L50: round((B44 + B45 + B46 + B47 + B48 + B49 + B50) / 7, 0)
J50: (D44 + D45 + D46 + D47 + D48 + D49 + D50) / 7
O50: 24
P50: P49 + O50
B51: 10453
C51: C50 + B51
E51: (B45 + B46 + B47 + B48 + B49 + B50 + B51) / 830
D51: (B51 + B50 + B49 + B48) / (B47 + B46 + B45 + B44)
L51: round((B45 + B46 + B47 + B48 + B49 + B50 + B51) / 7, 0)
J51: (D45 + D46 + D47 + D48 + D49 + D50 + D51) / 7
O51: 21
P51: P50 + O51
B52: 4749
C52: C51 + B52
E52: (B46 + B47 + B48 + B49 + B50 + B51 + B52) / 830
D52: (B52 + B51 + B50 + B49) / (B48 + B47 + B46 + B45)
L52: round((B46 + B47 + B48 + B49 + B50 + B51 + B52) / 7, 0)
J52: (D46 + D47 + D48 + D49 + D50 + D51 + D52) / 7
O52: 8
P52: P51 + O52
B53: 6729
C53: C52 + B53
E53: (B47 + B48 + B49 + B50 + B51 + B52 + B53) / 830
D53: (B53 + B52 + B51 + B50) / (B49 + B48 + B47 + B46)
L53: round((B47 + B48 + B49 + B50 + B51 + B52 + B53) / 7, 0)
J53: (D47 + D48 + D49 + D50 + D51 + D52 + D53) / 7
O53: 59
P53: P52 + O53
B54: 13565
C54: C53 + B54
E54: (B48 + B49 + B50 + B51 + B52 + B53 + B54) / 830
D54: (B54 + B53 + B52 + B51) / (B50 + B49 + B48 + B47)
L54: round((B48 + B49 + B50 + B51 + B52 + B53 + B54) / 7, 0)
J54: (D48 + D49 + D50 + D51 + D52 + D53 + D54) / 7
O54: 35
P54: P53 + O54
B55: 15431
C55: C54 + B55
E55: (B49 + B50 + B51 + B52 + B53 + B54 + B55) / 830
D55: (B55 + B54 + B53 + B52) / (B51 + B50 + B49 + B48)
L55: round((B49 + B50 + B51 + B52 + B53 + B54 + B55) / 7, 0)
J55: (D49 + D50 + D51 + D52 + D53 + D54 + D55) / 7
O55: 50
P55: P54 + O55
B56: 12969
C56: C55 + B56
E56: (B50 + B51 + B52 + B53 + B54 + B55 + B56) / 830
D56: (B56 + B55 + B54 + B53) / (B52 + B51 + B50 + B49)
L56: round((B50 + B51 + B52 + B53 + B54 + B55 + B56) / 7, 0)
J56: (D50 + D51 + D52 + D53 + D54 + D55 + D56) / 7
O56: 55
P56: P55 + O56
B57: 11214
C57: C56 + B57
E57: (B51 + B52 + B53 + B54 + B55 + B56 + B57) / 830
D57: (B57 + B56 + B55 + B54) / (B53 + B52 + B51 + B50)
L57: round((B51 + B52 + B53 + B54 + B55 + B56 + B57) / 7, 0)
J57: (D51 + D52 + D53 + D54 + D55 + D56 + D57) / 7
O57: 45
P57: P56 + O57
B58: 7345
C58: C57 + B58
E58: (B52 + B53 + B54 + B55 + B56 + B57 + B58) / 830
D58: (B58 + B57 + B56 + B55) / (B54 + B53 + B52 + B51)
L58: round((B52 + B53 + B54 + B55 + B56 + B57 + B58) / 7, 0)
J58: (D52 + D53 + D54 + D55 + D56 + D57 + D58) / 7
O58: 8
P58: P57 + O58
B59: 5511
C59: C58 + B59
E59: (B53 + B54 + B55 + B56 + B57 + B58 + B59) / 830
D59: (B59 + B58 + B57 + B56) / (B55 + B54 + B53 + B52)
L59: round((B53 + B54 + B55 + B56 + B57 + B58 + B59) / 7, 0)
J59: (D53 + D54 + D55 + D56 + D57 + D58 + D59) / 7
O59: 12
P59: P58 + O59
B60: 6325
C60: C59 + B60
E60: (B54 + B55 + B56 + B57 + B58 + B59 + B60) / 830
D60: (B60 + B59 + B58 + B57) / (B56 + B55 + B54 + B53)
L60: round((B54 + B55 + B56 + B57 + B58 + B59 + B60) / 7, 0)
J60: (D54 + D55 + D56 + D57 + D58 + D59 + D60) / 7
O60: 68
P60: P59 + O60
B61: 12455
C61: C60 + B61
E61: (B55 + B56 + B57 + B58 + B59 + B60 + B61) / 830
D61: (B61 + B60 + B59 + B58) / (B57 + B56 + B55 + B54)
L61: round((B55 + B56 + B57 + B58 + B59 + B60 + B61) / 7, 0)
J61: (D55 + D56 + D57 + D58 + D59 + D60 + D61) / 7
O61: 83
P61: P60 + O61
B62: 12925
C62: C61 + B62
E62: (B56 + B57 + B58 + B59 + B60 + B61 + B62) / 830
D62: (B62 + B61 + B60 + B59) / (B58 + B57 + B56 + B55)
L62: round((B56 + B57 + B58 + B59 + B60 + B61 + B62) / 7, 0)
J62: (D56 + D57 + D58 + D59 + D60 + D61 + D62) / 7
O62: 68
P62: P61 + O62
B63: 11022
C63: C62 + B63
E63: (B57 + B58 + B59 + B60 + B61 + B62 + B63) / 830
D63: (B63 + B62 + B61 + B60) / (B59 + B58 + B57 + B56)
L63: round((B57 + B58 + B59 + B60 + B61 + B62 + B63) / 7, 0)
J63: (D57 + D58 + D59 + D60 + D61 + D62 + D63) / 7
O63: 20
P63: P62 + O63
B64: 8901
C64: C63 + B64
E64: (B58 + B59 + B60 + B61 + B62 + B63 + B64) / 830
D64: (B64 + B63 + B62 + B61) / (B60 + B59 + B58 + B57)
L64: round((B58 + B59 + B60 + B61 + B62 + B63 + B64) / 7, 0)
J64: (D58 + D59 + D60 + D61 + D62 + D63 + D64) / 7
O64: 63
P64: P63 + O64
B65: 7337
C65: C64 + B65
E65: (B59 + B60 + B61 + B62 + B63 + B64 + B65) / 830
D65: (B65 + B64 + B63 + B62) / (B61 + B60 + B59 + B58)
L65: round((B59 + B60 + B61 + B62 + B63 + B64 + B65) / 7, 0)
J65: (D59 + D60 + D61 + D62 + D63 + D64 + D65) / 7
O65: 38
P65: P64 + O65
B66: 3736
C66: C65 + B66
E66: (B60 + B61 + B62 + B63 + B64 + B65 + B66) / 830
D66: (B66 + B65 + B64 + B63) / (B62 + B61 + B60 + B59)
L66: round((B60 + B61 + B62 + B63 + B64 + B65 + B66) / 7, 0)
J66: (D60 + D61 + D62 + D63 + D64 + D65 + D66) / 7
O66: 13
P66: P65 + O66
B67: 4664
C67: C66 + B67
E67: (B61 + B62 + B63 + B64 + B65 + B66 + B67) / 830
D67: (B67 + B66 + B65 + B64) / (B63 + B62 + B61 + B60)
L67: round((B61 + B62 + B63 + B64 + B65 + B66 + B67) / 7, 0)
J67: (D61 + D62 + D63 + D64 + D65 + D66 + D67) / 7
O67: 81
P67: P66 + O67
B68: 10454
C68: C67 + B68
E68: (B62 + B63 + B64 + B65 + B66 + B67 + B68) / 830
D68: (B68 + B67 + B66 + B65) / (B64 + B63 + B62 + B61)
L68: round((B62 + B63 + B64 + B65 + B66 + B67 + B68) / 7, 0)
J68: (D62 + D63 + D64 + D65 + D66 + D67 + D68) / 7
O68: 71
P68: P67 + O68
B69: 10696
C69: C68 + B69
E69: (B63 + B64 + B65 + B66 + B67 + B68 + B69) / 830
D69: (B69 + B68 + B67 + B66) / (B65 + B64 + B63 + B62)
L69: round((B63 + B64 + B65 + B66 + B67 + B68 + B69) / 7, 0)
J69: (D63 + D64 + D65 + D66 + D67 + D68 + D69) / 7
O69: 115
P69: P68 + O69
B70: 9727
C70: C69 + B70
E70: (B64 + B65 + B66 + B67 + B68 + B69 + B70) / 830
D70: (B70 + B69 + B68 + B67) / (B66 + B65 + B64 + B63)
L70: round((B64 + B65 + B66 + B67 + B68 + B69 + B70) / 7, 0)
J70: (D64 + D65 + D66 + D67 + D68 + D69 + D70) / 7
O70: 65
P70: P69 + O70
B71: 7211
C71: C70 + B71
E71: (B65 + B66 + B67 + B68 + B69 + B70 + B71) / 830
D71: (B71 + B70 + B69 + B68) / (B67 + B66 + B65 + B64)
L71: round((B65 + B66 + B67 + B68 + B69 + B70 + B71) / 7, 0)
J71: (D65 + D66 + D67 + D68 + D69 + D70 + D71) / 7
O71: 62
P71: P70 + O71
B72: 7774
C72: C71 + B72
E72: (B66 + B67 + B68 + B69 + B70 + B71 + B72) / 830
D72: (B72 + B71 + B70 + B69) / (B68 + B67 + B66 + B65)
L72: round((B66 + B67 + B68 + B69 + B70 + B71 + B72) / 7, 0)
J72: (D66 + D67 + D68 + D69 + D70 + D71 + D72) / 7
O72: 28
P72: P71 + O72
B73: 3022
C73: C72 + B73
E73: (B67 + B68 + B69 + B70 + B71 + B72 + B73) / 830
D73: (B73 + B72 + B71 + B70) / (B69 + B68 + B67 + B66)
L73: round((B67 + B68 + B69 + B70 + B71 + B72 + B73) / 7, 0)
J73: (D67 + D68 + D69 + D70 + D71 + D72 + D73) / 7
O73: 10
P73: P72 + O73
B74: 4171
C74: C73 + B74
E74: (B68 + B69 + B70 + B71 + B72 + B73 + B74) / 830
D74: (B74 + B73 + B72 + B71) / (B70 + B69 + B68 + B67)
L74: round((B68 + B69 + B70 + B71 + B72 + B73 + B74) / 7, 0)
J74: (D68 + D69 + D70 + D71 + D72 + D73 + D74) / 7
O74: 101
P74: P73 + O74
B75: 11780
C75: C74 + B75
E75: (B69 + B70 + B71 + B72 + B73 + B74 + B75) / 830
D75: (B75 + B74 + B73 + B72) / (B71 + B70 + B69 + B68)
L75: round((B69 + B70 + B71 + B72 + B73 + B74 + B75) / 7, 0)
J75: (D69 + D70 + D71 + D72 + D73 + D74 + D75) / 7
O75: 67
P75: P74 + O75
B76: 12150
C76: C75 + B76
E76: (B70 + B71 + B72 + B73 + B74 + B75 + B76) / 830
D76: (B76 + B75 + B74 + B73) / (B72 + B71 + B70 + B69)
L76: round((B70 + B71 + B72 + B73 + B74 + B75 + B76) / 7, 0)
J76: (D70 + D71 + D72 + D73 + D74 + D75 + D76) / 7
O76: 67
P76: P75 + O76
B77: 10118
C77: C76 + B77
E77: (B71 + B72 + B73 + B74 + B75 + B76 + B77) / 830
D77: (B77 + B76 + B75 + B74) / (B73 + B72 + B71 + B70)
L77: round((B71 + B72 + B73 + B74 + B75 + B76 + B77) / 7, 0)
J77: (D71 + D72 + D73 + D74 + D75 + D76 + D77) / 7
O77: 73
P77: P76 + O77
B78: 8517
C78: C77 + B78
E78: (B72 + B73 + B74 + B75 + B76 + B77 + B78) / 830
D78: (B78 + B77 + B76 + B75) / (B74 + B73 + B72 + B71)
L78: round((B72 + B73 + B74 + B75 + B76 + B77 + B78) / 7, 0)
J78: (D72 + D73 + D74 + D75 + D76 + D77 + D78) / 7
O78: 66
P78: P77 + O78
B79: 6164
C79: C78 + B79
E79: (B73 + B74 + B75 + B76 + B77 + B78 + B79) / 830
D79: (B79 + B78 + B77 + B76) / (B75 + B74 + B73 + B72)
L79: round((B73 + B74 + B75 + B76 + B77 + B78 + B79) / 7, 0)
J79: (D73 + D74 + D75 + D76 + D77 + D78 + D79) / 7
O79: 9
P79: P78 + O79
B80: 3088
C80: C79 + B80
E80: (B74 + B75 + B76 + B77 + B78 + B79 + B80) / 830
D80: (B80 + B79 + B78 + B77) / (B76 + B75 + B74 + B73)
L80: round((B74 + B75 + B76 + B77 + B78 + B79 + B80) / 7, 0)
J80: (D74 + D75 + D76 + D77 + D78 + D79 + D80) / 7
O80: 7
P80: P79 + O80
B81: 4799
C81: C80 + B81
E81: (B75 + B76 + B77 + B78 + B79 + B80 + B81) / 830
D81: (B81 + B80 + B79 + B78) / (B77 + B76 + B75 + B74)
L81: round((B75 + B76 + B77 + B78 + B79 + B80 + B81) / 7, 0)
J81: (D75 + D76 + D77 + D78 + D79 + D80 + D81) / 7
O81: 90
P81: P80 + O81
B82: 11547
C82: C81 + B82
E82: (B76 + B77 + B78 + B79 + B80 + B81 + B82) / 830
D82: (B82 + B81 + B80 + B79) / (B78 + B77 + B76 + B75)
L82: round((B76 + B77 + B78 + B79 + B80 + B81 + B82) / 7, 0)
J82: (D76 + D77 + D78 + D79 + D80 + D81 + D82) / 7
O82: 76
P82: P81 + O82
B83: 11644
C83: C82 + B83
E83: (B77 + B78 + B79 + B80 + B81 + B82 + B83) / 830
D83: (B83 + B82 + B81 + B80) / (B79 + B78 + B77 + B76)
L83: round((B77 + B78 + B79 + B80 + B81 + B82 + B83) / 7, 0)
J83: (D77 + D78 + D79 + D80 + D81 + D82 + D83) / 7
O83: 68
P83: P82 + O83
B84: 10429
C84: C83 + B84
E84: (B78 + B79 + B80 + B81 + B82 + B83 + B84) / 830
D84: (B84 + B83 + B82 + B81) / (B80 + B79 + B78 + B77)
L84: round((B78 + B79 + B80 + B81 + B82 + B83 + B84) / 7, 0)
J84: (D78 + D79 + D80 + D81 + D82 + D83 + D84) / 7
O84: 86
P84: P83 + O84
B85: 8854
C85: C84 + B85
E85: (B79 + B80 + B81 + B82 + B83 + B84 + B85) / 830
D85: (B85 + B84 + B83 + B82) / (B81 + B80 + B79 + B78)
L85: round((B79 + B80 + B81 + B82 + B83 + B84 + B85) / 7, 0)
J85: (D79 + D80 + D81 + D82 + D83 + D84 + D85) / 7
O85: 65
P85: P84 + O85
B86: 7612
C86: C85 + B86
E86: (B80 + B81 + B82 + B83 + B84 + B85 + B86) / 830
D86: (B86 + B85 + B84 + B83) / (B82 + B81 + B80 + B79)
L86: round((B80 + B81 + B82 + B83 + B84 + B85 + B86) / 7, 0)
J86: (D80 + D81 + D82 + D83 + D84 + D85 + D86) / 7
O86: 24
P86: P85 + O86
B87: 3111
C87: C86 + B87
E87: (B81 + B82 + B83 + B84 + B85 + B86 + B87) / 830
D87: (B87 + B86 + B85 + B84) / (B83 + B82 + B81 + B80)
L87: round((B81 + B82 + B83 + B84 + B85 + B86 + B87) / 7, 0)
J87: (D81 + D82 + D83 + D84 + D85 + D86 + D87) / 7
O87: 7
P87: P86 + O87
B88: 4971
C88: C87 + B88
E88: (B82 + B83 + B84 + B85 + B86 + B87 + B88) / 830
D88: (B88 + B87 + B86 + B85) / (B84 + B83 + B82 + B81)
L88: round((B82 + B83 + B84 + B85 + B86 + B87 + B88) / 7, 0)
J88: (D82 + D83 + D84 + D85 + D86 + D87 + D88) / 7
O88: 88
P88: P87 + O88
B89: 11903
C89: C88 + B89
E89: (B83 + B84 + B85 + B86 + B87 + B88 + B89) / 830
D89: (B89 + B88 + B87 + B86) / (B85 + B84 + B83 + B82)
L89: round((B83 + B84 + B85 + B86 + B87 + B88 + B89) / 7, 0)
J89: (D83 + D84 + D85 + D86 + D87 + D88 + D89) / 7
O89: 92
P89: P88 + O89
B90: 12382
C90: C89 + B90
E90: (B84 + B85 + B86 + B87 + B88 + B89 + B90) / 830
D90: (B90 + B89 + B88 + B87) / (B86 + B85 + B84 + B83)
L90: round((B84 + B85 + B86 + B87 + B88 + B89 + B90) / 7, 0)
J90: (D84 + D85 + D86 + D87 + D88 + D89 + D90) / 7
O90: 72
P90: P89 + O90
B91: 11518
C91: C90 + B91
E91: (B85 + B86 + B87 + B88 + B89 + B90 + B91) / 830
D91: (B91 + B90 + B89 + B88) / (B87 + B86 + B85 + B84)
L91: round((B85 + B86 + B87 + B88 + B89 + B90 + B91) / 7, 0)
J91: (D85 + D86 + D87 + D88 + D89 + D90 + D91) / 7
O91: 65
P91: P90 + O91
B92: 10949
C92: C91 + B92
E92: (B86 + B87 + B88 + B89 + B90 + B91 + B92) / 830
D92: (B92 + B91 + B90 + B89) / (B88 + B87 + B86 + B85)
L92: round((B86 + B87 + B88 + B89 + B90 + B91 + B92) / 7, 0)
J92: (D86 + D87 + D88 + D89 + D90 + D91 + D92) / 7
O92: 75
P92: P91 + O92
B93: 8682
C93: C92 + B93
E93: (B87 + B88 + B89 + B90 + B91 + B92 + B93) / 830
D93: (B93 + B92 + B91 + B90) / (B89 + B88 + B87 + B86)
L93: round((B87 + B88 + B89 + B90 + B91 + B92 + B93) / 7, 0)
J93: (D87 + D88 + D89 + D90 + D91 + D92 + D93) / 7
O93: 17
P93: P92 + O93
B94: 4056
C94: C93 + B94
E94: (B88 + B89 + B90 + B91 + B92 + B93 + B94) / 830
D94: (B94 + B93 + B92 + B91) / (B90 + B89 + B88 + B87)
L94: round((B88 + B89 + B90 + B91 + B92 + B93 + B94) / 7, 0)
J94: (D88 + D89 + D90 + D91 + D92 + D93 + D94) / 7
O94: 10
P94: P93 + O94
B95: 6771
C95: C94 + B95
E95: (B89 + B90 + B91 + B92 + B93 + B94 + B95) / 830
D95: (B95 + B94 + B93 + B92) / (B91 + B90 + B89 + B88)
L95: round((B89 + B90 + B91 + B92 + B93 + B94 + B95) / 7, 0)
J95: (D89 + D90 + D91 + D92 + D93 + D94 + D95) / 7
O95: 88
P95: P94 + O95
B96: 17015
C96: C95 + B96
E96: (B90 + B91 + B92 + B93 + B94 + B95 + B96) / 830
D96: (B96 + B95 + B94 + B93) / (B92 + B91 + B90 + B89)
L96: round((B90 + B91 + B92 + B93 + B94 + B95 + B96) / 7, 0)
J96: (D90 + D91 + D92 + D93 + D94 + D95 + D96) / 7
O96: 92
P96: P95 + O96
B97: 16077
C97: C96 + B97
E97: (B91 + B92 + B93 + B94 + B95 + B96 + B97) / 830
D97: (B97 + B96 + B95 + B94) / (B93 + B92 + B91 + B90)
L97: round((B91 + B92 + B93 + B94 + B95 + B96 + B97) / 7, 0)
J97: (D91 + D92 + D93 + D94 + D95 + D96 + D97) / 7
O97: 67
P97: P96 + O97
B98: 19572
C98: C97 + B98
E98: (B92 + B93 + B94 + B95 + B96 + B97 + B98) / 830
D98: (B98 + B97 + B96 + B95) / (B94 + B93 + B92 + B91)
L98: round((B92 + B93 + B94 + B95 + B96 + B97 + B98) / 7, 0)
J98: (D92 + D93 + D94 + D95 + D96 + D97 + D98) / 7
O98: 116
P98: P97 + O98
B99: 15145
C99: C98 + B99
E99: (B93 + B94 + B95 + B96 + B97 + B98 + B99) / 830
D99: (B99 + B98 + B97 + B96) / (B95 + B94 + B93 + B92)
L99: round((B93 + B94 + B95 + B96 + B97 + B98 + B99) / 7, 0)
J99: (D93 + D94 + D95 + D96 + D97 + D98 + D99) / 7
O99: 86
P99: P98 + O99
B100: 13732
C100: C99 + B100
E100: (B94 + B95 + B96 + B97 + B98 + B99 + B100) / 830
D100: (B100 + B99 + B98 + B97) / (B96 + B95 + B94 + B93)
L100: round((B94 + B95 + B96 + B97 + B98 + B99 + B100) / 7, 0)
J100: (D94 + D95 + D96 + D97 + D98 + D99 + D100) / 7
O100: 23
P100: P99 + O100
B101: 6573
C101: C100 + B101
E101: (B95 + B96 + B97 + B98 + B99 + B100 + B101) / 830
D101: (B101 + B100 + B99 + B98) / (B97 + B96 + B95 + B94)
L101: round((B95 + B96 + B97 + B98 + B99 + B100 + B101) / 7, 0)
J101: (D95 + D96 + D97 + D98 + D99 + D100 + D101) / 7
O101: 17
P101: P100 + O101