Decentralized Adaptive Suboptimal LQ Control in Microsoft Excel VBA
- 1.3k Downloads
Suboptimal linear quadratic (LQ) control has been popular very much because of its very good results in several tasks of control. It allows us to implement it on many systems even on unstable systems which it stabilizes. Adaptation enlarges the area of the usage especially in the case when standard controllers with fixed parameters gives unsatisfactory results. In this paper, the main attention is dedicated to the usage of the modified instrumental variable technique as the identification part of the self-tuning controllers, and to the implementation in Microsoft Excel. So this approach was verified by simulation in Microsoft Excel Visual Basic for Applications (VBA) on two input two output (TITO) systems.
KeywordsAdaptive control Instrumental variable Linear quadratic control Microsoft Excel VBA Self-tuning control Suboptimal control
- 1.Dostál, P., Bobál, V.: The suboptimal tracking problem in linear systems. In: Proceedings of the 7th Conference on Control and Automation, pp. 667–673. Haifa, Israel (1999)Google Scholar
- 2.Perutka, K.: Method of setting penalization constants in suboptimal linear quadratic tracking method. In: Proceedings of the 26th ASR 2001 Seminar on Instruments and Control. Ostrava, Czech Republic (2001)Google Scholar
- 3.Åström, K.J., Wittenmark, B.: Adaptive Control. Addison-Wesley, MA (1989)Google Scholar
- 14.Mensler, M.: Analyse et étude comparative de méthodes d´identification des systèmes à representation continue: Dévelopmnet d´une boîte à outils logicielle. CRAN, Nancy, France (1999)Google Scholar