INDEX

Index

 
DATA

Preventing Changes

PRINTING

Alternate Estimates
Excluding Blank Lines in Estimate Section Printouts
Logo - Adding to Reports
Maximum Collection Level
New Pages
Page Breaks
Removing Blank lines from Printouts
'Show Dimensions' option
To a TEXT file for importing into External Applications
 

PROJECTS

Account Bridging File - Creating
Adding a New Column
Add New Resources
Add External Documents
Assignments, Markups, and Overheads
Background Recalculations of
Cash Flow Charts
CC Adjustments
Column Widths - Standardising between worksheets
Cost Categories (CC)
    Displaying Dynamically in Worksheets
Create Account Bridging File
Create Sub-totals in the Section List (Summary)
Create a New Project Template
Creating Excel Workbooks (Schedules/BoQ) with EstimatorVJ 
Currencies
Custom Reports
Cut and Shuffle
Display the Section Totals
Documents

Attaching External Documents
Emailing

DJC (Direct Job Cost) Program Variable
Download Templates from the CCSi Website
Editing the Section Names
Error Collection and Reporting

Exporting Data to External Applications
Exporting Sections to Clipfiles
External Resource Libraries
Find

Resource - where used
Text Phrase - where used
Uncompleted items

Gantt Charts
Generating Tender Summary Sheets
Importing from XLS Workbook
IJC (Indirect Job Cost) Program Variable
Interfacing EstimatorVJ with Excel Workbooks
Locking the Project
ManHours Display
Markups, Assignments, Overhead Spread
    Nominating which 'CC's to receive OH Spread
Maximum Collection Level
Measuring off On-Screen Drawings
Merging
Multiple Currencies
Multi-User Access
Opening V6 Projects in VJ
Overhead Spread, Markups, and Assignments
    Nominating which 'CC's to receive OH Spread
Password - Protecting Workup Sheet
Prevent Changes to My Data
Print to an Excel Workbook
Project Password
Recalculating in the Background
Removing Unused Resources
Resources
            SubLibraries
            Editing while in a Worksheet
Restore a Project Backup
Restore a Deleted Project
Restore the Automatic Backup of Resources
Schedules
Search

Resource - where used
Text Phrase - where used

Show the Section Totals
Shuffle Items between Sections and Projects
Standardising Column Widths between worksheets
Standard Templates from the CCSi Website - Downloading
Subcategories in CC's
SubContract Comparisons

- Tutorial

SubLibraries
Sub-totals in Project Summary
Synced backups
Templates

Company Templates

Tender Summary Sheets - Generating
Unlocking
Unused Resources - Removing
Updating Excel Workbooks with EstimatorVJ

Updating Client Schedule

Variables
Vetting SubContracts

- Tutorial

SYSTEM

Add/Delete Users to my Account
Bypass the Log In
Change Worksheet Colours

Company Templates

Emails
Function Key Programming
Logging In
LogIn Remotely
Login through a Firewall
Preferences
Programming Function Keys

Program Variables

Progress Panel

Fails to Open

Reinstalling EstimatorVJ
Updates
Work Off-Line

 
TUTORIALS

General Tutorial
Worksheet
    Structure
        Modifying

 
WORKSHEETS

Add New Resources
Adding Columns

To one Worksheet
To a Project

Adding Notes
Adding Text in a Number Columns
Applying Worksheet Modifications to Other Existing Worksheets
Background Recalculations of
Backups
Calculation Expressions and Formulas
Cells
            Copying to Subsheets
            Display Mode
Change CASE of text
Columns

Adding a Worksheet Column
Data Precisions and Rounding
    for display
    for calculations

Hiding/Unhiding/Resetting

Widths - Standardising between worksheets

Completed Items
Cost Categories Display
Creating NEW Default Worksheet
Display Mode of Cells in Worksheets
Dynamic Worksheet Variables
Editing

Adding Round Brackets

Adding Text in a Number column
Copying Text in a Cell to Child Worksheets
Concatenating Text
Change CASE of Text
Entering/Editing text
Importing Data from an External Application
Project/Worksheet Variables - Selecting and Adding
Ranging whole lines
Resources 'on-the-fly'

Exporting
    Sections to Clipfiles
    To Excel Workbook
Fonts - Modify
Function Key Programming
Hiding Columns
Keyboard Shortcuts

Modify existing Resources
Notes
Omitting/Excluding Items
Options Panel - Unpinning
Password - Protecting Workup Sheet
Programming Function Keys
Protecting with Passwords
Resetting/Unhiding/Hiding Columns
Resources

Modifying 'on-the-fly'

