You can select the following article about pump :

1. Centrifugal Pump

2. Reciprocating Pump



  1. SIR,


    • Hi Varun, Please find calculation sheet for pumps attached. Regards, Jen

  2. Sir,

    pump excel sheet need.

    • Hi Manoj (if I’ve not mistaken), Herewith your file you need. With regards, Jen

  3. please send me PUMP CALCULATION SHEET


    • Dear Sami, Here attached file is centrifugal pump calculation sheet.Is it your need ?

  4. great article…need double acting diaphragm pump calculation


  5. Dear Sir,

    Could you email me the pump calculations sheet in excel format?



    • Hi Santosh, Thank you for your comments in this blog. With regards, Jen

  6. Dear Sir,

    Forgot to mention about reciprocating & centrifugal pumps too.
    Appreciate if you could share those spreadsheet.



  7. Dear Sir ,
    It was nice job you had been done on Calculation Worksheets
    I would line to explore deeply on Calculation sheets
    May I have one copy of ” Reciprocating Pump Calculation Sheets” ?

    Yours Faithfully ,

    • Hello Deden,

      Thank you for the comment. I will send these excel file to you soon.

      With regards,


  8. Dear Jens,
    Received the excel calculation sheets with many thanks. Can you provide the article (.pdf) as well. Having trouble with the download link. Please email at nik_haziq@yahoo.com.my

    Thank you!

    • Hi Nick, herewith the pdf file for reciprocating pump.

      BR, Jen

  9. Dear sir

    I am Vinoth Kumar from India Working as Engineer – Power Projects. I am working for past 2 years in utility works for power projects. I was amazed by seeing your blog. Thanks for sharing the valuable information in word press.it needs lot of time to dedicate on it.

    I am having shell Design Engineering Procedures and Saudi Aramco Engineering Procedures for Process Equipment i can forward to your mail.

    I need a guide sheets for Pumps,Compressor and Turbine in excel sheets. pls send it to vinoth.s@hotmail.com



  10. Dear sir,

    please send me calculation sheets in excel at chemi655@gmail.com


    • OK Khalid,

      Thanks for visiting.

  11. Thank you sir, i am waiting

  12. please send me the calcs in excel afze007@gmail.com

    • Hi Ashwin, files will be sent to you.


  13. Hi Pak Jen,

    Some with compressor, could you send me the calculation sheet (excel) of centrifugal pump? My email is sepbowo@gmail.com.

    Thank you pak

    • Dear Bowo, Files has been sent to you (for both type of compressor). Sorry for late reply. BR, Jen


  14. Very appreciate for the excel sir.
    Just my two cent, why don’t you calculate the linear velocity of fluida in suction and discharge pipe? I think we should consider the velocity, if I’m not mistaken it should have a range 1-3 ft/s at suction, and 6-9 ft/s at discharge pump (for water case).

    Thank you

    • Dear Sepbowo, Actually suction velocity has been considered in velocity head in line no. 21 based on input data of flow, SG and suction diameter in line no. 14 and 20. Equation is written in last column (Formula).


      • Halo Pak Jen,

        I mean, it’s better if we consider the velocity given by the pipe diameter we used. For example, in API14E, the velocity at suction is 2-3 ft/s or 6-9 ft/s at discharge pipe (not written as velocity head). I think it is easier to adjust the pipe diameter whether it’s too small or too big if we know the linear velocity resulted.

        Thank you very much pak.

      • Dear Sepbowo, Thank you for the feed back. We can modify the calculation in the next revision. Best regards, Jen


      • Dear Sepbowo, Kindly please find attached revised pump calculation sheet where has consider suction nozzle size selection and velocity. At same time some worksheets are added in this file for more detail and background for estimating efficiency, NPSHR and image of pump impeller. Best regards, Jen


  15. good article. please send me calculation sheets in excel at joesas74@yahoo.com

    thank you


    • Dear Johan, The file will be sent to you. Calculation sheets has been improved from the original that has shown in the blog. Thank you for your comment. Jen


  16. Dear Sir

    If you can send me the Centrifugal pump calculation at somen_m@yahoo.com

  17. Can you please send the Excel sheets for Both centrifugal & reciprocating pumps ?

    mail id- cpsatav@gmail.com

  18. Please send me the calculation and data sheets for Pumps and Compressors in Excel. These are excellent.

    • OK Bruce. From: Mechanical Engineering in Process Equipments To: jen_sapardi@yahoo.com Sent: Wednesday, December 9, 2015 1:38 AM Subject: [Mechanical Engineering in Process Equipments] Comment: “Pump” #yiv4655365574 a:hover {color:red;}#yiv4655365574 a {text-decoration:none;color:#0088cc;}#yiv4655365574 a.yiv4655365574primaryactionlink:link, #yiv4655365574 a.yiv4655365574primaryactionlink:visited {background-color:#2585B2;color:#fff;}#yiv4655365574 a.yiv4655365574primaryactionlink:hover, #yiv4655365574 a.yiv4655365574primaryactionlink:active {background-color:#11729E;color:#fff;}#yiv4655365574 WordPress.com | | |

      • Hi Jen,

        Many thanks for sending me the calculation sheets.

        Kind regards

        Bruce Quare
        Associate Professor Chemical & Environmental Engineering
        The University of Nottingham

  19. Really good post. Please send me excel sheet at gwangyu.roh@gmail.com
    Thanks in advance.

  20. Dear Jen,
    Could you please send me the spreadsheet?
    my email is abuhafsh007@gmail.com

    thanks for your sharing.


  21. Dear Jen,
    Great work – please send me the reciprocating pump calculation sheets.

  22. Hi Hen,
    Could you please share the Pump calculations sheets in Excel Format
    Thanks in advance.

    Best Regards,

  23. Hi Jen,

    Very nice calculation sheet. Can you please send me the excel version of the centrifugal pump calculation sheet? You compressor calculation sheets are also very impressive if you could share those as well.

    Thank you in advance,


    • Dear Mike, sorry for very late reply. Calculation sheets have been sent. With regards,Jen

      From: Mechanical Engineering in Process Equipments To: jen_sapardi@yahoo.com Sent: Wednesday, October 18, 2017 3:21 AM Subject: [Mechanical Engineering in Process Equipments] Comment: “Pump” #yiv4238242236 a:hover {color:red;}#yiv4238242236 a {text-decoration:none;color:#0088cc;}#yiv4238242236 a.yiv4238242236primaryactionlink:link, #yiv4238242236 a.yiv4238242236primaryactionlink:visited {background-color:#2585B2;color:#fff;}#yiv4238242236 a.yiv4238242236primaryactionlink:hover, #yiv4238242236 a.yiv4238242236primaryactionlink:active {background-color:#11729E;color:#fff;}#yiv4238242236 WordPress.com | | |

  24. Hi sir,

    i’m a new engineer in plant business and i need your centrifugal pump excel sheet to gorw up my ability. actually for my study.
    could you send me a your good work? (Centrifugal sheet)

    i’m look foward to here form you.

    thank you.

  25. Good articles about pump and compressor. Could you please send the spreadsheets of pumps, compressor and turbines to my email id. gm_santosh83@yahoo.co.in

    • Mr. Jen,

      Thanks for sending the spread sheets. it is very much helpful in sizing of these equipment in my job assignments.

      Santoshkumar Muthukrishnan

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: