EXCEL在财务工作中的应用之数据透视表（中）

1、一一、制制作作数数据据透透视视表表的的方方法法和和步步骤骤二二、设设置置数数据据透透视视表表的的显显示示方方式式（一）重新布局（二）修改字段名称1、通过“数据透视表字段”对话框修改字段名称进入 示例2-12、直接在工作表的单元格中修改字段名称3、修改字段名称的一些注意问题（三）设置字段的汇总方式进入 示例2-21、仅有1个字段汇总数据是改变字段的汇总方式2、对多个字段汇总数据改变为不同的汇总方式（四）设置字段的数字格式进入 示例2-31、将字段的数字格式设置为预设的数字格式2、将字段的数字格式设置为自定义数字格式3、利用条件格式对字段数字进行重点显示中国会计视野论坛 会计进级项目（五）设置字段

2、的数据显示方式1、差异显示进入 示例2-42、差异百分比显示3、占同行数据总和的百分比显示4、占同列数据的百分比显示5、占总和百分比显示6、累计值显示进入 示例2-57、纵向差异比较：环比增长分析进入 示例2-68、恢复为正常显示（六）分组查看1、按日期（年、季度、月）分组查看进入 示例2-72、取消分组查看3、几点注意（七）显示/隐藏某个字段的明细数据进入 示例2-81、当前数据透视表中显示/隐藏某个字段的明细数据2、在新工作表中显示某个项目的明细数据3、禁止显示字段的明细数据（八）显示/隐藏数据透视表中的汇总进入 示例2-91、显示单个字段的分类汇总2、显示整个数据透视表的总计3、显示/隐

3、藏行字段项目后的空白行（九）显示/隐藏数据透视表字段或字段项进入 示例2-101、显示/隐藏某个字段2、显示/隐藏行字段或列字段的项3、显示/隐藏某个数据项4、显示/隐藏页字段的项5、显示字段的前几项或后几项（十）设置字段的排序方式进入 示例2-111、自动排序2、关闭自动排序3、手动排序4、自定义排序（十一）设置数据透视表选项进入 示例2-121、取消数据透视表的行或列总计2、设置空值的显示方式3、设置错误值的显示方式4、为外部的行和列项目使用合并单元格或常规单元格（十二）刷新数据透视表进入 示例2-131、刷新数据透视表的基本方法2、打开工作簿时自动刷新数据透视表3、自动定时刷新数据透视表

4、三三、自自定定义义计计算算字字段段和和计计算算项项四四、制制作作动动态态的的数数据据透透视视表表日期(全部)修改字段名称返回课件城市(全部)求和项:销售额商品销售人员冰箱彩电电脑空调相机总计曹泽鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500047300018368008007307427530刘敬堃143260087170066220019964005608805523780王腾宇988000425500421400159040017712

5、03602420王学敏2277600251850015222002189600187083010378730周德宇2779400244490024510003760400201474013450440总计1306760010738700818720014963200685233053809030日期(全部)设置字段汇总方式返回课件城市(全部)求和项:销售额商品销售人员冰箱彩电电脑空调相机总计曹泽鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500

6、047300018368008007307427530刘敬堃143260087170066220019964005608805523780王腾宇98800042550042140015904001771203602420王学敏2277600251850015222002189600187083010378730周德宇2779400244490024510003760400201474013450440总计1306760010738700818720014963200685233053809030日期(全部)设置字段数字格式返回课件城市(全部)求和项:销售额商品销售人员冰箱彩电电脑空调相机总计曹

7、泽鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500047300018368008007307427530刘敬堃143260087170066220019964005608805523780王腾宇98800042550042140015904001771203602420王学敏2277600251850015222002189600187083010378730周德宇277940024449002451000376040020147401345

8、0440总计1306760010738700818720014963200685233053809030日期(全部)差异显示返回课件城市(全部)求和项:销售额商品销售人员冰箱彩电电脑空调相机总计曹泽鑫126880060950073100010248002250903859190房天琦218920016836001926400256480012029409566940郝宗泉2132000218500047300018368008007307427530刘敬堃143260087170066220019964005608805523780王腾宇9880004255004214001590400177

9、1203602420王学敏2277600251850015222002189600187083010378730周德宇2779400244490024510003760400201474013450440总计1306760010738700818720014963200685233053809030累计值显示返回课件城市(全部)商品(全部)求和项:销售额日期销售人员5月6月7月曹泽鑫127310015348601051230房天琦239014048022502374550郝宗泉116713029943703266030刘敬堃102617027165001781110王腾宇46810016506

10、001483720王学敏270936038832003786170周德宇308117063395604029710环比增长分析返回课件重点1 布局时销售额进行2次求和2 对日期进行按月组合3 合理设置差异比较的方式按月组合返回课件显示明细数据返回课件商品(全部)城市(全部)日期数据5月6月7月销售人员销售额 销售量 销售额 销售量 销售额 销售量 曹泽鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219刘敬堃10261703702716500852

11、1781110650王腾宇46810017716506005151483720538王学敏27093608043883200129137861701342周德宇30811708966339560213140297101279显示汇总方式返回课件商品(全部)城市(全部)日期数据5月6月7月销售人员销售额 销售量 销售额 销售量 销售额 销售量 曹泽鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219刘敬堃10261703702716500852178

12、1110650王腾宇46810017716506005151483720538王学敏27093608043883200129137861701342周德宇30811708966339560213140297101279显示字段或字段项返回课件商品(全部)城市(全部)日期数据5月6月7月销售人员销售额 销售量 销售额 销售量 销售额 销售量 曹泽鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219刘敬堃102617037027165008521781

13、110650王腾宇46810017716506005151483720538王学敏27093608043883200129137861701342周德宇30811708966339560213140297101279设置排序方式返回课件商品(全部)城市(全部)日期数据5月6月7月销售人员销售额 销售量 销售额 销售量 销售额 销售量 曹泽鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219刘敬堃102617037027165008521781110

14、650王腾宇46810017716506005151483720538王学敏27093608043883200129137861701342周德宇30811708966339560213140297101279设置数据透视表选项返回课件商品(全部)城市(全部)日期数据5月6月7月销售人员销售额 销售量 销售额 销售量 销售额 销售量 曹泽鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219刘敬堃102617037027165008521781110

15、650王腾宇46810017716506005151483720538王学敏27093608043883200129137861701342周德宇30811708966339560213140297101279设置排序方式返回课件商品(全部)城市(全部)日期数据5月6月7月销售人员销售额 销售量 销售额 销售量 销售额 销售量 曹泽鑫127310038315348604951051230387房天琦2390140609480225015972374550834郝宗泉11671304412994370103832660301219刘敬堃102617037027165008521781110650

16、王腾宇46810017716506005151483720538王学敏27093608043883200129137861701342周德宇30811708966339560213140297101279日期销售人员城市商品销售量销售额2009/5/12曹泽鑫武汉彩5/12刘敬堃沈阳冰箱27702002009/5/12周德宇太原电脑403440002009/5/12周德宇贵阳相机421549802009/5/12曹泽鑫武汉彩电34782002009/5/12王腾宇杭州冰箱24624002009/5/12周德宇天津彩电32736002009/5/13王学敏郑州电脑131

17、118002009/5/13周德宇沈阳相机341254602009/5/13周德宇太原彩电20460002009/5/13周德宇郑州相机431586702009/5/13房天琦上海空调451260002009/5/13王腾宇南京空调34952002009/5/13刘敬堃武汉冰箱16416002009/5/13郝宗泉杭州彩电23529002009/5/14周德宇上海彩电30690002009/5/14房天琦南京冰箱38988002009/5/14曹泽鑫昆明冰箱31806002009/5/14王学敏郑州空调421176002009/5/14刘敬堃沈阳冰箱19494002009/5/15刘敬堃太原空

18、调23644002009/5/15刘敬堃北京空调31868002009/5/15王学敏上海空5/15房天琦南京彩电21483002009/5/16郝宗泉杭州冰箱30780002009/5/16房天琦合肥电脑262236002009/5/16房天琦天津相机381402202009/5/16郝宗泉武汉彩电39897002009/5/16周德宇沈阳冰箱29754002009/5/16周德宇太原彩电21483002009/5/16周德宇昆明电脑131118002009/5/17王学敏贵阳相机321180802009/5/17房天琦天津彩电35805002009/5/17房天琦

