Spreadsheet: 220586d1363198726-my-current-function-needs-to-not-calculate-in-those-that-are-no-longer-on-my-program-help-stats-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date Referred | Install Date | Removal Date | Total # of Days Sentenced | Offender | Agency | Number of Days Served at time of report | Offence that put Offender on Program | Violations Yes/No | Violated from Program Yes/No | Was it a Misd. or Felony | What is Violation | Date of Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-07 00:00:00 | 2013-01-27 00:00:00 | 2013-05-12 00:00:00 | 105 | Doe, [NAME] | [NAME] | 63 | DUI | Yes |  |  | U/I alcohol | 2013-03-31 00:00:00
 |  |  | REPORT PREPARED FOR: |  |  |  |  |  |  |  |  |  |  |  | 2013-01-15 00:00:00 | 2013-02-15 00:00:00 | 2013-03-11 00:00:00 | 24 | Doe, [NAME] | [NAME] | 24 | DUI |  |  |  |  | 2013-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00 | 2013-03-16 00:00:00 | 2013-04-25 00:00:00 | 40 | Doe, [NAME] | [NAME] | 15 | DUI | yes | yes |  |  | 2013-03-31 00:00:00
 |  |  | DATE OF REPORT: |  | 2013-03-31 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-02-21 00:00:00 | 2013-03-17 00:00:00 | 2013-04-01 00:00:00 | 15 | Doe, [NAME] | [NAME] | 14 | Drugs |  |  | Felony |  | 2013-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-21 00:00:00 | 2013-03-28 00:00:00 | 2013-04-13 00:00:00 | 16 | Doe, [NAME] | [NAME] | 3 | DV |  |  | Misd. |  | 2013-03-31 00:00:00
 | Reporting Period |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-06 00:00:00 | 2013-04-10 00:00:00 | 2013-04-17 00:00:00 | 7 | Doe, [NAME] | [NAME] | 0 | DUI |  |  |  |  | 2013-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-12 00:00:00 | 2013-03-14 00:00:00 | Pre-Trial | PT | Doe, [NAME] | [NAME] | 17 | DUI | NO | NO | N/A |  | 2013-03-31 00:00:00
 | From | To |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 02/29/13 | 16 | Doe, [NAME] | [NAME] | 46 | DUI |  |  |  |  | 2013-03-31 00:00:00
 | 2013-03-01 00:00:00 | 2013-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 |  | Total # of Participants Refered during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 | 7 | Total # of Participants in Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | My problem in red, column V. This function tells me how
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | many days the offender has been on the program during
 |  | Total # of Participants Completing Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | a particular reporting period. The function is not working
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | properly when the offender has come off the program prior
 | 1 | Total # of Participants that were violated from Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | to the first day of the reporting period.  The function is
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | calculating those that are no longer on the program.
 |  | Total # of Participants that have used alcohol and/or drugs while on program
 |  | and/or refused an alcohol or drug test during the reporting period
 |  | Number of DUI offenders that have used alcohol and/or drugs while on the
 |  | program and/or refused an alcohol or drug test during the reporting period
 | 2 | Number of program participants that committed a new misd. [NAME] while
 |  | on program during the reporting period (See Offender info for individual accounts)