Link to home
Start Free TrialLog in
Avatar of Manju
ManjuFlag for India

asked on

SQL Fiscal Calendar - Stored Procedure with Parameters

Experts -

Table: FiscalCalendarMain
Fields:
FiscalCalendarID - Autonumber in SQL
FiscalCalendarName - nvarchar(255) - User Entry comes from a web page
FiscalCalendarStartDate - smalldatetime - User Entry comes from a web page
FiscalCalendarEndDate - smalldatetime - User Entry comes from a web page
FiscalStartMonth - nvarchar(255) - User Entry comes from a web page.

User accesses a web page & posts data onto above table. Once they submit, below table should also be automatically updated via a stored procedure with the parameters from above table (FiscalStartDate, FiscalEndDate, FiscalStartMonth)
Ex:
FiscalStartDate = 11/24/2017
FiscalEndDate = 06/30/2020
FiscalStartMonth = 7


Table: FiscalCalendarDetails
Fields:
SNO - Autonumber in SQL
FiscalCalendarID - nvarchar(255) - Comes from above table
FiscalDate - Smalldatetime - Ex: 11/24/2017
FiscalDay - nvarchar(255) - Ex: 24
FiscalDayName - nvarchar(255) - Ex: Friday
FiscalMonth - nvarchar(255) - Ex: 11
FiscalMonthName - nvarchar(255) - Ex: November
IsWeekend - nvarchar(255) - Ex: 1 for weekend(from FiscalDayName for Saturday and Sunday) and 0 for Weekdays
IsHoliday - nvarchar(255) - Default value for this field is 0.
HolidayName - nvarchar(255) - Default value for this field is ""
FiscalWk - nvarchar(255) - Ex: WK01 - Week number will be decided from the FiscalStartMonth from above table
FiscalQtr - nvarchar(255) - Ex: QTR01 - Quarter number will be decided from the FiscalStartMonth from above table
FiscalYear - nvarchar(255) - Ex: 2017
FiscalYearPerCalendar - nvarchar(255) - Ex: FY1718 (with prefix "FY", 17 and 18 in the example comes from FiscalStartMonth(from previous table) and FiscalEndMonth (12 months rolling from FiscalStartMonth)

Kindly help me with an SP for the above please.
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

You need 1 sp for both the inserts correct?
Avatar of Manju

ASKER

Only for the 2nd table (FiscalCalendarDetails)

Ex:

Declare @FiscalCalendarID nvarchar(255)
Declare @FiscalStartMonth nvarchar(255)
Declare @FiscalStartDate smalldatetime
Declare @FiscalEndDate smalldatetime

Set @FiscalCalendarID = 100
Set @FiscalStartMonth = 7
Set @FiscalStartDate = '11/24/2017'
Set @FiscalEndDate = '30/06/2020'

Remaining is what am asking help for.
Avatar of Manju

ASKER

I am able to get till here:
DECLARE @StartDate smalldatetime = '11/01/2017' --First Calendar date to include in table
DECLARE @EndDate smalldatetime = '06/30/2020' --Last calendar date to include in the table
declare @FiscalYearBegin_First smalldatetime = '07/01/2017' -- Considering 7 comes as FiscalStartMonth

DECLARE @Cycle INT = 52

SET DATEFIRST 7

 ;WITH --This secton generates the number table

        E00(N) AS (SELECT 1 UNION ALL SELECT 1),

        E02(N) AS (SELECT 1 FROM E00 a, E00 b),

        E04(N) AS (SELECT 1 FROM E02 a, E02 b),

        E08(N) AS (SELECT 1 FROM E04 a, E04 b),

        E16(N) AS (SELECT 1 FROM E08 a, E08 b),

        E32(N) AS (SELECT 1 FROM E16 a, E16 b),

   cteTally(N) AS (SELECT ROW_NUMBER() OVER (ORDER BY N) FROM E32),

--This CTE generates a list of calendar dates

CalendarBase as (

 SELECT

        DateKey = n

      , FiscalDate = DATEADD(day, n -1, @StartDate )

         , case when n = 1 then @FiscalYearBegin_First 

              else

                     case when datepart(dw,DATEADD(DAY, n -1 , @StartDate )) = 2 then  dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, n -1 , @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)

                     else

                           dateadd(week, datediff(week, 0, dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, n - 1, @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)), 7)

                     end

       end FiscalYearBegin

   

   FROM cteTally

  WHERE N <= DATEDIFF(day, @StartDate , @EndDate +1)

)

 

--Finally, use the list of calendar dates to fill the date dimension

SELECT DateKey as SNO

	, '100' as 'FiscalCalendarID'
	, FiscalDate	
	, FiscalDay				= DATEPART(DAY, FiscalDate)
	, FiscalDayName			= DATENAME (Weekday,FiscalDate ) 
	, FiscalMonth			= MONTH(FiscalDate)
	, FiscalMonthName		= DATENAME(Month, FiscalDate)
    , Case when (DATENAME (Weekday,FiscalDate)) in ('Saturday', 'Sunday') Then 1 Else 0 End as IsWeekend
    , 'IsHoliday'			= 0
    , 'HolidayName'			= 'No'
    , FiscalWeek			= 'WK'
    , FiscalQtr				= 'QTR'
    , FiscalYear			= YEAR(FiscalDate)
    , FiscalYearPerCalendar = 'FY'
	
FROM CalendarBase

Open in new window


User generated image
Main concern is trying to find the FiscalWeek, Qtr & FiscalYearpercalendar. Please help.
Please try this -

, FiscalWeek			= 'WK' + RIGHT('0' + CAST ( DAY(FiscalDate) AS VARCHAR ),2)
    , FiscalQtr				= 'QTR' + + RIGHT('0' + CAST ( DATEPART(QUARTER, FiscalDate) AS VARCHAR ),2)  
    , FiscalYearPerCalendar = 'FY' + CAST(RIGHT(FiscalDate,2) AS VARCHAR) + CAST( ( CAST(RIGHT(FiscalDate,2)AS INT) + 1 ) AS VARCHAR)

Open in new window

First of all: is this a relational or dimensional table?
Avatar of Manju

ASKER

@Pawan - Nope, its not working correctly.

As you can see in the attached picture,
WK is getting as "WK " + day. This is not what i want.
Similarly, QTR is not correct.

User generated image
What i want is, considering FIscalStartMonth is 7

I want July to be the start of fiscal.
So, First 4 week's of July should be WK 01 to WK 04 and Quarter should be QTR 1 till September end.

and Last column of FiscalYearperCalendar is throwing up error.
Avatar of Manju

ASKER

I changed the last column as below to get the value but still its not correct value.

, FiscalYearPerCalendar = 'FY ' + CAST(RIGHT(Year(FiscalDate),2) AS VARCHAR) + CAST( ( CAST(RIGHT(year(FiscalDate),2)AS INT) + 1 ) AS VARCHAR)
changing.
Please try full tested solution for you-

DECLARE @StartDate smalldatetime = '11/01/2017' --First Calendar date to include in table
DECLARE @EndDate smalldatetime = '06/30/2020' --Last calendar date to include in the table
declare @FiscalYearBegin_First smalldatetime = '07/01/2017' -- Considering 7 comes as FiscalStartMonth
DECLARE @Cycle INT = 52
SET DATEFIRST 7 ;
;WITH SingleDigits(Number) AS
(
    SELECT Number
    FROM (VALUES (1), (2), (3), (4), (5), (6), (7), (8),
    (9), (0)) AS X(Number)
)
,Series AS
(
    SELECT (d1.Number+1) + (10*d2.Number) + (100*d3.Number) + (1000*d4.Number) Number
    from
    SingleDigits as d1,
    SingleDigits as d2,
    SingleDigits as d3,
    SingleDigits as d4
)
,CTE1 AS
(
	SELECT Number datekey, DATEADD(Day,Number-1,@StartDate) FiscalDate 
	, case when Number = 1 then @FiscalYearBegin_First 
	else
	case when datepart(dw,DATEADD(DAY, number -1 , @StartDate )) = 2 then dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, number -1 , @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)
	else
	dateadd(week, datediff(week, 0, dateadd(week,CAST(ABS(DATEDIFF(WEEK,DATEADD(day, number - 1, @StartDate ),@StartDate))/@Cycle AS INT) * @Cycle,@FiscalYearBegin_First)), 7)
	end
	END FiscalYearBegin
	FROM Series 
	WHERE DATEADD(Day,Number-1,@StartDate) <= @EndDate
)
SELECT DateKey as SNO
	, '100' as 'FiscalCalendarID'
	, FiscalDate	
	, FiscalDay				= DATEPART(DAY, FiscalDate)
	, FiscalDayName			= DATENAME (Weekday,FiscalDate ) 
	, FiscalMonth			= MONTH(FiscalDate)
	, FiscalMonthName		= DATENAME(Month, FiscalDate)
    , Case when (DATENAME (Weekday,FiscalDate)) in ('Saturday', 'Sunday') Then 1 Else 0 End as IsWeekend
    , 'IsHoliday'			= 0
    , 'HolidayName'			= 'No'
    , FiscalWeek			= CONCAT( 'WK'  
	, CASE  WHEN DATEPART(DAY, FiscalDate) < 8 THEN '01'
			WHEN DATEPART(DAY, FiscalDate) >= 8 AND DATEPART(DAY, FiscalDate) < 15 THEN '02'
			WHEN DATEPART(DAY, FiscalDate) >= 15 AND DATEPART(DAY, FiscalDate) < 22 THEN '03'
			WHEN DATEPART(DAY, FiscalDate) >= 22 AND DATEPART(DAY, FiscalDate) <= 30 THEN '04'
			END ) 
    , FiscalQtr				= CONCAT( 'QTR' , 
	 CASE WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,3,@FiscalYearBegin_First) THEN '01'
		   WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,6,@FiscalYearBegin_First) THEN '02'
		   WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,9,@FiscalYearBegin_First) THEN '03'
		   WHEN FiscalDate BETWEEN @FiscalYearBegin_First AND DATEADD(month,12,@FiscalYearBegin_First) THEN '04' END  ) 
    , FiscalYear			= YEAR(FiscalDate)
    , FiscalYearPerCalendar = CONCAT( 'FY', CAST(RIGHT(Year(FiscalDate),2) AS VARCHAR) , CAST( ( CAST(RIGHT(year(FiscalDate),2)AS INT) + 1 ) AS VARCHAR) )
FROM CTE1
ORDER BY datekey

Open in new window


