Pumps

Overview#

This module includes the data models for the pumps industry. It includes Series (For Pumps and Motors), Products, Sites and Installations.

Pumps - Series#

Use this table to record parameters at a higher level, including an Efficiency curve, which is applied to all the pumps linked to this Type.

Fields#

• Type: Select from Pumps or Motors.
• Application: Select from Domestic, Agriculture, Mining and Industrial.
• Category: Lookup varies according to Type selection.
• Plots – Efficiency, Power, NPSH: Applicable to Pumps only. Enter plots for Efficiency, Power Curves and NPSH:
  • Efficiency: X = Flow (m3/hr)
• Flow Range and BPE are populated from the Plots. Flow Range = Lowest and Highest X on the Efficiency Plot. BPE = X linked to the highest efficiency point Y.
• Compatible Motors/Pumps: Use this field to link compatible Motors to Pumps.

Pumps - Products#

Use this table to capture all the products related to Pumps and Motors in the Items module.

Fields#

• Type: Select from Pump, Motor, Pump Unit or Accessory: the other fields are set according to the Type selection.
• Size – Shipping: this is the crated/boxed size of the pump in DxWxL mm.
• Size – Pump/Motor: this is a text field that can be populated as DxWxLmm or, for a submersible pump it could be Lenth x Diameter.

Pumps - Sites#

Use this table to add the data related to a pump site – all the requirements to select the correct Pump and Motor. This data can optionally be used in the pump selection process.

Pump - Installations#

Installations are used for Estimating and let you add a site or just the basic pump requirements if the site information is unavailable. Click the menu button next to the Sites field for options to:

• Edit the selected Site
• Add a new Site
• Update parameters from Site: Copies the pump selection parameters from the site.

When the parameters are entered, a list of suitable pumps and a list of compatible motors linked to the selected pump appear.

Confirm: Click the Confirm button when you are satisfied with your pump and motor selection – this function will add the Pump and Motor to the estimate.

Edit: Click the Edit button to clear the Estimate (Pump and Motor) to change the selection.

Charts#

• Comparison: displays a list of the Flow vs Head curves of all the suitable pumps. The red crosshair shows the required Flow and Head, the red rectangle shows the requirement including margins.
• Pump: Displays all the charts related to the pump.

Data Pipelines for Output from an Estimate#

The Data Pipelines for estimate Output Templates are listed in Output Data Pipelines.

Pump Selection Process#

Pumps can be selected using a filter or by analysing the Flow, Head and Efficiency curves linked to a Pump and Series by setting Select to Filter or Calculate respectively.

Click the Confirm button to add the selected Pump and Motor to the estimate.

Click the Edit button to change the selection.

The Comparison chart only appears when Select = Calculate.

All the charts have a common Y axis, which is the Flow in M3/hr.

The following parameters select a range of suitable pumps.

• Category: Matched to the Series.
• Application: Matched to the Series.
• Flow: Matched to the Series – the search can be widened by adding a percentage tolerance.
• Head: Matched to the pump – the search can be widened by adding a percentage tolerance.

The following parameters select suitable motors for the selected pump.

• Voltage: must be an exact match on the motor.
• P2 Duty Point: Motor must have the same or larger Output than is required by the pump – the first three motors that meet this criterion are selected.
• Suitable Motor: The Motor must be linked in the Pump Series list of suitable motors.

Pump Fields#

• P2 Duty Point (Kw): Selected from the Pump
• Flow (BPE): Selected from the Pump Series in M3/hr
• Efficiency (BPE): Selected from the Pump Series
• Efficiency (Req): Calculated as at the required Head/Flow
• Head (Req): The required Head in metres
• Unit Price: Displayed in local currency – selected from the Item

How to create a Pump Installation Estimate Type#

Navigate to the Estimate Setup module – the menu location could differ according to how the database is set up.

• Create a new Estimate Type, enter a description and set the Status to Active.
• Set the Type = Pumps – Installations.
• Add the Stored Procedure name – EST_PUMP_INSTALL.
• Navigate to the Transaction setup module and add it to the Estimates > Estimate Types collection.

How to add Pumps and Motors (Products) to Items#

General Setting > Default: Use Data Types: Add all the Pump Data Types.

Items > Menu (button) > Edit Categories: Select Input = Pumps – Products.

Tech Spec - Pump Selector Algorithm#

Calculate Min/Max Values

• Required Head: Max = +Tolerance; Min = -Tolerance
• Required Flow: Max = +Tolerance; Min = -Tolerance

First-Round Pump Selection:

• Required Head is inside Min/Max Head of Pump.
• Pump Min Flow is inside Required Min/Max Flow OR Pump Max Flow is inside Required Min/Max Flow.

Calculate Min/Max Efficiency

• Select Max Efficiency linked to pump; Max = +Tolerance; Min = -Tolerance.

Second-Round Test – Iterate all the Pump Flow Plots from Min Flow Req to Max Flow Req and Test:

• Efficiency on Flow point is inside Min/Max Efficiency.
• Head => Flow point is inside Min/Max Head Required.