Overview
Use the Rate Sheet Wizard to align your rate sheet base values directly with the latest equipment catalog costs or your company's actual purchase records. This data-driven workflow eliminates manual spreadsheet calculations and automatically flags models that lack baseline records. ToolWatch displays a yellow alert banner across the top of the preview window if any selected rows have no base value and cannot be updated. Because applied updates permanently change your active rate sheet with no one-click revert option, always verify your variances on the preview screen before committing changes.
Step-by-Step Instructions
Click Job Cost and Billing on the left-hand navigation sidebar to expand the menu.
Click Rate Sheets.
Click the hyperlinked number in the Rate Sheet ID column for the rate sheet you want to update.
Click Update Wizard in the top options toolbar.
Open the Update Type dropdown menu and select Current Model Base Value or Last Purchase Cost.
Click Preview Changes to load the proposed adjustments.
Review the figures across the Base Value, New Base Value, and Change ($) columns, and check the bottom-left metrics bar to confirm that the Included count, Excluded count, and Total Value Change match your planned adjustments (all items are selected by default; if you only want to update specific items, follow the steps in the How to Filter and Select Items in the Preview Window section).
Select the Show excluded rows checkbox at the top left (which displays the count of excluded items in parentheses) if you need to review models marked --/no data that lack underlying baseline records and will remain unchanged.
Click Apply to [X] rows to finalize and permanently commit your updates to the rate sheet.
How to Filter and Select Items in the Preview Window
Click the master checkbox to the left of the Category column header to deselect all line items.
Type an equipment type into the Category search field to isolate those specific items.
Select the individual checkboxes next to the specific models you want to adjust, noting that each selection automatically updates the Included count at the bottom left and adjusts the number displayed on the dynamic action button.
Click Apply to [X] rows to permanently commit the updates to the selected items only.