Dackson
Member
Dear Sir,
I am facing a big problem for make trip allowance sheet for each employee, can you help me?
Point below mentioned for your clarification.
This is a logbook of which is going for attend breakdown at outside of the workshop.
The first 5 sheet containing the details of 5 different commercial vehicle logbooks for attend outside running vehicles breakdown.
Each commercial vehicle brings one to five mechanic employees with its each trip for attend breakdown and one day they can attend may be more than one trip with the different commercial vehicle or may be nil.
In a sheet S to X column representative Employee’s code no (who are going to attend breakdown in the vehicle) see the heading EMP 1 to EMP 6. But employee code will be come any cell between S to X column, its mean an employee one day will come EMP 1 cell the next trip may be the code will be EMP 4 cell and the same employee will come the next sheet EMP5 cell.
Each trips every employees they will get trip allowance. It’s depend of their working used timing (less than 3 hours work nothing they will get, 3 to 6 Hours amount will be 10/-, 6 and above hours work will get 15/-)
The sixth sheet me required the report of each employee’s total trip allowance for the current month. When we choose the code of an employee in the report sheet automatically want to display the current selected employee’s total attended trip with the all row details. It will be sorted. See the example of EMP code of B311 in the seventh sheet.
Please help for me…………
I am facing a big problem for make trip allowance sheet for each employee, can you help me?
Point below mentioned for your clarification.
This is a logbook of which is going for attend breakdown at outside of the workshop.
The first 5 sheet containing the details of 5 different commercial vehicle logbooks for attend outside running vehicles breakdown.
Each commercial vehicle brings one to five mechanic employees with its each trip for attend breakdown and one day they can attend may be more than one trip with the different commercial vehicle or may be nil.
In a sheet S to X column representative Employee’s code no (who are going to attend breakdown in the vehicle) see the heading EMP 1 to EMP 6. But employee code will be come any cell between S to X column, its mean an employee one day will come EMP 1 cell the next trip may be the code will be EMP 4 cell and the same employee will come the next sheet EMP5 cell.
Each trips every employees they will get trip allowance. It’s depend of their working used timing (less than 3 hours work nothing they will get, 3 to 6 Hours amount will be 10/-, 6 and above hours work will get 15/-)
The sixth sheet me required the report of each employee’s total trip allowance for the current month. When we choose the code of an employee in the report sheet automatically want to display the current selected employee’s total attended trip with the all row details. It will be sorted. See the example of EMP code of B311 in the seventh sheet.
Please help for me…………
