A Field Perspective on Engineering Commissioning Resources
  • Home
    • What's New
  • Blog
    • Blog Support
  • SketchUp Models
    • SketchUp Resources
    • Bureaucratic Affairs Building HHW System Logic Exercise
    • Bureaucratic Affairs Building Scavenger Hunt
    • Chilled Water Plant System Diagram Exercise
    • The HIjend Hotel >
      • Chilled Water Plant Scoping Exercise
      • Ballroom AHU Scoping Exercise
      • Cooling Tower Scoping Exercise
  • Tools
    • Altitude Correction Factor
    • Economizer Evaluation Checklist
    • Eikon for Educators and WindLGC
    • Effective Duct Length Tool
    • Excel Third Axis Tool
    • Excel Time Value Conversion
    • Insulation Savings Tools
    • Logic Diagram Tool
    • Mixed Air Calculations
    • Monitoring Plan Spreadsheet
    • Pipe Friction Chart
    • Plot Digitizer >
      • Plot Digitizer Pump Curve Example
    • Square Law Spreadsheet
    • System Diagram Symbols
    • Thermodynamic Diagrams Spreadsheet
    • Universal Translator Data Analysis Tool
    • y = (m * x) + b Spreadsheet
  • Useful Formulas
    • Affinity Laws
    • Circular Equivalent Duct
    • Effective Duct Length
    • FT Guide Appendix C
    • HVAC Equations and Concepts
    • Hydraulic Diameter
    • Pump Power and Energy
    • "Square Law"
  • What's That Thing?
    • Cooling Towers
    • Pumps
    • Valves
  • Resources
    • Bill Coad's Writings
    • Data Logging Resources
    • EBCx Skills Guidebook
    • Energy Design Resources
    • Fisher Controls Valve Cavitation Bulletin
    • Functional Testing Guide
    • Honeywell Gray Manual
    • MCC Powers Bulletins
    • NBCIP Reports
    • PEC Tool Lending Library
    • PID Resources
    • Pneumatic Control Resources
    • Resource List
    • Scoping Resources
    • TAB Resources
    • Vintage Carrier Design Manual
    • VRF Systems
    • Williams' Wisdom
  • Videos
    • Bureaucratic Affairs HHW Logic Answers
    • Cooling Tower Flow Variation
    • Economizer Stratification
    • Functional Testing
    • Induction Principles
    • Monitoring Plans
    • Ripple Effects
    • Testing a Pump
    • The Garden of Low Entropy
    • Variable Flow Systems
  • Training
    • Materials from Classes and Presentations >
      • ACEEE
      • ASHRAE
      • ASHRAE - Engineers Notebook
      • BCxA and NCBC
      • BEST Institute
      • Case Studies
      • ERDC 2020 RCx Academy
      • ELPNW
      • ICEBO
      • Marriott AEP
      • Magazine Articles
      • NAVFAC
      • Pacific Energy Center Design, Performance and Commissioning Issues Classes >
        • PEC Class Materials Archive
      • Pacific Energy Center EBCx Project Review
      • Pacific Energy Center EBCx Workshop Series >
        • EBCx Workshop Series 12
        • EBCx Workshop Series 13
        • EBCx Workshop Series 14
        • EBCx Workshop Series 15 >
          • Student One On One Discussions
        • EBCx Workshop Series 16
        • EBCx Workshop Series 17
      • Portland General Electric
      • U of W >
        • U of W Archive
    • On Demand Training >
      • Fans, Ducts and AHUs
      • Induction Motor Principles
      • Introduction to Functional Testing
      • Scope of Work Documents
    • Training Opportunities
  • Contact
    • Copyright and Permissions
  • Home
    • What's New
  • Blog
    • Blog Support
  • SketchUp Models
    • SketchUp Resources
    • Bureaucratic Affairs Building HHW System Logic Exercise
    • Bureaucratic Affairs Building Scavenger Hunt
    • Chilled Water Plant System Diagram Exercise
    • The HIjend Hotel >
      • Chilled Water Plant Scoping Exercise
      • Ballroom AHU Scoping Exercise
      • Cooling Tower Scoping Exercise
  • Tools
    • Altitude Correction Factor
    • Economizer Evaluation Checklist
    • Eikon for Educators and WindLGC
    • Effective Duct Length Tool
    • Excel Third Axis Tool
    • Excel Time Value Conversion
    • Insulation Savings Tools
    • Logic Diagram Tool
    • Mixed Air Calculations
    • Monitoring Plan Spreadsheet
    • Pipe Friction Chart
    • Plot Digitizer >
      • Plot Digitizer Pump Curve Example
    • Square Law Spreadsheet
    • System Diagram Symbols
    • Thermodynamic Diagrams Spreadsheet
    • Universal Translator Data Analysis Tool
    • y = (m * x) + b Spreadsheet
  • Useful Formulas
    • Affinity Laws
    • Circular Equivalent Duct
    • Effective Duct Length
    • FT Guide Appendix C
    • HVAC Equations and Concepts
    • Hydraulic Diameter
    • Pump Power and Energy
    • "Square Law"
  • What's That Thing?
    • Cooling Towers
    • Pumps
    • Valves
  • Resources
    • Bill Coad's Writings
    • Data Logging Resources
    • EBCx Skills Guidebook
    • Energy Design Resources
    • Fisher Controls Valve Cavitation Bulletin
    • Functional Testing Guide
    • Honeywell Gray Manual
    • MCC Powers Bulletins
    • NBCIP Reports
    • PEC Tool Lending Library
    • PID Resources
    • Pneumatic Control Resources
    • Resource List
    • Scoping Resources
    • TAB Resources
    • Vintage Carrier Design Manual
    • VRF Systems
    • Williams' Wisdom
  • Videos
    • Bureaucratic Affairs HHW Logic Answers
    • Cooling Tower Flow Variation
    • Economizer Stratification
    • Functional Testing
    • Induction Principles
    • Monitoring Plans
    • Ripple Effects
    • Testing a Pump
    • The Garden of Low Entropy
    • Variable Flow Systems
  • Training
    • Materials from Classes and Presentations >
      • ACEEE
      • ASHRAE
      • ASHRAE - Engineers Notebook
      • BCxA and NCBC
      • BEST Institute
      • Case Studies
      • ERDC 2020 RCx Academy
      • ELPNW
      • ICEBO
      • Marriott AEP
      • Magazine Articles
      • NAVFAC
      • Pacific Energy Center Design, Performance and Commissioning Issues Classes >
        • PEC Class Materials Archive
      • Pacific Energy Center EBCx Project Review
      • Pacific Energy Center EBCx Workshop Series >
        • EBCx Workshop Series 12
        • EBCx Workshop Series 13
        • EBCx Workshop Series 14
        • EBCx Workshop Series 15 >
          • Student One On One Discussions
        • EBCx Workshop Series 16
        • EBCx Workshop Series 17
      • Portland General Electric
      • U of W >
        • U of W Archive
    • On Demand Training >
      • Fans, Ducts and AHUs
      • Induction Motor Principles
      • Introduction to Functional Testing
      • Scope of Work Documents
    • Training Opportunities
  • Contact
    • Copyright and Permissions

