{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Input Guidance","Input and output","Income statement","Feed Cost per Ton Calculation"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":7,"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":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[[41,0,41,9],[29,0,30,9],[38,0,39,9],[13,0,13,9],[14,2,14,9],[22,0,22,9],[25,0,25,9],[33,0,37,9],[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[10,2,10,9],[11,0,11,9],[12,0,12,1],[12,2,12,9],[16,0,16,9],[19,0,19,9],[5,0,5,9],[0,0,0,9],[1,0,1,9],[3,0,3,9],[4,0,4,9],[2,0,2,9]]}
["Instructions"]
["North Dakota Economic Analysis Tool"]
["Open Lot vs Confinement Barn "]
[1]
["2023-10-12"]
["Introduction:"]
["This workbook is used for the economic comparison between open lots with a runoff pond and confinement bedded pack or slatted floor roof structures. The values used in the spreadsheet are a reference values as a starting point and data gathered from the site and producer shall be considered in the spreadsheet by the Engineer"]
["A knowledge of ag waste design and NRCS-ND Conservation Practice Standards for ag waste systems is needed to properly use this workbook."]
["Worksheet Format:"]
[]
["White","Grey"," White cells with black lettering and Grey cells are locked and can not be changed by user."]
[]
["Blue",null," Blue cells with blue lettering are user inputs. "]
[]
["Red","Triangles"," Cells with Red Triangles in the upper right corner have comments or help with data entry."]
[]
["Input Guidance:"]
["Various research information to uses as guidance when filling in the Input and output tab."]
[]
["Input and output:"]
["Fill in applicable Blue cells to the project.  If a line item does not apply it can be left blank."]
[]
["Income Statement:"]
["Provides a summary of the data."]
[]
["Feed Cost per Ton Calculation:"]
["Optional.  Used to calculate the ration cost / ton of DM."]
[]
["Instructions for data input:"]
["The Blue cells are user inputs for entering known values.  Most are self explanatory, and many have comments (red triangles) and dropdown boxes included."]
[]
[]
["Printing - Creates a PDF:"]
["Go to Input and output tab.  Scroll to the right until you see: Print Analysis Tool, Left Click on Print Analysis Tool, Window pops up and asks if you want to include the Feed Cost per Ton Calculation, click yes or no,  Merge folder pops up, navigate to where you would like the file created, Click OK, Popup window says resulting file was created: Click OK.  Navigate on the computer to the location of the file double click on the PDF to open."]
[]
[]
[]
[]
["Do not use space bar to clear inputs from data entry cells.  Use either the \"Del\" key or \"Editing - Clear Contents\"."]
[]
[]
["End of Instructions"]
[]
[]
[]
[]
[]
[]
[]
["Spreadsheet based on:"]
["Euken, Russ; Doran, Beth E.; Clark, Christopher A.; Shouse, Shawn C.; Loy, Dan; and Schulz, Lee L., \"Beef Feedlot Systems Manual\""]
["(2015). Extension and Outreach Publications. 95."]

{"sheet":"Input Guidance","index":1,"n_rows":103,"n_cols":1,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,2,12],[3,0,5,12]]}
["Input Guidance "]
[]
[]
["The information provided was found in various research documents as noted.   These values are to be used as guiance for filling in the Input and Output tab when information isn't available from the producer.  "]
[]
[]
["Depreciation or years of life"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["https://aglease101.org/wp-content/uploads/2020/10/NCFMEC-04.pdf"]
[]
[]
["Performance"]
["Table 4. Performance assumptions of yearling steers and steer calves fed in differing facility types1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 2. Cattle performance differences for open (OPN), open with shelter (OS), and monoslope confinement (MON) housing system2"]
[]
[]
[]
[]
[]
[]
[]
["Labor "]
["Table 13. Hours of Labor Across sysetems using average assumptions1 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 3. Amount of variale inputs for open (OPN), open with shelter (OS) and monolsope confinement(MON) housing systems2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nutrients"]
[]
["Table 6 Estimated nutrient concentration per ton or per 1000 gallon1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Machinery Operatation and Ownership"]
["Machinery Operation and ownership Costs - Refer to Estimating Farm Machinery Costs - Iowa State University Extension and Outreach"]
["Est Farm Machinery Costs (iastate.edu)"]
[]
[]
[]
[]
[]
[]
["1 Euken, Russ; Doran, Beth E.; Clark, Christopher A.; Shouse, Shawn C.; Loy, Dan; and Schulz, Lee L., \"Beef Feedlot Systems Manual\""]
["(2015). Extension and Outreach Publications. 95."]
["2 Mrozinski, J.M.; Pritchard, R.H.; Holland, B.P.; and Warmann, G.W., \"Cost Analysis of Cattle Feedlot Designs\" (2012). South Dakota"]

{"sheet":"Input and output","index":2,"n_rows":179,"n_cols":25,"rows_kept":179,"cut":false,"hidden":false,"merged":[[0,4,2,10],[0,16,2,21],[4,4,4,5],[5,4,5,5],[6,4,6,5],[4,8,4,12],[4,17,4,21],[4,14,4,16],[45,15,45,21],[41,15,41,21],[22,15,22,16],[34,15,34,16],[35,15,35,16],[5,14,5,16],[6,14,6,16],[7,15,7,16],[9,15,9,16],[8,15,8,21],[8,6,8,7],[31,6,31,7],[32,6,32,7],[24,2,24,3],[20,2,20,3],[17,2,17,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[39,4,39,7],[32,15,32,21],[30,6,30,7],[17,15,17,16],[18,15,18,16],[20,15,20,16],[19,15,19,16],[15,15,15,16],[16,15,16,16],[21,15,21,16],[33,15,33,16],[14,15,14,21],[22,6,22,7],[17,6,17,7],[16,6,16,7],[23,6,23,7],[69,4,69,7],[68,4,68,7],[67,4,67,7],[58,4,58,7],[59,4,59,7],[60,4,60,7],[64,4,64,7],[72,4,72,7],[74,4,74,7],[73,4,73,7],[62,4,62,7],[63,4,63,7],[60,15,60,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[62,15,62,21],[66,15,66,21],[74,15,74,21],[68,15,68,16],[67,15,67,16],[51,15,51,16],[55,15,55,16],[53,15,53,21],[69,15,69,16],[70,15,70,16],[71,15,71,16],[72,15,72,16],[7,6,7,7],[36,15,36,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[50,15,50,16],[54,15,54,16],[58,15,58,16],[59,15,59,16],[10,15,10,16],[54,4,54,7],[75,15,75,16],[76,15,76,16],[64,15,64,16],[63,15,63,16],[36,0,78,2],[4,1,4,3],[6,1,6,3],[5,1,5,3],[4,6,4,7],[5,6,5,7],[6,6,6,7],[76,4,76,7],[19,6,19,7],[16,0,17,0],[19,0,20,0],[20,6,20,7],[9,6,9,7],[10,6,10,7],[11,6,11,7],[61,4,61,7],[21,6,21,7],[75,4,75,7],[71,4,71,7],[14,2,14,3],[10,2,10,4],[56,5,56,7],[12,6,12,7],[15,6,15,7],[77,4,77,7],[78,4,78,7],[14,6,14,7],[52,4,52,7],[55,4,55,7],[42,4,42,7],[43,4,43,7],[44,4,44,7],[45,4,45,7],[46,4,46,7],[33,6,33,7],[26,6,26,7],[27,6,27,7],[48,4,48,7],[49,4,49,7],[51,4,51,7],[47,4,47,7],[53,4,53,7],[50,4,50,7]]}
[null,null,null,null,"NATURAL RESOURCES CONSERVATION SERVICE                                                             OPEN LOT VS CONFINEMENT BARN ECONOMIC ANALYSIS TOOL",null,null,null,null,null,null,null,"North Dakota",null,null,null,"             NATURAL RESOURCES CONSERVATION SERVICE                                                     OPEN LOT VS CONFINEMENT BARN ECONOMIC ANALYSIS TOOL",null,null,null,null,null,"North Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-12",null,null,null,null,null,null,null,null,null,{"$f":"M2","v":"2023-10-12"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Version 1.0",null,null,null,null,null,null,null,null,null,{"$f":"M3","v":"Version 1.0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 3",null,null,null,null,null,null,null,null,null,"Page 2 of 3"]
["Producer:",null,null,null,"Field Office:",null,null,null,"FACILITY DESCRIPTION ",null,null,null,null,"Producer:",{"$f":"IF(Producer=\"\",\"\",Producer)","v":""},null,null,"FACILITY DESCRIPTION "]
["Legal Desc:",null,null,null,"Details:",null,null,null,"Open lot",null,"Confinement",null,"Confinement","Legal Desc:",{"$f":"IF(Legal=\"\",\"\",Legal)","v":""},null,null,"Open lot",null,"Confinement",null,"Confinement"]
["Completed by:",null,null,null,"Date:",null,null,null,"Runoff Pond",null,"Bedded",null,"Slatted","Field Office:",{"$f":"IF(FO=\"\",\"\",FO)","v":""},null,null,"Runoff Pond",null,"Bedded",null,"Slatted"]
[null,null,null,null,null,null,"Number of head",null,600,null,600,null,600,null,null,"Number of head",null,{"$f":"I8","v":600},null,{"$f":"K8","v":600},null,{"$f":"M8","v":600}]
[null,null,null,null,null,null,"Investment for facility",null,null,null,null,null,null,null,null,"Investment for facility"]
[null,null,null,null,null,null,"Construction Cost",null,360000,null,900000,null,975000,null,null,"Total Construction Cost $",null,{"$f":"I10","v":360000},null,{"$f":"K10","v":900000},null,{"$f":"M10","v":975000}]
["Animal Type",null,"Beef",null,null,null,"Construction Cost per head",null,{"$f":"IF(I8<=0,\"0\",I10/I8)","v":600},null,{"$f":"IF(K8<=0,\"0\",K10/K8)","v":1500},null,1625,null,null,"Estimated Tax & Insurance Annual $",null,{"$f":"I12","v":0},null,{"$f":"K12","v":0},null,0]
["Animal Weight",null,500,null,null,null,"Insurance  (per year)",null,0,null,0,null,0]
["Animal Cost $/lb.",null,2.44,null,null,null,"Land area required for facility (acres)",null,3,null,0.97,null,0.76]
["Finished Weight",null,1350]
["Finished Value $/lb.",null,2.35,null,null,null,"Financing for facility",null,null,null,null,null,null,null,null,"Annual facility charges"]
[null,null,null,null,null,null,"% Borrowed direct from lender",null,0,null,0,null,0,null,null,"Principal payment per year",null,{"$f":"IF(I17<=0,\"$0.00\",PPMT(I18,1,I17,-(I8*I11-(I8*I20*I21))*I16)+PPMT(I24,1,I23,-(I8*I11-(I8*I20*I21))*I22))","v":0},null,{"$f":"IF(K17<=0,\"$0.00\",PPMT(K18,1,K17,-(K8*K11-(K8*K20*K21))*K16)+PPMT(K24,1,K23,-(K8*K11-(K8*K20*K21))*K22))","v":0},null,0,null,null,"Payment on principal for a given time *(interest rate, 1, note length (years), -(No of head x initial investment per head x % cost share)) x %borrowed direct from lender + payment on princ (interest rate % for loan, 1, note length years, - (no of head x initial investment per head -(no of head x % of  investment cost share x % cost share)) x % of investment on low interest loan"]
["Ration Cost             ($/ ton DM)",null,null,null,null,null,"Note Length (years)",null,20,null,20,null,20,null,null,"Interest payment per year",null,{"$f":"IF(I17<=0,\"$0.00\",ISPMT(I18,1,I17,-((I8*I11)-(I8*I20*I21))*I16)+ISPMT(I24,1,I23,-((I8*I11)-(I8*I20*I21))*I22))","v":0},null,{"$f":"IF(K17<=0,\"$0.00\",ISPMT(K18,1,K17,-((K8*K11)-(K8*K20*K21))*K16)+ISPMT(K24,1,K23,-((K8*K11)-(K8*K20*K21))*K22))","v":0},null,0,null,null,"ISPMT - calculates the interest paid during a given period of an investment where principal payments are equal (interest rate, 1, note length, - (((no of head investment per head)-(no of headx % of invest cost shared x %cost share)) x %borrowed direct from lender ) + IPMT ( interest rate, 1, note length, - ((no of head x initial invest per head)-(no of head x % investment cost shared x % cost shared) x % of investment on low interest loan) "]
[null,null,189,null,null,null,"Interest Rate (%)",null,8.5000000000000006E-2,null,8.5000000000000006E-2,null,8.5000000000000006E-2,null,null,"Owner equity needed",null,{"$f":"(I8*I11)*(1-I16-(I20*I21)-I22)","v":360000},null,{"$f":"(K8*K11)*(1-K16-(K20*K21)-K22)","v":900000},null,{"$f":"(M8*M11)*(1-M16-(M20*M21)-M22)","v":975000},null,null,"( no of head x initial investment per head) x (1- % borrowed direct from lender - (% of investment financially assisted x % of financial assistance) - note length years for low interest loan"]
[null,null,null,null,null,null,"Additional financial assistance or low interest loans",null,null,null,null,null,null,null,null,"Opportunity cost of owner equity",null,{"$f":"IF(I17<=0,\"$0.00\",ISPMT(I18,1,I17,-R18))","v":29070},null,{"$f":"IF(K17<=0,\"$0.00\",ISPMT(K18,1,K17,-T18))","v":72675},null,78731.25,null,null,"ISPMT - calculates the interest paid during one year of an investment where principal payments are equal ( interest rate, 1 note length years, -owner equity needed)"]
["Bedding Cost       ($/ ton)",null,null,null,null,null,"% of Construction financially assistanced",null,0,null,0,null,0,null,null,"Depreciation per year",null,{"$f":"IF(I27<=0,\"$0.00\",((I8*I11)-(I8*I11*I28))/I27)","v":18000},null,{"$f":"IF(K27<=0,\"$0.00\",((K8*K11)-(K8*K11*K28))/K27)","v":45000},null,48750,null,null,"(( no of head x initial investment per head ) - (no of head x initial investment per head x salvage value of facility % of original cost)) / depreciable years of life"]
[null,null,23,null,null,null,"% Financial Assistance",null,0,null,0,null,0,null,null,"Principal and interest payment per head",null,{"$f":" (R16+R17)/( I8*I75)","v":0},null,{"$f":"(T16+T17)/(K8*K75)","v":0},null,{"$f":"(V16+V17)/(M8*M75)","v":0},null,null,"(principal payment per year + interest payment per year) / ( no of head x turns over the year)"]
[null,null,null,null,null,null,"% of investment on low interest loan",null,0,null,0,null,0,null,null,"Annual/hd depreciation, opportunity cost, and interest ",null,{"$f":"(R17+R19+R20)/(I8*I75)","v":52.048940405104794},null,{"$f":"(T17+T19+T20)/(K8*K75)","v":127.93542074363992},null,{"$f":"(V17+V19+V20)/(M8*M75)","v":138.20956416928138},null,null,"(interest rate payment per year + opportunity cost of owner equity +depreciation per year)/(no of head x turns over the year)"]
[null,null,null,null,null,null,"Note Length (years) for low interest loan",null,30,null,30,null,30,null,null,"Annual land rental charge for facility",null,{"$f":"I13*I56","v":0},null,{"$f":"K13*K56","v":0},null,{"$f":"M13*M56","v":0},null,null,"land area required for facility x rental rate per acre for land for facility"]
["Labor",null,null,null,null,null,"Interest Rate (%) for low interest loan",null,4.4999999999999998E-2,null,4.4999999999999998E-2,null,4.4999999999999998E-2]
["Charge ($/hour)",null,23]
[null,null,null,null,null,null,"Depreciation or years of life "]
[null,null,"% of Nutrient Available for Crop",null,null,null,"Depreciable years of life ",null,20,null,20,null,20,null,null,null,null,null,null," ",null," "]
["Nutrients","$/lb. Nutrient","Open Lot","Bedded","Slatted",null,"Salvage value of facility % of original cost",null,0,null,0,null,0]
[" N",0.64,0.5,0.5,0.5]
[" P2O5",0.71,1,1,1,null,"Performance and Health"]
[" K2O",0.45,1,1,1,null,"Occupancy (%)",null,1,null,1,null,1]
[null,null,null,null,null,null,"Avg. Daily Gain",null,3.51,null,3.57,null,3.58]
[null,null,null,null,null,null,"Pounds DM Feed per Pound Gain",null,7,null,6.75,null,6.75,null,null,"Manure quantity, nutrient concentration and value"]
[null,null,null,null,null,null,"Feed intake lbs. DM per hd per day",null,{"$f":"I33*I32","v":24.57},null,{"$f":"K33*K32","v":24.0975},null,24.4,null,null,"Manure (tons or gallons) total annual",null,{"$f":"I36*I8*I31","v":1800},null,{"$f":"K36*K8*K31","v":3000},null,{"$f":"M36*M8*M31","v":900000}]
[null,null,null,null,"Manure quantity, nutrient concentration and value",null,null,null,null,null,null,null,null,null,null,"Total manure value",null,{"$f":"IF(I36<100,((I38*I37*$D29*$B29)+(I39*I37*$D30*$B30)+(I40*I37*$D31*$B31)),((I38*(I37/1000)*$D29*$B29)+(I39*(I37/1000)*$D30*$B30)+(I40*(I37/1000)*$D31*$B31)))","v":40554},null,{"$f":"IF(K36<100,((K38*K37*$D29*$B29)+(K39*K37*$D30*$B30)+(K40*K37*$D31*$B31)),((K38*(K37/1000)*$D29*$B29)+(K39*(K37/1000)*$D30*$B30)+(K40*(K37/1000)*$D31*$B31)))","v":59610},null,{"$f":"IF(M36<100,((M38*M37*$E29*$B29)+(M39*M37*$E30*$B30)+(M40*M37*$E31*$B31)),((M38*(M37/1000)*$E29*$B29)+(M39*(M37/1000)*$E30*$B30)+(M40*(M37/1000)*$E31*$B31)))","v":43515}]
["Notes:",null,null,null,"Manure (tons or 1000 gallons) per head annual",null,null,null,3,null,5,null,1500,null,null,"Manure application cost total",null,{"$f":"I51+(I47*$C$25)+IF(I60=0,I53+I52,(R64*((I60)/R59))+((I53)+(I52)))","v":0},null,{"$f":"K51+(K47*$C$25)+IF(K60=0,K53+K52,(T64*((K60)/T59))+((K53)+(K52)))","v":0},null,{"$f":"M51+(M47*$C$25)+IF(M60=0,M53+M52,(V64*((M60)/V59))+((M53)+(M52)))","v":0}]
[null,null,null,null,"Manure (tons or gallons) total annual",null,null,null,{"$f":"I36*I8*I31","v":1800},null,{"$f":"K36*K8*K31","v":3000},null,{"$f":"M36*M8*M31","v":900000},null,null,"Manure application cost ton or per gallon",null,{"$f":"IF(R36<=0,\"0\",R36/R34)","v":"0"},null,{"$f":"IF(T36<=0,\"0\",T36/T34)","v":"0"},null,"0",null,null,"Entered value - tons of manure per year"]
[null,null,null,null,"- manure - Nitrogen lbs. per ton or 1000 gallon",null,null,null,15,null,18,null,45]
[null,null,null,null,"- manure - Phosphorus lbs. per ton or 1000 gallon",null,null,null,18,null,11,null,25,null,null,null,null,null,null,null,null,null,null,null,"Custom manure application charge per year+(Labor * manure application hours/per facility/year*Labor Rate Per hour)+(Annual payment additional feed storage*((equiipment purchase*0.75)/total investment for additional feed storage or equipment)+((equipment ownership/head/year*0.25)+(equipment operation head/year*0.2)*number of head))"]
[null,null,null,null,"- manure - Potassium lbs. per ton or 1000 gallon",null,null,null,11,null,14,null,36,null,null,null,null,null,null,null,null,null,null,null,"manure total/ manure application cost "]
[]
[null,null,null,null,"Other non feed factors",null,null,null,null,null,null,null,null,null,null,"Other Non Feed Factors"]
[null,null,null,null,"Bedding (Pounds / Head-Day)",null,null,null,10,null,5,null,0,null,null,"Bedding (tons) annually",null,{"$f":"(I43*I8*365*I31)/2000","v":1095},null,{"$f":"(K43*K8*365*K31)/2000","v":547.5},null,{"$f":"(M43*M8*365*M31)/2000","v":0}]
[null,null,null,null,"Labor -processing, sorting, etc. (hours/group/turn)",null,null,null,10,null,10,null,10,null,null,"Bedding cost annually",null,{"$f":"R43*$C21","v":25185},null,{"$f":"T43*$C21","v":12592.5},null,{"$f":"V43*$C21","v":0}]
[null,null,null,null,"Labor -daily care (hours/group/day)",null,null,null,0,null,2.6,null,2.6,null,null,"Bedding cost per head space per year",null,{"$f":"R44/I8","v":41.975000000000001},null,{"$f":"T44/K8","v":20.987500000000001},null,{"$f":"V44/M8","v":0}]
[null,null,null,null,"Labor - cleaning and bedding hours/group/week",null,null,null,0,null,{"$f":"(K8/150)*1.1","v":4.4000000000000004},null,{"$f":"(M8/150)*1.14","v":4.5599999999999996},null,null,"Labor"]
[null,null,null,null,"Labor - manure application hours/year",null,null,null,0,null,0,null,0,null,null,"Total labor hours per turn per head",null,{"$f":"I48*I8*I75","v":15.072352941176471},null,{"$f":"K48*K8*K75","v":1193.7585714285715},null,{"$f":"M48*M8*M75","v":1202.1443697478992}]
[null,null,null,null,"Total labor hours per turn per head",null,null,null,{"$f":"(I44+(I45*I73)+(I46*(I73/7))+I47)/I8","v":1.6666666666666666E-2},null,{"$f":"(K44+(K45*K73)+(K46*(K73/7))+K47)/K8","v":1.2978458049886623},null,{"$f":"(M44+(M45*M73)+(M46*(M73/7))+M47)/M8","v":1.3033120510774143},null,null,"Total labor hours per head space",null,{"$f":"R47/I8","v":2.5120588235294117E-2},null,{"$f":"T47/K8","v":1.9895976190476192},null,{"$f":"V47/M8","v":2.0035739495798319}]
[null,null,null,null,"Maintenance for roads, diversions, etc. per year",null,null,null,0,null,0,null,0,null,null,"Total labor hours per turn per head",null,{"$f":"(I44+(I45*I73)+(I46*(I73/7))+I47)/I8","v":1.6666666666666666E-2},null,{"$f":"(K44+(K45*K73)+(K46*(K73/7))+K47)/K8","v":1.2978458049886623},null,{"$f":"(M44+(M45*M73)+(M46*(M73/7))+M47)/M8","v":1.3033120510774143}]
[null,null,null,null,"Maintenance for building(s) or pond per year",null,null,null,0,null,0,null,0,null,null,"Total labor charge",null,{"$f":"R47*$C25","v":346.66411764705884},null,{"$f":"T47*$C25","v":27456.447142857145},null,{"$f":"V47*$C25","v":27649.320504201682}]
[null,null,null,null,"Custom manure application charge per year",null,null,null,0,null,0,null,0,null,null,"Custom manure application charge",null,{"$f":"I51","v":0},null,{"$f":"K51","v":0},null,{"$f":"M51","v":0}]
[null,null,null,null,"Manure Equipment operation per year",null,null,null,0,null,0,null,0,null,null,"Equipment usage for daily care/bedding cost total",null,{"$f":"(R47*$C$25)+IF(I61=0,I55+I54,(R64*((I61)/R59))+((I55)+(I54)))","v":346.66411764705884},null,{"$f":"(T47*$C$25)+IF(K61=0,K55+K54,(T64*((K61)/T59))+((K55)+(K54)))","v":27456.447142857145},null,{"$f":"(V47*$C$25)+IF(M61=0,M55+M54,(V64*((M61)/V59))+((M55)+(M54)))","v":27649.320504201682}]
[null,null,null,null,"Manure Equipment ownership per year",null,null,null,0,null,0,null,0]
[null,null,null,null,"Equipment operation for daily care/bedding per year",null,null,null,0,null,0,null,0,null,null,"Interest on feed and animal purchases"]
[null,null,null,null,"Equipment ownership for daily care/bedding per year",null,null,null,0,null,0,null,0,null,null,"Interest on feed",null,{"$f":"((($C18/2000)*(I33*($C14-$C12))*I8)*I70)*((I73/365)*0.5)*I75-IF(I79>0,I79*((($C18/2000)*(I33*($C14-$C12))*I8)*I70)*((I73/365)*0.5)*I75,0)","v":0},null,{"$f":"((($C18/2000)*(K33*($C14-$C12))*K8)*K70)*((K73/365)*0.5)*K75-IF(K79>0,K79*((($C18/2000)*(K33*($C14-$C12))*K8)*K70)*((K73/365)*0.5)*K75,0)","v":8132.9062499999991},null,{"$f":"((($C18/2000)*(M33*($C14-$C12))*M8)*M70)*((M73/365)*0.5)*M75-IF(M79>0,M79*((($C18/2000)*(M33*($C14-$C12))*M8)*M70)*((M73/365)*0.5)*M75,0)","v":8132.9062499999991}]
[null,null,null,null,"Rental rate per acre for land for facility",null,null,null,0,null,0,null,0,null,null,"Interest on cattle",null,{"$f":"(($C12*$C13)*I70*I8)*('Input and output'!I73/365*0.5)*I75-IF(I79>0,I79*(($C12*$C13)*I70*I8)*('Input and output'!I73/365*0.5),0)*I75","v":0},null,{"$f":"(($C12*$C13)*K70*K8)*('Input and output'!K73/365*0.5)*K75-IF(K79>0,K79*(($C12*$C13)*K70*K8)*('Input and output'!K73/365*0.5),0)*K75","v":18300},null,{"$f":"(($C12*$C13)*M70*M8)*('Input and output'!M73/365*0.5)*M75-IF(M79>0,M79*(($C12*$C13)*M70*M8)*('Input and output'!M73/365*0.5),0)*M75","v":18299.999999999996}]
[null,null,null,null,"Other  ",null,null,null,0,null,0,null,0]
[null,null,null,null,"Investment for additional feed storage or equipment",null,null,null,null,null,null,null,null,null,null,"Investment for additional feed storage or equipment"]
[null,null,null,null,"Feeding equipment (total $)",null,null,null,0,null,0,null,0,null,null,"Total additional investment",null,{"$f":"SUM(I59:I63)","v":0},null,{"$f":"SUM(K59:K63)","v":0},null,{"$f":"SUM(M59:M63)","v":0},null,null,"sum of investment for additional feed storage or equipment"]
[null,null,null,null,"Manure / Dirt Handling equipment (total $)",null,null,null,0,null,0,null,0,null,null,"Additional taxes and insurance",null,{"$f":"(R59*I64)+(I63*I65)","v":0},null,{"$f":"(T59*K64)+(K63*K65)","v":0},null,{"$f":"(V59*M64)+(M63*M65)","v":0}]
[null,null,null,null,"Bedding equipment. (total $)",null,null,null,0,null,0,null,0,null,null,"Per head  per year charge",null,{"$f":"IF(I70<=0,\"$0.00\",(PMT(I70,I69,-R59))/(I8*I75))","v":"$0.00"},null,{"$f":"IF(K70<=0,\"$0\",(PMT(K70,K69,-T59))/(K8*K75))","v":0},null,{"$f":"IF(M70<=0,\"$0\",(PMT(M70,M69,-V59))/(M8*M75))","v":0}]
[null,null,null,null,"Cattle Handling equipment(total $)",null,null,null,0,null,0,null,0]
[null,null,null,null,"Feed storage total $",null,null,null,0,null,0,null,0,null,null,"Finance additional feed storage or equipment"]
[null,null,null,null,"Insurance  (% of original investment)",null,null,null,0,null,0,null,0,null,null,"Annual payment",null,{"$f":"IF(I70<=0,\"$0\",PMT(I70,I69,-(R59*I68)))","v":"$0"},null,{"$f":"IF(K70<=0,\"$0\",PMT(K70,K69,-(T59*K68)))","v":0},null,{"$f":"IF(M70<=0,\"$0\",PMT(M70,M69,-(V59*M68)))","v":0}]
[null,null,null,null,"Tax on feed storage only (% of original investment)",null,null,null,0,null,0,null,0,null,null,"Cash or owner equity  ",null,{"$f":"R59*(1-I68)","v":0},null,{"$f":"T59*(1-K68)","v":0},null,{"$f":"V59*(1-M68)","v":0}]
[]
[null,null,null,null,"Finance additional feed storage or equipment",null,null,null,null,null,null,null,null,null,null,"Cost per lb. of gain comparison"]
[null,null,null,null,"% Borrowed Money $",null,null,null,0,null,0,null,0,null,null,"Total Cost ($ / lb. Gain)",null,{"$f":"R71+R70+R69","v":0.7559485823730161},null,{"$f":"T71+T70+T69","v":0.87342256307466082},null,{"$f":"V71+V70+V69","v":0.86945682197680263}]
[null,null,null,null,"Note Length (years)",null,null,null,5,null,5,null,5,null,null,"      Feed Cost ($ / lb. Gain)",null,{"$f":"$C18/2000*I33","v":0.66149999999999998},null,{"$f":"$C18/2000*K33","v":0.63787499999999997},null,{"$f":"$C18/2000*M33","v":0.63787499999999997}]
[null,null,null,null,"Interest Rate (%)",null,null,null,0,null,0.05,null,0.05,null,null,"      Non feed variable cost ($/lb. gain",null,{"$f":"((I52*(I8*I75)+I48+R44+R50+R51+R55+R56)/(I8*I32*I73*I75))","v":3.3214534837598675E-2},null,{"$f":"((K52*(K8*K75)+K48+T44+T50+T51+T55+T56)/(K8*K32*K73*K75))","v":8.5035303376260987E-2},null,{"$f":"((M52*(M8*M75)+M48+V44+V50+V51+V55+V56)/(M8*M32*M73*M75))","v":6.8982334718824465E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      Non feed fixed cost ($/lb. gain",null,{"$f":"((I53*I8)+(R17+R19+R20+R60+R64+R11+R23))/(I8*I32*I73*I75)","v":6.1234047535417398E-2},null,{"$f":"((K53*K8)+(T17+T19+T20+T60+T64+T11+T23))/(K8*K32*K73*K75)","v":0.1505122596983999},null,{"$f":"((M53*M8)+(V17+V19+V20+V60+V64+V11+V23))/(M8*M32*M73*M75)","v":0.16259948725797813}]
[null,null,null,null,"Days on feed and turns per year",null,null,null,null,null,null,null,null,null,null,"Manure value ($/ lb. gain)",null,{"$f":"R35/I8/(I32*I74)","v":5.2757288373726736E-2},null,{"$f":"T35/K8/(K32*K74)","v":7.6244196308660445E-2},null,{"$f":"V35/M8/(M32*M74)","v":5.550241065278947E-2}]
[null,null,null,null,"Days on Feed / turn",null,null,null,{"$f":"($C14-$C12)/I32","v":242.16524216524218},null,{"$f":"($C14-$C12)/K32","v":238.0952380952381},null,{"$f":"($C14-$C12)/M32","v":237.43016759776535},null,null,"Total Cost ($/lb. gain) with manure credit",null,{"$f":"R68-R72","v":0.70319129399928937},null,{"$f":"T68-T72","v":0.7971783667660004},null,{"$f":"V68-V72","v":0.81395441132401314}]
[null,null,null,null,"Days facility full per year",null,null,null,{"$f":"365*I31","v":365},null,{"$f":"365*K31","v":365},null,{"$f":"365*M31","v":365}]
[null,null,null,null,"Turns (over year span)",null,null,null,{"$f":"I74/I73","v":1.507235294117647},null,{"$f":"K74/K73","v":1.5329999999999999},null,{"$f":"M74/M73","v":1.5372941176470589},null,null,"Breakeven comparison"]
[null,null,null,null,"Custom feeding charge per head per day",null,null,null,null,null,null,null,null,null,null,"Breakeven finished price with manure credit",null,{"$f":"((($C14-$C12)*R73)+($C12*$C13))/(($C14))","v":1.3464537777032564},null,{"$f":"((($C14-$C12)*T73)+($C12*$C13))/(($C14))","v":1.4056308235193335},null,{"$f":"((($C14-$C12)*V73)+($C12*$C13))/(($C14))","v":1.4161935182410452}]
[null,null,null,null,"Custom feeding charge per head per day",null,null,null,0,null,0,null,0,null,null,"Breakeven finished price without manure credit",null,{"$f":"((($C14-$C12)*R68)+($C12*$C13))/(($C14))","v":1.3796713296422696},null,{"$f":"((($C14-$C12)*T68)+($C12*$C13))/(($C14))","v":1.4536364286025643},null,{"$f":"((($C14-$C12)*V68)+($C12*$C13))/(($C14))","v":1.4511394805039128}]
[null,null,null,null,"Feed mark up per ton dry matter",null,null,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,"Yardage cost is the non-feed cost per head for every day that an animal is fed harvested feed in some form of confinement."]
[null,null,null,null,"% of capacity custom fed",null,null,null,0,null,0,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ashley"]
["Beach"]
["Beulah"]
["Bismarck"]
["Bottineau"]
["Bowbells"]
["Bowman"]
["Cando"]
["Carrington"]
["Carson"]
["Cavalier"]
["Center"]
["Cooperstown"]
["Crosby"]
["Devils Lake"]
["Dickinson"]
["Ellendale"]
["Fargo"]
["Fessenden"]
["Finley"]
["Forman"]
["Fort Yates"]
["Garrison/Turtle Lake"]
["Grand Forks"]
["Hettinger"]
["Hillsboro"]
["Jamestown"]
["Killdeer"]
["La Moure"]
["Lakota"]
["Langdon"]
["Linton"]
["Lisbon"]
["Mandan"]
["McClusky"]
["Minnewaukan"]
["Minot"]
["Mohall"]
["Mott"]
["Napoleon"]
["New Rockford"]
["Park River"]
["Rolla"]
["Rugby"]
["Selfridge"]
["Stanley"]
["Steele"]
["Towner"]
["Valley City"]
["Wahpeton"]
["Watford City"]
["Williston"]

{"sheet":"Income statement","index":3,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[40,1,40,2],[41,1,41,2],[33,1,33,2],[35,1,35,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[31,1,31,2],[20,1,20,2],[22,1,22,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[19,1,19,2],[27,1,27,2],[25,1,25,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[23,1,23,2],[24,1,24,2],[1,2,2,7],[8,1,8,7],[10,1,11,2],[21,1,21,2],[4,1,4,4],[5,1,5,3],[6,1,6,3]]}
[null,null,null,null,null,null,null,null,"North Dakota"]
[null,null,"NATURAL RESOURCES CONSERVATION SERVICE                                                              OPEN LOT VS CONFINEMENT BARN ECONOMIC ANALYSIS TOOL",null,null,null,null,null,{"$f":"'Input and output'!M2","v":"2023-10-12"}]
[null,null,null,null,null,null,null,null,{"$f":"'Input and output'!M3","v":"Version 1.0"}]
[null,null,null,null,null,null,null,null,"Page 3 of 3"]
["Producer:",{"$f":"IF(Producer=\"\",\"\",Producer)","v":""}]
["Legal Desc:",{"$f":"IF(Legal=\"\",\"\",Legal)","v":""}]
["Field Office:",{"$f":"IF(FO=\"\",\"\",FO)","v":""}]
[]
[null,"Annual Income Statement"]
[]
[null,"Gross Income",null,{"$f":"'Input and output'!I6","v":"Open lot"},null,{"$f":"'Input and output'!K6","v":"Confinement"},null,{"$f":"'Input and output'!M6","v":"Confinement"}]
[null,null,null,{"$f":"'Input and output'!I7","v":"Runoff Pond"},null,{"$f":"'Input and output'!K7","v":"Bedded"},null,{"$f":"'Input and output'!M7","v":"Slatted"}]
[null,"Gross Beef Income",null,{"$f":"(('Input and output'!$C14*'Input and output'!$C15)*('Input and output'!I8*'Input and output'!I75))-IF('Input and output'!I79>0,('Input and output'!I79*((('Input and output'!$C14*'Input and output'!$C15)*('Input and output'!I8*'Input and output'!I75))-('Input and output'!$C14*'Input and output'!$C15)*(('Input and output'!I8)*'Input and output'!I75))),0)","v":2869022.3823529407},null,{"$f":"(('Input and output'!$C14*'Input and output'!$C15)*('Input and output'!K8*'Input and output'!K75))-IF('Input and output'!K79>0,('Input and output'!K79*((('Input and output'!$C14*'Input and output'!$C15)*('Input and output'!K8*'Input and output'!K75))-('Input and output'!$C14*'Input and output'!$C15)*(('Input and output'!K8)*'Input and output'!K75))),0)","v":2918065.5},null,{"$f":"(('Input and output'!$C14*'Input and output'!$C15)*('Input and output'!M8*'Input and output'!M75))-IF('Input and output'!M79>0,('Input and output'!M79*((('Input and output'!$C14*'Input and output'!$C15)*('Input and output'!M8*'Input and output'!M75))-('Input and output'!$C14*'Input and output'!$C15)*(('Input and output'!M8)*'Input and output'!M75))),0)","v":2926239.3529411769}]
[null,"Custom Feeding Income",null,{"$f":"('Input and output'!I77*'Input and output'!I79*'Input and output'!I8*'Input and output'!I74)+(('Input and output'!I34/2000*'Input and output'!I8*'Input and output'!I74)*'Input and output'!I78*'Input and output'!I79)","v":0},null,{"$f":"('Input and output'!K77*'Input and output'!K79*'Input and output'!K8*'Input and output'!K74)+(('Input and output'!K34/2000*'Input and output'!K8*'Input and output'!K74)*'Input and output'!K78*'Input and output'!K79)","v":0},null,{"$f":"('Input and output'!M77*'Input and output'!M79*'Input and output'!M8*'Input and output'!M74)+(('Input and output'!M34/2000*'Input and output'!M8*'Input and output'!M74)*'Input and output'!M78*'Input and output'!M79)","v":0}]
[null,"Manure Value (one year period)",null,{"$f":"'Input and output'!R35","v":40554},null,{"$f":"'Input and output'!T35","v":59610},null,{"$f":"'Input and output'!V35","v":43515}]
[null,"Total Gross Income (one year period)",null,{"$f":"D13+D14+D15","v":2909576.3823529407},null,{"$f":"F13+F14+F15","v":2977675.5},null,2969754.3529411769]
[]
[]
[null,"Annual Costs"]
[null,"Facility Interest and opportunity cost",null,{"$f":"'Input and output'!R17+'Input and output'!R19","v":29070},null,{"$f":"'Input and output'!T17+'Input and output'!T19","v":72675},null,{"$f":"'Input and output'!V17+'Input and output'!V19","v":78731.25}]
[null,"Facility Depreciation",null,{"$f":"'Input and output'!R20","v":18000},null,{"$f":"'Input and output'!T20","v":45000},null,{"$f":"'Input and output'!V20","v":48750}]
[null,"Facility Maintenance",null,{"$f":"'Input and output'!I49+'Input and output'!I50","v":0},null,{"$f":"'Input and output'!K49+'Input and output'!K50","v":0},null,{"$f":"'Input and output'!M49+'Input and output'!M50","v":0}]
[null,"Cattle Purchases",null,{"$f":"(('Input and output'!$C12*'Input and output'!$C13)*('Input and output'!I8*'Input and output'!I75))-(IF('Input and output'!I79>0,'Input and output'!I79*'Input and output'!$C12*'Input and output'!$C13*'Input and output'!I8*'Input and output'!I75,0))","v":1103296.2352941176},null,{"$f":"(('Input and output'!$C12*'Input and output'!$C13)*('Input and output'!K8*'Input and output'!K75))-(IF('Input and output'!K79>0,'Input and output'!K79*'Input and output'!$C12*'Input and output'!$C13*'Input and output'!K8*'Input and output'!K75,0))","v":1122156},null,{"$f":"(('Input and output'!$C12*'Input and output'!$C13)*('Input and output'!M8*'Input and output'!M75))-(IF('Input and output'!M79>0,'Input and output'!M79*'Input and output'!$C12*'Input and output'!$C13*'Input and output'!M8*'Input and output'!M75,0))","v":1125299.2941176472}]
[null,{"$f":"\"Feed Cost \"","v":"Feed Cost "},null,{"$f":"(('Input and output'!$C18/2000*('Input and output'!I8*'Input and output'!I74))-IF('Input and output'!I79>0,('Input and output'!I79*('Input and output'!$C18/2000*('Input and output'!I8*'Input and output'!I74))),0))","v":20695.5},null,{"$f":"(('Input and output'!$C18/2000*('Input and output'!K8*'Input and output'!K74))-IF('Input and output'!K79>0,('Input and output'!K79*('Input and output'!$C18/2000*('Input and output'!K8*'Input and output'!K74))),0))","v":20695.5},null,{"$f":"(('Input and output'!$C18/2000*('Input and output'!M8*'Input and output'!M74))-IF('Input and output'!M79>0,('Input and output'!M79*('Input and output'!$C18/2000*('Input and output'!M8*'Input and output'!M74))),0))","v":20695.5}]
[null,{"$f":"\"Labor Cost \"","v":"Labor Cost "},null,{"$f":"'Input and output'!R50","v":346.66411764705884},null,{"$f":"'Input and output'!T50","v":27456.447142857145},null,{"$f":"'Input and output'!V50","v":27649.320504201682}]
[null,{"$f":"\"Bedding Cost  \"","v":"Bedding Cost  "},null,{"$f":"'Input and output'!R44","v":25185},null,{"$f":"'Input and output'!T44","v":12592.5},null,{"$f":"'Input and output'!V44","v":0}]
[null,"Vet med",null,0,null,0,null,0]
[null,"Equipment Costs care/bedding",null,{"$f":"'Input and output'!R52","v":346.66411764705884},null,{"$f":"'Input and output'!T52","v":27456.447142857145},null,{"$f":"'Input and output'!V52","v":27649.320504201682}]
[null,"Cattle and Feed interest",null,{"$f":"'Input and output'!R55+'Input and output'!R56-(IF('Input and output'!I79>0,('Input and output'!I79*('Input and output'!R55+'Input and output'!R56)),0))","v":0},null,{"$f":"'Input and output'!T55+'Input and output'!T56-(IF('Input and output'!K79>0,('Input and output'!K79*('Input and output'!T55+'Input and output'!T56)),0))","v":26432.90625},null,{"$f":"'Input and output'!V55+'Input and output'!V56-(IF('Input and output'!M79>0,('Input and output'!M79*('Input and output'!V55+'Input and output'!V56)),0))","v":26432.906249999996},null,null,null,"Orignal forumals were the following, removed trucking costs for custom feeding and "]
[null,"Other variable costs",null,{"$f":"'Input and output'!R51-IF('Input and output'!I79>0,('Input and output'!I79*(('Input and output'!I8*'Input and output'!I75))),0)","v":0},null,{"$f":"(('Input and output'!K52)*('Input and output'!K8*'Input and output'!K75))+'Input and output'!T51-IF('Input and output'!K79>0,('Input and output'!K79*(('Input and output'!K8*'Input and output'!K75))),0)","v":0},null,{"$f":"(('Input and output'!M52)*('Input and output'!M8*'Input and output'!M75))+'Input and output'!V51-IF('Input and output'!M79>0,('Input and output'!M79*(('Input and output'!M8*'Input and output'!M75))),0)","v":0},null,null,null,"((equipment operation  + trucking charges ) + animal number x turns per year)) + custom manure application cost -IF % of capacity cutom fed >0 then % capacity of custome fed x trucking charges x no of head x number of turns"]
[null,"Other fixed costs",null,{"$f":"'Input and output'!R11+'Input and output'!R23+'Input and output'!R60+'Input and output'!R64+'Input and output'!I57","v":0},null,{"$f":"'Input and output'!T11+'Input and output'!T23+'Input and output'!T60+'Input and output'!T64+'Input and output'!K57","v":0},null,{"$f":"'Input and output'!V11+'Input and output'!V23+'Input and output'!V60+'Input and output'!V64+'Input and output'!M57","v":0},null,null,null,"tax and insurace  + annual land rent + tax and insurance on additional feed storage or equipetment + (equipment ownership x head per year)"]
[null,"Total Costs (one year period)",null,{"$f":"SUM(D20:D31)","v":1196940.0635294118},null,{"$f":"SUM(F20:F31)","v":1354464.8005357143},null,{"$f":"SUM(H20:H31)","v":1355207.5913760504}]
[]
[null,"Net Return (with manure value)",null,{"$f":"D16-D32","v":1712636.3188235289},null,{"$f":"F16-F32","v":1623210.6994642857},null,{"$f":"H16-H32","v":1614546.7615651265}]
[]
[null,"Net Return (without manure)",null,{"$f":"(D13+D14)-D32","v":1672082.3188235289},null,{"$f":"(F13+F14)-F32","v":1563600.6994642857},null,{"$f":"(H13+H14)-H32","v":1571031.7615651265}]
[null,null,null,null," "]
[null,"Return on equity ",null,{"$f":"IF('Input and output'!R18=0,0,(D34/('Input and output'!R18+'Input and output'!R65)))","v":4.7573231078431357},null,{"$f":"IF('Input and output'!T18=0,0,(F34/('Input and output'!T18+'Input and output'!T65)))","v":1.8035674438492064},null,{"$f":"IF('Input and output'!V18=0,0,(H34/('Input and output'!V18+'Input and output'!V65)))","v":1.6559453964770527}]
[null,"Return on investment ",null,{"$f":"(D34/('Input and output'!R10+'Input and output'!R59))","v":4.7573231078431357},null,{"$f":"(F34/('Input and output'!T10+'Input and output'!T59))","v":1.8035674438492064},null,{"$f":"(H34/('Input and output'!V10+'Input and output'!V59))","v":1.6559453964770527}]
[null,"Assest turnover",null,{"$f":"D16/('Input and output'!R10+'Input and output'!R59)","v":8.0821566176470583},null,{"$f":"F16/('Input and output'!T10+'Input and output'!T59)","v":3.3085283333333333},null,{"$f":"H16/('Input and output'!V10+'Input and output'!V59)","v":3.0459019004524892}]
[null,"Investment per dollar of gross income",null,{"$f":"('Input and output'!R10+'Input and output'!R59)/D16","v":0.12372935186835417},null,{"$f":"('Input and output'!T10+'Input and output'!T59)/F16","v":0.30224918732749756},null,{"$f":"('Input and output'!V10+'Input and output'!V59)/H16","v":0.32830998262007166}]
[null,"$ Net return per dollar investment",null,{"$f":"IF(-D34>('Input and output'!R10+'Input and output'!R59),(1+((D34+D29/2+D20)/('Input and output'!R10+'Input and output'!R59))),((D34+D29/2+D20)/('Input and output'!R10+'Input and output'!R59)))","v":4.8380731078431358},null,{"$f":"IF(-F34>('Input and output'!T10+'Input and output'!T59),(1+((F34+F29/2+F20)/('Input and output'!T10+'Input and output'!T59))),((F34+F29/2+F20)/('Input and output'!T10+'Input and output'!T59)))","v":1.8990023917658732},null,{"$f":"IF(-H34>('Input and output'!V10+'Input and output'!V59),(1+((H34+H29/2+H20)/('Input and output'!V10+'Input and output'!V59))),((H34+H29/2+H20)/('Input and output'!V10+'Input and output'!V59)))","v":1.7502507330155144}]

{"sheet":"Feed Cost per Ton Calculation","index":4,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[28,1,29,1],[28,2,29,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[1,4,2,9],[4,2,4,5],[5,2,5,5],[6,2,6,5],[28,8,29,8],[28,9,29,9],[9,7,10,7],[9,8,10,8],[9,9,10,9],[28,6,29,6],[28,7,29,7],[9,6,10,6]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Input and output'!M1","v":"North Dakota"}]
[null,null,null,null,"NATURAL RESOURCES CONSERVATION SERVICE                                                              OPEN LOT VS CONFINEMENT BARN ECONOMIC ANALYSIS TOOL",null,null,null,null,null,{"$f":"'Input and output'!M2","v":"2023-10-12"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Input and output'!M3","v":"Version 1.0"}]
[]
[null,null,{"$f":"IF(TRUE, \"\",'Input and output'!C5)","v":""}]
[null,"Producer:",{"$f":"IF(Producer=\"\",\"\",Producer)","v":""}]
[null,"Legal Desc:",{"$f":"IF(Legal=\"\",\"\",Legal)","v":""}]
[null,"Field Office:",{"$f":"IF(FO=\"\",\"\",FO)","v":""}]
[null,"Percent of Ration on Dry Matter (DM) basis"]
[null,"Feedstuff","Lbs. / unit","Cost/unit","DM % of feedstuff","% of ration on DM basis","% of ration on as fed","lbs DM","lbs as fed"]
[]
[null,"Corn",56,5.3,0.85,0.57999999999999996,{"$f":"I12/I$22","v":0.47977941176470584},{"$f":"100*F12","v":57.999999999999993},{"$f":"H12/E12","v":68.235294117647058},{"$f":"I12*(D12/C12)","v":6.4579831932773102}]
[null,"Distillers",1500,200,0.5,0.3,{"$f":"I13/I$22","v":0.421875},{"$f":"100*F13","v":30},{"$f":"H13/E13","v":60},{"$f":"I13*(D13/C13)","v":8}]
[null,"Hay ",2000,100,0.85,0.1,8.2720588235294115E-2,{"$f":"100*F14","v":10},{"$f":"H14/E14","v":11.764705882352942},{"$f":"I14*(D14/C14)","v":0.58823529411764708}]
[null,"Corn Silage",2000,40,0.4,null,0,{"$f":"100*F15","v":0},{"$f":"H15/E15","v":0},{"$f":"I15*(D15/C15)","v":0}]
[null,"Supplement",100,500,0.9,0.02,1.5625E-2,{"$f":"100*F16","v":2},{"$f":"H16/E16","v":2.2222222222222223},{"$f":"I16*(D16/C16)","v":11.111111111111111}]
[null,"Haylage",null,80,null,null,0]
[null,"Pasture",null,32,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F12:F21)","v":0.99999999999999989},{"$f":"SUM(G12:G21)","v":1},{"$f":"SUM(H12:H16)","v":100},{"$f":"SUM(I12:I16)","v":142.22222222222223},{"$f":"SUM(J12:J16)","v":26.157329598506067}]
[]
[null,null,null,null,null,null,null,"Ration DM",{"$f":"H22/I22","v":0.703125}," "]
[null,null,null,null,null,null,"         Ration cost /ton of DM",null,{"$f":"J22/100*2000","v":523.14659197012134}]
[null,null,null,null,null,null,"         Ration cost/ ton as fed",null,{"$f":"J22/I22*2000","v":367.83744747899158}]
[]
[null,"Percentage of ration on As Fed basis"]
[null,"Feedstuff","Lbs. / unit","Cost/unit","DM % of feedstuff","% of ration on DM basis","% of ration on as fed","lbs DM","lbs as fed"]
[]
[null,"Corn",56,4,0.85,0.4798,{"$f":"I31/I$41","v":0.58003313824907743},{"$f":"100*F31","v":47.980000000000004},{"$f":"H31*E31","v":40.783000000000001},{"$f":"H31*(D31/C31)","v":3.427142857142857}]
[null,"Wet distillers",2000,75,0.5,0.4219,0.3000220447579699,{"$f":"100*F32","v":42.19},{"$f":"H32*E32","v":21.094999999999999},{"$f":"H32*(D32/C32)","v":1.5821249999999998}]
[null,"Hay ",2000,125,0.85,8.2699999999999996E-2,9.9976532999580439E-2,8.27,{"$f":"H33*E33","v":7.0294999999999996},{"$f":"H33*(D33/C33)","v":0.51687499999999997}]
[null,"Corn Silage",2000,40,0.4,0,0,0,{"$f":"H34*E34","v":0},{"$f":"H34*(D34/C34)","v":0}]
[null,"Supplement",100,25,0.9,1.5599999999999999E-2,1.996828399337235E-2,1.5599999999999998,{"$f":"H35*E35","v":1.4039999999999999},{"$f":"H35*(D35/C35)","v":0.38999999999999996}]
[null,"Haylage",null,80,null,null,0]
[null,"Pasture",null,32,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F31:F40)","v":0.99999999999999989},{"$f":"SUM(G31:G40)","v":1},99.999999999999986,{"$f":"SUM(I31:I35)","v":70.311499999999995},{"$f":"SUM(J31:J35)","v":5.916142857142856}]
[]
[null,null,null,null,null,null,null,"Ration DM",{"$f":"I41/H41","v":0.70311500000000005}]
[null,null,null,null,null,null,"         Ration cost /ton of DM",null,{"$f":"J41/I41*2000","v":168.28379019485735}]
[null,null,null,null,null,null,"         Ration cost/ ton as fed",null,{"$f":"I44*I43","v":118.32285714285713}]