{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["使い方","詳細_ひな形","設定","課題"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":69,"n_cols":2,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["本Excelの使い方"]
["１．起動時にマクロを有効にしてください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["２．「課題」シートの「課題追加」ボタンをクリックします。"]
[]
[]
[]
[]
["※3行目の非表示は、課題を追加時にコピー用で利用するので非表示です。"]
[]
[]
["３．表示されたフォームの内容を全て入力し、「課題を追加する」ボタンをクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["※担当者は２～3文字程度を想定。"]
[]
["４．課題詳細のシートが「詳細_ひな形」からコピーされて作成されます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["※「詳細_番号」のシートが追加されます。管理番号と同じになります。"]
[]
["５．一覧にも課題が追加されます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["■設定方法"]
["「設定」シートを開きます。"]
["以下の内容を変更してご使用ください。"]
["E1:","課題タイトル"]
["①","分類名の参照先。自由に設定してください。"]
["②","管理番号の先頭文字。自由に設定してください。"]
["③","最終番号。初期は「0」になります。課題追加時にこの箇所を更新します。"]
["④","詳細のステータスの参照先。"]

{"sheet":"詳細_ひな形","index":1,"n_rows":4,"n_cols":24,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,2,5,24],[3,0,5,1],[0,0,0,16],[1,2,1,16],[2,2,2,16],[0,17,0,18],[1,0,1,1],[2,0,2,1],[1,17,1,18],[2,17,2,18],[1,19,1,22],[2,19,2,22],[1,23,1,24],[2,23,2,24],[0,23,0,24],[0,21,0,22]]}
[{"$f":"CONCATENATE(設定!E1,\"課題詳細\")","v":"〇〇〇課題詳細"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"管理番号",null,{"$f":"IFERROR(VLOOKUP($C$2,設定!$A$3:$B$25,2,),\"\")","v":""},"-",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,null,null,null,null,null,null,null,"更新日"]
["詳細"]

{"sheet":"設定","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
["設定シート",null,"課題タイトル",null,"〇〇〇"]
["分類名","管理分類","最終番号","ステータス"]
["全体","A",0,"受付"]
["〇〇〇〇〇〇","B",0,"進行中"]
["〇〇〇〇〇〇","C",0,"調査中"]
["〇〇〇〇〇〇","D",0,"構成中"]
["〇〇〇〇〇〇","E",0,"検討中"]
["〇〇〇〇〇〇","F",0,"ご確認"]
["〇〇〇〇〇〇","G",0,"完了"]
["〇〇〇〇〇〇","H",0,"取消"]
["〇〇〇〇〇〇","I",0]
["〇〇〇〇〇〇","J",0]
["〇〇〇〇〇〇","K",0]
["〇〇〇〇〇〇","L",0]
["〇〇〇〇〇〇","M",0]
["〇〇〇〇〇〇","N",0]
["〇〇〇〇〇〇","O",0]
["〇〇〇〇〇〇","P",0]
["〇〇〇〇〇〇","Q",0]
["〇〇〇〇〇〇","R",0]
["〇〇〇〇〇〇","S",0]
["〇〇〇〇〇〇","T",0]
["〇〇〇〇〇〇","U",0]
["〇〇〇〇〇〇","V",0]
["〇〇〇〇〇〇","W",0]

{"sheet":"課題","index":3,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[{"$f":"CONCATENATE(設定!E1,\"課題管理表\")","v":"〇〇〇課題管理表"}]
["管理番号",null,null,"分類","概要","ステータス","登録日","登録者","更新日","更新者"]
[null,"-"]