Variable Speed Pump System Workbook, version 2.

0 March 2009

Workbook to estimate the savings from adding variable speed control

or improving the control in a variable flow pumping system

This workbook allows the user to change flows, the pressure setpoint, and the reset schedule. This will allow the user
to estimate the impact of changes such as
• Reduce Differential Pressure setpoint
• Reset Differential Pressure setpoint
• Reduce flows (e.g. by changing 3-way valves to 2-way valves)
• Reduce operating hours (with schedule changes or temperature lockout)

This workbook includes some checks of performance relative to the requirements of California "2005 BUILDING
ENERGY EFFICIENCY STANDARDS" (Title 24). These checks are provided as a service to users. However,
performance estimated by this workbook is not warranted as, and should not be construed as, any proof of
compliance or non-compliance.

Major updates since the last version include:

Changing the solver engine to calculate line by line to significantly increase speed and improve robustness of the
calculation.
An input data guide is included to help the user understand what data to collect for input into the calculation.
Footers are added to each page to document relevant project information, and a place to better document the details
of the measures installed is included.
The instructions have been clarified based on user feedback and links provided from the sheets to relevant
instructions.

General Comments
There are 3 input worksheets: "PumpInput," "SystemInputs," and "CalcInputs." Data should be entered in these
worksheets in that order. The "InputDataGuide" tab has helpful guidance on obtaining or estimating the data that
needs to be entered.

If you don't have a specific pump curve to enter, the program will scale a default pump curve based on the design
sizing for the project pump.

This workbook simulates a simple flow loop. Multiple take-offs are not simulated. Therefore, it is important that the
user simulate the critical zone or coil in their system to properly estimate the energy use and savings. The critical
zone is the zone that requires the the controlling device (valve or damper) to be the nearest to fully open in order to
satisfy the zone. If a non-critical zone is simulated, the savings could be over-estimated. In the real system, if a non-
critical zone controls the duct or pump pressure, then a more critical zone could end up "starved" for flow. This will
often result in a controls change that will cause a reduction in savings from what was estimated.

Instructions Page 1
Systems with take-offs upstream of the static pressure sensor will give conservative results using the simple inputs on
worksheet "System Inputs." The degree of conservatism is dependent upon the proportion of the total pump flow that
takes off before the sensor. If more accurate results are desired, the more detailed inputs can be used. The more
detailed inputs allow the user to enter different flows at different places in the loop, but also require more information
about the pressures in the loop. If the flows are the same throughout the loop, and if the appropriate inputs are used,
simulations using the simple and detailed inputs will produce the same energy use and savings estimates.

Reset of the controlling differential pressure is simulated by allowing the user to input different pressures at different
flows. It is up to the user to input pressures that would result from a particular reset schedule or reset control strategy.
This workbook does not directly simulate a reset based on valve position. However, the program does provide a
formula that can determine the lowest possible pressure that can allow the input flow to be achieved. In other words,
this formula, which can be input automatically by a macro button, estimates the pressure that will cause the controlling
valve to be fully open and the flow still achieved..

There are 4 separate calculation worksheets: "CalcBaseline," CalcReduceFlows" CalcReduceSetPt," and

"CalcWithReset." No user input is required in these worksheets.

This calculation requires an interative solution. The standard Excel add-in, "Solver," must be installed. If
Solver is not installed, click Add-Ins on the Tools menu, and then select the Solver Add-in check box. Click OK, and
Excel will install the Solver. If you don't see Solver on the list of possible add-ins, you may need to run Excel Setup
again to make it available.
There is a button on the "VFDCalcInputs" worksheet to run the interative calculations. This macro updates all of the
calculation worksheets.

If you don't have a successful solution initially, it is probably because the system pressure drops are too great for the
input flows and the specified pump. The application provides prompts for this circumstance. Also see the notes for
worksheet "SystemInputs."
IMPORTANT: The Excel Solver usually does a good job of making sure that the pressure drops at the input flow
match the pressure rise across the pump, and making sure that the input pressure setpoint is met. However, as with
all analyses, the user should review the output to make sure the results make sense. Watch for unexpected
discontinuities in the graphs, and verify that the pressure matches the setpoint.

Also, note that the application assumes that the required flow will be achieved unless it is impossible to achieve it,
even with the speed at 100%. In some cases this could mean that the sensed pressure is higher than the setpoint.
Clearly this is not the way the systems would really operate: in the field the speed would be decreased to satisfy the
pressure setpoint, and the required flow wouldn't be achieved. The alternative would have been to allow the flow to
vary, but this would have slowed the calculation and made it less stable. If the results show a sensed pressure higher
than the setpoint, check the inputs and make sure they truly represent the system being modeled.

Advanced Users. The sheets have been protected to avoid erroneous input. Advanced users who wish to inspect
the calculation method in detail or make changes can access the formulas and code in the sheet as follows: Unhide
the sheet named "Version." You may wish to add comments there about changes you make to your version of the
tool. At the top of the "Version" sheet are convenience buttons that will unprotect or protect the sheets. It is
recommended that the tool be put in protected mode for use to avoid overwriting necessary formulas.

Inputs
Input cells are shaded yellow.

There are inputs on 3 sheets—PumpInput, SystemInputs, and VFDCalcInputs.

Instructions Page 2
Worksheet "PumpInput"
This worksheet is used to input the Pump data.

Enter the design selection point for the pump, usually available from the pump nameplate or drawings. If the system
has 2 identical pumps controlled in parallel, the flow for one pump should be entered, half of total system flow. Note
that a 2-pump system may be designed for only one pump to operate, with the second pump as a backup and normal
entry would be used. Note also that building operators will often have both pumps running when only one is needed.
If both pumps are found on, the system design and control sequence should be investigated. If only one pump is
needed, sequences should be revised or building operators educated.

Pump curve input: Ten points must be input for both the head curve and the efficiency curve. The Pump speed is also
input.

The data must be entered in order, from lowest flow to highest flow. The lowest flow should be near zero, and the
highest flow should give a Pump head near zero. This will often need to be extrapolated from the manufacturer's
curve for entry here, since Pump curves typically don't cover such relatively high flows.

Though this workbook has auto-scaling of a default Pump curve, it is strongly recommended to input the actual Pump
curve or the curve for another similarly-sized Pump in order to gain the best results. The range of flow and head must
include the design pump flow and head. When the pump curve does not match the actual pump, expect the solver
iteration to require multiple attempts.

