I would like to hire an Excel Expert

进行中 已发布的 5 年前 货到付款
进行中 货到付款

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.

Excel

项目ID: #17527723

关于项目

10个方案 远程项目 活跃的5 年前

授予:

KamrunNaharBD

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 更多

$45 CAD 在3天内
(1条评论)
0.7

有10名威客正在参与此工作的竞标,均价$126/小时

elqueabandona

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

$200 CAD 在5天内
(214条评论)
6.8
sonarkaushik

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 更多

$194 CAD 在3天内
(43条评论)
5.6
stats4data

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 更多

$55 CAD 在3天内
(3条评论)
2.0
KimberlyDodson

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 更多

$68CAD 在1天里
(2条评论)
2.0
mokeam

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?

$222CAD 在1天里
(0条评论)
0.0