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 163).
Figure 163: Data basis 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 164):
• 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) In the Results to field, select – new sheet – from the drop-down
list.
6) Click OK.
Chapter 8 Using the DataPilot 229