NAICS sectoring macro

Follow

ccooper

• March 29, 2010 21:43

I have the industry balance sheet exported to Excel and would like to aggregate the absorption and input values by 2 or 3-digit NAICS. By any chance would you have a macro for excel that would translate the Implan sectors into a 3-digit NAICS? I know I can aggregate my model but I am doing industry balance sheets for 5 or 6-digit industries and this isn't possible after aggregation.

0

• 

  DougO

  • March 30, 2010 11:45

  One of the cool things about the trade flow model, is that aggregating the model doesn't change the trade flows, they are simply added together. Do the balance sheets with the unaggregated and aggregate another model for the other reports. While the trade flows don't change you will still run into aggregation bias with the multipliers.

  0

  Comment actions Permalink
• 

  ScottL

  • March 30, 2010 14:43

  To answer your first question, we do not have a macro to do this. Any aggregation we do is all in MS Access. The aggregation templates are in your model. We write join queries to create the aggregation.

  0

  Comment actions Permalink

Please sign in to leave a comment.