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.

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 Best Practice includes
1 Downloadable Binary Number Converter

Nitin Mehta offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Sudesh Bhagwandas(last updated: 14/12/2018 10:04)

keyboard_arrow_leftkeyboard_arrow_right

Related categories


Any questions on Binary Number Converter Download Spreadsheet?

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


5.0 / 5 (1 votes)

please wait...