PlanetCricket First Class Championship

This is the first time I've tried using one :p It's across a couple of sheets as well :D Got all the player data on one and then the team data on another.

Gonna try and be fancy and use it to calculate the team batting and bowling average by looking up the player data, finding the runs scored, etc. Fun procrastinating using Excel :p
 
Formula's not working :(

Code:
=SUM(VLOOKUP([@Manager],Table2[[Manager]:[10]],8,FALSE)/(VLOOKUP([@Manager],Table2[[Manager]:[10]],6,FALSE)-VLOOKUP([@Manager],Table2[[Manager]:[10]],7,FALSE)))

Trying to get it to sum the stats associated with all the times that manager's name appears in the table but it only takes the first time. Is there a different formula I'm supposed to use?
 
Did it using SUMIF :D I feel smart now

Code:
=SUMIF(Table2[Manager],[@Manager],Table2[Runs Scored])/(SUMIF(Table2[Manager],[@Manager],Table2[Inns])-SUMIF(Table2[Manager],[@Manager],Table2[NO]))
 
Well I wouldn't have been able to help you anyway since I didn't know how you've got your spreadsheet set up.
 
That is quite true. All I need to do now though is just input raw stats, and bat ave, bat sr, bowl ave, econ, bowl sr, and the team bat/bowl ave and quotient are all spat out for me :D
 
Are you talking about real life stats or the stats you'll get when you sim matches?
 
For when I sim matches. The way I'm using ICC doesn't allow me to have a record of people's stats.
 
Code:
**********************************************
Worcestershire v Victoria
First Class Match - 1 Jul 2010
**********************************************

Worcestershire - 1st Innings
----------------------------------------------
D Mitchell      c Hussey b Cleary         49
N O'Brien       b Siddle                  10
A Aimson        lbw b Hastings            33
V Rush          c Finch b Mishra          11
A Kervezee      lbw b Mishra              16
T Maynard       lbw b Mishra              9
M Ali           not out                   22
S Afridi        b Hastings                23
M Lynch         lbw b Hastings            0
S Finn          c Finch b Mishra          0
B Rankin        b Hastings                6
----------------------------------------------
Extras: (nb5)                             5
TOTAL: (all out, 58.4 overs)              184

**********************************************

                O       M       R       W
----------------------------------------------
P Siddle        13      1       40      1
A McDonald      9       0       30      0
J Hastings      14.4    4       37      4
M Cleary        10      0       33      1
V Mishra        12      1       44      4
----------------------------------------------
Fall of Wickets:
1-22  2-95  3-97  4-119  5-131  
6-132  7-166  8-166  9-167  10-184

Victoria - 1st Innings
----------------------------------------------
C Rogers        b Afridi                  73
R Quiney        b Lynch                   55
D Hussey        c Afridi b Mitchell       103
M Wade          c Maynard b Lynch         54
A Finch         c O'Brien b Mitchell      7
A McDonald      c Rankin b Mitchell       13
R Coop          lbw b Afridi              72
J Hastings      b Mitchell                11
M Cleary        b Rankin                  47
P Siddle        not out                   27
V Mishra        c Aimson b Afridi         11
----------------------------------------------
Extras: (nb6,b12,lb2)                     20
TOTAL: (all out, 125.1 overs)             493

**********************************************

                O       M       R       W
----------------------------------------------
S Finn          22      0       69      0
M Lynch         25      5       104     2
B Rankin        25      1       112     1
S Afridi        34.1    3       103     3
M Ali           6       0       30      0
D Mitchell      13      0       61      4
----------------------------------------------
Fall of Wickets:
1-103  2-187  3-275  4-298  5-310  
6-316  7-342  8-434  9-464  10-493

Worcestershire - 2nd Innings
----------------------------------------------
D Mitchell      lbw b Siddle              75
N O'Brien       c Hussey b McDonald       3
A Aimson        lbw b Siddle              49
V Rush          c Hastings b Siddle       1
A Kervezee      run out                   57
T Maynard       lbw b Hastings            17
M Ali           c Wade b McDonald         52
S Afridi        b Cleary                  27
M Lynch         b Siddle                  11
S Finn          lbw b McDonald            0
B Rankin        not out                   9
----------------------------------------------
Extras: (nb6,w8,b4,lb2)                   20
TOTAL: (all out, 113.4 overs)             321

**********************************************

                O       M       R       W
----------------------------------------------
P Siddle        25.4    1       81      4
A McDonald      21      8       47      3
M Cleary        21      6       51      1
J Hastings      21      3       61      1
V Mishra        25      3       75      0
----------------------------------------------
Fall of Wickets:
1-5  2-122  3-138  4-141  5-197  
6-236  7-299  8-303  9-303  10-321


Victoria - 2nd Innings
----------------------------------------------
C Rogers        not out                   6
R Quiney        not out                   7
D Hussey        
M Wade          
A Finch         
A McDonald      
R Coop          
J Hastings      
M Cleary        
P Siddle        
V Mishra        
----------------------------------------------
Extras:                                   0
TOTAL: (0 wkts, 1.4 overs)                13

**********************************************

                O       M       R       W
----------------------------------------------
S Finn          1       0       7       0
M Lynch         0.4     0       6       0
----------------------------------------------
Fall of Wickets:



**********************************************
Victoria won by 10 wickets
Man of the match: D Mitchell
**********************************************

This is what ICC can output into a text file. Does this look fine or do you want more stats?
 
I don't mind more stats but if that means more work for you then don't worry. You want to have fun running a league and not do something which takes away from it. Unless you enjoy that sorta thing.
 
The other option is screenshotting the match. Will take a couple of minutes more at most.
 
Then the screenies will be better is what I feel. It looks pretty neat as well.
 

Users who are viewing this thread

Top