element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • Members
    Members
    • Benefits of Membership
    • Achievement Levels
    • Members Area
    • Personal Blogs
    • Feedback and Support
    • What's New on element14
  • Learn
    Learn
    • Learning Center
    • eBooks
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Dev Tools
    • Manufacturers
    • Raspberry Pi
    • RoadTests & Reviews
    • Avnet Boards Community
    • Product Groups
  • Store
    Store
    • Visit Your Store
    • Choose Another Store
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
Learning Center
  • Learn
  • More
Learning Center
Blog How to build and work with Logic Gates using MS Excel
  • Blog
  • Forum
  • Documents
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Learning Center requires membership for participation - click to join
Blog Post Actions
  • Subscribe by email
  • More
  • Cancel
  • Share
  • Subscribe by email
  • More
  • Cancel
Group Actions
  • Group RSS
  • More
  • Cancel
Engagement
  • Author Author: backcorp
  • Date Created: 28 Nov 2020 4:49 PM Date Created
  • Views 1673 views
  • Likes 5 likes
  • Comments 1 comment
  • logic gate project
  • tutorial
  • logic gates
  • excel
  • puzzle
Related
Recommended

How to build and work with Logic Gates using MS Excel

backcorp
backcorp
28 Nov 2020

Introduction: Hi, I am Jeff and I’m real good with Excel. I have had training in basic electronics and I like puzzles. I will walk you through making and playing with ‘simulated’ logic gates in Excel.

One drawback of this is the lack of a time sequence in their function. I get around this by generating random numbers ‘1s & 0s’. Therefore, if the order something happens in is crucial for your project you will need to input the Binary Code Decimal manually and I will show you how to have that option. If you just want to see it work and have some fun with logic gates, I will show you what I know and what I did. I will try to be detailed enough for Excel rookies but the second time we do a process I'll be a more brief. You can go back and refamiliarize yourself with the technique if you need to.

 

Conclusion of introduction: I do not want to type “or the color of your choice” every time I tell you what color I used. Please fill free to choose any color you like. Location, on the other hand, should be followed. I may refer to cell [C15] and if your [C15] is not where you put whatever I may have put there, it could get confusing. By all means, move things around to your liking when we’re done building. Left click & Right click refer to the mouse buttons. If you do not have a mouse you will need to make substitutions…

 

(Part 1 of 3)

Let’s make a template.

 

 

                Open up Microsoft Excel. Hit save and give it a title. I named mine LOGIC GATES. You may be more creative than I.

 

(Shrinking the cell width)

Left click on the [A] above the first column and hold the button down. Drag across the letters to about [AS]. The whole area below should now be selected. Right click in that area and select “Column width…” and change the number to 4 and hit ok. You should now have relatively square boxes. Monitors are all a little different so if you need to +/- the size, go for it. Perfect squares are not required.

 

(Create a ‘Truth Table’)

Left click on [C1] and hold. Slide to [F1] and let go. You should have a 4-cell box. Click on the Merge & Center command above and type “STATES” and hit Enter. Left click that area again and click on the yellow bucket above. Now go to the Font area and open the drop-down menu next to the underlined cell icon. Select “All Borders”.

 

Note: I will be using “Quotation marks” for things to type in the cells. You do not need to include them.

 

Now box with your mouse [B3]&[B4] to [F3]&[F4] and click on the “All Borders” icon above. In [B3] type “A”. In the next two boxes, moving right, type “0”(s). In the last two boxes type “1”(s). You should have: A 0 0 1 1. Below that put: B 0 1 0 1.

 

Now we can move faster. Merge & Center [A6]&[B6] Open the drop-down menu by the paint bucket icon and select the lightest gold color for [A6]&[B6]. Mouse box from [F6] to [A6]. Select “All Borders”. Select “Format Painter” (Upper left) and click on [A8]. Select “Format Painter” and click on [A10]. Repeat this process for [A12], [A14] & [A16]. You should have 6 colored boxes each connected to 4 empty boxes.

 

Now type in the boxes starting with [A6]-[F6]: AND 0 0 0 1. [A8]: NAND 1 1 1 0. [A10]: OR 0 1 1 1. [A12] NOR 1 0 0 0. [A14] XOR 0 1 1 0. [A16] XNOR 1 0 0 1.

 

Last, under your yellow “STATES” box in [C2]-[F2]: Type "#1", "#2", "#3" & "#4". Box with your mouse [C2]-[F2] and reduce the font size to 8.

 

 

The Truth Table is complete and we can do the preparation for the Logic Gates.

 

 

A sample of the project is attached.

Attachments:
SPDT Switch.xlsxSPDT Switch.xlsx
  • Sign in to reply
  • backcorp
    backcorp over 2 years ago

    So, it looks like you can just grab the file now. Should I even do the step by step on the rest of the build? Should I jump to the switches? Maybe milk this out one spreadsheet at a time?

     

    You tell me.

     

    I'm just hear because a wise person suggested I share with the community.

     

    I hope someone enjoys it and/or finds it useful.

     

    Jeff

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2023 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • Facebook
  • Twitter
  • linkedin
  • YouTube