1. Managing e-Resources & Licensing

License, ERM, permitted uses, terms of use, ERM, web, macros, Excel, data entry

• Labor for data entry projects, such as license data entry into an ERM, can be reduced using techniques such as pre-formatted data, macros for repetitive fields, quick keys and Notepad for text composition.
• Excel, using Concatenate, can be used to quickly format permitted uses.
• These techniques could be easily appropriated for other data entry projects.

Unavoidable, by-hand data entry is intense and tedious. Using techniques such as formatting data pre-entry, and using macros for quick data entry and Excel to format changeable data such as permissions can reduce time and effort. Practical, immediately-usable techniques can be easily adapted to other data input projects.