{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["計算書","入力の注意点","太陽光発電設備の住戸按分計算シート","【参考】共用部の太陽光の扱いについて","Ver情報"],"not_rendered":{"charts":0,"images":10,"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":549,"n_cols":198,"rows_kept":549,"cut":false,"hidden":false,"merged":[[6,6,8,6],[516,8,516,11],[516,12,516,13],[515,8,515,11],[515,12,515,13],[513,12,513,13],[511,12,511,13],[512,12,512,13],[514,12,514,13],[512,8,512,11],[513,8,513,11],[514,8,514,11],[511,8,511,11],[11,6,21,6],[23,6,25,6],[34,6,36,6],[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],[47,2,50,2],[15,2,15,3],[15,4,15,5],[16,2,18,2],[56,2,56,3],[74,1,74,5],[22,4,22,5],[67,1,67,3],[60,1,60,3],[63,1,63,3],[66,1,66,3],[34,2,44,2],[68,1,68,5],[69,1,69,5],[51,1,58,1],[23,2,33,2],[23,4,33,4],[71,1,71,5],[70,1,70,5],[51,2,51,3],[53,2,53,3],[73,1,73,5],[72,1,72,5],[22,2,22,3],[11,1,11,3],[62,1,62,3],[11,4,11,5],[13,1,13,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],[61,1,61,3],[64,1,64,3],[65,1,65,3],[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],[3,15,3,18],[5,1,5,3],[520,1,520,5],[77,1,77,5],[513,1,513,5],[512,1,512,5],[511,5,511,6],[511,1,511,4],[515,1,515,5],[516,1,516,5],[517,1,517,5],[518,1,518,5],[519,1,519,5],[3,12,3,14],[514,1,514,5],[3,1,3,2]]}
[null,"■住棟一次エネルギー消費量計算書"]
[null,"※申請書第六面及び設計内容説明書に代わる一覧表"]
[]
[null,"物件名",null,null,null,null,"地域区分",{"$f":"IF(H78=\"\",\"\",MID(H83,19,1)*1)","v":""},"住棟の\n延べ面積",null,"総住戸数",{"$f":"SUM(H7:GP7)","v":0},"住戸の存する建築物の用途\n（建築基準法上の用途区分）"]
[null,"住戸名称",null,null,"住棟全体","住戸合計","共用部の有無↓"]
[null,"申請の有無"]
[null,"同一計算結果住戸数"]
[null,"同一計算結果住戸名称"]
[null,"申請対象となる住戸が存する階"]
[null,"計算対象面積",null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF(G10=\"\",\"\",SUM(F10,G10)),F10)","v":""},{"$f":"IF(H10=\"\",\"\",SUM(H11:GP11))","v":""},null,{"$f":"IF(H78=\"\",\"\",LEFT(RIGHT(H82,LEN(H82)-(FIND(\"*\",SUBSTITUTE(H82,\" \",\"*\",3)))),LEN(RIGHT(H82,LEN(H82)-(FIND(\"*\",SUBSTITUTE(H82,\" \",\"*\",3)))))-1)*1)","v":""},{"$f":"IF(I78=\"\",\"\",LEFT(RIGHT(I82,LEN(I82)-(FIND(\"*\",SUBSTITUTE(I82,\" \",\"*\",3)))),LEN(RIGHT(I82,LEN(I82)-(FIND(\"*\",SUBSTITUTE(I82,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",LEFT(RIGHT(BU82,LEN(BU82)-(FIND(\"*\",SUBSTITUTE(BU82,\" \",\"*\",3)))),LEN(RIGHT(BU82,LEN(BU82)-(FIND(\"*\",SUBSTITUTE(BU82,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",LEFT(RIGHT(EG82,LEN(EG82)-(FIND(\"*\",SUBSTITUTE(EG82,\" \",\"*\",3)))),LEN(RIGHT(EG82,LEN(EG82)-(FIND(\"*\",SUBSTITUTE(EG82,\" \",\"*\",3)))))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H10=\"\",\"\",H10*H7)","v":""},{"$f":"IF(I10=\"\",\"\",I10*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU10=\"\",\"\",BU10*BU7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG10=\"\",\"\",EG10*EG7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"改修前のＢＥＩ値",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(P5)=1,\"\",$F$489)","v":""},null,"","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AP5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BV5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DB5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EH5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FN5)=1,\"\",$F$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"ＺＥＨマーク・ゼロエネ相当等表示",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(P5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AP5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BV5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(DB5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EH5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FN5)=1,\"\",$D$494)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考情報（二次エネ以外）の掲載の選択",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(P5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AN5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CZ5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FL5)=1,\"\",$G$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"外皮性能","評価手法（住戸評価or住棟評価）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(P5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AN5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CZ5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FL5)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"表示希望の選択",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(P5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AN5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CZ5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FL5)=1,\"\",$P$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"設計値","ＵＡ",{"$f":"IF(ISERROR(SUM(H18:GP18)/L4),\"\",ROUNDUP(SUM(H18:GP18)/L4,2))","v":""},null,null,{"$f":"IF(H78=\"\",\"\",LEFT(RIGHT(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1),LEN(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1))-8),LEN(RIGHT(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1),LEN(INDEX(H79:H480,MATCH(\"外皮平均熱貫流率*\",H79:H480,0),1))-8))-5)*1)","v":""},{"$f":"IF(I78=\"\",\"\",LEFT(RIGHT(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1),LEN(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1))-8),LEN(RIGHT(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1),LEN(INDEX(I79:I480,MATCH(\"外皮平均熱貫流率*\",I79:I480,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",LEFT(RIGHT(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1),LEN(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1))-8),LEN(RIGHT(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1),LEN(INDEX(BU79:BU480,MATCH(\"外皮平均熱貫流率*\",BU79:BU480,0),1))-8))-5)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",LEFT(RIGHT(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,0),1),LEN(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,0),1))-8),LEN(RIGHT(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,0),1),LEN(INDEX(EG79:EG480,MATCH(\"外皮平均熱貫流率*\",EG79:EG480,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(H78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(H79:H480,MATCH(\"平均日射熱取得率暖房期*\",H79:H480,0),1),3),\":\",\"\")*1)","v":""},{"$f":"IF(I78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(I79:I480,MATCH(\"平均日射熱取得率暖房期*\",I79:I480,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(BU79:BU480,MATCH(\"平均日射熱取得率暖房期*\",BU79:BU480,0),1),3),\":\",\"\")*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",SUBSTITUTE(RIGHT(INDEX(EG79:EG480,MATCH(\"平均日射熱取得率暖房期*\",EG79:EG480,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,J489:Q496,8)))","v":""},{"$f":"IF(H4=\"\",\"\",IF(E15=\"\",\"\",VLOOKUP(H4,J489:Q496,2)))","v":""},null,{"$f":"IF(OR(H5=\"\",H17=\"\",H19=\"\"),\"\",IF(AND(H17<=VLOOKUP($H$4,$J$489:$M$496,4),H19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AN5=\"\",AN17=\"\",AN19=\"\"),\"\",IF(AND(AN17<=VLOOKUP($H$4,$J$489:$M$496,4),AN19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BT5=\"\",BT17=\"\",BT19=\"\"),\"\",IF(AND(BT17<=VLOOKUP($H$4,$J$489:$M$496,4),BT19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(CZ5=\"\",CZ17=\"\",CZ19=\"\"),\"\",IF(AND(CZ17<=VLOOKUP($H$4,$J$489:$M$496,4),CZ19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EF5=\"\",EF17=\"\",EF19=\"\"),\"\",IF(AND(EF17<=VLOOKUP($H$4,$J$489:$M$496,4),EF19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(FL5=\"\",FL17=\"\",FL19=\"\"),\"\",IF(AND(FL17<=VLOOKUP($H$4,$J$489:$M$496,4),FL19<=VLOOKUP($H$4,$J$489:$N$496,5)),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"住戸の強化外皮基準（ＵＡ）",null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,J489:L496,3))","v":""},null,null,{"$f":"IF(OR(H5=\"\",H17=\"\"),\"\",IF(H17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(AN5=\"\",AN17=\"\"),\"\",IF(AN17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(BT5=\"\",BT17=\"\"),\"\",IF(BT17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(CZ5=\"\",CZ17=\"\"),\"\",IF(CZ17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(EF5=\"\",EF17=\"\"),\"\",IF(EF17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(OR(FL5=\"\",FL17=\"\"),\"\",IF(FL17<=VLOOKUP($H$4,$J$489:$M$496,3),\"適合\",\"-\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"一次エネルギー消費量","評価手法",null,"性能基準",null,null,null,{"$f":"IF(COUNTBLANK(I13)=1,\"\",$C$489)","v":""},"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(AN13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(BT13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(CZ13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(EF13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(COUNTBLANK(FL13)=1,\"\",$C$489)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"         基準値\n\n共用部 \n標準入力:MJ/延床㎡年\n\n住戸:MJ","暖房",null,{"$f":"SUM(H25:GP25)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H85,FIND(\" \",H85),10)*1),\"\",MID(H85,FIND(\" \",H85),10)*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(MID(I85,FIND(\" \",I85),10)*1),\"\",MID(I85,FIND(\" \",I85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(MID(BU85,FIND(\" \",BU85),10)*1),\"\",MID(BU85,FIND(\" \",BU85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(MID(EG85,FIND(\" \",EG85),10)*1),\"\",MID(EG85,FIND(\" \",EG85),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H24=\"\",\"\",H24*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT24=\"\",\"\",BT24*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF24=\"\",\"\",EF24*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"冷房",null,{"$f":"SUM(H27:GP27)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H86,FIND(\" \",H86),10)*1),\"\",MID(H86,FIND(\" \",H86),10)*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(MID(I86,FIND(\" \",I86),10)*1),\"\",MID(I86,FIND(\" \",I86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(MID(BU86,FIND(\" \",BU86),10)*1),\"\",MID(BU86,FIND(\" \",BU86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(MID(EG86,FIND(\" \",EG86),10)*1),\"\",MID(EG86,FIND(\" \",EG86),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H26=\"\",\"\",H26*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT26=\"\",\"\",BT26*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF26=\"\",\"\",EF26*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"換気",null,{"$f":"SUM(H29:GP29)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H87,FIND(\" \",H87),10)*1),\"\",MID(H87,FIND(\" \",H87),10)*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(MID(I87,FIND(\" \",I87),10)*1),\"\",MID(I87,FIND(\" \",I87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(MID(BU87,FIND(\" \",BU87),10)*1),\"\",MID(BU87,FIND(\" \",BU87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(MID(EG87,FIND(\" \",EG87),10)*1),\"\",MID(EG87,FIND(\" \",EG87),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",H28*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT28=\"\",\"\",BT28*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF28=\"\",\"\",EF28*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"照明",null,{"$f":"SUM(H31:GP31)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H89,FIND(\" \",H89),10)*1),\"\",MID(H89,FIND(\" \",H89),10)*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(MID(I89,FIND(\" \",I89),10)*1),\"\",MID(I89,FIND(\" \",I89),10)*1))","v":""},{"$f":"IF(J78=\"\",\"\",IF(ISERROR(MID(J89,FIND(\" \",J89),10)*1),\"\",MID(J89,FIND(\" \",J89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(MID(BU89,FIND(\" \",BU89),10)*1),\"\",MID(BU89,FIND(\" \",BU89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(MID(EG89,FIND(\" \",EG89),10)*1),\"\",MID(EG89,FIND(\" \",EG89),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H30=\"\",\"\",H30*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT30=\"\",\"\",BT30*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF30=\"\",\"\",EF30*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"給湯",null,{"$f":"SUM(H33:GP33)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(MID(H88,FIND(\" \",H88),10)*1),\"\",MID(H88,FIND(\" \",H88),10)*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(MID(I88,FIND(\" \",I88),10)*1),\"\",MID(I88,FIND(\" \",I88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(MID(BU88,FIND(\" \",BU88),10)*1),\"\",MID(BU88,FIND(\" \",BU88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(MID(EG88,FIND(\" \",EG88),10)*1),\"\",MID(EG88,FIND(\" \",EG88),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H32=\"\",\"\",H32*H7)","v":""},{"$f":"IF(I32=\"\",\"\",I32*I7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT32=\"\",\"\",BT32*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF32=\"\",\"\",EF32*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"昇降機"]
[null,null,"         設計値\n\n共用部\n標準入力：MJ/延床㎡年\n\n住戸:MJ","暖房",null,{"$f":"SUM(H36:GP36)","v":0},null,{"$f":"IF(H78=\"\",\"\",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(I78=\"\",\"\",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(BU78=\"\",\"\",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(EG78=\"\",\"\",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(H35=\"\",\"\",H35*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT35=\"\",\"\",BT35*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF35=\"\",\"\",EF35*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"冷房",null,{"$f":"SUM(H38:GP38)","v":0},null,{"$f":"IF(H78=\"\",\"\",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(I78=\"\",\"\",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(BU78=\"\",\"\",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(EG78=\"\",\"\",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(H37=\"\",\"\",H37*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT37=\"\",\"\",BT37*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF37=\"\",\"\",EF37*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"換気",null,{"$f":"SUM(H40:GP40)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H87,LEN(H87)-4),FIND(\" \",RIGHT(H87,LEN(H87)-4)))*1),\"\",LEFT(RIGHT(H87,LEN(H87)-4),FIND(\" \",RIGHT(H87,LEN(H87)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I87,LEN(I87)-4),FIND(\" \",RIGHT(I87,LEN(I87)-4)))*1),\"\",LEFT(RIGHT(I87,LEN(I87)-4),FIND(\" \",RIGHT(I87,LEN(I87)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU87,LEN(BU87)-4),FIND(\" \",RIGHT(BU87,LEN(BU87)-4)))*1),\"\",LEFT(RIGHT(BU87,LEN(BU87)-4),FIND(\" \",RIGHT(BU87,LEN(BU87)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG87,LEN(EG87)-4),FIND(\" \",RIGHT(EG87,LEN(EG87)-4)))*1),\"\",LEFT(RIGHT(EG87,LEN(EG87)-4),FIND(\" \",RIGHT(EG87,LEN(EG87)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H39=\"\",\"\",H39*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT39=\"\",\"\",BT39*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF39=\"\",\"\",EF39*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"照明",null,{"$f":"SUM(H42:GP42)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H89,LEN(H89)-4),FIND(\" \",RIGHT(H89,LEN(H89)-4)))*1),\"\",LEFT(RIGHT(H89,LEN(H89)-4),FIND(\" \",RIGHT(H89,LEN(H89)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I89,LEN(I89)-4),FIND(\" \",RIGHT(I89,LEN(I89)-4)))*1),\"\",LEFT(RIGHT(I89,LEN(I89)-4),FIND(\" \",RIGHT(I89,LEN(I89)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU89,LEN(BU89)-4),FIND(\" \",RIGHT(BU89,LEN(BU89)-4)))*1),\"\",LEFT(RIGHT(BU89,LEN(BU89)-4),FIND(\" \",RIGHT(BU89,LEN(BU89)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG89,LEN(EG89)-4),FIND(\" \",RIGHT(EG89,LEN(EG89)-4)))*1),\"\",LEFT(RIGHT(EG89,LEN(EG89)-4),FIND(\" \",RIGHT(EG89,LEN(EG89)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H41=\"\",\"\",H41*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT41=\"\",\"\",BT41*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF41=\"\",\"\",EF41*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"給湯",null,{"$f":"SUM(H44:GP44)","v":0},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H88,LEN(H88)-4),FIND(\" \",RIGHT(H88,LEN(H88)-4)))*1),\"\",LEFT(RIGHT(H88,LEN(H88)-4),FIND(\" \",RIGHT(H88,LEN(H88)-4)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I88,LEN(I88)-4),FIND(\" \",RIGHT(I88,LEN(I88)-4)))*1),\"\",LEFT(RIGHT(I88,LEN(I88)-4),FIND(\" \",RIGHT(I88,LEN(I88)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU88,LEN(BU88)-4),FIND(\" \",RIGHT(BU88,LEN(BU88)-4)))*1),\"\",LEFT(RIGHT(BU88,LEN(BU88)-4),FIND(\" \",RIGHT(BU88,LEN(BU88)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG88,LEN(EG88)-4),FIND(\" \",RIGHT(EG88,LEN(EG88)-4)))*1),\"\",LEFT(RIGHT(EG88,LEN(EG88)-4),FIND(\" \",RIGHT(EG88,LEN(EG88)-4)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H43=\"\",\"\",H43*H7)","v":""},{"$f":"IF(I43=\"\",\"\",I43*I7)","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(H78=\"\",\"\",IF(ISERROR(MID(H90,FIND(\" \",H90),10)*1),\"\",MID(H90,FIND(\" \",H90),10)*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(MID(I90,FIND(\" \",I90),10)*1),\"\",MID(I90,FIND(\" \",I90),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(MID(BU90,FIND(\" \",BU90),10)*1),\"\",MID(BU90,FIND(\" \",BU90),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(MID(EG90,FIND(\" \",EG90),10)*1),\"\",MID(EG90,FIND(\" \",EG90),10)*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H46=\"\",\"\",H46*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT46=\"\",\"\",BT46*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF46=\"\",\"\",EF46*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"設計値（発電設備）","自家消費分",null,{"$f":"IF(H78=\"\",\"\",SUM(H49:GP49))","v":""},{"$f":"IF(OR(G23=\"\",G23=\"照明簡易計算\",G23=\"共用部なし\"),\"\",IF(G23=\"標準入力法\",IFERROR(-M516,0),\"\"))","v":""},{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H91,LEN(H91)-20),FIND(\" \",RIGHT(H91,LEN(H91)-20)))*1),0,LEFT(RIGHT(H91,LEN(H91)-20),FIND(\" \",RIGHT(H91,LEN(H91)-20)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I91,LEN(I91)-20),FIND(\" \",RIGHT(I91,LEN(I91)-20)))*1),0,LEFT(RIGHT(I91,LEN(I91)-20),FIND(\" \",RIGHT(I91,LEN(I91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU91,LEN(BU91)-20),FIND(\" \",RIGHT(BU91,LEN(BU91)-20)))*1),0,LEFT(RIGHT(BU91,LEN(BU91)-20),FIND(\" \",RIGHT(BU91,LEN(BU91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG91,LEN(EG91)-20),FIND(\" \",RIGHT(EG91,LEN(EG91)-20)))*1),0,LEFT(RIGHT(EG91,LEN(EG91)-20),FIND(\" \",RIGHT(EG91,LEN(EG91)-20)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H48=\"\",\"\",H48*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT48=\"\",\"\",BT48*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF48=\"\",\"\",EF48*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,"控除量",null,{"$f":"IF(H80=\"\",\"\",SUM(H51:GP51))","v":""},null,{"$f":"IF(H78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(H92,LEN(H92)-26),FIND(\" \",RIGHT(H92,LEN(H92)-26)))*1),0,LEFT(RIGHT(H92,LEN(H92)-26),FIND(\" \",RIGHT(H92,LEN(H92)-26)))*1))","v":""},{"$f":"IF(I78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(I92,LEN(I92)-26),FIND(\" \",RIGHT(I92,LEN(I92)-26)))*1),0,LEFT(RIGHT(I92,LEN(I92)-26),FIND(\" \",RIGHT(I92,LEN(I92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(BU92,LEN(BU92)-26),FIND(\" \",RIGHT(BU92,LEN(BU92)-26)))*1),0,LEFT(RIGHT(BU92,LEN(BU92)-26),FIND(\" \",RIGHT(BU92,LEN(BU92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IF(ISERROR(LEFT(RIGHT(EG92,LEN(EG92)-26),FIND(\" \",RIGHT(EG92,LEN(EG92)-26)))*1),0,LEFT(RIGHT(EG92,LEN(EG92)-26),FIND(\" \",RIGHT(EG92,LEN(EG92)-26)))*1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H50=\"\",\"\",H50*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT50=\"\",\"\",BT50*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF50=\"\",\"\",EF50*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考値","発電量（ｺｰｼﾞｪﾈﾚｰｼｮﾝ）",null,null,{"$f":"IF(H78=\"\",\"\",SUM(H53:GP53))","v":""},null,{"$f":"IF(H78=\"\",\"\",IFERROR(LEFT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IFERROR(LEFT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IFERROR(LEFT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H52=\"\",\"\",H52*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT52=\"\",\"\",BT52*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF52=\"\",\"\",EF52*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"発電量（太陽光発電）",null,null,{"$f":"IF(H78=\"\",\"\",SUM(H55:GP55))","v":""},{"$f":"IF(OR(G23=\"\",G23=\"照明簡易計算\",G23=\"共用部なし\"),\"\",IF(M513=\"\",0,IF(M513=\"住戸・共用部で共有\",0,M517)))","v":""},{"$f":"IF(H78=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))),FIND(\" \",RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))),FIND(\" \",RIGHT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))))-1)*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IFERROR(LEFT(RIGHT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))),FIND(\" \",RIGHT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,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(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,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(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),LEN(INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1))-FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,0)+1,1),FIND(\" \",INDEX(BT79:BT480,MATCH(\"コージェネレーション太陽光発電*\",BT79:BT480,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(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))+1)),FIND(\" \",RIGHT(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),LEN(INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1))-FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,0)+1,1),FIND(\" \",INDEX(EF79:EF480,MATCH(\"コージェネレーション太陽光発電*\",EF79:EF480,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"}]
[null,null,"売電量（ｺｰｼﾞｪﾈﾚｰｼｮﾝ）",null,null,{"$f":"IF(H81=\"\",\"\",SUM(H58:GP58))","v":""},null,{"$f":"IF(H78=\"\",\"\",IFERROR(H56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN78=\"\",\"\",IFERROR(AN56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT78=\"\",\"\",IFERROR(BT56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ78=\"\",\"\",IFERROR(CZ56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF78=\"\",\"\",IFERROR(EF56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL78=\"\",\"\",IFERROR(FL56*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H57=\"\",\"\",H57*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT57=\"\",\"\",BT57*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF57=\"\",\"\",EF57*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,"売電量（太陽光発電）",null,null,{"$f":"IF(H78=\"\",\"\",SUM(H60:GP60))","v":""},null,{"$f":"IF(H78=\"\",\"\",IFERROR(RIGHT(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),LEN(INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))-FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1),FIND(\" \",INDEX(H79:H480,MATCH(\"コージェネレーション太陽光発電*\",H79:H480,0)+1,1))+1)+1))*1,0))","v":""},{"$f":"IF(I78=\"\",\"\",IFERROR(RIGHT(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),LEN(INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))-FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1),FIND(\" \",INDEX(I79:I480,MATCH(\"コージェネレーション太陽光発電*\",I79:I480,0)+1,1))+1)+1))*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",IFERROR(RIGHT(INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1),LEN(INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1))-FIND(\" \",INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1),FIND(\" \",INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1),FIND(\" \",INDEX(BU79:BU480,MATCH(\"コージェネレーション太陽光発電*\",BU79:BU480,0)+1,1))+1)+1))*1,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",IFERROR(RIGHT(INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1),LEN(INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1))-FIND(\" \",INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1),FIND(\" \",INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1),FIND(\" \",INDEX(EG79:EG480,MATCH(\"コージェネレーション太陽光発電*\",EG79:EG480,0)+1,1))+1)+1))*1,0))","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($G$6=\"あり（計算する）\",IF($G$61=\"\",\"\",IF(ISERROR(F61+G62),\"\",F61+G62)),F61)","v":0},{"$f":"SUM(H62:GP62)","v":0},null,{"$f":"IF(H78=\"\",\"\",LEFT(RIGHT(H94,LEN(H94)-35),FIND(\" \",RIGHT(H94,LEN(H94)-35))-1)*1)","v":""},{"$f":"IF(I78=\"\",\"\",LEFT(RIGHT(I94,LEN(I94)-35),FIND(\" \",RIGHT(I94,LEN(I94)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",LEFT(RIGHT(BU94,LEN(BU94)-35),FIND(\" \",RIGHT(BU94,LEN(BU94)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",LEFT(RIGHT(EG94,LEN(EG94)-35),FIND(\" \",RIGHT(EG94,LEN(EG94)-35))-1)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"BEI算定用　設計一次エネ",null,null,null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF($G$23=\"標準入力法\",G61,IF($G$23=\"照明簡易計算\",ROUNDUP(G61/1000,1))),0)","v":0},{"$f":"IF(H61=\"\",\"\",H61*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN61=\"\",\"\",AN61*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT61=\"\",\"\",BT61*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ61=\"\",\"\",CZ61*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF61=\"\",\"\",EF61*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL61=\"\",\"\",FL61*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考　設計一次エネ（設備の合計）",null,null,{"$f":"IF(ISERROR(SUM(F63,G63)),\"\",SUM(F63,G63))","v":0},{"$f":"ROUNDUP(SUM(F35,F37,F39,F41,F43,F48,F50)/1000,1)","v":0},{"$f":"IF($G$6=\"あり（計算する）\",IF($G$23=\"標準入力法\",AC506,IF($G$23=\"照明簡易計算\",ROUNDUP(G61/1000,1))),0)","v":0}]
[null,"基準一次エネルギー消費量（その他除く）",null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF(G64=\"\",\"\",IF(ISERROR(F64+G65),\"\",F64+G65)),F64)","v":0},{"$f":"SUM(H65:GP65)","v":0},null,{"$f":"IF(H78=\"\",\"\",MID(RIGHT(H94,LEN(H94)-35),FIND(\" \",RIGHT(H94,LEN(H94)-35)),10)*1)","v":""},{"$f":"IF(I78=\"\",\"\",MID(RIGHT(I94,LEN(I94)-35),FIND(\" \",RIGHT(I94,LEN(I94)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",MID(RIGHT(BU94,LEN(BU94)-35),FIND(\" \",RIGHT(BU94,LEN(BU94)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",MID(RIGHT(EG94,LEN(EG94)-35),FIND(\" \",RIGHT(EG94,LEN(EG94)-35)),10)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"BEI算定用　基準一次エネ",null,null,null,null,{"$f":"IF($G$6=\"あり（計算する）\",IF($G$23=\"標準入力法\",G64,IF($G$23=\"照明簡易計算\",ROUNDUP(G64/1000,1))),0)","v":0},{"$f":"IF(H64=\"\",\"\",H64*H7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AN64=\"\",\"\",AN64*AN7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BT64=\"\",\"\",BT64*BT7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CZ64=\"\",\"\",CZ64*CZ7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EF64=\"\",\"\",EF64*EF7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(FL64=\"\",\"\",FL64*FL7)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"参考　基準一次エネ（設備の合計）",null,null,{"$f":"IF(ISERROR(SUM(F66,G66)),\"\",SUM(F66,G66))","v":0},{"$f":"ROUNDUP(SUM(F24,F26,F28,F30,F32)/1000,1)","v":0},{"$f":"IF($G$6=\"あり（計算する）\",IF($G$23=\"標準入力法\",AC504,IF($G$23=\"照明簡易計算\",ROUNDUP(G64/1000,1))),0)","v":0}]
[null,"ＢＥＩ",null,null,{"$f":"IF(OR(E10=\"\",G6=\"\"),\"\",IF(ISERROR(E61/E64),\"\",ROUNDUP(E61/E64,2)))","v":""},null,null,{"$f":"IF(H78=\"\",\"\",RIGHT(H95,4)*1)","v":""},{"$f":"IF(I78=\"\",\"\",RIGHT(I95,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU78=\"\",\"\",RIGHT(BU95,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG78=\"\",\"\",RIGHT(EG95,4)*1)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"☆数",null,null,{"$f":"IF(E67=\"\",\"\",IF(E67<=0.8,\"☆☆☆☆☆\",IF(E67<=0.85,\"☆☆☆☆\",IF(E67<=0.9,\"☆☆☆\",IF(E67<=1,\"☆☆\",IF(E67<=1.1,\"☆\",\"-\"))))))","v":""},null,null,{"$f":"IF(H67=\"\",\"\",IF(H67<=0.8,\"☆☆☆☆☆\",IF(H67<=0.85,\"☆☆☆☆\",IF(H67<=0.9,\"☆☆☆\",IF(H67<=1,\"☆☆\",IF(H67<=1.1,\"☆\",\"-\"))))))","v":""},{"$f":"IF(I67=\"\",\"\",IF(I67<=0.8,\"☆☆☆☆☆\",IF(I67<=0.85,\"☆☆☆☆\",IF(I67<=0.9,\"☆☆☆\",IF(I67<=1,\"☆☆\",IF(I67<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BU67=\"\",\"\",IF(BU67<=0.8,\"☆☆☆☆☆\",IF(BU67<=0.85,\"☆☆☆☆\",IF(BU67<=0.9,\"☆☆☆\",IF(BU67<=1,\"☆☆\",IF(BU67<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EG67=\"\",\"\",IF(EG67<=0.8,\"☆☆☆☆☆\",IF(EG67<=0.85,\"☆☆☆☆\",IF(EG67<=0.9,\"☆☆☆\",IF(EG67<=1,\"☆☆\",IF(EG67<=1.1,\"☆\",\"-\"))))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(OR($G$6=\"なし\",$G$6=\"あり（計算除外）\"),0,IF($G$23=\"標準入力法\",AC508,IF($G$23=\"照明簡易計算\",G63,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((AN35+AN37+AN39+AN41+AN43+AN50-(AN52-AN57))/1000,1)),\"\",ROUNDUP((AN35+AN37+AN39+AN41+AN43+AN50-(AN52-AN57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((BT35+BT37+BT39+BT41+BT43+BT50-(BT52-BT57))/1000,1)),\"\",ROUNDUP((BT35+BT37+BT39+BT41+BT43+BT50-(BT52-BT57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((CZ35+CZ37+CZ39+CZ41+CZ43+CZ50-(CZ52-CZ57))/1000,1)),\"\",ROUNDUP((CZ35+CZ37+CZ39+CZ41+CZ43+CZ50-(CZ52-CZ57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((EF35+EF37+EF39+EF41+EF43+EF50-(EF52-EF57))/1000,1)),\"\",ROUNDUP((EF35+EF37+EF39+EF41+EF43+EF50-(EF52-EF57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((FL35+FL37+FL39+FL41+FL43+FL50-(FL52-FL57))/1000,1)),\"\",ROUNDUP((FL35+FL37+FL39+FL41+FL43+FL50-(FL52-FL57))/1000,1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた一次エネルギー消費削減量(GJ)",null,null,null,null,null,{"$f":"IF(ISERROR(H64-H69),\"\",H64-H69)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BT64-BT69),\"\",BT64-BT69)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EF64-EF69),\"\",EF64-EF69)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを除いた一次エネルギー消費量削減率(%) ",null,null,null,null,null,{"$f":"IF(ISERROR(H70/H64),\"\",ROUNDDOWN(H70/H64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BT70/BT64),\"\",ROUNDDOWN(BT70/BT64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EF70/EF64),\"\",ROUNDDOWN(EF70/EF64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(OR($G$6=\"なし\",$G$6=\"あり（計算除外）\"),0,IF($G$23=\"標準入力法\",AC509,IF($G$23=\"照明簡易計算\",G63,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((AN35+AN37+AN39+AN41+AN43-AN52-AN54)/1000,1)),\"\",IF((AN35+AN37+AN39+AN41+AN43-AN52-AN54)<0,ROUNDDOWN((AN35+AN37+AN39+AN41+AN43-AN52-AN54)/1000,1),ROUNDUP((AN35+AN37+AN39+AN41+AN43-AN52-AN54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((BT35+BT37+BT39+BT41+BT43-BT52-BT54)/1000,1)),\"\",IF((BT35+BT37+BT39+BT41+BT43-BT52-BT54)<0,ROUNDDOWN((BT35+BT37+BT39+BT41+BT43-BT52-BT54)/1000,1),ROUNDUP((BT35+BT37+BT39+BT41+BT43-BT52-BT54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((CZ35+CZ37+CZ39+CZ41+CZ43-CZ52-CZ54)/1000,1)),\"\",IF((CZ35+CZ37+CZ39+CZ41+CZ43-CZ52-CZ54)<0,ROUNDDOWN((CZ35+CZ37+CZ39+CZ41+CZ43-CZ52-CZ54)/1000,1),ROUNDUP((CZ35+CZ37+CZ39+CZ41+CZ43-CZ52-CZ54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((EF35+EF37+EF39+EF41+EF43-EF52-EF54)/1000,1)),\"\",IF((EF35+EF37+EF39+EF41+EF43-EF52-EF54)<0,ROUNDDOWN((EF35+EF37+EF39+EF41+EF43-EF52-EF54)/1000,1),ROUNDUP((EF35+EF37+EF39+EF41+EF43-EF52-EF54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(ROUNDUP((FL35+FL37+FL39+FL41+FL43-FL52-FL54)/1000,1)),\"\",IF((FL35+FL37+FL39+FL41+FL43-FL52-FL54)<0,ROUNDDOWN((FL35+FL37+FL39+FL41+FL43-FL52-FL54)/1000,1),ROUNDUP((FL35+FL37+FL39+FL41+FL43-FL52-FL54)/1000,1)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた一次エネルギー消費削減量(GJ)",null,null,null,null,null,{"$f":"IF(ISERROR(H64-H72),\"\",H64-H72)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BT64-BT72),\"\",BT64-BT72)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EF64-EF72),\"\",EF64-EF72)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"再生可能エネルギーを加えた一次エネルギー消費量削減率(%) ",null,null,null,null,null,{"$f":"IF(ISERROR(H73/H64),\"\",ROUNDDOWN(H73/H64*100,0))","v":""},{"$f":"IF(ISERROR(I73/I64),\"\",ROUNDDOWN(I73/I64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(BU73/BU64),\"\",ROUNDDOWN(BU73/BU64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR(EG73/EG64),\"\",ROUNDDOWN(EG73/EG64*100,0))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"住宅の「ＺＥＨマーク」、「ゼロエネ相当」に関する表示",null,null,null,null,null,{"$f":"IF(OR(AND(H13=$D$489,H21=\"適合\",H22=\"適合\",H71>=20,H74>=100),AND(H13=$D$490,H21=\"適合\",H22=\"適合\",H71>=20,H74>=75,H74<100),AND(H13=$D$491,H21=\"適合\",H22=\"適合\",H71>=20,H74>=50,H74<75),AND(H13=$D$492,H21=\"適合\",H22=\"適合\",H71>=20,H74>=20,H74<50),AND(H13=$D$493,H21=\"適合\",H71>=20,H74>=100)),\"適合\",\"-\")","v":"-"},{"$f":"IF(OR(AND(I13=$D$489,I21=\"適合\",I22=\"適合\",I71>=20,I74>=100),AND(I13=$D$490,I21=\"適合\",I22=\"適合\",I71>=20,I74>=75,I74<100),AND(I13=$D$491,I21=\"適合\",I22=\"適合\",I71>=20,I74>=50,I74<75),AND(I13=$D$492,I21=\"適合\",I22=\"適合\",I71>=20,I74>=20,I74<50),AND(I13=$D$493,I21=\"適合\",I71>=20,I74>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(OR(AND(BU13=$D$489,BU21=\"適合\",BU22=\"適合\",BU71>=20,BU74>=100),AND(BU13=$D$490,BU21=\"適合\",BU22=\"適合\",BU71>=20,BU74>=75,BU74<100),AND(BU13=$D$491,BU21=\"適合\",BU22=\"適合\",BU71>=20,BU74>=50,BU74<75),AND(BU13=$D$492,BU21=\"適合\",BU22=\"適合\",BU71>=20,BU74>=20,BU74<50),AND(BU13=$D$493,BU21=\"適合\",BU71>=20,BU74>=100)),\"適合\",\"-\")","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",{"$f":"IF(OR(AND(EG13=$D$489,EG21=\"適合\",EG22=\"適合\",EG71>=20,EG74>=100),AND(EG13=$D$490,EG21=\"適合\",EG22=\"適合\",EG71>=20,EG74>=75,EG74<100),AND(EG13=$D$491,EG21=\"適合\",EG22=\"適合\",EG71>=20,EG74>=50,EG74<75),AND(EG13=$D$492,EG21=\"適合\",EG22=\"適合\",EG71>=20,EG74>=20,EG74<50),AND(EG13=$D$493,EG21=\"適合\",EG71>=20,EG74>=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":"AA491*$Z$490","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":"AA492*$Z$490","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,"-・6.7","-","-",6.7,null,null,"-・2.8",null,null,null,null,null,null,"設計","空調",null,{"$f":"IF($G$23=\"標準入力法\",G35,\"\")","v":""},{"$f":"AA496*$Z$490","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":""},{"$f":"AA498*$Z$490","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":"AA500*$Z$490","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":"AA501*Z490","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(AB491:AB495)","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(AB491:AB495,AB501)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB505/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(AB496:AB500,AB502)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB506/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(AB496:AB502)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(AB507/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(AB496:AB500)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUNDUP(AB508/1000,1),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(AB496:AB500)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUNDUP(AB509/1000,1)+AC503,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(E67=\"\",\"\",IF((ISERROR(ROUNDUP((F35+F37+F39+F41+F43+F50-(F52-F57))/1000+G69,1))),\"\"\"\",ROUNDUP((F35+F37+F39+F41+F43+F50-(F52-F57))/1000+G69,1)))","v":""},null,"設計一次エネルギー消費量（太陽光除く）の合計（GJ）",null,null,null,null,null,"←標準入力法の計算結果より転記（太陽光除く、その他含む）"]
[null,"再生可能エネルギーを除いた基準一次エネルギー消費削減量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(E66-G515),\"\",E66-G515)","v":""},null,"共用部の太陽光発電による削減量（自己消費量）(MJ)",null,null,null,{"$f":"IF(M513=\"\",\"\",IF(M514=\"―（手入力）\",\"\",IF(M514=\"屋外\",0,IF(M514=\"屋内\",IF(M513=\"住戸・共用部で共有\",IF(F59/1000>=M515*0.3,M515*1000*0.3,F59),IF(M517>=M515*0.3,M515*1000*0.3,M517*1000))))))","v":""},null,"←主たる廊下の形状を「―（手入力）」とした場合、別途計算の上、数値を正数入力してください。"]
[null,"再生可能エネルギーを除いた一次エネルギー消費量削減率(%) ",null,null,null,null,{"$f":"IF(ISERROR(G516/E66),\"\",ROUNDDOWN(G516/E66*100,0))","v":""},null,"共用部の太陽光発電量（総発電量）(GJ)",null,null,null,null,null,"←正数入力してください"]
[null,"再生可能エネルギーを加えた設計一次エネルギー消費量(GJ)",null,null,null,null,{"$f":"IF(E67=\"\",\"\",IF(ISERROR(ROUNDUP((F35+F37+F39+F41+F43-F52-F54)/1000+G72,1)),\"\",IF((F35+F37+F39+F41+F43-F52-F54)<0,ROUNDDOWN((F35+F37+F39+F41+F43-F52-F54)/1000+G72,1),ROUNDUP((F35+F37+F39+F41+F43-F52-F54)/1000+G72,1))))","v":""},null,"※共用部の計算方法が標準入力法の場合のみ、入力が必要です。"]
[null,"再生可能エネルギーを加えた基準一次エネルギー消費削減量(GJ)",null,null,null,null,{"$f":"IF(ISERROR(E66-G518),\"\",E66-G518)","v":""},null,"※黒塗りのセルへの入力は不要です。"]
[null,"再生可能エネルギーを加えた一次エネルギー消費量削減率(%) ",null,null,null,null,{"$f":"IF(ISERROR(G519/E66),\"\",ROUNDDOWN(G519/E66*100,0))","v":""},null,"※太陽光発電設備を非住宅用途と共有する場合、本シートは利用できませんので、ご相談ください。"]
[null,"住棟の「ＺＥＨ―Ｍマーク」に関する表示",null,null,null,null,{"$f":"IF(OR(AND(E13=$E$489,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20,G520>=100),AND(E13=$E$490,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20,G520>=75,G520<100),AND(E13=$E$491,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20,G520>=50,G520<75),AND(E13=$E$492,G513=\"全住戸適合\",G514=\"全住戸適合\",G517>=20)),\"適合\",\"-\")","v":"-"}]
[]
[]
[null,null,"本シートの作成手順"]
[null,null,"【住戸部分】"]
[null,null,"1.本シートの最下行のＰＤＦ出力結果貼付セルに各住戸の一次エネルギー消費量計算結果（住宅）のＰＤＦをペーストする。（表の緑色のセルに数値が入力されます。）"]
[null,null,"　①一次エネルギー消費量計算結果（住宅）のＰＤＦ全体を選択（Ctrl+A）⇒②ＰＤＦ全体をコピー（Ctrl+C）⇒③このシートの貼付セルに貼付け（Ctrl+V）"]
[null,null,"　④貼付けを取消したいときは、CLEARボタンを押してください。ALL CLEARではすべての貼付け内容が消去されます。"]
[null,null,"　　（建築物エネルギー消費性能計算プログラム住宅版Ver.3.0.0以降のＰＤＦに対応、今後のバージョン変更によって貼付けできなくなる可能性があります。）"]
[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に関わる判定はできません。"]
[]
[null,null,"※計算結果が自動計算されない場合は、メニュー「数式」の計算方法が「自動」であるかを確認して下さい。"]

{"sheet":"入力の注意点","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"太陽光発電設備の住戸按分計算シート","index":2,"n_rows":49,"n_cols":50,"rows_kept":49,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
[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":3,"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が共用部の自己消費量"]
[]
["　　売電量＜共用部の設計一次エネ（太陽光除き）×0.3"]
["　　⇒売電量が共用部の自己消費量"]
[]
["　②-2太陽光発電設備の共有が「共有無し」の場合"]
[]
["　　共用部の太陽光発電量≧共用部の設計一次エネ（太陽光除き）×0.3"]
["　　⇒設計一次エネ（太陽光除き）×0.3が共用部の自己消費量"]
[]
["　　共用部の太陽光発電量＜共用部の設計一次エネ（太陽光除き）×0.3"]
["　　⇒共用部の太陽光発電量が共用部の自己消費量"]

{"sheet":"Ver情報","index":4,"n_rows":32,"n_cols":3,"rows_kept":32,"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の判定ができない不具合を解消しました。"]
["2019/12","Ver3.3.0","PDFを読み込んだ際に地域区分が反映しない不具合を解消しました。"]
["2020/3","Ver3.3.1","2020年4月の基準省令の改正に基づき、8地域の冷房期平均日射熱取得率の基準値を変更しました。"]
["2020/4","Ver3.4.0","共用部の太陽光発電の扱いについて修正を行いました。"]
["2020/12","Ver3.4.1","住戸：ZEH Oriented、住棟：ZEH-M Orientedを表示希望する場合、再エネ含みの削減率が50％以上の場合に「適合」が表示されない不具合を修正しました。"]
["2021/4","Ver.3.4.2","売電量（太陽光発電）の計算方法の修正　※計算結果に影響はありません"]
["2021/4","Ver.4.0.0","WebプログラムVer.3.0の計算書に対応"]
["2022/5","Ver.4.1.0","（一社）BELS評価書作成プログラムバージョンアップに伴うBEI及びZEH-Mの削減率の各算定方法の修正"]
[null,null,"上記に伴い共用部において、「設計一次エネルギー消費量の合計値」、「基準一次エネルギー消費量の合計値」を入力するよう変更しました。"]
[null,null,"上記に伴い共用部において、簡易照明計算を選択した場合の入力方法を変更しました。"]
[null,null,"必要項目の入力や選択が無い場合に、BEI及び削減率の計算結果が表示されないよう修正しました。"]
[null,null,"タブ「入力の注意点」を追加"]