Skip to main content
Gunjac1-Visitor
1-Visitor
Jul 10, 2014 5:09 PM UTC
Question

Multiplying values inside a mathcad table

Hi folks!

Is there ny way to multiply values inside Mathcad table like its done in Excel?

See file attached.

Thanx

9 replies

Fred_Kohlhepp23-Emerald I
23-Emerald I
Jul 10, 2014 6:10 PM UTC

You cannot attach an equation to a cell in a mathcad table, the table is either input or a place to display results or output. You can embed an EXCEL sheet in Mathcad and do what you're asking.

Translate
Gunjac1-VisitorAuthor
1-Visitor
Jul 10, 2014 6:24 PM UTC

Sound interesting but I would like to do all in one place.

What you said mean that I must manipulate tablein Excel and then import it in Mathcad, right?

Translate
Fred_Kohlhepp23-Emerald I
23-Emerald I
Jul 10, 2014 8:21 PM UTC

No, you can put an EXCEL sheet (fully functional) into the Mathcad document.

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Jul 10, 2014 9:25 PM UTC

Why would you want to use Excel's cell manipulations when you can have Mathcad's calculation with meaningful variable names and units, too??

Translate
Tezza20101-Visitor
1-Visitor
Aug 9, 2014 1:35 AM UTC

Hi Mario,

Yes there is a way to put the last column in as you require.

The table creates a variable called "lay".

What is done here is create a new variable called "output".

You first extract the columns you need.

Do the arithmatic on the extracted columns in an element by element fashion (With one vectorised expression)

Then reassemble the required individual columns with the "augment" function.

Have enclosed a file that does this as an extension of the one provided.

If required you can set the assign the original "lay" to the new values "output"

Hope it helps.

Translate
Terms & ConditionsAccessibility statement