13-10
Surveyor
User’s Guide
networks. Surveyor exports data into a special .csv file format that can be easily read
by the Optimal Performance product.
Perform the following steps to export data to Optimal Performance format:
1. Select Application Layer Matrix from the Monitor View or Capture View
menus.
2. Select the Table tab to view the data in tabular format.
3. Choose
View Options
from the
View
menu. Using the check boxes, select six
additional columns to display:
Station Address 1
Station Address 2
Frames 2 --> 1
Frames 1--> 2
Bytes 1 --> 2
Bytes 2 --> 1
4. Choose
Export to Optimal Performance
from the
File
menu.
5. Enter the file name in the
Save As
dialog box. Table views will automatically
be saved in Optimal CSV format and the file is given an extension of
.csv
.
6. Click the
Save
button.
Surveyor logs both a start and stop time to the
.csv
file. The start time is the time
the table/chart window is first opened and the stop time is the last time the file is
exported or saved to disk.
Exporting Counter Log Files to Excel
Use these steps to view the counter data in the log files as Excel™ 5.0 graphics. The
Excel template, charts.xlt, is located in the
...\examples
directory.
1. Start Excel 5.0 and open
charts.xlt
. You should see an empty worksheet
called “Data Sheet”. Worksheets are named using tabs at the bottom of the
Excel rows and columns.
2. Open the log file. Remember to set the
Files of Type
field in the
Open
dialog
box, to
.csv
or to All Files (
*.*
) so you can see the log file.
3. Select the entire worksheet. Move the mouse to the small button at the top left
corner of the worksheet. Click the button to highlight everything on the
worksheet.
4. Use
Copy
from the
Edit
menu or
Ctrl + C
to copy the contents of the
worksheet into the Windows clipboard.
Summary of Contents for Surveyor
Page 1: ...Surveyor User s Guide ...
Page 30: ...1 10 Surveyor User s Guide ...
Page 40: ...2 10 Surveyor User s Guide ...
Page 88: ...4 28 Surveyor User s Guide ...
Page 184: ...8 16 Surveyor User s Guide ...
Page 204: ...9 20 Surveyor User s Guide ...
Page 207: ...10 3 Expert Features Getting Started with Expert View10 Figure 10 1 Expert Overview Example ...
Page 211: ...10 7 Expert Features Expert Layers 10 Figure 10 3 Expert Application Layer Example ...
Page 368: ...11 34 Surveyor User s Guide ...
Page 390: ...13 12 Surveyor User s Guide ...
Page 416: ...C 4 Surveyor User s Guide ...
Page 426: ...D 10 Surveyor User s Guide ...
Page 454: ...Index 14 Surveyor User s Guide ...