EXCEL在財(cái)務(wù)工作中的應(yīng)用之?dāng)?shù)據(jù)透視表（中）

1、一一、制制作作數(shù)數(shù)據(jù)據(jù)透透視視表表的的方方法法和和步步驟驟二二、設(shè)設(shè)置置數(shù)數(shù)據(jù)據(jù)透透視視表表的的顯顯示示方方式式（一）重新布局（二）修改字段名稱1、通過“數(shù)據(jù)透視表字段”對(duì)話框修改字段名稱進(jìn)入 示例2-12、直接在工作表的單元格中修改字段名稱3、修改字段名稱的一些注意問題（三）設(shè)置字段的匯總方式進(jìn)入 示例2-21、僅有1個(gè)字段匯總數(shù)據(jù)是改變字段的匯總方式2、對(duì)多個(gè)字段匯總數(shù)據(jù)改變?yōu)椴煌膮R總方式（四）設(shè)置字段的數(shù)字格式進(jìn)入 示例2-31、將字段的數(shù)字格式設(shè)置為預(yù)設(shè)的數(shù)字格式2、將字段的數(shù)字格式設(shè)置為自定義數(shù)字格式3、利用條件格式對(duì)字段數(shù)字進(jìn)行重點(diǎn)顯示中國會(huì)計(jì)視野論壇 會(huì)計(jì)進(jìn)級(jí)項(xiàng)目（五）設(shè)置字段

2、的數(shù)據(jù)顯示方式1、差異顯示進(jìn)入 示例2-42、差異百分比顯示3、占同行數(shù)據(jù)總和的百分比顯示4、占同列數(shù)據(jù)的百分比顯示5、占總和百分比顯示6、累計(jì)值顯示進(jìn)入 示例2-57、縱向差異比較：環(huán)比增長分析進(jìn)入 示例2-68、恢復(fù)為正常顯示（六）分組查看1、按日期（年、季度、月）分組查看進(jìn)入 示例2-72、取消分組查看3、幾點(diǎn)注意（七）顯示/隱藏某個(gè)字段的明細(xì)數(shù)據(jù)進(jìn)入 示例2-81、當(dāng)前數(shù)據(jù)透視表中顯示/隱藏某個(gè)字段的明細(xì)數(shù)據(jù)2、在新工作表中顯示某個(gè)項(xiàng)目的明細(xì)數(shù)據(jù)3、禁止顯示字段的明細(xì)數(shù)據(jù)（八）顯示/隱藏?cái)?shù)據(jù)透視表中的匯總進(jìn)入 示例2-91、顯示單個(gè)字段的分類匯總2、顯示整個(gè)數(shù)據(jù)透視表的總計(jì)3、顯示/隱

3、藏行字段項(xiàng)目后的空白行（九）顯示/隱藏?cái)?shù)據(jù)透視表字段或字段項(xiàng)進(jìn)入 示例2-101、顯示/隱藏某個(gè)字段2、顯示/隱藏行字段或列字段的項(xiàng)3、顯示/隱藏某個(gè)數(shù)據(jù)項(xiàng)4、顯示/隱藏頁字段的項(xiàng)5、顯示字段的前幾項(xiàng)或后幾項(xiàng)（十）設(shè)置字段的排序方式進(jìn)入 示例2-111、自動(dòng)排序2、關(guān)閉自動(dòng)排序3、手動(dòng)排序4、自定義排序（十一）設(shè)置數(shù)據(jù)透視表選項(xiàng)進(jìn)入 示例2-121、取消數(shù)據(jù)透視表的行或列總計(jì)2、設(shè)置空值的顯示方式3、設(shè)置錯(cuò)誤值的顯示方式4、為外部的行和列項(xiàng)目使用合并單元格或常規(guī)單元格（十二）刷新數(shù)據(jù)透視表進(jìn)入 示例2-131、刷新數(shù)據(jù)透視表的基本方法2、打開工作簿時(shí)自動(dòng)刷新數(shù)據(jù)透視表3、自動(dòng)定時(shí)刷新數(shù)據(jù)透視表

4、三三、自自定定義義計(jì)計(jì)算算字字段段和和計(jì)計(jì)算算項(xiàng)項(xiàng)四四、制制作作動(dòng)動(dòng)態(tài)態(tài)的的數(shù)數(shù)據(jù)據(jù)透透視視表表日期(全部)修改字段名稱返回課件城市(全部)求和項(xiàng):銷售額商品銷售人員冰箱彩電電腦空調(diào)相機(jī)總計(jì)曹澤鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500047300018368008007307427530劉敬堃143260087170066220019964005608805523780王騰宇988000425500421400159040017712

