Spreadsheet: 90068d1289830006-excel-2007-dsum-question-referralsreceived2-example
Sheet: ReferralTracking

ReferralID | CityID | Column2 | Column1 | Referral Date | Worker | Date Received | AgencyName | Eligibility Status | EnrollmentStatus | Date Enrolled | Date Assigned to CHW | Randomization | Confimation Code | Column3
1 | 1 |  |  | 2010-03-18 00:00:00 |  | 2010-03-25 00:00:00 | Baycove | Eligible | Enrolled | 2010-04-23 00:00:00 | 2010-04-07 00:00:00 | UBP | 8418
4 | 1 |  |  | 2010-03-23 00:00:00 |  | 2010-03-25 00:00:00 | Baycove | Eligible | Enrolled | 2010-04-23 00:00:00 | 2010-04-07 00:00:00 | Interview | 6605
5 | 1 |  |  | 2010-03-23 00:00:00 |  | 2010-03-25 00:00:00 | Baycove | Eligible | Enrolled | 2010-04-29 00:00:00 | 2010-04-07 00:00:00 | Interview | 3435 |  | CityID | CityID | CityID |  | CityID | EligibilityStatus | EligibilityStatus
6 | 1 |  |  | 2010-03-18 00:00:00 |  | 2010-03-25 00:00:00 | Baycove | Eligible | Enrolled | 2010-04-22 00:00:00 | 2010-04-07 00:00:00 | UBP | 7303 |  | 1 | 2 | 3 |  | 1 | Pending | Ineligible
7 | 1 |  |  | 2010-03-17 00:00:00 |  | 2010-03-25 00:00:00 | Baycove | Ineligible
8 | 1 |  |  | 2010-03-16 00:00:00 |  | 2010-03-25 00:00:00 | Baycove | Ineligible
19 | 1 |  |  | 2010-03-29 00:00:00 |  | 2010-05-07 00:00:00 | Baycove | Eligible | Enrolled | 2010-04-24 00:00:00 | 2010-05-14 00:00:00 | UBP | 7955
20 | 1 |  |  | 2010-03-29 00:00:00 |  | 2010-05-07 00:00:00 | Baycove | Eligible | Enrolled | 2010-09-13 00:00:00 | 2010-07-19 00:00:00 | UBP | 5455
21 | 1 |  |  | 2010-03-26 00:00:00 |  | 2010-05-07 00:00:00 | Baycove | Ineligible
22 | 1 |  |  | 2010-04-15 00:00:00 |  | 0204-05-07 00:00:00 | Baycove | Eligible | Pending |  | 2010-05-14 00:00:00
24 | 1 |  |  | 2010-04-08 00:00:00 |  | 2010-06-15 00:00:00 | Thom | Eligible | Enrolled | 2010-08-05 00:00:00 | 2010-07-21 00:00:00 | Interview | 9213
25 | 1 |  |  | 2010-05-06 00:00:00 |  | 2010-06-15 00:00:00 | Thom | Ineligible
26 | 1 |  |  | 2010-05-18 00:00:00 |  | 2010-06-15 00:00:00 | Thom | Ineligible
27 | 1 |  |  | 2010-05-21 00:00:00 |  | 2010-06-15 00:00:00 | Thom | Eligible | Declined |  | 2010-06-19 00:00:00
28 | 1 |  |  | 2010-08-02 00:00:00 |  | 2010-08-05 00:00:00 | Baycove | Ineligible
29 | 1 |  |  | 2010-07-23 00:00:00 |  | 2010-09-15 00:00:00 | Thom | Ineligible
30 | 1 |  |  | 2010-06-17 00:00:00 |  | 2010-09-15 00:00:00 | Thom | Eligible | Enrolled |  | 2010-09-23 00:00:00 | Interview | 7773
31 | 1 |  |  | 2010-08-18 00:00:00 |  | 2010-09-15 00:00:00 | Baycove | Pending
32 | 1 |  |  | 2010-08-19 00:00:00 |  | 2010-09-15 00:00:00 | Baycove | Ineligible
33 | 1 |  |  | 2010-08-19 00:00:00 |  | 2010-09-15 00:00:00 | Baycove | Eligible | Pending |  | 2010-09-23 00:00:00
34 | 1 |  |  | 2010-09-10 00:00:00 |  | 2010-09-27 00:00:00 | Baycove | Eligible
35 | 1 |  |  | 2010-08-09 00:00:00 |  | 2010-09-27 00:00:00 | Baycove | Ineligible
68 | 1 |  |  | 2010-07-23 00:00:00 |  | 2010-10-19 00:00:00 | Thom | Pending
69 | 2 |  |  | 2010-11-01 00:00:00 |  | 2010-11-12 00:00:00 | PCCD | Pending
70 | 2 |  |  | 2010-10-07 00:00:00 |  | 2010-11-12 00:00:00 | PCCD | Pending
36 | 2 |  |  | 2010-03-17 00:00:00 |  | 2010-03-25 00:00:00 | PCCD | Pending
44 | 2 |  |  | 2010-05-07 00:00:00 |  | 2010-06-02 00:00:00 | PCCD | Ineligible
45 | 2 |  |  | 2010-05-26 00:00:00 |  | 2010-06-02 00:00:00 | PCCD | Pending
50 | 2 |  |  | 2010-05-11 00:00:00 |  | 2010-07-12 00:00:00 | MSPCC - L | Pending
51 | 2 |  |  | 2010-06-16 00:00:00 |  | 2010-06-12 00:00:00 | PCCD | Eligible | Declined |  | 2010-07-20 00:00:00
52 | 2 |  |  | 2010-09-23 00:00:00 |  | 2010-09-27 00:00:00 | PCCD | Eligible | Enrolled | 2010-10-18 00:00:00 | 2010-10-01 00:00:00
53 | 2 |  |  | 2010-09-22 00:00:00 |  | 2010-09-27 00:00:00 | PCCD | Eligible | Enrolled | 2010-10-13 00:00:00 | 2010-10-01 00:00:00 | UBP | 3506
54 | 2 |  |  | 2010-08-24 00:00:00 |  | 2010-09-27 00:00:00 | PCCD | Eligible | Enrolled | 2010-10-13 00:00:00 | 2010-10-01 00:00:00 | UBP | 8733
55 | 2 |  |  | 2010-08-24 00:00:00 |  | 2010-09-27 00:00:00 | PCCD | Pending
56 | 2 |  |  | 2010-09-09 00:00:00 |  | 2010-09-27 00:00:00 | PCCD | Ineligible
57 | 2 |  |  | 2010-10-04 00:00:00 |  | 2010-10-06 00:00:00 | PCCD | Ineligible
61 | 3 |  |  | 2010-05-12 00:00:00 |  | 2010-05-12 00:00:00 | MSPCC - W | Pending
62 | 3 |  |  |  |  | 2010-07-23 00:00:00 | UMASS Med | Pending
63 | 3 |  |  | 2010-03-15 00:00:00 |  | 2010-07-23 00:00:00 | MSPCC - W | Eligible | Enrolled | 2010-09-02 00:00:00 | 2010-08-03 00:00:00 | UBP | 9904
64 | 3 |  |  | 2010-03-17 00:00:00 |  | 2010-07-23 00:00:00 | UMASS Med | Pending
65 | 3 |  |  | 2010-06-11 00:00:00 |  | 2010-07-30 00:00:00 | UMASS Med | Pending
66 | 3 |  |  | 2010-09-18 00:00:00 |  | 2010-09-15 00:00:00 | UMASS Med | Eligible | Enrolled | 2010-10-21 00:00:00 | 2010-09-23 00:00:00 | Interview | 7301
67 | 3 |  |  | 2010-08-17 00:00:00 |  | 2010-09-15 00:00:00 | UMASS Med | Eligible | Pending |  | 2010-09-23 00:00:00