Units for Excel 5:

Previous post on Units for Excel

Download spreadsheet: Units4Excel.zip

I have posted a new update of the Units4Excel spreadsheet for download (link above).  The main changes are:

  • The ConvertA and ConvertA2 functions have been combined.
  • The ToSI and FromSI functions have been deleted, since with the use of scripting dictionaries the ConvertA function is very nearly as fast.
  • Functions have been added to convert to and from base SI units, and to work with multi-column ranges or arrays.  These are mainly intended for use with other VBA based routines.
  • The ConvertA and EvalU functions have been modified so that when all the input values have the same units the unit may be specified at the top of the input range.
  • The updated file is also saved in add-in format.

The download file includes documentation and examples of all the functions, as shown in the screen-shots below:

Function Index

ConvertA function with alternative input options.

ToSIBase and FromSIBase functions

ToSIBaseTab and FromSIBaseTab functions

ConvertTab function

ListSI and ListNonSI functions

EvalU function, showing alternative input for the tapered channel example

This entry was posted in Excel, Newton, UDFs, VBA and tagged , , , , , . Bookmark the permalink.

3 Responses to Units for Excel 5:

  1. Pingback: Daily Download 24: Units for Excel | Newton Excel Bach, not (just) an Excel Blog

  2. Pingback: 5 Year Report | Newton Excel Bach, not (just) an Excel Blog

  3. Pingback: what Microsoft think VBA is good for … | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.