{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Supplement","Equipment","Results"],"not_rendered":{"charts":1,"images":10,"macros":1,"external_links":3,"defined_names":68,"comments":3,"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":"Instructions","index":0,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[[48,1,48,3],[48,10,48,12],[52,1,53,11],[54,1,55,11],[30,1,30,4],[32,1,36,11],[37,1,39,11],[42,1,43,3],[42,10,43,13],[47,19,47,20],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[28,1,29,11]]}
[]
[]
[null,"KSU-Cattle Supplementation Cost"]
[]
[null,"An Excel spreadsheet to evaluate the total costs of various protein supplement programs for cow/calf and stocker producers"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 6.29.2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"The beef cattle supplement cost spreadsheet program was developed to assist the user in evaluating up to four supplement programs simultaneously from a total supplement cost basis. Program options can be modified to account for the diversity in cattle management and supplements found throughout the United States."]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly."]
[null,"In the Supplement and Equipment tabs, blue shaded numbers are inputs and all other numbers are calculated from these inputs.  The spreadsheet automatically recalculates every time an additional input is entered.  Thus, it is important to wait until all data have been entered and reviewed before interpreting any of the calculated results (i.e., black numbers)."]
[]
[]
[]
[]
[null,"Several of the input cells and calculated values have a red diamond in the upper right hand corner of the cell (if the comments do not appear go to View / Comments on the Excel menu -- you may need to click and then again).  By moving your mouse cursor over this diamond, a brief description of the input will be displayed on the screen.  "]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"With Questions Contact:"]
[]
[null,"Dustin L. Pendell, Ph.D.",null,null,null,null,"Dale Blasi, Ph.D."]
[null,"Agricultural Economist",null,null,null,null,"Extension Animal Scientist"]
[null,"Department of Agricultural Economics",null,null,null,null,"Department of Animal Science"]
[null,"Kansas State University",null,null,null,null,"Kansas State University"]
[null,"dpendell@k-state.edu",null,null,null,null,"dblasi@k-state.edu"]
[null,"785-532-3525",null,null,null,null,"785-532-5427"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"This spreadsheet was originally developed by Kevin Dhuyvetter, Ph.D., former Agricultural Economist, Kanasas State University, Craig Smith, former Graduate Research Assistant, Kansas State University, and Dale Blasi."]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Supplement","index":1,"n_rows":163,"n_cols":7,"rows_kept":163,"cut":false,"hidden":false,"merged":[[37,1,38,1],[140,2,140,5]]}
[]
[null,"Evaluation of total costs of various protein supplement programs"]
[]
[null,"Section A: Operation characteristics -- INPUTS"]
[null,"Description/name of group","Cows (7X)"]
[null,"Number of head",100]
[null,"Feeding duration, days",90]
[null,"Roundtrip distance to feed, miles",5]
[null,"Labor cost, $/hour",20]
[null,"Pickup/truck cost, $/mile",0.54]
[null,"Tractor cost, $/hour",20]
[null,"Interest rate for analysis, %",0.05]
[]
[null,"Section B: Supplement characteristics and delivery options -- INPUTS"]
[null,"Supplement delivery options ","Custom mix","Comm. Cubes","Self fed","Forage"]
[null,"Nutrient concentration"]
[null,"Dry matter, %",0.87,0.9,0.98,0.87]
[null,"Crude protein (CP), %",0.2,0.38,0.4,0.13]
[null,"CP equivalent from NPN, %",0,0,0.2,0]
[null,"NPN utilization level, %",0.15,0.15,0.15,0.15]
[null,"Total Digestible Nutrient (TDN), %",0.75,0.7,0.7,0.55000000000000004]
[null,"Phosphorus, %",2.5000000000000001E-3,0.01,0.01,2.5000000000000001E-3]
[null,"Supplement cost, $/ton",175,390,475,105]
[null,"Adjusted crude protein, %",{"$f":"IF(C18=0,\"\",(C18-C19)+IF(C19/C18>=C20,C20*C18,C19)+IF(C19/C18>=C20,(C19-C20*C18)*0.5,0))","v":0.2},{"$f":"IF(D18=0,\"\",(D18-D19)+IF(D19/D18>=D20,D20*D18,D19)+IF(D19/D18>=D20,(D19-D20*D18)*0.5,0))","v":0.38},{"$f":"IF(E18=0,\"\",(E18-E19)+IF(E19/E18>=E20,E20*E18,E19)+IF(E19/E18>=E20,(E19-E20*E18)*0.5,0))","v":0.33},{"$f":"IF(F18=0,\"\",(F18-F19)+IF(F19/F18>=F20,F20*F18,F19)+IF(F19/F18>=F20,(F19-F20*F18)*0.5,0))","v":0.13}]
[null,"Cost/pound of crude protein (adj), $/lb",{"$f":"IF(C18=0,\"\",C23/2000/(C24))","v":0.43749999999999994},{"$f":"IF(D18=0,\"\",D23/2000/(D24))","v":0.51315789473684215},{"$f":"IF(E18=0,\"\",E23/2000/(E24))","v":0.71969696969696961},{"$f":"IF(F18=0,\"\",F23/2000/(F24))","v":0.4038461538461538}]
[]
[null,"Section C: Supplement feeding characteristics -- INPUTS"]
[null,"Supplement delivery options ",{"$f":"C15","v":"Custom mix"},{"$f":"D15","v":"Comm. Cubes"},{"$f":"E15","v":"Self fed"},{"$f":"F15","v":"Forage"}]
[null,"(AF = As fed, DM = Dry matter)"]
[null,"Supplement provided (AF), lbs/hd/day",5.86,2.98,3.11,10.4]
[null,"Estimated wastage, %",0.02,0.02,0.02,0.15]
[null,"Feeding frequency, times/week",7,7,7,7]
[null,"Required/hd/feeding (AF), lbs",{"$f":"IF(AND(C$18>0,C30>0),C30*7/C32,\"    N/A\")","v":5.86},{"$f":"IF(AND(D$18>0,D30>0),D30*7/D32,\"    N/A\")","v":2.98},{"$f":"IF(AND(E$18>0,E30>0),E30*7/E32,\"    N/A\")","v":3.11},{"$f":"IF(AND(F$18>0,F30>0),F30*7/F32,\"    N/A\")","v":10.4}]
[null,"Total required/feeding (AF), lbs",{"$f":"IF(AND(C$18>0,C30>0),C30*7/C32*Supplement!$C$6,\"    N/A\")","v":586},{"$f":"IF(AND(D$18>0,D30>0),D30*7/D32*Supplement!$C$6,\"    N/A\")","v":298},{"$f":"IF(AND(E$18>0,E30>0),E30*7/E32*Supplement!$C$6,\"    N/A\")","v":311},{"$f":"IF(AND(F$18>0,F30>0),F30*7/F32*Supplement!$C$6,\"    N/A\")","v":1040}]
[null,"CP provided (DM), lbs/hd/day",{"$f":"IF(AND(C$18,C30>0),C30*C$24*C$17*(1-C31),\"    N/A\")","v":0.99924720000000011},{"$f":"IF(AND(D$18,D30>0),D30*D$24*D$17*(1-D31),\"    N/A\")","v":0.99877680000000002},{"$f":"IF(AND(E$18,E30>0),E30*E$24*E$17*(1-E31),\"    N/A\")","v":0.98565851999999998},{"$f":"IF(AND(F$18,F30>0),F30*F$24*F$17*(1-F31),\"    N/A\")","v":0.99980400000000014}]
[null,"Time to supplement, hours/roundtrip",2,1.5,1.5,2.25]
[null,"Tractor time, hours/feeding",0,0,0,0]
[null,"Select type of equipment used"]
[]
[]
[null,"Table 1: Feeding equipment used by delivery option"]
[null,null,{"$f":"C28","v":"Custom mix"},{"$f":"D28","v":"Comm. Cubes"},{"$f":"E28","v":"Self fed"},{"$f":"F28","v":"Forage"}]
[null,{"$f":"B156","v":"Cake box"},{"$f":"C156","v":1},{"$f":"D156","v":1},{"$f":"E156","v":0},{"$f":"F156","v":0}]
[null,{"$f":"B157","v":"Feed bunks"},{"$f":"C157","v":0},0,1,0]
[null,"Bale feeders",0,0,0,1]
[null,"Storage bins",1,1,0,0]
[null,"Rented self feeder",0,0,0,0]
[null,"N/A",0,0,0,0]
[null,"N/A",0,0,0,0]
[null,"N/A",0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DO NOT MODIFY ANYTHING BELOW THIS ROW"]
[]
[null,"Equipment choices:","These are stored as text, table below contains numbers."]
[null,null,"Custom mix",{"$f":"D28","v":"Comm. Cubes"},{"$f":"E28","v":"Self fed"},{"$f":"F28","v":"Forage"}]
[null,{"$f":"IF(Equipment!B6=\"\",\"N/A\",Equipment!B6)","v":"Cake box"},"1","1","0","0",""]
[null,{"$f":"IF(Equipment!B7=\"\",\"N/A\",Equipment!B7)","v":"Feed bunks"},"0","0","1","0",""]
[null,{"$f":"IF(Equipment!B8=\"\",\"N/A\",Equipment!B8)","v":"Bale feeders"},"0","0","0","1",""]
[null,{"$f":"IF(Equipment!B9=\"\",\"N/A\",Equipment!B9)","v":"Storage bins"},"1","1","0","0",""]
[null,{"$f":"IF(Equipment!B10=\"\",\"N/A\",Equipment!B10)","v":"Rented self feeder"},"0","0","0","0",""]
[null,{"$f":"IF(Equipment!B11=\"\",\"N/A\",Equipment!B11)","v":"N/A"},"0","0","0","0",""]
[null,{"$f":"IF(Equipment!B12=\"\",\"N/A\",Equipment!B12)","v":"N/A"},"0","0","0","0",""]
[null,{"$f":"IF(Equipment!B13=\"\",\"N/A\",Equipment!B13)","v":"N/A"},"0","0","0","0",""]
[null,null,null,""]
[null,"Select all types of equipment that apply: If a specific type of equipment is not listed it can be entered in the \"Equipment\" sheet."]
[]
[]
[null,null,{"$f":"C142","v":"Custom mix"},{"$f":"D142","v":"Comm. Cubes"},{"$f":"E142","v":"Self fed"},{"$f":"F142","v":"Forage"}]
[null,{"$f":"B143","v":"Cake box"},{"$f":"IF(C143=\"\",0,C143+0)","v":1},1,0,0]
[null,"Feed bunks",0,0,1,0]
[null,"Bale feeders",0,0,0,1]
[null,"Storage bins",1,1,0,0]
[null,"Rented self feeder",0,0,0,0]
[null,"N/A",0,0,0,0]
[null,"N/A",0,0,0,0]
[null,"N/A",0,0,0,0]

{"sheet":"Equipment","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,1,25,2],[27,1,27,2],[2,3,3,3],[15,1,15,8],[20,1,20,2],[21,1,21,2],[23,1,23,2],[24,1,24,2],[2,2,3,2],[2,8,3,8],[2,6,3,6],[2,7,3,7],[17,1,17,2],[18,1,18,2],[2,4,3,4],[2,5,3,5]]}
[]
[null,"Section D: Cost of equipment used for feeding supplement -- INPUTS"]
[null,null,"Market value","Salvage value","Useful life","Repairs       or rent","Allocate to supp.","Annual cost","Annual cost/head"]
[]
[null,"Type","($)","($)","(yrs)","($)","(%)","($)","($)"]
[null,"Cake box",3000,0,10,150,1,{"$f":"IF(SUM(C6:F6)>0,(IF(E6=0,0,(C6-D6)/E6)+(C6+D6)/2*D$14+F6)*G6,\"\")","v":525},{"$f":"IF(H6=\"\",\"\",H6/Supplement!$C$6)","v":5.25}]
[null,"Feed bunks",3500,500,10,250,0.5,{"$f":"IF(SUM(C7:F7)>0,(IF(E7=0,0,(C7-D7)/E7)+(C7+D7)/2*D$14+F7)*G7,\"\")","v":325},{"$f":"IF(H7=\"\",\"\",H7/Supplement!$C$6)","v":3.25}]
[null,"Bale feeders",5000,0,10,300,1,925,{"$f":"IF(H8=\"\",\"\",H8/Supplement!$C$6)","v":9.25}]
[null,"Storage bins",5000,0,20,0,0.5,187.5,{"$f":"IF(H9=\"\",\"\",H9/Supplement!$C$6)","v":1.875}]
[null,"Rented self feeder",0,0,0,400,1,400,{"$f":"IF(H10=\"\",\"\",H10/Supplement!$C$6)","v":4}]
[null,null,null,null,null,null,null,"",{"$f":"IF(H11=\"\",\"\",H11/Supplement!$C$6)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(H12=\"\",\"\",H12/Supplement!$C$6)","v":""}]
[null,null,null,null,null,null,null,"",{"$f":"IF(H13=\"\",\"\",H13/Supplement!$C$6)","v":""}]
[null,"Interest rate",null,{"$f":"Supplement!C12","v":0.05}]
[]
[null,"Section E: Estimated costs for vehicles used in delivering supplement -- (optional) INPUTS "]
[null,null,null,"Pickup","Truck","Tractor","Other"]
[null,"Market value",null,40000,15000,80000,0]
[null,"Salvage value",null,20000,5000,20000,0]
[]
[null,"Useful life, years",null,5,10,10,0]
[null,"Annual use, miles or hours",null,20000,5000,700,0]
[]
[null,"Taxes, insurance, & license, $",null,600,500,100,0]
[null,"Fuel and oil, $/mile or $/hour",null,0.25,0.375,35,0]
[null,"Annual repairs, $",null,200,400,1000,0]
[null,null,null,{"$f":"SUM(D18:D26)","v":80805.25},{"$f":"SUM(E18:E26)","v":25910.375},{"$f":"SUM(F18:F26)","v":101845},{"$f":"SUM(G18:G26)","v":0}]
[null,"Total cost per mile (or hour)",null,{"$f":"IF(D27>0,((D18-D19)/D21+(D18+D19)/2*$D14+D24+D26)/D22+D25,\"N/A\")","v":0.56499999999999995},{"$f":"IF(E27>0,((E18-E19)/E21+(E18+E19)/2*$D14+E24+E26)/E22+E25,\"N/A\")","v":0.85499999999999998},{"$f":"IF(F27>0,((F18-F19)/F21+(F18+F19)/2*$D14+F24+F26)/F22+F25,\"N/A\")","v":48.714285714285715},{"$f":"IF(G27>0,((G18-G19)/G21+(G18+G19)/2*$D14+G24+G26)/G22+G25,\"N/A\")","v":"N/A"}]

{"sheet":"Results","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Section F: Supplement feeding costs per head -- RESULTS"]
[null,"Supplement delivery options ",{"$f":"Supplement!C15","v":"Custom mix"},{"$f":"Supplement!D15","v":"Comm. Cubes"},{"$f":"Supplement!E15","v":"Self fed"},{"$f":"Supplement!F15","v":"Forage"}]
[null,"Supplement cost",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!C6>0),Supplement!C30*Supplement!C$23/2000*Supplement!$C$7,\"\")","v":46.147500000000001},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!C6>0),Supplement!D30*Supplement!D$23/2000*Supplement!$C$7,\"\")","v":52.299000000000007},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!C6>0),Supplement!E30*Supplement!E$23/2000*Supplement!$C$7,\"\")","v":66.476249999999993},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!C6>0),Supplement!F30*Supplement!F$23/2000*Supplement!$C$7,\"\")","v":49.14}]
[null,"Non supplement cost",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),SUM(C6:C9),\"\")","v":45.555},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),SUM(D6:D9),\"\")","v":36.555},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),SUM(E6:E9),\"\")","v":32.68},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),SUM(F6:F9),\"\")","v":52.18}]
[null,"Equipment cost",{"$f":"SUMPRODUCT(Supplement!C156:C163,Equipment!$I$6:$I$13)","v":7.125},{"$f":"SUMPRODUCT(Supplement!D156:D163,Equipment!$I$6:$I$13)","v":7.125},{"$f":"SUMPRODUCT(Supplement!E156:E163,Equipment!$I$6:$I$13)","v":3.25},{"$f":"SUMPRODUCT(Supplement!F156:F163,Equipment!$I$6:$I$13)","v":9.25}]
[null,"Labor cost",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),Supplement!C36*Supplement!C32*Supplement!$C$7/7*Supplement!$C$9/Supplement!$C$6,\"\")","v":36},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),Supplement!D36*Supplement!D32*Supplement!$C$7/7*Supplement!$C$9/Supplement!$C$6,\"\")","v":27},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),Supplement!E36*Supplement!E32*Supplement!$C$7/7*Supplement!$C$9/Supplement!$C$6,\"\")","v":27},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),Supplement!F36*Supplement!F32*Supplement!$C$7/7*Supplement!$C$9/Supplement!$C$6,\"\")","v":40.5}]
[null,"Pickup/truck cost",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),Supplement!$C$8*Supplement!C32*Supplement!$C$7/7*Supplement!$C$10/Supplement!$C$6,\"\")","v":2.4300000000000002},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),Supplement!$C$8*Supplement!D32*Supplement!$C$7/7*Supplement!$C$10/Supplement!$C$6,\"\")","v":2.4300000000000002},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),Supplement!$C$8*Supplement!E32*Supplement!$C$7/7*Supplement!$C$10/Supplement!$C$6,\"\")","v":2.4300000000000002},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),Supplement!$C$8*Supplement!F32*Supplement!$C$7/7*Supplement!$C$10/Supplement!$C$6,\"\")","v":2.4300000000000002}]
[null,"Tractor cost",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),Supplement!C37*Supplement!C32*Supplement!$C$7/7*Supplement!$C$11/Supplement!$C$6,\"\")","v":0},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),Supplement!D37*Supplement!D32*Supplement!$C$7/7*Supplement!$C$11/Supplement!$C$6,\"\")","v":0},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),Supplement!E37*Supplement!E32*Supplement!$C$7/7*Supplement!$C$11/Supplement!$C$6,\"\")","v":0},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),Supplement!F37*Supplement!F32*Supplement!$C$7/7*Supplement!$C$11/Supplement!$C$6,\"\")","v":0}]
[null,"TOTAL COST/HEAD/DAY",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),(C4+C5)/Supplement!$C$7,\"\")","v":1.0189166666666667},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),(D4+D5)/Supplement!$C$7,\"\")","v":0.98726666666666685},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),(E4+E5)/Supplement!$C$7,\"\")","v":1.101736111111111},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),(F4+F5)/Supplement!$C$7,\"\")","v":1.1257777777777778}]
[null,"TOTAL COST/HEAD/PERIOD",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),C4+C5,\"\")","v":91.702500000000001},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),D4+D5,\"\")","v":88.854000000000013},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),E4+E5,\"\")","v":99.15625},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),F4+F5,\"\")","v":101.32}]
[null,"TOTAL COST PER GROUP/PERIOD",{"$f":"IF(C11>0,C11*Supplement!$C$6,\"\")","v":9170.25},{"$f":"IF(D11>0,D11*Supplement!$C$6,\"\")","v":8885.4000000000015},{"$f":"IF(E11>0,E11*Supplement!$C$6,\"\")","v":9915.625},{"$f":"IF(F11>0,F11*Supplement!$C$6,\"\")","v":10132}]
[null,"Supplement cost as % of total",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),C4/C11,\"\")","v":0.50323055532837169},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),D4/D11,\"\")","v":0.58859477344857858},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),E4/E11,\"\")","v":0.67041916167664661},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),F4/F11,\"\")","v":0.48499802605606007}]
[]
[null,"Section G: Other nutrients supplied (on a dry matter basis) -- RESULTS"]
[null,"Supplement delivery options ",{"$f":"Supplement!C15","v":"Custom mix"},{"$f":"Supplement!D15","v":"Comm. Cubes"},{"$f":"Supplement!E15","v":"Self fed"},{"$f":"Supplement!F15","v":"Forage"}]
[null,"Crude protein supplied/hd/day, lbs",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),Supplement!C35,\"    N/A\")","v":0.99924720000000011},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),Supplement!D35,\"    N/A\")","v":0.99877680000000002},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),Supplement!E35,\"    N/A\")","v":0.98565851999999998},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),Supplement!F35,\"    N/A\")","v":0.99980400000000014}]
[null,"TDN supplied/hd/days, lbs",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),(Supplement!C30*(1-Supplement!C31))*Supplement!C$17*Supplement!C$21,\"    N/A\")","v":3.7471769999999998},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),(Supplement!D30*(1-Supplement!D31))*Supplement!D$17*Supplement!D$21,\"    N/A\")","v":1.8398519999999998},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),(Supplement!E30*(1-Supplement!E31))*Supplement!E$17*Supplement!E$21,\"    N/A\")","v":2.0907907999999997},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),(Supplement!F30*(1-Supplement!F31))*Supplement!F$17*Supplement!F$21,\"    N/A\")","v":4.22994}]
[null,"Phosphorus supplied/hd/day, grams",{"$f":"IF(AND(AND(Supplement!C$18>0,Supplement!C30),Supplement!$C$6>0),(Supplement!C30*(1-Supplement!C31))*Supplement!C17*Supplement!C$22*453.6,\"    N/A\")","v":5.6657316240000002},{"$f":"IF(AND(AND(Supplement!D$18>0,Supplement!D30),Supplement!$C$6>0),(Supplement!D30*(1-Supplement!D31))*Supplement!D17*Supplement!D$22*453.6,\"    N/A\")","v":11.92224096},{"$f":"IF(AND(AND(Supplement!E$18>0,Supplement!E30),Supplement!$C$6>0),(Supplement!E30*(1-Supplement!E31))*Supplement!E17*Supplement!E$22*453.6,\"    N/A\")","v":13.548324383999999},{"$f":"IF(AND(AND(Supplement!F$18>0,Supplement!F30),Supplement!$C$6>0),(Supplement!F30*(1-Supplement!F31))*Supplement!F17*Supplement!F$22*453.6,\"    N/A\")","v":8.7213671999999995}]