{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Portfolio Data","Selected Option","League Table","Share of Annual Revenue","Data"],"not_rendered":{"charts":4,"images":3,"macros":1,"external_links":0,"defined_names":160,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"League Table","index":2,"reason":"not_a_worksheet"},{"sheet":"Share of Annual Revenue","index":3,"reason":"not_a_worksheet"}],"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":"Portfolio Data","index":0,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["CRG, RCR & COR Portfolio (Detailed Analysis)"]
["Commercialisation & Revenue Generation (CRG), Rechargeable Costs Recovery (RCR) & Costs Offsetting & Reduction (COR)"]
[]
[null,null,null,null,"Double-Click on an option below to open the Option Analysis."]
["ID","Option Type","Portfolio","Status","Option","Development Cost","Avg. Op. Profit","Payback Period","In Portfolio","Lead Authority","Authority Readiness Level","Sector Readiness Level","Technology Readiness Level","Readiness Total","Political Alignment","Non-Cashable Benefits","Benefits Certainty","Scale of Investment","Competitive Intensity","Market Size","Market Volatility","Realisation Risk","Operational Risk","Realisation Effort","Achievability Total","Total"]
[1010,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Review"},"Bio-Mass Collection & Resale",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":90000},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Limited Cases / Data [1]","Technology Demonstrator [1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":2},"High [2]","High [2]","Medium [3]","Medium [3]","High [4]","Medium [3]","High [4]","Medium [3]","Medium [3]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":8.6666666666666679}]
[1020,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Review"},"Commuted Sum",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Some Cases / Good Results [3]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":3},"Medium [3]","Low [4]","Very High [1]","Very Low [1]","Very Low [1]","Low [4]","Medium [3]","Low [2]","Low [2]","Low [2]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":9},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":12}]
[1030,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Review"},"Asset Sponsorship & Street-Side Advertising",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Barnet"},null,"Many Cases / Mixed Results [3]","Available - Mature [5]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":8},"Low [4]","Very Low [5]","High [2]","Low [2]","Medium [3]","Medium [3]","Low [2]","Low [2]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":15.333333333333332}]
[1040,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Bus Stop & Bus-Side Advertising",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Barnet"},null,"Many Cases / Good Results [4]","Available - Mature [5]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":9},"High [2]","Very Low [5]","High [2]","Low [2]","Medium [3]","Medium [3]","Low [2]","Low [2]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":8},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":17}]
[1050,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Road Maintenance & Winter Services on Private Roads & Commercial Estates",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Suffolk"},null,"Some Cases / Mixed Results [2]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":2},"Low [4]","Low [4]","Medium [3]","Medium [3]","High [4]","Low [4]","Low [2]","Medium [3]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":5.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":7.333333333333333}]
[1060,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"Road Maintenance & Winter Services on Public Sector & Regulated Services Estates",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Suffolk"},null,"Some Cases / Mixed Results [2]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":2},"Medium [3]","Medium [3]","Medium [3]","Medium [3]","Medium [3]","Medium [3]","Low [2]","Medium [3]","Medium [3]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9}]
[1070,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"Using Highways Estates for Energy Generation",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":2400000},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Limited Cases / Data [1]","Available - Mature [5]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":6},"Medium [3]","Low [4]","Very Low [5]","Very High [5]","High [4]","Medium [3]","Medium [3]","High [4]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":4.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":10.666666666666668}]
[1080,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"Commercialising S278 Services",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":108000},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Many Cases / Good Results [4]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","Low [4]","High [2]","Low [2]","Medium [3]","Medium [3]","Very Low [1]","Low [2]","High [4]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.333333333333332}]
[1090,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"5G Mobile Lamp Mast Repeaters / Fixed Wireless Broadband (Concessions)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Proving"},null,"No Case Studies [0]","Available - New (Standardised) [4]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"High [2]","High [2]","Low [4]","Medium [3]","Low [2]","Low [4]","Low [2]","High [4]","Very Low [1]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.666666666666668}]
[1100,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"Street Furniture / Infrastructure as Technology Platform",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Buckinghamshire"},null,"Limited Cases / Data [1]","Pilot Solution [2]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":3},"High [2]","High [2]","Low [4]","Medium [3]","High [4]","Low [4]","Medium [3]","High [4]","Very Low [1]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9.6666666666666679}]
[1110,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Selling Services to Other Authorities",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Many Cases / Mixed Results [3]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":3},"Medium [3]","Low [4]","Medium [3]","Medium [3]","High [4]","Medium [3]","Low [2]","Medium [3]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9}]
[1120,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Recycling of Aggregates",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Somerset"},null,"Some Cases / Good Results [3]","Available - New (Standardised) [4]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":7},"High [2]","Low [4]","Medium [3]","Medium [3]","Low [2]","Low [4]","Low [2]","Medium [3]","Very Low [1]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":14.666666666666668}]
[1130,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Other"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Battery Banks (Cost Offset)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":920000},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Limited Cases / Data [1]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","Low [4]","Low [4]","Very High [5]","Medium [3]","Low [4]","High [4]","High [4]","Medium [3]","Low [2]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":4.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":8.6666666666666679}]
[1140,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Either"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Renewable Powered Fleet (or Low Carbon Powered Fleet)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Milton Keynes"},null,"Some Cases / Good Results [3]","Available - New (Standardised) [4]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":7},"Medium [3]","Medium [3]","Medium [3]","Very High [5]","Low [2]","Low [4]","Medium [3]","High [4]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":5.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":12.333333333333332}]
[1150,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"EVI (Granular)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Barnet"},null,"Many Cases / Good Results [4]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":7},"High [2]","Medium [3]","High [2]","High [4]","High [4]","High [2]","High [4]","High [4]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":13}]
[1160,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"EVI (Concession)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Proving"},null,"No Case Studies [0]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":3},"High [2]","Medium [3]","Low [4]","Low [2]","High [4]","Low [4]","Medium [3]","Medium [3]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9.6666666666666679}]
[1170,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"EVI Change of Use (Planning & Business Rate / Share of Business Rate)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":120000},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},null,{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"None"},null,"Limited Cases / Data [1]","Available - Mature [5]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":6},"High [2]","High [2]","High [2]","Low [2]","Very Low [1]","Medium [3]","Medium [3]","Low [2]","Very Low [1]","Low [2]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":10},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":16}]
[1180,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Transportation"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Demand Responsive Transport Services",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Milton Keynes"},null,"Many Cases / Mixed Results [3]","Pilot Solution [2]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":5},"High [2]","High [2]","Medium [3]","High [4]","Medium [3]","High [2]","Medium [3]","High [4]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.666666666666668}]
[1190,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Transportation"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Classroom Virtualisation (Home To School Transport Cost-Offset)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Limited Cases / Data [1]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Low [4]","Medium [3]","High [2]","Medium [3]","Very Low [1]","High [2]","Very Low [1]","High [4]","High [4]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.333333333333332}]
[1200,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Transportation"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"In-Home / Vulnerable People Virtual Care / Oversight Arrangements",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Limited Cases / Data [1]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","High [2]","Low [4]","Medium [3]","Very Low [1]","High [2]","Very Low [1]","High [4]","High [4]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.333333333333332}]
[1210,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Transportation"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Unknown"},"Driverless Public Transport Services",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Solihull"},null,"Limited Cases / Data [1]","Pilot Solution [2]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":3},"Medium [3]","Medium [3]","High [2]","High [4]","Very Low [1]","Medium [3]","Low [2]","Very High [5]","Very High [5]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9}]
[1220,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Commercialising S139/169 Services (Skips / Scaffold Permits)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"West Sussex"},null,"Many Cases / Good Results [4]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","Very Low [5]","Medium [3]","Low [2]","Very Low [1]","Medium [3]","Very Low [1]","Low [2]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":8.3333333333333339},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":12.333333333333334}]
[1230,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Extending On-Street Parking Fees / Permits",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Oxfordshire"},null,"Many Cases / Mixed Results [3]","Available - Mature [5]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":8},"Very Low [5]","Low [4]","High [2]","Medium [3]","Low [2]","High [2]","Medium [3]","High [4]","Low [2]","Low [2]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":15}]
[1240,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Car Club Permits / Dockless Bikes",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Oxfordshire"},null,"Many Cases / Mixed Results [3]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":6},"Medium [3]","High [2]","Low [4]","Medium [3]","Medium [3]","Medium [3]","Medium [3]","Medium [3]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":12.333333333333332}]
[1250,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Selling Concessions to Traders (Laybys, Car Parks, Park-and-Ride and Estates)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Derbyshire"},null,"Many Cases / Good Results [4]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"High [2]","Low [4]","High [2]","Low [2]","Very Low [1]","Medium [3]","Low [2]","Medium [3]","Very Low [1]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":9},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":13}]
[1260,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"On-Street License (for Cafés and Street Traders)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Oxfordshire"},null,"Many Cases / Good Results [4]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"High [2]","Low [4]","Very High [1]","Low [2]","Very Low [1]","Medium [3]","Low [2]","Medium [3]","Very Low [1]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":9.3333333333333339},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":13.333333333333334}]
[1270,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Downward Devolution (Agency Agreements & DTP Engagement)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Dorset"},null,"Some Cases / Mixed Results [2]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":2},"High [2]","Medium [3]","Medium [3]","Low [2]","Medium [3]","Low [4]","Medium [3]","Medium [3]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9.3333333333333321}]
[1280,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Either"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Crowd-Funded Schemes",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"West Sussex"},null,"Some Cases / Mixed Results [2]","Pilot Solution [2]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","Low [4]","Medium [3]","Low [2]","Medium [3]","High [2]","Medium [3]","Medium [3]","Low [2]","Low [2]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.666666666666668}]
[1290,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Either"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Cancelled"},"Training & Knowledge Sharing (e.g. Road Safety)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Suffolk"},null,"Some Cases / Good Results [3]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":6},"Medium [3]","Low [4]","High [2]","High [4]","High [4]","Medium [3]","Medium [3]","Medium [3]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":6.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":12.333333333333332}]
[1300,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Commercialising S37/38 Services",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Many Cases / Good Results [4]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","Medium [3]","Medium [3]","Low [2]","Low [2]","Medium [3]","Low [2]","Low [2]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.666666666666668}]
[1310,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Commercialising S184 Services",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Lincolnshire"},null,"Many Cases / Good Results [4]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","Medium [3]","High [2]","Medium [3]","Low [2]","Medium [3]","Very Low [1]","Low [2]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":8},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":12}]
[1320,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Suspended"},"Congestion & Pollution Charging Zones",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Barnet"},null,"No Case Studies [0]","Available - New (Standardised) [4]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","High [2]","High [2]","High [4]","Low [2]","High [2]","Low [2]","Very High [5]","Low [2]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.333333333333332}]
[1330,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Suspended"},"Road Charging Schemes",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Barnet"},null,"No Case Studies [0]","Available - New (Standardised) [4]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","High [2]","High [2]","High [4]","Low [2]","High [2]","Low [2]","Very High [5]","Low [2]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11.333333333333332}]
[1340,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Both"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"CCTV Parking / Movement / Weight Restrictions Enforcement",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"None"},null,"Many Cases / Good Results [4]","Available - New (Standardised) [4]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":8},"Low [4]","Low [4]","Medium [3]","Medium [3]","Low [2]","High [2]","Low [2]","Medium [3]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.333333333333333},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":15.333333333333332}]
[1350,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"Devolved Powers from DVLA (e.g. Road Tax Enforcement)",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"None"},null,"Some Cases / Good Results [3]","Available - New (Standardised) [4]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":7},"Medium [3]","High [2]","High [2]","Medium [3]","Very Low [1]","Medium [3]","Medium [3]","Low [2]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":8},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":15}]
[1360,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"Selling Traffic Management Survey Data ",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"None"},null,"Limited Cases / Data [1]","Available - New (No Standard) [3]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"Medium [3]","Low [4]","Low [4]","Medium [3]","High [4]","Medium [3]","High [4]","High [4]","Low [2]","Low [2]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":5.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9.6666666666666679}]
[1370,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"RCR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Green / Insurance Claims",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"None"},null,"Many Cases / Good Results [4]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":4},"High [2]","Low [4]","High [2]","High [4]","Low [2]","High [2]","Low [2]","Very High [5]","Low [2]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":11}]
[1380,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"CRG"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Highways"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Active"},"Quarry / Timber Extraction Charging",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"Northumberland"},null,"Limited Cases / Data [1]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":1},"Low [4]","Low [4]","High [2]","Medium [3]","Low [2]","High [2]","Low [2]","Medium [3]","Low [2]","Medium [3]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7.666666666666667},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":8.6666666666666679}]
[1390,{"$f":"GetData(Data[[#This Row],[ID]],\"Type\",\"Text\")","v":"COR"},{"$f":"GetData(Data[[#This Row],[ID]],\"Portfolio\",\"Text\")","v":"Either"},{"$f":"GetData(Data[[#This Row],[ID]],\"Status\",\"Text\")","v":"Planned"},"Shared Services",{"$f":"GetData(Data[[#This Row],[ID]],\"Development_Cost\",\"\")","v":0},{"$f":"GetData(Data[[#This Row],[ID]],\"Average_Annual_Operating_Profit\",\"\")","v":0},{"$f":"IF(GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\")<=0,0,GetData(Data[[#This Row],[ID]],\"Payback_Period\",\"\"))","v":0},"Yes",{"$f":"GetData(Data[[#This Row],[ID]],\"Lead_Authority\",\"\")","v":"None"},null,"Some Cases / Mixed Results [2]","Not Applicable [-1]",{"$f":"GetListScore(Data[[#This Row],[Authority Readiness Level]])+GetListScore(Data[[#This Row],[Sector Readiness Level]])+IF(GetListScore(Data[[#This Row],[Technology Readiness Level]])=-1,0,GetListScore(Data[[#This Row],[Technology Readiness Level]]))","v":2},"Low [4]","Medium [3]","Medium [3]","Medium [3]","Very Low [1]","Medium [3]","Medium [3]","Low [2]","Medium [3]","High [4]",{"$f":"ROUNDDOWN(50-(GetListScore(Data[[#This Row],[Political Alignment]])+GetListScore(Data[[#This Row],[Non-Cashable Benefits]])+GetListScore(Data[[#This Row],[Benefits Certainty]])+GetListScore(Data[[#This Row],[Scale of Investment]])+GetListScore(Data[[#This Row],[Competitive Intensity]])+GetListScore(Data[[#This Row],[Market Size]])+GetListScore(Data[[#This Row],[Market Volatility]])+GetListScore(Data[[#This Row],[Realisation Risk]])+GetListScore(Data[[#This Row],[Operational Risk]])+GetListScore(Data[[#This Row],[Realisation Effort]])),0)/3","v":7},{"$f":"Data[[#This Row],[Readiness Total]]+Data[[#This Row],[Achievability Total]]","v":9}]
["Double-Click here to insert a new row"]
["Double-Click the [ID] on a row to delete the option."]
[]
[null,null,null,null,null,"Total Annual Portfolio Value",{"$f":"SUBTOTAL(109,Data[Avg. Op. Profit])","v":198000}]
[null,null,null,null,null,"Total Development Cost",{"$f":"SUBTOTAL(109,Data[Development Cost])","v":3440000}]
[null,null,null,null,null,"Number of Portfolio Initiatives",{"$f":"SUBTOTAL(103,Data[Option])","v":39}]
[null,null,null,null,null,"Average Break Even",{"$f":"SUBTOTAL(101,Data[Payback Period])","v":0}]

