Big time saver and easy to use
ASAP utilities is something I cannot imagine living without as an avid Excel user. The tool makes it easy to do repetitive tasks or data transformation at the click of a button. It is very easy to use and would benefit a beginner excel user equally as well as an experienced person. I've introduced this tool to so many people and everyone loves it!
If you aren't using ASAP utilities, are you even using Excel?
ASAP Utilities is a MUST have for every Excel user.
Have you ever wished Excel could do something but you can't figure out how to make it work? ASAP Utilities know how, & has simplified those chores and combined them into single click tools. It's saved me over 100 hrs by doing all those nit-picky little tasks for me.I don't know where I'd be without it.
Whether you are an Excel power user or not you will find this addin a huge time saver and provide functionality to your spread sheet that you never thought possible. Seamlessly integrated into Microsoft Excel it provides a vast library of utilities to manipulate, edit and simplify repetitive tasks. Alan Cooke demonstrates it to us.
Navigate to WebLogic_domain/servers/WebLogic_server/upload/asapENV_ID/app (where the WebLogic_domain is the installation directory for your WebLogic Server domain, WebLogic_server is the name of your WebLogic Server domain, and ENV_ID is the ASAP environment ID.
Many ASAP utilities and scripts use the passwords contained in the CSF wallet. For more information about how these utilities and scripts use the CSF wallet security feature, see "Using the Credential Store Factory Wallet with ASAP Utilities and Scripts."
The utilities retrieve password information from the CSF wallet. The ASAP installer creates the CSF wallet during the installation of ASAP. You can modify the passwords using the ModifyPassword script (see Changing Database Passwords in the Credential Store Factory Wallet).
The cache functionality is controlled by the value of the cache_mode defined for the control database login and password. The caching functionality can be changed through menu option 10 in the asap_security_tool by modifying the control database login. If the value of the cache mode for the control database login is 0, then the Control server caches the secure data. Otherwise, the Control server retrieves the secure data from the database as required.
To enable schema validation, set the VALIDATION_ENABLED parameter to True in the ejb-jar.xml file from srp.jar file of Domain_home/servers/server_name/upload/asapenvid.ear deployment (where server_name is the name of your WebLogic server instance, and envid is the environment ID for your ASAP instance.
there are so many little functions that ASAP utilities does, that could be done in Excel itself, with formatting, formulas etc, but ASAP put them all into a single point. Easy to find and easy to use.
ASAP Utilities is a package of 300+ utilities for Excel. They allow you to conduct efficient sorting, arranging, and other bulk actions. You can export sheets as separate files, apply formulas to certain cells only, and many other functions. The add-in is available in 10 languages.
Getting into the registry might be a risky thing to do and I will also suggest that you do not go there. Just install the ASAP utilities and all its components, components in this case being other applications that might be related to the ASAP utilities and not the registry entries.
3. Using "Find and Replace" to replace diacritics and other characters requires a one-to-one replacement, but there are other tools (like ASAP utilities) or methods (like Regular Expressions) that will allow you to do more complex clean-up.
aa06259810