Could you please share with me your program, I am interested too, as also trying to find alterative ways preparig S curves in simple ways. please send me at [email protected]
I am still waiting for your program for evaluation. I am also currently making a SCurve and have problems generating the late finish curves properly since the float and the links are not yet finalize. Maybe your program can be a great help in simplying things. My email is [email protected] and is currently working for a project in UAE.
Further to my previous post, I tried Access and Excel files in another computer but still no luck..!!!
I am able to load P6 data in Access file but when I run "update activitie" macro gives the error no -2950 and give message "ODBC -- connection to "l" failed". So data in the excel file is not being updated!! What could be the reason??
I am using P6.1 and Office Enterprise 2007 on XP-SP3.
Thanks. Its been such a pleasure exchanging emails with a lot of planning guys here. Ive 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.
I am not keen with 2010 yet but its 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.
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?
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??
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 activitys BOQ cost?
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.
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 [email protected]
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
Sir,
Could you please send me this Programme, here is my email add [email protected]
Thanks
JOJit
hi sirs
Can i also get it?
[email protected]
Best Regards
Could you please share with me your program, I am interested too, as also trying to find alterative ways preparig S curves in simple ways. please send me at [email protected]
Many thanks,
Leody Cabral
Dear Artagan,
How to generate S-curve in P6
Dear Artagan,
How to generate S-curve in P6
Hi All
The feeding frenzy has gone too far.
Best regards
Mike Testro.
Please send it to xxxx
Hi D. Artagnan
It may be too late. How ever Can I get copy of your program which generate S curve from P6 data base.
xxx
Thanks
You need to assign resource to generate curve.
Yes just a copy paste technique.
So its copy pasting...
I didnt know that...
Thanks.
sTEPS:
1- Open a PROJECT
2- cLICK ACTIVITY RESOURCE SPREADSHEETS MENU.
3- cOSTUMISE DATA YOU WANT TO PRPARE BY MODIFYING THE SPREADSHEET FIELD.
4- cOPY TO EXCEL.
5- GENERATE GRAPH.
hi marie,
kabayan din, hehe,could you please send me some instruction on how to generate scurve on excel linked with the database on p6??
thanks and bestregards,
pat
dear artagnan,
you didn’t reply me about the copy ....can u send it at
xxx
regards,
sherif
Hi Marie,
Kabayan, kumusta?
Can you please tell us how to easily do it in P6? Would you mind to share how you do it in P6?
Why you need to do this in MS access. P6 can do all this things... its double work....just make it simple.
Hi D,
I have sent email to your email address. Please check. Appreciate very much if you could reply. [email protected]
Regards,
Duy
dear artgnan,
can i take a copy in my email
[email protected]
best regards...sherif saied
Dear D,
I am still waiting for your program for evaluation. I am also currently making a SCurve and have problems generating the late finish curves properly since the float and the links are not yet finalize. Maybe your program can be a great help in simplying things. My email is [email protected] and is currently working for a project in UAE.
Regards,
Ronnie
please send to my email the screenshot...
Can you send me a copy at please use mr suaves private message system to make contact.
thanks.............
Dear Artagnan,
Further to my previous post, I tried Access and Excel files in another computer but still no luck..!!!
I am able to load P6 data in Access file but when I run "update activitie" macro gives the error no -2950 and give message "ODBC -- connection to "l" failed". So data in the excel file is not being updated!! What could be the reason??
I am using P6.1 and Office Enterprise 2007 on XP-SP3.
Thanks in advance.
Regards,
Hey "D"
Thanks for a great file
Reporting became easier now
Mike,
Thanks. Its been such a pleasure exchanging emails with a lot of planning guys here. Ive 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.
Hail to the 4th Musketeer
This thread has generated more response and debate than any other recently.
Congratulations to DArtangan for responding so eloquently and precisely to the multiple responses.
Well done & best regards
Mike Testro.
Adrianne;
Missed the resource filter. Will look for it. If I cannot find it, I will send you a screen shot. Am I using the latest version (Nov 19)?
Hi Dennis,
I am not keen with 2010 yet but its 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!
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.
shoot me an email tomorrow, i will sort it out. i hope thats alright.
cheers!
HI Artagnan,
I have set the security to medium when we first open both Access and Excel files.
Im using Windows XP Pro.
have you set your macro security level to medium? are you running xp or vista or win 7?
Hi Artagnan,
By the way, the error that I got from Access was;
Arguments:
qTaskSpread_lvl1_append, Datasheet, Edit
Error Number:
2950
Hi Artagnan,
I have installed the files according as per your instruction but still couldnt get the s-curve generator to work.
I have e-mailed you the screenshot on the errors.
Hi Artagnan,
Could you send it too through my e-mail please (access and excel file).
[email protected]
Thanks
Art
i am sorry mate but i am really clueless about citrix server
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??
Hi Artagnan,
I would like to get a copy of your s-curve as well. send me please on [email protected]
Thanks in advance
Fuad
Hi Artagnan,
Can u send me a copy too at [email protected]?
thanks.
Dear Artagnan
Please could I get a copy too for S curve at [email protected]
Dear Artagnan
Please could I get a copy too for S curve at [email protected]
Please could I have a copy too at [email protected]
Dear Artagnan,
Kindly send me also at my email [email protected] so I can evaluate your program.
Regards,
Ronald Romero
Hi
I asked a couple of weeks ago if you could send thru the s curve, I would very much appreciate if you could send it thru to [email protected]
Thanks
Shaun
Dear Artagnan,
please send me at makssabic.gmail.com. appreciate your help.
thnaks
Abdul Khadeer
hi there!
I wish you could send one for me d artagnan.Id sent you a request two weeks ago but I havnt receive one.
Would you mind to send me a copy of your S-Curve @ [email protected] ,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
sent to you guys...
I really wish I could get some feedback...:(
Hi,
would you please send me one to my email: [email protected]?
thanking you
Hi Dears!
Any one please let me know where should I enter BoQ Cost to generate Cash Flow?
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 activitys BOQ cost?
Please...
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.
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 [email protected]
Thx
Pagination