Restore the Automatic Backup
Updating from Another Resource Library
Using Resources

Reverting to a Previous Backup
Schedules
Shuffle Items between Sections and Projects
Special Functions
Standardising Column Widths between worksheets
Structure

Creating NEW Default
Modifying
Preventing Modifications
Applying Modifications to Other Existing Worksheets

Sub-totals in a Worksheet
Templates
Unhiding/Hiding/Resetting Columns
Unpinning the Options Panel
Updating from an External Source
Using Lookup Tables
Variables

 

TROUBLE SHOOTING

Another User prevents this Operation
Blank Printouts
Deleting Projects
Displaying the Section Totals
Logging On
ManHours not correct in Reports
Program Locking Up
Resources don't come across when copying from another Project
Resources accidentally removed from the Resource Library
Resource Library recalculates 7 times

INDEX

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A

Account - Adding/Deleting users
Account Bridging File - Creating
Add a Column to a Worksheet
Add/Delete Users to my Account
Add External Documents
Add New Resources
Adding a Column

To one Worksheet
To a Project   

Adding a Logo to Reports
Adding Notes to a Worksheet
Adding Text in Number Columns
Advanced Functions
Alternate Estimates
Another User prevents this Operation
Applying Worksheet Modifications to Other Existing Worksheets
Assignments, Markups, and Overhead Spread
Attaching External Documents

B

Background Recalculations of Projects/Worksheets
Backups
    Restore a Project Backup
    Synced Project Backups
    Worksheet
Blank Lines - Excluding in Estimate Section Printouts
Browse nested workup sheets or composites

C

Calculations - Rounding
Calculation Expressions and Formulas - Special Functions
Calculated Sub-totals
CASE, changing of text
Cash Flow Charts
'CC' Breakdowns

Cells - Display Mode
Change Worksheet Colours
Changing a Resource Code Globally
Changing Worksheet Structures
    To an Individual Worksheet
    To ALL Project Worksheets
Client Schedule - Updating
Colours - Changing Worksheet Colours
Columns

Adding
Deleting ALL of a particular Name
Hiding/Unhiding/Resetting
Locking Columns
Modifying

Column Widths - Standardising between worksheets
Company Templates
Completed Items
Concatenating items
Copying one section to another
Cost Categories Display
     Displaying Dynamically in Worksheets  
Create Account Bridging File
Creating Alternate Estimates
Creating Excel Workbooks (Schedules/BoQ) with EstimatorVJ
Creating Sub-totals in the Section List (Summary)
Creating Sub-totals in a Worksheet
Currencies
Custom Reports
Cut and Shuffle
 

D

Data - Importing from an External Application
Data - Preventing Changes
Default Worksheet - Creating/Modifying
Delete a Column from a Worksheet
Deleting ALL columns of a particular Name
Delete Users from my Account
Deleted Projects - Restoring
Deleting Projects - Troubleshooting
Dimensions - Showing in Reports
DJC (Direct Job Cost) Program Variable
Display Cost Categories On-Screen
Display ManHours
Display Mode in Worksheets
Documents

Attaching External Documents
Emailing

Downloading Standard Templates from the CCSi Website
Drawings

Preferences
Measuring off

Dynamic Worksheet Variables

E

Editing the Section Names
Editing Worksheets

Omitting/Excluding Items

Range whole lines

Email

Setting Up
Attached Documents

Entering Sub-totals
Error Collection and Reporting
EstimatorVJ - Reinstalling
EstimatorVJ Updates
Excel Workbooks
    Interfacing EstimatorVJ with
    Creating Client Schedule/BoQ with EstimatorVJ

Existing Resources
            Editing while in a Worksheet
Exporting
    Data to External Applications
    Sections to Clipfiles
    Data To an Excel Workbook
External Applications - Importing Data from
External Documents - Attaching
External Resource Libraries
 

F

Finding in Project

Resource where Used

Text where used

Firewalls - Logging in
Fonts - Changing Worksheet Fonts
Formulas - Advanced Functions
Function Key Programming
Freezing the Data
Function Key Programming
 

G
H
I

Importing Data from an External Application
Importing from XLS Workbook
IJC (Indirect Job Cost) Program Variable
Insert a New Worksheet Column
Interfacing EstimatorVJ with Excel Workbooks
Internet Settings
Items

Marking as Completed

 

J
 
K

Keyboard Shortcuts

L

Lines - Range whole lines
Locking Columns
Locking the Project
Locking Up in the Program

Login Password - changing
LogIn Remotely
Login through a Firewall
Logo - Adding to Reports
Lookup Tables

