Skip to main content
S
SFares14-Alexandrite
14-Alexandrite
October 10, 2013
Solved

table generation

  • October 10, 2013
  • 2 replies
  • 3691 views

Hello,

Attached is a mathcad14 sheet.Is it possible to have mathcad generate a table after the automation of the calculation? the table is shown on the right. I did set up some equations on the left side that gives some of the values in the table. I need to automate the process because i am repeating the same steps for each element. Thanks!

Best answer by Werner_E

I am not sure but it looks like he is just after a neatly formatted table as he is possible used from spreadsheets.

So as I understand every set of (r,t,theta,TF) would yield a table as he had made by hand.

In this can be handled by a matrix which can be formatted as table or as marix as shown below, but you won't be able to achieve the look and format comfort of Excel.

But then, I may be wrong and something else is needed.

NMDeck.png

2 replies

W
Werner_E25-Diamond I
25-Diamond I
October 10, 2013

I have no idea from your description what you are after.

But it looks to me that you have to make the values you want to calculate for "each element" functions dependend on whatever values which change from "elelemnt" to "element".

S
SFares14-AlexandriteAuthor
14-Alexandrite
October 11, 2013

Hello Werner,

i am attaching new mathcad file. The values in the table are calculated on the left side. is there away i could show these calculated values in table format as done by hand? Thanks a lot!

W
Werner_E25-Diamond I
25-Diamond I
October 11, 2013

So the question is to just put all those calculated values in a nice and neat table for display?

You can't get results which would look as godd as you can make them look in a spreadsheet.

All you can do is to put all the values in a matrix. For headers, etc. you can assign textstrings to the appropriate matrix elements, but I guess the result would be far away from good looking.

As you wrote about repeating the calculation i thought you were after some kind of iteration.

A
arbiter0071-Visitor
1-Visitor
October 10, 2013

Generally, a table implies changing one or more parameters in some sort of sequence. You can do that by creating indexed variables, something like i:=0;5 L<sub>i</sub>:=5*i.

Next, you can just replace the single-valued variable with the indexed variable, and get a list of results from the equation.

TTFN

W
Werner_E25-Diamond IAnswer
25-Diamond I
October 11, 2013

I am not sure but it looks like he is just after a neatly formatted table as he is possible used from spreadsheets.

So as I understand every set of (r,t,theta,TF) would yield a table as he had made by hand.

In this can be handled by a matrix which can be formatted as table or as marix as shown below, but you won't be able to achieve the look and format comfort of Excel.

But then, I may be wrong and something else is needed.

NMDeck.png

    S
    SFares14-AlexandriteAuthor
    14-Alexandrite
    October 11, 2013

    This looks really good. i am not expecting it to look as good as excel, but it looks very decent. Thanks!

    Terms & ConditionsAccessibility statement