Spreadsheet: 56403d1256600533-sumproduct-array-error-temp
Sheet: Sheet1

LEGEND | AVAILABLE |  | 0 TASKS
 | PARTLY OCCUPIED |  | 2 TASKS ONLY
 | OCCUPIED |  | > 2 TASKS
Employee Name | Active-To-Date | New | Closed | Cancelled | STATUS
Ace | 1 | 1 | 1 | 0 | Partly Occupied
[NAME] | 0 | 0 | 2 | 0 | Available
[NAME] | 0 | 1 | 1 | 0 | Available
[NAME] | 1 | 1 | 0 | 0 | Partly Occupied
Kelly | 0 | 0 | 1 | 0 | Available
Mark | 1 | 2 | 0 | 0 | Occupied
[NAME] | 0 | 0 | 0 | 0 | Available
Miguel | 0 | 1 | 0 | 0 | Available
MJ | 0 | 1 | 0 | 1 | Available
Richelle | 1 | 0 | 0 | 1 | Available
RJ | 1 | 0 | 0 | 1 | Available
Scott | 0 | 1 | 0 | 0 | Available
O C T O B E R
Week # | Active-To-Date | New | Closed | Cancelled
WEEK 1 | 0 | 1 | 2 | 0 |  | 2009-10-05 00:00:00 | 2009-10-09 23:59:00
WEEK 2 | 0 | 7 | 0 | 0 |  | 2009-10-12 00:00:00 | 2009-10-16 23:59:00
WEEK 3 | 0 | 2 | 0 | 0 |  | 2009-10-19 00:00:00 | 2009-10-23 23:59:00
WEEK 4 | 0 | 0 | 0 | 0 |  | 2009-10-26 00:00:00 | 2009-10-30 23:59:00
 | Monday | Tuesday | Wednesday | Thursday | Friday
Occupied | 6 | 3 | 8 | 2 | 2 |  | 2009-10-12 00:00:00 | 2009-10-20 00:00:00
Partly Occupied
Available | 3 | 6 | 1 | 7 | 7
THIS IS HOW I WOULD HAVE WANTED THE RESULTS TO BE
 | Monday | Tuesday | Wednesday | Thursday | Friday
Occupied | 0 | 1 | 1 | 0 | 0
Partly Occupied | 0 | 0 | 1 | 0 | 1
Available | 9 | 8 | 7 | 9 | 8
Employee Name | Over All Status | START DATE | DUE DATE | DATE ACCOMPLISHED |  |  |  | # of times Active-to-date | # of times New
[NAME] | Active-To-Date | 2009-09-22 17:37:00 | 2009-09-25 17:00:00 | 2009-09-25 17:00:00 |  | 3 | Mon | 0 | 4
RJ | Active-To-Date | 2009-09-22 03:30:00 | 2009-10-01 06:00:00 | 2009-10-01 05:00:00 |  | 3 | Tue | 3 | 1
[NAME] | New | 2009-09-23 23:35:00 | 2009-10-09 17:00:00 | 2009-10-09 16:46:00 |  | 4 | Wed | 1 | 5
Ace | New | 2009-10-14 08:26:00 | 2009-10-13 17:00:00 | 2009-10-13 10:25:00 |  | 4 | Thu | 1 | 1
Richelle | Cancelled | 2009-09-28 09:58:00 | 2009-09-30 17:00:00 | 2009-09-28 12:00:00 |  | 2 | Fri | 1 | 1
[NAME] | Closed | 2009-09-28 08:30:00 | 2009-10-13 00:00:00 | 2009-10-12 22:30:00 |  | 2 | Sat | 0 | 0
Richelle | Active-To-Date | 2009-09-24 00:00:00 | 2009-10-26 17:00:00 |  |  | 5 | Sun | 0 | 0
Ace | Closed | 2009-09-29 11:20:00 | 2009-10-19 17:00:00 | 2009-10-19 10:50:00 |  | 3
RJ | Cancelled | 2009-09-28 10:35:00 | 2009-10-22 00:00:00 | 2009-10-05 09:30:00 |  | 2
[NAME] | Active-To-Date | 2009-10-16 08:30:00 | 2009-10-20 12:00:00 |  |  | 6
[NAME] | Closed | 2009-09-16 10:47:00 | 2009-09-28 12:00:00 | 2009-09-23 20:57:00 |  | 4
[NAME] | Closed | 2009-09-30 14:12:00 | 2009-10-12 17:00:00 | 2009-10-12 13:00:00 |  | 4
Mark | New | 2009-10-13 09:16:00 | 2009-10-16 00:00:00 | 2009-10-16 00:00:00 |  | 3
[NAME] | Closed | 2009-09-30 02:44:00 | 2009-10-07 15:30:00 | 2009-10-06 16:51:00 |  | 4
[NAME] | Closed | 2009-09-22 23:22:00 | 2009-10-01 00:00:00 | 2009-09-25 00:00:00 |  | 3
MJ | Cancelled | 2009-09-17 14:14:00 | 2009-10-07 00:00:00 | 2009-09-28 00:00:00 |  | 5
Kelly | Closed | 2009-10-05 10:07:00 | 2009-10-16 17:00:00 |  |  | 2
Miguel | New | 2009-10-01 10:06:00 | 2009-10-14 17:00:00 | 2009-10-13 14:30:00 |  | 5
Ace | Active-To-Date | 2009-10-14 13:22:00 | 2009-10-19 16:00:00 | 2009-10-16 13:37:00 |  | 4
[NAME] | New | 2009-10-07 04:06:00 | 2009-10-23 00:00:00 |  |  | 4
[NAME] | Closed | 2009-10-07 04:14:00 | 2009-10-19 10:00:00 | 2009-10-12 15:57:00 |  | 4
Mark | Active-To-Date | 2009-10-13 15:09:00 | 2009-10-17 21:00:00 | 2009-10-09 20:23:00 |  | 3
[NAME] | New | 2009-10-12 06:07:00 | 2009-10-28 12:00:00 |  |  | 2
Mark | New | 2009-10-14 08:34:00 |  |  |  | 4
[NAME] | New | 2009-10-14 10:37:00 | 2009-10-23 05:00:00 |  |  | 4
MJ | New | 2009-10-12 10:56:00 | 2009-11-02 16:00:00 |  |  | 2
[NAME] | New | 2009-10-16 02:16:00 | 2009-10-19 00:00:00 |  |  | 6
[NAME] | New | 2009-10-19 00:00:00 | 2009-11-13 17:00:00 |  |  | 2
Scott | New | 2009-10-19 10:24:00 | 2009-10-26 00:00:00 |  |  | 2