San Antonio, Texas
June 10, 2012
June 10, 2012
June 13, 2012
25.670.1 - 25.670.19
Glazing Made Simple: A Decision Support System Tool Using MS Excel VBAIn architecture, glazing is the most sought-after technique when it comes to facade, whether it iscommercial, governmental or even residential buildings. A welcome change from the mostly dullbrick and mortar structures, these glass facades have brought in a near revolution in constructionand architecture in recent times due to their aesthetic appeal and higher natural light allowance.Glass manufacturers have capitalized on this trend –with the help of modern technologies – byoffering wide ranges of glasses with different arrays of colors, thermal allowances, and otherphysical properties.Larsen & Toubro (L&T) –being the largest construction company in India – realizes theimportance of being able to offer the best glazing systems to its huge national and internationalcustomers.As part of a NSF International Research Experiences for Students (IRES) project a team ofgraduate and undergraduate students at a major U.S. university worked with L&T’s designengineers at the Center for Excellence and Futuristic Design (CEFD) in conducting all thenecessary calculations to determine the cooling loads for each of the glass-frame-shadingcombinations. The goal was to tabulate all the necessary calculations into an Excel spread sheetand then develop a simple interface –using Visual Basic for Applications (VBA) – for L&T’sarchitects. The program accesses a hidden database that allows the architects to simply selecttheir desired values for the glass type sub-criteria, frame type, and shading type, and then make adecision about which combination is ideal for their particular design. The decision is based notjust on aesthetics, but energy performance as well as some financial metrics such as additionalinvestment and payback period. This results in a simplified decision-making tool withinstantaneous consequence comparisons.Through developing this interface, the project team learned the following: • The culture and dynamics of working at an international company. • Interacting and working with students from Indian Universities. • Different aspects and properties of glass and their impact on the heating/cooling loading of a building. • How to use data mining techniques to turn large data sets into a simple user interface.
Mohamed, A., & Reynolds, E., & Sankar, C. S., & Raju, P., & B.S., N. K. (2012, June), Glazing Made Simple: A Decision Support System Tool Using MS Excel VBA Paper presented at 2012 ASEE Annual Conference & Exposition, San Antonio, Texas. https://peer.asee.org/21427
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2012 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015