{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["10月销售数据","9月销售数据","8月销售数据","7月销售数据","6月销售数据","5月活动数据","5月销售跟踪","4月销售跟踪","Sheet2","Sheet4","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"10月销售数据","index":0,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,2,1,4],[1,5,1,8],[0,9,0,17],[1,11,1,13],[1,14,1,17]]}
["           新都区新泰西路店 店销售跟踪报表",null,null,null,null,null,null,null,null,"           新都区新泰西路店 店中药销售跟踪报表"]
[null,null,"当天销售情况",null,null,"累积销售情况",null,null,null,null,null,"当天销售情况",null,null,"累积销售情况"]
["日期","天数","销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额","日期","天数","销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013.09.26",1,1266,787.7,{"$f":"D4-C4","v":-478.29999999999995},787.7,787.7,-478.3,-478.3,"2013.09.26",1,100,27,{"$f":"M4-L4","v":-73},27,27,-73,-73]
["2013.09.27",2,1266,965.87,-300.13,{"$f":"F4+D5","v":1753.5700000000002},{"$f":"F5/2","v":876.78500000000008},{"$f":"G5-C5","v":-389.21499999999992},{"$f":"H5*2","v":-778.42999999999984},"2013.09.27",2,100,0,-100,27,{"$f":"O5/2","v":13.5},{"$f":"P5-L5","v":-86.5},{"$f":"Q5*2","v":-173}]
["2013.09.28",3,1266,1667.6,401.59999999999991,3421.17,{"$f":"F6/3","v":1140.3900000000001},-125.6099999999999,{"$f":"H6*3","v":-376.8299999999997},"2013.09.28",3,100,25.6,-74.400000000000006,{"$f":"O5+M6","v":52.6},{"$f":"O6/3","v":17.533333333333335},{"$f":"P6-L6","v":-82.466666666666669},{"$f":"Q6*3","v":-247.4}]
["2013.09.29",4,1266,1529.5,263.5,4950.67,{"$f":"F7/4","v":1237.6675},-28.332499999999982,{"$f":"H7*B7","v":-113.32999999999993},"2013.09.29",4,100,25,-75,{"$f":"O6+M7","v":77.599999999999994},{"$f":"O7/4","v":19.399999999999999},{"$f":"P7-L7","v":-80.599999999999994},{"$f":"Q7*4","v":-322.39999999999998}]
["2013.09.30",5,1266,2517.8000000000002,1251.8000000000002,7468.47,{"$f":"F8/5","v":1493.694},227.69399999999996,{"$f":"H8*K8","v":1138.4699999999998},"2013.09.30",5,100,39.299999999999997,-60.7,{"$f":"O7+M8","v":116.89999999999999},{"$f":"O8/K8","v":23.38},{"$f":"P8-L8","v":-76.62},{"$f":"Q8*K8","v":-383.1}]
["2013.10.01",6,1266,1369.2,103.20000000000005,8837.67,{"$f":"F9/K9","v":1472.9449999999999},206.94499999999994,1241.6699999999996,"2013.10.01",6,100,123.6,23.599999999999994,{"$f":"O8+M9","v":240.5},{"$f":"O9/K9","v":40.083333333333336},{"$f":"P9-L9","v":-59.916666666666664},{"$f":"Q9*K9","v":-359.5}]
["2013.10.02",7,1266,1521.32,255.31999999999994,10358.99,{"$f":"F10/K10","v":1479.8557142857142},213.85571428571416,1496.9899999999991,"2013.10.02",7,100,0,-100,240.5,{"$f":"O10/K10","v":34.357142857142854},{"$f":"P10-100","v":-65.642857142857139},{"$f":"Q10*K10","v":-459.5}]
["2013.10.03",8,1266,629.79999999999995,-636.20000000000005,{"$f":"F10+D11","v":10988.789999999999},{"$f":"F11/K11","v":1373.5987499999999},{"$f":"G11-C11","v":107.59874999999988},860.78999999999905,"2013.10.03",8,100,0,-100,240.5,{"$f":"O11/K11","v":30.0625},{"$f":"P11-100","v":-69.9375},{"$f":"Q11*8","v":-559.5}]
["2013.10.04",9,1266,1100.52,-165.48000000000002,{"$f":"F11+D12","v":12089.31},{"$f":"F12/'10月销售数据'!B12","v":1343.2566666666667},{"$f":"G12-C12","v":77.256666666666661},695.31,"2013.10.04",9,100,52.7,-47.3,{"$f":"O11+M12","v":293.2},{"$f":"O12/9","v":32.577777777777776},{"$f":"P12-L12","v":-67.422222222222217},{"$f":"Q12*9","v":-606.79999999999995}]
["2013.10.05",10,1266,2057.62,791.61999999999989,{"$f":"F12+D13","v":14146.93},{"$f":"F13/B13","v":1414.693},{"$f":"G13-C13","v":148.69299999999998},1486.9299999999998,"2013.10.05",10,100,0,-100,{"$f":"O12+M13","v":293.2},{"$f":"O13/K13","v":29.32},{"$f":"P13-L13","v":-70.680000000000007},{"$f":"Q13*10","v":-706.80000000000007}]
["2013.10.06",11,1266,905.48,-360.52,15052.41,1368.4009000000001,102.401,1126.4110000000001,"2013.10.06",11,100,44.17,-55.83,337.37,30.67,-69.33,-762.63]
["2013.10.07",12,1266,790.3,-475.7,15842.71,1320.2257999999999,54.225999999999999,650.71199999999999,"2013.10.07",12,100,118,18,455.37,37.947499999999998,-62.052500000000002,-744.63]
["2013.10.08",13,1266,1399.3,{"$f":"D16-C16","v":133.29999999999995},{"$f":"F15+D16","v":17242.009999999998},{"$f":"F16/B16","v":1326.3084615384614},{"$f":"G16-C16","v":60.308461538461415},{"$f":"H16*13","v":784.0099999999984},"2013.10.08",13,100,35,{"$f":"M16-L16","v":-65},{"$f":"O15+M16","v":490.37},{"$f":"O16/K16","v":37.720769230769228},{"$f":"P16-L16","v":-62.279230769230772},{"$f":"Q16*K16","v":-809.63}]
["2013.10.09",14,1266,1274.73,{"$f":"D17-C17","v":8.7300000000000182},{"$f":"F16+D17","v":18516.739999999998},{"$f":"F17/B17","v":1322.6242857142856},{"$f":"G17-C17","v":56.624285714285634},{"$f":"H17*B17","v":792.73999999999887},"2013.10.09",14,100,28.3,{"$f":"M17-L17","v":-71.7},{"$f":"O16+M17","v":518.66999999999996},{"$f":"O17/K17","v":37.04785714285714},{"$f":"P17-L17","v":-62.95214285714286},{"$f":"Q17*K17","v":-881.33}]
["2013.10.10",15,1266,null,null,null,null,null,null,"2013.10.10",15,100]
["2013.10.11",16,1266,null,null,null,null,null,null,"2013.10.11",16,100]
["2013.10.12",17,1266,null,null,null,null,null,null,"2013.10.12",17,100]
["2013.10.13",18,1266,null,null,null,null,null,null,"2013.10.13",18,100]
["2013.10.14",19,1266,null,null,null,null,null,null,"2013.10.14",19,100]
["2013.10.15",20,1266,null,null,null,null,null,null,"2013.10.15",20,100]
["2013.10.16",21,1266,null,null,null,null,null,null,"2013.10.16",21,100]
["2013.10.17",22,1266,null,null,null,null,null,null,"2013.10.17",22,100]
["2013.10.18",23,1266,null,null,null,null,null,null,"2013.10.18",23,100]
["2013.10.19",24,1266,null,null,null,null,null,null,"2013.10.19",24,100]
["2013.10.20",25,1266,null,null,null,null,null,null,"2013.10.20",25,100]
["2013.10.21",26,1266,null,null,null,null,null,null,"2013.10.21",26,100]
["2013.10.22",27,1266,null,null,null,null,null,null,"2013.10.22",27,100]
["2013.10.23",28,1266,null,null,null,null,null,null,"2013.10.23",28,100]
["2013.10.24",29,1266,null,null,null,null,null,null,"2013.10.24",29,100]
["2013.10.25",30,1266,null,null,null,null,null,null,"2013.10.25",30,100]
["2013.10.26",31,1266,null,null,null,null,null,null,"2013.10.26",31,100]

{"sheet":"9月销售数据","index":1,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,2,1,4],[1,5,1,8]]}
["           新都区新泰西路店 店销售跟踪报表"]
[null,null,"当天销售情况",null,null,"累积销售情况"]
["日期","天数","销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013-08-26",1,1226,700.7,{"$f":"D4-C4","v":-525.29999999999995},700.7,700.7,-525.29999999999995,-525.29999999999995]
["2013-08-27",2,1226,871.4,-354.6,{"$f":"F4+D5","v":1572.1},{"$f":"F5/2","v":786.05},{"$f":"G5-C5","v":-439.95000000000005},{"$f":"H5*2","v":-879.90000000000009}]
["2013-08-28",3,1226,708.23,-517.77,2280.33,{"$f":"F6/3","v":760.11},-465.89,{"$f":"H6*3","v":-1397.67}]
["2013-08-29",4,1226,1369.9,143.90000000000009,3650.23,{"$f":"F7/4","v":912.5575},-313.4425,{"$f":"H7*4","v":-1253.77}]
["2013-08-30",5,1226,1104.8,-121.20000000000005,4755.03,{"$f":"F8/5","v":951.00599999999997},-274.99400000000003,{"$f":"H8*5","v":-1374.9700000000003}]
["2013-08-31",6,1226,1684,458,6439.03,{"$f":"F9/6","v":1073.1716666666666},-152.82833333333338,{"$f":"H9*6","v":-916.97000000000025}]
["2013-09-01",7,1226,1338.61,112.6099999999999,7777.6399999999994,{"$f":"F10/7","v":1111.0914285714284},-114.90857142857158,{"$f":"H10*7","v":-804.36000000000104}]
["2013-09-02",8,1226,915.4,-310.60000000000002,8693.0399999999991,{"$f":"F11/8","v":1086.6299999999999},-139.37000000000012,{"$f":"H11*8","v":-1114.9600000000009}]
["2013-09-03",9,1226,1084.8,-141.20000000000005,9777.8399999999983,{"$f":"F12/9","v":1086.4266666666665},-139.57333333333349,{"$f":"H12*9","v":-1256.1600000000014}]
["2013-09-04",10,1226,992.33,-233.66999999999996,10770.169999999998,{"$f":"F13/10","v":1077.0169999999998},-148.98300000000017,{"$f":"H13*10","v":-1489.8300000000017}]
["2013-09-05",11,1226,1473.6,247.59999999999991,12243.769999999999,{"$f":"F14/11","v":1113.07},-112.93000000000006,{"$f":"H14*11","v":-1242.2300000000007}]
["2013-09-06",12,1226,1538.9,312.90000000000009,13782.669999999998,{"$f":"F15/12","v":1148.5558333333331},-77.444166666666888,{"$f":"H15*12","v":-929.33000000000266}]
["2013-09-07",13,1226,1171.7,-54.299999999999955,14954.369999999999,{"$f":"F16/13","v":1150.3361538461538},-75.66384615384618,{"$f":"H16*13","v":-983.63000000000034}]
["2013-09-08",14,1226,1304.49,78.490000000000009,16258.859999999999,{"$f":"F17/14","v":1161.3471428571427},-64.652857142857329,{"$f":"H17*14","v":-905.1400000000026}]
["2013-09-09",15,1226,617.1,-608.9,16875.96,{"$f":"F18/15","v":1125.0639999999999},-100.93600000000015,{"$f":"H18*15","v":-1514.0400000000022}]
["2013-09-10",16,1226,904,-322,17779.96,{"$f":"F19/16","v":1111.2474999999999},-114.75250000000005,{"$f":"H19*16","v":-1836.0400000000009}]
["2013-09-11",17,1226,813.42,{"$f":"D20-C21","v":-412.58000000000004},18593.379999999997,{"$f":"F20/17","v":1093.7282352941174},-132.27176470588256,{"$f":"H20*17","v":-2248.6200000000035}]
["2013-09-12",18,1226,1576.1,{"$f":"D21-C21","v":350.09999999999991},20169.479999999996,{"$f":"F21/18","v":1120.5266666666664},-105.47333333333358,{"$f":"H21*18","v":-1898.5200000000045}]
["2013-09-13",19,1226,2316.9,1090.9000000000001,22486.379999999997,{"$f":"F22/19","v":1183.4936842105262},-42.506315789473774,{"$f":"H22*19","v":-807.62000000000171}]
["2013-09-14",20,1226,959.6,-266.39999999999998,23445.979999999996,{"$f":"F23/20","v":1172.2989999999998},-53.701000000000249,{"$f":"H23*20","v":-1074.020000000005}]
["2013-09-15",21,1226,516.6,-709.4,23962.579999999994,{"$f":"F24/21","v":1141.0752380952379},-84.924761904762136,{"$f":"H24*21","v":-1783.4200000000048}]
["2013-09-16",22,1226,2738.25,1512.25,26700.829999999994,{"$f":"F25/22","v":1213.6740909090906},-12.325909090909363,{"$f":"H25*22","v":-271.17000000000598}]
["2013-09-17",23,1226,2934,1708,29634.829999999994,{"$f":"F26/23","v":1288.4708695652171},62.470869565217072,{"$f":"H26*23","v":1436.8299999999927}]
["2013-09-18",24,1226,1693.92,{"$f":"D27-C27","v":467.92000000000007},31328.75,1305.364,79.364000000000004,1904.7360000000001]
["2013-09-19",25,1226,1080.8,-145.20000000000005,{"$f":"F27+D28","v":32409.55},{"$f":"F28/B28","v":1296.3820000000001},{"$f":"G28-C28","v":70.382000000000062},{"$f":"H28*B28","v":1759.5500000000015}]
["2013-09-20",26,1226,927.1,-298.89999999999998,{"$f":"F28+D29","v":33336.65},{"$f":"F29/B29","v":1282.1788461538463},{"$f":"G29-C29","v":56.17884615384628},{"$f":"H29*B29","v":1460.6500000000033}]
["2013-09-21",27,1226,2190.0500000000002,964.05000000000018,{"$f":"F29+D30","v":35526.700000000004},{"$f":"F30/B30","v":1315.8037037037038},89.804000000000002,2424.7080000000001]
["2013-09-22",28,1226,1175.54,-50.460000000000036,36702.239999999998,1310.7940000000001,46.814,1310.7919999999999]
["2013-09-23",29,1226,949.7,-276.29999999999995,{"$f":"F31+D32","v":37651.939999999995},{"$f":"F32/29","v":1298.3427586206894},{"$f":"G32-C32","v":72.342758620689438},{"$f":"H32*B32","v":2097.9399999999937}]
["2013-09-24",30,1226,2914.6,1688.6,{"$f":"F32+D33","v":40566.539999999994},{"$f":"F33/B33","v":1352.2179999999998},{"$f":"G33-C33","v":126.21799999999985},{"$f":"H33*B33","v":3786.5399999999954}]
["2013-09-25",31,1226,1671.23,445.23,42237.77,1362.508,136.50800000000001,4231.7479999999996]
[null,32,1226]

