| MS Project 2004 - Fill color, for a cell, 'Task Name' column - How Posted: 25 Mar 2005 07:37 AM PST Hi Jack
on that topic .. any ideas on when the next version will be out (not that i
want another version!)
Cheers
JulieD
"JackD" <momokuri@gmail> wrote in message
news:phx.gbl...
|
| Im building a webpage how do I access access 2002, any indepth so. Posted: 25 Mar 2005 06:39 AM PST Hi Donna
if you're using Frontpage to build the website then there's a good article
on the topic at
http://support.microsoft.com/default.aspx?scid=kb;en-us;825502
Cheers
JulieD
"Donna" <microsoft.com> wrote in message
news:com...
|
| relative start/stop times Posted: 25 Mar 2005 02:19 AM PST ProjDateDiff works like a charm! I tried the DateDiff earlier but that gave
"#ERROR" in every field.
Thanks,
hans
"Jan De Messemaeker" wrote:
|
| Earned Value Graph Posted: 24 Mar 2005 06:19 PM PST Have you tried the "Analyze timescaled data in excel" add-in that comes with
Project? It should export what you need to excel and you can then chart
away.
If you want something simpler you can write some VBA code. The following
requires that you have resources assigned to each task and that the resource
has a cost associated with it. If you do not have a resource loaded
schedule, you can simply make a dummy resource with a cost of 1 and assign
it to all tasks. Then baseline the project and run this macro. It exports
into a .csv file that can be opened with excel
MyFile = "c:\" & "HardwareBreakout" & ActiveProject.Name & "_" & Date$ &
".csv"
fnum = FreeFile()
Open MyFile For Output As fnum
mystring = ActiveProject.Name & " " & ActiveProject.LastSaveDate & " " &
Application.UserName
Write #fnum, mystring 'write project info
Write #fnum, ' Write blank line.
jPeriod = 7 'select time reporting period 1 = 1 day, 7 = 1 week
jStart = ActiveProject.ProjectSummaryTask.Start
jEnd = ActiveProject.ProjectSummaryTask.Finish
jStatus = jStart
myBCWS = 0
myACWP = 0
Do While jStatus <= jEnd + jPeriod
ActiveProject.StatusDate = jStatus
'CalculateProject
myBCWS = 0
myACWP = 0
For Each myTask In ActiveProject.Tasks
If (Not myTask Is Nothing) And (Not myTask.summary) Then
myBCWS = myBCWS + myTask.BCWS
myACWP = myACWP + myTask.ACWP
End If
Next myTask
mystring = jStatus & ", " & myBCWS & ", " & myACWP
Write #fnum, mystring 'write project info
jStatus = jStatus + jPeriod
Loop
Close #fnum
End Sub
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
..
"Paul" <microsoft.com> wrote in message
news:com...
stocks
completion
info
but
boss
700-task
do this
I do
|
| Variance Formula incorporating multiple baselines needed Posted: 24 Mar 2005 01:45 PM PST Hi CJ,
I suggest you check for no baseline first using >50000 for Baseline NA and I
think you could simplify the logic by doing that. Also, I use current date
(reporting date) as the compare date. Also, why check for baseline start and
baseline finish. Just one or the other. I check for an active baseline finish
and compare . Whilst I am not checking for multi baselines perhaps use the
following as a guide.(where 0 = no basline, 1 = black (completed), 2 = green,
3= yellow, 4 = Red):
IIf([Baseline Finish]>50000,0,IIf([Baseline Finish]<=([Current Date]-7) And
[% Complete]<100,4,IIf([Baseline Finish]<=[Current Date] And [%
Complete]<100,3,IIf([Baseline Finish]>=[Current Date] And [%
Complete]<100,2,1))))
Good luck with it...............Pratta
"JackD" wrote:
|
| Changing Work and Duration Based on Resource Utilization Posted: 24 Mar 2005 01:25 PM PST Hi John
I think you have to decide whether it is a fixed duration, fixed work or
fixed units task.
I tend to plan in duration so set all tasks by default to fixed duration;
and control in work (after I baseline). I don't like fixed units. But you
sound like you want the resource units to remain at 80%, so set the task to
fixed units, and it won't change on you. Its a personal preference thing.
You now are the keeper of the units. If you add the resource at 80% and set
to Fixed Units the first time you add the resource, duration must now alter
(increase) and does to 6.25 days. If you dont like that then reduce the
duration to 5 days and work will decrease to 32 hrs. W=D*U, and something
has to give and it sounds like you don't want it to be the resource.
Regards.............Pratta
"Rod Gill" wrote:
|
| Keeping some resource local Posted: 24 Mar 2005 12:25 PM PST Thank you so much! I would not hav eknown to take those steps. I appreciate
your help.
"Dale Howard [MVP]" wrote:
|
| Task completes before due date Posted: 24 Mar 2005 12:05 PM PST Hi KT
Dales sugegstion is excellent. I am going to try that. I was just going to
add that to ensure you show all tasks when you baseline to ensure baseline
and EV data is recorded at the task level, and that cost data is recorded
against each resource.
Also, when rebaselining, tick to rollup to summary boxes.
Of course, you must also key time accurately at the task level and use a
timesheet tool or the Task Usage view to record time.
Regards............Pratta
"KT" wrote:
|
| Excel link to percent complete? Posted: 24 Mar 2005 10:11 AM PST In article <com>,
Gueuze <microsoft.com> wrote:
Gueuze,
No, I'm not brilliant but I'm glad it works for you.
John
|
| Realistic Project Resourcing Posted: 24 Mar 2005 07:37 AM PST Hi,
When the earliest start date of this additional work allows for it leveling
WILL detect it and schedule it through the dips.
Of course if you have scheduled this addi work to be later (be it by a
constraint or by a dependency) leveling will not make it happen earlier.
When you say we cannot majke the roof before the walls, the fact that the
roofmakers are available does not make any change does it?
HTH
--
Jan De Messemaeker
Microsoft Project MVP
+32 495 300 620
http://users.online.be/prom-ade
"Tosh" <com> wrote in message
news:4242e019$0$22500$news.newnet.co.uk...
|
| front page Posted: 24 Mar 2005 07:33 AM PST Hi
Frontpage is a Microsoft Product which is available for purchase - you can
however, create web pages using Publisher without having Frontpage.
check out
microsoft.public.publisher
for a publisher related newsgroup and
microsoft.public.frontpage.client
for front page questions
Cheers
JulieD
"Charlain" <microsoft.com> wrote in message
news:com...
|
| Moving large amount of data Posted: 24 Mar 2005 07:29 AM PST You get best answers in an Excel newsgroup, but the quick answer is to
select the data, do Edit Copy, then Edit Paste Special, Transpose. But
rmemeber, there are only 256 columns so if you're transposing rows into
columns and columns into rows, you can only have a maximum of 255 rows in
your source data before you run out of room in the target range.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"WHSCC" <microsoft.com> wrote in message
news:com...
|
| Report names Posted: 24 Mar 2005 04:25 AM PST Simpler method, go to File>Properties and change the name there.
SarahK
|
| How do I write recommendation letter Posted: 24 Mar 2005 02:09 AM PST In article <googlegroups.com>,
"davegb" <com> wrote:
Dave,
My lips is sealed.
John
|
| Actual hours posted to future dates Posted: 23 Mar 2005 11:45 PM PST No, but you identified an important factor I should have included in my
original post.
"Rod Gill" wrote:
|
| Creating resource pool from multiple project plans Posted: 23 Mar 2005 05:07 PM PST Hi Baba
Create the new resource file and share it with the required files files. It
should have no tasks, only resources.
Tools, Share Resources and set to "pool takes precedence" and ensure the
drop down includes the files you intended.
Also ensure that the old files are still not connected by checking both the
respool and the old files i nTools Resoures/Resource Sharing
All calendar setting should be done within this respool file.
This should work fine for what you are doing. I woud password protect the
Respool file, to preclude schedule owners from adding resources themselves.
This should stop most of the problems Mike was mentioning from occurring. The
respool needs to be managed centrally. I also set all calendars in the
respool file. On most occasions there is no need to open the respool file for
update when editing the schedules. This shoud be done weekly by the PM or
administrator.
Regards......Pratta
"baba1970" wrote:
|
| Why Changing the hours per day in one calendar affects all others? Posted: 23 Mar 2005 11:01 AM PST The "hours per day" "hours per week" and "days per month" fields on the
calendar options page does NOT change any of the calendars. I know that
sounds like I'm crazy but none the less it's true. Those settings are
conversion factors used strictly for convenience when you enter or Project
displays durations, to allow you to work with data in your plan without
having to mentally convert everything to hours. Project stores all its data
in minutes. If you enter a task and set its duration to 3 days, Project has
to know how many working hours "3 days" actually stands for. Do you work 8
hours a day so it means 24 working hours or do you work 7 hours a day so it
means 21 working hours? The "hours per day" field on the calendar options
page does exactly that - it tells Project *how many* hours out of the
24-hour day should considered the standard length of the working time. The
calendar, accessed through the Tools menu, tells Project *which* of the
minutes in the day are working time. The "hours per day" should agree with
your Project calendar but setting hours per day DOES NOT change any of the
calendars themselves. Also, hours per day is a global setting so you might
have other calendars with differing numbers of work hours.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"subzizo" <microsoft.com> wrote in message
news:com...
|
