Skip to main content

Introduction to Spreadsheet Modeling and Metaheuristics

  • Chapter
  • First Online:
Metaheuristics for Business Analytics

Abstract

Models, as a simplified representation of reality, are used daily in an attempt to control or understand some aspects of a real system. Simplification of reality is the accepted view of the modeling process, which assumes that reality represents the absolute truth. Without getting too deep into a philosophical discourse, it is worth mentioning the notion of model-dependent realism, a phrase coined by physicists Stephen Hawkings and Leonard Molinow in their book The Grand Design. Model-dependent realism “is based on the idea that our brains interpret the input from our sensory organs by making a model of the world to aid in the decision-making process.” This implies that more than one model of a real system can be built and that we are free to use whatever model is more convenient as long as it has the same accuracy as other alternative models. It also implies that there is no theory-independent concept of reality. Therefore, “according to model-dependent realism, it is pointless to ask whether a model is real, only whether it agrees with observation.”

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 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 84.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

Notes

  1. 1.

    EuSpRIG Horror Stories can be found at http://www.eusprig.org/horror-stories.htm.

  2. 2.

    VaR (Value at Risk) is a popular measure of the risk of loss on a specific portfolio of financial assets.

  3. 3.

    This section has been adapted from Sect. 1.1 of the 1997 Tabu Search book by Glover and Laguna.

References

  1. Evans, J.R. 2013. Business analytics. London: Pearson.

    Google Scholar 

  2. Glover, F. 1986. Future paths for integer programming and links to artificial intelligence. Computers and Operations Research 13:533–549.

    Google Scholar 

  3. Glover, F., and M. Laguna. 1997. Tabu search. Berlin: Springer.

    Google Scholar 

  4. Grossman, T.A. 2002. Spreadsheet engineering: A research framework. In Proceedings of the European spreadsheet risks interest group symposium. Cardiff, Wales.

    Google Scholar 

  5. Grossman, T.A. 2006. Integrating spreadsheet engineering in a management science course: A hierarchical approach. INFORMS Transactions on Education 7(1): 18–36.

    Google Scholar 

  6. Powell, S.G., and K.R. Baker. 2004. The art of modeling with spreadsheets: Management science, spreadsheet engineering, and modeling craft. New York: Wiley, Inc.

    Google Scholar 

  7. Ragsdale, Cliff T. 2014. Spreadsheet modeling and decision analysis: A practical introduction to business analytics, 7th ed. Boston: Cengage Learning.

    Google Scholar 

  8. Reid, R.D., and N.R. Sanders. 2012. Operations management, 5th edn. New York: Wiley.

    Google Scholar 

  9. Sörensen, K. 2013. Metaheuristics the metaphor exposed. International Transactions in Operational Research 22: 3–18.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Rafael Martí .

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Duarte, A., Laguna, M., Martí, R. (2018). Introduction to Spreadsheet Modeling and Metaheuristics. In: Metaheuristics for Business Analytics. EURO Advanced Tutorials on Operational Research. Springer, Cham. https://doi.org/10.1007/978-3-319-68119-1_1

Download citation

Publish with us

Policies and ethics