Excel Unit Conversion Addin 3.0

Excel Unit Conversion Addin 3.0 is a Microsoft Excel Add-in offering direct conversion of values between any two units (eg. kg and lb), which works with the Excel environment to let easy access through the menus and toolbars. 

Units are defined in a simple text file, which can be modified if new ones are required. However most units are already defined and new derived units can be generated on the fly (e.g. kg.m/s). Dimensional Analysis is used to ensure that the conversion is legitimate.

The system entirely removes unit conversion issues from general calculation code - all conversion is done on input and output and the calculation can work in any self-consistent set of units, with no concern as to how the user wishes to input and display the data.

In addition, the approach adopted provides complete flexibility in the units that can be used, and an indefinite number of new units can be added at any time. The system is able to derive new units on the fly, no matter how obsure. These units are broken down using Dimensional Analysis to calculate the conversion factor and to ensure that the conversion is legitimate.

The system is driven by Unicode text files, which you could use to extend the unit classes supported. However, you will probably never need to understand these files, as a comprehensive set of units are already defined.

This Microsoft Add-In provides very powerful unit conversion functionality. The main unit conversion functionality is available as a user defined function. This can be accessed from the Insert Function dialog or by simply typing it into a cell.  It's tight integration with the Excel environment allows easy access through the menus and toolbars. 

The main unit conversion functionality is available as a user defined function. This can be accessed from the Insert Function dialog or by simply typing it into a cell.

Major Features:

1. Flexible unit conversion can easily be added to Excel.
2. A single function call converts between any units of measure.
3. A value and two units string is all that is required.
4. Converted values can be recalculated 'on-the-fly'.
5. Cells can be laid out in any arrangement.
6. Additional conversion function to handle 'Number Unit' strings.
7. User defined function to retrieve description of any unit string.
8. A menu specific to unit conversion is provided to give you access to some commonly used features.
9. Some of the menu items are also provided on a Units toolbar.
10. Each function parameter has a description associated with it in the Function Arguments dialog.
11. Unit Conversion Formula in cells, worksheets & workbooks can be 'frozen'.
12. Unit descriptions, factors & offsets can be updated within Excel.
13. Currency conversion can be handled.
14. Support for Unicode characters, allowing any character or symbol to be used.

Enhancements:

• Improved Excel integration

Requirements: Excel 97-2003

WareSeeker Editor