...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
This feature allows you to edit the sites, sectors, links and CPE’s in tabular format. It is accessed through the RF Systems>Spreadsheet Editors menu options. For example, to edit the site data, selecting RF Systems>Spreadsheet Editors>Site Data brings up the following Site Details dialog box:
...
Selecting the Sectors Data spreadsheet editor brings up the following Sector Details dialog box:
...
Basic Spreadsheet Functionality
This dialog box shows the data for each sector/transmitter in an easy, intuitive form for editing. New sectors can be added and existing sectors can be deleted using the spreadsheet editor. On the left side of the dialog box are three functions that can be selected using the tabs at the bottom left. These include a Groups editing function that allows groups to be created, deleted and modified, a data Filtering function as well as a sector data Import/Export from/to “.csv” format files.
The Spreadsheet Editors option allows sector channel assignments, CPE and Link parameter data to be edited using the same functions and features as the Sectors Data spreadsheet editor.
Basic Spreadsheet Functionality
The spreadsheet area displays the data for your RF System in a simple row format. You can move through the cells in a particular row using the tab key, allowing for quick and simple data entry using just the keyboard. The spreadsheet follows some familiar concepts such as copy/paste, delete and add.
...
Define your columns using the Freeze and Hide/Show options.
Above the spreadsheet is a drop down-list with the text '<New...>'. Select the '<New...>' option from the list.
In the Template Name dialog box, enter a name for the your current column settings template.
Click the ‘OK' button to close the dialog box and then click the ‘Save Column Config’ button and your settings are now saved in the newly named template.
Use the drop-down list to create new column settings and to select already defined settings.
Remember to click on 'Save column config' anytime you make a column change and want it saved to the current name.
Adding a New Row
To add a new line (row) of information, click in the last empty row at the bottom of the column. An asterisk (*) in the row header designates this row. For those systems relying on Templates (Sites, CPEs and Links), the row will automatically pre-fill with the currently selected template’s data. The template selection is the dropdown just above the grid navigation buttons.
Quick Add and Delete
In the toolbar strip above the column headers are two buttons: one for adding rows [icon] and one for deleting rows [icon] .
...
A little later in this section, we will describe how to remove a row from only a specific group.
Row Filtering
The filter toolstrip allows for quick filtering of the current rows. The example image shown below will filter rows to display only sectors with a frequency of 2400 MHz.
...
Using row filtering does not actually make any changes to your groups but instead is a way to temporarily view specific rows.
Group Viewing/Editing
You can filter your list based on using the Groups tab (not available for Site or Sector Channels Data). Selecting Master group will display everything. Selecting one of your defined group names will display only the data for the selected group. This tab allows you to create new groups, delete existing groups and add or remove rows within groups.
...
Earlier we described how to delete or add a row. Deleting a row removed the entire item from the current project. That is, it was removed from every group, including the Master group. The Groups tab allows you to remove one or more rows from just a specific group or add one or more rows to a specific group. To remove row(s), when you have selected a group (other than Master group) from the Groups window, highlight the row (or rows) and click the Remove Row From Group button. This will remove the row(s) from only the selected group. Any other group containing these items will not be changed. You can also add one or more rows to a specific group (the target) from another specific group (the source). To add rows, first select the “target” group (other than Master group) from the drop-down list below the Add Rows to Group button. Next highlight the desired “source” group from the selections in the Groups window and the group rows will display in the spreadsheet editor. Finally, click and highlight the “source” group rows that need to be added to the “target” group and then click the Add Rows to Group button. To view the newly added rows in the “target” group, highlight that group name in the Groups window.
Group Filtering
The Filtering tab is where you can add data to your groups. There are two buttons which open up a Group Filter dialog box, allowing you to update your groups. When selecting the Replace button, the dialog box will completely replace the current items in your group with a new list of items. When selecting the Add button, the dialog box will add items to the group’s current list of items.
...
Once you have the results listed, click the OK button to add those rows or replace the current rows in the selected group.
Importing/Exporting CSV Files
Perhaps you have a customer who has given you a “.csv” file, or you want to give someone a “.csv” file. The Import/Export tab in the Spreadsheet Editors allow you the option to import and export “.csv” file formats. The “.MIF” and “.KML” file format options are available in some of the dialogs.
When importing from a file, any data field not listed in the file will be automatically filled with the selected template data showing in the template drop down menu. For example, you can import CPEs from a “.csv” file containing the name, latitude and longitude. All of the other fields will be filled with the selected CPE template data.
Import from CSV/Export to CSV
Clicking the Export to CSV button will export the currently visible columns to a “.csv” file. The CSV header names checkbox is used to define whether or not the “.csv” file should list the column headers in the file.
...