Đã hoàn thành

Data Sort / Merging

Dự án này đã kết thúc thành công bởi atifdar với giá $48 USD trong 1 ngày.

Nhận tin báo giá cho dự án tương tự
Ngân sách dự án
$30 - $250 USD
Đã hoàn thành trong
1 ngày
Tổng đặt giá
37
Mô tả dự án

Hello

BRIEF

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.

SIZE

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.

DEADLINE

I need this completed by [url removed, login to view] GMT TODAY (20 March 2017).

FURTHER WORK

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.

Được hoàn thành bởi:
Các kỹ năng được yêu cầu

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online