1-Visitor

Solved

Table of results

Forum|Forum|11 years ago
August 12, 2014
3 replies
7837 views

I have a fairly complex formula for I(q,x) and I want to tabulate the results with q values (1 - 5) as the columns and x values (1 to 5) as the rows. I've no doubt it's very easy, but I can't see how to do it.

I apologize if I've posted this question to the wrong forum.

Other

Best answer by Werner_E

JOHN WOODGATE wrote:
Well. I copied your script into mine, with strange results. The graphs are correct, I belive (I can check with the inverted equation, which should always give H = 0.4). But the tabled values are mostly not correct, and those that are, may be coincidence. Anyway, I've attached my worksheet for your appraisal.

The reason is that you have to switch the arguments of I(), either when you define I() or when you call it.

In your very first post you said you had a function I(q,x) and want a table with x (which is the second argument of the function) as rows. So my solutions took this for granted.

In your sheet you have defined I(x,gamma) and obviously you want a table with x (which is now the first argument of the function) as rows. So of course you have to switch the order of the arguments to get it right.

If you would use my last approach, you wouldn't need the auxiliary function for the very same reason either.

M

MikeArmstrong

1-Visitor

There is probably a number of different ways to achieve this.

Could you post an example?

J

JohnWoodgate

Author

1-Visitor

Thanks for prompt response. Here is the output table from Excel. I have to show that Mathcad gives the same numbers. x in my original message is B in the Excel sheet.

q	1	2	3	4	5
B
0.5	9.54	6.16	5.49	5.38	5.41
0.75	5.35	4.09	4.02	4.10	4.18
1	3.95	3.44	3.53	3.64	3.71
1.25	3.37	3.23	3.37	3.48	3.54
1.5	3.12	3.19	3.36	3.46	3.52
1.75	3.04	3.25	3.44	3.54	3.60
2	3.05	3.37	3.57	3.67	3.73
2.25	3.11	3.53	3.74	3.84	3.90
2.5	3.21	3.71	3.94	4.04	4.09
2.75	3.33	3.91	4.15	4.26	4.31
3	3.48	4.12	4.37	4.49	4.54
3.25	3.63	4.34	4.61	4.73	4.79
3.5	3.80	4.57	4.86	4.98	5.04
3.75	3.97	4.81	5.11	5.24	5.30
4	4.15	5.06	5.37	5.50	5.56
4.25	4.34	5.30	5.63	5.77	5.83
4.5	4.53	5.56	5.90	6.04	6.11
4.75	4.72	5.81	6.17	6.32	6.39
5	4.92	6.07	6.44	6.59	6.67

M

MikeArmstrong

1-Visitor

Based on the information provided Werners example should do the trick.

Live data is much more productive to work BTW.

W

Werner_E

25-Diamond I

JOHN WOODGATE wrote:
I have a fairly complex formula for I(q,x) and I want to tabulate the results with q values (1 - 5) as the columns and x values (1 to 5) as the rows. I've no doubt it's very easy, but I can't see how to do it.

Maybe something like the two approaches attached?

If the values for x and/or q are not in ascending order with step size 1, different approaches are necessary. If thats an issue, ask again. Also, if you would like to have rudimentary row and column headers.

J

JohnWoodgate

Author

1-Visitor

Thank you very much. These are simple enough even for little me to understand. I probably only need to do this once, so no refinement is really necessary.

W

Werner_E

25-Diamond I

As explained above here is a more general approach by defining a utility routine and providing the row and column values as vectors. The function is assumed to have two independend arguments and the table created would have the first argmuent for the rows and the second for the columns. As your function seems to be defined the other way round, you will have to create am auxiliary function.

I am not including the worksheet as we still don't know which version of the program you are actually using.

J

JohnWoodgate

Author

1-Visitor

This, too, is not too difficult for me, but maybe more than I require. I'm using Mathcad 15 at present. Thank you very much.

How can I retrieve your worksheet/ I can screen-grab, of course, but I wonder f there is a better way.

W

Werner_E

25-Diamond I

JOHN WOODGATE wrote:
This, too, is not too difficult for me, but maybe more than I require. I'm using Mathcad 15 at present. Thank you very much.
How can I retrieve your worksheet/ I can screen-grab, of course, but I wonder f there is a better way.

Retrieving the sheet is easy - you simply ask for it.

Here you are!

1_Make_Table_WE_2-xmcdz.zip

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded