Count days of a range within a weeknum

HeiNeken · May 16, 2018

Hi all,

I have a bit trouble wrapping my head around this little roadblock I came across. I have a cell with a start date and another cell with an end date let's call them a1 and a2. I want to count how many of the days between the 2 dates are the same week number.

example:

a1= 4/11/18
a2= 4/17/18
the total workdays between the 2 dates are 5. 3 of them are weeknum 15 and 2 are weeknum 16

I am looking for a way to count the number of days for each weeknum.

thank you in advance
Dan

HeiNeken · May 19, 2018

Here is the actual spreadsheet.

thank you
Dan

Aladin Akyurek · May 19, 2018

HeiNeken said:
Here is the actual spreadsheet.

thank you
Dan

See: https://www.mrexcel.com/forum/about-board/508133-attachments.html

HeiNeken · May 19, 2018

Here is the Math page.

Book1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

1

Math

2

2018

3

current add

sat

sun

4

Jobs

5

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

Math

Cell Formulas
Range	Formula
I2	=VALUE(YEAR('Main Page'!C7))
I3	=VALUE(MONTH('Main Page'!C7))
I4	=DATE(I2,I3,1)
A4	=IF(D4+E4+Math!G4+'Main Page'!G10-1<0,0,D4+E4+Math!G4+'Main Page'!G10-1)
A5	=IF(D5+E5+Math!G5+'Main Page'!G11-1<0,0,D5+E5+Math!G5+'Main Page'!G11-1)
A6	=IF(D6+E6+Math!G6+'Main Page'!G12-1<0,0,D6+E6+Math!G6+'Main Page'!G12-1)
A7	=IF(D7+E7+Math!G7+'Main Page'!G13-1<0,0,D7+E7+Math!G7+'Main Page'!G13-1)
A8	=IF(D8+E8+Math!G8+'Main Page'!G14-1<0,0,D8+E8+Math!G8+'Main Page'!G14-1)
A9	=IF(D9+E9+Math!G9+'Main Page'!G15-1<0,0,D9+E9+Math!G9+'Main Page'!G15-1)
A10	=IF(D10+E10+Math!G10+'Main Page'!G16-1<0,0,D10+E10+Math!G10+'Main Page'!G16-1)
A11	=IF(D11+E11+Math!G11+'Main Page'!G17-1<0,0,D11+E11+Math!G11+'Main Page'!G17-1)
A12	=IF(D12+E12+Math!G12+'Main Page'!G18-1<0,0,D12+E12+Math!G12+'Main Page'!G18-1)
A13	=IF(D13+E13+Math!G13+'Main Page'!G19-1<0,0,D13+E13+Math!G13+'Main Page'!G19-1)
A14	=IF(D14+E14+Math!G14+'Main Page'!G20-1<0,0,D14+E14+Math!G14+'Main Page'!G20-1)
A15	=IF(D15+E15+Math!G15+'Main Page'!G21-1<0,0,D15+E15+Math!G15+'Main Page'!G21-1)
A16	=IF(D16+E16+Math!G16+'Main Page'!G22-1<0,0,D16+E16+Math!G16+'Main Page'!G22-1)
A17	=IF(D17+E17+Math!G17+'Main Page'!G23-1<0,0,D17+E17+Math!G17+'Main Page'!G23-1)
A18	=IF(D18+E18+Math!G18+'Main Page'!G24-1<0,0,D18+E18+Math!G18+'Main Page'!G24-1)
A19	=IF(D19+E19+Math!G19+'Main Page'!G25-1<0,0,D19+E19+Math!G19+'Main Page'!G25-1)
A20	=IF(D20+E20+Math!G20+'Main Page'!G26-1<0,0,D20+E20+Math!G20+'Main Page'!G26-1)
A21	=IF(D21+E21+Math!G21+'Main Page'!G27-1<0,0,D21+E21+Math!G21+'Main Page'!G27-1)
B4	=IF('Main Page'!G10>15,'Main Page'!G10+6,IF('Main Page'!G10>10,'Main Page'!G10+4,IF('Main Page'!G10>=5,'Main Page'!G10+2,'Main Page'!G10)))
B5	=IF('Main Page'!G11>15,'Main Page'!G11+6,IF('Main Page'!G11>10,'Main Page'!G11+4,IF('Main Page'!G11>=5,'Main Page'!G11+2,'Main Page'!G11)))
B6	=IF('Main Page'!G12>15,'Main Page'!G12+6,IF('Main Page'!G12>10,'Main Page'!G12+4,IF('Main Page'!G12>=5,'Main Page'!G12+2,'Main Page'!G12)))
B7	=IF('Main Page'!G13>15,'Main Page'!G13+6,IF('Main Page'!G13>10,'Main Page'!G13+4,IF('Main Page'!G13>=5,'Main Page'!G13+2,'Main Page'!G13)))
B8	=IF('Main Page'!G14>15,'Main Page'!G14+6,IF('Main Page'!G14>10,'Main Page'!G14+4,IF('Main Page'!G14>=5,'Main Page'!G14+2,'Main Page'!G14)))
B9	=IF('Main Page'!G15>15,'Main Page'!G15+6,IF('Main Page'!G15>10,'Main Page'!G15+4,IF('Main Page'!G15>=5,'Main Page'!G15+2,'Main Page'!G15)))
B10	=IF('Main Page'!G16>15,'Main Page'!G16+6,IF('Main Page'!G16>10,'Main Page'!G16+4,IF('Main Page'!G16>=5,'Main Page'!G16+2,'Main Page'!G16)))
B11	=IF('Main Page'!G17>15,'Main Page'!G17+6,IF('Main Page'!G17>10,'Main Page'!G17+4,IF('Main Page'!G17>=5,'Main Page'!G17+2,'Main Page'!G17)))
B12	=IF('Main Page'!G18>15,'Main Page'!G18+6,IF('Main Page'!G18>10,'Main Page'!G18+4,IF('Main Page'!G18>=5,'Main Page'!G18+2,'Main Page'!G18)))
B13	=IF('Main Page'!G19>15,'Main Page'!G19+6,IF('Main Page'!G19>10,'Main Page'!G19+4,IF('Main Page'!G19>=5,'Main Page'!G19+2,'Main Page'!G19)))
B14	=IF('Main Page'!G20>15,'Main Page'!G20+6,IF('Main Page'!G20>10,'Main Page'!G20+4,IF('Main Page'!G20>=5,'Main Page'!G20+2,'Main Page'!G20)))
B15	=IF('Main Page'!G21>15,'Main Page'!G21+6,IF('Main Page'!G21>10,'Main Page'!G21+4,IF('Main Page'!G21>=5,'Main Page'!G21+2,'Main Page'!G21)))
B16	=IF('Main Page'!G22>15,'Main Page'!G22+6,IF('Main Page'!G22>10,'Main Page'!G22+4,IF('Main Page'!G22>=5,'Main Page'!G22+2,'Main Page'!G22)))
B17	=IF('Main Page'!G23>15,'Main Page'!G23+6,IF('Main Page'!G23>10,'Main Page'!G23+4,IF('Main Page'!G23>=5,'Main Page'!G23+2,'Main Page'!G23)))
B18	=IF('Main Page'!G24>15,'Main Page'!G24+6,IF('Main Page'!G24>10,'Main Page'!G24+4,IF('Main Page'!G24>=5,'Main Page'!G24+2,'Main Page'!G24)))
B19	=IF('Main Page'!G25>15,'Main Page'!G25+6,IF('Main Page'!G25>10,'Main Page'!G25+4,IF('Main Page'!G25>=5,'Main Page'!G25+2,'Main Page'!G25)))
B20	=IF('Main Page'!G26>15,'Main Page'!G26+6,IF('Main Page'!G26>10,'Main Page'!G26+4,IF('Main Page'!G26>=5,'Main Page'!G26+2,'Main Page'!G26)))
B21	=IF('Main Page'!G27>15,'Main Page'!G27+6,IF('Main Page'!G27>10,'Main Page'!G27+4,IF('Main Page'!G27>=5,'Main Page'!G27+2,'Main Page'!G27)))
C4	=IF(E4=0,2,D4)
C5	=IF(D5>0,2,0)
C6	=IF(D6>0,2,0)
C7	=IF(D7>0,2,0)
C8	=IF(D8>0,2,0)
C9	=IF(D9>0,2,0)
C10	=IF(D10>0,2,0)
C11	=IF(D11>0,2,0)
C12	=IF(D12>0,2,0)
C13	=IF(D13>0,2,0)
C14	=IF(D14>0,2,0)
C15	=IF(D15>0,2,0)
C16	=IF(D16>0,2,0)
C17	=IF(D17>0,2,0)
C18	=IF(D18>0,2,0)
C19	=IF(D19>0,2,0)
C20	=IF(D20>0,2,0)
C21	=IF(D21>0,2,0)
D4	=IFERROR(INT((WEEKDAY('Main Page'!F10-7)-'Main Page'!F10+F4)/7),0)
D5	=IFERROR(INT((WEEKDAY('Main Page'!F11-7)-'Main Page'!F11+F5)/7),0)
D6	=IFERROR(INT((WEEKDAY('Main Page'!F12-7)-'Main Page'!F12+F6)/7),0)
D7	=IFERROR(INT((WEEKDAY('Main Page'!F13-7)-'Main Page'!F13+F7)/7),0)
D8	=IFERROR(INT((WEEKDAY('Main Page'!F14-7)-'Main Page'!F14+F8)/7),0)
D9	=IFERROR(INT((WEEKDAY('Main Page'!F15-7)-'Main Page'!F15+F9)/7),0)
D10	=IFERROR(INT((WEEKDAY('Main Page'!F16-7)-'Main Page'!F16+F10)/7),0)
D11	=IFERROR(INT((WEEKDAY('Main Page'!F17-7)-'Main Page'!F17+F11)/7),0)
D12	=IFERROR(INT((WEEKDAY('Main Page'!F18-7)-'Main Page'!F18+F12)/7),0)
D13	=IFERROR(INT((WEEKDAY('Main Page'!F19-7)-'Main Page'!F19+F13)/7),0)
D14	=IFERROR(INT((WEEKDAY('Main Page'!F20-7)-'Main Page'!F20+F14)/7),0)
D15	=IFERROR(INT((WEEKDAY('Main Page'!F21-7)-'Main Page'!F21+F15)/7),0)
D16	=IFERROR(INT((WEEKDAY('Main Page'!F22-7)-'Main Page'!F22+F16)/7),0)
D17	=IFERROR(INT((WEEKDAY('Main Page'!F23-7)-'Main Page'!F23+F17)/7),0)
D18	=IFERROR(INT((WEEKDAY('Main Page'!F24-7)-'Main Page'!F24+F18)/7),0)
D19	=IFERROR(INT((WEEKDAY('Main Page'!F25-7)-'Main Page'!F25+F19)/7),0)
D20	=IFERROR(INT((WEEKDAY('Main Page'!F26-7)-'Main Page'!F26+F20)/7),0)
D21	=IFERROR(INT((WEEKDAY('Main Page'!F27-7)-'Main Page'!F27+F21)/7),0)
E4	=IFERROR(INT((WEEKDAY('Main Page'!F10-1)-'Main Page'!F10+F4)/7),0)
E5	=IFERROR(INT((WEEKDAY('Main Page'!F11-1)-'Main Page'!F11+F5)/7),0)
E6	=IFERROR(INT((WEEKDAY('Main Page'!F12-1)-'Main Page'!F12+F6)/7),0)
E7	=IFERROR(INT((WEEKDAY('Main Page'!F13-1)-'Main Page'!F13+F7)/7),0)
E8	=IFERROR(INT((WEEKDAY('Main Page'!F14-1)-'Main Page'!F14+F8)/7),0)
E9	=IFERROR(INT((WEEKDAY('Main Page'!F15-1)-'Main Page'!F15+F9)/7),0)
E10	=IFERROR(INT((WEEKDAY('Main Page'!F16-1)-'Main Page'!F16+F10)/7),0)
E11	=IFERROR(INT((WEEKDAY('Main Page'!F17-1)-'Main Page'!F17+F11)/7),0)
E12	=IFERROR(INT((WEEKDAY('Main Page'!F18-1)-'Main Page'!F18+F12)/7),0)
E13	=IFERROR(INT((WEEKDAY('Main Page'!F19-1)-'Main Page'!F19+F13)/7),0)
E14	=IFERROR(INT((WEEKDAY('Main Page'!F20-1)-'Main Page'!F20+F14)/7),0)
E15	=IFERROR(INT((WEEKDAY('Main Page'!F21-1)-'Main Page'!F21+F15)/7),0)
E16	=IFERROR(INT((WEEKDAY('Main Page'!F22-1)-'Main Page'!F22+F16)/7),0)
E17	=IFERROR(INT((WEEKDAY('Main Page'!F23-1)-'Main Page'!F23+F17)/7),0)
E18	=IFERROR(INT((WEEKDAY('Main Page'!F24-1)-'Main Page'!F24+F18)/7),0)
E19	=IFERROR(INT((WEEKDAY('Main Page'!F25-1)-'Main Page'!F25+F19)/7),0)
E20	=IFERROR(INT((WEEKDAY('Main Page'!F26-1)-'Main Page'!F26+F20)/7),0)
E21	=IFERROR(INT((WEEKDAY('Main Page'!F27-1)-'Main Page'!F27+F21)/7),0)
F4	='Main Page'!F10+'Main Page'!G10-1
F5	='Main Page'!F11+'Main Page'!G11-1
F6	='Main Page'!F12+'Main Page'!G12-1
F7	='Main Page'!F13+'Main Page'!G13-1
F8	='Main Page'!F14+'Main Page'!G14-1
F9	='Main Page'!F15+'Main Page'!G15-1
F10	='Main Page'!F16+'Main Page'!G16-1
F11	='Main Page'!F17+'Main Page'!G17-1
F12	='Main Page'!F18+'Main Page'!G18-1
F13	='Main Page'!F19+'Main Page'!G19-1
F14	='Main Page'!F20+'Main Page'!G20-1
F15	='Main Page'!F21+'Main Page'!G21-1
F16	='Main Page'!F22+'Main Page'!G22-1
F17	='Main Page'!F23+'Main Page'!G23-1
F18	='Main Page'!F24+'Main Page'!G24-1
F19	='Main Page'!F25+'Main Page'!G25-1
F20	='Main Page'!F26+'Main Page'!G26-1
F21	='Main Page'!F27+'Main Page'!G27-1
G4	=IF(Math!D4>Math!E4,1,0)
G5	=IF(Math!D5>Math!E5,1,0)
G6	=IF(Math!D6>Math!E6,1,0)
G7	=IF(Math!D7>Math!E7,1,0)
G8	=IF(Math!D8>Math!E8,1,0)
G9	=IF(Math!D9>Math!E9,1,0)
G10	=IF(Math!D10>Math!E10,1,0)
G11	=IF(Math!D11>Math!E11,1,0)
G12	=IF(Math!D12>Math!E12,1,0)
G13	=IF(Math!D13>Math!E13,1,0)
G14	=IF(Math!D14>Math!E14,1,0)
G15	=IF(Math!D15>Math!E15,1,0)
G16	=IF(Math!D16>Math!E16,1,0)
G17	=IF(Math!D17>Math!E17,1,0)
G18	=IF(Math!D18>Math!E18,1,0)
G19	=IF(Math!D19>Math!E19,1,0)
G20	=IF(Math!D20>Math!E20,1,0)
G21	=IF(Math!D21>Math!E21,1,0)
H4	=WORKDAY('Main Page'!F10,'Main Page'!G10)-1
H5	=WORKDAY('Main Page'!F11,'Main Page'!G11)-1
H6	=WORKDAY('Main Page'!F12,'Main Page'!G12)-1
H7	=WORKDAY('Main Page'!F13,'Main Page'!G13)-1
H8	=WORKDAY('Main Page'!F14,'Main Page'!G14)-1
H9	=WORKDAY('Main Page'!F15,'Main Page'!G15)-1
H10	=WORKDAY('Main Page'!F16,'Main Page'!G16)-1
H11	=WORKDAY('Main Page'!F17,'Main Page'!G17)-1
H12	=WORKDAY('Main Page'!F18,'Main Page'!G18)-1
H13	=WORKDAY('Main Page'!F19,'Main Page'!G19)-1
H14	=WORKDAY('Main Page'!F20,'Main Page'!G20)-1
H15	=WORKDAY('Main Page'!F21,'Main Page'!G21)-1
H16	=WORKDAY('Main Page'!F22,'Main Page'!G22)-1
H17	=WORKDAY('Main Page'!F23,'Main Page'!G23)-1
H18	=WORKDAY('Main Page'!F24,'Main Page'!G24)-1
H19	=WORKDAY('Main Page'!F25,'Main Page'!G25)-1
H20	=WORKDAY('Main Page'!F26,'Main Page'!G26)-1
H21	=WORKDAY('Main Page'!F27,'Main Page'!G27)-1
L6	='Main Page'!T9
L14	='Main Page'!T17
L22	='Main Page'!T25
S6	=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R11,0)),1)),0)
S7	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R12,0)),1)),0)}
S8	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R13,0)),1)),0)}
S9	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R14,0)),1)),0)}
S10	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R15,0)),1)),0)}
S11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
S14	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R19,0)),1)),0)}
S15	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R20,0)),1)),0)}
S16	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R21,0)),1)),0)}
S17	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R22,0)),1)),0)}
S18	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R23,0)),1)),0)}
S22	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R27,0)),1)),0)}
S23	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R28,0)),1)),0)}
S24	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R29,0)),1)),0)}
S25	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R30,0)),1)),0)}
S26	{=IFERROR(('Main Page'!$M$15/'Main Page'!$G$15)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$15&":"&'Main Page'!$H$15)))),'Main Page'!$R31,0)),1)),0)}
P11	=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),0)),0)
P6	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R11,0)),1)),0)}
P7	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R12,0)),1)),0)}
P8	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R13,0)),1)),0)}
P9	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R14,0)),1)),0)}
P10	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R15,0)),1)),0)}
P14	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R19,0)),1)),0)}
P15	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R20,0)),1)),0)}
P16	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R21,0)),1)),0)}
P17	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R22,0)),1)),0)}
P18	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R23,0)),1)),0)}
P22	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R27,0)),1)),0)}
P23	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R28,0)),1)),0)}
P24	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R29,0)),1)),0)}
P25	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R30,0)),1)),0)}
P26	{=IFERROR(('Main Page'!$M$12/'Main Page'!$G$12)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$12&":"&'Main Page'!$H$12)))),'Main Page'!$R31,0)),1)),0)}
K4	=IF('Main Page'!F10="",1,'Main Page'!F10)
K5	=IF('Main Page'!F11="",1,'Main Page'!F11)
K6	=IF('Main Page'!F12="",1,'Main Page'!F12)
K7	=IF('Main Page'!F13="",1,'Main Page'!F13)
K8	=IF('Main Page'!F14="",1,'Main Page'!F14)
K9	=IF('Main Page'!F15="",1,'Main Page'!F15)
K10	=IF('Main Page'!F16="",1,'Main Page'!F16)
K11	=IF('Main Page'!F17="",1,'Main Page'!F17)
K12	=IF('Main Page'!F18="",1,'Main Page'!F18)
K13	=IF('Main Page'!F19="",1,'Main Page'!F19)
K14	=IF('Main Page'!F20="",1,'Main Page'!F20)
K15	=IF('Main Page'!F21="",1,'Main Page'!F21)
K16	=IF('Main Page'!F22="",1,'Main Page'!F22)
K17	=IF('Main Page'!F23="",1,'Main Page'!F23)
K18	=IF('Main Page'!F24="",1,'Main Page'!F24)
K19	=IF('Main Page'!F25="",1,'Main Page'!F25)
K20	=IF('Main Page'!F26="",1,'Main Page'!F26)
T6	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R11,0)),1)),0)}
T7	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R12,0)),1)),0)}
T8	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R13,0)),1)),0)}
T9	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R14,0)),1)),0)}
T10	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R15,0)),1)),0)}
T11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
T14	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R19,0)),1)),0)}
T15	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R20,0)),1)),0)}
T16	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R21,0)),1)),0)}
T17	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R22,0)),1)),0)}
T18	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R23,0)),1)),0)}
T22	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R27,0)),1)),0)}
T23	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R28,0)),1)),0)}
T24	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R29,0)),1)),0)}
T25	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R30,0)),1)),0)}
T26	{=IFERROR(('Main Page'!$M$16/'Main Page'!$G$16)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$16&":"&'Main Page'!$H$16)))),'Main Page'!$R31,0)),1)),0)}
U6	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R11,0)),1)),0)}
U7	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R12,0)),1)),0)}
U8	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R13,0)),1)),0)}
U9	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R14,0)),1)),0)}
U10	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R15,0)),1)),0)}
U11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
U14	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R19,0)),1)),0)}
U15	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R20,0)),1)),0)}
U16	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R21,0)),1)),0)}
U17	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R22,0)),1)),0)}
U18	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R23,0)),1)),0)}
U22	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R27,0)),1)),0)}
U23	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R28,0)),1)),0)}
U24	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R29,0)),1)),0)}
U25	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R30,0)),1)),0)}
U26	{=IFERROR(('Main Page'!$M$17/'Main Page'!$G$17)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$17&":"&'Main Page'!$H$17)))),'Main Page'!$R31,0)),1)),0)}
V6	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R11,0)),1)),0)}
V7	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R12,0)),1)),0)}
V8	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R13,0)),1)),0)}
V9	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R14,0)),1)),0)}
V10	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R15,0)),1)),0)}
V11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
V14	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R19,0)),1)),0)}
V15	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R20,0)),1)),0)}
V16	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R21,0)),1)),0)}
V17	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R22,0)),1)),0)}
V18	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R23,0)),1)),0)}
V22	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R27,0)),1)),0)}
V23	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R28,0)),1)),0)}
V24	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R29,0)),1)),0)}
V25	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R30,0)),1)),0)}
V26	{=IFERROR(('Main Page'!$M$18/'Main Page'!$G$18)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$18&":"&'Main Page'!$H$18)))),'Main Page'!$R31,0)),1)),0)}
W6	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R11,0)),1)),0)}
W7	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R12,0)),1)),0)}
W8	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R13,0)),1)),0)}
W9	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R14,0)),1)),0)}
W10	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R15,0)),1)),0)}
W11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
W14	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R19,0)),1)),0)}
W15	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R20,0)),1)),0)}
W16	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R21,0)),1)),0)}
W17	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R22,0)),1)),0)}
W18	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R23,0)),1)),0)}
W22	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R27,0)),1)),0)}
W23	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R28,0)),1)),0)}
W24	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R29,0)),1)),0)}
W25	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R30,0)),1)),0)}
W26	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R31,0)),1)),0)}
X6	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R11,0)),1)),0)}
X7	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R12,0)),1)),0)}
X8	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R13,0)),1)),0)}
X9	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R14,0)),1)),0)}
X10	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R15,0)),1)),0)}
X11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
X14	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R19,0)),1)),0)}
X15	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R20,0)),1)),0)}
X16	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R21,0)),1)),0)}
X17	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R22,0)),1)),0)}
X18	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R23,0)),1)),0)}
X22	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R27,0)),1)),0)}
X23	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R28,0)),1)),0)}
X24	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R29,0)),1)),0)}
X25	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R30,0)),1)),0)}
X26	{=IFERROR(('Main Page'!$M$19/'Main Page'!$G$19)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$19&":"&'Main Page'!$H$19)))),'Main Page'!$R31,0)),1)),0)}
Y6	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R11,0)),1)),0)}
Y7	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R12,0)),1)),0)}
Y8	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R13,0)),1)),0)}
Y9	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R14,0)),1)),0)}
Y10	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R15,0)),1)),0)}
Y11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
Y14	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R19,0)),1)),0)}
Y15	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R20,0)),1)),0)}
Y16	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R21,0)),1)),0)}
Y17	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R22,0)),1)),0)}
Y18	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R23,0)),1)),0)}
Y22	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R27,0)),1)),0)}
Y23	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R28,0)),1)),0)}
Y24	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R29,0)),1)),0)}
Y25	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R30,0)),1)),0)}
Y26	{=IFERROR(('Main Page'!$M$21/'Main Page'!$G$21)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$21&":"&'Main Page'!$H$21)))),'Main Page'!$R31,0)),1)),0)}
Z6	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R11,0)),1)),0)}
Z7	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R12,0)),1)),0)}
Z8	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R13,0)),1)),0)}
Z9	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R14,0)),1)),0)}
Z10	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R15,0)),1)),0)}
Z11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
Z14	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R19,0)),1)),0)}
Z15	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R20,0)),1)),0)}
Z16	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R21,0)),1)),0)}
Z17	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R22,0)),1)),0)}
Z18	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R23,0)),1)),0)}
Z22	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R27,0)),1)),0)}
Z23	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R28,0)),1)),0)}
Z24	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R29,0)),1)),0)}
Z25	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R30,0)),1)),0)}
Z26	{=IFERROR(('Main Page'!$M$22/'Main Page'!$G$22)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$22&":"&'Main Page'!$H$22)))),'Main Page'!$R31,0)),1)),0)}
AA6	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R11,0)),1)),0)}
AA7	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R12,0)),1)),0)}
AA8	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R13,0)),1)),0)}
AA9	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R14,0)),1)),0)}
AA10	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R15,0)),1)),0)}
AA11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
AA14	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R19,0)),1)),0)}
AA15	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R20,0)),1)),0)}
AA16	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R21,0)),1)),0)}
AA17	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R22,0)),1)),0)}
AA18	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R23,0)),1)),0)}
AA22	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R27,0)),1)),0)}
AA23	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R28,0)),1)),0)}
AA24	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R29,0)),1)),0)}
AA25	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R30,0)),1)),0)}
AA26	{=IFERROR(('Main Page'!$M$23/'Main Page'!$G$23)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$23&":"&'Main Page'!$H$23)))),'Main Page'!$R31,0)),1)),0)}
AB6	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R11,0)),1)),0)}
AB7	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R12,0)),1)),0)}
AB8	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R13,0)),1)),0)}
AB9	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R14,0)),1)),0)}
AB10	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R15,0)),1)),0)}
AB11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
AB14	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R19,0)),1)),0)}
AB15	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R20,0)),1)),0)}
AB16	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R21,0)),1)),0)}
AB17	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R22,0)),1)),0)}
AB18	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R23,0)),1)),0)}
AB22	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R27,0)),1)),0)}
AB23	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R28,0)),1)),0)}
AB24	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R29,0)),1)),0)}
AB25	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R30,0)),1)),0)}
AB26	{=IFERROR(('Main Page'!$M$24/'Main Page'!$G$24)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$24&":"&'Main Page'!$H$24)))),'Main Page'!$R31,0)),1)),0)}
AC6	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R11,0)),1)),0)}
AC7	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R12,0)),1)),0)}
AC8	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R13,0)),1)),0)}
AC9	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R14,0)),1)),0)}
AC10	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R15,0)),1)),0)}
AC11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
AC14	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R19,0)),1)),0)}
AC15	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R20,0)),1)),0)}
AC16	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R21,0)),1)),0)}
AC17	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R22,0)),1)),0)}
AC18	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R23,0)),1)),0)}
AC22	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R27,0)),1)),0)}
AC23	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R28,0)),1)),0)}
AC24	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R29,0)),1)),0)}
AC25	{=IFERROR(('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R30,0)),1)),0)}
AC26	{= (('Main Page'!$M$25/'Main Page'!$G$25)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$25&":"&'Main Page'!$H$25)))),'Main Page'!$R31,0)),1)),0)}
AD6	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R11,0)),1)),0)}
AD7	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R12,0)),1)),0)}
AD8	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R13,0)),1)),0)}
AD9	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R14,0)),1)),0)}
AD10	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R15,0)),1)),0)}
AD11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
AD14	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R19,0)),1)),0)}
AD15	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R20,0)),1)),0)}
AD16	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R21,0)),1)),0)}
AD17	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R22,0)),1)),0)}
AD18	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R23,0)),1)),0)}
AD22	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R27,0)),1)),0)}
AD23	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R28,0)),1)),0)}
AD24	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R29,0)),1)),0)}
AD25	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R30,0)),1)),0)}
AD26	{=IFERROR(('Main Page'!$M$26/'Main Page'!$G$26)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$26&":"&'Main Page'!$H$26)))),'Main Page'!$R31,0)),1)),0)}
N6	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R11,0)),1)),0)}
N7	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R12,0)),1)),0)}
N8	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R13,0)),1)),0)}
N9	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R14,0)),1)),0)}
N10	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R15,0)),1)),0)}
N11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),0)),0)}
N14	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R19,0)),1)),0)}
N15	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R20,0)),1)),0)}
N16	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R21,0)),1)),0)}
N17	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R22,0)),1)),0)}
N18	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R23,0)),1)),0)}
N22	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R27,0)),1)),0)}
N23	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R28,0)),1)),0)}
N24	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R29,0)),1)),0)}
N25	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R30,0)),1)),0)}
N26	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R31,0)),1)),0)}
O6	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R11,0)),1)),0)}
O7	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R12,0)),1)),0)}
O8	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R13,0)),1)),0)}
O9	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R14,0)),1)),0)}
O10	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R15,0)),1)),0)}
O11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
O13	{=MATCH(MONTH(L14),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)}
O14	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R19,0)),1)),0)}
O15	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R20,0)),1)),0)}
O16	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R21,0)),1)),0)}
O17	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R22,0)),1)),0)}
O18	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R23,0)),1)),0)}
O22	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R27,0)),1)),0)}
O23	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R28,0)),1)),0)}
O24	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R29,0)),1)),0)}
O25	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R30,0)),1)),0)}
O26	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R31,0)),1)),0)}
Q6	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R11,0)),1)),0)}
Q7	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R12,0)),1)),0)}
Q8	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R13,0)),1)),0)}
Q9	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R14,0)),1)),0)}
Q10	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R15,0)),1)),0)}
Q11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
Q14	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R19,0)),1)),0)}
Q15	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R20,0)),1)),0)}
Q16	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R21,0)),1)),0)}
Q17	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R22,0)),1)),0)}
Q18	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R23,0)),1)),0)}
Q22	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R27,0)),1)),0)}
Q23	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R28,0)),1)),0)}
Q24	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R29,0)),1)),0)}
Q25	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R30,0)),1)),0)}
Q26	{=IFERROR(('Main Page'!$M$13/'Main Page'!$G$13)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$13&":"&'Main Page'!$H$13)))),'Main Page'!$R31,0)),1)),0)}
R6	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R11,0)),1)),0)}
R7	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R12,0)),1)),0)}
R8	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R13,0)),1)),0)}
R9	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R14,0)),1)),0)}
R10	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R15,0)),1)),0)}
R11	{=IFNA((MATCH(MONTH($L$6),MONTH(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),0)),0)}
R14	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R19,0)),1)),0)}
R15	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R20,0)),1)),0)}
R16	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R21,0)),1)),0)}
R17	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R22,0)),1)),0)}
R18	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R23,0)),1)),0)}
R22	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R27,0)),1)),0)}
R23	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R28,0)),1)),0)}
R24	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R29,0)),1)),0)}
R25	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R30,0)),1)),0)}
R26	{=IFERROR(('Main Page'!$M$14/'Main Page'!$G$14)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$14&":"&'Main Page'!$H$14)))),'Main Page'!$R31,0)),1)),0)}
Press CTRL+SHIFT+ENTER to enter array formulas.

