销售数据统计分析表电子表格模板

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,按销售人员统计,,,

,,序号,日期,销售人员,产品编号,产品名称,规格,数量,单位,单价,销售金额,备注,,销售人员排行榜,,,,,,排名,姓名,销售金额,

,,1,2022/1/5,XX1,QK001,产品A,1*1,10,个,120,"1,200.00",,,排名,姓名,销售金额,占比,,,6,XX1,115910,

,,2,2022/1/16,XX2,QK002,产品B,1*1,6,个,60,360.00,,,1,XX4,209670,23%,,,4,XX2,134025,

,,3,2022/1/16,XX3,QK003,产品C,1*1,25,个,100,"2,500.00",,,2,XX6,177485,20%,,,3,XX3,143160,

,,4,2022/1/16,XX4,QK004,产品D,1*1,18,个,65,"1,170.00",,,3,XX3,143160,16%,,,1,XX4,209670,

,,5,2022/1/21,XX5,QK005,产品E,1*1,20,个,80,"1,600.00",,,4,XX2,134025,15%,,,5,XX5,124760,

,,6,2022/1/22,XX6,QK006,产品F,1*1,20,个,45,900.00,,,5,XX5,124760,14%,,,2,XX6,177485,

,,7,2022/1/23,XX6,QK001,产品A,1*1,65,个,120,"7,800.00",,,6,XX1,115910,13%,,,,,,

,,8,2022/1/26,XX5,QK005,产品E,1*1,93,个,80,"7,440.00",,,,,,,,,,,,

,,9,2022/1/27,XX1,QK006,产品F,1*1,83,个,45,"3,735.00",,,,,,,,,,,,

,,10,2022/1/29,XX3,QK002,产品B,1*1,84,个,60,"5,040.00",,,产品销售排行榜,,,,,,,,,

,,11,2022/1/30,XX5,QK002,产品B,1*1,26,个,60,"1,560.00",,,排名,产品编号,产品名称,销售金额,,,按产品统计,,,

,,12,2022/2/3,XX4,QK005,产品E,1*1,55,个,80,"4,400.00",,,1,QK001,产品A,249360,,,排名,产品编号,产品名称,销售金额

,,13,2022/2/3,XX3,QK004,产品D,1*1,20,个,65,"1,300.00",,,2,QK003,产品C,189100,,,1,QK001,产品A,249360

,,14,2022/2/7,XX4,QK003,产品C,1*1,88,个,100,"8,800.00",,,3,QK002,产品B,133560,,,3,QK002,产品B,133560

,,15,2022/2/7,XX3,QK006,产品F,1*1,23,个,45,"1,035.00",,,4,QK005,产品E,125200,,,2,QK003,产品C,189100

,,16,2022/2/8,XX5,QK001,产品A,1*1,61,个,120,"7,320.00",,,5,QK004,产品D,105235,,,5,QK004,产品D,105235

,,17,2022/2/9,XX4,QK001,产品A,1*1,28,个,120,"3,360.00",,,6,QK006,产品F,102555,,,4,QK005,产品E,125200

,,18,2022/2/10,XX6,QK006,产品F,1*1,71,个,45,"3,195.00",,,,,,,,,6,QK006,产品F,102555

,,19,2022/2/10,XX6,QK001,产品A,1*1,50,个,120,"6,000.00",,,,,,,,,,,,

,,20,2022/2/10,XX3,QK006,产品F,1*1,86,个,45,"3,870.00",,,,,,,,,,,,

,,21,2022/2/11,XX6,QK005,产品E,1*1,32,个,80,"2,560.00",,,,,,,,,,,,

,,22,2022/2/14,XX6,QK001,产品A,1*1,86,个,120,"10,320.00",,,,,,,,,按月份统计,,,

,,23,2022/2/14,XX3,QK001,产品A,1*1,72,个,120,"8,640.00",,,,,,,,,2022年,,,

,,24,2022/2/19,XX2,QK005,产品E,1*1,76,个,80,"6,080.00",,,,,,,,,月份,金额,备注,

