31 Aug 2014

Calendar 2014 v11, for Sept.

#23 Calendar 2014 v11, for month Sept.

I made a new version (v11) of my Excel Calendar, which is the same as v10, but I updated the month-calendar for September, and included the days in this month of a big sport-event here in Spain: Spain 2014 FIBA Basketball Worldcup, see fig.1. If you are interested in this event, I made an Excel with the match-schedule, see post:

http://worktimesheet2014.blogspot.com.es/2014/08/worldcup-basketball-2014-match-schedule.html



fig.1: Calendar month Sept.


Downloads:

#Mirror 1 (PDF file):

http://es.scribd.com/doc/238226627/Month-Calendar-201409-Sept

#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%21241

#Mirror 3 (1 zip file with Excel and PDF files):


https://drive.google.com/file/d/0BywxxSJoaUYxeWU2d0haTlpDbDQ/edit?usp=sharing


Worldcup Basketball 2014 Match Schedule

#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



20 Aug 2014

Calendar 2014 v10: with week-nr and new month-calendar

#21 Calendar 2014 v10:  with week-nr and new month-calendar

I made a new version (v10) of my Excel Calendar, which is the same as v9 (see post #19) + :

- year-calendar with ISO-week-numbers, see fig.1
NB: I recently learnt that the use of week-numbers is very common in Switzerland, see:

http://vowe.net/archives/008475.html

- new month-calendar, which has besides the actual month also the previous and next month, and some extra things to make the calendar less grey.., see fig.2



fig.1 Year calendar with week-numbers, numbers before Mon. and after Sun., between ( and )

fig.2: Month-calendar


Downloads:

#Mirror 1 (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%21238


#Mirror 2 (1 zip file with Excel and PDF files)

https://drive.google.com/file/d/0BywxxSJoaUYxdUdHcDB6b09VSFU/edit?usp=sharing