Spreadsheet: 220330d1363121303-need-to-know-the-total-of-persons-that-have-violated-during-during-a-particular-time-frame-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
 | 6 | Total # of Participants in Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | Problem:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | What I need to know is, how many participants have
 |  | Total # of Participants Completing Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | violated during the reporting period, so if anything in
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | column "Y" says yes, I need it to give me a total of the
 |  | Total # of Participants that were violated from Program during reporting period |  |  |  |  |  |  |  |  |  |  |  |  |  | "Yes's" in B18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I think the function in B14 is a good start for this one
 |  | Total # of Participants that have used alcohol and/or drugs while on program |  |  |  |  |  |  |  |  |  |  |  |  |  | it is the total participants during this reporting period
 |  | 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)