I am very happy to announce I have created a “Timesheets” Dashboard application.
Unlike many versions you can find online are working perfectly, I have developed a new timesheet format. Timesheet 2012 Dashboard has a new and more user friendly way to fill out your timesheet.
Timesheet 2012 Dashboard is a dynamic spread-sheet and needs the macros enabled to be used. If you do not know how to enable the macros, please follow the instruction at the link http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx
The dashboard has two dynamic menus which allow you to actively interact with the spread-sheet. The first menu, called Active Control and shown below, gives you the option to select a specif month or all the month. This can be very helpful to avoid to scroll up and down your timesheet or create a PDF of your timesheet.
The second menu, called User Menu and shown below, has 6 buttons:
1. Update: in spite of your timesheet is automatically updated [not in this Demo version, you will get an error saying it cannot find the server instead] as soon as you open it, this button allows to perform a further manual update. Please note that the Demo version is for demostration only. There is a final version which can be used on an intranet to manage the all companies timesheets
2. Email Admin: this button opens your Outlook and allows sending an email to Admin, copying another address as well. You should email Admin if you need help with your timesheet
3. Create PDF: this features allows to create a PDF of the visible area in your timesheet [Selecting All on the Active Control you will PDF the 12 months while selecting only one month you will PDF only the selected month]. The PDF will be automatically saved on your PC with the format FileNameCurrentDate.pdf [Document folder or desktop]
4. Quick timesheet: this button is the most powerful tool on the new timesheet. This control allows to select a range and fill it out with the same number of hours. [further explanation below]
5. Save/Close: Save and close button. Please use this button to save your timesheet and resetup Excel with the normal view
6. Admin: only Admin is allow to use this tool. The spreadsheet automatically recognize who is logged in
The Quick Timesheet tool:
In spite of you still should fill out your timesheet in the “old fashioned” way, and which I strongly recommend to do, I have developed a tool to fill out the timesheet faster.
As already aforementioned, this tool allows you to fill out a range of cells with the same number of hours.
In the example below, the days from 2 to 6 and from 9 to 11 have been selected and the Quick Timesheet Tool will fill them out with 8 hours a day as soon as the OK button is clicked.
You can enter letter as well, i.e. H for Holiday and so forth
IMPORTANT:
On top of your timesheet there are some information about the staff. Title and Location have a scroll-down list [the list is dynamic and updatable if connected to the server].
The project area:
As shown below, you can select a project number through a scroll-down list [the list is dynamic and updatable if connected to the server]. Please note that you can select a maximum 15 different projects per month. Projects without hours or vice versa, are not allowed and you cannot save the timesheet if this happen.
To download the timesheet please click here: Timesheet Dashboard
Please save the Timesheet on your Computer before using it. Once you have saved the file, unzip it using 7z [http://www.7-zip.org/] and install it.
Following on from the above also note that LockXLS add-in will be to execute the file with Excel.
I hope you enjoy the spread-sheet.
Paolo
[Copyright © 2012, Paolo Succo]
