{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["START HERE","1. Methodology Overview","2. Assessment Criteria","3. Matrix Overview","4. Instructions","5. Examples of Policy Scoring","6. Example of a Scored Plan"," Scoring Matrix Template V3.1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":27,"comments":5,"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":"START HERE","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1. Methodology Overview","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2. Assessment Criteria","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"3. Matrix Overview","index":3,"n_rows":22,"n_cols":35,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,32,4,32],[4,5,4,8],[3,27,4,27],[3,28,4,28],[3,29,4,29],[3,30,4,30],[3,31,4,31],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,26,4,26],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[5,5,5,8],[3,4,4,4],[3,9,4,9],[3,10,4,10],[3,11,4,11],[15,5,15,8],[16,5,16,8],[18,5,18,8],[19,5,19,8],[20,5,20,8],[15,2,15,3],[16,2,16,3],[1,1,5,3],[1,4,1,32],[2,4,2,9],[2,10,2,16],[2,17,2,18],[2,19,2,24],[2,25,2,27],[2,28,2,29],[2,30,2,32],[6,1,7,1],[8,1,9,1],[10,1,11,1],[12,1,13,1],[15,1,16,1],[18,2,18,3],[18,23,18,24],[19,2,19,3],[19,23,19,24],[19,25,19,26],[19,29,19,30],[19,31,19,32],[20,2,20,3],[20,23,20,24],[20,25,20,26],[20,27,20,28],[20,29,20,30],[20,31,20,32],[19,27,19,28],[21,23,21,24],[21,25,21,26],[21,27,21,28],[21,29,21,30],[21,31,21,32]]}
[]
[null,"Plan Name \n(+ date of publication)",null,null,"Green Infrastructure Design Elements"]
[null,null,null,null,"Policy Plan Mainstreaming",null,null,null,null,null,"Development integration",null,null,null,null,null,null,"Biodiversity/ Habitats",null,"Physical Environment",null,null,null,null,null,"Access Networks",null,null,"Greenspace",null,"Stewardship"]
[null,null,null,null,"Supportive of GI investment","economic policy","social policy","health policy","climate policy","GI policy outside Env. Policy","Early/integral design","Early engagement","Multi-functional land use","Natural Capital & ES","Off-site analysis","On-site survey","GI Network","Enhance biodiversity","Habitat networks","Watercourses as GI","SUDS as multifunctional GI","Naturalised SUDS","Access to waterbodies","Aesthetic of waterbodies","Ameliorate air quality","Active travel links","Links to wider networks","Recreational routes","Open space standards","Multi-user design","Agreed management","Functional maintenance","Resourcing mechanisms"]
[null,null,null,null,null,"GI benefits in"]
[null,null,null,null,"A","B",null,null,null,"C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
[null,"Chapter, Policy Name or Reference",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K7:AG7)","v":0}]
[null,null,{"$f":"C7","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K8:AG8)","v":0}]
[null,"Chapter, Policy Name or Reference",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C9","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Chapter, Policy Name or Reference",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C11","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Chapter, Policy Name or Reference",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"C13","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Overall Scores\nare automatically calculated in these rows","Coverage",null,{"$f":"MAX(IF(C7:C15=\"I\",IF(D7:D15=\"Coverage\",E7:E15,)))","v":0},{"$f":"IF(SUMIF(D7:D15,\"Coverage\",I7:I15)/12>0.75,3,IF(SUMIF(D7:D15,\"Coverage\",I7:I15)/12>=0.5,2,IF(SUMIF(D7:D15,\"Coverage\",I7:I15)/12>=0.2,1,0)))","v":0},null,null,null,{"$f":"IF(AI16/69>=0.7,3,IF(AI16/69>=0.5,2,IF(AI16/69>=0.2,1,0)))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",K$7:K$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",L$7:L$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",M$7:M$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",N$7:N$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",O$7:O$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",P$7:P$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",Q$7:Q$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",R$7:R$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",S$7:S$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",T$7:T$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",U$7:U$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",V$7:V$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",W$7:W$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",X$7:X$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",Y$7:Y$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",Z$7:Z$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",AA$7:AA$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",AB$7:AB$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",AC$7:AC$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",AD$7:AD$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",AE$7:AE$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",AF$7:AF$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Coverage\",AG$7:AG$15))","v":0},null,{"$f":"(SUMIF(D7:D15,\"Coverage\",AH7:AH15)-(SUMIFS(AH7:AH15,C7:C15,\"E\",D7:D15,\"Coverage\")))","v":0}]
[null,null,"Strength",null,{"$f":"MAX(IF(C7:C15=\"I\",IF(D7:D15=\"Strength\",E7:E15,)))","v":0},{"$f":"IF(SUMIF(D7:D15,\"Strength\",I7:I15)/12>0.75,3,IF(SUMIF(D7:D15,\"Strength\",I7:I15)/12>=0.5,2,IF(SUMIF(D7:D15,\"Strength\",I7:I15)/12>=0.2,1,0)))","v":0},null,null,null,{"$f":"IF(AI17/69>=0.7,3,IF(AI17/69>=0.5,2,IF(AI17/69>=0.2,1,0)))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",K$7:K$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",L$7:L$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",M$7:M$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",N$7:N$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",O$7:O$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",P$7:P$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",Q$7:Q$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",R$7:R$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",S$7:S$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",T$7:T$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",U$7:U$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",V$7:V$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",W$7:W$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",X$7:X$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",Y$7:Y$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",Z$7:Z$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",AA$7:AA$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",AB$7:AB$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",AC$7:AC$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",AD$7:AD$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",AE$7:AE$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",AF$7:AF$15))","v":0},{"$f":"MAX(IF($D$7:$D$15=\"Strength\",AG$7:AG$15))","v":0},null,{"$f":"(SUMIF(D7:D15,\"Strength\",AH7:AH15)-(SUMIFS(AH7:AH15,C7:C15,\"E\",D7:D15,\"Strength\")))","v":0}]
[]
[null,null,"Total (Max=78)",null,"Score","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGEND"]
[null,null,"Coverage",null,{"$f":"SUM(E16:AG16)","v":0},{"$f":"E20/78","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coverage",null,"None",null,"Some",null,"Most",null,"Full"]
[null,null,"Strength",null,{"$f":"SUM(E17:AG17)","v":0},{"$f":"E21/78","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,0,null,1,null,2,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strength",null,"None",null,"Weak",null,"Medium",null,"Strong"]

{"sheet":"4. Instructions","index":4,"n_rows":21,"n_cols":34,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,31,3,31],[3,4,3,7],[2,26,3,26],[2,27,3,27],[2,28,3,28],[2,29,3,29],[2,30,3,30],[2,21,3,21],[2,22,3,22],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[4,4,4,7],[2,3,3,3],[2,8,3,8],[2,9,3,9],[2,10,3,10],[14,4,14,7],[15,4,15,7],[17,4,17,7],[18,4,18,7],[19,4,19,7],[14,1,14,2],[15,1,15,2],[0,0,4,2],[0,3,0,31],[1,3,1,8],[1,9,1,15],[1,16,1,17],[1,18,1,23],[1,24,1,26],[1,27,1,28],[1,29,1,31],[5,0,6,0],[7,0,8,0],[9,0,10,0],[11,0,12,0],[14,0,15,0],[17,22,17,23],[18,30,18,31],[19,1,19,2],[19,22,19,23],[19,24,19,25],[19,26,19,27],[19,28,19,29],[19,30,19,31],[17,1,17,2],[18,1,18,2],[18,22,18,23],[18,24,18,25],[18,26,18,27],[18,28,18,29],[20,22,20,23],[20,24,20,25],[20,26,20,27],[20,28,20,29],[20,30,20,31]]}
["Plan Name \n(+ date of publication)",null,null,"Green Infrastructure Design Elements"]
[null,null,null,"Policy Plan Mainstreaming",null,null,null,null,null,"Development integration",null,null,null,null,null,null,"Biodiversity/ Habitats",null,"Physical Environment",null,null,null,null,null,"Access Networks",null,null,"Greenspace",null,"Stewardship"]
[null,null,null,"Supportive of GI investment","economic policy","social policy","health policy","climate policy","GI policy outside Env. Policy","Early/integral design","Early engagement","Multi-functional land use","Natural Capital & ES","Off-site analysis","On-site survey","GI Network","Enhance biodiversity","Habitat networks","Watercourses as GI","SUDS as multifunctional GI","Naturalised SUDS","Access to waterbodies","Aesthetic of waterbodies","Ameliorate air quality","Active travel links","Links to wider networks","Recreational routes","Open space standards","Multi-user design","Agreed management","Functional maintenance","Resourcing mechanisms"]
[null,null,null,null,"GI benefits in"]
[null,null,null,"A","B",null,null,null,"C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
["Chapter, or Section Heading",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:AF6)","v":0}]
[null,{"$f":"B6","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:AF7)","v":0}]
["Chapter, or Section Heading",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B8","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter, or Section Heading",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B10","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter, or Section Heading",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B12","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Highest Scores","Coverage",null,{"$f":"MAX(IF(B6:B14=\"I\",IF(C6:C14=\"Coverage\",D6:D14,)))","v":0},{"$f":"IF(SUMIF(C6:C14,\"Coverage\",H6:H14)/12>0.75,3,IF(SUMIF(C6:C14,\"Coverage\",H6:H14)/12>=0.5,2,IF(SUMIF(C6:C14,\"Coverage\",H6:H14)/12>=0.2,1,0)))","v":0},null,null,null,{"$f":"IF(AH15/69>=0.7,3,IF(AH15/69>=0.5,2,IF(AH15/69>=0.2,1,0)))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",J$6:J$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",K$6:K$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",L$6:L$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",M$6:M$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",N$6:N$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",O$6:O$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",P$6:P$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",Q$6:Q$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",R$6:R$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",S$6:S$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",T$6:T$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",U$6:U$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",V$6:V$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",W$6:W$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",X$6:X$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",Y$6:Y$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",Z$6:Z$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",AA$6:AA$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",AB$6:AB$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",AC$6:AC$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",AD$6:AD$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",AE$6:AE$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Coverage\",AF$6:AF$14))","v":0},null,{"$f":"(SUMIF(C6:C14,\"Coverage\",AG6:AG14)-(SUMIFS(AG6:AG14,B6:B14,\"E\",C6:C14,\"Coverage\")))","v":0}]
[null,"Strength",null,{"$f":"MAX(IF(B6:B14=\"I\",IF(C6:C14=\"Strength\",D6:D14,)))","v":0},{"$f":"IF(SUMIF(C6:C14,\"Strength\",H6:H14)/12>0.75,3,IF(SUMIF(C6:C14,\"Strength\",H6:H14)/12>=0.5,2,IF(SUMIF(C6:C14,\"Strength\",H6:H14)/12>=0.2,1,0)))","v":0},null,null,null,{"$f":"IF(AH16/69>=0.7,3,IF(AH16/69>=0.5,2,IF(AH16/69>=0.2,1,0)))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",J$6:J$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",K$6:K$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",L$6:L$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",M$6:M$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",N$6:N$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",O$6:O$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",P$6:P$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",Q$6:Q$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",R$6:R$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",S$6:S$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",T$6:T$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",U$6:U$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",V$6:V$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",W$6:W$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",X$6:X$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",Y$6:Y$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",Z$6:Z$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",AA$6:AA$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",AB$6:AB$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",AC$6:AC$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",AD$6:AD$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",AE$6:AE$14))","v":0},{"$f":"MAX(IF($C$6:$C$14=\"Strength\",AF$6:AF$14))","v":0},null,{"$f":"(SUMIF(C6:C14,\"Strength\",AG6:AG14)-(SUMIFS(AG6:AG14,B6:B14,\"E\",C6:C14,\"Strength\")))","v":0}]
[]
[null,"Total (Max=78)",null,"Score","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGEND"]
[null,"Coverage",null,{"$f":"SUM(D15:AF15)","v":0},{"$f":"D19/78","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coverage",null,"None",null,"Some",null,"Most",null,"Full"]
[null,"Strength",null,{"$f":"SUM(D16:AF16)","v":0},{"$f":"D20/78","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,0,null,1,null,2,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strength",null,"None",null,"Weak",null,"Medium",null,"Strong"]

{"sheet":"5. Examples of Policy Scoring","index":5,"n_rows":17,"n_cols":31,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,21,16,22],[16,23,16,24],[16,25,16,26],[16,27,16,28],[16,29,16,30],[14,23,14,24],[14,25,14,26],[14,27,14,28],[14,29,14,30],[15,21,15,22],[15,23,15,24],[15,25,15,26],[15,27,15,28],[15,29,15,30],[14,21,14,22],[9,0,11,0],[13,21,13,22],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[4,3,4,6],[5,0,7,0],[2,20,3,20],[0,0,4,1],[0,2,0,30],[1,2,1,7],[1,8,1,14],[1,15,1,16],[1,17,1,22],[1,23,1,25],[1,26,1,27],[1,28,1,30],[2,2,3,2],[2,30,3,30],[2,19,3,19],[2,21,3,21],[2,22,3,22],[2,28,3,28],[2,29,3,29],[3,3,3,6],[2,26,3,26],[2,27,3,27],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,12,3,12]]}
[null,null,"Green Infrastructure Design Elements"]
[null,null,"Policy Plan Mainstreaming",null,null,null,null,null,"Development integration",null,null,null,null,null,null,"Biodiversity/ Habitats",null,"Physical Environment",null,null,null,null,null,"Access Networks",null,null,"Greenspace",null,"Stewardship"]
[null,null,"Supportive of GI investment","economic policy","social policy","health policy","climate policy","GI policy outside Env. Policy","Early/integral design","Early engagement","Multi-functional land use","Natural Capital & ES","Off-site analysis","On-site survey","GI Network","Enhance biodiversity","Habitat networks","Watercourses as GI","SUDS as multifunctional GI","Naturalised SUDS","Access to waterbodies","Aesthetic of waterbodies","Ameliorate air quality","Active travel links","Links to wider networks","Recreational routes","Open space standards","Multi-user design","Agreed management","Functional maintenance","Resourcing mechanisms"]
[null,null,null,"GI benefits in"]
[null,null,"A","B",null,null,null,"C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
["Coverage","Full criterion coverage",3,null,3,3,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,"Most criterion coverage",null,null,null,null,null,null,null,2,2,2,null,2,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Some criterion coverage",null,1,null,null,null,null,1,1,1,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["Strength","Strong policy wording",null,null,null,null,null,null,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,"Medium policy wording",null,null,null,null,null,null,2,null,2,2,2,2,2,2,null,2,null,null,null,null,2,null,2,null,null,2]
[null,"Weak policy wording",null,null,null,null,null,null,1,1,1,null,1,1,1,1,1,1,1,1,1,1,null,1,1,1,1,1,1,1,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGEND"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coverage",null,"None",null,"Some",null,"Most",null,"Full"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,0,null,1,null,2,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strength",null,"None",null,"Weak",null,"Medium",null,"Strong"]

{"sheet":"6. Example of a Scored Plan","index":6,"n_rows":49,"n_cols":34,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,28,3,28],[2,29,3,29],[2,30,3,30],[2,31,3,31],[3,4,3,7],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,26,3,26],[2,27,3,27],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,3,17],[42,4,42,7],[43,4,43,7],[45,4,45,7],[46,4,46,7],[47,4,47,7],[5,0,6,0],[17,0,18,0],[15,0,16,0],[13,0,14,0],[23,0,24,0],[42,1,42,2],[43,1,43,2],[7,0,8,0],[9,0,10,0],[11,0,12,0],[19,0,20,0],[21,0,22,0],[0,0,4,2],[0,3,0,31],[1,3,1,8],[1,9,1,15],[1,16,1,17],[1,18,1,23],[1,24,1,26],[1,27,1,28],[1,29,1,31],[4,4,4,7],[2,3,3,3],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[25,0,26,0],[27,0,28,0],[31,0,32,0],[33,0,34,0],[39,0,40,0],[42,0,43,0],[29,0,30,0],[35,0,36,0],[37,0,38,0],[45,1,45,2],[45,22,45,23],[46,1,46,2],[46,22,46,23],[46,24,46,25],[46,28,46,29],[46,30,46,31],[47,1,47,2],[47,22,47,23],[47,24,47,25],[47,26,47,27],[47,28,47,29],[47,30,47,31],[46,26,46,27],[48,22,48,23],[48,24,48,25],[48,26,48,27],[48,28,48,29],[48,30,48,31]]}
["National Planning & Policy Framework, July 2018",null,null,"Green Infrastructure Design Elements"]
[null,null,null,"Policy Plan Mainstreaming",null,null,null,null,null,"Development integration",null,null,null,null,null,null,"Biodiversity/ Habitats",null,"Physical Environment",null,null,null,null,null,"Access Networks",null,null,"Greenspace",null,"Stewardship"]
[null,null,null,"Supportive of GI investment","economic policy","social policy","health policy","climate policy","GI policy outside Env. Policy","Early/integral design","Early engagement","Multi-functional land use","Natural Capital & ES","Off-site analysis","On-site survey","GI Network","Enhance biodiversity","Habitat networks","Watercourses as GI","SUDS as multifunctional GI","Naturalised SUDS","Access to waterbodies","Aesthetic of waterbodies","Ameliorate air quality","Active travel links","Links to wider networks","Recreational routes","Open space standards","Multi-user design","Agreed management","Functional maintenance","Resourcing mechanisms"]
[null,null,null,null,"GI benefits in"]
[null,null,null,"A","B",null,null,null,"C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
["Chapter 1: \nIntroduction",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:AF6)","v":0}]
[null,{"$f":"B6","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:AF7)","v":0}]
["Chapter 2: \nAchieving Sustainable Development\nParagraph 8 & 9","I","Coverage",1,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,{"$f":"SUM(J8:AF8)","v":4}]
[null,{"$f":"B8","v":"I"},"Strength",1,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,{"$f":"SUM(J9:AF9)","v":4}]
["Chapter 3:\nPlan-making\nParagraph 20d & 34","I","Coverage",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B10","v":"I"},"Strength",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter 4:\nDecision-making\nParagraph 39, 41, 42 & 43","I","Coverage",null,null,null,null,null,null,1,2,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,{"$f":"B12","v":"I"},"Strength",null,null,null,null,null,null,1,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Chapter 5:\nDelivering a sufficient supply of homes\n",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B14","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter 6:\nBuilding a strong, competitive economy",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B16","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter 7:\nEnsuring the vitality of town centres\n",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J18:AF18)","v":0}]
[null,{"$f":"B18","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter 8:\nPromoting healthy & safe communities\nParagraph 91a, 92a, 92e, 96, 98",null,"Coverage",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,2,1,null,null,null,6]
[null,{"$f":"B20","v":0},"Strength",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,2,1,null,null,null,6]
["Chapter 9:\nPromoting sustainable transport\nParagraph 102c, 104d, 110c",null,"Coverage",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,2]
[null,{"$f":"B22","v":0},"Strength",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,2]
["Chapter 10:\nSupporting high quality communications",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J24:AF24)","v":0}]
[null,{"$f":"B24","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter 11:\nMaking effective use of land\nParagraph 117, 118a/b","I","Coverage",1,null,null,null,null,null,null,null,2,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,5]
[null,{"$f":"B26","v":"I"},"Strength",1,null,null,null,null,null,null,null,2,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,5]
["Chapter 12:\nAchieving well-designed places\nParagraph 127b/c/e, 128",null,"Coverage",null,null,null,null,null,null,2,3,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,{"$f":"B28","v":0},"Strength",null,null,null,null,null,null,2,2,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["Chapter 13:\nProtecting green belt land",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B30","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter 14:\nMeeting the challenge of climate change, flooding and coastal change\nParagraph 150a, 163, 165d",null,"Coverage",null,null,null,null,null,null,null,null,null,null,1,1,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,{"$f":"B32","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,1,1,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Chapter 15\nConserving and enhancing the natural environment\nParagraph 170a/b/d, 171, 174a/b, 175b, 181","E","Coverage",null,null,null,null,null,null,null,null,null,3,null,1,3,3,3,null,null,null,null,null,3,null,null,null,null,null,null,null,null,16]
[null,{"$f":"B34","v":"E"},"Strength",null,null,null,null,null,null,null,null,null,2,null,1,2,2,2,null,null,null,null,null,2,null,null,null,null,null,null,null,null,11]
["Chapter 16\nConserving and enhancing the historic environment",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J36:AF36)","v":0}]
[null,{"$f":"B36","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Chapter 17\nFacilitating the sustainable use of minerals",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J38:AF38)","v":0}]
[null,{"$f":"B38","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Annex 2:\nGlossary\nGreen Infrastructure",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B40","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Overall Scores","Coverage",null,{"$f":"MAX(IF(B8:B42=\"I\",IF(C8:C42=\"Coverage\",D8:D42,)))","v":1},{"$f":"IF(SUMIF(C8:C42,\"Coverage\",H8:H42)/12>0.75,3,IF(SUMIF(C8:C42,\"Coverage\",H8:H42)/12>=0.5,2,IF(SUMIF(C8:C42,\"Coverage\",H8:H42)/12>=0.2,1,0)))","v":0},null,null,null,{"$f":"IF(AH43/69>=0.7,3,IF(AH43/69>=0.5,2,IF(AH43/69>=0.2,1,0)))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",J$8:J$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",K$8:K$42))","v":3},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",L$8:L$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",M$8:M$42))","v":3},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",N$8:N$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",O$8:O$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",P$8:P$42))","v":3},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",Q$8:Q$42))","v":3},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",R$8:R$42))","v":3},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",S$8:S$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",T$8:T$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",U$8:U$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",V$8:V$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",W$8:W$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",X$8:X$42))","v":3},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",Y$8:Y$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",Z$8:Z$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",AA$8:AA$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",AB$8:AB$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",AC$8:AC$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",AD$8:AD$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",AE$8:AE$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Coverage\",AF$8:AF$42))","v":0},null,{"$f":"(SUMIF(C8:C42,\"Coverage\",AG8:AG42)-(SUMIFS(AG8:AG42,B8:B42,\"E\",C8:C42,\"Coverage\")))","v":31}]
[null,"Strength",null,{"$f":"MAX(IF(B8:B42=\"I\",IF(C8:C42=\"Strength\",D8:D42,)))","v":1},{"$f":"IF(SUMIF(C8:C42,\"Strength\",H8:H42)/12>0.75,3,IF(SUMIF(C8:C42,\"Strength\",H8:H42)/12>=0.5,2,IF(SUMIF(C8:C42,\"Strength\",H8:H42)/12>=0.2,1,0)))","v":0},null,null,null,{"$f":"IF(AH44/69>=0.7,3,IF(AH44/69>=0.5,2,IF(AH44/69>=0.2,1,0)))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",J$8:J$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",K$8:K$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",L$8:L$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",M$8:M$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",N$8:N$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",O$8:O$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",P$8:P$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",Q$8:Q$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",R$8:R$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",S$8:S$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",T$8:T$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",U$8:U$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",V$8:V$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",W$8:W$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",X$8:X$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",Y$8:Y$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",Z$8:Z$42))","v":1},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",AA$8:AA$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",AB$8:AB$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",AC$8:AC$42))","v":2},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",AD$8:AD$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",AE$8:AE$42))","v":0},{"$f":"MAX(IF($C$8:$C$42=\"Strength\",AF$8:AF$42))","v":0},null,{"$f":"(SUMIF(C8:C42,\"Strength\",AG8:AG42)-(SUMIFS(AG8:AG42,B8:B42,\"E\",C8:C42,\"Strength\")))","v":29}]
[]
[null,"Total (Max=78)",null,"Score","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGEND"]
[null,"Coverage",null,{"$f":"SUM(D43:AF43)","v":34},{"$f":"D47/78","v":0.4358974358974359},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coverage",null,"None",null,"Some",null,"Most",null,"Full"]
[null,"Strength",null,{"$f":"SUM(D44:AF44)","v":28},{"$f":"D48/78","v":0.35897435897435898},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,0,null,1,null,2,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strength",null,"None",null,"Weak",null,"Medium",null,"Strong"]

{"sheet":" Scoring Matrix Template V3.1","index":7,"n_rows":27,"n_cols":34,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,28,25,29],[25,30,25,31],[24,26,24,27],[26,22,26,23],[26,24,26,25],[26,26,26,27],[26,28,26,29],[26,30,26,31],[24,24,24,25],[25,1,25,2],[25,4,25,7],[25,22,25,23],[25,24,25,25],[25,26,25,27],[23,4,23,7],[24,28,24,29],[24,30,24,31],[11,0,12,0],[20,0,21,0],[13,0,14,0],[15,0,16,0],[3,4,3,7],[4,4,4,7],[23,22,23,23],[24,1,24,2],[24,4,24,7],[24,22,24,23],[20,1,20,2],[20,4,20,7],[21,1,21,2],[21,4,21,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[23,1,23,2],[5,0,6,0],[7,0,8,0],[9,0,10,0],[2,13,3,13],[0,0,4,2],[0,3,0,31],[1,3,1,8],[1,29,1,31],[2,3,3,3],[2,30,3,30],[2,31,3,31],[2,20,3,20],[2,21,3,21],[2,22,3,22],[1,9,1,15],[1,16,1,17],[2,29,3,29],[2,14,3,14],[1,18,1,23],[1,24,1,26],[1,27,1,28],[2,27,3,27],[2,28,3,28],[2,26,3,26],[2,23,3,23],[2,24,3,24],[2,25,3,25],[2,15,3,15],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,19,3,19]]}
["MALDON DISTRICT\nApproved\nLocal Development Plan\n2014 – 2029                              July 2017",null,null,"Green Infrastructure Design Elements"]
[null,null,null,"Policy Plan Mainstreaming",null,null,null,null,null,"Development integration",null,null,null,null,null,null,"Biodiversity/ Habitats",null,"Physical Environment",null,null,null,null,null,"Access Networks",null,null,"Greenspace",null,"Stewardship"]
[null,null,null,"Supportive of GI investment","economic policy","social policy","health policy","climate policy","GI policy outside Env. Policy","Early/integral design","Early engagement","Multi-functional land use","Natural Capital & ES","Off-site analysis","On-site survey","GI Network","Enhance biodiversity","Habitat networks","Watercourses as GI","SUDS as multifunctional GI","Naturalised SUDS","Access to waterbodies","Aesthetic of waterbodies","Ameliorate air quality","Active travel links","Links to wider networks","Recreational routes","Open space standards","Multi-user design","Agreed management","Functional maintenance","Resourcing mechanisms"]
[null,null,null,null,"GI benefits in "]
[null,null,null,"A","B",null,null,null,"C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]
["Chpater 1 Introduction Paragraph 1.3","I","Coverage",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J6:AF6)","v":0}]
[null,{"$f":"B6","v":"I"},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:AF7)","v":0}]
["Chapter 2, Spatial Vision & Development Strategy Spatial Vision 2.4, Objectives 2.5, Policy S1, Policy S3, Policy S4  and Policy Clarification 2.60 - 2.64, Policy S5 and Policy Clarification 2.78, Policy S6, Policy S7, Policy S8","I","Coverage",1,null,1,null,1,null,1,null,null,null,1,1,2,2,1,null,null,null,1,1,null,2,3,1,null,1,1,null,null,18]
[null,{"$f":"B8","v":"I"},"Strength",null,null,null,null,null,null,1,null,null,null,1,1,2,1,1,null,null,null,1,1,null,1,3,1,null,1,1,null,null,16]
["Chapter 3 Design & Climate Change, Policy D1, Policy D2, Policy Context for D5 3.53 and Policy D5 \n",null,"Coverage",null,null,null,null,3,null,null,null,null,null,null,null,null,2,null,null,1,2,1,2,1,null,null,null,null,1,null,null,null,10]
[null,{"$f":"B10","v":0},"Strength",null,null,null,null,2,null,null,null,null,null,null,null,null,2,null,null,1,1,1,1,1,null,null,null,null,1,null,null,null,8]
["Chapter 6 National Environment and Green Infrastructure Policy Context for N1 6.2, 6.6.64, Policy N1 & Policy Clarification 6.8, 6.9, Policy N2 & Policy Clarification 6.12,6.15, 6.19, Policy Clarification 6.26 for Policy N3","E","Coverage",null,null,null,null,null,null,1,1,2,null,2,1,2,3,null,1,null,null,null,null,null,2,3,2,1,1,2,null,1,25]
[null,{"$f":"B12","v":"E"},"Strength",null,null,null,null,null,null,1,1,2,null,2,1,2,2,null,1,null,null,null,null,null,2,3,1,1,null,1,null,1,21]
["Chapter 7 Transport and Access Policy T2\nAccessibility",null,"Coverage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,{"$f":"SUM(J14:AF14)","v":1}]
[null,{"$f":"B14","v":0},"Strength",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,1]
["Chapter 8 Implementation and Monitoring Policy I1, Policy Clarification 8.2,8.4,8.10-13 and Policy  I2\n",null,"Coverage",null,null,null,null,null,null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,1,null,1,8]
[null,{"$f":"B16","v":0},"Strength",null,null,null,null,null,null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,1,null,1,6]
[]
[null,null,null,null,{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",E$6:E$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",F$6:F$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",G$6:G$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",H$6:H$18))","v":3}]
[null,null,null,null,{"$f":"MAX(IF($C$6:$C$18=\"Strength\",E$6:E$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",F$6:F$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",G$6:G$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",H$6:H$18))","v":2}]
["Overall Scores","Coverage",null,{"$f":"MAX(IF(B6:B18=\"I\",IF(C6:C18=\"Coverage\",D6:D18,)))","v":1},{"$f":"IF(SUM(E19:H19)/12>0.75,3,IF(SUM(E19:H19)/12>=0.5,2,IF(SUM(E19:H19)/12>=0.2,1,0)))","v":1},null,null,null,{"$f":"IF(AH21/69>=0.7,3,IF(AH21/69>=0.5,2,IF(AH21/69>=0.2,1,0)))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",J$6:J$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",K$6:K$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",L$6:L$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",M$6:M$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",N$6:N$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",O$6:O$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",P$6:P$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",Q$6:Q$18))","v":3},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",R$6:R$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",S$6:S$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",T$6:T$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",U$6:U$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",V$6:V$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",W$6:W$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",X$6:X$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",Y$6:Y$18))","v":3},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",Z$6:Z$18))","v":3},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",AA$6:AA$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",AB$6:AB$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",AC$6:AC$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",AD$6:AD$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",AE$6:AE$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Coverage\",AF$6:AF$18))","v":1},null,{"$f":"IF(COUNTIF(B6:B18,\"E\"),(SUMIF(C6:C18,\"Coverage\",AG6:AG18)-(SUMIFS(AG6:AG18,B6:B18,\"E\",C6:C18,\"Coverage\"))),0)","v":37}]
[null,"Strength",null,{"$f":"MAX(IF(B6:B18=\"I\",IF(C6:C18=\"Strength\",D6:D18,)))","v":0},{"$f":"IF(SUM(E20:H20)/12>0.75,3,IF(SUM(E20:H20)/12>=0.5,2,IF(SUM(E20:H20)/12>=0.2,1,0)))","v":0},null,null,null,{"$f":"IF(AH22/69>=0.7,3,IF(AH22/69>=0.5,2,IF(AH22/69>=0.2,1,0)))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",J$6:J$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",K$6:K$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",L$6:L$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",M$6:M$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",N$6:N$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",O$6:O$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",P$6:P$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",Q$6:Q$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",R$6:R$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",S$6:S$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",T$6:T$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",U$6:U$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",V$6:V$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",W$6:W$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",X$6:X$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",Y$6:Y$18))","v":2},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",Z$6:Z$18))","v":3},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",AA$6:AA$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",AB$6:AB$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",AC$6:AC$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",AD$6:AD$18))","v":1},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",AE$6:AE$18))","v":0},{"$f":"MAX(IF($C$6:$C$18=\"Strength\",AF$6:AF$18))","v":1},null,{"$f":"IF(COUNTIF(B6:B18,\"E\"),(SUMIF(C6:C18,\"Strength\",AG6:AG18)-(SUMIFS(AG6:AG18,B6:B18,\"E\",C6:C18,\"Strength\"))),0)","v":31}]
[]
[null,"Total (Max=78)",null,"Score","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGEND"]
[null,"Coverage",null,{"$f":"SUM(D21:AF21)","v":39},{"$f":"D25/78","v":0.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coverage",null,"None",null,"Some",null,"Most",null,"Full"]
[null,"Strength",null,{"$f":"SUM(D22:AF22)","v":30},{"$f":"D26/78","v":0.38461538461538464},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score",null,0,null,1,null,2,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strength",null,"None",null,"Weak",null,"Medium",null,"Strong"]