{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["シミュレータ","従量電灯","動力","マスタ"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":24,"n_cols":38,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,37,18,41],[13,37,13,41],[14,37,14,41],[15,37,15,41],[16,37,16,41],[17,37,17,41],[8,37,8,41],[9,37,9,41],[10,37,10,41],[11,37,11,41],[12,37,12,41],[5,37,5,41],[6,37,6,41],[7,37,7,41],[14,2,14,8],[14,9,14,11],[13,16,13,18],[5,19,5,24],[5,25,5,30],[5,31,5,33],[5,34,5,36],[6,16,6,18],[7,16,7,18],[6,25,6,30],[6,31,6,33],[6,34,6,36],[7,25,7,30],[2,2,2,11],[5,2,5,11],[11,2,11,11],[8,2,8,8],[8,9,8,11],[8,16,8,18],[9,16,9,18],[10,16,10,18],[11,16,11,18],[12,16,12,18],[6,19,6,24],[7,19,7,24],[9,19,9,24],[11,19,11,24],[13,19,13,24],[12,19,12,24],[10,19,10,24],[14,16,14,18],[15,16,15,18],[16,16,16,18],[17,16,17,18],[18,16,18,18],[7,31,7,33],[7,34,7,36],[8,19,8,24],[8,25,8,30],[8,31,8,33],[8,34,8,36],[9,25,9,30],[9,31,9,33],[9,34,9,36],[10,25,10,30],[10,31,10,33],[10,34,10,36],[11,34,11,36],[18,19,18,24],[18,25,18,30],[18,31,18,33],[18,34,18,36],[15,19,15,24],[15,25,15,30],[15,31,15,33],[15,34,15,36],[16,19,16,24],[16,25,16,30],[16,31,16,33],[16,34,16,36],[12,25,12,30],[12,31,12,33],[12,34,12,36],[0,16,1,29],[5,16,5,18],[2,16,3,36],[17,19,17,24],[17,25,17,30],[17,31,17,33],[17,34,17,36],[13,25,13,30],[13,31,13,33],[13,34,13,36],[14,19,14,24],[14,25,14,30],[14,31,14,33],[14,34,14,36],[11,25,11,30],[11,31,11,33]]}
[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,null,null,null,null,null,null,null,null,null,"by"]
[null,null,"東北電力",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"AIでんきにお切り替えいただくと、電気代が\"&TEXT(AF19*-1,\"0,000\")&\"円お得になる可能性があります！\"","v":"AIでんきにお切り替えいただくと、電気代が0,000円お得になる可能性があります！"}]
[]
[null,"2.電力プラン"]
[null,null,"従量電灯B(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,"月",null,null,"いままでの電気代",null,null,null,null,null,"AIでんきの電気代",null,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":"マスタ!C51","v":"1月"},null,null,{"$f":"ROUND(マスタ!H69,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P69,0)","v":0},null,null,null,null,null,{"$f":"Z7-T7","v":0},null,null,{"$f":"マスタ!F51","v":0}]
[null,{"$f":"\"3.ご契約電力\"&IF(C6=\"低圧電力(KW)\",\"(KW)\",IF(RIGHT(C6,3)=\"(A)\",\"(A)\",\"(kVA)\"))","v":"3.ご契約電力(A)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C52","v":"2月"},null,null,{"$f":"ROUND(マスタ!H70,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P70,0)","v":0},null,null,null,null,null,{"$f":"Z8-T8","v":0},null,null,{"$f":"マスタ!F52","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(RIGHT(B8,3)=\"(A)\",\"(A)\",IF(RIGHT(B8,4)=\"(KW)\",\"(KW)\",\"(kVA)\"))","v":"(A)"},null,null,null,null,null,null,{"$f":"マスタ!C53","v":"3月"},null,null,{"$f":"ROUND(マスタ!H71,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P71,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F53","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C54","v":"4月"},null,null,{"$f":"ROUND(マスタ!H72,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P72,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F54","v":0}]
[null,"4.対象月",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C55","v":"5月"},null,null,{"$f":"ROUND(マスタ!H73,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P73,0)","v":0},null,null,null,null,null,{"$f":"Z11-T11","v":0},null,null,{"$f":"マスタ!F55","v":0}]
[null,null,"4月",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C56","v":"6月"},null,null,{"$f":"ROUND(マスタ!H74,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P74,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F56","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C57","v":"7月"},null,null,{"$f":"ROUND(マスタ!H75,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P75,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F57","v":0}]
[null,"5.月間使用量",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C58","v":"8月"},null,null,{"$f":"ROUND(マスタ!H76,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P76,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F58","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C15=\"\",\"\",\"kWh\")","v":""},null,null,null,null,null,null,{"$f":"マスタ!C59","v":"9月"},null,null,{"$f":"ROUND(マスタ!H77,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P77,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C60","v":"10月"},null,null,{"$f":"ROUND(マスタ!H78,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P78,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C61","v":"11月"},null,null,{"$f":"ROUND(マスタ!H79,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P79,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F61","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"マスタ!C62","v":"12月"},null,null,{"$f":"ROUND(マスタ!H80,0)","v":0},null,null,null,null,null,{"$f":"ROUND(マスタ!P80,0)","v":0},null,null,null,null,null,0,null,null,{"$f":"マスタ!F62","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",null,null,{"$f":"SUM(T7:Y18)","v":0},null,null,null,null,null,{"$f":"SUM(Z7:AE18)","v":0},null,null,null,null,null,{"$f":"IF(AL19=\"\",Z19-T19,Z19-SUM(マスタ!D81:G81))","v":0},null,null,{"$f":"SUM(AI7:AK18)","v":0}]
[]
[null,null,"※","見積書の数値や名称を変更する場合は基本的にシュミレーターから変更してください。"]
[null,null,null,"低圧と従量でそれぞれ見積書フォーマットが異なりますので、電力プランをご確認の上ボタンを押してください。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"従量電灯","index":1,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,6,6,9],[5,6,5,8],[5,2,5,3],[28,7,28,16],[0,0,2,9],[0,16,0,18],[5,13,6,14],[7,13,7,14],[11,0,12,0],[11,2,11,5],[5,11,6,12],[7,0,7,1],[5,0,5,1],[6,0,6,1],[7,11,7,12],[6,2,6,4],[7,2,7,4],[7,6,7,8]]}
["電力切替　御見積書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-07-26"}]
[]
[]
["1. お客様情報",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,"A",null,{"$f":"O15","v":0},null,{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,9,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,0),VLOOKUP(シミュレータ!$C$3,マスタ!B21:R30,14,FALSE)))","v":25.9}]
[]
["2.ご使用実績（現状）",null,null,null,null,null,null,null,null,null,null,"4. 新料金資産"]
[null,null,null,null,null,null,null,null,null,null,null,"試算条件： ","力率85％　"]
["現料金単価","基本料金","従量料金",null,null,null,null,null,null,null,null,null,"再生可能エネルギー賦課金、燃料調整費は含まれておりません。"]
[null,{"$f":"H15/B15","v":{"$error":"#DIV/0!"}},{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,5,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,0),VLOOKUP(シミュレータ!$C$3,マスタ!B21:R30,14,FALSE)))","v":18.239999999999998},{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,6,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,0),VLOOKUP(シミュレータ!$C$3,マスタ!B21:R30,14,FALSE)))","v":24.87},{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,7,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,0),VLOOKUP(シミュレータ!$C$3,マスタ!B21:R30,14,FALSE)))","v":28.75},null,null,null,null,null,null,null,"金額はすべて税込（8％）で算定しています。"]
["年月","契約電力","1段階","2段階","3段階",null,"使用量合計","基本料金","従量料金","現電力料金",null,"年月","契約電力","使用電力量","基本料金","従量料金","新電力料金","削減額","削減率"]
["2017年04月",{"$f":"$G$8","v":0},{"$f":"マスタ!G54","v":0},{"$f":"マスタ!H54","v":0},{"$f":"マスタ!I54","v":0},null,{"$f":"SUMIF(C15:F15,\">=1\",C15:F15)","v":0},{"$f":"マスタ!C69","v":0},{"$f":"SUM(マスタ!D72:F72)","v":0},{"$f":"シミュレータ!T10","v":0},null,"2017年04月",{"$f":"B15","v":0},{"$f":"G15","v":0},{"$f":"マスタ!K72","v":0},{"$f":"SUM(マスタ!L69:N69)","v":0},{"$f":"シミュレータ!Z10","v":0},{"$f":"シミュレータ!AF10","v":0},{"$f":"R15/J15","v":{"$error":"#DIV/0!"}}]
["2017年05月",0,{"$f":"マスタ!G55","v":0},{"$f":"マスタ!H55","v":0},{"$f":"マスタ!I55","v":0},null,{"$f":"SUMIF(C16:F16,\">=1\",C16:F16)","v":0},{"$f":"マスタ!C70","v":0},{"$f":"SUM(マスタ!D73:F73)","v":0},{"$f":"シミュレータ!T11","v":0},null,"2017年05月",0,0,{"$f":"マスタ!K73","v":0},{"$f":"SUM(マスタ!L70:N70)","v":0},{"$f":"シミュレータ!Z11","v":0},{"$f":"シミュレータ!AF11","v":0},{"$f":"R16/J16","v":{"$error":"#DIV/0!"}}]
["2017年06月",0,{"$f":"マスタ!G56","v":0},{"$f":"マスタ!H56","v":0},{"$f":"マスタ!I56","v":0},null,0,{"$f":"マスタ!C71","v":0},{"$f":"SUM(マスタ!D74:F74)","v":0},{"$f":"シミュレータ!T12","v":0},null,"2017年06月",0,0,{"$f":"マスタ!K74","v":0},{"$f":"SUM(マスタ!L71:N71)","v":0},{"$f":"シミュレータ!Z12","v":0},{"$f":"シミュレータ!AF12","v":0},{"$error":"#DIV/0!"}]
["2017年07月",0,{"$f":"マスタ!G57","v":0},{"$f":"マスタ!H57","v":0},{"$f":"マスタ!I57","v":0},null,0,{"$f":"マスタ!C72","v":0},{"$f":"SUM(マスタ!D75:F75)","v":0},{"$f":"シミュレータ!T13","v":0},null,"2017年07月",0,0,{"$f":"マスタ!K75","v":0},{"$f":"SUM(マスタ!L72:N72)","v":0},{"$f":"シミュレータ!Z13","v":0},{"$f":"シミュレータ!AF13","v":0},{"$error":"#DIV/0!"}]
["2017年08月",0,{"$f":"マスタ!G58","v":0},{"$f":"マスタ!H58","v":0},{"$f":"マスタ!I58","v":0},null,0,{"$f":"マスタ!C73","v":0},{"$f":"SUM(マスタ!D76:F76)","v":0},{"$f":"シミュレータ!T14","v":0},null,"2017年08月",0,0,{"$f":"マスタ!K76","v":0},{"$f":"SUM(マスタ!L73:N73)","v":0},{"$f":"シミュレータ!Z14","v":0},{"$f":"シミュレータ!AF14","v":0},{"$error":"#DIV/0!"}]
["2017年09月",0,{"$f":"マスタ!G59","v":0},{"$f":"マスタ!H59","v":0},{"$f":"マスタ!I59","v":0},null,0,{"$f":"マスタ!C74","v":0},{"$f":"SUM(マスタ!D77:F77)","v":0},{"$f":"シミュレータ!T15","v":0},null,"2017年09月",0,0,{"$f":"マスタ!K77","v":0},{"$f":"SUM(マスタ!L74:N74)","v":0},{"$f":"シミュレータ!Z15","v":0},{"$f":"シミュレータ!AF15","v":0},{"$error":"#DIV/0!"}]
["2017年10月",0,{"$f":"マスタ!G60","v":0},{"$f":"マスタ!H60","v":0},{"$f":"マスタ!I60","v":0},null,0,{"$f":"マスタ!C75","v":0},{"$f":"SUM(マスタ!D78:F78)","v":0},{"$f":"シミュレータ!T16","v":0},null,"2017年10月",0,0,{"$f":"マスタ!K78","v":0},{"$f":"SUM(マスタ!L75:N75)","v":0},{"$f":"シミュレータ!Z16","v":0},{"$f":"シミュレータ!AF16","v":0},{"$error":"#DIV/0!"}]
["2017年11月",0,{"$f":"マスタ!G61","v":0},{"$f":"マスタ!H61","v":0},{"$f":"マスタ!I61","v":0},null,0,{"$f":"マスタ!C76","v":0},{"$f":"SUM(マスタ!D79:F79)","v":0},{"$f":"シミュレータ!T17","v":0},null,"2017年11月",0,0,{"$f":"マスタ!K79","v":0},{"$f":"SUM(マスタ!L76:N76)","v":0},{"$f":"シミュレータ!Z17","v":0},{"$f":"シミュレータ!AF17","v":0},{"$error":"#DIV/0!"}]
["2017年12月",0,{"$f":"マスタ!G62","v":0},{"$f":"マスタ!H62","v":0},{"$f":"マスタ!I62","v":0},null,0,{"$f":"マスタ!C77","v":0},{"$f":"SUM(マスタ!D80:F80)","v":0},{"$f":"シミュレータ!T18","v":0},null,"2017年12月",0,0,{"$f":"マスタ!K80","v":0},{"$f":"SUM(マスタ!L77:N77)","v":0},{"$f":"シミュレータ!Z18","v":0},{"$f":"シミュレータ!AF18","v":0},{"$error":"#DIV/0!"}]
["2017-01-01",0,{"$f":"マスタ!G51","v":0},{"$f":"マスタ!H51","v":0},{"$f":"マスタ!I51","v":0},null,0,{"$f":"マスタ!C69","v":0},{"$f":"SUM(マスタ!D69:F69)","v":0},{"$f":"シミュレータ!T7","v":0},null,"2017-01-01",0,0,{"$f":"マスタ!K69","v":0},{"$f":"SUM(マスタ!L69:N69)","v":0},{"$f":"シミュレータ!Z7","v":0},{"$f":"シミュレータ!AF7","v":0},{"$error":"#DIV/0!"}]
["2017-02-01",0,{"$f":"マスタ!G52","v":0},{"$f":"マスタ!H52","v":0},{"$f":"マスタ!I52","v":0},null,0,{"$f":"マスタ!C70","v":0},{"$f":"SUM(マスタ!D70:F70)","v":0},{"$f":"シミュレータ!T8","v":0},null,"2017-02-01",0,0,{"$f":"マスタ!K70","v":0},{"$f":"SUM(マスタ!L70:N70)","v":0},{"$f":"シミュレータ!Z8","v":0},{"$f":"シミュレータ!AF8","v":0},{"$error":"#DIV/0!"}]
["2017-03-01",0,{"$f":"マスタ!G53","v":0},{"$f":"マスタ!H53","v":0},{"$f":"マスタ!I53","v":0},null,0,{"$f":"マスタ!C71","v":0},{"$f":"SUM(マスタ!D71:F71)","v":0},{"$f":"シミュレータ!T9","v":0},null,"2017-03-01",0,0,{"$f":"マスタ!K71","v":0},{"$f":"SUM(マスタ!L71:N71)","v":0},{"$f":"シミュレータ!Z9","v":0},{"$f":"シミュレータ!AF9","v":0},{"$error":"#DIV/0!"}]
["合　計",null,{"$f":"SUM(C15:C26)","v":0},{"$f":"SUM(D15:D26)","v":0},0,0,0,0,0,0,null,"合　計",null,{"$f":"SUM(N15:N26)","v":0},{"$f":"SUM(O15:O26)","v":0},{"$f":"SUM(P15:P26)","v":0},{"$f":"SUM(Q15:Q26)","v":0},{"$f":"SUM(R15:R26)","v":0},{"$f":"R27/J27","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,"東京都港区元赤坂1-1-7オリエント赤坂モートサイドビル2F 株式会社パワー・オプティマイザー　TEL:03-4400-1796\n"]

{"sheet":"動力","index":2,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,15,4,18],[28,7,28,16],[0,0,2,9],[11,0,12,0],[11,2,11,5],[5,0,5,1],[5,2,5,3],[5,6,5,8],[5,13,5,14],[6,0,6,1],[6,2,6,4],[6,6,6,9],[7,0,7,1],[7,2,7,4],[7,11,7,12],[5,11,6,12],[0,16,0,18]]}
["電力切替　御見積書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2018-07-26"}]
[]
[]
["1. お客様情報",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,"kW","力率",0.85,null,{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,3,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,3,0),VLOOKUP(シミュレータ!$C$3,マスタ!B21:R30,14,FALSE)))","v":324},null,{"$f":"IF(G6=マスタ!B22,マスタ!Q22,IF(G6=マスタ!B5,マスタ!Q23,24))","v":24},{"$f":"IF(G6=マスタ!B22,マスタ!R22,IF(G6=マスタ!B5,マスタ!R23,IF(G6=マスタ!B21,マスタ!R21,22)))","v":22}]
[]
["2.ご使用実績（現状）",null,null,null,null,null,null,null,null,null,null,"4. 新料金資産"]
[null,null,null,null,null,null,null,null,null,null,null,"試算条件： ","力率",{"$f":"J8","v":0.85}]
["現料金単価","基本料金","従量料金",null,null,null,null,null,null,null,null,null,"再生可能エネルギー賦課金、燃料調整費は含まれておりません。"]
[null,{"$f":"マスタ!C69/B15","v":{"$error":"#DIV/0!"}},{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,6,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,0),VLOOKUP(シミュレータ!$C$3,マスタ!B21:R30,12,FALSE)))","v":24.87},{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,6,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,0),VLOOKUP(シミュレータ!$C$3,マスタ!B21:R30,13,FALSE)))","v":24.87},null,null,null,null,null,null,null,null,"金額はすべて税込（8％）で算定しています。"]
["年月","契約電力","夏季","他季",null,null,"使用量合計","基本料金","従量料金","現電力料金",null,"年月","契約電力","使用電力量","基本料金","従量料金","新電力料金","削減額","削減率"]
["2017年04月",{"$f":"$G$8","v":0},null,{"$f":"IF(シミュレータ!AL10=0,シミュレータ!AI10,シミュレータ!AL10)","v":0},null,null,{"$f":"SUM(C15:F15)","v":0},{"$f":"マスタ!C69","v":0},{"$f":"B15*D15","v":0},{"$f":"シミュレータ!T10","v":0},null,"2017年04月",{"$f":"B15","v":0},{"$f":"G15","v":0},{"$f":"マスタ!K72","v":0},{"$f":"SUM(マスタ!L69:N69)","v":0},{"$f":"シミュレータ!Z10","v":0},{"$f":"シミュレータ!AF10","v":0},{"$f":"R15/J15","v":{"$error":"#DIV/0!"}}]
["2017年05月",0,null,{"$f":"IF(シミュレータ!AL11=0,シミュレータ!AI11,シミュレータ!AL11)","v":0},null,null,{"$f":"SUM(C16:F16)","v":0},{"$f":"マスタ!C70","v":0},{"$f":"B16*D16","v":0},{"$f":"シミュレータ!T11","v":0},null,"2017年05月",0,0,{"$f":"マスタ!K73","v":0},{"$f":"SUM(マスタ!L70:N70)","v":0},{"$f":"シミュレータ!Z11","v":0},{"$f":"シミュレータ!AF11","v":0},{"$error":"#DIV/0!"}]
["2017年06月",0,null,{"$f":"IF(シミュレータ!AL12=0,シミュレータ!AI12,シミュレータ!AL12)","v":0},null,null,0,{"$f":"マスタ!C71","v":0},0,{"$f":"シミュレータ!T12","v":0},null,"2017年06月",0,0,{"$f":"マスタ!K74","v":0},{"$f":"SUM(マスタ!L71:N71)","v":0},{"$f":"シミュレータ!Z12","v":0},{"$f":"シミュレータ!AF12","v":0},{"$error":"#DIV/0!"}]
["2017年07月",0,{"$f":"IF(シミュレータ!AL13=0,シミュレータ!AI13,シミュレータ!AL13)","v":0},null,null,null,0,{"$f":"マスタ!C72","v":0},{"$f":"B18*C18","v":0},{"$f":"シミュレータ!T13","v":0},null,"2017年07月",0,0,{"$f":"マスタ!K75","v":0},{"$f":"SUM(マスタ!L72:N72)","v":0},{"$f":"シミュレータ!Z13","v":0},{"$f":"シミュレータ!AF13","v":0},{"$error":"#DIV/0!"}]
["2017年08月",0,{"$f":"IF(シミュレータ!AL14=0,シミュレータ!AI14,シミュレータ!AL14)","v":0},null,null,null,0,{"$f":"マスタ!C73","v":0},{"$f":"B19*C19","v":0},{"$f":"シミュレータ!T14","v":0},null,"2017年08月",0,0,{"$f":"マスタ!K76","v":0},{"$f":"SUM(マスタ!L73:N73)","v":0},{"$f":"シミュレータ!Z14","v":0},{"$f":"シミュレータ!AF14","v":0},{"$error":"#DIV/0!"}]
["2017年09月",0,{"$f":"IF(シミュレータ!AL15=0,シミュレータ!AI15,シミュレータ!AL15)","v":0}," ",null,null,0,{"$f":"マスタ!C74","v":0},{"$f":"B20*C20","v":0},{"$f":"シミュレータ!T15","v":0},null,"2017年09月",0,0,{"$f":"マスタ!K77","v":0},{"$f":"SUM(マスタ!L74:N74)","v":0},{"$f":"シミュレータ!Z15","v":0},{"$f":"シミュレータ!AF15","v":0},{"$error":"#DIV/0!"}]
["2017年10月",0,null,{"$f":"IF(シミュレータ!AL16=0,シミュレータ!AI16,シミュレータ!AL16)","v":0},null,null,0,{"$f":"マスタ!C75","v":0},0,{"$f":"シミュレータ!T16","v":0},null,"2017年10月",0,0,{"$f":"マスタ!K78","v":0},{"$f":"SUM(マスタ!L75:N75)","v":0},{"$f":"シミュレータ!Z16","v":0},{"$f":"シミュレータ!AF16","v":0},{"$error":"#DIV/0!"}]
["2017年11月",0,null,{"$f":"IF(シミュレータ!AL17=0,シミュレータ!AI17,シミュレータ!AL17)","v":0},null,null,0,{"$f":"マスタ!C76","v":0},0,{"$f":"シミュレータ!T17","v":0},null,"2017年11月",0,0,{"$f":"マスタ!K79","v":0},{"$f":"SUM(マスタ!L76:N76)","v":0},{"$f":"シミュレータ!Z17","v":0},{"$f":"シミュレータ!AF17","v":0},{"$error":"#DIV/0!"}]
["2017年12月",0,null,{"$f":"IF(シミュレータ!AL18=0,シミュレータ!AI18,シミュレータ!AL18)","v":0},null,null,0,{"$f":"マスタ!C77","v":0},0,{"$f":"シミュレータ!T18","v":0},null,"2017年12月",0,0,{"$f":"マスタ!K80","v":0},{"$f":"SUM(マスタ!L77:N77)","v":0},{"$f":"シミュレータ!Z18","v":0},{"$f":"シミュレータ!AF18","v":0},{"$error":"#DIV/0!"}]
["2017-01-01",0,null,{"$f":"IF(シミュレータ!AL7=0,シミュレータ!AI7,シミュレータ!AL7)","v":0},null,null,0,{"$f":"マスタ!C69","v":0},0,{"$f":"シミュレータ!T7","v":0},null,"2017-01-01",0,0,{"$f":"マスタ!K69","v":0},{"$f":"SUM(マスタ!L69:N69)","v":0},{"$f":"シミュレータ!Z7","v":0},{"$f":"シミュレータ!AF7","v":0},{"$error":"#DIV/0!"}]
["2017-02-01",0,null,{"$f":"IF(シミュレータ!AL8=0,シミュレータ!AI8,シミュレータ!AL8)","v":0},null,null,{"$f":"SUM(C25:F25)","v":0},{"$f":"マスタ!C70","v":0},0,{"$f":"シミュレータ!T8","v":0},null,"2017-02-01",0,0,{"$f":"マスタ!K70","v":0},{"$f":"SUM(マスタ!L70:N70)","v":0},{"$f":"シミュレータ!Z8","v":0},{"$f":"シミュレータ!AF8","v":0},{"$error":"#DIV/0!"}]
["2017-03-01",0,null,{"$f":"IF(シミュレータ!AL9=0,シミュレータ!AI9,シミュレータ!AL9)","v":0},null,null,{"$f":"SUM(C26:F26)","v":0},{"$f":"マスタ!C71","v":0},0,{"$f":"シミュレータ!T9","v":0},null,"2017-03-01",0,0,{"$f":"マスタ!K71","v":0},{"$f":"SUM(マスタ!L71:N71)","v":0},{"$f":"シミュレータ!Z9","v":0},{"$f":"シミュレータ!AF9","v":0},{"$error":"#DIV/0!"}]
["合　計",null,{"$f":"SUM(C15:C26)","v":0},0,0,0,0,0,0,0,null,"合　計",null,{"$f":"SUM(N15:N26)","v":0},{"$f":"SUM(O15:O26)","v":0},{"$f":"SUM(P15:P26)","v":0},{"$f":"SUM(Q15:Q26)","v":0},{"$f":"SUM(R15:R26)","v":0},{"$f":"R27/J27","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,"東京都港区元赤坂1-1-7オリエント赤坂モートサイドビル2F 株式会社パワー・オプティマイザー　TEL:03-4400-1796\n"]

{"sheet":"マスタ","index":3,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,3,0,9],[0,10,0,17]]}
["計算用",null,null,"電灯",null,null,null,null,null,null,"動力"]
[null,"エリア","プラン","基本料金","基本料金","第一段階","第二段階","第三段階","PO基本","PO従量1","基本料金","基本料金","夏季","他季","OP基本料金","OP基本料金","OP夏季","OP他季"]
[null,"北海道電力","従量電灯B(A)",334.8,{"$f":"D3*(シミュレータ!$C$9/10)","v":0},23.54,29.7,33.369999999999997,0,28.9]
[null,"東北電力","従量電灯B(A)",324,{"$f":"D4*(シミュレータ!$C$9/10)","v":0},18.239999999999998,24.87,28.75,0,25.9]
[null,"東京電力EP","従量電灯B(A)",280.8,{"$f":"D5*(シミュレータ!$C$9/10)","v":0},19.52,26,30.02,0,25.9]
[null,"中部電力","従量電灯B(A)",280.8,{"$f":"D6*(シミュレータ!$C$9/10)","v":0},20.68,25.08,27.97,0,26.9]
[null,"北陸電力","従量電灯B(A)",237.6,{"$f":"D7*(シミュレータ!$C$9/10)","v":0},17.52,21.33,23.02,0,25.9]
[null,"関西電力","従量電灯A（A)",327.64999999999998,{"$f":"D8","v":327.64999999999998},19.760000000000002,26.19,29.94,0,25.9]
[null,"中国電力","従量電灯A（A)",331.23,{"$f":"D9","v":331.23},20.399999999999999,26.96,29.04,0,25.9]
[null,"四国電力","従量電灯A（A)",403.92,{"$f":"D10","v":403.92},20,26.5,29.95,0,25.9]
[null,"九州電力","従量電灯B(A)",291.60000000000002,{"$f":"D11*(シミュレータ!$C$9/10)","v":0},17.190000000000001,22.69,25.63,0,25.9]
[null,"北海道電力","従量電灯C(kVA)",334.8,{"$f":"D12*(シミュレータ!$C$9/10)","v":0},23.54,29.72,33.369999999999997,0,29.9]
[null,"東北電力","従量電灯C(kVA)",324,{"$f":"D13*(シミュレータ!$C$9)","v":0},18.239999999999998,24.87,28.75,0,26.9]
[null,"東京電力EP","従量電灯C(kVA)",280.8,{"$f":"D14*(シミュレータ!$C$9)","v":0},19.52,26,30.02,0,26.9]
[null,"中部電力","従量電灯C(kVA)",280.8,{"$f":"D15*(シミュレータ!$C$9)","v":0},20.68,25.08,27.97,0,27.9]
[null,"北陸電力","従量電灯C(kVA)",237.6,{"$f":"D16*(シミュレータ!$C$9)","v":0},17.52,21.33,23.02,0,26.9]
[null,"関西電力","従量電灯B(kVA)",388.8,{"$f":"D17*(シミュレータ!$C$9)","v":0},17.399999999999999,21.68,24.95,0,26.9]
[null,"中国電力","従量電灯B(kVA)",399.6,{"$f":"D18*(シミュレータ!$C$9)","v":0},17.760000000000002,23.74,25.58,0,26.9]
[null,"四国電力","従量電灯B(kVA)",367.2,{"$f":"D19*(シミュレータ!$C$9)","v":0},16.66,22.09,24.96,0,26.9]
[null,"九州電力","従量電灯C(kVA)",324,{"$f":"D20*(シミュレータ!$C$9)","v":0},18.239999999999998,24.87,28.75,0,25.9]
[null,"北海道電力",null,null,null,null,null,null,null,null,1263.5999999999999,{"$f":"K21*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},17.350000000000001,17.350000000000001,523.79999999999995,{"$f":"O21*シミュレータ!$C$9","v":0},24,24]
[null,"東北電力","低圧電力(KW)",null,null,null,null,null,null,null,1242,{"$f":"K22*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},15.66,14.23,572.4,{"$f":"O22*シミュレータ!$C$9","v":0},25,23]
[null,"東京電力EP","低圧電力(KW)",null,null,null,null,null,null,null,1101.5999999999999,{"$f":"K23*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},17.059999999999999,15.51,691.2,{"$f":"O23*シミュレータ!$C$9","v":0},19.5,21.5]
[null,"中部電力","低圧電力(KW)",null,null,null,null,null,null,null,1123.2,{"$f":"K24*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},16.73,15.21,496.8,{"$f":"O24*シミュレータ!$C$9","v":0},24,22]
[null,"北陸電力","低圧電力(KW)",null,null,null,null,null,null,null,1144.8,{"$f":"K25*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},11.93,10.89,453.6,{"$f":"O25*シミュレータ!$C$9","v":0},24,22]
[null,"北陸電力","低圧電力Ⅱ(KW)",null,null,null,null,null,null,null,972,{"$f":"K26*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},18.559999999999999,16.91,453.6,{"$f":"O26*シミュレータ!$C$9","v":0},24,22]
[null,"関西電力","低圧電力(KW)",null,null,null,null,null,null,null,1058.4000000000001,{"$f":"K27*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},14.82,13.37,421.2,{"$f":"O27*シミュレータ!$C$9","v":0},24,22]
[null,"中国電力",null,null,null,null,null,null,null,null,1090.8,{"$f":"K28*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},14.75,13.49,453.6,{"$f":"O28*シミュレータ!$C$9","v":0},24,22]
[null,"四国電力",null,null,null,null,null,null,null,null,1096,{"$f":"K29*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},15.51,14.09,448.2,{"$f":"O29*シミュレータ!$C$9","v":0},24,22]
[null,"九州電力","低圧電力(KW)",null,null,null,null,null,null,null,993.6,{"$f":"K30*シミュレータ!$C$9*(IF(動力!$J$8=85%,1,IF(動力!$J$8=90%,1.05,IF(動力!$J$8=80%,0.95))))","v":0},16.850000000000001,15.2,545.4,{"$f":"O30*シミュレータ!$C$9","v":0},24,22]
["プラン表示用"]
[null,{"$f":"VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$C$11,2,FALSE)","v":"従量電灯B(A)"}]
[null,{"$f":"VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$C$20,2,FALSE)","v":"従量電灯C(kVA)"}]
[null,{"$f":"VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$C$29,2,FALSE)","v":"低圧電力(KW)"}]
[]
["対象月表示用",null,null,"1月",null,"2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月"]
[null,"1月",1000,1,null,{"$f":"C37/$C$38","v":1.1261261261261262},{"$f":"C37/$C$39","v":1.1764705882352942},{"$f":"C37/$C$40","v":1.4388489208633093},{"$f":"C37/$C$41","v":1.5267175572519085},{"$f":"C37/$C$42","v":1.5220700152207001},{"$f":"C37/$C$43","v":1.1454753722794959},{"$f":"C37/$C$44","v":1.0822510822510822},{"$f":"C37/$C$45","v":1.4749262536873156},{"$f":"C37/$C$46","v":1.5037593984962405},{"$f":"C37/$C$47","v":1.4265335235378032},{"$f":"C37/$C$48","v":1.0427528675703859}]
[null,"2月",888,{"$f":"C38/$C$37","v":0.88800000000000001},null,{"$f":"C38/$C$38","v":1},{"$f":"C38/$C$39","v":1.0447058823529412},{"$f":"C38/$C$40","v":1.2776978417266187},{"$f":"C38/$C$41","v":1.3557251908396946},{"$f":"C38/$C$42","v":1.3515981735159817},{"$f":"C38/$C$43","v":1.0171821305841924},{"$f":"C38/$C$44","v":0.96103896103896103},{"$f":"C38/$C$45","v":1.3097345132743363},{"$f":"C38/$C$46","v":1.3353383458646617},{"$f":"C38/$C$47","v":1.2667617689015691},{"$f":"C38/$C$48","v":0.92596454640250259}]
[null,"3月",850,{"$f":"C39/$C$37","v":0.85},null,0.9572072072072072,1,1.2230215827338129,1.2977099236641221,1.2937595129375952,0.97365406643757157,0.91991341991341991,1.2536873156342183,1.2781954887218046,1.2125534950071326,0.88633993743482797]
[null,"4月",695,{"$f":"C40/$C$37","v":0.69499999999999995},null,0.78265765765765771,0.81764705882352939,1,1.0610687022900764,1.0578386605783867,0.79610538373424966,0.75216450216450215,1.0250737463126844,1.0451127819548873,0.99144079885877323,0.72471324296141815]
[null,"5月",655,0.65500000000000003,null,0.73761261261261257,0.77058823529411768,0.94244604316546765,1,0.9969558599695586,0.75028636884306987,0.70887445887445888,0.96607669616519176,0.98496240601503759,0.93437945791726107,0.68300312825860277]
[null,"6月",657,0.65700000000000003,null,0.73986486486486491,0.77294117647058824,0.9453237410071943,1.0030534351145037,1,0.75257731958762886,0.71103896103896103,0.96902654867256632,0.98796992481203005,0.93723252496433662,0.68508863399374353]
[null,"7月",873,0.873,null,0.98310810810810811,1.0270588235294118,1.256115107913669,1.332824427480916,1.3287671232876712,1,0.94480519480519476,1.2876106194690264,1.3127819548872179,1.2453637660485022,0.91032325338894682]
[null,"8月",924,0.92400000000000004,null,1.0405405405405406,1.0870588235294119,1.3294964028776979,1.4106870229007633,1.4063926940639269,1.0584192439862543,1,1.3628318584070795,1.3894736842105264,1.3181169757489302,0.96350364963503654]
[null,"9月",678,0.67800000000000005,null,0.76351351351351349,0.79764705882352938,0.97553956834532374,1.0351145038167939,1.0319634703196348,0.7766323024054983,0.73376623376623373,1,1.0195488721804511,0.96718972895863053,0.70698644421272161]
[null,"10月",665,0.66500000000000004,null,0.74887387387387383,0.78235294117647058,0.95683453237410077,1.0152671755725191,1.0121765601217656,0.76174112256586479,0.71969696969696972,0.9808259587020649,1,0.94864479315263905,0.69343065693430661]
[null,"11月",701,0.70099999999999996,null,0.7894144144144144,0.82470588235294118,1.0086330935251799,1.0702290076335879,1.0669710806697108,0.80297823596792672,0.7586580086580087,1.0339233038348083,1.0541353383458647,1,0.73096976016684045]
[null,"12月",959,0.95899999999999996,null,1.079954954954955,1.128235294117647,1.3798561151079136,1.4641221374045801,1.4596651445966515,1.0985108820160367,1.0378787878787878,1.4144542772861357,1.4421052631578948,1.3680456490727533,1]
[]
[null,null,null,null,null,"基本","従量1","従量2","従量3"]
[{"$f":"シミュレータ!AL7","v":0},{"$f":"VLOOKUP(シミュレータ!C12,シミュレータ!C12,1,FALSE)","v":"4月"},"1月",{"$f":"HLOOKUP($B$51,$D$36:P48,2,FALSE)","v":1.4388489208633093},null,{"$f":"IF(A51=0,(ROUND($B$52*D51,0)),(ROUND(A51,0)))","v":0},{"$f":"IF(F51>120,120,F51)","v":0},{"$f":"IF(F51-G51>180,180,IF(F51-G51>0,F51-G51,0))","v":0},{"$f":"IF(F51-SUM(G51:H51)>0,F51-SUM(G51:H51),0)","v":0}]
[{"$f":"シミュレータ!AL8","v":0},{"$f":"シミュレータ!C15","v":0},"2月",{"$f":"HLOOKUP($B$51,$D$36:P50,3,FALSE)","v":1.2776978417266187},null,{"$f":"IF(A52=0,(ROUND($B$52*D52,0)),(ROUND(A52,0)))","v":0},{"$f":"IF(F52>120,120,F52)","v":0},{"$f":"IF(F52-G52>180,180,IF(F52-G52>0,F52-G52,0))","v":0},{"$f":"IF(F52-SUM(G52:H52)>0,F52-SUM(G52:H52),0)","v":0}]
[{"$f":"シミュレータ!AL9","v":0},null,"3月",{"$f":"HLOOKUP($B$51,$D$36:P51,4,FALSE)","v":1.2230215827338129},null,{"$f":"IF(A53=0,(ROUND($B$52*D53,0)),(ROUND(A53,0)))","v":0},0,0,{"$f":"IF(F53-SUM(G53:H53)>0,F53-SUM(G53:H53),0)","v":0}]
[{"$f":"シミュレータ!AL10","v":0},null,"4月",{"$f":"HLOOKUP($B$51,$D$36:P52,5,FALSE)","v":1},null,0,0,0,0]
[{"$f":"シミュレータ!AL11","v":0},null,"5月",{"$f":"HLOOKUP($B$51,$D$36:P53,6,FALSE)","v":0.94244604316546765},null,0,0,0,0]
[{"$f":"シミュレータ!AL12","v":0},null,"6月",{"$f":"HLOOKUP($B$51,$D$36:P54,7,FALSE)","v":0.9453237410071943},null,0,0,0,0]
[{"$f":"シミュレータ!AL13","v":0},null,"7月",{"$f":"HLOOKUP($B$51,$D$36:P55,8,FALSE)","v":1.256115107913669},null,0,0,0,0]
[{"$f":"シミュレータ!AL14","v":0},null,"8月",{"$f":"HLOOKUP($B$51,$D$36:P56,9,FALSE)","v":1.3294964028776979},null,0,0,0,0]
[{"$f":"シミュレータ!AL15","v":0},null,"9月",{"$f":"HLOOKUP($B$51,$D$36:P57,10,FALSE)","v":0.97553956834532374},null,0,0,0,0]
[{"$f":"シミュレータ!AL16","v":0},null,"10月",{"$f":"HLOOKUP($B$51,$D$36:P58,11,FALSE)","v":0.95683453237410077},null,0,0,0,0]
[{"$f":"シミュレータ!AL17","v":0},null,"11月",{"$f":"HLOOKUP($B$51,$D$36:P59,12,FALSE)","v":1.0086330935251799},null,0,0,0,0]
[{"$f":"シミュレータ!AL18","v":0},null,"12月",{"$f":"HLOOKUP($B$51,$D$36:P60,13,FALSE)","v":1.3798561151079136},null,0,0,0,0]
[]
[]
[]
[]
[]
["通常",null,"基本","従量1","従量2","従量3","低圧電力","合計",null,null,"PO基本","PO従量1","PO従量2","PO従量3","低圧電力","合計"]
[null,"1月",{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,4,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,4,0),VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$P$31,11,FALSE)))","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G51,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H51,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I51,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F51,0),0)","v":0},{"$f":"SUM(C69:G69)","v":0},null,"1月",{"$f":"IF(シミュレータ!J9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$2:$P$11,8,FALSE),IF(シミュレータ!J9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,8,0),VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$P$30,15,FALSE)))","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G51,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H51,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I51,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F51,0),0)","v":0},{"$f":"SUM(K69:O69)","v":0}]
[null,"2月",{"$f":"$C$69","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G52,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H52,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I52,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F52,0),0)","v":0},{"$f":"SUM(C70:G70)","v":0},null,"2月",{"$f":"$K$69","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G52,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H52,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I52,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F52,0),0)","v":0},{"$f":"SUM(K70:O70)","v":0}]
[null,"3月",{"$f":"$C$69","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G53,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H53,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I53,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F53,0),0)","v":0},0,null,"3月",{"$f":"$K$69","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G53,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H53,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I53,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F53,0),0)","v":0},0]
[null,"4月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G54,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H54,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I54,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F54,0),0)","v":0},0,null,"4月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G54,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H54,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I54,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F54,0),0)","v":0},0]
[null,"5月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G55,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H55,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I55,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F55,0),0)","v":0},0,null,"5月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G55,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H55,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I55,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F55,0),0)","v":0},0]
[null,"6月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G56,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H56,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I56,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F56,0),0)","v":0},0,null,"6月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G56,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H56,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I56,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F56,0),0)","v":0},0]
[null,"7月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G57,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H57,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I57,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,12,FALSE)*マスタ!F57,0),0)","v":0},0,null,"7月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G57,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H57,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I57,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,16,FALSE)*マスタ!F57,0),0)","v":0},0]
[null,"8月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G58,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H58,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I58,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,12,FALSE)*マスタ!F58,0),0)","v":0},0,null,"8月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G58,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H58,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I58,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,16,FALSE)*マスタ!F58,0),0)","v":0},0]
[null,"9月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G59,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H59,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I59,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,12,FALSE)*マスタ!F59,0),0)","v":0},0,null,"9月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G59,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H59,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I59,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,16,FALSE)*マスタ!F59,0),0)","v":0},0]
[null,"10月",{"$f":"$C$69","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G60,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H60,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I60,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F60,0),0)","v":0},{"$f":"SUM(C78:G78)","v":0},null,"10月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G60,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H60,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I60,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F60,0),0)","v":0},0]
[null,"11月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G61,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H61,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I61,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F61,0),0)","v":0},0,null,"11月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G61,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H61,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I61,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F61,0),0)","v":0},0]
[null,"12月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,5,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,5,FALSE),\"\"))*G62,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,6,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,6,FALSE),\"\"))*H62,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,7,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,7,FALSE),\"\"))*I62,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,13,FALSE)*マスタ!F62,0),0)","v":0},0,null,"12月",0,{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*G62,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*H62,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(A)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$3:$P$11,9,FALSE),IF(シミュレータ!$J$9=\"(kVA)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$12:$P$20,9,FALSE),\"\"))*I62,0)","v":0},{"$f":"IFERROR(IF(シミュレータ!$J$9=\"(KW)\",VLOOKUP(シミュレータ!$C$3,マスタ!$B$21:$R$29,17,FALSE)*マスタ!F62,0),0)","v":0},0]