Data Anlysis
$30-250 USD
Pagado a la entrega
I have two worksheets with lots of data
I need the first set of data to be matched agains the second.
I need this to be done manually to be sure
There are 1085 entries to check
Sheet one is a list of projects
Sheet two is a list of payments for those projects
Both have a matching project ID
Job is to match the payments to the projects
Some projects may have more than one payment
JOBS
1. In the project sheet create extra columns
Payment 1, Date, Amount, Amount in GBP 1, payment ID, Payment 2, Payment Date, payment id 2, Amount in GBP 2, Amount, Payment 3, Amount in GBP 3, Date, Amount, payment id 3
2. Look at the first payment in the payment sheet
Find the project and enter the payment into the first payment column adding the date, amount, amount in GBP (you will need to calculate) and payment id
Do this for each row in the payment sheet
If you find a second payment for a project the add it to the second set of columns Payment 2, Date 2 etc
3. Make a note or mark any payment in the payment sheet which you cannot find the project for
4. Bids
Now compare the bids
Nº del proyecto: #6636429
Sobre el proyecto
Adjudicado a:
Hello sir..i am interested on this project and ready for start now.......Please Provide me the excel sheet.........i will do this job for you with in time and with out doing and single mistake........Sir believe in lon Más
37 freelancers están ofertando un promedio de $105 por este trabajo
sir, i am highly interested and dedicated to do this task. let's discuss and start. i am awaiting for your positive reply. thanks
Hi there. I would be able to deliver the project in 2 days. I have read the description and I would like to discuss a few points. Kindly discuss. Regards.
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Más
Hello, I believe i have the necessary skills to provide you a good work. My bid is $100 f. Timeframe: 4 days (negotiable acording to your needs). Looking forward to have an opportunity to work in your project . Más
I've 2 years of experience working as a Data Entry Operator and Analyst in BRB International Agency. See My Profile. I'VE CLEARLY UNDERSTAND YOUR INSTRUCTIONS AND THE PROJECT. Your work'll be submitted in 3 days Más
Hi Experienced and expert data manager here I can easily do this job, I will start right now Looking forward to hear from you Thanks Fahad
Hello, i am expert in this type of jobs i will do a script to do the matching required then i will review it manually to check that it is correct can begin now payment after job completion waiting your Más
Hi, Thanks for checking my proposal. I have worked for several Data Analysis & Management assignments in the past. References available to show related skills. Quoting Negotiable price range & can work per Más
Hi, I have already worked on such a project, where you have a more than one matching values. It can be done using "if" and "vlookup" function together. If you can upload a sample I can show you what I mean. Als Más
Read my Cv in my portofolio section, if you are impressed hire me ! i think i am the best candidate for this job, if you want me to i can start right now
i am a good secretary and i am use to such job in excel sheet, i run petty cash and finance check report and for this job, such skills are required. if you hire me now i am sure to deliver the job properly done and on Más