DATA 5000 INCOME 8200.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Date	Year	Month	Bank	Flag	Branch Code	Branch Name	Product Code	CMO Mode	Cases Daily	Daily Premium	Annualized Premium	Cancelled Premium	Cancelled Cases	Premium NOC	Cases NOC
2	01/15/2020	2020	Jan	B	Conventional	45367	DEF	1B	A	1	40000	40000	0	0	40000	1
3	01/15/2020	2020	Jan	A	Takaful	47013	DEF	1B	A	1	100000	100000	0	0	100000	1
4	01/15/2020	2020	Jan	B	Takaful	38392	ABC	1A	A	1	30000	30000	0	0	30000	1
5	01/15/2020	2020	Jan	B	Conventional	75910	ABC	1B	A	1	20000	20000	0	0	20000	1
6	01/15/2020	2020	Jan	C	Takaful	1071	DEF	1B	A	1	100000	100000	0	0	100000	1
7	01/15/2020	2020	Jan	B	Conventional	61835	ABC	1B	A	1	50000	50000	0	0	50000	1
8	01/15/2020	2020	Jan	C	Takaful	26956	DEF	1A	A	1	40000	40000	0	0	40000	1
9	01/15/2020	2020	Jan	B	Conventional	78193	ABC	1A	A	1	40000	40000	0	0	40000	1
10	01/15/2020	2020	Jan	C	Conventional	82993	DEF	1B	A	1	25000	25000	0	0	25000	1
11	01/15/2020	2020	Jan	C	Conventional	12637	DEF	1B	A	1	100000	100000	0	0	100000	1
12	01/15/2020	2020	Jan	A	Takaful	5659	DEF	1A	A	1	50000	50000	0	0	50000	1
13	01/15/2020	2020	Jan	C	Takaful	64675	DEF	1A	A	1	40000	40000	0	0	40000	1
14	01/15/2020	2020	Jan	C	Conventional	64016	DEF	1B	A	1	40000	40000	0	0	40000	1
15	01/15/2020	2020	Jan	A	Conventional	72819	ABC	1B	A	1	25000	25000	0	0	25000	1
16	01/15/2020	2020	Jan	C	Conventional	3977	ABC	1A	A	1	40000	40000	0	0	40000	1
17	01/15/2020	2020	Jan	C	Takaful	32529	DEF	1B	A	1	25000	25000	0	0	25000	1
18	01/15/2020	2020	Jan	C	Conventional	73645	ABC	1B	A	1	50000	50000	0	0	50000	1
19	01/15/2020	2020	Jan	B	Conventional	18576	ABC	1A	A	1	40000	40000	0	0	40000	1
20	01/15/2020	2020	Jan	A	Conventional	12651	DEF	1B	A	1	25000	25000	0	0	25000	1
21	01/15/2020	2020	Jan	B	Takaful	99380	ABC	1B	A	1	25000	25000	0	0	25000	1
22	01/15/2020	2020	Jan	C	Conventional	96507	ABC	1A	A	1	40000	40000	0	0	40000	1
23	01/15/2020	2020	Jan	A	Takaful	25306	ABC	1A	A	1	20000	20000	0	0	20000	1
24	01/15/2020	2020	Jan	B	Conventional	41032	ABC	1A	A	1	20000	20000	0	0	20000	1
25	01/15/2020	2020	Jan	C	Conventional	52468	DEF	1B	A	1	40000	40000	0	0	40000	1
26	01/15/2020	2020	Jan	C	Conventional	99417	ABC	1A	A	1	25000	25000	0	0	25000	1
27	01/15/2020	2020	Jan	B	Conventional	28999	ABC	1B	A	1	25000	25000	0	0	25000	1
28	01/15/2020	2020	Jan	B	Takaful	52683	ABC	1A	A	1	25000	25000	0	0	25000	1
29	01/15/2020	2020	Jan	C	Conventional	27862	ABC	1B	A	1	25000	25000	0	0	25000	1
30	01/15/2020	2020	Jan	B	Conventional	3475	DEF	1A	A	1	30000	30000	0	0	30000	1
31	01/15/2020	2020	Jan	C	Takaful	74264	DEF	1B	A	1	30000	30000	0	0	30000	1
32	01/15/2020	2020	Jan	C	Conventional	76226	ABC	1B	A	1	30000	30000	0	0	30000	1
33	01/15/2020	2020	Jan	A	Conventional	82780	DEF	1A	A	1	40000	40000	0	0	40000	1
34	01/15/2020	2020	Jan	A	Takaful	13398	DEF	1A	A	1	50000	50000	0	0	50000	1
35	01/15/2020	2020	Jan	B	Conventional	74379	ABC	1A	A	1	50000	50000	0	0	50000	1
36	01/15/2020	2020	Jan	A	Conventional	27624	ABC	1A	A	1	40000	40000	0	0	40000	1
37	01/15/2020	2020	Jan	B	Takaful	16656	DEF	1A	A	1	50000	50000	0	0	50000	1
38	01/15/2020	2020	Jan	B	Conventional	76341	DEF	1A	A	1	40000	40000	0	0	40000	1
39	01/15/2020	2020	Jan	A	Conventional	95526	DEF	1B	A	1	100000	100000	0	0	100000	1
40	01/15/2020	2020	Jan	B	Takaful	79628	ABC	1B	A	1	20000	20000	0	0	20000	1
41	01/15/2020	2020	Jan	B	Takaful	63207	DEF	1A	A	1	40000	40000	0	0	40000	1
42	01/15/2020	2020	Jan	A	Takaful	52722	ABC	1B	A	1	100000	100000	0	0	100000	1
43	01/15/2020	2020	Jan	C	Takaful	58683	ABC	1B	A	1	50000	50000	0	0	50000	1
44	01/15/2020	2020	Jan	B	Conventional	44778	DEF	1B	A	1	40000	40000	0	0	40000	1
45	01/15/2020	2020	Jan	C	Conventional	21804	DEF	1A	A	1	100000	100000	0	0	100000	1
46	01/15/2020	2020	Jan	B	Takaful	67831	ABC	1B	A	1	100000	100000	0	0	100000	1
47	01/15/2020	2020	Jan	C	Conventional	98895	ABC	1A	A	1	100000	100000	0	0	100000	1
48	01/15/2020	2020	Jan	B	Takaful	24007	DEF	1A	A	1	20000	20000	0	0	20000	1
49	01/15/2020	2020	Jan	A	Conventional	3756	DEF	1B	A	1	100000	100000	0	0	100000	1
50	01/15/2020	2020	Jan	A	Takaful	35166	ABC	1B	A	1	100000	100000	0	0	100000	1
51	01/15/2020	2020	Jan	B	Takaful	74118	ABC	1A	A	1	30000	30000	0	0	30000	1
52	01/15/2020	2020	Jan	A	Conventional	27669	ABC	1A	A	1	25000	25000	0	0	25000	1
53	01/15/2020	2020	Jan	B	Conventional	93506	DEF	1B	A	1	25000	25000	0	0	25000	1
54	01/15/2020	2020	Jan	B	Takaful	55445	DEF	1B	A	1	100000	100000	0	0	100000	1
55	01/15/2020	2020	Jan	C	Takaful	2733	ABC	1B	A	1	40000	40000	0	0	40000	1
56	01/15/2020	2020	Jan	A	Takaful	94525	DEF	1A	A	1	100000	100000	0	0	100000	1
57	01/15/2020	2020	Jan	A	Takaful	84283	ABC	1A	A	1	30000	30000	0	0	30000	1
58	01/15/2020	2020	Jan	A	Takaful	41925	ABC	1B	A	1	40000	40000	0	0	40000	1
59	01/15/2020	2020	Jan	C	Takaful	37059	DEF	1A	A	1	100000	100000	0	0	100000	1
60	01/15/2020	2020	Jan	C	Takaful	4150	DEF	1B	A	1	100000	100000	0	0	100000	1
61	01/15/2020	2020	Jan	B	Conventional	23218	ABC	1A	A	1	100000	100000	0	0	100000	1
62	01/15/2020	2020	Jan	B	Takaful	94964	DEF	1A	A	1	30000	30000	0	0	30000	1
63	01/15/2020	2020	Jan	B	Takaful	37219	ABC	1A	A	1	25000	25000	0	0	25000	1
64	01/15/2020	2020	Jan	C	Conventional	28317	ABC	1B	A	1	50000	50000	0	0	50000	1
65	01/15/2020	2020	Jan	C	Conventional	52110	ABC	1A	A	1	30000	30000	0	0	30000	1
66	01/15/2020	2020	Jan	C	Takaful	18125	DEF	1A	A	1	20000	20000	0	0	20000	1
67	01/15/2020	2020	Jan	B	Conventional	50064	DEF	1B	A	1	100000	100000	0	0	100000	1
68	01/15/2020	2020	Jan	B	Conventional	15460	ABC	1A	A	1	40000	40000	0	0	40000	1
69	01/15/2020	2020	Jan	C	Takaful	86577	ABC	1A	A	1	40000	40000	0	0	40000	1
70	01/15/2020	2020	Jan	A	Takaful	69218	ABC	1B	A	1	30000	30000	0	0	30000	1
71	01/15/2020	2020	Jan	C	Takaful	3582	ABC	1A	A	1	20000	20000	0	0	20000	1
72	01/15/2020	2020	Jan	C	Takaful	96338	DEF	1B	A	1	25000	25000	0	0	25000	1
73	01/15/2020	2020	Jan	B	Conventional	97762	DEF	1B	A	1	20000	20000	0	0	20000	1
74	01/15/2020	2020	Jan	B	Takaful	54268	DEF	1A	A	1	40000	40000	0	0	40000	1
75	01/15/2020	2020	Jan	C	Takaful	2819	DEF	1B	A	1	30000	30000	0	0	30000	1
76	01/15/2020	2020	Jan	C	Takaful	66436	ABC	1B	A	1	25000	25000	0	0	25000	1
77	01/15/2020	2020	Jan	C	Takaful	88581	ABC	1A	A	1	20000	20000	0	0	20000	1
78	01/15/2020	2020	Jan	B	Conventional	53831	DEF	1B	A	1	25000	25000	0	0	25000	1
79	01/15/2020	2020	Jan	B	Takaful	97054	ABC	1A	A	1	30000	30000	0	0	30000	1
80	01/15/2020	2020	Jan	C	Takaful	65576	DEF	1B	A	1	50000	50000	0	0	50000	1
81	01/15/2020	2020	Jan	A	Conventional	20898	ABC	1A	A	1	40000	40000	0	0	40000	1
82	01/15/2020	2020	Jan	A	Conventional	72498	ABC	1A	A	1	25000	25000	0	0	25000	1
83	01/15/2020	2020	Jan	C	Conventional	18431	ABC	1A	A	1	25000	25000	0	0	25000	1
84	01/15/2020	2020	Jan	A	Takaful	80859	DEF	1B	A	1	30000	30000	0	0	30000	1
85	01/15/2020	2020	Jan	C	Takaful	96208	ABC	1A	A	1	20000	20000	0	0	20000	1
86	01/15/2020	2020	Jan	B	Conventional	42339	DEF	1B	A	1	100000	100000	0	0	100000	1
87	01/15/2020	2020	Jan	C	Conventional	87666	DEF	1A	A	1	20000	20000	0	0	20000	1
88	01/15/2020	2020	Jan	A	Takaful	67532	DEF	1A	A	1	50000	50000	0	0	50000	1
89	01/15/2020	2020	Jan	B	Takaful	99314	DEF	1A	A	1	50000	50000	0	0	50000	1
90	01/15/2020	2020	Jan	B	Conventional	19472	ABC	1A	A	1	50000	50000	0	0	50000	1
91	01/15/2020	2020	Jan	A	Takaful	85716	DEF	1B	A	1	25000	25000	0	0	25000	1
92	01/15/2020	2020	Jan	B	Takaful	40929	ABC	1B	A	1	40000	40000	0	0	40000	1
93	01/15/2020	2020	Jan	C	Takaful	92303	DEF	1B	A	1	50000	50000	0	0	50000	1
94	01/15/2020	2020	Jan	B	Conventional	22489	ABC	1B	A	1	50000	50000	0	0	50000	1
95	01/15/2020	2020	Jan	A	Takaful	85663	DEF	1A	A	1	40000	40000	0	0	40000	1
96	01/15/2020	2020	Jan	B	Conventional	27288	DEF	1B	A	1	25000	25000	0	0	25000	1
97	01/15/2020	2020	Jan	A	Conventional	39653	DEF	1B	A	1	30000	30000	0	0	30000	1
98	01/15/2020	2020	Jan	A	Conventional	14463	DEF	1B	A	1	30000	30000	0	0	30000	1
99	01/15/2020	2020	Jan	C	Takaful	98730	ABC	1A	A	1	100000	100000	0	0	100000	1
100	01/15/2020	2020	Jan	B	Takaful	64037	ABC	1A	A	1	30000	30000	0	0	30000	1