Bay 12 Games Forum

What goes around comes around

Because I felt the nostalgia of posting it here after such a long time and I still receive the odd email here and there with requests...

Here it goes:

----------------------------

Hi,

Since 2010, I've been making spreadsheets for the Euro and World Cup to compete with my friends and coworkers with the tournament predictions. 

I've made a hacky Excel 8 years ago and it still does it's job well enough today.

# Download links for the impatient

You can download the spreadsheet from the following links or copy the link to your own Google Drive:

[XLSX (Google Drive )]
[ODS (Google Drive)]

Alternatively, you can use 4Shared to get it:

[ODS (4shared)]
[XLSX (4shared)]

I intend to explain the logic/functions in my blog later on if people are interested.

# What problems does this spreadsheet solve:

- Be offline at all times (Complete privacy).

- No scripting or macros.  Just plain old excel formulas that require no user privileges.

- Be able to enter the predictions of many participants.

- Be able to specify how many points a participant wins for guessing the outcome and how many for guessing the exact score.

- Have the rankings and standings be updated automatically and correctly.

- Handle the possibility of PKs.

- Give people the possibility to localize the spreadsheet if they're so inclined.

- Protect the spreadsheet cells that shouldn't be modified to breakage by user mistakes.

Enjoy and post your predictions!

--------

For those completely out of touch... No, USA did not qualify... 

Hi, my name is Alex and I've been unmafia'd for 4 years (irc patches don't count).

The resolve is weaker and every day, is a day I need to fight the urges... A new day without mafia...
But then I remember Webadict, who was always scum and didn't always get what he deserved.  And it gets easier.
It's fun seeing some of the old wretched, scummy, undesirable, unscrupulous hags around here...
Never trust a user just because he has been long... Never trust him because he sounds reasonable, in fact, the more reasonable that these guys sound, the more you should lynch them... every game, for whatever reason:

Leafsnail, Vector, Webadict, Cheeetar, Toonyman and anyone that has acquired reknown, for whatever reason...

If they start raging... They're scum.  And If they don't, they're useless as power players... Lynch them soon and often! 
Heed my words. 

Godspeed.  I was never here.

I just received this from Gog's newsletter.  Thought some of you might find it interesting.

Baldur's Gate 1 & 2, Icewind Dale, Planescape: Torment, NWN, and more D&D games up to 65% off.  (I think they're all 3,49 us$)

http://www.gog.com/newsletter/hasbro_stacking_promo?utm_source=newsletter&utm_medium=email&utm_content=game_subject&utm_campaign=hasbro_stacking_promo

I already have P:T but I'll probaby get BG 2 (to play on a distant, less busy future )

Quote from: Alexhans on July 27, 2012, 12:09:00 am

Anyway.  Can someone explain to me how I can manage to exceed expectations with a team that was meant to be 9th (in a 10 team league) and then when everything seems to be going peachy and I have an almost perfect away form and came back from beating 2nd placed team 5 0 (biggest win so far, unexpected) I get so cocky I end up losing 4 0 against the currently 8th team?  What is WRONG with me!  Board confidence was almost flawless and now I have that ugly record...).

In my Welling United save, I won the Champion's league last year, yet I will sometimes lay an egg against the 15th place Premier League team.  Try and keep your player morale up (using 'Passionate' and 'I have faith' works well for me), have a chat with them if they have a few bad games in a row.

Basically even the best team Can and will get complacent. Yell at them after a stupid loss and then move on. How'd you lose, specifically? Did their formation not play well against yours? Better players? Own goals?

I always talk to my players to get them motivated happy or at least focused but it was mainly a problem about tactics.  You see, I'm still a worse team than the others and the predictions of my away games are that we will lose or draw.  In this case, it was a draw against slightly favorites St. Pats.  But knowing they were generally sucking and that I had won all but 1 away games I came out with my standard formation (not thinking that much about defending).  They scored early on and instead of handling it like an adult I just lost it and went for attack.  Then condeded another goal before the end of the half time and kept rushing my decisions.  I just wanted the match to end at some point and didn't focus on saving my ass.  Kept attacking (or on standard and pushing up) and received 2 more goals near the end.

I yelled at them aggressively, that's for sure.  Fortunately, we are mostly back on track.  Despite a couple of close draws.

I tried 5-4-1 counter attack in pre-season but we were awful so finally switched to 4-4-2 with a forward that keeps saving my ass with his dribbles and holding the ball and a not very agile but efficient poacher.  I went on holiday once because my main forward had sustained an injury and I was out of ideas and my manager played an interesting 4-5-1 that I adopted as a backup tactic from then on and it has worked interestingly well in a couple of shrewdly played matches.

Having a less-fortunate team in terms of players, I'm trying hard on the scouting parts of the game, to find suitable players to develop and a couple of them seem to pay off.  Training is also high unless the players are specifically unhappy about it (and focused on def, mid or forw although I'm likely to specialize something for wingers soon).  After the good run, I've changed my objectives to reach an european competition (looking good) so now the wage budget doesn't look so utterly sad and I convinced the board to increase the number of coaches to 4

Coaches I can pay are not too good though.  Oh, and I'm only playing with the Irish league active because I wanted a fast game.  I don't know if that might've made things easier in the long run (lack of impressive players from other parts of the world?)

I think it has to do with a perceived status of vulnerability we don't find in, say, young/adult males.

I do hate the emphasis though.  Specially when you're talking about collateral damage in wars and stuff like that and you pretend that just for being male (and not kids) it's somehow justified or that they're less innocent.

I'm just going to leave this here and hope it wasn't posted here before.

Quite interesting and quite impossible.  I've heard it before and it makes sense but media will argue that people are interested and want to know (viewers will sort of prove them right) and financially it makes so much sense.

Then there's the whole issue of being able to use it as a wildcard to talk seriously about anything and making whoever doesn't want to comment on the issue look insensitive.

Crisis and opportunity.  Massacres are one hell of an opportunity.

I own GTA IV and loved it but have never played online.  Should I start downloading? 

Are there enough numbers or do you need to join with friends?

Quote from: Catastrophic lolcats on July 16, 2012, 10:32:31 pm

Lottery tickets are a tax on the stupid. 

Stupid, or unlucky?

Are you unlucky if you try to swim from America to Africa and you drown in the process?