Pump Sizing and System Characteristic Calculations Using Excels

  Рет қаралды 13,108

Hosey How To Channel

Hosey How To Channel

Күн бұрын

How to determine the pump head required with a given flow using the MS Excels. The calculations combined all the formulas and plot the system curves. You can select a suitable pump to deliver the flow and head to the system with the calculated duty point and plot the pump performance curve and system curve on the same sheet.
كيفية تحديد رأس المضخة المطلوب مع تدفق معين باستخدام MS Excels. جمعت الحسابات جميع الصيغ ورسمت منحنيات النظام. يمكنك اختيار مضخة مناسبة لتوصيل التدفق والتوجه إلى النظام مع نقطة العمل المحسوبة ورسم منحنى أداء المضخة ومنحنى النظام على نفس الورقة.
Comment déterminer la tête de pompe requise avec un débit donné à l’aide du MS Excels. Les calculs combinaient toutes les formules et traçaient les courbes du système. Vous pouvez sélectionner une pompe appropriée pour fournir le débit et la tête au système avec le point de service calculé et tracer la courbe de performance de la pompe et la courbe du système sur la même feuille.
Paano matukoy ang pump head na kinakailangan sa isang naibigay na daloy gamit ang MS Excels. Ang mga kalkulasyon ay pinagsama ang lahat ng mga formula at i plot ang mga curve ng system. Maaari kang pumili ng isang angkop na pump upang maihatid ang daloy at ulo sa system na may kinakalkula na duty point at plot ang curve ng pagganap ng bomba at curve ng system sa parehong sheet.
Hoe de pompkop te bepalen die nodig is met een bepaald debiet met behulp van de MS Excels. De berekeningen combineerden alle formules en plotten de systeemcurven. U kunt een geschikte pomp selecteren om de stroom en kop naar het systeem te brengen met het berekende inschakelpunt en de pompprestatiecurve en systeemcurve op hetzelfde blad uitzetten.
如何使用 MS Excels 确定给定流量所需的泵扬程。计算结合了所有公式并绘制了系统曲线。您可以选择合适的泵来输送流量,并使用计算出的工作点将流量和头部输送到系统,并在同一张纸上绘制泵性能曲线和系统曲线。
So bestimmen Sie den Pumpenkopf, der bei einem bestimmten Durchfluss mit MS Excels erforderlich ist. Die Berechnungen kombinierten alle Formeln und zeichneten die Systemkurven auf. Sie können eine geeignete Pumpe auswählen, um den Durchfluss und die Förderhöhe mit dem berechneten Betriebspunkt an das System zu liefern, und die Pumpenleistungskurve und die Systemkurve auf demselben Blatt darstellen.
एमएस एक्सेल का उपयोग करके दिए गए प्रवाह के साथ आवश्यक पंप हेड कैसे निर्धारित करें। गणना ने सभी सूत्रों को जोड़ा और सिस्टम वक्रों को प्लॉट किया। आप गणना किए गए ड्यूटी बिंदु के साथ सिस्टम में प्रवाह और सिर देने के लिए एक उपयुक्त पंप का चयन कर सकते हैं और एक ही शीट पर पंप प्रदर्शन वक्र और सिस्टम वक्र को प्लॉट कर सकते हैं।
Cara menentukan kepala pompa yang dibutuhkan dengan aliran yang diberikan menggunakan MS Excels. Perhitungan menggabungkan semua rumus dan memplot kurva sistem. Anda dapat memilih pompa yang sesuai untuk mengirimkan aliran dan menuju ke sistem dengan titik tugas yang dihitung dan memplot kurva kinerja pompa dan kurva sistem pada lembar yang sama.
Come determinare la prevalenza della pompa richiesta con un determinato flusso utilizzando MS Excels. I calcoli hanno combinato tutte le formule e tracciato le curve di sistema. È possibile selezionare una pompa adatta per fornire il flusso e la prevalenza al sistema con il punto di lavoro calcolato e tracciare la curva di prestazione della pompa e la curva del sistema sullo stesso foglio.
MS Excelを使用して、特定の流量に必要なポンプヘッドを決定する方法。計算はすべての式を結合し、システム曲線をプロットします。計算されたデューティポイントでシステムに流量とヘッドを供給する適切なポンプを選択し、ポンプ性能曲線とシステム曲線を同じシートにプロットできます。
MS Excels를 사용하여 주어진 유량에 필요한 펌프 헤드를 결정하는 방법. 계산은 모든 공식을 결합하고 시스템 곡선을 플로팅합니다. 계산된 듀티 포인트로 유량과 헤드를 시스템에 전달하는 데 적합한 펌프를 선택하고 펌프 성능 곡선과 시스템 곡선을 동일한 시트에 그릴 수 있습니다.
Как определить требуемый напор насоса с заданным потоком с помощью MS Excels. Расчеты объединили все формулы и построили кривые системы. Вы можете выбрать подходящий насос для подачи потока и головки в систему с расчетной точкой дежурства и построить кривую производительности насоса и кривую системы на одном листе.
Cómo determinar el cabezal de la bomba requerido con un flujo dado utilizando MS Excels. Los cálculos combinaron todas las fórmulas y trazaron las curvas del sistema. Puede seleccionar una bomba adecuada para suministrar el flujo y la cabeza al sistema con el punto de trabajo calculado y trazar la curva de rendimiento de la bomba y la curva del sistema en la misma hoja.
Cách xác định đầu bơm cần thiết với một lưu lượng nhất định bằng MS Excels. Các tính toán kết hợp tất cả các công thức và vẽ các đường cong hệ thống. Bạn có thể chọn một máy bơm phù hợp để cung cấp lưu lượng và hướng đến hệ thống với điểm nhiệm vụ được tính toán và vẽ đường cong hiệu suất bơm và đường cong hệ thống trên cùng một tờ.
Pump Sizing Spreadsheet: www.dropbox.com/scl/fi/alfuip...

