TABLE OF CONTENTS The spreadsheet for pinch calculations may be downloaded from "http://books.elsevier.com/companions/0750682604".
When the spreadsheet is opened, it takes you directly to the INPUT tab, where the data is entered.
On the INPUT tab, enter the global ? T min chosen for the problem in cell F6, followed by the stream data. Note that the data must be in compatible units, as described in Section 8.4.5. The default spreadsheet display assumes that SI-based metric units are in use, but you can use your own units and alter the cell headings. You can also choose whether to enter the data as specific heat capacity and mass flowrate, heat capacity flowrate ( CP) or heat flow.
Enter the stream data, line by line. As you begin each line, cells requiring input are highlighted in yellow. Streams can be numbered, named or both. If a stream changes heat capacity significantly over the temperature range, enter each segment separately (e.g. as 3a, 3b, 3c, etc.). Enter latent heat streams by assigning them a small temperature difference, say 0.1 C.
As data is entered, the spreadsheet automatically calculates the full stream data, which can be seen on the right-hand side of the first tab and on other "results" tabs. The program calculates whether a stream is hot or cold depending on the difference between the supply and target temperatures. All heat capacity flowrates ( CP) should be positive, never negative.
The furthest left-hand tab, INDEX, gives a list of all...
