custom columns for WKS
in [Project]
|
From: Andrew Lavinsky on 27 Jan 2010 09:30 What's the first day of the first week in the Gantt, and what is your Project Start Date? We probably need to do a bit more "base offsetting" in the formula to match the two up. - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > Thank you very much for the feedback. I used this exact formula and > was very pleased that I got mostly the results I was looking for. I > was hoping to post a picture of what I got but can't. I did get the > wks in the columns. But they are not exactly lining up with the wks > in the gantt. What kind of adjustments do I need to make? > > Thanks again. > > Penny > > "Jim Aksel" wrote: > >> Andrew has it with one additional thing... >> "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per >> Day]),0) +1 >> You need to add the 1 at the end becuase the ProjDateDiff function >> returns 0 for the week containing the project start date. So it is a >> "0 base offset" in geek terms. >> >> The formula works fine regardless of start date day of week. >> >> Thanks Andrew! >> -- >> If this post was helpful, please consider rating it. >> Jim Aksel, MVP >> >> Check out my blog for more information: >> http://www.msprojectblog.com >> "Penny" wrote: >> >>> I would like to create a formula in a custom field that tells me >>> what week my start date is in. I have my gantt set up to show WK1, >>> WK2, etc. I would like to have that same week designation in a >>> custom column. Can I do that? >>> >>> thanks. >>> >>> Penny >>>
From: Sai on 27 Jan 2010 10:31 Andrew Lavinsky Catapult Systems wrote: > What's the first day of the first week in the Gantt, and what is your Project > Start Date? We probably need to do a bit more "base offsetting" in the formula > to match the two up. > > > - Andrew Lavinsky > Blog: http://blogs.catapultsystems.com/epm > > > Thank you very much for the feedback. I used this exact formula and > > was very pleased that I got mostly the results I was looking for. I > > was hoping to post a picture of what I got but can't. I did get the > > wks in the columns. But they are not exactly lining up with the wks > > in the gantt. What kind of adjustments do I need to make? > > > > Thanks again. > > > > Penny > > > > "Jim Aksel" wrote: > > > >> Andrew has it with one additional thing... > >> "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per > >> Day]),0) +1 > >> You need to add the 1 at the end becuase the ProjDateDiff function > >> returns 0 for the week containing the project start date. So it is a > >> "0 base offset" in geek terms. > >> > >> The formula works fine regardless of start date day of week. > >> > >> Thanks Andrew! > >> -- > >> If this post was helpful, please consider rating it. > >> Jim Aksel, MVP > >> > >> Check out my blog for more information: > >> http://www.msprojectblog.com > >> "Penny" wrote: > >> > >>> I would like to create a formula in a custom field that tells me > >>> what week my start date is in. I have my gantt set up to show WK1, > >>> WK2, etc. I would like to have that same week designation in a > >>> custom column. Can I do that? > >>> > >>> thanks. > >>> > >>> Penny > >>> Can you change the formula to "WK" & Round(ProjDateDiff([Project Start],[Start])/(7*[Minutes Per Day]),0) +1 Sai, PMP PMI-SP MCT MCTS
From: Penny on 27 Jan 2010 12:06 The week is starting on Monday and the start date is Feb 1. "Sai" wrote: > Andrew Lavinsky Catapult Systems wrote: > > What's the first day of the first week in the Gantt, and what is your Project > > Start Date? We probably need to do a bit more "base offsetting" in the formula > > to match the two up. > > > > > > - Andrew Lavinsky > > Blog: http://blogs.catapultsystems.com/epm > > > > > Thank you very much for the feedback. I used this exact formula and > > > was very pleased that I got mostly the results I was looking for. I > > > was hoping to post a picture of what I got but can't. I did get the > > > wks in the columns. But they are not exactly lining up with the wks > > > in the gantt. What kind of adjustments do I need to make? > > > > > > Thanks again. > > > > > > Penny > > > > > > "Jim Aksel" wrote: > > > > > >> Andrew has it with one additional thing... > > >> "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per > > >> Day]),0) +1 > > >> You need to add the 1 at the end becuase the ProjDateDiff function > > >> returns 0 for the week containing the project start date. So it is a > > >> "0 base offset" in geek terms. > > >> > > >> The formula works fine regardless of start date day of week. > > >> > > >> Thanks Andrew! > > >> -- > > >> If this post was helpful, please consider rating it. > > >> Jim Aksel, MVP > > >> > > >> Check out my blog for more information: > > >> http://www.msprojectblog.com > > >> "Penny" wrote: > > >> > > >>> I would like to create a formula in a custom field that tells me > > >>> what week my start date is in. I have my gantt set up to show WK1, > > >>> WK2, etc. I would like to have that same week designation in a > > >>> custom column. Can I do that? > > >>> > > >>> thanks. > > >>> > > >>> Penny > > >>> > > Can you change the formula to "WK" & Round(ProjDateDiff([Project > Start],[Start])/(7*[Minutes Per Day]),0) +1 > > > Sai, PMP PMI-SP MCT MCTS > . >
From: Jim Aksel on 28 Jan 2010 01:08 Oops, that "7" needs to be a "5" as ProjDateDiff calculates business days. More technically, it should not be 5 either: 5*[Minutes Per Day] should read [Minutes Per Week] with no integer at all. Thanks for keeping me on my toes. -- If this post was helpful, please consider rating it. Jim Aksel, MVP Check out my blog for more information: http://www.msprojectblog.com "Sai" wrote: > Andrew Lavinsky Catapult Systems wrote: > > What's the first day of the first week in the Gantt, and what is your Project > > Start Date? We probably need to do a bit more "base offsetting" in the formula > > to match the two up. > > > > > > - Andrew Lavinsky > > Blog: http://blogs.catapultsystems.com/epm > > > > > Thank you very much for the feedback. I used this exact formula and > > > was very pleased that I got mostly the results I was looking for. I > > > was hoping to post a picture of what I got but can't. I did get the > > > wks in the columns. But they are not exactly lining up with the wks > > > in the gantt. What kind of adjustments do I need to make? > > > > > > Thanks again. > > > > > > Penny > > > > > > "Jim Aksel" wrote: > > > > > >> Andrew has it with one additional thing... > > >> "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per > > >> Day]),0) +1 > > >> You need to add the 1 at the end becuase the ProjDateDiff function > > >> returns 0 for the week containing the project start date. So it is a > > >> "0 base offset" in geek terms. > > >> > > >> The formula works fine regardless of start date day of week. > > >> > > >> Thanks Andrew! > > >> -- > > >> If this post was helpful, please consider rating it. > > >> Jim Aksel, MVP > > >> > > >> Check out my blog for more information: > > >> http://www.msprojectblog.com > > >> "Penny" wrote: > > >> > > >>> I would like to create a formula in a custom field that tells me > > >>> what week my start date is in. I have my gantt set up to show WK1, > > >>> WK2, etc. I would like to have that same week designation in a > > >>> custom column. Can I do that? > > >>> > > >>> thanks. > > >>> > > >>> Penny > > >>> > > Can you change the formula to "WK" & Round(ProjDateDiff([Project > Start],[Start])/(7*[Minutes Per Day]),0) +1 > > > Sai, PMP PMI-SP MCT MCTS > . >
From: Penny on 28 Jan 2010 08:38 Okay so I have changed to the Minutes Per Week. I have done the 7, then the 5, then none at all. I am still not matching with the wks shown in the gantt with any of these different combinations. "Jim Aksel" wrote: > Oops, that "7" needs to be a "5" as ProjDateDiff calculates business days. > More technically, it should not be 5 either: > > 5*[Minutes Per Day] should read [Minutes Per Week] with no integer at all. > > Thanks for keeping me on my toes. > -- > If this post was helpful, please consider rating it. > > Jim Aksel, MVP > > Check out my blog for more information: > http://www.msprojectblog.com > > > > "Sai" wrote: > > > Andrew Lavinsky Catapult Systems wrote: > > > What's the first day of the first week in the Gantt, and what is your Project > > > Start Date? We probably need to do a bit more "base offsetting" in the formula > > > to match the two up. > > > > > > > > > - Andrew Lavinsky > > > Blog: http://blogs.catapultsystems.com/epm > > > > > > > Thank you very much for the feedback. I used this exact formula and > > > > was very pleased that I got mostly the results I was looking for. I > > > > was hoping to post a picture of what I got but can't. I did get the > > > > wks in the columns. But they are not exactly lining up with the wks > > > > in the gantt. What kind of adjustments do I need to make? > > > > > > > > Thanks again. > > > > > > > > Penny > > > > > > > > "Jim Aksel" wrote: > > > > > > > >> Andrew has it with one additional thing... > > > >> "WK" & Round(ProjDateDiff([Project Start],[Start])/(5*[Minutes Per > > > >> Day]),0) +1 > > > >> You need to add the 1 at the end becuase the ProjDateDiff function > > > >> returns 0 for the week containing the project start date. So it is a > > > >> "0 base offset" in geek terms. > > > >> > > > >> The formula works fine regardless of start date day of week. > > > >> > > > >> Thanks Andrew! > > > >> -- > > > >> If this post was helpful, please consider rating it. > > > >> Jim Aksel, MVP > > > >> > > > >> Check out my blog for more information: > > > >> http://www.msprojectblog.com > > > >> "Penny" wrote: > > > >> > > > >>> I would like to create a formula in a custom field that tells me > > > >>> what week my start date is in. I have my gantt set up to show WK1, > > > >>> WK2, etc. I would like to have that same week designation in a > > > >>> custom column. Can I do that? > > > >>> > > > >>> thanks. > > > >>> > > > >>> Penny > > > >>> > > > > Can you change the formula to "WK" & Round(ProjDateDiff([Project > > Start],[Start])/(7*[Minutes Per Day]),0) +1 > > > > > > Sai, PMP PMI-SP MCT MCTS > > . > >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: how do i reset the Unique ID field in Project 2003? Next: Macro for filter |