|
- Sub grf()
- Set d = CreateObject("scripting.dictionary")
- Arr = Sheets("产能").[a1].CurrentRegion
- For i = 2 To UBound(Arr) '站点和产能关系
- d(Arr(i, 1)) = Arr(i, 2)
- Next
- Arr = Sheets("条件").[a1].CurrentRegion
- ReDim brr(1 To 10 * UBound(Arr), 1 To 3)
- For i = 2 To UBound(Arr)
- x = Arr(i, 1)
- xrr = Split(x, ",")
- zd = Split(xrr(0), "/")(0) '站点
- cn = d(zd) '该站点的产能
- If cn > 0 Then
- For k = 0 To UBound(xrr)
- yrr = Split(xrr(k), "/")
- n = n + 1
- For j = 0 To UBound(yrr)
- cl = Val(yrr(2)) '产量
- brr(n, 1) = yrr(0)
- brr(n, 2) = yrr(1)
- brr(n, 3) = IIf(cn > cl, cl, cn)
- Next
- cn = cn - cl
- Next
- End If
- Next
- Sheets("结果").[a2].Resize(n, 3) = brr
- End Sub
复制代码 |
|