{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Introduction","Identify potential options","Option feasibility assessment","Multi-criteria assessment","Targeted indicators","MCA criteria weighting","Scoring","MCA indicator weighting","Results","Analysis","Sensitivity","Sensitivity Calc","General Calc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":7,"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":"Introduction","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,1,7,10],[2,1,4,8],[1,1,1,8]]}
[]
[null,"State guideline: Flood evacuation route improvements - Supporting tool"]
[null,"This tool supports Stage one: option feasibility assessment and Stage two: multi-criteria assessment of the State guideline: Flood evacuation route improvements (the guideline). The tool is not intended to be used independently to assess flood evacuation route improvements and is to be used in conjunction with the assessment process in the guideline. \n\nDisclaimer\nThis Support Tool is provided to assist users in undertaking the options assessment process outlined in the State guideline: Flood evacuation route improvements (guideline).  The guideline is intended to support users in identifying ‘fair and reasonable’ improvements to flood evacuation routes and improving evacuation.  Neither the process nor information in this Support Tool is intended to be exhaustive.  Neither TMR nor QRA make any representations or warranties about the accuracy, reliability, completeness or suitability for any particular purpose of the process or information contained in the guideline or this Support Tool.  Neither TMR nor QRA will be liable for any loss or damage suffered by users, caused by any error, inaccuracy, incompleteness or other similar defect in this Support Tool or in reliance of any of its contents.\n\nUse of this Support Tool or compliance with the guideline is not evidence that TMR or QRA will endorse any development, contribute to any development, commit to its own development or grant, or consider granting, funding in any capacity to any user of this guideline or other entity.\n"]
[]
[]
[]
[]
[null,"\nThis Smarter Solutions Multi-Criteria Assessment (MCA) Tool provides a clear line-of-sight across the Department of Transport and Main Roads' (TMR) infrastructure planning and investment process, providing assurance that the Network Optimisation Framework is embedded in our decision-making.\n\nThe MCA Tool has been designed for use in selecting a preferred option, or ranking alternate options, where network optimisation solutions (NOS) are included within assessment processes. The MCA Tool applies a standardised consideration of NOS relative to large capital infrastructure, ensuring TMR is delivering the right infrastructure at the right time and aligning with government policy direction for investment as outlined in the Queensland Government's State Infrastructure Plan.\n"]

{"sheet":"Identify potential options","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,2,2],[1,1,1,2]]}
[]
[null,"Identify potential options"]
[null,"Enter the long list of potential options for assessment in the table below. "]
[]
[]
[null,null,"Name"]
[null,"Option 1"]
[null,"Option 2"]
[null,"Option 3"]
[null,"Option 4"]
[null,"Option 5"]
[null,"Option 6"]
[null,"Option 7"]
[null,"Option 8"]
[null,"Option 9"]
[null,"Option 10"]
[null,"Option 11"]
[null,"Option 12"]
[null,"Option 13"]
[null,"Option 14"]
[null,"Option 15"]
[null,"Option 16"]
[null,"Option 17"]
[null,"Option 18"]
[null,"Option 19"]
[null,"Option 20"]

{"sheet":"Option feasibility assessment","index":2,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,8,5,8],[4,9,5,9],[4,1,5,1],[1,1,1,5],[4,7,5,7],[4,2,4,6]]}
[]
[null,"Stage one: option feasibility assessment\nFor each option select the response to the feasibility indicators and the high level cost estimate, before selecting the outcome. \n\nWhere 'Redefine option' is selected as the outcome, return to the Identify Potential Options worksheet to redefine the option. Following re-assessment complete this worksheet for the redefined option. \n\nWhere 'Collect further information required' is selected as the outcome, collect further information to re-assess the option. Following this, complete this worksheet with the additional information. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes/No","Lookup","Unique Category","Category Lookup"]
[null,"Options","Feasibility Indicators",null,null,null,null,"High level cost estimate","Outcome","Action"]
[null,null,"The option is likely to reduce risk to life for the affected population","The option is unlikely to cause significant environmental or cultural heritage impacts that are unable to be mitigated","The community supports the option and is likely to respond","The option is unlikely to cause adverse significant flood impacts that cannot be mitigated ","The option is physically and technically feasible when considering engineering, constructability or legal constraints",null,null,null,null,"Scoring","Indicator met","More information","Indicator not met",null,null,null,null,null,{"$f":"SUM(V7:V37)","v":0}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B7))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B7))))","v":""},"Select","Select","Select","Select","Select","Select","Select",{"$f":"IF(I7=\"Redefine option\",\"Return to identify potential options and redefine option before re-assessing\",IF(I7=\"Collect further information\",\"Collect additional information, re-assess\",IF(I7=\"Progress to MCA\",\"Shortlist for stage two: MCA\",IF(I7=\"Eliminate option\",\"Eliminate, proposed option is not feasible\",\"\"))))","v":""},null,null,{"$f":"COUNTIF($C7:$H7,$M$6)/COUNTA($C$6:$H$6)","v":0},{"$f":"COUNTIF($C7:$H7,$N$6)/COUNTA($C$6:$H$6)","v":0},{"$f":"COUNTIF($C7:$H7,$O$6)/COUNTA($C$6:$H$6)","v":0},null,null,null,{"$f":"IF(I7=\"Progress to MCA\",1,0)","v":0},{"$f":"IF(S7=1,SUM($S$7:S7),\"\")","v":""},{"$f":"IF(AND(T7=1,COUNTIFS($B$7:$B7,B7,$T$7:$T7,1)=1),1,0)","v":0},{"$f":"IF(U7=1,SUM($U7:U$7),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B8))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B8))))","v":""},"Select","Select","Select","Select","Select","Select","Select",{"$f":"IF(I8=\"Redefine option\",\"Return to identify potential options and redefine option before re-assessing\",IF(I8=\"Collect further information\",\"Collect additional information, re-assess\",IF(I8=\"Progress to MCA\",\"Shortlist for stage two: MCA\",IF(I8=\"Eliminate option\",\"Eliminate, proposed option is not feasible\",\"\"))))","v":""},null,null,0,0,0,null,null,null,0,{"$f":"IF(S8=1,SUM($S$7:S8),\"\")","v":""},{"$f":"IF(AND(T8=1,COUNTIFS($B$7:$B8,B8,$T$7:$T8,1)=1),1,0)","v":0},{"$f":"IF(U8=1,SUM($U$7:U8),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B9))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B9))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S9=1,SUM($S$7:S9),\"\")","v":""},{"$f":"IF(AND(T9=1,COUNTIFS($B$7:$B9,B9,$T$7:$T9,1)=1),1,0)","v":0},{"$f":"IF(U9=1,SUM($U$7:U9),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B10))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B10))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S10=1,SUM($S$7:S10),\"\")","v":""},{"$f":"IF(AND(T10=1,COUNTIFS($B$7:$B10,B10,$T$7:$T10,1)=1),1,0)","v":0},{"$f":"IF(U10=1,SUM($U$7:U10),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B11))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B11))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S11=1,SUM($S$7:S11),\"\")","v":""},{"$f":"IF(AND(T11=1,COUNTIFS($B$7:$B11,B11,$T$7:$T11,1)=1),1,0)","v":0},{"$f":"IF(U11=1,SUM($U$7:U11),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B12))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B12))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S12=1,SUM($S$7:S12),\"\")","v":""},{"$f":"IF(AND(T12=1,COUNTIFS($B$7:$B12,B12,$T$7:$T12,1)=1),1,0)","v":0},{"$f":"IF(U12=1,SUM($U$7:U12),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B13))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B13))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S13=1,SUM($S$7:S13),\"\")","v":""},{"$f":"IF(AND(T13=1,COUNTIFS($B$7:$B13,B13,$T$7:$T13,1)=1),1,0)","v":0},{"$f":"IF(U13=1,SUM($U$7:U13),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B14))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B14))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S14=1,SUM($S$7:S14),\"\")","v":""},{"$f":"IF(AND(T14=1,COUNTIFS($B$7:$B14,B14,$T$7:$T14,1)=1),1,0)","v":0},{"$f":"IF(U14=1,SUM($U$7:U14),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B15))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B15))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S15=1,SUM($S$7:S15),\"\")","v":""},{"$f":"IF(AND(T15=1,COUNTIFS($B$7:$B15,B15,$T$7:$T15,1)=1),1,0)","v":0},{"$f":"IF(U15=1,SUM($U$7:U15),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B16))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B16))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S16=1,SUM($S$7:S16),\"\")","v":""},{"$f":"IF(AND(T16=1,COUNTIFS($B$7:$B16,B16,$T$7:$T16,1)=1),1,0)","v":0},{"$f":"IF(U16=1,SUM($U$7:U16),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B17))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B17))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,{"$f":"IF(I17=\"Progress to MCA\",1,0)","v":0},{"$f":"IF(S17=1,SUM($S$7:S17),\"\")","v":""},{"$f":"IF(AND(T17=1,COUNTIFS($B$7:$B17,B17,$T$7:$T17,1)=1),1,0)","v":0},{"$f":"IF(U17=1,SUM($U$7:U17),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B18))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B18))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S18=1,SUM($S$7:S18),\"\")","v":""},{"$f":"IF(AND(T18=1,COUNTIFS($B$7:$B18,B18,$T$7:$T18,1)=1),1,0)","v":0},{"$f":"IF(U18=1,SUM($U$7:U18),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B19))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B19))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S19=1,SUM($S$7:S19),\"\")","v":""},{"$f":"IF(AND(T19=1,COUNTIFS($B$7:$B19,B19,$T$7:$T19,1)=1),1,0)","v":0},{"$f":"IF(U19=1,SUM($U$7:U19),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B20))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B20))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S20=1,SUM($S$7:S20),\"\")","v":""},{"$f":"IF(AND(T20=1,COUNTIFS($B$7:$B20,B20,$T$7:$T20,1)=1),1,0)","v":0},{"$f":"IF(U20=1,SUM($U$7:U20),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B21))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B21))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S21=1,SUM($S$7:S21),\"\")","v":""},{"$f":"IF(AND(T21=1,COUNTIFS($B$7:$B21,B21,$T$7:$T21,1)=1),1,0)","v":0},{"$f":"IF(U21=1,SUM($U$7:U21),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B22))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B22))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S22=1,SUM($S$7:S22),\"\")","v":""},{"$f":"IF(AND(T22=1,COUNTIFS($B$7:$B22,B22,$T$7:$T22,1)=1),1,0)","v":0},{"$f":"IF(U22=1,SUM($U$7:U22),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B23))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B23))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S23=1,SUM($S$7:S23),\"\")","v":""},{"$f":"IF(AND(T23=1,COUNTIFS($B$7:$B23,B23,$T$7:$T23,1)=1),1,0)","v":0},{"$f":"IF(U23=1,SUM($U$7:U23),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B24))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B24))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S24=1,SUM($S$7:S24),\"\")","v":""},{"$f":"IF(AND(T24=1,COUNTIFS($B$7:$B24,B24,$T$7:$T24,1)=1),1,0)","v":0},{"$f":"IF(U24=1,SUM($U$7:U24),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B25))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B25))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S25=1,SUM($S$7:S25),\"\")","v":""},{"$f":"IF(AND(T25=1,COUNTIFS($B$7:$B25,B25,$T$7:$T25,1)=1),1,0)","v":0},{"$f":"IF(U25=1,SUM($U$7:U25),\"\")","v":""}]
[null,{"$f":"IF(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B26))=0,\"\",(INDEX('Identify potential options'!$C$7:$C$26,ROWS($B$7:$B26))))","v":""},"Select","Select","Select","Select","Select","Select","Select","",null,null,0,0,0,null,null,null,0,{"$f":"IF(S26=1,SUM($S$7:S26),\"\")","v":""},{"$f":"IF(AND(T26=1,COUNTIFS($B$7:$B26,B26,$T$7:$T26,1)=1),1,0)","v":0},{"$f":"IF(U26=1,SUM($U$7:U26),\"\")","v":""}]

{"sheet":"Multi-criteria assessment","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,3,1,5]]}
[]
[null,null,null,"Stage two: multi-criteria assessment\nShort listed options for assessment in the stage two: multi-criteria assessment are shown in the table below. "]
[]
[]
[]
[{"$f":"MAX('Option feasibility assessment'!$T:$T)","v":0},null,null,null,"Name"]
[{"$f":"IF(ROWS($A$6:$A6)>$A$6,\"\",ROWS($A$6:$A6))","v":""},{"$f":"IF(A7=\"\",\"\",MATCH(A7,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B7=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B7)=0,\"\",INDEX('Identify potential options'!$B:$B,$B7)))","v":""},{"$f":"IF($B7=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B7)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B7)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A7)>$A$6,\"\",ROWS($A$6:$A7))","v":""},{"$f":"IF(A8=\"\",\"\",MATCH(A8,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C7)>$C$7,\"\",ROWS($C$7:$C7))","v":""},{"$f":"IF($B8=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B8)=0,\"\",INDEX('Identify potential options'!$B:$B,$B8)))","v":""},{"$f":"IF($B8=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B8)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B8)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A8)>$A$6,\"\",ROWS($A$6:$A8))","v":""},{"$f":"IF(A9=\"\",\"\",MATCH(A9,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C8)>$C$7,\"\",ROWS($C$7:$C8))","v":""},{"$f":"IF($B9=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B9)=0,\"\",INDEX('Identify potential options'!$B:$B,$B9)))","v":""},{"$f":"IF($B9=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B9)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B9)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A9)>$A$6,\"\",ROWS($A$6:$A9))","v":""},{"$f":"IF(A10=\"\",\"\",MATCH(A10,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C9)>$C$7,\"\",ROWS($C$7:$C9))","v":""},{"$f":"IF($B10=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B10)=0,\"\",INDEX('Identify potential options'!$B:$B,$B10)))","v":""},{"$f":"IF($B10=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B10)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B10)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A10)>$A$6,\"\",ROWS($A$6:$A10))","v":""},{"$f":"IF(A11=\"\",\"\",MATCH(A11,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C10)>$C$7,\"\",ROWS($C$7:$C10))","v":""},{"$f":"IF($B11=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B11)=0,\"\",INDEX('Identify potential options'!$B:$B,$B11)))","v":""},{"$f":"IF($B11=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B11)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B11)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A11)>$A$6,\"\",ROWS($A$6:$A11))","v":""},{"$f":"IF(A12=\"\",\"\",MATCH(A12,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C11)>$C$7,\"\",ROWS($C$7:$C11))","v":""},{"$f":"IF($B12=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B12)=0,\"\",INDEX('Identify potential options'!$B:$B,$B12)))","v":""},{"$f":"IF($B12=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B12)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B12)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A12)>$A$6,\"\",ROWS($A$6:$A12))","v":""},{"$f":"IF(A13=\"\",\"\",MATCH(A13,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C12)>$C$7,\"\",ROWS($C$7:$C12))","v":""},{"$f":"IF($B13=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B13)=0,\"\",INDEX('Identify potential options'!$B:$B,$B13)))","v":""},{"$f":"IF($B13=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B13)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B13)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A13)>$A$6,\"\",ROWS($A$6:$A13))","v":""},{"$f":"IF(A14=\"\",\"\",MATCH(A14,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C13)>$C$7,\"\",ROWS($C$7:$C13))","v":""},{"$f":"IF($B14=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B14)=0,\"\",INDEX('Identify potential options'!$B:$B,$B14)))","v":""},{"$f":"IF($B14=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B14)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B14)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A14)>$A$6,\"\",ROWS($A$6:$A14))","v":""},{"$f":"IF(A15=\"\",\"\",MATCH(A15,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C14)>$C$7,\"\",ROWS($C$7:$C14))","v":""},{"$f":"IF($B15=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B15)=0,\"\",INDEX('Identify potential options'!$B:$B,$B15)))","v":""},{"$f":"IF($B15=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B15)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B15)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A15)>$A$6,\"\",ROWS($A$6:$A15))","v":""},{"$f":"IF(A16=\"\",\"\",MATCH(A16,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C15)>$C$7,\"\",ROWS($C$7:$C15))","v":""},{"$f":"IF($B16=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B16)=0,\"\",INDEX('Identify potential options'!$B:$B,$B16)))","v":""},{"$f":"IF($B16=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B16)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B16)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A16)>$A$6,\"\",ROWS($A$6:$A16))","v":""},{"$f":"IF(A17=\"\",\"\",MATCH(A17,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C16)>$C$7,\"\",ROWS($C$7:$C16))","v":""},{"$f":"IF($B17=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B17)=0,\"\",INDEX('Identify potential options'!$B:$B,$B17)))","v":""},{"$f":"IF($B17=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B17)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B17)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A17)>$A$6,\"\",ROWS($A$6:$A17))","v":""},{"$f":"IF(A18=\"\",\"\",MATCH(A18,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C17)>$C$7,\"\",ROWS($C$7:$C17))","v":""},{"$f":"IF($B18=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B18)=0,\"\",INDEX('Identify potential options'!$B:$B,$B18)))","v":""},{"$f":"IF($B18=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B18)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B18)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A18)>$A$6,\"\",ROWS($A$6:$A18))","v":""},{"$f":"IF(A19=\"\",\"\",MATCH(A19,'Option feasibility assessment'!$T:$T,0))","v":""},{"$f":"IF(ROWS($C$7:$C18)>$C$7,\"\",ROWS($C$7:$C18))","v":""},{"$f":"IF($B19=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B19)=0,\"\",INDEX('Identify potential options'!$B:$B,$B19)))","v":""},{"$f":"IF($B19=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B19)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B19)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A19)>$A$6,\"\",ROWS($A$6:$A19))","v":""},{"$f":"IF(A20=\"\",\"\",MATCH(A20,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B20=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B20)=0,\"\",INDEX('Identify potential options'!$B:$B,$B20)))","v":""},{"$f":"IF($B20=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B20)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B20)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A20)>$A$6,\"\",ROWS($A$6:$A20))","v":""},{"$f":"IF(A21=\"\",\"\",MATCH(A21,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B21=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B21)=0,\"\",INDEX('Identify potential options'!$B:$B,$B21)))","v":""},{"$f":"IF($B21=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B21)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B21)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A21)>$A$6,\"\",ROWS($A$6:$A21))","v":""},{"$f":"IF(A22=\"\",\"\",MATCH(A22,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B22=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B22)=0,\"\",INDEX('Identify potential options'!$B:$B,$B22)))","v":""},{"$f":"IF($B22=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B22)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B22)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A22)>$A$6,\"\",ROWS($A$6:$A22))","v":""},{"$f":"IF(A23=\"\",\"\",MATCH(A23,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B23=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B23)=0,\"\",INDEX('Identify potential options'!$B:$B,$B23)))","v":""},{"$f":"IF($B23=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B23)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B23)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A23)>$A$6,\"\",ROWS($A$6:$A23))","v":""},{"$f":"IF(A24=\"\",\"\",MATCH(A24,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B24=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B24)=0,\"\",INDEX('Identify potential options'!$B:$B,$B24)))","v":""},{"$f":"IF($B24=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B24)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B24)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A24)>$A$6,\"\",ROWS($A$6:$A24))","v":""},{"$f":"IF(A25=\"\",\"\",MATCH(A25,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B25=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B25)=0,\"\",INDEX('Identify potential options'!$B:$B,$B25)))","v":""},{"$f":"IF($B25=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B25)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B25)))","v":""}]
[{"$f":"IF(ROWS($A$6:$A25)>$A$6,\"\",ROWS($A$6:$A25))","v":""},{"$f":"IF(A26=\"\",\"\",MATCH(A26,'Option feasibility assessment'!$T:$T,0))","v":""},null,{"$f":"IF($B26=\"\",\"\",IF(INDEX('Identify potential options'!$B:$B,$B26)=0,\"\",INDEX('Identify potential options'!$B:$B,$B26)))","v":""},{"$f":"IF($B26=\"\",\"\",IF(INDEX('Option feasibility assessment'!$B:$B,$B26)=0,\"\",INDEX('Option feasibility assessment'!$B:$B,$B26)))","v":""}]

{"sheet":"Targeted indicators","index":4,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,5,5,9],[1,1,1,5],[5,1,7,1],[5,2,7,2],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9]]}
[]
[null,"Targeted indicators\nShort-listed options will be assessed against the targeted indicators for each criteria shown in the table below. \n\nWhere a targeted indicator is not applicable for all options under assessment, ensure the assigned scores for the indicator are the same for all options. For example, if all options being assessed are non-infrastructure options. Assign a score of five to all options for the targeted indicator under flood behaviour/impacts criterion. \n\n"]
[]
[]
[]
[null,"Criteria","Targeted indicator","Use?","Measure","Scoring descriptors"]
[null,null,null,null,null,"1 (lowest)",2,3,4,"5 (highest)",null,"Yes/No","Lookup","Unique Category","Category Lookup",null,"Unique Indicator","Indicator Lookup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N9:N20)","v":6},null,null,{"$f":"SUM(Q9:Q20)","v":12}]
[null,"Safety","Ability to evacuate to safer locations or evacuation centres","Yes","Descriptive","Insufficient ability to evacuate  ","Some ability to evacuate","Sufficient ability to evacuate","Substantial ability to evacuate","Very substantial ability to evacuate ",null,{"$f":"IF(D9=\"Yes\",1,0)","v":1},{"$f":"IF(L9=1,SUM($L$9:L9),\"\")","v":1},{"$f":"IF(AND(L9=1,COUNTIFS($B$9:$B9,B9,$L$9:$L9,1)=1),1,0)","v":1},{"$f":"IF(N9=1,SUM($N$9:N9),\"\")","v":1},null,{"$f":"IF(AND(L9=1,COUNTIFS($C$9:$C9,C9,$L$9:$L9,1)=1),1,0)","v":1},{"$f":"IF(Q9=1,SUM($Q$9:Q9),\"\")","v":1}]
[null,"Safety","Population at risk","Yes","Descriptive","Extreme risk","High risk ","Medium risk","Low risk","Very low risk",null,1,{"$f":"IF(L10=1,SUM($L$9:L10),\"\")","v":2},{"$f":"IF(AND(L10=1,COUNTIFS($B$9:$B10,B10,$L$9:$L10,1)=1),1,0)","v":0},{"$f":"IF(N10=1,SUM($N$9:N10),\"\")","v":""},null,{"$f":"IF(AND(L10=1,COUNTIFS($C$9:$C10,C10,$L$9:$L10,1)=1),1,0)","v":1},{"$f":"IF(Q10=1,SUM($Q$9:Q10),\"\")","v":2}]
[null,"Safety","Isolation duration and risk","Yes","Descriptive","Extreme risk to life due to isolation","High risk to life due to isolation","Medium risk to life due to isolation","Low risk to life due to isolation","Very low risk to life due to isolation",null,1,{"$f":"IF(L11=1,SUM($L$9:L11),\"\")","v":3},{"$f":"IF(AND(L11=1,COUNTIFS($B$9:$B11,B11,$L$9:$L11,1)=1),1,0)","v":0},{"$f":"IF(N11=1,SUM($N$9:N11),\"\")","v":""},null,{"$f":"IF(AND(L11=1,COUNTIFS($C$9:$C11,C11,$L$9:$L11,1)=1),1,0)","v":1},{"$f":"IF(Q11=1,SUM($Q$9:Q11),\"\")","v":3}]
[null,"Economic","Economic growth and investment","Yes","Descriptive","No potential economic growth and investment","Minor potential economic growth and investment","Moderate potential economic growth and investment","Significant potential economic growth and investment","Very significant potential economic growth and investment",null,1,{"$f":"IF(L12=1,SUM($L$9:L12),\"\")","v":4},{"$f":"IF(AND(L12=1,COUNTIFS($B$9:$B12,B12,$L$9:$L12,1)=1),1,0)","v":1},{"$f":"IF(N12=1,SUM($N$9:N12),\"\")","v":2},null,{"$f":"IF(AND(L12=1,COUNTIFS($C$9:$C12,C12,$L$9:$L12,1)=1),1,0)","v":1},{"$f":"IF(Q12=1,SUM($Q$9:Q12),\"\")","v":4}]
[null,"Economic","Damages and costs (property, assets and operations)","Yes","Descriptive","No reduction in flood damages and costs","Minor reduction in flood damages and costs","Moderate reduction in flood damages and costs","Significant reduction in flood damages and costs","Very significant reduction in flood damages and costs",null,1,{"$f":"IF(L13=1,SUM($L$9:L13),\"\")","v":5},{"$f":"IF(AND(L13=1,COUNTIFS($B$9:$B13,B13,$L$9:$L13,1)=1),1,0)","v":0},{"$f":"IF(N13=1,SUM($N$9:N13),\"\")","v":""},null,{"$f":"IF(AND(L13=1,COUNTIFS($C$9:$C13,C13,$L$9:$L13,1)=1),1,0)","v":1},{"$f":"IF(Q13=1,SUM($Q$9:Q13),\"\")","v":5}]
[null,"Environmental and cultural heritage impact","Overall impact on fauna connectivity (fish passage/fauna movement) ","Yes","Descriptive","Significant negative impact to fauna connectivity","Moderate negative impact to fauna connectivity","Minor negative impact to fauna connectivity","Negligble impact to fauna connectivity","Positive impact to fauna connectivity",null,1,{"$f":"IF(L14=1,SUM($L$9:L14),\"\")","v":6},{"$f":"IF(AND(L14=1,COUNTIFS($B$9:$B14,B14,$L$9:$L14,1)=1),1,0)","v":1},{"$f":"IF(N14=1,SUM($N$9:N14),\"\")","v":3},null,{"$f":"IF(AND(L14=1,COUNTIFS($C$9:$C14,C14,$L$9:$L14,1)=1),1,0)","v":1},{"$f":"IF(Q14=1,SUM($Q$9:Q14),\"\")","v":6}]
[null,"Environmental and cultural heritage impact","Overall impacts to vegetation and habitat","Yes","Descriptive","Significant negative vegetation and habitat impacts","Moderate negative vegetation and habitat impacts","Minor negative vegetation and habitat impacts","Negligble vegetation and habitat impacts","Positive vegetation and habitat impacts",null,{"$f":"IF(D15=\"Yes\",1,0)","v":1},{"$f":"IF(L15=1,SUM($L$9:L15),\"\")","v":7},{"$f":"IF(AND(L15=1,COUNTIFS($B$9:$B15,B15,$L$9:$L15,1)=1),1,0)","v":0},{"$f":"IF(N15=1,SUM($N$9:N15),\"\")","v":""},null,{"$f":"IF(AND(L15=1,COUNTIFS($C$9:$C15,C15,$L$9:$L15,1)=1),1,0)","v":1},{"$f":"IF(Q15=1,SUM($Q$9:Q15),\"\")","v":7}]
[null,"Environmental and cultural heritage impact","Impact on cultural heritage sites","Yes","Descriptive","Very significant cultural heritage impacts","Significant cultural heritage impacts","Moderate cultural heritage impacts","Minor cultural heritage impacts","No cultural heritage impacts",null,1,{"$f":"IF(L16=1,SUM($L$9:L16),\"\")","v":8},{"$f":"IF(AND(L16=1,COUNTIFS($B$9:$B16,B16,$L$9:$L16,1)=1),1,0)","v":0},{"$f":"IF(N16=1,SUM($N$9:N16),\"\")","v":""},null,{"$f":"IF(AND(L16=1,COUNTIFS($C$9:$C16,C16,$L$9:$L16,1)=1),1,0)","v":1},{"$f":"IF(Q16=1,SUM($Q$9:Q16),\"\")","v":8}]
[null,"Social","Disruption to daily life","Yes","Descriptive","No improvement in disruption to daily life","Minor improvement in disruption to daily life","Moderate improvement in disruption to daily life","Significant improvement in disruption to daily life","Very significant improvement in disruption to daily life",null,1,{"$f":"IF(L17=1,SUM($L$9:L17),\"\")","v":9},{"$f":"IF(AND(L17=1,COUNTIFS($B$9:$B17,B17,$L$9:$L17,1)=1),1,0)","v":1},{"$f":"IF(N17=1,SUM($N$9:N17),\"\")","v":4},null,{"$f":"IF(AND(L17=1,COUNTIFS($C$9:$C17,C17,$L$9:$L17,1)=1),1,0)","v":1},{"$f":"IF(Q17=1,SUM($Q$9:Q17),\"\")","v":9}]
[null,"Social","Additional community benefits","Yes","Descriptive","No additional community benefits","Minor additional community benefits","Moderate additional community benefits","Significant additional community benefits","Very significant additional community benefits",null,1,{"$f":"IF(L18=1,SUM($L$9:L18),\"\")","v":10},{"$f":"IF(AND(L18=1,COUNTIFS($B$9:$B18,B18,$L$9:$L18,1)=1),1,0)","v":0},{"$f":"IF(N18=1,SUM($N$9:N18),\"\")","v":""},null,{"$f":"IF(AND(L18=1,COUNTIFS($C$9:$C18,C18,$L$9:$L18,1)=1),1,0)","v":1},{"$f":"IF(Q18=1,SUM($Q$9:Q18),\"\")","v":10}]
[null,"Flood behaviour/impact","Flood impacts","Yes","Change in water level","Very significant adverse flood impacts ","Significant adverse flood impacts","Moderate adverse flood impacts ","Minor adverse flood impacts ","Negligible flood impacts",null,1,{"$f":"IF(L19=1,SUM($L$9:L19),\"\")","v":11},{"$f":"IF(AND(L19=1,COUNTIFS($B$9:$B19,B19,$L$9:$L19,1)=1),1,0)","v":1},{"$f":"IF(N19=1,SUM($N$9:N19),\"\")","v":5},null,{"$f":"IF(AND(L19=1,COUNTIFS($C$9:$C19,C19,$L$9:$L19,1)=1),1,0)","v":1},{"$f":"IF(Q19=1,SUM($Q$9:Q19),\"\")","v":11}]
[null,"Additional constraints","Engineering/construction constraints","Yes","Descriptive","Very significant evidence of potential engineering or constructability issues","Significant evidence of potential engineering or constructability issues ","Moderate evidence of potential engineering or constructability issues ","Minor evidence of potential engineering or constructability issues","No evidence of potential engineering or constructability issues",null,1,{"$f":"IF(L20=1,SUM($L$9:L20),\"\")","v":12},{"$f":"IF(AND(L20=1,COUNTIFS($B$9:$B20,B20,$L$9:$L20,1)=1),1,0)","v":1},{"$f":"IF(N20=1,SUM($N$9:N20),\"\")","v":6},null,{"$f":"IF(AND(L20=1,COUNTIFS($C$9:$C20,C20,$L$9:$L20,1)=1),1,0)","v":1},{"$f":"IF(Q20=1,SUM($Q$9:Q20),\"\")","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"MCA criteria weighting","index":5,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,3,1,6]]}
[]
[null,null,null,"Multi-criteria Assessment criteria weighting (pairwise method)\nThis tool applies the pairwise method to determine weightings. To determine criteria weightings, complete the pairwise matrix below. If applying no weighting ensure a nil response is provided in all the input fields.  \n"]
[]
[]
[null,null,null,"  ",null,"Safety","Economic","Environmental and cultural heritage impact","Social","Flood behaviour/impact","Additional constraints","Occurrence +1","WEIGHTING"]
[null,null,null,"  ",null,{"$f":"IF(F5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:F$5)))","v":"A"},{"$f":"IF(G5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:G$5)))","v":"B"},{"$f":"IF(H5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:H$5)))","v":"C"},{"$f":"IF(I5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:I$5)))","v":"D"},{"$f":"IF(J5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:J$5)))","v":"E"},{"$f":"IF(K5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:K$5)))","v":"F"}]
[null,null,null,"Safety",{"$f":"IF(D7=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E7)))","v":"A"},{"$f":"IF($E7=\"\",\"\",$E7)","v":"A"},"-","-","-","-","-",{"$f":"IF($D7=\"\",\"\",COUNTIF($F$7:$K$12,$E7))","v":1},{"$f":"IF($D7=\"\",\"\",L7/$L$13)","v":0.16666666666666666}]
[null,null,null,"Economic",{"$f":"IF(D8=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E8)))","v":"B"},null,{"$f":"IF($E8=\"\",\"\",$E8)","v":"B"},"-","-","-","-",1,0.16666666666666666]
[null,null,null,"Environmental and cultural heritage impact",{"$f":"IF(D9=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E9)))","v":"C"},null,null,{"$f":"IF($E9=\"\",\"\",$E9)","v":"C"},"-","-","-",1,0.16666666666666666]
[null,null,null,"Social",{"$f":"IF(D10=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E10)))","v":"D"},null,null,null,{"$f":"IF($E10=\"\",\"\",$E10)","v":"D"},"-","-",1,0.16666666666666666]
[null,null,null,"Flood behaviour/impact",{"$f":"IF(D11=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E11)))","v":"E"},null,null,null,null,{"$f":"IF($E11=\"\",\"\",$E11)","v":"E"},"-",1,0.16666666666666666]
[null,null,null,"Additional constraints",{"$f":"IF(D12=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E12)))","v":"F"},null,null,null,null,null,{"$f":"IF($E12=\"\",\"\",$E12)","v":"F"},1,0.16666666666666666]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7:L12)","v":6}]
[null,null,null,null,null,{"$f":"C17","v":"Safety"},{"$f":"C18","v":"Safety"},{"$f":"C19","v":"Safety"},{"$f":"C20","v":"Economic"},{"$f":"C21","v":"Economic"},{"$f":"C22","v":"Environmental and cultural heritage impact"}]
[null,null,null,"  ",null,{"$f":"IF(ROWS($D$17:$D17)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D17),'Targeted indicators'!$R:$R,0)))","v":"Ability to evacuate to safer locations or evacuation centres"},{"$f":"IF(ROWS($D$17:$D18)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D18),'Targeted indicators'!$R:$R,0)))","v":"Population at risk"},{"$f":"IF(ROWS($D$17:$D19)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D19),'Targeted indicators'!$R:$R,0)))","v":"Isolation duration and risk"},{"$f":"IF(ROWS($D$17:$D20)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D20),'Targeted indicators'!$R:$R,0)))","v":"Economic growth and investment"},{"$f":"IF(ROWS($D$17:$D21)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D21),'Targeted indicators'!$R:$R,0)))","v":"Damages and costs (property, assets and operations)"},{"$f":"IF(ROWS($D$17:$D22)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D22),'Targeted indicators'!$R:$R,0)))","v":"Overall impact on fauna connectivity (fish passage/fauna movement) "},"Occurrence +1","WEIGHTING"]
[null,null,null,"  ",null,{"$f":"IF(F15=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:F$5)))","v":"A"},{"$f":"IF(G15=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:G$5)))","v":"B"},{"$f":"IF(H15=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:H$5)))","v":"C"},{"$f":"IF(I15=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:I$5)))","v":"D"},{"$f":"IF(J15=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:J$5)))","v":"E"},{"$f":"IF(K15=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:K$5)))","v":"F"}]
[null,null,{"$f":"IF(ROWS($D$17:$D17)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D17),'Targeted indicators'!$R:$R,0)))","v":"Safety"},{"$f":"IF(ROWS($D$17:$D17)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D17),'Targeted indicators'!$R:$R,0)))","v":"Ability to evacuate to safer locations or evacuation centres"},{"$f":"IF(D17=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E17)))","v":"A"},{"$f":"IF($E17=\"\",\"\",$E17)","v":"A"},"A","A","A","A","A",{"$f":"IF(C17=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C17),COUNTA($C$17:C17),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C17),1,10),C17)),E17))","v":3},{"$f":"IF($D17=\"\",\"\",L17/N17)","v":0.5},{"$f":"IF(C17=\"\",\"\",SUMIF(C:C,C17,L:L))","v":6}]
[null,null,{"$f":"IF(ROWS($D$17:$D18)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D18),'Targeted indicators'!$R:$R,0)))","v":"Safety"},{"$f":"IF(ROWS($D$17:$D18)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D18),'Targeted indicators'!$R:$R,0)))","v":"Population at risk"},{"$f":"IF(D18=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E18)))","v":"B"},null,{"$f":"IF($E18=\"\",\"\",$E18)","v":"B"},"B","B","B","B",{"$f":"IF(C18=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C18),COUNTA($C$17:C18),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C18),1,10),C18)),E18))","v":2},{"$f":"IF($D18=\"\",\"\",L18/N18)","v":0.33333333333333331},6]
[null,null,{"$f":"IF(ROWS($D$17:$D19)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D19),'Targeted indicators'!$R:$R,0)))","v":"Safety"},{"$f":"IF(ROWS($D$17:$D19)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D19),'Targeted indicators'!$R:$R,0)))","v":"Isolation duration and risk"},{"$f":"IF(D19=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E19)))","v":"C"},null,null,{"$f":"IF($E19=\"\",\"\",$E19)","v":"C"},"C","C","C",{"$f":"IF(C19=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C19),COUNTA($C$17:C19),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C19),1,10),C19)),E19))","v":1},0.16666666666666666,6]
[null,null,{"$f":"IF(ROWS($D$17:$D20)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D20),'Targeted indicators'!$R:$R,0)))","v":"Economic"},{"$f":"IF(ROWS($D$17:$D20)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D20),'Targeted indicators'!$R:$R,0)))","v":"Economic growth and investment"},{"$f":"IF(D20=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E20)))","v":"D"},null,null,null,{"$f":"IF($E20=\"\",\"\",$E20)","v":"D"},"D","D",{"$f":"IF(C20=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C20),COUNTA($C$17:C20),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C20),1,10),C20)),E20))","v":2},0.66666666666666663,3]
[null,null,{"$f":"IF(ROWS($D$17:$D21)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D21),'Targeted indicators'!$R:$R,0)))","v":"Economic"},{"$f":"IF(ROWS($D$17:$D21)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D21),'Targeted indicators'!$R:$R,0)))","v":"Damages and costs (property, assets and operations)"},{"$f":"IF(D21=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E21)))","v":"E"},null,null,null,null,{"$f":"IF($E21=\"\",\"\",$E21)","v":"E"},"E",{"$f":"IF(C21=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C21),COUNTA($C$17:C21),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C21),1,10),C21)),E21))","v":1},0.33333333333333331,3]
[null,null,{"$f":"IF(ROWS($D$17:$D22)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D22),'Targeted indicators'!$R:$R,0)))","v":"Environmental and cultural heritage impact"},{"$f":"IF(ROWS($D$17:$D22)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D22),'Targeted indicators'!$R:$R,0)))","v":"Overall impact on fauna connectivity (fish passage/fauna movement) "},{"$f":"IF(D22=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E22)))","v":"F"},null,null,null,null,null,{"$f":"IF($E22=\"\",\"\",$E22)","v":"F"},{"$f":"IF(C22=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C22),COUNTA($C$17:C22),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C22),1,10),C22)),E22))","v":1},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(ROWS($D$17:$D23)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D23),'Targeted indicators'!$R:$R,0)))","v":"Environmental and cultural heritage impact"},{"$f":"IF(ROWS($D$17:$D23)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D23),'Targeted indicators'!$R:$R,0)))","v":"Overall impacts to vegetation and habitat"},{"$f":"IF(D23=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E23)))","v":"G"},null,null,null,null,null,null,{"$f":"IF(C23=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C23),COUNTA($C$17:C23),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C23),1,10),C23)),E23))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(ROWS($D$17:$D24)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D24),'Targeted indicators'!$R:$R,0)))","v":"Environmental and cultural heritage impact"},{"$f":"IF(ROWS($D$17:$D24)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D24),'Targeted indicators'!$R:$R,0)))","v":"Impact on cultural heritage sites"},{"$f":"IF(D24=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E24)))","v":"H"},null,null,null,null,null,null,{"$f":"IF(C24=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C24),COUNTA($C$17:C24),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C24),1,10),C24)),E24))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(ROWS($D$17:$D25)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D25),'Targeted indicators'!$R:$R,0)))","v":"Social"},{"$f":"IF(ROWS($D$17:$D25)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D25),'Targeted indicators'!$R:$R,0)))","v":"Disruption to daily life"},{"$f":"IF(D25=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E25)))","v":"I"},null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C25),COUNTA($C$17:C25),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C25),1,10),C25)),E25))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(ROWS($D$17:$D26)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D26),'Targeted indicators'!$R:$R,0)))","v":"Social"},{"$f":"IF(ROWS($D$17:$D26)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D26),'Targeted indicators'!$R:$R,0)))","v":"Additional community benefits"},{"$f":"IF(D26=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E26)))","v":"J"},null,null,null,null,null,null,{"$f":"IF(C26=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C26),COUNTA($C$17:C26),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C26),1,10),C26)),E26))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(ROWS($D$17:$D27)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D27),'Targeted indicators'!$R:$R,0)))","v":"Flood behaviour/impact"},{"$f":"IF(ROWS($D$17:$D27)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D27),'Targeted indicators'!$R:$R,0)))","v":"Flood impacts"},{"$f":"IF(D27=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E27)))","v":"K"},null,null,null,null,null,null,{"$f":"IF(C27=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C27),COUNTA($C$17:C27),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C27),1,10),C27)),E27))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(ROWS($D$17:$D28)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D28),'Targeted indicators'!$R:$R,0)))","v":"Additional constraints"},{"$f":"IF(ROWS($D$17:$D28)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D28),'Targeted indicators'!$R:$R,0)))","v":"Engineering/construction constraints"},{"$f":"IF(D28=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E28)))","v":"L"},null,null,null,null,null,null,{"$f":"IF(C28=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C28),COUNTA($C$17:C28),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C28),1,10),C28)),E28))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"IF(ROWS($D$17:$D29)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D29),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D29)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D29),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E29)))","v":""},null,null,null,null,null,null,{"$f":"IF(C29=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C29),COUNTA($C$17:C29),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C29),1,10),C29)),E29))","v":""},"",""]
[null,null,{"$f":"IF(ROWS($D$17:$D30)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D30),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D30)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D30),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D30=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E30)))","v":""},null,null,null,null,null,null,{"$f":"IF(C30=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C30),COUNTA($C$17:C30),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C30),1,10),C30)),E30))","v":""},"",""]
[null,null,{"$f":"IF(ROWS($D$17:$D31)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D31),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D31)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D31),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D31=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E31)))","v":""},null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C31),COUNTA($C$17:C31),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C31),1,10),C31)),E31))","v":""},"",""]
[null,null,{"$f":"IF(ROWS($D$17:$D32)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D32),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D32)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D32),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D32=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E32)))","v":""},null,null,null,null,null,null,{"$f":"IF(C32=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C32),COUNTA($C$17:C32),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C32),1,10),C32)),E32))","v":""},"",""]
[null,null,{"$f":"IF(ROWS($D$17:$D33)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D33),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D33)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D33),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D33=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E33)))","v":""},null,null,null,null,null,null,{"$f":"IF(C33=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C33),COUNTA($C$17:C33),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C33),1,10),C33)),E33))","v":""},"",""]
[null,null,{"$f":"IF(ROWS($D$17:$D34)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D34),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D34)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D34),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D34=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E34)))","v":""},null,null,null,null,null,null,{"$f":"IF(C34=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C34),COUNTA($C$17:C34),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C34),1,10),C34)),E34))","v":""},"",""]
[null,null,{"$f":"IF(ROWS($D$17:$D35)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D35),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D35)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D35),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D35=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E35)))","v":""},null,null,null,null,null,null,{"$f":"IF(C35=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C35),COUNTA($C$17:C35),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C35),1,10),C35)),E35))","v":""},"",""]
[null,null,{"$f":"IF(ROWS($D$17:$D36)>'Targeted indicators'!$Q$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$17:$D36),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(ROWS($D$17:$D36)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$C:$C,MATCH(ROWS($D$17:$D36),'Targeted indicators'!$R:$R,0)))","v":""},{"$f":"IF(D36=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$17:$E36)))","v":""},null,null,null,null,null,null,{"$f":"IF(C36=\"\",\"\",COUNTIF(OFFSET($E$16,COUNTA($C$17:C36),COUNTA($C$17:C36),1,COUNTIF(OFFSET($E$13,1,COUNTA($C$17:C36),1,10),C36)),E36))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L17:L36)","v":{"$error":"#REF!"}}]

