Est Tool Tab

File:EstToolTabRibbon1.2.0.6.png

EstToolTab Ribbon

File:EstToolTabRibbon1.2.0.6.png

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 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

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

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

Breakdown

Enable B.D.

Hides and Unhides the Breakdown (Alpha Label) Column on Div's

Make B.D.

Creates a Breakdown Sheet if One does not already exist

• Must have Enable B.D. Enabled

Add User Item

Adds a New User Added Item

• Only on Summary, Recoverable and BreakDown Pages

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

Reformat

Reformats the Page to its Intended State

• Only works for Div's

Reformat Workbook

Reformats the Entire Workbook

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