...
How to Unlock the Rate Wizard
adsfadsfTo unlock the rate wizard so you can edit, please do the following:
you will need to unlock the Rate Matrix by clicking the 'Unlock” button
A Unlock Pop Up will appear, click on “yes”
You will now see the following message
How to create/edit a Rate using Rate by Fixed price
...
Ensure that “Rate by fixed pricing” has been selected
Next, you will need to unlock the Rate Matrix by clicking the 'Unlock” button
A Unlock Pop Up will appear, click on “yes”
You will now see the following message
The next step is to select the Package Type and Service Level you wish to create
If you have not already created your Service Levels, please click here: Service Levels
If you have not already created your Package Types, please click here: Package Types
To do this, first select the Package Type from the first dropdown (please note because Package Type are defined and created by your company, your dropdown will display different Package Type )
Then select the package type from the second dropdown. (please note because Service Levels are defined and created by your company, your dropdown will display different Service Levels)
Before starting to enter in rates, its best to explain how to read the Rate Matrix
If you have not already created your zones, please click here: Zone Wizard
You will see your Zones across the top and along the left hand side of the screen. (please note because Zones are defined and created by your company, your matrix will display different Zones)
You will noticed that the Zones across the top are the same zones that are along the left hand side of the matrix.
To enter in a rate select the “From” zone on the left hand side and the “To” zone from the top
Using the example above, if you want to enter in a rate “From” Vancouver (outlined in green in image below) “to” Surrey (outlined in blue in image below) you will select the cell highlighted in red.
To enter a rate into the selected cell, double click the cell. The cell will change to Yellow.
Then type in your rate
Continue this one with each cell.
Some Trip and Tricks.
You can use Microsoft Copy and Paste Hot keys. To do this:
double click into a cell that contains the price you which to copy
Then press “Ctrl” and “a” to highlight the entire rate
Then press “Ctrl” and “c” to copy the highlighted rated
Now click into the cell you wish to paste the rate into
Now press “Ctrl” and “v” to paste the rate into the cell
Continue to paste the copied rate into as many fields as need.
You can initialize the cells to a rate. The is helpful when all your rates are the same OR most of the cells continue the same rate. To do this:
Ensure “Initialize values to:$” has been selected
In the field beside “Initialize values to: $”, type the value you wish to have entered into all the fields
Then click “Modify Values”
You will now see the rate will appear in all the cells of the Rate Matrix
...