none
Logging status values RRS feed

  • Question

  • Would like to log status at certain milestones from each department and store a % value which indicates the current status for each order. Are currently doing it manually in Excel. Is there a way of storing this in Project or is a VBA export to Excel the best way? The orders dissapear from Project when they are delivered to the data is only in the Project file for a limited time, but we want to be able to see it after as well so we can follow it during a longer period. Is this doable in Project at all, or is Excel the only alternative?

    Kind regards //Anders


    • Edited by AT_lamnea Tuesday, September 9, 2014 9:21 AM
    Tuesday, September 9, 2014 9:20 AM

Answers

  • AT_lamnea --

    Without actually being able to see your project, why don't you simply include each of the order-related tasks as milestone tasks in the project?  From your above example, you would include three milestone tasks called:

    • 56400 Parts
    • 56400 Machining
    • 56400 Painting

    Then you could mark those milestone tasks with their appropriate % Complete values as work progresses.  When finished, you would be able to see the historical record.  Hope this helps.


    Dale A. Howard [MVP]

    • Marked as answer by AT_lamnea Tuesday, September 9, 2014 1:58 PM
    Tuesday, September 9, 2014 10:48 AM
    Moderator

All replies

  • AT_lamnea --

    Without actually being able to see your project, why don't you simply include each of the order-related tasks as milestone tasks in the project?  From your above example, you would include three milestone tasks called:

    • 56400 Parts
    • 56400 Machining
    • 56400 Painting

    Then you could mark those milestone tasks with their appropriate % Complete values as work progresses.  When finished, you would be able to see the historical record.  Hope this helps.


    Dale A. Howard [MVP]

    • Marked as answer by AT_lamnea Tuesday, September 9, 2014 1:58 PM
    Tuesday, September 9, 2014 10:48 AM
    Moderator
  • Thanks for your answer Dale,

    Figured out that we must export it to Excel to get what we want.

    Kind regards //Anders

    Tuesday, September 9, 2014 1:58 PM