Difference between revisions of "Report and Others"

From SynWiki
Jump to navigation Jump to search
(Removed Recap)
 
(25 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[File:ReportAndReview1.2.0.14.png|frame|center|link=]]
+
[[File:ReportAndOthersRibbon2.0.png|alt=|center|frame]]
  
 
= Report and Review =
 
= Report and Review =
−
== Others ==
+
== 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]] ===
 
=== [[Show SD]] ===
Line 10: Line 35:
 
Shows or Hides HD's on the Summary Page
 
Shows or Hides HD's on the Summary Page
  
−
=== [[Show IND]] ===
+
=== [[Show Zeros]] ===
−
Shows or Hides HD's on the Summary Page
+
Show or Hides Zeros on the Summary Page
 +
 
  
−
=== [[Show LBR]] ===
 
−
Shows or Hides HD's on the Summary Page
 
  
−
=== [[Show Bond]] ===
+
=== [[Extra Summary Data]] ===
−
Enables or Disables the Bond Column
+
Adds extra lines to the bottom of the Summary Page
  
−
== More ==
+
=== [[Extra Summary CM]] ===
 +
Adds extra comments to the bottom of the Summary Page
  
 
=== [[Scratch Sheet]] ===
 
=== [[Scratch Sheet]] ===
 
Will create a blank worksheet that can be used for anything
 
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]] ===
 
=== [[Approve WS]] ===
 
Changes the Tab Color of the Worksheet to Green/Approved
 
Changes the Tab Color of the Worksheet to Green/Approved
  
−
=== [[Freeze Top]] ===
+
== Breakdown ==
−
Freezes the Top few lines so they stay with you as you scroll
+
 
 +
=== [[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
  
−
=== [[Extra Summary Data]] ===
+
=== [[Show Targets]] ===
−
Adds extra lines to the bottom of the Summary Page
+
Reveals or Hides the Target Columns on a Div
  
−
=== [[Change Theme]] ===
+
== More ==
−
Changes the Current Workbook Theme
 
  
 
=== [[Re-Calc WB]] ===
 
=== [[Re-Calc WB]] ===
 
Re-Calculates the entire Workbook
 
Re-Calculates the entire Workbook
−
 
−
=== [[Set Page Breaks]] ===
 
−
Sets the Page Breaks for the Workbook
 
−
 
−
=== [[Set Page Breaks|Set Page]] ===
 
−
Sets the Page Break for the Current Worksheet
 
  
 
=== [[PrintToPDF]] ===
 
=== [[PrintToPDF]] ===
 
Prints the Workbook to a Pdf
 
Prints the Workbook to a Pdf
  
−
== Recap ==
+
==== Print Client Book ====
−
 
+
Prints the Book with specfic pre-set settings
−
=== [[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]] ===
+
==== Print Default ====
−
Hides Div Cols and Shows Recap Section simutanously
+
Prints the Book with specfic pre-set settings
  
−
=== [[Hide Div Cols]] ===
+
=== [[Reformat]] ===
−
Hides all unnecessary Div Cols for Recap
+
Reformats the Page to its Intended State
 +
* Only works for Div's
  
−
=== [[Show Recap]] ===
+
==== Reformat Workbook ====
−
Shows/Hides the Recap Section
+
Reformats the Entire Workbook
  
 
== Budget Summary Options ==
 
== Budget Summary Options ==

Latest revision as of 23:51, 5 December 2023

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

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