Project planner template documentation

%3CLINGO-SUB%20id%3D%22lingo-sub-126646%22%20slang%3D%22en-US%22%3EProject%20planner%20template%20documentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-126646%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20trying%20to%20get%20a%20grip%20on%20the%20Project%20planner%20template%2C%20which%20creates%20a%20Gantt%20chart%20by%20using%20conditional%20color%20formatting.%20It%20works%20based%20on%20several%20defined%20names%20(PeriodInPlan%2C%20Actual%2C%20etc)%20and%20then%20a%20series%20of%20conditional%20formats.%3C%2FP%3E%3CP%3EI%20want%20to%20adapt%20it%20to%20my%20%22real%22%20project%20task%20data%2C%20and%20also%20change%20to%20show%20just%20colors%20for%20Done%20and%20Remaining...%3C%2FP%3E%3CP%3EAnyway%2C%20I%20struggle%20to%20understand%20how%20the%20Name%20definitions%20work%20(not%20in%20general%2C%20but%20the%20way%20they%20are%20used%20in%20this%20template).%3C%2FP%3E%3CP%3EIs%20there%20some%20kind%20of%20documentation%20with%20explanation%20(%22How%20this%20is%20done%22)%3F%3C%2FP%3E%3CP%3EThanks%2C%20Martin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-126646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1930625%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20planner%20template%20documentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89314%22%20target%3D%22_blank%22%3E%40Martin%20Kallenbach%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20also%20using%20the%20same%20template%20for%20my%20project.%20i%20want%20to%20exclude%20weekends%20and%20holidays%20from%20coloring%20i.e%2C%20not%20to%20consider%20weekends%20and%20holidays%20as%20a%20working%20days.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi, trying to get a grip on the Project planner template, which creates a Gantt chart by using conditional color formatting. It works based on several defined names (PeriodInPlan, Actual, etc) and then a series of conditional formats.

I want to adapt it to my "real" project task data, and also change to show just colors for Done and Remaining...

Anyway, I struggle to understand how the Name definitions work (not in general, but the way they are used in this template).

Is there some kind of documentation with explanation ("How this is done")?

Thanks, Martin

1 Reply

@Martin Kallenbach 

I am also using the same template for my project. i want to exclude weekends and holidays from coloring i.e, not to consider weekends and holidays as a working days.