Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Re: Re-using formulas

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-17-2012
11:02 AM

07-17-2012
11:02 AM

I have to do some calculations within one sheet which I have to repeat a couple of times.

For example:

Input:

A

Calculations:

B = A + 1

C = A * 3

D = B / C

And then I want to publish both B, C and D.

My (printable left side) should look like:

A = x B = x C = x D = x

The formulas need to be located somewhere on the right side page.

But I want to be able to re-use the formulas so my left page will look like:

A.1 = x B.1 = x C.1 = x D.1 = x

A.2 = x B.2 = x C.2 = x D.2 = x

and I don't want to have to copy all the formulas all the time.

I know I can work with matrices, but that's not what I want. I really want to address a function and return the results from there.

Is this possible? And if so, how do I do this?

Thanks in advance for your replies.

Solved! Go to Solution.

Labels:

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-12-2012
06:25 PM

6 REPLIES 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-17-2012
11:16 AM

07-17-2012
11:16 AM

Re: Re-using formulas

Do you mean something like the attached?

Alan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

07-25-2012
12:10 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-12-2012
03:30 PM

09-12-2012
03:30 PM

Re: Re-using formulas

Thanks both for your suggestions.

My problem is however that this doesn't really work, as not all my results are directly based on 1 input parameter.

What I have now is:

P(A):=A+1 Q(P):= P-2 R(Q):=Q^2

A.1:= 5 P(A.1) = 6 Q(P(A.1)) = 4 R(Q(P(A.1))) = 16

As you can see this is horrible to work with. Also my formulas are too difficult to read when I combine them and base all results on 1 variable like this:

P(A):= A+1 Q(A):= (A+1)-2 R(A):=((A+1)-2)^2

A.1:=5 P(A.1) = 6 Q(A.1) = 4 R(A.1) = 16

So what I want to do is really like at the index or something else to pass info to other formulas. I know this sounds like array calculations, but is said, that is not exactly what I want. Because I want:

P.x:=A.x+1 Q.x:=P.x-2 R.x:=Q.x^2

A.1:= 5 P.1=6 Q.1=4 R.1=16

A.2:=6 P.2=7 Q.2=5 R.2=25

And that without having to re-write the formulas over and over again.

Is this possible?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-12-2012
06:25 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-13-2012
12:55 AM

09-13-2012
12:55 AM

Re: Re-using formulas

Maybe I'm missing something, but what happened to the simple approach?

Mike

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

09-13-2012
04:14 AM

09-13-2012
04:14 AM

Re: Re-using formulas

Thanks for the extra examples.

@ Mike Armstrong: I don't want to work with matrices as my output format of the sheet should look plain text.

@ Wayne Reid: The first lines are what I need.

P(A):=A+1 | Q(P):= P-2 R(Q):=Q^2 |

becomes:

P(A):=A+1 Q(A):=P(A)-2 R(A):=Q(A)^2

thanks.