Spreadsheet: 56c607f7-54ae-424d-bb08-508286be3cc4
Sheet: Sheet1

Unnamed: 0 | Northeastern Illinois Regional Water Supply Planning | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | Unnamed: 51 | Unnamed: 52 | Unnamed: 53 | Unnamed: 54 | Unnamed: 55 | Unnamed: 56 | Unnamed: 57 | Unnamed: 58 | Unnamed: 59 | Unnamed: 60 | Unnamed: 61 | Unnamed: 62 | Unnamed: 63 | Unnamed: 64 | Unnamed: 65 | Unnamed: 66 | Unnamed: 67 | Unnamed: 68 | Unnamed: 69 | Unnamed: 70 | Unnamed: 71 | Unnamed: 72 | Unnamed: 73 | Unnamed: 74 | Unnamed: 75 | Unnamed: 76 | Unnamed: 77 | Unnamed: 78 | Unnamed: 79 | Unnamed: 80 | Unnamed: 81 | Unnamed: 82 | Unnamed: 83 | Unnamed: 84 | Unnamed: 85 | Unnamed: 86 | Unnamed: 87 | Unnamed: 88 | Unnamed: 89 | Unnamed: 90 | Unnamed: 91 | Unnamed: 92 | Unnamed: 93 | Unnamed: 94 | Unnamed: 95 | Unnamed: 96 | Unnamed: 97 | Unnamed: 98 | Unnamed: 99 | Unnamed: 100 | Unnamed: 101 | Unnamed: 102 | Unnamed: 103 | Unnamed: 104 | Unnamed: 105 | Unnamed: 106 | Unnamed: 107 | Unnamed: 108 | Unnamed: 109 | Unnamed: 110 | Unnamed: 111
 | 2007-09-14 00:00:00
ID | Task Name | Duration | Staff To Task | Predecessors | Status | July |  |  |  |  | August |  |  |  | September |  |  |  | October |  |  |  |  | November |  |  |  | December |  |  |  |  | January '08 |  |  |  | February |  |  |  | March |  |  |  |  | April |  |  |  | May |  |  |  | June |  |  |  |  | July |  |  |  | August |  |  |  | September |  |  |  |  | October |  |  |  | November |  |  |  | December |  |  |  |  | January '09 |  |  |  | February |  |  |  | March |  |  |  |  | April |  |  |  | May |  |  |  | June |  |  |  |  | 2009-07-01 00:00:00
 |  |  |  |  |  | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 3 | 10 | 17 | 24 | 1 | 8 | 15 | 22 | 29 | 5 | 12 | 19 | 26 | 3 | 10 | 17 | 24 | 31 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 3 | 10 | 17 | 24 | 31 | 7 | 14 | 21 | 28 | 5 | 12 | 19 | 26 | 2 | 9 | 16 | 23 | 30 | 7 | 14 | 21 | 28 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29 | 6 | 13 | 20 | 27 | 3 | 10 | 17 | 24 | 1 | 8 | 15 | 22 | 29 | 5 | 12 | 19 | 26 | 2 | 9 | 16 | 23 | 2 | 9 | 16 | 23 | 30 | 6 | 13 | 20 | 27 | 4 | 11 | 18 | 25 | 1 | 8 | 15 | 22 | 29
1 | Organize July 2007 meeting - Present Planning Principles | 3 weeks | TL |  | Completed
1a | [NAME] | half day | TL, RWSPG |  | Completed
1b | Meeting Follow-up | 1 day | TL, AT |  | Completed
 | August Recess |  |  |  | Completed
2 | Develop Year 2, 3 Work Plan (WP) | 3 weeks | TL |  | On Schedule
2a | Coordinate WP with State Surveys' WPs | 1 day | TL, [NAME] |  | On Schedule
2b | Present WP to CMAP H2O Team | half day | TL, JE, AT, SP, JL, DK | 2a, | On Schedule
2c | Present WP to RWSPG Chairman | half day | TL, Kane County | 2b | On Schedule
2d | Edit WP for presentation to RWSPG | 1 day | TL | 2c | On Schedule
2e | Present workplan / timeline to RWSPG during Sept. meeting | half day | TL |  | On Schedule
I. | Public Information
 | Water-demand Scenario Presentations |  | SIUC |  | On Schedule
 | Generate regional map of water demand study areas for purposes of providing pop/emp/income data to SIUC. |  | TL, JP, SP |  | Behind Schedule
 | October meeting in Geneva - 1) Kane County study results, 2) SIUC/Water-Demand Scenario update |  | TL |  | Future Task
 | Meeting follow-up |  | TL, AT, SP |  | Future Task
 | November meeting - 1) Water Use Conservation, Efficiency, and Sustainability |  | TL, RWSPG |  | Future Task
 | Meeting follow-up |  | TL, AT, SP |  | Future Task
 | Water-demand Scenarios draft final report review w/ RWSPG |  | staff, RWSPG |  | Future Task
 | Review comments given to SIUC |  | staff, RWSPG |  | Future Task
 | Water-demand Scenarios Final Report submitted to CMAP |  |  |  | Future Task
 | Water-demand Scarios Final Report review w/ RWSPG |  | TL, RWSPG |  | Future Task
 | Water-availability Report received from State Surveys |  |  |  | Future Task
 | Analysis of water-availability report | 4 weeks | staff |  | Future Task
 | Water-availability presentation to RWSPG |  | Surveys |  | Future Task
 | Develop program to promote water conservation |  | staff, RWSPG |  | Future Task
 | Develop brochures no. 2 - water demand, and 3 - availability |  | staff, RWSPG |  | Future Task
 | prepare discussion of school district program to promote water conservation |  | TL, SP, AT |  | Future Task
