{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["参加者名簿"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":56,"n_cols":29,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,1,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,11,2,12],[20,22,26,22],[27,21,27,22],[3,0,3,12],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,8],[4,9,5,9],[4,10,4,12]]}
["※利用者名簿は任意の様式を使用されてもかまいませんが、氏名、料金区分、性別、宿泊日、現住所（外国籍の方は国籍と旅券番号）を必ずご記入ください。\n 　学校関係団体のご利用の場合は、個人の番地までの住所は不要です。"]
["◆愛知県旭高原自然の家　利用者名簿　　（必要事項をご入力ください。）"]
["団体名","",null,null,"期間",null,"入所日",null,null,null,"退所日"]
["\n　■利用者名簿への入力\n\n　　　１）この名簿は１シート５０名様用です。人数を増やす場合には、あらかじめ右側の増やすボタンを押し人数を増やしてから始めてください。\n　　　２）黄色のセルは記載・入力用です。氏名欄には宿泊者名をご入力ください。現住所、職業欄への記載入力もお願いいたします。\n　　　３）区分、性別、宿泊日のセルは緑色で、選択項目となっ ています。セルの右側の「▼」から項目を選択してください。\n　　　４）選択できない白いセルには、入力することはできません。\n　　　５）備考欄について：外国人の皆様で「在留カード」をお持ちでない方は、パスポートの写しが必要となります。当日ご提示ください。"]
["番号","氏　　　　名","区分","性別"," 宿泊日　　(その日に宿泊される方は「✔」を)",null,null,null,null,"現住所","備     考"]
[null,null,null,null,{"$f":"IF(I3=\"\",\"\",I3)","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6+1)<=$L3,E6+1,\"\"))","v":""},{"$f":"IF(F6=\"\",\"\",IF((F6+1)<=$L3,F6+1,\"\"))","v":""},{"$f":"IF(G6=\"\",\"\",IF((G6+1)<=$L3,G6+1,\"\"))","v":""},{"$f":"IF(H6=\"\",\"\",IF((H6+1)<=$L3,H6+1,\"\"))","v":""},null,"職業","国籍","旅券番号",null,null,null,null,null,null,null,null,null,null,"1泊目","2泊目","3泊目","4泊目","5泊目","合計"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3歳未満","3歳未満","男",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V7,$D:$D,$W7)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V7,$D:$D,$W7)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V7,$D:$D,$W7)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V7,$D:$D,$W7)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V7,$D:$D,$W7)","v":0},{"$f":"SUM(X7:AB7)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3歳～小学生","3歳～小学生","男",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V8,$D:$D,$W8)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V8,$D:$D,$W8)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V8,$D:$D,$W8)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V8,$D:$D,$W8)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V8,$D:$D,$W8)","v":0},{"$f":"SUM(X8:AB8)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"中学生","中学生","男",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V9,$D:$D,$W9)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V9,$D:$D,$W9)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V9,$D:$D,$W9)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V9,$D:$D,$W9)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V9,$D:$D,$W9)","v":0},0]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"高校生","高校生","男",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V10,$D:$D,$W10)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V10,$D:$D,$W10)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V10,$D:$D,$W10)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V10,$D:$D,$W10)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V10,$D:$D,$W10)","v":0},0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"大学生","大学生","男",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V11,$D:$D,$W11)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V11,$D:$D,$W11)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V11,$D:$D,$W11)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V11,$D:$D,$W11)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V11,$D:$D,$W11)","v":0},0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"成人","成人","男",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V12,$D:$D,$W12)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V12,$D:$D,$W12)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V12,$D:$D,$W12)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V12,$D:$D,$W12)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V12,$D:$D,$W12)","v":0},0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他","その他","男",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V13,$D:$D,$W13)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V13,$D:$D,$W13)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V13,$D:$D,$W13)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V13,$D:$D,$W13)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V13,$D:$D,$W13)","v":0},0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3歳未満","女",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V14,$D:$D,$W14)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V14,$D:$D,$W14)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V14,$D:$D,$W14)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V14,$D:$D,$W14)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V14,$D:$D,$W14)","v":0},0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"✔","3歳～小学生","女",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V15,$D:$D,$W15)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V15,$D:$D,$W15)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V15,$D:$D,$W15)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V15,$D:$D,$W15)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V15,$D:$D,$W15)","v":0},0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"中学生","女",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V16,$D:$D,$W16)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V16,$D:$D,$W16)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V16,$D:$D,$W16)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V16,$D:$D,$W16)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V16,$D:$D,$W16)","v":0},0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"高校生","女",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V17,$D:$D,$W17)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V17,$D:$D,$W17)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V17,$D:$D,$W17)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V17,$D:$D,$W17)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V17,$D:$D,$W17)","v":0},0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"大学生","女",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V18,$D:$D,$W18)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V18,$D:$D,$W18)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V18,$D:$D,$W18)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V18,$D:$D,$W18)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V18,$D:$D,$W18)","v":0},0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"成人","女",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V19,$D:$D,$W19)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V19,$D:$D,$W19)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V19,$D:$D,$W19)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V19,$D:$D,$W19)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V19,$D:$D,$W19)","v":0},0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他","女",{"$f":"COUNTIFS(E:E,\"✔\",$C:$C,$V20,$D:$D,$W20)","v":0},{"$f":"COUNTIFS(F:F,\"✔\",$C:$C,$V20,$D:$D,$W20)","v":0},{"$f":"COUNTIFS(G:G,\"✔\",$C:$C,$V20,$D:$D,$W20)","v":0},{"$f":"COUNTIFS(H:H,\"✔\",$C:$C,$V20,$D:$D,$W20)","v":0},{"$f":"COUNTIFS(I:I,\"✔\",$C:$C,$V20,$D:$D,$W20)","v":0},0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3歳未満","合計",{"$f":"SUM(X7,X14)","v":0},{"$f":"SUM(Y7,Y14)","v":0},0,0,0,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3歳～小学生",null,{"$f":"SUM(X8,X15)","v":0},0,0,0,0,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"中学生",null,0,0,0,0,0,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"高校生",null,0,0,0,0,0,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"大学生",null,0,0,0,0,0,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"成人",null,0,0,0,0,0,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他",null,0,0,0,0,0,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総計",null,{"$f":"SUM(X21:X27)","v":0},{"$f":"SUM(Y21:Y27)","v":0},0,0,0,0]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]