19、北京相机311143902009/5/17周德宇上海空调29812002009/5/18房天琦苏州空调371036002009/5/18刘敬堃杭州冰箱10260002009/5/18王学敏武汉彩电38874002009/5/18王学敏沈阳彩电21483002009/5/18周德宇太原冰箱19494002009/5/19郝宗泉郑州冰箱19494002009/5/19刘敬堃北京空调421176002009/5/19曹泽鑫上海冰箱501300002009/5/19刘敬堃南京空5/19周德宇杭州空调16448002009/5/20郝宗泉合肥空调24672002009/5/20

20、房天琦天津彩5/20周德宇武汉冰5/20王学敏太原电脑332838002009/5/20房天琦郑州相机25922502009/5/20王学敏昆明彩电26598002009/5/21郝宗泉贵阳冰箱12312002009/5/21房天琦上海彩电24552002009/5/21王学敏南京电脑242064002009/5/21郝宗泉苏州相机10369002009/5/21郝宗泉杭州彩5/22王学敏武汉相机471734302009/5/22周德宇沈阳空调431204002009/5/22王学敏太原空调22616002009/5

21、/22刘敬堃郑州冰箱21546002009/5/22房天琦武汉彩5/22曹泽鑫太原彩电32736002009/5/23周德宇上海冰箱31806002009/5/23王腾宇南京冰箱31806002009/5/23王学敏杭州空5/23周德宇合肥冰箱21546002009/5/24郝宗泉天津空调12336002009/5/24周德宇武汉空调35980002009/5/24周德宇沈阳空5/25王腾宇郑州彩5/25曹泽鑫贵阳冰箱481248002009/5/25房天琦天津电脑413526002009/

22、5/25周德宇南京相机24885602009/5/25周德宇苏州彩5/25郝宗泉杭州冰箱21546002009/5/25王学敏武汉彩电38874002009/5/26周德宇太原电脑342924002009/5/26周德宇郑州相机501845002009/5/26周德宇北京彩电491127002009/5/26郝宗泉上海相机26959402009/5/26周德宇杭州空调22616002009/5/26周德宇合肥空5/26刘敬堃武汉冰箱35910002009/5/26王学敏沈阳彩电20460002009/5/26房天琦昆明彩电2557500200

23、9/5/27刘敬堃贵阳冰箱12312002009/5/27刘敬堃天津冰箱35910002009/5/27王学敏北京空调441232002009/5/27曹泽鑫上海冰箱481248002009/5/27曹泽鑫南京空调35980002009/5/27周德宇苏州空调10280002009/5/27王学敏杭州空调401120002009/5/27周德宇沈阳彩电27621002009/5/27王学敏太原冰箱28728002009/5/27房天琦北京电脑312666002009/5/28郝宗泉南京相机21774902009/5/28房天琦杭州彩电28644002009/5/28刘敬堃合肥冰箱2154600

24、2009/5/28王学敏天津彩电501150002009/5/28曹泽鑫苏州电脑484128002009/5/28周德宇沈阳相机401476002009/5/28王学敏太原彩电16368002009/5/28王学敏昆明相机24885602009/5/29王学敏贵阳空5/29曹泽鑫天津空调30840002009/5/29郝宗泉北京冰5/29房天琦上海彩电21483002009/5/29周德宇苏州彩电35805002009/5/29房天琦杭州冰箱451170002009/5/29王学敏沈阳冰5/29王腾宇太原空调3186

25、8002009/5/29王学敏郑州冰5/30郝宗泉武汉空调381064002009/5/30周德宇沈阳空5/30刘敬堃太原空调27756002009/5/30郝宗泉北京彩电451035002009/5/30王学敏上海冰箱421092002009/5/30王学敏南京电脑171462002009/5/30刘敬堃杭州相机331217702009/5/30王学敏合肥彩电34782002009/5/30曹泽鑫天津冰5/30郝宗泉武汉彩电33759002009/5/30房天琦沈阳电脑231978002009/5/31王学敏太原相

26、机21774902009/5/31王学敏郑州彩5/31房天琦昆明相机22811802009/5/31周德宇贵阳空调25700002009/5/31郝宗泉天津空5/31王学敏北京冰箱28728002009/5/31郝宗泉南京彩电451035002009/5/31房天琦苏州彩电26598002009/5/31王腾宇沈阳冰箱401040002009/6/1房天琦太原冰箱431118002009/6/1郝宗泉北京空6/1房天琦南京冰6/1周德宇杭州空调24672002009/6/1周德宇合肥空调35

27、980002009/6/1周德宇天津空调11308002009/6/1房天琦沈阳彩6/1郝宗泉太原冰箱26676002009/6/1刘敬堃郑州电脑494214002009/6/1刘敬堃贵阳相机25922502009/6/1周德宇天津彩电16368002009/6/1周德宇北京冰箱431118002009/6/2周德宇苏州彩电42966002009/6/2周德宇杭州电脑171462002009/6/2房天琦郑州相机301107002009/6/2房天琦上海彩电40920002009/6/2刘敬堃杭州相机20738002009/6/3周德宇合肥空调391092002009

28、/6/3房天琦沈阳空调481344002009/6/3刘敬堃昆明冰箱38988002009/6/3周德宇贵阳彩电36828002009/6/3周德宇天津彩电20460002009/6/3房天琦上海冰箱481248002009/6/3周德宇南京冰箱441144002009/6/3房天琦苏州空调10280002009/6/3王学敏杭州冰箱30780002009/6/3周德宇武汉空调24672002009/6/3房天琦沈阳空调30840002009/6/4房天琦太原空调31868002009/6/4郝宗泉郑州彩电12276002009/6/4周德宇沈阳冰箱421092002009/6/4房天琦太原电

29、脑353010002009/6/4王学敏郑州相机401476002009/6/4郝宗泉北京彩电491127002009/6/4曹泽鑫上海冰箱471222002009/6/4周德宇南京彩电43989002009/6/4王学敏杭州电脑312666002009/6/4周德宇合肥相机27996302009/6/4房天琦天津彩电26598002009/6/5王学敏沈阳相机16590402009/6/5周德宇太原空调11308002009/6/5郝宗泉郑州空调29812002009/6/5房天琦昆明冰箱421092002009/6/5王学敏贵阳彩电23529002009/6/5曹泽鑫天津彩电2762100

30、2009/6/5王腾宇北京冰箱471222002009/6/5房天琦上海冰箱36936002009/6/5曹泽鑫南京空调33924002009/6/5郝宗泉苏州冰箱32832002009/6/5刘敬堃武汉空调401120002009/6/5房天琦沈阳空调361008002009/6/5王学敏太原空调16448002009/6/5周德宇上海彩电16368002009/6/6王学敏南京冰6/6郝宗泉杭州电脑211806002009/6/6房天琦合肥相机291070102009/6/6刘敬堃天津彩电23529002009/6/6房天琦沈阳冰箱401040002009/6/6

31、周德宇郑州彩电10230002009/6/6周德宇昆明电脑10860002009/6/6房天琦上海相机491808102009/6/7周德宇南京彩电501150002009/6/7刘敬堃苏州相机351291502009/6/7王腾宇杭州空调32896002009/6/7郝宗泉武汉空6/7刘敬堃沈阳冰箱26676002009/6/7周德宇太原彩电29667002009/6/8王腾宇北京彩电34782002009/6/8王学敏南京冰箱21546002009/6/8周德宇杭州冰箱501300002009/6/8刘敬堃合肥空调421176002009/6/8周德宇天津冰箱41

32、1066002009/6/8郝宗泉郑州空调371036002009/6/8郝宗泉昆明空调25700002009/6/8周德宇天津空调381064002009/6/8刘敬堃北京彩6/9房天琦南京冰6/9周德宇苏州电脑322752002009/6/9王学敏武汉相机22811802009/6/9王学敏沈阳彩电461058002009/6/9周德宇太原冰箱20520002009/6/10刘敬堃武汉彩6/10曹泽鑫沈阳电脑201720002009/6/10房天琦上海相机451660502009/6/10房天琦南京彩电34782

33、002009/6/11周德宇杭州相机22811802009/6/11王学敏天津空调26728002009/6/11王腾宇苏州空调21588002009/6/11刘敬堃沈阳冰箱451170002009/6/11郝宗泉郑州彩电24552002009/6/11王学敏昆明彩6/11房天琦贵阳冰箱32832002009/6/11周德宇天津冰箱451170002009/6/12房天琦北京空调22616002009/6/12王学敏上海冰箱19494002009/6/12曹泽鑫杭州空调411148002009/6/12周德宇沈阳空调35980002009/6/12郝宗泉太原空调501

