I want to make a calculation where the atribut columns whose rows have benefit values are all placed on the left and all rows with cost values are placed on the right. with the actual calculation formula like this:
(0.25x0.49237)+(0.15x0.71842)+(0.15x0.44721)+(0.15x68680) (benefit row atribut column and weight) - (row atribut column cost and weight)(0.3x0.36927) = 0.290176
what I do is even a calculation like this (0.3x0.36927)+(0.25x0.49237)+(0.15x0.71842)+(0.15x0.44721)+(0.15x0.66880)= 0.51173
anyone know how? The coding I made https://pastebin.com/U8mm7fgY
Note: the number of benefits and costs in the attribute column matches those in the database, the coding will automatically look for the benefit and cost rows with the formula pattern that I have explained