From the View menu of PicoLog Recorder or Player, select Spreadsheet.
![SpreadsheetWindow](spreadsheetwindow.png)
There is one line for each reading. The first column shows the time in seconds, while the remaining columns show the selected measurements.
The following options buttons are available:
![_bm33](_bm33.png) | Select channels. Select the measurements to display. |
![_bm34](_bm34.png) | View options. Spreadsheet options specify whether to display individual readings, or first reading, average, minimum and maximum for a period. |
If you select a range of readings, you can use the following buttons:
![_bm7](_bm7.png) | Write to disk. Write the readings to a print file (.prn) or a text file (.txt) - Both are tab separated value files. |
![_bm31](_bm31.png) | Copy to clipboard. Write the readings to the clipboard. |
![_bm32](_bm32.png) | Print view. Print the graph. |
You can select a range in one of three ways:
If all of the readings that you want to select are on the screen:
![blueball](blueball.zoom25.png) | Point the mouse at the first reading |
![blueball](blueball.zoom25.png) | Press and hold down the left mouse button |
![blueball](blueball.zoom25.png) | Drag the mouse to the last reading (the selected readings will be highlighted as you go) and |
![blueball](blueball.zoom25.png) | Release the left mouse button. |
If the readings are a long way apart:
![blueball](blueball.zoom25.png) | Point the mouse at first reading |
![blueball](blueball.zoom25.png) | Click the left mouse button (this will highlight the first reading) |
![blueball](blueball.zoom25.png) | Scroll down to the last reading |
![blueball](blueball.zoom25.png) | Point at the last reading and |
![blueball](blueball.zoom25.png) | Press the shift key and click the left mouse button. |
If you wish to select all of the readings for one day:
![blueball](blueball.zoom25.png) | Point the mouse at any reading during the required day |
![blueball](blueball.zoom25.png) | Click the left mouse button (this will highlight the reading) and |
![blueball](blueball.zoom25.png) | Click on the 'select day' icon: ![_bm37](_bm37.png) |
|