Exporting Project - Resource Usage table with phased time data to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2731163%22%20slang%3D%22en-US%22%3EExporting%20Project%20-%20Resource%20Usage%20table%20with%20phased%20time%20data%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2731163%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20there%20a%20way%20to%20export%20tasks%20to%20excel%20while%20retaining%26nbsp%3Bthe%20phased%20time%20cost%20data%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Project1.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308794i1C3722B733571101%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Project1.png%22%20alt%3D%22Project1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20an%20ideal%20world%20I%20would%20like%20to%20export%20this%20info%20and%20for%20it%20to%20look%20like%20this%20in%20excel%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Project2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308795i7601902E20A5474F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Project2.png%22%20alt%3D%22Project2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EExport%20wizard%20is%20not%20doing%20the%20trick.%20Good%20old%20copy%20paste%20is%20copying%20the%20Resource%20list%2C%20but%20not%20the%20time%20phase.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20ideas%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2731163%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eexport%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EResource%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etable%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2732282%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20Project%20-%20Resource%20Usage%20table%20with%20phased%20time%20data%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2732282%22%20slang%3D%22en-US%22%3EMartin%20--%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20are%20two%20methods%20you%20could%20try%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Create%20a%20custom%20Visual%20Report%20in%20Microsoft%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20Write%20VBA%20code%20to%20do%20the%20export.%3CBR%20%2F%3E%3CBR%20%2F%3ERegarding%20the%20second%20item%2C%20John%20-%20Project%20answers%20questions%20regularly%20in%20this%20user%20forum%2C%20often%20involving%20VBA%20code.%20Perhaps%20he%20will%20see%20this%20conversation%20and%20be%20able%20to%20offer%20you%20some%20guidance.%20Hope%20this%20helps.%3C%2FLINGO-BODY%3E
New Contributor

Hi Experts,

Is there a way to export tasks to excel while retaining the phased time cost data?

Project1.png

 

In an ideal world I would like to export this info and for it to look like this in excel:

Project2.png

 

Export wizard is not doing the trick. Good old copy paste is copying the Resource list, but not the time phase.

Any ideas?

 

 

2 Replies
Martin --

There are two methods you could try:

1. Create a custom Visual Report in Microsoft Excel.

2. Write VBA code to do the export.

Regarding the second item, John - Project answers questions regularly in this user forum, often involving VBA code. Perhaps he will see this conversation and be able to offer you some guidance. Hope this helps.

@martindc 

I'm the John guy Dale referred to and yes I can help you with VBA to export Project timescaled data to Excel. I can write code to create the spreadsheet you show in your 2nd screen shot but I don't think that's really what you want. Look closely. The material resource "boiler floor space" shows 140 square meters which is correctly spread over 4 days in Project's Resource Usage view. Yet somehow, that 140 square meters has morphed into 175 square meters spread over 5 days on the Excel spreadsheet. Details, details.

 

I've done this very type of export for a ton of users and myself over the years. If you'd like my help with this, I suggest we work one-on-one via e-mail. I will ask some questions. My contact info is below.

John

jmacprojataticlouddotdotcom

(remove obvious redundancies)