{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["解析解","例題21管型反応器モデル"],"not_rendered":{"charts":6,"images":4,"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":"解析解","index":0,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Dy=","m2/s",0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
["k1=","/s",0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["v=","m/s",0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
["y=","m ",2.5,2.25,2,1.75,1.5,1.25,1,0.75,0.5,0.25,1E-3]
["(L/v)=τ空間時間","s",{"$f":"C4/C3","v":250},{"$f":"D4/D3","v":225},{"$f":"E4/E3","v":200},{"$f":"F4/F3","v":175},{"$f":"G4/G3","v":150},125,100,75,50,25,0.1]
["(D/vL)",null,{"$f":"C1/C3/C4","v":0.4},{"$f":"D1/D3/D4","v":0.44444444444444442},{"$f":"E1/E3/E4","v":0.5},{"$f":"F1/F3/F4","v":0.5714285714285714},{"$f":"G1/G3/G4","v":0.66666666666666663},0.8,1,1.3333333333333333,2,4,{"$f":"M1/M3/M4","v":1000}]
["Pe=vL/D",null,null,null,{"$f":"1/E6","v":2}]
["a=",null,{"$f":"SQRT(1+4*C2*C5*C6)","v":3},3,3,3,3,3,3,3,3,3,3]
["b=",null,null,null,{"$f":"1/2/E6","v":1}]
[]
[]
[]
["出口濃度cA/cA0",null,null,null,{"$f":"(4*E8*EXP(E9))/((1+E8)^2*EXP(E8*E9)-(1-E8)^2*EXP(-E8*E9))","v":0.10156440067226907}]
[null,null,{"$f":"4*C8*EXP(0.5*(1/C6))/((1+C8)^2*EXP((C8/2)*(1/C6))-(1-C8)^2*EXP((-C8/2)*(1/C6)))","v":6.1572262631948184E-2},7.9072564534992673E-2,0.10156440067226907,{"$f":"4*F8*EXP(0.5*(1/F6))/((1+F8)^2*EXP((F8/2)*(1/F6))-(1-F8)^2*EXP((-F8/2)*(1/F6)))","v":0.13050166005339733},0.167813680510287,0.2161494345120864,0.27938704637330253,0.36386262416425036,0.4817724878783245,0.66231437708745744,0.9980039913521257]
[]
[]
[]
[]
[]
["濃度分布"]
["cA/CA0",null,null,null,{"$f":"(2*(1+$E$8)*EXP($E$8*$E$9)*EXP((1-$E$8)*(E4/$E$4)*$E$9)-2*(1-$E$8)*EXP(-$E$8*$E$9)*EXP((1+$E$8)*(E4/$E$4)*$E$9))/((1+$E$8)^2*EXP($E$8*$E$9)-(1-$E$8)^2*EXP(-$E$8*$E$9))","v":0.10156440067226907},{"$f":"(2*(1+$E$8)*EXP($E$8*$E$9)*EXP((1-$E$8)*(F4/$E$4)*$E$9)-2*(1-$E$8)*EXP(-$E$8*$E$9)*EXP((1+$E$8)*(F4/$E$4)*$E$9))/((1+$E$8)^2*EXP($E$8*$E$9)-(1-$E$8)^2*EXP(-$E$8*$E$9))","v":0.10747482224359055},0.12408874347692919,0.15089525226942754,0.18863552548775456,0.23910869830666481,0.30513890753889999,0.39066417431342465,0.50043128986440111]
["cA/CA0",null,{"$f":"(2*(1+$E$8)*EXP(($E$8/2)*$E$7)*EXP((1-$E$8)*$E$7*(C4/$E$4)/2)-2*(1-$E$8)*EXP(-($E$8/2)*$E$7)*EXP((1+$E$8)*$E$7*(C4/$E$4)/2))/((1+$E$8)^2*EXP(($E$8/2)*$E$7)-(1-$E$8)^2*EXP(-($E$8/2)*$E$7))","v":0.13309483688396728},null,{"$f":"(2*(1+$E$8)*EXP(($E$8/2)*$E$7)*EXP((1-$E$8)*$E$7*(E4/$E$4)/2)-2*(1-$E$8)*EXP(-($E$8/2)*$E$7)*EXP((1+$E$8)*$E$7*(E4/$E$4)/2))/((1+$E$8)^2*EXP(($E$8/2)*$E$7)-(1-$E$8)^2*EXP(-($E$8/2)*$E$7))","v":0.10156440067226907},{"$f":"(2*(1+$E$8)*EXP(($E$8/2)*$E$7)*EXP((1-$E$8)*$E$7*(F4/$E$4)/2)-2*(1-$E$8)*EXP(-($E$8/2)*$E$7)*EXP((1+$E$8)*$E$7*(F4/$E$4)/2))/((1+$E$8)^2*EXP(($E$8/2)*$E$7)-(1-$E$8)^2*EXP(-($E$8/2)*$E$7))","v":0.10747482224359055},0.12408874347692919,0.15089525226942754,0.18863552548775456,0.23910869830666481,0.30513890753889999,0.39066417431342465,0.50043128986440111]
[]
[]
["押し出し流れ"]
["cA/cA0",null,{"$f":"1*EXP(-(C2/C3)*C4)","v":6.737946999085467E-3},1.1108996538242306E-2,{"$f":"1*EXP(-(E2/E3)*E4)","v":1.8315638888734179E-2},{"$f":"1*EXP(-(F2/F3)*F4)","v":3.0197383422318501E-2},4.9787068367863944E-2,8.20849986238988E-2,0.1353352832366127,0.22313016014842982,0.36787944117144233,0.60653065971263342,0.99800199866733308]
["x",null,null,null,{"$f":"1-E26","v":0.98168436111126578},{"$f":"1-F26","v":0.96980261657768152},0.95021293163213605,0.91791500137610116,0.8646647167633873,0.77686983985157021,0.63212055882855767,0.39346934028736658,1.998001332666921E-3]
["完全混合"]
["cA/cA0",null,null,null,{"$f":"1/(1+(E4/E3)*E2)","v":0.2},{"$f":"1/(1+(F4/F3)*F2)","v":0.22222222222222221},0.25,0.2857142857142857,0.33333333333333331,0.4,0.5,0.66666666666666663,0.99800399201596801]
["x",null,null,null,{"$f":"1-E29","v":0.8},{"$f":"1-F29","v":0.77777777777777779},0.75,0.7142857142857143,0.66666666666666674,0.6,0.5,0.33333333333333337,1.9960079840319889E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dy",0.01,null,0.01]
["cA0",1,"mol/m3",1]
["k1",0.02,"/s",0.02]
["L",2,"m",4.25,"同じ反応率を与える容積（長さ）"]
["V"]
["v",0.01,"m/s",0.01]
["tR",{"$f":"B50/B52","v":200},"s",{"$f":"D50/D52","v":425}]
["Pe=vL/D",{"$f":"B52*B50/B47","v":2},null,{"$f":"D52*D50/D47","v":4.25}]
["D/vL",{"$f":"B47/B52/B50","v":0.5}]
["完全混合解"]
["出口（容器内均一）濃度",null,null,"完全混合"]
["cAout",{"$f":"B48/(1+(B50/B52)*B49)","v":0.2},null,{"$f":"D48/(1+(D50/D52)*D49)","v":0.10526315789473684}]
[]
["押し出し流れ解"]
["y","cA"]
[0,{"$f":"$B$48*EXP(-$B$49*A62/$B$52)","v":1}]
[0.2,{"$f":"$B$48*EXP(-$B$49*A63/$B$52)","v":0.67032004603563933}]
[0.4,{"$f":"$B$48*EXP(-$B$49*A64/$B$52)","v":0.44932896411722156}]
[0.6,{"$f":"$B$48*EXP(-$B$49*A65/$B$52)","v":0.30119421191220214}]
[0.8,{"$f":"$B$48*EXP(-$B$49*A66/$B$52)","v":0.20189651799465538}]
[1.1200000000000001,0.10645850437925281]
[1.2,9.0717953289412512E-2]
[1.4,6.0810062625217973E-2]
[1.6,4.0762203978366211E-2]
[1.8,2.7323722447292545E-2]
[2,1.8315638888734179E-2]

{"sheet":"例題21管型反応器モデル","index":1,"n_rows":42,"n_cols":25,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["微分方程式数",2,null,null,null,"定数",null,null,"L=",2]
["y=","cA=","g=",null,null,"k1=",0.02,"/s","(Dy/vL)=",{"$f":"G3/G4/J1","v":0.5}]
[2.9999999999999973,0.27513839805658075,0.47555691480917539,null,null,"Dy=",0.01,"m2/s"]
[null,"cA'=","g'=",null,null,"v=",0.01,"m/s"]
["微分方程式→",{"$f":"C3","v":0.47555691480917539},{"$f":"(G4*B5+G2*B3)/G3","v":1.025833710922337},null,null,"cA0=",1,"mol/m3"]
[]
["積分区間y=[a,",0,null,null,null,null,null,null,null,"計算のまとめ"]
["b]",3,null,null,null,null,null,null,null,"Dy",0.01,"Dy",0.02,"Dy",4.0000000000000001E-3,null,1E-3]
["積分刻み幅Δy",0.1,null,null,null,null,null,null,null,"(Dy/vL)=",0.5,"(Dy/vL)=",1,"(Dy/vL)=",0.2,null,0.05]
["計算結果",null,null,null,null,null,null,null,null,"g=",-0.49907000000000001,"g=",-0.30170000000000002,"g=",-0.86030099999999998,null,-1.4589803374995001,null,null,"解析解","(vL/Dy)=2","押し出し流れ",null,"完全混合"]
["y[m]","cA[mol/m3]","g(=dcA/dy)",null,null,null,null,null,null,"y[m]","cA[mol/m3]","y[m]","cA[mol/m3]","y[m]","cA[mol/m3]",null,"cA[mol/m3]",null,null,"y","cA","y","cA","y","cA"]
[0,{"$f":"G5-(-1*$G$3*C12/$G$4)","v":0.5009300000000001},-0.49907000000000001,null,null,"←初期値",null,null,null,0,0.50090000000000001,0,0.39660000000000001,0,0.65990000000000004,null,0.85410196625004997,null,null,2,0.10156440067226907,0,1,0,{"$f":"G5/(1+(J1/G4)*G2)","v":0.2}]
[0.1,0.45345651762500011,-0.45118471362500001,null,null,null,null,null,null,0.1,0.45345651762500011,0.1,0.36762959723958327,0.1,0.57525417687239588,null,0.71998587206889497,null,null,1.75,0.10747482224359055,0.2,0.67032004603563933,2,{"$f":"Y12","v":0.2}]
[0.2,0.41054418441776103,-0.40776940301216091,null,null,null,null,null,null,0.2,0.41054418441776103,0.2,0.34094674482304782,0.2,0.50454256440194978,null,0.60692947266738917,null,null,1.5,0.12408874347692919,0.4,0.44932896411722156]
[0.3,0.37176857071434261,-0.36837945270554262,null,null,null,null,null,null,0.3,0.37176857071434261,0.3,0.31639488818493017,0.3,0.44252702553433243,null,0.51162585140442629,null,null,1.25,0.15089525226942754,0.6,0.30119421191220214]
[0.39999999999999997,0.33674776666029255,-0.33260829792434426,null,null,null,null,null,null,0.39999999999999997,0.33674776666029255,0.39999999999999997,0.293831315932925,0.39999999999999997,0.38813999375441988,null,0.43128736307027082,null,null,1,0.18863552548775456,0.8,0.20189651799465538]
[0.49999999999999994,0.30513880750605699,-0.30008286039196974,null,null,null,null,null,null,0.49999999999999994,0.30513880750605699,0.49999999999999994,0.27312640498901902,0.49999999999999994,0.34044582948626539,null,0.36356409486213298,null,null,0.75,0.23910869830666481,1,0.1353352832366127]
[0.6,0.27663454348952959,-0.27045920968438342,null,null,null,null,null,null,0.6,0.27663454348952959,0.6,0.25416296135035588,0.6,0.29862492016937353,null,0.30647513113397606,null,null,0.5,0.30513890753889999,1.143,0.1016]
[0.70000000000000007,0.25096093511393774,-0.24341838240433222,null,null,null,null,null,null,0.70000000000000007,0.25096093511393774,0.70000000000000007,0.23683565460673614,0.70000000000000007,0.26195988270895076,null,0.25835061148269234,null,null,0.25,0.39066417431342465,1.2,9.0717953289412512E-2]
[0.80000000000000016,0.22787476157353581,-0.21866228769402363,null,null,null,null,null,null,0.80000000000000016,0.22787476157353581,0.80000000000000016,0.221050545218334,0.80000000000000016,0.22982367838149023,null,0.21778288761238393,null,null,1E-3,0.50043128986440111,1.4,6.0810062625217973E-2]
[0.90000000000000024,0.20716173749612191,-0.19590962189968572,null,null,null,null,null,null,0.90000000000000024,0.20716173749612191,0.90000000000000024,0.20672470445809971,0.90000000000000024,0.20166950542017506,null,0.18358535111272278,null,null,null,null,1.6,4.0762203978366211E-2]
[1.0000000000000002,0.18863504126614616,-0.17489170727665898,null,null,null,null,null,null,1.0000000000000002,0.18863504126614616,1.0000000000000002,0.19378592786941187,1.0000000000000002,0.17702239761967903,null,0.15475773043542665,null,null,null,null,1.8,2.7323722447292559E-2]
[1.1000000000000003,0.17213426720700553,-0.15534815907224589,null,null,null,null,null,null,1.1000000000000003,0.17213426720700553,1.1000000000000003,0.18217254409287623,1.1000000000000003,0.15547253425038801,null,0.13045685025406162,null,null,null,null,2,1.8315638888734179E-2]
[1.2000000000000004,0.15752482412272215,-0.13702227164692671,null,null,null,null,null,null,1.2000000000000004,0.15752482412272215,1.2000000000000004,0.17183332198996712,1.2000000000000004,0.13667036567530533,null,0.10997202434311476]
[1.3000000000000005,0.14469781446984992,-0.11965599687591338,null,null,null,null,null,null,1.3000000000000005,0.14469781446984992,1.3000000000000005,0.16272748015010852,1.3000000000000005,0.1203237922616671,null,9.2704446840879723E-2,null,null,null,null,null,null,0,0.1016]
[1.4000000000000006,0.13357044216105635,-0.10298436615182226,null,null,null,null,null,null,1.4000000000000006,0.13357044216105635,1.4000000000000006,0.15482480412804925,1.4000000000000006,0.10619781875217243,null,7.8150250063814528E-2,null,null,null,"同じ反応率cA=0.1016を与えるL",null,null,4.42,0.1016]
[1.5000000000000007,0.12408701318779587,-8.6729179950117363E-2,null,null,null,null,null,null,1.5000000000000007,0.12408701318779587,1.5000000000000007,0.14810587813813378,1.5000000000000007,9.4117367322823275E-2,null,6.5887600984056188E-2,null,null,null,"完全混合","押し出し流れ"]
[1.6000000000000008,0.11622061249007978,-7.0591754973579252E-2,null,null,null,null,null,null,1.6000000000000008,0.11622061249007978,1.6000000000000008,0.14256243945158906,1.6000000000000008,8.397430671493232E-2,null,5.5570237252007493E-2,null,null,null,"L","L"]
[1.7000000000000008,0.10997556352318164,-5.4244476952527876E-2,null,null,null,null,null,null,1.7000000000000008,0.10997556352318164,1.7000000000000008,0.13819786542500365,1.7000000000000008,7.5740295543179181E-2,null,4.693614991818125E-2,null,null,null,{"$f":"(G4/G2/0.1016)*(G5-0.1016)","v":4.4212598425196852},{"$f":"-(G4/G2)*LN(0.1016/G5)","v":1.1433558719188779},2]
[1.8000000000000009,0.10539080465691439,-3.7320855519517887E-2,null,null,null,null,null,null,1.8000000000000009,0.10539080465691439,1.8000000000000009,0.13502780495836095,1.8000000000000009,6.9487823283347738E-2,null,3.9860152772493218E-2,null,null,null,{"$f":"U29/V29","v":3.8669148872253989},null,{"$f":"W29/V29","v":1.749236654239094}]
[1.900000000000001,0.10254434996668646,-1.940371409027038E-2,null,null,null,null,null,null,1.900000000000001,0.10254434996668646,1.900000000000001,0.13308096826814325,1.900000000000001,6.542297680856432E-2,null,3.4543088701832286E-2]
[2.0000000000000009,0.10155904244452431,-1.1069785069716537E-5,null,null,null,null,null,null,2.0000000000000009,0.10155904244452431,2.0000000000000009,0.13240009119769258,2.0000000000000009,6.3935130870405671E-2,null,3.2135272931578598E-2]
[2.1000000000000005,0.10260985676623346,2.1420837040024378E-2,null,null,null,null,null,null,2.1000000000000005,0.10260985676623346,2.1000000000000005,0.13304309290997049,2.1000000000000005,6.5671202297018783E-2]
[2.2000000000000002,0.10593306844106461,4.555802097389873E-2,null,null,null,null,null,null,2.2000000000000002,0.10593306844106461,2.2000000000000002,0.13508444875869868,2.2000000000000002,7.1645678035781313E-2]
[2.2999999999999998,0.11183767881318324,7.3193537798252981E-2,null,null,null,null,null,null,2.2999999999999998,0.11183767881318324,2.2999999999999998,0.13861680345968128,2.2999999999999998,8.3402850719593705E-2]
[2.3999999999999995,0.12071957387264295,0.10527755409656525,null,null,null,null,null,null,2.3999999999999995,0.12071957387264295,2.3999999999999995,0.14375285343826441,2.3999999999999995,0.10325533954506082]
[2.4999999999999991,0.13307900269823839,0.14295388940335252,null,null,null,null,null,null,2.4999999999999991,0.13307900269823839,2.4999999999999991,0.15062753147186866,2.4999999999999991,0.13463416223296654]
[2.5999999999999988,0.14954209290593723,0.18760448150694589,null,null,null,null,null,null,2.5999999999999988,0.14954209290593723,2.5999999999999988,0.15940053154694214,2.5999999999999988,0.18260200010970137]
[2.6999999999999984,0.17088728097730208,0.24090354501059336,null,null,null,null,null,null,2.6999999999999984,0.17088728097730208,2.6999999999999984,0.17025921728537236,2.6999999999999984,0.25460527017187579]
[2.799999999999998,0.19807773121856395,0.30488358364305157,null,null,null,null,null,null,2.799999999999998,0.19807773121856395,2.799999999999998,0.18342196345471828,2.799999999999998,0.36157570941723721]
[2.8999999999999977,0.23230105620010408,0.38201589377187312,null,null,null,null,null,null,2.8999999999999977,0.23230105620010408,2.8999999999999977,0.19914198705989589,2.8999999999999977,0.51954354666687286]
[2.9999999999999973,0.27501794343129637,0.47530877926447657,null,null,null,null,null,null,2.9999999999999973,0.27501794343129637,2.9999999999999973,0.21771173243507902,2.9999999999999973,0.75199953784673101]