{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["問題","実習","解答"],"not_rendered":{"charts":2,"images":2,"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,13,8]]}
[]
[null,"問題6.2 バイオフィルター出口における悪臭物質の濃度\n[VBAで連続してゴールシークを使う]"]
[null,"　問題6.1で数値的に解いた式(6.10)は実は解析的にも解ける。変形して積分形すると\n\n                                                                           (6.11)\n\nとなり、解析的に積分すると次の式(6.12)が得られる。\n\n                                                                           (6.12)\n\n前問のバイオフィルターの入口から出口(z=L=0.9 m)までの濃度Cの分布を、式(6.12)を用いて0.1 m刻みで計算しなさい。\n"]

{"sheet":"実習","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,1,9,3]]}
[]
[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 [m]","C [g m-3]","残余関数"]
[null,0,10]
[null,0.1,10]
[null,0.2,10]
[null,0.3,10]
[null,0.4,10]
[null,0.5,10]
[null,0.6,10]
[null,0.7,10]
[null,0.8,10]
[null,0.9,10]

{"sheet":"解答","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,1,9,3]]}
[]
[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 [m]","C [g m-3]","残余関数"]
[null,0,10.499999996745686,{"$f":"$C$4*($C$5-C12)+$C$3*LN($C$5/C12)-$C$2/($C$8/$C$6)*B12","v":4.1841185180795015E-9}]
[null,0.1,9.3168781526728637,{"$f":"$C$4*($C$5-C13)+$C$3*LN($C$5/C13)-$C$2/($C$8/$C$6)*B13","v":3.4505731605349865E-11}]
[null,0.2,8.1919484750659954,8.175847554525717E-9]
[null,0.3,7.1309603019864687,2.8282265418511088E-11]
[null,0.4,6.1397827358081312,4.9531934109836584E-11]
[null,0.5,5.2241228021920785,3.8831933224514614E-9]
[null,0.6,4.3891293400247546,-2.5938877712405883E-9]
[null,0.7,3.6388932517218606,-1.0480505352461478E-13]
[null,0.8,2.9758931494530061,-7.815970093361102E-14]
[null,0.9,2.4004817338193662,-3.3826257350710875E-9]