industry import matrix

Comments

7 comments

  • Avatar
    DougO
    There is no prepared import matrix report in version 3. If you want a matrix then you will need to open your model file (after creating multipliers) using Microsoft Access and: 1) Under Queries click on "New" 2) Close the "Show Table" window 3) In the upper left of the main window button, click on the "SQL" button 4) Paste the sql command below, replacing the SELECT; SELECT RegionalAbsorption.CommodityCode AS Row, RegionalAbsorption.IndustryCode AS Col, [ForeignImportProportion]*[GrossAbsorptionCoefficient]*[Output] AS ForeignImportValue, [ForeignImportProportion]*[RPC]*[Output] AS DomesticImportValue FROM StudyAreaOutput INNER JOIN RegionalAbsorption ON StudyAreaOutput.IndustryCode = RegionalAbsorption.IndustryCode; The above creates an import matrix for industry (column) importing commodities (row) from either foreign or domestic sources (values in millions). 5) In a new query paste the below command, replacing the SELECT; SELECT RegionalAbsorption.CommodityCode AS Row, StudyAreaFinalDemand.TypeCode AS Col, [ForeignImportProportion]*[GrossAbsorptionCoefficient]*[GrossFinalDemand] AS ForeignImportValue, [ForeignImportProportion]*[RPC]*[GrossFinalDemand] AS DomesticImportValue FROM RegionalAbsorption INNER JOIN StudyAreaFinalDemand ON RegionalAbsorption.CommodityCode = StudyAreaFinalDemand.CommodityCode; The above create imports to final demands (columns). The Final demand type code definitions can be found in table "TypeCodesAll"
  • Avatar
    bfadali
    As a check after I do this, should I get row totals that are equal to the intermediate imports column in the commodity trade report for the first matrix and institutional imports for the second matrix (after I add up the foreign and domestic)? I don't seem to get that. Would this all work okay in an aggregated model?
  • Avatar
    DougO
    I believe if you add the row for both the domestic and foreign import that you should replicate the Intermediate and Institutional imports in the Commodity Trade report. I will have to try it now to check.
  • Avatar
    DougO
    Apparently I made mistake and a bad assumption. These check out. Industry import matrix: SELECT RegionalAbsorption.CommodityCode AS Row, RegionalAbsorption.IndustryCode AS Col, (1-[RPC])*[GrossAbsorptionCoefficient]*[Output] AS TotalImportValue, (1-[RPC])*[ForeignImportProportion]*[GrossAbsorptionCoefficient]*[Output] AS ForeignImportValue, ((1-[RPC])-(1-[RPC])*[ForeignImportProportion])*[GrossAbsorptionCoefficient]*[Output] AS DomesticImportValue FROM StudyAreaOutput INNER JOIN RegionalAbsorption ON StudyAreaOutput.IndustryCode = RegionalAbsorption.IndustryCode; Institutional import matrix: SELECT RegionalCommodityBalances.CommodityCode AS Row, StudyAreaFinalDemand.TypeCode AS Col, (1-[AverageRPC])*[GrossFinalDemand] AS TotalImportValue, [ForeignImportProportion]*[GrossFinalDemand] AS ForeignImportValue, (1-[DomesticRPC])*(1-[ForeignImportProportion])*[GrossFinalDemand] AS DomesticImportValue FROM RegionalCommodityBalances INNER JOIN StudyAreaFinalDemand ON RegionalCommodityBalances.CommodityCode = StudyAreaFinalDemand.CommodityCode; Sorry for the foulup.
  • Avatar
    bfadali
    Thank you Doug, this is great!
  • Avatar
    bfadali
    Is there any equally cool way to get the I by I import matrix? Also, using the above in the ACCESS database worked great on a disaggregated model but in my aggregated model it seemed to be off on the very last sector listed (as compared to the totals).
  • Avatar
    DougO
    If you update the software there are reports now for the commodity imports. For an IxI import matrix you would need to run the same queries but apply the results through the Market Share matrix [RegionalMarketShares].

Please sign in to leave a comment.