How units of measure are used in Sage Estimating (SQL)

As you work, you will encounter various units of measure throughout Sage Estimating (SQL).

• Phases use units to accumulate the cost per unit for an entire phase. These units appear at the phase level on the spreadsheet and reports. Example

  Example: For a Base Course phase, you might takeoff the following items that have their own units and costs.

  Item	Material	Labor	Equipment
  Filter fabric	sqft	hour, hr
  Gravel	cuyd	hour, hr
  Compaction		hour, hr	hour, hr

  To calculate the cost per unit for that entire phase, Sage Estimating (SQL) adds all costs and divides by the phase unit you specify. Depending on your reporting needs, you could set up the phase with a unit of square foot, cubic yard, or hours.

• Items have separate units for the takeoff and order quantities. The unit of measure you use for takeoff can be the same or different from the one you use for pricing. Both units appear at the item level on the spreadsheet and reports. Examples

  Examples:

  • Tile might be taken off and ordered by the square foot. In this case, you would set up the item with the same unit description for the takeoff unit and the order unit.

  • Filter fabric might be taken off by the square foot and ordered by the roll. In this case, you would set up the item with a takeoff unit of square foot and an order unit of roll.

  In addition, Sage Estimating (SQL) calculates labor and equipment hours if items have a time-based order unit. Crew pricing requires items to have a time-based order unit for labor and equipment.

  Note: This feature is available only if you have a license to use Crews.

  The totals appear on the spreadsheet, Totals window, and reports.

• Assemblies use units to label the cost per unit for an entire assembly. These units appear during takeoff as well as in the spreadsheet and on reports.
• Formulas have units to indicate what is being calculated at takeoff. The calculated result is actually based on the takeoff unit of the item.
• Variables have units to indicate what dimension is being requested at takeoff. The calculated result is actually based on the takeoff unit of the item.
• Work breakdown structures have units to label the cost per unit when the spreadsheet is in a WBS sequence.

• Subcategories use units to accumulate takeoff quantities for all items with that subcategory and with the same takeoff unit as the subcategory unit. These totals appear only on reports. Example

  Example: To report on the takeoff quantities of items with and without union labor, you would set up one subcategory called Union Labor and another called Non-Union Labor, making sure to enter a unit of measure for each.

  If an item is assigned to either of these subcategories and its takeoff unit matches the subcategory unit, Sage Estimating (SQL) adds its takeoff units to the total for that subcategory.

• The Bill of Materials (BOM) uses the item order units to accumulate order quantities for each BOM description within the same material class.
• The estimate information specifies a unit of measure for the job size and project duration.