Documents & Drawings Management Register (DDMR) (Excel XLS)

BENEFITS OF THIS EXCEL DOCUMENT

1. Master Document and Drawing Register is a tracking and monitoring tool for all project deliverables.
2. Master Document Register is used by Planning/Project Control Progress for weekly and monthly progress reports.
3. Document Control Department maintains, logs, and registers the Master Document Register for entire project.

DOCUMENT MANAGEMENT EXCEL DESCRIPTION

This product (Documents & Drawings Management Register [DDMR]) is an Excel template (XLS), which you can download immediately upon purchase.

Documents & Drawings Management Register (DDMR) is a Master List of Documents and Drawing Transactions used by all Client, Design Consultant, Project Management Consultant, Main Contractor from Design till As-Built Stages in all Infrastructure, Engineering, Oil & Gas, Construction, Manufacturing Industries.

It's also called the Master Document List or Master Document Register.

DDMR is used also as a master controlling and monitoring tool as per planned date against actual progress achieved for each deliverable till it reaches to final revision for construction/manufacturing design approval by the client.

MMDR is helpful for:

1. Logging /Registering every Department generated document/drawing with it's number, revision, planned date, the actual date, the reason for tissue, approval status, and decided review cycles for approval.

2. MMDR is used as the real time progress report by the project controls/planning department as a progress monitoring tool.

3. Document/Drawing Approval, Review, Rejection/Delay/Hold from each department and stack holders could be reviewed and remedial action is taken by higher management to improve the progress.

4. Construction and Procurement activities are based on the design approval of the project and only approved for Construction documents will go to the site for further action through MMDR.

The Total Project Team is depending on the MMDR hence Document Controller plays a highly important role in registering every parameter in MMDR with accuracy in excel MMDR or EDMS system. Transmittals prepared along with submittals are logged by Document Controllers.

The weekly status of MMDR is sent to the concerned stack holders for review and action. MMDR is always shared in real time nowadays through EDMS with dashboard too. Each and every revision is monitored closely against Reason for Issue and Approval Status.

MMDR serves as a Master List hence Final Documentation deliverables also issued to the client only after referring its accuracy.

The DDMR includes detailed reason codes for Excel template issuance, such as IFR for review and IFC for construction. It also categorizes approval statuses, including Approved (A) and Revise & Resubmit (C), ensuring precise tracking and management of document workflows.

Source: Best Practices in Document Management Excel: Documents & Drawings Management Register (DDMR) Excel (XLS) Spreadsheet, Prakash Patel (DMS Trainer & Consultant)