{"id":210,"date":"2020-10-19T19:20:19","date_gmt":"2020-10-19T19:20:19","guid":{"rendered":"https:\/\/msacomputing.com\/?page_id=210"},"modified":"2022-01-13T16:27:37","modified_gmt":"2022-01-13T16:27:37","slug":"bas-and-data-modeling-logic","status":"publish","type":"page","link":"https:\/\/msacomputing.com\/building-automation-made-easy\/bas-and-data-modeling-logic\/","title":{"rendered":"BAS and Data Modeling &#8211; Logic"},"content":{"rendered":"\n<p>How can applying data modeling to Building Automation System database make an operator\u2019s job easier. Four common ways:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/msacomputing.com\/bas-user-interface\/\">User Interface<\/a><\/li><li><a href=\"https:\/\/msacomputing.com\/bas-history\/\">Histories<\/a><\/li><li><strong>Program Logic<\/strong><\/li><li><a href=\"https:\/\/msacomputing.com\/finstack-summary\/\">Equipment Summaries<\/a><\/li><\/ul>\n\n\n\n<p><strong>Program Logic  \u2013 data modeling example \u201cprogramOn\u201d tag<\/strong><\/p>\n\n\n\n<p>Programming logic based on tags is extremely powerful. Creating sequence of operations, creating system \u201crollup\u201d points for minimum, maximum, totals, alarms, etc.<\/p>\n\n\n\n<p>The great thing about programs based on tags is one program can run on 1,000 pieces of equipment. The \u201cbad\u201d thing about programs based on tags is one program can run on 1,000 pieces of equipment. Great care needs to be used when defining a program to make sure it is only running on the intended equipment.<\/p>\n\n\n\n<p>An example of AHU VAV rollup points. The program runs on any&nbsp;AHU serving VAV boxes. The program calculates minimum, maximum, and totals for air flow, cooling load, heating load, and room temperature. It also counts the number VAVs are in the occupied mode served by a specific AHU.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"636\" src=\"https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/logic.png?resize=1024%2C636&#038;ssl=1\" alt=\"\" class=\"wp-image-212\" srcset=\"https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/logic.png?resize=1024%2C636&amp;ssl=1 1024w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/logic.png?resize=300%2C186&amp;ssl=1 300w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/logic.png?resize=768%2C477&amp;ssl=1 768w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/logic.png?resize=1536%2C953&amp;ssl=1 1536w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/logic.png?resize=2048%2C1271&amp;ssl=1 2048w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/logic.png?w=2340&amp;ssl=1 2340w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Fin|Stack and Haystack tagging, you can define tags once and realize value in multiple ways. again. Whether its a simple alarm logic or more complex sequence of operation, the programOn tag will replicate the logic program to as many similar pieces of equipment as you need. <\/p>\n\n\n\n<p>Logic usually runs on equipment but it can run on points for greater functionality. For instance, logic to alert the operator when a connected device is offline. The programOn tag for the logic &#8211; &#8220;point and allowProgram and deviceStatus.&#8221; Any point with the &#8220;deviceStatus and allowProgram&#8221; tags will be monitored. If the &#8220;curStatus&#8221; tag value does not equal &#8220;ok&#8221; then the point is offline and the logic will create an alarm to alert the BAS operator of the issue.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"395\" src=\"https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/deviceOfflineLogic.png?resize=1024%2C395&#038;ssl=1\" alt=\"\" class=\"wp-image-214\" srcset=\"https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/deviceOfflineLogic.png?resize=1024%2C395&amp;ssl=1 1024w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/deviceOfflineLogic.png?resize=300%2C116&amp;ssl=1 300w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/deviceOfflineLogic.png?resize=768%2C296&amp;ssl=1 768w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/deviceOfflineLogic.png?resize=1536%2C593&amp;ssl=1 1536w, https:\/\/i0.wp.com\/msacomputing.com\/wp-content\/uploads\/2020\/10\/deviceOfflineLogic.png?w=1786&amp;ssl=1 1786w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>These are just two simple examples. For more information contact us <a href=\"https:\/\/msacomputing.com\/contact\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How can applying data modeling to Building Automation System database make an operator\u2019s job easier. Four common ways: User Interface Histories Program Logic Equipment Summaries Program Logic \u2013 data modeling example \u201cprogramOn\u201d tag Programming logic based on tags is extremely powerful. Creating sequence of operations, creating system \u201crollup\u201d points for minimum, maximum, totals, alarms, etc.&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/msacomputing.com\/building-automation-made-easy\/bas-and-data-modeling-logic\/\" class=\"themebutton2\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"nf_dc_page":"","footnotes":""},"class_list":["post-210","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/pages\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/comments?post=210"}],"version-history":[{"count":5,"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/pages\/210\/revisions"}],"predecessor-version":[{"id":269,"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/pages\/210\/revisions\/269"}],"wp:attachment":[{"href":"https:\/\/msacomputing.com\/building-automation-made-easy\/wp-json\/wp\/v2\/media?parent=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}