Spreadsheet: 465721d1465850769-auto-update-formula-in-subsequent-cells-book1
Sheet: Weekly Trends

Efforts / Week |  | Period: |  | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5a |  |  |  | Week 5b |  |  |  | Week 6 |  |  |  | Week 7 |  |  |  | Week 9 |  |  |  | Week 10a |  |  |  | Week 10b |  |  |  | Week 11 |  |  |  | Week 12 |  |  |  | Week 13 |  |  |  | Week 14 |  |  |  | Week 15 |  |  |  | Week 16 |  |  |  | Week 17 |  |  |  | Week 18 |  |  |  | Week 19a |  |  |  | Week 19b |  |  |  | Week 20 |  |  |  | Week 21 |  |  |  | Week 22 |  |  |  | Week 23a |  |  |  | Week 23b |  |  |  | Week 24 |  |  |  | Week 26 |  |  |  | Week 27 |  |  |  | Week 28 |  |  |  | Week 29 |  |  |  | Week 30
 |  | 01-Feb-16 To 31-Jan-17 |  | 2016-02-01 00:00:00 |  |  |  | 2016-02-08 00:00:00 |  |  |  | 2016-02-15 00:00:00 |  |  |  | 2016-02-22 00:00:00 |  |  |  | 2016-02-29 00:00:00 |  |  |  | 2016-03-01 00:00:00 |  |  |  | 2016-03-07 00:00:00 |  |  |  | 2016-03-14 00:00:00 |  |  |  | 2016-03-21 00:00:00 |  |  |  | 2016-03-28 00:00:00 |  |  |  | 2016-04-01 00:00:00 |  |  |  | 2016-04-04 00:00:00 |  |  |  | 2016-04-11 00:00:00 |  |  |  | 2016-04-18 00:00:00 |  |  |  | 2016-04-25 00:00:00 |  |  |  | 2016-05-02 00:00:00 |  |  |  | 2016-05-09 00:00:00 |  |  |  | 2016-05-16 00:00:00 |  |  |  | 2016-05-23 00:00:00 |  |  |  | 2016-05-30 00:00:00 |  |  |  | 2016-06-01 00:00:00 |  |  |  | 2016-06-06 00:00:00 |  |  |  | 2016-06-13 00:00:00 |  |  |  | 2016-06-20 00:00:00 |  |  |  | 2016-06-27 00:00:00 |  |  |  | 2016-07-01 00:00:00 |  |  |  | 2016-07-04 00:00:00 |  |  |  | 2016-07-11 00:00:00 |  |  |  | 2016-07-18 00:00:00 |  |  |  | 2016-07-25 00:00:00 |  |  |  | 2016-08-01 00:00:00 |  |  |  | 2016-08-08 00:00:00
 |  |  |  | 2016-02-05 00:00:00 |  |  |  | 2016-02-12 00:00:00 |  |  |  | 2016-02-19 00:00:00 |  |  |  | 2016-02-26 00:00:00 |  |  |  | 2016-02-29 00:00:00 |  |  |  | 2016-03-04 00:00:00 |  |  |  | 2016-03-11 00:00:00 |  |  |  | 2016-03-18 00:00:00 |  |  |  | 2016-03-25 00:00:00 |  |  |  | 2016-03-31 00:00:00 |  |  |  | 2016-04-01 00:00:00 |  |  |  | 2016-04-08 00:00:00 |  |  |  | 2016-04-15 00:00:00 |  |  |  | 2016-04-22 00:00:00 |  |  |  | 2016-04-29 00:00:00 |  |  |  | 2016-05-06 00:00:00 |  |  |  | 2016-05-13 00:00:00 |  |  |  | 2016-05-20 00:00:00 |  |  |  | 2016-05-27 00:00:00 |  |  |  | 2016-05-31 00:00:00 |  |  |  | 2016-06-03 00:00:00 |  |  |  | 2016-06-10 00:00:00 |  |  |  | 2016-06-17 00:00:00 |  |  |  | 2016-06-24 00:00:00 |  |  |  | 2016-06-30 00:00:00 |  |  |  | 2016-07-01 00:00:00 |  |  |  | 2016-07-08 00:00:00 |  |  |  | 2016-07-15 00:00:00 |  |  |  | 2016-07-22 00:00:00 |  |  |  | 2016-07-29 00:00:00 |  |  |  | 2016-08-05 00:00:00 |  |  |  | 2016-08-12 00:00:00
Available Hours |  |  |  | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore
 | Test Management
 | Test Execution |  |  |  |  |  |  |  | 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 |  |  |  | 0
 | Specilaized services |  |  | 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 | 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 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 1 | 0 | 0 |  | 0 | 0 | 0 |  | 2 | 0 | 0 |  | 0 | 0 | 0 |  | -0.666666666666667 | -1.16666666666667 | -1.66666666666667 |  | 0 | 0 | 0 |  | 3 | 0 | 0 |  | 4 | 0 | 0 |  | -2 | -3.5 | -5 |  | 5
 | Total Available Hours
Allocated Hours |  |  |  | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore
 | Test Management
 | Test Execution |  |  |  |  |  |  |  | 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 |  |  |  | 0
 | Specilaized services |  |  | 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 | 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 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 1 | 0 | 0 |  | 0 | 0 | 0 |  | 2 | 0 | 0 |  | 0 | 0 | 0 |  | -0.666666666666667 | -1.16666666666667 | -1.66666666666667 |  | 0 | 0 | 0 |  | 3 | 0 | 0 |  | 4 | 0 | 0 |  | -2 | -3.5 | -5 |  | 5
 | Total Allocated Hours
