Modeling: Numerous books about Excel and about economic simulation models are available. You can begin a search for information with the following Internet/library sources:
Frontline Systems Inc. This firm developed the Excel solver. Their home page is a good source of information on use of the Excel solver (beyond the Excel documentation). A larger and faster solver can be purchased if you are developing very large models (e.g. those with over 100 markets to clear). VORSIM operations work normally for large models that require this “power” solver.
Green, J., S. Bullen, R. Bovey and M. Alexander. Excel
2007 VBA, Programmer’s Reference.
Walkenback, John. Microsoft
Office Excel 2003 Formulas. Wiley Publishing,
Walkenbach, John. Microsoft Excel 2003 Power Programming with VBA.
Walkenbach, John. Microsoft Office Excel 2007, Power
Programming with VBA. Wiley
Walkenbach, John. Microsoft Office Excel 2010, Power
Programming with VBA. Wiley
Francois, J. F. and K. A. Reinert, eds. 1997. Applied Methods for Trade Policy Analysis: A Handbook. Cambridge University Press, September 1997. This handbook covers a wide range of the model building techniques from traditional partial equilibrium models to CGE (computable general equilibrium) models. Although the techniques are applied to trade analysis, many of them are applicable to a wider set of problems.
Internet Resources: There are many resources on the Internet; these are a few to start:
Resources for Economists on the Internet, a Web Page for Economists. This web page is a comprehensive source of information on the Internet regarding economics. It has major references on modeling methods, data sources, and professional economists. It includes links to most of the major data sources and economic modeling groups in the world and is updated regularly by the American Economics Association.
ADR International, Ltd. This is the web site of a consulting firm that does trade research and analysis, especially for negotiations in the WTO (World Trade Organization). ADR also does research on foreign investment and economic development issues. The ADR home page is especially noteworthy for its links to research organizations working with trade and development issues around the world. In addition, ADR has built large VORSIM world trade models which deal with all traded products and balance of payments in individual countries.
Analyse-it. Statistical analysis software for Microsoft Excel. Analyse-it is integrated into Excel and includes multiple regression analysis, anova, chi-square, and many more procedures. A 30-day evaluation may be downloaded.
Mathtools.net is a technical computing portal for scientific and engineering needs. It contains useful links for technical computing programmers.
GTAP is the home of a leading world general equilibrium modeling project.
Business List contains listings for a wide variety of businesses in the
Other relevant publications: Several earlier works provide a background to modeling and analysis in spreadsheets. Earlier models and efforts are documented.
Roningen, V.O. 1993. Managing Free Trade For Agriculture. The