IPL 2018 Prediction Contest

Dt : 04 April 2018.

Its IPL season and a lot of fantasy games have started surfacing.However each of these games require you to predict every day to get you a realistic chance of winning.

Considering that the busy generation that we live in most of us do not have the luxury to dedicate that much time on a daily basis, I have come up with a quick IPL predictor game .The game is inspired by a EURO prediction game which was run by one of our previous employers which was an instant hit.

We ran the IPL game in pilot mode last year and had fun throughout the season.This year I am throwing this open to  a wider audience.All you have to do is download & fill up the excel sheet in the link given below and email it back to me along with your name.

I will compute the scores and maintain the  leader board .

Send me the entries by 06th April midnight India time  so that I can design the leader board based on the response. Instructions are in the excel sheet . Also no negative points this year to make it a tough contest.Remember you got to predict the entire season .

So put on your thinking hats and lets play.

Excel:
https://drive.google.com/file/d/0BxnwT-RSjoJhcXRQNS1qWUxPRXkxSzNvdHZuMUg5VHphSS1F/view?usp=drivesdk

Updated excel:(Added KXP to last 4 selections)
https://drive.google.com/open?id=1TTIpQU6hCGPBNrzuz8w7GF-cZ0K8UB_H

Download the copy and make changes 

Save and email it back to heroofblogging@gmail.com .Send your name  in your email.

IPL 2018 Fantasy League --- A Tableau Report on the Years Gone By

Dt.03 April 2018.

 We all know that a fresh season of the Indian Premier League 2018 is about to begin.The excitement is in the air .And since the dust has now settled on all the recent controversies on ball tampering and last minute replacements ,we can now sit back and get a quick summary of the years gone by before we deep dive into this season.

I have collected data from sports websites and summarized into a series of Tableau vizzes which are self explanatory.I will share the same with you in this blog along with short commentaries on the data as well as the Tableau type of report used for representation.

Lets start with the list of Winners & Runners up for all the years This is a Tableau TIMELINE report prepared using custom shapes.

Its disheartening to see my  home team RCB missing out on all of the winner  slots for 10 years. But my karmbhoomi's team MI has done extremely well in last few years .

Even though these were the winners the league stage looked completely different with other teams finishing number 1 before the league,Here is a tableau BUMP report done on a dual axis to highlight the same.

RCB ended up in the playoffs stage 5 times never to return back with a trophy. Notably Sourav Ganguly's KKR & PWI were very  lowly ranked teams.Tells a story about how he could not master the T20 game.

So here are the most successful captains of the IPL T20 format.Well its our Mumbai boy Rohit Sharma followed by the rest.Displayed below is a Word cloud representing the same.

Now lets have a quick look at Individual Players and records.

Top 10  Individual Scores in an innings

Sehwag holds the unique record for scoring the highest runs in an IPL innings for two different teams  DD & KXP.

Chris Gayle who was almost left out this year has the highest Individual score.(175*)

No ones has scored a  double hundred,This record could break this year

Top 10 wicket takers in an Innings

Sohail Tanvir took 6 in the first ever IPL  & Adam Zampa did a 6 wicket haul for RPS.

Top Run getters in IPL history

This goes to the Indian quartet of Raina Kohli Rohit & Gautam Gambhir. Unfortunately Yuvraj has not shined in this area.They have also been the backbone of success for CSK MI & KKR .

Top wicket takers in IPL history

This honour goes to the speedster from Mumbai .MA- LIN -GA ..This statistic is somehow not shown across too many times since this game is dominated by batsmen.Yet Malinga has been phenomenal in IPL with his rare slinging action.Another silent warrior is Amit Mishra the leggie who has been currently sidelined in the Indian squad.

While Ashwin might not have played all seasons , Bhajji has a better record in IPL.

Well this wraps up the Tableau summary for the years gone by.

Based on these reports you can now predict the winners for this season.My top 4 bets are.

1. RCB never won a trophy

2. CSK in the combeack year and fan sentiments running high

3. KXP with a  hurting Gayle factor & Sehwag as coach 

4  DD with Maxwell & Gambhir both hurting and ready to make a statement 

You can predict your winners too in the comments.

Trivia: Who holds the record for the most sixes in IPL history.


For people ineterested in the Interactive dahboards .Please visit my tableau Public Profile
https://public.tableau.com/profile/ashwin.puthran#!/

note: Data has been manually collected from various resources.Let me know if you observe a discrepancy.