利用Excel做RFM客戶細(xì)分的模擬數(shù)據(jù)

1、銷售類型(全部)最大值最小值值值行行標(biāo)標(biāo)簽簽最最大大值值項(xiàng)項(xiàng): :收收銀銀時(shí)時(shí)間間計(jì)計(jì)數(shù)數(shù)項(xiàng)項(xiàng): :記記錄錄IDID平平均均值值項(xiàng)項(xiàng): :銷銷售售金金額額01000117/09/201027123.4801000203/07/20101891.7801000328/08/201025137.4001000429/08/201030110.4001000518/08/201014151.3601000609/07/201017109.3501000722/09/201026152.3501000822/09/201035110.1401000903/08/201019171.4201001015

2、/09/201022106.0501001124/09/201023156.0401001211/09/201027173.1901001319/08/201024117.7501001402/09/201031152.2901001505/08/201025148.9601001607/09/201024168.8801001723/09/20102668.9601001827/07/201028103.7101001918/09/201020187.7001002024/09/20102081.5001002123/09/20102470.2101002218/09/201019110.2

3、101002314/09/201025180.8801002412/09/201031211.9401002516/09/201022133.6401002610/09/201025111.7201002716/07/201018164.7801002823/09/20101894.1101002914/09/20103287.2201003007/09/20102179.5201003101/09/201016187.8101003221/09/201019152.4201003328/08/201026147.8501003430/08/201025145.4801003502/09/20

4、1024212.4601003608/09/20101896.3301003704/09/201020116.6501003823/09/201027117.5401003905/09/20103086.1501004015/09/201021111.7601004115/08/20102090.8001004210/09/201030137.1701004318/09/201016107.4401004422/09/201020173.2501004507/09/201027153.8901004623/09/201026131.0001004720/09/201024100.6701004

5、813/09/201028140.3201004904/09/201014135.7901005015/09/201030122.9701005109/09/20102780.1101005207/08/20102495.6301005312/09/201021112.6701005424/09/201028188.1101005506/09/201023144.3501005606/08/201026108.5801005718/09/201020196.8501005804/09/201016150.6901005925/08/201022148.6801006001/09/2010166

6、2.6301006108/09/201022156.9501006224/09/201022116.2301006313/09/201026129.8501006404/09/201020173.1501006523/09/201017164.0001006623/09/201020151.1501006714/08/201021148.4801006819/09/201021153.0501006924/09/20102647.8101007023/09/201030146.9701007123/09/201018164.0001007210/09/201016103.5001007309/

7、08/201029104.6901007409/09/201019140.2401007522/09/201021112.2401007602/09/201027212.8501007716/09/201029171.5201007812/09/20102494.7501007924/09/201031255.2901008031/08/201020170.4501008119/09/201022145.5001008201/08/20101297.9201008323/09/20101879.1701008417/09/201028116.6301008507/08/20101997.470

8、1008618/09/201016109.9401008724/09/201025144.7201008831/08/201027194.4601008920/09/201018130.0001009031/08/201025193.8001009124/09/20102057.1501009224/09/20102992.6201009309/08/201010200.6001009425/07/201018188.5001009528/08/20102483.5001009606/09/201020155.5501009723/09/201022114.3601009831/08/2010

9、17200.7601009923/09/201031110.1901010010/09/201018151.7201010125/08/201025110.8001010220/09/201019105.5301010322/09/201022163.9501010423/09/201026174.9601010522/09/201015194.4001010628/08/20102073.5001010712/09/201014168.4401010810/09/201027127.1101010915/09/201025116.2801011015/09/201032117.0901011

10、116/09/201017184.0601011221/09/20101796.1801011317/09/201018173.2801011409/09/201023126.4801011513/09/201031133.3501011612/09/201023133.7401011724/09/201021109.5201011822/09/20101993.3701011925/08/201021131.1001012018/09/201025121.4401012124/09/201029109.9701012221/08/201029100.9301012321/08/2010181

11、53.9401012412/07/20102383.5701012522/09/201020114.4501012624/09/201026182.8101012715/09/20101881.8301012822/09/201030161.0701012919/09/201034132.1801013024/09/201023113.3501013122/09/201015181.2701013223/09/201024162.5001013307/08/20101586.6701013412/09/201021117.1901013522/09/201014111.5701013609/0

