{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Community Engagement","Adjacent Minor Works","Snow & Flood Wardens","Highways Wardens","Footway Winter Gritting","Footway Maintenance","Other"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"comments":1,"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":"Community Engagement","index":0,"n_rows":50,"n_cols":32,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Future Highways Research Club"]
[null,"Parishes & Town Councils"]
[null,"P&TC #1","P&TC #2","P&TC #3","P&TC #4","P&TC #5","P&TC #6","P&TC #7","P&TC #8","P&TC #9","P&TC #10","P&TC #11","P&TC #12","P&TC #13","P&TC #14","P&TC #15","P&TC #16","P&TC #17","P&TC #18","P&TC #19","P&TC #20","P&TC #21","P&TC #22","P&TC #23","P&TC #24","P&TC #25","P&TC #26","P&TC #27","P&TC #28",null,"Totals"]
["In Portfolio","Yes","No","Yes","No","Yes","Planned","Yes","?","Yes","No","?","Yes","?","No","No","Yes","?","?","Yes","Yes","?","?","Yes","No","No","No","?","?",null,{"$f":"COUNTIF(B4:AC4,\"Yes\")","v":10}]
["Characteristics"]
["P&TC Population Size",4865,1626,8484,756,6708,11853,11705,4870,5547,1667,2670,9505,6954,677,753,9548,11729,4632,6412,3901,4213,11776,1214,4111,1739,3847,9784,11415,null,{"$f":"SUM(B6:AC6)","v":162961}]
["P&TC Highways Budget",5000,0,3000,0,0,6000,16000,0,3000,0,2000,0,0,0,0,14000,0,0,6000,8000,0,0,6000,0,0,0,5000,5000,null,{"$f":"SUM(B7:AC7)","v":79000}]
["Engagement Readiness & Budget Allocation"]
["Baseline Service Statement","Yes",null,"Planned",null,"Yes","Yes","Yes",null,"Yes",null,null,"Yes",null,null,null,"Yes",null,null,"Yes","Yes",null,null,"Yes",null,null,null,"Yes"]
["Highways Activities Guidance for P&TCs","Planned",null,"Yes",null,"Planned",null,"Yes",null,"Yes",null,null,"Planned",null,null,null,"Yes",null,null,"Yes",null,null,null,"?",null,null,null,"Yes"]
["Support Services for Volunteers","Yes",null,"Yes",null,"Planned",null,"Planned",null,"Planned",null,null,"Yes",null,null,null,"Yes",null,null,"Planned","Yes",null,null,"?",null,null,null,"Planned"]
["Agency Agreement for P&TC-Funded Works","Yes",null,"Yes",null,"Planned",null,"Yes",null,"Planned",null,null,"Planned",null,null,null,"Planned",null,null,"?"]
["Menu Pricing for Authority-Delivered Services","Yes",null,null,null,"Yes",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,"Planned"]
["P&TC Liaison Framework","Yes",null,"Planned",null,"Yes","Yes",null,null,"Yes",null,null,null,null,null,null,"Yes",null,null,"Yes","Yes",null,null,"Planned",null,null,null,"Yes"]
["Agreed Budget Allocation",2500,0,3000,0,0,2000,16000,0,2000,0,0,0,0,0,0,3000,0,0,5000,2000,0,0,5000,0,0,0,5000,null,null,{"$f":"SUM(B15:AC15)","v":45500}]
["P&TC / Authority Managed Community Engagement Schemes"]
["Managed By","Authority",null,"P/TC",null,"Authority","P/TC","P/TC",null,"Authority",null,null,"P/TC",null,null,null,"P/TC",null,null,"Authority","Authority",null,null,"Authority",null,null,null,"Authority",null,null,{"$f":"COUNTIF(B17:AC17,\"Authority\")","v":7},"Authority managed."]
["Adjacent Minor Works (Sign Cleaning, Grass & Hedge Cutting)","Yes",null,"Yes",null,"Yes","?","?",null,"Yes",null,null,"Yes",null,null,null,"Yes",null,null,"Yes","?",null,null,"?",null,null,null,"?","?",null,{"$f":"COUNTIF(B18:AC18,\"Yes\")","v":7}]
["Cost to Authority",{"$f":"IF(OR(B18=\"Yes\",  B18=\"Planned\"),Adjacent_Minor_Works_Cost,0)","v":5660},0,5660,0,5660,0,0,0,5660,0,0,5660,0,0,0,5660,0,0,5660,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B19:AC19)","v":39620}]
["Cashable Benefit to Authority",{"$f":"IF(OR(B18=\"Yes\",  B18=\"Planned\"),Adjacent_Minor_Works_Benefit,0)","v":7900},0,7900,0,7900,0,0,0,7900,0,0,7900,0,0,0,7900,0,0,7900,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B20:AC20)","v":55300}]
["Non-Cashable Benefit to Authority",{"$f":"IF(OR(B18=\"Yes\",  B18=\"Planned\"),Adjacent_Minor_Works_Other,0)","v":0.85},0,0.85,0,0.85,0,0,0,0.85,0,0,0.85,0,0,0,0.85,0,0,0.85,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM(B21:AC21)>0,AVERAGEIF(B21:AC21,\">0\"),0)","v":0.84999999999999987}]
["Total",{"$f":"B20-B19","v":2240},{"$f":"C20-C19","v":0},2240,0,2240,0,0,0,2240,0,0,2240,0,0,0,2240,0,0,2240,0,0,0,0,0,0,0,0,0]
["Snow & Flood Wardens (Emergency Support)","?",null,"Yes",null,"Yes","Yes","Yes",null,"?",null,null,"Yes",null,null,null,"Yes",null,null,"Yes","?",null,null,"?",null,null,null,"Yes","?",null,{"$f":"COUNTIF(B23:AC23,\"Yes\")","v":8}]
["Cost to Authority",{"$f":"IF(OR(B23=\"Yes\",  B23=\"Planned\"),Snow_Flood_Cost,0)","v":0},0,730,0,730,730,730,0,0,0,0,730,0,0,0,730,0,0,730,0,0,0,0,0,0,0,730,0,null,{"$f":"SUM(B24:AC24)","v":5840}]
["Benefit to Authority",{"$f":"IF(OR(B23=\"Yes\",  B23=\"Planned\"),Snow_Flood_Benefit,0)","v":0},0,3000,0,3000,3000,3000,0,0,0,0,3000,0,0,0,3000,0,0,3000,0,0,0,0,0,0,0,3000,0,null,{"$f":"SUM(B25:AC25)","v":24000}]
["Non-Cashable Benefit to Authority",{"$f":"IF(OR(B23=\"Yes\",  B23=\"Planned\"),Snow_Flood_Other,0)","v":0},0,0.55000000000000004,0,0.55000000000000004,0.55000000000000004,0.55000000000000004,0,0,0,0,0.55000000000000004,0,0,0,0.55000000000000004,0,0,0.55000000000000004,0,0,0,0,0,0,0,0.55000000000000004,0,null,{"$f":"IF(SUM(B26:AC26)>0,AVERAGEIF(B26:AC26,\">0\"),0)","v":0.54999999999999993}]
["Total",{"$f":"B25-B24","v":0},0,2270,0,2270,2270,2270,0,0,0,0,2270,0,0,0,2270,0,0,2270,0,0,0,0,0,0,0,2270,{"$f":"AC25-AC24","v":0}]
["Highways Wardens (Highways Authority Managed)","Yes",null,"?",null,"?","?","Yes",null,"Yes",null,null,"Yes",null,null,null,"Yes",null,null,"Yes","?",null,null,"?",null,null,null,"Yes","?",null,{"$f":"COUNTIF(B28:AC28,\"Yes\")","v":7}]
["Cost to Authority",{"$f":"IF(OR(B28=\"Yes\",  B28=\"Planned\"),Highways_Wardens_Cost,0)","v":2230},0,0,0,0,0,2230,0,2230,0,0,2230,0,0,0,2230,0,0,2230,0,0,0,0,0,0,0,2230,0,null,{"$f":"SUM(B29:AC29)","v":15610}]
["Benefit to Authority",{"$f":"IF(OR(B28=\"Yes\",  B28=\"Planned\"),Highways_Wardens_Benefit,0)","v":3000},0,0,0,0,0,3000,0,3000,0,0,3000,0,0,0,3000,0,0,3000,0,0,0,0,0,0,0,3000,0,null,{"$f":"SUM(B30:AC30)","v":21000}]
["Non-Cashable Benefit to Authority",{"$f":"IF(OR(B28=\"Yes\",  B28=\"Planned\"),Highways_Wardens_Other,0)","v":0.75},0,0,0,0,0,0.75,0,0.75,0,0,0.75,0,0,0,0.75,0,0,0.75,0,0,0,0,0,0,0,0.75,0,null,{"$f":"IF(SUM(B31:AC31)>0,AVERAGEIF(B31:AC31,\">0\"),0)","v":0.75}]
["Total",{"$f":"B30-B29","v":770},0,0,0,0,0,770,0,770,0,0,770,0,0,0,770,0,0,770,0,0,0,0,0,0,0,770,{"$f":"AC30-AC29","v":0}]
["Footway Winter Gritting (Includes Grit Provision)","Yes",null,"Yes",null,"No","Yes","Yes",null,"?",null,null,"?",null,null,null,"Yes",null,null,"Yes","?",null,null,"?",null,null,null,"No","?",null,{"$f":"COUNTIF(B33:AC33,\"Yes\")","v":6}]
["Cost to Authority",{"$f":"IF(OR(B33=\"Yes\",  B33=\"Planned\"),Footway_Gritting_Cost,0)","v":2500},0,2500,0,0,2500,2500,0,0,0,0,0,0,0,0,2500,0,0,2500,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B34:AC34)","v":15000}]
["Benefit to Authority",{"$f":"IF(OR(B33=\"Yes\",  B33=\"Planned\"),Footway_Gritting_Benefit,0)","v":3000},0,3000,0,0,3000,3000,0,0,0,0,0,0,0,0,3000,0,0,3000,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B35:AC35)","v":18000}]
["Non-Cashable Benefit to Authority",{"$f":"IF(OR(B33=\"Yes\",  B33=\"Planned\"),Footway_Gritting_Other,0)","v":0.7},0,0.7,0,0,0.7,0.7,0,0,0,0,0,0,0,0,0.7,0,0,0.7,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM(B36:AC36)>0,AVERAGEIF(B36:AC36,\">0\"),0)","v":0.70000000000000007}]
["Total",{"$f":"B35-B34","v":500},{"$f":"C35-C34","v":0},{"$f":"D35-D34","v":500},{"$f":"E35-E34","v":0},{"$f":"F35-F34","v":0},{"$f":"G35-G34","v":500},{"$f":"H35-H34","v":500},{"$f":"I35-I34","v":0},{"$f":"J35-J34","v":0},{"$f":"K35-K34","v":0},{"$f":"L35-L34","v":0},{"$f":"M35-M34","v":0},{"$f":"N35-N34","v":0},{"$f":"O35-O34","v":0},{"$f":"P35-P34","v":0},{"$f":"Q35-Q34","v":500},{"$f":"R35-R34","v":0},{"$f":"S35-S34","v":0},{"$f":"T35-T34","v":500},{"$f":"U35-U34","v":0},{"$f":"V35-V34","v":0},{"$f":"W35-W34","v":0},{"$f":"X35-X34","v":0},{"$f":"Y35-Y34","v":0},{"$f":"Z35-Z34","v":0},{"$f":"AA35-AA34","v":0},{"$f":"AB35-AB34","v":0},{"$f":"AC35-AC34","v":0}]
["Footway Maintenance","Yes",null,"Yes",null,"?","?","Yes",null,"?",null,null,"Yes",null,null,null,"?",null,null,"Yes","?",null,null,"?",null,null,null,"?","?",null,{"$f":"COUNTIF(B38:AC38,\"Yes\")","v":5}]
["Cost to Authority",{"$f":"IF(OR(B38=\"Yes\",  B38=\"Planned\"),Footway_Maintenance_Cost,0)","v":3750},0,3750,0,0,0,3750,0,0,0,0,3750,0,0,0,0,0,0,3750,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B39:AC39)","v":18750}]
["Benefit to Authority",{"$f":"IF(OR(B38=\"Yes\",  B38=\"Planned\"),Footway_Maintenance_Benefit,0)","v":3900},0,3900,0,0,0,3900,0,0,0,0,3900,0,0,0,0,0,0,3900,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B40:AC40)","v":19500}]
["Non-Cashable Benefit to Authority",{"$f":"IF(OR(B38=\"Yes\",  B38=\"Planned\"),Footway_Maintenance_Other,0)","v":0.7},0,0.7,0,0,0,0.7,0,0,0,0,0.7,0,0,0,0,0,0,0.7,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM(B41:AC41)>0,AVERAGEIF(B41:AC41,\">0\"),0)","v":0.7}]
["Total",{"$f":"B40-B39","v":150},{"$f":"C40-C39","v":0},{"$f":"D40-D39","v":150},{"$f":"E40-E39","v":0},{"$f":"F40-F39","v":0},{"$f":"G40-G39","v":0},{"$f":"H40-H39","v":150},{"$f":"I40-I39","v":0},{"$f":"J40-J39","v":0},{"$f":"K40-K39","v":0},{"$f":"L40-L39","v":0},{"$f":"M40-M39","v":150},{"$f":"N40-N39","v":0},{"$f":"O40-O39","v":0},{"$f":"P40-P39","v":0},{"$f":"Q40-Q39","v":0},{"$f":"R40-R39","v":0},{"$f":"S40-S39","v":0},{"$f":"T40-T39","v":150},{"$f":"U40-U39","v":0},{"$f":"V40-V39","v":0},{"$f":"W40-W39","v":0},{"$f":"X40-X39","v":0},{"$f":"Y40-Y39","v":0},{"$f":"Z40-Z39","v":0},{"$f":"AA40-AA39","v":0},{"$f":"AB40-AB39","v":0},{"$f":"AC40-AC39","v":0}]
["Other (Specify)","?",null,"?",null,"?","?","?",null,"?",null,null,"?",null,null,null,"?",null,null,"?","?",null,null,"?",null,null,null,"?","?",null,{"$f":"COUNTIF(B43:AC43,\"Yes\")","v":0}]
["Cost to Authority",{"$f":"IF(OR(B43=\"Yes\",  B43=\"Planned\"),Other_Cost,0)","v":0},{"$f":"IF(OR(C43=\"Yes\",  C43=\"Planned\"),Footway_Maintenance_Cost,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B44:AC44)","v":0}]
["Benefit to Authority",{"$f":"IF(OR(B43=\"Yes\",  B43=\"Planned\"),Other_Benefit,0)","v":0},{"$f":"IF(OR(C43=\"Yes\",  C43=\"Planned\"),Footway_Maintenance_Benefit,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(B45:AC45)","v":0}]
["Non-Cashable Benefit to Authority",{"$f":"IF(OR(B43=\"Yes\",  B43=\"Planned\"),Other_Other,0)","v":0},{"$f":"IF(OR(C43=\"Yes\",  C43=\"Planned\"),Footway_Maintenance_Other,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(SUM(B46:AC46)>0,AVERAGEIF(B46:AC46,\">0\"),0)","v":0}]
["Total",{"$f":"B45-B44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Benefit / Dis-Benefit",{"$f":"B47+B42+B37+B32+B27+B22","v":3660},0,5160,0,4510,2770,3690,0,3010,0,0,5430,0,0,0,5780,0,0,5930,0,0,0,0,0,0,0,3040,0,null,{"$f":"SUM(B48:AC48)","v":42980}]
["Average Non-Cashable Benefits",{"$f":"(B46+B41+B36+B31+B26+B21)/6","v":0.5},{"$f":"(C46+C41+C36+C31+C26+C21)/6","v":0},0.46666666666666662,0,0.23333333333333331,0.20833333333333334,0.45,0,0.26666666666666666,0,0,0.47500000000000003,0,0,0,0.47500000000000003,0,0,0.59166666666666667,0,0,0,0,0,0,0,0.21666666666666667,0,null,{"$f":"AVERAGEIF(B49:AC49,\">0\")","v":0.38833333333333336}]
["Total Relationship Value (Community Budget + Total Benefit)",{"$f":"B48+B15","v":6160},{"$f":"C48+C15","v":0},8160,0,4510,4770,19690,0,5010,0,0,5430,0,0,0,8780,0,0,10930,2000,0,0,5000,0,0,0,8040,0,null,{"$f":"SUM(B50:AC50)","v":88480}]

{"sheet":"Adjacent Minor Works","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Cost Analysis","Average Annual Cost"]
["Equipment & Materials Costs"]
["Cost of Appliances / Equipment",300,"Purchases and depreciation."]
["Cost of Personal Protection Equipment",160,"Where required."]
["Cost of Equipment Maintenance",250,"Cleaning and wear and tear maintenance."]
["Cost of Delivery / Collection",350,"To and from each P&TC (where applicable)."]
["Cost of Consumables / Materials / Fuel",200,"Include cost of calls / data where applicable."]
["Cost of Disposals (Where Applicable)",200,"Waste disposal."]
["Resources Costs"]
["Cost of Scheme Recruitment / Retention",100,"One off cost."]
["Cost of Training",200,"Repeating annual cost."]
["Cost of Supervision",300,"On higher-risk activities."]
["Cost of Incentivisation",100,"Assumes two micro commissions per P&TC."]
["Cost of Network Management"]
["Cost of Notifications",500,"Assumes use of established notifications frameworks and methods."]
["Cost of Traffic Management",3000,"Where required."]
["Total",{"$f":"SUM(B3:B16)","v":5660}]
[]
[]
["Benefits Analysis"]
["Cashable Benefits","Typical Annual Benefits"]
["Economy Gains (Cashable)",3800,"Reductions in cost through use of community-based resources."]
["Efficiency Gains (Cashable)",2900,"Increase in resources efficiency / productivity / throughput."]
["Asset Cost Savings (Cashable)",1200,"Improvements in asset condition, extending asset longevity."]
["Total",{"$f":"SUM(B22:B24)","v":7900}]
[]
["Non-Cashable Benefits","Typical Annual Outcomes"]
["Reputational","Medium [3]"]
["Social (Health & Wellbeing)","Very High [5]"]
["Environmental","Very High [5]"]
["Political","High [4]"]
["Overall Non-Cashable Benefit Score",{"$f":"(Cnum(B28)+Cnum(B29)+Cnum(B30)+Cnum(B31))/20","v":0.85}]

{"sheet":"Snow & Flood Wardens","index":2,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Cost Analysis","Average Annual Cost"]
["Equipment & Materials Costs"]
["Cost of Appliances / Equipment",0,"Purchases and depreciation."]
["Cost of Personal Protection Equipment",160,"Where required."]
["Cost of Equipment Maintenance",0,"Cleaning and wear and tear maintenance."]
["Cost of Delivery / Collection",0,"To and from each P&TC (where applicable)."]
["Cost of Consumables / Materials / Fuel",80,"Include cost of calls / data where applicable."]
["Cost of Disposals (Where Applicable)",0,"Waste disposal."]
["Resources Costs"]
["Cost of Scheme Recruitment / Retention",100,"One off cost."]
["Cost of Training",200,"Repeating annual cost."]
["Cost of Supervision",90,"On higher-risk activities."]
["Cost of Incentivisation",100,"Assumes two micro commissions per P&TC."]
["Cost of Network Management"]
["Cost of Notifications",0,"Assumes use of established notifications frameworks and methods."]
["Cost of Traffic Management",0,"Where required."]
["Total",{"$f":"SUM(B3:B16)","v":730}]
[]
[]
["Benefits Analysis"]
["Cashable Benefits","Typical Annual Benefits"]
["Economy Gains (Cashable)",1200,"Reductions in cost through use of community-based resources."]
["Efficiency Gains (Cashable)",600,"Increase in resources efficiency / productivity / throughput."]
["Asset Cost Savings (Cashable)",1200,"Improvements in asset condition, extending asset longevity."]
["Total",{"$f":"SUM(B22:B24)","v":3000}]
[]
["Non-Cashable Benefits","Typical Annual Outcomes"]
["Reputational","Low [2]"]
["Social (Health & Wellbeing)","Very High [5]"]
["Environmental","Very Low [1]"]
["Political","Medium [3]"]
["Overall Non-Cashable Benefit Score",{"$f":"(Cnum(B28)+Cnum(B29)+Cnum(B30)+Cnum(B31))/20","v":0.55000000000000004}]

{"sheet":"Highways Wardens","index":3,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Cost Analysis","Average Annual Cost"]
["Equipment & Materials Costs"]
["Cost of Appliances / Equipment",1200,"Purchases and depreciation."]
["Cost of Personal Protection Equipment",160,"Where required."]
["Cost of Equipment Maintenance",0,"Cleaning and wear and tear maintenance."]
["Cost of Delivery / Collection",0,"To and from each P&TC (where applicable)."]
["Cost of Consumables / Materials / Fuel",380,"Include cost of calls / data where applicable."]
["Cost of Disposals (Where Applicable)",0,"Waste disposal."]
["Resources Costs"]
["Cost of Scheme Recruitment / Retention",100,"One off cost."]
["Cost of Training",200,"Repeating annual cost."]
["Cost of Supervision",90,"On higher-risk activities."]
["Cost of Incentivisation",100,"Assumes two micro commissions per P&TC."]
["Cost of Network Management"]
["Cost of Notifications",0,"Assumes use of established notifications frameworks and methods."]
["Cost of Traffic Management",0,"Where required."]
["Total",{"$f":"SUM(B3:B16)","v":2230}]
[]
[]
["Benefits Analysis"]
["Cashable Benefits","Typical Annual Benefits"]
["Economy Gains (Cashable)",1200,"Reductions in cost through use of community-based resources."]
["Efficiency Gains (Cashable)",600,"Increase in resources efficiency / productivity / throughput."]
["Asset Cost Savings (Cashable)",1200,"Improvements in asset condition, extending asset longevity."]
["Total",{"$f":"SUM(B22:B24)","v":3000}]
[]
["Non-Cashable Benefits","Typical Annual Outcomes"]
["Reputational","High [4]"]
["Social (Health & Wellbeing)","Very High [5]"]
["Environmental","Low [2]"]
["Political","High [4]"]
["Overall Non-Cashable Benefit Score",{"$f":"(Cnum(B28)+Cnum(B29)+Cnum(B30)+Cnum(B31))/20","v":0.75}]

{"sheet":"Footway Winter Gritting","index":4,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Cost Analysis","Average Annual Cost"]
["Equipment & Materials Costs"]
["Cost of Appliances / Equipment",850,"Purchases and depreciation."]
["Cost of Personal Protection Equipment",160,"Where required."]
["Cost of Equipment Maintenance",200,"Cleaning and wear and tear maintenance."]
["Cost of Delivery / Collection",0,"To and from each P&TC (where applicable)."]
["Cost of Consumables / Materials / Fuel",800,"Include cost of calls / data where applicable."]
["Cost of Disposals (Where Applicable)",0,"Waste disposal."]
["Resources Costs"]
["Cost of Scheme Recruitment / Retention",100,"One off cost."]
["Cost of Training",200,"Repeating annual cost."]
["Cost of Supervision",90,"On higher-risk activities."]
["Cost of Incentivisation",100,"Assumes two micro commissions per P&TC."]
["Cost of Network Management"]
["Cost of Notifications",0,"Assumes use of established notifications frameworks and methods."]
["Cost of Traffic Management",0,"Where required."]
["Total",{"$f":"SUM(B3:B16)","v":2500}]
[]
[]
["Benefits Analysis"]
["Cashable Benefits","Typical Annual Benefits"]
["Economy Gains (Cashable)",1200,"Reductions in cost through use of community-based resources."]
["Efficiency Gains (Cashable)",600,"Increase in resources efficiency / productivity / throughput."]
["Asset Cost Savings (Cashable)",1200,"Improvements in asset condition, extending asset longevity."]
["Total",{"$f":"SUM(B22:B24)","v":3000}]
[]
["Non-Cashable Benefits","Typical Annual Outcomes"]
["Reputational","High [4]"]
["Social (Health & Wellbeing)","Very High [5]"]
["Environmental","Very Low [1]"]
["Political","High [4]"]
["Overall Non-Cashable Benefit Score",{"$f":"(Cnum(B28)+Cnum(B29)+Cnum(B30)+Cnum(B31))/20","v":0.7}]

{"sheet":"Footway Maintenance","index":5,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Cost Analysis","Average Annual Cost"]
["Equipment & Materials Costs"]
["Cost of Appliances / Equipment",1200,"Purchases and depreciation."]
["Cost of Personal Protection Equipment",160,"Where required."]
["Cost of Equipment Maintenance",200,"Cleaning and wear and tear maintenance."]
["Cost of Delivery / Collection",600,"To and from each P&TC (where applicable)."]
["Cost of Consumables / Materials / Fuel",800,"Include cost of calls / data where applicable."]
["Cost of Disposals (Where Applicable)",300,"Waste disposal."]
["Resources Costs"]
["Cost of Scheme Recruitment / Retention",100,"One off cost."]
["Cost of Training",200,"Repeating annual cost."]
["Cost of Supervision",90,"On higher-risk activities."]
["Cost of Incentivisation",100,"Assumes two micro commissions per P&TC."]
["Cost of Network Management"]
["Cost of Notifications",0,"Assumes use of established notifications frameworks and methods."]
["Cost of Traffic Management",0,"Where required."]
["Total",{"$f":"SUM(B3:B16)","v":3750}]
[]
[]
["Benefits Analysis"]
["Cashable Benefits","Typical Annual Benefits"]
["Economy Gains (Cashable)",1900,"Reductions in cost through use of community-based resources."]
["Efficiency Gains (Cashable)",800,"Increase in resources efficiency / productivity / throughput."]
["Asset Cost Savings (Cashable)",1200,"Improvements in asset condition, extending asset longevity."]
["Total",{"$f":"SUM(B22:B24)","v":3900}]
[]
["Non-Cashable Benefits","Typical Annual Outcomes"]
["Reputational","High [4]"]
["Social (Health & Wellbeing)","Very High [5]"]
["Environmental","Very Low [1]"]
["Political","High [4]"]
["Overall Non-Cashable Benefit Score",{"$f":"(Cnum(B28)+Cnum(B29)+Cnum(B30)+Cnum(B31))/20","v":0.7}]

{"sheet":"Other","index":6,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Cost Analysis","Average Annual Cost"]
["Equipment & Materials Costs"]
["Cost of Appliances / Equipment",1200,"Purchases and depreciation."]
["Cost of Personal Protection Equipment",160,"Where required."]
["Cost of Equipment Maintenance",200,"Cleaning and wear and tear maintenance."]
["Cost of Delivery / Collection",600,"To and from each P&TC (where applicable)."]
["Cost of Consumables / Materials / Fuel",800,"Include cost of calls / data where applicable."]
["Cost of Disposals (Where Applicable)",300,"Waste disposal."]
["Resources Costs"]
["Cost of Scheme Recruitment / Retention",100,"One off cost."]
["Cost of Training",200,"Repeating annual cost."]
["Cost of Supervision",90,"On higher-risk activities."]
["Cost of Incentivisation",100,"Assumes two micro commissions per P&TC."]
["Cost of Network Management"]
["Cost of Notifications",0,"Assumes use of established notifications frameworks and methods."]
["Cost of Traffic Management",0,"Where required."]
["Total",{"$f":"SUM(B3:B16)","v":3750}]
[]
[]
["Benefits Analysis"]
["Cashable Benefits","Typical Annual Benefits"]
["Economy Gains (Cashable)",1900,"Reductions in cost through use of community-based resources."]
["Efficiency Gains (Cashable)",800,"Increase in resources efficiency / productivity / throughput."]
["Asset Cost Savings (Cashable)",1200,"Improvements in asset condition, extending asset longevity."]
["Total",{"$f":"SUM(B22:B24)","v":3900}]
[]
["Non-Cashable Benefits","Typical Annual Outcomes"]
["Reputational","High [4]"]
["Social (Health & Wellbeing)","Very High [5]"]
["Environmental","Very Low [1]"]
["Political","High [4]"]
["Overall Non-Cashable Benefit Score",{"$f":"(Cnum(B28)+Cnum(B29)+Cnum(B30)+Cnum(B31))/20","v":0.7}]