II. | Water Governance
 | September meeting - IL Water Law and Policies |  | TL, RWSPG |  | Future Task
 | Meeting 8 follow up |  | TL, AT, SP |  | Future Task
 | Identify opportunities for strengthening management with recommendtions targeted for state, regional, county, and local jurisdictions |  | staff, RWSPG |  | Future Task
 | State Legislation and Ordinance review, recommendations |  | staff, RWSPG |  | Future Task
 | Identify roles / responsibilities for implementing plan |  | staff, RWSPG |  | Future Task
 | Prepare presentation of work plan and proposed approach to planning for Sept. meeting |  | TL |  | Future Task
III. | Demand-side Conservation
 | prepare for discussion of Residential Surveys |  | TL, AT, SP |  | Future Task
 | prepare for discussion of residential plumbing retrofits |  | TL, AT, SP |  | Future Task
 | 2008
 | January meeting - 1)Water demand scenarios, and 2) BMP 1 - Water survey programs for single-family residential and multi-family residential customers, and BMP 2 - Residential plumbing retrofit |  | TL, RWSPG |  | Future Task
 | Meeting follow-up |  | TL, SP, AT |  | Future Task
 | prepare discussion of large landscape conservation |  | TL, SP, AT |  | Future Task
 | prepare discussion of high efficiency clothes washers |  | TL, SP, AT |  | Future Task
 | February meeting - 1) draft final report: water-demand scenarios review comments, and 2) BMPs: large landscapes; clothes washers |  | TL, RWSPG |  | Future Task
 | Meeting follow-up |  | TL, SP, AT |  | Future Task
 | prepare discussion of programs for commercial, industrial, and institutional accounts (CII) |  | TL, SP, AT |  | Future Task
 | March meeting - 1) water-demand scenarios review comments, 2) Lake Michigan reallocation study, and 3) BMPs: programs for CII |  | TL, RWSPG |  | Future Task
 | Meeting follow-up |  | TL, JE, AT |  | Future Task
 | prepare discussion of conservation pricing |  | TL, JE, AT |  | Future Task
 | prepare discussion of ULFT replacement |  | TL, JE, AT |  | Future Task
 | April meeting - 1) BMPs: conservation pricing; residential ULFT replacement, and 2) long-term demand-side review/summary |  | TL, RWSPG |  | Future Task
 | Meeting follow-up |  | TL, AT, SP |  | Future Task
 | Short-term emergency response: drought management |  | staff, RWSPG, Surveys |  | Future Task
IV. | Supply-side Conservation
 | prepare discussion of wastewater reuse applications |  | JE |  | Future Task
 | May meeting - 1) Wastewater reuse |  | TL, JE, RWSPG |  | Future Task
 | Meeting follow-up
 | prepare discussion of wastewater reuse applications |  | JE |  | Future Task
 | prepare discussion of audits, leak detection, repair |  | TL |  | Future Task
 | June meeting - 1) Wastewate reuse, and 2) system water audits, leak detection, and repair |  | TL, JE, RWSPG |  | Future Task
 | Meeting follow-up |  | TL, AT, SP |  | Future Task
 | prepare discussion of metering
 | prepare discussion of wholesale agency assistance programs
 | prepare discussion of water-waste prohibitions
 | July meeting - 1) metering, 2) wholesale agency assistance programs, and 3) water waste prohibitions
 | Meeting follow-up
 | August Recess
 | stormwater management and sourcewater protection: prepare discussion on relationships between watershed planning and conservation design with protecting water quality and groundwater recharge
 | September meeting - 1) stormwater management and sourcewater protection
 | Meeting follow-up
V. | Conservation Coordinator
 | prepared discussion for local and regional roles
 | October meeting - 1) conservation coordinator roles, and 2) Water Availability Report / Presentation
 | Meeting follow-up
VI. | New Water Sources / enhanced withdrawals
 | prepare to discuss water source optimization based on local circumstances and availability forecasts
 | develop regional plan outline
 | November meeting - 1) water availability: synthesis and response, 2) present THE REGIONAL PLAN outline, and 3) optimizing water access
 | Meeting follow-up
VII. | Regional Water Supply Plan Preparation
 | Staff begins to assimilate Surveys Availability Report
 | Write Regional Water Supply Plan
 | 2009
 | January meeting - 1) Drought Management
 | February meeting - School Education Program
 | March meeting - Plan review / discussion
 | April meeting - Draft Plan presented
 | May meeting - Plan review / discussion
 | [NAME] Final Plan approval
 | Submit NE IL Regional Water Supply Plan to IDNR
VIII. | Plan Implementation - Begin next planning cycle (5-year?)
 | Legend:
 | CMAP Staff work
 | RWSPG Meeting
 | SIUC: Water Demand Study Presentation
 | State Surveys Work Product Delivery
 | August recess
 | Delivery: THE REGIONALPLAN