Showing posts with label Calendar. Show all posts
Showing posts with label Calendar. Show all posts

5 Jun 2016

Month-calendar for June 2016 in Excel

#56 Month-calendar for June 2016 in Excel

In this post the new month-calendar for June, see fig.1. The Excel also has the year-calendar for 2016 and a 2016-year-planner. Event of this month is UEFA Euro 2016 France, hold on 10/6 - 10/7. Unfortunately the Netherlands did not qualify, so this time I was not so motivated to make a new version of Match for this Eurocup, or a new Excel for an office-pool, like I did for last FIFA Worldcup. But of course you can do it by yourself, by adapting these 2 files (Access and Excel):

http://worktimesheet2014.blogspot.com.es/2014/05/match-access-app-to-track-world-cup.html

http://worktimesheet2014.blogspot.com.es/2014/05/pool-for-betting-2014-world-cup-soccer.html

For a very nice Excel with a EURO 2016 tracker, which automatically calculates the points, who go to next round etc (by using formulas), see:

http://www.excely.com/football/euro-2016-schedule.shtml




fig.1: Month calendar 201606


Downloads:

https://goo.gl/BA0cJU







2 May 2016

Month-calendar for May 2016 in Excel

#55 Month-calendar for May 2016 in Excel

In this post the new month-calendar for May, see fig.1. The Excel also has the year-calendar for 2016 and a 2016-year-planner. Event of this month is Roland Garros, the French Open ATP tennis tournament, 22/5-5/6.




 fig.1: month-calendar May 2016




Downloads:

https://goo.gl/q3lwNW





2 Apr 2016

Month-calendar for April 2016 in Excel

#54 Month-calendar for April 2016 in Excel

In this post the new month-calendar for April, see fig.1. The Excel also has the year-calendar for 2016 and a 2016-year-planner. Event of this month is 'El Clasico', Barcelona vs Real Madrid, Sat. April 2, in the stadium of Barca, Nou Camp, in which there will be a 'remembrance-mosaic' with the Barca-shirt with number 14´, the number of Johan Cruyff, the Dutch legendary player and coach of this club, who died last March 24. Cruyff was besides for his football also famous for his oracle-like aphorisms, like "every disavantage has its advantage" and his logic like : " I do not believe. In Spain  all 22 players make the sign of the cross before they enter the field, and if it would work, it would always be a draw." , see:


--

--
Fig.1: calendar April 2016

12 Mar 2016

Month-calendar for March2016 in Excel

#53 Month-calendar for March2016 in Excel

In this post the new month-calendar for March2016, see fig.1. The Excel also has the year-calendar for 2016 and a 2016-year-planner. Event of this month is la Volta Ciclista a Catalunya 2016 (in Spain). For more info about this event , see:





fig.1: calendar March 2016


Downloads:

2 Feb 2016

Month-calendar for February 2016 in Excel

#51 Month-calendar for February 2016 in Excel

In this post the new month-calendar for February 2016, see fig.1. The Excel also has the year-calendar for 2016 and a 2016-year-planner. Event of this month is Lillehammer 2016 Youth Olympic Games (YOG), the Wintergames for children from 15-18 years. For more info about this event , see:

http://www.lillehammer2016.com/



fig,1 Calendar for month February 2016


Downloads:

https://goo.gl/Ap3yxl



2 Jan 2016

2016 Year calendar and planner in Excel

#49 2016 Year calendar and planner in Excel

In this post the new year calendar and planner for 2016 and the month-calendar for January, see fig.1-3. For the Spanish readers: the calendar includes all holidays in Madrid-capital, so it´s the 'calendario laboral 2016', see:

https://sede.madrid.es/portal/site/tramites/menuitem.1f3361415fda829be152e15284f1a5a0/?vgnextoid=4366addba8200510VgnVCM1000000b205a0aRCRD&vgnextchannel=239be59bdb789210VgnVCM100000171f5a0aRCRD

or this site, which also has a year-calender (in PDF):

http://www.calendarioslaborales.com/calendario-laboral-madrid-2016.htm

My calendar also has the (ISO) week-numbers (week 1 is the week with the 1st Thursday of the year). And it is multi-language (English, Spanish, French, German, Dutch, Italian, Korean, Chinese).
NB: For more about the Korean and Chinese variant, see earlier 'Calendar-posts' (see my blog-posts with tag/label 'Calendar' at the end of this post).


The graphic I used in this Excel, this time about the new year 2016, which is the year of the monkey in the Chinese horoscope, is from this site :

http://thumbs.dreamstime.com/z/chinese-new-year-monkey-year-symbol-calendar-red-figures-illustration-53158214.jpg

