Home Forums Discussions General Discussion Tables

Hopefully some one can help me wih this. 75% of my practice is wound care. What I want to do is create a table with wound locations going horizontal and wound descriptions going vertical. I think the best way to do this is an Excel table, and then attach as an import to the chart. Does excel have a text prediction property such that for any giving location say a sacral decub, the nurse can just scroll down, type in measurements, drainage, odor, just by typing the first letter. Anyone know how to make this work? Thanks.

Henry,

Excel is a rather complicated (for me) and very powerful program. I use it for simple spreadsheets and don't even scratch the surface of what it can do.

There is a good chance that someone on here can help you, but if you are continuing to add features to your Excel project and you wish to be able to go back again and again for help, I would highly recommend Experts-Exchange. EE is, by far, the best expert site there is. It is designed incredibly well. You can use it for free, but you have to answer questions to ask questions, so I simply pay the $9.95 per month. For me, it is a bargain as I have asked over 250 questions ranging from using OneNote to setting up a RAID5 and SBS server. There are thousands of experts. The neat thing about it is if you post a question to the Microsoft Excel zone, you will more than likely get a response from several experts within minutes. These are Microsoft Most Valuable Professionals with years and years of experience.

They do have a six-day trial period if you want to give it a shot. It's at www.experts-exchange.com. You should know it isn't limited to Excel, they have hundreds of zones and categories.

Henry- why not do it in MS Access? It uses the same graphing engine. Send me the table and I could take a crack at it. BTW, last time I tested the MS graph activeX was in MS WORD!! Check out- http://www.box.net/shared/static/ebziurpk40.dot for the test template that I used to show how you can grab table data from an outside MS Access table and graph it inside MS Word.

I remember when I studied Lotus 123 and thought that it had potential in my medical programming, but alas, it just didn't fit into my use of Paradox for DOS. After 1995 I looked at MS Excel, but still haven't used it at all- it just never added much to my EMR. I have read several MS Excel books, though, because they discuss the use of UserForms a lot better than any MS Word textbook.


(one of my favorite websites)

Bert- what's wrong with the http://www.microsoft.com/office/com....public.excel.misc&lang=en&cr=US site for asking questions? It's free too...

Cheers,
Al

Henry;
I see lots of wound care as well and have found that a picture is worth a thousands words. We place a clear plastic sheat over the wound (free from Regranex) and take a number of pictures of each wound (camera is canon elf sd600 50kb/picture w excellent clarity in macro no flash). We save in imported items. You can save in a separate file for left and right or ankle and heel etc for reference later. It also helps as we have staff do a lot of the work so they can see how the wound is progressing.
Sam M. Horowitz, DPM, FACFAS C.Ped

Thanks Al. I'll try to scan a copy of the wound sheet we use and email it to you tomorrow night. I'm not that good at access and excel. I can a computer together but not good at programing.

Sam we do take pictures and I'm inserting them into the chart. I figured something in an esay table format would be easier and fasterfr the nurses to use.

Oh, nothing wrong with it. I use them too. May sound crazy, but they all tend to be MVPs answering the questions. Greater variety in EE.

It really is difficult to explain. Maybe Adam can shed some light. In the threads you are talking about, one's question kind of gets lost in a sea of other questions, and you may get one, two, or three responses. You generally don't get a lot of back and forth.

In EE, it isn't uncommon to have a question with over 100 comments lasting ten days or more. The search is way better. Overall, just a much better forum for that type of thing at least for me. For some reason, they seem to have designed a much better aesthetic forum that makes it a lot easier to read and understand.

>>> May sound crazy, but they all tend to be MVPs answering the questions.

If you go to the MS Community Forums for MS Word or MS Access areas, you may occasionally see ME there (or just look up "alborg" -> http://www.microsoft.com/office/community/en-us/default.mspx?query=alborg&cboDiscussionGroup=en-us-office-word%3A%3Aen%3AUS%3A617c4d62-4061-4107-8d46-2a22fc6fa202%3A%3A%3A&=Go&dg=&cat=en-us-office-word&lang=en&cr=US&pt=617c4d62-4061-4107-8d46-2a22fc6fa202&catlist=&dglist=&ptlist=&exp=&sloc=en-us) and http://www.microsoft.com/office/community/en-us/default.mspx?query=alborg&cboDiscussionGroup=en-us-office-access%3A%3Aen%3AUS%3A327f343d-f0d6-4e07-aa53-9656edb98ada%3A%3A%3A&=Go&dg=&cat=en-us-office-access&lang=en&cr=US&pt=327f343d-f0d6-4e07-aa53-9656edb98ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us!!! (Teaching the MVPs how to do things... ) I used to average about 1-2 responses per day before 2006, but I just don't have the time to do that anymore at that rate.

I was nominated by Chris Wilkerson (chiro who is a MS MVP who posts on emrupdate) in 2006 to be a MS Word MVP, but unfortunately:

1) I spent too much time in the EMR websites and blogs, particularly emrupdate, and not enough in the MS community forums. In fact, my activity in the MS Community Forums skyrocketed when I got banned from emrupdate during January! My new home during my wandering period was here and in the MS Community Forum areas.
2) I didn't have a neat, organized website yet. I'm working on it, though. I just signed up with 1&1 website company... I wrote a 200+ page book back in 2006 (in my spare time of course) on writing an EMR focusing on MS Word and MS Access that I may use as the magnet to get folks to visit the site. For the TOC see: http://www.box.net/shared/static/px1v58iok4.doc.
3) I don't always use the most up-to-date MS Office 2007 products, preferring to work with MS Office 2000/2003. When MS comes out with MS Office 2009, I may get that, though. I like to purchase every-other-generation of MS Office software.

BTW, one of the things that I do when I get really stuck is to Google my questions. I do this all the time. You can't imagine the hundreds of responses to similar questions that you'll see out there. Many of the MS MVPs have their own websites that probably have covered the area of interest that is asked by your questions. You just have to choose your keywords right. Gosh, I just have a certain bias to things that are FREE. When it comes to MS Office, there is just so much free stuff out there to read already!!!

Cheers,
Al