{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["CIRIA W047c","HOME","Version Info","Scheme comparisons ESS","ESS Cost vs Benefit","ESS Benefit Comparison","Sheet1","Scenario Comparisons","Scenario Comparisons Data"],"not_rendered":{"charts":17,"images":16,"macros":1,"external_links":0,"defined_names":80,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"ESS Cost vs Benefit","index":4,"reason":"not_a_worksheet"},{"sheet":"ESS Benefit Comparison","index":5,"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":"CIRIA W047c","index":0,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,3,3,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"About CIRIA W047c B£ST: Options Comparison Tool",null,">>HIDE_ALONG"]
[null,"Release version 3,       January 2019"]
[]
[null,"Authors:",null,"Prof. Christopher Digman, Dr Bruce Horton, Jordan McMullan (Stantec) and Prof Richard Ashley (EcoFutures)"]
[null,"Developer:",null,"Gordon Wallace (WXLSolutions Ltd)"]
[null,"CIRIA Project Managers:",null,"Paul Shaffer (Project Director) "]
[null,"Funders:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Thanks to our previous funders: JBA Trust, Northern Ireland Environment Agency & Mayor of London."]
[]
[null,"For more information contact:",null,null,"CIRIA, Griffin Court, 15 Long Lane, London, EC1A 9PN, UK    +44 (0) 207 549 3300"]
[null,"For questions on the tool email: ",null,null,"best@susdrain.org"]
[]
[]
[">>HIDE_BELOW"]

{"sheet":"HOME","index":1,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Benefits Evaluation - Options Comparison Tool",null,null,">>HIDE_ALONG",{"$f":"IF(I13<>\"\",\"PROJECT DETAILS -   \"&I13,\"(Project Details Incomplete)\")","v":"(Project Details Incomplete)"},null,null,null,null,null,null,null,33.75]
[null,null,null,null,{"$f":"strVersion","v":"Version: 3.000, January-2019"},null,null,null,"do not edit this cell.. It is needed elsewhere..// move it if you HAVE to but don't delete!",null,null,null,null,null,null,null,12]
[null,null,{"$f":"ProjDetails","v":"(Project Details Incomplete)"},null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,"Ciric Green;  91,184,21",null,null,null,null,null,null,null,20]
[]
[null,null,null,null,null,null,null,null,"STILL TO DO"]
[null,null,null,null,null,null,null,null,"42% of everything"]
[null,null,null,null,null,null,null,null,"another menu item to inputs page (or ribbon whilst inputs page active) to clear all catchment information..// and to possible clear all top information.information"]
[]
[null,null,"ENTER Basic Project details below."]
[]
[null,null,null,null,null,null,null,null,"No:   Name:    Assmt. Version:    Date:"]
[null,null,"PROJECT DETAILS",null,null,null,null,null,{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(J13,\"><\",\",    \"),\"<\",\"\"),\">\",\".\")","v":""},{"$f":"J21&J19&J23&J17","v":""},null,"Values"]
[]
[null,null,"Author","please enter",null,null,null,"pdAuthor",{"$f":"IF(INDIRECT(H15)=\"please enter\",\"\",INDIRECT(H15))","v":""},{"$f":"IF(I15=\"\",\"\",\"<\"&I15&\">\")","v":""},null,"please enter"]
[]
[null,null,"Date","please enter",null,null,null,"pdDate",{"$f":"IF(INDIRECT(H17)=\"please enter\",\"\",INDIRECT(H17))","v":""},{"$f":"IF(I17=\"\",\"\",\"<Date: \"&TEXT(I17,\"mmm yyyy\")&\">\")","v":""},4,"please enter"]
[]
[null,null,"Project Name","please enter",null,null,null,"pdProjectName",{"$f":"IF(INDIRECT(H19)=\"please enter\",\"\",INDIRECT(H19))","v":""},{"$f":"IF(I19=\"\",\"\",\"<Name: \"&I19&\">\")","v":""},2,"please enter"]
[]
[null,null,"Project Reference Number","please enter",null,null,null,"pdProjectNumber",{"$f":"IF(INDIRECT(H21)=\"please enter\",\"\",INDIRECT(H21))","v":""},{"$f":"IF(I21=\"\",\"\",\"<No.: \"&I21&\">\")","v":""},1,"please enter"]
[]
[null,null,"Assessment version","please enter",null,null,null,"pdAssessVer",{"$f":"IF(INDIRECT(H23)=\"please enter\",\"\",INDIRECT(H23))","v":""},{"$f":"IF(I23=\"\",\"\",\"<Assmt. Version: \"&I23&\">\")","v":""},3,"please enter"]
[]
[null,null,"Have you assessed scenarios? Double click the button to show/hide the scenario sheets. ",null,null,null,null,null,false]
[]
[]
[]
[]
[">>HIDE_BELOW"]

{"sheet":"Version Info","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,5],[3,2,3,5]]}
[null,null,"Version Control",null,null,null,null,null,">>HIDE_ALONG"]
[null,null,null,null,null,{"$f":"strVersion","v":"Version: 3.000, January-2019"}]
[null,null,{"$f":"ProjDetails","v":"(Project Details Incomplete)"}]
[null,null,"This page contains information related to changes since the last version"]
[null,null,"Version","Date","Description","Author"]
[null,null,1,"2015-07-02","Release version 1","CD, GW"]
[null,null,1.01,"2015-07-24","Updates to logos","CD"]
[null,null,1.02,"2015-08-04","text updates","CD, GW"]
[null,null,1.03,"2016-09-29","Chart amendments","CD, GW"]
[null,null,2.0099999999999998,"2017-10-31","Inclusion of scenario comparisons","GW"]
[null,null,2.02,"2017-03-09","Minor updates and formatting","CJD/GW"]
[null,null,3,"2019-01-04","Updates to incorporate revised B£ST.","CJD/GW"]
[]
[">>HIDE_BELOW"]

{"sheet":"Scheme comparisons ESS","index":3,"n_rows":85,"n_cols":20,"rows_kept":85,"cut":false,"hidden":false,"merged":[[53,1,62,1],[64,1,70,1],[72,1,80,1],[82,1,84,1]]}
[null,null,null,null,null,"B£ST Benefit estimate comparisons ",null,null,">>HIDE_ALONG",null,null,null,null,null,null,null,null,null,null,">>HIDE_ALONG"]
[null,{"$f":"ProjDetails","v":"(Project Details Incomplete)"}]
[]
[null,"Note: Paste in data from the tool to enable a comparison. "]
[]
[]
[null,null,"Include option in chart?","YES","NO","NO","NO"]
[]
[null,null,"Scheme/Option Reference","Insert ref","Insert ref","Insert ref","Insert ref"]
[null,null,"Scheme Summary"]
[null,null,"Scheme present value cost",null,0,0,0]
[null,null,"Scheme present value benefits",{"$f":"SUM(D15:D37)","v":0},{"$f":"SUM(E15:E37)","v":0},0,0]
[null,null,"Overall scheme net present value",{"$f":"D12-D11","v":0},{"$f":"E12-E11","v":0},{"$f":"F12-F11","v":0},{"$f":"G12-G11","v":0}]
[null,null,"Impact","Present Value (£)","Present Value (£)","Present Value (£)","Present Value (£)"]
[null,null,"Air quality"]
[null,null,"Amenity"]
[null,null,"Asset performance"]
[null,null,"Biodiversity and ecology"]
[null,null,"Building temperature"]
[null,null,"Carbon reduction and sequestration"]
[null,null,"Crime"]
[null,null,"Economic growth "]
[null,null,"Education"]
[null,null,"Enabling development"]
[null,null,"Flooding"]
[null,null,"Health"]
[null,null,"Noise"]
[null,null,"Recreation"]
[null,null,"Tourism"]
[null,null,"Traffic calming"]
[null,null,"Water quality"]
[null,null,"Water quantity"]
[null,null,"User-defined 1"]
[null,null,"User-defined 2"]
[null,null,"User-defined 3"]
[null,null,"User-defined 4"]
[null,null,"User-defined 5"]
[]
[null,null,"Where user defined benefits have been included, sum the values in the following cells below to the appropriate type of Ecosystem Service"]
[null,null,"User defined Provisioning Services"]
[null,null,"User defined Regulating Services"]
[null,null,"User defined Cultural Services"]
[null,null,"User defined Supporting Services"]
[]
[]
[null,null,"Ecosystem service",{"$f":"D9","v":"Insert ref"},{"$f":"E9","v":"Insert ref"},"Insert ref","Insert ref"]
[null,null," Provisioning",{"$f":"SUM(D32,D29,D24,D17,D22,D40)","v":0},{"$f":"SUM(E32,E29,E24,E17,E22,E40)","v":0},0,0]
[null,null," Regulating",{"$f":"SUM(D15,D19,D20,D25,D31,D41)","v":0},{"$f":"SUM(E15,E19,E20,E25,E31,E41)","v":0},0,0]
[null,null," Cultural",{"$f":"SUM(D16,D21,D23,D26,D27,D28,D30,D42)","v":0},{"$f":"SUM(E16,E21,E23,E26,E27,E28,E30,E42)","v":0},0,0]
[null,null," Supporting",{"$f":"SUM(D18,D43)","v":0},{"$f":"SUM(E18,E43)","v":0},0,0]
[]
[]
[">>HIDE_BELOW"]
[null,"Provisioning services","Economic growth ",{"$f":"D22","v":0},{"$f":"E22","v":0},0,0]
[null,null,"Enabling development",{"$f":"D24","v":0},{"$f":"E24","v":0},0,0]
[null,null,null,null,null,null,null,"Not used"]
[null,null,"Asset Performance",{"$f":"D17","v":0},{"$f":"E17","v":0},0,0]
[null,null,"Water quantity",{"$f":"D32","v":0},{"$f":"E32","v":0},0,0]
[null,null,"Tourism",{"$f":"D29","v":0},{"$f":"E29","v":0},0,0]
[null,null,null,null,null,null,null,"Not used"]
[null,null,null,null,null,null,null,"Not used"]
[null,null,"User-defined",{"$f":"D40","v":0},{"$f":"E40","v":0},0,0]
[null,null,null,null,null,null,null,"Not used"]
[]
[null,"Regulating services","Air quality",{"$f":"D15","v":0},{"$f":"E15","v":0},0,0]
[null,null,"Building temperature",{"$f":"D19","v":0},{"$f":"E19","v":0},0,0]
[null,null,"Carbon reduction and sequestration",{"$f":"D20","v":0},{"$f":"E20","v":0},0,0]
[null,null,"Flooding",{"$f":"D25","v":0},{"$f":"E25","v":0},0,0]
[null,null,"Water quality",{"$f":"D31","v":0},{"$f":"E31","v":0},0,0]
[null,null,null,null,null,null,null,"Not used"]
[null,null,"User-defined",{"$f":"D41","v":0},{"$f":"E41","v":0},0,0]
[]
[null,"Cultural services","Amenity",{"$f":"D16","v":0},{"$f":"E16","v":0},0,0]
[null,null,"Noise",{"$f":"D27","v":0},{"$f":"E27","v":0},0,0,"Not used"]
[null,null,"Crime",{"$f":"D21","v":0},{"$f":"E21","v":0},0,0]
[null,null,"Education",{"$f":"D23","v":0},{"$f":"E23","v":0},0,0]
[null,null,"Health",{"$f":"D26","v":0},{"$f":"E26","v":0},0,0]
[null,null,"Recreation",{"$f":"D28","v":0},{"$f":"E28","v":0},0,0]
[null,null,"Traffic calming",{"$f":"D30","v":0},{"$f":"E30","v":0},0,0]
[null,null,"User-defined",{"$f":"D42","v":0},{"$f":"E42","v":0},0,0]
[null,null,null,null,null,null,null,"Not used"]
[]
[null,"Supporting services","Biodiversity and ecology",{"$f":"D18","v":0},{"$f":"E18","v":0},0,0]
[null,null,"User-defined",{"$f":"D43","v":0},{"$f":"E43","v":0},0,0]
[null,null,null,null,null,null,null,"Not used"]

{"sheet":"Sheet1","index":6,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":true,"merged":[[2,8,2,9]]}
[]
[]
[null,null,null,{"$f":"IncOp1=\"YES\"","v":true},{"$f":"IncOp2=\"YES\"","v":false},{"$f":"IncOp3=\"YES\"","v":false},{"$f":"IncOp4=\"YES\"","v":false}]
[]
[null,"Total",null,{"$f":"SUM(D6:D8)","v":0},{"$f":"SUM(E6:E8)","v":0},{"$f":"SUM(F6:F8)","v":0},{"$f":"SUM(G6:G8)","v":0}]
[null,{"$f":"'Scheme comparisons ESS'!B54","v":"Provisioning services"},null,{"$f":"SUM('Scheme comparisons ESS'!D54:D63)","v":0},{"$f":"SUM('Scheme comparisons ESS'!E54:E63)","v":0},{"$f":"SUM('Scheme comparisons ESS'!F54:F63)","v":0},{"$f":"SUM('Scheme comparisons ESS'!G54:G63)","v":0}]
[null,{"$f":"'Scheme comparisons ESS'!B65","v":"Regulating services"},null,{"$f":"SUM('Scheme comparisons ESS'!D65:D71)","v":0},{"$f":"SUM('Scheme comparisons ESS'!E65:E71)","v":0},{"$f":"SUM('Scheme comparisons ESS'!F65:F71)","v":0},{"$f":"SUM('Scheme comparisons ESS'!G65:G71)","v":0}]
[null,{"$f":"'Scheme comparisons ESS'!B73","v":"Cultural services"},null,{"$f":"SUM('Scheme comparisons ESS'!D73:D81)","v":0},{"$f":"SUM('Scheme comparisons ESS'!E73:E81)","v":0},{"$f":"SUM('Scheme comparisons ESS'!F73:F81)","v":0},{"$f":"SUM('Scheme comparisons ESS'!G73:G81)","v":0}]
[null,{"$f":"'Scheme comparisons ESS'!B83","v":"Supporting services"},null,{"$f":"SUM('Scheme comparisons ESS'!D83:D85)","v":0},{"$f":"SUM('Scheme comparisons ESS'!E83:E85)","v":0},{"$f":"SUM('Scheme comparisons ESS'!F83:F85)","v":0},{"$f":"SUM('Scheme comparisons ESS'!G83:G85)","v":0}]
[null,null,"='[SuDS Tool Comparison NEW.xlsm]Scheme comparisons ESS'!$I$51",{"$f":"IF(D3,1,\"\")&IF(E3,2,\"\")&IF(F3,3,\"\")&IF(G3,4,\"\")","v":"1"},{"$f":"IF(F10=0,1,F10)","v":1},{"$f":"LEN(D10)","v":1},"control data"]
[null,null,"Total",1,2,3,4]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngTitles","Option",{"$f":"IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,D$11,1)),1,1))","v":"Insert ref"},{"$f":"IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,E$11,1)),1,1))","v":""},{"$f":"IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,F$11,1)),1,1))","v":""},{"$f":"IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,G$11,1)),1,1))","v":""}]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngProvServ",{"$f":"B6","v":"Provisioning services"},{"$f":"IF(IF(D$11>$E$10,\"\",OFFSET($C6,0,(MID($D$10,D$11,1)),1,1))=0,NA(),IF(D$11>$E$10,\"\",OFFSET($C6,0,(MID($D$10,D$11,1)),1,1)))","v":{"$error":"#N/A"}},{"$f":"IF(IF(E$11>$E$10,\"\",OFFSET($C6,0,(MID($D$10,E$11,1)),1,1))=0,NA(),IF(E$11>$E$10,\"\",OFFSET($C6,0,(MID($D$10,E$11,1)),1,1)))","v":""},"",""]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngReguServ",{"$f":"B7","v":"Regulating services"},{"$error":"#N/A"},"","",""]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngCultServ",{"$f":"B8","v":"Cultural services"},{"$error":"#N/A"},"","",""]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngSuppServ",{"$f":"B9","v":"Supporting services"},{"$error":"#N/A"},{"$f":"IF(IF(E$11>$E$10,\"\",OFFSET($C9,0,(MID($D$10,E$11,1)),1,1))=0,NA(),IF(E$11>$E$10,\"\",OFFSET($C9,0,(MID($D$10,E$11,1)),1,1)))","v":""},"",""]
[]
[null,null,"Present value comparison of each scheme by types of ESS"]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngSchTitles","Option",{"$f":"IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,D$11,1)),1,1))","v":"Insert ref"},{"$f":"IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,E$11,1)),1,1))","v":""},{"$f":"IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,F$11,1)),1,1))","v":""},{"$f":"IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C9,0,(MID($D$10,G$11,1)),1,1))","v":""}]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngSchPreCost","Scheme present cost",{"$f":"IF(IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,D$11,1)),1,1))=0,NA(),IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,D$11,1)),1,1)))","v":{"$error":"#N/A"}},{"$f":"IF(IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,E$11,1)),1,1))=0,NA(),IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,E$11,1)),1,1)))","v":""},{"$f":"IF(IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,F$11,1)),1,1))=0,NA(),IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,F$11,1)),1,1)))","v":""},{"$f":"IF(IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,G$11,1)),1,1))=0,NA(),IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C11,0,(MID($D$10,G$11,1)),1,1)))","v":""}]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngSchTotPVImpact","Scheme total present value of Impact",{"$f":"IF(IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,D$11,1)),1,1))=0,NA(),IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,D$11,1)),1,1)))","v":{"$error":"#N/A"}},{"$f":"IF(IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,E$11,1)),1,1))=0,NA(),IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,E$11,1)),1,1)))","v":""},{"$f":"IF(IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,F$11,1)),1,1))=0,NA(),IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,F$11,1)),1,1)))","v":""},{"$f":"IF(IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,G$11,1)),1,1))=0,NA(),IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C12,0,(MID($D$10,G$11,1)),1,1)))","v":""}]
[null,"'SuDS Tool Comparison NEW.xlsm'!vRngSchNPV","Overall scheme net present value",{"$f":"IF(IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,D$11,1)),1,1))=0,NA(),IF(D$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,D$11,1)),1,1)))","v":{"$error":"#N/A"}},{"$f":"IF(IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,E$11,1)),1,1))=0,NA(),IF(E$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,E$11,1)),1,1)))","v":""},{"$f":"IF(IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,F$11,1)),1,1))=0,NA(),IF(F$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,F$11,1)),1,1)))","v":""},{"$f":"IF(IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,G$11,1)),1,1))=0,NA(),IF(G$11>$E$10,\"\",OFFSET('Scheme comparisons ESS'!$C13,0,(MID($D$10,G$11,1)),1,1)))","v":""}]
[]
[]
[]
[]
[]
[null,null,"TBL",{"$f":"incTBLOp1=\"YES\"","v":{"$error":"#REF!"}},{"$f":"incTBLOp2=\"YES\"","v":{"$error":"#REF!"}},{"$f":"incTBLOp3=\"YES\"","v":{"$error":"#REF!"}},{"$f":"incTBLOp4=\"YES\"","v":{"$error":"#REF!"}}]
[]
[null,"Total"]
[null,{"$f":"C38","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"C39","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"C40","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[]
[null,null,null,{"$f":"IF(D28,1,\"\")&IF(E28,2,\"\")&IF(F28,3,\"\")&IF(G28,4,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F35=0,1,F35)","v":{"$error":"#REF!"}},{"$f":"LEN(D35)","v":{"$error":"#REF!"}},"control data"]
[null,null,null,1,2,3,4]
["vRngTBLTitles","'SuDS Tool Comparison NEW.xlsm'!vRngTBLTitles","Option",{"$f":"IF(D$36>$E$35,\"\",OFFSET(#REF!,0,(MID($D$35,D$36,1)),1,1))","v":{"$error":"#REF!"}},{"$f":"IF(E$36>$E$35,\"\",OFFSET(#REF!,0,(MID($D$35,E$36,1)),1,1))","v":{"$error":"#REF!"}},{"$f":"IF(F$36>$E$35,\"\",OFFSET(#REF!,0,(MID($D$35,F$36,1)),1,1))","v":{"$error":"#REF!"}},{"$f":"IF(G$36>$E$35,\"\",OFFSET(#REF!,0,(MID($D$35,G$36,1)),1,1))","v":{"$error":"#REF!"}}]
["vRngTBLProvServ","'SuDS Tool Comparison NEW.xlsm'!vRngTBLProvServ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(IF(D$36>$E$35,\"\",OFFSET($C31,0,(MID($D$35,D$36,1)),1,1))=0,NA(),IF(D$36>$E$35,\"\",OFFSET($C31,0,(MID($D$35,D$36,1)),1,1)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(IF(F$36>$E$35,\"\",OFFSET($C31,0,(MID($D$35,F$36,1)),1,1))=0,NA(),IF(F$36>$E$35,\"\",OFFSET($C31,0,(MID($D$35,F$36,1)),1,1)))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["vRngTBLReguServ","'SuDS Tool Comparison NEW.xlsm'!vRngTBLReguServ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["vRngTBLCultServ","'SuDS Tool Comparison NEW.xlsm'!vRngTBLCultServ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Present value comparison of each scheme by TBL categories"]
["vRngTBLSchTitles","'SuDS Tool Comparison NEW.xlsm'!vRngTBLSchTitles","Option",{"$f":"D37","v":{"$error":"#REF!"}},{"$f":"E37","v":{"$error":"#REF!"}},{"$f":"F37","v":{"$error":"#REF!"}},{"$f":"G37","v":{"$error":"#REF!"}}]
["vRngTBLSchPreCost","'SuDS Tool Comparison NEW.xlsm'!vRngTBLSchPreCost","Scheme present cost",{"$f":"IF(IF(D$36>$E$35,\"\",OFFSET($C43,0,(MID($D$35,D$36,1)),1,1))=0,NA(),IF(D$36>$E$35,\"\",OFFSET($C43,0,(MID($D$35,D$36,1)),1,1)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["vRngSchTBLTotPVImpact","'SuDS Tool Comparison NEW.xlsm'!vRngSchTBLTotPVImpact","Scheme total present value of Impact",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["vRngTBLSchNPV","'SuDS Tool Comparison NEW.xlsm'!vRngTBLSchNPV","Overall scheme net present value",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Scenario Comparisons","index":7,"n_rows":54,"n_cols":63,"rows_kept":54,"cut":false,"hidden":true,"merged":[[40,2,40,27],[5,31,6,35],[8,3,8,5],[8,10,8,12],[8,17,8,19],[8,24,8,26]]}
[null,null,null,null,null,null,"Scenario Comparisons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">>HIDE_ALONG"]
[null,null,{"$f":"ProjDetails","v":"(Project Details Incomplete)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4]
[null,null,"Scheme/Option Name:",null,null,"Include in Summary chart at base of page?","YES",null,null,"Scheme/Option Name:",null,null,"Include in Summary chart at base of page?","YES",null,null,"Scheme/Option Name:",null,null,"Include in Summary chart at base of page?","YES",null,null,"Scheme/Option Name:",null,null,"Include in Summary chart at base of page?","YES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERALL COMPARISON GRAPH OF SCENARIOS AND OPTIONS"]
[]
[null,null,null,"Present Value (£)",null,null,null,null,null,null,"Present Value (£)",null,null,null,null,null,null,"Present Value (£)",null,null,null,null,null,null,"Present Value (£)"]
[null,null,null,"Time period",null,null,null,null,null,null,"Time period",null,null,null,null,null,null,"Time period",null,null,null,null,null,null,"Time period",null,null,null,null,null,null,null,"Totals"]
[null,null,"Scenario",null,null,null,"Total",null,null,"Scenario",null,null,null,"Total",null,null,"Scenario",null,null,null,"Total",null,null,"Scenario",null,null,null,"Total",null,null,null,"Scenario     \\       Option:",{"$f":"Opt_A","v":0},{"$f":"Opt_B","v":0},{"$f":"Opt_C","v":0},{"$f":"Opt_D","v":0}]
[null,null,"Post-confidence business as usual",null,null,null,{"$f":"SUM(D11:F11)","v":0},null,null,"Post-confidence business as usual",null,null,null,{"$f":"SUM(K11:M11)","v":0},null,null,"Post-confidence business as usual",null,null,null,{"$f":"SUM(R11:T11)","v":0},null,null,"Post-confidence business as usual",null,null,null,{"$f":"SUM(Y11:AA11)","v":0},null,null,null,"Post-confidence business as usual",{"$f":"G11","v":0},{"$f":"N11","v":0},{"$f":"U11","v":0},{"$f":"AB11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,{"$f":"SUM(D12:F12)","v":0},null,null,"World markets",null,null,null,{"$f":"SUM(K12:M12)","v":0},null,null,"World markets",null,null,null,{"$f":"SUM(R12:T12)","v":0},null,null,"World markets",null,null,null,{"$f":"SUM(Y12:AA12)","v":0},null,null,null,"World markets",{"$f":"G12","v":0},{"$f":"N12","v":0},{"$f":"U12","v":0},{"$f":"AB12","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D13:F13)","v":0},null,null,"National Enterprise",null,null,null,{"$f":"SUM(K13:M13)","v":0},null,null,"National Enterprise",null,null,null,{"$f":"SUM(R13:T13)","v":0},null,null,"National Enterprise",null,null,null,{"$f":"SUM(Y13:AA13)","v":0},null,null,null,"National Enterprise",{"$f":"G13","v":0},{"$f":"N13","v":0},{"$f":"U13","v":0},{"$f":"AB13","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D14:F14)","v":0},null,null,"Global Sustinability",null,null,null,{"$f":"SUM(K14:M14)","v":0},null,null,"Global Sustinability",null,null,null,{"$f":"SUM(R14:T14)","v":0},null,null,"Global Sustinability",null,null,null,{"$f":"SUM(Y14:AA14)","v":0},null,null,null,"Global Sustinability",{"$f":"G14","v":0},{"$f":"N14","v":0},{"$f":"U14","v":0},{"$f":"AB14","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(D15:F15)","v":0},null,null,"Local Stewardship",null,null,null,{"$f":"SUM(K15:M15)","v":0},null,null,"Local Stewardship",null,null,null,{"$f":"SUM(R15:T15)","v":0},null,null,"Local Stewardship",null,null,null,{"$f":"SUM(Y15:AA15)","v":0},null,null,null,"Local Stewardship",{"$f":"G15","v":0},{"$f":"N15","v":0},{"$f":"U15","v":0},{"$f":"AB15","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[]
[]
[]
[]
[]
[null,null,"SUMMARY CHARTS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,">>HIDE_BELOW"]

{"sheet":"Scenario Comparisons Data","index":8,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":true,"merged":[[16,1,20,1],[23,1,27,1],[30,1,34,1],[9,1,13,1]]}
[]
[null,null,null,{"$f":"Use_Opt_A=\"YES\"","v":true},{"$f":"Use_Opt_B=\"YES\"","v":true},{"$f":"Use_Opt_C=\"YES\"","v":true},{"$f":"Use_Opt_D=\"YES\"","v":true},{"$f":"IF(D2,'Scenario Comparisons'!AP4,\"\")&IF(E2,'Scenario Comparisons'!AQ4,\"\")&IF(F2,'Scenario Comparisons'!AR4,\"\")&IF(G2,'Scenario Comparisons'!AS4,\"\")","v":"1234"},{"$f":"MID(UseCols,1,1)","v":"1"},{"$f":"MID(UseCols,2,1)","v":"2"},{"$f":"MID(UseCols,3,1)","v":"3"},{"$f":"MID(UseCols,4,1)","v":"4"}]
[]
[null,null,null,null,null,null,null,{"$f":"LEN(UseCols)","v":4}]
[]
[null,null,null,null,null,null,null,null,0,1,2,3]
[null,null,null,null,null,null,null,null,"TimeT_Op1","TimeT_Op2","TimeT_Op3","TimeT_Op4"]
[null,null,null,"Total Benefits Values",null,null,null,null,{"$f":"IF(QChosen>I$6,\"Total Benefits Values\",\"-\")","v":"Total Benefits Values"},{"$f":"IF(QChosen>J$6,\"Total Benefits Values\",\"-\")","v":"Total Benefits Values"},{"$f":"IF(QChosen>K$6,\"Total Benefits Values\",\"-\")","v":"Total Benefits Values"},{"$f":"IF(QChosen>L$6,\"Total Benefits Values\",\"-\")","v":"Total Benefits Values"}]
[null,null,null,{"$f":"Opt_A","v":0},{"$f":"Opt_B","v":0},{"$f":"Opt_C","v":0},{"$f":"Opt_D","v":0},"TimeT_T",{"$f":"IF(QChosen>I$6,IF(I$2=\"\",0,OFFSET($C9,0,I$2,1,1)),\"  -\")","v":0},{"$f":"IF(QChosen>J$6,IF(J$2=\"\",0,OFFSET($C9,0,J$2,1,1)),\"  -\")","v":0},{"$f":"IF(QChosen>K$6,IF(K$2=\"\",0,OFFSET($C9,0,K$2,1,1)),\"  -\")","v":0},{"$f":"IF(QChosen>L$6,IF(L$2=\"\",0,OFFSET($C9,0,L$2,1,1)),\"  -\")","v":0}]
[null,"Scenario","Post-confidence business as usual",{"$f":"'Scenario Comparisons'!G11","v":0},{"$f":"'Scenario Comparisons'!N11","v":0},{"$f":"'Scenario Comparisons'!U11","v":0},{"$f":"'Scenario Comparisons'!AB11","v":0},"TimeT_1",{"$f":"IF(I$2=\"\",0,OFFSET($C10,0,I$2,1,1))","v":0},0,0,0]
[null,null,"World markets",{"$f":"'Scenario Comparisons'!G12","v":0},{"$f":"'Scenario Comparisons'!N12","v":0},{"$f":"'Scenario Comparisons'!U12","v":0},{"$f":"'Scenario Comparisons'!AB12","v":0},"TimeT_2",0,0,0,0]
[null,null,"National Enterprise",{"$f":"'Scenario Comparisons'!G13","v":0},{"$f":"'Scenario Comparisons'!N13","v":0},{"$f":"'Scenario Comparisons'!U13","v":0},{"$f":"'Scenario Comparisons'!AB13","v":0},"TimeT_3",0,0,0,0]
[null,null,"Global Sustinability",{"$f":"'Scenario Comparisons'!G14","v":0},{"$f":"'Scenario Comparisons'!N14","v":0},{"$f":"'Scenario Comparisons'!U14","v":0},{"$f":"'Scenario Comparisons'!AB14","v":0},"TimeT_4",0,0,0,0]
[null,null,"Local Stewardship",{"$f":"'Scenario Comparisons'!G15","v":0},{"$f":"'Scenario Comparisons'!N15","v":0},{"$f":"'Scenario Comparisons'!U15","v":0},{"$f":"'Scenario Comparisons'!AB15","v":0},"TimeT_5",0,0,0,0]
[]
[null,null,null," Benefits Values for time period",null,{"$f":"\"Period: \" &TimeP1","v":"Period: "},null,null,"TimeP1_Op1","TimeP1_Op2","TimeP1_Op3","TimeP1_Op4"]
[null,{"$f":"\"Benefits for: \"&TimeP1","v":"Benefits for: "},"Post-confidence business as usual",{"$f":"'Scenario Comparisons'!D11","v":0},{"$f":"'Scenario Comparisons'!K11","v":0},{"$f":"'Scenario Comparisons'!R11","v":0},{"$f":"'Scenario Comparisons'!Y11","v":0},"TimeP1_1",{"$f":"IF(I$2=\"\",\"\",OFFSET($C17,0,I$2,1,1))","v":0},0,0,0]
[null,null,"World markets",{"$f":"'Scenario Comparisons'!D12","v":0},{"$f":"'Scenario Comparisons'!K12","v":0},{"$f":"'Scenario Comparisons'!R12","v":0},{"$f":"'Scenario Comparisons'!Y12","v":0},"TimeP1_2",0,0,0,0]
[null,null,"National Enterprise",{"$f":"'Scenario Comparisons'!D13","v":0},{"$f":"'Scenario Comparisons'!K13","v":0},{"$f":"'Scenario Comparisons'!R13","v":0},{"$f":"'Scenario Comparisons'!Y13","v":0},"TimeP1_3",0,0,0,0]
[null,null,"Global Sustinability",{"$f":"'Scenario Comparisons'!D14","v":0},{"$f":"'Scenario Comparisons'!K14","v":0},{"$f":"'Scenario Comparisons'!R14","v":0},{"$f":"'Scenario Comparisons'!Y14","v":0},"TimeP1_4",0,0,0,0]
[null,null,"Local Stewardship",{"$f":"'Scenario Comparisons'!D15","v":0},{"$f":"'Scenario Comparisons'!K15","v":0},{"$f":"'Scenario Comparisons'!R15","v":0},{"$f":"'Scenario Comparisons'!Y15","v":0},"TimeP1_5",0,0,0,0]
[]
[null,null,null," Benefits Values for time period",null,{"$f":"\"Period: \" &TimeP2","v":"Period: "},null,null,"TimeP2_Op1","TimeP2_Op2","TimeP2_Op3","TimeP2_Op4"]
[null,{"$f":"\"Benefits for: \"&TimeP2","v":"Benefits for: "},"Post-confidence business as usual",{"$f":"'Scenario Comparisons'!E11","v":0},{"$f":"'Scenario Comparisons'!L11","v":0},{"$f":"'Scenario Comparisons'!S11","v":0},{"$f":"'Scenario Comparisons'!Z11","v":0},"TimeP2_1",{"$f":"IF(I$2=\"\",\"\",OFFSET($C24,0,I$2,1,1))","v":0},0,0,0]
[null,null,"World markets",{"$f":"'Scenario Comparisons'!E12","v":0},{"$f":"'Scenario Comparisons'!L12","v":0},{"$f":"'Scenario Comparisons'!S12","v":0},{"$f":"'Scenario Comparisons'!Z12","v":0},"TimeP2_2",0,0,0,0]
[null,null,"National Enterprise",{"$f":"'Scenario Comparisons'!E13","v":0},{"$f":"'Scenario Comparisons'!L13","v":0},{"$f":"'Scenario Comparisons'!S13","v":0},{"$f":"'Scenario Comparisons'!Z13","v":0},"TimeP2_3",0,0,0,0]
[null,null,"Global Sustinability",{"$f":"'Scenario Comparisons'!E14","v":0},{"$f":"'Scenario Comparisons'!L14","v":0},{"$f":"'Scenario Comparisons'!S14","v":0},{"$f":"'Scenario Comparisons'!Z14","v":0},"TimeP2_4",0,0,0,0]
[null,null,"Local Stewardship",{"$f":"'Scenario Comparisons'!E15","v":0},{"$f":"'Scenario Comparisons'!L15","v":0},{"$f":"'Scenario Comparisons'!S15","v":0},{"$f":"'Scenario Comparisons'!Z15","v":0},"TimeP2_5",0,0,0,0]
[]
[null,null,null," Benefits Values for time period",null,{"$f":"\"Period: \" &TimeP3","v":"Period: "},null,null,"TimeP3_Op1","TimeP3_Op2","TimeP3_Op3","TimeP3_Op4"]
[null,{"$f":"\"Benefits for: \"&TimeP3","v":"Benefits for: "},"Post-confidence business as usual",{"$f":"'Scenario Comparisons'!F11","v":0},{"$f":"'Scenario Comparisons'!M11","v":0},{"$f":"'Scenario Comparisons'!T11","v":0},{"$f":"'Scenario Comparisons'!AA11","v":0},"TimeP3_1",{"$f":"IF(I$2=\"\",\"\",OFFSET($C31,0,I$2,1,1))","v":0},0,0,0]
[null,null,"World markets",{"$f":"'Scenario Comparisons'!F12","v":0},{"$f":"'Scenario Comparisons'!M12","v":0},{"$f":"'Scenario Comparisons'!T12","v":0},{"$f":"'Scenario Comparisons'!AA12","v":0},"TimeP3_2",0,0,0,0]
[null,null,"National Enterprise",{"$f":"'Scenario Comparisons'!F13","v":0},{"$f":"'Scenario Comparisons'!M13","v":0},{"$f":"'Scenario Comparisons'!T13","v":0},{"$f":"'Scenario Comparisons'!AA13","v":0},"TimeP3_3",0,0,0,0]
[null,null,"Global Sustinability",{"$f":"'Scenario Comparisons'!F14","v":0},{"$f":"'Scenario Comparisons'!M14","v":0},{"$f":"'Scenario Comparisons'!T14","v":0},{"$f":"'Scenario Comparisons'!AA14","v":0},"TimeP3_4",0,0,0,0]
[null,null,"Local Stewardship",{"$f":"'Scenario Comparisons'!F15","v":0},{"$f":"'Scenario Comparisons'!M15","v":0},{"$f":"'Scenario Comparisons'!T15","v":0},{"$f":"'Scenario Comparisons'!AA15","v":0},"TimeP3_5",0,0,0,0]