Raw Transactions Table

Follow

redicank

• October 13, 2016 14:23

One thing that I can't quite figure out in this software is where to find the transactions table that would provide how each industry interacts with each other by purchases. I can find it for an individual industry and how each industry spends money in the region but what I was looking for is the matrix that shows the massive overview. I want to use the detailed industry (i.e. 1. Oilseed farming) not just the aggregated form (i.e. 11. Agriculture). Is there a way to do this without having to combine 526 different excel exports and just get the one big table? Thank you, K

0

• 

  IMPLAN Support

  • October 13, 2016 15:30

  Hello Kyle, You can export the Industry Detail SAM by opening your model and navigating to Industry Accounts > IxI Social Accounting Matrix > Export > Industry Detail SAM Files > IxI Industry Detail, Row Detail. Regards, IMPLAN Staff

  0

  Comment actions Permalink
• 

  redicank

  • October 13, 2016 15:45

  Thank you for this information. When I pull up my social accounts it only offers the IxC. The closest thing I found to that is when I go to IxC Input Output Accounts and export Full Detail IO Accounts. This table looks like the direct requirements table more so than the transactions table. Is there something that I am missing here?

  0

  Comment actions Permalink
• 

  IMPLAN Support

  • October 13, 2016 16:38

  Hello Kyle, Our apologies. The first step should read "…navigating to Industry Accounts…", not "Social Accounts". We have corrected our previous post. Regards, IMPLAN Staff

  0

  Comment actions Permalink
• 

  redicank

  • October 17, 2016 15:47

  This was helpful and gave me a lot of the important tables I was looking for. The only table I cannot seem to find is the raw transactions table. The tables I am able to pull out of this are direct requirements, but I am looking to get the raw transactions table to make sure the coefficients are right. Which export would that be? Thank you so much for all your help!

  0

  Comment actions Permalink
• 

  redicank

  • October 17, 2016 18:44

  I guess the main issue I am having here is finding a way to export the information that has how much each industry is spending on other industries. The IxI row detail only provides a decimal number in most cases. Is this because it is showing the fraction that it is of the total, or is the number in billions of dollars? An industry by industry real dollars spent is the table that I am looking for. Thanks!

  0

  Comment actions Permalink
• 

  IMPLAN Support

  • October 18, 2016 12:46

  Hello Kyle, Don't worry about the cross post; this response will be placed in both threads. The IxI Industry Detail Row Detail SAM is in millions of dollars. The IxI Transaction table (located in Industry Accounts > Reports Tab > Export > Structural Matrices Elements > Regional IxI Transactions) is in dollars. The IxI Direct Coefficients table is the "A" matrix, and the values presented are coefficients. If you have a question or concern regarding the data values, we are happy look into it if can provide the study region, data year, and industry/commodity of interest. Regards, IMPLAN Staff

  0

  Comment actions Permalink
• 

  redicank

  • October 18, 2016 18:37

  This was exactly what I needed. Thank you so much for your help!

  0

  Comment actions Permalink
• 

  IMPLAN Support

  • October 18, 2016 20:35

  You are most welcome. Regards, IMPLAN Staff

  0

  Comment actions Permalink
• 

  ppeltzer

  • March 27, 2017 23:43

  Hi, Is it possible to download a detailed Industry by Industry Input-Output Matrix with only an online account? I can't find a place to export detailed matrices. Thanks, Paige

  0

  Comment actions Permalink
• 

  IMPLAN Support

  • March 28, 2017 15:35

  Hi Paige! Thank you for your forum post. Unfortunately, our IMPLAN Online Software does not contain the table that you are looking to export. I have sent you an email to further discuss.

  0

  Comment actions Permalink
• 

  ppeltzer

  • March 28, 2017 16:38

  Thank you! I have not located your email.. was it sent to my personal email listed on my account, or is there a messaging function on this website that I have not located? Thanks!

  0

  Comment actions Permalink
• 

  ebowen

  • January 23, 2018 20:30

  This is a bit of a dead thread, but I too would like to export the IxI I-O Matrix from an online account. Has this been added since this posting?

  0

  Comment actions Permalink

Please sign in to leave a comment.