Help build a Leave tracker and Effort Time Estimation Tracker

cherias

New Member
Joined
Sep 9, 2015
Messages
15
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.
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top