Report and Others

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

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

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

Add User Item

Adds a New User Added Item

• Only on Summary, Recoverable and BreakDown Pages

Show Dis. Total

Hides and Unhides the Breakdown (Alpha Label) Distributed Total

SPL Comments

Hides and Unhides the SPL Comments within the Workbook

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

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