Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Start day & Finish day

6 replies [Last post]
Thu, 2006-07-20 12:20
Kris Harry
User offline. Last seen 13 years 13 weeks ago. Offline
Joined: 4 Oct 2004
Posts: 47
Groups: None
Hi Guys,

Can u guys let me know if we can show columns for start day and finish day - example day 120 as start day & day 125 as finish day for a 6 day activity and ow to do it.

Kris
Top

Replies

Tue, 2006-08-08 06:07
#1
Felis Muhammed
User offline. Last seen 5 years 4 weeks ago. Offline
Joined: 23 Jul 2006
Posts: 5
Groups: None
Sorry guys..2 times i did the same mistake in posting and finaly am replying under this thread


Just check if this is working

Go Data->Custom Data Items (CDI)

Add 3 CDI

1) Name-ORDD , Type-S, length-7, Description-Ordinal data date
2) Name-ORES , Type-N, length-7, Description-Ordinal ES
3) Name-OREF , Type-N, length-7, Description-Ordinal EF

Go Format-> columns
Add the 3 CDI to display on the view

Go Tools->Global change-> Add

In the ‘then’ statement add ORDD EQ your reference date (use calendar from list)

Trial run to see if it worked as per your wish and then run

Go Tools->Project Utilities->Export

Add new

Include “Activity custom data items” to the list

In the Format tab type the name of the file with location

Select type as [.DBF]

Run

Go-Excel

Open the exported DBF file in excel

Format columns ORS & ORF in number format

Use formula
ORS= ES-ORDD
ORF=EF-ORDD+1

Drag down the formula columns till the last activities.

Copy and paste the edited columns as values only.
Save the dbf file & exit (should exit)
go p3->Tools->Project Utilities->Import

Enter the name of the exported file with extention [.DBF]

Run

This is manual method and not dynamic. Donno if some other easy methods are there. Any way back up b4 running. Welcome your comments

Cheers

Felis
Top
Tue, 2006-08-08 00:23
#2
shamail shardan
User offline. Last seen 18 years 11 weeks ago. Offline
Joined: 22 Jan 2006
Posts: 23
Groups: None
Kris,

From my side, i think its not possible, if you could do it, plz let post the method.

Cheers
Top
Fri, 2006-08-04 09:56
#3
Kris Harry
User offline. Last seen 13 years 13 weeks ago. Offline
Joined: 4 Oct 2004
Posts: 47
Groups: None
Felis

If it’s Custom Data Item (CDI), it will not be a calculated item and I cannot get the start day and finish day (for early and late dates) for various activities of the project.

Kris
Top
Sun, 2006-07-30 22:23
#4
Felis Muhammed
User offline. Last seen 5 years 4 weeks ago. Offline
Joined: 23 Jul 2006
Posts: 5
Groups: None
Parves..

Is that Custom Data Item???..if so, Kris u can find it on Menu->Data->Custom Data Item. Using that u can make columns for showing customised data. Think it is datailed in P3 help.

Top
Sun, 2006-07-30 13:47
#5
Kris Harry
User offline. Last seen 13 years 13 weeks ago. Offline
Joined: 4 Oct 2004
Posts: 47
Groups: None
Thanks Praves,

I’ll try what u have suggested. What is CDI. Can u give the steps for the global change u are suggesting.

Kris
Top
Thu, 2006-07-20 23:34
#6
Praves Suppa
User offline. Last seen 1 year 51 weeks ago. Offline
Joined: 16 May 2006
Posts: 40
Groups: None
Hello Kris,

Global change & CDI could help you for ordinal dates showing..

Set CDIs for ordinal date of Staring Days and Finishing Day

Run global change for...

STARTDAY Equal ES - (the beginning day of the year.. ie year 1999 you have to choose 31 Dec 1998)

FINISHDAY Equal EF - (the beginning day of the year.. ie year 1999 you have to choose 31 Dec 1998)

Maybe a little help...

Best Regards,
Praves
Top