Spreadsheet: 231058d1366927540-conditional-formatting-supply-example3
Sheet: example

 |  |  | 2013 |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
Seat Balance | Long/Short
Seat Supply | Building | Initial HC | 2Q 2013 | 3Q 2013 | 4Q 2013 | 1Q 2014 | 2Q 2014 | 3Q 2014 | 4Q 2014 | 1Q 2015 | 2Q 2015 | 3Q 2015 | 4Q 2015 | 1Q 2016 | 2Q 2016
 | 1 | 2749 | 2749 | 2749 | 2749 | 2749 | 2749 | 2749 | 2749 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | 86 | 86 | 86 | 86 | 86 | 86 | 86 | 86 | 86 | 86 | 86 | 86 | 86 | 86
 | 3 | 422 | 422 | 422 | 422 | 422 | 422 | 422 | 422 | 422 | 422 | 422 | 422 | 422 | 422
 | 4 | 407 | 407 | 407 | 407 | 407 | 407 | 407 | 407 | 407 | 407 | 407 | 407 | 407 | 407
 | 5 | 754 | 754 | 754 | 754 | 754 | 754 | 754 | 754 | 754 | 754 | 754 | 754 | 754 | 754
 | 6 | 531 | 299 | 299 | 299 | 299 | 299 | 299 | 299 | 299 | 299 | 144 | 144 | 144 | 144
 | 7 | 186 | 186 | 186 | 186 | 186 | 186 | 186 | 186 | 186 | 0 | 0 | 0 | 0 | 0
 | 8 | 538 | 538 | 538 | 538 | 538 | 538 | 538 | 538 | 538 | 538 | 538 | 538 | 538 | 538
 | 9 | 742 | 742 | 742 | 742 | 742 | 742 | 742 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 11 | 927 | 927 | 927 | 927 | 927 | 927 | 927 | 927 | 927 | 927 | 927 | 927 | 927 | 927
 | 12 | 539 | 539 | 539 | 539 | 539 | 539 | 489 | 489 | 579 | 579 | 579 | 579 | 579 | 579
 | 13 | 680 | 680 | 680 | 680 | 680 | 680 | 680 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 14 | 896 | 896 | 896 | 896 | 896 | 896 | 896 | 896 | 896 | 896 | 896 | 0 | 0 | 0
 | 15 | 413 | 413 | 413 | 214 | 214 | 214 | 214 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 16 | 56 | 56 | 56 | 56 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 17 | 386 | 386 | 386 | 386 | 386 | 386 | 386 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 18 | 720 | 720 | 720 | 720 | 720 | 720 | 720 | 720 | 720 | 0 | 0 | 0 | 0 | 0
 | 19 | 514 | 514 | 514 | 514 | 514 | 514 | 514 | 514 | 514 | 514 | 514 | 0 | 0 | 0
 | Cumulative Seat Supply  (ALL Sites) | 12646 | 12414 | 12414 | 12215 | 12215 | 12159 | 11009 | 8987 | 6328 | 5422 | 5267 | 3857 | 3857 | 3857
Seat Demand | Building | Initial HC | 2Q 2013 | 3Q 2013 | 4Q 2013 | 1Q 2014 | 2Q 2014 | 3Q 2014 | 4Q 2014 | 1Q 2015 | 2Q 2015 | 3Q 2015 | 4Q 2015 | 1Q 2016 | 2Q 2016
 | 1 | 2156 | 2156 | 2156 | 2156 | 2156 | 1651 | 1651 | 1141 | -146 | -146 | -146 | -146 | -146 | -146
 | 2 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76 | 76
 | 3 | 381 | 381 | 381 | 381 | 381 | 381 | 381 | 334 | 334 | 334 | 334 | 334 | 334 | 334
 | 4 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352 | 352
 | 5 | 528 | 528 | 528 | 528 | 528 | 528 | 528 | 528 | 528 | 528 | 528 | 528 | 528 | 528
 | 6 | 316 | 316 | 316 | 316 | 311 | 278 | 278 | 150 | -15 | -15 | -15 | -15 | -15 | -15
 | 7 | 134 | 134 | 134 | 134 | 120 | 102 | 102 | -57 | -57 | -57 | -57 | -57 | -57 | -57
 | 8 | 468 | 468 | 468 | 468 | 468 | 477 | 477 | 447 | 615 | 615 | 615 | 615 | 615 | 615
 | 9 | 554 | 554 | 554 | 554 | -1 | -118 | -118 | -118 | -118 | -118 | -118 | -118 | -118 | -118
 | 10 | 888 | 888 | 888 | 888 | 794 | -177 | -177 | -177 | -177 | -177 | -177 | -177 | -177 | -177
 | 11 | 774 | 774 | 774 | 774 | -119 | 762 | 762 | 740 | 46 | 46 | 46 | 46 | 46 | 46
 | 12 | 466 | 466 | 466 | 466 | 439 | 168 | 168 | -58 | -58 | -58 | -58 | -58 | -58 | -58
 | 13 | 634 | 634 | 634 | 634 | 634 | 574 | 574 | 94 | 94 | 94 | 94 | 94 | 94 | 94
 | 14 | 736 | 736 | 736 | 736 | 736 | 695 | 695 | 677 | 130 | 130 | 130 | 130 | 130 | 130
 | 15 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172 | 172
 | 16 | 51 | 51 | 51 | 51 | 51 | -38 | -38 | -38 | -38 | -38 | -38 | -38 | -38 | -38
 | 17 | 333 | 333 | 333 | 333 | 333 | 95 | 95 | 95 | 95 | 95 | 95 | 95 | 95 | 95
 | 18 | 604 | 604 | 604 | 604 | 604 | 537 | 537 | -58 | -58 | -58 | -58 | -58 | -58 | -58
 | 19 | 454 | 454 | 454 | 454 | 454 | 454 | 454 | 454 | 454 | 454 | 454 | 454 | 454 | 454
 | Seat Demand - ALL Sites (OCF FF not included in Demand) | 10077 | 10077 | 10077 | 10077 | 8489 | 6969 | 6969 | 4754 | 2229 | 2229 | 2229 | 2229 | 2229 | 2229