Hi there, i need to draw up a s-curve in excel, the problem is that i need to get the info out of primavera. The info that i need is BL actual duration, BL duration and BL remaining duration based on perscent complete on a weekly basis to draw up the s-curve....can someone please help

 

Regards

Wayne

how to make s-cuvre in excel easy way.i mean very fast.why iam asking this question because it takes lot of time.please help

Ahmed:

1) Please only press the submit button once to avoid double-posting

2) Please don't reply to topics that are 7 years old

3) Please don't reply to topics asking a question that has nothing to do with that topic -start a new topic instead.

 

Thanks,

 

Gary

MSP = CPM scheduling, PERT based risk analysis (3rd party risk analysis add-ons are also available)

Pertmaster = CPM scheduling, Monte Carlo based risk analysis (see Risk Features)

RiskyProject = CPM scheduling, Event Chain risk analysis

Chris Hendrickson, Department of Civil and Environmental Engineering, Carnegie Mellon University published a free on-line version of Project Management for Construction which contains a chapter on Advanced Scheduling Techniques which discusses PERT, Monte Carlo and other risk analysis techniques.

Bernard Ertl
eTaskMaker Project Planning Software

Hi guys,

The point is does not matter if you are planning manually on a drawing board or using the best state of the art software, you have to understand the result of the answers you are getting. Let me put it straight:

1: MSP - This is a planning program that is very simplistic, and tends to give the wrong answers if you give it anything that is remotely complex to plan, and don’t even think of using resources in it. However I will say in it’s defence, that it probably has some nice presentation features, if you don’t know how to use a drawing board, it is better in the boardroom than trying to show management your planning on the back of a cigarette packet. For any planner that understands his trade, will understand the for the purposes of ensuring that an activity must either have an FF or FS relationship to get a critical path. However, in a lot of instances there is the need for SS relationship, and in a lot of instances in combination with FF, the fact that5 MSP have never allowed this is probably it’s greatest weakness. The fact is I have used MSP on several large projects, where the client demanded it becase of it’s price, as all contractors could not afford anything better, and I also have to use it on a daily basis on projects where the sub-contractors use it. I know it’s shortcomings, and always make sure I run a program like P3 or Open plan in parrallel to know what the true answers is. If you have planned manully, it is easy to spot when there is an error in the calculations that is normally caused by the algorithm used in the software.

2: Pertmaster: In this instance the software looks at logic, and in particular does not like certain types of logic, like FF 0 and SS 0, for instance, as well as certain other logic. There are also other factors taken into acount which is pre-programmed into the software. However, what the software does not take into account is day to day practical problems which creates risks that can jeopardise any project. A couple examples from recent experience:
a: The project required 90 welders to be carried out in time. However, the problems experienced to get the right number of visas to get 90 welders onto site as none were available locally would have been overlooked by a risk analysis program like Pertmaster. Explain how this type of risk must be analysed by a risk assesment program, it is why the human mind is necessary to do this in conjunction with the software. A simple histogramme and experince will tell you what the risks are.
b: Safety: Hazops, PDA’s, Rigging studies, are all factors leading to delays. On a project I have recently completed, we had a 13 week delay as a risk assesment, which could not be sorted out, mainly as a result of human politics, and it went in a 360 degree circle and the original design was accepted. The problem was on the main feeder cables, and as a result the power to the plant was four weeks late, however by managing the problem, a with the use of float buffers, the project will achieve completion four weeks early.

Therefore, to understand risk analysis software, you must understand their shortfalls, in the instance of the safety problem, the pertmaster program showed massive risks, but neithe it nor it’s operators understood the management behind the problems.

The answers are plain, there is a need for experienced, Pro-active planners, in combination with software that give the right answers, and both of the software programs discussed here fall far short of the requirement I have outlined.

Regards, and good luck with your thesis JC.

Philip

Hi Alex Wong,

we do update the schedule and the software showed me the project is about 1.5 years late compare with the target. But this 1.5 year is based on our input (late land handover,and endless negotiation with the goverment...),we can’t expect all these at the very beginning of the project, so no matter what software you have, you still can not evaluate the risk. if these information is avaiable, even without any software, you will have some ideas about the risk.

I agree with you a good tool is important, but there is something more important.

zhang haixiang

Sorry to jump on your comments please look at this as a positive Criticism.

Your schedule cannot tell you that the project is going to be delayed by 1.5 year, that means your schedule is not properly set up and updated." - Why I stated that -
Yes tools is a tool but you need the right tools to help you making decision. Ie we can fasten a screw without a screw driver, but to have is fasten properly you need the tool to help you. If your schedule cannot do proper forecast, that you are not using your tool properly.

Cheers

Why don’t you contact Pertmaster and MS Project for a demonstration disk for study purposes? They may be kind enough to help.