From The Pavlova

Not understanding how O/P/Q/R (2) come into this?

 

that's just where I threw the calcs. I moved them so I could use column refs.

 

this is the side of the spreadsheet.

<table style="width: 370pt; border-collapse: collapse;" border="0" cellSpacing="0" cellPadding="0" width="494"> <colgroup><col style="width: 48pt;" width="64"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" width="47"> <col style="width: 48pt;" width="64"> <col style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;" width="63"> <col style="width: 48pt;" span="4" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="border: 0px windowtext; width: 48pt; height: 15pt; background-color: transparent;" class="xl67" height="20" width="64"></td> <td style="border: 0px windowtext; width: 35pt; background-color: transparent;" class="xl67" width="47"></td> <td style="border: 0px windowtext; width: 48pt; background-color: transparent;" class="xl68" width="64"></td> <td style="border: 0px windowtext; width: 47pt; background-color: transparent;" class="xl67" width="63"></td> <td style="border: 0px windowtext; width: 48pt; background-color: transparent;" class="xl67" width="64">Ave Runs</td> <td style="border: 0px windowtext; width: 48pt; background-color: transparent;" class="xl67" width="64">Balls</td> <td style="border: 0px windowtext; width: 48pt; background-color: transparent;" class="xl67" width="64">SR</td> <td style="border: 0px windowtext; width: 48pt; background-color: transparent;" class="xl67" width="64">Out</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="border: 0px windowtext; height: 15.75pt; background-color: transparent;" class="xl67" height="21"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl68"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67" align="right">36.28465</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67" align="right">37.95096</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67" align="right">95.60932</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67" align="right">404</td> </tr> <tr style="height: 15.75pt;" height="21"> <td style="border-width: 1pt 0.5pt; border-style: solid; border-color: windowtext; height: 15.75pt; background-color: rgb(255, 255, 153);" class="xl69" height="21">Balls</td> <td style="border-width: 1pt 0px; border-style: solid none; border-color: windowtext; background-color: rgb(255, 255, 153);" class="xl70">SR</td> <td style="border: 1pt solid windowtext; background-color: rgb(255, 255, 153);" class="xl71">Out</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> </tr> <tr style="height: 15pt;" height="20"> <td style="border: 0px windowtext; height: 15pt; background-color: transparent;" class="xl67" height="20" align="right">116</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67" align="right">112.93</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl68">0</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> </tr> <tr style="height: 15pt;" height="20"> <td style="border: 0px windowtext; height: 15pt; background-color: transparent;" class="xl67" height="20" align="right">51</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67" align="right">172.55</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl68">0</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> </tr> <tr style="height: 15pt;" height="20"> <td style="border: 0px windowtext; height: 15pt; background-color: transparent;" class="xl67" height="20" align="right">115</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67" align="right">111.3</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl68">0</td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> <td style="border: 0px windowtext; background-color: transparent;" class="xl67"></td> </tr></tbody></table>

 

ah yeah makes sense.

 

is that what you were after?
If I spent time on it I'd probably build a front page to interepret your spreadsheet so you put in what you want and it calcs it out for you.
I'd have to play with it as it's more datary than I'm used to.
Most of mine are just calcs where you feed in the data to get a result as opposed to analysing hugh amounts of stuff.

 

Tried this.

Didn't work with the autofilters - the averages didn't update.

 

will soon... just on phone to the guru

 

try this
ave runs =SUBTOTAL(9,J:J)/R2
out: =SUBTOTAL(2,M:M)

 

I know I expect to get smoked every time I face you, always just sneak home though.

 

perfect bud. cheers

 

don't thank me thank the excel guru...

 

Walla Walla Weasel Wackers won by 123 runs

Nice win for me today, my bowlers probably bowled their best ever.

 

News just in: 5-2 win for USA in the PCC.

 

We play you on the 22nd of July, still a long way away...

 

Have $0 on FTP, brought too many players .

Got destroyed by the finance update, should be alright by the time I've played my games this week though. I'm selling my crap players as well.

 

That was me two seasons ago... buying up big then selling off others to civer the bills.
It's a shame you can't loan players and money.

They should introduce a player swap scheme. You could swap players for a couple of weeks or something and the other person gets to train them in their accedemy. Be cool for beginners to get some class training off a pro... perhaps.