topic Re: Data Table as Global Definition in Mathcad

Data Table as Global Definition

Andrewk2 — Thu, 03 May 2018 19:17:50 GMT

When you choose Insert --> Data --> Table, Mathcad inserts a table with the definition operator (:=). I want to use the global definition operator (~ keystroke for the triple equals sign) so that I can put this table at the bottom of the worksheet.I tried pasting the table

Re: Data Table as Global Definition

RichardJ — Mon, 20 Sep 2010 18:24:24 GMT

Is there any way of using a data table with the global definition operator?

No, sorry. You can't use any component based item with a global defintion. Why not just put the data table in an area at the top of the worksheet and then collapse the area?

Re: Data Table as Global Definition

Andrewk2 — Mon, 20 Sep 2010 18:47:33 GMT

Thanks. That was actually the work-around I started to use. It's not horrible, but I know I'm going to get "what's this ..." questions.

Re: Data Table as Global Definition

MikeArmstrong — Tue, 21 Sep 2010 06:40:21 GMT

Andrew Kelly wrote:
Thanks. That was actually the work-around I started to use. It's not horrible, but I know I'm going to get "what's this ..." questions.

Andrew,

I'm a little lost. Is your data defined within Mathcad or brought in from another program?

You could post a worksheet and you might get more responses on possible alternative methods.

Mike

Re: Data Table as Global Definition

Andrewk2 — Tue, 21 Sep 2010 12:43:21 GMT

See attached (V11). The content in my example is a made-up case.

The Data Table seems to fit all of my needs. It's embedded in the worksheet. It doesn't have a fixed number of rows / columns. Adding / deleting rows/columns, and data to the table is relatively painless. In this format, I can extract the info out of the table using hlookup, vlookup, match, submatrix, etc. functions. I've got it set-up so that the order of the rows / columns and number of rows / columns doesn't matter

The only issue is that there doesn't appear to be a way to use a variable size table with a global definition operator.

Re: Data Table as Global Definition

jeanGiraud — Tue, 21 Sep 2010 16:31:13 GMT

Andrew Kelly wrote:
See attached (V11). The content in my example is a made-up case.
The Data Table seems to fit all of my needs. It's embedded in the worksheet. It doesn't have a fixed number of rows / columns. Adding / deleting rows/columns, and data to the table is relatively painless. In this format, I can extract the info out of the table using hlookup, vlookup, match, submatrix, etc. functions. I've got it set-up so that the order of the rows / columns and number of rows / columns doesn't matter
The only issue is that there doesn't appear to be a way to use a variable size table with a global definition operator.

From what you demonstrate, there is not much to understand of all those things you "WantToDo".

You don't have a data table really, just a collection. You can create a collection of anything, any size, spool to file WRITEPRN, recall any component from the filed collection then extract at will from any component of the collection using a data extractor [a few lines general utility].

jmG

Re: Data Table as Global Definition

Andrewk2 — Tue, 21 Sep 2010 17:27:39 GMT

The example was intentionally obfuscated. If you refer to my original question, I wanted a way to turn the colon equals sign into a triple equals sign, so I could refer to "Data" above the point in the worksheet where it is defined.

I prefer not to use external files, if possible; I prefer to have the data behind "Data" embedded in the worksheet.

Does anyone have a way to get a triple equals sign (~) without using a matrix?

Re: Data Table as Global Definition

RichardJ — Tue, 21 Sep 2010 18:45:42 GMT

Does anyone have a way to get a triple equals sign (~) without using a matrix?

Sorry, but I think there really is no way to do this. The only thing that can be to the right of a global equals is a standard math region. The only such region that can hold mulitple numbers is a matrix. Data tables, Excel components, scripted components, etc, are not allowed.

Re: Data Table as Global Definition

MikeArmstrong — Wed, 22 Sep 2010 06:21:12 GMT

Andrew Kelly wrote:
The example was intentionally obfuscated. If you refer to my original question, I wanted a way to turn the colon equals sign into a triple equals sign, so I could refer to "Data" above the point in the worksheet where it is defined.
I prefer not to use external files, if possible; I prefer to have the data behind "Data" embedded in the worksheet.
Does anyone have a way to get a triple equals sign (~) without using a matrix?

