I would like to hire an Excel Expert
$30-250 CAD
货到付款
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.
项目ID: #17527723
关于项目
授予:
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 更多
有10名威客正在参与此工作的竞标,均价$126/小时
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 更多
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 更多
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 更多
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?