{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["入力シート","使い方","Posiwatt_Sheet","Add_Resource_Style","Input_Sheet (予備)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":2,"comments":3,"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":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,5,1,11],[0,3,0,4],[9,10,9,11],[2,6,2,11],[3,6,3,11],[5,9,5,11],[6,10,6,11],[9,5,9,8],[5,3,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[15,3,15,8],[15,9,15,10],[7,10,7,11],[8,10,8,11],[10,5,10,8],[10,10,10,11],[14,2,14,11]]}
[null,null,null,"三次調整力②需要家リスト・パターン入力支援ツール",null,"【重要】本ツールは，三次②需要家リスト・パターン受等領業務ビジネスプロトコル標準規格のパブリックコメント前に作成したため，規格が変更となる可能性があります。本ツールで作成したXMLファイルを需給調整市場システムへ提出した場合，未提出扱いとします。"]
[]
[null,null,null,"対象需要家リスト・パターン","パターン④","読込ファイル名","C:\\Users\\T1202480\\Desktop\\W9_0232_20210418_3Y543_04_KSS2019.xml",null,null,null,null,null,null,null,"需要家数"]
[null,null,null,"供出可能量（kW)",85637,"出力先","C:\\Users\\T1202480\\Desktop",null,null,null,null,null,null,null,13]
[null,null,null,"適用開始希望年月日","20210418",null,null,null,null,null,null,null,null,null,"発電所数"]
[null,null,null,"基本情報",null,null,null,null,null,"出力ファイル名情報",null,null,null,null,0]
[null,null,null,null,"コード","名称▲",null,null,null,"XMLファイル名",{"$f":"\"W9_0232_\"&K8&\"_\"&K9&\"_\"&K10&\"_\"&K11&\".xml\"","v":"W9_0232_20210418_3Y543_04_KSS2019.xml"}]
[null,null,null,"情報区分","0232","三次調整力②需要家リスト・パターン",null,null,null,"対象時期の開始日",{"$f":"E5","v":"20210418"}]
[null,null,null,"提出先事業者","10033","東京電力パワーグリッド株式会社",null,null,null,"アグリゲータ用系統コード",{"$f":"E11","v":"3Y543"}]
[null,null,null,"送信事業者","80363","グローバルエナジーアグリゲーター",null,null,null,"対象需要家リスト・パターン番号",{"$f":"IF(E3=\"パターン①\",\"01\",IF(E3=\"パターン②\",\"02\",IF(E3=\"パターン③\",\"03\",IF(E3=\"パターン④\",\"04\",IF(E3=\"パターン⑤\",\"05\",IF(E3=\"パターン⑥\",\"06\",IF(E3=\"パターン⑦\",\"07\",IF(E3=\"パターン⑧\",\"08\",IF(E3=\"パターン⑨\",\"09\",IF(E3=\"パターン⑩\",\"10\",IF( E3=\"パターン⑪\",\"11\",IF(E3=\"パターン⑫\",\"12\",IF(E3=\"パターン⑬\",\"13\",IF(E3=\"パターン⑭\",\"14\",IF(E3=\"パターン⑮\",\"15\",IF(E3=\"パターン⑯\",\"16\",IF(E3=\"パターン⑰\",\"17\",IF(E3=\"パターン⑱\",\"18\",IF(E3=\"パターン⑲\",\"19\",IF(E3=\"パターン⑳\",\"20\"))))))))))))))))))))","v":"04"}]
[null,null,null,"提出者(アグリゲータ用系統コード）","3Y543","グローバルエナジーアグリゲーター",null,null,null,"電源等コード","KSS2019"]
[null,null,null,"運用モード","通常"]
[]
[]
[null,null,"ネガワットリスト"]
[null,null,null,"需要家情報",null,null,null,null,null,"所属需要BG情報",null,"他需要抑制契約の状況"]
[null,null,"NO","供給地点特定番号","需要家名称","所在地","契約電力(kW)","電圧区分","供出方法","小売電気事業者コード","小売電気事業者名称▲","類型Ⅰ②\n需要抑制BGコード"]
[null,null,1,"0311111111111111111111","東京工場","東京都大田区〇-〇-〇",5856,"特高","需要抑制","422*3","P2Pネット","****3"]
[null,null,2,"0322222222222222222222","神奈川工場","神奈川県川崎市△-△-△",7152,"特高","需要抑制","422*3","P2Pネット","****3"]
[null,null,3,"0333333333333333333333","千葉工場","千葉県千葉市●-●-●",1782,"特高","電源（自家発等）","403*3","地球パワー","無"]
[null,null,4,"0344444444444444444444","埼玉工場","埼玉県さいたま市◎-◎-◎",4300,"特高","需要抑制","418*4","次世代パワー","無"]
[null,null,5,"0355555555555555555555","群馬工場","群馬県太田市□-□-□",5000,"特高","需要抑制","403*3","地球パワー","無"]
[null,null,6,"0366666666666666666666","栃木工場","栃木県宇都宮市▲-▲-▲",5250,"特高","需要抑制","403*3","地球パワー","無"]
[null,null,7,"0377777777777777777777","茨城工場","茨城県土浦市◆-◆-◆",16200,"特高","需要抑制","403*3","地球パワー","無"]
[null,null,8,"0388888888888888888888","静岡工場","静岡県沼津市×-×-×",1900,"特高","電源（自家発等）","403*3","地球パワー","無"]
[null,null,9,"0399999999999999999999","東京物流センター","東京都多摩市〇-×-△",8500,"高圧","需要抑制","403*3","地球パワー","無"]
[null,null,10,"0300000000000000000000","神奈川物流センター","神奈川県横浜市△-▲-△",23100,"高圧","需要抑制","403*3","地球パワー","無"]
[null,null,11,"0312121212121212121212","千葉物流センター","千葉県市川市●-◎-●",49400,"高圧","需要抑制","403*3","地球パワー","無"]
[null,null,12,"0312312312312312312312","埼玉製鉄工場","埼玉県鴻巣市〇-◎-〇",1114,"特高","需要抑制","403*3","地球パワー","無"]
[null,null,13,"0332132132132132132132","栃木VPP研究所","栃木県那須塩原市〇-●-●",49,"低圧","需要抑制","403*3","地球パワー","無"]

{"sheet":"使い方","index":1,"n_rows":89,"n_cols":15,"rows_kept":89,"cut":false,"hidden":false,"merged":[[48,0,50,14],[0,0,1,15],[4,0,5,14],[30,5,45,14],[53,0,53,14],[56,7,56,15],[54,7,54,15],[55,7,55,15],[59,0,59,7],[60,0,60,14],[55,0,55,4],[56,0,56,4],[54,5,54,6],[55,5,55,6],[56,5,56,6],[54,0,54,4],[61,0,61,5],[61,6,61,7],[62,0,62,5],[62,6,62,7],[62,8,62,14],[61,8,61,14],[63,0,63,5],[63,6,63,7],[64,0,64,5],[64,6,64,7],[63,8,63,14],[64,8,64,14],[75,0,75,14],[65,0,65,5],[65,6,65,7],[66,0,66,5],[66,6,66,7],[65,8,65,14],[66,8,66,14],[68,0,68,14],[69,0,69,14],[70,0,70,14],[71,0,71,14],[76,1,76,11],[88,0,89,14],[78,1,78,3],[78,4,78,6],[77,4,77,6],[77,7,77,8],[78,7,78,8],[77,1,77,3]]}
["需要家リスト・パターン入力支援ツールの使用方法"]
[]
[]
["①事前準備"]
["本マクロは，スキーマと共に使用します。下図の通り，本マクロとスキーマ（ファイル名：OCTO-W9-0232-0001.xsd）を同一フォルダに保存して下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["②起動ボタンの説明"]
[null,null,null,null,null,"本ツールは用途に合わせ，左図のボタンを押下して使用します。\n各ボタンの機能は，下記の通りです。\n・『ネガワットリスト需要家数変更』ボタン\n　需要抑制する需要家数を変更します。\n・『需要家リスト・パターンXML読込』ボタン\n　過去に作成した需要家リスト・パターンのXMLファイルを読み込みます。\n・『需要家リスト・パターンXML出力』ボタン\n　入力シートで作成した需要家リスト・パターンをXMLファイル形式で出力します。\n・『XMLファイル妥当性検証』ボタン\n　本ツール以外で作成した基準値計画のXMLをスキーマと照合してビジネスプロトコル標準規格に準拠しているか妥当性を検証します。なお，本ツールでXMLファイルの読み込みおよび出力を行った場合，スキーマによる妥当性を検証しているため，この操作は不要です。\n・『終了（上書保存）』ボタン\n　入力シートを上書き保存した後，本エクセルブックを閉じます。\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["③入力項目の説明"]
["本ツールは，『入力シート』の白色セルの所定の項目を入力した上で，XMLファイルに変換します。白色セルで『▲』マークが記されていない箇所は，必須入力項目です。具体的な入力方法は次項以降で説明します。"]
[]
[]
[]
["③－１　ファイル情報の入力"]
["ファイル情報の具体的な入力規則は下記の通りです。"]
["対象需要家リスト・パターン",null,null,null,null,"パターン④",null,"パターンは原則『パターン①』～『パターン⑩』を選択。"]
["供出可能量（kW)",null,null,null,null,85637,null,"当該需要家リスト・パターンの供出可能量を半角整数で入力。"]
["適用開始希望年月日",null,null,null,null,"20210418",null,"対象年月日は『YYYYMMDD』形式で半角数字8桁で入力。"]
[]
["③－２　基本情報の入力"]
["基本情報の具体的な入力規則は下記の通りです。"]
["基本情報"]
[null,null,null,null,null,null,"コード",null,"名称▲"]
["情報区分",null,null,null,null,null,"0232",null,"3次②需要家リスト・パターン"]
["提出先事業者",null,null,null,null,null,"10033",null,"東京電力パワーグリッド株式会社"]
["送信事業者",null,null,null,null,null,"80363",null,"グローバルエナジーアグリゲーター"]
["提出者（アグリゲーター用系統コード）",null,null,null,null,null,"3Y543",null,"グローバルエナジーアグリゲーター"]
["運用モード",null,null,null,null,null,"通常"]
[]
["情報区分は，自動入力（W9_0232で三次②需要家リスト・パターンを意味します）。"]
["提出先事業者は，作成する基準値計画が対象するリソースにおける属地エリアの一般送配電事業者を入力。"]
["送信事業者は，送信事業者コードと事業者名称を入力。"]
["運用モードは，約定したリソースの基準値計画として需給調整市場システムに提出する場合，『通常』を選択。"]
[]
["③－３　ネガワットリストの入力"]
["ネガワットの具体的な入力規則は下記の通りです。"]
["ネガワットリスト"]
[null,"需要家情報",null,null,null,null,null,null,null,null,null,null,"小売電気事業者情報",null,"他需要抑制契約の状況"]
["NO","供給地点特定番号",null,null,"需要家名称",null,null,"所在地",null,"契約電力(kW)","電圧区分","供出方法","小売電気\n事業者\nコード","小売電気\n事業者\n名称▲","類型Ⅰ②\n需要抑制BGコード"]
[1,"0311111111111111111111",null,null,"東京工場",null,null,"東京都大田区〇-〇-〇",null,5856,"特高","需要抑制","LA2*3","P2Pネット","****3"]
[]
["供給地点特定番号は，需要家を一意に特定する22桁の数字を入力。"]
["需要家名称は，需要家の名称を50文字以内で入力。"]
["所在地は需要家の住所を50文字以内で入力。"]
["契約電力(kW)は，需要家の契約電力(kW)を半角整数で入力。"]
["電圧区分は，需要家の供給電圧区分を『特高』，『高圧』，『低圧』から選択。"]
["供出方法は，需要家の調整力供出方法を『需要抑制』，『電源（自家発等）』から選択。"]
["小売電気事業者コードは需要リソースに電気を供給している小売電気事業者の事業者コードを半角英数字5桁で入力。"]
["小売電気事業者名称は，需要リソースに電気を供給している小売電気事業者の名称を50文字以内で任意入力。"]
["類型Ⅰ②需要抑制BGコードは，需要家が類型Ⅰ②需要抑制契約を締結している場合，その需要抑制BGコードを半角英数字5桁で入力。類型Ⅰ②需要抑制契約を締結していない場合は，『無』と入力。"]

{"sheet":"Posiwatt_Sheet","index":2,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,2,0,13],[1,3,1,10],[1,11,1,13]]}
[null,null,"ポジワットリスト"]
[null,null,null,"発電所情報",null,null,null,null,null,null,null,"発電販売計画情報"]
[null,null,"NO","受電地点特定番号","発電所名称","所在地","最大受電電力(kW)","電圧区分","電源の種別","発電方式","火力燃料種別","所属発電\nBGコード","所属発電BG名称▲","発電計画用\n系統コード"]