{"sheet":"8月销售数据","index":2,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,2,0],[1,1,2,1],[1,2,1,4],[1,5,1,8],[48,0,48,9],[44,0,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,9]]}
["           新都区新泰西路店 店销售跟踪报表"]
["日期","天数","当天销售情况",null,null,"累积销售情况"]
[null,null,"销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013-07-26",1,1100,617.1,-482.9,617.1,617.1,-482.9,-482.9]
["2013-07-27",{"$f":"B4+1","v":2},1100,520.87,-579.13,1137.97,568.98500000000001,-531.01499999999999,-1062.03]
["2013-07-28",{"$f":"B5+1","v":3},1100,744.64,{"$f":"D6-C6","v":-355.36},{"$f":"F5+D6","v":1882.6100000000001},{"$f":"F6/3","v":627.53666666666675},{"$f":"G6-C6","v":-472.46333333333325},{"$f":"H6*3","v":-1417.3899999999999}]
["2013-07-29",4,1100,743.84,-356.16,2626.45,656.61249999999995,-443.38749999999999,-1773.55]
["2013-07-30",5,1100,614.1,{"$f":"D8-C8","v":-485.9},{"$f":"F7+D8","v":3240.5499999999997},{"$f":"F8/B8","v":648.1099999999999},{"$f":"G8-C8","v":-451.8900000000001},{"$f":"H8*B8","v":-2259.4500000000007}]
["2013-07-31",6,1100,544.87,-555.13,3785.4199999999996,{"$f":"F9/B9","v":630.90333333333331},-469.09666666666669,-2814.58]
["2013-08-01",7,1100,1309.5999999999999,209.59999999999991,5095.0199999999995,{"$f":"F10/7","v":727.8599999999999},-372.1400000000001,-2604.9800000000005]
["2013-08-02",8,1100,864.6,-235.39999999999998,5959.62,{"$f":"F11/B11","v":744.95249999999999},-355.04750000000001,-2840.38]
["2013-08-03",9,1100,1019.22,-80.779999999999973,6978.84,775.42666666666673,-324.57333333333327,-2921.1599999999994]
["2013-08-04",10,1100,1159.23,59.230000000000018,8138.07,813.80700000000002,-286.19299999999998,-2861.93]
["2013-08-05",11,1100,761.8,-338.20000000000005,{"$f":"D14+F13","v":8899.869999999999},809.07909090909084,-290.92090909090916,-3200.130000000001]
["2013-08-06",12,1100,578.9,-521.1,{"$f":"D15+F14","v":9478.7699999999986},789.89749999999992,-310.10250000000008,-3721.2300000000009]
["2013-08-07",13,1100,1518.49,418.49,{"$f":"F15+D16","v":10997.259999999998},845.94307692307677,-254.05692307692323,-3302.7400000000021]
["2013-08-08",14,1100,1097.5999999999999,-2.4000000000000909,{"$f":"F16+D17","v":12094.859999999999},{"$f":"F17/B17","v":863.91857142857134},-236.08142857142866,-3305.1400000000012]
["2013-08-09",15,1100,860.26,-239.74,{"$f":"F17+D18","v":12955.119999999999},{"$f":"F18/B18","v":863.67466666666655},-236.32533333333345,-3544.8800000000019]
["2013-08-10",16,1100,710,-390,{"$f":"F18+D19","v":13665.119999999999},{"$f":"F19/B19","v":854.06999999999994},-245.93000000000006,-3934.880000000001]
["2013-08-11",17,1100,1173.6400000000001,73.64,14838.76,872.88800000000003,-227.11199999999999,-3860.904]
["2013-08-12",18,1100,556.5,{"$f":"D21-C21","v":-543.5},{"$f":"F20+D21","v":15395.26},{"$f":"F21/B21","v":855.29222222222222},{"$f":"G21-C21","v":-244.70777777777778},{"$f":"H21*B21","v":-4404.74}]
["2013-08-13",19,1100,2210.3000000000002,1110.3000000000002,17605.560000000001,926.60842105263168,-173.39157894736832,-3294.4399999999978]
["2013-08-14",20,1100,1459.53,359.53,19065.09,953.25450000000001,-146.74549999999999,-2934.91]
["2013-08-15",21,1100,710.47,-389.53,19775.560000000001,941.69333333333338,-158.30666666666662,-3324.4399999999987]
["2013-08-16",{"$f":"B24+1","v":22},1100,1583.5,483.5,21359.06,970.86636363636364,-129.13363636363636,-2840.9399999999996]
["2013-08-17",23,1100,840.28,-259.72000000000003,22199.34,965.18869565217392,-134.81130434782608,-3100.66]
["2013-08-18",24,1100,960.48,-139.51999999999998,{"$f":"F26+D27","v":23159.82},964.99249999999995,-135.00750000000005,-3240.1800000000012]
["2013-08-19",25,1100,926.7,-173.29999999999995,{"$f":"F27+D28","v":24086.52},963.46080000000006,-136.53919999999994,-3413.4799999999987]
["2013-08-20",26,1100,1222.8,122.79999999999995,25309.32,973.43499999999995,-126.565,-3290.69]
["2013-08-21",27,1100,819.43,-280.57000000000005,{"$f":"F29+D30","v":26128.75},{"$f":"F30/27","v":967.73148148148152},{"$f":"G30-C30","v":-132.26851851851848},{"$f":"H30*B30","v":-3571.2499999999991}]
["2013-08-22",28,1100,686.7,-413.29999999999995,{"$f":"F30+D31","v":26815.45},{"$f":"F31/B31","v":957.69464285714287},{"$f":"G31-C31","v":-142.30535714285713},{"$f":"H31*B31","v":-3984.5499999999997}]
["2013-08-23",29,1100,1141.3,41.299999999999955,27956.75,964.0258,-135.9742,-3943.2518]
["2013-08-24",30,1100,1185.71,85.710000000000036,{"$f":"F32+D33","v":29142.46},{"$f":"F33/B33","v":971.41533333333325},{"$f":"G33-C33","v":-128.58466666666675},{"$f":"H33*B33","v":-3857.5400000000027}]
["2013-08-25",31,1100,1259.99,159.99,{"$f":"F33+D34","v":30402.45},{"$f":"F34/B34","v":980.72419354838712},{"$f":"G34-C34","v":-119.27580645161288},{"$f":"H34*B34","v":-3697.5499999999993}]
[]
["汇总",null,"/","/","/"]
[]
["当天差距金额",null,"＝当天实际销售-当天销售目标"]
["累积总销售",null,"＝1月14日至当天的总销售"]
["累积日均销售",null,"＝累积总销售/天数"]
["日均差距金额",null,"＝累积日均销售-当天销售目标"]
["总差距金额",null,"＝日均差距金额*天数"]
[]
[]
["1、每天晚上下班后安排人员填写门店日销及员工日销报表"]
["2、每天在早会时向每一个员工通报前天的门店及员工销售日报，并传达当天每个员工的销售任务。下午接班的班组在上岗前开会小会学习后再上岗。"]
["3、两个报表需每天上午9：00以前报片区，片区于9：30以前报营业部。周末因要做广场活动可不报"]
["4、两个报表需挂在员工休息区或是办公室等能让员工都看到的地方，但注意不要挂在顾客轻易能看到的地方。"]
["5、每一个员工必须清楚了解自已当班的销售任务及自已当天与累积的差距金额，营业部每天均会安排人员进行电话抽查，对于不清楚的员工，处罚30元/次。若是店长原因，则只处罚店长。"]

