{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Capacity Calculations","Summary Table","void Proposed","Bishop North Proposed"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Instructions","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Instructions to User\nThis spreadsheet is provided by BWU in an attempt to standardize and streamline the calculation and review of sewer capacity studies within BWU's service area. It is intended to be used with BWU's sewer study guidelines and supplemental references.\nCalculations are organized by blocks, with one block required per line segment. The intent is to begin at the top of the page with the most upstream segment in the study and continue downstream with a new calculation block for each line segment.\nAdditional blocks can be added as needed by clicking the button to the right.\nCells with red text require user input. The rest of the spreadsheet, including the summary table, will auto-calculate as information is filled in. \nFor each segment, the user will input the following information:\n- Development information: One line per parcel/development. Provide the development name and type, unit count and description and daily flow per unit. Additional rows can be added as needed by clicking the button to the right.\n   Only the direct inflows to the current segment need to be added. The spreadsheet will automatically carry over the flow from the connecting upstream main.\n- Pipe information: Input the upstream and downstream manhole ID's from the city's GIS. Input upstream and downstream inverts. Input pipe length and size. There are various sources for this informatin including GIS, As-builts, Survey, etc.\n   Any information used must be verified by the EOR performing the calculations.\n"]

{"sheet":"Capacity Calculations","index":1,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"MH \"&B5&\" to MH \"&B7","v":"MH x to MH y"},"Development Type","Unit Count","Unit Description","GPD/unit","Total GPD","Eq. Population","Avg. Flow (gpm)","Peaking Factor","Peak Flow (gpm)"]
["Development Name","Type",1,"Unit",0,{"$f":"C2*E2","v":0},{"$f":"F2/100","v":0},{"$f":"F2/1440","v":0}]
["Carry over from upstream",null,null,null,null,{"$f":"IFERROR(INDEX($F$1:F2,MAX(_xlfn._xlws.FILTER(ROW($F$1:F2),$A$1:A2=\"Subtotal\"))),\"\")","v":""}]
["Subtotal",null,null,null,null,{"$f":"SUM(F2:F3)","v":0},{"$f":"F4/100","v":0},{"$f":"F4/1440","v":0},{"$f":"(18+SQRT(G4/1000))/(4+SQRT(G4/1000))","v":4.5},{"$f":"I4*H4","v":0}]
["Upstream Manhole ID","x","Pipe Slope (S)",{"$f":"(B6-B8)/B9","v":0.1},"ft/ft"]
["Upstream Invert (ft)",0.1,"Pipe Radius ",{"$f":"B10/12/2","v":4.1666666666666664E-2},"ft"]
["Downstream Manhole ID","y","Full Area (Afull = π*r²)",{"$f":"PI()*(D6^2)","v":5.4541539124822796E-3},"ft^2"]
["Downstream Invert (ft)",0,"Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*D6","v":0.26179938779914941},"ft"]
["Pipe Length (ft)",1,"Hydraulic Radius (R = A/P)",{"$f":"D7/D8","v":2.0833333333333336E-2},"ft"]
["Pipe Size (in)",1,"Entity ID",{"$f":"B5&\"_\"&B7","v":"x_y"}]
[null,null,"Pipe Capacity",{"$f":" (1.49/0.013)*D7*(D9^(2/3))*(D5^(1/2))*448.83","v":6.7177632074375344},"GAL/MIN"]
[null,null,"Model Flow",{"$f":"IF(J4=0,\"\",J4)","v":""},"GAL/MIN"]
[null,null,"Capacity Utilized",{"$f":"IF(OR(D11=0, D12=0, D11=\"\", D12=\"\"), \"\", D12/D11)","v":""}]
[null,null,null,"Project Name Sewer Study"]
[null,null,null,"Manhhole XXX-XXXX to XXX-XXXX"]
[null,null,null,"City Project # LSD/PP XX-XXXX"]
[null,null,null,"Revision # X - DATE"]
[]
[{"$f":"\"MH \"&B24&\" to MH \"&B26","v":"MH xx-xxxx to MH yy-yyyy"},"Development Type","Unit Count","Unit Description","GPD/unit","Total GPD","Eq. Population","Avg. Flow (gpm)","Peaking Factor","Peak Flow (gpm)"]
["Sample Development #1","Single Family Residence",1,"Dwelling Unit",264,{"$f":"C20*E20","v":264},{"$f":"F20/100","v":2.64},{"$f":"F20/1440","v":0.18333333333333332}]
["Sample Development #2","Office Building - Employee",20,"Employees",15,{"$f":"C21*E21","v":300},{"$f":"F21/100","v":3},{"$f":"F21/1440","v":0.20833333333333334}]
["Carry over from upstream",null,null,null,null,{"$f":"INDEX($F$1:F21,MAX(_xlfn._xlws.FILTER(ROW($F$1:F21),$A$1:A21=\"Subtotal\")))","v":0}]
["Subtotal",null,null,null,null,{"$f":"SUM(F20:F22)","v":564},{"$f":"F23/100","v":5.64},{"$f":"F23/1440","v":0.39166666666666666},{"$f":"(18+SQRT(G23/1000))/(4+SQRT(G23/1000))","v":4.4354985715021389},{"$f":"I23*H23","v":1.7372369405050043}]
["Upstream Manhole ID","xx-xxxx","Pipe Slope (S)",{"$f":"(B25-B27)/B28","v":0.01},"ft/ft"]
["Upstream Invert (ft)",4,"Pipe Radius ",{"$f":"B29/12/2","v":0.33333333333333331},"ft"]
["Downstream Manhole ID","yy-yyyy","Full Area (Afull = π*r²)",{"$f":"PI()*(D25^2)","v":0.3490658503988659},"ft^2"]
["Downstream Invert (ft)",3,"Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*D25","v":2.0943951023931953},"ft"]
["Pipe Length (ft)",100,"Hydraulic Radius (R = A/P)",{"$f":"D26/D27","v":0.16666666666666669},"ft"]
["Pipe Size (in)",8,"Entity ID",{"$f":"B24&\"_\"&B26","v":"xx-xxxx_yy-yyyy"}]
[null,null,"Pipe Capacity",{"$f":" (1.49/0.013)*D26*(D28^(2/3))*(D24^(1/2))*448.83","v":543.83187243982832},"GAL/MIN"]
[null,null,"Model Flow",{"$f":"IF(J23=0,\"\",J23)","v":1.7372369405050043},"GAL/MIN"]
[null,null,"Capacity Utilized",{"$f":"IF(OR(D30=0, D31=0, D30=\"\", D31=\"\"), \"\", D31/D30)","v":3.1944375248017833E-3}]
[]
[{"$f":"\"MH \"&B39&\" to MH \"&B41","v":"MH yy-yyyy to MH zz-zzzz"},"Development Type","Unit Count","Unit Description","GPD/unit","Total GPD","Eq. Population","Avg. Flow (gpm)","Peaking Factor","Peak Flow (gpm)"]
["Sample Development #3","Multifamily",10,"Dwelling Units",264,{"$f":"C35*E35","v":2640},{"$f":"F35/100","v":26.4},{"$f":"F35/1440","v":1.8333333333333333}]
["Sample Development #4","Restaurant",20,"Seats",40,{"$f":"C36*E36","v":800},{"$f":"F36/100","v":8},{"$f":"F36/1440","v":0.55555555555555558}]
["Carry over from upstream",null,null,null,null,{"$f":"INDEX($F$1:F36,MAX(_xlfn._xlws.FILTER(ROW($F$1:F36),$A$1:A36=\"Subtotal\")))","v":564}]
["Subtotal",null,null,null,null,{"$f":"SUM(F35:F37)","v":4004},{"$f":"F38/100","v":40.04},{"$f":"F38/1440","v":2.7805555555555554},{"$f":"(18+SQRT(G38/1000))/(4+SQRT(G38/1000))","v":4.3332539899739793},{"$f":"I38*H38","v":12.048853455455426}]
["Upstream Manhole ID","yy-yyyy","Pipe Slope (S)",{"$f":"(B40-B42)/B43","v":0.01},"ft/ft"]
["Upstream Invert (ft)",2,"Pipe Radius ",{"$f":"B44/12/2","v":0.33333333333333331},"ft"]
["Downstream Manhole ID","zz-zzzz","Full Area (Afull = π*r²)",{"$f":"PI()*(D40^2)","v":0.3490658503988659},"ft^2"]
["Downstream Invert (ft)",1,"Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*D40","v":2.0943951023931953},"ft"]
["Pipe Length (ft)",100,"Hydraulic Radius (R = A/P)",{"$f":"D41/D42","v":0.16666666666666669},"ft"]
["Pipe Size (in)",8,"Entity ID",{"$f":"B39&\"_\"&B41","v":"yy-yyyy_zz-zzzz"}]
[null,null,"Pipe Capacity",{"$f":" (1.49/0.013)*D41*(D43^(2/3))*(D39^(1/2))*448.83","v":543.83187243982832},"GAL/MIN"]
[null,null,"Model Flow",{"$f":"IF(J38=0,\"\",J38)","v":12.048853455455426},"GAL/MIN"]
[null,null,"Capacity Utilized",{"$f":"IF(OR(D45=0, D46=0, D45=\"\", D46=\"\"), \"\", D46/D45)","v":2.2155475002595692E-2}]

{"sheet":"Summary Table","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Entity ID\n(USMH_DSMH)","Pipe Size\n(inches)","Slope\n(decimal)","Capacity\n(gpm)","Proposed Peak Flow\n(gpm)","Capacity Utilized\n(%)"]
[{"$f":"_xlfn._xlws.FILTER('Capacity Calculations'!D14:D1048576,'Capacity Calculations'!C14:C1048576=\"Entity ID\")","v":"xx-xxxx_yy-yyyy"},{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A2,'Capacity Calculations'!$D:$D,0)),\"\")","v":8},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A2,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":0.01},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A2,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":543.83187243982832},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A2,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":1.7372369405050043},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A2,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":3.1944375248017833E-3}]
["yy-yyyy_zz-zzzz",{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A3,'Capacity Calculations'!$D:$D,0)),\"\")","v":8},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A3,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":0.01},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A3,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":543.83187243982832},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A3,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":12.048853455455426},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A3,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":2.2155475002595692E-2}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A4,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A4,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A4,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A4,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A4,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A5,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A5,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A5,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A5,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A5,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A6,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A6,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A6,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A6,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A6,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A7,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A7,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A7,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A7,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A7,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A8,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A8,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A8,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A8,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A8,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A9,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A9,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A9,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A9,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A9,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A10,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A10,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A10,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A10,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A10,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A11,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A11,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A11,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A11,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A11,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A12,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A12,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A12,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A12,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A12,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A13,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A13,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A13,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A13,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A13,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A14,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A14,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A14,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A14,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A14,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A15,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A15,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A15,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A15,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A15,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX('Capacity Calculations'!$B:$B,MATCH('Summary Table'!$A16,'Capacity Calculations'!$D:$D,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A16,'Capacity Calculations'!$D:$D,0)-5),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A16,'Capacity Calculations'!$D:$D,0)+1),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A16,'Capacity Calculations'!$D:$D,0)+2),\"\")","v":""},{"$f":"IFERROR(INDEX('Capacity Calculations'!$D:$D,MATCH('Summary Table'!$A16,'Capacity Calculations'!$D:$D,0)+3),\"\")","v":""}]

