销售目标及完成情况带统计图表

说明：,1、首页保护密码为空,可取消保护自行修改文字,2、在<2019年销售计划>中录入对应业务员以及每月指标和完成情况,3、其他统计图表自动随之更新,期初余额3500.0,收入合计3000.0,支出合计300.0,盈余6200.0,2019年目标任务及完成情况,序号姓名业绩目标（万元）已完成（万元）完成比例（%）7.08.09.011.012.0,业务员120.047.3708062.36854036.741.3483.5368680.35368683.0868680.617373611.7222.34445.41251.08250.850.170.161.58950.31791.587030.3174065.821.1646.226041.245208,业务员220.047.1027222.35513611.3024020.26048043.2368680.64737360.5684340.11368682.532790.5065588.876081.7752165.181071.0362147.708881.5417760.7362050.1472413.2950950.6590191.730430.34608611.9344682.3868936,业务员39.12750.182550.70.350.550.2750.460.231.060.531.40.71.35750.678750.05,业务员445.676920.91353841.998840.999420.483.671880.7343762.90.581.69780.339566.8321251.3664253.98560.797125.9821.19640.7486250.1497255.692251.897416666674.12780.8255614.05.640.402857142857,业务员526.89750.537951.80.90.6666666666673.681.841.580.791.60.6666666666670.30.065.09751.2743750.90.34.220.8444.721.57333333333,业务员648.04950.960994.480.8962.31.152.640.885.741.1489.53951.907910.173.393.40.680.690.233.260.8153.581.193333333332.250.225,7.0业务员75.80.1933333333330.120.0240.2880.05761.3420.26842.620.5242.51.250.50.180.12,8.0业务员80.06666666666670.1333333333330.1333333333331.8,9.0业务员93.840.1281.120.2240.161.120.7466666666670.533333333333,业务员10,完成合计360.0235.8649480.65518041111141.017.0212420.41515224390245.010.7237360.23830524444441.012.0871820.29480931707337.7525.474790.67482887417239.7524.486380.61600955974840.1525.6906950.63986787048635.7523.064480.6451602797241.7520.7247050.4964001197638.7513.940750.35976129032338.023.192680.61033368421131.7531.5683080.99427741732350.757.890.155467980296,18年完成情况130.5179.0730821.372207524913.73424.6775616.4480911.548714.269616.036811.361313.74833.10324216.180187.6787520.28666,同比增长1.758620689660.317143511273-0.5225354771630.2393326149321.29259186413-0.2651315745481.205857802180.7159822279530.6019838745881.030091626840.50747054117-0.578870552920.4334006172983.1111258994-0.611074469627,2.01-12月累计指标360，实际235.86，完成率65.52%，同比增幅31.71%；,分类1月2月3月4月5月6月7月8月9月10月11月12月,指标41.045.041.037.7539.7540.1535.7541.7538.7538.031.7550.75,实际17.02124210.72373612.08718225.4747924.4863825.69069523.0644820.72470513.9407523.1926831.5683087.89,完成率0.4151522439020.2383052444440.2948093170730.6748288741720.6160095597480.6398678704860.645160279720.496400119760.3597612903230.6103336842110.9942774173230.155467980296,同期13.73424.6775616.4480911.548714.269616.036811.361313.74833.10324216.180187.6787520.28666,同比0.2393326149321.29259186413-3.01.205857802180.7159822279530.6019838745881.030091626840.50747054117-0.578870552920.4334006172983.1111258994-0.611074469627,同比增长0.2393326149321.292591864131.205857802180.7159822279530.6019838745881.030091626840.507470541170.4334006172983.1111258994,同比下滑3.00.578870552920.611074469627,分类业务员1业务员2业务员3业务员4业务员5业务员6业务员7业务员8业务员9业务员10,指标20.020.0,实际47.37080647.1027229.127545.6769226.897548.04955.82.03.84,完成率2.36854032.35513610.182550.91353840.537950.960990.1933333333330.06666666666670.128,指标内0.182550.91353840.537950.960990.1933333333330.06666666666670.128,超指标2.36854032.3551361,11.0,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,分类业务员1业务员2业务员3业务员4业务员5业务员6业务员7业务员8业务员9业务员10,指标2.03.03.01.51.50.75,实际6.2260411.9344684.12784.723.580.180.8,完成率1.2452082.38689360.825561.573333333331.193333333330.120.533333333333,指标内0.825560.120.533333333333,超指标1.2452082.38689361.573333333331.19333333333,4S店业务指标构成及分析看板-得分排名,1月,2月,3月,序号业务员本月业绩上月业绩上月排名本月业绩本月排名4月,业务员13.5368686.743.5368685月,业务员23.2368681.3024023.2368686月,业务员30.550.70.557月,业务员42.41.998842.48月,业务员51.89月,业务员64.4810月,业务员711月,8.0业务员812月,9.0业务员9,10.0业务员10