34、400002009/6/12郝宗泉郑州彩电39897002009/6/12周德宇北京彩电29667002009/6/12刘敬堃上海冰箱32832002009/6/13郝宗泉南京冰箱29754002009/6/13王腾宇杭州空调451260002009/6/13王学敏合肥空调491372002009/6/13刘敬堃天津冰箱491274002009/6/13房天琦武汉彩6/13郝宗泉沈阳电脑221892002009/6/13王学敏太原相机391439102009/6/13郝宗泉郑州彩电34782002009/6/13周德宇昆明相机291070102009/6/13房天琦贵

35、阳空调401120002009/6/13王腾宇天津空调361008002009/6/13王学敏北京冰箱31806002009/6/13曹泽鑫南京彩电34782002009/6/14房天琦杭州彩电35805002009/6/14周德宇太原冰箱461196002009/6/14曹泽鑫郑州冰箱21546002009/6/14王腾宇上海空调34952002009/6/14周德宇南京冰箱35910002009/6/14王学敏杭州空调10280002009/6/14周德宇合肥空调21588002009/6/15郝宗泉沈阳空调21588002009/6/15周德宇太原彩电30690002009/6/15王腾

36、宇昆明彩电35805002009/6/15王学敏贵阳冰箱28728002009/6/15郝宗泉天津冰箱10260002009/6/15房天琦北京空调27756002009/6/15周德宇上海空6/15王学敏南京冰6/15郝宗泉沈阳彩电34782002009/6/16房天琦太原电脑413526002009/6/16王学敏武汉相6/16刘敬堃沈阳彩电23529002009/6/16周德宇太原相机341254602009/6/16房天琦北京空调30840002009/6/17房天琦上海空调21588002009/6/17王

37、学敏南京冰箱10260002009/6/17王学敏杭州彩电28644002009/6/17周德宇合肥彩电10230002009/6/17曹泽鑫天津冰箱26676002009/6/17周德宇武汉冰箱501300002009/6/17房天琦太原空调441232002009/6/17刘敬堃郑州冰箱391014002009/6/17王学敏昆明空调471316002009/6/17周德宇贵阳空调27756002009/6/17房天琦天津空调19532002009/6/18郝宗泉北京彩6/18王学敏上海彩电491127002009/6/18周德宇南京冰箱11286002009/6

38、/18王学敏苏州冰箱22572002009/6/18郝宗泉武汉空调491372002009/6/18周德宇沈阳空调29812002009/6/18周德宇太原冰箱22572002009/6/18房天琦郑州彩电27621002009/6/18周德宇北京电脑433698002009/6/18王学敏南京相机21774902009/6/18房天琦杭州彩电441012002009/6/18周德宇合肥相6/18周德宇天津空6/19王学敏武汉空调30840002009/6/19房天琦沈阳冰箱411066002009/6/19房天琦太原彩电2557500200

39、9/6/19周德宇昆明彩6/19房天琦贵阳冰箱391014002009/6/19周德宇天津冰箱401040002009/6/20刘敬堃北京空调21588002009/6/20周德宇苏州冰6/20周德宇杭州空调33924002009/6/20刘敬堃沈阳空调491372002009/6/20周德宇郑州空调31868002009/6/21王腾宇北京彩电37851002009/6/21周德宇上海彩电39897002009/6/21曹泽鑫南京冰箱23598002009/6/21曹泽鑫杭州冰箱30780002009/6/21曹泽鑫合肥空调12336002

40、009/6/21房天琦天津空6/21周德宇武汉冰箱36936002009/6/21王学敏沈阳彩电35805002009/6/21曹泽鑫太原电脑171462002009/6/21王学敏郑州相6/21刘敬堃昆明彩6/21郝宗泉贵阳相机291070102009/6/21周德宇天津空调421176002009/6/21房天琦郑州空调431204002009/6/22郝宗泉南京冰箱431118002009/6/22王学敏杭州彩电32736002009/6/22王学敏合肥彩电36828002009/6/22王学敏沈阳冰箱3283

41、2002009/6/22郝宗泉太原冰箱38988002009/6/22周德宇郑州空调421176002009/6/22王学敏昆明冰箱16416002009/6/22王腾宇贵阳空调21588002009/6/22郝宗泉天津空调441232002009/6/23周德宇北京空调24672002009/6/23曹泽鑫上海彩电38874002009/6/23郝宗泉南京彩电25575002009/6/23王学敏苏州冰6/23房天琦武汉冰箱441144002009/6/23王学敏沈阳空调23644002009/6/23郝宗泉北京空调25700002009/6/23周德宇南京冰箱43

