{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["判断シート","軽微な変更に該当する項目","マクロの有効化"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":40,"n_cols":78,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,18,3,56],[35,25,35,31],[35,32,35,38],[35,39,35,45],[35,2,35,24],[30,5,30,7],[30,23,30,25],[31,5,31,7],[34,25,34,31],[34,32,34,38],[34,39,34,45],[27,25,27,31],[27,32,27,38],[27,39,27,45],[28,32,28,38],[28,39,28,45],[28,25,28,31],[38,2,38,4],[26,8,26,62],[23,18,23,24],[23,25,23,31],[33,2,33,4],[23,39,23,45],[24,39,24,45],[19,18,19,24],[19,25,19,31],[19,32,19,38],[22,2,22,4],[26,2,26,4],[23,32,23,38],[24,18,24,24],[24,25,24,31],[24,32,24,38],[16,32,16,38],[16,39,16,45],[16,46,16,52],[17,39,17,45],[17,46,19,52],[18,39,18,45],[19,39,19,45],[17,32,17,38],[18,32,18,38],[16,18,16,24],[16,25,16,31],[17,18,17,24],[17,25,17,31],[18,18,18,24],[18,25,18,31],[1,1,1,62],[11,25,11,31],[12,25,12,31],[13,25,13,31],[10,25,10,31],[10,32,10,38],[11,32,11,38],[12,32,12,38],[6,18,6,24],[7,18,7,20],[7,28,7,30],[5,18,5,24],[13,32,13,38],[10,39,10,45],[11,39,11,45],[12,39,12,45],[11,18,11,24],[12,18,12,24],[10,46,10,52],[11,46,13,52],[13,18,13,24],[10,18,10,24],[13,39,13,45],[6,27,6,30],[6,44,6,49],[6,50,6,56],[4,18,4,30],[4,31,4,36],[4,37,4,43],[4,44,4,49],[4,50,4,56]]}
[]
[null,"住宅の軽微変更ルートBの適用判断シート"]
[]
[null,null,"物件名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,5,null,6,null,7]
[null,null,"対象業務",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"省エネ適判",null,null,null,null,null,null,null,null,null,null,null,null,"断熱等級",null,null,null,null,null,null,null,null,null,null,null,null,"一次エネ等級",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UA","ηAC","UA","ηAC","UA","ηAC","UA","ηAC"]
[null,null,"省エネ地域区分",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"地域",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.46,null,0.4,null,0.28000000000000003,null,0.2]
[null,null,"変更前のBEI",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(S5=\"\",\"\",IF(S5=\"省エネ適判\",0.9,IF(AND(S5=\"住宅性能評価（長期含む）\",AY5=4),0.9,IF(AND(S5=\"住宅性能評価（長期含む）\",AY5=5),0.81,IF(AND(S5=\"住宅性能評価（長期含む）\",AY5=6),0.72,\"\")))))","v":0.9},null,null,null,"※共同の場合は住棟BEIを入力",null,null,null,null,null,null,null,null,null,null,null,null,"判定",null,null,null,null,null,{"$f":"IF(S7=\"\",\"\",IF(S7<=AB7,\"OK\",\"NG\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.46,null,0.4,null,0.28000000000000003,null,0.2]
[null,null,"ルートBの適用項目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"床面積",null,null,null,null,null,null,null,null,null,"外皮",null,null,null,null,"いずれかを選択",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"グレーアウトのセルは記入しないでください。",null,null,3,0.56000000000000005,null,0.5,null,0.28000000000000003,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.75,null,0.6,null,0.34,null,0.23]
[null,null,"イ　床面積",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.87,3,0.6,3,0.46,3,0.26,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変更前面積",null,null,null,null,null,null,"変更後面積",null,null,null,null,null,null,"変更割合",null,null,null,null,null,null,"判定",null,null,null,null,null,null,"ルートB適用判定",null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,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(OR(S12=\"\",Z12=\"\"),\"\",(Z12-S12)/S12*100)","v":""},null,null,null,null,null,null,{"$f":"IF(AG12=\"\",\"\",IF(OR(AG12>10,AG12<-10),\"NG\",\"OK\"))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(AN12=\"\",AN13=\"\",AN14=\"\"),\"\",IF(AND(AN12=\"OK\",AN13=\"OK\",AN14=\"OK\"),\"OK\",\"NG\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,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,null,"その他の居室",null,null,null,null,null,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(OR(S13=\"\",Z13=\"\"),\"\",(Z13-S13)/S13*100)","v":""},null,null,null,null,null,null,{"$f":"IF(AG13=\"\",\"\",IF(OR(AG13>10,AG13<-10),\"NG\",\"OK\"))","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,8,null,6.7,null,6.7,null,5.0999999999999996]
[null,null,"非居室",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"✓"]
[null,null,"ロ　外皮"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変更前",null,null,null,null,null,null,"変更後",null,null,null,null,null,null,"判断基準値",null,null,null,null,null,null,"判定",null,null,null,null,null,null,"ルートB適用判定"]
[null,null,"外皮面積の合計",null,null,null,null,null,null,null,null,null,null,null,null,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(OR(S18=\"\",Z18=\"\"),\"\",IF(S18=Z18,\"OK\",\"NG\"))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(AN18=\"\",AN19=\"\",AN20=\"\"),\"\",IF(AND(AN18=\"OK\",AN19=\"OK\",AN20=\"OK\"),\"OK\",\"NG\"))","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(S19=\"\",\"\",IF(S6=8,\"―\",IF(OR(AL5=4,AL5=\"\"),ROUNDUP(0.9*VLOOKUP(S6,BR6:BT13,2,FALSE),2),IF(AL5=5,ROUNDUP(0.9*VLOOKUP(S6,BR6:BV13,4,FALSE),2),IF(AL5=6,ROUNDUP(0.9*VLOOKUP(S6,BR6:BX13,6,FALSE),2),IF(AL5=7,ROUNDUP(0.9*VLOOKUP(S6,BR6:BZ13,8,FALSE),2),\"\"))))))","v":""},null,null,null,null,null,null,{"$f":"IF(S19=\"\",\"\",IF(S19<=AG19,\"OK\",\"NG\"))","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,"←判断基準値は基準値×0.9の結果を小数第三位を切り上げて小数第二位までの数値としています。"]
[null,null,"冷房期の平均日射熱取得率",null,null,null,null,null,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(S20=\"\",\"\",IF(S6<=4,\"―\",IF(OR(AL5=4,AL5=\"\"),ROUNDUP(0.9*VLOOKUP(S6,BR6:BT13,3,FALSE),1),IF(AL5=5,ROUNDUP(0.9*VLOOKUP(S6,BR6:BV13,5,FALSE),1),IF(AL5=6,ROUNDUP(0.9*VLOOKUP(S6,BR6:BX13,7,FALSE),1),IF(AND(AL5=7,S6<=7),ROUNDUP(0.9*VLOOKUP(S6,BR6:BZ13,9,FALSE),1),IF(AND(AL5=7,S6=8),\"―\",\"\")))))))","v":""},null,null,null,null,null,null,{"$f":"IF(S20=\"\",\"\",IF(S20<=AG20,\"OK\",\"NG\"))","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,"←判断基準値は基準値×0.9の結果を小数第二位を切り上げて小数第一位までの数値としています。"]
[]
[null,null,"以下の（イ）～（ニ）のいずれかの変更であり、それ以外の変更はない（ルートAに該当するものを除く。）"]
[null,null,null,null,null,"(イ）開口部の面積増加分が外皮面積の合計の1/200を超えない変更"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変更前",null,null,null,null,null,null,"変更後",null,null,null,null,null,null,"判断基準値",null,null,null,null,null,null,"判定"]
[null,null,"開口部の面積の合計",null,null,null,null,null,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(Z18=\"\",\"\",Z18/200)","v":""},null,null,null,null,null,null,{"$f":"IF(AG25=\"\",\"\",IF(Z25-S25<=AG25,\"OK\",\"NG\"))","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,"←判断基準値は外皮面積の1/200とし、変更前後の開口部面積の差が判断基準値以下であるかどうかで判定しています。"]
[]
[null,null,null,null,null,"(ロ）",null,null,"変更する開口部面積が外皮面積の合計の1/200を超えない場合の開口部の断熱性能、日射遮蔽性能若しくはその両方が低下する変更又は日射遮蔽部材をなくす変更"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変更後",null,null,null,null,null,null,"判断基準値",null,null,null,null,null,null,"判定"]
[null,null,"性能低下・仕様変更する開口部の面積の合計",null,null,null,null,null,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(Z18=\"\",\"\",Z18/200)","v":""},null,null,null,null,null,null,{"$f":"IF(AG29=\"\",\"\",IF(Z29<=AG29,\"OK\",\"NG\"))","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,"←判断基準値は外皮面積の1/200とし、性能低下・仕様変更する開口部面積の合計が判断基準値以下であるかどうかで判定しています。"]
[null,null,"判定欄がOKの場合に開口部ごとに次の①又は②のいずれかの変更であれば適用可（開口部ごとに確認する。）"]
[null,null,null,"①",null,null,null,null,"開口部の断熱性能の低下",null,null,null,null,null,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/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,{"$f":"IF(Z18=\"\",\"\",Z18/100)","v":""},null,null,null,null,null,null,{"$f":"IF(AG36=\"\",\"\",IF(Z36<=AG36,\"OK\",\"NG\"))","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,"←判断基準値は外皮面積の1/100とし、性能低下・仕様変更する外皮面積（開口部除く）の合計が判断基準値以下であるかどうかで判定しています。"]
[null,null,"判定欄がOKの場合に開口部を除く外皮の断熱性能の低下を許容する。ただし、無断熱とすることはできない。"]
[]
[null,null,null,null,null,"(ニ）基礎断熱の基礎形状等の変更"]
[null,null,"基礎断熱を採用する住宅（部分的に基礎断熱を採用する住宅を含む。）について、対象となる基礎の形状等の変更を許容する。"]

{"sheet":"軽微な変更に該当する項目","index":1,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,7,2,15]]}
[]
[]
[null,null,null,null,null,null,null,"国土交通省ホームページ：省エネ基準適合義務対象建築物に係る 完了検査の手引き　参照"]

{"sheet":"マクロの有効化","index":2,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"ファイルを開いた際に上記メッセージが表示された場合は一度ファイルを閉じ、次のとおりご対応ください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"①ファイルを右クリックし、プロパティを選択"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"②全般タブのセキュリティの許可するにチェックし、適用→OKとして、ファイルを開く。"]