{"sheet":"Scoring","index":6,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Scoring\nEnter scores of between 1 to 5 for each of the targeted indicators. Score descriptors can be found in the Targeted indicators worksheet. \n\nEnsure scores have been assigned for each targeted indicator and option being assessed. Errors will occur in calculating scores, if a score has not been assigned. \n\nNote, after inputting scores, if there are changes to the options feasibility assessment resulting in the removal or addition of options scores will need to be re-entered to avoid errors in calculating scores. "]
[null,null,null,null,null,{"$f":"TRANSPOSE('Multi-criteria assessment'!$E$7:$E$26)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,"Criteria","Targeted Indicator","Pairwise Comparison","Base Case",{"$f":"IF(F3=0,\"\",F3)","v":""},{"$f":"IF(G3=0,\"\",G3)","v":""},"","","","","","","","","","","","","","","","","",""]
[null,{"$f":"'Targeted indicators'!B9","v":"Safety"},{"$f":"'Targeted indicators'!C9","v":"Ability to evacuate to safer locations or evacuation centres"},{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B10","v":"Safety"},{"$f":"'Targeted indicators'!C10","v":"Population at risk"},{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B11","v":"Safety"},{"$f":"'Targeted indicators'!C11","v":"Isolation duration and risk"},{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B12","v":"Economic"},{"$f":"'Targeted indicators'!C12","v":"Economic growth and investment"},{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B13","v":"Economic"},{"$f":"'Targeted indicators'!C13","v":"Damages and costs (property, assets and operations)"},{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B14","v":"Environmental and cultural heritage impact"},{"$f":"'Targeted indicators'!C14","v":"Overall impact on fauna connectivity (fish passage/fauna movement) "},{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B15","v":"Environmental and cultural heritage impact"},{"$f":"'Targeted indicators'!C15","v":"Overall impacts to vegetation and habitat"},{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B16","v":"Environmental and cultural heritage impact"},{"$f":"'Targeted indicators'!C16","v":"Impact on cultural heritage sites"},{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B17","v":"Social"},{"$f":"'Targeted indicators'!C17","v":"Disruption to daily life"},{"$f":"IF(B13=\"\",\"\",VLOOKUP(B13,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B18","v":"Social"},{"$f":"'Targeted indicators'!C18","v":"Additional community benefits"},{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B19","v":"Flood behaviour/impact"},{"$f":"'Targeted indicators'!C19","v":"Flood impacts"},{"$f":"IF(B15=\"\",\"\",VLOOKUP(B15,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,{"$f":"'Targeted indicators'!B20","v":"Additional constraints"},{"$f":"'Targeted indicators'!C20","v":"Engineering/construction constraints"},{"$f":"IF(B16=\"\",\"\",VLOOKUP(B16,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3]
[null,null,null,{"$f":"IF(B17=\"\",\"\",VLOOKUP(C17,'MCA criteria weighting'!D29:M48,24,FALSE))","v":""},{"$f":"IF($C17=\"\",\"\",3)","v":""},null,"","","","",null,"","","",null,"","","","","","","","","",""]
[null,null,null,{"$f":"IF(B18=\"\",\"\",VLOOKUP(C18,'MCA criteria weighting'!D30:M49,24,FALSE))","v":""},"","","","","","",null,"","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(C19,'MCA criteria weighting'!D31:M50,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(C20,'MCA criteria weighting'!D32:M51,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(C21,'MCA criteria weighting'!D33:M52,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(C22,'MCA criteria weighting'!D34:M53,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B23=\"\",\"\",VLOOKUP(C23,'MCA criteria weighting'!D35:M54,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B24=\"\",\"\",VLOOKUP(C24,'MCA criteria weighting'!D36:M55,24,FALSE))","v":""},"","","","","",null,"","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(C25,'MCA criteria weighting'!D37:M56,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B26=\"\",\"\",VLOOKUP(C26,'MCA criteria weighting'!D38:M57,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B27=\"\",\"\",VLOOKUP(C27,'MCA criteria weighting'!D39:M58,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B28=\"\",\"\",VLOOKUP(C28,'MCA criteria weighting'!D40:M59,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B29=\"\",\"\",VLOOKUP(C29,'MCA criteria weighting'!D41:M60,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B30=\"\",\"\",VLOOKUP(C30,'MCA criteria weighting'!D42:M61,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B31=\"\",\"\",VLOOKUP(C31,'MCA criteria weighting'!D43:M62,24,FALSE))","v":""}]

{"sheet":"MCA indicator weighting","index":7,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":true,"merged":[[1,2,1,7]]}
[]
[null,null,"**DO NOT EDIT**\n"]
[]
[]
[null,null,null,"  ",null,{"$f":"IF(ROWS($D$7:$D7)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D7),'Targeted indicators'!$O:$O,0)))","v":"Safety"},{"$f":"IF(ROWS($D$7:$D8)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D8),'Targeted indicators'!$O:$O,0)))","v":"Economic"},{"$f":"IF(ROWS($D$7:$D9)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D9),'Targeted indicators'!$O:$O,0)))","v":"Environmental and cultural heritage impact"},{"$f":"IF(ROWS($D$7:$D10)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D10),'Targeted indicators'!$O:$O,0)))","v":"Social"},{"$f":"IF(ROWS($D$7:$D11)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D11),'Targeted indicators'!$O:$O,0)))","v":"Flood behaviour/impact"},{"$f":"IF(ROWS($D$7:$D12)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D12),'Targeted indicators'!$O:$O,0)))","v":"Additional constraints"},{"$f":"IF(ROWS($D$7:$D13)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D13),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(ROWS($D$7:$D14)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D14),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(ROWS($D$7:$D15)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D15),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(ROWS($D$7:$D16)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D16),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(ROWS($D$7:$D17)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D17),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(ROWS($D$7:$D18)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D18),'Targeted indicators'!$O:$O,0)))","v":""},"Occurrence +1","WEIGHTING"]
[null,null,null,"  ",null,{"$f":"IF(F5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:F$5)))","v":"A"},{"$f":"IF(G5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:G$5)))","v":"B"},{"$f":"IF(H5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:H$5)))","v":"C"},{"$f":"IF(I5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:I$5)))","v":"D"},{"$f":"IF(J5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:J$5)))","v":"E"},{"$f":"IF(K5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:K$5)))","v":"F"},{"$f":"IF(L5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:L$5)))","v":""},{"$f":"IF(M5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:M$5)))","v":""},{"$f":"IF(N5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:N$5)))","v":""},{"$f":"IF(O5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:O$5)))","v":""},{"$f":"IF(P5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:P$5)))","v":""},{"$f":"IF(Q5=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:Q$5)))","v":""}]
[null,null,null,{"$f":"IF(ROWS($D$7:$D7)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D7),'Targeted indicators'!$O:$O,0)))","v":"Safety"},{"$f":"IF(D7=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E7)))","v":"A"},{"$f":"IF($E7=\"\",\"\",$E7)","v":"A"},"A","A","A","A","A",null,null,null,null,null,null,{"$f":"IF($D7=\"\",\"\",COUNTIF($F$7:$Q$26,$E7))","v":6},{"$f":"IF($D7=\"\",\"\",R7/$R$27)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"IF(ROWS($D$7:$D8)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D8),'Targeted indicators'!$O:$O,0)))","v":"Economic"},{"$f":"IF(D8=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E8)))","v":"B"},null,{"$f":"IF($E8=\"\",\"\",$E8)","v":"B"},"B","B","B","B",null,null,null,null,null,null,5,{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(ROWS($D$7:$D9)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D9),'Targeted indicators'!$O:$O,0)))","v":"Environmental and cultural heritage impact"},{"$f":"IF(D9=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E9)))","v":"C"},null,null,{"$f":"IF($E9=\"\",\"\",$E9)","v":"C"},"C","C","C",null,null,null,null,null,null,4,{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(ROWS($D$7:$D10)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D10),'Targeted indicators'!$O:$O,0)))","v":"Social"},{"$f":"IF(D10=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E10)))","v":"D"},null,null,null,{"$f":"IF($E10=\"\",\"\",$E10)","v":"D"},"D","D",null,null,null,null,null,null,3,{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(ROWS($D$7:$D11)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D11),'Targeted indicators'!$O:$O,0)))","v":"Flood behaviour/impact"},{"$f":"IF(D11=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E11)))","v":"E"},null,null,null,null,{"$f":"IF($E11=\"\",\"\",$E11)","v":"E"},"E",null,null,null,null,null,null,2,{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(ROWS($D$7:$D12)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D12),'Targeted indicators'!$O:$O,0)))","v":"Additional constraints"},{"$f":"IF(D12=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E12)))","v":"F"},null,null,null,null,null,{"$f":"IF($E12=\"\",\"\",$E12)","v":"F"},null,null,null,null,null,null,1,{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(ROWS($D$7:$D13)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D13),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(D13=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E13)))","v":""},null,null,null,null,null,null,{"$f":"IF($E13=\"\",\"\",$E13)","v":""},null,null,null,null,null,"",""]
[null,null,null,{"$f":"IF(ROWS($D$7:$D14)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D14),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(D14=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E14)))","v":""},null,null,null,null,null,null,null,{"$f":"IF($E14=\"\",\"\",$E14)","v":""},null,null,null,null,"",""]
[null,null,null,{"$f":"IF(ROWS($D$7:$D15)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($D$7:$D15),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(D15=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E15)))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($E15=\"\",\"\",$E15)","v":""},null,null,null,"",""]
[null,null,null,null,{"$f":"IF(D16=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E16)))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($E16=\"\",\"\",$E16)","v":""},null,null,"",""]
[null,null,null,null,{"$f":"IF(D17=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E17)))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E17=\"\",\"\",$E17)","v":""},null,"",""]
[null,null,null,null,{"$f":"IF(D18=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E18)))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E18=\"\",\"\",$E18)","v":""},"",""]
[null,null,null,null,{"$f":"IF(D19=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E19)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(D20=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E20)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,{"$f":"IF(INDEX(#REF!,ROWS($D$7:$D21))=0,\"\",INDEX(#REF!,ROWS($D$7:$D21)))","v":{"$error":"#REF!"}},{"$f":"IF(D21=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E21)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(INDEX(#REF!,ROWS($D$7:$D22))=0,\"\",INDEX(#REF!,ROWS($D$7:$D22)))","v":{"$error":"#REF!"}},{"$f":"IF(D22=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E22)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(INDEX(#REF!,ROWS($D$7:$D23))=0,\"\",INDEX(#REF!,ROWS($D$7:$D23)))","v":{"$error":"#REF!"}},{"$f":"IF(D23=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E23)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(INDEX(#REF!,ROWS($D$7:$D24))=0,\"\",INDEX(#REF!,ROWS($D$7:$D24)))","v":{"$error":"#REF!"}},{"$f":"IF(D24=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E24)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(INDEX(#REF!,ROWS($D$7:$D25))=0,\"\",INDEX(#REF!,ROWS($D$7:$D25)))","v":{"$error":"#REF!"}},{"$f":"IF(D25=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E25)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,{"$f":"IF(INDEX(#REF!,ROWS($D$7:$D26))=0,\"\",INDEX(#REF!,ROWS($D$7:$D26)))","v":{"$error":"#REF!"}},{"$f":"IF(D26=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$7:$E26)))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R7:R26)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"C31","v":"Safety"},{"$f":"C32","v":"Safety"},{"$f":"C33","v":"Safety"},{"$f":"C34","v":"Economic"},{"$f":"C35","v":"Economic"},{"$f":"C36","v":"Environmental and cultural heritage impact"},{"$f":"C37","v":"Environmental and cultural heritage impact"},{"$f":"C38","v":"Environmental and cultural heritage impact"},{"$f":"C39","v":"Social"},{"$f":"C40","v":"Social"},{"$f":"C41","v":"Flood behaviour/impact"},{"$f":"C42","v":"Additional constraints"}]
[null,null,null,"  ",null,{"$f":"D31","v":"Ability to evacuate to safer locations or evacuation centres"},{"$f":"D32","v":"Population at risk"},{"$f":"D33","v":"Isolation duration and risk"},{"$f":"D34","v":"Economic growth and investment"},{"$f":"D35","v":"Damages and costs (property, assets and operations)"},{"$f":"D36","v":"Overall impact on fauna connectivity (fish passage/fauna movement) "},{"$f":"D37","v":"Overall impacts to vegetation and habitat"},{"$f":"D38","v":"Impact on cultural heritage sites"},{"$f":"D39","v":"Disruption to daily life"},{"$f":"D40","v":"Additional community benefits"},{"$f":"D41","v":"Flood impacts"},{"$f":"D42","v":"Engineering/construction constraints"},"Occurrence +1","WEIGHTING"]
[null,null,null,"  ",null,{"$f":"IF(F29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:F$5)))","v":"A"},{"$f":"IF(G29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:G$5)))","v":"B"},{"$f":"IF(H29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:H$5)))","v":"C"},{"$f":"IF(I29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:I$5)))","v":"D"},{"$f":"IF(J29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:J$5)))","v":"E"},{"$f":"IF(K29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:K$5)))","v":"F"},{"$f":"IF(L29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:L$5)))","v":"G"},{"$f":"IF(M29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:M$5)))","v":"H"},{"$f":"IF(N29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:N$5)))","v":"I"},{"$f":"IF(O29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:O$5)))","v":"J"},{"$f":"IF(P29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:P$5)))","v":"K"},{"$f":"IF(Q29=\"\",\"\",INDEX('General Calc'!$B$5:$B$24,COLUMNS($F$5:Q$5)))","v":"L"}]
[null,null,{"$f":"IF('Targeted indicators'!D9=\"YES\",'Targeted indicators'!B9,\"NOT REQUIRED\")","v":"Safety"},{"$f":"IF('Targeted indicators'!D9=\"YES\",'Targeted indicators'!C9,\"NOT REQUIRED\")","v":"Ability to evacuate to safer locations or evacuation centres"},{"$f":"IF(D31=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E31)))","v":"A"},{"$f":"IF($E31=\"\",\"\",$E31)","v":"A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C31),COUNTA($C$31:C31),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C31),1,10),C31)),E31))","v":1},{"$f":"IF($D31=\"NOT REQUIRED\",\"\",R31/T31)","v":0.33333333333333331},{"$f":"IF(C31=\"\",\"\",SUMIF(C:C,C31,R:R))","v":3}]
[null,null,{"$f":"IF('Targeted indicators'!D10=\"YES\",'Targeted indicators'!B10,\"NOT REQUIRED\")","v":"Safety"},{"$f":"IF('Targeted indicators'!D10=\"YES\",'Targeted indicators'!C10,\"NOT REQUIRED\")","v":"Population at risk"},{"$f":"IF(D32=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E32)))","v":"B"},null,{"$f":"IF($E32=\"\",\"\",$E32)","v":"B"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C32=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C32),COUNTA($C$31:C32),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C32),1,10),C32)),E32))","v":1},{"$f":"IF($D32=\"NOT REQUIRED\",\"\",R32/T32)","v":0.33333333333333331},3]
[null,null,{"$f":"IF('Targeted indicators'!D11=\"YES\",'Targeted indicators'!B11,\"NOT REQUIRED\")","v":"Safety"},{"$f":"IF('Targeted indicators'!D11=\"YES\",'Targeted indicators'!C11,\"NOT REQUIRED\")","v":"Isolation duration and risk"},{"$f":"IF(D33=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E33)))","v":"C"},null,null,{"$f":"IF($E33=\"\",\"\",$E33)","v":"C"},null,null,null,null,null,null,null,null,null,{"$f":"IF(C33=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C33),COUNTA($C$31:C33),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C33),1,10),C33)),E33))","v":1},0.33333333333333331,3]
[null,null,{"$f":"IF('Targeted indicators'!D12=\"YES\",'Targeted indicators'!B12,\"NOT REQUIRED\")","v":"Economic"},{"$f":"IF('Targeted indicators'!D12=\"YES\",'Targeted indicators'!C12,\"NOT REQUIRED\")","v":"Economic growth and investment"},{"$f":"IF(D34=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E34)))","v":"D"},null,null,null,{"$f":"IF($E34=\"\",\"\",$E34)","v":"D"},null,null,null,null,null,null,null,null,{"$f":"IF(C34=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C34),COUNTA($C$31:C34),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C34),1,10),C34)),E34))","v":1},0.5,2]
[null,null,{"$f":"IF('Targeted indicators'!D13=\"YES\",'Targeted indicators'!B13,\"NOT REQUIRED\")","v":"Economic"},{"$f":"IF('Targeted indicators'!D13=\"YES\",'Targeted indicators'!C13,\"NOT REQUIRED\")","v":"Damages and costs (property, assets and operations)"},{"$f":"IF(D35=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E35)))","v":"E"},null,null,null,null,{"$f":"IF($E35=\"\",\"\",$E35)","v":"E"},null,null,null,null,null,null,null,{"$f":"IF(C35=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C35),COUNTA($C$31:C35),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C35),1,10),C35)),E35))","v":1},0.5,2]
[null,null,{"$f":"IF('Targeted indicators'!D14=\"YES\",'Targeted indicators'!B14,\"NOT REQUIRED\")","v":"Environmental and cultural heritage impact"},{"$f":"IF('Targeted indicators'!D14=\"YES\",'Targeted indicators'!C14,\"NOT REQUIRED\")","v":"Overall impact on fauna connectivity (fish passage/fauna movement) "},{"$f":"IF(D36=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E36)))","v":"F"},null,null,null,null,null,{"$f":"IF($E36=\"\",\"\",$E36)","v":"F"},null,null,null,null,null,null,{"$f":"IF(C36=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C36),COUNTA($C$31:C36),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C36),1,10),C36)),E36))","v":1},0.33333333333333331,3]
[null,null,{"$f":"IF('Targeted indicators'!D15=\"YES\",'Targeted indicators'!B15,\"NOT REQUIRED\")","v":"Environmental and cultural heritage impact"},{"$f":"IF('Targeted indicators'!D15=\"YES\",'Targeted indicators'!C15,\"NOT REQUIRED\")","v":"Overall impacts to vegetation and habitat"},{"$f":"IF(D37=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E37)))","v":"G"},null,null,null,null,null,null,{"$f":"IF($E37=\"\",\"\",$E37)","v":"G"},null,null,null,null,null,{"$f":"IF(C37=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C37),COUNTA($C$31:C37),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C37),1,10),C37)),E37))","v":1},{"$f":"IF($D37=\"NOT REQUIRED\",\"\",R37/T37)","v":0.33333333333333331},3]
[null,null,{"$f":"IF('Targeted indicators'!D16=\"YES\",'Targeted indicators'!B16,\"NOT REQUIRED\")","v":"Environmental and cultural heritage impact"},{"$f":"IF('Targeted indicators'!D16=\"YES\",'Targeted indicators'!C16,\"NOT REQUIRED\")","v":"Impact on cultural heritage sites"},{"$f":"IF(D38=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E38)))","v":"H"},null,null,null,null,null,null,null,{"$f":"IF($E38=\"\",\"\",$E38)","v":"H"},null,null,null,null,{"$f":"IF(C38=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C38),COUNTA($C$31:C38),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C38),1,10),C38)),E38))","v":1},0.33333333333333331,3]
[null,null,{"$f":"IF('Targeted indicators'!D17=\"YES\",'Targeted indicators'!B17,\"NOT REQUIRED\")","v":"Social"},{"$f":"IF('Targeted indicators'!D17=\"YES\",'Targeted indicators'!C17,\"NOT REQUIRED\")","v":"Disruption to daily life"},{"$f":"IF(D39=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E39)))","v":"I"},null,null,null,null,null,null,null,null,{"$f":"IF($E39=\"\",\"\",$E39)","v":"I"},null,null,null,{"$f":"IF(C39=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C39),COUNTA($C$31:C39),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C39),1,10),C39)),E39))","v":1},0.5,2]
[null,null,{"$f":"IF('Targeted indicators'!D18=\"YES\",'Targeted indicators'!B18,\"NOT REQUIRED\")","v":"Social"},{"$f":"IF('Targeted indicators'!D18=\"YES\",'Targeted indicators'!C18,\"NOT REQUIRED\")","v":"Additional community benefits"},{"$f":"IF(D40=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E40)))","v":"J"},null,null,null,null,null,null,null,null,null,{"$f":"IF($E40=\"\",\"\",$E40)","v":"J"},null,null,{"$f":"IF(C40=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C40),COUNTA($C$31:C40),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C40),1,10),C40)),E40))","v":1},0.5,2]
[null,null,{"$f":"IF('Targeted indicators'!D19=\"YES\",'Targeted indicators'!B19,\"NOT REQUIRED\")","v":"Flood behaviour/impact"},{"$f":"IF('Targeted indicators'!D19=\"YES\",'Targeted indicators'!C19,\"NOT REQUIRED\")","v":"Flood impacts"},{"$f":"IF(D41=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E41)))","v":"K"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E41=\"\",\"\",$E41)","v":"K"},null,{"$f":"IF(C41=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C41),COUNTA($C$31:C41),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C41),1,10),C41)),E41))","v":1},1,1]
[null,null,{"$f":"IF('Targeted indicators'!D20=\"YES\",'Targeted indicators'!B20,\"NOT REQUIRED\")","v":"Additional constraints"},{"$f":"IF('Targeted indicators'!D20=\"YES\",'Targeted indicators'!C20,\"NOT REQUIRED\")","v":"Engineering/construction constraints"},{"$f":"IF(D42=\"NOT REQUIRED\",\"\",INDEX('General Calc'!$B$5:$B$24,ROWS($E$31:$E42)))","v":"L"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E42=\"\",\"\",$E42)","v":"L"},{"$f":"IF(C42=\"NOT REQUIRED\",\"\",COUNTIF(OFFSET($E$30,COUNTA($C$31:C42),COUNTA($C$31:C42),1,COUNTIF(OFFSET($E$27,1,COUNTA($C$31:C42),1,10),C42)),E42))","v":1},1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R31:R42)","v":12}]

