{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["KPI and Intervention assessment","ROA Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":72,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"KPI and Intervention assessment","index":0,"n_rows":96,"n_cols":12,"rows_kept":96,"cut":false,"hidden":false,"merged":[[47,9,47,10],[47,3,47,4],[47,5,47,6],[47,7,47,8],[39,11,40,11],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,3,39,4],[52,1,53,11],[68,1,69,11],[84,1,85,11],[55,11,56,11],[71,11,72,11],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[87,11,88,11],[87,7,87,8],[87,9,87,10],[71,3,71,4],[71,5,71,6],[71,7,71,8],[20,1,21,11],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[36,1,37,11],[4,1,5,11],[7,11,8,11],[23,11,24,11],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[7,9,7,10],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[7,3,7,4],[7,5,7,6],[7,7,7,8],[95,3,95,4],[95,5,95,6],[95,7,95,8],[95,9,95,10],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[79,3,79,4],[79,5,79,6],[79,7,79,8],[79,9,79,10],[71,9,71,10],[87,3,87,4],[87,5,87,6]]}
[]
["OPTION 1"]
[]
["Title:","Business as usual / Do nothing"]
["Description:","<Option 1 description>"]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,0,0,0,0,0,0,0,0]
[null,"Interventions","%","KPI 1","KPI 2","KPI 1","KPI 2","KPI 1","KPI 2","KPI 1","KPI 2"]
[null,"<Intervention 1>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C11:C14)","v":0},{"$f":"D9*SUM(D11:D14)/2","v":0},{"$f":"E9*SUM(E11:E14)/2","v":0},0,0,0,0,0,0]
[null,"Benefit Total",null,{"$f":"D15+E15","v":0},null,{"$f":"F15+G15","v":0},null,{"$f":"H15+I15","v":0},null,{"$f":"J15+K15","v":0},null,{"$f":"SUM(D16:K16)","v":0}]
[]
["OPTION 2"]
[]
["Title:","<Option 2 title>"]
["Description:","<Option 2 description>"]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0},{"$f":"Benefit1KPI2Rating","v":0},{"$f":"Benefit2KPI1Rating","v":0},{"$f":"Benefit2KPI2Rating","v":0},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1"},{"$f":"Benefit1KPI2","v":"KPI 2"},{"$f":"Benefit2KPI1","v":"KPI 1"},{"$f":"Benefit2KPI2","v":"KPI 2"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"<Intervention 1>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C27:C30)","v":0},{"$f":"D25*SUM(D27:D30)/2","v":0},{"$f":"E25*SUM(E27:E30)/2","v":0},{"$f":"F25*SUM(F27:F30)/2","v":0},{"$f":"G25*SUM(G27:G30)/2","v":0},{"$f":"H25*SUM(H27:H30)/2","v":0},{"$f":"I25*SUM(I27:I30)/2","v":0},{"$f":"J25*SUM(J27:J30)/2","v":0},{"$f":"K25*SUM(K27:K30)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D31+E31","v":0},null,{"$f":"F31+G31","v":0},null,{"$f":"H31+I31","v":0},null,{"$f":"J31+K31","v":0},null,{"$f":"SUM(D32:K32)","v":0}]
[]
["OPTION 3"]
[]
["Title:","<Option 3 title>"]
["Description:","<Option 3 description>"]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0},{"$f":"Benefit1KPI2Rating","v":0},{"$f":"Benefit2KPI1Rating","v":0},{"$f":"Benefit2KPI2Rating","v":0},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1"},{"$f":"Benefit1KPI2","v":"KPI 2"},{"$f":"Benefit2KPI1","v":"KPI 1"},{"$f":"Benefit2KPI2","v":"KPI 2"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"<Intervention 1>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C43:C46)","v":0},{"$f":"D41*SUM(D43:D46)/2","v":0},{"$f":"E41*SUM(E43:E46)/2","v":0},{"$f":"F41*SUM(F43:F46)/2","v":0},{"$f":"G41*SUM(G43:G46)/2","v":0},{"$f":"H41*SUM(H43:H46)/2","v":0},{"$f":"I41*SUM(I43:I46)/2","v":0},{"$f":"J41*SUM(J43:J46)/2","v":0},{"$f":"K41*SUM(K43:K46)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D47+E47","v":0},null,{"$f":"F47+G47","v":0},null,{"$f":"H47+I47","v":0},null,{"$f":"J47+K47","v":0},null,{"$f":"SUM(D48:K48)","v":0}]
[]
["OPTION 4"]
[]
["Title:","<Option 4 title>"]
["Description:","<Option 4 description>"]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0},{"$f":"Benefit1KPI2Rating","v":0},{"$f":"Benefit2KPI1Rating","v":0},{"$f":"Benefit2KPI2Rating","v":0},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1"},{"$f":"Benefit1KPI2","v":"KPI 2"},{"$f":"Benefit2KPI1","v":"KPI 1"},{"$f":"Benefit2KPI2","v":"KPI 2"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"<Intervention 1>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C59:C62)","v":0},{"$f":"D57*SUM(D59:D62)/2","v":0},{"$f":"E57*SUM(E59:E62)/2","v":0},{"$f":"F57*SUM(F59:F62)/2","v":0},{"$f":"G57*SUM(G59:G62)/2","v":0},{"$f":"H57*SUM(H59:H62)/2","v":0},{"$f":"I57*SUM(I59:I62)/2","v":0},{"$f":"J57*SUM(J59:J62)/2","v":0},{"$f":"K57*SUM(K59:K62)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D63+E63","v":0},null,{"$f":"F63+G63","v":0},null,{"$f":"H63+I63","v":0},null,{"$f":"J63+K63","v":0},null,{"$f":"SUM(D64:K64)","v":0}]
[]
["OPTION 5"]
[]
["Title:","<Option 5 title>"]
["Description:","<Option 5 description>"]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0},{"$f":"Benefit1KPI2Rating","v":0},{"$f":"Benefit2KPI1Rating","v":0},{"$f":"Benefit2KPI2Rating","v":0},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1"},{"$f":"Benefit1KPI2","v":"KPI 2"},{"$f":"Benefit2KPI1","v":"KPI 1"},{"$f":"Benefit2KPI2","v":"KPI 2"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"<Intervention 1>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C75:C78)","v":0},{"$f":"D73*SUM(D75:D78)/2","v":0},{"$f":"E73*SUM(E75:E78)/2","v":0},{"$f":"F73*SUM(F75:F78)/2","v":0},{"$f":"G73*SUM(G75:G78)/2","v":0},{"$f":"H73*SUM(H75:H78)/2","v":0},{"$f":"I73*SUM(I75:I78)/2","v":0},{"$f":"J73*SUM(J75:J78)/2","v":0},{"$f":"K73*SUM(K75:K78)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D79+E79","v":0},null,{"$f":"F79+G79","v":0},null,{"$f":"H79+I79","v":0},null,{"$f":"J79+K79","v":0},null,{"$f":"SUM(D80:K80)","v":0}]
[]
["OPTION 6"]
[]
["Title:","<Option 6 title>"]
["Description:","<Option 6 description>"]
[]
[]
[null,null,null,"Benefit 1",null,"Benefit 2",null,"Benefit 3 ",null,"Benefit 4 ",null,"Weighted \nBenefit Score"]
[null,null,null,{"$f":"Benefit1KPI1Rating","v":0},{"$f":"Benefit1KPI2Rating","v":0},{"$f":"Benefit2KPI1Rating","v":0},{"$f":"Benefit2KPI2Rating","v":0},{"$f":"Benefit3KPI1Rating","v":0},{"$f":"Benefit3KPI2Rating","v":0},{"$f":"Benefit4KPI1Rating","v":0},{"$f":"Benefit4KPI2Rating","v":0}]
[null,"Interventions","%",{"$f":"Benefit1KPI1","v":"KPI 1"},{"$f":"Benefit1KPI2","v":"KPI 2"},{"$f":"Benefit2KPI1","v":"KPI 1"},{"$f":"Benefit2KPI2","v":"KPI 2"},{"$f":"Benefit3KPI1","v":"KPI 1"},{"$f":"Benefit3KPI2","v":"KPI 2"},{"$f":"Benefit4KPI1","v":"KPI 1"},{"$f":"Benefit4KPI2","v":"KPI 2"}]
[null,"<Intervention 1>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 2>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 3>",null,0,0,0,0,0,0,0,0]
[null,"<Intervention 4>",null,0,0,0,0,0,0,0,0]
[null,"KPI Score",{"$f":"SUM(C91:C94)","v":0},{"$f":"D89*SUM(D91:D94)/2","v":0},{"$f":"E89*SUM(E91:E94)/2","v":0},{"$f":"F89*SUM(F91:F94)/2","v":0},{"$f":"G89*SUM(G91:G94)/2","v":0},{"$f":"H89*SUM(H91:H94)/2","v":0},{"$f":"I89*SUM(I91:I94)/2","v":0},{"$f":"J89*SUM(J91:J94)/2","v":0},{"$f":"K89*SUM(K91:K94)/2","v":0}]
[null,"Benefit Total",null,{"$f":"D95+E95","v":0},null,{"$f":"F95+G95","v":0},null,{"$f":"H95+I95","v":0},null,{"$f":"J95+K95","v":0},null,{"$f":"SUM(D96:K96)","v":0}]

