energy consumption spreadsheet

Heating, insulation, ventilation, VMC, cooling ... short thermal comfort. Insulation, wood energy, heat pumps but also electricity, gas or oil, VMC ... Help in choosing and implementation, problem solving, optimization, tips and tricks ...
Chan
I learn econologic
I learn econologic
posts: 14
Registration: 16/11/10, 15:22

energy consumption spreadsheet




by Chan » 23/09/13, 14:32

Hello,

I wrote an Excel sheet (XLSX) in which we enter its actual energy consumption, and this gives the housing situation among the most common 3 labels (as well as the French DPE):
- BBC Effinergie
- Minergie
- PassivHaus
- DPE

Of course it does not have the value of a label because it is based on the real consumptions (thus depending on the habits of the occupants) and does not take into account the complementary parameters (sealing, thermal comfort, etc ...) but on the other hand it can give you a good idea of ​​the quality of your insulation and your installation.

Version that takes into account the remarks below: https://www.econologie.info/share/partag ... T1V3cA.xls
0 x
Chan
I learn econologic
I learn econologic
posts: 14
Registration: 16/11/10, 15:22




by Chan » 23/09/13, 14:34

Of course, any welcome remark;)
0 x
User avatar
ATE.Conseil
I learn econologic
I learn econologic
posts: 27
Registration: 02/09/10, 13:28
Location: Obernai (67)

consumption recovery




by ATE.Conseil » 23/09/13, 17:28

Hello,

I also recommend the excellent monthly relief site http://www.ecolometre.com who sends you a small monthly mail of relief of consos and gives you a lot of indicators of monitoring of consumption.

Admittedly, it does not place you on a DPE label but compares you to the French average and the objectives to be achieved.

Greetings
Philippe DESOn
Council ATE manager
http://www.ate-conseil.eu
0 x
ATE Council accompanies you to reduce your energy consumption
Chan
I learn econologic
I learn econologic
posts: 14
Registration: 16/11/10, 15:22

Re: consumption recovery




by Chan » 23/09/13, 17:56

ATE.Conseil wrote:I also recommend the excellent monthly relief site http://www.ecolometre.com who sends you a small monthly mail of relief of consos and gives you a lot of indicators of monitoring of consumption.


It does not look bad, I'll try.
0 x
Christophe
Moderator
Moderator
posts: 79117
Registration: 10/02/03, 14:06
Location: Greenhouse planet
x 10972




by Christophe » 24/09/13, 10:33

I converted the file to .xls here it is:

https://www.econologie.info/share/partag ... 9r0Nud.xls
0 x
Chan
I learn econologic
I learn econologic
posts: 14
Registration: 16/11/10, 15:22




by Chan » 24/09/13, 10:38

Christophe wrote:I converted the file to .xls


Thank you. But beware, this version XLS does not display the status (green, orange or red) relative to the label. It is therefore necessary to compare visually with the reference. I made an XLS version that displays the color chips (at least at home), here it is:

https://www.econologie.info/share/partag ... r8bfJm.xls
0 x
Christophe
Moderator
Moderator
posts: 79117
Registration: 10/02/03, 14:06
Location: Greenhouse planet
x 10972




by Christophe » 24/09/13, 10:40

Yes we lose some features by passing in .xls but more people can use it ...

As for content, I just tested.

It works well, thanks for sharing it!

Notes:

a) the box C35 is greyed out (so configurable by the user) whereas it is supposed to be a formula of result ... no?

b) the sheet does not take into account climatic corrections (climatic zones see: https://www.econologie.com/forums/zones-clim ... 11929.html ), you will find climatic corrections in this subject: https://www.econologie.com/forums/normes-et- ... t9153.html

c) Wood line: wet finger ????? : Shock:
0 x
Chan
I learn econologic
I learn econologic
posts: 14
Registration: 16/11/10, 15:22




by Chan » 24/09/13, 10:45

Christophe wrote:a) the box C35 is greyed out (so configurable by the user) whereas it is supposed to be a formula of result ... no?
b) the sheet does not take into account climatic corrections (climatic zones see: https://www.econologie.com/forums/zones-clim ... 11929.html ), you will find climatic corrections in this subject: https://www.econologie.com/forums/normes-et- ... t9153.html


Precisely, the box C35 contains the climatic formula, that's why it is editable. I also put a link in the comments to help the user to enter the good weather data. Except error on my part, Minergie and PH do not have these nuances, so afraid they references are fixed.

Christophe wrote:c) Wood line: wet finger ????? : Shock:


The comments on the right of consumption are personal. There is the consumption of my house, so I say that for the wood I estimated the consumption of 120kg wet finger : Mrgreen:
0 x
Christophe
Moderator
Moderator
posts: 79117
Registration: 10/02/03, 14:06
Location: Greenhouse planet
x 10972




by Christophe » 24/09/13, 10:49

Chan wrote:Precisely, the box C35 contains the climatic formula, that's why it is editable. I also put a link in the comments to help the user to enter the good weather data. Except error on my part, Minergie and PH do not have these nuances, so afraid they references are fixed.


Actually I did not click on the help link ...
You would have to "automate" the formula so that the user only has to enter his climatic zone and altitude and that the coefs a and b are calculated automatically ... no?

Chan wrote:I estimated the consumption of 120kg wet finger : Mrgreen:


Never heard of this method ... you explain us ???? : Shock:
0 x
Chan
I learn econologic
I learn econologic
posts: 14
Registration: 16/11/10, 15:22




by Chan » 24/09/13, 10:53

Christophe wrote:You should "automate" the formula


Ok, I had hesitated to overload the sheet again, but it stands, thank you :)

Christophe wrote:Never heard of this method ... you explain us ???? : Shock:


http://fr.wiktionary.org/wiki/au_doigt_mouill%C3%A9
0 x

 


  • Similar topics
    Replies
    views
    Last message

Back to "Heating, insulation, ventilation, VMC, cooling ..."

Who is online ?

Users browsing this forum : Google Adsense [Bot] and 320 guests