Joining the Renewable Heating Hub forums is completely free and only takes a minute. By registering you’ll be able to ask questions, join discussions, follow topics you’re interested in, bookmark useful threads and receive notifications when someone replies. Non-registered members also do not have access to our AI features. When choosing your username, please note that it cannot be changed later, so we recommend avoiding brand or product names. Before registering, please take a moment to read the Forum Rules & Terms of Use so we can keep the community helpful, respectful and informative for everyone. Thanks for joining!
Posted by: @jamespaPosted by: @derek-mI have now completed some further improvements to the modelling tool.
It is now possible to adjust the desired IAT setpoint and also the OAT value to one decimal place. This therefore provides the capability to ramp up and down the setpoint and more closely match variations in OAT.
Have fun in the 'Playroom'.
I downloaded your modelling tool but there are lots of '#value' in the playroom. Is there something I need to dial in to start it working?
Hi James,
Which cells contain '=value'?
About 50% of the play sheet. I'm guessing they all rely on or derive from one 'problem' cell.
I have an old version of Excel (2003) it could be that, although unlikely because it usually issues a warning if there are unsupported features. I will try to narrow down the root cause.
4kW peak of solar PV since 2011; EV and a 1930s house which has been partially renovated to improve its efficiency. 7kW Vaillant heat pump.
Had cop of 3.7 for yesterday/this morning, that seems lot better then what i had last winter, 3.04 last winter but that included dhw. Freezing at 5am this morning so running from 530-10-30 had used 27kwh, thats heavy, house now warm, prob too warm so switched off heating and will adjust curve down to 34 at- 5 and 26@20 try that tomorrow. That's a 12 degree difference to installer setting on cold side.
Posted by: @jamespaAbout 50% of the play sheet. I'm guessing they all rely on or derive from one 'problem' cell.
I have an old version of Excel (2003) it could be that, although unlikely because it usually issues a warning if there are unsupported features. I will try to narrow down the root cause.
Did you resolve the problem? If not, then please provide one cell location and I should be able to trace back to the cause.
I may be able to save the spreadsheet in a different format if that would help.
Unfortunately I didn't resolve it. #value cells include E1-AA1, D14, 16-18,20,23,24,31,32,36... but
opening it in Libre office calc seems to have fixed the problem. I will report back if I work out what the problem was!
4kW peak of solar PV since 2011; EV and a 1930s house which has been partially renovated to improve its efficiency. 7kW Vaillant heat pump.
Posted by: @jamespaUnfortunately I didn't resolve it. #value cells include E1-AA1, D14, 16-18,20,23,24,31,32,36... but
opening it in Libre office calc seems to have fixed the problem. I will report back if I work out what the problem was!
Hi James,
As you will have noticed I carried out quite a number of modifications to create the present version, one of which was to simulate the heat pump stopping and starting. This uses the cells D1 to AA1 to set cells D14 through to AA18 to zero if the heat pump is deemed to have stopped.
The formula in cell D1 sets the cell value bases upon the values of cells D9 (Setpoint Temp.) and D11 (Actual IAT), such that if D11 > D9 + 0.1C the heat pump is switched off, cell D1 set to 0.
Try overwriting the formula in cell D1 with the actual value 1 or 0 and see what effect this may have. You could also try changing the value in cell E9, above and below that of cell E11, to see how that affects the formula in cell E1.
Has it just come out of a dhw cycle, which would be at a much higher ft (and thus may take a while to cool down)?
4kW peak of solar PV since 2011; EV and a 1930s house which has been partially renovated to improve its efficiency. 7kW Vaillant heat pump.
There might a minimum LWT setting that applies whatever the WC curve says. Maybe that is 30?
@jamespa No DHW cycle is 2-3pm, this was much later. Judging on my curve, @7.2deg, what should flow temp be? Maybe its ok. Using lot less KWH last few days which is good as i have been lowering flow temp since and slab is probably warmed up.
Have desired temperature on front screen but think that changes with the curve.Posted by: @kev-mThere might a minimum LWT setting that applies whatever the WC curve says. Maybe that is 30?
@newhouse87 well your WC line is 34 at -5 and 25 at 20, so at 7 you expect 25+9*(11/25) = 29. So 30 is just 1C out which is likely well within the hysteresis. Situation normal so far as I can see
4kW peak of solar PV since 2011; EV and a 1930s house which has been partially renovated to improve its efficiency. 7kW Vaillant heat pump.
- 26 Forums
- 2,610 Topics
- 60.8 K Posts
- 1,052 Online
- 6,966 Members
Join Us!
Worth Watching
Latest Posts
-
RE: Anyone concerned about GivEnergy?
An incredibly enlightening piece on the subject by @maj...
By Mars , 30 minutes ago
-
Home automation and the cloud; is there a better way?
You’ve just had a brand new system installed (heat pump...
By Majordennisbloodnok , 34 minutes ago
-
RE: End-of-Life Heat Pumps: How Do You Dispose of an ASHP in the UK?
We've started to document everything, and part 2 of the...
By Mars , 49 minutes ago
-
RE: Summer usage. Why is my Vaillant Aerotherm using so much energy on "heating"?
So the red bars are 'DHW' and the yellow bars 'heating'...
By JamesPa , 2 hours ago
-
Its good kit the Midea and significantly cheaper, you w...
By ASHP-BOBBA , 5 hours ago
-
RE: Indevolt Batteries UK Support & Info Thread
Have you tried cutting the grid feed to see what actual...
By JamesPa , 5 hours ago
-
Contractors pack for inta antifreeze valves are around ...
By ASHP-BOBBA , 5 hours ago
-
RE: Renewables & Heat Pumps in the News
Critics and naysayers will be negative whatever the gov...
By JamesPa , 5 hours ago
-
RE: Microbore heat pump installs
In principle you are almost certainly right, but in pra...
By JamesPa , 16 hours ago
-
RE: Electricity price predictions
@old_scientist We are a low mileage home, so bulk of ou...
By ChandyKris , 17 hours ago
-
There are just too many unknowns for me to comment on p...
By Transparent , 19 hours ago
-
RE: What is the main ‘dictator’ of Agile’s unit price?
@toodles I keep an eye on wholesale prices and energy m...
By ChandyKris , 19 hours ago
-
RE: Brand and installer questions for ASHP
Strange, perhaps it doesnt use modbus which the third p...
By JamesPa , 21 hours ago
-
RE: Upgrading my system, how far do I go?
For comparison, my PW3 with 11.04kW inverter, will char...
By Old_Scientist , 1 day ago
-
RE: Changes to Tesla Powerwall Charging Regime?
Elon gate - legendary! I take my hat off to you @toodle...
By Old_Scientist , 1 day ago
-
RE: Mitsubishi Ecodan not good enough ?
Thanks @goody, appreciate the feedback and sorry you ha...
By marcexec , 2 days ago
-
RE: Minimum and Zero Disrupt Heat Pump Installations
True (first sentence) Thats the reason to consider th...
By JamesPa , 2 days ago
-
RE: High air source heat pump running costs – Vaillant AroTherm Plus
Quite right. I was using a rough guesstimate of doublin...
By Majordennisbloodnok , 2 days ago
-
RE: My Grant R290 9kW Heat Pump Installation
Again, really don't know how accurate this is! &nb...
By petch , 3 days ago
-
RE: MCS Quality Audit – Has Anyone Had One? Did It Lead to Remediation?
@toodles The whole scheme is a shocking waste of money....
By Papahuhu , 3 days ago
-
RE: DIY or Don’t Touch? Solarman Smart Meter Install
Yes, and these guys would probably be my preferred inst...
By Batpred , 3 days ago
-
RE: Hot water tank lose heat rapidly on random days
@jamespa Hopefully their reasons are well intended! ...
By Bash , 3 days ago
-
RE: Ecoflow UK Support & Info Thread
As mentioned above, we’ve got our full review of the Ec...
By Mars , 3 days ago
-
RE: Say hello and introduce yourself
@sonosppp welcome to the forums. I see you've posted in...
By Mars , 4 days ago
-
RE: Guidance with installing a new heating system
@bobflux Great, thanks for the advice. The pipe has an ...
By Hamilton , 4 days ago




