Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

Walterke

Industrial
Joined
Jun 22, 2011
Messages
451
Location
BE
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
 
You can still export to Excel, I think, by using the WRITEEXCEL function, as described in the help files.

TTFN
faq731-376
7ofakss

Need help writing a question or understanding a reply? forum1529
 
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
 
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
 
 http://files.engineering.com/getfile.aspx?folder=762d044a-b4c3-492e-bf81-010447cc3518&file=Knipsel.JPG
"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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top