,,25,2022/2/19,XX2,QK002,产品B,1*1,36,个,60,"2,160.00",,,,,,,,,1月,33305,,

,,26,2022/2/20,XX2,QK004,产品D,1*1,47,个,65,"3,055.00",,,,,,,,,2月,83155,,

,,27,2022/2/21,XX1,QK002,产品B,1*1,65,个,60,"3,900.00",,,,,,,,,3月,92010,,

,,28,2022/2/22,XX1,QK002,产品B,1*1,60,个,60,"3,600.00",,,,,,,,,4月,86940,,

,,29,2022/2/22,XX3,QK006,产品F,1*1,30,个,45,"1,350.00",,,,,,,,,5月,68985,,

,,30,2022/2/28,XX2,QK004,产品D,1*1,34,个,65,"2,210.00",,,,,,,,,6月,61825,,

,,31,2022/3/2,XX4,QK005,产品E,1*1,37,个,80,"2,960.00",,,,,,,,,7月,109600,,

,,32,2022/3/2,XX6,QK002,产品B,1*1,88,个,60,"5,280.00",,,,,,,,,8月,47200,,

,,33,2022/3/3,XX6,QK001,产品A,1*1,71,个,120,"8,520.00",,,,,,,,,9月,75585,,

,,34,2022/3/3,XX5,QK002,产品B,1*1,76,个,60,"4,560.00",,,,,,,,,10月,113020,,

,,35,2022/3/3,XX4,QK005,产品E,1*1,65,个,80,"5,200.00",,,,,,,,,11月,59240,,

,,36,2022/3/5,XX4,QK003,产品C,1*1,72,个,100,"7,200.00",,,,,,,,,12月,74145,,

,,37,2022/3/7,XX4,QK005,产品E,1*1,63,个,80,"5,040.00",,,,,,,,,,,,

,,38,2022/3/8,XX6,QK001,产品A,1*1,38,个,120,"4,560.00",,,,,,,,,,,,

,,39,2022/3/11,XX2,QK004,产品D,1*1,41,个,65,"2,665.00",,,,,,,,,,,,

,,40,2022/3/12,XX4,QK006,产品F,1*1,36,个,45,"1,620.00",,,,,,,,,,,,

,,41,2022/3/14,XX3,QK003,产品C,1*1,34,个,100,"3,400.00",,,,,,,,,,,,

,,42,2022/3/16,XX5,QK002,产品B,1*1,86,个,60,"5,160.00",,,,,,,,,,,,

,,43,2022/3/17,XX4,QK005,产品E,1*1,95,个,80,"7,600.00",,,,,,,,,,,,

,,44,2022/3/17,XX5,QK006,产品F,1*1,30,个,45,"1,350.00",,,,,,,,,,,,

,,45,2022/3/22,XX4,QK006,产品F,1*1,88,个,45,"3,960.00",,,,,,,,,,,,

,,46,2022/3/25,XX4,QK006,产品F,1*1,99,个,45,"4,455.00",,,,,,,,,,,,

,,47,2022/3/27,XX1,QK005,产品E,1*1,87,个,80,"6,960.00",,,,,,,,,,,,

,,48,2022/3/29,XX4,QK001,产品A,1*1,96,个,120,"11,520.00",,,,,,,,,,,,

,,49,2022/4/2,XX6,QK006,产品F,1*1,58,个,45,"2,610.00",,,,,,,,,,,,

,,50,2022/4/3,XX4,QK005,产品E,1*1,79,个,80,"6,320.00",,,,,,,,,,,,

,,51,2022/4/5,XX2,QK002,产品B,1*1,34,个,60,"2,040.00",,,,,,,,,,,,

,,52,2022/4/6,XX2,QK002,产品B,1*1,70,个,60,"4,200.00",,,,,,,,,,,,

,,53,2022/4/7,XX6,QK004,产品D,1*1,45,个,65,"2,925.00",,,,,,,,,,,,

,,54,2022/4/8,XX6,QK002,产品B,1*1,55,个,60,"3,300.00",,,,,,,,,,,,

,,55,2022/4/10,XX5,QK006,产品F,1*1,40,个,45,"1,800.00",,,,,,,,,,,,

,,56,2022/4/11,XX2,QK004,产品D,1*1,73,个,65,"4,745.00",,,,,,,,,,,,

,,57,2022/4/11,XX3,QK001,产品A,1*1,73,个,120,"8,760.00",,,,,,,,,,,,

,,58,2022/4/12,XX5,QK003,产品C,1*1,35,个,100,"3,500.00",,,,,,,,,,,,

,,59,2022/4/18,XX5,QK003,产品C,1*1,24,个,100,"2,400.00",,,,,,,,,,,,

,,60,2022/4/19,XX5,QK002,产品B,1*1,62,个,60,"3,720.00",,,,,,,,,,,,

,,61,2022/4/20,XX4,QK003,产品C,1*1,59,个,100,"5,900.00",,,,,,,,,,,,

,,62,2022/4/21,XX5,QK006,产品F,1*1,77,个,45,"3,465.00",,,,,,,,,,,,

,,63,2022/4/22,XX1,QK002,产品B,1*1,31,个,60,"1,860.00",,,,,,,,,,,,

,,64,2022/4/22,XX6,QK005,产品E,1*1,34,个,80,"2,720.00",,,,,,,,,,,,

,,65,2022/4/24,XX2,QK003,产品C,1*1,92,个,100,"9,200.00",,,,,,,,,,,,

,,66,2022/4/25,XX5,QK003,产品C,1*1,35,个,100,"3,500.00",,,,,,,,,,,,

,,67,2022/4/25,XX3,QK006,产品F,1*1,39,个,45,"1,755.00",,,,,,,,,,,,

,,68,2022/4/27,XX6,QK004,产品D,1*1,66,个,65,"4,290.00",,,,,,,,,,,,

,,69,2022/4/30,XX3,QK004,产品D,1*1,35,个,65,"2,275.00",,,,,,,,,,,,

,,70,2022/4/30,XX4,QK004,产品D,1*1,87,个,65,"5,655.00",,,,,,,,,,,,

,,71,2022/5/1,XX6,QK004,产品D,1*1,48,个,65,"3,120.00",,,,,,,,,,,,

,,72,2022/5/2,XX3,QK006,产品F,1*1,93,个,45,"4,185.00",,,,,,,,,,,,

,,73,2022/5/2,XX1,QK006,产品F,1*1,99,个,45,"4,455.00",,,,,,,,,,,,

,,74,2022/5/4,XX5,QK004,产品D,1*1,77,个,65,"5,005.00",,,,,,,,,,,,

,,75,2022/5/5,XX6,QK002,产品B,1*1,55,个,60,"3,300.00",,,,,,,,,,,,

,,76,2022/5/6,XX4,QK006,产品F,1*1,45,个,45,"2,025.00",,,,,,,,,,,,

,,77,2022/5/10,XX6,QK002,产品B,1*1,67,个,60,"4,020.00",,,,,,,,,,,,

,,78,2022/5/14,XX4,QK003,产品C,1*1,80,个,100,"8,000.00",,,,,,,,,,,,

,,79,2022/5/19,XX2,QK006,产品F,1*1,99,个,45,"4,455.00",,,,,,,,,,,,

,,80,2022/5/20,XX6,QK004,产品D,1*1,64,个,65,"4,160.00",,,,,,,,,,,,

,,81,2022/5/20,XX6,QK001,产品A,1*1,59,个,120,"7,080.00",,,,,,,,,,,,

,,82,2022/5/21,XX2,QK005,产品E,1*1,35,个,80,"2,800.00",,,,,,,,,,,,

,,83,2022/5/23,XX3,QK002,产品B,1*1,51,个,60,"3,060.00",,,,,,,,,,,,

,,84,2022/5/26,XX5,QK001,产品A,1*1,71,个,120,"8,520.00",,,,,,,,,,,,

,,85,2022/5/30,XX6,QK002,产品B,1*1,80,个,60,"4,800.00",,,,,,,,,,,,

,,86,2022/6/3,XX3,QK004,产品D,1*1,29,个,65,"1,885.00",,,,,,,,,,,,

