{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["問題","実習","解答"],"not_rendered":{"charts":2,"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":"問題","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,17,8]]}
[]
[null,"問題6.1 バイオフィルターによる排水中の悪臭物質の除去 [VBA：ルンゲクッタ法]"]
[null,"　バイオフィルターにより排水中に含まれている悪臭物質の分解除去を行う。リアクターは円筒形であり、高さL=0.9 m、断面積A=8.60×10-3 m2である。排水のバイオリアクターへの供給流量はQ=0.21 m3 hr-1であり、悪臭物質濃度はCin=10.5 g m-3である。\n　バイオフィルム内の微生物による悪臭物質の生分解反応はモノータイプの式で表せると仮定する。\n\n　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　(6.7)\n\n　ここで，CBはバイオフィルム中の悪臭物質濃度（微生物にとっては基質）[g m-3]，tは時間 [hr]である。m’は最大基質分解速度 [g m-3 hr-1]，KSは飽和定数 [g m-3]であり、それぞれmm'=380 g m-3 hr-1、KS=5.1 g m-3である。\n　供給汚染水中の悪臭物質のバイオフィルムへの拡散速度は、バイオフィルム内での生分解反応に比べ十分速く、平衡状態が成り立っていると仮定できるとする（平衡定数m=0.8）。定常状態におけるバイオフィルター内の濃度分布をシミュレーションしなさい。なお、リアクターの半径方向の濃度分布はなく、リアクターの高さ方向への1次元濃度分布とする。"]

{"sheet":"実習","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,9,2]]}
[]
[null,"mm' [g m-3 hr-1]",380]
[null,"Ks' [g m-3]",5.0999999999999996]
[null,"m [-]",0.8]
[null,"Cin [g m-3]",10.5]
[null,"A [m2]",8.6E-3]
[null,"L [m]",0.9]
[null,"Q [m3 hr-1]",0.21]
[]
[null,"cal."]
[null,"z/L [-]","C/Cin [-]"]

{"sheet":"解答","index":2,"n_rows":112,"n_cols":3,"rows_kept":112,"cut":false,"hidden":false,"merged":[[9,1,9,2]]}
[]
[null,"mm' [g m-3 hr-1]",380]
[null,"Ks' [g m-3]",5.0999999999999996]
[null,"m [-]",0.8]
[null,"Cin [g m-3]",10.5]
[null,"A [m2]",8.6E-3]
[null,"L [m]",0.9]
[null,"Q [m3 hr-1]",0.21]
[]
[null,"cal."]
[null,"z/L [-]","C/Cin [-]"]
[null,0,1]
[null,0.01,0.98964578842767725]
[null,0.02,0.97933260506275355]
[null,3.0000000000000002E-2,0.96906081929641663]
[null,0.04,0.95883080300176649]
[null,0.05,0.94864293048998283]
[null,6.0000000000000005E-2,0.93849757846334847]
[null,6.9999999999999993E-2,0.92839512596502283]
[null,0.08,0.91833595432546167]
[null,9.0000000000000011E-2,0.90832044710537096]
[null,0.10000000000000002,0.89834899003508839]
[null,0.11000000000000003,0.88842197095027908]
[null,0.12000000000000004,0.87853977972383779]
[null,0.13000000000000006,0.86870280819388213]
[null,0.14000000000000007,0.8589114500877254]
[null,0.15000000000000008,0.84916610094171663]
[null,0.16000000000000009,0.83946715801683303]
[null,0.1700000000000001,0.82981502020991349]
[null,0.1800000000000001,0.82021008796041939]
[null,0.19000000000000011,0.81065276315260903]
[null,0.20000000000000012,0.80114344901301915]
[null,0.21000000000000013,0.79168255000313725]
[null,0.22000000000000014,0.78227047170716035]
[null,0.23000000000000015,0.77290762071473296]
[null,0.24000000000000016,0.7635944044985572]
[null,0.25000000000000017,0.75433123128677637]
[null,0.26000000000000018,0.74511850993003137]
[null,0.27000000000000018,0.7359566497630935]
[null,0.28000000000000019,0.72684606046098399]
[null,0.2900000000000002,0.71778715188949194]
[null,0.30000000000000021,0.70878033395000728]
[null,0.31000000000000022,0.69982601641859354]
[null,0.32000000000000023,0.69092460877922668]
[null,0.33000000000000024,0.68207652005113695]
[null,0.34000000000000025,0.67328215861019525]
[null,0.35000000000000026,0.6645419320042919]
[null,0.36000000000000026,0.65585624676266852]
[null,0.37000000000000027,0.64722550819916713]
[null,0.38000000000000028,0.6386501202093724]
[null,0.39000000000000029,0.63013048506163527]
[null,0.4000000000000003,0.62166700318197121]
[null,0.41000000000000031,0.61326007293284435]
[null,0.42000000000000032,0.60491009038585519]
[null,0.43000000000000033,0.59661744908836722]
[null,0.44000000000000034,0.5883825398241157]
[null,0.45000000000000034,0.58020575036786282]
[null,0.46000000000000035,0.57208746523417131]
[null,0.47000000000000036,0.56402806542038975]
[null,0.48000000000000037,0.55602792814395574]
[null,0.49000000000000038,0.548087426574141]
[null,0.50000000000000033,0.54020692955837979]
[null,0.51000000000000034,0.53238680134334171]
[null,0.52000000000000035,0.524627401290925]
[null,0.53000000000000036,0.51692908358936995]
[null,0.54000000000000037,0.50929219695971006]
[null,0.55000000000000038,0.50171708435779738]
[null,0.56000000000000039,0.49420408267216293]
[null,0.5700000000000004,0.48675352241799058]
[null,0.5800000000000004,0.4793657274275066]
[null,0.59000000000000041,0.47204101453710834]
[null,0.60000000000000042,0.46477969327157698]
[null,0.61000000000000043,0.45758206552574299]
[null,0.62000000000000044,0.4504484252439922]
[null,0.63000000000000045,0.44337905809802663]
[null,0.64000000000000046,0.43637424116331242]
[null,0.65000000000000047,0.42943424259467172]
[null,0.66000000000000048,0.42255932130149582]
[null,0.67000000000000048,0.41574972662307763]
[null,0.68000000000000049,0.40900569800458314]
[null,0.6900000000000005,0.40232746467420072]
[null,0.70000000000000051,0.3957152453220264]
[null,0.71000000000000052,0.38916924778126127]
[null,0.72000000000000053,0.38268966871231552]
[null,0.73000000000000054,0.37627669329042784]
[null,0.74000000000000055,0.36993049489742541]
[null,0.75000000000000056,0.36365123481826178]
[null,0.76000000000000056,0.35743906194298358]
[null,0.77000000000000057,0.35129411247478465]
[null,0.78000000000000058,0.3452165096448172]
[null,0.79000000000000059,0.33920636343443422]
[null,0.8000000000000006,0.33326377030554355]
[null,0.81000000000000061,0.32738881293975403]
[null,0.82000000000000062,0.32158155998699739]
[null,0.83000000000000063,0.31584206582430441]
[null,0.84000000000000064,0.31017037032541112]
[null,0.85000000000000064,0.30456649864186314]
[null,0.86000000000000065,0.29903046099627606]
[null,0.87000000000000066,0.29356225248839846]
[null,0.88000000000000067,0.28816185291460839]
[null,0.89000000000000068,0.28282922660145682]
[null,0.90000000000000069,0.2775643222538503]
[null,0.9100000000000007,0.27236707281844413]
[null,0.92000000000000071,0.2672373953627889]
[null,0.93000000000000071,0.26217519097074637]
[null,0.94000000000000072,0.25718034465465917]
[null,0.95000000000000073,0.25225272528472531]
[null,0.96000000000000074,0.2473921855359921]
[null,0.97000000000000075,0.24259856185334622]
[null,0.98000000000000076,0.23787167443483467]
[null,0.99000000000000077,0.23321132723361054]
[null,1.0000000000000007,0.2286173079787511]