{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Calculator","Soil type guidance","Rainfall guidance","Previous crop guidance"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":83,"n_cols":4,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Funded By:"]

{"sheet":"Calculator","index":1,"n_rows":183,"n_cols":15,"rows_kept":183,"cut":false,"hidden":false,"merged":[[27,6,27,7],[14,14,15,16],[12,13,12,17],[10,3,10,12]]}
[]
[]
[null,null,null,"Soil Nitrogen Supply Calculator",null,null,null,null,null,null,"Tried & Tested Terms of Use:",null,null,null,{"$f":"IF(I49=TRUE,\"Accepted\",\"Not accepted\")","v":"Not accepted"}]
[]
[null,null,1,"Tick one box only for the blue, brown and green boxes - soil nitrogen supply (SNS Index) will be shown in the orange box."]
[null,null,2,"Rainfall - based on annual or excess winter figures - use local information (especially after unusually wet or dry winter) or see map below."]
[null,null,3,"Soil type - establish soil types across farm by soil texturing a representative area of fields - for organic/peat soils see the Fertiliser Manual."]
[null,null,4,"Previous cropping - previous year only - PLOUGHED OUT GRASS LOW N = <250kg/ha/yr & HIGH N = >250kg/ha/yr."]
[null,null,5,"Manure use in previous years - tick the red  box if manures have been applied regularly in previous years."]
[null,null,6,"Guidance on soil types, rainfall and previous crop is in following sheets (select from bar at the bottom of this page)"]
[]
[]
[null,"RAINFALL",null,null,"SOIL TYPE",null,null,null,null,null,"PREVIOUS CROPPING",null,null,"SOIL NITROGEN SUPPLY INDEX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I49=TRUE,(IF(M49=TRUE,(SUM(N51+N52+N53+N54+N55+N56+N57+N58+N59+N60+N61+N62+N63+N64+N65+N66+N67+N68+N69+N70+N71+N72+N73+N74+N75+N76+N77+N78+N79+N80+N81+N82+N83+N84+N85+N86+N87+N88+N89+N90+N91+N92+N93+N94+N95+N96+N97+N98+N99+N100+N101+N102+N103+N104+N105+N106+N107+N108+N109+N110+N111+N112+N113+N114+N115+N116+N117+N118+N119+N120+N121+N122+N123+N124+N125+N126+N127+N128+N129+N130+N131+N132+N133+N134+N135+N136+N137+N138+N139+N140+N141+N142+N143+N144+N145+N146+N147+N148+N149+N150+N151+N152+N153+N154+N155+N156+N157+N158+N159+N160+N161+N162+N163+N164+N165+N166+N167+N168+N169+N170+N171+N172+N173+N174+N175+N176+N177+N178+N179+N180+N181+N182+N183)),IF(OR(C54>1,F55>1,L62>1),\"Too many ticks\",\"One tick per section\"))),\"See Introduction\")","v":"See Introduction"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Rainfall mm"]
[null,null,null,null,null,null,"Annual","Excess winter"]
[null,null,null,null,"LOW","Brown","500-600","up to 150"]
[null,null,null,null,"MODERATE","Yellow","600-700","150-250"]
[null,null,null,null,"HIGH","Green","700+","250+"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"MANURE USE IN PREVIOUS YEARS"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"OR(B51:B53)","v":false},null,null,{"$f":"OR(E51:E54)","v":false},null,null,{"$f":"IF(AND(C54=1,F55=1,L62=1),TRUE,FALSE)","v":false},false,null,{"$f":"OR(K51:K61)","v":false},null,{"$f":"AND(B49,E49,H49,K49)","v":false}]
[]
[null,false,{"$f":"IF(B51=TRUE,\"1\",\"0\")","v":"0"},null,false,{"$f":"IF(E51=TRUE,\"1\",\"0\")","v":"0"},null,null,null,null,false,{"$f":"IF(K51=TRUE,\"1\",\"0\")","v":"0"},{"$f":"AND(B51,E51,K51)","v":false},{"$f":"IF(M51=TRUE,\"0\",\"0\")","v":"0"}]
[null,false,{"$f":"IF(B52=TRUE,\"1\",\"0\")","v":"0"},null,false,{"$f":"IF(E52=TRUE,\"1\",\"0\")","v":"0"},null,null,null,null,false,{"$f":"IF(K52=TRUE,\"1\",\"0\")","v":"0"},{"$f":"AND(B51,E51,K52)","v":false},{"$f":"IF(M52=TRUE,\"0\",\"0\")","v":"0"}]
[null,false,{"$f":"IF(B53=TRUE,\"1\",\"0\")","v":"0"},null,false,{"$f":"IF(E53=TRUE,\"1\",\"0\")","v":"0"},null,null,null,null,false,"0",{"$f":"AND(B51,E51,K53)","v":false},{"$f":"IF(M53=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,{"$f":"C51+C52+C53","v":0},null,false,{"$f":"IF(E54=TRUE,\"1\",\"0\")","v":"0"},null,null,null,null,false,"0",{"$f":"AND(B51,E51,K54)","v":false},{"$f":"IF(M54=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,{"$f":"F51+F52+F53+F54","v":0},null,null,null,null,false,"0",{"$f":"AND(B51,E51,K55)","v":false},{"$f":"IF(M55=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,false,"0",{"$f":"AND(B51,E51,K56)","v":false},{"$f":"IF(M56=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,false,"0",{"$f":"AND(B51,E51,K57)","v":false},{"$f":"IF(M57=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,false,"0",{"$f":"AND(B51,E51,K58)","v":false},{"$f":"IF(M58=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,false,"0",{"$f":"AND(B51,E51,K59)","v":false},{"$f":"IF(M59=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,false,"0",{"$f":"AND(B51,E51,K60)","v":false},{"$f":"IF(M60=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,false,"0",{"$f":"AND(B51,E51,K61)","v":false},{"$f":"IF(M61=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"K51+K52+K53+K54+K55+K56+K57+K58+K59+K60+K61","v":0},{"$f":"AND(B$51,E$52,K51)","v":false},{"$f":"IF(M62=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M63=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M64=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M65=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M66=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M67=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M68=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M69=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M70=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M71=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$52,K61)","v":false},{"$f":"IF(M72=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$53,K51)","v":false},{"$f":"IF(M73=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M74=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M75=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M76=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M77=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M78=TRUE,\"5\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M79=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M80=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$53,K59)","v":false},{"$f":"IF(M81=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$53,K60)","v":false},{"$f":"IF(M82=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$53,K61)","v":false},{"$f":"IF(M83=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$54,K51)","v":false},{"$f":"IF(M84=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M85=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M86=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M87=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M88=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M89=TRUE,\"5\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M90=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M91=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$54,K59)","v":false},{"$f":"IF(M92=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$54,K60)","v":false},{"$f":"IF(M93=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$51,E$54,K61)","v":false},{"$f":"IF(M94=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$51,K51)","v":false},{"$f":"IF(M95=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M96=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M97=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M98=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M99=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M100=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M101=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M102=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$51,K59)","v":false},{"$f":"IF(M103=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$51,K60)","v":false},{"$f":"IF(M104=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$51,K61)","v":false},{"$f":"IF(M105=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$52,K51)","v":false},{"$f":"IF(M106=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M108=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M110=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M111=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M113=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$52,K59)","v":false},{"$f":"IF(M114=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$52,K60)","v":false},{"$f":"IF(M115=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$52,K61)","v":false},{"$f":"IF(M116=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$53,K51)","v":false},{"$f":"IF(M117=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M118=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M119=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M120=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M121=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M122=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M123=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M124=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$53,K59)","v":false},{"$f":"IF(M125=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$53,K60)","v":false},{"$f":"IF(M126=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$53,K61)","v":false},{"$f":"IF(M127=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$54,K51)","v":false},{"$f":"IF(M128=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M129=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M130=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M131=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M132=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M133=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M134=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M135=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$54,K59)","v":false},{"$f":"IF(M136=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$54,K60)","v":false},{"$f":"IF(M137=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$52,E$54,K61)","v":false},{"$f":"IF(M138=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$51,K51)","v":false},{"$f":"IF(M139=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M140=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M143=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M144=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M145=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$51,K59)","v":false},{"$f":"IF(M147=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$51,K60)","v":false},{"$f":"IF(M148=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$51,K61)","v":false},{"$f":"IF(M149=TRUE,\"0\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$52,K51)","v":false},{"$f":"IF(M150=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M151=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M154=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M155=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,false,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$52,K59)","v":false},{"$f":"IF(M158=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$52,K60)","v":false},{"$f":"IF(M159=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$52,K61)","v":false},{"$f":"IF(M160=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$53,K51)","v":false},{"$f":"IF(M161=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M162=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M163=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M164=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M165=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M166=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M167=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M168=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$53,K59)","v":false},{"$f":"IF(M169=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$53,K60)","v":false},{"$f":"IF(M170=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$53,K61)","v":false},{"$f":"IF(M171=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$54,K51)","v":false},{"$f":"IF(M172=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M173=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M174=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M175=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M176=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M177=TRUE,\"4\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M178=TRUE,\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M179=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$54,K59)","v":false},{"$f":"IF(M180=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$54,K60)","v":false},{"$f":"IF(M181=TRUE,\"3\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(B$53,E$54,K61)","v":false},{"$f":"IF(M182=TRUE,\"2\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(M183=TRUE,\"1\",\"0\")","v":"0"}]

{"sheet":"Soil type guidance","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[30,2,30,6],[32,2,32,6],[34,2,34,6],[36,2,36,6],[38,2,38,6]]}
[]
[]
[]
[]
[null,null,null,"Tried & Tested Terms of Use:",null,null,null,{"$f":"IF(Calculator!I49=TRUE,\"Accepted\",\"Not accepted\")","v":"Not accepted"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Light sand soils","Soils which are sand, loamy sand or sandy loam to 40 cm depth and are sand or loamy sand between 40 and 80 cm, or over sandstone rock."]
[]
[null,"Shallow soils","Soils over impermeable subsoils and those where the parent rock (chalk, limestone or other rock) is within 40 cm of the soil surface. Sandy soils developed over sandstone rock should be regarded as light sand soils."]
[]
[null,"Medium soils","Mostly medium-textured mineral soils that do not fall into any other soil category. This includes sandy loams over clay, deep loams, and silty or clayey topsoils that have sandy or loamy subsoils."]
[]
[null,"Deep clayey soils","Soils with predominantly sandy clay loam, silty clay loam, clay loam, sandy clay, silty clay or clay topsoil overlying clay subsoil to more than 40cm depth. Deep clayey soils normally need artificial field drainage."]
[]
[null,"Deep silty soils","Soils of sandy silt loam, silt loam or silty clay loam textures to 100 cm depth or more. Silt soils formed on marine alluvium, warp soils (river alluvium) and brickearth soils are in this category. Silty clays of low fertility should be regarded as other mineral soils."]

{"sheet":"Rainfall guidance","index":3,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Tried & Tested Terms of Use:",null,null,null,{"$f":"IF(Calculator!I49=TRUE,\"Accepted\",\"Not accepted\")","v":"Not accepted"}]

{"sheet":"Previous crop guidance","index":4,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Tried & Tested Terms of Use:",null,null,null,{"$f":"IF(Calculator!I49=TRUE,\"Accepted\",\"Not accepted\")","v":"Not accepted"}]