Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2015, 01:00 AM
and and is offline Project 2013 - resource capacity column Windows 7 64bit Project 2013 - resource capacity column Office 2013
Novice
Project 2013 - resource capacity column
 
Join Date: Feb 2015
Posts: 2
and is on a distinguished road
Default Project 2013 - resource capacity column

Hello,



where can I find the capacity of the resource (eg. monthly)? I have not found any column with this information.
To be clear - I mean the number of hours calculated from the calendars.

TIA
and

Last edited by and; 02-10-2015 at 02:55 AM.
Reply With Quote
  #2  
Old 02-10-2015, 03:31 PM
JulieS JulieS is offline Project 2013 - resource capacity column Windows 7 64bit Project 2013 - resource capacity column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

In the Resource Usage view add the remaining availability field to the timescaled portion (right side) of the view. Zoom out to months.

The Remaining Availability shows you capacity in hours based upon resource calendars, max. units, and any assignments.
Reply With Quote
  #3  
Old 02-11-2015, 01:31 AM
and and is offline Project 2013 - resource capacity column Windows 7 64bit Project 2013 - resource capacity column Office 2013
Novice
Project 2013 - resource capacity column
 
Join Date: Feb 2015
Posts: 2
and is on a distinguished road
Default

Thank you for the speedy reply.

Remaing Availability is not exactly what I need, but it help me a lot.

I need to make a report (eg. in Excel) to compare monthly resource capacity with assigned work and/or actual work (table with monthly capacity, work, actual work in columns and resources in rows).
Is it feasible at all?

regards
and
Reply With Quote
  #4  
Old 02-11-2015, 07:10 AM
JulieS JulieS is offline Project 2013 - resource capacity column Windows 7 64bit Project 2013 - resource capacity column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

The Resource Work Availability Visual Report can give you that information. All of the visual reports take data from Project and create Pivot tables in Excel.

Run the Resource Work Availability report and then do the following:

On the Resource Usage tab in Excel, click in to the Pivot table to show the Pivot Table field list.
In the list, select Resources to show the resource names.
Drag the calendar to Columns.
The default report shows Work Availability, Work, and Remaining Availability.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Project 2013 - resource capacity column [Project 2013] More accuracy with resource, unit %, and cost? cag8f Project 18 01-02-2016 01:51 PM
Project 2013 - resource capacity column MS Project Resource Capacity and Auto-levelling Senor_Babs Project 2 11-01-2014 02:46 PM
Remove resource name from Gannt Bar in Project Professional 2013? nick@johansens.eu Project 1 10-16-2014 05:58 AM
MSP 2013 - A new column needed a bit like resource names Peasy Project 5 09-18-2014 01:11 PM
Project 2013 - resource capacity column Resource Column in MS Project 2003 seenai Project 18 06-10-2011 03:23 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:40 AM.


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