xi

ni

cni

fi

cfi

A1 = Random(9, 30)
A2 = Random(9, 30)
A3 = Random(9, 30)
A4 = Random(9, 30)
A5 = Random(9, 30)
A6 = Random(9, 30)
A7 = Random(9, 30)
A8 = Random(9, 30)
A9 = Random(9, 30)
A10 = Random(9, 30)
B1 = Random(9, 30)
B2 = Random(9, 30)
B3 = Random(9, 30)
B4 = Random(9, 30)
B5 = Random(9, 30)
B6 = Random(9, 30)
B7 = Random(9, 30)
B8 = Random(9, 30)
B9 = Random(9, 30)
B10 = Random(9, 30)
C1 = Random(9, 30)
C2 = Random(9, 30)
C3 = Random(9, 30)
C4 = Random(9, 30)
C5 = Random(9, 30)
C6 = Random(9, 30)
C7 = Random(9, 30)
C8 = Random(9, 30)
C9 = Random(9, 30)
C10 = Random(9, 30)
D1 = Random(9, 30)
D2 = Random(9, 30)
D3 = Random(9, 30)
D4 = Random(9, 30)
D5 = Random(9, 30)
D6 = Random(9, 30)
D7 = Random(9, 30)
D8 = Random(9, 30)
D9 = Random(9, 30)
D10 = Random(9, 30)
E1 = Random(9, 30)
E2 = Random(9, 30)
E3 = Random(9, 30)
E4 = Random(9, 30)
E5 = Random(9, 30)
E6 = Random(9, 30)
E7 = Random(9, 30)
E8 = Random(9, 30)
E9 = Random(9, 30)
E10 = Random(9, 30)
F1 = Random(9, 30)
F2 = Random(9, 30)
F3 = Random(9, 30)
F4 = Random(9, 30)
F5 = Random(9, 30)
F6 = Random(9, 30)
F7 = Random(9, 30)
F8 = Random(9, 30)
F9 = Random(9, 30)
F10 = Random(9, 30)
zalm: {A1, B1, C1, D1, E1, F1, A2, B2, C2, D2, E2, F2, A3, B3, C3, D3, E3, F3, A4, B4, C4, D4, E4, F4, A5, B5, C5, D5, E5, F5, A6, B6, C6, D6, E6, F6, A7, B7, C7, D7, E7, F7, A8, B8, C8, D8, E8, F8, A9, B9, C9, D9, E9, F9, A10, B10, C10, D10, E10, F10}
A13 = Min(zalm)
a = Max(zalm)
b = Min(zalm)
A14: A13 + 1
A15: A14 + 1
A16: A15 + 1
A17: A16 + 1
A18: A17 + 1
A19: A18 + 1
A20: A19 + 1
A21: A20 + 1
A22: A21 + 1
A23: A22 + 1
A24: A23 + 1
A25: A24 + 1
A26: A25 + 1
A27: A26 + 1
A28: A27 + 1
A29: A28 + 1
A30: A29 + 1
A31: A30 + 1
A32: A31 + 1
A33: A32 + 1
A34: A33 + 1
B13 = CountIf(x ≟ A13, zalm)
B14 = CountIf(x ≟ A14, zalm)
B15 = CountIf(x ≟ A15, zalm)
B16 = CountIf(x ≟ A16, zalm)
B17 = CountIf(x ≟ A17, zalm)
B18 = CountIf(x ≟ A18, zalm)
B19 = CountIf(x ≟ A19, zalm)
B20 = CountIf(x ≟ A20, zalm)
B21 = CountIf(x ≟ A21, zalm)
B22 = CountIf(x ≟ A22, zalm)
B23 = CountIf(x ≟ A23, zalm)
B24 = CountIf(x ≟ A24, zalm)
B25 = CountIf(x ≟ A25, zalm)
B26 = CountIf(x ≟ A26, zalm)
B27 = CountIf(x ≟ A27, zalm)
B28 = CountIf(x ≟ A28, zalm)
B29 = CountIf(x ≟ A29, zalm)
B30 = CountIf(x ≟ A30, zalm)
B31 = CountIf(x ≟ A31, zalm)
B32 = CountIf(x ≟ A32, zalm)
B33 = CountIf(x ≟ A33, zalm)
B34 = CountIf(x ≟ A34, zalm)
C13: 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
D13: B13 / 60
D14: B14 / 60
D15: B15 / 60
D16: B16 / 60
D17: B17 / 60
D18: B18 / 60
D19: B19 / 60
D20: B20 / 60
D21: B21 / 60
D22: B22 / 60
D23: B23 / 60
D24: B24 / 60
D25: B25 / 60
D26: B26 / 60
D27: B27 / 60
D28: B28 / 60
D29: B29 / 60
D30: B30 / 60
D31: B31 / 60
D32: B32 / 60
D33: B33 / 60
D34: B34 / 60
E13: C13 / 60
E14: C14 / 60
E15: C15 / 60
E16: C16 / 60
E17: C17 / 60
E18: C18 / 60
E19: C19 / 60
E20: C20 / 60
E21: C21 / 60
E22: C22 / 60
E23: C23 / 60
E24: C24 / 60
E25: C25 / 60
E26: C26 / 60
E27: C27 / 60
E28: C28 / 60
E29: C29 / 60
E30: C30 / 60
E31: C31 / 60
E32: C32 / 60
E33: C33 / 60
E34: C34 / 60