Forecasting Tool

[GaryHamsonsLeftBootLace]

My forecast for end of season using this tool is:

1. Blades 95 Pts
2. Fleetwood 82
3. Bolton 74
4. Scunthorpe 74

The tool is a MS Excel spreadsheet. Fill in the orange scores the "For" score being the team named at the top. Don't edit the yellow cells as they auto update, including the ones where teams play each other (e.g. Bolton's fixtures against Fleetwood and Scunny).

Enjoy, and if someone is whizz enough on Excel to create an automatic forecasted league table without having to play around with the Sort menu, please feel free.

 

[Kenilworth]

Can you imagine my disappointment on discovering that this thread was not about grafikhaus or SellyOakBlade ?

 

[Treeton Blade]

 

[Tynemouth Blade]

My forecast for end of season using this tool is:

1. Blades 95 Pts
2. Fleetwood 82
3. Bolton 74
4. Scunthorpe 74

The tool is a MS Excel spreadsheet. Fill in the orange scores the "For" score being the team named at the top. Don't edit the yellow cells as they auto update, including the ones where teams play each other (e.g. Bolton's fixtures against Fleetwood and Scunny).

Enjoy, and if someone is whizz enough on Excel to create an automatic forecasted league table without having to play around with the Sort menu, please feel free.

Didn’t the BBC do one of these in the past, or do they still do it?

 

[mattbianco1]

My forecast for end of season using this tool is:

1. Blades 95 Pts
2. Fleetwood 82
3. Bolton 74
4. Scunthorpe 74

The tool is a MS Excel spreadsheet. Fill in the orange scores the "For" score being the team named at the top. Don't edit the yellow cells as they auto update, including the ones where teams play each other (e.g. Bolton's fixtures against Fleetwood and Scunny).

Enjoy, and if someone is whizz enough on Excel to create an automatic forecasted league table without having to play around with the Sort menu, please feel free.

Your formula's are screwed. Doesn't add Fleetwood and Bolton up right because you only go down to Row 12.

Any road, i've got this:

1. Sheff Utd 93
2. Fleetwood 86
3. Bolton 85
4. Scunthorpe 80

 

[Mouth of the South]

You do realise your forecasting tool contradicts The Stir's 'supercomputer' that predicted (hoped) Utd would finish in a play off place?

 

[Maidenhead]

And there was I thinking this was a thread about Paul Hudson

 

[BiggerBladeThanThou]

Can't be arsed with that..

 

[GaryHamsonsLeftBootLace]

Your formula's are screwed. Doesn't add Fleetwood and Bolton up right because you only go down to Row 12.

Any road, i've got this:

1. Sheff Utd 93
2. Fleetwood 86
3. Bolton 85
4. Scunthorpe 80

You spotted the deliberate mistake

Here's the updated version...

 

[Esablade]

...just put in a fairly pessimistic set of results and still come up with 88 points...

No Game N/A -
Swindon A 1 1 -1
Charlton H 0 1 -0
Oldham A 1 1 -1
Millwall H 1 2 -0
Coventry H 2 0 -3
Northampton A 1 0 -3
Port Vale A 2 0 -3
Bradford H 2 2 -1
MK Dons A 1 1 -1
Chesterfield H 3 0 -3
No Game
Current Points 72
End of Season Points 88

 

[Pierre's PC]

I stopped downloading stuff from random people when limewire died.

 

[JJ Sefton]

My old tool was Darren; I'd ask him for a forecast and assume the opposite.

 

[MoscowBlade]

Your formula's are screwed. Doesn't add Fleetwood and Bolton up right because you only go down to Row 12.

Any road, i've got this:

1. Sheff Utd 93
2. Fleetwood 86
3. Bolton 85
4. Scunthorpe 80

My forecast for end of season using this tool is:

1. Blades 95 Pts
2. Fleetwood 82
3. Bolton 74
4. Scunthorpe 74

My forecast:
1. Blades 91 pts
2. Fleetwood 90 pts
3 Bolton 82 pts
4 Scunthorpe 80 pts

The tool is a MS Excel spreadsheet. Fill in the orange scores the "For" score being the team named at the top. Don't edit the yellow cells as they auto update, including the ones where teams play each other (e.g. Bolton's fixtures against Fleetwood and Scunny).

Enjoy, and if someone is whizz enough on Excel to create an automatic forecasted league table without having to play around with the Sort menu, please feel free.

My forecast for end of season using this tool is:

1. Blades 95 Pts
2. Fleetwood 82
3. Bolton 74
4. Scunthorpe 74

The tool is a MS Excel spreadsheet. Fill in the orange scores the "For" score being the team named at the top. Don't edit the yellow cells as they auto update, including the ones where teams play each other (e.g. Bolton's fixtures against Fleetwood and Scunny).

Enjoy, and if someone is whizz enough on Excel to create an automatic forecasted league table without having to play around with the Sort menu, please feel free.

 

[metalblade]

https://www.s24su.com/forum/index.php?threads/league-one-predictor.52843/

p.s don't forget to go back a few weeks and fill in the postponed game scores or it will screw up the calculations.

 

[TJB.]

 

[ucandomagic]

http://www.footballwebpages.co.uk/leagueone/league/predicted

This link shows an updated forecast after every match. There is a link at the bottom of the table that shows all of the future results that the forecast is based on.

UTB

 

[blade too long]

We will finish top

did that without any tools or a safety net