Player ratings idea

[James.]

Awhile ago I created THIS thread to see if there was any way we could introduce a database system for recording and analysing player ratings so as to produce the Foxestalk man of the match, player of the month, etc.

Well it seems that it may not be possible in terms of programming time or whatever to get something automatic introduced to the site. I know sheffield_fox used to do something but that involved websites and to be honest I don't really know how he did it and I can't be arsed to find out.

So basically I'm happy to put together a spreadsheet (I'm a spreadsheet geek, I'm aware of this) to record everyone's ratings after each game. I'll then use some very basic statistical techniques such as removing the highest and lowest score for each player to give the Foxestalk average. I'll exercise caution with rival supporters ratings (if they bother providing them) and also anyone's ratings that just look stupid.

What would help is if everyone used the same format (i.e. player order) as the first person to post in a player ratings thread. Also only people that went to the game should post their ratings. Furthermore I do have other things to do in my life so I hope people are patient - I would hope to get the averages (and any other interesting statistics I can think of) published by Monday or Tuesday assuming a Saturday game.

If anyone has any ideas or suggestions stick them in here.

[General Smuts]

Clem, redtube is a much better waste of your time.

[James.]

Clem, redtube is a much better waste of your time.

I'm a sad bastard. I've never even been on redtube. I like numbers instead. My girlfriend is very proud.

[Jay]

Awhile ago I created THIS thread to see if there was any way we could introduce a database system for recording and analysing player ratings so as to produce the Foxestalk man of the match, player of the month, etc.

Well it seems that it may not be possible in terms of programming time or whatever to get something automatic introduced to the site. I know sheffield_fox used to do something but that involved websites and to be honest I don't really know how he did it and I can't be arsed to find out.

So basically I'm happy to put together a spreadsheet (I'm a spreadsheet geek, I'm aware of this) to record everyone's ratings after each game. I'll then use some very basic statistical techniques such as removing the highest and lowest score for each player to give the Foxestalk average. I'll exercise caution with rival supporters ratings (if they bother providing them) and also anyone's ratings that just look stupid.

What would help is if everyone used the same format (i.e. player order) as the first person to post in a player ratings thread. Also only people that went to the game should post their ratings. Furthermore I do have other things to do in my life so I hope people are patient - I would hope to get the averages (and any other interesting statistics I can think of) published by Monday or Tuesday assuming a Saturday game.

If anyone has any ideas or suggestions stick them in here.

will this spreadsheet contain a multitued of formulas for example =IF(F3>0,"set",E3/100*5) I tend to find you get some strange satisfaction when you nail a decent formula so you are not alone on the spreadsheet front!!

but sounds like a plan

[Tommy G]

It's a good idea, but I think it will get distorted becuase

a) People will post ratings who haven't been to the game, how can you prove they haven't? Do we send you ticket stubs through the post..

b) People will understate/overstate ratings

Therefore the data and 'averages' you get won't probably reflect the players performance in a particular game, or over the whole season.

[James.]

will this spreadsheet contain a multitued of formulas for example =IF(F3>0,"set",E3/100*5) I tend to find you get some strange satisfaction when you nail a decent formula so you are not alone on the spreadsheet front!!

but sounds like a plan

I'll have IF statements within IF statements within OR statements. It'll be very sexy.

It's a good idea, but I think it will get distorted becuase

a) People will post ratings who haven't been to the game, how can you prove they haven't? Do we send you ticket stubs through the post..

b) People will understate/overstate ratings

Therefore the data and 'averages' you get won't probably reflect the players performance in a particular game, or over the whole season.

a) From reading previous player rating threads generally people only bother rating if they have been to the game. Furthermore I'm sure people will be happy to state whether they have been to the game or not. I really don't see this as being a significant issue.

b) Why? I can use statistics to minimise the effect of this anyway. I can "smooth" the data to omit inconsistencies while at the same time recognising the variety of opinions that people often have when it comes to rating players. Any ridiculous scores (relative to the others) can easily be spotted.

[Cheese Me]

Sounds great to me.

Look forward to seeing the results.

[davieG]

I've already contacted Sheff Fox about resurrecting his site, he's now making arrangements with Mark to set something up for the MK game which he will gradually improve as the season progresses.

Look out for a posting for the MK match.

[James.]

I've already contacted Sheff Fox about resurrecting his site, he's now making arrangements with Mark to set something up for the MK game which he will gradually improve as the season progresses.

Look out for a posting for the MK match.

[Daggers]

You can still do your bedded 'if' within another 'if'...and I'm sure it will be a very lovely spreadsheet.

You bastard davieG! Crushing poor JTB's dreams.

[Alexikokopops]

NEEEEEEEEEEEEEEEEEEEEEEERD.

He says while settling down in front of his RTI Impact Spreadsheet. It has colours and everything!

[The People's Hero]

I feel for JTB.

You can make a spreadsheet of my life if you like.

[Daggers]

I feel for JTB.

You can make a spreadsheet of my life if you like.

I'll chip in a pie chart

[Dr The Singh]

I feel for JTB.

You can make a spreadsheet of my life if you like.

You can spread for me between the sheets for me anytime JTB!!!

[Tabou]

You can spread for me between the sheets for me anytime JTB!!!

I think I'll give the Swan a miss on Saturday now.....

[Daggers]

I think I'll give the Swan a miss on Saturday now..... how about we just meet at my place

Just what kind of forum do you think this is?

[thybluefox]

I could knock a database driven ratings system pretty easily i reckon.

[davieG]

You can still do your bedded 'if' within another 'if'...and I'm sure it will be a very lovely spreadsheet.

You bastard davieG! Crushing poor JTB's dreams.

I'm a hard man!

JTB - perhaps you could contact Sheff Fox maybe he'd appreciate some help/advice

[James.]

I'm a hard man!

JTB - perhaps you could contact Sheff Fox maybe he'd appreciate some help/advice

I need a couple of days to come to terms with my shattered dream. Maybe then I will.

[Tabou]

Just what kind of forum do you think this is?

This is not a place for meeting hairsy-arsed football fans?

Oh Dear.

EDIT:- I cannot believe THAT was my 1000th post !

[Charnwood Norris]

When the season ends, show the results to Pearson & Mandaric..... all whilst smoking a Cuban cigar and laughing about Barry Hayles' 87.52% ball control failure.