{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["使い方","売上目標設定","実績入力表"],"not_rendered":{"charts":15,"images":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"使い方","index":0,"n_rows":28,"n_cols":2,"rows_kept":28,"merged":[[0,0,2,20],[4,2,4,3],[4,5,4,6],[4,8,4,9],[4,11,4,12],[4,14,4,15],[4,17,4,18],[5,2,5,3],[5,4,6,4],[5,5,5,6],[5,7,6,7],[5,8,5,9],[5,10,6,10],[5,11,5,12],[5,13,6,13],[5,14,5,15],[5,16,6,16],[5,17,5,18],[5,19,6,19],[6,2,6,3],[6,5,6,6],[6,8,6,9],[6,11,6,12],[6,14,6,15],[6,17,6,18],[9,1,9,3],[9,5,9,19],[10,1,10,3],[10,5,10,19],[12,2,12,3],[12,5,12,6],[12,8,12,9],[12,11,12,12],[12,14,12,15],[12,17,12,18],[13,2,13,3],[13,4,14,4],[13,5,13,6],[13,7,14,7],[13,8,13,9],[13,10,14,10],[13,11,13,12],[13,13,14,13],[13,14,13,15],[13,16,14,16],[13,17,13,18],[13,19,14,19],[14,2,14,3],[14,5,14,6],[14,8,14,9],[14,11,14,12],[14,14,14,15],[14,17,14,18],[16,2,16,4],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[17,2,17,4],[17,5,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,16],[17,17,17,19],[18,2,18,4],[18,5,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,19],[28,1,28,19]]}
["下半期売上管理シート 使い方"]
{"$rows_empty":26}
[null,"実績入力表の使い方"]

{"sheet":"売上目標設定","index":1,"n_rows":25,"n_cols":20,"rows_kept":25,"merged":[[1,1,1,18],[4,2,4,3],[4,5,4,6],[4,8,4,9],[4,11,4,12],[4,14,4,15],[4,17,4,18],[5,2,5,3],[5,4,6,4],[5,5,5,6],[5,7,6,7],[5,8,5,9],[5,10,6,10],[5,11,5,12],[5,13,6,13],[5,14,5,15],[5,16,6,16],[5,17,5,18],[5,19,6,19],[6,2,6,3],[6,5,6,6],[6,8,6,9],[6,11,6,12],[6,14,6,15],[6,17,6,18],[9,1,9,3],[9,5,9,19],[10,1,10,3],[10,5,10,19],[12,2,12,3],[12,5,12,6],[12,8,12,9],[12,11,12,12],[12,14,12,15],[12,17,12,18],[13,2,13,3],[13,4,14,4],[13,5,13,6],[13,7,14,7],[13,8,13,9],[13,10,14,10],[13,11,13,12],[13,13,14,13],[13,14,13,15],[13,16,14,16],[13,17,13,18],[13,19,14,19],[14,2,14,3],[14,5,14,6],[14,8,14,9],[14,11,14,12],[14,14,14,15],[14,17,14,18],[16,2,16,4],[16,5,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,16],[16,17,16,19],[17,2,17,4],[17,5,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,16],[17,17,17,19],[18,2,18,4],[18,5,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,19]]}
[]
[null,"下半期 売上管理シート"]
[]
[null,"上半期 実績"]
[null,null,"売上（上代）",null,"差","売上（下代）",null,"差","来店客数",null,"差","客単価",null,"差","顧客数",null,"差","新規顧客数",null,"差"]
[null,"目　標",{"v":26000,"d":"26,000"},null,{"$f":"IFERROR(C7-C6,\"\")","v":{"v":-1600,"d":"-1,600.0 "}},{"v":20000,"d":"20,000"},null,{"$f":"IFERROR(F7-F6,\"\")","v":{"v":-3000,"d":"-3,000.0 "}},3500,null,{"$f":"IFERROR(I7-I6,\"\")","v":50},{"$f":"C6/O6","v":{"v":65,"d":"65.00"}},null,{"$f":"IFERROR(L7-L6,\"\")","v":{"v":4.714285714285708,"d":"4.7"}},400,null,{"$f":"IFERROR(O7-O6,\"\")","v":{"v":-50,"d":"-50 "}},400,null,{"$f":"IFERROR(R7-R6,\"\")","v":{"v":-50,"d":"-50 "}}]
[null,"実　績",{"v":24400,"d":"24,400"},null,null,{"v":17000,"d":"17,000"},null,null,3550,null,null,{"$f":"C7/O7","v":{"v":69.71428571428571,"d":"69.71"}},null,null,350,null,null,350]
[]
[null,"下半期 目標設定"]
[null,"下半期の目標",{"$nulls":3},"新規顧客獲得に重点を置く・客単価を上げる"]
[null,"行動計画",{"$nulls":3},"新規顧客向けのキャンペーン、セール企画・セット購入を促すような施策、コミュニケーション力アップ"]
[]
[null,null,"売上（上代）",null,"差","売上（下代）",null,"差","来店客数",null,"差","客単価",null,"差","顧客数",null,"差","新規顧客数",null,"差"]
[null,"目　標",{"v":26000,"d":"26,000"},null,{"$f":"IFERROR(C15-C14,\"\")","v":{"v":-25860,"d":"-25,860.0 "}},{"v":20000,"d":"20,000"},null,{"$f":"IFERROR(F15-F14,\"\")","v":{"v":-20000,"d":"-20,000.0 "}},3500,null,{"$f":"IFERROR(I15-I14,\"\")","v":{"v":-3454,"d":"-3454 "}},{"$f":"C14/O14","v":{"v":65,"d":"65.00"}},null,{"$f":"IFERROR(L15-L14,\"\")","v":{"v":-64.6100278551532,"d":"-64.6 "}},400,null,{"$f":"IFERROR(O15-O14,\"\")","v":{"v":-41,"d":"-41 "}},50,null,{"$f":"IFERROR(R15-R14,\"\")","v":{"v":-41,"d":"-41 "}}]
[null,"実　績",{"$f":"SUM(D21,G21,J21,M21,P21,S21)","v":140},{"$nulls":5},{"$f":"SUM(D22,G22,J22,M22,P22,S22)","v":46},null,null,{"$f":"C15/O15","v":{"v":0.38997214484679665,"d":"0.39"}},null,null,{"$f":"SUM(O7,R15)","v":359},null,null,{"$f":"SUM(D25,G25,J25,M25,P25,S25)","v":9}]
[]
[null,null,"7月",null,null,"8月",null,null,"9月",null,null,"10月",null,null,"11月",null,null,"12月"]
[null,"1ヶ月ごとの目標","新規顧客獲得 目標達成"]
[null,"具体的な行動計画","ご新規様キャンペーンを行う"]
[null,null,"目標","実績","差","目標","実績","差","目標","実績","差","目標","実績","差","目標","実績","差","目標","実績","差"]
[null,"売上（千円）",{"v":3000,"d":"3,000"},{"$f":"IF(実績入力表!AJ7=\"\",\"\",実績入力表!AJ7)","v":140},{"$f":"IFERROR(D21-C21,\"\")","v":{"v":-2860,"d":"-2,860.0 "}},null,{"$f":"実績入力表!AJ17","v":""},{"$f":"IFERROR(G21-F21,\"\")","v":""},null,{"$f":"実績入力表!AJ27","v":""},{"$f":"IFERROR(J21-I21,\"\")","v":""},null,{"$f":"実績入力表!AJ37","v":""},{"$f":"IFERROR(M21-L21,\"\")","v":""},null,{"$f":"実績入力表!AJ47","v":""},{"$f":"IFERROR(P21-O21,\"\")","v":""},null,{"$f":"実績入力表!AJ57","v":""},{"$f":"IFERROR(S21-R21,\"\")","v":""}]
[null,"来店客数（人）",500,{"$f":"IF(実績入力表!AJ9=\"\",\"\",実績入力表!AJ9)","v":46},{"$f":"IFERROR(D22-C22,\"\")","v":{"v":-454,"d":"-454 "}},null,{"$f":"実績入力表!AJ19","v":""},{"$f":"IFERROR(G22-F22,\"\")","v":""},null,{"$f":"実績入力表!AJ29","v":""},{"$f":"IFERROR(J22-I22,\"\")","v":""},null,{"$f":"実績入力表!AJ39","v":""},{"$f":"IFERROR(M22-L22,\"\")","v":""},null,{"$f":"実績入力表!AJ49","v":""},{"$f":"IFERROR(P22-O22,\"\")","v":""},null,{"$f":"実績入力表!AJ59","v":""},{"$f":"IFERROR(S22-R22,\"\")","v":""}]
[null,"客単価（千円）",{"$f":"IFERROR(C21/C24,\"\")","v":{"v":7.5,"d":"7.50"}},{"$f":"IFERROR(D21/D24,\"\")","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"IFERROR(D23-C23,\"\")","v":{"v":-4.166666666666666,"d":"-4.2 "}},{"$f":"IFERROR(F21/F24,\"\")","v":""},{"$f":"IFERROR(G21/G24,\"\")","v":""},{"$f":"IFERROR(G23-F23,\"\")","v":""},{"$f":"IFERROR(I21/I24,\"\")","v":""},{"$f":"IFERROR(J21/J24,\"\")","v":""},{"$f":"IFERROR(J23-I23,\"\")","v":""},{"$f":"IFERROR(L21/L24,\"\")","v":""},{"$f":"IFERROR(M21/M24,\"\")","v":""},{"$f":"IFERROR(M23-L23,\"\")","v":""},{"$f":"IFERROR(O21/O24,\"\")","v":""},{"$f":"IFERROR(P21/P24,\"\")","v":""},{"$f":"IFERROR(P23-O23,\"\")","v":""},{"$f":"IFERROR(R21/R24,\"\")","v":""},{"$f":"IFERROR(S21/S24,\"\")","v":""},{"$f":"IFERROR(S23-R23,\"\")","v":""}]
[null,"顧客数（人）",400,{"$f":"実績入力表!AJ13","v":42},{"$f":"IFERROR(D24-C24,\"\")","v":{"v":-358,"d":"-358 "}},null,{"$f":"実績入力表!AJ23","v":""},{"$f":"IFERROR(G24-F24,\"\")","v":""},null,{"$f":"実績入力表!AJ33","v":""},{"$f":"IFERROR(J24-I24,\"\")","v":""},null,{"$f":"実績入力表!AJ43","v":""},{"$f":"IFERROR(M24-L24,\"\")","v":""},null,{"$f":"実績入力表!AJ53","v":""},{"$f":"IFERROR(P24-O24,\"\")","v":""},null,{"$f":"実績入力表!AJ63","v":""},{"$f":"IFERROR(S24-R24,\"\")","v":""}]
[null,"新規顧客数（人）",300,{"$f":"IF(実績入力表!AJ15=\"\",\"\",実績入力表!AJ15)","v":9},{"$f":"IFERROR(D25-C25,\"\")","v":{"v":-291,"d":"-291 "}},null,{"$f":"実績入力表!AJ25","v":""},{"$f":"IFERROR(G25-F25,\"\")","v":""},null,{"$f":"実績入力表!AJ35","v":""},{"$f":"IFERROR(J25-I25,\"\")","v":""},null,{"$f":"実績入力表!AJ45","v":""},{"$f":"IFERROR(M25-L25,\"\")","v":""},null,{"$f":"実績入力表!AJ55","v":""},{"$f":"IFERROR(P25-O25,\"\")","v":""},null,{"$f":"実績入力表!AJ65","v":""},{"$f":"IFERROR(S25-R25,\"\")","v":""}]

{"sheet":"実績入力表","index":2,"n_rows":65,"n_cols":36,"rows_kept":65,"merged":[[1,1,2,2],[4,1,4,3],[5,1,14,1],[5,2,6,2],[7,2,8,2],[9,2,10,2],[11,2,12,2],[13,2,14,2],[15,1,24,1],[15,2,16,2],[17,2,18,2],[19,2,20,2],[21,2,22,2],[23,2,24,2],[25,1,34,1],[25,2,26,2],[27,2,28,2],[29,2,30,2],[31,2,32,2],[33,2,34,2],[35,1,44,1],[35,2,36,2],[37,2,38,2],[39,2,40,2],[41,2,42,2],[43,2,44,2],[45,1,54,1],[45,2,46,2],[47,2,48,2],[49,2,50,2],[51,2,52,2],[53,2,54,2],[55,1,64,1],[55,2,56,2],[57,2,58,2],[59,2,60,2],[61,2,62,2],[63,2,64,2]]}
[]
[null,"月別　　　実績入力表"]
[{"$nulls":35},"単位（売上、客単価：千円　来店客数、顧客数、新規顧客数：人）"]
[]
[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,"月合計"]
[null,"7  月","売上","目標",30,30,50,20,25,{"$nulls":26},{"$f":"IF(E6=\"\",\"\",SUM(E6:AI6))","v":155}]
[{"$nulls":3},"実績",30,30,40,20,20,{"$nulls":26},{"$f":"IF(E7=\"\",\"\",SUM(E7:AI7))","v":140}]
[null,null,"来店客数","目標",10,8,25,5,6,{"$nulls":26},{"$f":"IF(E8=\"\",\"\",SUM(E8:AI8))","v":54}]
[{"$nulls":3},"実績",10,9,15,6,6,{"$nulls":26},{"$f":"IF(E9=\"\",\"\",SUM(E9:AI9))","v":46}]
[null,null,"客単価","目標",{"$f":"IFERROR(E6/E12,\"\")","v":{"v":3,"d":"3.00"}},{"$f":"IFERROR(F6/F12,\"\")","v":3.75},{"$f":"IFERROR(G6/G12,\"\")","v":{"v":2,"d":"2.00"}},{"v":4,"d":"4.00"},{"v":4.166666666666667,"d":"4.17"},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E10:AI10)/COUNT(E10:AI10),\"\")","v":{"v":3.3833333333333337,"d":"3.38"}}]
[{"$nulls":3},"実績",{"$f":"IFERROR(E7/E13,\"\")","v":{"v":3,"d":"3.00"}},{"$f":"IFERROR(F7/F13,\"\")","v":3.75},{"v":3.076923076923077,"d":"3.08"},{"v":3.3333333333333335,"d":"3.33"},{"v":4,"d":"4.00"},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E11:AI11)/COUNT(E11:AI11),\"\")","v":{"v":3.432051282051282,"d":"3.43"}}]
[null,null,"顧客数","目標",10,8,25,5,6,{"$nulls":26},{"$f":"IF(E12=\"\",\"\",SUM(E12:AI12))","v":54}]
[{"$nulls":3},"実績",10,8,13,6,5,{"$nulls":26},{"$f":"IF(E13=\"\",\"\",SUM(E13:AI13))","v":42}]
[null,null,"新規顧客","目標",2,2,5,1,2,{"$nulls":26},{"$f":"IF(E14=\"\",\"\",SUM(E14:AI14))","v":12}]
[{"$nulls":3},"実績",1,2,4,1,1,{"$nulls":26},9]
[null,"8  月","売上","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"来店客数","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"客単価","目標",{"$f":"IFERROR(E16/E22,\"\")","v":""},{"$f":"IFERROR(F16/F22,\"\")","v":""},{"$f":"IFERROR(G16/G22,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E20:AI20)/COUNT(E20:AI20),\"\")","v":""}]
[{"$nulls":3},"実績",{"$f":"IFERROR(E17/E23,\"\")","v":""},{"$f":"IFERROR(F17/F23,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E21:AI21)/COUNT(E21:AI21),\"\")","v":""}]
[null,null,"顧客数","目標",{"$nulls":31},{"$f":"IF(E22=\"\",\"\",SUM(E22:AI22))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},{"$f":"IF(E23=\"\",\"\",SUM(E23:AI23))","v":""}]
[null,null,"新規顧客","目標",{"$nulls":31},{"$f":"IF(E24=\"\",\"\",SUM(E24:AI24))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,"9  月","売上","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"来店客数","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"客単価","目標",{"$f":"IFERROR(E26/E32,\"\")","v":""},{"$f":"IFERROR(F26/F32,\"\")","v":""},{"$f":"IFERROR(G26/G32,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"IFERROR(SUM(E30:AI30)/COUNT(E30:AI30),\"\")","v":""}]
[{"$nulls":3},"実績",{"$f":"IFERROR(E27/E33,\"\")","v":""},{"$f":"IFERROR(F27/F33,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"IFERROR(SUM(E31:AI31)/COUNT(E31:AI31),\"\")","v":""}]
[null,null,"顧客数","目標",{"$nulls":31},{"$f":"IF(E32=\"\",\"\",SUM(E32:AI32))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},{"$f":"IF(E33=\"\",\"\",SUM(E33:AI33))","v":""}]
[null,null,"新規顧客","目標",{"$nulls":31},{"$f":"IF(E34=\"\",\"\",SUM(E34:AI34))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,"10月","売上","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"来店客数","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"客単価","目標",{"$f":"IFERROR(E36/E42,\"\")","v":""},{"$f":"IFERROR(F36/F42,\"\")","v":""},{"$f":"IFERROR(G36/G42,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E40:AI40)/COUNT(E40:AI40),\"\")","v":""}]
[{"$nulls":3},"実績",{"$f":"IFERROR(E37/E43,\"\")","v":""},{"$f":"IFERROR(F37/F43,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E41:AI41)/COUNT(E41:AI41),\"\")","v":""}]
[null,null,"顧客数","目標",{"$nulls":31},{"$f":"IF(E42=\"\",\"\",SUM(E42:AI42))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},{"$f":"IF(E43=\"\",\"\",SUM(E43:AI43))","v":""}]
[null,null,"新規顧客","目標",{"$nulls":31},{"$f":"IF(E44=\"\",\"\",SUM(E44:AI44))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,"11月","売上","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"来店客数","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"客単価","目標",{"$f":"IFERROR(E46/E52,\"\")","v":""},{"$f":"IFERROR(F46/F52,\"\")","v":""},{"$f":"IFERROR(G46/G52,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"IFERROR(SUM(E50:AI50)/COUNT(E50:AI50),\"\")","v":""}]
[{"$nulls":3},"実績",{"$f":"IFERROR(E47/E53,\"\")","v":""},{"$f":"IFERROR(F47/F53,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"IFERROR(SUM(E51:AI51)/COUNT(E51:AI51),\"\")","v":""}]
[null,null,"顧客数","目標",{"$nulls":31},{"$f":"IF(E52=\"\",\"\",SUM(E52:AI52))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},{"$f":"IF(E53=\"\",\"\",SUM(E53:AI53))","v":""}]
[null,null,"新規顧客","目標",{"$nulls":31},{"$f":"IF(E54=\"\",\"\",SUM(E54:AI54))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,"12月","売上","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"来店客数","目標",{"$nulls":31},""]
[{"$nulls":3},"実績",{"$nulls":31},""]
[null,null,"客単価","目標",{"$f":"IFERROR(E56/E62,\"\")","v":""},{"$f":"IFERROR(F56/F62,\"\")","v":""},{"$f":"IFERROR(G56/G62,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E60:AI60)/COUNT(E60:AI60),\"\")","v":""}]
[{"$nulls":3},"実績",{"$f":"IFERROR(E57/E63,\"\")","v":""},{"$f":"IFERROR(F57/F63,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(SUM(E61:AI61)/COUNT(E61:AI61),\"\")","v":""}]
[null,null,"顧客数","目標",{"$nulls":31},{"$f":"IF(E62=\"\",\"\",SUM(E62:AI62))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},{"$f":"IF(E63=\"\",\"\",SUM(E63:AI63))","v":""}]
[null,null,"新規顧客","目標",{"$nulls":31},{"$f":"IF(E64=\"\",\"\",SUM(E64:AI64))","v":""}]
[{"$nulls":3},"実績",{"$nulls":31},{"$f":"IF(E65=\"\",\"\",SUM(E65:AI65))","v":""}]