Map certain specific values from excel file in a Genetic Algorithm
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
Don Alexander
2015-5-29
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....
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Genetic Algorithm 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!