{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["使用方法","１ページ","２ページ","３ページ","４ページ","提出書類リスト","管理図(参考）","各実績表(参考）","グラフ(参考）","３ページ補足","目標変更ページ","補足説明"],"not_rendered":{"charts":14,"images":0,"macros":1,"external_links":1,"defined_names":12,"comments":8,"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":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["エコアップ認証取組実施状況報告書　（Excel簡易版）"]
[null,null,null,null,null,null,null,null,null,null,"ver.3.01"]
[]
["本ファイルの利用方法"]
["１．概要"]
[null,"・本シートは「エコアップ認証事業所 取組実施状況報告書」におけるExcel版での簡易版報告様式です。"]
[null,"・CO2排出量実績は、実績数値等を記入すれば、原単位数や集計結果が自動計算されます。"]
[null," また、《マクロ》ボタンを利用すれば 「CO2排出量換算シート」ファイルから、排出量実績をはじめ、表の"]
[null,"  必要データが一発で自動転記されるので、手間なく表を完成させることができます。"]
[]
["２．全般的な記入方法"]
[null,"・本シートでは　　黄色と　　　水色のセルに記入できます。水色セルにはプルダウンリストがあります。"]
[null,"・薄茶色の箇所は結合セルになっており、文を途中で改行したい場合は”Alt+Enter（Return)”で行えます。"]
[null,"・「１ページ」は直接記入する方法と、旧い報告書（同様式）から、マクロで自動転記もできます。"]
[null,"・「２ページ」２．（１）表の”今回達成率”値は「環境保全取組ﾁｪｯｸｼｰﾄ」から、マクロで自動転記もできます。"]
[null,"・「３ページ」、「目標変更ページ」は直接記入する方法と、マクロボタンにより「CO2量算定シート」から"]
[null," 自動転記もできます。"]
[null,"・「３ページ」、「３ページ補足」の表の水色セルのプルダウンリストに該当する項目が無い場合、欄外の"]
[null," ”●原単位活動指標表”の黄色の欄に所望の項目等を新たに追記すると、リストに対象が追加されます。"]
[null,"・「３ページ」の「・・・の入力データの消去」ボタンをクックすると、表の黄色に記入したデータを一括して消去"]
[null,"  することができます。"]
[]
["３．提出するシート"]
[null,"・提出が必要なシートは１ページ～４ページまでです。 それ以外のページは原則提出不要です。"]
[null,"・提出に際しては、本書式のほかに「添付書類リスト」にある必要書類も提出します。"]
[null,"・ 「３ページ補足」や「補足説明」シートは適宜、必要な場合のみ追加します。"]
[null,"　所定シートに書ききれない場合は、そのシートで行の挿入は行わず（様式では作業ができないように"]
[null,"　なっている）、 「補足説明」シートを利用します。"]
[]
["４．補足及び参考シート"]
[null,"・ 「目標変更ページ」シートは、目標値を変更する場合に提出します。提出に際しては県と事前協議を"]
[null,"  おこなう必要があります。 "]
[null,"・「目標変更ページ」シートの（１）ア）表は　「CO2量算定シート」＃８シートの目標表から、マクロボタン"]
[null,"　で自動転記ができます。 （２）、（３）の欄に変更した内容の記事説明を記載してください。"]
[]
[null,"・「各実績表」シートは参考として、日常の管理にご利用ください。添付書類にとして提出しても結構です。"]
[null,"　「各実績表」シートの結果は「グラフ」シートに反映され、月ごとの累積と単月の目標管理に利用できます。"]
[]
["５．マクロの使用方法"]
[null,"・マクロ機能を利用する場合、本ファイルを開く際、”コンテンツの有効”をクリックし、マクロを有効にします。"]
[null," (後から行う場合、リボンバー「開発」⇒「マクロのセキュリティ」でマクロの設定で２番以降の選択をする。)"]
[null,"・データを吸上げしたい対象の「CO2量算定シート」や「取組実施状況報告書」ファイルを開きます。"]
[null,"・本ファイルに戻り、シートのマクロボタンをクリックします。"]
[null,"・マクロ実行後、データ引用したファイルを保存するか否かを尋ねるメッセージボックスがでますので、データ"]
[null,"を引用したファイルを閉じる場合は \"Yes\"を選択します。"]
[]
["６．本ファイルの保存"]
[null,"・ファイルを保存する際、マクロ形式（拡張子 .xlm）のままで保存すると、次回もマクロ機能が利用できます。"]
[null,"エクセル形式（拡張子が .xls　.xlsx）で保存した場合は、マクロ機能は使用できなくなります。"]
[]
[]
["【注意事項】"]
[null,"以下の対処を厳守するようお願いします。マクロ機能が正常に使用できなくなります。"]
[null,"・《シート移動・コピーの禁止》　「1ページ」、「２ページ」、「３ページ」、「目標変更ページ」は本ファイル"]
[null,"　から、あるいは他ファイルブックからの移動、コピーはしないでください。"]
[null,"・《シート名の変更の禁止》 「１ページ」、「２ページ」、「３ページ」、「目標変更ページ」のシート名は変更"]
[null,"　しないでください。"]
[]
["※ver.2.11での主な変更点"]
[null,"・「２ページ」２．（１）達成率値コピーのマクロ追加"]
[null,"・「グラフ(参考）」単月目標・実績管理グラフのマクロ追加"]
["※ver.3.01の主な変更点"]
[null,"・「3ページ」２．ア）表での年度記入方法、（３）表記入方法変更。"]
[null,"・「3ページ」太陽光自家消費事業所用記入表追加。"]
[null,"・「管理図(参考）」シートを追加。"]

{"sheet":"１ページ","index":1,"n_rows":46,"n_cols":42,"rows_kept":46,"cut":false,"hidden":false,"merged":[[21,4,24,15],[41,1,43,3],[29,4,31,5],[29,10,31,11],[29,12,31,15],[25,4,28,15],[21,1,24,3],[25,1,28,3],[32,4,34,5],[32,10,34,11],[29,1,37,3],[29,6,31,9],[17,4,17,15],[18,4,20,15],[17,1,17,3],[18,1,20,3],[4,9,4,10],[7,9,9,15],[10,9,10,15],[11,9,11,15],[44,1,45,3],[35,4,37,5],[32,6,34,9],[44,5,45,9],[44,12,45,15],[32,12,34,15],[35,12,37,15],[38,11,40,15],[38,5,40,9],[41,5,43,9],[41,11,43,15],[35,6,37,9],[38,1,40,3]]}
["様式第４号（第１４条関係）",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[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,3]
[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,4]
[null,null,null,null,null,null,null,null,null,null,null,"年",null,"月",null,"日",null,null,null,null,null,null,null,null,null,null,5]
[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,6,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,7,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,8,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,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,null,null,null,10,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,11,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,12,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,13,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,14,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,15,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,16,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,17,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,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"令和１３"]
[null,"事業所の名称\n(認証範囲も記載）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,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,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,null,null,null,null,null,null,null,null,21,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,22,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,23,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,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,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,"従業員数\n人数（人）",null,null,null,null,null,"事業所の敷地面積"]
[]
[]
[null,null,null,null,"（　　　　　　　）",null,null,null,null,null,"（延床面積）"]
[]
[]
[null,"地球温暖化対策\n推進者名　　　　　　　　",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,"電子メール"]

{"sheet":"２ページ","index":2,"n_rows":19,"n_cols":26,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,5],[2,6,2,8],[2,14,2,17],[2,18,2,20],[3,2,6,25],[14,22,14,25],[16,22,16,25],[11,2,11,5],[12,2,12,5],[14,2,14,5],[11,6,11,9],[14,6,14,9],[14,10,14,13],[14,14,14,17],[14,18,14,21],[11,10,11,13],[11,14,11,17],[11,18,11,21],[12,6,12,8],[11,22,11,25],[13,2,13,5],[13,6,13,8],[13,10,13,12],[13,14,13,16],[13,18,13,20],[13,22,13,24],[12,10,12,12],[12,14,12,16],[12,18,12,20],[12,22,12,24],[19,2,50,25],[15,10,15,12],[15,14,15,16],[15,18,15,20],[15,22,15,25],[16,2,16,5],[16,6,16,8],[16,10,16,12],[16,14,16,16],[16,18,16,20],[15,6,15,8],[15,2,15,5]]}
[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,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,null,null,"％"]
[null,null,"認証申請時達成率",null,null,null,null,null,null,"％",null,null,null,"％",null,null,null,"％",null,null,null,"％"]
[]
[null,null,"（取組に関する情報・説明）　※当期に取り組んだ事項を記載する。"]

{"sheet":"３ページ","index":3,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[34,5,35,5],[34,6,35,6],[40,1,40,2],[40,3,40,4],[36,1,36,2],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[43,1,54,9],[5,1,6,2],[5,3,6,4],[7,3,7,4],[12,1,13,2],[12,3,13,4],[34,9,35,9],[14,3,14,4],[19,1,20,2],[19,3,20,4],[21,3,21,4],[26,1,27,2],[26,3,27,4],[28,3,28,4],[33,3,33,4],[34,3,35,4]]}
["（２）環境への負荷のチェック結果",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,"単位指標等",null,{"$f":"IF(I6=\"\",\"\",IF(G6=\"31/1\",30,G6-1))","v":""},{"$f":"IF(I6=\"\",\"\",IF(H6=\"31/1\",30,H6-1))","v":""},{"$f":"IF(I6=\"\",\"\",IF(I6=\"31/1\",30,I6-1))","v":""},null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,"年度","年度","年度","年度",null,null,null,null,null,null,null,3]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年",null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,{"$f":"D10&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E10,\"\")","v":""},{"$f":"IFERROR(ROUND(F8/F10,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G8/G10,4),\"\")","v":""},"","",null,null,{"$f":"MATCH(D10,$N$12:$N$21,0)","v":{"$error":"#N/A"}},null,null,null,null,5]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,L9),\"\")","v":""},null,null,null,null,null,null,null,null,"●原単位活動指標表",null,null,6]
[null,null,null,null,null,{"$f":"IF(AND(F8<>\"\",I8=\"\"),\"直近4カ年の実績値を入れてください！\",\"\")","v":""},null,null,null,null,null,null,null,"指標名","単位",null,7,"当たり"]
[null,"イ）工場・現場系ＣＯ₂排出量実績",null,null,null,null,null,null,null,null,null,null,null,"（床面積）","㎡",null,8]
[null,"項　　　目",null,"単位指標等",null,{"$f":"IF(F6=\"\",\"\",F6)","v":""},{"$f":"IF(G6=\"\",\"\",G6)","v":""},{"$f":"IF(H6=\"\",\"\",H6)","v":""},{"$f":"IF(I6=\"\",\"\",I6)","v":""},null,null,null,null,"（敷地面積）","㎡",null,9]
[null,null,null,null,null,"年度","年度","年度","年度",null,null,null,null,"（売上額）","億円",null,10]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年",null,null,null,null,null,null,null,null,null,"（受注額）","億円",null,11]
[null,{"$f":"D17&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E17,\"\")","v":""},{"$f":"IFERROR(ROUND(F15/F17,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G15/G17,4),\"\")","v":""},"","",null,null,{"$f":"MATCH(D17,$N$12:$N$21,0)","v":{"$error":"#N/A"}},null,"（従業員数）","人",null,12]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,L16),\"\")","v":""},null,null,null,null,null,null,null,null,"（台数）","台",null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（走行距離）","千km",null,14]
[null,"ウ）自動車系ＣＯ₂排出量実績",null,null,null,null,null,null,null,null,null,null,null,"（生産量）","ﾄﾝ",null,15]
[null,"項　　　目",null,"単位指標等",null,{"$f":"IF(F6=\"\",\"\",F6)","v":""},{"$f":"IF(G6=\"\",\"\",G6)","v":""},"","",null,null,null,null,null,null,null,16]
[null,null,null,null,null,"年度","年度","年度","年度",null,null,null,null,null,null,null,17]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年",null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,{"$f":"D24&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E24,\"\")","v":""},{"$f":"IFERROR(ROUND(F22/F24,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G22/G24,4),\"\")","v":""},"","",null,null,{"$f":"MATCH(D24,$N$12:$N$21,0)","v":{"$error":"#N/A"}},null,null,null,null,19]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,L23),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,"エ）（ア＋イ＋ウ）合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,"項　　　目",null,"単位指標等",null,{"$f":"IF(F6=\"\",\"\",F6)","v":""},{"$f":"IF(G6=\"\",\"\",G6)","v":""},"","",null,null,null,null,null,null,null,23,"）"]
[null,null,null,null,null,"年度","年度","年度","年度",null,null,null,null,null,null,null,24]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年",null,{"$f":"IFERROR(F8+F15+F22,\"\")","v":0},{"$f":"IFERROR(G8+G15+G22,\"\")","v":0},0,0,null,null,null,null,null,null,null,25]
[null,{"$f":"D31&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E31,\"\")","v":""},{"$f":"IFERROR(ROUND(F29/F31,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G29/G31,4),\"\")","v":""},"","",null,null,{"$f":"MATCH(D31,$N$12:$N$21,0)","v":{"$error":"#N/A"}},null,null,null,null,26]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,L30),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
["（３）二酸化炭素排出量及び原単位の実績",null,null,null,null,null,null,null,"太陽光自家消費報告の有・無⇒",null,null,null,null,null,null,{"$f":"IF(J33=\"有り\",1,IF(J33=\"無し\",2,3))","v":3},29]
[null,"年　　度",null,"ＣＯ₂排出量",null,"削減量","削減率","ＣＯ₂原単位","削減量","削減率",null,null,null,null,null,null,30]
[null,null,null,"（ｔ-ＣＯ₂）",null,"（ｔ-ＣＯ₂）","（％）",{"$f":"D31&R11","v":"当たり"},{"$f":"D31&R11","v":"当たり"},"（％）"]
[null,null,null,null,null,null,null,{"$f":"\"(\"&D30&E30&\")\"","v":"(ｔ-ＣＯ₂／)"},{"$f":"H36","v":"(ｔ-ＣＯ₂／)"},null,null,null,null,"★太陽光自家消費報告が有る事業所は（３）表の実績は下表へ記載！"]
[null,"基準値",null,48,null,null,null,null,null,null,null,null,null,"年度","ＣＯ₂量","CO₂原単位"]
[null,{"$f":"IF(I1=\"\",\"\",I1)","v":""},"年度",{"$f":"IFERROR(IF(AND(O38=\"\",$P$33=1),\"\",IF($P$33=1,O38,HLOOKUP(B38,F$27:I$31,3,FALSE))),\"\")","v":0},null,{"$f":"IF(D38=\"\",\"\",D38-D$37)","v":-48},{"$f":"IF(F38=\"\",\"\",F38/D$37*100)","v":-100},{"$f":"IFERROR(IF(AND(P38=\"\",$P$33=1),\"\",IF($P$33=1,P38,HLOOKUP(B38,F$27:I$31,4,FALSE))),\"\")","v":""},{"$f":"IF(H38=\"\",\"\",H38-H$37)","v":""},{"$f":"IF(I38=\"\",\"\",I38/H$37*100)","v":""},null,null,null,{"$f":"IF(B38=\"\",\"\",B38)","v":""}]
[null,{"$f":"IFERROR(IF(B38=\"\",\"\",IF(B38=\"31/1\",2,IF(B38=30,1,B38+1))),\"\")","v":""},"年度",{"$f":"IFERROR(IF(AND(O39=\"\",$P$33=1),\"\",IF($P$33=1,O39,HLOOKUP(B39,F$27:I$31,3,FALSE))),\"\")","v":0},null,{"$f":"IF(D39=\"\",\"\",D39-D$37)","v":-48},{"$f":"IF(F39=\"\",\"\",F39/D$37*100)","v":-100},{"$f":"IFERROR(IF(AND(P39=\"\",$P$33=1),\"\",IF($P$33=1,P39,HLOOKUP(B39,F$27:I$31,4,FALSE))),\"\")","v":""},{"$f":"IF(H39=\"\",\"\",H39-H$37)","v":""},{"$f":"IF(I39=\"\",\"\",I39/H$37*100)","v":""},null,null,null,{"$f":"B39","v":""}]
[null,{"$f":"IFERROR(IF(B39=\"\",\"\",IF(B39=\"31/1\",2,IF(B39=30,1,B39+1))),\"\")","v":""},"年度",{"$f":"IFERROR(IF(AND(O40=\"\",$P$33=1),\"\",IF($P$33=1,O40,HLOOKUP(B40,F$27:I$31,3,FALSE))),\"\")","v":0},null,{"$f":"IF(D40=\"\",\"\",D40-D$37)","v":-48},{"$f":"IF(F40=\"\",\"\",F40/D$37*100)","v":-100},{"$f":"IFERROR(IF(AND(P40=\"\",$P$33=1),\"\",IF($P$33=1,P40,HLOOKUP(B40,F$27:I$31,4,FALSE))),\"\")","v":""},{"$f":"IF(H40=\"\",\"\",H40-H$37)","v":""},{"$f":"IF(I40=\"\",\"\",I40/H$37*100)","v":""},null,null,null,{"$f":"B40","v":""}]
[null,"平均削減率",null,null,null,null,{"$f":"IF(G38=\"\",\"\",AVERAGE(G38:G40))","v":-100},null,null,{"$f":"IF(J38=\"\",\"\",AVERAGE(J38:J40))","v":""}]
[]
["（４）二酸化炭素排出量等の増減に関する情報・説明",null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\" （対象年度に取り組んだ対策、取組を記載する）\",\"\")","v":" （対象年度に取り組んだ対策、取組を記載する）"}]

