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

Taidot: Matlab ja Mathematica, Matematiikka, Algoritmi, Excel, tekniikka

Tietoa asiakkaasta:
( 6 arvostelua ) Oslo, Norway

Projektin tunnus: #32606281

12 freelanceria on tarjonnut keskimäärin $31 tähän työhön


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 Lisää

$30 USD 2 päivässä
(9 arvostelua)

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 Lisää

$100 USD 7 päivässä
(5 arvostelua)

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 Lisää

$20 USD 1 päivässä
(24 arvostelua)

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 Lisää

$20 USD 7 päivässä
(12 arvostelua)

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 Lisää

$20 USD 1 päivässä
(5 arvostelua)

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 Lisää

$30 USD 7 päivässä
(7 arvostelua)

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 Lisää

$30 USD 1 päivässä
(2 arvostelua)

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 7 päivässä
(0 arvostelua)

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 Lisää

$22 USD 9 päivässä
(0 arvostelua)

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 Lisää

$25 USD 2 päivässä
(1 arvostelu)

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 Lisää

$20 USD 1 päivässä
(0 arvostelua)

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 Lisää

$30 USD 7 päivässä
(0 arvostelua)