There is a workaround. You could either use a scripted component to collect the data from the table( Maybe a textbox at the top of the worksheet) or use an Embedded Excel component.

Mike

Re: Data Table as Global Definition

MikeArmstrong — Wed, 22 Sep 2010 07:24:37 GMT

Here is an example of a Textbox scripted component.

Another collab's help with more experience in scritpting tjhan me is required. i want the textbox to be able to collect a range

Re: Data Table as Global Definition

RichardJ — Wed, 22 Sep 2010 14:19:31 GMT

There is a workaround. You could either use a scripted component to collect the data from the table

I thought about that. It actually works fine in version 11, but not so fine in later versions. The problem is that when you open the worksheet the data is not on the screen, and is therefore not calculated. Therefore you can't get it. So you have to scroll to the end of the worksheet or hit Ctrl F9. That still won't get the data though, because the component is executed before the data table. So you have to click on the button after hitting Ctrl F9. So much of a PITA I don't think it's much of a solution.

Re: Data Table as Global Definition

MikeArmstrong — Thu, 23 Sep 2010 13:04:15 GMT

Richard,

The push button seems to works fine. I just click the button and the data is collected.

Definanlty a workaround for me .

Mike

Re: Data Table as Global Definition

RichardJ — Thu, 23 Sep 2010 13:39:56 GMT

Which version are you using? I've forgotten.

Re: Data Table as Global Definition

MikeArmstrong — Thu, 23 Sep 2010 13:57:49 GMT

I'm using 14.0 because I cant risk letting the IT department touch my laptop while I'm away onsite.

I deleted one of the "push button" objects and the "Get Result" button seems to work fine, see attached worksheet.

Mike

Re: Data Table as Global Definition

RichardJ — Thu, 23 Sep 2010 14:51:00 GMT

Without hitting Ctrl F9 first? Strange, because it only works for me if I first hit Ctrl F9.

Re: Data Table as Global Definition

MikeArmstrong — Thu, 23 Sep 2010 16:14:35 GMT

Richard Jackson wrote:
Without hitting Ctrl F9 first? Strange, because it only works for me if I first hit Ctrl F9.

I have just checked and if the data is within the screen when I left click on the mouse the button works, otherwise Ctrl F9 is needed. Either way this isn't a major issue.

Cheers

Mike

Re: Data Table as Global Definition

AlvaroDíaz — Thu, 23 Sep 2010 20:06:28 GMT

Is there any way of using a data table with the global definition operator?

Check the attached. Isn't a data table like the mathcad table component but can help if the objective is using global assignations.

Regards. Alvaro.

Re: Data Table as Global Definition

MikeArmstrong — Fri, 24 Sep 2010 07:17:59 GMT

AlvaroDíaz wrote:
Is there any way of using a data table with the global definition operator?

Check the attached. Isn't a data table like the mathcad table component but can help if the objective is using global assignations.
Regards. Alvaro.

Alvaro,

I think Andrew was only asking to use the golden definition operator because he wants the table table to be at the bottom of his worksheet and then use the data above, which seems a little strange to me.

He could define his data in an Embedded Excel component and use the XL storage component which Tom created to called the data to the top of the worksheet or just use the example provided by Richard.

Mike

Re: Data Table as Global Definition

AlvaroDíaz — Fri, 24 Sep 2010 10:00:26 GMT

Even the Bogus array is an oddity, it is native from mathcad and accept global definitions. Isn't like the table input, but I know kids that can program better interfaces for input arrays than the mathcad table component. Also don't need to activate scripts if your security level is at medium, and not disturbe the monster (excel, with their macros, addons, someones trials or free but with messages).

Re: Data Table as Global Definition

RichardJ — Fri, 24 Sep 2010 12:18:36 GMT

I know kids that can program better interfaces for input arrays than the mathcad table component.

I would agreee with that. You can find better grid controls that the Mathcad table component on the web, for free!