Spreadsheet: 66997d1267644631-excel-2007-table-structured-references-example
Sheet: Table Source

BASE CASE FORECAST (DUMMY DATA--SCENARIO PLANNING ONLY) |  |  |  |  |  | Revenue |  |  |  | Revenue |  |  | Gross Profit |  |  |  | Gross Profit |  |  | Opex--CDO |  |  |  | Opex--CDO |  |  | Opex--WWOPS |  |  |  | Opex--WWOPS |  |  | Opex--CA |  |  |  | Opex--CA |  |  | Opex--CMO |  |  |  | Opex--CMO |  |  | Opex--Finance |  |  |  | Opex--Finance |  |  | Opex--Operations |  |  |  | Opex--Operations |  |  | Opex--Other |  |  |  | Opex--Other |  |  | Opex--TOTAL |  |  |  | Opex--TOTAL |  |  | Contribution Margin  $ |  |  |  | Contribution Margin  $ |  |  | Contribution Margin  % |  |  |  | Contribution Margin  % |  |  |  |  |  |  |  |  | Constraints | Boston | 50
Council | Board | Category | Segment | Description |  | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 |  |  |  |  |  |  | 1000 | Philadelphia | 10
Council | Board | Category | Segment | Description | Column1 | 1Q11Revenue | 2Q11Revenue | 3Q11Revenue | 4Q11Revenue | FY11Revenue | FY12Revenue | FY13Revenue | 1Q11Gross Profit | 2Q11Gross Profit | 3Q11Gross Profit | 4Q11Gross Profit | FY11Gross Profit | FY12Gross Profit | FY13Gross Profit | 1Q11Opex--CDO | 2Q11Opex--CDO | 3Q11Opex--CDO | 4Q11Opex--CDO | FY11Opex--CDO | FY12Opex--CDO | FY13Opex--CDO | 1Q11Opex--WWOPS | 2Q11Opex--WWOPS | 3Q11Opex--WWOPS | 4Q11Opex--WWOPS | FY11Opex--WWOPS | FY12Opex--WWOPS | FY13Opex--WWOPS | 1Q11Opex--CA | 2Q11Opex--CA | 3Q11Opex--CA | 4Q11Opex--CA | FY11Opex--CA | FY12Opex--CA | FY13Opex--CA | 1Q11Opex--CMO | 2Q11Opex--CMO | 3Q11Opex--CMO | 4Q11Opex--CMO | FY11Opex--CMO | FY12Opex--CMO | FY13Opex--CMO | 1Q11Opex--Finance | 2Q11Opex--Finance | 3Q11Opex--Finance | 4Q11Opex--Finance | FY11Opex--Finance | FY12Opex--Finance | FY13Opex--Finance | 1Q11Opex--Operations | 2Q11Opex--Operations | 3Q11Opex--Operations | 4Q11Opex--Operations | FY11Opex--Operations | FY12Opex--Operations | FY13Opex--Operations | 1Q11Opex--Other | 2Q11Opex--Other | 3Q11Opex--Other | 4Q11Opex--Other | FY11Opex--Other | FY12Opex--Other | FY13Opex--Other | 1Q11Opex--TOTAL | 2Q11Opex--TOTAL | 3Q11Opex--TOTAL | 4Q11Opex--TOTAL | FY11Opex--TOTAL | FY12Opex--TOTAL | FY13Opex--TOTAL | 1Q11Contribution Margin  $ | 2Q11Contribution Margin  $ | 3Q11Contribution Margin  $ | 4Q11Contribution Margin  $ | FY11Contribution Margin  $ | FY12Contribution Margin  $ | FY13Contribution Margin  $ | 1Q11Contribution Margin  % | 2Q11Contribution Margin  % | 3Q11Contribution Margin  % | 4Q11Contribution Margin  % | FY11Contribution Margin  % | FY12Contribution Margin  % | FY13Contribution Margin  %
Boston | a | Base | Boston | a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Atlanta | 20
Philadelphia | b | Base | Philadelphia | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dallas | 24
Atlanta | c | Base | Atlanta | c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seattle | 5
Dallas | d | Base | Dallas | d
Seattle | e | Base | Seattle | e |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Funding Constraint | 400 | Total Funded | Total Rev/OPEX | Total Profit/OPEX |  | Number of Funded
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1400 | 1400 | 1400 | 1400 |  | 5800 | 6000 | 1375 | 1375 | 1375 | 1375 |  | 6000 | 6500 | 200 | 200 | 200 | 200 |  | 850 | 950 | 120 | 120 | 120 | 120 |  | 500 | 525
INVESTMENT ASKS (DUMMY DATA--SCENARIO PLANNING ONLY) |  |  |  |  |  | Revenue |  |  |  |  |  |  | Gross Profit |  |  |  |  |  |  | Opex--CDO |  |  |  |  |  |  | Opex--WWOPS |  |  |  |  |  |  | Opex--CA |  |  |  |  |  |  | Opex--CMO |  |  |  |  |  |  | Opex--Finance |  |  |  |  |  |  | Opex--Operations |  |  |  |  |  |  | Opex--Other |  |  |  |  |  |  | Opex--TOTAL |  |  |  |  |  |  | Contribution Margin  $ |  |  |  |  |  |  | Contribution Margin  % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | why didn't this list get updated
Council | Board | Category | Segment | [NAME] | Description Original | 1Q11 |  | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13 | Scenario |  |  |  | Cumulative Revenue | Cumulative Profit | Cumulative OPEX | Revenue/OPEX | Profit/OPEX | Rank Rev/OPEX | Rank Profit/OPEX | MacroFund |  |  | Scenario 1
Council | Board | Category | Segment | [NAME] | Description Original | 1Q11Revenue | 2Q11Revenue | 3Q11Revenue | 4Q11Revenue | FY11Revenue | FY12Revenue | FY13Revenue | 1Q11Gross Profit | 2Q11Gross Profit | 3Q11Gross Profit | 4Q11Gross Profit | FY11Gross Profit | FY12Gross Profit | FY13Gross Profit | 1Q11Opex--CDO | 2Q11Opex--CDO | 3Q11Opex--CDO | 4Q11Opex--CDO | FY11Opex--CDO | FY12Opex--CDO | FY13Opex--CDO | 1Q11Opex--WWOPS | 2Q11Opex--WWOPS | 3Q11Opex--WWOPS | 4Q11Opex--WWOPS | FY11Opex--WWOPS | FY12Opex--WWOPS | FY13Opex--WWOPS | 1Q11Opex--CA | 2Q11Opex--CA | 3Q11Opex--CA | 4Q11Opex--CA | FY11Opex--CA | FY12Opex--CA | FY13Opex--CA | 1Q11Opex--CMO | 2Q11Opex--CMO | 3Q11Opex--CMO | 4Q11Opex--CMO | FY11Opex--CMO | FY12Opex--CMO | FY13Opex--CMO | 1Q11Opex--Finance | 2Q11Opex--Finance | 3Q11Opex--Finance | 4Q11Opex--Finance | FY11Opex--Finance | FY12Opex--Finance | FY13Opex--Finance | 1Q11Opex--Operations | 2Q11Opex--Operations | 3Q11Opex--Operations | 4Q11Opex--Operations | FY11Opex--Operations | FY12Opex--Operations | FY13Opex--Operations | 1Q11Opex--Other | 2Q11Opex--Other | 3Q11Opex--Other | 4Q11Opex--Other | FY11Opex--Other | FY12Opex--Other | FY13Opex--Other | 1Q11Opex--TOTAL | 2Q11Opex--TOTAL | 3Q11Opex--TOTAL | 4Q11Opex--TOTAL | FY11Opex--TOTAL | FY12Opex--TOTAL | FY13Opex--TOTAL | 1Q11Contribution Margin  $ | 2Q11Contribution Margin  $ | 3Q11Contribution Margin  $ | 4Q11Contribution Margin  $ | FY11Contribution Margin  $ | FY12Contribution Margin  $ | FY13Contribution Margin  $ | 1Q11Contribution Margin  % | 2Q11Contribution Margin  % | 3Q11Contribution Margin  % | 4Q11Contribution Margin  % | FY11Contribution Margin  % | FY12Contribution Margin  % | FY13Contribution Margin  % | Scenario |  |  |  | Cumulative Revenue | Cumulative Profit | Cumulative OPEX | Revenue/OPEX | Profit/OPEX | Rank Rev/OPEX | Rank Profit/OPEX | MacroFund |  |  | Scenario 1
Boston |  |  | Boston |  |  | 5 | 10 | 25 | 40 |  | 125 | 275 |  |  |  |  |  |  |  | 4 | 4 | 6 | 7 |  | 25 | 30 | 3 | 3 | 4 | 8 |  | 25 | 30 | 1 | 1 | 1.2 | 1.2 |  | 5 | 7 | 0.5 | 0.5 | 0.75 | 0.75 |  | 4 | 4 | 0.1 | 0.1 | 0.1 | 0.1 |  | 0.75 | 0.75 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | Cumulative Revenue | Cumulative Profit | Cumulative OPEX | Revenue/OPEX | Profit/OPEX | Rank Rev/OPEX | Rank Profit/OPEX | MacroFund |  |  | Scenario 1
Boston |  |  | Boston |  |  | 4 | 20 | 30 | 50 |  | 175 | 300 |  |  |  |  |  |  |  | 1 | 1 | 1 | 2 |  | 7 | 7 | 4 | 4.5 | 5 | 5 |  | 25 | 40 | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 2 | 2 | 4 |  | 10 | 10 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Boston |  |  | Boston |  |  | 1 | 3 | 3 | 8 |  | 50 | 100 |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 |  | 1.5 | 1.5 | 1 | 1 | 1 | 1 |  | 6 | 7 | 0.5 | 0.5 | 0.5 | 0.5 |  | 2.5 | 3 | 0.75 | 0.75 | 1 | 1 |  | 3.5 | 3.5 | 0.5 | 0.5 | 0.5 | 0.5 |  | 2 | 2 | 0.15 | 0.15 | 0.15 | 0.15 |  | 0.75 | 1 | 0.25 | 0.25 | 0.25 | 0.25 |  | 1.25 | 1.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
Boston |  |  | Boston |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  | 1 | 1 | 2 | 3 |  | 7 | 9 | 2 | 2 | 2 | 2 |  | 8 | 8 | 1 | 1 | 1 | 1 |  | 5 | 7 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 | 1 | 1 |  | 5 | 7 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
Boston |  |  | Boston |  |  | 4 | 6 | 8 | 9 |  | 32 | 88 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 3 | 3 | 3 | 3 |  | 12 | 12 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0.5 | 0.75 | 1 | 1.25 |  | 6 | 7 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0.25 | 0.25 | 0.25 | 0.25 |  | 0.5 | 0.5 | 0.25 | 0.25 | 0.25 | 0.25 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0
Boston |  |  | Boston |  |  | 8 | 9 | 15 | 21 |  | 52 | 88 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 2 | 2 | 4 | 7 |  | 18 | 21 | 1 | 1 | 1 | 1 |  | 5 | 8 | 1 | 1 | 1 | 2 |  | 7 | 7 | 1 | 1 | 1 | 1 |  | 4 | 4 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Boston |  |  | Boston |  |  | 4 | 6 | 6 | 8 |  | 79 | 159 |  |  |  |  |  |  |  | 2 | 2 | 3 | 4 |  | 14 | 16 | 1 | 2 | 2 | 2 |  | 3 | 4 | 3 | 3 | 3 | 4 |  | 15 | 19 | 2 | 2 | 2 | 2 |  | 4 | 5 | 0 | 0 | 1 | 1 |  | 2 | 3 | 2 | 2 | 2 | 2 |  | 9 | 9 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0
Boston |  |  | Boston |  |  | 6 | 8 | 8 | 8 |  | 104 | 215 |  |  |  |  |  |  |  | 4 | 4 | 5 | 6 |  | 21 | 25 | 2 | 2 | 2 | 2 |  | 7 | 12 | 2 | 5 | 6 | 7 |  | 15 | 14 | 1 | 1 | 1 | 2 |  | 5 | 6 | 0 | 0 | 0 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 9 | 9 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
Philadelphia |  |  | Philadelphia |  |  | 9 | 11 | 15 | 18 |  | 175 | 310 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 | 1 | 1 |  | 22 | 28 | 4 | 4 | 4 | 4 |  | 18 | 21 | 3 | 3 | 3 | 3 |  | 13 | 14 | 1 | 1 | 1 | 1 |  | 5 | 8 | 1 | 1 | 1 | 2 |  | 4 | 5 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0
Philadelphia |  |  | Philadelphia |  |  | 5 | 10 | 15 | 25 |  | 75 | 100 |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.75 | 0.75 |  | 3 | 3 | 1 | 1 | 1 | 1 |  | 5 | 5 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0.25 | 0.25 | 0.25 | 0.25 |  | 1.25 | 1.25 | 0.75 | 0.75 | 0.75 | 1 |  | 5 | 5 | 0.5 | 0.5 | 0.5 | 0.5 |  | 3 | 3 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
Dallas |  |  | Dallas |  |  | 3 | 5 | 5 | 7 |  | 58 | 99 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 2 | 2 | 2 | 2 |  | 9 | 12 | 1 | 1 | 1 | 1 |  | 5 | 6 | 2 | 2 | 2 | 2 |  | 8 | 8 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0
Dallas |  |  | Dallas |  |  | 3 | 3 | 4 | 4 |  | 21 | 48 |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 |  | 3 | 3 | 3 | 3 | 3 | 3 |  | 1 | 1 | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 | 1 | 1 |  | 4 | 4 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
Dallas |  |  | Dallas |  |  | 1 | 1 | 1 | 2 |  | 55 | 310 |  |  |  |  |  |  |  | 4 | 4 | 4 | 5 |  | 12 | 10 | 5 | 5 | 5 | 5 |  | 25 | 28 | 3 | 3 | 3 | 3 |  | 14 | 14 | 3 | 3 | 3 | 3 |  | 14 | 14 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Atlanta |  |  | Atlanta |  |  | 5 | 15 | 21 | 28 |  | 150 | 530 |  |  |  |  |  |  |  | 9 | 9 | 13 | 15 |  | 36 | 23 | 5 | 5 | 5 | 5 |  | 20 | 20 | 7 | 7 | 7 | 7 |  | 20 | 20 | 2 | 2 | 2 | 2 |  | 9 | 12 | 1 | 1 | 1 | 1 |  | 4 | 4 | 2 | 2 | 2 | 3 |  | 11 | 14 | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Atlanta |  |  | Atlanta |  |  | 2 | 2 | 2 | 3 |  | 15 | 21 |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 |  | 2 | 3 | 0.25 | 0.25 | 0.5 | 0.5 |  | 3 | 3 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
Atlanta |  |  | Atlanta |  |  | 5 | 5 | 7 | 12 |  | 78 | 215 |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.5 | 0.5 |  | 2 | 2 | 0.5 | 0.5 | 0.5 | 0.5 |  | 2 |  | 0.75 | 0.75 | 0.75 | 0.75 |  | 3 | 3 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Atlanta |  |  | Atlanta |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 |  | 1 | 1 | 1 | 1 | 2 | 2 |  | 3 | 3 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Atlanta |  |  | Atlanta |  |  | 0 | 0 | 0 | 0 |  | 25 | 180 |  |  |  |  |  |  |  | 9 | 9 | 9 | 9 |  | 25 | 25 | 0 | 0 | 0 | 0 |  | 3 | 7 | 0 | 0 | 0 | 0 |  | 12 | 15 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Atlanta |  |  | Atlanta |  |  | 0 | 0 | 0 | 0 |  | 47 | 249 |  |  |  |  |  |  |  | 4 | 4 | 4 | 4 |  | 18 | 21 | 0 | 0 | 0 | 0 |  | 11 | 15 | 0 | 0 | 0 | 0 |  | 12 | 15 | 0 | 0 | 0 | 0 |  | 2 | 4 | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 | 1 | 1 |  | 2 | 2 | 0.5 | 0.5 | 0.5 | 0.5 |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
Atlanta |  |  | Atlanta |  |  | 4 | 4 | 4 | 4 |  | 89 | 280 |  |  |  |  |  |  |  | 15 | 15 | 15 | 15 |  | 50 | 40 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 | 1 | 1 |  | 7 | 12 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Atlanta |  |  | Atlanta |  |  | 2 | 2 | 3 | 4 |  | 35 | 115 |  |  |  |  |  |  |  | 3 | 3 | 3 | 3 |  | 15 | 15 | 2 | 2 | 2 | 2 |  | 8 | 8 | 0 | 0 | 0 | 1 |  | 2 | 2 | 0.5 | 0.5 | 0.5 | 0.5 |  | 3 | 4 | 0.25 | 0.25 | 0.25 | 0.25 |  | 1 | 1 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
Connected Architecture |  |  | Atlanta |  |  | 0 | 0 | 1 | 2 |  | 15 | 270 |  |  |  |  |  |  |  | 2 | 2 | 2 | 2 |  | 8 | 11 | 1 | 1 | 1 | 1 |  | 2 | 2 | 0.25 | 0.25 | 0.25 | 0.25 |  | 1 | 1 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Connected Architecture |  |  | Boston |  |  | 2 | 2 | 2 | 2 |  | 17 | 210 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 2 | 2 | 2 | 2 |  | 4 | 4 | 0 | 0 | 0 | 0 |  | 0 | 0 | 1 | 1 | 1 | 1 |  | 6 | 7 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Emerging Solutions |  |  | Boston |  |  | 1 | 3 | 7 | 11 |  | 125 | 532 |  |  |  |  |  |  |  | 13 | 14 | 17 | 21 |  | 75 | 80 | 5 | 5 | 5 | 5 |  | 15 | 21 | 2 | 2 | 2 | 2 |  | 11 | 15 | 1 | 1 | 1 | 1 |  | 3 | 5 | 0 | 0 | 0 | 0 |  | 3 | 5 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0
Emerging Solutions |  |  | Boston |  |  | 12 | 15 | 21 | 45 |  | 256 | 490 |  |  |  |  |  |  |  | 15 | 15 | 15 | 15 |  | 55 | 92 | 1 | 1 | 1 | 1 |  | 2 | 5 | 5 | 5 | 5 | 5 |  | 6 | 12 | 3 | 3 | 3 | 3 |  | 15 | 15 | 0 | 0 | 0 | 0 |  | 3 | 5 | 1 | 1 | 1 | 1 |  | 2 | 2 | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
Emerging Solutions |  |  | Boston |  |  | 4 | 5 | 7 | 11 |  | 125 | 278 |  |  |  |  |  |  |  | 3 | 3 | 3 | 3 |  | 10 | 7 | 0 | 0 | 0 | 0 |  | 1 | 3 | 1.5 | 1.5 | 1.5 | 1.5 |  | 7 | 7 | 2 | 2 | 2 | 2 |  | 8 | 8 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 1