I’m not sure I agree that a manual J calculation is unobtainable, but more that what’s offered is rarely that.
Thanks for sharing the spreadsheet. I’ll definitely take a closer look. Where we have struggled is that we don’t have reliable fuel billing history for two reasons : first / new owners. Second, every aspect of our innovation involved plugging and improving our building envelope. So we are quite a bit better than we were just six months ago, and will be much better in another six months. I dongg th have a great solution other than the manual J, which even thrr E n requires assumptions on what will soon be, not what currently is.
As most HVAC systems are put in with the expectation that they will be there for 2 decades or more, it seems wrong to base them on what was, instead of what will be.