Showing posts with label poss. Show all posts
Showing posts with label poss. Show all posts

Thursday, July 4, 2024

Issue # 5.2.1 "Great Entrées with Some Swiss and Turkey" (After Round of 16)

 Archive

Wednesday, July 3, 2024
[Dailies: Jun 29-30 Jul 1-2 ]

QUARTERFINALS FEATURE BIG MATCHUPS
Disabling Below Jobs leads with 83 pts; Two get 7 QF teams correct

QuarterfinalsFALLBROOK, CA (smt)- The quarterfinals will feature some great soccer nations with 3-time Euro (3xEuro) and one-time World Cup (1xWC) champion 1B-Spain, 3xEuro and 4xWC champion 1A-Germany, 1xEuro champion 1F-Portugal, 1xEuro and 2xWC champion 2D-France, 1xEuro champion 3D-Netherlands, and 1xWC champion 1C-England.  Tossed in with these 6 in the quarterfinals are 2A-Switzerland and 2F-Türkiye.

Group D missed getting three teams in the quarters as 1D-Austria's rally came up short to TUR, 2-1, in a rain-filled back-and-forth match.  The other group winner who failed to advance was 1E-Romania who got trounced by NED 3-0.  GER and SUI picked up 2-0 wins while FRA got an own goal to beat 2E-Belgium 1-0, ending that golden generation.  FRA is in the QF having only getting 3 goals, 2 by own goal and 1 by PK.  Cinderella #74 3F-Georgia had an early 1-0 lead thanks to an own goal but finished with zero shots on goal in a 4-1 loss to ESP.

Saturday, July 3, 2021

A Missing $ Sign

Should be $E$79:$E$80
Just a heads up that I found an error in my Excel file which affected a few entries that had ENG in the Semis but didn't get the points... ended up that a missing $ sign (which keeps row the same if you move different rows, but didn't as I moved a row down in this case) in the equation didn't carry over for the last few columns, which mainly affected Fantasy.  Thus, Fantasy essentially takes over my Glory to the Heroes pick, and finishes 4th in the scenarios I thought I would finish 4th for.  Thus, I had false hopes for a few days ;-)  The only other change is that Spermicidal FC (who would've had to win a 3-way tie for 4th if DEN>ESP in final) joined me, leaving 11 entries still alive instead of the original 12.

We still have the same 5 who can win the pool.  Daily update later tonight and then the email update tomorrow.  

BTW, I also fixed my possibilities Excel macro which should reduce the time to run the 32K scenarios after the Group Stage from 12-20 hours down to 1-4 hours, depending on PC resources.  So I may go back and edit the possibilities with this small correction.  I hope now I have tailored my Excel file for 24/32 team tourneys but it will have to chance in 2026 when the World Cup goes to 48 teams (hence, another reason I am not keen in doing the Copa or Gold Cups -- too random that small programming errors to adjust for special tourneys frustrate me!).

Have a safe and happy Independence Day weekend!

Friday, June 25, 2021

Elimination Station & Round of 16 Preview

