Herramienta de Análisis y Diseño de Sistemas de Control Basada en Hojas de Cálculo Excel

  1. Aliane, Nourdine
Journal:
Revista iberoamericana de automática e informática industrial ( RIAI )

ISSN: 1697-7920

Year of publication: 2009

Volume: 6

Issue: 4

Pages: 44-50

Type: Article

DOI: 10.1016/S1697-7912(09)70107-4 DIALNET GOOGLE SCHOLAR lock_openOpen access editor

More publications in: Revista iberoamericana de automática e informática industrial ( RIAI )

Abstract

This paper presents a toolbox for control systems analysis and design using Excel spreadsheets. The toolbox is a set of routines and function written in VBA macro programming language. At present, the toolbox is limited to linear systems represented by transfer functions. The user can specify a model, plot its time or frequency responses, perform a feedback, and tune interactively the controller parameters. The tool is intended to offer good level of productivity maintaining multiple simulations in a unique worksheet, and allows users to switch easily from one simulation to another. It is also intended to be highly interactive, where the user can perform “what-if” experiments in a straightforward manner by changing the parameters values and immediately see how these changes influence the system behavior. To illustrate the scope and the principal features of this tool, several examples are provided.

Bibliographic References

  • Chehab, A., y A. El-Hajj, (2004). Spreadsheet Applications in Electrical Engineering: A Review, Int. J. of Eng. Educ., 20(6), 902-908.
  • Aliane, N. (2008), Spreadsheet-Based Control-System Analysis and Design, IEEE Control System Magazine, 28(5), 108- 113
  • Craig T. C., (2006). Engineering with the Spreadsheet: Structural Engineering Templates Using Excel, American Society of Civil Engineers -ASCE Press.
  • David, M. B., (2006). Excel Scientific and Engineering Cookbook, 1st edition, O´Reilly.
  • Dormido, S., (2005). The Role of Interactivity in Control Learning, Int. J. of Eng. Educ., 21(6), 1122-1133.
  • El-Hadj, A., K. Y. Kabalan y S. Khoury, (2000). A Linear Control System Simulation Toolbox Using Spreadsheets. IEEE Control Systems Magazine, 20(6), 8-14.
  • El-Hadj, A., S. Karaki And K. Kabalan, (2002). Graphical Simulation of an Analogue Computer Using Spreadsheets, Int. J. of Eng. Educ., 18(6), 704-710.
  • El-Hadj, A., S. Karaki y K. Y. Kabalan, (2003). Digital Control Systems Simulation Using Spreadsheets. Journal of Computer Applic. in Eng. Educ., 11(1), 6-12.
  • El-Hadj, A., S. Karaki y Y. K. Karim, (2001). A Nonlinear Control System Simulation Toolbox Using Spreadsheets. Proc. of International Conference on Modelling and Simulation, Pittsburgh, U.S.A, 83-87.
  • Ferreira E. F, R. Lima & R. Salcedo, (2004). Spreadsheets in Chemical Engineering Education: Tool in Process Design and Process Integration, Int. J. of Eng. Educ., 20(6), 928- 938.
  • Foster K. R, (1998). Software tools: Technology 1998 analysis and forecast, IEEE Spectrum, 35(1), 52-66,
  • Gottfried, B.S., (2005). Spreadsheet Tools for Engineers using Excel, 3rd edition, McGraw-Hill.
  • Guzmán J. L., K. J. Åström, S. Dormido, T. Hägglund, y Y. Piguet, (2008). Interactive learning modules for PID control, IEEE Control System Magazine, 28(5), pp. 118- 134.
  • Johansson, M., Gäfvert, M., Åström, K. J, (1998). Interactive Tools for Education in Automatic Control, IEEE Control Systems Magazine, 18(3), pp. 33-40.
  • Levie, R., (2001). How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis, University Press, Cambridge.
  • Oke, S. A., (2004). Spreadsheet Applications in Engineering Education: A Review, Int. J. of Eng. Educ., 20(6), 893–901.
  • Rives C. y Lacks D. J., (2002). Teaching process control with a numerical approach based on spreadsheets, Chemical Eng. Educ., 36(3), 242-248.
  • Schumack, M, (2004). Use of a Spreadsheet Package to Demonstrate Fundamentals of Computational Fluid Dynamics and Heat Transfer”, Int. J. of Eng. Educ., 20(6), 974–983.
  • Silva, A. A., (1994). Simulating electrical circuits with an electronic spreadsheet, Computers and Education, 22(4), 345-353.
  • Webb, J. and S. Saunders, (2006). Programming Excel with VBA and .NET, O´Reilly.
  • Wittenmark, B., B. Häglund y H, M. Johansson, (1998). Dynamic Pictures and Interactive Learning, IEEE Control Systems Magazine, 18(3), 26-32.
  • Xu W., Y. Liu, D. Koval, y M. A. Lipsett, (1999). Using Spreadsheet Software as a Platform for Power System Analysis, IEEE Computer Applications in Power, 12(4), 41- 45.
Data source: Dialnet