2
$\begingroup$

Is it possible to model a heat pump cycle without using tools like EES, but using Excel? I am considering to use Refprop application as an add-in in Excel, and model a heat pump cycle. Another alternative would be to create a P-h database for various fluids, and go from very complicated series of equations to find pressure, temperature, and density values.

$\endgroup$
2
$\begingroup$

You can do this.

I set up a sheet using vlookup to interpolate through fluid characteristics and because the source data I used (from steam tables) had a 5 degree increment I had to build an interpolation function using several vlookups / I will let you do that as it is good experience.

$\endgroup$
4
  • $\begingroup$ thank you for the confirmation Solar Mike ; i wonder if there are simpler solutions out there. $\endgroup$ –  xavc Jan 7 '20 at 8:59
  • 1
    $\begingroup$ I wrote a nice formula that interpolates a value based on excel's 'smoothed line'. It looks pretty complicated, but there are only three inputs, namely Known Data Range X, Known Data Range Y, and Desired Point X. $\endgroup$ – Jonathan R Swift Jan 7 '20 at 13:27
  • 1
    $\begingroup$ @JonathanRSwift looks like you and I did about the same thing, but I stuck with linear interpolation as that was equivalent to manually using the steam tables. Good learning experience though :) $\endgroup$ – Solar Mike Jan 7 '20 at 13:29
  • $\begingroup$ @Solar Mike i have found out Coolprop add-in for Excel, which seems reallly promising. coolprop.org/coolprop/wrappers/Excel/index.html $\endgroup$ –  xavc Jan 8 '20 at 10:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.