The Engineering Format for Excel©

The Engineering Format for Excel©
Has been augmented to include an Excel Add-in Named 'dNumUtils'

(Please be patient. I am working on this documentation.)

Version 1.70 07APR2005 1106
© 2002, 2005 House of Myrrh

Disclaimer:

While every effort has been made to provide a bug-free tool and good advice, the user of this spreadsheet and instructions bears sole responsibility for any outcomes whether good or bad. Neither the author, website, or ISP shall be responsible for any damages incidental, direct or indirect resulting from the use of this material.
This file provides an Excel © Spreadsheet and Macro that formats the result of a cell into Engineering Notation. Engineering Notation displays in even multiples of 10^3 power. Ex. micro, milli, Kilo and Mega. User can select E^x, symbol (K), or long (Kilo) as displayed suffixes. A trailing text string can also be added to quantify the units. Ex. Ohm, Volt, Amp, etc.

Check it out! Download The latest version of the Add-In, Check Worksheet, and Stand-Alone Worksheet.

dNumUtils.xla - an Excel Add-In containing all the macro functions and sub-routines./li>
dNumCheck.xls - an Excel Workbook that is dependent on the dNumUtils add-in and provides examples of use.
Engr4XL.xls - a Stand-Alone Excel Workbook that incoporates all the functionality of both dNumUtils.xla and dNumCheck.xls in a single more easily shareable Workbook.
engr.htm - This HTML file for your off-line reference.

Installation Notes:

Using an add-in prevents having to re-enable macros everytime a worksheet is opened.

However, there is a problem with using and sharing a Worksheet that uses a Non-Standard Add-In, like mine. Excel adds absolute references, 'Links', to the source of the Functions. This requires the user you share a Worksheet using such an Add-In to 'fix' the 'Links' when they first load the shared spreadsheet. Obviously, you will have to make these adjustments, too.

For this reason the preferred location to install the Add-In is: C:\Program Files\Microsoft Office\Office\Library because this will allow all users to access it. And, provides a common link between systems and users. And, the Add-In should automatically be added to the list under [Tools]-[Add-Ins].

Unzip the files ina sutiable (and known) locations. Copy the dNumUtils.xla file to your Microsoft Office Library Folder/Sub-Directory. Start Excel. Then, using [Tools]-[Add-Ins] select the dNumUtils. This will attach, load and enable the add-in.

Next, load the dNumCheck.xls file. Excel will more than likely ask you if you want to update the references. Click yes. All the locations where the add-in functions are at will change to '#NAME. Don't panic, yet.

Using [Edit]-[Links]-[Change Source] find and select the dNumUtils.xla file (it should be in your Microsoft Office Library folder or Sub-Directory). After a few moments the Functions should be working properly again.

NOTE: you've already installed it on WinXP You must delete EVERY instance of dnumutils.xla from your hard drive, including the zip source and all shortcuts in 'Recent'. Open Excel let it figure out that the Add-In doesn't exist anymore, and remove from list. Close Excel and restart to verify that dnumutils is really missing from the list. Then download the zip source and follow the above installation instructions.

This was the only way I could defeat a previous installation. But, once completed the Check Workbook found the Add-In by itself.

If anyone knows how to save an Excel spreadsheet so that it can be transported without this nonesense (using my add-in) please let me know. This is a pain. But, you only have to do it once. The bad part is that it makes sharing your completed worksheet a bit of a pain. Which is why I am now including the Engr4XL.xls file, for your convinience.

Registration

As this is 'Freeware' registration is not required. However, if you will drop me a line letting me know you are using this Add-In, and stating your agreement not to divuldge the password for the code... I will send it to you. But, please, if you modify it... Don't ask for help.

