Pinch Analysis Spreadsheet

Paul McLaughlin

Enter data in the grey cells on the Input sheet as required.

Do not touch any other cell - all information is calculated automatically.

For streams with variable heat capacities, break down into multiple sections with distinct CP values
with upper and lower temperatures covering the whole range of the full stream.

Output tables of data are shown on the Results sheet, the Grand Composite Curve is on the GCC
sheet, hot and cold composite curves with shifted temperatures are on SCC and curves with true
stream temperatures are on TCC.

Selecting the graph tabs before entering data may bring up an Excel error - ignore this as it will not
have any adverse impact upon the operation of this spreadsheet.
Data Input
Number of streams 4 Temperatures °C
DTmin 20 °C CPs kW / °C
Physical Units Metric Heat Loads kW

Stream Table

Stream Temperature (°C) CP Type Shifted Temperature (°C) Heat Load

No. Name Supply Target kW / °C Cont. Supply Target kW
1 Hot Stream 1 260 160 30000 Hot -10 250 150 3000000
2 Hot Stream 2 250 130 15000 Hot -10 240 120 1800000
3 Hot Stream 3 120 235 20000 Cold 10 130 245 -2300000
4 Cold Stream 1 180 240 40000 Cold 10 190 250 -2400000
5 X X X X X X
6 X X X X X X
7 X X X X X X
8 X X X X X X
9 X X X X X X
10 X X X X X X
11 X X X X X X
12 X X X X X X
13 X X X X X X
14 X X X X X X
15 X X X X X X
16 X X X X X X
17 X X X X X X
18 X X X X X X
19 X X X X X X
20 X X X X X X
Hot Stream Table

Number of hot streams 2

Hot Stream Stream Temperature (°C) CP Heat Load

No. Name No. SupplyA SupplyS TargetA TargetS kW / °C kW
1 Hot Stream 1 1 260 250 160 150 30000 3000000
2 Hot Stream 2 2 250 240 130 120 15000 1800000
3 X X X X X X X X X
4 X X X X X X X X X
5 X X X X X X X X X
6 X X X X X X X X X
7 X X X X X X X X X
8 X X X X X X X X X
9 X X X X X X X X X
10 X X X X X X X X X
11 X X X X X X X X X
12 X X X X X X X X X
13 X X X X X X X X X
14 X X X X X X X X X
15 X X X X X X X X X
16 X X X X X X X X X
17 X X X X X X X X X
18 X X X X X X X X X
19 X X X X X X X X X
20 X X X X X X X X X

Cold Stream Table

Number of cold streams 2

Cold Stream Stream Temperature (°C) CP Heat Load

No. Name No. SupplyA SupplyS TargetA TargetS kW / °C kW
1 Hot Stream 3 3 120 130 235 245 -20000 -2300000
2 Cold Stream 1 4 180 190 240 250 -40000 -2400000
3 X X X X X X X X X
4 X X X X X X X X X
5 X X X X X X X X X
6 X X X X X X X X X
7 X X X X X X X X X
8 X X X X X X X X X
9 X X X X X X X X X
10 X X X X X X X X X
11 X X X X X X X X X
12 X X X X X X X X X
13 X X X X X X X X X
14 X X X X X X X X X
15 X X X X X X X X X
16 X X X X X X X X X
17 X X X X X X X X X
18 X X X X X X X X X
19 X X X X X X X X X
20 X X X X X X X X X
Temperatures Tables

Number of shifted temps 7

No. Temperature (°C) Duplicate Rank Stripped Actual Rank Temp

1 250 0 1 1 7 1 120
2 240 0 4 4 5 2 130
3 130 0 7 7 2 3 150
4 190 0 5 5 4 4 190
5 X 1 X X X 5 240
6 X 1 X X X 6 245
7 X 1 X X X 7 250
8 X 1 X X X 8 X
9 X 1 X X X 9 X
10 X 1 X X X 10 X
11 X 1 X X X 11 X
12 X 1 X X X 12 X
13 X 1 X X X 13 X
14 X 1 X X X 14 X
15 X 1 X X X 15 X
16 X 1 X X X 16 X
17 X 1 X X X 17 X
18 X 1 X X X 18 X
19 X 1 X X X 19 X
20 X 1 X X X 20 X
21 150 0 6 6 3 21 X
22 120 0 8 8 1 22 X
23 245 0 3 3 6 23 X
24 250 1 1 X X 24 X
25 X 1 X X X 25 X
26 X 1 X X X 26 X
27 X 1 X X X 27 X
28 X 1 X X X 28 X
29 X 1 X X X 29 X
30 X 1 X X X 30 X
31 X 1 X X X 31 X
32 X 1 X X X 32 X
33 X 1 X X X 33 X
34 X 1 X X X 34 X
35 X 1 X X X 35 X
36 X 1 X X X 36 X
37 X 1 X X X 37 X
38 X 1 X X X 38 X
39 X 1 X X X 39 X
40 X 1 X X X 40 X

