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

Beceriler: Matlab ve Mathematica , Matematik, Algoritma, Excel, Mühendislik

( 6 değerlendirme ) Oslo, Norway

Proje NO: #32606281

Bu iş için 12 freelancer ortalamada \$31 teklif veriyor

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 Daha Fazla

\$30 USD in 2 gün içinde
(9 Değerlendirme)
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 Daha Fazla

\$100 USD in 7 gün içinde
(5 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(24 Değerlendirme)
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 Daha Fazla

\$20 USD in 7 gün içinde
(12 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
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 Daha Fazla

\$30 USD in 7 gün içinde
(7 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

\$22 USD in 9 gün içinde
(0 Değerlendirme)
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 Daha Fazla

\$25 USD in 2 gün içinde
(1 Yorum)
0.0