HeiNeken · May 19, 2018

@Aladin, I hope I did it right. Let me know if you need anything else.

Aladin Akyurek · May 21, 2018

HeiNeken said:
@Aladin, I hope I did it right. Let me know if you need anything else.

You posted too much, which is hard to go thru. Is it possible to contain the post just to the problem area or construct an example describing the problem?

HeiNeken · May 21, 2018

Hi Aladin,

sorry about that. Let's try that again. This time I only selected the last week and first week of 2 months.

thank you
Dan

Book1

F

G

H

I

J

K

L

M

R

S

T

U

V

W

X

Y

Z

AA

AB

AC

AD

AE

AF

AG

8

Start

Duration in Days

Finish

Proposal

Coast

Profit

Taxable amount

After Tax

9

25

%

10

4/30/2018

3

11

5/3/2018

3

15

18

Week #

19

Main Page

Cell Formulas
Range	Formula
R15	=IF(S15="","",WEEKNUM(S15))
R19	=WEEKNUM(Y19)
S15	=IF(Y14T9,0),Y14+1,"")
S18	=TEXT(WEEKDAY(S20),"ddd")
S19	=IF(WEEKDAY(T17)=1,T17,"")
T15	=IF(S15T9,0),S15+1,"")
T18	=TEXT(WEEKDAY(T20),"ddd")
T19	=IF(S19<>"",S19+1,IF(WEEKDAY($T$17)=2,$T$17,""))
U15	=IF(T15$T$9,0),T15+1,"")
U18	=TEXT(WEEKDAY(U20),"ddd")
U19	=IF(T19<>"",T19+1,IF(WEEKDAY($T$17)=3,$T$17,""))
V15	=IF(U15$T$9,0),U15+1,"")
V18	=TEXT(WEEKDAY(V20),"ddd")
V19	=IF(U19<>"",U19+1,IF(WEEKDAY($T$17)=4,$T$17,""))
W15	=IF(V15$T$9,0),V15+1,"")
W18	=TEXT(WEEKDAY(W20),"ddd")
W19	=IF(V19<>"",V19+1,IF(WEEKDAY($T$17)=5,$T$17,""))
X15	=IF(W15$T$9,0),W15+1,"")
X18	=TEXT(WEEKDAY(X20),"ddd")
X19	=IF(W19<>"",W19+1,IF(WEEKDAY($T$17)=6,$T$17,""))
Y15	=IF(X15$T$9,0),X15+1,"")
Y18	=TEXT(WEEKDAY(Y20),"ddd")
Y19	=IF(X19<>"",X19+1,IF(WEEKDAY($T$17)=7,$T$17,""))
AA15	=SUM('Main Page'!AF15:AV15)
AA19	='Main Page'!AD19
AD15	=SUM(AF15:AV15)
AD19	=SUM(AF19:AV19)
AE15	=COUNTBLANK('Main Page'!T15:X15)
AE19	=COUNTBLANK('Main Page'!T19:X19)
H10	=IF(Math!K4="","",Math!K4+Math!A4)
H11	=IF(Math!K5="","",Math!K5+Math!A5)
I10	=IF($F10="","",SUM('Proposal Cost '!A41))
I11	=IF($F11="","",SUM('Proposal Cost '!A42))
J10	=IF($F10="","",SUM('Proposal Cost '!A6))
J11	=IF($F11="","",SUM('Proposal Cost '!A7))
K10	=IF(I10="","",I10-J10)
K11	=IF(I11="","",I11-J11)
L10	=IF(I10="","",(K10/100)*$L$9)
L11	=IF(I11="","",(K11/100)*$L$9)
M10	=IFERROR(K10-L10,"")
M11	=IFERROR(K11-L11,"")
AF15	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R15,0)),1)),0)}
AF19	{=IFERROR(('Main Page'!$M$10/'Main Page'!$G$10)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$10&":"&'Main Page'!$H$10)))),'Main Page'!$R19,0)),1)),0)}
AG15	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R15,0)),1)),0)}
AG19	{=IFERROR(('Main Page'!$M$11/'Main Page'!$G$11)*SUM(IF(ISNUMBER(MATCH(IF(ISNA(MATCH(WEEKDAY(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11))),{1,7},0)),WEEKNUM(ROW(INDIRECT('Main Page'!$F$11&":"&'Main Page'!$H$11)))),'Main Page'!$R19,0)),1)),0)}
Press CTRL+SHIFT+ENTER to enter array formulas.

Aladin Akyurek · May 22, 2018

Could you present the problem in the same style as you have used in your initial post, that is, post #1 ?

HeiNeken · May 22, 2018

Hi Aladin,
Sure,

Let's say project one starts
4/30/18 Monday and has 3 days duration. It would finish Wednesday 5/3/18. The next project would start right after on Thursday 5/4/18 and would finish Friday 5/10/18.

Last week of April is 18 and first week of may is 18 as well. Now I want to seperate the week by month in order to calculate the proper profit for each month.

Let's assume the first job profit is $1000 and the first day of the job is 4/30 and the last 2 days are in May. I want to devide the 1000 by the duration and multiply by 1 for the day in April to add the proper amount to the month of April and multiply it by the remaining 2 days for the beginning of May.

Hope that helps, let me know if you need more.

Thank you in advance for your help
Dan

Count days of a range within a weeknum

HeiNeken

New Member

HeiNeken

New Member

Excel Facts

Aladin Akyurek

MrExcel MVP

HeiNeken

New Member

HeiNeken

New Member

Aladin Akyurek

MrExcel MVP

HeiNeken

New Member

Aladin Akyurek

MrExcel MVP

HeiNeken

New Member

Similar threads

Forum statistics

Share this page

Count days of a range within a weeknum

New Member

New Member

Excel Facts

MrExcel MVP

New Member

New Member

MrExcel MVP

New Member

MrExcel MVP

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock