Estimate Builder Overview

The Builder tab contains the Estimate Builder component, which enables you to build your estimate using estimate products, line sets, tasks, and role requests.

Note:
  • You must have the appropriate permissions for the fields to display in the Estimate Builder component. Contact your administrator.
  • To view a record's details in a new tab, on the row of a record, click Down then View Details.
  • To export the Work Breakdown and Hours Breakdown views of the Estimate Builder to a CSV file, click Export to CSV File in the toolbar. Only the data in the expanded rows of the Builder are included in the CSV file. For more information, see Estimate Builder Lightning Component Properties.

Hierarchy of Estimate Records

Records on an estimate employ the following hierarchy:

  1. Estimate Products
  2. Line Sets
  3. Tasks
  4. Role Requests

Each record can exist alone, but they will always exist in the outlined hierarchy if the records are related to each other. Any changes to records will have an effect on their parent and child records. If a parent record is deleted, its child records will also be deleted.

Tip:

You can reorder and reparent records by dragging and dropping the rows. However, the new location of the records must still respect the hierarchy, and records can't be moved into or out of estimate products.

Customizing the Estimate Builder

You can customize the Builder in the following ways:

  • Right-click a column header to show a menu with options to hide columns.
  • Use drag-and-drop to reorder columns.
  • Use Drag and Drop to reorder rows.
  • Use the fill handle to copy cell values by clicking and dragging one or more cells and dropping them into other cells.
Tip:

You can also copy and paste specific cells by right-clicking the cell, then click Copy Cells, Cut Cells, or Paste. Keyboard shortcuts are also available to use when copying or pasting cells. For more information, see Estimate Builder Keyboard Shortcuts.

Note:

You cannot use the fill handle in the following scenarios:

  • When dragging cell values from the Discounted Bill Rate column
  • When dragging cell values from the Bill Rate and Discount (%) columns simultaneously
  • When cells are read-only
  • When dragging across different record types
  • When dragging horizontally in the Work Breakdown view
  • When dragging horizontally in the Name and Total Hours columns in the Hours Breakdown view

Your customizations are only applied for your user and are retained if you use the same browser on the same device. Your scroll position and collapsed state of estimate records are also retained for your most recently viewed estimate, provided you only have one estimate open.

Using Fill Handle on Start and End Dates

The following rules apply when changing or amending record dates in a hierarchy:

  • The end date cannot occur before the start date
  • Child start and end dates cannot be set outside of parent start and end dates if the Automatically Adjust Dates custom setting is set to true
  • Changing a start date adjusts the corresponding end date to maintain the same duration
Note:

You cannot use the fill handle to drag more than one start and end date.

Using Full-Time Equivalent (%)

You can update the full-time equivalent (%) of a role request in the Hours Breakdown view. An associated work calendar is required on a role request to edit the FTE (%) field. You can't use FTE (%) and the Hours Multiplier together to calculate the hours of a role request. If you are using the Hours Multiplier, the FTE (%) field will be locked for editing. To manage hours using full-time equivalent, you must set the value in the Hours Multiplier column of the associated estimate product to 1.

If you have multiple work calendars associated with a role request, you can change the value of the Default Work Calendar Hierarchy configuration setting in PSA. For more information, see Resource Settings.

You can choose whether to prioritize full-time equivalent or hours when calculating hours on a role request. You can do this by selecting an option on the Scheduling Strategy field on the Details tab of an estimate. If selected, full-time equivalent will not be prioritized when:

  • Moving estimate start and end dates
  • Adding a template to an estimate
  • Adding an estimate product to an estimate
  • Creating an estimate from a template

If hours can't be calculated using full-time equivalent, the default spread of hours will be used.

Note:

Full-time equivalent can't be calculated in the following situations:

  • There is no work calendar associated with the role request.
  • There is no start or end date on the role request.
  • There are no available hours on the role request's work calendar.
Tip:

We recommend giving the same permissions to all users using full-time equivalent. This is to prevent FTE (%) from getting out of sync. For example, if a user without adequate permissions changed a value that affected the full-time equivalent value, this change would not be reflected in the FTE (%) field. This means that users with the correct permission would then see inaccurate data.

Warning:

In some cases, full-time equivalent or hours can be calculated to be a recurring decimal number. When saving recurring decimal values, some detail is lost due to the way decimals are saved on the Salesforce platform. Making subsequent changes to the hours, full-time equivalent, or recalculating the schedules using the Recalculate Hours action, can result in full-time equivalent and Hours being modified. These changes will be reflected as unsaved changes in the Estimate Builder.

For example, if a role request with a duration of two weeks has 72 available hours (due to having a single day holiday) and the total hours of the request is set to 40, the full-time equivalent will be calculated as 40 / 72 = 55.555555555%.