12 Jan 2014

Calendar 2014 v3

#4  Calendar 2014 v3 - Multi-year and Multi-language

In this article I´ll explain the new version (v3) of my Excel doc Calendar 2014.

- At the end of this article you can find the URL where you can download the Excel-doc. (for free), and in mirror #3 there is also a PDF-version.
- The Excel is set up for use in Madrid-Spain (it has the Spanish holidays and school-year: 'Calendario Laboral Madrid (capital)' , 'Calendario Escolar 2013-2014  CA Madrid'), but of course you can change that.

Calendar-v3 has the following improvements :

- It has 5 different kinds of calendars:
  1. 2014 per week
  2. 2014 per quarter
  3. 3 years: 2013, 2014, 2015 (triennium) *
  4. 2 years: 2013, 2014 (biennium) *
  5. school-year: 2013-2014 *
(*): new in version 3

- It has a parameter to set your language (English, Spanish, French, German, Dutch, Italian). So in stead of calendar-v2 with it´s bilingual (Spanish and English) month- and weekday-labels (e.g. weekday 1: Lu.Mo, Lunes.Monday), calendar-v3 shows 'L' (if you set the language-parameter to Spanish) or 'M' (if you set the language-parameter to English). See fig.1-2.
And if your language is not in the list of 6, you can use the 'free' column 7 ('HEX') to write your own labels (now 'HEX' has hexadecimal values which I used for testing).

- I tried to follow as much as possible the Microsoft Excel template design guidelines:

fig.1: Calendar1 in Spanish

fig.2: Calendar1 in English

Some print-screens of the new calendars in v3:

fig.3: 2 years: 2013, 2014 (biennium)

fig.4: school-year: 2013- 2014

The calendar 'school-year 2013-2014' (in Spain: from Sep. 2013 to Jun. 2014) in fig.4 I made by using the biennium-calendar (fig.3), so by copy-pasting the months Sep.- Dec. of 2013 and Jan.- Jun. of 2014. 

I hope the calendars can be usefull for you, but in case you might find them boring, you can always use the one which I saw the other day in the newspaper '20 Minutos':

or look for some design-calenders, here you can find some real nice ones:


No comments: