Excel Templates | Excel Spreadsheets | World Cup 2010 Schedule and Scoresheet



World Cup 2010 Schedule and Scoresheet

Posted on February 10, 2010
Filed Under Soccer, Sports | 320 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 icon smile World Cup 2010 Schedule and Scoresheet ) 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.

World Cup 2010 Schedule and Scoresheet V1.31 World Cup 2010 Schedule and Scoresheet

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.

Direct to the download page

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 A Sample Result World Cup 2010 Schedule and Scoresheet

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 B Sample Result World Cup 2010 Schedule and Scoresheet

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 C Sample Result World Cup 2010 Schedule and Scoresheet

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 D Sample Result World Cup 2010 Schedule and Scoresheet

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 E Sample Result World Cup 2010 Schedule and Scoresheet

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 F Sample Result World Cup 2010 Schedule and Scoresheet

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 G Sample Result World Cup 2010 Schedule and Scoresheet

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.

Group H Sample Result World Cup 2010 Schedule and Scoresheet

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 icon smile World Cup 2010 Schedule and Scoresheet .

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.

Knock Out Stages Filled World Cup 2010 Schedule and Scoresheet

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 … icon wink World Cup 2010 Schedule and Scoresheet . 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 :

zip World Cup 2010 Schedule and Scoresheet  World Cup 2010 Schedule and Scoresheet V1.45 (197.6 KiB, 85,504 hits)

xls World Cup 2010 Schedule and Scoresheet  Contribute a better language translation (20.5 KiB, 8,915 hits)

zip World Cup 2010 Schedule and Scoresheet  World Cup 2010 Schedule and Scoresheet V1.45 without Nation Flag (127.3 KiB, 6,994 hits)

zip World Cup 2010 Schedule and Scoresheet  World Cup 2010 Schedule and Scoresheet V1.45 Sorted by Group Matches (127.6 KiB, 13,306 hits)



Comments

