RE: Looking for a database function

Subject: RE: Looking for a database function
From: "Monique Semp" <monique -dot- semp -at- earthlink -dot- net>
To: "Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>, techwr-l -at- lists -dot- techwr-l -dot- com
Date: Fri, 7 May 2010 12:32:25 -0700

I think so, but I wouldn't vouch for it without trying! But I know that
I've used them with these sort of two-dimensional (and really, they become
multi-dimensional when the grid intersections contain more complex data
than just yes/no values) spreadsheets, and then been able to
sort/arrange/report on any row or column entry for any given value.

So one could even be more complicated in the data entry and have not only
the presence/absence of the x to mark the intersection, but things such as
what version of training the person has had; when they took it, etc.

Here's an example of one I implemented (a long time ago, and although I'm
looking at it now it's still not obvious how I managed it, but clearly it
can be done :-):

Workbook sheet 1:
* One row for every document. (This would mimic your needs: a row for
every quality procedure.)

* Columns for everything under the sun about that doc: id, title, filename,
component, author, version, etc. (In your case, you'd have a column for
every employee.)

Then I created a new workbook sheet for the "Summary" tables. In that
sheet, I created a bunch of Pivot Tables. For example, I have an "Author
Summary" that shows the count of the docs assigned to every author. And
the great thing about the pivot table is that if I don't want to see
*every* author listed, I can just select which authors to show. So in your
case, you could show just the employee you're interested in.

Before anyone asks, I cannot share this particular Excel workbook because
it has too much proprietary data, and it would take forever to sanitize it.
But the point is, Excel does provide these functions in a way that you can
dynamically get very detailed analysis of the main sheet's information,
without changing/manually sorting that main sheet.

(I did this in Excel 2003, but from what I've seen of 2007, the functions
are pretty much the same, just accessed from the Ribbon instead of
menu/dialog boxes.)


> With grid entry as I described?
> >
> > I think pivot tables in Excel would provide what you need.
> >
> > -Monique
> >
> > >
> > > I need to be able to query in both directions
> >
> >


Use Doc-To-Help's XML-based editor, Microsoft Word, or HTML and
produce desktop, Web, or print deliverables. Just write (or import)
and Doc-To-Help does the rest. Free trial:

- Use this space to communicate with TECHWR-L readers -
- Contact admin -at- techwr-l -dot- com for more information -

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit

To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit for more resources and info.

Please move off-topic discussions to the Chat list, at:


Previous by Author: RE: Looking for a database function
Next by Author: FrameMaker paths to imported images...
Previous by Thread: RE: Looking for a database function
Next by Thread: RE: Looking for a database function

What this post helpful? Share it with friends and colleagues:

Sponsored Ads