Actual Hours |  |  |  | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore | US | UK | Offshore | Nearshore
 | Test Management
 | Test Execution |  |  | 100 |  | 300 |  | 100 | 0 | 345 |  |  | 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
 | Specilaized services |  |  | 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 | 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 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 1 | 0 | 0 |  | 0 | 0 | 0 |  | 2 | 0 | 0 |  | 0 | 0 | 0 |  | -0.666666666666667 | -1.16666666666667 | -1.66666666666667 |  | 0 | 0 | 0 |  | 3 | 0 | 0 |  | 4 | 0 | 0 |  | -2 | -3.5 | -5 |  | 5
 | Total Actual Hours
Available Total Hours (Weekly) |  |  |  |  |  |  |  | 2015-10-23 00:00:00 | 2015-10-30 00:00:00 | 2015-11-06 00:00:00 | 2015-11-13 00:00:00 | 2015-11-20 00:00:00 | 2015-11-27 00:00:00 | 2015-11-30 00:00:00 | 2015-12-04 00:00:00 | 2015-12-11 00:00:00 | 2015-12-18 00:00:00 | 2015-12-25 00:00:00 | 2015-12-31 00:00:00 | 2016-01-08 00:00:00 | 2016-01-15 00:00:00 | 2016-01-22 00:00:00 | 2016-01-29 00:00:00 | 2016-02-05 00:00:00 | 2016-02-12 00:00:00 | 2016-02-19 00:00:00 | 2016-02-26 00:00:00
 | Available Hours
 | Actual Work Assigned
 | Hours Unutilized
 | [NAME]
Allocated Total Hours (Weekly) |  |  |  | 2015-10-02 00:00:00 | 2015-10-09 00:00:00 | 2015-10-12 00:00:00 | 2015-10-16 00:00:00 | 2015-10-23 00:00:00 | 2015-10-30 00:00:00 | 2015-11-06 00:00:00 | 2015-11-13 00:00:00 | 2015-11-20 00:00:00 | 2015-11-27 00:00:00 | 2015-11-30 00:00:00 | 2015-12-04 00:00:00 | 2015-12-11 00:00:00 | 2015-12-18 00:00:00 | 2015-12-25 00:00:00 | 2015-12-31 00:00:00 | 2016-01-08 00:00:00 | 2016-01-15 00:00:00 | 2016-01-22 00:00:00 | 2016-01-29 00:00:00 | 2016-02-05 00:00:00 | 2016-02-12 00:00:00 | 2016-02-19 00:00:00 | 2016-02-26 00:00:00
 | Available Hours
 | Actual Work Assigned
 | Hours Unutilized
 | [NAME]
Actual Total Hours (Weekly) |  |  |  | 2015-10-02 00:00:00 | 2015-10-09 00:00:00 | 2015-10-12 00:00:00 | 2015-10-16 00:00:00 | 2015-10-23 00:00:00 | 2015-10-30 00:00:00 | 2015-11-06 00:00:00 | 2015-11-13 00:00:00 | 2015-11-20 00:00:00 | 2015-11-27 00:00:00 | 2015-11-30 00:00:00 | 2015-12-04 00:00:00 | 2015-12-11 00:00:00 | 2015-12-18 00:00:00 | 2015-12-25 00:00:00 | 2015-12-31 00:00:00 | 2016-01-08 00:00:00 | 2016-01-15 00:00:00 | 2016-01-22 00:00:00 | 2016-01-29 00:00:00 | 2016-02-05 00:00:00 | 2016-02-12 00:00:00 | 2016-02-19 00:00:00 | 2016-02-26 00:00:00
 | Available Hours
 | Actual Work Assigned
 | Hours Unutilized
 | [NAME]
 |  |  |  | 2015-10-01 00:00:00 |  |  |  |  | 2015-11-01 00:00:00 |  |  |  |  | 2015-12-01 00:00:00 |  |  |  |  | 2016-01-01 00:00:00 |  |  |  |  | 2016-02-01 00:00:00
Available Total Hours (Monthly) |  |  |  | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total
 | Available Hours
 | Actual Work Assigned
 | Hours Unutilized
 |  |  |  | 2015-10-01 00:00:00 |  |  |  |  | 2015-11-01 00:00:00 |  |  |  |  | 2015-12-01 00:00:00 |  |  |  |  | 2016-01-01 00:00:00 |  |  |  |  | 2016-02-01 00:00:00
Allocated Total Hours (Monthly) |  |  |  | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total
 | Available Hours
 | Actual Work Assigned
 | Hours Unutilized
 |  |  |  | 2015-10-01 00:00:00 |  |  |  |  | 2015-11-01 00:00:00 |  |  |  |  | 2015-12-01 00:00:00 |  |  |  |  | 2016-01-01 00:00:00 |  |  |  |  | 2016-02-01 00:00:00
Actual Total Hours (Monthly) |  |  |  | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total
 | Available Hours
 | Actual Work Assigned
 | Hours Unutilized
 |  |  |  | 2015-10-01 00:00:00 |  |  |  |  | 2015-11-01 00:00:00 |  |  |  |  | 2015-12-01 00:00:00 |  |  |  |  | 2016-01-01 00:00:00 |  |  |  |  | 2016-02-01 00:00:00
Revenue |  |  |  | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total | US | UK | Offshore | Nearshore | Total
 | Planned Billing
 | Actual Billing
 | Billing Loss