In my previous post I wrote about an Excel doc. I made to track your worked hours. Besides that, it also contained a calendar for 2014, with Spanish holidays ('calendario laboral') and a vacations-planner. In this post I write more about the calendar, for which I created a new Excel-doc, with some changes.
In this article I´ll explain an Excel-document (xlsx, version 2010) I made: Calendar 2014
NB:
- At the end of this article you can find the URL where you can download the Excel-doc. (for free)
- the Excel-doc is in Spanish, but in the Excel-doc of my 1st post you can see a translation in English of the most important Spanish terms.
The Excel-doc has 2 versions of the calendar 2014:
- week x weekday (52x7 matrix), see fig.1
- quarter x month (4x3 matrix), see fig.2
Notation of dates in cells: month + day
Every month has a different color (I created 12 conditional formatting rules).
fig.1
fig.2
Download-mirrors:
* Mirror #1:
https://skydrive.live.com/redir?resid=3F963E9F1A42D952!130&authkey=!AA_h9uKhpnqOhJo&ithint=file%2c.xlsx
* Mirror #2:
https://drive.google.com/file/d/0BywxxSJoaUYxUkpRbEFpR1RhbE0/edit?usp=sharing
* Mirror #3:
http://es.scribd.com/doc/197075559/Calendario-Laboral-2014-Espana
No comments:
Post a Comment