Control systems demonstrations using spreadsheets

  1. Nourdine Aliane 1
  1. 1 Universidad Europea de Madrid
    info

    Universidad Europea de Madrid

    Madrid, España

    ROR https://ror.org/04dp46240

Journal:
World Transactions on Engineering and Technology Education

ISSN: 1446-2257

Year of publication: 2007

Volume: 6

Pages: 349-352

Type: Article

GOOGLE SCHOLAR lock_openOpen access editor

More publications in: World Transactions on Engineering and Technology Education

Abstract

In this article, the author illustrates the use of Excel spreadsheets as a tool for constructing computer demonstrations incontrol systems simulation. To show some of these functionalities, two examples are included. The first one shows a simulation of acontinuous-time system, whereas the second demonstrates the simulation of a digital control system. Both simulations are wrappedwithin simple interfaces to provide interactivity and make them valuable for teaching. The examples are not comprehensive sincethey do not fully exploit all of the features of Excel. They were chosen only because they are straightforward and self-containedillustrations of how an Excel spreadsheet can be used to create simple interactive simulations.

Bibliographic References

  • 1. Gottfried, B.S., Spreadsheet Tools for Engineers Using Excel (3rd edn). New York: McGraw-Hill (2005).
  • 2. Bourg, D.M., Excel Scientific and Engineering Cookbook. Sebastopol: O´Reilly Media (2006).
  • 3. Webb, J. and Saunders, S., Programming Excel with VBA and .NET. Sebastopol: O´Reilly Media (2006).
  • 4. Chehab, A. and El-Hajj, A., Spreadsheet applications in electrical engineering: a review. Inter. J. of Engng. Educ., 20, 6, 902-908 (2004).
  • 5. Oke, S.A., Spreadsheet applications in engineering education: a review. Inter. J. of Eng. Educ., 20, 6, 893-901 (2004).
  • 6. Schumack, M., Use of a spreadsheet package to demonstrate fundamentals of computational fluid dynamics and heat transfer. Inter. J. of Engng. Educ., 20, 6, 974-983 (2004).
  • 7. Hanania, T.S. and Levin, I., Spreadsheet-based logic controller for teaching fundamentals of requirements engineering. Inter. J. of Engng. Educ., 20, 6, 939-948 (2004).
  • 8. El-Hajj, A., Kabalan, K.Y. and Khoury, S., A linear control system simulation toolbox using spreadsheets. IEEE Control Systems Magazine, 20, 6, 8-14 (2000).
  • 9. El-Hajj, A., Karaki, S. and Kabalan, K., Graphical simulation of an analogue computer using spreadsheets. Inter. J. of Engng. Educ., 18, 6, 704-710 (2002).
  • 10. El-Hajj, A., Karaki, S. and Kabalan, K.Y., Digital control systems simulation using spreadsheets. J. of Computer Applications in Engng. Educ., 11, 1, 6-12 (2003).
  • 11. El-Hajj, A., Karaki, S. and Karim, Y.K., A nonlinear control system simulation toolbox using spreadsheets. Proc. Inter. Conf. on Modelling and Simulation, Pittsburgh, USA, 83-87 (2001).
  • 12. Press, W.H., Flannery, B.P., Teukolsky S.A. and Vetterling, W.T., Numerical Recipes in C: the Art of Scientific Computing (2nd edn). Cambridge: Cambridge University Press (1992).
  • 13. Åström, K.J. and Wittenmark, B., Computer Controlled Systems (3rd edn). New York: Prentice Hall (1997).
  • 14. Levie, R., Spreadsheet simulation of chemical kinetics. Critical Reviews in Analytical Chemistry, 32, 1, 97-107 (2002).