{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["問題","実習","解答"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":80,"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,10,8]]}
[]
[null,"問題5.2 活性汚泥による排水処理プロセスのシミュレーション [VBAでソルバーを使う]"]
[null,"　ばっき槽と沈澱槽からなる活性汚泥排水処理プロセスをシミュレーションしなさい。ばっき槽の混合状態は槽列モデルで表され、槽数はn=5とする。操作条件は、排水流量Q=280 m3 hr-1、反応装置体積V=1400 m3、リサイクル比=0.35、余剰汚泥排出率=0.09、流入汚泥濃度（MLVSS or MLSS）Xin=0 mg L-1, 流入基質濃度（BOD） Sin=200 mg L-1、流出汚泥濃度（MLVSS or MLSS）Xout=0 mg L-1である。モノー式における反応速度定数は、最大増殖速度m=0.2 hr-1, 基質飽和定数KS=150 mg L-1、増殖収率YX/S=(DX/DS)=0.5である。 ばっき槽および沈澱槽の活性汚泥と基質の濃度分布を求めなさい。"]

{"sheet":"実習","index":1,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,9],[1,11,1,14],[14,3,15,3]]}
[]
[null,"パラメーター",null,null,null,"計算結果",null,null,null,null,null,"残余関数"]
[null,"槽数","n [-]",5,null,"i [-]","Xi [g m-3]","Si [g m-3]","Xr [g m-3]","Sr [g m-3]",null,"Xi","Si","Xr","Sr"]
[null,"最大増殖速度","mm [h-1]",0.25,null,1,500,200,1000,100,null,{"$f":"$D$11*$D$8*$D$3/$D$12+$D$9*$D$11*$I$4*$D$3/$D$12-(1+$D$9)*$D$11*G4*$D$3/$D$12+$D$4*H4/($D$5+H4)*G4","v":-241.66666666666669},{"$f":"$D$11*$D$10*$D$3/$D$12+$D$9*$D$11*$J$4*$D$3/$D$12-(1+$D$9)*$D$11*H4*$D$3/$D$12-$D$4*H4/($D$5+H4)*G4/$D$6","v":-201.66666666666666},{"$f":"(1+$D$9)*$D$11*$G$8-$D$11*($D$9+$D$13)*$I$4-(1-$D$13)*$D$11*$D$7","v":65800.000000000015},{"$f":"H8-J4","v":100}]
[null,"基質飽和定数","Ks [g m-3]",100,null,2,500,200,null,null,null,{"$f":"(1+$D$9)*$D$11*(G4-G5)*$D$3/$D$12+$D$4*H5/($D$5+H5)*G5","v":83.333333333333329},{"$f":"(1+$D$9)*$D$11*(H4-H5)*$D$3/$D$12-$D$4*H5/($D$5+H5)*G5/$D$6","v":-166.66666666666666}]
[null,"増殖収率","YX/S [g g-1]",0.5,null,3,500,200,null,null,null,{"$f":"(1+$D$9)*$D$11*(G5-G6)*$D$3/$D$12+$D$4*H6/($D$5+H6)*G6","v":83.333333333333329},{"$f":"(1+$D$9)*$D$11*(H5-H6)*$D$3/$D$12-$D$4*H6/($D$5+H6)*G6/$D$6","v":-166.66666666666666},null,{"$f":"ABS(SUM(L4:M8))+N4+O4","v":66676.666666666686}]
[null,"流出汚泥濃度","Xout [g m-3]",0,null,4,500,200,null,null,null,83.333333333333329,-166.66666666666666]
[null,"流入汚泥濃度","Xin [g m-3]",0,null,5,500,200,null,null,null,83.333333333333329,-166.66666666666666]
[null,"リサイクル比","a [-]",0.35]
[null,"流入基質濃度","Sin [g m-3]",200]
[null,"排水流量","Q [m3 h-1]",280]
[null,"反応装置体積","V [m3]",1400]
[null,"余剰汚泥排出率","w [-]",0.09]
[]
[null,"基質濃度","S [g m-3]"]
[null,"汚泥濃度","X [g m-3]"]

{"sheet":"解答","index":2,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,9],[1,11,1,14],[14,3,15,3]]}
[]
[null,"パラメーター",null,null,null,"計算結果",null,null,null,null,null,"残余関数"]
[null,"槽数","n [-]",5,null,"i [-]","Xi [g m-3]","Si [g m-3]","Xr [g m-3]","Sr [g m-3]",null,"Xi","Si","Xr","Sr"]
[null,"最大増殖速度","mm [h-1]",0.25,null,1,307.91598224348076,94.227696851445529,1080.9741645319457,5.4246503842498903,null,{"$f":"$D$11*$D$8*$D$3/$D$12+$D$9*$D$11*$I$4*$D$3/$D$12-(1+$D$9)*$D$11*G4*$D$3/$D$12+$D$4*H4/($D$5+H4)*G4","v":2.8475000135586015E-10},{"$f":"$D$11*$D$10*$D$3/$D$12+$D$9*$D$11*$J$4*$D$3/$D$12-(1+$D$9)*$D$11*H4*$D$3/$D$12-$D$4*H4/($D$5+H4)*G4/$D$6","v":-5.695000027117203E-10},{"$f":"(1+$D$9)*$D$11*$G$8-$D$11*($D$9+$D$13)*$I$4-(1-$D$13)*$D$11*$D$7","v":0},{"$f":"H8-J4","v":0}]
[null,"基質飽和定数","Ks [g m-3]",100,null,2,328.84598629889115,52.367688740624743,null,null,null,{"$f":"(1+$D$9)*$D$11*(G4-G5)*$D$3/$D$12+$D$4*H5/($D$5+H5)*G5","v":8.6672713450752781E-10},{"$f":"(1+$D$9)*$D$11*(H4-H5)*$D$3/$D$12-$D$4*H5/($D$5+H5)*G5/$D$6","v":-1.7334542690150556E-9}]
[null,"増殖収率","YX/S [g g-1]",0.5,null,3,341.96505609741655,26.12954914357395,null,null,null,{"$f":"(1+$D$9)*$D$11*(G5-G6)*$D$3/$D$12+$D$4*H6/($D$5+H6)*G6","v":1.5432597422204708E-9},{"$f":"(1+$D$9)*$D$11*(H5-H6)*$D$3/$D$12-$D$4*H6/($D$5+H6)*G6/$D$6","v":-3.0865265898682992E-9},null,{"$f":"ABS(SUM(L4:M8))+N4+O4","v":5.4995226150822418E-9}]
[null,"流出汚泥濃度","Xout [g m-3]",0,null,4,348.96036088772024,12.138939562966506,null,null,null,1.6124648283266652E-9,-3.2248479442387179E-9]
[null,"流入汚泥濃度","Xin [g m-3]",0,null,5,352.31750547707856,5.4246503842498903,null,null,null,1.1923795284474181E-9,-2.3847750441063909E-9]
[null,"リサイクル比","a [-]",0.35]
[null,"流入基質濃度","Sin [g m-3]",200]
[null,"排水流量","Q [m3 h-1]",280]
[null,"反応装置体積","V [m3]",1400]
[null,"余剰汚泥排出率","w [-]",0.09]
[]
[null,"基質濃度","S [g m-3]"]
[null,"汚泥濃度","X [g m-3]"]