Learn more

Adjusting a spreadsheet column

The Adjust Column feature allows you to modify quantities, amounts, and prices for selected cells within a spreadsheet column. For example, if certain portions of a project are duplicated, you can avoid laboriously taking the items off a second time by simply adjusting selected takeoff quantities.

You can use this feature to change cells in the following spreadsheet columns: Takeoff Quantity, category Productivity (Labor and Equipment only), category Price, category Amount, and Totals.

The Adjust Column feature is not available when items are combined.

To adjust a spreadsheet column:

Select the cells to adjust. To select an entire column, click the column heading.

You can select multiple cells in a column using the standard Microsoft Windows selection methods.

Right-click and select Adjust Column from the shortcut menu. The Adjust Column window opens.
Complete the fields in the Adjust Column window.
Click [OK] to apply the adjustment to the selected cells.

A red triangle appears on the spreadsheet cells to show that they have been adjusted.

Your spreadsheet adjustments are "temporary" at this point. You can reverse (undo) the adjustments until you make them permanent by finalizing them.

Tips:

You can adjust an entire group of items when you select Adjust Column from an overline cell. The adjustment affects all items within that overline.
To see a popup showing the original and adjusted values, point to any cell with a red triangle.
For equipment productivity, an adjustment applies only if equipment has the same productivity as labor, or if there is no labor productivity.
If there is a pending job total adjustment (in the Totals window) and the Adjustment type is Spread, addon amounts are subtracted before the adjustment is made.