Steps to Lock a TableFrom the Negotiations screen, select the Maintenance menu and then Salary Schedules.
At the Salary Schedules screen, enter the ID of the package for which to import the Salary Schedule - Amounts table into in the Package ID field, or click the down-arrow button to select the correct one.
Click the Import tab.
Enter the correct path (drive and folders) and file name for the spreadsheet file to be imported in the File Name field, or click the Search button to select the correct path and file.
Enter the number of the worksheet within the file to import in the Worksheet Number field, or click the Search button to select the correct one. The number for the length can be up to 3 digits long and range from 0 to 255. Leave this field blank to default to 0 to import the information from the first worksheet in the file.
Enter the direction (Across or Down) of the steps on the file to import in the Import Step Orientation field, or click the down-arrow button to select the correct one. If the steps go across as the columns on the file to import, enter Across. If the steps go down as the rows on the file to import, enter Down.
If applicable, in the Rows to Skip field, enter the number of rows to skip on the imported file if the data to be imported is not in consecutive rows. For example, if the data to be imported is in every other row, enter 1 in this field. The number can be up to 2 digits long. Leave this field blank to default to 0.
If applicable, in the Columns to Skip field, enter the number of columns to skip on the imported file if the data to be imported is not in consecutive columns. For example, if the data to be imported is in every other column, enter 1 in this field. The number can be up to 2 digits long. Leave this field blank to default to 0.
If desired, to import the descriptions for the steps, enter the cell ID for where the first step description is located in the file in the Starting Step Description Cell field, or click the Search button to select the correct one.
If desired, to import the descriptions for the lanes, enter the cell ID for where the first lane description is located in the file in the Starting Lane Description Cell field, or click the Search button to select the correct one.
Complete the Import Details List to define the specifications for importing the table. If the data to import is located uniformly on the file, only enter one line using the dimensions for the entire package; otherwise, multiple ranges of cells (steps and lanes) can be imported, if needed. To enter the import specifications for a range, complete the following:
In the blank line (indicated with an asterisk) at the bottom of the Import Details List, enter the number of the first step to import in the Starting Step field, or click the down-arrow button to select the correct one.
Enter the number of the last step to import in the Ending Step field, or click the down-arrow button to select the correct one.
Enter the number of the first lane to import in the Starting Lane field, or click the down-arrow button to select the correct one.
Enter the number of the last lane to import in the Ending Lane field, or click the down-arrow button to select the correct one.
Enter the cell ID for where the first step in the specified range is located in the file in the Starting Cell field, or click the Search button to select the correct one.
If applicable, repeat these steps until all the ranges have been entered.
Note: If needed, to remove a range, click the Delete button located to the left of the desired line in the Import Details List; when prompted to delete the record, click Yes.
Click the Execute button to import the table as specified.
After importing the table, click the Salary Schedules tab and then the Salary Schedule - Amounts tab located on the bottom of the screen to view the table.
Once the table has been imported successfully, lock the table to prevent it from being accidentally recalculated.