320 Responses to “World Cup 2010 Schedule and Scoresheet”

  1. Life Insurance BC on February 17th, 2010 8:02 am

    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.

  2. Simos on February 22nd, 2010 1:47 pm

    Send me!

  3. David Irvine on February 22nd, 2010 7:29 pm

    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

  4. Gen on February 23rd, 2010 4:20 pm

    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

  5. Zeca on February 24th, 2010 4:44 pm

    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

  6. Zeca on February 24th, 2010 4:48 pm

    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

  7. mhd85 on February 25th, 2010 11:24 am

    thanksssssssssssssssssssssssss

  8. mhd85 on February 25th, 2010 11:31 am

    thankssssssssssssssss

  9. mhd85 on February 25th, 2010 11:33 am

    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

  10. Mike on February 25th, 2010 9:01 pm

    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.

  11. Zack on March 2nd, 2010 12:03 pm

    Awesome work, man. Just what I needed, especially with the time zone option.

  12. Bert on March 2nd, 2010 12:29 pm

    ????????

  13. SemperDoc on March 3rd, 2010 7:31 am

    Is there a reason why the group standings do not auto update?

  14. Noah on March 5th, 2010 8:00 am

    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.

  15. Billy on March 11th, 2010 3:14 pm

    where do i download this, i cant find a link anywhere…ta

  16. Billy on March 11th, 2010 3:16 pm

    ha ha just slap me, found it

  17. PEB on March 14th, 2010 9:30 am

    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,

  18. admin on March 14th, 2010 4:41 pm

    Hi PEB,

    It fixed now. You can download the new one. Thanks.

  19. Charles G Nathan on March 15th, 2010 2:25 pm

    Hy Admin

    Bite me…I cant find the download link. :(

    Cheers

  20. Colin on March 15th, 2010 4:28 pm

    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

  21. Erin Hopkins on March 16th, 2010 7:13 am

    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

  22. Mrs. Celine Aicha Shareef. on March 16th, 2010 10:26 am

    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.

  23. Mork on March 16th, 2010 5:22 pm

    with Openoffice and the Italian language, the standings is not updated according to the results

  24. Marc Denjean on March 21st, 2010 11:21 am

    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

  25. Jorge on March 21st, 2010 11:32 am

    There are a mistake.
    if you put the results of the “group D” example appears #N/A in the second place of the group

  26. Bruppacher Heinz on March 21st, 2010 10:45 pm

    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

  27. Martin on March 22nd, 2010 3:47 am

    Hi,

    Great spreadsheet…would like to incorporate my predictions.

    In order to do so, I need a password.

    Can you assist

    Cheers

    Martin

  28. Tim on March 22nd, 2010 7:23 pm

    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

  29. Le Vuong Anh on March 25th, 2010 6:07 pm

    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

  30. Le Vuong Anh on March 25th, 2010 11:26 pm

    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

  31. Vu Hung on March 26th, 2010 9:52 am

    Hi Admin,

    Could you send me pass to unprotect spreadsheet ? i want to modify it according to our language.

    thanks alot.

  32. Reshad on March 27th, 2010 8:24 am

    Hi Can you please email me password to unprotect sheet. Thnx

  33. Mapuia (Peniel) on March 27th, 2010 9:27 am

    Hurrah!! Well done…

  34. minime on March 30th, 2010 10:26 am

    password:AABAABAABBBD

  35. JJ on April 6th, 2010 9:10 am

    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

  36. Dave Shaw on April 9th, 2010 2:54 pm

    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

  37. H on April 10th, 2010 4:23 pm

    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

  38. H on April 10th, 2010 4:26 pm

    How can i download this

  39. NETHERLAND FAN on April 10th, 2010 4:45 pm

    hi how can i download the file, or can you plz email the file thanx for your work great job.

    shant9@rogers.com

  40. kdha on April 13th, 2010 6:08 am

    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

  41. kriss on April 15th, 2010 11:32 am

    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

  42. abobaker on April 18th, 2010 6:20 pm

    great table

  43. Chris R on April 19th, 2010 12:20 pm

    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

  44. mikskov on April 20th, 2010 7:10 am

    If you want to compete with your friends in your own leagues etc, this is the spreadsheet for you:
    sites.google.com/site/footballexcel

  45. Joe Keenan on April 20th, 2010 10:17 am

    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.

  46. corey on April 20th, 2010 3:01 pm

    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

  47. corey on April 20th, 2010 3:33 pm

    sorry for teh previous question. i saw the answer above: AABAABAABBBD as password.

    thank you again. great template

  48. Peter on April 20th, 2010 8:03 pm

    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

  49. Dann on April 21st, 2010 8:57 pm

    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

  50. Dann on April 21st, 2010 8:57 pm

    My email address is;

    Dannj11@hotmail.com

  51. Peedy on April 21st, 2010 11:57 pm

    Hi Admin.

    can you please add match prediction functionality?

    Thanks :)

  52. Terry on April 24th, 2010 11:27 am

    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

  53. Su2dod on April 25th, 2010 10:23 am

    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.

  54. Nathan on April 25th, 2010 7:29 pm

    What do I put for a U.S. time zone in the spreadsheet?

  55. ngoclam on April 26th, 2010 7:05 am

    Can you give me the password to access to the 1/16 round of World Cup2010 please?Thanks a lot.

  56. f on April 26th, 2010 1:19 pm

    sfasfasfasfsa

  57. Joaquin garcia on April 27th, 2010 9:51 am

    Can you give me the password to access to the World Cup 2010 please?Thanks a lot.

  58. Adrian on April 27th, 2010 11:46 am

    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

  59. Jimi on April 28th, 2010 5:47 am

    Great spreadsheet!!

    Can you please email me the spreadsheet and password to unprotect so I can include my own predictions.

    Thanks

  60. RobS on April 28th, 2010 8:57 pm

    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!

  61. Imraan on April 28th, 2010 10:04 pm

    please send me the spreadsheet on this addy
    shaffi@slappershoes.com

  62. Jared on April 29th, 2010 3:14 am

    How do I get a copy? I can’t see where to download it?

  63. José on April 29th, 2010 8:19 am

    Visit:

    wc2010tabel.blogspot.com

  64. Anurag on April 29th, 2010 9:48 am

    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…

  65. michael short on April 30th, 2010 11:12 am

    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.

  66. michael short on April 30th, 2010 11:13 am

    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

  67. Andy on April 30th, 2010 1:56 pm

    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

  68. Andrew on May 1st, 2010 1:58 pm

    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?

  69. Andrew on May 1st, 2010 1:59 pm

    My email address is Andreus4@hotmail.it

  70. alfredo on May 2nd, 2010 8:58 pm

    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

  71. Steven on May 3rd, 2010 6:16 am

    Hi your templates are amazing

    Can you please email me the spreadsheet and password to unprotect so I can include my own predictions.

    Thanks.

  72. joelito on May 5th, 2010 2:34 am

    HI CAN YOU PLZ LET ME KNOW HOW CAN I DOWNLOAD UR CHART ? THANKS IN ADVANCE

  73. Arijit on May 5th, 2010 5:57 am

    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.

  74. john on May 5th, 2010 7:37 am

    can you please tell me how to download the wc spreadsheet#
    thanks
    john

  75. chris tiernan on May 5th, 2010 2:08 pm

    Can you please send me the file and the password please as i cant seem to find it.
    thanks

    Chris

  76. Nat on May 5th, 2010 5:54 pm

    Can you send the password so I can play around with this a little? Thanks!

  77. Roboy on May 5th, 2010 5:56 pm

    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!!

  78. K.Arnesen on May 7th, 2010 9:08 am

    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

  79. Banky on May 8th, 2010 4:51 am

    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

  80. Manu on May 8th, 2010 11:50 am

    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.

  81. Glads on May 8th, 2010 3:23 pm

    Hi, can you pls send me a copy of your spreadsheet?

    Thanks!

  82. marianah on May 8th, 2010 6:54 pm

    Can you send the password? Pls email me @ melatishafika@yahoo.com Thanks!

  83. Jassem on May 9th, 2010 2:07 am

    Hi,
    Can you send the Password???
    please E-mail me:
    Jassem.J@hotmail.com

    Thanks & Best Regards…

  84. Dave on May 9th, 2010 12:20 pm

    Hi All, love this spreadsheet but does anybody know if the bugs mentioned earlier are still there or has there been some changes made

  85. Babak on May 9th, 2010 2:27 pm

    hey R. Musadya,

    thanks a lot for the file. I emailed you the Farsi/|Persian translation. please update your file.
    Cheers,

    Go Holland Go

  86. singer on May 10th, 2010 3:04 am

    super cool tool.
    please send it to me….

  87. Raad on May 10th, 2010 6:42 am

    very nice …
    could u please sent it to my email
    thunder-2007@hotmail.com

  88. Zideth on May 10th, 2010 10:25 am

    Good chart but without all cities. There is no my country’s city “Phnom Penh”.

  89. Sam on May 10th, 2010 10:57 am

    Great chart. Could you please send it to my mail?
    skyj89@gmail.com

  90. Duncan on May 10th, 2010 10:57 am

    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

  91. Keith on May 10th, 2010 2:39 pm

    Please advise as to how to download and password if necessary. Thank you

  92. Terry on May 10th, 2010 4:35 pm

    Cheers for this mate. Very helpfull.

    Thanks

    Terry

  93. Colin on May 11th, 2010 10:59 am

    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

  94. chris hannaford on May 11th, 2010 11:52 am

    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

  95. Amr Kamal on May 11th, 2010 5:39 pm

    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.

  96. Ivo on May 11th, 2010 8:43 pm

    Thank you. Thank you. THANK YOU!

  97. Alan on May 11th, 2010 9:27 pm

    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,

  98. mike on May 11th, 2010 10:07 pm

    Hello, i love the format, could i get the password to unprotect for a office pool that we are doing? thanks

    bierchef@gmail.com

  99. Shiran on May 12th, 2010 7:27 am

    This is really awesome!good work
    Please can you email this to me…and the password as well

    shiran.moodley@za.ey.com

  100. Tam on May 12th, 2010 10:51 am

    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

  101. DT on May 12th, 2010 12:34 pm

    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

  102. Alex Crane on May 12th, 2010 1:23 pm

    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.

  103. Alex Crane on May 12th, 2010 1:40 pm

    Please can you also send me the password to unprotect the sheet.
    Alexander.crane@lionbridge.com

    Brilliant work

  104. Jason on May 12th, 2010 5:28 pm

    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

  105. Katie on May 12th, 2010 10:13 pm

    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

  106. andre cascaes on May 12th, 2010 11:40 pm

    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

  107. Glyn on May 13th, 2010 10:19 am

    Please could you send me the password for the World Cup 2010 spreadsheet, need to unprotect it!

  108. Raul Arcos (México) on May 13th, 2010 3:28 pm

    Congratulations, the file is excellent!!! I will enjoy it with all my family…
    Adios!

  109. Dave Thompson on May 13th, 2010 3:55 pm

    Hi, just wondering if its possible to have the password for me to use this class format ???

  110. Dave Thompson on May 13th, 2010 4:08 pm

    does anyone have the password ???
    if so would you be able to mail it to me ?>???

    daidtomo@hotmail.com

    Cheers

  111. Dave Thompson on May 13th, 2010 4:09 pm

    shit wrong mail lol

    davidtomo@hotmail.com

  112. maria on May 13th, 2010 4:12 pm

    does anybody know when BRASIL is playing hit me up at maria.orizaba619@yahoo.com

  113. Gray on May 16th, 2010 10:25 am

    Could I have the password for this too? Spreadsheet looks great.

  114. Victor Bergerskogen on May 16th, 2010 4:16 pm

    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!

  115. Kay on May 16th, 2010 7:44 pm

    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

  116. Andy on May 17th, 2010 3:21 am

    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…

  117. eLook on May 17th, 2010 4:26 am

    I would like to submit an update to the “Chinese – Traditional Language”. Please advise….

  118. Sivapatham on May 17th, 2010 9:20 am

    How to download this? Is it freeware? Please help me to download.

  119. Mark on May 17th, 2010 10:31 am

    Could you email me a copy?

    anderm13@yahoo.co.uk

  120. Arthur on May 17th, 2010 1:40 pm

    Could you email me a copy?
    plus the passwords to unlock?

  121. Ronald on May 17th, 2010 3:11 pm

    Great spreadsheet.
    My timezone is not available (Baku = GMT=4 hours. How can I change this?

  122. Ronald on May 17th, 2010 3:24 pm

    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?

  123. sanjay on May 18th, 2010 4:20 am

    pls send me the template

  124. Yang on May 18th, 2010 7:47 am

    This is really great. Thanks a lot.

  125. byron on May 18th, 2010 1:01 pm

    looks great, works like a champ.
    thanks!

  126. james morris on May 18th, 2010 1:36 pm

    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

  127. Alex Bald on May 18th, 2010 3:58 pm

    Hey,

    Could you email me a copy please?
    plus the passwords to unlock?

    Thanks very much.

  128. World Cup is nearly here! « on May 18th, 2010 3:59 pm

    [...] 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 [...]

  129. saskia on May 18th, 2010 5:06 pm

    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

  130. Bill on May 18th, 2010 9:26 pm

    Could you pls send me the password so that I can personalise for the office pool.
    Thanks,

  131. JOE on May 19th, 2010 5:47 pm

    Hi There.

    Could you please send me the password so that I can personalise for the department event.

  132. LP on May 19th, 2010 6:06 pm

    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

  133. dave on May 19th, 2010 9:21 pm

    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

  134. Javed Janjua on May 20th, 2010 8:48 am

    can anyone send me this excle schedule on my email??
    i will be greatful.

  135. Javed Janjua on May 20th, 2010 8:49 am

    can anyone send me this excle schedule on my email??
    i will be greatful.
    javed@ncel.com.pk
    javed_janjua@hotmail.com

  136. David Haywood on May 20th, 2010 3:33 pm

    I would really appreciate these sheets for my local pub pool.

    Thank you kindly,

    David

  137. BAM on May 20th, 2010 4:38 pm

    have the bugs been worked out and it there as place the updated template can be downloaded?

  138. Sami on May 20th, 2010 9:32 pm

    plz send me…

  139. mark on May 21st, 2010 2:47 am

    hey love it!! been looking for one ever since.
    thanks alot!!

  140. Cidic on May 21st, 2010 2:50 am

    please send me and thanks a lot!

  141. Josef on May 21st, 2010 9:48 am

    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

  142. KAI on May 21st, 2010 9:56 am

    Thanks…………..

  143. Pez at Ashford on May 21st, 2010 10:16 pm

    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

  144. Ruben (Denmark) on May 22nd, 2010 9:05 am

    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

  145. ali on May 22nd, 2010 12:49 pm

    hello,very beautiful Chart my dear,please can u send me the password for activation plz.

  146. Oz on May 22nd, 2010 7:16 pm

    Please..can i have a password to unprotect sheet?
    i just want to learn more about microsoft excel.

    PLEASE..

  147. IML on May 22nd, 2010 7:39 pm

    Did anyone ever solve the Excel 2010 compatibility issue?

  148. Oz on May 22nd, 2010 7:41 pm

    Please.. Send to my email joe_blake_28@yahoo.com

  149. krisna on May 22nd, 2010 11:44 pm

    hi … wonderfull excell
    can anyone send this template and password to my email budi_krisna07@yahoo.com

    many thanks,

  150. deepak on May 23rd, 2010 2:41 am

    muji haru download garna na janne le k computer chalaune ma chikani

  151. Zahirul on May 23rd, 2010 8:07 pm

    Superb, awesome, its very help full. Thanks for the hard work.All the best…………..

  152. Cliff on May 23rd, 2010 11:18 pm

    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.

  153. csl2004 on May 24th, 2010 6:01 am

    This is way too awesome, very handy with language/timezon options!
    Thanks a lot!

  154. Irfy on May 24th, 2010 10:35 am

    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.

  155. Sian on May 24th, 2010 4:23 pm

    Hi,

    If anyone could send me the spreadsheet to my email that would be amazing – thanks guys xx

    siandaniels_69@hotmail.com

  156. Moayad on May 24th, 2010 6:42 pm

    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.

  157. Adrian on May 24th, 2010 8:41 pm

    Thanks!!!

  158. Rabie on May 24th, 2010 10:17 pm

    excellent and nice

  159. sophal on May 25th, 2010 4:25 am

    Thanks and please share me
    sophal.van@azcom.net.kh

  160. Nigel Pearson on May 26th, 2010 9:08 am

    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

  161. Marjorie Berry on May 26th, 2010 10:13 am

    I have futbol aficionadoes in my Spanish classes. This is wonderful. Thank you for your brain and work.

    Marjorie

  162. JediKnut on May 26th, 2010 12:05 pm

    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!

  163. OGUZ on May 26th, 2010 12:10 pm

    THANKS

  164. mark on May 26th, 2010 12:19 pm

    Great, could you send me this aswell

  165. Jasmin on May 26th, 2010 1:09 pm

    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!

  166. PHIL on May 26th, 2010 3:48 pm

    Hi there. Nice. Would like to download the score sheet. Please send it to me. Thanks.

  167. Jamie on May 26th, 2010 4:44 pm

    Hi please can you email me a copy of these spreadsheets

    james_smith_321@hotmail.com

    much appreciated

  168. sharmoot on May 26th, 2010 4:54 pm

    hey,what is the download link?

  169. Vincent on May 26th, 2010 6:37 pm

    Hello there,

    I simulate some scores but nothing happend in the standings board.

    Is it normal?

    Cheers,

    V

  170. Peter North on May 26th, 2010 7:56 pm

    Yeah, standings not updating. Is this a problem when using Openoffice?

    Other than that great work!

    Pete.

  171. jmoney on May 26th, 2010 8:21 pm

    Hi admin!

    job well done! can you email me a copy along with the password pleaseeeeeeeee!
    jmarcellus11@gmail.com

    thank you.

  172. ANDREW on May 27th, 2010 3:45 am

    PLEASE SEND

  173. ???? on May 27th, 2010 5:51 am

    ???? ????? , ?? ????? ?? ?? ????? ?????

  174. Ziya on May 27th, 2010 6:50 am

    Hi. i unprotected sheet, but still can’t save this sheet as a web page (html), any ideas how to do it?
    thanks.

  175. Terry Dean on May 27th, 2010 9:15 am

    Please could you send a copy and password to my email address – Thanks

  176. hassan on May 27th, 2010 10:44 am

    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

  177. Dr. Omar on May 27th, 2010 12:37 pm

    awesome !!!

  178. Dude on May 27th, 2010 4:04 pm

    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.

  179. delgado on May 28th, 2010 2:10 am

    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.

  180. Krasen Daskalov on May 28th, 2010 4:37 am

    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

  181. Mansur on May 28th, 2010 12:18 pm

    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.

  182. Mansur on May 28th, 2010 12:19 pm

    Or just mail me I will made correction )))

  183. Farid Ghanbari on May 28th, 2010 7:41 pm

    Great one!
    Thanks so much!
    I’ve sent you the Persian Translation!

  184. kamal on May 29th, 2010 2:57 am

    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

  185. Stuart on May 29th, 2010 3:38 am

    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?

  186. Le Quang Huong on May 29th, 2010 7:30 am

    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!!!

  187. arian on May 29th, 2010 10:06 am

    Hi dear sir
    would you please send me this excel file?
    Thanks & Best regards

  188. jimmy on May 29th, 2010 12:52 pm

    how i get on it help

  189. osama on May 29th, 2010 12:59 pm

    THANKS FOR YOUR EFFORTS

  190. Bruno on May 29th, 2010 2:22 pm

    Hi, can you send it to my email, plse?

    kafekafe@live.be

    Thanks

  191. Jon on May 29th, 2010 2:46 pm

    Can you send me the password at my email spurinn@simnet.is

  192. Mr. Sarcasm on May 29th, 2010 4:08 pm

    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.

  193. Lindsay on May 29th, 2010 6:40 pm

    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

  194. Lindsay on May 29th, 2010 6:51 pm

    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

  195. Hashir/Areeb on May 30th, 2010 6:24 am

    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!!

  196. Hai’s Blog on May 30th, 2010 11:41 am

    @Lindsay: thanks

  197. 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…

    Thanks.

  198. Thái ??ng Tr??ng (Heerim-PVC) on May 31st, 2010 3:14 pm

    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.

  199. Thai Dang Truong (Heerim-PVC) on May 31st, 2010 3:18 pm

    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.

  200. Amber on May 31st, 2010 6:13 pm

    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

  201. sj on May 31st, 2010 6:49 pm

    can u please send me the password

    thanks

  202. sj on May 31st, 2010 6:55 pm

    SORRY I KNOW IT NOW I NEVER SAW THE OTHER 1

  203. Michael on June 1st, 2010 1:53 am

    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

  204. Rumman on June 1st, 2010 8:46 am

    Thanks………………..

  205. Tika on June 1st, 2010 8:57 am

    Could you please send this chart it to my email?
    tour_nepal2001@yahoo.com

  206. shashank pokhrel on June 1st, 2010 9:28 am

    great work!

    cud u do me a favor by incorporating Nepal Time?

  207. Trifonas on June 1st, 2010 7:55 pm

    Hey there … try to download …nothing happens! Any help os appreciated.

    Trifonas … Greece / Athens!

  208. World Cup fever is starting to build up, time to look for a schedule « A blog by Miguel PdL on June 1st, 2010 10:33 pm

    [...] 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 [...]

  209. Murch on June 2nd, 2010 10:40 am

    Please can I have the pwd to unprotect it?

    Great work and keep it up! A true excel guru =)

    Many thanks,

    Andrew

  210. alex on June 2nd, 2010 11:39 am

    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!

  211. v$ on June 2nd, 2010 6:08 pm

    This is super cool! Thank you very much exceltemplate.net for sharing.

  212. T. Muller on June 2nd, 2010 10:12 pm

    Is it possible to send the password tp learn how you fix this beautiful sheet.

    Thanks

  213. T. Muller on June 2nd, 2010 10:16 pm

    Sorry,

    I didn’t look very well, i have found it.
    Thanks

  214. Tapan on June 3rd, 2010 4:36 am

    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.

  215. Mexico@champion on June 4th, 2010 1:04 am

    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

  216. 2010 FIFA World Cup Office Pool | Excel Templates on June 5th, 2010 1:24 am

    [...] Hi all, there are many requests about making a prediction game or an office pool based on my World Cup 2010 Schedule. [...]

  217. Anh on June 5th, 2010 4:24 pm

    Hi,

    This is a excellence schedule. Can i have the pass for study about it.

    Pls send pass to: dalatville@gmail.com

    Many thanks.

  218. José Marinha on June 5th, 2010 10:41 pm

    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,

  219. Marcin on June 6th, 2010 4:33 am

    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

  220. Marco on June 6th, 2010 12:12 pm

    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

  221. Marcin on June 6th, 2010 2:25 pm

    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

  222. Nuno on June 6th, 2010 5:32 pm

    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.

  223. Tintin on June 7th, 2010 10:26 am

    Am I being stupid? I cant seem to find the link of the excel document itself !!! Can you please help?

    Thanks in advance

  224. k on June 7th, 2010 8:47 pm

    pls send me the password!!!

  225. dada on June 8th, 2010 6:27 am

    i would like the team profile of tha Brazili team.

  226. DjDiabolik on June 8th, 2010 11:00 am

    I have downloaded all two version 1.44… but i continue to not watch the national flag on Office 2007…… because ?

  227. DjDiabolik on June 8th, 2010 11:02 am

    Oh… my error… only on “World_Cup_2010_Schedule_and_Scoresheet_V1.44_Sorted_by_Group_Matches.zip” it’s no flag…..

  228. vlatko on June 8th, 2010 11:28 am

    How to translate in macedonian
    please help me
    Thanks

  229. Pablo on June 8th, 2010 8:34 pm

    Could you please send to cerbantespavlo@hotmail.com
    Many thanks!

  230. Pablo on June 8th, 2010 8:35 pm

    …in english if possible. Thx.

  231. reza on June 9th, 2010 7:49 am

    Hi,
    Please insert Persian language to languages list.
    thanks.

  232. Enok on June 9th, 2010 9:25 am

    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

  233. TraumaXB on June 9th, 2010 10:29 am

    “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

  234. TraumaXB on June 9th, 2010 10:31 am

    4b1b7b5b1b5b1 (v1.36)
    v1.44 is the same pass …

    TraumaXB

  235. Soni on June 9th, 2010 11:31 am

    awesome job!!
    thanks

  236. sarah on June 9th, 2010 7:28 pm

    Please send sheet in english for us to put up in the bar at THe Raft in Walvis Bay, Nambia,

    many thanks,

    Sarah

  237. pankaj acharya on June 10th, 2010 3:31 am

    Awesome job. Grateful if u could please email me the tie sheet in english to put up at the city hall.

    Pankaj

  238. Ali on June 10th, 2010 8:36 am

    amazing , love it

    can anyone please email it with the password to

    springfeild@hotmail.com

    thank you very much

  239. Spence on June 10th, 2010 7:31 pm

    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

  240. tony on June 10th, 2010 8:12 pm

    amazing , l love it
    can anyone please email it with the password to me

    Thanks a bunch!!

    Ole Ole!!!!

  241. ridwander » World Cup is coming! Google’s special “next page” icon on June 10th, 2010 8:54 pm

    [...] 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 [...]

  242. Jack Jones on June 10th, 2010 11:33 pm

    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…

  243. smn on June 11th, 2010 2:36 am

    flags / table broken on excel 2010

  244. WM – es geht los! | sascha kordel on June 11th, 2010 10:22 am

    [...] 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 [...]

  245. makh on June 11th, 2010 4:50 pm

    its not working. it says that’s there’s somethin wrong with the formula. and i use a mac. so wtf shuld i do ?

  246. TC on June 11th, 2010 5:10 pm

    This is awesome! Great job with excel!

  247. Marchelo on June 11th, 2010 8:40 pm

    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.

  248. Tan Truong on June 12th, 2010 2:18 am

    Hi, great spreedsheet can you pls email it to me…cheers!

  249. Mark D on June 12th, 2010 9:12 am

    Great Spreadsheet.

    One Question. How do you fill in the “drawing feature” table?

    Many Thanks.

  250. farshad on June 12th, 2010 10:48 am

    hi can u email me the sheet plz…

  251. farshad on June 12th, 2010 10:55 am

    can u plz send me the work sheet thru mail …

  252. MUHAMMAD TOZAMMAL HOSSAIN on June 12th, 2010 11:13 am

    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

  253. Michael Daniels on June 12th, 2010 12:40 pm

    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 :) !

  254. Fernando on June 12th, 2010 4:58 pm

    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.

  255. J. J. on June 12th, 2010 5:33 pm

    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!

  256. J. J. on June 12th, 2010 5:39 pm

    … 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?

  257. Andreas W. on June 12th, 2010 7:18 pm

    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.

  258. Mark D on June 13th, 2010 4:23 pm

    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.

  259. Criolo on June 13th, 2010 11:14 pm

    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!

  260. Kent on June 14th, 2010 4:30 am

    It’s great?
    What is the password?

  261. Kartik on June 14th, 2010 2:05 pm

    Kolkata/Mumbai, India time zone is not correct. It is +20 min in the present version. Pls correct this in the Next Version.

  262. Peter Wallengren on June 14th, 2010 2:35 pm

    Hi

    Please send me the file.

    Best Peter

  263. nit on June 14th, 2010 7:07 pm

    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

  264. Mark D on June 15th, 2010 2:52 am

    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.

  265. My World Cup predictions | Zepfanman.com on June 15th, 2010 2:58 pm

    [...] 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 [...]

  266. DjDiabolik on June 15th, 2010 10:51 pm

    Version 1.44 !!!! Italian Conversion Error!!

    Appears Australi and not Austalia..
    It’s possibile to edit manually !?!?!?!?

  267. DjDiabolik on June 15th, 2010 10:56 pm

    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 ??

  268. Mark D on June 16th, 2010 2:30 am

    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.

  269. Sushi on June 16th, 2010 5:24 am

    Thanks for the score sheet. It’s great.

    in 1.44 German Language. Australia is listed as Austria(Österreich)

    Should be (Australien)

  270. Steve Pitt on June 16th, 2010 1:28 pm

    There is no Switzerland in group H there are 2 Chile’s
    Regards

  271. Vladislav on June 16th, 2010 5:11 pm

    Thanks a lot for your great work!

  272. Ivan Lijeron on June 16th, 2010 8:58 pm

    it looks good.

  273. Vu Thanh on June 17th, 2010 1:05 am

    Thankssssssssssssssssssssssssssssssssss

  274. Vu Thanh on June 17th, 2010 1:06 am

    time 18-24 error

  275. Thu on June 17th, 2010 10:08 am

    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

  276. Nhan on June 17th, 2010 11:18 am

    Yeah, it’s great even though it’s quite funny to see translation into Vietnamese. Thanks a lot.

  277. Colin on June 17th, 2010 4:09 pm

    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

  278. FIFA Worldcup Excel Spreadsheets [Roundup] | Chandoo.org – Learn Microsoft Excel Online on June 18th, 2010 8:37 am

    [...] 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, [...]

  279. The~GoDFaTheR on June 21st, 2010 3:01 pm

    plz the pass

  280. Mc on June 22nd, 2010 11:35 am

    this excel template is not good…
    the goal difference standing is totally out of order…please fix ASAP

  281. Ronny on June 22nd, 2010 4:13 pm

    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

  282. saber on June 22nd, 2010 4:44 pm

    Group A result is wrong.
    Uruguay & Mexico will go through the next round, why South Africa ? Fix it.

  283. Admin on June 22nd, 2010 5:11 pm

    Hi,

    Make sure that you use the template with version 1.44 above.

    Regards

  284. Steve B on June 22nd, 2010 6:26 pm

    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

  285. Henk on June 22nd, 2010 9:28 pm

    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 !

  286. Fermin Espinosa Abonza on June 23rd, 2010 1:35 am

    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

  287. salem on June 23rd, 2010 11:20 am

    Excellent

  288. alex on June 23rd, 2010 7:14 pm

    Great work…. Thank.

    The fixture and standings on group A do not update by themselves… can you or I fix this bug? Thanks

  289. Mohammed on June 24th, 2010 12:10 am

    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

  290. Cade on June 24th, 2010 7:09 am

    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!!

  291. NoNeedToKnow on June 24th, 2010 8:22 am

    Please fix calculation of group phase. Mexico and Ghana appear to be outwhich is wrong :-(

  292. Jim on June 24th, 2010 8:31 am

    Guys,

    I have no standings problem. I think you should download and use the latest version. Mine is V1.45.

    Cheers

  293. Jug on June 24th, 2010 12:49 pm

    Excellent. I like this template.
    Could you send me sheet protection password for learning.

    jchaiwongsa@gmail.com

    Thanks.

  294. FranKoa on June 24th, 2010 1:14 pm

    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

  295. FranKoa on June 24th, 2010 1:16 pm

    Sorry, my email is francisqq@gmail.com if you are willing for me to learn better Excel. :P

    Thanks again

  296. Jeremie on June 24th, 2010 1:28 pm

    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

  297. vidch on June 25th, 2010 3:49 am

    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.)..

  298. Michael on June 25th, 2010 8:36 am

    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.

  299. Phil on June 25th, 2010 10:53 am

    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

  300. Phil on June 25th, 2010 10:58 am

    forgot to mention version I’m using is v1.36

  301. Phil on June 25th, 2010 11:05 am

    Apologies – just downloaded v1.45 and it fine.
    Thanks

  302. pap on June 25th, 2010 3:22 pm

    if I put Chile 0, Spain 1 and Swiss 1, Honduras 0, it shows an error on the standigs of group H. any comments?

  303. Leo BFG on June 26th, 2010 4:17 pm

    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!

  304. Vvn on June 26th, 2010 5:07 pm

    Thanks a lot. However, it’s not compatible with Excel 2010.

  305. MAT on June 29th, 2010 7:15 am

    Thanks

  306. asif h on June 29th, 2010 9:26 am

    password: AABAABAABBBD
    worked for me

  307. itsme on July 1st, 2010 6:03 pm

    great work

    thanks a lot

  308. Voi on July 5th, 2010 8:27 am

    Just entered scores for match 58 but you don’t get a winner if it goes to penalties.
    Using v1.45.
    ta

  309. Billy on July 6th, 2010 8:12 am

    can you please email me the password to un protect the sheet…

  310. Elie Jabbour on July 6th, 2010 1:35 pm

    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

  311. Nuno on July 12th, 2010 11:51 pm

    Hi Admin,

    Can you tell me how did you make the rigth flag appears associated to a cell number?

    Thank you

  312. Mr.Steven Mark on November 14th, 2010 9:05 am

    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

  313. Mirella Groat on February 4th, 2011 2:43 pm

    I was aware about this already, nevertheless there have been some helpful bits that finished the picture for me personally, many thanks!

  314. Sebastian on August 1st, 2011 10:44 am

    Hi, could you send me the password please? Great spreaddie

  315. ????? on February 25th, 2012 1:54 pm

    ?????…

    ?????…

  316. Olaniyi on March 2nd, 2012 10:41 pm

    hi thanks a lot for the spreadsheet it was very helpful

  317. Stratis on March 14th, 2012 2:07 pm

    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.

  318. Repairs computer on June 1st, 2012 12:22 am

    I have fun with, result in I discovered exactly
    what I was looking for. You’ve ended my 4 day long hunt! God Bless you man. Have a nice day. Bye

  319. Viamrsh Shetty on June 12th, 2012 9:38 am

    Hello there, just become aware of your weblog through Google, and located that
    it’s really informative. I’m gonna watch out for brussels. I will appreciate for those who continue this in future. Many people can be benefited from your writing. Cheers!

  320. Credit Check Online on July 16th, 2012 2:20 pm

    Hi there! I could have sworn I’ve visited this web site before but after going through a few of the posts I realized it’s new to me. Anyways, I’m certainly happy I found it and I’ll be book-marking it and checking back often!

Leave a Reply