I made an Excel Spreadsheet for Logic gates, amongst other stuff; I decoded 6 bit BCD to 64 independent gates. One for each number and zero. I watched the video on 7 segment displays and added/assigned the gates into 2 4 bit strings (ones & tens) for two 4 in 7 out chips as shown in an element14 video. Then I duplicated the chip, all with Logic Gates. I wrapped it up with an Excel formula based pair of 7 segment displays from the Logic Gates 1s & 0s. You may need Excel formula knowledge to take full advantage of this but you can make anything you want. I think this would be handy for element14 for showing the concept in a big way.
I happen to be on vacation in 'the last decade'. I'm going to try and give you the best version of this. After some thought, it is likely that my color correction likely made the colors worse for you guys. I made it better for office 2007 which likely scrambled it a second time for you. Note: You will see my chip simulations to the right of the 7 segment displays. Above them you will see the 'letter, number' co-ordinance to find them on that page.
Page 1 is a relative term for first of project:
Page 1) BDC decoder 0-32. This became the master page for the project. It has the controls and a cut and paste of page 2s results.
Page 2) BDC decoder 33-63. This is a good place to start because it is more like how I started. I copy/pasted the 0-32 page and made the minimum changes to make it correct. I changed all the 6th. bits from 0s to 1s and changed some 'hypothetical wirers' to the correct gates for the correct result. I then did the copy/paste of the standard number bar under the BCD to page one so it would have the full read out. One of the coolest parts to me was making the random number override on the left of page 1. Not that it is special in formula but that I wanted it and I made it happen.
I watched the element14 video on 7 segment displays and Page 3 started to take form.
Page 3) You'll read this from Row 68 up. The bottom is a copy/paste of the 0-63 result gates from pages 1 & 2. You'll see my labeling improves from the previous pages. I got it in my head how to turn the 0-63 into ones and tens and I started pasting gates column after column. I went back and labeled each gate with an ID and 'hypothetical wire' locations and then I went through the tedious task of, this = here and that = there. It turned out that I had pasted a few more gates than I needed. Eventually I deleted most of them. You will see a few on the tens side I left for place holders. After all I was only going to the 60s.
Below Row 68 is where I turned the gates decoded from the 6 bit into gates recoded into 4 bit. Tens on the left and then a chip reproduction of a 7 segment a-g section right of that. Right of that is a cut/paste for the ones section. Once I had that I copy/pasted each result on to my Chip displays and from there onto my Excel formula 7 segment displays.
I have a question for you. I'm new at this, telling you what cell to bla, bla, bla, makes it obvious. When I was invited to do this I was not prepared. I typed all that stuff down before I new I could attach a file. Credit where it is due, I saw later that a member provided this information but I was late to understand what I had been given.
Thank you again sir.
Question: Do I stay on this Blog and work out the BCD calculator or start a new one? It would be nice to move away from the blog that I spelled 'to' wrong. On the other hand, continuity could have its advantages.
Don't expect much until next week. I really am on vacation. Monday for me will be 10 days worth of logs & reports and maybe 3 or 4 reconciliations.
If this attachment does not have light gold logic gate names let me know and I'll attach a better copy next week. I'm doing what I can with what I have at the moment.
Until then, enjoy and have safe social intercourse.
Jeff
Top Comments