The Oracle

[foleys]

Guys

I have put together this Excel workbook that tries to predict games by using current form, home/away form, and percentage from the Premiership to the Scottish 2nd, sorry too lazy to add the 3rd. In a nut shell it is using maths to predict winners.

I have used it for a couple of weeks and it is running at about 75% correct predictions

Please feel free to add any advice on the formula's I have used.

Thanks

Sean

[foleys]

The teams for this weekend are
Blackburn 10/11
Brechin 8/13
Cardiff 8/11
Chelsea 4/9
Hartlepool 8/11
Huddersfield 5/6
Millwall 10/11
Peterhead 10/11
Raith 23/20
St Johnstone 4/7
Sunderland 10/11
Swindon 4/7
Wycombe 11/10
Yeovil 6/4

[kompressaur]

seems interesting Foleys. im suprised no one has replied. I can't open excel files as ..well i dont have excel and i should download this free alternative to it
http://www.openoffice.org/

I don't know if we need to authorise your attachment. Can people see it?

[foleys]

Kompressaur
Thanks for the input. The mods approved it yesterday so people should now be able to see it. I have uploaded the workbook to my website. Please feel free to have a look.
http://foleys.me.uk/

[traeth]

Just had a quick look . Looks like a lot of work you've done there mate . I will have another look after the weekend .

Just one question to start with , I looked at your Championship sheet as I agreed with your selections of Cardiff and Sunderland.
Why is Southampton "too close" with a rating of -15 , whilst you recommend Yeovil with a rating of -11?
Does it have anything to do with price?
Cannot see any reference to price /value anywhere.

good luck with your selections

[foleys]

There are 3 different criterias for selection to be chosen. It has to have atleast the curent form and one of the other 2 to select a team. So for Southampton the current form predicts a -15 so the away is fancied on current form, but on the % and points it is too close.

I hope it make sense.

Blackburn Won
Brechin Draw
Cardiff Won
Chelsea Draw
Hartlepool Draw
Huddersfield Won
Millwall Won
Peterhead Lost
Raith Lost
St Johnstone Won
Sunderland Won
Swindon Won
Wycombe Lost
Yeovil Won

8 Won
3 Drawn
3 Lost

[thehandicapman]

Interesting stuff Foley - it must be hell to update!

If you have any specific excel q's i might be able to help.

THM

[Mike_Winter]

I had a look at this last night and it certainly looked good, just wondering how I would go about updating it with recent results? Is there a help file anywhere