INTRODUCTION:
IMPLAN now allows users to upload any Event type using the Event template. Event templates can be used to create Events outside of IMPLAN for import into the system. The sheet has one tab for each Event Type, and the correct tab must be used in order for importing to be successful.
The Event Template is a very specific file, and each field must be filled out as it is shown in the original template. For example, where the template shows "100%" do not enter "100" (without the %).
If IMPLAN detects any errors in the uploaded template, it will display an appropriate warning message on the Import Event Template window indicating whether a specific Event can be imported without modifications.
At this time, IMPLAN recommends limiting your imports to 500 Events. Also, do not include an Event that has no Event Value or a cell containing a formula as this causes an error and won't let you upload the template.
If you are using the Template to upload Events and also manually entering an Event, it is recommended to upload the Template first. Uploading a Template into IMPLAN may cause manually entered Tags to be erased from the project.
There are three distinct Event Templates for use in IMPLAN, each one designed for use with a specific Industry Scheme. The US Industry, Canada Provincial, and International Templates can be downloaded from the Related Articles section at the bottom of the page.
CREATING A NEW EVENT TEMPLATE:
STEP 1 – DOWNLOAD THE BLANK EVENT TEMPLATE
- Download US Industry 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’ tab
- Commodity Output Events can be entered in the ‘Commodity’ tab
- Labor Income Events can be entered in the ‘Labor Income’ tab
- Household Income Events can be entered in the ‘Household Income’ tab
- Industry Spending Pattern Events can be entered in the ‘Industry Spending Pattern’ tab
- Institution Spending Pattern Events can be entered in the ‘Institution Spending Pattern’ tab
- Industry Contribution Analysis Events can be entered in the ‘Industry Contribution Analysis’ tab
- Populate the selected tab(s) with the Event Input Values you’d like to use. For information that you do not have, leave the values (cells) blank. Uploading the Event Template with the following info we would get a single Industry Output Event named "Event Template Article - Industry Event" in Industry 1, with an Output of $1M, and an Event Tag named "Wassily":
- 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
- Navigate back to the Impact Screen of IMPLAN
- Click the Advanced Options icon at the top of the page next to “SAVE”
- Click “Upload Template”
- Click “Choose file”
- Find your saved file
- Open your file
- Check the checkbox next to the Event 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 “Dollar Year” to the Events - this step must be done manually
MARGINING
Margins can be applied in the case of Industry and Commodity Events, where applicable. If you’d like margins to be applied to you Industry Event, populate the “Margins” column of the Template by using the dropdown menu to select “Producer” or “Purchaser.” Remember, not all Industries and Commodities are marginable. The only marginable Industries are Retail and Wholesale Industries. 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 marginable Commodities. Find current margins in the article Margins & Deflators. Note that currently, if you want your Commodity Events to be set to "Purchaser", leave the margin column blank. If you select "Purchaser" price for a non-wholesale or retail industry, IMPLAN will revert this change and change it back to "Producer" price automatically before running the Impact.
EVENT TYPE
The Event Template contains directions in an orange box on each tab. The following details directions and what values should be entered in each cell.
INDUSTRY
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Industry: This field is required. Your Sector value should be 1-546 for data years 2018 and forward.
Output: This field is optional.* If you know the Output associated with your impact, you will want to enter it in this field. If you leave this field blank, IMPLAN will estimate it based on one of the entered values for Employee Compensation, Proprietor Income, or Employment.
Employment: This field is optional.* If you know the Employment associated with 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 Industry.
Employee Compensation: This field is optional.* If you know the value of Employment Compensation paid in your Event, you will enter that value here. If you leave this field blank, IMPLAN will estimate the Employment Compensation value based on Employee Compensation per Worker values for the selected Industry.
Proprietor Income: This field is optional.* If you know the value of Proprietor Income paid in your Event, you will enter that value here. If you know that no Proprietor Income is paid by your Event, enter "0" here. If you leave this field blank, IMPLAN will estimate the Proprietor Income value based on Proprietor Income per Worker values for the selected Industry.
While each of these four fields is optional, at least one of them (Output, 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 a zero is entered, IMPLAN will treat that value as a zero and no associated impacts for that field will be calculated.
Margins: This field indicates to IMPLAN whether or not Margins should be applied to the Event value. Remember, only a retail or wholesale Industry can be margined. You must select “Purchaser” or “Producer” price for each retail or wholesale Industry Event in the template. If you select "Purchaser" price for a non-wholesale or retail industry, IMPLAN will revert this change and change it back to "Producer" price automatically before running the Impact. If you leave it blank, IMPLAN will default to Purchaser Price.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
INDUSTRY IMPACT ANALYSIS (DETAILED)
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Industry: This field is required. Your Sector value should be 1-546 for data years 2018 and forward.
Wage & Salary Employment: This field is optional.* If you know the Wage & Salary Employment associated with your impact, you will want to enter it in this field. If you leave this field blank, IMPLAN will estimate the value based on Average Employee Compensation values for the selected Industry.
Proprietor Employment: This field is optional.* If you know the Proprietor Employment associated with your impact, you will want to enter it in this field. If you leave this field blank, IMPLAN will estimate the value based on Average Proprietor Income values for the selected Industry.
Total Employment: This field is optional.* If you know the Total Employment associated with your impact, you will want to enter it in this field. Total Employment must be equal to the sum of Wage & Salary and Proprietor Employment. If you leave this field blank, IMPLAN will estimate the value based on Average Employee Compensation and Average Proprietor Income values for the selected Industry.
Employee Compensation: This field is optional.* If you know the value of Employment Compensation paid in your Event, you will enter that value here. If you leave this field blank, IMPLAN will estimate the Employment Compensation value based on Employee Compensation per Worker values for the selected Industry.
Proprietor Income: This field is optional.* If you know the value of Proprietor Income paid in your Event, you will enter that value here. If you know that no Proprietor Income is paid by your Event, enter "0" here. If you leave this field blank, IMPLAN will estimate the Proprietor Income value based on Proprietor Income per Worker values for the selected Industry.
Total Labor Income: This field is optional.* If you know the Total Labor Income associated with your impact, you will want to enter it in this field. Total Labor Income must be equal to the sum of Employee Compensation and Proprietor Income. If you leave this field blank, IMPLAN will estimate the value based on the Production Function of the selected Industry.
Taxes on Production & Imports Net of Subsidies: This field is optional.* If you know the Taxes on Production & Imports Net of Subsidies value associated with your impact, you will want to enter it in this field. If you know that no Taxes on Production & Imports Net of Subsidies is paid by your Event, enter "0" here. If you leave this field blank, IMPLAN will estimate the value based on the Production Function of the selected Industry.
Other Property Income: This field is optional.* If you know the Other Property Income value associated with your impact, you will want to enter it in this field. If you know that no Other Property Income is paid by your Event, enter "0" here. If you leave this field blank, IMPLAN will estimate the value based on the Production Function of the selected Industry.
Intermediate Inputs: This field is optional.* If you know the Intermediate Inputs value associated with your impact, you will want to enter it in this field. If you know that no Intermediate Inputs value is paid by your Event, enter "0" here. If you leave this field blank, IMPLAN will estimate the value based on the Production Function of the selected Industry.
Output: This field is optional.* If you know the Output associated with your impact, you will want to enter it in this field. Output must be equal to the sum of each component in the Production Function (Employee Compensation, Proprietor Income, Taxes on Production, Other Property Income, and Intermediate Inputs). The template will fail to upload if the sum exceed the Output value. If you leave this field blank, IMPLAN will estimate the value based on the Production Function of the selected Industry.
*While each of these ten fields is optional, at least one of them will require an entered value. IMPLAN will estimate the value of the remaining fields based on the Production Function of the selected Industry. If two or more fields contain information, IMPLAN will estimate the remaining values based on the outlined steps found in the Industry Impact Analysis Event Type article. This Event Type follows specific steps in order to estimate remaining values, please read the article carefully before proceeding.
Spending Pattern Year: This field is required. This field indicates which Data Year you are using. We recommend using the Data Year that matches the year of your data which would be the year your Event took place. If you are modeling something that is expected to happen in the future, we recommend using the most current Data Year. The template will fail to upload if you delete this value.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
COMMODITY OUTPUT
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Commodity: This field is required. Your value should be 3001-3546 for data years 2018-present.
Event Value: This field is required. This field is equivalent to the Commodity Output Event in IMPLAN and needs to be in the dollar value that is triggering the Event.
Margins: This field indicates to IMPLAN whether or not Margins should be applied to the Event value. Only Commodities that can be sold via a retailer or wholesaler can be margined in a Commodity Event. Select “Producer” price for each Commodity Event in the template if you know the value is the price received by the producer for goods and services that are sold. Setting margins to "Purchaser" means the value is the price paid by Industries and final users. If you leave it blank, IMPLAN will default margins to Purchaser Price. If you select "Purchaser" price for a non-wholesale or retail industry, IMPLAN will revert this change and change it back to "Producer" price automatically before running the Impact. Note that there is a tab within the Event Template titled "Marginable Commodities". This tab incudes' a list of all of the Commodities in IMPLAN that can be sold via a wholesale or retail Industry, and thus could have margins selected where applicable.
Local Purchase Percentage: This field is required. You must enter a value between 0-100%, this tells the software what portion of the line item Commodity was purchased locally and therefore affects the local Region. If you would like us to look this up in the model’s Social Accounting Matrix, enter SAM. When LPP is set to SAM, LPP will be set to the Regional Purchasing Coefficient (RPC) for the given Commodity and Region. Leaving this value blank will by default set LPP to 100%.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
LABOR INCOME
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Specification: This field is required. Use the dropdown menu to select a Labor Income.
Event Value: This field is required. The dollar value paid to the Labor Income component. Labor Income implies a value from an increase in earnings by existing employees or proprietors that is isolated from a change in industry production.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
HOUSEHOLD INCOME
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Specification: This field is required. Use the dropdown menu to select a Household.
Event Value: This field is required. The dollar value of Household Income should be entered. Household Income implies a value that includes income, personal tax, and savings but does not include payroll taxes.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
INDUSTRY SPENDING PATTERN
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Industry: This field is required. Your Sector value should be 1-546 for data years 2018 and forward.
Spending Pattern Year: This field is required. This field indicates which Data Year you are using. We recommend using the Data Year that matches the year of your data which would be the year your Event took place. If you are modeling something that is expected to happen in the future, we recommend using the most current Data Year. The template will fail to upload if you delete this value.
Intermediate Input: This field is optional.* The Intermediate Input field is the total value of all purchases of non-durable goods and services that are used to produce other goods and services rather than for final consumption. When the Intermediate Input field is chosen, 100% of the entered value will be spent on the Commodities included in the Industry Spending Pattern.
Output: This field is optional.* Output is the total value of Industry production in Producer Prices. When a value is entered in the Output field, the value will be multiplied by the total Gross Absorption percentage for the Industry before being spent on the list of Commodities included in the Industry Spending Pattern.
While both fields are optional, at least one of them will require an entered value. If both fields contain information, IMPLAN will default to the Intermediate Input value. If both cells are left blank, IMPLAN will not upload the Event.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
Commodity: This field is optional. Your Sector value should be 3001-3546 for data years 2018-present. This field should list all of the Intermediate Input Commodities you want to be included in the Industry’s Spending Pattern.
Percentage of Intermediate Input: This field is optional. You must enter a value between 1%-100% for each commodity. This indicates how much of the total Intermediate Input value should apply to each commodity in your Spending Pattern. The Sum of Percentages should equal 100%, regardless of whether Intermediate Inputs or Total Output is selected.
Local Purchase Percentage: This field is optional. You must enter a value between 1%-100% (which will , this tells the software what portion of the line item Commodity was purchased locally and therefore affects the local Region. If you would like us to look this up in the model’s social accounting matrix, enter SAM. When LPP is set to SAM, LPP will be set to the Regional Purchasing Coefficient (RPC) for the given Commodity and Region. If you leave it blank, IMPLAN will default to SAM.
INSTITUTION SPENDING PATTERN
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Institution: This field is required. You must enter the Institution code, not description.
Spending Pattern Year: This field is required. This field indicates which Data Year you are using. We recommend using the Data Year that matches the year of your data which would be the year your Event took place. If you are modeling something that is expected to happen in the future, we recommend using the most current Data Year. The template will fail to upload if you delete this value.
Intermediate Input: This field is required. The value entered in the Intermediate Input field should be the total value of spending on goods and services, as well as spending on labor. 100% of the entered value will be spent on the Commodities included in the Industry Spending Pattern.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
Commodity: This field is optional. Your Industry value should be 3001-3546 for data years 2018-present. This field should list all of the Intermediate Input Commodities included in the Institution Spending Pattern.
Percentage of Intermediate Input: This field is optional. You must enter a value between 1%-100% for each commodity. This indicates how much of the total Intermediate Input value should apply to each commodity in your Spending Pattern. The Sum of Percentages should equal 100%.
Local Purchase Percentage: This field is optional. You must enter a value between 1%-100%, this tells the software what portion of the line item Commodity was purchased locally and therefore affects the local Region. If you would like IMPLAN to look this up in the model’s social accounting matrix, enter SAM. When LPP is set to SAM, LPP will be set to the Regional Purchasing Coefficient (RPC) for the given Commodity and Region. If you leave it blank, IMPLAN will default to SAM.
INDUSTRY CONTRIBUTION ANALYSIS
Event Name: This field is required. You must enter a unique name for each Event in your project. The template will fail to upload if you enter the same Event Name throughout multiple tabs.
Industry: This field is required. Your Industry value should be 1-546 for data years 2018 and forward.
Contribution Value: This field is optional.* Enter the dollar value of the Industry Output that you want to model. The value should not exceed the Total Output of that Industry in the region.
Contribution Percentage: This field is optional.* Enter a percentage of the Industry Output that you want to model. The value can be up to, but not exceeding 100%.
While both fields are optional, at least one of them will require an entered value. If both fields contain information, IMPLAN will default to the Contribution Value. If both cells are left blank, IMPLAN will not upload the Event.
Event Tag: This field is optional. This field applies a tag you would like associated with the event. If you would like more than one tag per event, you must enter multiple tags separated by a comma (,) or pipe (|) character. Do not leave a space before or after the tag name. You can use up to 100 tags in a single project.
NOTE
The Event Template is available to use with the IMPLAN 546 Unaggregated scheme, as well as any custom or quick aggregation scheme, such as the 2-digit NAICS. Note, if you are using anything other than the IMPLAN 546 Unaggregated scheme, IMPLAN will only correctly upload your Events with the Event Template if you first set the Aggregation Scheme as outlined here. In addition to this, if using the 2 or 3 Digit NAICS quick aggregation schemes, you will need to set your Industry codes in the Event Template by rank, not the 2 or 3-digit NAICS codes. For example, 2-digit NAICS code 23 - Construction is shown in IMPLAN as rank code 4. If you are unsure of the rank, you can view any Industry scheme under the Industry Aggregation tab located in your preferences menu.
RELATED ARTICLES:
Event Template - International
Why can I not margin Sectors I once was able to apply margins to?
Written December 20, 2019
Updated February 17, 2023
Comments
0 comments
Article is closed for comments.