{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["入力シート","使い方","Add_Plan_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":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[8,5,8,8],[8,10,8,12],[0,3,0,5],[0,6,1,12],[6,5,6,8],[6,10,6,12],[7,5,7,8],[7,10,7,12],[2,6,2,12],[3,6,3,12],[5,3,5,8],[5,9,5,12],[9,10,9,12],[10,5,10,8],[58,0,63,0],[13,3,14,3],[15,3,18,3],[9,5,9,8],[13,4,13,10],[64,0,69,0],[70,1,70,2],[20,0,27,0],[28,0,33,0],[34,0,39,0],[40,0,45,0],[46,0,51,0],[52,0,57,0]]}
[null,null,null,"三次調整力②基準値計画入力支援ツール",null,null,"【重要】本ツールは，三次②基準値計画受等領業務ビジネスプロトコル標準規格のパブリックコメント前に作成したため，規格が変更となる可能性があります。本ツールで作成したXMLファイルを需給調整市場システムへ提出した場合，未提出扱いとします。"]
[]
[null,null,null,"対象年月日","20210405","読込ファイル名","C:\\Users\\T1202480\\Desktop\\XML\\W9_0132_20210405_07_3Y5ZZ.xml"]
[null,null,null,"対象商品ブロック","ブロック②","出力先","C:\\Users\\T1202480\\Desktop"]
[null,null,null,"対象需要家リスト・パターン","パターン④"]
[null,null,null,"基本情報",null,null,null,null,null,"出力ファイル名情報"]
[null,null,null,null,"コード","名称▲",null,null,null,"XMLファイル名",{"$f":"\"W9_0132_\"&K8&\"_\"&K9&\"_\"&K10&\".xml\"","v":"W9_0132_20210405_07_3Y5ZZ.xml"}]
[null,null,null,"情報区分","0132","三次調整力 ②基準値計画",null,null,null,"対象時期の開始日",{"$f":"E3","v":"20210405"}]
[null,null,null,"提出先事業者","10033","東京電力パワーグリッド株式会社",null,null,null,"約定対象開始コマ番号","07"]
[null,null,null,"送信事業者","80363","グローバルエナジーアグリゲーター",null,null,null,"アグリゲータ用系統コード",{"$f":"E11","v":"3Y5ZZ"}]
[null,null,null,"提出者（アグリゲータ用系統コード）","3Y5ZZ","グローバルエナジーアグリゲーター"]
[null,null,null,"運用モード","通常"]
[]
[null,null,null,"合計基準値","基準値内訳"]
[null,null,null,null,"需要ＢＧ1","需要BG2","需要BG3","需要BG4","需要BG5","需要BG6","需要BG7"]
[null,null,null,"合計基準値＝\nΣ基準値内訳","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード"]
[null,null,null,null,"LA393","LB643","LC543","LD773","LE433","LF783","LG893"]
[null,null,null,null,"需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲"]
[null,null,null,null,"関東でんき","東京みらいエナジー","エコネットライフ","センターアイ・パワー","サスティナブル・ライフ","OKでんき","P2Pコンソーシアム"]
["対象ブロック","#","時間帯","合計基準値(kWh)","基準値(kWh)","基準値(kWh)","基準値(kWh)","基準値(kWh)","基準値(kWh)","基準値(kWh)","基準値(kWh)"]
["ブロック①",47,"23:00～23:30"]
[null,48,"23:30～24:00"]
[null,"01","0:00～0:30"]
[null,"02","0:30～1:00"]
[null,"03","1:00～1:30"]
[null,"04","1:30～2:00"]
[null,"05","2:00～2:30",{"$f":"SUM(E27:K27)","v":7470},3800,123,543,463,1001,892,648]
[null,"06","2:30～3:00",{"$f":"SUM(E28:K28)","v":7390},3650,154,556,458,1003,873,696]
["ブロック②","07","3:00～3:30",{"$f":"SUM(E29:K29)","v":7009},3250,165,559,493,1005,882,655]
[null,"08","3:30～4:00",{"$f":"SUM(E30:K30)","v":7213},3250,189,585,474,1160,877,678]
[null,"09","4:00～4:30",{"$f":"SUM(E31:K31)","v":7299},3250,256,575,454,1220,855,689]
[null,10,"4:30～5:00",{"$f":"SUM(E32:K32)","v":7489},3550,265,569,463,1140,846,656]
[null,11,"5:00～5:30",{"$f":"SUM(E33:K33)","v":7572},3560,264,565,489,1211,825,658]
[null,12,"5:30～6:00",{"$f":"SUM(E34:K34)","v":7643},3650,289,535,414,1265,865,625]
["ブロック③",13,"6:00～6:30"]
[null,14,"6:30～7:00"]
[null,15,"7:00～7:30"]
[null,16,"7:30～8:00"]
[null,17,"8:00～8:30"]
[null,18,"8:30～9:00"]
["ブロック④",19,"9:00～9:30"]
[null,20,"9:30～10:00"]
[null,21,"10:00～10:30"]
[null,22,"10:30～11:00"]
[null,23,"11:00～11:30"]
[null,24,"11:30～12:00"]
["ブロック⑤",25,"12:00～12:30"]
[null,26,"12:30～13:00"]
[null,27,"13:00～13:30"]
[null,28,"13:30～14:00"]
[null,29,"14:00～14:30"]
[null,30,"14:30～15:00"]
["ブロック⑥",31,"15:00～15:30"]
[null,32,"15:30～16:00"]
[null,33,"16:00～16:30"]
[null,34,"16:30～17:00"]
[null,35,"17:00～17:30"]
[null,36,"17:30～18:00"]
["ブロック⑦",37,"18:00～18:30"]
[null,38,"18:30～19:00"]
[null,39,"19:00～19:30"]
[null,40,"19:30～20:00"]
[null,41,"20:00～20:30"]
[null,42,"20:30～21:00"]
["ブロック⑧",43,"21:00～21:30"]
[null,44,"21:30～22:00"]
[null,45,"22:00～22:30"]
[null,46,"22:30～23:00"]
[null,47,"23:00～23:30"]
[null,48,"23:30～24:00"]
[null,"対象約定ブロック合計",null,{"$f":"SUM(D29:D34)","v":44225},20510,1428,3388,2787,7001,5150,3961]

