RE: Looking for a database function

Subject: RE: Looking for a database function
From: "Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Fri, 7 May 2010 16:17:39 -0400

Thanks, but your example sounds a lot more complicated than what I'm
looking for. A simple entry grid like the one I described must exist in
some DB program... right?

Anyone? Bueller?

> -----Original Message-----
> From: Monique Semp
> Sent: Friday, May 07, 2010 3:32 PM
> To: Dan Goldstein; techwr-l -at- lists -dot- techwr-l -dot- com
> Subject: RE: Looking for a database function
>
> 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.)
>
> -Monique
>
> >
> > 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
> > >
> > >


This message contains confidential information intended only for the use of the addressee(s). If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing, copying, electronic storing or the taking of any action in reliance on the contents of this message is strictly prohibited. If you have received this message by mistake, please notify us, by replying to the sender, and delete the original message immediately thereafter. Thank you.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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: http://www.doctohelp.com


- 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 http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


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
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat


References:
RE: Looking for a database function: From: Monique Semp

Previous by Author: RE: Looking for a database function
Next by Author: RE: Looking for a database function
Previous by Thread: RE: Looking for a database function
Next by Thread: 50 Helpful Typography Tools and Resources


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


Sponsored Ads