And for more info about the Monkey- (leap) year 2016, see:

http://www.guy-sports.com/humor/christmas/chinese_new_year2016.htm

Happy 2016!



fig.1 Month Calendar January 2016



fig.2: Year Calendar 2016



Downloads:

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




#Mirror 2: Microsoft Onedrive (1 Excel file):
NB: this site has 'Excel-Online', so you can view my Excel-doc if you don´t have MS Excel on your PC

http://1drv.ms/1MMB2sr


#Mirror 3: Scribd.com (1 PDF file):

https://es.scribd.com/doc/294441979/2016-Year-Calendar-and-Planner

7 Dec 2015

Month-calendar for December 2015 in Excel

#47 Month-calendar for December 2015 in Excel

In this post the new month-calendar for December 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner. Event of this month is Carrera de las Empresas 2015 Madrid (13/12), a 10K run, a competition between (teams) of companies, so an event where work and sports meet like in this blog. For more info about this event , see:

http://www.carreradelasempresas.com/

http://www.expansion.com/actualidadeconomica/2015/11/02/5633741b46163f905f8b45b5.html



                                          fig.1 Dec.2015 calendar


Downloads:

https://drive.google.com/file/d/0BywxxSJoaUYxQVdFeFpESDlhRUU/view?usp=sharing

4 Nov 2015

Month-calendar for November 2015 in Excel

#44 Month-calendar for November 2015 in Excel


In this post the new month-calendar for November 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner. Theme of this month is the Science Week, 'la Semana de la Ciencia', in Madrid (2/11-15/11), where universities etc. open their doors to the public, see:


http://www.madrimasd.org/semanaciencia/2015/


Last year one of the activites of the Science Week was a guided walk in a garden with Bonsai-trees, for some photos I made, see:

https://picasaweb.google.com/103278159654062440102/Bozai

And if your are interested in some science about data-visualization and the important role of Exel in this, as I have tried to show in several posts in this blog (with label: 'Data visualization'), see:

https://blogs.scientificamerican.com/sa-visual/the-science-of-visualization/



--fig.1: Nov. 2015 Calendar

Download:

https://goo.gl/pJdDcd

1 Oct 2015

Month-calendar for October 2015 in Excel

#43 Month-calendar for October 2015 in Excel


In this post the new month-calendar for October 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner. Theme of this month is the Worldcup Rugby (until 31/10), see:


http://www.rugbyworldcup.com

The quote of this month, comparing soccer and rugby, I found on this poster:

https://www.facebook.com/veitchyonsport/photos/a.566695656700484.1073741828.203262656377121/692113720825343/?type=1&theater


It will be interesting to see how the teams who play against New Zealand will respond to their intimidating Maori war-dance, the famous 'Haka' (which until now worked well for them: in the Worldcup the 'All Blacks' currently are leading in their pool).  So this Worldcup no 'Waka Waka', but the 'Haka', for some nice videos, see :

https://youtu.be/GyZEUeAoFKE

https://www.youtube.com/watch?v=yiKFYTFJ_kw

https://youtu.be/bUZJyZldy10

fig.1 month-calendar Oct.2015

Downloads:

https://goo.gl/J6Uuzx 




1 Sept 2015

Month-calendar for September 2015 in Excel

#42 Month-calendar for September 2015 in Excel

Note 10/9/2015: I updated this post, with a new Excel which includes a 2015/16-schoolyear-calendar, see fig.2 and dowload-url V2 below.

In this post the new month-calendar for September 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner. Theme of this month is (again) "La Vuelta Ciclista a España - Cycling Tour of Spain 2015", which is held from 20 Aug. to 13 Sept.,  for more info, see:

http://www.lavuelta.com/15pr/en/index.html

The reason to repeat the theme (la Vuelta was also theme of month in Aug.) was to write about a Dutch surprise in this edition of La Vuelta, Tom Dumoulin, who won yesterday in a magnificant race the 9th stage (in Valencia), and is now also leading in the general ranking.  For a video of (part of) the race, see e.g.:

https://youtu.be/Ko-Hix712Ck
https://youtu.be/zj3r4apKNhY

I hope to see Dumoulin finish here in Madrid 13 Sept in the red jersey ( the Spanish yellow jersey).


Fig.1: month-calendar


fig.2: schoolyear-calendar


Downloads:

V1:
https://drive.google.com/file/d/0BywxxSJoaUYxaWUxSVh4QUhBY1U/view?usp=sharing

V2 (zip with Excel and PDF-version):
https://goo.gl/XoCvaG

1 Aug 2015

Month-calendar for August 2015 in Excel

