{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["MainSheet","BaseData","ActualLandUse","ScenarioLandUse","Point Sources","Templates","ListOptions","Rotation1","TestData","Rotation2","Rotation3","Rotation4","Rotation5","Rotation6","AtmosphericDeposition","NCycle","Version Log"],"not_rendered":{"charts":7,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":6,"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":"row_number_cap","date_system":"1900"}

{"sheet":"MainSheet","index":0,"n_rows":91,"n_cols":24,"rows_kept":91,"cut":false,"hidden":false,"merged":[[1,5,1,9],[14,16,15,19],[18,16,19,19],[1,13,1,14],[3,16,4,19],[6,16,7,19],[10,16,11,19],[2,16,2,19]]}
[null,null,"Field Scale Nitrate Leaching Tool"]
[null,null,null,null,null,"Annual Losses Summary"]
[null,null,null,null,"Fields","Average Nloss \n(kg N/ha)",null,"Average Nconc \n(mg/l)",null,"Total Nload\n(kg N)",null,null,null,null,null,null,"You can enter field-specific data\nto supplement the existing RPA data",null,null,null,null,null,"Land Use","Area \n(ha)"]
[null,null,null,"Actual Land Use",null,null,null,null,null,null,null,null,null,null,null,null,"You can view (and change) existing RPA data"]
[null,null,null,"Scenario Land Use"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Update N loss calculations"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"View field by field results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"This pie chart shows the Nload in kg N from the 4 main land uses "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"expressed as a percentage of the total N load from the farm unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Results are based on the actual land use"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"This bar chart shows the total N load (loss*area) in kg N from the 4 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," main crop types. Results are based on the actual land use data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"This bar chart shows the average nitrate-N concentration (mg N/l)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"from the 4 main crop types weighted by area. Results are based"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"on actual land use and any user scenario data that has ben entered"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"In comparing actual and scenario, ensure the same number of fields "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"are being compared (i.e. You have created scenarios for all fields)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"This bar chart shows the average N loss in kg N/ha from "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"the 4 main land uses weighted by area. Results are for actual "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"land use and any user scenario that has been created"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"In comparing actual and scenario, ensure the same number of fields "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"are being compared (i.e. You have created scenarios for all fields)."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"agricultural","point sources"]
[null,null,null,null,{"$f":"E42","v":0},{"$f":"'Point Sources'!G34","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"E43","v":0},{"$f":"'Point Sources'!G34","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"E44","v":0},{"$f":"'Point Sources'!G34","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"This bar chart shows the total N load (loss*area) in kg N from the 4 "]
[null,null,null,null,{"$f":"E45","v":0},{"$f":"'Point Sources'!G34","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"main crop types, compared with the total loading from point sources"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"in kg/N."]

{"sheet":"BaseData","index":1,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"  RPA  Field Data"]
[]
["Field Number","Field Name","Agreed Area (ha)","Soil Series","Soil Depth","Stored Water (mm)","HER (mm)","SPR","RPA Land Use","Intrinsic risk","National Grid Square","CPH","Duplicate Site","Missing HER"]

{"sheet":"ActualLandUse","index":2,"n_rows":4,"n_cols":29,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,21,1,28],[2,21,2,23],[2,24,2,28],[0,3,0,20],[1,13,1,14]]}
[null,null,null,"INPUT VARIABLES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUTPUT RESULTS"]
[null,null,null,"  Atmospheric deposition of N is assumed to be:",null,null,{"$f":"AtmosphericDeposition!C4","v":{"$error":"#N/A"}},"  (kg N/ha/year)",null,"NCYCLE Climate Zone:",null,{"$f":"NCycle!$J$49","v":{"$error":"#N/A"}},null,"Denitrification:\n(Inorganic Fertiliser)",null,0,"  %"]
["\n\nFlag empty/missing fields",null,null,"  Fertiliser values exceeding RB209 guidance are highlighted orange.    ***     All values can be manually overtyped.    ***      It is recommended to use the \"Field Data Entry\" Form to amend columns with a light green header.   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Losses",null,null,"Losses averaged over full rotation period"]
["Field Number","Field Name","Agreed Area (ha)","Uncultivated Margin (m)","Land Use","Fertiliser N (kg/ha)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount \n(t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount \n(t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Fresh market yield (t/ha)","Parcel ID","N deposition by livestock (kg/ha/yr)","Annual N production by livestock (kg/yr)","N Loss \n(kg N/ha)","N Conc \n(mg N/l)","Total \nN Loss\n(kg N)","Rotation number","Year in Rotation","Nloss \n(kg N/ha)","Nconc (mg/l)","N Load \n(kg N)"]

{"sheet":"ScenarioLandUse","index":3,"n_rows":4,"n_cols":29,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,21,2,23],[2,24,2,28],[0,21,1,28],[0,3,0,20],[1,13,1,14]]}
[null,null,null,"INPUT VARIABLES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUTPUT RESULTS"]
[null,null,null,"  Atmospheric deposition of N is assumed to be:",null,null,{"$f":"AtmosphericDeposition!C4","v":{"$error":"#N/A"}},"  (kg N/ha/year)",null,"NCYCLE Climate Zone:",null,{"$f":"ActualLandUse!L2","v":{"$error":"#N/A"}},null,"Denitrification:\n(Inorganic Fertiliser)",null,0,"  %"]
[null,null,null,"  Fertiliser values exceeding RB209 guidance are highlighted orange.    ***     All values can be manually overtyped.    ***      It is recommended to use the \"Field Data Entry\" Form to amend columns with a light green header.   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Losses",null,null,"Losses averaged over full rotation period"]
["Field Number","Field Name","Agreed Area (ha)","Uncultivated Margin (m)","Land Use","Fertiliser N (kg/ha)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount \n(t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Fresh market yield (t/ha)","Parcel ID","N deposition by livestock (kg/ha/yr)","Annual N production by livestock (kg/yr)","N Loss \n(kg N/ha)","N Conc \n(mg N/l)","N Load \n(kg N)","Rotation number","Year in Rotation","Nloss \n(kg N/ha)","Nconc (mg/l)","N Load \n(kg N)"]

{"sheet":"Point Sources","index":4,"n_rows":159,"n_cols":14,"rows_kept":159,"cut":false,"hidden":false,"merged":[[160,13,164,13],[177,13,180,13]]}
[]
[null,"These calculations are taken from the Environment Agency Cumulative N&P loading to groundwater calculator spreadsheet."]
[]
[null,"Key"]
[null,"Enter data in the yellow cells"]
[null,"Blue cells are calculated - do not change"]
[]
[null,null,null,null,null,"Calculated nitrate loading"]
[null,"Farm geography",null,null,null,"kg N/ha/yr","kg N/yr"]
[]
[null,"Total modelled field area","ha",{"$f":"SUM(ActualLandUse!C5:C100001)","v":0}]
[null,"Total farm area","ha"]
[]
[null,"Farm area to use in calculations","ha",5]
[null,"Annual average rainfall","mm"]
[]
[null,"Population"]
[]
[null,"Total population (to calculate mains water losses)","hd",0,null,{"$f":"C122","v":{"$error":"#DIV/0!"}},{"$f":"F19*D$14","v":{"$error":"#DIV/0!"}},null,"Mains water losses"]
[null,"Sewered population (with discharge of treated effluent to ground)",null,0,null,{"$f":"C75","v":{"$error":"#DIV/0!"}},{"$f":"F20*D$14","v":{"$error":"#DIV/0!"}},null,"Leaching from sewage discharged to ground"]
[null,"Number of people served by septic tanks",null,0,null,{"$f":"C89","v":{"$error":"#DIV/0!"}},{"$f":"F21*D$14","v":{"$error":"#DIV/0!"}},null,"Leaching from septic tanks"]
[null,"Number of people served by package treatment plants",null,0,null,{"$f":"C103","v":{"$error":"#DIV/0!"}},{"$f":"F22*D$14","v":{"$error":"#DIV/0!"}},null,"Leaching from package treatment plants"]
[]
[]
[null,"Area of roads and paved surfaces (outside urban)","ha",0,null,{"$f":"C159","v":0},{"$f":"F25*D$14","v":0},null,"Runoff from roads and tracks on the farm"]
[]
[null,"Agricultural point sources"]
[]
[null,"Area of engineered slurry stores","ha",0,null,{"$f":"G29/D$14","v":0},{"$f":"C129*(1-C145)","v":0},null,"Losses from engineered slurry stores"]
[null,"Area of unlined slurry stores","ha",0,null,{"$f":"G30/D$14","v":0},{"$f":"C133*(1-C145)","v":0},null,"Losses from unlined slurry stores"]
[null,"Area generating farmyard run-off","ha",0,null,{"$f":"G31/D$14","v":0},{"$f":"C137*(1-C145)","v":0},null,"Farmyard runoff"]
[null,"Area of constructed wetlands","ha",0,null,{"$f":"G32/D$14","v":0},{"$f":"C141*(1-C145)","v":0},null,"Constructed wetlands"]
[]
[null,"Total",null,null,null,{"$f":"G34/D14","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G19:G32)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,"Calculations and parameter values below here - for modification by advanced users."]
[]
[null,"Key"]
[null,"Model parameters (which may be changed by advanced users)"]
[null,"Data from Catchment Data Entry worksheet - do not change"]
[null,"Blue cells are calculated - do not change"]
[]
[null,"Calculations for non agricultural sources + agricultural point sources"]
[]
[]
[null,"Loading from sewers (sewered population)"]
[]
[null,"Sewered population",{"$f":"D19","v":0},"persons"]
[null,"Catchment area",{"$f":"D14","v":5},"ha"]
[null,"Population density",{"$f":"C51/C52","v":0},"person/ha"]
[null,"Water use",230,"l/person/day"]
[null,"Leakage rate",2,"%"]
[null,"Nitrogen concentration in effluent",45,"mg N/l"]
[null,"Leakage to groundwater",{"$f":"C53*365*C54*0.01*C55/10000","v":0},"mm/year"]
[null,"Leakage to groundwater",{"$f":"C51*C54*C55/(100*1000)","v":0},"m3/d"]
[null,"N loading (top unsaturated zone)",{"$f":"C$53*365*C$54*0.01*C$55*C56/1000000","v":0},"Kg N/ha/year"]
[null,"Attenuation (unsaturated zone)",0.2]
[null,"N loading (groundwater)",{"$f":"(1-C60)*C59","v":0},"Kg N/ha/year"]
[]
[null,"Loading from sewage discharges to ground  - Treated sewage effluent (e.g. STW)"]
[null,"Sewered population (with treated sewage discharged to ground)",{"$f":"D20","v":0},"persons"]
[null,"Catchment area",{"$f":"D11","v":0},"ha"]
[null,"Population density",{"$f":"C64/C65","v":{"$error":"#DIV/0!"}},"person/ha"]
[null,"Water use",230,"l/person/day"]
[null,"Nitrogen concentration in discharge to ground",20,"mg N/l"]
[null,"Discharge to groundwater",{"$f":"C66*365*C67/10000","v":{"$error":"#DIV/0!"}},"mm/year"]
[null,"Discharge to groundwater",{"$f":"C64*C67*0.001","v":0},"m3/day"]
[null,"Loading",{"$f":"C67*C68*365/1000000","v":1.679},"Kg N/person/year"]
[null,"N loading ",{"$f":"C64*365*C67*C68/(C65*1000000)","v":{"$error":"#DIV/0!"}},"Kg N/ha/year",null,null,null,null,null,null,null,null,null,"Average concentration"]
[null,"Attenuation (drainage blanket)",0.4,null,null,null,null,null,null,null,null,"Base of drainage blanket"]
[null,"Attenuation (unsaturated zone)",0,null,null,null,null,null,null,null,null,"Base unsaturated zone"]
[null,"N loading (groundwater)",{"$f":"(1-C74)*C72*(1-C73)","v":{"$error":"#DIV/0!"}},"Kg N/ha/year"]
[null,null,null,null,null,null,null,null,null,null,null,"After attenuation"]
[null,"Loading from sewage discharges to ground  - Treated sewage effluent (e.g. septic tanks)"]
[null,"Number of people served by septic tanks",{"$f":"D21","v":0},"persons"]
[null,"Catchment area",{"$f":"D11","v":0},"ha"]
[null,"Population density",{"$f":"C78/C79","v":{"$error":"#DIV/0!"}},"person/ha"]
[null,"Water use",150,"l/person/day"]
[null,"Nitrogen concentration in discharge to ground",50,"mg N/l"]
[null,"Discharge to groundwater",{"$f":"C80*365*C81/10000","v":{"$error":"#DIV/0!"}},"mm/year",null,null,null,null,null,null,null,22]
[null,"Discharge to groundwater",{"$f":"C78*C81*0.001","v":0},"m3/day",null,null,null,null,null,null,null,8.5,null,"Assumed to be 75% of DWS"]
[null,"Loading",{"$f":"C81*C82*365/1000000","v":2.7374999999999998},"Kg N/person/year",null,null,null,null,null,null,null,null,null,"average over catchment"]
[null,"N loading ",{"$f":"C78*365*C81*C82/(C79*1000000)","v":{"$error":"#DIV/0!"}},"Kg N/ha/year"]
[null,"Attenuation (drainage blanket)",0.4,null,null,null,null,null,null,null,null,null,null,"average over catchment"]
[null,"Attenuation (unsaturated zone)",0]
[null,"N loading (groundwater)",{"$f":"(1-C88)*C86*(1-C87)","v":{"$error":"#DIV/0!"}},"Kg N/ha/year"]
[]
[null,"Loading from sewage discharges to ground  - Treated sewage effluent (e.g. package treatment plant)"]
[null,"Number of people served by package treatment plants",{"$f":"D22","v":0},"persons"]
[null,"Catchment area",{"$f":"D11","v":0},"ha"]
[null,"Population density",{"$f":"C92/C93","v":{"$error":"#DIV/0!"}},"person/ha",null,null,null,null,null,null,null,null,null,"Suggest using % of effective effective rainfall"]
[null,"Water use",150,"l/person/day",null,null,null,null,null,null,null,4000,null,"Table 12.1, main report and 10% volatilisation loss"]
[null,"Nitrogen concentration in discharge to ground",20,"mg N/l"]
[null,"Discharge to groundwater",{"$f":"C94*365*C95/10000","v":{"$error":"#DIV/0!"}},"mm/year"]
[null,"Discharge to groundwater",{"$f":"C92*C95*0.001","v":0},"m3/day",null,null,null,null,null,null,null,null,null,"Value should be related to recharge calculated in Hydrology worksheet"]
[null,"Loading",{"$f":"C95*C96*365/1000000","v":1.095},"Kg N/person/year",null,null,null,null,null,null,null,4000,null,"Table 12.1, main report and 10% volatilisation loss"]
[null,"N loading ",{"$f":"C92*365*C95*C96/(C93*1000000)","v":{"$error":"#DIV/0!"}},"Kg N/ha/year"]
[null,"Attenuation (drainage blanket)",0.4,null,null,null,null,null,null,null,null,null,null,"Exclude areas draining to constructed wetlands, slurry stores"]
[null,"Attenuation (unsaturated zone)",0,null,null,null,null,null,null,null,null,null,null,"Value should be related to recharge calculated in Hydrology worksheet"]
[null,"N loading (groundwater)",{"$f":"(1-C102)*C100*(1-C101)","v":{"$error":"#DIV/0!"}},"Kg N/ha/year",null,null,null,null,null,null,null,17,null,"Based on Gouriveau 2007"]
[null,"Summary"]
[null,"Total loading from treated sewage effluent discharges",{"$f":"C72+C86+C100","v":{"$error":"#DIV/0!"}},"Kg N/ha/year"]
[null,"Total loading from treated sewage effluent discharges",{"$f":"C72*(1-C73)+C86*(1-C87)+C100*(1-C101)","v":{"$error":"#DIV/0!"}},"Kg N/ha/year",null,null,null,null,null,null,null,null,null,"Value should be related to recharge calculated in Hydrology worksheet"]
[null,"Total loading from treated sewage effluent discharges",{"$f":"C75+C89+C103","v":{"$error":"#DIV/0!"}},"Kg N/ha/year",null,null,null,null,null,null,null,9,null,"Assumes 50% removal of N in wetland"]
[null,"Average discharge to groundwater",{"$f":"C69+C83+C97","v":{"$error":"#DIV/0!"}},"mm/year"]
[null,"Nitrate concentration in recharge at water table",{"$f":"100*C107/C108","v":{"$error":"#DIV/0!"}},"mg N/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average over catchment"]
[null,"Loading from mains water",null,null,null,null,null,null,null,null,null,null,null,"average over catchment"]
[null,"Population",{"$f":"D19","v":0},"person"]
[null,"Catchment area",{"$f":"D11","v":0},"ha"]
[null,"Population density",{"$f":"C112/C113","v":{"$error":"#DIV/0!"}},"person/ha"]
[null,"Water use",{"$f":"C54","v":230},"l/person/day"]
[null,"Leakage rate",22,"%"]
[null,"Nitrogen concentration in mains water",8.5,"mg N/l"]
[null,"Leakage to groundwater",{"$f":"C114*365*C115*0.01*C116/10000","v":{"$error":"#DIV/0!"}},"mm/year"]
[null,"Leakage to groundwater",{"$f":"C112*C115*C116/100000","v":0},"m3/d",null,null,null,null,null,null,null,50,null,"Estimate"]
[null,"N loading ",{"$f":"C114*365*C115*0.01*C$116*C117/1000000","v":{"$error":"#DIV/0!"}},"Kg N/ha/year",null,null,null,null,null,null,null,3.5,null,"Table 10.2, main report"]
[null,"Attenuation (unsaturated zone)",0.2]
[null,"N loading (groundwater)",{"$f":"(1-C121)*C120","v":{"$error":"#DIV/0!"}},"Kg N/ha/year",null,null,null,null,null,null,null,null,null,"average over catchment"]
[]
[null,"Loading from agricultural point sources (slurry, farmyard and constructed wetlands)",null,null,null,null,null,null,null,null,null,null,null,"average over catchment"]
[null,"Total catchment area",{"$f":"D11","v":0},"ha"]
[null,"Area of engineered slurry stores",{"$f":"D29","v":0},"ha",null,null,null,null,null,null,null,null,null,"average over catchment"]
[null,"Infiltration from base of engineered stores",10,"mm/year"]
[null,"N concentration in leachate",4000,"mg N/l"]
[null,"Loading",{"$f":"100*100*C126*C127*C128/1000000","v":0},"kg N/year"]
[null,"Area of unlined slurry stores",{"$f":"D30","v":0},"ha"]
[null,"Infiltration from base of unlined stores",70,"mm/year"]
[null,"N concentration in leachate",4000,"mg N/l"]
[null,"Loading",{"$f":"100*100*C130*C131*C132/1000000","v":0},"kg N/year"]
[null,"Area generating farmyard run-off",{"$f":"D31","v":0},"ha"]
[null,"Infiltration over 'paved' areas",140,"mm/year"]
[null,"N concentration in run-off",17,"mg N/l"]
[null,"Loading",{"$f":"100*100*C134*C135*C136/1000000","v":0},"kg N/year"]
[null,"Area of constructed wetlands",{"$f":"D32","v":0},"ha"]
[null,"Infiltration from base of wetland",140,"mm/year"]
[null,"N concentration in leachate",9,"mg N/l"]
[null,"Total N loading",{"$f":"100*100*C138*C139*C140/1000000","v":0},"kg N/year"]
[null,"Total loading",{"$f":"C129+C133+C137+C141","v":0},"kg N/year"]
[null,"Total loading from point sources",{"$f":"(C129+C133+C137+C141)/C125","v":{"$error":"#DIV/0!"}},"Kg N/ha/year"]
[null,"Infiltration to groundwater",{"$f":"(C126*C127+C130*C131+C134*C135+C138*C139)/C125","v":{"$error":"#DIV/0!"}},"mm/year"]
[null,"Attenuation (unsaturated zone)",0.2]
[null,"N loading (groundwater)",{"$f":"(1-C145)*C143","v":{"$error":"#DIV/0!"}},"Kg N/ha/year"]
[]
[]
[null,"Loading from surface water run-off from roads and other paved areas"]
[null,"Area of roads, paved surfaces outside urban areas",{"$f":"D25","v":0},"ha"]
[null,"Rainfall ",{"$f":"D15","v":0},"mm/year"]
[null,"Percentage area draining to ground",50,"%"]
[null,"N concentration in run-off",3.5,"mg N/l"]
[null,"Total loading",{"$f":"0.01*C152*C151*C150*C153/100","v":0},"kg N/year"]
[null,"N loading",{"$f":"C154/C52","v":0},"kg N/ha/year"]
[null,"Average N concentration in drainage to groundwater",{"$f":"C153","v":3.5},"mg N/l"]
[null,"Infiltration to groundwater",{"$f":"1000*C150*0.001*C151*0.01*C152/C113","v":{"$error":"#DIV/0!"}},"mm/year"]
[null,"Attenuation (unsaturated zone)",0.2]
[null,"N loading (groundwater)",{"$f":"(1-C158)*C155","v":0},"kg N/ha/year"]

{"sheet":"Templates","index":5,"n_rows":51,"n_cols":31,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,23,0,28],[0,0,0,15],[0,17,0,21]],"read":"row_number_cap"}
["TEMPLATES: User defined values (editable)\n \n\n\n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock\n\n",null,null,null,null,null,"Default values (Literature recommendations)\n!should not be changed!\n"]
["Blank","Land Use","Fertiliser (kg N/ha)","Headland (m)","Manure 1 Type","Manure 1 Applied (t/ha)","Manure 1 Timing","Manure 2 Type","Manure 2 Applied (t/ha)","Manure 2 Timing","Soil N Index","Mitigation Options","Stocking density","Grazing period","Yield\n(t/ha)","Fixed N\n(kg N/ha)",null,"Livestock","Nproduction\n(kg N/yr \nper animal)","Stock Density\nHIGH\n(animals/ha)","Stock Density\nMEDIUM\n(animals/ha)","Stock Density\nLOW\n(animals/ha)",null,"Fertilizer\nMax \n(kg N/ha)","Fertilizer\nMin \n(kg N/ha)","Fertilizer\nTypical\n(kg N/ha)","Yield\n(t/ha)","Fixed N\n(kg N/ha)","Source"]
[null,"Arable:Winter Wheat",188,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",8.3000000000000007,0,null,null,null,null,null,null,null,280,0,188,8.3000000000000007,0,"RB209 (2019) Section 4 p28; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Winter Barley",152,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",6.9,0,null,null,null,null,null,null,null,220,0,152,6.9,0,"RB209 (2019) Section 4 p29; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Winter Oilseed Rape",181,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",3.4,0,null,null,null,null,null,null,null,220,0,181,3.4,0,"RB209 (2019) Section 4 p38; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Winter Oats",101,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",6.3,0,null,null,null,null,null,null,null,190,0,101,6.3,0,"RB209 (2019) Section 4 p31; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Spring Wheat",132,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",5.75,0,null,null,null,null,null,null,null,210,0,132,5.75,0,"RB209 (2019) Section 4 p32; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Spring Barley",103,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",5.45,0,null,null,null,null,null,null,null,160,0,103,5.45,0,"RB209 (2019) Section 4 p32; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Spring Oilseed Rape or linseed",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",2,0,null,null,null,null,null,null,null,150,0,85,2,0,"RB209 (2019) Section 4 p39; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Spring Oats",101,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",5.5,0,null,null,null,null,null,null,null,140,0,101,5.5,0,"RB209 (2019) Section 4 p34; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Rye or Triticale",128,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",5.6,0,null,null,null,null,null,null,null,140,0,128,5.6,0,"RB209 (2019) Section 4 p34; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Potatoes",136,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",45,0,null,null,null,null,null,null,null,270,0,136,45,0,"RB209 (2019) Section 5 p22; BSFP (2017) p44; Maincrop. ",null,"Arable"]
[null,"Arable:Sugar Beet",96,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",70,0,null,null,null,null,null,null,null,120,0,96,70,0,"RB209 (2019) Section 4 p41; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Forage maize",72,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",40,0,null,null,null,null,null,null,null,150,0,72,40,0,"RB209 (2019) Section 3 p27; BSFP (2017) p44; ",null,"Arable"]
[null,"Arable:Ryegrass (seed)",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",1.3,0,null,null,null,null,null,null,null,160,0,85,1.3,0,"RB209 (2019) Section 3 p34; RB209 (2019) Section 3 p34; Average rate for SNS index 2",null,"Arable"]
[null,"Arable:Asparagus",120,6,"None",0,1,"None",0,1,1,null,"n/a","n/a","n/a",0,null,null,null,null,null,null,null,150,0,120,"n/a",0,"RB209 (2019) Section 6 p24; RB209 (2019) Section 6 p24; Average value - see text p25",null,"Arable"]
[null,"Arable:Brussels Sprouts and Cabbage",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a","n/a",0,null,null,null,null,null,null,null,330,0,94,"n/a",0,"RB209 (2019) Section 6 p26; BSFP (2017) p44; Rate for brassicae",null,"Arable"]
[null,"Arable:Cauliflower",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",12,0,null,null,null,null,null,null,null,290,0,94,12,0,"RB209 (2019) Section 6 p28; BSFP (2017) p44; Rate for brassicae",null,"Arable"]
[null,"Arable:Onions",110,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",41,0,null,null,null,null,null,null,null,160,0,110,41,0,"RB209 (2019) Section 6 p35; RB209 (2019) Section 6 p35; Average rate for SNS index 2",null,"Arable"]
[null,"Arable:Fodder Beet",110,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",38,0,null,null,null,null,null,null,null,130,0,110,85,0,"RB209 (2019) Section 3 p33; RB209 (2019) Section 3 p33; Average rate for SNS index 2",null,"Arable"]
[null,"Arable:Spring sown grass",128,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",39,0,null,null,null,null,null,null,null,370,0,128,38,0,"RB209 (2019) Section 3 p15; BSFP (2017) p44; Rate for grass <5 years",null,"Arable"]
[null,"Veg:Brussels sprouts",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",20.3,0,null,null,null,null,null,null,null,330,0,94,20.3,0,"RB209 (2019) Section 6 p26; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:White Cabbage Storage",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",110,0,null,null,null,null,null,null,null,340,0,94,110,0,"RB209 (2019) Section 6 p26; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Head Cabbage pre Dec31st",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",60,0,null,null,null,null,null,null,null,325,0,94,60,0,"RB209 (2019) Section 6 p26; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Head Cabbage post Dec31st",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",53,0,null,null,null,null,null,null,null,240,0,94,53,0,"RB209 (2019) Section 6 p26; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Collards pre Dec31st",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",20,0,null,null,null,null,null,null,null,210,0,94,20,0,"RB209 (2019) Section 6 p26; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Collards post Dec31st",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",30,0,null,null,null,null,null,null,null,310,0,94,30,0,"RB209 (2019) Section 6 p26; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Cauliflower (Over Winter)",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",12,0,null,null,null,null,null,null,null,290,0,94,12,0,"RB209 (2019) Section 6 p28; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Calabrese",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",16.3,0,null,null,null,null,null,null,null,235,0,94,16.3,0,"RB209 (2019) Section 6 p28; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Cauliflower Summer",94,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",30.6,0,null,null,null,null,null,null,null,290,0,94,30.6,0,"RB209 (2019) Section 6 p28; BSFP (2017) p44; Rate for brassicae",null,"Vegetable"]
[null,"Veg:Lettuce (Crisp)",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",45.5,0,null,null,null,null,null,null,null,200,30,85,45.5,0,"RB209 (2019) Section 6 p33; BSFP (2017) p44; Rate for veg (other)",null,"Vegetable"]
[null,"Veg:Radish",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",50,0,null,null,null,null,null,null,null,100,0,85,50,0,"RB209 (2019) Section 6 p32; BSFP (2017) p44; Rate for veg (other)",null,"Vegetable"]
[null,"Veg:Bulb onions spring",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",60.5,0,null,null,null,null,null,null,null,130,0,85,60.5,0,"RB209 (2019) Section 6 p35; BSFP (2017) p44; Rate for veg (other)",null,"Vegetable"]
[null,"Veg:Bulb onions overwintered",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",60.5,0,null,null,null,null,null,null,null,160,0,85,60.5,0,"RB209 (2019) Section 6 p35; BSFP (2017) p44; Rate for veg (other)",null,"Vegetable"]
[null,"Veg:Leeks",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",47,0,null,null,null,null,null,null,null,200,40,85,47,0,"RB209 (2019) Section 6 p35; BSFP (2017) p44; Rate for veg (other)",null,"Vegetable"]
[null,"Veg:Swede",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",84.8,0,null,null,null,null,null,null,null,135,0,85,84.8,0,"RB209 (2019) Section 6 p37; BSFP (2017) p44; Rate for veg (other)",null,"Vegetable"]
[null,"Veg:Carrots",85,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",63.1,0,null,null,null,null,null,null,null,100,0,85,63.1,0,"RB209 (2019) Section 6 p37; BSFP (2017) p44; Rate for veg (other)",null,"Vegetable"]
[null,"Veg:Peas",0,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",3.5,140.69999999999999,null,null,null,null,null,null,null,0,0,0,3.5,140.69999999999999,"RB209 (2019) Section 4 p41; BSFP (2017) p44; ",null,"Vegetable"]
[null,"Veg:Beans",0,6,"None",0,1,"None",0,1,1,null,"n/a","n/a",3.6,224.6,null,null,null,null,null,null,null,0,0,0,3.6,224.6,"RB209 (2019) Section 6 p31; BSFP (2017) p44; ",null,"Vegetable"]
[null,"Grass:Dairy grazed",94,0,"None",0,1,"None",0,1,1,null,"High","Grazed","n/a",0,null,"Dairy",117,3.1,2.6,2,null,270,30,94,"n/a",0,"RB209 (2019) Section 3 p16; BSFP (2017) p26; Average field rate (grazed)",null,"Grassland"]
[null,"Grass:Dairy cut and grazed",94,0,"None",0,1,"None",0,1,1,null,"High","Grazed","n/a",0,null,"Dairy",117,3.1,2.6,2,null,310,70,94,"n/a",0,"RB209 (2019) Section 3 p15; BSFP (2017) p26; Average field rate (grazed)",null,"Grassland"]
[null,"Grass:Beef",94,0,"None",0,1,"None",0,1,1,null,"High","Grazed","n/a",0,null,"Beef",92,3.17,2,{"$f":"0.5 / 0.6","v":0.83333333333333337},null,310,70,94,"n/a",0,"RB209 (2019) Section 3 p15; BSFP (2017) p26; Average field rate (grazed)",null,"Grassland"]
[null,"Lowland Sheep",94,0,"None",0,1,"None",0,1,1,null,"Low","All year","n/a",0,null,"Sheep",12.3,{"$f":"1.7 / 0.17","v":9.9999999999999982},{"$f":"0.7 / 0.17","v":4.117647058823529},{"$f":"0.1 / 0.17","v":0.58823529411764708},null,310,70,94,"n/a",0,"RB209 (2019) Section 3 p15; BSFP (2017) p26; Average field rate (grazed)",null,"Lowland Sheep"]
[null,"Grass:Silage",126,0,"None",0,1,"None",0,1,1,null,"n/a","Cut only","n/a",0,null,null,null,null,null,null,null,310,70,126,"n/a",0,"RB209 (2019) Section 3 p15; BSFP (2017) p26; Average field rate (silage)",null,"Grassland"]
[null,"Outdoor Pigs",0,0,"None",0,1,"None",0,1,1,null,"High","All year","n/a",0,null,"Pigs",18,25,16,7,null,0,0,0,"n/a",0,null,null,"Outdoor Pigs"]
[null,"Hay (extensive)",83,0,"None",0,1,"None",0,1,1,null,"n/a","n/a","n/a",0,null,null,null,null,null,null,null,100,40,83,"n/a",0,"RB209 (2019) Section 3 p16; BSFP (2017) p26; Average field rate (hay)",null,"Other"]
[null,"Forestry",0,0,"None",0,1,"None",5,1,1,null,"n/a","n/a","n/a",0,null,null,null,null,null,null,null,0,0,0,"n/a",0,null,null,"Other"]
[null,"Rough Grazing",0,0,"None",0,1,"None",0,1,1,null,"n/a","n/a","n/a",0,null,null,null,null,null,null,null,0,0,0,"n/a",0,null,null,"Rough Grazing"]
[null,"Miscellaneous Landuse 1",0,0,"None",0,1,"None",0,1,1,null,"n/a","n/a","n/a",0]
[null,"Miscellaneous Landuse 2",0,0,"None",0,1,"None",0,1,1,null,"n/a","n/a","n/a",0]
[null,"Miscellaneous Landuse 3",0,0,"None",0,1,"None",0,1,1,null,"n/a","n/a","n/a",0]

{"sheet":"ListOptions","index":6,"n_rows":157,"n_cols":17,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["Land Use","Arable\nN coefficent\n(kg N/t)","Vegetables\n FW to DM\n(t/ha)","'a'","'b'","Manure types","available Ncontent",null,"Arable Mitigation ALL options","Pre-Residual Value","Post-Residual Value","Grassland Mitigation ALL options","Value",null,"Grazing period",null,"Stocking density"]
["Arable:Winter Wheat",21,"","","","None",0,null,"No mitigation options",100,100,"No mitigation options",100,null,"n/a",null,"n/a"]
["Arable:Winter Barley",15,"","","","Fresh Cattle FYM",1.2,null,"4:Plant autumn cover crops",100,50,"16:Allow drainage to deteriorate",80,null,"Grazed",null,"High"]
["Arable:Winter Oilseed Rape",30,"","","","Old Cattle FYM",0.6,null,"5:Early harvest and establishment",100,70,"17:Improve drainage",130,null,"1cut,grazed",null,"Medium"]
["Arable:Winter Oats",16,"","","","Fresh Pig FYM",1.8,null,"6:Spring instead of autumn cultivation",65,100,"18:Maintain ditches",120,null,"2cuts,grazed",null,"Low"]
["Arable:Spring Wheat",21,"","","","Old Pig FYM",1,null,"7:Reduced cultivation",80,100,"20:Plant N-efficient crops",90,null,"3cuts,grazed"]
["Arable:Spring Barley",15,"","","","Fresh Sheep FYM",1.4,null,"12:Maintain SOM levels",120,100,"21:Calibrate fertiliser spreader",95,null,"Cut only"]
["Arable:Spring Oilseed Rape or linseed",38,"","","","Old Sheep FYM",0.7,null,"16:Allow drainage to deteriorate",80,100,"22:Use fertiliser recommendation system",95,null,"All year"]
["Arable:Spring Oats",16,"","","","Fresh Duck FYM",1.6,null,"17:Improve drainage",130,100,"23:Integrate fertiliser and manure",90]
["Arable:Rye or Triticale",16,"","","","Old Duck FYM",1,null,"18:Maintain ditches",120,100,"25:Avoid high risk areas",98]
["Arable:Potatoes",3,"","","","Poultry Litter",9.5,null,"20:Plant N-efficient crops",90,100,"26:Avoid high risk times",95]
["Arable:Sugar Beet",2,"","","","Broiler/Turkey Litter",10.5,null,"21:Calibrate fertiliser spreader",95,100,"27:Use fertiliser placement",98]
["Arable:Forage maize",3,"","","","Cattle Slurry (whole)-2% DM",0.9,null,"22:Use fertiliser recommendation system",95,100,"28:Use nitrification inhibitors",65]
["Arable:Ryegrass (seed)",26,"","","","Cattle Slurry (whole)-6% DM",1.2,null,"23:Integrate fertiliser and manure",90,100,"29:Replace urea with ammonium nitrate",95]
["Arable:Asparagus",2,"","","","Cattle Slurry (whole)-10% DM",1.3,null,"25:Avoid high risk areas",98,100,"31:Use Clover",80]
["Arable:Brussels Sprouts and Cabbage",5,"","","","Cattle Slurry (liquid) -1.5%DM",0.8,null,"26:Avoid high risk times",95,100,"34:Phase feeding of livestock",98]
["Arable:Cauliflower",5,"","","","Cattle Slurry (liquid)-3%DM",1,null,"27:Use fertiliser placement",98,100,"67:Calibrate manure spreader",95]
["Arable:Onions",4,"","","","Cattle Slurry (liquid) -4%DM",1.5,null,"28:Use nitrification inhibitors",65,100,"69:Avoid slurry/manure spreading at high risk times",80]
["Arable:Fodder Beet",2,"","","","Cattle Slurry (solid)-20%DM",1,null,"29:Replace urea with ammonium nitrate",95,100,"72:Avoid FYM spreading at high risk times",95]
["Arable:Spring sown grass",26,"","","","Pig Slurry (whole/liquid)-2%DM",2.2000000000000002,null,"67:Calibrate manure spreader",95,100,"332:Reduce dietary N&P intake",90]
["Veg:Brussels sprouts","",1.53,2.5,3.5,"Pig Slurry (whole/liquid)-4%DM",2.5,null,"69:Avoid slurry/manure spreading at high risk times",80,100]
["Veg:White Cabbage Storage","",7.53,2.5499999999999998,0.8,"Pig Slurry (whole/liquid)-6%DM",2.8,null,"72:Avoid FYM spreading at high risk times",95,100,"Grassland options (No fertiliser)","Value"]
["Veg:Head Cabbage pre Dec31st","",5.55,2.5499999999999998,0.8,"Pig Slurry (seperated/liquid)-3%DM",2.2000000000000002,null,"Undersowing of Maize",85,100,"No mitigation options",100]
["Veg:Head Cabbage post Dec31st","",5.3,2.5499999999999998,0.8,"Pig Slurry (seperated/solid)-20%DM",1.3,null,null,null,null,"16:Allow drainage to deteriorate",80]
["Veg:Collards pre Dec31st","",3.92,3.45,0.6,"Biosolid-digested liquid",0.8,null,"Arable Options (No Fertiliser)","Pre-Residual Value","Post-Residual Value","17:Improve drainage",130]
["Veg:Collards post Dec31st","",4.41,3.45,0.6,"Biosolid-digested cake",1.6,null,"No mitigation options",100,100,"18:Maintain ditches",120]
["Veg:Cauliflower (Over Winter)","",1.48,3.45,0.6,"Biosolid - thermally dried",2,null,"4:Plant autumn cover crops",100,50,"20:Plant N-efficient crops",90]
["Veg:Calabrese","",1.63,1.8,3.5,"Biosolid - lime stabilised",0.9,null,"5:Early harvest and establishment",100,70,"67:Calibrate manure spreader",95]
["Veg:Cauliflower Summer","",4.5,3.45,0.6,"Biosolid - composted",0.6,null,"6:Spring instead of autumn cultivation",65,100,"69:Avoid slurry/manure spreading at high risk times",80]
["Veg:Lettuce (Crisp)","",9.48,2.6,1.1000000000000001,null,null,null,"7:Reduced cultivation",80,100,"72:Avoid FYM spreading at high risk times",95]
["Veg:Radish",null,17.7,0.81,7,null,null,null,"12:Maintain SOM levels",120,100]
["Veg:Bulb onions spring","",6.44,1.2,3.5,null,null,null,"16:Allow drainage to deteriorate",80,100,"Grassland options (No manure)","Value"]
["Veg:Bulb onions overwintered","",6.44,1.2,3.5,null,null,null,"17:Improve drainage",130,100,"No mitigation options",100]
["Veg:Leeks","",3.98,2,4,null,null,null,"18:Maintain ditches",120,100,"16:Allow drainage to deteriorate",80]
["Veg:Swede","",5.3,1.35,1.87,null,null,null,"20:Plant N-efficient crops",90,100,"17:Improve drainage",130]
["Veg:Carrots","",2.976,0.82,7,null,null,null,"67:Calibrate manure spreader",95,100,"18:Maintain ditches",120]
["Veg:Peas",35,null,"","",null,null,null,"69:Avoid slurry/manure spreading at high risk times",80,100,"20:Plant N-efficient crops",90]
["Veg:Beans",42,"","","",null,null,null,"72:Avoid FYM spreading at high risk times",95,100,"21:Calibrate fertiliser spreader",95]
["Grass:Dairy grazed",0,"","","",null,null,null,null,null,null,"22:Use fertiliser recommendation system",95]
["Grass:Dairy cut and grazed",0,"","","",null,null,null,"Arable Options (No Manure)","Pre-Residual Value","Post-Residual Value","25:Avoid high risk areas",98]
["Grass:Beef",0,"","","",null,null,null,"No mitigation options",100,100,"26:Avoid high risk times",95]
["Lowland Sheep",0,"",null,null,null,null,null,"4:Plant autumn cover crops",100,50,"27:Use fertiliser placement",98]
["Grass:Silage",0,"",null,null,null,null,null,"5:Early harvest and establishment",100,70,"28:Use nitrification inhibitors",65]
["Outdoor Pigs",0,"",null,null,null,null,null,"6:Spring instead of autumn cultivation",65,100,"29:Replace urea with ammonium nitrate",95]
["Hay (extensive)",26,"",null,null,null,null,null,"7:Reduced cultivation",80,100,"31:Use Clover",80]
["Forestry",0,"",null,null,null,null,null,"12:Maintain SOM levels",120,100]
["Rough Grazing",26,"",null,null,null,null,null,"16:Allow drainage to deteriorate",80,100,"Grassland options (No fertiliser or manure)","Value"]
["Miscellaneous Landuse 1",null,null,null,null,null,null,null,"17:Improve drainage",130,100,"No mitigation options",100]
["Miscellaneous Landuse 2",null,null,null,null,null,null,null,"18:Maintain ditches",120,100,"16:Allow drainage to deteriorate",80]
["Miscellaneous Landuse 3",null,null,null,null,null,null,null,"20:Plant N-efficient crops",90,100,"17:Improve drainage",130]
[null,null,null,null,null,null,null,null,"21:Calibrate fertiliser spreader",95,100,"18:Maintain ditches",120]
[null,null,null,null,null,null,null,null,"22:Use fertiliser recommendation system",95,100,"20:Plant N-efficient crops",90]
[null,null,null,null,null,null,null,null,"25:Avoid high risk areas",98,100]
[null,null,null,null,null,null,null,null,"26:Avoid high risk times",95,100,"Outdoor pigs options","Value"]
[null,null,null,null,null,null,null,null,"27:Use fertiliser placement",98,100,"No mitigation options",100]
[null,null,null,null,null,null,null,null,"28:Use nitrification inhibitors",65,100,"34:Phase feeding of livestock",98]
[null,null,null,null,null,null,null,null,"29:Replace urea with ammonium nitrate",95,100,"332:Reduce dietary N&P intake",90]
[]
[null,null,null,null,null,null,null,null,"Arable Options (No Fertiliser or Manure)","Pre-Residual Value","Post-Residual Value"]
[null,null,null,null,null,null,null,null,"No mitigation options",100,100]
[null,null,null,null,null,null,null,null,"4:Plant autumn cover crops",100,50]
[null,null,null,null,null,null,null,null,"5:Early harvest and establishment",100,70]
[null,null,null,null,null,null,null,null,"6:Spring instead of autumn cultivation",65,100]
[null,null,null,null,null,null,null,null,"7:Reduced cultivation",80,100]
[null,null,null,null,null,null,null,null,"12:Maintain SOM levels",120,100]
[null,null,null,null,null,null,null,null,"16:Allow drainage to deteriorate",80,100]
[null,null,null,null,null,null,null,null,"17:Improve drainage",130,100]
[null,null,null,null,null,null,null,null,"18:Maintain ditches",120,100]
[null,null,null,null,null,null,null,null,"20:Plant N-efficient crops",90,100]
[]
[null,null,null,null,null,null,null,null,"Arable options","Pre-Residual Value","Post-Residual Value"]
[null,null,null,null,null,null,null,null,"No mitigation options",100,100]
[null,null,null,null,null,null,null,null,"4:Plant autumn cover crops",100,50]
[null,null,null,null,null,null,null,null,"5:Early harvest and establishment",100,70]
[null,null,null,null,null,null,null,null,"6:Spring instead of autumn cultivation",65,100]
[null,null,null,null,null,null,null,null,"7:Reduced cultivation",80,100]
[null,null,null,null,null,null,null,null,"12:Maintain SOM levels",120,100]
[null,null,null,null,null,null,null,null,"16:Allow drainage to deteriorate",80,100]
[null,null,null,null,null,null,null,null,"17:Improve drainage",130,100]
[null,null,null,null,null,null,null,null,"18:Maintain ditches",120,100]
[null,null,null,null,null,null,null,null,"20:Plant N-efficient crops",90,100]
[null,null,null,null,null,null,null,null,"21:Calibrate fertiliser spreader",95,100]
[null,null,null,null,null,null,null,null,"22:Use fertiliser recommendation system",95,100]
[null,null,null,null,null,null,null,null,"23:Integrate fertiliser and manure",90,100]
[null,null,null,null,null,null,null,null,"25:Avoid high risk areas",98,100]
[null,null,null,null,null,null,null,null,"26:Avoid high risk times",95,100]
[null,null,null,null,null,null,null,null,"27:Use fertiliser placement",98,100]
[null,null,null,null,null,null,null,null,"28:Use nitrification inhibitors",65,100]
[null,null,null,null,null,null,null,null,"29:Replace urea with ammonium nitrate",95,100]
[null,null,null,null,null,null,null,null,"67:Calibrate manure spreader",95,100]
[null,null,null,null,null,null,null,null,"69:Avoid slurry/manure spreading at high risk times",80,100]
[null,null,null,null,null,null,null,null,"72:Avoid FYM spreading at high risk times",95,100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,""]

{"sheet":"Rotation1","index":7,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Year",null,"Field Name","Uncultivated Margin (m)","Land Use","Fertiliser N \n(kg)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount (t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Yield (t/ha)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16,null,null,null,null,null,null,null,null," "]
[17]
[18]
[19]
[20]

{"sheet":"TestData","index":8,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Field Number","Field Name","Agreed Area (ha)","Uncultivated Margin (m)","Year in Rotation","Land Use","Fertiliser N (kg)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount (t/ha)","Manure 2 Timing","N Index","Mitigation options","Stocking Density","Grazing Period","Yield (t/ha)"]
[1,"a",20,2,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,4,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,6,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,8,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,10,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
["Effect of headland width"]
[]
[1,"a",20,2,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,4,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,6,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,8,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
[1,"a",20,10,null,"Arable:Winter Wheat",180,"Fresh Cattle FYM",25,1,"None",0,1,1,null,"n/a","n/a",9.5]
["Effect of mitigation options"]
[]
[]
[1,"a",20,2,null,"Grass:Dairy grazed",250,"None",0,1,"None",0,1,1,null,"Dairy-H(2-4)","Grazed",999]
[2,"b",20,2,null,"Grass:Dairy cut and grazed",250,"None",0,1,"None",0,1,1,null,"Dairy-H(2-4)","1cut,grazed",999]
[3,"c",20,2,null,"Grass:Dairy cut and grazed",250,"None",0,1,"None",0,1,1,null,"Dairy-H(2-4)","2cuts,grazed",999]
[4,"d",20,2,null,"Grass:Silage",250,"None",0,1,"None",0,1,1,null,"n/a","Cut only",999]
[5,"e",20,2,null,"Hay (extensive)",0,"None",0,1,"None",0,1,1,null,"n/a","Cut only",999]
["Effect of grazing and cutting on grassland"]

{"sheet":"Rotation2","index":9,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Year",null,"Field Name","Uncultivated Margin (m)","Land Use","Fertiliser N (kg)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount (t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Yield (t/ha)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Rotation3","index":10,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Year",null,"Field Name","Uncultivated Margin (m)","Land Use","Fertiliser N (kg)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount (t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Yield (t/ha)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Rotation4","index":11,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Year",null,"Field Name","Uncultivated Margin (m)","Land Use","Fertiliser N (kg)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount (t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Yield (t/ha)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Rotation5","index":12,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Year",null,"Field Name","Uncultivated Margin (m)","Land Use","Fertiliser N (kg)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount (t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Yield (t/ha)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Rotation6","index":13,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Year",null,"Field Name","Uncultivated Margin (m)","Land Use","Fertiliser N (kg)","Fertiliser Guidance\nfrom RB209\n(Min - Max)","Manure 1 Type","Manure 1 Amount (t/ha)","Manure 1 Timing","Manure 2 Type","Manure2  Amount (t/ha)","Manure 2 Timing","Soil\nN Index","Mitigation options","Stocking Density","Grazing Period","Yield (t/ha)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"AtmosphericDeposition","index":14,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Atmospheric deposition"]
[null,"Your fields are predominanlty in National Grid square:","This square an average atmospheric N deposition of:",null,null,null,null,null,null,"HP",5]
[null,{"$f":"LEFT(BaseData!K5,2)","v":""},{"$f":"VLOOKUP(B4,J3:K56,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"HT",5]
[null,null,null,null,null,null,null,null,null,"HU",10]
[null,null,null,null,null,null,null,null,null,"HW",5]
[null,null,null,null,null,null,null,null,null,"HX",5]
[null,null,null,null,null,null,null,null,null,"HY",5]
[null,null,null,null,null,null,null,null,null,"HZ",5]
[null,null,null,null,null,null,null,null,null,"NA",5]
[null,null,null,null,null,null,null,null,null,"NB",5]
[null,null,null,null,null,null,null,null,null,"NC",5]
[null,null,null,null,null,null,null,null,null,"ND",5]
[null,null,null,null,null,null,null,null,null,"NF",5]
[null,null,null,null,null,null,null,null,null,"NG",5]
[null,null,null,null,null,null,null,null,null,"NH",11]
[null,null,null,null,null,null,null,null,null,"NJ",15]
[null,null,null,"Taken from DEFRA http://pollutantdeposition.defra.gov.uk/node/665",null,null,null,null,null,"NK",11]
[null,null,null,null,null,null,null,null,null,"NL",11]
[null,null,null,null,null,null,null,null,null,"NM",15]
[null,null,null,null,null,null,null,null,null,"NN",25]
[null,null,null,null,null,null,null,null,null,"NO",15]
[null,null,null,null,null,null,null,null,null,"NR",15]
[null,null,null,null,null,null,null,null,null,"NS",20]
[null,null,null,null,null,null,null,null,null,"NT",13]
[null,null,null,null,null,null,null,null,null,"NU",11]
[null,null,null,null,null,null,null,null,null,"NX",20]
[null,null,null,null,null,null,null,null,null,"NY",25]
[null,null,null,null,null,null,null,null,null,"NZ",20]
[null,null,null,null,null,null,null,null,null,"SC",20]
[null,null,null,null,null,null,null,null,null,"SD",20]
[null,null,null,null,null,null,null,null,null,"SE",20]
[null,null,null,null,null,null,null,null,null,"TA",20]
[null,null,null,null,null,null,null,null,null,"SH",30]
[null,null,null,null,null,null,null,null,null,"SJ",20]
[null,null,null,null,null,null,null,null,null,"SK",20]
[null,null,null,null,null,null,null,null,null,"TF",20]
[null,null,null,null,null,null,null,null,null,"TG",20]
[null,null,null,null,null,null,null,null,null,"SM",20]
[null,null,null,null,null,null,null,null,null,"SN",30]
[null,null,null,null,null,null,null,null,null,"SO",20]
[null,null,null,null,null,null,null,null,null,"SP",20]
[null,null,null,null,null,null,null,null,null,"TL",20]
[null,null,null,null,null,null,null,null,null,"TM",20]
[null,null,null,null,null,null,null,null,null,"SR",20]
[null,null,null,null,null,null,null,null,null,"SS",20]
[null,null,null,null,null,null,null,null,null,"ST",20]
[null,null,null,null,null,null,null,null,null,"SU",20]
[null,null,null,null,null,null,null,null,null,"TQ",20]
[null,null,null,null,null,null,null,null,null,"TR",15]
[null,null,null,null,null,null,null,null,null,"SV",15]
[null,null,null,null,null,null,null,null,null,"SW",15]
[null,null,null,null,null,null,null,null,null,"SX",25]
[null,null,null,null,null,null,null,null,null,"SY",20]
[null,null,null,null,null,null,null,null,null,"SZ",15]
[null,null,null,null,null,null,null,null,null,"TV",15]

{"sheet":"NCycle","index":15,"n_rows":89,"n_cols":11,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Coefficients in second order polynomial functions derived by Ian Martin (Environment Agency) based on the N-Cycle model."]
[]
[null,"All curves are of the form Ax2 + Bx + C"]
[]
[]
[null,"Climate Zone 1"]
[null,null,"Cut grass baseline",null,null,"Beef - Excreta at risk",null,null,"Dairy - Excreta at risk"]
[null,"Soil/drainage","A","B","C","A","B","C","A","B","C"]
[null,"Sand-Good",3.1E-4,7.6399999999999996E-2,5.41,2.0499999999999999E-6,-7.47E-5,-8.5299999999999994E-3,3.6399999999999999E-6,-2.43E-4,-1.2200000000000001E-2]
[null,"Loam-Moderate",1.92E-4,5.1799999999999999E-2,3.98,1.3799999999999999E-6,-7.3899999999999994E-5,-8.5299999999999994E-3,1.9800000000000001E-6,-5.8799999999999999E-5,-1.2200000000000001E-2]
[null,"Clay-Poor",6.7500000000000001E-5,1.35E-2,0.78600000000000003,4.2E-7,1.31E-5,-8.5299999999999994E-3,5.2600000000000002E-7,5.3999999999999998E-5,-1.2200000000000001E-2]
[]
[]
[]
[null,"Climate Zone 2"]
[null,null,"Cut grass baseline",null,null,"Beef - Excreta at risk",null,null,"Dairy - Excreta at risk"]
[null,"Soil/drainage","A","B","C","A","B","C","A","B","C"]
[null,"Sand-Good",3.0400000000000002E-4,6.3500000000000001E-2,3.87,1.6500000000000001E-6,5.3999999999999998E-5,-1.2200000000000001E-2,3.5999999999999998E-6,-2.42E-4,-1.2200000000000001E-2]
[null,"Loam-Moderate",1.8799999999999999E-4,4.2700000000000002E-2,2.81,9.9999999999999995E-7,5.3999999999999998E-5,-1.2200000000000001E-2,1.9099999999999999E-6,-4.9700000000000002E-5,-1.2200000000000001E-2]
[null,"Clay-Poor",6.6099999999999994E-5,1.14E-2,0.58099999999999996,3.22E-7,5.3999999999999998E-5,-1.2200000000000001E-2,4.8299999999999997E-7,6.2399999999999999E-5,-1.2200000000000001E-2]
[]
[]
[]
[null,"Climate Zone 3"]
[null,null,"Cut grass baseline",null,null,"Beef - Excreta at risk",null,null,"Dairy - Excreta at risk"]
[null,"Soil/drainage","A","B","C","A","B","C","A","B","C"]
[null,"Sand-Good",2.9799999999999998E-4,5.1200000000000002E-2,2.61,1.57E-6,6.2500000000000001E-5,-1.2200000000000001E-2,3.49E-6,-2.2499999999999999E-4,-1.2200000000000001E-2]
[null,"Loam-Moderate",1.84E-4,3.4099999999999998E-2,1.87,9.4399999999999998E-7,6.2500000000000001E-5,-1.2200000000000001E-2,1.8300000000000001E-6,-4.0399999999999999E-5,-1.2200000000000001E-2]
[null,"Clay-Poor",6.5199999999999999E-5,9.4000000000000004E-3,0.41199999999999998,2.28E-7,6.2399999999999999E-5,-1.2200000000000001E-2,4.4200000000000001E-7,6.9599999999999998E-5,-1.2200000000000001E-2]
[]
[]
[]
[null,"Climate Zone lookup"]
[]
[null,"HP",2]
[null,"HT",2]
[null,"HU",2]
[null,"HW",null,null,null,null,null,null,null,"Red",1]
[null,"HX",null,null,null,null,null,null,null,"Blue",2]
[null,"HY",null,null,null,null,null,null,null,"White",3]
[null,"HZ"]
[null,"NA"]
[null,"NB"]
[null,"NC",3,null,null,null,null,null,null,"Your fields are predominanlty in National Grid square:"]
[null,"ND",2,null,null,null,null,null,null,{"$f":"LEFT(BaseData!K5,2)","v":""}]
[null,"NF",2]
[null,"NG",2,null,null,null,null,null,null,"Climate Zone:"]
[null,"NH",3,null,null,null,null,null,null,{"$f":"VLOOKUP(J46,B36:C89,2,FALSE)","v":{"$error":"#N/A"}}]
[null,"NJ",3]
[null,"NK",2]
[null,"NL",2]
[null,"NM",2]
[null,"NN",3]
[null,"NO",2]
[null,"NR",2]
[null,"NS",3]
[null,"NT",3]
[null,"NU",2]
[null,"NX",2]
[null,"NY",3]
[null,"NZ",2]
[null,"SC",2]
[null,"SD",2]
[null,"SE",3]
[null,"TA",2]
[null,"SH",1]
[null,"SJ",2]
[null,"SK",3]
[null,"TF",2]
[null,"TG",1]
[null,"SM",1]
[null,"SN",3]
[null,"SO",2]
[null,"SP",1]
[null,"TL",1]
[null,"TM",1]
[null,"SR",1]
[null,"SS",1]
[null,"ST",1]
[null,"SU",1]
[null,"TQ",1]
[null,"TR",1]
[null,"SV",1]
[null,"SW",1]
[null,"SX",1]
[null,"SY",1]
[null,"SZ",1]
[null,"TV",1]

{"sheet":"Version Log","index":16,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,0,13,4],[26,0,26,4]]}
["Version","Date","Changes (Short)\n!Marks changes that will affect leaching results ","Implications for Results","Detailed changes to last version"]
[1.01,"Oct 2015","code restructuring, remove duplication","none","Module RotationNLosses commented out, Function wksnam copied to new Module Functions"]
[1.02,"Oct 2015","code restructuring, remove duplication","none","Module Leaching commented out, All relevant Functions (Function ArableOfftake, Function VegetableOfftake, Sub Nleach, Sub IntrinsicRisk, Sub PieChart, Function ReportFormatNumber) copied to new Module Functions"]
[1.03,"Oct 2015","code restructuring, remove duplication","none","Module Scenarios commented out"]
[1.04,"Oct 2015","code restructuring, remove duplication","none","The three modules RotationNLosses, Leaching and Scenarios permanently removed (commented out before)"]
[1.05,"Oct 2015","code restructuring, remove duplication","none","Several small changes to code: Error Handlers, GoTo statements removed, some duplication removed, additional comments for readability, code restructuring"]
[1.06,"Oct 2015","code restructuring, remove duplication","none","Tab Literature Values now redundant, all land use information now stored within tab Templates, fixed a few oddities (rotations calcs) "]
[1.07,"Oct 2015","4 year rotation averages output added","none","reintoduced 4 year rotation averages into tab ActualLandUse and Scenario Col Z and AA, format, more comments"]
[1.08,"Nov 2015","added functionality: Outdoor Pigs","none","Tab Literature Values deleted, added functionality outdoor pigs introduced (point 1 in memo)"]
[1.0900000000000001,"Nov 2015","!now included: Mitigation options for Grassland\nadded functionality: N Fixers\nadded functionality: Soil Index 0","Grassland fields with mitigation options will subsequently differ!","Mitigation options are now included in Grassland calculation output, N Fixers now included, A Soil N Index of zero now available"]
["1.10","Nov 2015","Redesign of the Templates tab\nadded functionality: Outdoor Pigs (Stocking Density editable)","none\n(check Stocking Densities - previously hard coded)","Redesign of the Template tab (info boxes for parameters, transparency of used values), Seperate livestock section added with editable Stocking Densities (previously hardcoded), Clear distinction between standard (literature) and user defined values, pop-up message when default values are changed"]
["1.12","Jan 2016","!now included: Headland correction for Grassland\nadded functionality: User defined rotation years\nnow included: Climate Zone 3\nbug fix: Offtake with Arable: Veg\nbug fix: Residual N < zero","Grassland fields with unused headland will subsequently differ!","User defined Rotation periods (was limited to 4 years) - User form to input up to 20 rotation years via button \"Add/Edit Rotation Year\", values for Climate Zone 3 updated using grassland curves (values were a copy of Zone 2 before) , Bug fixes: ResidualN can now not go below zero (when offtake greater than BaseN Input), Offtake calculation for Arable: Vegetables fixed (was not calculated correctly before), Headland correction now included for Grassland (previously not included/presumed to be zero)"]
["1.13","Jan 2016","\nadded functionality: Lowland sheep (as Grassland option)\nadded functionality: Update on user defined rotation years\nadded functionality: N Fixers (Offtake values updated)\n!bug fix: Min Arable ResidualN = 20 kg N/ha","Fields that have a ResidualN < 20 kg N/ha will subsequently differ!","Finalise implementation of user defined Rotation periods: \"Use Rotation\" button in ActualLandUse now recognises user defined rotation period lengths (i.e <> 4 years) and displays available years, Minimum Arable ResidualN introduced as contant value = 20 (previously not correctly implemented i.e. didn't work), Offtake calculation for N Fixers fixed using crop nitrogen content % from EUROSTAT, Introducing lowland sheep as additional Grassland option"]
["Phase 2"]
[2.0099999999999998,"Feb 2016","added functionality: Lowland sheep (testing)","none","Testing"]
[2.02,"Feb 2016","!update: Lowland sheep (now based on Farmscoper)\n!update: Outdoor Pigs ratios\nupdate: Fertiliser rates in Templates tab\nnow included: Fertiliser warning in Templates tab","Lowland sheep and Outdoor Pigs fields will differ from 1.13!","Introducing lowland sheep with ratios derived from FarmScoper, Ratios for Outdoor Pigs updated (Farmscoper), Updated fertiliser rates in tab Templates, Alert (red highlight on cell) when Fertiliser values in Col C are changed and differ from Col Z (literature values)"]
[2.0299999999999998,"Feb 2016","update:Rotations are field independent (calculated in ALU tab)\nnow included: Fertiliser guidance (min-max) in main calculation tabs","none","Crop Rotations are now independent of fields, Rotation losses are calculated in ActualLandUse/Scenario tabs, fertiliser guidance (min-max) now in col G of all three main calc tabs (will be imported when field entry is made via form or template imported)"]
[2.04,"Feb 2016","update: Cosmetic changes","none","Mainly cosmetic changes: no 999's anymore (n/a), restructured Entry Forms (Main Entry/Rotation/Scenario),  Land uses are sorted more sensibly in Templates tab"]
[2.0499999999999998,"Mar 2016","!update: N content (Asparagus, Brussel Sprouts/Cabbage, Cauliflower)\nupdate: Missing Fertiliser values\nbug fix: Charts in Main","Ncontent update will change result for the 3 arable landuses listed!","Missing fertiliser values in tab Templates added, Updated/fixed charts in Main tab to show correct values, updated Ncontent values for Arable:Asparagus, Brussel Sprouts and Cabbage, Cauliflower"]
[2.06,"Mar 2016","!update: Lowland Sheep & Outdoor Pigs (amended)\nupdate: Variable declarations\n!now included: Manure can be applied to grassland","Lowland sheep and Outdoor Pigs fields will subsequently differ!\nGrassland with manure will subsequently differ!","Amended Pigs and Sheep calculation to simulate Farmscoper better (no SoilIndexN, Fertiliser is leached according to Farmscoper ratio, add leaching from pasture), Code improved: clear variable declarations, Farmscoper values used as constants, ManureN is now calculated in seperate Function and applied to Arable AND Grass Landuse"]
[2.0699999999999998,"Mar 2016","bug fix: Entry forms show selected field data\nbug fix: Point sources chart in Main tab\nupdate: Log file entries for average rotation losses","none","Fixing various issues: Entry Forms now initially show the data from the selected field (only when you select a landuse it will show suggested values), Log file update to show proper Arable/Grassland entries AND Average Rotation losses, Point Sources chart in MainSheet now connected to PointSources Tab"]
[2.08,"Mar 2016","update: explicit variable declaration for all modules","none","Option Explicit activated, declaring every variable"]
[2.09,"April 2016","!update: N content for all arable land use\nnow included: Edit button in tab Templates","Arable fields will subsequently differ!","N content update, sources: PDA, 2008 www.pda.org.uk and EUROSTAT Crop N Coefficients (2011)\nDefine/Edit template Button in MainSheet and Templates now working"]
["2.10","April 2016","!now included: 10% excreta loss\nbug fix: NEAP-N error\nbug fix: Intrinsic risk calculation","Grazed fields will subsequently leach slighty less N! ","Reintroduced the 10% excreta loss via urea volatilisation, Fixed NEAP-N error when Basedata erroneous (e.g. Stored Water = 0), Intrinsic Risk calculation new fixed (broke when Stored Water = 0), Amended mitigation options array size (was fixed at 10)"]
["2.11","April 2016","!update: Yield/N-content Forage Maize","Forage maize fields will subsequently differ!","Yield value for forage maize set to 40 t/ha and N content (4%) - PDA, 2008 (http://www.pda.org.uk/pda_leaflets/17-forage-maize-fertiliser-requirements/)  "]
["2.12","June 2016","now included: Omit subsequent 'no entry' warning message","none","No Entry Warning Message changed to separate form with tick box to omit subsequent messages"]
["Phase 3"]
["3.01","Jan 2017","now included: Fertiliser warning pop-up removed, red highlights instead\nnow included: Omit 'no entry' warning messages gloabally\nnow included: Chart for Land Use in Main tab","none","Fertiliser pop-up warning removed, red highlights introduced (when feriliser values exceed recommendations), tick box to omit flag for empty/missing fields completely, additional chart for LandUse types in the Main sheet, fixed the field number lookup function to check for split field/additional empty characters seperatly, version log, version number in start-up splash screen, several additional error handlers (assist user input)"]
["3.02","Jan 2017","bug fix: Data entry form can works beyond row 100\nbug fix: No limit on Mitigation Options ","none","The data entry form did not populate rows > 100 (hard coded) this has been fixed - data can now be entered in any row, Mitigation Options were limited to 10 (array size) changed to open array i.e. any number possible"]
[3.03,"Jan 2017","!bug fix: Lowland sheep and outdoor pigs calculation","Lowland sheep and Outdoor Pigs fields will subsequently differ!","Lowland sheep and Outdoor pigs calculation were appliying the area of the field as a factor to base soil leaching value (4.05 kg N/ha) taken from Farmscoper to replicate Farmscoper results - leading to high leaching per ha values. i.e. unit issue "]
["3.04","Jan 2017","!update: Yield and N-content for several crops updated\n!update: Leguminous nitrogen fixation values","Results for several crops will subsequently differ! (see list in details), Peas and Beans will differ!","Mainly changes to Template and N content values suggested by Ian Martin:  N content: Veg:Cauliflower (Over Winter), Default Yield (tab 'Templates'): Carrots (changed from 150 to 63.1), N content Forage Maize (changed from 4 to 3), N content for Ryegrass (seed), Spring sown grass,Hay (extensive) and Rough Grazing slightly different because now rounded (changed from 25.81 to 26), Amount of nitrogen fixed by Peas and Beans changed from 45 kg N/ha to 140.7 kg N/ha and 224.6 kg N/ha respectively."]
["3.05","June 2017","!bug fix: Manure application to Outdoor Pigs and Lowland Sheep\n!update: SNS figures change to lower end of the RB209 ranges  \nnow included: Option to create up to 3 Miscellaneous Land Uses\nnow included: All Data Entry windows scalable \nnow included: Denitrification (%)  of inorganic fertiliser\nnow included: Columns highlighted that should only be edited with Entry Form\nnow included: Output naming of \"N Load (kg N)\" changed to \"Total N Loss (kg N)\"","Lowland sheep and Outdoor Pigs fields with manure application will subsequently differ!\nFields with a SN Index other than zero will subsequently differ!","Ratio of manure application to leaching from manure (derived from Farmscoper: worst case - PigFYM = 35%) introduced into calculation of Outdor Pigs and Lowland Sheep .i.e. only 35% of the N from applied manure is at risk of leaching. This was done to be consistent with the other N inputs to Pigs and Sheep (fertiliser/excreta) which are adapted using Farmscoper ratios.\nSNS figures used in NLT have been modified from the higher to the lower end of the RB209 ranges (See \"Templates\").\nUp to 3 miscellaneous land uses can be created by the user in \"Templates\" and then used as any other landuse (additional information needs to be entered).\nData entry forms are now scalable to accommodate for PC's with lower resolution that used to cut off parts of the forms.\nDenitrification of inorganic fertiliser can be specified at the top of the “Actual Land Use” tab and will be applied to all fields.\nColumns in \"ActualLandUse\" and \"ScenarioLandUse\" that should only be edited using the Field Data Entry form are marked with light green headers.\nNaming of the Annual Losses \"N Load (kg N)\" in the orange Output Results section in \"ActualLandUse\" and \"ScenarioLandUse\" has been changed to \"Total N Loss (kg N)\" for clarity."]
["3.06","Mar 2019","Updated fertiliser rates based on BSFP 2018 and RB209 2019.","Default fertiliser rates for most crops will change.","Changes to templates for most crops. Default fertilser rates updated to be consistent with BSFP 2018 (based on 2017 data) and max and min rates updated to be consistent with RB209 (2019)."]
["3.07","Mar 2019","Change to yield coefficients for radish","Results for radish crops will change.","Updates to 'a' and 'b' coefficients for radish crops. See comments in ListOptions tab."]
["3.08","Nov 2020","Splash screen activated\nPoint Source data removed","none","The splash screen had been deactivated (in empty NLT) sheets due to conflicts with the new GIS python code. We have now re-activated the splash screen in empty NLT sheets.\nThe point source tab had some superfluous data in the yellow user entry cells. This has been removed."]