1 2 3 4 5 6 7 8 9 10 11 12 13 14
| i = 3
While ((Worksheets(1).Cells(i, 1)) <> ReferenceSpeed.Speed95_h)
Si = Si + (Worksheets(1).Cells(i + 1, 1) - Worksheets(1).Cells(i, 1)) * Worksheets(1).Cells(i + 1, 2) + 0.5 * ((Worksheets(1).Cells(i + 1, 1) - Worksheets(1).Cells(i, 1)) * (Worksheets(1).Cells(i + 1, 2) - Worksheets(1).Cells(i, 2)))
If Si < (0.51 * Stot) Then
Nmin = Worksheets(1).Cells(i + 1, 1)
Smin = Si
Tmin = Worksheets(1).Cells(i + 1, 2)
Else
Nmax = Worksheets(1).Cells(i + 1, 1)
Smax = Si
Tmax = Worksheets(1).Cells(i + 1, 2)
Exit while
End If
Wend |
Partager