| Author |
 Topic  |
|
|
OndrejMM
Australia
81 Posts |
 Posted - 01/20/2009 : 6:32:35 PM
|
Hi
This might be a bizarre question, but anyway, lets say that I've just done a simple calculation using LabTalk col(C)=col(A)+col(B), but of course in 4 weeks time I dont remember what the kind of numbers are in the col(C)! If I do the same with the Set Values option I can always find what was done with the particular column, but I dont know how to get this information if I used LabTalk, does the origin remember which kind of operation was done on the particular column?
Cheers, Ondrej
|
|
|
cpyang
USA
1406 Posts |
Posted - 01/20/2009 : 10:41:53 PM
|
Currenly, there is no such thing.
So if we provide LT access to set/get col formula, then it will be good enough? Like
range a=col(c);
a.formula$="col(b)-col(a)";
This new property can be both set and get, will that be good enough?
CP
|
 |
|
|
OndrejMM
Australia
81 Posts |
Posted - 01/21/2009 : 12:26:34 AM
|
Hi CP
it looks okay, just maybe try to do it even more simple, because people may use it quite often as a number of LabTalk user increases
maybe as follows: formula col(C)
but thinking about it, . it might happen that someone will use many formulas on the same column, e.g.:
col(c)=col(a)+col(b);
col(c)^2;
col(c)=col(c)-col(X);
I think, it would require to know the column history, like:
- date when the column was created (10/02/2008)
- the source file (C:\file\example.txt)
- formula/s
col(c)=col(a)+col(b);
col(c)^2;
col(c)=col(c)-col(X);
maybe make new X-function, e.g. colinfo with different properties date, file, formulas,.
but, maybe Ive just overcomplicated it :-), Im sure you will find a good way to do it,
cheers
|
|
|
|
couturier
France
291 Posts |
Posted - 01/21/2009 : 08:38:29 AM
|
I like the idea of formula$. If you're going to add such a property, maybe it is good to also include a before_formula$ property.
The part about the many formulas can be solved in writing in one shot the full stuff, like:
col(c)=(col(a)+col(b))^2-col(X);
or by using the before formula script.
I think keeping an history of everything may be a bit overcomplicated. |
Edited by - couturier on 01/21/2009 08:39:11 AM |
|
|
|
OndrejMM
Australia
81 Posts |
Posted - 01/21/2009 : 8:02:15 PM
|
yeh, I think no one will try to split one formula like this: col(c)=(col(a)+col(b))^2-col(X), to more simpler, I just wanted to point out that more than one formula can be applied to one column, and then it might be confusing,... (I think)
imagine that I do something with the col(C) today, and in 6 months time I actually decide that I want to do some more calculations on the col(C), but I dont think that I will want to rewrite all already applied operations + add new ones just because in another 6 months time I want to see the whole formula which has been applied to the col(C),
maybe, if an additional operation is applied to the same column the information held in formula$ should be updated, maybe as follows:
col(C) = col(A) +col(B);
> col(C).formula$= col(A) +col(B) //show formulas
col(C)=col(C)-col(X)
> col(C).formula$=col(A)+col(B); col(C)-col(X) // show formulas
and a problem is that people are doing complicated calculations between many worksheets and workbooks, so I really think it would be good to keep track of all applied operations, and mainly it is important to keep it simple, because we just want to see very quickly what was done on the particular column in the worksheet,...
and,...
imagine that col(A) was imported from file C:\example.txt, then the formula$ may say that the column was imported from C:\example.txt:
> col(A).formula$=C:\example.txt
yeh, sorry I tend to overcomplicated things, I just think that it will be useful if we know whether the column was imported from some file or it was calculated from data in the worksheet by some formula/s,
Cheers
Ondrej
|
|
|
|
couturier
France
291 Posts |
Posted - 01/22/2009 : 04:49:21 AM
|
quote:
imagine that col(A) was imported from file C:\example.txt
Such info (as many others) are available if you check "Show organizer" in workbook grey area. |
|
|
| |
Topic |
|
|
|
column info