{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["rev block","NPSH","NPIP SUCTION RESULTS","DISCHARGE RESULTS","Directions & Training"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"rev block","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,3,2,4]]}
[]
[null,null,null,"MILTON ROY L.L.C.  PUMP SYSTEM ANALYSIS TOOL"]
[null,null,"Doc  No.: ",51518,null,"Rev #:","A"]
[]
[]
[null,null,"Revision History: "]
[]
[null,null,"Rev","Date","Brief description of change","Worksheets","Cells","Author"]
[null,null,"A","2013-06-30","Initial Release, added MBP & MCP,  ECN  #  16347 ","All","All","Glenn Smith"]

{"sheet":"NPSH","index":1,"n_rows":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Pressure Drops at Peak Flow"]
[]
[]
["Pressure drop due to acceleration "]
[]
[null,"dP = [NQ(S.G.)Lp]/[2.77x10^4(Dp^2)]"]
[]
[null,"dP (Press Drop)",null,"N (SPM) ","Q (GPH)","S.G.","Lp (Pipe Length)","Dp (Pipe ID)","Atm. Press (psia)","Tank Level","Head Press. (PSIA)","Static PSI"]
[null,{"$f":"(D9*E9*F9*G9)/(27700*H9^2)","v":1.4763243003796742},null,{"$f":"'NPIP SUCTION RESULTS'!G42","v":45},{"$f":"'NPIP SUCTION RESULTS'!D42","v":50},{"$f":"'NPIP SUCTION RESULTS'!$G$26","v":1},{"$f":"'NPIP SUCTION RESULTS'!F56","v":20},{"$f":"'NPIP SUCTION RESULTS'!F55","v":1.0489999999999999},{"$f":"SUM(14.7,('NPIP SUCTION RESULTS'!$F$30*-0.3048*0.01450377/8))","v":14.7},{"$f":"'NPIP SUCTION RESULTS'!I32","v":0},{"$f":"(62.4/144)*F9*J9+I9+I12-J12","v":14.5549623},{"$f":"K9-I9-I12","v":-0.1450376999999996}]
[null,0,null,{"$f":"D9","v":45},{"$f":"E9","v":50},{"$f":"F9","v":1},0,{"$f":"'NPIP SUCTION RESULTS'!F55","v":1.0489999999999999}]
[null,0,null,{"$f":"D9","v":45},{"$f":"E9","v":50},{"$f":"F9","v":1},{"$f":"'NPIP SUCTION RESULTS'!H56","v":0},{"$f":"'NPIP SUCTION RESULTS'!H55","v":1.0489999999999999},"Tank Press (psig)","Vapor pressure","Elevation Loss"]
[null,0,null,{"$f":"D9","v":45},{"$f":"E9","v":50},{"$f":"F9","v":1},0,{"$f":"'NPIP SUCTION RESULTS'!H55","v":1.0489999999999999},{"$f":"'NPIP SUCTION RESULTS'!F28","v":0},{"$f":"'NPIP SUCTION RESULTS'!E26","v":0.14503769999999999},{"$f":"(62/144)*F9*J12+I9","v":14.7624467875}]
[null,0,null,{"$f":"D9","v":45},{"$f":"E9","v":50},{"$f":"F9","v":1},{"$f":"'NPIP SUCTION RESULTS'!J56","v":0},{"$f":"'NPIP SUCTION RESULTS'!J55","v":0.74199999999999999}]
[null,0,null,{"$f":"D9","v":45},{"$f":"E9","v":50},{"$f":"F9","v":1},0,{"$f":"'NPIP SUCTION RESULTS'!J55","v":0.74199999999999999}]
["Single Suction Check Valve Viscous Loss"]
[]
[null,"dP = 0.7(0.0000414U^0.9Q^1.1)/(Ds^3.1)"]
[]
[null,"dP (Press Drop)",null,"U (centipoise)","Q (GPH)","Number of Seats","Ds (Seat Dia.)",null,null,"Accel Losses","Frictional Losses"]
[null,{"$f":"0.7*(0.0000414)*(D20^0.9)*(E20^1.1)/(G20^3.1)*F20","v":0.10725744214520058},null,{"$f":"'NPIP SUCTION RESULTS'!H26","v":1},{"$f":"E9","v":50},{"$f":"'NPIP SUCTION RESULTS'!M42","v":1},{"$f":"INDEX('NPIP SUCTION RESULTS'!$AM$105:$AM$195,'NPIP SUCTION RESULTS'!$D$38)","v":0.28299999999999997},null,"Head (PSIA)",{"$f":"K9","v":14.5549623},{"$f":"K9","v":14.5549623}]
[null,null,null,".",null,null,null,null,"Acceleration",{"$f":"B9+B11+B13","v":1.4763243003796742},0]
[null,null,null,null,null,null,null,null,"Check Valve",0,{"$f":"B20","v":0.10725744214520058}]
["Contour Plate Viscous Loss - Non HPD pumps",null,null,null,null,null,null,null,"Contour Plate",0,{"$f":"$B$28","v":2.1854945148746762E-6}]
[null,null,null,null,null,null,null,null,"Friction",0,{"$f":"SUM(B35:B40)","v":1.1809569998641764E-2}]
[null,"dP = (0.00000434Q^1.1U^0.9)/(N^1.1Dh^3.1)",null,null,null,null,null,null,"Head Press (PSIA)",{"$f":"J20-J21-J22-J23","v":13.078637999620325},{"$f":"K20-K22-K23-K24","v":14.435893102361643}]
[]
[null,"dP (Press Drop)",null,"Q (GPH)","U (centipoise)","# of holes","Dh (hole dia.)"]
[null,{"$f":"(0.00000434*D28^1.1*E28^0.9)/(F28^1.1*G28^3.1)","v":2.1854945148746762E-6},null,{"$f":"E9","v":50},{"$f":"D20","v":1},{"$f":"INDEX('NPIP SUCTION RESULTS'!$BB$105:$BB$195,'NPIP SUCTION RESULTS'!$D$38)","v":1},{"$f":"INDEX('NPIP SUCTION RESULTS'!$BE$105:$BE$195,'NPIP SUCTION RESULTS'!$D$38)","v":5}]
[null,null,null,null,null,null,null,null,"k factor=",{"$f":"((4*(K24^2))+(J21^2))/(4*K24*J21)","v":31.260710043028052},"dosapro's method - don't use"]
["Pipeline Friction",null,null,null,null,null,null,null,"Total loss = ",{"$f":"J29*J21","v":46.150945883645242}]
[]
[null,"dP = (0.0000143QULp)/(Dp^4)",null,null,null,null,null,null,"sqrt sum squares",{"$f":"SQRT(J21^2+K24^2)","v":1.4763715338068151},"use this"]
[]
[null,"dP (Press Drop)",null,"Q (GPH)","U (centipoise)","Lp (Pipe Length)","Dp (Pipe ID)"]
[null,{"$f":"0.0000143*D35*E35*F35/G35^4","v":1.1809569998641764E-2},null,{"$f":"$D$28","v":50},{"$f":"$E$28","v":1},{"$f":"G9","v":20},1.0489999999999999]
[null,0,null,50,1,{"$f":"'NPIP SUCTION RESULTS'!$F$67","v":0},1.0489999999999999]
[null,0,null,50,1,0,1.0489999999999999]
[null,0,null,50,1,{"$f":"'NPIP SUCTION RESULTS'!$H$67","v":0},1.0489999999999999]
[null,0,null,50,1,{"$f":"G13","v":0},{"$f":"H13","v":0.74199999999999999}]
[null,0,null,50,1,{"$f":"'NPIP SUCTION RESULTS'!$J$67","v":0},{"$f":"H14","v":0.74199999999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TAYA TO CONFIRM THESE FOR DURAMETER"]

{"sheet":"NPIP SUCTION RESULTS","index":2,"n_rows":195,"n_cols":57,"rows_kept":195,"cut":false,"hidden":false,"merged":[[37,9,38,9],[37,10,38,13],[22,9,22,10],[24,4,24,5],[25,4,25,5],[24,7,24,8],[9,11,9,12],[103,53,103,55],[103,56,103,58],[103,42,103,44],[103,49,103,50],[103,33,103,36],[103,38,103,39],[103,40,103,41],[11,18,13,27],[103,51,103,52],[87,7,87,12],[82,7,82,12],[78,7,78,12],[81,7,81,12],[18,18,18,19],[67,24,67,26],[0,13,0,14],[3,1,3,14],[4,2,6,14],[0,11,0,12],[1,13,1,14],[0,1,1,8],[2,1,2,15],[9,5,9,6],[9,7,9,8],[9,9,9,10],[57,2,57,4],[58,2,58,4],[56,2,56,4],[49,2,49,14],[16,4,16,9],[16,11,16,14],[18,4,18,14],[25,13,25,14],[37,3,38,6],[40,6,40,7],[40,3,40,4],[40,9,40,10],[40,12,40,14],[96,1,96,14],[72,2,72,8],[72,9,72,10],[76,7,76,12],[77,7,77,12],[75,2,75,12],[86,1,86,6],[89,1,93,14],[87,1,87,6],[86,7,86,12],[79,7,79,12],[80,7,80,12],[70,2,70,4],[59,2,59,4],[60,2,60,4],[61,2,61,4],[62,2,62,4],[63,2,63,4],[66,2,66,4],[64,2,64,4],[67,2,67,4],[68,2,68,4],[69,2,69,4],[54,11,55,13],[52,2,52,4],[53,2,53,4],[22,2,22,3],[11,10,14,14],[54,2,54,4],[55,2,55,4],[22,11,22,14],[25,7,25,8],[24,10,24,11],[24,13,24,14],[25,10,25,11],[46,3,46,6],[51,2,51,4],[31,2,34,4],[22,4,22,8]]}
[null,null,null,null,null,null,null,null,null,null,null,"Document:",null,{"$f":"'rev block'!D3","v":51518}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Revision:",{"$f":"'rev block'!G3","v":"A"}]
[null,"   PUMP SYSTEM ANALYSIS TOOL -SUCTION CONDITIONS"]
[null,"        Net Positive Inlet Pressure Calculator for 1 Tank to 1 Metering Pump "]
[null,null,"Calculations used in this program are based on a combination of theoritical anaylses and results of extensive fluids laboratory testing.  Because of simplifying assumptions made in equations, variations in chemical properties, variations in pipe characteristics, and other factors, Milton Roy L.L.C. cannot accept any responsibility for usefulness of calculated results.  The user is cautioned to verify results from this program with independent methods.  This calculator is applicable only for Milton Roy motor driven hydraulic or mechanical actuated diaphram or packed plunger pumps.   \nDO NOT USE THIS CALCULATOR  FOR ANY SOLENOID DRIVEN OR AIR-DRIVEN METERING PUMPS.   "]
[]
[]
[]
[null,"NOTES and COLOR KEY"]
[null,null,"▪","Cell Color Key:",null,"Required Data",null,"Optional Data",null,"Calculated Data",null,"Final Results Data"]
[null,null,"▪","All pressures are in psia as indicated"]
[null,null,"▪","All flow rates are in gallons per hour",null,null,null,null,null,null,"Note: Be sure all data from previous calculations has been cleared before starting each new calculation."]
[null,null,"▪","Lengths and height are in feet"]
[null,null,"▪","Pipe Diameters are in inches."]
[]
[null,"PROJECT DATA"]
[null,null,null,"Project Name:","NPSH CALC FOR  ??? PUMPS",null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2020-06-04"}]
[]
[null,null,null,"Prepared by: ","ENTER YOUR NAME"]
[]
[null,"CHEMICAL and SITE DATA"]
[]
[null,"1.","Select Chemical here:\n(based on 72° F)",null,68,null,null,null,null,"OR   Enter chemical     \nname here:  "]
[null,null,null,null,null,null,null,null,null,null,"Enter alternate values below based on  fluid temperature"]
[null,null,null,null,"Vapor Pressure psia:",null,"S.G.:","Viscosity cps:",null,null,"Vapor Pressure psia:",null,"S.G.:","Viscosity cps:"]
[null,null,null,null,{"$f":"IF($K$26>0,$K$26,INDEX($Z108:$Z178,$E$23)*14.50377)","v":0.14503769999999999},null,{"$f":"IF($M$26>0,$M$26,INDEX($Y108:$Y178,$E$23))","v":1},{"$f":"IF($N$26>0,$N$26,INDEX($AA108:$AA178,$E$23))","v":1}]
[]
[null,"2.","Enter tank or suction pressure:",null,null,0,"psig (enter \"0\" if atmospheric)"]
[]
[null,"3.","Enter elevation above sea level:",null,null,0,"feet"]
[]
[null,"4.","Enter the fluid height difference between tank outlet pipe elevation and pump centerline elevation\n(USE NEGATIVE NUMBER IF TANK OUTLET IS BELOW PUMP CENTERLINE):",null,null,null,null,"∆ H =",0,"feet"]
[null,null,null,null,null,null,null,"Fluid lift condtion",{"$f":"IF($I$32<0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Flooded suction",{"$f":"IF($I$32>=0,\"X\",\"\")","v":"X"}]
[]
[null,"5.    ENTER PUMP DATA"]
[null,null,null,"Select pump product:",null,null,null,null,null,"Number of Pump Heads: "]
[null,null,null,1,null,null,null,null,null,1,"IF SIMPLEX PUMP - ENTER 1, DUPLEX PUMP - ENTER 2, TRIPLEX PUMP - ENTER 3 \n (REMEMBER TO USE TOTAL FLOWRATE)"]
[]
[]
[null,null,null,"Total  pump flowrate:",null,null,"Pump stroke speed:",null,null,"Plunger diameter:",null,null,"Number of check valve seats:"]
[null,null,null,50,"GPH",null,45,"SPM",null,null,"inches",null,1,"  per head"]
[]
[null,null,null,"Minimum Allowable Inlet Pressure in liquid end for pump selected: ",null,null,null,null,null,null,{"$f":"INDEX($AL$105:$AL$195,$D$38)","v":3},"PSIA"]
[]
[null,null,"Note: The minimum allowable inlet pressure for each pump has a safety factor built in. Should you choose to add additional safety factor, "]
[null,null,null,"enter the amount of factor in psia here:",null,null,null,0,"  Be sure to enter 0 if no additional safety factor is required."]
[]
[null,"6.     ENTER SUCTION SIDE PIPING PARAMETERS"]
[null,null,"The calculator allows data to be entered for up to 3 different sections of suction pipe. This is important if pipe diameter changes between the tank and the pump. When not used or not applicable, enter \"0\" in the cell."]
[]
[null,null,"Description",null,null,"Section 1",null,"Section 2",null,"Section 3"]
[null,null,"Select Pipe Schedule:",null,null,1,null,1,null,2]
[null,null,"Select Pipe Size",null,null,5,null,5,null,4]
[null,null,"Calculated pipe ID inches",null,null,{"$f":"IF(F53=1,INDEX($U$108:$U$129,F54),IF(F53=2,INDEX($T$108:$T$129,F54),IF(F53=3,INDEX($V$108:$V$129,F54))))","v":1.0489999999999999},null,{"$f":"IF(H53=1,INDEX($U$108:$U$129,H54),IF(H53=2,INDEX($T$108:$T$129,H54),IF(H53=3,INDEX($V$108:$V$129,H54))))","v":1.0489999999999999},null,{"$f":"IF(J53=1,INDEX($U$108:$U$129,J54),IF(J53=2,INDEX($T$108:$T$129,J54),IF(J53=3,INDEX($V$108:$V$129,J54))))","v":0.74199999999999999},null,"Calculation Fields - do not change"]
[null,null,"Enter pipe actual length",null,null,20,"feet",0,"feet",0,"feet"]
[null,null,"# of 90°  elbows",null,null,0,null,0,null,0,null,{"$f":"SUM(30*F$55/12)*F57","v":0},{"$f":"SUM(30*H$55/12)*H57","v":0},{"$f":"SUM(30*J$55/12)*J57","v":0}]
[null,null,"# of 45°  elbows",null,null,0,null,0,null,0,null,{"$f":"SUM(16*F$55/12)*F58","v":0},{"$f":"SUM(16*H$55/12)*H58","v":0},{"$f":"SUM(16*J$55/12)*J58","v":0}]
[null,null,"Foot Valve",null,null,0,null,0,null,0,null,{"$f":"SUM(420*F$55/12)*F59","v":0},{"$f":"SUM(420*H$55/12)*H59","v":0},{"$f":"SUM(420*J$55/12)*J59","v":0}]
[null,null,"# of external ball check valves",null,null,0,null,0,null,0,null,{"$f":"SUM(150*F$55/12)*F60","v":0},{"$f":"SUM(150*H$55/12)*H60","v":0},{"$f":"SUM(150*J$55/12)*J60","v":0}]
[null,null,"# of tees - run flow",null,null,0,null,0,null,0,null,{"$f":"SUM(20*F$55/12)*F61","v":0},{"$f":"SUM(20*H$55/12)*H61","v":0},{"$f":"SUM(20*J$55/12)*J61","v":0}]
[null,null,"# of tees - branch flow",null,null,0,null,0,null,0,null,{"$f":"SUM(60*F$55/12)*F62","v":0},{"$f":"SUM(60*H$55/12)*H62","v":0},{"$f":"SUM(60*J$55/12)*J62","v":0}]
[null,null,"# of single reduction reducer bushings",null,null,0,null,0,null,0,null,{"$f":"SUM(15.5*F$55/12)*F63","v":0},{"$f":"SUM(15.5*H$55/12)*H63","v":0},{"$f":"SUM(15.5*J$55/12)*J63","v":0}]
[null,null,"# of Strainers or Valves",null,null,0,null,0,null,0,null,{"$f":"SUM((($D$42/60)*27700*(F$55^2))/((F$65^2)*$G$42*$G$26)*F$64)","v":0},{"$f":"SUM((($D$42/60)*27700*(H$55^2))/((H$65^2)*$G$42*$G$26)*H$64)","v":0},{"$f":"SUM((($D$42/60)*27700*(J$55^2))/((J$65^2)*$G$42*$G$26)*J$64)","v":0}]
[null,null,"CV of Strainer or Valve",null,null,9,null,9,null,9]
[]
[null,null,"Calculated equivalent pipe length",null,null,{"$f":"SUM(L57:L64)","v":0},"feet",{"$f":"SUM(M57:M64)","v":0},"feet",{"$f":"SUM(N57:N64)","v":0},"feet"]
[null,null,"Friction pressure drop for section without dampener",null,null,{"$f":"SUM(NPSH!$B$35:$B$36)","v":1.1809569998641764E-2},"psi",{"$f":"SUM(NPSH!$B$37:$B$38)","v":0},"psi",{"$f":"SUM(NPSH!$B$39:$B$40)","v":0},"psi"]
[null,null,"Acceleration Pressure Drop for pipe section (without dampener):",null,null,{"$f":"SUM(NPSH!B9:B10)","v":1.4763243003796742},"psi",{"$f":"SUM(NPSH!$B$11:$B$12)","v":0},"psi",{"$f":"SUM(NPSH!$B$13:$B$14)","v":0},"psi"]
[null,null,"Friction pressure drop for pipe section (with dampener):",null,null,{"$f":"SUM(F68*0.2)","v":2.3619139997283528E-3},"psi",{"$f":"SUM(H68*0.2)","v":0},"psi",{"$f":"SUM(J68*0.2)","v":0},"psi"]
[null,null,"Acceleration Pressure Drop for pipe section (with dampener):",null,null,{"$f":"SUM(F69*0.2)","v":0.29526486007593483},"psi",{"$f":"SUM(H69*0.2)","v":0},"psi",{"$f":"SUM(J69*0.2)","v":0},"psi"]
[]
[null,"7.","Indicate if a pump suction accumulator (dampener) will be provided (Y/N):",null,null,null,null,null,null,2]
[]
[null,"CALCULATIONS"]
[null,null,"Total of pressure sources: (based on tank pressure, vapor pressure and elev above sea level)",null,null,null,null,null,null,null,null,null,null,{"$f":"NPSH!$K$9","v":14.5549623},"PSIA"]
[null,null,null,null,null,null,null,"Total frictional pressure drop through all piping sections:",null,null,null,null,null,{"$f":"IF(S133=\"Y\",(F70+H70+J70),NPSH!$K$24)","v":1.1809569998641764E-2},"PSI"]
[null,null,null,null,null,null,null,"Total acceleration pressure drop through all piping sections:",null,null,null,null,null,{"$f":"IF(S133=\"Y\",(F71+H71+J71),NPSH!J21*$AF$176)","v":1.4763243003796742},"PSI"]
[null,null,null,null,null,null,null,"Contour Plate Friction Loss:",null,null,null,null,null,{"$f":"NPSH!$B$28","v":2.1854945148746762E-6},"PSI"]
[null,null,null,null,null,null,null,"Operating Safety margin (entered above):",null,null,null,null,null,{"$f":"H47","v":0},"PSI"]
[null,null,null,null,null,null,null,"Check Valve Pressure Loss:",null,null,null,null,null,{"$f":"NPSH!$B$20","v":0.10725744214520058},"PSI"]
[null,null,null,null,null,null,null,"Minimum Net Inlet Pressure in Liquid End After all Frictional related losses and vapor pressure:",null,null,null,null,null,{"$f":"IF(S133=\"Y\",(NPSH!K20-(SUM(NPSH!K22:'NPSH'!K24)*0.2)-N80),(NPSH!K20-SUM(NPSH!K22:'NPSH'!K24)-N80))","v":14.435893102361643},"PSIA"]
[null,null,null,null,null,null,null,"Minimum Net Inlet Pressure in Liquid End After all Acceleration related losses and vapor pressure:",null,null,null,null,null,{"$f":"IF(S133=\"Y\",(NPSH!J20-(NPSH!J21*0.2*$AF$176)-N80-N79-N81),(NPSH!J20-(NPSH!J21*$AF$176)-N80-N79-N81))","v":12.97137837198061},"PSIA"]
[]
[null,"CONCLUSIONS - GO / NO GO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILLIAMS & HAZEN FORMULA FOR SMOOTH/STEADY TURBULENT FLOW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP= 4335 (0.2083)(100/150)^1.852 X ((Q)^1.852)/((DI)^1.852)XL/100"]
[null,"    *  Available NPIP based on frictional losses:",null,null,null,null,null,{"$f":"IF((N82>K44),\"'OK FOR USE'\",\"'INADEQUATE - Need larger diameter piping, shorter piping, reduce flowrate, slower pump speed to plunger diameter ratio, lower viscosity of fluid, or higher suction pressure.'\")","v":"'OK FOR USE'"},null,null,null,null,null,null,null,null,null,null,"STEADY FLOWRATE DP CALCULATION"]
[null,"    *  Available NPIP based on acceleration losses:",null,null,null,null,null,{"$f":"IF((N83>K44),\"'OK FOR USE'\",\"'INADEQUATE - Need larger diameter piping, shorter piping, reduce flowrate, slower pump speed to plunger diameter ratio, or higher suction pressure.'\")","v":"'OK FOR USE'"}]
[]
[null,"Notice:  The available Net Positive Inlet Pressure (NPIP) values shown above are based on available supply tank static pressure, less calculated total frictional or acceleration losses, check valve losses, contour plate losses (if applicable) and process fluid vapor pressure.     The available net positive fluid inlet pressure value must exceed fluid vapor pressure plus minimum NPSH pump design pressure, in order to avoid fluid cavitation between fluid and diaphragm in the pump liquid end.   However, the pump liquid end and pump gear box/plunger are actually subjected to the process fluid supply pressure, which is the highest available NPIP pressure value plus fluid vapor pressure.   \nPlease refer to the pump user manual to verify that this actual supply pressure does not exceed maximum pump suction design pressure.  This situation can typically occur  when the supply tank fluid is pressurized to overcome high fluid vapor pressures.\n\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q = 104 GPH X 2 PUMPS +  57 GPH (1 PUMP) = 265 GPH / 60 = 4.42 GPM"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP=0.4335*10.44*L*(Q^1.85/(C^1.85*Di^4.8655)"]
[null,"ENTER ADDITIONAL COMMENTS HERE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L=LENGTH OF PIPE IN FEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C=SPECIFIC ROUGHNESS CONSTANT FOR CLEAN PIPING (SMOOTH SS=140, CONCRETE=120, CAST IRON=130, COPPER=140, PLASTIC=140 (SUBTRACT 30% FOR DIRTY PIPE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Di=PIPE INTERNAL DIAMETER, INCHES"]
[null,"For suggestions and contacts:",null,null,"Email: Info@miltonroy.com",null,null,"Phone: 215-441-0800",null,"Fax: 215-441-0735"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUMP MODEL CODES & SIZES",null,null,null,"MIN NPSH (PSIA)","METAL SEAT DIAM\nINCHES",null,"PLASTIC SEAT DIAM\nINCHES",null,"CHECK VLV DEFAULT",null,null,"SEAT PART #",null,"Max Suction pressure",null,"SUCT BALL SIZE (INCHES)",null,"DISCH BALL SIZE",null,"CONTOUR PLATE DATA (# OF HOLES)",null,null,"CONTOUR PLATE DATA  HOLE DIAM. INCHES)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal D HPD 1\" (MDH16_)",null,null,null,3,0.28299999999999997,null,0.47,null,null,2,null,"2240092XXX",null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCH 80 PLASTIC",null,null,null,"CHEMICAL PARAMETERS",null,null,null,null,null,null,null,null,null,null,"Milroyal D HPD 1-1/4\" (MDH20_)",null,null,null,3,0.47499999999999998,null,0.47,null,null,2,null,"2240092XXX",null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIPE SIZINGS:","SCH 80\nID (INCHES)","SCH 40\nID (INCHES)","SCH 160 \nID\n(INCHES)","CHEM NAME",null,"SG @ 25 C","VP BAR","FLUID VIS @ 25 C",null,null,null,null,null,null,"Milroyal D HPD 1-1/2\" (MDH24_)",null,null,null,3,0.47499999999999998,null,0.47,null,null,2,null,"2240092XXX",null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4\"",0.30199999999999999,0.36399999999999999,null,"Acétaldehyde",null,0.78339999999999999,0.99,0.222,null,null,null,null,null,null,"Milroyal D MDP: (H2, H4, 02, 04)",null,null,null,0,9.4E-2,null,null,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/8\"",0.42299999999999999,0.49299999999999999,null,"acetic acid 30%",null,1.0489999999999999,1.2999999999999999E-2,1.53,null,null,null,null,null,null,"Milroyal D MDP: (07, 10)",null,null,null,0,0.28299999999999997,null,null,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2\"",0.54600000000000004,0.622,0.46600000000000003,"aniline",null,1.2,5.0000000000000001E-4,4.4000000000000004,null,null,null,null,null,null,"Milroyal MDD02/03-XXXX",null,null,null,9,9.5000000000000001E-2,null,null,null,null,2,null,null,null,null,null,"1/8",null,null,null,10,null,null,7.2999999999999995E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/4\"",0.74199999999999999,0.82399999999999995,0.61399999999999999,"Ethyl acetate",null,0.9,0.10299999999999999,0.44,null,null,null,null,null,null,"mRoy  XT",null,null,null,9,0.28299999999999997,null,null,null,null,1,null,null,null,null,null,null,null,null,null,17,null,null,5.8999999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",0.95699999999999996,1.0489999999999999,0.81499999999999995,"Acetone",null,0.8,0.248,0.33,null,null,null,null,null,null,"mRoy XW",null,null,null,9,0.47499999999999998,null,null,null,null,2,null,null,null,null,null,null,null,null,null,56,null,null,5.8999999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",1.278,1.38,1.1599999999999999,"Aluminum Sulfate 48.5%",null,1.3360000000000001,6.8947569999999996E-3,30,null,null,null,null,null,null,"mRoy RS",null,null,null,9,0.28299999999999997,null,null,null,null,2,null,2920072000,null,null,null,"1/4",null,null,null,24,null,null,6.3E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",1.5,1.61,1.34,"Ammonia 35%",null,0.68179999999999996,0.01,1.2849999999999999,null,null,null,null,null,null,"mRoy RB / RM",null,null,null,9,0.47,null,0.46899999999999997,null,null,1,null,"2240087XXX",null,null,null,null,null,null,null,40,null,null,0.122540707522031]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2\"",1.9390000000000001,2.0670000000000002,1.69,"Ammonia Hydroxide 35%",null,0.9,63.32,{"$f":"SUM(0.9*1.425)","v":1.2825},null,null,null,null,null,null,"mRoy RH/RJ/RT",null,null,null,9,0.28299999999999997,null,null,null,null,2,null,"2920072XXX",null,null,null,{"$f":"3/8","v":0.375},null,{"$f":"3/8","v":0.375},null,16,null,null,5.8999999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-1/2\"",2.323,2.4689999999999999,2.125,"Benzene",null,0.88,0.1,0.60399999999999998,null,null,null,null,null,null,"mRoy RA",null,null,null,9,0.28299999999999997,null,0.28299999999999997,null,null,2,null,"2240169XXX / 2920072XXX",null,null,null,{"$f":"3/8","v":0.375},null,{"$f":"3/8","v":0.375},null,24,null,null,8.8999999999999996E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3\"",2.9,3.0680000000000001,2.6259999999999999,"Carbon tetrachloride",null,1.5940000000000001,0.1217,0.96,null,null,null,null,null,null,"mRoy RP",null,null,null,9,0.46600000000000003,null,null,null,null,2,null,null,null,null,null,{"$f":"5/8","v":0.625},null,null,null,24,null,null,8.8999999999999996E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-1/2\"",3.3639999999999999,3.548,null,"Carbon dioxide 15% @ 0 C",null,1.6,1.01,0.01,null,null,null,null,null,null,"Macroy D2",null,null,null,11,0.218,null,0.21099999999999999,null,null,1,null,"2240206XXX",null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\"",3.8260000000000001,4.0259999999999998,3.44,"Chloroforme",null,1.47,0.21299999999999999,0.53,null,null,null,null,null,null,"Macroy D4",null,null,null,11,0.35899999999999999,null,0.215,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5\"",4.8129999999999997,5.0469999999999997,4.3099999999999996,"Chromic acid 505",null,1.7030000000000001,1.8E-3,0.01,null,null,null,null,null,null,"Macroy D7/D8",null,null,null,11,0.41499999999999998,null,0.47199999999999998,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6\"",5.7610000000000001,6.0650000000000004,5.19,"Citric acid ",null,1.665,0.01,1.0109999999999999,null,null,null,null,null,null,"Macroy G5 ",null,null,null,11,0.41499999999999998,null,0.47199999999999998,null,null,1,null,"2240173XXX",null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8\"",7.625,7.9809999999999999,6.81,"Cyclohexane",null,0.78,0.127,0.94,null,null,null,null,null,null,"Macroy G6/G7 ",null,null,null,11,0.75,null,0.71,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10\"",9.5640000000000001,10.02,null,"Dichloroethane",null,1.25,8.6999999999999994E-2,0.8,null,null,null,null,null,null,"Maxroy B",null,null,null,9,0.75,null,0.71,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12\"",11.375999999999999,11.938000000000001,null,"Dichloroethylene",null,1.27,0.24,0.44540000000000002,null,null,null,null,null,null,"MBD20",null,null,null,9,0.47299999999999998,null,null,null,null,1,null,null,null,null,null,null,null,null,null,10,null,null,{"$f":"11/16","v":0.6875}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14\"",12.5,13.124000000000001,null,"Dichromate potassium",null,2.69,0.45300000000000001,{"$f":"SUM(1.03*0.974)","v":1.00322},null,null,null,null,null,null,"Milroyal B MBH (07,09,10,16)",null,null,null,3,0.28299999999999997,null,null,null,null,1,null,null,null,360,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16\"",14.314,15,null,"Di-iode",null,4.92,2.7999999999999998E-4,null,null,null,null,null,null,null,"Milroyal B MBH (20,24,)",null,null,null,3,0.47399999999999998,null,null,null,null,1,null,null,null,85,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18\"",16.126000000000001,16.876000000000001,null,"Dioxane",null,1,4.1000000000000002E-2,1.2,null,null,null,null,null,null,"Milroyal B MBH (32,40)",null,null,null,3,0.75,null,null,null,null,1,null,null,null,45,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20\"",17.937999999999999,18.814,null,"Dioxyde of souffre CAS 2025884)",null,0.01,2.4,1.2,null,null,null,null,null,null,"Milroyal B MBH (56,64)",null,null,null,3,1.125,null,null,null,null,1,null,null,null,15,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24\"",21.564,22.626000000000001,null,"Distilled water",null,0.998,2.3E-2,0.01,null,null,null,null,null,null,"Milroyal C MCH (16)",null,null,null,3,0.47399999999999998,null,null,null,null,1,null,null,null,100,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edta",null,0.86,2.4,null,null,null,null,null,null,null,"Milroyal C MCH (20,24,32)",null,null,null,3,0.75,null,null,null,null,1,null,null,null,50,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","SCH 40",null,null,"Ethanol",null,0.7893,5.8999999999999997E-2,1.2,null,null,null,null,null,null,"Milroyal C MCH (40,56)",null,null,null,3,1.125,null,null,null,null,1,null,null,null,30,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","SCH 80",null,null,"Ethyl ether",null,0.71340000000000003,0.58630000000000004,0.23,null,null,null,null,null,null,"Milroyal C MCH (80,92)",null,null,null,3,1.9,null,null,null,null,1,null,null,null,9,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(S131:S132,J73)","v":"N"},"SCH 160",null,null,"Ethylene",null,1.1134999999999999,7.3000000000000001E-3,21,null,null,null,null,null,null,"Milroyal C Disc MCD (18,24)",null,null,null,9,0.84399999999999997,null,null,null,null,1,null,null,null,null,null,null,null,null,null,42,null,null,0.1875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrofluorosilicic acid 32%",null,1.27,0.01,0.01,null,null,null,null,null,null,"Centrac S - 175spm-all sizes",null,null,null,9,0.47399999999999998,null,0.27500000000000002,null,null,1,null,2240088016,null,null,null,"5/8",null,null,null,24,null,null,0.109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formaldehyde 37%",null,0.8135,1.01,0.01,null,null,null,null,null,null,"MaxRoyal Fix.",null,null,null,9,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formic acid 50%",null,1.22,0.04,1.804,null,null,null,null,null,null,"MaxRoyal Var.",null,null,null,9,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexane",null,0.66,0.16,0.31,null,null,null,null,null,null,"Primeroyal L HPD (20, 25 mm)",null,null,null,9,{"$f":"9.52*0.75*0.03936996","v":0.28110151440000003},null,null,null,null,2,null,null,null,{"$f":"50*14.5","v":725},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrazine 35%",null,1.0011000000000001,1.3322000000000001,0.97,null,null,null,null,null,null,"Primeroyal L HPD (25, 32, 40 mm)",null,null,null,9,{"$f":"15.9*0.75*0.03936996","v":0.46948677300000008},null,null,null,null,1,null,null,null,{"$f":"50*14.5","v":725},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrobromique acid 50%",null,1.49,0.23300000000000001,10,null,null,null,null,null,null,"Primeroyal L HPD (40, 63 mm)",null,null,null,9,{"$f":"25*0.75*0.03936996","v":0.73818675},null,null,null,null,1,null,null,null,{"$f":"14*14.5","v":203},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrochloric acid 36%",null,1.18,0.2,1.998,null,null,null,null,null,null,"Primeroyal L HPD (115 mm)",null,null,null,9,{"$f":"40*0.75*0.03936996","v":1.1810988},null,null,null,null,1,null,null,null,{"$f":"4.3*14.5","v":62.349999999999994},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrofluoric acid 40%",null,0.98,0.4,0.53,null,null,null,null,null,null,"Primeroyal N HPD (25 mm)",null,null,null,9,{"$f":"15.9*0.75*0.03936996","v":0.46948677300000008},null,null,null,null,2,null,null,null,{"$f":"50*14.5","v":725},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrogen peroxide 50%",null,1.194,2.4399999999999999E-3,0.01,null,null,null,null,null,null,"Primeroyal N HPD (32, 40, 50, 55 mm)",null,null,null,9,{"$f":"25*0.75*0.03936996","v":0.73818675},null,null,null,null,1,null,null,null,{"$f":"28*14.5","v":406},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Magnesium Chloride",null,2.3199999999999998,0.01,1.022,null,null,null,null,null,null,"Primeroyal N HPD (55,63,80,90,100 mm)",null,null,null,9,{"$f":"40*0.75*0.03936996","v":1.1810988},null,null,null,null,1,null,null,null,{"$f":"8*14.5","v":116},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methanol",null,0.79149999999999998,0.53328949999999997,0.59,null,null,null,null,null,null,"Primeroyal N HPD (125,145 mm)",null,null,null,9,{"$f":"73*0.75*0.03936996","v":2.1555053100000001},null,null,null,null,1,null,null,null,{"$f":"4*14.5","v":58},null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methyl alcohol",null,0.79,0.129,0.59,null,null,null,null,null,null,"Primeroyal R HPD (40 mm)",null,null,null,9,{"$f":"25*0.75*0.03936996","v":0.73818675},null,null,null,null,2,null,null,null,725,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury",null,13.55,1.5999999999999999E-5,1.55,null,null,null,null,null,null,"Primeroyal R HPD (50, 55 mm)",null,null,null,9,{"$f":"40*0.75*0.03936996","v":1.1810988},null,null,null,null,1,null,null,null,725,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morpholine",null,1,9.332E-3,2.23,null,null,null,null,null,null,"Primeroyal R HPD (63,70,80,90,100 mm)",null,null,null,9,{"$f":"50*0.75*0.03936996","v":1.4763735},null,null,null,null,1,null,null,null,725,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nitric acid 40%",null,1.4,9.4000000000000004E-3,1.77,null,null,null,null,null,null,"Primeroyal R HPD (115,125,130 mm)",null,null,null,9,{"$f":"70*0.75*0.03936996","v":2.0669229000000002},null,null,null,null,1,null,null,null,725,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oxalic acid 40%",null,1.9,0.01,1.17,null,null,null,null,null,null,"Primeroyal R HPD (145, 160 mm)",null,null,null,9,{"$f":"110*0.75*0.03936996","v":3.2480217000000002},null,null,null,null,1,null,null,null,725,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dioxyde of manganese 83-85%",null,5.03,0.01,1.2,null,null,null,null,null,null,"MIL G (MGH) - 1-1/4\"",null,null,null,6,0.27900000000000003,null,null,null,null,1,null,null,null,100,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oxygenated water 50%",null,1.2,1.7999999999999999E-2,1.8,null,null,null,null,null,null,"MIL G (MGH) - ALL OTHERS\"",null,null,null,6,0.47199999999999998,null,null,null,null,1,null,null,null,100,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phenol",null,1.0569999999999999,4.666E-2,12.7,null,null,null,null,null,null,"CBH1611-C1    7/8\" SS HARD",null,null,null,3,0.47,null,null,null,null,1,null,22400136000,null,100,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phosphoric acid 85%",null,1.8340000000000001,4.0000000000000001E-3,1.008,null,null,null,null,null,null,"CBH1611-C2    7/8\" SS HARD",null,null,null,3,0.47,null,null,null,null,2,null,22400136000,null,100,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potassium chloride",null,1.9870000000000001,0.01,0.998,null,null,null,null,null,null,"CBH1611-11",null,null,null,3,0.47399999999999998,null,null,null,null,1,null,2240088016,null,100,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potassium Hydroxide 50%",null,2.044,0.01,1.008,null,null,null,null,null,null,"CBH1611-22",null,null,null,3,0.47399999999999998,null,null,null,null,2,null,2240088016,null,100,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potassium permanganate",null,2.7029999999999998,0.01,0.999,null,null,null,null,null,null,"CBH2011-C1  1-1/4\" SS HARD",null,null,null,3,0.47399999999999998,null,null,null,null,1,null,22400136000,null,100,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acid orthophosphorique",null,1.53,3.0000000000000001E-3,null,null,null,null,null,null,null,"CBH2011-C2  1-1/4\" SS HARD",null,null,null,3,0.47399999999999998,null,null,null,null,2,null,22400136000,null,100,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pyridine",null,0.98,0.02,0.95,null,null,null,null,null,null,"CBH2011-11  1-1/4\" SS ",null,null,null,3,0.47399999999999998,null,null,null,null,1,null,2240088016,null,100,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium carbonate 35%",null,2.532,0.01,1.0229999999999999,null,null,null,null,null,null,"CBH2011-22  1-1/4\" SS ",null,null,null,3,0.47399999999999998,null,null,null,null,2,null,2240088016,null,100,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium Chloride",null,2.165,0.01,0.56000000000000005,null,null,null,null,null,null,"CBH2411-C1  1-1/2\" SS HARD",null,null,null,3,0.47399999999999998,null,null,null,null,1,null,2240136000,null,70,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium Chlorite 30%",null,1.87,0.01,1.002,null,null,null,null,null,null,"CBH2411-C2  1-1/2\" SS HARD",null,null,null,3,0.47399999999999998,null,null,null,null,2,null,2240136000,null,70,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium hydroxide 50%",null,2.13,0.01,120,null,null,null,null,null,null,"CBH2411-H2  1-1/2\" SS ",null,null,null,3,0.47399999999999998,null,null,null,null,2,null,2240088016,null,70,null,null,null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium hypochlorite",null,1.25,7.4999999999999997E-3,20,null,null,null,null,null,null,"CBH2411-11  1-1/2\" SS ",null,null,null,3,0.47399999999999998,null,null,null,null,1,null,2240088016,null,70,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium sulphite",null,1.48,4.0000000000000001E-3,4,null,null,null,null,null,null,"CBH2411-22  1-1/2\" SS ",null,null,null,3,0.47399999999999998,null,null,null,null,2,null,2240088016,null,70,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sulfuric acid 96%",null,1.84,1.2999999999999999E-2,19.8,null,null,null,null,null,null,"CBH3211-11    2\"      SS",null,null,null,3,0.75,null,null,null,null,1,null,2240089016,null,40,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tartaric acid",null,1.788,0.01,1.0209999999999999,null,null,null,null,null,null,"CBH3211-22    2\"      SS",null,null,null,3,0.75,null,null,null,null,2,null,2240089016,null,40,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toulene",null,0.86609999999999998,2.92E-2,0.57999999999999996,null,null,null,null,null,null,"CBH3211-LS   2\"      SS  SLURRY",null,null,null,3,0.75,null,null,null,null,1,null,2240139000,null,40,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichloroethane",null,1.34,0.13300000000000001,0.79,null,null,null,null,null,null,"CBH4011-11   2-1/2\" SS",null,null,null,3,0.75,null,null,null,null,1,null,2240089016,null,40,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichloroethylene",null,1.46,7.6999999999999999E-2,0.55000000000000004,null,null,null,null,null,null,"CBH4011-22   2-1/2\" SS",null,null,null,3,0.75,null,null,null,null,2,null,2240089016,null,25,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Triethylene glycol",null,1.127,0.02,1.2,null,null,null,null,null,null,"CBH5611-11   3-1/2\" SS",null,null,null,3,1.125,null,null,null,null,1,null,2240084016,null,25,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urea",null,1.335,0.01,1.0049999999999999,null,null,null,null,null,null,"CBH5611-22   3-1/2\" SS",null,null,null,3,1.125,null,null,null,null,2,null,2240084016,null,15,null,"1.5",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Xylene",null,0.86399999999999999,0.79900000000000004,0.80900000000000005,null,null,null,null,null,null,"CBH5611-C1   3-1/2\" SS",null,null,null,3,1.125,null,null,null,null,1,null,2240142000,null,15,null,"1.5",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other - Enter Chemical Name & Parameters Below",null,null,null,null,null,null,null,null,null,null,"CBH5651-1C   3-1/2\" SS  HAS C",null,null,null,3,1.125,null,null,null,null,1,null,2240084026,null,15,null,"1.5",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FERRIC CHLORIDE",null,1.42,0.01,12,null,null,null,null,null,null,"CBH1622-22     7/8\"   PVC",null,null,null,3,0.19,null,0.19,null,null,2,null,920064071,null,100,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WATER",null,1,0.01,1,null,null,null,null,null,null,"CBH2471-22    1-1/2\"  PVC",null,null,null,3,0.75,null,0.75,null,null,2,null,2240091078,null,70,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESET",null,{"$f":"INDEX($Y108:$Y175,$E$23)","v":1},{"$f":"INDEX($Z108:$Z175,$E$23)*14.50377","v":0.14503769999999999},{"$f":"INDEX($AA108:$AA175,$E$23)","v":1},null,null,null,"MULTIPLEXING FACTOR",{"$f":"IF($J$38=1,1,(IF($J$38=2,0.55,(IF($J$38=3,0.2,(IF($J$38=4,0.44,(IF($J$38=5,0.1,(IF($J$38=6,0.3,(IF($J$38=7,0.07,(IF($J$38=8,0.23,1)))))))))))))))","v":1},"DO NOT REMOVE THIS","CBH3272-22    2\"        PVC",null,null,null,3,0.75,null,0.75,null,null,2,null,2240091078,null,40,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrofluosilicic Acid",null,1.3,0.1,6.5,null,null,null,null,null,null,"CBH4022-22    2-1/2\" PVC",null,null,null,3,0.75,null,0.75,null,null,2,null,2240091071,null,25,null,"1",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zinc Orthophosphate",null,1.1000000000000001,0.1,10,null,null,null,null,null,null,"CBH5672-22    3-1/2\" PVC",null,null,null,3,1.125,null,1.125,null,null,2,null,21817,null,15,null,"1.5",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EV1---03D/04D/06D",null,null,null,10,0.27700000000000002,null,null,null,null,1,null,null,null,null,null,null,null,null,null,8,null,null,0.438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EV1---10D/14D/20D",null,null,null,10,0.27700000000000002,null,null,null,null,1,null,null,null,null,null,null,null,null,null,8,null,null,0.438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EV1---28D/38D",null,null,null,10,0.27700000000000002,null,null,null,null,1,null,null,null,null,null,null,null,null,null,8,null,null,0.438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVP---03D/04D/06D",null,null,null,10,0.27700000000000002,null,null,null,null,1,null,null,null,null,null,null,null,null,null,8,null,null,0.438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVP---10D/14D/20D",null,null,null,10,0.27700000000000002,null,null,null,null,1,null,null,null,null,null,null,null,null,null,8,null,null,0.438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVP---28D/38D",null,null,null,10,0.27700000000000002,null,null,null,null,1,null,null,null,null,null,null,null,null,null,8,null,null,0.438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EVA",null,null,null,10,0.27700000000000002,null,0.27700000000000002,null,null,1,null,"6137PB-XX",null,null,null,"1/4",null,null,null,8,null,null,0.438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal B MBP (05,07,AF,AH)",null,null,null,0,0.187,null,null,null,null,2,null,null,null,1450,null,"1/4",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal B MBP (10)",null,null,null,0,0.28100000000000003,null,null,null,null,1,null,null,null,750,null,"3/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal B MBP (14, 18,)",null,null,null,0,0.46800000000000003,null,null,null,null,1,null,null,null,265,null,"5/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal B MBP (24, 28)",null,null,null,0,0.77200000000000002,null,null,null,null,1,null,null,null,125,null,"3/4",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal B MBP (40)",null,null,null,0,1.0625,null,null,null,null,1,null,null,null,70,null,"1-1/2",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal C MCP (07, 10, BA)",null,null,null,0,0.28100000000000003,null,null,null,null,2,null,null,null,3800,null,"3/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal C MCP (AH)",null,null,null,0,0.25,null,null,null,null,1,null,null,null,3800,null,"3/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal C MCP (14, 18) ",null,null,null,0,0.65600000000000003,null,null,null,null,2,null,null,null,1200,null,"7/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal C MCP (24, 32) ",null,null,null,0,0.84399999999999997,null,null,null,null,2,null,null,null,395,null,"1-1/8",null,null,null,1,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Milroyal C MCP ( 40, 56, 71)",null,null,null,0,1.0625,null,null,null,null,2,null,null,null,85,null,"1-1/2",null,null,null,1,null,null,5]

{"sheet":"DISCHARGE RESULTS","index":3,"n_rows":188,"n_cols":31,"rows_kept":188,"cut":false,"hidden":false,"merged":[[113,49,113,50],[113,51,113,53],[113,54,113,56],[92,16,92,26],[113,31,113,34],[113,36,113,37],[113,38,113,39],[113,40,113,42],[113,47,113,48],[77,2,77,6],[77,7,77,13],[81,1,81,14],[78,2,78,6],[78,7,78,13],[18,16,18,17],[38,1,39,14],[11,16,13,25],[2,1,2,14],[3,1,3,14],[16,3,16,8],[16,10,16,14],[7,21,7,25],[8,21,8,23],[22,4,22,7],[9,21,9,25],[8,5,8,6],[24,13,25,13],[27,2,27,10],[30,2,30,10],[25,6,25,7],[0,13,0,14],[18,3,18,14],[22,11,22,14],[22,8,22,10],[24,6,24,7],[24,9,25,10],[24,11,25,12],[5,1,6,14],[72,2,72,10],[70,2,70,10],[64,3,64,10],[61,2,61,6],[65,2,65,10],[67,2,67,10],[68,2,68,10],[69,2,69,10],[66,2,66,10],[61,7,61,8],[29,11,29,14],[50,2,50,4],[51,2,51,4],[71,2,71,10],[53,2,53,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[52,2,52,4],[46,2,46,4],[58,2,58,4],[59,2,59,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[73,2,73,10],[44,11,45,13],[10,10,13,14],[8,9,8,10],[8,11,8,12],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[8,7,8,8],[32,1,35,14],[24,3,24,4],[25,3,25,4],[23,9,23,13],[22,2,22,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Document: ",{"$f":"'NPIP SUCTION RESULTS'!$N$1","v":51518}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Revision: ",{"$f":"'NPIP SUCTION RESULTS'!$N$2","v":"A"}]
[null,"PUMP SYSTEM ANALYSIS TOOL - DISCHARGE CONDITIONS"]
[null,"PUMP DISCHARGE TO INJECTION POINT PRESSURE LOSSES  CALCULATOR"]
[]
[null,"Calculations used in this program are based on a combination of theoritical anaylses and results of extensive fluids laboratory testing.  Because of simplifying assumptions made in equations, variations in chemical properties, variations in pipe characteristics, and other factors, Milton Roy L.L.C. cannot accept any responsibility for usefulness of calculated results.  The user is cautioned to verify results from this program with independent methods.  This calculator is applicable only for Milton Roy motor driven hydraulic or mechanical actuated diaphram or packed plunger pumps.   \nDO NOT USE THIS CALCULATOR  FOR ANY SOLENOID DRIVEN OR AIR-DRIVEN METERING PUMPS. "]
[]
[null,"NOTES and COLOR KEY"]
[null,null,"▪","Cell Color Key:",null,"Required Data",null,"Optional Data",null,"Calculated Data",null,"Final Results Data"]
[null,null,"▪","All pressures are in psia as indicated"]
[null,null,"▪","All flow rates are in gallons per hour",null,null,null,null,null,null,"Note: Be sure all data from previous calculations has been cleared before starting each new calculation."]
[null,null,"▪","Lengths and height are in feet"]
[null,null,"▪","Pipe Diameters are in inches."]
[]
[null,"PROJECT DATA"]
[]
[null,null,"Project Name:",{"$f":"'NPIP SUCTION RESULTS'!E17","v":"NPSH CALC FOR  ??? PUMPS"},null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2020-06-04"}]
[]
[null,null,"Prepared by: ",{"$f":"'NPIP SUCTION RESULTS'!E19","v":"ENTER YOUR NAME"}]
[]
[null,"CHEMICAL and SITE DATA"]
[]
[null,null,"Chemical selected on Suction Page:",null,65,null,null,null,"OR    chemical entered manually on suction page:",null,null,{"$f":"'NPIP SUCTION RESULTS'!$L$23","v":0}]
[]
[null,null,null,"Vapor Pressure psia:",null,"S.G.:","Viscosity cps.",null,null,"Elevation above sea level entered on Suction page:",null,{"$f":"'NPIP SUCTION RESULTS'!$F$30","v":0},null,"Feet"]
[null,null,null,{"$f":"'NPIP SUCTION RESULTS'!$E$26","v":0.14503769999999999},null,{"$f":"'NPIP SUCTION RESULTS'!$G$26","v":1},{"$f":"'NPIP SUCTION RESULTS'!$H$26","v":1}]
[]
[null,null,"1.     Enter net height difference from pump discharge elev.  to discharge injection  point elev. \n(UPWARD = POSITIVE,   DOWNWARD - NEGATIVE):",null,null,null,null,null,null,null,null,0,"Feet"]
[null,"PUMP DATA"]
[null,null,null,"Pump data from suction worksheet:",null,null,"Flow:\n(gph)",{"$f":"'NPIP SUCTION RESULTS'!$D$42","v":50},"Speed:\n (spm)",{"$f":"'NPIP SUCTION RESULTS'!$G$42","v":45},"Pump selected:",{"$f":"INDEX('NPIP SUCTION RESULTS'!AH105:AH195,'NPIP SUCTION RESULTS'!$D$38)","v":"Milroyal D HPD 1\" (MDH16_)"}]
[null,null,"2.    Enter maximum discharge pressure from pump: (obtain value from  flow/pressure tables from applicable Milton Roy pump brochure or data tables and backpressure valve setting)",null,null,null,null,null,null,null,null,150,"PSIG"]
[]
[null,"Did you know that:\n• Frictional and acceleration pressure losses also occur on the discharge side of the metering pump, which will affect pump performance at the discharge point.  \n• A discharge pulsation dampener (WHEN OPERATING PROPERLY) will significantly reduce acceleration losses in the discharge piping.\n• NPSH calculator determines pressure losses from each pump discharge to its injection point and will notify if there is sufficient pressure at the injection point.\n• Unlike centrifugal pumps, suction pressure (if adequate) will not affect discharge pressure in metering pumps.\n• Unlike centrifugal pumps, metering pump flowrate change is extremely minor due to discharge backpressure changes.\n• Just like the suction side; elbows, tees, flowmeters and valves affect friction losses, but not acceleration losses\n• Just like the suction side; pipe lengths, pipe diameters and flowrate affect both frictional and acceleration losses.\n• Discharge fluid flow siphoning may occur when lengthy discharge piping is open to atmospheric pressure and is arranged in a flat or down hill layout. Siphoning can occur even with a backpressure valve near the pump discharge. Siphoning will prevent the pump from proper metering. This happens because as a mass of process fluid builds up in discharge line, it will suddenly break free and pour out the open end, causing a momentary vacuum drag condition in the discharge piping, which in turn , causes excessive flow to pour past the pump ball checks. This situation can be avoided by installing a backpressure valve as close to the injection point as possible, which will keep most of the discharge pipe at a steady back\npressure.\n• Pressure gauges and switches should be sized so that their ranges are 25-50% above the max pressure rating of the pump, so that they will not be damaged if overpresurization occurs. For example, a 200 psig gauge should be used (if available) for a pump with max pressure rating of 150 psig.  "]
[]
[]
[]
[]
[null,"3.    ENTER DISCHARGE SIDE PIPING PARAMETERS:"]
[null,"The calculator allows data to be entered for up to 3 different sections of discharge pipe. This is important if pipe diameter changes between the pump and the injection point. When not used or not applicable, enter \"0\" in the cell."]
[]
[]
[null,null,"Description",null,null,"Section 1",null,"Section 2",null,"Section 3"]
[null,null,"Select Pipe Schedule:",null,null,2,null,2,null,2]
[null,null,"Select Pipe Size",null,null,3,null,3,null,3]
[null,null,"Calculated pipe ID inches",null,null,{"$f":"IF(F43=1,INDEX($S$118:$S$139,F44),IF(F43=2,INDEX($R$118:$R$139,F44),IF(F43=3,INDEX($T$118:$T$139,F44))))","v":0.54600000000000004},null,{"$f":"IF(H43=1,INDEX($S$118:$S$139,H44),IF(H43=2,INDEX($R$118:$R$139,H44),IF(H43=3,INDEX($T$118:$T$139,H44))))","v":0.54600000000000004},null,{"$f":"IF(J43=1,INDEX($S$118:$S$139,J44),IF(J43=2,INDEX($R$118:$R$139,J44),IF(J43=3,INDEX($T$118:$T$139,J44))))","v":0.54600000000000004},null,"Calculation Fields - CANNOT BE ALTERED"]
[null,null,"Enter pipe actual length",null,null,100,"feet",0,"feet",0,"feet"]
[null,null,"# of 90°  elbows",null,null,0,null,0,null,0,null,{"$f":"SUM(30*F$45/12)*F47","v":0},{"$f":"SUM(30*H$45/12)*H47","v":0},{"$f":"SUM(30*J$45/12)*J47","v":0}]
[null,null,"# of 45°  elbows",null,null,0,null,0,null,0,null,{"$f":"SUM(16*F$45/12)*F48","v":0},{"$f":"SUM(16*H$45/12)*H48","v":0},{"$f":"SUM(16*J$45/12)*J48","v":0}]
[null,null,"# of external ball check valves",null,null,0,null,0,null,0,null,{"$f":"SUM(150*F$45/12)*F49","v":0},{"$f":"SUM(150*H$45/12)*H49","v":0},{"$f":"SUM(150*J$45/12)*J49","v":0}]
[null,null,"# of tees - run flow",null,null,0,null,0,null,0,null,{"$f":"SUM(20*F$45/12)*F50","v":0},{"$f":"SUM(20*H$45/12)*H50","v":0},{"$f":"SUM(20*J$45/12)*J50","v":0}]
[null,null,"# of tees - branch flow",null,null,0,null,0,null,0,null,{"$f":"SUM(60*F$45/12)*F51","v":0},{"$f":"SUM(60*H$45/12)*H51","v":0},{"$f":"SUM(60*J$45/12)*J51","v":0}]
[null,null,"# of single reduction reducer bushings",null,null,0,null,0,null,0,null,{"$f":"SUM(15.5*F$45/12)*F52","v":0},{"$f":"SUM(15.5*H$45/12)*H52","v":0},{"$f":"SUM(15.5*J$45/12)*J52","v":0}]
[null,null,"# of manual Valves",null,null,0,null,0,null,0,null,{"$f":"SUM((('NPIP SUCTION RESULTS'!$D$42/60)*27700*(F$45^2))/((F$54^2)*'NPIP SUCTION RESULTS'!$G$42*$F$26)*F$53)","v":0},{"$f":"SUM((('NPIP SUCTION RESULTS'!$D$42/60)*27700*(H$45^2))/((H$54^2)*'NPIP SUCTION RESULTS'!$G$42*$F$26)*H$53)","v":0},{"$f":"SUM((('NPIP SUCTION RESULTS'!$D$42/60)*27700*(J$45^2))/((J$54^2)*'NPIP SUCTION RESULTS'!$G$42*$F$26)*J$53)","v":0}]
[null,null,"CV of manual  Valve above",null,null,9,null,9,null,9]
[]
[null,null,"Calculated equivalent pipe length",null,null,{"$f":"SUM(L46:L54)","v":0},"feet",{"$f":"SUM(M46:M54)","v":0},"feet",{"$f":"SUM(N46:N54)","v":0},"feet"]
[null,null,"Friction pressure drop for section without dampener",null,null,{"$f":"(0.0000143*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$H$26*F46/F45^4)+(0.0000143*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$H$26*F56/F45^4)","v":0.80451745479548642},"psi",{"$f":"(0.0000143*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$H$26*H46/H45^4)+(0.0000143*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$H$26*H56/H45^4)","v":0},"psi",{"$f":"(0.0000143*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$H$26*J46/J45^4)+(0.0000143*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$H$26*J56/J45^4)","v":0},"psi"]
[null,null,"Acceleration Pressure Drop for pipe section (without dampener):",null,null,{"$f":"('NPIP SUCTION RESULTS'!$G$42*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$G$26*F46)/(27700*F45^2)*$AD$186","v":27.246922950497353},"psi",{"$f":"('NPIP SUCTION RESULTS'!$G$42*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$G$26*H46)/(27700*H45^2)*$AD$186","v":0},"psi",{"$f":"('NPIP SUCTION RESULTS'!$G$42*'NPIP SUCTION RESULTS'!$D$42*'NPIP SUCTION RESULTS'!$G$26*J46)/(27700*J45^2)*$AD$186","v":0},"psi"]
[null,null,"Friction pressure drop for pipe section (with dampener):",null,null,{"$f":"SUM(F57*0.2)","v":0.16090349095909728},"psi",{"$f":"SUM(H57*0.2)","v":0},"psi",{"$f":"SUM(J57*0.2)","v":0},"psi"]
[null,null,"Acceleration Pressure Drop for pipe section (with dampener):",null,null,{"$f":"SUM(F58*0.2)*$AD$186","v":5.4493845900994708},"psi",{"$f":"SUM(H58*0.2)*$AD$186","v":0},"psi",{"$f":"SUM(J58*0.2)*$AD$186","v":0},"psi"]
[]
[null,null,"4.    Select if pump discharge pulsation dampener is provided (Y/N):",null,null,null,null,1]
[]
[null,"CALCULATIONS"]
[null,null,null,"Starting discharge pressure inside pump:",null,null,null,null,null,null,null,{"$f":"L31","v":150},"PSIG"]
[null,null,"Total frictional pressure loss through all piping sections:",null,null,null,null,null,null,null,null,{"$f":"IF(Q144=\"Y\",SUM(F59,H59,J59),SUM(F57,H57,J57))","v":0.16090349095909728},"PSI"]
[null,null,"Total acceleration pressure loss through all piping sections:",null,null,null,null,null,null,null,null,{"$f":"IF(Q144=\"Y\",SUM(F60,H60,J60),SUM(F58,H58,J58))","v":5.4493845900994708},"PSI"]
[null,null,"Contour Plate Friction Loss:",null,null,null,null,null,null,null,null,{"$f":"NPSH!B28","v":2.1854945148746762E-6},"PSI"]
[null,null,"Operating Safety margin (entered above):",null,null,null,null,null,null,null,null,{"$f":"'NPIP SUCTION RESULTS'!$H$47","v":0},"PSI"]
[null,null,"Check Valve Pressure Loss:",null,null,null,null,null,null,null,null,{"$f":"NPSH!B20","v":0.10725744214520058},"PSI"]
[null,null,"Pressure Loss OR Gain due to discharge height difference from pump to injection point:",null,null,null,null,null,null,null,null,{"$f":"SUM(L28/2.31*'NPIP SUCTION RESULTS'!G26)","v":0},"PSI"]
[null,null,"Max Pressure at discharge piping  injection point after all Frictional related losses:",null,null,null,null,null,null,null,null,{"$f":"SUM(L65-L66-L68-L69-L70-L71)","v":149.73183688140119},"PSIG"]
[null,null,"Max Pressure at  discharge piping  injection point after all Acceleration related losses:",null,null,null,null,null,null,null,null,{"$f":"SUM(L65-L67-L69-L71)","v":144.55061540990053},"PSIG"]
[null,"5. ","Enter required discharge injection point pressure here.  Enter \"0\" if discharging into atmospheric conditions.   This is the target pressure to exceed. ",null,null,null,null,null,null,null,null,30,"PSIG"]
[]
[null,"CONCLUSIONS - GO / NO GO:"]
[]
[null,null,"    *  Available injection point pressure based on frictional losses:",null,null,null,null,{"$f":"IF(L72>$L$74,\"'OK FOR USE'\",\"'INADEQUATE - Need larger diameter piping, shorter piping, slower pump speed to plunger diameter ratio, or higher pump discharge pressure setting.'\")","v":"'OK FOR USE'"}]
[null,null,"    *  Available injection point pressure based on acceleration losses:",null,null,null,null,{"$f":"IF(L73>$L$74,\"'OK FOR USE'\",\"'INADEQUATE - Need larger diameter piping, shorter piping, slower pump speed to plunger diameter ratio, or higher pump discharge pressure setting.'\")","v":"'OK FOR USE'"}]
[]
[null,"ENTER ADDITIONAL COMMENTS HERE"]
[]
[]
[null,"For suggestions and contacts:",null,null,"Email: Info@miltonroy.com",null,null,"Phone: 215-441-0800",null,"Fax: 215-441-0735"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WILLIAMS & HAZEN FORMULA FOR SMOOTH/STEADY TURBULENT FLOW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP= 4335 (0.2083)(100/150)^1.852 X ((Q)^1.852)/((DI)^1.852)XL/100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEADY FLOWRATE DP CALCULATION"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q = 104 GPH X 2 PUMPS +  57 GPH (1 PUMP) = 265 GPH / 60 = 4.42 GPM"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DP=0.4335*10.44*L*(Q^1.85/(C^1.85*Di^4.8655)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L=LENGTH OF PIPE IN FEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C=SPECIFIC ROUGHNESS CONSTANT FOR CLEAN PIPING (SMOOTH SS=140, CONCRETE=120, CAST IRON=130, COPPER=140, PLASTIC=140 (SUBTRACT 30% FOR DIRTY PIPE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Di=PIPE INTERNAL DIAMETER, INCHES"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCH 80 PLASTIC",null,null,null,"CHEMICAL PARAMETERS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIPE SIZINGS:","SCH 80\nID (INCHES)","SCH 40\nID (INCHES)","SCH 160 \nID\n(INCHES)","CHEM NAME",null,"SG @ 25 C","VP BAR","FLUID VIS @ 25 C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4\"",0.30199999999999999,0.36399999999999999,null,"Acétaldehyde",null,0.78339999999999999,0.99,0.222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/8\"",0.42299999999999999,0.49299999999999999,null,"acetic acid 30%",null,1.0489999999999999,1.2999999999999999E-2,1.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2\"",0.54600000000000004,0.622,0.46600000000000003,"aniline",null,1.2,5.0000000000000001E-4,4.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/4\"",0.74199999999999999,0.82399999999999995,0.61399999999999999,"Ethyl acetate",null,0.9,0.10299999999999999,0.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",0.95699999999999996,1.0489999999999999,0.81499999999999995,"Acetone",null,0.8,0.248,0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",1.278,1.38,1.1599999999999999,"Aluminum Sulfate 48.5%",null,1.3360000000000001,6.8947569999999996E-3,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",1.5,1.61,1.34,"Ammonia 35%",null,0.68179999999999996,0.01,1.2849999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2\"",1.9390000000000001,2.0670000000000002,1.69,"Ammonia Hydroxide 35%",null,0.9,63.32,{"$f":"SUM(0.9*1.425)","v":1.2825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-1/2\"",2.323,2.4689999999999999,2.125,"Benzene",null,0.88,0.1,0.60399999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3\"",2.9,3.0680000000000001,2.6259999999999999,"Carbon tetrachloride",null,1.5940000000000001,0.1217,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-1/2\"",3.3639999999999999,3.548,null,"Carbon dioxide 15% @ 0 C",null,1.6,1.01,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\"",3.8260000000000001,4.0259999999999998,3.44,"Chloroforme",null,1.47,0.21299999999999999,0.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5\"",4.8129999999999997,5.0469999999999997,4.3099999999999996,"Chromic acid 505",null,1.7030000000000001,1.8E-3,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6\"",5.7610000000000001,6.0650000000000004,5.19,"Citric acid ",null,1.665,0.01,1.0109999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8\"",7.625,7.9809999999999999,6.81,"Cyclohexane",null,0.78,0.127,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10\"",9.5640000000000001,10.02,null,"Dichloroethane",null,1.25,8.6999999999999994E-2,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12\"",11.375999999999999,11.938000000000001,null,"Dichloroethylene",null,1.27,0.24,0.44540000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14\"",12.5,13.124000000000001,null,"Dichromate potassium",null,2.69,0.45300000000000001,{"$f":"SUM(1.03*0.974)","v":1.00322}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16\"",14.314,15,null,"Di-iode",null,4.92,2.7999999999999998E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18\"",16.126000000000001,16.876000000000001,null,"Dioxane",null,1,4.1000000000000002E-2,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20\"",17.937999999999999,18.814,null,"Dioxyde of souffre CAS 2025884)",null,0.01,2.4,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24\"",21.564,22.626000000000001,null,"Distilled water",null,0.998,2.3E-2,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edta",null,0.86,2.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y","SCH 40",null,null,"Ethanol",null,0.7893,5.8999999999999997E-2,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","SCH 80",null,null,"Ethyl ether",null,0.71340000000000003,0.58630000000000004,0.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Q141:Q142,H62)","v":"Y"},"SCH 160",null,null,"Ethylene",null,1.1134999999999999,7.3000000000000001E-3,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Q141:Q142,H62)","v":"Y"},null,null,null,"Hydrofluorosilicic acid 32%",null,1.27,0.01,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formaldehyde 37%",null,0.8135,1.01,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formic acid 50%",null,1.22,0.04,1.804]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexane",null,0.66,0.16,0.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrazine 35%",null,1.0011000000000001,1.3322000000000001,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrobromique acid 50%",null,1.49,0.23300000000000001,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrochloric acid 36%",null,1.18,0.2,1.998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrofluoric acid 40%",null,0.98,0.4,0.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrogen peroxide 50%",null,1.194,2.4399999999999999E-3,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Magnesium Chloride",null,2.3199999999999998,0.01,1.022]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methanol",null,0.79149999999999998,0.53328949999999997,0.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methyl alcohol",null,0.79,0.129,0.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury",null,13.55,1.5999999999999999E-5,1.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morpholine",null,1,9.332E-3,2.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nitric acid 40%",null,1.4,9.4000000000000004E-3,1.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oxalic acid 40%",null,1.9,0.01,1.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dioxyde of manganese 83-85%",null,5.03,0.01,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oxygenated water 50%",null,1.2,1.7999999999999999E-2,1.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phenol",null,1.0569999999999999,4.666E-2,12.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phosphoric acid 85%",null,1.8340000000000001,4.0000000000000001E-3,1.008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potassium chloride",null,1.9870000000000001,0.01,0.998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potassium Hydroxide 50%",null,2.044,0.01,1.008]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potassium permanganate",null,2.7029999999999998,0.01,0.999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acid orthophosphorique",null,1.53,3.0000000000000001E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pyridine",null,0.98,0.02,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium carbonate 35%",null,2.532,0.01,1.0229999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium Chloride",null,2.165,0.01,0.56000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium Chlorite 30%",null,1.87,0.01,1.002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium hydroxide 50%",null,2.13,0.01,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium hypochlorite",null,1.25,7.4999999999999997E-3,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium sulphite",null,1.48,4.0000000000000001E-3,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sulfuric acid 96%",null,1.84,1.2999999999999999E-2,19.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tartaric acid",null,1.788,0.01,1.0209999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toulene",null,0.86609999999999998,2.92E-2,0.57999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichloroethane",null,1.34,0.13300000000000001,0.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichloroethylene",null,1.46,7.6999999999999999E-2,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Triethylene glycol",null,1.127,0.02,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urea",null,1.335,0.01,1.0049999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Xylene",null,0.86399999999999999,0.79900000000000004,0.80900000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other - Enter Chemical Name & Parameters Below"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FERRIC CHLORIDE",null,1.42,0.01,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WATER",null,1,0.01,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESET",null,{"$f":"'NPIP SUCTION RESULTS'!Y176","v":1},{"$f":"'NPIP SUCTION RESULTS'!Z176","v":0.14503769999999999},{"$f":"'NPIP SUCTION RESULTS'!AA176","v":1},null,null,null,"MULTIPLEXING FACTOR",{"$f":"'NPIP SUCTION RESULTS'!$AF$176","v":1},"DO NOT REMOVE THIS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrofluosilicic Acid",null,1.3,0.1,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zinc Orthophosphate",null,1.1000000000000001,0.1,10]

{"sheet":"Directions & Training","index":4,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DOUBLE CLICK ON THE BOX BELOW FOR STEP BY STEP  INSTRUCTIONS ON HOW TO USE THE  PUMPING SYSTEMS ANALYSIS TOOL",null,"DOUBLE CLICK ON THE BOX BELOW FOR NPSH TRAINING SLIDE SHOW"]
[null,"   V    V     V     V     V     V     V     V     V     V     V     V     V     V     V     V    ",null,"     V    V     V     V     V     V     V     V     V     V     V     V     V     V     V     V     V"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PRESS <ESC> KEY TO EXIT SLIDE SHOW",null,"PRESS <ESC> KEY TO EXIT SLIDE SHOW"]