Best way to handle this Business Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi --

Before I get into the problem; I'd like to say that this client has
not decided on WSS 3.0 or MOSS ... and the figuring the optimal SP
solution for this business problem will definitely influence their
choice.

This client loves excel spreadsheets ... They take on these large
scale contracts that they call "Programs". Well, a given "Program"
encompasses many "Physical Locations", and at a Location the can have
many Widgets. Many of these columns hold dates, boolean values, and
notes.

Well, they like to track all their widgets per site ... and the Type
Of Program will dictate the excel template per each Location in that
Program (each program type having its own set of columns). All cut and
dried so far ... The problem is aggregation of all this information
from all these disparate spreadsheets into a single "data
structure?" ... I say data structure because I don't want to pin down
the solution to a SPList ... Here are some answers that the
aggregation needs to be good enough to show ... How many Locations
have date X < today? What are those Locations? (and other questions
like this ... but I think you get the point).

Does anybody have any idea?

Thanks,
Rich
.

Relevant Pages

  • Re: Managing multiple instances
    ... stored in the SAME data structure" but I have to work with it. ... Changing the architecture is probably going to result in a substantial "shotgun refactoring". ... Much of the client code within ... The collection classes then manage the collection and provide efficient support of Find semantics. ...
    (comp.object)
  • ATL service question about events and scope and memory
    ... object instance, the client calls the "open" interface for it. ... causes the service to save some info in a data structure that is ... My client then creates a sink object that the service object will send ... When I step into the service at this point I see that the memory that I ...
    (microsoft.public.vc.atl)
  • Re: 2.6.11-rc1-mm1
    ... Karim Yaghmour wrote: ... > This is not good for any client that doesn't know beforehand the exact ... > fill an intermediate data structure which will only be used for relay_write. ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: ATL service question about events and scope and memory
    ... > object instance, the client calls the "open" interface for it. ... > causes the service to save some info in a data structure that is ... > When I step into the service at this point I see that the memory that I ...
    (microsoft.public.vc.atl)