{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Assessment of the NPPF"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Assessment of the NPPF","index":0,"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"]