Dear Employer,
I can prepare a data base and map them in such way one would be able to track schedule by date/activity and many more function
Master Data : Fields in master data sheet
1) Employ ID, Work Assigned , From & to (Date & Time) , availability , Contract working Hours,
contact Information,
Tracking by date
1) Employ ID , Name , Activity Assigned, Time Period and availability based in Leave data and the cell are condition formatted .
Leave Data :
Employ ID, Name , Leave Entry Sheet ( This you can under stand only when you see the Idea)
Tracking By activity
Employ ID , Name , Activity Assigned, Time Period and availability based in Leave data and the cell are condition formatted .
Photo Bank:
Maintain the Photo of all employs Current Employs
Invoice
This will help in preparing bills for man power
This is just an idea if your interested ping me i will do Master data & Tracking by date with protection in work book .Once your happy you can award me the work and will complete the Job in 12 Hr after award
With Regards
Ramana