How to implement separation requirements

Hi all,
i'm having trouble on where/how to begin this task. essentially i have an excel spreadsheet (For sake of ease) that contain separation requirements (mm) of various objects if theyre selected with each other. I'd like to implement these separation requirements into matlab which can allow a user to select -initially- a few of the objects and be able to output the relative distances between each entity. how can i go sbout doing this? ideally id like to just import the selected tables into matlab, since there are many objects and thus a lot of separation requirements but its how to code in these rules thats throwing me off. any help will be greatly appreciated. any questions, ask away!

 采纳的回答

Hey Zain,
Could you please share a snippet of the data file? Further providing an example which explains what functionality you want from that data would also be helpful.
This link can be used to draft questions effectively. It will provide clarity to further help you.

3 个评论

Hi Pranjal,
I've re-uploaded the question with an example of the excel file and code here:
Any help will be greatly appreciated.
Thanks
Hey Zain,
You can refer the following code snippet
data = readtable('Example.xlsx', 'VariableNamingRule', 'preserve');
pipe1Data = data.('Pipe 1');
pipe2Data = data.('Pipe 2');
seperationData = data.('Separation');
pipe1prompt = 'Select the first pipe type ';
pipe1_Input = input(pipe1prompt, 's');
pipe2prompt = 'select the second pipe type ';
pipe2_Input = input(pipe2prompt, 's');
[row,col] = find(cellfun(@(x)isequal(x,pipe1_Input), pipe1Data) & cellfun(@(x)isequal(x,pipe2_Input), pipe2Data));
for i = 1:length(row)
disp(seperationData(row(i), col(i)));
end
Hope this helps!
thank you, that's worked perfectly!

请先登录,再进行评论。

更多回答(0 个)

类别

帮助中心File Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品

版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by