Loading...
HomeMy WebLinkAbout2017 CaryApex_IBT_AnnualReport 2015 Interbasin Transfer Certificate 2017 Annual Report Prepared for Town of Cary Town of Apex Submitted to North Carolina Division of Water Resources April 2018 Submitted by C. Jeff Adkins, PE Water Resources Manager Town of Cary PO Box 8005 Cary, NC 27512-8005 919-462-3846 jeff.adkins@townofcary.org This page has been intentionally left blank. Contents Section Page i Introduction ...................................................................................................................................... 1-1 Withdrawals, Discharges and Interbasin Transfers ............................................................................. 2-1 2.1 IBT Certificate Limits ........................................................................................................................ 2-2 2.2 Summary of Water Withdrawals, Discharges and IBT ..................................................................... 2-2 2.3 Monthly IBT ..................................................................................................................................... 2-4 Consumptive Use by Basin ................................................................................................................. 3-1 Discharge Report ............................................................................................................................... 4-1 4.1 Neuse Basin Demand and Required Discharge ............................................................................... 4-1 4.2 Actual Discharge .............................................................................................................................. 4-2 4.3 Compliance Evaluation .................................................................................................................... 4-3 Interbasin Transfer Certificate Conditions .......................................................................................... 5-1 Appendices A Daily Jordan Lake Water Supply Raw Water Withdrawals B Daily IBT Amounts C Monthly Billed Water Use D AWWA M36 Water Audit Output E Cape Fear River Basin Discharge ii This page has been intentionally left blank. 1-1 SECTION 1 Introduction On March 12, 2015, the North Carolina Environmental Management Commission (EMC) granted an interbasin transfer (IBT) certificate modification to the Towns of Cary and Apex (Towns) with transfer limits of 31 million gallons per day (mgd) from the Haw River basin to the Neuse River basin, and 2 mgd from the Haw River basin to the Cape Fear River basin, calculated as a daily average of a calendar month. This 2017 Annual Report is specified in the Compliance and Monitoring Plan (Plan) approved by the North Carolina Division of Water Resources (NCDWR) on July 14, 2015 and revised March 9, 2018. The schedule for reporting on IBT certificate compliance is provided in the Plan and repeated below. TABLE 1-1 Interbasin Transfer Compliance Monitoring and Reporting Description a Comments IBT Limits Daily average of a calendar month: - 31 mgd Haw to Neuse - 2 mgd Haw to Cape Fear Daily average IBT is calculated daily and reported in the Annual IBT Report. IBT calculated as the daily average of a calendar month reported on the Town of Cary website quarterly and in the Annual IBT Report. The percentages of water use in each basin, summarized historically, and set for calculating daily IBT for the next year will be reported in the Annual IBT Report. Condition 1 Water Conservation Plan Initial submittal to NCDWR by June 10, 2015, and then revised as needed to obtain NCDWR approval. Updates, if necessary, will be provided to NCDWR in the Towns’ respective Secondary and Cumulative Impacts Master Management Plan biennial updates. Water Conservation Plan will always be available on the Town of Cary website. Status of the plan will be included in the Annual IBT Report. Condition 2 Drought Management Plan Initial submittal to NCDWR by June 10, 2015, and then revised as needed to obtain NCDWR approval. Updates will be provided to NCDWR as needed. Drought Management Plan will always be available on the Town of Cary website. Status of the plan will be included in the Annual IBT Report. Condition 3 IBT Compliance and Monitoring Plan Initial submittal to NCDWR by June 10, 2015, and then revised as needed to obtain NCDWR approval. A revised submittal on March 9, 2018, following the modification of the 2015 IBT certificate, added condition 9. IBT Compliance and Monitoring Plan will always be available on the Town of Cary website. Status of the plan will be included in the Annual IBT Report. Condition 4 EMC Consideration of Alternative Sources No reporting necessary. Condition 5 EMC Consideration of Future Water Demand No reporting necessary. Condition 6 Resale of Transferred Water Included in the Annual IBT Report. Condition 7 EMC Consideration of Impacts No reporting necessary. Condition 8 Intake Access Included in the Annual IBT Report. Condition 9 Required Discharge Included in the Annual IBT Report a Certificate conditions are described in Section 4. 1 INTRODUCTION 1-2 To meet the annual reporting requirements of the Plan, the following sections of this 2017 Annual Report include: • Status of compliance with IBT certificate limits. • Summary of historical water withdrawals, reclaimed water usage, wastewater discharges and IBT for the January to December calendar years beginning with 2015. • Table of calculated daily average of calendar month IBT amounts for the 2017 reporting year. • Summary of amount of water used during 2015 to 2017 by customers in the Neuse River, Haw River, and Cape Fear River basins for use in determining the distribution of consumptive uses among the basins. Based on the amount of water used in each basin for the previous year, the distribution of consumptive use by basin in the following calendar year will be determined and documented. • Discharge Report, documenting Required Discharge and Actual Discharge. • Status of compliance with IBT certificate conditions. Appendix A is a table of daily Jordan Lake water supply allocation raw water withdrawals for Cary/Apex, Morrisville and Wake County/RTP South for January 1 to December 31 of the 2017 reporting year. Appendix B is a table of calculated daily IBT amounts for January 1 to December 31 of the 2017 reporting year. Appendix C is a table of monthly billed water use for Cary/Apex for the 2017 reporting year from the Towns’ billing database. Appendix D is the performance indicator and water balance output from the Town of Cary’s AWWA M36 Water Audit analysis performed for fiscal year 2017. The percentage non-revenue water is used in the discharge report to determine Neuse Demand. Appendix E is a table of the actual discharge to the Cape Fear River Basin from Western Wake Regional Water Reclamation Facility (WWRWRF) and other discharges such as the Durham County Triangle Wastewater Treatment Plant. 2-1 SECTION 2 Withdrawals, Discharges and Interbasin Transfers The Towns’ service areas include Cary, Apex, Morrisville, RDU Airport and RTP South (the Wake County portion of Research Triangle Park). Because the Towns’ water system service areas straddle the ridge lines between interbasin transfer (IBT) basins, water is transferred via wastewater discharge, potable water consumptive use, or reclaimed water consumptive use. The combined IBT amount from the communities served is calculated on a daily basis. 2 WITHDRAWALS, DISCHARGES AND INTERBASIN TRANSFERS 2-2 2.1 IBT Certificate Limits The Towns’ IBT certificate limits transfers to 31 million gallons per day (mgd) from the Haw River basin to the Neuse River basin, and to 2 mgd from the Haw River basin to the Cape Fear River basin, calculated as a daily average of a calendar month. During calendar year 2017, the Towns were in compliance with the monthly IBT certificate limits. The peak month transfer from the Haw River basin to the Neuse River basin was 16.1 mgd (52% of certificate limit) which occurred during July 2017. The peak month transfer from the Haw River basin to the Cape Fear River basin was 0.13 mgd (7% of certificate limit) which occurred during July 2017. Daily IBT estimates for the Towns are found in Appendix B. Monthly average daily IBT estimates are found in section 2.3. 2.2 Summary of Water Withdrawals, Discharges and IBT The Towns of Cary and Apex are co-owners of the Cary/Apex Water Treatment Facility which has its raw water intake in Jordan Lake. Cary/Apex, Morrisville and Wake County (for the portion of RTP within that county) each hold allocations of Jordan Lake water supply storage. Daily tracking of raw water withdrawals from Jordan Lake for the allocation holders for the period January 1, 2017 through December 31, 2017 is found in Appendix A. The average daily withdrawal for the Towns was 22.9 mgd during 2017 (Table 2-1). Raw water withdrawals for Cary (including Morrisville and RTP South) and Apex by calendar year beginning with 2015 are summarized in Table 2-1. The withdrawals in Table 2-1 do not include withdrawals for intake access. The City of Durham accessed its Jordan Lake water allocation through the Cary/Apex Water Treatment Facility for 104 days during calendar year 2017. The City of Raleigh accessed its Jordan Lake water allocation through the Cary/Apex Water Treatment Facility for 3 days during calendar year 2017. Table 2-1 Summary of Average Annual Jordan Lake Withdrawals1 Year Average Annual Withdrawal (mgd) 2015 21.2 2016 22.3 2017 22.9 1. Withdrawals from Jordan Lake at the Cary/Apex raw water intake. Includes water use by Apex, Cary, Morrisville and RTP South. Does not include water use by Durham. The Town of Cary owns and operates the North Cary and South Cary Water Reclamation Facilities (NCWRF and SCWRF) which discharge to Crabtree Creek and Middle Creek, respectively. The Town of Apex owns and operates the Apex Water Reclamation Facility (AWRF) which discharges to Middle Creek. The Towns co-own the Western Wake Regional Water Reclamation Facility (WWRWRF) which discharges to the Cape Fear River. Process water from the CAWTF is discharged to a tributary of Jordan Lake. The Town of Cary also has the ability to discharge wastewater to the Durham County Triangle Wastewater Treatment Plant (Durham Co.) which discharges to a tributary of Jordan Lake. The Town utilized this ability in 2017, as discussed in section 4.2. 2 WITHDRAWALS, DISCHARGES AND INTERBASIN TRANSFERS 2-3 Average annual wastewater discharges for Cary and Apex beginning with 2015, identified by receiving basin, are summarized in Table 2-2. Table 2-2 Summary of Average Annual Wastewater Discharges Year CAWTF Discharge (mgd) Wastewater Conveyed to Durham Co. WWTP (mgd) WWRWRF Discharge (mgd) NCWRF Discharge (mgd) SCWRF Discharge (mgd) AWRF Discharge (mgd) Total (mgd) Haw Haw Cape Fear Neuse Neuse Neuse 2015 3.3 0.02 4.6 6.0 5.3 1.2 20.4 2016 4.0 0 4.9 5.7 5.4 1.1 21.1 2017 3.8 0.48 4.5 5.9 4.7 1.1 20.5 The NCWRF and SCWRF produce reclaimed water which is used at each plant, pumped through distribution systems to customers and dispensed in bulk. The WWRWRF produces reclaimed water which is used at the plant and dispensed in bulk. The Town of Cary purchases reclaimed water from the Durham Co. TWWTP for distribution to customers in its western service area. Reclaimed water flows for Cary and Apex for calendar years beginning with 2015 are summarized in Table 2-3. Table 2-3 Summary of Reclaimed Water Flows Year NCWRF 1 Reclaimed Water (mgd) SCWRF 1 Reclaimed Water (mgd) WWRWRF 2 Reclaimed Water (mgd) Reclaimed Water Purchased from Durham Co. TWWTP (mgd) 2015 0.58 0.44 0.55 0.18 2016 0.57 0.38 0.85 0.20 2017 0.57 0.40 0.97 0.24 1 includes distributed, bulk, and plant use 2 includes bulk and plant use Interbasin transfers for Cary and Apex for each calendar year beginning with 2015 are summarized in Table 2-4. Annual average day withdrawals from the Haw Basin are quantified as (1) returned to Haw subbasin, (2) transferred to Neuse subbasin, (3) returned to Cape Fear subbasin or (4) transferred to Cape Fear subbasin. Table 2-4 Summary of Average Annual Interbasin Transfers for Cary and Apex Haw to Neuse Haw to Cape Fear Year Haw Basin Withdrawal (mgd) Return to Haw Basin (mgd) Haw-to-Neuse Interbasin Transfer (mgd) Return to Cape Fear Basin (mgd) Haw-to-Cape Fear Interbasin Transfer (mgd) 2015 21.2 4.3 12.9 4.0 0.03 2016 22.3 4.9 12.9 4.5 0 2017 22.9 5.4 13.2 4.2 0.1 2 WITHDRAWALS, DISCHARGES AND INTERBASIN TRANSFERS 2-4 2.3 Monthly IBT Daily IBT is calculated based on a combination of meter data and assumptions, as defined in Section 2 of the Compliance and Monitoring Plan. Daily IBT data are then used to calculate the IBT certificate compliance metric – IBT calculated as the daily average of a calendar month. Table 2-5 provides daily average interbasin transfers for each calendar month in 2017. Table 2-5 Monthly IBT for Calendar Year 2017 Month Average Daily IBT from Haw to Neuse (mgd) Average Daily IBT from Haw to Cape Fear (mgd) January 11.4 0.01 February 10.5 0.01 March 11.4 0.02 April 13.0 0.03 May 13.3 0.04 June 14.3 0.06 July 16.1 0.13 August 15.7 0.11 September 14.6 0.09 October 14.8 0.09 November 12.1 0.03 December 11.3 0.02 Certificate Limit 31.0 2.0 Max Month (July) 16.1 0.13 Maximum % of Limit 52% 7% 3-1 SECTION 3 Consumptive Use by Basin The average daily consumptive use was 17.2% for the period January 1, 2017 through December 31, 2017. Consumptive use has ranged between 10% and 23.5% since 2000. Historical consumptive use for each calendar year beginning with 2015 is shown in Table 3-1. Table 3-1 Historical Consumptive Use for Cary and Apex Year Average Daily Finished Water Demand (mgd) Average Daily Consumptive Use (mgd) % Consumptive Use 2015 18.0 2.6 14.4% 2016 18.7 2.5 13.3% 2017 19.5 3.4 17.2% Cary and Apex track historical use by assigning a subbasin to each customer. The distribution of consumptive uses between the Haw, Cape Fear, and Neuse River subbasins for 2017 was estimated based on historical water use in each basin as determined by billing records for Cary and Apex. During 2017, based on 2016 billing records, it was assumed that 29.7% of water use occurred in the Haw subbasin, 1.6% of water use occurred in the Cape Fear subbasin, and 68.7% of water use occurred in the Neuse River subbasin. During 2018, based on 2017 billing records, it will be assumed that 32.6% of their water use will occur in the Haw subbasin, 1.4% of their water use will occur in the Cape Fear subbasin, and 66.0% of water use will occur in the Neuse River subbasin. Table 3-2 shows the combined water use for Cary (including Morrisville and RTP South) and Apex, and the percentage water use in the Haw, Cape Fear, and Neuse River subbasins. The table also shows the Haw and Cape Fear use percentages that will be used for 2017 calculations. Table 3-2 Historic Water Use by Subbasin for Cary (including Morrisville and RTP South) and Apex (Annual Average Day) Haw Subbasin Cape Fear Subbasin Neuse Subbasin Year Total Billed Water Use (mgd) Billed Water Use (mgd) Percent Use Billed Water Use (mgd) Percent Use Billed Water Use (mgd) Percent Use 2014 14.57 4.27 29.3% 0.17 1.2% 10.13 69.5% 2015 15.06 4.47 29.7% 0.21 1.4% 10.38 68.9% 2016 15.24 4.52 29.7% 0.25 1.6% 10.47 68.7% 2017 16.93 5.52 32.6% 0.23 1.4% 11.18 66.0% 2018 percentages to be used for IBT calculations 32.6% 1.4% 4-1 SECTION 4 Discharge Report The following is addressed in this section as required by Condition 9 of the 2015 IBT certificate and as defined by the Compliance and Monitoring Plan revised in March 2018: • Required Discharge • Actual Discharge • Compliance Evaluation Data supporting the computation of Neuse Basin Demand, Required Discharge and Actual Discharge are outlined in the following sections. If mitigation measures are required, they would be included in this section as well. 4.1 Neuse Basin Demand and Required Discharge Neuse Basin Demand is the three-year running annual average daily amount of all finished water supplied from sources within the Haw River (2-1) and Cape Fear River (2-3) Basins, for the three preceding calendar years. Neuse Basin Demand is the sum of both billed and unbilled use by the Towns in the Neuse River Basin (10-1). Billed potable water use is quantified from the Town of Apex and Town of Cary water meter and billing databases. Unbilled amounts of finished water are quantified as a percentage of billed water use. The percentage of non- revenue water is calculated on a system-wide basis for the Towns on a yearly basis using procedures detailed in AWWA’s M36 Water Audits and Loss Control Programs publication. Table 4-1 is a summary of the Neuse Basin demand and required discharge calculations. The total Neuse Basin demand values for 2015 and 2016 were stipulated in the IBT certificate, modified by the EMC on March 8, 2018. Appendix C is a summary of the monthly billed water use for Cary and Apex. Appendix D is the output of Town of Cary’s AWWA M36 Water audit for fiscal year 2017. The non-revenue water percentage in Appendix D is assumed representative of both Cary and Apex systems. The Neuse Basin treated water purchases summarized in Table 4-1 are identified on a daily basis in Appendix B. Table 4-1 Neuse Basin Demand Calculation Table and Required Discharge Cary Billed Neuse Basin Water Use (mgd)1 Apex Billed Neuse Basin Water Use (mgd) 1 Total Neuse Basin Billed Water Use (mgd) Water Audit Unbilled Water %2 Neuse Basin Usage, with unbilled use (mgd)3 Neuse Basin Purchases (mgd)4 Total Neuse Basin Demand (mgd) 5 2015 - - - - - - 11.10 2016 - - - - - - 11.20 2017 10.16 1.02 11.18 10.2 % 12.32 0.35 11.98 3 year Running Average of Neuse Basin Demand 11.43 Required Discharge (3 year Running Average of Neuse Basin Demand – 9.756) 1.67 1 From monthly billed water use (Appendix C) 2 From AWWA M36 Water Audit (Appendix D) 3 Neuse Basin Usage = Neuse Billed Water Use + (System-wide Non-Revenue Water % * Neuse Billed Water Use) 4 From Appendix B columns (2), (3) and (4) 5 Neuse Basin Demand = Neuse Basin Usage – Neuse Purchases 4 DISCHARGE REPORT 4-2 4.2 Actual Discharge Actual Discharge is the three-year running annual average daily amount (in mgd) for the three preceding calendar years of treated wastewater that the Towns of Cary and Apex actually discharge to the Haw River Basin and Cape Fear River Basin receiving waters, without regard to which Town of Cary or Apex treatment facilities (whether by ownership or third-party contract) from which the treated wastewater is discharged. In 2017 the Towns of Cary and Apex discharged highly-treated wastewater effluent to the Cape Fear River Basin via the Western Wake Regional WRF (WWRWRF) and Durham County Wastewater Treatment Plant (Durham County). Treated wastewater discharges to Durham County occurred from January 24th to April 14th, 2017 during a period of emergency sewer line repair in Cary’s wastewater collection system. Figure 4-1 below shows the Towns’ daily Cape Fear River Basin discharges from WWRWRF and to Durham County for 2017. Supporting data is found in Appendix E. Figure 4-1 Cape Fear River Basin Actual Treated Wastewater Discharges Table 4-2 shows the Towns’ discharges to the Cape Fear River Basin beginning with 2015 and the 3-year running average for the reporting year 2017 which is compared to the required discharge to determine compliance. Table 4-2 Actual Discharge Calculation Table - Cape Fear River Basin Western Wake Regional WRF (Average Day Discharge) Other Treated Wastewater Discharges Total Actual Discharge (mgd) 2015 4.6 0.02 4.62 2016 4.9 0.00 4.90 2017 4.5 0.48 4.98 3 year running average 4.83 0 2 4 6 8 10 12 To t a l D i s c h a r g e ( m g d ) Cape Fear River Basin Actual Treated Wastewater Discharge (MGD) Discharge to Durham County WWWRF Discharge to Cape Fear River 4 DISCHARGE REPORT 4-3 4.3 Compliance Evaluation For 2017, Cary and Apex’s 3-year running average of actual discharge to the Cape Fear (4.83 mgd) exceeded the required discharge (1.67 mgd) by 3.16 mgd, as shown in Figure 4-2. Figure 4-2 Discharge Compliance Evaluation The Towns are in compliance with condition 9 of the 2015 IBT certificate. The Towns will continue to monitor required discharge and will comply with reporting requirements. If required in a future year, this section would discuss mitigation measures and temporary compliance solutions undertaken by the Towns of Cary and Apex in the prior calendar year, the estimated impact of each such measure, and all data supporting each estimated impact. 1.67 4.83 0 1 2 3 4 5 6 Reporting Year 2017 MG D Required Discharge 3 Yr Avg Actual Discharge (MGD) 5-1 SECTION 5 Interbasin Transfer Certificate Conditions In accordance with the Compliance and Monitoring Plan, the status of the additional eight conditions that the Towns must meet in order to maintain compliance with the IBT certificate are reported annually. The IBT certificate conditions and their status during the 2017 calendar year are as follows. 1. Water Conservation Plan – Within 90 days of receipt of the IBT certificate, the Towns are required to submit a water conservation plan subject to approval by the North Carolina Division of Water Resources (NCDWR) that specifies the water conservation measures that will be implemented by the Towns to ensure the efficient use of the transferred water. STATUS: The Water Conservation Plan was approved by NCDWR on July 14, 2015 and is available on the Town of Cary website (http://www.townofcary.org/home/showdocument?id=9609) . There were no updates during calendar year 2017. 2. Drought Management Plan – Within 90 days of receipt of the IBT certificate, the Towns are required to submit a drought management plan subject to approval by the NCDWR that specifies how the transfer will be managed to protect the source river basin (Haw River basin) during drought conditions or other emergencies that occur within the source river basin. STATUS: The Drought Management Plan was approved by NCDWR on July 14, 2015 and is available on the Town of Cary website (http://www.townofcary.org/home/showdocument?id=9607). An update was approved by NCDWR on August 17, 2015 to update the Town of Cary’s approved Water Shortage Response Plan. Those minor updates were to make the Water Shortage Response Plan consistent with changes in the Town’s organizational structure, changes in Town Council procedures, and changes in utility billing procedures. There were no updates during calendar year 2017. 3. Compliance and Monitoring Plan – Within 90 days of receipt of the IBT certificate, the Towns are required to submit a quarterly compliance and monitoring plan subject to approval by the NCDWR. STATUS: The Compliance and Monitoring Plan was approved by NCDWR on July 14, 2015. The plan was revised on March 9, 2018 following the modification of the 2015 IBT certificate to add condition 9. The current plan is available on the Town of Cary website (http://www.townofcary.org/home/showdocument?id=19727). 4. EMC Consideration of Alternative Sources – The EMC may reopen and amend the maximum amount of the IBT authorized if it appears that an alternative source of water is available to the Towns within the receiving basin (Neuse River basin). STATUS: No reporting is necessary. 5. EMC Consideration of Future Water Demands – The EMC may reopen and amend the certificate if it is determined that the Towns’ actual future water needs are significantly less than the projected water needs at the time the certificate was granted. STATUS: No reporting is necessary. 6. Resale of Transferred Water – The Towns shall not resell the water that would be transferred pursuant to the IBT certificate to another public water system. STATUS: There were no resales of transferred water by the Towns during calendar year 2017. 7. EMC Consideration of Impacts – The EMC may reopen the certificate and amend existing or require new conditions to ensure detrimental impacts are mitigated if environmental impacts are found to be substantially different from those on which the EMC’s Findings of Fact were based. STATUS: No reporting is necessary. 5 INTERBASIN TRANSFER CERTIFICATE CONDITIONS 5-2 8. Intake Access – The Towns shall be required to provide access at their existing intake site to other Jordan Lake water allocation holders that need access to utilize their allocations to the extent that this additional use is determined to be feasible by the NCDWR. STATUS: The Town of Cary has continued to provide retail water service to RTP South and the Town of Morrisville. Chatham County has continued to access its allocation through the Cary/Apex raw water intake. The City of Durham accessed its Jordan Lake water allocation through the Cary/Apex Water Treatment Facility for 104 days during calendar year 2017. The City of Raleigh accessed its Jordan Lake water allocation through the Cary/Apex Water Treatment Facility for 3 days during calendar year 2017. 9. Required Discharge – The Towns shall discharge to the Cape Fear River Basin and Haw River Basin receiving waters a calendar year average daily treated wastewater discharge (“Required Discharge”) calculated as: Required Discharge = Neuse Basin Demand – 9.756 million gallons per day (mgd) Neuse Basin Demand is defined as the 3-year running annual average daily amount for the 3 preceding calendar years of all finished water supplied from sources within the Haw River and Cape Fear River Basins, including both billed and unbilled amounts, expressed in mgd, used by the Towns of Cary and Apex in the Neuse River Basin. Unbilled amounts of finished water use are to be quantified following the procedures of AWWA’s Manual of Practice M36, Water Audits and Loss Control Programs. “Actual Discharge” is the three-year running annual average daily amount (in mgd) for the three preceding calendar years of treated wastewater that the Towns of Cary and Apex actually discharge to the Haw River Basin and Cape Fear River Basin receiving waters, without regard to which Town of Cary or Apex treatment facilities (whether by ownership or third-party contract) from which the treated wastewater is discharged. STATUS: The Towns of Cary and Apex “actual discharge” was greater than the “required discharge” for the reporting year 2017. Appendices A Daily Jordan Lake Water Supply Raw Water Withdrawals B Daily IBT Amounts C Monthly Billed Water Use D AWWA M36 Water Audit Summary E Cape Fear River Basin Discharge APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-1 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 1/1/2017 215.72 19.15 29.63 29.6 17,862 100.00% 1/2/2017 216.11 20.13 31.14 31.1 17,862 100.00% 1/3/2017 216.67 20.31 31.42 31.4 17,862 100.00% 1/4/2017 217.14 18.34 28.37 28.4 17,862 100.00% 1/5/2017 217.28 20.62 31.90 31.9 17,862 100.00% 1/6/2017 217.23 20.14 31.16 31.2 17,862 100.00% 1/7/2017 217.19 16.88 26.11 26.1 17,862 100.00% 1/8/2017 217.00 19.75 30.55 30.6 17,862 100.00% 1/9/2017 216.80 19.80 30.63 30.6 17,862 100.00% 1/10/2017 216.63 21.75 33.65 33.6 17,862 100.00% 1/11/2017 216.47 21.83 33.77 33.8 17,862 100.00% 1/12/2017 216.36 22.35 34.58 34.6 17,862 100.00% 1/13/2017 216.36 19.31 29.87 29.9 17,862 100.00% 1/14/2017 216.30 20.48 31.68 31.7 17,862 100.00% 1/15/2017 216.30 20.47 31.67 31.7 17,862 100.00% 1/16/2017 216.25 19.87 30.74 30.7 17,862 100.00% 1/17/2017 216.25 20.73 32.07 32.1 17,862 100.00% 1/18/2017 216.29 20.84 32.24 32.2 17,862 100.00% 1/19/2017 216.29 19.91 30.80 30.8 17,862 100.00% 1/20/2017 216.34 19.97 30.89 30.9 17,862 100.00% 1/21/2017 216.43 19.31 29.87 29.9 17,862 100.00% 1/22/2017 216.64 20.17 31.20 31.2 17,862 100.00% 1/23/2017 217.41 19.14 29.61 29.6 17,862 100.00% 1/24/2017 218.12 20.06 31.03 31.0 17,862 100.00% 1/25/2017 218.26 20.25 31.33 31.3 17,862 100.00% 1/26/2017 218.12 19.23 29.75 29.7 17,862 100.00% 1/27/2017 217.85 20.65 31.95 31.9 17,862 100.00% 1/28/2017 217.46 18.85 29.16 29.2 17,862 100.00% 1/29/2017 217.06 19.53 30.21 30.2 17,862 100.00% 1/30/2017 216.63 20.96 32.43 32.4 17,862 100.00% 1/31/2017 216.44 19.08 29.52 29.5 17,862 100.00% 2/1/2017 216.45 19.18 29.67 29.7 17,862 100.00% 2/2/2017 216.43 19.89 30.77 30.8 17,862 100.00% 2/3/2017 216.38 20.09 31.08 31.1 17,862 100.00% 2/4/2017 216.35 19.20 29.70 29.7 17,862 100.00% 2/5/2017 216.31 20.39 31.54 31.5 17,862 100.00% 2/6/2017 216.31 20.07 31.04 31.0 17,862 100.00% 2/7/2017 216.32 20.70 32.02 32.0 17,862 100.00% 2/8/2017 216.39 20.95 32.41 32.4 17,862 100.00% 2/9/2017 216.43 21.02 32.52 32.5 17,862 100.00% 2/10/2017 216.44 20.19 31.23 31.2 17,862 100.00% 2/11/2017 216.54 20.98 32.46 32.5 17,862 100.00% 2/12/2017 216.58 21.25 32.87 32.9 17,862 100.00% 2/13/2017 216.59 21.95 33.96 34.0 17,862 100.00% 2/14/2017 216.61 19.77 30.58 30.6 17,862 100.00% 2/15/2017 216.62 20.55 31.79 31.8 17,862 100.00% APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-2 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 2/16/2017 216.57 19.97 30.89 30.9 17,862 100.00% 2/17/2017 216.53 18.79 29.07 29.1 17,862 100.00% 2/18/2017 216.45 19.86 30.72 30.7 17,862 100.00% 2/19/2017 216.43 19.35 29.93 29.9 17,862 100.00% 2/20/2017 216.32 19.93 30.83 30.8 17,862 100.00% 2/21/2017 216.33 17.88 27.66 27.7 17,862 100.00% 2/22/2017 216.33 19.89 30.77 30.8 17,862 100.00% 2/23/2017 216.33 19.05 29.47 29.5 17,862 100.00% 2/24/2017 216.34 18.03 27.89 27.9 17,862 100.00% 2/25/2017 216.34 18.76 29.02 29.0 17,862 100.00% 2/26/2017 216.32 17.62 27.26 27.3 17,862 100.00% 2/27/2017 216.32 19.01 29.41 29.4 17,862 100.00% 2/28/2017 216.32 17.71 27.40 27.4 17,862 100.00% 3/1/2017 216.41 18.07 27.95 28.0 17,862 100.00% 3/2/2017 216.59 17.46 27.01 27.0 17,862 100.00% 3/3/2017 216.78 18.82 29.11 29.1 17,862 100.00% 3/4/2017 216.87 20.29 31.39 31.4 17,862 100.00% 3/5/2017 216.90 20.10 31.09 31.1 17,862 100.00% 3/6/2017 216.88 20.74 32.08 32.1 17,862 100.00% 3/7/2017 216.75 20.54 31.78 31.8 17,862 100.00% 3/8/2017 216.73 19.82 30.66 30.7 17,862 100.00% 3/9/2017 216.63 23.94 37.04 37.0 17,862 100.00% 3/10/2017 216.55 19.34 29.92 29.9 17,862 100.00% 3/11/2017 216.51 19.79 30.62 30.6 17,862 100.00% 3/12/2017 216.47 17.73 27.43 27.4 17,862 100.00% 3/13/2017 216.54 20.50 31.72 31.7 17,862 100.00% 3/14/2017 216.52 20.19 31.23 31.2 17,862 100.00% 3/15/2017 216.58 18.83 29.13 29.1 17,862 100.00% 3/16/2017 216.59 19.27 29.81 29.8 17,862 100.00% 3/17/2017 216.59 21.14 32.70 32.7 17,862 100.00% 3/18/2017 216.68 18.32 28.34 28.3 17,862 100.00% 3/19/2017 216.59 20.72 32.05 32.1 17,862 100.00% 3/20/2017 216.54 19.77 30.58 30.6 17,862 100.00% 3/21/2017 216.48 22.80 35.27 35.3 17,862 100.00% 3/22/2017 216.38 22.69 35.10 35.1 17,862 100.00% 3/23/2017 216.29 24.04 37.19 37.2 17,862 100.00% 3/24/2017 216.28 20.93 32.38 32.4 17,862 100.00% 3/25/2017 216.27 22.62 34.99 35.0 17,862 100.00% 3/26/2017 216.27 23.45 36.28 36.3 17,862 100.00% 3/27/2017 216.27 21.18 32.77 32.8 17,862 100.00% 3/28/2017 216.29 18.84 29.15 29.1 17,862 100.00% 3/29/2017 216.32 18.74 28.99 29.0 17,862 100.00% 3/30/2017 216.35 22.54 34.87 34.9 17,862 100.00% 3/31/2017 216.43 22.26 34.44 34.4 17,862 100.00% 4/1/2017 216.62 20.98 32.46 32.5 17,862 100.00% 4/2/2017 216.78 21.64 33.48 33.5 17,862 100.00% APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-3 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 4/3/2017 216.80 21.34 33.01 33.0 17,862 100.00% 4/4/2017 216.77 24.50 37.89 37.9 17,862 100.00% 4/5/2017 216.79 15.74 24.35 24.4 17,862 100.00% 4/6/2017 216.65 14.05 21.74 21.7 17,862 100.00% 4/7/2017 216.60 20.01 30.96 31.0 17,862 100.00% 4/8/2017 216.43 18.15 28.08 28.1 17,862 100.00% 4/9/2017 216.28 20.73 32.07 32.1 17,862 100.00% 4/10/2017 216.31 21.00 32.49 32.5 17,862 100.00% 4/11/2017 216.36 20.36 31.50 31.5 17,862 100.00% 4/12/2017 216.39 20.60 31.87 31.9 17,862 100.00% 4/13/2017 216.40 21.85 33.80 33.8 17,862 100.00% 4/14/2017 216.40 21.58 33.38 33.4 17,862 100.00% 4/15/2017 216.40 21.19 32.78 32.8 17,862 100.00% 4/16/2017 216.39 22.68 35.09 35.1 17,862 100.00% 4/17/2017 216.38 21.62 33.45 33.4 17,862 100.00% 4/18/2017 216.37 23.06 35.67 35.7 17,862 100.00% 4/19/2017 216.39 20.82 32.21 32.2 17,862 100.00% 4/20/2017 216.38 23.21 35.91 35.9 17,862 100.00% 4/21/2017 216.40 23.24 35.95 36.0 17,862 100.00% 4/22/2017 216.37 23.49 36.34 36.3 17,862 100.00% 4/23/2017 216.45 19.58 30.29 30.3 17,862 100.00% 4/24/2017 218.00 20.89 32.32 32.3 17,862 100.00% 4/25/2017 224.73 18.79 29.07 29.1 17,862 100.00% 4/26/2017 227.20 21.23 32.84 32.8 17,862 100.00% 4/27/2017 227.12 21.73 33.62 33.6 17,862 100.00% 4/28/2017 226.37 22.86 35.36 35.4 17,862 100.00% 4/29/2017 225.42 21.66 33.51 33.5 17,862 100.00% 4/30/2017 224.36 23.70 36.66 36.7 17,862 100.00% 5/1/2017 223.26 21.80 33.72 33.7 17,862 100.00% 5/2/2017 222.16 21.24 32.86 32.9 17,862 100.00% 5/3/2017 221.00 23.59 36.49 36.5 17,862 100.00% 5/4/2017 219.73 23.38 36.17 36.2 17,862 100.00% 5/5/2017 219.01 19.22 29.73 29.7 17,862 100.00% 5/6/2017 218.32 22.25 34.42 34.4 17,862 100.00% 5/7/2017 217.68 20.43 31.61 31.6 17,862 100.00% 5/8/2017 217.24 21.74 33.63 33.6 17,862 100.00% 5/9/2017 216.91 22.56 34.90 34.9 17,862 100.00% 5/10/2017 216.79 19.72 30.51 30.5 17,862 100.00% 5/11/2017 216.67 22.35 34.58 34.6 17,862 100.00% 5/12/2017 216.60 22.95 35.50 35.5 17,862 100.00% 5/13/2017 216.63 20.10 31.09 31.1 17,862 100.00% 5/14/2017 216.56 21.45 33.18 33.2 17,862 100.00% 5/15/2017 216.58 21.59 33.40 33.4 17,862 100.00% 5/16/2017 216.58 25.38 39.26 39.3 17,862 100.00% 5/17/2017 216.55 28.45 44.01 44.0 17,862 100.00% 5/18/2017 216.54 25.31 39.15 39.2 17,862 100.00% APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-4 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 5/19/2017 216.50 26.11 40.39 40.4 17,862 100.00% 5/20/2017 216.42 25.99 40.21 40.2 17,862 100.00% 5/21/2017 216.36 24.79 38.35 38.4 17,862 100.00% 5/22/2017 216.37 22.41 34.67 34.7 17,862 100.00% 5/23/2017 216.85 23.27 36.00 36.0 17,862 100.00% 5/24/2017 218.05 20.47 31.67 31.7 17,862 100.00% 5/25/2017 219.53 21.85 33.80 33.8 17,862 100.00% 5/26/2017 220.24 23.68 36.63 36.6 17,862 100.00% 5/27/2017 220.14 22.74 35.18 35.2 17,862 100.00% 5/28/2017 219.93 20.93 32.38 32.4 17,862 100.00% 5/29/2017 219.67 22.74 35.18 35.2 17,862 100.00% 5/30/2017 219.27 24.89 38.50 38.5 17,862 100.00% 5/31/2017 218.75 24.17 37.39 37.4 17,862 100.00% 6/1/2017 218.25 26.91 41.63 41.6 17,862 100.00% 6/2/2017 217.76 26.01 40.24 40.2 17,862 100.00% 6/3/2017 217.48 26.05 40.30 40.3 17,862 100.00% 6/4/2017 217.40 26.84 41.52 41.5 17,862 100.00% 6/5/2017 217.36 20.89 32.32 32.3 17,862 100.00% 6/6/2017 217.43 24.93 38.57 38.6 17,862 100.00% 6/7/2017 217.30 24.09 37.27 37.3 17,862 100.00% 6/8/2017 216.99 25.68 39.73 39.7 17,862 100.00% 6/9/2017 216.77 28.07 43.42 43.4 17,862 100.00% 6/10/2017 216.65 27.77 42.96 43.0 17,862 100.00% 6/11/2017 216.56 28.68 44.37 44.4 17,862 100.00% 6/12/2017 216.51 26.20 40.53 40.5 17,862 100.00% 6/13/2017 216.48 27.05 41.85 41.8 17,862 100.00% 6/14/2017 216.43 30.51 47.20 47.2 17,862 100.00% 6/15/2017 216.50 25.65 39.68 39.7 17,862 100.00% 6/16/2017 216.68 26.30 40.69 40.7 17,862 100.00% 6/17/2017 216.76 22.33 34.54 34.5 17,862 100.00% 6/18/2017 216.81 22.55 34.88 34.9 17,862 100.00% 6/19/2017 216.93 23.40 36.20 36.2 17,862 100.00% 6/20/2017 220.10 21.16 32.73 32.7 17,862 100.00% 6/21/2017 221.55 21.58 33.38 33.4 17,862 100.00% 6/22/2017 221.71 23.58 36.48 36.5 17,862 100.00% 6/23/2017 221.26 22.31 34.51 34.5 17,862 100.00% 6/24/2017 220.73 23.75 36.74 36.7 17,862 100.00% 6/25/2017 220.32 22.84 35.34 35.3 17,862 100.00% 6/26/2017 219.67 21.81 33.74 33.7 17,862 100.00% 6/27/2017 218.94 26.12 40.40 40.4 17,862 100.00% 6/28/2017 218.25 27.96 43.25 43.3 17,862 100.00% 6/29/2017 217.72 27.04 41.83 41.8 17,862 100.00% 6/30/2017 217.34 27.27 42.19 42.2 17,862 100.00% 7/1/2017 217.30 23.96 37.07 37.1 17,862 100.00% 7/2/2017 217.23 25.20 38.98 39.0 17,862 100.00% 7/3/2017 217.10 25.86 40.01 40.0 17,862 100.00% APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-5 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 7/4/2017 216.98 23.90 36.97 37.0 17,862 100.00% 7/5/2017 216.89 25.62 39.63 39.6 17,862 100.00% 7/6/2017 216.76 27.65 42.77 42.8 17,862 100.00% 7/7/2017 216.67 29.02 44.89 44.9 17,862 100.00% 7/8/2017 216.56 29.89 46.24 46.2 17,862 100.00% 7/9/2017 216.49 25.78 39.88 39.9 17,862 100.00% 7/10/2017 216.47 24.08 37.25 37.3 17,862 100.00% 7/11/2017 216.41 28.20 43.63 43.6 17,862 100.00% 7/12/2017 216.38 32.46 50.21 50.2 17,862 100.00% 7/13/2017 216.31 31.87 49.30 49.3 17,862 100.00% 7/14/2017 216.26 28.03 43.36 43.4 17,862 100.00% 7/15/2017 216.25 30.46 47.12 47.1 17,862 100.00% 7/16/2017 216.22 29.62 45.82 45.8 17,862 100.00% 7/17/2017 216.15 26.20 40.53 40.5 17,862 100.00% 7/18/2017 216.13 27.72 42.88 42.9 17,862 100.00% 7/19/2017 216.07 27.57 42.65 42.7 17,862 100.00% 7/20/2017 216.07 29.48 45.61 45.6 17,862 100.00% 7/21/2017 216.01 33.37 51.63 -0.8 17,862 100.00% 7/22/2017 215.95 32.68 50.56 12.7 17,787 99.58% 7/23/2017 215.98 29.97 46.36 84.3 17,862 100.00% 7/24/2017 216.08 25.12 38.86 38.9 17,862 100.00% 7/25/2017 216.07 28.54 44.15 44.2 17,862 100.00% 7/26/2017 216.00 30.10 46.57 6.8 17,783 99.56% 7/27/2017 215.93 20.65 31.94 16.0 17,752 99.38% 7/28/2017 215.88 27.62 42.73 56.5 17,779 99.53% 7/29/2017 215.85 26.70 41.30 83.2 17,862 100.00% 7/30/2017 215.74 27.40 42.39 -28.4 17,722 99.21% 7/31/2017 215.67 27.54 42.60 7.3 17,652 98.82% 8/1/2017 215.59 30.69 47.48 -1.3 17,555 98.28% 8/2/2017 215.52 29.10 45.02 7.1 17,480 97.86% 8/3/2017 215.43 30.99 47.94 -9.9 17,365 97.22% 8/4/2017 215.33 31.14 48.17 -18.6 17,233 96.48% 8/5/2017 215.29 30.53 47.23 33.2 17,205 96.32% 8/6/2017 215.17 29.10 45.02 -37.0 17,042 95.41% 8/7/2017 215.09 26.52 41.03 -3.3 16,954 94.92% 8/8/2017 215.13 26.27 40.64 178.5 17,227 96.45% 8/9/2017 215.11 25.85 39.99 124.9 17,396 97.39% 8/10/2017 215.06 27.39 42.37 65.7 17,442 97.65% 8/11/2017 215.03 27.24 42.14 107.7 17,572 98.38% 8/12/2017 215.01 24.61 38.07 129.1 17,753 99.39% 8/13/2017 215.02 25.92 40.10 95.2 17,862 100.00% 8/14/2017 215.02 22.95 35.50 35.5 17,862 100.00% 8/15/2017 215.01 25.85 39.99 40.0 17,862 100.00% 8/16/2017 214.99 27.90 43.16 43.2 17,862 100.00% 8/17/2017 214.96 26.88 41.58 41.6 17,862 100.00% 8/18/2017 214.93 29.94 46.32 46.3 17,862 100.00% APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-6 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 8/19/2017 214.87 28.26 43.72 31.2 17,837 99.86% 8/20/2017 214.82 29.43 45.53 56.2 17,858 99.98% 8/21/2017 214.77 25.83 39.96 41.8 17,862 100.00% 8/22/2017 214.66 29.29 45.31 -18.4 17,736 99.29% 8/23/2017 214.59 29.76 46.04 14.4 17,673 98.94% 8/24/2017 214.52 29.03 44.91 15.7 17,615 98.62% 8/25/2017 214.47 29.03 44.91 47.2 17,619 98.64% 8/26/2017 214.42 28.86 44.65 47.4 17,625 98.67% 8/27/2017 214.37 28.81 44.57 47.5 17,631 98.70% 8/28/2017 214.35 26.67 41.26 104.8 17,757 99.41% 8/29/2017 214.21 25.99 40.21 -55.1 17,568 98.35% 8/30/2017 214.15 26.46 40.94 12.0 17,510 98.03% 8/31/2017 214.10 26.41 40.86 21.8 17,472 97.82% 9/1/2017 214.24 26.81 41.48 238.0 17,862 100.00% 9/2/2017 214.31 21.72 33.60 33.6 17,862 100.00% 9/3/2017 214.44 22.62 34.99 35.0 17,862 100.00% 9/4/2017 214.46 25.80 39.91 39.9 17,862 100.00% 9/5/2017 214.45 26.82 41.49 41.5 17,862 100.00% 9/6/2017 214.43 24.75 38.29 38.3 17,862 100.00% 9/7/2017 214.44 22.66 35.05 35.1 17,862 100.00% 9/8/2017 214.49 26.22 40.56 40.6 17,862 100.00% 9/9/2017 214.46 22.51 34.82 34.8 17,862 100.00% 9/10/2017 214.41 27.32 42.26 42.3 17,862 100.00% 9/11/2017 214.36 24.13 37.33 37.3 17,862 100.00% 9/12/2017 214.33 25.16 38.92 38.9 17,862 100.00% 9/13/2017 214.30 23.22 35.92 35.9 17,862 100.00% 9/14/2017 214.34 26.11 40.39 40.4 17,862 100.00% 9/15/2017 214.32 26.12 40.41 40.4 17,862 100.00% 9/16/2017 214.29 25.55 39.53 39.5 17,862 100.00% 9/17/2017 214.23 24.12 37.31 16.6 17,821 99.77% 9/18/2017 214.17 25.89 40.05 19.0 17,779 99.54% 9/19/2017 214.11 26.31 40.71 16.4 17,731 99.27% 9/20/2017 214.04 26.96 41.71 -0.8 17,647 98.79% 9/21/2017 213.99 27.51 42.55 35.4 17,633 98.72% 9/22/2017 213.93 26.18 40.50 21.3 17,594 98.50% 9/23/2017 213.88 27.98 43.29 40.2 17,588 98.47% 9/24/2017 213.81 28.54 44.15 3.8 17,508 98.02% 9/25/2017 213.73 24.63 38.10 -7.4 17,418 97.51% 9/26/2017 213.67 27.10 41.93 13.1 17,361 97.19% 9/27/2017 213.59 27.34 42.29 -6.0 17,265 96.66% 9/28/2017 213.58 28.46 44.03 92.8 17,362 97.20% 9/29/2017 213.44 30.34 46.93 -54.2 17,161 96.08% 9/30/2017 213.34 30.86 47.74 -21.2 17,024 95.31% 10/1/2017 213.29 28.95 44.78 18.3 16,972 95.02% 10/2/2017 213.21 25.52 39.48 -6.7 16,880 94.50% 10/3/2017 213.13 28.03 43.37 -6.0 16,782 93.96% APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-7 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 10/4/2017 213.05 31.55 48.81 -5.2 16,675 93.36% 10/5/2017 212.98 28.84 44.61 -1.1 16,584 92.85% 10/6/2017 212.93 28.95 44.78 9.8 16,515 92.46% 10/7/2017 212.85 30.89 47.78 -14.6 16,391 91.77% 10/8/2017 212.81 22.48 34.77 15.6 16,353 91.55% 10/9/2017 212.82 24.62 38.09 53.7 16,384 91.73% 10/10/2017 212.84 25.01 38.70 100.2 16,506 92.41% 10/11/2017 212.82 27.97 43.28 47.1 16,514 92.45% 10/12/2017 212.82 23.72 36.70 76.2 16,592 92.89% 10/13/2017 212.77 26.07 40.33 0.8 16,513 92.45% 10/14/2017 212.72 25.14 38.89 0.8 16,438 92.03% 10/15/2017 212.65 26.16 40.47 -14.8 16,328 91.41% 10/16/2017 212.69 24.63 38.10 113.9 16,479 92.26% 10/17/2017 212.65 22.72 35.15 6.4 16,422 91.94% 10/18/2017 212.61 24.50 37.90 7.2 16,361 91.60% 10/19/2017 212.60 26.37 40.79 54.0 16,387 91.74% 10/20/2017 212.53 25.41 39.31 -19.2 16,271 91.09% 10/21/2017 212.49 26.83 41.51 4.2 16,197 90.68% 10/22/2017 212.46 25.63 39.65 11.3 16,141 90.36% 10/23/2017 212.55 24.58 38.03 205.7 16,473 92.22% 10/24/2017 212.57 21.24 32.85 99.9 16,606 92.97% 10/25/2017 212.70 22.90 35.42 297.7 17,126 95.88% 10/26/2017 212.71 22.33 34.55 92.8 17,242 96.53% 10/27/2017 212.77 24.85 38.44 183.9 17,530 98.14% 10/28/2017 212.72 22.52 34.84 -4.2 17,453 97.71% 10/29/2017 212.70 21.61 33.43 35.6 17,457 97.73% 10/30/2017 212.68 22.39 34.64 31.2 17,450 97.70% 10/31/2017 212.68 21.13 32.69 57.1 17,499 97.97% 11/1/2017 212.67 22.57 34.91 49.7 17,528 98.13% 11/2/2017 212.60 24.07 37.24 0.0 17,454 97.72% 11/3/2017 212.59 21.70 33.58 10.3 17,408 97.46% 11/4/2017 212.58 22.94 35.48 56.8 17,451 97.70% 11/5/2017 212.53 22.91 35.44 -2.4 17,375 97.28% 11/6/2017 212.52 22.13 34.24 53.7 17,414 97.49% 11/7/2017 212.52 22.03 34.08 71.9 17,489 97.91% 11/8/2017 212.58 21.10 32.64 175.2 17,772 99.49% 11/9/2017 212.59 21.70 33.58 79.1 17,862 100.00% 11/10/2017 212.55 20.32 31.43 8.8 17,817 99.75% 11/11/2017 212.47 18.99 29.37 -25.8 17,708 99.14% 11/12/2017 212.45 20.56 31.80 19.7 17,684 99.00% 11/13/2017 212.47 21.35 33.02 90.5 17,798 99.64% 11/14/2017 212.48 20.19 31.23 63.6 17,862 100.00% 11/15/2017 212.46 19.81 30.65 30.7 17,862 100.00% 11/16/2017 212.45 20.31 31.42 31.4 17,862 100.00% 11/17/2017 212.41 20.27 31.36 8.4 17,816 99.74% 11/18/2017 212.36 19.14 29.61 -3.3 17,751 99.38% APPENDIX A – DAILY JORDAN LAKE WATER SUPPLY A-8 APPENDIX A - Daily Jordan Lake Water Supply Raw Water Withdrawals Jordan Lake Water Supply Storage Allocation Tracking Cary/Apex, Morrisville, and Wake County/RTP South COMBINED Date Reservoir Level (ft) Cary/Apex/ Morrisville/RTP Water Supply (mgd) Cary/Apex/ Morrisville/RTP Water Supply (cfs) Inflow to Cary/Apex/ Morrisville/RTP (cfs) Cary/Apex/ Morrisville/RTP Storage Level (ac-ft) Cary/Apex/ Morrisville/RTP Storage Level (%) 11/19/2017 212.35 21.43 33.15 49.7 17,784 99.56% 11/20/2017 212.33 21.13 32.69 38.6 17,796 99.63% 11/21/2017 212.32 18.14 28.07 53.2 17,845 99.91% 11/22/2017 212.29 20.02 30.97 23.3 17,830 99.82% 11/23/2017 212.25 20.64 31.93 8.7 17,784 99.56% 11/24/2017 212.21 17.30 26.77 7.7 17,746 99.35% 11/25/2017 212.20 17.54 27.13 50.8 17,793 99.62% 11/26/2017 212.26 19.53 30.21 8.0 17,749 99.37% 11/27/2017 212.13 18.98 29.36 23.3 17,737 99.30% 11/28/2017 212.10 20.31 31.42 23.3 17,721 99.21% 11/29/2017 212.07 19.94 30.85 23.1 17,706 99.12% 11/30/2017 212.05 19.86 30.72 36.5 17,717 99.19% 12/1/2017 212.03 19.16 29.64 35.7 17,729 99.26% 12/2/2017 212.01 19.22 29.73 35.4 17,740 99.32% 12/3/2017 211.98 17.41 26.94 22.7 17,732 99.27% 12/4/2017 211.95 19.59 30.30 20.2 17,712 99.16% 12/5/2017 211.94 17.28 26.73 42.6 17,743 99.33% 12/6/2017 211.91 17.44 26.97 16.5 17,722 99.22% 12/7/2017 211.89 20.36 31.50 30.8 17,721 99.21% 12/8/2017 212.04 16.67 25.79 96.9 17,862 100.00% 12/9/2017 212.09 16.61 25.70 25.7 17,862 100.00% 12/10/2017 212.19 18.58 28.74 28.7 17,862 100.00% 12/11/2017 212.26 23.76 36.75 36.8 17,862 100.00% 12/12/2017 212.28 16.59 25.66 25.7 17,862 100.00% 12/13/2017 212.28 17.40 26.92 26.9 17,862 100.00% 12/14/2017 212.32 20.19 31.23 31.2 17,862 100.00% 12/15/2017 212.29 18.91 29.25 16.5 17,837 99.86% 12/16/2017 212.27 16.79 25.97 33.4 17,851 99.94% 12/17/2017 212.28 18.52 28.65 34.1 17,862 100.00% 12/18/2017 212.07 19.51 30.18 30.2 17,862 100.00% 12/19/2017 212.09 17.56 27.17 27.2 17,862 100.00% 12/20/2017 212.09 16.38 25.35 25.3 17,862 100.00% 12/21/2017 212.09 20.34 31.47 31.5 17,862 100.00% 12/22/2017 212.09 18.73 28.98 29.0 17,862 100.00% 12/23/2017 212.14 16.57 25.63 25.6 17,862 100.00% 12/24/2017 212.10 18.03 27.89 27.9 17,862 100.00% 12/25/2017 212.07 16.20 25.06 -8.8 17,795 99.62% 12/26/2017 212.07 16.20 25.06 56.1 17,856 99.97% 12/27/2017 212.10 16.87 26.10 28.9 17,862 100.00% 12/28/2017 212.03 17.61 27.24 -27.0 17,754 99.40% 12/29/2017 212.00 17.37 26.87 3.4 17,708 99.14% 12/30/2017 212.01 16.91 26.16 46.6 17,749 99.36% 12/31/2017 212.00 17.94 27.75 43.3 17,779 99.54% APPENDIX B – DAILY IBT AMOUNTS B-1 APPENDIX B - Daily IBT Amounts (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 1/1/2017 19.15 0.00 0.00 0.070 19.22 0.237 0.070 0.013 0.000 0.547 0.251 3.29 0.00 4.41 10.40 3.60 4.43 11.20 19.22 0.013 11.13 1/2/2017 20.13 0.00 0.00 0.065 20.20 0.251 0.065 0.014 0.000 0.582 0.255 3.26 0.00 4.32 11.45 3.58 4.34 12.28 20.20 0.014 12.22 1/3/2017 20.31 0.00 0.00 0.065 20.38 0.240 0.065 0.013 0.000 0.556 0.247 4.20 0.00 4.14 10.91 4.51 4.15 11.72 20.38 0.013 11.65 1/4/2017 18.34 0.00 0.00 0.078 18.42 0.238 0.078 0.013 0.000 0.551 0.265 2.37 0.00 4.28 10.63 2.69 4.29 11.44 18.42 0.013 11.37 1/5/2017 20.62 0.00 0.00 0.072 20.69 0.249 0.072 0.013 0.000 0.576 0.247 3.91 0.00 4.37 11.26 4.23 4.38 12.08 20.69 0.013 12.01 1/6/2017 20.14 0.00 0.00 0.068 20.21 0.243 0.068 0.013 0.000 0.562 0.301 3.86 0.00 4.34 10.82 4.17 4.36 11.68 20.21 0.013 11.61 1/7/2017 16.88 0.00 0.00 0.051 16.93 0.205 0.051 0.011 0.000 0.474 0.258 3.14 0.00 3.82 8.97 3.40 3.83 9.71 16.93 0.011 9.66 1/8/2017 19.75 0.00 0.00 0.045 19.80 0.247 0.045 0.013 0.000 0.571 0.281 3.17 0.00 4.72 10.75 3.46 4.73 11.60 19.80 0.013 11.55 1/9/2017 19.80 0.00 0.00 0.045 19.85 0.237 0.045 0.013 0.000 0.549 0.287 3.86 0.00 4.39 10.46 4.14 4.40 11.30 19.85 0.013 11.25 1/10/2017 21.75 0.00 0.00 0.060 21.81 0.258 0.060 0.014 0.000 0.596 0.260 4.45 0.00 4.62 11.55 4.77 4.64 12.41 21.81 0.014 12.35 1/11/2017 21.83 0.00 0.00 0.109 21.94 0.260 0.109 0.014 0.000 0.601 0.250 4.43 0.00 4.48 11.79 4.80 4.49 12.65 21.94 0.014 12.54 1/12/2017 22.35 0.00 0.00 0.205 22.56 0.270 0.205 0.015 0.000 0.624 0.200 4.40 0.00 4.95 11.89 4.87 4.97 12.71 22.56 0.015 12.51 1/13/2017 19.31 0.00 0.00 0.149 19.46 0.244 0.149 0.013 0.000 0.565 0.193 3.01 0.00 4.45 10.83 3.40 4.47 11.59 19.46 0.013 11.44 1/14/2017 20.48 0.00 0.00 0.132 20.61 0.236 0.132 0.013 0.000 0.547 0.180 4.69 0.00 4.45 10.37 5.06 4.46 11.09 20.61 0.013 10.96 1/15/2017 20.47 0.00 0.00 0.134 20.60 0.248 0.134 0.013 0.000 0.575 0.109 3.87 0.00 4.82 10.83 4.25 4.84 11.51 20.60 0.013 11.38 1/16/2017 19.87 0.00 0.00 0.138 20.01 0.246 0.138 0.013 0.000 0.569 0.203 3.45 0.00 4.61 10.78 3.83 4.63 11.55 20.01 0.013 11.41 1/17/2017 20.73 0.00 0.00 0.128 20.86 0.247 0.128 0.013 0.000 0.572 0.257 4.21 0.00 4.45 10.98 4.59 4.47 11.81 20.86 0.013 11.68 1/18/2017 20.84 0.00 0.00 0.141 20.98 0.240 0.141 0.013 0.000 0.555 0.270 4.81 0.00 4.33 10.62 5.19 4.34 11.44 20.98 0.013 11.30 1/19/2017 19.91 0.00 0.00 0.127 20.04 0.244 0.127 0.013 0.000 0.565 0.198 3.59 0.00 4.47 10.83 3.96 4.48 11.59 20.04 0.013 11.46 1/20/2017 19.97 0.00 0.00 0.128 20.10 0.218 0.128 0.012 0.000 0.505 0.201 5.41 0.00 3.90 9.73 5.76 3.91 10.43 20.10 0.012 10.31 1/21/2017 19.31 0.00 0.00 0.132 19.44 0.240 0.132 0.013 0.000 0.554 0.192 3.31 0.00 4.58 10.42 3.68 4.59 11.17 19.44 0.013 11.03 1/22/2017 20.17 0.00 0.00 0.134 20.30 0.240 0.134 0.013 0.000 0.554 0.205 4.17 0.00 4.43 10.56 4.54 4.44 11.32 20.30 0.013 11.19 1/23/2017 19.14 0.00 0.00 0.138 19.28 0.245 0.138 0.013 0.000 0.567 0.209 2.78 0.00 4.23 11.10 3.16 4.24 11.87 19.28 0.013 11.73 1/24/2017 20.06 0.00 0.00 0.133 20.19 0.239 0.133 0.013 0.000 0.554 0.197 4.07 0.33 3.19 11.46 4.78 3.21 12.21 20.19 0.013 12.08 1/25/2017 20.25 0.00 0.00 0.137 20.39 0.254 0.137 0.014 0.000 0.587 0.229 3.31 1.67 2.87 11.32 5.37 2.88 12.14 20.39 0.014 12.00 1/26/2017 19.23 0.00 0.00 0.144 19.37 0.233 0.144 0.013 0.000 0.539 0.217 3.68 1.33 2.64 10.58 5.39 2.65 11.34 19.37 0.013 11.19 1/27/2017 20.65 0.00 0.00 0.139 20.79 0.242 0.139 0.013 0.000 0.560 0.267 4.49 2.03 2.64 10.41 6.90 2.65 11.24 20.79 0.013 11.10 1/28/2017 18.85 0.00 0.00 0.129 18.98 0.234 0.129 0.013 0.000 0.542 0.216 3.19 1.92 2.53 10.21 5.47 2.54 10.97 18.98 0.013 10.84 1/29/2017 19.53 0.00 0.00 0.132 19.66 0.234 0.132 0.013 0.000 0.540 0.200 3.93 1.89 2.59 10.13 6.18 2.61 10.87 19.66 0.013 10.74 1/30/2017 20.96 0.00 0.00 0.132 21.09 0.250 0.132 0.013 0.000 0.579 0.216 4.24 2.22 2.52 10.93 6.84 2.53 11.72 21.09 0.013 11.59 1/31/2017 19.08 0.00 0.00 0.138 19.22 0.239 0.138 0.013 0.000 0.553 0.218 3.11 1.86 3.47 9.61 5.35 3.49 10.38 19.22 0.013 10.24 2/1/2017 19.18 0.00 0.00 0.152 19.33 0.237 0.152 0.013 0.000 0.547 0.255 3.40 1.71 3.07 9.94 5.50 3.09 10.75 19.33 0.013 10.59 2/2/2017 19.89 0.00 0.00 0.139 20.03 0.243 0.139 0.013 0.000 0.561 0.225 3.69 1.98 2.28 10.90 6.05 2.29 11.69 20.03 0.013 11.55 2/3/2017 20.09 0.00 0.00 0.131 20.22 0.223 0.131 0.012 0.000 0.516 0.206 5.19 1.83 2.63 9.49 7.37 2.64 10.21 20.22 0.012 10.08 2/4/2017 19.20 0.00 0.00 0.128 19.33 0.246 0.128 0.013 0.000 0.569 0.227 2.75 1.88 2.67 10.84 5.01 2.68 11.64 19.33 0.013 11.51 2/5/2017 20.39 0.00 0.00 0.130 20.52 0.239 0.130 0.013 0.000 0.553 0.213 4.43 1.94 2.32 10.68 6.74 2.33 11.45 20.52 0.013 11.32 2/6/2017 20.07 0.00 0.00 0.135 20.20 0.252 0.135 0.014 0.001 0.583 0.240 3.23 2.06 2.71 10.98 5.67 2.72 11.80 20.20 0.015 11.67 2/7/2017 20.70 0.00 0.00 0.151 20.85 0.235 0.151 0.013 0.000 0.545 0.215 5.00 2.02 2.35 10.32 7.40 2.37 11.08 20.85 0.013 10.93 2/8/2017 20.95 0.00 0.00 0.137 21.09 0.233 0.137 0.013 0.000 0.539 0.294 5.39 1.89 2.29 10.30 7.65 2.30 11.14 21.09 0.013 11.00 2/9/2017 21.02 0.00 0.00 0.133 21.15 0.251 0.133 0.014 0.000 0.581 0.279 4.24 2.02 2.52 11.11 6.64 2.53 11.97 21.15 0.014 11.84 2/10/2017 20.19 0.00 0.00 0.122 20.31 0.238 0.122 0.013 0.000 0.550 0.230 4.31 1.93 2.45 10.46 6.60 2.47 11.24 20.31 0.013 11.12 APPENDIX B – DAILY IBT AMOUNTS B-2 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 2/11/2017 20.98 0.00 0.00 0.109 21.09 0.255 0.109 0.014 0.000 0.589 0.232 3.94 2.10 2.63 11.22 6.40 2.65 12.04 21.09 0.014 11.93 2/12/2017 21.25 0.00 0.00 0.179 21.43 0.240 0.179 0.013 0.000 0.554 0.474 5.29 1.86 2.57 10.25 7.57 2.58 11.28 21.43 0.013 11.10 2/13/2017 21.95 0.00 0.00 0.377 22.33 0.253 0.377 0.014 0.000 0.586 0.534 5.26 2.14 2.52 10.64 8.03 2.54 11.76 22.33 0.014 11.38 2/14/2017 19.77 0.00 0.00 0.000 19.77 0.237 0.000 0.013 0.000 0.548 -0.023 3.83 1.98 2.44 10.75 6.05 2.45 11.27 19.77 0.013 11.27 2/15/2017 20.55 0.00 0.00 0.000 20.55 0.231 0.000 0.012 0.000 0.535 -0.017 4.98 1.71 2.24 10.86 6.92 2.26 11.37 20.55 0.012 11.37 2/16/2017 19.97 0.00 1.77 0.000 21.74 0.334 0.000 0.018 0.000 0.772 0.004 4.13 2.15 2.45 11.88 6.61 2.47 12.66 21.74 0.018 10.89 2/17/2017 18.79 0.00 1.88 0.000 20.67 0.208 0.000 0.011 0.000 0.481 -0.008 6.66 1.73 2.25 9.34 8.60 2.26 9.82 20.67 0.011 7.93 2/18/2017 19.86 0.00 1.78 0.000 21.64 0.256 0.000 0.014 0.000 0.592 -0.027 4.40 2.10 2.80 11.51 6.75 2.82 12.07 21.64 0.014 10.29 2/19/2017 19.35 0.00 1.14 0.120 20.61 0.241 0.120 0.013 0.000 0.558 0.311 4.36 1.98 2.57 10.45 6.70 2.58 11.32 20.61 0.013 10.07 2/20/2017 19.93 0.00 2.17 0.308 22.41 0.258 0.308 0.014 0.000 0.597 0.684 5.04 2.04 2.56 10.91 7.65 2.57 12.19 22.41 0.014 9.71 2/21/2017 17.88 0.00 1.84 0.258 19.98 0.232 0.258 0.012 0.000 0.536 0.504 4.38 1.86 2.25 9.95 6.73 2.26 10.99 19.98 0.012 8.89 2/22/2017 19.89 0.00 1.93 0.186 22.00 0.244 0.186 0.013 0.000 0.563 0.422 5.60 1.96 2.33 10.69 7.98 2.34 11.68 22.00 0.013 9.57 2/23/2017 19.05 0.00 2.04 0.164 21.25 0.265 0.164 0.014 0.000 0.614 0.497 3.71 2.14 2.52 11.32 6.28 2.54 12.43 21.25 0.014 10.23 2/24/2017 18.03 0.00 2.17 0.166 20.37 0.244 0.166 0.013 0.000 0.565 0.599 3.92 2.02 2.42 10.42 6.35 2.44 11.58 20.37 0.013 9.25 2/25/2017 18.76 0.00 2.08 0.166 21.00 0.255 0.166 0.014 0.000 0.591 0.576 3.80 2.11 2.58 10.91 6.33 2.59 12.08 21.00 0.014 9.84 2/26/2017 17.62 0.00 1.87 0.165 19.66 0.236 0.165 0.013 0.000 0.546 0.577 3.77 1.92 2.46 9.98 6.09 2.47 11.10 19.66 0.013 9.07 2/27/2017 19.01 0.00 1.90 0.158 21.07 0.246 0.158 0.013 0.000 0.569 0.498 4.49 2.15 2.34 10.60 7.04 2.36 11.67 21.07 0.013 9.61 2/28/2017 17.71 0.00 2.13 0.210 20.05 0.247 0.210 0.013 0.000 0.571 0.430 3.42 2.14 2.51 10.51 6.02 2.52 11.51 20.05 0.013 9.17 3/1/2017 18.07 0.00 2.10 0.169 20.34 0.244 0.169 0.013 0.000 0.564 0.417 3.92 1.95 2.28 10.78 6.28 2.30 11.77 20.34 0.013 9.49 3/2/2017 17.46 0.00 1.93 0.164 19.55 0.255 0.164 0.014 0.000 0.591 0.421 2.35 2.03 2.49 11.24 4.79 2.50 12.25 19.55 0.014 10.16 3/3/2017 18.82 0.00 0.00 0.161 18.98 0.218 0.161 0.012 0.001 0.505 0.412 4.28 1.86 2.10 9.44 6.52 2.11 10.36 18.98 0.012 10.20 3/4/2017 20.29 0.00 0.00 0.163 20.45 0.243 0.163 0.013 0.000 0.563 0.389 4.07 1.93 2.56 10.52 6.41 2.57 11.48 20.45 0.013 11.31 3/5/2017 20.10 0.00 0.00 0.154 20.25 0.257 0.154 0.014 0.000 0.594 0.400 2.97 2.02 2.77 11.07 5.40 2.79 12.07 20.25 0.014 11.91 3/6/2017 20.74 0.00 0.00 0.172 20.91 0.248 0.172 0.013 0.000 0.575 0.297 4.18 2.15 2.47 10.81 6.75 2.48 11.68 20.91 0.014 11.51 3/7/2017 20.54 0.00 0.00 0.174 20.72 0.646 0.174 0.035 0.000 1.495 0.219 3.12 2.21 2.54 10.28 6.15 2.58 11.99 20.72 0.035 11.82 3/8/2017 19.82 0.00 0.00 0.172 19.99 0.253 0.172 0.014 0.000 0.585 0.226 2.97 1.96 2.29 11.53 5.35 2.30 12.34 19.99 0.014 12.17 3/9/2017 23.94 0.00 0.00 0.177 24.12 0.297 0.177 0.016 0.000 0.686 0.242 4.58 2.10 2.56 13.47 7.15 2.58 14.39 24.12 0.016 14.22 3/10/2017 19.34 0.00 0.00 0.174 19.51 0.238 0.174 0.013 0.000 0.550 0.225 3.50 2.07 2.19 10.55 5.98 2.20 11.33 19.51 0.013 11.15 3/11/2017 19.79 0.00 0.00 0.162 19.95 0.257 0.162 0.014 0.000 0.595 0.206 2.64 2.06 2.59 11.43 5.12 2.60 12.24 19.95 0.014 12.07 3/12/2017 17.73 0.00 0.00 0.153 17.88 0.215 0.153 0.012 0.000 0.498 0.193 3.38 1.78 2.30 9.35 5.53 2.32 10.04 17.88 0.012 9.89 3/13/2017 20.50 0.00 0.00 0.144 20.65 0.257 0.144 0.014 0.000 0.594 0.206 3.35 2.01 2.45 11.62 5.76 2.46 12.42 20.65 0.014 12.28 3/14/2017 20.19 0.00 0.00 0.150 20.34 0.249 0.150 0.013 0.000 0.577 0.208 3.54 1.85 2.44 11.31 5.79 2.45 12.10 20.34 0.013 11.95 3/15/2017 18.83 0.00 0.00 0.149 18.98 0.233 0.149 0.013 0.000 0.540 0.219 3.27 1.95 2.12 10.49 5.60 2.13 11.25 18.98 0.013 11.10 3/16/2017 19.27 0.00 0.00 0.152 19.42 0.239 0.152 0.013 0.000 0.552 0.211 3.34 1.96 2.32 10.63 5.70 2.33 11.40 19.42 0.013 11.24 3/17/2017 21.14 0.00 0.00 0.158 21.30 0.260 0.158 0.014 0.000 0.602 0.226 3.77 2.10 2.61 11.56 6.29 2.62 12.39 21.30 0.014 12.23 3/18/2017 18.32 0.00 0.00 0.154 18.47 0.223 0.154 0.012 0.000 0.516 0.215 3.45 1.82 2.26 9.83 5.64 2.27 10.56 18.47 0.012 10.41 3/19/2017 20.72 0.00 0.00 0.159 20.88 0.267 0.159 0.014 0.000 0.617 0.207 2.91 2.09 2.85 11.76 5.43 2.86 12.59 20.88 0.014 12.43 3/20/2017 19.77 0.00 0.00 0.155 19.93 0.235 0.155 0.013 0.000 0.545 0.212 4.07 1.97 2.30 10.42 6.43 2.31 11.18 19.93 0.013 11.02 3/21/2017 22.80 0.00 0.00 0.173 22.97 0.290 0.173 0.016 0.000 0.671 0.231 5.11 2.21 2.57 11.70 7.78 2.59 12.60 22.97 0.016 12.43 3/22/2017 22.69 0.00 0.00 0.174 22.86 0.251 0.174 0.014 0.000 0.580 0.244 5.97 1.98 2.34 11.32 8.37 2.35 12.14 22.86 0.014 11.97 3/23/2017 24.04 0.00 0.00 0.176 24.22 0.250 0.176 0.013 0.000 0.579 0.220 7.35 2.10 2.33 11.19 9.88 2.35 11.99 24.22 0.013 11.82 3/24/2017 20.93 0.00 0.00 0.161 21.09 0.233 0.161 0.013 0.000 0.539 0.227 5.39 2.01 2.22 10.30 7.80 2.23 11.06 21.09 0.013 10.90 APPENDIX B – DAILY IBT AMOUNTS B-3 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 3/25/2017 22.62 0.00 0.00 0.165 22.79 0.260 0.165 0.014 0.000 0.601 0.246 5.29 2.18 2.68 11.35 7.90 2.69 12.20 22.79 0.014 12.03 3/26/2017 23.45 0.00 0.00 0.172 23.62 0.252 0.172 0.014 0.000 0.583 0.240 6.66 2.08 2.66 10.96 9.16 2.68 11.78 23.62 0.014 11.61 3/27/2017 21.18 3.13 0.00 0.206 24.52 0.402 0.206 0.022 0.000 0.929 0.225 5.85 2.40 2.64 11.85 8.86 2.66 13.00 24.52 0.022 9.67 3/28/2017 18.84 6.67 0.00 0.181 25.69 0.975 0.181 0.053 0.000 2.256 0.231 4.90 2.36 2.61 12.12 8.42 2.66 14.60 25.69 0.053 7.75 3/29/2017 18.74 0.00 0.00 0.176 18.92 0.231 0.176 0.012 0.000 0.534 0.248 3.36 1.96 2.13 10.26 5.73 2.14 11.04 18.92 0.012 10.87 3/30/2017 22.54 0.00 0.00 0.209 22.75 0.497 0.209 0.027 0.000 1.149 0.233 4.03 2.29 2.50 11.81 7.03 2.53 13.20 22.75 0.027 12.99 3/31/2017 22.26 0.00 0.00 0.172 22.43 0.270 0.172 0.015 0.000 0.625 0.230 4.24 2.02 2.55 12.31 6.70 2.56 13.17 22.43 0.015 12.99 4/1/2017 20.98 0.00 0.00 0.178 21.16 0.261 0.178 0.014 0.000 0.604 0.242 3.57 2.09 2.70 11.50 6.10 2.71 12.34 21.16 0.014 12.17 4/2/2017 21.64 0.00 0.00 0.161 21.80 0.273 0.161 0.015 0.000 0.631 0.250 3.44 2.16 2.83 12.04 6.03 2.84 12.92 21.80 0.015 12.76 4/3/2017 21.34 0.00 0.00 0.187 21.53 0.258 0.187 0.014 0.000 0.598 0.239 4.12 2.00 2.51 11.60 6.57 2.52 12.44 21.53 0.014 12.25 4/4/2017 24.50 0.00 0.00 0.184 24.68 0.650 0.184 0.035 0.000 1.504 0.240 3.91 2.39 2.83 12.94 7.13 2.87 14.68 24.68 0.035 14.50 4/5/2017 15.74 0.00 0.00 0.176 15.92 0.206 0.176 0.011 0.000 0.476 0.262 2.07 1.61 1.93 9.18 4.06 1.94 9.92 15.92 0.011 9.74 4/6/2017 14.05 0.00 0.00 0.164 14.21 0.300 0.164 0.016 0.000 0.694 0.207 -2.89 2.32 2.71 10.69 -0.11 2.73 11.59 14.21 0.016 11.43 4/7/2017 20.01 0.00 0.00 0.166 20.18 0.261 0.166 0.014 0.000 0.603 0.218 2.62 1.95 2.35 11.99 5.00 2.36 12.82 20.18 0.014 12.65 4/8/2017 18.15 0.00 0.00 0.170 18.32 0.227 0.170 0.012 0.000 0.524 0.230 3.06 1.89 2.26 9.94 5.35 2.27 10.70 18.32 0.012 10.53 4/9/2017 20.73 0.00 0.00 0.162 20.89 0.259 0.162 0.014 0.000 0.599 0.216 3.45 2.18 2.67 11.34 6.05 2.68 12.16 20.89 0.014 11.99 4/10/2017 21.00 0.00 0.00 0.169 21.17 0.317 0.169 0.017 0.000 0.734 0.253 3.07 2.34 2.48 11.79 5.89 2.50 12.78 21.17 0.017 12.61 4/11/2017 20.36 0.00 0.00 0.195 20.56 0.284 0.195 0.015 0.000 0.656 0.269 3.03 2.31 2.36 11.44 5.82 2.38 12.36 20.56 0.015 12.17 4/12/2017 20.60 0.00 0.00 0.225 20.83 0.542 0.225 0.029 0.000 1.253 0.257 2.81 2.30 1.65 11.76 5.88 1.68 13.27 20.83 0.029 13.05 4/13/2017 21.85 0.00 0.00 0.237 22.09 0.946 0.237 0.051 0.000 2.187 0.268 3.14 2.88 1.04 11.34 7.20 1.09 13.79 22.09 0.051 13.56 4/14/2017 21.58 0.00 0.00 0.249 21.83 1.014 0.249 0.055 0.000 2.346 0.265 2.77 0.05 4.48 10.61 4.08 4.53 13.22 21.83 0.055 12.97 4/15/2017 21.19 0.00 0.00 0.187 21.38 0.825 0.187 0.044 0.000 1.909 0.264 2.88 0.00 4.61 10.65 3.89 4.66 12.83 21.38 0.044 12.64 4/16/2017 22.68 0.00 0.00 0.246 22.93 1.174 0.246 0.063 0.000 2.715 0.268 2.70 0.00 4.96 10.80 4.12 5.03 13.78 22.93 0.063 13.53 4/17/2017 21.62 0.00 0.00 0.211 21.83 0.719 0.211 0.039 0.000 1.664 0.274 2.75 0.00 4.85 11.33 3.68 4.89 13.27 21.83 0.039 13.05 4/18/2017 23.06 0.00 0.00 0.201 23.26 1.040 0.201 0.056 0.000 2.405 0.361 3.41 0.00 4.63 11.16 4.65 4.69 13.92 23.26 0.056 13.72 4/19/2017 20.82 0.00 0.00 0.214 21.03 0.714 0.214 0.038 0.000 1.652 0.377 1.86 0.00 4.65 11.53 2.79 4.69 13.56 21.03 0.038 13.34 4/20/2017 23.21 0.00 0.00 0.287 23.50 1.147 0.287 0.062 0.000 2.653 0.352 3.21 0.00 4.65 11.14 4.64 4.71 14.15 23.50 0.062 13.86 4/21/2017 23.24 0.00 0.00 0.238 23.48 1.269 0.238 0.068 0.000 2.935 0.395 3.13 0.00 4.51 10.93 4.64 4.58 14.26 23.48 0.068 14.02 4/22/2017 23.49 0.00 0.00 0.277 23.77 1.300 0.277 0.070 0.000 3.008 0.300 3.30 0.00 4.67 10.85 4.88 4.74 14.15 23.77 0.070 13.88 4/23/2017 19.58 0.00 0.00 0.296 19.88 0.250 0.296 0.013 0.000 0.579 0.279 3.03 0.00 4.61 10.82 3.58 4.62 11.68 19.88 0.013 11.38 4/24/2017 20.89 0.00 0.00 0.179 21.07 0.273 0.179 0.015 0.000 0.631 0.223 2.71 0.00 4.65 12.39 3.16 4.66 13.24 21.07 0.015 13.06 4/25/2017 18.79 0.00 0.00 0.225 19.02 0.249 0.225 0.013 0.000 0.576 0.255 2.25 0.00 3.96 11.49 2.72 3.97 12.32 19.02 0.013 12.09 4/26/2017 21.23 0.00 0.00 0.182 21.41 0.270 0.182 0.015 0.001 0.625 0.241 3.22 0.00 2.60 14.26 3.67 2.62 15.12 21.41 0.015 14.94 4/27/2017 21.73 0.00 0.00 0.254 21.98 0.277 0.254 0.015 0.000 0.641 0.234 3.32 0.00 3.01 14.23 3.85 3.03 15.11 21.98 0.015 14.85 4/28/2017 22.86 0.00 0.00 0.227 23.09 0.293 0.227 0.016 0.000 0.678 0.240 3.34 0.00 4.32 13.97 3.86 4.34 14.89 23.09 0.016 14.66 4/29/2017 21.66 0.00 0.00 0.289 21.95 0.284 0.289 0.015 0.000 0.657 0.270 2.81 0.00 5.08 12.54 3.38 5.10 13.47 21.95 0.015 13.18 4/30/2017 23.70 0.00 0.00 0.246 23.95 0.306 0.246 0.016 0.000 0.708 0.240 3.34 0.00 5.43 13.66 3.89 5.45 14.61 23.95 0.016 14.36 5/1/2017 21.80 0.00 0.00 0.260 22.06 0.285 0.260 0.015 0.000 0.659 0.284 2.87 0.00 4.67 13.02 3.41 4.68 13.96 22.06 0.015 13.70 5/2/2017 21.24 0.00 0.00 0.310 21.55 0.259 0.310 0.014 0.000 0.598 0.254 4.13 0.00 4.29 11.70 4.70 4.30 12.55 21.55 0.014 12.24 5/3/2017 23.59 0.00 0.00 0.247 23.84 0.519 0.247 0.028 0.001 1.200 0.352 2.45 0.00 5.01 14.02 3.22 5.04 15.58 23.84 0.029 15.33 5/4/2017 23.38 0.00 0.00 0.276 23.66 0.547 0.276 0.029 0.005 1.266 0.299 4.22 0.00 4.94 12.07 5.04 4.97 13.64 23.66 0.034 13.36 5/5/2017 19.22 0.00 0.00 0.210 19.43 0.245 0.210 0.013 0.000 0.566 0.280 2.94 0.00 4.34 10.84 3.39 4.35 11.68 19.43 0.013 11.47 APPENDIX B – DAILY IBT AMOUNTS B-4 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 5/6/2017 22.25 0.00 0.00 0.276 22.53 0.274 0.276 0.015 0.000 0.634 0.282 4.07 0.00 5.16 11.82 4.62 5.17 12.74 22.53 0.015 12.46 5/7/2017 20.43 0.00 0.00 0.258 20.69 0.270 0.258 0.015 0.000 0.625 0.292 2.48 0.00 5.19 11.56 3.01 5.21 12.47 20.69 0.015 12.22 5/8/2017 21.74 0.00 0.00 0.254 22.00 0.394 0.254 0.021 0.000 0.911 0.278 2.95 0.00 5.16 12.02 3.60 5.18 13.21 22.00 0.021 12.96 5/9/2017 22.56 0.00 0.00 0.298 22.86 0.405 0.298 0.022 0.000 0.937 0.308 3.81 0.00 5.06 12.02 4.51 5.08 13.26 22.86 0.022 12.96 5/10/2017 19.72 0.00 0.00 0.216 19.94 0.253 0.216 0.014 0.001 0.585 0.297 2.90 0.00 4.39 11.28 3.37 4.41 12.16 19.94 0.014 11.94 5/11/2017 22.35 0.00 0.00 0.327 22.68 0.819 0.327 0.044 0.000 1.895 0.316 2.61 0.00 4.79 11.88 3.76 4.83 14.09 22.68 0.045 13.76 5/12/2017 22.95 0.00 0.00 0.229 23.18 0.606 0.229 0.033 0.000 1.401 0.303 4.08 0.00 4.73 11.79 4.91 4.77 13.50 23.18 0.033 13.27 5/13/2017 20.10 0.00 0.00 0.262 20.36 0.264 0.262 0.014 0.000 0.611 0.313 2.57 0.00 4.79 11.53 3.10 4.81 12.46 20.36 0.014 12.20 5/14/2017 21.45 0.00 0.00 0.266 21.72 0.268 0.266 0.014 0.000 0.620 0.296 3.66 0.00 5.05 11.54 4.19 5.07 12.45 21.72 0.014 12.19 5/15/2017 21.59 0.00 0.00 0.275 21.86 0.692 0.275 0.037 0.000 1.600 0.336 2.23 0.00 5.10 11.60 3.19 5.13 13.53 21.86 0.038 13.26 5/16/2017 25.38 0.00 0.00 0.393 25.77 1.514 0.393 0.082 0.000 3.502 0.455 3.37 0.00 5.22 11.24 5.27 5.30 15.20 25.77 0.082 14.81 5/17/2017 28.45 0.00 0.00 0.292 28.74 1.765 0.292 0.095 0.001 4.082 0.481 4.80 0.00 5.54 11.69 6.86 5.63 16.25 28.74 0.096 15.96 5/18/2017 25.31 0.00 0.00 0.369 25.68 1.335 0.369 0.072 0.000 3.087 0.504 4.36 0.00 4.93 11.03 6.06 5.00 14.62 25.68 0.072 14.25 5/19/2017 26.11 0.00 0.00 0.316 26.43 2.058 0.316 0.111 0.000 4.761 0.445 3.22 0.00 4.83 10.68 5.59 4.94 15.89 26.43 0.111 15.57 5/20/2017 25.99 0.00 0.00 0.403 26.39 1.876 0.403 0.101 0.000 4.338 0.582 3.81 0.00 4.89 10.39 6.09 4.99 15.31 26.39 0.101 14.91 5/21/2017 24.79 0.00 0.00 0.248 25.04 1.333 0.248 0.072 0.000 3.082 0.442 3.85 0.00 5.18 10.83 5.43 5.25 14.36 25.04 0.072 14.11 5/22/2017 22.41 0.00 0.00 0.291 22.70 0.619 0.291 0.033 0.000 1.431 0.417 3.42 0.00 4.94 11.55 4.33 4.98 13.40 22.70 0.033 13.10 5/23/2017 23.27 0.00 0.00 0.272 23.54 0.286 0.272 0.015 0.000 0.662 0.379 4.27 0.00 5.08 12.58 4.83 5.10 13.62 23.54 0.015 13.35 5/24/2017 20.47 0.00 0.00 0.174 20.64 0.256 0.174 0.014 0.000 0.592 0.267 3.40 0.00 4.48 11.46 3.83 4.49 12.32 20.64 0.014 12.15 5/25/2017 21.85 0.00 0.00 0.329 22.18 0.275 0.329 0.015 0.001 0.637 0.383 3.64 0.00 4.80 12.10 4.24 4.81 13.12 22.18 0.015 12.80 5/26/2017 23.68 0.00 0.00 0.257 23.94 0.490 0.257 0.026 0.000 1.134 0.298 4.73 0.00 5.11 11.89 5.48 5.14 13.32 23.94 0.026 13.06 5/27/2017 22.74 0.00 0.00 0.337 23.08 0.808 0.337 0.044 0.000 1.870 0.389 3.84 0.00 5.10 10.69 4.99 5.14 12.95 23.08 0.044 12.61 5/28/2017 20.93 0.00 0.00 0.263 21.19 0.589 0.263 0.032 0.000 1.361 0.355 3.01 0.00 4.90 10.69 3.86 4.93 12.40 21.19 0.032 12.14 5/29/2017 22.74 0.00 0.00 0.301 23.04 0.524 0.301 0.028 0.000 1.211 0.342 4.37 0.00 5.40 10.87 5.19 5.43 12.42 23.04 0.028 12.12 5/30/2017 24.89 0.00 0.00 0.342 25.23 1.244 0.342 0.067 0.000 2.878 0.480 3.43 0.00 5.11 11.68 5.02 5.17 15.04 25.23 0.067 14.70 5/31/2017 24.17 0.00 0.00 0.280 24.45 0.646 0.280 0.035 0.000 1.494 0.435 4.53 0.00 4.95 12.08 5.46 4.98 14.01 24.45 0.035 13.73 6/1/2017 26.91 0.00 0.00 0.443 27.35 1.521 0.443 0.082 0.002 3.519 0.570 5.01 0.00 4.88 11.33 6.97 4.96 15.42 27.35 0.084 14.98 6/2/2017 26.01 0.00 0.00 0.397 26.41 1.459 0.397 0.079 0.002 3.376 0.472 3.90 0.00 4.73 11.99 5.76 4.81 15.84 26.41 0.080 15.45 6/3/2017 26.05 0.00 0.00 0.442 26.49 1.660 0.442 0.089 0.000 3.839 0.596 3.81 0.00 4.90 11.16 5.91 4.98 15.60 26.49 0.089 15.15 6/4/2017 26.84 0.00 0.00 0.286 27.13 1.742 0.286 0.094 0.000 4.029 0.483 4.14 0.00 5.23 11.12 6.17 5.32 15.64 27.13 0.094 15.35 6/5/2017 20.89 0.00 0.00 0.254 21.14 0.261 0.254 0.014 0.000 0.604 0.394 3.55 0.00 4.70 11.37 4.07 4.71 12.37 21.14 0.014 12.11 6/6/2017 24.93 0.00 0.00 0.287 25.22 0.531 0.287 0.029 0.000 1.228 0.473 5.19 0.00 5.17 12.31 6.01 5.19 14.02 25.22 0.029 13.73 6/7/2017 24.09 0.00 0.00 0.271 24.36 0.748 0.271 0.040 0.001 1.730 0.443 4.61 0.00 4.93 11.59 5.63 4.97 13.76 24.36 0.041 13.49 6/8/2017 25.68 0.00 0.00 0.373 26.05 1.036 0.373 0.056 0.000 2.396 0.612 5.54 0.00 4.88 11.16 6.95 4.93 14.17 26.05 0.056 13.80 6/9/2017 28.07 0.00 0.00 0.246 28.32 1.890 0.246 0.102 0.010 4.373 0.557 5.73 0.00 4.85 10.56 7.87 4.96 15.49 28.32 0.111 15.24 6/10/2017 27.77 0.00 0.00 0.337 28.11 1.720 0.337 0.093 0.000 3.979 0.605 6.03 0.00 4.89 10.45 8.09 4.99 15.03 28.11 0.093 14.70 6/11/2017 28.68 0.00 0.00 0.281 28.96 2.174 0.281 0.117 0.000 5.029 0.540 5.25 0.00 5.04 10.53 7.71 5.16 16.10 28.96 0.117 15.82 6/12/2017 26.20 0.00 0.00 0.299 26.50 1.579 0.299 0.085 0.001 3.653 0.504 4.93 0.00 4.79 10.66 6.81 4.87 14.82 26.50 0.086 14.52 6/13/2017 27.05 0.00 0.00 0.431 27.48 1.990 0.431 0.107 0.000 4.603 0.665 4.75 0.00 4.64 10.30 7.17 4.74 15.57 27.48 0.107 15.14 6/14/2017 30.51 0.00 0.00 0.360 30.87 2.575 0.360 0.139 0.000 5.955 0.611 5.56 0.00 4.70 10.97 8.49 4.84 17.53 30.87 0.139 17.17 6/15/2017 25.65 0.00 0.00 0.382 26.03 1.243 0.382 0.067 0.001 2.876 0.673 5.28 0.00 4.67 10.84 6.91 4.74 14.38 26.03 0.068 14.00 6/16/2017 26.30 0.00 0.00 0.314 26.61 0.712 0.314 0.038 0.000 1.648 0.509 4.59 0.00 5.04 13.77 5.62 5.07 15.92 26.61 0.038 15.61 APPENDIX B – DAILY IBT AMOUNTS B-5 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 6/17/2017 22.33 0.00 0.00 0.245 22.58 0.280 0.245 0.015 0.000 0.647 0.460 3.74 0.00 4.76 12.43 4.26 4.78 13.53 22.58 0.015 13.29 6/18/2017 22.55 0.00 0.00 0.247 22.80 0.279 0.247 0.015 0.000 0.646 0.388 4.00 0.00 5.25 11.97 4.53 5.26 13.01 22.80 0.015 12.76 6/19/2017 23.40 0.00 0.00 0.263 23.66 0.391 0.263 0.021 0.000 0.904 0.463 4.62 0.00 5.05 11.95 5.27 5.07 13.32 23.66 0.021 13.05 6/20/2017 21.16 0.00 0.00 0.251 21.41 0.267 0.251 0.014 0.000 0.618 0.487 3.41 0.00 4.73 11.63 3.93 4.74 12.74 21.41 0.014 12.49 6/21/2017 21.58 0.00 0.00 0.219 21.80 0.282 0.219 0.015 0.000 0.652 0.426 2.82 0.00 5.02 12.37 3.32 5.04 13.44 21.80 0.015 13.22 6/22/2017 23.58 0.00 0.00 0.292 23.87 0.716 0.292 0.039 0.000 1.656 0.478 3.70 0.00 4.96 12.03 4.71 5.00 14.16 23.87 0.039 13.87 6/23/2017 22.31 0.00 0.00 0.256 22.57 1.309 0.256 0.071 0.000 3.029 0.448 2.79 0.00 3.04 11.63 4.36 3.11 15.10 22.57 0.071 14.85 6/24/2017 23.75 0.00 0.00 0.301 24.05 0.294 0.301 0.016 0.000 0.680 0.503 4.26 0.00 6.37 11.62 4.85 6.39 12.81 24.05 0.016 12.51 6/25/2017 22.84 0.00 0.00 0.215 23.06 0.277 0.215 0.015 0.000 0.640 0.347 4.43 0.00 5.11 12.02 4.92 5.12 13.01 23.06 0.015 12.79 6/26/2017 21.81 0.00 0.00 0.234 22.04 0.270 0.234 0.015 0.000 0.625 0.394 3.85 0.00 5.02 11.64 4.35 5.03 12.66 22.04 0.015 12.42 6/27/2017 26.12 0.00 0.00 0.277 26.39 1.267 0.277 0.068 0.000 2.932 0.545 4.66 0.00 4.86 11.79 6.20 4.93 15.27 26.39 0.068 14.99 6/28/2017 27.96 0.00 0.00 0.283 28.24 1.432 0.283 0.077 0.000 3.311 0.514 5.63 0.00 4.81 12.19 7.34 4.89 16.01 28.24 0.077 15.73 6/29/2017 27.04 0.00 0.00 0.342 27.38 1.808 0.342 0.097 0.000 4.182 0.520 4.49 0.00 4.71 11.23 6.64 4.81 15.94 27.38 0.097 15.59 6/30/2017 27.27 0.00 0.00 0.302 27.57 1.620 0.302 0.087 0.001 3.747 0.424 5.36 0.00 4.72 11.31 7.28 4.81 15.48 27.57 0.088 15.18 7/1/2017 23.96 0.00 0.00 0.290 24.25 1.101 0.290 0.059 0.000 2.546 0.464 4.67 0.00 4.64 10.48 6.06 4.70 13.49 24.25 0.059 13.20 7/2/2017 25.20 0.00 0.00 0.333 25.53 1.472 0.333 0.079 0.000 3.406 0.392 5.35 0.00 4.50 10.00 7.16 4.58 13.80 25.53 0.079 13.47 7/3/2017 25.86 0.00 0.00 0.311 26.17 1.419 0.311 0.076 0.000 3.281 0.396 6.17 0.00 4.35 10.17 7.90 4.42 13.85 26.17 0.077 13.54 7/4/2017 23.90 0.00 0.00 0.357 24.26 1.074 0.357 0.058 0.000 2.484 0.453 4.77 0.00 4.47 10.59 6.20 4.53 13.52 24.26 0.058 13.17 7/5/2017 25.62 0.00 0.00 0.300 25.92 0.925 0.300 0.050 0.000 2.140 0.389 5.41 0.00 4.73 11.97 6.64 4.78 14.50 25.92 0.050 14.20 7/6/2017 27.65 0.00 0.00 0.303 27.95 1.874 0.303 0.101 0.000 4.335 0.448 5.14 0.00 4.73 11.02 7.32 4.83 15.81 27.95 0.101 15.50 7/7/2017 29.02 0.00 0.00 0.289 29.31 2.344 0.289 0.126 0.000 5.423 0.462 5.84 0.00 4.59 10.23 8.47 4.72 16.12 29.31 0.127 15.83 7/8/2017 29.89 0.00 0.00 0.429 30.32 2.886 0.429 0.155 0.000 6.675 0.527 4.72 0.00 4.68 10.25 8.03 4.83 17.45 30.32 0.155 17.02 7/9/2017 25.78 0.00 0.00 0.264 26.04 1.952 0.264 0.105 0.000 4.516 0.431 3.67 0.00 4.82 10.29 5.89 4.92 15.24 26.04 0.105 14.97 7/10/2017 24.08 0.00 0.00 0.373 24.45 1.589 0.373 0.086 0.000 3.675 0.444 2.84 0.00 4.62 10.83 4.80 4.70 14.95 24.45 0.086 14.57 7/11/2017 28.20 0.00 0.00 0.466 28.67 2.635 0.466 0.142 0.000 6.096 0.599 4.44 0.00 4.58 9.71 7.54 4.72 16.40 28.67 0.142 15.94 7/12/2017 32.46 0.00 0.00 0.415 32.87 3.370 0.415 0.182 0.000 7.796 0.601 5.00 0.00 4.60 10.91 8.79 4.78 19.31 32.87 0.182 18.89 7/13/2017 31.87 0.00 0.00 0.439 32.31 3.070 0.439 0.165 0.000 7.102 0.672 4.87 0.00 4.55 11.45 8.38 4.71 19.22 32.31 0.165 18.78 7/14/2017 28.03 0.00 0.00 0.387 28.42 2.533 0.387 0.136 0.000 5.858 0.569 4.14 0.00 4.47 10.32 7.06 4.61 16.75 28.42 0.136 16.36 7/15/2017 30.46 0.00 0.00 0.475 30.94 3.411 0.475 0.184 0.000 7.889 0.598 3.63 0.00 4.59 10.16 7.52 4.78 18.64 30.94 0.184 18.17 7/16/2017 29.62 0.00 0.00 0.367 29.99 2.848 0.367 0.153 0.000 6.588 0.467 4.11 0.00 4.80 10.66 7.32 4.95 17.71 29.99 0.153 17.35 7/17/2017 26.20 0.00 0.00 0.448 26.65 1.697 0.448 0.091 0.000 3.926 0.508 4.58 0.00 4.64 10.75 6.73 4.74 15.19 26.65 0.091 14.74 7/18/2017 27.72 0.00 0.00 0.429 28.15 2.226 0.429 0.120 0.000 5.148 0.618 4.06 0.00 4.58 10.96 6.71 4.70 16.73 28.15 0.120 16.30 7/19/2017 27.57 0.00 0.00 0.275 27.85 2.298 0.275 0.124 0.000 5.316 0.610 3.87 0.00 4.64 10.72 6.44 4.76 16.64 27.85 0.124 16.37 7/20/2017 29.48 0.00 0.00 0.445 29.93 2.763 0.445 0.149 0.000 6.391 0.719 4.63 0.00 4.53 10.30 7.84 4.68 17.41 29.93 0.149 16.96 7/21/2017 33.37 0.00 0.00 0.492 33.86 3.979 0.492 0.214 0.000 9.205 0.740 4.41 0.00 4.47 10.35 8.88 4.69 20.30 33.86 0.215 19.81 7/22/2017 32.68 0.00 0.00 0.442 33.12 3.998 0.442 0.215 0.000 9.248 0.700 4.33 0.00 4.62 9.57 8.77 4.83 19.52 33.12 0.215 19.08 7/23/2017 29.97 0.00 0.00 0.501 30.47 2.658 0.501 0.143 0.000 6.149 0.627 4.57 0.00 5.13 10.69 7.73 5.27 17.47 30.47 0.143 16.97 7/24/2017 25.12 0.00 0.00 0.221 25.34 1.313 0.221 0.071 0.000 3.037 0.518 4.21 0.00 4.81 11.16 5.74 4.88 14.71 25.34 0.071 14.49 7/25/2017 28.54 0.00 0.00 0.333 28.87 2.450 0.333 0.132 0.000 5.667 0.703 4.50 0.00 4.66 10.43 7.28 4.79 16.80 28.87 0.132 16.47 7/26/2017 30.10 0.00 0.00 0.454 30.56 2.958 0.454 0.159 0.000 6.841 0.673 4.55 0.00 4.48 10.44 7.96 4.64 17.96 30.56 0.159 17.50 7/27/2017 20.65 0.00 0.00 0.521 21.17 3.143 0.521 0.169 0.000 7.270 0.802 -5.51 0.00 4.51 10.26 -1.84 4.68 18.33 21.17 0.169 17.81 7/28/2017 27.62 0.00 0.00 0.319 27.94 1.920 0.319 0.103 0.000 4.442 0.660 5.12 0.00 4.50 10.88 7.36 4.60 15.98 27.94 0.103 15.66 APPENDIX B – DAILY IBT AMOUNTS B-6 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 7/29/2017 26.70 0.00 0.00 0.424 27.12 2.025 0.424 0.109 0.000 4.683 0.548 4.38 0.00 4.58 10.38 6.83 4.69 15.61 27.12 0.109 15.18 7/30/2017 27.40 0.00 0.00 0.327 27.73 2.097 0.327 0.113 0.000 4.852 0.551 5.01 0.00 4.67 10.11 7.43 4.78 15.51 27.73 0.113 15.19 7/31/2017 27.54 0.00 0.00 0.413 27.95 2.168 0.413 0.117 0.000 5.015 0.568 4.86 0.00 4.50 10.31 7.44 4.62 15.89 27.95 0.117 15.48 8/1/2017 30.69 0.00 0.00 0.414 31.10 3.152 0.414 0.170 0.000 7.291 0.729 4.63 0.00 4.44 10.27 8.20 4.61 18.29 31.10 0.170 17.88 8/2/2017 29.10 0.00 0.00 0.330 29.43 2.773 0.330 0.149 0.000 6.415 0.637 3.92 0.00 4.50 10.70 7.02 4.65 17.76 29.43 0.149 17.43 8/3/2017 30.99 0.00 0.00 0.559 31.55 3.079 0.559 0.166 0.000 7.123 0.782 5.62 0.00 4.44 9.78 9.26 4.60 17.69 31.55 0.166 17.13 8/4/2017 31.14 0.00 0.00 0.379 31.52 3.388 0.379 0.183 0.000 7.837 0.706 4.77 0.00 4.38 9.87 8.54 4.57 18.42 31.52 0.183 18.04 8/5/2017 30.53 0.00 0.00 0.479 31.01 3.547 0.479 0.191 0.000 8.204 0.719 4.12 0.00 4.47 9.28 8.15 4.67 18.20 31.01 0.191 17.72 8/6/2017 29.10 0.00 0.00 0.391 29.49 3.007 0.391 0.162 0.000 6.955 0.593 3.79 0.00 4.68 9.91 7.19 4.85 17.46 29.49 0.162 17.07 8/7/2017 26.52 0.00 0.00 0.317 26.84 1.643 0.317 0.089 0.000 3.801 0.535 4.73 0.00 4.66 11.07 6.69 4.74 15.40 26.84 0.089 15.09 8/8/2017 26.27 0.00 0.00 0.436 26.71 1.237 0.436 0.067 0.000 2.862 0.580 4.27 0.00 4.73 12.52 5.94 4.80 15.97 26.71 0.067 15.53 8/9/2017 25.85 0.00 0.00 0.226 26.08 1.238 0.226 0.067 0.000 2.864 0.441 5.19 0.00 4.66 11.39 6.65 4.73 14.69 26.08 0.067 14.46 8/10/2017 27.39 0.00 0.00 0.395 27.79 2.208 0.395 0.119 0.000 5.107 0.533 4.41 0.00 4.58 10.43 7.01 4.70 16.07 27.79 0.119 15.68 8/11/2017 27.24 0.00 0.00 0.287 27.53 2.064 0.287 0.111 0.000 4.774 0.602 4.55 0.00 4.59 10.55 6.90 4.70 15.92 27.53 0.111 15.64 8/12/2017 24.61 0.00 0.00 0.344 24.95 1.250 0.344 0.067 0.000 2.890 0.450 3.90 0.00 4.94 11.11 5.49 5.01 14.45 24.95 0.067 14.11 8/13/2017 25.92 0.00 0.00 0.276 26.20 1.522 0.276 0.082 0.000 3.521 0.452 4.56 0.00 4.95 10.83 6.36 5.04 14.80 26.20 0.082 14.53 8/14/2017 22.95 0.00 0.00 0.277 23.23 0.782 0.277 0.042 0.000 1.809 0.494 3.74 0.00 4.75 11.33 4.80 4.79 13.64 23.23 0.043 13.36 8/15/2017 25.85 0.00 0.00 0.446 26.30 1.174 0.446 0.063 0.000 2.716 0.524 4.89 0.00 4.87 11.61 6.51 4.93 14.85 26.30 0.063 14.41 8/16/2017 27.90 0.00 0.00 0.313 28.21 2.011 0.313 0.108 0.000 4.651 0.484 5.08 0.00 4.77 10.79 7.40 4.88 15.93 28.21 0.108 15.61 8/17/2017 26.88 0.00 0.00 0.384 27.26 1.671 0.384 0.090 0.000 3.866 0.612 4.98 0.00 4.65 11.02 7.04 4.74 15.49 27.26 0.090 15.11 8/18/2017 29.94 0.00 0.00 0.310 30.25 2.340 0.310 0.126 0.000 5.412 0.590 5.31 0.00 4.59 11.57 7.96 4.72 17.57 30.25 0.126 17.26 8/19/2017 28.26 0.00 0.00 0.378 28.64 2.086 0.378 0.112 0.000 4.826 0.549 5.77 0.00 4.60 10.31 8.23 4.72 15.69 28.64 0.112 15.31 8/20/2017 29.43 0.00 0.00 0.416 29.85 2.529 0.416 0.136 0.000 5.850 0.522 5.47 0.00 4.64 10.28 8.42 4.78 16.65 29.85 0.136 16.24 8/21/2017 25.83 0.00 0.00 0.422 26.25 1.650 0.422 0.089 0.000 3.817 0.500 4.99 0.00 4.38 10.40 7.06 4.47 14.72 26.25 0.089 14.29 8/22/2017 29.29 0.00 0.00 0.519 29.81 2.402 0.519 0.129 0.000 5.556 0.548 5.84 0.00 4.48 10.33 8.76 4.61 16.44 29.81 0.129 15.92 8/23/2017 29.76 0.00 0.00 0.526 30.29 2.518 0.526 0.136 0.000 5.824 0.634 5.35 0.00 4.52 10.77 8.39 4.66 17.23 30.29 0.136 16.71 8/24/2017 29.03 0.00 0.00 0.362 29.39 2.462 0.362 0.133 0.000 5.695 0.648 4.88 0.00 4.58 10.63 7.70 4.71 16.97 29.39 0.133 16.61 8/25/2017 29.03 0.00 0.00 0.296 29.33 2.210 0.296 0.119 0.000 5.111 0.570 6.34 0.00 4.49 10.19 8.85 4.61 15.87 29.33 0.119 15.58 8/26/2017 28.86 0.00 0.00 0.394 29.25 2.718 0.394 0.146 0.000 6.286 0.536 4.33 0.00 4.63 10.22 7.44 4.77 17.04 29.25 0.146 16.64 8/27/2017 28.81 0.00 0.00 0.334 29.14 2.468 0.334 0.133 0.000 5.708 0.519 4.71 0.00 4.96 10.31 7.51 5.09 16.54 29.14 0.133 16.20 8/28/2017 26.67 0.00 0.00 0.393 27.06 1.722 0.393 0.093 0.000 3.983 0.447 5.49 0.00 4.50 10.43 7.60 4.59 14.86 27.06 0.093 14.47 8/29/2017 25.99 0.00 0.00 0.443 26.43 1.529 0.443 0.082 0.000 3.536 0.482 5.05 0.00 4.55 10.77 7.02 4.63 14.79 26.43 0.082 14.34 8/30/2017 26.46 0.00 0.00 0.263 26.73 1.623 0.263 0.087 0.000 3.754 0.589 4.77 0.00 4.66 10.98 6.66 4.75 15.32 26.73 0.087 15.06 8/31/2017 26.41 0.00 0.00 0.384 26.79 1.744 0.384 0.094 0.000 4.033 0.710 4.81 0.00 4.57 10.45 6.94 4.67 15.19 26.79 0.094 14.81 9/1/2017 26.81 0.00 0.00 0.269 27.08 1.128 0.269 0.061 0.000 2.608 0.599 5.69 0.00 4.98 11.74 7.09 5.04 14.95 27.08 0.061 14.68 9/2/2017 21.72 0.00 0.00 0.247 21.97 0.355 0.247 0.019 0.000 0.822 0.466 4.67 0.00 4.72 10.66 5.27 4.74 11.95 21.97 0.019 11.70 9/3/2017 22.62 0.00 0.00 0.262 22.88 1.029 0.262 0.055 0.000 2.381 0.431 4.65 0.00 4.46 9.62 5.94 4.51 12.43 22.88 0.055 12.17 9/4/2017 25.80 0.00 0.00 0.253 26.05 1.452 0.253 0.078 0.000 3.359 0.404 5.32 0.00 4.99 10.20 7.03 5.07 13.96 26.05 0.078 13.71 9/5/2017 26.82 0.00 0.00 0.382 27.20 1.644 0.382 0.089 0.000 3.803 0.534 4.88 0.00 4.89 10.98 6.91 4.98 15.31 27.20 0.089 14.93 9/6/2017 24.75 0.00 0.00 0.264 25.01 1.015 0.264 0.055 0.000 2.348 0.429 5.18 0.00 4.96 10.77 6.46 5.01 13.54 25.01 0.055 13.28 9/7/2017 22.66 0.00 0.00 0.333 22.99 0.794 0.333 0.043 0.000 1.836 0.458 4.36 0.00 4.54 10.63 5.49 4.58 12.92 22.99 0.043 12.59 9/8/2017 26.22 0.00 0.00 0.305 26.52 0.973 0.305 0.052 0.000 2.250 0.486 5.54 0.00 4.37 12.55 6.82 4.42 15.28 26.52 0.053 14.98 APPENDIX B – DAILY IBT AMOUNTS B-7 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 9/9/2017 22.51 0.00 0.00 0.281 22.79 0.907 0.281 0.049 0.000 2.097 0.542 3.51 0.00 4.68 10.72 4.70 4.73 13.36 22.79 0.049 13.08 9/10/2017 27.32 0.00 0.00 0.291 27.61 1.771 0.291 0.095 0.000 4.096 0.486 5.43 0.00 5.01 10.44 7.49 5.10 15.02 27.61 0.095 14.73 9/11/2017 24.13 0.00 0.00 0.250 24.38 0.575 0.250 0.031 0.000 1.329 0.411 5.68 0.00 5.12 10.98 6.50 5.15 12.72 24.38 0.031 12.47 9/12/2017 25.16 0.00 0.00 0.267 25.43 0.553 0.267 0.030 0.000 1.279 0.465 5.49 0.00 5.24 12.10 6.31 5.27 13.85 25.43 0.030 13.58 9/13/2017 23.22 0.00 0.00 0.214 23.43 0.527 0.214 0.028 0.000 1.218 0.418 4.77 0.00 4.82 11.44 5.51 4.84 13.08 23.43 0.028 12.86 9/14/2017 26.11 0.00 0.00 0.296 26.41 1.465 0.296 0.079 0.000 3.388 0.486 5.20 0.00 4.73 10.76 6.96 4.81 14.64 26.41 0.079 14.34 9/15/2017 26.12 0.00 0.00 0.263 26.38 1.650 0.263 0.089 0.000 3.818 0.477 5.03 0.00 4.52 10.53 6.94 4.61 14.83 26.38 0.089 14.57 9/16/2017 25.55 0.00 0.00 0.297 25.85 1.771 0.297 0.095 0.000 4.096 0.550 4.23 0.00 4.73 10.08 6.30 4.82 14.73 25.85 0.095 14.43 9/17/2017 24.12 0.00 0.00 0.289 24.41 1.497 0.289 0.081 0.000 3.463 0.451 3.08 0.00 5.06 10.49 4.87 5.14 14.41 24.41 0.081 14.12 9/18/2017 25.89 0.00 0.00 0.279 26.17 1.815 0.279 0.098 0.000 4.197 0.448 4.02 0.00 4.66 10.65 6.11 4.76 15.29 26.17 0.098 15.01 9/19/2017 26.31 0.00 0.00 0.385 26.70 1.751 0.385 0.094 0.000 4.050 0.568 3.96 0.00 4.56 11.33 6.10 4.65 15.95 26.70 0.094 15.56 9/20/2017 26.96 0.00 0.00 0.391 27.35 2.265 0.391 0.122 0.001 5.239 0.597 3.50 0.00 4.48 10.75 6.16 4.61 16.59 27.35 0.123 16.20 9/21/2017 27.51 0.00 0.00 0.463 27.97 2.103 0.463 0.113 0.001 4.864 0.610 4.86 0.00 4.54 10.42 7.42 4.65 15.89 27.97 0.114 15.43 9/22/2017 26.18 0.00 0.00 0.288 26.47 2.427 0.288 0.131 0.001 5.614 0.613 3.19 0.00 4.42 9.78 5.90 4.55 16.01 26.47 0.132 15.72 9/23/2017 27.98 0.00 0.00 0.299 28.28 2.446 0.299 0.132 0.000 5.658 0.628 4.45 0.00 4.62 10.05 7.20 4.75 16.34 28.28 0.132 16.04 9/24/2017 28.54 0.00 0.00 0.289 28.83 2.394 0.289 0.129 0.000 5.537 0.505 4.95 0.00 4.90 10.13 7.63 5.02 16.17 28.83 0.129 15.88 9/25/2017 24.63 0.00 0.00 0.244 24.87 1.703 0.244 0.092 0.000 3.938 0.551 2.84 0.00 4.91 10.59 4.79 5.00 15.08 24.87 0.092 14.84 9/26/2017 27.10 0.00 0.00 0.407 27.51 1.940 0.407 0.105 0.000 4.488 0.667 4.21 0.00 4.59 11.11 6.55 4.70 16.26 27.51 0.105 15.85 9/27/2017 27.34 0.00 0.00 0.332 27.67 2.464 0.332 0.133 0.002 5.698 0.670 2.74 0.00 4.53 11.09 5.54 4.67 17.46 27.67 0.135 17.13 9/28/2017 28.46 0.00 0.00 0.482 28.94 1.564 0.482 0.084 0.001 3.617 0.786 8.00 0.00 4.52 9.89 10.04 4.60 14.30 28.94 0.085 13.81 9/29/2017 30.34 0.00 0.00 0.348 30.69 3.488 0.348 0.188 0.000 8.068 0.736 3.96 0.00 4.28 9.62 7.80 4.47 18.42 30.69 0.188 18.07 9/30/2017 30.86 0.00 0.00 0.344 31.21 2.716 0.344 0.146 0.000 6.283 0.741 6.85 0.00 4.62 9.51 9.91 4.76 16.53 31.21 0.146 16.19 10/1/2017 28.95 0.00 0.00 0.311 29.26 2.755 0.311 0.148 0.000 6.373 0.679 4.08 0.00 4.89 10.02 7.15 5.04 17.07 29.26 0.148 16.76 10/2/2017 25.52 0.00 0.00 0.385 25.91 2.049 0.385 0.110 0.000 4.741 0.663 3.57 0.00 4.50 9.88 6.01 4.61 15.29 25.91 0.110 14.90 10/3/2017 28.03 0.00 0.00 0.386 28.42 2.822 0.386 0.152 0.001 6.527 0.768 3.60 0.00 4.44 9.73 6.81 4.59 17.02 28.42 0.153 16.64 10/4/2017 31.55 0.00 0.00 0.314 31.87 3.385 0.314 0.182 0.000 7.830 0.771 4.68 0.00 4.48 10.22 8.38 4.67 18.82 31.87 0.182 18.51 10/5/2017 28.84 0.00 0.00 0.423 29.26 2.578 0.423 0.139 0.000 5.964 0.787 4.84 0.00 4.49 10.04 7.84 4.63 16.79 29.26 0.139 16.37 10/6/2017 28.95 0.00 0.00 0.410 29.36 3.204 0.410 0.173 0.001 7.411 0.726 3.39 0.00 4.39 9.65 7.01 4.57 17.79 29.36 0.174 17.38 10/7/2017 30.89 0.00 0.00 0.442 31.33 2.908 0.442 0.157 0.000 6.727 0.769 5.54 0.00 4.60 10.18 8.89 4.76 17.68 31.33 0.157 17.24 10/8/2017 22.48 0.00 0.00 0.428 22.91 1.195 0.428 0.064 0.000 2.765 0.527 2.63 0.00 4.90 10.39 4.25 4.97 13.69 22.91 0.064 13.26 10/9/2017 24.62 0.00 0.00 0.432 25.06 1.516 0.432 0.082 0.000 3.506 0.585 3.71 0.00 4.59 10.64 5.65 4.67 14.73 25.06 0.082 14.30 10/10/2017 25.01 0.00 0.00 0.320 25.33 1.872 0.320 0.101 0.000 4.330 0.698 2.89 0.00 4.49 10.62 5.09 4.60 15.65 25.33 0.101 15.33 10/11/2017 27.97 0.00 0.00 0.291 28.27 1.871 0.291 0.101 0.000 4.327 0.656 4.19 0.00 4.62 12.20 6.36 4.72 17.19 28.27 0.101 16.90 10/12/2017 23.72 0.00 0.00 0.313 24.03 1.402 0.313 0.076 0.000 3.243 0.538 2.94 0.00 4.52 11.00 4.66 4.59 14.78 24.03 0.076 14.47 10/13/2017 26.07 0.00 0.00 0.203 26.27 1.884 0.203 0.101 0.000 4.358 0.553 3.62 0.00 4.82 10.73 5.71 4.92 15.64 26.27 0.101 15.44 10/14/2017 25.14 0.00 0.00 0.286 25.43 1.641 0.286 0.088 0.000 3.796 0.619 3.99 0.00 4.97 10.04 5.92 5.05 14.45 25.43 0.088 14.17 10/15/2017 26.16 0.00 0.00 0.252 26.41 1.795 0.252 0.097 0.000 4.152 0.562 3.93 0.00 5.03 10.59 5.98 5.13 15.30 26.41 0.097 15.05 10/16/2017 24.63 0.00 0.00 0.222 24.85 1.447 0.222 0.078 0.000 3.347 0.544 3.30 0.00 4.79 11.12 4.97 4.87 15.01 24.85 0.078 14.79 10/17/2017 22.72 0.00 0.00 0.274 23.00 1.107 0.274 0.060 0.001 2.560 0.538 3.43 0.00 4.56 10.48 4.81 4.62 13.57 23.00 0.060 13.30 10/18/2017 24.50 0.00 0.00 0.254 24.76 1.214 0.254 0.065 0.001 2.809 0.645 4.25 0.00 4.60 10.91 5.72 4.67 14.37 24.76 0.066 14.11 10/19/2017 26.37 0.00 0.00 0.362 26.73 2.015 0.362 0.109 0.001 4.662 0.545 3.79 0.00 4.62 10.62 6.17 4.73 15.83 26.73 0.109 15.46 10/20/2017 25.41 0.00 0.00 0.225 25.64 2.028 0.225 0.109 0.000 4.692 0.510 3.46 0.00 4.48 10.13 5.72 4.59 15.33 25.64 0.109 15.11 APPENDIX B – DAILY IBT AMOUNTS B-8 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 10/21/2017 26.83 0.00 0.00 0.312 27.15 2.370 0.312 0.128 0.000 5.482 0.534 4.00 0.00 4.61 9.71 6.68 4.74 15.72 27.15 0.128 15.41 10/22/2017 25.63 0.00 0.00 0.237 25.87 2.057 0.237 0.111 0.000 4.758 0.461 3.04 0.00 4.98 10.22 5.34 5.09 15.44 25.87 0.111 15.20 10/23/2017 24.58 0.00 0.00 0.263 24.84 0.954 0.263 0.051 0.001 2.208 0.460 4.96 0.00 4.89 11.06 6.18 4.94 13.72 24.84 0.052 13.46 10/24/2017 21.24 0.00 0.00 0.210 21.45 0.260 0.210 0.014 0.000 0.602 0.407 3.93 0.00 4.47 11.55 4.40 4.48 12.56 21.45 0.014 12.35 10/25/2017 22.90 0.00 0.00 0.180 23.08 1.198 0.180 0.065 0.000 2.772 0.411 2.51 0.00 4.63 11.31 3.89 4.69 14.49 23.08 0.065 14.31 10/26/2017 22.33 0.00 0.00 0.271 22.60 1.308 0.271 0.070 0.000 3.026 0.413 2.53 0.00 4.60 10.39 4.11 4.67 13.83 22.60 0.070 13.56 10/27/2017 24.85 0.00 0.00 0.213 25.06 1.361 0.213 0.073 0.000 3.149 0.487 5.05 0.00 4.40 10.33 6.63 4.47 13.96 25.06 0.073 13.75 10/28/2017 22.52 0.00 0.00 0.288 22.81 1.242 0.288 0.067 0.000 2.872 0.458 3.02 0.00 4.72 10.14 4.55 4.79 13.47 22.81 0.067 13.19 10/29/2017 21.61 0.00 0.00 0.208 21.82 0.287 0.208 0.015 0.000 0.664 0.341 2.48 0.00 5.39 12.43 2.98 5.40 13.44 21.82 0.015 13.23 10/30/2017 22.39 0.00 0.00 0.173 22.57 0.701 0.173 0.038 0.000 1.622 0.307 4.04 0.00 4.78 10.90 4.92 4.82 12.83 22.57 0.038 12.66 10/31/2017 21.13 0.00 0.00 0.248 21.38 0.602 0.248 0.032 0.000 1.393 0.379 3.47 0.00 4.66 10.59 4.32 4.70 12.36 21.38 0.032 12.12 11/1/2017 22.57 0.00 0.00 0.212 22.78 1.028 0.212 0.055 0.000 2.377 0.438 2.81 0.00 4.69 11.17 4.05 4.74 13.99 22.78 0.056 13.78 11/2/2017 24.07 0.00 0.00 0.238 24.31 1.283 0.238 0.069 0.000 2.967 0.450 4.15 0.00 4.62 10.53 5.67 4.69 13.95 24.31 0.069 13.71 11/3/2017 21.70 0.00 0.00 0.253 21.96 1.129 0.253 0.061 0.000 2.611 0.427 2.65 0.00 4.49 10.33 4.03 4.55 13.37 21.96 0.061 13.12 11/4/2017 22.94 0.00 0.00 0.209 23.14 1.331 0.209 0.072 0.000 3.079 0.390 2.97 0.00 4.74 10.35 4.51 4.82 13.82 23.14 0.072 13.61 11/5/2017 22.91 0.00 0.00 0.210 23.12 1.035 0.210 0.056 0.000 2.395 0.399 3.04 0.00 5.05 10.93 4.29 5.11 13.72 23.12 0.056 13.51 11/6/2017 22.13 0.00 0.00 0.184 22.32 0.843 0.184 0.045 0.000 1.951 0.403 3.50 0.00 4.80 10.58 4.53 4.85 12.94 22.32 0.045 12.75 11/7/2017 22.03 0.00 0.00 0.236 22.27 0.650 0.236 0.035 0.000 1.504 0.377 4.26 0.00 4.58 10.63 5.15 4.61 12.51 22.27 0.035 12.27 11/8/2017 21.10 0.00 0.00 0.198 21.30 0.690 0.198 0.037 0.000 1.596 0.375 2.90 0.00 4.62 10.88 3.78 4.66 12.86 21.30 0.037 12.66 11/9/2017 21.70 0.00 0.00 0.174 21.88 0.285 0.174 0.015 0.000 0.660 0.311 3.81 0.00 4.78 11.85 4.27 4.80 12.82 21.88 0.015 12.64 11/10/2017 20.32 0.00 0.00 0.140 20.46 0.431 0.140 0.023 0.000 0.996 0.378 3.40 0.00 4.61 10.48 3.97 4.63 11.86 20.46 0.023 11.72 11/11/2017 18.99 0.00 0.00 0.136 19.12 0.240 0.136 0.013 0.000 0.555 0.280 2.97 0.00 4.62 10.31 3.35 4.63 11.15 19.12 0.013 11.01 11/12/2017 20.56 0.00 0.00 0.124 20.68 0.495 0.124 0.027 0.000 1.145 0.275 2.59 0.00 5.01 11.01 3.21 5.04 12.44 20.68 0.027 12.31 11/13/2017 21.35 0.00 0.00 0.127 21.47 0.261 0.127 0.014 0.000 0.604 0.281 3.88 0.00 4.94 11.37 4.27 4.95 12.25 21.47 0.014 12.12 11/14/2017 20.19 0.00 0.00 0.139 20.32 0.388 0.139 0.021 0.000 0.898 0.253 2.80 0.00 4.74 11.09 3.33 4.76 12.24 20.32 0.021 12.10 11/15/2017 19.81 0.00 0.00 0.129 19.94 0.247 0.129 0.013 0.001 0.572 0.284 3.29 0.00 4.64 10.76 3.67 4.65 11.62 19.94 0.014 11.49 11/16/2017 20.31 0.00 0.00 0.136 20.45 0.542 0.136 0.029 0.000 1.253 0.352 2.55 0.00 4.68 10.91 3.23 4.71 12.51 20.45 0.029 12.38 11/17/2017 20.27 0.00 0.00 0.178 20.45 0.519 0.178 0.028 0.000 1.202 0.287 3.06 0.00 4.62 10.56 3.76 4.64 12.05 20.45 0.028 11.87 11/18/2017 19.14 0.00 0.00 0.137 19.28 0.269 0.137 0.015 0.000 0.623 0.244 2.51 0.00 4.87 10.61 2.92 4.88 11.47 19.28 0.015 11.34 11/19/2017 21.43 0.00 0.00 0.136 21.56 0.502 0.136 0.027 0.000 1.160 0.255 3.65 0.00 5.07 10.77 4.29 5.09 12.18 21.56 0.027 12.05 11/20/2017 21.13 0.00 0.00 0.153 21.28 0.755 0.153 0.041 0.001 1.746 0.265 2.83 0.00 4.83 10.66 3.74 4.87 12.67 21.28 0.042 12.52 11/21/2017 18.14 0.00 0.00 0.127 18.27 0.236 0.127 0.013 0.000 0.546 0.253 2.37 0.00 4.39 10.34 2.73 4.40 11.14 18.27 0.013 11.01 11/22/2017 20.02 0.00 0.00 0.130 20.15 0.293 0.130 0.016 0.000 0.679 0.268 2.99 0.00 4.89 10.88 3.42 4.91 11.83 20.15 0.016 11.70 11/23/2017 20.64 0.00 0.00 0.128 20.77 0.874 0.128 0.047 0.000 2.021 0.244 2.83 0.00 4.65 9.98 3.83 4.70 12.24 20.77 0.047 12.11 11/24/2017 17.30 0.00 0.00 0.125 17.43 0.216 0.125 0.012 0.000 0.499 0.259 2.90 0.00 4.13 9.29 3.24 4.14 10.05 17.43 0.012 9.92 11/25/2017 17.54 0.00 0.00 0.133 17.67 0.223 0.133 0.012 0.000 0.515 0.245 2.67 0.00 4.59 9.29 3.03 4.60 10.05 17.67 0.012 9.91 11/26/2017 19.53 0.00 0.00 0.121 19.65 0.564 0.121 0.030 0.000 1.304 0.245 1.67 0.00 5.13 10.59 2.35 5.16 12.14 19.65 0.030 12.02 11/27/2017 18.98 0.00 0.00 0.123 19.10 0.500 0.123 0.027 0.000 1.156 0.274 3.49 0.00 3.06 10.46 4.12 3.09 11.89 19.10 0.027 11.77 11/28/2017 20.31 0.00 0.00 0.198 20.51 0.678 0.198 0.037 0.000 1.569 0.268 2.31 0.00 4.87 10.59 3.18 4.90 12.42 20.51 0.037 12.23 11/29/2017 19.94 0.00 0.00 0.148 20.09 0.256 0.148 0.014 0.001 0.592 0.243 2.84 0.00 5.57 10.42 3.25 5.59 11.25 20.09 0.014 11.11 11/30/2017 19.86 0.00 0.00 0.128 19.98 1.071 0.128 0.058 0.000 2.477 0.188 2.88 0.00 2.79 10.39 4.08 2.85 13.06 19.98 0.058 12.93 12/1/2017 19.16 0.00 0.00 0.138 19.29 0.407 0.138 0.022 0.000 0.941 0.200 1.86 0.00 5.61 10.12 2.40 5.63 11.26 19.29 0.022 11.12 APPENDIX B – DAILY IBT AMOUNTS B-9 (1) (2) (3) (4) (5)=1+2 +3+4 (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16)=6+7+1 2+13 (17)=8+9+ 14 (18)=10+ 11+15 (19)=16+1 7+18 (20)=8+9 (21)=18- 2-3-4 Water Withdrawal/Purchase (mgd) Consumptive Use (mgd) Water Use Discharged as Wastewater (mgd) Total Returned/Used in Each Basin (mgd) Interbasin Transfer (mgd) Jordan Lake Withdrawal Neuse Basin Purchase Total System Use Haw Cape Fear Neuse Haw Cape Fear Neuse Haw Cape Fear Neuse Total for All Basins Haw to Cape Fear Haw to Neuse Haw Raleigh Durham Durham Co. Reclaimed Potable WRF Reuse Potable WRF Reuse Potable WRF Reuse WTP Process Water WRF WRF Total WRFs 12/2/2017 19.22 0.00 0.00 0.124 19.34 0.386 0.124 0.021 0.000 0.893 0.183 1.53 0.00 5.43 10.77 2.04 5.45 11.85 19.34 0.021 11.72 12/3/2017 17.41 0.00 0.00 0.127 17.54 0.239 0.127 0.013 0.000 0.552 0.186 1.46 0.00 4.79 10.17 1.83 4.80 10.91 17.54 0.013 10.78 12/4/2017 19.59 0.00 0.00 0.125 19.71 0.746 0.125 0.040 0.000 1.726 0.218 1.82 0.00 4.56 10.48 2.69 4.60 12.42 19.71 0.040 12.30 12/5/2017 17.28 0.00 0.00 0.200 17.48 0.238 0.200 0.013 0.000 0.551 0.178 1.44 0.00 4.42 10.44 1.88 4.44 11.16 17.48 0.013 10.96 12/6/2017 17.44 0.00 0.00 0.128 17.56 0.238 0.128 0.013 0.000 0.551 0.206 1.51 0.00 4.43 10.49 1.88 4.44 11.24 17.56 0.013 11.12 12/7/2017 20.36 0.00 0.00 0.125 20.49 0.861 0.125 0.046 0.000 1.992 0.164 1.56 0.00 4.76 10.98 2.54 4.81 13.14 20.49 0.047 13.01 12/8/2017 16.67 0.00 0.00 0.118 16.79 0.226 0.118 0.012 0.000 0.522 0.152 1.59 0.00 4.06 10.11 1.94 4.07 10.78 16.79 0.012 10.66 12/9/2017 16.61 0.00 0.00 0.105 16.71 0.221 0.105 0.012 0.000 0.510 0.171 1.86 0.00 3.96 9.87 2.18 3.98 10.55 16.71 0.012 10.45 12/10/2017 18.58 0.00 0.00 0.112 18.69 0.254 0.112 0.014 0.000 0.588 0.177 1.56 0.00 4.95 11.03 1.93 4.96 11.80 18.69 0.014 11.69 12/11/2017 23.76 0.00 0.00 0.119 23.87 0.736 0.119 0.040 0.000 1.703 0.163 5.15 0.00 4.84 11.12 6.01 4.88 12.98 23.87 0.040 12.86 12/12/2017 16.59 0.00 0.00 0.118 16.71 0.226 0.118 0.012 0.000 0.522 0.179 1.51 0.00 4.13 10.01 1.85 4.15 10.71 16.71 0.012 10.59 12/13/2017 17.40 0.00 0.00 0.120 17.52 0.233 0.120 0.013 0.000 0.538 0.202 1.86 0.00 4.24 10.31 2.21 4.26 11.05 17.52 0.013 10.93 12/14/2017 20.19 0.00 0.00 0.127 20.31 0.686 0.127 0.037 0.000 1.586 0.182 1.85 0.00 4.75 11.09 2.66 4.79 12.86 20.31 0.037 12.73 12/15/2017 18.91 0.00 0.00 0.123 19.03 0.657 0.123 0.035 0.000 1.520 0.216 1.63 0.00 4.66 10.19 2.41 4.70 11.93 19.03 0.035 11.80 12/16/2017 16.79 0.00 0.00 0.119 16.91 0.241 0.119 0.013 0.000 0.558 0.249 0.66 0.00 4.67 10.40 1.02 4.68 11.21 16.91 0.013 11.09 12/17/2017 18.52 0.00 0.00 0.125 18.65 0.239 0.125 0.013 0.000 0.552 0.183 2.58 0.00 4.71 10.24 2.94 4.73 10.97 18.65 0.013 10.85 12/18/2017 19.51 0.00 0.00 0.120 19.63 0.717 0.120 0.039 0.000 1.659 0.148 1.18 0.00 4.82 10.94 2.02 4.86 12.75 19.63 0.039 12.63 12/19/2017 17.56 0.00 0.00 0.129 17.69 0.243 0.129 0.013 0.001 0.563 0.170 1.31 0.00 4.77 10.49 1.68 4.79 11.22 17.69 0.014 11.09 12/20/2017 16.38 0.00 0.00 0.119 16.50 0.228 0.119 0.012 0.000 0.527 0.259 1.15 0.00 4.07 10.14 1.49 4.08 10.93 16.50 0.012 10.81 12/21/2017 20.34 0.00 0.00 0.123 20.46 0.784 0.123 0.042 0.000 1.815 0.187 1.11 0.00 4.94 11.46 2.02 4.99 13.46 20.46 0.042 13.34 12/22/2017 18.73 0.00 0.00 0.127 18.86 0.248 0.127 0.013 0.000 0.573 0.167 2.19 0.00 4.64 10.90 2.56 4.65 11.64 18.86 0.013 11.51 12/23/2017 16.57 0.00 0.00 0.120 16.69 0.232 0.120 0.013 0.000 0.537 0.155 1.05 0.00 4.50 10.09 1.40 4.51 10.78 16.69 0.013 10.66 12/24/2017 18.03 0.00 0.00 0.118 18.15 0.607 0.118 0.033 0.000 1.403 0.145 1.52 0.00 4.77 9.55 2.24 4.80 11.10 18.15 0.033 10.98 12/25/2017 16.20 0.00 0.00 0.110 16.31 0.225 0.110 0.012 0.000 0.521 0.153 1.13 0.00 4.45 9.71 1.47 4.46 10.38 16.31 0.012 10.27 12/26/2017 16.20 0.00 0.00 0.110 16.31 0.225 0.110 0.012 0.000 0.521 0.147 1.13 0.00 4.35 9.81 1.47 4.37 10.48 16.31 0.012 10.37 12/27/2017 16.87 0.00 0.00 0.112 16.98 0.225 0.112 0.012 0.000 0.519 0.150 1.86 0.00 4.15 9.96 2.20 4.16 10.62 16.98 0.012 10.51 12/28/2017 17.61 0.00 0.00 0.107 17.72 0.426 0.107 0.023 0.000 0.985 0.141 1.20 0.00 4.49 10.35 1.73 4.51 11.47 17.72 0.023 11.37 12/29/2017 17.37 0.00 0.00 0.115 17.49 0.268 0.115 0.014 0.000 0.619 0.168 0.81 0.00 4.59 10.90 1.19 4.60 11.69 17.49 0.014 11.58 12/30/2017 16.91 0.00 0.00 0.111 17.02 0.239 0.111 0.013 0.000 0.552 0.147 0.95 0.00 4.75 10.26 1.30 4.77 10.95 17.02 0.013 10.84 12/31/2017 17.94 0.00 0.00 0.109 18.05 0.239 0.109 0.013 0.000 0.554 0.153 1.93 0.00 4.71 10.34 2.28 4.72 11.05 18.05 0.013 10.94 APPENDIX B – DAILY IBT AMOUNTS B-10 C-1 Appendix C - Monthly Billed Water Use The monthly billed potable water use was exported from the billing databases of the Towns of Cary and Apex. The Town of Cary billed water use includes Morrisville and Wake County/RTP South. APPENDIX C Billed Water Use Apex and Cary (includes Morrisville, and Wake County/RTP South) Apex Billed Water Use (MGD) Cary Billed Water Use1 (MGD) Total Billed Water Use (MGD) Billed Month Haw Neuse Cape Fear Haw Neuse Haw Neuse Cape Fear Jan-2017 1.68 0.98 0.21 2.92 8.54 4.60 9.52 0.21 Feb-2017 1.70 0.97 0.26 2.96 9.15 4.66 10.12 0.26 Mar-2017 1.42 0.83 0.19 2.81 8.47 4.23 9.30 0.19 Apr-2017 1.61 0.94 0.21 3.13 9.43 4.74 10.37 0.21 May-2017 1.64 0.92 0.21 3.53 9.75 5.17 10.67 0.21 Jun-2017 2.00 1.05 0.22 4.09 11.00 6.09 12.05 0.22 Jul-2017 1.94 1.02 0.21 3.91 10.89 5.85 11.92 0.21 Aug-2017 2.50 1.18 0.27 4.62 12.43 7.12 13.61 0.27 Sep-2017 2.58 1.23 0.31 4.27 11.73 6.85 12.96 0.31 Oct-2017 2.20 1.04 0.25 4.18 11.72 6.38 12.76 0.25 Nov-2017 2.25 1.20 0.24 3.73 10.49 5.98 11.68 0.24 Dec-2017 1.73 0.90 0.22 2.95 8.58 4.68 9.49 0.22 Annual Average Day 1.93 1.02 0.23 3.59 10.16 5.52 11.18 0.23 1 Cary Billed Water Use includes Morrisville and Wake County/RTP South This page has been intentionally left blank. D-1 Appendix D - AWWA M36 Water Audit Summary The following screen shots summarize the Town of Cary water audit using the AWWA Free Water Audit Software v5.0. For fiscal year (FY) 2017, the non-revenue water is 10.2% by volume of the water supplied. Performance Indicator output from FY2017 AWWA Audit for the Town of Cary: Wat e r A u d i t R e p o r t f o r : To w n o f C a r y ( 0 3 - 9 2 - 0 2 0 ) Re p o r t i n g Y e a r : Sy s t e m A t t r i b u t e s : Ap p a r e n t L o s s e s : 28 . 3 8 8 MG / Y r + R e a l L o s s e s : 30 9 . 7 9 0 MG / Y r = W a t e r L o s s e s : 33 8 . 1 7 9 MG / Y r Un a v o i d a b l e A n n u a l R e a l L o s s e s ( U A R L ) : 57 8 . 3 0 MG / Y r An n u a l c o s t o f A p p a r e n t L o s s e s : $1 4 9 , 3 2 3 An n u a l c o s t o f R e a l L o s s e s : $3 6 7 , 8 9 8 Va l u e d a t Va r i a b l e P r o d u c t i o n C o s t Pe r f o r m a n c e I n d i c a t o r s : No n - r e v e n u e w a t e r a s p e r c e n t b y v o l u m e o f W a t e r S u p p l i e d : 10 . 2 % No n - r e v e n u e w a t e r a s p e r c e n t b y c o s t o f o p e r a t i n g s y s t e m : 2.7 % R e a l L o s s e s v a l u e d a t V a r i a b l e P r o d u c t i o n C o s t Ap p a r e n t L o s s e s p e r s e r v i c e c o n n e c t i o n p e r d a y : 1.1 3 ga l l o n s / c o n n e c t i o n / d a y Re a l L o s s e s p e r s e r v i c e c o n n e c t i o n p e r d a y : 12 . 3 3 ga l l o n s / c o n n e c t i o n / d a y Re a l L o s s e s p e r l e n g t h o f m a i n p e r d a y * : N/A Re a l L o s s e s p e r s e r v i c e c o n n e c t i o n p e r d a y p e r p s i p r e s s u r e : 0.1 2 ga l l o n s / c o n n e c t i o n / d a y / p s i Fr o m A b o v e , R e a l L o s s e s = C u r r e n t A n n u a l R e a l L o s s e s ( C A R L ) : 30 9 . 7 9 mil l i o n g a l l o n s / y e a r 0.5 4 * T h i s p e r f o r m a n c e i n d i c a t o r a p p l i e s f o r s y s t e m s w i t h a l o w s e r v i c e c o n n e c t i o n d e n s i t y o f l e s s t h a n 3 2 s e r v i c e c o n n e c t i o n s / m i l e o f p i p e l i n e A W W A F r e e W a t e r A u d i t S o f t w a r e : Sy s t e m A t t r i b u t e s a n d P e r f o r m a n c e I n d i c a t o r s ** * Y O U R W A T E R A U D I T D A T A V A L I D I T Y S C O R E I S : 7 7 o u t o f 1 0 0 * * * In f r a s t r u c t u r e L e a k a g e I n d e x ( I L I ) [ C A R L / U A R L ] : 20 1 7 7/2 0 1 6 - 6 / 2 0 1 7 Re t u r n t o R e p o r t i n g W o r k s h e e t t o c h a n g e t h i s a s s u m p i t o n ? ? Am e r i c a n W a t e r W o r k s A s s o c i a t i o n . Cop y r i g h t © 2 0 1 4 , All R i g h t s R e s e r v e d . WA S v 5 . 0 Fin a n c i a l : Op e r a t i o n a l Eff i c i e n c y : APPENDIX D – AWWA M36 WATER AUDIT SUMMARY D- 2 Water Balance Output from FY2017 AWWA Audit for the Town of Cary: Wa t e r A u d i t R e p o r t f o r : Re p o r t i n g Y e a r : 20 1 7 7/2 0 1 6 - 6 / 2 0 1 7 Da t a V a l i d i t y S c o r e : 77 Wa t e r E x p o r t e d Re v e n u e W a t e r 36 . 1 6 8 36 . 1 6 8 Bil l e d M e t e r e d C o n s u m p t i o n ( w a t e r ex p o r t e d i s r e m o v e d ) Re v e n u e W a t e r 4,9 7 6 . 7 3 6 Ow n S o u r c e s Au t h o r i z e d Co n s u m p t i o n 4, 9 7 6 . 7 3 6 Bil l e d U n m e t e r e d C o n s u m p t i o n 4,9 7 6 . 7 3 6 0.0 0 0 5, 2 0 1 . 2 9 4 Un b i l l e d M e t e r e d C o n s u m p t i o n 15 5 . 3 1 5 5,5 1 5 . 5 6 1 22 4 . 5 5 8 Un b i l l e d U n m e t e r e d C o n s u m p t i o n 69 . 2 4 3 Sy s t e m I n p u t Wa t e r S u p p l i e d Un a u t h o r i z e d C o n s u m p t i o n 56 2 . 7 3 7 5,5 7 5 . 6 4 1 Ap p a r e n t L o s s e s 0.0 0 5 5, 5 3 9 . 4 7 3 28 . 3 8 8 Cu s t o m e r M e t e r i n g I n a c c u r a c i e s 28 . 3 8 2 Sy s t e m a t i c D a t a H a n d l i n g E r r o r s Wa t e r L o s s e s 0.0 0 1 Wa t e r I m p o r t e d 33 8 . 1 7 9 Le a k a g e o n T r a n s m i s s i o n a n d / o r Dis t r i b u t i o n M a i n s Re a l L o s s e s No t b r o k e n d o w n 60 . 0 8 0 30 9 . 7 9 0 Le a k a g e a n d O v e r f l o w s a t U t i l i t y ' s S t o r a g e Ta n k s No t b r o k e n d o w n Le a k a g e o n S e r v i c e C o n n e c t i o n s No t b r o k e n d o w n AW W A F r e e W a t e r A u d i t S o f t w a r e : Wa t e r B a l a n c e No n - R e v e n u e W a t e r (N R W ) Bil l e d A u t h o r i z e d C o n s u m p t i o n Un b i l l e d A u t h o r i z e d C o n s u m p t i o n (A d j u s t e d f o r kn o w n e r r o r s ) Bil l e d W a t e r E x p o r t e d To w n o f C a r y ( 0 3 - 9 2 - 0 2 0 ) WA S v 5 . 0 Am e r i c a n W a t e r W o r k s A s s o c i a t i o n . Co p y r i g h t © 2 0 1 4 , All R i g h t s R e s e r v e d . E-1 Appendix E – Cape Fear River Basin Discharge (MGD) Date Discharge to Durham County WWTP WWWRF Discharge to Cape Fear River Basin 1-Jan-17 0.00 5.05 2-Jan-17 0.00 6.59 3-Jan-17 0.00 5.60 4-Jan-17 0.00 5.16 5-Jan-17 0.00 4.70 6-Jan-17 0.00 4.69 7-Jan-17 0.00 5.66 8-Jan-17 0.00 5.38 9-Jan-17 0.00 5.13 10-Jan-17 0.00 4.89 11-Jan-17 0.00 5.10 12-Jan-17 0.00 5.07 13-Jan-17 0.00 4.68 14-Jan-17 0.00 4.96 15-Jan-17 0.00 4.96 16-Jan-17 0.00 5.16 17-Jan-17 0.00 4.71 18-Jan-17 0.00 4.66 19-Jan-17 0.00 4.56 20-Jan-17 0.00 4.55 21-Jan-17 0.00 5.09 22-Jan-17 0.00 5.25 23-Jan-17 0.00 5.23 24-Jan-17 0.36 3.45 25-Jan-17 1.85 3.18 26-Jan-17 1.49 2.95 27-Jan-17 2.20 2.86 28-Jan-17 2.17 2.85 29-Jan-17 2.18 3.00 30-Jan-17 2.31 2.62 31-Jan-17 2.23 4.15 1-Feb-17 1.99 3.58 2-Feb-17 2.06 2.37 3-Feb-17 2.17 3.12 4-Feb-17 2.04 2.90 5-Feb-17 2.12 2.53 6-Feb-17 2.19 2.88 7-Feb-17 2.26 2.63 8-Feb-17 2.16 2.63 9-Feb-17 2.18 2.72 10-Feb-17 2.09 2.65 11-Feb-17 2.14 2.68 12-Feb-17 2.12 2.92 13-Feb-17 2.33 2.74 14-Feb-17 2.17 2.67 15-Feb-17 2.11 2.76 16-Feb-17 2.15 2.45 17-Feb-17 2.15 2.79 18-Feb-17 2.11 2.82 19-Feb-17 2.20 2.86 20-Feb-17 2.16 2.71 21-Feb-17 2.21 2.66 22-Feb-17 2.18 2.59 23-Feb-17 2.16 2.55 24-Feb-17 2.18 2.62 25-Feb-17 2.15 2.63 26-Feb-17 2.21 2.83 27-Feb-17 2.33 2.54 APPENDIX E – CAPE FEAR RIVER BASIN DISCHARGE E- 2 Date Discharge to Durham County WWTP WWWRF Discharge to Cape Fear River Basin 28-Feb-17 2.29 2.68 1-Mar-17 2.22 2.60 2-Mar-17 2.37 2.91 3-Mar-17 2.31 2.61 4-Mar-17 2.13 2.82 5-Mar-17 2.16 2.97 6-Mar-17 2.35 2.69 7-Mar-17 2.24 2.57 8-Mar-17 2.25 2.62 9-Mar-17 2.12 2.59 10-Mar-17 2.36 2.49 11-Mar-17 2.15 2.70 12-Mar-17 2.26 2.93 13-Mar-17 2.26 2.76 14-Mar-17 2.32 3.05 15-Mar-17 2.41 2.62 16-Mar-17 2.19 2.59 17-Mar-17 2.14 2.66 18-Mar-17 2.26 2.81 19-Mar-17 2.18 2.97 20-Mar-17 2.28 2.66 21-Mar-17 2.23 2.60 22-Mar-17 2.23 2.63 23-Mar-17 2.24 2.48 24-Mar-17 2.30 2.53 25-Mar-17 2.25 2.76 26-Mar-17 2.30 2.94 27-Mar-17 2.43 2.67 28-Mar-17 2.39 2.64 29-Mar-17 2.35 2.55 30-Mar-17 2.32 2.53 31-Mar-17 2.26 2.85 1-Apr-17 2.29 2.95 2-Apr-17 2.23 2.92 3-Apr-17 2.27 2.84 4-Apr-17 2.41 2.86 5-Apr-17 2.38 2.85 6-Apr-17 2.34 2.74 7-Apr-17 2.25 2.71 8-Apr-17 2.26 2.70 9-Apr-17 2.27 2.78 10-Apr-17 2.36 2.51 11-Apr-17 2.34 2.39 12-Apr-17 2.34 1.67 13-Apr-17 2.92 1.06 14-Apr-17 0.05 4.55 15-Apr-17 0.00 4.67 16-Apr-17 0.00 5.04 17-Apr-17 0.00 4.91 18-Apr-17 0.00 4.69 19-Apr-17 0.00 4.71 20-Apr-17 0.00 4.73 21-Apr-17 0.00 4.58 22-Apr-17 0.00 4.75 23-Apr-17 0.00 5.34 24-Apr-17 0.00 7.57 25-Apr-17 0.00 9.87 26-Apr-17 0.00 5.34 27-Apr-17 0.00 5.61 28-Apr-17 0.00 5.67 29-Apr-17 0.00 5.71 30-Apr-17 0.00 5.59 APPENDIX E – CAPE FEAR RIVER BASIN DISCHARGE E-3 Date Discharge to Durham County WWTP WWWRF Discharge to Cape Fear River Basin 1-May-17 0.00 5.26 2-May-17 0.00 5.13 3-May-17 0.00 5.08 4-May-17 0.00 5.02 5-May-17 0.00 6.15 6-May-17 0.00 5.44 7-May-17 0.00 5.54 8-May-17 0.00 5.24 9-May-17 0.00 5.15 10-May-17 0.00 5.13 11-May-17 0.00 4.88 12-May-17 0.00 4.80 13-May-17 0.00 5.05 14-May-17 0.00 5.25 15-May-17 0.00 5.18 16-May-17 0.00 5.34 17-May-17 0.00 5.63 18-May-17 0.00 5.04 19-May-17 0.00 4.93 20-May-17 0.00 5.02 21-May-17 0.00 5.26 22-May-17 0.00 5.03 23-May-17 0.00 5.55 24-May-17 0.00 5.40 25-May-17 0.00 5.61 26-May-17 0.00 5.19 27-May-17 0.00 5.21 28-May-17 0.00 4.98 29-May-17 0.00 5.50 30-May-17 0.00 5.21 31-May-17 0.00 5.03 1-Jun-17 0.00 5.01 2-Jun-17 0.00 4.84 3-Jun-17 0.00 5.03 4-Jun-17 0.00 5.32 5-Jun-17 0.00 5.47 6-Jun-17 0.00 5.25 7-Jun-17 0.00 5.01 8-Jun-17 0.00 4.99 9-Jun-17 0.00 4.93 10-Jun-17 0.00 5.00 11-Jun-17 0.00 5.13 12-Jun-17 0.00 4.88 13-Jun-17 0.00 4.77 14-Jun-17 0.00 4.81 15-Jun-17 0.00 4.79 16-Jun-17 0.00 5.12 17-Jun-17 0.00 5.78 18-Jun-17 0.00 5.41 19-Jun-17 0.00 5.13 20-Jun-17 0.00 5.50 21-Jun-17 0.00 5.50 22-Jun-17 0.00 5.05 23-Jun-17 0.00 3.09 24-Jun-17 0.00 7.39 25-Jun-17 0.00 5.67 26-Jun-17 0.00 5.10 27-Jun-17 0.00 4.94 28-Jun-17 0.00 4.89 29-Jun-17 0.00 4.81 30-Jun-17 0.00 4.81 APPENDIX E – CAPE FEAR RIVER BASIN DISCHARGE E- 4 Date Discharge to Durham County WWTP WWWRF Discharge to Cape Fear River Basin 1-Jul-17 0.00 4.73 2-Jul-17 0.00 4.60 3-Jul-17 0.00 4.44 4-Jul-17 0.00 4.58 5-Jul-17 0.00 4.82 6-Jul-17 0.00 4.82 7-Jul-17 0.00 4.68 8-Jul-17 0.00 4.81 9-Jul-17 0.00 4.90 10-Jul-17 0.00 4.73 11-Jul-17 0.00 4.73 12-Jul-17 0.00 4.72 13-Jul-17 0.00 4.67 14-Jul-17 0.00 4.59 15-Jul-17 0.00 4.74 16-Jul-17 0.00 4.91 17-Jul-17 0.00 4.78 18-Jul-17 0.00 4.71 19-Jul-17 0.00 4.72 20-Jul-17 0.00 4.67 21-Jul-17 0.00 4.62 22-Jul-17 0.00 4.76 23-Jul-17 0.00 5.29 24-Jul-17 0.00 4.88 25-Jul-17 0.00 4.76 26-Jul-17 0.00 4.62 27-Jul-17 0.00 4.67 28-Jul-17 0.00 4.59 29-Jul-17 0.00 4.71 30-Jul-17 0.00 4.77 31-Jul-17 0.00 4.63 1-Aug-17 0.00 4.57 2-Aug-17 0.00 4.60 3-Aug-17 0.00 4.61 4-Aug-17 0.00 4.50 5-Aug-17 0.00 4.63 6-Aug-17 0.00 4.81 7-Aug-17 0.00 4.75 8-Aug-17 0.00 4.85 9-Aug-17 0.00 4.73 10-Aug-17 0.00 4.70 11-Aug-17 0.00 4.68 12-Aug-17 0.00 5.05 13-Aug-17 0.00 5.04 14-Aug-17 0.00 4.83 15-Aug-17 0.00 5.00 16-Aug-17 0.00 4.87 17-Aug-17 0.00 4.76 18-Aug-17 0.00 4.68 19-Aug-17 0.00 4.72 20-Aug-17 0.00 4.77 21-Aug-17 0.00 4.51 22-Aug-17 0.00 4.64 23-Aug-17 0.00 4.68 24-Aug-17 0.00 4.69 25-Aug-17 0.00 4.58 26-Aug-17 0.00 4.75 27-Aug-17 0.00 5.07 28-Aug-17 0.00 4.62 29-Aug-17 0.00 4.68 30-Aug-17 0.00 4.74 31-Aug-17 0.00 4.69 APPENDIX E – CAPE FEAR RIVER BASIN DISCHARGE E-5 Date Discharge to Durham County WWTP WWWRF Discharge to Cape Fear River Basin 1-Sep-17 0.00 5.06 2-Sep-17 0.00 4.80 3-Sep-17 0.00 4.54 4-Sep-17 0.00 5.07 5-Sep-17 0.00 5.01 6-Sep-17 0.00 5.04 7-Sep-17 0.00 4.64 8-Sep-17 0.00 4.45 9-Sep-17 0.00 4.77 10-Sep-17 0.00 5.10 11-Sep-17 0.00 5.20 12-Sep-17 0.00 5.32 13-Sep-17 0.00 4.88 14-Sep-17 0.00 4.82 15-Sep-17 0.00 4.60 16-Sep-17 0.00 4.82 17-Sep-17 0.00 5.15 18-Sep-17 0.00 4.75 19-Sep-17 0.00 4.67 20-Sep-17 0.00 4.60 21-Sep-17 0.00 4.68 22-Sep-17 0.00 4.51 23-Sep-17 0.00 4.71 24-Sep-17 0.00 4.99 25-Sep-17 0.00 4.99 26-Sep-17 0.00 4.71 27-Sep-17 0.00 4.63 28-Sep-17 0.00 4.67 29-Sep-17 0.00 4.39 30-Sep-17 0.00 4.73 1-Oct-17 0.00 4.99 2-Oct-17 0.00 4.62 3-Oct-17 0.00 4.56 4-Oct-17 0.00 4.58 5-Oct-17 0.00 4.62 6-Oct-17 0.00 4.52 7-Oct-17 0.00 4.74 8-Oct-17 0.00 5.04 9-Oct-17 0.00 4.72 10-Oct-17 0.00 4.59 11-Oct-17 0.00 4.70 12-Oct-17 0.00 4.61 13-Oct-17 0.00 4.88 14-Oct-17 0.00 5.06 15-Oct-17 0.00 5.11 16-Oct-17 0.00 4.86 17-Oct-17 0.00 4.64 18-Oct-17 0.00 4.68 19-Oct-17 0.00 4.73 20-Oct-17 0.00 4.55 21-Oct-17 0.00 4.71 22-Oct-17 0.00 5.06 23-Oct-17 0.00 4.97 24-Oct-17 0.00 4.94 25-Oct-17 0.00 4.68 26-Oct-17 0.00 4.68 27-Oct-17 0.00 4.46 28-Oct-17 0.00 4.81 29-Oct-17 0.00 5.55 30-Oct-17 0.00 4.83 31-Oct-17 0.00 4.74 APPENDIX E – CAPE FEAR RIVER BASIN DISCHARGE E- 6 Date Discharge to Durham County WWTP WWWRF Discharge to Cape Fear River Basin 1-Nov-17 0.00 4.75 2-Nov-17 0.00 4.69 3-Nov-17 0.00 4.57 4-Nov-17 0.00 4.81 5-Nov-17 0.00 5.12 6-Nov-17 0.00 4.86 7-Nov-17 0.00 4.65 8-Nov-17 0.00 4.68 9-Nov-17 0.00 4.83 10-Nov-17 0.00 4.65 11-Nov-17 0.00 4.70 12-Nov-17 0.00 5.05 13-Nov-17 0.00 5.38 14-Nov-17 0.00 4.78 15-Nov-17 0.00 4.75 16-Nov-17 0.00 4.72 17-Nov-17 0.00 4.67 18-Nov-17 0.00 4.91 19-Nov-17 0.00 5.11 20-Nov-17 0.00 4.88 21-Nov-17 0.00 4.69 22-Nov-17 0.00 4.93 23-Nov-17 0.00 4.69 24-Nov-17 0.00 4.32 25-Nov-17 0.00 5.00 26-Nov-17 0.00 5.17 27-Nov-17 0.00 3.09 28-Nov-17 0.00 4.93 29-Nov-17 0.00 5.73 30-Nov-17 0.00 2.82 1-Dec-17 0.00 5.66 2-Dec-17 0.00 5.47 3-Dec-17 0.00 5.08 4-Dec-17 0.00 4.60 5-Dec-17 0.00 4.58 6-Dec-17 0.00 4.83 7-Dec-17 0.00 4.80 8-Dec-17 0.00 5.29 9-Dec-17 0.00 5.84 10-Dec-17 0.00 5.37 11-Dec-17 0.00 4.88 12-Dec-17 0.00 4.74 13-Dec-17 0.00 4.71 14-Dec-17 0.00 4.79 15-Dec-17 0.00 4.70 16-Dec-17 0.00 4.92 17-Dec-17 0.00 5.15 18-Dec-17 0.00 4.86 19-Dec-17 0.00 5.08 20-Dec-17 0.00 5.15 21-Dec-17 0.00 4.98 22-Dec-17 0.00 4.90 23-Dec-17 0.00 4.88 24-Dec-17 0.00 4.81 25-Dec-17 0.00 4.53 26-Dec-17 0.00 4.57 27-Dec-17 0.00 4.51 28-Dec-17 0.00 4.52 29-Dec-17 0.00 4.62 30-Dec-17 0.00 4.87 31-Dec-17 0.00 4.95