{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","Results","About"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Calculator","index":0,"n_rows":367,"n_cols":109,"rows_kept":367,"cut":false,"hidden":false,"merged":[[194,1,197,1],[205,11,205,12],[206,11,206,12],[200,9,200,10],[200,11,200,12],[201,11,201,12],[202,11,202,12],[203,11,203,12],[204,11,204,12],[206,9,206,10],[207,9,207,10],[111,7,111,8],[120,7,121,8],[201,9,201,10],[202,9,202,10],[124,9,124,11],[125,9,125,11],[127,9,127,11],[164,9,164,11],[118,7,118,8],[286,10,286,15],[129,9,129,11],[135,9,135,11],[175,9,175,11],[166,9,166,11],[168,9,168,11],[173,9,173,11],[139,9,139,11],[141,9,141,11],[177,9,177,11],[203,9,203,10],[204,9,204,10],[205,9,205,10],[207,11,207,12],[208,11,208,12],[208,9,208,10],[198,22,199,24],[179,9,179,11],[183,9,183,11],[190,8,191,10],[195,8,195,10],[1,1,1,12],[119,1,120,1],[76,1,78,1],[115,1,117,1],[109,1,112,1],[4,1,6,1],[10,1,12,1],[24,9,25,12],[17,1,21,1],[50,1,57,1],[80,1,82,1],[84,1,86,1],[88,1,90,1],[116,6,116,10],[110,7,110,8],[17,23,19,23],[192,21,193,21],[192,22,193,22],[27,31,27,33],[25,21,26,21],[25,22,26,22],[25,27,26,27],[25,30,26,30]]}
[{"$nulls":18},"       "]
[]
[]
[{"$nulls":5},"click below to change"]
[null,"Crop type",null,null,"Crop type","nabim 1 - wheat for breadmaking",{"$nulls":15},{"$f":"F5","v":"nabim 1 - wheat for breadmaking"}]
[]
[{"$nulls":4},"Planting season","Winter",{"$nulls":15},{"$f":"F7","v":"Winter"}]
[]
[]
[{"$nulls":8},"Select below:"]
[null,"Yield",1,null,"Yield ",5,"Tonnes per ha as :",null,"Fresh weight",{"$nulls":12},"tonnes/ha fresh",{"$f":"W14*100/(100-F13)","v":5}]
[]
[{"$nulls":4},"% moisture at harvest",20,{"$nulls":15},"water dried (tonnes)",{"$f":"(F13-F192)/100*W14","v":0.22}]
[{"$nulls":21},"dry weight",{"$f":"IF(I11=\"Fresh weight\",F11-F11*(F13/100),F11-F11*(F192/100))","v":4}]
[]
[]
[{"$nulls":5},"Soil type percentages"]
[null,"Soil type",null,null,"Light",100,null,null,{"$f":"IF((F18+F20+F22)>100,\"Error: total percentage of soil types must be less than 100\",\"\")","v":""},{"$nulls":12},"default medium",{"$f":"100-F18","v":0},"for data entry"]
[]
[{"$nulls":4},"Medium",{"$nulls":16},"default heavy",{"$f":"W18-F20","v":0}]
[]
[{"$nulls":4},"Heavy",{"$nulls":16},"average soil carbon texture",{"$f":"(F18*1+F20*2+F22*3)/100","v":1}]
[]
[]
[]
[{"$nulls":5},"Click the arrows or move the bars  below to alter the input values in the boxes",{"$nulls":15},"Index for fertiliser look-up","amount product applied (kg)",{"$nulls":4},"indirect from leaching",null,null,"production technology (2 if abated N)"]
[{"$nulls":9},"%N","% P2O5","%  K2O","% SO3","Abated Yes/No?",{"$nulls":9},"%N","N applied",null,"N2O emissions",null,null,"ignoring fillers",{"$nulls":4},"fertiliser production emissions","FYM applied","Compost applied","CaCO3 applied","Urea applied"]
[{"$nulls":4},"Ammonium nitrate",null,null,0,null,{"$f":"OFFSET(H$227,$V28,)","v":0.34},{"$f":"OFFSET(K$227,$V28,)","v":0},{"$f":"OFFSET(L$227,$V28,)","v":0},{"$f":"OFFSET(N$227,$V28,)","v":0},"No",{"$f":"IF(AD28>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},2,{"$f":"H28","v":0},{"$f":"J28","v":0.34},{"$f":"X28*W28","v":0},null,{"$f":"0.01*Y28","v":0},{"$f":"0.01*0.3*Y28","v":0},null,{"$f":"IF(ISERROR(J28/OFFSET(H$227,$V28,)),0,J28/OFFSET(H$227,$V28,))","v":1},{"$f":"SUMIF(V$243:V$244,N28,W$243:W$244)","v":1},"Ammonium sulphate nitrate mix",null,null,{"$f":"AD28*W28*OFFSET(Calculator!O$227,$V28,AE28)","v":0},{"$f":"IF($E28<>\"\",IF(SUMIF($AC$304:$AC$306,$E28,$AG$304:$AG$306)=1,W28,0),0)","v":0},{"$f":"IF($E28<>\"\",IF(SUMIF($AC$304:$AC$306,$E28,$AG$304:$AG$306)=2,W28,0),0)","v":0},{"$f":"IF($E28<>\"\",IF(SUMIF($AC$304:$AC$306,$E28,AG$304:AG$306)=3,W28*OFFSET(Calculator!M$227,V28,0),0),0)","v":0},{"$f":"IF(E28=E$248,W28,IF(E28=E$249,W28*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Ammonium sulphate",null,null,0,null,{"$f":"OFFSET(H$227,$V30,)","v":0.21},{"$f":"OFFSET(K$227,$V30,)","v":0},{"$f":"OFFSET(L$227,$V30,)","v":0},{"$f":"OFFSET(N$227,$V30,)","v":0.6},null,{"$f":"IF(AD30>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},3,{"$f":"H30","v":0},{"$f":"J30","v":0.21},0,null,{"$f":"0.01*Y30","v":0},0,null,{"$f":"IF(ISERROR(J30/OFFSET(H$227,$V30,)),0,J30/OFFSET(H$227,$V30,))","v":1},1,"% AN","%AS",null,{"$f":"AD30*W30*OFFSET(Calculator!O$227,$V30,AE30)","v":0},{"$f":"IF($E30<>\"\",IF(SUMIF($AC$304:$AC$306,$E30,$AG$304:$AG$306)=1,W30,0),0)","v":0},{"$f":"IF($E30<>\"\",IF(SUMIF($AC$304:$AC$306,$E30,$AG$304:$AG$306)=2,W30,0),0)","v":0},{"$f":"IF($E30<>\"\",IF(SUMIF($AC$304:$AC$306,$E30,AG$304:AG$306)=3,W30*OFFSET(Calculator!M$227,V30,0),0),0)","v":0},{"$f":"IF(E30=E$248,W30,IF(E30=E$249,W30*(0.25/0.73),0))","v":0}]
[]
[null,"N fertilisers",null,null,"Ammonium sulphate nitrate",null,null,0,null,0.21,{"$f":"OFFSET(K$227,$V32,)","v":0},{"$f":"OFFSET(L$227,$V32,)","v":0},{"$f":"OFFSET(N$227,$V32,)","v":0.6},"No",{"$f":"IF(SUM(AF32:AG32)>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},4,{"$f":"H32","v":0},{"$f":"J32","v":0.21},0,null,0,0,null,{"$f":"IF(ISERROR(J32/OFFSET(H$227,$V32,)),0,J32/OFFSET(H$227,$V32,))","v":1},{"$f":"SUMIF(V$243:V$244,N32,W$243:W$244)","v":1},{"$f":"(J32-OFFSET(H$227,$V30,))/(OFFSET(H$227,$V28,)-OFFSET(H$227,$V30,))","v":0},{"$f":"M32/OFFSET(N$227,$V30,)","v":1},null,{"$f":"W32*(AF32*OFFSET(Calculator!O$227,$V28,AE32)+AG32*OFFSET(Calculator!O$227,$V30,AE30))","v":0},{"$f":"IF($E32<>\"\",IF(SUMIF($AC$304:$AC$306,$E32,$AG$304:$AG$306)=1,W32,0),0)","v":0},{"$f":"IF($E32<>\"\",IF(SUMIF($AC$304:$AC$306,$E32,$AG$304:$AG$306)=2,W32,0),0)","v":0},{"$f":"IF($E32<>\"\",IF(SUMIF($AC$304:$AC$306,$E32,AG$304:AG$306)=3,W32*OFFSET(Calculator!M$227,V32,0),0),0)","v":0},{"$f":"IF(E32=E$248,W32,IF(E32=E$249,W32*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Calcium ammonium nitrate",null,null,0,null,{"$f":"OFFSET(H$227,$V34,)","v":0.27},{"$f":"OFFSET(K$227,$V34,)","v":0},{"$f":"OFFSET(L$227,$V34,)","v":0},{"$f":"OFFSET(N$227,$V34,)","v":0},"No",{"$f":"IF(AD34>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},6,{"$f":"H34","v":0},{"$f":"J34","v":0.27},0,null,0,0,null,{"$f":"IF(ISERROR(J34/OFFSET(H$227,$V34,)),0,J34/OFFSET(H$227,$V34,))","v":1},{"$f":"SUMIF(V$243:V$244,N34,W$243:W$244)","v":1},null,null,null,{"$f":"AD34*W34*OFFSET(Calculator!O$227,$V34,AE34)","v":0},{"$f":"IF($E34<>\"\",IF(SUMIF($AC$304:$AC$306,$E34,$AG$304:$AG$306)=1,W34,0),0)","v":0},{"$f":"IF($E34<>\"\",IF(SUMIF($AC$304:$AC$306,$E34,$AG$304:$AG$306)=2,W34,0),0)","v":0},{"$f":"IF($E34<>\"\",IF(SUMIF($AC$304:$AC$306,$E34,AG$304:AG$306)=3,W34*OFFSET(Calculator!M$227,V34,0),0),0)","v":0},{"$f":"IF(E34=E$248,W34,IF(E34=E$249,W34*(0.25/0.73),0))","v":0}]
[{"$nulls":8},"Choose correct units:"]
[{"$nulls":4},"Urea",null,null,0,"kgs/ha product",{"$f":"OFFSET(H$227,$V36,)","v":0.46399999999999997},{"$f":"OFFSET(K$227,$V36,)","v":0},{"$f":"OFFSET(L$227,$V36,)","v":0},{"$f":"OFFSET(N$227,$V36,)","v":0},null,{"$f":"IF(AD36>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},21,{"$f":"H36*OFFSET(V258,1,SUMIF(Z259:Z260,I36,AA259:AA260))","v":0},{"$f":"J36","v":0.46399999999999997},{"$f":"X36*W36","v":0},null,0,{"$f":"0.01*0.3*Y36","v":0},null,{"$f":"IF(ISERROR(J36/OFFSET(H$227,$V36,)),0,J36/OFFSET(H$227,$V36,))","v":1},1,null,null,null,{"$f":"AD36*W36*OFFSET(Calculator!O$227,$V36,AE36)","v":0},{"$f":"IF($E36<>\"\",IF(SUMIF($AC$304:$AC$306,$E36,$AG$304:$AG$306)=1,W36,0),0)","v":0},{"$f":"IF($E36<>\"\",IF(SUMIF($AC$304:$AC$306,$E36,$AG$304:$AG$306)=2,W36,0),0)","v":0},{"$f":"IF($E36<>\"\",IF(SUMIF($AC$304:$AC$306,$E36,AG$304:AG$306)=3,W36*OFFSET(Calculator!M$227,V36,0),0),0)","v":0},{"$f":"IF(E36=E$248,W36,IF(E36=E$249,W36*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Urea ammonium nitrate solution",null,null,0,"kgs/ha product",{"$f":"OFFSET(H$227,$V38,)","v":0.32},{"$f":"OFFSET(K$227,$V38,)","v":0},{"$f":"OFFSET(L$227,$V38,)","v":0},{"$f":"OFFSET(N$227,$V38,)","v":0},"No",{"$f":"IF(AD38>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},22,{"$f":"H38*OFFSET(V258,2,SUMIF(Z259:Z260,I38,AA259:AA260))","v":0},{"$f":"J38","v":0.32},{"$f":"X38*W38","v":0},null,0,{"$f":"0.01*0.3*Y38","v":0},null,{"$f":"IF(ISERROR(J38/OFFSET(H$227,$V38,)),0,J38/OFFSET(H$227,$V38,))","v":1},{"$f":"SUMIF(V$243:V$244,N38,W$243:W$244)","v":1},null,null,null,{"$f":"AD38*W38*OFFSET(Calculator!O$227,$V38,AE38)","v":0},{"$f":"IF($E38<>\"\",IF(SUMIF($AC$304:$AC$306,$E38,$AG$304:$AG$306)=1,W38,0),0)","v":0},{"$f":"IF($E38<>\"\",IF(SUMIF($AC$304:$AC$306,$E38,$AG$304:$AG$306)=2,W38,0),0)","v":0},{"$f":"IF($E38<>\"\",IF(SUMIF($AC$304:$AC$306,$E38,AG$304:AG$306)=3,W38*OFFSET(Calculator!M$227,V38,0),0),0)","v":0},{"$f":"IF(E38=E$248,W38,IF(E38=E$249,W38*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Calcium nitrate",null,null,0,null,{"$f":"OFFSET(H$227,$V40,)","v":0.15},{"$f":"OFFSET(K$227,$V40,)","v":0},{"$f":"OFFSET(L$227,$V40,)","v":0},{"$f":"OFFSET(N$227,$V40,)","v":0},null,{"$f":"IF(AD40>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},7,{"$f":"H40","v":0},{"$f":"J40","v":0.15},0,null,0,0,null,{"$f":"IF(ISERROR(J40/OFFSET(H$227,$V40,)),0,J40/OFFSET(H$227,$V40,))","v":1},1,null,null,null,{"$f":"AD40*W40*OFFSET(Calculator!O$227,$V40,AE40)","v":0},{"$f":"IF($E40<>\"\",IF(SUMIF($AC$304:$AC$306,$E40,$AG$304:$AG$306)=1,W40,0),0)","v":0},{"$f":"IF($E40<>\"\",IF(SUMIF($AC$304:$AC$306,$E40,$AG$304:$AG$306)=2,W40,0),0)","v":0},{"$f":"IF($E40<>\"\",IF(SUMIF($AC$304:$AC$306,$E40,AG$304:AG$306)=3,W40*OFFSET(Calculator!M$227,V40,0),0),0)","v":0},{"$f":"IF(E40=E$248,W40,IF(E40=E$249,W40*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Compound NK",null,null,0,null,{"$f":"OFFSET(H$227,$V42,)","v":0.14000000000000001},{"$f":"OFFSET(K$227,$V42,)","v":0},{"$f":"OFFSET(L$227,$V42,)","v":0.44},{"$f":"OFFSET(N$227,$V42,)","v":0},null,{"$f":"IF(AD42>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},8,{"$f":"H42","v":0},{"$f":"J42","v":0.14000000000000001},0,null,0,0,null,{"$f":"IF(ISERROR(J42/OFFSET(H$227,$V42,)),0,J42/OFFSET(H$227,$V42,))","v":1},1,null,null,null,{"$f":"AD42*W42*OFFSET(Calculator!O$227,$V42,AE42)","v":0},{"$f":"IF($E42<>\"\",IF(SUMIF($AC$304:$AC$306,$E42,$AG$304:$AG$306)=1,W42,0),0)","v":0},{"$f":"IF($E42<>\"\",IF(SUMIF($AC$304:$AC$306,$E42,$AG$304:$AG$306)=2,W42,0),0)","v":0},{"$f":"IF($E42<>\"\",IF(SUMIF($AC$304:$AC$306,$E42,AG$304:AG$306)=3,W42*OFFSET(Calculator!M$227,V42,0),0),0)","v":0},{"$f":"IF(E42=E$248,W42,IF(E42=E$249,W42*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Anhydrous ammonia",null,null,0,null,{"$f":"OFFSET(H$227,$V44,)","v":0.82},{"$f":"OFFSET(K$227,$V44,)","v":0},{"$f":"OFFSET(L$227,$V44,)","v":0},{"$f":"OFFSET(N$227,$V44,)","v":0},null,{"$f":"IF(AD44>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},5,{"$f":"H44","v":0},{"$f":"J44","v":0.82},{"$f":"X44*W44","v":0},null,0,{"$f":"0.01*0.3*Y44","v":0},null,{"$f":"IF(ISERROR(J44/OFFSET(H$227,$V44,)),0,J44/OFFSET(H$227,$V44,))","v":1},1,null,null,null,{"$f":"AD44*W44*OFFSET(Calculator!O$227,$V44,AE44)","v":0},{"$f":"IF($E44<>\"\",IF(SUMIF($AC$304:$AC$306,$E44,$AG$304:$AG$306)=1,W44,0),0)","v":0},{"$f":"IF($E44<>\"\",IF(SUMIF($AC$304:$AC$306,$E44,$AG$304:$AG$306)=2,W44,0),0)","v":0},{"$f":"IF($E44<>\"\",IF(SUMIF($AC$304:$AC$306,$E44,AG$304:AG$306)=3,W44*OFFSET(Calculator!M$227,V44,0),0),0)","v":0},{"$f":"IF(E44=E$248,W44,IF(E44=E$249,W44*(0.25/0.73),0))","v":0}]
[]
[]
[]
[]
[{"$nulls":4},"Diammonium phosphate",null,null,0,null,{"$f":"OFFSET(H$227,$V49,)","v":0.18},{"$f":"OFFSET(K$227,$V49,)","v":0.46},{"$f":"OFFSET(L$227,$V49,)","v":0},{"$f":"OFFSET(N$227,$V49,)","v":0},null,{"$f":"IF(AD49>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},10,{"$f":"H49","v":0},{"$f":"J49","v":0.18},{"$f":"X49*W49","v":0},null,{"$f":"0.01*Y49","v":0},{"$f":"0.01*0.3*Y49","v":0},null,{"$f":"IF(ISERROR(K49/OFFSET(K$227,$V49,)),0,K49/OFFSET(K$227,$V49,))","v":1},1,null,null,null,{"$f":"AD49*W49*OFFSET(Calculator!O$227,$V49,AE49)","v":0},{"$f":"IF($E49<>\"\",IF(SUMIF($AC$304:$AC$306,$E49,$AG$304:$AG$306)=1,W49,0),0)","v":0},{"$f":"IF($E49<>\"\",IF(SUMIF($AC$304:$AC$306,$E49,$AG$304:$AG$306)=2,W49,0),0)","v":0},{"$f":"IF($E49<>\"\",IF(SUMIF($AC$304:$AC$306,$E49,AG$304:AG$306)=3,W49*OFFSET(Calculator!M$227,V49,0),0),0)","v":0},{"$f":"IF(E49=E$248,W49,IF(E49=E$249,W49*(0.25/0.73),0))","v":0}]
[]
[null,"N, P, and K fertilisers",null,null,"Monoammonium phosphate",null,null,0,null,{"$f":"OFFSET(H$227,$V51,)","v":0.11},{"$f":"OFFSET(K$227,$V51,)","v":0.52},{"$f":"OFFSET(L$227,$V51,)","v":0},{"$f":"OFFSET(N$227,$V51,)","v":0},null,{"$f":"IF(AD51>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},15,{"$f":"H51","v":0},0.11,{"$f":"X51*W51","v":0},null,{"$f":"0.01*Y51","v":0},{"$f":"0.01*0.3*Y51","v":0},null,{"$f":"IF(ISERROR(K51/OFFSET(K$227,$V51,)),0,K51/OFFSET(K$227,$V51,))","v":1},1,null,null,null,{"$f":"AD51*W51*OFFSET(Calculator!O$227,$V51,AE51)","v":0},{"$f":"IF($E51<>\"\",IF(SUMIF($AC$304:$AC$306,$E51,$AG$304:$AG$306)=1,W51,0),0)","v":0},{"$f":"IF($E51<>\"\",IF(SUMIF($AC$304:$AC$306,$E51,$AG$304:$AG$306)=2,W51,0),0)","v":0},{"$f":"IF($E51<>\"\",IF(SUMIF($AC$304:$AC$306,$E51,AG$304:AG$306)=3,W51*OFFSET(Calculator!M$227,V51,0),0),0)","v":0},{"$f":"IF(E51=E$248,W51,IF(E51=E$249,W51*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Phosphate/Rock Phosphate",null,null,0,null,{"$f":"OFFSET(H$227,$V53,)","v":0},{"$f":"OFFSET(K$227,$V53,)","v":0.25},{"$f":"OFFSET(L$227,$V53,)","v":0},{"$f":"OFFSET(N$227,$V53,)","v":0},null,{"$f":"IF(AD53>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},17,{"$f":"H53","v":0},0,{"$f":"X53*W53","v":0},null,0,{"$f":"0.01*0.3*Y53","v":0},null,{"$f":"IF(ISERROR(K53/OFFSET(K$227,$V53,)),0,K53/OFFSET(K$227,$V53,))","v":1},1,null,null,null,{"$f":"AD53*W53*OFFSET(Calculator!O$227,$V53,AE53)","v":0},{"$f":"IF($E53<>\"\",IF(SUMIF($AC$304:$AC$306,$E53,$AG$304:$AG$306)=1,W53,0),0)","v":0},{"$f":"IF($E53<>\"\",IF(SUMIF($AC$304:$AC$306,$E53,$AG$304:$AG$306)=2,W53,0),0)","v":0},{"$f":"IF($E53<>\"\",IF(SUMIF($AC$304:$AC$306,$E53,AG$304:AG$306)=3,W53*OFFSET(Calculator!M$227,V53,0),0),0)","v":0},{"$f":"IF(E53=E$248,W53,IF(E53=E$249,W53*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Super phosphate",null,null,0,null,{"$f":"OFFSET(H$227,$V55,)","v":0},{"$f":"OFFSET(K$227,$V55,)","v":0.21},{"$f":"OFFSET(L$227,$V55,)","v":0},{"$f":"OFFSET(N$227,$V55,)","v":0},null,{"$f":"IF(AD55>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},19,{"$f":"H55","v":0},0,{"$f":"X55*W55","v":0},null,0,{"$f":"0.01*0.3*Y55","v":0},null,{"$f":"IF(ISERROR(K55/OFFSET(K$227,$V55,)),0,K55/OFFSET(K$227,$V55,))","v":1},1,null,null,null,{"$f":"AD55*W55*OFFSET(Calculator!O$227,$V55,AE55)","v":0},{"$f":"IF($E55<>\"\",IF(SUMIF($AC$304:$AC$306,$E55,$AG$304:$AG$306)=1,W55,0),0)","v":0},{"$f":"IF($E55<>\"\",IF(SUMIF($AC$304:$AC$306,$E55,$AG$304:$AG$306)=2,W55,0),0)","v":0},{"$f":"IF($E55<>\"\",IF(SUMIF($AC$304:$AC$306,$E55,AG$304:AG$306)=3,W55*OFFSET(Calculator!M$227,V55,0),0),0)","v":0},{"$f":"IF(E55=E$248,W55,IF(E55=E$249,W55*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Triple super phosphate",null,null,0,null,{"$f":"OFFSET(H$227,$V57,)","v":0},{"$f":"OFFSET(K$227,$V57,)","v":0.48},{"$f":"OFFSET(L$227,$V57,)","v":0},{"$f":"OFFSET(N$227,$V57,)","v":0},null,{"$f":"IF(AD57>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},20,{"$f":"H57","v":0},0,{"$f":"X57*W57","v":0},null,0,{"$f":"0.01*0.3*Y57","v":0},null,{"$f":"IF(ISERROR(K57/OFFSET(K$227,$V57,)),0,K57/OFFSET(K$227,$V57,))","v":1},1,null,null,null,{"$f":"AD57*W57*OFFSET(Calculator!O$227,$V57,AE57)","v":0},{"$f":"IF($E57<>\"\",IF(SUMIF($AC$304:$AC$306,$E57,$AG$304:$AG$306)=1,W57,0),0)","v":0},{"$f":"IF($E57<>\"\",IF(SUMIF($AC$304:$AC$306,$E57,$AG$304:$AG$306)=2,W57,0),0)","v":0},{"$f":"IF($E57<>\"\",IF(SUMIF($AC$304:$AC$306,$E57,AG$304:AG$306)=3,W57*OFFSET(Calculator!M$227,V57,0),0),0)","v":0},{"$f":"IF(E57=E$248,W57,IF(E57=E$249,W57*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Muriate of potash",null,null,0,null,{"$f":"OFFSET(H$227,$V59,)","v":0},{"$f":"OFFSET(K$227,$V59,)","v":0},{"$f":"OFFSET(L$227,$V59,)","v":0.6},{"$f":"OFFSET(N$227,$V59,)","v":0},null,{"$f":"IF(AD59>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},16,{"$f":"H59","v":0},0,{"$f":"X59*W59","v":0},null,0,{"$f":"0.01*0.3*Y59","v":0},null,{"$f":"IF(ISERROR(L59/OFFSET(L$227,$V59,)),0,L59/OFFSET(L$227,$V59,))","v":1},1,null,null,null,{"$f":"AD59*W59*OFFSET(Calculator!O$227,$V59,AE59)","v":0},{"$f":"IF($E59<>\"\",IF(SUMIF($AC$304:$AC$306,$E59,$AG$304:$AG$306)=1,W59,0),0)","v":0},{"$f":"IF($E59<>\"\",IF(SUMIF($AC$304:$AC$306,$E59,$AG$304:$AG$306)=2,W59,0),0)","v":0},{"$f":"IF($E59<>\"\",IF(SUMIF($AC$304:$AC$306,$E59,AG$304:AG$306)=3,W59*OFFSET(Calculator!M$227,V59,0),0),0)","v":0},{"$f":"IF(E59=E$248,W59,IF(E59=E$249,W59*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Potassium sulphate",null,null,0,null,{"$f":"OFFSET(H$227,$V61,)","v":0},{"$f":"OFFSET(K$227,$V61,)","v":0},{"$f":"OFFSET(L$227,$V61,)","v":0.5},{"$f":"OFFSET(N$227,$V61,)","v":0.45},null,{"$f":"IF(AD61>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},18,{"$f":"H61","v":0},0,{"$f":"X61*W61","v":0},null,0,{"$f":"0.01*0.3*Y61","v":0},null,{"$f":"IF(ISERROR(L61/OFFSET(L$227,$V61,)),0,L61/OFFSET(L$227,$V61,))","v":1},1,null,null,null,{"$f":"AD61*W61*OFFSET(Calculator!O$227,$V61,AE61)","v":0},{"$f":"IF($E61<>\"\",IF(SUMIF($AC$304:$AC$306,$E61,$AG$304:$AG$306)=1,W61,0),0)","v":0},{"$f":"IF($E61<>\"\",IF(SUMIF($AC$304:$AC$306,$E61,$AG$304:$AG$306)=2,W61,0),0)","v":0},{"$f":"IF($E61<>\"\",IF(SUMIF($AC$304:$AC$306,$E61,AG$304:AG$306)=3,W61*OFFSET(Calculator!M$227,V61,0),0),0)","v":0},{"$f":"IF(E61=E$248,W61,IF(E61=E$249,W61*(0.25/0.73),0))","v":0}]
[{"$nulls":9},"%N","% P2O5","%  K2O","% SO3","Abated Yes/No?",{"$nulls":12},"N2O emitted","Leached (as N2O)",null,null,"fertiliser tech","%AN","%TSP","%MOP"]
[{"$nulls":4},"NPK (or PK) Mix 1",null,null,0,null,{"$f":"OFFSET(H$227,$V63,)","v":0.15},{"$f":"OFFSET(K$227,$V63,)","v":0.15},{"$f":"OFFSET(L$227,$V63,)","v":0.15},{"$f":"OFFSET(N$227,$V63,)","v":0},"No",{"$f":"IF(SUM(AF63:AH63)>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},9,{"$f":"H63","v":0},{"$f":"J63","v":0.15},{"$f":"X63*W63","v":0},null,{"$f":"0.01*Y63","v":0},{"$f":"0.01*0.3*Y63","v":0},null,{"$f":"IF(ISERROR(J63/OFFSET(H$227,$V63,)),0,J63/OFFSET(H$227,$V63,))","v":1},{"$f":"SUMIF(V$243:V$244,N63,W$243:W$244)","v":1},{"$f":"(J63/OFFSET(H$227,$V$28,))","v":0.44117647058823523},{"$f":"(K63/OFFSET(K$227,$V$57,))","v":0.3125},{"$f":"(L63/OFFSET(L$227,$V$59,))","v":0.25},{"$f":"W63*(AF63*OFFSET(Calculator!O$227,$V$28,AE63)+AG63*OFFSET(Calculator!O$227,$V$57,AE63)+AH63*OFFSET(Calculator!O$227,$V$59,AE63))","v":0},{"$f":"IF($E63<>\"\",IF(SUMIF($AC$304:$AC$306,$E63,$AG$304:$AG$306)=1,W63,0),0)","v":0},{"$f":"IF($E63<>\"\",IF(SUMIF($AC$304:$AC$306,$E63,$AG$304:$AG$306)=2,W63,0),0)","v":0},{"$f":"IF($E63<>\"\",IF(SUMIF($AC$304:$AC$306,$E63,AG$304:AG$306)=3,W63*OFFSET(Calculator!M$227,V63,0),0),0)","v":0},{"$f":"IF(E63=E$248,W63,IF(E63=E$249,W63*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"NPK (or PK) Mix 2",null,null,0,null,{"$f":"OFFSET(H$227,$V65,)","v":0.15},{"$f":"OFFSET(K$227,$V65,)","v":0.15},{"$f":"OFFSET(L$227,$V65,)","v":0.15},{"$f":"OFFSET(N$227,$V65,)","v":0},"No",{"$f":"IF(SUM(AF65:AH65)>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},9,{"$f":"H65","v":0},{"$f":"J65","v":0.15},{"$f":"X65*W65","v":0},null,{"$f":"0.01*Y65","v":0},{"$f":"0.01*0.3*Y65","v":0},null,{"$f":"IF(ISERROR(J65/OFFSET(H$227,$V65,)),0,J65/OFFSET(H$227,$V65,))","v":1},{"$f":"SUMIF(V$243:V$244,N65,W$243:W$244)","v":1},{"$f":"(J65/OFFSET(H$227,$V$28,))","v":0.44117647058823523},{"$f":"(K65/OFFSET(K$227,$V$57,))","v":0.3125},{"$f":"(L65/OFFSET(L$227,$V$59,))","v":0.25},{"$f":"W65*(AF65*OFFSET(Calculator!O$227,$V$28,AE65)+AG65*OFFSET(Calculator!O$227,$V$57,AE65)+AH65*OFFSET(Calculator!O$227,$V$59,AE65))","v":0},{"$f":"IF($E65<>\"\",IF(SUMIF($AC$304:$AC$306,$E65,$AG$304:$AG$306)=1,W65,0),0)","v":0},{"$f":"IF($E65<>\"\",IF(SUMIF($AC$304:$AC$306,$E65,$AG$304:$AG$306)=2,W65,0),0)","v":0},{"$f":"IF($E65<>\"\",IF(SUMIF($AC$304:$AC$306,$E65,AG$304:AG$306)=3,W65*OFFSET(Calculator!M$227,V65,0),0),0)","v":0},{"$f":"IF(E65=E$248,W65,IF(E65=E$249,W65*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"NPK (or PK) Mix 3",null,null,0,null,{"$f":"OFFSET(H$227,$V67,)","v":0.15},{"$f":"OFFSET(K$227,$V67,)","v":0.15},{"$f":"OFFSET(L$227,$V67,)","v":0.15},{"$f":"OFFSET(N$227,$V67,)","v":0},"No",{"$f":"IF(SUM(AF67:AH67)>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},9,{"$f":"H67","v":0},{"$f":"J67","v":0.15},{"$f":"X67*W67","v":0},null,{"$f":"0.01*Y67","v":0},{"$f":"0.01*0.3*Y67","v":0},null,{"$f":"IF(ISERROR(J67/OFFSET(H$227,$V67,)),0,J67/OFFSET(H$227,$V67,))","v":1},{"$f":"SUMIF(V$243:V$244,N67,W$243:W$244)","v":1},{"$f":"(J67/OFFSET(H$227,$V$28,))","v":0.44117647058823523},{"$f":"(K67/OFFSET(K$227,$V$57,))","v":0.3125},{"$f":"(L67/OFFSET(L$227,$V$59,))","v":0.25},{"$f":"W67*(AF67*OFFSET(Calculator!O$227,$V$28,AE67)+AG67*OFFSET(Calculator!O$227,$V$57,AE67)+AH67*OFFSET(Calculator!O$227,$V$59,AE67))","v":0},{"$f":"IF($E67<>\"\",IF(SUMIF($AC$304:$AC$306,$E67,$AG$304:$AG$306)=1,W67,0),0)","v":0},{"$f":"IF($E67<>\"\",IF(SUMIF($AC$304:$AC$306,$E67,$AG$304:$AG$306)=2,W67,0),0)","v":0},{"$f":"IF($E67<>\"\",IF(SUMIF($AC$304:$AC$306,$E67,AG$304:AG$306)=3,W67*OFFSET(Calculator!M$227,V67,0),0),0)","v":0},{"$f":"IF(E67=E$248,W67,IF(E67=E$249,W67*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"NPK (or PK) Mix 4",null,null,0,null,{"$f":"OFFSET(H$227,$V69,)","v":0.15},{"$f":"OFFSET(K$227,$V69,)","v":0.15},{"$f":"OFFSET(L$227,$V69,)","v":0.15},{"$f":"OFFSET(N$227,$V69,)","v":0},"No",{"$f":"IF(SUM(AF69:AH69)>1.05,\"Please check analysis - nutrient levels are implausibly high\",\"\")","v":""},{"$nulls":6},9,{"$f":"H69","v":0},{"$f":"J69","v":0.15},{"$f":"X69*W69","v":0},null,{"$f":"0.01*Y69","v":0},{"$f":"0.01*0.3*Y69","v":0},null,{"$f":"IF(ISERROR(J69/OFFSET(H$227,$V69,)),0,J69/OFFSET(H$227,$V69,))","v":1},{"$f":"SUMIF(V$243:V$244,N69,W$243:W$244)","v":1},{"$f":"(J69/OFFSET(H$227,$V$28,))","v":0.44117647058823523},{"$f":"(K69/OFFSET(K$227,$V$57,))","v":0.3125},{"$f":"(L69/OFFSET(L$227,$V$59,))","v":0.25},{"$f":"W69*(AF69*OFFSET(Calculator!O$227,$V$28,AE69)+AG69*OFFSET(Calculator!O$227,$V$57,AE69)+AH69*OFFSET(Calculator!O$227,$V$59,AE69))","v":0},{"$f":"IF($E69<>\"\",IF(SUMIF($AC$304:$AC$306,$E69,$AG$304:$AG$306)=1,W69,0),0)","v":0},{"$f":"IF($E69<>\"\",IF(SUMIF($AC$304:$AC$306,$E69,$AG$304:$AG$306)=2,W69,0),0)","v":0},{"$f":"IF($E69<>\"\",IF(SUMIF($AC$304:$AC$306,$E69,AG$304:AG$306)=3,W69*OFFSET(Calculator!M$227,V69,0),0),0)","v":0},{"$f":"IF(E69=E$248,W69,IF(E69=E$249,W69*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Lime",null,null,0,{"$nulls":13},12,{"$f":"H71","v":0},0,0,null,{"$f":"0.01*Y71","v":0},0,null,1,1,null,null,null,{"$f":"AD71*W71*OFFSET(Calculator!O$227,$V71,AE71)","v":0},{"$f":"IF($E71<>\"\",IF(SUMIF($AC$304:$AC$306,$E71,$AG$304:$AG$306)=1,W71,0),0)","v":0},{"$f":"IF($E71<>\"\",IF(SUMIF($AC$304:$AC$306,$E71,$AG$304:$AG$306)=2,W71,0),0)","v":0},{"$f":"IF($E71<>\"\",IF(SUMIF($AC$304:$AC$306,$E71,AG$304:AG$306)=3,W71*OFFSET(Calculator!M$227,V71,0),0),0)","v":0},{"$f":"IF(E71=E$248,W71,IF(E71=E$249,W71*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Limestone",null,null,0,{"$nulls":13},13,{"$f":"H73","v":0},0,0,null,{"$f":"0.01*Y73","v":0},0,null,1,1,null,null,null,{"$f":"AD73*W73*OFFSET(Calculator!O$227,$V73,AE73)","v":0},{"$f":"IF($E73<>\"\",IF(SUMIF($AC$304:$AC$306,$E73,$AG$304:$AG$306)=1,W73,0),0)","v":0},{"$f":"IF($E73<>\"\",IF(SUMIF($AC$304:$AC$306,$E73,$AG$304:$AG$306)=2,W73,0),0)","v":0},{"$f":"W73","v":0},{"$f":"IF(E73=E$248,W73,IF(E73=E$249,W73*(0.25/0.73),0))","v":0}]
[]
[]
[{"$nulls":8},"Percentage of this crop to which this is applied","% N (readily available)","%P2O5","%K2O",{"$nulls":12},"This is RAN for organic fertilisers"]
[{"$nulls":4},{"$f":"E250","v":"Compost "},null,null,0,100,{"$f":"OFFSET(O$227,$V77,)","v":2.0000000000000001E-4},{"$f":"OFFSET(K$227,$V77,)","v":3.0000000000000001E-3},{"$f":"OFFSET(L$227,$V77,)","v":5.4999999999999997E-3},{"$nulls":9},23,{"$f":"H77*I77/100*1000","v":0},{"$f":"IF(E77<>\"\",OFFSET(Calculator!O$227,V77,0),0)","v":2.0000000000000001E-4},{"$f":"X77*W77","v":0},null,{"$f":"0.01*Y77","v":0},{"$f":"0.01*0.3*Y77","v":0},null,{"$f":"IF(ISERROR(J77/OFFSET(H$227,$V77,)),0,J77/OFFSET(H$227,$V77,))","v":2.6666666666666668E-2},1,null,null,null,{"$f":"W77*OFFSET(Calculator!O$227,$V77,AE77)","v":0},{"$f":"W77","v":0},{"$f":"IF($E77<>\"\",IF(SUMIF($AC$304:$AC$306,$E77,$AG$304:$AG$306)=2,W77,0),0)","v":0},{"$f":"IF($E77<>\"\",IF(SUMIF($AC$304:$AC$306,$E77,AG$304:AG$306)=3,W77*OFFSET(Calculator!M$227,V77,0),0),0)","v":0},{"$f":"IF(E77=E$248,W77,IF(E77=E$249,W77*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Cattle farmyard manure",null,null,0,100,{"$f":"OFFSET(O$227,$V79,)","v":1.1999999999999999E-3},{"$f":"OFFSET(K$227,$V79,)","v":3.2000000000000002E-3},{"$f":"OFFSET(L$227,$V79,)","v":8.0000000000000002E-3},{"$nulls":9},26,{"$f":"H79*I79/100*1000","v":0},{"$f":"IF(E79<>\"\",OFFSET(Calculator!O$227,V79,0),0)","v":1.1999999999999999E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W79*OFFSET(Calculator!O$227,$V79,AE79)","v":0},0,{"$f":"W79","v":0},{"$f":"IF($E79<>\"\",IF(SUMIF($AC$304:$AC$306,$E79,AG$304:AG$306)=3,W79*OFFSET(Calculator!M$227,V79,0),0),0)","v":0},{"$f":"IF(E79=E$248,W79,IF(E79=E$249,W79*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Pig farmyard manure",null,null,0,100,{"$f":"OFFSET(O$227,$V81,)","v":1.8E-3},{"$f":"OFFSET(K$227,$V81,)","v":6.0000000000000001E-3},{"$f":"OFFSET(L$227,$V81,)","v":8.0000000000000002E-3},{"$nulls":9},27,0,{"$f":"IF(E81<>\"\",OFFSET(Calculator!O$227,V81,0),0)","v":1.8E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W81*OFFSET(Calculator!O$227,$V81,AE81)","v":0},0,0,{"$f":"IF($E81<>\"\",IF(SUMIF($AC$304:$AC$306,$E81,AG$304:AG$306)=3,W81*OFFSET(Calculator!M$227,V81,0),0),0)","v":0},{"$f":"IF(E81=E$248,W81,IF(E81=E$249,W81*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Sheep farmyard manure",null,null,0,100,{"$f":"OFFSET(O$227,$V83,)","v":1.4E-3},{"$f":"OFFSET(K$227,$V83,)","v":3.2000000000000002E-3},{"$f":"OFFSET(L$227,$V83,)","v":8.0000000000000002E-3},{"$nulls":9},28,0,{"$f":"IF(E83<>\"\",OFFSET(Calculator!O$227,V83,0),0)","v":1.4E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W83*OFFSET(Calculator!O$227,$V83,AE83)","v":0},0,0,{"$f":"IF($E83<>\"\",IF(SUMIF($AC$304:$AC$306,$E83,AG$304:AG$306)=3,W83*OFFSET(Calculator!M$227,V83,0),0),0)","v":0},{"$f":"IF(E83=E$248,W83,IF(E83=E$249,W83*(0.25/0.73),0))","v":0}]
[]
[null,"Composts and manures",null,null,"Horse farmyard manure",null,null,0,100,{"$f":"OFFSET(O$227,$V85,)","v":1.6000000000000001E-3},{"$f":"OFFSET(K$227,$V85,)","v":5.0000000000000001E-3},{"$f":"OFFSET(L$227,$V85,)","v":6.0000000000000001E-3},{"$nulls":9},29,0,{"$f":"IF(E85<>\"\",OFFSET(Calculator!O$227,V85,0),0)","v":1.6000000000000001E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W85*OFFSET(Calculator!O$227,$V85,AE85)","v":0},0,0,{"$f":"IF($E85<>\"\",IF(SUMIF($AC$304:$AC$306,$E85,AG$304:AG$306)=3,W85*OFFSET(Calculator!M$227,V85,0),0),0)","v":0},{"$f":"IF(E85=E$248,W85,IF(E85=E$249,W85*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Poultry layer manure",null,null,0,100,{"$f":"OFFSET(O$227,$V87,)","v":9.4999999999999998E-3},{"$f":"OFFSET(K$227,$V87,)","v":1.4E-2},{"$f":"OFFSET(L$227,$V87,)","v":9.4999999999999998E-3},{"$nulls":9},30,0,{"$f":"IF(E87<>\"\",OFFSET(Calculator!O$227,V87,0),0)","v":9.4999999999999998E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W87*OFFSET(Calculator!O$227,$V87,AE87)","v":0},0,0,{"$f":"IF($E87<>\"\",IF(SUMIF($AC$304:$AC$306,$E87,AG$304:AG$306)=3,W87*OFFSET(Calculator!M$227,V87,0),0),0)","v":0},{"$f":"IF(E87=E$248,W87,IF(E87=E$249,W87*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Broiler/Turkey litter",null,null,0,100,{"$f":"OFFSET(O$227,$V89,)","v":1.0500000000000001E-2},{"$f":"OFFSET(K$227,$V89,)","v":2.5000000000000001E-2},{"$f":"OFFSET(L$227,$V89,)","v":1.7999999999999999E-2},{"$nulls":9},31,0,{"$f":"IF(E89<>\"\",OFFSET(Calculator!O$227,V89,0),0)","v":1.0500000000000001E-2},0,null,0,0,null,1,1,null,null,null,{"$f":"W89*OFFSET(Calculator!O$227,$V89,AE89)","v":0},0,0,{"$f":"IF($E89<>\"\",IF(SUMIF($AC$304:$AC$306,$E89,AG$304:AG$306)=3,W89*OFFSET(Calculator!M$227,V89,0),0),0)","v":0},{"$f":"IF(E89=E$248,W89,IF(E89=E$249,W89*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Cattle slurry",null,null,0,100,{"$f":"OFFSET(O$227,$V91,)","v":1.1999999999999999E-3},{"$f":"OFFSET(K$227,$V91,)","v":1.1999999999999999E-3},{"$f":"OFFSET(L$227,$V91,)","v":3.2000000000000002E-3},{"$nulls":9},32,0,{"$f":"IF(E91<>\"\",OFFSET(Calculator!O$227,V91,0),0)","v":1.1999999999999999E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W91*OFFSET(Calculator!O$227,$V91,AE91)","v":0},0,0,{"$f":"IF($E91<>\"\",IF(SUMIF($AC$304:$AC$306,$E91,AG$304:AG$306)=3,W91*OFFSET(Calculator!M$227,V91,0),0),0)","v":0},{"$f":"IF(E91=E$248,W91,IF(E91=E$249,W91*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Pig slurry",null,null,0,100,{"$f":"OFFSET(O$227,$V93,)","v":2.5000000000000001E-3},{"$f":"OFFSET(K$227,$V93,)","v":1.8E-3},{"$f":"OFFSET(L$227,$V93,)","v":2.3999999999999998E-3},{"$nulls":9},33,0,{"$f":"IF(E93<>\"\",OFFSET(Calculator!O$227,V93,0),0)","v":2.5000000000000001E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W93*OFFSET(Calculator!O$227,$V93,AE93)","v":0},0,0,{"$f":"IF($E93<>\"\",IF(SUMIF($AC$304:$AC$306,$E93,AG$304:AG$306)=3,W93*OFFSET(Calculator!M$227,V93,0),0),0)","v":0},{"$f":"IF(E93=E$248,W93,IF(E93=E$249,W93*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Separated Pig slurry - liquid part",null,null,0,100,{"$f":"OFFSET(O$227,$V95,)","v":2.2000000000000001E-3},{"$f":"OFFSET(K$227,$V95,)","v":1.6000000000000001E-3},{"$f":"OFFSET(L$227,$V95,)","v":2.3999999999999998E-3},{"$nulls":9},34,0,{"$f":"IF(E95<>\"\",OFFSET(Calculator!O$227,V95,0),0)","v":2.2000000000000001E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W95*OFFSET(Calculator!O$227,$V95,AE95)","v":0},0,0,{"$f":"IF($E95<>\"\",IF(SUMIF($AC$304:$AC$306,$E95,AG$304:AG$306)=3,W95*OFFSET(Calculator!M$227,V95,0),0),0)","v":0},{"$f":"IF(E95=E$248,W95,IF(E95=E$249,W95*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},"Separated Pig slurry - solid part",null,null,0,100,{"$f":"OFFSET(O$227,$V97,)","v":1.2999999999999999E-3},{"$f":"OFFSET(K$227,$V97,)","v":4.5999999999999999E-3},{"$f":"OFFSET(L$227,$V97,)","v":2.2000000000000001E-3},{"$nulls":9},35,0,{"$f":"IF(E97<>\"\",OFFSET(Calculator!O$227,V97,0),0)","v":1.2999999999999999E-3},0,null,0,0,null,1,1,null,null,null,{"$f":"W97*OFFSET(Calculator!O$227,$V97,AE97)","v":0},0,0,{"$f":"IF($E97<>\"\",IF(SUMIF($AC$304:$AC$306,$E97,AG$304:AG$306)=3,W97*OFFSET(Calculator!M$227,V97,0),0),0)","v":0},{"$f":"IF(E97=E$248,W97,IF(E97=E$249,W97*(0.25/0.73),0))","v":0}]
[{"$nulls":29},1,1,null,null,null,{"$f":"W98*OFFSET(Calculator!O$227,$V98,AE98)","v":0},0,0]
[null,"Biosolids",null,null,{"$f":"E264","v":"Digested liquid"},null,null,0,100,{"$f":"OFFSET(O$227,$V99,)","v":8.0000000000000004E-4},{"$f":"OFFSET(K$227,$V99,)","v":3.0000000000000001E-3},{"$f":"OFFSET(L$227,$V99,)","v":1E-3},{"$nulls":9},37,0,{"$f":"IF(E99<>\"\",OFFSET(Calculator!O$227,V99,0),0)","v":8.0000000000000004E-4},{"$f":"X99*W99","v":0},null,0,{"$f":"0.01*0.3*Y99","v":0},null,1,1,null,null,null,{"$f":"W99*OFFSET(Calculator!O$227,$V99,AE99)","v":0},0,0,{"$f":"IF($E99<>\"\",IF(SUMIF($AC$304:$AC$306,$E99,AG$304:AG$306)=3,W99*OFFSET(Calculator!M$227,V99,0),0),0)","v":0},{"$f":"IF(E99=E$248,W99,IF(E99=E$249,W99*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},{"$f":"E265","v":"Digested cake"},null,null,0,100,{"$f":"OFFSET(O$227,$V101,)","v":1.6000000000000001E-3},{"$f":"OFFSET(K$227,$V101,)","v":1.8E-3},{"$f":"OFFSET(L$227,$V101,)","v":5.9999999999999995E-4},{"$nulls":9},38,0,{"$f":"IF(E101<>\"\",OFFSET(Calculator!O$227,V101,0),0)","v":1.6000000000000001E-3},{"$f":"X101*W101","v":0},null,0,{"$f":"0.01*0.3*Y101","v":0},null,1,1,null,null,null,{"$f":"W101*OFFSET(Calculator!O$227,$V101,AE101)","v":0},0,0,{"$f":"IF($E101<>\"\",IF(SUMIF($AC$304:$AC$306,$E101,AG$304:AG$306)=3,W101*OFFSET(Calculator!M$227,V101,0),0),0)","v":0},{"$f":"IF(E101=E$248,W101,IF(E101=E$249,W101*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},{"$f":"E266","v":"Thermally dried"},null,null,0,100,{"$f":"OFFSET(O$227,$V103,)","v":2E-3},{"$f":"OFFSET(K$227,$V103,)","v":7.0000000000000007E-2},{"$f":"OFFSET(L$227,$V103,)","v":2E-3},{"$nulls":9},39,0,{"$f":"IF(E103<>\"\",OFFSET(Calculator!O$227,V103,0),0)","v":2E-3},{"$f":"X103*W103","v":0},null,0,{"$f":"0.01*0.3*Y103","v":0},null,1,1,null,null,null,{"$f":"W103*OFFSET(Calculator!O$227,$V103,AE103)","v":0},0,0,{"$f":"IF($E103<>\"\",IF(SUMIF($AC$304:$AC$306,$E103,AG$304:AG$306)=3,W103*OFFSET(Calculator!M$227,V103,0),0),0)","v":0},{"$f":"IF(E103=E$248,W103,IF(E103=E$249,W103*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},{"$f":"E267","v":"Lime stabilised"},null,null,0,100,{"$f":"OFFSET(O$227,$V105,)","v":8.9999999999999998E-4},{"$f":"OFFSET(K$227,$V105,)","v":2.5999999999999999E-2},{"$f":"OFFSET(L$227,$V105,)","v":8.0000000000000004E-4},{"$nulls":9},40,0,{"$f":"IF(E105<>\"\",OFFSET(Calculator!O$227,V105,0),0)","v":8.9999999999999998E-4},{"$f":"X105*W105","v":0},null,0,{"$f":"0.01*0.3*Y105","v":0},null,1,1,null,null,null,{"$f":"W105*OFFSET(Calculator!O$227,$V105,AE105)","v":0},0,0,{"$f":"IF($E105<>\"\",IF(SUMIF($AC$304:$AC$306,$E105,AG$304:AG$306)=3,W105*OFFSET(Calculator!M$227,V105,0),0),0)","v":0},{"$f":"IF(E105=E$248,W105,IF(E105=E$249,W105*(0.25/0.73),0))","v":0}]
[]
[{"$nulls":4},{"$f":"E268","v":"Composted"},null,null,0,100,{"$f":"OFFSET(O$227,$V107,)","v":5.9999999999999995E-4},{"$f":"OFFSET(K$227,$V107,)","v":6.0000000000000001E-3},{"$f":"OFFSET(L$227,$V107,)","v":3.0000000000000001E-3},{"$nulls":9},41,0,{"$f":"IF(E107<>\"\",OFFSET(Calculator!O$227,V107,0),0)","v":5.9999999999999995E-4},{"$f":"X107*W107","v":0},null,0,{"$f":"0.01*0.3*Y107","v":0},null,1,1,null,null,null,{"$f":"W107*OFFSET(Calculator!O$227,$V107,AE107)","v":0},0,0,{"$f":"IF($E107<>\"\",IF(SUMIF($AC$304:$AC$306,$E107,AG$304:AG$306)=3,W107*OFFSET(Calculator!M$227,V107,0),0),0)","v":0},{"$f":"IF(E107=E$248,W107,IF(E107=E$249,W107*(0.25/0.73),0))","v":0}]
[]
[]
[null,"N-fixing crops in previous year"]
[{"$nulls":5},"Type",null,"Percentage of crop preceded by this ",{"$nulls":13},42,null,null,{"$f":"SUMIF(E273:E281,F112,F273:F281)*H112/100","v":0},null,{"$f":"0.01*Y111","v":0},{"$f":"0.01*0.3*Y111","v":0},null,1,1,null,null,null,{"$f":"Y111*OFFSET(Calculator!O$227,$V111,AE111)","v":0},0,{"$f":"IF($E112<>\"\",IF(SUMIF($AC$304:$AC$306,$E112,$AG$304:$AG$306)=2,Y111,0),0)","v":0},{"$f":"IF($E112<>\"\",IF(SUMIF($AC$304:$AC$306,$E112,AG$304:AG$306)=3,Y111*OFFSET(Calculator!M$227,V111,0),0),0)","v":0},{"$f":"IF(E112=E$248,Y111,IF(E112=E$249,Y111*(0.25/0.73),0))","v":0}]
[{"$nulls":4},"Crop type","None",null,100,{"$nulls":15},"Total N",{"$f":"SUM(Y28:Y111)","v":0},null,{"$f":"SUM(AA28:AA111)","v":0},{"$f":"SUM(AB28:AB111)","v":0},{"$nulls":6},{"$f":"SUM(AI28:AI111)","v":0},{"$f":"SUM(AJ77:AJ97,AJ28:AJ61)","v":0},{"$f":"SUM(AK77:AK97,AK28:AK61)","v":0},{"$f":"SUM(AL28:AL107)","v":0},{"$f":"SUM(AM28:AM107)","v":0}]
[{"$nulls":23},"For status bar",{"$f":"ROUND(Y112,1)","v":0},null,null,{"$f":"SUM(AA112:AB112)*Calculator!F367","v":0},{"$nulls":9},{"$f":"44/12*Calculator!$W$252*Calculator!AL112","v":0},{"$f":"44/12*Calculator!$W$253*Calculator!AM112","v":0},{"$nulls":57},{"$f":"E108","v":0}]
[{"$nulls":96},{"$f":"E109","v":0}]
[{"$nulls":4},{"$f":"IF(BP204>0,\"If you use compost or manure as fertiliser, and this practice started less than 20 years ago, be sure to add this in the sequestration tab.\",\"\")","v":""},{"$nulls":103},{"$f":"E110","v":0}]
[null,"Crop protection",{"$nulls":106},{"$f":"E111","v":0}]
[{"$nulls":4},"Crop protection applications",null,{"$f":"AB117","v":"None: Approximately 0 kg active ingredient used"},{"$nulls":14},"kgCO2e pesticides",{"$f":"20.5*2*Z117","v":0},null,0,{"$f":"Y117","v":0},{"$f":"ROUND(Z117,0)","v":0},{"$f":"OFFSET(F349,AA117,) & \": Approximately \" & Z117 & \" kg active ingredient used\"","v":"None: Approximately 0 kg active ingredient used"}]
[]
[{"$nulls":7},{"$f":"\"Baled and sold off farm: \" &(100-AB121) & \"%\"","v":"Baled and sold off farm: 100%"}]
[null,"Crop residue management",null,null,"Thin, medium, or thick crop","Medium",null,null,null,{"$f":"(100-AB121)/100*AA121","v":3.6100000000000003},"tonnes sold off farm per ha",{"$nulls":10},"index","dry matter ratio","intercept","slope for yield","N ratio","estimated total","% Incorporated into soil (including after mulching)","Tonnes of residue (user override allowed)","N in above ground residue (tonnes)","N2O(kg)"]
[{"$nulls":7},{"$f":"\"Incorporated into soil (including after mulching): \" & AB121 & \"%\"","v":"Incorporated into soil (including after mulching): 0%"},null,{"$f":"AB121/100*AA121","v":0},"tonnes incorporated per ha",{"$nulls":10},{"$f":"SUMIF(F288:F301,F5,E288:E301)","v":1},{"$f":"OFFSET(K288,$V121,)","v":0.89},{"$f":"OFFSET(L288,$V121,)","v":1.61},{"$f":"OFFSET(M288,$V121,)","v":0.4},{"$f":"OFFSET(N288,$V121,)","v":6.0000000000000001E-3},{"$f":"SUMIF(S296:S299,F120,T296:T299)*(X121+Y121*W11)","v":3.6100000000000003},0,{"$f":"J121","v":0},{"$f":"AC121*Z$121","v":0},{"$f":"$AD121*0.01*1000","v":0}]
[{"$nulls":27},"totals"]
[]
[]
[null,"Field operations",null,null,null,"Number of passes \n(enter fractions if only part of area treated)",null,"Your actual fuel use if known (litres/ha) ","Default estimate (litres/ha)",{"$nulls":12},"modelled (default emissions) per operation","fuel use in litres"]
[{"$nulls":5},{"$f":"E310","v":"Mouldboard plough"},null,null,{"$f":"V126*G126","v":0},{"$nulls":12},{"$f":"(F310*F$18+H310*F$20+I310*F$22)/100","v":29.6},{"$f":"IF(H126<>\"\",H126,I126)","v":0}]
[]
[{"$nulls":5},{"$f":"E311","v":"add furrow press for plough"},null,null,{"$f":"V128*G128","v":0},{"$nulls":12},{"$f":"(F311*F$18+H311*F$20+I311*F$22)/100","v":4.3},0]
[]
[{"$nulls":5},{"$f":"E312","v":"Sub-soiling"},null,null,{"$f":"V130*G130","v":0},{"$nulls":12},{"$f":"(F312*F$18+H312*F$20+I312*F$22)/100","v":32.743362831858406},0]
[]
[{"$nulls":5},{"$f":"E313","v":"Mole ploughing"},null,null,{"$f":"V132*G132","v":0},{"$nulls":12},{"$f":"(F313*F$18+H313*F$20+I313*F$22)/100","v":46.207433628318583},0]
[]
[{"$nulls":5},{"$f":"E314","v":"Flat lifting"},null,null,{"$f":"V134*G134","v":0},{"$nulls":12},{"$f":"(F314*F$18+H314*F$20+I314*F$22)/100","v":32.743362831858406},0]
[]
[{"$nulls":5},{"$f":"E315","v":"Stubble cultivation (light)"},null,null,{"$f":"V136*G136","v":0},{"$nulls":12},{"$f":"(F315*F$18+H315*F$20+I315*F$22)/100","v":19.384070796460179},0]
[]
[{"$nulls":5},{"$f":"E316","v":"Discing shallow"},null,null,{"$f":"V138*G138","v":0},{"$nulls":12},{"$f":"(F316*F$18+H316*F$20+I316*F$22)/100","v":9.3333333333333321},0]
[]
[{"$nulls":5},{"$f":"E317","v":"Discing deep"},null,null,{"$f":"V140*G140","v":0},{"$nulls":12},{"$f":"(F317*F$18+H317*F$20+I317*F$22)/100","v":14},0]
[]
[{"$nulls":5},{"$f":"E318","v":"Power harrowing"},null,null,{"$f":"V142*G142","v":0},{"$nulls":12},{"$f":"(F318*F$18+H318*F$20+I318*F$22)/100","v":22.2},0]
[]
[{"$nulls":5},{"$f":"E319","v":"Spring tine"},null,null,{"$f":"V144*G144","v":0},{"$nulls":12},{"$f":"(F319*F$18+H319*F$20+I319*F$22)/100","v":14.87858407079646},0]
[]
[{"$nulls":5},{"$f":"E320","v":"Pressing"},null,null,{"$f":"V146*G146","v":0},{"$nulls":12},{"$f":"(F320*F$18+H320*F$20+I320*F$22)/100","v":16.81699115044248},0]
[]
[{"$nulls":5},{"$f":"E321","v":"Tillage train (eg Discorden type)"},null,null,{"$f":"V148*G148","v":0},{"$nulls":12},{"$f":"(F321*F$18+H321*F$20+I321*F$22)/100","v":29.783362831858412},0]
[]
[{"$nulls":5},{"$f":"E322","v":"Min till cultivator"},null,null,{"$f":"V150*G150","v":0},{"$nulls":12},{"$f":"(F322*F$18+H322*F$20+I322*F$22)/100","v":21.5},{"$f":"IF(H150<>\"\",H150,I150)","v":0}]
[]
[{"$nulls":5},{"$f":"E323","v":"Rolling"},null,null,{"$f":"V152*G152","v":0},{"$nulls":12},{"$f":"(F323*F$18+H323*F$20+I323*F$22)/100","v":5.55},0]
[]
[{"$nulls":5},{"$f":"E324","v":"Flat lift rape drilling"},null,null,{"$f":"V154*G154","v":0},{"$nulls":12},{"$f":"(F324*F$18+H324*F$20+I324*F$22)/100","v":36.700000000000003},0]
[]
[{"$nulls":5},{"$f":"E325","v":"Conventional drill"},null,null,{"$f":"V156*G156","v":0},{"$nulls":12},{"$f":"(F325*F$18+H325*F$20+I325*F$22)/100","v":4},0]
[]
[{"$nulls":5},{"$f":"E326","v":"Powerharrow drill"},null,null,{"$f":"V158*G158","v":0},{"$nulls":12},{"$f":"(F326*F$18+H326*F$20+I326*F$22)/100","v":26.2},0]
[]
[{"$nulls":5},{"$f":"E327","v":"Cultivator drills"},null,null,{"$f":"V160*G160","v":0},{"$nulls":12},{"$f":"(F327*F$18+H327*F$20+I327*F$22)/100","v":11},0]
[]
[{"$nulls":5},{"$f":"E328","v":"Direct drill"},null,null,{"$f":"V162*G162","v":0},{"$nulls":12},{"$f":"(F328*F$18+H328*F$20+I328*F$22)/100","v":20},0]
[]
[{"$nulls":5},"Number of times"]
[{"$nulls":5},{"$f":"E329","v":"Solid fertiliser distributing"},null,null,{"$f":"V165*G165","v":0},{"$nulls":12},{"$f":"(F329*F$18+H329*F$20+I329*F$22)/100","v":1.2},{"$f":"IF(H165<>\"\",H165,I165)","v":0}]
[]
[{"$nulls":5},{"$f":"E330","v":"Spraying"},null,null,{"$f":"V167*G167","v":0},{"$nulls":12},{"$f":"(F330*F$18+H330*F$20+I330*F$22)/100","v":0.8},{"$f":"IF(H167<>\"\",H167,I167)","v":0}]
[]
[{"$nulls":5},{"$f":"E331","v":"Liquid fertiliser application"},null,null,{"$f":"V169*G169","v":0},{"$nulls":12},{"$f":"(F331*F$18+H331*F$20+I331*F$22)/100","v":0.8},{"$f":"IF(H169<>\"\",H169,I169)","v":0}]
[]
[{"$nulls":5},{"$f":"E332","v":"ATV spreading"},null,null,{"$f":"V171*G171","v":0},{"$nulls":12},{"$f":"(F332*F$18+H332*F$20+I332*F$22)/100","v":2},{"$f":"IF(H171<>\"\",H171,I171)","v":0}]
[]
[{"$nulls":5},"Number of times"]
[{"$nulls":5},{"$f":"E334","v":"Combining "},null,null,{"$f":"V174*G174","v":0},{"$nulls":12},{"$f":"(F334*F$18+H334*F$20+I334*F$22)/100","v":15.4},{"$f":"IF(H174<>\"\",H174,I174)","v":0}]
[]
[{"$nulls":5},{"$f":"E335","v":"Add for straw chopping"},null,null,{"$f":"V176*G176","v":0},{"$nulls":12},{"$f":"(F335*F$18+H335*F$20+I335*F$22)/100","v":4},0]
[]
[{"$nulls":5},{"$f":"E336","v":"OSR swathing"},null,null,{"$f":"V178*G178","v":0},{"$nulls":12},{"$f":"(F336*F$18+H336*F$20+I336*F$22)/100","v":7.3612903225806461},0]
[]
[{"$nulls":5},{"$f":"E337","v":"Baling - Small rectangular"},null,null,{"$f":"V180*G180","v":0},{"$nulls":12},{"$f":"(F337*F$18+H337*F$20+I337*F$22)/100","v":4.7885572139303472},0]
[]
[{"$nulls":5},{"$f":"E338","v":"Baling - Round"},null,null,{"$f":"V182*G182","v":0},{"$nulls":12},{"$f":"(F338*F$18+H338*F$20+I338*F$22)/100","v":7.935323383084576},0]
[]
[{"$nulls":5},{"$f":"E339","v":"Baling - Heston type"},null,null,{"$f":"V184*G184","v":0},{"$nulls":12},{"$f":"(F339*F$18+H339*F$20+I339*F$22)/100","v":9.5},0]
[]
[{"$nulls":5},"Other diesel use e.g. carting",{"$nulls":16},{"$f":"H186","v":0},null,"for use in user bar"]
[{"$nulls":21},"litres",{"$f":"SUM(W126:W186)","v":0},null,{"$f":"W187","v":0}]
[{"$nulls":21},"kgCO2e",{"$f":"Y187*AB197","v":0}]
[]
[]
[null,"Grain drying",null,null,"Grain drying","No",null,null,{"$f":"\"Your estimated energy consumption for this drying phase is \" & ROUND(Z192,1) & \" KWh. If you know your energy use you may enter it here\"","v":"Your estimated energy consumption for this drying phase is 0 KWh. If you know your energy use you may enter it here"},null,null,{"$f":"Z192","v":0},"KWh (total)",{"$nulls":8},"energy source","Grid electicity",null,"water evaporated",{"$f":"IF(F191=\"Yes\",MAX(0,W13*1000),0)","v":0}]
[{"$nulls":4},"Moisture content after drying %",{"$f":"SUMIF(F$288:F$304,F$5,J$288:J$304)","v":14.5},{"$nulls":15},"dryer efficiency Kwh/kg",3.6,null,"estimated energy use",{"$f":"W192*Z191/W192","v":0},null,"emission per MJ","CO2 emissions"]
[{"$nulls":24},"user override if entered",{"$f":"IF(L191<>\"\",L191,Z192)","v":0},"*",0.124511777,{"$f":"IF(F191=\"Yes\",AB193*Z193*3.6,0)","v":0}]
[]
[null,"Transport to offsite drying facility",null,null,"Transport to third party"]
[{"$nulls":4},"Distance (miles)",null,null,null,{"$f":"\"Your estimated diesel use for transport is \" &ROUND(Z196,1)& \" litres. If you know your diesel use you can enter it here.\"","v":"Your estimated diesel use for transport is 0 litres. If you know your diesel use you can enter it here."},null,null,{"$f":"Z196","v":0},"litres",{"$nulls":9},"factor",null,"estimated diesel used",{"$f":"F196*W197*W11*W198*1.612","v":0},null,"kg CO2-eq/litre","CO2 emissions"]
[{"$nulls":21},"assume truck weight is 1/3 of laden weight and that it returns empty",{"$f":"5/3","v":1.6666666666666667},null,"user override if entered",{"$f":"IF(L196=\"\",Z196,L196)","v":0},"*",2.68,{"$f":"Z197*AB197","v":0}]
[{"$nulls":21},"litres/mile/tonne adapted from ***",{"$f":"0.12038/AB197","v":4.4917910447761195E-2}]
[]
[]
[{"$nulls":4},"Emissions",null,null,"kg CO2","kg N2O","kgCO2e per hectare",null,"kgCO2e per tonne"]
[{"$nulls":4},"Fertiliser production",null,null,{"$f":"AI112","v":0},null,{"$f":"H202+Calculator!F$366*I202","v":0},null,{"$f":"IF(W$11=0,0,J202/W$11)","v":0}]
[{"$nulls":4},"Fertiliser-induced field emissions",null,null,{"$f":"AL113+AM113","v":0},{"$f":"AB113","v":0},{"$f":"H203+Calculator!F$366*I203","v":0},null,{"$f":"IF(W$11=0,0,J203/W$11)","v":0}]
[{"$nulls":4},"Agrochemicals",null,null,{"$f":"W117","v":0},null,{"$f":"H204+Calculator!F$366*I204","v":0},null,0]
[{"$nulls":4},"Crop residue management",null,null,null,{"$f":"AE121","v":0},{"$f":"H205+Calculator!F$366*I205","v":0},null,0]
[{"$nulls":4},"Field energy use ",null,null,{"$f":"W188","v":0},null,{"$f":"H206+Calculator!F$366*I206","v":0},null,0]
[{"$nulls":4},"Grain drying",null,null,{"$f":"AC193","v":0},null,{"$f":"H207+Calculator!F$366*I207","v":0},null,0]
[{"$nulls":4},"Transport off site",null,null,{"$f":"AC197","v":0},null,{"$f":"H208+Calculator!F$366*I208","v":0},null,0]
[{"$nulls":4},"Totals ",null,null,{"$f":"SUM(H202:H205)","v":0},{"$f":"SUM(I202:I205)","v":0},{"$f":"SUM(J202:J208)","v":0},null,{"$f":"SUM(L202:L208)","v":0}]
{"$rows_empty":13}
[null,null,null,"Fertiliser analysis and production emissions"]
[]
[{"$nulls":4},"Database used for fertiliser production emissions",{"$nulls":10},"Kongshaug 1998 (Average Europe)","Kongshaug 1998 (Average Europe)","FLAG: synthetic/FYM/Compost/lime","Sources"]
[{"$nulls":5},"Index",null,"N","P","K","P2O5","K2O","CaCO3","SO3","Readily available N",1,2]
[]
[]
[{"$nulls":4},"Ammonium nitrate",2,null,0.34,{"$f":"0.436*K229","v":0},{"$f":"38/46*L229","v":0},0,0,0,0,{"$f":"H229","v":0.34},2.38,1.1299999999999999,0,"Kongshaug"]
[{"$nulls":4},"Ammonium sulphate",3,null,0.21,0,{"$f":"38/46*L230","v":0},0,0,0,0.6,0.21,0.34,0.34,0,"Kongshaug"]
[{"$nulls":4},"Ammonium sulphate nitrate",4,null,0.21,0,0,0,0,0,{"$f":"N230*(1-V230/100)","v":0.6},0.21,null,null,0,"Kongshaug"]
[{"$nulls":4},"Anhydrous ammonia",5,null,0.82,0,{"$f":"38/46*L232","v":0},0,0,0,0,0.82,1.91,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Calcium ammonium nitrate",6,null,0.27,0,0,0,0,0,0,0.27,1.81,0.79,0,"Kongshaug"]
[{"$nulls":4},"Calcium nitrate",7,null,0.15,0,0,0,0,0,0,0.15,1.69,0.61,0,"Kongshaug"]
[{"$nulls":4},"Compound NK",8,null,0.14000000000000001,0,0.3634782608695652,0,0.44,0,0,0.14000000000000001,1.97,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Compound NPK",9,null,0.15,{"$f":"0.436*K236","v":6.54E-2},0.12391304347826086,0.15,0.15,0,0,0.15,{"$f":"($U$190/100)*P229+($V$190/100)*P247+($W$190/100)*P243","v":0},{"$f":"($U$190/100)*Q229+($V$190/100)*Q247+($W$190/100)*Q243","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Diammonium phosphate",10,null,0.18,0.20056000000000002,0,0.46,0,0,0,0.18,0.46,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Kainit / Magnesium Sulphate",11,null,0,0,9.0869565217391299E-2,0,0.11,0,0.1,0,0,{"$f":"NA()","v":{"$error":"#N/A"}},0,"NA"]
[{"$nulls":4},"Lime",12,null,0,0,0,0,0,0,0,0,0,{"$f":"NA()","v":{"$error":"#N/A"}},3,"NA"]
[{"$nulls":4},"Limestone",13,null,0,0,0,0,0,0.55000000000000004,0,0,0,{"$f":"NA()","v":{"$error":"#N/A"}},3,"NA"]
[]
[{"$nulls":4},"Monoammonium phosphate",15,null,0.11,0.22672,0,0.52,0,0,0,0.11,0.31,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug",null,null,"Abated N drop-down"]
[{"$nulls":4},"Muriate of potash",16,null,0,0,0.49565217391304345,0,0.6,0,0,0,0.2,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug",null,null,"No",1]
[{"$nulls":4},"Phosphate/Rock Phosphate",17,null,0,0.109,0,0.25,0,0,0,0,{"$f":"2.8*K244*77.3/1000","v":5.4109999999999991E-2},{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug",null,null,"Yes",2]
[{"$nulls":4},"Potassium sulphate",18,null,0,0,0.41304347826086957,0,0.5,0,0.45,0,{"$f":"3*L245*77.3/1000","v":0.11594999999999998},{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Super phosphate",19,null,0,9.1560000000000002E-2,0,0.21,0,0,0,0,0.02,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Triple super phosphate",20,null,0,0.20927999999999999,0,0.48,0,0,0,0,0.17,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Urea",21,null,0.46399999999999997,0,0,0,0,0,0,0.46399999999999997,0.61,{"$f":"NA()","v":{"$error":"#N/A"}},0,"Kongshaug"]
[{"$nulls":4},"Urea ammonium nitrate solution",22,null,0.32,0,0,0,0,0,0,0.32,1.31,0.74,0,"Kongshaug"]
[{"$nulls":4},"Compost ",23,null,7.4999999999999997E-3,1.3079999999999999E-3,4.5434782608695648E-3,3.0000000000000001E-3,5.4999999999999997E-3,0,2.5999999999999999E-3,2.0000000000000001E-4,0,0,2,"Assumed",null,null,"Non-nitrogen soil emissions"]
[{"$nulls":21},"volatilisation",0.01]
[" ",{"$nulls":20},"Limestone",0.12]
[{"$nulls":4},"Cattle farmyard manure",26,null,6.0000000000000001E-3,1.3952000000000001E-3,6.6086956521739133E-3,3.2000000000000002E-3,8.0000000000000002E-3,0,2.3999999999999998E-3,1.1999999999999999E-3,0,0,1,"RB209",null,null,"Urea",0.2]
[{"$nulls":4},"Pig farmyard manure",27,null,7.0000000000000001E-3,2.6159999999999998E-3,6.6086956521739133E-3,6.0000000000000001E-3,8.0000000000000002E-3,0,3.3999999999999998E-3,1.8E-3,0,0,1,"RB209"]
[{"$nulls":4},"Sheep farmyard manure",28,null,7.0000000000000001E-3,1.3952000000000001E-3,6.6086956521739133E-3,3.2000000000000002E-3,8.0000000000000002E-3,0,3.0000000000000001E-3,1.4E-3,0,0,1,"RB209"]
[{"$nulls":4},"Horse farmyard manure",29,null,7.0000000000000001E-3,2.1800000000000001E-3,4.956521739130435E-3,5.0000000000000001E-3,6.0000000000000001E-3,0,0,1.6000000000000001E-3,0,0,1,"RB209"]
[{"$nulls":4},"Poultry layer manure",30,null,1.9E-2,6.1040000000000001E-3,7.8478260869565223E-3,1.4E-2,9.4999999999999998E-3,0,4.0000000000000001E-3,9.4999999999999998E-3,0,0,1,"RB209"]
[{"$nulls":4},"Broiler/Turkey litter",31,null,0.03,1.09E-2,1.4869565217391304E-2,2.5000000000000001E-2,1.7999999999999999E-2,0,8.0000000000000002E-3,1.0500000000000001E-2,0,0,1,"RB209",null,null,"densities for liquid fertilisers","kg","litres"]
[{"$nulls":4},"Cattle slurry",32,null,2.5999999999999999E-3,5.2319999999999992E-4,2.6434782608695654E-3,1.1999999999999999E-3,3.2000000000000002E-3,0,6.9999999999999999E-4,1.1999999999999999E-3,0,0,1,"RB209",null,null,null,1,1.32,null,"kgs/ha product",1]
[{"$nulls":4},"Pig slurry",33,null,3.5999999999999999E-3,7.8479999999999999E-4,1.9826086956521737E-3,1.8E-3,2.3999999999999998E-3,0,1E-3,2.5000000000000001E-3,0,0,1,"RB209",null,null,null,1,1.3,null,"litres/ha product",2]
[{"$nulls":4},"Separated Pig slurry - liquid part",34,null,3.5999999999999999E-3,6.9760000000000004E-4,1.9826086956521737E-3,1.6000000000000001E-3,2.3999999999999998E-3,0,0,2.2000000000000001E-3,0,0,1,"RB209"]
[{"$nulls":4},"Separated Pig slurry - solid part",35,null,5.0000000000000001E-3,2.0055999999999997E-3,1.8173913043478263E-3,4.5999999999999999E-3,2.2000000000000001E-3,0,0,1.2999999999999999E-3,0,0,1,"RB209"]
[]
[{"$nulls":4},"Digested liquid",37,null,2E-3,1.3079999999999999E-3,8.2608695652173917E-4,3.0000000000000001E-3,1E-3,null,null,8.0000000000000004E-4,0,0,1,"RB209"]
[{"$nulls":4},"Digested cake",38,null,1.0999999999999999E-2,7.8479999999999999E-4,4.9565217391304343E-4,1.8E-3,5.9999999999999995E-4,null,null,1.6000000000000001E-3,0,0,1,"RB209"]
[{"$nulls":4},"Thermally dried",39,null,0.04,3.0520000000000002E-2,1.6521739130434783E-3,7.0000000000000007E-2,2E-3,null,null,2E-3,0,0,1,"RB209"]
[{"$nulls":4},"Lime stabilised",40,null,8.5000000000000006E-3,1.1335999999999999E-2,6.6086956521739135E-4,2.5999999999999999E-2,8.0000000000000004E-4,null,null,8.9999999999999998E-4,0,0,1,"RB209"]
[{"$nulls":4},"Composted",41,null,1.0999999999999999E-2,2.6159999999999998E-3,2.4782608695652175E-3,6.0000000000000001E-3,3.0000000000000001E-3,null,null,5.9999999999999995E-4,0,0,1,"RB209"]
[]
[]
[]
[null,"Green manures",null,null,"Range of cover crops","RAN",null,"N"]
[{"$nulls":4},"None",{"$f":"H273/6","v":0},null,0]
[{"$nulls":4},"Forage peas",{"$f":"H274/6","v":13.333333333333334},null,80]
[{"$nulls":4},"Lucerne (silage)",16.666666666666668,null,100]
[{"$nulls":4},"Red clover (silage)",16.666666666666668,null,100]
[{"$nulls":4},"White clover/grass (silage)",16.666666666666668,null,100]
[{"$nulls":4},"Clover/grass (grazed)",20,null,120]
[{"$nulls":4},"Lupin",21.666666666666668,null,130]
[{"$nulls":4},"Field Bean",21.666666666666668,null,130]
[{"$nulls":4},"Vetch (cut and mulched)",25,null,150]
[]
[]
[]
[]
[null,"Crop classification",null,null,"Default residues from IPCC model"]
[]
[{"$nulls":4},"New index","[Select]",null,{"$f":"Calculator!T289","v":0},"Default moisture","Dried to","Dry matter fraction harvested","slope","intercept","N content - above ground"]
[{"$nulls":4},1,"nabim 1 - wheat for breadmaking",null,{"$f":"Calculator!T290","v":0},20,14.5,0.89,1.61,0.4,6.0000000000000001E-3]
[{"$nulls":4},2,"nabim 2 - wheat breadmaking and other",null,"Grain",20,14.5,0.89,1.61,0.4,6.0000000000000001E-3,{"$nulls":4},"Options for weight dropdown"]
[{"$nulls":4},3,"nabim 3 - wheat for biscuit, etc",null,"Grain",20,14.5,0.89,1.61,0.4,6.0000000000000001E-3,{"$nulls":4},"Fresh weight"]
[{"$nulls":4},4,"Group 4 - wheat for animal feed, biofuel, etc .",null,"Grain",20,14.5,0.89,1.61,0.4,6.0000000000000001E-3,{"$nulls":4},"Dried weight"]
[{"$nulls":4},5,"Malting barley",null,"Grain",20,14.5,0.89,0.98,0.59,7.0000000000000001E-3]
[{"$nulls":4},6,"Feed barley",null,{"$f":"Calculator!T295","v":0},20,14.5,0.89,0.98,0.59,7.0000000000000001E-3]
[{"$nulls":4},7,"OSR - food and fuel",null,"Oilseed",15,9,1,0,1.5,6.4999999999999997E-3,{"$nulls":4},"Options for residue defaults"]
[{"$nulls":4},8,"OSR - ind. and spec.",null,"Oilseed",15,9,1,0,1.5,6.4999999999999997E-3,{"$nulls":4},"[Select]","proportion of IPCC figure used"]
[{"$nulls":4},9,"Linseed",null,"Oilseed",15,9,1,0,1.5,6.4999999999999997E-3,{"$nulls":4},"Thin",0.5]
[{"$nulls":4},10,"Food oats",null,"Oats",20,14.5,0.89,0.91,0.89,7.0000000000000001E-3,{"$nulls":4},"Medium",1]
[{"$nulls":4},11,"Feed oats",null,"Oats",20,14.5,0.89,0.91,0.89,7.0000000000000001E-3,{"$nulls":4},"Thick",1.5]
[{"$nulls":4},12,"Rye",null,"Grain",20,14.5,{"$f":"K294","v":0.89},{"$f":"L294","v":0.98},{"$f":"M294","v":0.59},{"$f":"N294","v":7.0000000000000001E-3},"* as feed barley"]
[{"$nulls":4},13,"Triticale",null,"Grain",20,14.5,{"$f":"K294","v":0.89},{"$f":"L294","v":0.98},{"$f":"M294","v":0.59},{"$f":"N294","v":7.0000000000000001E-3},"* as feed barley"]
[{"$nulls":4},14,"Feed peas",null,"Legume",0,0,0.9,0.36,0.68,0.01,"* as dry beans in IPCC method"]
[{"$nulls":4},15,"Human consumption peas",null,"Legume",0,0,0.9,0.36,0.68,0.01,"* as dry beans in IPCC method"]
[{"$nulls":4},16,"Beans",null,"Legume",0,0,0.9,0.36,0.68,0.01,"* as dry beans in IPCC method"]
[]
[]
[]
[{"$nulls":4},"Soil modifier for tillage",1,null,1,{"$f":"I310/H310","v":1.3783783783783783}]
[{"$nulls":4},"Fuel use per ha","Light soil",null,"Medium soil","Heavy soil"]
[{"$nulls":4},"Mouldboard plough",29.6,null,29.6,40.799999999999997,null,"From KS, case studies or MC/CW pers comm."]
[{"$nulls":4},"add furrow press for plough",{"$f":"H311","v":4.3},null,4.3,{"$f":"I$310/H$310*H311","v":5.9270270270270267},null,"Derived from NAAC (sometimes using KS as a reference)"]
[{"$nulls":4},"Sub-soiling",{"$f":"H312","v":32.743362831858406},null,32.743362831858406,{"$f":"I$310/H$310*H312","v":45.132743362831853},null,"Assuming fuel use for light soils is as for medium"]
[{"$nulls":4},"Mole ploughing",46.20743362831859,null,46.20743362831859,{"$f":"I$310/H$310*H313","v":63.691327433628324},null,"Using mouldboard heavy/medium ratio as multiplier on medium figures"]
[{"$nulls":4},"Flat lifting",32.743362831858406,null,32.743362831858406,45.132743362831853,null,"Assumed based on other operations"]
[{"$nulls":4},"Stubble cultivation (light)",19.384070796460179,null,19.384070796460179,26.71858407079646]
[{"$nulls":4},"Discing shallow",9.3333333333333321,null,{"$f":"2/3*H317","v":9.3333333333333321},12.864864864864863]
[{"$nulls":4},"Discing deep",14,null,14,19.297297297297295]
[{"$nulls":4},"Power harrowing",22.2,null,22.2,30.599999999999998]
[{"$nulls":4},"Spring tine",14.87858407079646,null,14.87858407079646,20.508318584070796]
[{"$nulls":4},"Pressing",16.81699115044248,null,16.81699115044248,23.180176991150443]
[{"$nulls":4},"Tillage train (eg Discorden type)",29.783362831858412,null,29.783362831858412,41.052743362831862]
[{"$nulls":4},"Min till cultivator",{"$f":"H322","v":21.5},null,21.5,29.635135135135133]
[{"$nulls":4},"Rolling",5.55,null,5.55,7.6499999999999995]
[{"$nulls":4},"Flat lift rape drilling",{"$f":"H324","v":36.700000000000003},null,36.700000000000003,{"$f":"I$308*H324","v":50.586486486486486}]
[{"$nulls":4},"Conventional drill",4,null,4,{"$f":"I$308*H325","v":5.5135135135135132}]
[{"$nulls":4},"Powerharrow drill",26.2,null,{"$f":"H325+H318","v":26.2},{"$f":"I$308*H326","v":36.11351351351351}]
[{"$nulls":4},"Cultivator drills",11,null,11,{"$f":"I$308*H327","v":15.162162162162161}]
[{"$nulls":4},"Direct drill",20,null,20,{"$f":"I$308*H328","v":27.567567567567565}]
[{"$nulls":4},"Solid fertiliser distributing",1.2,null,1.2,{"$f":"H329","v":1.2}]
[{"$nulls":4},"Spraying",{"$f":"H330","v":0.8},null,0.8,{"$f":"H330","v":0.8}]
[{"$nulls":4},"Liquid fertiliser application",0.8,null,0.8,0.8]
[{"$nulls":4},"ATV spreading",2,null,2,2]
[{"$nulls":4},"Lime spreading",5,null,5,5]
[{"$nulls":4},"Combining ",15.4,null,15.4,15.4]
[{"$nulls":4},"Add for straw chopping",4,null,4,4]
[{"$nulls":4},"OSR swathing",7.3612903225806461,null,7.3612903225806461,7.3612903225806461]
[{"$nulls":4},"Baling - Small rectangular",4.7885572139303472,null,4.7885572139303472,4.7885572139303472]
[{"$nulls":4},"Baling - Round",7.935323383084576,null,7.935323383084576,7.935323383084576]
[{"$nulls":4},"Baling - Heston type",9.5,null,9.5,9.5]
[{"$nulls":4},"FYM spreading",5,null,5,5]
[{"$nulls":4},"Slurry spreading",5,null,5,5]
[{"$nulls":4},"Slurry injection",5,null,5,5]
[]
[]
[]
[]
[]
[null,null,"Pesticides - application regime descriptors"]
[{"$nulls":4},0,"None"]
[{"$nulls":4},1,"Very Low"]
[{"$nulls":4},2,"Very Low"]
[{"$nulls":4},3,"Low"]
[{"$nulls":4},4,"Low"]
[{"$nulls":4},5,"Standard"]
[{"$nulls":4},6,"Standard"]
[{"$nulls":4},7,"High"]
[{"$nulls":4},8,"Very high"]
[{"$nulls":4},9,"Very high"]
[]
[]
[]
[]
[]
[{"$nulls":4},"GWPs"]
[{"$nulls":4},"CH4",25]
[{"$nulls":4},"N2O",298]
[{"$nulls":4},"N to N2O conversion",{"$f":"44/28","v":1.5714285714285714}]

{"sheet":"Results","index":1,"n_rows":38,"n_cols":29,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,38,8],[19,2,23,8],[1,2,1,9],[4,2,4,8],[2,2,3,8],[34,2,36,8]]}
[]
[null,null,{"$f":" \"RESULTS: \" & Y4","v":"RESULTS: nabim 1 - wheat for breadmaking"}]
[null,null,"The table below shows your crops CO2 and N2O and reports them (in CO2e) per hectare and per tonne produced at final dried moisture content."]
[{"$nulls":24},{"$f":"C7","v":"nabim 1 - wheat for breadmaking"}]
[null,null,"Below the summary table, a graph of your emissions is provided, and a suggested mitigation option is given based on the largest source of emissions. Please note that this is only an estimate and a start point for mitigation, if you have not indeed already taken the steps indicated. Please refer to HGCA's guide 'Understanding carbon footprinting for cereals and oilseeds' for further ideas and discussion of options"]
[]
[null,null,{"$f":"Calculator!F5","v":"nabim 1 - wheat for breadmaking"},null,"kg CO2","kg N2O","kgCO2e per hectare","kgCO2e per tonne"]
[null,null,{"$f":"Calculator!E202","v":"Fertiliser production"},null,{"$f":"Calculator!H202","v":0},{"$f":"Calculator!I202","v":0},{"$f":"Calculator!J202","v":0},{"$f":"Calculator!L202","v":0},{"$nulls":14},1,{"$f":"H8","v":0},"fertiliser production",null,null,"Emissions from the production of fertiliser (particularly N fertiliser) can be substantial. Nitrate-based fertilisers using abatement technologies have significantly reduced production emissions"]
[null,null,{"$f":"Calculator!E203","v":"Fertiliser-induced field emissions"},null,{"$f":"Calculator!H203","v":0},{"$f":"Calculator!I203","v":0},{"$f":"Calculator!J203","v":0},{"$f":"Calculator!L203","v":0},{"$nulls":14},2,0,"fertiliser induced field emissions",null,null,"Soil N2O emissions from the use of N fertilisers and organic amendments can be quite substantial. There exist newer compounds (such as nitrification inhibitors) which can reduce field N2O emissions."]
[null,null,"Crop protection ",null,{"$f":"Calculator!H204","v":0},{"$f":"Calculator!I204","v":0},{"$f":"Calculator!J204","v":0},{"$f":"Calculator!L204","v":0},{"$nulls":14},3,0,"pesticides",null,null,"There is little data on the newer pesticides in common use. "]
[null,null,{"$f":"Calculator!E205","v":"Crop residue management"},null,{"$f":"Calculator!H205","v":0},{"$f":"Calculator!I205","v":0},{"$f":"Calculator!J205","v":0},{"$f":"Calculator!L205","v":0},{"$nulls":14},4,0,"crop residue management",null,null,"These can be large if left untreated in conditions (anaerobic) which favour methane emissions. If composting on farms emission may be mitigated by forced aeration composting."]
[null,null,{"$f":"Calculator!E206","v":"Field energy use "},null,{"$f":"Calculator!H206","v":0},{"$f":"Calculator!I206","v":0},{"$f":"Calculator!J206","v":0},{"$f":"Calculator!L206","v":0},{"$nulls":14},5,0,"field energy use",null,null,"It is worth keeping accurate records of fuel use in the field to mitigate this as far as possible."]
[null,null,{"$f":"Calculator!E207","v":"Grain drying"},null,{"$f":"Calculator!H207","v":0},{"$f":"Calculator!I207","v":0},{"$f":"Calculator!J207","v":0},{"$f":"Calculator!L207","v":0},{"$nulls":14},6,0,"grain drying",null,null,"It is reported that modern facilities have lower energy use requirements, although this must be balance against possibly increased travel costs."]
[null,null,{"$f":"Calculator!E208","v":"Transport off site"},null,{"$f":"Calculator!H208","v":0},{"$f":"Calculator!I208","v":0},{"$f":"Calculator!J208","v":0},{"$f":"Calculator!L208","v":0},{"$nulls":14},7,0,"transport off site",null,null,"Although not always an option for the farmer it is valubale to consider this in context of the farm gate emissions."]
[null,null,{"$f":"Calculator!E209","v":"Totals "},null,{"$f":"Calculator!H209","v":0},{"$f":"Calculator!I209","v":0},{"$f":"Calculator!J209","v":0},{"$f":"Calculator!L209","v":0},{"$nulls":15},0,{"$f":"C15","v":"Totals "}]
[]
[{"$nulls":23},"largest source",{"$f":"MAX(X8:X14)","v":0},{"$f":"OFFSET(Y7,SUMIF(X8:X15,Y17,W8:W15),)","v":0},null,null,{"$f":"OFFSET(AB7,SUMIF(X8:X15,Y17,W8:W15),)","v":0}]
[]
[]
[{"$nulls":24},{"$f":"\"In your case the largest single source of emissions is from \"&Z17&\". \"&AC17","v":"In your case the largest single source of emissions is from 0. 0"}]
[]
[]
[{"$nulls":27},"Although fertilisers generally have a signficant impact on emissions they also, of course, improve productivity. That is why the emission per tonne is generally a more useful indicator than emissions per hectare. High input systems can score well if they are matched by high outputs."]
{"$rows_empty":10}
[null,null,"Notes"]
[null,null,{"$f":"IF(X15<>0,Y20,\"\")","v":""}]
[]
[]
[null,null,{"$f":"IF(Y17<>X8,IF(Y18<>X9,\"\",AB23),AB23)","v":"Although fertilisers generally have a signficant impact on emissions they also, of course, improve productivity. That is why the emission per tonne is generally a more useful indicator than emissions per hectare. High input systems can score well if they are matched by high outputs."}]

{"sheet":"About","index":2,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,5,12],[7,0,15,12]]}
["Acknowledgement\n\nThis tool, funded by AHDB, was developed as part of AHDB project “Development of a carbon footprint protocol for the UK cereals and oilseed sector”. Central to this project was to provide farmers a simple decision support tool with robust and credible outputs to increase awareness and empower farmers.\n\nWe acknowledge that there is some commonality between this tool and the Cool Farm Tool, in terms of the underlying data and emissions factors, and for which we sought and obtained permission to re-use materials. However, there has been substantial innovation with regard to the interface  - which is a novel, designed entirely with the field crop farmer in mind.\n\n"]
[]
[]
[]
[]
[]
[]
["Disclaimer\n\nWhile the Agriculture and Horticulture Development Board, operating through its AHDB division, seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law, the Agriculture and Horticulture Development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document.\n\nReference herein to trade names and proprietary products without stating that they are protected does not imply that they may be regarded as  unprotected and thus free for general use. No endorsement of named products is intended, nor is any criticism implied of other alternative, but unnamed products.\n\nAHDB is the cereals and oilseeds division of the Agriculture and Horticulture Development Board."]
{"$rows_empty":10}
[{"$nulls":9},"AHDB"]
[{"$nulls":9},"Stoneleigh Park"]
[{"$nulls":9},"Warwickshire"]
[{"$nulls":9},"CV8 2TL"]
[{"$nulls":9},"cereals.ahdb.org.uk"]
[]
["This tool can be downloaded at cereals@ahdb.org.uk. ©Agriculture and Horticulture Development Board 2012. All rights reserved."]