{"sheet":"7月销售数据","index":3,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,9],[44,0,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,9],[0,0,0,8],[1,0,2,0],[1,1,2,1],[1,2,1,4],[1,5,1,8]]}
["           新都区新泰西路店 店销售跟踪报表"]
["日期","天数","当天销售情况",null,null,"累积销售情况"]
[null,null,"销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013-06-26",1,1100,888.3,-211.7,888.3,888.3,-211.7,-211.7]
["2013-06-27",{"$f":"B4+1","v":2},1100,751.42,{"$f":"D5-C5","v":-348.58000000000004},{"$f":"D5+D4","v":1639.7199999999998},{"$f":"F5/2","v":819.8599999999999},{"$f":"G5-C5","v":-280.1400000000001},{"$f":"H5*2","v":-560.2800000000002}]
["2013-06-28",{"$f":"B5+1","v":3},1100,480.22,-619.78,{"$f":"F5+D6","v":2119.9399999999996},{"$f":"F6/3","v":706.64666666666653},-393.35333333333347,{"$f":"H6*3","v":-1180.0600000000004}]
["2013-06-29",4,1100,726.09,-373.90999999999997,{"$f":"F6+D7","v":2846.0299999999997},{"$f":"F7/4","v":711.50749999999994},-388.49250000000006,{"$f":"H7*4","v":-1553.9700000000003}]
["2013-06-30",5,1100,616.04999999999995,-483.95000000000005,{"$f":"F7+D8","v":3462.08},{"$f":"F8/5","v":692.41599999999994},-407.58400000000006,{"$f":"H8*5","v":-2037.9200000000003}]
["2013-07-01",6,1100,1177.5,77.5,{"$f":"F8+D9","v":4639.58},{"$f":"F9/6","v":773.26333333333332},-326.73666666666668,{"$f":"H9*6","v":-1960.42}]
["2013-07-02",7,1100,939,-161,{"$f":"D10+F9","v":5578.58},{"$f":"F10/7","v":796.93999999999994},-303.06000000000006,{"$f":"H10*7","v":-2121.4200000000005}]
["2013-07-03",8,1100,1880.18,780.18000000000006,{"$f":"F10+D11","v":7458.76},{"$f":"F11/8","v":932.34500000000003},{"$f":"G11-C11","v":-167.65499999999997},{"$f":"H11*8","v":-1341.2399999999998}]
["2013-07-04",9,1100,3986.28,2886.28,{"$f":"D12+F11","v":11445.04},{"$f":"F12/9","v":1271.6711111111113},{"$f":"G12-C12","v":171.67111111111126},{"$f":"H12*9","v":1545.0400000000013}]
["2013-07-05",10,1100,633.1,-466.9,{"$f":"F12+D13","v":12078.140000000001},{"$f":"F13/10","v":1207.8140000000001},{"$f":"G13-C13","v":107.81400000000008},{"$f":"H13*10","v":1078.1400000000008}]
["2013-07-06",11,1100,1495,395,{"$f":"F13+D14","v":13573.140000000001},1291.1945000000001,191.19450000000001,2103.1390000000001]
["2013-07-07",12,1100,1426.43,326.43000000000006,{"$f":"D15+F14","v":14999.570000000002},{"$f":"F15/12","v":1249.9641666666669},{"$f":"G15-C15","v":149.96416666666687},{"$f":"H15*12","v":1799.5700000000024}]
["2013-07-08",13,1100,528.25,-571.75,15527.82,1194.4478899999999,94.447689999999994,1227.81999]
["2013-07-09",14,1100,620.5,{"$f":"D17-C17","v":-479.5},16148.32,1153.4514200000001,53.451419999999999,748.31988000000001]
["2013-07-10",15,1100,862.85,-237.14999999999998,{"$f":"F17+D18","v":17011.169999999998},{"$f":"F18/15","v":1134.078},{"$f":"G18-C18","v":34.077999999999975},{"$f":"H18*B18","v":511.16999999999962}]
["2013-07-11",16,1100,787.4,-312.60000000000002,17798.55,1112.4093,12.4093,198.55]
["2013-07-12",17,1100,932.9,-167.10000000000002,18731.45,1101.8499999999999,1.85,31.45]
["2013-07-13",18,1100,1303.5999999999999,203.59999999999991,20035.05,1113.0582999999999,13.058299999999999,235.04939999999999]
["2013-07-14",19,1100,1137.8900000000001,37.8900000000001,21172.94,1114.3652,14.3652,272.939999]
["2013-07-15",20,1100,1446,346,{"$f":"F22+D23","v":22618.94},{"$f":"F23/20","v":1130.9469999999999},{"$f":"G23-C23","v":30.946999999999889},{"$f":"H23*B23","v":618.93999999999778}]
["2013-07-16",21,1100,1452,352,{"$f":"F23+D24","v":24070.94},{"$f":"F24/B24","v":1146.2352380952379},{"$f":"G24-C24","v":46.235238095237946},{"$f":"H24*B24","v":970.93999999999687}]
["2013-07-17",{"$f":"B24+1","v":22},1100,1302.3499999999999,202.35,25373.29,1153.3312599999999,53.33126,1173.28772]
["2013-07-18",23,1100,867.9,-232.1,26241.19,1140.5213000000001,40.521299999999997,931.98990000000003]
["2013-07-19",24,1100,889.45,{"$f":"D27-C27","v":-210.54999999999995},{"$f":"F26+D27","v":27130.639999999999},{"$f":"F27/B27","v":1130.4433333333334},{"$f":"G27-C27","v":30.443333333333385},{"$f":"H27*24","v":730.64000000000124}]
["2013-07-20",25,1100,597.91,502.09,27728.55,1109.1420000000001,9.1419999999999995,228.55]
["2013-07-21",26,1100,468.66,{"$f":"D29-C29","v":-631.33999999999992},{"$f":"F28+D29","v":28197.21},{"$f":"F29/26","v":1084.5080769230769},{"$f":"G29-C29","v":-15.491923076923058},{"$f":"H29*26","v":-402.78999999999951}]
["2013-07-22",27,1100,1165.6400000000001,{"$f":"D30-C30","v":65.6400000000001},{"$f":"F29+D30","v":29362.85},{"$f":"F30/27","v":1087.512962962963},{"$f":"G30-C30","v":-12.487037037036998},{"$f":"H30*B30","v":-337.14999999999895}]
["2013-07-23",28,1100,734.3,-365.7,30097.15,1074.8982000000001,-25.101800000000001,-702.85040000000004]
["2013-07-24",29,1100,1595.78,495.78,31692.93,1092.8596,7.1403999999999996,207.07159999999999]
["2013-07-25",30,1100,866.9,{"$f":"D33-C33","v":-233.10000000000002},{"$f":"D33+F32","v":32559.83},{"$f":"F33/30","v":1085.3276666666668},{"$f":"G33-C33","v":-14.672333333333199},{"$f":"H33*B33","v":-440.16999999999598}]
["2013-07-26",31,1100]
[]
["汇总",null,"/","/","/"]
[]
["当天差距金额",null,"＝当天实际销售-当天销售目标"]
["累积总销售",null,"＝1月14日至当天的总销售"]
["累积日均销售",null,"＝累积总销售/天数"]
["日均差距金额",null,"＝累积日均销售-当天销售目标"]
["总差距金额",null,"＝日均差距金额*天数"]
[]
[]
["1、每天晚上下班后安排人员填写门店日销及员工日销报表"]
["2、每天在早会时向每一个员工通报前天的门店及员工销售日报，并传达当天每个员工的销售任务。下午接班的班组在上岗前开会小会学习后再上岗。"]
["3、两个报表需每天上午9：00以前报片区，片区于9：30以前报营业部。周末因要做广场活动可不报"]
["4、两个报表需挂在员工休息区或是办公室等能让员工都看到的地方，但注意不要挂在顾客轻易能看到的地方。"]
["5、每一个员工必须清楚了解自已当班的销售任务及自已当天与累积的差距金额，营业部每天均会安排人员进行电话抽查，对于不清楚的员工，处罚30元/次。若是店长原因，则只处罚店长。"]

