The boards.ie Rugby World Cup Sweep.

Irish Wolf

Right folks.. Here we go..

1. I declare these be the rules...

Scoring:

Select the team you think will win each game and for Group Stage games, write in the margin you think they will win by.
If you think the game will be a draw then place one of the teams name in the winning team box and 0 in the winning margin.
Please note If the game does not finish a draw, points will only be awarded on the team name placed in the winning team box.

Points for the Group Stage games will be awarded as follows, ONLY if you pick the winning team.

Exact Margin 20 pts
1 - 5 points out 10 pts
6 - 10 points out 5 pts
11 - 15 points out 2 pts
16 or more out 0 pts

Points for the Knockout Stage will be awarded based on the number of teams that are correctly predicted to go through at each stage.

Quarter Finalists 20 pts each
Semi Finalists 50 pts each
Finalists 75 pts each
Overall winner 100 pts

Scoring Examples:

Group Stage:
New Zealand V Portugal. Prediction: Portugal to win by 29. Actual score New Zealand 3 - Portugal 32. (actual score predicted). 20 pts.
South Africa V USA. Prediction: South Africa 0 (i.e. a draw). Actual score South Africa 16 - USA 9. (7 points out). 5 pts.

Knockout Stage:
Quarter Finalist predicted: USA, Tonga, Wales, Japan, Romania, Scotland, Ireland, Namibia.
Actual Quarter Finalists: USA, Tonga, Canada, Wales, New Zealand, Italy, Ireland, Namibia.

5 correctly predicted = 100 pts.

Group Tables:

The tables are automatically generated based on the predictions entered. They are scored 2 pts for a win, 1 pt for a draw.
It is up to each person to ensure they predict the results that sees their preference of Quarter Finalist progress from the group stage.

Finally…

In the event of a draw - a count back of the number of exact predictions at group stage will determine the winner.
If there is still a tie - a count back of 10pts scored, 5pts scored, etc. will determine the winner.
Incomplete or incorrect entries will not be accepted. Don't forgot your name!!!
A weekly update of scores will be posted - it is up to you to ensure your score is correct.
There may still be a few bugs in the spreadsheet - so if you notice anything let me know a.s.a.p.

2. I'm not 100% sure that the spreadsheet can be attached as a PM - so if you send me a PM to let me know you want to play, then I can forward on my e-mail address for you to send the entry.

3. Anyone who doesn't have access to Excel - let me know and we'll work something out.

4. Closing date September 6th at 5:00 p.m.

Have fun, and spread the word..

carlowboy

Looks great but I have everything filled in but it just shows Goergia and Italy having played 3 games and without an 8th participan in the QF

Irish Wolf

carlowboy wrote:

Looks great but I have everything filled in but it just shows Goergia and Italy having played 3 games and without an 8th participan in the QF

Buggery! Can you save it as it is and send it on.. I'll PM my address..

Irish Wolf

No need to send it on carlowboy.. I think (and hope ) I've sorted it.. original post updated to include the ammended entry form..

Please let there be no more bugs...

Sabre0001

Looks interesting!

I like the new format of doing selecting winners the whole way through before the tournament starts - more challenging, gives an idea of potential fixtures and means that you'll have a team to cheer on through all the matches!

Now my only problem is...If Ireland get a tough draw do I go with my head or my heart?! At the moment, France v Ireland is blank a) because it is tough to call b) because even if France were much better than Ireland, I would still be hesitant!!!

An ideal would be to put Ireland all the way to the Final and for them to get there!

Good work though!!!!!

Mushy

How do I remove the password/encryption on it? When I go to open it, it says "open the document in the application where it is saved, then remove the password/encryption." But how to do this is the problem.

MGrah

Irish Wolf - this looks like a really great spreadsheet and format.

