Photovoltaic system, how to use experiences like heat pumps?

I am looking for a calculation/Excel spreadsheet to calculate the profitability of a photovoltaic system with a heat pump. Do you create these yourselves or does it go directly to a specialist/provider? I have already tried the spreadsheet on Test.de and Umweltinstitut.org. Unfortunately, there is no monthly distribution and calculation here to determine which combination is sensible to calculate the area of the collectors as economically as possible with self-consumption using a heat pump.

That is also not easily calculated. Besides, photovoltaics + heat pump is not the solution either.

These are two systems that are each complicated enough to assess on their own.

Furthermore, the photovoltaics provide energy exactly when you don't need it.

Either you find the heat pump economical even without photovoltaics, then you should install a heat pump. Or not.

And the same applies to photovoltaics. Either it is economical, then install it, or it is not, then don't.

There is only one thing where the two work well together, and that is hot water in summer. That is basically free and saves you about 5-10 euros per month. But that will not be decisive.

The rest of the interplay is nice to have.

The question remains whether optimized for self-consumption, but for that you would have to know your future EV and its distribution/peak loads (which you probably won't), or you focus on driving down the costs/kWp, which ends up with the whole roof being fully packed.

The latter would be my option.

Exactly for this reason, I am now trying to familiarize myself with this subject so that the salespeople cannot sell me everything.

How exactly do I determine:
- Hot water demand (50 l per person ??)
- Hot water storage tank size (double daily demand??)
- Heat demand
- Required electricity to operate the water heat pump (use for domestic hot water and heating)
- Required electricity to operate the water heat pump (only for heating / domestic hot water with solar power system)

I had to grin.
Acceptance of the better half for intelligent energy efficiency...

That's exactly how I do it too...

Regards