Worksheet "SystemInputs"
The first set of inputs are for the differential pressure setpoint, motor and VFD sizes (to get part-load efficiencies), a
choice of methods to get VFD efficiencies (see chart at right for comparision of one case), and a choice of using
Temperature or Flow as the category axis on one of the output charts on the "SavingsSummary" worksheet. The two
required inputs are motor size and VFD size (usually the same as motor size).

The next sets of inputs are used to describe the pressure drop characteristics of the system. The "Simple Inputs" are
easiest to use, and provide the same energy use and savings estimates as the "Detailed Inputs."
- Input tested pump pressure difference from points 1 to 2 on schematic and pressure differential measurement from
points 3 to 6, as well as measured or estimated flow during test.
- "Detailed Inputs" have the advantage of providing a better estimate of where the pressure drops occur in the
system, and hence more accurate reporting of pressures at particular places in the system. However, "Simple Inputs"
should suffice in the vast majority of cases.
If using the "Detailed Inputs," each set of 3 inputs—2 pressures and 1 flow—must have a consistent set of inputs: The
input pressures must correspond to the pressures at the input flow.

Different sets of inputs can be at different flow conditions, but the pressures must be the ones that result at the input
flow.

(A later version may permit use of a different flow for the critical zone.)

These inputs can come from trend data, measurements, drawings, or calculations as available. But the relationship of
the pressure drops in the system is key to estimating the savings when there is no differential pressure reset, and will
affect the savings of differential pressure reset whenever the reset is not perfect. Therefore, the inputs for flows and
pressures are important.

Instructions Page 3
Ideally the inputs would come from trend data or measurements. However, these data may be hard to obtain. If
measured data are not available, the system data for "∆p across pump" and "estimated flow" can be based on
the pump design data, adjusted for the assumption that that pump has some design margin. If there is no
design margin, this may be reflected in the calculations, and the baseline calculation could fail because it
might not be possible to achieve the design flow.

Worksheet "VFDCalcInputs"
In these worksheets the required flows to handle the load at various operating conditions must be input. Flows at
different loads can be derived from trend data or energy simulation programs or methods. If the system has 2
identical pumps controlled in parallel, the flows for one pump should be entered, half of total system flow.

Up to 20 different flow conditions can be input. These will typically be for different ambient conditions, and a column
of bin temperatures are provided for convenience. However, the flows could vary based on other criteria as well. It is
up to the user to create a correlation of flow to the appropriate independent variables. The bin temperature column
can be edited as needed. The bin temperatures aren't used by the program; they are only there for
convenience in listing the hours at a particular flow. The user could use the bin temperatures in a formula to
calculate the flows, if the flows and load are dependent on ambient temperature.

If the base case is fixed speed, then input a high (impossible to reach) pressure setpoint for baseline. If a VSD is
already in place, enter the baseline differential pressure control setpoint.
The "Change Flows and operating hours" columns enable the user to simulate system changes that would change the
flows required to satisfy the load. For example, the flow could change if the minimum flows for one or more coils
changed. The flows could also change if the load was reduced as part of the project, such as by a lighting retrofit, or
replacing some 3-way valves with 2-way valves.

Operating hours can be reduced through schedule changes, reducing building loads, or putting a high- or low-
temperature lockout in to turn off the pump when not needed.

The user can enter the specific differential pressure setpoints associated with a reset schedule.
(Range K8:K27) These cells can include a formula that uses the pressure drop characteristics of the piping and
equipment to simulate a "perfect" reset schedule. That formula is as follows:

(Zdp3to4 + Zdp4to5 + Zdp5to6) * Flow*Flow

The formula also has logic to maintain a minimum pressure differential as input.

This formula will be placed in Range K8:K27 by clicking the macro button to "Use Optimum Reset Pressures"

The "perfect" reset uses a formula to give the theoretical optimum setpoint for each flow. Based on the input
pressures, the piping characteristic pressure drops are estimated, and a "perfect" reset pressure is the minimum
pressure needed to push the input flow through the simulated system. Because this application only uses a single-
zone model, and pressure drops may not always be, as simulated, a function of the square of the flow, the values
resulting from that formula will give optimistic results. Since the "perfect" resets are not likely to be achieved in reality,
they should just be used to see the limits of what might be gained with setpoint reset. In addition to zone differences,
the theoretical optimum reset shown assumes the abilitiy to use a valve-position based reset strategy that may be
difficult as discussed in the Seidl article on the links page.

Hint: If the calculation will not complete, first run a case where you pick a design point from the representative pump
curve provided to prime the cells with normal values for the solver, then rerun with the actual pump design conditions
that require an extrapolated pump curve.

Calculation Worksheets

Instructions Page 4
Calculation worksheets: "CalcBaseline," "CalcReduceFlows," "CalcWithVFD," and "CalcWithReset."

These worksheets are where the iteractive calculations take place. The calculations solve for the required pressures
in the flow loop. No user inputs are required. If you wish to stop a calculation underway, use the ctrl key and "break"
button several times.
Note that the current version does not include a full documentation commentary of all formulas, although they are
fairly standard engineering calculations that should be understandable to an experienced HVAC engineer.

Calculation Methodology
The basic approach is to use the excel solver application that applies a Newton-Raphson convergence methodology
on the calculation sheets. Each calculation sheet is essentially identical, using different inputs for the relevant
situation. Relevant data are taken from the input sheets and the solver iterates values for the pump speed and critical
throttling valve until a solution is reached for each flow rate. Note that the solver writes unique case values into
the sheet for pump speed and critical valve pressure drop, so until the calculation button is pressed, the
values will not be correct for a new situation that has been entered. If detailed inputs are provided on the
SystemInputs tab they are used, otherwise intermediate system pressures are estimated based on simplified inputs.
Parameters for each pressure position shown on the schematic are shown on the SystemInputs tab below the
schematic.

Once pump speed and pressure is calculated for each flow bin, the input efficiencies as projected to the selected
pump curve are used along with standard motor efficiency factors and the selected VSD power determination method
to calculate pump kW and pump kWh at each flow bin.

Output Worksheet
Worksheet "SavingsSummary"
This worksheet should be self-explanatory. If the system uses parallel pumping, with both pumps operating at all
times, savings will double the value shown.

Other Worksheets
Worksheet "PumpCurveFit"

The user doesn't need to do anything with this worksheet.

This worksheet estimates two polynomial fits to the input Pump data, a 4th-order fit for the pressure and a 3rd-order fit
for the efficiency.

These curve fits are used to estimate Pump performance in the Calc worksheets.