Logic Diagram Tool

Picture
Logic diagrams are a very useful way to convey a control sequence in a generic format.   Symbols, by there nature, have very precise definitions.  As a result, when you develop logic using symbols, it tends to eliminate any vagaries of the English (or other) language.  

If you want to see what a control system design standard looks like that utilizes logic diagrams, there are at least two Universities that have theirs up and available on line.  The links to those standards and other examples of logic diagrams are available on the Control Standards and Logic Diagram Examples​ page of this website.

​In many ways, logic diagrams are very similar to the flow charts many of us were taught to use when we learned computer programming.  As a result, by developing a logic diagram to convey your intended control sequence, you are creating a flow chart for your desired sequence.  As long as you supplement it with the definition of your symbols, the logic diagram can be used to convey your intent to any control system technician for implementation in the proprietary programming language of their particular system.
Picture
Picture
The system diagram for a simple hot water system serving the imaginary Department of Bureaucratic Affairs building model I use in some of my training classes.
The image at the top of the page is an example of a logic diagram.  Specifically, it is the logic for controlling the steam heat exchanger in the hot water system illustrated below and to the right of it.  The logic diagram was created in a spreadsheet tool we have developed that lets you paste symbols from a symbol set onto a grid created by the row height and column width settings in Excel. 

Turning on the "snap to grid" feature in Excel helps you keep everything orderly.The Logic Diagram Tool, is actually just a "poor man's" version of some of the other programming tools that are out there that you can obtain for free, like Eikon for Educators and WindLGC.   Prior to developing the Logic Diagram Tool, I used both of those packages to develop  and teach logic.   But the challenge was that there is a learning curve associated with using either one and in a class room setting, I found that I was spending a lot of my time teaching the tool rather than teaching the use of the tool.  The Logic Diagram tool tries to leverage the familiarity many people have with Excel and Microsoft Office drawing objects.   And it is not vendor specific where as the other products are associated with specific vendors;  Automated Logic Controls for Eikon and IDEC for WindLGC.

Having said that, even though there are probably more people familiar with drawing with Microsoft drawing objects, there still may be some who are not up to speed on that.  The techniques are fairly easy to pick up and a there are a lot of tutorials out there on the web that will help you understand them.   Here are a few that we think will give you the basics you need to get up and running using the logic diagram tool (they also are included in the instruction tab of the tool).
  • How to Add Shapes in Microsoft Word 2016
  • How to Draw Shapes in Microsoft Word 2016 Drawing Tools Tutorial
  • How to Add Connectors to PowerPoint Shapes
  • Excel Shortcut - Snap to Grid - Podcast 2140
  • Excel 2016 Training Part 6: How to Customize the Quick Access Toolbar With Excel 2016
