{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["まとめ(Input)","まとめ(Output)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"まとめ(Input)","index":0,"n_rows":38,"n_cols":38,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,21,37,22],[37,23,37,24],[37,25,37,26],[37,27,37,28],[37,29,37,30],[37,31,37,32],[37,33,37,34],[4,27,7,34],[37,1,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[37,15,37,16],[37,17,37,18],[37,19,37,20],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[29,5,29,6],[25,24,25,25],[9,24,9,26],[34,33,34,34],[32,7,32,8],[30,9,30,10],[31,9,31,10],[32,9,32,10],[30,11,30,12],[31,11,31,12],[32,11,32,12],[30,13,30,14],[30,17,30,18],[31,17,31,18],[31,13,31,14],[32,13,32,14],[30,15,30,16],[30,5,30,6],[31,5,31,6],[32,5,32,6],[30,7,30,8],[31,7,31,8],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,26],[29,7,29,8],[29,9,29,10],[34,9,34,10],[34,11,34,12],[34,13,34,14],[34,15,34,16],[34,17,34,18],[34,19,34,20],[34,1,34,4],[35,1,35,4],[36,1,36,4],[34,5,34,6],[34,7,34,8],[24,24,24,25],[23,31,23,32],[25,28,25,30],[34,21,34,22],[34,23,34,24],[34,25,34,26],[34,27,34,28],[34,29,34,30],[34,31,34,32],[29,31,29,32],[29,27,29,28],[29,29,29,30],[32,31,32,32],[30,29,30,30],[31,29,31,30],[32,29,32,30],[21,27,21,34],[23,33,23,34],[24,33,24,34],[24,28,24,30],[24,31,24,32],[30,31,30,32],[31,31,31,32],[29,33,29,34],[30,33,30,34],[31,33,31,34],[32,33,32,34],[32,17,32,18],[30,19,30,20],[31,19,31,20],[32,19,32,20],[31,15,31,16],[32,15,32,16],[36,25,36,26],[36,27,36,28],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[30,21,30,22],[31,21,31,22],[32,21,32,22],[30,27,30,28],[31,27,31,28],[32,27,32,28],[30,23,30,24],[31,23,31,24],[32,23,32,24],[30,25,30,26],[31,25,31,26],[32,25,32,26],[35,23,35,24],[35,25,35,26],[35,5,35,6],[36,5,36,6],[35,7,35,8],[36,7,36,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[2,27,3,34],[3,21,3,23],[3,24,3,26],[3,9,3,11],[3,12,3,14],[3,15,3,17],[3,18,3,20],[36,29,36,30],[35,31,35,32],[36,31,36,32],[35,27,35,28],[35,29,35,30],[36,9,36,10],[36,11,36,12],[36,13,36,14],[36,15,36,16],[36,17,36,18],[36,19,36,20],[36,21,36,22],[36,23,36,24],[35,15,35,16],[35,17,35,18],[35,19,35,20],[35,21,35,22],[7,24,7,26],[7,15,7,17],[4,1,7,1],[12,27,12,34],[4,9,4,11],[5,9,5,11],[5,12,5,14],[7,2,7,8],[4,2,4,8],[5,2,5,8],[6,2,6,8],[8,18,8,20],[8,21,8,23],[8,24,8,26],[4,24,4,26],[5,15,5,17],[5,24,5,26],[6,9,6,11],[6,12,6,14],[7,9,7,11],[7,12,7,14],[6,18,6,20],[6,21,6,23],[8,27,8,34],[6,24,6,26],[10,27,10,34],[8,1,13,1],[12,9,12,11],[12,12,12,14],[10,18,10,20],[10,21,10,23],[11,18,11,20],[11,21,11,23],[11,9,11,11],[11,12,11,14],[12,15,12,17],[10,24,10,26],[9,27,9,34],[13,27,13,34],[9,2,9,6],[9,7,9,8],[13,7,13,8],[12,2,12,6],[12,7,12,8],[9,9,9,11],[9,12,9,14],[9,15,9,17],[9,18,9,20],[2,1,3,8],[9,21,9,23],[8,2,8,8],[8,9,8,11],[8,12,8,14],[8,15,8,17],[4,12,4,14],[4,18,4,20],[4,21,4,23],[4,15,4,17],[7,21,7,23],[6,15,6,17],[7,18,7,20],[5,18,5,20],[5,21,5,23],[2,9,2,17],[2,18,2,26],[14,27,14,34],[11,24,11,26],[10,15,10,17],[11,15,11,17],[10,9,10,11],[10,12,10,14],[14,9,14,11],[14,12,14,14],[13,24,13,25],[13,15,13,16],[13,9,13,11],[13,18,13,20],[14,18,14,20],[14,21,14,23],[14,24,14,26],[14,15,14,17],[11,27,11,34],[18,9,18,11],[12,18,12,20],[12,21,12,23],[12,24,12,26],[24,9,24,10],[25,9,25,10],[25,5,25,6],[24,5,24,6],[23,5,23,6],[23,7,23,8],[24,7,24,8],[25,7,25,8],[23,9,23,10],[17,12,17,14],[16,9,16,11],[19,7,19,8],[15,7,15,8],[16,7,16,8],[20,7,20,8],[21,7,21,8],[23,24,23,25],[23,16,23,17],[24,14,24,15],[24,16,24,17],[22,1,22,6],[23,26,23,27],[24,3,24,4],[25,3,25,4],[17,9,17,11],[15,27,15,34],[16,27,16,34],[17,27,17,34],[23,3,23,4],[20,27,20,34],[23,1,23,2],[25,26,25,27],[25,14,25,15],[25,16,25,17],[22,7,22,13],[18,27,18,34],[19,27,19,34],[24,21,24,23],[25,21,25,23],[23,14,23,15],[23,21,23,23],[22,14,22,20],[23,18,23,20],[23,28,23,30],[14,1,21,1],[16,12,16,14],[16,21,16,23],[16,24,16,26],[15,2,15,6],[35,33,35,34],[36,33,36,34],[19,16,19,17],[19,9,19,15],[19,25,19,26],[19,18,19,24],[17,18,17,20],[17,21,17,23],[20,9,20,26],[21,9,21,26],[24,11,24,13],[23,11,23,13],[25,11,25,13],[24,18,24,20],[25,18,25,20],[22,21,22,34],[24,26,24,27],[24,1,24,2],[25,1,25,2],[28,31,28,32],[11,2,11,6],[11,7,11,8],[10,2,10,6],[10,7,10,8],[15,9,15,11],[15,12,15,14],[15,15,15,17],[17,24,17,26],[18,18,18,20],[18,21,18,23],[18,24,18,26],[17,7,17,8],[18,7,18,8],[15,18,15,20],[15,21,15,23],[15,24,15,26],[18,12,18,14],[16,15,16,17],[17,15,17,17],[18,15,18,17],[16,18,16,20],[14,2,14,6],[14,7,14,8]]}
["INPUT"]
[null,"【前提条件】"]
[null,null,null,null,null,null,null,null,null,"【費用回収年を重視する場合】",null,null,null,null,null,null,null,null,"【未利用消化ガス全量利用を重視する場合】",null,null,null,null,null,null,null,null,"備考"]
[null,null,null,null,null,null,null,null,null,"供給処理場1",null,null,"供給処理場2",null,null,"集約処理場",null,null,"供給処理場1",null,null,"供給処理場2",null,null,"集約処理場"]
[null,"装置構成","PSA",null,null,null,null,null,null,"〇",null,null,"〇",null,null,"×",null,null,"〇",null,null,"〇",null,null,"×",null,null,"装置構成は変更不可"]
[null,null,"吸蔵装置",null,null,null,null,null,null,"〇",null,null,"〇",null,null,"×",null,null,"〇",null,null,"〇",null,null,"×"]
[null,null,"シロキサン除去装置",null,null,null,null,null,null,"×",null,null,"×",null,null,"〇",null,null,"×",null,null,"×",null,null,"〇"]
[null,null,"低濃度CH4対応型余剰ガス燃焼装置",null,null,null,null,null,null,"×",null,null,"×",null,null,"×",null,null,"〇",null,null,"〇",null,null,"×"]
[null,"装置仕様","ボイラ等既存設備の分岐位置",null,null,null,null,null,null,"二次側",null,null,"二次側",null,null,"PSA無し",null,null,"二次側",null,null,"二次側",null,null,"PSA無し",null,null,"オフガス返送配管の一次側or二次側を選択",null,null,null,null,null,null,null,null,null,"一次側"]
[null,null,"PSAリサイクル率",null,null,null,null,"[-]",null,0.9,null,null,0.9,null,null,"-",null,null,"成り行き",null,null,"成り行き",null,null,"-",null,null,"PSA設定値",null,null,null,null,null,null,null,null,null,"二次側"]
[null,null,"PSA精製ガスCH4濃度",null,null,null,null,"[vol%]",null,90,null,null,90,null,null,"-",null,null,90,null,null,90,null,null,"-",null,null,"発電機仕様より決定",null,null,null,null,null,null,null,null,null,"PSA無し"]
[null,null,"PSAオフガスCH4濃度",null,null,null,null,"[vol%]",null,"成り行き",null,null,"成り行き",null,null,"-",null,null,20,null,null,20,null,null,"-",null,null,"新設余剰ガス燃焼装置仕様より決定"]
[null,null,"ガスホルダCH4濃度(要求)",null,null,null,null,"[vol%]",null,50,null,null,50,null,null,"成り行き",null,null,"成り行き",null,null,"成り行き",null,null,"成り行き",null,null,"既設ボイラ、余剰ガス燃焼装置仕様より決定"]
[null,null,"発電機出力",null,null,null,null,null,null,360,null,null,"kW (> 　max",null,null,{"$f":"'まとめ(Output)'!AF33/'まとめ(Output)'!AH33","v":355.30578112619469},null,")",400,null,null,"kW (> 　max",null,null,{"$f":"'まとめ(Output)'!AF60/'まとめ(Output)'!AH60","v":390.56283718116174},null,")","maxより大きい出力(一の位切り上げ）を選定"]
[null,"輸送条件","吸蔵時間",null,null,null,null,"[時間/回]",null,24,null,null,24,null,null,"-",null,null,24,null,null,24,null,null,"-",null,null,"運転スケジュールより決定"]
[null,null,"吸蔵容器数",null,null,null,null,"[基]",null,3,null,null,3,null,null,"-",null,null,3,null,null,3,null,null,"-",null,null,"運転スケジュールより決定"]
[null,null,"運搬日中拘束時間",null,null,null,null,"[時間]",null,3.5,null,null,3.5,null,null,"-",null,null,3.5,null,null,3.5,null,null,"-",null,null,"運転スケジュールより決定"]
[null,null,"運搬夜間拘束時間",null,null,null,null,"[時間]",null,0,null,null,0,null,null,"-",null,null,0,null,null,0,null,null,"-",null,null,"運転スケジュールより決定"]
[null,null,"往復回数",null,null,null,null,"[回]",null,1,null,null,1,null,null,"-",null,null,1,null,null,1,null,null,"-",null,null,"運転スケジュールより決定"]
[null,null,"集約処理場までの距離",null,null,null,null,"[km]",null,"供給処理場1 ⇔ 集約処理場 ：",null,null,null,null,null,null,15,null,"供給処理場2 ⇔ 集約処理場 ：",null,null,null,null,null,null,15,null,"処理場条件より決定"]
[null,null,"トラック燃料費",null,null,null,null,"[円/ℓ]",null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"軽油価格"]
[null,null,"トラック燃費",null,null,null,null,"[km/ℓ]",null,4.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"トラック仕様より決定"]
[null,"補助燃料",null,null,null,null,null,"GHG換算係数",null,null,null,null,null,null,"エネルギー換算係数",null,null,null,null,null,null,"その他"]
[null,"価格",null,320,null,"円/Nm3",null,"電力",null,0.51200000000000001,null,"kg-CO2/kWh",null,null,"電力",null,9.484,null,"MJ/kWh",null,null,"稼働日数",null,null,350,null,"日/年",null,"売電価格",null,null,15,null,"円/kWh"]
[null,"基本料金",null,1.5,null,"千円/月",null,"軽油",null,2.58,null,"kg-CO2/ℓ",null,null,"軽油",null,38.04,null,"MJ/ℓ",null,null,"人件費単価",null,null,3,null,"千円/時間",null,"買電価格",null,null,15,null,"円/kWh"]
[null,"使用量",null,2,null,"Nm3/日",null,"プロパンガス",null,3,null,"kg-CO2/kg",null,null,"プロパンガス",null,50.06,null,"MJ/kg",null,null,"現場作業",null,null,8,null,"時間/月"]
[]
[null,"【消化ガス情報(既存設備の状況調査)】"]
[null,"バイオガス発生量FD[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,765.997326631448,null,760.61492291964259,null,749.96378184132698,null,733.83349686536724,null,706.6382500365944,null,676.61399375089059,null,674.97157842102183,null,676.55414094492937,null,704.79491871931396,null,724.7511469453367,null,722.4183576992142,null,734.42409816762154,null,{"$f":"AVERAGE(F31:AC31)","v":719.29800107855897},null,{"$f":"MAX(F31:AC31)","v":765.997326631448},null,60]
[null,"供給処理場2",null,null,null,765.99732663144778,null,760.61492291964259,null,749.96378184132664,null,733.83349686536724,null,706.6382500365944,null,676.61399375089059,null,674.97157842102183,null,676.55414094492937,null,704.79491871931396,null,724.7511469453367,null,722.4183576992142,null,734.42409816762154,null,{"$f":"AVERAGE(F32:AC32)","v":719.29800107855897},null,{"$f":"MAX(F32:AC32)","v":765.99732663144778},null,60]
[null,"集約処理場",null,null,null,3194.77042400868,null,3172.3218545545683,null,3127.8987876378874,null,3060.6236737694794,null,2947.1995569722908,null,2821.9763967215313,null,2815.1263206998851,null,2821.7267666410721,null,2939.5115139865616,null,3022.7436161032051,null,3013.0141747202542,null,3063.0869141845869,null,{"$f":"AVERAGE(F33:AC33)","v":3000},null,{"$f":"MAX(F33:AC33)","v":3194.77042400868},null,60]
[null,"ボイラー使用量FB1[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大"]
[null,"供給処理場1",null,null,null,240.52644658287787,null,212.22921757312756,null,198.08060306825237,null,169.78337405850201,null,127.33753054387653,null,127.33753054387653,null,169.78337405850201,null,226.37783207800271,null,240.52644658287787,null,297.12090460237857,null,311.2695191072537,null,311.2695191072537,null,{"$f":"AVERAGE(F36:AC36)","v":219.30352482556509},null,{"$f":"MAX(F36:AC36)","v":311.2695191072537}]
[null,"供給処理場2",null,null,null,240.52644658287787,null,212.22921757312756,null,198.08060306825237,null,169.78337405850201,null,127.33753054387653,null,127.33753054387653,null,169.78337405850201,null,226.37783207800271,null,240.52644658287787,null,297.12090460237857,null,311.2695191072537,null,311.2695191072537,null,{"$f":"AVERAGE(F37:AC37)","v":219.30352482556509},null,{"$f":"MAX(F37:AC37)","v":311.2695191072537}]
[null,"集約処理場",null,null,null,1003.1716182537057,null,885.1514278709169,null,826.14133267952241,null,708.12114229673341,null,531.09085672255003,null,531.09085672255003,null,708.12114229673341,null,944.16152306231129,null,1003.1716182537057,null,1239.2119990192832,null,1298.2220942106778,null,1298.2220942106778,null,{"$f":"AVERAGE(F38:AC38)","v":914.65647546661387},null,{"$f":"MAX(F38:AC38)","v":1298.2220942106778}]

{"sheet":"まとめ(Output)","index":1,"n_rows":86,"n_cols":34,"rows_kept":86,"cut":false,"hidden":false,"merged":[[9,13,9,14],[10,13,10,14],[11,13,11,14],[12,13,12,14],[36,13,36,14],[37,13,37,14],[38,13,38,14],[39,13,39,14],[39,1,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[9,11,9,12],[10,11,10,12],[11,11,11,12],[12,11,12,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[36,1,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[38,5,38,6],[38,7,38,8],[38,9,38,10],[89,13,89,14],[82,1,82,6],[82,8,82,9],[82,11,82,12],[82,14,82,15],[78,2,78,5],[79,2,79,5],[78,8,78,9],[78,11,78,12],[78,14,78,15],[72,11,72,12],[81,8,81,9],[81,11,81,12],[81,14,81,15],[79,8,79,9],[79,11,79,12],[90,13,90,14],[91,13,91,14],[89,31,89,32],[90,31,90,32],[91,31,91,32],[92,31,92,32],[83,1,83,6],[84,1,84,6],[85,1,85,6],[87,31,87,32],[88,31,88,32],[83,19,83,20],[84,19,84,20],[85,19,85,20],[82,33,82,34],[82,22,82,23],[82,25,82,26],[82,28,82,29],[82,31,82,32],[80,17,80,18],[81,17,81,18],[80,22,80,23],[72,31,72,32],[73,31,73,32],[80,31,80,32],[81,31,81,32],[80,25,80,26],[80,28,80,29],[81,22,81,23],[81,25,81,26],[79,17,79,18],[79,22,79,23],[79,25,79,26],[79,28,79,29],[79,31,79,32],[78,22,78,23],[78,25,78,26],[78,31,78,32],[64,2,64,5],[65,2,65,5],[66,2,66,5],[67,2,67,5],[68,2,68,5],[69,2,69,5],[70,2,70,5],[71,2,71,5],[72,2,72,5],[76,31,76,32],[77,8,77,9],[77,11,77,12],[77,14,77,15],[77,17,77,18],[77,22,77,23],[77,25,77,26],[77,28,77,29],[77,31,77,32],[78,28,78,29],[80,2,80,5],[80,8,80,9],[80,11,80,12],[80,14,80,15],[73,2,73,5],[74,2,74,5],[75,2,75,5],[76,2,76,5],[77,2,77,5],[78,17,78,18],[76,25,76,26],[76,28,76,29],[79,14,79,15],[74,11,74,12],[74,14,74,15],[74,17,74,18],[74,22,74,23],[74,25,74,26],[74,28,74,29],[75,8,75,9],[75,11,75,12],[75,14,75,15],[73,8,73,9],[63,33,72,34],[73,33,73,34],[74,1,81,1],[81,2,81,4],[74,33,80,34],[74,31,74,32],[75,17,75,18],[75,22,75,23],[75,25,75,26],[75,28,75,29],[75,31,75,32],[81,33,81,34],[81,28,81,29],[76,8,76,9],[76,11,76,12],[76,14,76,15],[76,17,76,18],[76,22,76,23],[72,8,72,9],[81,5,81,6],[74,19,80,20],[81,19,81,20],[73,28,73,29],[74,8,74,9],[73,11,73,12],[73,14,73,15],[73,17,73,18],[70,8,70,9],[70,11,70,12],[70,14,70,15],[70,17,70,18],[72,22,72,23],[73,22,73,23],[72,14,72,15],[71,8,71,9],[71,11,71,12],[71,14,71,15],[71,17,71,18],[71,22,71,23],[71,25,71,26],[71,28,71,29],[71,31,71,32],[72,17,72,18],[72,25,72,26],[72,28,72,29],[9,7,9,8],[64,1,73,1],[62,1,63,6],[68,31,68,32],[69,8,69,9],[69,11,69,12],[69,22,69,23],[69,25,69,26],[69,17,69,18],[69,31,69,32],[69,14,69,15],[69,28,69,29],[64,22,64,23],[64,25,64,26],[64,28,64,29],[63,19,72,20],[73,19,73,20],[65,14,65,15],[13,1,13,32],[40,1,40,32],[18,1,18,32],[45,1,45,32],[22,1,22,32],[49,1,49,32],[26,1,26,32],[53,1,53,32],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[10,7,10,8],[11,7,11,8],[12,7,12,8],[28,17,28,18],[29,17,29,18],[30,17,30,18],[32,17,32,18],[28,19,28,20],[29,19,29,20],[30,19,30,20],[32,19,32,20],[37,1,37,4],[67,11,67,12],[67,14,67,15],[67,17,67,18],[67,28,67,29],[67,31,67,32],[67,22,67,23],[67,25,67,26],[64,31,64,32],[70,31,70,32],[68,17,68,18],[65,22,65,23],[65,25,65,26],[65,28,65,29],[65,31,65,32],[66,11,66,12],[66,14,66,15],[66,17,66,18],[66,22,66,23],[66,25,66,26],[66,28,66,29],[66,31,66,32],[73,25,73,26],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[58,33,58,34],[7,1,7,34],[34,1,34,34],[28,31,28,32],[29,31,29,32],[30,31,30,32],[32,31,32,32],[31,33,31,34],[57,25,57,26],[57,27,57,28],[57,29,57,30],[57,31,57,32],[55,25,55,26],[56,25,56,26],[28,25,28,26],[29,25,29,26],[30,25,30,26],[35,1,35,34],[8,1,8,34],[59,33,59,34],[1,33,1,34],[13,33,13,34],[40,33,40,34],[18,33,18,34],[45,33,45,34],[22,33,22,34],[59,25,59,26],[55,27,55,28],[56,27,56,28],[59,27,59,28],[55,29,55,30],[56,29,56,30],[59,29,59,30],[55,31,55,32],[56,31,56,32],[59,31,59,32],[50,33,50,34],[49,33,49,34],[23,33,23,34],[47,25,47,26],[48,25,48,26],[47,27,47,28],[1,1,1,32],[59,17,59,18],[55,19,55,20],[56,19,56,20],[59,19,59,20],[55,21,55,22],[56,21,56,22],[59,21,59,22],[55,23,55,24],[56,23,56,24],[59,23,59,24],[57,17,57,18],[57,19,57,20],[57,21,57,22],[57,23,57,24],[55,17,55,18],[56,17,56,18],[58,17,58,18],[58,19,58,20],[58,21,58,22],[58,23,58,24],[59,9,59,10],[55,11,55,12],[56,11,56,12],[57,11,57,12],[59,11,59,12],[55,13,55,14],[56,13,56,14],[57,13,57,14],[57,15,57,16],[59,13,59,14],[55,15,55,16],[56,15,56,16],[59,15,59,16],[55,9,55,10],[56,9,56,10],[57,9,57,10],[58,15,58,16],[58,9,58,10],[58,11,58,12],[58,13,58,14],[59,1,59,2],[59,3,59,4],[55,5,55,6],[56,5,56,6],[57,5,57,6],[59,5,59,6],[55,7,55,8],[56,7,56,8],[57,7,57,8],[59,7,59,8],[55,1,55,4],[56,1,56,4],[57,1,57,4],[58,7,58,8],[28,21,28,22],[29,21,29,22],[30,21,30,22],[32,21,32,22],[28,11,28,12],[29,11,29,12],[30,11,30,12],[32,11,32,12],[28,13,28,14],[29,13,29,14],[30,13,30,14],[32,13,32,14],[28,15,28,16],[29,15,29,16],[30,15,30,16],[32,15,32,16],[54,1,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[54,15,54,16],[54,17,54,18],[54,19,54,20],[54,21,54,22],[54,23,54,24],[54,25,54,26],[54,27,54,28],[54,29,54,30],[54,31,54,32],[53,33,53,34],[48,15,48,16],[47,17,47,18],[50,15,50,16],[50,17,50,18],[50,19,50,20],[50,21,50,22],[50,23,50,24],[50,25,50,26],[50,27,50,28],[50,29,50,30],[50,31,50,32],[51,23,51,24],[52,23,52,24],[51,21,51,22],[52,21,52,22],[51,19,51,20],[51,13,51,14],[52,13,52,14],[51,11,51,12],[52,11,52,12],[51,9,51,10],[52,9,52,10],[51,7,51,8],[52,7,52,8],[50,11,50,12],[50,13,50,14],[24,25,24,26],[25,25,25,26],[52,19,52,20],[51,17,51,18],[52,17,52,18],[51,15,51,16],[52,15,52,16],[51,33,51,34],[52,33,52,34],[51,31,51,32],[52,31,52,32],[51,29,51,30],[52,29,52,30],[51,27,51,28],[52,27,52,28],[51,25,51,26],[52,25,52,26],[47,15,47,16],[27,15,27,16],[27,17,27,18],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,26],[51,1,51,4],[52,1,52,4],[24,5,24,6],[25,5,25,6],[24,7,24,8],[25,7,25,8],[24,9,24,10],[25,9,25,10],[52,5,52,6],[50,1,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[44,1,44,4],[51,5,51,6],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[28,1,28,4],[29,1,29,4],[30,1,30,4],[32,1,32,2],[32,3,32,4],[44,25,44,26],[44,27,44,28],[44,29,44,30],[44,31,44,32],[44,33,44,34],[42,33,42,34],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[23,15,23,16],[23,17,23,18],[23,19,23,20],[24,1,24,4],[25,1,25,4],[24,11,24,12],[25,11,25,12],[24,13,24,14],[25,13,25,14],[24,15,24,16],[25,15,25,16],[24,17,24,18],[48,27,48,28],[47,29,47,30],[48,29,48,30],[47,31,47,32],[48,31,48,32],[47,33,47,34],[48,33,48,34],[24,27,24,28],[25,27,25,28],[24,29,24,30],[25,29,25,30],[24,31,24,32],[25,31,25,32],[24,33,24,34],[25,33,25,34],[26,33,26,34],[27,29,27,30],[27,31,27,32],[28,29,28,30],[29,29,29,30],[30,29,30,30],[32,29,32,30],[27,27,27,28],[32,33,32,34],[32,25,32,26],[28,27,28,28],[21,33,21,34],[48,17,48,18],[47,19,47,20],[48,19,48,20],[47,21,47,22],[48,21,48,22],[47,23,47,24],[48,23,48,24],[23,21,23,22],[23,23,23,24],[23,25,23,26],[23,27,23,28],[23,29,23,30],[23,31,23,32],[41,21,41,22],[41,23,41,24],[41,25,41,26],[41,27,41,28],[41,29,41,30],[41,31,41,32],[41,33,41,34],[41,17,41,18],[48,5,48,6],[47,7,47,8],[48,7,48,8],[47,9,47,10],[48,9,48,10],[47,11,47,12],[48,11,48,12],[47,13,47,14],[48,13,48,14],[20,17,20,18],[21,17,21,18],[20,19,20,20],[21,19,21,20],[20,21,20,22],[21,21,21,22],[20,23,20,24],[21,23,21,24],[47,5,47,6],[44,23,44,24],[25,17,25,18],[24,19,24,20],[25,19,25,20],[24,21,24,22],[25,21,25,22],[24,23,24,24],[25,23,25,24],[27,11,27,12],[27,13,27,14],[28,5,28,6],[29,5,29,6],[30,5,30,6],[32,5,32,6],[28,7,28,8],[46,1,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[46,17,46,18],[46,19,46,20],[19,17,19,18],[19,19,19,20],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[66,8,66,9],[67,8,67,9],[68,8,68,9],[44,5,44,6],[44,7,44,8],[17,5,17,6],[41,5,41,6],[41,7,41,8],[41,9,41,10],[42,9,42,10],[43,9,43,10],[44,19,44,20],[20,5,20,6],[21,5,21,6],[20,7,20,8],[21,7,21,8],[20,9,20,10],[21,9,21,10],[62,7,62,20],[82,19,82,20],[62,21,62,34],[63,7,63,9],[64,8,64,9],[65,8,65,9],[63,10,63,12],[64,11,64,12],[65,11,65,12],[63,13,63,15],[64,14,64,15],[63,16,63,18],[63,21,63,23],[63,24,63,26],[63,27,63,29],[68,11,68,12],[68,14,68,15],[68,22,68,23],[68,25,68,26],[68,28,68,29],[65,17,65,18],[70,22,70,23],[70,25,70,26],[70,28,70,29],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[64,17,64,18],[14,5,14,6],[15,5,15,6],[14,1,14,4],[15,1,15,4],[42,5,42,6],[16,5,16,6],[44,9,44,10],[44,11,44,12],[44,13,44,14],[44,15,44,16],[44,17,44,18],[47,1,47,4],[48,1,48,4],[5,5,5,6],[2,15,2,16],[2,17,2,18],[2,5,2,6],[43,5,43,6],[2,13,2,14],[2,19,2,20],[5,7,5,8],[5,15,5,16],[5,13,5,14],[3,11,3,12],[4,11,4,12],[5,11,5,12],[3,9,3,10],[4,9,4,10],[5,9,5,10],[2,7,2,8],[2,9,2,10],[2,11,2,12],[3,5,3,6],[4,5,4,6],[3,7,3,8],[4,7,4,8],[3,29,3,30],[4,29,4,30],[3,27,3,28],[4,27,4,28],[3,21,3,22],[4,21,4,22],[3,15,3,16],[4,15,4,16],[3,13,3,14],[4,13,4,14],[5,29,5,30],[3,31,3,32],[4,31,4,32],[5,31,5,32],[3,33,3,34],[4,33,4,34],[5,33,5,34],[41,19,41,20],[2,31,2,32],[2,33,2,34],[2,21,2,22],[2,23,2,24],[2,25,2,26],[2,27,2,28],[2,29,2,30],[19,21,19,22],[19,23,19,24],[19,25,19,26],[19,27,19,28],[19,29,19,30],[19,31,19,32],[19,33,19,34],[20,25,20,26],[21,25,21,26],[5,21,5,22],[3,19,3,20],[4,19,4,20],[5,19,5,20],[3,17,3,18],[4,17,4,18],[5,17,5,18],[5,27,5,28],[3,25,3,26],[4,25,4,26],[5,25,5,26],[3,23,3,24],[4,23,4,24],[5,23,5,24],[14,33,14,34],[15,33,15,34],[17,33,17,34],[15,25,15,26],[16,25,16,26],[17,25,17,26],[15,31,15,32],[16,31,16,32],[17,31,17,32],[16,33,16,34],[17,29,17,30],[20,27,20,28],[21,27,21,28],[20,29,20,30],[21,29,21,30],[20,31,20,32],[21,31,21,32],[20,33,20,34],[14,17,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,24],[14,25,14,26],[14,27,14,28],[14,29,14,30],[14,31,14,32],[17,23,17,24],[15,19,15,20],[16,19,16,20],[17,19,17,20],[15,21,15,22],[16,21,16,22],[17,21,17,22],[15,29,15,30],[16,29,16,30],[43,1,43,4],[17,9,17,10],[15,11,15,12],[14,7,14,8],[15,7,15,8],[42,7,42,8],[16,7,16,8],[43,7,43,8],[17,7,17,8],[42,1,42,4],[14,9,14,10],[14,11,14,12],[42,11,42,12],[43,11,43,12],[29,7,29,8],[30,7,30,8],[32,7,32,8],[28,9,28,10],[29,9,29,10],[30,9,30,10],[32,9,32,10],[37,5,37,6],[37,7,37,8],[37,9,37,10],[41,1,41,4],[41,11,41,12],[41,13,41,14],[41,15,41,16],[16,1,16,4],[17,1,17,4],[15,9,15,10],[16,9,16,10],[15,15,15,16],[16,15,16,16],[17,15,17,16],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[19,15,19,16],[20,1,20,4],[21,1,21,4],[20,11,20,12],[21,11,21,12],[21,15,21,16],[38,1,38,4],[15,17,15,18],[16,17,16,18],[17,17,17,18],[16,11,16,12],[17,11,17,12],[15,13,15,14],[16,13,16,14],[17,13,17,14],[14,13,14,14],[14,15,14,16],[42,13,42,14],[43,13,43,14],[42,15,42,16],[43,15,43,16],[42,17,42,18],[43,17,43,18],[42,19,42,20],[43,19,43,20],[15,27,15,28],[16,27,16,28],[17,27,17,28],[15,23,15,24],[16,23,16,24],[42,27,42,28],[28,23,28,24],[29,23,29,24],[30,23,30,24],[32,23,32,24],[29,27,29,28],[30,27,30,28],[32,27,32,28],[20,13,20,14],[21,13,21,14],[20,15,20,16],[83,33,83,34],[84,33,84,34],[85,33,85,34],[43,27,43,28],[42,29,42,30],[43,29,43,30],[42,31,42,32],[43,31,43,32],[43,21,43,22],[42,23,42,24],[43,23,43,24],[42,25,42,26],[43,25,43,26],[42,21,42,22],[43,33,43,34],[63,30,63,32],[46,21,46,22],[46,23,46,24],[46,25,46,26],[46,27,46,28],[46,29,46,30],[46,31,46,32],[46,33,46,34],[44,21,44,22],[58,25,58,26],[58,27,58,28],[58,29,58,30],[58,31,58,32],[70,40,70,42],[27,33,30,34],[31,1,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[31,17,31,18],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,26],[31,27,31,28],[31,29,31,30],[31,31,31,32],[54,33,57,34],[58,1,58,4],[58,5,58,6]]}
["OUTPUT"]
[null,"未利用消化ガス量FU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,{"$f":"'まとめ(Input)'!F31-'まとめ(Input)'!F36","v":525.47088004857017},null,{"$f":"'まとめ(Input)'!H31-'まとめ(Input)'!H36","v":548.38570534651501},null,{"$f":"'まとめ(Input)'!J31-'まとめ(Input)'!J36","v":551.88317877307463},null,{"$f":"'まとめ(Input)'!L31-'まとめ(Input)'!L36","v":564.05012280686526},null,{"$f":"'まとめ(Input)'!N31-'まとめ(Input)'!N36","v":579.30071949271792},null,{"$f":"'まとめ(Input)'!P31-'まとめ(Input)'!P36","v":549.2764632070141},null,{"$f":"'まとめ(Input)'!R31-'まとめ(Input)'!R36","v":505.18820436251985},null,{"$f":"'まとめ(Input)'!T31-'まとめ(Input)'!T36","v":450.17630886692666},null,{"$f":"'まとめ(Input)'!V31-'まとめ(Input)'!V36","v":464.26847213643612},null,{"$f":"'まとめ(Input)'!X31-'まとめ(Input)'!X36","v":427.63024234295813},null,{"$f":"'まとめ(Input)'!Z31-'まとめ(Input)'!Z36","v":411.1488385919605},null,{"$f":"'まとめ(Input)'!AB31-'まとめ(Input)'!AB36","v":423.15457906036784},null,{"$f":"MAX(AVERAGE(F4:AC4),'まとめ(Input)'!AD31-'まとめ(Input)'!AD36)","v":499.99447625299388},null,{"$f":"MAX(F4:AC4,'まとめ(Input)'!AF31-'まとめ(Input)'!AF36)","v":579.30071949271792},null,{"$f":"'まとめ(Input)'!AH31","v":60}]
[null,"供給処理場2",null,null,null,{"$f":"'まとめ(Input)'!F32-'まとめ(Input)'!F37","v":525.47088004856994},null,{"$f":"'まとめ(Input)'!H32-'まとめ(Input)'!H37","v":548.38570534651501},null,{"$f":"'まとめ(Input)'!J32-'まとめ(Input)'!J37","v":551.88317877307429},null,{"$f":"'まとめ(Input)'!L32-'まとめ(Input)'!L37","v":564.05012280686526},null,{"$f":"'まとめ(Input)'!N32-'まとめ(Input)'!N37","v":579.30071949271792},null,{"$f":"'まとめ(Input)'!P32-'まとめ(Input)'!P37","v":549.2764632070141},null,{"$f":"'まとめ(Input)'!R32-'まとめ(Input)'!R37","v":505.18820436251985},null,{"$f":"'まとめ(Input)'!T32-'まとめ(Input)'!T37","v":450.17630886692666},null,{"$f":"'まとめ(Input)'!V32-'まとめ(Input)'!V37","v":464.26847213643612},null,{"$f":"'まとめ(Input)'!X32-'まとめ(Input)'!X37","v":427.63024234295813},null,{"$f":"'まとめ(Input)'!Z32-'まとめ(Input)'!Z37","v":411.1488385919605},null,{"$f":"'まとめ(Input)'!AB32-'まとめ(Input)'!AB37","v":423.15457906036784},null,{"$f":"MAX(AVERAGE(F5:AC5),'まとめ(Input)'!AD32-'まとめ(Input)'!AD37)","v":499.99447625299388},null,{"$f":"MAX(F5:AC5,'まとめ(Input)'!AF32-'まとめ(Input)'!AF37)","v":579.30071949271792},null,{"$f":"'まとめ(Input)'!AH32","v":60}]
[null,"集約処理場",null,null,null,{"$f":"'まとめ(Input)'!F33","v":3194.77042400868},null,{"$f":"'まとめ(Input)'!H33","v":3172.3218545545683},null,{"$f":"'まとめ(Input)'!J33","v":3127.8987876378874},null,{"$f":"'まとめ(Input)'!L33","v":3060.6236737694794},null,{"$f":"'まとめ(Input)'!N33","v":2947.1995569722908},null,{"$f":"'まとめ(Input)'!P33","v":2821.9763967215313},null,{"$f":"'まとめ(Input)'!R33","v":2815.1263206998851},null,{"$f":"'まとめ(Input)'!T33","v":2821.7267666410721},null,{"$f":"'まとめ(Input)'!V33","v":2939.5115139865616},null,{"$f":"'まとめ(Input)'!X33","v":3022.7436161032051},null,{"$f":"'まとめ(Input)'!Z33","v":3013.0141747202542},null,{"$f":"'まとめ(Input)'!AB33","v":3063.0869141845869},null,{"$f":"MAX(AVERAGE(F6:AC6),'まとめ(Input)'!AD33-'まとめ(Input)'!AD38)","v":3000},null,{"$f":"MAX(F6:AC6,'まとめ(Input)'!AF33-'まとめ(Input)'!AF38)","v":3194.77042400868},null,{"$f":"'まとめ(Input)'!AH33","v":60}]
[]
[null,"【費用回収年を重視する場合】"]
[null,"装置構成"]
[null,null,null,null,null,"PSA(位置)",null,"吸蔵装置",null,"シロキサン除去装置",null,"余剰ガス燃焼装置",null,"既存ボイラ"]
[null,"供給処理場1",null,null,null,{"$f":"'まとめ(Input)'!J9","v":"二次側"},null,{"$f":"IF(F11=\"PSA無し\",\"×\",\"〇\")","v":"〇"},null,{"$f":"IF(F11=\"PSA無し\",\"〇\",\"×\")","v":"×"},null,"×",null,"〇"]
[null,"供給処理場2",null,null,null,{"$f":"'まとめ(Input)'!M9","v":"二次側"},null,{"$f":"IF(F12=\"PSA無し\",\"×\",\"〇\")","v":"〇"},null,{"$f":"IF(F12=\"PSA無し\",\"〇\",\"×\")","v":"×"},null,"×",null,"〇"]
[null,"集約処理場",null,null,null,{"$f":"'まとめ(Input)'!P9","v":"PSA無し"},null,{"$f":"IF(F13=\"PSA無し\",\"×\",\"〇\")","v":"×"},null,{"$f":"IF(F13=\"PSA無し\",\"〇\",\"×\")","v":"〇"},null,"×",null,"×"]
[null,"利用可能消化ガス量FA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",F4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!F31,F4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":319.16555276310334},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",H4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!H31,H4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":316.92288454985106},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",J4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!J31,J4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":312.4849091005529},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",L4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!L31,L4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":305.76395702723636},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",N4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!N31,N4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":294.43260418191431},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",P4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!P31,P4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":281.92249739620439},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",R4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!R31,R4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":281.23815767542578},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",T4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!T31,T4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":281.89755872705388},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",V4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!V31,V4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":293.66454946638083},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",X4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!X31,X4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":301.97964456055695},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",Z4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!Z31,Z4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":301.00764904133922},null,{"$f":"IF('まとめ(Input)'!$J$9=\"PSA無し\",AB4,IF('まとめ(Input)'!$J$9=\"二次側\",'まとめ(Input)'!AB31,AB4)*('まとめ(Input)'!$AH$31-'まとめ(Input)'!$J$13)/('まとめ(Input)'!$AH$31*'まとめ(Input)'!$J$10*(1-'まとめ(Input)'!$J$13/'まとめ(Input)'!$J$11)))","v":306.01004090317565},null,{"$f":"AVERAGE(F16:AC16)","v":299.70750044939956},null,{"$f":"MAX(F16:AC16)","v":319.16555276310334},null,{"$f":"'まとめ(Input)'!AH31","v":60}]
[null,"供給処理場2",null,null,null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",F5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!F32,F5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":319.16555276310322},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",H5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!H32,H5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":316.92288454985106},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",J5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!J32,J5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":312.48490910055278},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",L5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!L32,L5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":305.76395702723636},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",N5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!N32,N5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":294.43260418191431},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",P5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!P32,P5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":281.92249739620439},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",R5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!R32,R5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":281.23815767542578},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",T5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!T32,T5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":281.89755872705388},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",V5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!V32,V5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":293.66454946638083},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",X5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!X32,X5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":301.97964456055695},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",Z5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!Z32,Z5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":301.00764904133922},null,{"$f":"IF('まとめ(Input)'!$M$9=\"PSA無し\",AB5,IF('まとめ(Input)'!$M$9=\"二次側\",'まとめ(Input)'!AB32,AB5)*('まとめ(Input)'!$AH$32-'まとめ(Input)'!$M$13)/('まとめ(Input)'!$AH$32*'まとめ(Input)'!$M$10*(1-'まとめ(Input)'!$M$13/'まとめ(Input)'!$M$11)))","v":306.01004090317565},null,{"$f":"AVERAGE(F17:AC17)","v":299.70750044939956},null,{"$f":"MAX(F17:AC17)","v":319.16555276310322},null,{"$f":"'まとめ(Input)'!AH32","v":60}]
[null,"集約処理場",null,null,null,{"$f":"F6-IF($N$13=\"×\",0,'まとめ(Input)'!F38)","v":3194.77042400868},null,{"$f":"H6-IF($N$13=\"×\",0,'まとめ(Input)'!H38)","v":3172.3218545545683},null,{"$f":"J6-IF($N$13=\"×\",0,'まとめ(Input)'!J38)","v":3127.8987876378874},null,{"$f":"L6-IF($N$13=\"×\",0,'まとめ(Input)'!L38)","v":3060.6236737694794},null,{"$f":"N6-IF($N$13=\"×\",0,'まとめ(Input)'!N38)","v":2947.1995569722908},null,{"$f":"P6-IF($N$13=\"×\",0,'まとめ(Input)'!P38)","v":2821.9763967215313},null,{"$f":"R6-IF($N$13=\"×\",0,'まとめ(Input)'!R38)","v":2815.1263206998851},null,{"$f":"T6-IF($N$13=\"×\",0,'まとめ(Input)'!T38)","v":2821.7267666410721},null,{"$f":"V6-IF($N$13=\"×\",0,'まとめ(Input)'!V38)","v":2939.5115139865616},null,{"$f":"X6-IF($N$13=\"×\",0,'まとめ(Input)'!X38)","v":3022.7436161032051},null,{"$f":"Z6-IF($N$13=\"×\",0,'まとめ(Input)'!Z38)","v":3013.0141747202542},null,{"$f":"AB6-IF($N$13=\"×\",0,'まとめ(Input)'!AB38)","v":3063.0869141845869},null,{"$f":"AVERAGE(F18:AC18)","v":3000},null,{"$f":"MAX(F18:AC18)","v":3194.77042400868},null,{"$f":"'まとめ(Input)'!AH33","v":60}]
[null,"精製ガス量FP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,{"$f":"F16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":191.499331657862},null,{"$f":"H16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":190.15373072991065},null,{"$f":"J16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":187.49094546033174},null,{"$f":"L16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":183.45837421634178},null,{"$f":"N16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":176.6595625091486},null,{"$f":"P16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":169.15349843772262},null,{"$f":"R16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":168.74289460525546},null,{"$f":"T16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":169.13853523623231},null,{"$f":"V16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":176.19872967982852},null,{"$f":"X16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":181.18778673633417},null,{"$f":"Z16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":180.60458942480352},null,{"$f":"AB16*$AH$16/$AH$21*'まとめ(Input)'!$J$10","v":183.60602454190541},null,{"$f":"AVERAGE(F21:AC21)","v":179.82450026963974},null,{"$f":"MAX(F21:AC21)","v":191.499331657862},null,{"$f":"IF(F11=\"PSA無し\",'まとめ(Input)'!AH31,'まとめ(Input)'!J11)","v":90}]
[null,"供給処理場2",null,null,null,{"$f":"F17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":191.49933165786197},null,{"$f":"H17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":190.15373072991065},null,{"$f":"J17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":187.49094546033169},null,{"$f":"L17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":183.45837421634178},null,{"$f":"N17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":176.6595625091486},null,{"$f":"P17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":169.15349843772262},null,{"$f":"R17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":168.74289460525546},null,{"$f":"T17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":169.13853523623231},null,{"$f":"V17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":176.19872967982852},null,{"$f":"X17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":181.18778673633417},null,{"$f":"Z17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":180.60458942480352},null,{"$f":"AB17*$AH$17/$AH$22*'まとめ(Input)'!$M$10","v":183.60602454190541},null,{"$f":"AVERAGE(F22:AC22)","v":179.82450026963969},null,{"$f":"MAX(F22:AC22)","v":191.49933165786197},null,{"$f":"IF(F12=\"PSA無し\",'まとめ(Input)'!AH32,'まとめ(Input)'!M11)","v":90}]
[null,"オフガス量FO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,{"$f":"F16-F21","v":127.66622110524133},null,{"$f":"H16-H21","v":126.76915381994041},null,{"$f":"J16-J21","v":124.99396364022115},null,{"$f":"L16-L21","v":122.30558281089458},null,{"$f":"N16-N21","v":117.77304167276571},null,{"$f":"P16-P21","v":112.76899895848177},null,{"$f":"R16-R21","v":112.49526307017032},null,{"$f":"T16-T21","v":112.75902349082156},null,{"$f":"V16-V21","v":117.46581978655232},null,{"$f":"X16-X21","v":120.79185782422277},null,{"$f":"Z16-Z21","v":120.4030596165357},null,{"$f":"AB16-AB21","v":122.40401636127024},null,{"$f":"AVERAGE(F25:AC25)","v":119.88300017975985},null,{"$f":"MAX(F25:AC25)","v":127.66622110524133},null,{"$f":"AD16*AH16*(1-'まとめ(Input)'!J10)/('まとめ(Output)'!AD16-'まとめ(Output)'!AD21)","v":14.999999999999996}]
[null,"供給処理場2",null,null,null,{"$f":"F17-F22","v":127.66622110524125},null,{"$f":"H17-H22","v":126.76915381994041},null,{"$f":"J17-J22","v":124.9939636402211},null,{"$f":"L17-L22","v":122.30558281089458},null,{"$f":"N17-N22","v":117.77304167276571},null,{"$f":"P17-P22","v":112.76899895848177},null,{"$f":"R17-R22","v":112.49526307017032},null,{"$f":"T17-T22","v":112.75902349082156},null,{"$f":"V17-V22","v":117.46581978655232},null,{"$f":"X17-X22","v":120.79185782422277},null,{"$f":"Z17-Z22","v":120.4030596165357},null,{"$f":"AB17-AB22","v":122.40401636127024},null,{"$f":"AVERAGE(F26:AC26)","v":119.8830001797598},null,{"$f":"MAX(F26:AC26)","v":127.66622110524125},null,{"$f":"AD17*AH17*(1-'まとめ(Input)'!M10)/('まとめ(Output)'!AD17-'まとめ(Output)'!AD22)","v":14.999999999999989}]
[null,"発電機利用ガス量(メタン量)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"発電機"]
[null,"供給処理場1",null,null,null,{"$f":"F21*$AH$21/100","v":172.34939849207581},null,{"$f":"H21*$AH$21/100","v":171.13835765691957},null,{"$f":"J21*$AH$21/100","v":168.74185091429857},null,{"$f":"L21*$AH$21/100","v":165.11253679470758},null,{"$f":"N21*$AH$21/100","v":158.99360625823374},null,{"$f":"P21*$AH$21/100","v":152.23814859395034},null,{"$f":"R21*$AH$21/100","v":151.86860514472991},null,{"$f":"T21*$AH$21/100","v":152.22468171260908},null,{"$f":"V21*$AH$21/100","v":158.57885671184567},null,{"$f":"X21*$AH$21/100","v":163.06900806270076},null,{"$f":"Z21*$AH$21/100","v":162.54413048232317},null,{"$f":"AB21*$AH$21/100","v":165.24542208771487},null,{"$f":"AVERAGE(F29:AC29)","v":161.84205024267575},null,{"$f":"MAX(F29:AC29)","v":172.34939849207581}]
[null,"供給処理場2",null,null,null,{"$f":"F22*$AH$22/100","v":172.34939849207578},null,{"$f":"H22*$AH$22/100","v":171.13835765691957},null,{"$f":"J22*$AH$22/100","v":168.74185091429851},null,{"$f":"L22*$AH$22/100","v":165.11253679470758},null,{"$f":"N22*$AH$22/100","v":158.99360625823374},null,{"$f":"P22*$AH$22/100","v":152.23814859395034},null,{"$f":"R22*$AH$22/100","v":151.86860514472991},null,{"$f":"T22*$AH$22/100","v":152.22468171260908},null,{"$f":"V22*$AH$22/100","v":158.57885671184567},null,{"$f":"X22*$AH$22/100","v":163.06900806270076},null,{"$f":"Z22*$AH$22/100","v":162.54413048232317},null,{"$f":"AB22*$AH$22/100","v":165.24542208771487},null,{"$f":"AVERAGE(F30:AC30)","v":161.84205024267575},null,{"$f":"MAX(F30:AC30)","v":172.34939849207578}]
[null,"集約処理場",null,null,null,{"$f":"F18*$AH$18/100","v":1916.862254405208},null,{"$f":"H18*$AH$18/100","v":1903.393112732741},null,{"$f":"J18*$AH$18/100","v":1876.7392725827324},null,{"$f":"L18*$AH$18/100","v":1836.3742042616877},null,{"$f":"N18*$AH$18/100","v":1768.3197341833743},null,{"$f":"P18*$AH$18/100","v":1693.1858380329186},null,{"$f":"R18*$AH$18/100","v":1689.0757924199311},null,{"$f":"T18*$AH$18/100","v":1693.0360599846433},null,{"$f":"V18*$AH$18/100","v":1763.7069083919371},null,{"$f":"X18*$AH$18/100","v":1813.6461696619233},null,{"$f":"Z18*$AH$18/100","v":1807.8085048321525},null,{"$f":"AB18*$AH$18/100","v":1837.8521485107519},null,{"$f":"AVERAGE(F31:AC31)","v":1800},null,{"$f":"MAX(F31:AC31)","v":1916.862254405208}]
[null,"発電機投入ガス量",null,null,null,{"$f":"F18+F21+F22","v":3577.7690873244042},null,{"$f":"H18+H21+H22","v":3552.6293160143896},null,{"$f":"J18+J21+J22","v":3502.8806785585507},null,{"$f":"L18+L21+L22","v":3427.540422202163},null,{"$f":"N18+N21+N22","v":3300.518681990588},null,{"$f":"P18+P21+P22","v":3160.2833935969766},null,{"$f":"R18+R21+R22","v":3152.6121099103962},null,{"$f":"T18+T21+T22","v":3160.0038371135365},null,{"$f":"V18+V21+V22","v":3291.9089733462183},null,{"$f":"X18+X21+X22","v":3385.1191895758734},null,{"$f":"Z18+Z21+Z22","v":3374.2233535698615},null,{"$f":"AB18+AB21+AB22","v":3430.2989632683975},null,{"$f":"AVERAGE(F32:AC32)","v":3359.6490005392793},null,{"$f":"MAX(F32:AC32)","v":3577.7690873244042},null,{"$f":"'まとめ(Input)'!J14","v":360}]
[null,"発電量",null,"[kW]",null,{"$f":"(F29+F30+F31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":355.30578112619469},null,{"$f":"(H29+H30+H31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":352.80916777172058},null,{"$f":"(J29+J30+J31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":347.86866488855952},null,{"$f":"(L29+L30+L31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":340.38667597826549},null,{"$f":"(N29+N30+N31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":327.77223454162333},null,{"$f":"(P29+P30+P31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":313.84556474600174},null,{"$f":"(R29+R30+R31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":313.08373485257528},null,{"$f":"(T29+T30+T31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":313.81780218439064},null,{"$f":"(V29+V30+V31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":326.91721031269964},null,{"$f":"(X29+X30+X31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":336.1738526163499},null,{"$f":"(Z29+Z30+Z31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":335.09179465546725},null,{"$f":"(AB29+AB30+AB31)/24*9.97*(-0.00002*'まとめ(Input)'!$J$14^2+0.0223*'まとめ(Input)'!$J$14+32.383)/100","v":340.66062478948976},null,{"$f":"AVERAGE(F33:AC33)","v":333.64442570527814},null,{"$f":"MAX(F33:AC33)","v":355.30578112619469},null,{"$f":"IF(AF33<800,1,IF(AF33<1600,2,3))","v":1}]
[]
[null,"【未利用消化ガス全量利用を重視する場合】"]
[null,"装置構成"]
[null,null,null,null,null,"PSA(位置)",null,"吸蔵装置",null,"シロキサン除去装置",null,"余剰ガス燃焼装置",null,"既存ボイラ"]
[null,"供給処理場1",null,null,null,{"$f":"'まとめ(Input)'!S9","v":"二次側"},null,{"$f":"IF(F38=\"PSA無し\",\"×\",\"〇\")","v":"〇"},null,{"$f":"IF(F38=\"PSA無し\",\"〇\",\"×\")","v":"×"},null,"〇",null,"〇"]
[null,"供給処理場2",null,null,null,{"$f":"'まとめ(Input)'!V9","v":"二次側"},null,{"$f":"IF(F39=\"PSA無し\",\"×\",\"〇\")","v":"〇"},null,{"$f":"IF(F39=\"PSA無し\",\"〇\",\"×\")","v":"×"},null,"〇",null,"〇"]
[null,"集約処理場",null,null,null,{"$f":"'まとめ(Input)'!Y9","v":"PSA無し"},null,{"$f":"IF(F40=\"PSA無し\",\"×\",\"〇\")","v":"×"},null,{"$f":"IF(F40=\"PSA無し\",\"〇\",\"×\")","v":"〇"},null,"×",null,"×"]
[null,"利用可能消化ガス量FA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,{"$f":"F4","v":525.47088004857017},null,{"$f":"H4","v":548.38570534651501},null,{"$f":"J4","v":551.88317877307463},null,{"$f":"L4","v":564.05012280686526},null,{"$f":"N4","v":579.30071949271792},null,{"$f":"P4","v":549.2764632070141},null,{"$f":"R4","v":505.18820436251985},null,{"$f":"T4","v":450.17630886692666},null,{"$f":"V4","v":464.26847213643612},null,{"$f":"X4","v":427.63024234295813},null,{"$f":"Z4","v":411.1488385919605},null,{"$f":"AB4","v":423.15457906036784},null,{"$f":"AVERAGE(F43:AC43)","v":499.99447625299376},null,{"$f":"MAX(F43:AC43)","v":579.30071949271792},null,{"$f":"'まとめ(Input)'!AH31","v":60}]
[null,"供給処理場2",null,null,null,{"$f":"F5","v":525.47088004856994},null,{"$f":"H5","v":548.38570534651501},null,{"$f":"J5","v":551.88317877307429},null,{"$f":"L5","v":564.05012280686526},null,{"$f":"N5","v":579.30071949271792},null,{"$f":"P5","v":549.2764632070141},null,{"$f":"R5","v":505.18820436251985},null,{"$f":"T5","v":450.17630886692666},null,{"$f":"V5","v":464.26847213643612},null,{"$f":"X5","v":427.63024234295813},null,{"$f":"Z5","v":411.1488385919605},null,{"$f":"AB5","v":423.15457906036784},null,{"$f":"AVERAGE(F44:AC44)","v":499.99447625299371},null,{"$f":"MAX(F44:AC44)","v":579.30071949271792},null,{"$f":"'まとめ(Input)'!AH32","v":60}]
[null,"集約処理場",null,null,null,{"$f":"F6-IF($N$40=\"×\",0,'まとめ(Input)'!F38)","v":3194.77042400868},null,{"$f":"H6-IF($N$40=\"×\",0,'まとめ(Input)'!H38)","v":3172.3218545545683},null,{"$f":"J6-IF($N$40=\"×\",0,'まとめ(Input)'!J38)","v":3127.8987876378874},null,{"$f":"L6-IF($N$40=\"×\",0,'まとめ(Input)'!L38)","v":3060.6236737694794},null,{"$f":"N6-IF($N$40=\"×\",0,'まとめ(Input)'!N38)","v":2947.1995569722908},null,{"$f":"P6-IF($N$40=\"×\",0,'まとめ(Input)'!P38)","v":2821.9763967215313},null,{"$f":"R6-IF($N$40=\"×\",0,'まとめ(Input)'!R38)","v":2815.1263206998851},null,{"$f":"T6-IF($N$40=\"×\",0,'まとめ(Input)'!T38)","v":2821.7267666410721},null,{"$f":"V6-IF($N$40=\"×\",0,'まとめ(Input)'!V38)","v":2939.5115139865616},null,{"$f":"X6-IF($N$40=\"×\",0,'まとめ(Input)'!X38)","v":3022.7436161032051},null,{"$f":"Z6-IF($N$40=\"×\",0,'まとめ(Input)'!Z38)","v":3013.0141747202542},null,{"$f":"AB6-IF($N$40=\"×\",0,'まとめ(Input)'!AB38)","v":3063.0869141845869},null,{"$f":"AVERAGE(F45:AC45)","v":3000},null,{"$f":"MAX(F45:AC45)","v":3194.77042400868},null,{"$f":"'まとめ(Input)'!AH33","v":60}]
[null,"精製ガス量FP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,{"$f":"F43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":300.26907431346865},null,{"$f":"H43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":313.36326019800856},null,{"$f":"J43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":315.36181644175696},null,{"$f":"L43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":322.31435588963728},null,{"$f":"N43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":331.02898256726735},null,{"$f":"P43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":313.87226468972233},null,{"$f":"R43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":288.67897392143993},null,{"$f":"T43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":257.24360506681523},null,{"$f":"V43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":265.29626979224923},null,{"$f":"X43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":244.36013848169034},null,{"$f":"Z43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":234.94219348112028},null,{"$f":"AB43*($AH$43-'まとめ(Input)'!$S$12)/($AH$48-'まとめ(Input)'!$S$12)","v":241.80261660592447},null,{"$f":"AVERAGE(F48:AC48)","v":285.71112928742508},null,{"$f":"MAX(F48:AC48)","v":331.02898256726735},null,{"$f":"IF(F38=\"PSA無し\",'まとめ(Input)'!AH31,'まとめ(Input)'!S11)","v":90}]
[null,"供給処理場2",null,null,null,{"$f":"F44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":300.26907431346854},null,{"$f":"H44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":313.36326019800856},null,{"$f":"J44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":315.36181644175673},null,{"$f":"L44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":322.31435588963728},null,{"$f":"N44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":331.02898256726735},null,{"$f":"P44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":313.87226468972233},null,{"$f":"R44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":288.67897392143993},null,{"$f":"T44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":257.24360506681523},null,{"$f":"V44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":265.29626979224923},null,{"$f":"X44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":244.36013848169034},null,{"$f":"Z44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":234.94219348112028},null,{"$f":"AB44*($AH$44-'まとめ(Input)'!$V$12)/($AH$49-'まとめ(Input)'!$V$12)","v":241.80261660592447},null,{"$f":"AVERAGE(F49:AC49)","v":285.71112928742502},null,{"$f":"MAX(F49:AC49)","v":331.02898256726735},null,{"$f":"IF(F39=\"PSA無し\",'まとめ(Input)'!AH32,'まとめ(Input)'!V11)","v":90}]
[null,"オフガス量FO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"CH4濃度"]
[null,"供給処理場1",null,null,null,{"$f":"F43-F48","v":225.20180573510152},null,{"$f":"H43-H48","v":235.02244514850645},null,{"$f":"J43-J48","v":236.52136233131768},null,{"$f":"L43-L48","v":241.73576691722798},null,{"$f":"N43-N48","v":248.27173692545057},null,{"$f":"P43-P48","v":235.40419851729177},null,{"$f":"R43-R48","v":216.50923044107992},null,{"$f":"T43-T48","v":192.93270380011143},null,{"$f":"V43-V48","v":198.97220234418688},null,{"$f":"X43-X48","v":183.27010386126778},null,{"$f":"Z43-Z48","v":176.20664511084021},null,{"$f":"AB43-AB48","v":181.35196245444337},null,{"$f":"AVERAGE(F52:AC52)","v":214.28334696556882},null,{"$f":"MAX(F52:AC52)","v":248.27173692545057},null,{"$f":"'まとめ(Input)'!S12","v":20}]
[null,"供給処理場2",null,null,null,{"$f":"F44-F49","v":225.2018057351014},null,{"$f":"H44-H49","v":235.02244514850645},null,{"$f":"J44-J49","v":236.52136233131756},null,{"$f":"L44-L49","v":241.73576691722798},null,{"$f":"N44-N49","v":248.27173692545057},null,{"$f":"P44-P49","v":235.40419851729177},null,{"$f":"R44-R49","v":216.50923044107992},null,{"$f":"T44-T49","v":192.93270380011143},null,{"$f":"V44-V49","v":198.97220234418688},null,{"$f":"X44-X49","v":183.27010386126778},null,{"$f":"Z44-Z49","v":176.20664511084021},null,{"$f":"AB44-AB49","v":181.35196245444337},null,{"$f":"AVERAGE(F53:AC53)","v":214.28334696556877},null,{"$f":"MAX(F53:AC53)","v":248.27173692545057},null,{"$f":"'まとめ(Input)'!V12","v":20}]
[null,"発電機利用ガス量(メタン量)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Nm3/日]"]
[null,null,null,null,null,"4月",null,"5月",null,"6月",null,"7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"年平均",null,"最大",null,"発電機"]
[null,"供給処理場1",null,null,null,{"$f":"F48*$AH$48/100","v":270.24216688212181},null,{"$f":"H48*$AH$48/100","v":282.02693417820768},null,{"$f":"J48*$AH$48/100","v":283.82563479758124},null,{"$f":"L48*$AH$48/100","v":290.08292030067355},null,{"$f":"N48*$AH$48/100","v":297.9260843105406},null,{"$f":"P48*$AH$48/100","v":282.48503822075008},null,{"$f":"R48*$AH$48/100","v":259.81107652929592},null,{"$f":"T48*$AH$48/100","v":231.5192445601337},null,{"$f":"V48*$AH$48/100","v":238.7666428130243},null,{"$f":"X48*$AH$48/100","v":219.9241246335213},null,{"$f":"Z48*$AH$48/100","v":211.44797413300824},null,{"$f":"AB48*$AH$48/100","v":217.62235494533201},null,{"$f":"AVERAGE(F56:AC56)","v":257.14001635868254},null,{"$f":"MAX(F56:AC56)","v":297.9260843105406}]
[null,"供給処理場2",null,null,null,{"$f":"F49*$AH$49/100","v":270.24216688212169},null,{"$f":"H49*$AH$49/100","v":282.02693417820768},null,{"$f":"J49*$AH$49/100","v":283.82563479758102},null,{"$f":"L49*$AH$49/100","v":290.08292030067355},null,{"$f":"N49*$AH$49/100","v":297.9260843105406},null,{"$f":"P49*$AH$49/100","v":282.48503822075008},null,{"$f":"R49*$AH$49/100","v":259.81107652929592},null,{"$f":"T49*$AH$49/100","v":231.5192445601337},null,{"$f":"V49*$AH$49/100","v":238.7666428130243},null,{"$f":"X49*$AH$49/100","v":219.9241246335213},null,{"$f":"Z49*$AH$49/100","v":211.44797413300824},null,{"$f":"AB49*$AH$49/100","v":217.62235494533201},null,{"$f":"AVERAGE(F57:AC57)","v":257.14001635868249},null,{"$f":"MAX(F57:AC57)","v":297.9260843105406}]
[null,"集約処理場",null,null,null,{"$f":"F45*$AH$45/100","v":1916.862254405208},null,{"$f":"H45*$AH$45/100","v":1903.393112732741},null,{"$f":"J45*$AH$45/100","v":1876.7392725827324},null,{"$f":"L45*$AH$45/100","v":1836.3742042616877},null,{"$f":"N45*$AH$45/100","v":1768.3197341833743},null,{"$f":"P45*$AH$45/100","v":1693.1858380329186},null,{"$f":"R45*$AH$45/100","v":1689.0757924199311},null,{"$f":"T45*$AH$45/100","v":1693.0360599846433},null,{"$f":"V45*$AH$45/100","v":1763.7069083919371},null,{"$f":"X45*$AH$45/100","v":1813.6461696619233},null,{"$f":"Z45*$AH$45/100","v":1807.8085048321525},null,{"$f":"AB45*$AH$45/100","v":1837.8521485107519},null,{"$f":"AVERAGE(F58:AC58)","v":1800},null,{"$f":"MAX(F58:AC58)","v":1916.862254405208}]
[null,"発電機投入ガス量",null,null,null,{"$f":"F45+F48+F49","v":3795.3085726356171},null,{"$f":"H45+H48+H49","v":3799.0483749505852},null,{"$f":"J45+J48+J49","v":3758.6224205214012},null,{"$f":"L45+L48+L49","v":3705.2523855487539},null,{"$f":"N45+N48+N49","v":3609.2575221068255},null,{"$f":"P45+P48+P49","v":3449.7209261009757},null,{"$f":"R45+R48+R49","v":3392.4842685427652},null,{"$f":"T45+T48+T49","v":3336.2139767747026},null,{"$f":"V45+V48+V49","v":3470.1040535710604},null,{"$f":"X45+X48+X49","v":3511.4638930665856},null,{"$f":"Z45+Z48+Z49","v":3482.8985616824948},null,{"$f":"AB45+AB48+AB49","v":3546.6921473964358},null,{"$f":"AVERAGE(F59:AC59)","v":3571.4222585748503},null,{"$f":"MAX(F59:AC59)","v":3799.0483749505852},null,{"$f":"'まとめ(Input)'!S14","v":400}]
[null,"発電量",null,"[kW]",null,{"$f":"(F56+F57+F58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":388.9640842411398},null,{"$f":"(H56+H57+H58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":390.56283718116174},null,{"$f":"(J56+J57+J58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":386.9133207921605},null,{"$f":"(L56+L57+L58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":382.50497105594985},null,{"$f":"(N56+N57+N58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":374.21581619383539},null,{"$f":"(P56+P57+P58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":357.43494693662973},null,{"$f":"(R56+R57+R58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":349.60643234632693},null,{"$f":"(T56+T57+T58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":341.27687424546161},null,{"$f":"(V56+V57+V58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":354.75742161387211},null,{"$f":"(X56+X57+X58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":356.69709646215438},null,{"$f":"(Z56+Z57+Z58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":353.08975908779314},null,{"$f":"(AB56+AB57+AB58)/24*9.97*(-0.00002*$AH$59^2+0.0223*$AH$59+32.383)/100","v":359.79989236200896},null,{"$f":"AVERAGE(F60:AC60)","v":366.31862104320777},null,{"$f":"MAX(F60:AC60)","v":390.56283718116174},null,{"$f":"IF(AF60<800,1,IF(AF60<1600,2,3))","v":1}]
[]
[]
[null,null,null,null,null,null,null,"【費用回収年を重視する場合】",null,null,null,null,null,null,null,null,null,null,null,null,null,"【未利用消化ガス全量利用を重視する場合】"]
[null,null,null,null,null,null,null,"供給処理場1",null,null,"供給処理場2",null,null,"集約処理場",null,null,"共通",null,null,null,null,"供給処理場1",null,null,"供給処理場2",null,null,"集約処理場",null,null,"共通"]
[null,"建設コスト[千円]","PSA",null,null,null,null,{"$f":"IF(F11=\"PSA無し\",\" \",IF(AF16/24<150,1,IF(AF16/24<300,2,3)))","v":1},{"$f":"IF(F11=\"PSA無し\",0,ROUNDUP(-1.5609*ROUNDUP(AF16/24/H65,-1)^2+488.11*ROUNDUP(AF16/24/H65,-1),-2)*H65+ROUNDUP(35*AF16/24/H65,-1)*H65)","v":9670},null,{"$f":"IF(F12=\"PSA無し\",\" \",IF(AF17/24<150,1,IF(AF17/24<300,2,3)))","v":1},{"$f":"IF(F12=\"PSA無し\",0,ROUNDUP(-1.5609*ROUNDUP(AF17/24/K65,-1)^2+488.11*ROUNDUP(AF17/24/K65,-1),-2)*K65+ROUNDUP(35*AF17/24/K65,-1)*K65)","v":9670},null,{"$f":"IF(F13=\"PSA無し\",\" \",IF(AF18/24<150,1,IF(AF18/24<300,2,3)))","v":" "},{"$f":"IF(F13=\"PSA無し\",0,ROUNDUP(-1.5609*ROUNDUP(AF18/24,-1)^2+488.11*ROUNDUP(AF18/24,-1)+35*ROUNDUP(AF18/24,0),-1))","v":0},null,null,0,null,null,null,{"$f":"IF(F38=\"PSA無し\",\" \",IF(AF43/24<150,1,IF(AF43/24<300,2,3)))","v":1},{"$f":"IF(F38=\"PSA無し\",0,ROUNDUP(-1.5609*ROUNDUP(AF43/24/V65,-1)^2+488.11*ROUNDUP(AF43/24/V65,-1),-2)*V65+ROUNDUP(35*AF43/24/V65,-1)*V65)","v":14150},null,{"$f":"IF(F39=\"PSA無し\",\" \",IF(AF44/24<150,1,IF(AF44/24<300,2,3)))","v":1},{"$f":"IF(F39=\"PSA無し\",0,ROUNDUP(-1.5609*ROUNDUP(AF44/24/Y65,-1)^2+488.11*ROUNDUP(AF44/24/Y65,-1),-2)*Y65+ROUNDUP(35*AF44/24/Y65,-1)*Y65)","v":14150},null,{"$f":"IF(F40=\"PSA無し\",\" \",IF(AF45/24<150,1,IF(AF45/24<300,2,3)))","v":" "},{"$f":"IF(F40=\"PSA無し\",0,ROUNDUP(-1.5609*ROUNDUP(AF45/24/AB65,-1)^2+488.11*ROUNDUP(AF45/24/AB65,-1)*AB65+35*ROUNDUP(AF45/24/AB65,0),-1)*AB65)","v":0},null,null,0]
[null,null,"吸蔵装置",null,null,null,null,{"$f":"IF(F11=\"PSA無し\",\" \",IF(AF21/24<100,1,IF(AF21/24<200,2,3)))","v":1},{"$f":"IF(I65=0,0,ROUNDUP(-0.002*ROUNDUP(AF21/24/H66,-1)^2+251.03*ROUNDUP(AF21/24/H66,-1),-2)*H66)","v":2600},null,{"$f":"IF(F12=\"PSA無し\",\" \",IF(AF22/24<100,1,IF(AF22/24<200,2,3)))","v":1},{"$f":"IF(L65=0,0,ROUNDUP(-0.002*ROUNDUP(AF22/24/K66,-1)^2+251.03*ROUNDUP(AF22/24/K66,-1),-2)*K66)","v":2600},null,{"$f":"IF(F13=\"PSA無し\",\" \",IF(AF18/24<100,1,IF(AF18/24<200,2,3)))","v":" "},{"$f":"IF(O65=0,0,ROUNDUP(-0.002*ROUNDUP(AF18/24/N66,-1)^2+251.03*ROUNDUP(AF18/24/N66,-1),-1)*N66)","v":0},null,null,0,null,null,null,{"$f":"IF(F38=\"PSA無し\",\" \",IF(AF48/24<100,1,IF(AF48/24<200,2,3)))","v":1},{"$f":"IF(W65=0,0,ROUNDUP(-0.002*ROUNDUP(AF48/24/V66,-1)^2+251.03*ROUNDUP(AF48/24/V66,-1),-2)*V66)","v":5100},null,{"$f":"IF(F39=\"PSA無し\",\" \",IF(AF49/24<100,1,IF(AF49/24<200,2,3)))","v":1},{"$f":"IF(Z65=0,0,ROUNDUP(-0.002*ROUNDUP(AF49/24/Y66,-1)^2+251.03*ROUNDUP(AF49/24/Y66,-1),-2)*Y66)","v":5100},null,{"$f":"IF(F40=\"PSA無し\",\" \",IF(AF45/24<100,1,IF(AF45/24<200,2,3)))","v":" "},{"$f":"IF(AC65=0,0,ROUNDUP(-0.002*ROUNDUP(AF45/24/AB66,-1)^2+251.03*ROUNDUP(AF45/24/AB66,-1),-1)*AB66)","v":0},null,null,0]
[null,null,"シロキサン除去装置",null,null,null,null,{"$f":"IF(F11=\"PSA無し\",IF(AF16/24<500,1,IF(AF16/24<1000,2,3)),\" \")","v":" "},{"$f":"IF(I65=0,ROUNDUP(-0.0015*ROUNDUP(AF16/24/H67,-1)^2+91.4*ROUNDUP(AF16/24/H67,-1),-1)*H67,0)","v":0},null,{"$f":"IF(F12=\"PSA無し\",IF(AF17/24<500,1,IF(AF17/24<1000,2,3)),\" \")","v":" "},{"$f":"IF(L65=0,ROUNDUP(-0.0015*ROUNDUP(AF17/24/K67,-1)^2+91.4*ROUNDUP(AF17/24/K67,-1),-1)*K67,0)","v":0},null,{"$f":"IF(F13=\"PSA無し\",IF(AF18/24<500,1,IF(AF18/24<1000,2,3)),\" \")","v":1},{"$f":"IF(O65=0,ROUNDUP(-0.0015*ROUNDUP(AF18/24/N67,-1)^2+91.4*ROUNDUP(AF18/24/N67,-1),-2)*N67,0)","v":12800},null,null,0,null,null,null,{"$f":"IF(F38=\"PSA無し\",IF(AF43/24<500,1,IF(AF43/24<1000,2,3)),\" \")","v":" "},{"$f":"IF(W65=0,ROUNDUP(-0.0015*ROUNDUP(AF43/24/V67,-1)^2+91.4*ROUNDUP(AF43/24/V67,-1),-1)*V67,0)","v":0},null,{"$f":"IF(F39=\"PSA無し\",IF(AF44/24<500,1,IF(AF44/24<1000,2,3)),\" \")","v":" "},{"$f":"IF(Z65=0,ROUNDUP(-0.0015*ROUNDUP(AF44/24/Y67,-1)^2+91.4*ROUNDUP(AF44/24/Y67,-1),-1)*Y67,0)","v":0},null,{"$f":"IF(F40=\"PSA無し\",IF(AF45/24<500,1,IF(AF45/24<1000,2,3)),\" \")","v":1},{"$f":"IF(AC65=0,ROUNDUP(-0.0015*ROUNDUP(AF45/24/AB67,-1)^2+91.4*ROUNDUP(AF45/24/AB67,-1),-2)*AB67,0)","v":12800},null,null,0]
[null,null,"余剰ガス燃焼装置",null,null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,1,{"$f":"(50*ROUNDUP(AF52/24,-1)+2000)*V68","v":3000},null,1,{"$f":"(50*ROUNDUP(AF53/24,-1)+2000)*Y68","v":3000},null,null,0,null,null,0]
[null,null,"吸蔵容器",null,null,null,null,null,0,null,null,0,null,null,0,null,{"$f":"'まとめ(Input)'!$J$16+'まとめ(Input)'!$M$16","v":6},{"$f":"ROUNDUP(ROUNDUP(AF21/24*'まとめ(Input)'!$J$15/45,0)*875+(ROUNDUP(AF21/24*'まとめ(Input)'!$J$15/45,0)/5)^0.6*6760,-2)*'まとめ(Input)'!$J$16+ROUNDUP(ROUNDUP(AF22/24*'まとめ(Input)'!$M$15/45,0)*875+(ROUNDUP(AF22/24*'まとめ(Input)'!$M$15/45,0)/5)^0.6*6760,-2)*'まとめ(Input)'!$M$16","v":67200},null,null,null,null,0,null,null,0,null,null,0,null,{"$f":"'まとめ(Input)'!$S$16+'まとめ(Input)'!$V$16","v":6},{"$f":"ROUNDUP(ROUNDUP(AF48/24*'まとめ(Input)'!$S$15/45,0)*875+(ROUNDUP(AF48/24*'まとめ(Input)'!$S$15/45,0)/5)^0.6*6760,-2)*'まとめ(Input)'!$S$16+ROUNDUP(ROUNDUP(AF49/24*'まとめ(Input)'!$V$15/45,0)*875+(ROUNDUP(AF49/24*'まとめ(Input)'!$V$15/45,0)/5)^0.6*6760,-2)*'まとめ(Input)'!$V$16","v":96000}]
[null,null,"発電機,ガスホルダ",null,null,null,null,null,0,null,null,0,null,{"$f":"AH33","v":1},{"$f":"ROUNDUP(-0.2161*AH32^2+390.07*AH32,-2)*AH33+ROUNDUP(CEILING(AF32/24*5/60,5)^0.55*1800,-2)*AH33","v":120500},null,null,0,null,null,null,null,0,null,null,0,null,{"$f":"AH60","v":1},{"$f":"ROUNDUP(-0.2161*AH59^2+390.07*AH59,-2)*AB70+ROUNDUP(CEILING(AF59/24*5/60,5)^0.55*1800,-2)*AB70","v":129500},null,null,0]
[null,null,"トラック",null,null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"IF(MAX(ROUNDUP(AF21/24*'まとめ(Input)'!$J$15/45,0),ROUNDUP(AF22/24*'まとめ(Input)'!$M$15/45,0))<6,28500,33000)","v":28500},null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"IF(MAX(ROUNDUP(AF48/24*'まとめ(Input)'!$S$15/45,0),ROUNDUP(AF49/24*'まとめ(Input)'!$V$15/45,0))<6,28500,33000)","v":33000}]
[null,null,"工事費",null,null,null,null,null,{"$f":"26.5*ROUNDUP(AF16/24,-1)+14300+ROUNDUP(-2.0458*(-0.0001*ROUNDUP(AF16/24,-1)^2+0.2902*ROUNDUP(AF16/24,-1)+7.4901)^2+135.41*(-0.0001*ROUNDUP(AF16/24,-1)^2+0.2902*ROUNDUP(AF16/24,-1)+7.4901)+150,-1)","v":16420},null,null,{"$f":"26.5*ROUNDUP(AF17/24,-1)+14300+ROUNDUP(-2.0458*(-0.0001*ROUNDUP(AF17/24,-1)^2+0.2902*ROUNDUP(AF17/24,-1)+7.4901)^2+135.41*(-0.0001*ROUNDUP(AF17/24,-1)^2+0.2902*ROUNDUP(AF17/24,-1)+7.4901)+150,-1)","v":16420},null,null,{"$f":"ROUNDUP(16.3*ROUNDUP(IF(F13=\"PSA無し\",0,AF18/24),-1)+6.9*ROUNDUP(AF18/24,-1)+18600,-1)+ROUNDUP(40.362*AH32*AH33,-2)","v":34170},null,null,0,null,null,null,null,{"$f":"26.5*ROUNDUP(AF43/24,-1)+14300+ROUNDUP(-2.0458*(-0.0001*ROUNDUP(AF43/24,-1)^2+0.2902*ROUNDUP(AF43/24,-1)+7.4901)^2+135.41*(-0.0001*ROUNDUP(AF43/24,-1)^2+0.2902*ROUNDUP(AF43/24,-1)+7.4901)+150,-1)","v":16905},null,null,{"$f":"26.5*ROUNDUP(AF44/24,-1)+14300+ROUNDUP(-2.0458*(-0.0001*ROUNDUP(AF44/24,-1)^2+0.2902*ROUNDUP(AF44/24,-1)+7.4901)^2+135.41*(-0.0001*ROUNDUP(AF44/24,-1)^2+0.2902*ROUNDUP(AF44/24,-1)+7.4901)+150,-1)","v":16905},null,null,{"$f":"ROUNDUP(16.3*ROUNDUP(IF(F40=\"PSA無し\",0,AF45/24),-1)+6.9*ROUNDUP(AF45/24,-1)+18600,-1)+ROUNDUP(40.362*AH59*AH60,-2)","v":35770},null,null,0]
[null,null,"共通費用負担",null,null,null,null,null,{"$f":"AD29/(AD29+AD30+AD31)*SUM(R65:S72)","v":7293.1205750819272},null,null,{"$f":"AD30/(AD29+AD30+AD31)*SUM(R65:S72)","v":7293.1205750819272},null,null,{"$f":"AD31/(AD29+AD30+AD31)*SUM(R65:S72)","v":81113.758849836158},null,null,0,null,null,null,null,{"$f":"AD56/(AD56+AD57+AD58)*SUM(AF65:AG72)","v":14333.210173931062},null,null,{"$f":"AD57/(AD56+AD57+AD58)*SUM(AF65:AG72)","v":14333.21017393106},null,null,{"$f":"AD58/(AD56+AD57+AD58)*SUM(AF65:AG72)","v":100333.57965213789},null,null,0]
[null,null,"建設費合計",null,null,null,null,null,{"$f":"SUM(I65:J73)","v":35983.120575081928},null,null,{"$f":"SUM(L65:M73)","v":35983.120575081928},null,null,{"$f":"SUM(O65:P73)","v":248583.75884983616},null,null,null,null,{"$f":"SUM(I74:P74)","v":320550},null,null,{"$f":"SUM(W65:X73)","v":53488.21017393106},null,null,{"$f":"SUM(Z65:AA73)","v":53488.21017393106},null,null,{"$f":"SUM(AC65:AD73)","v":278403.57965213788},null,null,null,null,{"$f":"SUM(W74:AC74)","v":385380}]
[null,"維持管理コスト[千円/年]","人件費（装置全般）",null,null,null,null,null,{"$f":"'まとめ(Input)'!$Y$26*12*'まとめ(Input)'!$Y$25","v":288},null,null,{"$f":"'まとめ(Input)'!$Y$26*12*'まとめ(Input)'!$Y$25","v":288},null,null,{"$f":"'まとめ(Input)'!$Y$26*12*'まとめ(Input)'!$Y$25","v":288},null,null,0,null,null,null,null,{"$f":"'まとめ(Input)'!$Y$26*12*'まとめ(Input)'!$Y$25","v":288},null,null,{"$f":"'まとめ(Input)'!$Y$26*12*'まとめ(Input)'!$Y$25","v":288},null,null,{"$f":"'まとめ(Input)'!$Y$26*12*'まとめ(Input)'!$Y$25","v":288},null,null,0]
[null,null,"人件費（運転手）",null,null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(('まとめ(Input)'!J17+'まとめ(Input)'!M17)*'まとめ(Input)'!$Y$25+('まとめ(Input)'!J18+'まとめ(Input)'!M18)*'まとめ(Input)'!$Y$25*1.25)/2*'まとめ(Input)'!Y24","v":3675},null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"(('まとめ(Input)'!S17+'まとめ(Input)'!V17)*'まとめ(Input)'!$Y$25+('まとめ(Input)'!S18+'まとめ(Input)'!V18)*'まとめ(Input)'!$Y$25*1.25)/2*'まとめ(Input)'!Y24","v":3675}]
[null,null,"運搬燃料費",null,null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"('まとめ(Input)'!$Q$20*'まとめ(Input)'!$J$19+'まとめ(Input)'!$Z$20*'まとめ(Input)'!$M$19)*2*'まとめ(Input)'!$J$21/'まとめ(Input)'!$J$22*'まとめ(Input)'!$Y$24/1000","v":504},null,null,null,null,0,null,null,0,null,null,0,null,null,{"$f":"('まとめ(Input)'!$Q$20*'まとめ(Input)'!$S$19+'まとめ(Input)'!$Z$20*'まとめ(Input)'!$V$19)*2*'まとめ(Input)'!$J$21/'まとめ(Input)'!$J$22*'まとめ(Input)'!$Y$24/1000","v":504}]
[null,null,"消耗品費",null,null,null,null,null,{"$f":"IF(I65>0,AF16/24*35/10,0)+IF(I68>0,'まとめ(Input)'!$D$26*'まとめ(Input)'!$D$24*'まとめ(Input)'!$Y$24/1000+'まとめ(Input)'!$D$25*12,0)","v":46.544976444619238},null,null,{"$f":"IF(L65>0,AF17/24*35/10,0)+IF(L68>0,'まとめ(Input)'!$D$26*'まとめ(Input)'!$D$24*'まとめ(Input)'!$Y$24/1000+'まとめ(Input)'!$D$25*12,0)","v":46.544976444619223},null,null,{"$f":"IF(O65>0,AF18/24*35/10,0)+IF(O68>0,'まとめ(Input)'!$D$26*'まとめ(Input)'!$D$24*'まとめ(Input)'!$Y$24/1000+'まとめ(Input)'!$D$25*12,0)","v":0},null,null,0,null,null,null,null,{"$f":"IF(W65>0,AF43/24*35/10,0)+IF(W68>0,'まとめ(Input)'!$D$26*'まとめ(Input)'!$D$24*'まとめ(Input)'!$Y$24/1000+'まとめ(Input)'!$D$25*12,0)","v":326.48135492602137},null,null,{"$f":"IF(Z65>0,AF44/24*35/10,0)+IF(Z68>0,'まとめ(Input)'!$D$26*'まとめ(Input)'!$D$24*'まとめ(Input)'!$Y$24/1000+'まとめ(Input)'!$D$25*12,0)","v":326.48135492602137},null,null,{"$f":"IF(AC65>0,AF45/24*35/10,0)+IF(AC68>0,'まとめ(Input)'!$D$26*'まとめ(Input)'!$D$24*'まとめ(Input)'!$Y$24/1000+'まとめ(Input)'!$D$25*12,0)","v":0},null,null,0]
[null,null,"修繕費",null,null,null,null,null,{"$f":"ROUNDUP((I65+I66+I68)*0.02,0)","v":246},null,null,{"$f":"ROUNDUP((L65+L66+L68)*0.02,0)","v":246},null,null,{"$f":"ROUNDUP(-0.0136*ROUNDUP(AF18/24,-1)^2+9.8405*ROUNDUP(AF18/24,-1)+ROUNDUP(-0.0328*AH32^2+40.439*AH32,-2)*AH33+(O65+O66+O68+CEILING((AF21+AF22+AF18)/24*5/60,5)^0.55*1800)*0.02,-1)","v":11680},null,null,{"$f":"ROUNDUP(IF(R71=28500,836,876)+(R69-AF21/24*'まとめ(Input)'!$J$15/45*875*'まとめ(Input)'!$J$16-AF22/24*'まとめ(Input)'!$M$15/45*875*'まとめ(Input)'!$M$16)*0.02,-1)","v":1740},null,null,null,null,{"$f":"ROUNDUP((W65+W66+W68)*0.02,0)","v":445},null,null,{"$f":"ROUNDUP((Z65+Z66+Z68)*0.02,0)","v":445},null,null,{"$f":"ROUNDUP(-0.0136*ROUNDUP(AF45/24,-1)^2+9.8405*ROUNDUP(AF45/24,-1)+ROUNDUP(-0.0328*AH59^2+40.439*AH59,-2)*AH60+(AC65+AC66+AC68+CEILING((AF48+AF49+AF45)/24*5/60,5)^0.55*1800)*0.02,-1)","v":12280},null,null,{"$f":"ROUNDUP(IF(AF71=28500,836,876)+(AF69-AF48/24*'まとめ(Input)'!$S$15/45*875*'まとめ(Input)'!$S$16-AF49/24*'まとめ(Input)'!$V$15/45*875*'まとめ(Input)'!$V$16)*0.02,-1)","v":2030}]
[null,null,"消費電力",null,null,null,null,null,{"$f":"(ROUNDUP(-0.0002*(AD16/24)^2+0.0913*(AD16/24),1)+ROUNDUP((-0.0006*(AD21/24)^2+0.1883*(AD21/24))/2+1.5,1))*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$25/1000*24","v":428.40000000000009},null,null,{"$f":"(ROUNDUP(-0.0002*(AD17/24)^2+0.0913*(AD17/24),1)+ROUNDUP((-0.0006*(AD22/24)^2+0.1883*(AD22/24))/2+1.5,1))*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$25/1000*24","v":428.40000000000009},null,null,0,null,null,0,null,null,null,null,{"$f":"(ROUNDUP(-0.0002*(AD43/24)^2+0.0913*(AD43/24),1)+ROUNDUP((-0.0006*(AD48/24)^2+0.1883*(AD48/24))/2+1.5+IF(W68>0,0.5,0),1))*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$25/1000*24","v":630},null,null,{"$f":"(ROUNDUP(-0.0002*(AD44/24)^2+0.0913*(AD44/24),1)+ROUNDUP((-0.0006*(AD49/24)^2+0.1883*(AD49/24))/2+1.5+IF(Z68>0,0.5,0),1))*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$25/1000*24","v":630},null,null,0,null,null,0]
[null,null,"共通費用負担",null,null,null,null,null,{"$f":"AD29/(AD29+AD30+AD31)*SUM(R75:S80)","v":451.0760782017756},null,null,{"$f":"AD30/(AD29+AD30+AD31)*SUM(R75:S80)","v":451.0760782017756},null,null,{"$f":"AD31/(AD29+AD30+AD31)*SUM(R75:S80)","v":5016.8478435964498},null,null,0,null,null,null,null,{"$f":"AD56/(AD56+AD57+AD58)*SUM(AF75:AG80)","v":689.88296100727098},null,null,{"$f":"AD57/(AD56+AD57+AD58)*SUM(AF75:AG80)","v":689.88296100727098},null,null,{"$f":"AD58/(AD56+AD57+AD58)*SUM(AF75:AG80)","v":4829.2340779854585},null,null,0]
[null,null,"維持管理費合計",null,null,null,null,null,{"$f":"SUM(I75:J81)","v":1460.021054646395},null,null,{"$f":"SUM(L75:M81)","v":1460.021054646395},null,null,{"$f":"SUM(O75:P81)","v":16984.84784359645},null,null,null,null,{"$f":"SUM(I82:P82)","v":19904.88995288924},null,null,{"$f":"SUM(W75:X81)","v":2379.3643159332923},null,null,{"$f":"SUM(Z75:AA81)","v":2379.3643159332923},null,null,{"$f":"SUM(AC75:AD81)","v":17397.234077985457},null,null,null,null,{"$f":"SUM(W82:AD82)","v":22155.962709852043}]
[null,"発電による電力削減分[千円/年]",null,null,null,null,null,null,{"$f":"AD29/24*9.97*(-0.00002*AH32^2+0.0223*AH32+32.383)/100*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$24/1000","v":3203.7297519325198},null,null,{"$f":"AD30/24*9.97*(-0.00002*AH32^2+0.0223*AH32+32.383)/100*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$24/1000","v":3203.7297519325198},null,null,{"$f":"AD31/24*9.97*(-0.00002*AH32^2+0.0223*AH32+32.383)/100*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$24/1000","v":35631.738135000007},null,null,null,null,{"$f":"SUM(H83:P83)","v":42039.197638865044},null,null,{"$f":"AD56/24*9.97*(-0.00002*AH59^2+0.0223*AH59+32.383)/100*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$24/1000","v":5128.4166282220913},null,null,{"$f":"AD57/24*9.97*(-0.00002*AH59^2+0.0223*AH59+32.383)/100*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$24/1000","v":5128.4166282220913},null,null,{"$f":"AD31/24*9.97*(-0.00002*AH59^2+0.0223*AH59+32.383)/100*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$AF$24/1000","v":35899.312995000008},null,null,null,null,{"$f":"SUM(V83:AD83)","v":46156.146251444188}]
[null,"費用回収年[年]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T74/(T83-T82)","v":14.482043195012556},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH74/(AH83-AH82)","v":16.057377200142625}]
[null,"エネルギー創出量[GJ/年]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AD33*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$Q$24-(ROUNDUP(-0.0002*(AD16/24)^2+0.0913*(AD16/24),1)+ROUNDUP((-0.0006*(AD21/24)^2+0.1883*(AD21/24))/2+1.5,1)+ROUNDUP(-0.0002*(AD17/24)^2+0.0913*(AD17/24),1)+ROUNDUP((-0.0006*(AD22/24)^2+0.1883*(AD22/24))/2+1.5,1))*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$Q$24-('まとめ(Input)'!Q20*'まとめ(Input)'!J19+'まとめ(Input)'!Z20*'まとめ(Input)'!M19)*2/'まとめ(Input)'!$J$22*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$Q$25)/1000","v":25850.294927525229},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AD60*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$Q$24-(ROUNDUP(-0.0002*(AD43/24)^2+0.0913*(AD43/24),1)+ROUNDUP((-0.0006*(AD48/24)^2+0.1883*(AD48/24))/2+1.5+IF(W68>0,0.5,0),1)+ROUNDUP(-0.0002*(AD44/24)^2+0.0913*(AD44/24),1)+ROUNDUP((-0.0006*(AD49/24)^2+0.1883*(AD49/24))/2+1.5+IF(Z68>0,0.5,0),1))*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$Q$24-('まとめ(Input)'!Q20*'まとめ(Input)'!S19+'まとめ(Input)'!Z20*'まとめ(Input)'!V19)*2/'まとめ(Input)'!$J$22*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$Q$25-(V68+Y68+AB68)*'まとめ(Input)'!$D$26*'まとめ(Input)'!$Y$24/0.0224*0.044*'まとめ(Input)'!$Q$26)/1000","v":28060.709383638594}]
[null,"GHG削減量[t-CO2/年]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AD33*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$J$24-(ROUNDUP(-0.0002*(AD16/24)^2+0.0913*(AD16/24),1)+ROUNDUP((-0.0006*(AD21/24)^2+0.1883*(AD21/24))/2+1.5,1)+ROUNDUP(-0.0002*(AD17/24)^2+0.0913*(AD17/24),1)+ROUNDUP((-0.0006*(AD22/24)^2+0.1883*(AD22/24))/2+1.5,1))*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$J$24-('まとめ(Input)'!Q20*'まとめ(Input)'!J19+'まとめ(Input)'!Z20*'まとめ(Input)'!M19)*2/'まとめ(Input)'!$J$22*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$J$25)/1000","v":1392.9442707791429},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AD60*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$J$24-(ROUNDUP(-0.0002*(AD43/24)^2+0.0913*(AD43/24),1)+ROUNDUP((-0.0006*(AD48/24)^2+0.1883*(AD48/24))/2+1.5+IF(W68>0,0.5,0),1)+ROUNDUP(-0.0002*(AD44/24)^2+0.0913*(AD44/24),1)+ROUNDUP((-0.0006*(AD49/24)^2+0.1883*(AD49/24))/2+1.5+IF(Z68>0,0.5,0),1))*24*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$J$24-('まとめ(Input)'!Q20*'まとめ(Input)'!J19+'まとめ(Input)'!Z20*'まとめ(Input)'!M19)*2/'まとめ(Input)'!$J$22*'まとめ(Input)'!$Y$24*'まとめ(Input)'!$J$25-(V68+Y68+AB68)*'まとめ(Input)'!$D$26*'まとめ(Input)'!$Y$24/0.0224*0.044*'まとめ(Input)'!$J$26)/1000","v":1511.4568900885104}]