Optical Spreadsheet

The Optical Spreadsheet lists the total station and laser rangefinder observations in the project, along with computed values and station and target information. The data can be sorted by clicking at the top of any column. The Plan View and the Properties pane reflect all changes made to data in the spreadsheet view.

To create a new optical spreadsheet:

Select Optical Spreadsheet in Home > Data.
Right-click a total station observation and select New Optical Spreadsheet from the context menu.

To navigate the spreadsheet:

To select an observation, click in the left column for that row.

To display observation details:

Select the observation (click on the left edge of the row) and press F11, or right-click and select Properties. The Properties pane displays.

To sort entries:

Click on a column heading to change the sorting between ascending and descending.

To copy data:

Select data, and copy and paste it to a text editor (such as Microsoft^®Notepad) by using the context menu or by pressing [Ctrl] + [C] to copy and [Ctrl] + [V] to paste. You can select all data by pressing [Ctrl] + [A].

To manage column display:

Select Project Settings in the Quick Access Toolbar. Then click View and Optical Spreadsheet. For each type of data, select to Show or Hide the column in the spreadsheet. To change the order of columns across the spreadsheet, click and drag the column heading to a new location.