{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["コマンド","DB","以降のシートは変更不可→","テンプレート","加工DB"],"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":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["★作業用エクセル★"]
[]
[]
[]
[]
["【作業手順】"]
["①リセットボタンを押す"]
["作成の前に必ずリセットをクリックしてください。"]
["※クリックしないと、前回の作業分のデータをもとに生成される場合があります。"]
["②\"DB\"シートに抽出したCSVデータを貼り付け"]
["※A2より貼り付けてください。"]
["※「氏名」と「開始時刻」を組み合わせて同じデータだった場合、作業が途中で停止しますのでご注意ください。"]
["③作成ボタンを押す"]
["④終了"]
["※作成されたファイルは、このエクセルと同階層のディレクトリに保存されます。"]

{"sheet":"DB","index":1,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["学籍番号","氏名","相談日","開始時間","終了時間","キャンパス名","開催場所","相談内容","詳細"]

{"sheet":"以降のシートは変更不可→","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"テンプレート","index":3,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,43,8],[32,0,43,0],[8,1,8,2],[8,4,8,8],[10,1,10,8],[2,6,2,8],[4,5,4,8],[3,5,3,8],[11,1,30,8],[11,0,30,0],[5,1,5,8],[6,1,6,8]]}
["■キャリア相談予約",null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2017-03-01"}]
[]
["相談日","2017","年","03","月","15","日"]
["開始時間","11","時","00","分","から"]
["終了時間","11","時","20","分","まで"]
["キャンパス名","北16条キャンパス"]
["開催場所","北16条キャンパス"]
[]
["学籍番号",1411081,null,"氏名","平井綾耶"]
[]
["相談内容","書類添削"]
["相談内容詳細","藤田さん<改行><改行>藤女子大学 英語文化学科3年の平井綾耶です。<改行><改行>エントリーシートと履歴書の添削と<改行>面接対策をお願いしたいです。<改行><改行>よろしくお願い致します。<改行><改行>藤女子大学 英語文化学科3年 平井綾耶"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["担当者記入欄"]

{"sheet":"加工DB","index":4,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(DB!C2,1,4)","v":""},{"$f":"MID(DB!C2,5,2)","v":""},{"$f":"MID(DB!C2,7,2)","v":""},{"$f":"IF(LEN(DB!D2)=3,MID(DB!D2,1,1),MID(DB!D2,1,2))","v":""},{"$f":"IF(LEN(DB!D2)=3,MID(DB!D2,2,2),MID(DB!D2,3,2))","v":""},{"$f":"IF(LEN(DB!E2)=3,MID(DB!E2,1,1),MID(DB!E2,1,2))","v":""},{"$f":"IF(LEN(DB!E2)=3,MID(DB!E2,2,2),MID(DB!E2,3,2))","v":""},{"$f":"DB!F2","v":0},{"$f":"DB!G2","v":0},{"$f":"DB!A2","v":0},{"$f":"DB!B2","v":0},{"$f":"DB!H2","v":0},{"$f":"DB!I2","v":0}]