Difference between revisions of "Report and Others"
m (→Breakdown) |
(Removed Recap) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 78: | Line 78: | ||
=== [[Insert Letter]] === | === [[Insert Letter]] === | ||
| + | Inserts a new letter into the Breakdown Sheet | ||
=== [[Insert Space]] === | === [[Insert Space]] === | ||
| + | Inserts a space line into the Breakdown Sheet | ||
=== [[Insert SubTotal]] === | === [[Insert SubTotal]] === | ||
| + | Inserts a SubTotal line into the Breakdown Sheet | ||
=== [[Delete Any]] === | === [[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 == | == More == | ||
| Line 108: | Line 115: | ||
==== Reformat Workbook ==== | ==== Reformat Workbook ==== | ||
Reformats the Entire Workbook | 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
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