{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Enable Macros","Instructions","Based on N","Based on Q"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Enable Macros","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"In order for this Workbook to function properly you must enable macros.  If you can see this message then macros are not enabled.  Please close the Workbook and then reopen it and chose to allow or enable macros."]
[]
[null,"   "]

{"sheet":"Instructions","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"   "]
[null,null,"Waterworks Manual Compliance Check Worksheets"]
[]
[null,null,"The worksheets are not a substitute for an engineering analysis but instead use the values from an engineering analysis in order to determine compliance.","   "]
[]
[null,null,"The first step in determining compliance is the estimate the Maximum Day Average Demand for the system.  This can be done in one of two ways and will determine which spreadsheet to use.  Users should select one of the two methods and corresponding spreadsheet below:"]
[]
[null,null,"1.  Maximum Day Demand is calculated by first estimating the number of service connections (N) based on the land use analysis in the Waterworks Manual.  Once N is determined then the Maximum Day Average Demand and required storage are calculated using formulas in the manual.  If this method is selected then the first tab \"Based on N\" is used."]
[]
[null,null,"2.  Maximum Day Demand is calculated by a licensed civil engineer using common engineering practice and reported in a report provided and stamped by the engineer.  The values for the number of service connections (N) and storage, if not provided in the engineer's report are then calculated using formulas in the manual.  If this method is selected then the second tab \"Based on Q\" is used."]

{"sheet":"Based on N","index":2,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[[16,1,16,4],[18,1,18,5],[24,1,24,5],[28,1,28,5],[34,1,34,5],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[25,1,25,2],[26,1,26,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[15,1,15,4],[0,2,0,7],[1,2,1,7],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[2,1,2,6],[3,1,3,5],[14,1,14,4],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[41,1,41,5],[46,1,46,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[48,1,48,5],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[64,1,64,7],[65,1,65,7],[66,1,66,7],[67,1,67,7],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[68,1,68,7],[69,1,69,7],[70,1,70,7],[71,1,71,7],[72,1,72,7],[73,1,73,7],[74,1,74,7],[75,1,75,7],[76,1,76,7],[77,1,77,7],[82,1,82,7],[89,1,89,7],[78,1,78,7],[79,1,79,7],[80,1,80,7]]}
[null,"Water Purveyor:"]
[null,"System or Zone:"]
[]
[null,"1.  Determine Number of Service Connections (N)"]
[null,"Category",null,"Qty","Value","Total","Section","Comments"]
[null,"a. Number of single residential homes or lots =",null,null,1]
[null,"b. Number of 2nd residential units ≤ 1,800 sf =",null,null,0.5]
[null,"c. Number of 2nd residential units > 1,800 sf =",null,null,1]
[null,"d. Number of mobile home spaces < 3,000 sf =",null,null,0.5]
[null,"e. Number of mobile home spaces ≥ 3,000 sf =",null,null,1]
[null,"f.  Number of multifamily housing units =",null,null,0.5]
[null,"g. Number of trailer or trailer park spaces ="]
[null,"h. Number of commercial and industrial acres =",null,null,5]
[null,"i.  Number of agricultural acres =",null,null,2]
[null,"Maximum Service Connections (N) ="]
[null,"Actual Service Connections Issued ="]
[null,"Connections Available ="]
[]
[null,"2.  Determine Maximum Day Demand (Q0) and Storage (V0) from N",null,null,null,null,"Section","Comments"]
[null,"a.  Temerature in °F =",null,null,"degrees"]
[null,"b.  The System is metered.",null,false]
[null,"b.  Maximum Day Average Demand (Q0) =",null,null,"GPM"]
[null,"c.  Required Storage Volume (V0) =",null,null,"Gal"]
[]
[null,"3.  Determine Minimum Required Fire Flow (F) and Duration (DF)",null,null,null,null,"Section","Comments"]
[null,"a.  Minimum Fire Flow (F) =",null,null,"GPM"]
[null,"b.  Minimum Fire Flow Duration (DF) =",null,null,"Hours"]
[]
[null,"4.  Determine Required Minimum Total Storage (VM)",null,null,null,null,"Section","Comments"]
[null,"a.  Domestic Storage Required (V0) =",null,null,"Gal"]
[null,"b.  Fire Storage Required (VF) = 60 * F * DF =",null,null,"Gal"]
[null,"c.  Total Storage Required (VM) = Vo + VF =",null,null,"Gal"]
[null,"d.  Actual Storage Available (V1) =",null,null,"Gal"]
[]
[null,"5.  Determine Minimum Required Total Supply (QM)",null,null,null,null,"Section","Comments"]
[null,"a.  Actual Supply Available in the System (Q1) =",null,null,"GPD"]
[null,"b.  Storage Factor (S) ="]
[null,"c.  Domestic Supply Required (QD) = 1440 * S * Q0 =",null,null,"GPD"]
[null,"d.  Fire Supply Required (QF) =",null,null,"GPD"]
[null,"e.  Total Supply Required (QM) = QD + QF =",null,null,"GPD"]
[]
[null,"6.  Determine Minimum Required Peak Hour Demand (PHDM)",null,null,null,null,"Section","Comments"]
[null,"a.  Peak Hour Demand Multiplier (M) ="]
[null,"b.  PA = (M * Q0 / 2 ) + F =",null,null,"GPM"]
[null,"c.  PB = M * Q0 =",null,null,"GPM"]
[null,"d.  PHDM = greater of PA and PB =",null,null,"GPM"]
[null,"e.  Actual Peak Flow Rate (PHD1) =",null,null,"GPM"]
[]
[null,"7.  Determine Emergency Requirements (PE, VE1 and VE2)",null,null,null,null,"Section","Comments"]
[null,"a.  PED = M * Q0 / 2 ="]
[null,"b.  PEF = (M * Q0 / 4) + 0.75 * F =",null,null,"GPM"]
[null,"c.  PE = the greater of PED and PEF =",null,null,"GPM"]
[null,"d.  VE1 = 60 * PE =",null,null,"Gal"]
[null,"e.  VE2 = V0 + 0.75 * 60 * F =",null,null,"Gal"]
[null,"f.  Power Interuption of 1 Hour"]
[null,"     Peak Hour Demand (must be ≥ PE) =",null,null,"GPM"]
[null,"     Volume (must be ≥ VE1) =",null,null,"Gal"]
[null,"g.  Pump Out of Service"]
[null,"     Peak Hour Demand (must be ≥ PE) =",null,null,"GPM"]
[null,"     Volume (must be ≥ VE2) =",null,null,"Gal"]
[null,"h.  Source Interruption"]
[null,"     Peak Hour Demand (must be ≥ PE) ="]
[null,"     Volume (must be ≥ VE2) ="]
[]
[null,"8.  Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Water Purveyor"]
[]
[null,"Prepared By:  ",null,"Title:",null,null,"Date:"]
[]
[null,"Approve By:  ",null,"Title:",null,null,"Date:"]
[]
[]
[null,"County Use Only"]
[]
[null,"Accepted By:  ",null,null,null,null,"Date:"]

{"sheet":"Based on Q","index":3,"n_rows":78,"n_cols":8,"rows_kept":78,"cut":false,"hidden":false,"merged":[[10,1,10,5],[14,1,14,5],[20,1,20,5],[27,1,27,5],[11,1,11,2],[12,1,12,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[2,1,2,6],[4,1,4,2],[5,1,5,2],[0,2,0,7],[1,2,1,7],[3,1,3,5],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[34,1,34,5],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[50,1,50,7],[51,1,51,7],[52,1,52,7],[53,1,53,7],[54,1,54,7],[55,1,55,7],[56,1,56,7],[57,1,57,7],[58,1,58,7],[59,1,59,7],[65,1,65,7],[66,1,66,7],[68,1,68,7],[75,1,75,7],[60,1,60,7],[61,1,61,7],[62,1,62,7],[63,1,63,7],[64,1,64,7]]}
[null,"Water Purveyor:"]
[null,"System or Zone:"]
[]
[null,"1.  Maximum Day Demand (Q0) from Analysis, Storage (V0) and N",null,null,null,null,"Section","Comments"]
[null,"a.  Temerature in °F =",null,null,"degrees"]
[null,"b.  The System is metered.",null,true]
[null,"c.  Maximum Day Average Demand (Q0) =",null,null,"GPM"]
[null,"d.  Maximum Number of Service Connections (N) =",null,null,null,"Calculated N ="]
[null,"e.  Required Storage Volume (V0) in gallons =",null,null,null,"Calculated V0 ="]
[]
[null,"2.  Determine Minimum Required Fire Flow (F) and Duration (DF)",null,null,null,null,"Section","Comments"]
[null,"a.  Minimum Fire Flow (F) =",null,null,"GPM"]
[null,"b.  Minimum Fire Flow Duration (DF) =",null,null,"Hours"]
[]
[null,"3.  Determine Required Minimum Total Storage (VM)",null,null,null,null,"Section","Comments"]
[null,"a.  Domestic Storage Required (V0) =",null,null,"Gal"]
[null,"b.  Fire Storage Required (VF) = 60 * F * DF =",null,null,"Gal"]
[null,"c.  Total Storage Required (VM) = Vo + VF =",null,null,"Gal"]
[null,"d.  Actual Storage Available (V1) =",null,null,"Gal"]
[]
[null,"4.  Determine Minimum Required Total Supply (QM)",null,null,null,null,"Section","Comments"]
[null,"a.  Actual Supply Available in the System (Q1) =",null,null,"GPD"]
[null,"b.  Storage Factor (S) ="]
[null,"c.  Domestic Supply Required (QD) = 1440 * S * Q0 =",null,null,"GPD"]
[null,"d.  Fire Supply Required (QF) =",null,null,"GPD"]
[null,"e.  Total Supply Required (QM) = QD + QF =",null,null,"GPD"]
[]
[null,"5.  Determine Minimum Required Peak Hour Demand (PHDM)",null,null,null,null,"Section","Comments"]
[null,"a.  Peak Hour Demand Multiplier (M) ="]
[null,"b.  PA = (M * Q0 / 2 ) + F =",null,null,"GPM"]
[null,"c.  PB = M * Q0 =",null,null,"GPM"]
[null,"d.  PHDM = greater of PA and PB =",null,null,"GPM"]
[null,"e.  Actual Peak Flow Rate (PHD1) =",null,null,"GPM"]
[]
[null,"6.  Determine Emergency Requirements (PE, VE1 and VE2)",null,null,null,null,"Section","Comments"]
[null,"a.  PED = M * Q0 / 2 ="]
[null,"b.  PEF = (M * Q0 / 4) + 0.75 * F =",null,null,"GPM"]
[null,"c.  PE = the greater of PED and PEF =",null,null,"GPM"]
[null,"d.  VE1 = 60 * PE =",null,null,"Gal"]
[null,"e.  VE2 = V0 + 0.75 * 60 * F =",null,null,"Gal"]
[null,"f.  Power Interuption of 1 Hour"]
[null,"     Peak Hour Demand (must be ≥ PE) =",null,null,"GPM"]
[null,"     Volume (must be ≥ VE1) =",null,null,"Gal"]
[null,"g.  Pump Out of Service"]
[null,"     Peak Hour Demand (must be ≥ PE) =",null,null,"GPM"]
[null,"     Volume (must be ≥ VE2) =",null,null,"Gal"]
[null,"h.  Source Interruption"]
[null,"     Peak Hour Demand (must be ≥ PE) ="]
[null,"     Volume (must be ≥ VE2) ="]
[]
[null,"7.  Comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Water Purveyor Approval"]
[]
[null,"Prepared By:  ",null,"Title:",null,null,"Date:"]
[]
[null,"Approve By:  ",null,"Title:",null,null,"Date:"]
[]
[]
[null,"County Use Only"]
[]
[null,"Accepted By:  ",null,null,null,null,"Date:"]