Template: Work tracker

Alica Kačengová

Nowadays, more and more organizations work on multiple projects at the same time. Some projects don’t require all the resources that the organization has, some of new customers can’t wait until you finish your current project, and of course, it’s better to have multiple streams of income. Business dictionary defines project as a “Planned set of interrelated tasks to be executed over a fixed period and within certain cost and other limitations.” Thus the table Projects contains columns Begin and End:

With such diversification of work on projects, there comes the need for detailed work tracking. You can allocate different teams to different projects, but what if you need a person to work on multiple projects because you wouldn’t utilise all their time on one project? Or because you don’t have more workers with such experience and skillset?

This view is where the actual work tracking happens: Employees (red) are linked to Projects (green) and the link represents work done by particular employee on that project. Each instance of the link (a row in a table with white header) has attributes Date, Hours, Costs and Month:

Once you have the information about who and how much worked on each project, you can use charts and pivot tables to see data aggregated into valuable results that can be instantly seen. Let’s start with monthly costs on the projects:

See how many hours do your employees spend on each project every month:

Or rather switch the view to monthly costs:

Work tracking doesn’t have to be messy and complicated if you use the right tool. Start using Work tracking template in Lumeer now to save time with administration and focus on your business!