EXCEL - Complex Employee Planner w/Dashboard

Closed

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

REQUIREMENTS:

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: Excel

See more: want employee, tab scope, scheduling jobs, out of scope requirements, ms project jobs, ms excel jobs, jobs ms project, gantt project management free, employee required, employee of the month picture, dashboard functionality, availability dashboard, weekends off, account management jobs, gantt project, i want to employee, gantt, excel w, excel graphs, excel charts, employee, employee needed, excelchart, scope effort, view planner

Project ID: #5162992

24 freelancers are bidding on average $465 for this job

bharanisrihari

Hi, I'm an Excel expert / VBA programmer. I can get your requirements done perfectly! Please refer the excellent reviews for my completed projects in Freelancer.com. One of the reviews for your reference: "Where More

$833 USD in 15 days
(60 Reviews)
6.3
Toperfection

Dear "gbren" Hope you are doing well. I have reviewed the project details and would like to offer our services. We have completed many Research/Data collection/Product add/Data mining assignments on freelancer.com a More

$526 USD in 5 days
(25 Reviews)
5.9
amitchaps

Hi, This is Amit from India. Expert in excel macro development and creating excel based apps. We have created various management systems in excel along with systems like quotation generation tool,an invoice system More

$670 USD in 10 days
(4 Reviews)
5.3
javed1705

I am an ACCA , APA and Mcom finance having full command over advance excel You project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully More

$263 USD in 3 days
(29 Reviews)
5.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$333 USD in 10 days
(18 Reviews)
4.7
zExcel

Hi, I will be happy to help you create this workbook, but I would like to see the data first if at all possible

$350 USD in 2 days
(22 Reviews)
4.7
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche More

$555 USD in 20 days
(29 Reviews)
4.6
Tablassus

Dear Sir This project seems interesting and doable based on my past experience with this type of problem. THE SOLUTION: ============ I have 50 % of this project done since I have build in the past a custom GAN More

$277 USD in 7 days
(13 Reviews)
4.6
SiroosJafary

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past exper More

$466 USD in 15 days
(11 Reviews)
3.8
Edison1983

***Similar Projects I've done. Please refer my Portfolio.********** Survey Dashboard with charts having sorting ability and so on. Good Day!....I'm an Expert in Excel VBA Automation. Having 6+yrs of Exp. Have dev More

$250 USD in 2 days
(11 Reviews)
3.7
tomislav1975

I can help you with your project. I have done such projects (please check my portfolio) and I can make it any way you want / need. Please contact me on PM for details.

$655 USD in 20 days
(4 Reviews)
3.4
inoussakabore

I am a statistician working as a database manager there is 4 years. I am ready to do this job for you.

$526 USD in 3 days
(2 Reviews)
3.3
Midlander

I have completed several similar assignments. Normally I would provide a sample to let you judge my skill for yourself, But you made this a "restricted" project. I can't send an attachment unless you send me a Private More

$480 USD in 5 days
(4 Reviews)
3.2
gitapodder1989

I am ready to do the job for you and hopefully I can do it nicely with very good quality of output in time.

$500 USD in 12 days
(2 Reviews)
3.1
Aldo21

Hi, please check some of my previous work on VBA excel: https://www.dropbox.com/s/edubgxgaypsd9hp/BUDGET%20PROJECT.xlsm https://www.dropbox.com/s/sc321g7qhdlshgj/FORM_FINALV02.xlsm https://www.dropbox.com/s/cv More

$250 USD in 6 days
(9 Reviews)
2.9
kuberudu

A proposal has not yet been provided

$555 USD in 3 days
(4 Reviews)
1.3
RAJCDAC

Ready to take on the task,you can expect 100 percent time bound results.will complete as per your deadline

$515 USD in 10 days
(2 Reviews)
0.9
samarsoft2013

Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to works.Ready to More

$555 USD in 3 days
(0 Reviews)
0.0
raghukcd

We have a team of 5 members and all are Microsoft VBA experts. We will create a excel workbook as you described in project details.

$666 USD in 20 days
(0 Reviews)
0.0
RonelBenade

I have a Masters Degree in Computer Science and several awards. You are most welcome to have a look at my LinkedIn profile at http://za.linkedin.com/pub/ronel-benade/4b/2b7/232 Please feel free to contact me.

$290 USD in 2 days
(0 Reviews)
0.0