{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["配管","貯湯槽 (角形→角形)","貯湯槽（円形→円形）","貯湯槽（角形→円形）","制御盤","補助金申請に使用する場合の注意事項","元データ"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":15,"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":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,2,1,12],[21,10,21,12],[2,2,2,4],[2,6,2,8],[3,2,3,4],[3,6,3,8],[3,10,3,12],[34,10,34,11],[22,22,24,22],[25,22,27,22],[28,22,30,22],[15,2,15,4],[15,6,15,8],[19,22,21,22]]}
[]
[null,null,"配管CO2削減計算ツール"]
[null,null,"施設改修前",null,null,null,"施設改修後"]
[null,null,"Data",null,null,null,"Data",null,null,null,"CO2削減効果"]
[null,null,"出発温度",null,"℃",null,"出発温度",null,"℃",null,"削減放熱量",{"$f":"IFERROR(D17-H19,\"\")","v":""},"kcal/h"]
[null,null,"出発流量",null,"ℓ/min",null,"出発流量",null,"ℓ/min",null,"CO2削減量",{"$f":"IFERROR(ROUND(L5*24*365*0.00419*H12*44/12/1000,2),\"\")","v":""},"t-co2/年"]
[null,null,"施設距離",null,"m",null,"配管距離",null,"ｍ"]
[null,null,"到着温度",null,"℃",null,"外気温度",null,"℃"]
[null,null,"到着流量",null,"ℓ/min",null,"管材口径"]
[null,null,null,null,null,null,"保温材"]
[null,null,null,null,null,null,"保温材厚み",null,"mm"]
[null,null,null,null,null,null,"炭素排出係数",null,"kg-C/MJ"]
[null,null,null,null,null,null,"※FP2重保温・架橋ポリエチレン管・ポリプロピレン管の保温材はウレタンフォームを選択してください。"]
[null,null,null,null,null,null,"※FP2重保温・架橋ポリエチレン管・ポリプロピレン管の保温材厚みは各メーカーにお問い合わせください。"]
[null,null,null,null,null,null,"※加温等に使用している燃料の炭素排出係数を入力してください。"]
[null,null,"Ans",null,null,null,"Ans"]
[null,null,"施設放熱量",{"$f":"IF((D5-D8)*(D6-(D6-D9))*60=0,\"\",(D5-D8)*(D6-(D6-D9))*60)","v":""},"kcal/h",null,"到着温度",{"$f":"IFERROR(配管温度(H5,H8,H6,H7,H10,H11,H9),\"\")","v":""},"℃"]
[null,null,"1m当り放熱量",{"$f":"IFERROR(D17/D7,\"\")","v":""},"kcal/h",null,"到着流量",{"$f":"IF(H6=0,\"\",H6)","v":""},"ℓ/min"]
[null,null,null,null,null,null,"施設放熱量",{"$f":"IFERROR((H5-H17)*(H6-(H6-H18))*60,\"\")","v":""},"kcal/h"]
[]
[]
[]
[null,null,null,"■は手入力"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"補助金の申請に用いる場合"]
[null,null,null,null,null,null,null,null,null,null,"単位発熱量×炭素排出係数\n×44/12"]
[null,null,null,null,null,null,null,null,null,null,"申請書に入力する削減量",{"$f":"IFERROR(L6/L36,\"\")","v":""}]

{"sheet":"貯湯槽 (角形→角形)","index":1,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,10,33,11],[28,2,28,4],[28,6,28,8],[0,22,1,22],[1,1,1,13],[2,22,4,22],[3,2,3,4],[3,6,3,8],[4,2,4,4],[4,6,4,8],[6,10,6,12],[11,2,11,4],[15,10,15,12],[17,10,17,12],[15,6,15,8]]}
[]
[null,"角形貯湯槽CO2削減計算ツール"]
[]
[null,null,"施設改修前",null,null,null,"施設改修後"]
[null,null,"Data",null,null,null,"Data"]
[null,null,"槽縦",null,"ｍ",null,"槽縦",null,"ｍ"]
[null,null,"槽横",null,"ｍ",null,"槽横",null,"ｍ",null,"CO2削減効果"]
[null,null,"水深",null,"ｍ",null,"槽高さ",null,"ｍ",null,"削減放熱量",{"$f":"IFERROR(D30-H30,\"\")","v":""},"kcal/h"]
[null,null,"槽内温度",null,"℃",null,"水深",null,"ｍ",null,"CO2削減量",{"$f":"IFERROR(ROUND(L8*24*365*0.00419*H14*44/12/1000,2),\"\")","v":""},"t-co2/年"]
[null,null,null,null,null,null,"外気温度",null,"℃"]
[null,null,null,null,null,null,"槽内温度",null,"℃"]
[null,null,"Data（24時間後）",null,null,null,"保温材"]
[null,null,"槽内温度",null,"℃",null,"保温材厚み",null,"mm"]
[null,null,null,null,null,null,"炭素排出係数",null,"kg-C/MJ"]
[null,null,"※　槽水深に変化がないことが前提となっております。"]
[null,null,null,null,null,null,"※加温に使用している燃料を選択してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Ans",null,null,null,"Ans"]
[null,null,"施設放熱量",{"$f":"IF(ROUND(((D9-D13)/24)*((D6*D7*D8)*1000)*60,0)=0,\"\",ROUND(((D9-D13)/24)*((D6*D7*D8)*1000)*60,0))","v":""},"kcal/h",null,"施設放熱量",{"$f":"IFERROR(角貯湯(H11,H10,H9,H8,H7,H6,H12,H13),\"\")","v":""},"kcal/h"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"補助金の申請に用いる場合"]
[null,null,null,null,null,null,null,null,null,null,"単位発熱量×炭素排出係数\n×44/12"]
[null,null,null,null,null,null,null,null,null,null,"申請書に入力する削減量",{"$f":"IFERROR(L9/L35,\"\")","v":""}]

