INTRODUCTION:
The Activity Template is an Excel spreadsheet found at Documents>MIG> IMPLAN> User Data>Templates folder. The Activity Template can also be downloaded here.
DETAILED INFORMATION:
Activity Templates are a great way to manipulate and create Events outside the IMPLAN software and to move a series of Events between multiple Models.
The Activity Template is a very specific file, and each field must be filled out exactly as it is shown in the original template. It is used for creating Activity Types in advance, outside of IMPLAN for import into the IMPLAN system. The sheet has one tab for each Activity Type, and the correct tab must be used for successful import.
The Activity Year is a field that reports at the top of every template. It is not a field that needs to be modified and it doesn't affect the import of the results.
Please open the slide(s) for the Excel tab you are working with to see detailed information in regards to the fields in that tab.
INDUSTRY CHANGE:
Sector: This field is required. Your Sector value should be 1-536 if you are using 2013 - current data year. If you are using datasets from 2007-2012, your sector value should be 1-440.
- If you need help with Sector selection, you can download the NAICS (2012) TO IMPLAN 536 BRIDGE here or use the Model's Help>Sector Search.
- For construction Sectors, a different template is available. This is because our construction definitions are Census based instead of NAICS based.
- If you are running into an error indicating that you have a value that is out of bounds, check the Sector numbers to be sure they all fall into the appropriate Sectoring scheme (536 for 2013 - current data year).
Event Value: This field is optional*. This field is equivalent to Industry Sales in the Event in IMPLAN and is 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.
- If you are entering Employment values, you will want to be sure they are equivalent to IMPLAN jobs. Find the 536 FTE & EMPLOYEE COMPENSATION CONVERSION TABLE (2015) here.
Employee Compensation: This field is optional*. If you know the value of Employment Compensation 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.
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.
Event Year: This field is required. The Event Year should reflect the value of the dollars or the year of the jobs you are entering into the other Event fields.
- Event Year is required for every Event line in the template. You can use the bottom right-hand box to drag the Event Year across multiple Events if they are occurring in the same year.
Retail: This field indicates to IMPLAN whether or not Margins should be applied to the Event value.
- This field should be set to 'No' unless you are working with an Event value for Sectors 396-407 (the Retail Sectors in the 536 sectoring scheme) or you are entering a value into the Model which represents a retail or final purchase price.
- 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).
*While each of these fields is optional, at least one of these four fields (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.
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.
- For both Employment Compensation and Proprietor Income, Labor Income implies a fully loaded payroll value. If you need to convert from wage and salary numbers, you can do so with using the 536 FTE & EMPLOYEE COMPENSATION CONVERSION TABLE (2015), downloadable here.
Event Year: This field is required. The Event Year should reflect the value of the dollars entered into the Labor Income field. This will typically be the year of the labor payments.
- Event Year is required for every Event line in the template. You can use the bottom right-hand box to drag the Event Year across multiple Events if they are occurring in the same year.
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 LT10k
10002 Households 10-15k
10003 Households 15-25k
10004 Households 25-35k
10005 Households 35-50k
10006 Households 50-75k
10007 Households 75-100k
10008 Households 100-150k
10009 Households 150k+
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 required. The Event Year should reflect the value of the dollars entered into the Household Income field. This will typically be the year of the Household Income.
- Event Year is required for every Event line in the template. You can use the bottom right-hand box to drag the Event Year across multiple Events if they are occurring in the same year.
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).
RELATED TOPICS:
Updated December 3, 2019
Comments
0 comments
Article is closed for comments.