{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Introduction to N Supply"," Soil N Supply Calculator","Soil N Results","Quick N - Nitrate N Calculator","Quick N Results","Tips on Soil Sampling","Understanding Soil N","Understanding N Demand","Soil Mineralised N CalculatorV1","Dropdowns","Lookup"],"not_rendered":{"charts":1,"images":14,"macros":1,"defined_names":2,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"Introduction to N Supply","index":0,"n_rows":111,"n_cols":2,"rows_kept":111,"merged":[[22,1,22,7],[33,1,33,7],[35,1,35,7],[37,1,37,6],[86,1,86,7],[108,1,108,7],[110,1,110,7]]}
[]
[null,"Introduction to Understanding Your Soil Nitrogen Supply"]
{"$rows_empty":20}
[null,"Find out more about soil sampling"]
{"$rows_empty":10}
[null,"Find out more about Soil N and Initial Soil Mineral N"]
[]
[null,"Enter your soil Mineral N results into N Supply Calculator"]
[]
[null,"Calculate Quick N test results"]
{"$rows_empty":48}
[null,"Enter your soil PMN results into N Supply Calculator"]
{"$rows_empty":21}
[null,"Click to see further information on fertiliser management"]
[]
[null,"Go to Soil N Supply Calculator"]

{"sheet":" Soil N Supply Calculator","index":1,"n_rows":50,"n_cols":26,"rows_kept":50,"merged":[[0,6,0,7],[35,7,35,8],[36,7,36,8],[37,7,37,8]]}
[null,"Calculating Soil Nitrogen Supply",{"$nulls":4},"Return to Front Page"]
[]
[]
[]
[null,"Mineral N (kg N/ha) =  Mineral N (mg/kg)   x   Bulk Density  (g/cm3) x   Depth (cm) x 0.1"]
[null,"Estimated Mineralised N (kg N/ha) =  Potentially Mineralisable N [PMN*] (mg/kg)   x   Bulk Density  x   Total Climate Factor   /   Unit Factor"]
[]
[]
[null,"Paddock and Soil Details","* Must be filled in",null,null,"Estimating Mineralised N (kg N/ha)",{"$nulls":6},"Total Soil N Supply  (kg N/ha)"]
[]
["*","Paddock ID",{"$nulls":3},"Monthly Calculations",{"$nulls":6},"What you've got",{"$nulls":3},"Soil mineral N available",{"$f":"D30+D31","v":0},"kg N/ha","(A)"]
["*","Sampling date",{"$nulls":10},"What you might get",{"$nulls":3},"Total estimated N mineralised in growing season",{"$f":"J38","v":0},"kg N/ha","(B)"]
[{"$nulls":7},"Month","1st Soil Depth ","2nd Soil Depth","Monthly ",{"$nulls":5},"Total estimated soil N supply over growing season",{"$f":"R12+R11","v":0},"kg N/ha","( C)  = (A+B)",null,"Month","Soil N Supply (kg N/ha)","Estimated total crop N demand ",null,"Month"]
["*","Sampling depth (cm) - 1",null,{"$f":"IF(C14=\"0-15cm\",15,30)","v":30},null,"Irrigation (y/n)?","Climate Factor",null,{"$f":"C14","v":0},{"$f":"C15","v":0},"Total (kg/ha)",{"$nulls":10},{"$f":"IF(G32=\"Sep\",\"Aug\",IF(G32=\"Oct\",\"Sep\", IF(G32=\"Nov\",\"Oct\", IF(G32=\"Dec\",\"Nov\",IF(G32=\"Jan\",\"Dec\",IF(G32=\"Feb\",\"Jan\",IF(G32=\"Mar\",\"Feb\",IF(G32=\"Apr\",\"Mar\", IF(G32=\"May\",\"Apr\",0)))))))))","v":0},{"$f":"R11","v":0},{"$f":"C23*1","v":0}]
[null,"Soil depth 2",null,{"$f":"IF(C15=\"15-30cm\",15,IF(C15=\"15-60cm\",45,30))","v":30},null,"No",{"$f":"IFERROR(IF(F15=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H15,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H15,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Sep",{"$f":"$C$38*$C$18*G15/(IF($C$14=\"0-15cm\",100,50))","v":{"v":0,"d":"0.0"}},{"$f":"$C$39*$C$19*G15/(IF($C$15=\"15-30cm\",100,50))","v":{"v":0,"d":"0.0"}},{"$f":"J15+I15","v":{"v":0,"d":"0.0"}},null,"What the crop needs",{"$nulls":4},{"$f":"C23","v":0},"kg N/ha","(D)",null,{"$f":"IF(OR(V14=G33,V14=\" \"),\" \",IF(V14=\"Aug\",\"Sep\",IF(V14=\"Sep\",\"Oct\",IF(V14=\"Oct\",\"Nov\",IF(V14=\"Nov\",\"Dec\",IF(V14=\"Dec\",\"Jan\",IF(V14=\"Jan\",\"Feb\",IF(V14=\"Feb\",\"Mar\",IF(V14=\"Mar\",\"Apr\",IF(V14=\"Apr\",\"May\",0))))))))))","v":" "},{"$f":"W14+(INDEX(I15:I23,(MATCH(V15,H15:H23,0))))+(INDEX(J15:J23,(MATCH(V15,H15:H23,0))))","v":{"$error":"#N/A"}}]
[{"$nulls":5},"No",{"$f":"IFERROR(IF(F16=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H16,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H16,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Oct",{"$f":"$C$38*$C$18*G16/(IF($C$14=\"0-15cm\",100,50))","v":{"v":0,"d":"0.0"}},{"$f":"$C$39*$C$19*G16/(IF($C$15=\"15-30cm\",100,50))","v":{"v":0,"d":"0.0"}},{"$f":"J16+I16","v":{"v":0,"d":"0.0"}},null,"Difference between crop need and estimated soil N supply",{"$nulls":4},{"$f":"R15-R13","v":0},"kg N/ha","( E) = (D - C)",null,{"$f":"IF(OR(V15=G33,V15=\" \"),\" \",IF(V15=\"Aug\",\"Sep\",IF(V15=\"Sep\",\"Oct\",IF(V15=\"Oct\",\"Nov\",IF(V15=\"Nov\",\"Dec\",IF(V15=\"Dec\",\"Jan\",IF(V15=\"Jan\",\"Feb\",IF(V15=\"Feb\",\"Mar\",IF(V15=\"Mar\",\"Apr\",IF(V15=\"Apr\",\"May\",0))))))))))","v":" "},{"$f":"W15+(INDEX(I16:I24,(MATCH(V16,H16:H24,0))))+(INDEX(J16:J24,(MATCH(V16,H16:H24,0))))","v":{"$error":"#N/A"}}]
[null,"Soil Type",{"$nulls":3},"No",{"$f":"IFERROR(IF(F17=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H17,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H17,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Nov",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,"\"Confidence\" factor (How much of the potential soil N supply estimate to include)",{"$nulls":4},100,"%","(F)",null,{"$f":"IF(OR(V16=G33,V16=\" \"),\" \",IF(V16=\"Aug\",\"Sep\",IF(V16=\"Sep\",\"Oct\",IF(V16=\"Oct\",\"Nov\",IF(V16=\"Nov\",\"Dec\",IF(V16=\"Dec\",\"Jan\",IF(V16=\"Jan\",\"Feb\",IF(V16=\"Feb\",\"Mar\",IF(V16=\"Mar\",\"Apr\",IF(V16=\"Apr\",\"May\",0))))))))))","v":" "},{"$error":"#N/A"}]
["*","Bulk Density - depth 1",{"$nulls":3},"No",{"$f":"IFERROR(IF(F18=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H18,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H18,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Dec",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,"Revised fertiliser N requirement",{"$nulls":4},{"$f":"R15-((R17/100)*R13)","v":0},"kg N/ha","(G) = (D-(F/100)xC)",null,{"$f":"IF(OR(V17=G33,V17=\" \"),\" \",IF(V17=\"Aug\",\"Sep\",IF(V17=\"Sep\",\"Oct\",IF(V17=\"Oct\",\"Nov\",IF(V17=\"Nov\",\"Dec\",IF(V17=\"Dec\",\"Jan\",IF(V17=\"Jan\",\"Feb\",IF(V17=\"Feb\",\"Mar\",IF(V17=\"Mar\",\"Apr\",IF(V17=\"Apr\",\"May\",0))))))))))","v":" "},{"$error":"#N/A"}]
[null,"Bulk Density -depth 2",{"$nulls":3},"No",{"$f":"IFERROR(IF(F19=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H19,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H19,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Jan",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,"N fertiliser saving",{"$nulls":4},{"$f":"R15-R18","v":0},"kg N/ha","(D - G)",null,{"$f":"IF(OR(V18=G33,V18=\" \"),\" \",IF(V18=\"Aug\",\"Sep\",IF(V18=\"Sep\",\"Oct\",IF(V18=\"Oct\",\"Nov\",IF(V18=\"Nov\",\"Dec\",IF(V18=\"Dec\",\"Jan\",IF(V18=\"Jan\",\"Feb\",IF(V18=\"Feb\",\"Mar\",IF(V18=\"Mar\",\"Apr\",IF(V18=\"Apr\",\"May\",0))))))))))","v":" "},{"$error":"#N/A"}]
[{"$nulls":5},"No",{"$f":"IFERROR(IF(F20=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H20,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H20,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Feb",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$nulls":10},{"$f":"IF(OR(V19=G33,V19=\" \"),\" \",IF(V19=\"Aug\",\"Sep\",IF(V19=\"Sep\",\"Oct\",IF(V19=\"Oct\",\"Nov\",IF(V19=\"Nov\",\"Dec\",IF(V19=\"Dec\",\"Jan\",IF(V19=\"Jan\",\"Feb\",IF(V19=\"Feb\",\"Mar\",IF(V19=\"Mar\",\"Apr\",IF(V19=\"Apr\",\"May\",0))))))))))","v":" "},{"$error":"#N/A"}]
["*","Climate Region",{"$nulls":3},"No",{"$f":"IFERROR(IF(F21=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H21,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H21,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Mar",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$nulls":10},{"$f":"IF(OR(V20=G33,V20=\" \"),\" \",IF(V20=\"Aug\",\"Sep\",IF(V20=\"Sep\",\"Oct\",IF(V20=\"Oct\",\"Nov\",IF(V20=\"Nov\",\"Dec\",IF(V20=\"Dec\",\"Jan\",IF(V20=\"Jan\",\"Feb\",IF(V20=\"Feb\",\"Mar\",IF(V20=\"Mar\",\"Apr\",IF(V20=\"Apr\",\"May\",0))))))))))","v":" "},{"$error":"#N/A"}]
[{"$nulls":5},"No",{"$f":"IFERROR(IF(F22=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H22,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H22,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"Apr",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$nulls":10},{"$f":"IF(OR(V21=G33,V21=\" \"),\" \",IF(V21=\"Aug\",\"Sep\",IF(V21=\"Sep\",\"Oct\",IF(V21=\"Oct\",\"Nov\",IF(V21=\"Nov\",\"Dec\",IF(V21=\"Dec\",\"Jan\",IF(V21=\"Jan\",\"Feb\",IF(V21=\"Feb\",\"Mar\",IF(V21=\"Mar\",\"Apr\",IF(V21=\"Apr\",\"May\"))))))))))","v":" "},{"$error":"#N/A"}]
[null,"Estimated total crop",null,"(kg N/ha)",null,"No",{"$f":"IFERROR(IF(F23=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H23,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH(' Soil N Supply Calculator'!$C$21,Lookup!$G$6:$G$19,0),MATCH(' Soil N Supply Calculator'!H23,Lookup!$Q$5:$Y$5,0))),0)","v":{"v":0,"d":"0.0"}},"May",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$nulls":10},{"$f":"IF(OR(V22=G33,V22=\" \"),\" \",IF(V22=\"Aug\",\"Sep\",IF(V22=\"Sep\",\"Oct\",IF(V22=\"Oct\",\"Nov\",IF(V22=\"Nov\",\"Dec\",IF(V22=\"Dec\",\"Jan\",IF(V22=\"Jan\",\"Feb\",IF(V22=\"Feb\",\"Mar\",IF(V22=\"Mar\",\"Apr\",IF(V22=\"Apr\",\"May\",0))))))))))","v":" "},{"$error":"#N/A"}]
[null,"N demand"]
[{"$nulls":7},"Sub total",{"$f":"SUM(I15:I23)","v":0},{"$f":"SUM(J15:J23)","v":0}]
[null,"Soil Test Results"]
[]
[null,"Soil mineral N - What you've got"]
[null,null,"Lab Results - Min N (mg/kg)","Min N (Kg/ha)",null,"Estimate of mineralised N during growing season (active crop N uptake)"]
[null,"Sampling depth 1",null,{"$f":"IF(B34=\"No\", (C30*C18*D14*0.1),D33)","v":0}]
[null,"Sampling depth 2",null,{"$f":"IF(B34=\"No\", (C31*C19*D15*0.1),D34)","v":0},null,"Growing Season"]
[null,null,"Total Min N",{"$f":"D31+D30","v":0},null,"Start Month",null,"*","* Must be filled in"]
[null,"Use a Quick N result instead?","Sampling depth 1",null,null,"End Month ",null,"*"]
[null,"No","Sampling depth 2"]
[]
[null,"Potentially mineralisable N - What you might get",{"$nulls":4},"Soil Depth 1","Soil Depth 2",null,"Total "]
[null,null,"Lab Results - PMN (mg/kg)",{"$nulls":3},{"$f":"C14","v":0},{"$f":"C15","v":0}]
[null,"Sampling depth 1",null,{"$f":"C14","v":0},null,"Estm N",{"$f":"IFERROR(SUM(INDEX(I15:I23,(MATCH(G32,H15:H23,0))):INDEX(I15:I23,(MATCH(G33,H15:H23,0)))),0)","v":0},{"$f":"IFERROR(SUM(INDEX(J15:J23,(MATCH(G32,H15:H23,0))):INDEX(J15:J23,(MATCH(G33,H15:H23,0)))),0)","v":0},null,{"$f":"G38+H38","v":0},"kg/ha"]
[null,"Sampling depth 2",null,{"$f":"C15","v":0},null,"Mineralised"]
[{"$nulls":9},{"$f":"J38+D32","v":0}]
{"$rows_empty":8}
[null,"Yes"]
[null,"No"]

{"sheet":"Soil N Results","index":2,"n_rows":3,"n_cols":17,"rows_kept":3}
["Soil N Supply Calculator - Estimated Results ",{"$nulls":3},"(Note: This sheet is populated when you use the \"Save Results\" button on the Soil N Supply calculator tab)"]
[null,null,"What you've got","What you 'might' get in Growing Season","Estm total soil N supply",{"$nulls":5},"Soil Test Results"]
["Paddock ","Sample Date","Min N (kg/ha)","N Mineralised (kg/ha)","Total Soil N Supply (kg/ha) ","Sample \nDepth 1","Sample\nDepth 2","Soil Type","BD \nDepth 1","BD \nDepth 2","Min N\nDepth 1\n(mg/kg)","Min N\nDepth 2\n(mg/kg)","PMN \nDepth 1\n(mg/kg)","PMN \nDepth 2\n(mg/kg)","Start of Season","End of Season","Climate Region"]

{"sheet":"Quick N - Nitrate N Calculator","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[1,7,1,8]]}
[]
[null,"Quick N Test - Converting from mg/l to kg/ha",{"$nulls":5},"Return to Front Page"]
[]
[null,"Paddock Name"]
[null,"Sample Date"]
[]
[null,"      Conversion formula =  (Test strip result / soil correction factor) x (soil sample depth/10) x soil bulk density"]
[]
[null,"Sampling Depth",null,"cm"]
[]
[null,"Result from test strip\n(mg/l from App or Strip Jar)",null,"mg/l"]
[]
[null,"Soil Texture"]
[]
[null,"Soil Moisture"]
[]
[null,"Soil Correction",{"$f":"IFERROR(INDEX(Lookup!B2:D13,MATCH(C13,Lookup!A2:A13,1), MATCH(C15,Lookup!B1:D1,1)),0)","v":0}]
[]
[null,"Bulk Density (Click \"i\" advice)"]
[]
[]
[null,"Result ",{"$f":"IFERROR((C11/C17)*(C9/10)*C19,0)","v":0},"kg nitrate N/ha"]

{"sheet":"Quick N Results","index":4,"n_rows":2,"n_cols":9,"rows_kept":2}
["Quick N - Test Results",null,null,"(Note: This sheet is populated when you use the \"Save Results\" button on the Quick N calculator tab)"]
["Paddock ","Date","kg N/ha","mg/l in Test ","Sample depth","Texture","Moisture","Soil Correction ","Bulk Density"]

{"sheet":"Tips on Soil Sampling","index":5,"n_rows":52,"n_cols":4,"rows_kept":52,"merged":[[0,0,0,2],[0,6,0,8],[49,1,49,7],[51,3,51,5]]}
["Return to Front Page"]
{"$rows_empty":48}
[null,"See FAR's Nitrogen - Confidence to Cut Back booklet"]
[]
[{"$nulls":3},"Return to Front Page"]

{"sheet":"Understanding Soil N","index":6,"n_rows":70,"n_cols":11,"rows_kept":70,"merged":[[0,0,0,2],[26,1,26,7],[26,10,26,12],[28,1,28,7],[69,1,69,3]]}
["Return to Front Page"]
{"$rows_empty":25}
[null,"Enter your soil Mineral N results into N Supply Calculator",{"$nulls":8},"Return to Front Page"]
[]
[null,"See FAR's Nitrogen - Confidence to Cut Back booklet"]
{"$rows_empty":40}
[null,"Return to Front Page"]

{"sheet":"Understanding N Demand","index":7,"n_rows":49,"n_cols":2,"rows_kept":49,"merged":[[0,0,0,2],[46,1,46,7],[48,1,48,3]]}
["Return to Front Page"]
[null,"Understanding Crop N Demand and Fertiliser Management"]
{"$rows_empty":44}
[null,"Enter your soil Mineral N results into N Supply Calculator"]
[]
[null,"Return to Front Page"]

{"sheet":"Soil Mineralised N CalculatorV1","index":8,"n_rows":34,"n_cols":9,"rows_kept":34,"hidden":true,"merged":[[30,3,30,4],[31,3,31,4]]}
[null,"Calculating Mineralised N in Your Soil"]
[]
[]
[]
[null,"Estimated Mineralised N (kg N/ha) =  Potentially Mineralisable N [PMN*] (mg/kg)   x   Bulk Density  x   Total Climate Factor   /   Unit Factor"]
[]
[null,"Selecting Parameters"]
[null,"Paddock name"]
[null,"Sample date"]
[{"$nulls":6},"Estimated Mineralised N (kg N/ha)"]
[null,"Sampling Depth (cm)",{"$nulls":4},"Month","Top Soil Depth ","2nd Soil Depth"]
[null,"2nd depth",null,null,"Irrigation (y/n)?","Climate Factor",null,{"$f":"C11","v":0},{"$f":"C12","v":0}]
[{"$nulls":4},"No",{"$f":"IF(E13=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G13,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G13,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Sep",{"$f":"$C$23*$C$15*F13/100","v":{"$error":"#N/A"}},{"$f":"$C$24*$C$16*F13/100","v":{"$error":"#N/A"}}]
[null,"Soil Type",null,null,"No",{"$f":"IF(E14=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G14,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G14,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Oct",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Bulk Density - surface",{"v":0.9,"d":"0.90"},null,"No",{"$f":"IF(E15=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G15,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G15,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Nov",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Bulk Density -2nd depth",null,null,"No",{"$f":"IF(E16=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G16,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G16,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Dec",{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},"No",{"$f":"IF(E17=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G17,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G17,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Jan",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Climate Region",null,null,"No",{"$f":"IF(E18=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G18,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G18,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Feb",{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},"No",{"$f":"IF(E19=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G19,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G19,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Mar",{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":4},"No",{"$f":"IF(E20=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G20,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G20,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"Apr",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Soil Test Results - PMN",null,null,"No",{"$f":"IF(E21=\"No\",INDEX(Lookup!$H$6:$P$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G21,Lookup!$H$5:$P$5,0)),INDEX(Lookup!$Q$6:$Y$19,MATCH('Soil Mineralised N CalculatorV1'!$C$18,Lookup!$G$6:$G$19,0),MATCH('Soil Mineralised N CalculatorV1'!G21,Lookup!$Q$5:$Y$5,0)))","v":{"$error":"#N/A"}},"May",{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,"Soil Depth Sampled ",100,{"$nulls":3},"Sub total",{"$f":"SUM(H13:H21)","v":{"$error":"#N/A"}},{"$f":"SUM(I13:I21)","v":{"$error":"#N/A"}}]
[null,"2nd depth"]
[{"$nulls":6},"Total estimimated N mineralised in Year",{"$f":"H23+I23","v":{"$error":"#N/A"}}," (kg/ha)"]
[null,"Estimate of mineralised N during period of active crop N uptake"]
[]
[null,"Start Month","Sep"]
[null,"End Month ","Feb"]
[]
[{"$nulls":3},"2nd Soil Depth",null,"Total "]
[null,"Estm Mineralised N (kg/ha)",{"$f":"SUM(INDEX(H13:H21,(MATCH(C28,G13:G21,0))):INDEX(H13:H21,(MATCH(C29,G13:G21,0))))","v":{"$error":"#N/A"}},{"$f":"SUM(INDEX(I13:I21,(MATCH(C28,G13:G21,0))):INDEX(I13:I21,(MATCH(C29,G13:G21,0))))","v":{"$error":"#N/A"}},null,{"$f":"C32+D32","v":{"$error":"#N/A"}}]
[]
[{"$nulls":7},"Could we have a save button here like the quick test version?"]

{"sheet":"Dropdowns","index":9,"n_rows":23,"n_cols":11,"rows_kept":23,"hidden":true}
[null,"Texture","Moisture",null,null,"Depth","Soil Type","Region","Months",null,"Irrigation "]
[{"$nulls":10},"Yes"]
[null,"Clay","Dry",null,null,"0-15cm","Allophanic","Auckland (Pukekohe)","Sep",null,"No"]
[null,"Clay loam","Moist",null,null,"0-30cm","Brown","Waikato (Matamata)","Oct"]
[null,"Loam","Wet",{"$nulls":3},"Gley","Taranaki (Stratford)","Nov"]
[null,"Loamy sand",{"$nulls":3},"15-30cm","Granular","Bay of Plenty (Whakatane)","Dec"]
[null,"Sand",{"$nulls":3},"15-60cm","Pallic","Gisborne (Matawhero)","Jan"]
[null,"Sandy clay",{"$nulls":3},"30-60cm","Recent","Hawke's Bay (Whakatu)","Feb"]
[null,"Sandy clay loam",{"$nulls":5},"Manawatu (Levin)","Mar"]
[null,"Sandy loam",{"$nulls":5},"Tasman (Riwaka)","Apr"]
[null,"Silt",{"$nulls":5},"Marlborough (Blenheim)","May"]
[null,"Silt loam",{"$nulls":5},"North Canterbury (Waiau)"]
[null,"Silty clay",{"$nulls":5},"Mid Canterbury (Lincoln)"]
[null,"Silty clay loam",{"$nulls":5},"Mid Canterbury (Ashburton)"]
[{"$nulls":7},"South Canterbury (Waimate)"]
[{"$nulls":7},"Southland (Gore)"]
[]
[]
[]
[]
[null,"INDEX(Lookup!B2:D13,MATCH(C13,Lookup!A2:A13,1), MATCH('N Calculator'!C15,Lookup!B1:D1,1))"]
[]
[{"$nulls":7},"IF($C$14=\"0-30cm\", Dropdowns!$F$8, IF($C$14=\"0-15cm\", Dropdowns!$F$6:$F$7, Dropdowns!$F$6:$F$8))"]

{"sheet":"Lookup","index":10,"n_rows":25,"n_cols":33,"rows_kept":25,"hidden":true}
[null,"Dry","Moist","Wet",null,null,"Climate Factors",{"$nulls":19},"Soil - Bulk Density"]
["Clay",1.8,1.5,1.3]
["Clay loam",1.7,1.4,1.3,null,null,"Region",{"$nulls":3},"Dryland",{"$nulls":8},"Irrigated",{"$nulls":7},"Allophanic","Brown","Gley","Granular","Pallic","Recent"]
["Loam",2,1.5,1.3,{"$nulls":4},"Spring",null,null,"Summer",null,null,"Autumn",null,"Spring",{"$nulls":3},"Summer",null,null,"Autumn"]
["Loamy sand",1.8,1.5,1.4,{"$nulls":3},"Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May",null,"0-15cm",{"v":0.7,"d":"0.70"},1.15,1.15,{"v":0.8,"d":"0.80"},1.17,1.16]
["Sand",1.8,1.5,1.4,null,null,"Auckland (Pukekohe)",{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},12.5,12.5,12.5,14.5,14.5,14.5,16.5,16.5,16.5,{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},null,"0-30cm",0.76,1.22,{"v":1.2,"d":"1.20"},0.83,1.24,1.19]
["Sandy clay",1.8,1.4,1.3,null,null,"Waikato (Matamata)",{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},12.5,12.5,12.5,14.5,14.5,14.5,16.5,16.5,16.5,{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},null,"15-30cm",0.82,{"v":1.3,"d":"1.30"},1.28,0.86,1.32,1.22]
["Sandy clay loam",1.9,1.6,1.4,null,null,"Taranaki (Stratford)",{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},16.5,16.5,16.5,{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},16.5,16.5,16.5,{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"}]
["Sandy loam",2.1,1.8,1.5,null,null,"Bay of Plenty (Whakatane)",{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},14.5,14.5,14.5,{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"}]
["Silt",1.9,1.4,1.3,null,null,"Gisborne (Matawhero)",12.5,12.5,12.5,13.5,13.5,13.5,{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"}]
["Silt loam",1.7,1.4,1.3,null,null,"Hawke's Bay (Whakatu)",9.5,9.5,9.5,{"v":12,"d":"12.0"},{"v":12,"d":"12.0"},{"v":12,"d":"12.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},12.5,12.5,12.5,{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},{"v":17,"d":"17.0"},14.5,14.5,14.5]
["Silty clay",1.9,1.6,1.4,null,null,"Manawatu (Levin)",10.5,10.5,10.5,12.5,12.5,12.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":12,"d":"12.0"},{"v":12,"d":"12.0"},{"v":12,"d":"12.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"}]
["Silty clay loam",1.9,1.5,1.4,null,null,"Tasman (Riwaka)",{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},11.5,11.5,11.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"}]
[{"$nulls":6},"Marlborough (Blenheim)",8.5,8.5,8.5,10.5,10.5,10.5,7.5,7.5,7.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":12,"d":"12.0"},{"v":12,"d":"12.0"},{"v":12,"d":"12.0"}]
[{"$nulls":6},"North Canterbury (Waiau)",{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},9.5,9.5,9.5,7.5,7.5,7.5,9.5,9.5,9.5,14.5,14.5,14.5,11.5,11.5,11.5]
["Quick N - Look Ups",{"$nulls":5},"Mid Canterbury (Lincoln)",7.5,7.5,7.5,{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},8.5,8.5,8.5,{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},11.5,11.5,11.5]
[{"$nulls":6},"Mid Canterbury (Ashburton)",{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},10.5,10.5,10.5,8.5,8.5,8.5,{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":9,"d":"9.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},{"v":15,"d":"15.0"},11.5,11.5,11.5]
[{"$nulls":6},"South Canterbury (Waimate)",7.5,7.5,7.5,9.5,9.5,9.5,{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},{"v":8,"d":"8.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":14,"d":"14.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"}]
[{"$nulls":6},"Southland (Gore)",{"v":7,"d":"7.0"},{"v":7,"d":"7.0"},{"v":7,"d":"7.0"},9.5,9.5,9.5,7.5,7.5,7.5,{"v":7,"d":"7.0"},{"v":7,"d":"7.0"},{"v":7,"d":"7.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},{"v":13,"d":"13.0"},9.5,9.5,9.5]
[]
[]
[null,"INDEX(Lookup!P4:U5,MATCH('Soil Mineralised N Calculator'!C10,Lookup!O4:O5,1), MATCH('Soil Mineralised N Calculator'!C13,Lookup!P4:U4,1))"]
[]
[]
[null,"INDEX(Lookup!B2:D13,MATCH(C15,Lookup!A2:A13,1), MATCH('Quick N - Nitrate N Calculator'!C17,Lookup!B1:D1,1))"]