Hi, I am running single-region analysis for each state (2010 models). I am importing an activity template for an industry change from Excel for each state. Each activity has 42 events. The columns I am using are Sector (#), Employment (#), Event Year (2012), Retail (No), and Local Direct Purchase (100%). For some states, the Employment values do not seem to be importing for certain sectors when I import the activity. The issues are not confined to a single sector across states. For the problematic states, all of the sectors seem to import fine except for one. I am curious as to why this might be happening. I have tried copying the template values to a new Excel workbook in case there was some underlying formatting or links that were creating problems, which did not fix the problem. Is it possible that the values are being imported, but not displayed in the Event section under Employment? Is there any harm in creating custom events for the sectors that are not importing through the template by manually typing in the Employment values? An additional problem I am having is with decimal values. Some of the employment values in my templates are not whole numbers. When I import them into IMPLAN, the decimals are different. It doesn't seem to be just a rounding issue, though the decimal values in IMPLAN round up to the same whole numbers as the decimals in the template. Why might this be happening? Thank you.
Please sign in to leave a comment.