1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
| lngNbLTabPrdt = DCount("*", "RTop_MAT")
ReDim Preserve tabPrdt(1 To lngNbLTabPrdt, 9 To 80)
ReDim Preserve tabPdrg(1 To lngNbLTabPrdt, 1 To 12)
reqTopOcp.MoveFirst
For cpt = 1 To lngNbLTabPrdt
tabPdrg(cpt, 1) = reqTopOcp("[Ref]")
tabPrdt(cpt, 9) = reqTopOcp("[MAchTot]")
tabPrdt(cpt, 10) = reqTopOcp("[MATN]")
If tabPrdt(cpt, 10) = 0 Then
tabPrdt(cpt, 11) = 0
Else: tabPrdt(cpt, 11) = (tabPrdt(cpt, 9) - tabPrdt(cpt, 10)) / tabPrdt(cpt, 10)
End If
tabPrdt(cpt, 12) = reqTopOcp("[MAchTot]") - reqTopOcp("[MAchG]")
tabPrdt(cpt, 13) = reqTopOcp("[MATN]") - reqTopOcp("[MAGN]")
If tabPrdt(cpt, 13) = 0 Then
tabPrdt(cpt, 14) = 0
Else: tabPrdt(cpt, 14) = (tabPrdt(cpt, 12) - tabPrdt(cpt, 13)) / tabPrdt(cpt, 13)
End If
tabPrdt(cpt, 15) = reqTopOcp("[MAchG]")
tabPrdt(cpt, 16) = reqTopOcp("[MAGN]")
If tabPrdt(cpt, 16) = 0 Then
tabPrdt(cpt, 17) = 0
Else: tabPrdt(cpt, 17) = (tabPrdt(cpt, 15) - tabPrdt(cpt, 16)) / tabPrdt(cpt, 16)
End If
tabPrdt(cpt, 18) = tabPrdt(cpt, 9) - reqTopOcp("[MBE]")
tabPrdt(cpt, 19) = tabPrdt(cpt, 10) - reqTopOcp("[MBEN]")
If tabPrdt(cpt, 19) = 0 Then
tabPrdt(cpt, 20) = 0
Else: tabPrdt(cpt, 20) = (tabPrdt(cpt, 18) - tabPrdt(cpt, 19)) / tabPrdt(cpt, 19)
End If
tabPrdt(cpt, 21) = tabPrdt(cpt, 18) - tabPrdt(cpt, 15)
tabPrdt(cpt, 22) = tabPrdt(cpt, 19) - tabPrdt(cpt, 16)
If tabPrdt(cpt, 22) = 0 Then
tabPrdt(cpt, 23) = 0
Else: tabPrdt(cpt, 23) = (tabPrdt(cpt, 21) - tabPrdt(cpt, 22)) / tabPrdt(cpt, 22)
End If
End If
tabPrdt(cpt, 72) = reqTopOcp("[UVFT]")
tabPrdt(cpt, 73) = reqTopOcp("[UVFTN]")
If tabPrdt(cpt, 73) = 0 Then
tabPrdt(cpt, 74) = 0
Else: tabPrdt(cpt, 74) = (tabPrdt(cpt, 72) - tabPrdt(cpt, 73)) / tabPrdt(cpt, 73)
End If
tabPrdt(cpt, 75) = tabPrdt(cpt, 72) - reqTopOcp("[UVFE]") - reqTopOcp("[UVFH]")
tabPrdt(cpt, 76) = tabPrdt(cpt, 73) - reqTopOcp("[UVFEN]") - reqTopOcp("[UVFHN]")
If tabPrdt(cpt, 76) = 0 Then
tabPrdt(cpt, 77) = 0
Else: tabPrdt(cpt, 77) = (tabPrdt(cpt, 75) - tabPrdt(cpt, 76)) / tabPrdt(cpt, 76)
End If
tabPrdt(cpt, 78) = reqTopOcp("[UVFE]")
tabPrdt(cpt, 79) = reqTopOcp("[UVFEN]")
If tabPrdt(cpt, 79) = 0 Then
tabPrdt(cpt, 80) = 0
Else: tabPrdt(cpt, 80) = (tabPrdt(cpt, 78) - tabPrdt(cpt, 79)) / tabPrdt(cpt, 79)
End If
reqTopOcp.MoveNext
Next |
Partager