[an error occurred while processing this directive]
Skip to main content

Help

The Jobs and Economic Development Impact (JEDI) model uses a Microsoft Excel (MS Excel) spreadsheet.

MS Excel Tips

Macros must to be enabled in MS Excel for JEDI to operate correctly.

MS Excel 2007 users: Please make sure that the security setting on your computer is not set to "High." Set the level to "Medium" or "Low" and then re-open the JEDI worksheet. You can reset to a higher level when you have finished using the JEDI model. When the macros window pops up, choose to enable macros.

Frequently Asked Questions (FAQ)

How do determine if I have the most current version and identify which version of the JEDI model I have?

The most current versions of the JEDI model are available on Downloading the JEDI Models web page. The version (release number) of the model you are currently using can be found in the File Name.

Is there a mailing list I can get on to be notified when new versions of JEDI are released?

Yes. Prior to downloading, all users are required to register with their contact information and accept our User Agreement. You may elect to "Opt-In" and be placed on the JEDI mailing list, please contact jedisupport@nrel.gov.

When I open up the model, I receive a security alert message stating "the macros in the file have been disabled." How do I change the security setting, so I can run the model with the macros enabled?

The message you are receiving is related to the level of security you have chosen in your MS Excel set up. To change the setting for opening files, open MS Excel. Locate the top toolbar, click "tools," then "macros," and then "security." Set the security level to "medium," this will allow you to enable or disable macros each time you open a file.

How do I run a county or regional level analysis?

Running a county- or regional-level analysis is similar to running a state-level analysis, although there are two key differences users must keep in mind. First, the model does not contain county- or regional-level multipliers, thus users must obtain these and add them into the model. Second, users must enter the county or regional population in the Purchaser Prices (ProjectData tab) table. The population provides a reference for the model to automatically insert "local share" defaults for the analysis. Please see our Advanced Users web page on obtaining county- or regional-level multipliers and how to add in the data.

Where can I get county or regional level data to add-in to the model to run a county or region specific analysis?

County-level multipliers and personal consumption expenditure patterns are available from a number of sources. Users familiar with IMPLAN or input-output modeling can purchase the raw county level data and derive the multipliers themselves or purchase directly from IMPLAN and other sources for similar input-output modeling data. See Advanced Users - Data web page for more information about sources.

How do I add in county- or regional-level multipliers and the personal consumption expenditure data?

Adding-in county- or regional-level multipliers and personal consumption expenditure data involves going to the "User Add-in Location" tab in this model and cutting and pasting the data into their respective locations. With the data inserted, it is also necessary to include the county or region name and the year of the data. See our Advanced Users web page for more information about adding in custom data.

What does the "local share" refer to?

The "local share" refers to the percentage of each expenditure that is actually spent locally (i.e., in the state, county or region being analyzed). For example, if $1 million is going to be spent on construction materials and half ($500,000) of this total will be purchased from local suppliers, we say the "local share" is 50 percent.

I want to make my analysis as accurate as possible, where can I get information to adjust the default "local share" values (in the ProjectData tab) for my state or county?

Since the "local share" is directly related to the availability of local businesses and services and their ability to meet the construction and annual operating demands of the project, it is important to have an accurate picture of these local resources. This can be obtained in a number of ways: contacting experienced and knowledgeable persons in the area, contacting local business and contractor organizations and/or the local chamber of commerce, among others.

I am interested in viewing and possibly editing internal formulas within the model, how do I access them?

The JEDI model contains several intermediate worksheets that are an integral part of the model analysis. These worksheets are not designed to be changed by users. Several of these worksheets, including default data, calculations, and deflators may be viewed by clicking on the respective worksheet and scrolling to the right. Although these sheets may be viewed by users, they are protected and can not be edited. The model contains two additional worksheets: multipliers and household expenditures. These worksheets are hidden to protect proprietary data derived from IMPLAN (Minnesota IMPLAN Group).

Technical Contacts

For questions or comments regarding JEDI, please contact Technical Support.

Web Site Contact

For Web site questions, including questions about the download and registration process, please contact the Webmaster.