Hello everyone,
So this is something I came up with last night (I admit it needs polishing. But it's a result of 4-5 hours of work). Taking a cue from @PresidentEvil 's stats calculator, I went ahead and created a web version of the same.
Presenting to you, the simple yet powerful stats caluclator:
Features:
How To Use the File Upload Option:
The excel sheet should be in the same format as attached in this post
Bowling Stats
How To User Manual Entry Option:
Batting / Bowling Stats
+ Open to suggestions and new features implementation.
So this is something I came up with last night (I admit it needs polishing. But it's a result of 4-5 hours of work). Taking a cue from @PresidentEvil 's stats calculator, I went ahead and created a web version of the same.
Presenting to you, the simple yet powerful stats caluclator:
Features:
- Web based: Available on the move 24x7
- File upload option: Have all stats in an excel sheet? Great, upload it and get back the same updated sheet with the calculated values
- Once downloaded, the file will contain header row to specify the column type
- Manual entry option: Want to enter each player manually? No problem. That's available too.
- Has option to add multiple players at once by using the "Add New Player" button
- Stats are generated based on player type - Batting or Bowling
How To Use the File Upload Option:
The excel sheet should be in the same format as attached in this post
- Select the type of sheet being uploaded (i.e. batting sheet or bowling sheet)
- Browse to the file and select it
- Click the "Upload" button
- Column A: Player Name
- Column B: Innings Played
- Column C: Not Outs
- Column D: Runs Scored
- Column E: Balls Faced
- Column F: Batting Average (Will be auto generated and presented upon download)
- Column G: Batting Strike (Will be auto generated and presented upon download)

Bowling Stats
- Column A: Player Name
- Column B: Overs Bowled (Accepts decimal values such as 10.3)
- Column C: Wickets Taken
- Column D: Runs Conceded
- Column E: Bowling Strike Rate (Will be auto generated and presented upon download)
- Column F: Bowling Average (Will be auto generated and presented upon download)
- Column G: Bowling Economy (Will be auto generated and presented upon download)

How To User Manual Entry Option:
Batting / Bowling Stats
- Simply enter the values of the player in the textboxes
- If you want to add more than one player, click the "Add Another Player" button and it will show up below the first player
- Once done, click the "Submit" button
+ Open to suggestions and new features implementation.