{"sheet":"Add_Resource_Style","index":3,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":true,"merged":[[14,2,14,11],[20,2,20,13],[21,3,21,10],[21,11,21,13],[15,3,15,8],[15,9,15,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ネガワットリスト"]
[null,null,null,"需要家情報",null,null,null,null,null,"所属需要BG情報",null,"他需要抑制契約の状況"]
[null,null,"NO","供給地点特定番号","需要家名称","所在地","契約電力(kW)","電圧区分","供出方法","小売電気事業者コード","小売電気事業者名称▲","類型Ⅰ②\n需要抑制BGコード"]
[null,null,1]
[]
[]
[null,null,"ポジワットリスト"]
[null,null,null,"発電所情報",null,null,null,null,null,null,null,"発電販売計画情報"]
[null,null,"NO","受電地点特定番号","発電所名称","所在地","最大受電電力(kW)","電圧区分","電源の種別","発電方式","火力燃料種別","所属発電\nBGコード","所属発電BG名称▲","発電計画用\n系統コード"]
[null,null,1]

{"sheet":"Input_Sheet (予備)","index":4,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,0,0,12],[5,3,5,8],[6,5,6,8],[7,5,7,8],[8,5,8,8],[7,10,7,11],[8,10,8,11],[15,3,15,8],[15,9,15,10],[32,2,32,13],[33,3,33,10],[33,11,33,13],[9,10,9,11],[14,2,14,11],[2,6,2,11],[3,6,3,11],[4,6,4,11],[5,9,5,11],[6,10,6,11],[10,5,10,8],[9,5,9,8]]}
["三次②需要家リスト・パターン入力支援ツール"]
[]
[null,null,null,"対象需要家リスト・パターン","パターン④","読込ファイル名","C:\\Users\\T1202480\\Desktop\\20210405_07_12_3Y543_04.xml",null,null,null,null,null,null,null,"需要家数"]
[null,null,null,"最大可能供出電力（kW)","85637","出力先","C:\\Users\\T1202480\\Desktop",null,null,null,null,null,null,null,13]
[null,null,null,"適用開始希望年月日","20210415","Zip.exeのフルパス","C:\\Program Files (x86)\\Lhaplus\\Lhaplus.exe",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,"XMLファイル名",{"$f":"K8&\"_\"&K9&\"_\"&K10&\".xml\"","v":"20210415_3Y543_04.xml"}]
[null,null,null,"情報区分","0210","3次②需要家リスト・パターン",null,null,null,"対象時期の開始日",{"$f":"E5","v":"20210415"}]
[null,null,null,"提出先事業者","10033","東京電力パワーグリッド株式会社",null,null,null,"系統コード",{"$f":"E11","v":"3Y543"}]
[null,null,null,"送信事業者","80363","グローバルエナジーアグリゲーター",null,null,null,"対象需要家パターン",{"$f":"IF(E3=\"パターン①\",\"01\",IF(E3=\"パターン②\",\"02\",IF(E3=\"パターン③\",\"03\",IF(E3=\"パターン④\",\"04\",IF(E3=\"パターン⑤\",\"05\",IF(E3=\"パターン⑥\",\"06\",IF(E3=\"パターン⑦\",\"07\",IF(E3=\"パターン⑧\",\"08\",IF(E3=\"パターン⑨\",\"09\",IF(E3=\"パターン⑩\",\"10\",IF( E3=\"パターン⑪\",\"11\",IF(E3=\"パターン⑫\",\"12\",IF(E3=\"パターン⑬\",\"13\",IF(E3=\"パターン⑭\",\"14\",IF(E3=\"パターン⑮\",\"15\",IF(E3=\"パターン⑯\",\"16\",IF(E3=\"パターン⑰\",\"17\",IF(E3=\"パターン⑱\",\"18\",IF(E3=\"パターン⑲\",\"19\",IF(E3=\"パターン⑳\",\"20\"))))))))))))))))))))","v":"04"}]
[null,null,null,"提出者","3Y543","グローバルエナジーアグリゲーター"]
[null,null,null,"運用モード","通常"]
[]
[]
[null,null,"ネガワットリスト"]
[null,null,null,"需要家情報",null,null,null,null,null,"所属需要BG情報",null,"他需要抑制契約の状況"]
[null,null,"NO","供給地点特定番号","需要家名称","所在地","契約電力(kW)","電圧区分","供出方法","所属需要BGコード","所属需要BG名称▲","類型Ⅰ②\n需要抑制BGコード"]
[null,null,1,"031011206079919920****","武蔵野研究開発センタ","東京都武蔵野市緑町*-**-*",5856,"特高","需要抑制","LA2*3","P2Pネット","****3"]
[null,null,2,"031011207059914120****","厚木研究開発センタ","神奈川県厚木市森の里若宮*-**-*",7152,"特高","需要抑制","LA2*3","P2Pネット","****3"]
[null,null,3,"031011206079940520****","○○クリーンセンター","東京都武蔵野市緑町*-**-*",1782,"特高","電源（自家発等）","LB3*3","地球パワー","無"]
[null,null,4,"031011201019915221****","××株式会社　日光工場","栃木県宇都宮市白沢町*-**-*",4300,"特高","需要抑制","LC8*4","次世代パワー","無"]
[null,null,5,"031011208079974820****","××株式会社　豊富工場","山梨県中央市高部*-**-*",5000,"特高","需要抑制","LB3*3","地球パワー","無"]
[null,null,6,"031011202059996120****","××株式会社　群馬工場","群馬県伊勢崎市長沼町*-**-*",5250,"特高","需要抑制","LB3*3","地球パワー","無"]
[null,null,7,"031011207089950420****","△△株式会社　倉見工場","神奈川県高座郡寒川町*-**-*",16200,"特高","需要抑制","LB3*3","地球パワー","無"]
[null,null,8,"031011209039934020****","○○大学研究所","静岡県三島市谷田*-**-*",1900,"特高","電源（自家発等）","LB3*3","地球パワー","無"]
[null,null,9,"031011209039934120****","●●株式会社　三島工場","静岡県三島市*-**-*",8500,"高圧","需要抑制","LB3*3","地球パワー","無"]
[null,null,10,"031011207069922720****","▲▲株式会社　追浜工場","神奈川県横須賀市夏島町*-**-*",23100,"高圧","需要抑制","LB3*3","地球パワー","無"]
[null,null,11,"031011201079973121****","▲▲株式会社　栃木工場","栃木県河内郡上三川町上蒲生*-**-*",49400,"高圧","需要抑制","LB3*3","地球パワー","無"]
[null,null,12,"031011200139975026****","◎◎株式会社　東京物流センター　","東京都大田区東海*-**-*",1114,"特高","需要抑制","LB3*3","地球パワー","無"]
[null,null,13,"030011100190030402****","□□コンビニエンスストア","東京都葛飾区鎌倉*-**-*",49,"低圧","需要抑制","LB3*3","地球パワー","無"]
[]
[]
[null,null,"ポジワットリスト"]
[null,null,null,"発電所情報",null,null,null,null,null,null,null,"発電販売計画情報"]
[null,null,"NO","受電地点特定番号","発電所名称","所在地","最大受電電力(kW)","電圧区分","電源の種別","発電方式","火力燃料種別","所属発電\nBGコード","所属発電BG名称▲","発電計画用\n系統コード"]
[null,null,1,"031012200010010009****","○○クリーンセンター","東京都武蔵野市緑町*-**-*",800,"特高","火力","コンバインドサイクル","LNG","GB8*3","〇〇エナジー","3**43"]
[null,null,2,"031012200019990229****","▲▲清掃工場","東京都八王子市北野町*-**-*",750,"特高","火力","コンバインドサイクル","LNG","GA7*3","清掃組合グループ","3**54"]
[null,null,3,"031012200019998029****","■■区清掃工場","東京都大田区東海*-**-*",430,"特高","火力","コンバインドサイクル","LNG","GA7*3","清掃組合グループ","3**68"]
[null,null,4,"031012200029911529****","●●区清掃組合","東京都港区虎ノ門*-**-*",680,"特高","火力","コンバインドサイクル","LNG","GA7*3","清掃組合グループ","3**53"]
[null,null,5,"031012200029911929****","□□市クリーンセンター","千葉県船橋市日の出*-**-*",960,"高圧","火力","コンバインドサイクル","LNG","GB8*3","〇〇エナジー","3**57"]
[null,null,6,"031012200050160401****","△△サステナブルエナジー研究所","神奈川県横須賀市夏島町*-**-*",80,"高圧","蓄電池","その他","その他","GL5*3","未来発電グループ","3**83"]