Calc Guide

Figure 160: Selection of subtotals for several employees.
Example 2: Timekeeping
This example is often used by consultants and in several variations in
user support. The task is to provide a means for one or more users to
keep track of working hours.
A typical way of doing this is to create a spreadsheet per month and a
sum sheet with all the results of one year. For each employee, there is
one file (see Figures 161 and 162 for examples of two pages from the
file for one employee).
Practical problems and questions
• It is very difficult and time-consuming to create the timekeeping
table: 12 sheets that have to be copied from a raw template and
adjusted for each month, and a sheet with all the yearly sums
with references to all the other sheets. Users often search for a
macro to make the creation easier.
• The file shown contains only the data of one employee. How can
you get all the data for all the employees, so that you can have a
summary of all the work hours from all employees of a
department or the whole company?
• How can you compare employees and/or departments?
• The shown file contains data for one year. How can you compare
it with the data of the previous years?
Chapter 8 Using the DataPilot 227