Skip to main content

Decentralized Adaptive Suboptimal LQ Control in Microsoft Excel VBA

  • Conference paper
  • First Online:
Innovation, Engineering and Entrepreneurship (HELIX 2018)

Part of the book series: Lecture Notes in Electrical Engineering ((LNEE,volume 505))

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 259.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 329.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  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 

  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  Google Scholar 

  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)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  11. Zillettia, M., Elliott, S.J., Gardonio, P.: Self-tuning control systems of decentralised velocity feedback. J. Sound Vib. 329, 2738–2750 (2010)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  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)

    Article  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 

  15. Nourdine, A.: Data acquisition and real-time control using spreadsheets: Interfacing Excel with external hardware. ISA Trans. 49, 264–269 (2010)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Karel Perutka .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Perutka, K. (2019). Decentralized Adaptive Suboptimal LQ Control in Microsoft Excel VBA. In: Machado, J., Soares, F., Veiga, G. (eds) Innovation, Engineering and Entrepreneurship. HELIX 2018. Lecture Notes in Electrical Engineering, vol 505. Springer, Cham. https://doi.org/10.1007/978-3-319-91334-6_17

Download citation

Publish with us

Policies and ethics