{"sheet":"6月销售数据","index":4,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,9],[44,0,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,9],[0,0,0,8],[1,0,2,0],[1,1,2,1],[1,2,1,4],[1,5,1,8]]}
["           新都区新泰西路店 店销售跟踪报表"]
["日期","天数","当天销售情况",null,null,"累积销售情况"]
[null,null,"销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013-05-26",1,1100,785.76,-314.24,785.76,785.76,-314.24,-314.24]
["2013-05-27",{"$f":"B4+1","v":2},1100,645.9,-454.1,1431.66,715.83,-384.17,-768.34]
["2013-05-28",{"$f":"B5+1","v":3},1100,603.4,-496.6,2035.06,678.35299999999995,-421.64699999999999,-1264.941]
["2013-05-29",4,1100,1538.61,{"$f":"D7-C7","v":438.6099999999999},{"$f":"F6+D7","v":3573.67},{"$f":"F7/4","v":893.41750000000002},{"$f":"G7-C7","v":-206.58249999999998},{"$f":"H7*4","v":-826.32999999999993}]
["2013-05-30",5,1100,802.4,-297.60000000000002,4376.07,875.21400000000006,-224.786,-1123.93]
["2013-05-31",6,1100,755,-345,5131.07,855.178,-244.822,-1468.932]
["2013-06-01",7,1100,606.1,-493.9,5737.17,819.59569999999997,-280.40429999999998,-1962.8300999999999]
["2013-06-02",8,1100,822.21,-277.79000000000002,6559.38,819.92250000000001,-280.07749999999999,-2240.62]
["2013-06-03",9,1100,1060.26,{"$f":"D12-C12","v":-39.740000000000009},{"$f":"D12+F11","v":7619.64},{"$f":"F12/9","v":846.62666666666667},{"$f":"G12-C12","v":-253.37333333333333},{"$f":"H12*9","v":-2280.36}]
["2013-06-04",10,1100,789.88,{"$f":"D13-C13","v":-310.12},{"$f":"D13+F12","v":8409.52},{"$f":"F13/10","v":840.952},{"$f":"G13-C13","v":-259.048},{"$f":"H13*10","v":-2590.48}]
["2013-06-05",11,1100,976.79,-123.21,9386.31,853.3,-246.7,-2713.7]
["2013-06-06",12,1100,518.01,-581.99,9904.32,825.36,-274.64,-3295.68]
["2013-06-07",13,1100,870.75,-229.25,10775.07,828.85149999999999,-271.14800000000002,-3524.924]
["2013-06-08",14,1100,574.1,-525.9,11349.17,810.65499999999997,-289.34500000000003,-4050.83]
["2013-06-09",15,1100,1159.6300000000001,59.63,12508.8,833.92,-266.08,-3991.2]
["2013-06-10",16,1100,565.86,-534.14,13074.66,817.16600000000005,-282.834,-4525.3440000000001]
["2013-06-11",17,1100,1184.73,84.73,14259.39,838.7876,-261.2124,-4440.6108000000004]
["2013-06-12",18,1100,2150,{"$f":"D21-C21","v":1050},{"$f":"F20+D21","v":16409.39},{"$f":"F21/18","v":911.63277777777773},{"$f":"G21-C21","v":-188.36722222222227},{"$f":"H21*18","v":-3390.6100000000006}]
["2013-06-13",19,1100,631.6,{"$f":"D22-C22","v":-468.4},{"$f":"F21+D22","v":17040.989999999998},{"$f":"F22/19","v":896.89421052631565},{"$f":"G22-C22","v":-203.10578947368435},{"$f":"H22*19","v":-3859.0100000000029}]
["2013-06-14",20,1100,826.67,-273.33,17867.66,893.38300000000004,-206.61699999999999,-4132.34]
["2013-06-15",21,1100,625.48,-474.52,18493.14,880.62570000000005,-219.37430000000001,-4606.8603000000003]
["2013-06-16",22,1100,759.41,-340.59,19252.55,875.11590000000001,-224.88409999999999,-4947.4502000000002]
["2013-06-17",23,1100,1148.2,48.2,20400.75,886.98913000000005,-213.01079999999999,4899.25]
["2013-06-18",24,1100,586.4,{"$f":"D27-C27","v":-513.6},{"$f":"F26+D27","v":20987.15},{"$f":"F27/24","v":874.46458333333339},{"$f":"G27-C27","v":-225.53541666666661},{"$f":"H27*24","v":-5412.8499999999985}]
["2013-06-19",25,1100,1100.6600000000001,{"$f":"D28-C28","v":0.66000000000008185},{"$f":"F27+D28","v":22087.81},{"$f":"F28/25","v":883.51240000000007},{"$f":"G28-C28","v":-216.48759999999993},{"$f":"H28*25","v":-5412.1899999999987}]
["2013-06-20",26,1100,982.29,-117.71,23070.1,922.80399999999997,-177.196,-4607.0959999999995]
["2013-06-21",27,1100,700.6,-399.4,23770.7,880.39599999999996,-219.60400000000001,-4611.6840000000002]
["2013-06-22",28,1100,1607.31,{"$f":"D31-C31","v":507.30999999999995},{"$f":"F30+D31","v":25378.010000000002},{"$f":"F31/28","v":906.35750000000007},{"$f":"G31-C31","v":-193.64249999999993},{"$f":"H31*28","v":-5421.989999999998}]
["2013-06-23",29,1100,1920.99,{"$f":"D32-C32","v":820.99},{"$f":"F31+D32","v":27299.000000000004},{"$f":"F32/29","v":941.34482758620697},{"$f":"G32-C32","v":-158.65517241379303},{"$f":"H32*29","v":-4600.9999999999982}]
["2013-06-24",30,1100,2006.71,{"$f":"D33-C34","v":906.71},{"$f":"F32+D33","v":29305.710000000003},{"$f":"F33/30","v":976.85700000000008},{"$f":"G33-C33","v":-123.14299999999992},{"$f":"H33*30","v":-3694.2899999999972}]
["2013-06-25",31,1100,1161.2,61.2,30466.91,982.80349999999999,-117.1965,-3633.0915]
[]
["汇总",null,"/","/","/"]
[]
["当天差距金额",null,"＝当天实际销售-当天销售目标"]
["累积总销售",null,"＝1月14日至当天的总销售"]
["累积日均销售",null,"＝累积总销售/天数"]
["日均差距金额",null,"＝累积日均销售-当天销售目标"]
["总差距金额",null,"＝日均差距金额*天数"]
[]
[]
["1、每天晚上下班后安排人员填写门店日销及员工日销报表"]
["2、每天在早会时向每一个员工通报前天的门店及员工销售日报，并传达当天每个员工的销售任务。下午接班的班组在上岗前开会小会学习后再上岗。"]
["3、两个报表需每天上午9：00以前报片区，片区于9：30以前报营业部。周末因要做广场活动可不报"]
["4、两个报表需挂在员工休息区或是办公室等能让员工都看到的地方，但注意不要挂在顾客轻易能看到的地方。"]
["5、每一个员工必须清楚了解自已当班的销售任务及自已当天与累积的差距金额，营业部每天均会安排人员进行电话抽查，对于不清楚的员工，处罚30元/次。若是店长原因，则只处罚店长。"]