The worksheet also has a graph showing the Pump curves and some cells generalizing the curve so that it can be
used for different sized Pumps.

Worksheet "VFDeffy"
The user doesn't need to do anything with this worksheet.

This worksheet shows the sources of the data for motor and VFD efficiencies.

Problems?
Please email the California Commissioning Collaborative at info@cacx.org, if you encounter problems with this tool.

Instructions Page 5
Links to Related Resources
Pumps and Your Processes: They Must Work Together
Using System Curves to Enhance Pump Performance
Pumps and Your Processes: When They Won't Work Together
Continuous Commissioning Guidebook (FEMP)
CCSM Measures for Water/Steam Distribution Systems
Workshop Report on DDC to the Zone Level
David Sellers' Blog
Right-Sizing Pumps, David Sellers, HPAC Magazine March 2005
2005 CA Building Energy Efficiency Standards website
2005 CA Building Energy Efficiency Standards Manual
2005 CA Nonresidential Compliance Manual
Using demand-based reset strategies, Reinhard Seidl
 Data Inputs are color coded as follows: Required Data (enter site-specific data in yellow cells)
Note: Data is NOT input on this sheet! Optional Data (leave defaults if acceptable)
The following data is needed for this calculation. Detailed Input Data or rarely overriden default calculations
Please see the reference guide downloaded with the tool for recommended testing procecures to acquire some of this data.
Input Data Units Input on Tab Preferred Source
pump conditions at peak efficiency
pump Speed rpm pumpInput Pump curve for investigated pump at
hydronic Flow GPM pumpInput design speed. Where available, put in
Head ft. Head pumpInput actual pump efficiency.
Max Efficiency % pumpInput
Above for Design pumpInput Pump nameplate tag, equipment
submittals
pump curve data (default pump pumpInput pump curve for main supply pump at
curve will scaled to specific pump design speed.
inputs, so not high importance.)

Site specific pump system conditions:

pump motor size HP SystemInputs Motor Nameplate
VFD size HP SystemInputs VSD Namplate

VFD efficiency SystemInputs

Method

X-axis variable SystemInputs

Tested (or estimated) pump conditions at full open flow Field test of pump flow and pressures
D.P. at sensor[3-6] psi SystemInputs with all coil valves driven full open or
pump % speed for this test SystemInputs Balancing report of similar test. The
D.P. sensor[1-2] psi SystemInputs input for point [3-6] (differential
pressure at full flow) is probably the
Full hydronic flow GPM SystemInputs
most important input as far as
determining optimized pressure reset
schedules - obtaining measured data
for this point should be prioritized.

Use Detailed Inputs Check SystemInputs Check only if have all noted test data or good estimates
differential Pressure psi SystemInputs Field test of pump flow and pressures
at noted points with all coil valves full open
Main pump GPM SystemInputs
hydronic flow
Initial Flow Factor SystemInputs Recommended to leave this at 1.05

For four noted conditions, input flow conditions

differential pressure psi VFDcalcInputs Actual control setpoint or trends. (greater
setpoint than pump curve max head for constant
speed)
Flow at various load GPM VFDcalcInputs Flow trends correlated with outside air
condions temperature or load conditions.

Operating hours at hours/yr VFDcalcInputs Flow trends correlated with outside air
each load condion temperature or load conditions.

Minimum psi VFDcalcInputs Test in building after reset implemented

differential pressure to verify lowest differential pressure
setpoint for reset setpoint possible with no comfort issues.
 cific data in yellow cells) System schematic for reference:
if acceptable)
overriden default calculations
ecures to acquire some of this data.
Secondary source(s) Comments
May estimate peak efficiency at point
Use a pump curve for similar type near or at design point.
and impeller size. Efficiency may be
estimated using "estimate" button.

Building plans, balancing report or Not used in calculation, for

maintenance manuals, documentation only
Use a pump curve for similar type Include min & max flow points, max
and wheel size. efficiency point, and 7 other points;
where pump curve flattens at left,
input increasing head as flow reduces
to produce best results.

Plans or submittals
Plans or submittals or estimate
same as motor size
Bernier method has typically lower
efficiencies at low flow and higher
energy use than DOE-OIT method
Used in chart titles only
Estimated design flow and head If the differential pressure control does
conditions (calculate differential not exist or is located too close to the
across points [3-6] using pipe pump, it may be beneficial to test
presure drop calculations). If differential pressure in hydraulically
measurements cannot be extreme locations to justify installation
obtained for full flow differential or relocation of differential pressure
pressure (point [3-6]), care must sensing.
be taken in estimating this value.

est data or good estimates

Piping simulation or Balancing
report of similar test.
Main pump hydronic flow may vary for
different test conditions.
Can get slightly improved accuracy If necessary, the solution will increase
using factor of 1.00; but will take the flow factor. This occurs because
longer to converge to solution the estimated pump curve may be
slightly below the tested pump
capability.

Sequence of operation setpoint or Required for Base, Reduced Setpoint

operator interview. Case & for each load condition for DP
reset
Simulation of building with hydronic Required for Base and Reduced flow
flow trends by load condition, or or hours Case
typical estimate based on similar
building.

Simulation of building with hydronic Required for Base and Reduced flow
flow trends by load condition, or or hours Case
typical estimate based on similar
building.
Manufacturer's recommendation of Note: While pressure independent
minimum valve inlet pressure for valves typically require 5 psi to
proper operation. provide accurate flow information, if
valve flow information is not
necessary a lower minimum setpoint
can be used and resets can be
controlled from valve position.
matic for reference:
Project Pump Info Speed, rpm Flow, gpm head, ft effy ∆p, psi
Maximum efficiency point 1750 135 120 56.1% 52.2
Project Pump Design Point 1750 120 125
Design point is optional entry,
for reference only
Note: Hover over comment marked (red triangle) cells for more detail on inputs.
Pump Curve: Generic (from B&G Series 80 2x2x7 @ 3500 rpm)
Impeller dia., in. Speed, rpm Flow, gpm head, ft effy ∆p, psi Water HP
7 3500 0 229.0 0.1% 99.6 5.8
44 228.0 30.0% 99.1 8.5
75 225.0 45.0% 97.8 9.5
106 221.0 54.0% 96.1 11.0
135 212.0 58.0% 92.2 12.5
170 198.0 60.0% 86.1 14.2
190 188.0 58.6% 81.7 15.5
210 170.0 55.5% 73.9 16.3
260 130.0 40.0% 56.5 21.4
330 0.3 0.1% 0.1 25.1
Pressure Rise, feet

