Global Definition

[MikeArmstrong]

All the best everyone.

I have a question regarding the disadvantages of the Global definition. I know that it can�t be used when extracting data from Excel component, but cannot find any additional disadvantages.

The one major advantage is that results can be displayed above the calculated area, which is very useful when producing formal documents.

Regards

Mike

[Fred_Kohlhepp]

And your question is?


Fred Kohlhepp
fkohlhepp@sikorsky.com

[MikeArmstrong]

Basically, the restrictions within Mathcad when using this definition.

Regards

Mike

[pbaxter-disable]

I never use GLOBAL because most often I re-use equations or re-define variables in a worksheet. If you are doing one calculation in a sheet then using GLOBAL may not be an issue.

Preston

[MikeArmstrong]

Ok cheers.

The main issue is displaying results above where they have been calculated without manually changing them when an input is changed.

Regards

Mike

[IRstuff]

On 1/6/2010 11:46:14 AM, Armo wrote:
>Ok cheers.
>
>The main issue is displaying
>results above where they have
>been calculated without
>manually changing them when an
>input is changed.
>
>Regards
>
>Mike

Huh? You listed that as an advantage, so what is the issue?

TTFN,
Eden

[MikeArmstrong]

>Huh? You listed that as an advantage,
>so what is the issue?

That is the issue, that�s why I'm asking if anybody knows any disadvantages of using them.

Regards

Mike

[Fred_Kohlhepp]

On 1/6/2010 11:59:18 AM, Armo wrote:
>>Huh? You listed that as an advantage,
>>so what is the issue?
>
>That is the issue, that�s why
>I'm asking if anybody knows
>any disadvantages of using
>them.
>
>Regards
>
>Mike

as far as I know there is no disadvantage unless you attempt to redefine the value somewhere on the sheet. Then, as pointed out elsewhere, there will be confusion.

Fred Kohlhepp
fkohlhepp@sikorsky.com

[ptc-1368288]

"I'm asking if anybody knows any disadvantages of using them."
_____________________

Global definitions have no disadvantages. Just a matter of using them when convenient, for instance to avoid collapsing area(s)if you want the result to show somewhere at the top of the work sheet ... think in term of a *.PDF that will not capture collapsed area(s).

jmG

[MikeArmstrong]

Cheers question answered.

Regards

Mike

[MikeArmstrong]

I think I have found a disadvantage.

When using the given/find function the global definition cannot be used, therefore the answer has essentially been calculated using the local definition and cannot be shown above the function.

Regards

Mike

[Fred_Kohlhepp]

Can ou post an example?


Fred Kohlhepp
fkohlhepp@sikorsky.com

[MikeArmstrong]

See attahced

Regards

Mike

[IRstuff]

That's not a "disadvantage" That's just something it doesn't do.

Moreover, your example is incorrect in syntax, because while your inputs are globalized, the Find result is not. So your example does not actually show an error. The c=1 is correct, based on the fact that the globalized value of c is 1, and you then redefine it to equal 3, but that's a local assignment.

The correct syntax should be c ~ Find(c), which then fails because Find cannot be globalized.


TTFN,
Eden

[MikeArmstrong]

On 1/13/2010 1:10:09 PM, eden_mei wrote:
>That's not a "disadvantage"

I would say that it is a disadvantage because when using (Find) the answer cannot be globalized therefore the answer can not be shown say above in a results table.

Regards

Mike

[ptc-1368288]

On 1/13/2010 11:49:56 AM, Armo wrote:
>I think I have found a disadvantage.
...
>Regards
>
>Mike
____________________________________

A feature is a feature, a matter of application.



jmG

[MikeArmstrong]

I understand that the first c is for the birds, but what I'm trying to say is that once the Find function has produced an answer it cannot be shown above that function, like a globalized varible.

Regards

Mike

[TomGutman]

You can always use an Excel component (as a function) to show values anywhere on the sheet.
__________________
� � � � Tom Gutman

[MikeArmstrong]

Tom

I use Excel components all the time but have never used them as a function.

Would you be able to demonstrate please?

Regards

Mike

[TomGutman]

This should be an example. http://collab.mathsoft.com/read?129923,63e#129923
__________________
� � � � Tom Gutman

[MikeArmstrong]

That is exactly what I have been looking for.

Cheers even though I have no idea how it works.

Regards

Mike

[tschasta-disabl]

I'd like to see that example, but can't get it to open. Does anyone else have an example of how to incorporate Excel information into a Mathcad sheet?

[ptc-1368288]

On 1/14/2010 3:31:55 AM, Armo wrote:
>I understand that the first c
>is for the birds, but what I'm
>trying to say is that once the
>Find function has produced an
>answer it cannot be shown
>above that function, like a
>globalized varible.
>
>Regards
>
>Mike
____________________________

YES, you can ! Put the solver in a text box.



jmG

[ptc-1368288]

More for your convenience.

jmG

[MikeArmstrong]

Cheers

Regards

Mike