OUTPUT
/*------------------------
OUTPUT
------------------------*/
SNO         FiscalCalendarID FiscalDate              FiscalDay   FiscalDayName                  FiscalMonth FiscalMonthName                IsWeekend   IsHoliday   HolidayName FiscalWeek FiscalQtr FiscalYear  FiscalYearPerCalendar
----------- ---------------- ----------------------- ----------- ------------------------------ ----------- ------------------------------ ----------- ----------- ----------- ---------- --------- ----------- --------------------------------------------------------------
1           100              2017-11-01 00:00:00     1           Wednesday                      11          November                       0           0           No          WK01       QTR02     2017        FY1718
2           100              2017-11-02 00:00:00     2           Thursday                       11          November                       0           0           No          WK01       QTR02     2017        FY1718
3           100              2017-11-03 00:00:00     3           Friday                         11          November                       0           0           No          WK01       QTR02     2017        FY1718
4           100              2017-11-04 00:00:00     4           Saturday                       11          November                       1           0           No          WK01       QTR02     2017        FY1718
5           100              2017-11-05 00:00:00     5           Sunday                         11          November                       1           0           No          WK01       QTR02     2017        FY1718
6           100              2017-11-06 00:00:00     6           Monday                         11          November                       0           0           No          WK01       QTR02     2017        FY1718
7           100              2017-11-07 00:00:00     7           Tuesday                        11          November                       0           0           No          WK01       QTR02     2017        FY1718
8           100              2017-11-08 00:00:00     8           Wednesday                      11          November                       0           0           No          WK02       QTR02     2017        FY1718
9           100              2017-11-09 00:00:00     9           Thursday                       11          November                       0           0           No          WK02       QTR02     2017        FY1718
10          100              2017-11-10 00:00:00     10          Friday                         11          November                       0           0           No          WK02       QTR02     2017        FY1718
11          100              2017-11-11 00:00:00     11          Saturday                       11          November                       1           0           No          WK02       QTR02     2017        FY1718
12          100              2017-11-12 00:00:00     12          Sunday                         11          November                       1           0           No          WK02       QTR02     2017        FY1718
13          100              2017-11-13 00:00:00     13          Monday                         11          November                       0           0           No          WK02       QTR02     2017        FY1718
14          100              2017-11-14 00:00:00     14          Tuesday                        11          November                       0           0           No          WK02       QTR02     2017        FY1718
15          100              2017-11-15 00:00:00     15          Wednesday                      11          November                       0           0           No          WK03       QTR02     2017        FY1718
16          100              2017-11-16 00:00:00     16          Thursday                       11          November                       0           0           No          WK03       QTR02     2017        FY1718
17          100              2017-11-17 00:00:00     17          Friday                         11          November                       0           0           No          WK03       QTR02     2017        FY1718
18          100              2017-11-18 00:00:00     18          Saturday                       11          November                       1           0           No          WK03       QTR02     2017        FY1718
19          100              2017-11-19 00:00:00     19          Sunday                         11          November                       1           0           No          WK03       QTR02     2017        FY1718
20          100              2017-11-20 00:00:00     20          Monday                         11          November                       0           0           No          WK03       QTR02     2017        FY1718
21          100              2017-11-21 00:00:00     21          Tuesday                        11          November                       0           0           No          WK03       QTR02     2017        FY1718
22          100              2017-11-22 00:00:00     22          Wednesday                      11          November                       0           0           No          WK04       QTR02     2017        FY1718
23          100              2017-11-23 00:00:00     23          Thursday                       11          November                       0           0           No          WK04       QTR02     2017        FY1718
24          100              2017-11-24 00:00:00     24          Friday                         11          November                       0           0           No          WK04       QTR02     2017        FY1718
25          100              2017-11-25 00:00:00     25          Saturday                       11          November                       1           0           No          WK04       QTR02     2017        FY1718
26          100              2017-11-26 00:00:00     26          Sunday                         11          November                       1           0           No          WK04       QTR02     2017        FY1718
27          100              2017-11-27 00:00:00     27          Monday                         11          November                       0           0           No          WK04       QTR02     2017        FY1718
28          100              2017-11-28 00:00:00     28          Tuesday                        11          November                       0           0           No          WK04       QTR02     2017        FY1718
29          100              2017-11-29 00:00:00     29          Wednesday                      11          November                       0           0           No          WK04       QTR02     2017        FY1718
30          100              2017-11-30 00:00:00     30          Thursday                       11          November                       0           0           No          WK04       QTR02     2017        FY1718
31          100              2017-12-01 00:00:00     1           Friday                         12          December                       0           0           No          WK01       QTR02     2017        FY1718
32          100              2017-12-02 00:00:00     2           Saturday                       12          December                       1           0           No          WK01       QTR02     2017        FY1718
33          100              2017-12-03 00:00:00     3           Sunday                         12          December                       1           0           No          WK01       QTR02     2017        FY1718
34          100              2017-12-04 00:00:00     4           Monday                         12          December                       0           0           No          WK01       QTR02     2017        FY1718
35          100              2017-12-05 00:00:00     5           Tuesday                        12          December                       0           0           No          WK01       QTR02     2017        FY1718
36          100              2017-12-06 00:00:00     6           Wednesday                      12          December                       0           0           No          WK01       QTR02     2017        FY1718
37          100              2017-12-07 00:00:00     7           Thursday                       12          December                       0           0           No          WK01       QTR02     2017        FY1718
38          100              2017-12-08 00:00:00     8           Friday                         12          December                       0           0           No          WK02       QTR02     2017        FY1718
39          100              2017-12-09 00:00:00     9           Saturday                       12          December                       1           0           No          WK02       QTR02     2017        FY1718
40          100              2017-12-10 00:00:00     10          Sunday                         12          December                       1           0           No          WK02       QTR02     2017        FY1718
41          100              2017-12-11 00:00:00     11          Monday                         12          December                       0           0           No          WK02       QTR02     2017        FY1718
42          100              2017-12-12 00:00:00     12          Tuesday                        12          December                       0           0           No          WK02       QTR02     2017        FY1718
43          100              2017-12-13 00:00:00     13          Wednesday                      12          December                       0           0           No          WK02       QTR02     2017        FY1718
44          100              2017-12-14 00:00:00     14          Thursday                       12          December                       0           0           No          WK02       QTR02     2017        FY1718
45          100              2017-12-15 00:00:00     15          Friday                         12          December                       0           0           No          WK03       QTR02     2017        FY1718
46          100              2017-12-16 00:00:00     16          Saturday                       12          December                       1           0           No          WK03       QTR02     2017        FY1718
47          100              2017-12-17 00:00:00     17          Sunday                         12          December                       1           0           No          WK03       QTR02     2017        FY1718
48          100              2017-12-18 00:00:00     18          Monday                         12          December                       0           0           No          WK03       QTR02     2017        FY1718
49          100              2017-12-19 00:00:00     19          Tuesday                        12          December                       0           0           No          WK03       QTR02     2017        FY1718
50          100              2017-12-20 00:00:00     20          Wednesday                      12          December                       0           0           No          WK03       QTR02     2017        FY1718
51          100              2017-12-21 00:00:00     21          Thursday                       12          December                       0           0           No          WK03       QTR02     2017        FY1718
52          100              2017-12-22 00:00:00     22          Friday                         12          December                       0           0           No          WK04       QTR02     2017        FY1718
53          100              2017-12-23 00:00:00     23          Saturday                       12          December                       1           0           No          WK04       QTR02     2017        FY1718
54          100              2017-12-24 00:00:00     24          Sunday                         12          December                       1           0           No          WK04       QTR02     2017        FY1718
55          100              2017-12-25 00:00:00     25          Monday                         12          December                       0           0           No          WK04       QTR02     2017        FY1718
56          100              2017-12-26 00:00:00     26          Tuesday                        12          December                       0           0           No          WK04       QTR02     2017        FY1718
57          100              2017-12-27 00:00:00     27          Wednesday                      12          December                       0           0           No          WK04       QTR02     2017        FY1718
58          100              2017-12-28 00:00:00     28          Thursday                       12          December                       0           0           No          WK04       QTR02     2017        FY1718
59          100              2017-12-29 00:00:00     29          Friday                         12          December                       0           0           No          WK04       QTR02     2017        FY1718
60          100              2017-12-30 00:00:00     30          Saturday                       12          December                       1           0           No          WK04       QTR02     2017        FY1718
61          100              2017-12-31 00:00:00     31          Sunday                         12          December                       1           0           No          WK         QTR02     2017        FY1718
62          100              2018-01-01 00:00:00     1           Monday                         1           January                        0           0           No          WK01       QTR02     2018        FY1819
63          100              2018-01-02 00:00:00     2           Tuesday                        1           January                        0           0           No          WK01       QTR03     2018        FY1819
64          100              2018-01-03 00:00:00     3           Wednesday                      1           January                        0           0           No          WK01       QTR03     2018        FY1819
65          100              2018-01-04 00:00:00     4           Thursday                       1           January                        0           0           No          WK01       QTR03     2018        FY1819
66          100              2018-01-05 00:00:00     5           Friday                         1           January                        0           0           No          WK01       QTR03     2018        FY1819
67          100              2018-01-06 00:00:00     6           Saturday                       1           January                        1           0           No          WK01       QTR03     2018        FY1819
68          100              2018-01-07 00:00:00     7           Sunday                         1           January                        1           0           No          WK01       QTR03     2018        FY1819
69          100              2018-01-08 00:00:00     8           Monday                         1           January                        0           0           No          WK02       QTR03     2018        FY1819
70          100              2018-01-09 00:00:00     9           Tuesday                        1           January                        0           0           No          WK02       QTR03     2018        FY1819
71          100              2018-01-10 00:00:00     10          Wednesday                      1           January                        0           0           No          WK02       QTR03     2018        FY1819
72          100              2018-01-11 00:00:00     11          Thursday                       1           January                        0           0           No          WK02       QTR03     2018        FY1819
73          100              2018-01-12 00:00:00     12          Friday                         1           January                        0           0           No          WK02       QTR03     2018        FY1819
74          100              2018-01-13 00:00:00     13          Saturday                       1           January                        1           0           No          WK02       QTR03     2018        FY1819
75          100              2018-01-14 00:00:00     14          Sunday                         1           January                        1           0           No          WK02       QTR03     2018        FY1819
76          100              2018-01-15 00:00:00     15          Monday                         1           January                        0           0           No          WK03       QTR03     2018        FY1819
77          100              2018-01-16 00:00:00     16          Tuesday                        1           January                        0           0           No          WK03       QTR03     2018        FY1819
78          100              2018-01-17 00:00:00     17          Wednesday                      1           January                        0           0           No          WK03       QTR03     2018        FY1819
79          100              2018-01-18 00:00:00     18          Thursday                       1           January                        0           0           No          WK03       QTR03     2018        FY1819
80          100              2018-01-19 00:00:00     19          Friday                         1           January                        0           0           No          WK03       QTR03     2018        FY1819
81          100              2018-01-20 00:00:00     20          Saturday                       1           January                        1           0           No          WK03       QTR03     2018        FY1819
82          100              2018-01-21 00:00:00     21          Sunday                         1           January                        1           0           No          WK03       QTR03     2018        FY1819
83          100              2018-01-22 00:00:00     22          Monday                         1           January                        0           0           No          WK04       QTR03     2018        FY1819
84          100              2018-01-23 00:00:00     23          Tuesday                        1           January                        0           0           No          WK04       QTR03     2018        FY1819
85          100              2018-01-24 00:00:00     24          Wednesday                      1           January                        0           0           No          WK04       QTR03     2018        FY1819
86          100              2018-01-25 00:00:00     25          Thursday                       1           January                        0           0           No          WK04       QTR03     2018        FY1819
87          100              2018-01-26 00:00:00     26          Friday                         1           January                        0           0           No          WK04       QTR03     2018        FY1819
88          100              2018-01-27 00:00:00     27          Saturday                       1           January                        1           0           No          WK04       QTR03     2018        FY1819
89          100              2018-01-28 00:00:00     28          Sunday                         1           January                        1           0           No          WK04       QTR03     2018        FY1819
90          100              2018-01-29 00:00:00     29          Monday                         1           January                        0           0           No          WK04       QTR03     2018        FY1819
91          100              2018-01-30 00:00:00     30          Tuesday                        1           January                        0           0           No          WK04       QTR03     2018        FY1819
92          100              2018-01-31 00:00:00     31          Wednesday                      1           January                        0           0           No          WK         QTR03     2018        FY1819
93          100              2018-02-01 00:00:00     1           Thursday                       2           February                       0           0           No          WK01       QTR03     2018        FY1819
94          100              2018-02-02 00:00:00     2           Friday                         2           February                       0           0           No          WK01       QTR03     2018        FY1819
95          100              2018-02-03 00:00:00     3           Saturday                       2           February                       1           0           No          WK01       QTR03     2018        FY1819
96          100              2018-02-04 00:00:00     4           Sunday                         2           February                       1           0           No          WK01       QTR03     2018        FY1819
97          100              2018-02-05 00:00:00     5           Monday                         2           February                       0           0           No          WK01       QTR03     2018        FY1819
98          100              2018-02-06 00:00:00     6           Tuesday                        2           February                       0           0           No          WK01       QTR03     2018        FY1819
99          100              2018-02-07 00:00:00     7           Wednesday                      2           February                       0           0           No          WK01       QTR03     2018        FY1819
100         100              2018-02-08 00:00:00     8           Thursday                       2           February                       0           0           No          WK02       QTR03     2018        FY1819
101         100              2018-02-09 00:00:00     9           Friday                         2           February                       0           0           No          WK02       QTR03     2018        FY1819
102         100              2018-02-10 00:00:00     10          Saturday                       2           February                       1           0           No          WK02       QTR03     2018        FY1819
103         100              2018-02-11 00:00:00     11          Sunday                         2           February                       1           0           No          WK02       QTR03     2018        FY1819
104         100              2018-02-12 00:00:00     12          Monday                         2           February                       0           0           No          WK02       QTR03     2018        FY1819
105         100              2018-02-13 00:00:00     13          Tuesday                        2           February                       0           0           No          WK02       QTR03     2018        FY1819
106         100              2018-02-14 00:00:00     14          Wednesday                      2           February                       0           0           No          WK02       QTR03     2018        FY1819
107         100              2018-02-15 00:00:00     15          Thursday                       2           February                       0           0           No          WK03       QTR03     2018        FY1819
108         100              2018-02-16 00:00:00     16          Friday                         2           February                       0           0           No          WK03       QTR03     2018        FY1819
109         100              2018-02-17 00:00:00     17          Saturday                       2           February                       1           0           No          WK03       QTR03     2018        FY1819
110         100              2018-02-18 00:00:00     18          Sunday                         2           February                       1           0           No          WK03       QTR03     2018        FY1819
111         100              2018-02-19 00:00:00     19          Monday                         2           February                       0           0           No          WK03       QTR03     2018        FY1819
112         100              2018-02-20 00:00:00     20          Tuesday                        2           February                       0           0           No          WK03       QTR03     2018        FY1819
113         100              2018-02-21 00:00:00     21          Wednesday                      2           February                       0           0           No          WK03       QTR03     2018        FY1819
114         100              2018-02-22 00:00:00     22          Thursday                       2           February                       0           0           No          WK04       QTR03     2018        FY1819
115         100              2018-02-23 00:00:00     23          Friday                         2           February                       0           0           No          WK04       QTR03     2018        FY1819
116         100              2018-02-24 00:00:00     24          Saturday                       2           February                       1           0           No          WK04       QTR03     2018        FY1819
117         100              2018-02-25 00:00:00     25          Sunday                         2           February                       1           0           No          WK04       QTR03     2018        FY1819
118         100              2018-02-26 00:00:00     26          Monday                         2           February                       0           0           No          WK04       QTR03     2018        FY1819
119         100              2018-02-27 00:00:00     27          Tuesday                        2           February                       0           0           No          WK04       QTR03     2018        FY1819
120         100              2018-02-28 00:00:00     28          Wednesday                      2           February                       0           0           No          WK04       QTR03     2018        FY1819
121         100              2018-03-01 00:00:00     1           Thursday                       3           March                          0           0           No          WK01       QTR03     2018        FY1819
122         100              2018-03-02 00:00:00     2           Friday                         3           March                          0           0           No          WK01       QTR03     2018        FY1819
123         100              2018-03-03 00:00:00     3           Saturday                       3           March                          1           0           No          WK01       QTR03     2018        FY1819
124         100              2018-03-04 00:00:00     4           Sunday                         3           March                          1           0           No          WK01       QTR03     2018        FY1819
125         100              2018-03-05 00:00:00     5           Monday                         3           March                          0           0           No          WK01       QTR03     2018        FY1819
126         100              2018-03-06 00:00:00     6           Tuesday                        3           March                          0           0           No          WK01       QTR03     2018        FY1819
127         100              2018-03-07 00:00:00     7           Wednesday                      3           March                          0           0           No          WK01       QTR03     2018        FY1819
128         100              2018-03-08 00:00:00     8           Thursday                       3           March                          0           0           No          WK02       QTR03     2018        FY1819
129         100              2018-03-09 00:00:00     9           Friday                         3           March                          0           0           No          WK02       QTR03     2018        FY1819
130         100              2018-03-10 00:00:00     10          Saturday                       3           March                          1           0           No          WK02       QTR03     2018        FY1819
131         100              2018-03-11 00:00:00     11          Sunday                         3           March                          1           0           No          WK02       QTR03     2018        FY1819
132         100              2018-03-12 00:00:00     12          Monday                         3           March                          0           0           No          WK02       QTR03     2018        FY1819
133         100              2018-03-13 00:00:00     13          Tuesday                        3           March                          0           0           No          WK02       QTR03     2018        FY1819
134         100              2018-03-14 00:00:00     14          Wednesday                      3           March                          0           0           No          WK02       QTR03     2018        FY1819
135         100              2018-03-15 00:00:00     15          Thursday                       3           March                          0           0           No          WK03       QTR03     2018        FY1819
136         100              2018-03-16 00:00:00     16          Friday                         3           March                          0           0           No          WK03       QTR03     2018        FY1819
137         100              2018-03-17 00:00:00     17          Saturday                       3           March                          1           0           No          WK03       QTR03     2018        FY1819
138         100              2018-03-18 00:00:00     18          Sunday                         3           March                          1           0           No          WK03       QTR03     2018        FY1819
139         100              2018-03-19 00:00:00     19          Monday                         3           March                          0           0           No          WK03       QTR03     2018        FY1819
140         100              2018-03-20 00:00:00     20          Tuesday                        3           March                          0           0           No          WK03       QTR03     2018        FY1819
141         100              2018-03-21 00:00:00     21          Wednesday                      3           March                          0           0           No          WK03       QTR03     2018        FY1819
142         100              2018-03-22 00:00:00     22          Thursday                       3           March                          0           0           No          WK04       QTR03     2018        FY1819
143         100              2018-03-23 00:00:00     23          Friday                         3           March                          0           0           No          WK04       QTR03     2018        FY1819
144         100              2018-03-24 00:00:00     24          Saturday                       3           March                          1           0           No          WK04       QTR03     2018        FY1819
145         100              2018-03-25 00:00:00     25          Sunday                         3           March                          1           0           No          WK04       QTR03     2018        FY1819
146         100              2018-03-26 00:00:00     26          Monday                         3           March                          0           0           No          WK04       QTR03     2018        FY1819
147         100              2018-03-27 00:00:00     27          Tuesday                        3           March                          0           0           No          WK04       QTR03     2018        FY1819
148         100              2018-03-28 00:00:00     28          Wednesday                      3           March                          0           0           No          WK04       QTR03     2018        FY1819
149         100              2018-03-29 00:00:00     29          Thursday                       3           March                          0           0           No          WK04       QTR03     2018        FY1819
150         100              2018-03-30 00:00:00     30          Friday                         3           March                          0           0           No          WK04       QTR03     2018        FY1819
151         100              2018-03-31 00:00:00     31          Saturday                       3           March                          1           0           No          WK         QTR03     2018        FY1819
152         100              2018-04-01 00:00:00     1           Sunday                         4           April                          1           0           No          WK01       QTR03     2018        FY1819
153         100              2018-04-02 00:00:00     2           Monday                         4           April                          0           0           No          WK01       QTR04     2018        FY1819
154         100              2018-04-03 00:00:00     3           Tuesday                        4           April                          0           0           No          WK01       QTR04     2018        FY1819
155         100              2018-04-04 00:00:00     4           Wednesday                      4           April                          0           0           No          WK01       QTR04     2018        FY1819
156         100              2018-04-05 00:00:00     5           Thursday                       4           April                          0           0           No          WK01       QTR04     2018        FY1819
157         100              2018-04-06 00:00:00     6           Friday                         4           April                          0           0           No          WK01       QTR04     2018        FY1819
158         100              2018-04-07 00:00:00     7           Saturday                       4           April                          1           0           No          WK01       QTR04     2018        FY1819
159         100              2018-04-08 00:00:00     8           Sunday                         4           April                          1           0           No          WK02       QTR04     2018        FY1819
160         100              2018-04-09 00:00:00     9           Monday                         4           April                          0           0           No          WK02       QTR04     2018        FY1819
161         100              2018-04-10 00:00:00     10          Tuesday                        4           April                          0           0           No          WK02       QTR04     2018        FY1819
162         100              2018-04-11 00:00:00     11          Wednesday                      4           April                          0           0           No          WK02       QTR04     2018        FY1819
163         100              2018-04-12 00:00:00     12          Thursday                       4           April                          0           0           No          WK02       QTR04     2018        FY1819
164         100              2018-04-13 00:00:00     13          Friday                         4           April                          0           0           No          WK02       QTR04     2018        FY1819
165         100              2018-04-14 00:00:00     14          Saturday                       4           April                          1           0           No          WK02       QTR04     2018        FY1819
166         100              2018-04-15 00:00:00     15          Sunday                         4           April                          1           0           No          WK03       QTR04     2018        FY1819
167         100              2018-04-16 00:00:00     16          Monday                         4           April                          0           0           No          WK03       QTR04     2018        FY1819
168         100              2018-04-17 00:00:00     17          Tuesday                        4           April                          0           0           No          WK03       QTR04     2018        FY1819
169         100              2018-04-18 00:00:00     18          Wednesday                      4           April                          0           0           No          WK03       QTR04     2018        FY1819
170         100              2018-04-19 00:00:00     19          Thursday                       4           April                          0           0           No          WK03       QTR04     2018        FY1819
171         100              2018-04-20 00:00:00     20          Friday                         4           April                          0           0           No          WK03       QTR04     2018        FY1819
172         100              2018-04-21 00:00:00     21          Saturday                       4           April                          1           0           No          WK03       QTR04     2018        FY1819
173         100              2018-04-22 00:00:00     22          Sunday                         4           April                          1           0           No          WK04       QTR04     2018        FY1819
174         100              2018-04-23 00:00:00     23          Monday                         4           April                          0           0           No          WK04       QTR04     2018        FY1819
175         100              2018-04-24 00:00:00     24          Tuesday                        4           April                          0           0           No          WK04       QTR04     2018        FY1819
176         100              2018-04-25 00:00:00     25          Wednesday                      4           April                          0           0           No          WK04       QTR04     2018        FY1819
177         100              2018-04-26 00:00:00     26          Thursday                       4           April                          0           0           No          WK04       QTR04     2018        FY1819
178         100              2018-04-27 00:00:00     27          Friday                         4           April                          0           0           No          WK04       QTR04     2018        FY1819
179         100              2018-04-28 00:00:00     28          Saturday                       4           April                          1           0           No          WK04       QTR04     2018        FY1819
180         100              2018-04-29 00:00:00     29          Sunday                         4           April                          1           0           No          WK04       QTR04     2018        FY1819
181         100              2018-04-30 00:00:00     30          Monday                         4           April                          0           0           No          WK04       QTR04     2018        FY1819
182         100              2018-05-01 00:00:00     1           Tuesday                        5           May                            0           0           No          WK01       QTR04     2018        FY1819
183         100              2018-05-02 00:00:00     2           Wednesday                      5           May                            0           0           No          WK01       QTR04     2018        FY1819
184         100              2018-05-03 00:00:00     3           Thursday                       5           May                            0           0           No          WK01       QTR04     2018        FY1819
185         100              2018-05-04 00:00:00     4           Friday                         5           May                            0           0           No          WK01       QTR04     2018        FY1819
186         100              2018-05-05 00:00:00     5           Saturday                       5           May                            1           0           No          WK01       QTR04     2018        FY1819
187         100              2018-05-06 00:00:00     6           Sunday                         5           May                            1           0           No          WK01       QTR04     2018        FY1819
188         100              2018-05-07 00:00:00     7           Monday                         5           May                            0           0           No          WK01       QTR04     2018        FY1819
189         100              2018-05-08 00:00:00     8           Tuesday                        5           May                            0           0           No          WK02       QTR04     2018        FY1819
190         100              2018-05-09 00:00:00     9           Wednesday                      5           May                            0           0           No          WK02       QTR04     2018        FY1819
191         100              2018-05-10 00:00:00     10          Thursday                       5           May                            0           0           No          WK02       QTR04     2018        FY1819
192         100              2018-05-11 00:00:00     11          Friday                         5           May                            0           0           No          WK02       QTR04     2018        FY1819
193         100              2018-05-12 00:00:00     12          Saturday                       5           May                            1           0           No          WK02       QTR04     2018        FY1819
194         100              2018-05-13 00:00:00     13          Sunday                         5           May                            1           0           No          WK02       QTR04     2018        FY1819
195         100              2018-05-14 00:00:00     14          Monday                         5           May                            0           0           No          WK02       QTR04     2018        FY1819
196         100              2018-05-15 00:00:00     15          Tuesday                        5           May                            0           0           No          WK03       QTR04     2018        FY1819
197         100              2018-05-16 00:00:00     16          Wednesday                      5           May                            0           0           No          WK03       QTR04     2018        FY1819
198         100              2018-05-17 00:00:00     17          Thursday                       5           May                            0           0           No          WK03       QTR04     2018        FY1819
199         100              2018-05-18 00:00:00     18          Friday                         5           May                            0           0           No          WK03       QTR04     2018        FY1819
200         100              2018-05-19 00:00:00     19          Saturday                       5           May                            1           0           No          WK03       QTR04     2018        FY1819
201         100              2018-05-20 00:00:00     20          Sunday                         5           May                            1           0           No          WK03       QTR04     2018        FY1819
202         100              2018-05-21 00:00:00     21          Monday                         5           May                            0           0           No          WK03       QTR04     2018        FY1819
203         100              2018-05-22 00:00:00     22          Tuesday                        5           May                            0           0           No          WK04       QTR04     2018        FY1819
204         100              2018-05-23 00:00:00     23          Wednesday                      5           May                            0           0           No          WK04       QTR04     2018        FY1819
205         100              2018-05-24 00:00:00     24          Thursday                       5           May                            0           0           No          WK04       QTR04     2018        FY1819
206         100              2018-05-25 00:00:00     25          Friday                         5           May                            0           0           No          WK04       QTR04     2018        FY1819
207         100              2018-05-26 00:00:00     26          Saturday                       5           May                            1           0           No          WK04       QTR04     2018        FY1819
208         100              2018-05-27 00:00:00     27          Sunday                         5           May                            1           0           No          WK04       QTR04     2018        FY1819
209         100              2018-05-28 00:00:00     28          Monday                         5           May                            0           0           No          WK04       QTR04     2018        FY1819
210         100              2018-05-29 00:00:00     29          Tuesday                        5           May                            0           0           No          WK04       QTR04     2018        FY1819
211         100              2018-05-30 00:00:00     30          Wednesday                      5           May                            0           0           No          WK04       QTR04     2018        FY1819
212         100              2018-05-31 00:00:00     31          Thursday                       5           May                            0           0           No          WK         QTR04     2018        FY1819
213         100              2018-06-01 00:00:00     1           Friday                         6           June                           0           0           No          WK01       QTR04     2018        FY1819
214         100              2018-06-02 00:00:00     2           Saturday                       6           June                           1           0           No          WK01       QTR04     2018        FY1819
215         100              2018-06-03 00:00:00     3           Sunday                         6           June                           1           0           No          WK01       QTR04     2018        FY1819
216         100              2018-06-04 00:00:00     4           Monday                         6           June                           0           0           No          WK01       QTR04     2018        FY1819
217         100              2018-06-05 00:00:00     5           Tuesday                        6           June                           0           0           No          WK01       QTR04     2018        FY1819
218         100              2018-06-06 00:00:00     6           Wednesday                      6           June                           0           0           No          WK01       QTR04     2018        FY1819
219         100              2018-06-07 00:00:00     7           Thursday                       6           June                           0           0           No          WK01       QTR04     2018        FY1819
220         100              2018-06-08 00:00:00     8           Friday                         6           June                           0           0           No          WK02       QTR04     2018        FY1819
221         100              2018-06-09 00:00:00     9           Saturday                       6           June                           1           0           No          WK02       QTR04     2018        FY1819
222         100              2018-06-10 00:00:00     10          Sunday                         6           June                           1           0           No          WK02       QTR04     2018        FY1819
223         100              2018-06-11 00:00:00     11          Monday                         6           June                           0           0           No          WK02       QTR04     2018        FY1819
224         100              2018-06-12 00:00:00     12          Tuesday                        6           June                           0           0           No          WK02       QTR04     2018        FY1819
225         100              2018-06-13 00:00:00     13          Wednesday                      6           June                           0           0           No          WK02       QTR04     2018        FY1819
226         100              2018-06-14 00:00:00     14          Thursday                       6           June                           0           0           No          WK02       QTR04     2018        FY1819
227         100              2018-06-15 00:00:00     15          Friday                         6           June                           0           0           No          WK03       QTR04     2018        FY1819
228         100              2018-06-16 00:00:00     16          Saturday                       6           June                           1           0           No          WK03       QTR04     2018        FY1819
229         100              2018-06-17 00:00:00     17          Sunday                         6           June                           1           0           No          WK03       QTR04     2018        FY1819
230         100              2018-06-18 00:00:00     18          Monday                         6           June                           0           0           No          WK03       QTR04     2018        FY1819
231         100              2018-06-19 00:00:00     19          Tuesday                        6           June                           0           0           No          WK03       QTR04     2018        FY1819
232         100              2018-06-20 00:00:00     20          Wednesday                      6           June                           0           0           No          WK03       QTR04     2018        FY1819
233         100              2018-06-21 00:00:00     21          Thursday                       6           June                           0           0           No          WK03       QTR04     2018        FY1819
234         100              2018-06-22 00:00:00     22          Friday                         6           June                           0           0           No          WK04       QTR04     2018        FY1819
235         100              2018-06-23 00:00:00     23          Saturday                       6           June                           1           0           No          WK04       QTR04     2018        FY1819
236         100              2018-06-24 00:00:00     24          Sunday                         6           June                           1           0           No          WK04       QTR04     2018        FY1819
237         100              2018-06-25 00:00:00     25          Monday                         6           June                           0           0           No          WK04       QTR04     2018        FY1819
238         100              2018-06-26 00:00:00     26          Tuesday                        6           June                           0           0           No          WK04       QTR04     2018        FY1819
239         100              2018-06-27 00:00:00     27          Wednesday                      6           June                           0           0           No          WK04       QTR04     2018        FY1819
240         100              2018-06-28 00:00:00     28          Thursday                       6           June                           0           0           No          WK04       QTR04     2018        FY1819
241         100              2018-06-29 00:00:00     29          Friday                         6           June                           0           0           No          WK04       QTR04     2018        FY1819
242         100              2018-06-30 00:00:00     30          Saturday                       6           June                           1           0           No          WK04       QTR04     2018        FY1819
243         100              2018-07-01 00:00:00     1           Sunday                         7           July                           1           0           No          WK01       QTR04     2018        FY1819
244         100              2018-07-02 00:00:00     2           Monday                         7           July                           0           0           No          WK01       QTR       2018        FY1819
245         100              2018-07-03 00:00:00     3           Tuesday                        7           July                           0           0           No          WK01       QTR       2018        FY1819
246         100              2018-07-04 00:00:00     4           Wednesday                      7           July                           0           0           No          WK01       QTR       2018        FY1819
247         100              2018-07-05 00:00:00     5           Thursday                       7           July                           0           0           No          WK01       QTR       2018        FY1819
248         100              2018-07-06 00:00:00     6           Friday                         7           July                           0           0           No          WK01       QTR       2018        FY1819
249         100              2018-07-07 00:00:00     7           Saturday                       7           July                           1           0           No          WK01       QTR       2018        FY1819
250         100              2018-07-08 00:00:00     8           Sunday                         7           July                           1           0           No          WK02       QTR       2018        FY1819
251         100              2018-07-09 00:00:00     9           Monday                         7           July                           0           0           No          WK02       QTR       2018        FY1819
252         100              2018-07-10 00:00:00     10          Tuesday                        7           July                           0           0           No          WK02       QTR       2018        FY1819
253         100              2018-07-11 00:00:00     11          Wednesday                      7           July                           0           0           No          WK02       QTR       2018        FY1819
254         100              2018-07-12 00:00:00     12          Thursday                       7           July                           0           0           No          WK02       QTR       2018        FY1819
255         100              2018-07-13 00:00:00     13          Friday                         7           July                           0           0           No          WK02       QTR       2018        FY1819
256         100              2018-07-14 00:00:00     14          Saturday                       7           July                           1           0           No          WK02       QTR       2018        FY1819
257         100              2018-07-15 00:00:00     15          Sunday                         7           July                           1           0           No          WK03       QTR       2018        FY1819
258         100              2018-07-16 00:00:00     16          Monday                         7           July                           0           0           No          WK03       QTR       2018        FY1819
259         100              2018-07-17 00:00:00     17          Tuesday                        7           July                           0           0           No          WK03       QTR       2018        FY1819
260         100              2018-07-18 00:00:00     18          Wednesday                      7           July                           0           0           No          WK03       QTR       2018        FY1819
261         100              2018-07-19 00:00:00     19          Thursday                       7           July                           0           0           No          WK03       QTR       2018        FY1819
262         100              2018-07-20 00:00:00     20          Friday                         7           July                           0           0           No          WK03       QTR       2018        FY1819
263         100              2018-07-21 00:00:00     21          Saturday                       7           July                           1           0           No          WK03       QTR       2018        FY1819
264         100              2018-07-22 00:00:00     22          Sunday                         7           July                           1           0           No          WK04       QTR       2018        FY1819
265         100              2018-07-23 00:00:00     23          Monday                         7           July                           0           0           No          WK04       QTR       2018        FY1819
266         100              2018-07-24 00:00:00     24          Tuesday                        7           July                           0           0           No          WK04       QTR       2018        FY1819
267         100              2018-07-25 00:00:00     25          Wednesday                      7           July                           0           0           No          WK04       QTR       2018        FY1819
268         100              2018-07-26 00:00:00     26          Thursday                       7           July                           0           0           No          WK04       QTR       2018        FY1819
269         100              2018-07-27 00:00:00     27          Friday                         7           July                           0           0           No          WK04       QTR       2018        FY1819
270         100              2018-07-28 00:00:00     28          Saturday                       7           July                           1           0           No          WK04       QTR       2018        FY1819
271         100              2018-07-29 00:00:00     29          Sunday                         7           July                           1           0           No          WK04       QTR       2018        FY1819
272         100              2018-07-30 00:00:00     30          Monday                         7           July                           0           0           No          WK04       QTR       2018        FY1819
273         100              2018-07-31 00:00:00     31          Tuesday                        7           July                           0           0           No          WK         QTR       2018        FY1819
274         100              2018-08-01 00:00:00     1           Wednesday                      8           August                         0           0           No          WK01       QTR       2018        FY1819
275         100              2018-08-02 00:00:00     2           Thursday                       8           August                         0           0           No          WK01       QTR       2018        FY1819
276         100              2018-08-03 00:00:00     3           Friday                         8           August                         0           0           No          WK01       QTR       2018        FY1819
277         100              2018-08-04 00:00:00     4           Saturday                       8           August                         1           0           No          WK01       QTR       2018        FY1819
278         100              2018-08-05 00:00:00     5           Sunday                         8           August                         1           0           No          WK01       QTR       2018        FY1819
279         100              2018-08-06 00:00:00     6           Monday                         8           August                         0           0           No          WK01       QTR       2018        FY1819
280         100              2018-08-07 00:00:00     7           Tuesday                        8           August                         0           0           No          WK01       QTR       2018        FY1819
281         100              2018-08-08 00:00:00     8           Wednesday                      8           August                         0           0           No          WK02       QTR       2018        FY1819
282         100              2018-08-09 00:00:00     9           Thursday                       8           August                         0           0           No          WK02       QTR       2018        FY1819
283         100              2018-08-10 00:00:00     10          Friday                         8           August                         0           0           No          WK02       QTR       2018        FY1819
284         100              2018-08-11 00:00:00     11          Saturday                       8           August                         1           0           No          WK02       QTR       2018        FY1819
285         100              2018-08-12 00:00:00     12          Sunday                         8           August                         1           0           No          WK02       QTR       2018        FY1819
286         100              2018-08-13 00:00:00     13          Monday                         8           August                         0           0           No          WK02       QTR       2018        FY1819
287         100              2018-08-14 00:00:00     14          Tuesday                        8           August                         0           0           No          WK02       QTR       2018        FY1819
288         100              2018-08-15 00:00:00     15          Wednesday                      8           August                         0           0           No          WK03       QTR       2018        FY1819
289         100              2018-08-16 00:00:00     16          Thursday                       8           August                         0           0           No          WK03       QTR       2018        FY1819
290         100              2018-08-17 00:00:00     17          Friday                         8           August                         0           0           No          WK03       QTR       2018        FY1819
291         100              2018-08-18 00:00:00     18          Saturday                       8           August                         1           0           No          WK03       QTR       2018        FY1819
292         100              2018-08-19 00:00:00     19          Sunday                         8           August                         1           0           No          WK03       QTR       2018        FY1819
293         100              2018-08-20 00:00:00     20          Monday                         8           August                         0           0           No          WK03       QTR       2018        FY1819
294         100              2018-08-21 00:00:00     21          Tuesday                        8           August                         0           0           No          WK03       QTR       2018        FY1819
295         100              2018-08-22 00:00:00     22          Wednesday                      8           August                         0           0           No          WK04       QTR       2018        FY1819
296         100              2018-08-23 00:00:00     23          Thursday                       8           August                         0           0           No          WK04       QTR       2018        FY1819
297         100              2018-08-24 00:00:00     24          Friday                         8           August                         0           0           No          WK04       QTR       2018        FY1819
298         100              2018-08-25 00:00:00     25          Saturday                       8           August                         1           0           No          WK04       QTR       2018        FY1819
299         100              2018-08-26 00:00:00     26          Sunday                         8           August                         1           0           No          WK04       QTR       2018        FY1819
300         100              2018-08-27 00:00:00     27          Monday                         8           August                         0           0           No          WK04       QTR       2018        FY1819
301         100              2018-08-28 00:00:00     28          Tuesday                        8           August                         0           0           No          WK04       QTR       2018        FY1819
302         100              2018-08-29 00:00:00     29          Wednesday                      8           August                         0           0           No          WK04       QTR       2018        FY1819
303         100              2018-08-30 00:00:00     30          Thursday                       8           August                         0           0           No          WK04       QTR       2018        FY1819
304         100              2018-08-31 00:00:00     31          Friday                         8           August                         0           0           No          WK         QTR       2018        FY1819
305         100              2018-09-01 00:00:00     1           Saturday                       9           September                      1           0           No          WK01       QTR       2018        FY1819
306         100              2018-09-02 00:00:00     2           Sunday                         9           September                      1           0           No          WK01       QTR       2018        FY1819
307         100              2018-09-03 00:00:00     3           Monday                         9           September                      0           0           No          WK01       QTR       2018        FY1819
308         100              2018-09-04 00:00:00     4           Tuesday                        9           September                      0           0           No          WK01       QTR       2018        FY1819
309         100              2018-09-05 00:00:00     5           Wednesday                      9           September                      0           0           No          WK01       QTR       2018        FY1819
310         100              2018-09-06 00:00:00     6           Thursday                       9           September                      0           0           No          WK01       QTR       2018        FY1819
311         100              2018-09-07 00:00:00     7           Friday                         9           September                      0           0           No          WK01       QTR       2018        FY1819
312         100              2018-09-08 00:00:00     8           Saturday                       9           September                      1           0           No          WK02       QTR       2018        FY1819
313         100              2018-09-09 00:00:00     9           Sunday                         9           September                      1           0           No          WK02       QTR       2018        FY1819
314         100              2018-09-10 00:00:00     10          Monday                         9           September                      0           0           No          WK02       QTR       2018        FY1819
315         100              2018-09-11 00:00:00     11          Tuesday                        9           September                      0           0           No          WK02       QTR       2018        FY1819
316         100              2018-09-12 00:00:00     12          Wednesday                      9           September                      0           0           No          WK02       QTR       2018        FY1819
317         100              2018-09-13 00:00:00     13          Thursday                       9           September                      0           0           No          WK02       QTR       2018        FY1819
318         100              2018-09-14 00:00:00     14          Friday                         9           September                      0           0           No          WK02       QTR       2018        FY1819
319         100              2018-09-15 00:00:00     15          Saturday                       9           September                      1           0           No          WK03       QTR       2018        FY1819
320         100              2018-09-16 00:00:00     16          Sunday                         9           September                      1           0           No          WK03       QTR       2018        FY1819
321         100              2018-09-17 00:00:00     17          Monday                         9           September                      0           0           No          WK03       QTR       2018        FY1819
322         100              2018-09-18 00:00:00     18          Tuesday                        9           September                      0           0           No          WK03       QTR       2018        FY1819
323         100              2018-09-19 00:00:00     19          Wednesday                      9           September                      0           0           No          WK03       QTR       2018        FY1819
324         100              2018-09-20 00:00:00     20          Thursday                       9           September                      0           0           No          WK03       QTR       2018        FY1819
325         100              2018-09-21 00:00:00     21          Friday                         9           September                      0           0           No          WK03       QTR       2018        FY1819
326         100              2018-09-22 00:00:00     22          Saturday                       9           September                      1           0           No          WK04       QTR       2018        FY1819
327         100              2018-09-23 00:00:00     23          Sunday                         9           September                      1           0           No          WK04       QTR       2018        FY1819
328         100              2018-09-24 00:00:00     24          Monday                         9           September                      0           0           No          WK04       QTR       2018        FY1819
329         100              2018-09-25 00:00:00     25          Tuesday                        9           September                      0           0           No          WK04       QTR       2018        FY1819
330         100              2018-09-26 00:00:00     26          Wednesday                      9           September                      0           0           No          WK04       QTR       2018        FY1819
331         100              2018-09-27 00:00:00     27          Thursday                       9           September                      0           0           No          WK04       QTR       2018        FY1819
332         100              2018-09-28 00:00:00     28          Friday                         9           September                      0           0           No          WK04       QTR       2018        FY1819
333         100              2018-09-29 00:00:00     29          Saturday                       9           September                      1           0           No          WK04       QTR       2018        FY1819
334         100              2018-09-30 00:00:00     30          Sunday                         9           September                      1           0           No          WK04       QTR       2018        FY1819
335         100              2018-10-01 00:00:00     1           Monday                         10          October                        0           0           No          WK01       QTR       2018        FY1819
336         100              2018-10-02 00:00:00     2           Tuesday                        10          October                        0           0           No          WK01       QTR       2018        FY1819
337         100              2018-10-03 00:00:00     3           Wednesday                      10          October                        0           0           No          WK01       QTR       2018        FY1819
338         100              2018-10-04 00:00:00     4           Thursday                       10          October                        0           0           No          WK01       QTR       2018        FY1819
339         100              2018-10-05 00:00:00     5           Friday                         10          October                        0           0           No          WK01       QTR       2018        FY1819
340         100              2018-10-06 00:00:00     6           Saturday                       10          October                        1           0           No          WK01       QTR       2018        FY1819
341         100              2018-10-07 00:00:00     7           Sunday                         10          October                        1           0           No          WK01       QTR       2018        FY1819
342         100              2018-10-08 00:00:00     8           Monday                         10          October                        0           0           No          WK02       QTR       2018        FY1819
343         100              2018-10-09 00:00:00     9           Tuesday                        10          October                        0           0           No          WK02       QTR       2018        FY1819
344         100              2018-10-10 00:00:00     10          Wednesday                      10          October                        0           0           No          WK02       QTR       2018        FY1819
345         100              2018-10-11 00:00:00     11          Thursday                       10          October                        0           0           No          WK02       QTR       2018        FY1819
346         100              2018-10-12 00:00:00     12          Friday                         10          October                        0           0           No          WK02       QTR       2018        FY1819
347         100              2018-10-13 00:00:00     13          Saturday                       10          October                        1           0           No          WK02       QTR       2018        FY1819
348         100              2018-10-14 00:00:00     14          Sunday                         10          October                        1           0           No          WK02       QTR       2018        FY1819
349         100              2018-10-15 00:00:00     15          Monday                         10          October                        0           0           No          WK03       QTR       2018        FY1819
350         100              2018-10-16 00:00:00     16          Tuesday                        10          October                        0           0           No          WK03       QTR       2018        FY1819
351         100              2018-10-17 00:00:00     17          Wednesday                      10          October                        0           0           No          WK03       QTR       2018        FY1819
352         100              2018-10-18 00:00:00     18          Thursday                       10          October                        0           0           No          WK03       QTR       2018        FY1819
353         100              2018-10-19 00:00:00     19          Friday                         10          October                        0           0           No          WK03       QTR       2018        FY1819
354         100              2018-10-20 00:00:00     20          Saturday                       10          October                        1           0           No          WK03       QTR       2018        FY1819
355         100              2018-10-21 00:00:00     21          Sunday                         10          October                        1           0           No          WK03       QTR       2018        FY1819
356         100              2018-10-22 00:00:00     22          Monday                         10          October                        0           0           No          WK04       QTR       2018        FY1819
357         100              2018-10-23 00:00:00     23          Tuesday                        10          October                        0           0           No          WK04       QTR       2018        FY1819
358         100              2018-10-24 00:00:00     24          Wednesday                      10          October                        0           0           No          WK04       QTR       2018        FY1819
359         100              2018-10-25 00:00:00     25          Thursday                       10          October                        0           0           No          WK04       QTR       2018        FY1819
360         100              2018-10-26 00:00:00     26          Friday                         10          October                        0           0           No          WK04       QTR       2018        FY1819
361         100              2018-10-27 00:00:00     27          Saturday                       10          October                        1           0           No          WK04       QTR       2018        FY1819
362         100              2018-10-28 00:00:00     28          Sunday                         10          October                        1           0           No          WK04       QTR       2018        FY1819
363         100              2018-10-29 00:00:00     29          Monday                         10          October                        0           0           No          WK04       QTR       2018        FY1819
364         100              2018-10-30 00:00:00     30          Tuesday                        10          October                        0           0           No          WK04       QTR       2018        FY1819
365         100              2018-10-31 00:00:00     31          Wednesday                      10          October                        0           0           No          WK         QTR       2018        FY1819
366         100              2018-11-01 00:00:00     1           Thursday                       11          November                       0           0           No          WK01       QTR       2018        FY1819
367         100              2018-11-02 00:00:00     2           Friday                         11          November                       0           0           No          WK01       QTR       2018        FY1819
368         100              2018-11-03 00:00:00     3           Saturday                       11          November                       1           0           No          WK01       QTR       2018        FY1819
369         100              2018-11-04 00:00:00     4           Sunday                         11          November                       1           0           No          WK01       QTR       2018        FY1819
370         100              2018-11-05 00:00:00     5           Monday                         11          November                       0           0           No          WK01       QTR       2018        FY1819
371         100              2018-11-06 00:00:00     6           Tuesday                        11          November                       0           0           No          WK01       QTR       2018        FY1819
372         100              2018-11-07 00:00:00     7           Wednesday                      11          November                       0           0           No          WK01       QTR       2018        FY1819
373         100              2018-11-08 00:00:00     8           Thursday                       11          November                       0           0           No          WK02       QTR       2018        FY1819
374         100              2018-11-09 00:00:00     9           Friday                         11          November                       0           0           No          WK02       QTR       2018        FY1819
375         100              2018-11-10 00:00:00     10          Saturday                       11          November                       1           0           No          WK02       QTR       2018        FY1819
376         100              2018-11-11 00:00:00     11          Sunday                         11          November                       1           0           No          WK02       QTR       2018        FY1819
377         100              2018-11-12 00:00:00     12          Monday                         11          November                       0           0           No          WK02       QTR       2018        FY1819
378         100              2018-11-13 00:00:00     13          Tuesday                        11          November                       0           0           No          WK02       QTR       2018        FY1819
379         100              2018-11-14 00:00:00     14          Wednesday                      11          November                       0           0           No          WK02       QTR       2018        FY1819
380         100              2018-11-15 00:00:00     15          Thursday                       11          November                       0           0           No          WK03       QTR       2018        FY1819
381         100              2018-11-16 00:00:00     16          Friday                         11          November                       0           0           No          WK03       QTR       2018        FY1819
382         100              2018-11-17 00:00:00     17          Saturday                       11          November                       1           0           No          WK03       QTR       2018        FY1819
383         100              2018-11-18 00:00:00     18          Sunday                         11          November                       1           0           No          WK03       QTR       2018        FY1819
384         100              2018-11-19 00:00:00     19          Monday                         11          November                       0           0           No          WK03       QTR       2018        FY1819
385         100              2018-11-20 00:00:00     20          Tuesday                        11          November                       0           0           No          WK03       QTR       2018        FY1819
386         100              2018-11-21 00:00:00     21          Wednesday                      11          November                       0           0           No          WK03       QTR       2018        FY1819
387         100              2018-11-22 00:00:00     22          Thursday                       11          November                       0           0           No          WK04       QTR       2018        FY1819
388         100              2018-11-23 00:00:00     23          Friday                         11          November                       0           0           No          WK04       QTR       2018        FY1819
389         100              2018-11-24 00:00:00     24          Saturday                       11          November                       1           0           No          WK04       QTR       2018        FY1819
390         100              2018-11-25 00:00:00     25          Sunday                         11          November                       1           0           No          WK04       QTR       2018        FY1819
391         100              2018-11-26 00:00:00     26          Monday                         11          November                       0           0           No          WK04       QTR       2018        FY1819
392         100              2018-11-27 00:00:00     27          Tuesday                        11          November                       0           0           No          WK04       QTR       2018        FY1819
393         100              2018-11-28 00:00:00     28          Wednesday                      11          November                       0           0           No          WK04       QTR       2018        FY1819
394         100              2018-11-29 00:00:00     29          Thursday                       11          November                       0           0           No          WK04       QTR       2018        FY1819
395         100              2018-11-30 00:00:00     30          Friday                         11          November                       0           0           No          WK04       QTR       2018        FY1819
396         100              2018-12-01 00:00:00     1           Saturday                       12          December                       1           0           No          WK01       QTR       2018        FY1819
397         100              2018-12-02 00:00:00     2           Sunday                         12          December                       1           0           No          WK01       QTR       2018        FY1819
398         100              2018-12-03 00:00:00     3           Monday                         12          December                       0           0           No          WK01       QTR       2018        FY1819
399         100              2018-12-04 00:00:00     4           Tuesday                        12          December                       0           0           No          WK01       QTR       2018        FY1819
400         100              2018-12-05 00:00:00     5           Wednesday                      12          December                       0           0           No          WK01       QTR       2018        FY1819
401         100              2018-12-06 00:00:00     6           Thursday                       12          December                       0           0           No          WK01       QTR       2018        FY1819
402         100              2018-12-07 00:00:00     7           Friday                         12          December                       0           0           No          WK01       QTR       2018        FY1819
403         100              2018-12-08 00:00:00     8           Saturday                       12          December                       1           0           No          WK02       QTR       2018        FY1819
404         100              2018-12-09 00:00:00     9           Sunday                         12          December                       1           0           No          WK02       QTR       2018        FY1819
405         100              2018-12-10 00:00:00     10          Monday                         12          December                       0           0           No          WK02       QTR       2018        FY1819
406         100              2018-12-11 00:00:00     11          Tuesday                        12          December                       0           0           No          WK02       QTR       2018        FY1819
407         100              2018-12-12 00:00:00     12          Wednesday                      12          December                       0           0           No          WK02       QTR       2018        FY1819
408         100              2018-12-13 00:00:00     13          Thursday                       12          December                       0           0           No          WK02       QTR       2018        FY1819
409         100              2018-12-14 00:00:00     14          Friday                         12          December                       0           0           No          WK02       QTR       2018        FY1819
410         100              2018-12-15 00:00:00     15          Saturday                       12          December                       1           0           No          WK03       QTR       2018        FY1819
411         100              2018-12-16 00:00:00     16          Sunday                         12          December                       1           0           No          WK03       QTR       2018        FY1819
412         100              2018-12-17 00:00:00     17          Monday                         12          December                       0           0           No          WK03       QTR       2018        FY1819
413         100              2018-12-18 00:00:00     18          Tuesday                        12          December                       0           0           No          WK03       QTR       2018        FY1819
414         100              2018-12-19 00:00:00     19          Wednesday                      12          December                       0           0           No          WK03       QTR       2018        FY1819
415         100              2018-12-20 00:00:00     20          Thursday                       12          December                       0           0           No          WK03       QTR       2018        FY1819
416         100              2018-12-21 00:00:00     21          Friday                         12          December                       0           0           No          WK03       QTR       2018        FY1819
417         100              2018-12-22 00:00:00     22          Saturday                       12          December                       1           0           No          WK04       QTR       2018        FY1819
418         100              2018-12-23 00:00:00     23          Sunday                         12          December                       1           0           No          WK04       QTR       2018        FY1819
419         100              2018-12-24 00:00:00     24          Monday                         12          December                       0           0           No          WK04       QTR       2018        FY1819
420         100              2018-12-25 00:00:00     25          Tuesday                        12          December                       0           0           No          WK04       QTR       2018        FY1819
421         100              2018-12-26 00:00:00     26          Wednesday                      12          December                       0           0           No          WK04       QTR       2018        FY1819
422         100              2018-12-27 00:00:00     27          Thursday                       12          December                       0           0           No          WK04       QTR       2018        FY1819
423         100              2018-12-28 00:00:00     28          Friday                         12          December                       0           0           No          WK04       QTR       2018        FY1819
424         100              2018-12-29 00:00:00     29          Saturday                       12          December                       1           0           No          WK04       QTR       2018        FY1819
425         100              2018-12-30 00:00:00     30          Sunday                         12          December                       1           0           No          WK04       QTR       2018        FY1819
426         100              2018-12-31 00:00:00     31          Monday                         12          December                       0           0           No          WK         QTR       2018        FY1819
427         100              2019-01-01 00:00:00     1           Tuesday                        1           January                        0           0           No          WK01       QTR       2019        FY1920
428         100              2019-01-02 00:00:00     2           Wednesday                      1           January                        0           0           No          WK01       QTR       2019        FY1920
429         100              2019-01-03 00:00:00     3           Thursday                       1           January                        0           0           No          WK01       QTR       2019        FY1920
430         100              2019-01-04 00:00:00     4           Friday                         1           January                        0           0           No          WK01       QTR       2019        FY1920
431         100              2019-01-05 00:00:00     5           Saturday                       1           January                        1           0           No          WK01       QTR       2019        FY1920
432         100              2019-01-06 00:00:00     6           Sunday                         1           January                        1           0           No          WK01       QTR       2019        FY1920
433         100              2019-01-07 00:00:00     7           Monday                         1           January                        0           0           No          WK01       QTR       2019        FY1920
434         100              2019-01-08 00:00:00     8           Tuesday                        1           January                        0           0           No          WK02       QTR       2019        FY1920
435         100              2019-01-09 00:00:00     9           Wednesday                      1           January                        0           0           No          WK02       QTR       2019        FY1920
436         100              2019-01-10 00:00:00     10          Thursday                       1           January                        0           0           No          WK02       QTR       2019        FY1920
437         100              2019-01-11 00:00:00     11          Friday                         1           January                        0           0           No          WK02       QTR       2019        FY1920
438         100              2019-01-12 00:00:00     12          Saturday                       1           January                        1           0           No          WK02       QTR       2019        FY1920
439         100              2019-01-13 00:00:00     13          Sunday                         1           January                        1           0           No          WK02       QTR       2019        FY1920
440         100              2019-01-14 00:00:00     14          Monday                         1           January                        0           0           No          WK02       QTR       2019        FY1920
441         100              2019-01-15 00:00:00     15          Tuesday                        1           January                        0           0           No          WK03       QTR       2019        FY1920
442         100              2019-01-16 00:00:00     16          Wednesday                      1           January                        0           0           No          WK03       QTR       2019        FY1920
443         100              2019-01-17 00:00:00     17          Thursday                       1           January                        0           0           No          WK03       QTR       2019        FY1920
444         100              2019-01-18 00:00:00     18          Friday                         1           January                        0           0           No          WK03       QTR       2019        FY1920
445         100              2019-01-19 00:00:00     19          Saturday                       1           January                        1           0           No          WK03       QTR       2019        FY1920
446         100              2019-01-20 00:00:00     20          Sunday                         1           January                        1           0           No          WK03       QTR       2019        FY1920
447         100              2019-01-21 00:00:00     21          Monday                         1           January                        0           0           No          WK03       QTR       2019        FY1920
448         100              2019-01-22 00:00:00     22          Tuesday                        1           January                        0           0           No          WK04       QTR       2019        FY1920
449         100              2019-01-23 00:00:00     23          Wednesday                      1           January                        0           0           No          WK04       QTR       2019        FY1920
450         100              2019-01-24 00:00:00     24          Thursday                       1           January                        0           0           No          WK04       QTR       2019        FY1920
451         100              2019-01-25 00:00:00     25          Friday                         1           January                        0           0           No          WK04       QTR       2019        FY1920
452         100              2019-01-26 00:00:00     26          Saturday                       1           January                        1           0           No          WK04       QTR       2019        FY1920
453         100              2019-01-27 00:00:00     27          Sunday                         1           January                        1           0           No          WK04       QTR       2019        FY1920
454         100              2019-01-28 00:00:00     28          Monday                         1           January                        0           0           No          WK04       QTR       2019        FY1920
455         100              2019-01-29 00:00:00     29          Tuesday                        1           January                        0           0           No          WK04       QTR       2019        FY1920
456         100              2019-01-30 00:00:00     30          Wednesday                      1           January                        0           0           No          WK04       QTR       2019        FY1920
457         100              2019-01-31 00:00:00     31          Thursday                       1           January                        0           0           No          WK         QTR       2019        FY1920
458         100              2019-02-01 00:00:00     1           Friday                         2           February                       0           0           No          WK01       QTR       2019        FY1920
459         100              2019-02-02 00:00:00     2           Saturday                       2           February                       1           0           No          WK01       QTR       2019        FY1920
460         100              2019-02-03 00:00:00     3           Sunday                         2           February                       1           0           No          WK01       QTR       2019        FY1920
461         100              2019-02-04 00:00:00     4           Monday                         2           February                       0           0           No          WK01       QTR       2019        FY1920
462         100              2019-02-05 00:00:00     5           Tuesday                        2           February                       0           0           No          WK01       QTR       2019        FY1920
463         100              2019-02-06 00:00:00     6           Wednesday                      2           February                       0           0           No          WK01       QTR       2019        FY1920
464         100              2019-02-07 00:00:00     7           Thursday                       2           February                       0           0           No          WK01       QTR       2019        FY1920
465         100              2019-02-08 00:00:00     8           Friday                         2           February                       0           0           No          WK02       QTR       2019        FY1920
466         100              2019-02-09 00:00:00     9           Saturday                       2           February                       1           0           No          WK02       QTR       2019        FY1920
467         100              2019-02-10 00:00:00     10          Sunday                         2           February                       1           0           No          WK02       QTR       2019        FY1920
468         100              2019-02-11 00:00:00     11          Monday                         2           February                       0           0           No          WK02       QTR       2019        FY1920
469         100              2019-02-12 00:00:00     12          Tuesday                        2           February                       0           0           No          WK02       QTR       2019        FY1920
470         100              2019-02-13 00:00:00     13          Wednesday                      2           February                       0           0           No          WK02       QTR       2019        FY1920
471         100              2019-02-14 00:00:00     14          Thursday                       2           February                       0           0           No          WK02       QTR       2019        FY1920
472         100              2019-02-15 00:00:00     15          Friday                         2           February                       0           0           No          WK03       QTR       2019        FY1920
473         100              2019-02-16 00:00:00     16          Saturday                       2           February                       1           0           No          WK03       QTR       2019        FY1920
474         100              2019-02-17 00:00:00     17          Sunday                         2           February                       1           0           No          WK03       QTR       2019        FY1920
475         100              2019-02-18 00:00:00     18          Monday                         2           February                       0           0           No          WK03       QTR       2019        FY1920
476         100              2019-02-19 00:00:00     19          Tuesday                        2           February                       0           0           No          WK03       QTR       2019        FY1920
477         100              2019-02-20 00:00:00     20          Wednesday                      2           February                       0           0           No          WK03       QTR       2019        FY1920
478         100              2019-02-21 00:00:00     21          Thursday                       2           February                       0           0           No          WK03       QTR       2019        FY1920
479         100              2019-02-22 00:00:00     22          Friday                         2           February                       0           0           No          WK04       QTR       2019        FY1920
480         100              2019-02-23 00:00:00     23          Saturday                       2           February                       1           0           No          WK04       QTR       2019        FY1920
481         100              2019-02-24 00:00:00     24          Sunday                         2           February                       1           0           No          WK04       QTR       2019        FY1920
482         100              2019-02-25 00:00:00     25          Monday                         2           February                       0           0           No          WK04       QTR       2019        FY1920
483         100              2019-02-26 00:00:00     26          Tuesday                        2           February                       0           0           No          WK04       QTR       2019        FY1920
484         100              2019-02-27 00:00:00     27          Wednesday                      2           February                       0           0           No          WK04       QTR       2019        FY1920
485         100              2019-02-28 00:00:00     28          Thursday                       2           February                       0           0           No          WK04       QTR       2019        FY1920
486         100              2019-03-01 00:00:00     1           Friday                         3           March                          0           0           No          WK01       QTR       2019        FY1920
487         100              2019-03-02 00:00:00     2           Saturday                       3           March                          1           0           No          WK01       QTR       2019        FY1920
488         100              2019-03-03 00:00:00     3           Sunday                         3           March                          1           0           No          WK01       QTR       2019        FY1920
489         100              2019-03-04 00:00:00     4           Monday                         3           March                          0           0           No          WK01       QTR       2019        FY1920
490         100              2019-03-05 00:00:00     5           Tuesday                        3           March                          0           0           No          WK01       QTR       2019        FY1920
491         100              2019-03-06 00:00:00     6           Wednesday                      3           March                          0           0           No          WK01       QTR       2019        FY1920
492         100              2019-03-07 00:00:00     7           Thursday                       3           March                          0           0           No          WK01       QTR       2019        FY1920
493         100              2019-03-08 00:00:00     8           Friday                         3           March                          0           0           No          WK02       QTR       2019        FY1920
494         100              2019-03-09 00:00:00     9           Saturday                       3           March                          1           0           No          WK02       QTR       2019        FY1920
495         100              2019-03-10 00:00:00     10          Sunday                         3           March                          1           0           No          WK02       QTR       2019        FY1920
496         100              2019-03-11 00:00:00     11          Monday                         3           March                          0           0           No          WK02       QTR       2019        FY1920
497         100              2019-03-12 00:00:00     12          Tuesday                        3           March                          0           0           No          WK02       QTR       2019        FY1920
498         100              2019-03-13 00:00:00     13          Wednesday                      3           March                          0           0           No          WK02       QTR       2019        FY1920
499         100              2019-03-14 00:00:00     14          Thursday                       3           March                          0           0           No          WK02       QTR       2019        FY1920
500         100              2019-03-15 00:00:00     15          Friday                         3           March                          0           0           No          WK03       QTR       2019        FY1920
501         100              2019-03-16 00:00:00     16          Saturday                       3           March                          1           0           No          WK03       QTR       2019        FY1920
502         100              2019-03-17 00:00:00     17          Sunday                         3           March                          1           0           No          WK03       QTR       2019        FY1920
503         100              2019-03-18 00:00:00     18          Monday                         3           March                          0           0           No          WK03       QTR       2019        FY1920
504         100              2019-03-19 00:00:00     19          Tuesday                        3           March                          0           0           No          WK03       QTR       2019        FY1920
505         100              2019-03-20 00:00:00     20          Wednesday                      3           March                          0           0           No          WK03       QTR       2019        FY1920
506         100              2019-03-21 00:00:00     21          Thursday                       3           March                          0           0           No          WK03       QTR       2019        FY1920
507         100              2019-03-22 00:00:00     22          Friday                         3           March                          0           0           No          WK04       QTR       2019        FY1920
508         100              2019-03-23 00:00:00     23          Saturday                       3           March                          1           0           No          WK04       QTR       2019        FY1920
509         100              2019-03-24 00:00:00     24          Sunday                         3           March                          1           0           No          WK04       QTR       2019        FY1920
510         100              2019-03-25 00:00:00     25          Monday                         3           March                          0           0           No          WK04       QTR       2019        FY1920
511         100              2019-03-26 00:00:00     26          Tuesday                        3           March                          0           0           No          WK04       QTR       2019        FY1920
512         100              2019-03-27 00:00:00     27          Wednesday                      3           March                          0           0           No          WK04       QTR       2019        FY1920
513         100              2019-03-28 00:00:00     28          Thursday                       3           March                          0           0           No          WK04       QTR       2019        FY1920
514         100              2019-03-29 00:00:00     29          Friday                         3           March                          0           0           No          WK04       QTR       2019        FY1920
515         100              2019-03-30 00:00:00     30          Saturday                       3           March                          1           0           No          WK04       QTR       2019        FY1920
516         100              2019-03-31 00:00:00     31          Sunday                         3           March                          1           0           No          WK         QTR       2019        FY1920
517         100              2019-04-01 00:00:00     1           Monday                         4           April                          0           0           No          WK01       QTR       2019        FY1920
518         100              2019-04-02 00:00:00     2           Tuesday                        4           April                          0           0           No          WK01       QTR       2019        FY1920
519         100              2019-04-03 00:00:00     3           Wednesday                      4           April                          0           0           No          WK01       QTR       2019        FY1920
520         100              2019-04-04 00:00:00     4           Thursday                       4           April                          0           0           No          WK01       QTR       2019        FY1920
521         100              2019-04-05 00:00:00     5           Friday                         4           April                          0           0           No          WK01       QTR       2019        FY1920
522         100              2019-04-06 00:00:00     6           Saturday                       4           April                          1           0           No          WK01       QTR       2019        FY1920
523         100              2019-04-07 00:00:00     7           Sunday                         4           April                          1           0           No          WK01       QTR       2019        FY1920
524         100              2019-04-08 00:00:00     8           Monday                         4           April                          0           0           No          WK02       QTR       2019        FY1920
525         100              2019-04-09 00:00:00     9           Tuesday                        4           April                          0           0           No          WK02       QTR       2019        FY1920
526         100              2019-04-10 00:00:00     10          Wednesday                      4           April                          0           0           No          WK02       QTR       2019        FY1920
527         100              2019-04-11 00:00:00     11          Thursday                       4           April                          0           0           No          WK02       QTR       2019        FY1920
528         100              2019-04-12 00:00:00     12          Friday                         4           April                          0           0           No          WK02       QTR       2019        FY1920
529         100              2019-04-13 00:00:00     13          Saturday                       4           April                          1           0           No          WK02       QTR       2019        FY1920
530         100              2019-04-14 00:00:00     14          Sunday                         4           April                          1           0           No          WK02       QTR       2019        FY1920
531         100              2019-04-15 00:00:00     15          Monday                         4           April                          0           0           No          WK03       QTR       2019        FY1920
532         100              2019-04-16 00:00:00     16          Tuesday                        4           April                          0           0           No          WK03       QTR       2019        FY1920
533         100              2019-04-17 00:00:00     17          Wednesday                      4           April                          0           0           No          WK03       QTR       2019        FY1920
534         100              2019-04-18 00:00:00     18          Thursday                       4           April                          0           0           No          WK03       QTR       2019        FY1920
535         100              2019-04-19 00:00:00     19          Friday                         4           April                          0           0           No          WK03       QTR       2019        FY1920
536         100              2019-04-20 00:00:00     20          Saturday                       4           April                          1           0           No          WK03       QTR       2019        FY1920
537         100              2019-04-21 00:00:00     21          Sunday                         4           April                          1           0           No          WK03       QTR       2019        FY1920
538         100              2019-04-22 00:00:00     22          Monday                         4           April                          0           0           No          WK04       QTR       2019        FY1920
539         100              2019-04-23 00:00:00     23          Tuesday                        4           April                          0           0           No          WK04       QTR       2019        FY1920
540         100              2019-04-24 00:00:00     24          Wednesday                      4           April                          0           0           No          WK04       QTR       2019        FY1920
541         100              2019-04-25 00:00:00     25          Thursday                       4           April                          0           0           No          WK04       QTR       2019        FY1920
542         100              2019-04-26 00:00:00     26          Friday                         4           April                          0           0           No          WK04       QTR       2019        FY1920
543         100              2019-04-27 00:00:00     27          Saturday                       4           April                          1           0           No          WK04       QTR       2019        FY1920
544         100              2019-04-28 00:00:00     28          Sunday                         4           April                          1           0           No          WK04       QTR       2019        FY1920
545         100              2019-04-29 00:00:00     29          Monday                         4           April                          0           0           No          WK04       QTR       2019        FY1920
546         100              2019-04-30 00:00:00     30          Tuesday                        4           April                          0           0           No          WK04       QTR       2019        FY1920
547         100              2019-05-01 00:00:00     1           Wednesday                      5           May                            0           0           No          WK01       QTR       2019        FY1920
548         100              2019-05-02 00:00:00     2           Thursday                       5           May                            0           0           No          WK01       QTR       2019        FY1920
549         100              2019-05-03 00:00:00     3           Friday                         5           May                            0           0           No          WK01       QTR       2019        FY1920
550         100              2019-05-04 00:00:00     4           Saturday                       5           May                            1           0           No          WK01       QTR       2019        FY1920
551         100              2019-05-05 00:00:00     5           Sunday                         5           May                            1           0           No          WK01       QTR       2019        FY1920
552         100              2019-05-06 00:00:00     6           Monday                         5           May                            0           0           No          WK01       QTR       2019        FY1920
553         100              2019-05-07 00:00:00     7           Tuesday                        5           May                            0           0           No          WK01       QTR       2019        FY1920
554         100              2019-05-08 00:00:00     8           Wednesday                      5           May                            0           0           No          WK02       QTR       2019        FY1920
555         100              2019-05-09 00:00:00     9           Thursday                       5           May                            0           0           No          WK02       QTR       2019        FY1920
556         100              2019-05-10 00:00:00     10          Friday                         5           May                            0           0           No          WK02       QTR       2019        FY1920
557         100              2019-05-11 00:00:00     11          Saturday                       5           May                            1           0           No          WK02       QTR       2019        FY1920
558         100              2019-05-12 00:00:00     12          Sunday                         5           May                            1           0           No          WK02       QTR       2019        FY1920
559         100              2019-05-13 00:00:00     13          Monday                         5           May                            0           0           No          WK02       QTR       2019        FY1920
560         100              2019-05-14 00:00:00     14          Tuesday                        5           May                            0           0           No          WK02       QTR       2019        FY1920
561         100              2019-05-15 00:00:00     15          Wednesday                      5           May                            0           0           No          WK03       QTR       2019        FY1920
562         100              2019-05-16 00:00:00     16          Thursday                       5           May                            0           0           No          WK03       QTR       2019        FY1920
563         100              2019-05-17 00:00:00     17          Friday                         5           May                            0           0           No          WK03       QTR       2019        FY1920
564         100              2019-05-18 00:00:00     18          Saturday                       5           May                            1           0           No          WK03       QTR       2019        FY1920
565         100              2019-05-19 00:00:00     19          Sunday                         5           May                            1           0           No          WK03       QTR       2019        FY1920
566         100              2019-05-20 00:00:00     20          Monday                         5           May                            0           0           No          WK03       QTR       2019        FY1920
567         100              2019-05-21 00:00:00     21          Tuesday                        5           May                            0           0           No          WK03       QTR       2019        FY1920
568         100              2019-05-22 00:00:00     22          Wednesday                      5           May                            0           0           No          WK04       QTR       2019        FY1920
569         100              2019-05-23 00:00:00     23          Thursday                       5           May                            0           0           No          WK04       QTR       2019        FY1920
570         100              2019-05-24 00:00:00     24          Friday                         5           May                            0           0           No          WK04       QTR       2019        FY1920
571         100              2019-05-25 00:00:00     25          Saturday                       5           May                            1           0           No          WK04       QTR       2019        FY1920
572         100              2019-05-26 00:00:00     26          Sunday                         5           May                            1           0           No          WK04       QTR       2019        FY1920
573         100              2019-05-27 00:00:00     27          Monday                         5           May                            0           0           No          WK04       QTR       2019        FY1920
574         100              2019-05-28 00:00:00     28          Tuesday                        5           May                            0           0           No          WK04       QTR       2019        FY1920
575         100              2019-05-29 00:00:00     29          Wednesday                      5           May                            0           0           No          WK04       QTR       2019        FY1920
576         100              2019-05-30 00:00:00     30          Thursday                       5           May                            0           0           No          WK04       QTR       2019        FY1920
577         100              2019-05-31 00:00:00     31          Friday                         5           May                            0           0           No          WK         QTR       2019        FY1920
578         100              2019-06-01 00:00:00     1           Saturday                       6           June                           1           0           No          WK01       QTR       2019        FY1920
579         100              2019-06-02 00:00:00     2           Sunday                         6           June                           1           0           No          WK01       QTR       2019        FY1920
580         100              2019-06-03 00:00:00     3           Monday                         6           June                           0           0           No          WK01       QTR       2019        FY1920
581         100              2019-06-04 00:00:00     4           Tuesday                        6           June                           0           0           No          WK01       QTR       2019        FY1920
582         100              2019-06-05 00:00:00     5           Wednesday                      6           June                           0           0           No          WK01       QTR       2019        FY1920
583         100              2019-06-06 00:00:00     6           Thursday                       6           June                           0           0           No          WK01       QTR       2019        FY1920
584         100              2019-06-07 00:00:00     7           Friday                         6           June                           0           0           No          WK01       QTR       2019        FY1920
585         100              2019-06-08 00:00:00     8           Saturday                       6           June                           1           0           No          WK02       QTR       2019        FY1920
586         100              2019-06-09 00:00:00     9           Sunday                         6           June                           1           0           No          WK02       QTR       2019        FY1920
587         100              2019-06-10 00:00:00     10          Monday                         6           June                           0           0           No          WK02       QTR       2019        FY1920
588         100              2019-06-11 00:00:00     11          Tuesday                        6           June                           0           0           No          WK02       QTR       2019        FY1920
589         100              2019-06-12 00:00:00     12          Wednesday                      6           June                           0           0           No          WK02       QTR       2019        FY1920
590         100              2019-06-13 00:00:00     13          Thursday                       6           June                           0           0           No          WK02       QTR       2019        FY1920
591         100              2019-06-14 00:00:00     14          Friday                         6           June                           0           0           No          WK02       QTR       2019        FY1920
592         100              2019-06-15 00:00:00     15          Saturday                       6           June                           1           0           No          WK03       QTR       2019        FY1920
593         100              2019-06-16 00:00:00     16          Sunday                         6           June                           1           0           No          WK03       QTR       2019        FY1920
594         100              2019-06-17 00:00:00     17          Monday                         6           June                           0           0           No          WK03       QTR       2019        FY1920
595         100              2019-06-18 00:00:00     18          Tuesday                        6           June                           0           0           No          WK03       QTR       2019        FY1920
596         100              2019-06-19 00:00:00     19          Wednesday                      6           June                           0           0           No          WK03       QTR       2019        FY1920
597         100              2019-06-20 00:00:00     20          Thursday                       6           June                           0           0           No          WK03       QTR       2019        FY1920
598         100              2019-06-21 00:00:00     21          Friday                         6           June                           0           0           No          WK03       QTR       2019        FY1920
599         100              2019-06-22 00:00:00     22          Saturday                       6           June                           1           0           No          WK04       QTR       2019        FY1920
600         100              2019-06-23 00:00:00     23          Sunday                         6           June                           1           0           No          WK04       QTR       2019        FY1920
601         100              2019-06-24 00:00:00     24          Monday                         6           June                           0           0           No          WK04       QTR       2019        FY1920
602         100              2019-06-25 00:00:00     25          Tuesday                        6           June                           0           0           No          WK04       QTR       2019        FY1920
603         100              2019-06-26 00:00:00     26          Wednesday                      6           June                           0           0           No          WK04       QTR       2019        FY1920
604         100              2019-06-27 00:00:00     27          Thursday                       6           June                           0           0           No          WK04       QTR       2019        FY1920
605         100              2019-06-28 00:00:00     28          Friday                         6           June                           0           0           No          WK04       QTR       2019        FY1920
606         100              2019-06-29 00:00:00     29          Saturday                       6           June                           1           0           No          WK04       QTR       2019        FY1920
607         100              2019-06-30 00:00:00     30          Sunday                         6           June                           1           0           No          WK04       QTR       2019        FY1920
608         100              2019-07-01 00:00:00     1           Monday                         7           July                           0           0           No          WK01       QTR       2019        FY1920
609         100              2019-07-02 00:00:00     2           Tuesday                        7           July                           0           0           No          WK01       QTR       2019        FY1920
610         100              2019-07-03 00:00:00     3           Wednesday                      7           July                           0           0           No          WK01       QTR       2019        FY1920
611         100              2019-07-04 00:00:00     4           Thursday                       7           July                           0           0           No          WK01       QTR       2019        FY1920
612         100              2019-07-05 00:00:00     5           Friday                         7           July                           0           0           No          WK01       QTR       2019        FY1920
613         100              2019-07-06 00:00:00     6           Saturday                       7           July                           1           0           No          WK01       QTR       2019        FY1920
614         100              2019-07-07 00:00:00     7           Sunday                         7           July                           1           0           No          WK01       QTR       2019        FY1920
615         100              2019-07-08 00:00:00     8           Monday                         7           July                           0           0           No          WK02       QTR       2019        FY1920
616         100              2019-07-09 00:00:00     9           Tuesday                        7           July                           0           0           No          WK02       QTR       2019        FY1920
617         100              2019-07-10 00:00:00     10          Wednesday                      7           July                           0           0           No          WK02       QTR       2019        FY1920
618         100              2019-07-11 00:00:00     11          Thursday                       7           July                           0           0           No          WK02       QTR       2019        FY1920
619         100              2019-07-12 00:00:00     12          Friday                         7           July                           0           0           No          WK02       QTR       2019        FY1920
620         100              2019-07-13 00:00:00     13          Saturday                       7           July                           1           0           No          WK02       QTR       2019        FY1920
621         100              2019-07-14 00:00:00     14          Sunday                         7           July                           1           0           No          WK02       QTR       2019        FY1920
622         100              2019-07-15 00:00:00     15          Monday                         7           July                           0           0           No          WK03       QTR       2019        FY1920
623         100              2019-07-16 00:00:00     16          Tuesday                        7           July                           0           0           No          WK03       QTR       2019        FY1920
624         100              2019-07-17 00:00:00     17          Wednesday                      7           July                           0           0           No          WK03       QTR       2019        FY1920
625         100              2019-07-18 00:00:00     18          Thursday                       7           July                           0           0           No          WK03       QTR       2019        FY1920
626         100              2019-07-19 00:00:00     19          Friday                         7           July                           0           0           No          WK03       QTR       2019        FY1920
627         100              2019-07-20 00:00:00     20          Saturday                       7           July                           1           0           No          WK03       QTR       2019        FY1920
628         100              2019-07-21 00:00:00     21          Sunday                         7           July                           1           0           No          WK03       QTR       2019        FY1920
629         100              2019-07-22 00:00:00     22          Monday                         7           July                           0           0           No          WK04       QTR       2019        FY1920
630         100              2019-07-23 00:00:00     23          Tuesday                        7           July                           0           0           No          WK04       QTR       2019        FY1920
631         100              2019-07-24 00:00:00     24          Wednesday                      7           July                           0           0           No          WK04       QTR       2019        FY1920
632         100              2019-07-25 00:00:00     25          Thursday                       7           July                           0           0           No          WK04       QTR       2019        FY1920
633         100              2019-07-26 00:00:00     26          Friday                         7           July                           0           0           No          WK04       QTR       2019        FY1920
634         100              2019-07-27 00:00:00     27          Saturday                       7           July                           1           0           No          WK04       QTR       2019        FY1920
635         100              2019-07-28 00:00:00     28          Sunday                         7           July                           1           0           No          WK04       QTR       2019        FY1920
636         100              2019-07-29 00:00:00     29          Monday                         7           July                           0           0           No          WK04       QTR       2019        FY1920
637         100              2019-07-30 00:00:00     30          Tuesday                        7           July                           0           0           No          WK04       QTR       2019        FY1920
638         100              2019-07-31 00:00:00     31          Wednesday                      7           July                           0           0           No          WK         QTR       2019        FY1920
639         100              2019-08-01 00:00:00     1           Thursday                       8           August                         0           0           No          WK01       QTR       2019        FY1920
640         100              2019-08-02 00:00:00     2           Friday                         8           August                         0           0           No          WK01       QTR       2019        FY1920
641         100              2019-08-03 00:00:00     3           Saturday                       8           August                         1           0           No          WK01       QTR       2019        FY1920
642         100              2019-08-04 00:00:00     4           Sunday                         8           August                         1           0           No          WK01       QTR       2019        FY1920
643         100              2019-08-05 00:00:00     5           Monday                         8           August                         0           0           No          WK01       QTR       2019        FY1920
644         100              2019-08-06 00:00:00     6           Tuesday                        8           August                         0           0           No          WK01       QTR       2019        FY1920
645         100              2019-08-07 00:00:00     7           Wednesday                      8           August                         0           0           No          WK01       QTR       2019        FY1920
646         100              2019-08-08 00:00:00     8           Thursday                       8           August                         0           0           No          WK02       QTR       2019        FY1920
647         100              2019-08-09 00:00:00     9           Friday                         8           August                         0           0           No          WK02       QTR       2019        FY1920
648         100              2019-08-10 00:00:00     10          Saturday                       8           August                         1           0           No          WK02       QTR       2019        FY1920
649         100              2019-08-11 00:00:00     11          Sunday                         8           August                         1           0           No          WK02       QTR       2019        FY1920
650         100              2019-08-12 00:00:00     12          Monday                         8           August                         0           0           No          WK02       QTR       2019        FY1920
651         100              2019-08-13 00:00:00     13          Tuesday                        8           August                         0           0           No          WK02       QTR       2019        FY1920
652         100              2019-08-14 00:00:00     14          Wednesday                      8           August                         0           0           No          WK02       QTR       2019        FY1920
653         100              2019-08-15 00:00:00     15          Thursday                       8           August                         0           0           No          WK03       QTR       2019        FY1920
654         100              2019-08-16 00:00:00     16          Friday                         8           August                         0           0           No          WK03       QTR       2019        FY1920
655         100              2019-08-17 00:00:00     17          Saturday                       8           August                         1           0           No          WK03       QTR       2019        FY1920
656         100              2019-08-18 00:00:00     18          Sunday                         8           August                         1           0           No          WK03       QTR       2019        FY1920
657         100              2019-08-19 00:00:00     19          Monday                         8           August                         0           0           No          WK03       QTR       2019        FY1920
658         100              2019-08-20 00:00:00     20          Tuesday                        8           August                         0           0           No          WK03       QTR       2019        FY1920
659         100              2019-08-21 00:00:00     21          Wednesday                      8           August                         0           0           No          WK03       QTR       2019        FY1920
660         100              2019-08-22 00:00:00     22          Thursday                       8           August                         0           0           No          WK04       QTR       2019        FY1920
661         100              2019-08-23 00:00:00     23          Friday                         8           August                         0           0           No          WK04       QTR       2019        FY1920
662         100              2019-08-24 00:00:00     24          Saturday                       8           August                         1           0           No          WK04       QTR       2019        FY1920
663         100              2019-08-25 00:00:00     25          Sunday                         8           August                         1           0           No          WK04       QTR       2019        FY1920
664         100              2019-08-26 00:00:00     26          Monday                         8           August                         0           0           No          WK04       QTR       2019        FY1920
665         100              2019-08-27 00:00:00     27          Tuesday                        8           August                         0           0           No          WK04       QTR       2019        FY1920
666         100              2019-08-28 00:00:00     28          Wednesday                      8           August                         0           0           No          WK04       QTR       2019        FY1920
667         100              2019-08-29 00:00:00     29          Thursday                       8           August                         0           0           No          WK04       QTR       2019        FY1920
668         100              2019-08-30 00:00:00     30          Friday                         8           August                         0           0           No          WK04       QTR       2019        FY1920
669         100              2019-08-31 00:00:00     31          Saturday                       8           August                         1           0           No          WK         QTR       2019        FY1920
670         100              2019-09-01 00:00:00     1           Sunday                         9           September                      1           0           No          WK01       QTR       2019        FY1920
671         100              2019-09-02 00:00:00     2           Monday                         9           September                      0           0           No          WK01       QTR       2019        FY1920
672         100              2019-09-03 00:00:00     3           Tuesday                        9           September                      0           0           No          WK01       QTR       2019        FY1920
673         100              2019-09-04 00:00:00     4           Wednesday                      9           September                      0           0           No          WK01       QTR       2019        FY1920
674         100              2019-09-05 00:00:00     5           Thursday                       9           September                      0           0           No          WK01       QTR       2019        FY1920
675         100              2019-09-06 00:00:00     6           Friday                         9           September                      0           0           No          WK01       QTR       2019        FY1920
676         100              2019-09-07 00:00:00     7           Saturday                       9           September                      1           0           No          WK01       QTR       2019        FY1920
677         100              2019-09-08 00:00:00     8           Sunday                         9           September                      1           0           No          WK02       QTR       2019        FY1920
678         100              2019-09-09 00:00:00     9           Monday                         9           September                      0           0           No          WK02       QTR       2019        FY1920
679         100              2019-09-10 00:00:00     10          Tuesday                        9           September                      0           0           No          WK02       QTR       2019        FY1920
680         100              2019-09-11 00:00:00     11          Wednesday                      9           September                      0           0           No          WK02       QTR       2019        FY1920
681         100              2019-09-12 00:00:00     12          Thursday                       9           September                      0           0           No          WK02       QTR       2019        FY1920
682         100              2019-09-13 00:00:00     13          Friday                         9           September                      0           0           No          WK02       QTR       2019        FY1920
683         100              2019-09-14 00:00:00     14          Saturday                       9           September                      1           0           No          WK02       QTR       2019        FY1920
684         100              2019-09-15 00:00:00     15          Sunday                         9           September                      1           0           No          WK03       QTR       2019        FY1920
685         100              2019-09-16 00:00:00     16          Monday                         9           September                      0           0           No          WK03       QTR       2019        FY1920
686         100              2019-09-17 00:00:00     17          Tuesday                        9           September                      0           0           No          WK03       QTR       2019        FY1920
687         100              2019-09-18 00:00:00     18          Wednesday                      9           September                      0           0           No          WK03       QTR       2019        FY1920
688         100              2019-09-19 00:00:00     19          Thursday                       9           September                      0           0           No          WK03       QTR       2019        FY1920
689         100              2019-09-20 00:00:00     20          Friday                         9           September                      0           0           No          WK03       QTR       2019        FY1920
690         100              2019-09-21 00:00:00     21          Saturday                       9           September                      1           0           No          WK03       QTR       2019        FY1920
691         100              2019-09-22 00:00:00     22          Sunday                         9           September                      1           0           No          WK04       QTR       2019        FY1920
692         100              2019-09-23 00:00:00     23          Monday                         9           September                      0           0           No          WK04       QTR       2019        FY1920
693         100              2019-09-24 00:00:00     24          Tuesday                        9           September                      0           0           No          WK04       QTR       2019        FY1920
694         100              2019-09-25 00:00:00     25          Wednesday                      9           September                      0           0           No          WK04       QTR       2019        FY1920
695         100              2019-09-26 00:00:00     26          Thursday                       9           September                      0           0           No          WK04       QTR       2019        FY1920
696         100              2019-09-27 00:00:00     27          Friday                         9           September                      0           0           No          WK04       QTR       2019        FY1920
697         100              2019-09-28 00:00:00     28          Saturday                       9           September                      1           0           No          WK04       QTR       2019        FY1920
698         100              2019-09-29 00:00:00     29          Sunday                         9           September                      1           0           No          WK04       QTR       2019        FY1920
699         100              2019-09-30 00:00:00     30          Monday                         9           September                      0           0           No          WK04       QTR       2019        FY1920
700         100              2019-10-01 00:00:00     1           Tuesday                        10          October                        0           0           No          WK01       QTR       2019        FY1920
701         100              2019-10-02 00:00:00     2           Wednesday                      10          October                        0           0           No          WK01       QTR       2019        FY1920
702         100              2019-10-03 00:00:00     3           Thursday                       10          October                        0           0           No          WK01       QTR       2019        FY1920
703         100              2019-10-04 00:00:00     4           Friday                         10          October                        0           0           No          WK01       QTR       2019        FY1920
704         100              2019-10-05 00:00:00     5           Saturday                       10          October                        1           0           No          WK01       QTR       2019        FY1920
705         100              2019-10-06 00:00:00     6           Sunday                         10          October                        1           0           No          WK01       QTR       2019        FY1920
706         100              2019-10-07 00:00:00     7           Monday                         10          October                        0           0           No          WK01       QTR       2019        FY1920
707         100              2019-10-08 00:00:00     8           Tuesday                        10          October                        0           0           No          WK02       QTR       2019        FY1920
708         100              2019-10-09 00:00:00     9           Wednesday                      10          October                        0           0           No          WK02       QTR       2019        FY1920
709         100              2019-10-10 00:00:00     10          Thursday                       10          October                        0           0           No          WK02       QTR       2019        FY1920
710         100              2019-10-11 00:00:00     11          Friday                         10          October                        0           0           No          WK02       QTR       2019        FY1920
711         100              2019-10-12 00:00:00     12          Saturday                       10          October                        1           0           No          WK02       QTR       2019        FY1920
712         100              2019-10-13 00:00:00     13          Sunday                         10          October                        1           0           No          WK02       QTR       2019        FY1920
713         100              2019-10-14 00:00:00     14          Monday                         10          October                        0           0           No          WK02       QTR       2019        FY1920
714         100              2019-10-15 00:00:00     15          Tuesday                        10          October                        0           0           No          WK03       QTR       2019        FY1920
715         100              2019-10-16 00:00:00     16          Wednesday                      10          October                        0           0           No          WK03       QTR       2019        FY1920
716         100              2019-10-17 00:00:00     17          Thursday                       10          October                        0           0           No          WK03       QTR       2019        FY1920
717         100              2019-10-18 00:00:00     18          Friday                         10          October                        0           0           No          WK03       QTR       2019        FY1920
718         100              2019-10-19 00:00:00     19          Saturday                       10          October                        1           0           No          WK03       QTR       2019        FY1920
719         100              2019-10-20 00:00:00     20          Sunday                         10          October                        1           0           No          WK03       QTR       2019        FY1920
720         100              2019-10-21 00:00:00     21          Monday                         10          October                        0           0           No          WK03       QTR       2019        FY1920
721         100              2019-10-22 00:00:00     22          Tuesday                        10          October                        0           0           No          WK04       QTR       2019        FY1920
722         100              2019-10-23 00:00:00     23          Wednesday                      10          October                        0           0           No          WK04       QTR       2019        FY1920
723         100              2019-10-24 00:00:00     24          Thursday                       10          October                        0           0           No          WK04       QTR       2019        FY1920
724         100              2019-10-25 00:00:00     25          Friday                         10          October                        0           0           No          WK04       QTR       2019        FY1920
725         100              2019-10-26 00:00:00     26          Saturday                       10          October                        1           0           No          WK04       QTR       2019        FY1920
726         100              2019-10-27 00:00:00     27          Sunday                         10          October                        1           0           No          WK04       QTR       2019        FY1920
727         100              2019-10-28 00:00:00     28          Monday                         10          October                        0           0           No          WK04       QTR       2019        FY1920
728         100              2019-10-29 00:00:00     29          Tuesday                        10          October                        0           0           No          WK04       QTR       2019        FY1920
729         100              2019-10-30 00:00:00     30          Wednesday                      10          October                        0           0           No          WK04       QTR       2019        FY1920
730         100              2019-10-31 00:00:00     31          Thursday                       10          October                        0           0           No          WK         QTR       2019        FY1920
731         100              2019-11-01 00:00:00     1           Friday                         11          November                       0           0           No          WK01       QTR       2019        FY1920
732         100              2019-11-02 00:00:00     2           Saturday                       11          November                       1           0           No          WK01       QTR       2019        FY1920
733         100              2019-11-03 00:00:00     3           Sunday                         11          November                       1           0           No          WK01       QTR       2019        FY1920
734         100              2019-11-04 00:00:00     4           Monday                         11          November                       0           0           No          WK01       QTR       2019        FY1920
735         100              2019-11-05 00:00:00     5           Tuesday                        11          November                       0           0           No          WK01       QTR       2019        FY1920
736         100              2019-11-06 00:00:00     6           Wednesday                      11          November                       0           0           No          WK01       QTR       2019        FY1920
737         100              2019-11-07 00:00:00     7           Thursday                       11          November                       0           0           No          WK01       QTR       2019        FY1920
738         100              2019-11-08 00:00:00     8           Friday                         11          November                       0           0           No          WK02       QTR       2019        FY1920
739         100              2019-11-09 00:00:00     9           Saturday                       11          November                       1           0           No          WK02       QTR       2019        FY1920
740         100              2019-11-10 00:00:00     10          Sunday                         11          November                       1           0           No          WK02       QTR       2019        FY1920
741         100              2019-11-11 00:00:00     11          Monday                         11          November                       0           0           No          WK02       QTR       2019        FY1920
742         100              2019-11-12 00:00:00     12          Tuesday                        11          November                       0           0           No          WK02       QTR       2019        FY1920
743         100              2019-11-13 00:00:00     13          Wednesday                      11          November                       0           0           No          WK02       QTR       2019        FY1920
744         100              2019-11-14 00:00:00     14          Thursday                       11          November                       0           0           No          WK02       QTR       2019        FY1920
745         100              2019-11-15 00:00:00     15          Friday                         11          November                       0           0           No          WK03       QTR       2019        FY1920
746         100              2019-11-16 00:00:00     16          Saturday                       11          November                       1           0           No          WK03       QTR       2019        FY1920
747         100              2019-11-17 00:00:00     17          Sunday                         11          November                       1           0           No          WK03       QTR       2019        FY1920
748         100              2019-11-18 00:00:00     18          Monday                         11          November                       0           0           No          WK03       QTR       2019        FY1920
749         100              2019-11-19 00:00:00     19          Tuesday                        11          November                       0           0           No          WK03       QTR       2019        FY1920
750         100              2019-11-20 00:00:00     20          Wednesday                      11          November                       0           0           No          WK03       QTR       2019        FY1920
751         100              2019-11-21 00:00:00     21          Thursday                       11          November                       0           0           No          WK03       QTR       2019        FY1920
752         100              2019-11-22 00:00:00     22          Friday                         11          November                       0           0           No          WK04       QTR       2019        FY1920
753         100              2019-11-23 00:00:00     23          Saturday                       11          November                       1           0           No          WK04       QTR       2019        FY1920
754         100              2019-11-24 00:00:00     24          Sunday                         11          November                       1           0           No          WK04       QTR       2019        FY1920
755         100              2019-11-25 00:00:00     25          Monday                         11          November                       0           0           No          WK04       QTR       2019        FY1920
756         100              2019-11-26 00:00:00     26          Tuesday                        11          November                       0           0           No          WK04       QTR       2019        FY1920
757         100              2019-11-27 00:00:00     27          Wednesday                      11          November                       0           0           No          WK04       QTR       2019        FY1920
758         100              2019-11-28 00:00:00     28          Thursday                       11          November                       0           0           No          WK04       QTR       2019        FY1920
759         100              2019-11-29 00:00:00     29          Friday                         11          November                       0           0           No          WK04       QTR       2019        FY1920
760         100              2019-11-30 00:00:00     30          Saturday                       11          November                       1           0           No          WK04       QTR       2019        FY1920
761         100              2019-12-01 00:00:00     1           Sunday                         12          December                       1           0           No          WK01       QTR       2019        FY1920
762         100              2019-12-02 00:00:00     2           Monday                         12          December                       0           0           No          WK01       QTR       2019        FY1920
763         100              2019-12-03 00:00:00     3           Tuesday                        12          December                       0           0           No          WK01       QTR       2019        FY1920
764         100              2019-12-04 00:00:00     4           Wednesday                      12          December                       0           0           No          WK01       QTR       2019        FY1920
765         100              2019-12-05 00:00:00     5           Thursday                       12          December                       0           0           No          WK01       QTR       2019        FY1920
766         100              2019-12-06 00:00:00     6           Friday                         12          December                       0           0           No          WK01       QTR       2019        FY1920
767         100              2019-12-07 00:00:00     7           Saturday                       12          December                       1           0           No          WK01       QTR       2019        FY1920
768         100              2019-12-08 00:00:00     8           Sunday                         12          December                       1           0           No          WK02       QTR       2019        FY1920
769         100              2019-12-09 00:00:00     9           Monday                         12          December                       0           0           No          WK02       QTR       2019        FY1920
770         100              2019-12-10 00:00:00     10          Tuesday                        12          December                       0           0           No          WK02       QTR       2019        FY1920
771         100              2019-12-11 00:00:00     11          Wednesday                      12          December                       0           0           No          WK02       QTR       2019        FY1920
772         100              2019-12-12 00:00:00     12          Thursday                       12          December                       0           0           No          WK02       QTR       2019        FY1920
773         100              2019-12-13 00:00:00     13          Friday                         12          December                       0           0           No          WK02       QTR       2019        FY1920
774         100              2019-12-14 00:00:00     14          Saturday                       12          December                       1           0           No          WK02       QTR       2019        FY1920
775         100              2019-12-15 00:00:00     15          Sunday                         12          December                       1           0           No          WK03       QTR       2019        FY1920
776         100              2019-12-16 00:00:00     16          Monday                         12          December                       0           0           No          WK03       QTR       2019        FY1920
777         100              2019-12-17 00:00:00     17          Tuesday                        12          December                       0           0           No          WK03       QTR       2019        FY1920
778         100              2019-12-18 00:00:00     18          Wednesday                      12          December                       0           0           No          WK03       QTR       2019        FY1920
779         100              2019-12-19 00:00:00     19          Thursday                       12          December                       0           0           No          WK03       QTR       2019        FY1920
780         100              2019-12-20 00:00:00     20          Friday                         12          December                       0           0           No          WK03       QTR       2019        FY1920
781         100              2019-12-21 00:00:00     21          Saturday                       12          December                       1           0           No          WK03       QTR       2019        FY1920
782         100              2019-12-22 00:00:00     22          Sunday                         12          December                       1           0           No          WK04       QTR       2019        FY1920
783         100              2019-12-23 00:00:00     23          Monday                         12          December                       0           0           No          WK04       QTR       2019        FY1920
784         100              2019-12-24 00:00:00     24          Tuesday                        12          December                       0           0           No          WK04       QTR       2019        FY1920
785         100              2019-12-25 00:00:00     25          Wednesday                      12          December                       0           0           No          WK04       QTR       2019        FY1920
786         100              2019-12-26 00:00:00     26          Thursday                       12          December                       0           0           No          WK04       QTR       2019        FY1920
787         100              2019-12-27 00:00:00     27          Friday                         12          December                       0           0           No          WK04       QTR       2019        FY1920
788         100              2019-12-28 00:00:00     28          Saturday                       12          December                       1           0           No          WK04       QTR       2019        FY1920
789         100              2019-12-29 00:00:00     29          Sunday                         12          December                       1           0           No          WK04       QTR       2019        FY1920
790         100              2019-12-30 00:00:00     30          Monday                         12          December                       0           0           No          WK04       QTR       2019        FY1920
791         100              2019-12-31 00:00:00     31          Tuesday                        12          December                       0           0           No          WK         QTR       2019        FY1920
792         100              2020-01-01 00:00:00     1           Wednesday                      1           January                        0           0           No          WK01       QTR       2020        FY2021
793         100              2020-01-02 00:00:00     2           Thursday                       1           January                        0           0           No          WK01       QTR       2020        FY2021
794         100              2020-01-03 00:00:00     3           Friday                         1           January                        0           0           No          WK01       QTR       2020        FY2021
795         100              2020-01-04 00:00:00     4           Saturday                       1           January                        1           0           No          WK01       QTR       2020        FY2021
796         100              2020-01-05 00:00:00     5           Sunday                         1           January                        1           0           No          WK01       QTR       2020        FY2021
797         100              2020-01-06 00:00:00     6           Monday                         1           January                        0           0           No          WK01       QTR       2020        FY2021
798         100              2020-01-07 00:00:00     7           Tuesday                        1           January                        0           0           No          WK01       QTR       2020        FY2021
799         100              2020-01-08 00:00:00     8           Wednesday                      1           January                        0           0           No          WK02       QTR       2020        FY2021
800         100              2020-01-09 00:00:00     9           Thursday                       1           January                        0           0           No          WK02       QTR       2020        FY2021
801         100              2020-01-10 00:00:00     10          Friday                         1           January                        0           0           No          WK02       QTR       2020        FY2021
802         100              2020-01-11 00:00:00     11          Saturday                       1           January                        1           0           No          WK02       QTR       2020        FY2021
803         100              2020-01-12 00:00:00     12          Sunday                         1           January                        1           0           No          WK02       QTR       2020        FY2021
804         100              2020-01-13 00:00:00     13          Monday                         1           January                        0           0           No          WK02       QTR       2020        FY2021
805         100              2020-01-14 00:00:00     14          Tuesday                        1           January                        0           0           No          WK02       QTR       2020        FY2021
806         100              2020-01-15 00:00:00     15          Wednesday                      1           January                        0           0           No          WK03       QTR       2020        FY2021
807         100              2020-01-16 00:00:00     16          Thursday                       1           January                        0           0           No          WK03       QTR       2020        FY2021
808         100              2020-01-17 00:00:00     17          Friday                         1           January                        0           0           No          WK03       QTR       2020        FY2021
809         100              2020-01-18 00:00:00     18          Saturday                       1           January                        1           0           No          WK03       QTR       2020        FY2021
810         100              2020-01-19 00:00:00     19          Sunday                         1           January                        1           0           No          WK03       QTR       2020        FY2021
811         100              2020-01-20 00:00:00     20          Monday                         1           January                        0           0           No          WK03       QTR       2020        FY2021
812         100              2020-01-21 00:00:00     21          Tuesday                        1           January                        0           0           No          WK03       QTR       2020        FY2021
813         100              2020-01-22 00:00:00     22          Wednesday                      1           January                        0           0           No          WK04       QTR       2020        FY2021
814         100              2020-01-23 00:00:00     23          Thursday                       1           January                        0           0           No          WK04       QTR       2020        FY2021
815         100              2020-01-24 00:00:00     24          Friday                         1           January                        0           0           No          WK04       QTR       2020        FY2021
816         100              2020-01-25 00:00:00     25          Saturday                       1           January                        1           0           No          WK04       QTR       2020        FY2021
817         100              2020-01-26 00:00:00     26          Sunday                         1           January                        1           0           No          WK04       QTR       2020        FY2021
818         100              2020-01-27 00:00:00     27          Monday                         1           January                        0           0           No          WK04       QTR       2020        FY2021
819         100              2020-01-28 00:00:00     28          Tuesday                        1           January                        0           0           No          WK04       QTR       2020        FY2021
820         100              2020-01-29 00:00:00     29          Wednesday                      1           January                        0           0           No          WK04       QTR       2020        FY2021
821         100              2020-01-30 00:00:00     30          Thursday                       1           January                        0           0           No          WK04       QTR       2020        FY2021
822         100              2020-01-31 00:00:00     31          Friday                         1           January                        0           0           No          WK         QTR       2020        FY2021
823         100              2020-02-01 00:00:00     1           Saturday                       2           February                       1           0           No          WK01       QTR       2020        FY2021
824         100              2020-02-02 00:00:00     2           Sunday                         2           February                       1           0           No          WK01       QTR       2020        FY2021
825         100              2020-02-03 00:00:00     3           Monday                         2           February                       0           0           No          WK01       QTR       2020        FY2021
826         100              2020-02-04 00:00:00     4           Tuesday                        2           February                       0           0           No          WK01       QTR       2020        FY2021
827         100              2020-02-05 00:00:00     5           Wednesday                      2           February                       0           0           No          WK01       QTR       2020        FY2021
828         100              2020-02-06 00:00:00     6           Thursday                       2           February                       0           0           No          WK01       QTR       2020        FY2021
829         100              2020-02-07 00:00:00     7           Friday                         2           February                       0           0           No          WK01       QTR       2020        FY2021
830         100              2020-02-08 00:00:00     8           Saturday                       2           February                       1           0           No          WK02       QTR       2020        FY2021
831         100              2020-02-09 00:00:00     9           Sunday                         2           February                       1           0           No          WK02       QTR       2020        FY2021
832         100              2020-02-10 00:00:00     10          Monday                         2           February                       0           0           No          WK02       QTR       2020        FY2021
833         100              2020-02-11 00:00:00     11          Tuesday                        2           February                       0           0           No          WK02       QTR       2020        FY2021
834         100              2020-02-12 00:00:00     12          Wednesday                      2           February                       0           0           No          WK02       QTR       2020        FY2021
835         100              2020-02-13 00:00:00     13          Thursday                       2           February                       0           0           No          WK02       QTR       2020        FY2021
836         100              2020-02-14 00:00:00     14          Friday                         2           February                       0           0           No          WK02       QTR       2020        FY2021
837         100              2020-02-15 00:00:00     15          Saturday                       2           February                       1           0           No          WK03       QTR       2020        FY2021
838         100              2020-02-16 00:00:00     16          Sunday                         2           February                       1           0           No          WK03       QTR       2020        FY2021
839         100              2020-02-17 00:00:00     17          Monday                         2           February                       0           0           No          WK03       QTR       2020        FY2021
840         100              2020-02-18 00:00:00     18          Tuesday                        2           February                       0           0           No          WK03       QTR       2020        FY2021
841         100              2020-02-19 00:00:00     19          Wednesday                      2           February                       0           0           No          WK03       QTR       2020        FY2021
842         100              2020-02-20 00:00:00     20          Thursday                       2           February                       0           0           No          WK03       QTR       2020        FY2021
843         100              2020-02-21 00:00:00     21          Friday                         2           February                       0           0           No          WK03       QTR       2020        FY2021
844         100              2020-02-22 00:00:00     22          Saturday                       2           February                       1           0           No          WK04       QTR       2020        FY2021
845         100              2020-02-23 00:00:00     23          Sunday                         2           February                       1           0           No          WK04       QTR       2020        FY2021
846         100              2020-02-24 00:00:00     24          Monday                         2           February                       0           0           No          WK04       QTR       2020        FY2021
847         100              2020-02-25 00:00:00     25          Tuesday                        2           February                       0           0           No          WK04       QTR       2020        FY2021
848         100              2020-02-26 00:00:00     26          Wednesday                      2           February                       0           0           No          WK04       QTR       2020        FY2021
849         100              2020-02-27 00:00:00     27          Thursday                       2           February                       0           0           No          WK04       QTR       2020        FY2021
850         100              2020-02-28 00:00:00     28          Friday                         2           February                       0           0           No          WK04       QTR       2020        FY2021
851         100              2020-02-29 00:00:00     29          Saturday                       2           February                       1           0           No          WK04       QTR       2020        FY2021
852         100              2020-03-01 00:00:00     1           Sunday                         3           March                          1           0           No          WK01       QTR       2020        FY2021
853         100              2020-03-02 00:00:00     2           Monday                         3           March                          0           0           No          WK01       QTR       2020        FY2021
854         100              2020-03-03 00:00:00     3           Tuesday                        3           March                          0           0           No          WK01       QTR       2020        FY2021
855         100              2020-03-04 00:00:00     4           Wednesday                      3           March                          0           0           No          WK01       QTR       2020        FY2021
856         100              2020-03-05 00:00:00     5           Thursday                       3           March                          0           0           No          WK01       QTR       2020        FY2021
857         100              2020-03-06 00:00:00     6           Friday                         3           March                          0           0           No          WK01       QTR       2020        FY2021
858         100              2020-03-07 00:00:00     7           Saturday                       3           March                          1           0           No          WK01       QTR       2020        FY2021
859         100              2020-03-08 00:00:00     8           Sunday                         3           March                          1           0           No          WK02       QTR       2020        FY2021
860         100              2020-03-09 00:00:00     9           Monday                         3           March                          0           0           No          WK02       QTR       2020        FY2021
861         100              2020-03-10 00:00:00     10          Tuesday                        3           March                          0           0           No          WK02       QTR       2020        FY2021
862         100              2020-03-11 00:00:00     11          Wednesday                      3           March                          0           0           No          WK02       QTR       2020        FY2021
863         100              2020-03-12 00:00:00     12          Thursday                       3           March                          0           0           No          WK02       QTR       2020        FY2021
864         100              2020-03-13 00:00:00     13          Friday                         3           March                          0           0           No          WK02       QTR       2020        FY2021
865         100              2020-03-14 00:00:00     14          Saturday                       3           March                          1           0           No          WK02       QTR       2020        FY2021
866         100              2020-03-15 00:00:00     15          Sunday                         3           March                          1           0           No          WK03       QTR       2020        FY2021
867         100              2020-03-16 00:00:00     16          Monday                         3           March                          0           0           No          WK03       QTR       2020        FY2021
868         100              2020-03-17 00:00:00     17          Tuesday                        3           March                          0           0           No          WK03       QTR       2020        FY2021
869         100              2020-03-18 00:00:00     18          Wednesday                      3           March                          0           0           No          WK03       QTR       2020        FY2021
870         100              2020-03-19 00:00:00     19          Thursday                       3           March                          0           0           No          WK03       QTR       2020        FY2021
871         100              2020-03-20 00:00:00     20          Friday                         3           March                          0           0           No          WK03       QTR       2020        FY2021
872         100              2020-03-21 00:00:00     21          Saturday                       3           March                          1           0           No          WK03       QTR       2020        FY2021
873         100              2020-03-22 00:00:00     22          Sunday                         3           March                          1           0           No          WK04       QTR       2020        FY2021
874         100              2020-03-23 00:00:00     23          Monday                         3           March                          0           0           No          WK04       QTR       2020        FY2021
875         100              2020-03-24 00:00:00     24          Tuesday                        3           March                          0           0           No          WK04       QTR       2020        FY2021
876         100              2020-03-25 00:00:00     25          Wednesday                      3           March                          0           0           No          WK04       QTR       2020        FY2021
877         100              2020-03-26 00:00:00     26          Thursday                       3           March                          0           0           No          WK04       QTR       2020        FY2021
878         100              2020-03-27 00:00:00     27          Friday                         3           March                          0           0           No          WK04       QTR       2020        FY2021
879         100              2020-03-28 00:00:00     28          Saturday                       3           March                          1           0           No          WK04       QTR       2020        FY2021
880         100              2020-03-29 00:00:00     29          Sunday                         3           March                          1           0           No          WK04       QTR       2020        FY2021
881         100              2020-03-30 00:00:00     30          Monday                         3           March                          0           0           No          WK04       QTR       2020        FY2021
882         100              2020-03-31 00:00:00     31          Tuesday                        3           March                          0           0           No          WK         QTR       2020        FY2021
883         100              2020-04-01 00:00:00     1           Wednesday                      4           April                          0           0           No          WK01       QTR       2020        FY2021
884         100              2020-04-02 00:00:00     2           Thursday                       4           April                          0           0           No          WK01       QTR       2020        FY2021
885         100              2020-04-03 00:00:00     3           Friday                         4           April                          0           0           No          WK01       QTR       2020        FY2021
886         100              2020-04-04 00:00:00     4           Saturday                       4           April                          1           0           No          WK01       QTR       2020        FY2021
887         100              2020-04-05 00:00:00     5           Sunday                         4           April                          1           0           No          WK01       QTR       2020        FY2021
888         100              2020-04-06 00:00:00     6           Monday                         4           April                          0           0           No          WK01       QTR       2020        FY2021
889         100              2020-04-07 00:00:00     7           Tuesday                        4           April                          0           0           No          WK01       QTR       2020        FY2021
890         100              2020-04-08 00:00:00     8           Wednesday                      4           April                          0           0           No          WK02       QTR       2020        FY2021
891         100              2020-04-09 00:00:00     9           Thursday                       4           April                          0           0           No          WK02       QTR       2020        FY2021
892         100              2020-04-10 00:00:00     10          Friday                         4           April                          0           0           No          WK02       QTR       2020        FY2021
893         100              2020-04-11 00:00:00     11          Saturday                       4           April                          1           0           No          WK02       QTR       2020        FY2021
894         100              2020-04-12 00:00:00     12          Sunday                         4           April                          1           0           No          WK02       QTR       2020        FY2021
895         100              2020-04-13 00:00:00     13          Monday                         4           April                          0           0           No          WK02       QTR       2020        FY2021
896         100              2020-04-14 00:00:00     14          Tuesday                        4           April                          0           0           No          WK02       QTR       2020        FY2021
897         100              2020-04-15 00:00:00     15          Wednesday                      4           April                          0           0           No          WK03       QTR       2020        FY2021
898         100              2020-04-16 00:00:00     16          Thursday                       4           April                          0           0           No          WK03       QTR       2020        FY2021
899         100              2020-04-17 00:00:00     17          Friday                         4           April                          0           0           No          WK03       QTR       2020        FY2021
900         100              2020-04-18 00:00:00     18          Saturday                       4           April                          1           0           No          WK03       QTR       2020        FY2021
901         100              2020-04-19 00:00:00     19          Sunday                         4           April                          1           0           No          WK03       QTR       2020        FY2021
902         100              2020-04-20 00:00:00     20          Monday                         4           April                          0           0           No          WK03       QTR       2020        FY2021
903         100              2020-04-21 00:00:00     21          Tuesday                        4           April                          0           0           No          WK03       QTR       2020        FY2021
904         100              2020-04-22 00:00:00     22          Wednesday                      4           April                          0           0           No          WK04       QTR       2020        FY2021
905         100              2020-04-23 00:00:00     23          Thursday                       4           April                          0           0           No          WK04       QTR       2020        FY2021
906         100              2020-04-24 00:00:00     24          Friday                         4           April                          0           0           No          WK04       QTR       2020        FY2021
907         100              2020-04-25 00:00:00     25          Saturday                       4           April                          1           0           No          WK04       QTR       2020        FY2021
908         100              2020-04-26 00:00:00     26          Sunday                         4           April                          1           0           No          WK04       QTR       2020        FY2021
909         100              2020-04-27 00:00:00     27          Monday                         4           April                          0           0           No          WK04       QTR       2020        FY2021
910         100              2020-04-28 00:00:00     28          Tuesday                        4           April                          0           0           No          WK04       QTR       2020        FY2021
911         100              2020-04-29 00:00:00     29          Wednesday                      4           April                          0           0           No          WK04       QTR       2020        FY2021
912         100              2020-04-30 00:00:00     30          Thursday                       4           April                          0           0           No          WK04       QTR       2020        FY2021
913         100              2020-05-01 00:00:00     1           Friday                         5           May                            0           0           No          WK01       QTR       2020        FY2021
914         100              2020-05-02 00:00:00     2           Saturday                       5           May                            1           0           No          WK01       QTR       2020        FY2021
915         100              2020-05-03 00:00:00     3           Sunday                         5           May                            1           0           No          WK01       QTR       2020        FY2021
916         100              2020-05-04 00:00:00     4           Monday                         5           May                            0           0           No          WK01       QTR       2020        FY2021
917         100              2020-05-05 00:00:00     5           Tuesday                        5           May                            0           0           No          WK01       QTR       2020        FY2021
918         100              2020-05-06 00:00:00     6           Wednesday                      5           May                            0           0           No          WK01       QTR       2020        FY2021
919         100              2020-05-07 00:00:00     7           Thursday                       5           May                            0           0           No          WK01       QTR       2020        FY2021
920         100              2020-05-08 00:00:00     8           Friday                         5           May                            0           0           No          WK02       QTR       2020        FY2021
921         100              2020-05-09 00:00:00     9           Saturday                       5           May                            1           0           No          WK02       QTR       2020        FY2021
922         100              2020-05-10 00:00:00     10          Sunday                         5           May                            1           0           No          WK02       QTR       2020        FY2021
923         100              2020-05-11 00:00:00     11          Monday                         5           May                            0           0           No          WK02       QTR       2020        FY2021
924         100              2020-05-12 00:00:00     12          Tuesday                        5           May                            0           0           No          WK02       QTR       2020        FY2021
925         100              2020-05-13 00:00:00     13          Wednesday                      5           May                            0           0           No          WK02       QTR       2020        FY2021
926         100              2020-05-14 00:00:00     14          Thursday                       5           May                            0           0           No          WK02       QTR       2020        FY2021
927         100              2020-05-15 00:00:00     15          Friday                         5           May                            0           0           No          WK03       QTR       2020        FY2021
928         100              2020-05-16 00:00:00     16          Saturday                       5           May                            1           0           No          WK03       QTR       2020        FY2021
929         100              2020-05-17 00:00:00     17          Sunday                         5           May                            1           0           No          WK03       QTR       2020        FY2021
930         100              2020-05-18 00:00:00     18          Monday                         5           May                            0           0           No          WK03       QTR       2020        FY2021
931         100              2020-05-19 00:00:00     19          Tuesday                        5           May                            0           0           No          WK03       QTR       2020        FY2021
932         100              2020-05-20 00:00:00     20          Wednesday                      5           May                            0           0           No          WK03       QTR       2020        FY2021
933         100              2020-05-21 00:00:00     21          Thursday                       5           May                            0           0           No          WK03       QTR       2020        FY2021
934         100              2020-05-22 00:00:00     22          Friday                         5           May                            0           0           No          WK04       QTR       2020        FY2021
935         100              2020-05-23 00:00:00     23          Saturday                       5           May                            1           0           No          WK04       QTR       2020        FY2021
936         100              2020-05-24 00:00:00     24          Sunday                         5           May                            1           0           No          WK04       QTR       2020        FY2021
937         100              2020-05-25 00:00:00     25          Monday                         5           May                            0           0           No          WK04       QTR       2020        FY2021
938         100              2020-05-26 00:00:00     26          Tuesday                        5           May                            0           0           No          WK04       QTR       2020        FY2021
939         100              2020-05-27 00:00:00     27          Wednesday                      5           May                            0           0           No          WK04       QTR       2020        FY2021
940         100              2020-05-28 00:00:00     28          Thursday                       5           May                            0           0           No          WK04       QTR       2020        FY2021
941         100              2020-05-29 00:00:00     29          Friday                         5           May                            0           0           No          WK04       QTR       2020        FY2021
942         100              2020-05-30 00:00:00     30          Saturday                       5           May                            1           0           No          WK04       QTR       2020        FY2021
943         100              2020-05-31 00:00:00     31          Sunday                         5           May                            1           0           No          WK         QTR       2020        FY2021
944         100              2020-06-01 00:00:00     1           Monday                         6           June                           0           0           No          WK01       QTR       2020        FY2021
945         100              2020-06-02 00:00:00     2           Tuesday                        6           June                           0           0           No          WK01       QTR       2020        FY2021
946         100              2020-06-03 00:00:00     3           Wednesday                      6           June                           0           0           No          WK01       QTR       2020        FY2021
947         100              2020-06-04 00:00:00     4           Thursday                       6           June                           0           0           No          WK01       QTR       2020        FY2021
948         100              2020-06-05 00:00:00     5           Friday                         6           June                           0           0           No          WK01       QTR       2020        FY2021
949         100              2020-06-06 00:00:00     6           Saturday                       6           June                           1           0           No          WK01       QTR       2020        FY2021
950         100              2020-06-07 00:00:00     7           Sunday                         6           June                           1           0           No          WK01       QTR       2020        FY2021
951         100              2020-06-08 00:00:00     8           Monday                         6           June                           0           0           No          WK02       QTR       2020        FY2021
952         100              2020-06-09 00:00:00     9           Tuesday                        6           June                           0           0           No          WK02       QTR       2020        FY2021
953         100              2020-06-10 00:00:00     10          Wednesday                      6           June                           0           0           No          WK02       QTR       2020        FY2021
954         100              2020-06-11 00:00:00     11          Thursday                       6           June                           0           0           No          WK02       QTR       2020        FY2021
955         100              2020-06-12 00:00:00     12          Friday                         6           June                           0           0           No          WK02       QTR       2020        FY2021
956         100              2020-06-13 00:00:00     13          Saturday                       6           June                           1           0           No          WK02       QTR       2020        FY2021
957         100              2020-06-14 00:00:00     14          Sunday                         6           June                           1           0           No          WK02       QTR       2020        FY2021
958         100              2020-06-15 00:00:00     15          Monday                         6           June                           0           0           No          WK03       QTR       2020        FY2021
959         100              2020-06-16 00:00:00     16          Tuesday                        6           June                           0           0           No          WK03       QTR       2020        FY2021
960         100              2020-06-17 00:00:00     17          Wednesday                      6           June                           0           0           No          WK03       QTR       2020        FY2021
961         100              2020-06-18 00:00:00     18          Thursday                       6           June                           0           0           No          WK03       QTR       2020        FY2021
962         100              2020-06-19 00:00:00     19          Friday                         6           June                           0           0           No          WK03       QTR       2020        FY2021
963         100              2020-06-20 00:00:00     20          Saturday                       6           June                           1           0           No          WK03       QTR       2020        FY2021
964         100              2020-06-21 00:00:00     21          Sunday                         6           June                           1           0           No          WK03       QTR       2020        FY2021
965         100              2020-06-22 00:00:00     22          Monday                         6           June                           0           0           No          WK04       QTR       2020        FY2021
966         100              2020-06-23 00:00:00     23          Tuesday                        6           June                           0           0           No          WK04       QTR       2020        FY2021
967         100              2020-06-24 00:00:00     24          Wednesday                      6           June                           0           0           No          WK04       QTR       2020        FY2021
968         100              2020-06-25 00:00:00     25          Thursday                       6           June                           0           0           No          WK04       QTR       2020        FY2021
969         100              2020-06-26 00:00:00     26          Friday                         6           June                           0           0           No          WK04       QTR       2020        FY2021
970         100              2020-06-27 00:00:00     27          Saturday                       6           June                           1           0           No          WK04       QTR       2020        FY2021
971         100              2020-06-28 00:00:00     28          Sunday                         6           June                           1           0           No          WK04       QTR       2020        FY2021
972         100              2020-06-29 00:00:00     29          Monday                         6           June                           0           0           No          WK04       QTR       2020        FY2021
973         100              2020-06-30 00:00:00     30          Tuesday                        6           June                           0           0           No          WK04       QTR       2020        FY2021

