Utility Pump Station Design Spreadsheet 2w221t
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3b7i
Overview 3e4r5l
& View Utility Pump Station Design Spreadsheet as PDF for free.
More details w3441
- Words: 3,017
- Pages: 16
Spreadsheet Instructions This spreadsheet is to be used as a tool for design engineers to design pump station and force main systems to connect to the Brunswick County Collection System. The use of this spreadsheet does not relieve the design engineer of the responsibility of ing the results of the spreadsheet and taking into conditions which may not be General: ed for with the spreadsheet. Should such conditions which are not ed for in this spreadsheet be present, the designer should the Brunswick County Engineering Department prior to submittal. Data should only be entered into shaded cells. entered data will be linked to calculations in subsequent sheets as required. Warnings and approval messages appear behind Bold & Italicized text. Begin with the "Tributary Flow Calculations" tab. Insert the number of applicable units corresponding to the 1
description in the Establishment column. Add additional flow generating establishments as required which are not included in the list. The flow generated by these units is subject to Brunswick County approval. Move to the "Design Pumping Flow Rate" tab. The Minimum Pumping Rate Required is calculated. The designer
2
should enter the desired Design Pumping Rate in the shaded cell. The Design Pumping Rate should not be less than the Minimum Pumping Rate Required. Additional pumping capacity may be beneficial to allow for non-clog pumps, larger force main diameters, etc. Move to the "Cycle Time & Wet Well Geometry" tab. Input the target cycles per hour in the Target Cycles per Hour box. Pick a Wet Well Diameter and Wet Well Cycle in the "Determine Wet well Diameter" box. The Volume in Cycle
3
value should closely match the Required Volume value. If not, adjust desired Cycles Per Hour, Wet Well Diameter, and Wet Well Cycle values. Note: Wet well diameter to be standard precast wet well inside diameter. Submit manufacturer's cut sheet of proposed wet well.
4
Input the Vertical Datum to which the elevations to be provided correspond. Input the existing Ground Elevation and the Sanitary Sewer Invert In elevation. Do not enter the Bottom Invert
5
Elevation until the specific pump has been determined in instruction item #11. The vertical distance between Pump Off and Bottom Invert Elev shall provide for complete pump submergance, and not be less than 4'. Move to the "Force Main & Piping Design" tab. Input the proposed force main diameter. Resultant velocity should be
6
between 2-5 fps. Check for warnings below the velocity line. Enter the length of force main from the downstream connection point to the transition at the valve vault piping.
7
Enter the Connection Point in the shaded box. Example Values are as follows: Existing 12" FM at Mt. Misery Rd & Cedar Hill Rd, Existing MH at Hwy 17 & Holden Beach Rd., etc. Select Valve Vault and Wet Well Piping Size. This piping may be slightly smaller than the Off-Site Force Main. Enter
8
the appropriate quantity of fittings and the total length of pipe the flow travels through from one pump until transiting to the larger off-site force main diameter, or leaving the valve vault (if Pump Station Piping and Off-Site Force Main are same diameter). Add additonal fittings and associated L/D values as required.
Spreadsheet Instructions Enter data provided by Brunswick County in the GPM , Pressure Head at Connection Condition "All Pumps On" , and Pressure Head at Connection Condition "Only Proposed Pump On" columns. The Engineer shall determine the appropriate value to input into the “Static Head” column from either 1) the “Connection Point Elevation” minus the wetwell “Pump Off” elevation or 2) the Force Main High Point elevation minus the wetwell “Pump Off” elevation. Option #2 is appropriate when the High Point Elevation exceeds the Hydraulic Grade Line elevation at the location of the proposed force main High Point. As a quick check to see if option #2 needs further investigation, sum the 9
“Pressure Head at Connection” and the “Connection Point Elevation” to calculate the Connection Point Hydraulic Grade Line for both the “All On” and “Only Proposed Pump Station On” scenarios. If the Connection Point Hydraulic Grade Line exceeds the High Point Elevation for both conditions then option #1 is the appropriate choice for determining the static head. If static head is determined by option 2 for any condition, the designer shall indicate the flow rate above which static head as defined by option 1 is the approperate value. Select a pump that can provide the “Minimum Required Pumping Rate” at the head in the column "’All On TDH”. Check to ensure the proposed pump will also provided the Design Flow Rate at the head in column "’All Off TDH”. Use the graph provided on the "System Curve" tab to aid in determining operating points. All pumps should be nonoverloading at the impeller diameter chosen. Note: If the proposed force main discharges to a non-pressurized point such as a gravity manhole or to a WWTP outfall, or option 2 above governs static head, the values for both “Pressure Head at Connection” columns will be 0.” Note: Velocity Head is not included in spreadsheet calculation due to neglidgeable value for normal force main operating velocities. Enter specific pump information in the shaded areas. Attached manufacturer's cut sheet. Move to "Cycle Time & Wet
10
Well Geometry" tab and enter Wet Well Invert Elevation based on the depth required to provide complete submergence for the specific pump chosen.
11
Move to the "Operational Check" tab. The operational points entered should be points on the pump curve that intercept the system curves. Check for Warnings in Red at the bottom of the page. If both read OK, then the pump and force main design can be
12
submitted to Brunswick County for review. If warnings are present adjust previously entered values as required to obtain a cycle time between 2-8 cycles per hour. Values which can affect cycle time include: wet well diameter, wet well cycle, pump selection, etc. Move to the "Buoyancy Calculations" tab. Input the outside diameter of the wet well, diameter of the extended base,
13
extended base slab thickness, and top slab thickness in appropriate shaded boxes. Provided manufacturer's cut sheet to dimensions.
14
15
16
Enter the Saturated unit weight of soil. Use 50 pcf for the submerged unit weigh of soil unless geotechnical investigations justify greater values. Attach ing geotechnical information if applicable. If Wet Well ballast is required as indicated on the last box on the sheet submit proposed concrete anchor design for approval. Once the design of the pump station and force main is complete, move to the "Cover & Summary" tab. Input the project specific data as required. Note these cells are not shaded.
Brunswick County Wastewater Pump Station & Force Main Design Calculations
Project Name: Location: Designed By: Checked By: Date: Project no.:
Brunswick County Wastewater Pump Station & Force Main Project Summary
Project Name: Average Daily Flow (gpm): Pump Operational Point No. 1 (gpm@tdh): Pump Operational Point, No. 2 (gpm@tdh): Pump Manufacturer: Model Number: Impeller Diameter: Horse Power: Voltage: Force Main Diameter (in): Force Main Length (ft):
Tributary Wastewater Flow Calculations Unit Value (Gal/Day/Unit)
Unit Type
# of Units
Residential (To NEWWTF)
360
Residence
500
Residential (all other Treatment Facilities)
210
Residence
0
Barber Shops
50
Chair
0
Beauty Shops
125
Booth or Bowl
5
Business - General & Office
25
Employee per shift
100
Business - Factories Excluding Industrial Waste
25
Employee per shift
0
Business or Factories w/showers or food preparation
35
Employee per shift
0
Business - Warehouse
100
Loading bay
0
Business - Warehouse Self Storage (not including Caretaker Residence)
1
Unit
0
Churches without kitchens, day care, or camps
3
Seat
0
Churches with kitchens
5
Seat
0
Churches providing day care or camp
25
Person (child+employee)
0
Fire or Rescue without on-site staff
25
Person
0
Fire or Rescue with on-site staff
50
Person per shift
0
Food & Drink - Banquet Dining Hall
30
Seat
100
Food & Drink - Bars, Cocktail Lounges
20
Seat
0
Food & Drink - Caterers
50
100 sf floor space
0
Food & Drink - Restaurants, Full Service
40
Seat
0
Food & Drink - Restaurants, Single Service Articles
20
Seat
0
Food & Drink - Restaurants, Drive-in
50
car space
0
Food & Drink - Restaurants, Carry out only
50
100 sf floor space
10
Food & Drink - Institutions, Dining Halls
5
meal
0
Food & Drink - Deli
40
100 sf floor space
0
Food & Drink - Bakery
10
100 sf floor space
0
Food & Drink - Meat Dept., Butcher, Fish Market
75
100 sf floor space
0
Food & Drink - Specialty Food Stand or Kiosk
50
100 sf floor space
0
Hotels/Motels/B&B without in-room cooking facilities
120
Room
0
Hotels/Motels/B&B with in-room cooking facilities
175
Room
0
Hotels/Motels- Resort Hotels
200
Room
0
Hotels/Motels- Cottages, Cabins
200
Unit
0
Laundries (Self-Service)
500
Machine
0
Medical or Dental offices
250
Practitioner per shift
0
Medical - Veterinary offices without boarding
250
Practitioner per shift
0
Medical - Veterinary, Kennels, with boarding
20
Pen, Cage, Kennel, Stall
0
Medical - Medical Hospitals
300
Bed
0
Medical - Mental Hospitals
150
Bed
0
Medical - Convalescent, Nursing, Rest Homes without Laundry
60
Bed
0
Medical - Convalescent, Nursing, Rest Homes w/ Laundry
120
Bed
0
Medical - Residential Care Facilities
60
Person
0
Parks & Rec. - Campgrounds w/comfort station but without water & sewer hookup
75
Campsite
0
Parks & Rec. - Campgrounds with water & sewer hookup
100
Campsite
0
Parks & Rec. - Campground Dump Station facility
50
Space
0
Parks & Rec. - Construction, Hunting, or Work camps with flush toilets
60
Person
0
Parks & Rec. - Construction, Hunting, or Work camps with chemical or portable toilets
40
Person
0
Parks & Rec. - Parks with Restrooms
250
Plumbing Fixture
0
Parks & Rec. - Summer camps without food prep or laundry facilitates
30
Person
0
Parks & Rec. - Summer camps with food prep and laundry facilitates
60
Person
0
Parks & Rec. - Swimming Pools, Bath Houses, Spas
10
Person
368
Public Access Restrooms
325
Plumbing Fixture
0
Establishment
Tributary Wastewater Flow Calculations Unit Value (Gal/Day/Unit)
Unit Type
# of Units
Schools - Preschools & Daycares
25
Person (child+employee)
0
Schools with Cafeteria, Gym, & Showers
15
Student
0
Schools with Cafeteria
12
Student
1000
Schools without Cafeteria, Gym, & Showers
10
Student
0
Schools, Boarding
60
Person (student+employee)
0
Service Stations, Gas Stations
250
Plumbing Fixture
0
Car Wash Facilities (if recycling water, see Rule .0235 of 2T regulations)
Establishment
1200
Bay
0
Sports Centers - Bowling
50
Lane
0
Sports Centers - Fitness, Exercise, Karate, Dance
50
100 sf floor space
0
Sports Centers - Tennis, Racquet ball
50
court
0
Sports Centers - Gymnasium
50
100 sf floor space
0
Sports Centers - Golf Course with only minimal food service
250
Plumbing Fixture
0
Sports Centers - Country Clubs
60
Member or Patron
0
Sports Centers - Mini Golf, Putt-Putt
250
Plumbing Fixture
0
Sports Centers - Go-Kart, Motorcross
250
Plumbing Fixture
0
Sports Centers - Batting Cages, Driving Ranges
250
Plumbing Fixture
0
Sports Centers - Marinas without Bathhouse
10
Slip
0
Sports Centers - Marinas with Bathhouse
30
Slip
0
Sports Centers - Video Game Arcades, Pool Halls
250
Plumbing Fixture
0
5
Seat
0
Stadiums, Auditoriums, Theatres, Community Centers Stores, Shopping Centers, Malls & Flea Markets: Auto, Boat, RV dealerships/showrooms with restrooms
125
Plumbing Fixture
0
Convenience Stores, with Food Preparation
60
100 sf floor space
0
Convenience Stores, without Food Preparation
250
Plumbing Fixture
0
Flea Markets
30
Stall
0
Shopping Centers and Malls with Food Service
130
1000 sf
0
Stores and Shopping Centers without Food Service
100
1000 sf
0
5
enger
0
Transportation Terminals - Air, Bus, Train, Ferry, Port & Dock Other Other Other Other -
From 15A NCAC 02T .0114
Average Daily Flow (gallons per day)
Tributary astewater Flow Calculations Discharge, GPD 180,000 0 0 625 2,500 0 0 0 0 0 0 0 0 0 3,000 0 0 0 0 0 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3,680 0
Tributary astewater Flow Calculations Discharge, GPD 0 0 12,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
202,305
Design Pumping Flow Rate
Peaking Factor Calculation Service Area Population = Peak Factor =
100,000 18 + √P 4 + √P
Calculated Peak Factor = Design Peak Factor =
2.0 2.5
Determine Minimum Pump Rate Average Daily Flow = Peak Flow =
202,305 GPD 505763
GPD
Minimum Pumping Rate Required =
351
GPM
Design Pumping Rate =
575
GPM
Cycle Time & Wet Well Geometry Target Cycles Per Hour ADF
=
140 gpm
Pumping Rate
=
575 gpm
Time
=
15.0 min.
Cycles Per Hour =
4.0
Check Cycles Per Hour:
OK
Check Cycles Per Hour:
OK
Determine Wet well Diameter Required Volume =
1592
Gallons
Pick Wet Well Diameter =
8.0
Ft
Pick Wet Well Cycle =
4.0
Vert. Ft
1504
Gallons
Volume in Cycle =
Vertical Datum Used: NAVD 88
Determine Wet Well Invert & Float Elevations Wet well Dia. = Top Elev=
50.50
Gnd Elev=
50.00
SS Invert In=
42.00
8.0
Ft
Alarm =
37.00
Lag On = 36.00 Lead On = 35.00 Pumps Off 31.00 =
Bottom Invert Elev* = 27.00 *As required for complete submergence OK
Force Main & Piping Design Off-Site Force Main Data Design Pump Rate (gpm) =
575
Select Force Main Size (in) =
8
Velocity (fps) =
3.67
Meets Minimum Velocity Requirement? OK Meets Maximum Velocity Requirement? OK Required Pump? Use Non-Clog Pump Line Length (ft) = for Minor Losses = Equiv Length (ft) =
10,320 5% 10,325
Connection Point: 24" Force Main @ North Brunswick WWTP Pump Station Piping Data Design Pump Rate (gpm) = Pick Wet Well & Valve Vault Piping Size (in) = Velocity (fps) =
Item 45 bend 90 bend 22.5 bend Branch Tee Flow Check valve Plug Valve
575 6 6.52
Meets Minimum Velocity Requirement?
OK > 2 FPS
Meets Maximum Velocity Requirement?
OK < 8 FPS
Number of Fittings
L/D Ratio
0 2 1 1 1 1
16 30 9 60 135 17
Equivalent Fitting Length (ft) = Wet Well & Valve Vault Piping Length (ft) = Total Equivalent Pump Station Pipe Length (ft) = Equivalent Off-Site Diameter Length (ft) = Total Equivalent Force Main Length (ft) =
Equivalent Length 0.00 30.00 4.50 30.00 67.50 8.50 0.00 0.00 0.00 141 20 161 651 10976
Pump Selection
GPM
Force Main Diameter (in) =
8
Equivalent Force Main Length (ft) =
10976
Hazen-Williams C Factor = Minimum Required Pump Rate (GPM) =
130 351
Design Pumping Rate (GPM) =
575
Pressure Head at Connection Pressure Head "Only Proposed at Connection Pump Station "All On" On"
100 300 600 900 1200
14 16.6 20.8 25.5 30.5
0 0.4 1.4 2.9 5
Pump Manufacturer: Flygt Model Number: NP 3171 SH 63-275-00-1070 Impeller Diameter: 195 mm Horsepower: 35 Voltage: 460v 3phase
Static Head
"All On" TDH
"Only Proposed Pump Station On" TDH
20 20 20 0 0
37 58 119 191 313
23 42 100 169 287
Velocity (fps)
Pump Head
0.6 1.9 3.8 5.7 7.7
245 197 135 74
Pump and Force Main System Curve 350
300
TDH (FT)
250
200
Pump Head All On System TDH All Off System TDH
150
100
50
0 0
200
400
600
800
1000
1200
1400
Flow (GPM)
Pg. 8
Station Operation Check
Proposed Operational Point No.1 600 GPM @ 135
TDH
Check Wet well Cycle Times Wet well Diameter (feet)
Wet well Area (gal / VF)
8.0
376
4.0
1503
Wet well Volume
=
10.7
minutes
=
3.3
minutes
Fill =
Wet well Wet well Cycle Volume (ft) (gal)
ADF Run =
Wet well Volume Pump Rate - ADF
Total = 14.0 Cycle Time = 4.3 Meets Minimum Cycle Time? OK Meets Maximum Cycle Time? OK
minutes Cycles / Hour
Station Operation Check
Proposed Operational Point No. 2 640 GPM @ 125
TDH
Check Wet well Cycle Times Wet well Diameter (feet)
Wet well Area (gal / VF)
8.0
376
4.0
1503
Wet well Volume
=
10.7
minutes
=
3.0
minutes
Fill =
Wet well Wet well Cycle Volume (ft) (gal)
ADF Run =
Wet well Volume Pump Rate - ADF
Total = 13.7 Cycle Time = 4.4 Meets Minimum Cycle Time? OK Meets Maximum Cycle Time? OK
minutes Cycles / Hour
Buoyancy Calculations Wet well Outside Dimensions Wet well Inside Dimensions Wet well Top Slab Elevation Wet well Invert Elevation Extended Base Slab Diameter Extended Base Slab Thickness Top Slab Thickness
9.00 8.00 50.50 27.00 11.00 1.00 0.50
Feet Feet Feet Feet Feet Feet Feet
Calculate Total Volume of Wet well Structure Volume of Wet well Riser Sections= Volume of Wet well Extended Base= Total Volume of Wet well Structure=
1494 95 1589
cf cf cf
Calculate Total Volume of Water Displaced H20 Displaced = (Volume of Wet well Structure) * (62.4 lbs/cf) H20 Displaced= 99168 lbs Calculate Submerged Weight of Wet well Components Section Top Slab Thickness (ft.) Riser - Total Vertical Ft. Base Slab Thickness (ft.) Totals= Total Weight of Concrete in Wet well=
Total Ht 0.50 23.50 1.00
Weight 2786 27486 8325
25
38597
38597
lbs.
Calculate Weight of Soil Above Extended Base/Footing Total Area of Extended Base Total Area of Wet well Riser Area of Extended Base less Wet well Height of Soil Above Extended Base Volume of Soil Above Extended Base Weight of Soil Above Extended Base (estimated) Total Weight of Soil Above Extended Base
95 64 31 23 723 50 36128
sf sf sf ft cf lbs/cf lbs/cf
Flotation Protection Required? Weight of Concrete and Weight of Soil Above Extended Base: Weight of Water Displaced By Wet Well: Flotation Protection Required?
74726 lbs 99168 lbs YES
description in the Establishment column. Add additional flow generating establishments as required which are not included in the list. The flow generated by these units is subject to Brunswick County approval. Move to the "Design Pumping Flow Rate" tab. The Minimum Pumping Rate Required is calculated. The designer
2
should enter the desired Design Pumping Rate in the shaded cell. The Design Pumping Rate should not be less than the Minimum Pumping Rate Required. Additional pumping capacity may be beneficial to allow for non-clog pumps, larger force main diameters, etc. Move to the "Cycle Time & Wet Well Geometry" tab. Input the target cycles per hour in the Target Cycles per Hour box. Pick a Wet Well Diameter and Wet Well Cycle in the "Determine Wet well Diameter" box. The Volume in Cycle
3
value should closely match the Required Volume value. If not, adjust desired Cycles Per Hour, Wet Well Diameter, and Wet Well Cycle values. Note: Wet well diameter to be standard precast wet well inside diameter. Submit manufacturer's cut sheet of proposed wet well.
4
Input the Vertical Datum to which the elevations to be provided correspond. Input the existing Ground Elevation and the Sanitary Sewer Invert In elevation. Do not enter the Bottom Invert
5
Elevation until the specific pump has been determined in instruction item #11. The vertical distance between Pump Off and Bottom Invert Elev shall provide for complete pump submergance, and not be less than 4'. Move to the "Force Main & Piping Design" tab. Input the proposed force main diameter. Resultant velocity should be
6
between 2-5 fps. Check for warnings below the velocity line. Enter the length of force main from the downstream connection point to the transition at the valve vault piping.
7
Enter the Connection Point in the shaded box. Example Values are as follows: Existing 12" FM at Mt. Misery Rd & Cedar Hill Rd, Existing MH at Hwy 17 & Holden Beach Rd., etc. Select Valve Vault and Wet Well Piping Size. This piping may be slightly smaller than the Off-Site Force Main. Enter
8
the appropriate quantity of fittings and the total length of pipe the flow travels through from one pump until transiting to the larger off-site force main diameter, or leaving the valve vault (if Pump Station Piping and Off-Site Force Main are same diameter). Add additonal fittings and associated L/D values as required.
Spreadsheet Instructions Enter data provided by Brunswick County in the GPM , Pressure Head at Connection Condition "All Pumps On" , and Pressure Head at Connection Condition "Only Proposed Pump On" columns. The Engineer shall determine the appropriate value to input into the “Static Head” column from either 1) the “Connection Point Elevation” minus the wetwell “Pump Off” elevation or 2) the Force Main High Point elevation minus the wetwell “Pump Off” elevation. Option #2 is appropriate when the High Point Elevation exceeds the Hydraulic Grade Line elevation at the location of the proposed force main High Point. As a quick check to see if option #2 needs further investigation, sum the 9
“Pressure Head at Connection” and the “Connection Point Elevation” to calculate the Connection Point Hydraulic Grade Line for both the “All On” and “Only Proposed Pump Station On” scenarios. If the Connection Point Hydraulic Grade Line exceeds the High Point Elevation for both conditions then option #1 is the appropriate choice for determining the static head. If static head is determined by option 2 for any condition, the designer shall indicate the flow rate above which static head as defined by option 1 is the approperate value. Select a pump that can provide the “Minimum Required Pumping Rate” at the head in the column "’All On TDH”. Check to ensure the proposed pump will also provided the Design Flow Rate at the head in column "’All Off TDH”. Use the graph provided on the "System Curve" tab to aid in determining operating points. All pumps should be nonoverloading at the impeller diameter chosen. Note: If the proposed force main discharges to a non-pressurized point such as a gravity manhole or to a WWTP outfall, or option 2 above governs static head, the values for both “Pressure Head at Connection” columns will be 0.” Note: Velocity Head is not included in spreadsheet calculation due to neglidgeable value for normal force main operating velocities. Enter specific pump information in the shaded areas. Attached manufacturer's cut sheet. Move to "Cycle Time & Wet
10
Well Geometry" tab and enter Wet Well Invert Elevation based on the depth required to provide complete submergence for the specific pump chosen.
11
Move to the "Operational Check" tab. The operational points entered should be points on the pump curve that intercept the system curves. Check for Warnings in Red at the bottom of the page. If both read OK, then the pump and force main design can be
12
submitted to Brunswick County for review. If warnings are present adjust previously entered values as required to obtain a cycle time between 2-8 cycles per hour. Values which can affect cycle time include: wet well diameter, wet well cycle, pump selection, etc. Move to the "Buoyancy Calculations" tab. Input the outside diameter of the wet well, diameter of the extended base,
13
extended base slab thickness, and top slab thickness in appropriate shaded boxes. Provided manufacturer's cut sheet to dimensions.
14
15
16
Enter the Saturated unit weight of soil. Use 50 pcf for the submerged unit weigh of soil unless geotechnical investigations justify greater values. Attach ing geotechnical information if applicable. If Wet Well ballast is required as indicated on the last box on the sheet submit proposed concrete anchor design for approval. Once the design of the pump station and force main is complete, move to the "Cover & Summary" tab. Input the project specific data as required. Note these cells are not shaded.
Brunswick County Wastewater Pump Station & Force Main Design Calculations
Project Name: Location: Designed By: Checked By: Date: Project no.:
Brunswick County Wastewater Pump Station & Force Main Project Summary
Project Name: Average Daily Flow (gpm): Pump Operational Point No. 1 (gpm@tdh): Pump Operational Point, No. 2 (gpm@tdh): Pump Manufacturer: Model Number: Impeller Diameter: Horse Power: Voltage: Force Main Diameter (in): Force Main Length (ft):
Tributary Wastewater Flow Calculations Unit Value (Gal/Day/Unit)
Unit Type
# of Units
Residential (To NEWWTF)
360
Residence
500
Residential (all other Treatment Facilities)
210
Residence
0
Barber Shops
50
Chair
0
Beauty Shops
125
Booth or Bowl
5
Business - General & Office
25
Employee per shift
100
Business - Factories Excluding Industrial Waste
25
Employee per shift
0
Business or Factories w/showers or food preparation
35
Employee per shift
0
Business - Warehouse
100
Loading bay
0
Business - Warehouse Self Storage (not including Caretaker Residence)
1
Unit
0
Churches without kitchens, day care, or camps
3
Seat
0
Churches with kitchens
5
Seat
0
Churches providing day care or camp
25
Person (child+employee)
0
Fire or Rescue without on-site staff
25
Person
0
Fire or Rescue with on-site staff
50
Person per shift
0
Food & Drink - Banquet Dining Hall
30
Seat
100
Food & Drink - Bars, Cocktail Lounges
20
Seat
0
Food & Drink - Caterers
50
100 sf floor space
0
Food & Drink - Restaurants, Full Service
40
Seat
0
Food & Drink - Restaurants, Single Service Articles
20
Seat
0
Food & Drink - Restaurants, Drive-in
50
car space
0
Food & Drink - Restaurants, Carry out only
50
100 sf floor space
10
Food & Drink - Institutions, Dining Halls
5
meal
0
Food & Drink - Deli
40
100 sf floor space
0
Food & Drink - Bakery
10
100 sf floor space
0
Food & Drink - Meat Dept., Butcher, Fish Market
75
100 sf floor space
0
Food & Drink - Specialty Food Stand or Kiosk
50
100 sf floor space
0
Hotels/Motels/B&B without in-room cooking facilities
120
Room
0
Hotels/Motels/B&B with in-room cooking facilities
175
Room
0
Hotels/Motels- Resort Hotels
200
Room
0
Hotels/Motels- Cottages, Cabins
200
Unit
0
Laundries (Self-Service)
500
Machine
0
Medical or Dental offices
250
Practitioner per shift
0
Medical - Veterinary offices without boarding
250
Practitioner per shift
0
Medical - Veterinary, Kennels, with boarding
20
Pen, Cage, Kennel, Stall
0
Medical - Medical Hospitals
300
Bed
0
Medical - Mental Hospitals
150
Bed
0
Medical - Convalescent, Nursing, Rest Homes without Laundry
60
Bed
0
Medical - Convalescent, Nursing, Rest Homes w/ Laundry
120
Bed
0
Medical - Residential Care Facilities
60
Person
0
Parks & Rec. - Campgrounds w/comfort station but without water & sewer hookup
75
Campsite
0
Parks & Rec. - Campgrounds with water & sewer hookup
100
Campsite
0
Parks & Rec. - Campground Dump Station facility
50
Space
0
Parks & Rec. - Construction, Hunting, or Work camps with flush toilets
60
Person
0
Parks & Rec. - Construction, Hunting, or Work camps with chemical or portable toilets
40
Person
0
Parks & Rec. - Parks with Restrooms
250
Plumbing Fixture
0
Parks & Rec. - Summer camps without food prep or laundry facilitates
30
Person
0
Parks & Rec. - Summer camps with food prep and laundry facilitates
60
Person
0
Parks & Rec. - Swimming Pools, Bath Houses, Spas
10
Person
368
Public Access Restrooms
325
Plumbing Fixture
0
Establishment
Tributary Wastewater Flow Calculations Unit Value (Gal/Day/Unit)
Unit Type
# of Units
Schools - Preschools & Daycares
25
Person (child+employee)
0
Schools with Cafeteria, Gym, & Showers
15
Student
0
Schools with Cafeteria
12
Student
1000
Schools without Cafeteria, Gym, & Showers
10
Student
0
Schools, Boarding
60
Person (student+employee)
0
Service Stations, Gas Stations
250
Plumbing Fixture
0
Car Wash Facilities (if recycling water, see Rule .0235 of 2T regulations)
Establishment
1200
Bay
0
Sports Centers - Bowling
50
Lane
0
Sports Centers - Fitness, Exercise, Karate, Dance
50
100 sf floor space
0
Sports Centers - Tennis, Racquet ball
50
court
0
Sports Centers - Gymnasium
50
100 sf floor space
0
Sports Centers - Golf Course with only minimal food service
250
Plumbing Fixture
0
Sports Centers - Country Clubs
60
Member or Patron
0
Sports Centers - Mini Golf, Putt-Putt
250
Plumbing Fixture
0
Sports Centers - Go-Kart, Motorcross
250
Plumbing Fixture
0
Sports Centers - Batting Cages, Driving Ranges
250
Plumbing Fixture
0
Sports Centers - Marinas without Bathhouse
10
Slip
0
Sports Centers - Marinas with Bathhouse
30
Slip
0
Sports Centers - Video Game Arcades, Pool Halls
250
Plumbing Fixture
0
5
Seat
0
Stadiums, Auditoriums, Theatres, Community Centers Stores, Shopping Centers, Malls & Flea Markets: Auto, Boat, RV dealerships/showrooms with restrooms
125
Plumbing Fixture
0
Convenience Stores, with Food Preparation
60
100 sf floor space
0
Convenience Stores, without Food Preparation
250
Plumbing Fixture
0
Flea Markets
30
Stall
0
Shopping Centers and Malls with Food Service
130
1000 sf
0
Stores and Shopping Centers without Food Service
100
1000 sf
0
5
enger
0
Transportation Terminals - Air, Bus, Train, Ferry, Port & Dock Other Other Other Other -
From 15A NCAC 02T .0114
Average Daily Flow (gallons per day)
Tributary astewater Flow Calculations Discharge, GPD 180,000 0 0 625 2,500 0 0 0 0 0 0 0 0 0 3,000 0 0 0 0 0 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3,680 0
Tributary astewater Flow Calculations Discharge, GPD 0 0 12,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
202,305
Design Pumping Flow Rate
Peaking Factor Calculation Service Area Population = Peak Factor =
100,000 18 + √P 4 + √P
Calculated Peak Factor = Design Peak Factor =
2.0 2.5
Determine Minimum Pump Rate Average Daily Flow = Peak Flow =
202,305 GPD 505763
GPD
Minimum Pumping Rate Required =
351
GPM
Design Pumping Rate =
575
GPM
Cycle Time & Wet Well Geometry Target Cycles Per Hour ADF
=
140 gpm
Pumping Rate
=
575 gpm
Time
=
15.0 min.
Cycles Per Hour =
4.0
Check Cycles Per Hour:
OK
Check Cycles Per Hour:
OK
Determine Wet well Diameter Required Volume =
1592
Gallons
Pick Wet Well Diameter =
8.0
Ft
Pick Wet Well Cycle =
4.0
Vert. Ft
1504
Gallons
Volume in Cycle =
Vertical Datum Used: NAVD 88
Determine Wet Well Invert & Float Elevations Wet well Dia. = Top Elev=
50.50
Gnd Elev=
50.00
SS Invert In=
42.00
8.0
Ft
Alarm =
37.00
Lag On = 36.00 Lead On = 35.00 Pumps Off 31.00 =
Bottom Invert Elev* = 27.00 *As required for complete submergence OK
Force Main & Piping Design Off-Site Force Main Data Design Pump Rate (gpm) =
575
Select Force Main Size (in) =
8
Velocity (fps) =
3.67
Meets Minimum Velocity Requirement? OK Meets Maximum Velocity Requirement? OK Required Pump? Use Non-Clog Pump Line Length (ft) = for Minor Losses = Equiv Length (ft) =
10,320 5% 10,325
Connection Point: 24" Force Main @ North Brunswick WWTP Pump Station Piping Data Design Pump Rate (gpm) = Pick Wet Well & Valve Vault Piping Size (in) = Velocity (fps) =
Item 45 bend 90 bend 22.5 bend Branch Tee Flow Check valve Plug Valve
575 6 6.52
Meets Minimum Velocity Requirement?
OK > 2 FPS
Meets Maximum Velocity Requirement?
OK < 8 FPS
Number of Fittings
L/D Ratio
0 2 1 1 1 1
16 30 9 60 135 17
Equivalent Fitting Length (ft) = Wet Well & Valve Vault Piping Length (ft) = Total Equivalent Pump Station Pipe Length (ft) = Equivalent Off-Site Diameter Length (ft) = Total Equivalent Force Main Length (ft) =
Equivalent Length 0.00 30.00 4.50 30.00 67.50 8.50 0.00 0.00 0.00 141 20 161 651 10976
Pump Selection
GPM
Force Main Diameter (in) =
8
Equivalent Force Main Length (ft) =
10976
Hazen-Williams C Factor = Minimum Required Pump Rate (GPM) =
130 351
Design Pumping Rate (GPM) =
575
Pressure Head at Connection Pressure Head "Only Proposed at Connection Pump Station "All On" On"
100 300 600 900 1200
14 16.6 20.8 25.5 30.5
0 0.4 1.4 2.9 5
Pump Manufacturer: Flygt Model Number: NP 3171 SH 63-275-00-1070 Impeller Diameter: 195 mm Horsepower: 35 Voltage: 460v 3phase
Static Head
"All On" TDH
"Only Proposed Pump Station On" TDH
20 20 20 0 0
37 58 119 191 313
23 42 100 169 287
Velocity (fps)
Pump Head
0.6 1.9 3.8 5.7 7.7
245 197 135 74
Pump and Force Main System Curve 350
300
TDH (FT)
250
200
Pump Head All On System TDH All Off System TDH
150
100
50
0 0
200
400
600
800
1000
1200
1400
Flow (GPM)
Pg. 8
Station Operation Check
Proposed Operational Point No.1 600 GPM @ 135
TDH
Check Wet well Cycle Times Wet well Diameter (feet)
Wet well Area (gal / VF)
8.0
376
4.0
1503
Wet well Volume
=
10.7
minutes
=
3.3
minutes
Fill =
Wet well Wet well Cycle Volume (ft) (gal)
ADF Run =
Wet well Volume Pump Rate - ADF
Total = 14.0 Cycle Time = 4.3 Meets Minimum Cycle Time? OK Meets Maximum Cycle Time? OK
minutes Cycles / Hour
Station Operation Check
Proposed Operational Point No. 2 640 GPM @ 125
TDH
Check Wet well Cycle Times Wet well Diameter (feet)
Wet well Area (gal / VF)
8.0
376
4.0
1503
Wet well Volume
=
10.7
minutes
=
3.0
minutes
Fill =
Wet well Wet well Cycle Volume (ft) (gal)
ADF Run =
Wet well Volume Pump Rate - ADF
Total = 13.7 Cycle Time = 4.4 Meets Minimum Cycle Time? OK Meets Maximum Cycle Time? OK
minutes Cycles / Hour
Buoyancy Calculations Wet well Outside Dimensions Wet well Inside Dimensions Wet well Top Slab Elevation Wet well Invert Elevation Extended Base Slab Diameter Extended Base Slab Thickness Top Slab Thickness
9.00 8.00 50.50 27.00 11.00 1.00 0.50
Feet Feet Feet Feet Feet Feet Feet
Calculate Total Volume of Wet well Structure Volume of Wet well Riser Sections= Volume of Wet well Extended Base= Total Volume of Wet well Structure=
1494 95 1589
cf cf cf
Calculate Total Volume of Water Displaced H20 Displaced = (Volume of Wet well Structure) * (62.4 lbs/cf) H20 Displaced= 99168 lbs Calculate Submerged Weight of Wet well Components Section Top Slab Thickness (ft.) Riser - Total Vertical Ft. Base Slab Thickness (ft.) Totals= Total Weight of Concrete in Wet well=
Total Ht 0.50 23.50 1.00
Weight 2786 27486 8325
25
38597
38597
lbs.
Calculate Weight of Soil Above Extended Base/Footing Total Area of Extended Base Total Area of Wet well Riser Area of Extended Base less Wet well Height of Soil Above Extended Base Volume of Soil Above Extended Base Weight of Soil Above Extended Base (estimated) Total Weight of Soil Above Extended Base
95 64 31 23 723 50 36128
sf sf sf ft cf lbs/cf lbs/cf
Flotation Protection Required? Weight of Concrete and Weight of Soil Above Extended Base: Weight of Water Displaced By Wet Well: Flotation Protection Required?
74726 lbs 99168 lbs YES
Related Documents 3m3m1z
Utility Pump Station Design Spreadsheet 2w221t
December 2019 48
Pump+turbine_ Foundation Design Spreadsheet 3ix4y
February 2021 0
Pump Sizing Spreadsheet 4v1237
November 2019 72
Storm Water Pump Station Design Guide 5r5g1c
October 2022 0
T Beam Design Spreadsheet 6j376w
January 2022 0
Slab Canopy Design Spreadsheet 304i4q
April 2020 16More Documents from "Farhat Khan" 193r5d
Utility Pump Station Design Spreadsheet 2w221t
December 2019 48
Marazzi Espana 2013 Cevisama Collection 6z1w72
December 2019 49
Lean Mesurement Book 522d6c
April 2020 19
Understanding Carbon Mesh Size 325s24
December 2019 24
Shahid Amin, Gandhi As Mahatma 6m263q
October 2019 121