Rate Sheet Generation Step #3: Building a Template

This article describes the steps to build a template for use in generating an Excel style rate sheet using Optimal Blue. Prior to building your template, you should have already completed building your rate sheet entity/product tree and configured your pricing sources . For the next step in this process, see the Rate Sheet Generation Step #4: Daily Generation article.

Building a Rate Sheet Template

This section describes the steps to build a template for use in generating an Excel rate sheet using the template provided by Optimal Blue. Prior to building your template, you should have already completed building your rate sheet entity/product tree and configuring pricing sources . See the Building a Rate Sheet article for information on completing these steps.

Complete the following steps to build a rate sheet template:

1. Select the Rate Sheet entity on the Entity Selection screen in your Configuration site.

1. Select the Ratesheet Generation activity. The Ratesheet Generation Controls screen is displayed.

1. You must create and save an Excel template in order to generate a rate sheet. Click on the Click Here link in the Update Template section to download a sample template that you can use to help you create your own.

The template shown here will be downloaded:

As an example, below is the same template with the Conforming 30 Year Fixed product with the Pricing Source configured and the template updated to pull in the product rate and pricing.

1. Build out your rate sheet to display all of the products you want to include.

Things to Remember:

• Use the data fields as displayed in the sample template. No custom formulas.
  • Rate ~Product Code~ — Product code exactly as entered on the Streamlined Product Addition screen (See the Building a Rate Sheet article)
  • ~DATA~-Day – Brings in the lock period
  • ~DATA~ – Brings in the corresponding rate or price
  1. Once your template is complete and saved to your local network drive, return to the Ratesheet Generation Controls screen. Click Choose File (or Browse) to select your template file and then click Upload.
  2. Once the file has uploaded, click on the file information in the Download Past Ratesheets section to open the rate sheet and verify it is working as intended. (Remember: Do not save this file in place of your template!)

  Your rate sheet should have data in all of the fields you have configured, as shown below:
  

  For the next step in this process, see the Rate Sheet Generation Step #4: Daily Generation article.

  Leave a Reply Cancel reply

  You must be logged in to post a comment.