The attached spread sheet is calculating the capacity of a beam , the cell showing the capacity is coloured in blue.
I want to make single optimisation using this spread sheet and the optimisation method I want to apply is genetic algorithm .
I prefer to run it using MICROSOFT EXCEL , if that is not applicable MATLAB is ok.
the objective function is the capacity of the section and it should be maximised.
the variables are the dimensions of the section which are
and t .
t is a discrete value of (0.15,0.2,0.25,0.3,0.35,0.4)
the constraints are as follows:
H <= 300*t
B <= 60*t
B <= 0.8*H
D <= 40*t
D <= 0.8*B