Calc Guide

Solution
To use the DataPilot for this task, collect all the data into one single table. This can be
done either manually or by importing a file from an (electronic) timekeeping
machine.
In very simple cases, each employee takes care of their own working hours. If you
need calculations that cover several employees, departments, or the whole company,
just copy everything into one huge table (Figure 179).
Figure 179: Database in Calc
Using the DataPilot requires only 12 mouse clicks and gives you a nice overview
within seconds:
1) Select the cell A1 (or any other single cell within the list).
2) Choose Data > DataPilot > Start and click OK.
3) On the DataPilot dialog (Figure 180):
• Drag date into the Row Fields area.
• Drag hours into the Data Fields area. Notice that it becomes Sum –
hours.
• Drag name into the Column Fields area.
4) Click More to show more options in the lower part of the dialog.
5) Choose – new sheet – for Results to.
6) Click OK.
Chapter 8 Using the DataPilot 203