{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Woodland Benefits Tool","Reporting","Menus","Totals","Calculations","Badges","Chart"],"not_rendered":{"charts":2,"images":13,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Woodland Benefits Tool","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[40,1,41,1],[44,1,45,1],[48,1,49,1],[4,1,5,1],[20,1,21,1],[8,1,9,1],[36,1,37,1],[32,1,33,1],[28,1,29,1],[24,1,25,1],[16,1,17,1],[12,1,13,1]]}
[]
[null," Woodland and biodiversity"," Woodland and water"," Woodland and community"," Woodland and economy"," Calculate scores"]
[]
[null,"Woodland and biodiversity: Goal #1","Question 1.1","Question 1.2"]
[null,"Create a native woodland with the aim of delivering benefits for biodiversity","Has the woodland area been planted mainly with native species or allowed to regenerate naturally?","Has the new woodland been designed with the aim of creating or improving priority habitat?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and biodiversity: Goal #2","Question 2.1","Question 2.2"]
[null,"Create a woodland with a diverse structure in order to deliver benefits for biodiversity","Has the woodland been designed to deliver a suitably diverse and wildlife-friendly structure?","Has the potential for an area of minimum intervention been assessed?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and biodiversity: Goal #3","Question 3.1","Question 3.2"]
[null,"Create a woodland that provides new ecological connections across the landscape","Will the new woodland link to an existing woodland, or otherwise connect valuable habitats?","Is the new woodland in an area of particular significance for biodiversity conservation?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and water: Goal #1","Question 1.1","Question 1.2"]
[null,"Create a woodland that protects and improves the site's aquatic or wetland habitats","Have existing aquatic and wetland habitats been identified and their management appropriately planned for? ","Does the woodland design include new areas of freshwater or wetland habitat?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and water: Goal #2","Question 2.1","Question 2.2"]
[null,"Create a woodland that contributes towards improvements in water quality","Is the new woodland located where it will help to deliver improvements in water quality?","Has the woodland been designed with a focus on delivering improvements in water quality?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and water: Goal #3","Question 3.1","Question 3.2"]
[null,"Create a woodland that contributes towards reductions in flood risk","Is the new woodland located where it will contribute to reductions in flood risk?","Has the woodland been designed with a focus on delivering reductions in flood risk?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and community: Goal #1","Question 1.1","Question 1.2"]
[null,"Create a woodland that is accessible to the community and actively used","Is the woodland located in an area deficient in accessible natural green space?","Is the use of the woodland to be promoted to a range of groups across the community?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and community: Goal #2","Question 2.1","Question 2.2"]
[null,"Create a woodland that is designed to help to meet the needs of the community","Has the woodland been designed in a way that supports community activities?","Have members of the community been involved in the design of the new woodland?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and community: Goal #3","Question 3.1","Question 3.2"]
[null,"Create a woodland that protects health and enhances the character of the area","Will the new woodland help to regulate air quality or temperature?","Will the new woodland complement and enhance the existing landscape or townscape ?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and economy: Goal #1","Question 1.1","Question 1.2"]
[null,"Create a productive woodland that provides goods and materials to the economy ","Has the woodland been designed with timber production as an aim?","Is the new woodland expected to produce woodfuel or other non-timber products? "]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and economy: Goal #2","Question 2.1","Question 2.2"]
[null,"Create woodland that supports local enterprises and economic development","Is the new woodland expected to support local enterprises in the future?","Is the new woodland expected to contribute to rural diversification or urban regeneration?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]
[]
[null,"Woodland and economy: Goal #3","Question 3.1","Question 3.2"]
[null,"Create a woodland that supports volunteering and skills development","Is the woodland expected to provide opportunities for volunteering?","Is the woodland to be used as a place to deliver training and skills?"]
[null,null,"<<Drop down to select answer>>","<<Drop down to select answer>>"]

{"sheet":"Reporting","index":1,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":false,"merged":[[17,1,17,8],[19,1,22,8],[12,5,12,6],[15,5,15,8],[62,10,62,16],[27,1,27,8],[27,10,27,17],[29,10,39,17],[29,1,39,8],[41,1,41,7],[41,10,41,16],[42,1,42,8],[42,10,42,17],[24,1,24,7],[62,1,62,7],[25,1,25,17],[57,1,57,17],[59,1,61,17],[44,1,54,8],[44,10,54,17],[56,1,56,7],[56,10,56,16],[15,1,15,4],[13,1,13,4],[13,5,13,8],[1,12,1,13],[1,14,1,17],[1,10,1,11],[3,1,3,17],[5,10,5,17],[5,1,5,8],[7,1,7,8],[9,1,9,7],[10,1,10,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,"  Export PDF",null,null,null,"  Back to questions"]
[]
[null,"Woodland Benefits Assessment"]
[]
[null,"Name of project",null,null,null,null,null,null,null,null,"Comparative scores"]
[]
[null,"[Insert text here]"]
[]
[null,"Characters remaining:",null,null,null,null,null,null,{"$f":"45-(LEN(B8))","v":27}]
[null,"Scores"]
[]
[null,"Biodiversity",null,{"$f":"Badges!B4","v":0},null,"Community",null,{"$f":"Badges!B14","v":0}]
[null,{"$f":"Badges!B5","v":" "},null,null,null,{"$f":"Badges!B15","v":" "}]
[null,"Water",null,{"$f":"Badges!B9","v":0},null,"Economy",null,{"$f":"Badges!B19","v":0}]
[null,{"$f":"Badges!B10","v":" "},null,null,null,{"$f":"Badges!B20","v":" "}]
[]
[null,"Description of project"]
[" "]
[null,"[Insert text here]"]
[]
[]
[]
[" "]
[null,"Characters remaining:",null,null,null,null,null,null,{"$f":"250-(LEN(B20))","v":232}]
[null,"Supporting commentary"]
[" "]
[null,"Woodland and biodiversity",null,null,null,null,null,null,null,null,"Woodland and water"]
[]
[null,"[Insert text here]",null,null,null,null,null,null,null,null,"[Insert text here]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[null,"Characters remaining:",null,null,null,null,null,null,{"$f":"650-(LEN(B30))","v":632},null,"Characters remaining:",null,null,null,null,null,null,{"$f":"650-(LEN(K30))","v":632}]
[null,"Woodland and community",null,null,null,null,null,null,null,null,"Woodland and economy"]
[]
[null,"[Insert text here]",null,null,null,null,null,null,null,null,"[Insert text here]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[null,"Characters remaining:",null,null,null,null,null,null,{"$f":"650-(LEN(B45))","v":632},null,"Characters remaining:",null,null,null,null,null,null,{"$f":"650-(LEN(K45))","v":632}]
[null,"Unique woodland features"]
[]
[null,"[Insert text here]"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Characters remaining:",null,null,null,null,null,null,{"$f":"300-(LEN(B60))","v":282}]

{"sheet":"Menus","index":2,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Woodland and biodiversity"]
["Goal #1 - Create a native woodland with the aim of delivering biodiversity gains"]
["Question 1.1","Score","Question 1.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Goal #2 - Create a woodland with a diverse structure in order to deliver benefits for biodiversity"]
["Question 2.1","Score","Question 2.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a",0]
["Goal #3 - Create a woodland that provides new ecological connections across the landscape"]
["Question 3.1","Score","Question 3.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Woodland and water"]
["Goal #1 - Create a woodland that protects and improves the sites aquatic or wetland habitats"]
["Question 1.1","Score","Question 1.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Goal #2 - Create a woodland that contributes towards improvements in water quality"]
["Question 2.1","Scores","Question 2.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Goal #3 - Create a woodland that contributes towards reductions in flood risk"]
["Question 3.1","Score","Question 3.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Woodland and community"]
["Goal #1 - Create a woodland that is accessible to the community and actively used"]
["Question 1.1","Score","Question 1.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a",0]
["Goal #2 - Create a woodland that is designed to help to meet the needs of the community"]
["Question 2.1","Score","Question 2.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Goal #3 - Create a woodland that protects health and supports community wellbeing"]
["Question 3.1","Score","Question 3.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Woodland and economy"]
["Goal #1 - Create a productive woodland that provides raw materials to the economy"]
["Question 1.1","Score","Question 1.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a",0]
["Goal #2 - Create woodland with strong links to local enterprise and economic development"]
["Question 2.1","Score","Question 2.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]
["Goal #3 - Create a woodland that supports employment, volunteering, and skills development"]
["Question 3.1","Score","Question 3.2","Score"]
["<<Drop down to select answer>>","-","<<Drop down to select answer>>","-"]
["Yes",20,"Yes",20]
["No or N/a","-","No or N/a","-"]

{"sheet":"Totals","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":true,"merged":[[4,2,6,37],[11,2,13,37],[18,2,20,37],[25,2,27,37]]}
["Woodland and biodiversity"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
["Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available "]
[{"$f":"Menus!B5","v":20},{"$f":"Menus!D5","v":20},{"$f":"Menus!B10","v":20},{"$f":"Menus!D10","v":20},{"$f":"Menus!B15","v":20},{"$f":"Menus!D15","v":20}]
["Total score available:",{"$f":"SUM(A4:F4)","v":120}]
["Total scored:",{"$f":"(SUM(Calculations!A3:F5))","v":0}]
["Percentage scored:",{"$f":"B6/B5","v":0}]
["Woodland and water"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
["Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available "]
[{"$f":"Menus!B21","v":20},{"$f":"Menus!D21","v":20},{"$f":"Menus!B26","v":20},{"$f":"Menus!D26","v":20},{"$f":"Menus!B31","v":20},{"$f":"Menus!D31","v":20}]
["Total score available:",{"$f":"SUM(A11:F11)","v":120}]
["Total scored:",{"$f":"(SUM(Calculations!A8:F10))","v":0}]
["Percentage scored:",{"$f":"B13/B12","v":0}]
["Woodland and community"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
["Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available "]
[{"$f":"Menus!B37","v":20},{"$f":"Menus!D37","v":20},{"$f":"Menus!B42","v":20},{"$f":"Menus!D42","v":20},{"$f":"Menus!B47","v":20},{"$f":"Menus!D47","v":20}]
["Total score available:",{"$f":"SUM(A18:F18)","v":120}]
["Total scored:",{"$f":"(SUM(Calculations!A13:G15))","v":0}]
["Percentage scored:",{"$f":"B20/B19","v":0}]
["Woodland and economy"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
["Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available ","Highest score available "]
[{"$f":"Menus!B53","v":20},{"$f":"Menus!D53","v":20},{"$f":"Menus!B58","v":20},{"$f":"Menus!D58","v":20},{"$f":"Menus!B63","v":20},{"$f":"Menus!D63","v":20}]
["Total score available:",{"$f":"SUM(A25:F25)","v":120}]
["Total scored:",{"$f":"SUM(Calculations!A18:F18)","v":0}]
["Percentage scored:",{"$f":"B27/B26","v":0}]

{"sheet":"Calculations","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Woodland and biodiversity"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
[{"$f":"IF('Woodland Benefits Tool'!C6=Menus!A5,Menus!B5,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D6=Menus!C5,Menus!D5,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C10=Menus!A10,Menus!B10,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D10=Menus!C10,Menus!D10,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C14=Menus!A15,Menus!B15,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D14=Menus!C15,Menus!D15,0)","v":0}]
["-","-","-","-","-","-"]
["-","-","-","-","-","-"]
["Woodland and water"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
[{"$f":"IF('Woodland Benefits Tool'!C18=Menus!A21,Menus!B21,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D18=Menus!C21,Menus!D21,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C22=Menus!A26,Menus!B26,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D22=Menus!C26,Menus!D26,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C26=Menus!A31,Menus!B31,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D26=Menus!C31,Menus!D31,0)","v":0}]
["-","-","-","-","-","-"]
["-","-","-","-","-","-"]
["Woodland and community"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
[{"$f":"IF('Woodland Benefits Tool'!C30=Menus!A37,Menus!B37,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D30=Menus!C37,Menus!D37,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C34=Menus!A42,Menus!B42,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D34=Menus!C42,Menus!D42,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C38=Menus!A47,Menus!B47,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D38=Menus!C47,Menus!D47,0)","v":0}]
["-","-","-","-","-","-"]
["-","-","-","-","-","-"]
["Woodland and economy"]
["Question 1.1","Question 1.2","Question 2.1","Question 2.2","Question 3.1","Question 3.2"]
[{"$f":"IF('Woodland Benefits Tool'!C42=Menus!A53,Menus!B58,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D42=Menus!C53,Menus!D53,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C46=Menus!A58,Menus!B58,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D46=Menus!C58,Menus!D58,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!C50=Menus!A63,Menus!B63,0)","v":0},{"$f":"IF('Woodland Benefits Tool'!D50=Menus!C63,Menus!D63,0)","v":0}]
["-","-","-","-","-","-"]
["-","-","-","-","-","-"]

{"sheet":"Badges","index":5,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[[3,2,4,37],[8,2,9,37],[13,2,14,37],[23,2,24,37],[18,2,19,37]]}
["Woodland and biodiversity"]
["Score:","0-20","21-40","41-60","61-80","81-100"]
[null,{"$f":"IF(Totals!B7<21%,1,0)*AND(IF(Totals!B7>10%,1,0))","v":0},{"$f":"IF(Totals!B7>21%,2,0)","v":0},{"$f":"IF(Totals!B7>41%,3,0)","v":0},{"$f":"IF(Totals!B7>61%,4,0)","v":0},{"$f":"IF(Totals!B7>81%,5,0)","v":0}]
["Badges awarded:",{"$f":"MAX(B3:F3)","v":0}]
["Class:",{"$f":"IF(B4>=4,\"Wildlife haven\",B25)","v":" "}]
["Woodland and water"]
["Score:","0-20","21-40","41-60","61-80","81-100"]
[null,{"$f":"IF(Totals!B14<21%,1,0)*AND(IF(Totals!B14>10%,1,0))","v":0},{"$f":"IF(Totals!B14>21%,2,0)","v":0},{"$f":"IF(Totals!B14>41%,3,0)","v":0},{"$f":"IF(Totals!B14>61%,4,0)","v":0},{"$f":"IF(Totals!B14>81%,5,0)","v":0}]
["Badges awarded:",{"$f":"MAX(B8:F8)","v":0}]
["Class:",{"$f":"IF(B9>=4,\"Freshwater friendly\",B25)","v":" "}]
["Woodland and community"]
["Score:","0-20","21-40","41-60","61-80","81-100"]
[null,{"$f":"IF(Totals!B21<21%,1,0)*AND(IF(Totals!B21>10%,1,0))","v":0},{"$f":"IF(Totals!B21>21%,2,0)","v":0},{"$f":"IF(Totals!B21>41%,3,0)","v":0},{"$f":"IF(Totals!B21>61%,4,0)","v":0},{"$f":"IF(Totals!B21>81%,5,0)","v":0}]
["Badges awarded:",{"$f":"MAX(B13:F13)","v":0}]
["Class:",{"$f":"IF(B14>=4,\"Community asset\",B25)","v":" "}]
["Woodland and economy"]
["Score:","0-20","21-40","41-60","61-80","81-100"]
[null,{"$f":"IF(Totals!B28<21%,1,0)*AND(IF(Totals!B28>10%,1,0))","v":0},{"$f":"IF(Totals!B28>21%,2,0)","v":0},{"$f":"IF(Totals!B28>41%,3,0)","v":0},{"$f":"IF(Totals!B28>61%,4,0)","v":0},{"$f":"IF(Totals!B28>81%,5,0)","v":0}]
["Badges awarded:",{"$f":"MAX(B18:F18)","v":0}]
["Class:",{"$f":"IF(B19>=4,\"Economic driver\",B25)","v":" "}]
["Multi-functional calculation"]
["Wildlife","Water","Community","Economy"]
[{"$f":"IF(B4=3,1,0)","v":0},{"$f":"IF(B9=3,1,0)","v":0},{"$f":"IF(B14=3,1,0)","v":0},{"$f":"IF(B19=3,1,0)","v":0}]
["Total:",{"$f":"SUM(A23:D23)","v":0}]
["Class:",{"$f":"IF(B24=4,\"  Multi-purpose\",\" \")","v":" "}]

{"sheet":"Chart","index":6,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"Totals!A7","v":"Percentage scored:"},{"$f":"Badges!A4","v":"Badges awarded:"}]
[{"$f":"Totals!A1","v":"Woodland and biodiversity"},{"$f":"Totals!B7","v":0},{"$f":"Badges!B4","v":0}]
[{"$f":"Totals!A8","v":"Woodland and water"},{"$f":"Totals!B14","v":0},{"$f":"Badges!B9","v":0}]
[{"$f":"Totals!A15","v":"Woodland and community"},{"$f":"Totals!B21","v":0},{"$f":"Badges!B14","v":0}]
[{"$f":"Totals!A22","v":"Woodland and economy"},{"$f":"Totals!B28","v":0},{"$f":"Badges!B19","v":0}]