Api 610 12th Edition Data Sheet Excel Updated [4K 2025]

The API 610 12th Edition Data Sheet in Excel format is more than just a document; it’s the primary interface for digital technical procurement in the oil and gas industry. Released in January 2021, the 12th edition updates critical parameters for centrifugal pumps to align with modern reliability and safety standards. Key Features of the 12th Edition Excel Data Sheet

Tab 1: Header & General Information (POO – Purchase Order Outline)

Project name & number
Pump tag number (e.g., P-101A/B)
Service description (e.g., "Lean Amine Charge")
Quantity (duty + standby)
Driver type (electric motor, steam turbine, engine)

Tab 2: Performance Guarantees

Capacity (m³/h or GPM): Rated and Normal.
Differential Head (m or ft): Specific gravity corrected.
NPSHa (Available): The vendor needs this to calculate NPSHr (Required). Include a margin of +3 ft (1m) or +3 psi.
Driver Details: Motor kW, voltage, frequency, or turbine data.

Green: Cells with drop-down menus for consistent data entry. Black: Fields to be completed by the purchaser. Blue: Fields for the supplier (vendor) to complete. Red: Fields that can be filled by either party. Api 610 12th Edition Data Sheet Excel

Recommendation

✅ Use it – but only if:

Blue Text: Information provided by the vendor during the proposal phase. Critical Review of Data Sheet Changes The API 610 12th Edition Data Sheet in

3. Critical Data Field Deep Dive

3.1 Hydraulic Tab – The Performance Basis

Rated flow (m³/h or gpm): Must not be at end-of-curve. API 610 requires rated point to be between BEP and 110% of BEP for OH/BB/VS types.
Rated head (m or ft): Head at rated flow. Should not exceed 105% of BEP head.
Normal flow vs. Rated flow: Confusion here leads to oversized motors or cavitation.
NPSHa (m): Must be ≥ NPSHr + margin (typically 1 m for hydrocarbons, 3 m for water). Excel sheets without NPSHa margin calculation cause cavitation.
Specific gravity (SG): Drives impeller diameter, motor power, and casing pressure rating. A 0.5 SG error can undersize a motor by 40%.
Viscosity (cSt): >50 cSt requires hydraulic correction (HI method). Most Excel sheets lack an automatic viscosity correction → major error source.

: For pumps with discharge nozzles larger than 3 inches (80 mm), head values must now be within 3% of each other in the preferred operating region. NPSH Datum Point Project name & number Pump tag number (e

Streamlined data entry: Organized layout for easy data input
Automatic calculations: Formulas for calculating performance parameters, such as flow rate and head
Material selection: Dropdown menus for selecting construction materials
Testing and inspection: Checklist for testing and inspection requirements

3. Critical Data Field Deep Dive

3.1 Hydraulic Tab – The Performance Basis

Rated flow (m³/h or gpm): Must not be at end-of-curve. API 610 requires rated point to be between BEP and 110% of BEP for OH/BB/VS types.

Rated head (m or ft): Head at rated flow. Should not exceed 105% of BEP head.

Normal flow vs. Rated flow: Confusion here leads to oversized motors or cavitation.

NPSHa (m): Must be ≥ NPSHr + margin (typically 1 m for hydrocarbons, 3 m for water). Excel sheets without NPSHa margin calculation cause cavitation.

Specific gravity (SG): Drives impeller diameter, motor power, and casing pressure rating. A 0.5 SG error can undersize a motor by 40%.

Viscosity (cSt): >50 cSt requires hydraulic correction (HI method). Most Excel sheets lack an automatic viscosity correction → major error source.

: For pumps with discharge nozzles larger than 3 inches (80 mm), head values must now be within 3% of each other in the preferred operating region. NPSH Datum Point

Streamlined data entry: Organized layout for easy data input

Automatic calculations: Formulas for calculating performance parameters, such as flow rate and head

Material selection: Dropdown menus for selecting construction materials

Testing and inspection: Checklist for testing and inspection requirements