An Excel tool to get the byte values for 7-segment displays


Results 1 to 7 of 7

Threaded View

  1. #1
    Join Date
    May 2011
    Location
    Bangalore, India
    Posts
    33

    Default An Excel tool to get the byte values for 7-segment displays

    When we design projects with 7-segment displays, we simplify the PCB design by connecting any pin of the port to any segment of the display. When we do that, arriving at the byte values for the digits to be displayed becomes a time-consuming job. In order to make life a bit easier, I created an Excel file which comes quite handy in those situations.

    In the file, you merely have to enter the segment names (including the decimal point) against the port pins and voila, the byte values are calculated immediately and you can copy and paste them directly into your code as text along with separating commas. Whether the display is Common Cathode or Common Anode, you get the byte values for digits 0 to 9 as well as digits A to F. Necessary instructions are given on the sheet itself.

    There are plenty of formulas and no macros in the worksheet. In order to prevent accidental overwriting of any formulas, the sheet is protected. This means that you can wok on the file without any fear of deleting or overwriting any formulas, but you are allowed to enter segment names in 8 cells and no entry is allowed anywhere else. If you want to make any changes or improve the tool, you can go ahead after unprotecting the sheet (Review, Unprotect Sheet).

    Sheet2 of the file shows the pinout of the most commonly available single and multi-digit displays which you may find useful.

    To facilitate uploading the file, I have renamed it as "7-Segment Displays - Byte Values and Pinout.txt". After downloading the file, you have to rename it as "7-Segment Displays - Byte Values and Pinout.xlsx" to open it as an Excel file.

    Do let me know your comments and suggestions.
    Attached Files Attached Files

Similar Threads

  1. Replies: 2
    Last Post: - 2nd August 2018, 15:05
  2. Excel Tool for 7 Segment Displays
    By Balachandar in forum mel PIC BASIC Pro
    Replies: 5
    Last Post: - 31st March 2015, 18:05
  3. 7 segment led displays
    By raybel in forum FAQ - Frequently Asked Questions
    Replies: 3
    Last Post: - 12th September 2013, 17:22
  4. 7 Segment Displays and MAX7219
    By Bill Legge in forum mel PIC BASIC Pro
    Replies: 13
    Last Post: - 31st October 2010, 18:30
  5. Multplexing two 7-Segment Displays with PIC16F84A
    By lawriem72 in forum mel PIC BASIC
    Replies: 2
    Last Post: - 19th July 2007, 21:27

Members who have read this thread : 1

You do not have permission to view the list of names.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts