# 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

H

B

D

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

Tietoa asiakkaasta:
( 6 arvostelua ) Oslo, Norway

Projektin tunnus: #32606281

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

soumojit86

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)
3.9
DanilVavilov

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)
3.6
Leozida

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)
3.8
harfarooqi

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)
3.4
AlexeiDeveloper1

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)
3.5
cargamento2000

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)
3.6
Samidullo

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)
2.1
Abuzargour84

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)
0.0
vinodjonwal495

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)
0.0
hossamhamdy157

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)
0.0