LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 3
Default Determine Resource Allocations by evaluating available time and required time.

Greetings!

I've finally run up against a wall, and need to plead for help.

What I have is this:

A list of 50 employees, and their available time (# of hours consolidated monthly) for 12 months.

a b c d e f g h i j k l m
Bob Network 64 120 177 0 0 0 0 0 0 0 0 0


I have another worksheet that contains 50 projects and the required time for each project (# of hours consilidated monthly) for 12 months.

a b c d e f g h i j k l m
projectName 20 16 25 0 0 0 0 44 55 78 99

Each project will require 4 employees each with a different skillset (Lead, Platform, Network, Storage).

What I need to do is find a Lead, Platform, Network and Storage employee for each project.

I need to end up with a worksheet containing project names and each of the 4 employee names that are available to work on that project.
a b c d e
ProjectName Bob Cindy Carla Steve

I've tried all manner of things to accomplish this, and have finally given up.

I've attached a spreadsheet with sample data to better illustrate what I'm trying to accomplish.

Can anyone help with a series of formulas/functions?

THANK YOU!!!!
Attached Files
File Type: zip Proj Portfolio and Allocations 2012.zip (31.0 KB, 102 views)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula required (2nd time) Sohail khan Excel Discussion (Misc queries) 9 March 25th 10 02:54 PM
time and resource mgmt HSF 20hour deadline Excel Discussion (Misc queries) 0 May 27th 06 03:51 PM
Evaluating Rank to determine formula Mary Excel Worksheet Functions 5 September 10th 05 05:33 AM
Resource / Time consuming macro Bryan[_7_] Excel Programming 2 July 29th 04 02:04 AM
Object required - run time error 424. devorivivere Excel Programming 3 April 10th 04 05:43 PM


All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"