SAM108

The SAM108 works off of the SAM120 and was made by aggregating sectors.  The steps taken for this is described below.

Necessary file:

SAM, CCM, 108_Excel.xls

Steps for aggregating SAM:

1. Paste large SAM into worksheet LargeSAM.

2. Paste list of large SAM sectors into column A of this worksheet.

3. Paste list of large SAM sectors into row 3 of worksheet CombineRowsSAM.

4. Paste list of small SAM sectors into column A of worksheet CombineRowsSAM.

5. Match small SAM sectors in column B of this worksheet with the large SAM sectors.

6. Copy matching small SAM sectors in column B of this worksheet, paste in row 1 of worksheet CombineRowsSAM.

7. Make sure that all the relevant cells in worksheet CombineRowsSAM have a formula.

8. Paste list of small SAM sectors into column A and row 2 of worksheet SmallSAM.

9. Make sure that all the relevant cells in worksheet SmallSAM have a formula.