Hello, I am modeling employment in an Industry Change Activity Type and tried two different methods of entering the same inputs just to see if there would be any difference in the results. First I entered my employment counts manually: New Activity>Industry Change>New Event for each selected Industry Sector. Then I created an Activity Template using the same employment counts and the same Industry Sectors and imported the template from Excel. Once the other Industry Sales, Employee Compensation and Proprietor Income fields populated, I noticed that the values of those categories did not match across the two methods of entering in my inputs. The New Activity>Industry Change>New Event method actually generated higher values for each Industry Sector. The Event Year, LPP, Activity Type, Industry Sectors, and deflators are exactly the same. None of the Industry Sectors are Retail Sectors and I made sure that "No" was indicated in the Retail column of the Template. I also made sure that the employee counts were entered as integers so that the differences could not be explained by rounding. I used to think that these two methods were interchangeable but now I am thinking that the software is making different assumptions about how it interprets the inputs based on how they are entered. Is that correct? In other words, is the Industry Change Activity that is imported from Excel different from the Industry Change Activity that is entered into the software manually? If so, which method is "better" or the most reliable or appropriate to use? Alternatively, am I doing something wrong that could explain why the Industry Change, Employee Compensation and Proprietor Income values change for the same Employment inputs, the same Industry Sectors and for the same Activity Type? I have attached my original Activity Template and both sets of inputs that I exported to Excel. Thank you very much for your help! Andrew
Please sign in to leave a comment.