42、1118002009/6/23郝宗泉杭州彩电36828002009/6/23王腾宇合肥电脑494214002009/6/24周德宇天津相机491808102009/6/24王学敏武汉彩电501150002009/6/24王学敏沈阳相机10369002009/6/24郝宗泉太原空调24672002009/6/24周德宇郑州空调12336002009/6/24房天琦贵阳冰箱501300002009/6/24房天琦北京彩电25575002009/6/24周德宇南京彩电23529002009/6/24刘敬堃武汉冰6/24周德宇沈阳冰箱27702002009/6/25刘敬堃太原

43、空调27756002009/6/25刘敬堃郑州冰箱34884002009/6/25王腾宇武汉空调391092002009/6/25房天琦沈阳空调451260002009/6/25周德宇太原空调25700002009/6/25刘敬堃郑州彩电12276002009/6/25王学敏北京彩电36828002009/6/25王学敏上海冰箱24624002009/6/25曹泽鑫南京冰6/25王学敏合肥空调26728002009/6/25曹泽鑫天津空调411148002009/6/25周德宇沈阳冰6/25王学敏太原彩电34782002009/6/25王学敏

44、郑州电脑373182002009/6/25房天琦昆明相机22811802009/6/25房天琦贵阳彩电471081002009/6/25曹泽鑫天津相机24885602009/6/25房天琦北京空调12336002009/6/26房天琦南京空调22616002009/6/26周德宇苏州冰箱10260002009/6/26周德宇杭州彩电451035002009/6/26郝宗泉武汉彩6/26周德宇沈阳冰6/26房天琦太原冰箱491274002009/6/26曹泽鑫郑州空调20560002009/6/27王学敏南京冰箱38988002009/6/27

45、郝宗泉杭州空调34952002009/6/27刘敬堃合肥空调411148002009/6/27王腾宇天津空调29812002009/6/27郝宗泉武汉彩电20460002009/6/27郝宗泉沈阳彩电451035002009/6/27周德宇郑州冰6/27周德宇昆明冰箱22572002009/6/28王学敏天津空调22616002009/6/28刘敬堃北京空调27756002009/6/28王腾宇上海冰箱21546002009/6/28王学敏南京彩电27621002009/6/28刘敬堃苏州电脑171462002009/6/28周德宇武汉相机401476002009/6

46、/28王腾宇沈阳彩6/28郝宗泉郑州相机341254602009/6/28刘敬堃上海空调371036002009/6/28周德宇南京空调24672002009/6/28房天琦杭州冰6/28刘敬堃合肥彩电25575002009/6/29周德宇沈阳彩电37851002009/6/29曹泽鑫太原冰箱24624002009/6/29刘敬堃贵阳冰6/29周德宇北京空调10280002009/6/29周德宇上海冰箱32832002009/6/30房天琦杭州空6/30王腾宇武汉空

47、6/30王学敏太原空调29812002009/6/30周德宇郑州彩电39897002009/6/30王学敏沈阳彩电30690002009/6/30郝宗泉上海冰箱37962002009/7/1郝宗泉南京冰箱501300002009/7/1王腾宇杭州空调21588002009/7/1周德宇合肥空调471316002009/7/1周德宇天津冰7/1王学敏武汉彩电491127002009/7/1房天琦沈阳电脑272322002009/7/1郝宗泉太原相7/1王学敏郑州彩电441012002009/7/1王学敏昆明相机451660502009/7/1刘

48、敬堃贵阳空调25700002009/7/1刘敬堃天津空调401120002009/7/1王学敏北京冰箱31806002009/7/1刘敬堃南京彩电16368002009/7/2房天琦苏州彩电20460002009/7/2郝宗泉沈阳冰箱33858002009/7/2王腾宇太原冰7/2王学敏郑州空调381064002009/7/2周德宇北京冰箱391014002009/7/2周德宇上海空调391092002009/7/2周德宇南京空调451260002009/7/2刘敬堃杭州空调411148002009/7/2郝宗泉合肥彩电19437002009/7/2周德宇武汉彩电47

49、1081002009/7/2郝宗泉沈阳冰箱491274002009/7/3郝宗泉郑州冰箱22572002009/7/3房天琦昆明空调30840002009/7/3曹泽鑫贵阳空调22616002009/7/3王学敏天津冰箱23598002009/7/3郝宗泉上海彩电38874002009/7/3周德宇南京电脑181548002009/7/3郝宗泉武汉相机501845002009/7/3王学敏太原彩电28644002009/7/3刘敬堃郑州相机281033202009/7/4曹泽鑫北京空7/4房天琦上海空调27756002009/7/4王学敏南京冰箱48124800200

