INTRODUCTION:
Currently, IMPLAN allows you to upload Industry Change, Commodity Output, Labor Income Changes, and Household Spending Changes. We have several improvements and expansions planned for this template as we work to include things like Spending Patterns, Regional Definition, and more. As always, if you have ideas we would love to hear them here!
The Event Template is a very specific file, and each field must be filled out EXACTLY as it is shown in the original template. For example, where the template shows "100%" do not enter "100" (without the %).
It can be used to create Events outside of IMPLAN for import into the system. The sheet has one tab for each Activity Type, and the correct tab must be used in order for importing to be successful.
At this time, IMPLAN recommends limiting your imports to 100 Events. Also, do not include an Event Value with a zero as this causes an error and won't let you upload the template.
CREATING A NEW EVENT TEMPLATE:
STEP 1 – DOWNLOAD THE BLANK EVENT TEMPLATE
- Ensure your Regions and all the Groups you will need for your Analysis are set up first to minimize model running time
- Download Event Template
- Select the tab(s) with the Type of Event(s) you’d like to import
- Industry Output, Employment, Employee Compensation, and Proprietor Income Events can be entered in the ‘Industry Change’ tab
- Commodity Output Events can be entered in the ‘Commodity Output’ tab
- Labor Income Events can be entered in the ‘Labor Income Change’ tab
- Household Income Events can be entered in the ‘Household Spending Change’ tab
- The additional tabs are not yet available for importing into IMPLAN
- Populate the selected tab(s) with the Event Input Values you’d like to use. “Event Value” corresponds to Output in the “Industry Change” tab. For information that you do not have, leave the values (cells) blank.
- The Event Year will not be imported. “Event Year” is labeled “Dollar Year” in IMPLAN and must be defined in the tool within the Group(s).
- Save the populated Template in a place and by a name that will be easy for you to find and identify later.
STEP 2 – IMPORT THE COMPLETED EVENT TEMPLATE
- Ensure your Regions and all the Groups you will need for your Analysis are set up first to minimize model running time
- Navigate back to the Impact Screen of IMPLAN
- Click the Advanced Options icon at the top of the page next to “Select All Events”
- Click “Upload Template”
- Click “Select template file”
- Find the saved Template Excel file
- Select the file and click “Open”
- The Type(s) listed in black are the available Types for importing
- Check the checkbox next to the Type(s) you’d like to import
- Click “Save”
- Your Event(s) will now be populated in the Impacts Screen
- Events will need to be dragged and dropped into the appropriate Groups - the import process will not automatically match Events to Groups, and therefore the import process will not assign any “Event Year” (now called “Dollar Year”) to the Events - this step must be done manually
- Note Event types that are in orange text are not available
MARGINNING:
- Margins can be applied in the case of Industry and Commodity Events, where applicable
- If you’d like margins to be applied, populate the “Retail” column of the Template with “Yes”. This will choose “Total Revenue” (if the Sector or Commodity is marginable) within the Advanced Menu of the Event, applying Margins.
- Remember, not all Industries and Commodities are marginable.
- The only marginable industries are Retail and Wholesale sectors. IMPLAN has adjusted the best practices of modeling commodity purchases with margins rather than industry purchases. The only exception is for wholesale and retail industries which maintain their marginable status.
- Now, when the item purchased is known, a Commodity Output Event should be modeled using the purchased item as the Specification and Margins can be applied if appropriate.
- Commodities that can be purchased from a retailer are the marginnable Commodities. Find current margins in Margins 2018.
EVENT TYPE:
INDUSTRY CHANGE
Sector: This field is required. Your Sector value should be 1-546 for data years 2018 and forward.
Event Value (Output): This field is optional.* This field is equivalent to Industry Output in the Event in IMPLAN and needs to be in the dollar value that is triggering the Event. Do not use a dollar sign when you enter the dollar amount in this field as this could cause errors on import.
Employment: This field is optional.* If you know the Employment associated to your impact, you will want to enter it in this field. If you leave this field blank, IMPLAN will estimate the Employment value based on Output per Worker values for the selected Sector.
Employee Compensation: This field is optional.* If you know the value of Employment Compensation paid in your Event, you will enter that value here. Again, do not use a dollar sign when you enter the dollar amount in this field as this could cause errors on import.
Proprietor Income: This field is optional.* If you know the value of Proprietor Income paid in your Event, you will enter that value here. Do not use a dollar sign when you enter the dollar amount in this field as this could cause errors on import. If you know that no Proprietor Income is paid by your Event, enter "0" here.
While each of these four fields is optional, at least one of these them (Event Value, Employment, Employment Compensation, or Proprietor Income) will require an entered value. IMPLAN will estimate the value of the remaining fields based on the value you enter into the template. If two or more fields contain information, IMPLAN will estimate the remaining values based on the entered Event Value.
If any cell B-E is left blank, IMPLAN will calculate results for that field. If a zero is entered, IMPLAN will treat that value as a zero and no associated impacts for that field will be calculated.
Event Year: This field is will not be recognized by IMPLAN and can be left blank. A Dollar Year will need to be determined in the Group on the Impact screen and should reflect the value of the dollars or the year of the jobs you are entering into the other Event fields.
Retail: This field indicates to IMPLAN whether or not Margins should be applied to the Event value. The capitalization of the word is important - 'Yes' is entered if you want Margins applied to your Event value. A retail selection must entered for every Event line.
Local Direct Purchase: By default this field is 100%, and you will not want to change this value unless:
- You are working with a sales value that doesn't all occur within the Study Area (e.g. Big Box X did $80MM in sales this year in North Carolina, of which 18% was in my county (Event Value = 80MM, Local Direct Purchase = .18).
- You are using an Industry Change Activity type but are modeling budgetary spending (i.e. first round Indirect Expenditures).
COMMODITY OUTPUT
Sector: This field is required. Your Sector value should be 3001-3536 for data years 2013-present.
Event Value: This field is equivalent to Industry Output in the Event in IMPLAN and needs to be in the dollar value that is triggering the Event. Do not use a dollar sign when you enter the dollar amount in this field as this could cause errors on import.
Event Year: This field is will not be recognized by IMPLAN and can be left blank. A Dollar Year will need to be determined in the Group on the Impact screen and should reflect the value of the dollars or the year of the jobs you are entering into the other Event fields.
Retail: This field indicates to IMPLAN whether or not Margins should be applied to the Event value. The capitalization of the word is important - 'Yes' is entered if you want Margins applied to your Event value. A retail selection must entered for every Event line.
Local Direct Purchase: By default this field is 100%, and you will not want to change this value unless you are working with a sales value that doesn't all occur within the Study Area (e.g. Big Box X did $80MM in sales this year in North Carolina, of which 18% was in my county (Event Value = 80MM, Local Direct Purchase = .18).
LABOR INCOME CHANGE
Sector: This field is required.
- 5001 - Employment Compensation is selected if you are working with a value paid to wage and salary workers
- 6001 - Proprietor Income is selected if your entered value represents payments to sole proprietors or business partners
Labor Income: This field is required. The dollar value paid to Employment Compensation or Proprietor Income should be entered. Do not use a dollar sign when you enter the dollar amount in this field as this could cause errors on import.
Event Year: This field is will not be recognized by IMPLAN and can be left blank. A Dollar Year will need to be determined in the Group on the Impact screen and should reflect the value of the dollars entered into the Labor Income field. This will typically be the year of the labor payments.
Local Direct Purchase: This field is required. By default this field is 100%, and you will not want to change this value unless you are working with an income value that wasn't all paid within the Study Area (e.g. Big Box X paid $80MM in Employment Compensation this year in North Carolina, of which 18% was in my county (Event Value = 80MM, Local Direct Purchase = .18)). This is different from commuting rates, which should be calculated outside of the Model.
HOUSEHOLD SPENDING CHANGE
Sector: This field is required. The following Household Sectors are available. Descriptions are provided here for guidance, but only the numbers (10001-10009) should be entered into the field.
10001 Households LT15k
10002 Households 15-30k
10003 Households 30-40k
10004 Households 40-50k
10005 Households 50-70k
10006 Households 70-100k
10007 Households 100-150k
10008 Households 150-200k
10009 Households 200k+
Household Expenditures: This field is required. The dollar value of Household Income should be entered. Do not use a dollar sign when you enter the dollar amount in this field as this could cause errors on import. Household Income implies a value that includes income tax and savings but does not include payroll taxes of benefit values.
Event Year: This field is will not be recognized by IMPLAN and can be left blank. A Dollar Year will need to be determined in the Group on the Impact screen and should reflect the value of the dollars entered into the Household Income field. This will typically be the year of the Household Income.
Local Direct Purchase: This field is required. By default this field is 100%, and you will not want to change this value unless you are working with an income value that wasn't all paid within the Study Area (e.g. Big Box X paid $80MM in dividends this year in North Carolina, of which 18% was in my county (Event Value = 80MM, Local Direct Purchase = .18).
SPENDING PATTERNS
Currently, spending patterns can’t be uploaded into IMPLAN. We have several improvements and expansions planned for this template as we work to include things like Spending Patterns, Regional Definition, and more. Stay tuned!
RELATED ARTICLES:
Why can I not margin Sectors I once was able to apply margins to?
IMPLAN Pro: Exporting Events using the Event Template
Written December 20, 2019
Updated November 25, 2020
Comments
0 comments
Article is closed for comments.