Data Sort / Merging

Bu proje atifdar tarafından 48$ USD karşılığında bir gün içinde başarıyla tamamlandı.

Bunun gibi bir proje için ücretsiz teklifler alın
Proje Bütçesi
$30 - $250 USD
Tamamlanma Süresi
1 gün
Toplam Teklif
Proje Açıklaması



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.

Gereken Beceriler

Biraz para kazanmak mı istiyorsunuz?

  • Bütçe ve zaman çerçevenizi belirleyin
  • Teklifinizin anahatlarını verin
  • Çalışmanız için ödeme alın

Bu projeye de teklif veren Freelancerları işe alın

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