Do you have any objection (considering the work you've put in) to people using this for sweeps outside of boards? i.e. would you mind if I forwarded it on to a few friends and colleagues to use for our own little sweep?

JenK

hey Irishwolf,
looks great il give it a shot and pass it on to some rugby heads who are abroad for the Cup this year.

Irish Wolf

Mushy wrote:

How do I remove the password/encryption on it? When I go to open it, it says "open the document in the application where it is saved, then remove the password/encryption." But how to do this is the problem.

Hmmm.. not too sure about that - I've only got a regular spreadsheet protection password on it - no encryption..

Try it again Mushy - and if you can't get it working PM me and I'll forward one without the password set..

Irish Wolf

MGrah wrote:

Irish Wolf - this looks like a really great spreadsheet and format.

Do you have any objection (considering the work you've put in) to people using this for sweeps outside of boards? i.e. would you mind if I forwarded it on to a few friends and colleagues to use for our own little sweep?

Yup - no problem.. I'm working on a master spreadsheet that will contain all the predictions and do the calculation of points automatically.. So if you wait a week or so, maybe that'll be more useful..

MGrah

Irish Wolf wrote:

Yup - no problem.. I'm working on a master spreadsheet that will contain all the predictions and do the calculation of points automatically.. So if you wait a week or so, maybe that'll be more useful..

Fantastic - if you wouldn't mind posting it when you're ready with it, that'd be great. thanks!

daveirl

This post has been deleted.

Irish Wolf

daveirl wrote:

This post has been deleted.

Tough one to call .. When you've figured out the winner - send on your entry...

Don't worry - I'll allow as many changes as you want up to the 6th Sept.. just in case O'Driscoll or Habana get flattened in any warm-ups..

Irish Wolf

Hmmm.. another little gremlin in the spreadsheet - the drop down list for the knock-out stages didn't appear to be working but I've sorted it now..

If you've already saved a copy of the entry - there's no need to update it... I'll review each entry as it comes in anyway..

Nukem

Top notch effort - excellent work Irish Wolf

Sabre0001

daveirl wrote:

This post has been deleted.

Bah! Fiji v Georgia all the way!

komodosp

Please note If the game does not finish a draw, points will only be awarded on the team name placed in the winning team box.

Does this work the other way around? If you predicted a win by 5 points and it finishes a draw, do you get the points?

Irish Wolf

komodosp wrote:

Does this work the other way around? If you predicted a win by 5 points and it finishes a draw, do you get the points?

It does indeed.. If a game ends in a draw - people will get points for either team provided they are within the 15pt limit..

besty

Great work Irish Wolf.

Do you want us to email our entries to you or what?
I have France to beat Ireland in the final! I followed my heart in the QF against the All Blacks.

Irish Wolf

besty wrote:

Great work Irish Wolf.

Do you want us to email our entries to you or what?
I have France to beat Ireland in the final! I followed my heart in the QF against the All Blacks.

Thanks besty - I'll PM my email and you can send it on..

dulpit

Top job, interesting way of doing it as well... Looks like I have an Australia win predicted, dunno about it but hey? What you gonna do?

Steffano2002

Hi Irish Wolf!

I've filled the s/sheet at last! Could you PM me your e-mail address please?

I have France to beat Australia in the final... Yeah, I know... "Keep dreaming Steffano!"

Irish Wolf

Steffano2002 wrote:

Hi Irish Wolf!

I've filled the s/sheet at last! Could you PM me your e-mail address please?

I have France to beat Australia in the final... Yeah, I know... "Keep dreaming Steffano!"

PM sent - thanks and best of luck

Steffano2002

I don't need luck Wolf! What I predicted is going to happen!

I'll send you that s/sheet tomorrow (going to go over it one last time).

Steffano2002

Oh and I forgot to say that I think the mods should make this tread a sticky to get as many people to join!

Irish Wolf

Steffano2002 wrote:

I don't need luck Wolf! What I predicted is going to happen!

I'll send you that s/sheet tomorrow (going to go over it one last time).

Ok.. once you come to a firm decision what will happen.. let me know..

I didn't wan't to mention the sticky.. as I know "virtual estate" is limited - but it would make things a bit easier to find and update the post..

**nudge** @ the mods..

Irish Wolf

For anyone that wants the main spreadsheet for a work/group sweep - I've pretty much got it finished just need to test it on Monday.

Provided it's a not for profit situation - post your interest in thread - and I'll contact you

bernardcat

Sounds great fun. Working on my predictions. Cheers

Jackz

Irish Wolf can i get your e-mail for my entry, I guess you abandoned the pay to play idea?

Irish Wolf

Jackz wrote:

Irish Wolf can i get your e-mail for my entry, I guess you abandoned the pay to play idea?

Yeah - it would have been way too much hastle with fees etc., but hopefully this will still be a bit of fun..

PM on its way..

Steffano2002

Thanks for making this a sticky Mods!

Hopefully loads of people will participate!

Irish Wolf

Steffano2002 wrote:

Thanks for making this a sticky Mods!

Hopefully loads of people will participate!

Yup - thanks for the sticky folks...

Now Steffano - where are those predictions? Or are you still polishing your crystal ball?

Steffano2002

Irish Wolf wrote:

Now Steffano - where are those predictions? Or are you still polishing your crystal ball?

Still polishing me balls alright Irish Wolf!

Seriously though, I haven't been home in a few days so I'll go over my predictions one last time tonight and send them on to you!

PM me yer email addy there will ya wolf? Cheers

Hamo

Great job my friend, I went completly with teh heart Ireland ALL the way..!!:D

Irish Wolf

Spotted another little bug in the spreadsheet - it won't affect anything provided you haven't predicted a draw for the any of the final 3 group games..

Any entry I've recieved so far thankfully doesn't have this scenario - but just in case any of you are thinking along those lines.. then please use this updated version of the entry..

If one of our friendly moderators could update the attachment in post #1 as well, it should avoid any further confusion

daveirl

This post has been deleted.

Irish Wolf

daveirl wrote:

This post has been deleted.

Thanks daveirl - at least it points to the updated sheet - so it's cool..

Punchbowl

I want to submit mine too guys, btw isn't there bonus points at the world cup?

Irish Wolf

Punchbowl wrote:

I want to submit mine too guys, btw isn't there bonus points at the world cup?

There is indeed - but for the sake of making my life easier when coding up the form - I made an executive decision to ignore the bonus points for the sweep..

I'll PM you my email address now..

gerire

Irish Wolf wrote:

Tough one to call .. When you've figured out the winner - send on your entry...

Don't worry - I'll allow as many changes as you want up to the 6th Sept.. just in case O'Driscoll or Habana get flattened in any warm-ups..

So it was you who Jinxed him......

Great Job IW, can you pm your email address please

jimmyboy

Can you PM your E-mail address please? Cheers

Nukem

Can i get you e-mail too please?

Ginger

Great job Irish Wolf.. is this ok to send to my work collegues or do i need a different version. Its a just for fun, but if we do decide cash.. i am sure a donation could be made

Irish Wolf

gerire, jimmyboy, Nukem, and Ginger - PMs sent..

Best of luck

scaramanga

Nukem wrote:

Can i get you e-mail too please?

me too please

randomname2005

me too please Irishwolf

Punchbowl

I may need to reconsider my predicted winner after last nights game...

Irish Wolf

scaramanga and randomname2005 - PMs sent..

Reconsider away Punchbowl - plenty of time yet to make up your mind

yogidc26

How cool is irish wolf can I get you email to send it on to you

Thanks

Steffano2002

How many people have joined so far Irish Wolf?