{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["元データ","一次案内状","懇談希望表","二次案内状","懇談表","使用方法"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"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":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,0,3,1],[4,0,4,1],[5,0,5,1],[7,6,11,8],[12,6,13,6],[12,8,13,8]]}
[]
["初期データを入力するシート"]
[]
["開始時刻→",null,"08:30:00",null,null,null,null,"←に「日にち」と「氏名」「開始時刻」「懇談時間」「懇談回数」「１日の懇談数」"]
["懇談時間(分)→",null,"00:30:00",null,null,null,null,"を入力して面談時間作成ボタンをクリックしてください。"]
["１日の懇談数→",null,13,null,"　　←最後の懇談のＮｏを入力してください。"]
[]
["日にち","懇談No","懇談時間","No","氏名",null,"昼休みを設定する場合は下のセルに時間を入力してください。設定しない場合は空欄にしてください。"]
["8月19日(水)",1,"8:30:～9:00:",{"$f":"IF(E9=\"\",\"\",1)","v":1},"瀬口拓弥",null,null,null,null,null,null,null,null,null,null,null,null,null,"08:00:00","00:10:00",1,"08:30:00","09:00:00"]
["8月20日(木)",2,"9:00:～9:30:",{"$f":"IF(E10=\"\",\"\",2)","v":2},"上福元直人",null,null,null,null,null,null,null,null,null,null,null,null,null,"08:10:00","00:15:00",2,"09:00:00","09:30:00"]
["8月21日(金)",3,"9:30:～10:00",{"$f":"IF(E11=\"\",\"\",3)","v":3},"松澤香輝",null,null,null,null,null,null,null,null,null,null,null,null,null,"08:20:00","00:20:00",3,"09:30:00","10:00:00"]
["8月24日(月)",4,"10:00～10:30",{"$f":"IF(E12=\"\",\"\",4)","v":4},"長谷川徹",null,null,null,null,null,null,null,null,null,null,null,null,null,"08:30:00","00:25:00",4,"10:00:00","10:30:00"]
["8月25日(火)",5,"10:30～11:00",{"$f":"IF(E13=\"\",\"\",5)","v":5},"田向泰輝",null,"↓",null,"↓",null,null,null,null,null,null,null,null,null,"08:40:00","00:30:00",5,"10:30:00","11:00:00"]
[null,6,"11:00～11:30",{"$f":"IF(E14=\"\",\"\",6)","v":6},"ドゥシャン",null,null,null,null,null,null,null,null,null,null,null,null,null,"08:50:00","00:35:00",6,"11:00:00","11:30:00"]
[null,7,"11:30～12:00",{"$f":"IF(E15=\"\",\"\",7)","v":7},"ジエゴ",null,"12:00:00","～","13:00:00",null,null,null,null,null,null,null,null,null,"09:00:00","00:40:00",7,"11:30:00","12:00:00"]
[null,null,"12:00～13:00昼休み",{"$f":"IF(E16=\"\",\"\",8)","v":8},"石井秀典",null,null,null,null,null,null,null,null,null,null,null,null,null,"09:10:00",null,8,"12:00:00","12:30:00"]
[null,7.5625,"13:00～13:30",{"$f":"IF(E17=\"\",\"\",9)","v":9},"福岡将太",null,null,null,null,null,null,null,null,null,null,null,null,null,"09:20:00",null,9,"16:00:00","16:30:00"]
[null,8.5833333333333339,"13:30～14:00",{"$f":"IF(E18=\"\",\"\",10)","v":10},"安部崇士",null,null,null,null,null,null,null,null,null,null,null,null,null,"09:30:00",null,10,"16:30:00","17:00:00"]
[null,9.6041666666666661,"14:00～14:30",{"$f":"IF(E19=\"\",\"\",11)","v":11},"秋山拓也",null,null,null,null,null,null,null,null,null,null,null,null,null,"09:40:00","11:00:00",11,"17:00:00","17:30:00"]
[null,10.625,"14:30～15:00",{"$f":"IF(E20=\"\",\"\",12)","v":12},"吹ヶ徳喜",null,null,null,null,null,null,null,null,null,null,null,null,null,"09:50:00","11:05:00",12,"17:30:00","18:00:00"]
[null,11.645833333333334,"15:00～15:30",{"$f":"IF(E21=\"\",\"\",13)","v":13},"奥田雄大",null,null,null,null,null,null,null,null,null,null,null,null,null,"10:00:00","11:10:00",13,"18:00:00","18:30:00"]
[null,12.666666666666666,"15:30～16:00",{"$f":"IF(E22=\"\",\"\",14)","v":14},"内田航平",null,null,null,null,null,null,null,null,null,null,null,null,null,"10:10:00","11:15:00",14,"15:30:00","16:00:00"]
[null,null,null,{"$f":"IF(E23=\"\",\"\",15)","v":15},"小西雄大",null,null,null,null,null,null,null,null,null,null,null,null,null,"10:20:00","11:20:00",15]
[null,null,null,{"$f":"IF(E24=\"\",\"\",16)","v":16},"岩尾憲",null,null,null,null,null,null,null,null,null,null,null,null,null,"10:30:00","11:25:00",16]
[null,null,null,{"$f":"IF(E25=\"\",\"\",17)","v":17},"渡井理己",null,null,null,null,null,null,null,null,null,null,null,null,null,"10:40:00","11:30:00",17]
[null,null,null,{"$f":"IF(E26=\"\",\"\",18)","v":18},"島屋八徳",null,null,null,null,null,null,null,null,null,null,null,null,null,"10:50:00","11:35:00",18]
[null,null,null,{"$f":"IF(E27=\"\",\"\",19)","v":19},"清武功暉",null,null,null,null,null,null,null,null,null,null,null,null,null,"11:00:00","11:40:00",19]
[null,null,null,{"$f":"IF(E28=\"\",\"\",20)","v":20},"榎本大輝",null,null,null,null,null,null,null,null,null,null,null,null,null,"11:10:00","11:45:00",20]
[null,null,null,{"$f":"IF(E29=\"\",\"\",21)","v":21},"藤田征也",null,null,null,null,null,null,null,null,null,null,null,null,null,"11:20:00","11:50:00",21]
[null,null,null,{"$f":"IF(E30=\"\",\"\",22)","v":22},"鈴木徳真",null,null,null,null,null,null,null,null,null,null,null,null,null,"11:30:00","11:55:00",22]
[null,null,null,{"$f":"IF(E31=\"\",\"\",23)","v":23},"西谷和希",null,null,null,null,null,null,null,null,null,null,null,null,null,"11:40:00","12:00:00",23]
[null,null,null,{"$f":"IF(E32=\"\",\"\",24)","v":24},"川上エドオジョン智慧",null,null,null,null,null,null,null,null,null,null,null,null,null,"11:50:00","12:05:00",24]
[null,null,null,{"$f":"IF(E33=\"\",\"\",25)","v":25},"浜下瑛",null,null,null,null,null,null,null,null,null,null,null,null,null,"12:00:00","12:10:00",25]
[null,null,null,{"$f":"IF(E34=\"\",\"\",26)","v":26},"梶川諒太",null,null,null,null,null,null,null,null,null,null,null,null,null,"12:10:00","12:15:00",26]
[null,null,null,{"$f":"IF(E35=\"\",\"\",27)","v":27},"森田凜",null,null,null,null,null,null,null,null,null,null,null,null,null,"12:20:00","12:20:00",27]
[null,null,null,{"$f":"IF(E36=\"\",\"\",28)","v":28},"杉森考起",null,null,null,null,null,null,null,null,null,null,null,null,null,"12:30:00","12:25:00",28]
[null,null,null,{"$f":"IF(E37=\"\",\"\",29)","v":29},"河田篤秀",null,null,null,null,null,null,null,null,null,null,null,null,null,"12:40:00","12:30:00",29]
[null,null,null,{"$f":"IF(E38=\"\",\"\",30)","v":30},"押谷祐樹",null,null,null,null,null,null,null,null,null,null,null,null,null,"12:50:00","12:35:00",30]
[null,null,null,{"$f":"IF(E39=\"\",\"\",31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:00:00","12:40:00"]
[null,null,null,{"$f":"IF(E40=\"\",\"\",32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:10:00","12:45:00"]
[null,null,null,{"$f":"IF(E41=\"\",\"\",33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:20:00","12:50:00"]
[null,null,null,{"$f":"IF(E42=\"\",\"\",34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:30:00","12:55:00"]
[null,null,null,{"$f":"IF(E43=\"\",\"\",35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:40:00","13:00:00"]
[null,null,null,{"$f":"IF(E44=\"\",\"\",36)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:50:00","13:05:00"]
[null,null,null,{"$f":"IF(E45=\"\",\"\",37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:00:00","13:10:00"]
[null,null,null,{"$f":"IF(E46=\"\",\"\",38)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:10:00","13:15:00"]
[null,null,null,{"$f":"IF(E47=\"\",\"\",39)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:20:00","13:20:00"]
[null,null,null,{"$f":"IF(E48=\"\",\"\",40)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:30:00","13:25:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:40:00","13:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:50:00","13:35:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:00:00","13:40:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:45:00"]
[null,null,null,null,{"$f":"COUNTA(E9:E48)","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:50:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:55:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:00:00"]

{"sheet":"一次案内状","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,4,1],[14,3,14,4],[9,2,10,10],[12,3,12,9],[2,8,2,10],[7,3,7,9]]}
[4]
[]
["保護者への最初の案内状",null,null,null,null,null,null,null,"2020-07-01"]
[null,null,"保護者のみなさまへ"]
[null,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,"－懇談希望表の記入について－\n 下のように,懇談可能で希望する日時に①②をご記入ください。提出いただいた別紙の懇談希望表を元に懇談表を作成し,後日懇談日時をお知らせいたします。\n(①第一希望,②第二希望,③第三希望)"]
[]
[null,null,null,"懇談時間",null,{"$f":"元データ!A9","v":"8月19日(水)"},{"$f":"元データ!A10","v":"8月20日(木)"},{"$f":"元データ!A11","v":"8月21日(金)"},{"$f":"元データ!A12","v":"8月24日(月)"},{"$f":"元データ!A13","v":"8月25日(火)"}]
[null,null,null,{"$f":"IF(元データ!B9=0,\"\",元データ!B9)","v":1},{"$f":"IF(元データ!C9=\"\",\"\",元データ!C9)","v":"8:30:～9:00:"},null,"①"]
[null,null,null,{"$f":"IF(元データ!B10=0,\"\",元データ!B10)","v":2},{"$f":"IF(元データ!C10=\"\",\"\",元データ!C10)","v":"9:00:～9:30:"},null,"①"]
[null,null,null,{"$f":"IF(元データ!B11=0,\"\",元データ!B11)","v":3},{"$f":"IF(元データ!C11=\"\",\"\",元データ!C11)","v":"9:30:～10:00"},null,"①"]
[null,null,null,{"$f":"IF(元データ!B12=0,\"\",元データ!B12)","v":4},{"$f":"IF(元データ!C12=\"\",\"\",元データ!C12)","v":"10:00～10:30"},null,"①"]
[null,null,null,{"$f":"IF(元データ!B13=0,\"\",元データ!B13)","v":5},{"$f":"IF(元データ!C13=\"\",\"\",元データ!C13)","v":"10:30～11:00"},"①"]
[null,null,null,{"$f":"IF(元データ!B14=0,\"\",元データ!B14)","v":6},{"$f":"IF(元データ!C14=\"\",\"\",元データ!C14)","v":"11:00～11:30"},"①"]
[null,null,null,{"$f":"IF(元データ!B15=0,\"\",元データ!B15)","v":7},{"$f":"IF(元データ!C15=\"\",\"\",元データ!C15)","v":"11:30～12:00"},"①"]
[null,null,null,{"$f":"IF(元データ!B16=0,\"\",元データ!B16)","v":""},{"$f":"IF(元データ!C16=\"\",\"\",元データ!C16)","v":"12:00～13:00昼休み"}]
[null,null,null,{"$f":"IF(元データ!B17=0,\"\",元データ!B17)","v":7.5625},{"$f":"IF(元データ!C17=\"\",\"\",元データ!C17)","v":"13:00～13:30"},null,"③",null,null,"②"]
[null,null,null,{"$f":"IF(元データ!B18=0,\"\",元データ!B18)","v":8.5833333333333339},{"$f":"IF(元データ!C18=\"\",\"\",元データ!C18)","v":"13:30～14:00"},null,"③",null,null,"②"]
[null,null,null,{"$f":"IF(元データ!B19=0,\"\",元データ!B19)","v":9.6041666666666661},{"$f":"IF(元データ!C19=\"\",\"\",元データ!C19)","v":"14:00～14:30"},null,null,null,null,"②"]
[null,null,null,{"$f":"IF(元データ!B20=0,\"\",元データ!B20)","v":10.625},{"$f":"IF(元データ!C20=\"\",\"\",元データ!C20)","v":"14:30～15:00"}]
[null,null,null,{"$f":"IF(元データ!B21=0,\"\",元データ!B21)","v":11.645833333333334},{"$f":"IF(元データ!C21=\"\",\"\",元データ!C21)","v":"15:00～15:30"}]
[null,null,null,{"$f":"IF(元データ!B22=0,\"\",元データ!B22)","v":12.666666666666666},{"$f":"IF(元データ!C22=\"\",\"\",元データ!C22)","v":"15:30～16:00"},null,null,"②"]
[null,null,null,{"$f":"IF(元データ!B23=0,\"\",元データ!B23)","v":""},{"$f":"IF(元データ!C23=\"\",\"\",元データ!C23)","v":""},null,null,"②"]
[null,null,null,{"$f":"IF(元データ!B24=0,\"\",元データ!B24)","v":""},{"$f":"IF(元データ!C24=\"\",\"\",元データ!C24)","v":""},null,null,"②"]
[null,null,null,{"$f":"IF(元データ!B25=0,\"\",元データ!B25)","v":""},{"$f":"IF(元データ!C25=\"\",\"\",元データ!C25)","v":""}]
[null,null,null,{"$f":"IF(元データ!B26=0,\"\",元データ!B26)","v":""},{"$f":"IF(元データ!C26=\"\",\"\",元データ!C26)","v":""},null,"③"]
[null,null,null,{"$f":"IF(元データ!B27=0,\"\",元データ!B27)","v":""},{"$f":"IF(元データ!C27=\"\",\"\",元データ!C27)","v":""},null,"③"]
[null,null,null,{"$f":"IF(元データ!B28=0,\"\",元データ!B28)","v":""},{"$f":"IF(元データ!C28=\"\",\"\",元データ!C28)","v":""}]
[null,null,null,{"$f":"IF(元データ!B29=0,\"\",元データ!B29)","v":""},{"$f":"IF(元データ!C29=\"\",\"\",元データ!C29)","v":""}]
[null,null,null,{"$f":"IF(元データ!B30=0,\"\",元データ!B30)","v":""},{"$f":"IF(元データ!C30=\"\",\"\",元データ!C30)","v":""}]
[null,null,null,{"$f":"IF(元データ!B31=0,\"\",元データ!B31)","v":""},{"$f":"IF(元データ!C31=\"\",\"\",元データ!C31)","v":""}]
[null,null,null,{"$f":"IF(元データ!B32=0,\"\",元データ!B32)","v":""},{"$f":"IF(元データ!C32=\"\",\"\",元データ!C32)","v":""}]
[null,null,null,{"$f":"IF(元データ!B33=0,\"\",元データ!B33)","v":""},{"$f":"IF(元データ!C33=\"\",\"\",元データ!C33)","v":""}]
[null,null,null,{"$f":"IF(元データ!B34=0,\"\",元データ!B34)","v":""},{"$f":"IF(元データ!C34=\"\",\"\",元データ!C34)","v":""}]

{"sheet":"懇談希望表","index":2,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,4,4,7],[6,4,6,7],[9,3,9,4],[3,0,4,1]]}
[4]
[]
[null,null,null,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":"元データ!A9","v":"8月19日(水)"},{"$f":"元データ!A10","v":"8月20日(木)"},{"$f":"元データ!A11","v":"8月21日(金)"},{"$f":"元データ!A12","v":"8月24日(月)"},{"$f":"元データ!A13","v":"8月25日(火)"}]
[null,null,null,{"$f":"IF(元データ!B9=0,\"\",元データ!B9)","v":1},{"$f":"IF(元データ!C9=\"\",\"\",元データ!C9)","v":"8:30:～9:00:"}]
[null,null,null,{"$f":"IF(元データ!B10=0,\"\",元データ!B10)","v":2},{"$f":"IF(元データ!C10=\"\",\"\",元データ!C10)","v":"9:00:～9:30:"}]
[null,null,null,{"$f":"IF(元データ!B11=0,\"\",元データ!B11)","v":3},{"$f":"IF(元データ!C11=\"\",\"\",元データ!C11)","v":"9:30:～10:00"}]
[null,null,null,{"$f":"IF(元データ!B12=0,\"\",元データ!B12)","v":4},{"$f":"IF(元データ!C12=\"\",\"\",元データ!C12)","v":"10:00～10:30"}]
[null,null,null,{"$f":"IF(元データ!B13=0,\"\",元データ!B13)","v":5},{"$f":"IF(元データ!C13=\"\",\"\",元データ!C13)","v":"10:30～11:00"}]
[null,null,null,{"$f":"IF(元データ!B14=0,\"\",元データ!B14)","v":6},{"$f":"IF(元データ!C14=\"\",\"\",元データ!C14)","v":"11:00～11:30"}]
[null,null,null,{"$f":"IF(元データ!B15=0,\"\",元データ!B15)","v":7},{"$f":"IF(元データ!C15=\"\",\"\",元データ!C15)","v":"11:30～12:00"}]
[null,null,null,{"$f":"IF(元データ!B16=0,\"\",元データ!B16)","v":""},{"$f":"IF(元データ!C16=\"\",\"\",元データ!C16)","v":"12:00～13:00昼休み"}]
[null,null,null,{"$f":"IF(元データ!B17=0,\"\",元データ!B17)","v":7.5625},{"$f":"IF(元データ!C17=\"\",\"\",元データ!C17)","v":"13:00～13:30"}]
[null,null,null,{"$f":"IF(元データ!B18=0,\"\",元データ!B18)","v":8.5833333333333339},{"$f":"IF(元データ!C18=\"\",\"\",元データ!C18)","v":"13:30～14:00"}]
[null,null,null,{"$f":"IF(元データ!B19=0,\"\",元データ!B19)","v":9.6041666666666661},{"$f":"IF(元データ!C19=\"\",\"\",元データ!C19)","v":"14:00～14:30"}]
[null,null,null,{"$f":"IF(元データ!B20=0,\"\",元データ!B20)","v":10.625},{"$f":"IF(元データ!C20=\"\",\"\",元データ!C20)","v":"14:30～15:00"}]
[null,null,null,{"$f":"IF(元データ!B21=0,\"\",元データ!B21)","v":11.645833333333334},{"$f":"IF(元データ!C21=\"\",\"\",元データ!C21)","v":"15:00～15:30"}]
[null,null,null,{"$f":"IF(元データ!B22=0,\"\",元データ!B22)","v":12.666666666666666},{"$f":"IF(元データ!C22=\"\",\"\",元データ!C22)","v":"15:30～16:00"}]
[null,null,null,{"$f":"IF(元データ!B23=0,\"\",元データ!B23)","v":""},{"$f":"IF(元データ!C23=\"\",\"\",元データ!C23)","v":""}]
[null,null,null,{"$f":"IF(元データ!B24=0,\"\",元データ!B24)","v":""},{"$f":"IF(元データ!C24=\"\",\"\",元データ!C24)","v":""}]
[null,null,null,{"$f":"IF(元データ!B25=0,\"\",元データ!B25)","v":""},{"$f":"IF(元データ!C25=\"\",\"\",元データ!C25)","v":""}]
[null,null,null,{"$f":"IF(元データ!B26=0,\"\",元データ!B26)","v":""},{"$f":"IF(元データ!C26=\"\",\"\",元データ!C26)","v":""}]
[null,null,null,{"$f":"IF(元データ!B27=0,\"\",元データ!B27)","v":""},{"$f":"IF(元データ!C27=\"\",\"\",元データ!C27)","v":""}]
[null,null,null,{"$f":"IF(元データ!B28=0,\"\",元データ!B28)","v":""},{"$f":"IF(元データ!C28=\"\",\"\",元データ!C28)","v":""}]
[null,null,null,{"$f":"IF(元データ!B29=0,\"\",元データ!B29)","v":""},{"$f":"IF(元データ!C29=\"\",\"\",元データ!C29)","v":""}]
[null,null,null,{"$f":"IF(元データ!B30=0,\"\",元データ!B30)","v":""},{"$f":"IF(元データ!C30=\"\",\"\",元データ!C30)","v":""}]
[null,null,null,{"$f":"IF(元データ!B31=0,\"\",元データ!B31)","v":""},{"$f":"IF(元データ!C31=\"\",\"\",元データ!C31)","v":""}]
[null,null,null,{"$f":"IF(元データ!B32=0,\"\",元データ!B32)","v":""},{"$f":"IF(元データ!C32=\"\",\"\",元データ!C32)","v":""}]
[null,null,null,{"$f":"IF(元データ!B33=0,\"\",元データ!B33)","v":""},{"$f":"IF(元データ!C33=\"\",\"\",元データ!C33)","v":""}]
[null,null,null,{"$f":"IF(元データ!B34=0,\"\",元データ!B34)","v":""},{"$f":"IF(元データ!C34=\"\",\"\",元データ!C34)","v":""}]

{"sheet":"二次案内状","index":3,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[21,2,21,3],[9,2,9,9],[2,8,2,9],[7,4,7,7],[2,0,4,1]]}
[8]
[]
["懇談日時をお知らせする二次案内状",null,null,null,null,null,null,null,"2020-07-10"]
[null,null,"保護者のみなさまへ"]
[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,{"$f":"INDEX(懇談表!$B$7:$D$35,$A$1,1)","v":"石井秀典"}]
[]
[null,null,null,"２ 懇談日時",null,{"$f":"INDEX(懇談表!$B$7:$D$35,$A$1,2)","v":"8月20日(木)"},{"$f":"INDEX(懇談表!$B$7:$D$35,$A$1,3)","v":"15:30～16:00"}]
[]
[null,null,null,"３ 懇談場所",null,"５年１組教室"]
[]
[null,null,null,"４ その他    　上記日時で都合のつかない場合は，担任までご連絡ください。"]
[]
[null,null,null,null,null,"懇談表"]
[]
[null,null,"懇談時間",null,{"$f":"懇談表!I7","v":"8月19日(水)"},{"$f":"懇談表!J7","v":"8月20日(木)"},{"$f":"懇談表!K7","v":"8月21日(金)"},{"$f":"懇談表!L7","v":"8月24日(月)"},{"$f":"懇談表!M7","v":"8月25日(火)"}]
[null,null,{"$f":"懇談表!G8","v":1},{"$f":"IF(懇談表!H8=\"\",\"\",懇談表!H8)","v":"8:30:～9:00:"},{"$f":"IF(懇談表!I8=\"\",\"\",懇談表!I8)","v":"上福元直人"},{"$f":"IF(懇談表!J8=\"\",\"\",懇談表!J8)","v":""},{"$f":"IF(懇談表!K8=\"\",\"\",懇談表!K8)","v":""},{"$f":"IF(懇談表!L8=\"\",\"\",懇談表!L8)","v":"松澤香輝"},{"$f":"IF(懇談表!M8=\"\",\"\",懇談表!M8)","v":""}]
[null,null,{"$f":"懇談表!G9","v":2},{"$f":"IF(懇談表!H9=\"\",\"\",懇談表!H9)","v":"9:00:～9:30:"},{"$f":"IF(懇談表!I9=\"\",\"\",懇談表!I9)","v":"長谷川徹"},{"$f":"IF(懇談表!J9=\"\",\"\",懇談表!J9)","v":""},{"$f":"IF(懇談表!K9=\"\",\"\",懇談表!K9)","v":""},{"$f":"IF(懇談表!L9=\"\",\"\",懇談表!L9)","v":""},{"$f":"IF(懇談表!M9=\"\",\"\",懇談表!M9)","v":""}]
[null,null,{"$f":"懇談表!G10","v":3},{"$f":"IF(懇談表!H10=\"\",\"\",懇談表!H10)","v":"9:30:～10:00"},{"$f":"IF(懇談表!I10=\"\",\"\",懇談表!I10)","v":""},{"$f":"IF(懇談表!J10=\"\",\"\",懇談表!J10)","v":""},{"$f":"IF(懇談表!K10=\"\",\"\",懇談表!K10)","v":"瀬口拓弥"},{"$f":"IF(懇談表!L10=\"\",\"\",懇談表!L10)","v":""},{"$f":"IF(懇談表!M10=\"\",\"\",懇談表!M10)","v":""}]
[null,null,{"$f":"懇談表!G11","v":4},{"$f":"IF(懇談表!H11=\"\",\"\",懇談表!H11)","v":"10:00～10:30"},{"$f":"IF(懇談表!I11=\"\",\"\",懇談表!I11)","v":""},{"$f":"IF(懇談表!J11=\"\",\"\",懇談表!J11)","v":""},{"$f":"IF(懇談表!K11=\"\",\"\",懇談表!K11)","v":""},{"$f":"IF(懇談表!L11=\"\",\"\",懇談表!L11)","v":""},{"$f":"IF(懇談表!M11=\"\",\"\",懇談表!M11)","v":""}]
[null,null,{"$f":"懇談表!G12","v":5},{"$f":"IF(懇談表!H12=\"\",\"\",懇談表!H12)","v":"10:30～11:00"},{"$f":"IF(懇談表!I12=\"\",\"\",懇談表!I12)","v":""},{"$f":"IF(懇談表!J12=\"\",\"\",懇談表!J12)","v":""},{"$f":"IF(懇談表!K12=\"\",\"\",懇談表!K12)","v":"島屋八徳"},{"$f":"IF(懇談表!L12=\"\",\"\",懇談表!L12)","v":""},{"$f":"IF(懇談表!M12=\"\",\"\",懇談表!M12)","v":""}]
[null,null,{"$f":"懇談表!G13","v":6},{"$f":"IF(懇談表!H13=\"\",\"\",懇談表!H13)","v":"11:00～11:30"},{"$f":"IF(懇談表!I13=\"\",\"\",懇談表!I13)","v":""},{"$f":"IF(懇談表!J13=\"\",\"\",懇談表!J13)","v":""},{"$f":"IF(懇談表!K13=\"\",\"\",懇談表!K13)","v":""},{"$f":"IF(懇談表!L13=\"\",\"\",懇談表!L13)","v":""},{"$f":"IF(懇談表!M13=\"\",\"\",懇談表!M13)","v":""}]
[null,null,{"$f":"懇談表!G14","v":7},{"$f":"IF(懇談表!H14=\"\",\"\",懇談表!H14)","v":"11:30～12:00"},{"$f":"IF(懇談表!I14=\"\",\"\",懇談表!I14)","v":""},{"$f":"IF(懇談表!J14=\"\",\"\",懇談表!J14)","v":""},{"$f":"IF(懇談表!K14=\"\",\"\",懇談表!K14)","v":""},{"$f":"IF(懇談表!L14=\"\",\"\",懇談表!L14)","v":""},{"$f":"IF(懇談表!M14=\"\",\"\",懇談表!M14)","v":""}]
[null,null,{"$f":"懇談表!G15","v":""},{"$f":"IF(懇談表!H15=\"\",\"\",懇談表!H15)","v":"12:00～13:00昼休み"},{"$f":"IF(懇談表!I15=\"\",\"\",懇談表!I15)","v":""},{"$f":"IF(懇談表!J15=\"\",\"\",懇談表!J15)","v":""},{"$f":"IF(懇談表!K15=\"\",\"\",懇談表!K15)","v":""},{"$f":"IF(懇談表!L15=\"\",\"\",懇談表!L15)","v":""},{"$f":"IF(懇談表!M15=\"\",\"\",懇談表!M15)","v":""}]
[null,null,{"$f":"懇談表!G16","v":7.5625},{"$f":"IF(懇談表!H16=\"\",\"\",懇談表!H16)","v":"13:00～13:30"},{"$f":"IF(懇談表!I16=\"\",\"\",懇談表!I16)","v":""},{"$f":"IF(懇談表!J16=\"\",\"\",懇談表!J16)","v":""},{"$f":"IF(懇談表!K16=\"\",\"\",懇談表!K16)","v":""},{"$f":"IF(懇談表!L16=\"\",\"\",懇談表!L16)","v":""},{"$f":"IF(懇談表!M16=\"\",\"\",懇談表!M16)","v":""}]
[null,null,{"$f":"懇談表!G17","v":8.5833333333333339},{"$f":"IF(懇談表!H17=\"\",\"\",懇談表!H17)","v":"13:30～14:00"},{"$f":"IF(懇談表!I17=\"\",\"\",懇談表!I17)","v":""},{"$f":"IF(懇談表!J17=\"\",\"\",懇談表!J17)","v":""},{"$f":"IF(懇談表!K17=\"\",\"\",懇談表!K17)","v":"ジエゴ"},{"$f":"IF(懇談表!L17=\"\",\"\",懇談表!L17)","v":""},{"$f":"IF(懇談表!M17=\"\",\"\",懇談表!M17)","v":""}]
[null,null,{"$f":"懇談表!G18","v":9.6041666666666661},{"$f":"IF(懇談表!H18=\"\",\"\",懇談表!H18)","v":"14:00～14:30"},{"$f":"IF(懇談表!I18=\"\",\"\",懇談表!I18)","v":""},{"$f":"IF(懇談表!J18=\"\",\"\",懇談表!J18)","v":""},{"$f":"IF(懇談表!K18=\"\",\"\",懇談表!K18)","v":""},{"$f":"IF(懇談表!L18=\"\",\"\",懇談表!L18)","v":""},{"$f":"IF(懇談表!M18=\"\",\"\",懇談表!M18)","v":""}]
[null,null,{"$f":"懇談表!G19","v":10.625},{"$f":"IF(懇談表!H19=\"\",\"\",懇談表!H19)","v":"14:30～15:00"},{"$f":"IF(懇談表!I19=\"\",\"\",懇談表!I19)","v":""},{"$f":"IF(懇談表!J19=\"\",\"\",懇談表!J19)","v":""},{"$f":"IF(懇談表!K19=\"\",\"\",懇談表!K19)","v":""},{"$f":"IF(懇談表!L19=\"\",\"\",懇談表!L19)","v":""},{"$f":"IF(懇談表!M19=\"\",\"\",懇談表!M19)","v":""}]
[null,null,{"$f":"懇談表!G20","v":11.645833333333334},{"$f":"IF(懇談表!H20=\"\",\"\",懇談表!H20)","v":"15:00～15:30"},{"$f":"IF(懇談表!I20=\"\",\"\",懇談表!I20)","v":""},{"$f":"IF(懇談表!J20=\"\",\"\",懇談表!J20)","v":""},{"$f":"IF(懇談表!K20=\"\",\"\",懇談表!K20)","v":""},{"$f":"IF(懇談表!L20=\"\",\"\",懇談表!L20)","v":""},{"$f":"IF(懇談表!M20=\"\",\"\",懇談表!M20)","v":""}]
[null,null,{"$f":"懇談表!G21","v":12.666666666666666},{"$f":"IF(懇談表!H21=\"\",\"\",懇談表!H21)","v":"15:30～16:00"},{"$f":"IF(懇談表!I21=\"\",\"\",懇談表!I21)","v":""},{"$f":"IF(懇談表!J21=\"\",\"\",懇談表!J21)","v":"石井秀典"},{"$f":"IF(懇談表!K21=\"\",\"\",懇談表!K21)","v":""},{"$f":"IF(懇談表!L21=\"\",\"\",懇談表!L21)","v":""},{"$f":"IF(懇談表!M21=\"\",\"\",懇談表!M21)","v":""}]
[null,null,{"$f":"懇談表!G22","v":""},{"$f":"IF(懇談表!H22=\"\",\"\",懇談表!H22)","v":""},{"$f":"IF(懇談表!I22=\"\",\"\",懇談表!I22)","v":""},{"$f":"IF(懇談表!J22=\"\",\"\",懇談表!J22)","v":""},{"$f":"IF(懇談表!K22=\"\",\"\",懇談表!K22)","v":""},{"$f":"IF(懇談表!L22=\"\",\"\",懇談表!L22)","v":""},{"$f":"IF(懇談表!M22=\"\",\"\",懇談表!M22)","v":""}]
[null,null,{"$f":"懇談表!G23","v":""},{"$f":"IF(懇談表!H23=\"\",\"\",懇談表!H23)","v":""},{"$f":"IF(懇談表!I23=\"\",\"\",懇談表!I23)","v":""},{"$f":"IF(懇談表!J23=\"\",\"\",懇談表!J23)","v":""},{"$f":"IF(懇談表!K23=\"\",\"\",懇談表!K23)","v":""},{"$f":"IF(懇談表!L23=\"\",\"\",懇談表!L23)","v":""},{"$f":"IF(懇談表!M23=\"\",\"\",懇談表!M23)","v":""}]
[null,null,{"$f":"懇談表!G24","v":""},{"$f":"IF(懇談表!H24=\"\",\"\",懇談表!H24)","v":""},{"$f":"IF(懇談表!I24=\"\",\"\",懇談表!I24)","v":""},{"$f":"IF(懇談表!J24=\"\",\"\",懇談表!J24)","v":""},{"$f":"IF(懇談表!K24=\"\",\"\",懇談表!K24)","v":""},{"$f":"IF(懇談表!L24=\"\",\"\",懇談表!L24)","v":""},{"$f":"IF(懇談表!M24=\"\",\"\",懇談表!M24)","v":""}]
[null,null,{"$f":"懇談表!G25","v":""},{"$f":"IF(懇談表!H25=\"\",\"\",懇談表!H25)","v":""},{"$f":"IF(懇談表!I25=\"\",\"\",懇談表!I25)","v":""},{"$f":"IF(懇談表!J25=\"\",\"\",懇談表!J25)","v":""},{"$f":"IF(懇談表!K25=\"\",\"\",懇談表!K25)","v":""},{"$f":"IF(懇談表!L25=\"\",\"\",懇談表!L25)","v":""},{"$f":"IF(懇談表!M25=\"\",\"\",懇談表!M25)","v":""}]
[null,null,{"$f":"懇談表!G26","v":""},{"$f":"IF(懇談表!H26=\"\",\"\",懇談表!H26)","v":""},{"$f":"IF(懇談表!I26=\"\",\"\",懇談表!I26)","v":""},{"$f":"IF(懇談表!J26=\"\",\"\",懇談表!J26)","v":""},{"$f":"IF(懇談表!K26=\"\",\"\",懇談表!K26)","v":""},{"$f":"IF(懇談表!L26=\"\",\"\",懇談表!L26)","v":""},{"$f":"IF(懇談表!M26=\"\",\"\",懇談表!M26)","v":""}]
[null,null,{"$f":"懇談表!G27","v":""},{"$f":"IF(懇談表!H27=\"\",\"\",懇談表!H27)","v":""},{"$f":"IF(懇談表!I27=\"\",\"\",懇談表!I27)","v":""},{"$f":"IF(懇談表!J27=\"\",\"\",懇談表!J27)","v":""},{"$f":"IF(懇談表!K27=\"\",\"\",懇談表!K27)","v":""},{"$f":"IF(懇談表!L27=\"\",\"\",懇談表!L27)","v":""},{"$f":"IF(懇談表!M27=\"\",\"\",懇談表!M27)","v":""}]
[null,null,{"$f":"懇談表!G28","v":""},{"$f":"IF(懇談表!H28=\"\",\"\",懇談表!H28)","v":""},{"$f":"IF(懇談表!I28=\"\",\"\",懇談表!I28)","v":""},{"$f":"IF(懇談表!J28=\"\",\"\",懇談表!J28)","v":""},{"$f":"IF(懇談表!K28=\"\",\"\",懇談表!K28)","v":""},{"$f":"IF(懇談表!L28=\"\",\"\",懇談表!L28)","v":""},{"$f":"IF(懇談表!M28=\"\",\"\",懇談表!M28)","v":""}]
[null,null,{"$f":"懇談表!G29","v":""},{"$f":"IF(懇談表!H29=\"\",\"\",懇談表!H29)","v":""},{"$f":"IF(懇談表!I29=\"\",\"\",懇談表!I29)","v":""},{"$f":"IF(懇談表!J29=\"\",\"\",懇談表!J29)","v":""},{"$f":"IF(懇談表!K29=\"\",\"\",懇談表!K29)","v":""},{"$f":"IF(懇談表!L29=\"\",\"\",懇談表!L29)","v":""},{"$f":"IF(懇談表!M29=\"\",\"\",懇談表!M29)","v":""}]
[null,null,{"$f":"懇談表!G30","v":""},{"$f":"IF(懇談表!H30=\"\",\"\",懇談表!H30)","v":""},{"$f":"IF(懇談表!I30=\"\",\"\",懇談表!I30)","v":""},{"$f":"IF(懇談表!J30=\"\",\"\",懇談表!J30)","v":""},{"$f":"IF(懇談表!K30=\"\",\"\",懇談表!K30)","v":""},{"$f":"IF(懇談表!L30=\"\",\"\",懇談表!L30)","v":""},{"$f":"IF(懇談表!M30=\"\",\"\",懇談表!M30)","v":""}]
[null,null,{"$f":"懇談表!G31","v":""},{"$f":"IF(懇談表!H31=\"\",\"\",懇談表!H31)","v":""},{"$f":"IF(懇談表!I31=\"\",\"\",懇談表!I31)","v":""},{"$f":"IF(懇談表!J31=\"\",\"\",懇談表!J31)","v":""},{"$f":"IF(懇談表!K31=\"\",\"\",懇談表!K31)","v":""},{"$f":"IF(懇談表!L31=\"\",\"\",懇談表!L31)","v":""},{"$f":"IF(懇談表!M31=\"\",\"\",懇談表!M31)","v":""}]
[null,null,{"$f":"懇談表!G32","v":""},{"$f":"IF(懇談表!H32=\"\",\"\",懇談表!H32)","v":""},{"$f":"IF(懇談表!I32=\"\",\"\",懇談表!I32)","v":""},{"$f":"IF(懇談表!J32=\"\",\"\",懇談表!J32)","v":""},{"$f":"IF(懇談表!K32=\"\",\"\",懇談表!K32)","v":""},{"$f":"IF(懇談表!L32=\"\",\"\",懇談表!L32)","v":""},{"$f":"IF(懇談表!M32=\"\",\"\",懇談表!M32)","v":""}]
[null,null,{"$f":"懇談表!G33","v":""},{"$f":"IF(懇談表!H33=\"\",\"\",懇談表!H33)","v":""},{"$f":"IF(懇談表!I33=\"\",\"\",懇談表!I33)","v":""},{"$f":"IF(懇談表!J33=\"\",\"\",懇談表!J33)","v":""},{"$f":"IF(懇談表!K33=\"\",\"\",懇談表!K33)","v":""},{"$f":"IF(懇談表!L33=\"\",\"\",懇談表!L33)","v":""},{"$f":"IF(懇談表!M33=\"\",\"\",懇談表!M33)","v":""}]
[null,null,null,{"$f":"IF(懇談表!H34=\"\",\"\",懇談表!H34)","v":""},{"$f":"IF(懇談表!I34=\"\",\"\",懇談表!I34)","v":""},{"$f":"IF(懇談表!J34=\"\",\"\",懇談表!J34)","v":""},{"$f":"IF(懇談表!K34=\"\",\"\",懇談表!K34)","v":""},{"$f":"IF(懇談表!L34=\"\",\"\",懇談表!L34)","v":""},{"$f":"IF(懇談表!M34=\"\",\"\",懇談表!M34)","v":""}]
[null,null,null,{"$f":"IF(懇談表!H35=\"\",\"\",懇談表!H35)","v":""},{"$f":"IF(懇談表!I35=\"\",\"\",懇談表!I35)","v":""},{"$f":"IF(懇談表!J35=\"\",\"\",懇談表!J35)","v":""},{"$f":"IF(懇談表!K35=\"\",\"\",懇談表!K35)","v":""},{"$f":"IF(懇談表!L35=\"\",\"\",懇談表!L35)","v":""},{"$f":"IF(懇談表!M35=\"\",\"\",懇談表!M35)","v":""}]
[null,null,null,{"$f":"IF(懇談表!H36=\"\",\"\",懇談表!H36)","v":""},{"$f":"IF(懇談表!I36=\"\",\"\",懇談表!I36)","v":""},{"$f":"IF(懇談表!J36=\"\",\"\",懇談表!J36)","v":""},{"$f":"IF(懇談表!K36=\"\",\"\",懇談表!K36)","v":""},{"$f":"IF(懇談表!L36=\"\",\"\",懇談表!L36)","v":""},{"$f":"IF(懇談表!M36=\"\",\"\",懇談表!M36)","v":""}]
[null,null,null,{"$f":"IF(懇談表!H37=\"\",\"\",懇談表!H37)","v":""},{"$f":"IF(懇談表!I37=\"\",\"\",懇談表!I37)","v":""},{"$f":"IF(懇談表!J37=\"\",\"\",懇談表!J37)","v":""},{"$f":"IF(懇談表!K37=\"\",\"\",懇談表!K37)","v":""},{"$f":"IF(懇談表!L37=\"\",\"\",懇談表!L37)","v":""},{"$f":"IF(懇談表!M37=\"\",\"\",懇談表!M37)","v":""}]
[null,null,null,{"$f":"IF(懇談表!H38=\"\",\"\",懇談表!H38)","v":""},{"$f":"IF(懇談表!I38=\"\",\"\",懇談表!I38)","v":""},{"$f":"IF(懇談表!J38=\"\",\"\",懇談表!J38)","v":""},{"$f":"IF(懇談表!K38=\"\",\"\",懇談表!K38)","v":""},{"$f":"IF(懇談表!L38=\"\",\"\",懇談表!L38)","v":""},{"$f":"IF(懇談表!M38=\"\",\"\",懇談表!M38)","v":""}]

{"sheet":"懇談表","index":4,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[4,8,4,10],[4,1,4,3],[0,0,2,1]]}
["保護者の希望を元に作成する懇談表"]
[]
[]
[]
[null,"個別懇談表",null,null,null,null,null,null,"懇談表"]
["番号","氏名","日時","時間"]
[{"$f":"IF(B7=\"\",\"\",1)","v":1},{"$f":"IF(元データ!E9=\"\",\"\",元データ!E9)","v":"瀬口拓弥"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B7,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B7,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B7,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B7,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B7,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B7,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B7,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B7,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B7,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B7,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B7,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B7,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B7,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B7,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B7,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B7,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":"8月21日(金)"},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B7,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B7,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B7,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B7,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B7,懇談表!$M$8:$M$23,0),MATCH($B7,懇談表!$L$8:$L$23,0))))))),\"\")","v":"9:30:～10:00"},null,null,null,"懇談時間",{"$f":"元データ!A9","v":"8月19日(水)"},{"$f":"元データ!A10","v":"8月20日(木)"},{"$f":"元データ!A11","v":"8月21日(金)"},{"$f":"元データ!A12","v":"8月24日(月)"},{"$f":"元データ!A13","v":"8月25日(火)"}]
[{"$f":"IF(B8=\"\",\"\",2)","v":2},{"$f":"IF(元データ!E10=\"\",\"\",元データ!E10)","v":"上福元直人"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B8,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B8,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B8,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B8,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B8,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B8,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B8,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B8,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B8,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B8,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B8,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B8,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B8,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B8,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B8,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B8,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":"8月19日(水)"},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B8,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B8,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B8,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B8,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B8,懇談表!$M$8:$M$23,0),MATCH($B8,懇談表!$L$8:$L$23,0))))))),\"\")","v":"8:30:～9:00:"},null,null,{"$f":"IF(元データ!B9=0,\"\",元データ!B9)","v":1},{"$f":"IF(元データ!C9=\"\",\"\",元データ!C9)","v":"8:30:～9:00:"},"上福元直人",null,null,"松澤香輝"]
[{"$f":"IF(B9=\"\",\"\",3)","v":3},{"$f":"IF(元データ!E11=\"\",\"\",元データ!E11)","v":"松澤香輝"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B9,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B9,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B9,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B9,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B9,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B9,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B9,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B9,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B9,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B9,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B9,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B9,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B9,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B9,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B9,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B9,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":"8月24日(月)"},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B9,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B9,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B9,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B9,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B9,懇談表!$M$8:$M$23,0),MATCH($B9,懇談表!$L$8:$L$23,0))))))),\"\")","v":"8:30:～9:00:"},null,null,{"$f":"IF(元データ!B10=0,\"\",元データ!B10)","v":2},{"$f":"IF(元データ!C10=\"\",\"\",元データ!C10)","v":"9:00:～9:30:"},"長谷川徹"]
[{"$f":"IF(B10=\"\",\"\",4)","v":4},{"$f":"IF(元データ!E12=\"\",\"\",元データ!E12)","v":"長谷川徹"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B10,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B10,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B10,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B10,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B10,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B10,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B10,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B10,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B10,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B10,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B10,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B10,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B10,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B10,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B10,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B10,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":"8月19日(水)"},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B10,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B10,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B10,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B10,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B10,懇談表!$M$8:$M$23,0),MATCH($B10,懇談表!$L$8:$L$23,0))))))),\"\")","v":"9:00:～9:30:"},null,null,{"$f":"IF(元データ!B11=0,\"\",元データ!B11)","v":3},{"$f":"IF(元データ!C11=\"\",\"\",元データ!C11)","v":"9:30:～10:00"},null,null,"瀬口拓弥"]
[{"$f":"IF(B11=\"\",\"\",5)","v":5},{"$f":"IF(元データ!E13=\"\",\"\",元データ!E13)","v":"田向泰輝"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B11,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B11,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B11,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B11,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B11,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B11,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B11,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B11,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B11,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B11,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B11,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B11,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B11,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B11,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B11,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B11,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B11,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B11,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B11,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B11,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B11,懇談表!$M$8:$M$23,0),MATCH($B11,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B12=0,\"\",元データ!B12)","v":4},{"$f":"IF(元データ!C12=\"\",\"\",元データ!C12)","v":"10:00～10:30"}]
[{"$f":"IF(B12=\"\",\"\",6)","v":6},{"$f":"IF(元データ!E14=\"\",\"\",元データ!E14)","v":"ドゥシャン"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B12,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B12,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B12,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B12,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B12,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B12,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B12,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B12,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B12,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B12,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B12,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B12,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B12,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B12,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B12,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B12,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B12,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B12,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B12,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B12,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B12,懇談表!$M$8:$M$23,0),MATCH($B12,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B13=0,\"\",元データ!B13)","v":5},{"$f":"IF(元データ!C13=\"\",\"\",元データ!C13)","v":"10:30～11:00"},null,null,"島屋八徳"]
[{"$f":"IF(B13=\"\",\"\",7)","v":7},{"$f":"IF(元データ!E15=\"\",\"\",元データ!E15)","v":"ジエゴ"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B13,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B13,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B13,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B13,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B13,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B13,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B13,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B13,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B13,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B13,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B13,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B13,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B13,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B13,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B13,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B13,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":"8月21日(金)"},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B13,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B13,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B13,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B13,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B13,懇談表!$M$8:$M$23,0),MATCH($B13,懇談表!$L$8:$L$23,0))))))),\"\")","v":"13:30～14:00"},null,null,{"$f":"IF(元データ!B14=0,\"\",元データ!B14)","v":6},{"$f":"IF(元データ!C14=\"\",\"\",元データ!C14)","v":"11:00～11:30"}]
[{"$f":"IF(B14=\"\",\"\",8)","v":8},{"$f":"IF(元データ!E16=\"\",\"\",元データ!E16)","v":"石井秀典"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B14,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B14,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B14,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B14,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B14,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B14,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B14,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B14,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B14,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B14,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B14,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B14,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B14,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B14,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B14,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B14,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":"8月20日(木)"},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B14,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B14,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B14,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B14,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B14,懇談表!$M$8:$M$23,0),MATCH($B14,懇談表!$L$8:$L$23,0))))))),\"\")","v":"15:30～16:00"},null,null,{"$f":"IF(元データ!B15=0,\"\",元データ!B15)","v":7},{"$f":"IF(元データ!C15=\"\",\"\",元データ!C15)","v":"11:30～12:00"}]
[{"$f":"IF(B15=\"\",\"\",9)","v":9},{"$f":"IF(元データ!E17=\"\",\"\",元データ!E17)","v":"福岡将太"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B15,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B15,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B15,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B15,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B15,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B15,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B15,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B15,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B15,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B15,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B15,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B15,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B15,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B15,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B15,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B15,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B15,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B15,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B15,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B15,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B15,懇談表!$M$8:$M$23,0),MATCH($B15,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B16=0,\"\",元データ!B16)","v":""},{"$f":"IF(元データ!C16=\"\",\"\",元データ!C16)","v":"12:00～13:00昼休み"}]
[{"$f":"IF(B16=\"\",\"\",10)","v":10},{"$f":"IF(元データ!E18=\"\",\"\",元データ!E18)","v":"安部崇士"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B16,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B16,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B16,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B16,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B16,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B16,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B16,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B16,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B16,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B16,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B16,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B16,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B16,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B16,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B16,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B16,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B16,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B16,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B16,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B16,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B16,懇談表!$M$8:$M$23,0),MATCH($B16,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B17=0,\"\",元データ!B17)","v":7.5625},{"$f":"IF(元データ!C17=\"\",\"\",元データ!C17)","v":"13:00～13:30"}]
[{"$f":"IF(B17=\"\",\"\",11)","v":11},{"$f":"IF(元データ!E19=\"\",\"\",元データ!E19)","v":"秋山拓也"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B17,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B17,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B17,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B17,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B17,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B17,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B17,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B17,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B17,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B17,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B17,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B17,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B17,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B17,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B17,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B17,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B17,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B17,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B17,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B17,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B17,懇談表!$M$8:$M$23,0),MATCH($B17,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B18=0,\"\",元データ!B18)","v":8.5833333333333339},{"$f":"IF(元データ!C18=\"\",\"\",元データ!C18)","v":"13:30～14:00"},null,null,"ジエゴ"]
[{"$f":"IF(B18=\"\",\"\",12)","v":12},{"$f":"IF(元データ!E20=\"\",\"\",元データ!E20)","v":"吹ヶ徳喜"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B18,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B18,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B18,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B18,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B18,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B18,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B18,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B18,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B18,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B18,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B18,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B18,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B18,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B18,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B18,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B18,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B18,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B18,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B18,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B18,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B18,懇談表!$M$8:$M$23,0),MATCH($B18,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B19=0,\"\",元データ!B19)","v":9.6041666666666661},{"$f":"IF(元データ!C19=\"\",\"\",元データ!C19)","v":"14:00～14:30"}]
[{"$f":"IF(B19=\"\",\"\",13)","v":13},{"$f":"IF(元データ!E21=\"\",\"\",元データ!E21)","v":"奥田雄大"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B19,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B19,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B19,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B19,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B19,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B19,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B19,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B19,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B19,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B19,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B19,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B19,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B19,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B19,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B19,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B19,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B19,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B19,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B19,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B19,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B19,懇談表!$M$8:$M$23,0),MATCH($B19,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B20=0,\"\",元データ!B20)","v":10.625},{"$f":"IF(元データ!C20=\"\",\"\",元データ!C20)","v":"14:30～15:00"}]
[{"$f":"IF(B20=\"\",\"\",14)","v":14},{"$f":"IF(元データ!E22=\"\",\"\",元データ!E22)","v":"内田航平"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B20,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B20,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B20,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B20,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B20,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B20,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B20,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B20,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B20,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B20,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B20,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B20,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B20,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B20,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B20,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B20,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B20,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B20,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B20,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B20,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B20,懇談表!$M$8:$M$23,0),MATCH($B20,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B21=0,\"\",元データ!B21)","v":11.645833333333334},{"$f":"IF(元データ!C21=\"\",\"\",元データ!C21)","v":"15:00～15:30"}]
[{"$f":"IF(B21=\"\",\"\",15)","v":15},{"$f":"IF(元データ!E23=\"\",\"\",元データ!E23)","v":"小西雄大"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B21,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B21,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B21,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B21,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B21,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B21,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B21,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B21,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B21,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B21,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B21,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B21,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B21,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B21,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B21,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B21,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B21,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B21,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B21,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B21,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B21,懇談表!$M$8:$M$23,0),MATCH($B21,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B22=0,\"\",元データ!B22)","v":12.666666666666666},{"$f":"IF(元データ!C22=\"\",\"\",元データ!C22)","v":"15:30～16:00"},null,"石井秀典"]
[{"$f":"IF(B22=\"\",\"\",16)","v":16},{"$f":"IF(元データ!E24=\"\",\"\",元データ!E24)","v":"岩尾憲"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B22,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B22,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B22,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B22,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B22,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B22,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B22,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B22,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B22,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B22,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B22,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B22,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B22,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B22,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B22,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B22,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B22,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B22,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B22,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B22,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B22,懇談表!$M$8:$M$23,0),MATCH($B22,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B23=0,\"\",元データ!B23)","v":""},{"$f":"IF(元データ!C23=\"\",\"\",元データ!C23)","v":""}]
[{"$f":"IF(B23=\"\",\"\",17)","v":17},{"$f":"IF(元データ!E25=\"\",\"\",元データ!E25)","v":"渡井理己"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B23,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B23,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B23,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B23,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B23,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B23,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B23,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B23,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B23,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B23,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B23,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B23,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B23,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B23,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B23,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B23,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B23,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B23,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B23,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B23,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B23,懇談表!$M$8:$M$23,0),MATCH($B23,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B24=0,\"\",元データ!B24)","v":""},{"$f":"IF(元データ!C24=\"\",\"\",元データ!C24)","v":""}]
[{"$f":"IF(B24=\"\",\"\",18)","v":18},{"$f":"IF(元データ!E26=\"\",\"\",元データ!E26)","v":"島屋八徳"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B24,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B24,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B24,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B24,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B24,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B24,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B24,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B24,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B24,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B24,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B24,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B24,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B24,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B24,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B24,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B24,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":"8月21日(金)"},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B24,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B24,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B24,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B24,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B24,懇談表!$M$8:$M$23,0),MATCH($B24,懇談表!$L$8:$L$23,0))))))),\"\")","v":"10:30～11:00"},null,null,{"$f":"IF(元データ!B25=0,\"\",元データ!B25)","v":""},{"$f":"IF(元データ!C25=\"\",\"\",元データ!C25)","v":""}]
[{"$f":"IF(B25=\"\",\"\",19)","v":19},{"$f":"IF(元データ!E27=\"\",\"\",元データ!E27)","v":"清武功暉"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B25,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B25,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B25,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B25,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B25,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B25,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B25,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B25,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B25,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B25,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B25,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B25,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B25,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B25,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B25,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B25,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B25,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B25,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B25,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B25,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B25,懇談表!$M$8:$M$23,0),MATCH($B25,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B26=0,\"\",元データ!B26)","v":""},{"$f":"IF(元データ!C26=\"\",\"\",元データ!C26)","v":""}]
[{"$f":"IF(B26=\"\",\"\",20)","v":20},{"$f":"IF(元データ!E28=\"\",\"\",元データ!E28)","v":"榎本大輝"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B26,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B26,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B26,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B26,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B26,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B26,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B26,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B26,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B26,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B26,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B26,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B26,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B26,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B26,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B26,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B26,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B26,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B26,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B26,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B26,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B26,懇談表!$M$8:$M$23,0),MATCH($B26,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B27=0,\"\",元データ!B27)","v":""},{"$f":"IF(元データ!C27=\"\",\"\",元データ!C27)","v":""}]
[{"$f":"IF(B27=\"\",\"\",21)","v":21},{"$f":"IF(元データ!E29=\"\",\"\",元データ!E29)","v":"藤田征也"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B27,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B27,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B27,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B27,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B27,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B27,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B27,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B27,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B27,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B27,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B27,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B27,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B27,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B27,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B27,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B27,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B27,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B27,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B27,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B27,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B27,懇談表!$M$8:$M$23,0),MATCH($B27,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B28=0,\"\",元データ!B28)","v":""},{"$f":"IF(元データ!C28=\"\",\"\",元データ!C28)","v":""}]
[{"$f":"IF(B28=\"\",\"\",22)","v":22},{"$f":"IF(元データ!E30=\"\",\"\",元データ!E30)","v":"鈴木徳真"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B28,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B28,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B28,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B28,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B28,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B28,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B28,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B28,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B28,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B28,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B28,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B28,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B28,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B28,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B28,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B28,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B28,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B28,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B28,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B28,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B28,懇談表!$M$8:$M$23,0),MATCH($B28,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B29=0,\"\",元データ!B29)","v":""},{"$f":"IF(元データ!C29=\"\",\"\",元データ!C29)","v":""}]
[{"$f":"IF(B29=\"\",\"\",23)","v":23},{"$f":"IF(元データ!E31=\"\",\"\",元データ!E31)","v":"西谷和希"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B29,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B29,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B29,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B29,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B29,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B29,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B29,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B29,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B29,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B29,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B29,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B29,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B29,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B29,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B29,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B29,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B29,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B29,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B29,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B29,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B29,懇談表!$M$8:$M$23,0),MATCH($B29,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B30=0,\"\",元データ!B30)","v":""},{"$f":"IF(元データ!C30=\"\",\"\",元データ!C30)","v":""}]
[{"$f":"IF(B30=\"\",\"\",24)","v":24},{"$f":"IF(元データ!E32=\"\",\"\",元データ!E32)","v":"川上エドオジョン智慧"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B30,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B30,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B30,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B30,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B30,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B30,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B30,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B30,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B30,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B30,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B30,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B30,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B30,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B30,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B30,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B30,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B30,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B30,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B30,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B30,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B30,懇談表!$M$8:$M$23,0),MATCH($B30,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B31=0,\"\",元データ!B31)","v":""},{"$f":"IF(元データ!C31=\"\",\"\",元データ!C31)","v":""}]
[{"$f":"IF(B31=\"\",\"\",25)","v":25},{"$f":"IF(元データ!E33=\"\",\"\",元データ!E33)","v":"浜下瑛"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B31,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B31,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B31,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B31,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B31,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B31,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B31,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B31,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B31,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B31,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B31,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B31,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B31,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B31,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B31,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B31,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B31,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B31,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B31,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B31,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B31,懇談表!$M$8:$M$23,0),MATCH($B31,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B32=0,\"\",元データ!B32)","v":""},{"$f":"IF(元データ!C32=\"\",\"\",元データ!C32)","v":""}]
[{"$f":"IF(B32=\"\",\"\",26)","v":26},{"$f":"IF(元データ!E34=\"\",\"\",元データ!E34)","v":"梶川諒太"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B32,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B32,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B32,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B32,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B32,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B32,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B32,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B32,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B32,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B32,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B32,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B32,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B32,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B32,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B32,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B32,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B32,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B32,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B32,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B32,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B32,懇談表!$M$8:$M$23,0),MATCH($B32,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B33=0,\"\",元データ!B33)","v":""},{"$f":"IF(元データ!C33=\"\",\"\",元データ!C33)","v":""}]
[{"$f":"IF(B33=\"\",\"\",27)","v":27},{"$f":"IF(元データ!E35=\"\",\"\",元データ!E35)","v":"森田凜"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B33,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B33,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B33,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B33,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B33,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B33,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B33,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B33,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B33,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B33,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B33,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B33,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B33,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B33,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B33,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B33,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B33,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B33,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B33,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B33,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B33,懇談表!$M$8:$M$23,0),MATCH($B33,懇談表!$L$8:$L$23,0))))))),\"\")","v":""},null,null,{"$f":"IF(元データ!B34=0,\"\",元データ!B34)","v":""},{"$f":"IF(元データ!C34=\"\",\"\",元データ!C34)","v":""}]
[{"$f":"IF(B34=\"\",\"\",28)","v":28},{"$f":"IF(元データ!E36=\"\",\"\",元データ!E36)","v":"杉森考起"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B34,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B34,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B34,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B34,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B34,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B34,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B34,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B34,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B34,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B34,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B34,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B34,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B34,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B34,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B34,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B34,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B34,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B34,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B34,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B34,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B34,懇談表!$M$8:$M$23,0),MATCH($B34,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B35=\"\",\"\",29)","v":29},{"$f":"IF(元データ!E37=\"\",\"\",元データ!E37)","v":"河田篤秀"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B35,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B35,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B35,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B35,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B35,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B35,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B35,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B35,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B35,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B35,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B35,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B35,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B35,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B35,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B35,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B35,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B35,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B35,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B35,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B35,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B35,懇談表!$M$8:$M$23,0),MATCH($B35,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B36=\"\",\"\",30)","v":30},{"$f":"IF(元データ!E38=\"\",\"\",元データ!E38)","v":"押谷祐樹"},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B36,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B36,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B36,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B36,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B36,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B36,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B36,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B36,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B36,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B36,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B36,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B36,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B36,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B36,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B36,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B36,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B36,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B36,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B36,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B36,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B36,懇談表!$M$8:$M$23,0),MATCH($B36,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B37=\"\",\"\",31)","v":""},{"$f":"IF(元データ!E39=\"\",\"\",元データ!E39)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B37,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B37,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B37,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B37,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B37,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B37,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B37,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B37,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B37,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B37,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B37,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B37,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B37,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B37,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B37,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B37,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B37,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B37,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B37,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B37,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B37,懇談表!$M$8:$M$23,0),MATCH($B37,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B38=\"\",\"\",32)","v":""},{"$f":"IF(元データ!E40=\"\",\"\",元データ!E40)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B38,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B38,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B38,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B38,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B38,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B38,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B38,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B38,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B38,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B38,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B38,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B38,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B38,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B38,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B38,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B38,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B38,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B38,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B38,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B38,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B38,懇談表!$M$8:$M$23,0),MATCH($B38,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B39=\"\",\"\",33)","v":""},{"$f":"IF(元データ!E41=\"\",\"\",元データ!E41)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B39,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B39,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B39,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B39,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B39,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B39,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B39,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B39,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B39,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B39,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B39,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B39,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B39,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B39,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B39,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B39,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B39,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B39,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B39,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B39,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B39,懇談表!$M$8:$M$23,0),MATCH($B39,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B40=\"\",\"\",34)","v":""},{"$f":"IF(元データ!E42=\"\",\"\",元データ!E42)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B40,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B40,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B40,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B40,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B40,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B40,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B40,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B40,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B40,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B40,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B40,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B40,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B40,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B40,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B40,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B40,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B40,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B40,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B40,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B40,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B40,懇談表!$M$8:$M$23,0),MATCH($B40,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B41=\"\",\"\",35)","v":""},{"$f":"IF(元データ!E43=\"\",\"\",元データ!E43)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B41,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B41,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B41,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B41,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B41,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B41,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B41,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B41,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B41,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B41,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B41,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B41,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B41,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B41,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B41,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B41,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B41,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B41,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B41,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B41,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B41,懇談表!$M$8:$M$23,0),MATCH($B41,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B42=\"\",\"\",36)","v":""},{"$f":"IF(元データ!E44=\"\",\"\",元データ!E44)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B42,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B42,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B42,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B42,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B42,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B42,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B42,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B42,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B42,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B42,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B42,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B42,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B42,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B42,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B42,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B42,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B42,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B42,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B42,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B42,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B42,懇談表!$M$8:$M$23,0),MATCH($B42,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B43=\"\",\"\",37)","v":""},{"$f":"IF(元データ!E45=\"\",\"\",元データ!E45)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B43,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B43,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B43,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B43,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B43,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B43,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B43,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B43,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B43,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B43,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B43,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B43,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B43,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B43,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B43,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B43,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B43,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B43,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B43,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B43,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B43,懇談表!$M$8:$M$23,0),MATCH($B43,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B44=\"\",\"\",38)","v":""},{"$f":"IF(元データ!E46=\"\",\"\",元データ!E46)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B44,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B44,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B44,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B44,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B44,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B44,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B44,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B44,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B44,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B44,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B44,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B44,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B44,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B44,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B44,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B44,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B44,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B44,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B44,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B44,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B44,懇談表!$M$8:$M$23,0),MATCH($B44,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B45=\"\",\"\",39)","v":""},{"$f":"IF(元データ!E47=\"\",\"\",元データ!E47)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B45,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B45,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B45,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B45,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B45,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B45,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B45,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B45,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B45,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B45,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B45,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B45,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B45,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B45,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B45,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B45,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B45,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B45,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B45,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B45,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B45,懇談表!$M$8:$M$23,0),MATCH($B45,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[{"$f":"IF(B46=\"\",\"\",40)","v":""},{"$f":"IF(元データ!E48=\"\",\"\",元データ!E48)","v":""},{"$f":"IFERROR(INDEX(懇談表!$I$7:$M$7,IFERROR(MATCH(B46,懇談表!$I$8:$M$8,0),IFERROR(MATCH(B46,懇談表!$I$9:$M$9,0),IFERROR(MATCH(B46,懇談表!$I$10:$M$10,0),IFERROR(MATCH(B46,懇談表!$I$11:$M$11,0),IFERROR(MATCH(B46,懇談表!$I$12:$M$12,0),IFERROR(MATCH(B46,懇談表!$I$13:$M$13,0),IFERROR(MATCH(B46,懇談表!$I$14:$M$14,0),IFERROR(MATCH(B46,懇談表!$I$15:$M$15,0),IFERROR(MATCH(B46,懇談表!$I$16:$M$16,0),IFERROR(MATCH(B46,懇談表!$I$17:$M$17,0),IFERROR(MATCH(B46,懇談表!$I$18:$M$18,0),IFERROR(MATCH(B46,懇談表!$I$19:$M$19,0),IFERROR(MATCH(B46,懇談表!$I$20:$M$20,0),IFERROR(MATCH(B46,懇談表!$I$21:$M$21,0),IFERROR(MATCH(B46,懇談表!$I$22:$M$22,0),IFERROR(MATCH(B46,懇談表!$I$23:$M$23,0),111))))))))))))))))),\"\")","v":""},{"$f":"IFERROR(INDEX(懇談表!$H$8:$H$37,IFERROR(MATCH($B46,懇談表!$I$8:$I$23,0),IFERROR(MATCH($B46,懇談表!$J$8:$J$23,0),IFERROR(MATCH($B46,懇談表!$K$8:$K$23,0),IFERROR(MATCH($B46,懇談表!$L$8:$L$23,0),IFERROR(MATCH($B46,懇談表!$M$8:$M$23,0),MATCH($B46,懇談表!$L$8:$L$23,0))))))),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"に子ども氏名をリストで入力してください。"]
[null,null,null,null,null,null,"データはすべて元データのシートに入力してください。"]

{"sheet":"使用方法","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,1,4,2],[11,1,11,2],[1,0,5,0]]}
[]
["取扱説明"]
[null,"懇談表・案内状作成アプリの使用方法"]
[]
[null,"初期設定"]
[null,1,"このアプリは、エクセルにより懇談表や家庭訪問などの予定表、案内状を作成するとき等に使用してください。"]
[null,2,"初期設定として、メニュー表示からシート保護解除ボタンをクリックして、元データシートにデータを入力します。また、案内状の文面を作成（修正）します。"]
[null,3,"先ず懇談日（5日まで設定可能）を入力し、開始時刻は懇談開始時刻、懇談時間は、20分は、0:20と入力、そして１日の最大懇談回数を入力してください。"]
[null,4,"午前から午後にかけて懇談時間を設定し、昼の休み時間を設定する場合は、昼の時間を入力してください。"]
[null,5,"入力が完了したら、面談時間作成ボタンをクリックしてください。"]
[null,6,"①懇談日時5日間まで対応②氏名４０人まで対応③懇談人数は40人まで対応"]
[null,"使用法"]
[null,1,"保護者への一次案内で希望日時を提出していただく場合は、このシートが利用できます。（記入方法は適宜変更してください。）"]
[null,2,"保護者の希望をもとに、懇談表シートの懇談表に児童・生徒の氏名をリストで入力していきます。"]
[null,3,"案内状シートのメニューから各個人用の案内状が印刷できます。印刷は個人単位、全員一括どちらでも可能です。"]
[null,4,"各シートは、保護がかかっいるので、メニューから保護の解除ボタンで解除してから、案内状の作成は行ってください。"]
[null,5,"シート見出しが、青色時は保護設定時、色無しは解除時となっています。ファイルを開くときに自動的にシートは保護されます。"]
[]
[null,null,"※元データの氏名登録は、１５人に限定されています。Vectorシェアレジの支払いでパスワードが配布されるので、aj2セルに入力し、シート保護を外すと入力できるようになります。"]
[null,null,"※各シートは自動的に保護がかかるようになっています。パスワードは設けていないので、必要に応じて外してください。"]
[null,null,"※その他、使用上動作不良、プログラムミス等を見つけられたとき、またご質問や修正等については、orion (ipsum0114@gmail.com) までご連絡ください。"]