{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["戸建・併用住宅用"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":499,"n_cols":32,"rows_kept":499,"cut":false,"hidden":false,"merged":[[3,4,3,6],[5,7,5,8],[9,2,9,6],[22,1,25,1],[14,4,14,6],[15,2,15,6],[10,7,10,8],[6,7,6,8],[6,9,6,11],[11,9,11,11],[12,7,12,8],[12,9,12,11],[11,2,11,6],[12,2,12,6],[16,2,17,3],[16,4,16,6],[9,7,9,8],[9,9,9,11],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[24,2,24,6],[45,11,46,11],[39,1,39,3],[41,1,41,3],[42,1,42,3],[44,1,44,3],[41,10,42,11],[43,11,44,11],[45,5,46,5],[43,1,43,3],[46,1,46,3],[45,8,46,8],[45,10,46,10],[39,4,39,11],[43,4,44,4],[43,5,44,5],[41,4,42,5],[41,7,42,8],[38,1,38,4],[34,5,34,10],[35,5,38,5],[35,6,38,6],[35,7,38,7],[25,15,25,19],[22,15,23,15],[22,17,24,17],[29,1,29,3],[29,4,29,5],[35,8,38,8],[35,9,38,9],[35,10,38,10],[30,9,30,10],[31,9,31,11],[31,6,31,8],[31,4,31,5],[34,1,34,3],[36,1,36,3],[31,1,31,3],[21,9,21,10],[20,1,21,1],[23,7,23,8],[25,7,25,8],[25,2,25,6],[23,2,23,6],[28,1,28,3],[28,4,28,5],[29,6,29,7],[22,7,22,8],[51,11,55,11],[48,4,48,10],[143,15,143,17],[143,18,143,19],[144,15,144,17],[144,18,144,19],[136,15,136,20],[145,14,145,17],[145,18,145,19],[133,14,138,14],[142,18,142,19],[142,14,142,17],[141,14,141,17],[141,18,141,19],[129,17,129,21],[61,11,62,11],[136,21,136,22],[57,6,59,6],[57,7,59,7],[136,23,136,24],[137,15,137,22],[138,15,138,22],[133,15,133,17],[134,15,135,17],[134,18,134,19],[134,21,134,22],[127,22,127,23],[129,22,129,23],[134,23,134,24],[135,18,135,19],[135,21,135,22],[127,24,129,24],[130,14,130,23],[127,14,129,16],[127,17,127,21],[128,22,128,23],[128,17,128,21],[135,23,135,24],[124,24,126,24],[125,17,125,21],[126,17,126,21],[124,14,126,16],[124,17,124,21],[124,22,124,23],[125,22,125,23],[126,22,126,23],[123,14,123,24],[18,7,18,8],[21,7,21,8],[20,7,20,8],[20,9,20,10],[20,2,21,3],[19,4,19,6],[50,1,50,3],[61,1,64,1],[54,4,54,10],[50,9,52,9],[51,5,52,5],[51,4,52,4],[49,4,50,4],[49,5,50,5],[61,2,62,2],[54,1,54,3],[55,4,56,5],[57,4,59,5],[57,8,59,8],[61,3,61,5],[61,6,61,10],[52,1,52,3],[50,10,52,10],[47,1,47,3],[48,1,48,3],[67,4,67,5],[68,4,68,5],[43,10,44,10],[43,8,44,8],[50,6,52,6],[50,7,52,7],[50,8,52,8],[67,2,67,3],[68,2,68,3],[66,4,66,5],[66,1,68,1],[66,2,66,3],[45,4,46,4],[45,7,46,7],[55,6,56,7],[55,8,56,10],[45,1,45,3],[43,7,44,7],[3,1,3,3],[34,29,37,29],[34,28,37,28],[34,26,37,26],[34,27,37,27],[4,4,4,6],[5,1,5,3],[5,4,5,5],[4,1,4,3],[4,7,4,8],[20,4,21,6],[16,1,19,1],[21,18,21,19],[20,14,21,14],[20,15,20,16],[20,17,20,19],[22,18,24,19],[7,9,7,11],[8,7,8,8],[8,9,8,11],[8,2,8,6],[13,9,14,11],[5,9,5,10],[24,7,24,8],[8,19,9,20],[30,7,30,8],[30,1,30,3],[30,4,30,5],[28,6,28,7],[4,9,4,11],[6,2,6,6],[19,7,19,8],[18,2,19,3],[18,4,18,6],[15,9,19,11],[6,1,15,1],[7,2,7,6],[11,7,11,8],[7,7,7,8],[13,2,14,3],[13,4,13,6],[10,9,10,11],[10,2,10,6],[17,4,17,6],[22,2,22,6],[16,14,17,16],[16,17,17,18],[16,19,17,19]]}
[null,"■　住宅用一次エネルギー消費量計算書",null,null,null,null,null,null,null,null,null,"Ver.10.0"]
[]
[null,"1. 一次エネルギー消費量計算結果・断熱性能"]
[null,"住宅タイプの名称",null,null,{"$f":"IF(ISERROR(LEFT(C168,(LEN(C168)-8))),\"\",LEFT(C168,(LEN(C168)-8)))","v":""},null,null,"建て方",{"$f":"IF(ISERROR(MID(C168,(LEN(C168)-5),4)),\"\",MID(C168,(LEN(C168)-5),4))","v":""},"地域の区分",{"$f":"O158","v":""},"地域",null," 【本計算書の使用方法と注意事項】"]
[null,"断熱性能評価手法",null,null,{"$f":"IF(J8=\"\",\"\",IF(OR(J5=R151,J5=R152,J5=R153,ISERROR(C214)),S154,IF(MID(C214,14,13)=\"当該住戸の外皮面積を用いて\",S150,IF(MID(C214,14,4)=\"仕様基準\",S151,IF(MID(C214,14,6)=\"誘導仕様基準\",S152,IF(MID(C214,14,13)=\"当該住戸の外皮面積を用いず\",S153,S154))))))","v":""},null,null,"一次エネルギー評価手法",null,{"$f":"IF(J8=\"\",R154,R150)","v":"選択するかPDFを読込んでください"},null,null,null," ①　本計算書を添付することで、BELS設計内容説明書 第二面の数値記入を省略することができます。"]
[null,"計算対象床面積（合計）",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C170,LEN(C170)-1),ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(LEFT(C170,LEN(C170)-1),ROW($1:$16))))","v":""},null,"㎡","非住宅の評価対象床面積",null,{"$f":"IF(I4=\"\",\"\",IF(I4=\"戸建住宅\",0,IF(R17=\"\",0,R17)))","v":""},null,"㎡",null," ②　本計算書を再利用すると計算式が削除されている可能性があるため、常に新しい計算書をご使用ください。"]
[null,"一次エネルギー消費量","内訳",null,null,null,null,"設計一次[MJ/年]",null,"基準一次[MJ/年]",null,null,null," ②　BELS評価プレビューは端数処理等の影響によって数値が変わる可能性があります。"]
[null,null,"暖房設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C171,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C171,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C171,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C171,ROW($1:$16))))","v":""}]
[null,null,"冷房設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C172,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C172,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C172,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C172,ROW($1:$16))))","v":""},null,null,null," 【本計算書の作成方法】",null,null,null,null,null,"ＰＤＦ読込"]
[null,null,"換気設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C173,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C173,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C173,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C173,ROW($1:$16))))","v":""},null,null,null," ①　右のボタンで一次エネルギー消費量計算結果のPDFを読み込む。"]
[null,null,"給湯設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C174,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C174,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C174,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C174,ROW($1:$16))))","v":""},null,null,null,"※ PDFが読み込めないときは、「1. 一次エネルギー消費量計算結果」"]
[null,null,"照明設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C175,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C175,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C175,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C175,ROW($1:$16))))","v":""},null,null,null,"　 の黄色セルに該当のPDFデータを入力してください。"]
[null,null,"その他の設備",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C176,7,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C176,7,15),ROW($1:$16))))","v":""},null,{"$f":"IF(ISBLANK(H13),\"\",H13)","v":""},null,null,null,"※ 住宅タイプの名称に変更がある場合は、修正を行ってください。"]
[null,null,"発電設備の発電量\nのうち自家消費分",null,"太陽光発電（PV）",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C179,LEN(C179)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(C179,LEN(C179)-3),3)=\"---\",\"\",LOOKUP(1,-RIGHT(LEFT(C179,LEN(C179)-3),ROW($1:$16)))))","v":""},null,{"$f":"IF(SUM(H14:I15)=0,\"\",\"自家消費分合計 ＝ \"&SUM(H14:I15))","v":""}]
[null,null,null,null,"コージェネレーション設備（CGS）",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C180,LEN(C180)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(C180,LEN(C180)-3),3)=\"---\",\"\",LOOKUP(1,-RIGHT(LEFT(C180,LEN(C180)-3),ROW($1:$16)))))","v":""},null,null,null,null,null," ②　併用住宅で、非住宅部分と太陽光発電設備を共有している場合、非住宅の評価対象床面積を入力してください。"]
[null,null,"コージェネレーション設備の売電量に係る控除量",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C181,LEN(C181)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(C181,LEN(C181)-3),3)=\"---\",\"\",LOOKUP(1,-RIGHT(LEFT(C181,LEN(C181)-3),ROW($1:$16)))))","v":""},null,"発電設備が無い場合は\n０を記入、又は空欄とする\n\n",null,null,null,"　　　（ZEH等の適合判断では、総発電量を床面積按分した値を太陽光のエネルギー消費削減分の上限とします）"]
[null,"参考値","発電量［MJ/年］",null,"コージェネレーション",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C195,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C195,ROW($1:$16))))","v":""},null,null,null,null,null,null,"非住宅の評価対象床面積",null,null,null,null,"㎡"]
[null,null,null,null,"太陽光発電",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C196,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C196,ROW($1:$16))))","v":""}]
[null,null,"売電量［MJ/年］",null,"コージェネレーション",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C197,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C197,ROW($1:$16))))","v":""}]
[null,null,null,null,"太陽光発電",null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C198,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C198,ROW($1:$16))))","v":""},null,null,null,null,null," ③　「2. BELS評価申請項目」を入力、確認する。下の選択肢、又は左の表で直接選択してください。"]
[null,"ＢＥＩ","建築物エネルギー\n消費性能基準",null,"一次エネルギー消費量（その他除く）",null,null,"設計一次[GJ/年]",null,"基準一次[GJ/年]",null,"BEI",null,null,"選択","目安光熱費",null,"再エネ設備"]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(C203:D203)=0,\"\",SUM(C203:D203))","v":""},null,{"$f":"IF(SUM(C204:D204)=0,\"\",SUM(C204:D204))","v":""},null,{"$f":"IF(SUM(C205:D205)=0,\"\",SUM(C205:D205))","v":""},null,null,null,"表示","ガス種類","容量表示","太陽光以外の再エネ設備"]
[null,"参考値"," 消費電力量　　  [kWh/年]",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C191,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C191,ROW($1:$16))))","v":""},null,"断熱性能","ＵＡ","ηＡＣ",null,null,null,"希望する","都市ガス","太陽光が\nある場合\n希望する","太陽熱：なし\nその他：なし"]
[null,null,"ガス消費量 　　 [MJ]/年",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C192,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C192,ROW($1:$16))))","v":""},null,"設計値",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C185,LEN(C185)-5),ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(LEFT(C185,LEN(C185)-5),ROW($1:$16))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C186,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C186,ROW($1:$16))))","v":""},null,null,null,null,"ＬＰガス"]
[null,null,"灯油消費量 　　 [MJ/年]",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C193,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C193,ROW($1:$16))))","v":""},null,"基準値",{"$f":"IF(ISERROR(VLOOKUP(K4,O159:Q166,2)),\"\",VLOOKUP(K4,O159:Q166,2))","v":""},{"$f":"IF(ISERROR(VLOOKUP(K4,O159:Q166,3)),\"\",VLOOKUP(K4,O159:Q166,3))","v":""},null,null,null,"希望しない","－"]
[null,null,"コージェネ設備の売電量に係るガス消費量の控除量　[MJ/年]",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C194,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C194,ROW($1:$16))))","v":""},null,"強化外皮基準",{"$f":"IF(ISERROR(VLOOKUP(K4,O159:R166,4)),\"\",VLOOKUP(K4,O159:R166,4))","v":""},null,null,null,null,"左の表で選択",null,null,null,null,null,null,null,null,null,null,0,"評価申請選択（1-4）"]
[]
[null,"2. BELS評価申請項目"]
[null,"再エネ設備の有無",null,null,{"$f":"IF(J8=\"\",\"\",IF(OR(AA30,AB30,AC30),Z150,IF(OR(AA26=1,AA26=2,AA26=3),Z151,Z152)))","v":""},null,"種類（複数選択可能）",null,null,null,null,"(　　　　　　)",null,{"$f":"IF(AC30,T154,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H18=\"\",H18=0),FALSE,TRUE)","v":false},{"$f":"IF(S207=\"無し\",FALSE,TRUE)","v":false},null,"管理用"]
[null,"再エネ容量の表示希望",null,null,{"$f":"IF(J8=\"\",\"\",IF(E29=Z151,X153,IF(AND(H18<>\"\",H18<>0,OR(AA26=1,AA26=2,AA26=3)),X150,X152)))","v":""},null,"再エネ設備の容量・単位",null,{"$f":"IF(OR(J8=\"\",E30=X153),\"\",IF(E30=X151,\"－\",IF(P209=0,\"\",P209&\"kW\")))","v":""},{"$f":"IF(OR(J8=\"\",E30=X153),\"\",IF(E30=X151,\"－　　　\",IF(AB30,\"[㎡]\",\"\")))","v":""},{"$f":"IF(OR(J8=\"\",E30=X153),\"\",IF(E30=X151,\"－　　　\",IF(AB30,\"[L]\",\"\")))","v":""},{"$f":"IF(OR(J8=\"\",E30=X153),\"\",IF(E30=X151,\"－\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H18=\"\",H18=0),FALSE,TRUE)","v":false},{"$f":"IF(S207=\"無し\",FALSE,TRUE)","v":false},false,"実行用"]
[null,"エネルギーの多段階表示",null,null,{"$f":"IF(J8=\"\",\"\",IF(OR(H18=\"\",H18=0),W150,W151))","v":""},null,"「ZEHマーク」",{"$f":"IF(J8=\"\",\"\",IF(AND(K24<=K26,L24<=L25,W127>=20,W130>=100,H18>0),P150,IF(AND(K24<=K26,L24<=L25,W127>=20,W130>=75,W130<100,H18>0),P151,IF(AND(K24<=K26,L24<=L25,W127>=20),P154,P153))))","v":""},null,"ZEH Orientedの要件",null,{"$f":"IF(H31=\"\",\"\",IF(H31=P152,Y150,Y151))","v":""},null,{"$f":"IF(H31=P154,P156,IF(H31=P152,P155,\"\"))","v":""}]
[null,"目安光熱費の表示",null,null,{"$f":"IF(OR(J5=R151,J5=R152),U151,IF(J8=\"\",\"\",IF(OR(AA26=1,AA26=2),U150,IF(AA26=3,U151,U152))))","v":""},null,"ガス設備の選択",null,null,{"$f":"IF(AA26=1,V150,IF(AA26=2,V151,IF(E32=U150,V152,IF(OR(E32=U151,AA26=3),V153,\"\"))))","v":""}]
[]
[null,"3. BELS評価プレビュー",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,2,3,0]
[null,"住宅（住戸）",null,null,null,"エネルギー消費性能",null,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(AA43=3,$AC$35,IF(AA43=2,$AB$35,IF(AA43=1,$AA$35,\"\")))","v":""},"","","","",""]
[null,"物件概要"]
[null,"建物名称："]
[null,{"$f":"IF(E4=\"\",\"\",IF(OR(RIGHT(E4,9)=\" ( 戸建住宅 )\",RIGHT(E4,9)=\" ( 共同住宅 )\"),LEFT(E4,LEN(E4)-9),E4))","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,1,2,3,4,5,6]
[null,{"$f":"IF(K4=\"\",\"地域の区分：\",\"地域の区分：\"&K4&\"地域\")","v":"地域の区分："},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(E46=\"\",0,IF(E46>=0,1,IF(H46>=0,2,3)))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.1,1,IF(H46>=0.1,2,3)))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.2,1,IF(H46>=0.2,2,3)))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.3,1,IF(H46>=0.3,2,3)))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.4,1,IF(H46>=0.4,2,3)))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.5,1,IF(H46>=0.5,2,3)))","v":0}]
[null,null,null,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,2,3,4]
[null,"評価概要",null,null,"再エネなし",null,null,"再エネあり\n（自家消費分）",null,null,"再エネあり\n（自家消費分＋売電分）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E46=\"\",0,IF(E46>=0,1,3))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.1,1,3))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.2,1,3))","v":0},{"$f":"IF(E46=\"\",0,IF(E46>=0.3,1,3))","v":0}]
[null,"評価対象：住宅",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(E31=W151,AA40,\"\")","v":""},{"$f":"IF(E31=W151,AB40,IF(E31=W150,AB42,\"\"))","v":""},{"$f":"IF(E31=W151,AC40,IF(E31=W150,AC42,\"\"))","v":""},{"$f":"IF(E31=W151,AD40,IF(E31=W150,AD42,\"\"))","v":""},{"$f":"IF(E31=W151,AE40,IF(E31=W150,AE42,\"\"))","v":""},{"$f":"IF(E31=W151,AF40,\"\")","v":""}]
[null,{"$f":"IF(I4=\"\",\"\",IF(COUNTIF(I4,\"*\"&\"戸建\"&\"*\"),\"（一戸建ての住宅）\",IF(COUNTIF(I4,\"*\"&\"共同\"&\"*\"),\"（店舗等併用住宅の住戸部分）\",\"\")))","v":""},null,null,"削減率","BEI値",null,"削減率","BEI値",null,"削減率","BEI値"]
[null,"評価手法："]
[null,"・一次エネルギー消費量",null,null,{"$f":"IF(W127=\"\",\"\",W127/100)","v":""},{"$f":"IF(W127=\"\",\"\",1-W127/100)","v":""},null,{"$f":"IF(W127=\"\",\"\",IF(E31=W150,W127/100,1-I46))","v":""},{"$f":"IF(E31=W150,1-W127/100,L22)","v":""},null,{"$f":"IF(W127=\"\",\"\",IF(E31=W150,W127/100,W130/100))","v":""},{"$f":"IF(W127=\"\",\"\",IF(E31=W150,1-W127/100,1-W130/100))","v":""}]
[null,{"$f":"IF(J5=R154,\"\",\" \"&J5)","v":""}]
[null,"・断熱性能（外皮性能）"]
[null,{"$f":"\" \"&E5","v":" "},null,null,"断 熱 性 能"]
[null,"XMLID：",null,null,"UA値","ηAC値"]
[null,{"$f":"IF(ISERROR(C221),\"\",\" \"&MID(C221,10,18))","v":" "},null,null,null,null,{"$f":"IF($P190>=3,3,\"-\")","v":"-"},{"$f":"IF($P190>=4,4,\"-\")","v":"-"},{"$f":"IF($P190>=5,5,\"-\")","v":"-"},{"$f":"IF($P190>=6,6,\"-\")","v":"-"},{"$f":"IF($P190>=7,7,\"-\")","v":"-"}]
[null,"再出力コード :",null,null,{"$f":"K24","v":""},{"$f":"L24","v":""}]
[null,{"$f":"IF(ISERROR(C221),\"\",\" \"&RIGHT(C221,19))","v":" "}]
[]
[null,"目安光熱費",null,null,"達 成 項 目"]
[null,{"$f":"IF(E32=U151,\"なし\",IF(OR(AND(E32=U150,J32=V150),AND(E32=U150,J32=V151)),\"ガス設備：\"&J32,\"\"))","v":""},null,null,"ZEH水準",null,"ネット・ゼロ・\nエネルギー",null,"再エネ設備"]
[]
[null,null,null,null,{"$f":"IF(AND(E46<>\"\",E46>=0.2,S142>=5),\"☑\",\"-\")","v":"-"},null,{"$f":"IF(AND(E46<>\"\",X137=\"適合\"),\"☑\",\"-\")","v":"-"},{"$f":"IF(X137=\"適合\",V137,\"－\")","v":"－"},{"$f":"IF(OR(E29=Z150,E29=Z151),E29,\"\")","v":""},{"$f":"IF(AA30,\"太陽光発電\",\"－\")","v":"－"},{"$f":"IF(AND(E30=X150,AA30),I30,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AB30,\"太陽熱利用\",\"－\")","v":"－"},{"$f":"IF(AND(E30=X150,AB30),J30,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AC30,\"その他\",\"－\")","v":"－"},{"$f":"IF(AND(E30=X150,AB30),K30,\"\")","v":""}]
[]
[null,"省エネ性能","基準","一次エネルギー消費性能（GJ/年）",null,null,"断熱性能",null,null,null,null,"総合判定"]
[null,null,null,"設計一次","基準一次","判定","UA値","基準（UA）","ηAC値","基準（η）","判定"]
[null,null,"省エネ基準",{"$f":"IF(Z192=0,\"\",Z192)","v":""},{"$f":"IF(Z193=0,\"\",Z193)","v":""},{"$f":"IF(D64=\"\",\"\",IF(D64<=E64,\"達成\",\"非達成\"))","v":""},{"$f":"K24","v":""},{"$f":"P192","v":""},{"$f":"L24","v":""},{"$f":"Q192","v":""},{"$f":"IF(G64=\"\",\"\",IF(AND(G64<=H64,I64<=J64),\"達成\",\"非達成\"))","v":""},{"$f":"IF(F64=\"\",\"\",IF(AND(F64=\"達成\",K64=\"達成\"),\"達成\",\"非達成\"))","v":""}]
[null,null,"誘導基準",{"$f":"IF(Z196=0,\"\",Z196)","v":""},{"$f":"IF(Z197=0,\"\",Z197)","v":""},{"$f":"IF(D65=\"\",\"\",IF(D65<=E65,\"達成\",\"非達成\"))","v":""},{"$f":"K24","v":""},{"$f":"R192","v":""},{"$f":"L24","v":""},{"$f":"S192","v":""},{"$f":"IF(G65=\"\",\"\",IF(AND(G65<=H65,I65<=J65),\"達成\",\"非達成\"))","v":""},{"$f":"IF(F65=\"\",\"\",IF(AND(F65=\"達成\",K65=\"達成\"),\"達成\",\"非達成\"))","v":""}]
[]
[null,"特記項目","再エネ除く削減率",null,{"$f":"IF(ISERROR(W127/100),\"\",W127/100)","v":""},null,null,"参考情報","等級","設計値","基準値","表示値"]
[null,null,"再エネ含む削減率",null,{"$f":"IF(ISERROR(W130/100),\"\",W130/100)","v":""},null,null,"品確法5-1",{"$f":"S142","v":""},{"$f":"IF(K24=\"\",\"\",TEXT(K24,\"0.00\")&\"/\"&TEXT(L24,\"0.0\"))","v":""},{"$f":"IF(I68=4,Q190,IF(I68=5,S190,IF(I68=6,U190,IF(I68=7,W190,\"\"))))","v":""},{"$f":"IF(OR(I68=7,AND(K4=8,I68=6)),J68,IF(I68=\"\",\"\",\"－\"))","v":""}]
[null,null,"「ZEHマーク」",null,{"$f":"IF(H31=\"\",\"\",IF(X137=\"適合\",H31,IF(OR(H31=P150,H31=P151,H31=P152),H31&\"　不適合\",\"記載しない\")))","v":""},null,null,"品確法5-2",{"$f":"S143","v":""},{"$f":"IF(S145=\"\",\"\",TEXT(S145,\"#####.0\")&\" GJ\")","v":""},{"$f":"IF(S144=\"\",\"\",TEXT(S144,\"#####.0\")&\" GJ\")","v":""},{"$f":"IF(OR(S146=\"－\",S146=\"\"),S146,S146&\" MJ/㎡\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"100行から読込開始"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"●旧評価書記載事項【計算結果・設計内容（現況）説明書記載事項】"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"「ZEHマーク」に関する事項"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"再生可能エネルギー等除き",null,null,"設計一次エネルギー消費量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(F163),\"\",F163)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費削減量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(J22-F163),\"\",J22-F163)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費量（その他除く）の削減率　　％",null,null,null,null,{"$f":"IF(O169=Q149,O171,IF(O169=Q150,P171,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"再生可能エネルギー等加え",null,null,"設計一次エネルギー消費量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(F164),\"\",F164)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費削減量（その他除く） GJ",null,null,null,null,{"$f":"IF(ISERROR(J22-F164),\"\",J22-F164)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"一次エネルギー消費量（その他除く）の削減率　　％",null,null,null,null,{"$f":"IF(O169=Q149,O174,IF(O169=Q150,P174,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"誘導仕様基準（ZEH Orientedに限る）"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"●旧評価書記載事項【評価書プレビュー】"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"一面","BEIの値（削減率）",null,null,{"$f":"L22","v":""},{"$f":"IF(S134=\"\",\"\",\"(\"&ROUND((1-S134)*100,0)&\"%削減)\")","v":""},{"$f":"IF(COUNTBLANK(S134)=1,\"\",IF(U158<>\"適合\",\"－\",IF(S134<=0.8,\"☆☆☆☆☆\",IF(AND(S134>0.8,S134<=0.85),\"☆☆☆☆\",IF(AND(S134>0.85,S134<=0.9),\"☆☆☆\",IF(AND(S134>0.9,S134<=1),\"☆☆\",IF(AND(S134>1,S134<=1.1),\"☆\",\"－\")))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"単位面積当たりの\n一次エネルギー消費量(MJ/㎡・年)",null,null,"設計値（その他除く）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP(H22*1000/E6,0))","v":""},"設計値（その他含む）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP((H162*1000)/E6,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,"基準値（その他除く）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP(J22*1000/E6,0))","v":""},"基準値（その他含む）",null,{"$f":"IF(E6=\"\",\"\",ROUNDUP(H154*1000/E6,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"「ＺＥＨマーク」、「ゼロエネ相当」、「ZEH-Mマーク」に関する事項　／　判定",null,null,null,null,null,{"$f":"IF(H31=\"\",\"\",H31)","v":""},null,{"$f":"IF(ISERROR(IF(OR(H31=\"\",K4=\"-\",K4=\"\",K24=\"\",L24=\"\",W127=\"\",W130=\"\"),\"\",IF(OR(AND(H31=P150,K24<=K26,L24<=L25,W127>=20,W130>=100),AND(H31=P151,K24<=K26,L24<=L25,W127>=20,W130>=75,W130<100),AND(H31=P152,K24<=K26,L24<=L25,W127>=20,W130<75)),\"適合\",\"－\"))),\"－\",IF(OR(H31=\"\",K4=\"\",AND(K4<8,K24=\"\"),W127=\"\",W130=\"\"),\"\",IF(OR(AND(H31=P150,K24<=K26,L24<=L25,W127>=20,W130>=100,H18>0),AND(H31=P151,K24<=K26,L24<=L25,W127>=20,W130>=75,W130<100,H18>0),AND(H31=P152,K24<=K26,L24<=L25,W127>=20,W130<75)),\"適合\",\"－\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"再生可能エネルギーを除いた設計一次エネルギー消費量の基準一次エネルギー消費量からの削減率",null,null,null,null,null,null,null,{"$f":"W127","v":""},"%削減"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"再生可能エネルギーを加えた設計一次エネルギー消費量の基準一次エネルギー消費量からの削減率",null,null,null,null,null,null,null,{"$f":"IF(V137=P152,\"\",W130)","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,"●旧評価書記載事項【参考情報　品確法 5-1、5-2 等級判定】"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"5-1　等級　（4・5・6・7）",null,null,null,{"$f":"IF(K4=\"\",\"\",IF(W191=\"適合\",7,IF(U191=\"適合\",6,IF(S191=\"適合\",5,IF(Q191=\"適合\",4,\"－\")))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"5-2　等級　（4・5・6）",null,null,null,{"$f":"IF(Z192=0,\"\",IF(AE200=\"適合\",6,IF(AC200=\"適合\",5,IF(AA200=\"適合\",4,\"－\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"IF(S143=\"\",\"\",S143)","v":""},"基準一次エネルギー　[GJ]",null,null,{"$f":"IF(S143=6,Z197,IF(S143=5,Z195,IF(S143=4,Z193,\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"IF(S143=\"\",\"\",S143)","v":""},"設計一次エネルギー　[GJ]",null,null,{"$f":"IF(S143=6,Z196,IF(S143=5,Z194,IF(S143=4,Z192,\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"設計一次エネルギー表示値　[MJ/㎡・年]",null,null,null,{"$f":"IF(OR(S145=\"\",E6=\"\"),\"\",IF(S143=6,ROUNDUP(S145*1000/E6,0),\"－\"))","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,"一次エネ設計","外皮設計","再エネ設備","光熱費","ガス種類","省エネ表示","容量表示","ZEH Oriented要件","再エネ設備"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"H28年基準",null,"国土交通省告示第489号に準拠した計算方法"]
[null,null,"エネルギー計算",null,null,null,null,null,null,null,null,null," ",null,"H25年基準","『ＺＥＨ』","ネット・ゼロ・エネルギー・ハウス支援事業が採用している計算方法","性能基準（平成28年基準）","性能基準（平成28年基準）","太陽光発電","希望する","都市ガス","４段階","希望する","適合","あり"]
[null,null,null,null,"他除","他除","他含",null,null,null,null,null," ",null,null,"Ｎｅａｒｌｙ　ＺＥＨ",null,"仕様基準（平成28年基準）","仕様基準（平成28年基準）","太陽熱利用","希望しない","ＬＰガス","６段階","希望しない","－","なし"]
[null,null,null,null,"MJ","GJ","MJ","GJ",null,null,null,null," ",null,null,"ＺＥＨ　Ｏｒｉｅｎｔｅｄ",null,"誘導仕様基準（平成28年基準）","誘導仕様基準（平成28年基準）","その他（　　　　　　　）","選択してください","選択してください",null,"選択してください",null,"選択してください"]
[null,null,"合計","設計",{"$f":"SUM(H8:I12)","v":0},null,null,null,null,null,null,null," ",null,null,"記載しない",null,"国土交通大臣が認める方法","国土交通大臣が認める方法","－",null,"選択不要",null,"選択不要"]
[null,null,null,"基準",{"$f":"SUM(J8:L12)","v":0},{"$f":"ROUNDUP(E154/1000,1)","v":0},{"$f":"E154+H13","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(G154/1000,1)","v":{"$error":"#VALUE!"}},null,null,null,null," ",null,null,"記載しない（※）",null,"選択するかPDFを読込んでください","選択してください"," ※　その他の再エネ利用設備名をカッコ内に記載してください"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null," ※　ZEH Orientedの要件に適合しない場合は、ZEH Orientedを選択できません"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,null," ※　ZEH Orientedの要件に適合する場合は、ZEH Orientedの選択が可能な性能値です"]
[null,null,null,null,"MJ",null,null,null,null,null,null,null," "]
[null,null,"自家消費＋CGS売電控除",null,{"$f":"IF(ISBLANK(H15),\"\",O176*(-1)+O177*(-1)+O178*(-1))","v":0},null,null,null,null,null,null,null," ",null,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(SUBSTITUTE(C169,\"区分\",\"*\",2),FIND(\"*\",SUBSTITUTE(C169,\"区分\",\"*\",2))+1,3),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(SUBSTITUTE(C169,\"区分\",\"*\",2),FIND(\"*\",SUBSTITUTE(C169,\"区分\",\"*\",2))+1,3),ROW($1:$16))))","v":""},null,null,{"$f":"IF(ISERROR(VLOOKUP(K4,O159:R166,4)),\"\",VLOOKUP(K4,O159:R166,4))","v":""},null,"省エネ基準",{"$f":"IF(OR(AND(K4>=5,K4<=7,K24<=K25,L24<=L25),AND(K4=8,L24<=L25),AND(K4<=4,K24<=K25)),\"適合\",\"－\")","v":"－"}]
[null,null,"CGS発電量＋売電控除",null,{"$f":"IF(ISBLANK(H17),\"\",O184-O186+O178*(-1))","v":0},null,null,null,null,null,null,null," ",null,1,0.46,"-",0.4]
[null,"按分","総発電量(ｺｰｼﾞｪﾈ＋太陽）",null,{"$f":"IF(OR(ISBLANK(H18),E6=\"\"),\"\",O184+O185*(E6/SUM(E6,J6)))","v":""},null,null,null,null,null,null,null," ",null,2,0.46,"-",0.4]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,3,0.56000000000000005,"-",0.5]
[null,null,"設計一次エネ",null,{"$f":"E$153-E158","v":0},{"$f":"ROUNDUP(E162/1000,1)","v":0},{"$f":"E162+H13","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(G162/1000,1)","v":{"$error":"#VALUE!"}},null,null,null,null," ",null,4,0.75,"-",0.6]
[null,null,null,"再除",{"$f":"E$153-E159","v":0},{"$f":"ROUNDUP(E163/1000,1)","v":0},null,null,null,null,null,null," ",null,5,0.87,3,0.6]
[null,null,null,"再含",{"$f":"E$153-E160","v":{"$error":"#VALUE!"}},{"$f":"IF(E164<0,ROUNDDOWN(E164/1000,1),ROUNDUP(E164/1000,1))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null," ",null,6,0.87,2.8,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,7,0.87,2.7,0.6]
[null,null,"抽出結果",null,"抽出文字列・Work",null,null,null,null,null,null,null," ",null,8,"-",6.7,"-"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E167&\"*\",$J$100:$J$499,0),1))","v":""},null,"(1)住宅",null,null,null,null,null,null,null," ",null,"-","□","□","□"]
[null,null,{"$f":"IF(C167<>\"\",MID(C167,FIND(\"(建て方)\",C167)+6,LEN(C167)),\"\")","v":""},null,"住宅名称WORK",null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E169&\"*\",$J$100:$J$499,0),1))","v":""},null,"(3)地域の区分",null,null,null,null,null,null,null," ",null,{"$f":"Q149","v":"国土交通省告示第489号に準拠した計算方法"}]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E170&\"*\",$J$100:$J$499,0)+1,1))","v":""},null,"(2)床面積",null,null,null,null,null,null,null," ",null,"告示準拠","ZEH"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E171&\"*\",$J$100:$J$499,0),1))","v":""},null,"暖房設備",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISERROR((J22-F163)/J22),\"\",IF(W126>=0,ROUNDDOWN((J22-F163)/J22*100,0),ROUNDUP((J22-F163)/J22*100,0)))","v":""},{"$f":"IF(ISERROR((E154-E153+E159)/E154),\"\",IF((E154-E153+E159)>=0,ROUNDDOWN((E154-E153+E159)/E154*100,1),ROUNDUP((E154-E153+E159)/E154*100,1)))","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,{"$f":"IF(ISERROR((J22-F164)/J22),\"\",IF(W129>=0,ROUNDDOWN((J22-F164)/J22*100,0),ROUNDUP((J22-F164)/J22*100,0)))","v":""},{"$f":"IF(ISERROR((E154-E153+E160)/E154),\"\",IF((E154-E153+E160)>=0,ROUNDDOWN((E154-E153+E160)/E154*100,1),ROUNDUP((E154-E153+E160)/E154*100,1)))","v":""}]
[null,null,"",null,"照明設備",null,null,null,null,null,null,null," "]
[null,null,"",null,"その他の設備",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H14),H14,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E176&\"*\",$J$100:$J$499,0)+1,1))","v":""},null,"　","自家消費量",null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H15),H15,0)","v":0},"数値以外の場合は0表記"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H16),H16,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E179&\"*\",$J$100:$J$499,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E179&\"*\",$J$100:$J$499,0),1)))","v":""},null,"太陽光発電(PV)",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C182,ROW($1:$16)))),\"\",IF(LEFT(C182,2)=\"合計\",-LOOKUP(1,-LEFT(MID(C182,3,15),ROW($1:$16))),-LOOKUP(1,-RIGHT(LEFT(C182,FIND(\" \",C182)),ROW($1:$16)))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C182,ROW($1:$16)))),\"\",IF(LEFT(C182,2)=\"合計\",\"\",-LOOKUP(1,-RIGHT(C182,ROW($1:$16)))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C182,ROW($1:$16)))),\"\",IF(LEFT(C182,2)=\"合計\",-LOOKUP(1,-RIGHT(C182,ROW($1:$16))),-LOOKUP(1,-LEFT(MID(C182,FIND(\" \",C182)+1,15),ROW($1:$16)))))","v":""},"設計合計MJ（PV、CGS）／設計合計MJ（CGS）／基準合計MJ"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E181&\"*\",$J$100:$J$499,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E181&\"*\",$J$100:$J$499,0)-1,1)))","v":""},null,null,null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H23),H23,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E181&\"*\",$J$100:$J$499,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E181&\"*\",$J$100:$J$499,0),1)))","v":""},null,"コージェネレーション設備の売電量に係る控除量",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H24),H24,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E181&\"*\",$J$100:$J$499,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E181&\"*\",$J$100:$J$499,0)+1,1)))","v":""},null,"MJ合計",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H25),H25,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E183&\"*\",$J$100:$J$499,0),1))","v":""},null,"一次エネルギー消費量(その他除く)",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H26),H26,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E184&\"*\",$J$100:$J$499,0),1))","v":""},null,"BEI ",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H17),H17,0)","v":0},"数値以外の場合は0表記(CGS)"]
[null,null,{"$f":"IF(RIGHT(D185,1)=\"）\",LEFT(D185,FIND(\"（\",D185)-2),D185)","v":""},{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E185&\"*\",$J$100:$J$499,0),1))","v":""},"外皮平均熱貫流率",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H18),H18,0)","v":0},"数値以外の場合は0表記(太陽光)"]
[null,null,{"$f":"MID(D186,FIND(\"ηAC\",D186)+6,3)","v":{"$error":"#VALUE!"}},{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E186&\"*\",$J$100:$J$499,0),1))","v":""},"平均日射熱取得率",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H19),H19,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E187&\"*\",$J$100:$J$499,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E187&\"*\",$J$100:$J$499,0)+1,1)))","v":""},null,"消費電力量[kWh] *1 ガス消費量[MJ] 灯油消費量[MJ] 相当値[MJ] *2",null,null,null,null,null,null,null," ",null,{"$f":"IF(ISNUMBER(H20),H20,0)","v":0},"数値以外の場合は0表記"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E188&\"*\",$J$100:$J$499,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E188&\"*\",$J$100:$J$499,0)+1,1)))","v":""},null,"消費電力量[kWh] *1 ガス消費量[MJ] 灯油消費量[MJ]",null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E189&\"*\",$J$100:$J$499,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E189&\"*\",$J$100:$J$499,0)+1,1)))","v":""},null,"発電量（コージェネレーション）[MJ] 発電量（太陽光発電）[MJ] 売電量[MJ]",null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$499,MATCH(E190&\"*\",$J$100:$J$499,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E190&\"*\",$J$100:$J$499,0)+1,1)))","v":""},null,"コージェネレーション太陽光発電コージェネレーション太陽光発電",null,null,null,null,null,null,null," ",null,"5-1work",{"$f":"IF(K4=\"\",0,IF(W191=\"適合\",7,IF(U191=\"適合\",6,IF(S191=\"適合\",5,IF(Q191=\"適合\",4,0)))))","v":0},{"$f":"TEXT(P192,\"0.00\")&\"/\"&TEXT(Q192,\"0.0\")","v":"/"},null,{"$f":"TEXT(R192,\"0.00\")&\"/\"&TEXT(S192,\"0.0\")","v":"/"},null,{"$f":"TEXT(T192,\"0.00\")&\"/\"&TEXT(U192,\"0.0\")","v":"/"},null,{"$f":"TEXT(V192,\"0.00\")&\"/\"&TEXT(W192,\"0.0\")","v":"/"},null,"5-2work"]
[null,null,{"$f":"IF(C188<>\"\",C188,\"\")","v":""},null,"消費電力量WORK",null,null,null,null,null,null,null," ",null,"地域区分","5-1等級4",{"$f":"IF(OR(AND(K4>=5,K4<=7,K24<=P192,L24<=Q192),AND(K4=8,L24<=Q192),AND(K4<=4,K24<=P192)),\"適合\",\"－\")","v":"－"},"5-1等級5",{"$f":"IF(OR(AND(K4>=5,K4<=7,K24<=R192,L24<=S192),AND(K4=8,L24<=S192),AND(K4<=4,K24<=R192)),\"適合\",\"－\")","v":"－"},"5-1等級6",{"$f":"IF(OR(AND(K4>=5,K4<=7,K24<=T192,L24<=U192),AND(K4=8,L24<=U192),AND(K4<=4,K24<=T192)),\"適合\",\"－\")","v":"－"},"5-1等級7",{"$f":"IF(OR(AND(K4>=5,K4<=7,K24<=V192,L24<=W192),AND(K4<=4,K24<=V192)),\"適合\",\"－\")","v":"－"},null,"GJ合計値抽出","PDF読込","計算"]
[null,null,{"$f":"IF(C188<>\"\",MID(C188,FIND(\" \",C188)+1,20),\"\")","v":""},null,"ガス消費量WORK",null,null,null,null,null,null,null," ",null,{"$f":"K4","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,2))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,3))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,4))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,5))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,6))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,7))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,8))","v":""},{"$f":"IF(ISERROR(VLOOKUP(O192,O193:W200,4)),\"\",VLOOKUP(O192,O193:W200,9))","v":""},null,"等級4設計",{"$f":"IF(ISERROR(C208),AA192,IF(C208=\"\",AA192,-LOOKUP(1,-LEFT(MID(C208,1,15),ROW($1:$16)))))","v":0},{"$f":"ROUNDUP(SUM(H8,H9,H10,H11,H12,H13,H14,H15,H16)/1000,1)","v":0}]
[null,null,{"$f":"IF(C188<>\"\",MID(C188,FIND(\"★\",SUBSTITUTE(C188,\" \",\"★\",2))+1,20),\"\")","v":""},null,"灯油消費量WORK",null,null,null,null,null,null,null," ",null,1,0.46,"-",0.4,"-",0.28000000000000003,"-",0.2,"-",null,"等級4基準",{"$f":"IF(ISERROR(C209),AA193,IF(C209=\"\",AA193,-LOOKUP(1,-LEFT(MID(C209,1,15),ROW($1:$16)))))","v":0},{"$f":"ROUNDUP(SUM(J8,J9,J10,J11,J12,H13)/1000,1)","v":0}]
[null,null,{"$f":"IF(AND(C188<>\"\",C187=\"\"),MID(C188,FIND(\"★\",SUBSTITUTE(C188,\" \",\"★\",3))+1,20),\"\")","v":""},null,"コージェネ売電ガス控除量WORK",null,null,null,null,null,null,null," ",null,2,0.46,"-",0.4,"-",0.28000000000000003,"-",0.2,"-",null,"等級5設計",{"$f":"IF(ISERROR(C210),AA194,IF(C210=\"\",AA194,-LOOKUP(1,-LEFT(MID(C210,1,15),ROW($1:$16)))))","v":0},{"$f":"ROUNDUP(SUM(H8,H9,H10,H11,H12,H13,H14,H15,H16)/1000,1)","v":0}]
[null,null,{"$f":"IF(C190<>\"\",C190,IF(C189<>\"\",C189,MID(C178,17,20)))","v":""},null,"発電・売電WORK1（発電CGS）",null,null,null,null,null,null,null," ",null,3,0.56000000000000005,"-",0.5,"-",0.28000000000000003,"-",0.2,"-",null,"等級5基準",{"$f":"IF(ISERROR(C211),AA195,IF(C211=\"\",AA195,IF(LEFT(C179,9)=\"太陽光発電(PV)\",-LOOKUP(1,-LEFT(MID(C211,10,15),ROW($1:$16))),-LOOKUP(1,-LEFT(MID(C211,12,15),ROW($1:$16))))))","v":0},{"$f":"ROUNDUP((SUM(J8,J9,J10,J11,J12)*0.9+SUM(H13))/1000,1)","v":0}]
[null,null,{"$f":"IF(C190<>\"\",MID(C190,FIND(\" \",C190)+1,20),IF(C189<>\"\",MID(C189,FIND(\" \",C189)+1,20),MID(C179,12,20)))","v":""},null,"発電・売電WORK2（発電太陽光）",null,null,null,null,null,null,null," ",null,4,0.75,"-",0.6,"-",0.34,"-",0.23,"-",null,"等級6設計",{"$f":"IF(ISERROR(C212),AA196,IF(C212=\"\",AA196,-LOOKUP(1,-LEFT(MID(C212,1,15),ROW($1:$16)))))","v":0},{"$f":"ROUNDUP((SUM(H8,H9,H10,H11,H12,H13,H16,H19)-SUM(H17))/1000,1)","v":0}]
[null,null,{"$f":"IF(C190<>\"\",MID(C190,FIND(\"★\",SUBSTITUTE(C190,\" \",\"★\",2))+1,20),\"\")","v":""},null,"発電・売電WORK3（売電CGS)",null,null,null,null,null,null,null," ",null,5,0.87,3,0.6,3,0.46,3,0.26,3,null,"等級6基準",{"$f":"IF(ISERROR(C213),AA197,IF(C213=\"\",AA197,-LOOKUP(1,-LEFT(MID(C213,1,15),ROW($1:$16)))))","v":0},{"$f":"ROUNDUP((SUM(J8,J9,J10,J11,J12)*0.8+SUM(H13))/1000,1)","v":0}]
[null,null,{"$f":"IF(C190<>\"\",MID(C190,FIND(\"★\",SUBSTITUTE(C190,\" \",\"★\",3))+1,20),IF(C189<>\"\",MID(C189,FIND(\"★\",SUBSTITUTE(C189,\" \",\"★\",2))+1,20),MID(C180,4,20)))","v":""},null,"発電・売電WORK4（売電太陽光）",null,null,null,null,null,null,null," ",null,6,0.87,2.8,0.6,2.8,0.46,2.8,0.26,2.8]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E183&\"*\",$J$100:$J$499,0)+4,1))","v":""},null,"BEI（V3.3.0以降）",null,null,null,null,null,null,null," ",null,7,0.87,2.7,0.6,2.7,0.46,2.7,0.26,2.7,null,"5-2等級"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E183&\"*\",$J$100:$J$499,0)+5,1))","v":""},null,"BEI（V3.3.0以降）",null,null,null,null,null,null,null," ",null,8,"-",6.7,"-",6.7,"-",5.0999999999999996,"-","-",null,"5-2等級","等級4",{"$f":"IF(Z192<=Z193,\"適合\",\"－\")","v":"適合"},"等級5",{"$f":"IF(Z194<=Z195,\"適合\",\"－\")","v":"適合"},"等級6",{"$f":"IF(Z196<=Z197,\"適合\",\"－\")","v":"適合"}]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E183&\"*\",$J$100:$J$499,0)+6,1))","v":""},null,"BEI（V3.3.0以降）",null,null,null,null,null,null,null," ",null,"-","□","□","□","□","□","□","□","□"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E183&\"*\",$J$100:$J$499,0)+7,1))","v":""},null,"BEI（V3.3.0以降）",null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF(OR(ISERROR(-LOOKUP(1,-LEFT(MID(C183,36,15),ROW($1:$16)))),ISBLANK(J100)),\"\",IF(ABS(-LOOKUP(1,-LEFT(MID(C183,36,15),ROW($1:$16)))-ROUNDUP((SUM(H8:I12)+SUM(H15:I16))/1000,1))>0.5,\"※error\",-LOOKUP(1,-LEFT(MID(C183,36,15),ROW($1:$16)))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C199,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C199,ROW($1:$16))))","v":""},"BEIワーク（省エネ基準：設計）",null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C183,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C183,ROW($1:$16))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C200,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C200,ROW($1:$16))))","v":""},"BEIワーク（省エネ基準：基準）",null,null,null,null,null,null,null," ",null,"太陽光発電容量",null,null,"太陽熱利用の有無"]
[null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C184,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C184,ROW($1:$16))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C201,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C201,ROW($1:$16))))","v":""},"BEIワーク（省エネ基準：BEI）",null,null,null,null,null,null,null," ",null,"その１",{"$f":"IF(ISERROR(C215),0,IF(LEN(C215)<20,0,-LOOKUP(1,-LEFT(MID(C215,20,6),ROW($1:$16)))))","v":0},null,"J.液体集熱",{"$f":"IF(ISERROR(C219),\"無し\",IF(C219=\"\",\"無し\",IF(RIGHT(C219,5)=\"設置しない\",\"無し\",\"有り\")))","v":"無し"}]
[null,null,{"$f":"IF(ISERROR(F163),\"\",IF(D206=\"\",F163,\"\"))","v":0},{"$f":"IF(OR(ISERROR(-LOOKUP(1,-LEFT(MID(C202,17,15),ROW($1:$16)))),ISBLANK(J100)),\"\",IF(ABS(-LOOKUP(1,-LEFT(MID(C202,17,15),ROW($1:$16)))-ROUNDUP((SUM(H8:I12)+SUM(H15:I16))/1000,1))>0.5,\"※error\",-LOOKUP(1,-LEFT(MID(C202,17,15),ROW($1:$16)))))","v":""},"BEIワーク（誘導基準：設計）",null,null,null,null,null,null,null," ",null,"その２",{"$f":"IF(ISERROR(C216),0,IF(LEN(C216)<20,0,-LOOKUP(1,-LEFT(MID(C216,20,6),ROW($1:$16)))))","v":0},null,"K.空気集熱",{"$f":"IF(ISERROR(C220),\"無し\",IF(C220=\"\",\"無し\",IF(RIGHT(C220,5)=\"設置しない\",\"無し\",\"有り\")))","v":"無し"}]
[null,null,{"$f":"IF(ISERROR(ROUNDUP(C206/C204,2)),\"\",IF(D207=\"\",ROUNDUP(C206/C204,2),\"\"))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C202,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C202,ROW($1:$16))))","v":""},"BEIワーク（誘導基準：BEI）",null,null,null,null,null,null,null," ",null,"その３",{"$f":"IF(ISERROR(C217),0,IF(LEN(C217)<20,0,-LOOKUP(1,-LEFT(MID(C217,20,6),ROW($1:$16)))))","v":0},null,"判定",{"$f":"IF(AND(S205=\"無し\",S206=\"無し\"),\"無し\",\"有り\")","v":"無し"}]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E208&\"*\",$J$100:$J$499,0)+8,1))","v":""},null,"２． 判定","等級4設計",null,null,null,null,null,null," ",null,"その４",{"$f":"IF(ISERROR(C218),0,IF(LEN(C218)<20,0,-LOOKUP(1,-LEFT(MID(C218,20,6),ROW($1:$16)))))","v":0}]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E208&\"*\",$J$100:$J$499,0)+9,1))","v":""},null,null,"等級4基準",null,null,null,null,null,null," ",null,"合計",{"$f":"SUM(P205:P208)","v":0}]
[null,null,{"$f":"C208","v":""},null,null,"等級5設計",null,null,null,null,null,null," ",null,"按分合計",{"$f":"ROUND(P209*E6/SUM(E6,J6),2)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF($J$100=\"\",\"\",IF(LEFT(C179,9)=\"太陽光発電(PV)\",INDEX($J$100:$J$499,MATCH(E208&\"*\",$J$100:$J$499,0)+22,1),INDEX($J$100:$J$499,MATCH(E208&\"*\",$J$100:$J$499,0)+13,1)))","v":""},null,null,"等級5基準",null,null,null,null,null,null," "]
[null,null,{"$f":"IF($J$100=\"\",\"\",IF(LEFT(C179,9)=\"太陽光発電(PV)\",INDEX($J$100:$J$499,MATCH(E208&\"*\",$J$100:$J$499,0)+13,1),IF(SUM(H18)=0,C208,IF(SUM(H8,H9,H10,H11,H12,H13:H16,H18)-SUM(H20)>=0,ROUNDUP((SUM(H8,H9,H10,H11,H12,H13:H16,H18)-SUM(H20))/1000,1),ROUNDDOWN((SUM(H8,H9,H10,H11,H12,H13:H16,H18)-SUM(H20))/1000,1)))))","v":""},null,null,"等級6設計",null,null,null,null,null,null," ",null,"更新履歴(V7.0以降)"]
[null,null,{"$f":"IF($J$100=\"\",\"\",IF(LEFT(C179,9)=\"太陽光発電(PV)\",INDEX($J$100:$J$499,MATCH(E208&\"*\",$J$100:$J$499,0)+14,1),ROUNDUP((SUM(J8,J9,J10,J11,J12)*0.8+H13)/1000,1)))","v":""},null,null,"等級6基準",null,null,null,null,null,null," ",null,"ver7.0","2018-07-09","入力項目変更（売電量追加）"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(\"*\"&E214&\"*\",$J$100:$J$499,0),1))","v":""},null,"外皮性能の評価方法",null,null,null,null,null,null,null," ",null,"ver7.1","2018-08-01","一次エネルギー計算結果改訂（V2.4.1以降）に伴う変更"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E215&\"*\",$J$100:$J$499,0),1))","v":""},null,"その1",null,null,null,null,null,null,null," ",null,"ver7.2","2018-10-01","一次エネルギー計算結果改訂（V2.4.2以降）に伴う変更"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E216&\"*\",$J$100:$J$499,0),1))","v":""},null,"その2",null,null,null,null,null,null,null," ",null,"ver8.0","2018-10-05","一次エネルギー計算結果改訂（V2.5以降）に伴う変更"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E217&\"*\",$J$100:$J$499,0),1))","v":""},null,"その3",null,null,null,null,null,null,null," ",null,"ver8.1","2019-10-01","一次エネルギー計算結果改訂（V2.5.1以降）に伴う変更"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E218&\"*\",$J$100:$J$499,0),1))","v":""},null,"その4",null,null,null,null,null,null,null," ",null,"ver8.2","2019-12-16","ZEH Oriented 注記変更"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E219&\"*\",$J$100:$J$499,0),1))","v":""},null,"J.液体集熱",null,null,null,null,null,null,null," ",null,"ver8.3","2020-02-18","地域区分記載改訂（V2.7.2以降)に伴う変更"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E220&\"*\",$J$100:$J$499,0)+3,1))","v":""},null,"K.空気集熱",null,null,null,null,null,null,null," ",null,"ver8.4","2020-05-13","一次エネ計算V2.8.1に対応、住戸名称取得変更"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$499,MATCH(E221&\"*\",$J$100:$J$499,0),1))","v":""},null,"XML ID",null,null,null,null,null,null,null," ",null,"ver8.41","2020-09-29","ZEH Oriented エネルギー削減率表記変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver8.5","2021-04-01","一次エネ計算V3に対応、UA値取得変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.0","2021-08-01","ZEH適合判定条件に太陽光発電有りのチェックを追加"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.2","2022-04-05","PDF表示方式対応、入力・読込修正欄変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.3","2022-06-01","BELS評価書交付プログラムV10.3.0対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.4","2022-07-07","動作改善"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.61","2022-11-07","V3.3.x 対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.62","2023-01-06","等級判定改修（その他含むGJ合計値使用）"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.8","2023-04-03","併用住宅の5-1等級6,7表示対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.9.9","2023-09-22","外皮性能評価手法表示、等級参考表示変更"]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"ver.10.0","2024-02-26","省エネ性能表示対応"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"499行まで非表示"]