{"sheet":"5月活动数据","index":5,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,9],[44,0,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,9],[0,0,0,8],[1,0,2,0],[1,1,2,1],[1,2,1,4],[1,5,1,8]]}
["           新都区新泰西路店 店销售跟踪报表"]
["日期","天数","当天销售情况",null,null,"累积销售情况"]
[null,null,"销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013-05-07",1,1200,1122.17,{"$f":"D4-C4","v":-77.829999999999927},1122.17,1122.17,-77.83,-77.83]
["2013-05-08",{"$f":"B4+1","v":2},1200,1141.6199999999999,-58.38,2263.79,1131.895,-68.105000000000004,-136.21]
["2013-05-09",{"$f":"B5+1","v":3},1200,1491.9,291.89999999999998,3755.69,1251.8966600000001,51.896659999999997,155.68989999999999]
["2013-05-10",4,1200,1775.7,{"$f":"D7-C7","v":575.70000000000005},{"$f":"F6+D7","v":5531.39},{"$f":"F7/4","v":1382.8475000000001},{"$f":"G7-C7","v":182.84750000000008},{"$f":"H7*4","v":731.39000000000033}]
["2013-05-11",5,1200,1520.9,320.89999999999998,7052.29,1410.4580000000001,210.458,1052.29]
["2013-05-12",6,1200,883.17,316.83,7935.46,1322.5766599999999,122.57666,735.45998999999995]
["2013-05-13",7,1200,2417.1999999999998,{"$f":"D10-C10","v":1217.1999999999998},{"$f":"F9+D10","v":10352.66},{"$f":"F10/7","v":1478.9514285714286},{"$f":"G10-C10","v":278.95142857142855},{"$f":"H10*7","v":1952.6599999999999}]
["2013-05-14",8,null,{"$f":"SUM(D4:D10)","v":10352.66}]
["2013-05-15",9]
["2013-05-16",10]
["2013-05-17",11]
["2013-05-18",{"$f":"B14+1","v":12}]
["2013-05-19",13]
["2013-05-20",14]
["2013-05-21",15]
["2013-05-11",16]
["2013-05-12",17]
["2013-05-13",18]
["2013-05-14",19]
["2013-05-15",20]
["2013-05-16",21]
["2013-05-17",22]
["2013-05-18",23]
["2013-05-19",24]
["2013-05-20",25]
["2013-05-21",26]
["2013-05-22",27]
["2013-05-23",28]
["2013-05-24",29]
["2013-05-25",30]
["2013-05-26",31]
[]
["汇总",null,"/","/","/"]
[]
["当天差距金额",null,"＝当天实际销售-当天销售目标"]
["累积总销售",null,"＝1月14日至当天的总销售"]
["累积日均销售",null,"＝累积总销售/天数"]
["日均差距金额",null,"＝累积日均销售-当天销售目标"]
["总差距金额",null,"＝日均差距金额*天数"]
[]
[]
["1、每天晚上下班后安排人员填写门店日销及员工日销报表"]
["2、每天在早会时向每一个员工通报前天的门店及员工销售日报，并传达当天每个员工的销售任务。下午接班的班组在上岗前开会小会学习后再上岗。"]
["3、两个报表需每天上午9：00以前报片区，片区于9：30以前报营业部。周末因要做广场活动可不报"]
["4、两个报表需挂在员工休息区或是办公室等能让员工都看到的地方，但注意不要挂在顾客轻易能看到的地方。"]
["5、每一个员工必须清楚了解自已当班的销售任务及自已当天与累积的差距金额，营业部每天均会安排人员进行电话抽查，对于不清楚的员工，处罚30元/次。若是店长原因，则只处罚店长。"]

