Oracle® Rules Palette Release 9.1.0.0.0 E15811-01

# Upload Rates from Aggregate Table

Aggregate rates can be uploaded from an Excel spreadsheet.

Upload Rates From Aggregate Table in an Excel Spreadsheet

1. Navigate to Admin Explorer.

2. Right-click on the Rate Groups folder.

3. Select New Rate Group.

4. Enter the rate group information and select Next.

5. Select the Yes radio button to upload rates from a spreadsheet and then select Next.

6. In the Workbook field, select the Excel spreadsheet containing the rates you want to upload.

7. Select Aggregate as the Table Type (rate type) to be uploaded.

8. Enter the literal worksheet name (exactly as appears on the spreadsheet) in the Worksheet field.

9. In the Int Criteria Column, enter the spreadsheet column letter that contains the Integer Criteria for the intended indexing strategy.

10. In Start and End Row, enter the starting and ending row numbers that contain the rates to be uploaded.

11. Select the Add Row button.

12. Enter the Column letter of the criteria you want to add.

13. Enter the Criteria type. The Criteria types are stored as code values in the database in order to save space and make it easier to perform updates.

14. Complete steps 12 and 13 until you have entered all columns and criteria.

15. Select Finish.

Once you have finished uploading the rates, the Configuration Area will open and display your new rate table. You can check-out the XML file if you need to make changes to the rate table information.

Note: You can manually edit a rate if it was uploaded incorrectly.

Below is a sample of the aggregate spreadsheet that was used to fill out the pink portion of the screen shot above.