Find Jobs
Hire Freelancers

Merge & Edit Excel Data.

$20-75 USD

Ολοκληρώθηκε
Αναρτήθηκε πάνω από 7 χρόνια πριν

$20-75 USD

Πληρωμή κατά την παράδοση
Hello, I have 3 excel files (attached to project) that I need merged and modified. Ad Network [login to view URL] - Contains cost stats from advertising network Ad Network [login to view URL] - Contains cost stats from advertising network (Fewer Records) [login to view URL] - Contains Revenue stats from advertiser Basically the first 2 files are what the ad network is reporting for stats, and the 3rd file is what our ad server is reporting for stats. Currently they are mismatched and we want to merge them and get a better idea on which ad zones are profitable and which ones are not using accurate data. Task... Step 1) Merge data for each "Source ID" from Ad Network [login to view URL] and Ad Network [login to view URL] into one new data file. For example line 2 in Ad Network [login to view URL] contains 13789343 for Source ID and in Ad Network [login to view URL] this is contained in line # 3. So in the new data file you would take combine the impressions and cost for that "Source ID" into a new line. So for Source ID: 13789343 the new impressions could would be 46,605 and the new cost would be $748.40 because we simply combined to the two identical records into the 3rd file. As you can see Ad Network [login to view URL] only contains 128 records while Ad Network [login to view URL] contains 7,579 records. Step 2) Now once we have the merged data, were going to merge it with the data from [login to view URL] and update the records. Remember in Step 1 we worked with Source ID # 13789343 and if you look in [login to view URL] you will find this record on line 2. We will now update the impressions and cost values with the correct values we determined in Step 1. So we will replace the 27,945 impressions with 46,605 and replace the $851.11 cost with $748.40. Step 3) Once we merged the data in step 1, then updated [login to view URL] with the new values we are simply going to update the Profit and ROI fields with the updated totals. Going back to the Source ID 13789343 sample we are going to update the profit field to -56.15 (Revenue 692.25 Minus Cost $748.40) and then update the ROI (Return On Investment) to -7.5% Note: ROI is calculated by taking profit divided by cost multiple by 100 to get the percentage. So for example on Source ID: 13789343 it would be -56.15 / $748.40 x 100 = -7.5% End Result: You provide me with an excel sheet so I can accurately and easily identify which Source IDs are profitable or losing money. Note: I will be selecting a freelancer that can complete this task quickly (today)
Ταυτότητα εργασίας: 11694880

Σχετικά με την εργασία

26 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
"**** Trusted [login to view URL] from SB IT Services ****.I have read your description and checked the excel and understood your [login to view URL] are the best team(8 people) within your budget to complete this project [login to view URL] are very responsible towards our clients. We know our client needs and importance. Check our reviews to confirm our work quality(100%completion rate). Experience : a) 4.5 years of in O-Desk,Freelancer and E Lancer. b) Done more than 1200 projects. Skills : Excel, Macros,VB.net, Web scraping, Data entry, Copy typing, Transcription works. Contacts : O-desk profile - SBLancer E Lancer profile - dreammediasolutions With Regards, Bhaskar, SBITServices skyp id : [login to view URL] "
$35 USD σε 1 ημέρα
4,9 (508 αξιολογήσεις)
7,6
7,6
26 freelancers δίνουν μια μέση προσφορά $47 USD για αυτή τη δουλειά
Avatar Χρήστη
can merge and modify can merge and modify can merge and modify can merge and modify can merge and modify can merge and modify
$70 USD σε 1 ημέρα
4,9 (685 αξιολογήσεις)
7,5
7,5
Avatar Χρήστη
Hello, I understood your requirement and can handle this project with accuracy and deliver it on time. Thank you & regards Techies
$21 USD σε 3 ημέρες
5,0 (86 αξιολογήσεις)
7,2
7,2
Avatar Χρήστη
Hello Sir, I would like to work with your project. I am waiting for your message. I will provide High Quality Work. Cheers!
$75 USD σε 1 ημέρα
5,0 (138 αξιολογήσεις)
6,6
6,6
Avatar Χρήστη
Hello, I’ve carefully gone through your job posting Merge & Edit Excel Data. I'm an expert in Advanced Excel VBA programming techniques. I am very much interested in your project with all of your requirements. I am always available on Email. I will be available to start your project as soon as possible in accordance with you. Thank you for your consideration, Best Regards, Ian
$52 USD σε 10 ημέρες
5,0 (75 αξιολογήσεις)
5,9
5,9
Avatar Χρήστη
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start
$75 USD σε 0 ημέρα
4,7 (115 αξιολογήσεις)
5,5
5,5
Avatar Χρήστη
Greetings! Hope you will not ignore my resume/cover letter or proposal letter whatever you mean it. Wish you could have spent some time to read this thoroughly. May be this will help you to get an eminent person or may be waste your time. Let me introduce myself first. I am a professional Graphics Designer along with Web design and Data Entry. I have competency on, Graphics Design based on these fields, Clipping path, Background Removing/Changing/etching, Image editing, Image Optimization for web, Image Enhancement, Portrait Retouching, Image Manipulation, Photo Restoration, Photo Retouch, Hair Masking, Color Correction, Creating Vector Image, Flyer /Brochure Design, Business card, Banner Design etc. And Web Design based on these fields, WordPress, HTML & CSS, PSD to responsive HTML to WordPress etc. I even worked with some clients as a Virtual Assistant and I have done well on all of them. So I can tell you confidently that Admin assistant or virtual admin is also one of my strong skill. Even I am fully expert in web research, extracting email, data mining, Google, Bing, Yahoo, MS Office (Full), Google Docs, Google Document, Google Spreadsheet, Ad words, Analytics, Webmaster, PR, B2B Marketing, Lead Generation, Directory and other related programs. This is a summary of me. You can now take your decision and if has any opportunity then that will be very glad for me. Looking forward to hearing from you. And thanks a lot for your response. Thanks once again.
$20 USD σε 10 ημέρες
5,0 (9 αξιολογήσεις)
3,9
3,9
Avatar Χρήστη
A proposal has not yet been provided
$55 USD σε 3 ημέρες
4,5 (11 αξιολογήσεις)
3,2
3,2
Avatar Χρήστη
A proposal has not yet been provided
$52 USD σε 2 ημέρες
5,0 (2 αξιολογήσεις)
2,1
2,1
Avatar Χρήστη
I am expert in excel and can do your work.
$45 USD σε 5 ημέρες
5,0 (2 αξιολογήσεις)
1,2
1,2
Avatar Χρήστη
HI I WANT THIS JOB.................................................................................................
$52 USD σε 10 ημέρες
0,0 (1 αξιολόγηση)
0,0
0,0
Avatar Χρήστη
can you choose me to merge it? i ill sure the project can be done on time and i will do with hard work.
$52 USD σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hello I will be happy to work on your project and assure you I can deliver this within the day. I am new here and offering my services at a low cost.
$35 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
$45 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
$52 USD σε 9 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Riverside, United States
4,9
252
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιαν 13, 2010

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.