50、9/7/4刘敬堃杭州彩7/4王学敏合肥彩电451035002009/7/4王腾宇天津冰箱19494002009/7/4王腾宇武汉冰7/4周德宇沈阳空调12336002009/7/4郝宗泉郑州冰箱20520002009/7/4刘敬堃昆明空7/5王学敏贵阳空调25700002009/7/5王学敏天津空调25700002009/7/5王腾宇上海彩电12276002009/7/5周德宇杭州彩电41943002009/7/5曹泽鑫武汉冰箱35910002009/7/5王学敏沈阳冰箱10260002009/7/5周德宇太原空调2

51、2616002009/7/5房天琦郑州空调451260002009/7/5房天琦武汉冰7/5郝宗泉沈阳彩电37851002009/7/6周德宇太原电脑10860002009/7/6王腾宇北京相机481771202009/7/6王学敏上海彩电42966002009/7/6曹泽鑫南京相机371365302009/7/6房天琦杭州空调19532002009/7/6王腾宇合肥空调481344002009/7/6房天琦太原冰箱28728002009/7/6郝宗泉郑州彩电33759002009/7/7王学敏昆明彩电42966002009/7/7周德宇天津冰箱26676002009

52、/7/7房天琦北京冰7/7周德宇上海空调19532002009/7/7周德宇南京冰箱24624002009/7/7郝宗泉苏州空调381064002009/7/7曹泽鑫杭州空调421176002009/7/7刘敬堃武汉空调31868002009/7/7曹泽鑫太原彩电35805002009/7/7曹泽鑫郑州彩电39897002009/7/7王腾宇北京冰箱32832002009/7/7曹泽鑫上海冰箱26676002009/7/7周德宇南京空调25700002009/7/7曹泽鑫杭州空调28784002009/7/7周德宇合肥冰箱10260002009/7/8王学敏武汉彩电3

53、9897002009/7/8周德宇沈阳电脑221892002009/7/8周德宇昆明相机341254602009/7/8周德宇贵阳彩电26598002009/7/8房天琦天津相机351291502009/7/8周德宇北京空调20560002009/7/8刘敬堃上海空调21588002009/7/8王学敏南京冰箱29754002009/7/8房天琦苏州彩电41943002009/7/8王学敏杭州彩电31713002009/7/8王腾宇武汉冰箱471222002009/7/8周德宇郑州冰箱26676002009/7/8王腾宇北京空调361008002009/7/8王学敏上海冰箱1539000200

54、9/7/9周德宇天津空调25700002009/7/9曹泽鑫武汉空调31868002009/7/9王学敏沈阳空调481344002009/7/9周德宇太原彩电42966002009/7/9王学敏郑州彩电12276002009/7/9王腾宇天津冰箱11286002009/7/9周德宇北京冰箱10260002009/7/9刘敬堃上海空调25700002009/7/9周德宇南京空调361008002009/7/9王学敏苏州冰箱431118002009/7/10王学敏杭州彩电10230002009/7/10郝宗泉沈阳电脑121032002009/7/10周德宇太原相机24885602009/7/10刘

55、敬堃郑州彩电491127002009/7/10郝宗泉武汉相机301107002009/7/10王学敏沈阳空调411148002009/7/11周德宇太原空调11308002009/7/11郝宗泉北京冰箱27702002009/7/11周德宇上海彩电471081002009/7/11王学敏南京彩电26598002009/7/11曹泽鑫杭州冰箱481248002009/7/11周德宇沈阳冰7/11周德宇太原空调361008002009/7/11王学敏郑州冰箱401040002009/7/11刘敬堃昆明空调401120002009/7/11周德宇贵阳空调481344002009/7/12周德宇天津空调32896002009/7/12房天琦北京彩电451035002009/7/12刘敬堃上海彩电501150002009/7/12周德宇苏州冰箱20520002009/7/12郝宗泉太原冰箱27702002009/7/12房天琦郑州空调27756002009/7/12王腾宇上海空调23644002009/7/12周德宇南京彩电491127002009/7/12刘敬堃杭州彩电28644002009/7/12周德宇合肥冰7/13王学敏天津冰