10. Calculations Tab

10. Calculations Tab

Select the Calculations tab to calculate the material and labor costs associated with a job.

When you calculate a job, the system pulls the appropriate information from various parts of the program and creates all reports.

How Calculations are Generated

You can generate a job calculation as follows:

  1. It is best to calculate the entire project using the Database pricing.

  2. To do so, make sure the button next to Database is selected, and then click 

    .
    The progress of the calculation is illustrated by the blue band that moves across the Calculating Labor and Material Summaries window. (It depends on how fast your computer runs whether or not you see this window.)

The calculation of labor and material estimates is one of the most complex (and important) steps performed by QuoteSoft Pipe. Although it is not essential to understand this process in detail, each step is documented here in order to aid in understanding how the estimates are computed.

The following steps are performed for each Zone included in the calculation to determine material costs and quantities of labor hours:

  1. All Zone takeoff items (from the Takeoff Screen) are sorted and merged into a single list. Common items (such as Pipe, Fittings or Valves) having the same size are combined and quantities are summed up in order to reduce the overall computation time. This is done for each Zone.

  2. Each item in the merged takeoff list from Step #1 is converted into a detail record by pulling information from both the Spec and Database. For instance, if the takeoff item was 1″ 90 Elbow, the system looks in the Spec for that Zone for the Group and Class of fittings in the 1″ size. The information you entered there (such as Wrought/Cast Copper) will be read to locate the exact item from the Database.

  3. Each detail record created in step #1 is processed to determine the total labor hours for each Zone for the active labor source as set up in the Configuration. The Global Labor Discounts are provided for each of four sets of labor factors, so that multiple options of labor factors will be available for the job.

  4. Each detail record created in step #1 is processed to determine the total material cost for each discount set (#1 through #4). Note that the material cost is normally taken from the Database, but quoted costs may also be used.


    When “Quoted” is selected, all Database items are copied to the quoted price list. The system then refers to the quoted price list for all calculations (bypassing any global or job discounts). The quoted price list may then be updated with actual supplier costs in order to compute accurate material costs.

  5. A detail record list is built for each Material Discount Group (Copper Pipe, Steel Pipe…) so that these may be viewed or printed.

Each type of takeoff item in the Takeoff List is converted to a detail record as follows:

 Pipe

Each takeoff item that is Pipe is resolved against the spec to determine the Group and Class of Pipe in this size. This Group and Class are used to locate the specific Database item. The Database information is added to the detail record list. If either AutoJoint or AutoHanger were specified, these are also processed. Quantities are determined by Hanger Spacing and Joint Length in the Spec. These are added to the detail record list (see AutoHanger andAutoJoint on the following pages).

 Fitting

Each takeoff item that is a Fitting is resolved against the spec to determine the Fitting Group and Class for that size. This Group and Class are used to locate the Database item. The Database information for this is added to the detail list. The joints for a fitting are resolved by using the Joint Group and Joint Class fields of the fitting’s Database entry. If these are set to a specific Joint Group and Class, this will be used to determine the type of joint. If these are set to SPEC, then the Joint Group and Joint Class are taken from the Spec for the fitting.

 Valve

Each takeoff item that is a Valve is resolved against the spec to determine the Valve Group, Class, and accessories for that size. This Group and Class are used to locate the Database item. The Database information for the valve (along with all joints) is added to the detail list. (Note that the Joint Group and Class are taken from the Spec definition for fittings of the same size, if they are not specifically defined in the Database). If accessories were defined, these items are also added to the detail list.

 Joint

Each takeoff item that is a Joint is resolved against the spec to determine the Joint Group, Class, and accessories for that size. This Group and Class are used to locate the specific item in the Database. The Database information for the joint is added to the detail list.

 Flange

Each takeoff item that is a Flange is resolved against the Spec to determine the Flange Group, Class, and accessories for that size. The database information for the flange (along with all joints) is added to the detail list. (Note that the Joint Group and Class are taken from the Spec definition for fittings of the same size, if they are not specifically defined in the Database). If accessories were defined, these items are also added to the detail list.

 Specialty

