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
| Dim Optimum As Long
Optimum = 600000
For i = 2 To 4
For j = 2 To 4
For k = 2 To 4
Sheets("Données Projet").Cells(28, 3) = Sheets("Toit").Cells(i, 14)
Sheets("Données Projet").Cells(31, 3) = Sheets("Toit").Cells(i, 20)
Sheets("Données Projet").Cells(32, 3) = Sheets("Toit").Cells(i, 18)
Sheets("Données Projet").Cells(28, 4) = Sheets("Mur").Cells(j, 14)
Sheets("Données Projet").Cells(31, 4) = Sheets("Mur").Cells(j, 20)
Sheets("Données Projet").Cells(32, 4) = Sheets("Mur").Cells(j, 18)
Sheets("Données Projet").Cells(28, 5) = Sheets("Sol").Cells(k, 14)
Sheets("Données Projet").Cells(31, 5) = Sheets("Sol").Cells(k, 20)
Sheets("Données Projet").Cells(32, 5) = Sheets("Sol").Cells(k, 18)
SolverReset
SolverOk SetCell:="$F$42", MaxMinVal:=2, ValueOf:="0", ByChange:="$C$36:$E$36"
SolverAdd CellRef:="$F$45:$F$47", Relation:=3, FormulaText:="$H$45:$H$47"
SolverAdd CellRef:="$F$48", Relation:=1, FormulaText:="$H$48"
SolverAdd CellRef:="$F$49:$F$51", Relation:=3, FormulaText:="$H$49:$H$51"
SolverOk SetCell:="$F$42", MaxMinVal:=2, ValueOf:="0", ByChange:="$C$36:$E$36"
If Sheets("données Projet").Cells(42, 6) < Optimum Then
SolverFinish (1)
Optimum = Sheets("données Projet").Cells(42, 6)
Else
SolverFinish (2)
End If
Next k
Next j
Next i |
Partager