12 - USING DOUBLE-CLICK

OBJECTIVE

ZUCOST includes intelligent navigation using the double-click action.

This feature allows the estimator to move quickly between Base, Matrix, and the related resource information without manually rebuilding filters each time.

The purpose is to reduce navigation time and keep the estimator focused on the active item.


FROM BASE TO MATRIX

From the Base sheet:

Double-click an item.

ZUCOST automatically opens Matrix and filters the information associated with that item.

This allows the estimator to move directly from the item summary in Base to its detailed resource composition in Matrix.


FROM MATRIX

From the Matrix sheet:

Double-click any resource row.

ZUCOST automatically identifies the active item and processes the related information.

The item remains the working reference while the corresponding resource can be located in Resources.

This provides a faster way to review or verify the resource being used.


COMBINING FILTERS

The Matrix filters can be combined freely.

For example, after opening a specific item, the estimator may also filter by:

• Resource Type.
• Resource Description.
• Unit.
• Cost.
• Other available Matrix fields.

This makes it possible to analyze only the information required at that moment.


EXAMPLE

Suppose the estimator is reviewing Item 3.2 in Base.

1. Double-click Item 3.2.

2. ZUCOST opens Matrix.

3. Matrix is filtered to show the resources associated with Item 3.2.

4. The estimator may then apply an additional filter such as:

Resource Type = LABOR

or

Resource Type = EQUIPMENT

5. Double-clicking a resource row can help locate the corresponding resource information for review.


WHY THIS IS IMPORTANT

In a large estimate, manually moving between sheets and repeatedly applying filters can consume a significant amount of time.

Double-click navigation helps:

• Reduce repetitive navigation.
• Avoid manually searching for item numbers.
• Accelerate resource review.
• Improve continuity between Base and Matrix.
• Keep the active item clearly identified.
• Reduce the possibility of reviewing the wrong item.


USE IT AS A NAVIGATION TOOL

The double-click feature does not replace filters.

Instead, it provides a fast initial navigation method.

After ZUCOST locates the active item, normal Excel filters can still be used to refine the analysis.


IMPORTANT

Before double-clicking, verify that the cursor is positioned on the item or resource row you actually want to review.

The navigation process uses the active row as the reference.


RECOMMENDATION

Use double-click navigation as the normal method for moving from Base to Matrix during detailed estimate review.

Combine it with Matrix filters when a more specific analysis is required.

This feature becomes especially useful in large estimates containing hundreds of items and thousands of resource rows.