Great! Please share your findings
No spreadsheet but I’ve got plenty of data on defrosts.
Here’s a typical defrost when its -1C outside: Emoncms - app view dashboard
If we zoom in on just the defrost section, we can see it took 5min to defrost and used 0.031kWh of elec and extracted 0.24kWh of heat from the house, which reduced the return temp by 8C. However, the heat has previously been provided in the prior 30min with a COP of 3.1 therefore the heat extracted equates to only 0.077kWh of elec in total to defrost used the equivalent of 0.11kWh of elec.
When it’s -1C outside, defrosts happen about every 60min:
