Spreadsheet: 46761d1245703419-sumproduct-using-2-different-date-ranges-annual-student-report-report-template-06-22-09-fs
Sheet: Paste Intervention Summary

Name | Discipline Reporter | Subtype | Discipline Level | Entry Date | Category | [NAME] | Custom | Entry | [NAME] | School ID |  |  |  | CONTRACT For Success |  |  | Action VLOOKUP
AAA, Test Student | Melehan, M | 02-Make-Up Session | 4 | 2008-09-12 00:00:00 | 4 | 3 |  |  | 1 | 3 |  |  |  |  |  |  |  | No
AAA, Test Student | [NAME], V | 01-Detention | 2 | 2008-09-19 00:00:00 | 4 | 2 |  |  |  |  |  |  |  | 09-Cont. For Success |  |  | 0 | No
AAA, Test Student | Melehan, M | 02-Make-Up Session | 6 | 2008-09-23 00:00:00 | 4 | 2 |  |  | 0 | 3 |  |  |  |  |  |  | 1 | Please Select
AAA, Test Student |  |  | 1 | 2008-09-26 00:00:00 | 4 | 0 |  |  | 0 | 3 |  |  |  | IPP |  |  | 2 | Yes --- Pending
AAA, Test Student | Brooks, A | 01-Detention | 3 | 2008-09-27 00:00:00 | 4 | 3 |  |  | 1 | 3 |  |  |  |  |  |  | 3 | Yes --- Active
AAA, Test Student | [NAME], V | 01-Detention | 3 | 2008-10-04 00:00:00 | 4 | 3 |  |  | 1 | 3 |  |  |  | 10-IPP |  |  | 4 | Yes --- Complete
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-10-08 00:00:00 | 4 | 3 |  |  | 1 | 3
AAA, Test Student | Brooks, A | 01-Detention | 3 | 2008-10-16 00:00:00 | 4 | 3 |  |  | 1 | 3 |  |  |  | Probationary Contract
AAA, Test Student | Melehan, M | 02-Make-Up Session | 6 | 2008-10-18 00:00:00 | 4 | 2 |  |  | 0 | 3
AAA, Test Student | Brooks, A | 07-Dir. [NAME] | 7 | 2008-10-21 00:00:00 | 4 | 5 |  |  | 1 | 3 |  |  |  | 14-Probat. Contract
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-10-24 00:00:00 | 4 | 3 |  |  | 1 | 3
AAA, Test Student | [NAME], V | 01-Detention | 2 | 2008-10-25 00:00:00 | 4 | 3 |  |  | 1 | 3
AAA, Test Student | Melehan, M | 02-Make-Up Session | 6 | 2008-10-25 00:00:00 | 4 | 2 |  |  | 0 | 3 |  |  |  | HIDE ME!!!
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-10-30 00:00:00 | 4 | 2 |  |  | 1 | 3
AAA, Test Student | Melehan, M | 02-Make-Up Session | 4 | 2008-11-01 00:00:00 | 4 | 2 |  |  | 0 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-11-05 00:00:00 | 4 | 2 |  |  | 1 | 3
AAA, Test Student | Melehan, M | 02-Make-Up Session | 4 | 2008-11-08 00:00:00 | 4 | 2 |  |  | 1 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-11-12 00:00:00 | 4 | 2 |  |  | 1 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-11-18 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-12-05 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-12-10 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2008-12-11 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Melehan, M. | 02-Make-Up Session | 4 | 2008-12-13 00:00:00 | 4 | 2 |  |  | 0 | 3
AAA, Test Student | Brooks, A | 01-Detention | 1 | 2008-12-16 00:00:00 | 4 | 3 |  |  | 2 | 3
AAA, Test Student | [NAME], V | 01-Detention | 1 | 2008-12-18 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2009-01-14 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2009-01-22 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Melehan, M | 02-Make-Up Session | 4 | 2009-01-24 00:00:00 | 4 | 2 |  |  | 0 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2009-01-27 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2009-02-03 00:00:00 | 4 | 4 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2009-02-04 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | Hogan | 01-Detention | 1 | 2009-02-06 00:00:00 | 4 | 2 |  |  | 2 | 3
AAA, Test Student | [NAME], V | 01-Detention | 2 | 2009-02-28 00:00:00 | 4 | 2 |  |  | 3 | 3
AAA, Test Student | [NAME], S | 01-Detention | 2 | 2009-02-28 00:00:00 | 4 | 2 |  |  | 3 | 3
AAA, Test Student | Melehan, M | 03-Action Form/DIR | 0 | 2009-03-10 00:00:00 | 4 | 4 |  |  | 3 | 3
AAA, Test Student | Ward, A | 01-Detention | 1 | 2009-04-22 00:00:00 | 4 | 2 |  |  | 3 | 3