Estimated Pump Performance

160
Pressure Rise at
140 100% Speed

Pressure Rise at
120 80% Speed

100 Max Efficiency

Point

80 Design Point

60

40

20

0
0 50 100 150 Flow,200
gpm 250 300 350 400

Cases analyzed:
Baseline - Constant Flow
Details for case 0

Reduce Average Hydronic Flow

Details for case 1

Remove pipe obstructions

Details for case 2

Reset Static Pressure Setpoint by Coil PID

Details for case 3

Project Name CHW CP-3 Firm or Analyst

Building Owner Main Chilled Water 1-Dec-24
System Inputs System Schematic

10 Motor size, HP 7.30 Approx Pump SHP at design

10 VFD size, HP
DOE-OIT Method of obtaining VFD efficiency
X-axis variable for the chart of Pressure drops from 2 to 1 must =
Temp "Pump Energy vs…" (Temp/Flow) pressure rise from 1 to 2.

Pressure Drop Inputs

Simple Inputs Use Detailed
Measurements taken when all control valves are full open. Inputs
40 ∆p across differential pressure sensor [3-6], psi 158 Pressure at 2, psi
100% pump % speed 125 Pressure at 3, psi
60.3 Max ∆p across pump, psi (from curve) 170 Flow, gpm
54.5 ∆p across pump [1-2], psi (valves wide open)
120 estimated flow from curve, gpm 125 Pressure at 3, psi
Pressure Rise, feet

120 Pressure at 4, psi

170 Flow for this case

Estimated Pump Performance 120 Pressure at 4, psi

160
Pressure Rise 114 Pressure at 5, psi
140 at 100% Speed
170 Flow for this case
Pressure Rise
120 at 80% Speed Output Pressure Drop Characteristics
Entered Test 114 Pressure at 5, psi Name Definition Value Units
100 Data
Peak Efficiency
110 Pressure at 6, psi Zdp2to3 z(2-3), ∆p/(Flow^2) 0.001050 feet/gpm^2
80 170 Flow for this case Zdp3to4 z(3-4), ∆p/(Flow^2) 0.002897 feet/gpm^2
Zdp4to5 z(4-5), ∆p/(Flow^2) 0.000000 feet/gpm^2
60 110 Pressure at 6, psi Zdp5to6 z(5-6), ∆p/(Flow^2) 0.002897 feet/gpm^2
77 Pressure at 1, psi Zdp6to1 z(6-1), ∆p/(Flow^2) 0.001050 feet/gpm^2
40
170 Flow for this case Total pressure drop characteristic 0.007896
20 differential pressure as a percentage of total ∆P: 73.4%
Loop pressure with
0 Pressure characteristic flow factor to aid convergance: 1.05
15 system off, psi.
0 50 100 Flow,150
gpm 200 250 300
Initial flow factor (1.05 recommended): 1.05
Project Name CHW CP-3 Firm or Analyst
Building Owner Main Chilled Water 1-Dec-24
Scenario Analysis Inputs
Reduce Average Hydronic
Pump Baseline - Constant Flow Remove pipe obstructions Reset Static Pressure Setpoint by Coil PID
Design Flow
Diff. pressure Diff. pressure Diff. pressure Diff. pressure
52 PSI setpoint, psi: 50 setpoint, psi: 50 setpoint, psi: 30 setpoint, psi: 30
135 GPM
Setpoint in feet 115 Setpoint in feet 69 Minimum psi for optimum reset: 3
Differential
Ambient Flow, Flow, Flow, Flow, Pressure
Temp, ºF GPM Hours at Flow GPM Hours at Flow GPM Hours at Flow GPM Hours at Flow Setpoint, psi
102.5 122 2 104 2 104 2 104 2 27.02
97.5 122 35 104 35 104 35 104 35 27.02
92.5 110 84 93 84 93 84 93 84 21.88
87.5 99 133 84 133 84 133 84 133 17.73
82.5 89 343 76 343 76 343 76 343 14.36
77.5 80 539 68 539 68 539 68 539 11.63
72.5 72 686 61 686 61 686 61 686 9.42
67.5 65 707 55 707 55 707 55 707 7.63
62.5 58 679 50 679 50 679 50 679 6.18
57.5 53 392 45 392 45 392 45 392 5.01
52.5 47 217 40 217 40 217 40 217 4.06
47.5 43 35 36 35 36 35 36 35 3.28
42.5 38 7 33 7 33 7 33 7 3.00
37.5 34 1 29 1 29 1 29 1 3.00
32.5 31 26 26 0 26 0 3.00
27.5 28 24 24 0 24 0 3.00
22.5 25 21 21 0 21 0 3.00
17.5 23 19 19 0 19 0 3.00
12.5 20 17 17 0 17 0 3.00
7.5 18 16 16 0 16 0 3.00
Total Hours: 3,860 3,860 3,860 3,860
Weighted
average flow: 69.4 59.0 59.0 59.0

Project Name CHW CP-3 Firm or Analyst

Building Owner Main Chilled Water 1-Dec-24
 Savings Summary Electrical Power vs. Flow
for Three Types of Flow Control
12
#VALUE! Baseline - Constant Flow energy use
#VALUE! Reduce Average Hydronic Flow energy use
Baseline: Fixed speed or high ∆p setpoint
#VALUE! Savings

Power [kW]
10
Improved: Valve controls flow; VFD controls ∆p
#VALUE! Remove pipe obstructions energy use
#VALUE! Additional savings to the reduced flow & hours scenario 8 With reset of ∆p setpoint

#VALUE! Reset Static Pressure Setpoint by Coil PID energy use

#VALUE! Additional savings to the improved variable speed scenario 6

#VALUE! Total Annual Savings

Case Notes: 4
Baseline - Constant Flow
Details for case 0
Reduce Average Hydronic Flow 2
Details for case 1
Remove pipe obstructions
Details for case 2 0
Reset Static Pressure Setpoint by Coil PID 0 20 40 60 80 100 120 140
Flow [gpm]
Details for case 3
Electricity Use [kWh]

Pressure Rise [feet]

Pump Energy vs. Ambient Temperature
for Three Types of Flow Control Pump Performance and System Curves
12 160 100%
Baseline: Fixed speed or Pressure Rise at 100% Speed
high ∆p setpoint 90%
140 Pressure Rise at 80% Speed
10 Reduced Flow or

