Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2012, 02:43 AM
chabuk1 chabuk1 is offline Create a resource sheet in MS Project Windows 7 32bit Create a resource sheet in MS Project Office 2010 32bit
Novice
Create a resource sheet in MS Project
 
Join Date: Apr 2012
Posts: 2
chabuk1 is on a distinguished road
Default Create a resource sheet in MS Project

Hi,
I am trying to create the below sheet in MS Project -

Dept Labour days 4/16/2012 4/23/2012 4/30/2012 5/7/2012
Modeling 30 2 2 1
Texture 30 1 1 1 2
Rig 25 1 1 1 1

Where the numbers 2 & 1 are the number of resources required for that particular week.



Please let me know if I can do this in Project 2010.

Regards,

Chabuk
Reply With Quote
  #2  
Old 04-18-2012, 05:25 AM
JulieS JulieS is offline Create a resource sheet in MS Project Windows 7 64bit Create a resource sheet in MS Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You can get close with the Task Usage view, zoomed out to a weekly basis. After assigning the resources to tasks as needed -- format the timescaled (right side) of the Task Usage view to show "Peak Units". This will show maximum assignment units for the week in percentage. If you wish to show the data as decimals, change the setting in Options from 'percentage' to decimal.

I hope this helps.

Julie
Reply With Quote
  #3  
Old 04-18-2012, 05:56 AM
chabuk1 chabuk1 is offline Create a resource sheet in MS Project Windows 7 32bit Create a resource sheet in MS Project Office 2010 32bit
Novice
Create a resource sheet in MS Project
 
Join Date: Apr 2012
Posts: 2
chabuk1 is on a distinguished road
Default

Thanks for the response but thats not what I was looking for. I can maybe send you an excel of which I would like to make it in Project. Do you have an option where I can send you the file?

Regards,

Chabuk
Reply With Quote
  #4  
Old 04-19-2012, 07:26 AM
JulieS JulieS is offline Create a resource sheet in MS Project Windows 7 64bit Create a resource sheet in MS Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm afraid you won't get exactly what you have in Excel from Project -- two different pieces of software -- two different purposes.

Can you tell me what was in error with the example I gave you? It may not be possible in Project to accomplish the exact format you have in Excel.

Have you looked at the Visual Reports?
Reply With Quote
  #5  
Old 04-26-2012, 12:52 PM
Trigger Trigger is offline Create a resource sheet in MS Project Windows 7 32bit Create a resource sheet in MS Project Office 2007
Novice
 
Join Date: Apr 2012
Posts: 8
Trigger is on a distinguished road
Default

Am I right in saying that modelling only takes 3 weeks out of the 4 and that Modelling, Texture and Rig are tasks?
Reply With Quote
  #6  
Old 04-26-2012, 03:42 PM
JulieS JulieS is offline Create a resource sheet in MS Project Windows 7 64bit Create a resource sheet in MS Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

My interpretation was Modeling, Texture, and Rigs were resources.
Reply With Quote
  #7  
Old 04-27-2012, 04:05 AM
Trigger Trigger is offline Create a resource sheet in MS Project Windows 7 32bit Create a resource sheet in MS Project Office 2007
Novice
 
Join Date: Apr 2012
Posts: 8
Trigger is on a distinguished road
Default

My understanding was that modelling etc were tasks and that the numbers 1 & 2 were the number of resources required in a given week, ie, looking at the below, to complete the modelling task you need 2 the first week, 2 the second week and 1 the third week.

Modeling 30 2 2 1

This being the case, give the resources names, hours and rates etc within the resource area and allocate them to the tasks accordingly.

I might be wrong but that is how I have read it.
Reply With Quote
  #8  
Old 04-27-2012, 02:38 PM
JulieS JulieS is offline Create a resource sheet in MS Project Windows 7 64bit Create a resource sheet in MS Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I don't know and unless chabuk1 posts back -- likely we'll never know.
Reply With Quote
  #9  
Old 05-01-2012, 12:59 PM
Trigger Trigger is offline Create a resource sheet in MS Project Windows 7 32bit Create a resource sheet in MS Project Office 2007
Novice
 
Join Date: Apr 2012
Posts: 8
Trigger is on a distinguished road
Default

, yep and it looks like, we will never know.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a resource sheet in MS Project resource leveling in ms project ketanco Project 1 12-24-2011 12:58 PM
Create a resource sheet in MS Project Resource Column in MS Project 2003 seenai Project 18 06-10-2011 03:23 AM
Need to Create a Resource Driven Schedule gamer83 Project 2 05-24-2011 03:56 AM
Resource Usage sheet - options Andy Bain Project 1 11-05-2010 12:42 PM
MS Project Resource Chart fherbert PowerPoint 0 09-09-2010 12:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft