I am running an IMPLAN analysis of the impact of 30 separate firms from the same industry on their respective MSAs. Each firm is located in a different MSA. The analysis will be based on a survey that asks for each firm's capital and operating expenditures by year for 10 years. The IMPLAN activities will be uniform for every firm. Activity values will relate to direct outputs from the survey, which I will have in Excel format. My question is how to run the IMPLAN analysis most efficiently for the 30 firms and options to integrate the survey outputs from Excel with IMPLAN. (1) I have set up all activities in one MSA. If I export these data to the Activity Library, what will I need to adjust when I import these activities to another MSA? For example, I assume the local purchase percentage (based on the SAM model) from the original MSA is also imported to the new MSA. Are there other elements of the activity that will need adjusting when imported? Are industry spending coefficients, for example, common across MSAs? Is there any way to automate adjusting the LPP to reflect the SAM values of the new MSA? (2) I have tried importing activities from Excel using the template provided, but IMPLAN does not recognize when I change the event year; it always displays some default event year that doesn't appear in the Excel. Is there a way to ensure the event year from Excel is displayed in IMPLAN? (3) Assuming event years can be adjusted, one idea I have for analyzing results is to: (A) Setup activities for one MSA (B) Export all the activities to Excel to essentially create activity templates (C) Program Excel to populate these templates with the survey results (treating one firms' responses as the values for a set of activities) (D) Create the next IMPLAN model for the next MSA and import the Excel-based activities -- with the appropriate Activity values already assigned. (E) Adjust Local Purchase Percentages to reflect the model's SAM values. Does the process above seem possible? (I have yet to purchase all the data I need, so I can't try it myself.) Is there a way to automatically adjust LPPs to the local SAM values when I import from Excel? Are there other adjustments I need to make when importing activities from one model to another? (The activities include an industry spending pattern, a labor income change, a commodity change, and an institutional spending pattern.)
Please sign in to leave a comment.