Free Excel Spreadsheets - Microsoft XML Files

Downloads Categories

Mission

You do not have to provide any information to download free software downloads. We will screen all donated downloads, for validity and relevance.

TYPE : Spread Sheet Category : Education

Binary Number Converter Download BCD
File Name : BCD.xls
Version : 1.0
File Size (MB) : .026M
Company Name: engineers-excel.com
Author Name : NitinMehta
Primary Download URL: https://www.engineers-excel.com/Tools/BCD/BCD.xls
Download Now
Title :

Binary Number Converter Download BCD

Description :

Binary Number Converter Download spreadsheet converts to BCD

Details :

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:
Input=VALUE((Sheet1!$A$1+0)&(Sheet1!$B$1+0)&(Sheet1!$C$1+0)&(Sheet1!$D$1+0))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

Keywords :

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

Program OS Support :

Win 7, WinXP, Vista



Bookmarks this site

digg free engineering software
free engineering software
free maintenance software
reddit free maintenance software
stumbleupon free engineering downloads

Add to favorites

Disclaimer:

Industrial-EBook.com and all related entities make no manner of an endorsement, representation, or warranty regarding any contents located on this site. Viewers understand that any content or other information offered on or through Industrial-EBook.com is provided for informational purposes only. Viewers should evaluate any content or other information offered on or through Industrial-EBook.com in light of the viewer's 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 the results obtained from using 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.

Send mail to admin @ Industrial-Ebooks.com with questions or comments about this web site. Also see BIN On-site PLC Training Copyright © 2010 All Free Industrial-Ebooks.com