{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calculation","Viscosity","Sheet4","Eq. List","Fig.20-3","Fig.20-70","Fig.20-71","Z factor MW 18.85"],"not_rendered":{"charts":0,"images":8,"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":"Calculation","index":0,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[45,5,45,8]]}
[]
[null,"DESIGN OF SOLID desiccant DRYER "]
[null,"Based on GPSA"]
[]
[null,"DATA"]
[null,"Gas flow",null,100,"MMSCFD",null,"Input/Selected"]
[null,"Pressure at inlet condition",null,600,"PSIA",null,"Determined"]
[null,"Temperature at inlet condition",null,100,"oF",null,"Calculated"]
[null,null,null,{"$f":"D8+460","v":560},"R"]
[null,"Molecular Weight",null,18]
[null,"Required outlet dew point",null,-150,"oF"]
[null,"Miu","Viscosity",1.4999999999999999E-2,"cP"]
[null,"Compressibility Factor",null,0.93,null,"(Based on Z factor figure)"]
[null,"Rho","Density",{"$f":"D7*D10/(D13*10.7316*D9)","v":1.9323611753084431},"lb/ft3"]
[null,"Regeneration temperature",null,500,"oF"]
[]
[null,"PARAMETERS TO BE DETERMINED"]
[null,"desiccant type",null,"Mole Sieve Davison-4A"]
[null,"Particles Type",null,"1/8\" bead"]
[null,"B","Constant (function of particles type)",{"$f":"VLOOKUP(D19,Sheet4!$B$3:$D$6,2,FALSE)","v":5.6000000000000001E-2}]
[null,"C","Constant (function of particles type)",{"$f":"VLOOKUP(D19,Sheet4!$B$3:$D$6,3,FALSE)","v":8.8900000000000006E-5}]
[null,"Z",null,{"$f":"VLOOKUP(D19,Sheet4!$B$3:$E$6,4,FALSE)","v":1.7}]
[null,"Inlet Water Content",null,70,"lb/MMscf","(Fig. 20-3)"]
[null,"Outlet Water Content ",null,0,"lb/MMscf","(Fig. 20-3)"]
[null,"Type of molecular sieve",null,{"$f":"VLOOKUP(D18,Sheet4!$B$13:$C$18,2,FALSE)","v":"Spherical"}]
[null,"Bulk density of molecular sieve",null,{"$f":"VLOOKUP(D18,Sheet4!$B$13:$D$18,3,FALSE)","v":"42-45"},"lb/ft3"]
[null,"Selected bulk density of molecular sieve",null,45,"lb/ft3"]
[null,"Heat capacity of desiccant",null,{"$f":"VLOOKUP(D18,Sheet4!$B$13:$F$18,5,FALSE)","v":0.24},"Btu/(lb F)"]
[]
[null,"DIMENSION CALCULATION"]
[null,"Water to be removed",null,{"$f":"(D23-D24)*D6","v":7000},"lb/day"]
[null,"V","Superficial vapor velocity",41.40820959408385,"ft/min","(Guess)"]
[null,"Delta P/L","Pressure drop per length of packed bed",{"$f":"D20*D12*D32+D21*D14*D32^2","v":0.32933557020905363},"psi/ft","(Eq. 20-9). Use goal seek to get 0,333"]
[null,"Status",null,{"$f":"IF(D33<0.333,\"OK\",\"Redesign\")","v":"OK"},null,"(Maximum 0,333 psi/ft)"]
[]
[null,"Gas flow rate at standard condition",null,{"$f":"D6*1000000/24/60","v":69444.444444444438},"scfm"]
[null,"Temperature at standard condition",null,14.7,"psia"]
[null,"Pressure at standard condition",null,60,"F"]
[null,null,null,{"$f":"D38+460","v":520},"R"]
[null,"q","Gas flow at actual condition",{"$f":"(D36*D37/D39)*(D9/D7)","v":1832.2649572649568},"acfm"]
[null,"D","Diameter",{"$f":"(4*D40/(PI()*D32))^0.5","v":7.5059552471203661},"ft","(Eq. 20-10)"]
[]
[null,"Actual gas velocity",null,{"$f":"4*D40/(PI()*D41^2)","v":41.40820959408385},"ft/min"]
[null,"Act Delta P/L","Pressure drop per length of packed bed",{"$f":"D20*D12*D43+D21*D14*D43^2","v":0.32933557020905363},"psi/ft"]
[]
[null,"Cycle time",null,12,null,"(8-12 hours). For 24-hour cycle consisting of 12 hours adsorbing and 12 hours regenerating (for two towers). 12 hours regenerating consists of heating, cooling, standby, valve switching; the heating time is usually 50%-60% of total regeneration time."]
[null,"Percentage of heating time",null,0.6,null,"(Usually 50%-60%)"]
[null,"Wr","Water removed per cycle",{"$f":"D6*(D23-D24)/24*D46","v":3500},"lb"]
[null,"Css","Saturation correction factor for sieve",1,null,"(Fig. 20-70)"]
[null,"CT","Temperature correction factor",0.93,null,"(Fig. 20-71)"]
[null,"Saturation capacity",null,0.13,null,"(Assumes 13 lb water per 100 lb desiccant)"]
[null,"Ss","Amount of mol sieve required at saturation zone",{"$f":"D48/(D51*D49*D50)","v":28949.545078577336},"lb"]
[null,"Ls","Length of packed at saturation zone",{"$f":"D52*4/(PI()*D41^2*D27)","v":14.538761323356193},"ft"]
[]
[null,"Lmtz","Length of mass transfer zone",{"$f":"(D32/35)^0.3*D22","v":1.7879461892117936},"ft"]
[]
[null,null,"Total bed height",{"$f":"D53+D55","v":16.326707512567985},"ft"]
[null,"Free space above and below the bed",null,3,"ft"]
[null,null,"Total length of vessel",{"$f":"D57+D58","v":19.326707512567985},"ft"]
[]
[null,"Pressure drop",null,{"$f":"D59*D33","v":6.3649722389151782},"psi","(Pressure drop should be about 5-8 psi)"]
[null,null,null,{"$f":"IF(AND(D61>=5,D61<=8),\"OK\",IF(D61<5,\"Add bed height\",\"Add diameter\"))","v":"OK"}]
[null,"REGENERATION CALCULATION"]
[null,"Qw","Desorption of water heat duty",{"$f":"1800*D48","v":6300000},"Btu","(Eq. 20-14)"]
[null,"Qsi","Duty required to heat molecular sieve to regeneration temperature",{"$f":"PI()*D41^2*D57*D27/4*D28*(D15-D8)","v":3120931.108388925},"Btu"]
[]
[null,"Duty required to heat vessel and piping to regeneration temperature"]
[null,"t","Thickness of vessel",{"$f":"(12*D41*110%*(D7-14.7))/(37600-1.2*110%*(D7-14.7))+0.0625","v":1.6371619012581518},"in"]
[null,"msteel","Weight of steel",{"$f":"155*(D68+0.125)*(D59+0.75*D41)*D41","v":51163.645396421496},"lb"]
[null,"Heat capacity of steel",null,0.122,"Btu/(lb F)"]
[null,"Qst","Duty required to heat vessel and piping to regeneration temperature",{"$f":"D69*D70*(D15-D8)","v":2496785.8953453694},"Btu"]
[null,"Qh","Heat loss",{"$f":"10%*(D64+D65+D71)","v":1191771.7003734296},"Btu"]
[null,"Qtr","Total regeneration heat duty",{"$f":"2.5*(D64+D65+D71+D72)","v":32773721.76026931},"Btu"]
[]
[null,"Heat capacity of regen gas",null,0.65,"Btu/(lb F)"]
[null,"Rate of regen gas",null,{"$f":"D73/(D75*(D15+50-D6)*D46*D47)","v":15562.071111238989},"lb/hr"]
[null,null,null,{"$f":"D76/60","v":259.36785185398315},"lb/min"]
[]
[null,"Verification of pressure drop during regeneration to prevent channeling"]
[]
[null,"Gas molecular weight for regeneration",null,17]
[null,"Density of gas for regeneration",null,{"$f":"D7*D81/(1*10.7316*(D15+50+460))","v":0.94105351494559042},"lb/ft3"]
[null,"Velocity of regeneration gas",null,{"$f":"4*D77/(PI()*D41^2*D82)","v":6.228737106734183},"ft/min"]
[null,"Viscosity of regeneration gas",null,2.3E-2,"cP","(From graph)"]
[null,"Delta P/L",null,{"$f":"D20*D84*D83+D21*D82*D83^2","v":1.1268371007559057E-2},"psi/ft"]
[null,null,null,{"$f":"IF(D85<=0.11,\"OK\",\"Redesign\")","v":"OK"},null,"Pressure drop should be maintain at 0.01 psi/ft"]

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

{"sheet":"Sheet4","index":2,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Particle Type","B","C","Z"]
[null,"1/8\" bead",5.6000000000000001E-2,8.8900000000000006E-5,1.7]
[null,"1/8\" extrudate",7.22E-2,1.2400000000000001E-4,1.7]
[null,"1/16\" bead",0.152,1.36E-4,0.85]
[null,"1/16\" extrudate",0.23799999999999999,2.1000000000000001E-4,0.85]
[]
[]
[null,null,"Spherical","42-45"]
[null,null,"Extruded","40-44"]
[]
[null,"Desiccant","Shape","Bulk Density (lb/ft3)","Particle Size","Heat Capacity (Btu/lb F)","Approx. Minimum Moisture Content of Effluent Gas (ppmw)"]
[null,"Alumina Gel Alcoa H-151","Spherical",52,"1/4\"",0.2,"5-10"]
[null,"Activated Alumina Alcoa F-1","Granular",52,"1/4\"-8 mesh",null,0.1]
[null,"Silica Gel Sorbed-R","Spherical",49,"4-8 mesh",0.25,"5-10"]
[null,"Silica Gel Sorbead-H","Spherical",45,"3-8 mesh",0.25,"5-10"]
[null,"Mole Sieve Davison-4A","Spherical","42-45","4-8 mesh or 8-12 mesh",0.24,0.1]
[null,"Mole Sieve Linde-4A","Extruded Cylinder","40-44","1/8\" or 1/16\"",0.24,0.1]
[]
[]
[null,"Feed Rate","10 to 1500 MMSCFD"]
[null,"Superficial velocity","Approximately 30 to 35 ft/min (9 to 11 m/min)"]
[null,"Pressure drop","Approximately 5 psi, not to exceed 10 psi"]
[null,"Cycle time","4 to 24 hours; 8 or a multiple thereof is common"]
[null,"Temperatures and pressures"]
[null,"Adsoption"]
[null,null,"Temperature : 50 to 115 F"]
[null,null,"Pressure: to 1500 psig"]
[]
[null,"Regeneration","Temperature: 400 to 600 F"]
[null,null,"Pressure: adsorption pressure or lower"]

{"sheet":"Eq. List","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Fig.20-3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Fig.20-70","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Fig.20-71","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Z factor MW 18.85","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}