To extract all multipliers at once in Excel?

Comments

4 comments

  • Avatar
    IMPLAN Support
    Hello Gimel, Please see this [url=http://implan.com/v4/index.php?option=com_content&view=article&id=699:how-to-create-a-pivot-table-&catid=266:faq-videos&Itemid=50 ]video [/url]for how to create a pivot table.
  • Avatar
    Gimel
    Thanks but actually I knew how to use Pivot table in that SAM/IO because the output is organized in a perfect rectangular and all columns have exactly the right values. However when I did aggregation 2 Digit NAICS and then compute the multipliers and try to export all the multipliers, the result in csv such a mess that I didn't know how to use the pivot table in that situation. Maybe there's a trick that I didn't know and somebody here knows it better. Thanks, Gimel.
  • Avatar
    IMPLAN Support
    Hi Gimel, The value columns represent the Direct & Indirect (Col E), the Induced (Col F) and Direct & Indirect & Induced (Col G - totals). So in order to pivot the table you will need to decide which values you want (probably column G) and delete the other two columns. Otherwise this table is not amenable to pivoting because since there are 3 types of multipliers listed. It is in effect too many dimensions. The first 20 rows (if aggregated to 2-digit NAICS) are identical to the screen you see when you go to Explore > Multipliers > Detail Multipliers tab (with the first sector listed in the drop-down menu). The next 20 lines will then be identical to the screen you see when you select the second sector from the drop-down menu. And so on for all sectors in the drop-down menu. The export basically stacks each of these views on top of one-another all in one file so they can be viewed together. If you do not want to delete any of the columns, you will have to work with them all in a single csv table.
  • Avatar
    Gimel
    Hi I found how to solve the problem. My problem comes from the first name of the aggregation: " 11. Agr, Fishery , .... " which when I exported to csv file and using delimited comma, this will create several columns just for every row that contains "11. Agr ..." . Therefore I just renamed this sector alone, eliminating the names without comma and when I extract that again, everything is fine. So the aggregation name using comma caused some problems in excel especially when I want to extract all multipliers directly from IMPLAN.

Please sign in to leave a comment.