周銷售業(yè)績(jī)統(tǒng)計(jì)分析表excel模板

1、周銷售業(yè)績(jī)統(tǒng)計(jì)分析工具編號(hào)姓名部門星期一星期二星期三星期四星期五總銷售額排名百分比排名A01程小萍銷售（1 ）部66,50092,50095,50098,00086,500439,000480%A02張麗銷售（1 ）部73,50091,50064,50093,50084,000407,0001133%A03盧奔銷售（1 ）部75,50062,50087,00094,50078,000397,5001413%A04劉月銷售（1 ）部79,50098,50068,000100,00096,000442,000293%A05杜鳴銷售（1 ）部82,05063,50090,50097,00065,15

2、0398,2001320%A06張成漢銷售（2 ）部82,50078,00081,00096,50096,500434,500573%A07盧紅銷售（2 ）部84,50071,00099,50089,50084,500429,000760%A08李佳佳銷售（2 ）部87,50063,50067,50098,50078,500395,500156%A09杜月蘭銷售（2 ）部88,00082,50083,00075,50062,000391,000160%A10李成斌銷售（2 ）部92,00064,00097,00093,00075,000421,000946%A11張利軍銷售（3 ）部93,00

3、071,50092,00096,50087,000440,000386%A12李詩奇銷售（3 ）部93,05085,50077,00081,00095,000431,550666%A13杜樂月銷售（3 ）部96,00072,500100,00086,00062,000416,5001040%A14劉大維銷售（3 ）部96,50086,50090,50094,00099,500467,0001100%A15唐艷菊銷售（3 ）部97,50076,00072,00092,50084,500422,500853%A15唐艷菊銷售（3 ）部87,50076,00072,00082,50084,50040

4、2,5001226%銷售員百分比排名銷售員排名120%100%80%60%40%20%0%銷售員百分比排名銷售員排名181614121086420百分比排名排名各部門一周銷售數(shù)據(jù)分析120,000100,00080,00060,00040,00020,0000星期一銷售（ 1 ）部銷售（ 2）部銷售（ 3）部星期四星期五星期二星期三星期一星期二星期三星期四星期五平均銷售額85,94477,21983,56391,78182,416優(yōu)秀率75.0%37.5%62.5%93.8%62.5%達(dá)標(biāo)率100.0%100.0%100.0%100.0%100.0%前三名97,50098,500100,000

5、100,00099,50096,50092,50099,50098,50096,50096,00091,50097,00098,00096,000后三名66,50062,50064,50075,50062,00073,50063,50067,50081,00062,00075,50063,50068,00082,50065,150中值87,50076,00085,00093,75084,500眾數(shù)87,50063,50090,50096,50084,500人數(shù)星期一星期二星期三星期四星期五銷售（1 ）75,410.081,700.081,100.096,600.081,930.0部52 ）銷售（86,900.071,800.085,600.090,600.079,300.0部53 ）銷售（9