Number Cruncher - The Stats Calculator (With upload option)

asprin

Administrator
Admin
India
PlanetCricket Award Winner
Joined
Sep 3, 2012
Online Cricket Games Owned
  1. Don Bradman Cricket 14 - Steam PC
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:
  • 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
Batting Stats
  • 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)
batting.jpg


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)

bowling.jpg




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.
 

Attachments

  • batting_sheet.xlsx
    8.1 KB · Views: 12
  • bowling_sheet.xlsx
    8 KB · Views: 10

Users who are viewing this thread

Top