{"sheet":"5月销售跟踪","index":6,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,9],[44,0,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,9],[0,0,0,8],[1,0,2,0],[1,1,2,1],[1,2,1,4],[1,5,1,8]]}
["           新都区新泰西路店 店销售跟踪报表"]
["日期","天数","当天销售情况",null,null,"累积销售情况"]
[null,null,"销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013-04-26",1,1100,1068.22,{"$f":"D4-C4","v":-31.779999999999973},1068.22,1068.22,-31.78,-31.78]
["2013-04-27",{"$f":"B4+1","v":2},1100,725.62,374.38,{"$f":"F4+D5","v":1793.8400000000001},896.92,-203.08,-406.16]
["2013-04-28",{"$f":"B5+1","v":3},1100,534.05999999999995,{"$f":"D6-C6","v":-565.94000000000005},{"$f":"F5+D6","v":2327.9},{"$f":"F6/3","v":775.9666666666667},{"$f":"G6-C6","v":-324.0333333333333},{"$f":"H6*3","v":-972.09999999999991}]
["2013-04-29",4,1100,1067.06,-32.94,3394.96,848.74,-251.26,-1005.04]
["2013-04-30",5,1100,567.5,-532.5,3962.46,792.49199999999996,-307.50799999999998,-1537.54]
["2013-05-01",6,1100,1081.54,-18.46,5044,840.66660000000002,-259.33339999999998,-1556.0003999999999]
["2013-05-02",7,1100,649.88,{"$f":"D10-C10","v":-450.12},{"$f":"D10+F9","v":5693.88},{"$f":"F10/7","v":813.41142857142859},{"$f":"G10-C10","v":-286.58857142857141},{"$f":"H10*7","v":-2006.12}]
["2013-05-03",8,1100,1253.4000000000001,153.40000000000009,6947.2800000000007,{"$f":"F11/8","v":868.41000000000008},{"$f":"G11-C11","v":-231.58999999999992},{"$f":"H11*8","v":-1852.7199999999993}]
["2013-05-04",9,1100,843.96,-256.03999999999996,7791.2400000000007,{"$f":"F12/9","v":865.69333333333338},{"$f":"G12-C12","v":-234.30666666666662},{"$f":"H12*9","v":-2108.7599999999993}]
["2013-05-05",10,1100,482.68,-617.31999999999994,8273.92,{"$f":"F13/10","v":827.39200000000005},{"$f":"G13-C14","v":-272.60799999999995},{"$f":"H13*10","v":-2726.0799999999995}]
["2013-05-06",11,1100,890.4,-209.60000000000002,9164.32,{"$f":"F14/11","v":833.12},{"$f":"G14-C14","v":-266.88},{"$f":"H14*11","v":-2935.68}]
["2013-05-07",12,1100,1122.17,22.170000000000073,10286.49,{"$f":"F15/12","v":857.20749999999998},{"$f":"G15-C15","v":-242.79250000000002},{"$f":"H15*12","v":-2913.51}]
["2013-05-08",13,1100,1141.6199999999999,41.619999999999891,11428.11,879.08529999999996,-220.91470000000001,-2871.8910999999998]
["2013-05-09",14,1100,1491.9,391.90000000000009,12920.01,922.85784999999998,-177.142,-2479.9899999999998]
["2013-05-10",15,1100,1775.7,675.7,{"$f":"F17+D18","v":14695.710000000001},{"$f":"F18/15","v":979.71400000000006},{"$f":"G18-C18","v":-120.28599999999994},{"$f":"H18*15","v":-1804.2899999999991}]
["2013-05-11",16,1100,1520.9,420.90000000000009,16216.61,1013.538,-86.462000000000003,-1383.3920000000001]
["2013-05-12",17,1100,883.17,-216.83000000000004,17099.78,1005.869411,-94.130579999999995,-1600.22]
["2013-05-13",18,1100,2417.1999999999998,1317.1999999999998,{"$f":"D21+F20","v":19516.98},{"$f":"F21/18","v":1084.2766666666666},{"$f":"G21-C21","v":-15.723333333333358},{"$f":"H21*18","v":-283.02000000000044}]
["2013-05-14",19,1100,1145.3,45.299999999999955,{"$f":"F21+D22","v":20662.28},{"$f":"F22/19","v":1087.4884210526316},{"$f":"G22-C22","v":-12.511578947368434},{"$f":"H22*19","v":-237.72000000000025}]
["2013-05-15",20,1100,578.12,{"$f":"D23-C23","v":-521.88},21240.400000000001,1062.02,-37.979999999999997,-759.6]
["2013-05-16",21,1100,586.04,-513.96,21826.44,1039.354,-60.646000000000001,-1273.566]
["2013-05-17",22,1100,529.12,-570.88,{"$f":"D25+F24","v":22355.559999999998},{"$f":"F25/22","v":1016.161818181818},{"$f":"G25-C25","v":-83.838181818181965},{"$f":"H25*22","v":-1844.4400000000032}]
["2013-05-18",23,1100,963.43,-136.57000000000005,23318.99,1013.8691,-86.130859999999998,-1981.01]
["2013-05-19",24,1100,934.68,-165.32000000000005,24253.67,1010.56958,-89.430419999999998,-2146.3300800000002]
["2013-05-20",25,1100,1464.95,364.95000000000005,25718.62,1028.7447999999999,-74.255200000000002,-1781.38]
["2013-05-21",26,1100,950.91,-149.09000000000003,26671.93,1025.8430000000001,-74.156499999999994,-1928.07]
["2013-05-22",27,1100,853.02,-246.98000000000002,{"$f":"D30+F29","v":27524.95},{"$f":"F30/27","v":1019.4425925925926},{"$f":"G30-C30","v":-80.557407407407368},{"$f":"H30*27","v":-2175.0499999999988}]
["2013-05-23",28,1100,981.75,-118.25,{"$f":"D31+F30","v":28506.7},{"$f":"F31/28","v":1018.0964285714286},{"$f":"G31-C31","v":-81.903571428571354},{"$f":"H31*B31","v":-2293.2999999999979}]
["2013-05-24",29,1100,2326.6,1226.5999999999999,{"$f":"F31+D32","v":30833.3},{"$f":"F32/29","v":1063.2172413793103},{"$f":"G32-C32","v":-36.782758620689719},{"$f":"H32*29","v":-1066.7000000000019}]
["2013-05-25",30,1100,679.47,{"$f":"D33-C33","v":-420.53},31512.77,1050.4259999999999,-49.573999999999998,-1487.22]
["2013-05-26",31,1100]
[]
["汇总",null,"/","/","/"]
[]
["当天差距金额",null,"＝当天实际销售-当天销售目标"]
["累积总销售",null,"＝1月14日至当天的总销售"]
["累积日均销售",null,"＝累积总销售/天数"]
["日均差距金额",null,"＝累积日均销售-当天销售目标"]
["总差距金额",null,"＝日均差距金额*天数"]
[]
[]
["1、每天晚上下班后安排人员填写门店日销及员工日销报表"]
["2、每天在早会时向每一个员工通报前天的门店及员工销售日报，并传达当天每个员工的销售任务。下午接班的班组在上岗前开会小会学习后再上岗。"]
["3、两个报表需每天上午9：00以前报片区，片区于9：30以前报营业部。周末因要做广场活动可不报"]
["4、两个报表需挂在员工休息区或是办公室等能让员工都看到的地方，但注意不要挂在顾客轻易能看到的地方。"]
["5、每一个员工必须清楚了解自已当班的销售任务及自已当天与累积的差距金额，营业部每天均会安排人员进行电话抽查，对于不清楚的员工，处罚30元/次。若是店长原因，则只处罚店长。"]

