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!

Register Log in
  • 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

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
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
Upvote 0 Downvote
"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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

yuriy_biks
  • Locked
  • Question Question
"This value must be a scalar" issue in the FOR loop Mathcad Prime 9
Replies
12
Views
2K
3DDave
3DDave
weikequ
  • Locked
  • Question Question
Things you love/hate with mathcad
2 3
Replies
43
Views
24K
Sparweb
Sparweb
271828
  • Locked
  • Question Question
Mathcad Prime - subscript . and unit font
2
Replies
22
Views
3K
samirhayatkhan
samirhayatkhan
LS_SMS
  • Locked
  • Question Question
Picking Data From Table of Values
Replies
6
Views
3K
EJ_H
EJ_H
julian89
  • Locked
  • Question Question
Trilinear interpolation in mathcad prime?
Replies
3
Views
1K
bkal
bkal

Part and Inventory Search

Sponsor

Back
Top