,,87,2022/6/4,XX4,QK002,产品B,1*1,82,个,60,"4,920.00",,,,,,,,,,,,

,,88,2022/6/4,XX4,QK001,产品A,1*1,62,个,120,"7,440.00",,,,,,,,,,,,

,,89,2022/6/5,XX2,QK004,产品D,1*1,20,个,65,"1,300.00",,,,,,,,,,,,

,,90,2022/6/7,XX3,QK003,产品C,1*1,54,个,100,"5,400.00",,,,,,,,,,,,

,,91,2022/6/8,XX2,QK003,产品C,1*1,40,个,100,"4,000.00",,,,,,,,,,,,

,,92,2022/6/9,XX1,QK001,产品A,1*1,24,个,120,"2,880.00",,,,,,,,,,,,

,,93,2022/6/11,XX3,QK005,产品E,1*1,51,个,80,"4,080.00",,,,,,,,,,,,

,,94,2022/6/12,XX4,QK001,产品A,1*1,76,个,120,"9,120.00",,,,,,,,,,,,

,,95,2022/6/19,XX3,QK005,产品E,1*1,56,个,80,"4,480.00",,,,,,,,,,,,

,,96,2022/6/22,XX5,QK002,产品B,1*1,50,个,60,"3,000.00",,,,,,,,,,,,

,,97,2022/6/28,XX6,QK001,产品A,1*1,91,个,120,"10,920.00",,,,,,,,,,,,

,,98,2022/6/29,XX5,QK001,产品A,1*1,20,个,120,"2,400.00",,,,,,,,,,,,

,,99,2022/7/4,XX1,QK003,产品C,1*1,37,个,100,"3,700.00",,,,,,,,,,,,

,,100,2022/7/4,XX2,QK001,产品A,1*1,89,个,120,"10,680.00",,,,,,,,,,,,

,,101,2022/7/4,XX3,QK006,产品F,1*1,90,个,45,"4,050.00",,,,,,,,,,,,

,,102,2022/7/5,XX6,QK005,产品E,1*1,55,个,80,"4,400.00",,,,,,,,,,,,

,,103,2022/7/5,XX1,QK003,产品C,1*1,64,个,100,"6,400.00",,,,,,,,,,,,

,,104,2022/7/6,XX1,QK002,产品B,1*1,57,个,60,"3,420.00",,,,,,,,,,,,

,,105,2022/7/6,XX6,QK006,产品F,1*1,97,个,45,"4,365.00",,,,,,,,,,,,

,,106,2022/7/6,XX4,QK005,产品E,1*1,49,个,80,"3,920.00",,,,,,,,,,,,

,,107,2022/7/8,XX1,QK004,产品D,1*1,28,个,65,"1,820.00",,,,,,,,,,,,

,,108,2022/7/12,XX4,QK006,产品F,1*1,35,个,45,"1,575.00",,,,,,,,,,,,

,,109,2022/7/13,XX3,QK004,产品D,1*1,86,个,65,"5,590.00",,,,,,,,,,,,

,,110,2022/7/13,XX1,QK004,产品D,1*1,24,个,65,"1,560.00",,,,,,,,,,,,

,,111,2022/7/14,XX1,QK005,产品E,1*1,96,个,80,"7,680.00",,,,,,,,,,,,

,,112,2022/7/16,XX6,QK002,产品B,1*1,48,个,60,"2,880.00",,,,,,,,,,,,

,,113,2022/7/18,XX5,QK003,产品C,1*1,68,个,100,"6,800.00",,,,,,,,,,,,

,,114,2022/7/20,XX2,QK002,产品B,1*1,76,个,60,"4,560.00",,,,,,,,,,,,

,,115,2022/7/23,XX4,QK005,产品E,1*1,49,个,80,"3,920.00",,,,,,,,,,,,

,,116,2022/7/26,XX2,QK003,产品C,1*1,56,个,100,"5,600.00",,,,,,,,,,,,

,,117,2022/7/27,XX3,QK003,产品C,1*1,85,个,100,"8,500.00",,,,,,,,,,,,

