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).
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).
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:
The calculation for C is ([2/(2+4)]/3+[4/(2+4]/3).
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:
The calculation for B would be [6/(2+6)]/3 + [2/(2+6)]/3.
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 Plus
11 freelance font une offre moyenne de $130 pour ce travail
Hello, I am ready to create macro to consolidates files to create a weighted average list with percentages. I need to discus in details. ****PRICE NEGOTIABLE*****Highly experienced in Excel Programming, Excel automa Plus
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 Plus
Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on this kind of project with more than 5 years [login to view URL] feel free to contact me.I am looking forward to hear Plus
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 Plus
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 Plus
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?
It's well explained! I can get it done in even less time. Do you have any sample data sheets to offer for testing?