{"sheet":"４ページ","index":4,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,2,18,30],[32,13,32,30],[48,8,48,30],[49,8,50,30],[21,11,21,30],[22,2,29,30],[33,2,40,30],[44,8,44,30],[45,8,45,30],[46,8,46,30],[47,8,47,30]]}
[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,{"$f":"IF(C5=\"\",\"（対象年度におこなった内容、変化した管理事項も記載する）\",\"\")","v":"（対象年度におこなった内容、変化した管理事項も記載する）"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"その他："]

{"sheet":"提出書類リスト","index":5,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,31],[2,10,3,31],[2,1,3,9],[4,1,5,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,null,null,null,"・追加事項がある場合（３ページ補足、補足ページ等）"]
[]
[null,null,null,null,null,null,null,null,null,null,"＊目標の変更は県との事前協議が必要です。"]
[null,"２　エコアップEMS関連",null,null,null,null,null,null,null,null,"①環境保全に関する取組チェックシート ※"]
[null,null,null,null,null,null,null,null,null,null,null,"* SDGs関連シートの提出は必須ではありません"]
[null,null,null,null,null,null,null,null,null,null,"②CO₂量算定シート※（ファイルブック一式）"]
[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,"<注>②はExcelファイルブック一式で提出。pdfや紙だけは不可"]
[]
[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,"※提出必須書類（下線のあるファイル）"]

{"sheet":"管理図(参考）","index":6,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,13,1,14],[5,0,5,1],[6,0,6,1],[1,0,1,1],[1,2,1,3],[1,5,1,6],[1,7,1,8]]}
["○○株式会社　令和〇年度 電力量管理表"]
["目標値",null,38050,null,"kwh/年","目標CO₂量",null,{"$f":"C2*0.495*0.001","v":18.83475},null,"t-CO₂/年",null,"担当部門名",null,"○○部"]
["建物系電力量","単位","4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月","合計値"]
["目標値","kWh",2300,2100,2500,4200,4450,3900,2800,2500,3200,3500,3800,2800,{"$f":"SUM(C4:N4)","v":38050}]
["本年度実績","kWh",2475,1988,2398,3799,4270,3950,2908,2460,3111,3699,3984,3003,{"$f":"SUM(C5:N5)","v":38045}]
["単月評価",null,{"$f":"IF(C4>C5,\"○\",\"×\")","v":"×"},{"$f":"IF(D4>D5,\"○\",\"×\")","v":"○"},"○","○","○","×","×","○","○","×","×","×","○"]
["累積評価",null,{"$f":"IF(C37>C38,\"○\",\"×\")","v":"×"},"×","○","○","○","○","○","○","○","○","○","○","○"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C4","v":2300},{"$f":"C37+D4","v":4400},6900,11100,15550,19450,22250,24750,27950,31450,35250,38050,{"$f":"O4","v":38050}]
[null,null,{"$f":"C5","v":2475},4463,6861,10660,14930,18880,21788,24248,27359,31058,35042,38045,{"$f":"O5","v":38045}]

{"sheet":"各実績表(参考）","index":7,"n_rows":83,"n_cols":34,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,17,0,18],[0,15,0,16],[0,11,0,12],[0,13,0,14],[28,32,48,32],[1,32,2,32],[0,32,0,33],[80,3,80,4],[1,1,2,1],[1,2,2,2],[1,17,2,17],[1,33,2,33],[3,32,26,32],[3,33,26,33],[1,18,2,18],[74,1,75,1],[2,3,2,4],[28,33,48,33],[50,32,72,32],[50,33,72,33],[74,33,82,33],[74,32,82,32]]}
[null,null,"年度 環境負荷削減活動実績表",null,null,{"$f":"IF(COUNTIF(U3:AF3,\"TRUE\")>2,\"エラー!!：チェック数は２カ所まで\",\"\")","v":""},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,"項目","種類","年目標値","単位","4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月","合計値","累計値\nor平均値",null,1,2,3,4,5,6,7,8,9,10,11,12,"増減の理由や分析内容","今期に実施した対策や見直し"]
[null,null,null,"(累積対比するはじめと最後の月にチェックを入れる）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(U3:AF3,\"TRUE\")>2,0,\"\")","v":""},true,false,false,false,false,false,false,false,false,false,false,true]
[null,"ア）建物系","電力","目標値もしくは前年度","kWh",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F4:Q4)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F4,0,U$19-1):OFFSET(Q4,0,U$20-12)))","v":0},null,{"$f":"IF(U3=TRUE,U2,\"\")","v":1},"","","","","","","","","","",12]
[null,null,null,"本年度実績","kWh",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F5:Q5)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F5,0,U$19-1):OFFSET(Q5,0,U$20-12)))","v":0}]
[null,null,null,null,null,{"$f":"IF(F4=\"\",\"\",IF(F4-F5>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G4=\"\",\"\",IF(G4-G5>=0,\"○\",\"×\"))","v":""},"","","","","","","","","","",{"$f":"IF(AND(R4=0,R5=0),\"\",IF(R4-R5>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S4=0,S5=0),\"\",IF(S4-S5>=0,\"○\",\"×\"))","v":""}]
[null,null,"都市ガス","目標値もしくは前年度","㎥",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F7:Q7)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F7,0,U$19-1):OFFSET(Q7,0,U$20-12)))","v":0}]
[null,null,null,"本年度実績","㎥",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F8:Q8)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F8,0,U$19-1):OFFSET(Q8,0,U$20-12)))","v":0},{"$f":"COUNTA(F8:Q8)","v":0}]
[null,null,null,null,null,{"$f":"IF(F7=\"\",\"\",IF(F7-F8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G7=\"\",\"\",IF(G7-G8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H7=\"\",\"\",IF(H7-H8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I7=\"\",\"\",IF(I7-I8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J7=\"\",\"\",IF(J7-J8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K7=\"\",\"\",IF(K7-K8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L7=\"\",\"\",IF(L7-L8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M7=\"\",\"\",IF(M7-M8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N7=\"\",\"\",IF(N7-N8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O7=\"\",\"\",IF(O7-O8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P7=\"\",\"\",IF(P7-P8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q7=\"\",\"\",IF(Q7-Q8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R7=0,R8=0),\"\",IF(R7-R8>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S7=0,S8=0),\"\",IF(S7-S8>=0,\"○\",\"×\"))","v":""}]
[null,null,"LPG","目標値もしくは前年度","kg",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F10:Q10)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F10,0,U$19-1):OFFSET(Q10,0,U$20-12)))","v":0},null,null,null,"kg",null,null,"揮発油（ガソリン）",null,2.3216999999999999,"L"]
[null,null,null,"本年度実績","kg",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F11:Q11)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F11,0,U$19-1):OFFSET(Q11,0,U$20-12)))","v":0},{"$f":"COUNTA(F11:Q11)","v":0},null,null,"㎥",null,null,"軽油",null,2.585,"L"]
[null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",IF(F10-F11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G10=\"\",\"\",IF(G10-G11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H10=\"\",\"\",IF(H10-H11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I10=\"\",\"\",IF(I10-I11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J10=\"\",\"\",IF(J10-J11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K10=\"\",\"\",IF(K10-K11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L10=\"\",\"\",IF(L10-L11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M10=\"\",\"\",IF(M10-M11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N10=\"\",\"\",IF(N10-N11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O10=\"\",\"\",IF(O10-O11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P10=\"\",\"\",IF(P10-P11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q10=\"\",\"\",IF(Q10-Q11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R10=0,R11=0),\"\",IF(R10-R11>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S10=0,S11=0),\"\",IF(S10-S11>=0,\"○\",\"×\"))","v":""},null,null,null,null,null,null,"Ａ重油",null,2.7096,"L"]
[null,null,"灯油","目標値もしくは前年度","L",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F13:Q13)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F13,0,U$19-1):OFFSET(Q13,0,U$20-12)))","v":0},null,null,null,null,null,null,"B、C重油",null,2.9958499999999999,"L"]
[null,null,null,"本年度実績","L",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F14:Q14)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F14,0,U$19-1):OFFSET(Q14,0,U$20-12)))","v":0},{"$f":"COUNTA(F14:Q14)","v":0},null,null,null,null,null,"その他ガス"]
[null,null,null,null,null,{"$f":"IF(F13=\"\",\"\",IF(F13-F14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G13=\"\",\"\",IF(G13-G14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H13=\"\",\"\",IF(H13-H14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I13=\"\",\"\",IF(I13-I14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J13=\"\",\"\",IF(J13-J14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K13=\"\",\"\",IF(K13-K14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L13=\"\",\"\",IF(L13-L14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M13=\"\",\"\",IF(M13-M14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N13=\"\",\"\",IF(N13-N14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O13=\"\",\"\",IF(O13-O14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P13=\"\",\"\",IF(P13-P14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q13=\"\",\"\",IF(Q13-Q14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R13=0,R14=0),\"\",IF(R13-R14>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S13=0,S14=0),\"\",IF(S13-S14>=0,\"○\",\"×\"))","v":""}]
[null,"その他燃料",null,"目標値もしくは前年度",{"$f":"IFERROR($AC$16,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F16:Q16)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F16,0,U$19-1):OFFSET(Q16,0,U$20-12)))","v":0},null,null,null,"L",null,null,{"$f":"MATCH(C16,Z10:Z14,0)","v":{"$error":"#N/A"}},null,{"$f":"INDEX(AB10:AB14,Z16)","v":{"$error":"#N/A"}},{"$f":"INDEX(AC10:AC14,Z16)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IFERROR($AB$16,0)","v":0},"本年度実績",{"$f":"IFERROR($AC$16,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F17:Q17)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F17,0,U$19-1):OFFSET(Q17,0,U$20-12)))","v":0},{"$f":"COUNTA(F17:Q17)","v":0},null,null,"kg"]
[null,null,null,null,null,{"$f":"IF(F16=\"\",\"\",IF(F16-F17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G16=\"\",\"\",IF(G16-G17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H16=\"\",\"\",IF(H16-H17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I16=\"\",\"\",IF(I16-I17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J16=\"\",\"\",IF(J16-J17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K16=\"\",\"\",IF(K16-K17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L16=\"\",\"\",IF(L16-L17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M16=\"\",\"\",IF(M16-M17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N16=\"\",\"\",IF(N16-N17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O16=\"\",\"\",IF(O16-O17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P16=\"\",\"\",IF(P16-P17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q16=\"\",\"\",IF(Q16-Q17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R16=0,R17=0),\"\",IF(R16-R17>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S16=0,S17=0),\"\",IF(S16-S17>=0,\"○\",\"×\"))","v":""}]
[null,null,"活動指標","床面積","㎡",null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,{"$f":"MATCH(T19,U3:AF3,0)","v":1}]
[null,null,"CO₂小計","当月目標値もしくは前年実績","t-CO₂",{"$f":"(F4*0.495+F7*2.1693+IF($E10=\"\",\"\",IF($E10=\"kg\",F10*2.9989,F10*6.05))+F13*2.4895+F16*$C$17)*0.001","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"_xlfn.AGGREGATE(9,7,F20:Q20)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F20,0,U$19-1):OFFSET(Q20,0,U$20-12)))","v":0},null,{"$f":"INDEX(U4:AE4,MATCH(MAX(U4:AE4)+1,U4:AE4,1))","v":1},null,"㎥"]
[null,null,null,"本年度当月実績","t-CO₂",{"$f":"IF(AND(F5=0,F8=0,F11=0,F14=0,F17=0),\"\",(F5*0.495+F8*2.1693+IF($E11=\"\",\"\",IF($E11=\"kg\",F11*2.9989,F11*6.05))+F14*2.4895+F17*$C$17)*0.001)","v":""},"","","","","","","","","","","",0,{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F21,0,U$19-1):OFFSET(Q21,0,U$20-12)))","v":0}]
[null,null,null,"当月削減量","t-CO₂",{"$f":"IFERROR(F20-F21,\"\")","v":""},{"$f":"IFERROR(G20-G21,\"\")","v":""},"","","","","","","","","","",{"$f":"R20-R21","v":0},0]
[null,null,null,"累積目標値","t-CO₂",{"$f":"F20","v":0},{"$f":"F23+G20","v":0},{"$f":"G23+H20","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"累積実績値","t-CO₂",{"$f":"F21","v":""},{"$f":"IFERROR(F24+G21,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IFERROR(O24+P21,NA())","v":{"$error":"#N/A"}},{"$f":"IFERROR(P24+Q21,NA())","v":{"$error":"#N/A"}}]
[null,null,null,"目標達成状況",null,{"$f":"IFERROR(IF(F23=\"\",\"\",IF(F23-F24>=0,\"○\",\"×\")),\"\")","v":""},"","","","","","","","","","","",{"$f":"IFERROR(IF(AND(R20=0,R21=0),\"\",IF(R20-R21>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(AND(S20=0,S21=0),\"\",IF(S20-S21>=0,\"○\",\"×\")),\"\")","v":""}]
[null,null,null,"原単位目標",{"$f":"E20&\"/\"&E19","v":"t-CO₂/㎡"}]
[null,null,null,"原単位実績",{"$f":"E21&\"/\"&E19","v":"t-CO₂/㎡"},{"$f":"IFERROR(F21/F19*12,\"\")","v":""},{"$f":"IFERROR(G21/G19*12,\"\")","v":""},"","","","","","","","","","",{"$f":"R21/R19","v":{"$error":"#DIV/0!"}},{"$f":"S21/S19","v":{"$error":"#DIV/0!"}}]
[]
[null,"イ）現場系","電力","目標値もしくは前年度","kWh",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F29:Q29)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F29,0,U$19-1):OFFSET(Q29,0,U$20-12)))","v":0}]
[null,null,null,"本年度実績","kWh",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F30:Q30)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F30,0,U$19-1):OFFSET(Q30,0,U$20-12)))","v":0}]
[null,null,null,null,null,{"$f":"IF(F29=\"\",\"\",IF(F29-F30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G29=\"\",\"\",IF(G29-G30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H29=\"\",\"\",IF(H29-H30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I29=\"\",\"\",IF(I29-I30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J29=\"\",\"\",IF(J29-J30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K29=\"\",\"\",IF(K29-K30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L29=\"\",\"\",IF(L29-L30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M29=\"\",\"\",IF(M29-M30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N29=\"\",\"\",IF(N29-N30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O29=\"\",\"\",IF(O29-O30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P29=\"\",\"\",IF(P29-P30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q29=\"\",\"\",IF(Q29-Q30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R29=0,R30=0),\"\",IF(R29-R30>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S29=0,S30=0),\"\",IF(S29-S30>=0,\"○\",\"×\"))","v":""}]
[null,null,"軽油","目標値もしくは前年度","㎥",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F32:Q32)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F32,0,U$19-1):OFFSET(Q32,0,U$20-12)))","v":0}]
[null,null,null,"本年度実績","㎥",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F33:Q33)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F33,0,U$19-1):OFFSET(Q33,0,U$20-12)))","v":0},null,null,null,null,null,null,"揮発油（ガソリン）",null,2.3216999999999999,"L"]
[null,null,null,null,null,{"$f":"IF(F32=\"\",\"\",IF(F32-F33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G32=\"\",\"\",IF(G32-G33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H32=\"\",\"\",IF(H32-H33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I32=\"\",\"\",IF(I32-I33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J32=\"\",\"\",IF(J32-J33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K32=\"\",\"\",IF(K32-K33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L32=\"\",\"\",IF(L32-L33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M32=\"\",\"\",IF(M32-M33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N32=\"\",\"\",IF(N32-N33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O32=\"\",\"\",IF(O32-O33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P32=\"\",\"\",IF(P32-P33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q32=\"\",\"\",IF(Q32-Q33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R32=0,R33=0),\"\",IF(R32-R33>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S32=0,S33=0),\"\",IF(S32-S33>=0,\"○\",\"×\"))","v":""},null,null,null,null,null,null,"軽油",null,2.585,"L"]
[null,null,"灯油","目標値もしくは前年度","L",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F35:Q35)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F35,0,U$19-1):OFFSET(Q35,0,U$20-12)))","v":0},null,null,null,null,null,null,"Ａ重油",null,2.7096,"L"]
[null,null,null,"本年度実績","L",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F36:Q36)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F36,0,U$19-1):OFFSET(Q36,0,U$20-12)))","v":0},null,null,null,null,null,null,"B、C重油",null,2.9958499999999999,"L"]
[null,null,null,null,null,{"$f":"IF(F35=\"\",\"\",IF(F35-F36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G35=\"\",\"\",IF(G35-G36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H35=\"\",\"\",IF(H35-H36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I35=\"\",\"\",IF(I35-I36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J35=\"\",\"\",IF(J35-J36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K35=\"\",\"\",IF(K35-K36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L35=\"\",\"\",IF(L35-L36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M35=\"\",\"\",IF(M35-M36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N35=\"\",\"\",IF(N35-N36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O35=\"\",\"\",IF(O35-O36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P35=\"\",\"\",IF(P35-P36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q35=\"\",\"\",IF(Q35-Q36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R35=0,R36=0),\"\",IF(R35-R36>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S35=0,S36=0),\"\",IF(S35-S36>=0,\"○\",\"×\"))","v":""},null,null,null,null,null,null,"その他ガス"]
[null,"その他燃料",null,"目標値もしくは前年度",{"$f":"IFERROR($AC$39,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F38:Q38)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F38,0,U$19-1):OFFSET(Q38,0,U$20-12)))","v":0}]
[null,null,{"$f":"IFERROR($AB39,0)","v":0},"本年度実績",{"$f":"IFERROR($AC$39,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F39:Q39)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F39,0,U$19-1):OFFSET(Q39,0,U$20-12)))","v":0},null,null,null,null,null,null,{"$f":"MATCH(C38,Z33:Z37,0)","v":{"$error":"#N/A"}},null,{"$f":"INDEX(AB33:AB37,Z39)","v":{"$error":"#N/A"}},{"$f":"INDEX(AC33:AC37,Z39)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"IF(F38=\"\",\"\",IF(F38-F39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G38=\"\",\"\",IF(G38-G39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(H38=\"\",\"\",IF(H38-H39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(I38=\"\",\"\",IF(I38-I39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(J38=\"\",\"\",IF(J38-J39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(K38=\"\",\"\",IF(K38-K39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(L38=\"\",\"\",IF(L38-L39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(M38=\"\",\"\",IF(M38-M39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(N38=\"\",\"\",IF(N38-N39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(O38=\"\",\"\",IF(O38-O39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(P38=\"\",\"\",IF(P38-P39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(Q38=\"\",\"\",IF(Q38-Q39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(R38=0,R39=0),\"\",IF(R38-R39>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S38=0,S39=0),\"\",IF(S38-S39>=0,\"○\",\"×\"))","v":""}]
[null,null,"活動指標"]
[null,null,"CO₂小計","当月目標値もしくは前年実績","t-CO₂",{"$f":"(F29*0.495+F32*2.585+F35*2.4895+F38*$C$39)*0.001","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"_xlfn.AGGREGATE(9,7,F42:Q42)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F42,0,U$19-1):OFFSET(Q42,0,U$20-12)))","v":0}]
[null,null,null,"本年度当月実績","t-CO₂",{"$f":"IF(AND(F30=0,F33=0,F36=0,F39=0),\"\",(F30*0.495+F33*2.585+F36*2.4895+F39*$C$39)*0.001)","v":""},"","","","","","","","","","","",{"$f":"_xlfn.AGGREGATE(9,7,F43:Q43)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F43,0,U$19-1):OFFSET(Q43,0,U$20-12)))","v":0}]
[null,null,null,"当月削減量","t-CO₂",{"$f":"IFERROR(F42-F43,\"\")","v":""},{"$f":"IFERROR(G42-G43,\"\")","v":""},"","","","","","","","","","",{"$f":"IFERROR(R42-R43,\"\")","v":0},{"$f":"S42-S43","v":0}]
[null,null,null,"累積目標値","t-CO₂",{"$f":"F42","v":0},{"$f":"F45+G42","v":0},{"$f":"G45+H42","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"累積実績値","t-CO₂",{"$f":"F43","v":""},{"$f":"IFERROR(F46+G43,\"\")","v":""},{"$f":"IFERROR(G46+H43,\"\")","v":""},"","","","","","","","",""]
[null,null,null,"目標達成状況",null,{"$f":"IFERROR(IF(F45=\"\",\"\",IF(F45-F46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(G45=\"\",\"\",IF(G45-G46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(H45=\"\",\"\",IF(H45-H46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(I45=\"\",\"\",IF(I45-I46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(J45=\"\",\"\",IF(J45-J46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(K45=\"\",\"\",IF(K45-K46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(L45=\"\",\"\",IF(L45-L46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(M45=\"\",\"\",IF(M45-M46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(N45=\"\",\"\",IF(N45-N46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(O45=\"\",\"\",IF(O45-O46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(P45=\"\",\"\",IF(P45-P46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(Q45=\"\",\"\",IF(Q45-Q46>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(AND(R42=0,R43=0),\"\",IF(R42-R43>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(AND(S42=0,S43=0),\"\",IF(S42-S43>=0,\"○\",\"×\")),\"\")","v":""}]
[null,null,null,"原単位目標",{"$f":"E42&\"/\"&E41","v":"t-CO₂/"}]
[null,null,null,"原単位実績",{"$f":"E43&\"/\"&E41","v":"t-CO₂/"},{"$f":"IFERROR(F43/F41*12,\"\")","v":""},{"$f":"IFERROR(G43/G41*12,\"\")","v":""},"","","","","","","","","","",{"$f":"R43/R41","v":{"$error":"#DIV/0!"}},{"$f":"S43/S41","v":{"$error":"#DIV/0!"}}]
[]
[null,"ウ）自動車","ガソリン","目標値もしくは前年度","ｋL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F51:Q51)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F51,0,U$19-1):OFFSET(Q51,0,U$20-12)))","v":0}]
[null,null,null,"本年度実績","ｋL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F52:Q52)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F52,0,U$19-1):OFFSET(Q52,0,U$20-12)))","v":0}]
[null,null,null,"台数","台",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(1,7,F53:Q53)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"走行距離","千km",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F54:Q54)","v":0},{"$f":"_xlfn.AGGREGATE(1,7,F54:Q54)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(F51=\"\",\"\",IF(F51-F52>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G51=\"\",\"\",IF(G51-G52>=0,\"○\",\"×\"))","v":""},"","","","","","","","","","",{"$f":"IF(AND(R51=0,R52=0),\"\",IF(R51-R52>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S51=0,S52=0),\"\",IF(S51-S52>=0,\"○\",\"×\"))","v":""}]
[null,null,"軽油","目標値もしくは前年度","ｋL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F56:Q56)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F56,0,U$19-1):OFFSET(Q56,0,U$20-12)))","v":0}]
[null,null,null,"本年度実績","ｋL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F57:Q57)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F57,0,U$19-1):OFFSET(Q57,0,U$20-12)))","v":0}]
[null,null,null,"台数","台",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(1,7,F58:Q58)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(R56=0,R57=0),\"\",IF(R56-R57>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S56=0,S57=0),\"\",IF(S56-S57>=0,\"○\",\"×\"))","v":""}]
[null,"その他燃料",null,"目標値もしくは前年度",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F60:Q60)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F60,0,U$19-1):OFFSET(Q60,0,U$20-12)))","v":0}]
[null,"CO₂排出係数",null,"本年度実績",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F61:Q61)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F61,0,U$19-1):OFFSET(Q61,0,U$20-12)))","v":0}]
[null,null,null,"台数","台",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(1,7,F62:Q62)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"走行距離","千km",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,7,F63:Q63)","v":0},{"$f":"_xlfn.AGGREGATE(1,7,F63:Q63)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(F60=\"\",\"\",IF(F60-F61>=0,\"○\",\"×\"))","v":""},{"$f":"IF(G60=\"\",\"\",IF(G60-G61>=0,\"○\",\"×\"))","v":""},"","","","","","","","","","",{"$f":"IF(AND(R60=0,R61=0),\"\",IF(R60-R61>=0,\"○\",\"×\"))","v":""},{"$f":"IF(AND(S60=0,S61=0),\"\",IF(S60-S61>=0,\"○\",\"×\"))","v":""}]
[null,null,"活動指標","自動車台数","台"]
[null,null,"CO₂小計","当月目標値もしくは前年実績","t-CO₂",{"$f":"(F51*2.3217+F56*2.585+F60*$C$61)*0.001","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"_xlfn.AGGREGATE(9,7,F66:Q66)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F66,0,U$19-1):OFFSET(Q66,0,U$20-12)))","v":0}]
[null,null,null,"本年度当月実績","t-CO₂",{"$f":"IF(AND(F52=0,F57=0,F61=0),\"\",(F52*2.3217+F57*2.585+F61*$C$61)*0.001)","v":""},"","","","","","","","","","","",{"$f":"_xlfn.AGGREGATE(9,7,F67:Q67)","v":0},{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F67,0,U$19-1):OFFSET(Q67,0,U$20-12)))","v":0}]
[null,null,null,"当月削減量","t-CO₂",{"$f":"IFERROR(F66-F67,\"\")","v":""},{"$f":"IFERROR(G66-G67,\"\")","v":""},"","","","","","","","","","",{"$f":"R66-R67","v":0},0]
[null,null,null,"累積目標値","t-CO₂",{"$f":"F66","v":0},{"$f":"F69+G66","v":0},{"$f":"G69+H66","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"累積実績値","t-CO₂",{"$f":"F67","v":""},{"$f":"IFERROR(F70+G67,\"\")","v":""},{"$f":"IFERROR(G70+H67,\"\")","v":""},"","","","","","","","",""]
[null,null,null,"目標達成状況",null,{"$f":"IFERROR(IF(F69=\"\",\"\",IF(F69-F70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(G69=\"\",\"\",IF(G69-G70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(H69=\"\",\"\",IF(H69-H70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(I69=\"\",\"\",IF(I69-I70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(J69=\"\",\"\",IF(J69-J70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(K69=\"\",\"\",IF(K69-K70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(L69=\"\",\"\",IF(L69-L70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(M69=\"\",\"\",IF(M69-M70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(N69=\"\",\"\",IF(N69-N70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(O69=\"\",\"\",IF(O69-O70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(P69=\"\",\"\",IF(P69-P70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(Q69=\"\",\"\",IF(Q69-Q70>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(AND(R66=0,R67=0),\"\",IF(R66-R67>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(AND(S66=0,S67=0),\"\",IF(S66-S67>=0,\"○\",\"×\")),\"\")","v":""}]
[null,null,null,"原単位目標",{"$f":"E66&\"/\"&E65","v":"t-CO₂/台"}]
[null,null,null,"原単位実績",{"$f":"E67&\"/\"&E65","v":"t-CO₂/台"},{"$f":"IFERROR(F67/F65*12,\"\")","v":""},"","","","","","","","",{"$f":"IFERROR(O67/O65*12,\"\")","v":""},"","",{"$f":"R67/R65","v":{"$error":"#DIV/0!"}},{"$f":"S67/S65","v":{"$error":"#DIV/0!"}}]
[]
[null,"エ）ＣＯ₂排出量合計","活動指標","売上額","百万円"]
[null,null,null,"目標値もしくは前年度","t-CO₂",{"$f":"_xlfn.AGGREGATE(9,7,F20,F42,F66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F76,0,U$19-1):OFFSET(Q76,0,U$20-12)))","v":0}]
[null,null,null,"本年度当月実績","t-CO₂",{"$f":"_xlfn.AGGREGATE(9,7,F21,F43,F67)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($T$3=0,\"エラー\",SUM(OFFSET(F77,0,U$19-1):OFFSET(Q77,0,U$20-12)))","v":0}]
[null,null,null,"当月削減量","t-CO₂",{"$f":"IFERROR(F76-F77,NA())","v":0},{"$f":"IFERROR(G76-G77,NA())","v":0},{"$f":"IFERROR(H76-H77,NA())","v":0},{"$f":"IFERROR(I76-I77,NA())","v":0},{"$f":"IFERROR(J76-J77,NA())","v":0},{"$f":"IFERROR(K76-K77,NA())","v":0},{"$f":"IFERROR(L76-L77,NA())","v":0},{"$f":"IFERROR(M76-M77,NA())","v":0},{"$f":"IFERROR(N76-N77,NA())","v":0},{"$f":"IFERROR(O76-O77,NA())","v":0},{"$f":"IFERROR(P76-P77,NA())","v":0},{"$f":"IFERROR(Q76-Q77,NA())","v":0},{"$f":"IFERROR(R76-R77,\"\")","v":0},{"$f":"S76-S77","v":0}]
[null,null,null,"累積目標値","t-CO₂",{"$f":"F76","v":0},{"$f":"F79+G76","v":0},{"$f":"G79+H76","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"累積実績値","t-CO₂",{"$f":"F77","v":0},{"$f":"IFERROR(F80+G77,\"\")","v":0},{"$f":"IFERROR(G80+H77,\"\")","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"目標達成状況(累積値評価）",null,{"$f":"IFERROR(IF(F76=\"\",\"\",IF(F76-F77>=0,\"○\",\"×\")),\"\")","v":"○"},{"$f":"IFERROR(IF(G76=\"\",\"\",IF(G76-G77>=0,\"○\",\"×\")),\"\")","v":"○"},"○","○","○","○","○","○","○","○","○","○",{"$f":"IFERROR(IF(AND(R76=0,R77=0),\"\",IF(R76-R77>=0,\"○\",\"×\")),\"\")","v":""},{"$f":"IFERROR(IF(AND(S76=0,S77=0),\"\",IF(S76-S77>=0,\"○\",\"×\")),\"\")","v":""}]
[null,null,null,"原単位目標",{"$f":"E76&\"/\"&E75","v":"t-CO₂/百万円"}]
[null,null,null,"原単位実績",{"$f":"E77&\"/\"&E75","v":"t-CO₂/百万円"},{"$f":"IFERROR(F77/F75*12,\"\")","v":""},{"$f":"IFERROR(G77/G75*12,\"\")","v":""},"","","","","","","","","","",{"$f":"R77/R75","v":{"$error":"#DIV/0!"}},{"$f":"S77/S75","v":{"$error":"#DIV/0!"}}]

{"sheet":"グラフ(参考）","index":8,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["◆ ＣＯ₂排出量目標達成状況グラフ"]

{"sheet":"３ページ補足","index":9,"n_rows":53,"n_cols":30,"rows_kept":53,"cut":false,"hidden":false,"merged":[[14,3,14,4],[5,1,6,2],[5,3,6,4],[7,3,7,4],[12,1,13,2],[12,3,13,4],[37,1,37,2],[37,3,37,4],[19,1,20,2],[19,3,20,4],[21,3,21,4],[26,1,27,2],[26,3,27,4],[28,3,28,4],[2,1,2,8],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,1,41,2],[41,3,41,4],[4,4,4,8],[11,4,11,8],[18,4,18,8],[25,4,25,8],[33,1,33,9],[34,3,34,4],[35,3,36,4],[35,5,36,5],[35,6,36,6],[35,9,36,9],[46,3,46,4],[47,3,48,4],[47,6,48,6],[47,7,48,7],[47,11,48,11],[52,1,52,2],[52,3,52,4],[47,5,48,5],[49,3,49,4],[50,3,50,4],[51,3,51,4]]}
["◆ ３ページの補足"]
[]
[]
[]
[null,"ア）建物系ＣＯ₂排出量実績",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年度",20,21,22,23,24,25,26,27,28,29,30,31]
[null,"項　　　目",null,"単位指標等",null,null,{"$f":"IF(F6=\"\",\"\",IF(F6=\"31/1\",2,IF(F6=30,1,F6+1)))","v":""},{"$f":"IF(G6=\"\",\"\",IF(G6=\"31/1\",2,IF(G6=30,1,G6+1)))","v":""},{"$f":"IF(H6=\"\",\"\",IF(H6=\"31/1\",2,IF(H6=30,1,H6+1)))","v":""},null,null,null,null,null,null,null,null,"建物系",{"$f":"IF($P$3=1,S12+S18,S12)","v":0},{"$f":"IF($P$3=1,T12+T18,T12)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"年度","年度","年度","年度",null,null,null,null,null,null,null,null,"工場・現場系",{"$f":"IF($P$3=1,S13+S19,S13)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年",null,null,null,null,null,null,null,null,null,null,null,null,null,"自動車系",{"$f":"IF($P$3=1,S14+S20,S14)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"D10&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E10,\"\")","v":""},{"$f":"IFERROR(ROUND(F8/F10,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G8/G10,4),\"\")","v":""},"","",null,null,null,{"$f":"MATCH(D10,$N$12:$N$21,0)","v":{"$error":"#N/A"}}]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,M9),\"\")","v":""},null,null,null,null,null,null,null,null,"●原単位活動指標表",null,null,null,"ＣＯ₂排出量補正結果"]
[null,null,null,null,null,{"$f":"IF(AND(F8<>\"\",I8=\"\"),\"直近4カ年の実績値を入れてください！\",\"\")","v":""},null,null,null,null,null,null,null,"指標名","単位",null,"当たり","年度",20,21,22,23,24,25,26,27,28,29,30,31]
[null,"イ）工場・現場系ＣＯ₂排出量実績",null,null,null,null,null,null,null,null,null,null,null,"（床面積）","㎡",null,null,"建物系",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"項　　　目",null,"単位指標等",null,{"$f":"IF(F6=\"\",\"\",F6)","v":""},{"$f":"IF(G6=\"\",\"\",G6)","v":""},{"$f":"IF(H6=\"\",\"\",H6)","v":""},{"$f":"IF(I6=\"\",\"\",I6)","v":""},null,null,null,null,"（敷地面積）","㎡",null,null,"工場・現場系",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"年度","年度","年度","年度",null,null,null,null,"（売上額）","億円",null,null,"自動車系",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年",null,null,null,null,null,null,null,null,null,"（受注額）","億円"]
[null,{"$f":"D17&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E17,\"\")","v":""},{"$f":"IFERROR(ROUND(F15/F17,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G15/G17,4),\"\")","v":""},"","",null,null,null,{"$f":"MATCH(D17,$N$12:$N$21,0)","v":{"$error":"#N/A"}},"（従業員数）","人",null,null,"その他のＣＯ₂排出量"]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,M16),\"\")","v":""},null,null,null,null,null,null,null,null,"（台数）","台",null,null,"年度",20,21,22,23,24,25,26,27,28,29,30,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（走行距離）","千km",null,null,"建物系",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ウ）自動車系ＣＯ₂排出量実績",null,null,null,null,null,null,null,null,null,null,null,"（生産量）","ﾄﾝ",null,null,"工場・現場系",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"項　　　目",null,"単位指標等",null,{"$f":"IF(F6=\"\",\"\",F6)","v":""},{"$f":"IF(G6=\"\",\"\",G6)","v":""},"","",null,null,null,null,null,null,null,null,"自動車系",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"年度","年度","年度","年度"]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年"]
[null,{"$f":"D24&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E24,\"\")","v":""},{"$f":"IFERROR(ROUND(F22/F24,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G22/G24,4),\"\")","v":""},"","",null,null,null,{"$f":"MATCH(D24,$N$12:$N$21,0)","v":{"$error":"#N/A"}}]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,M23),\"\")","v":""}]
[]
[null,"エ）（ア＋イ＋ウ）合計"]
[null,"項　　　目",null,"単位指標等",null,{"$f":"IF(F6=\"\",\"\",F6)","v":""},{"$f":"IF(G6=\"\",\"\",G6)","v":""},"","",null,null,null,null,null,null,"（","）"]
[null,null,null,null,null,"年度","年度","年度","年度"]
[null,"ＣＯ₂排出量",null,"ｔ-ＣＯ₂／年",null,{"$f":"IFERROR(F8+F15+F22,\"\")","v":0},{"$f":"IFERROR(G8+G15+G22,\"\")","v":0},0,0]
[null,{"$f":"D31&\"当たり\"","v":"当たり"},null,"ｔ-ＣＯ₂／",{"$f":"IFERROR(E31,\"\")","v":""},{"$f":"IFERROR(ROUND(F29/F31,4),\"\")","v":""},{"$f":"IFERROR(ROUND(G29/G31,4),\"\")","v":""},"","",null,null,null,{"$f":"MATCH(D31,$N$12:$N$21,0)","v":{"$error":"#N/A"}}]
[null,"原単位の指標",null,null,{"$f":"IFERROR(INDEX($O$12:$O$21,M30),\"\")","v":""}]
[]
["（３）’二酸化炭素排出量及び原単位の実績",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,"（ｔ-ＣＯ₂）","（％）",{"$f":"D31&Q11","v":"当たり"},{"$f":"D31&Q11","v":"当たり"},"（％）",null,null,null,null,null,null,"２２年度"]
[null,null,null,null,null,null,null,{"$f":"P27&D30&E30&Q27","v":"（ｔ-ＣＯ₂／）"},{"$f":"P27&D30&E30&Q27","v":"（ｔ-ＣＯ₂／）"},null,null,null,null,null,null,null,"２３年度"]
[null,"基準値",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"２４年度"]
[null,null,"年度",{"$f":"IF(B39=\"\",\"\",IFERROR((HLOOKUP(B39,F$27:I$31,3,FALSE)),\"\"))","v":""},null,{"$f":"IF(D39=\"\",\"\",D39-D$38)","v":""},{"$f":"IF(F39=\"\",\"\",F39/D$38*100)","v":""},{"$f":"IF(B39=\"\",\"\",IFERROR((HLOOKUP(B39,F$27:I$31,4,FALSE)),\"\"))","v":""},{"$f":"IF(H39=\"\",\"\",H39-H$38)","v":""},{"$f":"IF(I39=\"\",\"\",I39/H$38*100)","v":""},null,null,null,null,null,null,"２５年度"]
[null,{"$f":"IF(B39=\"\",\"\",IF(B39=\"31/1\",2,IF(B39=30,1,B39+1)))","v":""},"年度",{"$f":"IF(B40=\"\",\"\",IFERROR((HLOOKUP(B40,F$27:I$31,3,FALSE)),\"\"))","v":""},null,{"$f":"IF(D40=\"\",\"\",D40-D$38)","v":""},{"$f":"IF(F40=\"\",\"\",F40/D$38*100)","v":""},{"$f":"IF(B40=\"\",\"\",IFERROR((HLOOKUP(B40,F$27:I$31,4,FALSE)),\"\"))","v":""},{"$f":"IF(H40=\"\",\"\",H40-H$38)","v":""},{"$f":"IF(I40=\"\",\"\",I40/H$38*100)","v":""},null,null,null,null,null,null,"２６年度"]
[null,{"$f":"IF(B40=\"\",\"\",IF(B40=\"31/1\",2,IF(B40=30,1,B40+1)))","v":""},"年度","",null,{"$f":"IF(D41=\"\",\"\",D41-D$38)","v":""},{"$f":"IF(F41=\"\",\"\",F41/D$38*100)","v":""},"",{"$f":"IF(H41=\"\",\"\",H41-H$38)","v":""},{"$f":"IF(I41=\"\",\"\",I41/H$38*100)","v":""},null,null,null,null,null,null,"２７年度"]
[null,"平均削減率",null,null,null,null,{"$f":"IF(G39=\"\",\"\",AVERAGE(G39:G41))","v":""},null,null,{"$f":"IF(J39=\"\",\"\",AVERAGE(J39:J41))","v":""},null,null,null,null,null,null,"２８年度"]
[]
[]
[]
[null,"●県と協議し、期間中に基準値変更した場合"]
[null,"年　　度",null,"ＣＯ₂排出量",null,"基準値","削減量","削減率","ＣＯ₂原単位","基準値","削減量","削減率"]
[null,null,null,"（ｔ-ＣＯ₂）",null,"（ｔ-ＣＯ₂）","（ｔ-ＣＯ₂）","（％）",{"$f":"D31&Q11","v":"当たり"},{"$f":"I48","v":"当たり"},{"$f":"J48","v":"当たり"},"（％）"]
[null,null,null,null,null,null,null,null,{"$f":"O27&C30&D30&P27","v":"ｔ-ＣＯ₂／（"},{"$f":"P27&D30&E30&Q27","v":"（ｔ-ＣＯ₂／）"},{"$f":"J49","v":"（ｔ-ＣＯ₂／）"}]
[null,null,"年度",{"$f":"IF(B50=\"\",\"\",IFERROR((HLOOKUP(B50,F$27:I$31,3,FALSE)),\"\"))","v":""},null,null,{"$f":"IF(D50=\"\",\"\",D50-F50)","v":""},{"$f":"IF(G50=\"\",\"\",G50/F50*100)","v":""},{"$f":"IF(B50=\"\",\"\",IFERROR((HLOOKUP(B50,G$27:J$31,4,FALSE)),\"\"))","v":""},null,{"$f":"IF(H50=\"\",\"\",H50-J50)","v":""},{"$f":"IF(K50=\"\",\"\",K50/J50*100)","v":""}]
[null,null,"年度",{"$f":"IF(B51=\"\",\"\",IFERROR((HLOOKUP(B51,F$27:I$31,3,FALSE)),\"\"))","v":""},null,null,{"$f":"IF(D51=\"\",\"\",D51-F51)","v":""},{"$f":"IF(G51=\"\",\"\",G51/F51*100)","v":""},{"$f":"IF(B51=\"\",\"\",IFERROR((HLOOKUP(B51,G$27:J$31,4,FALSE)),\"\"))","v":""},null,{"$f":"IF(H51=\"\",\"\",H51-J51)","v":""},{"$f":"IF(K51=\"\",\"\",K51/J51*100)","v":""}]
[null,null,"年度","",null,null,"","","",null,{"$f":"IF(H52=\"\",\"\",H52-J52)","v":""},""]
[null,"平均削減率",null,null,null,null,null,{"$f":"IF(H50=\"\",\"\",AVERAGE(H50:H52))","v":""},null,null,null,{"$f":"IF(L50=\"\",\"\",AVERAGE(L50:L52))","v":""}]

