RE: Looking for a database function

["Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>]

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