how can i make a column from excel data to a matric.

Hi,

I have 1:21600 for six degree freedom data in excel. I need to transform the results coordinate (global coordinate) for a specific point and I never used matlab. in the attached pic i discribe exactly what i am looking for.

Please see the attached pic.

Answer 1

[KSSV]

tx = rand(10,1) ; 
ty = rand(10,1) ;
tz = rand(10,1) ;

C = [tx ty tz] ; 
m = length(tx) ; 

A = zeros(4,4,m) ; 
for i = 1:m
  A(1:3,1:3,i) = eye(3) ; 
  A(1:3,4,i) = C(i,:) ;
end

[Iman Ramzanpoor]

hi,

thanks for sending the answer, can you please give me a explaniation. for instance can you please let me know what is 10 represent in rand (10,1). thanks

[KSSV]

You have some length for the columns....I have used Rand to create dummy datafor demo. I have taken it'slength tobe 10. This is for demo puprose.

[Iman Ramzanpoor]

Hi KSSV,

thanks for your reply. as i mentioned i never used MATLAB before. to be more clear, please find attached pic. i explained what i am looking for. it is multipication of matric to vector. i appreciate your help.