{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["会員登録名簿","会員登録名簿記入例","支部No."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":3,"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":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,7,1,8],[1,10,1,13],[1,15,1,16]]}
[null,null,null,null,{"$f":"ASC(TRIM(PHONETIC(D1)))","v":""},null,null,{"$f":"IF(G1=\"\",\"\",DATEDIF(G1,$P$2,\"Y\"))","v":""}]
[null,null,"準会員登録",null,"令和","7",null,"年度",null,null," 剣道連盟会員登録名簿",null,null,null,"年齢基準",{"$f":"\"R\" & F2 & \".4.1\"","v":"R7.4.1"}]
[null,"会員\n番号","全剣連\n登録番号","氏名","ﾌﾘｶﾞﾅ","性別","生年月日","年齢","郵便番号","住所","電話","称号","取得\n年月日","段位","取得\n年月日","職業","備考"]
[null,1,null,null,null,null,null,{"$f":"IF(G4=\"\",\"\",DATEDIF(G4,$P$2,\"Y\"))","v":""}]
[null,2,null,null,null,null,null,{"$f":"IF(G5=\"\",\"\",DATEDIF(G5,$P$2,\"Y\"))","v":""}]
[null,3,null,null,null,null,null,""]
[null,4,null,null,null,null,null,""]
[null,5,null,null,null,null,null,""]
[null,6,null,null,null,null,null,""]
[null,7,null,null,null,null,null,""]
[null,8,null,null,null,null,null,""]
[null,9,null,null,null,null,null,""]
[null,10,null,null,null,null,null,""]

{"sheet":"会員登録名簿記入例","index":1,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,7,1,8],[1,10,1,13],[1,15,1,16]]}
[]
[null,null,"準会員登録",null,"令和",null,null,"年度",null,null," 剣道連盟会員登録名簿",null,null,null,"年齢基準","2024-04-01"]
[null,"会員\n番号","全剣連\n登録番号","氏名","ﾌﾘｶﾞﾅ","性別","生年月日","年齢","郵便番号","住所","電話","称号","取得\n年月日","段位","取得\n年月日","職業","備考"]
[null,1,340549,"横浜　太郎",{"$f":"PHONETIC(D4)","v":"ヨコハマ　　タロウ"},"男","1960-10-10",{"$f":"IF(G4=\"\",\"\",DATEDIF(G4,P2,\"Y\"))","v":63},"123-4567","神奈川区鶴屋町2-17-1\n相鉄・岩崎学園ビル307号","045-321-6175","教士","2004-05-03","七","2006-05-06",null,null,null,{"$f":"IF(R4=\"\",\"\",(YEAR(NOW())-YEAR(R4)-IF(MONTH(NOW())*100+DAY(NOW())>=MONTH(R4)*100+DAY(R4),0,1)))","v":""}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R5=\"\",\"\",(YEAR(NOW())-YEAR(R5)-IF(MONTH(NOW())*100+DAY(NOW())>=MONTH(R5)*100+DAY(R5),0,1)))","v":""}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"支部No.","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["No.","支部名","職業",{"$f":"TEXT(NOW(),\"e\")-1","v":6}]
[1,"鶴見区","小学生",{"$f":"TEXT(NOW(),\"e\")","v":"7"}]
[2,"神奈川区","中学生",{"$f":"TEXT(NOW(),\"e\")+1","v":8}]
[3,"西区","高校生"]
[4,"中区","大学生"]
[5,"南区","会社員"]
[6,"保土ケ谷区","公務員"]
[7,"磯子区","教職員"]
[8,"金沢区","自営業"]
[9,"港北区","警察官"]
[10,"戸塚区","団体職員"]
[11,"泉区","主婦"]
[12,"栄区","無職"]
[13,"港南区"]
[14,"旭区"]
[15,"瀬谷区"]
[16,"緑区"]
[17,"青葉区"]
[18,"都筑区"]
[19,"川崎市"]
[20,"横須賀"]
[21,"平塚市"]
[22,"鎌倉"]
[23,"藤沢市"]
[24,"茅ヶ崎市"]
[25,"中郡"]
[26,"小田原"]
[28,"相模原市"]
[29,"秦野市"]
[30,"厚木"]
[31,"大和市"]
[32,"海老名市"]
[33,"津久井"]
[34,"座間市"]
[35,"伊勢原市"]
[36,"綾瀬市"]
[37,"警察"]
[38,"防衛大学"]