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
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 give back result to other columns ?
i worked in many projects that involved Excel filling, by doing calculations ..., i'm looking forward to hear more about this project, just need some clarifications.
cordially,
$50 USD 1 gün içinde
5,0 (12 değerlendirme)
4,8
4,8
7 freelancer bu proje için ortalama $38 USD teklif veriyor
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 discuss more ?
Hope to see your response.
Best regards,
Nam
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. Thank you............
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
portfolio and reviews to get an idea about my work.
I'm online at the moment, feel free to initiate a
chat; We can discuss further details regarding your
project.
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