Creating
Retrieving
 

M

ManHours Display
Markup Estimate Sections and/or Bill Items
Markups, Reassignments, Overhead Spread
Maximum Collection Level
Measuring Directly off drawings
Merging Projects
Missing Resources in the Resource Library
Modifying existing Resources
Modifying the Default Worksheet
Modifying Worksheet Structures
    To an Individual Worksheet
    To ALL Project Worksheets

Preventing

Multiple Currencies
Multi-User Access
 

N

New Page in General Estimate Section Prints
New Resources, Adding
Notes
Number Columns, Adding Text

O

Omitting/Excluding Items

Omit Flag

On-screen Drawings - Measuring off
Opening V6 Projects in VJ
Options Panel - Unpinning
Overhead Spread, Assignments, and Markups
    Nominating which 'CC's to receive OH Spread

P

Password
    Changing/Resetting the Login Password
    Protecting Workup Sheets
Precisions in Rounding
Preferences
Preventing Changes to the Project Data
Preventing Illegal Access to a Project
Preventing Modifications to Worksheet Structures
Printing

Adding a Logo to Reports
Creating an Excel Workbook from
Maximum Collection Level
New Page Control

Project 
            Adding a Column

Cash Flow Charts
Creating Templates 
Displaying Section Totals
Exporting Data to External Applications
Finding Uncompleted items
Gantt Charts
Locking the Project
Maximum Collection Level
Merging
Modifying Worksheet Structures
    To an Individual Worksheet
    To ALL Project Worksheets
Multi-User Access
Opening V6 Projects in VJ
Password for Protecting Workup Sheets
Recalculating in the Background
Removing Unused Resources
Restoring a Backup
Restoring a Deleted project
Secure from Illegal Access
Sections - Exporting to Clipfiles
Synced Backups
Templates from the CCSi Website - Downloading

Variables

Program Locking Up
Program Variables
Programming Function Keys
Progress Panel

Fails to Open

Project Variables
Protecting Workup Sheets with Passwords
Proxy Settings
 

Q
R

Ranging whole lines
Recalculating Projects in the Background
Referenced Variables
Reinstalling EstimatorVJ
Remotely Logging In
Reports

Adding a  Logo to
Custom Reports
'Show Dimensions' option

Resetting/Unhiding/Hiding Columns
Resources

Adding New
Changing a Resource Code Globally
Cost Categories
Creating
Editing while in a Worksheet
External
Finding where Used
Missing from the Resource Library
Modifying
Modifying 'on-the-fly'
Removing Unused Resources
Restoring the Automatic Backup
Spring Loaded RC List Panel
Subcategories
SubLibraries
Updating from another Resource Library

Restore a Project Backup
Restore a Worksheet Backup
Restoring a Deleted Project
Reverting to a Previous Worksheet Backup
Rounding in Calculations
 

S

Schedules
Searching in Project

Resource where Used

Text where used

Sections

Copying one section to another

Editing Section Names

Section Totals - Displaying
Sections - Exporting to Clipfiles 
Secure Project from Illegal Access
Shortcuts - Keyboard
'Show Dimensions' option in Reports
Software Updates
Special Functions in Calculations and Formulas
Standardising Column Widths between worksheets
Structure - Modifying Worksheet
Shuffling Items between Sections and Projects
Status Panel

Fails to Open

Subcategories

- Tutorial

SubLibraries
Sub-totals
    In the Section Names List (Summary)
    In a Worksheet
    Calculated Sub-totals
Synced Project Backups
System Preferences
 

T

Tags to Drawing Measurements
Templates

Company Templates

Creating a New Project Template
Downloading Standard Templates from the CCSi Website
Worksheet Templates

Tender Summary Sheets - Generating
Text - Adding in Number Columns
Trouble Shooting

Another User prevents this Operation
Deleting Projects
 

U

Uncompleted items
Unhiding/Hiding/Resetting Columns
Unlocking a Project
Unpinning the Options Panel
Unused Resources - Removing
Updates
Updating Excel Workbooks with EstimatorVJ
Updating Client Schedule
Using Sub-totals
Users - Adding/Deleting/Editing

V

V6 Projects - Opening in VJ
Variables  (Program, Project,  Dynamic project)
        Display Options
Vetting SubContracts

- Tutorial

 

W

Work Off-Line

Worksheets
            Adding a Column

Reverting to a Previous Backup
Schedules
Templates
Updating from an External Source
Variables

Worksheet Structure

Modifying
Applying Modifications to Other Existing Worksheets
Preventing Modifications 

Workup Sheets - Protecting with Passwords

X
Y
 
Z