(973 row(s) affected)

Open in new window

btw, as long as you don't use SQL Server 2005-, this is wrong:

FiscalDate - Smalldatetime - Ex: 11/24/2017

Open in new window


it must be

FiscalDate DATE NOT NULL

Open in new window


same for the other date suffixed columns.

And if it is a dimensional table, I strongly recommend Kimball's books.

And last, but not least: Your table defines fiscal values, but it does not correlate them with the normal date. FiscalDate <> NormalDate and there is no further date column for this. Even dimensional tables require correct naming schemes.
@ste5an
Below is working fine for me in SQL 2012+  so why to use Date type.
DECLARE @StartDate smalldatetime = '11/01/2017'
It's not about working, it's about data modelling, domain and naming. A column suffixed with Date having a data type other than DATE is semantically wrong.

It also has a time portion, which requires additional checks and more carful handling when used in queries.

And for more semantics: a fiscal year is something different than a fiscal calendar, like 4-4-5 or 12-30. The above one look like normal calendar dimensions for different fiscal years.
Avatar of Manju

ASKER

@Pawan - Week numbers are still wrong.

1. date 31 for any month - week number is missing
2. each week should only have a max of 7 days. your approach would give more than that. Logic should be to take sun as 1 to sat as 7 and make the week's accordingly.
3. fiscalyearpercalendar is still wrong. for ex: if fiscalstart is july. then fiscal year is from 1st July 2017 to 30th June 2018. Till this period, fiscalyearpercalendar should be FY1718 and for next cycle it should be FY1819 and so on.
4. because week's logic is incorrect, quarter also fails in numbering.
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Manju

ASKER

@Pawan - Qtr is not right as your query gives qtr number only for 1718. Nonetheless, I am handling this with Update query. Thanks for your help.