Outline

• Overview of page
• Supporting spreadsheets for text of printed paper
• Student instruction sheets
• Supplementary examples

Overview

All of the spreadsheets have been annotated using the "comment" tool.  Cells with comments have a red triangle in the top right corner.  Moving the mouse over the cell will display the comment.  The comments have been written to explain the setup of the spreadsheets, highlight important features, give special instructions, or provide tips.   In addition to comments, some of the spreadsheets contain an outline that describes how to complete functions referred to in the paper.  For example, the spreadsheet for Figure 15 contains instructions on how to use the Iteration option and the Solver.  In such cases, the outline appears below the part of the spreadsheet that appears as a figure in the text.

All spreadsheets are in Microsoft Excel 97 format, and all text is in Rich Text Format (*.rtf), which can be recognized by a variety of word processors.  It is recommended that you follow your browser's directions to configure your browser to automatically open the Excel files with your Excel 97 (or later) spreadsheet program, and the text files with your word processor.  That is, after clicking on a link, you will likely be prompted with a window giving you several options.  One of the options should be "Pick Application", "Pick App", or something similar.  Click on this option and follow instructions.  You will only have to go through this procedure once.  It will allow you to view the text files and spreadsheet files in separate windows by clicking on them, and eliminates the need to save the files to your local drive first.

Back to top
 

Supporting spreadsheets for text of paper

• Section 2:  Utility Functions
• Spreadsheet for Figures 3, 6, 7
• Section 3:  Substitution Bias in the Consumer Price Index
• Spreadsheet for Figure 8
• Section 4:  Hicksian Decomposition and Consumer Surplus
• Spreadsheet for Figure 10
• Instructions for Creating Figure 11 (in Rich Text Format)
• Spreadsheets for Figures 11, 12
• Spreadsheet for Figure 14
• Section 5:  Optimal Aggregate Consumption and Saving
• Spreadsheet for Figures 15, 17

-  includes spreadsheet for Figure 15, instructions on use of  Iteration option and Solver tool, and Figure 17

 Student instruction sheets

• Section 2:  Utility Functions
• Student instruction sheet (in Rich Text Format)
• Section 3:  Substitution Bias in the Consumer Price Index
• Student instruction sheet (in Rich Text Format)
• Section 4:  Hicksian Decomposition and Consumer Surplus
• Student instruction sheet (in Rich Text Format)
• Section 5:  Optimal Aggregate Consumption and Saving
• Student instruction sheet (in Rich Text Format)

Supplementary Examples

• Supplement 1:  Calculating the Chain Weight Index
• Write-up of model (in Rich Text Format)
• Spreadsheet for Figure S1.1
• Supplement 2:  Limit Pricing Model and Critique
• Write-up of model (in Rich Text Format)
• Spreadsheet for Figure S2.1
• Supplement 3:  General Solow Growth Model
• Write-up of model (in Rich Text Format)
• Spreadsheet for Figure S3.1:  A Dynamic Solow Growth Model
• Spreadsheet for Figure S3.2:  Comparative Static Example
• Supplement 4:  IS-LM / AS-AD Model
• Write-up of model (in Rich Text Format)
• Spreadsheets for Figures S4.1-S4.6
• Supplement 5:  Multiplant Cost Minimization
• Write-up of model (in Rich Text Format)
• Spreadsheet for Figure S5.1

Back to top