Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2015, 11:30 AM
Emanol Espina Emanol Espina is offline Seperate Cost per Resource Group and Taskname Windows 7 32bit Seperate Cost per Resource Group and Taskname Office 2013
Novice
Seperate Cost per Resource Group and Taskname
 
Join Date: Nov 2015
Posts: 4
Emanol Espina is on a distinguished road
Default Seperate Cost per Resource Group and Taskname

Hello everybody,

Im currently planing a bigger project.
I already have defined various tasks with subtasks and already assigned resources and materials to every subtask.

My problem is the following:
My resources are divided into different Resource Groups (in reality these are different Companys which Im going to contract and pay).

For the payment I would like to know per task the sum of the cost for each resource group/company e.g. two resources of the same company are working on one task so I would like to see automatically how much money I have to pay to the company per task.

Currently I just managed to see the total cost per task or the cost per resource in each task.

Would be great if anybody could help me.

Best regards
Emanol
Reply With Quote
  #2  
Old 11-29-2015, 11:19 AM
JulieS JulieS is offline Seperate Cost per Resource Group and Taskname Windows 7 64bit Seperate Cost per Resource Group and Taskname Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You should be able to get close by grouping on the Task Usage view. Here are some step by steps
1. Apply the Task Usage view
2. Add the Cost field to the view
3. Insert the Text 1 field and add the formula: [Outline Number] & " " & [Name]
4. Create a custom group with the following definition:
Group by:
Field: Text1
Field Type: Task
Order: Ascending

Then by:
Field: Resource Group
Field Type: Assignment
Order: Ascending
You'll need to turn on the option "Group assignments not tasks" to be able to set the field type to assignments.

Apply the group.
Reply With Quote
  #3  
Old 12-01-2015, 10:19 AM
Emanol Espina Emanol Espina is offline Seperate Cost per Resource Group and Taskname Windows 7 32bit Seperate Cost per Resource Group and Taskname Office 2013
Novice
Seperate Cost per Resource Group and Taskname
 
Join Date: Nov 2015
Posts: 4
Emanol Espina is on a distinguished road
Default

Hello Julie,

thank you very much for your answer.
I already created the filter as you said, but what I dont understand is what you mean with step 3:

"3. Insert the Text 1 field and add the formula: [Outline Number] & " " & [Name]"

Cheers
Emanol
Reply With Quote
  #4  
Old 12-01-2015, 11:25 AM
JulieS JulieS is offline Seperate Cost per Resource Group and Taskname Windows 7 64bit Seperate Cost per Resource Group and Taskname Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Filters won't work, you'll need to create the group. What I mean in step 3 is:
Insert the Text1 field into the view. Go to the Add A column start to type Text1 to insert the field. Then right click on the field and choose "Custom Fields". Enter the formula into the field.
Reply With Quote
  #5  
Old 12-01-2015, 03:06 PM
Emanol Espina Emanol Espina is offline Seperate Cost per Resource Group and Taskname Windows 7 32bit Seperate Cost per Resource Group and Taskname Office 2013
Novice
Seperate Cost per Resource Group and Taskname
 
Join Date: Nov 2015
Posts: 4
Emanol Espina is on a distinguished road
Default

Great(-:

It worked thanks a lot Julie.

The only problem I have now is that Project just groups the subtasks. That is already a great help, but I would have to sum all the subtask of one summary-task to get the information for the total of one summary task.

Is there a way to get the information for the summary-tasks in the same way your group explanation shows me for the subtasks?

Cheers and thank you very very much
Emanol
Reply With Quote
  #6  
Old 12-02-2015, 12:17 PM
Emanol Espina Emanol Espina is offline Seperate Cost per Resource Group and Taskname Windows 7 32bit Seperate Cost per Resource Group and Taskname Office 2013
Novice
Seperate Cost per Resource Group and Taskname
 
Join Date: Nov 2015
Posts: 4
Emanol Espina is on a distinguished road
Default

Hello Julie,

I also tried the solucion from the following forum:

https://social.technet.microsoft.com...nal2010general

I think you also left some comments their.

I tried the solucion with the macro, and yes it shows me what I want to see, but Ive got the same problem as with the "group by" solucion:
It just shows the information for the sub-tasks and not for the summary tasks.

If you have any further advice, I would be very greatfull.

Best regards
Immanuel
Reply With Quote
  #7  
Old 12-17-2015, 02:59 PM
JulieS JulieS is offline Seperate Cost per Resource Group and Taskname Windows 7 64bit Seperate Cost per Resource Group and Taskname Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Is the value in Text1 applied to tasks or summary tasks?

You could add to group by Project in the group definition - but something tells me that you are really inserting projects. Where is the "project" defined?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seperate Cost per Resource Group and Taskname [Project 2013] More accuracy with resource, unit %, and cost? cag8f Project 18 01-02-2016 01:51 PM
Seperate Cost per Resource Group and Taskname Different cost rates for resources for different projects linked to the Resource Pool Hanloujohn3515 Project 1 10-31-2015 11:58 AM
Seperate Cost per Resource Group and Taskname Cost resource not taken in real cost pascalbidouille Project 1 08-21-2015 01:25 PM
Portfolio Analyzer Cube - Cost Resource Question seanpears99 Project 2 03-07-2013 06:59 PM
entering values for a cost type resource ketanco Project 3 12-26-2011 09:25 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:02 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