• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now

# NA - 112

### Customer Question

I am trying to build a structure stiffness matrix for a plane truss. I have all the global striffness matrix for each member in an excel file, each member on a different page. Using xlsread, im trying to build the stiffness matrix for the entire truss but I do not know how to read the specific excel file for that member. Here is the code. GK is the global stiffness matrix function [S]=Calculate_S NCJT=2; JB=xlsread('Tutorial3.xlsx', 1, 'J4:J9'); JE=xlsread('Tutorial3.xlsx', 1, 'K4:K9'); NJ=xlsread('Tutorial3.xlsx', 1, 'B3'); GK=xlsread('Output_Tutorial_4', 'A1:D4'); NSC=[ 6 7 1 8 2 3 4 5]'; i=1; NDOF=5; S=zeros(2*NJ,2*NJ); g=1; for i=1:(2*NCJT) if i==1:NCJT; I1=(JB-1)*NCJT+i; N1=NSC(I1); else I1=(JE-1)*NCJT+(i-NCJT); N1=NSC(I1); end for N1=1:NDOF; J=1; for J=1:(2*NCJT); if J==1:NCJT; I1=(JB-1)*NCJT+J; else I1=(JE-1)*NCJT+(J-NCJT); end for N2=1:NDOF; S(N1,N2)=S(N1,N2)+GK(i,J); end end end end

Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Lindie-mod replied 4 years ago.
Hi,
I'm a moderator for this topic. I've been working hard to find a Professional to assist you with your Excel, but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!
Lindie
Customer: replied 4 years ago.

You can cancel this question for me.

Thanks anyways!