{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["EFA option guide","Arable area calculator","EFA Calculator","Data"],"read":"whole","date_system":"1900"}

{"sheet":"EFA option guide","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"merged":[[1,1,4,5],[6,1,7,1],[9,1,10,1],[11,1,13,1],[14,1,16,1]]}
[]
[null,"Please use this questionnaire as a starting point to start thinking what EFA options would be suitable for your business type,\nAnswering YES or No to the questions should highlight a reduced list of EFA options EFA options \nOur recommendation is to read the full guidance but this may help with your decision process\n"]
[]
[]
[]
[null,"Grouping","EFA management questionnaire","Answer","Suggestion","Guidance"]
[null,"Field Margins","Do or could you have  Conservation headlands, beetlebanks ,grass margins, or watercourse margins which are at least 3 metres wide around arable fields?",null,{"$f":"IF(D7=\"Yes\", \"EFA Margin might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},{"$f":"IF(D7=\"YES\", HYPERLINK(\"https://www.ruralpayments.org/topics/all-schemes/basic-payment-scheme/basic-payment-scheme-full-guidance/greening---bps/\", \"Click Here\"), \"\")","v":""}]
[null,null,"Could you leave the headland unharvested of a single species cereal,  oil-seed crop, or a spring sown pea or pulse crop to support crop pollinators, and function as a wildlife refuge?",null,{"$f":"IF(D8=\"Yes\", \"EFA Unharvested Crop might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},{"$f":"IF(D8=\"YES\", HYPERLINK(\"https://www.ruralpayments.org/topics/all-schemes/basic-payment-scheme/basic-payment-scheme-full-guidance/greening---bps/\", \"Click Here\"), \"\")","v":""}]
[null,"Fallow land","Could you have a fallow area of ground that has no production between 15th January to 15th July, which must be sown with an enhanced temporary grassland mix, wild flower mix or wild bird seed mix or a soil conditioning crop?",null,{"$f":"IF(D9=\"Yes\", \"EFA Fallow might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,"Grassland options","Do you have PGRS that you do not apply inorganic fertiliser to that is grazed or cut for forage?",null,{"$f":"IF(D10=\"Yes\", \"EFA Low input grassland might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,null,"Do you have or could you create improved TGRS that contains a mix of at least three different herbs or legume species ( min 1 legume)",null,{"$f":"IF(D11=\"Yes\", \"EFA herb and legume rich pastures might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,"Growing crop options","Do you intend to undersow a cereal, oilseed, or maize crop with grass?",null,{"$f":"IF(D12=\"Yes\", \"EFA Catch Crops might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,null,"Do you intend to sow a Green cover crop after a main crop but before the 1st November? This can now contain stubble turnips or fodder rape in the mix as well as a wide range of species types, and can now be grazed.",null,{"$f":"IF(D13=\"Yes\", \"EFA Green Cover might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,null,"Could you grow 2 types of Nitrogen fixing crops with a margin around them ?",null,{"$f":"IF(D14=\"Yes\", \"EFA Nitrogen Fixing crop might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,"Hedges and Trees","Do you have Hedges that have Gaps < 5 metres wide and you are content not to trim for an extended period?",null,{"$f":"IF(D15=\"Yes\", \"EFA Hedges might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,null,"Do you have or would you be willing to plant an area with 20 to 50 native / or fruit trees planted per hectare, that can be grazed or managed for arable crops?",null,{"$f":"IF(D16=\"Yes\", \"EFA Low Density trees might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]
[null,null,"Have you an area of trees planted or would you plant under Scottish Forestry Woodland creation – small or farm woodland’ scheme?",null,{"$f":"IF(D17=\"Yes\", \"EFA Agro Forestry might be a suitable EFA option for you, \nplease read the full option guidance\", \"\")","v":""},""]

{"sheet":"Arable area calculator","index":1,"n_rows":39,"n_cols":8,"rows_kept":39,"merged":[[1,1,1,2],[2,1,2,2]]}
[]
[null,"Arable Area Calculator for the purpose of Greening EFA calculations"]
[null,"Enter your crop types using the drop down list and the area claimed for BPS\n\nCalculator will add all the arable areas together and then highlight the EFA commitment that you must meet",{"$nulls":4},"Area Convertor, please note all BPS/ Enhanced Greening claims must be in Hectares"]
[null,"Crop description","Area claimed in HA for BPS",null,null,"Acres"," =","Ha"]
[{"$nulls":7},{"$f":"F5/2.4710538147","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[{"$nulls":5},"Ha"," =","Acres"]
[{"$nulls":5},0,null,{"$f":"F10*2.4710538147","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":25}
[{"$nulls":3},"EFA area required @ 7%"]
[null,"Total arable area",{"$f":"SUM(C5:C36)","v":{"v":0,"d":"0.00"}},{"$f":"C37*7/100","v":0}]
[]
[null,{"$f":"IF(C37<=15,\"Deemed compliant with EFA if less than 15 ha of arable Land\",\"Required to manage EFA as you have more than 15ha of arable land\")","v":"Deemed compliant with EFA if less than 15 ha of arable Land"}]

{"sheet":"EFA Calculator","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"merged":[[1,6,1,10],[23,1,28,4]]}
[]
[null,"EFA managed area Calculator",{"$nulls":4},"Area Convertor, please note all BPS  / Enhanced Greening claims must be in Hectares."]
[null,null,"HA","EFA required %","EFA required ha",null,null,"Acres"," =","Ha"]
[null,"Managed Arable Area`",null,7,{"$f":"C4*D4/100","v":0},null,null,0,null,{"$f":"H4/2.4710538147","v":{"v":0,"d":"0.00"}}]
[null,null,0]
[null,{"$f":"IF(C4<=15,\"Deemed compliant with EFA not greater than 15 ha of arable land\",\"More than 15ha of arable land, requirement to manage EFA \")","v":"Deemed compliant with EFA not greater than 15 ha of arable land"}]
[]
[null,"EFA option","Weighting","Managed area","EFA area",null,null,"Ha"," =","Acres"]
[null,"Fallow",1,null,{"$f":"C9*D9","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"H9*2.4710538147","v":{"v":0,"d":"0.00"}}]
[null,"Margins",1.5,null,{"$f":"C10*D10","v":{"v":0,"d":"0.00"}}]
[null,"Nitrogen-fixing",1,null,{"v":0,"d":"0.00"}]
[null,"Catch",0.3,null,{"v":0,"d":"0.00"}]
[null,"Green",0.3,null,{"v":0,"d":"0.00"}]
[null,"Agro-forestry",1,null,{"v":0,"d":"0.00"}]
[null,"Hedges (length in metres) full","10 m2",null,{"$f":"D15*0.001","v":{"v":0,"d":"0.00"}}]
[null,"Hedges (length in metres) 1/2","5 m2",null,{"$f":"D16*0.0005","v":{"v":0,"d":"0.00"}}]
[null,"Low input grassland",0.2,null,{"$f":"C17*D17","v":{"v":0,"d":"0.00"}}]
[null," Herb and legume rich pastures",1.5,null,{"v":0,"d":"0.00"}]
[null," Agro-forestry Low   Density Planting",2,null,{"v":0,"d":"0.00"}]
[null,"Unharvested Crop",1.5,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},"Total EFA area",{"$f":"SUM(E9:E20)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Please enter the arable area of your holding into the Green cell at the top of this form and it will calculate the area of EFA you must manage to meet your EFA requirement.\n\nIf you enter the total area of each option you are intending to manage the calculator will take into consideration the weighting of each option and determine the total managed EFA area.\n\nTotal EFA area should be equal to or greater than the EFA required area.\n\nwe would encourage customers to have a safety margin of managed area above the required area to ensure they enough managed area when they submit their annual SAF.\n\nFull Scheme guidance is available on the guidance portal:\n\n"]
[]
[]
[]
[]
[]
[null,"All schemes"]

{"sheet":"Data","index":3,"n_rows":86,"n_cols":4,"rows_kept":86,"hidden":true}
[]
[]
[]
[{"$nulls":3},"Alfalfa"]
[{"$nulls":3},"Arable Silage for Stock feed"]
[{"$nulls":3},"Aromatic, Medicinal and Culinary"]
[{"$nulls":3},"Artichokes"]
[{"$nulls":3},"Asparagus"]
[{"$nulls":3},"Bedding and Pot Plants"]
[{"$nulls":3},"Beetroot"]
[{"$nulls":3},"Birdsfoot Trefoil"]
[{"$nulls":3},"Brussels Sprouts"]
[{"$nulls":3},"Buckwheat"]
[{"$nulls":3},"Bulbs/Flowers"]
[{"$nulls":3},"Cabbages and Savoys"]
[{"$nulls":3},"Calabrese"]
[{"$nulls":3},"Canary Seed"]
[{"$nulls":3},"Carrots"]
[{"$nulls":3},"Cauliflowers"]
[{"$nulls":3},"Celery"]
[{"$nulls":3},"Chickpea"]
[{"$nulls":3},"Chicory"]
[{"$nulls":3},"Clover – Red"]
[{"$nulls":3},"Clover – White"]
[{"$nulls":3},"Energy Beet"]
[{"$nulls":3},"Ex-Structural Set-Aside"]
[{"$nulls":3},"Fallow"]
[{"$nulls":3},"Fallow land that has"]
[{"$nulls":3},"been fallow for"]
[{"$nulls":3},"Fibre Flax"]
[{"$nulls":3},"Fodder Beet"]
[{"$nulls":3},"Forage Maize"]
[{"$nulls":3},"Garlic"]
[{"$nulls":3},"Green Cover Mixtures"]
[{"$nulls":3},"Hemp"]
[{"$nulls":3},"Kale and Cabbages for"]
[{"$nulls":3},"Stock Feed"]
[{"$nulls":3},"Leeks"]
[{"$nulls":3},"Lentil"]
[{"$nulls":3},"Lettuce"]
[{"$nulls":3},"Linseed"]
[{"$nulls":3},"Millet"]
[{"$nulls":3},"Mixed Brassica for stock feed"]
[{"$nulls":3},"Mustard"]
[{"$nulls":3},"Onions"]
[{"$nulls":3},"Other Soft Fruit"]
[{"$nulls":3},"Other Vegetables"]
[{"$nulls":3},"Parsnips"]
[{"$nulls":3},"Permanent Cover - for EFA margins"]
[{"$nulls":3},"Phacelia"]
[{"$nulls":3},"Pumpkin"]
[{"$nulls":3},"Rape for Stock Feed"]
[{"$nulls":3},"Rotational Grass Year 1"]
[{"$nulls":3},"Rotational Grass Year 2"]
[{"$nulls":3},"Rotational Grass Year 3"]
[{"$nulls":3},"Rotational Grass Year 4"]
[{"$nulls":3},"Rotational Grass Year 5"]
[{"$nulls":3},"Seed Potatoes"]
[{"$nulls":3},"Shopping Swedes"]
[{"$nulls":3},"Shopping Turnips"]
[{"$nulls":3},"Sorghum"]
[{"$nulls":3},"Spring Barley"]
[{"$nulls":3},"Spring Beans for human consumption"]
[{"$nulls":3},"Spring Field Beans"]
[{"$nulls":3},"Spring Oats"]
[{"$nulls":3},"Spring Oilseed Rape"]
[{"$nulls":3},"Spring Wheat"]
[{"$nulls":3},"Sweet Lupins"]
[{"$nulls":3},"Turf Production"]
[{"$nulls":3},"Turnips for Stock Feed"]
[{"$nulls":3},"Uncropped Arable Land"]
[{"$nulls":3},"Vetch"]
[{"$nulls":3},"Ware Potatoes"]
[{"$nulls":3},"Wild Bird Seed"]
[{"$nulls":3},"Wild Flower Mix"]
[{"$nulls":3},"Winter Barley"]
[{"$nulls":3},"Winter Beans for human consumption"]
[{"$nulls":3},"Winter Field Beans"]
[{"$nulls":3},"Winter Oats"]
[{"$nulls":3},"Winter Oilseed Rape"]
[{"$nulls":3},"Winter Peas for human consumtion"]
[{"$nulls":3},"Winter Protein Peas"]
[{"$nulls":3},"Winter Rye"]
[{"$nulls":3},"Winter Spelt"]
[{"$nulls":3},"Winter Triticale"]
[{"$nulls":3},"Winter Wheat"]