Est Tool Tab

EstToolTab Ribbon

EstToolTab Ribbon

Insert / Convert

Insert Cost Line

Inserts an Empty CostLine below the Line in which the user has currently selected

Insert Cost Detail

Inserts an Empty CostDetail below the Line in which the user has currently selected

Insert Comment x3

Inserts 3 Empty Comments below the Line in which the user has currently selected

Insert Staff

Inserts an Empty Staff Line below the Line in which the user has currently selected

Insert Space Line

Inserts an Empty Space below the Line in which the user has currently selected

Insert Header

Inserts an Header Line below the Line in which the user has currently selected

Insert SubDivision

Inserts an SubDivision Line below the Line in which the user has currently selected

Convert CD to CL

Bump up the Cost Detail line to a Cost Line.

User Defined Variables

User can define variables to be used in estimate book.

Convert To Comment

Convert To Comment

Converts all CostDetail Lines within the range to Comments and Re-Calculates the Page

Resurrect

Brings Commented out CD's back to life!

Convert CL To ST

If a CostLine has no CostDetails related to it, this will convert all CostLines within the rage to ST

Comments

Hides & UnHides all Comments

• You Can only Add Comments if Comments are Unhidden

Zeros

Hides & UnHides all Lines with 0 Total Value

• You Can only Add Lines if Zeros are Unhidden

CM Rate

Swaps the Class Rates between CM & LS

SPL Comments

Toggles on and off SPL Comments

Subtrade Description

Hides and Shows the Subtrade Description Column

Add LBR Premium

Inserts a specific Labour CostLine to the book

Add Tool Allowance

Inserts a specific Tool Allowance Line to the book

Plug

Changes Cells in the selected range to the Plug Colour

Quote

Changes Cells in the selected range to the Quote Colour

Clear

Removes the background colour of Cells in the selected range

Unit / Labour

Unit

Drop Down Menu that allows the user to change the current Unit on the Line Selected

Class

Drop Down Menu that allows the user to change the current Class on the Line(s) Selected

Change Rates

Pop-Up Window that allows the user to change the current Rates being used in the current workbook

See Rate Table Guide for more information on usage

Financials

Tender Eval

Displays a Pop-Up window in which you can change the Tender Eval info

Project Info

Displays a Pop-Up window in which you can change the Project Info

See Project Info Guide for more information on usage

Calculate Recoverable

Sheet Selector Pop-Up Appears and the User Selects Pages to be recoverabled upon. Creates a Recoverable Sheet based on the pages selected

Project Total

Dynamic Sum of the Project Total

Fee

Dynamic Sum of the Fee Total

Insurance

Dynamic Sum of the Insurance Costs

Bid Close

Tag Line

Tag's a line so that it can be used in the BidClose Form

Un-Tag Line

Un-Tag's a line and removes it from the BidClose Form

Un-Tag All

Un-Tag's every single line in the Workbook

Bid Close Form

Displays a Pop-up window inwhich the user can change tagged lines without being on the worksheet

Copy / Paste

Copy Section

Copies the Section of the row selected

Paste Section

Pastes the Copied Section below the row selected

Copy Div

Creates a Copy of the Current Div based on the Name given by the User

Redemption

Undo

Undo's the Last Action

• Only works on Div's
• Once you leave a page, you can no longer Undo

Rearrange Worksheets

Allows User to Rearrange Worksheets via a Pop-Up Menu

Delete Sheet

Delete's a Sheet from the workbook

Delete Line

Delete's a Line/Section from the worksheet

• Only works on Div's

Delete Section

Delete's an entire section from the Div

Extras

Extras

Debug Features

Help

Re-directs the user to the Synwiki Website

Updates And Info

Displays a Form giving the latest updates/info/Dev Team

Show/Hide Hiddens

Shows or Hides the Hidden Worksheets

Pro/UnPro

Protects or Unprotects the Workbook

EnableDebug

Enables or Disables Sheet Change or Sheet Activate