5、03602420王學(xué)敏2277600251850015222002189600187083010378730周德宇2779400244490024510003760400201474013450440總計(jì)1306760010738700818720014963200685233053809030日期(全部)設(shè)置字段匯總方式返回課件城市(全部)求和項(xiàng):銷售額商品銷售人員冰箱彩電電腦空調(diào)相機(jī)總計(jì)曹澤鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500

6、047300018368008007307427530劉敬堃143260087170066220019964005608805523780王騰宇98800042550042140015904001771203602420王學(xué)敏2277600251850015222002189600187083010378730周德宇2779400244490024510003760400201474013450440總計(jì)1306760010738700818720014963200685233053809030日期(全部)設(shè)置字段數(shù)字格式返回課件城市(全部)求和項(xiàng):銷售額商品銷售人員冰箱彩電電腦空調(diào)相機(jī)總計(jì)曹

7、澤鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500047300018368008007307427530劉敬堃143260087170066220019964005608805523780王騰宇98800042550042140015904001771203602420王學(xué)敏2277600251850015222002189600187083010378730周德宇277940024449002451000376040020147401345

8、0440總計(jì)1306760010738700818720014963200685233053809030日期(全部)差異顯示返回課件城市(全部)求和項(xiàng):銷售額商品銷售人員冰箱彩電電腦空調(diào)相機(jī)總計(jì)曹澤鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500047300018368008007307427530劉敬堃143260087170066220019964005608805523780王騰宇9880004255004214001590400177

9、1203602420王學(xué)敏2277600251850015222002189600187083010378730周德宇2779400244490024510003760400201474013450440總計(jì)1306760010738700818720014963200685233053809030累計(jì)值顯示返回課件城市(全部)商品(全部)求和項(xiàng):銷售額日期銷售人員5月6月7月曹澤鑫127310015348601051230房天琦239014048022502374550郝宗泉116713029943703266030劉敬堃102617027165001781110王騰宇46810016506

10、001483720王學(xué)敏270936038832003786170周德宇308117063395604029710環(huán)比增長分析返回課件重點(diǎn)1 布局時(shí)銷售額進(jìn)行2次求和2 對(duì)日期進(jìn)行按月組合3 合理設(shè)置差異比較的方式按月組合返回課件顯示明細(xì)數(shù)據(jù)返回課件商品(全部)城市(全部)日期數(shù)據(jù)5月6月7月銷售人員銷售額 銷售量 銷售額 銷售量 銷售額 銷售量 曹澤鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219劉敬堃10261703702716500852

11、1781110650王騰宇46810017716506005151483720538王學(xué)敏27093608043883200129137861701342周德宇30811708966339560213140297101279顯示匯總方式返回課件商品(全部)城市(全部)日期數(shù)據(jù)5月6月7月銷售人員銷售額 銷售量 銷售額 銷售量 銷售額 銷售量 曹澤鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219劉敬堃10261703702716500852178

12、1110650王騰宇46810017716506005151483720538王學(xué)敏27093608043883200129137861701342周德宇30811708966339560213140297101279顯示字段或字段項(xiàng)返回課件商品(全部)城市(全部)日期數(shù)據(jù)5月6月7月銷售人員銷售額 銷售量 銷售額 銷售量 銷售額 銷售量 曹澤鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219劉敬堃102617037027165008521781

13、110650王騰宇46810017716506005151483720538王學(xué)敏27093608043883200129137861701342周德宇30811708966339560213140297101279設(shè)置排序方式返回課件商品(全部)城市(全部)日期數(shù)據(jù)5月6月7月銷售人員銷售額 銷售量 銷售額 銷售量 銷售額 銷售量 曹澤鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219劉敬堃102617037027165008521781110

14、650王騰宇46810017716506005151483720538王學(xué)敏27093608043883200129137861701342周德宇30811708966339560213140297101279設(shè)置數(shù)據(jù)透視表選項(xiàng)返回課件商品(全部)城市(全部)日期數(shù)據(jù)5月6月7月銷售人員銷售額 銷售量 銷售額 銷售量 銷售額 銷售量 曹澤鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219劉敬堃102617037027165008521781110

15、650王騰宇46810017716506005151483720538王學(xué)敏27093608043883200129137861701342周德宇30811708966339560213140297101279設(shè)置排序方式返回課件商品(全部)城市(全部)日期數(shù)據(jù)5月6月7月銷售人員銷售額 銷售量 銷售額 銷售量 銷售額 銷售量 曹澤鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219劉敬堃102617037027165008521781110650

