全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

客户等级分析（多维度）

收藏
  • 客户等级分析（多维度）-表格模板销售数据使用方法：,1. 按下表格式粘贴复制销售数据即可；,序号月份日期客户订单金额业务员已收款金额,张贤忠,张国建,刘世,陈勇,8928.08928.0,陈庆杰,佳鑫,13.0,14.0周小平,15.0,16.0汪毅德,陈勇军,18.0,19.0彭小姐,21.0杨冬飞,22.0高辉煌,23.0,4422.04422.0,25.0,26.0,27.05205.625205.6,28.0,29.01702.8,维生,31.02754.02754.0,32.0,33.0武旗,周延新,2223.02223.0,36.0,37.0苑文乐,38.0黄成,39.01008.9,41.04296.04296.0,42.0,43.0吴刚1299.41299.4,44.0,45.043902.0,46.043902.0邓老板,47.0,48.08400.08400.0,华欣泓,张霞,53.0593.75593.75,许和胜,56.0黄泉良3077.23077.0,57.0,58.0胡小东,59.043906.0许和胜,61.0,62.0涂昌喜,63.0振扬,64.0,65.0吴伍凤,熊胜,67.0,68.0973.0961.0,69.0严胜2053.62054.0,刘燕4366.34366.0,71.0高素英951.75,72.0,73.0张二科6746.46746.0,74.0梁华满,陆亚东,76.0,77.0赵德顺,79.043911.0,43911.0,81.0朱卫强,82.0牟伟兰,83.0,84.0,308.75308.75,86.0,87.0,88.0,89.0,2260.02260.0,91.0薛继红,周成忠,93.01166.11166.0,龙连忠2217.62217.0,95.0,96.0,97.0,98.0张栋材,99.0,钟海滨,101.0梁兵,102.0陈宽,103.0张雪,1072.51072.5,107.0熊文政,张辉,109.0罗雄,华欣泓,112.0黎生,113.0兴达,1795.51795.5,116.0,743.4742.0,119.03470.73470.7,申亮军,121.0赵士权,122.0,123.0,124.0王胜,赵伟,126.0黄幼华7014.67014.6,127.0何泽芝,128.0,129.0,131.0王永年,132.01266.51266.0,133.0李山峰,134.0谭菊4406.44406.0,魏思思940.8940.8,136.0郑文超,137.0,138.0,139.0兴达五金,楚佳,141.0,142.01102.51102.5,143.06800.06800.0,43925.0李庆,冯文浩,146.0肖星吉,147.0陈宽1833.01776.0,148.0马福久,149.0,151.0吴斌,152.0杨飞鹏,153.0何军,154.0林培龙,155.0,陈剑,157.0242.5242.5,158.01082.91082.9,159.0,李凤启,161.0498.75498.75,162.0,163.0,166.0,167.0余建国1143.91143.0,169.0,丁先秀,171.0,172.05250.05250.0,173.0张华,176.0,177.0,侯百强,179.0立盛,1607.21607.0,181.0,182.0,183.0,184.0,丁胜,186.0863.28863.28,187.0翼焕冬,188.0,189.0,李平,191.0冯于波,643.5643.5,193.018468.018468.0,194.0,王春龙,196.0,197.0李亚运,良田,199.0许艳梅,洪玉评,201.0,202.0,203.0谢容,204.0宋新华,206.0刘超,林荣,208.0,209.0,211.0肖天勇,212.0傅自强,213.0,214.0,216.0,217.083.4283.42,218.0,杨清明,221.0柳德志984.2984.0,222.0员海军3224.0,223.0,224.01156.951156.95,梁宝容,226.0姚林明,227.0杜江水,杨渊,229.0姚林明,231.0487.6487.6,232.0陈刚,233.0,余静,237.07327.07300.0,238.0苏三九,239.0,许富民,241.02760.02760.0,242.0周书建,243.0,244.042.542.5,2220.02220.0,246.0邝达安,247.0王振华,248.0,249.0890.6890.6,张老板,251.02466.02466.0,252.0,253.0,254.0古均,256.0谭波,257.03889.63889.6,258.0,259.0,261.0,262.0贾志文,263.0,264.0曹高辉,姚慧敏,266.0苑敏,267.0,268.0,269.0,郭志勇,271.0闵建中,272.0胡峰,273.0,274.0,高胜利,宋勇,277.03399.03399.0,279.0,5875.25875.0,281.0丁胜,282.0陈能利2230.02230.0,283.0博创,284.043947.03162.53162.5,43947.0,286.0周磊,287.0,王应磊,289.0,1847.11840.0,291.0闵建中,292.0孟治友,293.0罗泽红,294.0冯俊龙,冯俊龙,296.0,王姐,298.0傅自强4408.04400.0,299.0,301.0653.4653.4,302.0董沾,303.04642.04642.0,304.0黄定旺,蓝松成,307.0雅兰,308.0龙连忠,309.0张华,彼得,311.01215.0,313.0周超,314.0邓树鼎,316.0,317.02431.02431.0,318.03404.53401.0,319.0,321.0谭菊10102.510100.0,322.0黄彩裕,323.0,487.5487.5,325.0,326.0,327.0何帅书,328.0,329.0谢小军,331.01177.21177.2,332.01085.0987.57,333.0邓海斌,334.03811.23811.0,335.0郝小姐1920.8,336.02955.192955.0,337.0,338.0,339.09439.29439.2,341.0蓝松成0.0,342.0周宏丽,彭智慧,344.0,陈江涛2070.02070.0,346.0897.75897.75,347.0晏杨威,348.0367.5367.5,349.0罗成五金,于山友,351.0蒋海,邱海,353.0梁雪英,354.0李凤启,355.09359.99359.9,356.0,357.0,358.0路文兵802.5,359.0雷小龙,王传红8250.08250.0,361.0,362.0857.5857.5,363.08162.08162.0,364.0颜志凯10200.010200.0,365.0,刘辉庆10758.810758.8,367.0,368.0,222.5222.5,371.0袁忠余,372.0刘万兵,373.0,374.0鲁权,安悦694.2694.0,767.448767.45,377.0林智明,378.0雷文军,379.0,应团保1196.61196.6,381.0,382.0631.4,383.0,384.01012.01010.0,385.0,386.0蒋先顺,387.0朱金保,388.01878.51878.0,389.0朱斌847.5847.5,2130.32130.3,391.0450.072,392.0174.636174.64,393.0吴亚娣,394.0雷志强,395.0潘淳科,396.0李雪梅,397.0,398.0,张易军,401.0,胡峰,403.0,404.0寿红超,张国强1673.651670.0,406.0高波,407.0,409.0兰汉林,1279.21279.2,411.0,412.0,413.0冯文浩4125.04125.0,415.0杰邦,416.0施明加,417.0,418.0金永洪1303.5,419.0满松珊,421.0杨颖,422.01185.61185.6,423.06396.06396.0,424.0,425.03174.43174.0,426.0段晓宽6908.86908.0,427.0秦洪金,428.01246.41246.4,429.01640.0,431.0,433.0田炎辉,434.0,435.0,索爱,437.0940.5940.5,438.0,439.0,于山友,441.0周业陈,442.01960.01960.0,443.0,穗宝尊品,445.0段良勇,446.0998.4998.4,447.0袁杰2610.02610.0,448.01915.21915.2,449.0谢凌峰,谭玉龙,451.0甘升,罗润涛,454.0苏迎秋,周建春,周建春,457.0谢忠萍,458.0谭静文1878.81878.2,459.0,罗文珍,461.0千百利,462.0,463.0唐亮,464.011.511.5,466.0,467.0,469.0王剑英7116.87117.0,许文礼,471.0,472.0刘吉良,473.0蒙旭丰,474.01278.81278.8,475.0,476.0,477.0,478.0,479.0岳瑛,641.25641.25,481.0盛秋红,482.0176.4176.0,483.0,484.0,485.0苑文乐,487.0陈后宏,488.0付维军,489.02590.52590.5,491.0,492.0,493.0龙新科,494.0,2004.52004.5,496.01138.51138.5,497.0,498.0,499.0军华,魏生,501.0,502.0杨银才1244.41244.4,503.0金汇鑫1507.51507.0,504.0,460.8460.8,506.0永隆五金3045.03045.0,507.0杨光秋,508.0,509.0,卞兴红,511.0,402.5402.5,513.0大莱,514.07281.67275.2,516.0张怀,517.0吴军,518.0蒋建华,519.0,521.0邝焕强,522.0,523.0,524.0,526.01785.01785.0,527.0,528.0梁小军,529.0许大文4338.44338.0,李世国,531.0薛坤,2109.62109.6,533.04590.04590.0,534.0,535.0王长德747.5,536.0刘峰,537.04670.724670.0,538.01245.61245.6,539.0,龙友,541.0,542.0,543.0,544.0棕星,545.0王志强,546.0海星,547.0,548.0夏平涛,549.0何浩1734.31734.0,王新887.4887.0,551.0潘发,552.0张泽芳261.6261.6,553.0,554.0,556.0任承渐,557.0杨琪3352.43352.0,558.0,559.0,6090.06090.0,鲁常良,562.0罗永树,563.0恒达1804.0,564.0,565.04691.64691.6,566.0何军,潘发,568.0,569.01237.51237.5,程林辉,571.0李巍,572.01904.01904.0,573.0,574.0,廖冬林,兆纵2140.0,577.0,578.0棕星,579.0志胜,43996.0中和,581.043996.05125.05125.0,582.0王占武,583.0朱周利,584.0冯文祥1966.21966.2,1254.5,586.0,587.0志胜,588.0,589.0,591.0,592.0,593.0,张怀,595.0林思珍,596.0冯文祥952.0864.3,597.0,598.0,599.0罗方平,1107.6,601.0897.6897.6,602.0,603.0曾汉强,604.0,605.0,蒋建华,607.0,608.0,609.0王海军,611.01117.81117.0,胡年华,613.0,614.01152.81152.8,73.7489273.74892,616.0蒋志辉,617.0罗波,618.0,619.0,杜云志,621.0海臣,622.0郑开星,623.0林斯俊,624.0贾峰峰,626.0885.6885.6,359.19,628.0823.2823.2,629.0,1105.5,631.0,632.08606.08606.0,633.0,634.0,635.0盈俊织带,636.0,637.0庞邦富,638.0张洪全,639.0李维凡6268.5,641.0香港彭生,642.01811.21811.2,643.0,洪玉评10050.010050.0,李秋明,646.0,647.0朱运顺,648.0,649.0蔡敦富,肖林中,651.0215.514,652.0谢文5791.25791.2,653.0,654.0黄龙,658.0苑敏,659.0建华,661.0王建房,662.0,663.0吴燕州,664.0梁小军,665.0,666.0黄幼华,667.0,668.02310.02310.0,669.0,723.9723.9,671.01816.251816.25,672.0曹平,673.0潘超,674.0姚慧敏3672.03672.0,569.25569.25,676.01360.0,677.0,678.0,679.0851.2851.2,681.0,682.0刘辉辉,683.012974.512925.14,44017.0朱梦亚,685.044017.0691.6691.0,686.0,687.0,688.0,689.0唐强,孟磊,691.02188.9,692.09.59.5,693.0熊金湖,694.03675.03675.0,695.0,696.0,697.0刘付闯,698.0天美五金,699.0618.6618.6,1719.91719.9,701.0熊晓东,702.0李巍,703.0,704.0,舒玉,706.0闫雪松,707.0,708.0,709.0644.16,冯丽娟,711.0,712.0蒋海,713.0149.7149.7,714.0,715.0,716.09678.49678.4,717.0张阿南,718.0孙永刚,719.0,1400.71400.7,721.0,722.0王玉峰,723.0郑洪,724.0,726.0刘新,727.0,728.0小曾,729.0,730.03237.53237.0,731.03480.03480.0,732.0,733.04323.04323.0,734.0张南宽,736.0永坚,737.05947.2,738.0黄宝才,739.0829.5,肖天生,742.0,743.0曹丽芝,陶文杰,745.0,746.01092.5,747.0,748.0,749.06467.56460.0,751.0299.25299.25,752.0,753.0,754.0余彬,755.0,高生,757.0,758.0,759.0李永元,苏迎秋,761.0597.8597.2,762.0,763.0蒋贤耀,764.0廖凤英,765.0李中河,766.0车超,767.0,768.0,769.0,771.0,772.0冯孝金,773.0彭晓琳,774.0张敏,王秀,776.0,777.0张先建,778.0,779.0,781.0永隆五金1784.01784.0,782.0,蒋祖镇,785.0,786.0,787.0马逍阳,788.0,789.0刘新2177.552170.0,790.0卓建清,791.0,肖建雄,793.0,794.0,王武权,796.0李浩2196.02196.0,797.0713.4713.4,798.0455.9455.9,44040.0560.5560.5,801.044040.0窑金1603.0,802.0吴胜和5700.05700.0,803.0李俊帮,804.0,806.0江文,807.0雷文法,808.0谭新军,809.0蔡波,魏生,811.0,812.02037.5,813.0,814.0,815.0马来西亚王小姐,816.0陈佳亮,817.0应后从,818.0曾卫,819.0,821.0,822.0王云倪,823.0,824.0,罗老板,827.0,828.01677.5,829.0陈江涛2365.02360.0,830.057.5,831.03799.6,832.02119.52119.5,833.0高生,834.0,835.0任士民1557.51557.0,836.098.0,837.0佳德利夏先生,838.0,839.0罗老板,江文,841.08750.08750.0,842.0,843.0945.75945.75,844.0刘明军,845.0博创,846.0,847.02667.02667.0,848.0何帅书,849.0骆玲3700.03700.0,851.0黄燕玲1764.0,852.0,853.0康之宝,854.0林斯武,855.0,856.0黄胜,857.01216.4,858.03290.03290.0,859.06105.0,曾震,861.0,862.0524.4524.4,863.0,864.0腾飞,865.0,866.0冯志明6600.06600.0,867.012215.012215.0,868.0,869.09779.49779.4,870.0,871.0,872.0,873.0,874.0李霞,鲁智辉,876.0黄国维,877.03328.463328.46,878.0刘锦,879.08500.08500.0,李悦龙,881.0,882.0屈先学,883.01990.01990.0,884.0姬英才,1750.7,886.0,887.0王保刚,888.0王景祥788.7,889.02112.02112.0,890.0杰邦,891.0959.4959.4,892.0沈生焕,893.0海马,894.0,895.02476.42476.4,896.01398.4,李光银,898.0,899.0王丽蓉,922.5,901.0,902.0,903.0,904.0张海燕3685.03685.0,905.0,906.0,907.0,908.02472.42472.4,909.02772.02772.0,911.0,913.0,914.02058.02058.0,915.0,916.0思霏厂686.8,917.01816.651791.5,918.0148.2148.2,919.0易廷尚,921.0,922.0,柳冬伟,924.0,925.01867.51867.5,926.0,927.0张海燕,928.0黄佑全,929.0,931.0,932.0,郑安华,934.0梁宝容,935.0焦传会,谢容,937.0,938.0,939.0廖青松771.0,941.0刘洋,942.0,944.0,张艳霞,946.0,947.0847.0,948.0黄芬林,949.0周阳,951.0赵老板997.2997.0,952.0,953.0肖建光,954.0,955.0,956.0,957.0,958.0曹太胜7928.07928.0,959.0罗旺,1425.61425.6,961.0,潘淳科6271.26217.0,963.044072.0,44072.01475.18,965.0方寸五金,林周华,967.0,968.0,969.0,971.01771.61771.6,972.0,973.0,974.0,976.0,977.0,978.0,979.0张小杰,2325.0,981.0,982.0,983.0胡晓夏,984.09234.09234.0,985.0,986.0冯在国,987.0石昌强1875.01875.0,989.0895.7895.7,991.0,992.0,993.0,994.0国小燕,995.0524.8524.0,996.0永滔材料店,997.0鸿上五金2002.5,998.02097.02097.0,999.0张井祥,王凤鸣,1002.0张艳霞,1003.03928.753928.75,1004.0陈瑞靖,刘尚堃,1006.0刘清军,1007.0王继红,1008.0胡年华,1009.0王娟,1010.0谢林军,1011.0叶绍湖,1012.0,1013.0白小炎,1014.0,2863.02863.0,1016.0杨德广,1017.0,1018.0朱谦,1019.0李洋,1021.0,1022.0刘先荣,1023.0谭老板,1024.0,1025.0谢文亮,1026.0棕鑫1980.01980.0,1027.02088.02088.0,1028.02181.62181.0,刘奇,1031.0591.5591.5,1032.0周团结,1033.0,1034.0陈鹏飞,1036.0陈勇1,1037.0唐全其,1038.03586.03586.0,1039.0高华彪,11114.810975.0,1041.0,1042.0,1043.01925.01925.0,骆玲3900.03900.0,1045.0,1046.06188.8,1047.0崔靖博,1048.0,1049.0李冬红,1051.0蒋美周4063.54063.0,1052.03962.4,1053.0,1054.0邬利清5196.45190.0,1055.04857.64835.6,1056.0曾友平,1057.0吴胜和3030.03030.0,1058.0,1059.0,虞雅锋,1061.0石军华,1062.0,1063.0277.5,1064.0彭智慧,1066.0董泽恒,1067.0杨晓忠,1069.0,1070.0,1071.0,1072.0邝焕强4661.554660.55,1073.0邹云英,1074.0,1075.0何元斌,1076.0佰瑞兰,1077.0,1078.0,1079.0余静5723.95720.0,1081.0陈晓真,1082.0,1083.0,1084.02055.02055.0,1085.0杨三湖,1086.0,1087.0,1088.0,1089.04554.04550.0,1090.0,1091.0黄于晖,1092.0,1093.0舒馨寝具,1094.0,1095.0肖新才,1096.0,1097.0,1098.0杜奋兴,1099.0方淑平3948.83948.8,何夏飞12056.8,1101.0谢兵5209.1,1102.0周德友,1103.0江承正,3391.23391.0,1106.0洪新辉,高素英,1108.0,1109.0,1111.0刘文标,1112.0,1113.01219.21219.2,1114.0210.6,1115.0,1116.0谢新文,1117.0,1118.0覃光银,1119.0,1121.0张权兵,黄其龙,1123.0蒋贤耀,1124.0622.3622.0,冯于波,1126.0谢信和,1127.0优感睡眠,1128.01512.0,1129.0,许文礼,1131.0蒋老板,1132.0邝素,徐高福,1135.0邓功斌,1136.01310.0,1137.0周衡岳5856.55856.5,1138.0,1139.0,王应俊,1141.0李业龙,1142.0刘付闯,1143.06072.46072.4,1144.0,1145.0,1147.0范振杰,1148.0李立娟,1149.0陈成礼,1151.0唐江林,杨舜豪,1153.09857.49857.4,1154.0谢赛君,1156.0何元斌,1157.0,1158.03253.63253.6,1159.07807.47807.4,17153.517153.5,1161.04518.84518.8,1162.0朱周利1840.0,1163.0,1164.0张马庆3396.63390.0,1165.0熊晓东,1166.0,1167.0罗会伍,1168.0鄢海南,1169.0李昂,1171.0,1172.02544.02544.0,1173.0,1174.0姬英才1214.41214.0,1175.0,1176.0庞邦富,1177.06080.06080.0,1178.05160.05160.0,1179.020406.620374.5,1180.0,1181.0吴继灿2494.02494.0,1182.0陈雪3435.03435.0,1183.0,1184.0,1185.01648.81620.2,1186.0易建武,1187.06551.86551.8,1188.0,1189.0李立娟,832.5,1191.0于绍岭1774.51774.0,1192.0,1193.01146.61119.0,1194.011660.0,1195.0,1196.0,1197.0赵易成,1198.0,1199.06256.5,1201.0卢则猛,1202.0戴港2240.02240.0,1203.0,2080.82080.8,1205.0陈静,1206.0李桂芬1085.951084.8,1207.0,1208.0,1209.01255.21255.2,1210.04602.54600.5,1211.0涂国红,1212.09120.09120.0,1213.0刘成保,1214.02508.02507.3,1215.0,1216.0,1217.06390.06390.0,1218.0,1219.0,秦洪美,1221.0丁红义,1222.0祝有良,1223.0176.3,1224.0,熊灯云,1226.0842.8842.8,1227.0嘉豪五金707.2707.2,1228.03775.0,1229.0邓俊强,李业龙,1231.0,3007.23007.2,1233.0,1234.0李勇,1235.0秦梓豪,1236.04410.04410.0,1237.0鲁权,1238.0,1239.0,1240.0,1241.0肖同军933.3,1242.05025.05025.0,1243.0向美,1244.0,1245.0,1247.0,1249.0姚正刚1863.01863.0,单继英3565.83565.8,1251.0王佳祥887.5,1252.07216.57216.5,1253.0永坚,1254.0罗柏林,1255.03128.03128.0,1256.0关观荣,1257.0戴港,1258.0杨正根2511.62511.6,1259.0思霏厂,1261.0罗英布艺,1262.0,1263.0谢远鑫,1264.01017.5,1265.02475.02475.0,1266.0肖林中,1267.0,1268.0谭静文2989.02989.0,1269.0吴灿,1270.0,1271.03960.03960.0,4725.04725.0,1273.0黎兆丰,1274.0李凤振,杨老板,3528.0,1277.0郑安华,1278.0卢亿,1279.0林丰,徐锰,1282.0,1283.0,1284.0李辉林,1285.0,1286.0王义兴,1287.0,1288.0黎志杰,1289.03056.03056.0,1290.0,1291.0李尚彬,1292.0,1293.0夏平涛,1294.01406.0,1296.0张德怀2464.02464.0,1297.0王应俊952.5952.5,1298.0,1299.0,33107.533100.0,1301.0王玉峰,1302.03040.03040.0,1303.0恩洳五金,1304.03701.4,1305.0唐云生,1306.04210.04210.0,1307.0646.8646.8,1308.0,1309.0奉小洁,1310.0,1311.0任军涛,1313.0梁久华,1314.0陈应亮,1315.0,1316.03405.6,1317.02087.4,1318.0蒙艳明,1319.04400.0,1321.03460.83460.8,1322.0方忠清（老板娘）,1323.0,1324.0陈应亮,1325.0,罗征,1327.03696.0,1328.0,1329.0柏子权,石小磊,1331.0周宇方杨,1333.0,1334.0曾志忠,1335.0李文勇3610.83610.1,1336.02161.5,1337.0童学英,1338.0,1339.01475.0,1340.0,1341.0,1342.05433.93,1343.01742.41742.4,桂妃631.4631.0,1345.0恒昌,1346.0兴达五金,1347.0杜移万6900.06900.0,1348.02320.0,1349.0潘峰2852.52852.5,任泽红,1351.0邱平厂,1352.0郭松斌,1353.0,1354.0,1355.0,1356.0余彬,1357.0,1358.0,1359.0,1360.01702.4,1361.0,1362.0,1363.0粤胜,1364.0,1365.0,1366.0康之宝3411.0,1367.0孙淑峰,1369.0,1370.06885.0,1371.0刘虎,1418.41418.4,1373.0崔靖博2744.0,1374.01070.3,1375.0李逢胜,1377.01855.11855.1,1378.0,1379.04074.0,1381.0陈拥军,1382.0,1383.0,1384.0颜志凯3020.03020.0,1385.04050.0,1387.0李佑文,1388.0,1389.0曾祥雪,1390.0陈瑞靖,1391.013159.8,1392.0,1393.0,1394.0肖国忠,1395.0,1396.0李洪全,1397.0陈建龙,1398.0李凤振7140.07140.0,1399.0罗镇辉,雷天顺,1401.0517.5,1402.0,1403.0,1404.0杨大君,1405.0名顺门市,1406.0吴余根,1407.0,1408.02060.0,1409.0,赖春茂,1411.0,1412.0林丰2649.1,1413.0,1414.0,1415.0小马辅料,1416.0刘勤军,1417.0杨仰细95.094.5,1418.01054.8,1419.0,1420.0蒋平生,1421.0,1422.0陈裕康,1423.0杨志东,831.9831.7,名顺门市,1426.0王多好,1427.0蒋兵兵,1428.0合肥王斌,1429.0纪春花,1431.01218.0,1432.0王玉英,1433.02850.02850.0,1434.0李秋菊,1435.0873.0,1436.07188.487188.48,1437.0郑淼升,1438.0周礼,1439.0,1190.8,1441.0王海军,1442.0庞战强4560.04560.0,1443.0王吉发,1444.0程林辉,1445.0袁志刚,1446.0,1447.06702.26700.0,1448.02860.02860.0,1449.0,2103.02103.0,1451.0周书建,1452.0,1453.0刘虎,1454.0,1455.0,1456.0叶瑞龙,1457.0王子高,2796.82796.8,1459.0,1460.0,1461.04300.04300.0,1462.0梁晓霞,1463.0沈鹏,1464.0段志鹏,1465.01886.8,1466.0闵浩19815.0,1467.0,1468.0睡王,1469.0,张俊,1471.0蒋腾伟2065.02065.0,1472.0孙书桂,1473.01365.0,1474.0魏剑锋,1475.0,917.7917.7,1477.012177.012177.0,1478.0,1479.0王丽蓉（大龙）,1481.0黎威1795.2,1482.0,1483.0,1484.01216.01210.0,1485.0,1486.0747.3747.0,1487.0黄冬虹,3936.03936.0,1489.0蔡莉虹,1490.0,1491.0,1492.0郑如俊,1493.0刘成保,1494.0马庆凯,1495.0宏昌3515.4,1496.01388.64,1497.07210.07210.0,1498.0,1499.0刘燕6123.0,黎兆丰2650.02650.0,1501.0高州张超,1502.0王德,1503.0李昂,1504.0,李浩,1506.0周维刚4200.04200.0,1507.0596.8,1508.0,1509.0穗宝尊品,1510.0,1511.0,1512.0,1513.02567.5,1514.0周延定,1515.0,1516.0391.5391.0,1517.0涂国红,1518.0周宏丽,1519.0,李金秀,1521.0高伯阳,1522.014100.014100.0,1523.0,1524.0,何杨梅,1526.0,1527.0,1528.01622.41622.0,1529.0,焦传会,1531.012567.8,1532.0李锐龙2226.02226.0,1533.0王兆营3144.03144.0,1534.0,1535.0,李佑文,1537.0戴英洪,1538.0,1539.0张清全,李老板,1541.0,1542.0,1543.0张小杰,1544.0刘先荣,1546.0,1547.0,1548.0李锐龙,1549.0王振华,杨勇,1551.0李生2355.0,1552.0,1553.0杨荣初,1554.0,1555.0葛星,1556.0,1557.0杜志怀,1558.015593.6,1559.0,494.0,1561.0,1562.06510.06510.0,1563.01058.4,1564.02050.0,1565.0,1566.05985.0,1567.01341.6,1568.01827.01827.0,1569.0,1570.0黄长华,1571.0韦国将,1572.01564.0,1573.06311.5,1574.0丽豪,1575.0刘林（重庆）,1576.0黄天丽,1577.0,1578.0,1579.0,1580.0,1581.0,1582.0,1583.0杨正根753.5753.0,1584.0雷天顺,1585.0谢兆民,1586.010584.0,1587.0,1588.0,1589.0,1590.0,1591.0任浏生,1592.0宏昌8184.0,1593.0,1594.0,1595.0,1596.0,1597.0,1598.01037.4,1599.0孔小姐,1601.0王斌2750.0,1602.0,1603.0王柏涛,1604.0765.0,高伯阳,1606.0,1607.0,1608.0周龙辉,1609.0,489.5489.0,1611.0,1612.0闫雪松,1613.0,1614.0张朝辉,1936.0,1616.0,1617.01056.0,1618.03648.0,1619.0杨冬飞,1621.01479.0,1622.06775.2,1623.0赵老板2080.02080.0,1625.0,1626.0,1627.0,1628.0,1629.0古均,1630.0秦洪金,1631.0谭波,1633.0老王,1634.0林培龙,1635.0陈大收,1636.0王丽蓉（大龙）,1637.0,1638.0686.4,1639.0杜奋兴,1640.0周宇方杨,1641.05712.0,1642.0,1643.0,1644.0,1645.0谢建新,1646.0,1647.0宋静4153.6,1648.0龙波,1649.0梦安,梁后友,1651.0曾福,1652.0,1653.0梦菲菲2478.02478.0,1654.0项亮,1655.02660.0,1656.0詹平全,1657.0,1658.02888.4,1659.0肖海华,1660.01290.0,1661.0蒋祖镇1170.24,1662.0顺景五金,1663.0晋心举2233.02233.0,1664.0钱乐,1665.01435.0,1666.0王应磊,1667.0彼得,1668.0利质,1669.0廖荫良2150.02150.0,1670.0,1671.0,1672.0凌维,1673.0赵士权,1674.0陈健,1675.0华顺2385.02385.0,1676.0,1677.0,1678.0,1679.0,2355.6,1681.0,1682.0叶文,1683.0李老板,1684.0张权兵,1685.01173.2,1686.0,1687.07116.2,1688.0,1689.0叶成,1690.0熊文政,1691.02600.0,1692.0王俊,1693.0黄天丽,1694.05475.0,1695.0梁华满,1696.0曾德锷870.0,1697.0,1698.0和兴1836.01836.0,1699.0曾志忠,1701.0刘文标,1702.0周老哥3024.03024.0,1703.0朱胜标1818.01818.0,1704.01106.0,1705.0悦安五金,1706.0周世放,1707.0,1708.06580.0,1709.0唐亮,1711.0496.4,1712.0,1713.01880.0,1714.0,1715.0陈生,1716.0江航,1717.0陈礼桥,1718.0,1719.0林伟贤,1721.06973.0,1722.0,1723.0,1724.0姚兆峰6226.2,1725.0陈能利4199.04199.0,1726.0高军,1727.0,王晓良2440.0,1729.0,1730.01940.0,1731.0,1732.0胡华纤,1733.01057.81057.8,1734.0陈佳杰7755.0,1735.0,2060.0,1737.0,1738.0邹雄威990.6990.6,1739.0,1740.0杨德广,1741.0,1742.0慕洁伍生,1743.0,1744.0许艳梅12250.0,1745.0815.0,1746.05328.0,1747.0蔡莉虹2550.0,1748.01385.8,1749.0,杨林仁,1751.0,1752.0,1753.05518.0,1754.0黄丽平,郑文超,1756.0王奇,1757.0582.0,1758.0蒙世友,1759.0覃光银,高峰,1761.0廖青松1198.51198.5,1762.0肖德平,1763.0刘天昆,1764.0,1765.0舒顺,1766.04525.0,1767.0肖东军1708.0,1768.0金诚,1769.0,杨鸿庆,1771.0,1772.0章剑坤,1773.0韦国将,1774.0,廖忠云6540.06540.0,1776.0,1777.01372.8,1778.06240.0,1779.0李永忠2280.0,易廷平2673.0,,客户,数据统计累计金额等于客户全年下单金额合计使用方法：,1.先在《销售数据源》按格式粘贴销售数据；,2.在此表点击“客户”单元格，菜单栏——分析——刷新数据；,3.公式不够用可选择后往下拖拉复制使用；,4.在《客户等级设定》表中设定各登记的评定标准；,收款占比等于客户全年累计收款金额/全年下单金额*100%,来单频率客户全年来单月份次数,客户9.012.0累计金额收款占比来单频率统计结果客户评级,安悦694.2694.20.999711898588,白小炎,佰瑞兰,柏子权,彼得,卞兴红,博创1155.01320.0,博瑞,蔡波0.86,蔡敦富,蔡莉虹2550.04500.00.433333333333良好较差较差,蔡旭795.62010.05258.812384.40.825587028843,曹高辉,曹丽芝936.0936.00.99358974359,曹平,曹太胜7928.07928.0,曾德锷870.0870.0,曾福,曾海轩185.02025.0,曾汉强,曾卫,曾祥煊11337.4873.01880.018640.40.851773567091,曾祥雪,曾友平,曾震,曾志忠1480.02410.0,车超,陈成礼,陈大收,陈刚,陈洪普3430.00.577259475219中等较差合格,陈后宏,陈佳杰7755.07755.0,陈佳亮,陈建红3162.58229.01372.813814.30.304937637086,陈建龙276.0276.0,陈剑,陈健,陈江涛2070.02365.04435.00.998872604284,陈杰1156.952550.37557.250.821363591253,陈静,陈宽3060.01833.04893.00.988350705089,陈礼桥,陈能利2230.04199.06429.0,陈鹏飞,陈庆杰,陈瑞靖104.02575.02679.0,陈生,陈文浩6546.07106.00.0788066422741,陈晓真,陈雪3435.03435.0,陈依川7327.053514.160841.10.998905345235,陈应亮806.0806.0,陈拥军735.0735.0,陈勇,陈勇1,陈勇军,陈裕康,陈媛1216.03106.00.99806825499合格良好合格,程林辉1320.01445.0,楚佳,崔靖博228.02744.02972.00.0767160161507,崔伟霞18468.02179.59360.030007.50.688077980505,大莱,戴港3365.03365.0,戴英洪,单继英3565.83565.8,邓功斌,邓海斌,邓俊强,邓老板,邓树鼎,丁红义,丁胜325.0325.0,丁先秀,鼎昇10578.43290.014108.40.982988857702,董泽恒,董沾,杜奋兴0.142857142857,杜江水,杜移万6900.06900.0,杜云志,杜志怀,段良勇,段晓宽6908.86908.80.999884205651,段学东2502.5684.03186.5,段志鹏,恩洳五金1424.01424.0,樊佳397.13649.05176.1360.343140133876,范振杰,方寸五金912.0912.0,方明海465.04210.05215.00.192713326942,方淑平3948.83948.8,方忠清2960.0,方忠清（老板娘）,冯俊龙155.0155.0,冯丽娟,冯美丽1166.12056.10.999951364233,冯文浩962.04125.05087.0,冯文祥2918.22918.20.969947227743,冯孝金,冯于波,冯在国656.0656.0,冯志明6600.06600.0,奉小洁,付维军,傅自强6808.06808.00.998824911868,甘升,高波,高伯阳2570.0,高峰52.552.50.990476190476,高华彪,高辉煌,高军305.0305.0,高生355.0,高胜利110.0110.0,高素英951.75784.01735.750.989197753133,高天志2208.8686.44665.20.852868044242,高州张超,葛少童3768.09120.012888.0,葛星,耿小飞4326.21216.85543.00.999891755367,古均860.0,关观荣,桂妃0.999366487171,郭松斌,郭艳945.06256.56973.015224.50.0689677821932,郭又云1125.01254.53820.94882.515593.628026.50.0401405812356,郭志勇,国小燕,海臣,海马,海星,韩军408.02510.0,韩美芳2037.54294.61512.011244.10.302380804155,韩勤红3460.81250.06600.8,郝小姐1920.81920.80.999583506872,合肥王斌,何浩1734.31734.30.999827019547,何军2040.0,何帅书590.0,何夏飞12056.812056.8,何杨梅,何元斌,何泽芝1105.01105.0,和兴1836.01836.0,恒昌,恒达1804.01804.00.9977827051,宏昌3515.48184.011699.4,洪新辉,洪玉评2640.010050.012690.0,洪玉仕3470.73701.41488.014740.10.544819913026,鸿利0.979591836735,鸿上五金2002.52002.5,侯百强,胡峰2444.0,胡华纤,胡年华920.01830.0,胡若昭2620.02880.0,胡小东,胡晓夏1505.01505.0,华顺2385.02385.0,华欣泓915.0915.0,华鑫达3503.01170.05947.21005.02103.016528.20.494669716001,黄宝才,黄彩裕,黄成,黄定旺,黄冬虹,黄芬林,黄国维,黄老板2045.0168.03513.63040.011706.6,黄丽平,黄龙,黄其龙1476.01476.0,黄其圣1630.00.993865030675,黄泉良0.999935005849,黄胜,黄天丽1390.01390.00.115107913669,黄燕玲1764.01764.00.997732426304,黄幼华7014.68614.6,黄佑全,黄于晖,黄长华0.909090909091,姬英才1214.42114.40.999810821037,纪春花,佳德利夏先生,佳鑫,嘉豪五金707.2707.2,贾峰峰,贾志文,建华,江承正,江海潮1736.0796.5747.34074.80.999926376755,江航,江文,姜涛1552.02402.0,蒋兵兵,蒋海,蒋华山306.01011.0,蒋建华,蒋老板,蒋美周4063.54063.50.999876953365,蒋谋平1330.0,蒋平生,蒋腾伟2065.02065.0,蒋先顺,蒋贤耀984.00.548780487805,蒋志辉,蒋祖镇1170.241920.240.390576177978,焦传会,杰邦,金邦达5875.224.07281.64857.618038.40.998414493525,金诚,金汇鑫1507.51507.50.999668325041,金永洪1303.51303.50.997314921366,晋心举2233.02233.0,军华,骏兴639.01809.04363.00.581480632592,凯怡五金622.34517.45619.70.110682064879,康之宝3411.03415.00.00117130307467中等较差较差,孔小姐278.0278.0,匡小姐1712.01632.01290.04634.00.721622788088,邝达安,邝焕强1530.04661.556191.550.999838489554,邝素,赖春茂,赖冬梅4422.04296.01456.42660.013709.40.805943367325,赖金荣3070.0,兰汉林51.051.0,蓝松成535.00.934579439252,老王555.0555.0,雷天顺2290.00.829694323144,雷文法,雷文军,雷小龙,雷志强,黎生,黎威1795.21795.2,黎兆丰945.02650.03595.0,黎志杰,李昂,李冬红,李逢胜,李凤启1060.01960.0,李凤振7140.07452.00.999731615674,李光银,李桂芬1085.951085.950.998941019384,李浩2196.03596.0,李洪全,李辉林,李金秀,李军218.01568.0,李俊帮,李老板219.0769.0,李立娟,李平,李庆,李秋菊1545.01545.0,李秋明,李锐龙3176.03176.0,李山峰,李尚彬,李生,李世国,李巍486.01610.02096.0,李维凡6268.56268.5,李文勇3610.83610.80.999806137144,李霞,李雪梅,李亚运,李洋1.02564102564,李业龙725.02075.0,李永元,李永忠2280.02280.0,李勇,李佑文,李悦龙,李中河,立盛,丽豪1344.01344.00.989583333333,利质,良田66.066.0,梁宝容55.0445.0,梁兵,梁后友,梁华满,梁久华,梁小军1250.0,梁晓霞,梁雪英,廖冬林,廖凤英1015.01015.0,廖平凡6420.014840.0,廖青松771.01198.51969.50.999492256918,廖信彩14880.05328.022708.00.76536903294,廖荫良2150.02150.0,廖忠云6540.06540.0,林二勇1276.01925.06001.0,林丰3360.02649.16009.1,林胡8162.03596.212974.512241.537594.20.99868703151,林培龙561.0561.00.999108734403,林荣,林思珍,林斯俊,林斯武,林伟贤,林智明,林周华505.0505.0,凌维,刘超,刘成保3920.0,刘峰,刘付闯625.0,刘光兵7073.04323.01755.014693.0,刘桂贤2180.0,刘国兰7807.42161.510058.90.999850878327,刘虎705.01585.0,刘辉辉,刘辉庆10758.810758.8,刘吉良,刘锦,刘立雨185.0,刘林5035.00.746772591857,刘林（重庆）,刘明军,刘奇,刘勤军,刘清军,刘尚堃,刘世,刘天昆,刘添4100.05780.0,刘万兵,刘伟2182.042.51898.85953.30.773100633262,刘文标4080.0,刘先荣156.0291.00.979381443299,刘新3141.553141.550.99759672773,刘燕4366.36123.010489.30.416233685756,刘洋,刘玉1702.85811.015179.256586.44827224.2489237093.4636447.419964.422186.623796.438227.6234219.606920.677198211566优质合格良好,柳德志984.2984.20.99979678927,柳冬伟,龙波,龙连忠2217.63512.60.999829186358,龙新科0.5,龙友,卢德芳1722.02320.013159.817201.80.100105802881,卢晓华875.52605.50.612358472462合格合格合格,卢亿,卢则猛,鲁常良92.092.0,鲁翠玖455.03355.0中等优质合格,鲁权0.265536723164,鲁智辉,陆丽清4500.08075.012575.00.357852882704,陆亚东,路文兵802.5802.50.996884735202,伦敦道1090.04570.00.923413566749.0良好良好中等,罗柏林,罗波,罗成五金,罗方平,罗会伍,罗金贵5040.02048.03128.010216.0,罗老板1010.01010.0,罗林丽,罗润涛,罗旺,罗文珍,罗雄,罗义贤2181.64071.60.999852637784,罗英布艺943.0943.0,罗永树,罗泽红,罗镇辉,罗征,骆玲3700.03900.07600.0,马福久1146.01146.0,马来西亚王小姐0.971428571429,马庆凯,马逍阳0.998263888889,马志刚7000.0,满松珊,毛建设2360.01910.01330.02623.52822.43760.017205.90.781470309603,毛先生6803.59376.06390.07360.029929.50.753971833809,蒙世友,蒙旭丰,蒙艳明,孟磊,孟治友,梦安3120.03120.0,梦菲菲2478.02478.0,闵浩19815.019815.0,闵建中,名顺门市385.0385.0,牟伟兰,慕洁伍生,倪世明1068.02063.0,宁亮亮6467.51724.08191.50.999084416773,潘超0.946666666667,潘淳科826.06271.27097.20.992363185482,潘发1462.01462.0,潘峰2852.52852.5,庞邦富1452.0,庞战强4560.04560.0,彭小姐,彭晓琳78.078.0,彭智慧1246.01758.0,蓬格莱1107.02197.0,千百利,钱乐,秦洪金5600.0,秦洪美17.017.0,秦继红4155.11886.86041.90.687714129661优质合格较差,秦梓豪1230.01230.0,邱海,邱平厂,屈超云1722.53192.5,屈老板3889.66396.0468.08516.225969.80.464139115434,屈先学,任承渐,任承尚,任军涛,任浏生,任士民1557.51557.50.999678972713,任泽红,茹宇16060.016760.00.0417661097852,睿兴1510.0,申亮军,沈鹏,沈生焕,圣帝奴1092.02642.0,盛秋红,施明加,石昌强,石军华,石小磊,寿红超,舒顺,舒馨寝具,舒玉,睡王,顺景五金,司小姐1860.0465.01035.00.744444444444,思霏厂686.81366.80.995024875622,宋洪福5626.45626.4,宋静4153.64153.6良好较差较差,宋新华,宋勇,苏三九,苏迎秋,穗宝尊品535.0,穗宁774.01814.00.988974641676,孙彪725.51310.01475.04230.50.170192648623,孙崇新3036.05398.48434.40.359954472162,孙少东923.0723.91736.9,孙书桂,孙淑峰,孙永刚,索爱,覃光银,谭波1585.00.227129337539,谭代新5060.02964.88059.80.00434253951711,谭静文1878.82989.04867.80.999876741033,谭菊4406.410102.514508.90.999800122683,谭老板,谭新军,谭玉龙,唐江林,唐亮3075.0,唐强,唐全其,唐有财3586.06702.22217.813916.00.980439781546,唐云生,陶文杰,腾飞1620.01620.0,天隆1180.00.78813559322较差中等合格,天美五金,添发贸易2754.03880.012634.0,田定胜0.991452991453,田炎辉,童学英1525.01525.0,涂昌喜,涂国红,汪敏114.01452.0,汪毅德,王柏涛,王保刚,王斌2750.02750.0,王传红8250.08250.0,王春龙,王德,王多好,王凤鸣,王海军105.01005.0,王洪江1938.91425.612446.89607.813363.41936.041738.50.630096912922,王吉发,王继红,王佳祥887.5887.5,王建房,王剑英7116.87116.81.00002810252,王姐,王景祥788.7788.70.988969189806,王娟,王俊,王老板1104.01104.0966.0885.66072.47188.4817885.48优质优质中等,王礼平3367.06867.0,王丽蓉510.0510.0,王丽蓉（大龙）453.02453.0,王铭晟1395.01945.0,王奇,王琪2475.04545.0良好优质合格,王如春1012.08500.04410.013922.00.99985634248,王胜,王伟1605.03499.27024.20.931664815922,王武权,王希龙1290.0590.01880.0,王晓良2440.02440.0,王新887.4887.40.999549244985,王秀,王义兴1.01785714286,王应俊952.51402.5,王应磊0.653846153846良好合格较差,王永年,王玉峰1725.0,王玉英,王云倪,王占武,王长德747.5747.50.989966555184,王兆营3144.03144.0,王振华,王志强,王子高,旺隆944.0105.0644.03091.25129.013887.20.999301515064,韦国将432.0432.0,维生,魏剑锋,魏生94.0334.0,魏思思940.8940.8,邬利清5196.45196.40.998768378108,吴斌,吴灿,吴刚1299.41299.4,吴继灿2494.02494.0,吴军,吴胜和5700.03030.08730.0,吴伍凤,吴亚娣,吴燕州,吴永红2326.82326.8,吴余根,伍杰华295.0,武旗,夏平涛4320.04970.0,香港何小姐8928.01565.0560.55336.03951.325750.80.845973717321,香港彭生,祥恒丰3010.06800.04818.534801.122566.252472.413283.7510348.83271.56974.088346.320.902034176409,向金方890.61610.01990.04490.6良好优质合格,向美,向志民4030.01138.55168.5,项亮,小曾,小马辅料,肖德平,肖东军1708.01708.0,肖国忠,肖海华,肖建光,肖建雄,肖林中0.481481481481,肖天生,肖天勇,肖同军933.3933.30.999678559949,肖新才,肖星吉,谢兵5209.15209.10.99825305715,谢建新,谢连意1555.0,谢林军,谢凌峰1458.01458.0,谢容,谢赛君,谢文5791.25791.2,谢文亮,谢小军,谢新文,谢信和75.075.0,谢远鑫,谢兆民,谢忠萍,欣峰1728.02563.21072.08944.60.734655546363,兴达,兴达五金0.381443298969,熊灯云,熊金湖0.990476190476,熊强6188.85985.05518.019141.8,熊胜,熊文政,熊晓东,徐高福,徐军明8400.010060.01827.028657.0,徐锰,徐伟斌3174.44304.40.999907071833,许大文4338.44338.40.999907800111,许富民,许和胜1296.01296.0,许文礼174.0824.0,许艳梅12250.012940.00.0533230293663,薛继红,薛坤,雅兰,亚菲1270.0,鄢海南,鄢勇3675.012369.56080.022124.5,闫雪松1660.0,严胜2053.62053.61.0001947799,颜龙三12029.79779.45160.01435.028404.10.949479124493,颜志凯10200.03020.013220.0,晏杨威,杨北余743.42050.08108.40.595925213359,杨大君,杨德广,杨冬飞2795.0,杨飞鹏,杨峰五金5205.62973.01082.91044.0644.017153.526103.020.999539516883,杨光秋,杨鸿庆,杨老板,杨林仁1065.01065.0,杨琪3352.43352.40.999880682496,杨清明2200.02200.0,杨荣初,杨三湖990.0990.0,杨舜豪,杨习波1516.68487.51480.0740.05064.180.853875652129,杨晓忠,杨仰细0.994736842105,杨银才1244.41244.4,杨颖,杨勇,杨渊,杨正根2511.6753.53265.10.999846865333,杨志东,姚慧敏1386.03672.05058.0,姚林明640.0640.0,姚生,姚兆峰6226.26226.2,姚正刚1863.01863.0,窑金1603.01603.00.998128509046,叶兵3195.00.66510172144合格合格合格,叶成,叶瑞龙,叶绍湖,叶文,叶小华524.81017.51572.30.9979011639,艺林0.9,易建武,易廷平2673.02673.0,易廷尚,翼焕冬805.0805.0,应后从,应团保1196.61196.6,英琪五金3027.41218.01173.25643.60.0398681692537,盈俊织带,永坚245.01995.0,永隆五金3045.01784.04829.0,永盛2660.03452.0,永滔材料店,优感睡眠,于山友,于绍岭1774.51774.50.999718230487,余彬,余宏金2315.922366.01970.712215.05480.06240.031099.620.620013685055,余建国1143.91143.90.999213217939,余静1133.05723.96856.90.999431229856,余军2340.03090.0,虞雅锋,员海军3224.03224.0中等较差较差,袁杰2610.02610.0,袁志刚,袁忠余,苑敏7000.0,苑文乐625.0,岳瑛576.0576.0,悦安五金,粤胜,詹平全,张阿南,张朝辉,张德怀2464.02464.0,张栋材452.0452.0,张二科6746.46746.40.999940709119,张国建,张国强1673.651673.650.997819137813,张海燕4765.04765.0,张洪全,张华2169.02169.0,张怀1151.01151.0,张辉,张杰4180.192563.63328.465433.93435.02937.618878.780.533512229074,张井祥,张俊,张老板,张亮365.0237.5602.50.605809128631较差合格较差,张马庆3396.63396.60.99805688041,张敏,张南宽594.0594.0,张清全,张权兵,张善珍1615.09234.0496.411345.40.956246584519,张霞130.0130.0,张先建,张贤忠,张小杰,张雪,张艳霞,张易军54.054.0,张泽芳261.6261.6,章剑坤324.0324.0,章小峰489.54689.50.999893378825,兆纵2140.02140.0,赵德顺,赵德治5960.072574.7041360.04825.0277.51058.43080.019010.676优质较差中等,赵二2380.04246.11283.25518.42316.86011.810574.76598.713208.714258.967397.30.830148685481,赵老板997.22080.00.999935005849,赵士权1326.01461.00.907597535934,赵司9246.09359.95455.01719.05240.09825.215000.77096.09005.072266.80.856348973526,赵伟,赵易成215.0215.0,振扬,郑安华40.055.0,郑洪,郑开星,郑隆奇1607.2145.02152.20.999907071833,郑淼升,郑如俊,郑文超5550.07850.0,志胜0.989898989899,中和,钟海滨340.0340.0,钟孟生1550.0815.03665.00.777626193724,周超575.0575.0,周成忠,周德友,周广健12.04143.01238.05863.0,周衡岳5856.55856.5,周宏丽2285.0,周建春204.0204.0,周奎1008.91847.12567.55423.50.995667004702,周老哥3024.03024.0,周磊2560.02560.0,周礼,周龙辉,周琪657.01967.0,周世放,周书建0.0441176470588,周团结376.0376.0,周维刚4200.04200.0,周小平,周延定,周延新0.989898989899,周阳,周业陈,周友国1140.00.8,周宇方杨1134.01369.0,朱斌847.5847.5,朱金保,朱锦辉1990.03387.67500.63620.02428.6422696.840.47661260334,朱梦亚,朱谦,朱胜标1818.01818.0,朱卫强,朱运顺744.0744.0,朱振重5550.06820.0,朱周利3080.01840.04920.00.626016260163良好合格较差,祝有良402.0402.0,卓建清,棕鑫1980.01980.0,棕星,邹雄威990.6990.6,邹云英,(空白),总计,,客户等级设定使用方法：,1. 按以下备注、参考值提示录入各项指标评级值；,评核标准级别参考占比参考值设定值级别简称参考值/评级说明备注,订单金额人均金额=总金额/总人数,人均金额*参考占比得出参考值（取整数）1.起步级别设定值必须为：0,2.设定值为必填项目，可通过调整参考占比后根据参考值录入设定值，亦可以直接录入设定值；,,2100.02500.0,0.852900.03200.0,0.983400.03500.0,5200.05800.0,收款占比平均收款占比：全年累计收款金额/全年累计订单金额,平均收款占比*参考占比得出参考值（参考值>100%,按100%计算）,0.4694,0.850.6650.7,0.980.76670.8,来单频率平均收款占比：全年累计收款金额/全年累计订单金额,平均收款占比*参考占比得出参考值（参考值>100%,按100%计算）,0.81.31632653061,1.21.974489795928.0,2.468112244910.0,3.55.7589285714312.0,出现情况客户评级订单金额收款来单,较差较差较差不合作客户,较差较差合格,较差较差中等,较差较差良好,较差较差优质,较差合格较差,较差合格合格,较差合格中等,较差合格良好,较差合格优质,较差中等较差,较差中等合格,较差中等中等,较差中等良好,较差中等优质,较差良好较差一般客户,较差良好合格,较差良好中等,较差良好良好,较差良好优质,较差优质较差,较差优质合格,较差优质中等,较差优质良好,较差优质优质,合格较差较差,合格较差合格,合格较差中等,合格较差良好,合格较差优质,合格合格较差,合格合格合格,合格合格中等,合格合格良好,合格合格优质,合格中等较差,合格中等合格,合格中等中等,合格中等良好,合格中等优质,合格良好较差,合格良好合格,合格良好中等,合格良好良好,合格良好优质,合格优质较差,合格优质合格,合格优质中等,合格优质良好,合格优质优质,中等较差较差,中等较差合格,中等较差中等,中等较差良好,中等较差优质,中等合格较差,中等合格合格,中等合格中等,中等合格良好,中等合格优质,中等中等较差,中等中等合格,中等中等中等,中等中等良好,中等中等优质,中等良好较差,中等良好合格,中等良好中等,中等良好良好,中等良好优质,中等优质较差,中等优质合格,中等优质中等,中等优质良好,中等优质优质,良好较差较差一般客户,良好较差合格,良好较差中等,良好较差良好,良好较差优质,良好合格较差,良好合格合格,良好合格中等,良好合格良好,良好合格优质,良好中等较差,良好中等合格,良好中等中等,良好中等良好,良好中等优质,良好良好较差,良好良好合格,良好良好中等,良好良好良好,良好良好优质,良好优质较差,良好优质合格,良好优质中等,良好优质良好,良好优质优质,优质较差较差,优质较差合格,优质较差中等,优质较差良好,优质较差优质,优质合格较差,优质合格合格,优质合格中等,优质合格良好,优质合格优质,优质中等较差,优质中等合格,优质中等中等,优质中等良好,优质中等优质,优质良好较差,优质良好合格,优质良好中等,优质良好良好,优质良好优质,优质优质较差,优质优质合格,优质优质中等,优质优质良好,优质优质优质优质客户,,分析结果使用方法：,1.先在《销售数据源》按格式粘贴销售数据；,2.在此表点击“客户评级”单元格，菜单栏——分析——刷新数据；,3.公式不够用可选择后往下拖拉复制使用；,客户评级人数人数占比总营业额人均营业额营业额占比,不合作客户35.00.044642857142941074.241173.549714290.0151708229395,高信用可发展客户3.00.0038265306122412390.64130.20.00457648391582,可发展客户50.00.0637755102041759121.4869215182.42973840.280382489552,可营销客户20.00.0255102040816343298.1717164.90850.126797617011,普通客户531.00.677295918367797068.221501.070094160.294398163821,需催款客户22.00.0280612244898279190.53212690.47872730.103119379138,需营销客户57.00.0727040816327247871.354348.620175440.0915515993146,一般客户45.00.057397959183758114.351291.430.0214646093049,一次性客户8.00.010204081632721556.52694.56250.00796192077312,疑似流失客户13.00.0165816326531147764.2511366.48076920.05457691423,优质客户,(空白),总计
  • 客户等级分析（多维度）-表格模板
  • 客户等级分析（多维度）-表格模板
  • 客户等级分析（多维度）-表格模板
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
客户分析表.xlsx
客户分析表.xlsx

