Spreadsheet: 220260d1363109481-of-participants-in-a-program-during-the-reporting-period-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 |  |  |  | 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 |  |  |  |  | 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 |  |  |  |  | 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 |  |  |  |  | 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-29 00:00:00 | Pre-Trial | PT | Doe, [NAME] | [NAME] | 2 | DUI | NO | NO | N/A |  | 2013-03-31 00:00:00
 | From | To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  | Total # of Participants in Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | I am still not getting how you string these together
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and when to use "sumproduct" or "countif"
 |  | Total # of Participants Completing Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | Reporting period is 03/01/13 (B10) to 03/31/13 (C10)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total # in Program
 |  | Total # of Participants that were violated from Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | Q2:Q12<=C10 |  | R2:R12>=B10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If this column says Pre-Trial
 |  | Total # of Participants that have used alcohol and/or drugs while on program |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | it needs to count
 |  | 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
 |  | Number of program participants that committed a new misd. [NAME] while
 |  | on program during the reporting period (See Offender info for individual accounts)