sawtooth
Tour Winner
Cheers Stu:thup:
Switzerland 1-4 France , was that a mistake?
Switzerland 1-4 France , was that a mistake?
Euro 2016 Prediction Competition
- Thread starter sawtooth
- Start date
Region3
Ryder Cup Winner
Latest sheet with Brians predictions.
https://app.box.com/s/3ya7nbi60g3v39r2qpa63lnhxxax9874
Leaderboard workbook looks like its gone a bit awry but I'll will ask the originator of the sheet to take a look, or find someone who knows about Excel
It looks like Col.V on the table page needs updating with the correct names, as the errors are occurring because a formula is looking for a name in that column and can't find it.
It also looks like there's something gone wrong with Col.A on that page, but not fully understanding the sheet I could be wrong.
sawtooth
Tour Winner
Thanks , I sent you a PM with some instruction that had been passed to me. Spreadsheets are not my strong suit but If you have any time to take a look that would be great. Else don't worry.
As it stands it works for totalling up the points its just about tidying it up so that the sheets show just the entrants from here on it.
As it stands it works for totalling up the points its just about tidying it up so that the sheets show just the entrants from here on it.
sawtooth
Tour Winner
Cheers Gary for helping with the spreadsheet. Its looking tidy now, I've added some bogus results to see that the calcs are working nicely. :thup:
https://app.box.com/s/uqb8b5mna1a4hjw8u6keqbiqd6akjqk7
We have 8 people, the more the merrier £10 to enter your predictions and (£80 prize fund so far)
https://app.box.com/s/uqb8b5mna1a4hjw8u6keqbiqd6akjqk7
We have 8 people, the more the merrier £10 to enter your predictions and (£80 prize fund so far)
sawtooth
Tour Winner
Received some money and predictions OK gents , still waiting on a few more. Deadline Wednesday .
Piece
Tour Winner
Mine done, hopefully correctly! :thup:
sawtooth
Tour Winner
Thanks Matt.
Still waiting on LP, Fundy and Rooter for scores and money!
Plenty of time for more to join in just predict your scores and send over a £10.
Farneyman
Tour Winner
Will get mine in before Wednesday.
sawtooth
Tour Winner
Cheers
Payment made, let us know when you get it 👍🏻
Farneyman
Tour Winner
Can you PM payment and email details.
Ta
Ta
sawtooth
Tour Winner
You need to clear messages Farneyman I tried to PM you payment and email details.
No hurry as long as have everything before Thursday. I would like to post up the final sheet on Friday locked and loaded with predictions from everybody.
I think we have 8 which is pretty measly but at least more chance of winning lol.
Rooter
Money List Winner
sorry sean, not going to have time to do this, good luck all!
sawtooth
Tour Winner
No worries Scott , it only took me 5 mins to add my scores though , maybe I should have taken more care!
Might just have the prize for 1st place now as there is £70, If the others agree.
Might just have the prize for 1st place now as there is £70, If the others agree.
drewster
Tour Rookie
Is iot too late for me to join in chaps ? If not , please PM me details and i'll get the cash and predictions over . thanks Andy
sawtooth
Tour Winner
The more the merrier, I will pm you drewster.
drewster
Tour Rookie
£10 sent , please confirm receipt. Have replied to your PM too. Thanks for having me !!!!!
sawtooth
Tour Winner
Its here https://app.box.com/s/tzr8jgcw51fuces4d7xet1o27rp2o470
Just make sure that you don't have 10 or more of the same result the spreadsheet checks this for you at the bottom anyway. Redo if its not "ok".
Then just email back the spreadsheet with the inputted scores.
I think i was quicker than that, ha ha.
More chance of winning the lottery me thinks!!
