Binary Number Converter Download Spreadsheet
  • Binary Number Converter Download Spreadsheet
Originally published: 22/11/2017 16:07
Publication number: ELQ-12200-1
View all versions & Certificate
certified

Binary Number Converter Download Spreadsheet

This tool simulates a Binary Coded Decimal (BCD) to 7 segment display driver circuit.

binaryconverterdisplay driver circuitengineering

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))

This business tool includes
1 Downloadable Binary Number Converter

Nitin Mehta offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Binary Number Converter Download Spreadsheet?

The user community and author are here to help. Go ahead!

please wait...