{"sheet":"Results","index":8,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[43,1,44,1],[5,3,14,11],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[19,1,20,1],[19,2,19,7],[19,8,19,9]]}
[]
[]
[null,"\nResults\nThe results of the Stage two: multi-criteria assessment is shown in the table below. The table shows both results for each criteria and the overall results. Criteria results are the average scores for each criteria and do not apply the assigned weightings. The overall results take into account weightings and are determined by totalling the weighted scores for each targeted indicator. \n"]
[]
[null,"Highest scoring option"]
[null,"Overall",{"$f":"INDEX(Analysis!$G$4:$AB$4,MATCH(1,Results!$B$19:$Y$19,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Identify potential options'!$D$7:$D$26,MATCH(C6,'Identify potential options'!$C$7:$C$26,0))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ROWS($B$7:$B7)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B7),'Targeted indicators'!$O:$O,0)))","v":"Safety"},{"$f":"IF(B7=\"\",\"\",INDEX($C$45:$L$45,MATCH(MAX(C46:L46),C46:L46,0)))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(ROWS($B$7:$B8)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B8),'Targeted indicators'!$O:$O,0)))","v":"Economic"},{"$error":"#N/A"}]
[null,{"$f":"IF(ROWS($B$7:$B9)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B9),'Targeted indicators'!$O:$O,0)))","v":"Environmental and cultural heritage impact"},{"$error":"#N/A"}]
[null,{"$f":"IF(ROWS($B$7:$B10)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B10),'Targeted indicators'!$O:$O,0)))","v":"Social"},{"$error":"#N/A"}]
[null,{"$f":"IF(ROWS($B$7:$B11)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B11),'Targeted indicators'!$O:$O,0)))","v":"Flood behaviour/impact"},{"$error":"#N/A"}]
[null,{"$f":"IF(ROWS($B$7:$B12)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B12),'Targeted indicators'!$O:$O,0)))","v":"Additional constraints"},{"$error":"#N/A"}]
[null,{"$f":"IF(ROWS($B$7:$B13)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B13),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(B13=\"\",\"\",INDEX($C$45:$L$45,MATCH(MAX(D52:L52),D52:L52,0)))","v":""}]
[null,{"$f":"IF(ROWS($B$7:$B14)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B14),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(B14=\"\",\"\",INDEX($C$45:$L$45,MATCH(MAX(D53:L53),D53:L53,0)))","v":""}]
[null,{"$f":"IF(ROWS($B$7:$B15)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$7:$B15),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(B15=\"\",\"\",INDEX($C$45:$L$45,MATCH(MAX(D54:L54),D54:L54,0)))","v":""}]
[]
["Summary of option scoring",null,{"$f":"Scoring!F4","v":""},{"$f":"Scoring!G4","v":""},{"$f":"Scoring!H4","v":""},{"$f":"Scoring!I4","v":""},{"$f":"Scoring!J4","v":""},{"$f":"Scoring!K4","v":""},{"$f":"Scoring!L4","v":""},{"$f":"Scoring!M4","v":""},{"$f":"Scoring!N4","v":""},{"$f":"Scoring!O4","v":""},{"$f":"Scoring!P4","v":""},{"$f":"Scoring!Q4","v":""},{"$f":"Scoring!R4","v":""},{"$f":"Scoring!S4","v":""},{"$f":"Scoring!T4","v":""},{"$f":"Scoring!U4","v":""},{"$f":"Scoring!V4","v":""},{"$f":"Scoring!W4","v":""},{"$f":"Scoring!X4","v":""},{"$f":"Scoring!Y4","v":""}]
["Score",null,{"$f":"ROUND(SUMPRODUCT(Analysis!H5:H16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!I5:I16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!J5:J16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!K5:K16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!L5:L16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!M5:M16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!N5:N16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!O5:O16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!P5:P16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!Q5:Q16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!R5:R16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!S5:S16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!T5:T16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!U5:U16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!V5:V16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!W5:W16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!X5:X16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!Y5:Y16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!Z5:Z16),2)","v":0},{"$f":"ROUND(SUMPRODUCT(Analysis!AA5:AA16),2)","v":0}]
["Rank",{"$f":"IF(B18<>0,RANK(B18,$B$18:$K$18),\"\")","v":""},{"$f":"IF(C18<>0,RANK(C18,$C$18:$Y$18,0),\"\")","v":""},{"$f":"IF(D18<>0,RANK(D18,$C$18:$Y$18,0),\"\")","v":""},"","","","","","","","","","","","","","","","","",""]
[null,"Option","Criteria results (no weighting applied)",null,null,null,null,null,"Overall results (weighting applied)"]
[null,null,"Safety","Economic","Environmental and cultural heritage impact","Social","Flood behaviour/impact","Additional constraints","Score","Rank"]
[null,{"$f":"C17","v":""},{"$f":"TRANSPOSE($C$46:$V$51)","v":""},"","","","","",{"$f":"HLOOKUP(B22,$C$17:$V$19,2,FALSE)","v":0},{"$f":"HLOOKUP(B22,$C$17:$V$19,3,FALSE)","v":""}]
[null,{"$f":"D17","v":""},"","","","","","",0,{"$f":"HLOOKUP(B23,$C$17:$V$19,3,FALSE)","v":""}]
[null,{"$f":"E17","v":""},"","","","","","",0,""]
[null,{"$f":"F17","v":""},"","","","","","",0,""]
[null,{"$f":"G17","v":""},"","","","","","",0,""]
[null,{"$f":"H17","v":""},"","","","","","",0,""]
[null,{"$f":"I17","v":""},"","","","","","",0,""]
[null,{"$f":"J17","v":""},"","","","","","",0,""]
[null,{"$f":"K17","v":""},"","","","","","",0,""]
[null,{"$f":"L17","v":""},"","","","","","",0,""]
[null,{"$f":"M17","v":""},"","","","","","",0,""]
[null,{"$f":"N17","v":""},"","","","","","",0,""]
[null,{"$f":"O17","v":""},"","","","","","",0,""]
[null,{"$f":"P17","v":""},"","","","","","",0,""]
[null,{"$f":"Q17","v":""},"","","","","","",0,""]
[null,{"$f":"R17","v":""},"","","","","","",0,""]
[null,{"$f":"S17","v":""},"","","","","","",0,""]
[null,{"$f":"T17","v":""},"","","","","","",0,""]
[null,{"$f":"U17","v":""},"","","","","","",0,""]
[null,{"$f":"V17","v":""},"","","","","","",0,""]
[]
[null,"Scores per criteria"]
[null,"Criteria","Options"]
[null,null,{"$f":"Scoring!F4","v":""},{"$f":"Scoring!G4","v":""},{"$f":"Scoring!H4","v":""},{"$f":"Scoring!I4","v":""},{"$f":"Scoring!J4","v":""},{"$f":"Scoring!K4","v":""},{"$f":"Scoring!L4","v":""},{"$f":"Scoring!M4","v":""},{"$f":"Scoring!N4","v":""},{"$f":"Scoring!O4","v":""},{"$f":"Scoring!P4","v":""},{"$f":"Scoring!Q4","v":""},{"$f":"Scoring!R4","v":""},{"$f":"Scoring!S4","v":""},{"$f":"Scoring!T4","v":""},{"$f":"Scoring!U4","v":""},{"$f":"Scoring!V4","v":""},{"$f":"Scoring!W4","v":""},{"$f":"Scoring!X4","v":""},{"$f":"Scoring!Y4","v":""}]
[null,"Safety",{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(C$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!F$5:F$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(D$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!G$5:G$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(E$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!H$5:H$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(F$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!I$5:I$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(G$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!J$5:J$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(H$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!K$5:K$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(I$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!L$5:L$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(J$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!M$5:M$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(K$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!N$5:N$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(L$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!O$5:O$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(M$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!P$5:P$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(N$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!Q$5:Q$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(O$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!R$5:R$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(P$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!S$5:S$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(Q$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!T$5:T$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(R$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!U$5:U$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(S$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!V$5:V$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(T$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!W$5:W$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(U$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!X$5:X$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""},{"$f":"IF($B46=\"\",\"\",IF(COUNTBLANK(V$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1,Scoring!Y$5:Y$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B46)*1),\"\"))","v":""}]
[null,"Economic",{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(C$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!F$5:F$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(D$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!G$5:G$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(E$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!H$5:H$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(F$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!I$5:I$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(G$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!J$5:J$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(H$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!K$5:K$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(I$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!L$5:L$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(J$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!M$5:M$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(K$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!N$5:N$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(L$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!O$5:O$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(M$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!P$5:P$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(N$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!Q$5:Q$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(O$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!R$5:R$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(P$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!S$5:S$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(Q$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!T$5:T$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(R$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!U$5:U$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(S$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!V$5:V$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(T$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!W$5:W$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(U$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!X$5:X$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""},{"$f":"IF($B47=\"\",\"\",IF(COUNTBLANK(V$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1,Scoring!Y$5:Y$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B47)*1),\"\"))","v":""}]
[null,"Environmental and cultural heritage impact",{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(C$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!F$5:F$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(D$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!G$5:G$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(E$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!H$5:H$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(F$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!I$5:I$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(G$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!J$5:J$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(H$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!K$5:K$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(I$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!L$5:L$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(J$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!M$5:M$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(K$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!N$5:N$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(L$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!O$5:O$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(M$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!P$5:P$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(N$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!Q$5:Q$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(O$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!R$5:R$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(P$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!S$5:S$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(Q$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!T$5:T$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(R$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!U$5:U$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(S$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!V$5:V$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(T$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!W$5:W$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(U$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!X$5:X$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""},{"$f":"IF($B48=\"\",\"\",IF(COUNTBLANK(V$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1,Scoring!Y$5:Y$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B48)*1),\"\"))","v":""}]
[null,"Social",{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(C$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!F$5:F$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(D$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!G$5:G$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(E$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!H$5:H$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(F$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!I$5:I$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(G$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!J$5:J$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(H$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!K$5:K$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(I$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!L$5:L$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(J$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!M$5:M$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(K$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!N$5:N$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(L$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!O$5:O$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(M$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!P$5:P$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(N$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!Q$5:Q$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(O$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!R$5:R$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(P$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!S$5:S$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(Q$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!T$5:T$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(R$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!U$5:U$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(S$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!V$5:V$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(T$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!W$5:W$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(U$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!X$5:X$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""},{"$f":"IF($B49=\"\",\"\",IF(COUNTBLANK(V$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1,Scoring!Y$5:Y$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B49)*1),\"\"))","v":""}]
[null,"Flood behaviour/impact",{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(C$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!F$5:F$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(D$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!G$5:G$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(E$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!H$5:H$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(F$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!I$5:I$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(G$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!J$5:J$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(H$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!K$5:K$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(I$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!L$5:L$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(J$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!M$5:M$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(K$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!N$5:N$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(L$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!O$5:O$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(M$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!P$5:P$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(N$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!Q$5:Q$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(O$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!R$5:R$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(P$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!S$5:S$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(Q$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!T$5:T$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(R$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!U$5:U$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(S$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!V$5:V$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(T$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!W$5:W$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(U$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!X$5:X$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""},{"$f":"IF($B50=\"\",\"\",IF(COUNTBLANK(V$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1,Scoring!Y$5:Y$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B50)*1),\"\"))","v":""}]
[null,"Additional constraints",{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(C$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!F$5:F$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(D$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!G$5:G$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(E$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!H$5:H$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(F$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!I$5:I$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(G$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!J$5:J$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(H$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!K$5:K$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(I$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!L$5:L$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(J$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!M$5:M$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(K$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!N$5:N$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(L$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!O$5:O$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(M$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!P$5:P$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(N$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!Q$5:Q$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(O$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!R$5:R$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(P$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!S$5:S$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(Q$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!T$5:T$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(R$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!U$5:U$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(S$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!V$5:V$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(T$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!W$5:W$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(U$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!X$5:X$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""},{"$f":"IF($B51=\"\",\"\",IF(COUNTBLANK(V$45)=0,SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1,Scoring!Y$5:Y$25)/SUMPRODUCT((Analysis!$B$5:$B$25=$B51)*1),\"\"))","v":""}]
[null,{"$f":"IF(ROWS($B$46:$B52)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$46:$B52),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(B52=\"\",\"\",AVERAGEIF(Analysis!$B$5:$B$25,B52,Analysis!$C$5:$C$25))","v":""}]
[null,{"$f":"IF(ROWS($B$46:$B53)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$46:$B53),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(B53=\"\",\"\",AVERAGEIF(Analysis!$B$5:$B$25,B53,Analysis!$C$5:$C$25))","v":""}]
[null,{"$f":"IF(ROWS($B$46:$B54)>'Targeted indicators'!$N$8,\"\",INDEX('Targeted indicators'!$B:$B,MATCH(ROWS($B$46:$B54),'Targeted indicators'!$O:$O,0)))","v":""},{"$f":"IF(B54=\"\",\"\",AVERAGEIF(Analysis!$B$5:$B$25,B54,Analysis!$C$5:$C$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!G$6:G$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!H$6:H$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!I$6:I$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!J$6:J$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!K$6:K$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!L$6:L$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!M$6:M$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!N$6:N$25))","v":""},{"$f":"IF($B54=\"\",\"\",SUMPRODUCT(Scoring!$E$6:$E$25,(Scoring!$B$6:$B$25=$B54)*1,Scoring!O$6:O$25))","v":""}]
[null,"Final Score",{"$f":"SUM(C46:C54)","v":0},{"$f":"SUM(D46:D54)","v":0},0,0,0,0,0,0,0,0]
[null,"Rank",{"$f":"IF(C55<>0,RANK(C55,$C$55:$L$55),\"\")","v":""},{"$f":"IF(D55<>0,RANK(D55,$C$55:$L$55),\"\")","v":""},"","","","","","","","","","","","","","","","","",""]

{"sheet":"Analysis","index":9,"n_rows":31,"n_cols":27,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Analysis\nAn analysis of the results is shown in the table below. The table displays the following:\n\nCriteria weighting - weightings determined through the pairwise method in the Multi-criteria Assessment Criteria Weighting Worksheet\n\nTargeted indicator weighting - determined by dividing criteria weighting by the number of targeted indicators within the criterion. \n\nWeighted scores - determined by multiplying scores by the    targeted indicator weightings\n\nOverall scores - sum of the weighted scores for each option."]
[]
[null,"Criteria","Criteria Weighting","Targeted indicator","Weighting of issue within criteria (%)","Targeted indicator weighting",{"$f":"Scoring!E4","v":"Base Case"},{"$f":"Scoring!F4","v":""},{"$f":"Scoring!G4","v":""},{"$f":"Scoring!H4","v":""},{"$f":"Scoring!I4","v":""},{"$f":"Scoring!J4","v":""},{"$f":"Scoring!K4","v":""},{"$f":"Scoring!L4","v":""},{"$f":"Scoring!M4","v":""},{"$f":"Scoring!N4","v":""},{"$f":"Scoring!O4","v":""},{"$f":"Scoring!P4","v":""},{"$f":"Scoring!Q4","v":""},{"$f":"Scoring!R4","v":""},{"$f":"Scoring!S4","v":""},{"$f":"Scoring!T4","v":""},{"$f":"Scoring!U4","v":""},{"$f":"Scoring!V4","v":""},{"$f":"Scoring!W4","v":""},{"$f":"Scoring!X4","v":""},{"$f":"Scoring!Y4","v":""}]
[null,{"$f":"Scoring!B5","v":"Safety"},{"$f":"IF(COUNTBLANK(B5)=0,VLOOKUP(B5,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C5","v":"Ability to evacuate to safer locations or evacuation centres"},{"$f":"IF(B5=\"\",\"\",VLOOKUP(D5,'MCA indicator weighting'!D31:S42,16,FALSE))","v":0.33333333333333331},{"$f":"E5*C5","v":5.5555555555555552E-2},{"$f":"IF($B5=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!E$5:E$30)*$E5*$C5))","v":0.16666666666666666},{"$f":"IF($B5=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!F$5:F$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!G$5:G$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!H$5:H$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!I$5:I$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!J$5:J$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!K$5:K$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!L$5:L$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!M$5:M$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!N$5:N$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!O$5:O$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!P$5:P$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!Q$5:Q$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!R$5:R$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!S$5:S$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!T$5:T$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!U$5:U$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!V$5:V$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!W$5:W$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!X$5:X$30)*$E5*$C5))","v":""},{"$f":"IF($B5=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D5,Scoring!Y$5:Y$30)*$E5*$C5))","v":""}]
[null,{"$f":"Scoring!B6","v":"Safety"},{"$f":"IF(COUNTBLANK(B6)=0,VLOOKUP(B6,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C6","v":"Population at risk"},{"$f":"IF(B6=\"\",\"\",VLOOKUP(D6,'MCA indicator weighting'!D32:S43,16,FALSE))","v":0.33333333333333331},{"$f":"E6*C6","v":5.5555555555555552E-2},{"$f":"IF($B6=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!E$5:E$30)*$E6*$C6))","v":0.16666666666666666},{"$f":"IF($B6=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!F$5:F$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!G$5:G$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!H$5:H$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!I$5:I$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!J$5:J$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!K$5:K$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!L$5:L$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!M$5:M$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!N$5:N$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!O$5:O$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!P$5:P$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!Q$5:Q$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!R$5:R$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!S$5:S$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!T$5:T$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!U$5:U$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!V$5:V$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!W$5:W$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!X$5:X$30)*$E6*$C6))","v":""},{"$f":"IF($B6=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D6,Scoring!Y$5:Y$30)*$E6*$C6))","v":""}]
[null,{"$f":"Scoring!B7","v":"Safety"},{"$f":"IF(COUNTBLANK(B7)=0,VLOOKUP(B7,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C7","v":"Isolation duration and risk"},{"$f":"IF(B7=\"\",\"\",VLOOKUP(D7,'MCA indicator weighting'!D33:S44,16,FALSE))","v":0.33333333333333331},5.5555555555555552E-2,{"$f":"IF($B7=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!E$5:E$30)*$E7*$C7))","v":0.16666666666666666},{"$f":"IF($B7=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!F$5:F$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!G$5:G$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!H$5:H$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!I$5:I$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!J$5:J$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!K$5:K$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!L$5:L$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!M$5:M$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!N$5:N$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!O$5:O$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!P$5:P$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!Q$5:Q$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!R$5:R$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!S$5:S$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!T$5:T$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!U$5:U$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!V$5:V$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!W$5:W$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!X$5:X$30)*$E7*$C7))","v":""},{"$f":"IF($B7=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D7,Scoring!Y$5:Y$30)*$E7*$C7))","v":""}]
[null,{"$f":"Scoring!B8","v":"Economic"},{"$f":"IF(COUNTBLANK(B8)=0,VLOOKUP(B8,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C8","v":"Economic growth and investment"},{"$f":"IF(B8=\"\",\"\",VLOOKUP(D8,'MCA indicator weighting'!D34:S45,16,FALSE))","v":0.5},8.3333333333333329E-2,{"$f":"IF($B8=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!E$5:E$30)*$E8*$C8))","v":0.25},{"$f":"IF($B8=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!F$5:F$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!G$5:G$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!H$5:H$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!I$5:I$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!J$5:J$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!K$5:K$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!L$5:L$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!M$5:M$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!N$5:N$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!O$5:O$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!P$5:P$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!Q$5:Q$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!R$5:R$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!S$5:S$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!T$5:T$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!U$5:U$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!V$5:V$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!W$5:W$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!X$5:X$30)*$E8*$C8))","v":""},{"$f":"IF($B8=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D8,Scoring!Y$5:Y$30)*$E8*$C8))","v":""}]
[null,{"$f":"Scoring!B9","v":"Economic"},{"$f":"IF(COUNTBLANK(B9)=0,VLOOKUP(B9,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C9","v":"Damages and costs (property, assets and operations)"},{"$f":"IF(B9=\"\",\"\",VLOOKUP(D9,'MCA indicator weighting'!D35:S46,16,FALSE))","v":0.5},8.3333333333333329E-2,{"$f":"IF($B9=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!E$5:E$30)*$E9*$C9))","v":0.25},{"$f":"IF($B9=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!F$5:F$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!G$5:G$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!H$5:H$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!I$5:I$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!J$5:J$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!K$5:K$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!L$5:L$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!M$5:M$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!N$5:N$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!O$5:O$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!P$5:P$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!Q$5:Q$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!R$5:R$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!S$5:S$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!T$5:T$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!U$5:U$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!V$5:V$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!W$5:W$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!X$5:X$30)*$E9*$C9))","v":""},{"$f":"IF($B9=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D9,Scoring!Y$5:Y$30)*$E9*$C9))","v":""}]
[null,{"$f":"Scoring!B10","v":"Environmental and cultural heritage impact"},{"$f":"IF(COUNTBLANK(B10)=0,VLOOKUP(B10,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C10","v":"Overall impact on fauna connectivity (fish passage/fauna movement) "},{"$f":"IF(B10=\"\",\"\",VLOOKUP(D10,'MCA indicator weighting'!D36:S47,16,FALSE))","v":0.33333333333333331},5.5555555555555552E-2,{"$f":"IF($B10=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!E$5:E$30)*$E10*$C10))","v":0.16666666666666666},{"$f":"IF($B10=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!F$5:F$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!G$5:G$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!H$5:H$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!I$5:I$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!J$5:J$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!K$5:K$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!L$5:L$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!M$5:M$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!N$5:N$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!O$5:O$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!P$5:P$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!Q$5:Q$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!R$5:R$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!S$5:S$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!T$5:T$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!U$5:U$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!V$5:V$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!W$5:W$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!X$5:X$30)*$E10*$C10))","v":""},{"$f":"IF($B10=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D10,Scoring!Y$5:Y$30)*$E10*$C10))","v":""}]
[null,{"$f":"Scoring!B11","v":"Environmental and cultural heritage impact"},{"$f":"IF(COUNTBLANK(B11)=0,VLOOKUP(B11,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C11","v":"Overall impacts to vegetation and habitat"},{"$f":"IF(B11=\"\",\"\",VLOOKUP(D11,'MCA indicator weighting'!D37:S48,16,FALSE))","v":0.33333333333333331},5.5555555555555552E-2,{"$f":"IF($B11=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!E$5:E$30)*$E11*$C11))","v":0.16666666666666666},{"$f":"IF($B11=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!F$5:F$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!G$5:G$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!H$5:H$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!I$5:I$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!J$5:J$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!K$5:K$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!L$5:L$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!M$5:M$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!N$5:N$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!O$5:O$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!P$5:P$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!Q$5:Q$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!R$5:R$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!S$5:S$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!T$5:T$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!U$5:U$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!V$5:V$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!W$5:W$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!X$5:X$30)*$E11*$C11))","v":""},{"$f":"IF($B11=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D11,Scoring!Y$5:Y$30)*$E11*$C11))","v":""}]
[null,{"$f":"Scoring!B12","v":"Environmental and cultural heritage impact"},{"$f":"IF(COUNTBLANK(B12)=0,VLOOKUP(B12,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C12","v":"Impact on cultural heritage sites"},{"$f":"IF(B12=\"\",\"\",VLOOKUP(D12,'MCA indicator weighting'!D38:S49,16,FALSE))","v":0.33333333333333331},5.5555555555555552E-2,{"$f":"IF($B12=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!E$5:E$30)*$E12*$C12))","v":0.16666666666666666},{"$f":"IF($B12=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!F$5:F$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!G$5:G$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!H$5:H$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!I$5:I$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!J$5:J$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!K$5:K$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!L$5:L$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!M$5:M$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!N$5:N$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!O$5:O$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!P$5:P$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!Q$5:Q$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!R$5:R$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!S$5:S$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!T$5:T$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!U$5:U$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!V$5:V$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!W$5:W$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!X$5:X$30)*$E12*$C12))","v":""},{"$f":"IF($B12=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D12,Scoring!Y$5:Y$30)*$E12*$C12))","v":""}]
[null,{"$f":"Scoring!B13","v":"Social"},{"$f":"IF(COUNTBLANK(B13)=0,VLOOKUP(B13,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C13","v":"Disruption to daily life"},{"$f":"IF(B13=\"\",\"\",VLOOKUP(D13,'MCA indicator weighting'!D39:S50,16,FALSE))","v":0.5},8.3333333333333329E-2,{"$f":"IF($B13=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!E$5:E$30)*$E13*$C13))","v":0.25},{"$f":"IF($B13=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!F$5:F$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!G$5:G$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!H$5:H$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!I$5:I$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!J$5:J$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!K$5:K$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!L$5:L$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!M$5:M$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!N$5:N$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!O$5:O$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!P$5:P$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!Q$5:Q$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!R$5:R$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!S$5:S$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!T$5:T$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!U$5:U$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!V$5:V$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!W$5:W$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!X$5:X$30)*$E13*$C13))","v":""},{"$f":"IF($B13=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D13,Scoring!Y$5:Y$30)*$E13*$C13))","v":""}]
[null,{"$f":"Scoring!B14","v":"Social"},{"$f":"IF(COUNTBLANK(B14)=0,VLOOKUP(B14,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C14","v":"Additional community benefits"},{"$f":"IF(B14=\"\",\"\",VLOOKUP(D14,'MCA indicator weighting'!D40:S51,16,FALSE))","v":0.5},8.3333333333333329E-2,{"$f":"IF($B14=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!E$5:E$30)*$E14*$C14))","v":0.25},{"$f":"IF($B14=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!F$5:F$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!G$5:G$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!H$5:H$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!I$5:I$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!J$5:J$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!K$5:K$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!L$5:L$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!M$5:M$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!N$5:N$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!O$5:O$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!P$5:P$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!Q$5:Q$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!R$5:R$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!S$5:S$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!T$5:T$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!U$5:U$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!V$5:V$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!W$5:W$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!X$5:X$30)*$E14*$C14))","v":""},{"$f":"IF($B14=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D14,Scoring!Y$5:Y$30)*$E14*$C14))","v":""}]
[null,{"$f":"Scoring!B15","v":"Flood behaviour/impact"},{"$f":"IF(COUNTBLANK(B15)=0,VLOOKUP(B15,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C15","v":"Flood impacts"},{"$f":"IF(B15=\"\",\"\",VLOOKUP(D15,'MCA indicator weighting'!D41:S52,16,FALSE))","v":1},0.16666666666666666,{"$f":"IF($B15=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!E$5:E$30)*$E15*$C15))","v":0.5},{"$f":"IF($B15=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!F$5:F$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!G$5:G$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!H$5:H$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!I$5:I$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!J$5:J$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!K$5:K$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!L$5:L$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!M$5:M$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!N$5:N$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!O$5:O$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!P$5:P$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!Q$5:Q$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!R$5:R$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!S$5:S$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!T$5:T$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!U$5:U$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!V$5:V$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!W$5:W$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!X$5:X$30)*$E15*$C15))","v":""},{"$f":"IF($B15=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D15,Scoring!Y$5:Y$30)*$E15*$C15))","v":""}]
[null,{"$f":"Scoring!B16","v":"Additional constraints"},{"$f":"IF(COUNTBLANK(B16)=0,VLOOKUP(B16,'MCA criteria weighting'!$D$7:$M$12,10,FALSE),\"\")","v":0.16666666666666666},{"$f":"Scoring!C16","v":"Engineering/construction constraints"},{"$f":"IF(B16=\"\",\"\",VLOOKUP(D16,'MCA indicator weighting'!D42:S53,16,FALSE))","v":1},0.16666666666666666,{"$f":"IF($B16=\"\",\"\",IF(G$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!E$5:E$30)*$E16*$C16))","v":0.5},{"$f":"IF($B16=\"\",\"\",IF(H$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!F$5:F$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(I$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!G$5:G$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(J$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!H$5:H$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(K$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!I$5:I$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(L$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!J$5:J$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(M$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!K$5:K$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(N$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!L$5:L$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(O$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!M$5:M$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(P$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!N$5:N$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(Q$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!O$5:O$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(R$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!P$5:P$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(S$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!Q$5:Q$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(T$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!R$5:R$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(U$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!S$5:S$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(V$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!T$5:T$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(W$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!U$5:U$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(X$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!V$5:V$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(Y$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!W$5:W$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(Z$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!X$5:X$30)*$E16*$C16))","v":""},{"$f":"IF($B16=\"\",\"\",IF(AA$4=\"\",\"\",AVERAGEIF(Scoring!$C$5:$C$37,$D16,Scoring!Y$5:Y$30)*$E16*$C16))","v":""}]
[null,"Overall Score",null,null,null,null,{"$f":"IF(COUNT(G16)=1,SUM(G5:G16),\"\")","v":3},{"$f":"IF(COUNT(H16)=1,SUM(H5:H16),\"\")","v":""},{"$f":"IF(COUNT(I16)=1,SUM(I5:I16),\"\")","v":""},{"$f":"IF(COUNT(J16)=1,SUM(J5:J16),\"\")","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(COUNT(AA16)=1,SUM(AA5:AA16),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(B27=\"\",\"\",VLOOKUP(D27,'MCA indicator weighting'!D53:S64,16,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(B28=\"\",\"\",VLOOKUP(D28,'MCA indicator weighting'!D54:S65,16,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(B29=\"\",\"\",VLOOKUP(D29,'MCA indicator weighting'!D55:S66,16,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(B30=\"\",\"\",VLOOKUP(D30,'MCA indicator weighting'!D56:S67,16,FALSE))","v":""}]
[null,null,null,null,{"$f":"IF(B31=\"\",\"\",VLOOKUP(D31,'MCA indicator weighting'!D57:S68,16,FALSE))","v":""}]

{"sheet":"Sensitivity","index":10,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,1,31,2],[32,1,32,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[30,1,30,2],[19,1,19,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[20,1,20,2],[12,1,12,2],[13,1,13,2],[1,1,1,5],[17,1,17,2],[18,1,18,2],[3,2,3,4],[4,4,10,4]]}
[]
[null,"Sensitivity Testing\nConduct sensitivity testing by adjusting the weightings of the assessment criteria to determine the impact on the results. \n\nTo ensure apprioriate sensitivity results are calculated, the sum of the criteria weightings must equal 100%. \n"]
[]
[null,"Criteria","Weighting"]
[null,"Safety",null,{"$f":"C5/3","v":0},{"$f":"IF($C$11=100%,\"\",\"Criteria weighting does not total 100%\")","v":"Criteria weighting does not total 100%"}]
[null,"Economic",null,{"$f":"C6/2","v":0}]
[null,"Environmental and cultural heritage impacts",null,{"$f":"C7/3","v":0}]
[null,"Social",null,{"$f":"C8/2","v":0}]
[null,"Flood behaviour/impact",null,{"$f":"C9","v":0}]
[null,"Additional constraints",null,{"$f":"C10","v":0}]
[null,"Total",{"$f":"SUM(C5:C10)","v":0}]
[]
[null,"Option",null,"Overall Score","Overall Score","Rank","New Score","New Rank"]
[null,{"$f":"Results!$B$22","v":""},null,{"$f":"IF(Results!B22=\"\",\"\",Results!I22)","v":""},{"$f":"IF(Results!$B$22=\"\",\"\",Results!$I$22)","v":""},{"$f":"Results!$J$22","v":""},{"$f":"IF(Results!$B$22=\"\",\"\",'Sensitivity Calc'!$F$17)","v":""},{"$f":"IF(Results!$B22=\"\",\"\",'Sensitivity Calc'!F$18)","v":""}]
[null,{"$f":"Results!$B$23","v":""},null,{"$f":"IF(Results!B23=\"\",\"\",Results!I23)","v":""},{"$f":"IF(Results!$B$23=\"\",\"\",Results!$I$23)","v":""},{"$f":"Results!$J$23","v":""},{"$f":"IF(Results!$B$23=\"\",\"\",'Sensitivity Calc'!$G$17)","v":""},{"$f":"IF(Results!$B$23=\"\",\"\",'Sensitivity Calc'!$G$18)","v":""}]
[null,{"$f":"Results!$B$24","v":""},null,{"$f":"IF(Results!B24=\"\",\"\",Results!I24)","v":""},{"$f":"IF(Results!$B$24=\"\",\"\",Results!$I$24)","v":""},{"$f":"Results!$J$24","v":""},{"$f":"IF(Results!$B$24=\"\",\"\",'Sensitivity Calc'!$H$17)","v":""},{"$f":"IF(Results!$B$24=\"\",\"\",'Sensitivity Calc'!$H$18)","v":""}]
[null,{"$f":"Results!$B$25","v":""},null,{"$f":"IF(Results!B25=\"\",\"\",Results!I25)","v":""},{"$f":"IF(Results!$B$25=\"\",\"\",Results!$I$25)","v":""},{"$f":"Results!$J$25","v":""},{"$f":"IF(Results!$B$25=\"\",\"\",'Sensitivity Calc'!$I$17)","v":""},{"$f":"IF(Results!$B$25=\"\",\"\",'Sensitivity Calc'!$I$18)","v":""}]
[null,{"$f":"Results!$B$26","v":""},null,{"$f":"IF(Results!B26=\"\",\"\",Results!I26)","v":""},{"$f":"IF(Results!$B$26=\"\",\"\",Results!$I$26)","v":""},{"$f":"Results!$J$26","v":""},{"$f":"IF(Results!$B$26=\"\",\"\",'Sensitivity Calc'!$J$17)","v":""},{"$f":"IF(Results!$B$26=\"\",\"\",'Sensitivity Calc'!$J$18)","v":""}]
[null,{"$f":"Results!$B$27","v":""},null,{"$f":"IF(Results!B27=\"\",\"\",Results!I27)","v":""},{"$f":"IF(Results!$B$27=\"\",\"\",Results!$I$27)","v":""},{"$f":"Results!$J$27","v":""},{"$f":"IF(Results!$B$27=\"\",\"\",'Sensitivity Calc'!$K$17)","v":""},{"$f":"IF(Results!$B$27=\"\",\"\",'Sensitivity Calc'!$K$18)","v":""}]
[null,{"$f":"Results!$B$28","v":""},null,{"$f":"IF(Results!B28=\"\",\"\",Results!I28)","v":""},{"$f":"IF(Results!$B$28=\"\",\"\",Results!$I$28)","v":""},{"$f":"Results!$J$28","v":""},{"$f":"IF(Results!$B$28=\"\",\"\",'Sensitivity Calc'!$L$17)","v":""},{"$f":"IF(Results!$B$28=\"\",\"\",'Sensitivity Calc'!$L$18)","v":""}]
[null,{"$f":"Results!$B$29","v":""},null,{"$f":"IF(Results!B29=\"\",\"\",Results!I29)","v":""},{"$f":"IF(Results!$B$29=\"\",\"\",Results!$I$29)","v":""},{"$f":"Results!$J$29","v":""},{"$f":"IF(Results!$B$29=\"\",\"\",'Sensitivity Calc'!$M$17)","v":""},{"$f":"IF(Results!$B$29=\"\",\"\",'Sensitivity Calc'!$M$18)","v":""}]
[null,{"$f":"Results!$B$30","v":""},null,{"$f":"IF(Results!B30=\"\",\"\",Results!I30)","v":""},{"$f":"IF(Results!$B$30=\"\",\"\",Results!$I$30)","v":""},{"$f":"Results!$J$30","v":""},{"$f":"IF(Results!$B$30=\"\",\"\",'Sensitivity Calc'!$N$17)","v":""},{"$f":"IF(Results!$B$30=\"\",\"\",'Sensitivity Calc'!$N$18)","v":""}]
[null,{"$f":"Results!$B$31","v":""},null,{"$f":"IF(Results!B31=\"\",\"\",Results!I31)","v":""},{"$f":"IF(Results!$B$31=\"\",\"\",Results!$I$31)","v":""},{"$f":"Results!$J$31","v":""},{"$f":"IF(Results!$B$31=\"\",\"\",'Sensitivity Calc'!$O$17)","v":""},{"$f":"IF(Results!$B$31=\"\",\"\",'Sensitivity Calc'!$O$18)","v":""}]
[null,{"$f":"Results!$B$32","v":""},null,{"$f":"IF(Results!B32=\"\",\"\",Results!I32)","v":""},{"$f":"IF(Results!$B$32=\"\",\"\",Results!$I$32)","v":""},{"$f":"Results!$J$32","v":""},{"$f":"IF(Results!$B$32=\"\",\"\",'Sensitivity Calc'!$P$17)","v":""},{"$f":"IF(Results!$B$32=\"\",\"\",'Sensitivity Calc'!$P$18)","v":""}]
[null,{"$f":"Results!$B$33","v":""},null,{"$f":"IF(Results!B33=\"\",\"\",Results!I33)","v":""},{"$f":"IF(Results!$B$33=\"\",\"\",Results!$I$33)","v":""},{"$f":"Results!$J$33","v":""},{"$f":"IF(Results!$B$33=\"\",\"\",'Sensitivity Calc'!$Q$17)","v":""},{"$f":"IF(Results!$B$33=\"\",\"\",'Sensitivity Calc'!$Q$18)","v":""}]
[null,{"$f":"Results!$B$34","v":""},null,{"$f":"IF(Results!B34=\"\",\"\",Results!I34)","v":""},{"$f":"IF(Results!$B$34=\"\",\"\",Results!$I$34)","v":""},{"$f":"Results!$J$34","v":""},{"$f":"IF(Results!$B$34=\"\",\"\",'Sensitivity Calc'!$R$17)","v":""},{"$f":"IF(Results!$B$34=\"\",\"\",'Sensitivity Calc'!$R$18)","v":""}]
[null,{"$f":"Results!$B$35","v":""},null,{"$f":"IF(Results!B35=\"\",\"\",Results!I35)","v":""},{"$f":"IF(Results!$B$35=\"\",\"\",Results!$I$35)","v":""},{"$f":"Results!$J$35","v":""},{"$f":"IF(Results!$B$35=\"\",\"\",'Sensitivity Calc'!$S$17)","v":""},{"$f":"IF(Results!$B$35=\"\",\"\",'Sensitivity Calc'!$S$18)","v":""}]
[null,{"$f":"Results!$B$36","v":""},null,{"$f":"IF(Results!B36=\"\",\"\",Results!I36)","v":""},{"$f":"IF(Results!$B$36=\"\",\"\",Results!$I$36)","v":""},{"$f":"Results!$J$36","v":""},{"$f":"IF(Results!$B$36=\"\",\"\",'Sensitivity Calc'!$T$17)","v":""},{"$f":"IF(Results!$B$36=\"\",\"\",'Sensitivity Calc'!$T$18)","v":""}]
[null,{"$f":"Results!$B$37","v":""},null,{"$f":"IF(Results!B37=\"\",\"\",Results!I37)","v":""},{"$f":"IF(Results!$B$37=\"\",\"\",Results!$I$37)","v":""},{"$f":"Results!$J$37","v":""},{"$f":"IF(Results!$B$37=\"\",\"\",'Sensitivity Calc'!$U$17)","v":""},{"$f":"IF(Results!$B$37=\"\",\"\",'Sensitivity Calc'!$U$18)","v":""}]
[null,{"$f":"Results!$B$38","v":""},null,{"$f":"IF(Results!B38=\"\",\"\",Results!I38)","v":""},{"$f":"IF(Results!$B$38=\"\",\"\",Results!$I$38)","v":""},{"$f":"Results!$J$38","v":""},{"$f":"IF(Results!$B$38=\"\",\"\",'Sensitivity Calc'!$V$17)","v":""},{"$f":"IF(Results!$B$38=\"\",\"\",'Sensitivity Calc'!$V$18)","v":""}]
[null,{"$f":"Results!$B$39","v":""},null,{"$f":"IF(Results!B39=\"\",\"\",Results!I39)","v":""},{"$f":"IF(Results!$B$39=\"\",\"\",Results!$I$39)","v":""},{"$f":"Results!$J$39","v":""},{"$f":"IF(Results!$B$39=\"\",\"\",'Sensitivity Calc'!$W$17)","v":""},{"$f":"IF(Results!$B$39=\"\",\"\",'Sensitivity Calc'!$W$18)","v":""}]
[null,{"$f":"Results!$B$40","v":""},null,{"$f":"IF(Results!B40=\"\",\"\",Results!I40)","v":""},{"$f":"IF(Results!$B$40=\"\",\"\",Results!$I$40)","v":""},{"$f":"Results!$J$40","v":""},{"$f":"IF(Results!$B$40=\"\",\"\",'Sensitivity Calc'!X17)","v":""},{"$f":"IF(Results!$B$40=\"\",\"\",'Sensitivity Calc'!$X$18)","v":""}]
[null,{"$f":"Results!$B$41","v":""},null,{"$f":"IF(Results!B41=\"\",\"\",Results!I41)","v":""},{"$f":"IF(Results!$B$41=\"\",\"\",Results!$I$41)","v":""},{"$f":"Results!$J$41","v":""},{"$f":"IF(Results!$B$41=\"\",\"\",'Sensitivity Calc'!$Y$17)","v":""},{"$f":"IF(Results!$B$41=\"\",\"\",'Sensitivity Calc'!$Y$18)","v":""}]

{"sheet":"Sensitivity Calc","index":11,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,{"$f":"TRANSPOSE('Multi-criteria assessment'!$E$7:$E$26)","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,"Criteria","Targeted Indicator","Pairwise Comparison","Base Case",{"$f":"IF(F3=0,\"\",F3)","v":""},{"$f":"IF(G3=0,\"\",G3)","v":""},"","","","","","","","","","","","","","","","","",""]
[null,{"$f":"'Targeted indicators'!B9","v":"Safety"},{"$f":"'Targeted indicators'!C9","v":"Ability to evacuate to safer locations or evacuation centres"},{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!G$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!H$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!I$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!J$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!K$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!L$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!M$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!N$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!O$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!P$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!Q$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!R$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!S$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!T$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!U$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!V$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!W$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!X$5*Sensitivity!$D$5","v":0},{"$f":"Scoring!Y$5*Sensitivity!$D$5","v":0}]
[null,{"$f":"'Targeted indicators'!B10","v":"Safety"},{"$f":"'Targeted indicators'!C10","v":"Population at risk"},{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!G$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!H$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!I$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!J$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!K$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!L$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!M$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!N$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!O$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!P$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!Q$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!R$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!S$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!T$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!U$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!V$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!W$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!X$6*Sensitivity!$D$5","v":0},{"$f":"Scoring!Y$6*Sensitivity!$D$5","v":0}]
[null,{"$f":"'Targeted indicators'!B11","v":"Safety"},{"$f":"'Targeted indicators'!C11","v":"Isolation duration and risk"},{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!G$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!H$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!I$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!J$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!K$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!L$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!M$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!N$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!O$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!P$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!Q$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!R$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!S$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!T$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!U$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!V$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!W$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!X$7*Sensitivity!$D$5","v":0},{"$f":"Scoring!Y$7*Sensitivity!$D$5","v":0}]
[null,{"$f":"'Targeted indicators'!B12","v":"Economic"},{"$f":"'Targeted indicators'!C12","v":"Economic growth and investment"},{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!G$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!H$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!I$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!J$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!K$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!L$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!M$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!N$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!O$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!P$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!Q$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!R$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!S$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!T$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!U$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!V$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!W$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!X$8*Sensitivity!$D$6","v":0},{"$f":"Scoring!Y$8*Sensitivity!$D$6","v":0}]
[null,{"$f":"'Targeted indicators'!B13","v":"Economic"},{"$f":"'Targeted indicators'!C13","v":"Damages and costs (property, assets and operations)"},{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!G$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!H$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!I$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!J$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!K$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!L$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!M$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!N$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!O$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!P$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!Q$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!R$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!S$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!T$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!U$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!V$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!W$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!X$9*Sensitivity!$D$6","v":0},{"$f":"Scoring!Y$9*Sensitivity!$D$6","v":0}]
[null,{"$f":"'Targeted indicators'!B14","v":"Environmental and cultural heritage impact"},{"$f":"'Targeted indicators'!C14","v":"Overall impact on fauna connectivity (fish passage/fauna movement) "},{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!G$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!H$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!I$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!J$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!K$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!L$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!M$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!N$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!O$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!P$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!Q$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!R$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!S$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!T$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!U$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!V$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!W$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!X$10*Sensitivity!$D$7","v":0},{"$f":"Scoring!Y$10*Sensitivity!$D$7","v":0}]
[null,{"$f":"'Targeted indicators'!B15","v":"Environmental and cultural heritage impact"},{"$f":"'Targeted indicators'!C15","v":"Overall impacts to vegetation and habitat"},{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!G$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!H$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!I$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!J$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!K$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!L$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!M$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!N$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!O$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!P$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!Q$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!R$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!S$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!T$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!U$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!V$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!W$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!X$11*Sensitivity!$D$7","v":0},{"$f":"Scoring!Y$11*Sensitivity!$D$7","v":0}]
[null,{"$f":"'Targeted indicators'!B16","v":"Environmental and cultural heritage impact"},{"$f":"'Targeted indicators'!C16","v":"Impact on cultural heritage sites"},{"$f":"IF(B12=\"\",\"\",VLOOKUP(B12,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!G$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!H$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!I$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!J$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!K$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!L$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!M$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!N$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!O$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!P$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!Q$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!R$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!S$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!T$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!U$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!V$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!W$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!X$12*Sensitivity!$D$7","v":0},{"$f":"Scoring!Y$12*Sensitivity!$D$7","v":0}]
[null,{"$f":"'Targeted indicators'!B17","v":"Social"},{"$f":"'Targeted indicators'!C17","v":"Disruption to daily life"},{"$f":"IF(B13=\"\",\"\",VLOOKUP(B13,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!G$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!H$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!I$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!J$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!K$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!L$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!M$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!N$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!O$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!P$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!Q$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!R$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!S$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!T$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!U$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!V$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!W$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!X$13*Sensitivity!$D$8","v":0},{"$f":"Scoring!Y$13*Sensitivity!$D$8","v":0}]
[null,{"$f":"'Targeted indicators'!B18","v":"Social"},{"$f":"'Targeted indicators'!C18","v":"Additional community benefits"},{"$f":"IF(B14=\"\",\"\",VLOOKUP(B14,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!G$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!H$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!I$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!J$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!K$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!L$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!M$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!N$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!O$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!P$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!Q$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!R$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!S$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!T$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!U$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!V$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!W$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!X$14*Sensitivity!$D$8","v":0},{"$f":"Scoring!Y$14*Sensitivity!$D$8","v":0}]
[null,{"$f":"'Targeted indicators'!B19","v":"Flood behaviour/impact"},{"$f":"'Targeted indicators'!C19","v":"Flood impacts"},{"$f":"IF(B15=\"\",\"\",VLOOKUP(B15,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!G$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!H$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!I$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!J$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!K$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!L$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!M$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!N$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!O$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!P$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!Q$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!R$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!S$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!T$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!U$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!V$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!W$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!X$15*Sensitivity!$D$9","v":0},{"$f":"Scoring!Y$15*Sensitivity!$D$9","v":0}]
[null,{"$f":"'Targeted indicators'!B20","v":"Additional constraints"},{"$f":"'Targeted indicators'!C20","v":"Engineering/construction constraints"},{"$f":"IF(B16=\"\",\"\",VLOOKUP(B16,'MCA criteria weighting'!$D$7:$M$36,10,FALSE))","v":0.16666666666666666},3,{"$f":"Scoring!F$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!G$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!H$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!I$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!J$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!K$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!L$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!M$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!N$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!O$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!P$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!Q$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!R$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!S$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!T$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!U$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!V$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!W$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!X$16*Sensitivity!$D$10","v":0},{"$f":"Scoring!Y$16*Sensitivity!$D$10","v":0}]
[null,null,"Total",{"$f":"IF(B17=\"\",\"\",VLOOKUP(C17,'MCA criteria weighting'!D29:M48,24,FALSE))","v":""},{"$f":"IF($C17=\"\",\"\",3)","v":3},{"$f":"ROUND(SUM(F$5:F$16),2)","v":0},0,0,0,0,0,{"$f":"ROUND(SUM(L$5:L$16),2)","v":0},{"$f":"ROUND(SUM(M$5:M$16),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Rank",{"$f":"IF(B18=\"\",\"\",VLOOKUP(C18,'MCA criteria weighting'!D30:M49,24,FALSE))","v":""},3,{"$f":"IF(F$17<>0,RANK(F$17,$F$17:$Y$17,0),\"\")","v":""},{"$f":"IF(G$17<>0,RANK(G$17,$F$17:$Y$17,0),\"\")","v":""},"","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B19=\"\",\"\",VLOOKUP(C19,'MCA criteria weighting'!D31:M50,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(C20,'MCA criteria weighting'!D32:M51,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B21=\"\",\"\",VLOOKUP(C21,'MCA criteria weighting'!D33:M52,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B22=\"\",\"\",VLOOKUP(C22,'MCA criteria weighting'!D34:M53,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B23=\"\",\"\",VLOOKUP(C23,'MCA criteria weighting'!D35:M54,24,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B24=\"\",\"\",VLOOKUP(C24,'MCA criteria weighting'!D36:M55,24,FALSE))","v":""},"","","","","",null,"","","","","","","","","","","","","","",""]
[null,null,null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(C25,'MCA criteria weighting'!D37:M56,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B26=\"\",\"\",VLOOKUP(C26,'MCA criteria weighting'!D38:M57,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B27=\"\",\"\",VLOOKUP(C27,'MCA criteria weighting'!D39:M58,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B28=\"\",\"\",VLOOKUP(C28,'MCA criteria weighting'!D40:M59,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B29=\"\",\"\",VLOOKUP(C29,'MCA criteria weighting'!D41:M60,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B30=\"\",\"\",VLOOKUP(C30,'MCA criteria weighting'!D42:M61,24,FALSE))","v":""}]
[null,null,null,{"$f":"IF(B31=\"\",\"\",VLOOKUP(C31,'MCA criteria weighting'!D43:M62,24,FALSE))","v":""}]

{"sheet":"General Calc","index":12,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["General Calculations and Lists"]
[]
[]
[null,"Pairwise List","Yes/ No List","Grading List","Grading List",null,"Weighting Summary Table",null,null,"Criterion","Pairwise Comparison","Adjusted Weighting",null,null,null,"Difference in Weighting"]
[null,"A","Yes","Indicator Met","Cost is practical",null,"Criterion","Pairwise Comparison",null,null,null,-0.5,-0.25,0.25,0.5,-0.5,-0.25,0.25,0.5]
[null,"B","No","Not met","Cost is not practical",null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G6))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G6)))","v":"Safety"},{"$f":"IF($G6=\"\",\"\",INDEX('MCA criteria weighting'!$M$7:$M$12,MATCH($G6,'MCA criteria weighting'!$D$7:$D$12,0)))","v":0.16666666666666666},null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J6))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J6)))","v":"Safety"},{"$f":"IF($J6=\"\",\"\",INDEX($H$6:$H$25,MATCH($G28,$G$6:$G$25,0),MATCH($K$4,$H$5:$H$5,0)))","v":0.16666666666666666},{"$f":"IF($J6=\"\",\"\",$K6*(1+L$5))","v":8.3333333333333329E-2},0.125,0.20833333333333331,0.25,{"$f":"IF($J6=\"\",\"\",L6-$K6)","v":-8.3333333333333329E-2},{"$f":"IF($J6=\"\",\"\",M6-$K6)","v":-4.1666666666666657E-2},4.1666666666666657E-2,8.3333333333333343E-2]
[null,"C",null,"More information","More information",null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G7))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G7)))","v":"Economic"},{"$f":"IF($G7=\"\",\"\",INDEX('MCA criteria weighting'!$M$7:$M$12,MATCH($G7,'MCA criteria weighting'!$D$7:$D$12,0)))","v":0.16666666666666666},null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J7))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J7)))","v":"Economic"},0.16666666666666666,8.3333333333333329E-2,0.125,0.20833333333333331,0.25,{"$f":"IF($J7=\"\",\"\",L7-$K7)","v":-8.3333333333333329E-2},{"$f":"IF($J7=\"\",\"\",M7-$K7)","v":-4.1666666666666657E-2},{"$f":"IF($J7=\"\",\"\",N7-$K7)","v":4.1666666666666657E-2},{"$f":"IF($J7=\"\",\"\",O7-$K7)","v":8.3333333333333343E-2}]
[null,"D",null,"Select","Select",null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G8))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G8)))","v":"Environmental and cultural heritage impact"},{"$f":"IF($G8=\"\",\"\",INDEX('MCA criteria weighting'!$M$7:$M$12,MATCH($G8,'MCA criteria weighting'!$D$7:$D$12,0)))","v":0.16666666666666666},null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J8))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J8)))","v":"Environmental and cultural heritage impact"},0.16666666666666666,8.3333333333333329E-2,0.125,0.20833333333333331,0.25,-8.3333333333333329E-2,-4.1666666666666657E-2,4.1666666666666657E-2,8.3333333333333343E-2]
[null,"E",null,null,null,null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G9))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G9)))","v":"Social"},{"$f":"IF($G9=\"\",\"\",INDEX('MCA criteria weighting'!$M$7:$M$12,MATCH($G9,'MCA criteria weighting'!$D$7:$D$12,0)))","v":0.16666666666666666},null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J9))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J9)))","v":"Social"},0.16666666666666666,8.3333333333333329E-2,0.125,0.20833333333333331,0.25,-8.3333333333333329E-2,-4.1666666666666657E-2,4.1666666666666657E-2,8.3333333333333343E-2]
[null,"F",null,null,null,null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G10))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G10)))","v":"Flood behaviour/impact"},{"$f":"IF($G10=\"\",\"\",INDEX('MCA criteria weighting'!$M$7:$M$12,MATCH($G10,'MCA criteria weighting'!$D$7:$D$12,0)))","v":0.16666666666666666},null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J10))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J10)))","v":"Flood behaviour/impact"},0.16666666666666666,8.3333333333333329E-2,0.125,0.20833333333333331,0.25,-8.3333333333333329E-2,-4.1666666666666657E-2,4.1666666666666657E-2,8.3333333333333343E-2]
[null,"G","Eliminate option",null,null,null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G11))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$6:$G11)))","v":"Additional constraints"},{"$f":"IF($G11=\"\",\"\",INDEX('MCA criteria weighting'!$M$7:$M$12,MATCH($G11,'MCA criteria weighting'!$D$7:$D$12,0)))","v":0.16666666666666666},null,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J11))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($J$6:$J11)))","v":"Additional constraints"},0.16666666666666666,8.3333333333333329E-2,0.125,0.20833333333333331,0.25,-8.3333333333333329E-2,-4.1666666666666657E-2,4.1666666666666657E-2,8.3333333333333343E-2]
[null,"H","Progress to MCA"]
[null,"I","Redefine Option"]
[null,"J","Collect further information"]
[null,"K","Select"]
[null,"L"]
[null,"M"]
[null,"N"]
[null,"O"]
[null,"P"]
[null,"Q"]
[null,"R"]
[null,"S"]
[null,"T"]
[]
[null,"Ranks","Ranks Remaining"]
[null,1,1,1,null,null,-0.5,"Pairwise Comparison",{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:I$27))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:I$27)))","v":"Safety"},{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:J$27))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:J$27)))","v":"Economic"},{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:K$27))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:K$27)))","v":"Environmental and cultural heritage impact"},{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:L$27))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:L$27)))","v":"Social"},{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:M$27))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:M$27)))","v":"Flood behaviour/impact"},{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:N$27))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,COLUMNS($I$27:N$27)))","v":"Additional constraints"}]
[null,2,2,2,null,-0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G28))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G28)))","v":"Safety"},{"$f":"IF($G28=\"\",\"\",INDEX($H$6:$H$25,MATCH($G28,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0)))","v":0.16666666666666666},{"$f":"IF(OR($G28=\"\",I$27=\"\"),\"\",IF($G28=I$27,INDEX($L$6:$O$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$28,$L$5:$O$5,0)),$H28-($H28/(1-INDEX($H$6:$H$25,MATCH(I$27,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0))))*INDEX($P$6:$S$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$28,$P$5:$S$5,0))))","v":8.3333333333333329E-2},{"$f":"IF(OR($G28=\"\",J$27=\"\"),\"\",IF($G28=J$27,INDEX($L$6:$O$25,MATCH(J$27,$J$6:$J$25,0),MATCH($F$28,$L$5:$O$5,0)),$H28-($H28/(1-INDEX($H$6:$H$25,MATCH(J$27,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0))))*INDEX($P$6:$S$25,MATCH(J$27,$J$6:$J$25,0),MATCH($F$28,$P$5:$S$5,0))))","v":0.18333333333333332},0.18333333333333332,0.18333333333333332,0.18333333333333332,0.18333333333333332]
[null,3,3,3,null,-0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G29))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G29)))","v":"Economic"},0.16666666666666666,{"$f":"IF(OR($G29=\"\",I$27=\"\"),\"\",IF($G29=I$27,INDEX($L$6:$O$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$28,$L$5:$O$5,0)),$H29-($H29/(1-INDEX($H$6:$H$25,MATCH(I$27,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0))))*INDEX($P$6:$S$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$28,$P$5:$S$5,0))))","v":0.18333333333333332},8.3333333333333329E-2,0.18333333333333332,0.18333333333333332,0.18333333333333332,0.18333333333333332]
[null,4,4,4,null,-0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G30))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G30)))","v":"Environmental and cultural heritage impact"},0.16666666666666666,0.18333333333333332,0.18333333333333332,8.3333333333333329E-2,0.18333333333333332,0.18333333333333332,0.18333333333333332]
[null,5,5,5,null,-0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G31))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G31)))","v":"Social"},0.16666666666666666,0.18333333333333332,0.18333333333333332,0.18333333333333332,8.3333333333333329E-2,0.18333333333333332,0.18333333333333332]
[null,6,"",null,null,-0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G32))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G32)))","v":"Flood behaviour/impact"},0.16666666666666666,0.18333333333333332,0.18333333333333332,0.18333333333333332,0.18333333333333332,8.3333333333333329E-2,0.18333333333333332]
[null,7,"",null,null,-0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G33))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$28:$G33)))","v":"Additional constraints"},0.16666666666666666,0.18333333333333332,0.18333333333333332,0.18333333333333332,0.18333333333333332,0.18333333333333332,8.3333333333333329E-2]
[null,8,"",null,null,-0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G34))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G34)))","v":"Safety"},{"$f":"IF($G34=\"\",\"\",INDEX($H$6:$H$25,MATCH($G34,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0)))","v":0.16666666666666666},{"$f":"IF(OR($G34=\"\",I$27=\"\"),\"\",IF($G34=I$27,INDEX($L$6:$O$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$34,$L$5:$O$5,0)),$H34-($H34/(1-INDEX($H$6:$H$25,MATCH(I$27,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0))))*INDEX($P$6:$S$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$34,$P$5:$S$5,0))))","v":0.125},0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999]
[null,9,"",null,null,-0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G35))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G35)))","v":"Economic"},{"$f":"IF($G35=\"\",\"\",INDEX($H$6:$H$25,MATCH($G35,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0)))","v":0.16666666666666666},0.17499999999999999,0.125,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999]
[null,10,"",null,null,-0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G36))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G36)))","v":"Environmental and cultural heritage impact"},0.16666666666666666,0.17499999999999999,0.17499999999999999,0.125,0.17499999999999999,0.17499999999999999,0.17499999999999999]
[null,11,"",null,null,-0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G37))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G37)))","v":"Social"},0.16666666666666666,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.125,0.17499999999999999,0.17499999999999999]
[null,12,"",null,null,-0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G38))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G38)))","v":"Flood behaviour/impact"},0.16666666666666666,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.125,0.17499999999999999]
[null,13,"",null,null,-0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G39))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$34:$G39)))","v":"Additional constraints"},0.16666666666666666,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.17499999999999999,0.125]
[null,14,"",null,null,0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G40))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G40)))","v":"Safety"},{"$f":"IF($G40=\"\",\"\",INDEX($H$6:$H$25,MATCH($G40,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0)))","v":0.16666666666666666},{"$f":"IF(OR($G40=\"\",I$27=\"\"),\"\",IF($G40=I$27,INDEX($L$6:$O$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$40,$L$5:$O$5,0)),$H40-($H40/(1-INDEX($H$6:$H$25,MATCH(I$27,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0))))*INDEX($P$6:$S$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$40,$P$5:$S$5,0))))","v":0.20833333333333331},0.15833333333333333,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.15833333333333333]
[null,15,"",null,null,0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G41))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G41)))","v":"Economic"},{"$f":"IF($G41=\"\",\"\",INDEX($H$6:$H$25,MATCH($G41,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0)))","v":0.16666666666666666},0.15833333333333333,0.20833333333333331,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.15833333333333333]
[null,16,"",null,null,0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G42))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G42)))","v":"Environmental and cultural heritage impact"},0.16666666666666666,0.15833333333333333,0.15833333333333333,0.20833333333333331,0.15833333333333333,0.15833333333333333,0.15833333333333333]
[null,17,"",null,null,0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G43))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G43)))","v":"Social"},0.16666666666666666,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.20833333333333331,0.15833333333333333,0.15833333333333333]
[null,18,"",null,null,0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G44))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G44)))","v":"Flood behaviour/impact"},0.16666666666666666,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.20833333333333331,0.15833333333333333]
[null,19,"",null,null,0.25,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G45))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$40:$G45)))","v":"Additional constraints"},0.16666666666666666,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.15833333333333333,0.20833333333333331]
[null,20,"",null,null,0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G46))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G46)))","v":"Safety"},{"$f":"IF($G46=\"\",\"\",INDEX($H$6:$H$25,MATCH($G46,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0)))","v":0.16666666666666666},{"$f":"IF(OR($G46=\"\",I$27=\"\"),\"\",IF($G46=I$27,INDEX($L$6:$O$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$46,$L$5:$O$5,0)),$H46-($H46/(1-INDEX($H$6:$H$25,MATCH(I$27,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0))))*INDEX($P$6:$S$25,MATCH(I$27,$J$6:$J$25,0),MATCH($F$46,$P$5:$S$5,0))))","v":0.25},0.15,0.15,0.15,0.15,0.15]
[null,null,null,null,null,0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G47))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G47)))","v":"Economic"},{"$f":"IF($G47=\"\",\"\",INDEX($H$6:$H$25,MATCH($G47,$G$6:$G$25,0),MATCH($H$27,$H$5:$H$5,0)))","v":0.16666666666666666},0.15,0.25,0.15,0.15,0.15,0.15]
[null,null,null,null,null,0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G48))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G48)))","v":"Environmental and cultural heritage impact"},0.16666666666666666,0.15,0.15,0.25,0.15,0.15,0.15]
[null,null,null,null,null,0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G49))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G49)))","v":"Social"},0.16666666666666666,0.15,0.15,0.15,0.25,0.15,0.15]
[null,null,null,null,null,0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G50))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G50)))","v":"Flood behaviour/impact"},0.16666666666666666,0.15,0.15,0.15,0.15,0.25,0.15]
[null,null,null,null,null,0.5,{"$f":"IF(INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G51))=0,\"\",INDEX('MCA criteria weighting'!$D$7:$D$12,ROWS($G$46:$G51)))","v":"Additional constraints"},0.16666666666666666,0.15,0.15,0.15,0.15,0.15,0.25]