Api 610 12th Edition Data Sheet Excel Today
The API 610 12th Edition (ISO 13709) data sheet in Excel is the de facto standard document for specifying centrifugal pumps for petroleum, petrochemical, and heavy-duty industrial services. Unlike a simple "fill-in-the-blanks" form, this Excel sheet functions as a dynamic engineering contract. It defines hydraulic, mechanical, material, testing, and auxiliary system requirements. Errors or omissions in this file directly correlate to 70%+ of field failures and commercial disputes.
This report dissects the logical architecture, key tabs, critical data fields, interdependencies, and risk areas within the API 610 12th Edition Excel data sheet.
Even experienced engineers make these mistakes:
The API 610 12th Edition (released January 2021) introduced a standardized Excel-based data sheet (found in Annex N) to streamline procurement and minimize data entry errors. This template uses a specific color-coded system to define responsibilities between the purchaser and the vendor. 1. Responsibility Color Codes
The 12th Edition data sheet uses the following legend to ensure clear ownership of every data field:
Black Text: To be completed by the Purchaser (Initial requirements).
Blue Text: To be completed by the Vendor/Supplier (Technical proposal data).
Red Text: Can be completed by either party (Negotiable or optional fields). Api 610 12th Edition Data Sheet Excel
Green Cells: Feature drop-down menus to ensure consistent terminology for items like material classes or pump types. 2. Essential Data Sheet Sections
A complete data sheet typically spans multiple tabs or pages, organized as follows:
General Information: Job number, item/tag number, service description, and site conditions (ambient temperature, altitude). Operating Conditions:
Normal vs. Rated: You must now provide both normal and rated conditions for process fluid properties to ensure the vendor selects the most efficient pump.
Alternate Operating Points: The 12th edition allows for three additional points (e.g., for different liquids or flush fluids).
NPSH Available: The purchaser must specify NPSHA; note that for vertical pumps, the datum point is now the impeller suction eye.
Liquid Characteristics: Fluid name, temperature, vapor pressure, specific gravity, and viscosity at various operating points. The API 610 12th Edition (ISO 13709) data
Performance Data: Includes efficiency, absorbed power, and the Allowable Operating Region (AOR).
Note: Performance tests now require 9 points instead of 6 (see section 4 below).
Construction Materials: Specify the Material Class (e.g., S-5, S-6, C-6). The 12th edition removed several older classes like I-1 and I-2.
Mechanical Seals & Systems: Reference API 682 for the seal plan, buffer/flush fluid details, and cooling requirements.
Driver Details: Motor power, voltage, speed, and whether an Adjustable Speed Drive (ASD) is used. 3. Key 12th Edition Changes to Data Fields
Key updates in the 12th edition affecting data entry include:
Design Life: Replaced the 20-year mandatory requirement with a requirement to identify finite-life components. Even experienced engineers make these mistakes: The API
Parallel Operation: Head requirements tightened for discharge nozzles >80mm (3").
Safety Features: Mandatory shaft guards allowing inspection of the seal.
Baseplates: Updated requirements for sloped decks and minimum drain connection sizes. 4. Performance Test Requirements
The 12th edition mandates a 9-point performance test (compared to the previous 6-point) to ensure pump performance across a wider operating range. How to Obtain the Official Excel Template
The official Excel spreadsheets are provided by the American Petroleum Institute (API) as part of the standard's purchase or via authorized vendors like Accuris Standards Store. API 610 12th Edition - Amarinth
Even with a perfect template, human error is the enemy. Avoid these three traps:
If you enter Differential Pressure (psi) instead of Differential Head (feet), but forget to update the specific gravity cell, the motor sizing will be dangerously wrong. Rule: Always specify Head (ft or m) because head is independent of fluid density; pressure is not.
| Error | Consequence | Mitigation | |-------|-------------|-------------| | Leaving "Pump type" blank | Vendor quotes OH2 by default, but site needs VS6 | Mandatory dropdown with images | | Mismatch between rated head and BEP | High vibration, bearing failures | Add BEP % field with auto-warning if >10% from rated | | No driver service factor | Motor under-sized for cold start or high SG | Auto-calc: Power = (Q×H×SG)/(367×η) × 1.1 | | Missing API 682 piping plan | Seal fails in 3 months instead of 3 years | Link seal type to plan table | | Ignoring nozzle load table | Casing distortion, seal leakage | Prefill with API minimum, require vendor recalculation |
Real-world data: >60% of RFQ disputes originate from incomplete or contradictory entries in the API 610 Excel data sheet.
