comment by dublin fox optimistically pessimistic, (was london fox)(now Cambridge fox)(can not spell fox) (U1131)
posted 4 days ago
comment by emKriti (U21322)
posted 59 minutes ago
comment by Manfrombelmonty (U1705)
posted 1 hour, 11 minutes ago
Think I got every single championship result wrong! Even an infant with a crayon could've accidentally guessed more right
----------------------------------------------------------------------
Hey, who told you my method, MFB?
----------------------------------------------------------------------
no that doesn't work either
zero championship point with the red crayon this week
next week im trying dice for the championship
1,4/2,5/3,6/ score 1,2,3,
1,4/2,5/3,6/ home,away,draw !?
----------------------------------------------------------------------
everyone know it's the green crayon for the championship.
comment by Call Sign: Until Valhalla (U3627)
posted 1 hour, 33 minutes ago B
comment by Penshawdave (U1894)
posted 1 hour, 51 minutes ago
comment by Call Sign: Until Valhalla (U3627)
posted 1 hour, 35 minutes ago
Did you forget to change the position column?
----------------------------------------------------------------------
No. I am using a brand new spreadsheet which has been completely revamped and has a few items still to do. But I knew you would be first on the case today before I went out so posted so as not to disappoint you.
I have not bumped it up the site so far till I sort it out.
----------------------------------------------------------------------
I made a few changes to the Scottish one for this season to make it easier for me to manage
So far I have spent more time managing the spreadsheet and code than if I had left it alone
----------------------------------------------------------------------
With plenty of time on my hands these days I like to try different layouts on my spreadsheet.
I have recently had some terrific help from Emkriti who plays KOP and has given me some new methods of calculating totals ...very quickly. So that is why I am reorganising my spreadsheet.
I meant to enter your Scottish pred game seeing that you raided the KOP last season but I forgot the early weeks . I could always try chasing up the table from the bottom
You’d easily catch the ones at the bottom
I switched the scoring to match yours. It was previously only 5,4 and 3
Now it makes for better reward for correct score
Hmm, haven't won the Scottish one yet
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 minutes ago
Hmm, haven't won the Scottish one yet
----------------------------------------------------------------------
Cinci, Lets both give it a try and show them how its done having given them a start
I will take a look tomorrow morning at the fixtures..
comment by montleeds (U18330)
posted 3 hours, 27 minutes ago
comment by dublin fox optimistically pessimistic, (was london fox)(now Cambridge fox)(can not spell fox) (U1131)
posted 4 days ago
comment by emKriti (U21322)
posted 59 minutes ago
comment by Manfrombelmonty (U1705)
posted 1 hour, 11 minutes ago
Think I got every single championship result wrong! Even an infant with a crayon could've accidentally guessed more right
----------------------------------------------------------------------
Hey, who told you my method, MFB?
----------------------------------------------------------------------
no that doesn't work either
zero championship point with the red crayon this week
next week im trying dice for the championship
1,4/2,5/3,6/ score 1,2,3,
1,4/2,5/3,6/ home,away,draw !?
----------------------------------------------------------------------
everyone know it's the green crayon for the championship.
----------------------------------------------------------------------
Oh!
This adultig is so hard!
comment by Penshawdave (U1894)
posted 1 day, 8 hours ago
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 minutes ago
Hmm, haven't won the Scottish one yet
----------------------------------------------------------------------
Cinci, Lets both give it a try and show them how its done having given them a start
I will take a look tomorrow morning at the fixtures..
----------------------------------------------------------------------
Argh, bleedin forgot to go do it, was fired up as well
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 hours, 53 minutes ago
comment by Penshawdave (U1894)
posted 1 day, 8 hours ago
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 minutes ago
Hmm, haven't won the Scottish one yet
----------------------------------------------------------------------
Cinci, Lets both give it a try and show them how its done having given them a start
I will take a look tomorrow morning at the fixtures..
----------------------------------------------------------------------
Argh, bleedin forgot to go do it, was fired up as well
----------------------------------------------------------------------
There are around 7 or so double pointers weeks PLUS you have 2 jokers to even DOUBLE a double pointer set.. With lots of weeks to come etc it is worth a shot to see how far you can get up the table.
Set 6 results now posted early thanks to Emkriti
Dave, just out of curiosity is your monthly table on a spreadsheet?
My spreadsheet has the entrants along the top with all the headings (predictions, points this round etc) and the fixtures for every set down the left side. As long as the points are entered correctly, the tab at the top (insert) is opened and after highlighting all the relevant boxes using my mouse it automatically adds the points, thus no mistakes.
I still have to copy and paste the updated league tables though, using the JA606 table format. Takes roughly an hour to manually do it that way.
comment by wolfieintheSunshineState (U16306)
posted 10 minutes ago
Dave, just out of curiosity is your monthly table on a spreadsheet?
My spreadsheet has the entrants along the top with all the headings (predictions, points this round etc) and the fixtures for every set down the left side. As long as the points are entered correctly, the tab at the top (insert) is opened and after highlighting all the relevant boxes using my mouse it automatically adds the points, thus no mistakes.
I still have to copy and paste the updated league tables though, using the JA606 table format. Takes roughly an hour to manually do it that way.
----------------------------------------------------------------------
Wolfie I have always wondered how you collected the entries and took out the teams and just use the score.
Do you have to re enter each one as a score?
Do you also have to enter the individual points for every scoring pred so they get added together
I collect the CODES by copy/paste straight to a fans column (10 secs for each one)
Scoring for ALL fans can now be done in 5 mins now that I have a super calculator (from Emkriti )
All my tables are produced automatically for monthly, main table. Bonus points are added automatically once I put them on.
It depends how much you are familiar with spreadsheets etc.
My first decent week and I still get shafted by 5 points in the H2H
I copy and paste the fixtures from the BBC Sports website and edit them accordingly. On my spreadsheet I use column A for the matches i.e.
MNU v WOL and so on down the left side and add total, using 11 boxes. When the matches are finished I add the score...MNU v WOL 1-1 in the A column.
All of the participants are along the top using 8 boxes for each one.. ID, Pre. Pts T/R, C/R, jks, Pts, Bon Pts, Total pts. I then manually enter the points for each match. Then use the 'insert' box, select 'sum' after highlighting, dragging all boxes and it adds the totals automatically.
Then comes the hard part by copying and pasting the last table, creating a new article and manually correcting it according to the info on the spreadsheet.
If you have of a quicker way to automatically update the table, I'd be happy to try it.
42..Ginolasmane .v. Oldgoldilox....41
Oof thats a tough one to take....all the best Ginolas
comment by Oldgoldilox - 1 Carl Ikeme (U17303)
posted 9 hours, 33 minutes ago
42..Ginolasmane .v. Oldgoldilox....41
Oof thats a tough one to take....all the best Ginolas
----------------------------------------------------------------------
I've never been so happy about an arsenal 2 0 win! Cheers
Interim Scores for SET 6B
(Thanks to the new super fast calculator)
TOP SET
Tector ..41
Oldgoldilox ..33
PPLF ..32
Jukes Jake ..31
MarcusMud ..31
Somtin .31
Cinciwolf .. 30
TOP MONTHLY
Wolfie ..212
Takeaboo ..207
MarcusMud .. 201
Lily ..194
Worc Spur ..189
TOP OVERALL
Scottini ..452
MFB ..446
Worc Spur ..446
Takeaboo ..443
Wolfie ..442
Results posted for SET 6B
How close is that lot ?
Anyone else hate League Cup games?
comment by JukeboxJunkie (U10162)
posted 22 minutes ago
Anyone else hate League Cup games?
----------------------------------------------------------------------
You did quite well out of them with the 7th highest set score
Moi was 33rd So I hate them (this time)
By the way Juke, you are 1st reserves team for the 1st Round of H2HKo if anyone misses entry. !!
Not as much as I hate the Championship games
As PSD said at the start of the season with 3 teams coming down to it and 3 coming up along with being a league where everyone takes points off everyone then it is so hard to consistently predict
comment by Call Sign: Until Valhalla (U3627)
posted 2 minutes ago
Not as much as I hate the Championship games
As PSD said at the start of the season with 3 teams coming down to it and 3 coming up along with being a league where everyone takes points off everyone then it is so hard to consistently predict
----------------------------------------------------------------------
Plus... League Cup games are used by Prem teams to give their reserves a run out especially in the early rounds till it gets to the business end of last 8 teams.
comment by Penshawdave (U1894)
posted 1 hour, 28 minutes ago
comment by JukeboxJunkie (U10162)
posted 22 minutes ago
Anyone else hate League Cup games?
----------------------------------------------------------------------
You did quite well out of them with the 7th highest set score
Moi was 33rdSo I hate them (this time)
----------------------------------------------------------------------
Flukes it
comment by JukeboxJunkie (U10162)
posted 2 hours, 39 minutes ago
Anyone else hate League Cup games?
----------------------------------------------------------------------
Nah, love em
Sign in if you want to comment
King of Pundits 2018/19: RESULTS
Page 4 of 16
6 | 7 | 8 | 9 | 10
posted on 21/9/18
comment by dublin fox optimistically pessimistic, (was london fox)(now Cambridge fox)(can not spell fox) (U1131)
posted 4 days ago
comment by emKriti (U21322)
posted 59 minutes ago
comment by Manfrombelmonty (U1705)
posted 1 hour, 11 minutes ago
Think I got every single championship result wrong! Even an infant with a crayon could've accidentally guessed more right
----------------------------------------------------------------------
Hey, who told you my method, MFB?
----------------------------------------------------------------------
no that doesn't work either
zero championship point with the red crayon this week
next week im trying dice for the championship
1,4/2,5/3,6/ score 1,2,3,
1,4/2,5/3,6/ home,away,draw !?
----------------------------------------------------------------------
everyone know it's the green crayon for the championship.
posted on 21/9/18
comment by Call Sign: Until Valhalla (U3627)
posted 1 hour, 33 minutes ago B
comment by Penshawdave (U1894)
posted 1 hour, 51 minutes ago
comment by Call Sign: Until Valhalla (U3627)
posted 1 hour, 35 minutes ago
Did you forget to change the position column?
----------------------------------------------------------------------
No. I am using a brand new spreadsheet which has been completely revamped and has a few items still to do. But I knew you would be first on the case today before I went out so posted so as not to disappoint you.
I have not bumped it up the site so far till I sort it out.
----------------------------------------------------------------------
I made a few changes to the Scottish one for this season to make it easier for me to manage
So far I have spent more time managing the spreadsheet and code than if I had left it alone
----------------------------------------------------------------------
With plenty of time on my hands these days I like to try different layouts on my spreadsheet.
I have recently had some terrific help from Emkriti who plays KOP and has given me some new methods of calculating totals ...very quickly. So that is why I am reorganising my spreadsheet.
I meant to enter your Scottish pred game seeing that you raided the KOP last season but I forgot the early weeks . I could always try chasing up the table from the bottom
posted on 21/9/18
You’d easily catch the ones at the bottom
I switched the scoring to match yours. It was previously only 5,4 and 3
Now it makes for better reward for correct score
posted on 21/9/18
Hmm, haven't won the Scottish one yet
posted on 21/9/18
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 minutes ago
Hmm, haven't won the Scottish one yet
----------------------------------------------------------------------
Cinci, Lets both give it a try and show them how its done having given them a start
I will take a look tomorrow morning at the fixtures..
posted on 21/9/18
comment by montleeds (U18330)
posted 3 hours, 27 minutes ago
comment by dublin fox optimistically pessimistic, (was london fox)(now Cambridge fox)(can not spell fox) (U1131)
posted 4 days ago
comment by emKriti (U21322)
posted 59 minutes ago
comment by Manfrombelmonty (U1705)
posted 1 hour, 11 minutes ago
Think I got every single championship result wrong! Even an infant with a crayon could've accidentally guessed more right
----------------------------------------------------------------------
Hey, who told you my method, MFB?
----------------------------------------------------------------------
no that doesn't work either
zero championship point with the red crayon this week
next week im trying dice for the championship
1,4/2,5/3,6/ score 1,2,3,
1,4/2,5/3,6/ home,away,draw !?
----------------------------------------------------------------------
everyone know it's the green crayon for the championship.
----------------------------------------------------------------------
Oh!
This adultig is so hard!
posted on 23/9/18
comment by Penshawdave (U1894)
posted 1 day, 8 hours ago
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 minutes ago
Hmm, haven't won the Scottish one yet
----------------------------------------------------------------------
Cinci, Lets both give it a try and show them how its done having given them a start
I will take a look tomorrow morning at the fixtures..
----------------------------------------------------------------------
Argh, bleedin forgot to go do it, was fired up as well
posted on 23/9/18
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 hours, 53 minutes ago
comment by Penshawdave (U1894)
posted 1 day, 8 hours ago
comment by Cinciwolf--Top ten finish? Piece of pee (U11551)
posted 10 minutes ago
Hmm, haven't won the Scottish one yet
----------------------------------------------------------------------
Cinci, Lets both give it a try and show them how its done having given them a start
I will take a look tomorrow morning at the fixtures..
----------------------------------------------------------------------
Argh, bleedin forgot to go do it, was fired up as well
----------------------------------------------------------------------
There are around 7 or so double pointers weeks PLUS you have 2 jokers to even DOUBLE a double pointer set.. With lots of weeks to come etc it is worth a shot to see how far you can get up the table.
posted on 23/9/18
Set 6 results now posted early thanks to Emkriti
posted on 23/9/18
Dave, just out of curiosity is your monthly table on a spreadsheet?
My spreadsheet has the entrants along the top with all the headings (predictions, points this round etc) and the fixtures for every set down the left side. As long as the points are entered correctly, the tab at the top (insert) is opened and after highlighting all the relevant boxes using my mouse it automatically adds the points, thus no mistakes.
I still have to copy and paste the updated league tables though, using the JA606 table format. Takes roughly an hour to manually do it that way.
posted on 23/9/18
comment by wolfieintheSunshineState (U16306)
posted 10 minutes ago
Dave, just out of curiosity is your monthly table on a spreadsheet?
My spreadsheet has the entrants along the top with all the headings (predictions, points this round etc) and the fixtures for every set down the left side. As long as the points are entered correctly, the tab at the top (insert) is opened and after highlighting all the relevant boxes using my mouse it automatically adds the points, thus no mistakes.
I still have to copy and paste the updated league tables though, using the JA606 table format. Takes roughly an hour to manually do it that way.
----------------------------------------------------------------------
Wolfie I have always wondered how you collected the entries and took out the teams and just use the score.
Do you have to re enter each one as a score?
Do you also have to enter the individual points for every scoring pred so they get added together
I collect the CODES by copy/paste straight to a fans column (10 secs for each one)
Scoring for ALL fans can now be done in 5 mins now that I have a super calculator (from Emkriti )
All my tables are produced automatically for monthly, main table. Bonus points are added automatically once I put them on.
It depends how much you are familiar with spreadsheets etc.
posted on 23/9/18
My first decent week and I still get shafted by 5 points in the H2H
posted on 23/9/18
Nae luck.
posted on 23/9/18
I copy and paste the fixtures from the BBC Sports website and edit them accordingly. On my spreadsheet I use column A for the matches i.e.
MNU v WOL and so on down the left side and add total, using 11 boxes. When the matches are finished I add the score...MNU v WOL 1-1 in the A column.
All of the participants are along the top using 8 boxes for each one.. ID, Pre. Pts T/R, C/R, jks, Pts, Bon Pts, Total pts. I then manually enter the points for each match. Then use the 'insert' box, select 'sum' after highlighting, dragging all boxes and it adds the totals automatically.
Then comes the hard part by copying and pasting the last table, creating a new article and manually correcting it according to the info on the spreadsheet.
If you have of a quicker way to automatically update the table, I'd be happy to try it.
posted on 24/9/18
42..Ginolasmane .v. Oldgoldilox....41
Oof thats a tough one to take....all the best Ginolas
posted on 24/9/18
comment by Oldgoldilox - 1 Carl Ikeme (U17303)
posted 9 hours, 33 minutes ago
42..Ginolasmane .v. Oldgoldilox....41
Oof thats a tough one to take....all the best Ginolas
----------------------------------------------------------------------
I've never been so happy about an arsenal 2 0 win! Cheers
posted on 26/9/18
Interim Scores for SET 6B
(Thanks to the new super fast calculator)
TOP SET
Tector ..41
Oldgoldilox ..33
PPLF ..32
Jukes Jake ..31
MarcusMud ..31
Somtin .31
Cinciwolf .. 30
TOP MONTHLY
Wolfie ..212
Takeaboo ..207
MarcusMud .. 201
Lily ..194
Worc Spur ..189
TOP OVERALL
Scottini ..452
MFB ..446
Worc Spur ..446
Takeaboo ..443
Wolfie ..442
posted on 27/9/18
Results posted for SET 6B
How close is that lot ?
posted on 27/9/18
Anyone else hate League Cup games?
posted on 27/9/18
comment by JukeboxJunkie (U10162)
posted 22 minutes ago
Anyone else hate League Cup games?
----------------------------------------------------------------------
You did quite well out of them with the 7th highest set score
Moi was 33rd So I hate them (this time)
posted on 27/9/18
By the way Juke, you are 1st reserves team for the 1st Round of H2HKo if anyone misses entry. !!
posted on 27/9/18
Not as much as I hate the Championship games
As PSD said at the start of the season with 3 teams coming down to it and 3 coming up along with being a league where everyone takes points off everyone then it is so hard to consistently predict
posted on 27/9/18
comment by Call Sign: Until Valhalla (U3627)
posted 2 minutes ago
Not as much as I hate the Championship games
As PSD said at the start of the season with 3 teams coming down to it and 3 coming up along with being a league where everyone takes points off everyone then it is so hard to consistently predict
----------------------------------------------------------------------
Plus... League Cup games are used by Prem teams to give their reserves a run out especially in the early rounds till it gets to the business end of last 8 teams.
posted on 27/9/18
comment by Penshawdave (U1894)
posted 1 hour, 28 minutes ago
comment by JukeboxJunkie (U10162)
posted 22 minutes ago
Anyone else hate League Cup games?
----------------------------------------------------------------------
You did quite well out of them with the 7th highest set score
Moi was 33rdSo I hate them (this time)
----------------------------------------------------------------------
Flukes it
posted on 27/9/18
comment by JukeboxJunkie (U10162)
posted 2 hours, 39 minutes ago
Anyone else hate League Cup games?
----------------------------------------------------------------------
Nah, love em
Page 4 of 16
6 | 7 | 8 | 9 | 10