{"sheet":"4月销售跟踪","index":7,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,0,47,9],[48,0,48,9],[0,0,0,8],[44,0,44,9],[45,0,45,9],[46,0,46,9],[1,2,1,4],[1,5,1,8],[1,0,2,0],[1,1,2,1]]}
["           新都区新泰西路店 店销售跟踪报表"]
["日期","天数","当天销售情况",null,null,"累积销售情况"]
[null,null,"销售目标","当天实际销售","当天差距金额","累积总销售","累积日均销售","日均差距金额","总差距金额"]
["2013-03-26",1,1100,857.6,{"$f":"D4-C4","v":-242.39999999999998},857.6,857.6,{"$f":"D4-C4","v":-242.39999999999998},-242.4]
["2013-03-27",{"$f":"B4+1","v":2},1100,487.56,-612.44000000000005,{"$f":"D5+D4","v":1345.16},{"$f":"F5/2","v":672.58},{"$f":"G5-C5","v":-427.41999999999996},{"$f":"H5*2","v":-854.83999999999992}]
["2013-03-28",{"$f":"B5+1","v":3},1100,501.7,-598.29999999999995,{"$f":"F5+D6","v":1846.8600000000001},{"$f":"F6/3","v":615.62},{"$f":"G6-C6","v":-484.38},{"$f":"H6*3","v":-1453.1399999999999}]
["2013-03-29",4,1100,1551.34,451.33999999999992,{"$f":"F6+D7","v":3398.2},{"$f":"F7/4","v":849.55},{"$f":"G7-C7","v":-250.45000000000005},{"$f":"H7*4","v":-1001.8000000000002}]
["2013-03-30",5,1100,992.12,-107.88,4390.32,878.06399999999996,-221.93600000000001,-1109.68]
["2013-03-31",6,1100,1599.41,499.41000000000008,{"$f":"D9+F8","v":5989.73},{"$f":"F9/6","v":998.2883333333333},{"$f":"G9-C9","v":-101.7116666666667},{"$f":"H9*6","v":-610.27000000000021}]
["2013-04-01",7,1100,752,-348,{"$f":"F9+D10","v":6741.73},{"$f":"F10/7","v":963.10428571428565},{"$f":"G10-C10","v":-136.89571428571435},{"$f":"H10*7","v":-958.27000000000044}]
["2013-04-02",8,1100,1005.21,{"$f":"D11-C11","v":-94.789999999999964},{"$f":"F10+D11","v":7746.94},{"$f":"F11/8","v":968.36749999999995},{"$f":"G11-C11","v":-131.63250000000005},{"$f":"H11*8","v":-1053.0600000000004}]
["2013-04-03",9,1100,937.63,-162.37,8684.57,964.95222000000001,-135.04769999999999,-1215.43]
["2013-04-04",10,1100,772.85,-327.14999999999998,9457.42,945.74199999999996,-154.25800000000001,-1542.58]
["2013-04-05",11,1100,1020.81,-79.190000000000055,10478.23,952.56636000000003,-147.43360000000001,-1621.77]
["2013-04-06",12,1100,972.58,-127.41999999999996,11450.81,954.23416599999996,-145.76580000000001,-1749.19]
["2013-04-07",13,1100,749.1,-350.9,12199.91,938.45461,-161.54539,-2100.0900700000002]
["2013-04-08",14,1100,607.1,-492.9,12807.01,914.78642000000002,-185.21,-2592.9899999999998]
["2013-04-09",15,1100,847.9,{"$f":"D18-C18","v":-252.10000000000002},{"$f":"D18+F17","v":13654.91},{"$f":"F18/15","v":910.32733333333329},{"$f":"G18-C18","v":-189.67266666666671},{"$f":"H18*15","v":-2845.0900000000006}]
["2013-04-10",16,1100,1071.56,-28.440000000000055,{"$f":"F18+D19","v":14726.47},{"$f":"F19/16","v":920.40437499999996},{"$f":"G19-C19","v":-179.59562500000004},{"$f":"H19*16","v":-2873.5300000000007}]
["2013-04-11",17,1100,962.02,-137.98000000000002,15688.49,922.85230000000001,-177.14760000000001,-3011.51]
["2013-04-12",18,1100,957.82,-142.17999999999995,{"$f":"D21+F20","v":16646.310000000001},{"$f":"F21/18","v":924.79500000000007},{"$f":"G21-C21","v":-175.20499999999993},{"$f":"H21*18","v":-3153.6899999999987}]
["2013-04-13",19,1100,443.3,-656.7,{"$f":"D22+F21","v":17089.61},{"$f":"F22/19","v":899.45315789473682},{"$f":"G22-C22","v":-200.54684210526318},{"$f":"H22*19","v":-3810.3900000000003}]
["2013-04-14",20,1100,569.29,-530.71,{"$f":"F22+D23","v":17658.900000000001},{"$f":"F23/20","v":882.94500000000005},{"$f":"G23-C23","v":-217.05499999999995},{"$f":"H23*20","v":-4341.0999999999985}]
["2013-04-15",21,1100,722.9,-377.1,18381.8,875.32380000000001,-224.67618999999999,-4718.2]
["2013-04-16",22,1100,623,{"$f":"D25-C25","v":-477},19004.8,863.85450000000003,"`-236.1455",-5195.201]
["2013-04-17",23,1100,728.31,-371.69000000000005,{"$f":"F25+D26","v":19733.11},{"$f":"F26/23","v":857.96130434782606},{"$f":"G26-C26","v":-242.03869565217394},{"$f":"H26*23","v":-5566.89}]
["2013-04-18",24,1100,1000.94,-99.059999999999945,{"$f":"F26+D27","v":20734.05},{"$f":"F27/24","v":863.91874999999993},{"$f":"G27-C27","v":-236.08125000000007},{"$f":"H27*24","v":-5665.9500000000016}]
["2013-04-19",25,1100,452.92,-647.07999999999993,21186.97,847.47879999999998,-252.52119999999999,-6313.03]
["2013-04-20",26,1100,607,-493,21793.97,838.2296,-261.7704,-6806.0303999999996]
["2013-04-21",27,1100,1318.79,218.78999999999996,23112.76,856.02809999999999,-243.97190000000001,-6587.2412999999997]
["2013-04-22",28,1100,1221.46,121.46000000000004,{"$f":"D31+F30","v":24334.219999999998},{"$f":"F31/28","v":869.07928571428567},{"$f":"G31-C31","v":-230.92071428571433},{"$f":"H31*22","v":-5080.2557142857149}]
["2013-04-23",29,1100,646.71,-453.28999999999996,{"$f":"D32+F31","v":24980.929999999997},{"$f":"F32/29","v":861.41137931034473},{"$f":"G32-C32","v":-238.58862068965527},{"$f":"H32*29","v":-6919.0700000000033}]
["2013-04-24",30,1100,526.4,-573.6,{"$f":"D33+F32","v":25507.329999999998},{"$f":"F33/30","v":850.24433333333332},{"$f":"G33-C33","v":-249.75566666666668},{"$f":"H33*30","v":-7492.67}]
["2013-04-25",31,1100,1640.74,{"$f":"D34-C34","v":540.74},27148.07,875.74419,-224.25581,-6951.9301100000002]
[]
["汇总",null,"/","/","/"]
[]
["当天差距金额",null,"＝当天实际销售-当天销售目标"]
["累积总销售",null,"＝1月14日至当天的总销售"]
["累积日均销售",null,"＝累积总销售/天数"]
["日均差距金额",null,"＝累积日均销售-当天销售目标"]
["总差距金额",null,"＝日均差距金额*天数"]
[]
[]
["1、每天晚上下班后安排人员填写门店日销及员工日销报表"]
["2、每天在早会时向每一个员工通报前天的门店及员工销售日报，并传达当天每个员工的销售任务。下午接班的班组在上岗前开会小会学习后再上岗。"]
["3、两个报表需每天上午9：00以前报片区，片区于9：30以前报营业部。周末因要做广场活动可不报"]
["4、两个报表需挂在员工休息区或是办公室等能让员工都看到的地方，但注意不要挂在顾客轻易能看到的地方。"]
["5、每一个员工必须清楚了解自已当班的销售任务及自已当天与累积的差距金额，营业部每天均会安排人员进行电话抽查，对于不清楚的员工，处罚30元/次。若是店长原因，则只处罚店长。"]

