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.
Đã trao cho:
33 freelancer đang chào giá trung bình $120 cho công việc này
Hi I am Excel Expert and VBA Programmer I have my cool team and can split job over them or make to work in shifts If interested, contact me I can do it before deadline Thanks & Regards