Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Re: Multiplying values inside a mathcad table

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-10-2014
01:09 PM

07-10-2014
01:09 PM

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

Labels:

9 REPLIES 9

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-10-2014
02:10 PM

07-10-2014
02:10 PM

Re: Multiplying values inside a mathcad table

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.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-10-2014
02:24 PM

07-10-2014
02:24 PM

Re: Multiplying values inside a mathcad table

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?

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-10-2014
04:21 PM

07-10-2014
04:21 PM

Re: Multiplying values inside a mathcad table

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

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-10-2014
11:07 PM

07-10-2014
11:07 PM

Re: Multiplying values inside a mathcad table

I remember someone doing some interesting things using tables in Prime 3.0; Valery maybe? Anyway, you can write formulas in tables but the results posted outside. Please see some simple examples attached.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-14-2014
05:58 AM

07-14-2014
05:58 AM

Re: Multiplying values inside a mathcad table

Fred,

is there anyway that you can SUM all the values from column C and create an Mathcad solution?

See file attached.

Thank you.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-14-2014
07:03 AM

07-14-2014
07:03 AM

Re: Multiplying values inside a mathcad table

Yes,but why would you?

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-14-2014
07:53 AM

07-14-2014
07:53 AM

Re: Multiplying values inside a mathcad table

is there anyway that you can SUM all the values from column C and create an Mathcad solution?

You are just about to switch from Excel calculation sheets to Mathcad, right?

See the attached for doing what you have demanded without using and embedding Excel, which I consider an anachronism anyway for this task.

I think you should forget about thinking in rows and columns and cell formulas but rather think the way you would use your formulas in a more natural way. I know, after using Excel for some years one begins to believe that pure numbers in a grid without any units, with an awkward way to name cell ranges and with hidden formulas is natural, but it sure isn't.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-10-2014
05:25 PM

07-10-2014
05:25 PM

Re: Multiplying values inside a mathcad table

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

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

08-08-2014
09:35 PM

08-08-2014
09:35 PM

Re: Multiplying values inside a mathcad table

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.