{"sheet":"void Proposed","index":3,"n_rows":321,"n_cols":18,"rows_kept":321,"cut":false,"hidden":true,"merged":[[27,14,27,17],[94,0,94,4],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[17,0,17,4],[30,0,30,4],[41,0,41,4],[60,0,60,4],[71,0,71,4],[83,0,83,4],[251,0,251,4],[106,0,106,4],[120,0,120,4],[135,0,135,4],[150,0,150,4],[165,0,165,4],[183,0,183,4],[194,0,194,4],[205,0,205,4],[216,0,216,4],[227,0,227,4],[238,0,238,4],[262,0,262,4],[273,0,273,4],[292,0,292,4],[303,0,303,4],[313,0,313,4]]}
["McAuley Place Sewer Study"]
["Manhhole 484-6536 to 484-1303 - Existing Flows"]
["Crafton Tull Job # 20112100"]
[{"$f":"TODAY()","v":"2025-12-04"}]
["MH 484-6536 to 484-6537","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Mercy Clinic Pediatric","Hospital - Employees",25,{"$f":"VLOOKUP(B6,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B6,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C6*E6*D6","v":{"$error":"#REF!"}},{"$f":"F6/24/60","v":{"$error":"#REF!"}},{"$f":"D6*C6","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Facility Assumption","Persons/Unit","gal/person/day"]
["Mercy Clinic Pediatric","Hospital - Bed",75,{"$f":"VLOOKUP(B7,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B7,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C7*E7*D7","v":{"$error":"#REF!"}},{"$f":"F7/24/60","v":{"$error":"#REF!"}},{"$f":"D7*C7","v":{"$error":"#REF!"}}]
["Sub total from existing ",null,null,null,null,{"$f":"SUM(F6:F7)","v":{"$error":"#REF!"}},{"$f":"SUM(G6:G7)","v":{"$error":"#REF!"}},{"$f":"SUM(H6:H7)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H8/1000))/(4+SQRT(H8/1000))","v":{"$error":"#REF!"}},{"$f":"I8*G8","v":{"$error":"#REF!"}},null,null,null,null,"Apartment",2,120]
["Pipe Size (in)",8,"Design Flow",{"$f":" (1.49/0.013)*B12*(B14^(2/3))*(B10^(1/2))","v":0.76632461337433266},"FT³/S",null,null,null,null,null,null,null,null,null,"Assembly Hall",1,4]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D9*60","v":45.979476802459956},"FT³/MIN",null,null,null,null,null,null,null,null,null,"Automobile Service Station- Employees",1,13]
["Pipe Radius ",{"$f":"B9/12/2","v":0.33333333333333331},"Design Flow",{"$f":"D10*7.481","v":343.97246595920291},"GAL/MIN",null,null,null,null,null,null,null,null,null,"Automobile Service Station- Vehicles",1,10]
["Full Area (Afull = π*r²)",{"$f":"PI()*(B11^2)","v":0.3490658503988659},null,null,null,null,null,null,null,null,null,null,null,null,"Country Club- Employees",1,13]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B11","v":2.0943951023931953},"Model Flow",{"$f":"J8","v":{"$error":"#REF!"}},"GAL/MIN",null,null,null,null,null,null,null,null,null,"Country Club- Members",1,25]
["Hydraulic Radius (R = A/P)",{"$f":"B12/B13","v":0.16666666666666669},"Capacity ",{"$f":"D13/D11","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Hospital - Bed",1,250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hospital - Employees",1,10]
["MH 484-6537 to 484-5938","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)",null,null,null,null,"Industrial",1,20]
["McAuley Place",{"$f":"#REF!","v":{"$error":"#REF!"}},188,{"$f":"VLOOKUP(B17,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B17,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C17*E17*D17","v":{"$error":"#REF!"}},{"$f":"F17/24/60","v":{"$error":"#REF!"}},{"$f":"D17*C17","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Commercial",1,10]
["Carry over from upstream",null,null,null,null,{"$f":"F8","v":{"$error":"#REF!"}},{"$f":"G7","v":{"$error":"#REF!"}},{"$f":"H7","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F17:F18)","v":{"$error":"#REF!"}},{"$f":"SUM(G17:G18)","v":{"$error":"#REF!"}},{"$f":"SUM(H17:H18)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H19/1000))/(4+SQRT(H19/1000))","v":{"$error":"#REF!"}},{"$f":"G19*I19","v":{"$error":"#REF!"}},null,null,null,null,"Institutions other than hospitals- Employees",1,10]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B23*(B25^(2/3))*(B21^(1/2))","v":0.76632461337433266},"FT³/S",null,null,null,null,null,null,null,null,null,"Office",1,13]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D20*60","v":45.979476802459956},"FT³/MIN",null,null,null,null,null,null,null,null,null,"Picnic park w/flush toilets",1,5]
["Pipe Radius ",{"$f":"(B20/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D21*7.481","v":343.97246595920291},"GAL/MIN",null,null,null,null,null,null,null,null,null,"Restaurant",1,8]
["Full Area (Afull = π*r²)",{"$f":"PI()*B22^2","v":0.3490658503988659},null,null,null,null,null,null,null,null,null,null,null,null,"School",1,15]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B22","v":2.0943951023931953},"Model Flow",{"$f":"J19","v":{"$error":"#REF!"}},"GAL/MIN",null,null,null,null,null,null,null,null,null,"Shopping Center- Employees",1,10]
["Hydraulic Radius (R = A/P)",{"$f":"B23/B24","v":0.16666666666666669},"Capacity",{"$f":"D24/D22","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,"Shopping Center- Guests",1,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family Residential",3,100]
["MH 484-5938 to 484-5937","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["I Street Modern Apartments","Apartment",238,{"$f":"VLOOKUP(B28,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B28,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"E28*D28*C28","v":{"$error":"#REF!"}},{"$f":"F28/24/60","v":{"$error":"#REF!"}},{"$f":"C28*D28","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Future Land Use Assumptions"]
["Commercial Plaza",{"$f":"O17","v":"Commercial"},4,{"$f":"VLOOKUP(B29,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B29,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C29*E29*D29","v":{"$error":"#REF!"}},{"$f":"F29/24/60","v":{"$error":"#REF!"}},{"$f":"D29*C29","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Future Zoning","Units/Acre","Persons/Unit","Gal/Person/Day"]
["Commercial Plaza",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B30,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B30,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"E30*D30*C30","v":{"$error":"#REF!"}},{"$f":"F30/24/60","v":{"$error":"#REF!"}},{"$f":"C30*D30","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F19","v":{"$error":"#REF!"}},{"$f":"G19","v":{"$error":"#REF!"}},{"$f":"H19","v":{"$error":"#REF!"}},null,null,null,null,null,null,"R-1",4,3,100]
["Sub total",null,{"$f":"C28","v":238},null,null,{"$f":"SUM(F28:F31)","v":{"$error":"#REF!"}},{"$f":"SUM(G28:G31)","v":{"$error":"#REF!"}},{"$f":"SUM(H28:H31)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H32/1000))/(4+SQRT(H32/1000))","v":{"$error":"#REF!"}},{"$f":"G32*I32","v":{"$error":"#REF!"}},null,null,null,null,"R-2",10,2,100]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B36*(B38^(2/3))*(B34^(1/2))","v":0.76632461337433266},"FT³/S",null,null,null,null,null,null,null,null,null,"R-3",22,3,120]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D33*60","v":45.979476802459956},"FT³/MIN",null,null,null,null,null,null,null,null,null,"C-1",4,1,10]
["Pipe Radius ",{"$f":"(B33/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D34*7.481","v":343.97246595920291},"GAL/MIN",null,null,null,null,null,null,null,null,null,"C-2",14,1,10]
["Full Area (Afull = π*r²)",{"$f":"PI()*B35^2","v":0.3490658503988659},null,null,null,null,null,null,null,null,null,null,null,null,"C-3",4,1,10]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B35","v":2.0943951023931953},"Model Flow",{"$f":"J32","v":{"$error":"#REF!"}},"GAL/MIN",null,null,null,null,null,null,null,null,null,"I",1,1,20]
["Hydraulic Radius (R = A/P)",{"$f":"B36/B37","v":0.16666666666666669},"Capacity",{"$f":"D37/D35","v":{"$error":"#REF!"}}]
[]
["MH 484-5937 to 484-5935","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["-",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B41,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B41,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"E41*D41*C41","v":{"$error":"#REF!"}},{"$f":"F41/24/60","v":{"$error":"#REF!"}},{"$f":"C41*D41","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F32","v":{"$error":"#REF!"}},{"$f":"G32","v":{"$error":"#REF!"}},{"$f":"H32","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F41:F42)","v":{"$error":"#REF!"}},{"$f":"SUM(G41:G42)","v":{"$error":"#REF!"}},{"$f":"SUM(H41:H42)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H43/1000))/(4+SQRT(H43/1000))","v":{"$error":"#REF!"}},{"$f":"G43*I43","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B47*(B49^(2/3))*(B45^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D44*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B44/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D45*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B46^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B46","v":2.0943951023931953},"Model Flow",{"$f":"J43","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B47/B48","v":0.16666666666666669},"Capacity",{"$f":"D48/D46","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MH 484-5935 to 484-5934","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["-",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B60,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B60,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"E60*D60*C60","v":{"$error":"#REF!"}},{"$f":"F60/24/60","v":{"$error":"#REF!"}},{"$f":"C60*D60","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F43","v":{"$error":"#REF!"}},{"$f":"G43","v":{"$error":"#REF!"}},{"$f":"H43","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F60:F61)","v":{"$error":"#REF!"}},{"$f":"SUM(G60:G61)","v":{"$error":"#REF!"}},{"$f":"SUM(H60:H61)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H62/1000))/(4+SQRT(H62/1000))","v":{"$error":"#REF!"}},{"$f":"G62*I62","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B66*(B68^(2/3))*(B64^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D63*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B63/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D64*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B65^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B65","v":2.0943951023931953},"Model Flow",{"$f":"J62","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B66/B67","v":0.16666666666666669},"Capacity",{"$f":"D67/D65","v":{"$error":"#REF!"}}]
[]
["MH 484-5934 to 484-6843","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Bentonville Community Center Tennis Court Bathroom","Picnic park w/flush toilets",1,{"$f":"VLOOKUP(B71,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B71,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C71*E71*D71","v":{"$error":"#REF!"}},{"$f":"F71/24/60","v":{"$error":"#REF!"}},{"$f":"D71*C71","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F62","v":{"$error":"#REF!"}},{"$f":"G62","v":{"$error":"#REF!"}},{"$f":"H62","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"SUM(C71:C71)","v":1},null,null,{"$f":"SUM(F71:F72)","v":{"$error":"#REF!"}},{"$f":"SUM(G71:G72)","v":{"$error":"#REF!"}},{"$f":"SUM(H71:H72)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H73/1000))/(4+SQRT(H73/1000))","v":{"$error":"#REF!"}},{"$f":"G73*I73","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B77*(B79^(2/3))*(B75^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D74*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B74/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D75*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B76^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B76","v":2.0943951023931953},"Model Flow",{"$f":"J73","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B77/B78","v":0.16666666666666669},"Capacity",{"$f":"D78/D76","v":{"$error":"#REF!"}}]
[]
["MH 484-6843 to 484-5933","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Bentonville Community Center Main Building ",{"$f":"#REF!","v":{"$error":"#REF!"}},40,{"$f":"VLOOKUP(B82,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B82,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C82*E82*D82","v":{"$error":"#REF!"}},{"$f":"F82/24/60","v":{"$error":"#REF!"}},{"$f":"D82*C82","v":{"$error":"#REF!"}}]
["Bentonville Community Center Main Building ",{"$f":"#REF!","v":{"$error":"#REF!"}},100,{"$f":"VLOOKUP(B83,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B83,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C83*E83*D83","v":{"$error":"#REF!"}},{"$f":"F83/24/60","v":{"$error":"#REF!"}},{"$f":"D83*C83","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F73","v":{"$error":"#REF!"}},{"$f":"G73","v":{"$error":"#REF!"}},{"$f":"H73","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F82:F84)","v":{"$error":"#REF!"}},{"$f":"SUM(G82:G84)","v":{"$error":"#REF!"}},{"$f":"SUM(H82:H84)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H85/1000))/(4+SQRT(H85/1000))","v":{"$error":"#REF!"}},{"$f":"G85*I85","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B89*(B91^(2/3))*(B87^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D86*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B86/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D87*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B88^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B88","v":2.0943951023931953},"Model Flow",{"$f":"J85","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B89/B90","v":0.16666666666666669},"Capacity",{"$f":"D90/D88","v":{"$error":"#REF!"}}]
[]
["MH 484-5933 to 484-5932","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["-",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B94,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B94,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C94*E94*D94","v":{"$error":"#REF!"}},{"$f":"F94/24/60","v":{"$error":"#REF!"}},{"$f":"D94*C94","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F85","v":{"$error":"#REF!"}},{"$f":"G85","v":{"$error":"#REF!"}},{"$f":"H85","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"SUM(C94:C94)","v":0},null,null,{"$f":"SUM(F94:F95)","v":{"$error":"#REF!"}},{"$f":"SUM(G94:G95)","v":{"$error":"#REF!"}},{"$f":"SUM(H94:H95)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H96/1000))/(4+SQRT(H96/1000))","v":{"$error":"#REF!"}},{"$f":"G96*I96","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B100*(B102^(2/3))*(B98^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D97*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B97/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D98*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B99^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B99","v":2.0943951023931953},"Model Flow",{"$f":"J96","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B100/B101","v":0.16666666666666669},"Capacity",{"$f":"D101/D99","v":{"$error":"#REF!"}}]
[]
["MH 484-5932 to 484-6844","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["-",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B105,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B105,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C105*E105*D105","v":{"$error":"#REF!"}},{"$f":"F105/24/60","v":{"$error":"#REF!"}},{"$f":"D105*C105","v":{"$error":"#REF!"}}]
[]
["Carry over from upstream",null,null,null,null,{"$f":"F96","v":{"$error":"#REF!"}},{"$f":"G96","v":{"$error":"#REF!"}},{"$f":"H96","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F105:F107)","v":{"$error":"#REF!"}},{"$f":"SUM(G105:G107)","v":{"$error":"#REF!"}},{"$f":"SUM(H105:H107)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H108/1000))/(4+SQRT(H108/1000))","v":{"$error":"#REF!"}},{"$f":"G108*I108","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B112*(B114^(2/3))*(B110^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D109*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B109/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D110*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B111^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B111","v":2.0943951023931953},"Model Flow",{"$f":"J108","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B112/B113","v":0.16666666666666669},"Capacity",{"$f":"D113/D111","v":{"$error":"#REF!"}}]
[]
["MH 484-6844 to 484-1091","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Citizen Park ",{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"VLOOKUP(B117,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B117,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C117*E117*D117","v":{"$error":"#REF!"}},{"$f":"F117/24/60","v":{"$error":"#REF!"}},{"$f":"D117*C117","v":{"$error":"#REF!"}}]
[]
[]
[]
["Carry over from upstream",null,null,null,null,{"$f":"F108","v":{"$error":"#REF!"}},{"$f":"G108","v":{"$error":"#REF!"}},{"$f":"H108","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F117:F121)","v":{"$error":"#REF!"}},{"$f":"SUM(G117:G121)","v":{"$error":"#REF!"}},{"$f":"SUM(H117:H121)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H122/1000))/(4+SQRT(H122/1000))","v":{"$error":"#REF!"}},{"$f":"G122*I122","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B126*(B128^(2/3))*(B124^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D123*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B123/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D124*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B125^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B125","v":2.0943951023931953},"Model Flow",{"$f":"J122","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B126/B127","v":0.16666666666666669},"Capacity",{"$f":"D127/D125","v":{"$error":"#REF!"}}]
[]
["MH 484-1091 to 484-1101","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Oxford Ridge Subdivision",{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$error":"#REF!"},{"$f":"VLOOKUP(B131,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C131*E131*D131","v":{"$error":"#REF!"}},{"$f":"F131/24/60","v":{"$error":"#REF!"}},{"$f":"D131*C131","v":{"$error":"#REF!"}}]
[null,"Country Club- Members",0,1,25,{"$f":"C132*E132*D132","v":0},{"$f":"F132/24/60","v":0},{"$f":"D132*C132","v":0}]
[null,"Country Club- Employees",0,1,13,{"$f":"C133*E133*D133","v":0},{"$f":"F133/24/60","v":0},{"$f":"D133*C133","v":0}]
[null,"assembly hall",0,1,4,{"$f":"C134*E134*D134","v":0},{"$f":"F134/24/60","v":0},{"$f":"D134*C134","v":0}]
[null,"Single Family Residential",0,{"$f":"VLOOKUP(B135,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B135,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C135*E135*D135","v":{"$error":"#REF!"}},{"$f":"F135/24/60","v":{"$error":"#REF!"}},{"$f":"D135*C135","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F122","v":{"$error":"#REF!"}},{"$f":"G122","v":{"$error":"#REF!"}},{"$f":"H122","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F131:F136)","v":{"$error":"#REF!"}},{"$f":"SUM(G131:G136)","v":{"$error":"#REF!"}},{"$f":"SUM(H131:H136)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H137/1000))/(4+SQRT(H137/1000))","v":{"$error":"#REF!"}},{"$f":"G137*I137","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B141*(B143^(2/3))*(B139^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D138*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B138/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D139*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B140^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B140","v":2.0943951023931953},"Model Flow",{"$f":"J137","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B141/B142","v":0.16666666666666669},"Capacity",{"$f":"D142/D140","v":{"$error":"#REF!"}}]
[]
["MH 484-1101 to 484-1102","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["-","Single Family Residential",0,{"$f":"VLOOKUP(B146,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B146,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C146*E146*D146","v":{"$error":"#REF!"}},{"$f":"F146/24/60","v":{"$error":"#REF!"}},{"$f":"D146*C146","v":{"$error":"#REF!"}}]
["The Buttered Biscuit at I Steet ",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B147,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B147,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C147*E147*D147","v":{"$error":"#REF!"}},{"$f":"F147/24/60","v":{"$error":"#REF!"}},{"$f":"D147*C147","v":{"$error":"#REF!"}}]
["Flagstone Church of Christ ",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B148,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B148,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C148*E148*D148","v":{"$error":"#REF!"}},{"$f":"F148/24/60","v":{"$error":"#REF!"}},{"$f":"D148*C148","v":{"$error":"#REF!"}}]
["Scooters Coffee",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B149,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B149,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C149*E149*D149","v":{"$error":"#REF!"}},{"$f":"F149/24/60","v":{"$error":"#REF!"}},{"$f":"D149*C149","v":{"$error":"#REF!"}}]
["Bentonville Community Center Soccer Pitch Bathroom",{"$f":"#REF!","v":{"$error":"#REF!"}},0,{"$f":"VLOOKUP(B150,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B150,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C150*E150*D150","v":{"$error":"#REF!"}},{"$f":"F150/24/60","v":{"$error":"#REF!"}},{"$f":"D150*C150","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F137","v":{"$error":"#REF!"}},{"$f":"G137","v":{"$error":"#REF!"}},{"$f":"H137","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"C96","v":0},null,null,{"$f":"SUM(F146:F151)","v":{"$error":"#REF!"}},{"$f":"SUM(G146:G151)","v":{"$error":"#REF!"}},{"$f":"SUM(H146:H151)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H152/1000))/(4+SQRT(H152/1000))","v":{"$error":"#REF!"}},{"$f":"G152*I152","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B156*(B158^(2/3))*(B154^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D153*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B153/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D154*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B155^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B155","v":2.0943951023931953},"Model Flow",{"$f":"J152","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B156/B157","v":0.16666666666666669},"Capacity",{"$f":"D157/D155","v":{"$error":"#REF!"}}]
[]
["MH 484-1102 to 484-1108","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Oxford Ridge Subdivision","Single Family Residential",{"$f":"45+65","v":110},{"$f":"VLOOKUP(B161,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B161,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C161*E161*D161","v":{"$error":"#REF!"}},{"$f":"F161/24/60","v":{"$error":"#REF!"}},{"$f":"D161*C161","v":{"$error":"#REF!"}}]
["The Buttered Biscuit at I Steet ",{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"VLOOKUP(B162,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B162,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C162*E162*D162","v":{"$error":"#REF!"}},{"$f":"F162/24/60","v":{"$error":"#REF!"}},{"$f":"D162*C162","v":{"$error":"#REF!"}}]
["Flagstone Church of Christ ",{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"VLOOKUP(B163,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B163,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C163*E163*D163","v":{"$error":"#REF!"}},{"$f":"F163/24/60","v":{"$error":"#REF!"}},{"$f":"D163*C163","v":{"$error":"#REF!"}}]
["Bentonville Community Center Soccer Pitch Bathroom",{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"VLOOKUP(B164,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B164,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C164*E164*D164","v":{"$error":"#REF!"}},{"$f":"F164/24/60","v":{"$error":"#REF!"}},{"$f":"D164*C164","v":{"$error":"#REF!"}}]
["Scooters Coffee",{"$f":"#REF!","v":{"$error":"#REF!"}},1,{"$f":"VLOOKUP(B165,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B165,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C165*E165*D165","v":{"$error":"#REF!"}},{"$f":"F165/24/60","v":{"$error":"#REF!"}},{"$f":"D165*C165","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F152","v":{"$error":"#REF!"}},{"$f":"G152","v":{"$error":"#REF!"}},{"$f":"H152","v":{"$error":"#REF!"}}]
["Sub total",null,null,null,null,{"$f":"SUM(F161:F166)","v":{"$error":"#REF!"}},{"$f":"SUM(G161:G166)","v":{"$error":"#REF!"}},{"$f":"SUM(H161:H166)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H167/1000))/(4+SQRT(H167/1000))","v":{"$error":"#REF!"}},{"$f":"G167*I167","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B171*(B173^(2/3))*(B169^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D168*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B168/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D169*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B170^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B170","v":2.0943951023931953},"Model Flow",{"$f":"J167","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B171/B172","v":0.16666666666666669},"Capacity",{"$f":"D172/D170","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["MH 484-1088 to 484-1075","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Oxford Ridge Subdivision ","Single Family Residential",47,{"$f":"VLOOKUP(B182,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B182,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C182*E182*D182","v":{"$error":"#REF!"}},{"$f":"F182/24/60","v":{"$error":"#REF!"}},{"$f":"D182*C182","v":{"$error":"#REF!"}}]
["Commercial Plaza",{"$f":"#REF!","v":{"$error":"#REF!"}},4,{"$f":"VLOOKUP(B183,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B183,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C183*E183*D183","v":{"$error":"#REF!"}},{"$f":"F183/24/60","v":{"$error":"#REF!"}},{"$f":"D183*C183","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F167","v":{"$error":"#REF!"}},{"$f":"G167","v":{"$error":"#REF!"}},{"$f":"H167","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F182:F184)","v":{"$error":"#REF!"}},{"$f":"SUM(G182:G184)","v":{"$error":"#REF!"}},{"$f":"SUM(H182:H184)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H185/1000))/(4+SQRT(H185/1000))","v":{"$error":"#REF!"}},{"$f":"G185*I185","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B189*(B191^(2/3))*(B187^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D186*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B186/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D187*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B188^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B188","v":2.0943951023931953},"Model Flow",{"$f":"J185","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B189/B190","v":0.16666666666666669},"Capacity",{"$f":"D190/D188","v":{"$error":"#REF!"}}]
[]
["MH 484-1075 to 484-1115","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Oxford Ridge Subdivision","Single Family Residential",46,{"$f":"VLOOKUP(B194,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B194,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C194*E194*D194","v":{"$error":"#REF!"}},{"$f":"F194/24/60","v":{"$error":"#REF!"}},{"$f":"D194*C194","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F185","v":{"$error":"#REF!"}},{"$f":"G185","v":{"$error":"#REF!"}},{"$f":"H185","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F194:F195)","v":{"$error":"#REF!"}},{"$f":"SUM(G194:G195)","v":{"$error":"#REF!"}},{"$f":"SUM(H194:H195)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H196/1000))/(4+SQRT(H196/1000))","v":{"$error":"#REF!"}},{"$f":"G196*I196","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B200*(B202^(2/3))*(B198^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D197*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B197/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D198*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B199^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B199","v":2.0943951023931953},"Model Flow",{"$f":"J196","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B200/B201","v":0.16666666666666669},"Capacity",{"$f":"D201/D199","v":{"$error":"#REF!"}}]
[]
["MH 484-1115 to 484-1365","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Oxford Ridge Subdivision","Single Family Residential",1,{"$f":"VLOOKUP(B205,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B205,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C205*E205*D205","v":{"$error":"#REF!"}},{"$f":"F205/24/60","v":{"$error":"#REF!"}},{"$f":"D205*C205","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F196","v":{"$error":"#REF!"}},{"$f":"G196","v":{"$error":"#REF!"}},{"$f":"H196","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F205:F206)","v":{"$error":"#REF!"}},{"$f":"SUM(G205:G206)","v":{"$error":"#REF!"}},{"$f":"SUM(H205:H206)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H207/1000))/(4+SQRT(H207/1000))","v":{"$error":"#REF!"}},{"$f":"G207*I207","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B211*(B213^(2/3))*(B209^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D208*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B208/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D209*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B210^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B210","v":2.0943951023931953},"Model Flow",{"$f":"J207","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B211/B212","v":0.16666666666666669},"Capacity",{"$f":"D212/D210","v":{"$error":"#REF!"}}]
[]
["MH 484-1365 to 484-1366","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ","Single Family Residential",17,{"$f":"VLOOKUP(B216,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B216,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C216*E216*D216","v":{"$error":"#REF!"}},{"$f":"F216/24/60","v":{"$error":"#REF!"}},{"$f":"D216*C216","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F207","v":{"$error":"#REF!"}},{"$f":"G207","v":{"$error":"#REF!"}},{"$f":"H207","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F216:F217)","v":{"$error":"#REF!"}},{"$f":"SUM(G216:G217)","v":{"$error":"#REF!"}},{"$f":"SUM(H216:H217)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H218/1000))/(4+SQRT(H218/1000))","v":{"$error":"#REF!"}},{"$f":"G218*I218","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B222*(B224^(2/3))*(B220^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D219*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B219/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D220*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B221^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B221","v":2.0943951023931953},"Model Flow",{"$f":"J218","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B222/B223","v":0.16666666666666669},"Capacity",{"$f":"D223/D221","v":{"$error":"#REF!"}}]
[]
["MH 484-1366 to 484-1345","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ","Single Family Residential",9,{"$f":"VLOOKUP(B227,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B227,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C227*E227*D227","v":{"$error":"#REF!"}},{"$f":"F227/24/60","v":{"$error":"#REF!"}},{"$f":"D227*C227","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F218","v":{"$error":"#REF!"}},{"$f":"G218","v":{"$error":"#REF!"}},{"$f":"H218","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F227:F228)","v":{"$error":"#REF!"}},{"$f":"SUM(G227:G228)","v":{"$error":"#REF!"}},{"$f":"SUM(H227:H228)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H229/1000))/(4+SQRT(H229/1000))","v":{"$error":"#REF!"}},{"$f":"G229*I229","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B233*(B235^(2/3))*(B231^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D230*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B230/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D231*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B232^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B232","v":2.0943951023931953},"Model Flow",{"$f":"J229","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B233/B234","v":0.16666666666666669},"Capacity",{"$f":"D234/D232","v":{"$error":"#REF!"}}]
[]
["MH 484-1345 to 484-1344","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ","Single Family Residential",4,{"$f":"VLOOKUP(B238,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B238,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C238*E238*D238","v":{"$error":"#REF!"}},{"$f":"F238/24/60","v":{"$error":"#REF!"}},{"$f":"D238*C238","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F229","v":{"$error":"#REF!"}},{"$f":"G229","v":{"$error":"#REF!"}},{"$f":"H229","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F238:F239)","v":{"$error":"#REF!"}},{"$f":"SUM(G238:G239)","v":{"$error":"#REF!"}},{"$f":"SUM(H238:H239)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H240/1000))/(4+SQRT(H240/1000))","v":{"$error":"#REF!"}},{"$f":"G240*I240","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B244*(B246^(2/3))*(B242^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D241*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B241/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D242*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B243^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B243","v":2.0943951023931953},"Model Flow",{"$f":"J240","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B244/B245","v":0.16666666666666669},"Capacity",{"$f":"D245/D243","v":{"$error":"#REF!"}}]
[]
["MH 484-1344 to 484-1368","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ","Single Family Residential",3,{"$f":"VLOOKUP(B249,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B249,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C249*E249*D249","v":{"$error":"#REF!"}},{"$f":"F249/24/60","v":{"$error":"#REF!"}},{"$f":"D249*C249","v":{"$error":"#REF!"}}]
[null,"Apartment",0,{"$f":"VLOOKUP(B250,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B250,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C250*E250*D250","v":{"$error":"#REF!"}},{"$f":"F250/24/60","v":{"$error":"#REF!"}},{"$f":"D250*C250","v":{"$error":"#REF!"}}]
[null,"Assembly Hall",0,{"$f":"VLOOKUP(B251,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B251,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C251*E251*D251","v":{"$error":"#REF!"}},{"$f":"F251/24/60","v":{"$error":"#REF!"}},{"$f":"D251*C251","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F240","v":{"$error":"#REF!"}},{"$f":"G240","v":{"$error":"#REF!"}},{"$f":"H240","v":{"$error":"#REF!"}}]
["Sub total",null,null,null,null,{"$f":"SUM(F249:F252)","v":{"$error":"#REF!"}},{"$f":"SUM(G249:G252)","v":{"$error":"#REF!"}},{"$f":"SUM(H249:H252)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H253/1000))/(4+SQRT(H253/1000))","v":{"$error":"#REF!"}},{"$f":"G253*I253","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B257*(B259^(2/3))*(B255^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D254*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B254/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D255*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B256^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B256","v":2.0943951023931953},"Model Flow",{"$f":"J253","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B257/B258","v":0.16666666666666669},"Capacity",{"$f":"D258/D256","v":{"$error":"#REF!"}}]
[]
["MH 484-1368 to 484-1301","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ","Single Family Residential",30,{"$f":"VLOOKUP(B262,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B262,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C262*E262*D262","v":{"$error":"#REF!"}},{"$f":"F262/24/60","v":{"$error":"#REF!"}},{"$f":"D262*C262","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F253","v":{"$error":"#REF!"}},{"$f":"G253","v":{"$error":"#REF!"}},{"$f":"H253","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F262:F263)","v":{"$error":"#REF!"}},{"$f":"SUM(G262:G263)","v":{"$error":"#REF!"}},{"$f":"SUM(H262:H263)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H264/1000))/(4+SQRT(H264/1000))","v":{"$error":"#REF!"}},{"$f":"G264*I264","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B268*(B270^(2/3))*(B266^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D265*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B265/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D266*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B267^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B267","v":2.0943951023931953},"Model Flow",{"$f":"J264","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B268/B269","v":0.16666666666666669},"Capacity",{"$f":"D269/D267","v":{"$error":"#REF!"}}]
[]
["MH 484-1301 to 484-5120","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ","Single Family Residential",9,{"$f":"VLOOKUP(B273,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B273,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C273*E273*D273","v":{"$error":"#REF!"}},{"$f":"F273/24/60","v":{"$error":"#REF!"}},{"$f":"D273*C273","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F264","v":{"$error":"#REF!"}},{"$f":"G264","v":{"$error":"#REF!"}},{"$f":"H264","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F273:F274)","v":{"$error":"#REF!"}},{"$f":"SUM(G273:G274)","v":{"$error":"#REF!"}},{"$f":"SUM(H273:H274)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H275/1000))/(4+SQRT(H275/1000))","v":{"$error":"#REF!"}},{"$f":"G275*I275","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B279*(B281^(2/3))*(B277^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D276*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B276/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D277*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B278^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B278","v":2.0943951023931953},"Model Flow",{"$f":"J275","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B279/B280","v":0.16666666666666669},"Capacity",{"$f":"D280/D278","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["MH 484-5120 to 484-7741","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ","Single Family Residential",115,{"$f":"VLOOKUP(B291,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B291,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C291*E291*D291","v":{"$error":"#REF!"}},{"$f":"F291/24/60","v":{"$error":"#REF!"}},{"$f":"D291*C291","v":{"$error":"#REF!"}}]
[null,"Office",0,{"$f":"VLOOKUP(B292,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B292,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C292*E292*D292","v":{"$error":"#REF!"}},{"$f":"F292/24/60","v":{"$error":"#REF!"}},{"$f":"D292*C292","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F275","v":{"$error":"#REF!"}},{"$f":"G275","v":{"$error":"#REF!"}},{"$f":"H275","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F291:F293)","v":{"$error":"#REF!"}},{"$f":"SUM(G291:G293)","v":{"$error":"#REF!"}},{"$f":"SUM(H291:H293)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H294/1000))/(4+SQRT(H294/1000))","v":{"$error":"#REF!"}},{"$f":"G294*I294","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B298*(B300^(2/3))*(B296^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D295*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B295/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D296*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B297^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B297","v":2.0943951023931953},"Model Flow",{"$f":"J294","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B298/B299","v":0.16666666666666669},"Capacity",{"$f":"D299/D297","v":{"$error":"#REF!"}}]
[]
["MH 484-7741 to 484-1303","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Brightwood ",{"$f":"B291","v":"Single Family Residential"},0,{"$f":"VLOOKUP(B303,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B303,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C303*E303*D303","v":{"$error":"#REF!"}},{"$f":"F303/24/60","v":{"$error":"#REF!"}},{"$f":"D303*C303","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F294","v":{"$error":"#REF!"}},{"$f":"G294","v":{"$error":"#REF!"}},{"$f":"H294","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"SUM(C303:C303)","v":0},null,null,{"$f":"SUM(F303:F304)","v":{"$error":"#REF!"}},{"$f":"SUM(G303:G304)","v":{"$error":"#REF!"}},{"$f":"SUM(H303:H304)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H305/1000))/(4+SQRT(H305/1000))","v":{"$error":"#REF!"}},{"$f":"G305*I305","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B309*(B311^(2/3))*(B307^(1/2))","v":0.76632461337433266},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0000000000000001E-3,"Design Flow",{"$f":"D306*60","v":45.979476802459956},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B306/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D307*7.481","v":343.97246595920291},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B308^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B308","v":2.0943951023931953},"Model Flow",{"$f":"J305","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B309/B310","v":0.16666666666666669},"Capacity",{"$f":"D310/D308","v":{"$error":"#REF!"}}]
[]
["MH 8366 to 12040","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Calc. Peak (gpm)"]
["Carry over from upstream",null,null,null,null,{"$f":"F305","v":{"$error":"#REF!"}},{"$f":"G305","v":{"$error":"#REF!"}},{"$f":"H305","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F314:F314)","v":{"$error":"#REF!"}},{"$f":"SUM(G314:G314)","v":{"$error":"#REF!"}},{"$f":"SUM(H314:H314)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H315/1000))/(4+SQRT(H315/1000))","v":{"$error":"#REF!"}},{"$f":"G315*I315","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B319*(B321^(2/3))*(B317^(1/2))","v":3.3709573629423515},"FT³/S"]
["Pipe Slope (S) (FT/FT)",7.7399999999999997E-2,"Design Flow",{"$f":"D316*60","v":202.2574417765411},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B316/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D317*7.481","v":1513.087921930304},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B318^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B318","v":2.0943951023931953},"Model Flow",{"$f":"J315","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B319/B320","v":0.16666666666666669},"Capacity",{"$f":"D320/D318","v":{"$error":"#REF!"}}]

{"sheet":"Bishop North Proposed","index":4,"n_rows":303,"n_cols":13,"rows_kept":303,"cut":false,"hidden":true,"merged":[[255,0,255,4],[274,0,274,4],[285,0,285,4],[295,0,295,4],[187,0,187,4],[198,0,198,4],[209,0,209,4],[220,0,220,4],[233,0,233,4],[244,0,244,4],[176,0,176,4],[38,0,38,4],[56,0,56,4],[67,0,67,4],[78,0,78,4],[89,0,89,4],[100,0,100,4],[111,0,111,4],[126,0,126,4],[137,0,137,4],[148,0,148,4],[165,0,165,4],[27,0,27,4],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[16,0,16,4]]}
["Bishop North Sewer Study"]
["Manhhole 8505 to 12040 - Proposed Flows"]
["Crafton Tull Job # 21112800"]
["2023-05-24"]
["MH 8505 to 8503","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Bishop North Gravity","Single Family Residential",47,{"$f":"VLOOKUP(B6,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B6,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C6*E6*D6","v":{"$error":"#REF!"}},{"$f":"F6/24/60","v":{"$error":"#REF!"}},{"$f":"D6*C6","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H6/1000))/(4+SQRT(H6/1000))","v":{"$error":"#REF!"}},null,{"$f":"G6*I6","v":{"$error":"#REF!"}}]
["Sub total from existing ","Single Family Residential - Lift Station (93 lots)",null,null,null,{"$f":"F6","v":{"$error":"#REF!"}},{"$f":"SUM(G6:G6)","v":{"$error":"#REF!"}},{"$f":"SUM(H6:H6)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H7/1000))/(4+SQRT(H7/1000))","v":{"$error":"#REF!"}},99,{"$f":"SUM(K6:K6)+J7","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":" (1.49/0.013)*B11*(B13^(2/3))*(B9^(1/2))","v":0.99916505253518795},"FT³/S"]
["Pipe Slope (S) (FT/FT)",6.7999999999999996E-3,"Design Flow",{"$f":"D8*60","v":59.949903152111276},"FT³/MIN"]
["Pipe Radius ",{"$f":"B8/12/2","v":0.33333333333333331},"Design Flow",{"$f":"D9*7.481","v":448.48522548094445},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*(B10^2)","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B10","v":2.0943951023931953},"Model Flow",{"$f":"K7","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B11/B12","v":0.16666666666666669},"Capacity ",{"$f":"D12/D10","v":{"$error":"#REF!"}}]
[]
["MH 8503 to 8502","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Summer Meadows PH 1","Single Family Residential",6,{"$f":"VLOOKUP(B16,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B16,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C16*E16*D16","v":{"$error":"#REF!"}},{"$f":"F16/24/60","v":{"$error":"#REF!"}},{"$f":"D16*C16","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F7","v":{"$error":"#REF!"}},{"$f":"G7","v":{"$error":"#REF!"}},{"$f":"H7","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F16:F17)","v":{"$error":"#REF!"}},{"$f":"SUM(G16:G17)","v":{"$error":"#REF!"}},{"$f":"SUM(H16:H17)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H18/1000))/(4+SQRT(H18/1000))","v":{"$error":"#REF!"}},{"$f":"J7","v":99},{"$f":"G18*I18+J18","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B22*(B24^(2/3))*(B20^(1/2))","v":2.5760364065004056},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.5199999999999997E-2,"Design Flow",{"$f":"D19*60","v":154.56218439002433},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B19/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D20*7.481","v":1156.279701421772},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B21^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B21","v":2.0943951023931953},"Model Flow",{"$f":"K18","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B22/B23","v":0.16666666666666669},"Capacity",{"$f":"D23/D21","v":{"$error":"#REF!"}}]
[]
["MH 8502 to 8500","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Summer Meadows PH 2","Single Family Residential",6,{"$f":"VLOOKUP(B27,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B27,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"E27*D27*C27","v":{"$error":"#REF!"}},{"$f":"F27/24/60","v":{"$error":"#REF!"}},{"$f":"C27*D27","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F18","v":{"$error":"#REF!"}},{"$f":"G18","v":{"$error":"#REF!"}},{"$f":"H18","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"C27","v":6},null,null,{"$f":"SUM(F27:F28)","v":{"$error":"#REF!"}},{"$f":"SUM(G27:G28)","v":{"$error":"#REF!"}},{"$f":"SUM(H27:H28)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H29/1000))/(4+SQRT(H29/1000))","v":{"$error":"#REF!"}},{"$f":"J18","v":99},{"$f":"G29*I29+J29","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B33*(B35^(2/3))*(B31^(1/2))","v":0.99179103992779749},"FT³/S"]
["Pipe Slope (S) (FT/FT)",6.7000000000000002E-3,"Design Flow",{"$f":"D30*60","v":59.507462395667851},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B30/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D31*7.481","v":445.17532618199118},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B32^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B32","v":2.0943951023931953},"Model Flow",{"$f":"K29","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B33/B34","v":0.16666666666666669},"Capacity",{"$f":"D34/D32","v":{"$error":"#REF!"}}]
[]
["MH 8500 to 8499","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Summer Meadows Phase 1","Single Family Residential",6,{"$f":"VLOOKUP(B38,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B38,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"E38*D38*C38","v":{"$error":"#REF!"}},{"$f":"F38/24/60","v":{"$error":"#REF!"}},{"$f":"C38*D38","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F29","v":{"$error":"#REF!"}},{"$f":"G29","v":{"$error":"#REF!"}},{"$f":"H29","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F38:F39)","v":{"$error":"#REF!"}},{"$f":"SUM(G38:G39)","v":{"$error":"#REF!"}},{"$f":"SUM(H38:H39)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H40/1000))/(4+SQRT(H40/1000))","v":{"$error":"#REF!"}},{"$f":"J29","v":99},{"$f":"G40*I40+J40","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B44*(B46^(2/3))*(B42^(1/2))","v":2.2110822381250643},"FT³/S"]
["Pipe Slope (S) (FT/FT)",3.3300000000000003E-2,"Design Flow",{"$f":"D41*60","v":132.66493428750385},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B41/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D42*7.481","v":992.4663734048163},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B43^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B43","v":2.0943951023931953},"Model Flow",{"$f":"K40","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B44/B45","v":0.16666666666666669},"Capacity",{"$f":"D45/D43","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["MH 8499 to 8493","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Summer Meadows Phase 2","Single Family Residential",3,{"$f":"VLOOKUP(B56,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B56,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"E56*D56*C56","v":{"$error":"#REF!"}},{"$f":"F56/24/60","v":{"$error":"#REF!"}},{"$f":"C56*D56","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F40","v":{"$error":"#REF!"}},{"$f":"G40","v":{"$error":"#REF!"}},{"$f":"H40","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F56:F57)","v":{"$error":"#REF!"}},{"$f":"SUM(G56:G57)","v":{"$error":"#REF!"}},{"$f":"SUM(H56:H57)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H58/1000))/(4+SQRT(H58/1000))","v":{"$error":"#REF!"}},{"$f":"J40","v":99},{"$f":"G58*I58+J58","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B62*(B64^(2/3))*(B60^(1/2))","v":2.4831755550433536},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.2000000000000003E-2,"Design Flow",{"$f":"D59*60","v":148.99053330260122},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B59/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D60*7.481","v":1114.5981796367598},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B61^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B61","v":2.0943951023931953},"Model Flow",{"$f":"K58","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B62/B63","v":0.16666666666666669},"Capacity",{"$f":"D63/D61","v":{"$error":"#REF!"}}]
[]
["MH 8493 to MH 8490","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Multiple Subdivisions","Single Family Residential",138,{"$f":"VLOOKUP(B67,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B67,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C67*E67*D67","v":{"$error":"#REF!"}},{"$f":"F67/24/60","v":{"$error":"#REF!"}},{"$f":"D67*C67","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F58","v":{"$error":"#REF!"}},{"$f":"G58","v":{"$error":"#REF!"}},{"$f":"H58","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"SUM(C67:C67)","v":138},null,null,{"$f":"SUM(F67:F68)","v":{"$error":"#REF!"}},{"$f":"SUM(G67:G68)","v":{"$error":"#REF!"}},{"$f":"SUM(H67:H68)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H69/1000))/(4+SQRT(H69/1000))","v":{"$error":"#REF!"}},{"$f":"J58","v":99},{"$f":"G69*I69+J69","v":{"$error":"#REF!"}}]
["Pipe Size (in)",10,"Design Flow",{"$f":"(1.49/0.013)*B73*(B75^(2/3))*(B71^(1/2))","v":1.423751273855336},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.1999999999999997E-3,"Design Flow",{"$f":"D70*60","v":85.42507643132015},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B70/12)/2","v":0.41666666666666669},"Design Flow",{"$f":"D71*7.481","v":639.06499678270598},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B72^2","v":0.54541539124822802}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B72","v":2.6179938779914944},"Model Flow",{"$f":"K69","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B73/B74","v":0.20833333333333334},"Capacity",{"$f":"D74/D72","v":{"$error":"#REF!"}}]
[]
["MH 8490 to 8489","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Phase II","Single Family Residential",15,{"$f":"VLOOKUP(B78,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B78,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C78*E78*D78","v":{"$error":"#REF!"}},{"$f":"F78/24/60","v":{"$error":"#REF!"}},{"$f":"D78*C78","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F69","v":{"$error":"#REF!"}},{"$f":"G69","v":{"$error":"#REF!"}},{"$f":"H69","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F78:F79)","v":{"$error":"#REF!"}},{"$f":"SUM(G78:G79)","v":{"$error":"#REF!"}},{"$f":"SUM(H78:H79)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H80/1000))/(4+SQRT(H80/1000))","v":{"$error":"#REF!"}},{"$f":"J69","v":99},{"$f":"G80*I80+J80","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B84*(B86^(2/3))*(B82^(1/2))","v":0.78804852916204449},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.2300000000000003E-3,"Design Flow",{"$f":"D81*60","v":47.282911749722672},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B81/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D82*7.481","v":353.7234627996753},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B83^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B83","v":2.0943951023931953},"Model Flow",{"$f":"K80","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B84/B85","v":0.16666666666666669},"Capacity",{"$f":"D85/D83","v":{"$error":"#REF!"}}]
[]
["MH 8489 to 8488","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Phase II","Single Family Residential",8,{"$f":"VLOOKUP(B89,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B89,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C89*E89*D89","v":{"$error":"#REF!"}},{"$f":"F89/24/60","v":{"$error":"#REF!"}},{"$f":"D89*C89","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F80","v":{"$error":"#REF!"}},{"$f":"G80","v":{"$error":"#REF!"}},{"$f":"H80","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"SUM(C89:C89)","v":8},null,null,{"$f":"SUM(F89:F90)","v":{"$error":"#REF!"}},{"$f":"SUM(G89:G90)","v":{"$error":"#REF!"}},{"$f":"SUM(H89:H90)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H91/1000))/(4+SQRT(H91/1000))","v":{"$error":"#REF!"}},{"$f":"J80","v":99},{"$f":"G91*I91+J91","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B95*(B97^(2/3))*(B93^(1/2))","v":0.76908444716990099},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.0288629999999997E-3,"Design Flow",{"$f":"D92*60","v":46.145066830194061},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B92/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D93*7.481","v":345.21124495668175},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B94^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B94","v":2.0943951023931953},"Model Flow",{"$f":"K91","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B95/B96","v":0.16666666666666669},"Capacity",{"$f":"D96/D94","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"over 80"]
[]
["MH 8488 to 8487","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Phase II","Single Family Residential",8,{"$f":"VLOOKUP(B100,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B100,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C100*E100*D100","v":{"$error":"#REF!"}},{"$f":"F100/24/60","v":{"$error":"#REF!"}},{"$f":"D100*C100","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F91","v":{"$error":"#REF!"}},{"$f":"G91","v":{"$error":"#REF!"}},{"$f":"H91","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F100:F101)","v":{"$error":"#REF!"}},{"$f":"SUM(G100:G101)","v":{"$error":"#REF!"}},{"$f":"SUM(H100:H101)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H102/1000))/(4+SQRT(H102/1000))","v":{"$error":"#REF!"}},{"$f":"J91","v":99},{"$f":"G102*I102+J102","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B106*(B108^(2/3))*(B104^(1/2))","v":0.8128099960607249},"FT³/S"]
["Pipe Slope (S) (FT/FT)",4.4999999999999997E-3,"Design Flow",{"$f":"D103*60","v":48.768599763643493},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B103/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D104*7.481","v":364.83789483181698},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B105^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B105","v":2.0943951023931953},"Model Flow",{"$f":"K102","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B106/B107","v":0.16666666666666669},"Capacity",{"$f":"D107/D105","v":{"$error":"#REF!"}}]
[]
["MH 8487 to 8484","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Phase II","Single Family Residential",6,{"$f":"VLOOKUP(B111,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B111,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C111*E111*D111","v":{"$error":"#REF!"}},{"$f":"F111/24/60","v":{"$error":"#REF!"}},{"$f":"D111*C111","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F102","v":{"$error":"#REF!"}},{"$f":"G102","v":{"$error":"#REF!"}},{"$f":"H102","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F111:F112)","v":{"$error":"#REF!"}},{"$f":"SUM(G111:G112)","v":{"$error":"#REF!"}},{"$f":"SUM(H111:H112)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H113/1000))/(4+SQRT(H113/1000))","v":{"$error":"#REF!"}},{"$f":"J102","v":99},{"$f":"G113*I113+J113","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B117*(B119^(2/3))*(B115^(1/2))","v":1.2356613103778209},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.04E-2,"Design Flow",{"$f":"D114*60","v":74.139678622669251},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B114/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D115*7.481","v":554.63893577618865},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B116^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B116","v":2.0943951023931953},"Model Flow",{"$f":"K113","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B117/B118","v":0.16666666666666669},"Capacity",{"$f":"D118/D116","v":{"$error":"#REF!"}}]
[]
["MH 8484 to 8483","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
[null,"Picnic park w/flush toilets",62.25,1,5,{"$f":"C122*E122*D122","v":311.25},{"$f":"F122/24/60","v":0.21614583333333334},{"$f":"D122*C122","v":62.25}]
[null,"Country Club- Members",26.25,1,25,{"$f":"C123*E123*D123","v":656.25},{"$f":"F123/24/60","v":0.45572916666666669},{"$f":"D123*C123","v":26.25}]
[null,"Country Club- Employees",7.5,1,13,{"$f":"C124*E124*D124","v":97.5},{"$f":"F124/24/60","v":6.7708333333333329E-2},{"$f":"D124*C124","v":7.5}]
[null,"assembly hall",52.5,1,4,{"$f":"C125*E125*D125","v":210},{"$f":"F125/24/60","v":0.14583333333333334},{"$f":"D125*C125","v":52.5}]
[null,"Single Family Residential",4,{"$f":"VLOOKUP(B126,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B126,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C126*E126*D126","v":{"$error":"#REF!"}},{"$f":"F126/24/60","v":{"$error":"#REF!"}},{"$f":"D126*C126","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F113","v":{"$error":"#REF!"}},{"$f":"G113","v":{"$error":"#REF!"}},{"$f":"H113","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F122:F127)","v":{"$error":"#REF!"}},{"$f":"SUM(G122:G127)","v":{"$error":"#REF!"}},{"$f":"SUM(H122:H127)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H128/1000))/(4+SQRT(H128/1000))","v":{"$error":"#REF!"}},{"$f":"J113","v":99},{"$f":"G128*I128+J128","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B132*(B134^(2/3))*(B130^(1/2))","v":1.2474860899496232},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.06E-2,"Design Flow",{"$f":"D129*60","v":74.849165396977384},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B129/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D130*7.481","v":559.94660633478782},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B131^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B131","v":2.0943951023931953},"Model Flow",{"$f":"K128","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B132/B133","v":0.16666666666666669},"Capacity",{"$f":"D133/D131","v":{"$error":"#REF!"}}]
[]
["MH 8483 to 8482","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Subdivision Ph I","Single Family Residential",10,{"$f":"VLOOKUP(B137,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B137,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C137*E137*D137","v":{"$error":"#REF!"}},{"$f":"F137/24/60","v":{"$error":"#REF!"}},{"$f":"D137*C137","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F128","v":{"$error":"#REF!"}},{"$f":"G128","v":{"$error":"#REF!"}},{"$f":"H128","v":{"$error":"#REF!"}}]
["Sub total",null,null,null,null,{"$f":"SUM(F137:F138)","v":{"$error":"#REF!"}},{"$f":"SUM(G137:G138)","v":{"$error":"#REF!"}},{"$f":"SUM(H137:H138)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H139/1000))/(4+SQRT(H139/1000))","v":{"$error":"#REF!"}},{"$f":"J128","v":99},{"$f":"G139*I139+J139","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B143*(B145^(2/3))*(B141^(1/2))","v":1.2116656026554116},"FT³/S"]
["Pipe Slope (S) (FT/FT)",0.01,"Design Flow",{"$f":"D140*60","v":72.699936159324693},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B140/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D141*7.481","v":543.86822240790798},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B142^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B142","v":2.0943951023931953},"Model Flow",{"$f":"K139","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B143/B144","v":0.16666666666666669},"Capacity",{"$f":"D144/D142","v":{"$error":"#REF!"}}]
[]
["MH 8482 to 8463","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Subdivision Ph I","Single Family Residential",13,{"$f":"VLOOKUP(B148,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B148,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C148*E148*D148","v":{"$error":"#REF!"}},{"$f":"F148/24/60","v":{"$error":"#REF!"}},{"$f":"D148*C148","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F139","v":{"$error":"#REF!"}},{"$f":"G139","v":{"$error":"#REF!"}},{"$f":"H139","v":{"$error":"#REF!"}}]
["Sub total",null,null,null,null,{"$f":"SUM(F148:F149)","v":{"$error":"#REF!"}},{"$f":"SUM(G148:G149)","v":{"$error":"#REF!"}},{"$f":"SUM(H148:H149)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H150/1000))/(4+SQRT(H150/1000))","v":{"$error":"#REF!"}},{"$f":"J139","v":99},{"$f":"G150*I150+J150","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B154*(B156^(2/3))*(B152^(1/2))","v":1.2297062814501885},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.03E-2,"Design Flow",{"$f":"D151*60","v":73.78237688701131},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B151/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D152*7.481","v":551.9659614917316},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B153^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B153","v":2.0943951023931953},"Model Flow",{"$f":"K150","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B154/B155","v":0.16666666666666669},"Capacity",{"$f":"D155/D153","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["MH 8463 to 8462","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Subdivision Ph I","Single Family Residential",3,{"$f":"VLOOKUP(B165,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B165,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C165*E165*D165","v":{"$error":"#REF!"}},{"$f":"F165/24/60","v":{"$error":"#REF!"}},{"$f":"D165*C165","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F150","v":{"$error":"#REF!"}},{"$f":"G150","v":{"$error":"#REF!"}},{"$f":"H150","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F165:F166)","v":{"$error":"#REF!"}},{"$f":"SUM(G165:G166)","v":{"$error":"#REF!"}},{"$f":"SUM(H165:H166)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H167/1000))/(4+SQRT(H167/1000))","v":{"$error":"#REF!"}},{"$f":"J150","v":99},{"$f":"G167*I167+J167","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B171*(B173^(2/3))*(B169^(1/2))","v":1.5571708686449306},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.9E-3,"Design Flow",{"$f":"D168*60","v":93.430252118695833},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B168/12)/2","v":0.5},"Design Flow",{"$f":"D169*7.481","v":698.95171609996351},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B170^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B170","v":3.1415926535897931},"Model Flow",{"$f":"K167","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B171/B172","v":0.25},"Capacity",{"$f":"D172/D170","v":{"$error":"#REF!"}}]
[]
["MH 8462 to 8261","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Subdivision Ph I","Single Family Residential",59,{"$f":"VLOOKUP(B176,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B176,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C176*E176*D176","v":{"$error":"#REF!"}},{"$f":"F176/24/60","v":{"$error":"#REF!"}},{"$f":"D176*C176","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F167","v":{"$error":"#REF!"}},{"$f":"G167","v":{"$error":"#REF!"}},{"$f":"H167","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F176:F177)","v":{"$error":"#REF!"}},{"$f":"SUM(G176:G177)","v":{"$error":"#REF!"}},{"$f":"SUM(H176:H177)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H178/1000))/(4+SQRT(H178/1000))","v":{"$error":"#REF!"}},{"$f":"J167","v":99},{"$f":"G178*I178+J178","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B182*(B184^(2/3))*(B180^(1/2))","v":1.5156388275300279},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.8E-3,"Design Flow",{"$f":"D179*60","v":90.938329651801666},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B179/12)/2","v":0.5},"Design Flow",{"$f":"D180*7.481","v":680.30964412512822},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B181^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B181","v":3.1415926535897931},"Model Flow",{"$f":"K178","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B182/B183","v":0.25},"Capacity",{"$f":"D183/D181","v":{"$error":"#REF!"}}]
[]
["MH 8461 to 8460","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Southview Subdivision Ph 1","Single Family Residential",50,{"$f":"VLOOKUP(B187,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B187,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C187*E187*D187","v":{"$error":"#REF!"}},{"$f":"F187/24/60","v":{"$error":"#REF!"}},{"$f":"D187*C187","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F178","v":{"$error":"#REF!"}},{"$f":"G178","v":{"$error":"#REF!"}},{"$f":"H178","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F187:F188)","v":{"$error":"#REF!"}},{"$f":"SUM(G187:G188)","v":{"$error":"#REF!"}},{"$f":"SUM(H187:H188)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H189/1000))/(4+SQRT(H189/1000))","v":{"$error":"#REF!"}},{"$f":"J178","v":99},{"$f":"G189*I189+J189","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B193*(B195^(2/3))*(B191^(1/2))","v":1.3835826247814635},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.5E-3,"Design Flow",{"$f":"D190*60","v":83.014957486887809},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B190/12)/2","v":0.5},"Design Flow",{"$f":"D191*7.481","v":621.03489695940766},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B192^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B192","v":3.1415926535897931},"Model Flow",{"$f":"K189","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B193/B194","v":0.25},"Capacity",{"$f":"D194/D192","v":{"$error":"#REF!"}}]
[]
["MH 8460 to 8459","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Lowell Estates Subdivision","Single Family Residential",5,{"$f":"VLOOKUP(B198,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B198,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C198*E198*D198","v":{"$error":"#REF!"}},{"$f":"F198/24/60","v":{"$error":"#REF!"}},{"$f":"D198*C198","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F189","v":{"$error":"#REF!"}},{"$f":"G189","v":{"$error":"#REF!"}},{"$f":"H189","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F198:F199)","v":{"$error":"#REF!"}},{"$f":"SUM(G198:G199)","v":{"$error":"#REF!"}},{"$f":"SUM(H198:H199)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H200/1000))/(4+SQRT(H200/1000))","v":{"$error":"#REF!"}},{"$f":"J189","v":99},{"$f":"G200*I200+J200","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B204*(B206^(2/3))*(B202^(1/2))","v":1.5571708686449306},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.9E-3,"Design Flow",{"$f":"D201*60","v":93.430252118695833},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B201/12)/2","v":0.5},"Design Flow",{"$f":"D202*7.481","v":698.95171609996351},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B203^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B203","v":3.1415926535897931},"Model Flow",{"$f":"K200","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B204/B205","v":0.25},"Capacity",{"$f":"D205/D203","v":{"$error":"#REF!"}}]
[]
["MH 8459 to 8450","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Lowell Estates Subdivision","Single Family Residential",9,{"$f":"VLOOKUP(B209,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B209,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C209*E209*D209","v":{"$error":"#REF!"}},{"$f":"F209/24/60","v":{"$error":"#REF!"}},{"$f":"D209*C209","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F200","v":{"$error":"#REF!"}},{"$f":"G200","v":{"$error":"#REF!"}},{"$f":"H200","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F209:F210)","v":{"$error":"#REF!"}},{"$f":"SUM(G209:G210)","v":{"$error":"#REF!"}},{"$f":"SUM(H209:H210)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H211/1000))/(4+SQRT(H211/1000))","v":{"$error":"#REF!"}},{"$f":"J200","v":99},{"$f":"G211*I211+J211","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B215*(B217^(2/3))*(B213^(1/2))","v":1.8562708808993627},"FT³/S"]
["Pipe Slope (S) (FT/FT)",2.7000000000000001E-3,"Design Flow",{"$f":"D212*60","v":111.37625285396176},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B212/12)/2","v":0.5},"Design Flow",{"$f":"D213*7.481","v":833.20574760048794},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B214^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B214","v":3.1415926535897931},"Model Flow",{"$f":"K211","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B215/B216","v":0.25},"Capacity",{"$f":"D216/D214","v":{"$error":"#REF!"}}]
[]
["MH 8450 to 8429","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Lowell Estates Subdivision","Single Family Residential",61,{"$f":"VLOOKUP(B220,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B220,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C220*E220*D220","v":{"$error":"#REF!"}},{"$f":"F220/24/60","v":{"$error":"#REF!"}},{"$f":"D220*C220","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F211","v":{"$error":"#REF!"}},{"$f":"G211","v":{"$error":"#REF!"}},{"$f":"H211","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F220:F221)","v":{"$error":"#REF!"}},{"$f":"SUM(G220:G221)","v":{"$error":"#REF!"}},{"$f":"SUM(H220:H221)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H222/1000))/(4+SQRT(H222/1000))","v":{"$error":"#REF!"}},{"$f":"J211","v":99},{"$f":"G222*I222+J222","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B226*(B228^(2/3))*(B224^(1/2))","v":1.5156388275300279},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.8E-3,"Design Flow",{"$f":"D223*60","v":90.938329651801666},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B223/12)/2","v":0.5},"Design Flow",{"$f":"D224*7.481","v":680.30964412512822},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B225^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B225","v":3.1415926535897931},"Model Flow",{"$f":"K222","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B226/B227","v":0.25},"Capacity",{"$f":"D227/D225","v":{"$error":"#REF!"}}]
[]
["MH 8429 to 8428","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Greene Acres/ Miller Addition","Single Family Residential",28,{"$f":"VLOOKUP(B231,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B231,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C231*E231*D231","v":{"$error":"#REF!"}},{"$f":"F231/24/60","v":{"$error":"#REF!"}},{"$f":"D231*C231","v":{"$error":"#REF!"}}]
[null,"Apartment",12,{"$f":"VLOOKUP(B232,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B232,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C232*E232*D232","v":{"$error":"#REF!"}},{"$f":"F232/24/60","v":{"$error":"#REF!"}},{"$f":"D232*C232","v":{"$error":"#REF!"}}]
[null,"Assembly Hall",82.5,{"$f":"VLOOKUP(B233,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B233,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C233*E233*D233","v":{"$error":"#REF!"}},{"$f":"F233/24/60","v":{"$error":"#REF!"}},{"$f":"D233*C233","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F222","v":{"$error":"#REF!"}},{"$f":"G222","v":{"$error":"#REF!"}},{"$f":"H222","v":{"$error":"#REF!"}}]
["Sub total",null,null,null,null,{"$f":"SUM(F231:F234)","v":{"$error":"#REF!"}},{"$f":"SUM(G231:G234)","v":{"$error":"#REF!"}},{"$f":"SUM(H231:H234)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H235/1000))/(4+SQRT(H235/1000))","v":{"$error":"#REF!"}},{"$f":"J222","v":99},{"$f":"G235*I235+J235","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B239*(B241^(2/3))*(B237^(1/2))","v":1.7861974879601847},"FT³/S"]
["Pipe Slope (S) (FT/FT)",2.5000000000000001E-3,"Design Flow",{"$f":"D236*60","v":107.17184927761109},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B236/12)/2","v":0.5},"Design Flow",{"$f":"D237*7.481","v":801.75260444580852},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B238^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B238","v":3.1415926535897931},"Model Flow",{"$f":"K235","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B239/B240","v":0.25},"Capacity",{"$f":"D240/D238","v":{"$error":"#REF!"}}]
[]
["MH 8428 to 8424","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Greene Acres","Single Family Residential",4,{"$f":"VLOOKUP(B244,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B244,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C244*E244*D244","v":{"$error":"#REF!"}},{"$f":"F244/24/60","v":{"$error":"#REF!"}},{"$f":"D244*C244","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F235","v":{"$error":"#REF!"}},{"$f":"G235","v":{"$error":"#REF!"}},{"$f":"H235","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F244:F245)","v":{"$error":"#REF!"}},{"$f":"SUM(G244:G245)","v":{"$error":"#REF!"}},{"$f":"SUM(H244:H245)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H246/1000))/(4+SQRT(H246/1000))","v":{"$error":"#REF!"}},{"$f":"J235","v":99},{"$f":"G246*I246+J246","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B250*(B252^(2/3))*(B248^(1/2))","v":3.0522556054017165},"FT³/S"]
["Pipe Slope (S) (FT/FT)",7.3000000000000001E-3,"Design Flow",{"$f":"D247*60","v":183.13533632410298},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B247/12)/2","v":0.5},"Design Flow",{"$f":"D248*7.481","v":1370.0354510406144},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B249^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B249","v":3.1415926535897931},"Model Flow",{"$f":"K246","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B250/B251","v":0.25},"Capacity",{"$f":"D251/D249","v":{"$error":"#REF!"}}]
[]
["MH 8424 to 8409","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Greene Acres","Single Family Residential",9,{"$f":"VLOOKUP(B255,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B255,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C255*E255*D255","v":{"$error":"#REF!"}},{"$f":"F255/24/60","v":{"$error":"#REF!"}},{"$f":"D255*C255","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F246","v":{"$error":"#REF!"}},{"$f":"G246","v":{"$error":"#REF!"}},{"$f":"H246","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F255:F256)","v":{"$error":"#REF!"}},{"$f":"SUM(G255:G256)","v":{"$error":"#REF!"}},{"$f":"SUM(H255:H256)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H257/1000))/(4+SQRT(H257/1000))","v":{"$error":"#REF!"}},{"$f":"J246","v":99},{"$f":"G257*I257+J257","v":{"$error":"#REF!"}}]
["Pipe Size (in)",12,"Design Flow",{"$f":"(1.49/0.013)*B261*(B263^(2/3))*(B259^(1/2))","v":3.1550538147399725},"FT³/S"]
["Pipe Slope (S) (FT/FT)",7.7999999999999996E-3,"Design Flow",{"$f":"D258*60","v":189.30322888439835},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B258/12)/2","v":0.5},"Design Flow",{"$f":"D259*7.481","v":1416.1774552841841},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B260^2","v":0.78539816339744828}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B260","v":3.1415926535897931},"Model Flow",{"$f":"K257","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B261/B262","v":0.25},"Capacity",{"$f":"D262/D260","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
["MH 8409 to 8335","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Greene Acres/ Miller Addition","Single Family Residential",28,{"$f":"VLOOKUP(B273,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B273,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C273*E273*D273","v":{"$error":"#REF!"}},{"$f":"F273/24/60","v":{"$error":"#REF!"}},{"$f":"D273*C273","v":{"$error":"#REF!"}}]
[null,"Office",11.25,{"$f":"VLOOKUP(B274,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B274,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C274*E274*D274","v":{"$error":"#REF!"}},{"$f":"F274/24/60","v":{"$error":"#REF!"}},{"$f":"D274*C274","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F257","v":{"$error":"#REF!"}},{"$f":"G257","v":{"$error":"#REF!"}},{"$f":"H257","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F273:F275)","v":{"$error":"#REF!"}},{"$f":"SUM(G273:G275)","v":{"$error":"#REF!"}},{"$f":"SUM(H273:H275)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H276/1000))/(4+SQRT(H276/1000))","v":{"$error":"#REF!"}},{"$f":"J257","v":99},{"$f":"G276*I276+J276","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B280*(B282^(2/3))*(B278^(1/2))","v":1.2600188027662167},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.0814053000000001E-2,"Design Flow",{"$f":"D277*60","v":75.601128165972995},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B277/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D278*7.481","v":565.57203980964391},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B279^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B279","v":2.0943951023931953},"Model Flow",{"$f":"K276","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B280/B281","v":0.16666666666666669},"Capacity",{"$f":"D281/D279","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"over 80"]
[]
["MH 8335 to 8336","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
[null,"Industrial",27.75,{"$f":"VLOOKUP(B285,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B285,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"C285*E285*D285","v":{"$error":"#REF!"}},{"$f":"F285/24/60","v":{"$error":"#REF!"}},{"$f":"D285*C285","v":{"$error":"#REF!"}}]
["Carry over from upstream",null,null,null,null,{"$f":"F276","v":{"$error":"#REF!"}},{"$f":"G276","v":{"$error":"#REF!"}},{"$f":"H276","v":{"$error":"#REF!"}}]
["Sub total",null,{"$f":"SUM(C285:C285)","v":27.75},null,null,{"$f":"SUM(F285:F286)","v":{"$error":"#REF!"}},{"$f":"SUM(G285:G286)","v":{"$error":"#REF!"}},{"$f":"SUM(H285:H286)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H287/1000))/(4+SQRT(H287/1000))","v":{"$error":"#REF!"}},{"$f":"J276","v":99},{"$f":"G287*I287+J287","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B291*(B293^(2/3))*(B289^(1/2))","v":1.4590385952244502},"FT³/S"]
["Pipe Slope (S) (FT/FT)",1.4500000000000001E-2,"Design Flow",{"$f":"D288*60","v":87.542315713467019},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B288/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D289*7.481","v":654.90406385244671},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B290^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B290","v":2.0943951023931953},"Model Flow",{"$f":"K287","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B291/B292","v":0.16666666666666669},"Capacity",{"$f":"D292/D290","v":{"$error":"#REF!"}}]
[]
["MH 8366 to NEW PUPPY CREEK INTERCEPTOR","Type","Units","Capacity/unit","gdp/cap","gal/day","Avg. Flow (gpm)","Population","Peaking Factor","Lift Station Flow (gpm)","Calc. Peak (gpm)"]
["Carry over from upstream",null,null,null,null,{"$f":"F287","v":{"$error":"#REF!"}},{"$f":"G287","v":{"$error":"#REF!"}},{"$f":"H287","v":{"$error":"#REF!"}}]
["Sub total",null,0,null,null,{"$f":"SUM(F296:F296)","v":{"$error":"#REF!"}},{"$f":"SUM(G296:G296)","v":{"$error":"#REF!"}},{"$f":"SUM(H296:H296)","v":{"$error":"#REF!"}},{"$f":"(18+SQRT(H297/1000))/(4+SQRT(H297/1000))","v":{"$error":"#REF!"}},{"$f":"J287","v":99},{"$f":"G297*I297+J297","v":{"$error":"#REF!"}}]
["Pipe Size (in)",8,"Design Flow",{"$f":"(1.49/0.013)*B301*(B303^(2/3))*(B299^(1/2))","v":2.2700547789933703},"FT³/S"]
["Pipe Slope (S) (FT/FT)",3.5099999999999999E-2,"Design Flow",{"$f":"D298*60","v":136.20328673960222},"FT³/MIN"]
["Pipe Radius ",{"$f":"(B298/12)/2","v":0.33333333333333331},"Design Flow",{"$f":"D299*7.481","v":1018.9367880989641},"GAL/MIN"]
["Full Area (Afull = π*r²)",{"$f":"PI()*B300^2","v":0.3490658503988659}]
["Wetted Perimeter (P = 2*π*r)",{"$f":"2*PI()*B300","v":2.0943951023931953},"Model Flow",{"$f":"K297","v":{"$error":"#REF!"}},"GAL/MIN"]
["Hydraulic Radius (R = A/P)",{"$f":"B301/B302","v":0.16666666666666669},"Capacity",{"$f":"D302/D300","v":{"$error":"#REF!"}}]