I need a macro programmed in Python3, which reads a file with data of “n” variables / criteria, the goals for alternatives and finally the weights for each variable / criterion. So I have three sources of input.
After reading, it is expected that the code can result the results obtained equal to those of the first 3 spreadsheets in green.
The necessary calculations are in the orange spreadsheets, the blue tab is the main calculation and where the input data is located (Goals, Data Obtained and Weights), the other 3 spreadsheets contain the same calculations but with the only difference of changing the input data comprising columns B to G from line 26.
To facilitate the work I found some Python programs of the calculation that I did in Excel, but they need an adaptation so that I can use the macro and mainly to consider the goals as input data. Goals are not being considered in the codes !. The calculation I am doing is a change from the original calculation obtained by the program sent.
In the spreadsheets are all the calculations used to generate the results and accepting the project I can remove all doubts about the mathematical part, however it is necessary to have knowledge about macro programming and Python3 matrices.
P.S.1. I sent an example that uses 15 alternatives and 6 variables / criteria to be analyzed, but I need a macro so that it can include different sizes of data.
PS2 In Excel, several repetitions were necessary in the other lines of the calculations obtained, which in programming will not be necessary, as the calculations are the same, I had to do these repetitions, because we have different goals, so during programming it is necessary to list the goals according to the alternative.
I will be available if I accept the project to answer more specific questions
7 freelancers estão ofertando em média $38 nesse trabalho
I am good at operations on data in python and i have experience in api automation which deals with parsing json data part and surely i will complete the project before deadline