Each takeoff item that is a Specialty is resolved against the spec to determine the specialty Group, Class, and accessories for that size. The Database information for the Specialty (along with all joints) is added to the detail list. (Note that the joint Group and Class are taken from the Spec definition for fittings of the same size, if they are specifically defined in the Database). If accessories were defined, these items are also added to the detail list.

 Hangers

Each takeoff item that is a Hanger is resolved by searching the Spec for the Hanger Form (i.e., Suspended, Base Mount,…) corresponding to the size taken off. Each component, as defined in the Spec, is resolved against the Database based on the component Group.

For components in hanger groups Base Plate, Base Stand, Base Support, Dbl Rod Hanger, Guides/Anchors, Hanger, J-Hooks, Pipe Extension, Saddle Support, and Shield/Saddle, the takeoff size plus insulation thickness (if required by the Spec) is used when searching the Database. In order to assure that an adequate sized hanger component is chosen, the system will select the first Database item that is at least as large as required for the given size. If more than one catalog item has the same size, then the item having a second size at least as large as the pipe size is chosen.

For the remaining hanger groups (such as Rod, Coupling,…) the takeoff size without the insulation thickness is used when searching the Database. Again, in order to assure that an adequate sized hanger component is chosen, the system will select the first Database item that is at least as large as required for a given size.

 AutoJoint

The joints for a Zone of pipe are resolved by using the Joint Group and Joint Class fields of the pipe’s Database entry. If these are set to a valid Joint Group and Class, this will be used to resolve the specific type of joint. If these are set to SPEC, then the Joint Group and Joint Class are taken from the Spec for the pipe. The quantity of Joints is determined from the Joint Length defined in the Spec for this size and length of Pipe. If the joint for a pipe connection is a coupling, which requires joint material for installation, both the coupling and associated joints will be added to the detail list.

 AutoHanger

The AutoHangers for a Zone of pipe are resolved in the same method as normal Hangers (see above), except that the pipe size is used as the takeoff size and the quantity of Hangers is determined from the Hanger Spacing defined in the Spec for this Hanger Size and Hanger Form.

Database Items

When items (not in the Spec) are taken off from the Database, they also are added to the detail list. NO joints associated with these items will be taken off.

Calculate Pricing

Under normal circumstances, you will calculate each job using pricing provided in the Database.

However, if you prefer, QuoteSoft Pipe can also force all items in the job to a Quoted price list that will allow you to enter exact prices from your supplier. To force all items to a Quoted price list, select Quoted (rather than Database). Q = Quoted.

Should you wish to return to Database pricing, click Database and 

.

NOTE: If you typed QUOTED for an item on the Quotes tab, the item will still have Q for Quoted on the Reports tab. To bring in all Database items (not quoted) simply delete all quoted prices under the Quotes tab, select Database pricing, and then recalculate.

If you would like “Some Quoted”, click the circle next to Some Quoted. You will be asked to confirm this change. When you say Yes, a window appears where you can select specific items as Quoted.

Add or remove Material Groups that are set to Quoted.

NOTE: You can also open the “Select Quoted Material Groups” window by clicking “Set Quoted.”

Calculation by Selected Zone

Reports in QuoteSoft Pipe can be calculated for selected Zones within a job. This provides a convenient method of selecting a small group of Zones for calculation.

  1. Go to the Zones tab.

  2. Select (check mark) the desired Zones using the left-hand column of the screen.

  3. Go back to the Reports tab.

  4. Click 

The program will now calculate only the Zones that have check marks on the Zones tab.

Calculate Pattern

Reports in QuoteSoft Pipe can be calculated for the entire job or for any portion of job.

  1. Click on 

    .


    Note that if multiple selections are made within one category (e.g., Specs), all Zones with any of the selected Specs will be included in the calculation. If selections are made across two or more categories, all Zones that satisfy all selected categories will be included in the calculation.

  2. When the selection has been made, click 

    . The program will now calculate only the Zones that meet the selections made.

Material Summary Report

When you click 

 on the Report tab, the Material Summary Report appears.

©2022 ConstructConnect, Inc. All rights reserved.