Binary Number Converter Download Spreadsheet

Description
This spreadsheet tool converts a BCD (Binary Coded Decimal) to a seven segment display driver circuit.

To switch the inputs in the circuit to ON or OFF, press the checkboxes in the spreadsheet. Bit 1 is the most significant part while Bit 4 is the least significant.

The circuit will accept inputs from 0000 to 1111. (all bits OFF to all bits ON.) For inputs >9, hex characters (A-F) are displayed.

The unique thing about this tool is that no macros nor formulas are entered into the cells directly. The tool works by using Conditional Formatting and a Named Formula.

The Named Formula works out the input to the
ciruit while the "LEDs" of the 7 segment display are run using conditional
formatting.

The LEDs of the seven segment display are run by using conditional formatting whilst the named formula works out the input to the circuit.

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 "Input" will calculate the entry in Binary, and the check boxes are connected to the cells A1, B1, C1, & D1

The formula is:
Input=VALUE((Sheet1!$A$1+0)&(Sheet1!$B$1+0)&(Sheet1!$C$1+0)&(Sheet1!$D$1+0))