Efficiency
Baseline System Curve 80%
Reduced Hours
120 Improved System Curve
Improved: Valve controls Improved with Reset 70%
8 flow; VFD controls ∆p
Efficiency at 100% Speed
100
With reset of ∆p setpoint Efficiency at 80% Speed 60%

6 80 50%

40%
60
4 30%
40
20%
2 20
10%

0 0%
0 0 50 100 150 200 250 300
Ambient Temperature [ºF] Flow [gpm]

Project Name CHW CP-3 Firm or Analyst

Building Owner Main Chilled Water 01-Dec-24
Calculation of the Baseline Energy Use
Methodology
Baseline - Constant Flow

Flow, % Flow, pump min ∆p valve

Ambient Flow, Hours at P1, Speed, of max at % of %max pump head, P2, P3, P4, (4 to 5) throttle P5,
Temp, ºF gpm Flow feet RPM RPM MaxEff delta-p ∆p, psi feet feet feet feet feet ∆p feet
Design 120 35 1750 46% 89% 91% 55 126 161 146 104 0.0 12.2 92
102.5 122 2 35 1750 47% 90% 90% 54 125 160 145 102 0.0 7.8 94
Baseline: Fixed speed or high ∆p setpoint

97.5 122 35 35 1750 47% 90% 90% 54 125 160 145 102 0.0 7.8 94
92.5 110 84 35 1750 42% 81% 93% 56 129 164 151 116 0.0 33.3 83
87.5 99 133 35 1750 38% 73% 94% 57 131 166 156 127 0.0 53.7 74
82.5 89 343 35 1747 34% 66% 95% 57 132 167 159 136 0.0 69.5 66
77.5 80 539 35 1719 31% 59% 96% 56 129 164 157 138 0.0 78.2 60
72.5 72 686 35 1697 28% 53% 97% 55 126 161 156 141 0.0 85.3 55
67.5 65 707 35 1679 26% 48% 97% 54 124 159 155 143 0.0 91.0 52
62.5 58 679 35 1664 23% 43% 98% 53 122 157 154 144 0.0 95.6 48
57.5 53 392 35 1652 21% 39% 98% 53 121 156 153 145 0.0 99.3 46
52.5 47 217 35 1643 19% 35% 98% 52 120 155 153 146 0.0 102.4 44
47.5 43 35 35 1635 17% 32% 98% 52 119 154 152 147 0.0 104.8 42
42.5 38 7 35 1628 16% 28% 99% 51 118 153 152 148 0.0 106.8 41
37.5 34 1 35 1623 14% 26% 99% 51 118 153 152 148 0.0 108.5 40
32.5 31 0 35 1618 13% 23% 99% 51 117 152 151 149 0.0 109.8 39
27.5 28 0 35 1614 12% 21% 99% 51 117 152 151 149 0.0 110.8 38
22.5 25 0 35 1611 10% 19% 99% 51 117 152 151 149 0.0 111.7 37
17.5 23 0 35 1609 9% 17% 99% 51 116 151 151 149 0.0 112.4 37
12.5 20 0 35 1606 8% 15% 99% 51 116 151 151 150 0.0 112.9 37
7.5 18 0 35 1604 8% 14% 99% 50 116 151 151 150 0.0 113.4 36

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
 Baseline - Constant Flow
at total flow reduction

∆p ∆p P1- pump effective

P6, (3 to 6) setpt, P1calc, delta-p, %peak Pump Pump Flow, Motor VFD Pump Pump incremental
feet feet feet P1calc feet Residual PSI effy effy HP gpm effy effy kW kWh exponent
50.1 95.7 115 35 0.0 0.0 54.7 100% 56% 6.8 120 94% ### ###
50.6 94.1 115 35 0.0 21.3 54.5 100% 56% 6.9 122 94% ### ### ###
50.6 94.1 115 35 0.0 21.3 54.5 100% 56% 6.9 122 94% ### ### ###
47.7 103.2 115 35 0.0 12.1 55.9 99% 56% 6.4 110 94% ### ### ### ###
45.3 110.3 115 35 0.0 5.1 56.9 96% 54% 6.1 99 94% ### ### ### ###
43.3 115.3 115 35 0.0 0.0 57.4 92% 52% 5.7 89 94% ### ### ### ###
41.7 115.3 115 35 0.0 0.0 56.0 89% 50% 5.3 80 93% ### ### ### ###
40.5 115.3 115 35 0.0 0.0 54.9 84% 47% 4.9 72 93% ### ### ### ###
39.4 115.3 115 35 0.0 0.0 54.0 80% 45% 4.6 65 93% ### ### ### ###
38.6 115.3 115 35 0.0 0.0 53.3 75% 42% 4.3 58 92% ### ### ### ###
37.9 115.3 115 35 0.0 0.0 52.7 70% 39% 4.1 53 92% ### ### ### ###
37.3 115.3 115 35 0.0 0.0 52.2 65% 37% 3.9 47 92% ### ### ### ###
36.9 115.3 115 35 0.0 0.0 51.8 60% 34% 3.8 43 91% ### ### ### ###
36.5 115.3 115 35 0.0 0.0 51.5 56% 31% 3.7 38 91% ### ### ### ###
36.2 115.3 115 35 0.0 0.0 51.2 51% 29% 3.6 34 90% ### ### ### ###
36.0 115.3 115 35 0.0 0.0 51.0 47% 26% 3.5 31 90% ### ### ### ###
35.8 115.3 115 35 0.0 0.0 50.9 43% 24% 3.4 28 90% ### ### ### ###
35.7 115.3 115 35 0.0 0.0 50.7 40% 22% 3.3 25 90% ### ### ### ###
35.5 115.3 115 35 0.0 0.0 50.6 36% 20% 3.3 23 89% ### ### ### ###
35.4 115.3 115 35 0.0 0.0 50.5 33% 18% 3.2 20 89% ### ### ### ###
35.4 115.3 115 35 0.0 0.0 50.4 30% 17% 3.2 18 89% ### ### ### ###
60

Project Name CHW CP-3

Building Owner Main Chilled Water Firm or Analyst
 Baseline - Constant Flow
t total flow reduction

effective
net
exponent Regression: Pump power vs. flow Note: Regressions may be inaccurate if appropriate flows are not input for all 20 load conditions

#VALUE! #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE! #VALUE!
### #VALUE! #VALUE! #N/A #N/A
### #VALUE! 6 #N/A #N/A
### #VALUE! #VALUE! #N/A #N/A
### Third order equation - (see LINEST in excel help documentation for additional explanation)
### #VALUE!
###
###
### #VALUE! #VALUE! #VALUE!
### #VALUE! #VALUE! #VALUE!
### #VALUE! #VALUE! #N/A
### #VALUE! 17 #N/A
### #VALUE! #VALUE! #N/A
### Second order equation - (see LINEST in excel help documentation for additional explanation)
### #VALUE!
###
###
###
###

