2008
DOI: 10.1002/9780470387207
|View full text |Cite
|
Sign up to set email alerts
|

Modeling for Insight

Abstract: It is widely recognized that spreadsheets are error-filled, their creators are overconfident, and the process by which they are developed is chaotic. It is less wellunderstood that spreadsheet users generally lack the skills needed to derive practical insights from their models. Modeling for insight requires skills in establishing a base case, performing sensitivity analysis, using back-solving, and (when necessary) carrying out optimization and simulation. Some of these tasks are made possible only with speci… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
1
1
1
1

Citation Types

0
5
0

Year Published

2020
2020
2023
2023

Publication Types

Select...
7

Relationship

0
7

Authors

Journals

citations
Cited by 20 publications
(5 citation statements)
references
References 21 publications
0
5
0
Order By: Relevance
“…Considering the fact that optimization depends not only on efficient and robust algorithms but also on good modeling techniques, careful interpretation of results and user-friendly software [18], we followed acknowledged principles of spreadsheet modeling and post-solution analysis [19,35,38,39,41]. This corresponds to a continuous effort for improving the conceptualization and formulation of the model, and using the model as a tool for gaining real insights into the problem.…”
Section: Discussion and Concluding Remarksmentioning
confidence: 99%
See 1 more Smart Citation
“…Considering the fact that optimization depends not only on efficient and robust algorithms but also on good modeling techniques, careful interpretation of results and user-friendly software [18], we followed acknowledged principles of spreadsheet modeling and post-solution analysis [19,35,38,39,41]. This corresponds to a continuous effort for improving the conceptualization and formulation of the model, and using the model as a tool for gaining real insights into the problem.…”
Section: Discussion and Concluding Remarksmentioning
confidence: 99%
“…In addition to the optimal solution obtained, the decision maker may also gain valuable insights into the initial problem and diverse instances thereof. Generally, spreadsheet modeling offers unique possibilities for extracting useful business information and creating valuable documentation, but requires well-informed programmers who would not miss such opportunities [38]. In this model, the decision-maker is able to see whether the constraints expressed as binding (i.e., hold as equalities) or nonbinding (i.e., not met exactly) inequalities and thus identify which of the potential limitations become actual limitations.…”
Section: Sensitivity Analysismentioning
confidence: 99%
“…Following steps of [16], in particular, this study chooses the GRG Non-Linear method as an estimation method. According to [17], the existing values in the worksheet cells for each decision variable are taken as an initial solution such that any small change will improve the objective value. In this way, the objective value will increase if the objective is maximization, or decrease if the objective is minimized until it achieves optimal solution.…”
Section: Estimation and Selection A Parameter Estimationmentioning
confidence: 99%
“…where q i,d is the visual quality of the listed apartment, qi,d,v is the model's measure of the apartment's descriptive quality in the ordinal form and A i,d,v is the test parameter checking, whether the descriptive quality matches the visual quality of the apartment. The following (4) The optimization procedure has been conducted with the use of an evolutionary algorithm (Powell & Batt, 2008). Figure 4 presents the visualisation of the calibration phase procedure.…”
Section: Models' Calibration Phasementioning
confidence: 99%