16、王騰宇46810017716506005151483720538王學(xué)敏27093608043883200129137861701342周德宇30811708966339560213140297101279日期銷售人員城市商品銷售量銷售額2009/5/12曹澤鑫武漢彩5/12劉敬堃沈陽冰箱27702002009/5/12周德宇太原電腦403440002009/5/12周德宇貴陽相機(jī)421549802009/5/12曹澤鑫武漢彩電34782002009/5/12王騰宇杭州冰箱24624002009/5/12周德宇天津彩電32736002009/5/13王學(xué)敏鄭州電腦131

17、118002009/5/13周德宇沈陽相機(jī)341254602009/5/13周德宇太原彩電20460002009/5/13周德宇鄭州相機(jī)431586702009/5/13房天琦上海空調(diào)451260002009/5/13王騰宇南京空調(diào)34952002009/5/13劉敬堃武漢冰箱16416002009/5/13郝宗泉杭州彩電23529002009/5/14周德宇上海彩電30690002009/5/14房天琦南京冰箱38988002009/5/14曹澤鑫昆明冰箱31806002009/5/14王學(xué)敏鄭州空調(diào)421176002009/5/14劉敬堃沈陽冰箱19494002009/5/15劉敬堃太原空

18、調(diào)23644002009/5/15劉敬堃北京空調(diào)31868002009/5/15王學(xué)敏上?？?/15房天琦南京彩電21483002009/5/16郝宗泉杭州冰箱30780002009/5/16房天琦合肥電腦262236002009/5/16房天琦天津相機(jī)381402202009/5/16郝宗泉武漢彩電39897002009/5/16周德宇沈陽冰箱29754002009/5/16周德宇太原彩電21483002009/5/16周德宇昆明電腦131118002009/5/17王學(xué)敏貴陽相機(jī)321180802009/5/17房天琦天津彩電35805002009/5/17房天琦

