Skip to main content
1-Visitor
August 25, 2016
Question

Table Basics

  • August 25, 2016
  • 4 replies
  • 17769 views

‌hi,

im trying to make the jump from excel to prime for good.

im trying to find how to create data from a table. In a very basic example if I create a 2 by 3 table with 1, 2 and 3 in the first two columns, how in mathcad do I calculate a third column that would return for example the multiplication of column 1 and 2 (appreciate this is actually column 0 and 1?

in excel I would have typed =A1*B1 and dragged down through column C. Then I could do things like evaluating the sum of any column or row. Looking to see how this is acheived in mathCaD. If there is an existing tutorial on this id appreciate being pointed in the right direction.

cheers,

andy

ps on my phone which is why this message looks like it's written by a child.

4 replies

25-Diamond I
August 25, 2016

How about something like this:

Its important to use vectorization, otherwise c is calculated as vector product (-->14)-

Its not necessary to use matrices, but if you insist you could do something like

Werner

23-Emerald V
August 25, 2016

Andy Wibroe wrote:

im trying to find how to create data from a table. In a very basic example if I create a 2 by 3 table with 1, 2 and 3 in the first two columns, how in mathcad do I calculate a third column that would return for example the multiplication of column 1 and 2 (appreciate this is actually column 0 and 1?

in excel I would have typed =A1*B1 and dragged down through column C. Then I could do things like evaluating the sum of any column or row. Looking to see how this is acheived in mathCaD. If there is an existing tutorial on this id appreciate being pointed in the right direction.

Adding to Werner's reply, there are several ways to approach this problem - the main adjustment that people need to make when moving from Excel to Mathcad is to make use of Mathcad's operators and functions and to remember Mathcad is not a spreadsheet.

Stuart

23-Emerald IV
August 25, 2016

And in Prime (which many discourage to use at the moment because it is still, in many respects except a few, inferior to Mathcad 15)

using its 'table' feature, it might look like this:

But you can also use the constructs that Werner and Stuart have shown:

Note that if you buy Prime, you get Mathcad 15 for free.

Success!
Luc

awibroe1-VisitorAuthor
1-Visitor
August 29, 2016

‌thanks to all!

a Quick question on arrays, can you only create an array of from a number to another by a given step 12345 or 2468. Or can you be more sophisticated like doubling the previous number ie 1248 etc or by some other other formula?

1-Visitor
August 29, 2016

An array can be anything you want:

1-Visitor
August 29, 2016

Good clarification, Luc.

I also thought of one more way it can be helpful to define arrays:

(two means to achieve the same thing)