{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ReadMe-Orientation","single pen","Manure Excretion Estimates","Crop Requirements","Bedding Estimates"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":1,"defined_names":65,"comments":1,"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":"ReadMe-Orientation","index":0,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,3,5]]}
[]
[]
["Manure Balance Tool"]
[]
["Description of this tool"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Author","Dennis Buckmaster, Professor & Dean's Fellow for Digital Agriculture and Tamilee Nennich, former Purdue faculty"]
["Affiliation","Purdue University, Department of Agricultural & Biological Engineering and Animal Sciences"]
["Date","Updated December, 2021"]
["URL to acquire","https://engineering.purdue.edu/~dbuckmas/outreach/Manure_Balance_Tool.xlsm"]
["Related tools:","Fertilizer Tools",null,"https://engineering.purdue.edu/~dbuckmas/outreach/Fertilizer_tools.xlsx"]
[null,"Manure Records",null,"https://docs.google.com/spreadsheets/d/11MEMOHU-8uQVqdlFJPyIG5cn6ZEOYxCiEzqY7ohBqak/edit?usp=sharing"]

{"sheet":"single pen","index":1,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[[42,2,42,3]]}
[null,"INPUT SECTION : ANIMALS AND CROPS"]
[null,"Select an animal from the drop down menu"]
["at","animal type",3]
["n","Number of animals",2]
["mcp","Manure collection period",365,"days/year"]
[null,"Select the bedding used from the menu"]
["bt","bedding type",4]
["ab","Amount of bedding used per animal",2,"tons/year/animal"]
["a","Total crop area",2,"acres"]
["eyg","Expected yield on grassland",3,"tons hay/acre"]
["eyc","Expected yield on corn",150,"bu/acre"]
["eys","Expected yield on soybeans",40,"bu/acre"]
["pg","Percentage of land area in grassland",100,"%"]
["pc","Percentage of land area in corn",0,"%"]
[null,"OUTPUT SECTION"]
["ps","Percentage of land area in soybeans",{"$f":"100-C14-C13","v":0},"%",{"$f":"IF(C14+C13>100,\"Land area percentages cannot exceed 100%\",\"\")","v":""}]
[null,"Manure Nutrient Production"]
["Np","Nitrogen production",{"$f":"n*VLOOKUP(at,animals,4)*mcp + ab*n*VLOOKUP(bt,bedding,4)","v":262.41830065359477},"lb/year"]
["Pp","Phosphorus (P2O5) production",{"$f":"n*VLOOKUP(at,animals,5)*mcp + ab*n*VLOOKUP(bt,bedding,5)","v":79.760849673202614},"lb/year"]
["Mp","Total manure and bedding produced",{"$f":"((n*VLOOKUP(at,animals,3)*mcp)/62)*0.037037 + (ab*n/VLOOKUP(bt,bedding,3))*2000","v":30.598639890364751},"yd3/year"]
[]
[null,"Crop Nutrient Demand"]
["Ndg","nitrogen demand for grassland",{"$f":"eyg*VLOOKUP(1,crops,3)","v":120},"lb/acre/year"]
["Pdg","phosphorus demand for grassland",{"$f":"eyg*VLOOKUP(1,crops,4)","v":39},"lb/acre/year"]
["Ndc","nitrogen demand for corn",{"$f":"eyc*VLOOKUP(2,crops,3)","v":135},"lb/acre/year"]
["Pdc","phosphorus demand for corn",{"$f":"eyc*VLOOKUP(2,crops,4)","v":55.5},"lb/acre/year"]
["Nds","nitrogen demand for soybeans",{"$f":"eys*VLOOKUP(3,crops,3)","v":152},"lb/acre/year"]
["Pds","phosphorus demand for soybeans",{"$f":"eys*VLOOKUP(3,crops,4)","v":32},"lb/acre/year"]
[]
["Ndmt","nitrogen demand for current crop mix",{"$f":"a*(pg*Ndg+pc*Ndc+ps*Nds)/100","v":240},"lb/year"]
["Pdmt","phosphorus demand for current crop mix",{"$f":"a*(pg*Pdg+pc*Pdc+ps*Pds)/100","v":78},"lb/year"]
["Ndgt","nitrogen demand for all grassland",{"$f":"a*Ndg","v":240},"lb/year"]
["Pdgt","phosphorus demand for all grassland",{"$f":"a*Pdg","v":78},"lb/year"]
["Ndct","nitrogen demand for all corn",{"$f":"a*Ndc","v":270},"lb/year"]
["Pcdt","phosphorus demand for all corn",{"$f":"a*Pdc","v":111},"lb/year"]
["Ndst","nitrogen demand for all soybeans",{"$f":"a*Nds","v":304},"lb/year"]
["Pdst","phosphorus demand for all soybeans",{"$f":"a*Pds","v":64},"lb/year"]
[]
["Ne","nitrogen difference",{"$f":"Np-Ndmt","v":22.41830065359477},"lb/year"]
["Pe","phosphorus difference",{"$f":"Pp-Pdmt","v":1.760849673202614},"lb/year"]
["Me","maximum difference",{"$f":"MAX(Ne,Pe)","v":22.41830065359477},"lb/year"]
[]
[null,"Your land area is",{"$f":"IF(C41<=0,\"SUFFICIENT\", \"NOT SUFFICIENT\")","v":"NOT SUFFICIENT"},null,"to deal with the nutrients produced."]
[]
[null,"Nitrogen"]
[null,"Phosphorus"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Manure Nutrient Checker by Nennich and Buckmaster, Purdue University, February 2014."]
[null,"Downloaded from : https://engineering.purdue.edu/~dbuckmas/outreach/Manure_Balance_Tool.xlsm"]

{"sheet":"Manure Excretion Estimates","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5]
[null,null,"Total Manure","Nitrogen","P2O5","Phosphorus"]
[null,null,"lb/animal/d","lb/animal/d","lb/animal/d","lb/animal/d"]
[1,"Beef - Cow",70,0.42,{"$f":"F4*2.29","v":0.22213000000000002},9.7000000000000003E-2]
[2,"Beef - Cow/Calf pair",83,0.49,{"$f":"F5*2.29","v":0.27212999999999998},0.11883406113537118]
[3,"Beef - Steer",64.052287581699346,0.35947712418300654,0.10926143790849673,4.7712418300653592E-2]
[4,"Beef - Veal",7.8,3.3000000000000002E-2,2.2671000000000004E-2,9.9000000000000008E-3]
[5,"Dairy - Calf",19,0.14000000000000001,5.0380000000000001E-2,2.1999999999999999E-2]
[6,"Dairy - Cow",150,0.99,0.38930000000000003,0.17]
[7,"Dairy - Dry cow",83,0.5,0.15114,6.6000000000000003E-2]
[8,"Dairy - Heifer",48,0.26,0.10076,4.3999999999999997E-2]
[9,"Goats",3.2,3.2000000000000001E-2,1.8319999999999999E-2,8.0000000000000002E-3]
[10,"Horse - Intense exercise",57,0.34,0.16716999999999999,7.2999999999999995E-2]
[11,"Horse - Sedentary",56,0.2,6.6410000000000011E-2,2.9000000000000001E-2]
[12,"Poultry - Broiler",0.22916666666666666,2.5000000000000001E-3,1.6697916666666669E-3,7.291666666666667E-4]
[13,"Poultry - Duck",0.35897435897435898,3.5897435897435902E-3,2.8184615384615388E-3,1.2307692307692308E-3]
[14,"Poultry - Layer",0.19,3.5000000000000001E-3,2.5190000000000004E-3,1.1000000000000001E-3]
[15,"Poultry - Turkey (females)",0.3619047619047619,5.4285714285714284E-3,3.4895238095238095E-3,1.5238095238095239E-3]
[16,"Poultry - Turkey (males)",0.5864661654135338,9.0225563909774424E-3,6.1984962406015035E-3,2.7067669172932329E-3]
[17,"Sheep",4,0.04,2.29E-2,0.01]
[18,"Swine - Boar",8.4,6.0999999999999999E-2,4.8090000000000001E-2,2.1000000000000001E-2]
[19,"Swine - Finishing pig",10,8.3333333333333329E-2,3.2441666666666667E-2,1.4166666666666666E-2]
[20,"Swine - Gestating sow",11,7.0999999999999994E-2,4.58E-2,0.02]
[21,"Swine - Lactating sow",25,0.19,0.12595000000000001,5.5E-2]
[22,"Swine - Nursery pig",2.4166666666666665,2.5277777777777777E-2,9.541666666666667E-3,4.1666666666666666E-3]

{"sheet":"Crop Requirements","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5]
[null,"Crop Type","Nitrogen","P2O5"]
[null,null,"lb removed/unit yield","lb removed/unit yield","yield unit"]
[1,"Pasture/Forage/Grassland",40,13,"tons hay equivalent/acre"]
[2,"Corn",0.9,0.37,"bu/acre"]
[3,"Soybeans",3.8,0.8,"bu/acre"]

{"sheet":"Bedding Estimates","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[1,2,3,4,5]
[null,"Bedding Type","Density","Nitrogen","P2O5"]
[null,null,"lbs/yd3","lb/ton","lb/ton"]
[1,"Straw",{"$f":"(190+1700)/2","v":945},13,3.3]
[2,"Sawdust",{"$f":"(540+1700)/2","v":1120},5,0.4]
[3,"Corn stalks",{"$f":"(215+1700)/2","v":957.5},22,8.1999999999999993]
[4,"Sand",3000,0,0]