Risk and issues log template

Risk and issues log template

Risk and issues log template
Risk and issues log template

issues log template
 issues log template

Risk and issues log template in excel - Free Download

Use this template to track the project's risks and issues. The risk log provides a calculation based on the identified Risk's probability and impact. Probability is a drop down list of: Certain, Expected, Likely, Possible, Unlikely. Impact is a drop down list: Very High, High, Medium, Low and Very Low. - The template also controls issue log items by using the log to update the issue "n" sheet.

Risk and issues log template instructions

General: On the first time to use the template, Update the headers on all worksheets to reflect the PROJECT NAME

Risk Log: List Identified Risks and Calculate Risk Rating with suggested meanings
1-Enter or Update the following:
  • Risk Number
  • Risk description 
  •  Probability (use dropdown list) 
  • Impact (use dropdown list) 
  • Risk Rate color will change based on formula

2-If Sorting is desired Sort all lines using the Header Row by Rating (descending) Number (ascending).

3-For additional risks, Insert new rows, and then copy the Complete "template line" (At least cells A-R) and insert it after the last identified risk.

Issue Log: For Tracking all Issue Items - Log is used to provide information to the specific issue sheet (Issue summary, Responsible Person, Issue Date and Status).

Enter the following on the Issue Log worksheet: 
  • Next sequential issue number 
  • Issue description 
  • Name of person assigned/responsible for the issue
  • Date the issue is being added
  • Status (use the dropdown list)
Issues worksheet: For tracking details of each identified Issue
1-Make a copy of the Issue Template worksheet by right clicking  on its label - choose "Move or Copy". Choose both (move to end) and create a copy. 

2-Rename the copy of the Issue Template worksheet to "Issue "n" where n = the issue number 

3-Link the fields (Issue Description, Name of person Assigned, and Date of Issue) from the Issue Log to the appropriate fields on the Issue worksheet: On the Issue "n" sheet for each field type in "=", then go to the  issue log sheet and click on the field there. Hit "enter" and you will come back to the Issue "n" sheet with the value filled in.

4-Enter the following on the Issue worksheet:
  • Level - High, Medium or Low
  • Class - Impact Area 
  • Originator
  • A brief description of the consequences

5-Update the Resolution with the steps completed to resolve the issue.  At a minimum, this should include the date, action taken, who took the action.  This should reflect a historical sequence of events.

6-Make any changes to Issue Description, Person responsible or status in the issue log and they will be updated in the Issues Worksheet.

Download Free:

Post a Comment

Previous Post Next Post

Comments