Optimisation using genetic algorithm

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 >=10

H <= 300*t

B >=3

B <= 60*t

B >=0.2*H

B <= 0.8*H

D >=1

D <= 40*t

D >=0.2*B

D <= 0.8*B

Skills: Matlab and Mathematica, Mathematics, Algorithm, Excel, Engineering

About the Client:
( 6 reviews ) Oslo, Norway

Project ID: #32606281

12 freelancers are bidding on average $31 for this job


I am a PhD in Operations Research with 12 years of experience in developing and deploying Optimization solutions for various organisations and institutions. Currently I am working as a Lead AI Scientist in a top tier U More

$30 USD in 2 days
(9 Reviews)

Hello, there I am an expert full stack development dealing with matlab, python, C++ etc... I have worked on many GA projects. I am open to discuss more details of the project now, Looking to hearing from you. Please More

$100 USD in 7 days
(5 Reviews)

Hi There, Hope you are doing well, Did run solver by varying H, b & D and got the following H 120 B 24 D 6.108835012. Mn([login to view URL]) [login to view URL] 3772.425224 (Max) Interested in your posting as I’m used to perform More

$20 USD in 1 day
(24 Reviews)

Hi Good day! I have seen your job description and interested in work. I have two international journal publications in which I have used Genetic algorithm. I know how to apply GA on complex problem. It would be great More

$20 USD in 7 days
(12 Reviews)

Dear I'm interested to discuss more about your project after reading your description. I am Program developer with 7 years of experience. I have many experiences working on similar projects to develop image and audio p More

$20 USD in 1 day
(5 Reviews)

Hi, good afternoon, actually it is possible to solve the problem with excel. But what is your deadline to solve it? I can work it, I am a mathematician with experience in solving and simulations and optimizations prob More

$30 USD in 7 days
(7 Reviews)

I have read and understood all your project details and I feel my self the best candidate to complete this project with 100% accuracy. I have vast amount of experience in this industry since I am working from 2020 as a More

$30 USD in 1 day
(2 Reviews)

I am interested in your work and i I will complete your in the best way because I am expert and very hard working person

$20 USD in 7 days
(0 Reviews)

Dear sir My name is vinod Kumar .i read your project information and understand this project. i as m expert algorithm and mathematics . I want work this. .i intrested this Work. I I's I I's about More

$22 USD in 9 days
(0 Reviews)

Hi I can do this by using the macro and VBA in excel . I can design for you dynamic dashboards for data. I can use a lot of functions to make our work is easy. I am an expert in Excel and all programs of Microsoft More

$25 USD in 2 days
(1 Review)

Hi there! I am an engineer and a MATLAB expert in mathematics, especially optimization and history matching. I had plenty of projects with optimization tool of MATLAB and genetic algorithm during my professional perio More

$20 USD in 1 day
(0 Reviews)

Hello I am an aerospace engineer with a Masters in mechanical engineering. I have 14 years experience in matlab /simulink based solution development. I have applied various optimization algorithms for mechanical produc More

$30 USD in 7 days
(0 Reviews)