Workbook: V0304.xls (also Aggregate Make Matrix.xls and Aggregate Use Matrix.xls)

 

Notes / Method:

 

·         First, open the ‘Aggregate Make Matrix.xls’ workbook.  The far right hand sheet, ‘US 1997 Aggregate_Make_Matrix’ is a copy of the ‘Aggregate Make Matrix numbers.xls’ file as output from Access.  This is only a 90x90 matrix, as it omits the one-to-many retail, wholesale, and ACC sectors.  The intent of the rest of the workbook is to expand this matrix to the full 106x106 US 1997 Make matrix.

·         The sheets ‘Wage ratios’ and ‘Wage ratios transpose’ are copies of the ‘Wage ratios’ sheet from the ‘ES 202 Dram Summary.xls’ workbook.

·         The sheet ‘Horizontal Expansion’ expands the matrix to a 90x106 matrix by estimating values for the one-to-many columns, which are highlighted in red on the sheet.  Using the retail columns (56-67) as an example, the estimates are calculated by allocating total retail commodity production from the 90x90 IO table to each retail sector on the basis of CA 2003 wages in each retail sector.

·         The sheet ‘Vertical Expansion’ expands the matrix from 90x106 to 106x106.  The method is the same as for the horizontal expansion above, except the allocations act on the rows instead of columns.

·         The sheet ‘US Make Matrix’ is the 106x106 1997 US Make matrix.  The only difference between this sheet and the ‘Vertical Expansion’ sheet is that values of unity have been plugged into the last two diagonal entries (cells (105,105) and (106,106)).  These entries will ensure that usage of LABOR and CAPITAL actually show up in the IO table.

·         This ‘Aggregate Use Matrix.xls’ workbook operates in an identical fashion to the ‘Aggregate Make Matrix.xls’ workbook, except there is no need for the final step of adding ones to the final two diagonal entries.