v1.70 07APR2005 1106
- Fixed a bug in strHex2strBin where a lower case 'b' was inadvertantly placed where a lower case 'e' went, resulting in an 'unrecognised character error' when Hex was entered with a lowercase 'e'.
- Added strBin_AND and strBIN_OR functions to do bitwise AND and OR functions. These are limited the strBIN strings at this time. If enough interest occurs (or, I have a need) I will expand them.
v1.60 16FEB2005 1930
- Added a Function: strBin_Sel() Which allows the selection of a substring from a strBin (Binary String) which is often encountered in deciphering bits sets from within registers.
v1.50 15FEB2005 2000
- Corrected a serious bug that made the strHex2Dnum function return the wrong value for lower case alpha's.
v1.00b 18APR2004 0700
- Made some minor additions/changes to the Check Worksheet.
- Did some re-wording of the documentation where installation is concerned.
v1.00a
- Added code to trap the condition where a number entered into the Shift Right/Left routines exceeds the WW (Word Width in bits) and allow a graceful exit or correction.
- Note: A condition can occur where you have a large number of Shifting Cells all referencing a common seed, and then enter a number too big for the current WW. You will get a Message Box for each and every cell. As there is no 'safe' way to propagate a new WW across the Workbook without risking other not directly affected cells. No 'fix' is emminent.
- Now including a Stand-Alone Check Workbook that includes the full functionality of both the Check Workbook and Add-In.
beta
- Maintains almost all previous functionality
- Dropped support for 'Centi', 'Hecto' and disabling 'Nano'
- Added Public Sub function to do a Shift Right or Shift Left on a given cell. It's a bit crude. But, I am open for suggestions.

1.04 adds Oblique Trig functions to Electron.xls
1.03 adds even more Electronics Formulas, and Conditional Display of 'only' Valid results to Electron.xls.
1.02 adds additional Electronics Formulas to Electron.xls
1.01 corrected a problem with the Math package that at unpredictable times returned a String value as scientific, corrupting the displayed value. This error was discovered to exist in both Excel and Quick Basic. I consider myself 'lucky' to have stumbled onto it.

The Current Function Set Is:

Function Dnum2EngrStr(dNum As Double, _
Optional DP As Long = 3, _
Optional StrForm As String = "P", _
Optional Units As String) As String

Where:
dNum - Number you want displayed as an Engineering Notation String
DP --- Number of Decimal Points
- "P" - as Engineering Powers of Ten. eg., E-03
- "L" - as Long Form. eg., 'Mega', 'milli', 'nano'
- "S" - as a symbol. eg., 'M', 'm', 'ľ' (micro symbol.)
Units --- A follow-on tag to denote what measurement units are in use. eg., 'Ohms', 'Amps', 'Volts'

Function dNum2strHex (dNum as double) as string - converts a Double Precision number to a HEX string.
Function strHex2dNum(strHex As String) As Double - Converts a HEX string to a Double Precision number
Function dNum2strOct(dNum As Double) As String - Converts a Double Precision number to an Octal string
Function strOct2dNum(strOct As String) As Double - Converts an Octal string to a Double Precision number
Function dNum2strBin(dNum As Double) As String - Converts a Double Precision number to a Binary string
Function strBin2dNum(strBin As String) As Double - Converts a Binary string to a Double Precision number
Function strHex2strBin(strHex As String) As String - Converts a HEX string to a Binary string
Function strBin2strHex(strBin As String) As String - Converts a Binary string to a HEX string
Function ShiftLeft(vNum as Variant, Places as Long, Carry As String, WW As Long) as String - Shifts a Variant Left
Function ShiftRight(vNum As Variant, Places As Long, Carry As String, WW As Long) As String - Shifts a Variant Right

Places - Number of Bit Positions to Shift
Carry: (Could Use Some Ideas on Carrys)
- 0 - Zeros Extended
- 1 - Ones Extended
- L - Rotate through Least Significant (This will change to 'R' for Rotate Later.)
- M or S - Most Significant or Sing Extended (Needs Work, Got some ideas?)

You must have the Cell you want acted upon 'Selected' *before* clicking the button(s)
A one bit shift is effected per button click
The Carry Mode must be in the Cell immediately below the Selected Cell
The Word Width in Bits must be in the next Cell Down after the Carry Mode

NOTE:
The purpose of the copyright notice © House of Myrrh and © Mike Druckenmiller is to protect the integrity of the document not restrict it's useage. Please feel free to distribute , in their entirety and without charge, any so marked documents for the purpose of ministry.

Return to: House of Myrrh Home Page

We would greatly appreciate hearing from those who visit our web site. Your Questions, Comments, Suggestions, and, yes even corrections and admonitions are More Than Welcome.

Contact Page