I would like to hire an Excel Expert

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.

Taidot: Excel

Näytä lisää: excel expert hire, excel expert on hire, excel expert services for hire, excel spreadsheet consultant, excel expert tutorial, excel expert salary, excel expert jobs, excel experts forum, excel for hire, excel programmers for hire, excel experts online help, excel expert sg hire, Hire an excel expert, hire excel expert, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i need an excel expert, i want an excel expert who works on my excel sheet according to my requirements, i want to hire an excel expert in the leesburg va area

Tietoa työnantajasta:
( 0 arvostelua ) Canada

Projektin tunnus: #17527723

Myönnetty käyttäjälle:


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 Lisää

$45 CAD 3 päivässä
(0 Arvostelua)

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$250 CAD 2 päivässä
(161 arvostelua)

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 päivässä
(199 arvostelua)

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 Lisää

$194 CAD 3 päivässä
(43 arvostelua)

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 Lisää

$50 CAD 2 päivässä
(32 arvostelua)
$90 CAD 2 päivässä
(31 arvostelua)

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 Lisää

$68 CAD 1 päivässä
(2 arvostelua)

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 Lisää

$55 CAD 3 päivässä
(1 arvostelu)

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?

$222 CAD 1 päivässä
(0 arvostelua)

It's well explained! I can get it done in even less time. Do you have any sample data sheets to offer for testing?

$166 CAD 3 päivässä
(0 arvostelua)
$88 CAD 1 päivässä
(0 arvostelua)