全年销售数据分析看板1

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

,全年销售基础数据库:,,,,,,,,,,,,,,,,,,

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

,部门,姓名,第一季度,,第二季度,,第三季度,,第四季度,,年度目标销售,年度实际销售,完成率,占比,排名,,,,

,,,目标,实际,目标,实际,目标,实际,目标,实际,,,,,,,,,

,市场部,姓名1,150000,120933,200000,125477,180000,145628,300000,276363,830000,668401,81%,10%,6,,,,

,市场部,姓名2,150000,109229,200000,176828,180000,124873,300000,283664,830000,694594,84%,10%,4,,,,

,市场部,姓名3,150000,162600,200000,187282,180000,187282,300000,210002,830000,747166,90%,11%,2,,,,

,市场部,姓名4,150000,134592,200000,123737,180000,145828,300000,250000,830000,654157,79%,10%,8,,,,

,市场部,姓名5,150000,178999,200000,167225,180000,125466,300000,251722,830000,723412,87%,11%,3,,,,

,市场部,姓名6,150000,160999,200000,187272,180000,121273,300000,210083,830000,679627,82%,10%,5,,,,

,市场部,姓名7,150000,123770,200000,106725,180000,167262,300000,256161,830000,653918,79%,10%,9,,,,

,市场部,姓名8,150000,121872,200000,160288,180000,172636,300000,212919,830000,667715,80%,10%,7,,,,

,市场部,姓名9,150000,109888,200000,132773,180000,120393,300000,210082,830000,573136,69%,8%,10,,,,

,市场部,姓名10,150000,120939,200000,150992,180000,230002,300000,310888,830000,812821,98%,12%,1,,,,

,全年汇总：,,1500000,1343821,2000000,1518599,1800000,1540643,3000000,2471884,8300000,6874947,83%,-,-,,,,

,去年汇总：,,2000000,1277882,2000000,1282899,2500000,2018383,3200000,2108882,9700000,6688046,69%,-,-,,,,

,实际销售同比：,,▲5.16%,,▲18.37%,,▼-23.67%,,▲17.21%,,▲2.79%,,-,-,-,,,,↑

,以下数据为自动计算（不需要调整）,,,,,,,,,,,,,,,,,,

,部门,姓名,第一季度,第二季度,第三季度,第四季度,4,,部门,姓名,年度目标销售,年度实际销售,完成率,占比,辅助,,,,

,市场部,姓名1,120933,125477,145628,276363,276363,,市场部,姓名1,830000,668401,81%,10%,19%,,,,

,市场部,姓名2,109229,176828,124873,283664,283664,,市场部,姓名2,830000,694594,84%,10%,16%,,,,

,市场部,姓名3,162600,187282,187282,210002,210002,,市场部,姓名3,830000,747166,90%,11%,10%,,,,

,市场部,姓名4,134592,123737,145828,250000,250000,,市场部,姓名4,830000,654157,79%,10%,21%,,,,

,市场部,姓名5,178999,167225,125466,251722,251722,,市场部,姓名5,830000,723412,87%,11%,13%,,,,

,市场部,姓名6,160999,187272,121273,210083,210083,,市场部,姓名6,830000,679627,82%,10%,18%,,,,

,市场部,姓名7,123770,106725,167262,256161,256161,,市场部,姓名7,830000,653918,79%,10%,21%,,,,

,市场部,姓名8,121872,160288,172636,212919,212919,,市场部,姓名8,830000,667715,80%,10%,20%,,,,

,市场部,姓名9,109888,132773,120393,210082,210082,,市场部,姓名9,830000,573136,69%,8%,31%,,,,

,市场部,姓名10,120939,150992,230002,310888,310888,,市场部,姓名10,830000,812821,98%,12%,2%,,,,

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

,排名,姓名,占比,辅助,今年销售达成,辅助,,,季度,去年,今年,占比,,,,,,,

,1,姓名10,11.8%,88%,83%,17%,,,第一季度,1277882,1343821,20%,,,,,,,

,2,姓名3,10.9%,89%,,,,,第二季度,1282899,1518599,22%,,,,,,,

,3,姓名5,10.5%,89%,,,,,第三季度,2018383,1540643,22%,,,,,,,

,4,姓名2,10.1%,90%,去年同期,今年销售,同比增长,,第四季度,2108882,2471884,36%,,,,,,,

,5,姓名6,9.9%,90%,6688046,6874947,2.8%,,汇总：,6688046,6874947,100%,,,,,,,

,6,姓名1,9.7%,90%,,,,,,,,,,,,,,,

,7,姓名8,9.7%,90%,,,,,季度,今年预算,今年实际销售,完成率,,,,,,,

,8,姓名4,9.5%,90%,,,,,第一季度,1500000,1343821,90%,,,,,,,