The Official 2018/19 Premier League Predictathon Thread
Discussion
Haven't we all played 40 games too?
Also, I think I may have found how the error has come about. Some predictions posted seem to have an extra space after the score:
E.G 2-0 prediction written 2space0space instead of 2space0
Assuming you simply copy & paste into your spreadsheet, I am wondering if that is picking up the extra space at the end and therefore the s/s function/equation is not picking up the match. I think there might be a couple of other errors in the league table too, which seem to be linked to this extra space!
Just a thought - I maybe wrong!! Might just be worth us all making sure we avoid that second space just to ease the data collection!
Also, I think I may have found how the error has come about. Some predictions posted seem to have an extra space after the score:
E.G 2-0 prediction written 2space0space instead of 2space0
Assuming you simply copy & paste into your spreadsheet, I am wondering if that is picking up the extra space at the end and therefore the s/s function/equation is not picking up the match. I think there might be a couple of other errors in the league table too, which seem to be linked to this extra space!
Just a thought - I maybe wrong!! Might just be worth us all making sure we avoid that second space just to ease the data collection!
Edited by mattyn1 on Monday 3rd September 23:31
Edited by mattyn1 on Monday 3rd September 23:36
Well done Mattyn1, I think you are correct, it should be number/space/number only. Extra spaces could well be the problem.
As for 40 games - again you are correct. I'll amend on the next SS. It's the only column I fill in manually and sometimes it gets forgotten what with all of the data sorting etc. Luckily it's not important in terms of table placement. In fact, over the Christmas period it's a pain in the arse.
You're doing well and clearly positioning yourself for a shot at running the Predictathon next season. I'll second you right now
And you're spreadsheet savvy which is always better than letting some fool with pencil and children's graph paper take over
As for 40 games - again you are correct. I'll amend on the next SS. It's the only column I fill in manually and sometimes it gets forgotten what with all of the data sorting etc. Luckily it's not important in terms of table placement. In fact, over the Christmas period it's a pain in the arse.
You're doing well and clearly positioning yourself for a shot at running the Predictathon next season. I'll second you right now
And you're spreadsheet savvy which is always better than letting some fool with pencil and children's graph paper take over
Some say I am a bit of a weirdo when I say I quite like knocking Spreadsheets up - maybe I am! But I thought I would have a go at doing one for this when I started playing..... the only bit I have not managed to work out is the matching correct results with an incorrect score - I can visualise the formula in my head loosely - but i need some time to work it properly - so in mine I have been doing that manually.
Matching a correct score guess to the actual score is dead easy - as long as we don't have too many <spaces> in the predictions!
And I would wager avoiding relegation would be easier than building a spreadsheet to fully automate this game!
Also, has anyone come up with an idea to play an FA Cup predictathon?
Matching a correct score guess to the actual score is dead easy - as long as we don't have too many <spaces> in the predictions!
And I would wager avoiding relegation would be easier than building a spreadsheet to fully automate this game!
Also, has anyone come up with an idea to play an FA Cup predictathon?
mattyn1 said:
Some say I am a bit of a weirdo when I say I quite like knocking Spreadsheets up - maybe I am! But I thought I would have a go at doing one for this when I started playing..... the only bit I have not managed to work out is the matching correct results with an incorrect score - I can visualise the formula in my head loosely - but i need some time to work it properly - so in mine I have been doing that manually.
Matching a correct score guess to the actual score is dead easy - as long as we don't have too many <spaces> in the predictions!
And I would wager avoiding relegation would be easier than building a spreadsheet to fully automate this game!
Also, has anyone come up with an idea to play an FA Cup predictathon?
You'll need to speak to Oxford about the FA Cup. Matching a correct score guess to the actual score is dead easy - as long as we don't have too many <spaces> in the predictions!
And I would wager avoiding relegation would be easier than building a spreadsheet to fully automate this game!
Also, has anyone come up with an idea to play an FA Cup predictathon?
mattyn1 said:
Some say I am a bit of a weirdo when I say I quite like knocking Spreadsheets up - maybe I am! But I thought I would have a go at doing one for this when I started playing..... the only bit I have not managed to work out is the matching correct results with an incorrect score - I can visualise the formula in my head loosely - but i need some time to work it properly - so in mine I have been doing that manually.
Matching a correct score guess to the actual score is dead easy - as long as we don't have too many <spaces> in the predictions!
And I would wager avoiding relegation would be easier than building a spreadsheet to fully automate this game!
If you want a copy of the spreadsheet with the system and formulas revealed then PM me.Matching a correct score guess to the actual score is dead easy - as long as we don't have too many <spaces> in the predictions!
And I would wager avoiding relegation would be easier than building a spreadsheet to fully automate this game!
It’s a bargain at only £40
oxford drinker said:
Excel should get rid of any extra spaces at the end when you paste the scores in... or it used to, anyway.
I've just checked and it does so that makes this incident curious. I can only assume it's a glitch.However, hopefully everyone is checking their scores at least for one matchday so that they know the formula is working for them.
On another note I've been offered the opportunity to get away for a week from this Saturday so I'm taking it. I'll publish Matchday 6's fixtures just before I go this Friday but it means there will be no table published on Monday. I'll amalgamate the two matches in my return and publish the table the following Monday.
I'll have my phone with me but I can't do the spreadsheet on that, it's too fiddly.
Gassing Station | Football | Top of Page | What's New | My Stuff