Map Metra

Estimate 3: Formulas and tools

Any quantity or rate cell can hold a formula, saved with the cell so you can edit it later. Find and Replace changes values across the whole sheet in one sweep, with a single undo.

How to

  1. 1

    Use formulas

    Start a quantity or rate cell with '=', for example =65*1.1. Reference another row by its number in square brackets, such as [3.1], or click the row while the cell is open.

  2. 2

    Edit in the formula bar

    Use the f(x) formula bar to see and edit figures at full width.

  3. 3

    Use the calculator

    Work out a figure in the floating calculator and insert it straight into a cell.

  4. 4

    Find and Replace

    Find rows even inside collapsed categories, and change a field such as Mark-up percent on every match at once. One undo reverses the whole sweep.

  5. 5

    Tidy the sheet

    Use Remove zero quantity on the toolbar to clear rows with no quantity, and the View menu to choose what shows.