Maximum shifted temperature 250

Maximum shifted hot temp 250

Rank is 7
Minimum shifted hot temp 120
Rank is 1
Maximum shifted cold temp 250
Rank is 7
Minimum shifted cold temp 130
Rank is 2
Calculations
Interval 1 2 3 4 5 6 X X X X X X
Tmin 120 130 150 190 240 245 X X X X X X
Tmax 130 150 190 240 245 250 X X X X X X
1 0 0 30000 30000 30000 30000 X X X X X X
2 15000 15000 15000 15000 0 0 X X X X X X
3 0 -20000 -20000 -20000 -20000 0 X X X X X X
4 0 0 0 -40000 -40000 -40000 X X X X X X
5 X X X X X X X X X X X X
6 X X X X X X X X X X X X
7 X X X X X X X X X X X X
8 X X X X X X X X X X X X
Stream CPs

9 X X X X X X X X X X X X
10 X X X X X X X X X X X X
11 X X X X X X X X X X X X
12 X X X X X X X X X X X X
13 X X X X X X X X X X X X
14 X X X X X X X X X X X X
15 X X X X X X X X X X X X
16 X X X X X X X X X X X X
17 X X X X X X X X X X X X
18 X X X X X X X X X X X X
19 X X X X X X X X X X X X
20 X X X X X X X X X X X X
CPi 15000 -5000 25000 -15000 -30000 -10000 X X X X X X
DHi 150000 -100000 1000000 -750000 -150000 -50000 X X X X X X
DHi,Hot 150000 300000 1800000 2250000 150000 150000 X X X X X X
DHi,Cold 0 -400000 -800000 -3000000 -300000 -200000 X X X X X X
Ts 120 130 150 190 240 245 250 X X X X X
Heat Cascade 100000 -50000 50000 -950000 -200000 -50000 0 X X X X X
Problem Table 1050000 900000 1000000 0 750000 900000 950000 X X X X X
Pinch Point 0 0 0 1 0 0 0 0 0 0 0 0
Pinch Text 190 190 190 190 190 190 190 190 190

QH,min 950000
QC,min 1050000
Pinch Point 190

Ts 120 130 150 190 240 245 250 X X X X X

Thot 130 140 160 200 250 255 260 X X X X X
Tcold 110 120 140 180 230 235 240 X X X X X
Hot Cascade 0 150000 450000 2250000 4500000 4650000 4800000 X X X X X
Cold Cascade 1050000 1050000 1450000 2250000 5250000 5550000 5750000 X X X X X

Single Pinch 1
Threshold Problem 0
Multiple Pinch 0
Pinch Region 0
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
 X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
0 0 0 0 0 0 0 0 0 0 0 0 0 0
190 190 190 190 190 190 190 190 190 190 190 190 190 190

X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
X X X X X X X X X X X X X
 X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
0 0 0 0 0 0 0 0 0 0 0 0 0 0
190 190 190 190 190 190 190 190 190 190 190 190 190 190

X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
X X X X X X X X X X X X X X
Results

Stream Table

Stream Temperatures (°C) Type CP Heat Load

No. Name Supply Target (kW / °C) (kW)
1 Hot Stream 1 260 160 Hot 30000 3000000
2 Hot Stream 2 250 130 Hot 15000 1800000
3 Hot Stream 3 120 235 Cold -20000 -2300000
4 Cold Stream 1 180 240 Cold -40000 -2400000
Problem Table

Minimum hot utility = 950000 kW

Minimum cold utility = 1050000 kW

Net Heat Load (kW) Shifted Temperature (°C)

### 120.0
### 130.0
### 150.0
PINCH 0.0 190.0 PINCH
### 240.0
### 245.0
### 250.0
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X
X X

Pinch occurs at 190 °C

This is a single pinch problem

This is not a threshold problem
This is not a multiple pinch problem
This is not a pinch region problem
Composite Curves Tables

Cold Composite Curve Hot Composite Curve

Rank Temperature (°C) Heat Load Temperature (°C) Heat Load

Shifted Actual (kW) Shifted Actual (kW)
1 120 130 0
2 130 120 1050000 130 140 150000
3 150 140 1450000 150 160 450000
4 190 180 2250000 190 200 2250000
5 240 230 5250000 240 250 4500000
6 245 235 5550000 245 255 4650000
7 250 240 5750000 250 260 4800000
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
 Grand Composite Curve
Shifted Temperature (°C)

12

10

0
0 2 4 6 8 10 12
Net Heat Load (kW)
 True Composite Curves

12
Temperature (°C)

10

0
0 2 4 6 8 10 12
Heat Load (kW)
 Shifted Composite Curves
Shifted Temperature (°C)

12

10

0
0 2 4 6 8 10 12
Heat Load (kW)
Hot Cascade
Cold Cascade