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 gratefulResources 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 thanksExporting 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 - thanks
Tasks 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?
Resources 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.Project 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. CarlosPWA 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?
