Mathcad express prime 2: table in function of 2 variables. 1

[Walterke]

I'm switching from excel to mathcad because of the more organized system of placing formula's

(things like =($B$12*($B$5*D$18-$B$11+$B$6*D$19)+$K$8*($K$10*D$18-$B$11)+$B$13*(D$18*($B$1+$B$7+($B22-$B$4-$B$2)/2)-$B$11+$B$8*D$19)+$K$9*D$18*($K$11+($B22-$B$4-$B$2)/2-$B$11)+$B$14*(D$18*($B22-$B$4+$B$3)-$B$11+$B$9*D$19))/1000000) can become messy after a while. )

Only problem is that I want the same end result.
The result of my mathcad file is a formula with 2 variables y(L,a).
I need to create a load chart in function of the L and a. (row 1= variables for a, column 1 = variables for L, table fills up in function of a & L)
Because of the freeware version I cannot export to excel, so I was wondering if there was a way in mathcad that I can do this.
If not, please explain how I could do this with the payed version, so I can maybe convince my boss to purchase this product.

Hope my explanation makes some sense.

NX 7.5.5.4 with Teamcenter 8 on win7 64
Intel Xeon @3.2GHz
8GB RAM
Nvidia Quadro 2000

 

[IRstuff]

You can still export to Excel, I think, by using the WRITEEXCEL function, as described in the help files.

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529

 

[Walterke]

I got the READEXCEL function to work. But WRITEEXCEL gives me an error.

Could somebody please upload a file from mathcad express prime 2.0 with a proper working writeexcel function in it? (if at all possible)

NX 7.5.5.4 with Teamcenter 8 on win7 64
Intel Xeon @3.2GHz
8GB RAM
Nvidia Quadro 2000

 

[Walterke]

I was too fast to post. Managed to get it to work.

Unfortunately, this does not yet solve my problem.
I could now export my results from mathcad toe excel, but I still don't know how to GET the results in mathcad.

Let's try to explain by using an example. (see attached image)
A2:A11=length1
B1:K1=length2
B2:K11=formula f1=length1+length2

In mathcad we would get the formula:
f1(length1,length2):=length1+length2
now, from this formula, how do I get my results B2:K11 in a way that I can export them to excel?

NX 7.5.5.4 with Teamcenter 8 on win7 64
Intel Xeon @3.2GHz
8GB RAM
Nvidia Quadro 2000

 

[IRstuff]

http://files.engineering.com/getfil...0-489a-900e-43e565abed19&file=writeexcel.mcdx

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529

 

[Walterke]

"the file type is not supported."

But thanks for trying to help me out!

NX 7.5.5.4 with Teamcenter 8 on win7 64
Intel Xeon @3.2GHz
8GB RAM
Nvidia Quadro 2000

 

[IRstuff]

This is a PDF copy of the file:

http://files.engineering.com/getfil...af-4c8a-945d-5411b66e0db4&file=writeexcel.pdf

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529