SynWiki - User contributions [en]

Report and Others

2023-12-05T23:51:58Z

Andrew samoil: Removed Recap

[[File:ReportAndOthersRibbon2.0.png|alt=|center|frame]]

= Report and Review =
== General Settings ==

=== [[Show LBR]] ===
Shows or Hides HD's on the Summary Page

=== [[Show IND]] ===
Shows or Hides HD's on the Summary Page

[[Add User Item]]

Adds a New User Added Item
* Only on Summary, Recoverable

=== [[Freeze Top]] ===
Freezes the Top few lines so they stay with you as you scroll

=== [[Change Theme]] ===
Changes the Current Workbook Theme

=== [[Set Page Breaks]] ===
Sets the Page Breaks for the Workbook

=== [[Set Page Breaks|Set Page]] ===
Sets the Page Break for the Current Worksheet

== Summary Settings ==

=== [[Show SD]] ===
Shows or Hides SD's on the Summary Page

=== [[Show HD]] ===
Shows or Hides HD's on the Summary Page

=== [[Show Zeros]] ===
Show or Hides Zeros on the Summary Page

=== [[Extra Summary Data]] ===
Adds extra lines to the bottom of the Summary Page

=== [[Extra Summary CM]] ===
Adds extra comments to the bottom of the Summary Page

=== [[Scratch Sheet]] ===
Will create a blank worksheet that can be used for anything

== Worksheet Settings ==

=== [[Show Bond]] ===
Enables or Disables the Bond Column

=== [[Add End Line]] ===
Adds a line at the end of a Div sheet to show that its the end

=== [[Approve WS]] ===
Changes the Tab Color of the Worksheet to Green/Approved

== Breakdown ==

=== [[View BD]] ===
Shows a view of all Breakdown Sheets and their order

===== [[Make B.D.]] =====
Creates an additional Breakdown sheet to be used in the Workbook

===== [[Push To Target]] =====
Pushes all Marked data to a Target Excel book

=== [[BD Helper]] ===
Enlarges the view of a BD cell on a Div for easier editing

=== [[Enable B.D.]] ===
Hides and Unhides the Breakdown (Alpha Label) Column on Div's

=== [[Insert Letter]] ===
Inserts a new letter into the Breakdown Sheet

=== [[Insert Space]] ===
Inserts a space line into the Breakdown Sheet

=== [[Insert SubTotal]] ===
Inserts a SubTotal line into the Breakdown Sheet

=== [[Delete Any]] ===
Deletes Any Line on the Breakdown Sheet

=== [[Flip Lock]] ===
Flips the Disperse Lock for each Letter

=== [[Show Targets]] ===
Reveals or Hides the Target Columns on a Div

== More ==

=== [[Re-Calc WB]] ===
Re-Calculates the entire Workbook

=== [[PrintToPDF]] ===
Prints the Workbook to a Pdf

==== Print Client Book ====
Prints the Book with specfic pre-set settings

==== Print Default ====
Prints the Book with specfic pre-set settings

=== [[Reformat]] ===
Reformats the Page to its Intended State
* Only works for Div's

==== Reformat Workbook ====
Reformats the Entire Workbook

== Budget Summary Options ==

=== [[Budget Sheet]] ===
Creates a budget sheet between two different workbooks (the current one and another one)

=== [[Show SD Budget]] ===
Shows or hides all SD lines on the Budget Sheet

=== [[Show Zeros Budget]] ===
Shows or hides all Zeros lines on the Budget Sheet

=== [[Show HD Budget]] ===
Shows or hides all HD lines on the Budget Sheet

Redo

2023-12-05T23:49:11Z

Andrew samoil: Created page with "To Redo: Undo an action and press Redo to redo it. center"

To Redo:

Undo an action and press Redo to redo it.

[[File:EST2.3.0.0 Redo.gif|border|center]]

File:EST2.3.0.0 Redo.gif

2023-12-05T23:47:31Z

Andrew samoil:

EST2.3.0.0 Redo

Undo

2023-12-05T23:47:01Z

Andrew samoil:

To Undo:
# Make a Change
# Press Undo

[[File:EST2.3.0.0 Undo.gif|alt=|center]]

Undo

2023-12-05T23:46:43Z

Andrew samoil: update

To Undo:
# Make a Change
# Press Undo

Note:
* You can only Undo on Div Pages in the Current Edition
* Once you leave a Page, the changes you made cannot be undone via the undo button

[[File:EST2.3.0.0 Undo.gif|alt=|center]]

File:EST2.3.0.0 Undo.gif

2023-12-05T23:46:34Z

Andrew samoil:

EST2.3.0.0 Undo

Est Tool Tab

2023-12-05T23:46:03Z

Andrew samoil: /* Redemption */

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

=== [[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 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]] ===
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

=== [[Project Total|Fee]] ===
Dynamic Sum of the Fee Total

=== [[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]] ===
Copies the Section of the row selected

=== [[Copy Section|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
'''<big>[[Redo]]</big>'''

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

Add LBR Premium

2023-12-05T22:33:52Z

Andrew samoil: updated gif

This button adds a custom Labour Premium Line that Calculates and adds the Labour Premium to the Estimating book

This Line is Calculated by = (Total Labour Cost - Staff Labour Cost) * Labour Premium percent

This percent can be changed by editing the percent in the Description Column of the Labour Premium Line

[[File:EST2.3.0.0 AddLBRPRemium.gif|alt=|center]]

File:EST2.3.0.0 AddLBRPRemium.gif

2023-12-05T22:33:32Z

Andrew samoil:

EST2.3.0.0 AddLBRPRemium

Add Tool Allowance

2023-12-05T22:33:07Z

Andrew samoil: updated gif

This button adds a custom Small Tool Allowance Line that Calculates and adds the Small Tool Allowance to the Estimating book

This Line is Calculated by = (Total Labour Cost - Staff Labour Cost) * Small Tool Allowance percent

This percent can be changed by editing the percent in the Description Column of the Small Tool Allowance Line

[[File:EST2.3.0.0 AddSmallToolAllow.gif|alt=|center]]

File:EST2.3.0.0 AddSmallToolAllow.gif

2023-12-05T22:32:41Z

Andrew samoil:

EST2.3.0.0 AddSmallToolAllow

Est Tool Tab

2023-12-05T22:22:55Z

Andrew samoil: /* Insert / Convert */

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

=== [[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 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]] ===
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

=== [[Project Total|Fee]] ===
Dynamic Sum of the Fee Total

=== [[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]] ===
Copies the Section of the row selected

=== [[Copy Section|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

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

Show Targets

2023-06-13T14:46:38Z

Andrew samoil: Created page with "This checkbox will show and hide the Target Columns within the BD Sheet center"

This checkbox will show and hide the Target Columns within the BD Sheet

[[File:ReportAndReview ShowTargets.gif|center]]

File:ReportAndReview ShowTargets.gif

2023-06-13T14:45:44Z

Andrew samoil:

ReportAndReview ShowTargets

Flip Lock

2023-06-13T14:37:55Z

Andrew samoil: Created page with "This button will flip the disperse Lock on a BD Letter. Meaning that its distributed total will be not distributed when calculated. The Lock can either be True or False ..."

This button will flip the disperse Lock on a BD Letter. Meaning that its distributed total will be not distributed when calculated.

The Lock can either be True or False

[[File:ReportAndReview FlipLock.gif|center]]

File:ReportAndReview FlipLock.gif

2023-06-13T14:34:54Z

Andrew samoil:

ReportAndReview FlipLock

Delete Any

2023-06-12T22:53:26Z

Andrew samoil: Created page with "This button will delete any selected row on the BD sheet This includes Letters, Space lines and SubTotal lines center"

This button will delete any selected row on the BD sheet

This includes Letters, Space lines and SubTotal lines

[[File:ReportAndReview DeleteAny.gif|center]]

File:ReportAndReview DeleteAny.gif

2023-06-12T22:53:18Z

Andrew samoil:

ReportAndReview DeleteAny

Insert SubTotal

2023-06-12T22:30:17Z

Andrew samoil:

This will insert a SubTotal line (STTL) in the Breakdown that will calculate the Subtotal for the BD Sheet

The line can be removed with the Delete Any button located below it

[[File:ReportAndReview InsertSTTL.gif|center]]

Insert SubTotal

2023-06-12T22:29:48Z

Andrew samoil: Created page with "This will insert a SubTotal line (STTL) in the Breakdown that will calculate the Subtotal for the BD Sheet center"

This will insert a SubTotal line (STTL) in the Breakdown that will calculate the Subtotal for the BD Sheet

[[File:ReportAndReview InsertSTTL.gif|center]]

File:ReportAndReview InsertSTTL.gif

2023-06-12T22:28:07Z

Andrew samoil:

ReportAndReview InsertSTTL

Insert Space

2023-06-12T22:21:50Z

Andrew samoil:

This button will insert a Space line imbetween rows on the Breakdown Sheet

[[File:ReportAndReview InsertSPC.gif|center]]

File:ReportAndReview InsertSPC.gif

2023-06-12T22:21:35Z

Andrew samoil:

ReportAndReview InsertSPC

Insert Space

2023-06-12T22:02:06Z

Andrew samoil: Created page with "tem"

tem

Insert Letter

2023-06-12T21:24:29Z

Andrew samoil:

This button will insert a letter on a BD Sheet and will shift all letters below it down a letter. This can be repeated an infinite amount of times.

Letters can be deleted with the Delete Any button located within and below the InsertAlpha button

[[File:ReportAndReview InsertLetter.gif|center]]

File:ReportAndReview InsertLetter.gif

2023-06-12T21:24:02Z

Andrew samoil:

ReportAndReview InsertLetter

Insert Letter

2023-06-12T21:23:42Z

Andrew samoil: Created page with "This button will insert a letter on a BD Sheet and will shift all letters below it down a letter. This can be repeated an infinite amount of times. Letters can be deleted wit..."

BD Helper

2023-06-12T20:05:18Z

Andrew samoil:

This button will make a form appear that will show the Multiplier, Letter, and Description for the Breakdown Cell on a Div

<nowiki>*</nowiki>NOTE, you do not have to use this to edit the BD Cell (you can edit it directly), this is just a helper.

[[File:ReportAndReview BDHelper.gif|center]]

BD Helper

2023-06-12T20:05:10Z

Andrew samoil:

File:ReportAndReview BDHelper.gif

2023-06-12T19:56:21Z

Andrew samoil:

ReportAndReview BDHelper

BD Helper

2023-06-12T19:31:52Z

Andrew samoil: Created page with "tmep"

tmep

Push To Target

2023-06-12T19:31:31Z

Andrew samoil:

This button will push all Marked BD Cells to a Separate Workbook

* Marked must be of the format SheetName,Cell Ex. Sheet1,A1
* There are Target Columns for Description, Total, Distributed Total and Subtrade
* These columns become visible via the Show Targets checkbox

[[File:ReportAndReview PushToTarget.gif|center]]

Push To Target

2023-06-12T19:28:59Z

Andrew samoil: Created page with "This button will push all Marked BD Cells to a Separate Workbook * Marked must be of the format SheetName,Cell Ex. Sheet1,A1 center"

This button will push all Marked BD Cells to a Separate Workbook

* Marked must be of the format SheetName,Cell Ex. Sheet1,A1

[[File:ReportAndReview PushToTarget.gif|center]]

File:ReportAndReview PushToTarget.gif

2023-06-12T19:27:44Z

Andrew samoil:

ReportAndReview PushToTarget

Make B.D.

2023-06-12T18:41:22Z

Andrew samoil:

To Make a Breakdown Sheet the user must press the Make B.D. button in the Breakdown Sub-Section
* The Enable B.D. Checkbox must be Enabled to Create One
* You can Create as Many Breakdowns as you need
* Breakdown Sheets can be deleted with the Delete Sheet Button in the EstToolTab

[[File:ReportAndReview MakeBD.gif|alt=|center]]

File:ReportAndReview MakeBD.gif

2023-06-12T18:26:00Z

Andrew samoil:

ReportAndReview MakeBD

View BD

2023-06-12T18:16:10Z

Andrew samoil:

This Creates a View of All the Breakdown Sheets and the Order that they exist in

* You Can Edit the Name of a Breakdown Sheet from this Form, The program will tell you if it is a valid name or not
* When a Sheet is selected from this form , you can click the Wipe BD button to Wipe all Div's that have letter for that sheet
* There is a button to add another BD Sheet

[[File:ReportAndReview ViewBD.gif|center]]

View BD

2023-06-12T18:15:57Z

Andrew samoil:

File:ReportAndReview ViewBD.gif

2023-06-12T18:07:57Z

Andrew samoil:

ReportAndReview ViewBD

View BD

2023-06-12T17:51:26Z

Andrew samoil:

View BD

2023-06-12T17:28:00Z

Andrew samoil: Created page with "temp"

temp

Report and Others

2023-06-12T17:27:33Z

Andrew samoil: /* Breakdown */

[[File:ReportAndOthersRibbon2.0.png|alt=|center|frame]]

= Report and Review =
== General Settings ==

=== [[Show LBR]] ===
Shows or Hides HD's on the Summary Page

=== [[Show IND]] ===
Shows or Hides HD's on the Summary Page

[[Add User Item]]

Adds a New User Added Item
* Only on Summary, Recoverable

=== [[Freeze Top]] ===
Freezes the Top few lines so they stay with you as you scroll

=== [[Change Theme]] ===
Changes the Current Workbook Theme

=== [[Set Page Breaks]] ===
Sets the Page Breaks for the Workbook

=== [[Set Page Breaks|Set Page]] ===
Sets the Page Break for the Current Worksheet

== Summary Settings ==

=== [[Show SD]] ===
Shows or Hides SD's on the Summary Page

=== [[Show HD]] ===
Shows or Hides HD's on the Summary Page

=== [[Show Zeros]] ===
Show or Hides Zeros on the Summary Page

=== [[Extra Summary Data]] ===
Adds extra lines to the bottom of the Summary Page

=== [[Extra Summary CM]] ===
Adds extra comments to the bottom of the Summary Page

=== [[Scratch Sheet]] ===
Will create a blank worksheet that can be used for anything

== Worksheet Settings ==

=== [[Show Bond]] ===
Enables or Disables the Bond Column

=== [[Add End Line]] ===
Adds a line at the end of a Div sheet to show that its the end

=== [[Approve WS]] ===
Changes the Tab Color of the Worksheet to Green/Approved

== Breakdown ==

=== [[View BD]] ===
Shows a view of all Breakdown Sheets and their order

===== [[Make B.D.]] =====
Creates an additional Breakdown sheet to be used in the Workbook

===== [[Push To Target]] =====
Pushes all Marked data to a Target Excel book

=== [[BD Helper]] ===
Enlarges the view of a BD cell on a Div for easier editing

=== [[Enable B.D.]] ===
Hides and Unhides the Breakdown (Alpha Label) Column on Div's

=== [[Insert Letter]] ===
Inserts a new letter into the Breakdown Sheet

=== [[Insert Space]] ===
Inserts a space line into the Breakdown Sheet

=== [[Insert SubTotal]] ===
Inserts a SubTotal line into the Breakdown Sheet

=== [[Delete Any]] ===
Deletes Any Line on the Breakdown Sheet

=== [[Flip Lock]] ===
Flips the Disperse Lock for each Letter

=== [[Show Targets]] ===
Reveals or Hides the Target Columns on a Div

== More ==

=== [[Re-Calc WB]] ===
Re-Calculates the entire Workbook

=== [[PrintToPDF]] ===
Prints the Workbook to a Pdf

==== Print Client Book ====
Prints the Book with specfic pre-set settings

==== Print Default ====
Prints the Book with specfic pre-set settings

=== [[Reformat]] ===
Reformats the Page to its Intended State
* Only works for Div's

==== Reformat Workbook ====
Reformats the Entire Workbook

== Recap ==

=== [[Select Material]] ===
Sets the selected material value from the recap section into the Div

=== [[Select Subtrade]] ===
Sets the selected subtrade value from the recap section into the Div

=== [[Full Recap]] ===
Hides Div Cols and Shows Recap Section simutanously

==== [[Hide Div Cols]] ====
Hides all unnecessary Div Cols for Recap

==== [[Show Recap]] ====
Shows/Hides the Recap Section

== Budget Summary Options ==

=== [[Budget Sheet]] ===
Creates a budget sheet between two different workbooks (the current one and another one)

=== [[Show SD Budget]] ===
Shows or hides all SD lines on the Budget Sheet

=== [[Show Zeros Budget]] ===
Shows or hides all Zeros lines on the Budget Sheet

=== [[Show HD Budget]] ===
Shows or hides all HD lines on the Budget Sheet

Report and Others

2023-06-12T17:05:45Z

Andrew samoil: /* Breakdown */

[[File:ReportAndOthersRibbon2.0.png|alt=|center|frame]]

= Report and Review =
== General Settings ==

=== [[Show LBR]] ===
Shows or Hides HD's on the Summary Page

=== [[Show IND]] ===
Shows or Hides HD's on the Summary Page

[[Add User Item]]

Adds a New User Added Item
* Only on Summary, Recoverable

=== [[Freeze Top]] ===
Freezes the Top few lines so they stay with you as you scroll

=== [[Change Theme]] ===
Changes the Current Workbook Theme

=== [[Set Page Breaks]] ===
Sets the Page Breaks for the Workbook

=== [[Set Page Breaks|Set Page]] ===
Sets the Page Break for the Current Worksheet

== Summary Settings ==

=== [[Show SD]] ===
Shows or Hides SD's on the Summary Page

=== [[Show HD]] ===
Shows or Hides HD's on the Summary Page

=== [[Show Zeros]] ===
Show or Hides Zeros on the Summary Page

=== [[Extra Summary Data]] ===
Adds extra lines to the bottom of the Summary Page

=== [[Extra Summary CM]] ===
Adds extra comments to the bottom of the Summary Page

=== [[Scratch Sheet]] ===
Will create a blank worksheet that can be used for anything

== Worksheet Settings ==

=== [[Show Bond]] ===
Enables or Disables the Bond Column

=== [[Add End Line]] ===
Adds a line at the end of a Div sheet to show that its the end

=== [[Approve WS]] ===
Changes the Tab Color of the Worksheet to Green/Approved

== Breakdown ==

=== [[View BD]] ===
Shows a view of all Breakdown Sheets and their order

===== [[Make B.D.]] =====
Creates an additional Breakdown sheet to be used in the Workbook

===== [[Push To Target]] =====
Pushes all Marked data to a Target Excel book

=== [[BD Helper]] ===
Enlarges the view of a BD cell on a Div for easier editing

=== [[Enable B.D.]] ===
Hides and Unhides the Breakdown (Alpha Label) Column on Div's

=== [[Insert Letter]] ===

=== [[Insert Space]] ===

=== [[Insert SubTotal]] ===

=== [[Delete Any]] ===

=== [[Insert Sub Total]] ===
Inserts a subtotal line on a breakdown sheet

== More ==

=== [[Re-Calc WB]] ===
Re-Calculates the entire Workbook

=== [[PrintToPDF]] ===
Prints the Workbook to a Pdf

==== Print Client Book ====
Prints the Book with specfic pre-set settings

==== Print Default ====
Prints the Book with specfic pre-set settings

=== [[Reformat]] ===
Reformats the Page to its Intended State
* Only works for Div's

==== Reformat Workbook ====
Reformats the Entire Workbook

== Recap ==

=== [[Select Material]] ===
Sets the selected material value from the recap section into the Div

=== [[Select Subtrade]] ===
Sets the selected subtrade value from the recap section into the Div

=== [[Full Recap]] ===
Hides Div Cols and Shows Recap Section simutanously

==== [[Hide Div Cols]] ====
Hides all unnecessary Div Cols for Recap

==== [[Show Recap]] ====
Shows/Hides the Recap Section

== Budget Summary Options ==

=== [[Budget Sheet]] ===
Creates a budget sheet between two different workbooks (the current one and another one)

=== [[Show SD Budget]] ===
Shows or hides all SD lines on the Budget Sheet

=== [[Show Zeros Budget]] ===
Shows or hides all Zeros lines on the Budget Sheet

=== [[Show HD Budget]] ===
Shows or hides all HD lines on the Budget Sheet

Report and Others

2023-06-09T21:31:14Z

Andrew samoil: Report change test

[[File:ReportAndOthersRibbon2.0.png|alt=|center|frame]]

= Report and Review =
== General Settings ==

=== [[Show LBR]] ===
Shows or Hides HD's on the Summary Page

=== [[Show IND]] ===
Shows or Hides HD's on the Summary Page

[[Add User Item]]

Adds a New User Added Item
* Only on Summary, Recoverable

=== [[Freeze Top]] ===
Freezes the Top few lines so they stay with you as you scroll

=== [[Change Theme]] ===
Changes the Current Workbook Theme

=== [[Set Page Breaks]] ===
Sets the Page Breaks for the Workbook

=== [[Set Page Breaks|Set Page]] ===
Sets the Page Break for the Current Worksheet

== Summary Settings ==

=== [[Show SD]] ===
Shows or Hides SD's on the Summary Page

=== [[Show HD]] ===
Shows or Hides HD's on the Summary Page

=== [[Show Zeros]] ===
Show or Hides Zeros on the Summary Page

=== [[Extra Summary Data]] ===
Adds extra lines to the bottom of the Summary Page

=== [[Extra Summary CM]] ===
Adds extra comments to the bottom of the Summary Page

=== [[Scratch Sheet]] ===
Will create a blank worksheet that can be used for anything

== Worksheet Settings ==

=== [[Show Bond]] ===
Enables or Disables the Bond Column

=== [[Add End Line]] ===
Adds a line at the end of a Div sheet to show that its the end

=== [[Approve WS]] ===
Changes the Tab Color of the Worksheet to Green/Approved

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

=== [[Show Dis. Total]] ===
Hides and Unhides the Breakdown (Alpha Label) Distributed Total

=== [[Insert Sub Total]] ===
Inserts a subtotal line on a breakdown sheet

==== [[Delete Sub Total]] ====
Deletes Sub-Total that was placed on a breakdown sheet

== More ==

=== [[Re-Calc WB]] ===
Re-Calculates the entire Workbook

=== [[PrintToPDF]] ===
Prints the Workbook to a Pdf

==== Print Client Book ====
Prints the Book with specfic pre-set settings

==== Print Default ====
Prints the Book with specfic pre-set settings

=== [[Reformat]] ===
Reformats the Page to its Intended State
* Only works for Div's

==== Reformat Workbook ====
Reformats the Entire Workbook

== Recap ==

=== [[Select Material]] ===
Sets the selected material value from the recap section into the Div

=== [[Select Subtrade]] ===
Sets the selected subtrade value from the recap section into the Div

=== [[Full Recap]] ===
Hides Div Cols and Shows Recap Section simutanously

==== [[Hide Div Cols]] ====
Hides all unnecessary Div Cols for Recap

==== [[Show Recap]] ====
Shows/Hides the Recap Section

== Budget Summary Options ==

=== [[Budget Sheet]] ===
Creates a budget sheet between two different workbooks (the current one and another one)

=== [[Show SD Budget]] ===
Shows or hides all SD lines on the Budget Sheet

=== [[Show Zeros Budget]] ===
Shows or hides all Zeros lines on the Budget Sheet

=== [[Show HD Budget]] ===
Shows or hides all HD lines on the Budget Sheet

File:ReportAndOthersRibbon2.0.png

2023-06-09T21:30:06Z

Andrew samoil:

ReportAndOthersRibbon2.0

Project Info Guide

2022-08-31T20:39:08Z

Andrew samoil:

[[File:ProjectInfo1.3.0.24.png|center|link=]]

{| class="wikitable"
|+ Caption text
|-
! Item !! Description !! Editable
|-
| Info Item || Describes Item || No
|-
| Cost Code || Code for Item || Yes
|-
| Type || type for Item || No
|-
| Rate || rate percent || Yes
|-
| Amount || Amount || Yes
|-
| By Rate || By Rate or Amount || Yes
|-
| Spread in BD || Amount is spread in B.D. || Yes
|-
| Used in Summary || Item is used in Summary || Yes
|-
| B.D. Letter || Letter for Breakdown || Yes
|-
| B.D. Description || Description from Breakdown || No
|}

Project Info Guide

2022-08-31T20:35:12Z

Andrew samoil:

[[File:ProjectInfo1.3.0.24.png|center|link=]]

{| class="wikitable"
|+ Caption text
|-
! Item !! Description !! Editable !! Header text
|-
| Info Item || Describes Item || No || Example
|-
| Cost Code || Code for Item || Yes || Example
|-
| Type || type for Item || No || Example
|-
| Rate || rate percent || Yes || Example
|-
| Amount || Amount || Yes || Example
|-
| By Rate || By Rate or Amount || Yes || Example
|-
| Spread in BD || Amount is spread in B.D. || Yes || Example
|-
| Used in Summary || Item is used in Summary || Yes || Example
|-
| B.D. Letter || Letter for Breakdown || Yes || Example
|-
| B.D. Description || Description from Breakdown || No || Example
|}

Project Info Guide

2022-08-31T20:30:46Z

Andrew samoil:

[[File:ProjectInfo1.3.0.24.png|center|link=]]

{| class="wikitable"
|+ Caption text
|-
! Item !! Description !! Editable !! Header text
|-
| Info Item || Example || Example || Example
|-
| Cost Code || Example || Example || Example
|-
| Type || Example || Example || Example
|-
| Rate || Example || Example || Example
|-
| Amount || Example || Example || Example
|-
| By Rate || Example || Example || Example
|-
| Spread in BD || Example || Example || Example
|-
| Used in Summary || Example || Example || Example
|-
| B.D. Letter || Example || Example || Example
|-
| B.D. Description || Example || Example || Example
|}

Project Info Guide

2022-08-31T20:27:14Z

Andrew samoil:

[[File:ProjectInfo1.3.0.24.png|center|link=]]

{| class="wikitable"
|+ Caption text
|-
! Item !! Description !! Editable !! Header text
|-
| Contract Finalization || Example || Example || Example
|-
| Building Permits || Example || Example || Example
|-
| Fee || Example || Example || Example
|-
| Design Contingency || Example || Example || Example
|-
| Development Permit App. Cost || Example || Example || Example
|-
| GST || Example || Example || Example
|-
| HST || Example || Example || Example
|-
| PST || Example || Example || Example
|-
| Other Tax || Example || Example || Example
|-
| Wrap Up Liability || Example || Example || Example
|-
| COC Insurance || Example || Example || Example
|-
| GL Insurance || Example || Example || Example
|-
| Performance Bond || Example || Example || Example
|-
| Labour & Materials Bond || Example || Example || Example
|-
| Long-Term Bonding || Example || Example || Example
|}

Project Info Guide

2022-08-31T20:20:56Z

Andrew samoil:

[[File:ProjectInfo1.3.0.24.png|center|link=]]

{| class="wikitable"
|+ Caption text
|-
! Header text !! Header text
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|-
| Example || Example
|}