12、9/201026207.7301013724/09/201028113.4301013824/09/201018118.1101013915/08/201025159.7601014024/09/201023109.2201014122/09/201027134.3001014214/08/201020173.5501014325/08/201029112.4501014415/08/20102391.9601014517/09/20101799.6501014618/09/20101489.3601014714/09/201017105.0001014803/09/201027146.520

13、1014924/09/201039119.3201015009/09/20102597.4401015104/09/201014116.7901015215/09/201025104.1201015321/09/201026125.5801015422/09/20102558.0001015531/08/201027104.7001015624/09/20101897.1701015703/09/201017162.6501015815/09/201022182.6801015915/08/201031176.6501016023/09/20102698.1501016105/09/20101

14、9109.2601016213/09/201024152.6301016306/09/201017119.2401016422/09/201020121.7501016512/09/201018118.7801016617/09/201020179.0001016717/09/201027143.1901016820/08/201018110.4401016922/09/20102295.7301017018/09/201024103.0801017109/09/201020156.6001017213/08/201017194.8201017330/08/201022110.45010174

15、22/09/201021133.6701017514/09/20102492.7501017612/09/201018218.6701017714/09/201025176.7601017825/06/201019140.1101017923/08/201028119.0001018019/09/201017119.6501018114/09/201027167.2201018223/09/20102380.5201018314/09/20102289.9101018424/09/201022111.2701018511/09/201024176.2101018622/09/201020113

16、.6801018724/09/201020146.9501018820/09/20102586.6801018922/08/201019139.8401019022/09/201021145.2401019116/08/201022101.1801019222/09/201015139.6001019313/09/20102291.8201019423/09/201023137.1301019502/09/201012120.8301019601/09/20102382.9101019723/09/20102777.4101019806/09/201019155.1601019912/09/2

17、01015123.2701020023/08/201026160.7301020107/09/201020135.3301020223/09/201028128.9601020322/09/201022175.1801020415/08/201020181.0501020519/08/201015108.6701020619/09/201020101.5501020724/09/201018122.6101020802/09/201019126.7401020922/09/20102274.0901021023/09/201019129.1601021102/09/201025177.9601

18、021222/09/201022174.7301021322/09/201014122.2901021414/09/201019175.2101021524/09/201019198.5301021606/09/201018130.5001021702/09/201010141.0001021811/09/201021130.7601021914/09/201021170.2401022014/08/20102187.0501022127/07/20102496.2101022224/09/201020145.1501022324/09/201020202.5001022423/09/2010

19、26163.4501022523/09/201029103.4101022629/08/201029130.5901022724/09/201022199.6801022818/07/201016138.0601022922/09/201029143.0301023018/09/201020131.3501023113/08/201019155.6101023230/08/201025132.4401023322/09/201021120.7601023430/08/201024112.1301023502/09/201024185.3301023621/08/201028124.390102

20、3716/08/201021120.6201023825/07/201023233.0401023922/08/201015158.2001024017/09/201016184.0001024103/08/201024164.3301024223/09/201023127.2401024312/09/201019185.2101024416/07/201021-12.4801024514/09/201019178.3701024618/09/201030136.6701024714/09/201032167.5901024831/08/201023196.5201024921/09/2010

21、25123.5601025014/09/201021167.1901025105/09/201029210.3801025218/09/201027114.5901025323/09/201027142.0001025410/09/201014189.6101025524/09/201020141.4501025603/09/201023164.0001025722/08/201018149.7201025805/09/20102496.4201025906/09/20101695.8101026009/09/201020124.7001026116/09/201024155.29010262

22、22/09/201020147.1501026315/09/201023175.8701026402/09/201029104.2401026527/08/201020165.2501026615/09/20102276.6801026715/09/201024131.0001026830/08/201023139.0001026911/09/201021129.1001027021/08/20102699.0401027116/09/201025144.4801027226/08/201029132.1401027323/07/201023135.1701027424/09/20101718

23、8.7601027522/09/20102128.0501027616/09/201026115.1201027722/09/201019138.7401027810/09/201032170.1601027927/08/201024148.9401028024/09/201025130.4001028127/08/201018195.8301028206/09/201023127.3501028321/09/201033184.7901028414/09/201022176.3601028517/09/201028127.7101028623/09/201032109.6901028708/