12/1/2024 Project Name CHW CP-3 12/1/2024

Firm or Analyst Building Owner Main Chilled Water Firm or Analyst
Calculation of Savings from Reducing Flows and Operating Hours
Methodology
Reduce Average Hydronic Flow

Flow, % Flow, pump min ∆p valve

Ambient Flow, Hours at P1, Speed, of max at % of %max pump head, P2, P3, P4, (4 to 5) throttle P5,
Temp, ºF gpm Flow feet RPM RPM maxEff delta-p ∆p, psi feet feet feet feet feet ∆p feet
Design 120 35 1750 46% 89% 91% 55 126 161 146 104 0.0 12.2 92
102.5 104 2 35 1750 40% 77% 94% 56 130 165 154 122 0.0 44.9 77
97.5 104 35 35 1750 40% 77% 94% 56 130 165 154 122 0.0 44.9 77
92.5 93 84 35 1750 36% 69% 95% 57 132 167 158 132 0.0 63.0 69
Reduced Flow or Reduced Hours

87.5 84 133 35 1731 32% 62% 96% 57 130 165 158 137 0.0 74.4 63
82.5 76 343 35 1707 30% 56% 96% 55 127 162 156 140 0.0 82.2 58
77.5 68 539 35 1687 27% 50% 97% 54 125 160 155 142 0.0 88.5 53
72.5 61 686 35 1671 24% 45% 97% 54 123 158 154 143 0.0 93.6 50
67.5 55 707 35 1658 22% 41% 98% 53 122 157 154 145 0.0 97.7 47
62.5 50 679 35 1647 20% 37% 98% 52 120 155 153 146 0.0 101.1 45
57.5 45 392 35 1638 18% 33% 98% 52 120 155 152 147 0.0 103.8 43
52.5 40 217 35 1631 16% 30% 98% 52 119 154 152 147 0.0 106.0 41
47.5 36 35 35 1625 15% 27% 99% 51 118 153 152 148 0.0 107.8 40
42.5 33 7 35 1620 13% 24% 99% 51 118 153 151 148 0.0 109.2 39
37.5 29 1 35 1616 12% 22% 99% 51 117 152 151 149 0.0 110.4 38
32.5 26 0 35 1613 11% 20% 99% 51 117 152 151 149 0.0 111.3 38
27.5 24 0 35 1610 10% 18% 99% 51 117 152 151 149 0.0 112.1 37
22.5 21 0 35 1607 9% 16% 99% 51 116 151 151 149 0.0 112.7 37
17.5 19 0 35 1605 8% 14% 99% 50 116 151 151 150 0.0 113.2 36
12.5 17 0 35 1603 7% 13% 100% 50 116 151 151 150 0.0 113.6 36
7.5 16 0 35 1602 6% 12% 100% 50 116 151 151 150 0.0 113.9 36

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
 Reduce Average Hydronic Flow
at total flow reduction

∆p ∆p P1- pump effective

P6, (3 to 6) setpt, P1calc, delta-p, %peak Pump Pump Flow, Motor VFD Pump Pump incremental effective net
feet feet feet P1calc feet Residual PSI effy effy HP gpm effy effy kW kWh exponent exponent
50.1 95.7 115 35 0.0 0.0 54.7 100% 56% 6.8 120 94% ### ###
46.3 107.3 115 35 0.0 8.1 56.5 98% 55% 6.2 104 94% ### ### ###
46.3 107.3 115 35 0.0 8.1 56.5 98% 55% 6.2 104 94% ### ### ###
44.1 113.4 115 35 0.0 1.9 57.3 94% 53% 5.9 93 94% ### ### ### ### #VALUE!
42.4 115.3 115 35 0.0 0.0 56.6 90% 51% 5.5 84 94% ### ### ### ### #VALUE!
41.0 115.3 115 35 0.0 0.0 55.4 86% 48% 5.0 76 93% ### ### ### ### #VALUE!
39.9 115.3 115 35 0.0 0.0 54.4 82% 46% 4.7 68 93% ### ### ### ### #VALUE!
38.9 115.3 115 35 0.0 0.0 53.6 77% 43% 4.4 61 92% ### ### ### ### #VALUE!
38.2 115.3 115 35 0.0 0.0 52.9 72% 41% 4.2 55 92% ### ### ### ### #VALUE!
37.6 115.3 115 35 0.0 0.0 52.4 67% 38% 4.0 50 92% ### ### ### ### #VALUE!
37.1 115.3 115 35 0.0 0.0 52.0 63% 35% 3.9 45 91% ### ### ### ### #VALUE!
36.7 115.3 115 35 0.0 0.0 51.6 58% 32% 3.7 40 91% ### ### ### ### #VALUE!
36.4 115.3 115 35 0.0 0.0 51.3 53% 30% 3.6 36 91% ### ### ### ### #VALUE!
36.1 115.3 115 35 0.0 0.0 51.1 49% 28% 3.5 33 90% ### ### ### ### #VALUE!
35.9 115.3 115 35 0.0 0.0 50.9 45% 25% 3.4 29 90% ### ### ### ### #VALUE!
35.7 115.3 115 35 0.0 0.0 50.8 41% 23% 3.4 26 90% ### ### ### ### #VALUE!
35.6 115.3 115 35 0.0 0.0 50.7 38% 21% 3.3 24 89% ### ### ### ### #VALUE!
35.5 115.3 115 35 0.0 0.0 50.6 34% 19% 3.3 21 89% ### ### ### ### #VALUE!
35.4 115.3 115 35 0.0 0.0 50.5 31% 18% 3.2 19 89% ### ### ### ### #VALUE!
35.3 115.3 115 35 0.0 0.0 50.4 28% 16% 3.2 17 89% ### ### ### ### #VALUE!
35.3 115.3 115 35 0.0 0.0 50.4 26% 15% 3.2 16 89% ### ### ### ### #VALUE!
18

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
 Reduce Average Hydronic Flow

Regression: Pump power vs. flow Note: Regressions may be inaccurate if appropriate flows are not input for all 20 load conditions

#VALUE! #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #N/A #N/A
#VALUE! 6 #N/A #N/A
#VALUE! #VALUE! #N/A #N/A
Third order equation - (see LINEST in excel help documentation for additional explanation)
#VALUE!

#VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #N/A
#VALUE! 17 #N/A
#VALUE! #VALUE! #N/A
Second order equation - (see LINEST in excel help documentation for additional explanation)
#VALUE!

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
Calculation of Savings from Reducing the Static Pressure Setpoint
Methodology
Remove pipe obstructions

Flow, % Flow, pump min ∆p valve

Ambient Flow, Hours at P1, Speed, of max at % of %max pump head, P2, P3, P4, (4 to 5) throttle P5,
Temp, ºF gpm Flow feet RPM RPM MaxEff delta-p ∆p, psi feet feet feet feet feet ∆p feet
Design 120 35 1750 46% 89% 91% 55 126 161 146 104 0.0 12.2 92
102.5 104 2 35 1496 46% 77% 90% 40 92 127 115 84 0.0 6.9 77
Improved: Valve controls flow; VFD controls

97.5 104 35 35 1496 46% 77% 90% 40 92 127 115 84 0.0 6.9 77
92.5 93 84 35 1448 43% 69% 92% 38 87 122 113 88 0.0 18.7 69
87.5 84 133 35 1408 40% 62% 93% 37 84 119 112 91 0.0 28.3 63
82.5 76 343 35 1376 37% 56% 95% 35 81 116 110 94 0.0 36.1 58
77.5 68 539 35 1350 34% 50% 95% 34 79 114 109 96 0.0 42.4 53
72.5 61 686 35 1330 31% 45% 96% 34 77 112 108 97 0.0 47.5 50
67.5 55 707 35 1313 28% 41% 97% 33 76 111 107 99 0.0 51.6 47
62.5 50 679 35 1299 25% 37% 97% 32 74 109 107 100 0.0 54.9 45
57.5 45 392 35 1288 23% 33% 98% 32 73 108 106 101 0.0 57.7 43
∆p

52.5 40 217 35 1279 21% 30% 98% 32 73 108 106 101 0.0 59.8 41
47.5 36 35 35 1272 19% 27% 98% 31 72 107 106 102 0.0 61.6 40
42.5 33 7 35 1266 17% 24% 98% 31 71 106 105 102 0.0 63.1 39
37.5 29 1 35 1261 16% 22% 99% 31 71 106 105 103 0.0 64.2 38
32.5 26 0 35 1257 14% 20% 99% 31 71 106 105 103 0.0 65.2 38
27.5 24 0 35 1253 13% 18% 99% 31 70 105 105 103 0.0 65.9 37
22.5 21 0 35 1250 11% 16% 99% 31 70 105 105 103 0.0 66.6 37
17.5 19 0 35 1248 10% 14% 99% 30 70 105 105 104 0.0 67.1 36
12.5 17 0 35 1246 9% 13% 99% 30 70 105 105 104 0.0 67.5 36
7.5 16 0 35 1244 8% 12% 99% 30 70 105 104 104 0.0 67.8 36

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
 Remove pipe obstructions
at total flow reduction

∆p ∆p P1- pump effective effective

P6, (3 to 6) setpt, P1calc, delta-p, %peak Pump Pump Flow, Motor VFD Pump Pump incremental net
feet feet feet P1calc feet Residual PSI effy effy HP gpm effy effy kW kWh exponent exponent
50.1 95.7 115 35 0.0 0.0 54.7 100% 56% 6.8 120 94% ### ###
46.3 69.2 69 35 0.0 0.0 39.9 100% 56% 4.3 104 92% ### ### ###
46.3 69.2 69 35 0.0 0.0 39.9 100% 56% 4.3 104 92% ### ### ###
44.1 69.2 69 35 0.0 0.0 38.0 100% 56% 3.7 93 91% ### ### ### ### #VALUE!
42.4 69.2 69 35 0.0 0.0 36.5 98% 55% 3.3 84 89% ### ### ### ### #VALUE!
41.0 69.2 69 35 0.0 0.0 35.3 95% 54% 2.9 76 87% ### ### ### ### #VALUE!
39.9 69.2 69 35 0.0 0.0 34.3 92% 52% 2.6 68 86% ### ### ### ### #VALUE!
38.9 69.2 69 35 0.0 0.0 33.5 88% 49% 2.4 61 84% ### ### ### ### #VALUE!
38.2 69.2 69 35 0.0 0.0 32.9 84% 47% 2.2 55 82% ### ### ### ### #VALUE!
37.6 69.2 69 35 0.0 0.0 32.3 79% 44% 2.1 50 80% ### ### ### ### #VALUE!
37.1 69.2 69 35 0.0 0.0 31.9 74% 42% 2.0 45 79% ### ### ### ### #VALUE!
36.7 69.2 69 35 0.0 0.0 31.6 69% 39% 1.9 40 77% ### ### ### ### #VALUE!
36.4 69.2 69 35 0.0 0.0 31.3 65% 36% 1.8 36 76% ### ### ### ### #VALUE!
36.1 69.2 69 35 0.0 0.0 31.1 60% 34% 1.8 33 75% ### ### ### ### #VALUE!
35.9 69.2 69 35 0.0 0.0 30.9 55% 31% 1.7 29 74% ### ### ### ### #VALUE!
35.7 69.2 69 35 0.0 0.0 30.7 51% 29% 1.7 26 73% ### ### ### ### #VALUE!
35.6 69.2 69 35 0.0 0.0 30.6 47% 26% 1.6 24 72% ### ### ### ### #VALUE!
35.5 69.2 69 35 0.0 0.0 30.5 43% 24% 1.6 21 72% ### ### ### ### #VALUE!
35.4 69.2 69 35 0.0 0.0 30.4 39% 22% 1.6 19 71% ### ### ### ### #VALUE!
35.3 69.2 69 35 0.0 0.0 30.4 36% 20% 1.5 17 71% ### ### ### ### #VALUE!
35.3 69.2 69 35 0.0 0.0 30.3 33% 18% 1.5 16 70% ### ### ### ### #VALUE!
0

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
 Remove pipe obstructions

Regression: Pump power vs. flow Note: Regressions may be inaccurate if appropriate flows are not input for all 20 load conditions

#VALUE! #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #N/A #N/A
#VALUE! 6 #N/A #N/A
#VALUE! #VALUE! #N/A #N/A
Third order equation - (see LINEST in excel help documentation for additional explanation)
#VALUE!

#VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #N/A
#VALUE! 17 #N/A
#VALUE! #VALUE! #N/A
Second order equation - (see LINEST in excel help documentation for additional explanation)
#VALUE!

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
Calculation of Savings from adding Static Pressure Reset
Methodology
Reset Static Pressure Setpoint by Coil PID

Flow, % Flow, pump min ∆p valve

Ambient Flow, Hours at P1, Speed, of max at % of %max pump head, P2, P3, P4, (4 to 5) throttle P5,
Temp, ºF gpm Flow feet RPM RPM MaxEff delta-p ∆p, psi feet feet feet feet feet ∆p feet
Design 120 35 1750 46% 89% 91% 55 126 161 146 104 0.0 12.2 92
102.5 104 2 35 1446 48% 77% 90% 37 85 120 109 77 0.0 0.0 77
97.5 104 35 35 1446 48% 77% 90% 37 85 120 109 77 0.0 0.0 77
92.5 93 84 35 1302 48% 69% 90% 30 69 104 95 69 0.0 0.0 69
87.5 84 133 35 1172 48% 62% 90% 24 56 91 83 63 0.0 0.0 63
82.5 76 343 35 1054 48% 56% 90% 20 45 80 74 58 0.0 0.0 58
With reset of ∆p setpoint

77.5 68 539 35 949 48% 50% 90% 16 37 72 67 53 0.0 0.0 53

72.5 61 686 35 854 48% 45% 90% 13 30 65 61 50 0.0 0.0 50
67.5 55 707 35 769 48% 41% 90% 10 24 59 56 47 0.0 0.0 47
62.5 50 679 35 692 48% 37% 90% 8 19 54 52 45 0.0 0.0 45
57.5 45 392 35 623 48% 33% 90% 7 16 51 49 43 0.0 0.0 43
52.5 40 217 35 560 48% 30% 90% 6 13 48 46 41 0.0 0.0 41
47.5 36 35 35 504 48% 27% 90% 4 10 45 44 40 0.0 0.0 40
42.5 33 7 35 472 46% 24% 91% 4 9 44 43 40 0.0 0.8 39
37.5 29 1 35 457 43% 22% 92% 4 9 44 43 40 0.0 1.9 38
32.5 26 0 35 445 40% 20% 94% 4 8 43 43 41 0.0 2.9 38
27.5 24 0 35 435 36% 18% 95% 4 8 43 43 41 0.0 3.7 37
22.5 21 0 35 427 33% 16% 96% 3 8 43 42 41 0.0 4.3 37
17.5 19 0 35 420 31% 14% 96% 3 8 43 42 41 0.0 4.8 36
12.5 17 0 35 415 28% 13% 97% 3 8 43 42 41 0.0 5.2 36
7.5 16 0 35 411 25% 12% 97% 3 7 42 42 41 0.0 5.5 36

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
 Reset Static Pressure Setpoint by Coil PID
at total flow reduction

∆p ∆p P1- pump effective effective

P6, (3 to 6) setpt, P1calc, delta-p, %peak Pump Pump Flow, Motor VFD Pump Pump incremental net
feet feet feet P1calc feet Residual PSI effy effy HP gpm effy effy kW kWh exponent exponent
50.1 95.7 115 35 0.0 0.0 54.7 100% 56% 6.8 120 94% ### ###
46.3 62.3 62 35 0.0 0.0 36.9 100% 56% 4.0 104 92% ### ### ###
46.3 62.3 62 35 0.0 0.0 36.9 100% 56% 4.0 104 92% ### ### ###
44.1 50.5 50 35 0.0 0.0 29.9 100% 56% 2.9 93 87% ### ### ### ### #VALUE!
42.4 40.9 41 35 0.0 0.0 24.2 100% 56% 2.1 84 80% ### ### ### ### #VALUE!
41.0 33.1 33 35 0.0 0.0 19.6 100% 56% 1.5 76 71% ### ### ### ### #VALUE!
39.9 26.8 27 35 0.0 0.0 15.9 100% 56% 1.1 68 60% ### ### ### ### #VALUE!
38.9 21.7 22 35 0.0 0.0 12.9 100% 56% 0.8 61 49% ### ### ### ### #VALUE!
38.2 17.6 18 35 0.0 0.0 10.4 100% 56% 0.6 55 39% ### ### ### ### #VALUE!
37.6 14.3 14 35 0.0 0.0 8.4 100% 56% 0.4 50 31% ### ### ### ### #VALUE!
37.1 11.5 12 35 0.0 0.0 6.8 100% 56% 0.3 45 24% ### ### ### ### #VALUE!
36.7 9.4 9 35 0.0 0.0 5.5 100% 56% 0.2 40 18% ### ### ### ### #VALUE!
36.4 7.6 8 35 0.0 0.0 4.5 100% 56% 0.2 36 13% ### ### ### ### #VALUE!
36.1 6.9 7 35 0.0 0.0 4.0 100% 56% 0.1 33 11% ### ### ### ### #VALUE!
35.9 6.9 7 35 0.0 0.0 3.8 100% 56% 0.1 29 9% ### ### ### ### #VALUE!
35.7 6.9 7 35 0.0 0.0 3.6 98% 55% 0.1 26 8% ### ### ### ### #VALUE!
35.6 6.9 7 35 0.0 0.0 3.5 95% 53% 0.1 24 7% ### ### ### ### #VALUE!
35.5 6.9 7 35 0.0 0.0 3.4 92% 51% 0.1 21 7% ### ### ### ### #VALUE!
35.4 6.9 7 35 0.0 0.0 3.3 88% 49% 0.1 19 6% ### ### ### ### #VALUE!
35.3 6.9 7 35 0.0 0.0 3.3 83% 47% 0.1 17 6% ### ### ### ### #VALUE!
35.3 6.9 7 35 0.0 0.0 3.2 79% 44% 0.1 16 5% ### ### ### ### #VALUE!
0

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst
 Reset Static Pressure Setpoint by Coil PID

Regression: Pump power vs. flow Note: Regressions may be inaccurate if appropriate flows are not input for all 20 load conditions

#VALUE! #VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #N/A #N/A
#VALUE! 6 #N/A #N/A
#VALUE! #VALUE! #N/A #N/A
Third order equation - (see LINEST in excel help documentation for additional explanation)
#VALUE!

#VALUE! #VALUE! #VALUE!

#VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #N/A
#VALUE! 17 #N/A
#VALUE! #VALUE! #N/A
Second order equation - (see LINEST in excel help documentation for additional explanation)
#VALUE!

Project Name CHW CP-3 12/1/2024

Building Owner Main Chilled Water Firm or Analyst