,,118,2022/7/28,XX6,QK005,产品E,1*1,71,个,80,"5,680.00",,,,,,,,,,,,

,,119,2022/7/30,XX4,QK003,产品C,1*1,55,个,100,"5,500.00",,,,,,,,,,,,

,,120,2022/7/31,XX6,QK003,产品C,1*1,70,个,100,"7,000.00",,,,,,,,,,,,

,,121,2022/8/4,XX3,QK006,产品F,1*1,68,个,45,"3,060.00",,,,,,,,,,,,

,,122,2022/8/5,XX2,QK003,产品C,1*1,73,个,100,"7,300.00",,,,,,,,,,,,

,,123,2022/8/12,XX5,QK002,产品B,1*1,41,个,60,"2,460.00",,,,,,,,,,,,

,,124,2022/8/14,XX1,QK001,产品A,1*1,59,个,120,"7,080.00",,,,,,,,,,,,

,,125,2022/8/15,XX3,QK003,产品C,1*1,38,个,100,"3,800.00",,,,,,,,,,,,

,,126,2022/8/16,XX6,QK003,产品C,1*1,26,个,100,"2,600.00",,,,,,,,,,,,

,,127,2022/8/17,XX4,QK002,产品B,1*1,55,个,60,"3,300.00",,,,,,,,,,,,

,,128,2022/8/19,XX1,QK003,产品C,1*1,56,个,100,"5,600.00",,,,,,,,,,,,

,,129,2022/8/23,XX3,QK002,产品B,1*1,51,个,60,"3,060.00",,,,,,,,,,,,

,,130,2022/8/28,XX4,QK005,产品E,1*1,30,个,80,"2,400.00",,,,,,,,,,,,

,,131,2022/8/29,XX1,QK001,产品A,1*1,35,个,120,"4,200.00",,,,,,,,,,,,

,,132,2022/8/30,XX5,QK006,产品F,1*1,52,个,45,"2,340.00",,,,,,,,,,,,

,,133,2022/9/1,XX4,QK001,产品A,1*1,38,个,120,"4,560.00",,,,,,,,,,,,

,,134,2022/9/3,XX6,QK006,产品F,1*1,37,个,45,"1,665.00",,,,,,,,,,,,

,,135,2022/9/4,XX6,QK001,产品A,1*1,81,个,120,"9,720.00",,,,,,,,,,,,

,,136,2022/9/5,XX4,QK002,产品B,1*1,58,个,60,"3,480.00",,,,,,,,,,,,

,,137,2022/9/6,XX3,QK003,产品C,1*1,58,个,100,"5,800.00",,,,,,,,,,,,

,,138,2022/9/7,XX2,QK002,产品B,1*1,76,个,60,"4,560.00",,,,,,,,,,,,

,,139,2022/9/8,XX2,QK005,产品E,1*1,66,个,80,"5,280.00",,,,,,,,,,,,

,,140,2022/9/9,XX4,QK003,产品C,1*1,76,个,100,"7,600.00",,,,,,,,,,,,

,,141,2022/9/11,XX5,QK001,产品A,1*1,94,个,120,"11,280.00",,,,,,,,,,,,

,,142,2022/9/11,XX4,QK006,产品F,1*1,34,个,45,"1,530.00",,,,,,,,,,,,

,,143,2022/9/11,XX5,QK002,产品B,1*1,51,个,60,"3,060.00",,,,,,,,,,,,

,,144,2022/9/13,XX6,QK006,产品F,1*1,58,个,45,"2,610.00",,,,,,,,,,,,

,,145,2022/9/14,XX6,QK005,产品E,1*1,20,个,80,"1,600.00",,,,,,,,,,,,

,,146,2022/9/15,XX1,QK006,产品F,1*1,48,个,45,"2,160.00",,,,,,,,,,,,

,,147,2022/9/16,XX3,QK005,产品E,1*1,57,个,80,"4,560.00",,,,,,,,,,,,

,,148,2022/9/29,XX2,QK001,产品A,1*1,51,个,120,"6,120.00",,,,,,,,,,,,

