- Forum
- EVENTS & COMPETITIONS
- OFFLINE
- Sensible Days - SWOS World Cup
- Sensible Days 2019 - Fulda, Germany
Sensible Days 2019 - Fulda, Germany
- Rock and Roll
- Offline
- Moderator
Less
More
- Posts: 2485
- Thank you received: 1
5 years 3 months ago #141526
by Rock and Roll
Replied by Rock and Roll on topic Re: Sensible Days 2019 - Fulda, Germany
Busy working on the spreadsheet before sending it to Hawkz for tweeks, cosmetics and overall improvements.
Seeing as we re going to have 6 groups NO MATTER WHAT, I ve programmed 10 possible pots.
So 6 groups with 10 players max. The spreadsheet can be easily adapted for less than 10 in the groups.
It has an automatic fixture set, but if we prefer we can enter the fixture list per group which swos generates, just
before the tournaments get under way.
Got a random draw in, result entering, automatic league tables, automatic calculating qualifiers for Master, Super,
Repecharges, KOs all seem to work. Just need a cosmetic polish, and a KO tree.
Busy programming a page for automatic best attacker / best defender but I have some questions first.
- Can a Bacon/Onion/Cucumber/Sauerkraut etc etc qualifier win best attacker / best defender?
I m inclined to not allow these matches to count towards best defender / attacker.
Can these matches count? Or do only the matches these players played in the groups count?
Or must you finish in the top 4 of your group to be eligible for best defender / attacker?
- Is the best defender / attacker still the player with the best average?
Previous editions we ve always used the average = goals / matches played to determine the winners.
Yet again the question; does anything else need to be put in the spreadsheet?
I hope to finish the boring stuff this week .
Seeing as we re going to have 6 groups NO MATTER WHAT, I ve programmed 10 possible pots.
So 6 groups with 10 players max. The spreadsheet can be easily adapted for less than 10 in the groups.
It has an automatic fixture set, but if we prefer we can enter the fixture list per group which swos generates, just
before the tournaments get under way.
Got a random draw in, result entering, automatic league tables, automatic calculating qualifiers for Master, Super,
Repecharges, KOs all seem to work. Just need a cosmetic polish, and a KO tree.
Busy programming a page for automatic best attacker / best defender but I have some questions first.
- Can a Bacon/Onion/Cucumber/Sauerkraut etc etc qualifier win best attacker / best defender?
I m inclined to not allow these matches to count towards best defender / attacker.
Can these matches count? Or do only the matches these players played in the groups count?
Or must you finish in the top 4 of your group to be eligible for best defender / attacker?
- Is the best defender / attacker still the player with the best average?
Previous editions we ve always used the average = goals / matches played to determine the winners.
Yet again the question; does anything else need to be put in the spreadsheet?
I hope to finish the boring stuff this week .
Please Log in or Create an account to join the conversation.
5 years 3 months ago #141527
by xflea
Replied by xflea on topic Re: Sensible Days 2019 - Fulda, Germany
hey Rock, could you send me this excel file to This email address is being protected from spambots. You need JavaScript enabled to view it. to have a look and beta testing? :)
Please Log in or Create an account to join the conversation.
Less
More
- Posts: 9603
- Thank you received: 190
5 years 3 months ago - 5 years 3 months ago #141528
by Playaveli
Replied by Playaveli on topic Re: Sensible Days 2019 - Fulda, Germany
*c p from whatsapp:
I think we should stick with averages.
And every match should count for that, no matter if cucumber or master group.
Alcohol can be involved, that is part of it, and part of the humor.
As long as the rules are followed (eg: no own goals on purpose etc) everything is fine.
Do not hassle... just count all the matches which are also entered on website.
So, yes, EVERYONE can be best goal scorer or defender, no matter which route of the tournament he will take. Master or Sauerkraut... every match counts!
We ll stick with averages!
Great work, Rock. Really awesome! Looking forward to using that spreadsheet.
Please share it with me when it s done, so I can do some tests. *edit* just saw your message on FB. Thanks!
Question ahead:
Will a player be drawn from a pot on one s button click? To simulate opening the surprise egg? That would be essential...
I think we should stick with averages.
And every match should count for that, no matter if cucumber or master group.
Alcohol can be involved, that is part of it, and part of the humor.
As long as the rules are followed (eg: no own goals on purpose etc) everything is fine.
Do not hassle... just count all the matches which are also entered on website.
So, yes, EVERYONE can be best goal scorer or defender, no matter which route of the tournament he will take. Master or Sauerkraut... every match counts!
We ll stick with averages!
Great work, Rock. Really awesome! Looking forward to using that spreadsheet.
Please share it with me when it s done, so I can do some tests. *edit* just saw your message on FB. Thanks!
Question ahead:
Will a player be drawn from a pot on one s button click? To simulate opening the surprise egg? That would be essential...
Please Log in or Create an account to join the conversation.
5 years 2 months ago #141539
by ElMichaJ
Hey Hey Hey .... El Micha J !!!
Replied by ElMichaJ on topic Re: Sensible Days 2019 - Fulda, Germany
cinek ebster and fulgore added
Hey Hey Hey .... El Micha J !!!
Please Log in or Create an account to join the conversation.
5 years 2 months ago #141556
by ElMichaJ
Hey Hey Hey .... El Micha J !!!
Replied by ElMichaJ on topic Re: Sensible Days 2019 - Fulda, Germany
Boesjesman + visitor Nakkeost + visitor Swoozh confirmed
3 places left ^^
3 places left ^^
Hey Hey Hey .... El Micha J !!!
Please Log in or Create an account to join the conversation.
Less
More
- Posts: 9603
- Thank you received: 190
5 years 2 months ago #141558
by Playaveli
Replied by Playaveli on topic Re: Sensible Days 2019 - Fulda, Germany
Had a phone conference with Micha yesterday.
We ve decided to NOT play an XBOX tournament for good reasons:
- Not sure about hardware
- Not sure about adapters
- Relax the schedule for everyone
- Too much hassle
Best goalscorers will be awarded with the CANON, as it is a German tradition in real football (Bundesliga)!
We ve decided to NOT play an XBOX tournament for good reasons:
- Not sure about hardware
- Not sure about adapters
- Relax the schedule for everyone
- Too much hassle
Best goalscorers will be awarded with the CANON, as it is a German tradition in real football (Bundesliga)!
Please Log in or Create an account to join the conversation.
5 years 2 months ago #141561
by andib
Replied by andib on topic Re: Sensible Days 2019 - Fulda, Germany
Fine with me, Playaveli and Micha.
It was almost too much in Almelo and even worse without adapters.
It was almost too much in Almelo and even worse without adapters.
Please Log in or Create an account to join the conversation.
5 years 2 months ago #141562
by ElMichaJ
Hey Hey Hey .... El Micha J !!!
Replied by ElMichaJ on topic Re: Sensible Days 2019 - Fulda, Germany
dzemandowski confirmed
Hey Hey Hey .... El Micha J !!!
Please Log in or Create an account to join the conversation.
5 years 2 months ago #141565
by ElMichaJ
Hey Hey Hey .... El Micha J !!!
Replied by ElMichaJ on topic Re: Sensible Days 2019 - Fulda, Germany
makoto added for amiga
Hey Hey Hey .... El Micha J !!!
Please Log in or Create an account to join the conversation.
5 years 2 months ago #141574
by ElMichaJ
Hey Hey Hey .... El Micha J !!!
Replied by ElMichaJ on topic Re: Sensible Days 2019 - Fulda, Germany
Pallister confirmed
Hey Hey Hey .... El Micha J !!!
Please Log in or Create an account to join the conversation.
- Forum
- EVENTS & COMPETITIONS
- OFFLINE
- Sensible Days - SWOS World Cup
- Sensible Days 2019 - Fulda, Germany
Time to create page: 0.245 seconds