FlowThoughts Studio – Pump Performance & Duty Analysis Datasheet Edition

FlowThoughts Studio | Pump Curve & Duty Analysis Tool

A practical Excel-based workflow for centrifugal-pump curve review, duty screening, viscosity correction, motor sizing and operating comparisons.

Turn vendor water-curve data and project requirements into structured engineering outputs using a familiar Excel workflow.

The Pump Curve & Duty Analysis Tool is designed for engineers who need a clear and efficient way to digitise pump curves, evaluate a selected duty point, review key performance indicators and prepare professional datasheets and charts.

What the tool helps you do

• Digitise up to 9 vendor water-curve points
• Generate scaled and viscosity-corrected pump performance curves
• Apply affinity-law scaling for speed, impeller diameter and stage count
• Estimate viscosity-correction factors for preliminary screening
• Evaluate rated duty, BEP location and flow-to-BEP ratio
• Review NPSH margin at the selected rated flow
• Compare calculated NPSHA with the user-entered project value
• Calculate specific speed and suction specific speed using the selected convention
• Review head rise to shut-off, pressure and impeller-diameter checks
• Estimate rated power and end-of-curve power
• Recommend a preliminary motor size using standard motor ratings
• Compare the existing motor rating with the preliminary requirement
• Present minimum-flow, MCSF and preliminary MCTF screening references
• Create clean standard and viscosity-corrected datasheets
• Build a preliminary system curve using pipe, fitting, valve and component losses
• Compare the pump curve with the calculated system curve
• Compare identical pumps operating in series or parallel
• Generate multi-speed pump curves for preliminary variable-speed review

Actual workbook views

The product images show real views from the Excel workbook, including:

• User input and Quick Review workspace
• Head and efficiency performance curve
• Power and NPSHR presentation
• Standard and viscosity-corrected datasheets
• Pump and system-curve comparison
• Series and parallel pump analysis
• Multi-speed pump curves

Included in your download

• Pump Curve & Duty Analysis Tool Excel workbook
• Quick Start Guide in PDF format

Available editions

·        Protected Edition

Designed for everyday engineering use. User input areas are clearly organised, calculation areas are protected, and the workbook is prepared for structured pump screening, curve review and datasheet generation.

·        Unlocked Engineering Edition

Designed for advanced users who want to inspect formulas, review the calculation structure, examine supporting worksheets or adapt the workbook to their engineering workflow.

Who the tool is for

• Rotating equipment engineers
• Mechanical and process engineers
• EPC contractors and engineering consultants
• Pump vendors and OEM review teams
• Maintenance and reliability engineers
• Engineering students learning centrifugal-pump performance
• Professionals performing preliminary pump screening and technical comparisons

Why it is useful

• Reduces repetitive manual curve calculations
• Brings key pump-review checks into one structured workflow
• Supports selectable engineering units
• Produces professional datasheets and performance charts
• Supports water-basis and viscosity-corrected performance review
• Provides clear status indicators for important screening checks
• Requires no macros, add-ins or separate software installation
• Supports project screening, technical comparison and engineering training

Typical applications

• Preliminary centrifugal-pump screening
• Vendor pump-curve digitisation and review
• Rated-duty and BEP-position assessment
• NPSH-margin screening
• Viscous-liquid performance estimation
• Preliminary motor-sizing review
• Speed and impeller-diameter what-if studies
• Multistage pump screening
• Pump and system-curve comparison
• Series and parallel pump comparison
• Variable-speed pump-curve visualisation
• Engineering training and study

Excel compatibility

Designed for Microsoft Excel desktop:

• Microsoft 365 Excel
• Excel 2021
• Excel 2019

No macros or add-ins are required.

Google Sheets is not recommended because workbook formulas, charts, formatting and protected areas may not behave as intended.

Important engineering note

This workbook supports preliminary centrifugal-pump screening, technical review, training and project comparison. It does not provide vendor-certified or guaranteed pump performance.

Viscosity correction, affinity-law scaling, motor sizing, MCSF, MCTF, NPSH, pressure and system-curve outputs are intended as engineering screening references.

Users are responsible for verifying all inputs, assumptions, selected units and calculated outputs. Final pump selection, operating limits, NPSH margin, motor rating and procurement decisions should be confirmed using OEM-certified pump data, the approved project hydraulic basis, applicable engineering standards and final vendor review.

Support

For product-related questions, contact:

·        FlowThoughtsStudio@gmail.com