Binary Number Converter Download spreadsheet converts to BCD
This tool simulates a Binary Coded Decimal (BCD) to 7 segment display driver circuit. (wich is also a hexadecimal number converter for 1-15) Click on the checkboxes in spreadsheet next to turn the inputs to the circuit ON or OFF. Bit 1 is the most significant bit while Bit 4 is the least significant. The circuit accepts inputs from 0000 (all bits OFF) to 1111 (all bits ON). Hex characters (A - F) are discplayed for inputs greater than 9 (1001).
The interesting feature of this tool is that there are no macros or even formulae entered directly in the cells, all functionality is achieved using a Named Formula and Conditional Formatting . The Named Formula works out the input to the ciruit while the "LEDs" of the 7 segment display are run using conditional formatting.
The check boxes are linked to the cells A1, B1, C1 and D1, and the input formula "Input" works out the entry in Binary.
The formula is:
Adding a 0 converts the boolean values in cells A1 through D1 into a number.
The logic driving the LEDs can be constructed from AND and OR statements, and are easily handled using conditional formatting. The formatting is used to turn the LEDs off at the appropriate inputs. Conditional formatting is also used to show the switches opening and closing at the input of the circuit
BCD, binary number converter, binary converter,binary calculator, binary number chart, binary converter, binary numbers, bit converter, octal number converter, hexadecimal number converter, binary number calculator
Industrial-EBook.com and all related entities makes no manner of an
endorsement, representation or warranty regarding any contents located
on this site. Viewers understands that any content or other information
offered on or through Industrial-EBook.com are provided for
informational purposes only. Viewers should evaluate any content or
other information offered on or through Industrial-EBook.com in light of
viewer's own individual circumstances. Industrial-EBook.com does not
guarantee the accuracy, adequacy, completeness or availability of any
content or other information offered on or through Industrial-EBook.com
and is not responsible for any errors or omissions or for the results
obtained from the use of any such content or other information. Other
product names used herein are for identification purposes only and may
be trademarks of their respective owners. Industrial-EBook.com disclaims
any and all rights in those marks.