EXCEL - Complex Employee Planner w/Dashboard

Avg Bid (USD)
Project Budget (USD)
$250 - $750

Project Description:
Needed: A complex excel workbook that will manage multiple tasks & functions performed by a corporate team.

1. First tab (workbook) should have a GANTT CHART style layout that highlights all the jobs and job requests for this working team. Each task shall be assigned priority, start date, end date, duration, % complete, working days, days complete, days remaining. Each task should have the ability (if necessary) to show collapsable sub tasks to manage project milestones. A pretty gantt chart should be shown beside this high level team overview. Each task should be able to capture multiple resources and manage the effort in hours/days/months (whatever is required). Each task can be either a single project or a daily\weekly\monthly repetitive task. The chart should only highlight actual due dates of the repetitive tasks (unlike Gant chart which would highlight an entire year, I want to highlight 1 day per month if that task is performed once per month for 5 hours on a single day.. get it ? ) Tasks should be sortable based on priority and completed tasks can be moved into a bucket at the bottom (out of sight but available for future reference).

2. Second tab (workbook) should show very nice charts and graphs that will show employee availability by day in a week view with hours blocked off for appropriate tasks based on priority. This should show all the tasks that fit into the day as well as tasks marked out of scope for the day due to scheduling issues. The purpose is to show entire team on one workbook (4-5 employees) and who is available for additional tasks. Who has free time.

This should follow all the basic principles in MS Project (account for work days not weekends, assign based on priority).

I've added a picture. I want that on steroids. on a lot of steroids. with much more functionality and people management features.

Skills required:
Additional Files: excel-gantt-chart-MF_large.gif
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

Hire bharanisrihari
$ 833
in 15 days
$ 526
in 5 days
$ 670
in 10 days
Hire javed1705
$ 263
in 3 days
$ 333
in 10 days
$ 350
in 2 days
$ 555
in 20 days
$ 277
in 7 days
$ 466
in 15 days
$ 250
in 2 days