{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Gap prioritizing matrix","Gap Action plan"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":39,"n_cols":1,"rows_kept":39}
{"$rows_empty":7}
["Gap Assessment Template"]
[]
["This gap assessment template created in the steps below uses a scatter plot and gradient shading to highlight the comparative gaps associated with undertaking different projects or activities. "]
["Before constructing the gap assessment template, you will first need to decide upon the nomenclature and scale to express the impact on the organisation and the control that you have on closing the gap. "]
["This template uses a 1 to 100 scale, breaking down the impact on the organisation into 5 discernible levels and the control into six possible ranges as follows:"]
[]
["Impact on the organisations performance"]
[]
["Insignificant - The gap does not impact the organisations' performance nor will it contribute to performance improvement . (Impact level <10.)"]
["Minor - The gap causes some disruption in the organisations performance. (Impact level between 11 and 25.)"]
["Moderate - The gap causes moderate disruptions. (Impact level between 26 and 50.)"]
["Major - The gap causes severe disruptions on the organisations performance  and significant risk of failure to part of the organisation is possible. (Impact level between 51 and 75.)"]
["Critical - This gap leads to significant concerns within the organisation and the gap is classified as critical. (Impact level >75.)"]
[]
["Control over the implementation"]
[]
["No control at all, completely dependent on others to implement- Control level of less than 10%."]
["Little control, others are crucial in the implementation - Control level between 10% and 35%."]
["Somewhat in control, others are needed to implement - Control level between 36% to 50%."]
["More in control, Although others are needed to implement, I have some control over implementation - Control level between 51% to 60%."]
["Mostly in control - Control level between 61% to 90%."]
["Full control,  - Probability above 90%."]
[]
["Important: the classification of the gap is a subjective exercise. It is recommended to conduct the classification with several stakeholders in the organisation to get the best rating of the gaps. "]
[]
["Steps to create the gap prioritization graph"]
["Step 1: List the identified gaps in column A of the 'Gap Prioritizing Matrix'. Use keywords"]
["Step 2: Rate the Impact, using the 5 impact levels"]
["Step 3: Rate the Control, using the 6 control levels"]
[]
["Based on the input the graph will fill itself"]
["The gaps that are placed in the 'red corner' of the graph have the highest priority "]

{"sheet":"Gap prioritizing matrix","index":1,"n_rows":9,"n_cols":3,"rows_kept":9}
["Gap","Impact","Control"]
["Gap 1",90,90]
["Gap 2",50,10]
["Gap 3",10,90]
["Gap 4",20,80]
["Gap 5",10,10]
["Gap 6",100,100]
["Gap 7",75,25]
["Gap 8",25,10]

{"sheet":"Gap Action plan","index":2,"n_rows":9,"n_cols":8,"rows_kept":9}
{"$rows_empty":7}
["Action plan"]
["Gap","Target","Planned Action","Desired Results / Outputs","Target Date","Date Achieved ","Responsible officer","Resources needed"]