24、09/201027159.2201028816/09/201022106.6801028920/09/201025165.0001029016/08/201029138.2401029120/09/201027121.7801029212/08/201021130.4301029308/08/201019145.2601029423/09/201022144.0001029504/06/201012160.0501029624/09/201019108.0001029724/09/201016132.4401029819/08/201023169.9601029914/09/201017104

25、.3501030025/08/201025187.4402000112/09/201023143.6102000222/09/201028115.2102000324/09/201016153.0002000430/08/201019186.5802000531/08/201021123.3802000622/09/201026139.2002000710/09/201031102.4802000817/09/201026132.7702000915/09/201020151.8002001022/09/201023140.1302001112/09/201024160.0002001204/

26、08/201013186.0002001318/07/201023123.7402001408/08/201021116.4802001510/09/201028119.5902001622/09/201015116.2002001715/09/201029106.3102001820/09/201027105.1902001916/09/201022155.2702002019/09/201018164.5002002111/09/201022148.0002002211/08/201026147.8102002323/09/201029166.4802002411/09/201027169

27、.5902002511/09/201023119.0402002610/09/201029118.7902002702/09/201016126.0602002818/09/201030117.0702002914/08/201014101.1402003007/08/201017126.2902003118/09/201023116.1702003214/08/201016105.6302003326/08/201031123.0302003408/09/201018107.5602003512/08/20102294.6402003607/09/201019168.9502003723/0

28、9/201023139.2202003817/08/201021132.0002003924/09/201027136.7002004011/09/201020150.8002004114/09/201026171.9202004221/09/201023199.0902004310/09/20102984.8602004423/09/201020164.2502004515/08/20101888.0602004622/09/201024116.8802004708/09/201021173.2602004826/08/201020119.6002004923/07/201024142.88

29、02005015/08/20102394.4302005110/09/201018134.0002005219/08/20101484.5702005324/09/20102796.3002005431/08/201017164.7102005521/08/201021134.9502005631/08/201013117.0802005720/09/201026160.1902005831/07/201014123.7902005905/09/201021116.7602006022/09/201022155.4502006122/08/201023123.1702006223/09/201

30、017160.7602006314/09/201030105.1702006423/09/201025120.7602006519/09/201018223.2802006624/09/201019155.2602006706/09/201016126.0602006810/09/201021101.1002006905/09/20102796.3002007006/09/201024228.8802007123/09/201024157.0802007201/09/201023155.4302007319/08/201028137.1402007418/09/201023165.610200

31、7513/09/201024125.2902007617/08/20101779.7102007721/09/20101399.8502007806/09/201016154.1902007919/08/201020151.9502008011/08/201026120.8102008122/09/201028143.3902008223/09/201027112.8902008327/08/201018134.0002008414/09/201022150.8602008522/09/201027133.4802008615/09/20102494.0402008722/09/2010221

32、07.3202008823/09/201021110.0502008911/09/201026147.3802009021/09/201032123.6602009112/09/201024157.0402009207/09/201029153.2802009324/09/201017150.2402009419/09/201016118.2502009518/09/201018150.9402009616/09/201025153.4402009724/09/201026103.0402009801/09/201022144.5902009907/09/201025120.520201001

33、5/09/201025120.7602010114/09/201020142.6502010206/09/201016119.8102010317/09/201027136.8102010422/09/201028149.2102010514/09/20101984.3202010617/09/201024126.0402010704/09/201028142.7102010818/09/201024142.6302010912/08/201030178.7702011014/08/201023124.0902011115/09/201032163.3802011223/09/20102211

34、5.8202011313/08/20101477.1402011418/09/20103374.2702011524/09/20102388.6102011624/09/201028130.2902011718/09/20102484.0402011822/07/201019170.5802011925/09/201021172.6702012007/08/201017123.9402012108/09/201017205.3502012208/09/201023188.8302012305/08/201024147.5002012422/09/201021102.5702012524/09/

35、201025197.8802012624/09/201028197.6802012723/09/201027120.5202012824/09/201024152.7902012916/06/201011176.5502013006/09/201029119.7602013114/09/201025123.8002013224/09/20102096.0002013320/08/201023186.7002013422/09/201025144.6002013522/09/201033113.7902013611/09/201021195.4802013718/09/201022126.680

36、2013801/09/201021111.9502013911/09/201018172.7802014002/09/201025101.4402014111/09/201025136.4402014226/08/201024196.0002014319/09/201021138.7602014417/09/201022154.3202014523/09/201026135.0802014631/08/201017154.9402014706/09/201023149.7402014831/08/20102574.8402014906/09/201011172.5502015012/09/20

