This is an Excel Spreadsheet for following up the NCRs of a construction project (and not only).

It covers all the important data that need to be recorded in an NCR like location, activity, owner, closure date, cost, corrective actions and several dates.

The spreadsheet also includes a very simple Dashboard with Pivot Tables that are fully working, which can be sent to the management and basically gives an overview of where the major issues are and if there are any trends. My proposal is always to include a simple visual graphic of the latest major NCR and use that Dashboard as a poster at your project.

The spreadsheet uses some simple pivot tables and it will definitely need to be adjusted to cover your needs and your project.