Finalizing spreadsheet adjustments

Undoing spreadsheet adjustments

Changing the job total or cost/unit

You can change the total cost of a job in the Totals window and spread that amount back to the estimate. This is useful for negotiated jobs when you want to bring the estimate as close as possible to a predefined price. calculates the new cost per unit and shows the variance (difference between the old and new totals).

To change the job total or cost/unit:

  1. Open the Totals window in one of the following ways:

  2. To change the job total, click An image of the Adjust button in the toolbar of the Totals window, select Adjust Job Total, and enter the new total for the job.
  3. Click [Spread Variance].

    closes the Totals window, selects the Total Amount column on the spreadsheet, and opens the Adjust Column window. The Adjustment type is set to Spread and the Amount shows the variance between the original job total and the new job total.

  4. To spread the variance proportionally across all the Total Amount column cells, click [OK].

    A red triangle appears on the Total Amount and Total Cost/Unit column cells to show that they have been adjusted.

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