37、101780.1202015123/09/201025127.2002015223/09/201024172.0002015311/09/201030138.0702015422/09/20102399.4302015522/09/201018143.5602015622/09/201023143.3902015714/09/20101593.8702015830/08/201022143.1802015918/09/201016130.3102016024/09/201029121.3102016117/09/201020108.4802016224/09/201016126.8102016

38、328/08/201031111.2602016422/09/20101895.2202016513/09/201023155.7002016622/09/201018113.9402016725/08/201024113.5802016826/08/201027172.1902016902/09/20101689.6902017020/09/20102458.2102017127/08/201019124.4702017207/09/20102090.4002017321/09/201025215.2802017409/08/201016187.2502017504/09/20102277.

39、1402017627/07/201018177.6102017711/09/201013204.1502017824/09/201023160.3502017921/09/201020177.2502018014/09/201026135.6902018106/09/201027167.4102018217/09/201025139.4802018317/09/201022103.3602018430/08/20102787.2202018509/09/201027144.5402018618/08/201020204.2502018709/09/20102599.6402018823/09/

40、201031142.1302018915/09/201020133.5502019029/08/201022153.0002019122/09/201022142.6402019217/09/201024109.6702019322/09/201025167.1202019409/09/201022134.7702019506/09/201020111.3502019610/09/201019134.0002019723/09/201018155.8902019825/07/201021167.0502019916/07/20102466.9602020012/09/201021139.760

41、2020101/09/201024121.3302020214/08/20102392.4302020322/09/201019222.0502020422/09/201019144.7402020515/09/201019176.9502020622/09/201027151.4102020720/09/201032146.1902020818/09/201024105.6702020906/09/20102664.8102021022/09/201021111.8602021124/09/20103472.7602021206/09/201022205.0502021313/08/2010

42、16145.0602021417/08/201021170.1402021522/09/201027149.9302021627/08/20102754.9602021723/09/20102057.6502021824/09/201031213.2302021907/09/201019121.1602022031/08/201025135.8802022123/09/201021173.0002022211/09/201024166.7902022314/09/201025122.4402022414/08/201022146.2702022522/09/201021120.33020226

43、14/09/201025192.9202022712/09/201028130.3202022824/09/201021113.5702022923/09/201014100.2902023017/09/20102193.9002023118/09/201019141.0002023222/09/201023172.7802023318/09/20101763.1202023414/09/20102379.8902023512/09/201020140.0002023624/08/201020125.0502023724/09/201021175.0502023816/09/20101784.

44、1202023924/09/20102555.0402024029/08/20102591.4402024124/09/201021166.1202024216/09/201025136.1202024307/09/201019161.2102024424/09/20102289.3602024517/09/201024138.0402024616/08/201020156.8002024710/09/201024187.5402024801/09/20101675.8102024908/08/201020136.9502025007/09/20102199.1002025116/09/201

45、02479.6702025222/09/201020127.8002025323/09/201021107.4302025408/08/201029165.1002025513/08/201028114.3902025607/09/20102192.9502025724/09/201022151.9102025824/08/201025175.5602025930/08/201014157.1402026013/09/201017187.2402026120/08/201017130.5302026217/09/201020154.5002026322/08/20102453.75020264

46、30/08/20101599.5302026522/09/201015171.9302026622/09/201016111.0602026713/09/201013102.5402026818/09/201018120.7202026921/09/201030120.9702027010/09/201022144.0002027107/09/20102684.3102027222/09/201027118.7802027320/09/201023116.4302027422/09/20101991.6802027524/09/201025181.6802027615/09/201025119

47、.1202027707/08/20102078.2002027824/09/201020144.0002027923/09/201022141.0902028010/09/201021142.9502028125/08/20102198.3302028217/08/201020163.8502028302/09/201025104.1602028406/09/201022101.1402028514/08/201022151.3202028624/09/201025104.5602028726/08/201020145.0502028823/09/201028164.3602028924/09

48、/201022142.3902029028/08/201026171.5802029106/09/201026117.7202029215/09/201021114.0002029324/09/201031131.2302029415/08/201018198.7802029518/09/201022162.7302029615/08/201023142.5202029719/09/201018110.5002029823/09/20102473.0402029926/08/201026151.0402030022/09/201027110.1503000112/09/201021112.14

