Report of nominal deliveries versus real deliveries

[argaii]

Hi everyone,

I created a Project with different deliveries in different days. For example, on 17th April I have to deliver 2 boxes (nominal delivery).

Due to delays in the project the delivery of the two boxes will be on 23rd April and 27th April.

Is there a report which shows the cumulative deliveries Vs the real deliveries?

I mean on x-coordinate the time (days, weeks...) and on x-coordinate the cumulative sum of deliveries.

Thank you for your help

[#2]

@argaii

Can you get a report like that? Yes, but not with any of Project's report formats (unless I've missed a trick). For a graph like you describe, I would export Project data to Excel and then create the graph there.

John

[#3]

Hi @John-project 

I also tought to export the data of the MS Project file to an Excel, but this is not a good solution for two reasons:

- I'm creating this MS Project file for the projects of the company where I work. The reports are useful not for me but for other colleagues which will have access to this MS Project, it will be shared

- The final purpose is to use MS Project online, in order to link it also woth MS Planner and send the tasks to the people which are working on the project and consequently the updates for the reports, everything in the cloud and shared

Anyway thank you for the suggestion 🙂

[#4]

argaii,
If you can live without the graph, a few custom fields can provide the data in Project but it may still require a macro.

John

[#5]

Hi,
Do you know this macro?
It's not a theme of survival, but I don't work alone and the deliveries through time are really important for our customers 😉

[#6]

argaii,
I'd have to write the macro, it's not something that already exists.

In your reasons for not wanting to export to Excel you mentioned an end goal of using Project Online and MS Planner. I assume you meant Project for the Web and Planner. Project for the Web is not the same as Project Online. Further, Project for the Web and Planner have much less capability than Project Desktop or Project Online. One reason I like to export data to Excel for sharing with others is that Excel is part of MS Office which is much more universal than MS Project (i.e. nearly everyone in business has access to Office but not to Project).

John

[#7]

Hi,
I meant to use Project Online and MS Planner. I have also Project desktop and I suppose that it can synchronize with its Online version.
If I understood well Project for the Web cannot integrate with MS Planner and cannot make reports.

I admit that I'm a newbie in MS Project, sorry for misunderstanding...

[#8 · Accepted solution]

argaii,
You might find the following link useful in understanding the various Project options, particularly the response from my colleague Dale Howard.
https://answers.microsoft.com/en-us/msoffice/forum/all/question-about-various-versions-of-microsoft/....

John

[#9]

Hi John,
I had a look at the post of your colleague.
We definitely need MS Project Online. This will allor the PM and the Project Planner to manage the project, assigning the tasks to the resources (they will be informed through MS Planner) and get the needed reports (maybe with the help of a macro)

[#10]

argaii,
So.....did I answer your question or do you still need help? I don't use Project Online or Planner, I leave that stuff to Dale but if you need something that requires VBA, then I'm your guy.

John

[#11]

Hi John,
Yes with your help I understood that my company needs to use MS Project Online in order to manage properly the projects.

When and if we will get it, I will ask for a macro for the needed report.

Thank you very much!

[#12]

@argaii,

You're welcome and thanks for the feedback.

John