Document Tracking & Management
In the Open Standard
Matt GauntMember for 19 years
- Created
- 3
- 2
0
I am needing a solution to the problem below during a month when the planning software we use (MSP 2003) is phased out and Primavera P6 is introduced.
I am trying to create a spreadsheet using EXCEL that allows me to track a large number of design documents that my team are producing.
I have managed to work out some of the basics that:
- calculate review due dates by the client (21 days after the document has been issued to the client)
- calculate days over due for issue and review/approval by the client
I was rather hoping i could attach the example file on this post but i cant seem to find any options that allow this.
I would be grateful if anybody is a bit of a whizz with EXCEL and i could email the file.
Regards
MG
I am trying to create a spreadsheet using EXCEL that allows me to track a large number of design documents that my team are producing.
I have managed to work out some of the basics that:
- calculate review due dates by the client (21 days after the document has been issued to the client)
- calculate days over due for issue and review/approval by the client
I was rather hoping i could attach the example file on this post but i cant seem to find any options that allow this.
I would be grateful if anybody is a bit of a whizz with EXCEL and i could email the file.
Regards
MG
3 replies
Oldest first- 0Mike Testro ·Hi Matt
I am not an excell user - I prefer Lotus 123 - but it seems that you have a relatively simple set of data that needs a "what if" formula to check if a particular date is later than one which is specified.
Even excell can do this.
Have a look at the =if(etc) probabilities.
Best regards
Mike Testro. - 0Kumaraganesan K ·Hai
I am using Excel for Engineering Document Tracking. Please use Conditional formatting on the cell where the plan date for each document is mentioned. When you update the cell for Status date, the plan date should appear as "RED" or preferable color. It is easy to track the overdue dates.
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?