{"sheet":"Selected Option","index":1,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":true,"merged":[[13,14,13,21],[14,14,14,21],[14,1,14,6],[10,14,10,21],[10,1,10,6],[11,14,11,21],[11,1,11,6],[12,14,12,21],[43,1,43,21],[44,1,44,21],[45,1,45,21],[15,14,15,21],[16,14,16,21],[17,14,17,21],[17,1,17,6],[18,14,18,21],[38,1,38,21],[39,1,39,21],[40,1,40,21],[23,1,23,6],[28,1,30,21],[33,1,33,21],[34,1,34,21],[35,1,35,21],[5,4,5,12],[5,14,5,15],[5,16,5,18],[5,20,5,21],[7,1,7,6],[7,14,7,15],[7,16,7,18],[7,20,7,21],[19,14,19,21],[20,1,20,6],[20,14,20,21],[21,1,21,6],[21,14,21,21]]}
[]
[]
[]
[]
[]
[null,"ID",1390,"Name","Shared Services",null,null,null,null,null,null,null,null,null,"Lead Authority",null,"None",null,null,"Status","Planned"]
[]
[null,"Cost of Option Development",null,null,null,null,null,null,null,null,null,null,null,null,"Portfolio",null,"Either",null,null,"Type","COR"]
[]
[null,null,null,null,null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5",null,"In-Line Comments"]
[null,"Anticipated Transactions Per Annum"]
[null,"Average Revenue Per Transaction"]
[null,null,null,null,null,null,"Other Cashable Benefits / Cost Savings / Efficiency Gains"]
[null,null,null,null,null,null,"Total Annual Revenue",null,{"$f":"(I13+(I11*I12))","v":0},{"$f":"(J13+(J11*J12))","v":0},{"$f":"(K13+(K11*K12))","v":0},{"$f":"(L13+(L11*L12))","v":0},{"$f":"(M13+(M11*M12))","v":0}]
[null,"Confidence In Revenue Projections (%)"]
[null,null,null,null,null,null,"Confidence-Adjusted Total Annual Revenue",null,{"$f":"I15*I14","v":0},{"$f":"J15*J14","v":0},{"$f":"K15*K14","v":0},{"$f":"L15*L14","v":0},{"$f":"M15*M14","v":0}]
[null,null,null,null,null,null,"Annual Cost of Service / Operations"]
[null,"Partner(s) Revenue Sharing / License Payments (%)"]
[null,null,null,null,null,null,"Gross Operating Profit After All Fees",null,{"$f":"I16-(I17+I18)","v":0},{"$f":"J16-(J17+J18)","v":0},{"$f":"K16-(K17+K18)","v":0},{"$f":"L16-(L17+L18)","v":0},{"$f":"M16-(M17+M18)","v":0}]
[null,null,null,null,null,null,"Annual Cost of Overheads"]
[null,"Net Operating Profit",null,null,null,null,null,null,{"$f":"I19-I20","v":0},{"$f":"J19-J20","v":0},{"$f":"K19-K20","v":0},{"$f":"L19-L20","v":0},{"$f":"M19-M20","v":0}]
[null,"Cumulative Operating Profit",null,null,null,null,null,null,{"$f":"I21","v":0},{"$f":"+Cumulative_Operating_Profit_Year_1+Net_Operating_Profit_Year_2","v":0},{"$f":"+Cumulative_Operating_Profit_Year_2+Net_Operating_Profit_Year_3","v":0},{"$f":"+Cumulative_Operating_Profit_Year_3+Net_Operating_Profit_Year_4","v":0},{"$f":"+Cumulative_Operating_Profit_Year_4+Net_Operating_Profit_Year_5","v":0}]
[]
[null,"Average Annual Operating Profit",null,null,null,null,null,null,{"$f":"AVERAGE(I21:M21)","v":0}]
[]
[null,null,null,null,null,null,"Payback Period (Years)",null,{"$f":"CalculatePayback(I24,I8)","v":-1}]
[]
[null,"Comments"]
[]
[]
[]
[]
[null,"Critical Enablers"]
[]
[]
[]
[]
[null,"Barriers to Implementation"]
[]
[]
[]
[]
[null,"Key Operational Risks"]

{"sheet":"Data","index":4,"n_rows":42,"n_cols":66,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
["Option_ID","Option_Title","Lead_Authority","Status","Type","Portfolio","Development_Cost","Annual_Cost_Year_1","Annual_Cost_Year_2","Annual_Cost_Year_3","Annual_Cost_Year_4","Annual_Cost_Year_5","Transactions_Year_1","Transactions_Year_2","Transactions_Year_3","Transactions_Year_4","Transactions_Year_5","Average_Annual_Operating_Profit","Payback_Period","Revenue_Per_Transaction_Year_1","Revenue_Per_Transaction_Year_2","Revenue_Per_Transaction_Year_3","Revenue_Per_Transaction_Year_4","Revenue_Per_Transaction_Year_5","Other_Benefits_Year_1","Other_Benefits_Year_2","Other_Benefits_Year_3","Other_Benefits_Year_4","Other_Benefits_Year_5","Revenue_Confidence_Year_1","Revenue_Confidence_Year_2","Revenue_Confidence_Year_3","Revenue_Confidence_Year_4","Revenue_Confidence_Year_5","License_Payment_1","License_Payment_2","License_Payment_3","License_Payment_4","License_Payment_5","Annual_Overheads_1","Annual_Overheads_2","Annual_Overheads_3","Annual_Overheads_4","Annual_Overheads_5","In_Line_Comment_1","In_Line_Comment_2","In_Line_Comment_3","In_Line_Comment_4","In_Line_Comment_5","In_Line_Comment_6","In_Line_Comment_7","In_Line_Comment_8","In_Line_Comment_9","In_Line_Comment_10","In_Line_Comment_11","In_Line_Comment_12","Comment","Critical_Enabler_1","Critical_Enabler_2","Critical_Enabler_3","Barrier_1","Barrier_2","Barrier_3","Risk_1","Risk_2","Risk_3"]
[1010,"Bio-Mass Collection & Resale","Lincolnshire","Review","CRG","Highways",0,0,0,0,0,0,0,0,0,0,0,90000,-1,0,0,0,0,0,150000,150000,150000,150000,150000,0.8,0.7,0.6,0.5,0.4]
[1020,"Commuted Sum","Lincolnshire","Review","RCR","Highways",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,482000,482000,482000,482000,482000,0.8,0.7,0.6,0.5,0.4]
[1030,"Asset Sponsorship & Street-Side Advertising","Barnet","Review","CRG","Highways",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,800000,800000,800000,800000,800000,0.8,0.7,0.6,0.5,0.4]
[1040,"Bus Stop & Bus-Side Advertising","Barnet","Active","CRG","Highways",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,300000,300000,300000,300000,300000,0.8,0.7,0.6,0.5,0.4]
[1050,"Road Maintenance & Winter Services on Private Roads & Commercial Estates","Suffolk","Active","CRG","Highways",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,150000,150000,150000,150000,150000,0.8,0.7,0.6,0.5,0.4]
[1060,"Road Maintenance & Winter Services on Public Sector & Regulated Services Estates","Suffolk","Planned","CRG","Highways",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,200000,200000,200000,200000,200000,0.8,0.7,0.6,0.5,0.4]
[1070,"Using Highways Estates for Energy Generation","Lincolnshire","Planned","CRG","Highways",2400000,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,200000,200000,200000,200000,200000,0.8,0.7,0.6,0.5,0.4]
[1080,"Commercialising S278 Services","Lincolnshire","Planned","RCR","Highways",0,0,0,0,0,0,0,0,0,0,0,108000,-1,0,0,0,0,0,180000,180000,180000,180000,180000,0.8,0.7,0.6,0.5,0.4]
[1090,"5G Mobile Lamp Mast Repeaters / Fixed Wireless Broadband (Concessions)","Proving","Planned","CRG","Highways",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,1500000,1500000,1500000,1500000,1500000,0.8,0.7,0.6,0.5,0.4]
[1100,"Street Furniture / Infrastructure as Technology Platform","Buckinghamshire","Planned","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,100000,100000,100000,100000,100000,0.8,0.7,0.6,0.5,0.4]
[1110,"Selling Services to Other Authorities","Lincolnshire","Active","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,700000,700000,700000,700000,700000,0.8,0.7,0.6,0.5,0.4]
[1120,"Recycling of Aggregates","Somerset","Active","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,120000,120000,120000,120000,120000,0.8,0.7,0.6,0.5,0.4]
[1130,"Battery Banks (Cost Offset)","Lincolnshire","Active","COR","Other",920000,2000,2000,2000,2000,2000,0,0,0,0,0,null,null,0,0,0,0,0,45000,45000,45000,45000,45000,0.8,0.7,0.6,0.5,0.4]
[1140,"Renewable Powered Fleet (or Low Carbon Powered Fleet)","Milton Keynes","Active","COR","Either",null,0,0,0,0,0,25,25,25,25,0,null,null,0,0,0,0,0,17000,34000,51000,68000,68000,0.8,0.7,0.6,0.5,0.4]
[1150,"EVI (Granular)","Barnet","Planned","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,900000,900000,900000,900000,900000,0.8,0.7,0.6,0.5,0.4]
[1160,"EVI (Concession)","Proving","Planned","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,5400000,null,null,null,null,0.8,0.7,0.6,0.5,0.4]
[1170,"EVI Change of Use (Planning & Business Rate / Share of Business Rate)","None","Planned","CRG","Highways",120000,null,null,null,null,null,null,null,null,null,null,0,-1]
[1180,"Demand Responsive Transport Services","Milton Keynes","Active","COR","Transportation",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,410000,410000,410000,410000,410000,0.8,0.7,0.6,0.5,0.4]
[1190,"Classroom Virtualisation (Home To School Transport Cost-Offset)","Lincolnshire","Active","COR","Transportation",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,2500000,2500000,2500000,2500000,2500000,0.8,0.7,0.6,0.5,0.4]
[1200,"In-Home / Vulnerable People Virtual Care / Oversight Arrangements","Lincolnshire","Active","COR","Transportation",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,2500000,2500000,2500000,2500000,2500000,0.8,0.7,0.6,0.5,0.4]
[1210,"Driverless Public Transport Services","Solihull","Unknown","COR","Transportation",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0.8,0.7,0.6,0.5,0.4]
[1220,"Commercialising S139/169 Services (Skips / Scaffold Permits)","West Sussex","Active","RCR","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,60000,60000,60000,60000,60000,0.8,0.7,0.6,0.5,0.4]
[1230,"Extending On-Street Parking Fees / Permits","Oxfordshire","Active","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,4000000,4000000,4000000,4000000,4000000,0.8,0.7,0.6,0.5,0.4]
[1240,"Car Club Permits / Dockless Bikes","Oxfordshire","Active","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,100000,100000,100000,100000,100000,0.8,0.7,0.6,0.5,0.4]
[1250,"Selling Concessions to Traders (Laybys, Car Parks, Park-and-Ride and Estates)","Derbyshire","Active","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,100000,100000,100000,100000,100000,0.8,0.7,0.6,0.5,0.4]
[1260,"On-Street License (for Cafés and Street Traders)","Oxfordshire","Active","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,200000,200000,200000,200000,200000,0.8,0.7,0.6,0.5,0.4]
[1270,"Downward Devolution (Agency Agreements & DTP Engagement)","Dorset","Active","COR","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,105000,105000,105000,105000,105000,0.8,0.7,0.6,0.5,0.4]
[1280,"Crowd-Funded Schemes","West Sussex","Active","COR","Either",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,175000,175000,175000,175000,175000,0.8,0.7,0.6,0.5,0.4]
[1290,"Training & Knowledge Sharing (e.g. Road Safety)","Suffolk","Cancelled","CRG","Either",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,50000,50000,50000,50000,50000,0.8,0.7,0.6,0.5,0.4]
[1300,"Commercialising S37/38 Services","Lincolnshire","Active","RCR","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,800000,800000,800000,800000,800000,0.8,0.7,0.6,0.5,0.4]
[1310,"Commercialising S184 Services","Lincolnshire","Active","RCR","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,90000,90000,90000,90000,90000,0.8,0.7,0.6,0.5,0.4]
[1320,"Congestion & Pollution Charging Zones","Barnet","Suspended","CRG","Highways",null,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0.8,0.7,0.6,0.5,0.4]
[1330,"Road Charging Schemes","Barnet","Suspended","CRG","Highways",null,5000,0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,0.8,0.7,0.6,0.5,0.4,0,0,0,0,0,null,null,null,null,null,"What are the headline costs (if the transactional costs are unknown)?",null,null,null,"These are the initial, indication revenue figures.",null,null,null,null,null,null,null,"This option requires primary legislation."]
[1330,"Test","a","Unknown","CRG","Other",0,3000,3000,3000,3000,3000,1,1,1,1,1,29999.95,-1,50000,50000,50000,50000,50000,5000,5000,5000,5000,5000,0.8,0.7,0.6,0.5,0.4,0.05,0.05,0.05,0.05,0.05,null,null,null,null,null,"B","b","b","b","b","b","b","b","b","b","b","b","test","test ce1","test ce2","test ce3","b1","b2","b3","r1","r2","r3"]
[1350,"Devolved Powers from DVLA (e.g. Road Tax Enforcement)","None","Planned","RCR","Highways",null,null,null,null,null,null,null,null,null,null,null,0,-1]
[1340,"CCTV Parking / Movement / Weight Restrictions Enforcement","None","Active","RCR","Both",null,null,null,null,null,null,null,null,null,null,null,0,-1]
[1360,"Selling Traffic Management Survey Data ","None","Planned","CRG","Highways",null,null,null,null,null,null,null,null,null,null,null,0,-1]
[1370,"Green / Insurance Claims","None","Active","RCR","Highways",null,null,null,null,null,null,null,null,null,null,null,0,-1]
[1380,"Quarry / Timber Extraction Charging","Northumberland","Active","CRG","Highways",null,null,null,null,null,null,null,null,null,null,null,0,-1]
[1390,"Shared Services","None","Planned","COR","Either",null,null,null,null,null,null,null,null,null,null,null,0,-1]