To extract all multipliers at once in Excel?
Hi, I have tried exported all multiplier results in csv file to excel but when I opened the excel, all is not in the order, even it is difficult to apply pivot table in Excel. Do you have any idea how to construct the multiplier table easily directly using excel after exporting all multipliers to csv file?
Gimel Israel
-
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. -
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. -
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. -
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.
Comments
4 comments