World Cup 2010 Schedule and Scoresheet
Posted on February 10, 2010
Filed Under Soccer, Sports | 317 Comments
It is not easy to write again after three months I didn’t write and post any templates. And, I am really sorry for not replying many comments due to my time limitation to monitor this site. But…, I am back now with my newest sport template, World Cup 2010 Schedule and Scoresheet Template. This template is the first version, because I plan to add analysis worksheet which can help you (and me of course
) analyzing your favourite teams before they play their matches.
This template is based on my previous Euro 2008 template. Because World Cup 2010 tournament consists of 32 teams, compare with Euro 2008 tournament which only consists of 16 teams, I made lay out modification to make the sheet fit nicely and properly if it is printed within one page A4 or letter paper size.
I am also adjusting the excel formula for deciding and ranking the teams that qualify to the next round after they played all their group matches, if two or more teams have same points, based on World Cup tournament tie regulation where the tie regulation is slightly different with Euro 2008 tie regulation.
I maintain the language and timezone conversion, so you can use or print this template based on your language and time zone. I would like to thanks to Google which provide a very good translation tool which translate my words in this template in seconds. But, I still need a better human translation to make it fully comply with your language. You can help me refining that translation, or add new language translation, by downloading the language file and send it back to me. I will put your name as credit in this site. There 34 different languages and 139 cities timezone available in this version. Just select your language and timezone from the dropdown list in the upper left side of the worksheet to change the appearance of the worksheet into your local language and timezone.
I add a new excel formula to dynamically manage the appearance of team or country flags in Group Standings Table. In the beginning, I plan to put that formula next to every teams in every matches. But, it makes the excel run very slow every time you change cells or fill the scores. So, I decided to drop the formula in any team matches and apply the formula in Group standing table only.
Now, let’s go to the detail on how to use this spreadsheet as your scoresheet. If you ever had download my sport templates, you will be familiar with my sport style template where there are score boxes with blue color which ready to be filled with your estimation score or real score results.And you don’t have to read this instruction. Just use it. For you that download this spreadsheet for the first time, you can read this explanation below carefully to understand how this spreadsheet works.
GROUP STAGES
This scoresheet consists of two big parts, the group stage part and the knock out round part. In the group stage part, you should fill the blue color boxes in all 48 group matches with the real score results or your score prediction. You will see the group standing table next to group matches table are changing automatically based on your input.
After all teams playing their group matches, the excel formula will place the team which quality in first and second position of the group based on group standing regulation. If their points are not the same, it is easy to place the team in first and second position. And the challenge in creating the spreadsheet is in this part, where I have to create the correct formula that will accommodate all possible condition based on FIFA tie regulation. I quoted the group ranking regulation from FIFA World Cup document :
The ranking of each team in each group will be determined as follows:
a) greatest number of points obtained in all group matches;
b) goal difference in all group matches;
c) greatest number of goals scored in all group matches.
If two or more teams are equal on the basis of the above three criteria, their rankings will be determined as follows:
d) greatest number of points obtained in the group matches between the teams concerned;
e) goal difference resulting from the group matches between the teams concerned;
f) greater number of goals scored in all group matches between the teams concerned;
g) drawing of lots by the FIFA Organising Committee.
At least, this tie regulation is much more simpler than Champions League Group tie regulation. I put some samples of the implementation of group ranking regulation as you can see in the pictures. I will explain the ranking regulation applied in each group to give you better understanding on this group ranking and tie regulation.
Group A (Rule a) and b) applied)
After all teams played their matches, France is qualified without question based on rule a) and South Africa is qualified based on rule b) because South Africa has a better goal difference compare with Uruguay.

Group B (Rule a) and c) applied)
In Group B, Argentina and South Korea are having the same point. Because both teams have the highest points compare with other teams in Group B, both teams are qualified. And based on rule b), South Korea will get the top position because South Korea scored more goals, 7 goals, compare with Argentina, 6 goals.

Group C (Rule a) and b) applied)
In Group C, England and Slovenia are having the same point, six. Eventhough England beat Slovenia in their meeting, Slovenia will top the group because Slovenia has a better goal difference.

Group D (Rule b) and tie rule d) applied)
There are three teams that are having the same points. Based on rule b), Serbia will top the group. And because Ghana and Germany are having the same goal difference and the same goal scored, tie rule d) will make Ghana deserve the runner up position because Ghana beat Germany in their meeting.

Group E (Rule c) applied)
This group also has three teams that are sharing the same points. They also has the same goal difference. But, Japan scored more goals than Netherlands, and Netherlands scored more goals than Denmark. So, Denmark is eliminated based on rule c).

Group F (Rule a) and c) applied)
In this group, Italy is topping its group and Slovakia take the runner up position based on rule a) and c).

Group G (Rule a) and tie rule d) applied)
In Group G, Brazil is qualified perfectly by beating all its opponents. But, the others are having the same points (3). Based on rule c), North Korea and Cote-d’Ivoire will go into tie regulation to decide which team will advance to the next round. And tie rule d) reveal North Korea as a runner up because they beat Cote-d’Ivoire in their meeting.

Group H (Rule a) and tie rule g) applied)
This group will use tie rule g) to decide whether Chile or Switzerland that will accompany Spain advance to the next round. Both teams are having the same points, goal difference, goals scored, and also they are sharing the same point in their meeting. So, FIFA will draw them, and in this example, Chile is lucky. But, I haven’t finished to create a drawing table that can be manually filled. In this spreadsheet version, this ranking is still based on FIFA rank, used for group drawing. I plan to reveal a drawing table when some teams are going to be drawn and can be filled manually in the later version.

