Completed

HLP Historical Analysis

I need someone to take the sheets that have data for the months January 2017 to May 2018 (total of 17 sheets or months) and put the data into the two sheets labeled "Month" and "Date".

1)

For the "Date" sheet, the first column is all the customer IDs for all the 17 sheets, the second column "17-Jan" is the total amount in the "Amount" column that matches the Customer ID for that month sheet i.e. "January 2017" sheet. In the "17-Feb" column, that is the total amount in the "Amount" column for each Customer ID in the "February 2017" sheet, and I need that for all the other sheets to put into the "Date" sheet.

2)

For the month sheet, the first column is all the customer IDs for all the 17 sheets, and the "Month 1" column is the first payment that the Customer ID made a payment (found in the "Amount" column for each month in order January 2017, February 2017, etc.), "Month 2" is the second month that Customer ID made a payment "Amount". The "Amount" should include the total amount that person made in their first month's payment (Month 1). If there are two Amounts in the same month, then add them up. For example, if the Customer ID did not have any amounts from the January 2017 Sheet but their first payment was in March 2017 for $100, then the "Month" 1 for that Customer ID should be $100.

If you are interested in this project, I need you to do the first two months and send me a sample so that I know that you can do this project. If you want this project, please only do the sample and reply with the message "I have done the sample, message me so I can show you". Thank you!

Skills: Accounting, Data Entry, Data Processing, Excel, Statistics

See more: i need a data entry person san francisco, i need a data entry clerk, i need to data entry worl, writing, technical writing, data entry, i need online data posting job pls help, i need online data entry job, i need freelancers data entry operators name mobile number, i need freelancers data entry operators name & mobile number, i need excel data entry, i need a data typist, i need a data entry person, i need a data entry part time job, i need a data entry job, i need a data entry job online where i don t have to pay to register, i need a data entry clerk houston tx, i have 60 business cards which i need the data to be entered into an excel sheet each category to have

About the Employer:
( 39 reviews ) Los Angeles, United States

Project ID: #17268210

Awarded to:

cranius

I have done the sample, message me so I can show you. Actually I have already done the full "Date" sheet, check here: [login to view URL] If you award me I will do the month and send it in a few hours. More

$17 USD in 1 day
(2 Reviews)
3.0

21 freelancers are bidding on average $27 for this job

Tanmoy236

"I am fast and Extremely Detailed Oriented. Completed more than 150+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great More

$30 USD in 1 day
(151 Reviews)
6.4
talhaahsan

Hello.I read the description of your project.I offer my services for this task.I already completed work like [login to view URL] contact with me so we discuss more about [login to view URL]

$25 USD in 1 day
(38 Reviews)
6.1
$25 USD in 4 days
(20 Reviews)
4.6
rIbrarahmed

Hi, I am very good in accounting and finance having 6 years of working experience in a multinational organization. And also very good in excel as well. I have done these type of projects before. And how can send you More

$25 USD in 1 day
(14 Reviews)
3.9
NataliyaKNA

Feel free to hire for: - Data entry - data processing - Microsoft Office - Microsoft Excel - PDF Conversion I believe that my skills and ability will prove to benefit your company. I am More

$111 USD in 2 days
(14 Reviews)
3.4
inspiredwhiz

I am an expert in data science, I've done a lot of projects in the field involving data pre-processing, data visualization, building predictive and clustering models using R and python, contact me for further discussio More

$10 USD in 1 day
(2 Reviews)
2.8
amrrrrrr

Welcome my friend ... I will start working from now on .... I am completely free……………………………………………………………………………………………..

$10 USD in 1 day
(2 Reviews)
1.5
antoinepal

I am an experienced Data Analyst with advanced excel skills. I can do your job really fast. I am ready to start! Thanks!

$30 USD in 1 day
(1 Review)
0.7
$25 USD in 1 day
(2 Reviews)
0.7
$15 USD in 1 day
(0 Reviews)
0.0
erssrivastava22

Project Understanding : There is a need to insert and update data in spreadsheet. Assumptions : 1) Data will be provided in the form of a spreadsheet(s), 2) Given data needs to be updated, I More

$25 USD in 1 day
(0 Reviews)
0.0
$29 USD in 1 day
(0 Reviews)
0.0
Mrx0258

Free time

$25 USD in 2 days
(0 Reviews)
0.0
markann0802

I have worked in the Customer Support Field for the past 6 years. I was a Team Leader in one of the BPO company in the Philippines. Most recently, I have been working as an email customer support in a company using More

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
buddhikarc

Hi, I have done the sample, message me so I can show you. But there is no option to attach it here. Can I have your email address to send it. Let me know whether I am doing it correctly, Thanks Buddhika

$30 USD in 1 day
(0 Reviews)
0.0
adsajuahmed

Hello Sir, I'm Saju Ahmed. I want to bid for this work. I can do it if you want to ...

$25 USD in 1 day
(0 Reviews)
0.0
sowjanya4betha

I am interested in data entry jobs and I can complete the given work ontime Relevant Skills and Experience Typing , data processing

$25 USD in 1 day
(0 Reviews)
0.0
faredaa800

استطيع ادخال البيانات عن طريق اكسل

$25 USD in 1 day
(0 Reviews)
0.0
$18 USD in 1 day
(0 Reviews)
0.0