I made a new version (V2) of this Excel, "Timesheet 2015", see:
In this article I´ll explain an Excel-document (xlsx, version 2010) I made: "Time sheet hours worked 2014", which has the following functionality:
- registrate your worked hours, vacations and other non-working days (e.g. sick leave)
- calculate statistics like total hours worked per week, month and year, and differences with standard working times (as defined by the company)
- calender with holidays (see also my other post: http://worktimesheet2014.blogspot.com.es/2014/10/calendar-2014-october-in-excel.html )
- vacation planner for members of team (see also my other post: http://worktimesheet2014.blogspot.com.es/2014/07/vacations-planner-in-excel.html )
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.
- 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.
* 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:
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).
* SHEET 4
2014 Calendar with (Spanish) holidays
* SHEET 5
Vacation planner for members of team, with color-coding (e.g. red: request for vacation denied, green: aproved)
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:
* Mirror #1:
* Mirror #2:
* Mirror #3: