Difference between revisions of "Report and Others"

From SynWiki
Jump to navigation Jump to search
(Removed Recap)
 
(38 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[File:ReportAndReviewPic.png|frame|center|link=report and others]]
+
[[File:ReportAndOthersRibbon2.0.png|alt=|center|frame]]
  
 
= Report and Review =
 
= Report and Review =
−
== Report ==
+
== 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
  
−
=== [[Change Theme]] ===
+
=== [[Show Zeros]] ===
−
Changes the Current Workbook Theme
+
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]] ===
 
=== [[Show Bond]] ===
 
Enables or Disables the Bond Column
 
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-Calc WB]] ===
 
Re-Calculates the entire Workbook
 
Re-Calculates the entire Workbook
  
−
=== [[Set Page Breaks]] ===
+
=== [[PrintToPDF]] ===
−
Sets the Page Breaks for the Workbook
+
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
  
−
=== [[Set Page Breaks|Set Page]] ===
+
=== [[Show HD Budget]] ===
−
Sets the Page Break for the Current Worksheet
+
Shows or hides all HD lines on the Budget Sheet

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