Spreadsheet: 59721d1260294452-sumproduct-returning-incorrect-value-sample
Sheet: Cost Centre View

Team | Team | Initiative Type | Saving | Project | F07 | F08 | F09 | [NAME] (000's) |  |  |  |  |  |  |  |  |  |  |  | F10 Total | F11 (000's) | Planned Impl. Date | Status | Type | Start Date | Project #
 |  |  |  |  |  |  |  | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST
 |  |  |  |  |  |  |  | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
Client Services | Client Services | LEAN/Broken Windows | Run Rate Reduction | Project 1 |  |  |  | 0 | 0 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 | 41.7 | 50.04 | 2010-01-01 00:00:00 | G | WIP | 2009-09-01 00:00:00 | 200909-441
 | Client Services | LEAN/Broken Windows | Run Rate Reduction | Project 2 |  |  |  | 0 | 0 | 0 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 45 | 60 | 2010-02-01 00:00:00 | G | Comp | 2009-10-01 00:00:00 | 200910-452
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 1.523 | 1.802 | 2.081 | 2.879 | 2.879 | 2.879 | 3.318 | 4.954 | 4.954 | 4.954 | 5.352 | 5.512 | 43.088
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 3.124 | 3.696 | 4.269 | 5.905 | 5.905 | 5.905 | 6.805 | 10.159 | 10.159 | 10.159 | 10.977 | 11.305 | 88.369
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0.727 | 0.861 | 0.994 | 1.375 | 1.375 | 1.375 | 1.585 | 2.366 | 2.366 | 2.366 | 2.556 | 2.633 | 20.58
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0.092 | 0.109 | 0.126 | 0.174 | 0.174 | 0.174 | 0.2 | 0.299 | 0.299 | 0.299 | 0.323 | 0.333 | 2.6
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 2.362 | 2.795 | 3.228 | 4.466 | 4.466 | 4.466 | 5.146 | 7.683 | 7.683 | 7.683 | 8.302 | 8.549 | 66.83
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 2.334 | 2.761 | 3.189 | 4.412 | 4.412 | 4.412 | 5.084 | 7.59 | 7.59 | 7.59 | 8.201 | 8.445 | 66.018
Target |  |  | Capacity Creation
Client Services | Client Services | LEAN/Broken Windows | Run Rate Reduction | Project 3 |  |  |  | 0 | 0 | 0 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 | 118.8 | 158.4 | 2010-02-01 00:00:00 | G | Comp | 2009-03-01 00:00:00 | 200903-388
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0.419 | 0.496 | 0.572 | 0.792 | 0.792 | 0.792 | 0.913 | 1.362 | 1.362 | 1.362 | 1.472 | 1.516 | 11.85
Target |  |  | Capacity Creation
Total Run Rate |  |  |  |  |  |  |  | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
Total Cap Creation |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target |  |  | Run Rate Reduction |  |  |  |  | 10.581 | 12.52 | 14.459 | 20.003 | 20.003 | 20.003 | 23.051 | 34.413 | 34.413 | 34.413 | 37.183 | 38.293 | 299.335
Total Completed |  |  |  |  |  |  |  | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
DTO - US | DTO - US |  | Run Rate Reduction
 | DTO - US |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 1.557 | 1.842 | 2.127 | 2.943 | 2.943 | 2.943 | 3.391 | 5.063 | 5.063 | 5.063 | 5.47 | 5.633 | 44.037
Target |  |  | Capacity Creation
Total Run Rate |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cap Creation |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target |  |  | Run Rate Reduction |  |  |  |  | 1.557 | 1.842 | 2.127 | 2.943 | 2.943 | 2.943 | 3.391 | 5.063 | 5.063 | 5.063 | 5.47 | 5.633 | 44.037
Total Completed |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total Run Rate |  |  |  |  |  |  |  | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
Grand Total Cap Creation |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 18.2 | 163.8 | 218.4
Grand Total Target |  |  |  |  |  |  |  | 12.138 | 14.362 | 16.586 | 22.946 | 22.946 | 22.946 | 26.442 | 39.47600000000001 | 39.47600000000001 | 39.47600000000001 | 42.653 | 43.926 | 343.372
Net |  |  |  |  |  |  |  | -12.138 | -14.362 | -16.586 | -4.746000000000002 | -4.746000000000002 | -4.746000000000002 | -8.242 | -21.27600000000001 | -21.27600000000001 | -21.27600000000001 | -24.453 | -25.726 | -179.572
FTE Benefits
Team | Team | Initiative Type | Saving | Project | F07 | F08 | F09 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | F10 Total | Planned Impl. Date | Status | Type | Start Date |  | Project # | FTE Name
 |  |  |  |  |  |  |  | ACT | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST | FCST
 |  |  |  |  |  |  |  | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0.1 | 0.1 | 0.3 | 0.3 | 0.3 | 0.4 | 0.8 | 0.8 | 0.8 | 0.9 | 1 | 0.5
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0.1 | 0.3 | 0.7 | 0.7 | 0.7 | 0.9 | 1.7 | 1.7 | 1.7 | 1.9 | 2 | 1
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0 | 0.1 | 0.2 | 0.2 | 0.2 | 0.2 | 0.4 | 0.4 | 0.4 | 0.4 | 0.5 | 0.2
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0.1 | 0
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0.1 | 0.2 | 0.5 | 0.5 | 0.5 | 0.7 | 1.3 | 1.3 | 1.3 | 1.4 | 1.5 | 0.8
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0.1 | 0.2 | 0.5 | 0.5 | 0.5 | 0.7 | 1.3 | 1.3 | 1.3 | 1.4 | 1.5 | 0.8
Target |  |  | Capacity Creation
Client Services | Client Services |  | Run Rate Reduction
 | Client Services |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0 | 0 | 0.1 | 0.1 | 0.1 | 0.1 | 0.2 | 0.2 | 0.2 | 0.3 | 0.3 | 0.1
Target |  |  | Capacity Creation
Total Run Rate |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cap Creation |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0.4 | 0.8999999999999999 | 2.3 | 2.3 | 2.3 | 3 | 5.7 | 5.7 | 5.7 | 6.399999999999999 | 6.899999999999999 | 3.4
Total |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DTO - US | DTO - US |  | Run Rate Reduction
 | DTO - US |  | Capacity Creation
Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0.1 | 0.1 | 0.3 | 0.3 | 0.3 | 0.4 | 0.8 | 0.8 | 0.8 | 0.9 | 1 | 0.5
Target |  |  | Capacity Creation
Total Run Rate |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cap Creation |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Target |  |  | Run Rate Reduction |  |  |  |  | 0 | 0.1 | 0.1 | 0.3 | 0.3 | 0.3 | 0.4 | 0.8 | 0.8 | 0.8 | 0.9 | 1 | 0.5
Total |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total Run Rate |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total Cap Creation |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total Target |  |  |  |  |  |  |  | 0 | 0.5 | 0.9999999999999999 | 2.6 | 2.6 | 2.6 | 3.4 | 6.5 | 6.5 | 6.5 | 7.3 | 7.899999999999999 | 3.9
Net |  |  |  |  |  |  |  | 0 | -0.5 | -0.9999999999999999 | -2.6 | -2.6 | -2.6 | -3.4 | -6.5 | -6.5 | -6.5 | -7.3 | -7.899999999999999 | -3.9