客户分析表

客户来源地分析（可视化图表，商务蓝灰）.xlsx
客户来源地分析（可视化图表，商务蓝灰）.xlsx

客户来源地分析（可视化图表，商务蓝灰）

客户交易明细分析表.xlsx
客户交易明细分析表.xlsx

客户交易明细分析表

客户来源地分析（可视化图表，商务蓝白）.xlsx
客户来源地分析（可视化图表，商务蓝白）.xlsx

客户来源地分析（可视化图表，商务蓝白）

外贸询价询盘客户需求分析记录表.xlsx
外贸询价询盘客户需求分析记录表.xlsx

外贸询价询盘客户需求分析记录表

客户跟进管理表.xlsx
客户跟进管理表.xlsx

客户跟进管理表

销售部意向客户来源渠道分析.xlsx
销售部意向客户来源渠道分析.xlsx

销售部意向客户来源渠道分析

成交客户分级评价表（含指标说明自动评分等级）.xlsx
成交客户分级评价表（含指标说明自动评分等级）.xlsx

成交客户分级评价表（含指标说明自动评分等级）

电商客户新增情况分析图表.xlsx
电商客户新增情况分析图表.xlsx

电商客户新增情况分析图表

客户管理跟进系统.xlsx
客户管理跟进系统.xlsx

客户管理跟进系统

客户分析表.xlsx
客户分析表.xlsx

客户分析表

客户登记表（不同等级）.xlsx
客户登记表（不同等级）.xlsx

客户登记表（不同等级）

模板单价：￥14.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以14.99元购买此模板
  • 页数：4页
  • 时间：2021-01-13
  • 编号：20553823
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

Angelina

设计作品1818 独家高品质原创文档

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服