MELCloud Reports
A question to the MELCloud experts. Has anyone seen a report / found a way to create a report view that includes the external and internal temperature history information alongside the flow rate history in a single chart?
They seem such obvious sets of information to compare together yet they are currently spread over two different reports.
Do I need to explore using an API?
Do you mean flow temps rather than flow rates? I have the metering package and with that you can download minute by minute CSV file showing outside, indoor temps and flow return temps, can you access that?
Posted by: @hjdA question to the MELCloud experts. Has anyone seen a report / found a way to create a report view that includes the external and internal temperature history information alongside the flow rate history in a single chart?
They seem such obvious sets of information to compare together yet they are currently spread over two different reports.
Do I need to explore using an API?
Not that I found. I access the data using Python.
Posted by: @hjdA question to the MELCloud experts. Has anyone seen a report / found a way to create a report view that includes the external and internal temperature history information alongside the flow rate history in a single chart?
They seem such obvious sets of information to compare together yet they are currently spread over two different reports.
Do I need to explore using an API?
The MELCloud app is pretty basic to be honest, but the API underneath it certainly has all the information you need. Well worth taking a look at simply using the API to grab the figures and graphing as you see fit.
105 m2 bungalow in South East England
Mitsubishi Ecodan 8.5 kW air source heat pump
18 x 360W solar panels
1 x 6 kW GroWatt battery and SPH5000 inverter
1 x Myenergi Zappi
1 x VW ID3
Raised beds for home-grown veg and chickens for eggs
"Semper in excretia; sumus solum profundum variat"
Posted by: @walkers-heatpump@majordennisbloodnok is there a somewhat layman way of doing that?
There is, but you’ll have to give me a wee bit of time to sort out the easiest way to show you. Leave it with me.
105 m2 bungalow in South East England
Mitsubishi Ecodan 8.5 kW air source heat pump
18 x 360W solar panels
1 x 6 kW GroWatt battery and SPH5000 inverter
1 x Myenergi Zappi
1 x VW ID3
Raised beds for home-grown veg and chickens for eggs
"Semper in excretia; sumus solum profundum variat"
OK, here's something to play with. I've uploaded a spreadsheet that grabs the data from several of Melcloud's API functions and so combines bits of two reports. It is not macro-enabled so feel free to download and scan it for viruses to your heart's content before opening and playing with it.
It should do roughly what you wanted. Some bits to bear in mind, though....
- The first tab is for your settings. Here is where you'll put your start and end dates along with your Melcloud username (i.e. email address) and your associated password.
- Once you've put those four details in, all you need to do to run it all is to go to Data on the menu bar and then click on the button "Refresh All". This assumes, of course, that you trust my coding, so feel free to be as suspicious and wary as you would like; that's exactly what I would do.
- The data source you are using behind this all assumes that you only have one location (i.e. house), that you only have one heat pump at that location and that you have two zones to be heated.
- Melcloud's API has a few quirks in the way it works. For instance, it will only give hourly data for the current day and even then it's only for the internal temperatures, so I have left that out. Similarly, if you want to look at the past month or less it will give you daily data but if you put in dates more than one month apart then it will provide monthly data points instead. Nowt I can do about that, I'm afraid. There's nothing to stop you, however, from putting in a start and end date in, for instance January 2022 and getting daily figures from that far back - it's not a problem of lack of data on Mitsi's part.
- Since the data points mean different things based on the distance between start and end dates, I haven't even attempted to add any dates next to the data. Suffice to say whatever comes out is in chronological order from oldest at the top to newest at the bottom.
If you want to see the guts of the spreadsheet you can go to Data on the menu, then click on Queries & Connections to bring up a panel on the right hand side. In there you will see a query called (imaginatively enough) Query1. If you click on it and select Edit then you'll get into the Power Query Editor. Clicking on the Advanced Editor will then show you the entirety of the code I put together.
I hasten to add that if you aren't interested in the code, there's absolutely no need to take a look. However, if anyone is actually interested in how it's working then I can post more of an explanation later.
Overall, the spreadsheet is just a proof of concept that is intended as a working starting point for people to extend if they really want to. Using Excel to get API data is not entirely novice stuff but nor is it the domain of a gifted few. There are some underlying concepts to get to grips with if you want to do it yourself, but if it raises enough interest it's something that could theoretically become the basis of an RHH article.
105 m2 bungalow in South East England
Mitsubishi Ecodan 8.5 kW air source heat pump
18 x 360W solar panels
1 x 6 kW GroWatt battery and SPH5000 inverter
1 x Myenergi Zappi
1 x VW ID3
Raised beds for home-grown veg and chickens for eggs
"Semper in excretia; sumus solum profundum variat"
Posted by: @majordennisbloodnokThe data source you are using behind this all assumes that you only have one location (i.e. house), that you only have one heat pump at that location and that you have two zones to be heated.
I have only one zone 😌
However, your work is appreciated. Thank you for sharing.
Retrofitted 11.2kw Mitsubishi Ecodan to new radiators commissioned November 2021.
14 x 500w Monocrystalline solar panels.
2 ESS Smile G3 10.1 batteries.
ESS Smile G3 5kw inverter.
Posted by: @morganPosted by: @majordennisbloodnokThe data source you are using behind this all assumes that you only have one location (i.e. house), that you only have one heat pump at that location and that you have two zones to be heated.
I have only one zone 😌
However, your work is appreciated. Thank you for sharing.
My pleasure. Do let me know if it works for you, though; I was only able to test with my account so confirmation is always good.
105 m2 bungalow in South East England
Mitsubishi Ecodan 8.5 kW air source heat pump
18 x 360W solar panels
1 x 6 kW GroWatt battery and SPH5000 inverter
1 x Myenergi Zappi
1 x VW ID3
Raised beds for home-grown veg and chickens for eggs
"Semper in excretia; sumus solum profundum variat"
It won't work for me. I have one zone and as per your quoted requirement, I need two.
Retrofitted 11.2kw Mitsubishi Ecodan to new radiators commissioned November 2021.
14 x 500w Monocrystalline solar panels.
2 ESS Smile G3 10.1 batteries.
ESS Smile G3 5kw inverter.
Posted by: @morganIt won't work for me. I have one zone and as per your quoted requirement, I need two.
OK. I have only one zone as well, but that just means Melcloud shows the second zone as at a constant -39. As a result, I assumed (not being able to test otherwise) that the spreadsheet would only work with up to two zones, not precisely two. If it's not working for you then it shouldn't be too difficult to amend the calls accordingly.
105 m2 bungalow in South East England
Mitsubishi Ecodan 8.5 kW air source heat pump
18 x 360W solar panels
1 x 6 kW GroWatt battery and SPH5000 inverter
1 x Myenergi Zappi
1 x VW ID3
Raised beds for home-grown veg and chickens for eggs
"Semper in excretia; sumus solum profundum variat"
- 26 Forums
- 2,114 Topics
- 46.4 K Posts
- 35 Online
- 3,410 Members
Join Us!
Latest Posts
-
RE: No-code, plug-and-play monitoring for your heat pump
By Grantmethestrength , 19 hours ago
-
@eliuccio good to hear you’re happy with the install. A...
By Mars , 1 day ago
-
RE: Is this just haze or something more?
I am not a scientist nor a meteorologist and I know the...
By Toodles , 2 days ago
-
RE: Benefits of an extra horizontal loop for GSHP
It will improve performance, but by how much depends on...
By Brendon Uys , 2 days ago
-
RE: The good, the bad and the not that great – my heat pump installation
Said I would pop back with a update. Only Mr Jesus h...
By Burtis , 3 days ago
-
RE: Buffers, hot water and cooling
Thats presumably heat pump DT, what about radiator DT a...
By JamesPa , 3 days ago
-
RE: Who's your electricity provider and what's your tariff?
@chandykris Exactly the same here. We now have 13.5kWh ...
By Old_Scientist , 3 days ago
-
Compressor and Evaporator Stratification
I have had a few issues with my Hitachi spilt heatpump ...
By trebor12345 , 3 days ago
-
RE: Wood burner with ASHP - direct air?
This depends on the size of your wood burner and size/t...
By Lucia , 4 days ago
-
RE: Difficult positioning of air source heat pump
@rikiarn It's a not a buffer it's a volumiser which is ...
By Lucia , 4 days ago
-
RE: Is your heat pump insured?
To make things clear, lots of insurance companies cover...
By Lucia , 4 days ago
-
RE: Boxt Heat Pump Installation Experience
@adrian any updates since installation? How is it perfo...
By Ashfp , 4 days ago
-
RE: Say hello and introduce yourself
Hi @seatonian - Yes, I know Seaton, and I have the Nat...
By Transparent , 5 days ago
-
@seatonian got your email. Will connect you with a reco...
By Mars , 6 days ago
-
@downfield and @toddles, this isn’t in the settings cur...
By Mars , 1 week ago
-
RE: Homely launched for Grant Aerona ASHP control
I haven't bought the Aerona Smart Controller (£700!) bu...
By Prunus , 1 week ago
-
RE: Antifreeze top up for my heat pump - is this a rip off?
For the record, Grant supply ethylene glycol for their ...
By Prunus , 1 week ago
-
RE: Compressor attempts start but fails - Nibe Fighter 2005 8kW
@skyefarmer amazing. Well done!
By Mars , 1 week ago
-
RE: Air source heat pump roll call – what heat pump brand and model do you have?
Ebac 5kw - Monobloc R32. Developed and made in UK - Mit...
By marcinwloch69@gmail.com , 1 week ago
-
RE: Is a Valliant Inline 6kW heater a BUS buster?
Just another thought - it might be worth thinking about...
By JamesPa , 1 week ago