As additional information, this is the FIFA team ranking used as group drawing lots reference . I took the information from Wiki.
1. South Africa (hosts)
2. Brazil
3. Spain
4. Netherlands
5. Italy
6. Germany
7. Argentina
8. England
9. France
10. Portugal
11. United States
12. Switzerland
13. Cameroon
14. Greece
15. Chile
16. Mexico
17. Côte d’Ivoire
18. Serbia
19. Paraguay
20. Australia
21. Uruguay
22. Denmark
23. Algeria
24. Nigeria
25. Slovakia
26. Honduras
27. Ghana
28. Japan
29. Korea Republic
30. Slovenia
31. New Zealand
32. Korea DPR
KNOCK OUT STAGES
When all group matches are finished and the team that qualified are revealed, the excel formula will place all teams in their corresponding match boxes based on FIFA rule. And if all first seeded are topping their group, you won’t see Brazil vs England in World Cup final
.
In knock out stage, you have to fill the score in one or three blue blank boxes in every matches to reveal and put the winner to next round. If the match is ended in normal time, you just fill the first blue box and the final score will reveal next to each team name. If it has to go to extra time, put the tie score in the first blue box, and put the extra time score in the second blue box. If the match has to be decided by penalty shoot out, put the tie score in extra time box and put the penalty score in the last blue box to reveal the winner of the match. You can the sample in the picture below.
Do the same steps until the final match which will reveal the 2010 World Cup Champion. And before the champion is revealed, feel free to play with those score boxes.
I plan to release the next version which will have player information, match analysis based on player stats, team head-to-head statistic and also other layout types. I hope I can release that in May. And I will separate the templates into several files, so you can choose which template that suit your needs.
If you like my template and want to help other people around the world using this template, you can contribute to correct or add new translation by downloading my language spreadsheet. If the language is already available, you don’t have to write all the translation, just type the correct one next to the English language. I will put your name for your contribution in this site.
I have received several language files, and I would like to thanks these people below for sending me the correct translation, and will make other people who use this spreadsheet in their language will use it more human than more google …
. Those are: Jack Sakali (Arabic), Smartish (Chinese-Simplified), eLook (Chinese-Traditional), Michael Calundann (Danish), Helmer Peerdeman and Willem Norbruis (Dutch), Rauli Korpela (Finnish), Nishal Sooredoo (French), David Rapava (Georgian), Hans A. Keks (German/Deutsch), Achilleas Katsaros, Zach Ioannou and Stelios (Greek), Benysamo (Hebrew), Jozef Kele (Hungarian), Wahyudi Palwono, Herman Macci, Adjie Heryanto, Zainal Arifin and Ananda Raja (Indonesian), Sigursteinn Leifsson (Icelandic), Luca (Italian), Raizal Sohri, Hamal Anuar Md Ali and Nazre bin Abdul Rashid (Malay), Muzzy (Mongolian), Jostein R. Hareide and Kay Ronny Dahl (Norway), Amir Asadi and Amir Yarazavi (Persian), Wally K. and Lukas (Polish), Laercio Fernandes Neves (Portuguese-Brazil), Bruno Afonso, D. Tiago and António Macedo (Portuguese-Portugal), Tudor Apostolescu (Romanian), Kozlov Alexander (Russian), Marko Papic (Serbian), Martin Biros and Michal Zajaek (Slovak), Jorge Cantero Gómez and Jesus Duran (Spanish), Javier Mariano Areco (Spanish-Argentine), Peter Bacharach (Swedish), Win Limthanopajai and Somphop Muenpakdee (Thai), M.Volkan Çakr (Turkish), Mykola Volkogon (Ukrainian), Dung Le Trung, Le Vuong Anh, Philip Nguyen, Bch Tin, Pham Ly Thanh, Nguyen Viet Ha, Vit Thng, Bao Nguyen, Huy Bao Dao, and Tran Quoc Bao (Vietnamese). There are still some languages in process but I am still waiting other language correction to make all languages in this spreadsheet translated correctly.
There are also additional two spreadsheet with no nation flag which should solve compatibility problem in MS Excel 2010 and Openoffice and also for those who running Excel in Macintosh OS/Apple.
And also I would like to thanks Adrian Flores for informing me about flag mixed up, Josef for incorrect match number and also for Noah and Eric van Rooijen who correcting my rule missinterpretation. GBU all.
Here are all the files :
World Cup 2010 Schedule and Scoresheet V1.45 (197.6 KiB, 81,481 hits)
Contribute a better language translation (20.5 KiB, 8,259 hits)
World Cup 2010 Schedule and Scoresheet V1.45 Sorted by Group Matches (127.6 KiB, 11,875 hits)
You can read and download my other templates below :
- UEFA Euro 2008 Football Match Template
- UEFA EURO 2012 Schedule and Scoresheet
- Champions League Fixtures 2009/2010
- World Cup 2010 Wall Chart
Comments
317 Responses to “World Cup 2010 Schedule and Scoresheet”
Leave a Reply







