Skip to main content
P
ptc-63191651-Visitor
1-Visitor
September 8, 2014
Question

Can anyone help on how to use the matrix (taken from an excel file) in the equations...?

  • September 8, 2014
  • 2 replies
  • 1237 views

Can anyone help on how to use the matrix (taken from an excel file) in the equations...?

In the attached Mathcad file you can see that I need to evaluate the output power equation as a function of k (as highlighted in yellow in the last page).

I need the matrix (L11, L22, k etc) to be used in the equation (for the variable k)...

In short, I need to plot a graph Pout(k) vs k........ all the values indicated in the equation of Pout(k) must be taken from the matrix.. please help to get the plot

2 replies

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
September 8, 2014

Mathcad gives you the ability to embed your EXCEL sheet in the document and assign cell values to Mathcad variables.

R
RichardJ19-Tanzanite
19-Tanzanite
September 8, 2014

You need to get rid of the header row, so use the submatrix function to extract the data rather than the row operator. Then vectorize the expression for M, so that M is a vector. Then calculate P.out as a vector, and just plot it against k. You need to fix a units problem though (which I was too lazy to do ).

P
ptc-63191651-VisitorAuthor
1-Visitor
September 8, 2014

Thanks, Thats a good point.. will use the submatrix .!

Terms & ConditionsAccessibility statement