I would like to hire an Excel Expert
$30-250 CAD
Paid on delivery
The goal of my project is to create a macro that consolidates files to create a weighted average list with percentages beside particular identifiers. The sum of all percentages will be equal to 100% under most circumstances (see section III).
Section I
The macro will pull identifiers from several individual files. The macro should make it easy to input specific file paths. The format will be consistent with [login to view URL] that is uploaded where the identifers start at A5 and progress to cells downwards. Files can contain between 0 and 30 identifiers.
Each file will have an associated score that is an input at the start of the macro. The macro will return a list with all identifiers listed with a weighted average percentage beside each.
For example, if G1 has a score of 4 with 3 identifiers (A,B & C) and G2 has a score of 2 with 3 different identifiers (D, E & F) the final list will each identifier listed with a corresponding percentage of 22% ([4/(2+4)]/3) while each identifier from G2 will have a corresponding percentage of 11% ([2/(2+4)]/3).
A 22%
B 22%
C 22%
D 11%
E 11%
F 11%
Section II
This gets slightly more complex if two files have the same identifiers. For example, if G1 has a score of 4 with 3 identifiers (A, B, C) and G2 has a score of 2 with 3 identifers (C, D and E) then the list will be organized as:
C 33%
A 22%
B 22%
D 11%
E 11%
The calculation for C is ([2/(2+4)]/3+[4/(2+4]/3).
Section III
The total list will be equal to 100% except when a particular file has less than 2 identifiers. For example, if G1 has a score of 6 with 2 identifiers (A, B) and G2 has a score of 2 with 3 identifiers (B, C, D) the output would be:
B 33%
A 25%
C 8%
D 8%
The calculation for B would be [6/(2+6)]/3 + [2/(2+6)]/3.
Project ID: #17527723
About the project
Awarded to:
Hi I have been working for more than 5 years in data entry and excel. I understood your project description. I can do it with perfection. You can please communicate me to get this job done with perfection. Thank More
10 freelancers are bidding on average $126 for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
Sir, I am very able to create this macro to suffice your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks an More
Name : Snoussi Khalil age : 27 gmail : whatsapp : 00212646739822 adress: agdal, Rabat, Morocco skype: Summary: I’m a data scientist with a Master’s degree in Statistics, Data science and applied e More
Hi, Whenever you need a person to collected information, data, links or company website details with a reasonable rate and in short time duration then i'm here to assist you. I’m energetic speedy and a dynamic freelan More
Hi There, I understand fully well what you want to do. One thing i’m curious about is if you want to use microsoft excel or google sheet?