49、03000209/09/201027126.5903000323/09/201020118.5003000423/09/201021129.6703000523/09/201024144.4603000607/09/201021124.0003000724/09/201016184.6903000804/09/201020153.1003000913/09/201017120.8803001017/09/201017162.0003001124/09/201019102.0503001223/09/201026113.4203001304/09/201030203.9003001418/09/

50、201023170.1703001518/09/201019142.5103001615/09/201026102.6203001724/09/201014134.1103001801/09/201026202.6903001918/09/201027145.3303002024/09/201022131.9503002109/09/201021130.1203002201/09/201022122.9503002310/09/201022166.5903002420/09/201018135.2803002514/09/201024114.5803002619/08/201033143.24

51、03002722/09/20101640.2503002810/08/201014111.5703002923/09/201023109.3003003001/09/201025167.0403003113/09/201034139.6203003223/09/201015190.1303003321/08/201030177.5303003424/09/201020135.7503003524/09/201025135.2003003607/08/20102291.5903003712/08/201014137.5403003811/09/201027132.9303003921/09/20

52、1031114.7103004011/09/20102182.9003004111/09/201027121.4103004230/08/201017158.7603004318/09/201028125.3803004428/07/201023199.2403004510/09/201017164.4703004612/09/201019158.0003004724/09/201020112.9003004811/09/201012114.9203004912/09/201013153.3103005024/09/201022142.2303005113/08/201025135.24030

53、05209/09/201019127.4703005323/08/201024218.2103005418/09/201028131.4603005514/09/201022199.9503005624/09/201017144.0603005714/09/20101683.4403005822/09/201025179.9603005905/09/201025185.8003006006/09/201019117.8203006130/08/20101694.9403006221/09/20102989.8603006330/08/20102380.0003006411/09/2010241

54、37.5003006508/09/201022135.1403006614/08/201016102.8103006722/09/201023125.0903006812/09/201021166.9003006919/09/201028150.8903007003/09/20101396.9203007112/09/201033172.3003007223/09/201016163.1903007319/09/20101886.7803007424/09/201030169.4303007517/09/201020161.5503007623/09/20101593.1303007724/0

55、9/20101970.2103007823/07/20101798.7603007918/09/201023120.9603008022/09/201024122.9203008120/08/201018209.7203008215/09/201022141.5003008311/09/201021132.6703008427/08/20102689.1903008505/08/201022173.5903008614/08/201028151.8903008719/09/20101985.6803008819/08/201026183.8103008909/09/201028139.5003

56、009012/09/201026139.1503009106/07/201020168.9003009225/08/201026144.8503009324/09/201028156.7903009427/08/201015130.9303009520/09/201019155.0803009609/09/201018168.2203009714/09/201015150.5303009822/09/201020160.8503009906/09/20102382.9603010020/09/201019130.9503010102/09/201017139.8203010224/09/201

57、012107.0003010322/08/201030110.0003010424/09/20103388.1203010518/09/201027168.7803010622/09/20102491.8803010707/08/201017197.5903010809/09/20101963.7403010904/09/201020107.1503011018/09/201019163.7903011124/09/201022132.4503011212/09/201022105.7303011322/09/201022100.7703011411/09/201022143.95030115

58、23/09/201032186.2503011624/09/201020141.8503011724/09/201025121.3203011811/08/201025142.1603011924/09/20101874.9403012020/09/201024111.1703012124/09/201025213.9203012211/09/201020138.5003012302/09/201018130.0603012401/09/201022116.4503012514/08/201025163.1203012622/09/201020199.3003012723/09/2010191

59、20.3703012813/09/201019185.1603012914/09/20102795.3703013024/09/20102381.3503013125/08/201022147.8203013223/09/201023162.8703013311/09/201022113.5003013431/08/201017176.8203013518/08/20101788.8803013620/08/201014120.5003013723/07/20102446.9603013825/08/201023127.2203013923/09/201018200.5003014022/09

60、/201023150.1703014106/09/201019265.8403014218/09/201027141.6703014329/08/201016118.2503014417/08/201014112.9303014509/07/201024238.7503014614/09/201021102.1003014705/08/201023122.5203014824/09/201021118.7603014915/08/201019109.3703015023/09/201028127.1103015113/09/201019139.8903015218/09/201025105.6