Note that while the tutorials are specific to a particular MS Office product (Word, Excel, PowerPoint, etc.) the techniques you use with the shapes generally apply across all of the product lines.

You may also find a couple of the GoToMeeting sessions I recorded with students to help them develop their system diagrams to be useful because in them we are working with MS Office drawing objects similar to the ones used in the logic diagram tool.  All of the students offered to share the meetings in case the information would be helpful to others, so hats off to them for their willingness to do that.
  • 2017 EBCx Workshop Series System Diagram GoToMeeting Sessions
The downside of the Logic Diagram tool relative to the vendor tools is that both of the vendor tools allow you to run your logic in a simulation mode once you have created it.   That is a really useful feature in terms of making sure the your logic is truly going to do what you intended before you send it out into the field.   And, since both of those tools are vendor tools, you can actually take the logic you created and load it directly into the product it is associated with if that happens to be the product in use on your project.  If you want to know a little bit more about either tool, we have a webpage that includes a bit more information along with some example programs that you can download and play with.

In addition making the Logic Diagram Tool available, we have also provided some examples of logic that has been developed using the tool, like the hot water logic shown at the top of the page.  We plan to keep adding examples to the website going forward, so you may want to check back every once-in-a-while if you are interested in this sort of thing.  I should also mention that you can get a copy of the system diagram associated with the logic on the 
system diagram page of the web site.

For now, the examples are just the control logic for a particular process.  But eventually we will add the point lists, sequences and system diagrams so the full context of the logic can be understood.

​The files below will provide you with the current version of the spreadsheet tool along with a PowerPoint file that contains the symbol set and an explanation of how to use the symbols in case you want to try your hand at it.  If you put the two files in the same folder, then you should be able to click on the links next to the symbols on the symbol list tabs in the Excel Spreadsheet and open up the relevant PowerPoint slide associated with the symbol, which includes an explanation of how it is to be used and what the various connections on the logic block are for. 

The first tab of the spreadsheet contains some instructions to help get you started. 

As a "Heads Up", The tool has a couple of macros that let you turn the grid on and off and change the background color from black to white.  So, you will need to save the tool as a macro enabled file and enable the macros for those features to work.

The background color change hinges on two custom color pallets I have created; 
FDE Primary.xml and FDE Primary White.xml, which are referenced by the macros.  As far as I know, those pallets will come in with the spreadsheet when you save it.

But, if the colors see odd when you run the macro's, then an issue with the color pallets is the most likely problem (other than my being an engineer and perhaps having no sense of color).  So just in case, I have also included copies of the .xml files associated with the color pallets (they are themes) so you can access them and install them on your machine if you need to.

On my machine, the files are in this location:


C:\Users\dsellers\AppData\Roaming\Microsoft\Templates\Document Themes\Theme Colors  

So, you will need to put them in a similar location on your machine.  Note that the AppData folder is a hidden folder by default, so to see it you need to use this procedure.

Finally, you will find a number of articles that Jay Santos wrote and a few that I wrote about control system design and logic diagram development on our Magazine Articles page.

​
As with the other resources on the web site, we are happy to share them with you, but we are sharing them "as is" and you are using them at your own risk.  We consider them to be intellectual property and copyrighted, so please visit our copyright and permissions page before using them so you understand our conditions for sharing them with you.
Logic Diagram Tool version 9 (logic_diagram_tool_v9.xlsm)
File Size: 1655 kb
File Type: xlsm
Download File

logic_diagram_symbols_v11.pptx
File Size: 1793 kb
File Type: pptx
Download File

Custom Theme Color Pallets (theme_color_palletes.zip)
File Size: 0 kb
File Type: zip
Download File

Mixed Air Control (mixed_air_plenum_control_logic_example.xlsm)
File Size: 1637 kb
File Type: xlsm
Download File

Bureaucratic Affairs HW System Logic (hhw_logic_diagram_v4.xlsm)
File Size: 4634 kb
File Type: xlsm
Download File

Cooling Tower Control (davis_hall_cw_system_v4.xlsm)
File Size: 3341 kb
File Type: xlsm
Download File

Two Speed Cooling Tower Fan with Bypass (cooling_tower_with_two_speed_fan_and_bypass_valve_example_v6a.xlsm)
File Size: 1711 kb
File Type: xlsm
Download File

Home

Blog

Resources

Contact

Picture
A Field Perspective on Engineering - © 2017 Facility Dynamics Engineering, All Rights Reserved
(Contact Me to Check on Lefts or Any Other Questions You May Have about Permissions)