31 Jul 2014

Vacations planner in Excel

#20 Vacations planner in Excel

The Excel in this post is a vacations planner. It has all dates of 2014 and for every resource (team-member) you should mark with a number which date(s) he wants to take his vacation (by team-member) and if that is possible or not (by team-boss), like this:
 1: applied (yellow)
 2: aproved (green)
 3: refused (red)

Below you can see a small example of a company with 2 employers (John and Jane) which have to agree about their vacation-dates, in a way there is always at least 1 person at the office.


fig.1: on 3-2-2014 John and Jane wanted the same day off and Jane 'won'


fig.2: in August John and Jane both want to take a 2 week vacations, and there were no planning-conflicts


fig.3: On 31-12-2014 John and Jane both want to take a day off and they didn´t decide yet who can go


Downloads

#Mirror 1:
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


#Mirror 2:







Calendar 2014 v9: year/month/week-calendar in Excel

#19 Calendar 2014 v9: year/month/week-calendar in Excel

I made a new version (v9) of my Excel Calendar, which is almost the same as v8 (see post #10), only I added 2 sheets with a month and week-calendar (v8 only had a year-calendar), see fig.1 for a photo of this calendar (printed and sticked on blackboard).

fig.1: printed Excel calendar (year/month/week)


The month-calender I made from the year-calendar, by copy/paste a month of the year-calendar (a 7x6 table in sheet Calendar-2) to sheet tMonth.

fig.2: month-calendar (e.g. July 2014)


The week-calendar is a table with the hours (from 07:00 to 23:00, assuming the other hours you don´t have anything to do) and the 7 weekdays (so without dates) and per day it also has 5 'free fields' to note things which should be done that day but not at any specific time.

fig.3 week-calendar template


For the v9 calendar I also made 2 sub-versions:
- v.9a: Excel for Madrid capital (with local holidays)
- v.9b: Excel for everywhere else then Madrid-capital  (without local holidays)

Rember the Excel-calendar is multi-language (7 possible languages), just select in sheet-1 (Info) in cell A19 your language. In par. Downloads I included a Spanish version of v9a and an English version of v9b in PDF-format (I printed the Excel with a program that can print to PDF (so generate a PDF-file instead printing it on paper), e.g. CutePDF, see:

http://www.cutepdf.com/


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

- v9a:
https://onedrive.live.com/redir?resid=3F963E9F1A42D952%21231

-v9b:
https://onedrive.live.com/redir?resid=3F963E9F1A42D952%21232


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

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