S-CURVE generation
In the Open Standard
DA
D ArtagnanMember for 18 years
- Created
- 175
- 15
0
175 replies
Oldest first- 0ACAftab C Mohd ·Mr Artagnan,
I have been using MSP 2007 all along and creating the S curve using visual reports. Ever since the company switched to the p6 I have not been happy about my S curve. Your approach and integration sounds like perfect. Could you please send a copy to my mail address?
Mail me at cm@arconksa.com/ aftab.cmohd@gmail.com.
Thanx in Advance
Aftab
- 0AHAthar Hashmi ·Thanks Artagnan.
I got the file. But i need some troubleshooting from you.
While executing message appeared:
"ODBC - Connection to ’Primavera P6 SDK’ failed"
Then I follwed the same what you mentioned in your PDF file.
Linked Table Manager (Window)-
Select All-
OK-
Select Data Source (Window)-
Machine Data Source (Tab)-
(Here I didn’t find Primaver P6 SDK only user database was there). Then I clicked ’New...’
ODBC System DSN Warning Window appeared with a message:
’You are logged on with non-administrative privileges. System DSNs could not be created or modified.’-
Please suggest what to do!
- 0AHAthar Hashmi ·dats right Artagnan, i don’t have SDK installed in my computer. for this i have to check my IT department.
But by the way, how can i generate S-curve for cash folw in p6. I want to generate Early / Late / Forecast S-curve in P6. Please help me in this regard. What is the default procedure for that.
Thanx - 0ACAbhishek Chhangani ·Hi arnold, i have been generating s curve by assigning weightages to all wbs & activities & allocating a dummy labor resource to all activities. Then with help of top down estimation getting planned units & s curve. Do u have any other correct method of generating s curve?? Pls send me at abhishekchhangani@yahoo.co.in
Thx - 0ASAmreshwar Shukla ·Dear Artagnan, Thank you so much for sending the files to me.
I am able to connect the access file with the P6 data with SDK,but when I hit Update activities or update resources it gives the error " Action Failed, Error Number 2950, stop all macros" and when I close the dialog box it gives the another box with the message "Properties not found"
what could be the reason?
It looks like that access macro are unable to connect with the excel sheet.
Can any body help me on this issue?
Thanks in advacne.
- 0AHAthar Hashmi ·I want to generate S-curve for the BoQ Cost only. For this i made one resource named ’BOQ’ non labor and assigned to the activity.
I put that activity cost in status tab of activity detail windows in ’non labor cost’ space.
Now when i executing the progress update then the budgeted cost, which i put in ’non labor cost’ space is changed and new cost came which is ’multiplied by 8 x duration’ e.g.
activity cost = 10,000
activity duration = 100d
after updation the activity budgeted cost became
8 x 100 = 800
How to overcome this problem and where should i have to enter the activity’s BOQ cost?
Please... - 0JJJonathan Jamandra ·hi there!
I wish you could send one for me d artagnan.I’d sent you a request two weeks ago but I havn’t receive one.
Would you mind to send me a copy of your S-Curve @ jong_jamandra@yahoo.com ,so I can test it with the projects I currently working on.
As long as I have tested it I will give you my feedback.
Thanks in advence
Engr.Jonathan - 0ACAbhishek Chhangani ·Your file can only be used when SDK is installed. Incase i am using primavera thru citrix server, is there any way to generate s curve from resource loaded schedule. Also, resource loaded means I have used a dummy labor resource for all the activities & thru topdown estimation generated s curve. But this is not the correct method as i keep all activities type as ""task dependent"" & % complete type as "physical". Also, to get quantity liquidation, I have added the scope in the form of material resource hence every time I update, I have to upate quantities as well as physical % complete.
Is there any method to generate reasonably correct s curve while using primavera thru citrix server?? - 0DHDennis Hanks ·Adrianne;
Just installed the Office 2010 beta and would like to test the files again. Excel file macros did not work with Excel 2003. Any feedback for Excel 2010?
The files that I have are dated 19Nov09, have there been any updates?
PS: Nicely done. Works in 2010 beta. Not to look a gift horse in the mouth, but any chance you are working on filters for WBS and/or resources?
This is slick, thanks. - 0DAD Artagnan ·Hi Dennis,
I am not keen with 2010 yet but it’s great to know that my small program works in the new excel version. I have not been able to develop the program as I have been pretty much busy with integrating our project with BIM using Navisworks...also busy looking for a new job.
I will introduce WBS in my next release. However, with regards to resources, I had included it on the other sheet where you filter curves for resources and resource type. Perhaps you can give me an example of data curve that you want.
Cheers! - 0DAD Artagnan ·Mike, Thanks. It’s been such a pleasure exchanging emails with a lot of planning guys here. I’ve received emails more than replies here in the thread, as a matter of fact. Most of them were able to run it, however, some were not, unfortunately. Thanks Mike, again. To Dennis, Please give me a screenshot of a curve and data you want to pull out from P6 database.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?

