Nishant:
Pay careful attention to what Breizh is telling you. You are obviously not thinking out the correct algorithm that you have to employ to do a mass & heat balance. This is basic chemical engineering and you must correctly think out what is happening in the process.
For example, you cannot have "condensate" (which is assumed to be saturated) at 110 oC & 25 kg/cm2A. I believe you have your thinking all wrong and you have to THROTTLE the 25 kg/cm2 down to 18 kg/cm2 so both can mix. Is that correct?
Another important engineering concept that you are using in a wrong way is the spreadsheet as a tool. Never use a spreadsheet to post basic calculation data in a text box! That is totally ignorant of what a spreadsheet tool is for. Use the cells to contain the data and use the spread sheet to do the calculations. Post all your thermo data in another spreadsheet within the same workbook and refer to that data in your calculations. That way you know your calculations are correct and accurate.
Refer to the attached revision of your spread sheet. Do the calculations the correct way and don't use a spread sheet as a bulletin board with data in text boxes.
Book1 Rev1.xlsx 18.32KB
88 downloads