Difference between revisions of "Est Tool Tab"

From SynWiki
Jump to navigation Jump to search
 
(45 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
== ==
+
[[File:EstToolTabRibbon1.3.0.22.png|center|EstToolTab Ribbon|link=|alt=|thumb|840x840px]]
  
 +
__TOC__
  
−
[[File:EstToolTab Ribbon.png|frame|center|EstToolTab Ribbon]]
 
 
== Insert / Convert ==
 
== Insert / Convert ==
−
 
+
[[File:InsertConvertRibbon.png|frame|right]]
 
=== [[Insert Cost Line]] ===
 
=== [[Insert Cost Line]] ===
 
Inserts an Empty CostLine below the Line in which the user has currently selected
 
Inserts an Empty CostLine below the Line in which the user has currently selected
Line 14: Line 14:
 
Inserts 3 Empty Comments below the Line in which the user has currently selected
 
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
 
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
 
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
 
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]] ====
 
==== [[Convert To Comment]] ====
 
Converts all CostDetail Lines within the range to Comments and Re-Calculates the Page
 
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]] ====
 
==== [[Convert CL To ST]] ====
 
If a CostLine has no CostDetails related to it, this will convert all CostLines within the rage 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 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]] ===
 
=== [[Comments]] ===
Line 43: Line 68:
 
=== [[CM Rate]] ===
 
=== [[CM Rate]] ===
 
Swaps the Class Rates between CM & LS
 
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]] ===
 
=== [[Plug]] ===
Line 63: Line 94:
 
Pop-Up Window that allows the user to change the current Rates being used in the current workbook
 
Pop-Up Window that allows the user to change the current Rates being used in the current workbook
  
−
** Link to How to Use Rate Table **
+
See [[Rate Table Guide]] for more information on usage
  
 
== Financials ==
 
== Financials ==
 +
 +
=== [[Tender Eval]] ===
 +
Displays a Pop-Up window in which you can change the Tender Eval info
  
 
=== [[Project Info]] ===
 
=== [[Project Info]] ===
 
Displays a Pop-Up window in which you can change the 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]] ===
 
=== [[Calculate Recoverable]] ===
 
Sheet Selector Pop-Up Appears and the User Selects Pages to be recoverabled upon.  
 
Sheet Selector Pop-Up Appears and the User Selects Pages to be recoverabled upon.  
 
Creates a Recoverable Sheet based on the pages selected
 
Creates a Recoverable Sheet based on the pages selected
−
 
−
=== [[% Fee]] ===
 
−
Swaps Fee Calculation between percent and a static numerical value
 
  
 
=== [[Project Total]] ===
 
=== [[Project Total]] ===
Line 85: Line 118:
 
=== [[Project Total|Insurance]] ===
 
=== [[Project Total|Insurance]] ===
 
Dynamic Sum of the Insurance Costs
 
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 / Paste ==
Line 96: Line 142:
 
=== [[Copy Div]] ===
 
=== [[Copy Div]] ===
 
Creates a Copy of the Current Div based on the Name given by the User
 
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 ==
 
== Redemption ==
Line 116: Line 149:
 
* Only works on Div's
 
* Only works on Div's
 
* Once you leave a page, you can no longer Undo
 
* Once you leave a page, you can no longer Undo
 +
'''<big>[[Redo]]</big>'''
 +
 +
Redo's the Last Action
 +
 +
=== [[Restore]] ===
 +
Allow user to recover critical data from most recent cloud upload.
  
 
=== [[Rearrange Worksheets]] ===
 
=== [[Rearrange Worksheets]] ===
 
Allows User to Rearrange Worksheets via a Pop-Up Menu
 
Allows User to Rearrange Worksheets via a Pop-Up Menu
−
 
−
=== [[Reformat]] ===
 
−
Reformats the Page to its Intended State
 
−
* Only works for Div's
 
  
 
=== [[Delete Sheet]] ===
 
=== [[Delete Sheet]] ===
Line 130: Line 165:
 
Delete's a Line/Section from the worksheet
 
Delete's a Line/Section from the worksheet
 
* Only works on Div's
 
* Only works on Div's
 +
 +
==== [[Delete Section]] ====
 +
Delete's an entire section from the Div
  
 
== Extras ==
 
== Extras ==
 
=== [[Extras]] ===
 
=== [[Extras]] ===
 
Debug Features
 
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

Latest revision as of 23:46, 5 December 2023

EstToolTab Ribbon

Insert / Convert

InsertConvertRibbon.png

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

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

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

Redo

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

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

Retrieved from "https://thewiki.builtplainly.com/index.php?title=Est_Tool_Tab&oldid=1771"