Api 610 12th Edition Data Sheet Excel [FREE]
The 12th edition works in SI units (meters, kPa, °C) but many US vendors still think in imperial (feet, psi, °F). Never hide the units row. Use Excel’s CONVERT function to show both.
If you are migrating from the 11th Edition, your Excel data sheet must account for these updates:
| Feature | Benefit | |---------|---------| | Drop-downs for API 610 material classes | Prevents misspelling (e.g., "S6" instead of "S-6") | | Automatic NPSHa margin calculation | Eliminates arithmetic errors | | Pump type selector with visual icons | Reduces misunderstanding between OH2 and BB3 | | Motor power auto-calc with safety factor | Ensures no under-sizing | | Link to API 682 seal plan database | Suggests Plan 11, 21, 23 based on temp/pressure | | Export to JSON/XML for PLM integration | Enables automated procurement systems | Api 610 12th Edition Data Sheet Excel
If you are still using an Excel template based on the 11th or 10th edition, you are introducing risk. The 12th edition introduced several key changes that must be reflected in your columns and checkboxes:
The API 610 12th Edition (Centrifugal Pumps for Petroleum, Petrochemical, and Natural Gas Industries) data sheet in Excel serves as a standardized, machine-readable template for: The 12th edition works in SI units (meters,
Using an Excel version allows easy calculations, drop-down lists for compliance options, and integration with procurement systems.
The requirements for bearing life (L10) have been updated. The data sheet now has specific fields to designate the required bearing life for different pump configurations (OH, BB, VS types), often requiring greater than 25,000 hours for critical services. If you are still using an Excel template
A compliant API 610 Excel data sheet typically contains 9–12 tabs, though custom versions exist. The standard logical flow is:
| Tab Name | Purpose | Criticality | |----------|---------|--------------| | Instruction / Notes | Defines units, abbreviations, and completion rules | High (often ignored → errors) | | Hydraulic Data | Flow, head, NPSHa, specific gravity, viscosity, operating range | Critical | | Mechanical Data | Casing type, shaft seal, bearings, materials, nozzle loads | Critical | | Driver Data | Motor/turbine/engine specs, enclosure, efficiency, hazardous area | High | | Materials of Construction | Wetted parts, casing, impeller, shaft, rings (per API 610 material classes) | Critical | | Auxiliary Systems | Piping plans (API 682), cooling, flushing, seal support systems | High | | Testing & Inspection | Hydrostatic, performance, NPSHr, mechanical run, witness points | High | | Vendor Data Requirements | Curves, GA drawings, QAP, MDR | Medium | | Spare Parts | Recommended spares, criticality classification | Medium | | Purchaser / Vendor Comments | Deviations, clarifications | Legal |
Key observation: The Excel sheet is not linear — data in one tab triggers requirements in others (e.g., specific gravity in Hydraulic tab affects seal selection in Auxiliary Systems tab).