Difference between revisions of "Est Tool Tab"

Latest revision as of 23:46, 5 December 2023

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

Insert Staff

Inserts an Empty Staff 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

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

Clear Cost Detail Line

You can use this button to clear up all content on the Cost Detail and keep the cost code and description.

Add OH (Over Head or Overhead) Line (Button Group)

This button along with all buttons underneath is used for adding Overhead lines. note that Add LBR Premium and Add Tool Allowance will be phased out due to the addition of this feature.

Add Tool Allowance

Adds Tool Allowance OH Line

Add LBR Premium

Adds LBR Premium OH Line

______________________________________________

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

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

Redemption

Undo

Undo's the Last Action

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

Redo

Redo's the Last Action

Only works on Div's

Delete Section

Delete's an entire section from the Div

Pro/UnPro

Protects or Unprotects the Workbook

EnableDebug

Enables or Disables Sheet Change or Sheet Activate

@@ Line 1: / Line 1: @@
-[[File:EstToolTab Ribbon.png|frame|center|EstToolTab Ribbon]]
+[[File:EstToolTabRibbon1.3.0.22.png|center|EstToolTab Ribbon|link=|alt=|thumb|840x840px]]
+__TOC__
 == Insert / Convert ==
+[[File:InsertConvertRibbon.png|frame|right]]
 === [[Insert Cost Line]] ===
 Inserts an Empty CostLine below the Line in which the user has currently selected
@@ Line 11: / Line 14: @@
 Inserts 3 Empty Comments below the Line in which the user has currently selected
-=== Insert Staff ===
+===[[Insert Space Line]]===
-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 ===
+===[[Insert Header]]===
 Inserts an Header Line below the Line in which the user has currently selected
-=== Insert SubDivision ===
+===[[Insert SubDivision]]===
 Inserts an SubDivision Line 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
+=== [[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 ====
+==== [[Convert To Comment]] ====
 Converts all CostDetail Lines within the range to Comments and Re-Calculates the Page
-==== Convert CL To ST ====
+==== [[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 ===
+===[[Clear Cost Detail Line]]===
+You can use this button to clear up all content on the Cost Detail and keep the cost code and description.
+=== [[Add OH Line (Button Group)|Add OH (Over Head or Overhead) Line (Button Group)]] ===
+This button along with all buttons underneath is used for adding Overhead lines. note that [[Add LBR Premium]] and [[Add Tool Allowance]] will be phased out due to the addition of this feature.
+'''<big>[[Add Tool Allowance]]</big>'''
+Adds Tool Allowance OH Line
+'''<big>[[Add LBR Premium]]</big>'''
+Adds LBR Premium OH Line
+______________________________________________
+=== [[Comments]] ===
 Hides & UnHides all Comments
 * You Can only Add Comments if Comments are Unhidden
-=== Zeros ===
+=== [[Zeros]] ===
 Hides & UnHides all Lines with 0 Total Value
 * You Can only Add Lines if Zeros are Unhidden
-=== CM Rate ===
+=== [[CM Rate]] ===
 Swaps the Class Rates between CM & LS
-=== Plug ===
+=== [[SPL Comments]] ===
+Toggles on and off SPL Comments
+=== [[Subtrade Description]] ===
+Hides and Shows the Subtrade Description Column
+=== [[Plug]] ===
 Changes Cells in the selected range to the Plug Colour
-=== Quote ===
+=== [[Quote]] ===
 Changes Cells in the selected range to the Quote Colour
-=== Clear ===
+=== [[Clear]] ===
 Removes the background colour of Cells in the selected range
 == Unit / Labour ==
-=== Unit ===
+=== [[Unit]] ===
 Drop Down Menu that allows the user to change the current Unit on the Line Selected
-=== Class ===
+=== [[Class]] ===
 Drop Down Menu that allows the user to change the current Class on the Line(s) Selected
-=== Change Rates ===
+=== [[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 ===
+=== [[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
-=== Calculate Recoverable ===
+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
-=== % Fee ===
+=== [[Project Total]] ===
-Swaps Fee Calculation between percent and a static numerical value
-=== Project Total ===
 Dynamic Sum of the Project Total
-=== Fee ===
+=== [[Project Total|Fee]] ===
 Dynamic Sum of the Fee Total
-=== Insurance ===
+=== [[Project 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 ===
+=== [[Copy Section]] ===
 Copies the Section of the row selected
-=== Paste Section ===
+=== [[Copy Section|Paste Section]] ===
 Pastes the Copied Section below the row selected
-=== Copy Div ===
+=== [[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]] ===
 Undo's the Last Action
 * Only works on Div's
 * Once you leave a page, you can no longer Undo
+'''<big>[[Redo]]</big>'''
-=== Rearrange Worksheets ===
+Redo's the Last Action
+=== [[Restore]] ===
+Allow user to recover critical data from most recent cloud upload.
+=== [[Rearrange Worksheets]] ===
 Allows User to Rearrange Worksheets via a Pop-Up Menu
-=== Reformat ===
+=== [[Delete Sheet]] ===
-Reformats the Page to its Intended State
-* Only works for Div's
-=== Delete Sheet ===
 Delete's a Sheet from the workbook
-=== Delete Line ===
+=== [[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

Difference between revisions of "Est Tool Tab"

Latest revision as of 23:46, 5 December 2023

Insert / Convert

Convert To Comment

Unit / Labour

Financials

Bid Close

Copy / Paste

Redemption

Extras

Pro/UnPro

Navigation menu

Search