Data Coding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Whois Clinton - 29 May 2008 16:43 GMT

Hi,

I would like to set up codes for faster data entry, similar to SPSS options.
For instance:
Entering 1 would display Minimal
Entering 2 would display Moderate
Entering 3 would display Severe
Entering 4 would display Maximum

There would be several variations on the above idea such as department names
etc. Is there any help or existing references for such topics?

Thanks in advance
Clint

Reply to this Message

Tim879 - 29 May 2008 17:03 GMT

You can use Microsoft's autocorrect feature so everytime you type
"min" it would replace it with minimal.

Another option would be to use lookup tables so the user would enter
in 1 then the lookup table would return "Minimal" in another cell.

On May 29, 11:43 am, Whois Clinton
<WhoisClin...@discussions.microsoft.com> wrote:

> Hi,
>
[quoted text clipped - 10 lines]
> Thanks in advance
> Clint

Reply to this Message

Whois Clinton - 29 May 2008 18:39 GMT

Thanks, the look up table was closest to what I was hoping for. Thanks for
your time!
Clint

> You can use Microsoft's autocorrect feature so everytime you type
> "min" it would replace it with minimal.
[quoted text clipped - 18 lines]
> > Thanks in advance
> > Clint

Reply to this Message