Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top
Published in:
TExtractor: An OSINT Tool to Extract and Analyse Audio/Video Content Read chapter Read first chapter

2019 | OriginalPaper | Chapter

Decentralized Adaptive Suboptimal LQ Control in Microsoft Excel VBA

Author : Karel Perutka

Published in: Innovation, Engineering and Entrepreneurship

Publisher: Springer International Publishing

Log in

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

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.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

inform now

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

inform now
previous chapter CHP Production Optimization Based on Receding Horizon Strategy
next chapter Formal Verification: Focused on the Verification Using a Plant Model
Literature
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)
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)
3.
Åström, K.J., Wittenmark, B.: Adaptive Control. Addison-Wesley, MA (1989)
4.
Bobál, V., Böhm, J., Prokop, R., Fessl, J.: Practical Aspects of Self-Tuning Controllers: Algorithms and Implementation. VUTIUM Press, Brno University of Technology, Brno (1999)MATH
5.
Al-Ghossini, H., Locment, F., Sechilariu, M., Gagneur, L., Forgez, C.: Adaptive-tuning of extended Kalman filter used for small scale wind generator control. Renew. Energy 85, 1237–1245 (2016)CrossRef
6.
Zhaoa, B., Lib, Y., Liuc, D.: Self-tuned local feedback gain based decentralized fault tolerant control for a class of large-scale nonlinear systems. Neurocomputing 235, 147–156 (2017)CrossRef
7.
Vasanthi, D., Pranavamoorthy, B., Pappa, N.: Design of a self-tuning regulator for temperature control of a polymerization reactor. ISA Trans. 51, 22–29 (2012)CrossRef
8.
Zaky, M.S.: A self-tuning PI controller for the speed control of electrical motor drives. Electr. Power Syst. Res. 119, 293–303 (2015)CrossRef
9.
Mendes, J., Osório, L., Araújo, R.: Self-tuning PID controllers in pursuit of plug and play capacity. Control Eng. Pract. 69, 73–84 (2017)CrossRef
10.
Ashida, Y., Wakitani, S., Yamamoto, T.: Design of an implicit self-tuning PID controller based on the generalized output. IFAC PapersOnLine (50-1), pp. 13946–13951 (2018)CrossRef
11.
Zillettia, M., Elliott, S.J., Gardonio, P.: Self-tuning control systems of decentralised velocity feedback. J. Sound Vib. 329, 2738–2750 (2010)CrossRef
12.
Bobál, V., Perutka, K., Dostál, P.: Decentralized adaptive continuous-time control of coupled drives apparatus. In: Proceedings of the IFAC Workshop on Adaptation and Learning in Control and Signal Processing, pp. 57–62. Cernobbio-Como, Italy (2001)CrossRef
13.
Beijen, M.A., Heertjes, M.F., Van Dijk, J., Hakvoort, W.B.J.: Self-tuning MIMO disturbance feedforward control for active hard-mounted vibration isolators. Control Eng. Pract. 72, 90–103 (2018)CrossRef
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)
15.
Nourdine, A.: Data acquisition and real-time control using spreadsheets: Interfacing Excel with external hardware. ISA Trans. 49, 264–269 (2010)CrossRef
Metadata
Title
Decentralized Adaptive Suboptimal LQ Control in Microsoft Excel VBA
Author
Karel Perutka
Copyright Year
2019
Book
Innovation, Engineering and Entrepreneurship

Print ISBN: 978-3-319-91333-9

Electronic ISBN: 978-3-319-91334-6

Copyright Year: 2019

DOI
https://doi.org/10.1007/978-3-319-91334-6_17

Premium Partner

    Image Credits