Data Coding
 

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

Data Coding
 

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
wrote:
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

Data Coding
 

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

"Tim879" wrote:

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
wrote:
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