<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-10055334</id><updated>2011-12-14T21:41:50.858-05:00</updated><title type='text'>New leafs on an old tree</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>42</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-10055334.post-5803499151218595429</id><published>2010-02-21T13:21:00.004-05:00</published><updated>2010-03-12T15:03:12.145-05:00</updated><title type='text'>EEMS</title><content type='html'>used in BOA project&lt;br /&gt;http://www.prophetsuite.com/ &lt;br /&gt;http://www.activelogix.com/ (by Ex Tridium developer)&lt;br /&gt;&lt;br /&gt;From Excel to MySql:&lt;br /&gt;1. Export your data from Excel to a flat.csv file. &lt;br /&gt;2. Put that flat.csv in C:\ (just for convenience) &lt;br /&gt;3. Launch mysql command or use MySQL Quer Browser: &lt;br /&gt;LOAD DATA LOCAL INFILE 'C:\\flat.csv' INTO TABLE tblTest FIELDS TERMINATED BY ',' &lt;br /&gt;ENCLOSED BY '"' LINES TERMINATED BY '\n' &lt;br /&gt;(field1, field2)&lt;br /&gt;&lt;br /&gt;If you have an extra character after the field, use this: &lt;br /&gt;LINES TERMINATED BY '\r\n' &lt;br /&gt;&lt;br /&gt;If you don't want to have the column names imported, open the .csv file with NOTEPAD and delete them or use IGNORE ROW in the SQL&lt;br /&gt;&lt;br /&gt;Alternative steps: &lt;br /&gt;1. create a ODBC connection to the destination MySQL database. &lt;br /&gt;2. Open MS Access and create a new access database. &lt;br /&gt;3. Import the excel data creating a new table. &lt;br /&gt;4. Export the new table just created selecting "Database ODBC()" from file Type list. &lt;br /&gt;5. Select the ODBC connection related to the destination MySQL database&lt;br /&gt;&lt;br /&gt;http://www.straxx.com/excel/password.html&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-5803499151218595429?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/5803499151218595429/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=5803499151218595429' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/5803499151218595429'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/5803499151218595429'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2010/02/eems.html' title='EEMS'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-4027735319775231377</id><published>2009-04-19T14:06:00.000-05:00</published><updated>2009-04-19T14:12:09.727-05:00</updated><title type='text'></title><content type='html'>Single enumeration&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-4027735319775231377?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/4027735319775231377/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=4027735319775231377' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/4027735319775231377'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/4027735319775231377'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2009/04/single-enumeration.html' title=''/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-2916438841669598572</id><published>2008-01-27T17:17:00.001-05:00</published><updated>2008-01-27T17:17:54.051-05:00</updated><title type='text'>Carrier R2 driver</title><content type='html'>33CNDRVCCN   $2500&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-2916438841669598572?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/2916438841669598572/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=2916438841669598572' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/2916438841669598572'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/2916438841669598572'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2008/01/carrier-r2-driver.html' title='Carrier R2 driver'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-4882525584897789873</id><published>2007-10-03T22:45:00.000-05:00</published><updated>2007-10-03T22:49:13.975-05:00</updated><title type='text'>Game Theroy</title><content type='html'>&lt;a href="http://uctv.canterbury.ac.nz/modules/journal/journalview.php?space_key=4&amp;amp;module_key=41&amp;amp;tag_key=15&amp;amp;journal_user_key="&gt;Game Theroy&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-4882525584897789873?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/4882525584897789873/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=4882525584897789873' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/4882525584897789873'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/4882525584897789873'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/10/game-theroy.html' title='Game Theroy'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-332357958729200116</id><published>2007-09-22T13:54:00.000-05:00</published><updated>2007-09-22T14:52:31.055-05:00</updated><title type='text'>The Palm Islands and The World Islands</title><content type='html'>&lt;iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.com/maps?q=25.216667,55.166667&amp;amp;ie=UTF8&amp;amp;t=h&amp;amp;om=1&amp;amp;ll=25.112337,55.118923&amp;amp;spn=0.077865,0.1157&amp;amp;z=13&amp;amp;output=embed&amp;amp;s=AARTsJphUdfiJQujnQ4jN_qE79UrbQcjew"&gt;&lt;/iframe&gt;&lt;br /&gt;&lt;small&gt;&lt;a href="http://maps.google.com/maps?q=25.216667,55.166667&amp;amp;ie=UTF8&amp;amp;t=h&amp;amp;om=1&amp;amp;ll=25.112337,55.118923&amp;amp;spn=0.077865,0.1157&amp;amp;z=13&amp;amp;source=embed" style="color:#0000FF;text-align:left"&gt;View Larger Map&lt;/a&gt;&lt;/small&gt;&lt;br /&gt;&lt;br /&gt;Besides this, &lt;a href="http://maps.google.com/maps?f=q&amp;hl=en&amp;geocode=&amp;q=25.216667,55.166667&amp;ie=UTF8&amp;t=h&amp;om=1&amp;ll=25.216434,55.15523&amp;spn=0.038903,0.086002&amp;z=14" target="_blank"&gt;the World Islands&lt;/a&gt; is opening.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-332357958729200116?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/332357958729200116/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=332357958729200116' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/332357958729200116'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/332357958729200116'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/09/httpmaps.html' title='The Palm Islands and The World Islands'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-1084310008673417752</id><published>2007-09-22T10:04:00.000-05:00</published><updated>2007-09-22T15:41:52.309-05:00</updated><title type='text'>Data Visualization</title><content type='html'>&lt;p&gt;&lt;embed src="http://www.youtube.com/v/hVimVzgtD6w" width="425" height="350" type="application/x-shockwave-flash" wmode="transparent"&gt;&lt;/embed&gt;&lt;/p&gt;&lt;p&gt;This example shows how powerful it will be if you have all the data together and analysis them.&lt;/p&gt;&lt;p&gt;One of the summarizing comments from Youtube:&lt;br /&gt;There are no third world countries.&lt;br /&gt;The animations make it easy to understand correlations between variables.&lt;br /&gt;Averages hide (often) huge differences within a statistical population.&lt;br /&gt;The data is spread across multiple systems and need to be linked and searchable.&lt;br /&gt;&lt;br /&gt;More info can be found at &lt;a href="http://www.gapminder.org/" target="_blank"&gt;here&lt;/a&gt; &lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-1084310008673417752?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/1084310008673417752/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=1084310008673417752' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/1084310008673417752'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/1084310008673417752'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/09/data-visualization.html' title='Data Visualization'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-4635186169458156918</id><published>2007-08-20T21:13:00.001-05:00</published><updated>2007-08-20T22:12:55.178-05:00</updated><title type='text'>Controller programming library 2</title><content type='html'>How do we differentiate controller A to B? I/O, point assignment and sequence.&lt;br /&gt;&lt;br /&gt;If we have a master I/O list for all controllers, it's easy to figure out the difference between them by putting them side by side.&lt;br /&gt;&lt;br /&gt;I would like to have the software cover the difference of point assignment for the programmers as long as they are in one controller. As I mentioned before, the logic layer is above the physical point assignment and it won't be affected by the order of I/O or pseudo points in a controller.&lt;br /&gt;&lt;br /&gt;Now, here comes sequence. In TXT library, I setup modules that match the sequence blocks on the drawing. And I setup CID that represent the selected sequences in each controller. While that works pretty well, it may not fit all real applications.&lt;br /&gt; &lt;br /&gt;Firstly, one controller may have more than 1 units. So CID must be arranged per unit.&lt;br /&gt;&lt;br /&gt;Secondly, there are always new sequences that were not included in the library. So the library has to be updated.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-4635186169458156918?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/4635186169458156918/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=4635186169458156918' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/4635186169458156918'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/4635186169458156918'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/08/controller-programming-library-2.html' title='Controller programming library 2'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-3905858747500003296</id><published>2007-08-20T21:00:00.000-05:00</published><updated>2007-08-20T21:03:29.338-05:00</updated><title type='text'>AX domain-wide authentication</title><content type='html'>a. Add a String slot to the WebService and name it cookieDomain.&lt;br /&gt;b. Enter the domain name in the field.&lt;br /&gt;c. When domain name is used the cookie will log you on with the same&lt;br /&gt;logon of the first station. If you do not have the stations registered in your&lt;br /&gt;DNS Server you can workaround by putting the host in the host file&lt;br /&gt;(Platform/TCP/IP Configuration).&lt;br /&gt;i. For example:&lt;br /&gt;cookieDomain = tridium.com&lt;br /&gt;host file:&lt;br /&gt;jace1.tridium.com&lt;br /&gt;jace2.tridium.com&lt;br /&gt;jace3.tridium.com&lt;br /&gt;&lt;br /&gt;192.168.1.100:82/ord?station:|slot:/Drivers/LonNetwork/VAV_001&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-3905858747500003296?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/3905858747500003296/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=3905858747500003296' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/3905858747500003296'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/3905858747500003296'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/08/ax-domain-wide-authentication.html' title='AX domain-wide authentication'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-8223085985147903986</id><published>2007-08-20T16:23:00.000-05:00</published><updated>2007-08-20T21:09:09.162-05:00</updated><title type='text'>Controller programming library</title><content type='html'>How to easily figure out the difference between 2 controller programming? Or more?&lt;br /&gt;&lt;br /&gt;By point table? CVAHU02a to CVAHU01b, +FrzAlm +OaFlowSig +RaCO2 +RmRh&lt;br /&gt;Following common sense, I know FrzAlm will stop fan in emergency. I don't know if those 3 additional AI are for monitoring only or acutually bring in more sequence.&lt;br /&gt;&lt;br /&gt;By CID? +33(CO2 control) +34(outside air flow measurement and control)&lt;br /&gt;Combining point table, I get a rough idea of what's the differece. But there's more.&lt;br /&gt;&lt;br /&gt;Inputs, outputs, AV and BV assignments. I can ignore this in TXT library, since the logic layer is abstract and points are identified by their name, not the physical assignment. But in GRA library, I lose the control and the tool does not separate them. When I move programs from CVAHU01b to CVAHU02a, points are associated with their ID, not name. Very ugly! I have to manually go through each point to make sure logics are not connected to wrong points due to assignment changes.&lt;br /&gt;&lt;br /&gt;The differences are always &lt;strong&gt;I/O, assignement and sequence&lt;/strong&gt;. But the above process only applies to those controllers in the library. In real projects, things are more complicated. Normally, they don't have CID. (CID reminds me of how I differtiate controllers when I programmed them and they came from sequences.)&lt;br /&gt;&lt;br /&gt;I have to identify them on HW drawings, in sequences. And they were checked by HW designer but this very simple result was left outside of the drawings. It's too bad that one can not pass all the useful information to downstreams.&lt;br /&gt;&lt;br /&gt;That's why we need a revolution of the design process. Some of the key elements helping efficient engineering have to be identified and recorded at the very beginning of the job.&lt;br /&gt;&lt;br /&gt;Great success begins at the beginning!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-8223085985147903986?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/8223085985147903986/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=8223085985147903986' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/8223085985147903986'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/8223085985147903986'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/08/controller-programming-library.html' title='Controller programming library'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-3480755159034611173</id><published>2007-08-11T10:33:00.000-05:00</published><updated>2007-08-11T11:43:05.551-05:00</updated><title type='text'>Computer tools</title><content type='html'>&lt;a href="http://www.atribune.org/ccount/click.php?id=4"&gt;VundoFix.exe&lt;/a&gt;&lt;br /&gt;&lt;a href="http://www.superantispyware.com/"&gt;superantispyware&lt;/a&gt;&lt;br /&gt;&lt;a href="http://download.bleepingcomputer.com/oldtimer/winpfind3u.exe"&gt;winpfind3u.exe&lt;/a&gt;&lt;br /&gt;&lt;a href="http://www.personalfirewall.comodo.com/"&gt;Comodo Firewall&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-3480755159034611173?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/3480755159034611173/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=3480755159034611173' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/3480755159034611173'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/3480755159034611173'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/08/computer-tools.html' title='Computer tools'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-7500626773862659256</id><published>2007-08-04T22:46:00.000-05:00</published><updated>2007-08-04T23:29:36.576-05:00</updated><title type='text'>My Tridium R2 tools 1</title><content type='html'>I thought about this over a year, and finally upgraded my tools of importing NVs from Excel 50/500 controllers and converting them to program objects.&lt;br /&gt;&lt;br /&gt;There are 2 ways, from CARE printout or from LonSchemaManager of Dynamic device. They are separate exe files now. Maybe in next upgrade, I'll combine them together.&lt;br /&gt;&lt;br /&gt;The improvements are:&lt;br /&gt;1) Before LonSchemaManager, I was using web property page of each Dynamic device, which requires additional webUI, live station and Excel as a temporary media. LonSchemaManager is much easier to get, even from a offline station.&lt;br /&gt;&lt;br /&gt;There was an even earlier version, which requires a man-made Excel spreadsheet. The Excel spreadsheet was a part of the turnover documents from the CARE guy. But I didn't like it. Firstly, it costs more CARE guy's time and sometimes he just simply cannot provide it. Secondly, it may not reflect the true settings in CARE, since it's a manual process, and any human mistake may happen.&lt;br /&gt;&lt;br /&gt;2) The software now shows an editable table of all NVs instead of directly generating codes in text windows and leaving no interface for human reviewing and editing. Single or multiple continuous NVs can be manually deleted. It's sorted by NV names. For further orgnizing, these NVs can be copied to and pasted from Excel.&lt;br /&gt;&lt;br /&gt;3) The CARE version now supports automatically removing bound NVs from the NV list, which saves a lot of my manual filtering time.&lt;br /&gt;&lt;br /&gt;4) Generally, the LonSchemaManager version should support all 3rd party Lon controllers. But I don't have enough time to review the program object code. In next upgrade, if possible, I would like to have a configurable code template to make this tool more generic and flexible.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-7500626773862659256?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/7500626773862659256/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=7500626773862659256' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7500626773862659256'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7500626773862659256'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/08/my-tridium-r2-tools.html' title='My Tridium R2 tools 1'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-5994915384248287479</id><published>2007-07-25T22:16:00.000-05:00</published><updated>2007-07-25T22:18:08.611-05:00</updated><title type='text'>Start/stop R2 station without admin tool</title><content type='html'>It is said that station start/stop can be performed through PHP code. Just opened a socket, wrote a simple HTTP request.It's something about "plat stopstation -?" in the HTTP part. I need to check this out.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-5994915384248287479?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/5994915384248287479/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=5994915384248287479' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/5994915384248287479'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/5994915384248287479'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/07/startstop-r2-station-without-admin-tool.html' title='Start/stop R2 station without admin tool'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-6373161033506056074</id><published>2007-07-21T19:33:00.000-05:00</published><updated>2007-07-21T22:55:25.949-05:00</updated><title type='text'>Every dog has its shining moment</title><content type='html'>&lt;object width="425" height="350"&gt;&lt;param name="movie" value="http://www.youtube.com/v/i0dzZTPWrSM"&gt;&lt;/param&gt;&lt;param name="wmode" value="transparent"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/i0dzZTPWrSM" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-6373161033506056074?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/6373161033506056074/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=6373161033506056074' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/6373161033506056074'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/6373161033506056074'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/07/every-dog-has-its-moment.html' title='Every dog has its shining moment'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-7291489222827642737</id><published>2007-07-21T13:07:00.000-05:00</published><updated>2007-08-04T23:28:28.156-05:00</updated><title type='text'>JAVA test of port 9100</title><content type='html'>Since I don't know much about JAVA socket programming, I have to google similar codes and try to simplify them.&lt;br /&gt;&lt;br /&gt;try&lt;br /&gt;{　　　　　&lt;br /&gt;Socket socket=new Socket("192.168.1.100",9100);&lt;br /&gt;String line;&lt;br /&gt;PrintWriter os=new PrintWriter(socket.getOutputStream());&lt;br /&gt;&lt;br /&gt;line=x get this from a String input x;&lt;br /&gt;os.println(line);&lt;br /&gt;os.flush();&lt;br /&gt;System.out.println("Alarm:"+line);&lt;br /&gt;os.close();&lt;br /&gt;socket.close();&lt;br /&gt;}&lt;br /&gt;catch(Exception e)&lt;br /&gt;{&lt;br /&gt;System.out.println("Error:"+e);&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;Alarm service and BAlarmRecepient are a little complicate to me now. I think I will try BStatusString first. This is hard to go further without offical support or commercial stimulation.&lt;br /&gt;&lt;br /&gt;By the way, I accidentally found this interesting BQL:&lt;br /&gt;alarm:bql:select * from openAlarms&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-7291489222827642737?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/7291489222827642737/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=7291489222827642737' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7291489222827642737'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7291489222827642737'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/07/java-test-of-port-9100.html' title='JAVA test of port 9100'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-7009663161104675427</id><published>2007-07-21T10:47:00.000-05:00</published><updated>2007-07-21T11:22:03.501-05:00</updated><title type='text'>Alarm printing without a PC</title><content type='html'>I used to believe that in order to print something, you need to install a printer driver on a OS, Even for a network printer. There are some &lt;span class="blsp-spelling-error" id="SPELLING_ERROR_0"&gt;walk-throughs&lt;/span&gt; on the Internet showing how to configure a direct printing port.&lt;br /&gt;&lt;br /&gt;I've searching for a common protocol over &lt;span class="blsp-spelling-error" id="SPELLING_ERROR_1"&gt;TCP&lt;/span&gt;/&lt;span class="blsp-spelling-error" id="SPELLING_ERROR_2"&gt;IP&lt;/span&gt; that can make a printer print something. And the answer is YES, which means you don't have to install a printer driver and just write a common tool that hopefully works on most of the network printers.&lt;br /&gt;&lt;br /&gt;This makes it possible to have a &lt;span class="blsp-spelling-error" id="SPELLING_ERROR_3"&gt;JACE&lt;/span&gt; controller send out alarm message directly to a network printer. Among all options, HP port 9100 (RAW, &lt;span class="blsp-spelling-error" id="SPELLING_ERROR_4"&gt;AppSocket&lt;/span&gt;, &lt;span class="blsp-spelling-error" id="SPELLING_ERROR_5"&gt;JetDriver&lt;/span&gt; ...) seems to be the &lt;span class="blsp-spelling-corrected" id="SPELLING_ERROR_6"&gt;simplest&lt;/span&gt;. However, there is no standard specification of this protocol. It has to be tested on each target model.&lt;br /&gt;&lt;br /&gt;Here is a useful link:&lt;br /&gt;&lt;a href="http://www.irongeek.com/i.php?page=security/networkprinterhacking"&gt;http://www.irongeek.com/i.php?page=security/networkprinterhacking&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-7009663161104675427?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/7009663161104675427/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=7009663161104675427' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7009663161104675427'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7009663161104675427'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/07/alarm-printing-without-pc.html' title='Alarm printing without a PC'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-7357902492568676917</id><published>2007-07-15T10:15:00.000-05:00</published><updated>2007-07-15T10:24:54.931-05:00</updated><title type='text'>Control system alternative interface</title><content type='html'>This is kind of go back to old days. Low end customers need some low cost simple interface to show them important messages, such as critical alarms.&lt;br /&gt;&lt;br /&gt;Solustion 1 - Buzzer&lt;br /&gt;More and more controller support UO, which, in binary mode, provides 12Vdc output when it's activated. Mini 12VDC Electric Buzzer from Radioshack has been successfully used in a project.&lt;br /&gt;&lt;a href="http://www.radioshack.com/product/index.jsp?productId=2102817&amp;cp=2032058.2032230.2032266&amp;amp;allCount=19&amp;fbn=Type%2FBuzzer&amp;amp;f=PAD%2FProduct+Type%2FBuzzer&amp;fbc=1&amp;amp;parentPage=family"&gt;http://www.radioshack.com/product/index.jsp?productId=2102817&amp;cp=2032058.2032230.2032266&amp;amp;allCount=19&amp;fbn=Type%2FBuzzer&amp;amp;f=PAD%2FProduct+Type%2FBuzzer&amp;fbc=1&amp;amp;parentPage=family&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Solution 2 - big LED display system&lt;br /&gt;My current selection is &lt;a href="http://www.adaptivedisplays.com/"&gt;www.adaptivedisplays.com&lt;/a&gt;, simply because it provides the protocol details. I need to spend some time on the drive development and test.&lt;br /&gt;&lt;br /&gt;Solution 3 - small Serial LCD&lt;br /&gt;My current selection is melabs Serial LCD (SLCD). Yeah, it provides protocol too.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-7357902492568676917?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/7357902492568676917/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=7357902492568676917' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7357902492568676917'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7357902492568676917'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/07/control-system-alternative-interface.html' title='Control system alternative interface'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-7829796142012679327</id><published>2007-06-09T23:24:00.000-05:00</published><updated>2007-06-10T11:55:36.066-05:00</updated><title type='text'>my perfect control system 1</title><content type='html'>Normally, the design of a control system is based on engineering drawings and specifications of the mechical/electrical system. From these, we extract Level 1 information, most of which are independent to the hardware of the control system (i.e. no size and selection of valves, damper actuators, sensors etc.). Level 1 information is considered as the core information of a control system. It reveals the nature of the system.&lt;br /&gt;&lt;br /&gt;That brings up the first question. What's the best format to record and present Level 1 information? Often, designer uses control system hardware drawing to present it. But that's not a good way. since it contains much more than Level 1. The importance of Level 1 is dilluted in a sea of information. The best presentation of Level 1 should easily have a designer capture the nature of the system in a couple of minutes.&lt;br /&gt;&lt;br /&gt;Level 1 (core):&lt;br /&gt;1, A plant list that summarize all equipment and plants under control.&lt;br /&gt;&lt;br /&gt;This provides all designers and managers a big picture of what the system is. And from this, the index of hardware drawings and the navigation menu of graphics are easily created.&lt;br /&gt;&lt;br /&gt;Moreover, the plant list is useful for all kinds of engineering hour and material cost analysis at marco level.&lt;br /&gt;&lt;br /&gt;2, A point list arranged by controllers&lt;br /&gt;&lt;br /&gt;This is the only item that is hardware related. But we only need to know how many of each type of points each controller can handle. Since I try to keep the design system as much hardware independent as possible, the rule of controller's point capability should be configurable.&lt;br /&gt;&lt;br /&gt;Is there a similar hardware drawing can be followed/reused?&lt;br /&gt;&lt;br /&gt;When creating graphics, one needs to know things such as where all the exhaust fans are?&lt;br /&gt;&lt;br /&gt;3, Control sequence&lt;br /&gt;&lt;br /&gt;The control sequence is not just simply copy and paste from mechnical drawings or specifications. It should be the decided sequence that will programmed in the selected controllers.&lt;br /&gt;&lt;br /&gt;What are the software subroutines should be used? Is there a similar controller program that I can follow/reuse? What exactly are the differences? How to change it to satisfy the current need. (Search and comparison)&lt;br /&gt;&lt;br /&gt;What are the most common used subroutines? (Application library optimization)&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-7829796142012679327?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/7829796142012679327/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=7829796142012679327' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7829796142012679327'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/7829796142012679327'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2007/06/my-perfect-control-system-1.html' title='my perfect control system 1'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-116650537358595389</id><published>2006-12-19T00:13:00.000-05:00</published><updated>2006-12-19T00:16:13.593-05:00</updated><title type='text'>Home Automation</title><content type='html'>I knew nothing about home automation and decided to take a look in this holiday. And I will update to this post little by little.&lt;br /&gt;&lt;br /&gt;protocal: x10 (&lt;a href="http://www.smarthome.com/about_x10.html"&gt;http://www.smarthome.com/about_x10.html&lt;/a&gt;)&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-116650537358595389?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/116650537358595389/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=116650537358595389' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/116650537358595389'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/116650537358595389'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/12/home-automation.html' title='Home Automation'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-116180729323215171</id><published>2006-10-25T15:07:00.000-05:00</published><updated>2006-10-25T15:14:53.240-05:00</updated><title type='text'>EBI EBI</title><content type='html'>After its installation, the computer name can not be changed? the engineer units in EBI won't update with the measurement system changes?&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-116180729323215171?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/116180729323215171/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=116180729323215171' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/116180729323215171'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/116180729323215171'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/10/ebi-ebi.html' title='EBI EBI'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-115552435149854215</id><published>2006-08-13T21:54:00.000-05:00</published><updated>2006-08-13T21:59:11.513-05:00</updated><title type='text'>CARE5 task list</title><content type='html'>-Multiple techs program/commission&lt;br /&gt;-Break XL50/500 controller's SNVT limitation&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-115552435149854215?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/115552435149854215/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=115552435149854215' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/115552435149854215'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/115552435149854215'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/08/care5-task-list.html' title='CARE5 task list'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-115475198967472926</id><published>2006-08-04T23:14:00.000-05:00</published><updated>2006-08-04T23:28:14.306-05:00</updated><title type='text'>Tridium AX Bug Catching Log - BQL</title><content type='html'>Some BQL querys which work fine in Workbench can not suvive in the browser enviroment. And they all come with the character &lt;strong&gt;&lt;span style="color:#ff0000;"&gt;'&lt;/span&gt;&lt;/strong&gt;.&lt;br /&gt;&lt;br /&gt;For example:&lt;br /&gt;select parent.displayName as 'Name',out.value as 'counts' from kitControl:Counter where parent.displayName like 'GroupA%'&lt;br /&gt;&lt;br /&gt;'Name', 'counts' and 'GroupA%' are not allowed.&lt;br /&gt;&lt;br /&gt;------- &lt;em&gt;BCL, not BQL&lt;/em&gt;&lt;br /&gt;&lt;bcl,&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-115475198967472926?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/115475198967472926/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=115475198967472926' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/115475198967472926'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/115475198967472926'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/08/tridium-ax-bug-catching-log-bql.html' title='Tridium AX Bug Catching Log - BQL'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-115110287205914271</id><published>2006-06-23T17:08:00.000-05:00</published><updated>2006-06-24T14:38:05.880-05:00</updated><title type='text'>My Google search has been hijacked</title><content type='html'>Recently, I frequently found myself was taken to strange web sites after clicking the search results from Google. I used to manually remove some obvious spywares, but this one took me a lot more time to figure out.&lt;br /&gt;&lt;br /&gt;First thing I noticed is that the IE status bar shows the link has been redirected to 85.255.114.114, and the php scripts there bring me further the hijack trip. I checked registry and used hijackthis tool from &lt;a href="http://www.spywareinfo.com/~merijn/downloads.html"&gt;Merjin&lt;/a&gt; (It used to be Merjin.org, but it looks like recently this address has been taken over by someone else.) to remove any items with 85.255.114.114. But the problem still exists. Then I decided to change and save the perferences setting of my Google search and hoped that change of setting will get rid of this hijack. The preference link is just at the right of the searching text box. It DID work at first, which is odd to the-current-me since I now know what causes this problem. Unfortunately, the problem came back after a while.&lt;br /&gt;&lt;br /&gt;I used different key words to search the cure online and finally find a useful tool. It's called &lt;strong&gt;F-Secure BlackLight. &lt;/strong&gt;You can download it &lt;a href="http://www.f-secure.com/blacklight/"&gt;here&lt;/a&gt;. Basically, a software technology called Rootkit hides the spywars and make them invisible to the regular anti-spyware software and manual checking. &lt;strong&gt;F-Secure BlackLight&lt;/strong&gt; can find them and put them under the spot.&lt;br /&gt;&lt;br /&gt;With it, I found a couple of evil exe files. They are csbwy.exe, dmhti.exe, filesafer23.exe and howiper.exe. The tool can rename the found files and bring the peace back to my Google searching. If you have the same issue. Try it! And note there is a file called wbemtest.exe on the list. That's a windows system file. Don't rename that one. Good luck!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-115110287205914271?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/115110287205914271/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=115110287205914271' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/115110287205914271'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/115110287205914271'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/06/my-google-search-has-been-hijacked.html' title='My Google search has been hijacked'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-114066219034458351</id><published>2006-02-22T21:27:00.000-05:00</published><updated>2006-02-22T21:47:55.150-05:00</updated><title type='text'>Distech FCU controller in Tridium</title><content type='html'>&lt;strong&gt;Tridium Niagara version&lt;/strong&gt;: r2.301.515&lt;br /&gt;&lt;strong&gt;Lonworks Jar file version&lt;/strong&gt;: lonworks-2.301.515f.v1&lt;br /&gt;&lt;strong&gt;Distech Jar file version&lt;/strong&gt;: lonDistech10-2.301.515a.v1/ lonDistech-2.305.515q.v1/ lonDistechWizards-2.304.515.v106&lt;br /&gt;&lt;br /&gt;I like &lt;a href="http://www.distech-controls.com"&gt;Distech&lt;/a&gt; Free &lt;em&gt;programmable&lt;/em&gt; controller. It's very flexible in terms of working with Tridium, although it can only be programmed in a LNS plug-in.  This is the first time I play with its FCU &lt;em&gt;Lonmark&lt;/em&gt; controller and program it in Tridium.&lt;br /&gt;&lt;br /&gt;Distech provides a wizard for the user to config the fan coil Lonmark controller. The first page allows you to choose the measurement system, "metric" or "Imperial". It gives some people convenience as well as an annoying bug.&lt;br /&gt;&lt;br /&gt;It's about the temperature. Besides "metric" or "Imperial", user can choose "fahrenheit" or "celsius" in the properties of Lonworks service. And it looks like when "fahrenheit" + "Imperial", the temperature reading is 32F lower than the actual measurement. This 32F will be put in "offset" to make a temperature input work.&lt;br /&gt;&lt;br /&gt;The other issue occurs when a typical controller shadow object is duplicated. The new shadow object will not inherit all the original configurations. The SNVT type of all hardware inputs will ignore all the changes and keep in SNVT_TEMP_F (It's a changable NVO), even when these NVOs are linked to other objecgts. So, you will not be happy if there are 100 controllers to be duplicated.&lt;br /&gt;&lt;br /&gt;Distech Jar files had a recent upgrade (lonDistech10-2.301.515a.v1/ lonDistech-2.305.515s.v1/ lonDistechWizards-2.304.515.v110). And I have not tested to see if these bugs are fixed.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-114066219034458351?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/114066219034458351/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=114066219034458351' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/114066219034458351'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/114066219034458351'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/02/distech-fcu-controller-in-tridium.html' title='Distech FCU controller in Tridium'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113787315997782039</id><published>2006-01-21T14:45:00.000-05:00</published><updated>2006-01-21T14:52:39.990-05:00</updated><title type='text'>What's happening 01/21/2006</title><content type='html'>&lt;a href="http://www.esmagazine.com/CDA/Articles/Column/add10d9e19ea8010VgnVCM100000f932a8c0____"&gt;Building Automation: HP And Cisco Sign In&lt;/a&gt;&lt;br /&gt;&lt;a href="http://en.wikipedia.org/wiki/Deep_lake_water_cooling"&gt;Deep lake water cooling&lt;/a&gt;&lt;br /&gt;&lt;a href="http://www.sciam.com/article.cfm?chanID=sa004&amp;articleID=0005CBF4-0A9C-114B-BC2A83414B7F4945"&gt;Big Chill - An ambitious new project uses lake water to cool off city slickers&lt;/a&gt;&lt;br /&gt;&lt;a href="http://rense.com/general69/future.htm"&gt;Future PC's&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113787315997782039?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113787315997782039/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113787315997782039' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113787315997782039'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113787315997782039'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/01/whats-happening-01212006.html' title='What&apos;s happening 01/21/2006'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113773323269167106</id><published>2006-01-19T23:05:00.000-05:00</published><updated>2006-01-20T00:05:10.533-05:00</updated><title type='text'>AHR EXPO opens next Monday</title><content type='html'>The &lt;a href="http://www.ahrexpo.com/"&gt;web site home page&lt;/a&gt; has a script busy loading and changing banners. I wonder how much every blink earns.&lt;br /&gt;&lt;br /&gt;Booth #3532 is shared by 12 Bacnet venders. And they will connect and integrate each other's controllers into their own front-ends over Bacnet/IP. Similar thing has been done in &lt;a href="http://www.automatedbuildings.com/news/dec05/reviews/cctrls.htm"&gt;Bacnet Conference and Expo 2005&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;I can't make it. My plan is to check the &lt;a href="http://www.ahrexpo.com/exhibitorlist/index.php"&gt;exhibitor list&lt;/a&gt; and &lt;a href="http://www.ahrexpo.com/productlocator/index.php"&gt;product locator&lt;/a&gt;, and have fun in a hard way.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113773323269167106?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113773323269167106/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113773323269167106' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113773323269167106'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113773323269167106'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/01/ahr-expo-opens-next-monday.html' title='AHR EXPO opens next Monday'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113737983812667158</id><published>2006-01-15T21:29:00.000-05:00</published><updated>2006-01-15T22:04:07.110-05:00</updated><title type='text'>Invensys Building Systems to go franchise</title><content type='html'>The title of &lt;a href="http://www.tmcnet.com/usubmit/2006/jan/1277835.htm"&gt;this news&lt;/a&gt; is about expanding, but the story is telling the shrinking.&lt;br /&gt;&lt;br /&gt;With a network of Independent Field Offices, IBS is cutting its project delivery force and put the limited resource on R&amp;amp;D(?) and manufacturing. But I am still questioning about the loyralty of the "Independent Field Offices", which are actually dealers. I see more and more dealers adopt "best of breed"method, i.e., to give up the exclusive dealership and mix controllers from different manufacturers, based on the controller prices and engineering costs, in projects.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113737983812667158?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113737983812667158/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113737983812667158' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113737983812667158'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113737983812667158'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/01/invensys-building-systems-to-go.html' title='Invensys Building Systems to go franchise'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113660640987326186</id><published>2006-01-06T22:14:00.000-05:00</published><updated>2006-01-06T23:12:42.770-05:00</updated><title type='text'>huMan to Machine &amp; Machine to Machine</title><content type='html'>The key to Tridium's growth is "anything to internet". Followed that, Echelon came up with &lt;a href="http://www.echelon.com/products/cis/"&gt;iLon&lt;/a&gt; and Bacnet brought out &lt;a href="http://www.bacnet.org/Tutorial/BACnetIP/index.html"&gt;Bacnet/IP&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;Tridium's main goal is M2M market, which furthers the above idea. People predict that in the future, there will be more machine to machine communication than human to machine on networks including Internet. And that's why Tridium joined Honeywell. Honeywell has a deep pocket to support Tridium's ambition.&lt;br /&gt;&lt;br /&gt;However, M2M is a little far away from BA industry. And I think the distance in between is the &lt;em&gt;human to machine interface&lt;/em&gt;. With more and more devices support web interface. The operators should not be locked at the PC. Using generic wireless web-supported personal electronics such as PDA, cell phone and more fancy stuffs like &lt;a href="http://blogs.sun.com/roller/page/chandan?entry=the_all_in_one_card"&gt;all-in-1-card&lt;/a&gt; and &lt;a href="http://www.eink.com/index.html"&gt;e-paper&lt;/a&gt;, the BA system can be accessed anywhere in the building. I'll call these as &lt;strong&gt;pervasive interfaces&lt;/strong&gt;.&lt;br /&gt;&lt;br /&gt;With &lt;strong&gt;pervasive interfaces&lt;/strong&gt;, M2M sets the foothold in BA systems. Site devices can send real time and historical data to remote servers through M2M technology. We don't need PC on site for system persentation and historical data storage anymore. Operators log on the system provider's portal web server and check the building conditions. The service provider maintains the system at back stage. The BA system can be accessed anywhere even thoudsands miles away from the building.&lt;br /&gt;&lt;br /&gt;I'll explorer more of this in latter posts.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113660640987326186?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113660640987326186/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113660640987326186' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113660640987326186'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113660640987326186'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/01/human-to-machine-machine-to-machine.html' title='huMan to Machine &amp; Machine to Machine'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113626541520160826</id><published>2006-01-03T00:16:00.000-05:00</published><updated>2006-01-03T00:32:51.076-05:00</updated><title type='text'>Schneider and TAC</title><content type='html'>A lot of BA acquistions and mergers happened in last 2 years.&lt;br /&gt;&lt;br /&gt;Other than the cases I mentioned previously, &lt;a href="http://www.schneider-electric.com/"&gt;Schneider Electric &lt;/a&gt;has been played actively. After Schneider gobbled up &lt;a href="http://www.tac.com/"&gt;TAC&lt;/a&gt; in 2003 and &lt;a href="http://www.andovercontrols.com/"&gt;Andover Controls&lt;/a&gt; in 2004, the new TAC formed in April, 2005, with estimated 2004 revenes of 0.7B.&lt;br /&gt;&lt;br /&gt;Along with some lightweight acquisitions in &lt;a href="http://www.abacus-engr.com"&gt;consulting engineering&lt;/a&gt; and &lt;a href="http://www.tac.com/Content?contentId=document/6157&amp;node=1374"&gt;security/fire&lt;/a&gt; businesses, TAC took over almost all the building automation business of &lt;a href="http://www.invensys.com"&gt;Invensys&lt;/a&gt; in Europe and Middle East in June, 2005. By the way, &lt;a href="http://www.invensys.com/"&gt;Invensys&lt;/a&gt; is a company in controls and automation industry who suffered a lot from its acquistion &amp;amp; merger failures. &lt;a href="http://www.jimpinto.com/commentary/invensysdecline.html"&gt;Here&lt;/a&gt; are some details.&lt;br /&gt;&lt;br /&gt;Another notable Schneider's acquistion is Canadian based company &lt;a href="http://www.pwrm.com"&gt;Power Measurement&lt;/a&gt; (not throught TAC) in April, 2005.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113626541520160826?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113626541520160826/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113626541520160826' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113626541520160826'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113626541520160826'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/01/schneider-and-tac.html' title='Schneider and TAC'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113609749865569778</id><published>2006-01-01T01:38:00.000-05:00</published><updated>2006-04-28T18:52:18.720-05:00</updated><title type='text'>Here comes the new year</title><content type='html'>&lt;a href="http://en.wikipedia.org/wiki/Steve_jobs"&gt;Steve Jobs&lt;/a&gt;  asked a question to &lt;a href="http://en.wikipedia.org/wiki/John_Sculley"&gt;John Sculley&lt;/a&gt;, "Do you want to sell sugar water for the rest of your life, or do you wnat to change the world?" Although, over years, this may have became a cliche because &lt;a href="http://www.apple.com"&gt;Apple&lt;/a&gt; guys used it again and again to the people they want. But it is still powerful if you ask yourself once a year.... in the first 3 years?&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113609749865569778?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113609749865569778/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113609749865569778' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113609749865569778'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113609749865569778'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2006/01/here-comes-new-year.html' title='Here comes the new year'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113592122625563560</id><published>2005-12-30T00:40:00.000-05:00</published><updated>2005-12-31T17:49:35.043-05:00</updated><title type='text'>thoughts from real projects</title><content type='html'>&lt;p class="mobile-post"&gt;The minimum cost of the integration defines the broadness of the integration market. If the devices to be integrated are less valuable than the cost of the integration, people may not want to integrate them. If the cost of the integration is more than the cost of replacing new devices with popular protocols, the integration will not happen.&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113592122625563560?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113592122625563560/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113592122625563560' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113592122625563560'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113592122625563560'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/thoughts-from-real-projects.html' title='thoughts from real projects'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113583144686195660</id><published>2005-12-28T23:44:00.000-05:00</published><updated>2005-12-28T23:44:06.913-05:00</updated><title type='text'>Smart fridge and food management</title><content type='html'>&lt;p class="mobile-post"&gt;I used to buy a lot of thing, put them in the fridge and forget to eat. They ended up at garbage bags. Because once they are in the fridge, I easily lose the awareness of their existence. Everytime I open the frige door, I always pick the things first into my eyes, which are probobally from my latest purchase.&lt;/p&gt;&lt;p class="mobile-post"&gt;I wish there is a display on the fridge showing me a list where the earliest or nearest to the expire date ones are on the top. It could be a little program in the PC, but again I will forget to open it, which make the program worthless. It must be something on the fridge.&lt;/p&gt;&lt;p class="mobile-post"&gt;The input method is the hardest part. If I type too much, this program may be abandoned. The easier the input is, the more useful the program will be. The options I can come up are barcode scanning (This way, I should have the same database as the one used by supermaket or setup every new barcode and reuse. Or, web serves?),receipt scanning (This way, the same data could be used for my financial management.) and typing.The first 2 methods require some data re-orgnization process and manual verification. Then, everytime I take something out of the fridge, I have to update it in a convenient way.&lt;/p&gt;&lt;p class="mobile-post"&gt;Now, let's talk about the management. Each item in the database will be assigned a freshness period or an expire date. Along with the date I put it into the fridge, the program can determine the order of the list. An enhanced funtion could be recommending recipes according to the top items on the list.&lt;/p&gt;&lt;p class="mobile-post"&gt;Most of the proccssing and calculation can be done in my PC. On the fridge, there are only a LCD display (a touch screen will be too luxury), a commnunication transceiver (most likely wireless) and input devices (scanner and buttons).&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113583144686195660?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113583144686195660/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113583144686195660' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113583144686195660'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113583144686195660'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/smart-fridge-and-food-management.html' title='Smart fridge and food management'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113554149322360093</id><published>2005-12-25T15:11:00.000-05:00</published><updated>2005-12-25T16:45:55.150-05:00</updated><title type='text'>Honeywell to acquire Tridium (December, 2005)</title><content type='html'>Here comes another interesting acquisition. Some people even said this case is more or less like IBM acquiring Microsoft at its beginning in building automation industry.&lt;br /&gt;&lt;br /&gt;Is &lt;a href="http://www.tridium.com"&gt;Tridium&lt;/a&gt; going to become the Microsoft in BA industry? Maybe. Tridum has successfully got its Niagara Framework platform behind many building automation product lines in the market, such as &lt;a href="http://www.staefa.com"&gt;Siemens Steafa Talon system&lt;/a&gt;, &lt;a href="http://customer.honeywell.com/Honeywell/ui/pages/catalog/SystemCategory.aspx?Catalog=Buildings&amp;Category=WEBs+System_38931&amp;amp;ChannelID=%7b02CD9124-96F3-4A04-8EA7-1777CCCAD5B3%7d"&gt;Honeywell Webs&lt;/a&gt; and &lt;a href="http://www.invensysibs.com/ia.shtml"&gt;Invensys I/A series&lt;/a&gt;. In September 2005, Johnson Controls launched a new system based on Niagara AX platform called &lt;a href="http://www.jci.com/CorpPR/Releases/cg/release920.asp"&gt;Facility Explorer System&lt;/a&gt;. By now, almost every traditional BA giant has at least 1 product line powered by Tridium. And among HVAC manufacturers, &lt;a href="http://www.commercial.carrier.com/commercial/hvac/product_description/0,3059,CLI1_DIV12_ETI434_PRD582,00.html"&gt;CarrierOne Comfort Integrator&lt;/a&gt; and Mcquay &lt;a href="http://www.mcquay.com/mcquay/common/pages/literature?prodtype=Controls_MicroTechII&amp;menutype=Product%20Information&amp;amp;menutype2=Controls&amp;menutype3=MicroTech%20II&amp;amp;amp;r1=539918&amp;r2=539910&amp;amp;r3=539915"&gt;MicroTech II Chiller System Manager&lt;/a&gt; are actually Tridium JACE controllers.&lt;br /&gt;&lt;br /&gt;But, wait a minute. How about &lt;a href="http://www.echelon.com"&gt;Echelon&lt;/a&gt;, the owner of Lonworks? I figured out years ago, this company want to be BA Intel + BA Microsoft, with &lt;a href="http://www.echelon.com/developers/lonworks/neuron.htm"&gt;Neuron&lt;/a&gt; &lt;em&gt;Chip&lt;/em&gt; in every Lonworks controller and &lt;a href="http://www.echelon.com/products/development/lns/default.htm"&gt;LNS&lt;/a&gt; network &lt;em&gt;operating system&lt;/em&gt; in most of the Lonworks networks.&lt;br /&gt;&lt;br /&gt;Well, so far, no one dominates the market, because companies learned a lot from IT history and became more and more alert. As a result, on any potential direction, there are more than 1 runner. And existing big players can not afford a single chance of losing the game, they just follow every direction. The game of "de facto standard " is harder and harder.&lt;br /&gt;&lt;br /&gt;But they do have difference. Echelon tries to have everybody speak Lonworks, while Tridium accepts all the existing communication protocals including Lonworks and bring them easily on web pages.&lt;br /&gt;&lt;br /&gt;The interesting thing here is that this acquisition blurs the line between competitor and partner. Try to replace "Tridium" with "Honeywell" and read the first paragraph again. How do you feel? Will this acquisioin affect Tridium's market presence among Honyewell's competitors after it lose the independency in BA industry? I finally find the answer. Tridium does not care! Its ambition is more than BA and HVAC industry.&lt;br /&gt;&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113554149322360093?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113554149322360093/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113554149322360093' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113554149322360093'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113554149322360093'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/honeywell-to-acquire-tridium-december.html' title='Honeywell to acquire Tridium (December, 2005)'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113510233707883365</id><published>2005-12-20T12:55:00.000-05:00</published><updated>2005-12-25T02:18:46.150-05:00</updated><title type='text'>Johnson Controls plus York</title><content type='html'>My &lt;a href="http://leaflying.blogspot.com/2005/12/johnson-controls-to-acquire-york.html#links"&gt;last post&lt;/a&gt; lists a couple of numbers and statements regarding these 2 companies before the aquisition. From there, we can tell the margin in conventional HVAC market is much lower than building automation and controls market. Even the later one is getting lower and lower every year. But, despite all of these, as publicly held companies, JCI and York have to grow, to make more money. And that's why they went together.&lt;br /&gt;&lt;br /&gt;My first impression of this acquisition is like &lt;a href="http://www.logitech.com"&gt;Logitech&lt;/a&gt; (a computer peripheral device manufacturer), instead of HP, buying &lt;a href="http://h18020.www1.hp.com/corporate/history.html"&gt;Compaq&lt;/a&gt; (a former giant PC manufacturer). But now, I more and more feel this like the &lt;a href="http://www.pbs.org/newshour/bb/business/jan-june00/aol_01-12.html"&gt;merge&lt;/a&gt; between AOL and &lt;a href="http://www.timewarner.com"&gt;Time Warner&lt;/a&gt; in HVAC industry. But ..., I did not mean that this acquisition will repeat the same bad consequence. JCI's current business is much more solid and robust than that of AOL at 2001.&lt;br /&gt;&lt;br /&gt;In their presentation to investors (Aug. 25), JCI defined a 200B &lt;strong&gt;Building Enviroments&lt;/strong&gt; market, in which, HVAC controls is 12% of the pie and mechanical equipment is 17%. In fact, it is just a combination of all the neighbour markets that new JCI participates. And personally, I don't see it as a new market unless there are unique products for it, New gargets are somthing I really want to see from this kind of acquisition, as I mentioned in &lt;a href="http://leaflying.blogspot.com/2005/12/carrier-to-acquire-automated-logic.html#links"&gt;Carrier+AL case&lt;/a&gt;. However, both JCI and York are companies over 100 years and in stable markets, technology is often not the priority in business decisions. They are not Google. The math here is 1+1=2.&lt;br /&gt;&lt;br /&gt;Where I found 1+1&gt;2 is the oportunities JCI and York penetrate each other's existing customers to sell new controls/mechanical equipment, and more importantly, new combined service. Yes, &lt;strong&gt;service&lt;/strong&gt; is likely the last paradise in this highly competed market. Everybody knows this but how to cook it well is interesting and more difficult. Good luck.&lt;br /&gt;&lt;br /&gt;Over all, I am exited to see this combination and looking forward to see more fresh changes in HVAC world.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113510233707883365?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113510233707883365/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113510233707883365' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113510233707883365'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113510233707883365'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/johnson-controls-plus-york.html' title='Johnson Controls plus York'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113462420910648963</id><published>2005-12-15T00:10:00.000-05:00</published><updated>2005-12-15T00:26:42.153-05:00</updated><title type='text'>A Chilled Water System Analysis Tool</title><content type='html'>This tool, as the developers metioned, is "intended to direct analysis effort toward the most promising cost reduction opportunities".  And it can be downloaded from &lt;a href="http://www.ceere.org/iac/iac_betatestreg.html"&gt;CEERE&lt;/a&gt;. Need some personal information to get it.&lt;br /&gt;&lt;br /&gt;Also, &lt;a href="http://www.ceere.org/iac/assessment%20tool/index.html"&gt;Industrial Energy Conservation Guide&lt;/a&gt; looks good. I need some time to read it.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113462420910648963?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113462420910648963/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113462420910648963' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113462420910648963'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113462420910648963'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/chilled-water-system-analysis-tool.html' title='A Chilled Water System Analysis Tool'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113436012068624475</id><published>2005-12-11T22:59:00.000-05:00</published><updated>2005-12-20T11:15:05.050-05:00</updated><title type='text'>Johnson Controls to acquire York (August, 2005)</title><content type='html'>If you visit &lt;a href="http://www.york.com"&gt;www.york.com&lt;/a&gt; now, you will see a footnote under its YORK logo saying "A Johnson Controls company". This $3.2 billion aquisition was announced in August and completed on &lt;a href="http://www.jci.com/CorpPR/Releases/corp/release949.asp"&gt;Dec. 9th&lt;/a&gt;.&lt;br /&gt;&lt;br /&gt;JCI controls sales in 2004 is $6.1B, 23% of the group sales. Controls operating income in 2004 is $284M, 22% of the total (from JCI 2004 Annual Report). York sales in 2004 is $4.5B with operating income of $128M (from York 2004 Annual Report, which is no longer available online).&lt;br /&gt;&lt;br /&gt;To read through each company's &lt;em&gt;Form 10K&lt;/em&gt; required by SEC is too much for me. But I like the &lt;em&gt;Part I, &lt;/em&gt;which gives me a general picture of the companies and the markets.&lt;br /&gt;&lt;br /&gt;Here are some of the quotes.&lt;br /&gt;"Key factors in the award of installationcontracts include &lt;span style="color:#990000;"&gt;system and service quality&lt;/span&gt;, &lt;span style="color:#990000;"&gt;price&lt;/span&gt;, &lt;span style="color:#990000;"&gt;reputation&lt;/span&gt;, &lt;span style="color:#990000;"&gt;technology&lt;/span&gt;, &lt;span style="color:#990000;"&gt;application engineering capability&lt;/span&gt; and &lt;span style="color:#990000;"&gt;construction management expertise&lt;/span&gt;."&lt;br /&gt;"Worldwide, approximately &lt;span style="color:#990000;"&gt;40 percent&lt;/span&gt; of the Controls Group's sales are derived from installed control systems and approximately &lt;span style="color:#990000;"&gt;60 percent&lt;/span&gt; originate from its service offerings. Also,approximately &lt;span style="color:#990000;"&gt;35 percent&lt;/span&gt; of segment revenues are derived from the new construction market while &lt;span style="color:#990000;"&gt;65 percent&lt;/span&gt; are derived from the existing buildings market."&lt;br /&gt;"The services market is &lt;span style="color:#990000;"&gt;highly fragmented&lt;/span&gt;, with no one company being dominant.Sales of these services are largely dependent upon numerous individual contracts with commercial businesses worldwide and various departments and agencies of the U.S. Federal government."&lt;br /&gt;-JCI&lt;br /&gt;&lt;br /&gt;"Products compete on thebasis of &lt;span style="color:#990000;"&gt;product design&lt;/span&gt;, &lt;span style="color:#990000;"&gt;reliability&lt;/span&gt;, &lt;span style="color:#990000;"&gt;quality&lt;/span&gt;,&lt;span style="color:#990000;"&gt; price&lt;/span&gt;, &lt;span style="color:#990000;"&gt;efficiency&lt;/span&gt;, &lt;span style="color:#990000;"&gt;acoustics&lt;/span&gt;, and &lt;span style="color:#990000;"&gt;post-installation service&lt;/span&gt;.Architects and engineers play an important part in determining which manufacturer's products will bespecified and ultimately used in an application."&lt;br /&gt;"The global equipment markets are driven by new construction and replacement sales in almost &lt;span style="color:#990000;"&gt;equal proportions&lt;/span&gt;."&lt;br /&gt;"Our Global Applied service business competes in a very large but&lt;span style="color:#990000;"&gt; f&lt;/span&gt;&lt;span style="color:#990000;"&gt;ragmented&lt;/span&gt; market, where individualmarket shares are typically in the single digit range. Most of our competition consists of thousands ofindependent mechanical contracting companies delivering services and purchased products. Other competitors include manufacturers such as Trane and Carrier and some &lt;span style="color:#ff0000;"&gt;non-manufacturing national companies such as Johnson Controls&lt;/span&gt;."&lt;br /&gt;-YORK&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113436012068624475?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113436012068624475/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113436012068624475' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113436012068624475'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113436012068624475'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/johnson-controls-to-acquire-york.html' title='Johnson Controls to acquire York (August, 2005)'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113364398893605826</id><published>2005-12-03T15:39:00.000-05:00</published><updated>2005-12-04T01:12:55.426-05:00</updated><title type='text'>Carrier to acquire Automated Logic (April, 2004)</title><content type='html'>&lt;p&gt;Carrier(CCN), York(ISN) or Trane(TracerSummit), each HVAC manufacturer has its own control system. But most of the systems are mainly sold with their HVAC product. These control systems are more like small islands away from the mainland (BAS market). The aquisition interested me because it was first time that I saw a conventional HVAC player took action in the native BAS market. &lt;/p&gt;&lt;p&gt;The following policies were issued, which I think were to protect each other's market share.&lt;/p&gt;&lt;ul&gt;&lt;li&gt;The United Technologies relationship will reinforce Automated Logic's continuing focus on technology and innovation.&lt;/li&gt;&lt;li&gt;Carrier Corporation, the acquiring subsidiary of UTC, is committed to the Automated Logic brand and to its independent network of authorized dealers.&lt;/li&gt;&lt;li&gt;Automated Logic dealers will continue to deliver and service the ALC product line, and Carrier will continue to deliver and service the Carrier CCN product line.&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;And, what's more? Did they all lived happily ever after? I don't know. &lt;/p&gt;&lt;p&gt;Last year, a Carrier control guy guessed that they may soon have a new thing to replace CarrierOne utilizing the the Bacnet open protocol technology from AL. (CarrierOne is acutally a Tridium JACE controller acts as a gateway between CCN and 3rd party control system) Well, after a year and half, CarrierOne is still there.&lt;/p&gt;&lt;p&gt;It is natural for a technical guy to assume the combination of 2 expertises will bring new gargets, like traditional people believe a marrige will lead to children. The real game is more complicate.&lt;/p&gt;&lt;p&gt;To cheer you up at the end of this boring story, here is a stupid joke. Take a look at &lt;a href="http://www.commercial.carrier.com/commercial/hvac/product_description/0,3059,CLI1_DIV12_ETI434_PRD1110,00.html?SMSESSION=NO"&gt;CCNWeb&lt;/a&gt;, a new HMI for CCN system. Feel the java applets and somewhat "Tridiumized" graphics (especially the AHU one). See, Carrier DO have a child, not from his wife, but his mistress.&lt;img src="http://photos1.blogger.com/blogger/3135/760/1600/ha.gif" border="0" /&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113364398893605826?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113364398893605826/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113364398893605826' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113364398893605826'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113364398893605826'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/carrier-to-acquire-automated-logic.html' title='Carrier to acquire Automated Logic (April, 2004)'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113347211020938197</id><published>2005-12-01T16:20:00.000-05:00</published><updated>2006-04-28T19:11:23.003-05:00</updated><title type='text'>VAV system - installation</title><content type='html'>&lt;a href="http://photos1.blogger.com/blogger/3135/760/1600/vav.jpg"&gt;&lt;img style="DISPLAY: block; MARGIN: 0px auto 10px; CURSOR: hand; TEXT-ALIGN: center" alt="" src="http://photos1.blogger.com/blogger/3135/760/400/vav.jpg" border="0" /&gt;&lt;/a&gt;Normally, all the VAV controllers in a project are sent to the VAV supplier. In the factory, an enclosure is mounted on each &lt;strong&gt;&lt;span style="color:#33cc00;"&gt;VAV box&lt;/span&gt;&lt;/strong&gt;. The &lt;strong&gt;&lt;span style="color:#6600cc;"&gt;base&lt;/span&gt;&lt;/strong&gt; of the &lt;span style="color:#000000;"&gt;enclosure&lt;/span&gt; contains a transformer and a controller directly coupled to the damper shaft. As showed in the top picture, I've seen 2 types of enclousure (&lt;strong&gt;&lt;span style="color:#6600cc;"&gt;base&lt;/span&gt;&lt;/strong&gt;+&lt;strong&gt;&lt;span style="color:#cc33cc;"&gt;cover&lt;/span&gt;&lt;/strong&gt;) so far. The left one is with just 1 screw, pretty difficult to put the&lt;strong&gt;&lt;span style="color:#cc33cc;"&gt; cover&lt;/span&gt;&lt;/strong&gt; back. The right one is with 4 screws.&lt;br /&gt;&lt;br /&gt;In order for site people to see the damper position /check the network connection /replace a controller, the &lt;strong&gt;&lt;span style="color:#cc66cc;"&gt;cover&lt;/span&gt;&lt;/strong&gt; of enclosure has to been removed and put back on complishing. A lot of time is wasted without any production. What I suggest is to remove the whole enclosure system and expose the controller, or decrease the size of the inclosure just for the trasformer. Now the design such as the position indicator of the controller is meaningful!.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113347211020938197?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113347211020938197/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113347211020938197' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113347211020938197'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113347211020938197'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/12/vav-system-installation.html' title='VAV system - installation'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113340527456341001</id><published>2005-11-30T21:43:00.000-05:00</published><updated>2005-12-02T00:04:11.790-05:00</updated><title type='text'>Excel 5000 Lon (1)</title><content type='html'>If you use Care5+EBI to do a job, a lot of twist is on the way.&lt;br /&gt;&lt;br /&gt;Firstly, Care5, the engineering tool, has its own Lonworks network mgmt tool, which is not LNS based. On the other hand, EBI, the frontend, is LNS based. Thus, in order for EBI to see all the Honeywell Lon Controllers. All the controllers commisioned by Care5 have to be re-commissioned by LNS.&lt;br /&gt;&lt;br /&gt;And since you don't have the control of the assignment of node ID in LNS, one controller will have different subnet/node IDs in LNS and Care5. Therefore, if you want to modify a controller managed by EBI, you will have to re-re-commission the controller to get back it subnet/node ID in Care5. After the changes, go back to EBI, re-re-re-commission the controller.&lt;br /&gt;&lt;br /&gt;Honeywell realized that this process could be a mess and came up with a tool called &lt;strong&gt;RSS&lt;/strong&gt;. RSS happens to be one of the hotest word on Internet recently. The "hotware" &lt;strong&gt;RSS&lt;/strong&gt; stands for &lt;a href="http://en.wikipedia.org/wiki/RSS_(protocol)"&gt;Really Simple Syndication&lt;/a&gt;, while the Honeywell &lt;strong&gt;RSS&lt;/strong&gt; stands for remote sync server. Don't get confused. Hoeywell RSS will be installed in EBI PC and Care5 acts as the client side software. Briefly, it tries to automate the process of commanding LNS to follow Care5 database. For more information, check the documents come with the software.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113340527456341001?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113340527456341001/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113340527456341001' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113340527456341001'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113340527456341001'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/11/excel-5000-lon-1.html' title='Excel 5000 Lon (1)'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113338289586902296</id><published>2005-11-30T14:15:00.000-05:00</published><updated>2005-12-01T13:33:09.223-05:00</updated><title type='text'>Visualizaion in Building Automation system (2)</title><content type='html'>&lt;strong&gt;For people along the assembly line&lt;/strong&gt;&lt;br /&gt;Visualization exists not only at the final graphical presentation for the operator, but also during the BAS engineering process.&lt;br /&gt;&lt;br /&gt;Big companies tend to  divide one thing into sevral tasks, such as hardware design, software design and graphics design. Each specialist concentrate on his/her own business. And there is little consideration on how to pass the information seamlessly.&lt;br /&gt;&lt;br /&gt;For example, the hardware designer read through all the spec. and mech. drawings to understand the structure of the control system. The graphics designer may have to go through them again to determine the menu system/navigation structure. These is because the hardware design does not consider the graphics when he/she create the control drawing index.&lt;br /&gt;&lt;br /&gt;Another example will be the control sequence. The hardware designer copies or rewrites the control sequence for each unit/plant. But those sequence are not obvious for the software designer to get the idea at first look. He/she has to read through carefully to figure out what the program should be. And normally software designers have a standard software library. It takes quite awhile for him/her to pick the standard module and modify them. Is there a signal system on the hardware drawing to expedite this?&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113338289586902296?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113338289586902296/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113338289586902296' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113338289586902296'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113338289586902296'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/11/visualizaion-in-building-automation_30.html' title='Visualizaion in Building Automation system (2)'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-113330222500657007</id><published>2005-11-29T16:24:00.000-05:00</published><updated>2005-11-30T17:02:07.250-05:00</updated><title type='text'>Visualizaion in Building Automation system (1)</title><content type='html'>&lt;strong&gt;Display of unit modes&lt;/strong&gt;&lt;img hspace="20" src="http://photos1.blogger.com/blogger/3135/760/320/md1.jpg" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;&lt;/p&gt;Normally an air handling unit has multiple operating modes in NA control systems. The basic modes are &lt;em&gt;Occupied&lt;/em&gt; and &lt;em&gt;Unoccupied &lt;/em&gt;based on the unit schedule.&lt;br /&gt;&lt;br /&gt;&lt;p&gt;Then, according to indoor/outdoor thermal conditions, there are&lt;br /&gt;&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Morning Warmup/Cooldown----After &lt;em&gt;Occupied&lt;/em&gt; time to rapidly overcome the temperature/setpoint difference&lt;/li&gt;&lt;li&gt;Optimal Heating/Cooling---Prior to &lt;em&gt;Occupied&lt;/em&gt; time to meet the setpiont at the beginning of the Occupied mode.&lt;/li&gt;&lt;li&gt;Night Cycling/Purge----During Unoccupied period, for space low temperature protection or for free cooling.&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;Obviously, if Optimal Heating/Cooling works properly, Morning Warmup/Cooldown modes will not be activated even they are programmed. Therefore, in most of the cases, a unit will have 5-6 different operating modes.&lt;/p&gt;&lt;p&gt;These modes can be running without the awareness of the operator. However, professionals in charge of the operations may want to know if each mode really works, how frequently each mode happens or what the unit has been through last couple days.&lt;/p&gt;&lt;p&gt;My current thoughts of how to visualize these informations.&lt;/p&gt;&lt;ul&gt;&lt;li&gt;A graphical presentation of what happened last day from 0:00 to 11:59. (Should think about what is the best log structure to support this function.) Each mode is given a different color. The concept is similar to Metasys Time of River.&lt;/li&gt;&lt;li&gt;A report of each mode's active time, maybe with a pie chart. It is easy to give the hours from the very beginnning, but better if this period is selectable. Since I want to see not only if Night Cycle really been activated but also how much running time I can save if I lower the Night Cycel setpoint by 1 degree.&lt;/li&gt;&lt;li&gt;Can I setup something to evaluate the energy saving by night purge (free cooling) vs. power consumption of the fan running?&lt;/li&gt;&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-113330222500657007?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/113330222500657007/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=113330222500657007' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113330222500657007'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/113330222500657007'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/11/visualizaion-in-building-automation.html' title='Visualizaion in Building Automation system (1)'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-110808156649428852</id><published>2005-02-10T19:24:00.000-05:00</published><updated>2005-02-10T19:26:06.496-05:00</updated><title type='text'>About chiller in series</title><content type='html'>1 ON-OFF CONTROL IN THE "OFF" POSITION:&lt;br /&gt;Note:&lt;br /&gt;Water-cooled, ccntrifugal chillers CC-1 and CC-2 shall bc off, as well as chilled water pump P-1A. Associated condenser water system, including cooling towers and condenser pumps P-1 and P-2 shall also be off.&lt;br /&gt;* Sequence of operation is based on two chillers, each sized for 50% of full cooling load with 42 [degrees] chilled water supply and 60 [degrees] chilled water return.&lt;br /&gt;* Sequence of operation does not include discussion of the condenser water control strategy. Refer to previous Back to Basic Tests #75 and #76 for blow-through cooling tower sequence of operation. Refer to previous Back to Basic Tests #73 and #74 for draw-through cooling tower sequence of operation.&lt;br /&gt;2 ON-OFF CONTROL IN THE "ON" POSITION:&lt;br /&gt;Facility operator shall manually start both chillers unit-mounted "on-off" switches at the associated control panels, CP-1 and CP-2. Interlock control signal shall start chilled water pump P-1A. Associated P-2 shall also start while P-1 waits for control signal from chiller CC-1 to start. Chilled water flow switch FS-1 shall confirm (P-1, P-1A, P-2) is delivering sufficient chilled water flow for CC-1 to start its refrigeration cooling process. Chilled water flow switch FS-2 shall confirm (P-1, P-1A, P-2) is delivering sufficient chilled water flow for CC-2 to start its refrigeration cooling process.&lt;br /&gt;Chilled-water supply temperature control transmitter TT-1, set at (51 [degrees]F, 55 [degrees]F, 60 [degrees]F), shall maintain CC-1 supply water temperature setpoint by signaling CC-1 self-contained, refrigeration controls within its control panel (CP-1, P-1, CT-1).&lt;br /&gt;Chilled-water supply temperature control transmitter TT-2, set at (42 [degrees], 45 [degrees], 50 [degrees]), shall maintain CC-2 supply water temperature setpoint by signaling CC-2 self-contained, refrigeration controls within its control panel CP-2.&lt;br /&gt;3 MINIMUM COOLING:&lt;br /&gt;Chiller CC-2 shall provide minimum cooling capacity with TT-2 maintaining 42[degrees] supply water temperature by modulating the centrifugal (pump, tower, compressor). At minimum load (less than 50%), CC-1 refrigeration cycle shall remain off as chilled water return temperature shall be (42[degrees], 51[degrees], 60[degrees]) or colder. As chilled water demand increase, CC-2 compressor shall continue to produce 42[degrees] chilled water supply up to the full capacity of CC-2 (50% of system capacity).&lt;br /&gt;4 MAXIMUM COOLING:&lt;br /&gt;As the demand for more cooling capacity increases and chilled water return temperature increases above 51[degrees], chiller CC-1 refrigeration cycle shall start. Associated P-1 shall start based on control panel CP-l signal to start CC-1 refrigeration cycle.&lt;br /&gt;Maximum cooling capacity shall be provided by CC-1 and CC-2 in (demand, parallel, series) operation. Temperature transmitter TT-1 shall maintain 51[degrees] chilled water supply leaving CC-1 by modulating its associated centrifugal compressor towards (100%, 50%) capacity. Temperature transmitter TT-2 shall further cool the chilled water supply down to 42 chilled water supply leaving CC-2 by modulating its associated centrifugal compressor towards 100% capacity. In turn, and as demand is reduced, CC-1 and CC-2 compressors shall unload in series while continuing to produce primary 42[degrees] chilled water supply.&lt;br /&gt;ANSWERS FOR CHILLERS IN SERIES WITH CC-2 AS LEAD BASIC SYSTEM -- DESIGN TEST: 2) P-1A; P-1A; 51[degrees]; CP-1; 42[degrees];:3) compressor 51[degrees];4) 100%.&lt;em&gt;Just C&amp;amp;P from web, need to look into it.&lt;/em&gt;&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-110808156649428852?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/110808156649428852/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=110808156649428852' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/110808156649428852'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/110808156649428852'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/02/about-chiller-in-series.html' title='About chiller in series'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-10055334.post-110533110120587538</id><published>2005-01-09T23:20:00.000-05:00</published><updated>2005-12-04T13:27:19.516-05:00</updated><title type='text'>The Nigerian Scam</title><content type='html'>This is one of the spam email I received, which is one variation of the famous &lt;strong&gt;Nigerian Scam&lt;/strong&gt;. Take a look and be aware of this kind of trap.&lt;br /&gt;$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$?&lt;br /&gt;Dear Friend,&lt;br /&gt;&lt;br /&gt;I guess this letter may come to you as a surprise since I had no previous correspondence with you.&lt;br /&gt;&lt;br /&gt;I the chairman tender board of Independent National Electoral Commission (INEC).I got your contact in my search for a reliable person to handle a very confidential transaction involving the transfer of&lt;br /&gt;US$20.5million.&lt;br /&gt;&lt;br /&gt;The above fund is not connected with arms, drugs or Money laundering.It is the product of an over invoiced Contract awarded in 2001 by INEC to a foreign company for the construction of high rise estate in the federal capital territory.&lt;br /&gt;&lt;br /&gt;The contract has long been executed and payment of the actual contract amount has been paid to the foreign contractor leaving the balance,which my colleague and I now want to transfer out of Nigeria into a reliable foreign account for our personal use.&lt;br /&gt;&lt;br /&gt;As civil servants we are not allowed to run foreign accounts. Hence we have chosen to front and support you as the beneficiary to be paid.If you are interested in the proposal kindly get back to me by sending me your letter of acceptance along with your direct telephone and fax numbers, we have decided to share the money in the following percentage,60%for us 30% for you the account owner and 10% for all local and international expenses that may arise in the course of this transaction.&lt;br /&gt;&lt;br /&gt;Further details about this transaction will be discussed in the subsequent correspondence. Note also that the particular nature of your business is irrelevant to this transaction and all local contacts and arrangements are in place for a smooth and successful conclusion of this transaction.&lt;br /&gt;&lt;br /&gt;Be informed that we are aware of the way email proposals of this type are being sent from this part of africa and as regards that,you should please treat this with utmost attention knowing fully well that you cannot and will not be compelled to assist us if you are not disposed to.&lt;br /&gt;&lt;br /&gt;Contact me via my email account with your contact telephone and fax Numbers, so that I can call you for a discussion.Confirm your capability in this transaction.&lt;br /&gt;&lt;br /&gt;Thank you as I await your response.&lt;br /&gt;&lt;br /&gt;Sincerely,&lt;br /&gt;Kola Badmus Mohammed.&lt;br /&gt;____Mail sent from WebMail service at PHP-Nuke Powered Site&lt;br /&gt;- &lt;a href="http://yoursite.com/"&gt;http://yoursite.com/&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10055334-110533110120587538?l=leaflying.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://leaflying.blogspot.com/feeds/110533110120587538/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=10055334&amp;postID=110533110120587538' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/110533110120587538'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/10055334/posts/default/110533110120587538'/><link rel='alternate' type='text/html' href='http://leaflying.blogspot.com/2005/01/nigerian-scam.html' title='The Nigerian Scam'/><author><name>Leaflying</name><uri>http://www.blogger.com/profile/18284607301642444283</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry></feed>