Thank you for all the great posts from last year! I look forward to reading your blog, because they are always full of information that I can put to use. Thank you again, and God bless you in 2010.
Send me!
Hi, Just discovered your website and wondered if you could help. I’ve been roped into dealing with a world cup leage where colleagues guess the results of the group stages and get points based on whether they get the exact scoreline or just the correct result. Do you have anything that might fit this?
A lot to aks perhaps but thanks in advance
David
Hello
Beautiful charts!
One thing, can you please email me the password to un protect the sheet
I need to swap out the teams names for ones that will be used as part of my office staff
Any help appreciated
g
You should have stayed a few more months out. Are you insane? To have the guts to put the Netherlands ahead of Brazil is just plain STUPID! Unless, of course, this is just some crazy numbers to fill the grids. Please let us know how you came to those conclusions so we can decide if its okay for you to be back to your responsabilities or send you back to the rehab program…
Zeca
Sorry for my last post. A friend of mine played a joke on me and I felt for it. Please, disregard my last comments and thanks for doing what you do!
Zeca
thanksssssssssssssssssssssssss
thankssssssssssssssss
Hello
Beautiful charts!
One thing, can you please email me the password to un protect the sheet
I need to swap out the teams names for ones that will be used as part of my office staff
Any help appreciated
This is a great template. I am always wanting to learn more about Excel. Would you be able to explain to me how some of the formulas are linked?
Like the following:
=’Countries and Timezone’!$T$3:$AC$52
Also how did you do the language formulas?
Thanks a lot for all the great templates.
Awesome work, man. Just what I needed, especially with the time zone option.
????????
Is there a reason why the group standings do not auto update?
In your scenario for Group C above, Slovenia and England both have 6 points, but Slovenia has a better goal difference than England (+3 to +1). Slovenia should therefore finish first in the group (tie breaker b).
I think a similar mistake is made in your spreadsheet.
where do i download this, i cant find a link anywhere…ta
ha ha just slap me, found it
First tanks for a good/user-friendly program.
One thing though, in Group C, with:
- England-USA 1-1
- Algeria-Slovenia 2-0
- Slovenia-USA 3-2
- England-Algeria 2-0
- Slovenia-England 0-0
- USA-Algeria 2-0
USA should be second before Slovenia and not third after Slovenia as the goal difference in all group matches prevails over Slovenia’s win over USA.
If you are planning to fix what I believe is a bug, thanks for letting me know when. Cheers,
Hi PEB,
It fixed now. You can download the new one. Thanks.
Hy Admin
Bite me…I cant find the download link.
Cheers
Can you please send me the password as I am running a prediction comp at work and I need to let people put their name in the spreadsheet? Many many thanks. Colin
Hello, i have a question, i would like to know more about how you created the Standings table for the World cup Template. I would like to know so that i can possibly modify it.modify it for more Teams and more games possibly
THanks in advance
How are you my friend,
I crave your indulgence at this mail coming from somebody you have not known before. I decided to do this after praying over the situation. You should please consider the transaction on its content and not the fact that you have not known me before. I need not dwell on how I came by your contact information because there are many such possibilities these days.
My name is Mrs. Celine Aicha Shareef , from Benin Republic, widow to Late Mr. Hashim Shareef (former Consular of the Benin embassy in Madrid,Spain). I have been recently been diagnosed of Cancer of the pelvis.. I am writing from my sick bed.
There is this USD$17.2M (Seventeen Million Two Hundred Thousand American Dollars) my husband has in an account with the Finance Firm here in Benin Republic of which I am the next of kin. With my health condition and because my husband and I have no children, I am looking for a credible person to whom I will pass the right of next of kin. This person will apply to the bank and request for the transfer of the fund to his/her bank account. This is on the condition that you will take 25% of the fund for yourself, 5% used for expenses, while you will use the remaining 70% for the less privilege people in the society. This is in fulfilment of the last request of my husband that a substantial part of the fund be used to carter for the less privileged.
I cannot do this my self any more. I once asked members of my family to close one of my late husband bank accounts and donate the money which I have there to the less privilege people in the society; they refused and kept the money to themselves. Hence, I do not trust them anymore, as they seems not to be contended with what I have left for them. If this condition is acceptable to you, you should contact me immediately with your full names and contact information so that I will ask our family lawyer to prepare the authorization that will give you the right of next of kin to the account in the bank. I will also give you a text of the application you are to send to the bank.
I cannot predict what will be my fate by the time the fund will be transferred into your account, but you should please ensure that the fund is used as I have described above.
Reply to this Email: shareefcelineaicha@yahoo.com
Best regards to you and your family,
Mrs. Celine Aicha Shareef.
with Openoffice and the Italian language, the standings is not updated according to the results
Hi – I have a compatibility. I am running this with Excel 2004 on Mac. I assume this was created with the latest PC version of Excel and the compatibility problem means very slow to operate and a tendency to crash. I did not have this problem with other spreadsheets that I have used over the years from this site (typically formula 1 2008, 2009).
Thanks – this comment applies to both formula 1 2010 and the world cup 2010.
Cheers
There are a mistake.
if you put the results of the “group D” example appears #N/A in the second place of the group
Hallo
gut gemacht. Für einige persönliche Anpassung möchte ich Zellen verändern. Senden Sie mir bitte das Passwort zu.
Herzlichen Dank
H. Bruppacher
Hi,
Great spreadsheet…would like to incorporate my predictions.
In order to do so, I need a password.
Can you assist
Cheers
Martin
Hey,
I love your scoresheet. Unfortunately, I found two small errors. In the quarter finals, you put Match 59 as “Winner Match 51″ vs. “Winner Match 52″. This should be the other way round; 52 plays at home against 51.
In the semifinals, there is a similar error: Match 61 should be played among “Match 58 winner” vs. “Match 57 winner” and not 57 – 58 as it stands now.
Either you can update this, or you can send me the password so I can update it for myself. It doesn’t matter for me =)
Tim
Please modify your translated into Vietnamese as follows:
World Cup 2010 Schedule and Scoresheet: L?ch thi ??u và b?ng ?i?m World Cup 2010
Group Stages: Giai ?o?n ??u b?ng
Matches: K?t qu? các tr?n ??u
Match #: Tr?n ??u
Group: B?ng
Time: Gi?
Country: ??i
Score: T? s?
Round of 16: Vòng 16 ??i
Group A Winner: ??i nh?t b?ng A
Group B Runner Up: ??i nhì b?ng B
Normal Time: Hi?p chính
Exta Time: Hi?p ph?
Penalty Shoot Out: Sút ph?t ??n
Played: S? tr?n
Win: Th?ng
Draw: Hòa
Lose: Thua
Goal scored for: Bàn th?ng
Goal Scored against: Bàn thua
Quarter Finals: T? k?t
Mach 53 Winner: Th?ng tr?n 53
Match for Third Place: Tr?n tranh h?ng Ba
Final: Chung k?t
World Cup 2010 Champion: Vô ??ch World Cup 2010
Match 64 Winner: ??i th?ng tr?n 64
Please modify your translated into Vietnamese as follows:
World Cup 2010 Schedule and Scoresheet: Lich thi dau và bang diem World Cup 2010
Group Stages: Giai doan dau bang
Matches: Ket qua các tran dau
Match #: Tran dau
Group: Bang
Time: Gio
Country: Doi
Score: Ti so
Round of 16: Vòng 16 doi
Group A Winner: Doi nhat bang A
Group B Runner Up: Doi nhì bang B
Normal Time: Hiep chính
Exta Time: Hiep phu
Penalty Shoot Out: Sút phat den
Played: So tran
Win: Thang
Draw: Hòa
Lose: Thua
Goal scored for: Bàn thang
Goal Scored against: Bàn thua
Quarter Finals: Tu ket
Mach 53 Winner: Thang tran 53
Match for Third Place: Tran tranh hang Ba
Final: Chung ket
World Cup 2010 Champion: Vô dich World Cup 2010
Match 64 Winner: Doi thang tran 64
Hi Admin,
Could you send me pass to unprotect spreadsheet ? i want to modify it according to our language.
thanks alot.
Hi Can you please email me password to unprotect sheet. Thnx
Hurrah!! Well done…
password:AABAABAABBBD
Hi,
Great sheet! I was just wondering where I can find the formulas to create my own sheet, is there a website or a book you can recommend? I am just starting out on using excel and I would like to know the workings of such a page and I think it would be a good excercise for me to play around with it.
I have tried using search engines and I found this site.
Any help or guidence would be much appreaciated.
JJ
I am attempting to copy the page but ahen I enter the scores it does not update the leagues. How do i do this as I want to send copies to workmates so they can fill it in and return then I can link it to a a master and calculate scores. Hope you understand this.
DS
Hi your templates are amazing
Is there any chance you could send me the password so that i can have a look at how the formulas are done and also how did you manage to link all the data to different languages?
Awesome
How can i download this
hi how can i download the file, or can you plz email the file thanx for your work great job.
shant9@rogers.com
Hey just downloaded this and its excellent. I was wondering if i could get the password to unlock this. I am trying to setup a pool at work and would like to use this.
Thanks
Hi,
I´m using Excel 2010 beta and for some reason it goes and changes the picture on the left so it all becomes very small and unreadable. Any suggestions?
REgards
kris
great table
I having the same issues as Kris with regards the picture on the right hand side, where all the group tables are, shrinking in Excel 2010. Any suggestions to fix this would be great.
Chris
If you want to compete with your friends in your own leagues etc, this is the spreadsheet for you:
sites.google.com/site/footballexcel
I’ve got a problem when i put the results in of 1 of the people who i’m doing it with, i get one or more of the teams in the group coming up as N/A
If you could please either give me an email address to send you the file to, or reply to me i hope you can help me.
If you put every single home team to win 2-1 in the group stages you will see the problem.
Thanks.
Hi
great template thank you.
some cells are protected , can I get the password to unprotect the fields : (match 50 and over)
igf2k10@gmail.com
sorry for teh previous question. i saw the answer above: AABAABAABBBD as password.
thank you again. great template
Thanks this is a great spreadsheet for the World Cup. I want to make a few changes for an office sweepstake. Could you please email me the password? thanks
Hi
Please could you provide me with the password for your wonderful spreadsheet?
There are some amendments I would like to make so that I can use this in the office.
Thanks
Dann
My email address is;
Dannj11@hotmail.com
Hi Admin.
can you please add match prediction functionality?
Thanks
Hi
Excellent spreadsheet its just what Ive been looking for.
What is the chance of getting the password to unprotect the sheet so I can use it for a junior league I help run?
Thanks
Terry
Thank you for the great Excel tool, but I think we all agree that it would be nice to be able to upgrade it such that it could be used for match predictions and betting.
What do I put for a U.S. time zone in the spreadsheet?
Can you give me the password to access to the 1/16 round of World Cup2010 please?Thanks a lot.
sfasfasfasfsa
Can you give me the password to access to the World Cup 2010 please?Thanks a lot.
Hi, just wondered if you could help. I’ve been looking into setting up a world cup leage where colleagues predicts the results of the group stages and get points based on whether they get the exact scoreline or just the correct result. Do you have anything that might fit this? please please please
Thanks in advance
Great spreadsheet!!
Can you please email me the spreadsheet and password to unprotect so I can include my own predictions.
Thanks
Great sheet, incredible even. The tie breaker based on Head to Head results is not working though, using the examples on this site Groups D and G error with #N/A instead of 2nd place. Any chance you can explain the workings behind this, I’m lost in the formulas!
please send me the spreadsheet on this addy
shaffi@slappershoes.com
How do I get a copy? I can’t see where to download it?
Visit:
wc2010tabel.blogspot.com
First of all … Great job done…
Try this:-
South Africa 4-2 Mexico
Uruguay 2-4 France
South Africa 3-5 France…
Application fails…..
correct me if i’m wrong…
Hi, Just discovered your website and wondered if you could help. I’ve been roped into dealing with a world cup leage where colleagues guess the results of the group stages and get points based on whether they get the exact scoreline or just the correct result. Do you have anything that might fit this?
A lot to aks perhaps but thanks in advance
David
I have the same problem as david and was wondering if there is a tool to easily function this?
I would appreciate any help you can offer.
Hi, Just discovered your website and wondered if you could help. I’ve been roped into dealing with a world cup leage where colleagues guess the results of the group stages and get points based on whether they get the exact scoreline or just the correct result. Do you have anything that might fit this?
A lot to aks perhaps but thanks in advance
David
I have the same problem as david and was wondering if there is a tool to easily function this?
I would appreciate any help you can offer.
If anyone else can help.. mshortm@hotmail.com
Hi
This is just what i’ve looking for.! Its great to get more involved with the world cup and enter the scores yourself…
Just how do i download the file.?
I can’t find the download button on this page.?
Please could you send it to me…
LowCostGadgets@aol.com
Regards Andrew
Hello,
very good work. Can you send me an email with the password to unprotect the file, to correct some things in italian language, please?
My email address is Andreus4@hotmail.it
thanks for the chart, i’ve been looking for a chart like this for a while for the league im doing. thanks this is brilliant
Hi your templates are amazing
Can you please email me the spreadsheet and password to unprotect so I can include my own predictions.
Thanks.
HI CAN YOU PLZ LET ME KNOW HOW CAN I DOWNLOAD UR CHART ? THANKS IN ADVANCE
Can you plz send me a copy of the “World Cup 2010 Schedule and Scoresheet” excel template.
I could not find the link to download the same.
can you please tell me how to download the wc spreadsheet#
thanks
john
Can you please send me the file and the password please as i cant seem to find it.
thanks
Chris
Can you send the password so I can play around with this a little? Thanks!
Great work!! It’s really the best worldcup schedule i’ve ever used, thank you very much for making a useful product, i hope you’ll develop it more and more excellent!!
Hey,
Your chart looks amazing and just what i’ve been looking for.
How can I download it?
If possible, please send it to my email:
kvarnesen@gmail.com
Cheers
Hey,
Your chart looks amazing and just what i’ve been looking for.
How can I download it?
If possible, please send it to my email:
manow_redarmy@hotmail.com
Banky
Thanks for this – I found one bug for a very unlikely scenario, but enjoyed making Australia come 3rd against Germany overall(another, perhaps, unlikely scenario). Spain is my predicted winner. Looking forward to entering the REAL results soon.
Hi, can you pls send me a copy of your spreadsheet?
Thanks!
Can you send the password? Pls email me @ melatishafika@yahoo.com Thanks!
Hi,
Can you send the Password???
please E-mail me:
Jassem.J@hotmail.com
Thanks & Best Regards…
Hi All, love this spreadsheet but does anybody know if the bugs mentioned earlier are still there or has there been some changes made
hey R. Musadya,
thanks a lot for the file. I emailed you the Farsi/|Persian translation. please update your file.
Cheers,
Go Holland Go
super cool tool.
please send it to me….
very nice …
could u please sent it to my email
thunder-2007@hotmail.com
Good chart but without all cities. There is no my country’s city “Phnom Penh”.
Great chart. Could you please send it to my mail?
skyj89@gmail.com
Hi
Great sheet. Small issue, timezone for Cairo is wrong. They are observing DST and should be 2hrs ahead of London, not 1.
Thanks
Duncan
Please advise as to how to download and password if necessary. Thank you
Cheers for this mate. Very helpfull.
Thanks
Terry
Please can you let me have the password? I have to run a prediction competition at work and my colleagues need to add their names and scores etc. Many many thanks
Would it be possible for you to send me the World cup 2010 spreadsheet and password so I too can organise a work competition.
Many thanks,
Chris
This is superb effort. Thanks to all Football lovers who contributed to develop this sheet.
Can you please share with me the password to unprotect the world cup 2010 sheet on:
Amr.Adel.Kamal@gmail.com
Best regards,
Amr.
Thank you. Thank you. THANK YOU!
Would it be possible for you to send me the World cup 2010 spreadsheet and password so I too can organise a work competition.
Many thanks,
Hello, i love the format, could i get the password to unprotect for a office pool that we are doing? thanks
bierchef@gmail.com
This is really awesome!good work
Please can you email this to me…and the password as well
shiran.moodley@za.ey.com
Hi all how do you download the world cup 2010 excel sheet ?? i have already subscribed but cant see where you download the sheet !! thanks in advance
Hi brilliant spreadsheet but do you have one that allows a competition on predicted vs actual scores and calculates points and a winner at the end of the world cup ie person with most results, quarter finalists etc correct? Thanks
Hello, like a few of the guys above I am running a tournament in work with a points system based on the results of your spreadsheet, I don’t suppose you have already done this?
Aside from that, the spreadsheet is excellent, it seems there is an error in group 2 with greece and nigeria.
Please can you also send me the password to unprotect the sheet.
Alexander.crane@lionbridge.com
Brilliant work
How did you get the standings to update within the picture? I am trying to set something up similar to this but don’t see where the picture is linking to?
Thanks
Hello, I love the format and would like to request the password as well. Using it for an office pool. Thanks a lot!
katiekong@hotmail.com
Boa noite
Vi o teu site e gostei mt do teu modelo world cup 2010.Gostaria muito que pudesses enviar ao meu mail o teu modelo e tambem quero a senha.
Muito obrigado
Please could you send me the password for the World Cup 2010 spreadsheet, need to unprotect it!
Congratulations, the file is excellent!!! I will enjoy it with all my family…
Adios!
Hi, just wondering if its possible to have the password for me to use this class format ???
does anyone have the password ???
if so would you be able to mail it to me ?>???
daidtomo@hotmail.com
Cheers
shit wrong mail lol
davidtomo@hotmail.com
does anybody know when BRASIL is playing hit me up at maria.orizaba619@yahoo.com
Could I have the password for this too? Spreadsheet looks great.
Hi Admin. Love the file. Could I please have the password for unlocking the Last 16 and the Finals?
My e-mail is victorbergerskogen@gmail.com
In advance, thank you!
Hi, this is excellent stuff. During the past touraments we have used a similar spreadsheet to enter our scores of a friend’s pool. Is there a chance that you could send the password to unprotect the sheet? Would be very much appreciated!
Thanks so much
Kay
This worksheet is not good for me. It is protected. I love Excel, not World Cup, I was here for the code behind it, maybe learn something new (I am alread well versed in Excel anyway) but you hide it behind password. Useless…
I would like to submit an update to the “Chinese – Traditional Language”. Please advise….
How to download this? Is it freeware? Please help me to download.
Could you email me a copy?
anderm13@yahoo.co.uk
Could you email me a copy?
plus the passwords to unlock?
Great spreadsheet.
My timezone is not available (Baku = GMT=4 hours. How can I change this?
I have previously seen a spreadsheet that also administered the scoring for the whole office, ideal to run a pool. A new list was issued every day.
Is this available in combination with the world cup 2010 spreadsheet?
pls send me the template
This is really great. Thanks a lot.
looks great, works like a champ.
thanks!
wicked spread sheet i am doing a prediction with my friends and need to imput points next to results, if possible ma i have the password.
thanks
Hey,
Could you email me a copy please?
plus the passwords to unlock?
Thanks very much.
[...] also managed to find this neat little template which allows you to print off and fill in all the results from the competition as they [...]
Hallo, kun je mij de excel worldcup 2010 voetbalpool per email opsturen. Deze worldcup ziet er zeer overzichtelijk uit en kan het in mijn website plaatsen
Could you pls send me the password so that I can personalise for the office pool.
Thanks,
Hi There.
Could you please send me the password so that I can personalise for the department event.
Hello, like a few other people above I am running a tournament at work with a points system based on the results of your spreadsheet, I don’t suppose you have already done this?
If not can you send me the password so I can make some modifications.
Thanks in advance,
LP
hi all and admin
firstly are the bugs above fixed?
also I would like the password as I run a major charity based competition. could someone email me it, regards dave@sixofthebest.info
PS what a great spreadsheet come on england
can anyone send me this excle schedule on my email??
i will be greatful.
can anyone send me this excle schedule on my email??
i will be greatful.
javed@ncel.com.pk
javed_janjua@hotmail.com
I would really appreciate these sheets for my local pub pool.
Thank you kindly,
David
have the bugs been worked out and it there as place the updated template can be downloaded?
plz send me…
hey love it!! been looking for one ever since.
thanks alot!!
please send me and thanks a lot!
Real good stuff!
Unfortunately I’ve found some mistakes:
Matches 21,22,23,41,42,43 and 44 are not as on the FIFA schedule. Same for 59,61, here the team position are excahnged.
Do you think you update the file?
Thanks
Joesf
Thanks…………..
Many thanks for a superb piece of work.
Please could you mail me a password to modify the sheet? I’m organising a World Cup competition for my local pub and your chart will make my life so much easier.
Many thanks
Pez
hi
thx fpor aa very nice excel
but the google translate are not good at danish. i know the password AABAABAABBBD. but how does I edit in “picture 91″ Standings?
Ruben
hello,very beautiful Chart my dear,please can u send me the password for activation plz.
Please..can i have a password to unprotect sheet?
i just want to learn more about microsoft excel.
PLEASE..
Did anyone ever solve the Excel 2010 compatibility issue?
Please.. Send to my email joe_blake_28@yahoo.com
hi … wonderfull excell
can anyone send this template and password to my email budi_krisna07@yahoo.com
many thanks,
muji haru download garna na janne le k computer chalaune ma chikani
Superb, awesome, its very help full. Thanks for the hard work.All the best…………..
Hi
Very impressed with the sheet. I’m not very knowledgeble in this field but could you tell me if it would work on a college network or would Macros?? be a problem if not enabled? (I know we have had this problem in the past. Excellent presentation and the layouts and colour are great. Could you please send me the password in order for me to work within the sheet?
Thanks.
Cliff.
This is way too awesome, very handy with language/timezon options!
Thanks a lot!
Great sheet…
Just one observation regarding the timezone for Kolkata, Mumbai and New Delhi. The time difference is 3:30hrs however the sheet displays it as 3:50hrs due to which the timing is off by 20 mins.
Hi,
If anyone could send me the spreadsheet to my email that would be amazing – thanks guys xx
siandaniels_69@hotmail.com
Really, really good job, excellent. Thanks man. Even if there are some mistakes, it is nothing in front of this amazing sheet. Even FIFA themselves can not make such sheet.
Thanks!!!
excellent and nice
Thanks and please share me
sophal.van@azcom.net.kh
Would it be possible for you to send me the World cup 2010 spreadsheet and password so I too can organise a work competition.
Many thanks,
Nigel
I have futbol aficionadoes in my Spanish classes. This is wonderful. Thank you for your brain and work.
Marjorie
Hi!
Love the spreadsheet, but the timezone is wrong for India. India should be GMT+5.5, but it seems to be off.
Please check & let us footie fans in India know!
Thanks a ton!
THANKS
Great, could you send me this aswell
Hi there! Where do I download this fabulous score sheet?! I used it for the last World Cup and it was GREAT! Please send it to me if you can! THANKS!
Hi there. Nice. Would like to download the score sheet. Please send it to me. Thanks.
Hi please can you email me a copy of these spreadsheets
james_smith_321@hotmail.com
much appreciated
hey,what is the download link?
Hello there,
I simulate some scores but nothing happend in the standings board.
Is it normal?
Cheers,
V
Yeah, standings not updating. Is this a problem when using Openoffice?
Other than that great work!
Pete.
Hi admin!
job well done! can you email me a copy along with the password pleaseeeeeeeee!
jmarcellus11@gmail.com
thank you.
PLEASE SEND
???? ????? , ?? ????? ?? ?? ????? ?????
Hi. i unprotected sheet, but still can’t save this sheet as a web page (html), any ideas how to do it?
thanks.
Please could you send a copy and password to my email address – Thanks
Hello everybody
Well done ,it very nice and completely organized .
Thank you very much and if you do not mind sending me the file and its password to my email zrig2000@yahoo.com .
With kind regards
Hassan
awesome !!!
Hi, this rule does not work correctly:
If two or more teams are equal on the basis of the above three criteria, their rankings will be determined as follows:
d) greatest number of points obtained in the group matches between the teams concerned;
If you input all 1-0 for the group games then the top two teams will have identical points and goals for/against but the team that beat the group winner is actually in second place. It should be the other way around.
Nice job, but just a heads up (positive criticism). Your team ranking mechanism within groups is flawed. I am saying this because I was looking for a new script to fix my own spreadsheet and found your model, and saw that you happen to use the same concept as I did. In rare occasions it sends the wrong team to the round of 16.
To prove it: try the following combination of scores for group A
South Africa 0 1 Mexico
Uruguay 1 1 France
South Africa 1 2 Uruguay
France 1 1 Mexico
Mexico 1 1 Uruguay
France 1 0 South Africa
France is mistakenly sent to round of 16, instead of Mexico…
To fix it I came up with a different ranking system that did the job. Just send me an email if you are interested in it, and I have no problems sharing it with you.
Hi,
The translation in Bulgarian is not correct and it has some “funny” things, for example “D” in the table is translated as “paint” instead of “equal score”. So, if you send me a file I will make the translation right.
Best regards,
Krasen
Hi Admin,
It is a mistakes in russion traslation.
is not correct “????????” you shoul change it to “????”. You wrote “Date” like it date with girl )))
????????? ???????-??????????????? ??????????
you can write like “????”
“Loser”— Translation is “???????????”
It is just small mistakes.
Thank you for greate post.
Or just mail me I will made correction )))
Great one!
Thanks so much!
I’ve sent you the Persian Translation!
Hello, I’m from Trinidad in the caribbean and this is the first spreadsheet of this type I ever found. Thank you so much… Can you email me the password so i can fil in the rest when the time comes? Thanks again
Awesome spreadsheet for the World Cup!!
Running your spreadsheet on Excel 2010, the standings tables appear so small the numbers in the tables are barely visible. It is as though it is bringing from A3:AC53 rather than T3:AC53.
Any idea how to fix this?
bonjour!!!
can you please email me the password to un protect the sheet
I need to swap out the teams names for ones that will be used as part of my office staff
my email: lequanghuong@gmail.com
thanks!!!
Hi dear sir
would you please send me this excel file?
Thanks & Best regards
how i get on it help
THANKS FOR YOUR EFFORTS
Hi, can you send it to my email, plse?
kafekafe@live.be
Thanks
Can you send me the password at my email spurinn@simnet.is
Hi!
Can you tell me where the download is?
Oh, and I need you to e-mail it too me, too.
Oh, and send the password so I can make changes.
Oh, and I need you to tell me how to make those changes.
Oh, and can you just make the changes for me?
Oh, and I need you to create a spreadsheet for me that’s kind of like this – can you do that?
Oh, and can you just come to my office and do all of my work for me, too?
Oh, and send me $5,000 (US) and I will give you a share of my $17.2 million inheritance.
Oh, and can you make my sick puppy better?
Seriously, the spreadsheet is nice. Well done.
problem with XL 2010 (beta) – the merged & centred cells on the main sheet cause the linked picture to contain all of the “timezone” sheet.
If you unmerge the cells the linked picture reverts to what it should.
works fine in XL 2007
cheers
to get it to work in XL 2010 you need to unprotect the “Tournament” sheet (password AABAABAABBBD)
go to cell N2, unmerge the cells.
go to cell b6, unmerge the cells.
go to cell b8, unmerge the cells.
re protect the sheet.
save the file
close the file and re-open it and the standings tables are fine i.e. the picture link is just the standings tables, not the whole “countries and timezones” sheet.
cheers
If Pakistan/India take football game seriously,they can become a favourite champions!Especially Pakistani talents can hit the world cup winning target.To us,Pakistan will soon rule the world of football.Just wait………..few years!!
@Lindsay: thanks
Hi everyone,
Here is the pass for unprotect sheet: 4b1b7b5b1b5b1 (v1.36)
You can edit anything you want but please respect copyright…
Thanks.
Hi Admin,
There are some mistakes.
Please modify your translated into Vietnamese as follows:
Stadings: V? trí (or ‘X?p h?ng’)
Jun.: Tháng Sáu
Jul.: Tháng B?y
Match ‘#’ Winner: ??i th?ng tr?n ‘#’
for example: Match 64 Winner: ??i th?ng tr?n 64
Visit exceltemplate.net for more templates and updates: Xem trang exceltemplate.net ?? c?p nh?t và có thêm các m?u.
Thanks
Best regards.
Hi Admin,
There are some mistakes.
Please modify your translated into Vietnamese as follows: (please use Unicode code)
Stadings: Vi tri (or ‘Xep hang’)
Jun.: Thang sau
Jul.: Thang bay
Match ‘#’ Winner: Doi thang tran ‘#’
for example: Match 64 Winner: Doi thang tran 64
Visit exceltemplate.net for more templates and updates: Xem trang exceltemplate.net de cap nhat va co them cac mau.
Thanks
Best regards.
Dear Admin,
Excellent work! One small error. The times for Hawaii (Honolulu) appear to be the same as the local times for the matches. I think these should be one hour earlier than the Alaska (Anchorage) times.
Thanks for helping me track the matches from multiple time zones as I’ll be in Hawaii for some of the matches and it is great to be able to see when the matches will be so I can still watch!
Swimmingly,
Amber
can u please send me the password
thanks
SORRY I KNOW IT NOW I NEVER SAW THE OTHER 1
Great spreadsheet.
An error found in V1.44. In the German language version, “Australia” is shown as “Osterreich” (Austria). I think this should be “Australien”. National flag is OK.
Also, can the group matches be listed in chronological order instead of FIFA match number order?
Thanks
Thanks………………..
Could you please send this chart it to my email?
tour_nepal2001@yahoo.com
great work!
cud u do me a favor by incorporating Nepal Time?
Hey there … try to download …nothing happens! Any help os appreciated.
Trifonas … Greece / Athens!
[...] outright win from <left blank intentionally> as a gut feeling, I’ve started to use this World Cup 2010 Schedule and Scoresheet spreadsheet to see what team may pop out after I enter all my predicted scores. I’ve managed to get [...]
Please can I have the pwd to unprotect it?
Great work and keep it up! A true excel guru =)
Many thanks,
Andrew
Hi, in Russian version of the first download link there are few corrections needed:
in match 49 there is no group letter index of the group winner team (should be Group A winner, now simply Group winner)
also in match 56 you need to change the order of words in order to follow suit of other matches – now it says Group H winner, whereas all other matches follow this order – Winner of group H (which sounds better in Russian)
Great table, thanks!
This is super cool! Thank you very much exceltemplate.net for sharing.
Is it possible to send the password tp learn how you fix this beautiful sheet.
Thanks
Sorry,
I didn’t look very well, i have found it.
Thanks
Hi,
Thanks for your Schedule and Scoresheet. If you sand my a Schedule and Scoresheet in time zone Dhaka, Bangladesh I fill very happy. My yahoo id.(tapan.9998@yahoo.com)
Thanks’
Tapan.
Mexico 4 South Africa 2
Uruguay 0 Francia 0
South Africa 0 Francia 1
Mexico 1 Uruguay 0
South Africa 2 Uruguay 2
Mexico 1 Francia 1
after this tournament Mexico World Cup Champion
[...] Hi all, there are many requests about making a prediction game or an office pool based on my World Cup 2010 Schedule. [...]
Hi,
This is a excellence schedule. Can i have the pass for study about it.
Pls send pass to: dalatville@gmail.com
Many thanks.
Please modify your translated into Portuguese as follows:
English Portuguese
34 25
South Africa África do Sul
Mexico México
Uruguay Uruguai
France França
Argentina Argentina
Nigeria Nigéria
South Korea Coreia do Sul
Greece Grécia
England Inglaterra
USA E.U.A.
Algeria Argélia
Slovenia Eslovénia
Germany Alemanha
Australia Austrália
Serbia Sérvia
Ghana Gana
Netherlands Holanda
Denmark Dinamarca
Japan Japão
Cameroon Camarões
Italy Itália
Paraguay Paraguai
New Zealand Nova Zelândia
Slovakia Eslováquia
Brazil Brasil
North Korea Coreia do Norte
Côte-d’Ivoire Costa do Marfim
Portugal Portugal
Spain Espanha
Switzerland Suíça
Honduras Honduras
Chile Chile
Language Idioma
Timezone Fuso horário
Group Stages Fase de Grupos
Matches Jogos
Standings Classificação
Group Grupo
Date Data
Country País
Score Pontuação
Time Hora
Round of 16 Oitavos de Final
Quarter Finals Quartos de Final
Semi Finals Meias Finais
Match for Third Place Apuramento para o 3º Lugar
Final Final
Winner Vencedor
Runner Up Segundo Classificado
Normal Time Tempo Normal
Extra Time Tempo Extra
Penalty Shoot Out Penáltis
Champion Campeão
Match # Jogo #
Group A Winner Vencedor Grupo A
Group B Winner Vencedor Grupo B
Group C Winner Vencedor Grupo C
Group D Winner Vencedor Grupo D
Group E Winner Vencedor Grupo E
Group F Winner Vencedor Grupo F
Group G Winner Vencedor Grupo G
Group H Winner Vencedor Grupo H
Group A Runner Up 2º Class. Grupo A
Group B Runner Up 2º Class. Grupo B
Group C Runner Up 2º Class. Grupo C
Group D Runner Up 2º Class. Grupo D
Group E Runner Up 2º Class. Grupo E
Group F Runner Up 2º Class. Grupo F
Group G Runner Up 2º Class. Grupo G
Group H Runner Up 2º Class. Grupo H
Match 53 Winner Vencedor Jogo 53
Match 54 Winner Vencedor Jogo 54
Match 55 Winner Vencedor Jogo 55
Match 56 Winner Vencedor Jogo 56
Match 57 Winner Vencedor Jogo 57
Match 58 Winner Vencedor Jogo 58
Match 59 Winner Vencedor Jogo 59
Match 60 Winner Vencedor Jogo 60
Match 61 Winner Vencedor Jogo 61
Match 62 Winner Vencedor Jogo 62
Match 63 Winner Vencedor Jogo 63
Match 64 Winner Vencedor Jogo 64
Visit exceltemplate.net for more templates and updates Visite o site exceltemplate.net para mais modelos e atualizações
Played Jogos
Win Vitória
Draw Empate
Lose Derrota
Goal scored for Golos Marcados
Goal scored against Golos Sofridos
Point Pontos
Second place O segundo lugar
Group A Grupo A
Group B Grupo B
Group C Grupo C
Group D Grupo D
Group E Grupo E
Group F Grupo F
Group G Grupo G
Group H Grupo H
Match 49 Winner Vencedor Jogo 49
Match 50 Winner Vencedor Jogo 50
Match 51 Winner Vencedor Jogo 51
Match 52 Winner Vencedor Jogo 52
Match 61 Loser Derrotado Jogo 61
Match 62 Loser Derrotado Jogo 62
World Cup 2010 Schedule and Scoresheet Campeonato do Mundo 2010 Calendário e Scoresheet
World Cup 2010 Champion Campeão do Mundo 2010
Thanks,
Great work! Congratulation.
I am not an Excel guru so I have a question. There are 25 players only in the spreadsheet. I will have more than 25 players participating in the pool. How to add more players in the way that theirs scores will be calculated automatically in the Player Leaderboard and the Player Scoreboard the same way as the scores of existing 25 players?
Thank you for help. Anyboby is welcome to answer this question
Hi!
There is an error in the German language-pack. Australia is “Australien” in German, not “Österreich”. This would be Austria, which is not participating…
Could you update your sheet before next friday?
Regards,
Marco
Same post but I am adding may email address.
Great work! Congratulation.
I am not an Excel guru so I have a question. There are 25 players only in the spreadsheet. I will have more than 25 players participating in the pool. How to add more players in the way that theirs scores will be calculated automatically in the Player Leaderboard and the Player Scoreboard the same way as the scores of existing 25 players?
Thank you for help. Anyboby is welcome to answer this question
marcin.mtl@gmail.com
This is a great template.
Would you, or anyone be able to explain to me how did you associate the Country with the right Flag before?
What procedure do i have to do to for any country i want, get the right flag before or after?
Thanks a lot for all the great templates.
Am I being stupid? I cant seem to find the link of the excel document itself !!! Can you please help?
Thanks in advance
pls send me the password!!!
i would like the team profile of tha Brazili team.
I have downloaded all two version 1.44… but i continue to not watch the national flag on Office 2007…… because ?
Oh… my error… only on “World_Cup_2010_Schedule_and_Scoresheet_V1.44_Sorted_by_Group_Matches.zip” it’s no flag…..
How to translate in macedonian
please help me
Thanks
Could you please send to cerbantespavlo@hotmail.com
Many thanks!
…in english if possible. Thx.
Hi,
Please insert Persian language to languages list.
thanks.
Hi
Love your sheet. Thanks for the great work!
I have made some modifications making it into a simulator, or more precisely as a tool to beat my friends in a betting pool
If you are interested in a copy just send me a mail and I will send it.
Cheers
Enok
“Cuongnd@ on May 31st, 2010 3:14 am Hi everyone,
Here is the pass for unprotect sheet: 4b1b7b5b1b5b1 (v1.36)
You can edit anything you want but please respect copyright…”
TraumaXB
4b1b7b5b1b5b1 (v1.36)
v1.44 is the same pass …
TraumaXB
awesome job!!
thanks
Please send sheet in english for us to put up in the bar at THe Raft in Walvis Bay, Nambia,
many thanks,
Sarah
Awesome job. Grateful if u could please email me the tie sheet in english to put up at the city hall.
Pankaj
amazing , love it
can anyone please email it with the password to
springfeild@hotmail.com
thank you very much
UNREAL! helped so much, thanks!
any chance I can get the password please!? I need to play with it to add people in for my office pool
amazing , l love it
can anyone please email it with the password to me
Thanks a bunch!!
Ole Ole!!!!
[...] World Cup scores and game results. Not to be missed also is the work this guy put in to create a World Cup Excel template which generates all the right matches coming up, depending on the results you put in. Definitely [...]
Hi there,
is there a possibilty to change the points. For example instead 100/75/50 3/2/1.
I simulated that case… but there is a problem with the 1 Score… sometimes it shows 50.
I think when the score of the game has a difference of 1 goal. For example. If i bet 3:1 and the game finishes 2:1 then it will give me 50 points instead of 1.
Anyone knows a solution?
Thank you… great side by the way…
flags / table broken on excel 2010
[...] Muss ist der WM-Kalender für Outlook und iCal, sowie das Excel-Template zum Eintragen der Ergebnisse bzw. der Tipps mit automatischer Berechnung des weiteren Verlaufs [...]
its not working. it says that’s there’s somethin wrong with the formula. and i use a mac. so wtf shuld i do ?
This is awesome! Great job with excel!
Hi. Great job! Only flags between uruguay and serbia are mixed up. Also player’s cant be seen (only Andre Pierre GIGNAC, others are locked). Can you send me the password and will you fix these problems?
Cheers, M.
Hi, great spreedsheet can you pls email it to me…cheers!
Great Spreadsheet.
One Question. How do you fill in the “drawing feature” table?
Many Thanks.
hi can u email me the sheet plz…
can u plz send me the work sheet thru mail …
Thank you for all the great posts World Cup 2010 Schedule and Score sheet
&
also please can u plz send me the work sheet thru mail …
organization billing (A/C) sheet
You did a great job. Thank you so much for this spreadsheet.
BTW, when I open this http://exceltemplate.net/download/1/ with Excel 2010, the “Standings” section look like corrupted (it’s normal on Excel 2003), so that I’m using this file http://exceltemplate.net/download/6/. I just wonder if you can make another compatible version of this spreadsheet for Excel 2010 (with flags, of course ^_^).
Thanks again for your hard work
!
Hallo
When I change language to german/deutsch I fund out there is an error by the first game from germany. “Deutschland-Österreich”, Österreich didn’t make it to the WM 2010, ‘maybe next time’. It should be Deutschland-Australien. In fact all the Australian games are writen over with Austria.
But still thank you all for your nice work.
This is a great sheet! Thought I had tried to comment a couple days ago but it didn’t show up.
(1) How come you don’t have a contact form on this site?
(2) Can I post a copy of this on my website with the scores filled in? I’ll credit you. Thanks!
… oh, and (3) Do you know of a sheet like this that’s being continually updated to make it easy to download and print (one one page) at any time during the games?
Dear Sir,
the german translation for AUSTRALIA should be corrected to AUSTRALIEN . Currently you have the wrong country ÖSTERREICH (which is AUSTRIA and which is not participating). I have tried to do myself but you have protected the sheets.
brgds A.W.
This is what I wrote before: -
“Mark D on June 12th, 2010 9:12 am
Great Spreadsheet.
One Question. How do you fill in the “drawing feature” table?”
My apologies, I read carefully your instructions where it clearly states that this is to be filled in manually.
Thanks.
Would you, or anyone be able to explain to me how did you associate the Country with the Flag that appears before?
How you did it in excel?
What procedure do i have to do to for any country i want, get the right flag before or after?
Thanks a lot!
It’s great?
What is the password?
Kolkata/Mumbai, India time zone is not correct. It is +20 min in the present version. Pls correct this in the Next Version.
Hi
Please send me the file.
Best Peter
Hi,
Very Nice Work. Well, I have noticed a problem. Whenever I am sorting Column F by oldest to newest the Group table changes but the flags do not follow the respective country. Can you please send me a copy correcting that.
cheers,
nit
For the “drawing table” (If FIFA have to draw lots to see who goes through from the group stages).
I think this is how it works: -
Manually fill in the pop up table by entering “1″ for the winner, then enter “2″ for the runner up.
This appears to correctly place the winner in the knockout stage.
Likewise, if there are three teams tied, enter “3″ against the third team and if there are four teams, enter “4″ against the fourth team.
All fields in the pop up table have to be filled in.
I hope this is correct. Seems to work for me.
Admin, please correct me if I am wrong.
Thanks.
[...] your predictions to this handy World Cup 2010 Schedule and Scoresheet in Excel, then print it on the other side of your Match Schedule from step 2 above. There are [...]
Version 1.44 !!!! Italian Conversion Error!!
Appears Australi and not Austalia..
It’s possibile to edit manually !?!?!?!?
Downloading the version 1.45….
The Wrong name.. Australi and not Australia still remaining on italian translation.
How i can export the result on my 1.44 and import on 1.45 ??
Admin: -
Version 1.45 just appeared.
Are the updates just to languages? I am using the English version, so do I need to update from version 1.44.
Thanks for the score sheet. It’s great.
in 1.44 German Language. Australia is listed as Austria(Österreich)
Should be (Australien)
There is no Switzerland in group H there are 2 Chile’s
Regards
Thanks a lot for your great work!
it looks good.
Thankssssssssssssssssssssssssssssssssss
time 18-24 error
Hi
Can you please email me the password to unprotect the sheets.
We need to translate to Vietnamese more exactly.
Thansk you very much.
Email: xuanthu196025@yahoo.com
Yeah, it’s great even though it’s quite funny to see translation into Vietnamese. Thanks a lot.
Hi there, i realy like this spreadsheet but i have one problem, the flags for the following countrys don’t show up:
Portugal,
Cote-d’Ivoire,
North Korea,
Switzerland,
Chile,
Spain,
Honduras.
If you could get back to me to let me know if it is just me who is having this problem.
Thanks
colhan_durban09@hotmail.co.uk
[...] mention this one that I found which makes a nice one-page form you can fill in dynamically. http://exceltemplate.net/sports/world-cup-2010-schedule-and-scoresheet/ Diego Garcia June 11, [...]
plz the pass
this excel template is not good…
the goal difference standing is totally out of order…please fix ASAP
I found a bug @ the template in Group a is uruguay @ 1st and Mexico on 2nd…..in my template is Uruguay on 1st RIGHT and Southafrica on second….why?
fix asap
Group A result is wrong.
Uruguay & Mexico will go through the next round, why South Africa ? Fix it.
Hi,
Make sure that you use the template with version 1.44 above.
Regards
World Cup 2010 Schedule and Scoresheet
Just noticed that South Africa have qualified for the second stage as the template does not seen to take into account goal difference. SSorry if this is a repeat of a mail sent by others
Excellent template. Thought I was good with Excel, but I know better now. Wish I could prepare these templates.
My compliments for correcting the error in the group A result so promptly.
Thank you !
I’m mexican; sorry for my english.
There is a mistake in the first group (A). The second place had more goals against than the third place. Mexico must be second and South Africa the third and they are on the contrary (?)
I hope you understand me
Excellent
Great work…. Thank.
The fixture and standings on group A do not update by themselves… can you or I fix this bug? Thanks
Hi my dear,
thanks a lot for your great job
but i want you to know, when i use the world cup 2010 schedule i found a little mistake appears on the team ranking table on the right, for example if two teams are equals in points but one of them has for example 3 goals for him and 2 against so the result is 1 for, and the other has 2 goals for and 5 against so the result is (-3) meaning against, the second team will be the winner which is wrong
please take an example by entering Group A and D scoring results with the actuals scores and see what will happen
I can’t see how to download this newer version of the World Cup sheet on your website… my version has the error that does not identify the teams that are progressing correctly (when that have the same number of points). please help!!
Please fix calculation of group phase. Mexico and Ghana appear to be outwhich is wrong
Guys,
I have no standings problem. I think you should download and use the latest version. Mine is V1.45.
Cheers
Excellent. I like this template.
Could you send me sheet protection password for learning.
jchaiwongsa@gmail.com
Thanks.
Hi, thanks for the excellent job creating this template. However there is some minor bgs that need to be fix. After the Australia vs Serbia match, the team ranking on the right, the top 2 team in Group E, F G and H turns the blue color even though they have played only 2 matches. I am using both v1.44 and v1.45
Could you send me sheet protection password for learning.
Thanks
Sorry, my email is francisqq@gmail.com if you are willing for me to learn better Excel.
Thanks again
Hi I would like to thank you for this incredible file you created !
If possible could you send me the password by email (I have to make some automatic calculations points)
Thank you in advance
Jeremie
Thanks a lot for the charts. I used to use a similar Excel sheet, but seeing what you have done, I decided to code something similar for myself (with flags, playerlists etc.)..
Hi,
Great spreadsheet — thanks!
One improvement:
I’ve used the spreadsheet to predict placings, by filling in the results beforehand.
Unfortunately, when I later update the results by blanking them, the tables of the groups don’t get updated afresh, so teams’s results & points remain unchanged from the last predictions.
It would be great if the tables could reflect the updates when results are re-set to blank.
Very nice work, all the same.
Hi Great Chart. Seems a little blip on final games of group H.
I’ve filled in all scores to date (final games are still to be played), but if I put in theoretical scores of Chile 0 1 Spain ,and Swiss 1 0 Honduras, Chile stay in second place in the table but we get #NA as their name and a string of zeros in the other cells.
Not a complaint – I couldn’t come close to creating a spreadsheet like this.
Thanks
forgot to mention version I’m using is v1.36
Apologies – just downloaded v1.45 and it fine.
Thanks
if I put Chile 0, Spain 1 and Swiss 1, Honduras 0, it shows an error on the standigs of group H. any comments?
Been using v1.36 for results and predictions and it has worked flawlessly.
You are a god of Excel.
This is from a former Excel and VBA programmer.
God love ya!
Thanks a lot. However, it’s not compatible with Excel 2010.
Thanks
password: AABAABAABBBD
worked for me
great work
thanks a lot
Just entered scores for match 58 but you don’t get a winner if it goes to penalties.
Using v1.45.
ta
can you please email me the password to un protect the sheet…
Hi, and thanks for your effort, I have followed the scores using your spreadsheet,
I’m curious to find out how did you write the program, I’ve came to some of the secrets but can I have more details, especially the standing page.
If you can send me the password that will be great,
Thanks a lot and hope that Germany wins the Cup.
Elie
Hi Admin,
Can you tell me how did you make the rigth flag appears associated to a cell number?
Thank you
Do you need a loan to pay off your bills and clear off your Debt?Do you need an Urgent loan or a business Loan? Have you be denied of a loan from your bank or a any Financial Firm? Do you need a loan to pay off your bills or buy a home? Do you need a loan to start up a business?Get an affordable loan at a low interest rate of 3% Contact us at: stevenloanfirms@sify.com
Your Name:
Loan Amount:
Loan Duration:
Your Phone Number
Email: stevenloanfirms@sify.com
I was aware about this already, nevertheless there have been some helpful bits that finished the picture for me personally, many thanks!
Hi, could you send me the password please? Great spreaddie
?????…
?????…
hi thanks a lot for the spreadsheet it was very helpful
Hi Travma ,
I would like to ask for your services as I have to recreate a similar XL to handle Team games in Olympics. Any chance of working together.
Its very similar but not all team sports have so many teams in their groups.