- Installing Fred Add On In Excellence
- Installing Fred Add On In Excel Sheet
Installing Fred Add On In Excellence
These are Excel add-in files (.xla) for the OM/IE collection. They are compressed and stored at this site with the (.zip) suffix. Download by clicking on the file name of the add-in in the left most column. The files may be expanded with the free Aladdin Expander.
On the bottom of the window choose (Manage: Excel Add-ins) Go. In the new window, choose Browse and locate the file (Ex. FRED2013.xlam) that you downloaded and click OK. If prompted about a file already existing, accept the prompt. Make sure the check box next to FRED is checked. On the Ready to install page, click Install. After the installation is completed, click Finish to close the wizard. The first time that you open Excel or Word on a computer where the Office Add-ins component was installed, you are prompted to install the add-in. Click Install to continue with the installation. After you install the Office Add-ins. The FRED Spreadsheet Add-In is the next step toward improving the usability of economic data for students, researchers, and businesspeople alike. The FRED Add-In has been designed with a simple interface that provides users with a fast way to get economic data from FRED into Excel for conducting analysis using all of the tools Excel has to offer. Federal Reserve Bank of St. Louis, One Federal Reserve Bank Plaza, St. Louis, MO 63102.
As the add-ins are improved and corrected, we update the versions on the web. The DateModified entries below show the dates of the latest revisions. Click the Revisions link on the left to see the purpose of each revision. If you replace an add-in with a newer version, be sure to delete or change the name of the old version. Otherwise, Excel may link to the old version rather than the new.
Links are provided to the instructions for each add-in. Click on the add-in name or the leaf on the right to reach the instructions. Add-ins are not used like regular Excel workbook files. They must be installed through the add-in dialog on the tools menu or through the Add OMIE. Review the General Instructions for loading add-ins.
Installing Fred Add On In Excel Sheet
Date Modified | Instructions |
9/18/04 | Add OMIE
When called, this add-in lists all the OM/IE add-ins that are in the same directory as the Add OMIE add-in. Add-ins are installed and removed with a simple click of a button. The add-in also loads demonstration files that illustrate the add-ins. To use this feature these files must be stored in a the same directory as the add-ins. See the instructions for details. |
Investment Economics
This add-in performs a variety of procedures to evaluate investment alternatives. Included are procedures to define projects and compute measures of effectiveness such as present worth, annual worth and internal rate of return. Functions are provided to compute the traditional time value of money factors. Projects may be defined with tax and inflation considerations. Cash flows are presented in either tabular or graphical displays. For a one-page summary click here. |
7/15/04 | Portfolio
This add-in uses optimization for two kinds of portfolio problems. Capital Budgeting selects a portfolio from a set of candidate projects. A project is described by its initial investment, annual return, salvage value and life. The first three of these factors are described by averages and standard deviations. Markowitz Portfolio analysis determines an optimum mix if financial securities considering both security returns and risk. Risk is measured by the statistical variance of the portfolio. The analysis uses historical return data to determine the expected return for each security and the covariance matrix showing the dependence between securities. |
Process Flow Analysis
The Process Flow Add-in provides a tool to analyze and design manufacturing systems. Four principal activities are supported: process definition, economic analysis, resource requirements analysis and product mix decisions. Either tree or network structures are allowed. The add-in links with the Math. Programming add-in to produce linear and mixed integer models for decisions. It also links with the Facility Layout add-in for facility design. Models for queues, inventories and lot change delays are included. |
Facility Layout
This add-in accepts as data: a list of departments, physical size of departments, part flows between departments and the size of a proposed plant. The program uses the CRAFT procedure in an attempt to find the layout of departments that minimizes the distance over which parts must flow. The new version interacts with the Process Flow add-in. Significant revision was made on 2/13/03. Optimization was added on 1/22/04. |
Forecasting
The add-in implements several forecasting methods for data series including: moving average, exponential smoothing, regression and double exponential smoothing. The add-in constructs a form that holds the data and uses functions to compute forecasts and forecast errors. Several data series can be analyzed on a single worksheet page. An option allows comparison of several methods for a single time series. A simulation option creates data simulated with the Monte Carlo technique. A portfolio option evaluates and forecasts a portfolio of investments. Adjustments are provided for series with seasonality. |
2/21/04 | Inventory
We compute the Economic Lot Size with or without backorders or lost sales. We also allow either finite or infinite replenishment rates. Both deterministic and stochastic models are considered. The add-in finds the optimum lot size with cost breaks. Three optimization models that involve more than one item are solved: multi-item systems, inventories with common cycle times and machine scheduling. The add-in includes several models of manufacturing processes that produce Work-in-Process. Total WIP and cycle times are computed for combinations of inventories arranged into systems. |
Materials Requirement Planning
Materials Requirement Planning (MRP) is a scheduling procedure for production processes that have several levels of production. The add-in provides the means to enter data concerning a production system and determine a schedule with MRP. |
12/26/04 | Project Management
This add-in performs the computations of CPM and PERT. Given the activities of the project, the add-in computes the critical path. A graphical display is available. With restricted resources, the add-in generates schedules which attempt to minimize shortage costs. |
| Archive |
Jensen Library
This is the complete collection of ORMM, Teach OR and OM/IE add-ins. The archive also includes the the folder demo_xls. This folder includes all the demonstrations for the add-ins. |