{"sheet":"貯湯槽（円形→円形）","index":2,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[21,22,23,22],[24,22,26,22],[27,22,28,22],[23,2,23,4],[23,6,23,8],[29,10,29,11],[1,2,1,12],[9,2,9,4],[2,2,2,4],[2,6,2,8],[3,2,3,4],[3,6,3,8],[5,10,5,12],[13,10,13,12],[13,6,13,8]]}
[]
[null,null,"円形貯湯槽CO2削減計算ツール"]
[null,null,"施設改修前",null,null,null,"施設改修後"]
[null,null,"Data",null,null,null,"Data"]
[null,null,"槽内径",null,"ｍ",null,"槽内径",null,"ｍ"]
[null,null,"水深",null,"ｍ",null,"槽高さ",null,"ｍ",null,"CO2削減効果"]
[null,null,"槽内温度",null,"℃",null,"水深",null,"ｍ",null,"削減放熱量",{"$f":"IFERROR(D25-H25,\"\")","v":""},"kcal/h"]
[null,null,null,null,null,null,"外気温度",null,"℃",null,"CO2削減量",{"$f":"IFERROR(ROUND(L7*24*365*0.00419*H12*44/12/1000,2),\"\")","v":""},"t-co2/年"]
[null,null,null,null,null,null,"槽内温度",null,"℃"]
[null,null,"Data（24時間後）",null,null,null,"保温材"]
[null,null,"槽内温度",null,"℃",null,"保温材厚み",null,"mm"]
[null,null,"外気温度",null,"℃",null,"炭素排出係数",null,"kg-C/MJ"]
[]
[null,null,"※　槽水深に変化がないことが前提となっております。",null,null,null,"※加温に使用している燃料を選択してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Ans",null,null,null,"Ans"]
[null,null,"施設放熱量",{"$f":"IF(ROUND(((D7-D11)/24)*((D5^2*PI()/4*D6)*1000)*60,0)=0,\"\",ROUND(((D7-D11)/24)*((D5^2*PI()/4*D6)*1000)*60,0))","v":""},"kcal/h",null,"施設放熱量",{"$f":"IFERROR(円貯湯(H9,H8,H7,H6,H10,H11,H5),\"\")","v":""},"kcal/h"]
[]
[null,null,null,null,"■は手入力"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"補助金の申請に用いる場合"]
[null,null,null,null,null,null,null,null,null,null,"単位発熱量×炭素排出係数\n×44/12"]
[null,null,null,null,null,null,null,null,null,null,"申請書に入力する削減量",{"$f":"IFERROR(L8/L31,\"\")","v":""}]