19、北京相機(jī)311143902009/5/17周德宇上?？照{(diào)29812002009/5/18房天琦蘇州空調(diào)371036002009/5/18劉敬堃杭州冰箱10260002009/5/18王學(xué)敏武漢彩電38874002009/5/18王學(xué)敏沈陽彩電21483002009/5/18周德宇太原冰箱19494002009/5/19郝宗泉鄭州冰箱19494002009/5/19劉敬堃北京空調(diào)421176002009/5/19曹澤鑫上海冰箱501300002009/5/19劉敬堃南京空5/19周德宇杭州空調(diào)16448002009/5/20郝宗泉合肥空調(diào)24672002009/5/20

20、房天琦天津彩5/20周德宇武漢冰5/20王學(xué)敏太原電腦332838002009/5/20房天琦鄭州相機(jī)25922502009/5/20王學(xué)敏昆明彩電26598002009/5/21郝宗泉貴陽冰箱12312002009/5/21房天琦上海彩電24552002009/5/21王學(xué)敏南京電腦242064002009/5/21郝宗泉蘇州相機(jī)10369002009/5/21郝宗泉杭州彩5/22王學(xué)敏武漢相機(jī)471734302009/5/22周德宇沈陽空調(diào)431204002009/5/22王學(xué)敏太原空調(diào)22616002009/5

21、/22劉敬堃鄭州冰箱21546002009/5/22房天琦武漢彩5/22曹澤鑫太原彩電32736002009/5/23周德宇上海冰箱31806002009/5/23王騰宇南京冰箱31806002009/5/23王學(xué)敏杭州空5/23周德宇合肥冰箱21546002009/5/24郝宗泉天津空調(diào)12336002009/5/24周德宇武漢空調(diào)35980002009/5/24周德宇沈陽空5/25王騰宇鄭州彩5/25曹澤鑫貴陽冰箱481248002009/5/25房天琦天津電腦413526002009/

22、5/25周德宇南京相機(jī)24885602009/5/25周德宇蘇州彩5/25郝宗泉杭州冰箱21546002009/5/25王學(xué)敏武漢彩電38874002009/5/26周德宇太原電腦342924002009/5/26周德宇鄭州相機(jī)501845002009/5/26周德宇北京彩電491127002009/5/26郝宗泉上海相機(jī)26959402009/5/26周德宇杭州空調(diào)22616002009/5/26周德宇合肥空5/26劉敬堃武漢冰箱35910002009/5/26王學(xué)敏沈陽彩電20460002009/5/26房天琦昆明彩電2557500200

23、9/5/27劉敬堃貴陽冰箱12312002009/5/27劉敬堃天津冰箱35910002009/5/27王學(xué)敏北京空調(diào)441232002009/5/27曹澤鑫上海冰箱481248002009/5/27曹澤鑫南京空調(diào)35980002009/5/27周德宇蘇州空調(diào)10280002009/5/27王學(xué)敏杭州空調(diào)401120002009/5/27周德宇沈陽彩電27621002009/5/27王學(xué)敏太原冰箱28728002009/5/27房天琦北京電腦312666002009/5/28郝宗泉南京相機(jī)21774902009/5/28房天琦杭州彩電28644002009/5/28劉敬堃合肥冰箱2154600

24、2009/5/28王學(xué)敏天津彩電501150002009/5/28曹澤鑫蘇州電腦484128002009/5/28周德宇沈陽相機(jī)401476002009/5/28王學(xué)敏太原彩電16368002009/5/28王學(xué)敏昆明相機(jī)24885602009/5/29王學(xué)敏貴陽空5/29曹澤鑫天津空調(diào)30840002009/5/29郝宗泉北京冰5/29房天琦上海彩電21483002009/5/29周德宇蘇州彩電35805002009/5/29房天琦杭州冰箱451170002009/5/29王學(xué)敏沈陽冰5/29王騰宇太原空調(diào)3186

25、8002009/5/29王學(xué)敏鄭州冰5/30郝宗泉武漢空調(diào)381064002009/5/30周德宇沈陽空5/30劉敬堃太原空調(diào)27756002009/5/30郝宗泉北京彩電451035002009/5/30王學(xué)敏上海冰箱421092002009/5/30王學(xué)敏南京電腦171462002009/5/30劉敬堃杭州相機(jī)331217702009/5/30王學(xué)敏合肥彩電34782002009/5/30曹澤鑫天津冰5/30郝宗泉武漢彩電33759002009/5/30房天琦沈陽電腦231978002009/5/31王學(xué)敏太原相

26、機(jī)21774902009/5/31王學(xué)敏鄭州彩5/31房天琦昆明相機(jī)22811802009/5/31周德宇貴陽空調(diào)25700002009/5/31郝宗泉天津空5/31王學(xué)敏北京冰箱28728002009/5/31郝宗泉南京彩電451035002009/5/31房天琦蘇州彩電26598002009/5/31王騰宇沈陽冰箱401040002009/6/1房天琦太原冰箱431118002009/6/1郝宗泉北京空6/1房天琦南京冰6/1周德宇杭州空調(diào)24672002009/6/1周德宇合肥空調(diào)35

27、980002009/6/1周德宇天津空調(diào)11308002009/6/1房天琦沈陽彩6/1郝宗泉太原冰箱26676002009/6/1劉敬堃鄭州電腦494214002009/6/1劉敬堃貴陽相機(jī)25922502009/6/1周德宇天津彩電16368002009/6/1周德宇北京冰箱431118002009/6/2周德宇蘇州彩電42966002009/6/2周德宇杭州電腦171462002009/6/2房天琦鄭州相機(jī)301107002009/6/2房天琦上海彩電40920002009/6/2劉敬堃杭州相機(jī)20738002009/6/3周德宇合肥空調(diào)391092002009

28、/6/3房天琦沈陽空調(diào)481344002009/6/3劉敬堃昆明冰箱38988002009/6/3周德宇貴陽彩電36828002009/6/3周德宇天津彩電20460002009/6/3房天琦上海冰箱481248002009/6/3周德宇南京冰箱441144002009/6/3房天琦蘇州空調(diào)10280002009/6/3王學(xué)敏杭州冰箱30780002009/6/3周德宇武漢空調(diào)24672002009/6/3房天琦沈陽空調(diào)30840002009/6/4房天琦太原空調(diào)31868002009/6/4郝宗泉鄭州彩電12276002009/6/4周德宇沈陽冰箱421092002009/6/4房天琦太原電

29、腦353010002009/6/4王學(xué)敏鄭州相機(jī)401476002009/6/4郝宗泉北京彩電491127002009/6/4曹澤鑫上海冰箱471222002009/6/4周德宇南京彩電43989002009/6/4王學(xué)敏杭州電腦312666002009/6/4周德宇合肥相機(jī)27996302009/6/4房天琦天津彩電26598002009/6/5王學(xué)敏沈陽相機(jī)16590402009/6/5周德宇太原空調(diào)11308002009/6/5郝宗泉鄭州空調(diào)29812002009/6/5房天琦昆明冰箱421092002009/6/5王學(xué)敏貴陽彩電23529002009/6/5曹澤鑫天津彩電2762100

30、2009/6/5王騰宇北京冰箱471222002009/6/5房天琦上海冰箱36936002009/6/5曹澤鑫南京空調(diào)33924002009/6/5郝宗泉蘇州冰箱32832002009/6/5劉敬堃武漢空調(diào)401120002009/6/5房天琦沈陽空調(diào)361008002009/6/5王學(xué)敏太原空調(diào)16448002009/6/5周德宇上海彩電16368002009/6/6王學(xué)敏南京冰6/6郝宗泉杭州電腦211806002009/6/6房天琦合肥相機(jī)291070102009/6/6劉敬堃天津彩電23529002009/6/6房天琦沈陽冰箱401040002009/6/6

31、周德宇鄭州彩電10230002009/6/6周德宇昆明電腦10860002009/6/6房天琦上海相機(jī)491808102009/6/7周德宇南京彩電501150002009/6/7劉敬堃蘇州相機(jī)351291502009/6/7王騰宇杭州空調(diào)32896002009/6/7郝宗泉武漢空6/7劉敬堃沈陽冰箱26676002009/6/7周德宇太原彩電29667002009/6/8王騰宇北京彩電34782002009/6/8王學(xué)敏南京冰箱21546002009/6/8周德宇杭州冰箱501300002009/6/8劉敬堃合肥空調(diào)421176002009/6/8周德宇天津冰箱41

32、1066002009/6/8郝宗泉鄭州空調(diào)371036002009/6/8郝宗泉昆明空調(diào)25700002009/6/8周德宇天津空調(diào)381064002009/6/8劉敬堃北京彩6/9房天琦南京冰6/9周德宇蘇州電腦322752002009/6/9王學(xué)敏武漢相機(jī)22811802009/6/9王學(xué)敏沈陽彩電461058002009/6/9周德宇太原冰箱20520002009/6/10劉敬堃武漢彩6/10曹澤鑫沈陽電腦201720002009/6/10房天琦上海相機(jī)451660502009/6/10房天琦南京彩電34782

33、002009/6/11周德宇杭州相機(jī)22811802009/6/11王學(xué)敏天津空調(diào)26728002009/6/11王騰宇蘇州空調(diào)21588002009/6/11劉敬堃沈陽冰箱451170002009/6/11郝宗泉鄭州彩電24552002009/6/11王學(xué)敏昆明彩6/11房天琦貴陽冰箱32832002009/6/11周德宇天津冰箱451170002009/6/12房天琦北京空調(diào)22616002009/6/12王學(xué)敏上海冰箱19494002009/6/12曹澤鑫杭州空調(diào)411148002009/6/12周德宇沈陽空調(diào)35980002009/6/12郝宗泉太原空調(diào)501

34、400002009/6/12郝宗泉鄭州彩電39897002009/6/12周德宇北京彩電29667002009/6/12劉敬堃上海冰箱32832002009/6/13郝宗泉南京冰箱29754002009/6/13王騰宇杭州空調(diào)451260002009/6/13王學(xué)敏合肥空調(diào)491372002009/6/13劉敬堃天津冰箱491274002009/6/13房天琦武漢彩6/13郝宗泉沈陽電腦221892002009/6/13王學(xué)敏太原相機(jī)391439102009/6/13郝宗泉鄭州彩電34782002009/6/13周德宇昆明相機(jī)291070102009/6/13房天琦貴

35、陽空調(diào)401120002009/6/13王騰宇天津空調(diào)361008002009/6/13王學(xué)敏北京冰箱31806002009/6/13曹澤鑫南京彩電34782002009/6/14房天琦杭州彩電35805002009/6/14周德宇太原冰箱461196002009/6/14曹澤鑫鄭州冰箱21546002009/6/14王騰宇上海空調(diào)34952002009/6/14周德宇南京冰箱35910002009/6/14王學(xué)敏杭州空調(diào)10280002009/6/14周德宇合肥空調(diào)21588002009/6/15郝宗泉沈陽空調(diào)21588002009/6/15周德宇太原彩電30690002009/6/15王騰

36、宇昆明彩電35805002009/6/15王學(xué)敏貴陽冰箱28728002009/6/15郝宗泉天津冰箱10260002009/6/15房天琦北京空調(diào)27756002009/6/15周德宇上?？?/15王學(xué)敏南京冰6/15郝宗泉沈陽彩電34782002009/6/16房天琦太原電腦413526002009/6/16王學(xué)敏武漢相6/16劉敬堃沈陽彩電23529002009/6/16周德宇太原相機(jī)341254602009/6/16房天琦北京空調(diào)30840002009/6/17房天琦上?？照{(diào)21588002009/6/17王

37、學(xué)敏南京冰箱10260002009/6/17王學(xué)敏杭州彩電28644002009/6/17周德宇合肥彩電10230002009/6/17曹澤鑫天津冰箱26676002009/6/17周德宇武漢冰箱501300002009/6/17房天琦太原空調(diào)441232002009/6/17劉敬堃鄭州冰箱391014002009/6/17王學(xué)敏昆明空調(diào)471316002009/6/17周德宇貴陽空調(diào)27756002009/6/17房天琦天津空調(diào)19532002009/6/18郝宗泉北京彩6/18王學(xué)敏上海彩電491127002009/6/18周德宇南京冰箱11286002009/6

38、/18王學(xué)敏蘇州冰箱22572002009/6/18郝宗泉武漢空調(diào)491372002009/6/18周德宇沈陽空調(diào)29812002009/6/18周德宇太原冰箱22572002009/6/18房天琦鄭州彩電27621002009/6/18周德宇北京電腦433698002009/6/18王學(xué)敏南京相機(jī)21774902009/6/18房天琦杭州彩電441012002009/6/18周德宇合肥相6/18周德宇天津空6/19王學(xué)敏武漢空調(diào)30840002009/6/19房天琦沈陽冰箱411066002009/6/19房天琦太原彩電2557500200

39、9/6/19周德宇昆明彩6/19房天琦貴陽冰箱391014002009/6/19周德宇天津冰箱401040002009/6/20劉敬堃北京空調(diào)21588002009/6/20周德宇蘇州冰6/20周德宇杭州空調(diào)33924002009/6/20劉敬堃沈陽空調(diào)491372002009/6/20周德宇鄭州空調(diào)31868002009/6/21王騰宇北京彩電37851002009/6/21周德宇上海彩電39897002009/6/21曹澤鑫南京冰箱23598002009/6/21曹澤鑫杭州冰箱30780002009/6/21曹澤鑫合肥空調(diào)12336002

40、009/6/21房天琦天津空6/21周德宇武漢冰箱36936002009/6/21王學(xué)敏沈陽彩電35805002009/6/21曹澤鑫太原電腦171462002009/6/21王學(xué)敏鄭州相6/21劉敬堃昆明彩6/21郝宗泉貴陽相機(jī)291070102009/6/21周德宇天津空調(diào)421176002009/6/21房天琦鄭州空調(diào)431204002009/6/22郝宗泉南京冰箱431118002009/6/22王學(xué)敏杭州彩電32736002009/6/22王學(xué)敏合肥彩電36828002009/6/22王學(xué)敏沈陽冰箱3283

41、2002009/6/22郝宗泉太原冰箱38988002009/6/22周德宇鄭州空調(diào)421176002009/6/22王學(xué)敏昆明冰箱16416002009/6/22王騰宇貴陽空調(diào)21588002009/6/22郝宗泉天津空調(diào)441232002009/6/23周德宇北京空調(diào)24672002009/6/23曹澤鑫上海彩電38874002009/6/23郝宗泉南京彩電25575002009/6/23王學(xué)敏蘇州冰6/23房天琦武漢冰箱441144002009/6/23王學(xué)敏沈陽空調(diào)23644002009/6/23郝宗泉北京空調(diào)25700002009/6/23周德宇南京冰箱43

42、1118002009/6/23郝宗泉杭州彩電36828002009/6/23王騰宇合肥電腦494214002009/6/24周德宇天津相機(jī)491808102009/6/24王學(xué)敏武漢彩電501150002009/6/24王學(xué)敏沈陽相機(jī)10369002009/6/24郝宗泉太原空調(diào)24672002009/6/24周德宇鄭州空調(diào)12336002009/6/24房天琦貴陽冰箱501300002009/6/24房天琦北京彩電25575002009/6/24周德宇南京彩電23529002009/6/24劉敬堃武漢冰6/24周德宇沈陽冰箱27702002009/6/25劉敬堃太原

43、空調(diào)27756002009/6/25劉敬堃鄭州冰箱34884002009/6/25王騰宇武漢空調(diào)391092002009/6/25房天琦沈陽空調(diào)451260002009/6/25周德宇太原空調(diào)25700002009/6/25劉敬堃鄭州彩電12276002009/6/25王學(xué)敏北京彩電36828002009/6/25王學(xué)敏上海冰箱24624002009/6/25曹澤鑫南京冰6/25王學(xué)敏合肥空調(diào)26728002009/6/25曹澤鑫天津空調(diào)411148002009/6/25周德宇沈陽冰6/25王學(xué)敏太原彩電34782002009/6/25王學(xué)敏

44、鄭州電腦373182002009/6/25房天琦昆明相機(jī)22811802009/6/25房天琦貴陽彩電471081002009/6/25曹澤鑫天津相機(jī)24885602009/6/25房天琦北京空調(diào)12336002009/6/26房天琦南京空調(diào)22616002009/6/26周德宇蘇州冰箱10260002009/6/26周德宇杭州彩電451035002009/6/26郝宗泉武漢彩6/26周德宇沈陽冰6/26房天琦太原冰箱491274002009/6/26曹澤鑫鄭州空調(diào)20560002009/6/27王學(xué)敏南京冰箱38988002009/6/27

45、郝宗泉杭州空調(diào)34952002009/6/27劉敬堃合肥空調(diào)411148002009/6/27王騰宇天津空調(diào)29812002009/6/27郝宗泉武漢彩電20460002009/6/27郝宗泉沈陽彩電451035002009/6/27周德宇鄭州冰6/27周德宇昆明冰箱22572002009/6/28王學(xué)敏天津空調(diào)22616002009/6/28劉敬堃北京空調(diào)27756002009/6/28王騰宇上海冰箱21546002009/6/28王學(xué)敏南京彩電27621002009/6/28劉敬堃蘇州電腦171462002009/6/28周德宇武漢相機(jī)401476002009/6

46、/28王騰宇沈陽彩6/28郝宗泉鄭州相機(jī)341254602009/6/28劉敬堃上海空調(diào)371036002009/6/28周德宇南京空調(diào)24672002009/6/28房天琦杭州冰6/28劉敬堃合肥彩電25575002009/6/29周德宇沈陽彩電37851002009/6/29曹澤鑫太原冰箱24624002009/6/29劉敬堃貴陽冰6/29周德宇北京空調(diào)10280002009/6/29周德宇上海冰箱32832002009/6/30房天琦杭州空6/30王騰宇武漢空

47、6/30王學(xué)敏太原空調(diào)29812002009/6/30周德宇鄭州彩電39897002009/6/30王學(xué)敏沈陽彩電30690002009/6/30郝宗泉上海冰箱37962002009/7/1郝宗泉南京冰箱501300002009/7/1王騰宇杭州空調(diào)21588002009/7/1周德宇合肥空調(diào)471316002009/7/1周德宇天津冰7/1王學(xué)敏武漢彩電491127002009/7/1房天琦沈陽電腦272322002009/7/1郝宗泉太原相7/1王學(xué)敏鄭州彩電441012002009/7/1王學(xué)敏昆明相機(jī)451660502009/7/1劉

48、敬堃貴陽空調(diào)25700002009/7/1劉敬堃天津空調(diào)401120002009/7/1王學(xué)敏北京冰箱31806002009/7/1劉敬堃南京彩電16368002009/7/2房天琦蘇州彩電20460002009/7/2郝宗泉沈陽冰箱33858002009/7/2王騰宇太原冰7/2王學(xué)敏鄭州空調(diào)381064002009/7/2周德宇北京冰箱391014002009/7/2周德宇上?？照{(diào)391092002009/7/2周德宇南京空調(diào)451260002009/7/2劉敬堃杭州空調(diào)411148002009/7/2郝宗泉合肥彩電19437002009/7/2周德宇武漢彩電47

49、1081002009/7/2郝宗泉沈陽冰箱491274002009/7/3郝宗泉鄭州冰箱22572002009/7/3房天琦昆明空調(diào)30840002009/7/3曹澤鑫貴陽空調(diào)22616002009/7/3王學(xué)敏天津冰箱23598002009/7/3郝宗泉上海彩電38874002009/7/3周德宇南京電腦181548002009/7/3郝宗泉武漢相機(jī)501845002009/7/3王學(xué)敏太原彩電28644002009/7/3劉敬堃鄭州相機(jī)281033202009/7/4曹澤鑫北京空7/4房天琦上?？照{(diào)27756002009/7/4王學(xué)敏南京冰箱48124800200

50、9/7/4劉敬堃杭州彩7/4王學(xué)敏合肥彩電451035002009/7/4王騰宇天津冰箱19494002009/7/4王騰宇武漢冰7/4周德宇沈陽空調(diào)12336002009/7/4郝宗泉鄭州冰箱20520002009/7/4劉敬堃昆明空7/5王學(xué)敏貴陽空調(diào)25700002009/7/5王學(xué)敏天津空調(diào)25700002009/7/5王騰宇上海彩電12276002009/7/5周德宇杭州彩電41943002009/7/5曹澤鑫武漢冰箱35910002009/7/5王學(xué)敏沈陽冰箱10260002009/7/5周德宇太原空調(diào)2

51、2616002009/7/5房天琦鄭州空調(diào)451260002009/7/5房天琦武漢冰7/5郝宗泉沈陽彩電37851002009/7/6周德宇太原電腦10860002009/7/6王騰宇北京相機(jī)481771202009/7/6王學(xué)敏上海彩電42966002009/7/6曹澤鑫南京相機(jī)371365302009/7/6房天琦杭州空調(diào)19532002009/7/6王騰宇合肥空調(diào)481344002009/7/6房天琦太原冰箱28728002009/7/6郝宗泉鄭州彩電33759002009/7/7王學(xué)敏昆明彩電42966002009/7/7周德宇天津冰箱26676002009

52、/7/7房天琦北京冰7/7周德宇上海空調(diào)19532002009/7/7周德宇南京冰箱24624002009/7/7郝宗泉蘇州空調(diào)381064002009/7/7曹澤鑫杭州空調(diào)421176002009/7/7劉敬堃武漢空調(diào)31868002009/7/7曹澤鑫太原彩電35805002009/7/7曹澤鑫鄭州彩電39897002009/7/7王騰宇北京冰箱32832002009/7/7曹澤鑫上海冰箱26676002009/7/7周德宇南京空調(diào)25700002009/7/7曹澤鑫杭州空調(diào)28784002009/7/7周德宇合肥冰箱10260002009/7/8王學(xué)敏武漢彩電3

53、9897002009/7/8周德宇沈陽電腦221892002009/7/8周德宇昆明相機(jī)341254602009/7/8周德宇貴陽彩電26598002009/7/8房天琦天津相機(jī)351291502009/7/8周德宇北京空調(diào)20560002009/7/8劉敬堃上?？照{(diào)21588002009/7/8王學(xué)敏南京冰箱29754002009/7/8房天琦蘇州彩電41943002009/7/8王學(xué)敏杭州彩電31713002009/7/8王騰宇武漢冰箱471222002009/7/8周德宇鄭州冰箱26676002009/7/8王騰宇北京空調(diào)361008002009/7/8王學(xué)敏上海冰箱1539000200

54、9/7/9周德宇天津空調(diào)25700002009/7/9曹澤鑫武漢空調(diào)31868002009/7/9王學(xué)敏沈陽空調(diào)481344002009/7/9周德宇太原彩電42966002009/7/9王學(xué)敏鄭州彩電12276002009/7/9王騰宇天津冰箱11286002009/7/9周德宇北京冰箱10260002009/7/9劉敬堃上?？照{(diào)25700002009/7/9周德宇南京空調(diào)361008002009/7/9王學(xué)敏蘇州冰箱431118002009/7/10王學(xué)敏杭州彩電10230002009/7/10郝宗泉沈陽電腦121032002009/7/10周德宇太原相機(jī)24885602009/7/10劉

55、敬堃鄭州彩電491127002009/7/10郝宗泉武漢相機(jī)301107002009/7/10王學(xué)敏沈陽空調(diào)411148002009/7/11周德宇太原空調(diào)11308002009/7/11郝宗泉北京冰箱27702002009/7/11周德宇上海彩電471081002009/7/11王學(xué)敏南京彩電26598002009/7/11曹澤鑫杭州冰箱481248002009/7/11周德宇沈陽冰7/11周德宇太原空調(diào)361008002009/7/11王學(xué)敏鄭州冰箱401040002009/7/11劉敬堃昆明空調(diào)401120002009/7/11周德宇貴陽空調(diào)481344002009/7/12周德宇天津空調(diào)32896002009/7/12房天琦北京彩電451035002009/7/12劉敬堃上海彩電501150002009/7/12周德宇蘇州冰箱20520002009/7/12郝宗泉太原冰箱27702002009/7/12房天琦鄭州空調(diào)27756002009/7/12王騰宇上?？照{(diào)23644002009/7/12周德宇南京彩電491127002009/7/12劉敬堃杭州彩電28644002009/7/12周德宇合肥冰7/13王學(xué)敏天津冰