Excel work

Ukończone Opublikowano 4 lat temu Płatność przy odbiorze
Ukończone

I have two Excel sheets. One has venture capital (VC) firms and each VC has its own VC-ID. The other has firms and each firm has its own Firm-ID. VCs have invested in firms.

Note that you do not need to calculate any of the following. I have done this already. You only need to merge the two Excel sheets.

The following work is required:

1/

For each Firm-ID, create dummy variables (0 or 1) for whether...

- a the firm is associated with a VC-ID from the United States

- a the firm is associated with a VC-ID from the China

- a the firm is associated with a VC-ID from the Russia

- a the firm is associated with a VC-ID from the Switzerland

- a the firm is associated with a VC-ID from the California

- a the firm is associated with a VC-ID from the New York

- a the firm is associated with a VC-ID from the Massachussetts

- a firm is associated with a VC-ID that has SEC registration

- a firm is associated with a VC-ID that has Crypto-only focus

- a firm is associated with a VC-ID with firm type VC

- a firm is associated with a VC-ID firm type HF

- a firm is associated with a VC-ID firm type PE

2/

For each Firm-ID, create sums for...

- the Employees of all VC-IDs

- the AUM of all VC-IDs

- the Age of all VC-IDs

The work should be completed within 24 hours, ideally within 12 hours. Hourly billing is ok, but when you apply, please state your total required budget. Thanks.

I attach both sheets with only a few lines as examples.

Excel Wprowadzanie danych Przetwarzanie danych Administrowanie bazami danych Data Analysis

Numer ID Projektu: #23037375

O projekcie

45 ofert Zdalny projekt Aktywny 4 lat temu

Przyznany użytkownikowi:

sharmapritam311

Hi there. i have read your job requirements. I am very proficient in excel vba automation. I can do this job within 12 hours for sure. on job completion i expect not more than 55 $.

$5 USD / godzina
(8 ocen)
2.8

45 freelancerów złożyło ofertę na średnią kwotę $5/godzinę w tym projekcie

bouslimi1979

Hi, I can merge the 2 sheets by using a macro. I can finish before your 12 hours deadline. Total price 80. I need a short discussion to clarify the logic before starting. Thanks

$5 USD / godzina
(304 Oceny)
7.8
rashedkhanrubel

Hi, I have understand the project requirement & interested to work for this project. Please send a message so we can discuss more & start the project. Thanks.

$8 USD / godzina
(188 Oceny)
6.3
pm9887

Hello, I can assist you in best way, I have good experience in many type of jobs. I am good in internet research and spreadsheet task. Would like to do some samples to gain your confidence. Let's initiate chat and disc Więcej

$5 USD / godzina
(74 Oceny)
5.8
dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project don Więcej

$5 USD / godzina
(47 Oceny)
5.2
w3saddam

Dear hiring manager, I am interested in your project. Yes, I am available right now to do your job. I think I am the suitable person for this position. Please don’t be fell hesitate to invite me. I am expert in data e Więcej

$5 USD / godzina
(61 Oceny)
5.4
sadif18

Hello, I can do this for you within 12 hour with 100% accuracy. My bid is for $35- total. Please response. Looking forward to working with you. Thanks

$5 USD / godzina
(105 Oceny)
5.2
Mohammedelouh

Hi…. I am an engineer. I understand your order (I am Expert Excel). Please send me a message now so that we can discuss it more. The price is negotiable.

$5 USD / godzina
(15 Oceny)
4.9
superseoservice

Dear Hiring Manager, After carefully reading the requirements of the Project, I believe that my strong experience and dedication make me a suitable match for this. I have vast experience in Lead Generation, Data Entry Więcej

$4 USD / godzina
(11 Oceny)
4.3
asad090

The thing I am on good at is providing quality work in a given certain time ............................................................................................

$2 USD / godzina
(10 Oceny)
4.2
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat. I will cha Więcej

$8 USD / godzina
(18 Oceny)
4.4
ProjectManage01

Hello Sir/Madam, It is my pleasure to be able to bid on your project. I would like to give my fullest and maximum contribution towards the success of this project. I'm a very confident Więcej

$5 USD / godzina
(7 Oceny)
3.0
Servicehour24

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirements. I'd like to help you with confidence and satisfying results. I have professional wor Więcej

$8 USD / godzina
(2 Oceny)
2.4
lamyaa4ever

Hello, my name is lamiaa , i am software engineer and I am interested in your job offer. Contact me to discuss further details of the project. thanks Total budget 45$

$5 USD / godzina
(2 Oceny)
1.2
ajayjonwal791

I am ajay and I want to work for you with honestly. I am finish the work within time line and if you will require revision of the work I am working on it without any cost. Because I want to make a long term relationsh Więcej

$8 USD / godzina
(0 Oceny)
0.0
Faroghabbas768fa

hello sir, i am expert in ms Excel you can hire me for a long time i am free now so i bit less. i will give give you 100% quality 100% accuracy 100% value for money. message me i reply you instently thanking you

$3 USD / godzina
(0 Oceny)
0.0
Fziatif

hi I am perfect in data entry and analysis on Excel. I can prepare reports and graphs on excel. I can do your task well gives you the quality of work. I have checked the work and excel files also. 1 file is having prob Więcej

$6 USD / godzina
(0 Oceny)
0.0
akshatgpt118

I am interested in completing your work Please provide nessesory information about the project..............

$2 USD / godzina
(0 Oceny)
0.0
HP67

I will do this job given me a chance to show myself . I promise to complete the job in time or before

$4 USD / godzina
(0 Oceny)
0.0
ashmit101192

I am a Chartered Accountant (Equivalent to CPA), over past 7 yers we have helped businesses into Accounts and Taxation matters. We have helped US, Canadian & UK businesses in bookkeeping services and SAVE COST and inve Więcej

$5 USD / godzina
(0 Oceny)
0.0
rakibshad123

Thank you for posting your valuable project/inquiry. I have a completed more than 700+ Projects in the same field, Having years experience. I can do this work accurately and rapidly. I have study all the details which Więcej

$5 USD / godzina
(0 Oceny)
0.0