{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["管理状況届出書（データ提出用）","DATA"],"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":86,"n_cols":51,"rows_kept":86,"cut":false,"hidden":false,"merged":[[1,16,1,34],[3,36,3,38],[3,39,3,41],[3,44,3,45],[3,48,3,49],[5,29,5,44],[20,0,21,9],[13,11,13,31],[13,0,13,9],[16,0,17,9],[6,30,6,32],[9,41,9,46],[5,19,5,27],[6,19,7,27],[8,19,8,27],[9,19,9,27],[6,33,6,34],[6,35,6,38],[9,29,9,33],[9,35,9,39],[7,29,7,50],[8,29,8,50],[10,29,10,50],[25,0,25,9],[25,11,25,50],[26,0,26,9],[23,0,24,9],[24,11,24,13],[24,14,24,17],[24,18,24,27],[24,28,24,50],[22,0,22,9],[29,11,29,23],[30,0,30,9],[30,14,30,17],[30,21,30,22],[28,0,28,9],[10,19,10,27],[28,21,28,23],[26,11,26,23],[30,27,30,35],[10,3,10,14],[20,10,20,51],[14,0,15,9],[15,11,15,43],[28,14,28,16],[12,0,12,51],[17,11,17,35],[21,11,21,50],[29,0,29,9],[26,43,26,44],[27,0,27,9],[27,14,27,17],[27,40,27,42],[27,47,27,49],[22,11,22,18],[85,0,86,9],[86,11,86,50],[66,21,66,28],[31,0,31,9],[32,0,32,9],[32,36,32,49],[79,0,79,9],[79,11,79,21],[82,0,84,9],[84,27,84,34],[76,0,76,9],[76,11,76,21],[76,27,76,35],[70,16,70,20],[71,0,71,9],[71,11,71,16],[42,27,42,35],[82,18,82,35],[65,37,65,39],[61,17,61,20],[61,26,61,28],[61,33,61,34],[60,17,60,20],[72,16,72,25],[78,0,78,9],[78,11,78,21],[78,27,78,35],[57,17,57,20],[57,26,57,28],[57,33,57,34],[60,26,60,28],[58,17,58,20],[72,0,73,9],[63,0,66,9],[63,11,63,15],[62,0,62,9],[73,16,73,25],[64,26,64,29],[64,33,64,37],[65,21,65,24],[65,30,65,32],[62,11,62,22],[59,26,59,28],[59,33,59,34],[67,0,70,9],[77,11,77,21],[67,21,67,30],[31,11,31,22],[60,33,60,34],[56,0,61,9],[42,11,42,16],[52,0,52,9],[39,11,39,21],[55,31,55,38],[50,0,50,9],[51,0,51,9],[51,11,51,18],[40,11,40,27],[52,11,52,15],[51,27,51,35],[47,21,47,28],[48,15,48,20],[54,31,54,38],[33,0,37,9],[33,11,33,19],[33,21,33,49],[37,23,37,49],[43,11,43,16],[44,0,44,9],[44,11,44,16],[45,0,45,9],[53,0,53,9],[53,11,53,18],[54,0,55,9],[46,0,48,9],[39,0,39,9],[40,0,40,9],[54,10,54,30],[46,11,46,20],[41,0,41,9],[41,11,41,16],[42,0,42,9],[49,0,49,9],[50,11,50,25],[41,33,41,37],[49,35,49,38],[50,43,50,46],[69,16,69,26],[57,43,57,45],[58,26,58,28],[58,33,58,34],[59,17,59,20],[49,11,49,16],[46,21,46,28],[45,11,45,16],[57,48,57,50],[58,48,58,50],[59,48,59,50],[60,48,60,50],[61,48,61,50],[83,28,83,45],[58,43,58,45],[59,43,59,45],[60,43,60,45],[61,43,61,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,null,null,null,null,null,null,null,null,"（必須）",null,null,"令和",null,null,null,null,null,"年",null,null,null,"月",null,null,null,"日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"【届出者】"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　属性（必須）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　住所（必須）",null,null,null,null,null,null,null,null,"〒",null,null,null,null,"―"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　氏名（必須）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　電話番号（必須）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"－",null,null,null,null,null,"－"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　Email"]
[]
["神戸市マンション管理の適正化の推進に関する要綱第4条第1項、第2項、第５条第３項の規定により下記の通り届け出ます。この届出書に記載の事項は、事実に相違ありません。"]
["届出の種別（必須）"]
["総会等での決議（必須）",null,null,null,null,null,null,null,null,null,"届け出について、"]
[]
["情報開示の取扱い\n（必須）",null,null,null,null,null,null,null,null,null,"届出について、神戸市による情報開示の取扱について申告します。"]
[]
[]
["<マンションの概要>"]
["1.マンション名・号棟\n（必須）",null,null,null,null,null,null,null,null,null,"（マンション名と号棟名との間は空白を空けずに記入　マンション名の末尾が数字でかつ数字の号棟名が続く場合はマンション名と号棟名の間に「・」を入力）"]
[]
["2.マンション識別番号\n（必須）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（数字１０桁）"]
["3.所在地（住居表示）\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,"（丁目・字・番地）（例：1丁目2番地3号の場合⇒1-2-3で入力）"]
[null,null,null,null,null,null,null,null,null,null,null,"神戸市"]
["4.管理組合名"]
["5.管理組合の形態",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（団地管理組合である場合）→全体の棟数　全",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"棟"]
["6.戸数（必須）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"戸",null,"（１棟あたりの戸数）"]
["7.階数（必須）",null,null,null,null,null,null,null,null,null,null,"地上",null,null,null,null,null,"階／地下",null,null,null,null,null,null,"階"]
["8.構造（主たる部分）（必須）"]
["9.竣工年月（必須）",null,null,null,null,null,null,null,null,null,"（西暦）",null,null,null,null,null,null,null,null,"年",null,null,null,"月"]
["10.土地の権利"]
["11.併設用途",null,null,null,null,null,null,null,null,null,null,"□",null,"なし",null,null,null,"□",null,"店舗",null,null,null,"□",null,"事務所",null,null,null,null,"□",null,"その他（",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"）"]
["12.管理形態"]
[null,null,null,null,null,null,null,null,null,null,"※「全部委託」又は「一部委託」の場合は、以下記載してください。"]
[null,null,null,null,null,null,null,null,null,null,null,null,"（この項目の記載内容は情報開示の同意がある場合でも開示されません）"]
[null,null,null,null,null,null,null,null,null,null,null,"[管理業者]"]
[null,null,null,null,null,null,null,null,null,null,null,null,"会社名（支店名も記入）"]
["<適正な維持管理に関する事項>"]
["13.管理組合（必須）"]
["14.管理者等（必須）"]
["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,"年"]
["16.区分所有者名簿"]
["17.居住者名簿"]
["18.空き住戸（割合）"]
["19.賃貸化住戸（割合）"]
["20.総会の開催",null,null,null,null,null,null,null,null,null,null,"年１回以上の開催（必須）"]
[null,null,null,null,null,null,null,null,null,null,null,"総会の議事録"]
[null,null,null,null,null,null,null,null,null,null,null,"出席率",null,null,null,null,null,null,null,null,null,"（書面行使を含む）"]
["21.管理費（必須）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(徴収している場合)→床面積㎡当たりの月額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円/月・㎡"]
["22.修繕積立金（必須）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(徴収している場合)→床面積㎡当たりの月額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円/月・㎡"]
["23.滞納者に対するルール"]
["24.金融機関からの借入"]
["25.修繕積立金の収納率"]
["26.\n財務状況書類の整備",null,null,null,null,null,null,null,null,null,"管理費会計と修繕積立金会計を分けて経理（必須）"]
[null,null,null,null,null,null,null,null,null,null,"貸借対照表・財産目録（管理組合法人の場合）"]
["27.\n大規模な修繕工事の\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,null,null,null,null,null,null,null,null,null,"→（西暦",null,null,null,null,null,null,"年",null,null,"回数",null,null,"回）",null,null,null,null,null,"西暦","西暦",null,null,null,"年"]
[null,null,null,null,null,null,null,null,null,null,"屋上防水等",null,null,null,null,null,null,null,null,null,null,null,"→（西暦",null,null,null,null,null,null,"年",null,null,"回数",null,null,"回）",null,null,null,null,null,"西暦","西暦",null,null,null,"年"]
[null,null,null,null,null,null,null,null,null,null,"給水管更新等",null,null,null,null,null,null,null,null,null,null,null,"→（西暦",null,null,null,null,null,null,"年",null,null,"回数",null,null,"回）",null,null,null,null,null,"西暦","西暦",null,null,null,"年"]
[null,null,null,null,null,null,null,null,null,null,"排水管更新等",null,null,null,null,null,null,null,null,null,null,null,"→（西暦",null,null,null,null,null,null,"年",null,null,"回数",null,null,"回）",null,null,null,null,null,"西暦","西暦",null,null,null,"年"]
[null,null,null,null,null,null,null,null,null,null,"鉄部塗装",null,null,null,null,null,null,null,null,null,null,null,"→（西暦",null,null,null,null,null,null,"年",null,null,"回数",null,null,"回）",null,null,null,null,null,"西暦","西暦",null,null,null,"年"]
["28.修繕履歴の管理"]
["29.\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,null,null,"年間",null,null,"西暦",null,null,null,null,"年",null,"～",null,null,null,null,"年"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総会決議"]
["30.耐震性能（必須）",null,null,null,null,null,null,null,null,null,"建築確認を受けた時期"]
[null,null,null,null,null,null,null,null,null,null,"※1981年5月31日以前の場合、下記もご記入ください"]
[null,null,null,null,null,null,null,null,null,null,"耐震診断"]
[null,null,null,null,null,null,null,null,null,null,"耐震改修"]
["31.設計図書"]
["32.法定点検の実施",null,null,null,null,null,null,null,null,null,"建築基準法　"]
[null,null,null,null,null,null,null,null,null,null,"消防法"]
[]
["<危機管理に関する事項>"]
["33.防災マニュアル"]
["34.防災用品の備蓄"]
["35.防災訓練の定期的実施"]
["36.浸水対策"]
[]
["<その他の事項>"]
["37.コミュニティ活動",null,null,null,null,null,null,null,null,null,"地域組織への加入"]
[null,null,null,null,null,null,null,null,null,null,"　","（加入している場合）→",null,null,null,null,null,null,null,null,null,null,"加入団体名"]
[null,null,null,null,null,null,null,null,null,null,"マンション内でのコミュニティ活動"]
["38.\n環境に配慮した取組等",null,null,null,null,null,null,null,null,null,"（自由記述:環境に配慮した取組について、内容を記入ください）"]

{"sheet":"DATA","index":1,"n_rows":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["項目名","管理状況届出書（データ提出用）","値","確認済",null,"届出の種別",null,null,"バージョン"]
["届出年月日","AN4",{"$f":"IF(OR('管理状況届出書（データ提出用）'!AN4=\"\",'管理状況届出書（データ提出用）'!AS4=\"\",'管理状況届出書（データ提出用）'!AW4=\"\"),\"\",TEXT('管理状況届出書（データ提出用）'!AK4&'管理状況届出書（データ提出用）'!AN4&'管理状況届出書（データ提出用）'!AQ4&'管理状況届出書（データ提出用）'!AS4&'管理状況届出書（データ提出用）'!AU4&'管理状況届出書（データ提出用）'!AW4&'管理状況届出書（データ提出用）'!AY4,\"yyyy/mm/dd\"))","v":""},{"$f":"IF('管理状況届出書（データ提出用）'!D11=\"\",\"\",'管理状況届出書（データ提出用）'!D11)","v":""},null,"DATA","CD",null,20230309]
["届出者属性","AD6",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B3)=\"\",\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B3))","v":""},null,null,"届出・更新（5年毎）",1]
["届出者郵便番号","AE7",{"$f":"IF(OR('管理状況届出書（データ提出用）'!AE7=\"\",'管理状況届出書（データ提出用）'!AJ7=\"\"),\"\",'管理状況届出書（データ提出用）'!AE7&'管理状況届出書（データ提出用）'!AJ7)","v":""},null,null,"届出内容の変更",2]
["届出者住所","AD8",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B5)=\"\",\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B5))","v":""}]
["届出者氏名","AD9",""]
["届出者電話番号","AD10",{"$f":"IF(OR('管理状況届出書（データ提出用）'!AD10=\"\",'管理状況届出書（データ提出用）'!AJ10=\"\",'管理状況届出書（データ提出用）'!AP10=\"\"),\"\",'管理状況届出書（データ提出用）'!AD10&\"-\"&'管理状況届出書（データ提出用）'!AJ10&\"-\"&'管理状況届出書（データ提出用）'!AP10)","v":""}]
["届出者Email","AD11","",null,null,"情報開示の取扱い"]
["届出の種別","L14",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B9)=\"\",\"Null\",IFERROR(VLOOKUP(INDIRECT(\"'\"&$B$1&\"'!\"&$B9),$F$3:$G$4,2,FALSE),\"Null\"))","v":"Null"},null,null,"DATA","CD"]
["総会等での決議","L16","",null,null,"届出項目・所在地・マンション名の情報開示を希望する",1]
["情報開示の取扱い","L18",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B11)=\"\",\"Null\",IFERROR(VLOOKUP(INDIRECT(\"'\"&$B$1&\"'!\"&$B11),$F$10:$G$12,2,FALSE),\"Null\"))","v":"Null"},null,null,"所在地・マンション名のみ情報開示を希望する",2]
["マンション名_号棟","L22",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B12)=\"\",\"\",DBCS(INDIRECT(\"'\"&$B$1&\"'!\"&$B12)))","v":""},null,null,"情報開示を希望しない",3]
["マンション識別番号","L23",""]
["所在1","固定値","兵庫県"]
["所在2","O25",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B15)=\"\",\"\",\"神戸市\"&INDIRECT(\"'\"&$B$1&\"'!\"&$B15))","v":""}]
["所在3","S25",""]
["所在4","AC25",""]
["管理組合名","L26",""]
["管理組合の形態","L27",""]
["管理組合の形態_全体の棟数","AR27",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B20)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B19)<>\"団地管理組合である\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B20)))","v":"Null"}]
["戸数","O28",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B21)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B21))","v":"Null"}]
["地上階","O29",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B22)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B22))","v":"Null"}]
["地下階","V29",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B23)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B23))","v":"Null"}]
["構造_主たる部分","L30",""]
["竣工年","O31",""]
["竣工月","V31",""]
["土地の権利","L32",""]
["併設用途_なし","L33",{"$f":"IF(AND(OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$29)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$29)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$30)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$30)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$31)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$31)=\"□\")),\"Null\",IF(OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B28)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B28)=\"□\"),0,1))","v":"Null"}]
["併設用途_店舗","R33",{"$f":"IF(AND(OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$29)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$29)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$30)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$30)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$31)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$31)=\"□\")),\"Null\",IF(AND(INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"■\",INDIRECT(\"'\"&$B$1&\"'!\"&$B29)=\"■\"),\"ERROR\",IF(OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B29)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B29)=\"□\"),0,1)))","v":"Null"}]
["併設用途_事務所","X33",{"$f":"IF(AND(OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$29)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$29)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$30)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$30)=\"□\"),OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B$31)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B$31)=\"□\")),\"Null\",IF(AND(INDIRECT(\"'\"&$B$1&\"'!\"&$B$28)=\"■\",INDIRECT(\"'\"&$B$1&\"'!\"&$B30)=\"■\"),\"ERROR\",IF(OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B30)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B30)=\"□\"),0,1)))","v":"Null"}]
["併設用途_その他","AE33","Null"]
["併設用途その他内容","AK33",{"$f":"IF(AND(OR(INDIRECT(\"'\"&$B$1&\"'!\"&$B31)=\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B31)=\"□\"),INDIRECT(\"'\"&$B$1&\"'!\"&$B32)<>\"\"),\"ERROR\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B32)=\"\",\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B32)))","v":""}]
["管理形態","L34",""]
["管理業者_会社名","X38",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B34)=\"\",\"\",IF(AND(INDIRECT(\"'\"&$B$1&\"'!\"&$B33)<>\"全部委託\",INDIRECT(\"'\"&$B$1&\"'!\"&$B33)<>\"一部委託\"),\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B34)))","v":""}]
["管理組合","L40",""]
["管理者等","L41",""]
["管理規約","L42",""]
["管理規約最終改正年","AH42",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B38)=\"\",\"\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B37)<>\"ある\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B38)))","v":""}]
["区分所有者名簿","L43",""]
["居住者名簿","L44",""]
["空き住戸_割合","L45",""]
["賃貸化住戸_割合","L46",""]
["総会の開催","V47",""]
["総会の議事録","V48",""]
["総会出席率","P49",""]
["管理費","L50",""]
["管理費月額","AJ50",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B47)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B46)<>\"徴収している\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B47)))","v":"Null"}]
["修繕積立金","L51",""]
["修繕積立金月額","AR51",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B49)=\"\",\"Null\",IF(IFERROR(FIND(\"徴収している\",INDIRECT(\"'\"&$B$1&\"'!\"&$B48),1),0)<1,\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B49)))","v":"Null"}]
["滞納者に関するルール","L52",""]
["金融機関からの借入","L53",""]
["修繕積立金の収納率","L54",""]
["管理費会計と修繕積立金の分離","AF55",""]
["貸借対照表・財産目録","AF56",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B54)=\"\",\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B54))","v":""}]
["外壁改修","R58",""]
["外壁改修実施年","AA58",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B56)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$55)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B56)))","v":"Null"}]
["外壁改修実施回数","AH58",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B57)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$55)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B57)))","v":"Null"}]
["外壁改修予定年","AR58",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B58)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B58))","v":"Null"}]
["屋上防水","R59",""]
["屋上防水実施年","AA59",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B60)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$59)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B60)))","v":"Null"}]
["屋上防水実施回数","AH59",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B61)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$59)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B61)))","v":"Null"}]
["屋上防水予定年","AR59",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B62)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B62))","v":"Null"}]
["給水管更新","R60",""]
["給水管更新実施年","AA60",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B64)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$63)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B64)))","v":"Null"}]
["給水管更新実施回数","AH60",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B65)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$63)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B65)))","v":"Null"}]
["給水管更新予定年","AR60",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B66)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B66))","v":"Null"}]
["排水管更新","R61",""]
["排水管更新実施年","AA61",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B68)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$67)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B68)))","v":"Null"}]
["排水管更新実施回数","AH61",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B69)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$67)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B69)))","v":"Null"}]
["排水管更新予定年","AR61",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B70)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B70))","v":"Null"}]
["鉄部塗装","R62",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B71)=\"\",\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B71))","v":""}]
["鉄部塗装実施年","AA62",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B72)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$71)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B72)))","v":"Null"}]
["鉄部塗装実施回数","AH62",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B73)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$71)<>\"実施済\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B73)))","v":"Null"}]
["鉄部塗装予定年","AR62",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B74)=\"\",\"Null\",INDIRECT(\"'\"&$B$1&\"'!\"&$B74))","v":"Null"}]
["修繕履歴の管理","L63",""]
["長期修繕計画","L64",""]
["長期修繕計画最新作成_更新年","AA65",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B77)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$76)<>\"ある\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B77)))","v":"Null"}]
["長期修繕計画最新作成_更新","AH65",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B78)=\"\",\"\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$76)<>\"ある\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B78)))","v":""}]
["長期修繕計画_計画期間","V66",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B79)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$76)<>\"ある\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B79)))","v":"Null"}]
["長期修繕計画開始","AE66",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B80)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$76)<>\"ある\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B80)))","v":"Null"}]
["長期修繕計画終了","AL66",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B81)=\"\",\"Null\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$76)<>\"ある\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B81)))","v":"Null"}]
["長期修繕計画_総会決議","V67",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B82)=\"\",\"\",IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B$76)<>\"ある\",\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B82)))","v":""}]
["耐震診断","Q70",""]
["耐震改修","Q71",""]
["設計図書","L72",""]
["法定点検の実施_建築基準法","Q73",""]
["法定点検の実施_消防法","Q74",""]
["防災マニュアル","L77",""]
["防災用品の備蓄","L78",""]
["防災訓練の定期的実施","L79",""]
["浸水対策","L80",""]
["地域組織への加入","S83",""]
["加入団体名","AC84",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B93)=\"\",\"\",IF(IFERROR(FIND(\"している\",INDIRECT(\"'\"&$B$1&\"'!\"&$B92)),0)<1,\"ERROR\",INDIRECT(\"'\"&$B$1&\"'!\"&$B93)))","v":""}]
["マンション内でのコミュニティ活動","AB85",""]
["環境に配慮した取り組み等","L87",""]
["外壁改修予定未定","AW58",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B96)=\"\",0,IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B96)=\"未定\",1,\"\"))","v":0},"ここより下20230309追加"]
["屋上防水予定未定","AW59",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B97)=\"\",0,IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B97)=\"未定\",1,\"\"))","v":0}]
["給水管更新予定未定","AW60",0]
["排水管更新予定未定","AW61",0]
["鉄部塗装予定未定","AW62",0]
["建築確認時期","V68",{"$f":"IF(INDIRECT(\"'\"&$B$1&\"'!\"&$B101)=\"\",\"\",INDIRECT(\"'\"&$B$1&\"'!\"&$B101))","v":""}]