1 Jan 2014

Timesheet

#1  Timesheet hours worked 2014  in Excel

NB 13/1/2015: 
I made a new version (V2) of this Excel, "Timesheet 2015", see:
http://worktimesheet2014.blogspot.com.es/2015/01/timesheet-for-worked-hours-2015.html

In this article I´ll explain an Excel-document (xlsx, version 2010) I made: "Time sheet hours worked 2014", which has the following functionality:
At the end of this article you can find the websites where you can download the Excel-doc. (for free).
Mirror #1, Microsoft Skydrive has "Excel Web App", so you can look the Excel-doc even in you don´t have Excel installed on your PC.

NB:
- the Excel is in Spanish, but on sheet-2 you can see a translation in English of the most used Spanish terms.
- I filled for all days of the year the worked hours, so this is how the Excel could look like at 31-12-2014.

The Excel has 5 work-sheets:

* SHEET 1

In fig.1 you can see all the dates of 2014 (white) and input-columns (green) and calculated columns (yellow). In the green cells you register every day the begin- and end-time of your work-day and the same for your breaks.

fig.1


* SHEET 2
Explication of columns in sheet-1 and vocabulary, and used formulas.


* SHEET 3

In fig.2 you can see some of the statistics, which are pivot-tables using the data in sheet-1. So every time you change data in sheet-1, you have to update these pivot-tables. In Excel 2010 (Spanish), you can do this in menu "Data > Actualizar Todo". For details, see:

http://office.microsoft.com/en-us/excel-help/refresh-pivottable-data-HA101906071.aspx

The blue bars in the graphic (in fig.2) show the total time worked in a week or month, and the red bars show the difference with the standard work hours (as defined by the company).

fig.2



* SHEET 4

2014 Calendar with (Spanish) holidays

fig.3



* SHEET 5

Vacation planner for members of team, with color-coding (e.g. red: request for vacation denied, green: aproved)
fig.4

Note (25-1-2014): In my Excel in worksheet 'Estadisticas', cell O74 and Q51, you can see the total hours I have to work in Spain (1765). See my post of 18-1-2014 for more details about this:
http://worktimesheet2014.blogspot.nl/2014/01/calendar-2014-v4-usa.html

Download-mirrors:

* Mirror #1:
https://skydrive.live.com/redir?resid=3F963E9F1A42D952!119&authkey=!ADtEH1vpYHGEkDY&ithint=file%2c.xlsx

* Mirror #2:
http://es.scribd.com/doc/195037542/Horas-Trabajado-TimeSheetWorkedHours-2014-v1b-xlsx

* Mirror #3:
https://drive.google.com/file/d/0BywxxSJoaUYxZ2tHVlVyY1pQbGM/edit?usp=sharing

No comments: