{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["計算書","太陽光発電設備の住戸按分計算シート","【参考】共用部の太陽光の扱いについて","Ver情報"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"計算書","index":0,"n_rows":543,"n_cols":198,"rows_kept":543,"cut":false,"hidden":false,"merged":[[3,15,3,18],[5,1,5,3],[516,1,516,5],[73,1,73,5],[509,1,509,5],[508,1,508,5],[507,5,507,6],[507,1,507,4],[511,1,511,5],[512,1,512,5],[513,1,513,5],[514,1,514,5],[515,1,515,5],[3,12,3,14],[56,2,56,3],[510,1,510,5],[3,1,3,2],[3,3,3,5],[4,1,4,3],[6,1,6,3],[9,1,9,3],[6,4,6,5],[7,4,7,5],[7,1,7,3],[8,1,8,3],[8,4,8,5],[69,1,69,5],[68,1,68,5],[22,2,22,3],[11,1,11,3],[21,2,21,3],[14,4,14,5],[14,2,14,3],[13,4,13,5],[12,4,12,5],[21,4,21,5],[47,2,50,2],[15,2,15,3],[15,4,15,5],[16,2,18,2],[11,4,11,5],[13,1,13,3],[70,1,70,5],[22,4,22,5],[63,1,63,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[34,2,44,2],[64,1,64,5],[65,1,65,5],[51,1,58,1],[23,2,33,2],[23,4,33,4],[67,1,67,5],[66,1,66,5],[51,2,51,3],[53,2,53,3],[58,2,58,3],[22,1,50,1],[12,1,12,3],[14,1,21,1],[16,4,16,5],[18,4,18,5],[34,4,49,4],[6,6,8,6],[512,8,512,11],[512,12,512,13],[511,8,511,11],[511,12,511,13],[509,12,509,13],[507,12,507,13],[508,12,508,13],[510,12,510,13],[508,8,508,11],[509,8,509,11],[510,8,510,11],[507,8,507,11],[11,6,21,6],[23,6,25,6],[34,6,36,6]]}
[]
[null,"■申請書第六面及び設計内容説明書に代わる一覧表"]
[]
[null,"物件名",null,null,null,null,"地域区分",{"$f":"IF(H74=\"\",\"\",MID(H80,18,1)*1)","v":""},"住棟の延べ面積",null,"総住戸数",{"$f":"SUM(H7:GP7)","v":0},"住戸の存する建築物の用途\n（建築基準法上の用途区分）"]
[null,"住戸名称",null,null,"住棟全体","住戸合計","共用部"]
[null,"申請の有無"]
[null,"同一計算結果住戸数"]
[null,"同一計算結果住戸名称"]
[null,"申請対象となる住戸が存する階"]
[null,"計算対象面積",null,null,{"$f":"IF(G10=\"\",\"\",SUM(F10,G10))","v":""},{"$f":"IF(H10=\"\",\"\",SUM(H11:GP11))","v":""},null,{"$f":"IF(H74=\"\",\"\",LEFT(RIGHT(H79,LEN(H79)-(FIND(\"*\",SUBSTITUTE(H79,\" \",\"*\",3)))),LEN(RIGHT(H79,LEN(H79)-(FIND(\"*\",SUBSTITUTE(H79,\" \",\"*\",3)))))-1)*1)","v":""},{"$f":"IF(I74=\"\",\"\",LEFT(RIGHT(I79,LEN(I79)-(FIND(\"*\",SUBSTITUTE(I79,\" \",\"*\",3)))),LEN(RIGHT(I79,LEN(I79)-(FIND(\"*\",SUBSTITUTE(I79,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",LEFT(RIGHT(BU79,LEN(BU79)-(FIND(\"*\",SUBSTITUTE(BU79,\" \",\"*\",3)))),LEN(RIGHT(BU79,LEN(BU79)-(FIND(\"*\",SUBSTITUTE(BU79,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",LEFT(RIGHT(EG79,LEN(EG79)-(FIND(\"*\",SUBSTITUTE(EG79,\" \",\"*\",3)))),LEN(RIGHT(EG79,LEN(EG79)-(FIND(\"*\",SUBSTITUTE(EG79,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H10=\"\",\"\",H10*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT10=\"\",\"\",BT10*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF10=\"\",\"\",EF10*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"改修前のＢＥＩ値",null,null,null,null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$F$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$F$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$F$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"ＺＥＨマーク・ゼロエネ相当等表示",null,null,null,null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$D$490)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$D$490)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$D$490)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考情報（二次エネ以外）の掲載の選択",null,null,null,null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$G$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$G$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$G$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"外皮性能","評価手法（住戸評価or住棟評価）",null,null,null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$C$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$C$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$C$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"表示希望の選択",null,null,null,null,{"$f":"IF(COUNTBLANK(H5)=1,\"\",$P$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$P$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$P$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"設計値","ＵＡ",{"$f":"IF(ISERROR(SUM(H18:GP18)/L4),\"\",ROUNDUP(SUM(H18:GP18)/L4,2))","v":""},null,null,{"$f":"IF(H74=\"\",\"\",LEFT(RIGHT(INDEX(H75:H476,MATCH(\"外皮平均熱貫流率*\",H75:H476,0),1),LEN(INDEX(H75:H476,MATCH(\"外皮平均熱貫流率*\",H75:H476,0),1))-8),LEN(RIGHT(INDEX(H75:H476,MATCH(\"外皮平均熱貫流率*\",H75:H476,0),1),LEN(INDEX(H75:H476,MATCH(\"外皮平均熱貫流率*\",H75:H476,0),1))-8))-5)*1)","v":""},{"$f":"IF(I74=\"\",\"\",LEFT(RIGHT(INDEX(I75:I476,MATCH(\"外皮平均熱貫流率*\",I75:I476,0),1),LEN(INDEX(I75:I476,MATCH(\"外皮平均熱貫流率*\",I75:I476,0),1))-8),LEN(RIGHT(INDEX(I75:I476,MATCH(\"外皮平均熱貫流率*\",I75:I476,0),1),LEN(INDEX(I75:I476,MATCH(\"外皮平均熱貫流率*\",I75:I476,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",LEFT(RIGHT(INDEX(BU75:BU476,MATCH(\"外皮平均熱貫流率*\",BU75:BU476,0),1),LEN(INDEX(BU75:BU476,MATCH(\"外皮平均熱貫流率*\",BU75:BU476,0),1))-8),LEN(RIGHT(INDEX(BU75:BU476,MATCH(\"外皮平均熱貫流率*\",BU75:BU476,0),1),LEN(INDEX(BU75:BU476,MATCH(\"外皮平均熱貫流率*\",BU75:BU476,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",LEFT(RIGHT(INDEX(EG75:EG476,MATCH(\"外皮平均熱貫流率*\",EG75:EG476,0),1),LEN(INDEX(EG75:EG476,MATCH(\"外皮平均熱貫流率*\",EG75:EG476,0),1))-8),LEN(RIGHT(INDEX(EG75:EG476,MATCH(\"外皮平均熱貫流率*\",EG75:EG476,0),1),LEN(INDEX(EG75:EG476,MATCH(\"外皮平均熱貫流率*\",EG75:EG476,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H17=\"\",\"\",H17*H7)","v":""},{"$f":"IF(I17=\"\",\"\",I17*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU17=\"\",\"\",BU17*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG17=\"\",\"\",EG17*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"ηＡＣ",{"$f":"IF(ISERROR(SUM(H20:GP20)/L4),\"\",ROUNDUP(SUM(H20:GP20)/L4,1))","v":""},null,null,{"$f":"IF(H74=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(H75:H476,MATCH(\"平均日射熱取得率暖房期*\",H75:H476,0),1),3),\":\",\"\")*1)","v":""},{"$f":"IF(I74=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(I75:I476,MATCH(\"平均日射熱取得率暖房期*\",I75:I476,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(BU75:BU476,MATCH(\"平均日射熱取得率暖房期*\",BU75:BU476,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(EG75:EG476,MATCH(\"平均日射熱取得率暖房期*\",EG75:EG476,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H19=\"\",\"\",H19*H7)","v":""},{"$f":"IF(I19=\"\",\"\",I19*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU19=\"\",\"\",BU19*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG19=\"\",\"\",EG19*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"基準値（左：住棟　右：住戸）","ＵＡ・ηＡＣ",{"$f":"IF(H4=\"\",\"\",IF(E15=\"\",\"\",VLOOKUP(H4,J485:Q492,8)))","v":""},{"$f":"IF(H4=\"\",\"\",IF(E15=\"\",\"\",VLOOKUP(H4,J485:Q492,2)))","v":""},null,{"$f":"IF(OR(H5=\"\",H17=\"\",H19=\"\"),\"\",IF(AND(H17<=VLOOKUP($H$4,$J$485:$M$492,4),H19<=VLOOKUP($H$4,$J$485:$N$492,5)),\"適合\",\"-\"))","v":""},{"$f":"IF(OR(I5=\"\",I17=\"\",I19=\"\"),\"\",IF(AND(I17<=VLOOKUP($H$4,$J$485:$M$492,4),I19<=VLOOKUP($H$4,$J$485:$N$492,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BT5=\"\",BT17=\"\",BT19=\"\"),\"\",IF(AND(BT17<=VLOOKUP($H$4,$J$485:$M$492,4),BT19<=VLOOKUP($H$4,$J$485:$N$492,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EF5=\"\",EF17=\"\",EF19=\"\"),\"\",IF(AND(EF17<=VLOOKUP($H$4,$J$485:$M$492,4),EF19<=VLOOKUP($H$4,$J$485:$N$492,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"住戸の強化外皮基準（ＵＡ）",null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,J485:L492,3))","v":""},null,null,{"$f":"IF(OR(H5=\"\",H17=\"\"),\"\",IF(H17<=VLOOKUP($H$4,$J$485:$M$492,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BT5=\"\",BT17=\"\"),\"\",IF(BT17<=VLOOKUP($H$4,$J$485:$M$492,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EF5=\"\",EF17=\"\"),\"\",IF(EF17<=VLOOKUP($H$4,$J$485:$M$492,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"一次エネルギー消費量","評価手法",null,"性能基準",null,null,{"$f":"IF(COUNTBLANK(H13)=1,\"\",$C$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT13)=1,\"\",$C$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF13)=1,\"\",$C$485)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"         基準値\n\n共用部 標準入力:MJ/㎡\n       照明簡易計算:MJ\n住戸:MJ","暖房",null,{"$f":"SUM(H25:GP25)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(MID(H82,FIND(\" \",H82),10)*1),\"\",MID(H82,FIND(\" \",H82),10)*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(MID(I82,FIND(\" \",I82),10)*1),\"\",MID(I82,FIND(\" \",I82),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(MID(BU82,FIND(\" \",BU82),10)*1),\"\",MID(BU82,FIND(\" \",BU82),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(MID(EG82,FIND(\" \",EG82),10)*1),\"\",MID(EG82,FIND(\" \",EG82),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H24=\"\",\"\",H24*H7)","v":""},{"$f":"IF(I24=\"\",\"\",I24*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU24=\"\",\"\",BU24*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG24=\"\",\"\",EG24*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"冷房",null,{"$f":"SUM(H27:GP27)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(MID(H83,FIND(\" \",H83),10)*1),\"\",MID(H83,FIND(\" \",H83),10)*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(MID(I83,FIND(\" \",I83),10)*1),\"\",MID(I83,FIND(\" \",I83),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(MID(BU83,FIND(\" \",BU83),10)*1),\"\",MID(BU83,FIND(\" \",BU83),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(MID(EG83,FIND(\" \",EG83),10)*1),\"\",MID(EG83,FIND(\" \",EG83),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H26=\"\",\"\",H26*H7)","v":""},{"$f":"IF(I26=\"\",\"\",I26*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU26=\"\",\"\",BU26*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG26=\"\",\"\",EG26*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"換気",null,{"$f":"SUM(H29:GP29)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(MID(H84,FIND(\" \",H84),10)*1),\"\",MID(H84,FIND(\" \",H84),10)*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(MID(I84,FIND(\" \",I84),10)*1),\"\",MID(I84,FIND(\" \",I84),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(MID(BU84,FIND(\" \",BU84),10)*1),\"\",MID(BU84,FIND(\" \",BU84),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(MID(EG84,FIND(\" \",EG84),10)*1),\"\",MID(EG84,FIND(\" \",EG84),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",H28*H7)","v":""},{"$f":"IF(I28=\"\",\"\",I28*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU28=\"\",\"\",BU28*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG28=\"\",\"\",EG28*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"照明",null,{"$f":"SUM(H31:GP31)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(MID(H86,FIND(\" \",H86),10)*1),\"\",MID(H86,FIND(\" \",H86),10)*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(MID(I86,FIND(\" \",I86),10)*1),\"\",MID(I86,FIND(\" \",I86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(MID(BU86,FIND(\" \",BU86),10)*1),\"\",MID(BU86,FIND(\" \",BU86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(MID(EG86,FIND(\" \",EG86),10)*1),\"\",MID(EG86,FIND(\" \",EG86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H30=\"\",\"\",H30*H7)","v":""},{"$f":"IF(I30=\"\",\"\",I30*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU30=\"\",\"\",BU30*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG30=\"\",\"\",EG30*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"給湯",null,{"$f":"SUM(H33:GP33)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(MID(H85,FIND(\" \",H85),10)*1),\"\",MID(H85,FIND(\" \",H85),10)*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(MID(I85,FIND(\" \",I85),10)*1),\"\",MID(I85,FIND(\" \",I85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(MID(BU85,FIND(\" \",BU85),10)*1),\"\",MID(BU85,FIND(\" \",BU85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(MID(EG85,FIND(\" \",EG85),10)*1),\"\",MID(EG85,FIND(\" \",EG85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H32=\"\",\"\",H32*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT32=\"\",\"\",BT32*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF32=\"\",\"\",EF32*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"昇降機"]
[null,null,"         設計値\n\n共用部 標準入力MJ/㎡\n       照明簡易計算:MJ\n住戸:MJ","暖房",null,{"$f":"SUM(H36:GP36)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H82,LEN(H82)-4),FIND(\" \",RIGHT(H82,LEN(H82)-4)))*1),\"\",LEFT(RIGHT(H82,LEN(H82)-4),FIND(\" \",RIGHT(H82,LEN(H82)-4)))*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I82,LEN(I82)-4),FIND(\" \",RIGHT(I82,LEN(I82)-4)))*1),\"\",LEFT(RIGHT(I82,LEN(I82)-4),FIND(\" \",RIGHT(I82,LEN(I82)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU82,LEN(BU82)-4),FIND(\" \",RIGHT(BU82,LEN(BU82)-4)))*1),\"\",LEFT(RIGHT(BU82,LEN(BU82)-4),FIND(\" \",RIGHT(BU82,LEN(BU82)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG82,LEN(EG82)-4),FIND(\" \",RIGHT(EG82,LEN(EG82)-4)))*1),\"\",LEFT(RIGHT(EG82,LEN(EG82)-4),FIND(\" \",RIGHT(EG82,LEN(EG82)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H35=\"\",\"\",H35*H7)","v":""},{"$f":"IF(I35=\"\",\"\",I35*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU35=\"\",\"\",BU35*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG35=\"\",\"\",EG35*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"冷房",null,{"$f":"SUM(H38:GP38)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H83,LEN(H83)-4),FIND(\" \",RIGHT(H83,LEN(H83)-4)))*1),\"\",LEFT(RIGHT(H83,LEN(H83)-4),FIND(\" \",RIGHT(H83,LEN(H83)-4)))*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I83,LEN(I83)-4),FIND(\" \",RIGHT(I83,LEN(I83)-4)))*1),\"\",LEFT(RIGHT(I83,LEN(I83)-4),FIND(\" \",RIGHT(I83,LEN(I83)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU83,LEN(BU83)-4),FIND(\" \",RIGHT(BU83,LEN(BU83)-4)))*1),\"\",LEFT(RIGHT(BU83,LEN(BU83)-4),FIND(\" \",RIGHT(BU83,LEN(BU83)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG83,LEN(EG83)-4),FIND(\" \",RIGHT(EG83,LEN(EG83)-4)))*1),\"\",LEFT(RIGHT(EG83,LEN(EG83)-4),FIND(\" \",RIGHT(EG83,LEN(EG83)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H37=\"\",\"\",H37*H7)","v":""},{"$f":"IF(I37=\"\",\"\",I37*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU37=\"\",\"\",BU37*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG37=\"\",\"\",EG37*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"換気",null,{"$f":"SUM(H40:GP40)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H84,LEN(H84)-4),FIND(\" \",RIGHT(H84,LEN(H84)-4)))*1),\"\",LEFT(RIGHT(H84,LEN(H84)-4),FIND(\" \",RIGHT(H84,LEN(H84)-4)))*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I84,LEN(I84)-4),FIND(\" \",RIGHT(I84,LEN(I84)-4)))*1),\"\",LEFT(RIGHT(I84,LEN(I84)-4),FIND(\" \",RIGHT(I84,LEN(I84)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU84,LEN(BU84)-4),FIND(\" \",RIGHT(BU84,LEN(BU84)-4)))*1),\"\",LEFT(RIGHT(BU84,LEN(BU84)-4),FIND(\" \",RIGHT(BU84,LEN(BU84)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG84,LEN(EG84)-4),FIND(\" \",RIGHT(EG84,LEN(EG84)-4)))*1),\"\",LEFT(RIGHT(EG84,LEN(EG84)-4),FIND(\" \",RIGHT(EG84,LEN(EG84)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H39=\"\",\"\",H39*H7)","v":""},{"$f":"IF(I39=\"\",\"\",I39*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU39=\"\",\"\",BU39*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG39=\"\",\"\",EG39*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"照明",null,{"$f":"SUM(H42:GP42)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H86,LEN(H86)-4),FIND(\" \",RIGHT(H86,LEN(H86)-4)))*1),\"\",LEFT(RIGHT(H86,LEN(H86)-4),FIND(\" \",RIGHT(H86,LEN(H86)-4)))*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I86,LEN(I86)-4),FIND(\" \",RIGHT(I86,LEN(I86)-4)))*1),\"\",LEFT(RIGHT(I86,LEN(I86)-4),FIND(\" \",RIGHT(I86,LEN(I86)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU86,LEN(BU86)-4),FIND(\" \",RIGHT(BU86,LEN(BU86)-4)))*1),\"\",LEFT(RIGHT(BU86,LEN(BU86)-4),FIND(\" \",RIGHT(BU86,LEN(BU86)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG86,LEN(EG86)-4),FIND(\" \",RIGHT(EG86,LEN(EG86)-4)))*1),\"\",LEFT(RIGHT(EG86,LEN(EG86)-4),FIND(\" \",RIGHT(EG86,LEN(EG86)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H41=\"\",\"\",H41*H7)","v":""},{"$f":"IF(I41=\"\",\"\",I41*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU41=\"\",\"\",BU41*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG41=\"\",\"\",EG41*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"給湯",null,{"$f":"SUM(H44:GP44)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H85,LEN(H85)-4),FIND(\" \",RIGHT(H85,LEN(H85)-4)))*1),\"\",LEFT(RIGHT(H85,LEN(H85)-4),FIND(\" \",RIGHT(H85,LEN(H85)-4)))*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I85,LEN(I85)-4),FIND(\" \",RIGHT(I85,LEN(I85)-4)))*1),\"\",LEFT(RIGHT(I85,LEN(I85)-4),FIND(\" \",RIGHT(I85,LEN(I85)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU85,LEN(BU85)-4),FIND(\" \",RIGHT(BU85,LEN(BU85)-4)))*1),\"\",LEFT(RIGHT(BU85,LEN(BU85)-4),FIND(\" \",RIGHT(BU85,LEN(BU85)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG85,LEN(EG85)-4),FIND(\" \",RIGHT(EG85,LEN(EG85)-4)))*1),\"\",LEFT(RIGHT(EG85,LEN(EG85)-4),FIND(\" \",RIGHT(EG85,LEN(EG85)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H43=\"\",\"\",H43*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT43=\"\",\"\",BT43*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF43=\"\",\"\",EF43*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"昇降機"]
[null,null,"基準・設計","その他",null,{"$f":"SUM(H47:GP47)","v":0},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(MID(H87,FIND(\" \",H87),10)*1),\"\",MID(H87,FIND(\" \",H87),10)*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(MID(I87,FIND(\" \",I87),10)*1),\"\",MID(I87,FIND(\" \",I87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(MID(BU87,FIND(\" \",BU87),10)*1),\"\",MID(BU87,FIND(\" \",BU87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(MID(EG87,FIND(\" \",EG87),10)*1),\"\",MID(EG87,FIND(\" \",EG87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H46=\"\",\"\",H46*H7)","v":""},{"$f":"IF(I46=\"\",\"\",I46*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU46=\"\",\"\",BU46*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG46=\"\",\"\",EG46*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"設計値（発電設備）","自家消費分",null,{"$f":"IF(H74=\"\",\"\",SUM(H49:GP49))","v":""},{"$f":"IF(OR(G23=\"\",G23=\"照明簡易計算\",G23=\"共用部なし\"),\"\",IF(G23=\"標準入力法\",IFERROR(-M512,0),\"\"))","v":""},{"$f":"IF(H74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H88,LEN(H88)-20),FIND(\" \",RIGHT(H88,LEN(H88)-20)))*1),0,LEFT(RIGHT(H88,LEN(H88)-20),FIND(\" \",RIGHT(H88,LEN(H88)-20)))*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I88,LEN(I88)-20),FIND(\" \",RIGHT(I88,LEN(I88)-20)))*1),0,LEFT(RIGHT(I88,LEN(I88)-20),FIND(\" \",RIGHT(I88,LEN(I88)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU88,LEN(BU88)-20),FIND(\" \",RIGHT(BU88,LEN(BU88)-20)))*1),0,LEFT(RIGHT(BU88,LEN(BU88)-20),FIND(\" \",RIGHT(BU88,LEN(BU88)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG88,LEN(EG88)-20),FIND(\" \",RIGHT(EG88,LEN(EG88)-20)))*1),0,LEFT(RIGHT(EG88,LEN(EG88)-20),FIND(\" \",RIGHT(EG88,LEN(EG88)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H48=\"\",\"\",H48*H7)","v":""},{"$f":"IF(I48=\"\",\"\",I48*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU48=\"\",\"\",BU48*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG48=\"\",\"\",EG48*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"控除量",null,{"$f":"IF(H76=\"\",\"\",SUM(H51:GP51))","v":""},null,{"$f":"IF(H74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H89,LEN(H89)-26),FIND(\" \",RIGHT(H89,LEN(H89)-26)))*1),0,LEFT(RIGHT(H89,LEN(H89)-26),FIND(\" \",RIGHT(H89,LEN(H89)-26)))*1))","v":""},{"$f":"IF(I74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I89,LEN(I89)-26),FIND(\" \",RIGHT(I89,LEN(I89)-26)))*1),0,LEFT(RIGHT(I89,LEN(I89)-26),FIND(\" \",RIGHT(I89,LEN(I89)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU89,LEN(BU89)-26),FIND(\" \",RIGHT(BU89,LEN(BU89)-26)))*1),0,LEFT(RIGHT(BU89,LEN(BU89)-26),FIND(\" \",RIGHT(BU89,LEN(BU89)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG89,LEN(EG89)-26),FIND(\" \",RIGHT(EG89,LEN(EG89)-26)))*1),0,LEFT(RIGHT(EG89,LEN(EG89)-26),FIND(\" \",RIGHT(EG89,LEN(EG89)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H50=\"\",\"\",H50*H7)","v":""},{"$f":"IF(I50=\"\",\"\",I50*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU50=\"\",\"\",BU50*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG50=\"\",\"\",EG50*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考値","発電量（ｺｰｼﾞｪﾈﾚｰｼｮﾝ）",null,null,{"$f":"IF(H74=\"\",\"\",SUM(H53:GP53))","v":""},null,{"$f":"IF(H74=\"\",\"\",IFERROR(LEFT(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1),FIND(\" \",INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))-1)*1,0))","v":""},{"$f":"IF(I74=\"\",\"\",IFERROR(LEFT(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1),FIND(\" \",INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IFERROR(LEFT(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1),FIND(\" \",INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IFERROR(LEFT(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1),FIND(\" \",INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H52=\"\",\"\",H52*H7)","v":""},{"$f":"IF(I52=\"\",\"\",I52*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU52=\"\",\"\",BU52*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG52=\"\",\"\",EG52*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"発電量（太陽光発電）",null,null,{"$f":"IF(H74=\"\",\"\",SUM(H55:GP55))","v":""},{"$f":"IF(OR(G23=\"\",G23=\"照明簡易計算\",G23=\"共用部なし\"),\"\",IF(M509=\"\",0,IF(M509=\"住戸・共用部で共有\",0,M513)))","v":""},{"$f":"IF(H74=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1),LEN(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))-FIND(\" \",INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))),FIND(\" \",RIGHT(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1),LEN(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))-FIND(\" \",INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))))-1)*1,0))","v":""},{"$f":"IF(I74=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1),LEN(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))-FIND(\" \",INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))),FIND(\" \",RIGHT(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1),LEN(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))-FIND(\" \",INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1),LEN(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))-FIND(\" \",INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))),FIND(\" \",RIGHT(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1),LEN(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))-FIND(\" \",INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1),LEN(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))-FIND(\" \",INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))),FIND(\" \",RIGHT(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1),LEN(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))-FIND(\" \",INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H54=\"\",\"\",H54*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT54=\"\",\"\",BT54*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF54=\"\",\"\",EF54*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"LEFT(RIGHT(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1),LEN(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))-FIND(\" \",INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1),FIND(\" \",INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1),LEN(INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))-FIND(\" \",INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1),FIND(\" \",INDEX(H75:H476,MATCH(\"コージェネレーション太陽光発電*\",H75:H476,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$f":"LEFT(RIGHT(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1),LEN(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))-FIND(\" \",INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1),FIND(\" \",INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1),LEN(INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))-FIND(\" \",INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1),FIND(\" \",INDEX(I75:I476,MATCH(\"コージェネレーション太陽光発電*\",I75:I476,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LEFT(RIGHT(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1),LEN(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))-FIND(\" \",INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1),FIND(\" \",INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1),LEN(INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))-FIND(\" \",INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1),FIND(\" \",INDEX(BU75:BU476,MATCH(\"コージェネレーション太陽光発電*\",BU75:BU476,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LEFT(RIGHT(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1),LEN(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))-FIND(\" \",INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1),FIND(\" \",INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1),LEN(INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))-FIND(\" \",INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1),FIND(\" \",INDEX(EG75:EG476,MATCH(\"コージェネレーション太陽光発電*\",EG75:EG476,0)+1,1))+1)))-1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"売電量（ｺｰｼﾞｪﾈﾚｰｼｮﾝ）",null,null,{"$f":"IF(H77=\"\",\"\",SUM(H58:GP58))","v":""},null,{"$f":"IF(H74=\"\",\"\",IFERROR(H56*1,0))","v":""},{"$f":"IF(I74=\"\",\"\",IFERROR(I56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",IFERROR(BU56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",IFERROR(EG56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H57=\"\",\"\",H57*H7)","v":""},{"$f":"IF(I57=\"\",\"\",I57*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU57=\"\",\"\",BU57*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG57=\"\",\"\",EG57*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"売電量（太陽光発電）",null,null,{"$f":"IF(H74=\"\",\"\",SUM(H60:GP60))","v":""},null,{"$f":"IF(H74=\"\",\"\",H52+H54-H57+H48)","v":""},{"$f":"IF(I74=\"\",\"\",I52+I54-I57+I48)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",BU52+BU54-BU57+BU48)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",EG52+EG54-EG57+EG48)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H59=\"\",\"\",H59*H7)","v":""},{"$f":"IF(I59=\"\",\"\",I59*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU59=\"\",\"\",BU59*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG59=\"\",\"\",EG59*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"設計一次エネルギー消費量",null,null,{"$f":"IF(ISERROR(G61),\"\",SUM(F61,G61))","v":0},{"$f":"ROUNDUP(SUM(F35,F37,F39,F41,F43,F48,F50)/1000,1)","v":0},{"$f":"IF(G10=\"\",\"\",IF($G$23=\"共用部なし\",0,IF($G$23=\"標準入力法\",AC502,IF($G$23=\"照明簡易計算\",ROUNDUP(G41/1000,1)))))","v":""},{"$f":"IF(H74=\"\",\"\",LEFT(RIGHT(H93,LEN(H93)-35),FIND(\" \",RIGHT(H93,LEN(H93)-35))-1)*1)","v":""},{"$f":"IF(I74=\"\",\"\",LEFT(RIGHT(I93,LEN(I93)-35),FIND(\" \",RIGHT(I93,LEN(I93)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",LEFT(RIGHT(BU93,LEN(BU93)-35),FIND(\" \",RIGHT(BU93,LEN(BU93)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",LEFT(RIGHT(EG93,LEN(EG93)-35),FIND(\" \",RIGHT(EG93,LEN(EG93)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"基準一次エネルギー消費量",null,null,{"$f":"IF(ISERROR(G62),\"\",SUM(F62,G62))","v":0},{"$f":"ROUNDUP(SUM(F24,F26,F28,F30,F32)/1000,1)","v":0},{"$f":"IF(G10=\"\",\"\",IF($G$23=\"共用部なし\",0,IF($G$23=\"標準入力法\",AC500,IF($G$23=\"照明簡易計算\",ROUNDUP(G30/1000,1)))))","v":""},{"$f":"IF(H74=\"\",\"\",MID(RIGHT(H93,LEN(H93)-35),FIND(\" \",RIGHT(H93,LEN(H93)-35)),10)*1)","v":""},{"$f":"IF(I74=\"\",\"\",MID(RIGHT(I93,LEN(I93)-35),FIND(\" \",RIGHT(I93,LEN(I93)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",MID(RIGHT(BU93,LEN(BU93)-35),FIND(\" \",RIGHT(BU93,LEN(BU93)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",MID(RIGHT(EG93,LEN(EG93)-35),FIND(\" \",RIGHT(EG93,LEN(EG93)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"ＢＥＩ",null,null,{"$f":"IF(ISERROR(E61/E62),\"\",ROUNDUP(E61/E62,2))","v":""},null,null,{"$f":"IF(H74=\"\",\"\",RIGHT(H94,4)*1)","v":""},{"$f":"IF(I74=\"\",\"\",RIGHT(I94,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU74=\"\",\"\",RIGHT(BU94,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG74=\"\",\"\",RIGHT(EG94,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"☆数",null,null,{"$f":"IF(E63=\"\",\"\",IF(E63<=0.8,\"☆☆☆☆☆\",IF(E63<=0.85,\"☆☆☆☆\",IF(E63<=0.9,\"☆☆☆\",IF(E63<=1,\"☆☆\",IF(E63<=1.1,\"☆\",\"-\"))))))","v":""},null,null,{"$f":"IF(H63=\"\",\"\",IF(H63<=0.8,\"☆☆☆☆☆\",IF(H63<=0.85,\"☆☆☆☆\",IF(H63<=0.9,\"☆☆☆\",IF(H63<=1,\"☆☆\",IF(H63<=1.1,\"☆\",\"-\"))))))","v":""},{"$f":"IF(I63=\"\",\"\",IF(I63<=0.8,\"☆☆☆☆☆\",IF(I63<=0.85,\"☆☆☆☆\",IF(I63<=0.9,\"☆☆☆\",IF(I63<=1,\"☆☆\",IF(I63<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU63=\"\",\"\",IF(BU63<=0.8,\"☆☆☆☆☆\",IF(BU63<=0.85,\"☆☆☆☆\",IF(BU63<=0.9,\"☆☆☆\",IF(BU63<=1,\"☆☆\",IF(BU63<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG63=\"\",\"\",IF(EG63<=0.8,\"☆☆☆☆☆\",IF(EG63<=0.85,\"☆☆☆☆\",IF(EG63<=0.9,\"☆☆☆\",IF(EG63<=1,\"☆☆\",IF(EG63<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(G61=\"\",0,IF($G$23=\"標準入力法\",AC504,IF($G$23=\"照明簡易計算\",G61,0)))","v":0},{"$f":"IF(ISERROR(ROUNDUP((H35+H37+H39+H41+H43+H50-(H52-H57))/1000,1)),\"\",ROUNDUP((H35+H37+H39+H41+H43+H50-(H52-H57))/1000,1))","v":""},{"$f":"IF(ISERROR(ROUNDUP((I35+I37+I39+I41+I43+I50-(I52-I57))/1000,1)),\"\",ROUNDUP((I35+I37+I39+I41+I43+I50-(I52-I57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((BU35+BU37+BU39+BU41+BU43+BU50-(BU52-BU57))/1000,1)),\"\",ROUNDUP((BU35+BU37+BU39+BU41+BU43+BU50-(BU52-BU57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((EG35+EG37+EG39+EG41+EG43+EG50-(EG52-EG57))/1000,1)),\"\",ROUNDUP((EG35+EG37+EG39+EG41+EG43+EG50-(EG52-EG57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた一次エネルギー消費削減量(GJ)",null,null,null,null,null,{"$f":"IF(ISERROR(H62-H65),\"\",H62-H65)","v":""},{"$f":"IF(ISERROR(I62-I65),\"\",I62-I65)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BU62-BU65),\"\",BU62-BU65)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EG62-EG65),\"\",EG62-EG65)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた一次エネルギー消費量削減率(%) ",null,null,null,null,null,{"$f":"IF(ISERROR(H66/H62),\"\",ROUNDDOWN(H66/H62*100,0))","v":""},{"$f":"IF(ISERROR(I66/I62),\"\",ROUNDDOWN(I66/I62*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BU66/BU62),\"\",ROUNDDOWN(BU66/BU62*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EG66/EG62),\"\",ROUNDDOWN(EG66/EG62*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(G61=\"\",0,IF($G$23=\"標準入力法\",AC505,IF($G$23=\"照明簡易計算\",G61,0)))","v":0},{"$f":"IF(ISERROR(ROUNDUP((H35+H37+H39+H41+H43-H52-H54)/1000,1)),\"\",IF((H35+H37+H39+H41+H43-H52-H54)<0,ROUNDDOWN((H35+H37+H39+H41+H43-H52-H54)/1000,1),ROUNDUP((H35+H37+H39+H41+H43-H52-H54)/1000,1)))","v":""},{"$f":"IF(ISERROR(ROUNDUP((I35+I37+I39+I41+I43-I52-I54)/1000,1)),\"\",IF((I35+I37+I39+I41+I43-I52-I54)<0,ROUNDDOWN((I35+I37+I39+I41+I43-I52-I54)/1000,1),ROUNDUP((I35+I37+I39+I41+I43-I52-I54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((BU35+BU37+BU39+BU41+BU43-BU52-BU54)/1000,1)),\"\",IF((BU35+BU37+BU39+BU41+BU43-BU52-BU54)<0,ROUNDDOWN((BU35+BU37+BU39+BU41+BU43-BU52-BU54)/1000,1),ROUNDUP((BU35+BU37+BU39+BU41+BU43-BU52-BU54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((EG35+EG37+EG39+EG41+EG43-EG52-EG54)/1000,1)),\"\",IF((EG35+EG37+EG39+EG41+EG43-EG52-EG54)<0,ROUNDDOWN((EG35+EG37+EG39+EG41+EG43-EG52-EG54)/1000,1),ROUNDUP((EG35+EG37+EG39+EG41+EG43-EG52-EG54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた一次エネルギー消費削減量(GJ)",null,null,null,null,null,{"$f":"IF(ISERROR(H62-H68),\"\",H62-H68)","v":""},{"$f":"IF(ISERROR(I62-I68),\"\",I62-I68)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BU62-BU68),\"\",BU62-BU68)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EG62-EG68),\"\",EG62-EG68)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた一次エネルギー消費量削減率(%) ",null,null,null,null,null,{"$f":"IF(ISERROR(H69/H62),\"\",ROUNDDOWN(H69/H62*100,0))","v":""},{"$f":"IF(ISERROR(I69/I62),\"\",ROUNDDOWN(I69/I62*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BU69/BU62),\"\",ROUNDDOWN(BU69/BU62*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EG69/EG62),\"\",ROUNDDOWN(EG69/EG62*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"住宅の「ＺＥＨマーク」、「ゼロエネ相当」に関する表示",null,null,null,null,null,{"$f":"IF(OR(AND(H13=$D$485,H21=\"適合\",H22=\"適合\",H67>=20,H70>=100),AND(H13=$D$486,H21=\"適合\",H22=\"適合\",H67>=20,H70>=75,H70<100),AND(H13=$D$487,H21=\"適合\",H22=\"適合\",H67>=20,H70>=50,H70<75),AND(H13=$D$488,H21=\"適合\",H22=\"適合\",H67>=20,H70>=20,H70<50),AND(H13=$D$489,H21=\"適合\",H67>=20,H70>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(OR(AND(BT13=$D$485,BT21=\"適合\",BT22=\"適合\",BT67>=20,BT70>=100),AND(BT13=$D$486,BT21=\"適合\",BT22=\"適合\",BT67>=20,BT70>=75,BT70<100),AND(BT13=$D$487,BT21=\"適合\",BT22=\"適合\",BT67>=20,BT70>=50,BT70<75),AND(BT13=$D$488,BT21=\"適合\",BT22=\"適合\",BT67>=20,BT70>=20,BT70<50),AND(BT13=$D$489,BT21=\"適合\",BT67>=20,BT70>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(OR(AND(EF13=$D$485,EF21=\"適合\",EF22=\"適合\",EF67>=20,EF70>=100),AND(EF13=$D$486,EF21=\"適合\",EF22=\"適合\",EF67>=20,EF70>=75,EF70<100),AND(EF13=$D$487,EF21=\"適合\",EF22=\"適合\",EF67>=20,EF70>=50,EF70<75),AND(EF13=$D$488,EF21=\"適合\",EF22=\"適合\",EF67>=20,EF70>=20,EF70<50),AND(EF13=$D$489,EF21=\"適合\",EF67>=20,EF70>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[]
[]
[null,"貼付けセル⇒"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"外皮性能住棟評価"]
["全住戸適合","申請する","性能基準","『ZEH』","『ZEH-M』","記載なし","記載なし",null,"記載なし",1,"0.46・-",0.4,0.46,"-","適合\n(性能基準)","UA値","0.41・-",null,null,null,null,null,null,null,"共用部","面積","MJ／延べ","①×延べ","MJ⇒GJ"]
["不適合あり","申請しない","仕様基準","Nearly ZEH","Nearly ZEH-M","記載する","別紙による",null,"別紙による",2,"0.46・-",0.4,0.46,"-","－\n(対象外)","ηAC値","0.41・-",null,null,null,null,null,null,null,"延べ面積",{"$f":"IF(J4=\"\",\"\",J4)","v":""}]
[null,null,"大臣の方法","ZEH Ready","ZEH-M Ready",null,"四面と同じ",null,"第四面と同じ",3,"0.56・-",0.5,0.56000000000000005,"-","適合\n(仕様基準)","希望しない","0.44・-",null,null,null,null,null,null,"基準","空調",null,{"$f":"IF($G$23=\"標準入力法\",G24,\"\")","v":""},{"$f":"AA487*$Z$486","v":{"$error":"#VALUE!"}}]
[null,null,null,"ZEH Oriented","ZEH-M Oriented",null,null,null,null,4,"0.75・-",0.6,0.75,"-",null,null,"0.69・-",null,null,null,null,null,null,"基準","換気",null,{"$f":"IF($G$23=\"標準入力法\",G28,\"\")","v":""},{"$f":"AA488*$Z$486","v":{"$error":"#VALUE!"}}]
[null,null,null,"ゼロエネ相当","記載しない",null,null,null,null,5,"0.87・3.0",0.6,0.87,3,null,null,"0.75・1.5",null,null,null,null,null,null,"基準","照明",null,{"$f":"IF($G$23=\"標準入力法\",G30,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,"記載しない",null,null,null,null,null,6,"0.87・2.8",0.6,0.87,2.8,null,null,"0.75・1.4",null,null,null,null,null,null,"基準","給湯",null,{"$f":"IF($G$23=\"標準入力法\",G32,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,7,"0.87・2.7",0.6,0.87,2.7,null,null,"0.75・1.3",null,null,null,null,null,null,"基準","昇降機",null,{"$f":"IF($G$23=\"標準入力法\",G34,\"\")","v":""},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,8,"-・3.2","-","-",3.2,null,null,"-・2.8",null,null,null,null,null,null,"設計","空調",null,{"$f":"IF($G$23=\"標準入力法\",G35,\"\")","v":""},{"$error":"#VALUE!"}]
["標準入力法",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($G$23=\"標準入力法\",G39,\"\")","v":""},{"$error":"#VALUE!"}]
["照明簡易計算",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($G$23=\"標準入力法\",G41,\"\")","v":""},{"$error":"#VALUE!"}]
["共用部なし",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($G$23=\"標準入力法\",G43,\"\")","v":""},{"$error":"#VALUE!"}]
[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($G$23=\"標準入力法\",G45,\"\")","v":""},{"$f":"AA496*$Z$486","v":{"$error":"#VALUE!"}}]
[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($G$23=\"標準入力法\",G46,\"\")","v":""},{"$f":"AA497*Z486","v":{"$error":"#VALUE!"}}]
[null,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":"G48","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,{"$f":"IFERROR(-G54,0)","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":"SUM(AB487:AB491)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB500/1000,1)","v":{"$error":"#VALUE!"}}]
[null,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":"SUM(AB487:AB491,AB497)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB501/1000,1)","v":{"$error":"#VALUE!"}}]
[null,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":"SUM(AB492:AB496,AB498)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB502/1000,1)","v":{"$error":"#VALUE!"}}]
[null,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":"SUM(AB492:AB498)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB503/1000,1)","v":{"$error":"#VALUE!"}}]
[null,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":"SUM(AB492:AB496)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB504/1000,1)","v":{"$error":"#VALUE!"}}]
[null,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":"SUM(AB492:AB496)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUNDUP(AB505/1000,1)+AC499,0)","v":0}]
[]
[null,"【住棟のZEH-M等に関わる判定】",null,null,null,null,null,null,"【共同住宅等の共用部の太陽光発電設備に関する事項】"]
[null,"選択した表示",null,null,null,{"$f":"IF(E13=\"\",\"\",E13)","v":""},null,null,"共用部への太陽光発電電力の供給の有無"]
[null,"全住戸の外皮の省エネ基準への適合状況",null,null,null,null,null,null,"太陽光発電設備の共有"]
[null,"全住戸の強化外皮基準への適合状況",null,null,null,null,null,null,"主たる廊下の形状"]
[null,"再生可能エネルギーを除いた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(ROUNDUP((F35+F37+F39+F41+F43+F50-(F52-F57))/1000+G65,1)),\"\",ROUNDUP((F35+F37+F39+F41+F43+F50-(F52-F57))/1000+G65,1))","v":""},null,"設計一次エネルギー消費量（太陽光除く）の合計（GJ）",null,null,null,null,null,"←標準入力法の計算結果より転記（太陽光除く、その他含む）"]
[null,"再生可能エネルギーを除いた一次エネルギー消費削減量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(E62-G511),\"\",E62-G511)","v":""},null,"共用部の太陽光発電による削減量（自己消費量）(MJ)",null,null,null,{"$f":"IF(M509=\"\",\"\",IF(M510=\"―（手入力）\",\"\",IF(M510=\"屋外\",0,IF(M510=\"屋内\",IF(M509=\"住戸・共用部で共有\",IF(F59/1000>=M511,M511*1000*0.3,F59*0.3),IF(M513>=M511,M511*1000*0.3,M513*1000*0.3))))))","v":""},null,"←主たる廊下の形状を「―（手入力）」とした場合、別途計算の上、数値を正数入力してください。"]
[null,"再生可能エネルギーを除いた一次エネルギー消費量削減率(%) ",null,null,null,null,{"$f":"IF(ISERROR(G512/E62),\"\",ROUNDDOWN(G512/E62*100,0))","v":""},null,"共用部の太陽光発電量（総発電量）(GJ)",null,null,null,null,null,"←正数入力してください"]
[null,"再生可能エネルギーを加えた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(ROUNDUP((F35+F37+F39+F41+F43-F52-F54)/1000+G68,1)),\"\",IF((F35+F37+F39+F41+F43-F52-F54)<0,ROUNDDOWN((F35+F37+F39+F41+F43-F52-F54)/1000+G68,1),ROUNDUP((F35+F37+F39+F41+F43-F52-F54)/1000+G68,1)))","v":""},null,"※共用部の計算方法が標準入力法の場合のみ、入力が必要です。"]
[null,"再生可能エネルギーを加えた一次エネルギー消費削減量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(E62-G514),\"\",E62-G514)","v":""},null,"※黒塗りのセルへの入力は不要です。"]
[null,"再生可能エネルギーを加えた一次エネルギー消費量削減率(%) ",null,null,null,null,{"$f":"IF(ISERROR(G515/E62),\"\",ROUNDDOWN(G515/E62*100,0))","v":""},null,"※太陽光発電設備を非住宅用途と共有する場合、本シートは利用できませんので、ご相談ください。"]
[null,"住棟の「ＺＥＨ―Ｍマーク」に関する表示",null,null,null,null,{"$f":"IF(OR(AND(E13=$E$485,G509=\"全住戸適合\",G510=\"全住戸適合\",G513>=20,G516>=100),AND(E13=$E$486,G509=\"全住戸適合\",G510=\"全住戸適合\",G513>=20,G516>=75,G516<100),AND(E13=$E$487,G509=\"全住戸適合\",G510=\"全住戸適合\",G513>=20,G516>=50,G516<75),AND(E13=$E$488,G509=\"全住戸適合\",G510=\"全住戸適合\",G513>=20,G516<50)),\"適合\",\"-\")","v":"-"}]
[]
[]
[null,null,"本シートの作成手順"]
[null,null,"【住戸部分】"]
[null,null,"1.本シートの最下行のＰＤＦ出力結果貼付セルに各住戸の一次エネルギー消費量計算結果（住宅）のＰＤＦをペーストする。（表の緑色のセルに数値が入力されます。）"]
[null,null,"　①一次エネルギー消費量計算結果（住宅）のＰＤＦ全体を選択（Ctrl+A）⇒②ＰＤＦ全体をコピー（Ctrl+C）⇒③このシートの貼付セルに貼付け（Ctrl+V）"]
[null,null,"　④貼付けを取消したいときは、CLEARボタンを押してください。ALL CLEARではすべての貼付け内容が消去されます。"]
[null,null,"　　（建築物エネルギー消費性能基準[Ｈ28年4月以降]V2.6.1以降のＰＤＦに対応、今後のバージョン変更によって貼付けできなくなる可能性があります。）"]
[null,null,"　　※Adobe以外のアプリケーションで展開したPDFファイルについては保障されていません。適切な計算結果が読み込めない場合があります。"]
[null,null,"2.住戸名称を入力することで、デフォルト入力される項目を希望する選択肢に変更"]
[null,null,"3.自動で入力されないセル(薄い黄色）に必要事項を入力"]
[]
[null,null,"【共用部】"]
[null,null,"1.本シートのE6のセルで住棟全体について申請するを選択する。"]
[null,null,"2.本シートのG6のセルで共用部について、「あり（計算する）」、「あり（計算除外）」、「なし」のいずれかを選択する。"]
[null,null,"3.2で「あり（計算する）」を選択した場合、G23のセルで共用部の計算方法を選択する。"]
[null,null,"4.計算の出力結果より、計算方法に応じて算出される数値を転記する。"]
[null,null,"5.標準入力法の場合で、共用部に太陽光発電設備を搭載している場合は【共同住宅等の共用部の太陽光発電設備に関する事項】に必要な情報を入力する。"]
[null,null,"6.共用部にコージェネレーションシステムを採用している場合は、別途ご相談ください。"]
[]
[null,null,"【住棟のZEH-Mに関わる判定】"]
[null,null,"1.評価対象の住棟の全住戸及び共用部の入力が完了していることを確認する。"]
[null,null,"2.全住戸の外皮の省エネ基準への適合状況を確認し、全てが「適合」となっていれば、G509セルを「全住戸適合」とする。"]
[null,null,"3.全住戸の強化外皮基準への適合状況を確認し、全てが「適合」となっていればG510セルを「全住戸適合」とする。"]
[null,null,"4.選択した表示の水準に達してれば、G517セルに「適合」が表示される。"]
[null,null,"5.共用部の計算を除外している場合や外皮性能について住棟評価を選択している場合にはZEH-Mに関わる判定はできません。"]

{"sheet":"太陽光発電設備の住戸按分計算シート","index":1,"n_rows":49,"n_cols":50,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,37],[3,1,8,35],[35,21,35,32],[36,21,36,32],[37,21,37,32],[28,21,28,32],[29,21,29,32],[38,21,38,32],[39,21,39,32],[22,4,22,10],[22,11,22,17],[22,18,22,20],[22,21,22,32],[23,4,23,10],[23,11,23,17],[23,18,23,20],[23,21,23,32],[19,11,19,17],[19,18,19,20],[19,21,19,32],[20,4,20,10],[20,11,20,17],[20,18,20,20],[20,21,20,32],[45,41,45,47],[33,41,33,47],[34,41,34,47],[40,41,40,47],[41,41,41,47],[42,41,42,47],[37,41,37,47],[38,41,38,47],[28,41,28,47],[29,41,29,47],[30,41,30,47],[31,41,31,47],[32,41,32,47],[39,41,39,47],[47,11,47,17],[47,18,47,20],[47,4,48,10],[48,11,48,17],[48,18,48,20],[47,21,48,32],[14,41,16,47],[17,41,17,47],[18,41,18,47],[19,41,19,47],[20,41,20,47],[21,41,21,47],[22,41,22,47],[23,41,23,47],[43,41,43,47],[44,41,44,47],[24,41,24,47],[25,41,25,47],[26,41,26,47],[27,41,27,47],[35,41,35,47],[36,41,36,47],[46,41,46,47],[47,41,47,47],[44,4,44,10],[44,11,44,17],[44,18,44,20],[44,21,44,32],[45,4,45,10],[45,11,45,17],[45,18,45,20],[45,21,45,32],[46,4,46,10],[46,11,46,17],[46,18,46,20],[46,21,46,32],[43,4,43,10],[43,11,43,17],[43,18,43,20],[43,21,43,32],[30,21,30,32],[31,21,31,32],[40,21,40,32],[41,21,41,32],[32,21,32,32],[33,21,33,32],[42,21,42,32],[21,4,21,10],[21,11,21,17],[21,18,21,20],[21,21,21,32],[34,21,34,32],[24,21,24,32],[25,21,25,32],[26,21,26,32],[27,21,27,32],[10,1,10,7],[10,8,10,37],[12,1,12,14],[12,15,12,22],[14,4,16,10],[14,11,16,17],[14,21,16,32],[12,24,12,29],[12,30,12,37],[14,18,16,20],[17,4,17,10],[17,11,17,17],[17,18,17,20],[17,21,17,32],[18,4,18,10],[18,11,18,17],[18,18,18,20],[18,21,18,32],[19,4,19,10]]}
[]
[null,"太陽光発電設備の住戸按分計算シート"]
[]
[null,"本シートは、1又は複数の太陽光発電設備が複数の住戸に接続されており、発電設備と各住戸の消費の関係が明らかでない場合に各住戸に対応する太陽電池アレイのシステム容量を面積按分する際に利用してください。このシートで算定される「計算用仮想システム容量」をWebプログラムの各住戸の計算へ適用することになります。なお、異なる方位に太陽光発電設備が設置される場合は、本シートをコピーしてご利用ください。（最大４面）"]
[]
[]
[]
[]
[]
[]
[null,"建築物の名称"]
[]
[null,"太陽電池アレイのシステム容量（kW）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"パネルの方位"]
[]
[null,null,null,null,"室名称\n（タイプ名称）",null,null,null,null,null,null,"単位住戸床面積\n（㎡）",null,null,null,null,null,null,"戸数",null,null,"計算用仮想システム容量\n（kW/戸）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位住戸床面積\n×戸数"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"真南から東および西へ15度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"真南から東へ15度以上45度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND($P$13*AP18/$AP$48/S18,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L18*S18","v":0},null,null,null,null,null,null,null,"真南から東へ45度以上75度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から東へ75度以上105度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から東へ105度以上135度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から東へ135度以上165度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から東および西へ165度以上真北まで"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から西へ135度以上165度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から西へ105度以上135度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"L25*S25","v":0},null,null,null,null,null,null,null,"真南から西へ75度以上105度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から西へ45度以上75度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,"真南から西へ15度以上45度未満"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"L44*S44","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L45*S45","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L46*S46","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L47*S47","v":0}]
[null,null,null,null,"合計",null,null,null,null,null,null,{"$f":"SUM(L18:R47)","v":0},null,null,null,null,null,null,{"$f":"SUM(S18:U47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP18:AV47)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"㎡"]

{"sheet":"【参考】共用部の太陽光の扱いについて","index":2,"n_rows":81,"n_cols":1,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["　※計算書における共用部の自己消費量の考え方は選択により以下の通り計算が行われます。"]
[]
["①主たる廊下の形状が「屋外」"]
["　　⇒上記表1により係数が0となるため、自己消費量は0"]
[]
["②主たる廊下の形状が「屋内」"]
["　上記表1により係数は0.3となる。"]
[]
["　②-1太陽光発電設備の共有が「住戸・共用部で共有」の場合"]
["　"]
["　　売電量≧共用部の設計一次エネ（太陽光除き）"]
["　　⇒設計一次エネ（太陽光除き）×0.3が共用部の自己消費量"]
[]
["　　売電量＜共用部の設計一次エネ（太陽光除き）"]
["　　⇒売電量×0.3が共用部の自己消費量"]
[]
["　②-2太陽光発電設備の共有が「共有無し」の場合"]
[]
["　　共用部の太陽光発電量≧共用部の設計一次エネ（太陽光除き）"]
["　　⇒設計一次エネ（太陽光除き）×0.3が共用部の自己消費量"]
[]
["　　共用部の太陽光発電量＜共用部の設計一次エネ（太陽光除き）"]
["　　⇒共用部の太陽光発電量×0.3が共用部の自己消費量"]

{"sheet":"Ver情報","index":3,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["2018-08-08","Ver1.1.0","①ηACが整数となる場合にηACが自動入力されない不具合の解消"]
[null,null,"②住戸のZEH Orientedの太陽光含みの削減率の必要条件を20％以上、50％未満に修正"]
[null,null,"③Verj情報が印刷されない不具合を修正"]
["2018-08-23","Ver1.1.1","①Ｈ列の住戸名称を入力してもデフォルト住戸数「1」が表示されない不具合を解消"]
[null,null,"（Ver1.1.0の使用でも問題はありません。）"]
["2018-09-13","Ver1.2.0","①太陽光発電設備の住戸按分計算シートを新規掲載しました。按分する際にご利用ください。"]
[null,null,"②共用部の計算手法を「照明簡易計算」とした場合、照明設備にマスクがかかる不具合を修正。"]
[null,null,"③【共同住宅等の共用部の太陽光発電設備に関する事項】において、主たる廊下の形状を「屋外」とした場合、共用部の太陽光発電量（総発電量）にマスクがかかる不具合を修正。"]
[null,null,"④「【参考】共用部の太陽光の扱いについて」のシートに共用部の自己消費量の考え方を追記しました。"]
[null,null,"⑤本シートの作成手順に記載の「対応する計算のVer」を2.4.2から2.4.3に修正しました。"]
[null,null,"⑥計算結果貼付けについて、Adobe以外のアプリケーションで展開した場合に適切な計算結果が読み込めないことを記載。"]
["2018/10","Ver2.0.0","WebプログラムVer2.5.0以降の計算書に対応"]
["2018-11-16","Ver2.0.1","計算書において、Ｒ列が表示されていない不具合を修正"]
["2018-11-19","Ver2.0.2","Ｒ列に計算式が反映されていない不具合を修正"]
["2018-11-29","Ｖｅｒ2.1.0"," Ver2.0.2で確認された内容に加え、Ｒ列に計算式が反映されていない不具合を修正"]
["2019-04-22","Ｖｅｒ3.0.0","WebプログラムVer2.6.0以降の計算書に対応"]
["2019/5","Ｖｅｒ3.1.0","太陽光発電設備、コージェネレーション設備ともに設置がない場合、数値が適切に表示されない不具合を解消しました。"]
["2019/7","Ｖｅｒ3.1.1","計算対象面積が正しく反映されない不具合を解消しました。"]
["2019/11","Ver3.2.0","共用部を除外する計算方法と外皮性能の住棟評価に対応しました。"]
["2019/11","Ver3.2.1","共用部がない（長屋等）の場合にZEH-Mの判定ができない不具合を解消しました。"]