{"sheet":"ROA Worksheet","index":1,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":false,"merged":[[4,1,5,7],[56,4,57,9],[35,0,35,3],[47,0,47,3],[50,0,50,3],[52,0,52,3],[56,0,56,2],[8,0,8,3],[9,0,9,3],[10,0,10,3],[12,0,12,3],[11,0,11,3],[23,0,23,3],[24,0,24,3],[23,4,24,4],[13,0,13,3],[21,4,21,9],[21,0,21,3],[22,0,22,3],[26,0,26,1],[27,0,27,1],[59,4,60,9],[59,0,59,2],[72,1,72,9],[73,1,73,9],[39,0,39,3],[49,0,49,3],[51,0,51,3],[48,0,48,3],[41,0,41,9],[29,0,29,1],[81,1,81,9],[45,0,45,3],[67,1,67,6],[64,1,64,9],[65,1,65,9],[66,1,66,9],[80,1,80,9],[76,1,76,9],[78,1,78,9],[79,1,79,9],[70,1,70,9],[53,0,53,3],[62,0,62,9],[69,1,69,9],[63,1,63,9],[25,0,25,3],[75,0,75,9],[74,1,74,9],[42,0,42,3],[15,1,15,9],[17,1,17,9],[18,1,18,9],[23,6,24,6],[23,7,24,7],[23,8,24,8],[23,9,24,9],[23,5,24,5],[34,0,34,3],[32,0,32,3],[71,1,71,9],[68,1,68,7],[77,1,77,9],[2,1,3,7],[36,0,36,3],[40,0,40,3],[44,0,44,3],[30,0,30,1],[37,0,37,9],[38,0,38,3],[8,4,8,9],[43,0,43,3],[33,0,33,3],[14,0,14,9],[31,0,31,9],[28,0,28,1],[16,1,16,9],[19,1,19,9]]}
[]
[null,null,null,null,null,null,null,null,"Department:","<department name>"]
[null,"Investment name (title)",null,null,null,null,null,null,"Investor:","<first name surname>"]
[null,null,null,null,null,null,null,null,"Facilitator:","<first name surname>"]
[null,"Subtitle",null,null,null,null,null,null,"Initial Workshop:","<did/mm/yyyy>"]
[null,null,null,null,null,null,null,null,"Version No.:","<e.g. 0.1, 1.0 etc.>"]
[null,null,null,null,null,null,null,null,"Last Modified by:","<first name surname did/mm/yyyy >"]
[]
[null,null,null,null,"Response options"]
["Interventions",null,null,null,"Option 1","Option 2","Option 3","Option 4","Option 5","Option 6"]
[null,null,null,null,{"$f":"Option1Title","v":"Business as usual / Do nothing"},{"$f":"Option2Title","v":"<Option 2 title>"},{"$f":"Option3Title","v":"<Option 3 title>"},{"$f":"Option4Title","v":"<Option 4 title>"},{"$f":"Option5Title","v":"<Option 5 title>"},{"$f":"Option6Title","v":"<Option 6 title>"}]
["<Interventions>"]
[]
["Total",null,null,null,{"$f":"SUM(E12:E13)","v":0},0,0,0,0,0]
["NOTES"]
[1,"The range of interventions that could respond to the identified problem and deliver the KPIs for the expected benefits are listed in the left-hand column.  "]
[2,"Against the listed interventions a spread of response options are structured to provide genuine alternative approaches to the problem."]
[3,"Response options should be titled to reflect the underlying strategy."]
[4,"The shaded boxes indicate which interventions are used in each response and the percentage (%) indicates the relative importance of each specific intervention within the response.  \nThe total should be 100%."]
[5,"This is a balance of two factors: the importance of the intervention in delivering the response option, and the likely effort/cost involved."]
[]
[null,null,null,null,"Response options"]
["Benefits",null,null,null,"Option 1","Option 2","Option 3","Option 4","Option 5","Option 6"]
[null,null,null,null,{"$f":"E11","v":"Business as usual / Do nothing"},"<Option 2 title>","<Option 3 title>","<Option 4 title>","<Option 5 title>","<Option 6 title>"]
[]
["Percentage of full benefit to be delivered",null,null,null,{"$f":"Option1WeightedBenefit","v":0},{"$f":"Option2WeightedBenefit","v":0},{"$f":"Option3WeightedBenefit","v":0},{"$f":"Option4WeightedBenefit","v":0},{"$f":"Option5WeightedBenefit","v":0},{"$f":"Option6WeightedBenefit","v":0}]
["Benefit 1",null,"<Insert description here>",null,{"$f":"Option1Benefit1","v":0},{"$f":"Option2Benefit1","v":0},{"$f":"Option3Benefit1","v":0},{"$f":"Option4Benefit1","v":0},{"$f":"Option5Benefit1","v":0},{"$f":"Option6Benefit1","v":0}]
["Benefit 2",null,"<Insert description here>",null,{"$f":"Option1Benefit2","v":0},{"$f":"Option2Benefit2","v":0},{"$f":"Option3Benefit2","v":0},{"$f":"Option4Benefit2","v":0},{"$f":"Option5Benefit2","v":0},{"$f":"Option6Benefit2","v":0}]
["Benefit 3",null,"<Insert description here>",null,{"$f":"Option1Benefit3","v":0},{"$f":"Option2Benefit3","v":0},{"$f":"Option3Benefit3","v":0},{"$f":"Option4Benefit3","v":0},{"$f":"Option5Benefit3","v":0},{"$f":"Option6Benefit3","v":0}]
["Benefit 4",null,"<Insert description here>",null,{"$f":"Option1Benefit4","v":0},{"$f":"Option2Benefit4","v":0},{"$f":"Option3Benefit4","v":0},{"$f":"Option4Benefit4","v":0},{"$f":"Option5Benefit4","v":0},{"$f":"Option6Benefit4","v":0}]
[]
["Risk and uncertainty"]
["Risk 1 ",null,null,null,"<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>"]
["Risk 2",null,null,null,"<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>"]
["Risk 3",null,null,null,"<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>"]
["Risk 4",null,null,null,"<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>","<Insert description and rating - H,M,L>"]
[]
["Dis-benefits"]
["Dis-benefit 1",null,null,null,"<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>"]
["Dis-benefit 2",null,null,null,"<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>","<Insert description and criticality - H,M,L>"]
[]
["Interdependencies"]
["Interdependency 1",null,null,null,"<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>"]
["Interdependency 2",null,null,null,"<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>","<Insert description and impact - H,M,L>"]
[]
["Is a real options analysis workshop required? Yes/No/Maybe",null,null,null,"Maybe","<…>","<…>","<…>","<…>","<…>"]
[]
["Cost"]
["Capital total estimated investment (TEI) (range)",null,null,null,"$n mil - $n mil","$n mil - $n mil","$n mil - $n mil","$n mil - $n mil","$n mil - $n mil","$n mil - $n mil"]
["Net incremental output costs (range)",null,null,null,"$n mil - $n mil pa","$n mil - $n mil pa","$n mil - $n mil pa","$n mil - $n mil pa","$n mil - $n mil pa","$n mil - $n mil pa"]
["Time"]
["(Range)",null,null,null,"mm-mm","mm-mm","mm-mm","mm-mm","mm-mm","mm-mm"]
["Ranking"]
["1-6",null,null,null,null,1,2,null,3]
[]
[]
["Overall Assessment:"]
[]
[]
["Recommendation:"]
[]
[]
["Notes:"]
["a","Benefits - % benefit weighting derived from ILM\nThe value the investment will provide to the organisation or its customers. Benefits are the of successfully responding to the identified problem. \nA benefit is supported by one or more key performance indicators (KPIs).  "]
["b","Benefit delivery- rank (0-Marginal, 1-Partial, 2-Full) - See Worksheet 2."]
["c","Dis-benefits - negative impacts that are likely to  occur as a direct consequence of  successfully implementing this option."]
["d","Risk - one to four of the most significant things that might result in the delivery of the benefits being significantly different from expectations. These should include exogenous factors that may influence the investment's benefit delivery."]
["e","Interdependencies - identify external factors that  need to be in place if an intervention is to be successful."]
["f","Real options workshop - determine whether a real options, or managing uncertainty, analysis workshop is required."]
["g","Timeframe - from commencement of funding to date of full benefit delivery (not completion of the investment delivery)"]
["h","Capital TEI- range should be sufficiently reliable to provide an order of magnitude for the response."]
["i","Output costs- output costs  should be identified  as these may substantially differ between responses.  These should be the incremental costs, directly incurred as a result of the investment, net of any expected savings as a result of the investment."]
["j","Ranking - considering all factors, which response option is the preferred approach to resolving the problem?"]
["k","Overall Assessment - why was the preferred response chosen? Are there any other assessment observations?"]
["l","Recommendation - how should this investment proceed…or not?"]
["Instructions for creating Response Options Analysis Report (Word)"]
["a","Complete KPI intervention assess and then select Copy Interventions function under ROA Report."]
["b","Complete risk and uncertainty, dis-benefit, interdependencies, cost, timeframe, ranking and overall assessment and recommendation fields (after relevant workshops)."]
["c","To add additional rows for Risk and uncertainty, Dis-benefits or Interdependencies: Right-click the row heading of the last existing item of the type (Risk and uncertainty, Dis-benefits or Interdependencies) you want to add and select Copy. Then right-click the same row heading and select Insert Copied Cells. Then renumber the new row and edit the descriptions of the relevant  Risk and uncertainty, Dis-benefits or Interdependencies. "]
["d","Save and select Create Report function to generate Word Report of Response Options Analysis."]