Difference between revisions of "Report and Others"
(Removed Recap) |
|||
| (41 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[File: | + | [[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]] === | === [[Show SD]] === | ||
| Line 9: | Line 35: | ||
Shows or Hides HD's on the Summary Page | 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]] === | === [[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 | ||
| − | === [[ | + | === [[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 | |
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
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
