Once the previous rounds are finished, we lock down the scores

Thanks a lot mateswas looking out for these for quite some timeCheers and keep it upJason from Goa, India.

Hi there. Im trying to build a similar Euro16 spreadsheet to yours for a work competition. What does the macro look like for putting 3rd place teams into the right knockout stage matches? UEFA have made it very confusing!

2018 World Cup Match Predictions and Odds

Joel, thats correct. The group stage scoring was set up so that if you picked England first and they finished second, you get nothing. We did not build that setting in to allow points for the group stage. Sorry about that

I hope the six eliminated teams from preliminary round for AFC qualifiers could play in play-offs for Asian Cup 2019 :s

onWorld Cup 2018 Office Pool Excel Spreadsheets!

World Cup 2018 Previews Teams 20-17

We dont keep completed tournaments up. As we create new sheets, we will post them

In the spreadsheet for 2018 World Cup Qualifying AFC, Japan is not showing up in the list of qualified teams although they have qualified (I have updated the scores).

would it be possible to have the file in a format whereby i could find and replace the name of the teams to include in brackets the name of my colleague who has that team in the sweep stake at work please?

I would like to make some changes on Euro Cup 2016 spreadsheet. for the group, if the team is right, but not right position, ppl can get 1 point. How do we make that change? or could you send me password to unlock vba thanks

2018 World Cup Office Pool DOWNLOAD HERE

World Cup 2018 Previews Teams 20-17

Hello Admin and football lovers, I liked your European Championship 2016 Excel Spreadsheet. I finished the Pickes file but I face a major problem in the Master file. I cannot copy/move the tab with the participants picks into the Master file, so I cannot creat the Standings! Any help is appreciated and thanks a lot.

Theres a mistake in the ranking of second placed teams in the UEFA spreadsheet. Even though all groups have 6 teams after the admissions of Kosovo and Gibraltar. UEFA has confirmed that the ranking of the second placed teams, will only use results from the matches against the top 5 placed teams. This because the regulations cannot be changed after the draw of the groups. Hence the second place table lists to many points, and to many goals.

Notice: Undefined index: type in/home/weglobal/public_html/wp-content/plugins/jetpack/modules/widgets/twitter-timeline.phpon line88

Do you send me a excel file Euro 2016 without password

World Cup 2018 Previews Teams 24-21

Yes, were working on it right now. Should be available by tomorrow!

Click to share on Reddit (Opens in new window)

EURO 2016 spreadsheet will be available soon! All tiebreakers will work properly!

We will post an update so you can adjust the time since we have it locked right now.

Theme: ColorMag byThemeGrill. Powered byWordPress.

We Global Footballs Excel Spreadsheet Downloads for all major tournaments:

These look great! Will you be doing a Euro 2016 Finals spreadsheet?

onWorld Cup 2018 Office Pool Excel Spreadsheets!

Most likely. There are some newer excel formulas like countifs, which may not be available. There should definitely not be anywhere.

Well then can you send me an example of how to do a head to head between two or more teams in the excel file

I was looking for something exactly like these, however, when I put in random scores, in the Euro 2016 Competition Tracker, the Group D and 3rd Place tables show up with nothing but in all of them and N/A in the team and stat files. Could that maybe be because Im using openoffice instead of excel?

The eight runners-up with the best record against the teams first, third, fourth and fifth in their groups proceed to play-offs to decide the remaining four European berths.

Theres something wrong, even with the option any location, Im getting not the correct number of points for people that predicted that teams would go through, independently of the final group standing. For example, people that got right that 11 teams would go through are only getting the points for those they predicted with the correct group standing. And no change in the point system happens if I change the knockout scoring setting from any location to exact location and vice-versa. What am I doing wrong? Again thanks for your support and awesome spreadsheet!

Click to share on Twitter (Opens in new window)

We will not be providing any files without password protection. Everything you need should be in the file!

The UEFA file is all fixed up. Can download the update. Thanks for pointing that out

World Cup 2018 Previews Teams 28-25

A Scathing Review of FIFAs new ELO Rankings

Steven, download the master file again. We added an option to change that in the second version we released.

I want to remove some sheets and copy the 1st two so multiple players are in one excel. How can I do it?

World Cup 2018 Previews Teams 32-29

Wow sorry about the auto correct that through what I said into a mess. I was seeing if you have the formulas that will help me to make my own spreadsheets so I can do my own tournaments through FIFA World Cup for X-box 360. This is for my own use and no one else. Even if you can email it to me.

One of the great features of We Global Football are the spreadsheets.  The spreadsheets are free to download, and you can track any tournament, qualification, or whatever else we come up with.The macros are 100% safe to use.  Here are some screenshots of prior sheets. Click the images to see larger.

Thank you very much! Let the hex begin!!

onWorld Cup 2018 Office Pool Excel Spreadsheets!

Hello. Thanks for great job. Will the Olympic tournament 2016 be available?

