Rate Table Guide

This is a brief guide on How to use the Rate Table in the Estimating Template

After Clicking the Change Rates button in the Unit/Labour section of the EstToolTab Ribbon, A Table should appear

File:Rate Table Pic.png

This table has 5 parts

	Category	PayRoll Type	Label	CM CO	LS CO
Meaning	Job Description	Hourly or Salary	Job Abbreviation	CM Rate	LS Rate
Type	Word/Words	Hourly or Salary	short abv.	number	number

Rate Table Column Explanations

Category

Contains a Description/Title of the Job/Position

Can be edited to any word/words

PayRoll Type

Contains the Type of PayRoll for the given position.

Can Either be 'Hourly' or 'Salary'.

to quickly type them, the user can simply input an 'h' or an 's' and upon leaving the cell, the Cell will automatically change to its given definition. 'h' -> 'Hourly' , 's' -> 'Salary'. You can try this out on the template

Label

This Contains a compressed, easy to type version of the Category/Position.

The given label is the identifier for the given position throughout the template.

They will appear in the Labour Class Column in Div's (Located in the Labour Man-hours section)

CM CO

This is the CM rate for the given position.

If the CM Rate checkbox is selected, Then this is the value used to calculate rows with this class selected

LS CO

This is the LS rate for the given position.

If the CM rate checkbox is not selected, Then this is the value used to calculate rows with this class selected

How To Add More Positions

There are 2 ways to add more positions.

The First way is that at the bottom of the Rate Table, there is an empty line.
Start filling out that line and the new position will be created

The Second way is to select any cell on a given row and click the insert Row button.
This will insert an empty row below the row of the cell you have selected and the user can fill out this
empty row to add a new position

NOTE: with both methods, 1 thing is important. IN order for a new position to be added to the Rate Table,
The new Row must be filled out completely. So if you add a new row and just fill out the Category Column, this
data will not be saved and will be discarded. Only if a new row is created and all 5 columns are filled out appropriately
will the new row become apart of the Rate Table and Document.

How to Apply my Changes to the Workbook

Your changes will be automatically applied upon exiting the Form/Window

How to Remove Positions From the Rate Table

Removing positions that already exist is not currently supported.
Only adding new positions is supported