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
- :
- assigning a value to a parameters defined above in...

Options

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

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

Showing results for

Highlighted

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

12-17-2013
09:23 PM

12-17-2013
09:23 PM

i have this long worksheet that creates graphs in the last page . I am investigating the effect of the parameters defined in the first pages of the worsheet on the final results(graphs) . each time I have to scrol several pages up , change a value , run the program scroll down and see the difference. doing this for several hundered times is makin me crazy!!!

I there a way to assign a value to the parameters defined in the first pages from somewhere down in the worksheet?

Solved! Go to Solution.

Labels:

1 ACCEPTED SOLUTION

Accepted Solutions

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

12-17-2013
09:35 PM

12-17-2013
09:35 PM

There are a few solutions to your problem which come to mind

1) Probably too cumbersome if the worksheet wasn't designed that way from the beginning, but the maybe cleanest solution from a mathematical point of view. Turn all of your calculation into functions depending on the parameters you want to change. So you can call the function(s) with the parameters at the end of the sheet w/o scrolling and you are even able to compare the results directly, having the results of different sets of parameters side by side at the same time.

2) Use global assignment for the parameters at the end of your sheet (basically this is what you asked for, I think)

3) Keep the parameters assigned at the top and hide the calculations in one ore more collapsed areas.

4) Put the calculations in a second worksheet which you reference in your main sheet after the parameter definitions.

1 REPLY 1

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

12-17-2013
09:35 PM

12-17-2013
09:35 PM

There are a few solutions to your problem which come to mind

1) Probably too cumbersome if the worksheet wasn't designed that way from the beginning, but the maybe cleanest solution from a mathematical point of view. Turn all of your calculation into functions depending on the parameters you want to change. So you can call the function(s) with the parameters at the end of the sheet w/o scrolling and you are even able to compare the results directly, having the results of different sets of parameters side by side at the same time.

2) Use global assignment for the parameters at the end of your sheet (basically this is what you asked for, I think)

3) Keep the parameters assigned at the top and hide the calculations in one ore more collapsed areas.

4) Put the calculations in a second worksheet which you reference in your main sheet after the parameter definitions.

Top Tags