{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["台数算定"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"台数算定","index":0,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[25,17,26,17],[25,16,26,16],[25,11,26,11],[25,12,25,13],[23,11,24,11],[36,17,37,17],[42,9,43,20],[34,11,35,11],[34,12,35,12],[36,11,37,11],[36,12,37,12],[36,16,37,16],[39,5,39,6],[23,12,23,14],[24,12,24,14],[2,6,2,7],[4,6,4,7],[31,5,31,6],[21,6,21,7],[23,6,23,7]]}
[null,"駐車施設設置義務判定・算定シート"]
[null,"①～⑦の順に入力・確認をします。（入力は赤枠のみ）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"はい"]
[null,"①","駐車場整備地区ですか",null,null,"⇒",{"$f":"IF(E3=W2,\"③に進みます\",IF(E3=W3,\"②に進みます\",\"指示がここに出ます\"))","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,"e（またはh+i）",null,null,null,"f"]
[null,"②","用途地域は何ですか",null,null,"⇒",{"$f":"IF(X15=1,\"③に進みます\",IF(W15=1,\"附置義務なし\",\"判定又は指示が出ます\"))","v":"判定又は指示が出ます"},null,null,null,null,{"$f":"IF(AND($G$22=\"附置義務あり\",H12>10000),SUM(H18:H19),IF($G$22=\"附置義務あり\",H15,\"\"))","v":""},"÷",300,"＋",{"$f":"IF($G$22=\"附置義務あり\",H16,\"\")","v":""},"÷",450,null,null,null,null,"第一種低層住居専用地域","近隣商業地域"]
[null,null,"※計画敷地が適用地区の内外にわたる場合、敷地の過半を占める地区又は地域で判断します。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"j",null,null,null,null,"第二種低層住居専用地域","商業地域"]
[null,"③","駐車場整備地区、商業地域、近隣商業地域のいずれかに該当する場合、下表に床面積を記入",null,null,null,null,null,null,null,null,null,"＝",{"$f":"IFERROR(L5/N5,\"\")","v":""},"+",{"$f":"IFERROR(P5/R5,\"\")","v":""},"＝",{"$f":"IFERROR(N7+P7,\"\")","v":""},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,"第一種住居地域"]
[null,null,"記号","用途",null,null,null,"床面積（㎡）",null,"事務所面積が１万㎡を超える場合の緩和",null,null,null,null,null,null,null,null,null,null,null,null,"第二種住居地域"]
[null,null,"a","店舗部分の床面積",null,null,null,null,null,"緩和後の事務所面積ｉの算定",null,null,null,null,null,null,null,null,null,null,null,null,"準住居地域"]
[null,null,"b","事務所部分の床面積",null,null,null,null,null,null,"ｲ．","1万㎡を超え5万㎡以下の部分",null,null,null,null,null,null,null,null,null,null,"準工業地域"]
[null,null,"c","倉庫部分の床面積",null,null,null,null,null,null,"（",{"$f":"IF(AND($H$12>10000,$H$12<=50000),$H$12,IF($H$12>50000,50000,\"\"))","v":""},"-",10000,"）","×0.7","＝",{"$f":"IF(L13=\"\",0,(L13-N13)*0.7)","v":0},"（㎡）→b'",null,null,null,"工業地域"]
[null,null,"d","その他の特定用途の床面積",null,null,null,null,null,null,"ﾛ．","5万㎡を超えて10万㎡以下の部分",null,null,null,null,null,null,null,null,null,null,"工業専用地域"]
[null,null,"e","特定用途部分の床面積の合計（a+b+c+d）",null,null,null,{"$f":"SUM(H11:H14)","v":0},null,null,"（",{"$f":"IF(AND($H$12>50000,$H$12<=100000),$H$12,IF($H$12>100000,100000,\"\"))","v":""},"-",50000,"）","×0.6","＝",{"$f":"IF(L15=\"\",0,(L15-N15)*0.6)","v":0},"（㎡）→b''",null,null,null,{"$f":"COUNTIF(W5:W14,$E$5)","v":0},{"$f":"COUNTIF(X5:X6,$E$5)","v":0}]
[null,null,"f","非特定用途部分の床面積の合計",null,null,null,null,null,null,"ﾊ．","10万㎡を超える部分"]
[null,null,"g","建築物の延べ面積（e+f）",null,null,null,{"$f":"H15+H16","v":0},null,null,"（",{"$f":"IF($H$12>100000,$H$12,\"\")","v":""},"-",100000,"）","×0.5","＝",{"$f":"IF(L17=\"\",0,(L17-N17)*0.5)","v":0},"（㎡）→b'''",null,null,null,"第一種低層住居専用地域"]
[null,null,"h","b>10,000㎡のときのb以外の床面積の合計（a+c+d）",null,null,null,{"$f":"IF(H12>10000,H11+H13+H14,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"第二種低層住居専用地域"]
[null,null,"i","b>10,000㎡のときの緩和後の事務所部分bの床面積",null,null,null,{"$f":"R19","v":""},null,null,null,null,null,null,null," i =10,000+b'+b''+b'''","=",{"$f":"IF($H$12>10000,R13+R15+R17+10000,\"\")","v":""},"（㎡）",null,null,null,"第一種中高層住居専用地域"]
[null,null,"m","緩和係数Ｋ算定のための床面積（特定用途部分※＋非特定用途×1/2）",null,null,null,{"$f":"IF(H12>10000,H18+H19,H15)+H16/2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"第二種中高層住居専用地域"]
[null,null,null,"※事務所部分が1万㎡を超える場合は（h+i）、それ以外の場合（e）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"第一種住居地域"]
[null,"④","駐車施設の附置の要否",null,null,null,{"$f":"IF(G5=\"附置義務なし\",\"附置義務なし\",IF(OR(E3=\"\",H11=\"\",H12=\"\",H13=\"\",H14=\"\",H16=\"\"),\"判定が出ます\",IF(H15=0,Y30,Y31)))","v":"判定が出ます"},null,null,"延べ面積ｇが6,000未満の場合の緩和",null,null,null,null,null,null,null,null,null,null,null,null,"第二種住居地域"]
[null,null,"※判断基準：特定用途のみまたは混合用途の場合e(またはh+i)+f/2>1,500㎡、非特定用途のみの場合f/2>3,000㎡",null,null,null,null,null,null,"緩和係数Kの算定",null,null,null,null,null,null,null,null,null,null,null,null,"準住居地域"]
[null,"⑤","荷さばき用の駐車施設の要否",null,null,null,{"$f":"IF(E3=\"いいえ\",\"不要です\",IF(AND(E3=\"はい\",H15>2000),\"荷さばき用が必要です\",IF(OR(E3=\"\",H11=\"\",H12=\"\",H13=\"\",H14=\"\"),\"判定が出ます\",\"不要です\")))","v":"判定が出ます"},null,null,null,null,"K =1－","1,000×（6,000-g)",null,null,null,null,null,null,null,null,null,"近隣商業地域"]
[null,null,"※判断基準：駐車場整備地区内で、特定用途部分の床面積が2,000平方メートルを超える建築物",null,null,null,null,null,null,null,null,null,"6,000×m-1,000×g",null,null,null,null,"K",null,null,null,null,"商業地域"]
[null,null,"荷さばきのための駐車施設の附置台数算定（各部分の床面積を各除数で割算）",null,null,null,null,null,null,null,null,"   =1－",6000,null,"-",{"$f":"IF(AND(G22=\"附置義務あり\",H17<6000),H17,\"\")","v":""},"＝",{"$f":"IFERROR(1-((M26-P26)/(6*N27-P27)),\"\")","v":""},null,null,null,null,"準工業地域"]
[null,null,"記号","用途",null,"床面積（㎡）","除数（㎡）","台数（台）",null,null,null,null,"6×",{"$f":"IF(AND(G22=\"附置義務あり\",H17<6000),H20,\"\")","v":""},"-",{"$f":"P26","v":""},null,null,null,null,null,null,"工業地域"]
[null,null,"a","店舗部分",null,{"$f":"IF(G24=\"荷さばき用が必要です\",H11,\"\")","v":""},3000,{"$f":"IFERROR(F28/G28,\"\")","v":""},null,"緩和後の附置台数の算定",null,null,null,null,null,null,null,null,null,null,null,null,"工業専用地域"]
[null,null,"b","事務所部分",null,{"$f":"IF(G$24=\"荷さばき用が必要です\",H12,\"\")","v":""},5000,{"$f":"IFERROR(F29/G29,\"\")","v":""},null,null,null,null,null,"j",null,"K",null,"n"]
[null,null,"c","倉庫部分",null,{"$f":"IF(G$24=\"荷さばき用が必要です\",H13,\"\")","v":""},1500,{"$f":"IFERROR(F30/G30,\"\")","v":""},null,null,null,null,null,{"$f":"IF(H17<6000,R7,\"\")","v":""},"×",{"$f":"R26","v":""},"=",{"$f":"IFERROR(N30*P30,\"\")","v":""},null,null,null,null,{"$f":"IF(H15=0,H16/2,0)","v":0},3000,{"$f":"IF(W30>X30,\"附置義務あり\",\"附置義務なし\")","v":"附置義務なし"}]
[null,null,"d","その他の特定用途の部分",null,{"$f":"IF(G$24=\"荷さばき用が必要です\",H14,\"\")","v":""},4000,{"$f":"IFERROR(F31/G31,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H15>0,H15+H16/2,0)","v":0},1500,{"$f":"IF(W31>X31,\"附置義務あり\",\"附置義務なし\")","v":"附置義務なし"}]
[null,null,"p","合計",null,null,null,{"$f":"SUM(H28:H31)","v":0}]
[null,null,null,null,null,null,null,null,null,"延べ面積eが6,000未満の場合の荷さばき用駐車施設台数の緩和"]
[null,"⑥","駐車施設の必要台数",null,null,null,null,null,null,"緩和係数kの算定"]
[null,null,"必要附置台数合計",null,null,{"$f":"IFERROR(IF(AND(G22=\"附置義務あり\",H17>=6000),ROUNDUP(R7,0),IF(G22=\"附置義務あり\",ROUNDUP(R30,0),0)),0)","v":0},"台",null,null,null,null,"k =1","-","6,000-e"]
[null,null,"上記附置台数のうち荷さばき車両用スペース",null,null,{"$f":"IF(G24=\"荷さばき用が必要です\",IF(H15>=6000,ROUNDUP(H32,0),ROUNDUP(R41,0)),0)","v":0},"台",null,null,null,null,null,null,"2e",null,null,null,"k"]
[null,null,"上記附置台数のうち車いす利用者用スペース",null,null,{"$f":"IF(F35>0,1,0)","v":0},"台",null,null,null,null,"   =1","-",6000,"-",{"$f":"IF(AND(G24=\"荷さばき用が必要です\",H15<6000),H15,\"\")","v":""},"＝",{"$f":"IFERROR(ROUND(1-(N37-P37)/(N38*P38),2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"×",{"$f":"P37","v":""}]
[null,"⑦","設置予定台数を入力してください。",null,null,null,null,null,null,"緩和後の附置台数の算定"]
[null,null,"駐車施設の種別",null,null,"台数",null,"判定",null,null,null,null,null,"p",null,"k",null,"q"]
[null,null,"一般車両用スペース",null,null,null,"台",{"$f":"IF(F41<F35-(F42+F43),\"NG\",\"OK\")","v":"OK"},null,null,null,null,null,{"$f":"IF(AND(G24=\"荷さばき用が必要です\",H15<6000),H32,\"\")","v":""},"×",{"$f":"IF(AND(G24=\"荷さばき用が必要です\",H15<6000),R37,\"\")","v":""},"=",{"$f":"IFERROR(N41*P41,\"\")","v":""}]
[null,null,"荷さばき車両用スペース",null,null,null,"台",{"$f":"IF(F42<F36,\"NG\",\"OK\")","v":"OK"}]
[null,null,"車いす利用者用スペース",null,null,null,"台",{"$f":"IF(F43<F37,\"NG\",\"OK\")","v":"OK"},null,"特定用途：劇場、映画館、演芸場、観覧場、放送用ｽﾀｼﾞｵ、公会堂、集会場、展示場、結婚式場、斎場、旅館、ﾎﾃﾙ、料理店、飲食店、待合、ｷｬﾊﾞﾚｰ、ｶﾌｪ、ﾅｲﾄｸﾗﾌﾞ、ﾊﾞｰ、舞踊場、遊技場、体育館、百貨店その他の店舗、病院、事務所、卸売市場、倉庫、工場"]
[null,null,"附置台数合計",null,null,{"$f":"SUM(F41:F43)","v":0},"台",{"$f":"IF(F44<F35,\"NG\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,"非特定用途：寺社仏閣、共同住宅、駅舎等、特定用途以外の用途"]