关 键 词：

VBA 数组 字典 知识 实例

资源描述：

VBA数组教程 excel精英培训网 兰色幻想 从从一一个个实实例例开开始始 Sub v4 运行时间0 01秒 Dim t t Timer For x 1 To 100000 m m 1000 真接调用内存中的值 Next x MsgBox Timer t End Sub Sub v5 运行时间0 5秒 Dim t t Timer For x 1 To 100000 m m Cells 1 1 调用单元格中的值 Next x MsgBox Timer t End Sub 运行的结果是直接调用内存中的值比调用单元格的值快了50倍 为什么会这样呢 我们需要了解一下 VBA的运算原理 VBA的运算原理 VBA中的运算最终是在内存中进行的 如果数据已经在内存中 则直接进行运算 但如果数据是 储存在第三方对象 如单元格里 控件里 里 则还需要先把数据从第三方对象里调入到内存中 然后再 在内存中对数据进行运算 如果把v5的程序进行稍微改动 运行时间会大大缩短 Sub v5 2 运行时间0 5秒 Dim x t t Timer x Cells 1 1 把单元格的值先交给变量 For x 1 To 100000 m m x Next x MsgBox Timer t End Sub 如果VBA多次调用同一样单元格 我们可以先把这个单元格放在一个变量中 如果是多行多列的单元 格区域呢 我们同样可以把把这个区域的值装入一个VBA变量 Sub v6 x Range a1 10000 End Sub 这个VBA变量装入大于1个的数据时 就构成了VBA内存数组 那那什什么么是是VBAVBA数数组组呢呢 1 1 什什么么是是VBAVBA数数组组呢呢 VBA数组就是储存一组数据的数据空间 数据类型可以数字 可以是文本 可以是对象 也可以是 VBA数组 2 2 VBAVBA数数组组的的分分类类 A A 按按维维数数划划分分 1 1维维数数组组 Sub t1 Dim arr 1 To 10 For x 1 To 10 arr x x Next x Stop End Sub 2 2维维数数组组 Sub t2 Dim arr 1 To 10 1 To 2 For x 1 To 10 For y 1 To 2 arr x y x y Next y Next x Stop End Sub 3 3维维数数组组 Sub t3 Dim arr 1 To 10 1 To 2 1 To 3 For x 1 To 10 For y 1 To 2 For z 1 To 3 arr x y z x y z Next z Next y Next x Stop End Sub B B 按按储储存存类类型型划划分分 常常量量数数组组 Sub t4 arr Array 1 2 3 4 5 arr1 Array Array 1 2 Array 10 20 Array 100 200 数组的中储存数组 arr2 a 1 b 2 c 3 调用工作表内存数组构成VBA二维数组 Stop End Sub 静静态态数数组组 固固定定大大小小的的数数组组 静态数组声明方法 dim public private 数组名称 第一维数组上标 to 第一维数组下标 第二维上标 to 第二维下标 Sub t5 Dim arr1 10 声明一个上标是0 下标是10的数组 Dim arr2 1 To 10 声明一个上标是1 下标是10的数组 Dim arr3 1 To 10 1 To 2 声明一个10行2列的二维数组 End Sub 动动态态数数组组 大大小小不不固固定定的的数数组组 动态数组的声明方法 和静态数组不同的时 动态数组需要先用Dim声明 数组大小得出 结果后还需要再用Redim进行二次声明 Dim 数组名称 Redim 数组名称 第一维数组上标 to 第一维数组下标 第二维上标 to 第二维下标 例例1 1 Sub darr Dim arr 声明一个动态的arr数组 不知道它能盛多少数据 Dim k k Application WorksheetFunction CountIf Range a2 a60 10 计算大于10的个数 ReDim arr 1 To k 再次声明arr的大小 正好盛下k数量的值 For x 2 To 6 If Cells x 1 10 Then m m 1 arr m Cells x 1 通过循环把大于10的数字装入数组 End If Next x MsgBox arr 2 End Sub 如果数组需要随一个变量不断的扩充 数组就需要多次声明 每扩充一次就声明一次 Redim Preserve 1 to k 如果数组是多维的 只能动态声明第末维的 如果需要把让第一维不断扩充 还需要先转置 有点麻烦 这里就不再详述 遇到这种情况 我们可以声明一个足够大的静态数组来取代动态数组 运行速度较前者快 1 1 单单元元格格区区域域存存入入VBAVBA数数组组 Sub test Dim arr 声明一个变量用来盛放单元格数据 Dim x As Integer arr Range a2 d5 把单元格数据搬入到arr里 它有4列4行 For x 1 To 4 通过循环在arr数组中循环 arr x 4 arr x 3 arr x 2 数组的第4列 金额 第3列 第2例 Next x Range a2 d5 arr 把数组放回到单元格中 End Sub 2 2 一一维维VBAVBA数数组组放放入入单单元元格格区区域域中中 Sub test1 Dim arr 1 To 5 声明一维数组 For x 1 To 5 arr x x 2 通过循环给每个位置赋值 Next x Range A1 E1 arr 把数组导入到excel中的a1 e1单元格中 Range A1 A5 Application Transpose arr 如果是放在一列中 就需要对数组进行转置后 再存放 End Sub 1 1 计计算算VBAVBA数数组组的的大大小小 Sub b1 Dim arr 3 To 4 MsgBox UBound arr 下标 MsgBox LBound arr 上标 For x 3 To 4 arr x x 2 Next x MsgBox Application Count arr 含有数据元素的个数 End Sub Sub b2 Dim arr arr Sheets 1 UsedRange Usedrange的行数和列数是未知的 MsgBox UBound arr 1 可以计算这个区域有多少行 MsgBox UBound arr 2 可以计算出这个区域有多少列 End Sub 2 VBA2 VBA数数组组的的筛筛选选 Sub b3 arr Array ABC A D CA ER arr1 VBA Filter arr A True 筛选所有含A的数值组成一个新数组 arr2 VBA Filter arr A False 筛选所有不含A的数值组成一个新数组 Stop End Sub 3 3 VBAVBA数数组组的的拆拆分分与与合合并并 Sub t2 arr2 Range A1 B4 把单元格区域A1 B4的值装入数组arr2 arr3 Application Index arr2 2 把数组第2列拆分出来装入新数组arr3中 Stop新数组为二维数组 End Sub 如果想按行拆分 除了api函数外是没有其他办法的 如果想把两个数组进行组合成一个数组 只有一个办法 就是通过循环 4 4 VBAVBA数数组组的的最最值值 Sub t3 arr Array 1 35 4 13 MsgBox Application Max arr 最大值 MsgBox Application Min arr 最小值 End Sub Sub t4 arr Array 1 35 4 13 MsgBox Application Large arr 2 第2大值 MsgBox Application Small arr 2 第2小值 End Sub 5 5 数数组组的的统统计计与与求求和和 Sub t5 arr Array 1 35 4 13 MsgBox Application Sum arr 对数组进行求和 End Sub Sub t6 arr Array 1 35 a 4 13 b MsgBox Application Count arr 返回数字的个数4 MsgBox Application CountA arr 返回数组文本和数字的总个数 End Sub 6 6 数数组组的的查查询询 Sub t7 arr Array 1 35 4 13 MsgBox Application Match 4 arr 0 查询数值4在数组Arr中的位置 End Sub 7 7 数数组组的的转转置置 Sub t8 arr Array 1 35 a 4 13 b arr1 Application Transpose arr Stop End Sub Sub t9 arr Range a1 a5 arr1 Application Transpose arr Stop End Sub 8 8 字字符符串串与与VBAVBA数数组组 Sub t1 Dim arr myst As String myst A REW E RWC 2 RWC arr Split myst 按 分隔成一组数装入数组中 k Join arr 再用 把数组的每个值连接成一个字符串 结果为 A REW StopE RWC 2 RWC End Sub 9 9 巧巧妙妙利利用用数数组组的的标标 因为数组的标是唯一的 所以我们就利用这个特点去除重复的数值 Sub r1 Dim arr arr2 1 To 13 1 To 1 arr Range a1 a13 For x 1 To UBound arr arr2 arr x 1 1 arr x 1 Next x Range b1 Resize 13 arr2 End Sub 10 10 重重新新初初始始化化数数组组 Sub r2 Dim arr 1 To 10 For x 1 To 10 arr x x Next x Stop Erase arr 如果arr是动态数组 下次使用前还需要用redim设置数组的大小 Stop For x 1 To 10 arr x x Next x Stop End Sub 安泰原料库存一览表 开始日期7月1日结束日期7月30日 代代码码原原料料名名称称规规格格型型号号类类别别期期初初数数量量本本月月发发料料本本月月用用料料本本月月退退料料 A630001ACW9532406 1镜头 10050030020 A630002CW5231606 1镜头 10050030030 A630003CW6231706 1镜头 10050030022 A6300043228 LED3228 LEDLED 10050030045 A6300050201 0 1UF电容0201 电容电容 10050030061 A6300060402 0 1UF电容0402 电容电容 10050030031 A630007OV2655OV2655芯片芯片 10050030024 A630008OV7675OV7675芯片芯片 10050030041 A630009BF3603BF3603芯片芯片 10050030010 A630010G0307G0307芯片芯片 1005003005 A630011FPC KML084BKML084BFPC 1005003006 A630012FPC KML083BKML083BFPC 1005003008 A630013FPC KML142GKML142GFPC 10050030016 A630014FPC KML040G BKML040G BFPC 10050030017 A630015FPC KML040G AKML040G AFPC 10050030021 A630016FPC KML075V BKML075V BFPC 100500 仓仓库库结结存存 280 270 278 255 239 269 276 259 290 295 294 292 284 283 279 600 发 料 明 细 表 领领料料单单号号领领料料日日期期生生产产产产品品物物料料编编码码类类别别物物料料名名称称 2010 7 10A630001ACW953240 2010 7 11A630002CW523160 2010 7 12A630003CW623170 2010 7 13A6300043228 LED 2010 7 14A6300050201 0 1UF电容 2010 7 15A6300060402 0 1UF电容 2010 7 16A630007OV2655 2010 7 17A630008OV7675 2010 7 18A630009BF3603 2010 7 19A630010G0307 2010 7 20A630011FPC KML084B 2010 7 21A630012FPC KML083B 2010 7 22A630013FPC KML142G 2010 7 23A630014FPC KML040G B 2010 7 24A630015FPC KML040G A 2010 7 25A630016FPC KML075V B 规规格格单单位位领领料料数数量量领领料料部部门门领领料料人人用用料料原原因因 6 1镜头500甲 6 1镜头500乙 6 1镜头500丙 3228 LEDLED500丁 0201 电容电容500戊 0402 电容电容500己 OV2655芯片芯片500庚 OV7675芯片芯片500辛 BF3603芯片芯片500壬 G0307芯片芯片500癸 KML084BFPC500甲 KML083BFPC500乙 KML142GFPC500丙 KML040G BFPC500丁 KML040G AFPC500戊 KML075V BFPC500己 发 料 明 细 表 引用 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 产线代工用料明细表 领领料料单单号号类类别别日日期期编编码码原原料料名名称称规规格格型型号号 R20100716001 KML063G2010 7 16A630001ACW9532406 1 R20100716001 KML063G2010 7 16A630002CW5231606 1 R20100719001 KML063G2010 7 19A630003CW6231706 1 R20100719001 KML063G2010 7 19A6300043228 LED3228 LED KML064G2010 7 20A6300050201 0 1UF电容0201 电容 KML065G2010 7 21A6300060402 0 1UF电容0402 电容 KML066G2010 7 22A630007OV2655OV2655芯片 KML067G2010 7 23A630008OV7675OV7675芯片 KML068G2010 7 24A630009BF3603BF3603芯片 KML069G2010 7 25A630010G0307G0307芯片 KML070G2010 7 26A630011FPC KML084BKML084B KML071G2010 7 27A630012FPC KML083BKML083B KML072G2010 7 28A630013FPC KML142GKML142G KML073G2010 7 29A630014FPC KML040G BKML040G B KML074G2010 7 30A630015FPC KML040G AKML040G A KML075G2010 7 31A630016FPC KML075V BKML075V B 单单位位数数量量金金额额税税额额价价税税合合计计 领领料料单单位位生生产产产产品品 pcs300甲KML063G pcs300乙KML063G pcs300丙KML063G pcs300丁KML063G pcs300戊KML064G pcs300己KML065G pcs300庚KML066G pcs300辛KML067G pcs300壬KML068G pcs300癸KML069G pcs300甲KML070G pcs300乙KML071G pcs300丙KML072G pcs300丁KML073G pcs300戊KML074G pcs300己KML075G 产线代工用料明细表 引用 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 退 料 明 细 表 退退料料单单号号退退料料日日期期生生产产产产品品物物料料编编码码类类别别物物料料名名称称 2010 7 18A630001ACW953240 2010 7 18A630002CW523160 2010 7 18A630003CW623170 2010 7 19A6300043228 LED 2010 7 20A6300050201 0 1UF电容 2010 7 21A6300060402 0 1UF电容 2010 7 22A630007OV2655 2010 7 23A630008OV7675 2010 7 24A630009BF3603 2010 7 25A630010G0307 2010 7 26A630011FPC KML084B 2010 7 27A630012FPC KML083B 2010 7 28A630013FPC KML142G 2010 7 29A630014FPC KML040G B 2010 7 30A630015FPC KML040G A 2010 7 31A630016FPC KML075V B 规规格格单单位位退退料料数数量量退退料料类类别别收收料料人人备备注注 6 1pcs20甲 6 1pcs30乙 6 1pcs22丙 3228 LEDpcs45丁 0201 电容pcs61戊 0402 电容pcs31己 OV2655芯片pcs24庚 OV7675芯片pcs41辛 BF3603芯片pcs10壬 G0307芯片pcs5癸 KML084Bpcs6甲 KML083Bpcs8乙 KML142Gpcs16丙 KML040G Bpcs17丁 KML040G Apcs21戊 KML075V Bpcs22己 退 料 明 细 表 引用 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 编号 数量编号 编号个数编号 数量编号数量编号数量 84 848684846843732334194213419421 84 883234344341942128157105726094 34 28162828428157105264854528612 28 249057575572609430171126721285 578705555264856132513528587 5 817330304301711235285873837689 30 6267616113617389014213445435937 61 872970707704342927284736233917 70 413068683681458717165566918741 68 505045456452861216424023235324 45 509893934932238338376894117571 93 622467673672128522167854321446 67 858766661325115171873927404 636778788783753129376554631624 78 616391916913940032353244836325 91 421935357352858718351553332973 35 107779792791564139274044216091 79 813614145142134423290915315755 14 62892727727284737200676632948 27 364280807804829333329735233218 5 72559494694322872347674919628 80 538976764762220613230504025928 80 900117174171655626169856421241 94 42771616916424021126153731730 7679438387383768925196503625280 17 862647471047612043425245920718 1615054547543593731102374415377 38381757567531604818055 47 702688882884694423981 79 750573731173542251218518 54 3649992915502425194 759202222422167851920601 16 42021515415171873731730 88 383695951095388903625280 73 21329898598321602017594 91676262562339172113512 22 28489696129658009 15 3868696956918741 95516292962937655 47 5283323293235324 35 2068414144117571 98 4928909039010938 刷新 62 3250181871835155 96 6503434344321446 69 1002868668634431 29 7639393953927404 32 1984232352329091 91 4385773720067 15 7225464664631624 41 7719484884836325 90 5872333373332973 47 9071929259228650 91 8704424244216091 29 6938505025011594 61 794311113119367 18 9348228234767 43 7950727287236623 86 2263656546512479 39 812710104108566 3242636336313950 14 1260100100710045809 96 6533535335315755 29 9094818138115090 54 9135666656632948 18 4945838348325153 23 7017131351323050 7 8739525265233218 46 1332262632616985 1880399991994452 16 7317828248216850 48 3841606026011835 48 5192717197163785 62 9447113112615 45 4236898968935858 33 3545494934919628 92 3285252532519650 29 9691337342524 42 1841404064025928 47 7370313183110237 50 6868646446421241 90 1736878738715130 11 3553884818055 2 9145444423981 72 7272858538512054 42 8819121241218518 45 396974742748207 48 9627242442425194 18 4973191961920601 65457373783731730 10313777777733750 63 1747363633625280 100 296797971974822 67 4155595955920718 53 1978444434415377 81 568051512518554 95 833655553559008 66 1475202032017594 65 2354212122113512 6 188858581588883 80 9143 27 7275 83 3048 17 3179 76 8617 57 1879 13 5836 52 1109 46 2713 76 3513 61904 46 8213 95 3573 26 5737 99 4452 82 5224 26 2229 30 2382 100 2542 60 4864 53 9489 71 8342 53 4288 1 4089 32 8743 89 5293 2 7812 66 5646 49 8099 83 9813 35 2023 28 5514 25 9377 32 7111 52 8520 2 7646 3 2975 82 2741 40847 62 4318 31 3954 64 9439 87 5328 31995 92 9709 6812 65 2192 16 9497 8300 95759 23 2272 31 1351 100 4703 96642 94 1352 45 1094 22 3240 91 7758 72481 30 4494 40 2448 60 6971 48 6374 73 5189 28 3729 65 7476 93 5293 61 1932 100 7837 96 1178 73 7347 27867 4 4490 73 5376 73 6466 72 2104 18 1589 32 3057 86 9708 27 2771 42539 70 9203 85 2974 86 6609 75 1442 22 7441 12 6044 92 5518 48 1013 70965 8 8864 96 4060 72 6253 54 1793 10 1497 43493 64 8138 23 6417 74 4589 42 4892 63 8819 33 8505 33 2671 48 6346 74 3618 28 3977 48 1899 24 8148 2239 71 5072 80 6282 19 4748 40 6012 24 5005 37 3198 77 5589 31770 71 9386 10 5619 7 1808 36 9054 77 1316 57 4738 97 4822 11 1450 40 7137 61 4262 90 3330 37 3854 25 5488 33 7212 67 8543 19601 35 6688 96 7997 100 9618 45 8908 37 1406 61 6318 11 4364 15 1516 34 5322 12 4750 69 1125 52 3762 16591 4163 59 1535 64 2734 95 7969 43 6543 92 7840 84 2454 95 1935 89 2606 45 5307 4 7736 8 1258 18 4991 38 4730 66 8157 85211 35701 2 1491 3 9366 6 1675 59 4144 54 2403 69 1185 15 4578 8 7633 44 9775 51848 82 8191 71 4832 6 2298 46 8469 78 4258 19895 87 1932 29 2273 94 9534 38 3491 37 6275 13 9213 94 6207 9533 16 1532 61 7274 96 2698 2 1171 89 7449 55 1060 25 4785 37 3349 27 4319 35 8764 17 1143 73 4043 3 7831 27 3055 33702 72753 89 8549 33 5349 59 2795 80 6401 78 1048 80 5276 52 7145 32 9255 100 8907 13 2762 20 5315 52 5269 71 9329 84 4999 46 2978 38 9529 54 8791 14 9354 23 4739 37 4776 50 4726 39 2428 70 8502 46 7919 5 7059 78 5780 34 6867 49 9741 87 7870 77 9350 84 3099 89 8283 31195 47 6638 24 2907 48 2033 19 8668 73 6881 9 1383 1411 63 3384 40 3533 43 6460 83 9958 57 9204 76 9282 94 3150 38 6227 44359 3 7769 91 8243 77 6990 69 6086 71 8939 37 3758 47 6308 85 8869 32 3116 69 9343 4 2878 86 3015 89 3678 30 3969 3 3608 98 3666 41 6627 59 7971 19 4313 96 9871 94 7767 29

内容简介：

-