,,149,2022/10/1,XX4,QK003,产品C,1*1,99,个,100,"9,900.00",,,,,,,,,,,,

,,150,2022/10/3,XX2,QK003,产品C,1*1,72,个,100,"7,200.00",,,,,,,,,,,,

,,151,2022/10/3,XX3,QK006,产品F,1*1,89,个,45,"4,005.00",,,,,,,,,,,,

,,152,2022/10/3,XX5,QK004,产品D,1*1,91,个,65,"5,915.00",,,,,,,,,,,,

,,153,2022/10/5,XX2,QK006,产品F,1*1,54,个,45,"2,430.00",,,,,,,,,,,,

,,154,2022/10/5,XX2,QK002,产品B,1*1,25,个,60,"1,500.00",,,,,,,,,,,,

,,155,2022/10/7,XX3,QK005,产品E,1*1,39,个,80,"3,120.00",,,,,,,,,,,,

,,156,2022/10/7,XX5,QK003,产品C,1*1,68,个,100,"6,800.00",,,,,,,,,,,,

,,157,2022/10/8,XX5,QK003,产品C,1*1,43,个,100,"4,300.00",,,,,,,,,,,,

,,158,2022/10/11,XX5,QK006,产品F,1*1,52,个,45,"2,340.00",,,,,,,,,,,,

,,159,2022/10/13,XX3,QK005,产品E,1*1,24,个,80,"1,920.00",,,,,,,,,,,,

,,160,2022/10/15,XX2,QK001,产品A,1*1,22,个,120,"2,640.00",,,,,,,,,,,,

,,161,2022/10/16,XX3,QK006,产品F,1*1,35,个,45,"1,575.00",,,,,,,,,,,,

,,162,2022/10/16,XX4,QK006,产品F,1*1,78,个,45,"3,510.00",,,,,,,,,,,,

,,163,2022/10/17,XX2,QK004,产品D,1*1,94,个,65,"6,110.00",,,,,,,,,,,,

,,164,2022/10/17,XX6,QK003,产品C,1*1,46,个,100,"4,600.00",,,,,,,,,,,,

,,165,2022/10/18,XX6,QK004,产品D,1*1,85,个,65,"5,525.00",,,,,,,,,,,,

,,166,2022/10/18,XX3,QK005,产品E,1*1,41,个,80,"3,280.00",,,,,,,,,,,,

,,167,2022/10/19,XX1,QK002,产品B,1*1,62,个,60,"3,720.00",,,,,,,,,,,,

,,168,2022/10/19,XX4,QK002,产品B,1*1,69,个,60,"4,140.00",,,,,,,,,,,,

,,169,2022/10/20,XX1,QK004,产品D,1*1,78,个,65,"5,070.00",,,,,,,,,,,,

,,170,2022/10/20,XX1,QK004,产品D,1*1,74,个,65,"4,810.00",,,,,,,,,,,,

,,171,2022/10/20,XX5,QK004,产品D,1*1,49,个,65,"3,185.00",,,,,,,,,,,,

,,172,2022/10/23,XX1,QK004,产品D,1*1,35,个,65,"2,275.00",,,,,,,,,,,,

,,173,2022/10/23,XX4,QK004,产品D,1*1,38,个,65,"2,470.00",,,,,,,,,,,,

,,174,2022/10/24,XX3,QK005,产品E,1*1,90,个,80,"7,200.00",,,,,,,,,,,,

,,175,2022/10/28,XX3,QK001,产品A,1*1,29,个,120,"3,480.00",,,,,,,,,,,,

,,176,2022/11/4,XX5,QK002,产品B,1*1,53,个,60,"3,180.00",,,,,,,,,,,,

,,177,2022/11/12,XX6,QK006,产品F,1*1,36,个,45,"1,620.00",,,,,,,,,,,,

,,178,2022/11/13,XX5,QK003,产品C,1*1,68,个,100,"6,800.00",,,,,,,,,,,,

,,179,2022/11/14,XX4,QK001,产品A,1*1,99,个,120,"11,880.00",,,,,,,,,,,,

,,180,2022/11/14,XX2,QK001,产品A,1*1