Resource Charts - filtering & Summary
In the Open Standard
Andrew OwensonMember for 18 years 4 months
- Created
- 3
- 5
0
Planners
I have a programme which covers a multiple of buildings, I have resourced the activities with the various trades. What I would like to do is - filter each building out so that I can print a resource histogram for each trade for each building and also a summary of "men" for each building and would love to be able to produce a stacked histogram for the same. I would also like to do the same for the whole project as a summary. At the moment I can only get individual resource charts for each trade for the whole project. I have not used the resource capabilities of MSP before so if you could make any replies idiot proof I would be eternally gratefull.
My thanks in advance - oh I forgot to mention - I am under a bit of pressure to do this quickly.
Regards
Andrew
I have a programme which covers a multiple of buildings, I have resourced the activities with the various trades. What I would like to do is - filter each building out so that I can print a resource histogram for each trade for each building and also a summary of "men" for each building and would love to be able to produce a stacked histogram for the same. I would also like to do the same for the whole project as a summary. At the moment I can only get individual resource charts for each trade for the whole project. I have not used the resource capabilities of MSP before so if you could make any replies idiot proof I would be eternally gratefull.
My thanks in advance - oh I forgot to mention - I am under a bit of pressure to do this quickly.
Regards
Andrew
3 replies
Oldest first- 0Trevor Rabey ·Since you need it quick, here it is rough and not checked.
Easiest way to separate the buildings is to use a spare Text field and just fill in the field with ctrl-D (fill down) Building 1, Building 2 etc, then make a filter (Project, Filtered For etc) which reads the field.
I think that if you filter out the buildings you don’t want and then go to the Resource sheet, Resource graph etc, you should get the graphs just for the building that the filter brings back. Not sure, not checked. - 0Trevor Rabey ·Say you have 3 buildings.
Just delete all of the resources for 2 of them (ctrl-D) from a blank cell) directly in the Resource Names column of the Entry Table. Then run/print the graph etc in Resource Graph View, then close the file, don’t save, re-open and do the same for the other buildings.
Or save the Resource Names column in a spare text column so you can copy/paste to and from it so you don’t have to close and re-open.
This might seem clumsy but should work.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?