Spreadsheet: 114754d1310480890-modify-this-array-formula-in-excel-2007-abc2
Sheet: Sheet1

CW | Test Plan | Area | Test Requestor | Test Coordinator | Tester | No. of Testers | No. of [NAME] | Individual Test Effort Required | Individual Remaining Test Effort | Overall Test Effort Required | Overall Remaining Test Effort | Individual Coordination Effort Required | Individual Remaining Coordination Effort | Action Date | Start Date | Planned Completion Date | Actual Completion Date | Test Report Sent | Test Plan Status | Test Status | Test Details | Comments
1 | abc |  |  | Anshul | Havva | 1 | 10 | 0.5 | 0.5 | 0.04545454545454546 | 0.9545454545454546 | 0.25 | 0.75 |  |  |  |  |  |  |  |  |  | 1 | CRM | Anshul | Yes | Havva | Completed | Errors - Retest Required
1 | xyz |  |  | Mahesh | Soumya | 1 | 10 | 0.5 | 0.5 | 0.04545454545454546 | 0.9090909090909091 | 0.25 | 0.5 |  |  |  |  |  |  |  |  |  | 2 | SRM | Mahesh | No | Soumya | In Process | Retest OK
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 3 | ERP | Saraswathi |  | Siddharth | Yet to Start | OK
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 4 | NW |  |  | Ravi | Cancelled | OK with Reservations
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 5 | [NAME] |  |  | Supriya | Postponed | Limitation
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 6 | HCM |  |  | [NAME]
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 7 | ByD |  |  | Greeshma
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 8 | BOBJ |  |  | Rupa
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 9 | ISV |  |  | Prithvi
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 10 | Others |  |  | Sarish
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 11 |  |  |  | [NAME]
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A
 |  |  |  |  |  | 0 |  | 0 | #N/A | 0 | 1 | 0.25 | #N/A