State Regional Commodity Tables & Trade Flows

Comments

7 comments

  • Avatar
    jenny
    Hi Jon, Can you please describe exactly which commodity table you are referring to?
    0
    Comment actions Permalink
  • Avatar
    Jon L. Smith
    Please forgive the omission. I am looking at the Regional Commodity Balances for the state of New Hampshire and each of the 10 counties. Jon
    0
    Comment actions Permalink
  • Avatar
    Jon L. Smith
    Let me provide some more information. I ran the model for the state of New Hampshire and then for each of the 10 counties. I then got compared the data for the Regional Commodity Balances tables. I assumed that the state values would be equal or almost equal to the sum of the county balances. In some cases it was. For example, for commodity code 3027 the value for "Total State Commodity Supply" is 19.66951752, exactly the same as the sum of the total of county values for the same commodity. In most cases, the state values are within 1 to 5% of the county sums with the state values being higher. In some cases, as with commodity 3028 where the state value is 34.49052048 and the summed county value is 3.444058248 or commodity 3119 where the state value is 14.80007648 and the summed county values are 0.744777262, the difference is extreme. I can understand minor differences of around 1% or so, but extreme deviations are troubling. Can you help me understand these discrepancies? Thanks, Jon
    0
    Comment actions Permalink
  • Avatar
    jenny
    I built a model using the state of NH 2009 data. I then built a second model using the 10 NH counties' 2009 data. When I go to Explore > Social Accounts > Social Accounts Resports tab > View By: Commodity, the value for "Total Commodity Supply" for commodity 3119 is identical in both models. I suggest trying this approach and seeing if you still see differences. If you do, it would be helpful if you could tell us which year of data you are dealing with, the exact steps you took, and exactly which table you are looking at (your numbers appear to be in millions, while mine are in dollars - are you by chance using Version 2 of the software?)
    0
    Comment actions Permalink
  • Avatar
    Jon L. Smith
    I am using V 3.0 with 2008 data. I think I see where the problem is. First, I am going into the file J:/IMPLAN User Data/MODELS with access and am exporting the RegionalCommodityBalances files into Excel. I then am looking at the various vectors like "Total Commodity Supply", which is the source of my confusion. I am also running 10 individual models,one for each county, rather than one as a 10 county region. Could it be the 2008 data or am I missing another source of the commodity inputs? Jon
    0
    Comment actions Permalink
  • Avatar
    jenny
    Thank you for the additional information - very helpful. I built a 2008 NH model and in the RegionalCommodityBalances table in Access I am seeing the same numbers as your county sums - so it appears as though something is awry with your state model. I suggest re-building a new NH model. If that doesn't fix it, you can always re-download your data from the software under the Help menu.
    0
    Comment actions Permalink
  • Avatar
    Jon L. Smith
    Jenny, I've rerun the state model and have come up with the correct figures. I'll have to try to determine what went wrong with the first run. Thanks for all of the help and time. Jon
    0
    Comment actions Permalink

Please sign in to leave a comment.