#22 Worldcup Basketball 2014 Match Schedule
Note 14-9: Update Excel after final, V6
Note 10-9: Update Excel after matches of today, V5
Note 9-9: Update Excel after matches of today, V4
Note 8-9-2014:
I updated this Excel after the 1/8 finals with the 1/4 finalists (V3).
Note 6-9-2014:
Now the group-phase has ended and the 16 1/8 finalists are known, I updated this Excel, to which I refer below with v2. Besides, I also included a bracket (tournament schema in tree.from for finals), see fig.2.
Spain was counting down for the Spain 2014 FIBA Worldcup Basketball , but now it has finally started! And in Madrid, basketball is everywhere now, for some photos I made, see:
https://www.flickr.com/photos/46731978@N00/sets/72157647082847479/
I made an Excel with the match-schedule for this event, see. fig.1. It is in the same style as the Excel I made for the Soccer Worldcup, see post:
http://worktimesheet2014.blogspot.com.es/2014/05/excel-with-match-schedule-for-2014-fifa.html
so see that post for more info about the format of the match-schedule.
To make this Excel, I used:
http://fiba-2014.com/fiba-2014-schedule-fixtures-matches/
and
http://en.wikipedia.org/wiki/2014_FIBA_Basketball_World_Cup
which has the data about the matches and teams in table-format, which made it easy to import it using PowerQuery, about which I wrote in this post:
http://worktimesheet2014.blogspot.com.es/2014/05/excel-2013-and-business-intelligence.html
In Download-mirror #2 you can see in Excel v0 the result of this import. To come to the final version of the match-schedule, was more work then I thought, mainly because the data in the table was not 100% structured (e.g. date and time in 1 column) and even had some errors. To prevent this kind of errors, I made some pivot-tables (see sheet3-5 in my Excel) which has checks like: all groups have same number of games, at 1 time and place there is only 1 game (no 'over-booking') etc.
Well, I hope with my Excel you´ll enjoy the Worldcup Basketball even more.
Go Gasol, go
ÑBA!
NB: Some links with more info about the Worldcup:
http://www.fiba.com/spain2014
http://www.fiba.com/basketballworldcup/2014
http://as.com/especiales/baloncesto/mundial/2014/calendario.html
http://www.marca.com/deporte/baloncesto/mundial/calendario.html
fig.1: Match Schedule Worldcup Basketball
fig.2 Match Schedule Worldcup Basketball in bracket-fomat
NB: to create this bracket, I used this Excel-template from the MS website:
Downloads:
#Mirror 1 (PDF file):
http://es.scribd.com/doc/238226655/Spain-2014-FIBA-WorldCup-Basketball
#Mirror 2 (Excel file):
NB: this site has MS Onedrive, which has 'Excel-Online', so you can view my Excel-calendar here if you don´t have MS Excel on your PC
https://onedrive.live.com/redir?resid=3F963E9F1A42D952%21240
#Mirror 3 (V1: 1 zip file with Excel and PDF files, V2: bracket-schema and 1/8 finalists):
V1:
https://drive.google.com/file/d/0BywxxSJoaUYxZDhKd2JnTmhaTUk/edit?usp=sharing
V2:
https://drive.google.com/file/d/0BywxxSJoaUYxekRyRU50WlRlM1k/edit?usp=sharing
V3:
https://drive.google.com/file/d/0BywxxSJoaUYxNzlITjB6aGc1SVk/edit?usp=sharing