Can you put all of the associations qualifiers for the World Cup (UEFA, AFC, CAF, CONCACAF etc) in one Excel file with different sheets, one for each association? Thanks a lot in advance! Or maybe you can give me an advice how to do it myself (I dont think simple copy/paste would work, because of macros).

Thanks and glad to hear! The times are all set to Eastern standard time (where were located), so if youre in a different location, they will all be off by the same amount.

World Cup 2018 Update October 2017 Odds and Predictions

onWorld Cup 2018 Office Pool Excel Spreadsheets!

Will there be an updated CONCACAF file that contains the Hex?? Thank you so much, love these files!

I have the same issue. Ive setup a pool for 27 people using the Euro spreadsheet, but the points only work if the correct picks are in the exact location and it would take too long to manually add up the points for 27 brackets. Please let me know if theres an easy fix on my end. If not, an updated spreadsheet would be much appreciated.

Hey! Awesome job with the euro pool file!! I was testing it to use it here at work and as soon as I get to the quarter final teams some of the participants get 10 points for a champion that hasnt been selected yet. And then if fill up the rest of the bracket those participants still get 10 points for the champion whether they got it right or not and all the others that actually guessed dont get the 10 points. Any ideas on why is this happening?

There was an error in the older version. If you download the master file again, that issue is corrected. Sorry about that!

Sorry, were not going to have multiple editions of the file. It must be used as is to keep the formulas and standings.

There is a cell directly to the right of the teams name that is unlocked. That is where you enter the score

Perhaps well post a version that just has fixtures/standings in the future with them all. For now, its a lot of rework, so well keep it as is. Thanks for your comment!

The World Cup Office Pool is here! Use our download link above to run a pool for your office. No ads. No nonsense. Just an easy way for you to enjoy the World Cup!

I just did a test and the remaining rounds work for Any Location. Its just the group stage points that dont work for Any Location.

Once the draw is concluded and fixtures announced, well provide Round 3

Do you have a link? We can update the file

I am waiting for the 3rd round excel!! really like your files! : ))

I have just downloaded the World Cup 2018 spreadsheet but the worksheet is blocked. What is the password? Thank you.

Will you provide the AFC 3rd round soon?

Will you be adding the EURO 2016 Spreadsheet?

Thank you very much! I will be looking forward for that!! ?

UEFA Playoffs Predictions, Odds and Probabilities for the 2018 World Cup


Thanks guys very much! so usefull site! Golib, Tashkent, Uzbekistan!

Hello! As UEFA WC 2018 qualifyng is starting in a week time, will the spredsheet be available by the Sunday?

I was seeing also if you could update the OFC 2nd Round sheet with the 3 game bracket they had. I believe was part of there qualifying. It was part of the OFC Nations Cup.

World Cup 2018 Office Pool Excel Spreadsheets!

Click to share on Facebook (Opens in new window)

Thanks a lot in advance and keep up the good work!

Will you be adding the UEFA World Cup Spreadsheet any time soon? The other ones are great!

Hi Ahmed. You must copy the Finalized version that gets created from the Picks file. The original file is locked, but the new file that gets created is unlocked and can be copied into the master file. Hope this helps!

UEFA sheet will be up today or tomorrow. Just adding some finishing touches.

I just love these sheets. Can i adjust the time when the game begins. It is now 7 hours wrong.

Hi, I like your European Championship 2016 spreadsheet, can I ask though how you managed to split the teams in the group stages if 2 or more teams finished on the same points ,,,,,, reason I ask is I run have been asked to automate a current manual Excel file for a junior soccer season cup, but I am having trouble when 2 teams finish on the same points, how to split them .. currently if two teams finish on same points then I have to look at the matches between those two teams and use that to split, but if that match was a draw then I ahve to look at their respective league finish places and use that ,,, but like I said, its all manual and time consuming, so when I saw your file I knew there must be a way of automating this ,, any help is appreciated. Thanks

onWorld Cup 2018 Office Pool Excel Spreadsheets!

It will probably be completed closer to the start of qualifying, but well definitely have one!

Click to print (Opens in new window)

when I try to enter a score into the knock out teams cell it keeps asking for a password.can you help

The files individually are large, so putting them all in one file is going to really slow down the performance of running simulations and projections.

Maybe some that dose formulas for excel. So you can input you own scores for games for the previous rounds.

World Cup 2018 Previews Teams 24-21

A Scathing Review of FIFAs new ELO Rankings

Hi Phil. Sorry we wont have time to get something like that together. Best bet is to just copy the cells and put in some data validation.

Right at the top of the page there is a link above the first image.

How do i download the Copa America , AFC etc spreadsheets?.I only find the world cup pool and it doesnt have that things

Enter your email address to receive notifications of new WGF Posts!

World Cup 2018 Previews Teams 28-25

Best thing to do is look at Wikipedia to see who goes where. Then figure out the 4 teams who are advancing. Then do a lookup or index/match to put the right team in the right place.

Grateful for any hints/tips (or the answer!). Cheers.

2018 World Cup Match Predictions and Odds

1 Comment

Leave a Reply