IPL data.xlsx

	B	C	D	E	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AE	AF	AG	AH	AI	AK	AL	AM	AN	AO	AP	AQ	AR	AW
1	Team	Team Code	Home Stadium	Stadium Code	Team 1	Team 2	Stadium	Day of the Week	Time	Day Time Team Stadium Combination	Day Time Team Combination	Reverse Day Time Team Combination	Stadium Team Combination	Team Combination	Stadium Revenue	Online Revenue	Total Revenue	Same Team, Same Stadium	1				Day of the week	Time	Stadium	Team 1	Team 2	Day Time Team Stadium Combination	Stadium Capacity	Fill Rate	Ticket Prices	Revenue from Stadium	Day of the week	Time	Team 1	Team 2	Day Time Team Combination	Viewership	Income/Viewership	Revenue from Online
2	CSK	1	Chepauk	1	6	4	6	1	2	64126	6412	4612	646	64	383766656	780822570	1164589226	1		Stadium	Matches	10	1	2	1	1	2	12121	79,351	80%	6511	413323489	1	2	1	2	1212	100045652	2.0	200091304
3	KKR	2	Eden	2	8	2	8	2	2	82228	8222	2822	828	82	436600164	499097422	935697586	1		1	5	4	1	2	1	1	3	13121	51,871	80%	5562	230805202	1	2	1	3	1312	146242424	5.0	731212120	Constraints
4	DC	3	Arun Jaitley	3	8	1	8	3	2	81328	8132	1832	818	81	316840306	498375180	815215486	0		2	6		1	2	1	1	4	14121	71,951	80%	5705	328384364	1	2	1	4	1412	251560553	3.0	754681659	Only 2 stadiums possible for a game
5	PBKS	4	Mullanpur	4	9	2	9	4	2	92429	9242	2942	929	92	141982751	657224532	799207283	1		3	9		1	2	1	1	5	15121	53,111	80%	5473	232541202	1	2	1	5	1512	283969881	5.0	1419849405	Only 2 games can happen between 2 teams, min 1 has to happen
6	RCB	5	Chinnaswamy	5	5	5	5	5	2	55525	5552	5552	555	55	0	0	0	0		4	7		1	2	1	1	6	16121	38,767	80%	5602	173738187	1	2	1	6	1612	261688942	2.0	523377884	Max 14 games
7	GT	6	Narendra Modi	6	10	2	10	6	1	1026110	10261	21061	10210	102	169050024	170041622	339091646	1		5	4		1	2	1	1	7	17121	45,363	80%	4521	164068898	1	2	1	7	1712	224182658	4.0	896730632	1 stadium can have max 7 matches
8	SRH	7	Rajiv Gandhi	7	2	1	2	6	2	21622	2162	1262	212	21	296085026	170737366	466822392	0		6	4		1	2	1	1	8	18121	79,801	80%	5802	370404322	1	2	1	8	1812	170339066	2.0	340678132	Teams Stadium Combination needs to be unique
9	RR	8	Sawai Man Singh	8	10	5	10	7	1	1057110	10571	51071	10510	105	102938714	661652485	764591199	1		7	8		1	2	1	1	9	19121	57,571	80%	6963	320693498	1	2	1	9	1912	275634072	5.0	1378170360	One Team can have consecutive games at the interval of min 2 days
10	MI	9	Wankhede	9	3	9	3	7	2	39723	3972	9372	393	39	179795700	1192714685	1372510385	1		8	10		1	2	1	1	10	110121	30,280	80%	7297	176762528	1	2	1	10	11012	86227044	3.0	258681132
11	LSG	10	Ekana	10	3	4	3	1	2	34123	3412	4312	343	34	153517252	514261362	667778614	0		9	7		1	2	2	2	1	21122	79,547	80%	7300	464554480	1	2	2	3	2312	231587619	3.0	694762857
12					9	5	9	2	2	95229	9522	5922	959	95	203740500	1064842216	1268582716	1		10	10		1	2	2	2	3	23122	75,071	80%	5861	351992905	1	2	2	4	2412	243648775	2.0	487297550
13	Obj Function				7	9	7	3	2	79327	7932	9732	797	79	280318856	588410866	868729722	0					1	2	2	2	4	24122	72,090	80%	6274	361834128	1	2	2	5	2512	236612453	3.0	709837359
14	56975424637				9	3	9	4	2	93429	9342	3942	939	93	179823091	832380180	1012203271	1		Stadium Teams Combination	Matches	4	1	2	2	2	5	25122	30,794	80%	5015	123545528	1	2	2	6	2612	235324736	5.0	1176623680
15					5	10	5	5	2	510525	51052	10552	5105	510	262753840	726332680	989086520	1		121	0		1	2	2	2	6	26122	59,031	80%	6179	291802039	1	2	2	7	2712	104974126	5.0	524870630
16					7	10	7	6	1	710617	71061	10761	7107	710	255173930	714358440	969532370	1		131	0		1	2	2	2	7	27122	59,572	80%	4661	222132074	1	2	2	8	2812	148184825	3.0	444554475
17					4	3	4	6	2	43624	4362	3462	434	43	356370722	972363628	1328734350	1		141	0		1	2	2	2	8	28122	76,015	80%	5301	322364412	1	2	2	9	2912	150955086	2.0	301910172
18					9	3	9	7	1	93719	9371	3971	939	93	131588928	335282826	466871754	0		151	1		1	2	2	2	9	29122	40,156	80%	5368	172445926	1	2	2	10	21012	115650769	4.0	462603076
19					5	9	5	7	2	59725	5972	9572	595	59	179811612	854834384	1034645996	1		161	0		1	2	2	2	10	210122	39,301	80%	7110	223544088	1	2	3	4	3412	171420454	3.0	514261362
20					3	4	3	1	2	34123	3412	4312	343	34	153517252	514261362	667778614	1		171	1		1	2	3	3	1	31123	36,379	80%	7795	226859444	1	2	3	5	3512	132179737	5.0	660898685
21					4	9	4	2	2	49224	4922	9422	494	49	149207386	1148705056	1297912442	1		181	0		1	2	3	3	2	32123	30,732	80%	5507	135392899	1	2	3	6	3612	266404548	5.0	1332022740
22					7	9	7	3	2	79327	7932	9732	797	79	280318856	588410866	868729722	0		191	0		1	2	3	3	4	34123	43,445	80%	4417	153517252	1	2	3	7	3712	179943219	4.0	719772876
23					2	1	2	4	2	21422	2142	1242	212	21	166695360	561035660	727731020	0		1101	1		1	2	3	3	5	35123	37,694	80%	7422	223811894	1	2	3	8	3812	212086190	5.0	1060430950
24					3	5	3	5	2	35523	3552	5352	353	35	184088464	1063107132	1247195596	1		212	2		1	2	3	3	6	36123	56,638	80%	7128	322972531	1	2	3	9	3912	220719326	3.0	662157978
25					5	3	5	6	1	53615	5361	3561	535	53	349126263	479232022	828358285	0		232	1		1	2	3	3	7	37123	48,160	80%	5908	227623424	1	2	3	10	31012	196566595	4.0	786266380
26					8	5	8	6	2	85628	8562	5862	858	85	234022342	713318972	947341314	0		242	1		1	2	3	3	8	38123	43,918	80%	4928	173142323	1	2	4	5	4512	225398156	5.0	1126990780
27					4	10	4	7	1	410714	41071	10471	4104	410	251989338	415554900	667544238	1		252	0		1	2	3	3	9	39123	54,080	80%	6626	286667264	1	2	4	6	4612	156164514	5.0	780822570
28					10	3	10	7	2	1037210	10372	31072	10310	103	179001642	499847748	678849390	1		262	0		1	2	3	3	10	310123	38,006	80%	5422	164854826	1	2	4	7	4712	221229560	5.0	1106147800
29					10	4	10	1	2	1041210	10412	41012	10410	104	226195200	418986450	645181650	0		272	0		1	2	4	4	1	41124	79,871	80%	7971	509321393	1	2	4	8	4812	286484438	5.0	1432422190
30					2	10	2	2	2	210222	21022	10222	2102	210	265724624	764272647	1029997271	0		282	0		1	2	4	4	2	42124	69,599	80%	4870	271157704	1	2	4	9	4912	87760574	2.0	175521148
31					7	3	7	3	2	73327	7332	3732	737	73	211559321	515095028	726654349	0		292	0		1	2	4	4	3	43124	67,194	80%	4984	267915917	1	2	4	10	41012	209493225	2.0	418986450
32					1	1	1	4	2	11421	1142	1142	111	11	0	0	0	1		2102	1		1	2	4	4	5	45124	59,898	80%	4696	225024806	1	2	5	6	5612	297200460	3.0	891601380
33					8	2	8	5	2	82528	8252	2852	828	82	256349304	744046805	1000396109	1		313	0		1	2	4	4	6	46124	65,991	80%	4450	234927960	1	2	5	7	5712	271464572	5.0	1357322860
34					1	1	1	6	1	11611	1161	1161	111	11	0	0	0	0		323	0		1	2	4	4	7	47124	74,142	80%	7483	443843669	1	2	5	8	5812	148026221	4.0	592104884
35					2	2	2	6	2	22622	2262	2262	222	22	0	0	0	0		343	2		1	2	4	4	8	48124	38,213	80%	5576	170460550	1	2	5	9	5912	160585598	3.0	481756794
36					7	10	7	7	1	710717	71071	10771	7107	710	291767414	776498157	1068265571	0		353	1		1	2	4	4	9	49124	54,579	80%	5930	258922776	1	2	5	10	51012	210006680	4.0	840026720
37					9	6	9	7	2	96729	9672	6972	969	96	211821574	1073113636	1284935210	1		363	0		1	2	4	4	10	410124	50,667	80%	5898	239067173	1	2	6	7	6712	124155464	3.0	372466392
38					8	4	8	1	2	84128	8412	4812	848	84	276630765	1432422190	1709052955	1		373	1		1	2	5	5	1	51125	46,649	80%	6803	253882518	1	2	6	8	6812	93240714	5.0	466203570
39					4	6	4	2	2	46224	4622	6422	464	46	386826214	452145840	838972054	1		383	0		1	2	5	5	2	52125	53,911	80%	6509	280725359	1	2	6	9	6912	270320147	2.0	540640294
40					8	5	8	3	2	85328	8532	5832	858	85	160412772	745112457	905525229	1		393	2		1	2	5	5	3	53125	34,480	80%	4994	137754496	1	2	6	10	61012	273801562	2.0	547603124
41					1	5	1	4	2	15421	1542	5142	151	15	162532008	413411562	575943570	0		3103	2		1	2	5	5	4	54125	71,940	80%	6539	376332528	1	2	7	8	7812	257091366	3.0	771274098
42					6	8	6	5	2	68526	6852	8652	686	68	225655241	513410601	739065842	1		414	1		1	2	5	5	6	56125	66,433	80%	6531	347099138	1	2	7	9	7912	156756107	5.0	783780535
43					3	3	3	6	1	33613	3361	3361	333	33	0	0	0	0		424	0		1	2	5	5	7	57125	73,691	80%	7241	426877225	1	2	7	10	71012	223679318	3.0	671037954
44					6	6	6	6	2	66626	6662	6662	666	66	0	0	0	1		434	1		1	2	5	5	8	58125	55,149	80%	6921	305348983	1	2	8	9	8912	225638710	4.0	902554840
45					8	7	8	7	1	87718	8771	7871	878	87	403579493	585115448	988694941	1		454	1		1	2	5	5	9	59125	37,932	80%	6816	206835610	1	2	8	10	81012	117759318	5.0	588796590
46					3	7	3	7	2	37723	3772	7372	373	37	189164030	944192492	1133356522	1		464	2		1	2	5	5	10	510125	73,690	80%	7494	441786288	1	2	9	10	91012	253093704	3.0	759281112
47					3	10	3	1	2	310123	31012	10312	3103	310	164854826	786266380	951121206	0		474	0		1	2	6	6	1	61126	37,607	80%	6353	191133817	2	2	1	2	1222	298879944	3.0	896639832
48					9	5	9	2	2	95229	9522	5922	959	95	203740500	1064842216	1268582716	0		484	0		1	2	6	6	2	62126	46,074	80%	6846	252338083	2	2	1	3	1322	227509171	4.0	910036684
49					7	6	7	3	2	76327	7632	6732	767	76	174398947	965847345	1140246292	0		494	1		1	2	6	6	3	63126	41,809	80%	6519	218042297	2	2	1	4	1422	298588891	5.0	1492944455
50					2	4	2	4	2	24422	2442	4242	242	24	323722989	717136974	1040859963	0		4104	1		1	2	6	6	4	64126	65,894	80%	7280	383766656	2	2	1	5	1522	90706808	3.0	272120424
51					8	5	8	5	2	85528	8552	5852	858	85	395174707	824577192	1219751899	1		515	0		1	2	6	6	5	65126	48,451	80%	7031	272527185	2	2	1	6	1622	111800742	4.0	447202968
52					10	8	10	6	1	1086110	10861	81061	10810	108	213698680	830825118	1044523798	0		525	0		1	2	6	6	7	67126	66,303	80%	4178	221611147	2	2	1	7	1722	297998844	3.0	893996532
53					4	5	4	6	2	45624	4562	5462	454	45	146783614	412034691	558818305	0		535	1		1	2	6	6	8	68126	51,457	80%	4245	174747972	2	2	1	8	1822	257745236	3.0	773235708
54					1	10	1	7	1	110711	11071	10171	1101	110	146046195	241557162	387603357	1		545	0		1	2	6	6	9	69126	51,334	80%	7299	299749493	2	2	1	9	1922	280232257	4.0	1120929028
55					3	9	3	7	2	39723	3972	9372	393	39	179795700	1192714685	1372510385	0		565	0		1	2	6	6	10	610126	58,285	80%	4100	191174800	2	2	1	10	11022	202609196	2.0	405218392
56					1	7	1	1	2	17121	1712	7112	171	17	164068898	896730632	1060799530	0		575	0		1	2	7	7	1	71127	71,405	80%	6947	396840428	2	2	2	3	2322	157240502	5.0	786202510
57					10	1	10	2	2	1012210	10122	11022	10110	101	132286355	405218392	537504747	1		585	0		1	2	7	7	2	72127	36,898	80%	4856	143341350	2	2	2	4	2422	268064322	3.0	804192966
58					8	9	8	3	2	89328	8932	9832	898	89	133613594	860895064	994508658	0		595	1		1	2	7	7	3	73127	54,038	80%	6434	278144394	2	2	2	5	2522	81921084	3.0	245763252
59					4	1	4	4	2	41424	4142	1442	414	41	348422280	672374144	1020796424	1		5105	1		1	2	7	7	4	74127	50,259	80%	6622	266252078	2	2	2	6	2622	233987871	4.0	935951484
60					6	2	6	5	2	62526	6252	2652	626	62	345807554	287627642	633435196	0		616	0		1	2	7	7	5	75127	31,904	80%	7631	194767539	2	2	2	7	2722	172710088	5.0	863550440
61					10	1	10	6	1	1016110	10161	11061	10110	101	409742285	749746496	1159488781	1		626	1		1	2	7	7	6	76127	66,808	80%	5247	280433261	2	2	2	8	2822	249548711	2.0	499097422
62					7	5	7	6	2	75627	7562	5762	757	75	167324330	731573695	898898025	0		636	0		1	2	7	7	8	78127	38,617	80%	7315	225986684	2	2	2	9	2922	169589455	3.0	508768365
63					9	1	9	7	1	91719	9171	1971	919	91	221730862	399537840	621268702	1		646	1		1	2	7	7	9	79127	35,518	80%	4618	131217699	2	2	2	10	21022	254757549	3.0	764272647
64					3	10	3	7	2	310723	31072	10372	3103	310	319003267	499847748	818851015	0		656	0		1	2	7	7	10	710127	67,410	80%	5821	313914888	2	2	3	4	3422	117725137	4.0	470900548
65					10	1	10	1	2	1011210	10112	11012	10110	101	207689082	258681132	466370214	0		676	0		1	2	8	8	1	81128	62,072	80%	4428	219883853	2	2	3	5	3522	132377417	5.0	661887085
66					8	5	8	2	2	85228	8522	5822	858	85	149482195	347872380	497354575	0		686	1		1	2	8	8	2	82128	55,426	80%	6070	269148656	2	2	3	6	3622	260314708	2.0	520629416
67					4	6	4	3	2	46324	4632	6432	464	46	166257264	667250073	833507337	0		696	0		1	2	8	8	3	83128	63,616	80%	5114	260265779	2	2	3	7	3722	112712914	3.0	338138742
68					10	10	10	4	2	10104210	101042	101042	101010	1010	0	0	0	1		6106	0		1	2	8	8	4	84128	77,323	80%	4472	276630765	2	2	3	8	3822	249961784	4.0	999847136
69					2	3	2	5	2	23522	2352	3252	232	23	286727510	491520920	778248430	1		717	1		1	2	8	8	5	85128	34,637	80%	6388	177008925	2	2	3	9	3922	209630132	3.0	628890396
70					10	1	10	6	1	1016110	10161	11061	10110	101	409742285	749746496	1159488781			727	0		1	2	8	8	6	86128	59,582	80%	7230	344622288	2	2	3	10	31022	274249812	2.0	548499624
71					7	1	7	6	2	71627	7162	1762	717	71	153102182	516411710	669513892			737	1		1	2	8	8	7	87128	40,370	80%	4083	131864568	2	2	4	5	4522	255134899	3.0	765404697
72												0000								747	0		1	2	8	8	9	89128	66,672	80%	4655	248286528	2	2	4	6	4622	90429168	5.0	452145840
73												0000								757	1		1	2	8	8	10	810128	77,911	80%	4319	269198087	2	2	4	7	4722	93127144	5.0	465635720
74												0000								767	1		1	2	9	9	1	91129	55,811	80%	5432	242532282	2	2	4	8	4822	110569632	2.0	221139264
75												0000								787	0		1	2	9	9	2	92129	71,191	80%	7059	402029815	2	2	4	9	4922	287176264	4.0	1148705056
76												0000								797	2		1	2	9	9	3	93129	73,079	80%	7650	447243480	2	2	4	10	41022	109678821	3.0	329036463
77												0000								7107	2		1	2	9	9	4	94129	46,996	80%	5748	216106406	2	2	5	6	5622	209202253	5.0	1046011265
78												0000								818	1		1	2	9	9	5	95129	46,719	80%	7626	285023275	2	2	5	7	5722	144948547	4.0	579794188
79												0000								828	2		1	2	9	9	6	96129	35,415	80%	6329	179313228	2	2	5	8	5822	115957460	3.0	347872380
80												0000								838	0		1	2	9	9	7	97129	30,614	80%	4224	103450829	2	2	5	9	5922	266210554	4.0	1064842216
81												0000								848	1		1	2	9	9	8	98129	35,636	80%	4270	121732576	2	2	5	10	51022	299260480	5.0	1496302400
82												0000								858	4		1	2	9	9	10	910129	79,868	80%	7422	474224237	2	2	6	7	6722	168589360	4.0	674357440
83												0000								868	0		1	2	10	10	1	1011210	49,582	80%	5236	207689082	2	2	6	8	6822	119291963	4.0	477167852
84												0000								878	1		1	2	10	10	2	1021210	65,158	80%	5606	292220598	2	2	6	9	6922	285853145	3.0	857559435
85												0000								898	1		1	2	10	10	3	1031210	59,522	80%	6625	315466600	2	2	6	10	61022	116007450	5.0	580037250
86												0000								8108	0		1	2	10	10	4	1041210	70,125	80%	4032	226195200	2	2	7	8	7822	241479929	4.0	965919716
87												0000								919	1		1	2	10	10	5	1051210	73,730	80%	7033	414834472	2	2	7	9	7922	131744826	4.0	526979304
88												0000								929	1		1	2	10	10	6	1061210	55,926	80%	5709	255425227	2	2	7	10	71022	96092964	5.0	480464820
89												0000								939	2		1	2	10	10	7	1071210	53,584	80%	4051	173655027	2	2	8	9	8922	178901296	4.0	715605184
90												0000								949	0		1	2	10	10	8	1081210	44,443	80%	5570	198038008	2	2	8	10	81022	283780303	5.0	1418901515
91												0000								959	2		1	2	10	10	9	1091210	41,086	80%	7657	251676402	2	2	9	10	91022	95964411	5.0	479822055
92												0000								969	1		2	2	1	1	2	12221	65,585	80%	7292	382596656	3	2	1	2	1232	117208789	4.0	468835156
93												0000								979	0		2	2	1	1	3	13221	56,620	80%	4783	216650768	3	2	1	3	1332	240173244	3.0	720519732
94												0000								989	0		2	2	1	1	4	14221	58,444	80%	4876	227978355	3	2	1	4	1432	258521458	4.0	1034085832
95												0000								9109	0		2	2	1	1	5	15221	78,983	80%	5384	340195578	3	2	1	5	1532	125443484	2.0	250886968
96												0000								10110	4		2	2	1	1	6	16221	55,573	80%	6028	267995235	3	2	1	6	1632	153910668	4.0	615642672
97												0000								10210	1		2	2	1	1	7	17221	74,292	80%	7993	475052765	3	2	1	7	1732	111063060	5.0	555315300
98												0000								10310	1		2	2	1	1	8	18221	38,618	80%	4463	137881707	3	2	1	8	1832	166125060	3.0	498375180
99												0000								10410	1		2	2	1	1	9	19221	44,111	80%	6902	243563298	3	2	1	9	1932	121798657	4.0	487194628
100												0000								10510	1		2	2	1	1	10	110221	45,112	80%	6776	244543130	3	2	1	10	11032	247771533	2.0	495543066