|
|
xlPrecision
Eliminate hidden spreadsheet errors with xlPrecision, an add-in for Microsoft Excel that provides vastly more precise results from mathematical formulas than Excel provides on its own. xlPrecision makes your calculation results up to 2,183.47 times more precise by providing up to 32,767 "significant digits" of precision, compared to only 15 with Excel alone. xlPrecision also eliminates the insidious binary conversion errors that plague spreadsheet programs. xlPrecision also empowers you to use vastly larger (and vastly smaller) numbers than Excel allows on its own. With xlPrecision, you can use gigantic numbers with over 106 TIMES as many digits as Excel allows, as well as extremely tiny numbers with over 106 times as many zeroes to the right of the decimal. Finally, xlPrecision offers many additional features that take you beyond Excel''s capabilities in other ways. Save valuable time with xlPrecision''s powerful Excluder functions. View your sorted data at a glance with the exceptional sorting function. Take control of your fractional data with the versatile fraction reducer. If you''re a programmer, you can even use xlPrecision in your programming code, such as Excel VBA macros, Visual Basic projects, or from any other code that can call an ActiveX (OLE) server. New In xlPrecison 2.0: -- 66 new functions -- Faster calculation -- Export in exponential notation -- Data Control & Analysis Functions -- Help text in Excel''s Insert Function dialog
Keywords: microsoft excel add-in arbitrary precision precise significant digits ieee 754 large small binary conversion sort manager tool internal structure
|
|
|
inspector text
inspector text is an Add-In for Microsoft Excel that adds powerful worksheet formula functions for working with text in worksheet cells, including search & replace, and fuzzy matching. inspector text''s search & replace functions are vastly more powerful and useful than the search & replace functions built into Excel (FIND, SEARCH, REPLACE, SUBSTITUTE, LEFT, RIGHT, & MID), yet are easy to use and do not require any special knowledge. -- Use several powerful wildcards and substitutions. -- Search from left to right or from right to left. -- Choose whether search is case sensitive or not. -- Restrict search to text that appears before (or does not appear before) other text you specify. -- Offset both the position and the length of the text found by any amount. -- If replacing text, choose whether to replace only the first matching string found, or to replace all matching strings found. -- If replacing text, rearrange text as desired, instead of (or in addition to) replacing it. -- Return any of 22 kinds of information about the text found, such as position, position from right, text string found, count of all text strings found, array of all text strings found, etc. etc. -- Choose a friendly, custom message to return if no match is found, instead of returning a standard error, if desired. inspector text''s fuzzy matching worksheet formulas allow you to determine whether or not the text in two cells is similar, or find the characters they have in common. They can also be used to find the text items in a list that are most similar to a target text item. Finally, you can easily find the needle in that haystack! inspector text also adds worksheet formula functions that evaluate concatenated formulas, that return ordinal indicators for cardinal numbers ("1st" for 1, "2nd" for 2...), that exclude or retrieve lists of characters from text, and that perform Regular Expressions search and replace.
Keywords: microsoft excel add-in search replace regex regexp regular expressions fuzzy matching ordinal indicator suffix text exclude extract space saving cash drawers
|
