Microsoft Project: Using Graphical Indicators

[gorefish]

Can you post the formula you used for the %complete variance column? Thank you!

[patxipiratak]

Thans I think is a good video to undestand the graphics symbols and some formules.

I would like know if the are another video about how create formules .

Sinceraly form Basque Country

[Violetster]

Excellent, superb, BRAVO!  Thanks for the tips!

[MrBabylonlion]

if i have 5 elements or sub tasks in my project the 1st 1000 hrs , 2nd 3000 hrs , 3rd 5000 , 4th 500 hrs . 5th 500 hrs , What is the overall % Complete with decimal if the % work Complete for the 1st task 100% , 2nd 49 % , 3rd 88% , 4th 90 % ???? I want the overall % Complete depending on the work complete for each task with decimal , can I have your E.Mail ?? thank u very much.

[Amberlina03]

Thank you so much for your videos, they're helping me a lot! Do you happen to know if there is a way to insert an image into Project, similar to how you can insert an image in an Excel cell? (I have MS Project 2010 Standard.)

[mfaghihi]

Thanks for great videos!

[bmuijen]

Did someone find the formula on google? I'm not able to find a comparable formula, and can't read the formule from the video clearly...

[cparedes08]

Thanks for the video, very simple but never knew about it. I will apply it right to my current project on monday

[SirGanttalot]

Thanks for the feedback. I'm glad the information is of real, practical help to you.

[graspman]

@SirGanttalot

thank you for this video. I also see immediate practical use. One question, do you have the formula posted anywhere for the % complete Variance? I followed along with you step by step and am just missing the formula to immediatly integrate into my current project plan.

[blarson75]

Sir Ganttalot, Do you know if there is a way to get your indicator to show up over in the Gantt Bar View rather than in a column?

[SirGanttalot]

Thanks for the question. If you just want to print with indicators you could paste versions of them as graphics onto the Bar area of a Gantt chart. You would need to create them as png. or other objects in a drawing package. Making them appear automatically isn't feasible. Don't forget you can filter any Gantt view to include only tasks that meet certain criteria. The criteria could match the indicator criteria. So you could filter for just late, slipping, overbudget tasks, etc.

[azamora2005]

cool video... It would be interesting to listen your perspective about Critical Chain Management.

Thanks for the great job!

looking forward for your next video.

[SirGanttalot]

Thanks! People who like the Critical Chain approach find it VERY helpful. It is best used when availability of resources is a serious constraint. A critical path is calculated without taking resources into account, resource constraints are then factored in, a new CP is calculated, and duration "buffers" are calculated. The PM then focuses on managing buffers and managing resources. MS Project does not support CC directly, but some CC products do interface with MSP. Give it a whirl!

[graspman]

@SirGanttalot

Actually I mentioned the wrong formula. In my previous post I asked for just the formula to % complete variance. I meant to also ask for the more complicated formula for Baseline Variance. Much appreciated!

[SirGanttalot]

Hi, I just sent you a message on this issue. Let me know if this helps.

[sevensteps007]

Great Video Sir

You catch a man a fish-you feed him for a day. You show a man how to catch a fish - you feed him for lifetime. Thanks for taking a lead in the second approach.

Very clear, efficient and effective, It will help me a lot in Project Management.

[rafaelnos]

Thank you sir,

[avs137]

thanx