Abstract
With the increasing use of information technology and availability of high-quality data, business organizations have a greater need for analyzing data and using this analysis to guide their decisions. An information system based on decision models is called a decision support system (DSS). A DSS uses the data residing in spreadsheets and/or databases, models it, processes or analyzes it using problem-specific methodologies, and assists the user in the decision-making process through a graphical user interface. In this chapter, we discuss the usefulness and capabilities of spreadsheet software for developing a DSS. Spreadsheets are a great option for developing many DSS applications since they are available with almost any operational system and have many features that are relatively easy to learn and can be implemented for a large variety of problems.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Ahuja, R.K. and (Şeref) Hanna, M. “Decision Support Systems Development: An Essential Part of OR Education”. Oper Res Letts, 31, 2004.
Albright, S. VBA for Modelers. Belmont, CA: Duxbury, 2001.
Chan, Y.E. and V.C. Storey. “The use of spreadsheets in organizations: Determinants and consequences.” Inform Manage, 31, 1996.
Cragg, P. and King, M. “Spreadsheet Modeling Abuse: An Opportunity for OR?” J Oper Res Soc, 44, 8, 1993.
Gass, S.I., D.S. Hirshfeld and E.A. Wasil. “Model world: The spreadsheeting of OR/MS.” Interfaces, 30, 2000.
Geoffrion, A.M. and R. Krishnan. “Prospects for operations research in the e-business era.” Interfaces, 31, 2001.
Panko, R. Spreadsheet Research, 2006. URL http://panko.cba.hawaii.edu/ssr/ Welcome.htm.
Pol, A. and Ahuja, R.K. “Developing Web-Enabled Decision Support Systems”, Belmont, MA: Dynamic Ideas, 2007.
Power, D. DSS Resources, 2006. URL = http://www.dssresources.com.
Power, D. Decision Support Systems: Concepts and Resources for Managers, Quorum , 2002.
Power, D.J. and R. Sharda, “Model-Driven DSS: Concepts and Research Directions”, Decis Support Syst, special issue on Integrated Decision Support, 43(3), 2007, 1044-1061.
Ragsdale, C.T. Spreadsheet Modeling and Decision Analysis, Third Edition. San Diego: South-Western College Publishing, 2000.
Ragsdale, C.T. “Teaching management science with spreadsheets: From decision models to decision support.” INFORMS Trans Ed, 1, 2, 2001.
Þeref, M.H., Ahuja, R.K. and Winston, W.L., Developing Spreadsheet-Based Decision Support Systems (Using Excel and VBA for Excel), Belmont, MA: Dynamic Ideas, 2007.
Turban, E. and Aronson, J. E. Decision Support Systems and Intelligent Systems, New York: Prentice-Hall, 2001.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Şeref, M., Ahuja, R. (2008). Spreadsheet-Based Decision Support Systems. In: Handbook on Decision Support Systems 1. International Handbooks Information System. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-48713-5_14
Download citation
DOI: https://doi.org/10.1007/978-3-540-48713-5_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-48712-8
Online ISBN: 978-3-540-48713-5
eBook Packages: Computer ScienceComputer Science (R0)