Technical data

Page 108
TECHNICAL DATA
The Viking Corporation, 210 N Industrial Park Road, Hastings MI 49058
Telephone: [phone] Technical Services 877-384-5464 Fax: [phone] Email: [e-mail]
ESFR PRE-PRIMED SINGLE
INTERLOCK PREACTION
COLD STORAGE SYSTEM
March 7, 2008
APPENDIX B - ESFR PRE-PRIMED SINGLE INTERLOCK
PREACTION COLD STORAGE SYSTEM PIPING ESTIMAT-
ING TOOL
Appendix B provides information on how to set up a Microsoft Excel spreadsheet to compare the fric-
tion loss values when using the Hazen Williams formula and the Darcy-Weisbach formula. This tool
can be helpful in the project estimating phase for large systems that use propylene glycol solution.
This spreadsheet is not intended to be used for hydraulic calculations. It should be used as a refer-
ence only.
A
BC D EFGH
1 Hazen Willams Darcey Wiesbach Reynolds Number E1 Turbulent
2 PSI Loss Per Foot B2 C2 Calculated Friction Factor E2 Laminar
3 Total PSI Loss B3 C3
4
5
6 Hazen Willams Darcey Wiesbach
7 Flow Rate (GPM)
8 C of Pipe None Typical values are 120
9 internal pipe dia (in.)
10 Length of pipe (ft)
11 friction factor None See cell above or may also be found in table
12 Temperature (F) 60 0 -10 -20
13 Density 64.96 65.89 66.2 67.7
14
viscosity (centipose) None
Viscosity 8.13 61 96 180
15 Relative Pipe Roughness None Typical values are .0003
3
B2 =4.52*B7^1.85/(B8^1.85*B9^4.87)
C2 =IF(E1>2000,G1,G2)
E2 =(1/(-1.8*LOG10(6.9/E1+(C15*12/(C9*3.7))^1.11)))^2
B3 =B2*B10
C3 =C2*C10
Enter the following formulas in the cells listed:
E1 =47.6*C7*C12/(C9*C14)
Step 1: Create the table as shown. Enter
the formulas and constant values
highlighted in gray. Formulas are listed
to the right.
Inputs
density (lbs/ft^3) None
A
BC D EFGH
1 Hazen Willams Darcey Wiesbach Reynolds Number #DIV/0! #DIV/0! Turbulent
2 PSI Loss Per Foot #DIV/0! #DIV/0! Calculated Friction Factor #DIV/0! #DIV/0! Laminar
3 Total PSI Loss #DIV/0! #DIV/0!
4
5
6 Hazen Willams Darcey Wiesbach
7 Flow Rate (GPM) 803.8 803.8
8 C of Pipe None Typical values are 120
9 internal pipe dia (in.)
10 Length of pipe (ft)
11 friction factor None See cell above or may also be found in table
12 Temperature (F) 60 0 -10 -20
13 Density 64.96 65.89 66.2 67.7
14
viscosity (centipose) None
Viscosity 8.13 61 96 180
15 Relative Pipe Roughness None Typical values are .00033
Step 2: Input Flow Rate into cells B7 and C7
Inputs
density (lbs/ft^3) None