Book contents
- Frontmatter
- Contents
- SECTION 1 GETTING ORIENTED
- 1 Necessary Foundations for Decision Support
- 2 The Development Environment
- 3 Getting Data – Acquisition, Linkage, and Generation
- SECTION 2 HARVESTING INTELLIGENCE
- SECTION 3 LEVERAGING DYNAMIC ANALYSIS
- SECTION 4 ADVANCED AUTOMATION AND INTERFACING
- Glossary of Key Terms
- Appendix – Shortcut (Hot Key) Reference
- Index
2 - The Development Environment
from SECTION 1 - GETTING ORIENTED
Published online by Cambridge University Press: 06 July 2010
- Frontmatter
- Contents
- SECTION 1 GETTING ORIENTED
- 1 Necessary Foundations for Decision Support
- 2 The Development Environment
- 3 Getting Data – Acquisition, Linkage, and Generation
- SECTION 2 HARVESTING INTELLIGENCE
- SECTION 3 LEVERAGING DYNAMIC ANALYSIS
- SECTION 4 ADVANCED AUTOMATION AND INTERFACING
- Glossary of Key Terms
- Appendix – Shortcut (Hot Key) Reference
- Index
Summary
This discussion of decision support design starts by jumping into the basics of the Excel development environment. Figure 2.1 provides an annotated view of what people typically see when opening up a new file in Excel. Only a few key elements of this interface are central to our early discussion.
Excel files are called workbooks. They contain any number of worksheets (i.e., spreadsheets) that can be used in tandem. Ninety-five percent of the time, Excel has been relegated to storing information, largely by those who don't know what else Excel can do. Not that storing info in Excel is bad, but there are often better alternatives available for storage, such as databases in the case of very large sets of data. Functionally the storage capability of Excel represents only the bare tip of this technological iceberg.
Regardless, knowing how the cell structure in the spreadsheet works is a good place to start and is essential to our future discussion.
Cells in spreadsheets can contain:
Fixed data: Data you've entered, numerical or otherwise.
Formatting: Background color, border thickness, font type, and so on.
Labels: References other than the standard ColumnRow reference.
Comments: Notes regarding the contents.
Formulae: Can be mathematical/statistical, text based, or a range of other types such as logic based or search oriented.
Live data links: Data that are drawn from an externally linked source, such as a database or the Internet.
Fixed data
Data entry in Excel is about as basic as it gets – just click and type.
- Type
- Chapter
- Information
- Excel Basics to BlackbeltAn Accelerated Guide to Decision Support Designs, pp. 8 - 33Publisher: Cambridge University PressPrint publication year: 2008