Пікірлер: 58
@herobandar8257
@herobandar8257 11 ай бұрын
The best education there is. A university-level standard. Too bad this video didn't exist 10 years ago.
@hoseyhowtochannel8235
@hoseyhowtochannel8235 11 ай бұрын
Thanks for your comments. Great to know that you like it. Please try my other videos!
@skrasel6508
@skrasel6508 9 ай бұрын
Excellent work
@hoseyhowtochannel8235
@hoseyhowtochannel8235 9 ай бұрын
Thanks. Hope you like my other videos!
@arun4846
@arun4846 5 ай бұрын
Superb thanks sir ❤❤❤
@hoseyhowtochannel8235
@hoseyhowtochannel8235 5 ай бұрын
Thanks for your comment. Hope you also like my other videos!
@mysteryjafaro
@mysteryjafaro 3 ай бұрын
This is a great job. Is there a spreadsheet that does the same thing for a branched pipe network with demands instead of a single pipe?
@hoseyhowtochannel8235
@hoseyhowtochannel8235 3 ай бұрын
Please refer to my video "How to create the system characteristic curves for multiple tanks pumping" kzfaq.info/get/bejne/rMmiaJyls5fbfZ8.htmlsi=IFKgFq2UAizCGEQa
@jafarramadan9858
@jafarramadan9858 3 ай бұрын
your are a professional, thanks so much for your helpful video, it was simple to understand, Could your please unprotect your file to do some modifaction realated to my major
@hoseyhowtochannel8235
@hoseyhowtochannel8235 3 ай бұрын
Thanks for your comment. Hope you will like my other videos as well. The spreadsheet is protected to avoid any accidental changes to the formula that causes errors. Hope you can understand!
@mysteryjafaro
@mysteryjafaro 3 ай бұрын
A spreadsheet that does the same thing for an actual water distribution network would be great if available.
@hoseyhowtochannel8235
@hoseyhowtochannel8235 3 ай бұрын
Thanks for the comment. Please refer to my video "How to create System Characteristic Curves for Multilple Tanks Pumping" kzfaq.info/get/bejne/rMmiaJyls5fbfZ8.htmlsi=IFKgFq2UAizCGEQa.
@mysteryjafaro
@mysteryjafaro 3 ай бұрын
@@hoseyhowtochannel8235 Thank you for your prompt response. So, this means that for sizing pumps for a complex system such as a water distribution network where I can specify demands, I should use commercial software such as Water Gems. I was wondering if a spreadsheet is available for such cases.
@hoseyhowtochannel8235
@hoseyhowtochannel8235 3 ай бұрын
@@mysteryjafaro it is recommended to use commercial software to analyze the multiple tanks system as it would be very tedious and complicated if pumping to more than 2 tanks simultaneously.
@bobstevens1332
@bobstevens1332 5 ай бұрын
Fantastic, i have been looking for something like the excel for some time, if possible could i obtain a copy?
@hoseyhowtochannel8235
@hoseyhowtochannel8235 5 ай бұрын
I have shared the spreadsheet in the link at the end of the description.
@jalilalmteen536
@jalilalmteen536 6 ай бұрын
Can we have an example for a calculation for left station serving certain area with known flow
@hoseyhowtochannel8235
@hoseyhowtochannel8235 6 ай бұрын
An area network supply is a very complex and many iterations calculations is required. An engineering software shall be used instead of calculated manually. Hope this addressed your question.
@KhirdAdeed
@KhirdAdeed Жыл бұрын
Nice work mate . Can I get spreadsheet. If it's easy for uou
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
Sure. Please pm your email.
@emmanclaris2307
@emmanclaris2307 Жыл бұрын
​@@hoseyhowtochannel8235hi may i request for the spreadsheet
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
@@emmanclaris2307 I have shared the spreadsheet in the link.
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
I shared the spreadsheet at the bottom of the description. Please check on the link. You need to allow the excel iteration option to enable the calculations.
@user-fk9dj1do6k
@user-fk9dj1do6k Жыл бұрын
Thank you for your interesting video. It was simple to understand. Could you please share your spread sheet Thank you in advance Hassan Berbia
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
Thanks for your comments. Please send me your email for the excelsheet.
@hassanberbia2834
@hassanberbia2834 Жыл бұрын
@@hoseyhowtochannel8235 Dear Sir, Have you received my email address ?
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
@@hassanberbia2834 Hi, I have share the spreadsheet in the link.
@hassanberbia2834
@hassanberbia2834 Жыл бұрын
@@hoseyhowtochannel8235 Thank you Maybe there are some circular references
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
@@hassanberbia2834 Please enable the excel iteration option for the calculations. Hope this help!
@user-xd2eh9oc2z
@user-xd2eh9oc2z 11 ай бұрын
Please make excel sheet for water supply system design to houses
@hoseyhowtochannel8235
@hoseyhowtochannel8235 11 ай бұрын
Thanks for your idea. This will be my future video 😊👍
@user-vl5wk1ol8m
@user-vl5wk1ol8m 11 ай бұрын
please can i get this Excel sheet?
@hoseyhowtochannel8235
@hoseyhowtochannel8235 11 ай бұрын
Please go to the end of the description. A link to the spreadsheet is included. Make sure you have enabled the excel iteration option before running the spreadsheet.
@meenakshiprasadchoudhury1479
@meenakshiprasadchoudhury1479 Жыл бұрын
Hello sir can I get the sheet
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
Sure, please PM your email.
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
I have shared the spreadsheet in the link
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
@@Punith_Gowda Please check the link at the end of the description.
@beldjilalimohamed5230
@beldjilalimohamed5230 5 ай бұрын
Please I need this exel sheet
@hoseyhowtochannel8235
@hoseyhowtochannel8235 5 ай бұрын
The spreadsheet is in the link at the end of the description. Enjoy!
@vondeefelix979
@vondeefelix979 9 ай бұрын
Please can I have the excel spreadsheet
@hoseyhowtochannel8235
@hoseyhowtochannel8235 9 ай бұрын
Please check the link at the end of the description.
@raivenmenes844
@raivenmenes844 Жыл бұрын
Can i have your spreadsheet? Thanks
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
Spreadsheet refers to the link at the end of the description.
@abratm8772
@abratm8772 3 ай бұрын
Thanks for your explanation.. Could u pls inform me the password to unprotect sheet? i would like to do a simulation with your this workbook.. thanks in advance
@hoseyhowtochannel8235
@hoseyhowtochannel8235 3 ай бұрын
Thank you for the comment. The spreadsheet was protected to ensure no error and to avoid any changes by mistake. Hope you understand and appreciate your support!
@amaldhumary
@amaldhumary 9 ай бұрын
Hello dir this is the best education here .could you pls share the password for this excel sheet.
@hoseyhowtochannel8235
@hoseyhowtochannel8235 9 ай бұрын
Hi thanks for your comments. The spreadsheet is protected to avoid any changes to the formula that caused errors. Hope you understood. Cheers!
@rahulsarkar7728
@rahulsarkar7728 4 ай бұрын
Pl share spreadsheet
@hoseyhowtochannel8235
@hoseyhowtochannel8235 4 ай бұрын
The spreadsheet is provided in the link at the end of the description. Enjoy!
@hysiu2002
@hysiu2002 Жыл бұрын
Can I have the spreadsheet? What’s your email?
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
Sure. Please PM your email.
@hysiu2002
@hysiu2002 Жыл бұрын
@@hoseyhowtochannel8235 can I have your email address so that I can PM you?
@hoseyhowtochannel8235
@hoseyhowtochannel8235 Жыл бұрын
I have shared the spreadsheet in the link.
@jeetu319
@jeetu319 2 ай бұрын
This is just literature, no effective information or knowledge transfer.
@hoseyhowtochannel8235
@hoseyhowtochannel8235 2 ай бұрын
Thanks for your comment. Sorry to hear that this video was not effective for you. Hope you will continue to watch my other videos!
Webinar: Pump Curves and Pump Sizing
1:04:39
EECABUSINESS
Рет қаралды 104 М.
Pump Chart Basics Explained - Pump curve HVACR
13:05
The Engineering Mindset
Рет қаралды 1,8 МЛН
Jumping off balcony pulls her tooth! 🫣🦷
01:00
Justin Flom
Рет қаралды 26 МЛН
How Many Balloons Does It Take To Fly?
00:18
MrBeast
Рет қаралды 202 МЛН
Finger Heart - Fancy Refill (Inside Out Animation)
00:30
FASH
Рет қаралды 28 МЛН
How To Read and Understand Pump Datasheet and Curves
9:15
Hosey How To Channel
Рет қаралды 4,4 М.
Sizing a pump formula with an example
11:10
Pdms_piping design
Рет қаралды 95 М.
Pump Selection
10:25
MECH 241 - Fluid Mechanics I
Рет қаралды 32 М.
Process Engineering: Line Sizing
19:31
Kevin Dorma Consulting
Рет қаралды 17 М.
Sizing a sewage pump
14:32
Water Guy
Рет қаралды 4,1 М.
Want to understand pumps? Don't start with pump curves.
7:43
Process with Pat
Рет қаралды 22 М.
Sizing a submersible pump: Some things to know to get it right.
6:03
Irrigear® Independent Experts
Рет қаралды 13 М.
Jumping off balcony pulls her tooth! 🫣🦷
01:00
Justin Flom
Рет қаралды 26 МЛН