#40 Month-calendar for August 2015 in Excel

In this post the new month-calendar for August 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner. Theme of this month is "La Vuelta Ciclista a España - Tour of Spain 2015", which starts 20 August, for more info, see:

http://www.lavuelta.com/15pr/en/index.html

This cycling Grand Tour also passed through the mountains Picos de Europa (Asturia), a very nice part of Spain where I spent several holidays, for some photos, see:

https://www.flickr.com/photos/46731978@N00/7573362742/in/photolist-c: eqYW-cxereq-cxerEL-cxestW-cxesTG-cxes2m-cxetdw-cxetNb-cxeu37-cxeuvE/

In my calendar I used a clipart from:
http://www.chungkong.nl/wp-content/uploads/2015/04/MY-VUELTA-A-ESPANA-MINIMAL-POSTER-2015-2-720px.jpg


-- fig.1

Downloads (Excel and PDF):

https://goo.gl/JZ1fte

2 Jul 2015

Month-calendar for July 2015 in Excel

#39 Month-calendar for July 2015 in Excel

In this post the new month-calendar for July 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner. Theme of this month is "(Free) Summer Courses by Open University Madrid (UDIMA)", aprox. 70 courses 'online' (with Google Hangout) during the whole month of July. The courses are about various themes, one of them is Business Administration, with a course about Excel: "Treatment of Accounting data with MS Excel. Pivot-tables and Power Pivot".  So the courses are free, online (type: Open Education), last about 1 hour, are in Spanish and had in 2014 over 10.000 'students' of about 56 countries (mainly Spanish-speaking). For more info about the UDIMA summer courses, see:

http://www.udima.es/es/cursos-verano-2015



--fig.1


Download:

https://goo.gl/ci8p1j

2 Jun 2015

Month-calendar for June 2015 in Excel

#37 Month-calendar for June 2015 in Excel

In this post the new month-calendar for June 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner.
Theme of this month is "Rotary Streetsoccer Oldenzaal 2015", a soccer-tournament for schools in Oldenzaal (Netherlands), with 338 teams (2200 kids) participating this year, a new record.  For more info about this tournament, see:

www.rotarystreetsoccer.nl

and for some videos, see:
https://m.youtube.com/watch?v=Pj8g5qDJk5A
https://m.youtube.com/watch?v=CBK-sYJPRA4

And for photos, see:
https://www.facebook.com/RotaryStreetsoccer/photos

As I wrote in a previous post, see:
http://worktimesheet2014.blogspot.com.es/2014/05/match-access-app-to-track-world-cup.html

I made a computer-program, Match, for this tournament (6 years ago), with MS Access. For some
of the reports of Match for this year´s edition of the tournament, see:

https://drive.google.com/folderview?id=0B_emFzfVW20dalR5REd2aHljeEU&usp=sharing&tid=0B5vS1W52SGhjZ3gzc3ltSG9xek0

https://drive.google.com/folderview?id=0B_emFzfVW20dRTdXN1Fna0IzSVE&usp=sharing&tid=0B5vS1W52SGhjZ3gzc3ltSG9xek0

https://www.facebook.com/RotaryStreetsoccer/photos/a.693853170666477.1073741829.319101751474956/899126876805771/?type=1&theater

And for all other Match-reports and everything else about Match and how it can be used for competitions like Rotary Streetsoccer, see the user manual:
https://es.scribd.com/doc/119063075/Handleiding-Match-2012-pdf

Note that for this calendar I used '#' to color-format the days of the tournament, and that the weekdays are in Dutch, which I configured in sheet-1, where you can select from varios languages.

And to conclude this post I want to recommend you this Excel.course by TU Delft (Delft University of Technology, where I studied computer science):

https://courses.edx.org/courses/DelftX/EX101x/1T2015/info

Data Analysis: Take it to the MAX(), a course with videos about how you can do data-analysis with MS Excel.


--fig.1


Download:

https://goo.gl/pt4Jfg

4 May 2015

Month-calendar for May 2015 in Excel

#36 Month-calendar for May 2015 in Excel

In this post the new month-calendar for May 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner.
Theme of this month is "La carrera de la mujer Madrid", a 10K race for women to raise funds for breastcancer research, hold on Sun. 10/5 with over 30.000 participants. For more info, see:

http://www.carreradelamujer.com/


--fig.1

Download:

http://goo.gl/dUU0tS






2 Apr 2015

Month-calendar for April 2015 in Excel

#34 Month-calendar for April 2015 in Excel

In this post the new month-calendar for April 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner.
Theme of this month is Semana Santa (Easter Week) in Madrid, with processions in the street in which you can see men with cone-shaped hats (see fig.1). For more info, see:
www.semanasantamadrid.es

and for a video o Semana Santa in Sevilla, maybe the most famous one of Spain, see:
https://www.youtube.com/watch?v=YOL3eeDdAXw



--fig.1


Download:

http://goo.gl/nsfTH3






4 Mar 2015

Month-calendar for March 2015 in Excel

#33 Month-calendar for March 2015 in Excel

In this post the new month-calendar for March 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner.
Theme of this month is Spring, which in Madrid, with days of 20C already, is anounced by the almond-trees in park Quinta de Molina as you can see on my photos:


https://www.flickr.com/photos/46731978@N00/13168647425/






fig.1 Month-calendar March 2015




Download:

http://goo.gl/1itdxG





1 Feb 2015

Month-calendar for February 2015 in Excel

#31 Month-calendar for January 2015 in Excel

In this post the new month-calendar for February 2015, see fig.1. The Excel also has the year-calendar for 2015 and a 2015-year-planner.
The event of this month is ISU World Cup Speed Skating, February 7-8, 2015, in 'ice-temple' Thialf ( Heerenveen, Netherlands), see for more info:

http://www.isu.org/en/speed-skating/calendar-of-events/2015/02/isu-world-cup-speed-skating-heerenven



fig.1 2015-Calendar month Feb.

Downloads:

#Mirror 1 :

http://goo.gl/oq7mHR

29 Dec 2014

Year calendar and planner 2015 and Month-calendar Jan.

#29 Year calendar and planner for 2015 and Month-calendar January in Excel and PDF

In this post the new year calendar and planner for 2015 and the month-calendar for January 2015, see fig.1-3. For the Spanish readers: the calendar includes all holidays (so it´s the 'calendario laboral 2015').
The graphic I used in this Excel, this time about the new year 2015, which is the year of the (green) sheep in the Chinese horoscope, is from this site with public domain cliparts:
http://www.clker.com/clipart-green-sheep.html



Fig.1: 2015 year-planner


Fig.2: 2015 year-calendar



Fig.3: Jan. 2015 month-calendar


Downloads:


#Mirror 1 (PDF file):
https://es.scribd.com/doc/251216011/Calendar-201501

 #Mirror 2 (Excel file):
NB: this site has MS Onedrive, which has 'Excel-Online', so you can view my Excel-files here if you don´t have MS Excel on your PC

http://1drv.ms/1JWMNPk

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

http://goo.gl/eq5Mpq

http://goo.gl/rmWopZ

30 Nov 2014

Month-calendar for December and 2015 year-calendar in Excel

#28 Month-calendar for December and 2015 year-calendar in Excel 

In this post the new month-calendar for December 2014, with week-numbers (see fig.1) in my multi-language (English, Spanish, Chinese and some more languages) Excel. The Excel also has the year-calendar for 2015 (see fig.2). And soon I´ll make a new version which includes the 2015- year-planner.
The graphic I used in this Excel is from this site with public domain cliparts, this time about Xmas.

http://www.clipartlord.com/category/christmas-clip-art/reindeer-clip-art/

, thanks for sharing!





      fig.1 2014-Calendar month Dec.



           fig.2 2015 year-calendar

Downloads:

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

https://drive.google.com/file/d/0BywxxSJoaUYxMFI1UGlEUHAxbTQ/view?usp=sharing

1 Nov 2014

Calendar 2014 November in Excel in Chinese

#26 Calendar 2014 November in Excel in Chinese

I made a new version (v13) of my Excel Calendar (see fig.1), which is almost the same as v12, but now with the month-calendar for November, and I also added Chinese day and month names. I don´t know anything about Chinese, except that it is a CJK-language and I thought that if I have Korean as a language in my Excel Calendar, I should also include Chinese as the most spoken language in the world. For more info about CJK-languages and special characters in MS Excel (Office), see my post with a calendar in Korean:

http://worktimesheet2014.blogspot.com.es/2014/01/calendar-2014-v5-korean-part-12.html

This month´s item is 'La carrera del niño 2014', a run organized by hospital Niño Jesus, to raise funds for investigation of severe diseases with childeren, like e.g. cancer. For more info see:

http://correporelnino.wordpress.com

And if you find this calendar a bit boring, you can decorate it as you like, see fig.2 for an example of a 'kids-version'.


fig.1 2014-Calendar month Nov., in Chinese


fig.2 (photo of) Excel-Calendar, kids-version




Downloads:

#Mirror 1:
https://drive.google.com/file/d/0BywxxSJoaUYxRy1ULUxwTnBSZWs/view?usp=sharing