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

100

101

Figure 186: The DataPilot now shows accumulated values

Differences and advantages

These examples show an important aspect of the DataPilot. Normally you have to

collect your data according to the way you want the result to be represented. This

means you have to use a specific structure and you are stuck with it.

The DataPilot works more like a real database. The source data are collected in a

simple spreadsheet that contains all data. Only when you want to look at it do you

select which part of the data you want to use.

Example 3: Frequency distribution

For showing the frequency of incidents, Calc uses the function FREQUENCY. This

formula has to be used in a so-called matrix formula. This is an advanced feature.

Alternatively you can use the DataPilot, which requires almost no knowledge of

spreadsheets.

In our example we want to investigate the number of emails that go to the

Germanophone support mailing list ([email protected]). We want to know how

the activity on the list is distributed during the day.

The starting point for this example is the mailbox file of the Thunderbird mail client.

The command (in Linux)

grep 'Delivery-Date:' Inbox > users.txt

creates a text file that contains, for the timespan of more than 2 years, one line for

each message, with date and time. (See Figure 187.)

Chapter 8 Using the DataPilot 207

1 2 ... 202 203 204 205 206 207 208 209 210 211 212 ... 433 434

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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