Workbook: ROW.xls

 

Notes / Method:

 

·         The sheet ‘Raw from IMPLAN—ea040’ is simply the raw data from IMPLAN

·         The sheet ‘Mapping’ maps the IMPLAN data to the SAM’s industry sectors.

·         The sheet ‘Pivot’ aggregates the IMPLAN data under the SAM’s industry sectors and calculates the ratio of exports to imports for each sector.

·         The sheet ‘ROW’ organizes the data for export to the SAM.