Most up to date dataset description

[Joelius300]

Because I used the dataset from this project in multiple school projects, there are now multiple descriptions of it, some in german, some in english, some more detailed, some less. When these school projects are done it would make sense to compile these here into one document.

Off the top of my mind:

• in dbs_hslu (notebooks)
• in dviz_hslu (before 31deb92)
• I feel like there should be more. ABIZ also looked at a use-case with this data. Is there a german one somewhere?

[Joelius300]

From DBS (2022/10)

sps_zeit: Time the integrated system thinks it is (innacurate quartz clock) in the local time zone
received_time: Time my system received this state of the heating unit in UTC
kessel: Temperature of the water inside the furnance in °C
ruecklauf: Temperature of the water before entering the furnance in °C (should be around 65°, not below 60°)
abgas: Temperature of exhaust gasses in °C (optimal values 150° - 200°)
co2_soll: Target value of CO2 percentage.
co2_ist: Actual CO2 percentage. Can be transformed into residual oxygen percentage with formula: O2 = 20.942 - CO2 * 20.942 / 20.35 (note that 20.942=O2 max and 20.35 CO2 max for wood).
saugzug_ist: "Leistung Rauchgasventilator" probably an inverse meaning lower valeus = more energy for the ventilator = higher rpm. But unaware of any formula to convert it.
puffer_oben: Temperature in °C of buffer ([probably] high end). Used for determining the stored energy.
puffer_unten: ditto but low end
platine: [probably] Temperature of the integrated system in °C
betriebsphase_kessel: Phase of the furnance:
    0=Off
    1=Heating up (Anheizen)
    2=Automatic (Automatik)
    4=Burn out (Ausbrennen)
    6=Regulate (Abregeln="bremsen weil zu heiss")
    8=Heating up detected (Anheizen erkannt)
    These are not used apparently: 3,5,7
    "Lid open" (Tür geöffnet) exists according to the manual but the phase doesn't actually change when the lid is opened; can be fully replaced by DI_2
    "Gluterhaltung" and "Übertemperatur" I don't know but they're probably not in the data either.
aussen: Temperature of sensor outside the house in °C
vorlauf_hk1_ist: Current temperature ([probably] of water just leaving the furnance or buffer to go to) heating circuit 1 (radiators)
vorlauf_hk1_soll: Target value of ditto
betriebsphase_hk1: Phase of heating circuit 1 (radiators) (needs more analysis)
vorlauf_hk2_ist: See hk1 but for heating circuit 2 (underfloor heating)
vorlauf_hk2_soll: ditto
betriebsphase_hk2: ditto
boiler_1: Temperature of water inside boiler in °C (top)
di_0: {always false} Seems to be some security guard
di_1: {always true} ?
di_2: True=Lid closed, False=Lid open
di_3: {always true} ?
a_w_0: Motor of secondary air lid ([probably] True=lid open)
a_w_1: Motor of primary air lid ([probably] True=lid open)
a_w_2: Motor of mixer for "Rücklaufanhebung" (True=running). Not sure what it does but it correlates with an increase in "Rücklauf" as guessed.
a_w_3: {always true} something something warning/error
a_ea_0: ?
a_ea_1: ?
a_ea_2: ?
a_ea_3: [needs analysis] Something something lambdasonde
a_ea_4: {always false} ?
a_phase_0: Suction fan (True=on) (Saugzuggebläse)
a_phase_1: Charge pump for the furnance (True=on) (Ladepumpe Kessel)
a_phase_2: something something remote (we don't use that)
a_phase_3: {always false} something something additional heat source
a_phase_4: ?

[Joelius300]

From DVIZ (2022/11)

received_time: Time my system received this state of the heating unit in UTC
kessel: Temperature of the water inside the furnance in °C
abgas: Temperature of exhaust gasses in °C
co2_soll: Target value of CO2 percentage.
co2_ist: Actual CO2 percentage. Can be transformed into residual oxygen percentage with formula: O2 = 20.942 - CO2 * 20.942 / 20.35 (note that 20.942=O2 max and 20.35 CO2 max for wood).
puffer_oben: Temperature in °C of buffer at the highest point (usually highest temperature because the water is layered by temperature ascending). Used for determining the stored energy.
puffer_unten: ditto but lowest point of the buffer (usally lowest temperature)
betriebsphase_kessel: Phase of the furnance:
    0=Off
    1=Heating up (Anheizen)
    2=Automatic (Automatik)
    4=Burn out (Ausbrennen)
    6=Regulate (Abregeln="slow down, its too hot")
    8=Heating up detected (Anheizen erkannt)
    These are not used apparently: 3,5,7
    "Lid open" (Tür geöffnet) exists according to the manual but the phase doesn't actually change when the lid is opened; can be fully replaced by DI_2
    "Gluterhaltung" and "Übertemperatur" I don't know but they're probably not in the data either.
aussen: Temperature of sensor outside the house in °C (important note: sensor must not be reachable by the sun)
vorlauf_hk1_ist: Current temperature of water just leaving the furnance or buffer to go to heating circuit 1 (radiators)
vorlauf_hk1_soll: ditto but target value instead of current value
betriebsphase_hk1: Phase of heating circuit 1 (radiators) (needs more analysis)
vorlauf_hk2_ist: See hk1 but for heating circuit 2 (underfloor heating)
vorlauf_hk2_soll: ditto
betriebsphase_hk2: ditto
boiler_1: Temperature of water inside boiler in °C (top)
di_2: True=Primary lid closed, False=Primary lid open (the primary lid is where the wood is put in)
a_w_0: Motor of secondary air lid (True=lid open)
a_w_1: Motor of primary air lid (True=lid open)
a_phase_0: Smoke suction fan (True=on) (Saugzuggebläse)