{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["CENTRIFUGAL"],"not_rendered":{"charts":1,"images":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"CENTRIFUGAL","index":0,"n_rows":49,"n_cols":23,"rows_kept":49,"merged":[[0,0,0,14],[0,15,0,17],[32,1,32,5],[32,7,32,11],[32,13,32,16]]}
["PUMP CALCULATION PART 1"]
[{"$nulls":18},"SYSTEM CHARACTERISTICS"]
[null,"SINGLE STAGE CENTRIFUGAL PUMP CALCULATION",{"$nulls":12},"Version","1.001","1997-11-01",null,"Q","Ptot","Ltot","Ftot","Htot"]
[null,"(Clean Water Use)",{"$nulls":16},{"$f":"C34","v":215},{"$f":"C44-C38","v":{"v":0,"d":"0.00"}},{"$f":"C45+C39","v":-0.008},{"$f":"C41+C47","v":{"v":54.12844037,"d":"54.13"}},{"$f":"T4+U4+V4","v":{"v":54.12044037,"d":"54.12"}}]
[null,"Static Suction Lift = Ls",{"$nulls":3},"Pump Suction Diam = Ds"]
[null,"Static Discharge Head = Ld",{"$nulls":3},"Pump Discharge Diam = Dd",{"$nulls":12},0,{"$f":"$T$4","v":{"v":0,"d":"0.00"}},{"$f":"$U$4","v":-0.008},{"$f":"$V$4/$S$4^2*S6^2","v":0},{"$f":"T6+U6+V6","v":{"v":-0.008,"d":"-0.01"}}]
[null,"Total Static Head Ltot = Ls + Ld",{"$nulls":16},{"$f":"$S$4/8+S6","v":26.875},{"v":0,"d":"0.00"},-0.008,0.8457568807,{"v":0.8377568807,"d":"0.84"}]
[null,"Friction Head = Hfs and Hfd",{"$nulls":16},53.75,{"v":0,"d":"0.00"},-0.008,3.383027523,{"v":3.375027523,"d":"3.38"}]
[null,"Inlet and Discharge Nozzle Losses = Hi and Ho",{"$nulls":16},80.625,{"v":0,"d":"0.00"},-0.008,7.611811927,{"v":7.603811927,"d":"7.60"}]
[null,"Velocity Head = V2/2g      [often included in pump curves]",{"$nulls":16},107.5,{"v":0,"d":"0.00"},-0.008,13.53211009,{"v":13.52411009,"d":"13.52"}]
[null,"Pump Suction and Discharge Nozzle Elevations = Lns and Lnd",{"$nulls":16},134.375,{"v":0,"d":"0.00"},-0.008,21.14392202,{"v":21.13592202,"d":"21.14"}]
[null,"Suction Pressure Head = Ps [if open tank = 0]",{"$nulls":16},161.25,{"v":0,"d":"0.00"},-0.008,30.44724771,{"v":30.43924771,"d":"30.44"}]
[null,"Discharge Pressure Head = Pd [if open tank = 0]",{"$nulls":16},188.125,{"v":0,"d":"0.00"},-0.008,41.44208716,{"v":41.43408716,"d":"41.43"}]
[{"$nulls":18},215,{"v":0,"d":"0.00"},-0.008,54.12844037,{"v":54.12044037,"d":"54.12"}]
[{"$nulls":18},241.875,{"v":0,"d":"0.00"},-0.008,68.50630734,{"v":68.49830734,"d":"68.50"}]
[{"$nulls":18},268.75,{"v":0,"d":"0.00"},-0.008,84.57568807,{"v":84.56768807,"d":"84.57"}]
[{"$nulls":18},295.625,{"v":0,"d":"0.00"},-0.008,102.3365826,{"v":102.3285826,"d":"102.33"}]
[{"$nulls":18},322.5,{"v":0,"d":"0.00"},-0.008,121.7889908,{"v":121.7809908,"d":"121.78"}]
[{"$nulls":7},"Pout = Pd + Ld + Hfd + Ho - Lnd = Hd - Vd2/2g - Lnd",{"$nulls":10},349.375,{"v":0,"d":"0.00"},-0.008,142.9329128,{"v":142.9249128,"d":"142.92"}]
[{"$nulls":18},376.25,{"v":0,"d":"0.00"},-0.008,165.7683486,{"v":165.7603486,"d":"165.76"}]
[{"$nulls":18},403.125,{"v":0,"d":"0.00"},-0.008,190.2952982,{"v":190.2872982,"d":"190.29"}]
[{"$nulls":6},"Pin = Ps - Ls - Hfs - Hi + Lns = - Hs - Vs2/2g + Lns",{"$nulls":11},430,{"v":0,"d":"0.00"},-0.008,216.5137615,{"v":216.5057615,"d":"216.51"}]
[]
[{"$nulls":18},{"$f":"C34","v":215},{"$nulls":3},{"$f":"I45","v":{"v":55.52980874,"d":"55.53"}}]
[]
[{"$nulls":5},"Total Dynamic Suction Lift ",null,null,"Hs = Ls - Ps + Hfs + Hi - Vs2/2g",{"$nulls":3},"Dynamic Suction Lift (req'd)",null,null,"Hs(r) = Ls - Ps + Hfs + Hi",null,null,"WATER VAPOUR PRESSURE"]
[{"$nulls":5},"Total Dynamic Discharge Head ",null,null,"Hd = Ld + Pd + Hfd + Ho + Vd2/2g",{"$nulls":3},"Dynamic Discharge Head (req'd)",null,null,"Hd(r) = Ld + Pd + Hfd + Ho",null,null,"degC","kPa(abs)"]
[{"$nulls":5},"Total Dynamic Head ",null,null,"Htot = Hd + Hs",{"$nulls":3},"Dynamic Head (req'd)",null,null,"Htot(r) = Hd(r) + Hs(r) ",null,null,0,0.6]
[{"$nulls":12},"NPSHa(req'd)",null,null,"NPSHa(r) = NPSHa - Vs2/2g",null,null,15,1.7]
[null,null,"Closed Tank:","NPSHa(abs) = Ps + Patm - Ls  - Hfs - Hi + Vs2/2g - Pvap  [where Pvap = Vapour Pressure(abs)]",{"$nulls":8},"Provide this to pump vendor and use on pump curves",{"$nulls":5},25,3.2]
[null,null,"Open Tank:","or = Pamb - Ls - Hfs - Hi + Vs2/2g - Pvap   [NPSHa should exceed NPSHr by at least 0.5 m]",{"$nulls":8},"where velocity head is included in vendors pump curves.",{"$nulls":5},30,4.25]
[{"$nulls":18},40,7.38]
[null,"SYSTEM PROPERTIES",{"$nulls":5},"SYSTEM CHARACTERISTICS",{"$nulls":5},"PUMP SELECTION (Nominal)",{"$nulls":4},50,12.5]
[null,"Q",215,"l/sec",{"$f":"C34/1000","v":{"v":0.215,"d":"0.2150"}},"m3/sec",null,"Patm",{"$f":"K34/9.81/$C$35","v":{"v":10.32874618,"d":"10.329"}},"m",101.325,"kPa(abs)"]
[null,"SG",1,"D",{"$f":"C35*1000","v":1000},"kg/m3",null,"Pamb",{"v":9.97961264,"d":"9.980"},"m",{"v":97.9,"d":"97.900"},"kPa(abs)",null,"Pump Speed",null,1483,"rpm",null,120,198.5]
[null,"Tfluid",null,null,16,"oC",null,"Vs",{"$f":"K36^2/2/9.81","v":{"v":0.9777731774,"d":"0.978"}},"m",{"$f":"$E$34/E42","v":{"v":4.379944034,"d":"4.38"}},"m/sec",{"$nulls":6},140,361.4]
[null,"Pvap",{"$f":"E37/$C$35/9.81","v":{"v":0.1936799185,"d":"0.19"}},"m(abs)",1.9,"kPa(abs)",null,"Pinlet",{"$f":"C38-C39-C41-C40+C43","v":{"v":-2.668735984,"d":"-2.669"}},"m",{"$f":"$C$35*9.81*I37","v":{"v":-26.1803,"d":"-26.180"}},"kPa(g)",null,"Impeller Diam",null,0.449,"m"]
[null,"Ps",{"v":0,"d":"0.00"},"m",0,"kPa(g)",null,"Hs",{"$f":"C39-C38+C41+C40-I36","v":{"v":1.990962806,"d":"1.991"}},"m",{"v":19.53134513,"d":"19.531"},"kPa",null,"Pump Head",null,{"$f":"(PI()*P37*P35/60)^2/2/9.81","v":{"v":61.95455268,"d":"61.95"}},"m"]
[null,"Ls",{"v":0.93,"d":"0.930"},"m",{"$f":"$C$35*9.81*C39","v":{"v":9.1233,"d":"9.1"}},"kPa",null,"Hs(r) ",{"$f":"C39-C38+C41+C40","v":{"v":2.968735984,"d":"2.969"}},"m",{"v":29.1233,"d":"29.123"},"kPa"]
[null,"Hi",{"$f":"E40/$C$35/9.81","v":{"v":0,"d":"0.000"}},"m",0,"kPa",null,"Vd",{"$f":"K40^2/2/9.81","v":{"v":2.387141546,"d":"2.387"}},"m",{"$f":"$E$34/E48","v":{"v":6.843662553,"d":"6.84"}},"m/sec",null,"Hydraulic Power",null,{"$f":"I45*E34*E35*9.81/1000","v":{"v":117.1206961,"d":"117.12"}},"kW",null,"NOTES:"]
[null,"Hfs",{"v":2.038735984,"d":"2.039"},"m",20,"kPa",null,"Poutlet",{"$f":"C44+C45+C47+C46-C49","v":{"v":51.45170438,"d":"51.452"}},"m",{"$f":"$C$35*9.81*I41","v":{"v":504.74122,"d":"504.741"}},"kPa(g)",null,"Pump Efficiency",null,{"v":0.838,"d":"83.8%"},null,null,"For Hfs and Hfd try 50 kPa/100m"]
[null,"Ds",{"v":0.25,"d":"0.250"},"m        As",{"$f":"PI()*C42^2/4","v":{"v":0.04908738521,"d":"0.0491"}},"m2",null,"Hd",{"$f":"C45+C44+K40^2/2/9.81+C47+C46","v":{"v":53.53884593,"d":"53.539"}},"m",{"v":525.2160786,"d":"525.216"},"kPa",null,"Motor Power",null,{"$f":"P40/P41","v":{"v":139.7621672,"d":"139.76"}},"kW"]
[null,"Lns",0.3,"m",{"$f":"$C$35*9.81*C43","v":2.943},"kPa",null,"Hd(r) ",{"$f":"C45+C44+C47+C46","v":{"v":51.15170438,"d":"51.152"}},"m",{"v":501.79822,"d":"501.798"},"kPa",{"$nulls":6},"Select Ds and Dd for Vs and Vd around 3 m/sec"]
[null,"Pd",{"$f":"E44/$C$35/9.81","v":{"v":0,"d":"0.00"}},"m",0,"kPa(g)",{"$nulls":7},"Specific Speed",null,{"$f":"P35*SQRT(C34)/(I45^0.75)","v":{"v":1068.970568,"d":"1069"}}]
[null,"Ld",-0.938,"m",{"$f":"$C$35*9.81*C45","v":-9.20178},"kPa",null,"Htot",{"$f":"I42+I38","v":{"v":55.52980874,"d":"55.53"}},"m",{"$f":"$C$35*9.81*I45","v":{"v":544.7474237,"d":"544.75"}},"kPa",null,{"$f":"IF(P44<500,\"Warning: Low Specific Speed. Consider Multistage.\",\" \")","v":" "},{"$nulls":4},"For small pumps try 60% efficiency"]
[null,"Ho",{"$f":"E46/$C$35/9.81","v":{"v":0,"d":"0.000"}},"m",0,"kPa",null,"Htot(r)",{"v":54.12044037,"d":"54.12"},"m",{"v":530.92152,"d":"530.92"},"kPa",null,"NPSHr",null,2,"m"]
[null,"Hfd",{"v":52.08970438,"d":"52.090"},"m",511,"kPa",{"$nulls":7},"Normally approx. 3% Htot =",null,{"$f":"0.03*I45","v":{"v":1.665894262,"d":"1.666"}},"m"]
[null,"Dd",{"v":0.2,"d":"0.200"},"m        Ad",{"$f":"PI()*C48^2/4","v":{"v":0.03141592654,"d":"0.0314"}},"m2",null,"NPSHa",{"$f":"IF(E38=0,I35-C39-C41-C40+I36-C37,C38+I34-C39-C41-C40+I36-C37)","v":{"v":7.794969915,"d":"7.79"}},"m(abs)",{"$f":"$C$35*9.81*I48","v":{"v":76.46865487,"d":"76.47"}},"kPa(g)",null,{"$f":"IF(I49<P46,\"Warning: NPSHr exceeds NPSHa\",\" \")","v":" "}]
[null,"Lnd",-0.3,"m",{"$f":"$C$35*9.81*C49","v":-2.943},"kPa",null,"NPSHa(r)",{"$f":"I48-I36","v":{"v":6.817196738,"d":"6.82"}},"m(abs)",{"v":66.8767,"d":"66.88"},"kPa(g)"]