{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["加盟申請書","会員名簿"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,12,11,13],[11,11,12,11],[11,5,12,5],[8,10,8,11],[6,10,6,11],[6,8,6,9],[7,8,7,9],[6,12,6,13],[7,10,7,11],[7,12,7,13],[11,0,12,1],[11,2,11,4],[11,6,11,10],[9,12,9,13],[12,2,12,4],[12,6,12,10],[12,12,12,13],[9,1,9,2],[9,8,9,9],[9,3,9,4],[9,5,9,6],[5,7,9,7],[9,10,9,11],[7,5,7,6],[8,3,8,4],[8,5,8,6],[8,1,8,2],[8,12,8,13],[8,8,8,9],[0,4,0,9],[5,1,5,2],[7,1,7,2],[6,1,6,2],[7,3,7,4],[4,8,4,9],[5,8,5,9],[2,9,2,10],[2,6,2,7],[0,1,0,2],[5,5,5,6],[4,1,4,2],[2,12,2,13],[6,3,6,4],[6,5,6,6],[4,3,4,4],[4,5,4,6],[5,3,5,4],[4,10,4,11],[4,12,4,13],[5,10,5,11],[5,12,5,13],[2,1,2,4]]}
[null,"2023(R5)",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,"代表者名\n(顧問名)",null,null,"電話",null,null,"提出日",null,null,null,null,"加盟申請書と会員名簿を印刷"]
[]
["役職","ID番号",null,"氏名",null,"電話",null,"役職","ID番号",null,"氏名",null,"電話"]
["会長",null,null,{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(B6,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,"県連理事\n(学校は顧問)",null,null,{"$f":"IF(I6=\"\",\"\",VLOOKUP(I6,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(I6,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(I6=\"\",\"\",VLOOKUP(I6,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,null,"色のついているセルに入力してください"]
[null,null,null,{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(B7,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,null,null,null,{"$f":"IF(I7=\"\",\"\",VLOOKUP(I7,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(I7,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(I7=\"\",\"\",VLOOKUP(I7,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,null,"シートに保護をかけてありますが"]
[null,null,null,{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(B8,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,null,null,null,{"$f":"IF(I8=\"\",\"\",VLOOKUP(I8,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(I8,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(I8=\"\",\"\",VLOOKUP(I8,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,null,"パスワードは設定しておりません"]
[null,null,null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(B9,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,null,null,null,{"$f":"IF(I9=\"\",\"\",VLOOKUP(I9,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(I9,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(I9=\"\",\"\",VLOOKUP(I9,会員名簿!$B$4:$J$153,9,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,会員名簿!$B$4:$J$153,2,FALSE)&\"  \"&VLOOKUP(B10,会員名簿!$B$4:$J$153,3,FALSE))","v":""},null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,会員名簿!$B$4:$J$153,9,FALSE))","v":""},null,null,"ID番号のない方は\nこちらに記入してください"]
[]
["メール担当者",null,null,null,null,"E-mail\n(添付ファイルが読めるもの)",null,null,null,null,null,"電話"]
[]
[]
["会員区分","小計","教士七段","教士六段","錬士六段","錬士五段","五段","四段","参段","弐段","初段","無･級位"]
["一般",{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$E$4:$E$153,A16))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&C15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&D15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&E15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&F15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&G15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&H15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&I15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&J15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$L$4:$L$153,$A$16&K15))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",B16-SUM(C16:K16))","v":""}]
["大学生",{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$E$4:$E$153,A17))","v":""}]
["高校生",{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$E$4:$E$153,A18))","v":""}]
["中学生",{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$E$4:$E$153,A19))","v":""},null,null,null,"登録会員","納入会費","一般","大学生","高校生","中学生","小学生"]
["小学生",{"$f":"IF(COUNTA(会員名簿!$E$4:$E$153)=0,\"\",COUNTIF(会員名簿!$E$4:$E$153,A20))","v":""},null,null,null,{"$f":"IF(COUNTA(会員名簿!$E$4:$E$18)=0,\"\",SUM(B16:B20))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$18)=0,\"\",SUM(H20:L20))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$18)=0,\"\",SUMPRODUCT(C21:N21,C16:N16))","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$18)=0,\"\",B17*1000)","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$18)=0,\"\",B18*1000)","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$18)=0,\"\",B19*500)","v":""},{"$f":"IF(COUNTA(会員名簿!$E$4:$E$18)=0,\"\",B20*500)","v":""}]
[null,"一般登録料",15000,14000,13000,12000,7000,6000,5000,4000,3000,3000]

{"sheet":"会員名簿","index":1,"n_rows":153,"n_cols":16,"rows_kept":153,"cut":false,"hidden":false,"merged":[[0,10,0,12]]}
[null,null,{"$f":"加盟申請書!B3&\"  会員名簿\"","v":"  会員名簿"},null,null,null,null,null,"№",null,"L列は非表示",null,null,"印刷ページ数",{"$f":"IF(加盟申請書!F20=\"\",1,ROUNDUP(加盟申請書!F20/15,0))","v":1},"編集する場合【校閲】→【シート保護の解除】をしてください(パスワードはありません)"]
[]
["№","ID番号","姓","名","会員区分","称号","段位","〒","住所","電話"]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"E4&F4&G4","v":""},"色のついているセルに入力してください"]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"E5&F5&G5","v":""},"シートに保護をかけてありますが"]
[3,null,null,null,null,null,null,null,null,null,null,"","パスワードは設定しておりません"]
[4,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,""]
[12,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,null,null,null,""]
[16,null,null,null,null,null,null,null,null,null,null,{"$f":"E19&F19&G19","v":""}]
[17,null,null,null,null,null,null,null,null,null,null,{"$f":"E20&F20&G20","v":""}]
[18,null,null,null,null,null,null,null,null,null,null,""]
[19,null,null,null,null,null,null,null,null,null,null,""]
[20,null,null,null,null,null,null,null,null,null,null,""]
[21,null,null,null,null,null,null,null,null,null,null,""]
[22,null,null,null,null,null,null,null,null,null,null,""]
[23,null,null,null,null,null,null,null,null,null,null,""]
[24,null,null,null,null,null,null,null,null,null,null,""]
[25,null,null,null,null,null,null,null,null,null,null,""]
[26,null,null,null,null,null,null,null,null,null,null,""]
[27,null,null,null,null,null,null,null,null,null,null,""]
[28,null,null,null,null,null,null,null,null,null,null,""]
[29,null,null,null,null,null,null,null,null,null,null,""]
[30,null,null,null,null,null,null,null,null,null,null,""]
[31,null,null,null,null,null,null,null,null,null,null,{"$f":"E34&F34&G34","v":""}]
[32,null,null,null,null,null,null,null,null,null,null,{"$f":"E35&F35&G35","v":""}]
[33,null,null,null,null,null,null,null,null,null,null,""]
[34,null,null,null,null,null,null,null,null,null,null,""]
[35,null,null,null,null,null,null,null,null,null,null,""]
[36,null,null,null,null,null,null,null,null,null,null,""]
[37,null,null,null,null,null,null,null,null,null,null,""]
[38,null,null,null,null,null,null,null,null,null,null,""]
[39,null,null,null,null,null,null,null,null,null,null,""]
[40,null,null,null,null,null,null,null,null,null,null,""]
[41,null,null,null,null,null,null,null,null,null,null,""]
[42,null,null,null,null,null,null,null,null,null,null,""]
[43,null,null,null,null,null,null,null,null,null,null,""]
[44,null,null,null,null,null,null,null,null,null,null,""]
[45,null,null,null,null,null,null,null,null,null,null,""]
[46,null,null,null,null,null,null,null,null,null,null,{"$f":"E49&F49&G49","v":""}]
[47,null,null,null,null,null,null,null,null,null,null,{"$f":"E50&F50&G50","v":""}]
[48,null,null,null,null,null,null,null,null,null,null,""]
[49,null,null,null,null,null,null,null,null,null,null,""]
[50,null,null,null,null,null,null,null,null,null,null,""]
[51,null,null,null,null,null,null,null,null,null,null,""]
[52,null,null,null,null,null,null,null,null,null,null,""]
[53,null,null,null,null,null,null,null,null,null,null,""]
[54,null,null,null,null,null,null,null,null,null,null,""]
[55,null,null,null,null,null,null,null,null,null,null,""]
[56,null,null,null,null,null,null,null,null,null,null,""]
[57,null,null,null,null,null,null,null,null,null,null,""]
[58,null,null,null,null,null,null,null,null,null,null,""]
[59,null,null,null,null,null,null,null,null,null,null,""]
[60,null,null,null,null,null,null,null,null,null,null,""]
[61,null,null,null,null,null,null,null,null,null,null,{"$f":"E64&F64&G64","v":""}]
[62,null,null,null,null,null,null,null,null,null,null,{"$f":"E65&F65&G65","v":""}]
[63,null,null,null,null,null,null,null,null,null,null,""]
[64,null,null,null,null,null,null,null,null,null,null,""]
[65,null,null,null,null,null,null,null,null,null,null,""]
[66,null,null,null,null,null,null,null,null,null,null,""]
[67,null,null,null,null,null,null,null,null,null,null,""]
[68,null,null,null,null,null,null,null,null,null,null,""]
[69,null,null,null,null,null,null,null,null,null,null,""]
[70,null,null,null,null,null,null,null,null,null,null,""]
[71,null,null,null,null,null,null,null,null,null,null,""]
[72,null,null,null,null,null,null,null,null,null,null,""]
[73,null,null,null,null,null,null,null,null,null,null,""]
[74,null,null,null,null,null,null,null,null,null,null,""]
[75,null,null,null,null,null,null,null,null,null,null,""]
[76,null,null,null,null,null,null,null,null,null,null,{"$f":"E79&F79&G79","v":""}]
[77,null,null,null,null,null,null,null,null,null,null,{"$f":"E80&F80&G80","v":""}]
[78,null,null,null,null,null,null,null,null,null,null,""]
[79,null,null,null,null,null,null,null,null,null,null,""]
[80,null,null,null,null,null,null,null,null,null,null,""]
[81,null,null,null,null,null,null,null,null,null,null,""]
[82,null,null,null,null,null,null,null,null,null,null,""]
[83,null,null,null,null,null,null,null,null,null,null,""]
[84,null,null,null,null,null,null,null,null,null,null,""]
[85,null,null,null,null,null,null,null,null,null,null,""]
[86,null,null,null,null,null,null,null,null,null,null,""]
[87,null,null,null,null,null,null,null,null,null,null,""]
[88,null,null,null,null,null,null,null,null,null,null,""]
[89,null,null,null,null,null,null,null,null,null,null,""]
[90,null,null,null,null,null,null,null,null,null,null,""]
[91,null,null,null,null,null,null,null,null,null,null,{"$f":"E94&F94&G94","v":""}]
[92,null,null,null,null,null,null,null,null,null,null,{"$f":"E95&F95&G95","v":""}]
[93,null,null,null,null,null,null,null,null,null,null,""]
[94,null,null,null,null,null,null,null,null,null,null,""]
[95,null,null,null,null,null,null,null,null,null,null,""]
[96,null,null,null,null,null,null,null,null,null,null,""]
[97,null,null,null,null,null,null,null,null,null,null,""]
[98,null,null,null,null,null,null,null,null,null,null,""]
[99,null,null,null,null,null,null,null,null,null,null,""]
[100,null,null,null,null,null,null,null,null,null,null,""]
[101,null,null,null,null,null,null,null,null,null,null,""]
[102,null,null,null,null,null,null,null,null,null,null,""]
[103,null,null,null,null,null,null,null,null,null,null,""]
[104,null,null,null,null,null,null,null,null,null,null,""]
[105,null,null,null,null,null,null,null,null,null,null,""]
[106,null,null,null,null,null,null,null,null,null,null,{"$f":"E109&F109&G109","v":""}]
[107,null,null,null,null,null,null,null,null,null,null,{"$f":"E110&F110&G110","v":""}]
[108,null,null,null,null,null,null,null,null,null,null,""]
[109,null,null,null,null,null,null,null,null,null,null,""]
[110,null,null,null,null,null,null,null,null,null,null,""]
[111,null,null,null,null,null,null,null,null,null,null,""]
[112,null,null,null,null,null,null,null,null,null,null,""]
[113,null,null,null,null,null,null,null,null,null,null,""]
[114,null,null,null,null,null,null,null,null,null,null,""]
[115,null,null,null,null,null,null,null,null,null,null,""]
[116,null,null,null,null,null,null,null,null,null,null,""]
[117,null,null,null,null,null,null,null,null,null,null,""]
[118,null,null,null,null,null,null,null,null,null,null,""]
[119,null,null,null,null,null,null,null,null,null,null,""]
[120,null,null,null,null,null,null,null,null,null,null,""]
[121,null,null,null,null,null,null,null,null,null,null,{"$f":"E124&F124&G124","v":""}]
[122,null,null,null,null,null,null,null,null,null,null,{"$f":"E125&F125&G125","v":""}]
[123,null,null,null,null,null,null,null,null,null,null,""]
[124,null,null,null,null,null,null,null,null,null,null,""]
[125,null,null,null,null,null,null,null,null,null,null,""]
[126,null,null,null,null,null,null,null,null,null,null,""]
[127,null,null,null,null,null,null,null,null,null,null,""]
[128,null,null,null,null,null,null,null,null,null,null,""]
[129,null,null,null,null,null,null,null,null,null,null,""]
[130,null,null,null,null,null,null,null,null,null,null,""]
[131,null,null,null,null,null,null,null,null,null,null,""]
[132,null,null,null,null,null,null,null,null,null,null,""]
[133,null,null,null,null,null,null,null,null,null,null,""]
[134,null,null,null,null,null,null,null,null,null,null,""]
[135,null,null,null,null,null,null,null,null,null,null,""]
[136,null,null,null,null,null,null,null,null,null,null,{"$f":"E139&F139&G139","v":""}]
[137,null,null,null,null,null,null,null,null,null,null,{"$f":"E140&F140&G140","v":""}]
[138,null,null,null,null,null,null,null,null,null,null,""]
[139,null,null,null,null,null,null,null,null,null,null,""]
[140,null,null,null,null,null,null,null,null,null,null,""]
[141,null,null,null,null,null,null,null,null,null,null,""]
[142,null,null,null,null,null,null,null,null,null,null,""]
[143,null,null,null,null,null,null,null,null,null,null,""]
[144,null,null,null,null,null,null,null,null,null,null,""]
[145,null,null,null,null,null,null,null,null,null,null,""]
[146,null,null,null,null,null,null,null,null,null,null,""]
[147,null,null,null,null,null,null,null,null,null,null,""]
[148,null,null,null,null,null,null,null,null,null,null,""]
[149,null,null,null,null,null,null,null,null,null,null,""]
[150,null,null,null,null,null,null,null,null,null,null,""]