{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["使い方","目標管理","記入表","日報"],"not_rendered":{"charts":7,"images":3,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"使い方","index":0,"n_rows":43,"n_cols":1,"rows_kept":43,"merged":[[0,0,2,14],[42,0,43,14]]}
["下半期 目標管理シートの使い方"]
{"$rows_empty":41}
["目標達成記入表の使い方"]

{"sheet":"目標管理","index":1,"n_rows":43,"n_cols":16,"rows_kept":43,"merged":[[2,2,2,4],[2,5,2,7],[2,9,2,12],[4,0,9,0],[4,1,6,1],[4,2,6,4],[4,5,6,7],[4,8,6,8],[4,9,6,12],[4,13,6,13],[7,1,9,1],[7,2,7,4],[7,5,7,7],[7,9,7,12],[8,2,8,4],[8,5,8,7],[8,9,8,12],[9,2,9,4],[9,5,9,7],[9,9,9,12],[10,0,15,0],[10,1,12,1],[10,2,12,4],[10,5,12,7],[10,8,12,8],[10,9,12,12],[10,13,12,13],[13,1,15,1],[13,2,13,4],[13,5,13,7],[13,9,13,12],[14,2,14,4],[14,5,14,7],[14,9,14,12],[15,2,15,4],[15,5,15,7],[15,9,15,12],[16,0,21,0],[16,1,18,1],[16,2,18,4],[16,5,18,7],[16,8,18,8],[16,9,18,12],[16,13,18,13],[19,1,21,1],[19,2,19,4],[19,5,19,7],[19,9,19,12],[20,2,20,4],[20,5,20,7],[20,9,20,12],[21,2,21,4],[21,5,21,7],[21,9,21,12],[22,0,27,0],[22,1,24,1],[22,2,24,4],[22,5,24,7],[22,8,24,8],[22,9,24,12],[22,13,24,13],[25,1,27,1],[25,2,25,4],[25,5,25,7],[25,9,25,12],[26,2,26,4],[26,5,26,7],[26,9,26,12],[27,2,27,4],[27,5,27,7],[27,9,27,12],[28,0,33,0],[28,1,30,1],[28,2,30,4],[28,5,30,7],[28,8,30,8],[28,9,30,12],[28,13,30,13],[31,1,33,1],[31,2,31,4],[31,5,31,7],[31,9,31,12],[32,2,32,4],[32,5,32,7],[32,9,32,12],[33,2,33,4],[33,5,33,7],[33,9,33,12],[34,0,39,0],[34,1,36,1],[34,2,36,4],[34,5,36,7],[34,8,36,8],[34,9,36,12],[34,13,36,13],[37,1,39,1],[37,2,37,4],[37,5,37,7],[37,9,37,12],[38,2,38,4],[38,5,38,7],[38,9,38,12],[39,2,39,4],[39,5,39,7],[39,9,39,12]]}
["下半期 目標管理シート"]
[]
[null,null,"目標設定",null,null,"備考",null,null,"達成率","達成グラフ",{"$nulls":3},"今月のまとめ",null,"7月"]
[{"$nulls":15},"8月"]
["7月","大目標","契約件数300件 (1日10件)",{"$nulls":5},{"$f":"記入表!AI4","v":{"v":0.2903225806451613,"d":"0.3"}},{"$f":"I5","v":{"v":0.2903225806451613,"d":"29.0%"}},{"$nulls":5},"9月"]
[{"$nulls":15},"10月"]
[{"$nulls":15},"11月"]
[null,"行動目標","電話応対1日100件",{"$nulls":5},{"$f":"記入表!AI5","v":{"v":4.67741935483871,"d":"4.7"}},{"$f":"I8","v":{"v":4.67741935483871,"d":"467.7%"}},{"$nulls":5},"12月"]
[null,null,"書類作成のミス・修正ゼロ",{"$nulls":5},{"$f":"記入表!AI6","v":{"v":8.290322580645162,"d":"8.3"}},{"$f":"I9","v":{"v":8.290322580645162,"d":"829.0%"}}]
[null,null,"取引先へのアプローチ1日5件",{"$nulls":5},{"$f":"記入表!AI7","v":{"v":5,"d":"5.0"}},{"v":5,"d":"500.0%"}]
["8月","大目標",{"$nulls":6},{"$f":"記入表!AI8","v":""},{"$f":"I11","v":""}]
[]
[]
[null,"行動目標",{"$nulls":6},{"$f":"記入表!AI9","v":""},{"$f":"I14","v":""}]
[{"$nulls":8},{"$f":"記入表!AI10","v":""},{"$f":"I15","v":""}]
[{"$nulls":8},{"$f":"記入表!AI11","v":""},""]
["9月","大目標",{"$nulls":6},{"$f":"記入表!AI12","v":""},{"$f":"I17","v":""}]
[]
[]
[null,"行動目標",{"$nulls":6},{"$f":"記入表!AI13","v":""},{"$f":"I20","v":""}]
[{"$nulls":8},{"$f":"記入表!AI14","v":""},{"$f":"I21","v":""}]
[{"$nulls":8},{"$f":"記入表!AI15","v":""},""]
["10月","大目標",{"$nulls":6},{"$f":"記入表!AI16","v":""},{"$f":"I23","v":""}]
[]
[]
[null,"行動目標",{"$nulls":6},{"$f":"記入表!AI17","v":""},{"$f":"I26","v":""}]
[{"$nulls":8},{"$f":"記入表!AI18","v":""},{"$f":"I27","v":""}]
[{"$nulls":8},{"$f":"記入表!AI19","v":""},""]
["11月","大目標",{"$nulls":6},{"$f":"記入表!AI20","v":""},{"$f":"I29","v":""}]
[]
[]
[null,"行動目標",{"$nulls":6},{"$f":"記入表!AI21","v":""},{"$f":"I32","v":""}]
[{"$nulls":8},{"$f":"記入表!AI22","v":""},{"$f":"I33","v":""}]
[{"$nulls":8},{"$f":"記入表!AI23","v":""},""]
["12月","大目標",{"$nulls":6},{"$f":"記入表!AI24","v":""},{"$f":"I35","v":""}]
[]
[]
[null,"行動目標",{"$nulls":6},{"$f":"記入表!AI25","v":""},{"$f":"I38","v":""}]
[{"$nulls":8},{"$f":"記入表!AI26","v":""},{"$f":"I39","v":""}]
[{"$nulls":8},{"$f":"記入表!AI27","v":""},""]
[]
[]
["月別 目標達成率グラフ"]

{"sheet":"記入表","index":2,"n_rows":59,"n_cols":37,"rows_kept":59,"merged":[[3,0,6,0],[3,36,5,37],[7,0,10,0],[11,0,14,0],[15,0,18,0],[19,0,22,0],[23,0,26,0],[58,36,62,37]]}
["目標達成率記入表",null,null,"※入力上の注意・・・目標達成率(%)を入力します。達成件数ではありません。"]
[]
[null,null,"目標内容",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"総合達成率 (%)"]
["7月","大目標",{"$f":"IF(目標管理!C5=\"\",\"\",目標管理!C5)","v":"契約件数300件 (1日10件)"},{"v":5,"d":"5.0"},{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"$nulls":28},{"$f":"IF(C4=\"\",\"\",SUM(D4:AH4)/31)","v":{"v":0.2903225806451613,"d":"0.3"}},null,"グラフを見る"]
[null,"行動目標1",{"$f":"IF(目標管理!C8=\"\",\"\",目標管理!C8)","v":"電話応対1日100件"},{"v":50,"d":"50.0"},{"v":50,"d":"50.0"},{"v":45,"d":"45.0"},{"$nulls":28},{"$f":"IF(C5=\"\",\"\",SUM(D5:AH5)/31)","v":{"v":4.67741935483871,"d":"4.7"}}]
[null,"行動目標2",{"$f":"IF(目標管理!C9=\"\",\"\",目標管理!C9)","v":"書類作成のミス・修正ゼロ"},{"v":100,"d":"100.0"},{"v":80,"d":"80.0"},{"v":77,"d":"77.0"},{"$nulls":28},{"v":8.290322580645162,"d":"8.3"}]
[null,"行動目標3",{"$f":"IF(目標管理!C10=\"\",\"\",目標管理!C10)","v":"取引先へのアプローチ1日5件"},{"v":60,"d":"60.0"},{"v":40,"d":"40.0"},{"v":55,"d":"55.0"},{"$nulls":28},{"v":5,"d":"5.0"}]
["8月","大目標",{"$f":"IF(目標管理!C11=\"\",\"\",目標管理!C11)","v":""},{"$nulls":31},""]
[null,"行動目標4",{"$f":"IF(目標管理!C14=\"\",\"\",目標管理!C14)","v":""},{"$nulls":31},""]
[null,"行動目標5",{"$f":"IF(目標管理!C15=\"\",\"\",目標管理!C15)","v":""},{"$nulls":31},""]
[null,"行動目標6",{"$f":"IF(目標管理!C16=\"\",\"\",目標管理!C16)","v":""},{"$nulls":31},""]
["9月","大目標",{"$f":"IF(目標管理!C17=\"\",\"\",目標管理!C17)","v":""},{"$nulls":31},{"$f":"IF(C12=\"\",\"\",SUM(D12:AH12)/30)","v":""}]
[null,"行動目標7",{"$f":"IF(目標管理!C20=\"\",\"\",目標管理!C20)","v":""},{"$nulls":31},{"$f":"IF(C13=\"\",\"\",SUM(D13:AH13)/30)","v":""}]
[null,"行動目標8",{"$f":"IF(目標管理!C21=\"\",\"\",目標管理!C21)","v":""},{"$nulls":31},""]
[null,"行動目標9",{"$f":"IF(目標管理!C22=\"\",\"\",目標管理!C22)","v":""},{"$nulls":31},""]
["10月","大目標",{"$f":"IF(目標管理!C23=\"\",\"\",目標管理!C23)","v":""},{"$nulls":31},""]
[null,"行動目標10",{"$f":"IF(目標管理!C26=\"\",\"\",目標管理!C26)","v":""},{"$nulls":31},""]
[null,"行動目標11",{"$f":"IF(目標管理!C27=\"\",\"\",目標管理!C27)","v":""},{"$nulls":31},""]
[null,"行動目標12",{"$f":"IF(目標管理!C28=\"\",\"\",目標管理!C28)","v":""},{"$nulls":31},""]
["11月","大目標",{"$f":"IF(目標管理!C29=\"\",\"\",目標管理!C29)","v":""},{"$nulls":31},{"$f":"IF(C20=\"\",\"\",SUM(D20:AH20)/30)","v":""}]
[null,"行動目標13",{"$f":"IF(目標管理!C32=\"\",\"\",目標管理!C32)","v":""},{"$nulls":31},{"$f":"IF(C21=\"\",\"\",SUM(D21:AH21)/30)","v":""}]
[null,"行動目標14",{"$f":"IF(目標管理!C33=\"\",\"\",目標管理!C33)","v":""},{"$nulls":31},""]
[null,"行動目標15",{"$f":"IF(目標管理!C34=\"\",\"\",目標管理!C34)","v":""},{"$nulls":31},""]
["12月","大目標",{"$f":"IF(目標管理!C35=\"\",\"\",目標管理!C35)","v":""},{"$nulls":31},""]
[null,"行動目標16",{"$f":"IF(目標管理!C38=\"\",\"\",目標管理!C38)","v":""},{"$nulls":31},""]
[null,"行動目標17",{"$f":"IF(目標管理!C39=\"\",\"\",目標管理!C39)","v":""},{"$nulls":31},""]
[null,"行動目標18",{"$f":"IF(目標管理!C40=\"\",\"\",目標管理!C40)","v":""},{"$nulls":31},""]
{"$rows_empty":31}
[{"$nulls":36},"達成度入力表を見る"]

{"sheet":"日報","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"merged":[[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11]]}
["メモ（やったこと、できなかったことなどを記入）"]
[]
["7月",null,"8月",null,"9月",null,"10月",null,"11月",null,"12月"]
[1,null,1,null,1,null,1,null,1,null,1]
[2,null,2,null,2,null,2,null,2,null,2]
[3,null,3,null,3,null,3,null,3,null,3]
[4,null,4,null,4,null,4,null,4,null,4]
[5,null,5,null,5,null,5,null,5,null,5]
[6,null,6,null,6,null,6,null,6,null,6]
[7,null,7,null,7,null,7,null,7,null,7]
[8,null,8,null,8,null,8,null,8,null,8]
[9,null,9,null,9,null,9,null,9,null,9]
[10,null,10,null,10,null,10,null,10,null,10]
[11,null,11,null,11,null,11,null,11,null,11]
[12,null,12,null,12,null,12,null,12,null,12]
[13,null,13,null,13,null,13,null,13,null,13]
[14,null,14,null,14,null,14,null,14,null,14]
[15,null,15,null,15,null,15,null,15,null,15]
[16,null,16,null,16,null,16,null,16,null,16]
[17,null,17,null,17,null,17,null,17,null,17]
[18,null,18,null,18,null,18,null,18,null,18]
[19,null,19,null,19,null,19,null,19,null,19]
[20,null,20,null,20,null,20,null,20,null,20]
[21,null,21,null,21,null,21,null,21,null,21]
[22,null,22,null,22,null,22,null,22,null,22]
[23,null,23,null,23,null,23,null,23,null,23]
[24,null,24,null,24,null,24,null,24,null,24]
[25,null,25,null,25,null,25,null,25,null,25]
[26,null,26,null,26,null,26,null,26,null,26]
[27,null,27,null,27,null,27,null,27,null,27]
[28,null,28,null,28,null,28,null,28,null,28]
[29,null,29,null,29,null,29,null,29,null,29]
[30,null,30,null,30,null,30,null,30,null,30]
[31,null,31,null,31,null,31,null,31,null,31]