25 Jun 2015

Vacations planner for 2015 in Excel

#38 Vacations planner for 2015 in Excel

Note: I made a similiar Excel for 2014 (see post #20), but the 2015-version has some new features, like date-formulas, to calculate e.g. the weekday (in fig.1 these have the Spanish names, like Lu(nes) = Monday).

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

In fig.1 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 that there is always at least 1 person at the office. The last column 'Conflict' = 1 (red) if both Jane and John have a vacations-request (with status 1) for the same day.

And to conclude this post:
If you don´t have any plans yet for these summer holidays, maybe I have an idea for you, see sheet-1 of the Excel for a photo of my holidays-destination in 2011, Islas Cies, playa Rodas (Galicia - Espana),  which was elected that year by the readers of the newspaper 20minutos as the nicest beach of Spain, and this newspaper used one of my photos to show why, see:

http://www.20minutos.es/noticia/1149298/0/mejor/playa/verano-2011




 fig.1: Holidays-planner


Download:

https://goo.gl/Q6cf7z


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