{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["教師の一覧"," リスト データ"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"教師の一覧","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,1,0,2],[0,4,0,8],[2,9,6,9]]}
[null,"教師の一覧",null,"リスト データ","このセルには、状態の色の凡例があります。開始前は標準スタイル、実行中は R=91 G=133 B=49、期限は R=118 G=88 B=0、保留中は R=109 G=66 B=111、完了は取り消し線、キャンセル済みは R=191 G=191 B=191、期限超過は R=191 G=33 B=28。"]
[null,"項目","カテゴリ","開始日","期限","残り日数","状態","メモ"]
[null,"引き出しの掃除","オフィス",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,6)","v":"2018-04-06"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,16)","v":"2018-04-16"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":""},"完了",null,null,"このセルには、状態スライサーが含まれます。状況でリストをフィルター処理するには、スライサーで状態を選びます。Ctrl キーを押しながら、複数のオプションを選びます。"]
[null,"ステッカーの注文","備品",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,11)","v":"2018-04-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":""},"完了"]
[null,"床のモップふきとワックスがけ","その他",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())-25)","v":"2018-04-16"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":""},"完了"]
[null,"名前ラベル作成済み","備品",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)","v":"2018-04-01"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":""},"保留中"]
[null,"四半期成績書面レポート","評価",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"TODAY()-5","v":"2018-05-06"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":-5},"期限超過"]
[null,"許可証のメール通知","電話をかける",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-05-01"},{"$f":"TODAY()","v":"2018-05-11"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":""},"キャンセル済み"]
[null,"成績口頭レポート","オフィス",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),7)","v":"2018-05-07"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),17)","v":"2018-05-17"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":6},"実行中"]
[null,"鉛筆を削る","備品",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),11)","v":"2018-05-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),10)","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(リスト[[#This Row],[開始日]]:リスト[[#This Row],[期限]])<>2,\"\",IF(OR(リスト[[#This Row],[状態]]=\"完了\",リスト[[#This Row],[状態]]=\"キャンセル済み\",リスト[[#This Row],[状態]]=\"保留中\"),\"\",リスト[[#This Row],[期限]]-TODAY())),\"\")","v":-1},"実行中"]

{"sheet":" リスト データ","index":1,"n_rows":13,"n_cols":3,"rows_kept":13}
[null,"リスト データ","教師の一覧"]
[null,"カテゴリ"]
[null,"オフィス"]
[null,"備品"]
[null,"購入するもの"]
[null,"電話をかける"]
[null,"新しいアイデア"]
[null,"評価"]
[null,"チーム"]
[null,"介入"]
[null,"コンピューター"]
[null,"個人用"]
[null,"その他"]