{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":40,"n_cols":31,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Nutrients from effluent and sludge calculator",null,null,null,null,null,null,null,"(Version 3.1)"]
[null,"Step","   Select type of material being spread",null,null,null,null,null,null,null,null,"Sludge:","N (kg/ML)","P (kg/ML)","K (kg/ML)","% solids",null,null,null,null,null,null,"OB step 3 TF",null,false,false,true,false]
[null,1,null,"Your selection:",{"$f":"LOOKUP(Y10,AB18:AB20,AC18:AC20)","v":"Sludge"},null,null,null,null,null,null,null,957,239,593,8.3000000000000007,null,null,null,null,"Southwest Victoria",null,"OB step 3",null,{"$f":"IF(Y2=TRUE,1,IF(Z2=TRUE,2,IF(AA2=TRUE,3,IF(AB2=TRUE,4))))","v":3},{"$f":"IF($Y$3=1,IF(Y10=1,D39/(E8*D38),D39/E8))","v":false},null,null,1,"nitrogen content"]
[null,null,{"$f":"IF(Y10=1,\"   Nutrient concentrations in sludge are very dependant on % solids.\",\"\")","v":"   Nutrient concentrations in sludge are very dependant on % solids."},null,null,null,null,null,null,null,null,null,1893,612,934,"na",null,null,null,null,"NSW - Central",null,null,null,null,{"$f":"IF($Y$3=2,D40/G8)","v":false},null,null,2,"potassium content"]
[null,null,{"$f":"IF(Y10=1,\"     Test your own sludge and be cautious with variation in % solids.\",\"\")","v":"     Test your own sludge and be cautious with variation in % solids."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y10=1,IF(Y12=3,\"<-- ENTER OWN DATA HERE\",\"\"),\"\")","v":""},null,null,null,null,"OWN DATA",null,null,null,null,{"$f":"IF($Y$3=3,IF(Y10=1,D39/(E8*D38),D39/E8))","v":0.15673981191222569},null,{"$f":"IF(Y3=3,D40/G8)","v":0.10118043844856661},3,{"$f":"IF(Z5=Y7,\"nitrogen content\",IF(AB5=Y7,\"potassium content\"))","v":"potassium content"}]
[null,2,"   Choose your source of data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Y$3=4,IF(Y10=1,E16/(E8*D38),E16/E8))","v":false},{"$f":"IF($Y$3=4,F16/F8)","v":false},{"$f":"IF($Y$3=4,G16/G8)","v":false},4,{"$f":"IF(Y7=0,\"\",IF(Z6=Y7,\"nitrogen content\",IF(AA6=Y7,\"phosphorus content\",IF(AB6=Y7,\"potassium content\",\"FALSE\"))))","v":"FALSE"}]
[null,null,null,null,"N (kg/ML)","P (kg/ML)","K (kg/ML)",null,null,null,null,"Effluent - 2nd pond:","N (kg/ML)","P (kg/ML)","K (kg/ML)",null,null,null,null,null,null,null,null,null,{"$f":"MIN(Z3:AB6)","v":0.10118043844856661}]
[null,null,null,"Nutrient concentrations:",{"$f":"LOOKUP($Y$10,W22:W24,X22:X24)","v":957},{"$f":"LOOKUP($Y$10,W22:W24,Y22:Y24)","v":239},{"$f":"LOOKUP($Y$10,W22:W24,Z22:Z24)","v":593},null,null,null,null,null,196,47,364,null,null,null,null,null,"Southwest Victoria"]
[null,null,null,"Source:",{"$f":"LOOKUP(Y10,W22:W24,AA22:AA24)","v":"Southwest Victoria"},null,null,null,null,null,null,null,286,107,474,null,null,null,null,null,"Gippsland",null,"OB step 1 TF",null,true,false,false]
[null,null,{"$f":"IF(E9=\"OWN DATA\",\"\",\"       Note: 'typical' data masks significant variation from farm to farm; test your own material!\")","v":"       Note: 'typical' data masks significant variation from farm to farm; test your own material!"},null,null,null,null,null,null,null,null,null,175,22,85,null,null,null,null,null,"SE Qld",null,"OB step 1",null,{"$f":"IF(Y9=TRUE,1,IF(Z9=TRUE,2,IF(AA9=TRUE,3)))","v":1}]
[null,3,"   Set a nutrient application limit",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y10=2,IF(Y14=4,\"<-- ENTER OWN DATA HERE\",\"\"),\"\")","v":""},null,null,null,null,"OWN DATA",null,"OB step 2_1 TF",null,true,false,false,null,null,"Conditional test:"]
[null,null,"    Refer to Fert$mart for further info; no more than 60 kg N/ha per application is recommended.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OB step 2_1",null,{"$f":"IF(Y11=TRUE,1,IF(Z11=TRUE,2,IF(AA11=TRUE,3)))","v":1},null,null,null,null,{"$f":"IF($Y$10=1,IF(Y12=3,TRUE,FALSE))","v":false}]
[null,null,"           No more than 60 kg K/ha per application (or 120 kg K/ha per annum) is recommended.",null,null,null,null,null,null,null,null,"Effluent - single pond:","N (kg/ML)","P (kg/ML)","K (kg/ML)",null,null,null,null,null,null,null,"OB step 2_2 TF",null,true,false,false,false]
[null,null,{"$f":"IF(Y3=4,\"                        Enter a maximum application for each nutrient\",\"\")","v":""},null,null,null,null,null,null,null,null,null,313,65,316,null,null,null,null,null,"Southwest Victoria",null,"OB step 2_2",null,{"$f":"IF(Y13=TRUE,1,IF(Z13=TRUE,2,IF(AA13=TRUE,3,IF(AB13=TRUE,4))))","v":1},null,null,null,null,{"$f":"IF($Y$10=2,IF(Y14=4,TRUE,FALSE))","v":false}]
[null,null,null,null,{"$f":"IF(Y3=4,\"kg N/ha\",\"\")","v":""},{"$f":"IF(Y3=4,\"kg P/ha\",\"\")","v":""},{"$f":"IF(Y3=4,\"kg K/ha\",\"\")","v":""},null,null,null,null,null,429,113,479,null,null,null,null,null,"Gippsland",null,"OB step 2_3 TF",null,true,false,false,false,false]
[null,null,null,{"$f":"IF(Y3=4,\"Your limits\",\"\")","v":""},null,null,null,null,null,null,null,null,311,86,361,null,null,null,null,null,"Northern Victoria",null,"OB step 2_3",null,{"$f":"IF(Y15=TRUE,1,IF(Z15=TRUE,2,IF(AA15=TRUE,3,IF(AB15=TRUE,4,IF(AC15=TRUE,5)))))","v":1},null,null,null,null,{"$f":"IF($Y$10=3,IF(Y16=5,TRUE,FALSE))","v":false}]
[null,null,null,null,null,{"$f":"IF(Y3>=3,\"Your application rate will be limited by:\",\"\")","v":"Your application rate will be limited by:"},{"$f":"IF(Y3>=3,LOOKUP(Y3,AC3:AC6,AD3:AD6),\"\")","v":"potassium content"},null,null,null,null,null,220,46,394,null,null,null,null,null,"SE Qld"]
[null,4,"   Set a value for nutrients",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y10=3,IF(Y16=5,\"<-- ENTER OWN DATA HERE\",\"\"),\"\")","v":""},null,null,null,null,"OWN DATA",null,null,null,null,null,null,1,"Sludge"]
[null,null,null,null,null,null,"Dial in the current cost of fertiliser    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Effluent - second pond"]
[null,null,null,null,"N ($/kg)","P ($/kg)","K ($/kg)",600,"          Urea ($/t) 46% N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Effluent - single pond (supernatant)"]
[null,null,null,null,{"$f":"H20/0.46/1000","v":1.3043478260869565},{"$f":"H21/0.088/1000","v":3.9772727272727275},{"$f":"H22/0.5/1000","v":1.4},350,"          Single super ($/t) 8.8% P"]
[null,null,null,null,null,null,null,700,"          Potash ($/t) 50% K",null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"LOOKUP($Y$12,AB22:AB24,AC22:AC24)","v":957},{"$f":"LOOKUP($Y$12,AB22:AB24,AD22:AD24)","v":239},{"$f":"LOOKUP($Y$12,AB22:AB24,AE22:AE24)","v":593},{"$f":"LOOKUP($Y$12,AB22:AB24,U3:U5)","v":"Southwest Victoria"},1,{"$f":"M3","v":957},239,593]
[null,5,"   Application summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"LOOKUP($Y$14,AB25:AB28,AC25:AC28)","v":196},{"$f":"LOOKUP($Y$14,AB25:AB28,AD25:AD28)","v":47},{"$f":"LOOKUP($Y$14,AB25:AB28,AE25:AE28)","v":364},{"$f":"LOOKUP($Y$14,AB25:AB28,U8:U11)","v":"Southwest Victoria"},2,1893,612,934]
[null,null,"Target effluent/sludge application rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"LOOKUP($Y$16,AB29:AB33,AC29:AC33)","v":313},{"$f":"LOOKUP($Y$16,AB29:AB33,AD29:AD33)","v":65},{"$f":"LOOKUP($Y$16,AB29:AB33,AE29:AE33)","v":316},{"$f":"LOOKUP($Y$16,AB29:AB33,U14:U18)","v":"Southwest Victoria"},3,0,0,0]
[null,null,null,{"$f":"Y7","v":0.10118043844856661},"ML/ha",{"$f":"IF(E28>D39,\"Warning! N application rate exceeds 60 kg/ha\",IF(G28>D40,\"Warning! K application rate exceeds 60 kg/ha\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"M8","v":196},47,364]
[null,null,"OR",{"$f":"D25*100","v":10.118043844856661},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,286,107,474]
[null,null,null,"Nutrients applied:","N (kg/ha)","P (kg/ha)","K (kg/ha)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,175,22,85]
[null,null,null,null,{"$f":"IF(Y10=1,$D$25*E8*D38,D25*E8)","v":38.731871838111303},{"$f":"$D$25*F8","v":24.182124789207421},{"$f":"$D$25*G8","v":60},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,0]
[null,null,null,null,{"$f":"IF(Y10=1,\"Based on 40% N availability in the year of application\",\"\")","v":"Based on 40% N availability in the year of application"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"M14","v":313},65,316]
[null,null,null,"Value of nutrients:","N ($/ML)","P ($/ML)","K ($/ML)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,429,113,479]
[null,null,null,null,{"$f":"E21*E8","v":1248.2608695652175},{"$f":"F21*F8","v":950.56818181818187},{"$f":"G21*G8","v":830.19999999999993},"Total",{"$f":"SUM(E31:G31)","v":3029.0290513833993},"$/ML",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,311,86,361]
[null,null,null,null,{"$f":"IF(Y10=1,\"N value taken over 3+ years\",\"\")","v":"N value taken over 3+ years"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,220,46,394]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,0]
[]
[]
[]
[]
[null,null,"Mineralistion",0.4]
[null,null,"N limit",60]
[null,null,"K limit",60]