{"sheet":"貯湯槽（角形→円形）","index":3,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[24,22,26,22],[27,22,28,22],[10,2,10,4],[13,6,13,8],[14,10,14,12],[21,22,23,22],[24,2,24,4],[24,6,24,8],[30,10,30,11],[5,10,5,12],[1,2,1,12],[2,2,2,4],[2,6,2,8],[3,2,3,4],[3,6,3,8]]}
[]
[null,null,"角形⇒円形貯湯槽CO2削減計算ツール"]
[null,null,"施設改修前",null,null,null,"施設改修後"]
[null,null,"Data",null,null,null,"Data"]
[null,null,"槽縦",null,"ｍ",null,"槽内径",null,"ｍ"]
[null,null,"槽横",null,"ｍ",null,"槽高さ",null,"ｍ",null,"CO2削減効果"]
[null,null,"水深",null,"ｍ",null,"水深",null,"ｍ",null,"削減放熱量",{"$f":"IFERROR(D26-H26,\"\")","v":""},"kcal/h"]
[null,null,"槽内温度",null,"℃",null,"外気温度",null,"℃",null,"CO2削減量",{"$f":"IFERROR(ROUND(L7*24*365*0.00419*H12*44/12/1000,2),\"\")","v":""},"t-co2/年"]
[null,null,null,null,null,null,"槽内温度",null,"℃"]
[null,null,null,null,null,null,"保温材"]
[null,null,"Data（24時間後）",null,null,null,"保温材厚み",null,"mm"]
[null,null,"槽内温度",null,"℃",null,"炭素排出係数",null,"kg-C/MJ"]
[]
[null,null,"※　槽水深に変化がないことが前提となっております。",null,null,null,"※加温に使用している燃料を選択してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Ans",null,null,null,"Ans"]
[null,null,"施設放熱量",{"$f":"IF(ROUND(((D8-D12)/24)*((D5*D6*D7)*1000)*60,0)=0,\"\",ROUND(((D8-D12)/24)*((D5*D6*D7)*1000)*60,0))","v":""},"kcal/h",null,"施設放熱量",{"$f":"IFERROR(円貯湯(H9,H8,H7,H6,H10,H11,H5),\"\")","v":""},"kcal/h"]
[]
[null,null,null,null,"■は手入力"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"補助金の申請に用いる場合"]
[null,null,null,null,null,null,null,null,null,null,"単位発熱量×炭素排出係数\n×44/12"]
[null,null,null,null,null,null,null,null,null,null,"申請書に入力する削減量",{"$f":"IFERROR(L8/L32,\"\")","v":""}]

{"sheet":"制御盤","index":4,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,2,1,12],[11,2,11,4],[3,10,3,12],[14,10,14,12],[11,6,11,8],[2,2,2,4],[2,6,2,8],[3,2,3,4],[3,6,3,8]]}
[]
[null,null,"制御盤設備CO2削減計算ツール"]
[null,null,"施設改修前",null,null,null,"施設改修後"]
[null,null,"Data",null,null,null,"Data",null,null,null,"CO2削減効果"]
[null,null,"商用電源周波数",null,"Hz",null,"可変周波数",null,"Hz",null,"差分電気使用量",{"$f":"H14","v":""},"kW/年"]
[null,null,"動力",null,"kW",null,"動力",null,"Kw",null,"CO2削減量",{"$f":"IFERROR(ROUND(L5*H7,2),\"\")","v":""},"kg-co2/年"]
[null,null,"※周波数　東日本50Hz、西日本60Hz",null,null,null,"電気事業者別排出係数",4.4099999999999999E-4,"ｔ-CO2/kWh"]
[null,null,null,null,null,null,"※1 電気事業者別排出係数は環境省HP『温室効果ガス排出量算定・報告・公表制度』を参照の上、入力してください。"]
[null,null,null,null,null,null,"https://ghg-santeikohyo.env.go.jp/calc/denki"]
[null,null,null,null,null,null,"※2 電気事業者別排出係数デフォルト0.000441は代替値です。"]
[]
[null,null,"Ans",null,null,null,"Ans"]
[null,null,"改修前電気使用量",{"$f":"D6*24*365","v":0},"kW/年",null,"改修後電気使用量",{"$f":"IFERROR(ROUND((ROUND((H5/D5)^3,3))*H6*365*24,0),\"\")","v":""},"kW/年"]
[null,null,null,null,null,null,"差分電気使用量",{"$f":"IFERROR(D13-H13,\"\")","v":""},"kW/年"]
[null,null,null,null,null,null,null,null,null,null,"イメージ"]
[]
[]
[]
[]
[]
[null,null,null,"■は手入力"]

