{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["General Input","Process Input","Calculations","Results","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"General Input","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[12,0,12,2],[1,0,1,11],[9,0,9,2],[9,3,9,5],[10,0,10,2],[11,0,11,2],[7,0,7,2],[7,3,7,5],[8,0,8,2],[8,3,8,5],[5,0,5,2],[5,3,5,5],[6,0,6,2],[6,3,6,5]]}
[]
["CDS - DELTA-P CALCULATIONS FOR SINGLE AND MULTI-PHASE FLOWS"]
[]
[]
[]
["General Information",null,null,"Input Data"]
["JOB",null,null,"MP DP calculation"]
["CLIENT",null,null,"XYZ"]
["ITEM NO.",null,null,"Line#101"]
["LOCATION",null,null,"Pune"]
["DESIGN ENGINEER    / Rev.#",null,null,"abc",0]

{"sheet":"Process Input","index":1,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,11],[9,6,9,8],[10,6,10,8],[11,6,11,8],[7,6,7,11],[4,0,4,3],[14,0,14,2],[15,0,15,2],[11,0,11,2],[16,6,16,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[13,0,13,2],[12,0,12,2],[18,0,18,3],[16,13,16,16],[17,13,17,16],[18,13,18,16],[16,0,16,2],[17,6,17,8],[17,0,17,2],[13,13,13,16],[22,13,22,16],[14,13,14,16],[20,13,20,16],[21,13,21,16],[15,13,15,16],[19,13,19,16],[5,13,5,16],[10,13,10,16],[7,0,7,5],[11,13,11,16],[12,13,12,16],[6,13,6,16],[7,13,7,16],[9,13,9,16],[9,0,9,2],[10,0,10,2]]}
[]
["CDS - DELTA-P CALCULATIONS FOR SINGLE AND MULTI-PHASE FLOWS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-phase "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single phase"]
["Flow type:",null,null,null,{"$f":"IF(Q3=\"Single phase\",1,2)","v":2},null,null,null,null,null,null,null,null,null,null,null,"Multi-phase "]
[null,null,null,null,null,null,"Realative Pipe roughness=",null,null,1,"mm",null,null,"Relative Rougness of the pipe"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J6/1000","v":1E-3},null,null,"Pipe inside diameter"]
[{"$f":"IF(E5=1,\"Input Values for Single Phase Flow:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(E5=2,\"Input Values for Multi-phase Flow:\",\"\")","v":"Input Values for Multi-phase Flow:"},null,null,null,null,null,null,"Density of the fluid"]
[null,null,null,null,{"$f":"D10/1000","v":0},{"$f":"D11/1000","v":0},null,null,null,null,null,{"$f":"J11/1000","v":0.1}]
[null,null,null,null,null,{"$f":"39.37008*E9","v":0},null,null,null,null,null,{"$f":"39.37008*K7","v":3.9370080000000002E-2},null,"Viscosity of the fluid"]
[{"$f":"IF(E5=1,N7,\" \")","v":" "},null,null,null,{"$f":"IF(E5=1,\"mm\",\"\")","v":""},{"$f":"39.37008*F9","v":0},{"$f":"IF(E5=2,N16,\"\")","v":"Pipe inside diameter"},null,null,100,{"$f":"IF(E5=2,\"mm\",\"\")","v":"mm"},{"$f":"39.37008*L9","v":3.9370080000000005},null,"Mass flow rate of the fluid"]
[{"$f":"IF(E5=1,N8,\"\")","v":""},null,null,null,{"$f":"IF(E5=1,\"kg/m3\",\"\")","v":""},{"$f":"0.062426*D12","v":0},{"$f":"IF(E5=2,N17,\"\")","v":"Viscosity of the liquid"},null,null,1,{"$f":"IF(E5=2,\"cP\",\"\")","v":"cP"},{"$f":"J12","v":1},null," "]
[{"$f":"IF(E5=1,N10,\"\")","v":""},null,null,null,{"$f":"IF(E5=1,\"cP\",\"\")","v":""},{"$f":"D13","v":0},{"$f":"IF(E5=2,N18,\"\")","v":"Mass flow rate of the vapour"},null,null,1000,{"$f":"IF(E5=2,\"kg/hr\",\"\")","v":"kg/hr"},{"$f":"2.20462*J13","v":2204.62},null," "]
[{"$f":"IF(E5=1,N11,\"\")","v":""},null,null,null,{"$f":"IF(E5=1,\"kg/hr\",\"\")","v":""},{"$f":"2.20462*D14","v":0},{"$f":"IF(E5=2,N19,\"\")","v":"Mass flow rate of the liquid"},null,null,2000,{"$f":"IF(E5=2,\"kg/hr\",\"\")","v":"kg/hr"},{"$f":"2.20462*J14","v":4409.24},null," "]
[null,null,null,null,null,null,{"$f":"IF(E5=2,N20,\"\")","v":"Density of the liquid"},null,null,800,{"$f":"IF(E5=2,\"kg/m3\",\"\")","v":"kg/m3"},{"$f":"0.062426*J15","v":49.940800000000003},null," "]
[null,null,null,null,null,null,{"$f":"IF(E5=2,N21,\"\")","v":"Density of the vapour"},null,null,0.9,{"$f":"IF(E5=2,\"kg/m3\",\"\")","v":"kg/m3"},{"$f":"0.062426*J16","v":5.6183400000000001E-2},null,"Pipe inside diameter"]
[null,null,null,null,null,null,{"$f":"IF(E5=2,N22,\"\")","v":"Surface tension of liquid"},null,null,12,{"$f":"IF(E5=2,\"dyne/cm\",\"\")","v":"dyne/cm"},{"$f":"J17","v":12},null,"Viscosity of the liquid"]
[null,null,null,null,null,null,{"$f":"IF(E5=2,N23,\"\")","v":"Viscosity of the vapour"},null,null,8.9999999999999993E-3,{"$f":"IF(E5=2,\"cP\",\"\")","v":"cP"},{"$f":"J18","v":8.9999999999999993E-3},null,"Mass flow rate of the vapour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mass flow rate of the liquid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Density of the liquid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Density of the vapour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface tension of liquid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Viscosity of the vapour"]

{"sheet":"Calculations","index":2,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,7,45,10],[45,0,45,4],[39,7,39,8],[39,9,39,10],[8,0,8,1],[9,0,9,1],[8,5,8,6],[9,5,9,6],[10,5,10,6],[10,0,10,1],[11,0,11,1],[12,5,12,6],[14,5,14,6],[15,5,15,6],[11,5,11,6],[13,5,13,6],[1,0,1,11],[5,0,5,1],[6,0,6,1],[7,0,7,1],[6,5,6,6],[5,5,5,6],[7,5,7,6]]}
[]
["DELTA-P CALCULATIONS FOR SINGLE AND MULTI-PHASE VAPOR-LIQUID FLOWS"]
[]
[]
[]
["E =",null,{"$f":"PI()*('Process Input'!F11/24)^2","v":0},null,null,"E =",null,{"$f":"3.14*('Process Input'!L11/24)^2","v":8.4496702178960034E-2}]
["Velocity, U =",null,{"$f":"'Process Input'!F14/(3600*'Process Input'!F12*C6)","v":{"$error":"#DIV/0!"}},"ft/sec",{"$f":"C7*0.3048","v":{"$error":"#DIV/0!"}},"(pro V)^.5 =",null,{"$f":"'Process Input'!L16^0.5","v":0.23703037779997738}]
["Reynold's No. , Nre =",null,{"$f":"123.9*'Process Input'!F11*C7*'Process Input'!F12/'Process Input'!F13","v":{"$error":"#DIV/0!"}},"N/A",null,"Bx =",null,{"$f":"531*('Process Input'!L14/'Process Input'!L13)*(('Process Input'!L12^0.33)/'Process Input'!L17)*(H7/('Process Input'!L15^0.166))","v":10.959826201525596}]
["A =",null,{"$f":"(((LN(1/(((7/C8)^0.9)+('Process Input'!F10/'Process Input'!F11))))*2.45)^16)","v":{"$error":"#DIV/0!"}},null,null,"(pro V*pro L)^.5 =",null,{"$f":"('Process Input'!L15*'Process Input'!L16)^0.5","v":1.6750653547608225}]
["B =",null,{"$f":"(37530/C8)^16","v":{"$error":"#DIV/0!"}},null,null,"By =",null,{"$f":"2.16*'Process Input'!L13/(H6*H9)","v":33644.647202641521}]
["Friction factor, f =",null,{"$f":"8*((((8/C8)^12)+(1/((C9+C10)^1.5)))^0.08)","v":{"$error":"#DIV/0!"}},null,null,"Avg. fluid density, D =",null,{"$f":"(('Process Input'!L13+'Process Input'!L14)/(('Process Input'!L14/'Process Input'!L15)+('Process Input'!L13/'Process Input'!L16)))","v":0.16817181341980544},"lb/ft3"]
["Pressure drop, P =",null,{"$f":"0.129*C11*'Process Input'!F12*C7^2/'Process Input'!F11","v":{"$error":"#DIV/0!"}},"psi/100 ft. of pipe",null,"Total flow rate, Q =",null,{"$f":"'Process Input'!L13+'Process Input'!L14","v":6613.86},"lb/hr"]
[null,null,null,null,null,"Flow regime is  ",null,{"$f":"IF(J34=\"D\",\"Dispersed\",IF(J34=\"A\",\"Annular\",IF(J34=\"S\",\"Slug\",\"Bubble\")))","v":"Dispersed"}]
[null,null,null,null,null,"Velocity, U =",null,{"$f":"H12/(3600*H11*D36)","v":129.28839092954186},"ft/sec",{"$f":"H14*0.3048","v":39.40710155532436}]
[null,null,null,null,null,"Prssure Drop =",null,{"$f":"J36","v":7.9893425226507837},"psi/100 ft. of pipe"]
[null,null,null,null,null,"Phi SQ =",null,{"$f":"H15/G45","v":3.4110824085499973}]
[{"$f":"IF(C8<2100,\"Laminar\",IF(C8>4500,\"Turbulent\",\"Transition\"))","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Selection of regime"]
[null,null,null,null,null,null,null,"Cond",1,{"$f":"IF(H10>=80000,\"D\",\"N\")","v":"N"}]
[null,null,null,null,null,null,null,"Cond",2,{"$f":"IF(J31=\"D\",\"D\",IF(H10<=4000,\"A,S\",\"N\"))","v":"N"}]
[null,null,"Dispersed/Annular/Slug/Bubble",null,null,null,null,"Cond",3,{"$f":"IF(J32=\"D\",\"D\",IF(J32=\"A,S\",IF(H8<=20,\"A\",\"S\"),\"N\"))","v":"N"}]
[null,null,"D =",{"$f":"'Process Input'!L15","v":49.940800000000003},null,"Now,",null,"Cond",4,{"$f":"IF(J33=\"D\",\"D\",IF(J33=\"A\",\"A\",IF(J33=\"S\",\"S\",IF(H8>=300,\"B\",IF(H10<=30000,\"A\",\"D\")))))","v":"D"}]
[null,null,"Q =",{"$f":"'Process Input'!L14","v":4409.24},null,"H =",{"$f":"D42","v":1.1355250120245478E-2}]
[null,null,"E =",{"$f":"H6","v":8.4496702178960034E-2},null,"D =",{"$f":"'Process Input'!L16","v":5.6183400000000001E-2},null,"Delta P =",{"$f":"IF(J34=\"D\",B50,IF(J34=\"A\",J50,IF(J34=\"S\",I42,K42)))","v":7.9893425226507837},"psi"]
[null,null,"U =",{"$f":"D35/(3600*D34*D36)","v":0.29024582648188496},null,"Q =",{"$f":"'Process Input'!L13","v":2204.62}]
[null,null,"Nre =",{"$f":"123.9*'Process Input'!L11*D37*D34/'Process Input'!L12","v":7070.6458040068483},null,"V =",{"$f":"'Process Input'!L18","v":8.9999999999999993E-3}]
[null,null,"A =",{"$f":"(((LN(1/(((7/D38)^0.9)+('Process Input'!L10/'Process Input'!L11))))*2.45)^16)","v":3.6380045735107056E+16},null,"U =",{"$f":"G37/(3600*G36*D36)","v":128.99814510305998}]
[null,null,"B =",{"$f":"(37530/D38)^16","v":396927979842.5498},null,"Nre =",{"$f":"123.9*'Process Input'!L11*G39*G36/G38","v":392813.65577815828},"Slug",null,"Bubble"]
[null,null,"W =",{"$f":"8*((((8/D38)^12)+(1/((D39+D40)^1.5)))^0.08)","v":8.237317949632432E-2},null,"A =",{"$f":"(((LN(1/(((7/G40)^0.9)+('Process Input'!L10/'Process Input'!L11))))*2.45)^16)","v":6.7698543950599672E+16},"M =",{"$f":"(((1190*((G46^0.5)^0.815))/('Process Input'!L14/H6)^0.5)^2)","v":0.35262728391101011},"M =",{"$f":"((14.2*((G46^0.5)^0.75)/(('Process Input'!L14/H6)^0.1))^2)","v":0.42194447021724696}]
[null,null,"P =",{"$f":"(0.129*D41*D34*D37^2)/'Process Input'!L11","v":1.1355250120245478E-2},null,"B =",{"$f":"(37530/G40)^16","v":4.8202747751197574E-17},"C =",{"$f":"I41*G45","v":0.82591383513207495},"C =",{"$f":"K41*G45","v":0.98826662459233794}]
[null,null,null,null,null,"W =",{"$f":"8*((((8/G40)^12)+(1/((G41+G42)^1.5)))^0.08)","v":7.6457565883203127E-2}]
[null,null,null,null,null,"P =",{"$f":"(0.129*G43*G36*G39^2)/'Process Input'!L11","v":2.3421722391183564}]
[null,null,null,null,null,"T =",{"$f":"G44","v":2.3421722391183564}]
["Dispersed",null,null,null,null,"Z =",{"$f":"G35/G45","v":4.8481703995090627E-3},"Annular"]
[null,"Z=<.1",null,"Z=<.5",null,"Else",null,null,"I<=10","Else"]
["M =",{"$f":"((36.67*(G46-0.01))+3.6)","v":3.4110824085499973},"M =",{"$f":"((14.75*(G46-0.1))+6.9)","v":5.4965105133927592},"M =",{"$f":"((6.71*(-0.5))+12.8)","v":9.4450000000000003},null,"M =",{"$f":"(((4.8-(0.31*'Process Input'!L11))*((G46^0.5)^(0.34-(0.02*'Process Input'!L11))))^2)","v":3.1840938321430903},"M =",{"$f":"((1.68*((G46^0.5)^0.13))^2)","v":1.4117041365804377}]
["Since Z =",{"$f":"G46","v":4.8481703995090627E-3},"Thus, M =",{"$f":"IF(G46<=0.1,B48,IF(G46<=0.5,D48,F48))","v":3.4110824085499973},null,null,null,"For  I =",{"$f":"'Process Input'!L11","v":3.9370080000000005},"Thus, M =",{"$f":"IF('Process Input'!L11<=10,Calculations!I48,Calculations!K48)","v":3.1840938321430903}]
["C =",{"$f":"D49*G45","v":7.9893425226507837},null,null,null,null,null,null,"C =",{"$f":"K49*G45","v":7.4576961803935298}]

{"sheet":"Results","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,8],[6,4,6,5],[13,3,13,5],[13,6,13,8],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[18,3,18,5],[18,6,18,8],[14,3,14,5],[14,6,14,8],[15,3,15,5],[15,6,15,8],[16,3,16,5],[17,3,17,5],[17,6,17,8]]}
["Pressure drop calculation of Single or Multiphase Vapor Liquid Flow:  Results"]
[]
[]
[]
[]
["Results:"]
["Phase of flow ",null,null,null,{"$f":"IF('Process Input'!E5=1,\"Single-phase\",\"Multi-phase\")","v":"Multi-phase"}]
[{"$f":"IF(E7=\"Single\",\"\",\"Flow Regime is \")","v":"Flow Regime is "},null,null,null,{"$f":"IF(E7=\"Single-phase\",Calculations!A17,Calculations!H13)","v":"Dispersed"},"flow"]
["Velocity ",null,null,null,{"$f":"IF(E7 = \"Single-phase\",Calculations!E7,Calculations!J14)","v":39.40710155532436},"m/sec"]
["Pressure drop ",null,null,null,{"$f":"IF(E7 = \"Single-phase\",Calculations!C12,Calculations!H15)","v":7.9893425226507837},"psi/100ft of pipe"]
[null,null,null,null,{"$f":"E10*0.48/100000","v":3.8348844108723762E-5},"bar/m of pipe"]
[]
[]
[null,null,null,"Client",null,null,{"$f":"'General Input'!D8","v":"XYZ"}]
[null,null,null,"Location",null,null,{"$f":"'General Input'!D10","v":"Pune"}]
[null,null,null,"Item No.",null,null,{"$f":"'General Input'!D9","v":"Line#101"}]
[null,null,null,"Design Engr",null,null,{"$f":"'General Input'!D11","v":"abc"}]
[null,null,null,"Revision No.",null,null,{"$f":"'General Input'!E11","v":0}]
[null,null,null,"Date",null,null,{"$f":"NOW()","v":"2020-09-26T21:44:03.010"}]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}