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.
@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,396 Topics
- 54.3 K Posts
- 403 Online
- 6,077 Members
Join Us!
Worth Watching
Latest Posts
-
RE: Advice for a novice on Mitsubishi Ecodan 6kW
In my case it was a very specific pattern of behaviour ...
By Sheriff Fatman , 4 minutes ago
-
RE: Vaillant aroTherm not heating with many faults
@ashp-bobba Yeah I'll give it a go, will check filter...
By Anon67 , 14 minutes ago
-
@majordennisbloodnok it has been a few weeks since addi...
By TechnoGeek , 14 minutes ago
-
RE: RDSAP10 effect on existing heat pump EPC rating?
@transparent Perhaps the names at the end of the docume...
By Toodles , 25 minutes ago
-
RE: Predicted Heat Loss & Needs from MCS calcs vs EPC vs actual
COP of 3 perhaps a little low and you say that you don'...
By benson , 57 minutes ago
-
RE: Heatpunk Floor plan issues
@jamiejones85 A2A they will design on dynamic heat loss...
By ASHP-BOBBA , 1 hour ago
-
RE: Considering MLCP (Multi-Layer Composite Pipe) for ASHP
I think the concern was about crud being forced from th...
By iotum , 1 hour ago
-
RE: Recommended home battery inverters + regulatory matters - help requested
The usual type of underground cable with a metal 'outer...
By Transparent , 1 hour ago
-
RE: Rate the quality of your heat pump design and installation
Welcome to the forum and I am sorry you are disappointe...
By JamesPa , 1 hour ago
-
RE: Fan unit Making terrible noise HELP!!
can you post a video looking inside, at and through the...
By ASHP-BOBBA , 2 hours ago
-
RE: Setback savings - fact or fiction?
Excellent graphics and description Rob…. But to my mind...
By SUNandAIR , 2 hours ago
-
RE: Heat pump not reaching flow temperature
@davec Ive had a look at the screenshots. Lots of th...
By JamesPa , 14 hours ago
-
RE: Power outages and storms: A surprisingly good DNO experience
Agreed, which is no more nor less than a customer shoul...
By Majordennisbloodnok , 19 hours ago
-
RE: Running from backup generaor in powercut?
@batpred In our case, 3 times each day when the Octopus...
By Toodles , 19 hours ago
-
RE: New Fogstar 15.5kWh upright solution
@batpred Here's the latest Fogstar ready built pack....
By Bash , 21 hours ago
-
RE: Solis inverters S6-EH1P: pros and cons and battery options
Solis confirmed that the S6 works with a single battery...
By Batpred , 22 hours ago
-
RE: Who has a V2G EV installation
I am wondering if in any V2X, would the car battery eve...
By Batpred , 22 hours ago
-
RE: New Mitsubishi Ecodan 11.2kW installation - L9 errors and maybe more
OK. I think your system, which seems well designed, is...
By JamesPa , 1 day ago
-
RE: Fan is clipping ice build up from the front of unit.
@majordennisbloodnok I’ll not go there thanks! Toodles.
By Toodles , 2 days ago





