Excel Tool for 7 Segment Displays


Closed Thread
Results 1 to 6 of 6
  1. #1
    Join Date
    May 2011
    Location
    Bangalore, India
    Posts
    33

    Default Excel Tool for 7 Segment Displays

    When we design a PCB for a project that includes a 7 segment display, the usual practice is to connect the port pins to the segments in the most convenient way to avoid or minimize jumpers. Then we calculate the byte values for displaying the digits, based on which port pin is connected to which segment. To simplify these calculations, I have created a tool in Excel; you merely enter the segment names (and the decimal point if needed) against the port pins 0 to 7. The Excel tool performs all the required calculations and provides the byte values separated by commas as a text string that can be just copied and pasted into the code.

    If you are using 14 pin PICs like 16F676 which have only 6 pins per port, you cannot assign all the segments to a single port. But it is possible to split the segments between the ports. For example, in 16F676, you can enter segments a, b, c & d against pins that you can use from port A and hyphens for the remaining 4 boxes in the tool. You will get the byte values for port A. By entering the remaining segments against the available port C pins, you can get the byte values for port C. Hyphens are to be entered against port pins that are not used for the display.

    The necessary instructions are given in the worksheet itself. The second sheet shows the pinout of common 7 segment display modules - single digit to 4 digits that you may find useful. The worksheet is protected in order to avoid accidental deletion or overwriting of any cell contents. If you would like to make changes in an attempt to improve the tool, you may do so after unprotecting the sheet.

    File attached: 7-Segment Display Byte Value and Pinout.xlsx.txt (After downloading the file, rename it by deleting the ".txt" at the end.)

    Your comments and suggestions are welcome.

    Regards,
    Bala
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2008
    Location
    Ploiesti, ROMANIA
    Posts
    582


    Did you find this post helpful? Yes | No

    Default Re: Excel Tool for 7 Segment Displays

    Thanks for sharing ! Regards !

  3. #3
    Join Date
    Aug 2003
    Posts
    985


    Did you find this post helpful? Yes | No

    Default Re: Excel Tool for 7 Segment Displays

    Nice idea! This is always a pain in the butt job.
    I used to trace the port pins and convert to segments A-G&DP, blah.
    I lately found it easier to cycle all byte combinations and wait for the right digits to occur!

  4. #4
    Join Date
    Jan 2005
    Location
    Montreal, Quebec, Canada
    Posts
    3,037


    Did you find this post helpful? Yes | No

    Default Re: Excel Tool for 7 Segment Displays

    Can someone attach the file as a XLS format for the old people who are on even older versions of excel?

    Robert

  5. #5
    Join Date
    Sep 2009
    Posts
    752


    Did you find this post helpful? Yes | No

    Default Re: Excel Tool for 7 Segment Displays


  6. #6
    Join Date
    Jan 2005
    Location
    Montreal, Quebec, Canada
    Posts
    3,037


    Did you find this post helpful? Yes | No

    Default Re: Excel Tool for 7 Segment Displays

    Thank you!

Similar Threads

  1. 7 segment led displays
    By raybel in forum FAQ - Frequently Asked Questions
    Replies: 3
    Last Post: - 12th September 2013, 18:22
  2. 7 Segment Displays and MAX7219
    By Bill Legge in forum mel PIC BASIC Pro
    Replies: 13
    Last Post: - 31st October 2010, 19:30
  3. Serial Data to Excel
    By tonyfelloni in forum Serial
    Replies: 4
    Last Post: - 31st March 2009, 21:59
  4. Multplexing two 7-Segment Displays with PIC16F84A
    By lawriem72 in forum mel PIC BASIC
    Replies: 2
    Last Post: - 19th July 2007, 22:27
  5. How to simulate in EXCEL ?
    By Johan in forum mel PIC BASIC Pro
    Replies: 4
    Last Post: - 27th June 2007, 19:08

Members who have read this thread : 0

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

Tags for this Thread

Posting Permissions

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