Spreadsheet: 705006d1605845753-formula-to-best-pull-in-values-from-a-chart-and-if-there-are-values-in-a-specific-column-att-summary
Sheet: Attendance Summary Search

Program & Site | Individual ID | Additional Individual ID | Service Description (Code) | Service Date | Count | [NAME] | Attendance Type Option | Option Code | Billable Option | Time In | Time Out | Billable Time Slot | Duration (hh:[NAME]) | Duration (minutes) | Service Provider | Direct Billing Units | Employee ID Number | Revenue Code | Notes (Non-billable) | Comments (Daily) | Status | Entered Date
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/01/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/02/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/02/2020 |  | Daily Units | Present - Remote | PR | Yes |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/02/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/05/2020 |  | Daily Units | Present - Remote | PR | Yes |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/05/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/06/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/30/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/07/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/30/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/08/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/30/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/09/2020 |  | Daily Units | Present - Remote | PR | Yes |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/30/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/12/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/30/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/13/2020 |  | Daily Units | Present - Remote | PR | Yes |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/30/2020
Santa Rosa | 7190013 |  | Adult Day Program (510 ) | 10/14/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/30/2020
Fairfield | 7143125 |  | [NAME] (102 ) | 10/09/2020 |  | Hourly Units | Not Billable | NB | No |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/11/2020
Fairfield | 7143125 |  | Community Integration Training (Daily) (055 ) | 10/12/2020 |  | Daily Units | Present - Remote | PR | Yes |  |  |  |  | 0 |  |  |  |  |  |  | In Prep | 10/18/2020
Vacaville | 7189613 |  | Transportation per Trip (880 ) | 10/15/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | Submitted for Billing | 10/26/2020
Vacaville | 7189613 |  | Adult Day Program (510 ) | 10/16/2020 |  | Daily Units | Present - Remote | PR | Yes |  |  |  |  | 0 |  |  |  |  |  |  | Approved | 10/26/2020
Vacaville | 7189613 |  | Transportation per Trip (880 ) | 10/16/2020 |  | Daily Units | Present - Remote | PR | Yes |  |  |  |  | 0 |  |  |  |  |  |  | Submitted for Billing | 10/26/2020
Vacaville | 7189613 |  | Adult Day Program (510 ) | 10/19/2020 |  | Daily Units | Absent | A | No |  |  |  |  | 0 |  |  |  |  |  |  | Approved | 10/27/2020
[NAME] | 7193194 |  | Transportation per Trip (880 ) | 10/29/2020 |  | Daily Units | AM Transportation | A | No |  |  |  |  | 0 |  |  |  |  |  |  | Submitted for Billing | 10/30/2020
[NAME] | 7193194 |  | Transportation per Trip (880 ) | 10/29/2020 |  | Daily Units | PM Transportation | A | No |  |  |  |  | 0 |  |  |  |  |  |  | Submitted for Billing | 10/30/2020
[NAME] | 7193194 |  | Transportation per Trip (880 ) | 10/29/2020 |  | Daily Units | Round Trip | A | No |  |  |  |  | 0 |  |  |  |  |  |  | Submitted for Billing | 10/30/2020