{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["使い方","下半期 業務計画表"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,5,4,7],[4,8,4,10],[4,11,4,13],[5,2,5,4],[5,5,5,7],[5,8,5,10],[5,11,5,13],[9,2,9,4],[9,5,9,7],[9,8,9,10],[9,11,9,13],[10,2,10,4],[10,5,10,7],[10,8,10,10],[10,11,10,13],[6,2,6,4],[6,5,6,7],[6,8,6,10],[6,11,6,13],[7,2,7,4],[7,5,7,7],[7,8,7,10],[7,11,7,13],[10,17,10,18],[11,14,11,15],[11,17,11,18],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[10,14,10,15],[14,14,14,15],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[16,14,16,15],[19,1,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[16,2,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[20,14,20,15],[21,1,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[20,1,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[22,14,22,15],[23,1,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[22,1,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[24,14,24,15],[25,1,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[24,1,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[26,14,26,15],[27,1,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[26,1,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[28,14,28,15],[29,1,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[28,1,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[31,14,31,15],[32,1,41,1],[32,14,32,15],[33,14,33,15],[34,14,34,15],[35,14,35,15],[36,14,36,15],[37,14,37,15],[38,14,38,15],[39,14,39,15],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[47,1,51,1],[47,14,47,15],[48,14,48,15],[49,14,49,15],[50,14,50,15],[51,14,51,15],[40,14,40,15],[41,14,41,15],[42,1,46,1],[42,14,42,15],[43,14,43,15],[44,14,44,15],[45,14,45,15],[46,14,46,15],[57,1,61,1],[57,14,57,15],[58,14,58,15],[59,14,59,15],[60,14,60,15],[61,14,61,15],[52,1,56,1],[52,14,52,15],[53,14,53,15],[54,14,54,15],[55,14,55,15],[56,14,56,15]]}
[]
[null,"下半期 業務計画表 の使い方"]
[]
[]
[null,"上半期 実績","売上金額",null,null,"売上件数",null,null,"取引先（顧客）数",null,null,"新規客獲得数"]
[null,"目　標",5000,null,null,250,null,null,300,null,null,10]
[null,"実　績",4800,null,null,240,null,null,310,null,null,10]
[null,"達成率",{"$f":"IFERROR(C7/C6,\"\")","v":0.96},null,null,{"$f":"IFERROR(F7/F6,\"\")","v":0.96},null,null,{"$f":"IFERROR(I7/I6,\"\")","v":1.0333333333333334},null,null,{"$f":"IFERROR(L7/L6,\"\")","v":1}]
[]
[null,"下半期 目標設定","売上金額",null,null,"売上件数",null,null,"取引先（顧客）数",null,null,"新規客獲得数"]
[null,"目　標",5500,null,null,300,null,null,320,null,null,10]
[]
[null,"月別 目標設定","10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"合計"]
[null,"売上金額（千円）",930,null,850,null,1400,null,820,null,700,null,800,null,{"$f":"SUM(C14:N14)","v":5500}]
[null,"売上件数（件）",45,null,40,null,120,null,40,null,20,null,35,null,{"$f":"SUM(C15:N15)","v":300}]
[null,"取引先（顧客）数（件）",55,null,50,null,95,null,40,null,35,null,45,null,320]
[null,"新規客獲得数（件）",2,null,1,null,3,null,1,null,1,null,2,null,10]
[]
[null,"売上計画"]
[null,"施策計画",null,null,"期間",null,"経費（千円）",null,"売上予算（千円）",null,"売上件数目標（件）",null,"その他必要事項",null,"備考"]
[null,"△△キャンペーン",null,null,"11/5~11/20",null,250,null,350,null,30,null,"アルバイト3人"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"スケジュール","10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"備考"]
[null,"業務スケジュール"]
[null,null,null,null,null,null,"　"]
[null,null,null,null,null,"　　"]
[]
[]
[]
[]
[]
[]
[]
[null,"新商品"]
[]
[]
[]
[]
[null,"キャンペーン1"]
[]
[]
[]
[]
[null,"キャンペーン2"]
[]
[]
[]
[]
[null,"その他"]

{"sheet":"下半期 業務計画表","index":1,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[19,14,19,15],[19,10,19,11],[19,8,19,9],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[20,14,20,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[24,14,24,15],[21,8,21,9],[22,8,22,9],[23,8,23,9],[20,10,20,11],[21,10,21,11],[22,10,22,11],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[29,14,29,15],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[26,6,26,7],[26,8,26,9],[26,12,26,13],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[29,4,29,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[19,12,19,13],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,10,23,11],[23,12,23,13],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[20,8,20,9],[19,4,19,5],[26,10,26,11],[57,14,57,15],[58,14,58,15],[59,14,59,15],[60,14,60,15],[61,14,61,15],[52,14,52,15],[53,14,53,15],[54,14,54,15],[55,14,55,15],[56,14,56,15],[47,14,47,15],[48,14,48,15],[49,14,49,15],[50,14,50,15],[51,14,51,15],[42,14,42,15],[43,14,43,15],[44,14,44,15],[45,14,45,15],[46,14,46,15],[37,14,37,15],[38,14,38,15],[39,14,39,15],[40,14,40,15],[41,14,41,15],[32,14,32,15],[33,14,33,15],[34,14,34,15],[35,14,35,15],[36,14,36,15],[32,1,41,1],[42,1,46,1],[47,1,51,1],[52,1,56,1],[57,1,61,1],[13,14,13,15],[14,14,14,15],[15,14,15,15],[16,14,16,15],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[11,17,11,18],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[16,12,16,13],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[9,8,9,10],[9,11,9,13],[10,2,10,4],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[13,4,13,5],[15,4,15,5],[10,5,10,7],[10,8,10,10],[10,11,10,13],[10,14,10,15],[10,17,10,18],[11,14,11,15],[4,11,4,13],[5,2,5,4],[6,2,6,4],[7,2,7,4],[5,5,5,7],[6,5,6,7],[7,5,7,7],[5,8,5,10],[6,8,6,10],[7,8,7,10],[5,11,5,13],[6,11,6,13],[7,11,7,13],[4,2,4,4],[4,5,4,7],[4,8,4,10],[9,2,9,4],[9,5,9,7]]}
[]
[null,"下半期 業務計画表"]
[]
[]
[null,"上半期 実績","売上金額",null,null,"売上件数",null,null,"取引先（顧客）数",null,null,"新規客獲得数"]
[null,"目　標",5000,null,null,250,null,null,300,null,null,10]
[null,"実　績",4800,null,null,240,null,null,310,null,null,10]
[null,"達成率",{"$f":"IFERROR(C7/C6,\"\")","v":0.96},null,null,{"$f":"IFERROR(F7/F6,\"\")","v":0.96},null,null,{"$f":"IFERROR(I7/I6,\"\")","v":1.0333333333333334},null,null,{"$f":"IFERROR(L7/L6,\"\")","v":1}]
[]
[null,"下半期 目標設定","売上金額",null,null,"売上件数",null,null,"取引先（顧客）数",null,null,"新規客獲得数"]
[null,"目　標",5500,null,null,300,null,null,320,null,null,10]
[]
[null,"月別 目標設定","10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"合計"]
[null,"売上金額（千円）",930,null,850,null,1400,null,820,null,700,null,800,null,{"$f":"SUM(C14:N14)","v":5500}]
[null,"売上件数（件）",45,null,40,null,120,null,40,null,20,null,35,null,{"$f":"SUM(C15:N15)","v":300}]
[null,"取引先（顧客）数（件）",55,null,50,null,95,null,40,null,35,null,45,null,320]
[null,"新規客獲得数（件）",2,null,1,null,3,null,1,null,1,null,2,null,10]
[]
[null,"売上計画"]
[null,"施策計画",null,null,"期間",null,"経費（千円）",null,"売上予算（千円）",null,"売上件数目標（件）",null,"その他必要事項",null,"備考"]
[null,"△△キャンペーン",null,null,"11/5~11/20",null,250,null,350,null,30,null,"アルバイト3人"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"スケジュール","10月",null,"11月",null,"12月",null,"1月",null,"2月",null,"3月",null,"備考"]
[null,"業務スケジュール"]
[null,null,null,null,null,null,"　"]
[null,null,null,null,null,"　　"]
[]
[]
[]
[]
[]
[]
[]
[null,"新商品"]
[]
[]
[]
[]
[null,"キャンペーン1"]
[]
[]
[]
[]
[null,"キャンペーン2"]
[]
[]
[]
[]
[null,"その他"]