5 GAMES TO GO Swindon 7 games to go 21 points total 91 points max play PNE so total likely 91 - 89 - 88 so effectively cant win the league and will need a divine miracle to go up automatically. MKD 6 games to go 18 points done playing top teams so likely total could be 93 points, but win 6 more? PNE 6 games to go and 18 points total 98 points play Swindon and CITY so points could be 98 - 96- 92 .. current run won 10 drawn 3 so will they beat our run won 10 drawn 6 .. Bristol City 5 games to go total of 103pts max but play PNE so likely 103 - 101 - 100 so still chance for triple figures 2 home and 3 away. Sat a draw will be worth a win as both sides are a game closer to the final reckoning. PNE then needing CITY TO LOSE 3 OF THEIR LAST 5 AND DRAW 2 a CITY win would mean PNE need city to lose their last 4 PNE win 5 a PNE win would mean they need City to lose 2 more win 1 and draw 1 ( of course Swindon could go on a winning streak and beat PNE for us!) come on the ROBINS
so we only need to win 2 games to return to the championship this time next week.......................
Far easier to read my spreadsheet. Enter the result and it works it out . Incidentally we can get promoted by gaining another 5 points if we maintain a better goal difference than MK Similarly its 10 points needed to be champions (we are currently 9 goals better off than Preston)
LARED my spreadsheets are set up for the obvious, the worst scenario ( rounded down) the best scenario ( rounded up )they take into consideration past results, level playing field and past results against teams away top half (periodically revised 4-5 games) past results against teams away bottom half (periodically revised 4-5 games) past results against home top half (periodically revised 4-5 games) past results against home bottom half (periodically revised 4-5 games) Current as above previous 10 games ( no more than a 6-4 split ) the above is not based on spreadsheets just simple logic with less games to go spreadsheet calculations above become/appear more erratic they are not the final outcome just a guide based on figures what might happen..laws of probability EXAMPLE OF THIS IS in the table on different post City would lose 2 (v Swindon was L .. D and W just less than .5 in calc ) we won! PNE D THEN WIN (city) BUT BEAT bRADFORD 10 MEN! but that's football ......... part extract .........................................................................................................................23 28 ........ 28 33 ........ 33 38 ........ 38 43 LEAGUE ..... ..... ...... ..... ...... ..... ...... ..... ...... ..Top ...... Bottom .... ..... ...... DATA ...... DATA ...... DATA ...... DATA TEAM ........ PLYD ... Won ... Draw ... Lost ... 12 pts ... 11 pts ... PTS ........... POSN.... ... POSN.... ... POSN........ ... POSN CITY........ ........ 41 ........ 26 ....... 10 .......... 5 ......... 43 ........ 45 ...... 88 ......... 1 ......... 1 ......... 1 ......... 1 PNE......... ........ 40 ......... 23 ........ 11 .......... 6 ......... 43 ........ 37 ...... 80 ......... 3 ......... 4 ......... 2 ......... 2 SWINDON ..... 39 ......... 21 ........ 7 .......... 11 ......... 38 ........ 32 ...... 70 ......... 4 ......... 2 ......... 4 ......... 3 MKDONS.. ..... 40 ......... 22 ........ 9 .......... 9 ......... 34 ........ 41 ...... 75 ......... 2 ......... 3 ......... 3 ......... 4 you can see from game 23 City have been 1st whilst other teams have wiggled around !!!
just clearing up the difference between a spread sheet and a . s p r e a d s h e e t and I do have a healthy hobby .... how many aged peeps do you know that can move 700kgs vertically 40 foot then along 20 foot in 20 kg bites in 50 mins! twice a week sometimes 3! or for 9 days out of 10 walk 16k over a vertical range of 400m?......... fresh air and exercise physically aids the other functions of the body!..... oh and perform similar for 4-5 hours after the first 8k... Sweeping statement...un defined... return as runners up? worst scenario ... ... best scenario .. .. LIKELY CITY 43 .. .. .. .. 89 .. .. .. 92 .. .. .. ..90 P NE 42 .. .. .. .. 84 .. .. .. 81 .. .. .. .. 84 M KD 42 .. .. .. .79 .. .. .. 76 .. .. .. ..77 SWIN 41 .. .. .. ..76 .. .. .. 73 .. .. .. ..73 SHEF 43 .. .. .. ..71 .. .. .. 71 .. .. .. ..71 CHES 43 .. .. .. .67 .. .. .. 67 .. .. .. ..67 ROCH 42 .. .. .. .60 .. .. .. 63 .. .. .. ..63 FLEE 43 .. .. .. ..59 .. .. .. 62 .. .. .. ..60 WILL ALL BE SETTLED V COVENTRY CITY 44 .. .. .. .. 93 P NE 43 .. .. .. .. 85 M KD 43 .. .. .. .80 SWIN 42 .. .. .. ..76 SHEF 44 .. .. .. ..72 CHES 44 .. .. .. .68 ROCH 43 .. .. .. .64 FLEE 44 .. .. .. .. 61 BRAD 43 .. .. .. .59
