ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Rational Addiction
2
Humberto Barreto
3
DePauw University
4
5
This Excel workbook explains key ideas in the model of rational addiction.
6
It uses Excel's Solver to find an optimal solution and makes clear how the model works.
7
8
Software Requirements:
9
You need Microsoft Excel, Windows version 2007 or greater to get full functionality from this file.
10
The file can be opened with Mac Excel, but it uses Visual Basic code that may not be fully supported on a Mac.
11
12
You must be sure to Enable Content or the buttons and code in this macro-enabled workbook will not work. -->
13
Search "enable macros" in Excel's Help for more information on how to do this.
14
15
As you read and scroll down a sheet, the workbook will unfold, displaying new sheets, and I will ask you to click buttons and change things.
16
You are free to take notes on the sheets or change cells as you desire.
17
You can modify charts or create new ones -- there is nothing special about this workbook, nothing is password protected or otherwise blocked.
18
You cannot really hurt anything -- if something does break, just close the workbook and re-open it. You can also Save As if you want to be extra careful and have an original copy available.
19
If you know Visual Basic, go ahead and look at the code. It is freely available for you to inspect and alter as you wish.
20
If you are reading this on your own, check out the Conversation sheet; otherwise your professor
21
22
I welcome all feedback, positive and negative. Drop me an email and let me know what you think or if you have any questions or suggestions.
23
I really hope this helps.
24
Enjoy!
25
Humberto Barreto
26
hbarreto@depauw.edu
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100