Data Sort / Merging
Dự án này đã được trao cho atifdar với giá $48 USD.Nhận tin báo giá cho dự án tương tự
Ngân sách dự án$30 - $250 USD
Tổng đặt giá37
Mô tả dự án
I have a spreadsheets that I need aligned urgently.
There are two main headings:
(1) Contractor's Attendance Log - Time IN / OUT
(2) Client's Log of Contractor's Attendance - Time IN / OUT
(1) and (2) are both employee clocking in / out databases with the times manpower (around 730 people) clock in and clocked out of work. (1) is maintained by company X (building), (2) is maintained by company Y (client).
There are discrepancies between the times the manpower clocked in and clocked out as recorded in (1), compared to (2). So I need you to align the staff from both (1) and (2) down the left hand side of the spreadsheet (they're in different order in (1) from (2)), with the hours they clocked in and out as per (1) and then (2) along the horizontal.
There is a further spreadsheet, (3). Sheet (3) is the payroll details of the same manpower whose presence on site was recorded in (1) and (2). I need you to align the respective manpower payroll data on the right hand side of the spreadsheet. This is so that I can compare the amount of time each manpower entry was paid for in the payroll, against the time logged in (1) and (2).
The spreadsheets I have at present are daily for one month (so around 26 working days), I need these to be merged into one spreadsheet including the whole month.
I have two sets ((1) and (2)) of approx. 26 spreadsheets (each representing a working day in the month of August 2015), plus the payroll spreadsheet.
I need this completed by [url removed, login to view] GMT TODAY (20 March 2017).
If you can turn this around for me as a priority in good time (sooner the better but definitely before the deadline), I have a further 6 months of the same exercise that you could do.
If you can email me ASAP I'd be grateful.
Muốn kiếm tiến?
- Hạn định ngân sách và khung thời gian
- Mô tả đề xuất của bạn
- Nhận thanh toán cho công việc của bạn
Thuê những Freelancer đã đặt giá trong dự án này
Bạn đang tìm việc làm?
Làm việc cho những dự án như dự án này và kiếm tiền tại nhà!Đăng ký ngay
- The New York Times
- Wall Street Journal
- Times Online