BEFORE PROCEEDING www.cranepumps.com
System Design READ THE IMPORTANT INFORMATION BELOW The Design Templates included in this software are only tools to aid in the proper design of a low pressure sewer system. All project designs present specific issues that require consideration and solutions beyond the scope of the templates. Outcomes resulting from the use of the templates are the sole responsibility of those who choose to use the templates. Barnes Pumps Inc. accepts no responsibility for the results obtained through the use of the templates. The Design Templates have been created using Microsoft Excel. It is assumed that anyone using the Design Templates is a competent and experienced user of Microsoft Excel and will be using a properly licensed copy of the software. Microsoft Excel is protected under copyright of Microsoft Corporation. Those not in agreement and compliance with the paragraphs above are expressly not given permission to use the Design Templates. Permission is also expressly denied to make alterations to the template values and formulas. If you agree, please proceed to the next page. If you disagree, please exit.
SECTION D 1 PAGE DATE 6/05
A Crane Co. Company
USA: (937) 778-8947 • Canada: (905) 457-6223 • International: (937) 615-3598
DESIGN TEMPLATE USE INSTRUCTIONS (Instructions pertain to templates beginning with “DT” and containing “01_02” in the name) www.cranepumps.com
System Design Design templates are helpful tools in predicting pipe size required, design flow rates, friction and head characteristics, flow velocities, and average retention times throughout the system. Each template is for a specific pump type and a specific type and grade of pipe. There are eight templates, four for centrifugal grinder pumps based on Barnes SGV pump characteristics and four for progressing cavity grinder pumps based on Barnes SGPC pump characteristics. It is suggested that spreadsheet templates be saved as “XLT” files on your hard drive. Specific use applications should be saved individually as “XLS” files. Follow the following steps in order: • A Sample Printed Page is Attached for Your Reference • Open Excel • Open The Appropriate Design Template • Save as “XLS” file on your hard drive or floppy disk….include project name in file name. Suggested example: (ABC LAKE.xls) • In cells P11 and P12, enter the Project Name and Project Location • In cell E19, enter the “c” value desired from Hazen-Williams equation. It is strongly recommended the value be “150.” • All of the following steps involve table entry data. The Pipe Segment numbers are already entered in Column A. It is imperative that these numbers remain in consecutive order or errors will occur. If you find you need to add some rows, you may do so by adding them as decimal. For example: If pipe segment number 1 needs to be divided into two pipe segments, you may call them 1.1 and 1.2 respectively. (See next paragraph before proceeding) • When a new row is needed, DO NOT INSERT A NEW ROW. Instead, renumber column A. Inserting a row will insert a blank row with no formulas. In the example above, we wanted to insert one additional row so that the original Pipe Segment 1 would end up being two lines, Pipe Segments 1.1 and 1.2. If the numbers 2 through 286 were selected in Column A, cut and pasted beginning with Pipe Segment 3 (cell A27) through 287, the space required is achieved and no formulas are lost. The spreadsheet now ends with row 286 and there are two rows available for 1.1 and 1.2. You may need to re-format to one decimal place. • Begin entering data in Column C for each respective pipe segment. Columns requiring data entry are Columns C through G. • Only after the completion of preceding step, enter data into Column B. Data required is the number of the pipe segment “into which” a respective pipe segment flows. For example, if Pipe Segment 2 discharges into Pipe Segment 5 in a design layout, the number 5 would be entered in Column B of Pipe Segment 2.
SECTION D 2 PAGE 6/05 DATE
A Crane Co. Company
USA: (937) 778-8947 • Canada: (905) 457-6223 • International: (937) 615-3598
DESIGN TEMPLATE USE INSTRUCTIONS (Instructions pertain to templates beginning with “DT” and containing “01_02” in the name) www.cranepumps.com
System Design • Wherever a pipe segment discharges to atmosphere, for instance into the wet well of a lift station, enter the Number Zero in column B. • Iterations to verify system performance under varying circumstances are easily performed with the spreadsheet format. For example, to understand what happens when an air release valve opens simply alter the basic calculation as follows: 1. Change control datum in all pipe segments pumping to the air release valve to the elevation of the air release valve. 2. Change Column B value to Numeric Zero in the pipe segment containing the respective air release valve. Result will be system performance upstream of the air release valve when the air release valve is in the open position. • Printing the spreadsheet 1. Highlight all cells that you desire to print beginning with the last row, Column W. back through Cell A1. 2. Click File, Print Area, Set Print Area. 3. You are now ready to print the spreadsheet.
SECTION D 3 PAGE DATE 6/05
A Crane Co. Company
USA: (937) 778-8947 • Canada: (905) 457-6223 • International: (937) 615-3598
INTO
SEGMENT
NUMBER
(EDU's)
OF
NUMBER
Date Printed: 6/13/2005
23 24 25 26 27
20 21 22
12 13 14 15 16 17 18 19
8 9 10 11
3 4 5 6 7
1 2
FLOWS
PIPE
SEGMENT
CONNECTED
EDU's
ACCUM
in Segment
DATUM
LOW
150
of Segment
DATUM
CONTROL
Hazen-Williams "C" Factor
PIPE
MAX
(GAL/MIN)
FLOW (INCH)
SIZE
PIPE
(INCHES)
ID
PIPE
MAX
(FT/SEC)
VELOCITY
Project Name: YYY
Project Location: XXX
(FT/C.FT)
FACTOR
FR LOSS
(FEET)
THIS PIPE (FEET)
FL
ACCUM
(FEET)
PIPE
NUMBER
SEGMENT
SEGMENT
TIME
RETENTION
DISCHARGE
TO
HOURS
PVC SDR 21
Barnes Hydraulics Program.xls, Page 1
REQUIRED
MAX HEAD
Pipe Type:
GPM for one pump
N= EDU's B= 25
Constant Number of EDU's on a given pipe segment
A= 0.5
Gal./EDU= 200
Assumptions: AN + B = Q
FRICTION
This preliminary design analysis is only valid for Barnes pumps.
(FEET)
LENGTH
www.Barnes-PS.com
Barnes Pumps Inc. 420 Third Street Piqua, Ohio 45356
