Skip to content

S-CURVE generation

D ArtagnanMember for 18 years
Created
175
15
0

I have made an ms access program that links the P6 database to excel. Right now, the excel file can generate s-curve and cash flow.

Anyone who’s interested please send me email at adiasanta@adcc.com.qa






 

175 replies

Oldest first
  1. 0
    Hemanth Kumar ·
    Me too please


    hemanth.vineyard@gmail.com
  2. 0
    D Artagnan ·
    sent to you guys...

  3. 0
    Ciprian Ionescu ·
    Hi,

    I would like to try this program. Can you please send me a copy?

    ciprian_ip@yahoo.com

    Thanks
  4. 0
    Babu Mather ·
    Can I have a copy of the programe ?
    babumather@gmail.com
  5. 0
    Roldan Bartolome ·
    can you send me one at my e-mail add rgbart2@yahoo.com

    thanks,
  6. 0
    Keunsoo Park ·
    Hi,

    I would like to try this S-CURVE generation program.
    Can you please send me a copy?

    kspark2001tw@yahoo.co.kr

    Thanks in advance a lot.
  7. 0
    D Artagnan ·
    already sent. please post your feedback.
  8. 0
    Ernesto Montales ·
    Can you please send me a copy (jojo68502@yahoo.com)

    Thanks.

    Ernesto
  9. 0
    Sachin Sangai ·
    hi Artagnan
    can u resend me a copy i didnt get it,
    Please send it on sachincsangai@gmail.com

    thanks
    Sachin
  10. 0
    Akhtar Khan ·
    can you please send scurve generation to my email, akhtar@taisei.ae . thanks in advance
  11. 0
    D Artagnan ·
    already sent you guys. however, i am expecting some feedback. Thanks.
  12. 0
    Jonathan Jamandra ·
    d’artagnan

    Please send me a copy to my email jong_jamandra@yahoo.com
    Thanks
  13. 0
    Akhtar Khan ·
    Hi,
    Can u please send a copy of S-Curve to me.

    Thanks A lot
    akhtarmkhan@hotmail.com
  14. 0
    Aftab 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

  15. 0
    Athar Hashmi ·
    Dear
    Please send me S-curve program too.
    athar.hashmi@yahoo.com
  16. 0
    Athar Hashmi ·
    Dear
    Please send me S-curve program too.
    athar.hashmi@yahoo.com
  17. 0
    D Artagnan ·
    sent you already... please post your feedbacks.
  18. 0
    Athar 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!

  19. 0
    D Artagnan ·
    This is because no Primavera 6 SDK is installed in your system. If you have the installation CD, run the setup.exe and then modify the installation by adding the SDK. Accept all the defaults. That should work.
  20. 0
    Athar 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
  21. 0
    D Artagnan ·
    i recommend to send your request to our dear friend, Arnold Puy, because he has made a whitepaper about this.
  22. 0
    Athar Hashmi ·
    Thanx Arnold
    Your white paper on curves really amazing. i learned so many things.

    Thanx Artagnan, for your coopertions.

    May Allah bless you here and here after!

  23. 0
    Abhishek 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
  24. 0
    Amreshwar 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.
  25. 0
    Athar 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...
  26. 0
    Athar Hashmi ·
    Hi Dears!
    Any one please let me know where should I enter BoQ Cost to generate Cash Flow?

  27. 0
    Amit Sgssg ·
    Hi,
    would you please send me one to my email: as2@aol.in?

    thanking you
  28. 0
    D Artagnan ·
    sent to you guys...

    I really wish I could get some feedback...:(
  29. 0
    Jonathan 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
  30. 0
    Abdul Khadeer ·
    Dear Artagnan,

    please send me at makssabic.gmail.com. appreciate your help.

    thnaks
    Abdul Khadeer
  31. 0
    Shaun Draper ·
    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 s.draper@globalplanningservices.com.au

    Thanks
    Shaun
  32. 0
    Ronald Romero ·
    Dear Artagnan,

    Kindly send me also at my email ronnieksa@yahoo.com so I can evaluate your program.

    Regards,

    Ronald Romero
  33. 0
    Samra Mushtaq ·
    Please could I have a copy too at samramushtaq@gmail.com
  34. 0
    Abhishek Chhangani ·
    Dear Artagnan

    Please could I get a copy too for S curve at abhishekchhangani@yahoo.co.in
  35. 0
    Abhishek Chhangani ·
    Dear Artagnan

    Please could I get a copy too for S curve at abhishekchhangani@yahoo.co.in
  36. 0
    Noel Deguzman ·
    Hi Artagnan,

    Can u send me a copy too at ndg63@yahoo.com?

    thanks.
  37. 0
    Fuad Dadashov ·
    Hi Artagnan,

    I would like to get a copy of your s-curve as well. send me please on fdadashov@gmail.com



    Thanks in advance
    Fuad
  38. 0
    Abhishek 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??
  39. 0
    D Artagnan ·
    i am sorry mate but i am really clueless about citrix server
  40. 0
    Art Borja ·
    Hi Artagnan,

    Could you send it too through my e-mail please (access and excel file).
    art_dborja@yahoo.com

    Thanks

    Art
  41. 0
    Ahmad Rashidi ·
    Hi Artagnan,

    I have installed the files according as per your instruction but still couldn’t get the s-curve generator to work.

    I have e-mailed you the screenshot on the errors.

  42. 0
    Ahmad Rashidi ·
    Hi Artagnan,

    By the way, the error that I got from Access was;

    Arguments:
    qTaskSpread_lvl1_append, Datasheet, Edit

    Error Number:
    2950
  43. 0
    D Artagnan ·
    have you set your macro security level to medium? are you running xp or vista or win 7?
  44. 0
    Ahmad Rashidi ·
    HI Artagnan,

    I have set the security to medium when we first open both Access and Excel files.

    I’m using Windows XP Pro.
  45. 0
    D Artagnan ·
    shoot me an email tomorrow, i will sort it out. i hope that’s alright.

    cheers!
  46. 0
    Dennis 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.
  47. 0
    D 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!
  48. 0
    Dennis Hanks ·
    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)?
  49. 0
    Mike Testro ·
    Hail to the 4th Musketeer

    This thread has generated more response and debate than any other recently.

    Congratulations to D’Artangan for responding so eloquently and precisely to the multiple responses.

    Well done & best regards

    Mike Testro.
  50. 0
    D 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?