{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["ガント","詳細情報"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"ガント","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["このワークシートでガント チャートを作成します。\nセル B1 には、このプロジェクトのタイトルを入力します。\n凡例タイトルはセル I1 にあります。\nこのワークシートの使用方法に関する情報 (スクリーン リーダーの説明やブックの作成者など) は、\"詳細情報\" ワークシートに入ります。\n列 A を下方に移動し続けると、さらに多くの情報を確認できます。","プロジェクト タイトル",{"$nulls":6},"凡例:"]
["セル B2 には会社の名前を入力します。\n凡例は、セル I2 から AC2 にあります。","会社名",{"$nulls":6},"順調",{"$nulls":4},"低リスク",{"$nulls":4},"中リスク",{"$nulls":4},"高リスク",{"$nulls":4},"割り当てなし"]
["セル B3 に、プロジェクト主任の名前を入力します。セル F3 に、プロジェクトの開始日を入力するか、サンプルの数式を使用してガント データ テーブルから最も早い日付の値を見つけます。\nプロジェクトの開始日: ラベルはセル D3 に入ります。","プロジェクト主任",null,"プロジェクトの開始日:",null,{"$f":"IFERROR(IF(MIN(マイルストーン[開始])=0,TODAY(),MIN(マイルストーン[開始])),TODAY())","v":"2018-07-07"}]
["スクロールの増分はセル F4 に入ります。\n行 5 の日付に対応する月が、セル I4 からセル BL4 に表示されます。\nこれらのセルは変更しないでください。これらは、セル F3 のプロジェクトの開始日に基づいて自動的に更新されます。",null,null,"スクロールの増分:",null,0,null,null,{"$f":"TEXT(I5,\"m月\")","v":"7月"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"m月\")=I4,\"\",TEXT(P5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"m月\")=P4,TEXT(W5,\"m月\")=I4),\"\",TEXT(W5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"m月\")=W4,TEXT(AD5,\"m月\")=P4,TEXT(AD5,\"m月\")=I4),\"\",TEXT(AD5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"m月\")=AD4,TEXT(AK5,\"m月\")=W4,TEXT(AK5,\"m月\")=P4,TEXT(AK5,\"m月\")=I4),\"\",TEXT(AK5,\"m月\"))","v":"8月"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"m月\")=AK4,TEXT(AR5,\"m月\")=AD4,TEXT(AR5,\"m月\")=W4,TEXT(AR5,\"m月\")=P4),\"\",TEXT(AR5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"m月\")=AR4,TEXT(AY5,\"m月\")=AK4,TEXT(AY5,\"m月\")=AD4,TEXT(AY5,\"m月\")=W4),\"\",TEXT(AY5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"m月\")=AY4,TEXT(BF5,\"m月\")=AR4,TEXT(BF5,\"m月\")=AK4,TEXT(BF5,\"m月\")=AD4),\"\",TEXT(BF5,\"m月\"))","v":""}]
["セル I5 から BL5 には、各日付のセルの上にあるセル ブロック内に表示される月に対応するその月の日付の数字が含まれており、自動的に計算が行われます。\nこれらのセルは変更しないでください。\n今日の日付は、行 5 の今日の日付からプロジェクト スケジュールの最後まで日付列全体が赤 (16 進値 #AD3815) で囲まれます。",{"$nulls":7},{"$f":"IFERROR(Project_Start+Scrolling_Increment,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["スクロール バーはセル I6 から BL6 までに入ります。データのページングの増分は、一度に 2 ページとして定義されており、コントロール バーの設定で構成することができます。\nタイムラインの前後にジャンプするには、セル F4 に 0 以上の値を入力します。\n値 0 は、グラフの先頭に移動します。"]
["この行には、その下に続くプロジェクトのスケジュールの見出しが含まれています。\nコンテンツを読み上げるには、B7 から BL7 に移動します。その見出しの上にある日付の各曜日の最初の文字が、セル I7 から始まってセル BL7 まで続いています。\nすべてのプロジェクトのタイムライン グラフは、マイルストーンの表に入力されたカテゴリ、開始日、日数を基にして自動的に生成されます。","マイルストーンの説明","カテゴリ","担当者","進捗状況","開始","日数",null,{"$f":"LEFT(TEXT(I5,\"aaa\"),1)","v":"土"},"日","月","火","水","木","金","土","日","月","火","水","木","金","土","日","月","火","水","木","金","土","日","月","火","水","木","金","土","日","月","火",{"$f":"LEFT(TEXT(AO5,\"aaa\"),1)","v":"水"},"木","金","土","日","月","火","水","木","金","土","日","月","火","水","木","金","土","日","月","火","水","木","金"]
["この行は削除しないでください。この行は、プロジェクトのスケジュール内にある現在の日付を強調表示するために使用されている数式を保持するために非表示になっています。 "]
["セル B9 からセル G9 に、プロジェクト情報を入力します。\nサンプル データは、セル B9 からセル G33 に格納されています。\nグラフの作成を開始するには、マイルストーンの説明を入力し、ドロップダウン リストからカテゴリを選択し、アイテムにユーザーを割り当ててから、タスクの進捗状況、開始日、および日数を入力します。\n次の指示はセル A34 にあります。","タイトル 1",{"$nulls":6},{"$f":"IF(AND($C9=\"目標\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"マイルストーン\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目標\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"マイルストーン\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目標\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"マイルストーン\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目標\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"マイルストーン\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"タスク 1","目標","名前",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-09-02"},3,null,{"$f":"IF(AND($C10=\"目標\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"マイルストーン\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 2","マイルストーン",null,null,{"$f":"TODAY()+5","v":"2019-09-07"},1,null,{"$f":"IF(AND($C11=\"目標\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"マイルストーン\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 3","低リスク",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-08-30"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 4","マイルストーン",null,null,{"$f":"F10+20","v":"2019-09-22"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 5","中リスク",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-09-08"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タイトル 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 1","高リスク",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-09-08"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 2","順調",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-09-10"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 3","低リスク",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-09-15"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 4","マイルストーン",null,null,{"$f":"F18+2","v":"2019-09-17"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 5",{"$nulls":3},{"$f":"F19+1","v":"2019-09-18"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タイトル 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 1","順調",null,null,{"$f":"F10+15","v":"2019-09-17"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 2","中リスク",null,null,{"$f":"F22+3","v":"2019-09-20"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 3","順調",null,null,{"$f":"F23+15","v":"2019-10-05"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"目標\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"マイルストーン\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"目標\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"マイルストーン\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"タスク 4","目標",null,null,{"$f":"F19+22","v":"2019-10-09"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"目標\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"マイルストーン\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 5","低リスク",null,null,{"$f":"F14","v":"2019-09-08"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タイトル 4",{"$nulls":6},{"$f":"IF(AND($C27=\"目標\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"マイルストーン\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 1",{"$nulls":3},{"$f":"F25+3","v":"2019-10-12"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 3","マイルストーン",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"タスク 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["これは空の行です",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["この行は、ガント マイルストーン データの末尾をマークします。この行には何も入力しないでください。\nさらにアイテムを追加するには、この行の上に新しい行を挿入します。","さらにデータを追加するには、この行の上に新しい行を挿入します。"]

{"sheet":"詳細情報","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["このテンプレートについて"]
["このテンプレートを使用すると、プロジェクトの視覚化と管理に役立つガント チャートを簡単な方法で作成できます。タスクの説明を入力し、目標のカテゴリ、マイルストーン、順調、低リスク、中リスク、高リスク、進捗状況 (タスク完了の割合)、開始日、タスクを完了する日数を選択するだけです。ガント チャートが描画され、さまざまなカテゴリを区別できるように色分けされます。スクロール バーを使用すると、タイムラインをスクロールすることができます。新しいタスクを挿入するには、新しい行を挿入します。\n"]
["スクリーン リーダーのガイド"]
["このブックには 2 つのワークシートがあります。\n\nガント チャート\n詳細情報\n\n各ワークシートの説明は、各ワークシートの A 列のセル A1 から始まります。非表示のテキストで書き込まれます。各手順では、その行に含まれる情報について説明しています。明示的な指示がない限り、後続の各手順はセル A2、セル A3 といった順に格納されています。たとえば、説明テキストに、次の手順について \"セル A6 に続く\" と記載されている場合があります。\n\nこの非表示のテキストは印刷されません。\n\nワークシートからこれらの説明を削除する場合は、列 A を削除するだけです。"]
["これは、このワークシートにおける最後の説明です。"]