Microsoft Project Field That Calculates Hours Remaining for a Project after a certain date

Amanda_316,

Wow, a rather convoluted process. When you talked about actual hours through a given time period I assumed you were using the Actual Work field to input those hours. However, based on your latest post, it appears you have an independent custom field (i.e. EOPM) where you enter those hours. In that case the "planned future hours" will be shown in the Remaining Cumulative Work field in the timescaled data as Trevor shows. This same value would also be available in the Baseline Remaining Cumulative Work, if you had set a baseline. But since you are not entering data into the Actual Work field, either timescaled field should meet you needs for "planned future hours".

I don't understand how your planned future hours can have much meaning if it doesn't take into account actual accrued hours but maybe you account for that in a way not explained.

To answer your question about how Trevor got the "Work after January" column, it is a simple copy and paste of the timescaled data for February (note his screen shot shows the February timescaled column selected).

Hope this gets you what you need/want and if so please consider marking one of Trevor's responses as the answer.

John

status date is today 17:00, and all tasks are marked on track. Any help?

Amanda Adams2,

Again, what exactly is your definition of "work planned"? Is it the current schedule remaining work from today, is it baseline work from today, or something else? You said the Remaining Work field does not describe "your planning" so we need to know exactly what "your planning" is.

I can get you the information you want either via custom fields or via VBA, but not until I understand exactly what you want.

In particular, how can "work planned after today" not be directly related to total work minus actual work, as of today?

Your screen shot shows a visual report with a project portfolio with 3 projects. In Project do you have a master with 3 inserted subprojects (i.e. linked structure) or do you simply have a single project file with separate summary lines for each "project"?

John

It may be better to explain as I am looking for a field to just calculate work planned after today, regardless of how much actual time has been spent so far (Actual Work). I usually get this information from the Task Usage report, and filter the dates to remove all data from the past:

I was hoping to be able to have this calculated directly in the MPP file instead of having to create the report and filter it down each time.

I hope this explains better!

Amanda Adams2,

Entering time "booked" into the Actual work column is exactly what you should do but the the part about hours booked in the future "based on our planning" is the open question. It's impossible to help you with a custom calculated field without fully understanding what that means.

Do you not use the baseline fields? That's where the "planned" data should be.

Perhaps an example screen shot would help.

John