cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Matrix results in to excel - help!

ptc-5377589
1-Newbie

Matrix results in to excel - help!

I am wanting to produce a large data table in excel that gives me results based upon formula using 2 nested vectors (I hope I have my terminology correct).

Q1: In my simple attached example I am firstly confused why this displays 1 x 9 and not 3 x 3?

Q2: Nevertheless I have created an excel component in mathcad to display the results and typed the individual input variable and assigned it a cell reference. This is OK when I have only a 3 x 3 matrix but if this is say 40 x 15 this is isn't realistic.

Is there a more elegant way I can do this for a large data set? My ultimate objective is to copy and paste a 40 x 15 data set in to a WORD document.

1 REPLY 1
RichardJ
19-Tanzanite
(To:ptc-5377589)

See the attached worksheet.

Top Tags