{"sheet":"Sheet2","index":8,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,2,0],[0,0,0,16],[1,1,1,4],[1,5,1,8],[1,9,1,12],[1,13,1,16]]}
["         新泰西路 店员工日销跟踪报表"]
["日期","销售人员朱朝霞",null,null,null,"销售人员胡燕明",null,null,null,"销售人员李江",null,null,null,"销售人员4",null,null,null,"。。。。。。"]
[null,"个人当天任务","个人当天实际销售","当天差距","累积差距","个人当天任务","个人当天实际销售","当天差距","累积差距","个人当天任务","个人当天实际销售","当天差距","累积差距","个人当天任务","个人当天实际销售","当天差距","累积差距"]
["2013-01-14",534.25,470.02499999999998,{"$f":"C4-B4","v":-64.225000000000023},-64.224999999999994,534.25,470.02499999999998,-64.224999999999994,-64.224999999999994,0,0,0,0]
["2013-01-15",534.25,491.75,{"$f":"C5-B5","v":-42.5},-106.72499999999999,0,0,0,-64.23,534.25,491.75,-42.5,-42.5]
["2013-01-16",0,0,0,-106.72499999999999,534.25,480.84,-53.41,-117.64,534.25,480.84,-53.41,-95.91]
["2013-01-17",534.25,255.6,-278.64999999999998,-385.375,534.25,255.6,-278.64999999999998,-396.29,0,0,0,-95.91]
["2013-01-18",534.25,305.5,-228.75,-614.125,0,0,0,-396.29,534.25,305.5,-228.75,-324.66000000000003]
["2013-01-19",0,0,0,-614.125,534.25,327.95,-206.3,-602.59,534.25,327.95,-206.3,-530.96]
["2013-01-20",534.25,541.68499999999995,7.4349999999999996,-606.69000000000005,534.25,541.68499999999995,7.4349999999999996,-595.15499999999997,0,0,0,-530.96]
["2013-01-21",534.25,415.53500000000003,{"$f":"C11-B11","v":-118.71499999999997},-725.40499999999997,0,0,0,-595.15499999999997,534.25,415.53500000000003,{"$f":"K11-J11","v":-118.71499999999997},-649.67499999999995]
["2013-01-22",0,0,0,-725.40499999999997,534.25,483.45,-50.8,-645.95500000000004,534.25,483.45,-50.8,-700.47500000000002]
["2013-01-23",534.25,368.66,-165.59,-890.995,534.25,368.66,-165.59,-811.54499999999996,0,0,0,-700.47500000000002]
["2013-01-24",534.25,527.75,{"$f":"C14-B14","v":-6.5},-897.495,0,0,0,-811.54499999999996,534.25,527.75,-6.5,-706.95699999999999]
["2013-01-25",0,0,0,-897.495,534.25,402.79,{"$f":"G15-F15","v":-131.45999999999998},-943.005,534.25,402.79,-131.46,-838.41700000000003]
["2013-01-26",534.25,879.4,345.15,-552.34500000000003,534.25,879.4,345.15,-597.85500000000002,0,0,0,-838.41700000000003]
["2013-01-27",534.25,895.38499999999999,361.13499999999999,-161.21,0,0,0,-597.85500000000002,534.25,895.38499999999999,361.13499999999999,-477.28199999999998]
["2013-01-28",0,0,0,-161.21,534.25,594.30499999999995,{"$f":"G18-F18","v":60.05499999999995},-537.79999999999995,534.25,594.30499999999995,60.055,-417.22699999999998]
["2013-01-29",534.25,550.05999999999995,15.81,-145.4,534.25,550.05999999999995,15.81,{"$f":"I18+H19","v":-521.99},0,0,0,-417.22699999999998]
["2013-01-30",534.25,242.785,-291.46499999999997,-436.86500000000001,0,0,0,{"$f":"I19+H20","v":-521.99},534.25,242.785,-291.46499999999997,-708.69200000000001]
["2013-01-31",0,0,0,-436.86500000000001,534.25,172.01499999999999,{"$f":"G21-F21","v":-362.23500000000001},-884.23,534.25,172.01499999999999,{"$f":"K21-J21","v":-362.23500000000001},-1070.9269999999999]
["2013-02-01",534.25,null,null,null,534.25,null,null,null,0,0,0,-1070.9269999999999]
["2013-02-02"]
["2013-02-03"]
["2013-02-04"]
["2013-02-05"]
["2013-02-06"]
["2013-02-07"]
["2013-02-08"]
["汇总"]
[]
["个人当天任务",null,"将门店当天销售目标分解到班再分解到人，于当天早上早会以前制定"]
["当天差距",null,"＝个人当天实际销售-个人当天任务"]
["累积差距",null,"＝每天差距的总和"]

{"sheet":"Sheet4","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}