SourceForge Logo

- reports

User Info
- user guide
- help forum

- product

- project page
- data model


It is easy to use MS Excel to analyze work hours in a number of ways. The chart below shows four projects and for each project it shows the number of hours spent on each activity.

The data was extracted from the TIMETOWORK database using a live connection between Excel and the database. It can be refreshed with the push of a single button.

This particular chart was created using what is called a pivot chart. A pivot chart enables the user to analyze the data using a number variables (or dimensions). In this particular case the chart enables it's user to set five variables to perform the analysis.

  • week number of year
  • year
  • employee
  • activity
  • project

For example the above chart was created using the following variable settings: all employees, all weeks, the year 2003, all activities, and all projects.