{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"comments":1,"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":"Sheet1","index":0,"n_rows":303,"n_cols":103,"rows_kept":303,"cut":false,"hidden":false,"merged":[[255,1,259,1],[2,5,2,6],[24,0,24,2],[31,0,31,2],[28,0,28,2],[10,0,10,2],[4,0,4,2],[3,0,3,2],[29,0,30,2],[26,0,26,2],[17,1,17,2],[11,1,11,2],[2,1,2,4],[5,0,5,2],[12,1,12,2],[254,1,254,2],[22,0,23,0],[11,0,21,0],[22,1,22,2],[23,1,23,2]]}
["東京ゼロエミ 住宅設計確認審査申請書・工事完了検査申請書　第四面（集合住宅用）",null,null,null,null,null,null,null,null,null,"Ｖｅｒ.1.0.2","エネルギー消費性能計算プログラム【住宅版】Ver.3.8～3.5対応"]
["単位住戸に関する事項"]
["物件名",null,null,null,null,"単位住戸の数",null,{"$f":"SUM(D7:CY7)","v":0},"水準Ａ\nの住戸数",{"$f":"SUMIF(D11:CY11,\"水準Ａ\",D7:CY7)","v":0},"水準Ｂ\nの住戸数",{"$f":"SUMIF(D11:CY11,\"水準Ｂ\",D7:CY7)","v":0},"水準Ｃ\nの住戸数",{"$f":"SUMIF(D11:CY11,\"水準Ｃ\",D7:CY7)","v":0}]
[null,null,null,"№1","№2","№3","№4","№5","№6","№7","№8","№9","№10","№11","№12","№13","№14","№15","№16","№17","№18","№19","№20","№21","№22","№23","№24","№25","№26","№27","№28","№29","№30","№31","№32","№33","№34","№35","№36","№37","№38","№39","№40","№41","№42","№43","№44","№45","№46","№47","№48","№49","№50","№51","№52","№53","№54","№55","№56","№57","№58","№59","№60","№61","№62","№63","№64","№65","№66","№67","№68","№69","№70","№71","№72","№73","№74","№75","№76","№77","№78","№79","№80","№81","№82","№83","№84","№85","№86","№87","№88","№89","№90","№91","№92","№93","№94","№95","№96","№97","№98","№99","№100"]
["地域区分",null,null,{"$f":"IF(D32=\"\",\"\",D254)","v":""},{"$f":"IF(E32=\"\",\"\",E254)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ32=\"\",\"\",BQ254)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["計算結果の住宅タイプの名称",null,null,{"$f":"IF(OR(COUNTIF(D29,\"*3.8.*\"),COUNTIF(D29,\"*3.7.*\")),IFERROR(MID(INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1),FIND(\"(建て方)\",INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1))+5,FIND(\"(共\",INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1))-FIND(\"(建て方)\",INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1))-5),\"\"),IFERROR(MID(INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1),FIND(\"(建て方)\",INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1))+5,FIND(\"( 共\",INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1))-FIND(\"(建て方)\",INDEX(D32:D252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",D32:D252,0),1))-5),\"\"))","v":""},{"$f":"IF(OR(COUNTIF(E29,\"*3.8.*\"),COUNTIF(E29,\"*3.7.*\")),IFERROR(MID(INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1),FIND(\"(建て方)\",INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1))+5,FIND(\"(共\",INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1))-FIND(\"(建て方)\",INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1))-5),\"\"),IFERROR(MID(INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1),FIND(\"(建て方)\",INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1))+5,FIND(\"( 共\",INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1))-FIND(\"(建て方)\",INDEX(E32:E252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",E32:E252,0),1))-5),\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(COUNTIF(BQ29,\"*3.8.*\"),COUNTIF(BQ29,\"*3.7.*\")),IFERROR(MID(INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1),FIND(\"(建て方)\",INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1))+5,FIND(\"(共\",INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1))-FIND(\"(建て方)\",INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1))-5),\"\"),IFERROR(MID(INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1),FIND(\"(建て方)\",INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1))+5,FIND(\"( 共\",INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1))-FIND(\"(建て方)\",INDEX(BQ32:BQ252,MATCH(\"(1)住宅タイプの名称 (建て方) *\",BQ32:BQ252,0),1))-5),\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["住戸数カウンタ　",null,null,{"$f":"IF(D32=\"\",\"\",1)","v":""},{"$f":"IF(E32=\"\",\"\",1)","v":""},{"$f":"IF(F32=\"\",\"\",1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BR32=\"\",\"\",1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["1.単位住戸の番号 ",null,"※入力必須"]
["2.単位住戸の位置する階",null,"※入力必須"]
["3.単位住戸の床面積　（㎡）",null,"※計算結果の床面積を表示",{"$f":"IF(D32=\"\",\"\",IF(OR(COUNTIF(D29,\"*3.8.*\"),COUNTIF(D29,\"*3.7.*\")),LEFT(RIGHT(INDEX(D32:D252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),LEN(INDEX(D32:D252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(D32:D252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),\" \",\"*\",3)))),LEN(RIGHT(INDEX(D32:D252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),LEN(INDEX(D32:D252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(D32:D252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),\" \",\"*\",3)))))-1)*1,LEFT(RIGHT(INDEX(D32:D252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),LEN(INDEX(D32:D252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(D32:D252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),\" \",\"*\",3)))),LEN(RIGHT(INDEX(D32:D252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),LEN(INDEX(D32:D252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(D32:D252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",D32:D252,0)+1,1),\" \",\"*\",3)))))-1)*1))","v":""},{"$f":"IF(E32=\"\",\"\",IF(OR(COUNTIF(E29,\"*3.8.*\"),COUNTIF(E29,\"*3.7.*\")),LEFT(RIGHT(INDEX(E32:E252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),LEN(INDEX(E32:E252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(E32:E252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),\" \",\"*\",3)))),LEN(RIGHT(INDEX(E32:E252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),LEN(INDEX(E32:E252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(E32:E252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),\" \",\"*\",3)))))-1)*1,LEFT(RIGHT(INDEX(E32:E252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),LEN(INDEX(E32:E252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(E32:E252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),\" \",\"*\",3)))),LEN(RIGHT(INDEX(E32:E252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),LEN(INDEX(E32:E252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(E32:E252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",E32:E252,0)+1,1),\" \",\"*\",3)))))-1)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ32=\"\",\"\",IF(OR(COUNTIF(BQ29,\"*3.8.*\"),COUNTIF(BQ29,\"*3.7.*\")),LEFT(RIGHT(INDEX(BQ32:BQ252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),LEN(INDEX(BQ32:BQ252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(BQ32:BQ252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),\" \",\"*\",3)))),LEN(RIGHT(INDEX(BQ32:BQ252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),LEN(INDEX(BQ32:BQ252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(BQ32:BQ252,MATCH(\"(4)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),\" \",\"*\",3)))))-1)*1,LEFT(RIGHT(INDEX(BQ32:BQ252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),LEN(INDEX(BQ32:BQ252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(BQ32:BQ252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),\" \",\"*\",3)))),LEN(RIGHT(INDEX(BQ32:BQ252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),LEN(INDEX(BQ32:BQ252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1))-(FIND(\"*\",SUBSTITUTE(INDEX(BQ32:BQ252,MATCH(\"(2)床面積主たる居室その他の居室非居室合計*\",BQ32:BQ252,0)+1,1),\" \",\"*\",3)))))-1)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["4.適合する水準"]
["5.適合を確認する際に選択した基準","非表示セル（予備）"]
[null,"(ア) 断熱性能",null,{"$f":"IF(D$32=\"\",\"\",IF(OR(COUNTIF(D29,\"*3.2.*\"),COUNTIF(D29,\"*3.1.*\"),COUNTIF(D29,\"*3.0.*\")),\"－\",IF(D255=\"当該住戸の外皮面積を用いて外皮性能を評価する\",\"性能規定\",IF(OR(D255=\"誘導仕様基準により外皮性能を評価する（住戸全体を対象に評価）\",D255=\"誘導仕様基準により外皮性能を評価する\"),\"仕様規定　　　誘導仕様基準\",\"－\"))))","v":""},{"$f":"IF(E$32=\"\",\"\",IF(OR(COUNTIF(E29,\"*3.2.*\"),COUNTIF(E29,\"*3.1.*\"),COUNTIF(E29,\"*3.0.*\")),\"－\",IF(E255=\"当該住戸の外皮面積を用いて外皮性能を評価する\",\"性能規定\",IF(OR(E255=\"誘導仕様基準により外皮性能を評価する（住戸全体を対象に評価）\",E255=\"誘導仕様基準により外皮性能を評価する\"),\"仕様規定　　　誘導仕様基準\",\"－\"))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ$32=\"\",\"\",IF(OR(COUNTIF(BQ29,\"*3.2.*\"),COUNTIF(BQ29,\"*3.1.*\"),COUNTIF(BQ29,\"*3.0.*\")),\"－\",IF(BQ255=\"当該住戸の外皮面積を用いて外皮性能を評価する\",\"性能規定\",IF(OR(BQ255=\"誘導仕様基準により外皮性能を評価する（住戸全体を対象に評価）\",BQ255=\"誘導仕様基準により外皮性能を評価する\"),\"仕様規定　　　誘導仕様基準\",\"－\"))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"外皮平均\n熱貫流率\nW/(㎡・K）","設計値→\n基準値↓",{"$f":"IF(OR(D6=\"\",D8=\"\",D9=\"\",D32=\"\"),\"\",IF(COUNTIF(D29,\"*3.2*\"),\"　　　－\",VLOOKUP(D$255,$C$256:$CY$260,D$253,FALSE)))","v":""},{"$f":"IF(OR(E6=\"\",E8=\"\",E9=\"\",E32=\"\"),\"\",IF(COUNTIF(E29,\"*3.2*\"),\"　　　－\",VLOOKUP(E$255,$C$256:$CY$260,E$253,FALSE)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ6=\"\",BQ8=\"\",BQ9=\"\",BQ32=\"\"),\"\",IF(COUNTIF(BQ29,\"*3.2*\"),\"　　　－\",VLOOKUP(BQ$255,$C$256:$CY$260,BQ$253,FALSE)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"水準A",0.35,{"$f":"IF(OR(D$32=\"\",D$8=\"\"),\"\",IF(D$14<=$C$15,\"適合\",\"-\"))","v":""},{"$f":"IF(OR(E$32=\"\",E$7=\"\"),\"\",IF(E$14<=$C$15,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AK$32=\"\",AK$7=\"\"),\"\",IF(AK$14<=$C$15,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ$32=\"\",BQ$7=\"\"),\"\",IF(BQ$14<=$C$15,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"水準B",0.46,{"$f":"IF(OR(D$32=\"\",D$8=\"\"),\"\",IF(D$14<=$C$16,\"適合\",\"-\"))","v":""},{"$f":"IF(OR(E$32=\"\",E$7=\"\"),\"\",IF(E$14<=$C$16,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AK$32=\"\",AK$7=\"\"),\"\",IF(AK$14<=$C$16,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ$32=\"\",BQ$7=\"\"),\"\",IF(BQ$14<=$C$16,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"水準C",0.6,{"$f":"IF(OR(D$32=\"\",D$8=\"\"),\"\",IF(D$14<=$C$17,\"適合\",\"-\"))","v":""},{"$f":"IF(OR(E$32=\"\",E$7=\"\"),\"\",IF(E$14<=$C$17,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AK$32=\"\",AK$7=\"\"),\"\",IF(AK$14<=$C$17,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ$32=\"\",BQ$7=\"\"),\"\",IF(BQ$14<=$C$17,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"(イ) 設備の省エネルギー性能",null,{"$f":"IF(D32=\"\",\"\",\"性能規定\")","v":""},{"$f":"IF(E32=\"\",\"\",\"性能規定\")","v":""},"","","","","","","","","",{"$f":"IF(O32=\"\",\"\",\"性能規定\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CA32=\"\",\"\",\"性能規定\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"BEIZE\n誘導ＢＥＩを表示","設計値→\n基準値↓",{"$f":"IF(OR(D32=\"\",D6=\"\",D8=\"\",D9=\"\"),\"\",IF(OR(COUNTIF(H86,\"*3.2.*\"),COUNTIF(H86,\"*3.1.*\"),COUNTIF(H86,\"*3.1.*\")),\"　　　－\",RIGHT(INDEX(D32:D252,MATCH(\"3. BEI*\",D32:D252,0)+9,1),4)*1))","v":""},{"$f":"IF(OR(E32=\"\",E6=\"\",E7=\"\",E9=\"\"),\"\",IF(OR(COUNTIF(I86,\"*3.2.*\"),COUNTIF(I86,\"*3.1.*\"),COUNTIF(I86,\"*3.1.*\")),\"　　　－\",RIGHT(INDEX(E32:E252,MATCH(\"3. BEI*\",E32:E252,0)+9,1),4)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AK32=\"\",AK6=\"\",AK7=\"\",AK9=\"\"),\"\",IF(OR(COUNTIF(AO86,\"*3.2.*\"),COUNTIF(AO86,\"*3.1.*\"),COUNTIF(AO86,\"*3.1.*\")),\"　　　－\",RIGHT(INDEX(AK32:AK252,MATCH(\"3. BEI*\",AK32:AK252,0)+9,1),4)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ32=\"\",BQ6=\"\",BQ7=\"\",BQ9=\"\"),\"\",IF(OR(COUNTIF(BU86,\"*3.2.*\"),COUNTIF(BU86,\"*3.1.*\"),COUNTIF(BU86,\"*3.1.*\")),\"　　　－\",RIGHT(INDEX(BQ32:BQ252,MATCH(\"3. BEI*\",BQ32:BQ252,0)+9,1),4)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(CW32=\"\",CW6=\"\",CW7=\"\",CW9=\"\"),\"\",IF(OR(COUNTIF(DA86,\"*3.2.*\"),COUNTIF(DA86,\"*3.1.*\"),COUNTIF(DA86,\"*3.1.*\")),\"　　　－\",RIGHT(INDEX(CW32:CW252,MATCH(\"3. BEI*\",CW32:CW252,0)+9,1),4)*1))","v":""},"",""]
[null,"水準A",0.6,{"$f":"IF(OR(D$32=\"\",D$8=\"\"),\"\",IF(D$19<=$C$20,\"適合\",\"-\"))","v":""},{"$f":"IF(OR(E$32=\"\",E$7=\"\"),\"\",IF(E$19<=$C$20,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AK$32=\"\",AK$7=\"\"),\"\",IF(AK$19<=$C$20,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ$32=\"\",BQ$7=\"\"),\"\",IF(BQ$19<=$C$20,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"水準B",0.65,{"$f":"IF(OR(D$32=\"\",D$8=\"\"),\"\",IF(D$19<=$C$21,\"適合\",\"-\"))","v":""},{"$f":"IF(OR(E$32=\"\",E$7=\"\"),\"\",IF(E$19<=$C$21,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AK$32=\"\",AK$7=\"\"),\"\",IF(AK$19<=$C$21,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ$32=\"\",BQ$7=\"\"),\"\",IF(BQ$19<=$C$21,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"水準C",0.7,{"$f":"IF(OR(D$32=\"\",D$8=\"\"),\"\",IF(D$19<=$C$22,\"適合\",\"-\"))","v":""},{"$f":"IF(OR(E$32=\"\",E$7=\"\"),\"\",IF(E$19<=$C$22,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AK$32=\"\",AK$7=\"\"),\"\",IF(AK$19<=$C$22,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ$32=\"\",BQ$7=\"\"),\"\",IF(BQ$19<=$C$22,\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["6.単位住戸当りの\n太陽光発電システム発電出力","単位住戸ごとの受電の有無\n※無しの場合は空欄"]
[null,"太陽光発電システムの出力　(kW)"]
["7.東京ゼロエミ住宅におけるオール電化への該当の有無\n※入力必須"]
[]
["判定\n※数値のみの判定結果でありその他認証要件は含めていません",null,null,{"$f":"IF(OR(D32=\"\",D8=\"\",D11=\"\",D25=\"\"),\"\",IF(AND(D11=\"水準Ａ\",D15=\"適合\",D20=\"適合\"),\"適合\",IF(AND(D11=\"水準Ｂ\",D16=\"適合\",D21=\"適合\"),\"適合\",IF(AND(D11=\"水準Ｃ\",D17=\"適合\",D22=\"適合\"),\"適合\",\"－\"))))","v":""},{"$f":"IF(OR(E32=\"\",E8=\"\",E11=\"\",E25=\"\"),\"\",IF(AND(E11=\"水準Ａ\",E15=\"適合\",E20=\"適合\"),\"適合\",IF(AND(E11=\"水準Ｂ\",E16=\"適合\",E21=\"適合\"),\"適合\",IF(AND(E11=\"水準Ｃ\",E17=\"適合\",E22=\"適合\"),\"適合\",\"－\"))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BQ32=\"\",BQ8=\"\",BQ11=\"\",BQ25=\"\"),\"\",IF(AND(BQ11=\"水準Ａ\",BQ15=\"適合\",BQ20=\"適合\"),\"適合\",IF(AND(BQ11=\"水準Ｂ\",BQ16=\"適合\",BQ21=\"適合\"),\"適合\",IF(AND(BQ11=\"水準Ｃ\",BQ17=\"適合\",BQ22=\"適合\"),\"適合\",\"－\"))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
["WEBプログラム（住宅版）Ver",null,null,{"$f":"IF(D32=\"\",\"\",IFERROR(MID(INDEX(D32:D252,MATCH(\"Version:*\",D32:D252,0)+0,1),10,5),0))","v":""},{"$f":"IF(E32=\"\",\"\",IFERROR(MID(INDEX(E32:E252,MATCH(\"Version:*\",E32:E252,0)+0,1),10,5),0))","v":""},"","","","","","",{"$f":"IF(L32=\"\",\"\",IFERROR(MID(INDEX(L32:L252,MATCH(\"Version:*\",L32:L252,0)+0,1),10,5),0))","v":""},{"$f":"IF(M32=\"\",\"\",IFERROR(MID(INDEX(M32:M252,MATCH(\"Version:*\",M32:M252,0)+0,1),10,5),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ32=\"\",\"\",IFERROR(MID(INDEX(BQ32:BQ252,MATCH(\"Version:*\",BQ32:BQ252,0)+0,1),10,5),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["計算書日時",null,null,{"$f":"IF(D32=\"\",\"\",IFERROR(MID(INDEX(D32:D252,MATCH(\"Version:*\",D32:D252,0)+0,1),19,11),0))","v":""},{"$f":"IF(E32=\"\",\"\",IFERROR(MID(INDEX(E32:E252,MATCH(\"Version:*\",E32:E252,0)+0,1),19,11),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ32=\"\",\"\",IFERROR(MID(INDEX(BQ32:BQ252,MATCH(\"Version:*\",BQ32:BQ252,0)+0,1),19,11),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(D32=\"\",\"\",IFERROR(RIGHT(INDEX(D32:D252,MATCH(\"Version:*\",D32:D252,0)+0,1),8),0))","v":""},{"$f":"IF(E32=\"\",\"\",IFERROR(RIGHT(INDEX(E32:E252,MATCH(\"Version:*\",E32:E252,0)+0,1),8),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ32=\"\",\"\",IFERROR(RIGHT(INDEX(BQ32:BQ252,MATCH(\"Version:*\",BQ32:BQ252,0)+0,1),8),0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["貼付けセル⇒"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"VLOOLUP用列番号",2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101]
[null,"地域区分",null,{"$f":"IF(D32=\"\",\"\",IF(OR(COUNTIF(D29,\"*3.8.*\"),COUNTIF(D29,\"*3.7.*\")),MID(INDEX(D32:D252,MATCH(\"(5)地域の区分/年間の日射地域区分*\",D32:D252,0),1),19,1)*1,MID(INDEX(D32:D252,MATCH(\"(3)地域の区分/年間の日射地域区分*\",D32:D252,0),1),19,1)*1))","v":""},{"$f":"IF(E32=\"\",\"\",IF(OR(COUNTIF(E29,\"*3.8.*\"),COUNTIF(E29,\"*3.7.*\")),MID(INDEX(E32:E252,MATCH(\"(5)地域の区分/年間の日射地域区分*\",E32:E252,0),1),19,1)*1,MID(INDEX(E32:E252,MATCH(\"(3)地域の区分/年間の日射地域区分*\",E32:E252,0),1),19,1)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ32=\"\",\"\",IF(OR(COUNTIF(BQ29,\"*3.8.*\"),COUNTIF(BQ29,\"*3.7.*\")),MID(INDEX(BQ32:BQ252,MATCH(\"(5)地域の区分/年間の日射地域区分*\",BQ32:BQ252,0),1),19,1)*1,MID(INDEX(BQ32:BQ252,MATCH(\"(3)地域の区分/年間の日射地域区分*\",BQ32:BQ252,0),1),19,1)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"外皮評価方法",null,{"$f":"IF(D32=\"\",\"\",LEFT(RIGHT(INDEX(D32:D252,MATCH(\"A.外皮外皮性能の評価方法*\",D32:D252,0),1),LEN(INDEX(D32:D252,MATCH(\"A.外皮外皮性能の評価方法*\",D32:D252,0),1))-13),LEN(RIGHT(INDEX(D32:D252,MATCH(\"A.外皮外皮性能の評価方法*\",D32:D252,0),1),LEN(INDEX(D32:D252,MATCH(\"A.外皮外皮性能の評価方法*\",D32:D252,0),1))-13))))","v":""},{"$f":"IF(E32=\"\",\"\",LEFT(RIGHT(INDEX(E32:E252,MATCH(\"A.外皮外皮性能の評価方法*\",E32:E252,0),1),LEN(INDEX(E32:E252,MATCH(\"A.外皮外皮性能の評価方法*\",E32:E252,0),1))-13),LEN(RIGHT(INDEX(E32:E252,MATCH(\"A.外皮外皮性能の評価方法*\",E32:E252,0),1),LEN(INDEX(E32:E252,MATCH(\"A.外皮外皮性能の評価方法*\",E32:E252,0),1))-13))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BQ32=\"\",\"\",LEFT(RIGHT(INDEX(BQ32:BQ252,MATCH(\"A.外皮外皮性能の評価方法*\",BQ32:BQ252,0),1),LEN(INDEX(BQ32:BQ252,MATCH(\"A.外皮外皮性能の評価方法*\",BQ32:BQ252,0),1))-13),LEN(RIGHT(INDEX(BQ32:BQ252,MATCH(\"A.外皮外皮性能の評価方法*\",BQ32:BQ252,0),1),LEN(INDEX(BQ32:BQ252,MATCH(\"A.外皮外皮性能の評価方法*\",BQ32:BQ252,0),1))-13))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"UA","当該住戸の外皮面積を用いて外皮性能を評価する",{"$f":"IF(D$32=\"\",\"\",IF($C$256=D$255,LEFT(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8),LEN(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8))-5)*1,0))","v":""},{"$f":"IF(E$32=\"\",\"\",IF($C$256=E$255,LEFT(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8),LEN(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8))-5)*1,0))","v":""},{"$f":"IF(F$32=\"\",\"\",IF($C$256=F$255,LEFT(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8),LEN(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8))-5)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BR$32=\"\",\"\",IF($C$256=BR$255,LEFT(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8),LEN(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8))-5)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"仕様基準により外皮性能を評価する",{"$f":"IF(D$32=\"\",\"\",IF($C$257=D$255,LEFT(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8),LEN(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8))-13)*1,0))","v":""},{"$f":"IF(E$32=\"\",\"\",IF($C$257=E$255,LEFT(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8),LEN(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8))-13)*1,0))","v":""},{"$f":"IF(F$32=\"\",\"\",IF($C$257=F$255,LEFT(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8),LEN(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8))-13)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BR$32=\"\",\"\",IF($C$257=BR$255,LEFT(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8),LEN(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8))-13)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"仕様基準により外皮性能を評価する（住戸全体を対象に評価）",{"$f":"IF(D$32=\"\",\"\",IF($C$258=D$255,LEFT(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8),LEN(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8))-13)*1,0))","v":""},{"$f":"IF(E$32=\"\",\"\",IF($C$258=E$255,LEFT(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8),LEN(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8))-13)*1,0))","v":""},{"$f":"IF(F$32=\"\",\"\",IF($C$258=F$255,LEFT(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8),LEN(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8))-13)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BR$32=\"\",\"\",IF($C$258=BR$255,LEFT(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8),LEN(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8))-13)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"誘導仕様基準により外皮性能を評価する",{"$f":"IF(D$32=\"\",\"\",IF($C$259=D$255,LEFT(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8),LEN(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8))-15)*1,0))","v":""},{"$f":"IF(E$32=\"\",\"\",IF($C$259=E$255,LEFT(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8),LEN(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8))-15)*1,0))","v":""},{"$f":"IF(F$32=\"\",\"\",IF($C$259=F$255,LEFT(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8),LEN(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8))-15)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BR$32=\"\",\"\",IF($C$259=BR$255,LEFT(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8),LEN(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8))-15)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"誘導仕様基準により外皮性能を評価する（住戸全体を対象に評価）",{"$f":"IF(D$32=\"\",\"\",IF($C$260=D$255,LEFT(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8),LEN(RIGHT(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1),LEN(INDEX(D$32:D$252,MATCH(\"外皮平均熱貫流率*\",D$32:D$252,0),1))-8))-15)*1,0))","v":""},{"$f":"IF(E$32=\"\",\"\",IF($C$260=E$255,LEFT(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8),LEN(RIGHT(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1),LEN(INDEX(E$32:E$252,MATCH(\"外皮平均熱貫流率*\",E$32:E$252,0),1))-8))-15)*1,0))","v":""},{"$f":"IF(F$32=\"\",\"\",IF($C$260=F$255,LEFT(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8),LEN(RIGHT(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1),LEN(INDEX(F$32:F$252,MATCH(\"外皮平均熱貫流率*\",F$32:F$252,0),1))-8))-15)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BR$32=\"\",\"\",IF($C$260=BR$255,LEFT(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8),LEN(RIGHT(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1),LEN(INDEX(BR$32:BR$252,MATCH(\"外皮平均熱貫流率*\",BR$32:BR$252,0),1))-8))-15)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"適合する水準","受電","オール電化"]
[null,"水準Ａ","有","○該当あり"]
[null,"水準Ｂ",null,"×該当なし"]
[null,"水準Ｃ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"　　　▲他のシートの「全住戸計算書書コピーボタン」から貼り付ける場合はこのセルに貼付け"]
[null,"：自由入力のセル"]
[null,"：プルダウン選択のセル"]