{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["例題32 非等温PBR","BASIC化プロ1985","Stream report"],"not_rendered":{"charts":3,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"例題32 非等温PBR","index":0,"n_rows":72,"n_cols":25,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["微分方程式数",2,null,null,null,"Pt=",126.7,"kPa","全圧",null,null,null,"L","触媒量W","元問題条件",null,"化学工学会編：BASICによる化学工学プログラミング, p. 149, 例題10.3, 培風館 (1985)"]
["W=","xA=","T=",null,null,"T0=",398.15,"K",null,null,null,null,"m","kg","R0=",2.5000000000000001E-2,"m","反応管半径"]
[0.60000000000000042,0.99543163412369617,462.9045215661211,null,null,"FA0=",2.48E-3,"mol/s","Benzene",null,null,null,0.1,{"$f":"M3*3.14*$P$2^2*$P$4","v":0.2355000000000001},"A",{"$f":"3.14*P2^2","v":1.9625000000000003E-3},"m2","管断面積"]
[null,"xA'=","T'=",null,null,"FB0=",7.4399999999999994E-2,"mol/s","Hydrogen",null,null,null,0.2,{"$f":"M4*3.14*$P$2^2*$P$4","v":0.4710000000000002},"ρB=",1200,"kg/m3","触媒層密度"]
["微分方程式→",{"$f":"G21/G3","v":8.0309205428595959E-2},{"$f":"((-1*G26*G25*(C3-G24)/G27)+(-G21)*(G23))/(G8*G22)","v":-169.60891963540635},null,null,"FA=",{"$f":"G3*(1-B3)","v":1.1329547373233488E-5},"mol/s","Benzene",null,null,null,0.25,{"$f":"M5*3.14*$P$2^2*$P$4","v":0.58875000000000011},"Tw=",373.15,"K","壁温度"]
[null,null,null,null,null,"FB= ",{"$f":"G4-G3*B3","v":7.1931329547373232E-2},"mol/s","Hydrogen",null,null,null,0.255,{"$f":"M6*3.14*$P$2^2*$P$4","v":0.6005250000000002},"h0=",75.400000000000006,"J/(m2 s K)","伝熱係数"]
["積分区間W=[a,",0,null,null,null,"FC=",{"$f":"G3*B3","v":2.4686704526267664E-3},"mol/s","Cyclohexan",null,null,null,null,null,"Pt=",1.292,"Kg/cm2","全圧"]
["b]",0.6,null,null,null,"ΣFi=",{"$f":"SUM(G5:G7)","v":7.4411329547373228E-2},"mol/s",null,null,null,null,null,null,"G=",0.17530000000000001,"kg/(m2 s)","質量速度",null,{"$f":"K3*P12/P3","v":0}]
["積分刻み幅ΔW",0.01,null,null,null,"c0=",{"$f":"1/(0.0224*(101/G1)*(G2/273.15))","v":38.420384563258544},"mol/m3","入口原料全濃度",null,null,null,null,null,"T0=",398.15,"K","入口ガス温度"]
["計算結果",null,null,null,null,"c=",{"$f":"1/(0.0224*(101/G1)*(C3/273.15))","v":33.045855897254086},"mol/m3","原料全濃度(温度圧力変化)",null,null,null,null,null,"yB0=",3.2300000000000002E-2,null,"入口ﾍﾞﾝｾﾞﾝモル分率"]
["W[kg]","xA","T[K]",null,null,"cA0=",{"$f":"G3/G12","v":1.2393672439760821},"mol/m3","ベンゼン供給濃度",null,null,null,null,null,"θH=",30,null,"水素の流量比"]
[0,0,{"$f":"P9","v":398.15},null,"←初期値","F0=",{"$f":"(G3+G4)/G9","v":2.0010210952838932E-3},"m3/s","入口原料ガス",null,null,null,null,null,"Mav=",4.47E-3,"kg/mol","反応ガス平均分子量"]
[0.01,3.5799539187770575E-2,404.90661570570916,null,null,"F=",{"$f":"G8/G10","v":2.2517597903571433E-3},"m3/s",null,null,null,null,null,null,"Cp=",7270,"J/(kg K)","反応ガス熱容量"]
[0.02,8.4339462899707257E-2,414.12390346007157,null,null,"cA=",{"$f":"G5/G13","v":5.0314191690209332E-3},"mol/m3","Benzene",null,null,null,null,null,"ΔH=",-206000,"J/mol","反応熱"]
[3.0000000000000002E-2,0.15440744186931216,427.55323719841175,null,null,"cB=",{"$f":"G6/G13","v":31.944495081317918},"mol/m3","Hydrogen"]
[0.04,0.25605084802302003,447.18603754442961,null,null,"cC=",{"$f":"G7/G13","v":1.0963293967671479},"mol/m3","Cyclohexan",null,null,null,null,null,"GA=",{"$f":"P8*3.14*P2^2","v":3.4402625000000013E-4},"kg/s","全供給"]
[4.9999999999999996E-2,0.36947755069468557,468.88506584864882,null,null,"k=",{"$f":"3214000*EXP(-6093/C3)","v":6.1748542109998867},null,null,null,null,null,null,null,"Fmol=",{"$f":"P16/P12","v":7.6963366890380344E-2},"mol/s","全供給"]
[5.9999999999999991E-2,0.45205612982747567,483.87907842468508,null,null,"KA=",{"$f":"0.00000008769*3.72*EXP(5640/C3)","v":6.3813131894804462E-2},null,null,null,null,null,null,null,"F0",{"$f":"P17*22.4*0.001*(P9/273)*(101.15/G1)","v":2.0072682812681741E-3},"m3/s","全供給"]
[6.9999999999999993E-2,0.50576399448703413,492.67297465071965,null,null,"KB=",{"$f":"0.000000001044*3.72*EXP(7805/C3)","v":8.1630340473586138E-2}]
[0.08,0.54369545535357056,498.0573081182535,null,null,"KC=",{"$f":"0.000000565*3.73*EXP(4481/C3)","v":3.3713736624826705E-2}]
[9.0000000000000011E-2,0.57296951230262039,501.55566295611726,null,null,"-rA'=",{"$f":"G17*G19^3*G18*G15^3*G14/(1+G19*G15+G18*G14+G20*G16)^4","v":1.9916682946291797E-4},"mol/kg-s",null,null,null,null,null,null,"k",{"$f":"3214000*EXP(-6093/P9)","v":0.72596691712491934},"mol/kg-s"]
[0.10000000000000002,0.59706338107321977,503.91828385625814,null,null,"Cp=",32.496899999999997,"J/mol-K","ガス熱容量",null,null,null,null,null,"KB,KA,KCはpA[kPa]=(pt/c)cA[mol/m3]で係数を変換c=34.0 (450Kの値）を使用"]
[0.11000000000000003,0.61780663435116334,505.54340430502356,null,null,"ΔrH=",-206000,"J/mol","反応熱(発熱)",null,null,null,null,null,"-rA'=((3214000*EXP(-6093/T))*(3.88e-9*exp(7805/T))^3*(3.26e-7*exp(5640/T))*C(Hydrogen)^3*C(Benzene))/(1+(3.88e-9*exp(7805/T))*C(Hydrogen)+(3.26e-7*exp(5640/T))*C(Benzene)+(1.84e-6*exp(4481/T))*C(Cyclohexane))^4"]
[0.12000000000000004,0.63624653502519735,506.6609985546616,null,null,"Ta=",373.15,"K"]
[0.13000000000000003,0.65302598181259497,507.41347880547636,null,null,"a=",80,"/m"]
[0.14000000000000004,0.66856200513977915,507.89401906331813,null,null,"U=",75.400000000000006,"J/m2- s- K",null,null,null,null,"COCO計算結果",null,null,null,null,null,null,"CCO",null,null,null,"Excel"]
[0.15000000000000005,0.68313701166103025,508.16625526282246,null,null,"ρb=",1200,"kg/m3",null,null,null,null,"L","V","触媒量W","T","T K","Benzene","xA",null,"rxn1 rate",null,null,"W","-rA'="]
[0.16000000000000006,0.69694875514348686,508.27513466771569,null,null,null,null,null,null,null,null,null,"m","m3","kg",null,null,null,null,null,"kmol/h kg","mol/s kg",null,0,7.7499999999999999E-3]
[0.17000000000000007,0.71013934450952754,508.25324925740358,null,null,null,null,null,null,null,null,0,0,{"$f":"3.14*$P$2^2*M29","v":0},{"$f":"N29*$G$27","v":0},125,{"$f":"P29+273","v":398},8.8999999999999999E-3,{"$f":"1-R29/$R$29","v":0},0,2.7900000000000001E-2,{"$f":"U29*1000/3600","v":7.7500000000000008E-3},null,0.03,2.1100000000000001E-2]
[0.18000000000000008,0.72281293038197703,508.12471889912848,null,null,null,null,null,null,null,null,1,1.2749999999999999E-2,{"$f":"3.14*$P$2^2*M30","v":2.5021875000000003E-5},3.0026250000000004E-2,157.4,{"$f":"P30+273","v":430.4},7.4799999999999997E-3,0.15955056179775284,1.4999999999999999E-2,4.4499999999999998E-2,{"$f":"U30*1000/3600","v":1.2361111111111111E-2},null,4.4999999999999998E-2,2.87E-2]
[0.19000000000000009,0.73504694704256512,507.90767334894502,null,null,null,null,null,null,null,null,2,2.5499999999999998E-2,{"$f":"3.14*$P$2^2*M31","v":5.0043750000000007E-5},6.0052500000000009E-2,215.2,488.2,4.8599999999999997E-3,0.45393258426966299,3.0026250000000004E-2,8.2699999999999996E-2,{"$f":"U31*1000/3600","v":2.297222222222222E-2},null,0.06,1.592E-2]
[0.20000000000000009,0.74689951640028562,507.61589595717845,null,null,null,null,null,null,null,null,3,3.8249999999999999E-2,7.506562500000001E-5,9.0078750000000013E-2,230.7,503.7,3.9100000000000003E-3,0.56067415730337067,4.4999999999999998E-2,0.1,2.7777777777777776E-2,null,7.4999999999999997E-2,9.3200000000000002E-3]
[0.2100000000000001,0.75841447518909777,507.25994584846313,null,null,null,null,null,null,null,null,4,5.0999999999999997E-2,1.0008750000000001E-4,0.12010500000000002,235.2,508.2,3.3890000000000001E-3,0.61921348314606739,6.0052500000000009E-2,5.0700000000000002E-2,{"$f":"U33*1000/3600","v":1.4083333333333335E-2},null,0.09,6.4999999999999997E-3]
[0.22000000000000011,0.76962487926067624,506.84794440558926,null,null,null,null,null,null,null,null,5,6.3750000000000001E-2,1.2510937500000003E-4,0.15013125000000005,236.4,509.4,2.99E-3,0.66404494382022472,9.0078750000000013E-2,2.12E-2,5.8888888888888888E-3,null,0.12,4.3400000000000001E-3]
[0.23000000000000012,0.78055550245560146,506.38613912117756,null,null,null,null,null,null,null,null,6,7.6499999999999999E-2,1.5013125000000002E-4,0.18015750000000003,236.3,509.3,2.66E-3,0.70112359550561798,0.12010500000000002,1.4500000000000001E-2,4.0277777777777777E-3,null,0.15,3.5100000000000001E-3]
[0.24000000000000013,0.79122465398014696,505.87931587046836,null,null,null,null,null,null,null,null,7,8.9249999999999996E-2,1.7515312500000001E-4,0.21018375,235.4,508.4,2.3600000000000001E-3,0.73483146067415728,0.15013125000000005,1.18E-2,3.2777777777777775E-3,null,0.17,3.2000000000000002E-3]
[0.25000000000000011,0.80164552302780234,505.33110557208909,null,null,null,null,null,null,null,null,8,0.10199999999999999,2.0017500000000003E-4,0.24021000000000003,234,507,2.0699999999999998E-3,0.76741573033707866,0.18015750000000003,1.0500000000000001E-2,2.9166666666666668E-3,null,0.2,2.8999999999999998E-3]
[0.26000000000000012,0.81182718875812165,504.74421576864944,null,null,null,null,null,null,null,null,9,0.11475,2.2519687500000004E-4,0.27023625000000007,232.3,505.3,1.81E-3,0.79662921348314608,0.21018375,9.6699999999999998E-3,2.6861111111111109E-3,null,0.3,2.2699999999999999E-3]
[0.27000000000000013,0.82177538927790661,504.12060790599816,null,null,null,null,null,null,null,null,10,0.1275,2.5021875000000006E-4,0.3002625000000001,230.4,503.4,1.57E-3,0.82359550561797756,0.24021000000000003,8.9999999999999993E-3,2.5000000000000001E-3,null,0.4,1.6000000000000001E-3]
[0.28000000000000014,0.83149311460584885,503.46163477946652,null,null,null,null,null,null,null,null,11,0.14025000000000001,2.7524062500000005E-4,0.33028875000000008,228.2,501.2,1.33E-3,0.85056179775280905,0.27023625000000007,8.5000000000000006E-3,2.3611111111111111E-3,null,0.5,7.7999999999999999E-4]
[0.29000000000000015,0.84098106973865228,502.76814844576279,null,null,null,null,null,null,null,null,12,0.153,3.0026250000000004E-4,0.36031500000000005,225.7,498.7,1.1100000000000001E-3,0.87528089887640448,0.3002625000000001,8.0000000000000002E-3,2.2222222222222222E-3,null,0.6,2.0000000000000001E-4]
[0.30000000000000016,0.85023804129982117,502.04058609321601,null,null,null,null,null,null,null,null,13,0.16575000000000001,3.2528437500000009E-4,0.39034125000000008,223,496,9.1E-4,0.89775280898876408,0.33028875000000008,7.4999999999999997E-3,2.0833333333333333E-3]
[0.31000000000000016,0.85926119266044509,501.27903944525809,null,null,null,null,null,null,null,null,14,0.17849999999999999,3.5030625000000002E-4,0.42036750000000001,220,493,7.2999999999999996E-4,0.91797752808988764,0.36031500000000005,6.9800000000000001E-3,1.9388888888888891E-3]
[0.32000000000000017,0.86804630651239889,500.48331194462548,null,null,null,null,null,null,null,null,15,0.19125,3.7532812500000006E-4,0.45039375000000009,216.7,489.7,5.6999999999999998E-4,0.93595505617977526,0.39034125000000008,6.4000000000000003E-3,1.7777777777777779E-3]
[0.33000000000000018,0.87658798977828079,499.65296703801255,null,null,null,null,null,null,null,null,16,0.20399999999999999,4.0035000000000005E-4,0.48042000000000007,213.1,486.1,4.2999999999999999E-4,0.95168539325842694,0.42036750000000001,5.7000000000000002E-3,1.5833333333333333E-3]
[0.34000000000000019,0.88487985288914583,498.78737022755519,null,null,null,null,null,null,null,null,17,0.21675,4.2537187500000004E-4,0.5104462500000001,209.1,482.1,3.1E-4,0.96516853932584268,0.45039375000000009,5.0499999999999998E-3,1.4027777777777777E-3]
[0.3500000000000002,0.89291467346528286,497.88572709173513,null,null,null,null,null,null,null,null,18,0.22950000000000001,4.5039375000000009E-4,0.54047250000000013,204.8,477.8,2.1499999999999999E-4,0.97584269662921352,0.48042000000000007,4.3E-3,1.1944444444444444E-3]
[0.36000000000000021,0.90068455302447592,496.94711914411829,null,null,null,null,null,null,null,null,19,0.24224999999999999,4.7541562500000008E-4,0.57049875000000005,200.2,473.2,1.4300000000000001E-4,0.9839325842696629,0.5104462500000001,3.5000000000000001E-3,9.7222222222222219E-4]
[0.37000000000000022,0.90818107431093664,495.97053914875681,null,null,null,null,null,null,null,null,20,0.255,5.0043750000000012E-4,0.6005250000000002,195.3,468.3,9.0000000000000006E-5,0.98988764044943822,0.54047250000000013,2.7000000000000001E-3,7.5000000000000002E-4]
[0.38000000000000023,0.91539546601755961,494.95492730944682,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57049875000000005,2E-3,5.5555555555555556E-4]
[0.39000000000000024,0.92231878091180863,493.89920956372089,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6005250000000002,1.4E-3,3.8888888888888887E-4]
[0.40000000000000024,0.92894209252222937,492.80233901012377]
[0.41000000000000025,0.93525671444637171,491.66334124763239]
[0.42000000000000026,0.9412544448486263,490.48136407805191]
[0.43000000000000027,0.94692783668485325,489.25573158755952,null,null,null,null,null,null,null,null,null,0.1,373.15]
[0.44000000000000028,0.95227049150921217,487.98600206145704,null,null,null,null,null,null,null,null,null,0.6,373.15]
[0.45000000000000029,0.95727737134557034,486.67202849066734]
[0.4600000000000003,0.961945119115731,485.31401961811065]
[0.47000000000000031,0.96627237375213959,483.91259860125018]
[0.48000000000000032,0.9702600618365963,482.46885553018529]
[0.49000000000000032,0.9739116440717478,480.98438937915125]
[0.50000000000000033,0.97723329295231209,479.46133465635961]
[0.51000000000000034,0.98023397854194227,477.90236823068796]
[0.52000000000000035,0.98292544299049101,476.31069269160878]
[0.53000000000000036,0.98532205162160347,474.68999418461232]
[0.54000000000000037,0.98744051868826865,473.04437486043736]
[0.55000000000000038,0.98929951806379091,471.37826262422817]
[0.56000000000000039,0.99091920137351464,469.69630337835207]
[0.5700000000000004,0.9923206562386615,468.00324297254895]
[0.5800000000000004,0.99352534347934107,466.3038072159477]
[0.59000000000000041,0.99455455314058905,464.60258834144247]
[0.60000000000000042,0.99542891497901742,462.90394525013062]

{"sheet":"BASIC化プロ1985","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["p. 149 例題10.3 触媒反応器内の温度・反応率分布",null,null,null,null,null,null,null,"管径R0=0.025m ρb=1200 kg/m3"]
["L","W",null,"T","T"]
["m","kg","xA","℃","K"]
[0,{"$f":"A4*(3.14)*0.025^2*1200","v":0},0,125,{"$f":"D4+273.15","v":398.15}]
[5.7619999999999998E-3,{"$f":"A5*(3.14)*0.025^2*1200","v":1.3569510000000003E-2},0.05,134.4,{"$f":"D5+273.15","v":407.54999999999995}]
[9.8099999999999993E-3,2.3102550000000003E-2,0.1,143.9,417.04999999999995]
[1.2800000000000001E-2,3.0144000000000008E-2,0.15,153.4,426.54999999999995]
[1.5100000000000001E-2,3.5560500000000009E-2,0.2,162.99,436.14]
[1.7100000000000001E-2,4.0270500000000015E-2,0.25,172.53,445.67999999999995]
[1.89E-2,4.4509500000000014E-2,0.3,182.14,455.28999999999996]
[2.07E-2,4.8748500000000007E-2,0.35,191.61,464.76]
[2.2700000000000001E-2,5.3458500000000013E-2,0.4,200.92,474.06999999999994]
[2.5100000000000001E-2,5.9110500000000017E-2,0.45,209.91,483.05999999999995]
[2.8299999999999999E-2,6.6646500000000011E-2,0.5,218.38,491.53]
[3.2800000000000003E-2,7.7244000000000021E-2,0.55000000000000004,225.98,499.13]
[3.9199999999999999E-2,9.2316000000000009E-2,0.6,232.2,505.34999999999997]
[4.82E-2,0.11351100000000003,0.65,236.66,509.80999999999995]
[6.0100000000000001E-2,0.14153550000000004,0.7,238.98,512.13]
[7.4999999999999997E-2,0.17662500000000003,0.75,239.28,512.42999999999995]
[9.2600000000000002E-2,0.21807300000000007,0.8,237.81,510.96]
[0.1129,0.26587950000000005,0.85,234.75,507.9]
[0.13689999999999999,0.32239950000000001,0.9,229.76,502.90999999999997]
[0.16819999999999999,0.39611100000000005,0.95,221.13,494.28]

{"sheet":"Stream report","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[]
[null,"Stream","Feed","Products",null,"PFR"]
[null,"Pressure / [kPa]",126.7,112.312,null,"Parameter","Value"]
[null,"Temperature / [K]",398.15,468.214,null,"Benzene conversion",0.98986399999999997]
[null,"Flow rate / [mol / s]",7.6880000000000004E-2,6.9515400000000005E-2]
[null,"Flow Benzene / [mol / s]",2.48E-3,2.5137300000000001E-5]
[null,"Flow Hydrogen / [mol / s]",7.4399999999999994E-2,6.7035399999999995E-2]
[null,"Flow Cyclohexane / [mol / s]",0,2.4548600000000001E-3]