Implement an Excel routine in Python3 code

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

Habilidades: Processamento de Dados, Excel, Python, Matemática

Sobre o Cliente:
( 1 comentário ) São Paulo, Brazil

ID do Projeto: #27426639

Concedido a:


hello sir, i'm python expert, i tried to read carrefully your description, but still have many questions, if i'm right you want to create a script that take some columns from some sheets and do some calculations and Mais

$50 USD em 1 dia
(12 Comentários)

7 freelancers estão ofertando em média $38 nesse trabalho


Hi there, I see you need to find a Python programmer to write a script to process Excel files. I have ability to implement this kind of task. I also check .docx file and saw the python code already there. Could we disc Mais

$50 USD em 1 dia
(48 Comentários)

Hi, I have a very good programming skills and can implement your task in Python. Inbox me for your task.

$30 USD in 7 dias
(6 Comentários)

Hi my name is Shikder Ali i have 3 years experience of #data entry, #data processing, #email marketing, #ebay marketing, #ms word , #excel #powerpoint etc. I am a good person because i am expert and honest. Th Mais

$25 USD in 7 dias
(0 Comentários)

I will implement an Excel routine in Python3 code by following all your specifications. I am an expert Python developer. Thank you

$50 USD in 12 dias
(0 Comentários)

Dear Client, I have read your job description and interested to deal with you, I have extensive amount of experience in Data Entry and I have worked on many similar projects before. Please take a look at my po Mais

$30 USD in 7 dias
(0 Comentários)

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

$30 USD in 7 dias
(0 Comentários)