Pinch Analysis Spreadsheet Overview
Pinch Analysis Spreadsheet Overview
TABLE OF CONTENTS:
INPUT Input Data Input problem data, i.e. stream temperatures, stream names, stream properties
PT Problem Table & Cascade Problem table, heat cascade, pinch identification, problem type, min utility requi
CC Composite Curves Composite curve plot.
SCC Shifted Composite Curves Shifted composite curve plot.
GCC Grand Composite Curve Grand composite plot.
GRID Grid Diagram Schematic showing hot and cold shfted streams and the pinch location.
AS Actual Streams Schematic showing actual streams.
AT Actual Intervals Table Calculation table for actual composite curves.
SS Shifted Streams Schematic showing shifted streams.
ST Shifted Intervals Table Calculation table for shifted composite curves.
DTMIN Varying dTmin global Pinch analysis over a range of dTmin values.
curves.
curves.
values.
actors.
Input Data
1. Select Input Method from the Dropdown list: Heat Capacity Flowrate
3. Select appropriate units for the input data from the drop down lists below (E15/F15). Requires Input -
Optional Input -
4. Input data: Stream Name, Temperatures & Heat/Flow Data (max 50 streams). Calculation cell -
180
160
140
120
100
80
60
40
20
Heat Flow (k Actual Temperature (°C)
Heat Flow (k Actual Temperature (°C)
Heat Flow(MJ/
0 Actual Temperature (°F)
Heat Flow (Mbtu(IT)/hr)
0 1000 2000 3000 4000 5000 6000 7000 8000 9000
180
Shifted Temperature (°C)
160
140
120
100
80
60
40
20
Heat Flow Shifted Temperature (°C)
Heat Flow Shifted Temperature (°C)
Heat Flow(Shifted
0 Temperature (°F)
Heat Flow (Mbtu(IT)/hr)
0 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000
Heat Flow (kW)
0
0 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000
Heat Flow (kW)
Grand Composite
180
Shifted Temperature (°C)
160
140
120
100
80
60
0
0 500 1000 1500 2000 2500 3
165
155
135
130
101
55
35
25
mCp (kW/K)
Name (kW) Temp (°C)
H1 3100 31 HOT
▼
●
|
H2 3850 35 HOT
▼
●
|
C1 2375 25 COLD
●
|
|
C2 3840 60 COLD
●
|
|
Stream H1 H2 C1 C2
Heat Flow (kW) 31.0 35.0 25.0 60.0
Actual Temp
Interval HOT HOT COLD COLD
(°C)
160 ● ▲
1 | |
140 | ● |
2 | | |
125 | | ▲ |
3 | | | |
96 | | | ●
4 | | |
60 ▼ | |
5 | |
30 ▼ ●
Actual Intervals Table
Actual Temperature T(i+1)-Ti CpHot dHHot Hot Duty CpCold dHCold Cold Duty
°C kW/K kW kW kW/K kW kW
160 6950.0 8651.0
20 31.0 620.0 60.0 1200.0
140 6330.0 7451.0
15 66.0 990.0 60.0 900.0
125 5340.0 6551.0
29 66.0 1914.0 85.0 2465.0
96 3426.0 4086.0
36 66.0 2376.0 25.0 900.0
60 1050.0 3186.0
30 35.0 1050.0 25.0 750.0
30 0.0 2436.0
Stream H1 H2 C1 C2
mCp (kW/K) 31.0 35.0 25.0 60.0
Heat Flow (kW) 3100.0 3850.0 2375.0 3840.0
Shifted Temp
Interval HOT HOT COLD COLD
(°C)
165 ▲
1 |
155 ● |
2 | |
Shifted Intervals Table
P in c h T e m p e ra tu re (°C )
This sheet will set up a case study to report the pinch temperature and the min utility requirements for varying dTmin globa
IMPORTANT: Using this function will clear all dTcontrib information from individual streams (reverting to dTmin global for a
Max dTmin 20 °C
Min dTmin 10 °C
Varying Pi
2. Click this button to run the case and re-plot the adjacent charts.
155
Run Case 150
145
140
Plot Data (No entry required):
135
130
dTmin Hot Pinch Cold Pinch Hot Utility Cold Utility
125
°C °C °C kW kW
120
10 150 130 2300 700 8 10
2500
2000
1500
1000
500
0
8 10
nts for varying dTmin global values within a specified range.
verting to dTmin global for all streams).
155
150
145
Pinch Temperature (°C)
140
Pinch Temperature (°C)
Pinch Temperature (°F)
135
dTmin global (°C)
130
dTmin global (°C)
125
dTmin global (°F)
120
8 10 12 14 16 18 20
2000
1500
1000
500
0
8 10 12 14 16 18 20
Conversion Factors:
Heat Capacity Conversion FaHeat Duty Conversion FactoMass Flowrate
Select Units Select Units Select Units
kW/K 1 kW 1 kg/s
W/K 1000 Btu(IT)/sec 0.94781712 kg/h
kcal(IT)/°Csec 0.238845897 Btu(IT)/min 56.869027219 lb/min
Btu(IT)/°Fs 0.52656506 kcal(IT)/sec 0.238845897 lb/h
kcal(IT)/h 859.845227859 US ton(short)/h
hp (boiler) 0.101941995 UK ton(long)/h
ton(metric)/h
°C °C °C °C
H1 160.0 60.0 5 155 10
H2 140.0 30.0 5 135
C1 30.0 125.0 5 35
C2 96.0 160.0 5 101
Temperature Units:
°C Name of unit Symbol Relation to SI units Relation to °C
°F kelvin K SI base unit T[K] = T[°C] + 273.15
K degree Celsius °C T[°C] = T[K] − 273.15
R degree Rankine °R; °Ra T[°Ra] = 1.8 × T[K]
degree Fahrenheit °F T[°F] = T[K] × 1.8 − 459.67 T[°F] = 1.8 × T[°C] + 32
Output Options
SI Metric
Heat Heat
Capacity Conversion Conversion Capacity
Flowrate Flowrate
kW/K 0 mCp
kW/K MJ/h/K
31 1 31 111.60000
35 1 35 126.00000
25 1 25 90.00000
60 1 60 216.00000
°C
kW/K
kW
eat Capacity
Temperature Options
English SI/Metric English
Supply
Target DTMIN
Supply Temperature Target Temperature Temperatu
Temperature CONTRIB
re
MBtu(IT)/hr/°F °C °C °F °F °C
16.3235222333333 160.0 60.0 320.0 140.0 5
18.4297831666667 140.0 30.0 284.0 86.0 5
13.1641308333333 30.0 125.0 86.0 257.0 5
31.593914 96.0 160.0 204.8 320.0 5
DTMIN DTMIN DTMIN Input Error
GLOBAL CONTRIB GLOBAL Detection
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
NO SUPPLY
TEMP
NO STREAM NO SUPPLY NO TARGET
NOTEMP
PRIMARY HEAT DATA
Non numerical entry
supply target dtmincontrib Prim Heat Sec Heat
A2. Plot Tables