{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["例題14 1次反応を伴う1次元拡散","反応係数"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":27,"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":"例題14 1次反応を伴う1次元拡散","index":0,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["微分方程式数",2,null,null,null,"定数"]
["y=","cA=","g",null,null,"k1=",5,"/s"]
[1.5000000000000023E-4,-3.4805219437828569E-3,-187.8314627698208,null,null,"DAB=",2.0000000000000001E-9,"m2/s"]
[null,"cA'=","g'="]
["微分方程式→",{"$f":"C3","v":-187.8314627698208},{"$f":"B3*G2/G3","v":-8701304.8594571427}]
[null,null,null,null,null,null,null,null,null,"解析解濃度分布"]
["積分区間y=[a,",0,null,null,null,null,null,null,null,null,null,null,null,null,"計算結果のまとめ"]
["b]",1.4999999999999999E-4,null,null,null,null,null,null,null,null,null,null,null,"k1",10,20,5,2,0.6,0.15]
["積分刻み幅Δy",5.0000000000000004E-6,null,null,null,null,null,null,null,"cA=0となるL＝δ",null,null,null,"g",-17677.669450000001,-24999.999997999999,-12500.15,-7913.6,-4468,-2784]
["計算結果",null,null,null,null,null,null,null,null,1.2E-4,"←仮定　天下り"]
["y[m]","cA[mol/m3]","g",null,null,null,null,null,null,"cA",null,null,null,"y[m]","cA[mol/m3]","cA[mol/m3]","cA[mol/m3]","cA[mol/m3]","cA[mol/m3]","cA[mol/m3]"]
[0,0.25,-12500.2,null,null,null,null,null,null,{"$f":"$B$12*COSH(SQRT($G$2/$G$3)*A12)-$B$12*SINH(SQRT($G$2/$G$3)*A12)/TANH(SQRT($G$2/$G$3)*$J$10)","v":0.25},null,null,null,0,0.25,0.25,0.25,0.25,0.25,0.25]
[5.0000000000000004E-6,0.19470113802083333,-9735.3137044270843,null,null,null,null,null,null,0.19469941971122418,null,null,null,5.0000000000000004E-6,0.17555798926562499,0.15169270834374998,0.194701390625,0.21339864375000001,0.22857016093749999,0.23631006162109375]
[1.0000000000000001E-5,0.15163362211142645,-7582.0108454651308,null,null,null,null,null,null,0.15163106405821561,null,null,null,1.0000000000000001E-5,0.12328243067346867,9.2042711069498684E-2,0.15163414318974813,0.18214331368343098,0.20885566803844358,0.22306327381629687]
[1.5E-5,0.1180919021283971,-5905.0184980250397,null,null,null,null,null,null,0.11808911192542046,null,null,null,1.5E-5,8.6572863187345944E-2,5.584883252620463E-2,0.11809272441702751,0.15545100663467898,0.19070857032008556,0.21023479497883413]
[2.0000000000000002E-5,9.1968849220207552E-2,-4598.9861029982194,null,null,null,null,null,null,9.1966249927831922E-2,null,null,null,2.0000000000000002E-5,6.0794232178046942E-2,3.3887442699279111E-2,9.197002437807747E-2,0.13265303150723681,0.17399267960064063,0.19780056795375497]
[2.5000000000000001E-5,7.1623383605369545E-2,-3581.8672257831399,null,null,null,null,null,null,7.1621277919308945E-2,null,null,null,2.5000000000000001E-5,4.2691654213908858E-2,2.0561911923093527E-2,7.1624985459574186E-2,0.11317825733908381,0.15858254845040551,0.18573727492372216]
[3.0000000000000001E-5,5.5777380081204121E-2,-2789.7653063169078,null,null,null,null,null,null,5.5775998624349787E-2,null,null,null,3.0000000000000001E-5,2.997944620088578E-2,1.247636855929387E-2,5.5779509265052284E-2,9.6538805427799634E-2,0.14436252874880015,0.17402229368127517]
[3.5000000000000004E-5,4.3435374750409129E-2,-2172.9196047898445,null,null,null,null,null,null,4.3434913360730021E-2,null,null,null,3.5000000000000004E-5,2.1052528519894309E-2,7.5702967567049112E-3,4.3438165025510948E-2,8.231782707698547E-2,0.13122590378209856,0.16263365520556566]
[4.0000000000000003E-5,3.3822028851019835E-2,-1692.5791756057122,null,null,null,null,null,null,3.3822678640432424E-2,null,null,null,4.0000000000000003E-5,1.4783763098928343E-2,4.5934356161837046E-3,3.3825655510585723E-2,7.0159060774191706E-2,0.11907408736851949,0.15155000246400932]
[4.5000000000000003E-5,2.6333421096697816E-2,-1318.5684890908624,null,null,null,null,null,null,2.6335394284788372E-2,null,null,null,4.5000000000000003E-5,1.0381637747253078E-2,2.787163324642899E-3,2.6338111977968585E-2,5.975790718856426E-2,0.10781588400036624,0.14075055036159473]
[5.0000000000000002E-5,2.0499108656965116E-2,-1027.3917705509512,null,null,null,null,null,null,2.0502662671215921E-2,null,null,null,5.0000000000000002E-5,7.2903275700519059E-3,1.6911703493566203E-3,2.0505158454606268E-2,5.0853798400580054E-2,9.7366804450818148E-2,0.13021504676274287]
[5.5000000000000002E-5,1.5952573405157294E-2,-800.75696910821682,null,null,null,null,null,null,1.5958035438220053E-2,null,null,null,5.5000000000000002E-5,5.1195149328714749E-3,1.0261543854993447E-3,1.5960362184826264E-2,4.3223670199121954E-2,8.7648431709221125E-2,0.11992373451262152]
[6.0000000000000002E-5,1.2408196833880652E-2,-624.42663037086004,null,null,null,null,null,null,1.2415990927428844E-2,null,null,null,6.0000000000000002E-5,3.5951068445330371E-3,6.226430956708137E-4,1.2418213909042625E-2,3.6676373914996778E-2,7.8587832486423426E-2,0.10985731438669359]
[6.5000000000000008E-5,9.6433171760400699E-3,-487.32348345556659,null,null,null,null,null,null,9.6539959428527666E-3,null,null,null,6.5000000000000008E-5,2.5246271948011568E-3,3.7780586374133463E-4,9.656191848042471E-3,3.1047887797104906E-2,7.0117009873692182E-2,9.9996908899018869E-2]
[7.0000000000000021E-5,7.4842415394051325E-3,-380.83455432897398,null,null,null,null,null,null,7.4985248358556689E-3,null,null,null,7.0000000000000021E-5,1.7729141720930724E-3,2.2924849185252373E-4,7.5007826319903898E-3,2.6197207967474798E-2,6.2172393047590133E-2,9.0324026901439119E-2]
[7.5000000000000034E-5,5.7953343211000928E-3,-298.27008908282386,null,null,null,null,null,null,5.8141575480963326E-3,null,null,null,7.5000000000000034E-5,1.2450543479193474E-3,1.3911269420884838E-4,5.8165809930279862E-3,2.2002816016067964E-2,5.4694360191210399E-2,8.0820528907259687E-2]
[8.0000000000000047E-5,4.4704964237761123E-3,-234.44329609382936,null,null,null,null,null,null,4.4950716838840776E-3,null,null,null,8.0000000000000047E-5,8.7439863691718411E-4,8.4428310602148492E-5,4.4977834517500653E-3,1.8359634742139568E-2,4.7626791051445252E-2,7.1468593074399345E-2]
[8.500000000000006E-5,3.426499988072389E-3,-185.34450599960454,null,null,null,null,null,null,3.4583940912149558E-3,null,null,null,8.500000000000006E-5,6.1414699343792403E-4,5.1259602625271446E-5,3.4615416212299072E-3,1.5176395777902531E-2,4.0916645774373789E-2,6.2250681784216805E-2]
[9.0000000000000073E-5,2.5977599215799159E-3,-147.8892798575971,null,null,null,null,null,null,2.638994256564331E-3,null,null,null,9.0000000000000073E-5,4.3143930450324276E-4,3.1153877719577295E-5,2.6427575755261102E-3,1.2373353148646498E-2,3.4513566858062346E-2,5.3149508753339417E-2]
[9.5000000000000087E-5,1.9322137656692892E-3,-119.72464136441917,null,null,null,null,null,null,1.985392402243491E-3,null,null,null,9.5000000000000087E-5,3.0320637844635247E-4,1.8987410351429919E-5,1.9899943217006793E-3,9.8802854898023002E-3,2.8369501235560285E-2,4.4148006616819127E-2]
[1.000000000000001E-4,1.388051068537551E-3,-99.081260434633379,null,null,null,null,null,null,1.4565252075868784E-3,null,null,null,1.000000000000001E-4,2.1325716325921535E-4,1.165971623347423E-5,1.4622444664088823E-3,7.6347368728250514E-3,2.2438339651944448E-2,3.5229294921824569E-2]
[1.0500000000000011E-4,9.3108679971214852E-4,-84.662302157512656,null,null,null,null,null,null,1.0191659565705891E-3,null,null,null,1.0500000000000011E-4,1.5023441856244269E-4,7.3034295642253077E-6,1.0263540808316833E-3,5.5804521693542126E-3,1.6675570629051926E-2,2.6376648471848105E-2]
[1.1000000000000013E-4,5.3261380058702672E-4,-75.561958514729,null,null,null,null,null,null,6.4583702953413535E-4,null,null,null,1.1000000000000013E-4,1.0618071855751841E-4,4.808429588805202E-6,6.5493992796593066E-4,3.6659677566461399E-3,1.1037946421016714E-2,1.7573465962063994E-2]
[1.1500000000000014E-4,1.6759935905319006E-4,-71.208544951543686,null,null,null,null,null,null,3.1308358872905728E-4,null,null,null,1.1500000000000014E-4,7.553372546916457E-5,3.5389464394911746E-6,3.2466920979554712E-4,1.8433222588547661E-3,5.4831584537129519E-3,8.8032388470196902E-3]
[1.2000000000000015E-4,-1.8688738557549655E-4,-71.328587092351043,null,null,null,null,null,null,0,null,null,null,1.2000000000000015E-4,5.4423873927906689E-5,3.1715558075009685E-6,1.4793765681308374E-5,6.6855025850347249E-5,-3.0480187618811376E-5,4.952038227815439E-5]
[1.2500000000000017E-4,-5.5311600028295875E-4,-75.92964152423292,null,null,null,null,null,null,-3.1308358873616271E-4,null,null,null,1.2500000000000017E-4,4.0185790048009587E-5,3.6127806466707911E-6,-2.9415336190171E-4,-1.707937750751831E-3,-5.544347605391596E-3,-8.7041052180448341E-3]
[1.3000000000000018E-4,-9.5409377713302399E-4,-85.300771478030867,null,null,null,null,null,null,-6.4583702952347721E-4,null,null,null,1.3000000000000018E-4,3.1021755761661057E-5,4.975307433227412E-6,-6.2158087820630243E-4,-3.5255179407677984E-3,-1.1099823619155454E-2,-1.7474053565687018E-2]
[1.3500000000000019E-4,-1.4150111022737714E-3,-100.03070735055408,null,null,null,null,null,null,-1.0191659565776945E-3,null,null,null,1.3500000000000019E-4,2.5774726714387954E-5,7.6067656133243012E-6,-9.8805853170426546E-4,-5.4314193282245602E-3,-1.6738600307969326E-2,-2.6276770882319424E-2]
[1.400000000000002E-4,-1.9648239764436994E-3,-121.0448330105641,null,null,null,null,null,null,-1.4565252076010893E-3,null,null,null,1.400000000000002E-4,2.3782244680773022E-5,1.2178420315877541E-5,-1.4166093529215408E-3,-7.4733883178330265E-3,-2.2502994896182911E-2,-3.5128764841028726E-2]
[1.4500000000000022E-4,-2.638073104715435E-3,-149.66332151041274,null,null,null,null,null,null,-1.9853924022470437E-3,null,null,null,1.4500000000000022E-4,2.4792799587719612E-5,1.9856407009410219E-5,-1.9341560180284895E-3,-9.7025800719853592E-3,-2.8436267330736759E-2,-4.4046635523039009E-2]
[1.5000000000000023E-4,-3.4770538353295776E-3,-187.68407248330132,null,null,null,null,null,null,null,null,null,null,1.5000000000000023E-4,2.8934081519356103E-5,3.2599188765250986E-5,-2.5732122013151608E-3,-1.217484004375213E-2,-3.4582944933297145E-2,-5.3047106547725854E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.2E-4,0]

{"sheet":"反応係数","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"γ=δ(k1/DAB)^0.5",null,"数値解","数値解"]
["δ","k1","DAB","γ","β","g(0)=dcA/dy","g/g-反応なし"]
[]
[1.2E-4,20,2.0000000000000001E-9,{"$f":"A4*(B4/C4)^0.5","v":12},{"$f":"D4/TANH(D4)","v":12.000000000906034},-24999.99,{"$f":"F4/$F$11","v":11.999995200000001}]
[1.2E-4,10,2.0000000000000001E-9,8.4852813742385713,8.4852820977984962,-17678,{"$f":"F5/$F$11","v":8.4854399999999988}]
[1.2E-4,5,2.0000000000000001E-9,6,6.0000737310012591,-12500,6]
[1.2E-4,2,2.0000000000000001E-9,3.7947331922020551,3.7985735135874958,-7913.6,3.7985279999999997]
[1.2E-4,0.6,2.0000000000000001E-9,2.078460969082653,2.1445754461007183,-4468,2.1446399999999999]
[1.2E-4,0.15,2.0000000000000001E-9,1.0392304845413265,1.3364864380444401,-2784,1.33632]
[]
[null,"0(反応なし)",null,null,null,{"$f":"-0.25/0.00012","v":-2083.3333333333335}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,5,{"$f":"D19/TANH(D19)","v":5.000454019910098}]
[null,null,null,4,{"$f":"D20/TANH(D20)","v":4.0026846016067301}]
[null,null,null,3,3.0149094699410672]
[null,null,null,2,2.0746294414550959]
[null,null,null,1.8,1.9011286109061329]
[null,null,null,1.6,1.7359819778492447]
[null,null,null,1.4,1.5812925890438552]
[null,null,null,1.2,1.4394450530308209]
[null,null,null,1,1.3130352854993315]
[null,null,null,0.8,1.2047525616349655]
[null,null,null,0.6,1.1172153128319997]
[null,null,null,0.4,1.0527729767328753]
[null,null,null,0.2,1.0132979126878945]
[null,null,null,0.01,1.0000333331111135]