File Notes

World Cup 2014 files Change Log

!! IMPORTANT SECURITY NOTE !! : Files contain Macros. To ensure some Security please Only download through this official website and always scan your downloads with reputable Virus scanners (or use online multi virus scanners such as https://www.virustotal.com/). To learn more about macros visit http://www.howtogeek.com/171993/macros-explained-why-microsoft-office-files-can-be-dangerous/.

Files for Excel 2010 (2007/2013)

Created on Excel 2010 SP2 32bit running on Windows 7 64bit SP1. May work on Excel 2007 & Excel 2013. File includes charts, calander, danger-men game for the 2014 world cup!

[note for Excel 2013 users – this file will run very very slow on Excel 2013 due to the way Microsoft has designed Excel 2013 when running protected macros – recommend offing Flags or using the 2003 version of this file]

*A* 

Ver. A 1.11 (13 July 14 LATEST VERSION) – Sweepstakes versionfinal scores

Ver. A 1.09 (3 July 14 ) – Sweepstakes versionscores updated to game 56, colour formatting bug chart 2+3 corrected.

Ver. A 1.06 – Ver. A1.08 (2 July 14) – Sweepstakes versionscores updated.

Ver. A 1.05 (26 June 14 ) – Sweepstakes versionextra predictions analysis graph added, scores updated to game 48.

Ver. A 1.04 (24 June 14) – Sweepstakes versionextra predictions analysis graph added, scores updated to game 36.

Ver. A 1.03 (15 June 14 ) – Sweepstakes version – Italian language corrections , timezone GMT +5:45  GMT+6:30 added, displayHeadings chart bug resolved.

Ver. A 1.02 (8 June 14) – Sweepstakes versionPrediction points system finalised.

Ver. A 1.01 (1 June 14)PC Regional Date format settings bug now corrected.

Ver. A 1.00 (27 May 14) – Sweepstakes version.

*B* 

Ver. B 1.09 (13 July 14 LATEST VERSION) – LITE charts Version – final scores

Ver. B 1.05 (3 July 14 ) – LITE charts Version – scores updated, colour formatting bug chart 2+3 corrected.

Ver. B 1.05 – B 1.06 (2 July 14 ) LITE charts Version – scores updated.

Ver. B 1.04 (22 June 14 ) – LITE charts Version – scores updated to game 29

Ver. B 1.03 (19 June 14) – LITE charts Versionminor updates

Ver. B 1.02 (10 June 14) – LITE charts Versioneasy export to plain Excel file option added

Ver. B 1.01 (31 May 14 ) – LITE charts Version PC Regional Date format settings bug now corrected

Ver. B 1.00 (27 May 14) – LITE charts Version

*C* 

Ver. C 4.08 (13 July 14 LATEST VERSION) Ultimate Chart (for excel 2010 only)– final scores.

Ver. C 4.06 (3 July 14 ) Ultimate Chart (excel 2010 only)– scores updated to game 56, colour formatting bug chart 2+3 corrected.

Ver. C 4.03 C 4.05 (2 June 14) – Ultimate Chart (excel 2010 only)scores updated.

Ver. C 4.02 (8 June 14) Ultimate Chart (excel 2010 only) Prediction points system finalised.

Ver. C 4.01 (1 June 14) – Ultimate Chart (excel 2010 only)– PC Regional Date format settings bug  corrected on main sheets only.

Ver. C 4.00 (27 May 14 ) – Ultimate Chart – office pools / sweepstakes option added. 24 hour option added. File naming changed from “World Cup 2014 Brazil Chart and Danger-Men Game” to  “World Cup Brazil 2014 Ultimate Chart”. Sub versions created from this – see above

Ver.3.06 (5 May 14) – Corrected Summer Time Zones, Added ability to export Charts into PDF format, updated Chart Title Fonts.

Ver.3.05 (28 April 14) – increased Chart Title Customisation

Ver.3.04 (26 April 14) – Added: Ability to Partially Customise Chart Titles/Name (Create your own interesting Titles now!!),  Ability to add your own Translation, or change/swap team names with Peoples names, improved TimeZone Selection options.

Ver.3.03 (6 April 14 ) – Group stage table sort bug/error corrected. Further languages added: Bulgarian (български),  Croatia (Hrvatski), Czech (Čeština), Danish (Dansk), Hungarian (Magyar), Norwegian (Norsk), Poland (Polski), Thai (ภาษาไทย), Turkish (Türkçe), Urdu (اردو), Vietnamese (Việt)

Ver.3.02 (9 March 14 ) – German translation correction (Australia).

Ver.3.01 (5 Feb 14) – Languages increased to 22 – now includes: Afrikaans, Bengali (বাঙ্গালী), Hindi (हिन्दी भाषा), Italian (Italiano), Japanese (日本の), Korean (한국어), Romanian (Român), Swedish (Svenska).

Ver.3.00 (26 Jan 14) – MAJOR UPDATE – 14 LANGUAGES ADDED: Arabic (العربية), , Chinese 中文 (Simplified &Traditional), Dutch (Nederlands), French (Français), German (Deutsch), Greek (ελληνικά), Hebrew (עברית), Indonesian, Malay, Portuguese, Russian (русский), Spanish (Español).

Ver.2.03 (22 Jan 14 ) – Updated Schedule to latest World cup start times

Ver.2.02 (18 Jan 14) – game engine compile error bug occurrence on 64bit office versions corrected

Ver.2.01 (9 Jan 14) – minor bugs on chart corrected

Ver.2.00 (4 Jan 14) – MAJOR UPDATE – COUNTRY FLAGS ADDED

Ver.1.09 (22 Jan 14) – Updated Schedule to latest World cup start times.

Ver.1.08 (18 Jan 14) – 64bit bug correction.

Ver.1.01-1.07 (Dec 2013) – bug corrections

Ver.1.00 (Nov 2013) – initial release

*D – For Excel 2003* 

File with simple World Cup charts only. Made specifically for Excel 2003 , but will also work on all new excel versions (2007, 2010, 2013).

Ver.1.08 (13 July 2014) – Final scores

Ver.1.07 (4 July 2014) – scores updated.

Ver.1.06 (22 Jan 2014) – Updated Schedule to latest World cup start times

Ver.1.01-1.05 (Dec 2013) – bug corrections

Ver.1.00 (Nov 2013) – initial release

****

Ranking of teams in Group stage

This World cup template applies the full Fifa rules per below
(extracted from wikipedia  http://en.wikipedia.org/wiki/2014_FIFA_World_Cup#Final_draw)
“The group winners and runners-up advance to the round of 16. The ranking of each team in each group will be determined as follows:

Levels

1. Points obtained in all group matches;
2. Goal difference in all group matches;
3. 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:

4. Points obtained in the group matches between the teams concerned;
5. Goal difference in the group matches between the teams concerned;
6. number of goals scored in the group matches between the teams concerned;”

(7) EXCEL (my own code at this level) – create lookup to a unique reference list (i.e use a simple sequence , Brazil 1, Mexico 2  etc, or FIFA ranking).
this is to enable Excel to complete unique sort and trigger drawing Lots options field

“X. Drawing of lots by the FIFA Organising Committee.” – manually enter order of teams.

Ranking of teams in Group stage- smartcoder247

14 comments on “File Notes

  1. heyy.. I’m a programmer… I rly liked your excel program for the world cup 2014; and I’m writing to report a bug which is: the excel workbook (V 2.01) won’t work on a 64bit operating system running microsoft office 2010. Try it yourself. It will give the following error: “Microsoft visual basic for applications… Compile error in hidden module: SoundMod. This error commonly occurs when code is incompatible with the version, platform, ….”. this is the error that the users will see but won’t be able to debug it because the VBA is protected. This error is fixed with a small change in the VBA code to run on 64bit systems. I cracked the workbook, unprotected everything, fixed the error in the VBA code and reprotected it the same way with the same password. And now it’s working fine with me on my 64bit laptop. U should release a 64bit version of it.. I’ll tell u how to fix it. in the 64bit version, just add the keyword “PtrSafe” in all the declare statements in the VBA code.. for ex: Declare PtrSafe function … and this version with the PtrSafe added will work well with 64bit systems but maybe won’t work with 32bit versions.. so u gotta make 2 versions of the workbook… For more info contact me on my e-mail. Regards.

  2. Hi, i have a problem with the ver 3-01, it said the Macros are currently disabled.
    To play Catd Game please enable Macros (through options\Trust center settings) and restart Execl.
    Can you please help?
    can you please explain how can i do it to open the file?
    thx.

  3. i’ve tried to edit the wall chart as a test and it is saying that the document is protected and is read only, so how can i input the scores or edit the chart myself ?

  4. First match over – I’ve 20 people in my excel sheet. However, I went to the standings page and now I can’t get out of it. When I close it and come back into it I get the error: Run-time error’1004′: Unable to set the displayHeadings property of the window class.
    Any suggestions?

    • There were two issues, the first 1004′displayHeadings error was due to a VBA code line missing – this is now sorted (see new version Option A 1.03). The Second , sometimes getting locked on chart sheets is an issue with chart and button overlays dropping out – can’t satisfactorily resolve other than using Excel keyboard shortcut to move between sheets ( press Ctrl & Page Up) or unhide sheet tabs.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s