{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Template","Example","Instructions"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":2,"n_cols":12,"rows_kept":2,"merged":[[0,0,0,11]]}
["Project Name - Issues Reporting Log"]
["ID","Issue Date","Type","Problem Description","Originator","Assigned To","Priority","Start Date","Target Completion Date","Resolution Description","Status","Close Date"]

{"sheet":"Example","index":1,"n_rows":3,"n_cols":12,"rows_kept":3,"merged":[[0,0,0,11]]}
["Project Name - Issues Reporting Log"]
["ID","Issue Date","Type","Problem Description","Originator","Assigned To","Priority","Start Date","Target Completion Date","Resolution Description","Status","Close Date"]
[1,"2011-09-09","Technical","Stockell is unable to meet G+A's need for encoding Content-Type in 270 EDI transaction","UBHC-Patient Accounting","Mike Brown, G+A","High","2011-09-12","2011-09-19","G+A developed, tested and impemented a on-off interface for Stockell to use with their Content-Type encoding","Closed","2011-09-19"]

{"sheet":"Instructions","index":2,"n_rows":56,"n_cols":2,"rows_kept":56}
[]
[null,"Issues can pop up at any time during a project, and must be dealt with quickly, without the benefit of pre-defined solutions.  Typically, project issues involve the project deliverable itself, in the form of unexpected technical problems, incompatibilities or other conflicts.  However, during the course of a project, it is likely that other issues will also arise, relating to project schedules, resources, materials, finances, or other unexpected changes in the project environment."]
[]
[null,"Just because you can’t predict issues, doesn’t mean you shouldn’t be prepared to handle issues once they arrive.  Every project should track, resolve and manage issues."]
[]
[null,"You will need to collect and track the following types of information:"]
[]
[null,"ID: a unique number to track the issue."]
[]
[null,"Issue Date: the date the issue was raised."]
[]
[null,"Type: used to categorize issues for easier assignment and tracking.  Issue types may vary, but should usually include the following:"]
[]
[null,"·         Technical: an issue relating to the technical aspects of the project process or deliverable."]
[]
[null,"·         Financial: an issue relating to project funding, spending or budget."]
[]
[null,"·         Resource: an issue relating to project resources."]
[]
[null,"·         Schedule: an issue relating to the project schedule (timeline)."]
[]
[null,"·         Other: a unique issue specific to the project at hand."]
[]
[null,"Problem Description: to identify the specific nature and impact of the issue (what is the issue about and how does it impact the project in terms of deliverables, schedule, costs, scope or other parameter?)."]
[]
[null,"Originator: who first raised the issue?"]
[]
[null,"Assigned To: who is responsible for issue resolution?"]
[]
[null,"Priority: to ensure that issues are dealt with appropriately considering impact and consequences:"]
[]
[null,"·         High: Issues having a major impact on the project, requiring immediate action."]
[]
[null,"·         Medium: Issues have a moderate impact on the project, requiring attention in the near future."]
[]
[null,"·         Low: Issues having an insignificant impact on the project, requiring attention at some future date if time permits, or not at all."]
[]
[null,"Start Date: to establish a timeframe for problem initiation."]
[]
[null,"Target Completion Date: to establish a timeframe for resolution."]
[]
[null,"Resolution Description: to identify the steps taken to address and resolve the issue."]
[]
[null,"Status: classification to track issue status:"]
[]
[null,"·         Identified: The issue has been identified, resolution has not yet begun."]
[]
[null,"·         Seeking Resolution: Determining how to resolve the issue."]
[]
[null,"·         Solution Proposed: A solution to the issue has been proposed and is pending acceptance or revision."]
[]
[null,"·         Resolved: The issue has been resolved."]
[]
[null,"·         Escalated: The issue has been escalated to the Steering Committee for further action."]
[]
[null,"Close Date: to establish a timeframe for problem closure."]