TABULUS®, The Table Oriented Spreadsheet

TABULUS® 2010 - Simply put, TABULUS is a better spreadsheet!

TABULUS® 2010 FREE Trial
home recent topics recent posts search faq

TABULUS® Forums
Messages in this topic - RSS

Home » Support & Discussion » Operations with sets

|
2/16/2010 5:23:55 PM

subby
subby
Posts: 1 		Hi everyone,
Currently my work requires a lot of list comparison, defining which one is subset of other, that sort of things
For example: if we have A = {1,2,3}; B = {1,2,4};
I would like to be able to solve things like these with ease right in the spreadsheet tool I am using


A - B = {3} or A + B = {1,2,3,4}.

Having those two only one can build quite complex system of formals.
It is true I can develop simple program to do that, but it is time consuming to move huge list around.


So I am interested in such things, do you have ideas to provide such functionality, or you already do.
Which will be the perfect case ;-)

I am not talking about implementing set theory, but elementary operations with sets.

Thanks,
permalink
2/17/2010 7:35:35 PM

RichDiehl
RichDiehl
Posts: 15 		Hi Subby,
I have thought of ideas about the display of sets, but not the manipulations. The application I had in mind, was the ability to list attributes of entities. List each student, and list each class they have taken.
For your purpose, I can see how set operators could be handy. It would be possible to implement a few functions, which treat text strings as sets.

A=”1,2,3”;b=”1,2,4”
A+B=SetJoin(A,B);
A-B=SetSubtract(A,B)
We currently don't have any of issue on our development list. Let me know what would work for you. I can't say we would implement it for a single customer, but I can log it into my planning doc. If I find there is a market somewhat larger, it's not a huge effort to do.

Rich
edited by rado on 2/18/2010
permalink
pages: 1
|

Home » Support & Discussion » Operations with sets