Hi Uwe

I tried to adapt my excel sheet to the excel reader but I still have some problems.

The excel sheet is like this one:

and I modified the excel reader as follows. after creating the R1_bus_heat:

[…]

for i, t in transformers.iterrows():

noded[i] = solph.Transformer(

label=i,

inputs={noded[t[‘from’]]: solph.Flow()},

outputs={noded[t[‘bus_el’]]: solph.Flow(

nominal_value=t[‘capacity_el’],

variable_costs=t[‘variable costs’],

max=t[‘simultaneity’]),

noded[t[‘bus_heat’]]: solph.Flow(

nominal_value=t[‘capacity_heat’])},

conversion_factors={noded[t[‘bus_el’]]: t[‘efficiency_el’], noded[t[‘bus_heat’]]: t[‘efficiency_heat’]})

I receive the KeyError: 0

I tried also this way:

[…]

for i, t in transformers.iterrows():

noded[i] = solph.Transformer(

label=i,

inputs={noded[t[‘from’]]: solph.Flow()},

el_outputs={noded[t[‘bus_el’]]: solph.Flow(

nominal_value=t[‘capacity_el’],

variable_costs=t[‘variable costs’],

max=t[‘simultaneity’])},

heat_outputs={noded[t[‘bus_heat’]]: solph.Flow(

nominal_value=t[‘capacity_heat’])},

conversion_factors={noded[t[‘bus_el’]]: t[‘efficiency_el’], noded[t[‘bus_heat’]]: t[‘efficiency_heat’]})

but still get the same KeyError, even if this way I am creating a new dict, if I am not wrong.

Do you have any suggestion?

Thank you

gabriele