Unlike our HWCI NCAA pools, these soccer pools are not run on software but in Excel.  As such, I created a quick brute force method of calculating the 32,768 possible outcomes is done which is extremely slow (or there is an Excel macro setting I'm not toggling), taking more than 12 hours.  Of course, after tomorrow, that will be cut by 75% (just 8,192 outcomes) so it's really this first run after the Group Stage is complete that takes forever and making any corrections (forgetting to set the correct # of entries), means doing it again.

And what an unexpected result... no one is eliminated from the top 4 money prizes.  Zero.  This is a pre-determined non-elimination leg.  But if you think about it, with the top 14 teams making it plus 26% and 37% picking WAL and CZE, everyone's bracket is in good shape and most will pick different outcomes going forward.  Unless you are like my pick Futbol Fabone Twelf (can only win 4th), whose FRA over POR final is the same as four others and far behind in the standings, you have less margin for error).  But hey, a 0.06% chance to win something is better than Otsego2 who has a 0.05% chance (16 in 32,768).  Slyelf has the best chance to win money at 42.1% with FrankfromSeattle (29.9%), Club Med (24.6%), and NoFixing (21.9%) all having better than a 1 in 5 chance.

In the race to become the 3rd HWCI EURO Pool champion, 43 entries have a chance with Slyelf with a 15.2% chance to win it all with FrankfromSeattle next at 10.1%.  Remember, these possibilities include ties, so a positive outcome is being tied for 1st but you could still lose the tiebreaker (total goals in semifinals and final) and finish 2nd.  Same with overall, you are only guaranteed to finish at least a tie for 4th but you can lose the tiebreaker and end up with nothing.

You can always find the "Possibilities" tab in the main menu next to "Standings".

The Knockout stage begins tomorrow and the upper bracket features #1 Belgium, reining Euro champ Portugal, everyone's favorite France, very hot Italy (undefeated in 30 straight), and three-time Euro champion Spain.  The bottom bracket features a Germany team six minutes from elimination and a lame duck coach and an England team that has only scored twice (13 teams scored more than 2 goals in ONE match).  But both play each other, providing a winnable route to the semifinal for Netherlands, Czech Rep, Wales, or Denmark.  ENG is the only team that will play at home (London) as home teams went 13-7-4 in the group stage.

In other oddities, we already have more PKs awarded (14 - five via VAR) and own goals (8) in the Euros ever.  French fans mistook Budapest for Bucharest and traveled there by mistake for the 3rd match but they could extend their stay as that is where France will play Switzerland.  Although it looks cool, UEFA correctly blocked Munich from lighting it up as a disagreement to Hungarian law (yes, they were playing HUN) as political statements are not allowed (hence, my nickname Glory to the Heroes which was also blocked by UEFA on Ukraine's jersey since when combined with Glory to Ukraine, was a rallying cry) - had Munich wanted to light up the Rainbow Stadium for all 3 matches to support LGBTQ+ month, I'm sure that would've been okay and UEFA did allow the German GK to wear a rainbow captain's armband.  Cristiano Ronaldo is one goal way from the International record (he's at 109).  While Ronaldo is 3/3 on PKs, the rest of the players are 5/11.  A European tournament meant Poland traveled 2,200 miles twice (Seville, ESP to St. Petersburg, RUS) while Switzerland (Rome, ITA to Azerbaijan, AZE; and now to Bucharest, ROU) and Belgium (Copenhagen, DEN and St. Petersburg, RUS; now to Seville, ESP) are logging lots of miles as well.  SUI, however, will have 3 extra days rest than FRA.

Edit (7/3): Small correction to my Excel file... there were 40 who could win pool (not 43) but all 49 were still alive.

Thursday, June 24, 2021

Issue # 4.1.3 "Everything That Has Transpired Has Done So According To My Design" (6/24)

Thursday, June 24, 2021 - [Dailies: 20-21-22-23]

NOT MANY SURPRISES IN THE ROUND OF 16
Slyelf
 in 1st as six get 15 of 16 R16 teams correct; all 49 entries still alive

Round of 16CERRITOS TENNIS CENTER, CA (smt) - Was it so predictable?  Everyone seemed to know F2-Portugal, F3-France, and F4-Germany would make the Round of 16.  But a wild ride to get there with GER six minutes from being eliminated.  Of course, D1-England would win their group.  But with two lackluster 1-0 wins and scoring just two goals?  It seems the only real surprises were D4-Czech Rep and A3-Wales making the cut.  Could be the strongest Round of 16 we've seen.

A2-Italy, B3-Belgium, and C1-Netherlands won their group with max of 9 points while D1-England and E2-Sweden won to get to 7 pts.  A4-Switzerland and D2-Croatia each won 3-1 to secure their R16 spot while B1-Denmark routed B4-Russia 4-1 to claim 2nd on goal differential over B2-Finland, who missed the cut.  C3-Austria beat C2-Ukraine 1-0 to take 2nd but UKR still snuck in as the last 3rd place team.  Power teams needing results got them as a fun E1-Spain routed E4-Slovakia 5-0 (SVK's GD got hammered and missed the cut), F4-Germany had to rally twice against F1-Hungary (2-2 draw), and F2-Portugal got 2 PKs from Ronaldo to tie F1-France 2-2 to advance (though POR would have had advanced if they lost by a few as long as HUN didn't win... but HUN was leading for most of the match).

The only group winner that was a surprise was

Wednesday, July 6, 2016

Ronaldo on a roll

Ronaldo's 9th Euro goal (ties record)
Sometimes, things just line up.  A late stoppage time goal by 2F-Iceland knocked 3F-Portugal to third and put the Portuguese in the upper bracket with no giants (e.g., ENG, ESP, FRA, GER).  They even avoided BEL thanks to 1B-Wales.  After needing a late OT goal to beat 1D-Croatia and a PSO to beat 2C-Poland, POR could've settled for another regulation tie.  But after a listless first half, Ronaldo struck with a brilliant header off a corner kick and less than three minutes later, a Ronaldo shot was re-directed in by Nani and Portugal controlled the rest of the match winning 2-0 over the Welsh.  Will Ronaldo do what Messi couldn't do and win a title for home and country at the world stage?  Will Ronaldo quit the national team if he loses in the final like Messi?  Will Portugal finally go back to their traditional red and not the green glow/night shade jersey?  It was a nice run by Wales and with Iceland out, only traditional powers 1A-France, 1C-Germany, and Portugal remain.

Portugal's win was picked by 5 entries and this also meant we won't know who will win the pool until after the final on Sunday!  Travel Bug (who was 26th before the Round of 16 matches) moved into 1st (89 pts) while

Monday, July 4, 2016

France explodes, dashing Icelandic dream

Vive la France!
For some reason, when I woke up to an alert that there was an explosion before the 1A-France/2F-Iceland match, I thought I read the match was postponed.  So a noontime belated Father's Day lunch in Pasadena (Lunasia Dim Sum) with my in-laws wouldn't interfere with the match after all.  As we got there just before noon, I noticed the restaurant was playing the match and the pre-game looked legit.  Then I confirmed I misread the alert and the match was taking place as planned.  While the first-level had a couple of large HDTVs playing the match, we were in a more private area on the top level with no TVs.  But not to fear, an iPad Air 2 streaming the match thanks to Verizon's UDP (unlimited data plan) hotspot on my new Moto X Pure Edition, and I never missed a beat.  Even the waiters were coming over to watch the match with me!  Oh, and thanks to my wife's sister for getting me a Euro 2016 France shirt while she watched the opening match at the Eiffel Tower.  

As for the match itself, France starting strong and unlike England or Belgium, continued the pressure and exploded for four goals in the first half.  But give Iceland credit, as they

Friday, June 24, 2016

No Brexit for Euros, but are Youexit in pool?

Only the Scots not at the party.
Wow, crazy that Great Britain will no longer be a part of the European Union.  But they can take solace that except for Scotland, who didn't qualify for the Euros and almost voted to secede from Great Britain a couple years ago, Wales, England, and Northern Ireland are still alive in Euro 2016.  And might as well get Ireland in there as well.  Just those Scots...

So Brexit happened, but did Youexit happen?  With 27 entries and a more wide open Euro than usual, only one single entry has been eliminated (unofficially, haven't had the time to thoroughly verify as it took many hours to run the simulation) -- Cheesy Grits FC.  Alas, his France over Spain final was a popular one (5 did this) which meant not a lot of points to pick up to try to move from 25th place.

You will also notice there is a "Possibilities" option in the top menu now.  There were 32,768 possible outcomes and this link will let you know how many of those you could win the pool and how many you could win money (finish top 4).  JBueno, with a 5 point lead, has the best shot at winning money (80.3%) and the pool (47.3%).  Four others (BigRedMessi2, Big Blue Game of Two Halves, Jurpa FC) have at least a 35% to win money.  21 of 27 can still win the pool.


Sunday, June 24, 2012

Final Four Teams, 8 Final Scenarios

Well, I was wondering if we'd have an interesting final week in the pool since everyone seemed to pick ESP or GER but with POR and ITA in the mix, no one is guaranteed money.  In fact, no one will win the pool until the winner of the Final is determined.  There aren't as many "tied" scenarios as I hoped but there are a few.  Remember, for the tiebreaker, it's only goals scored in regulation or overtime (the "official" score) and does not include penalty kick shootout (PSO) goals.  So today's match would be "0" goals as the official score is 0-0 (not 6 with PSOs).  

So there are four people who will win the first HWCI EURO Pool.  All will have to root for their team depending if Portugal (Charles D's Sisyphus), Germany (Brian S's Flying Elvi), Spain (Ricardo A's SalsaKing), or Italy (Bernice P's Adivinanza) wins the 2012 EURO.  Below are the final 8 scenarios and how the 13 entries can win money:

Saturday, June 23, 2012

The Champs Roll On

I haven't really seen the Spain-France match yet, caught some sniplets, and then the ending as a French player rolled over a Spainish player in the box for only the tourney's 3rd PK (and 2nd made) to punctuate a 2-0 victory.  Not sure if France were just outplayed, unlucky, or just being French.

More later, but as for the pool, no change at the top with Tuan, who lost his champ France, can't win 1st.  SiemkoStrimkoPlinko!, RunnerLuis, and Wampa are now eliminated.

Wednesday, June 20, 2012

Issue # 5.1.3 "Familiar EURO Field..."

Wow, what a tourney thus far.  In the end, don't the 8 teams look like they should be there in the EURO knockout stage (except for Czech Republic)?  But now, who is still alive in the pool? 


FRANTIC FINISHES AS KNOCKOUT STAGE SET
Tuan and The Flying Elvi on top as 20 are still alive

SiemkoStrimkoPlinko! Not Yet Stinko!

Thanks to the crazy France pick to win it all, my second entry is still alive, though after watching the French play, not for long.  Here are my 16 possible winning outcomes (note that "2" could mean tied for 2nd):

SiemkoStrimkoPlinko!
1st
2nd
Semi
Semi
Place (Could be Tied)
FRA
GER
CZE
ENG
2
FRA
ENG
CZE
GER
2
FRA
GER
CZE
ITA
2
FRA
ITA
CZE
GER
2
FRA
GRE
CZE
ENG
2
FRA
ENG
CZE
GRE
2
FRA
GRE
CZE
ITA
2
FRA
ITA
CZE
GRE
2
FRA
GER
POR
ENG
2
FRA
ENG
POR
GER
2
FRA
GER
POR
ITA
2
FRA
ITA
POR
GER
2
FRA
GRE
POR
ENG
2
FRA
ENG
POR
GRE
2
FRA
GRE
POR
ITA
2
FRA
ITA
POR
GRE
2

If you would like to see your possible winning outcomes (so you know who to root for), you can either post a comment to any of the blog posts (including this one), post your request on Twitter to @HWCI_Pools or  #hwcieuro, or post at our Facebook page.

The English Helping the French

You know when you go to a meeting that you think might be 15 minutes and 2 hours later everyone is still discussing the same topic?  Yup, that's been me.  Rough couple of weeks at work as we have too much work (nice problem, I guess, in this economy). 

Anyway, it's always nice when one soccer powerhouse helps another.  The French could not get anything started as the then winless Swedes shut out France, 2-0, with Zlatan Ibrahimovic half-volleying a rocket into the net for the first goal. But luckily, FRA back-doored their way into the Last 8 when England took care of business squeaking by Ukraine, 1-0, thanks to a header by the returning Wayne Rooney.  FRA's 23-match unbeaten streak got snapped but it didn't matter as the French lazily advanced (they could've lost 10-0-- they would only be out if UKR scored twice and won).  The penalty of course is that they have to face Spain instead of Italy.  35 picked ENG (no one had thought UKR would win) while 8 picked SWE.  Eight went 2-0 while 4 went 0-2.  Twenty (20) correctly picked both ENG and FRA in the Quarterfinals while no one missed both.

For all the group matches,

Tuesday, June 19, 2012

It All Changes Now - Who is Eliminated?

You'll see a couple of changes of interest to you.  The Standings page now includes two additional columns.  "Pl" is the highest placement you can reach with the remaining 128 possible outcomes.  If it says "E", well, that means your entry has been eliminated.  Sorry.  My primary entry Futbol Fabone Five is one of 20 to get an early retirement.  Since we have 4 money spots, the number 1-4 corresponds to the highest possible placement (you could lose a tiebreaker) where "1" means you are one of the 9 entries with a chance to win the pool.  My second entry (SiemkoStrimkoPlinko!), barely surviving thanks to France back-dooring into the Quarters, has a "2" which means I could still finish in 2nd place though it might mean I need GRE and FRA meeting in the final.  If you want to know which possible outcomes would win you money, please post a comment at the bottom of this post or request it via Facebook or Twitter.

The other new thing is a new menu tab on top called "Possibilities".  This shows what percentage you could win 1st or win money.  Right now, The Flying Elvi is flying high as he has a 26.6% to win 1st and a 71.9% to win money.  But that could change in a few days!

Monday, June 18, 2012

Champions Go Through

Another day, another frenzied ending that potentially could've seen favorite Spain go home.  While Croatia and Ireland played their hearts out, it will be the familiar faces of the '08 EURO and '10 World Cup champs Spain and '06 World Cup champ Italy progressing to the knockout stage.

Spain and Croatia started off in the driver's seat (and if they wanted to be a part of Italy's match-fixing scandal, they could've agreed to a 2-2 tie and both would be in regardless how Italy did) but Italy got an early goal which put Croatia on their heels the whole game against Spain.  Spain weathered the storm and seemingly made one too many passes on several good opportunities.  And Spain should've been worried because a Croatia goal would've knocked them out of the tournament but an 88' minute tap in gave the defending champs the top spot of Group C.  Italy sealed the win