OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 201)

100

101

Figure 176: 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.

Note

In the real world timekeeping requires tracking working time on

individual projects. Specialized database software is often used but for

simple applications in a small company a Calc spreadsheet and the Data

Pilot might be all that is needed to track work done.

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 177 and

178 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 file shown contains data for one year. How can you compare it with the

data of the previous years?

Chapter 8 Using the DataPilot 201

1 2 ... 196 197 198 199 200 201 202 203 204 205 206 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 201

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3