{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["P19","Sheet2","Sheet3"],"not_rendered":{"charts":2,"images":11,"macros":1,"external_links":0,"defined_names":49,"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":"P19","index":0,"n_rows":67,"n_cols":34,"rows_kept":67,"cut":false,"hidden":false,"merged":[[34,8,34,9],[31,30,46,34]]}
["Model calculations for the MULTIPLICATIVE model estimated by SAS"]
[]
["Parameter estimates:",null,null,null,null,null,null,"Example variable values:"]
[]
[null,null,"Approx"]
["Parameter","Estimate","Std Error","Approximate 95% Confidence Limits",null,null,null,"Variable","Value"]
["b_Nmx0",-6.5757000000000003,1.046,-8.6270000000000007,-4.5244999999999997,null,null,"I_SM1",{"$f":"IF(P7,1,0)","v":0},null,"= 1 if SoilMoist = 1 (SoilMoist = 2 is ref.)",null,null,null,null,false]
["b_sm1Nmx",9.7100000000000006E-2,3.5499999999999997E-2,2.75E-2,0.16669999999999999,null,null,"AirTemp",{"$f":"P8-6","v":20},null,null,null,null,null,null,26]
["b_atNmx",2.2100000000000002E-2,2.4499999999999999E-3,1.7299999999999999E-2,2.69E-2,null,null,"WindSpeed",9]
["b_wsNmx",4.0899999999999999E-2,1.1900000000000001E-2,1.7600000000000001E-2,6.4100000000000004E-2,null,null,"I_MT1",{"$f":"IF(P10,1,0)","v":0},null,"= 1 if ManureType = 1 (ManureType = 2 is ref.)",null,null,null,null,false]
["b_mt1Nmx",-0.156,5.1799999999999999E-2,-0.25750000000000001,-5.45E-2,null,null,"ManureDM",8]
["b_mdmNmx",0.1024,9.8499999999999994E-3,8.3099999999999993E-2,0.1217,null,null,"ManureTAN",{"$f":"P12/10","v":3.2},null,null,null,null,null,null,32]
["b_mtanNmx",-0.1888,2.6499999999999999E-2,-0.2407,-0.1368,null,null,"I_MA0",{"$f":"IF(P13=1,1,0)","v":0},null,"= 1 if ManureAppl = 0 (ManureAppl = 5 is ref.)",null,null,null,null,2]
["b_ma0Nmx",3.5691000000000002,0.4506,2.6854,4.4527999999999999,null,null,"I_MA1",{"$f":"IF(P13=2,1,0)","v":1},null,"= 1 if ManureAppl = 1 (ManureAppl = 5 is ref.)"]
["b_ma1Nmx",3.0198,0.45540000000000003,2.1265999999999998,3.9129,null,null,"I_MA2",{"$f":"IF(P13=3,1,0)","v":0},null,"= 1 if ManureAppl = 2 (ManureAppl = 5 is ref.)"]
["b_ma2Nmx",3.1591999999999998,0.65439999999999998,1.8758999999999999,4.4424999999999999,null,null,"I_MA3",{"$f":"IF(P13=4,1,0)","v":0},null,"= 1 if ManureAppl = 3 (ManureAppl = 5 is ref.)"]
["b_ma3Nmx",2.2702,0.47839999999999999,1.3320000000000001,3.2084000000000001,null,null,"I_MA4",{"$f":"IF(P13=5,1,0)","v":0},null,"= 1 if ManureAppl = 4 (ManureAppl = 5 is ref.)"]
["b_ma4Nmx",2.9582000000000002,0.51939999999999997,1.9396,3.9767999999999999,null,null,"ManureRate",40]
["b_mrNmx",-4.3299999999999996E-3,1.2700000000000001E-3,-6.8199999999999997E-3,-1.8400000000000001E-3,null,null,"I_MI0",{"$f":"IF(P19,1,0)","v":1},null,"= 1 if ManureInc = 0 (ManureInc = 2 is ref.)",null,null,null,null,true]
["b_mi0Nmx",2.4291,0.94199999999999995,0.58179999999999998,4.2765000000000004,null,null,"I_MeT1",{"$f":"IF(P20=1,1,0)","v":1},null,"= 1 if MeasTech = 1 (MeasTech = 3 is ref.)",null,null,null,null,1]
["b_met1Nmx",-0.63819999999999999,9.7699999999999995E-2,-0.82979999999999998,-0.4466,null,null,"I_MeT2",{"$f":"IF(P20=2,1,0)","v":0},null,"= 1 if MeasTech = 2 (MeasTech = 3 is ref.)"]
["b_met2Nmx",-0.54849999999999999,0.10539999999999999,-0.75529999999999997,-0.34179999999999999,null,null,"t",0]
["b_Km0",3.6999999999999998E-2,0.27400000000000002,-0.50039999999999996,0.57430000000000003,null,null,"dt",6]
["b_sm1Km",9.74E-2,6.6600000000000006E-2,-3.3099999999999997E-2,0.22800000000000001]
["b_atKm",-4.0899999999999999E-2,4.6699999999999997E-3,-5.0099999999999999E-2,-3.1800000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil moisture"]
["b_wsKm",-5.1700000000000003E-2,2.0299999999999999E-2,-9.1399999999999995E-2,-1.2E-2,null,null,"Results:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nmax",{"$f":"100*Nmax","v":40.129438252524615},"%"]
["b_mt1Km",1.3567,0.1018,1.1571,1.5563,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry","Wet"]
["b_mdmKm",0.16139999999999999,1.8100000000000002E-2,0.1258,0.19689999999999999,null,null,"Nmax",{"$f":"EXP(b_Nmx0 + b_sm1Nmx*I_SM1 + b_atNmx*AirTemp + b_wsNmx*WindSpeed + b_mt1Nmx*I_MT1 + b_mdmNmx*ManureDM + b_mtanNmx*ManureTAN + b_ma0Nmx*I_MA0 + b_ma1Nmx*I_MA1 + b_ma2Nmx*I_MA2 + b_ma3Nmx*I_MA3 + b_ma4Nmx*I_MA4 + b_mrNmx*ManureRate + b_mi0Nmx*I_MI0 + b_met1Nmx*I_MeT1 + b_met2Nmx*I_MeT2)","v":0.40129438252524613},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Km",{"$f":"Km","v":4.2940055845370377},"h"]
["b_mtanKm",0.1011,4.9500000000000002E-2,4.0200000000000001E-3,0.1981,null,null,"Km",{"$f":" EXP(b_Km0 + b_sm1Km*I_SM1 + b_atKm*AirTemp + b_wsKm*WindSpeed + b_mt1Km*I_MT1 + b_mdmKm*ManureDM + b_mtanKm*ManureTAN + b_ma0Km*I_MA0 + b_ma1Km*I_MA1 + b_ma2Km*I_MA2 + b_ma3Km*I_MA3 + b_ma4Km*I_MA4 + b_mrKm*ManureRate + b_mi0Km*I_MI0 + b_met1Km*I_MeT1 + b_met2Km*I_MeT2)","v":4.2940055845370377}]
["b_ma0Km",0,"Not estimated, fixed to zero due to insignificance",null,null,null,null,"Rel. Loss Rate",{"$f":"Nmax*Km/(22:22 + Km)/(22:22 +23:23  + Km)","v":3.8983307249030791E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air temperature"]
["b_ma1Km",0,"Not estimated, fixed to zero due to insignificance",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,{"$f":"I8","v":20},"°C"]
["b_ma2Km",0,"Not estimated, fixed to zero due to insignificance",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,"This is a prototype model presented at the NJF Seminar \"Sustainable Handling and Utilization of Livestock Manure from Animals to Plants\", Horsens, DK, 16-19 January 2001 by H.T. Søgaard et al. The model can be used freely without any charge but the authors disclaim all responsibility for the results derived by the model."]
["b_ma3Km",0,"Not estimated, fixed to zero due to insignificance",null,null,null,null,"Cumlated relative loss:"]
["b_ma4Km",0,"Not estimated, fixed to zero due to insignificance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wind speed"]
["b_mrKm",1.7500000000000002E-2,2.5000000000000001E-3,1.26E-2,2.24E-2,null,null,null,"Cumulated Loss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I9","v":9},"m/s"]
["b_mi0Km",0,"Not estimated, fixed to zero due to insignificance",null,null,null,null,"Time","Relative","Absolute"]
["b_met1Km",0.38879999999999998,0.17610000000000001,4.3400000000000001E-2,0.73429999999999995,null,null,0,{"$f":"100*Nmax*H$37:H$65536/(H$37:H$65536+Km)","v":0},{"$f":"ManureTAN*ManureRate*I37/100","v":0}]
["b_met2Km",0.70240000000000002,0.19220000000000001,0.3256,1.0792999999999999,null,null,1,7.5801654553853188,{"$f":"ManureTAN*ManureRate*I38/100","v":9.7026117828932072},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slurry type"]
[null,null,null,null,null,null,null,2,12.751637320155437,16.32209576979896]
[null,null,null,null,null,null,null,3,16.505103178532195,21.126532068521211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cattle","Pig"]
[null,null,null,null,null,null,null,4,19.35346574993395,24.772436159915454]
[null,null,null,null,null,null,null,6,23.389984349418476,29.939179967255651]
[null,null,null,null,null,null,null,8,26.113173921442165,33.424862619445975,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM%"]
[null,null,null,null,null,null,null,10,28.074312700658112,35.935120256842382,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I11","v":8},"%"]
[null,null,null,null,null,null,null,15,31.19837252821614,39.933916836116659]
[null,null,null,null,null,null,null,20,33.036493807399729,42.286712073471655]
[null,null,null,null,null,null,null,30,35.104769100479821,44.934104448614171,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAN"]
[null,null,null,null,null,null,null,40,36.23915942841144,46.386124068366641,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I12","v":3.2},"g N/kg"]
[null,null,null,null,null,null,null,50,36.955680300693729,47.303270784887971]
[null,null,null,null,null,null,null,75,37.956310149203297,48.584076990980222]
[null,null,null,null,null,null,null,100,38.477224100858905,49.250846849099396,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application technique"]
[null,null,null,null,null,null,null,150,39.012635099298649,49.93617292710227]
[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,{"$f":"IF(P13=1,\"Broad spread\",IF(P13=2,\"Band spread/trailing hose\",IF(P13=3,\"Trailing shoe\",IF(P13=4,\"Open slot\", IF(P13=5,\"Closed slot\",\"Pressurised injection\")))))","v":"Band spread/trailing hose"}]
[]
[null,null,null,null,null,null,null,"Nmax ref line"]
[null,null,null,null,null,null,null,0,{"$f":"100*Nmax","v":40.129438252524615},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application rate"]
[null,null,null,null,null,null,null,150,{"$f":"100*Nmax","v":40.129438252524615},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I18","v":40},"t/ha"]
[]
[null,null,null,null,null,null,null,"Km ref lines"]
[null,null,null,null,null,null,null,0,{"$f":"50*Nmax","v":20.064719126262307},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slurry incorporation"]
[null,null,null,null,null,null,null,{"$f":"Km","v":4.2940055845370377},{"$f":"50*Nmax","v":20.064719126262307}]
[null,null,null,null,null,null,null,{"$f":"Km","v":4.2940055845370377},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Shallow cultivation"]
[]
[]
[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,"Measuring technique"]
[]
[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,{"$f":"IF(P20=1,\"Wind tunnel\",IF(P20=2,\"Micromet. mass balance\",\"Lennart boxes (dyn. chambers)\"))","v":"Wind tunnel"}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}