Overtime, Scheduling and Timesheet excel expert

Closed Posted 3 years ago Paid on delivery
Closed Paid on delivery

I really need to impress my boss for a promotion.

My document is messy so any help to make it look great would be helpful. Unfortunately my budget isn't that much.

My wishlist items are as follows:

1. The overtime calculations to be correct against the timesheet. Rules are in the OT_Code tab

2. Individual timesheets per staff member instead of everything on one sheet (can go up to 100 staff). Some VBA to make it hidden. the times are pulled through automatically from the Actual_Roster page by Vlookup on the Duty_Codes Page. Timesheets are only amended manually if someone is late. If not amended it sticks to default times.

3. A great dashboard that shows a whole bunch of stats, perhaps overtime, rostered shifts etc.

Currently number 1 is the priority.

Just to explain some things:

1. all staff names are pulled from the Staff_List sheet

2. All shift codes are pulled from the Duty_Codes sheet

3. All Overtime info is from the OT_Codes sheet

4. Actual_Roster is a duplicate of planned roster (changes made manually on actual_roster)

5. All dates are pulled from the Dashboard tab

6. My Hours Tab is for reference (I know my formulas are lengthy but I don't know excel well, but they seem to work). The labels are as follows:

*SH - Total Shift Hours

*BR - Total Break hours (1 every 5 hours)

*WD1 - Working hours (breaks have been removed) for day of shift start

*RH1 - Regular hours (04:00-21:00) for WD1

*NH1 - Night Hours (21:00-04:00) for WD1

*WD2 - Working hours (breaks have been removed) for next day if past midnight duty occurs

*RH2 - Regular Hours for day 2

*NH2 - Night Hours for day 2

I need the overtime calculations to go in the highlighted column under the Overtime Sheet. White column all hours passing 8 hrs that fall within (04:00-21:00) to go into this column. Dark grey column is for the night hours.

The tricky part is if someone is on a 12 hour shift and they finish at 22:00, 2 hours is overtime as a maximum of 8 hours is allowed with a 2 hour break. But 1 hour falls on the regular hours and one hour falls on the night. This has to be recorded accordingly.

Another example is if they finish a shift at 01:00 and have 3 hours overtime, 2 hours must be in the night range for day 1 and 1 hour must be in the night range for the next day.

I hope this will make sense to you.

NOTE: I know my date formula on my timesheet next to the individual times is incorrect. I'll fix that.

Excel Visual Basic PHP Data Processing Data Entry

Project ID: #27852853

About the project

12 proposals Remote project Active 3 years ago

12 freelancers are bidding on average $45 for this job

schoudhary1553

Hi, Greetings! ✅checked your project details: Overtime, Scheduling and Timesheet excel expert ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same ki More

$60 USD in 2 days
(498 Reviews)
8.4
dhanrajkarthick

Hi there, Gone through your requirements and i clearly understood what you need. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Kindly go through my profile and come back for the discussion. More

$50 USD in 2 days
(42 Reviews)
5.2
AnuradhaVM

Hi, Greetings! ✅checked your project details. I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data analysis and MIS Management. I have strong analysis, and Excel skills and am able to provide More

$45 USD in 7 days
(25 Reviews)
4.2
Usama0709

where lo is the amplitude of input current and k is the fee-space wave number. • Plot the 3-D polar pattern of the far-field at two different sets of view angles. • Plot the radiation pattern in the x-y plane (9 = 900 More

$50 USD in 1 day
(4 Reviews)
3.5
faizan0017

Dear Boss, Greetings to you! I have read and understand every aspesct of your project. Will try my best to get you a big deserved promotion from your boss. Please come to chat and let me explain few things to you. Th More

$50 USD in 3 days
(1 Review)
1.4
sohidulislam571

Hello, From your job description I have learned that the requirements you have asked for data entry work excel sheet. I have proficiency in MS office. Working with me will surely bring you many good as I am very creati More

$40 USD in 2 days
(0 Reviews)
0.0
rahul896938

Hello sir, My name is Rahul Kumar and I have been working as a data entry specialist for over 2 years. I am a thorough researcher with an eye for important and relevant facts, and I am experienced in sortin More

$15 USD in 2 days
(0 Reviews)
2.8
Praveenkumarg235

I have read your job description and interested to deal with you. I am offering my service on short notice. Relevant skills and experience please consider me and give me a chance to impress you by my quality services.

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

Hi sir, I can do this job in 4 days or as soon as possible. So you can hire me for your job at cheap rate. Thank you sir.

$45 USD in 4 days
(0 Reviews)
0.0
FurkanAtaman

Hi My name is Furkan Ataman. I am Turkish. I have worked as Production Engineer for 5 years. Most of times, I used Excell, VBA coding and SAP ERP during working, scheduling ex. This is my first job as freelancer. I wi More

$30 USD in 3 days
(0 Reviews)
0.0
mccombsbeth

I have a Bachelor of Science Degree in Accounting from an accredited college - Western KY University - and 35 years of experience. I am proficient in payroll and payroll taxes. My data entry is extremely fast and have More

$30 USD in 7 days
(0 Reviews)
0.0