Map certain specific values from excel file in a Genetic Algorithm

2 views (last 30 days)
function x = mapvariables(x)
data=xlsread('newsections.xlsx'); %reading data from excel file.This excel file has 65 rows...
and 15 columns with each column depicting a certain property such as Area, radius etc
x1_2=data(:,7)'; %area is in the 7th column
X1_2=x1_2/10000; % values in m^2
x(1) = X1_2(x(1)); % takes value from specified area values
self_wt=data(:,9);
rmin=data(:,15);
MOIz=data(:,11);
I wish to run GA for the above part. My design variable is x(1). My problem is when I run GA and it takes a certain area, I also want to know corresponding self_wt,rmin etc. That is, I want to find the location of row from which area has been selected, so that I can get the values of rmin,self-wt etc for the corresponding row.
  2 Comments
Don Alexander
Don Alexander on 29 May 2015
Dear Ace_ventura, can u please explain how to take values from an excel sheet & pass it on to objective func & constraint func, the running the GA code......please help....

Sign in to comment.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!