I have made several changes to the Units4Excel spreadsheet:
- Litres added as the base SI unit of fluid volume.
- Units added for specific heat
- Units added for fuel consumption in both km/litre and litres/100 km form
As before, the revisions are currently only in the standalone version; the add-in version will be updated at a later date. The revised spreadsheet may be downloaded from: Units4Excel
Since there are a huge number of other units in use in various contexts it is difficult, if not impossible, to cater for all eventualities, so I will describe how the unit tables may be edited to change unit names or abbreviations and to introduce new units.
The editable tables are all on the “Ext Unit List” and “SIDims” sheets, the tables on the “XLUnit_List” sheet are the units used by the built-in Convert function, and are for reference only. Editing the Non-SI units table for existing units or unit types is straightforward; for instance:
To change default gallon units from Imperial to US fluid units change the table as shown below:
- To insert a new unit, with an existing unit type, insert a blank row in the appropriate range, and enter details following the pattern of the other entries.
- Entering a new unit type is a little more complicated. The screen shots below show the addition of the new “fuel consumption” and “inverse fuel consumption” units:
In order to recognise the new units the spreadsheet must be saved and re-opened.
In future versions this process will be simplified, using the VBA “scripting dictionary” object, which will also improve performance, but the current system allows the addition of any new unit types required.
Pingback: Units for Excel 4: Scripting dictionaries | Newton Excel Bach, not (just) an Excel Blog