{"sheet":"使い方","index":1,"n_rows":97,"n_cols":11,"rows_kept":97,"cut":false,"hidden":false,"merged":[[66,8,66,12],[67,8,67,12],[62,8,62,12],[61,0,61,12],[54,0,54,7],[60,0,60,7],[67,0,67,5],[66,6,66,7],[67,6,67,7],[57,4,57,5],[57,6,57,13],[66,0,66,5],[62,0,62,5],[63,0,63,5],[57,0,57,3],[64,0,64,5],[4,0,5,13],[49,0,51,13],[0,0,1,10],[30,5,46,13],[56,0,56,3],[55,0,55,3],[55,4,55,5],[56,4,56,5],[56,6,56,13],[55,6,55,13],[65,0,65,5],[62,6,62,7],[63,6,63,7],[64,6,64,7],[65,6,65,7],[63,8,63,12],[64,8,64,12],[65,8,65,12],[94,3,94,4],[83,3,83,4],[70,0,70,13],[82,0,82,1],[83,0,90,1],[76,0,81,4],[76,5,77,7],[78,5,81,7],[82,5,82,7],[83,5,83,7],[84,5,84,7],[85,5,85,7],[86,8,86,9],[92,5,92,7],[93,5,93,7],[91,0,96,1],[82,3,82,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,3,88,4],[95,3,95,4],[96,3,96,4],[89,3,89,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[94,5,94,7],[95,5,95,7],[96,5,96,7],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[80,8,80,9],[86,5,86,7],[87,5,87,7],[88,5,88,7],[89,5,89,7],[90,5,90,7],[91,5,91,7],[84,8,84,9],[85,8,85,9],[96,8,96,9],[78,10,79,13],[80,10,81,13],[89,10,96,13],[87,8,87,9],[88,8,88,9],[89,8,89,9],[90,8,90,9],[91,8,91,9],[92,8,92,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[93,8,93,9],[94,8,94,9],[95,8,95,9]]}
["基準値計画入力支援ツールの使用方法"]
[]
[]
["①事前準備"]
["本マクロは，スキーマと共に使用します。下図の通り，本マクロとスキーマ（ファイル名：OCTO-W9-0132-0001.xsd)を同一フォルダに保存して下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["②起動ボタンの説明"]
[null,null,null,null,null,"本ツールは用途に合わせ，左図のボタンを押下して使用します。\n各ボタンの機能は，下記の通りです。\n・『対象商品ブロック変更』ボタン\n　作成する基準値計画の対象となる商品ブロックを選択します。\n・『需要BG数変更』ボタン\n　作成する基準値計画の内訳となる需要BG数を変更します。\n・『基準値XML読込』ボタン\n　過去に作成した基準値計画のXMLファイルを読み込みます。\n・『基準値XML出力』ボタン\n　入力シートで作成した基準値計画をXMLファイル形式で出力します。\n・『XMLファイル妥当性検証』ボタン\n　本ツール以外で作成した基準値計画のXMLをスキーマと照合してビジネスプロトコル標準規格に準拠しているか妥当性を検証します。なお，本ツールでXMLファイルの読み込みおよび出力を行った場合，スキーマによる妥当性を検証しているため，この操作は不要です。\n・『終了（上書保存）』ボタン\n　入力シートを上書き保存した後，本エクセルブックを閉じます。\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["③入力項目の説明"]
["本ツールは，『入力シート』の白色セルの所定の項目を入力した上で，XMLファイルに変換します。白色セルで『▲』マークが記されていない箇所は，必須入力項目です。具体的な入力方法は次項以降で説明します。"]
[]
[]
[]
["③－１　ファイル情報の入力"]
["ファイル情報の具体的な入力規則は下記の通りです。"]
["対象年月日",null,null,null,"20210405",null,"対象年月日は『YYYYMMDD』形式で半角数字8桁で入力。"]
["対象商品ブロック",null,null,null,"ブロック②",null,"対象商品ブロックは，『対象商品ブロック変更』ボタンを押下して選択。"]
["対象需要家リスト・パターン",null,null,null,"パターン④",null,"パターンは原則『パターン①』～『パターン⑩』を選択。"]
[]
["③－２　基本情報の入力"]
["基本情報の具体的な入力規則は下記の通りです。"]
["基本情報"]
[null,null,null,null,null,null,"コード",null,"名称▲"]
["情報区分",null,null,null,null,null,"0132",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_0132で三次②基準値計画を意味します）。"]
["提出先事業者は，作成する基準値計画が対象するリソースにおける属地エリアの一般送配電事業者を入力。"]
["送信事業者は，送信事業者コードと事業者名称を入力。"]
["運用モードは，約定したリソースの基準値計画として需給調整市場システムに提出する場合，『通常』を選択。"]
[]
["③－３　基準値の入力"]
["基準値の具体的な入力規則は下記の通りです。"]
[null,null,null,null,null,"アグリゲーター\n合計基準値",null,null,"基準値内訳"]
[null,null,null,null,null,null,null,null,"需要ＢＧ1"]
[null,null,null,null,null,"アグリゲーター\n合計＝\nΣ需要基準値内訳",null,null,"需要BGコード",null,"需要BGコードは，リソースが所属する需要BGのコードを半角英数字5桁で入力。"]
[null,null,null,null,null,null,null,null,"LA393"]
[null,null,null,null,null,null,null,null,"需要BG名称▲",null,"需要BG名称は，リソースが所属する需要BGの名称を50文字以内で任意入力。"]
[null,null,null,null,null,null,null,null,"関東でんき"]
["対象ブロック",null,"#","時間帯",null,"合計基準値(kWh)",null,null,"BG基準値(kWh)"]
["ブロック①",null,47,"23:00～23:30"]
[null,null,48,"23:30～24:00"]
[null,null,"01","0:00～0:30"]
[null,null,"02","0:30～1:00"]
[null,null,"03","1:00～1:30"]
[null,null,"04","1:30～2:00"]
[null,null,"05","2:00～2:30",null,3800,null,null,3800,null,"BG基準値(kWh）は，リソースが需要抑制を実施しなかった場合の接続対象電力量(kWh)を需要BGかつ30分コマ単位に半角整数で入力。"]
[null,null,"06","2:30～3:00",null,3650,null,null,3650]
["ブロック②",null,"07","3:00～3:30",null,3250,null,null,3250]
[null,null,"08","3:30～4:00",null,3250,null,null,3250]
[null,null,"09","4:00～4:30",null,3250,null,null,3250]
[null,null,10,"4:30～5:00",null,3550,null,null,3550]
[null,null,11,"5:00～5:30",null,3560,null,null,3560]
[null,null,12,"5:30～6:00",null,3650,null,null,3650]

{"sheet":"Add_Plan_Style","index":2,"n_rows":71,"n_cols":2,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"基準値内訳"]
[null,"需要ＢＧ1"]
[null,"需要BGコード"]
[]
[null,"需要BG名称▲"]
[]
[null,"基準値(kWh)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUM(B29:B34)","v":0}]

{"sheet":"Input_Sheet (予備)","index":3,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":true,"merged":[[52,0,57,0],[58,0,63,0],[64,0,69,0],[70,1,70,2],[15,3,18,3],[20,0,27,0],[28,0,33,0],[34,0,39,0],[40,0,45,0],[46,0,51,0],[13,3,14,3],[13,4,13,12],[6,5,6,8],[6,10,6,12],[7,5,7,8],[7,10,7,12],[8,5,8,8],[8,10,8,12],[9,5,9,8],[9,10,9,12],[10,5,10,8],[10,10,10,12],[11,10,11,12],[0,0,0,12],[2,6,2,12],[3,6,3,12],[4,6,4,12],[5,3,5,8],[5,9,5,12]]}
["三次②基準値計画入力支援ツール"]
[null,null,null,"20k16o20I16K!"]
[null,null,null,"対象年月日","20210403","読込ファイル名","C:\\Users\\Desktop\\提出ファイル\\20210402_7_3Y**5_8.xml"]
[null,null,null,"対象商品ブロック","ブロック③","出力先","C:\\Users\\Desktop\\提出ファイル"]
[null,null,null,"対象需要家パターン","パターン⑮","Zip.exeのフルパス","C:\\Program Files (x86)\\Lhaplus\\Lhaplus.exe"]
[null,null,null,"基本情報",null,null,null,null,null,"出力ファイル名情報"]
[null,null,null,null,"コード","名称▲",null,null,null,"XMLファイル名",{"$f":"K8&\"_\"&K9&\"_\"&K10&\"_\"&K11&\"_\"&K12&\".xml\"","v":"20210403_13_18_3Y543_15.xml"}]
[null,null,null,"情報区分","0110","3次②基準値計画",null,null,null,"対象時期の開始日",{"$f":"E3","v":"20210403"}]
[null,null,null,"提出先事業者","10033","東京電力パワーグリッド株式会社",null,null,null,"約定対象開始コマ","13"]
[null,null,null,"送信事業者","80363","グローバルエナジーアグリゲーター",null,null,null,"約定対象終了コマ","18"]
[null,null,null,"提出者","3Y543","グローバルエナジーアグリゲーター",null,null,null,"系統コード",{"$f":"E11","v":"3Y543"}]
[null,null,null,"運用モード","通常",null,null,null,null,"対象需要家パターン",{"$f":"IF(E5=\"パターン①\",\"01\",IF(E5=\"パターン②\",\"02\",IF(E5=\"パターン③\",\"03\",IF(E5=\"パターン④\",\"04\",IF(E5=\"パターン⑤\",\"05\",IF(E5=\"パターン⑥\",\"06\",IF(E5=\"パターン⑦\",\"07\",IF(E5=\"パターン⑧\",\"08\",IF(E5=\"パターン⑨\",\"09\",IF(E5=\"パターン⑩\",\"10\",IF( E5=\"パターン⑪\",\"11\",IF(E5=\"パターン⑫\",\"12\",IF(E5=\"パターン⑬\",\"13\",IF(E5=\"パターン⑭\",\"14\",IF(E5=\"パターン⑮\",\"15\",IF(E5=\"パターン⑯\",\"16\",IF(E5=\"パターン⑰\",\"17\",IF(E5=\"パターン⑱\",\"18\",IF(E5=\"パターン⑲\",\"19\",IF(E5=\"パターン⑳\",\"20\"))))))))))))))))))))","v":"15"}]
[]
[null,null,null,"アグリゲーター合計基準値","基準値内訳"]
[null,null,null,null,"需要ＢＧ1","需要BG2","需要BG3","需要BG4","需要BG5","需要BG6","需要BG7","需要BG8","需要BG9"]
[null,null,null,"アグリゲーター合計＝\nΣ需要基準値内訳","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード","需要BGコード"]
[null,null,null,null,"LA393","LB643","LC543","LD773","LE433","LF783","LG893"]
[null,null,null,null,"需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲","需要BG名称▲"]
[null,null,null,null,"飛田新地","信太山","黄金町","伊勢崎","太田","西川口","中洲"]
["対象ブロック","#","時間帯","合計基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)","BG基準値(kWh)"]
["ブロック①",47,"23:00～23:30"]
[null,48,"23:30～24:00"]
[null,"01","0:00～0:30"]
[null,"02","0:30～1:00"]
[null,"03","1:00～1:30"]
[null,"04","1:30～2:00"]
[null,"05","2:00～2:30"]
[null,"06","2:30～3:00"]
["ブロック②","07","3:00～3:30"]
[null,"08","3:30～4:00"]
[null,"09","4:00～4:30"]
[null,10,"4:30～5:00"]
[null,11,"5:00～5:30",{"$f":"SUM(E33:M33)","v":3676},6,123,543,463,1001,892,648]
[null,12,"5:30～6:00",3746,6,154,556,458,1003,873,696]
["ブロック③",13,"6:00～6:30",3765,6,165,559,493,1005,882,655]
[null,14,"6:30～7:00",3969,6,189,585,474,1160,877,678]
[null,15,"7:00～7:30",4055,6,256,575,454,1220,855,689]
[null,16,"7:30～8:00",3945,6,265,569,463,1140,846,656]
[null,17,"8:00～8:30",4018,6,264,565,489,1211,825,658]
[null,18,"8:30～9:00",3999,6,289,535,414,1265,865,625]
["ブロック④",19,"9:00～9:30"]
[null,20,"9:30～10:00"]
[null,21,"10:00～10:30"]
[null,22,"10:30～11:00"]
[null,23,"11:00～11:30"]
[null,24,"11:30～12:00"]
["ブロック⑤",25,"12:00～12:30"]
[null,26,"12:30～13:00"]
[null,27,"13:00～13:30"]
[null,28,"13:30～14:00"]
[null,29,"14:00～14:30"]
[null,30,"14:30～15:00"]
["ブロック⑥",31,"15:00～15:30"]
[null,32,"15:30～16:00"]
[null,33,"16:00～16:30"]
[null,34,"16:30～17:00"]
[null,35,"17:00～17:30"]
[null,36,"17:30～18:00"]
["ブロック⑦",37,"18:00～18:30"]
[null,38,"18:30～19:00"]
[null,39,"19:00～19:30"]
[null,40,"19:30～20:00"]
[null,41,"20:00～20:30"]
[null,42,"20:30～21:00"]
["ブロック⑧",43,"21:00～21:30"]
[null,44,"21:30～22:00"]
[null,45,"22:00～22:30"]
[null,46,"22:30～23:00"]
[null,47,"23:00～23:30"]
[null,48,"23:30～24:00"]
[null,"対象約定ブロック合計",null,{"$f":"SUM(D35:D40)","v":23751},36,1428,3388,2787,7001,5150,3961,0,0]