Forum Widgets
Latest Discussions
Exporting resources to excel to create histogram
Hi I'm a scheduler who normally uses P6 (although I have used MS Project a little in the past!) I'm working on a tender schedule which has a stipulation to be presented in MS Project... all good so far, schedule built looks good, hits the key dates etc and now I've loaded it out with construction resources (masons/roofers/electricians etc), one of the tender deliverables is to present a resource histogram (showing numbers of operatives/day) of the project resource. I'm looking to export the project resources to excel to produce the histogram and this is where the issue is! The options as I see it are - Export a visual report - I exported a time-phase resource usage report but then hit a brick wall when I tried to manipulate the pivot table data to add a calculated field to convert the hours into a resource headcount as project export to Excel using OLAP cube data which isn't modifiable! Resource Usage View copy & paste - next I tried to straight up copy & paste the raw data from the Resource Usage view into excel to create my own pivot table but unfortunately left clicking to highlight all the date just didn't seem to work - I could highlight and copy the left hand table but the time phase data on the right hand side seems un-copyable, if I highlight it I don't get any copy option on the left click! Export to Excel - next I tried to export the raw data in xlsx format via File/Export/Save Project as File but then am unsure of which fields to set up when mapping to get the resources time phased, I just seem to be able to export the tabular info - Lastly I created a custom report using the in-built graphing tool in Project to create the histogram but this gives a couple of issues - the resource stats on the y-axis are in hours (obviously) with no way of converting to days and more importantly it is in Project and not in Excel as stipulated in the tender requirements! Am I missing something fundamental with this/is it possible? Any help would be gratefulChris_MercerJul 17, 2025Copper Contributor42Views0likes3CommentsResources histogram export to excel
Hi I'm a scheduler who normally uses P6 (although I have used MS Project a little in the past!) I'm working on a tender schedule which has a stipulation to be presented in MS Project... all good so far, schedule built looks good, hits the key dates etc and now I've loaded it out with construction resources (masons/roofers/electricians etc), one of the tender deliverables is to present a resource histogram (showing numbers of operatives/day) of the project resource. I'm looking to export the project resources to excel to produce the histogram and this is where the issue is! The options as I see it are - Export a visual report - I exported a time-phase resource usage report but then hit a brick wall when I tried to manipulate the pivot table data to add a calculated field to convert the hours into a resource headcount as project export to Excel using OLAP cube data which isn't modifiable! Resource Usage View copy & paste - next I tried to straight up copy & paste the raw data from the Resource Usage view into excel to create my own pivot table but unfortunately left clicking to highlight all the date just didn't seem to work - I could highlight and copy the left hand table but the time phase data on the right hand side seems un-copyable, if I highlight it I don't get any copy option on the left click! Export to Excel - next I tried to export the raw data in xlsx format via File/Export/Save Project as File but then am unsure of which fields to set up when mapping to get the resources time phased, I just seem to be able to export the tabular info - Lastly I created a custom report using the in-built graphing tool in Project to create the histogram but this gives a couple of issues - the resource stats on the y-axis are in hours (obviously) with no way of converting to days and more importantly it is in Project and not in Excel as stipulated in the tender requirements! Am I missing something fundamental with this/is it possible? Any help would be grateful - many thanksChris_MercerJul 17, 2025Copper Contributor18Views0likes2CommentsExporting resources to Excel
Hi I'm a scheduler who normally uses P6 (although I have used MS Project a little in the past!) I'm working on a tender schedule which has a stipulation to be presented in MS Project... all good so far, schedule built looks good, hits the key dates etc and now I've loaded it out with construction resources (masons/roofers/electricians etc), one of the tender deliverables is to present a resource histogram (showing numbers of operatives/day) of the project resource. I'm looking to export the project resources to excel to produce the histogram and this is where the issue is! The options as I see it are - Export a visual report - I exported a time-phase resource usage report but then hit a brick wall when I tried to manipulate the pivot table data to add a calculated field to convert the hours into a resource headcount as project export to Excel using OLAP cube data which isn't modifiable! Resource Usage View copy & paste - next I tried to straight up copy & paste the raw data from the Resource Usage view into excel to create my own pivot table but unfortunately left clicking to highlight all the date just didn't seem to work - I could highlight and copy the left hand table but the time phase data on the right hand side seems un-copyable, if I highlight it I don't get any copy option on the left click! Export to Excel - next I tried to export the raw data in xlsx format via File/Export/Save Project as File but then am unsure of which fields to set up when mapping to get the resources time phased, I just seem to be able to export the tabular info - Lastly I created a custom report using the in-built graphing tool in Project to create the histogram but this gives a couple of issues - the resource stats on the y-axis are in hours (obviously) with no obvious way of converting to days and more importantly it is in Project and not in Excel as stipulated in the tender requirements! Am I missing something fundamental with this/is it possible? Any help would be grateful - thanksChris_MercerJul 17, 2025Copper Contributor48Views0likes2CommentsTasks tab does not load
At a customer the tasks tab in the Project-app in PowerApps refuses to load by a specific user. Last week I was there for a training and it seemed the same problem occurred to me as well. The correct url's are already added to the pop-up (known issue). The tasks tab will only load after deleting cookies and other browser history; this has to be done with every browser session. It al worked fine untill recently. What could be the issue here?Chris_Kegler2100Jul 14, 2025Copper Contributor13Views0likes1CommentResources mapping using Project (Planner) and MS Power BI template
I have started using Project for the web and the MS Power BI template from MS. And I really like what I am seeing so far. How can I add a Resource Mapping view to the Microsoft Power BI Project for the Web template? I’d like to display the monthly percentage allocation for each resource, calculated based on remaining effort and the project schedule. Ideally, this view should also support filtering by project and by individual resource.sidimmJul 14, 2025Copper Contributor45Views0likes1CommentNeed Help in Project Operations connection with Project for Web
Can anyone suggest which Environment they are using in Dynamics 365 to use Project operations, is it CDS or CRM? or Does anyone knows how we can connect Project for Web and Dynamics 365 project Operations to see Projects and Tasks??Navdeep62Jul 09, 2025Copper Contributor262Views0likes1CommentProject Online- How to hide/show timescale from Schedule.aspx (PWA)
Hi all, Some time ago I had no problem to remove or add Timescale from Project Center or from a Project Schedule page (PWA).. Currently I have achieved "close" (or open) timescales in Project Center but not in Schedule page because web element only displays "Details" and there is not any mention to close-show Timescales. Do you know if there is still any way to show/hide timescales in Schedule page (PWA). Thanks in advance. CarlosCarlosMorenoVJul 07, 2025Copper Contributor120Views0likes3CommentsPWA Instance not found
Hi Community, I'm experiencing an unidentified issue, every time I create a new PWA instance, I can initially access it without problems, however, within less than a minute, I receive the message: "Sorry... the instance is not found." I’ve confirmed that the account has a Project license and admin permissions. Has anyone encountered this before or have any suggestions?KnowledgeseekerJul 07, 2025Copper Contributor73Views0likes4Comments
Resources
Tags
- Project689 Topics
- Online286 Topics
- Project Desktop153 Topics
- Project Server150 Topics
- office 36597 Topics
- developer75 Topics
- 201664 Topics
- On Premise54 Topics
- api51 Topics
- Reporting41 Topics