Looking at a free lancer to create a roster mechanism in excel for scheduling cabs & tracking the utilization .
Receive shift inputs in excel from employees
Upload the consolidated shift inputs
Map it with the employee's address
Schedule a vehicle with at least 95% occupancy & generate a unique trip id for every trip
Print a trip sheet with the employee details & a Barcode for the unique trip to be scanned to capture data
Also track employee/driver/cab/guard attendance
5 freelancere byder i gennemsnit ₹9883 på dette job
As you have mention in your project that to Create Roster mechanism for scheduling cabs & tracking the utilization i think this may be done properly and scheduled through Sql backend database. And monitored well.