{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Import data","Summary","Settings"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":122,"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":"Import data","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,1,22,4],[13,1,13,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
[null,"HMEA Collator"]
[null,{"$f":"\" Version: v\" & Settings!B1","v":" Version: v1.02"}]
[null,"File paths for HMEA analyses"]
[]
[]
[]
[]
[]
[null,"File path"]
[1,"C:\\Data\\projects\\Wales Benefits of maintenance\\Wales analyses\\Example\\Collator files\\HMEA - Backlog 6 sect Traff.xlsm"]
[2,"C:\\Data\\projects\\Wales Benefits of maintenance\\Wales analyses\\Example\\Collator files\\HMEA - Current Budget 6 sect Traff.xlsm"]
[3]
[4]
[5]
[]
[]
[]
[]
[]
[null,"Liability"]
[null,"No Liability for loss or damage that may be suffered by any person or organisation as a result of the use of this model, or as the result of any errors or omissions in the information contained herein, is accepted by the developers of the toolkit."]
[]
[]
[]
[null,"Version history"]
[]
[null,"Version","Date","Description"]
[null,"1.00","2019-11-08","Version for client review"]
[null,"1.01","2019-12-06","Added help button and carbon total onto summary sheet, improved colour coding on summary sheet to guide use."]
[null,"1.02","2020-05-12","Changes to headings on summary sheet"]

{"sheet":"Summary","index":1,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[44,1,44,2],[5,1,5,2],[6,1,6,2],[20,1,20,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[53,1,53,2],[54,1,54,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[51,1,51,2],[52,1,52,2]]}
[null,"Display results?",null,{"$f":"IF(AND(SelectedCase<>1,D11<>\"\",SelectedHasData),TRUE,FALSE)","v":true},{"$f":"IF(AND(SelectedCase<>2,E11<>\"\",SelectedHasData),TRUE,FALSE)","v":false},{"$f":"IF(AND(SelectedCase<>3,F11<>\"\",SelectedHasData),TRUE,FALSE)","v":false},{"$f":"IF(AND(SelectedCase<>4,G11<>\"\",SelectedHasData),TRUE,FALSE)","v":false},{"$f":"IF(AND(SelectedCase<>5,H11<>\"\",SelectedHasData),TRUE,FALSE)","v":false}]
[null,"HMEA Collator"]
[null,{"$f":"\"Version: v\" & Settings!B1","v":"Version: v1.02"}]
[]
[]
[null,"Analysis Name",null,"No Backlog - 6 sectors, 30 years, with traffic effect","Current Budget - 6 sectors, 30 years, with traffic effect"]
[null,"Base Case Selector"]
[]
[null,"Undiscounted costs"]
[]
[null,"Direct Cost: Maintenance","£k",540624.77933541161,166971.6]
[]
[null,"HMAT Indirect Costs","£k",169250126.51973179,155870546.73674256]
[null,"Total Carbon costs","£k",4877540.1499383729,4038318.9635539507]
[]
[null,"Network benefits","£k",15180401.570591772,14163699.776115015]
[null,"Public Income","£k",50965445.5785321,2799910.8360986803]
[null,"Economic Impacts","£k",261742977.12683445,251987201.31069362]
[]
[]
[null,"Overall Economic Contribution (EC)",null,{"$f":"IF(D$1,IFERROR((dis_A_Base-dis_A_1)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":121.92705720072584},{"$f":"IF(E$1,IFERROR((dis_A_Base-dis_A_2)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_A_Base-dis_A_3)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_A_Base-dis_A_4)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_A_Base-dis_A_5)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[]
[null,"EC: HMAT + HMEA (Economic)",null,{"$f":"IF(D$1,IFERROR((dis_B_Base-dis_B_1)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":-9.6983089326144274},{"$f":"IF(E$1,IFERROR((dis_B_Base-dis_B_2)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_B_Base-dis_B_3)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_B_Base-dis_B_4)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_B_Base-dis_B_5)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Excluding Economic)",null,{"$f":"IF(D$1,IFERROR((dis_C_Base-dis_C_1)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":95.817883358039197},{"$f":"IF(E$1,IFERROR((dis_C_Base-dis_C_2)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_C_Base-dis_C_3)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_C_Base-dis_C_4)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_C_Base-dis_C_5)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Excluding HMAT)",null,{"$f":"IF(D$1,IFERROR((dis_D_Base-dis_D_1)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":157.73453997602681},{"$f":"IF(E$1,IFERROR((dis_D_Base-dis_D_2)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_D_Base-dis_D_3)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_D_Base-dis_D_4)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_D_Base-dis_D_5)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Net Ben + Public Inc.)",null,{"$f":"IF(D$1,IFERROR((dis_E_Base-dis_E_1)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":131.62536613334018},{"$f":"IF(E$1,IFERROR((dis_E_Base-dis_E_2)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_E_Base-dis_E_3)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_E_Base-dis_E_4)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_E_Base-dis_E_5)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[]
[null,"EC: HMEA (Economic)",null,{"$f":"IF(D$1,IFERROR((dis_EcoImp_1-dis_EcoImp_Base)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":26.109173842686641},{"$f":"IF(E$1,IFERROR((dis_EcoImp_2-dis_EcoImp_Base)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_EcoImp_3-dis_EcoImp_Base)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_EcoImp_4-dis_EcoImp_Base)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_EcoImp_5-dis_EcoImp_Base)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMAT",null,{"$f":"IF(D$1,IFERROR((dis_HMAT_BASE-dis_HMAT_1)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":-35.807482775301068},{"$f":"IF(E$1,IFERROR((dis_HMAT_BASE-dis_HMAT_2)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_HMAT_BASE-dis_HMAT_3)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_HMAT_BASE-dis_HMAT_4)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_HMAT_BASE-dis_HMAT_5)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Network Benefit)",null,{"$f":"IF(D$1,IFERROR((dis_NetBen_1-dis_NetBen_Base)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":2.7209772342499177},{"$f":"IF(E$1,IFERROR((dis_NetBen_2-dis_NetBen_Base)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_NetBen_3-dis_NetBen_Base)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_NetBen_4-dis_NetBen_Base)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_NetBen_5-dis_NetBen_Base)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Public Income)",null,{"$f":"IF(D$1,IFERROR((dis_PublicInc_1-dis_PublicInc_Base)/(dis_DirCost_1-dis_DirCost_Base),\"\"),\"\")","v":128.90438889909026},{"$f":"IF(E$1,IFERROR((dis_PublicInc_2-dis_PublicInc_Base)/(dis_DirCost_2-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((dis_PublicInc_3-dis_PublicInc_Base)/(dis_DirCost_3-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((dis_PublicInc_4-dis_PublicInc_Base)/(dis_DirCost_4-dis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((dis_PublicInc_5-dis_PublicInc_Base)/(dis_DirCost_5-dis_DirCost_Base),\"\"),\"\")","v":""}]
[]
[null,"Discounted costs"]
[]
[null,"Direct Cost: Maintenance","£k",354654.57838948839,105947.74911147289]
[]
[null,"HMAT Indirect Costs","£k",96231289.74549225,90197937.475481302]
[null,"Total Carbon costs","£k",2643615.7483734596,2239694.9959911932]
[]
[null,"Network benefits","£k",8740295.8772075884,8243538.8941561058]
[null,"Public Income","£k",24413273.461792268,2000192.934563166]
[null,"Economic Impacts","£k",159727012.90839019,154766589.85999471]
[]
[]
[null,"Overall Economic Contribution (EC)",null,{"$f":"IF(D$1,IFERROR((undis_A_Base-undis_A_1)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":87.8018040439689},{"$f":"IF(E$1,IFERROR((undis_A_Base-undis_A_2)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_A_Base-undis_A_3)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_A_Base-undis_A_4)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_A_Base-undis_A_5)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[]
[null,"EC: HMAT + HMEA (Economic)",null,{"$f":"IF(D$1,IFERROR((undis_B_Base-undis_B_1)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":-4.3140320059972934},{"$f":"IF(E$1,IFERROR((undis_B_Base-undis_B_2)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_B_Base-undis_B_3)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_B_Base-undis_B_4)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_B_Base-undis_B_5)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Excluding Economic)",null,{"$f":"IF(D$1,IFERROR((undis_C_Base-undis_C_1)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":67.856943411088935},{"$f":"IF(E$1,IFERROR((undis_C_Base-undis_C_2)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_C_Base-undis_C_3)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_C_Base-undis_C_4)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_C_Base-undis_C_5)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Excluding HMAT)",null,{"$f":"IF(D$1,IFERROR((undis_D_Base-undis_D_1)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":112.06069668284614},{"$f":"IF(E$1,IFERROR((undis_D_Base-undis_D_2)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_D_Base-undis_D_3)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_D_Base-undis_D_4)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_D_Base-undis_D_5)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Net Ben + Public Inc.)",null,{"$f":"IF(D$1,IFERROR((undis_E_Base-undis_E_1)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":92.115836049966106},{"$f":"IF(E$1,IFERROR((undis_E_Base-undis_E_2)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_E_Base-undis_E_3)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_E_Base-undis_E_4)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_E_Base-undis_E_5)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[]
[null,"EC: HMEA (Economic)",null,{"$f":"IF(D$1,IFERROR((undis_EcoImp_1-undis_EcoImp_Base)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":19.944860632879944},{"$f":"IF(E$1,IFERROR((undis_EcoImp_2-undis_EcoImp_Base)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_EcoImp_3-undis_EcoImp_Base)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_EcoImp_4-undis_EcoImp_Base)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_EcoImp_5-undis_EcoImp_Base)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMAT",null,{"$f":"IF(D$1,IFERROR((undis_HMAT_BASE-undis_HMAT_1)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":-24.258892638877239},{"$f":"IF(E$1,IFERROR((undis_HMAT_BASE-undis_HMAT_2)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_HMAT_BASE-undis_HMAT_3)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_HMAT_BASE-undis_HMAT_4)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_HMAT_BASE-undis_HMAT_5)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Network Benefit)",null,{"$f":"IF(D$1,IFERROR((undis_NetBen_1-undis_NetBen_Base)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":1.9973596402380476},{"$f":"IF(E$1,IFERROR((undis_NetBen_2-undis_NetBen_Base)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_NetBen_3-undis_NetBen_Base)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_NetBen_4-undis_NetBen_Base)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_NetBen_5-undis_NetBen_Base)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]
[null,"EC: HMEA (Public Income)",null,{"$f":"IF(D$1,IFERROR((undis_PublicInc_1-undis_PublicInc_Base)/(undis_DirCost_1-undis_DirCost_Base),\"\"),\"\")","v":90.118476409728046},{"$f":"IF(E$1,IFERROR((undis_PublicInc_2-undis_PublicInc_Base)/(undis_DirCost_2-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(F$1,IFERROR((undis_PublicInc_3-undis_PublicInc_Base)/(undis_DirCost_3-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(G$1,IFERROR((undis_PublicInc_4-undis_PublicInc_Base)/(undis_DirCost_4-undis_DirCost_Base),\"\"),\"\")","v":""},{"$f":"IF(H$1,IFERROR((undis_PublicInc_5-undis_PublicInc_Base)/(undis_DirCost_5-undis_DirCost_Base),\"\"),\"\")","v":""}]

{"sheet":"Settings","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Version number","1.02"]
["Base case",2,null,1,2,3,4,5]
["Has data",{"$f":"OFFSET(Summary!B11,0,$B$2)<>\"\"","v":true}]
[]
[]
["Discounted costs"]
[]
[null,"Selected"]
["Expenditure by Treatment",{"$f":"OFFSET(Summary!C11,0,$B$2)","v":166971.6},null,{"$f":"Summary!D11","v":540624.77933541161},{"$f":"Summary!E11","v":166971.6},{"$f":"Summary!F11","v":0},{"$f":"Summary!G11","v":0},{"$f":"Summary!H11","v":0}]
[]
["HMAT analysis total cost",{"$f":"OFFSET(Summary!C13,0,$B$2)","v":155870546.73674256},null,{"$f":"Summary!D13","v":169250126.51973179},{"$f":"Summary!E13","v":155870546.73674256},{"$f":"Summary!F13","v":0},{"$f":"Summary!G13","v":0},{"$f":"Summary!H13","v":0}]
["Network benefits",{"$f":"OFFSET(Summary!C16,0,$B$2)","v":14163699.776115015},null,{"$f":"Summary!D16","v":15180401.570591772},{"$f":"Summary!E16","v":14163699.776115015},{"$f":"Summary!F16","v":0},{"$f":"Summary!G16","v":0},{"$f":"Summary!H16","v":0}]
["Public Income",{"$f":"OFFSET(Summary!C17,0,$B$2)","v":2799910.8360986803},null,{"$f":"Summary!D17","v":50965445.5785321},{"$f":"Summary!E17","v":2799910.8360986803},{"$f":"Summary!F17","v":0},{"$f":"Summary!G17","v":0},{"$f":"Summary!H17","v":0}]
["Economic Impacts",{"$f":"OFFSET(Summary!C18,0,$B$2)","v":251987201.31069362},null,{"$f":"Summary!D18","v":261742977.12683445},{"$f":"Summary!E18","v":251987201.31069362},{"$f":"Summary!F18","v":0},{"$f":"Summary!G18","v":0},{"$f":"Summary!H18","v":0}]
[]
["Calc for BCR A",{"$f":"B11-B12-B13-B14","v":-113080265.18616474},null,{"$f":"D11-D12-D13-D14","v":-158638697.75622654},{"$f":"E11-E12-E13-E14","v":-113080265.18616474},{"$f":"F11-F12-F13-F14","v":0},{"$f":"G11-G12-G13-G14","v":0},{"$f":"H11-H12-H13-H14","v":0}]
["Calc for BCR B",{"$f":"B11-B14","v":-96116654.573951066},null,{"$f":"D11-D14","v":-92492850.607102662},{"$f":"E11-E14","v":-96116654.573951066},{"$f":"F11-F14","v":0},{"$f":"G11-G14","v":0},{"$f":"H11-H14","v":0}]
["Calc for BCR C",{"$f":"B11-B12-B13","v":138906936.12452888},null,{"$f":"D11-D12-D13","v":103104279.37060791},{"$f":"E11-E12-E13","v":138906936.12452888},{"$f":"F11-F12-F13","v":0},{"$f":"G11-G12-G13","v":0},{"$f":"H11-H12-H13","v":0}]
["Calc for BCR D",{"$f":"-B12-B13-B14","v":-268950811.92290729},null,{"$f":"-D12-D13-D14","v":-327888824.2759583},{"$f":"-E12-E13-E14","v":-268950811.92290729},{"$f":"-F12-F13-F14","v":0},{"$f":"-G12-G13-G14","v":0},{"$f":"-H12-H13-H14","v":0}]
["Calc for BCR E",{"$f":"-B12-B13","v":-16963610.612213694},null,{"$f":"-D12-D13","v":-66145847.14912387},{"$f":"-E12-E13","v":-16963610.612213694},{"$f":"-F12-F13","v":0},{"$f":"-G12-G13","v":0},{"$f":"-H12-H13","v":0}]
[]
[]
["Un-discounted costs"]
[]
[null,"Selected"]
["Expenditure by Treatment",{"$f":"OFFSET(Summary!C35,0,$B$2)","v":105947.74911147289},null,{"$f":"Summary!D35","v":354654.57838948839},{"$f":"Summary!E35","v":105947.74911147289},{"$f":"Summary!F35","v":0},{"$f":"Summary!G35","v":0},{"$f":"Summary!H35","v":0}]
[]
["HMAT analysis total cost",{"$f":"OFFSET(Summary!C37,0,$B$2)","v":90197937.475481302},null,{"$f":"Summary!D37","v":96231289.74549225},{"$f":"Summary!E37","v":90197937.475481302},{"$f":"Summary!F37","v":0},{"$f":"Summary!G37","v":0},{"$f":"Summary!H37","v":0}]
["Network benefits",{"$f":"OFFSET(Summary!C40,0,$B$2)","v":8243538.8941561058},null,{"$f":"Summary!D40","v":8740295.8772075884},{"$f":"Summary!E40","v":8243538.8941561058},{"$f":"Summary!F40","v":0},{"$f":"Summary!G40","v":0},{"$f":"Summary!H40","v":0}]
["Public Income",{"$f":"OFFSET(Summary!C41,0,$B$2)","v":2000192.934563166},null,{"$f":"Summary!D41","v":24413273.461792268},{"$f":"Summary!E41","v":2000192.934563166},{"$f":"Summary!F41","v":0},{"$f":"Summary!G41","v":0},{"$f":"Summary!H41","v":0}]
["Economic Impacts",{"$f":"OFFSET(Summary!C42,0,$B$2)","v":154766589.85999471},null,{"$f":"Summary!D42","v":159727012.90839019},{"$f":"Summary!E42","v":154766589.85999471},{"$f":"Summary!F42","v":0},{"$f":"Summary!G42","v":0},{"$f":"Summary!H42","v":0}]
[]
["Calc for BCR A",{"$f":"B28-B29-B30-B31","v":-74812384.213232666},null,{"$f":"D28-D29-D30-D31","v":-96649292.501897812},{"$f":"E28-E29-E30-E31","v":-74812384.213232666},{"$f":"F28-F29-F30-F31","v":0},{"$f":"G28-G29-G30-G31","v":0},{"$f":"H28-H29-H30-H31","v":0}]
["Calc for BCR B",{"$f":"B28-B31","v":-64568652.384513408},null,{"$f":"D28-D31","v":-63495723.162897944},{"$f":"E28-E31","v":-64568652.384513408},{"$f":"F28-F31","v":0},{"$f":"G28-G31","v":0},{"$f":"H28-H31","v":0}]
["Calc for BCR C",{"$f":"B28-B29-B30","v":79954205.646762043},null,{"$f":"D28-D29-D30","v":63077720.40649239},{"$f":"E28-E29-E30","v":79954205.646762043},{"$f":"F28-F29-F30","v":0},{"$f":"G28-G29-G30","v":0},{"$f":"H28-H29-H30","v":0}]
["Calc for BCR D",{"$f":"-B29-B30-B31","v":-165010321.68871397},null,{"$f":"-D29-D30-D31","v":-192880582.24739006},{"$f":"-E29-E30-E31","v":-165010321.68871397},{"$f":"-F29-F30-F31","v":0},{"$f":"-G29-G30-G31","v":0},{"$f":"-H29-H30-H31","v":0}]
["Calc for BCR E",{"$f":"-B29-B30","v":-10243731.828719271},null,{"$f":"-D29-D30","v":-33153569.338999856},{"$f":"-E29-E30","v":-10243731.828719271},{"$f":"-F29-F30","v":0},{"$f":"-G29-G30","v":0},{"$f":"-H29-H30","v":0}]