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.
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.