Multifucntional activities not assigned properly

[kebamba]

In multifunctionality activities Sparks is not taking the right one sometimes. Example in the attached Excel files. In tech_mapping_out, id 18 (chp_biofuel_extraction) the reference product (column prod_reference_product) specifies it should take 'electricity'. However, after running Sparks we get basefile_.xlsx, where the same act (now id 3) has been assigned the ecoinvent key '4cdddfa31a4349f4935e35c92b460359', corresponding to the reference product 'heat, district...' (see image below).

tech_mapping_out.xlsx

basefile_.xlsx