Dear Experts,
Request you suggestion and guidance in building a EXCEL based tracker for capturing the team leaves and effort utilization/estimation.
Below I have listed the functionalities, which I intend to include -
Leave Calendar -
1) Person can select the day or days that he/she is planning to go on leave and select the category of leaves (Annual, Sick, Public Holidays) applied.
2) If some other teammate, tries to apply the leave for the same period, then a conflict message should pop-up but allow user to enter the leaves.
3) The leave applied by one person should be visible to others in read only mode in the calendar
4) There should be reporting enabled for team availability, which should enable the Manager to view the availability day wise or week wise.
5) The reporting should enable the manager to view, in case any extra leave during a period will hit or go below the threshold availability
Effort Estimation -
1) The interface will be used by the team, so the features and visibility to reports should be profile depended or restrictions enforced based on user profile
2) Each team member will work on one or multiple projects, so it should enable the team members to add PROJECTS, then for each project selected, there should be a combo box for the set of tasks to be performed and on the right hand side, there should be a boxes against each task, in which team members can input the time utilized in the task.
3) The total utilization spent on the tasks should then add up to the total utilization for that projects, which should also sum up to show, the total utilization of a team member per week, month wise and year wise.
4) Related reporting to show the utilization of team members, week/month wise, time utilization task wise and the total team utilization for week/month and also for each task.
Kindly guide me on building this please.
Request you suggestion and guidance in building a EXCEL based tracker for capturing the team leaves and effort utilization/estimation.
Below I have listed the functionalities, which I intend to include -
Leave Calendar -
1) Person can select the day or days that he/she is planning to go on leave and select the category of leaves (Annual, Sick, Public Holidays) applied.
2) If some other teammate, tries to apply the leave for the same period, then a conflict message should pop-up but allow user to enter the leaves.
3) The leave applied by one person should be visible to others in read only mode in the calendar
4) There should be reporting enabled for team availability, which should enable the Manager to view the availability day wise or week wise.
5) The reporting should enable the manager to view, in case any extra leave during a period will hit or go below the threshold availability
Effort Estimation -
1) The interface will be used by the team, so the features and visibility to reports should be profile depended or restrictions enforced based on user profile
2) Each team member will work on one or multiple projects, so it should enable the team members to add PROJECTS, then for each project selected, there should be a combo box for the set of tasks to be performed and on the right hand side, there should be a boxes against each task, in which team members can input the time utilized in the task.
3) The total utilization spent on the tasks should then add up to the total utilization for that projects, which should also sum up to show, the total utilization of a team member per week, month wise and year wise.
4) Related reporting to show the utilization of team members, week/month wise, time utilization task wise and the total team utilization for week/month and also for each task.
Kindly guide me on building this please.
