×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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

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

(OP)
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

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

(OP)
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

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

(OP)
"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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources