Process:
The OBH sheet is updated every morning with the details of the trips that are running that day.
Copy the full schedule from the admin panel and paste it in an excel sheet.
Put a filter on the ‘Status’ column, choose the canceled ones and delete them.
Choose the option to ‘custom sort’ the whole data and sort it by
Transport company
Driver name
5. Select the following columns and delete them:-
S. No, Confirmed, Canceled, Bus Capacity, Status, Trip Type, Driver Phone, Gross Revenue, Discount, Net Amount, Passenger Details and Trip History.
6. Copy the remaining data from the excel sheet and paste it in the OBH sheet. Then put the appropriate cost type and amount in front of every trip.
