夹点温度、最小公用工程计算excel表格Pinch_Spreadsheet_NOV06_FINAL.xlsVIP

A2

A1

DTMIN

ST

SS

AT

AS

GRID

GCC

SCC

CC

PT

INPUT

INDEX

EC

HCF

HL

MF

OUnits

SHC

Temp

Type

Units

Units2

Cold

Composite

Hot

Grand

Utility

SERIES

PinchAnalysisSpreadsheet

TABLEOFCONTENTS:

INPUT

InputData

Inputproblemdata,i.e.streamtemperatures,streamnames,streampropertiesanddTmincriteria.

PT

ProblemTableCascade

Problemtable,heatcascade,pinchidentification,problemtype,minutilityrequirements.

CC

CompositeCurves

Compositecurveplot.

SCC

ShiftedCompositeCurves

Shiftedcompositecurveplot.

GCC

GrandCompositeCurve

Grandcompositeplot.

GRID

GridDiagram

Schematicshowinghotandcoldshftedstreamsandthepinchlocation.

AS

ActualStreams

Schematicshowingactualstreams.

AT

ActualIntervalsTable

Calculationtableforactualcompositecurves.

SS

ShiftedStreams

Schematicshowingshiftedstreams.

ST

ShiftedIntervalsTable

Calculationtableforshiftedcompositecurves.

DTMIN

VaryingdTminglobal

PinchanalysisoverarangeofdTminvalues.

A1

Set-upandconversions

Configurationpagelistingconversionfactors.

A2

Plottables

Tabulationofplotvalues.

1.SelectInputMethodfromtheDropdownlist:

HeatCapacityFlowrate

2.InputGlobaldTminselectinputtemperatureunits:

°C

3.Selectappropriateunitsfortheinputdatafromthedropdownlistsbelow(E15/F15).

RequiresInput-

OptionalInput-

4.Inputdata:StreamName,TemperaturesHeat/FlowData(max50streams).

Calculationcell-

5.Selectdesiredoutputunitset:

SI-based(kW/K)

StreamName

SupplyTemperature

TargetTemperature

dTMinContrib

HeatFlow

StreamType

SupplyShift

TargetShift

kW/K

ShiftTemperature

Interval

T(i+1)-Ti

mCpnet

dH

InfeasibleCascade

FeasibleCascade

HotPinch

▼

ColdPinch

MinHotUtility

MinColdUtility

HeatFlow(kW)

ActualTemperature(°C)

HeatFlow(MJ/h)

ActualTemperature(°F)

HeatFlow(Mbtu(IT)/hr)

ShiftedTemperature(°C)

ShiftedTemperature(°F)

NetHeatFlow(kW)

NetHeatFlow(MJ/h)

NetHeatFlow(Mbtu(IT)/hr)

Stream

ActualTemperature

CpH