{"sheet":"目標変更ページ","index":10,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,2,6,3],[6,4,6,5],[5,4,5,5],[15,4,15,5],[14,4,14,5],[13,2,13,3],[13,4,13,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,2,19,3],[19,4,19,5],[4,4,4,5],[3,2,3,3],[3,4,3,5],[42,2,48,12],[23,2,38,12],[7,4,7,5],[9,4,9,5],[8,4,8,5],[10,2,10,3],[10,4,10,5],[4,8,5,8],[12,8,12,12],[14,9,15,9],[14,10,15,10],[14,11,15,11],[4,9,5,9]]}
[null,"環境への負荷低減目標・・・・申請時より目標を変更した場合に記載する（県との協議が必要）"]
[null,null,"（１）二酸化炭素の削減目標"]
[null,null,"ア）認証時の目標表",null,null,null,null,null,"基準値  （　　　～ 　　年度　　平均）"]
[null,null,"年度",null,"CO₂排出量",null,"増減量","削減率","CO₂原単位","増減量","削減率"]
[null,null,null,null,"（t-CO₂）",null,"（t-CO₂）","（％）","当たり\nt-CO₂/","当たり\nt-CO₂/","（％）"]
[]
[null,null,"基準値"]
[null,null,null,"年",null,null,{"$f":"IF(E8=\"\",\"\",E8-E$7)","v":""},{"$f":"IF(E8=\"\",\"\",G8/E$7)","v":""},null,{"$f":"IF(I8=\"\",\"\",I8-I$7)","v":""},{"$f":"IF(I8=\"\",\"\",J8/I$7)","v":""}]
[null,null,null,"年",null,null,{"$f":"IF(E9=\"\",\"\",E9-E$7)","v":""},{"$f":"IF(E9=\"\",\"\",G9/E$7)","v":""},null,{"$f":"IF(I9=\"\",\"\",I9-I$7)","v":""},{"$f":"IF(I9=\"\",\"\",J9/I$7)","v":""}]
[null,null,null,"年",null,null,{"$f":"IF(E10=\"\",\"\",E10-E$7)","v":""},"",null,{"$f":"IF(I10=\"\",\"\",I10-I$7)","v":""},""]
[null,null,"平均増減率",null,null,null,null,{"$f":"IFERROR(AVERAGE(H8:H10),\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGE(K8:K10),\"\")","v":""}]
[]
[null,null,"イ）変更後の目標表",null,null,null,null,null,"基準値  （　　　～ 　　年度　　平均）"]
[null,null,"年度",null,"CO₂排出量",null,"基準値","増減量","削減率","CO₂原単位","基準値","増減量","削減率"]
[null,null,null,null,"（t-CO₂）",null,"（t-CO₂）","（t-CO₂）","（％）","当たり\n(ｔ-ＣＯ₂/　）","当たり\n(ｔ-ＣＯ₂/　）","当たり\n(ｔ-ＣＯ₂/　）","（％）"]
[]
[null,null,null,"年",null,null,null,{"$f":"IF(E17=\"\",\"\",E17-G17)","v":""},{"$f":"IF(E17=\"\",\"\",H17/G17)","v":""},null,null,{"$f":"IF(J17=\"\",\"\",J17-K17)","v":""},{"$f":"IF(J17=\"\",\"\",L17/K17)","v":""}]
[null,null,null,"年",null,null,null,{"$f":"IF(E18=\"\",\"\",E18-G18)","v":""},{"$f":"IF(E18=\"\",\"\",H18/G18)","v":""},null,null,{"$f":"IF(J18=\"\",\"\",J18-K18)","v":""},{"$f":"IF(J18=\"\",\"\",L18/K18)","v":""}]
[null,null,null,"年",null,null,null,"","",null,null,{"$f":"IF(J19=\"\",\"\",J19-K19)","v":""},{"$f":"IF(J19=\"\",\"\",L19/K19)","v":""}]
[null,null,"平均増減率",null,null,null,null,null,{"$f":"IFERROR(AVERAGE(I17:I19),\"\")","v":""},null,null,null,{"$f":"IFERROR(AVERAGE(M17:M19),\"\")","v":""}]
[]
[null,null,"（２）二酸化炭素排出量等の増減に関する情報・説明"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"（３）その他の環境に重大な影響を与える項目の目標及びその他の情報・説明"]

{"sheet":"補足説明","index":11,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[[2,2,44,30],[1,2,1,30]]}
[null,null,"◆補足説明"]