{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["戸建用"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":9,"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":500,"n_cols":32,"rows_kept":500,"cut":false,"hidden":false,"merged":[[90,1,91,2],[92,1,95,2],[84,1,84,2],[15,7,15,8],[77,10,77,11],[73,6,73,9],[74,6,74,9],[75,7,75,9],[76,7,76,9],[77,6,77,9],[74,10,74,11],[75,10,75,11],[76,10,76,11],[73,10,73,11],[19,1,19,6],[21,2,21,6],[20,1,27,1],[20,2,20,6],[24,7,24,8],[30,1,30,8],[30,9,30,11],[31,1,31,8],[31,9,31,11],[32,1,32,8],[9,9,9,11],[12,1,12,6],[13,1,13,6],[10,1,10,6],[11,1,11,6],[18,1,18,6],[3,1,3,2],[3,3,3,5],[5,6,5,7],[9,1,9,6],[9,7,9,8],[17,1,17,6],[13,7,13,8],[17,7,17,8],[14,1,14,6],[16,1,16,6],[16,7,16,8],[15,1,15,6],[14,7,14,8],[7,10,7,11],[8,10,8,11],[32,9,32,11],[22,2,22,6],[23,2,23,6],[24,2,24,6],[24,9,27,11],[25,2,25,6],[26,2,26,6],[27,2,27,6],[26,7,26,8],[27,7,27,8],[20,9,23,11],[40,8,40,9],[40,10,40,11],[41,8,41,9],[41,10,41,11],[42,2,42,9],[43,2,43,9],[41,2,41,7],[33,1,33,8],[33,9,33,11],[34,1,34,8],[34,9,34,11],[35,1,35,8],[35,9,35,11],[39,5,39,6],[39,10,39,11],[40,5,40,6],[96,1,97,2],[98,1,99,2],[10,7,10,8],[10,9,10,11],[11,7,11,8],[12,7,12,8],[83,1,83,2],[85,1,85,2],[86,1,86,2],[22,7,22,8],[39,8,39,9],[87,1,89,2],[73,1,74,2],[75,1,76,2],[77,1,78,2],[79,1,80,2],[81,1,82,2],[80,6,83,11],[45,1,48,1],[45,2,47,2],[48,2,48,3],[38,1,43,1],[38,2,38,4],[39,2,40,4],[19,9,19,10],[16,9,18,11],[15,9,15,11],[18,7,18,8],[19,7,19,8],[25,7,25,8],[23,7,23,8],[11,9,11,11],[12,9,12,11],[13,9,13,11],[14,9,14,11],[20,7,20,8],[21,7,21,8]]}
[null,"■一次エネルギー消費量計算書（Ver.9.9)"]
[]
[null,"●設計内容（現況）説明書記載事項"]
[null,"建築物の名称",null,{"$f":"IF(ISERROR(LEFT(C119,(LEN(C119)-8))),\"\",LEFT(C119,(LEN(C119)-8)))","v":""},null,null,"建て方",{"$f":"IF(ISERROR(MID(C119,(LEN(C119)-5),4)),\"\",MID(C119,(LEN(C119)-5),4))","v":""},null,"外皮性能","ＵＡ","ηＡＣ",null,null,"H28年基準","『ＺＥＨ』","国土交通省告示第489号に準拠した計算方法",null,"性能基準"]
[null,"地域区分",null,null,null,null,{"$f":"O10","v":"-"},"地域",null,"設計値",{"$f":"IF(E91=0,\"\",E91)","v":""},{"$f":"IF(E92=0,\"\",E92)","v":""},null,null,"H25年基準","Ｎｅａｒｌｙ　ＺＥＨ","ネット・ゼロ・エネルギー・ハウス支援事業が採用している計算方法",null,"仕様基準"]
[null,"「ＺＥＨマーク」、「ゼロエネ相当」等に関する表示",null,null,null,null,{"$f":"IF(K5=\"\",\"\",IF(AND(E91<=K7,E92<=L6,J33>=20,J36>=100,E98>0),P4,IF(AND(E91<=K7,E92<=L6,J33>=20,J36>=75,J36<100,E98>0),P5,IF(AND(E91<=K6,E92<=L6,J33>=20,J36>=100,J36<>\"\"),P7,IF(AND(E91<=K7,E92<=L6,J33>=20),P9,P8)))))","v":""},null,null,"基準値",{"$f":"IF(ISERROR(VLOOKUP(G5,O11:Q18,2)),\"\",VLOOKUP(G5,O11:Q18,2))","v":""},{"$f":"IF(ISERROR(VLOOKUP(G5,O11:Q18,3)),\"\",VLOOKUP(G5,O11:Q18,3))","v":""},null,null,null,"ＺＥＨ　Ｏｒｉｅｎｔｅｄ",null,{"$f":"IF(G6=P6,\"注釈_ZEH\",IF(G6=P9,\"注釈_記載無し\",\"注釈無し\"))","v":"注釈無し"},"誘導仕様基準"]
[null,"計算対象面積（合計）",null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C121,LEN(C121)-1),ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(LEFT(C121,LEN(C121)-1),ROW($1:$16))))","v":""},"㎡",null,"強化外皮基準",{"$f":"IF(ISERROR(VLOOKUP(G5,O11:R18,4)),\"\",VLOOKUP(G5,O11:R18,4))","v":""},null,null,null,null,"ゼロエネ相当",null,null,"大臣の方法"]
[null,null,null,null,null,null,null,null,null,"外皮評価手法",{"$f":"IF(ISERROR(C165),\"\",IF(MID(C165,14,13)=\"当該住戸の外皮面積を用いて\",S4,IF(MID(C165,14,4)=\"仕様基準\",S5,IF(MID(C165,14,6)=\"誘導仕様基準\",S6,IF(MID(C165,14,13)=\"当該住戸の外皮面積を用いず\",S7,\"\")))))","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,{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(SUBSTITUTE(C120,\"区分\",\"*\",2),FIND(\"*\",SUBSTITUTE(C120,\"区分\",\"*\",2))+1,3),ROW($1:$16)))),\"-\",-LOOKUP(1,-LEFT(MID(SUBSTITUTE(C120,\"区分\",\"*\",2),FIND(\"*\",SUBSTITUTE(C120,\"区分\",\"*\",2))+1,3),ROW($1:$16))))","v":"-"},null,null,{"$f":"IF(ISERROR(VLOOKUP(O10,O11:R18,4)),\"\",VLOOKUP(O10,O11:R18,4))","v":""},null,"省エネ基準",{"$f":"IF(OR(AND(G5>=5,G5<=7,E91<=K6,E92<=L6),AND(G5=8,E92<=L6),AND(G5<=4,E91<=K6)),\"適合\",\"－\")","v":"－"}]
[null,"　暖房設備　  [MJ]",null,null,null,null,null,{"$f":"IF(ISBLANK(E74),\"\",E74)","v":""},null,{"$f":"IF(ISBLANK(E75),\"\",E75)","v":""},null,null,null,null,1,0.46,"-",0.4]
[null,"　冷房設備　  [MJ]",null,null,null,null,null,{"$f":"IF(ISBLANK(E76),\"\",E76)","v":""},null,{"$f":"IF(ISBLANK(E77),\"\",E77)","v":""},null,null,null,null,2,0.46,"-",0.4]
[null,"　換気設備　  [MJ]",null,null,null,null,null,{"$f":"IF(ISBLANK(E78),\"\",E78)","v":""},null,{"$f":"IF(ISBLANK(E79),\"\",E79)","v":""},null,null,null,null,3,0.56000000000000005,"-",0.5]
[null,"　給湯設備　  [MJ]",null,null,null,null,null,{"$f":"IF(ISBLANK(E80),\"\",E80)","v":""},null,{"$f":"IF(ISBLANK(E81),\"\",E81)","v":""},null,null,null,null,4,0.75,"-",0.6]
[null,"　照明設備 　 [MJ]",null,null,null,null,null,{"$f":"IF(ISBLANK(E82),\"\",E82)","v":""},null,{"$f":"IF(ISBLANK(E83),\"\",E83)","v":""},null,null,null,null,5,0.87,3,0.6]
[null,"その他の設備  [MJ]",null,null,null,null,null,{"$f":"IF(ISBLANK(E84),\"\",E84)","v":""},null,{"$f":"IF(ISBLANK(E84),\"\",E84)","v":""},null,null,null,null,6,0.87,2.8,0.6]
[null,"発電設備の発電量のうち自家消費分 [MJ]（太陽光発電）",null,null,null,null,null,{"$f":"IF(COUNTBLANK(E85)=1,\"\",T17)","v":""},null,"発電設備が無い場合は\n０を記入、又は空欄とする",null,null,null,null,7,0.87,2.7,0.6,null,{"$f":"IF(ISNUMBER(E85),E85,0)","v":0},"数値以外の場合は0表記"]
[null,"発電設備の発電量のうち自家消費分　 [MJ]（CGS）",null,null,null,null,null,{"$f":"IF(COUNTBLANK(E86)=1,\"\",T18)","v":""},null,null,null,null,null,null,8,"-",6.7,"-",null,{"$f":"IF(ISNUMBER(E86),E86,0)","v":0},"数値以外の場合は0表記"]
[null,"コージェネ設備の売電量に係る控除量 [MJ]（マイナス値）",null,null,null,null,null,{"$f":"IF(COUNTBLANK(E87)=1,\"\",T19)","v":""},null,null,null,null,null,null,"-","□","□","□",null,{"$f":"IF(ISNUMBER(E87),E87,0)","v":0},"数値以外の場合は0表記"]
[null,"一次エネルギー消費量(その他除く）[GJ]・省エネ基準BEI",null,null,null,null,null,{"$f":"IF(ISBLANK(E88),\"\",E88)","v":""},null,{"$f":"IF(ISBLANK(E89),\"\",E89)","v":""},null,{"$f":"IF(ISBLANK(E90),\"\",E90)","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C133,ROW($1:$16)))),\"\",IF(LEFT(C133,2)=\"合計\",-LOOKUP(1,-LEFT(MID(C133,3,15),ROW($1:$16))),-LOOKUP(1,-RIGHT(LEFT(C133,FIND(\" \",C133)),ROW($1:$16)))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C133,ROW($1:$16)))),\"\",IF(LEFT(C133,2)=\"合計\",\"\",-LOOKUP(1,-RIGHT(C133,ROW($1:$16)))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C133,ROW($1:$16)))),\"\",IF(LEFT(C133,2)=\"合計\",-LOOKUP(1,-RIGHT(C133,ROW($1:$16))),-LOOKUP(1,-LEFT(MID(C133,FIND(\" \",C133)+1,15),ROW($1:$16)))))","v":""},"設計合計MJ（PV、CGS）／設計合計MJ（CGS）／基準合計MJ"]
[null,"参考値"," 消費電力量　　  [kWh]",null,null,null,null,{"$f":"IF(ISBLANK(E93),\"\",E93)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(E93),E93,0)","v":0},"数値以外の場合は0表記"]
[null,null,"ガス消費量 　　 [MJ]",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,"数値以外の場合は0表記"]
[null,null,"灯油消費量 　　 [MJ]",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,"数値以外の場合は0表記"]
[null,null,"コージェネ設備の売電量に係るガス消費量の控除量　[MJ]",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,"数値以外の場合は0表記"]
[null,null,"発電量(コージェネレーション) [MJ]",null,null,null,null,"",null,"発電設備が無い場合は\n０を記入、又は空欄とする",null,null,null,null,null,null,null,null,null,0,"数値以外の場合は0表記"]
[null,null,"発電量(太陽光発電)　　　　　 [MJ]",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,"数値以外の場合は0表記"]
[null,null,"売電量(コージェネレーション) [MJ]",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,"数値以外の場合は0表記"]
[null,null,"売電量(太陽光発電)　　　　　 [MJ]",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0,"数値以外の場合は0表記"]
[]
[null,"●計算結果・設計内容（現況）説明書記載事項"]
[null,"再生可能エネルギーを除いた設計一次エネルギー消費量（その他除く） GJ/年",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F114),\"\",F114)","v":""},null,null,null,null,{"$f":"Q4","v":"国土交通省告示第489号に準拠した計算方法"}]
[null,"再生可能エネルギーを除いた一次エネルギー消費削減量（その他除く） GJ/年",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(E89-F114),\"\",E89-F114)","v":""},null,null,null,null,"告示準拠","ZEH"]
[null,"再生可能エネルギーを除いた一次エネルギー消費量（その他除く）の削減率　　％",null,null,null,null,null,null,null,{"$f":"IF(O31=Q4,O33,IF(O31=Q5,P33,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISERROR((E89-F114)/E89),\"\",IF(J32>=0,ROUNDDOWN((E89-F114)/E89*100,0),ROUNDUP((E89-F114)/E89*100,0)))","v":""},{"$f":"IF(ISERROR((E105-E104+E110)/E105),\"\",IF((E105-E104+E110)>=0,ROUNDDOWN((E105-E104+E110)/E105*100,1),ROUNDUP((E105-E104+E110)/E105*100,1)))","v":""}]
[null,"再生可能エネルギーを加えた設計一次エネルギー消費量（その他除く） GJ/年",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F115),\"\",F115)","v":""}]
[null,"再生可能エネルギーを加えた一次エネルギー消費削減量（その他除く） GJ/年",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(E89-F115),\"\",E89-F115)","v":""}]
[null,"再生可能エネルギーを加えた一次エネルギー消費量（その他除く）の削減率　　％",null,null,null,null,null,null,null,{"$f":"IF(O31=Q4,O36,IF(O31=Q5,P36,\"\"))","v":""},null,null,null,null,{"$f":"IF(ISERROR((E89-F115)/E89),\"\",IF(J35>=0,ROUNDDOWN((E89-F115)/E89*100,0),ROUNDUP((E89-F115)/E89*100,0)))","v":""},{"$f":"IF(ISERROR((E105-E104+E111)/E105),\"\",IF((E105-E104+E111)>=0,ROUNDDOWN((E105-E104+E111)/E105*100,1),ROUNDUP((E105-E104+E111)/E105*100,1)))","v":""}]
[]
[null,"●評価書プレビュー"]
[null,"一面","BEIの値（削減率）",null,null,{"$f":"E90","v":""},{"$f":"IF(F39=\"\",\"\",\"(\"&ROUND((1-F39)*100,0)&\"%削減)\")","v":""},{"$f":"IF(COUNTBLANK(F39)=1,\"\",IF(U10<>\"適合\",\"－\",IF(F39<=0.8,\"☆☆☆☆☆\",IF(AND(F39>0.8,F39<=0.85),\"☆☆☆☆\",IF(AND(F39>0.85,F39<=0.9),\"☆☆☆\",IF(AND(F39>0.9,F39<=1),\"☆☆\",IF(AND(F39>1,F39<=1.1),\"☆\",\"－\")))))))","v":""}]
[null,null,"単位面積当たりの\n一次エネルギー消費量(MJ/㎡・年)",null,null,"設計値（その他除く）",null,{"$f":"IF(G7=\"\",\"\",ROUNDUP(E88*1000/G7,0))","v":""},"設計値（その他含む）",null,{"$f":"IF(G7=\"\",\"\",ROUNDUP((H113*1000)/G7,0))","v":""}]
[null,null,null,null,null,"基準値（その他除く）",null,{"$f":"IF(G7=\"\",\"\",ROUNDUP(E89*1000/G7,0))","v":""},"基準値（その他含む）",null,{"$f":"IF(G7=\"\",\"\",ROUNDUP(H105*1000/G7,0))","v":""}]
[null,null,"「ＺＥＨマーク」、「ゼロエネ相当」、「ZEH-Mマーク」に関する事項　／　判定",null,null,null,null,null,{"$f":"IF(G6=\"\",\"\",G6)","v":""},null,{"$f":"IF(ISERROR(IF(OR(G6=\"\",G5=\"-\",G5=\"\",E91=\"\",E92=\"\",J33=\"\",J36=\"\"),\"\",IF(OR(AND(G6=P4,E91<=K7,E92<=L6,K43>=20,K44>=100),AND(G6=P5,E91<=K7,E92<=L6,K43>=20,K44>=75,K44<100),AND(G6=P6,E91<=K7,E92<=L6,K43>=20),AND(G6=P7,E91<=K6,E92<=L6,K43>=20,K44>=100)),\"適合\",\"－\"))),\"－\",IF(OR(G6=\"\",G5=\"-\",G5=\"\",E91=\"\",E92=\"\",J33=\"\",J36=\"\"),\"\",IF(OR(AND(G6=P4,E91<=K7,E92<=L6,K43>=20,K44>=100,E98>0),AND(G6=P5,E91<=K7,E92<=L6,K43>=20,K44>=75,K44<100,E98>0),AND(G6=P6,E91<=K7,E92<=L6,K43>=20),AND(G6=P7,E91<=K6,E92<=L6,K43>=20,K44>=100)),\"適合\",\"－\")))","v":""}]
[null,null,"再生可能エネルギーを除いた設計一次エネルギー消費量の基準一次エネルギー消費量からの削減率",null,null,null,null,null,null,null,{"$f":"J33","v":""},"%削減"]
[null,null,"再生可能エネルギーを加えた設計一次エネルギー消費量の基準一次エネルギー消費量からの削減率",null,null,null,null,null,null,null,{"$f":"IF(I42=P6,\"\",J36)","v":""},"%削減"]
[]
[null,"二面","住戸部分","設備項目","冷房設備","暖房設備","換気設備","照明設備","給湯設備","効率化設備"]
[null,null,null,"設計値",{"$f":"IF(G7=\"\",\"\",ROUND(H12/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(H11/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(H13/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(H15/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(H14/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",IF(LEFT(C133,2)=\"合計\",ROUND((T18*(-1)+T19*(-1))/G7,2),ROUND((T17*(-1)+T18*(-1)+T19*(-1))/G7,2)))","v":""}]
[null,null,null,"基準値",{"$f":"IF(G7=\"\",\"\",ROUND(J12/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(J11/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(J13/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(J15/G7,2))","v":""},{"$f":"IF(G7=\"\",\"\",ROUND(J14/G7,2))","v":""}]
[null,null,"二次エネルギー（設計値）",null,"電気",{"$f":"T21","v":0},"ガス",{"$f":"T22-T24","v":0},"灯油",{"$f":"T23","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"●一次エネルギー計算結果　入力・読込修正欄",null,null,null,null,"●参考情報　品確法 5-1、5-2 等級判定"]
[null,"暖房",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C122,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C122,5,15),ROW($1:$16))))","v":""},null,"5-1　等級　（4・5・6・7）",null,null,null,{"$f":"IF(G5=\"-\",\"\",IF(X103=\"適合\",7,IF(V103=\"適合\",6,IF(T103=\"適合\",5,IF(R103=\"適合\",4,\"－\")))))","v":""}]
[null,null,null,"基準",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C122,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C122,ROW($1:$16))))","v":""},null,"5-2　等級　（4・5・6）",null,null,null,{"$f":"IF(AA104=0,\"\",IF(AF112=\"適合\",6,IF(AD112=\"適合\",5,IF(AB112=\"適合\",4,\"－\"))))","v":""}]
[null,"冷房",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C123,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C123,5,15),ROW($1:$16))))","v":""},null,{"$f":"IF(K75=\"\",\"\",K75)","v":""},"基準一次エネルギー　[GJ]",null,null,{"$f":"IF(K75=6,AA109,IF(K75=5,AA107,IF(K75=4,AA105,\"\")))","v":""}]
[null,null,null,"基準",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C123,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C123,ROW($1:$16))))","v":""},null,{"$f":"IF(K75=\"\",\"\",K75)","v":""},"設計一次エネルギー　[GJ]",null,null,{"$f":"IF(K75=6,AA108,IF(K75=5,AA106,IF(K75=4,AA104,\"\")))","v":""}]
[null,"換気",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C124,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C124,5,15),ROW($1:$16))))","v":""},null,"設計一次エネルギー表示値　[MJ/㎡・年]",null,null,null,{"$f":"IF(OR(K77=\"\",G7=\"\"),\"\",IF(K75=6,ROUNDUP(K77*1000/G7,0),\"－\"))","v":""}]
[null,null,null,"基準",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C124,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C124,ROW($1:$16))))","v":""}]
[null,"給湯",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C125,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C125,5,15),ROW($1:$16))))","v":""},null,"【本計算書の使用方法と注意事項】"]
[null,null,null,"基準",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C125,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C125,ROW($1:$16))))","v":""},null,"本計算書を添付することで、設計内容説明書 第二面の数値記入を省略することができます。計算結果や評価書プレビューの数値は端数処理や審査によって数値が変更になる可能性があります。"]
[null,"照明",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C126,5,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C126,5,15),ROW($1:$16))))","v":""}]
[null,null,null,"基準",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C126,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C126,ROW($1:$16))))","v":""}]
[null,"その他",null,"基準・設計",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(MID(C127,7,15),ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(MID(C127,7,15),ROW($1:$16))))","v":""}]
[null,"自家消費　PV",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C130,LEN(C130)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(C130,LEN(C130)-3),3)=\"---\",\"\",LOOKUP(1,-RIGHT(LEFT(C130,LEN(C130)-3),ROW($1:$16)))))","v":""},null,"【本計算書の作成方法】"]
[null,"自家消費 CGS",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C131,LEN(C131)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(C131,LEN(C131)-3),3)=\"---\",\"\",LOOKUP(1,-RIGHT(LEFT(C131,LEN(C131)-3),ROW($1:$16)))))","v":""},null,"1．下部のマクロボタンにより住戸の一次エネルギー消費量計算結果"]
[null,"コージェネ控除量",null,"設計",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C132,LEN(C132)-3),ROW($1:$16)))),\"\",IF(RIGHT(LEFT(C132,LEN(C132)-3),3)=\"---\",\"\",LOOKUP(1,-RIGHT(LEFT(C132,LEN(C132)-3),ROW($1:$16)))))","v":""},null,"　　（住宅版）のPDFデータを読込む。(※)"]
[null,"ＢＥＩ\n（省エネ基準）",null,"設計(GJ・年)",{"$f":"IF(SUM(C154:D154)=0,\"\",SUM(C154:D154))","v":""},null,"2．「ＺＥＨマーク」、「ゼロエネ相当」等に関する表示について確認する。"]
[null,null,null,"基準(GJ・年)",{"$f":"IF(SUM(C155:D155)=0,\"\",SUM(C155:D155))","v":""},null,"※　エネルギー計算結果PDFデータが読み込めないときは、"]
[null,null,null,"ＢＥＩ",{"$f":"IF(SUM(C156:D156)=0,\"\",SUM(C156:D156))","v":""},null,"　　「●設計内容（現況）説明書記載事項 」及び"]
[null,"外皮",null,"UA値",{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(LEFT(C136,LEN(C136)-5),ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(LEFT(C136,LEN(C136)-5),ROW($1:$16))))","v":""},null,"　　「●一次エネルギー計算結果　入力・読込修正欄 」の"]
[null,null,null,"ηＡＣ値",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C137,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C137,ROW($1:$16))))","v":""},null,"　　黄色の着色セルにPDFの該当のデータを入力してください。"]
[null,"二次\nエネルギー\n（設計値）",null,"電気",{"$f":"IF(ISERROR(-LOOKUP(1,-LEFT(C142,ROW($1:$16)))),\"\",-LOOKUP(1,-LEFT(C142,ROW($1:$16))))","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,"5-1work",null,null,null,null,null,null,null,null,null,"5-2work"]
[null,null,null,null,"MJ","GJ","MJ","GJ",null,null,null,null,null,null,null,"地域区分","5-1等級4",{"$f":"IF(OR(AND(G5>=5,G5<=7,E91<=Q104,E92<=R104),AND(G5=8,E92<=R104),AND(G5<=4,E91<=Q104)),\"適合\",\"－\")","v":"－"},"5-1等級5",{"$f":"IF(OR(AND(G5>=5,G5<=7,E91<=S104,E92<=T104),AND(G5=8,E92<=T104),AND(G5<=4,E91<=S104)),\"適合\",\"－\")","v":"－"},"5-1等級6",{"$f":"IF(OR(AND(G5>=5,G5<=7,E91<=U104,E92<=V104),AND(G5=8,E92<=V104),AND(G5<=4,E91<=U104)),\"適合\",\"－\")","v":"－"},"5-1等級7",{"$f":"IF(OR(AND(G5>=5,G5<=7,E91<=W104,E92<=X104),AND(G5<=4,E91<=W104)),\"適合\",\"－\")","v":"－"},null,"GJ合計値抽出","読込","計算"]
[null,null,"合計","設計",{"$f":"H11+H12+H13+H14+H15","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"G5","v":"-"},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,2))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,3))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,4))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,5))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,6))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,7))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,8))","v":""},{"$f":"IF(ISERROR(VLOOKUP(P104,P105:X112,4)),\"\",VLOOKUP(P104,P105:X112,9))","v":""},null,"等級4設計",{"$f":"IF(C159=\"\",AB104,-LOOKUP(1,-LEFT(MID(C159,1,15),ROW($1:$16))))","v":0},{"$f":"ROUNDUP(SUM(E74,E76,E78,E80,E82,E84,E85,E86,E87)/1000,1)","v":0}]
[null,null,null,"基準",{"$f":"J11+J12+J13+J14+J15","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(E105/1000,1)","v":{"$error":"#VALUE!"}},{"$f":"E105+E84","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(G105/1000,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,1,0.46,"-",0.4,"-",0.28000000000000003,"-",0.2,"-",null,"等級4基準",{"$f":"IF(C160=\"\",AB105,-LOOKUP(1,-LEFT(MID(C160,1,15),ROW($1:$16))))","v":0},{"$f":"ROUNDUP(SUM(E75,E77,E79,E81,E83,E84)/1000,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.46,"-",0.4,"-",0.28000000000000003,"-",0.2,"-",null,"等級5設計",{"$f":"IF(C161=\"\",AB106,-LOOKUP(1,-LEFT(MID(C161,1,15),ROW($1:$16))))","v":0},{"$f":"ROUNDUP(SUM(E74,E76,E78,E80,E82,E84,E85,E86,E87)/1000,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.56000000000000005,"-",0.5,"-",0.28000000000000003,"-",0.2,"-",null,"等級5基準",{"$f":"IF(C162=\"\",AB107,IF(LEFT(C130,9)=\"太陽光発電(PV)\",-LOOKUP(1,-LEFT(MID(C162,10,15),ROW($1:$16))),-LOOKUP(1,-LEFT(MID(C162,12,15),ROW($1:$16)))))","v":0},{"$f":"ROUNDUP((SUM(E75,E77,E79,E81,E83)*0.9+SUM(E84))/1000,1)","v":0}]
[null,null,null,null,"MJ",null,null,null,null,null,null,null,null,null,null,4,0.75,"-",0.6,"-",0.34,"-",0.23,"-",null,"等級6設計",{"$f":"IF(C163=\"\",AB108,-LOOKUP(1,-LEFT(MID(C163,1,15),ROW($1:$16))))","v":0},{"$f":"ROUNDUP((SUM(E74,E76,E78,E80,E82,E84,E87,E99)-SUM(E97))/1000,1)","v":0}]
[null,null,"自家消費＋CGS売電控除",null,{"$f":"IF(ISBLANK(E86),\"\",T17*(-1)+T18*(-1)+T19*(-1))","v":0},null,null,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(C164=\"\",AB109,-LOOKUP(1,-LEFT(MID(C164,1,15),ROW($1:$16))))","v":0},{"$f":"ROUNDUP((SUM(E75,E77,E79,E81,E83)*0.8+SUM(E84))/1000,1)","v":0}]
[null,null,"CGS発電量＋売電控除",null,{"$f":"IF(ISBLANK(E97),\"\",T25-T27+T19*(-1))","v":0},null,null,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,"総発電量(ｺｰｼﾞｪﾈ＋太陽）",null,{"$f":"IF(ISBLANK(E98),\"\",T25+T26)","v":0},null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"-",6.7,"-",6.7,"-",5.0999999999999996,"-","-",null,"5-2等級","等級4",{"$f":"IF(AA104<=AA105,\"適合\",\"－\")","v":"適合"},"等級5",{"$f":"IF(AA106<=AA107,\"適合\",\"－\")","v":"適合"},"等級6",{"$f":"IF(AA108<=AA109,\"適合\",\"－\")","v":"適合"}]
[null,null,"設計一次エネ",null,{"$f":"E$104-E109","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(E113/1000,1)","v":{"$error":"#VALUE!"}},{"$f":"E113+E84","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(G113/1000,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"-","□","□","□","□","□","□","□","□"]
[null,null,null,"再除",{"$f":"E$104-E110","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(E114/1000,1)","v":{"$error":"#VALUE!"}}]
[null,null,null,"再含",{"$f":"E$104-E111","v":{"$error":"#VALUE!"}},{"$f":"IF(E115<0,ROUNDDOWN(E115/1000,1),ROUNDUP(E115/1000,1))","v":{"$error":"#VALUE!"}}]
[]
[null,null,"抽出結果",null,"抽出文字列"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E118&\"*\",$J$100:$J$465,0),1))","v":""},null,"(1)住宅"]
[null,null,{"$f":"IF(C118<>\"\",MID(C118,FIND(\"(建て方)\",C118)+6,LEN(C118)),\"\")","v":""},null,"住宅名称WORK"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E120&\"*\",$J$100:$J$465,0),1))","v":""},null,"(3)地域の区分"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E121&\"*\",$J$100:$J$465,0)+1,1))","v":""},null,"(2)床面積"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$4965,MATCH(E122&\"*\",$J$100:$J$465,0),1))","v":""},null,"暖房設備"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E123&\"*\",$J$100:$J$465,0),1))","v":""},null,"冷房設備"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E124&\"*\",$J$100:$J$465,0),1))","v":""},null,"換気設備"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E125&\"*\",$J$100:$J$465,0),1))","v":""},null,"給湯設備"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E126&\"*\",$J$100:$J$465,0),1))","v":""},null,"照明設備"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E127&\"*\",$J$100:$J$465,0),1))","v":""},null,"その他の設備"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E127&\"*\",$J$100:$J$465,0)+1,1))","v":""},null,"　","自家消費量"]
[]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E130&\"*\",$J$100:$J$465,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E130&\"*\",$J$100:$J$465,0),1)))","v":""},null,"太陽光発電(PV)"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E132&\"*\",$J$100:$J$465,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E132&\"*\",$J$100:$J$465,0)-1,1)))","v":""}]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E132&\"*\",$J$100:$J$465,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E132&\"*\",$J$100:$J$465,0),1)))","v":""},null,"コージェネレーション設備の売電量に係る控除量"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E132&\"*\",$J$100:$J$465,0),1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E132&\"*\",$J$100:$J$465,0)+1,1)))","v":""},null,"MJ合計"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E134&\"*\",$J$100:$J$465,0),1))","v":""},null,"一次エネルギー消費量(その他除く)"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E135&\"*\",$J$100:$J$465,0),1))","v":""},null,"BEI "]
[null,null,{"$f":"IF(RIGHT(D136,1)=\"）\",LEFT(D136,FIND(\"（\",D136)-2),D136)","v":""},{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E136&\"*\",$J$100:$J$465,0),1))","v":""},"外皮平均熱貫流率"]
[null,null,{"$f":"MID(D137,FIND(\"ηAC\",D137)+6,3)","v":{"$error":"#VALUE!"}},{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E137&\"*\",$J$100:$J$465,0),1))","v":""},"平均日射熱取得率"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E138&\"*\",$J$100:$J$465,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E138&\"*\",$J$100:$J$465,0)+1,1)))","v":""},null,"消費電力量[kWh] *1 ガス消費量[MJ] 灯油消費量[MJ] 相当値[MJ] *2"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E139&\"*\",$J$100:$J$465,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E139&\"*\",$J$100:$J$465,0)+1,1)))","v":""},null,"消費電力量[kWh] *1 ガス消費量[MJ] 灯油消費量[MJ]"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E140&\"*\",$J$100:$J$465,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E140&\"*\",$J$100:$J$465,0)+1,1)))","v":""},null,"発電量（コージェネレーション）[MJ] 発電量（太陽光発電）[MJ] 売電量[MJ]"]
[null,null,{"$f":"IF(ISERROR(INDEX($J$100:$J$465,MATCH(E141&\"*\",$J$100:$J$465,0)+1,1)),\"\",IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E141&\"*\",$J$100:$J$465,0)+1,1)))","v":""},null,"コージェネレーション太陽光発電コージェネレーション太陽光発電"]
[null,null,{"$f":"IF(C139<>\"\",C139,\"\")","v":""},null,"消費電力量WORK"]
[null,null,{"$f":"IF(C139<>\"\",MID(C139,FIND(\" \",C139)+1,20),\"\")","v":""},null,"ガス消費量WORK"]
[null,null,{"$f":"IF(C139<>\"\",MID(C139,FIND(\"★\",SUBSTITUTE(C139,\" \",\"★\",2))+1,20),\"\")","v":""},null,"灯油消費量WORK"]
[null,null,{"$f":"IF(AND(C139<>\"\",C138=\"\"),MID(C139,FIND(\"★\",SUBSTITUTE(C139,\" \",\"★\",3))+1,20),\"\")","v":""},null,"コージェネ売電ガス控除量WORK"]
[null,null,{"$f":"IF(C141<>\"\",C141,IF(C140<>\"\",C140,MID(C129,17,20)))","v":""},null,"発電・売電WORK1（発電CGS）"]
[null,null,{"$f":"IF(C141<>\"\",MID(C141,FIND(\" \",C141)+1,20),IF(C140<>\"\",MID(C140,FIND(\" \",C140)+1,20),MID(C130,12,20)))","v":""},null,"発電・売電WORK2（発電太陽光）"]
[null,null,{"$f":"IF(C141<>\"\",MID(C141,FIND(\"★\",SUBSTITUTE(C141,\" \",\"★\",2))+1,20),\"\")","v":""},null,"発電・売電WORK3（売電CGS)"]
[null,null,{"$f":"IF(C141<>\"\",MID(C141,FIND(\"★\",SUBSTITUTE(C141,\" \",\"★\",3))+1,20),IF(C140<>\"\",MID(C140,FIND(\"★\",SUBSTITUTE(C140,\" \",\"★\",2))+1,20),MID(C131,4,20)))","v":""},null,"発電・売電WORK4（売電太陽光）"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E134&\"*\",$J$100:$J$465,0)+4,1))","v":""},null,"BEI（V3.3.0以降）"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E134&\"*\",$J$100:$J$465,0)+5,1))","v":""},null,"BEI（V3.3.0以降）"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E134&\"*\",$J$100:$J$465,0)+6,1))","v":""},null,"BEI（V3.3.0以降）"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E134&\"*\",$J$100:$J$465,0)+7,1))","v":""},null,"BEI（V3.3.0以降）"]
[null,null,{"$f":"IF(OR(ISERROR(-LOOKUP(1,-LEFT(MID(C134,36,15),ROW($1:$16)))),ISBLANK(J100)),\"\",IF(ABS(-LOOKUP(1,-LEFT(MID(C134,36,15),ROW($1:$16)))-ROUNDUP((SUM(H11:I15)+SUM(H18:I19))/1000,1))>0.5,\"※error\",-LOOKUP(1,-LEFT(MID(C134,36,15),ROW($1:$16)))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C150,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C150,ROW($1:$16))))","v":""},"BEIワーク（省エネ基準：設計）"]
[null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C134,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C134,ROW($1:$16))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C151,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C151,ROW($1:$16))))","v":""},"BEIワーク（省エネ基準：基準）"]
[null,null,{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C135,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C135,ROW($1:$16))))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C152,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C152,ROW($1:$16))))","v":""},"BEIワーク（省エネ基準：BEI）"]
[null,null,{"$f":"IF(ISERROR(F114),\"\",IF(D157=\"\",F114,\"\"))","v":""},{"$f":"IF(OR(ISERROR(-LOOKUP(1,-LEFT(MID(C153,17,15),ROW($1:$16)))),ISBLANK(J100)),\"\",IF(ABS(-LOOKUP(1,-LEFT(MID(C153,17,15),ROW($1:$16)))-ROUNDUP((SUM(H11:I15)+SUM(H18:I19))/1000,1))>0.5,\"※error\",-LOOKUP(1,-LEFT(MID(C153,17,15),ROW($1:$16)))))","v":""},"BEIワーク（誘導基準：設計）"]
[null,null,{"$f":"IF(ISERROR(ROUNDUP(C157/C155,2)),\"\",IF(D158=\"\",ROUNDUP(C157/C155,2),\"\"))","v":""},{"$f":"IF(ISERROR(-LOOKUP(1,-RIGHT(C153,ROW($1:$16)))),\"\",-LOOKUP(1,-RIGHT(C153,ROW($1:$16))))","v":""},"BEIワーク（誘導基準：BEI）"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E159&\"*\",$J$100:$J$465,0)+8,1))","v":""},null,"２． 判定","等級4設計"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(E159&\"*\",$J$100:$J$465,0)+9,1))","v":""},null,null,"等級4基準"]
[null,null,{"$f":"C159","v":""},null,null,"等級5設計"]
[null,null,{"$f":"IF($J$100=\"\",\"\",IF(LEFT(C130,9)=\"太陽光発電(PV)\",INDEX($J$100:$J$465,MATCH(E159&\"*\",$J$100:$J$465,0)+22,1),INDEX($J$100:$J$465,MATCH(E159&\"*\",$J$100:$J$465,0)+13,1)))","v":""},null,null,"等級5基準"]
[null,null,{"$f":"IF($J$100=\"\",\"\",IF(LEFT(C130,9)=\"太陽光発電(PV)\",INDEX($J$100:$J$465,MATCH(E159&\"*\",$J$100:$J$465,0)+13,1),IF(SUM(E98)=0,C159,IF(SUM(E74,E76,E78,E80,E82,E84:E87,E98)-SUM(E100)>=0,ROUNDUP((SUM(E74,E76,E78,E80,E82,E84:E87,E98)-SUM(E100))/1000,1),ROUNDDOWN((SUM(E74,E76,E78,E80,E82,E84:E87,E98)-SUM(E100))/1000,1)))))","v":""},null,null,"等級6設計"]
[null,null,{"$f":"IF($J$100=\"\",\"\",IF(LEFT(C130,9)=\"太陽光発電(PV)\",INDEX($J$100:$J$465,MATCH(E159&\"*\",$J$100:$J$465,0)+14,1),ROUNDUP((SUM(E75,E77,E79,E81,E83)*0.8+E84)/1000,1)))","v":""},null,null,"等級6基準"]
[null,null,{"$f":"IF($J$100=\"\",\"\",INDEX($J$100:$J$465,MATCH(\"*\"&E165&\"*\",$J$100:$J$465,0),1))","v":""},null,"外皮性能の評価方法"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"更新履歴(V7.0以降)"]
[null,null,"ver7.0","2018-07-09","入力項目変更（売電量追加）"]
[null,null,"ver7.1","2018-08-01","一次エネルギー計算結果改訂（V2.4.1以降）に伴う変更"]
[null,null,"ver7.2","2018-10-01","一次エネルギー計算結果改訂（V2.4.2以降）に伴う変更"]
[null,null,"ver8.0","2018-10-05","一次エネルギー計算結果改訂（V2.5以降）に伴う変更"]
[null,null,"ver8.1","2019-10-01","一次エネルギー計算結果改訂（V2.5.1以降）に伴う変更"]
[null,null,"ver8.2","2019-12-16","ZEH Oriented 注記変更"]
[null,null,"ver8.3","2020-02-18","地域区分記載改訂（V2.7.2以降)に伴う変更"]
[null,null,"ver8.4","2020-05-13","一次エネ計算V2.8.1に対応、住戸名称取得変更"]
[null,null,"ver8.41","2020-09-29","ZEH Oriented エネルギー削減率表記変更"]
[null,null,"ver8.5","2021-04-01","一次エネ計算V3に対応、UA値取得変更"]
[null,null,"ver.9.0","2021-08-01","ZEH適合判定条件に太陽光発電有りのチェックを追加"]
[null,null,"ver.9.2","2022-04-05","PDF表示方式対応、入力・読込修正欄変更"]
[null,null,"ver.9.3","2022-06-01","BELS評価書交付プログラムV10.3.0対応"]
[null,null,"ver.9.4","2022-07-07","動作改善"]
[null,null,"ver.9.61","2022-11-07","V3.3.x 対応"]
[null,null,"ver.9.62","2023-01-06","等級判定改修（その他含むGJ合計値使用）"]
[null,null,"ver.9.8","2023-04-03","併用住宅の5-1等級6,7表示対応"]
[null,null,"ver.9.9","2023-09-22","外皮性能評価手法表示、等級参考表示変更"]