年度销售业绩统计分析表(自动汇总生成).xlsx

年度销售业绩统计表编号姓名部门一月份二月份三月份四月份五月份六月份七月份八月份九月份十月份 十一月份 十二月份XS001张三销售一部76,50042,50095,50098,000106,50091,00076,50042,50095,50098,000106,50091,000XS002李四销售一部73,50091,50064,50093,50084,00087,00073,50091,50064,50093,50084,00087,000XS003王五销售一部75,50062,50087,00094,50078,00091,00075,50062,50087,00094,50078,00091,000XS004马六销售一部79,50098,50068,000100,00096,00066,00079,50098,50068,000100,00096,00066,000XS005刘七销售一部82,05063,50090,50097,00065,15099,00082,05063,50090,50097,00065,15099,000XS006明明销售一部82,50078,00081,00096,50096,50057,00082,50078,00081,00096,50096,50057,000XS007红红销售一部84,50071,00099,50089,50084,50058,00084,50071,00099,50089,50084,50058,000XS008佳佳销售一部87,50063,50067,50098,50078,50094,00087,50063,50067,50098,50078,50094,000XS009兰兰销售一部88,00082,50083,00075,50062,00085,00088,00082,50083,00075,50062,00085,000XS010军军销售一部92,00064,00097,00093,00075,00093,00092,00064,00097,00093,00075,00093,000XS011莉莉销售一部93,00071,50092,00096,50087,00061,00093,00071,50092,00096,50087,00061,000XS012琪琪销售一部93,05085,50077,00081,00095,00078,00093,05085,50077,00081,00095,00078,000XS013乐乐销售一部96,00072,500100,00086,00062,00087,50096,00072,500100,00086,00062,00087,500XS014小刚销售一部96,50086,50090,50094,00099,50070,00096,50086,50090,50094,00099,50070,000XS015赵一销售一部97,50076,00072,00092,50084,50078,00097,50076,00072,00092,50084,50078,000XS016赵二销售二部56,00077,50085,00083,00074,50079,00056,00077,50085,00083,00074,50079,000XS017赵三销售二部58,50090,00088,50097,00072,00065,00058,50090,00088,50097,00072,00065,000XS018赵四销售二部63,00099,50078,50063,15079,50065,50063,00099,50078,50063,15079,50065,500XS019赵五销售二部69,00089,50092,50073,00058,50096,50069,00089,50092,50073,00058,50096,500XS020赵六销售二部72,50074,50060,50087,00077,00078,00072,50074,50060,50087,00077,00078,000XS021赵七销售二部74,00072,50067,00094,00078,00090,00074,00072,50067,00094,00078,00090,000XS022赵八销售二部75,50072,50075,00092,00086,00055,00075,50072,50075,00092,00086,00055,000XS023赵九销售二部76,50070,00064,00075,00087,00078,00076,50070,00064,00075,00087,00078,000XS024李一销售二部77,00060,50066,05084,00098,00093,00077,00060,50066,05084,00098,00093,000XS025李二销售二部80,50096,00072,00066,00061,00085,00080,50096,00072,00066,00061,00085,000XS026李三销售二部83,50078,50070,500100,00068,15069,00083,50078,50070,500100,00068,15069,000XS027李四销售二部84,50078,50087,50064,50072,00076,50084,50078,50087,50064,50072,00076,500XS028李五销售二部92,50093,50077,00073,00057,00084,00092,50093,50077,00073,00057,00084,000XS029李六销售二部95,00095,00070,00089,50061,15061,50095,00095,00070,00089,50061,15061,500XS030李七销售二部97,00075,50073,00081,00066,00076,00097,00075,50073,00081,00066,00076,000XS031李八销售三部62,50076,00057,00067,50088,00084,50062,50076,00057,00067,50088,00084,500XS032李九销售三部62,50057,50085,00059,00079,00061,50062,50057,50085,00059,00079,00061,500XS033小王销售三部63,50073,00065,00095,00075,50061,00063,50073,00065,00095,00075,50061,000XS034小李销售三部68,00097,50061,00057,00060,00085,00068,00097,50061,00057,00060,00085,000XS035小兵销售三部71,50061,50082,00057,50057,00085,00071,50061,50082,00057,50057,00085,000XS036娜娜销售三部71,50059,50088,00063,00088,00060,50071,50059,50088,00063,00088,00060,500XS037刘一销售三部75,00071,00086,00060,50060,00085,00075,00071,00086,00060,50060,00085,000XS038刘二销售三部75,50060,50085,00057,00076,00083,00075,50060,50085,00057,00076,00083,000XS039刘三销售三部76,00063,50084,00081,00065,00062,00076,00063,50084,00081,00065,00062,000XS040刘四销售三部81,00055,50061,00091,50081,00059,00081,00055,50061,00091,50081,00059,000XS041刘五销售三部85,50064,50074,00078,50064,00076,00085,50064,50074,00078,50064,00076,000XS042刘六销售三部86,50065,50067,50070,50062,00073,00086,50065,50067,50070,50062,00073,000XS043刘七销售三部94,00068,05078,00060,50076,00067,00094,00068,05078,00060,50076,00067,000XS044刘八销售三部96,50074,50063,00066,00071,00069,00096,50074,50063,00066,00071,00069,000年度销售业绩分析图表总销售额排名百分比排名指标名一月份二月份三月份四月份五月份六月份七月份八月份九月份十月份510,000395%平均销售额80,04874,56977,92281,19776,19276,34180,04874,56977,92281,197494,0001079%优秀率50.0%27.3%45.5%59.1%34.1%40.9%50.0%27.3%45.5%59.1%488,5001372%达标率95.5%90.9%97.7%90.9%93.2%90.9%95.5%90.9%97.7%90.9%508,000590%前三名97,50099,500100,000100,000106,50099,00097,50099,500100,000100,000497,200981%97,00098,50099,500100,00099,50096,50097,00098,50099,500100,000491,5001176%96,50097,50097,00098,50098,00094,00096,50097,50097,00098,500487,0001469%后三名56,00042,50057,00057,00057,00055,00056,00042,50057,00057,000489,5001274%58,50055,50060,50057,00057,00057,00058,50055,50060,50057,000476,0001860%62,50057,50061,00057,50058,50058,00062,50057,50061,00057,500514,000297%中值80,00072,75077,50083,50076,00078,00080,00072,75077,50083,500501,000786%众数75,50063,50085,00081,00062,00085,00075,50063,50085,00081,000509,550493%504,000688%部门人数一月份二月份三月份四月份五月份六月份七月份八月份九月份537,0001100%销售一部1586,506.773,966.784,333.392,400.083,610.079,700.086,506.773,966.784,333.3500,500883%销售二部1577,000.081,566.775,136.781,476.773,053.376,800.077,000.081,566.775,136.7455,0002739%销售三部1476,392.967,717.974,035.768,892.971,607.172,250.076,392.967,717.974,035.7471,0002153%449,1503032%479,0001567%449,5002934%475,5001958%各部门年度销售业绩统计图表一月份二月份三月份四月份五月份六月份七月份八月份九月份十月份 十一月份十二月份0.010,000.020,000.030,000.040,000.050,000.060,000.070,000.080,000.090,000.0100,000.0销售一部销售二部销售三部456,0002641%450,5002837%478,5501665%460,5002544%469,6502251%二月份二月份分隔点463,5002446%=0=60000=7000080000100000404,500440%二月份二月份433,0003716%428,500416%414,500432%430,5003911%437,5003423%437,0003520%431,5003813%429,000409%442,5003227%425,000424%443,5503130%440,0003325%各部门年度销售业绩统计图表一月份二月份三月份四月份五月份六月份七月份八月份九月份十月份 十一月份十二月份0.010,000.020,000.030,000.040,000.050,000.060,000.070,000.080,000.090,000.0100,000.0销售一部销售二部销售三部十一月份 十二月份76,19276,34134.1%40.9%93.2%90.9%106,50099,00099,50096,50098,00094,00057,00055,00057,00057,00058,50058,00076,00078,00062,00085,000十月份 十一月份 十二月份92,400.083,610.079,700.081,476.773,053.376,800.068,892.971,607.172,250.0各部门年度销售业绩统计图表一月份二月份三月份四月份五月份六月份七月份八月份九月份十月份 十一月份十二月份0.010,000.020,000.030,000.040,000.050,000.060,000.070,000.080,000.090,000.0100,000.0销售一部销售二部销售三部各部门年度销售业绩统计图表一月份二月份三月份四月份五月份六月份七月份八月份九月份十月份 十一月份十二月份0.010,000.020,000.030,000.040,000.050,000.060,000.070,000.080,000.090,000.0100,000.0销售一部销售二部销售三部