{"sheet":"補助金申請に使用する場合の注意事項","index":5,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["補助金申請に使用する場合の注意事項"]
["本ツールを補助金の申請に使用する場合は、必ず以下の記載事項を守って使用してください。"]
[]
["１．「配管」シートについて"]
["①施設改修前の出発温度、出発流量、到着温度、到着流量については、実測値を使用するとともに、温度計や流量計の写真等の根拠資料を添付してください。"]
["②施設改修前の区間距離については、配管改修区間を含む出発温度等を計測した地点と到達温度等を計測した地点の区間距離を入力してください。"]
["③施設改修後の改修配管距離、管材口径、保温材、保温材厚みについては、補助金の申請内容・見積りと合わせてください。"]
["④施設改修後の改修配管距離について、必ず該当区間の後に利用施設で加温している等エネルギー起源CO2削減につながる区間を入力してください。"]
["⑤施設改修後の外気温度については、当該改修を行う場所の年間の平均気温など、適切な数値の入力を行うとともに、その根拠資料を添付してください。"]
["⑥施設改修後の炭素排出係数については、現在、加温等に使用しており改修によって削減が見込まれる燃料の係数を入力してください。"]
["※到達温度・到達流量が不自然に低下している場合、漏湯等が発生している可能性があります。その場合、改修を行っても適切な効果が得られないことがありますので、申請前にご確認ください。"]
[]
["２．「貯湯槽 (角形→角形)」シートについて"]
["①施設改修前の槽縦、槽横、水深、槽内温度については、実測値を使用するとともに、温度計の写真等の根拠資料を添付してください。"]
["②施設改修後の槽縦、槽横、槽高さ、保温材、保温材厚みについては、補助金の申請内容・見積りと合わせてください。"]
["③施設改修後の外気温度については、当該改修を行う場所の年間の平均気温など、適切な数値の入力を行うとともに、その根拠資料を添付してください。"]
["④施設改修後の炭素排出係数については、現在、加温等に使用しており改修によって削減が見込まれる燃料の係数を入力してください。"]
[]
["３．「貯湯槽（円形→円形）」シートについて"]
["①施設改修前の槽内径、水深、槽内温度については、実測値を使用するとともに、温度計の写真等の根拠資料を添付してください。"]
["②施設改修後の槽内径、槽高さ、保温材、保温材厚みについては、補助金の申請内容・見積りと合わせてください。"]
["③施設改修後の外気温度については、当該改修を行う場所の年間の平均気温など、適切な数値の入力を行うとともに、その根拠資料を添付してください。"]
["④施設改修後の炭素排出係数については、現在、加温等に使用しており改修によって削減が見込まれる燃料の係数を入力してください。"]
[]
["４．「貯湯槽（角形→円形）」シートについて"]
["①施設改修前の槽縦、槽横、水深、槽内温度については、実測値を使用するとともに、温度計の写真等の根拠資料を添付してください。"]
["②施設改修後の槽内径、槽高さ、保温材、保温材厚みについては、補助金の申請内容・見積りと合わせてください。"]
["③施設改修後の外気温度については、当該改修を行う場所の年間の平均気温など、適切な数値の入力を行うとともに、その根拠資料を添付してください。"]
["④施設改修後の炭素排出係数については、現在、加温等に使用しており改修によって削減が見込まれる燃料の係数を入力してください。"]
[]
["５．「制御盤」シートについて"]
["①動力については、根拠資料を添付してください。"]
["②施設改修後の可変周波数は、メーカーによる予想軽減周波数等予想される動力の周波数を入力し、その根拠資料を添付してください。"]
["③電気事業者別排出係数については、現在使用している事業者の係数を調べて入力してください。"]
[]
["６．申請書様式への記入について"]
["①配管・貯湯槽については、補助金の申請に用いる場合欄の数値を様式の適切な活動種別に応じた削減量(P-A)欄に直接入力をしてください。"]
["②制御盤については、改修前電気使用量欄の数値を様式の現状(P)欄に、改修後電気使用量欄の数値を改修後(A)欄に入力してください。"]

{"sheet":"元データ","index":6,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":true,"merged":[[14,9,16,9],[17,9,19,9],[20,9,22,9],[23,9,25,9]]}
[]
[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,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,"FP2重保温",null,"強化プラスチック2重保温"]
[null,null,"GNG",null,"架橋ポリエチレン管"]
[]
[]
[]
[null,null,null,"熱伝導率"]
[null,null,"ポリスチレンフォーム",3.9E-2]
[null,null,"ウレタンフォーム",2.5999999999999999E-2]
[]
[null,null,null,null,"コントロール","内径","肉厚","管外径","ｍ当たり単価","備考",null,"口径","保温厚","コントロール","ウレタンフォーム","ポリスチレンフォーム"]
[null,null,"強化プラスチック",50,{"$f":"C15&D15&\"A\"","v":"強化プラスチック50A"},50,4,{"$f":"F15+(G15*2)","v":58},7450,"1本当り3ｍなので継手部を30％上乗せ",null,"100A",30,{"$f":"L15&M15","v":"100A30"},8440,8150]
[null,null,"強化プラスチック",65,{"$f":"C16&D16&\"A\"","v":"強化プラスチック65A"},65,4,{"$f":"F16+(G16*2)","v":73},8130,null,null,"100A",40,{"$f":"L16&M16","v":"100A40"},10870,9460]
[null,null,"強化プラスチック",100,"強化プラスチック100A",100,5,110,12720,null,null,"100A",50,"100A50",13530,10860]
[null,null,"強化プラスチック2重保温",50,{"$f":"C18&D18&\"A\"","v":"強化プラスチック2重保温50A"},50,4,{"$f":"F18+(G18*2)","v":58},17010,"1本当り3ｍなので継手部を30％上乗せ",null,"75A",30,"75A30",7270,6490]
[null,null,"強化プラスチック2重保温",65,{"$f":"C19&D19&\"A\"","v":"強化プラスチック2重保温65A"},65,4,{"$f":"F19+(G19*2)","v":73},18850,null,null,"75A",40,"75A40",9600,7760]
[null,null,"強化プラスチック2重保温",100,"強化プラスチック2重保温100A",100,5,110,27490,null,null,"75A",50,"75A50",12100,9040]
[null,null,"架橋ポリエチレン管",50,"架橋ポリエチレン管50A",50,null,60.5,18310,"10ｍ作成することを想定し、継手を2カ所とする",null,"65A",30,"65A30",6790,5620]
[null,null,"架橋ポリエチレン管",65,"架橋ポリエチレン管65A",65,null,76,20620,null,null,"65A",40,"65A40",8820,663]
[null,null,"架橋ポリエチレン管",100,"架橋ポリエチレン管100A",100,null,114,30100,null,null,"65A",50,"65A50",11270,7770]
[null,null,"耐熱塩ビ管",50,"耐熱塩ビ管50A",50,null,60,2850,"1本当り4ｍなので継手部を30％上乗せ",null,"50A",30,"50A30",5720,4840]
[null,null,"耐熱塩ビ管",65,"耐熱塩ビ管65A",65,null,76,3900,null,null,"50A",40,"50A40",7740,5820]
[null,null,"耐熱塩ビ管",100,"耐熱塩ビ管100A",100,null,114,8560,null,null,"50A",50,"50A50",10000,7040]
[]
[]
[]
[null,null,"保温厚み",30]
[null,null,null,40]
[null,null,null,50]