Buildout excel capacity planning tool with drop down menus, and worksheet roll up to an aggragate

We would like to have someone help develop an excel capacity planning tool, with individual sheets for each employee that rolls up to an aggregate for the whole team. Ideally it will be color coded automatically based on our preference. Additionally, we would like to have a visual representation of capacity for the whole team and by each individual team members. We would want team members to be able to quickly adjust their individual capacity and allow that to adjust the aggregate capacity spreadsheet, so the worksheets would need to have drop downs and be user friendly.

We want to be able to see at a glance from an individual team member level whether or not someone has capacity currently, forward projecting capacity and projections of what we think maximum capacity from a team and individual level might look like.

Skills: Excel

See more: excel capacity planning, dependant drop boxes excel, lock drop menu excel, import data using drop menu excel, lock drop box excel, lock drop list excel, install drop box excel, pricing tool excel, lock drop field excel, visual search tool excel, percentage tool excel, dependent citystate drop list excel, start macro word drop box excel, google stock exchange tool excel, sms providers drop list excel

About the Employer:
( 0 reviews ) Seattle, United States

Project ID: #12010739

Awarded to:

$50 USD in 1 day
(6 Reviews)