{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","Title","User Page","Equipment","Litter","Fertilizer","Comparison"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":27,"comments":6,"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":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[]
[null,"To Do List 8.20.20"]
[]
[]
[null,"Comparison page chart? Visual?"]
[null,"Save Macro"]
[null,"comments"]
[null,"To  reset whole sheet, need to go to each sheet and reset to default each using the back button"]
[null,"Disclaimer sheet similar to beginning of forcap"]
[null,"Call the macros that calculate results. Need to figure this out"]
[]
[]
[]
[]
[]
[null,"Notes for using this decision support tool"]
[]
[null,"1). Start on the \"user page\" and work your way using the blue arrows towards the comparison tab which will show you your results."]

{"sheet":"Title","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[18,3,18,14],[28,1,37,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Written and developed by James Tim Stults and Dr. Michael Popp"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"© Copyright Reserved."]
[]
[null,"Disclaimer: The information provided within represents estimates that are a result of a set of complex calculations that are described in more detail in information provided on the download site. Changes in parameter values and its implications on profitability differences are estimates. The user should use their own reasonable judgment to determine whether results are appropriate before acting on the results. As such, this software is provided ‘as is’ and without warranties as to performance of merchantability. Further, statements may have been made to you about this software. Any such statements do not constitute warranties and shall not be relied on by the user in deciding whether to use the program or act on its results. This program is provided without any expressed or implied warranties whatsoever. Because the diversity of conditions and hardware under which this program may be used, no warranty of merchantability or warranty of fitness for a particular purpose is offered. The user is advised to test the program thoroughly before relying on it. The user assumes the entire risk of using the program. The University of Arkansas will not be liable for any claim or damage brought against the user by any third party, nor will the University of Arkansas be liable for any consequential, indirect or special damages suffered by the user as a result of the software."]

{"sheet":"User Page","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[23,1,23,5],[9,4,10,4],[9,5,10,5],[29,4,30,4],[29,5,30,5]]}
[]
[]
[]
[]
[null,"Acres Fertilized",300,null,"Fertilizer Cost","$/ton"]
[null,null,"$/ton",null,"Price of Urea (46 - 0 - 0)",400.63636363636357]
[null,"Cost of Litter",45,null,"Price of Triple Super Phosphate (0 - 46 - 0)",456.94545454545454]
[null,"Litter Nutrient Analysis","in %",null,"Price of Muriate of Potash (0 - 0 - 60)",473.0181818181818]
[null,"Nitrogen",3,null,null,"$/order"]
[null,"Phosphate",3,null,"Any additional fees incurred to get the fertilizer to the farm?",0]
[null,"Potash",2.5]
[]
[null,"Desired Nutrient Application Rate"," (lbs./acre/year)",null,"Labor Charges","$/hr"]
[null,"Nitrogen",60,null,"Operator 1",20]
[null,"Phosphate",40,null,"Operator 2",15]
[null,"Potash",60,null,"Operator 3",10]
[]
[null,"Interest Rates","% annual",null,"Diesel Fuel Price ($/gal)",2]
[null,"Capital recovery rate",0.06]
[]
[null,null,null,null,null,null,null,true]
[]
[]
[null,"Default Information"]
[null,"Acres Fertilized",300,null,"Fertilizer Cost","$/ton"]
[null,null,"$/ton",null,"Price of Urea (46 - 0 - 0)",{"$f":"Fertilizer!$AU$27","v":400.63636363636357}]
[null,"Cost of Litter",35,null,"Price of Triple Super Phosphate (0 - 46 - 0)",{"$f":"Fertilizer!$AV$27","v":456.94545454545454}]
[null,"Litter Nutrient Analysis","in %",null,"Price of Muriate of Potash (0 - 0 - 60)",{"$f":"Fertilizer!$AW$27","v":473.0181818181818}]
[null,"Nitrogen",3,null,null,"$/order"]
[null,"Phosphate",3,null,"Any additional fees incurred to get the fertilizer to the farm?",0]
[null,"Potash",2.5]
[]
[null,"Desired Nutrient Application Rate"," (lbs./acre/year)",null,"Labor Charges","$/hr"]
[null,"Nitrogen",60,null,"Operator 1",20]
[null,"Phosphate",40,null,"Operator 2",15]
[null,"Potash",60,null,"Operator 3",10]
[]
[null,"Interest Rates","% annual",null,"Diesel Fuel Price ($/gal)",2]
[null,"Capital recovery rate",0.06]

{"sheet":"Equipment","index":3,"n_rows":108,"n_cols":60,"rows_kept":108,"cut":false,"hidden":false,"merged":[[49,34,49,35],[5,4,6,4],[1,2,1,27],[144,34,144,35]]}
[]
[null,null,"Specification of Equipment Choices",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,null,null,null,null,null,null,null,true,"Temporary flag to turn off autoupdate",null,null,null,null,null,"Insurance (% of avg. value)","Property Taxes (% of avg. value)"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.4999999999999997E-3,7.4999999999999997E-3]
[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,null,null,null,null,null,null,null,null,null,{"$f":"OR(AK6,AK7,AK8,AK9,AK11,AK12)","v":false}]
[null,null,null,null,null,"Equipment Type (Changes load defaults)","Name","Rent/Lease, Custom activity, or Owned?","Rental/Lease Fee in $/hr or Custom Rate in $/acre","Age of Equipment at time of purchase (years)","Existing hours on equipment (at time of purchase)","Annual hours of usage","Default List Price (New)","Est. Purchase Price","Remaining Useful Life (Years)","Expected Salvage Value (w/o inflation)","Capital Recovery Factor","Annual Capital Recovery","Repair Factor (% of list price over useful life)","Annual Repair & Maintenance",{"$f":"CONCATENATE(\"Yearly Insurance (\",ROUND($AS$3*100,2),\" % of avg. value)\")","v":"Yearly Insurance (0.55 % of avg. value)"},{"$f":"CONCATENATE(\"Yearly Property Tax (\",ROUND($AT$3*100,2),\" % of avg. value)\")","v":"Yearly Property Tax (0.75 % of avg. value)"},"Ownership Cost per hour","C1","C2","C3","Min HP","Useful Life in hours",null,null,null,null,null,null,null,null,"Not Saved?","Equipment Type","Name","Rent/Lease, Custom activity, or Owned?","Rental/Lease Fee per hour","Age of Equipment at time of purchase (years)","Existing hours on equipment (at time of purchase)","Annual hours of usage","Default List Price (New)","Est. Purchase Price","Remaining Useful Life (Years)","Expected Salvage Value (w/o inflation)","Capital Recovery Factor","Capital Recovery","Repair Factor (% of list price over useful life)","Annual Repair & Maintenance",{"$f":"CONCATENATE(\"Insurance (\",ROUND($AS$3*100,2),\" % of avg. value)\")","v":"Insurance (0.55 % of avg. value)"},{"$f":"CONCATENATE(\"Property Tax (\",ROUND($AT$3*100,2),\" % of avg. value)\")","v":"Property Tax (0.75 % of avg. value)"},"Ownership Cost per hour","C1","C2","C3","Min HP","Useful Life in hours"]
[null,null,null,null,"Tractors","MFWD55",{"$f":"VLOOKUP($F6,$F$48:$V$66,2,FALSE)","v":"John Deere 5055e 4wd"},"Owned",{"$f":"IF(H6=\"Owned\",\"N/A\",IF(H6=\"Custom\",VLOOKUP(F6,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,7,FALSE),\"N/A\")","v":600},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,8,FALSE),\"N/A\")","v":33000},{"$f":"IF(H6=\"Owned\",IF(J6>0,M6*(X6-Y6*J6^0.5-Z6*(K6/J6)^0.5)^2,M6),\"N/A\")","v":33000},{"$f":"IF(H6=\"Owned\",IF((IF(((AB6-K6)/L6)>20,20,((AB6-K6)/L6))-J6)<0,0,(IF(((AB6-K6)/L6)>20,20,((AB6-K6)/L6))-J6)),\"N/A\")","v":20},{"$f":"IF(H6=\"Owned\",N6*((X6-Y6*(O6^0.5)-Z6*(L6^0.5)))^2,\"N/A\")","v":5905.241927396024},{"$f":"IF(H6=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O6)/(((1+'User Page'!$C$19)^O6)-1),\"N/A\")","v":8.7184556976851402E-2},{"$f":"IF(H6=\"Owned\",((N6-P6)*Q6)+(P6*'User Page'!$C$19),\"N/A\")","v":2716.5589945987072},{"$f":"VLOOKUP($F6,$F$48:$V$66,12,FALSE)","v":0.8},{"$f":"IF(H6=\"Owned\",S6*M6/IF(((AB6-K6)/L6)>20,20,((AB6-K6)/L6)),0)","v":1320},{"$f":"IF(H6=\"Owned\",$AS$3*AVERAGE(N6,P6),0)","v":106.98941530033906},{"$f":"IF(H6=\"Owned\",$AT$3*AVERAGE(N6,P6),0)","v":145.89465722773508},{"$f":"IF(H6=\"Owned\",(R6+T6+U6+V6)/L6,\"N/A\")","v":7.1490717785446369},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.98099999999999998},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,14,FALSE),\"N/A\")","v":9.2999999999999999E-2},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,15,FALSE),\"N/A\")","v":5.7999999999999996E-3},{"$f":"VLOOKUP($F6,$F$48:$V$66,16,FALSE)","v":"-"},{"$f":"VLOOKUP($F6,$F$48:$V$66,17,FALSE)","v":16000},null,null,null,null,null,null,null,null,{"$f":"IF(AND(F6=AL6,G6=AM6,H6=AN6,I6=AO6,J6=AP6,K6=AQ6,L6=AR6,M6=AS6,N6=AT6,O6=AU6,P6=AV6,Q6=AW6,R6=AX6,S6=AY6,T6=AZ6,U6=BA6,V6=BB6,W6=BC6,X6=BD6,Y6=BE6,Z6=BF6,AA6=BG6,AB6=BH6),FALSE,TRUE)","v":false},"MFWD55",{"$f":"VLOOKUP($F6,$F$48:$V$66,2,FALSE)","v":"John Deere 5055e 4wd"},"Owned",{"$f":"IF(H6=\"Owned\",\"N/A\",IF(H6=\"Custom\",VLOOKUP(F6,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,7,FALSE),\"N/A\")","v":600},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,8,FALSE),\"N/A\")","v":33000},{"$f":"IF(H6=\"Owned\",IF(J6>0,M6*(X6-Y6*J6^0.5-Z6*(K6/J6)^0.5)^2,M6),\"N/A\")","v":33000},{"$f":"IF(H6=\"Owned\",IF((IF(((AB6-K6)/L6)>20,20,((AB6-K6)/L6))-J6)<0,0,(IF(((AB6-K6)/L6)>20,20,((AB6-K6)/L6))-J6)),\"N/A\")","v":20},{"$f":"IF(H6=\"Owned\",N6*((X6-Y6*(O6^0.5)-Z6*(L6^0.5)))^2,\"N/A\")","v":5905.241927396024},{"$f":"IF(H6=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O6)/(((1+'User Page'!$C$19)^O6)-1),\"N/A\")","v":8.7184556976851402E-2},{"$f":"IF(H6=\"Owned\",((N6-P6)*Q6)+(P6*'User Page'!$C$19),\"N/A\")","v":2716.5589945987072},{"$f":"VLOOKUP($F6,$F$48:$V$66,12,FALSE)","v":0.8},{"$f":"IF(H6=\"Owned\",S6*M6/IF(((AB6-K6)/L6)>20,20,((AB6-K6)/L6)),0)","v":1320},{"$f":"IF(H6=\"Owned\",$AS$3*AVERAGE(N6,P6),0)","v":106.98941530033906},{"$f":"IF(H6=\"Owned\",$AT$3*AVERAGE(N6,P6),0)","v":145.89465722773508},{"$f":"IF(H6=\"Owned\",(R6+T6+U6+V6)/L6,\"N/A\")","v":7.1490717785446369},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.98099999999999998},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,14,FALSE),\"N/A\")","v":9.2999999999999999E-2},{"$f":"IF(H6=\"Owned\",VLOOKUP($F6,$F$48:$V$66,15,FALSE),\"N/A\")","v":5.7999999999999996E-3},{"$f":"VLOOKUP($F6,$F$48:$V$66,16,FALSE)","v":"-"},{"$f":"VLOOKUP($F6,$F$48:$V$66,17,FALSE)","v":16000}]
[null,null,null,null,null,"MFWD110",{"$f":"VLOOKUP($F7,$F$48:$V$66,2,FALSE)","v":"John Deere 6110M 4wd"},"Owned",{"$f":"IF(H7=\"Owned\",\"N/A\",IF(H7=\"Custom\",VLOOKUP(F7,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,7,FALSE),\"N/A\")","v":850},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,8,FALSE),\"N/A\")","v":110000},{"$f":"IF(H7=\"Owned\",IF(J7>0,M7*(X7-Y7*J7^0.5-Z7*(K7/J7)^0.5)^2,M7),\"N/A\")","v":110000},{"$f":"IF(H7=\"Owned\",IF((IF(((AB7-K7)/L7)>20,20,((AB7-K7)/L7))-J7)<0,0,(IF(((AB7-K7)/L7)>20,20,((AB7-K7)/L7))-J7)),\"N/A\")","v":18.823529411764707},{"$f":"IF(H7=\"Owned\",N7*((X7-Y7*(O7^0.5)-Z7*(L7^0.5)))^2,\"N/A\")","v":25855.043786272145},{"$f":"IF(H7=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O7)/(((1+'User Page'!$C$19)^O7)-1),\"N/A\")","v":9.0080503967433306E-2},{"$f":"IF(H7=\"Owned\",((N7-P7)*Q7)+(P7*'User Page'!$C$19),\"N/A\")","v":9131.1226892265422},{"$f":"VLOOKUP($F7,$F$48:$V$66,12,FALSE)","v":0.8},{"$f":"IF(H7=\"Owned\",S7*M7/IF(((AB7-K7)/L7)>20,20,((AB7-K7)/L7)),0)","v":4675},{"$f":"IF(H7=\"Owned\",$AS$3*AVERAGE(N7,P7),0)","v":373.6013704122484},{"$f":"IF(H7=\"Owned\",$AT$3*AVERAGE(N7,P7),0)","v":509.45641419852052},{"$f":"IF(H7=\"Owned\",(R7+T7+U7+V7)/L7,\"N/A\")","v":17.28138879274978},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.94199999999999995},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,14,FALSE),\"N/A\")","v":0.1},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,15,FALSE),\"N/A\")","v":8.0000000000000004E-4},{"$f":"VLOOKUP($F7,$F$48:$V$66,16,FALSE)","v":"-"},{"$f":"VLOOKUP($F7,$F$48:$V$66,17,FALSE)","v":16000},null,null,null,null,null,null,null,null,{"$f":"IF(AND(F7=AL7,G7=AM7,H7=AN7,I7=AO7,J7=AP7,K7=AQ7,L7=AR7,M7=AS7,N7=AT7,O7=AU7,P7=AV7,Q7=AW7,R7=AX7,S7=AY7,T7=AZ7,U7=BA7,V7=BB7,W7=BC7,X7=BD7,Y7=BE7,Z7=BF7,AA7=BG7,AB7=BH7),FALSE,TRUE)","v":false},"MFWD110",{"$f":"VLOOKUP($F7,$F$48:$V$66,2,FALSE)","v":"John Deere 6110M 4wd"},"Owned",{"$f":"IF(H7=\"Owned\",\"N/A\",IF(H7=\"Custom\",VLOOKUP(F7,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,7,FALSE),\"N/A\")","v":850},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,8,FALSE),\"N/A\")","v":110000},{"$f":"IF(H7=\"Owned\",IF(J7>0,M7*(X7-Y7*J7^0.5-Z7*(K7/J7)^0.5)^2,M7),\"N/A\")","v":110000},{"$f":"IF(H7=\"Owned\",IF((IF(((AB7-K7)/L7)>20,20,((AB7-K7)/L7))-J7)<0,0,(IF(((AB7-K7)/L7)>20,20,((AB7-K7)/L7))-J7)),\"N/A\")","v":18.823529411764707},{"$f":"IF(H7=\"Owned\",N7*((X7-Y7*(O7^0.5)-Z7*(L7^0.5)))^2,\"N/A\")","v":25855.043786272145},{"$f":"IF(H7=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O7)/(((1+'User Page'!$C$19)^O7)-1),\"N/A\")","v":9.0080503967433306E-2},{"$f":"IF(H7=\"Owned\",((N7-P7)*Q7)+(P7*'User Page'!$C$19),\"N/A\")","v":9131.1226892265422},{"$f":"VLOOKUP($F7,$F$48:$V$66,12,FALSE)","v":0.8},{"$f":"IF(H7=\"Owned\",S7*M7/IF(((AB7-K7)/L7)>20,20,((AB7-K7)/L7)),0)","v":4675},{"$f":"IF(H7=\"Owned\",$AS$3*AVERAGE(N7,P7),0)","v":373.6013704122484},{"$f":"IF(H7=\"Owned\",$AT$3*AVERAGE(N7,P7),0)","v":509.45641419852052},{"$f":"IF(H7=\"Owned\",(R7+T7+U7+V7)/L7,\"N/A\")","v":17.28138879274978},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.94199999999999995},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,14,FALSE),\"N/A\")","v":0.1},{"$f":"IF(H7=\"Owned\",VLOOKUP($F7,$F$48:$V$66,15,FALSE),\"N/A\")","v":8.0000000000000004E-4},{"$f":"VLOOKUP($F7,$F$48:$V$66,16,FALSE)","v":"-"},{"$f":"VLOOKUP($F7,$F$48:$V$66,17,FALSE)","v":16000}]
[null,null,null,null,"Manure","Litter Drill (5 ton)",{"$f":"VLOOKUP($F8,$F$48:$V$66,2,FALSE)","v":"Litter Drill"},"Owned",{"$f":"IF(H8=\"Owned\",\"N/A\",IF(H8=\"Custom\",VLOOKUP(F8,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(Litter!H54/Litter!B14=0,50,Litter!H54/Litter!B14)","v":50},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,8,FALSE),\"N/A\")","v":65000},{"$f":"IF(H8=\"Owned\",IF(J8>0,M8*(X8-Y8*J8^0.5-Z8*(K8/J8)^0.5)^2,M8),\"N/A\")","v":65000},{"$f":"IF(H8=\"Owned\",IF((IF(((AB8-K8)/L8)>20,20,((AB8-K8)/L8))-J8)<0,0,(IF(((AB8-K8)/L8)>20,20,((AB8-K8)/L8))-J8)),\"N/A\")","v":20},{"$f":"IF(H8=\"Owned\",N8*((X8-Y8*(O8^0.5)-Z8*(L8^0.5)))^2,\"N/A\")","v":18547.17907059666},{"$f":"IF(H8=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O8)/(((1+'User Page'!$C$19)^O8)-1),\"N/A\")","v":8.7184556976851402E-2},{"$f":"IF(H8=\"Owned\",((N8-P8)*Q8)+(P8*'User Page'!$C$19),\"N/A\")","v":5162.7993572908408},{"$f":"VLOOKUP($F8,$F$48:$V$66,12,FALSE)","v":0.5},{"$f":"IF(H8=\"Owned\",S8*M8/IF(((AB8-K8)/L8)>20,20,((AB8-K8)/L8)),0)","v":1625},{"$f":"IF(H8=\"Owned\",$AS$3*AVERAGE(N8,P8),0)","v":229.75474244414079},{"$f":"IF(H8=\"Owned\",$AT$3*AVERAGE(N8,P8),0)","v":313.30192151473744},{"$f":"IF(H8=\"Owned\",(R8+T8+U8+V8)/L8,\"N/A\")","v":146.6171204249944},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.88300000000000001},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,14,FALSE),\"N/A\")","v":7.8E-2},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,15,FALSE),\"N/A\")","v":0},{"$f":"VLOOKUP($F8,$F$48:$V$66,16,FALSE)","v":100},{"$f":"VLOOKUP($F8,$F$48:$V$66,17,FALSE)","v":2500},null,null,null,null,null,null,null,null,false,"Litter Drill (5 ton)",{"$f":"VLOOKUP($F8,$F$48:$V$66,2,FALSE)","v":"Litter Drill"},"Owned",{"$f":"IF(H8=\"Owned\",\"N/A\",IF(H8=\"Custom\",VLOOKUP(F8,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(Litter!H54/Litter!B14=0,50,Litter!H54/Litter!B14)","v":50},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,8,FALSE),\"N/A\")","v":65000},{"$f":"IF(H8=\"Owned\",IF(J8>0,M8*(X8-Y8*J8^0.5-Z8*(K8/J8)^0.5)^2,M8),\"N/A\")","v":65000},{"$f":"IF(H8=\"Owned\",IF((IF(((AB8-K8)/L8)>20,20,((AB8-K8)/L8))-J8)<0,0,(IF(((AB8-K8)/L8)>20,20,((AB8-K8)/L8))-J8)),\"N/A\")","v":20},{"$f":"IF(H8=\"Owned\",N8*((X8-Y8*(O8^0.5)-Z8*(L8^0.5)))^2,\"N/A\")","v":18547.17907059666},{"$f":"IF(H8=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O8)/(((1+'User Page'!$C$19)^O8)-1),\"N/A\")","v":8.7184556976851402E-2},{"$f":"IF(H8=\"Owned\",((N8-P8)*Q8)+(P8*'User Page'!$C$19),\"N/A\")","v":5162.7993572908408},{"$f":"VLOOKUP($F8,$F$48:$V$66,12,FALSE)","v":0.5},{"$f":"IF(H8=\"Owned\",S8*M8/IF(((AB8-K8)/L8)>20,20,((AB8-K8)/L8)),0)","v":1625},{"$f":"IF(H8=\"Owned\",$AS$3*AVERAGE(N8,P8),0)","v":229.75474244414079},{"$f":"IF(H8=\"Owned\",$AT$3*AVERAGE(N8,P8),0)","v":313.30192151473744},{"$f":"IF(H8=\"Owned\",(R8+T8+U8+V8)/L8,\"N/A\")","v":146.6171204249944},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.88300000000000001},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,14,FALSE),\"N/A\")","v":7.8E-2},{"$f":"IF(H8=\"Owned\",VLOOKUP($F8,$F$48:$V$66,15,FALSE),\"N/A\")","v":0},{"$f":"VLOOKUP($F8,$F$48:$V$66,16,FALSE)","v":100},{"$f":"VLOOKUP($F8,$F$48:$V$66,17,FALSE)","v":2500}]
[null,null,null,null,"Fertilizer\n(Farmer applied)","Fertilzer Spreader (4 ton)",{"$f":"VLOOKUP($F9,$F$48:$V$66,2,FALSE)","v":"BBI Spreader"},"Rent/Lease",0,{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,5,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,6,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,7,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,8,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",IF(J9>0,M9*(X9-Y9*J9^0.5-Z9*(K9/J9)^0.5)^2,M9),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",IF((IF(((AB9-K9)/L9)>20,20,((AB9-K9)/L9))-J9)<0,0,(IF(((AB9-K9)/L9)>20,20,((AB9-K9)/L9))-J9)),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",N9*((X9-Y9*(O9^0.5)-Z9*(L9^0.5)))^2,\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O9)/(((1+'User Page'!$C$19)^O9)-1),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",((N9-P9)*Q9)+(P9*'User Page'!$C$19),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F9,$F$48:$V$66,12,FALSE)","v":0.35},{"$f":"IF(H9=\"Owned\",S9*M9/IF(((AB9-K9)/L9)>20,20,((AB9-K9)/L9)),0)","v":0},{"$f":"IF(H9=\"Owned\",$AS$3*AVERAGE(N9,P9),0)","v":0},{"$f":"IF(H9=\"Owned\",$AT$3*AVERAGE(N9,P9),0)","v":0},{"$f":"IF(H9=\"Owned\",(R9+T9+U9+V9)/L9,\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,13,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,14,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,15,FALSE),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F9,$F$48:$V$66,16,FALSE)","v":45},{"$f":"VLOOKUP($F9,$F$48:$V$66,17,FALSE)","v":1500},null,null,null,null,null,null,null,null,false,"Fertilzer Spreader (4 ton)",{"$f":"VLOOKUP($F9,$F$48:$V$66,2,FALSE)","v":"BBI Spreader"},"Rent/Lease",0,{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,5,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,6,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,7,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,8,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",IF(J9>0,M9*(X9-Y9*J9^0.5-Z9*(K9/J9)^0.5)^2,M9),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",IF((IF(((AB9-K9)/L9)>20,20,((AB9-K9)/L9))-J9)<0,0,(IF(((AB9-K9)/L9)>20,20,((AB9-K9)/L9))-J9)),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",N9*((X9-Y9*(O9^0.5)-Z9*(L9^0.5)))^2,\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O9)/(((1+'User Page'!$C$19)^O9)-1),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",((N9-P9)*Q9)+(P9*'User Page'!$C$19),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F9,$F$48:$V$66,12,FALSE)","v":0.35},{"$f":"IF(H9=\"Owned\",S9*M9/IF(((AB9-K9)/L9)>20,20,((AB9-K9)/L9)),0)","v":0},{"$f":"IF(H9=\"Owned\",$AS$3*AVERAGE(N9,P9),0)","v":0},{"$f":"IF(H9=\"Owned\",$AT$3*AVERAGE(N9,P9),0)","v":0},{"$f":"IF(H9=\"Owned\",(R9+T9+U9+V9)/L9,\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,13,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,14,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H9=\"Owned\",VLOOKUP($F9,$F$48:$V$66,15,FALSE),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F9,$F$48:$V$66,16,FALSE)","v":45},{"$f":"VLOOKUP($F9,$F$48:$V$66,17,FALSE)","v":1500}]
[]
[null,null,null,null,"Custom\nWork","Custom spread fertilizer",{"$f":"VLOOKUP($F11,$F$48:$V$66,2,FALSE)","v":"Custom spread fertilizer"},"Custom",{"$f":"IF(H11=\"Owned\",\"N/A\",IF(H11=\"Custom\",VLOOKUP(F11,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":7},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,5,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,6,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,7,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,8,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",IF(J11>0,M11*(X11-Y11*J11^0.5-Z11*(K11/J11)^0.5)^2,M11),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",IF((IF(((AB11-K11)/L11)>20,20,((AB11-K11)/L11))-J11)<0,0,(IF(((AB11-K11)/L11)>20,20,((AB11-K11)/L11))-J11)),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",N11*((X11-Y11*(O11^0.5)-Z11*(L11^0.5)))^2,\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O11)/(((1+'User Page'!$C$19)^O11)-1),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",((N11-P11)*Q11)+(P11*'User Page'!$C$19),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F11,$F$48:$V$66,12,FALSE)","v":"N/A"},{"$f":"IF(H11=\"Owned\",S11*M11/IF(((AB11-K11)/L11)>20,20,((AB11-K11)/L11)),0)","v":0},{"$f":"IF(H11=\"Owned\",$AS$3*AVERAGE(N11,P11),0)","v":0},{"$f":"IF(H11=\"Owned\",$AT$3*AVERAGE(N11,P11),0)","v":0},{"$f":"IF(H11=\"Owned\",(R11+T11+U11+V11)/L11,\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,13,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,14,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,15,FALSE),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F11,$F$48:$V$66,16,FALSE)","v":"N/A"},{"$f":"VLOOKUP($F11,$F$48:$V$66,17,FALSE)","v":"N/A"},null,null,null,null,null,null,null,null,{"$f":"IF(AND(F11=AL11,G11=AM11,H11=AN11,I11=AO11,J11=AP11,K11=AQ11,L11=AR11,M11=AS11,N11=AT11,O11=AU11,P11=AV11,Q11=AW11,R11=AX11,S11=AY11,T11=AZ11,U11=BA11,V11=BB11,W11=BC11,X11=BD11,Y11=BE11,Z11=BF11,AA11=BG11,AB11=BH11),FALSE,TRUE)","v":false},"Custom spread fertilizer",{"$f":"VLOOKUP($F11,$F$48:$V$66,2,FALSE)","v":"Custom spread fertilizer"},"Custom",{"$f":"IF(H11=\"Owned\",\"N/A\",IF(H11=\"Custom\",VLOOKUP(F11,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":7},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,5,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,6,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,7,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,8,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",IF(J11>0,M11*(X11-Y11*J11^0.5-Z11*(K11/J11)^0.5)^2,M11),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",IF((IF(((AB11-K11)/L11)>20,20,((AB11-K11)/L11))-J11)<0,0,(IF(((AB11-K11)/L11)>20,20,((AB11-K11)/L11))-J11)),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",N11*((X11-Y11*(O11^0.5)-Z11*(L11^0.5)))^2,\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O11)/(((1+'User Page'!$C$19)^O11)-1),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",((N11-P11)*Q11)+(P11*'User Page'!$C$19),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F11,$F$48:$V$66,12,FALSE)","v":"N/A"},{"$f":"IF(H11=\"Owned\",S11*M11/IF(((AB11-K11)/L11)>20,20,((AB11-K11)/L11)),0)","v":0},{"$f":"IF(H11=\"Owned\",$AS$3*AVERAGE(N11,P11),0)","v":0},{"$f":"IF(H11=\"Owned\",$AT$3*AVERAGE(N11,P11),0)","v":0},{"$f":"IF(H11=\"Owned\",(R11+T11+U11+V11)/L11,\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,13,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,14,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H11=\"Owned\",VLOOKUP($F11,$F$48:$V$66,15,FALSE),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F11,$F$48:$V$66,16,FALSE)","v":"N/A"},{"$f":"VLOOKUP($F11,$F$48:$V$66,17,FALSE)","v":"N/A"}]
[null,null,null,null,"User\nSpecified","Miscellaneous","Loader","Owned",{"$f":"IF(H12=\"Owned\",\"N/A\",IF(H12=\"Custom\",VLOOKUP(F12,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},1,250,500,5000,{"$f":"IF(H12=\"Owned\",IF(J12>0,M12*(X12-Y12*J12^0.5-Z12*(K12/J12)^0.5)^2,M12),\"N/A\")","v":3461.12},{"$f":"IF(H12=\"Owned\",IF((IF(((AB12-K12)/L12)>20,20,((AB12-K12)/L12))-J12)<0,0,(IF(((AB12-K12)/L12)>20,20,((AB12-K12)/L12))-J12)),\"N/A\")","v":8.5},{"$f":"IF(H12=\"Owned\",N12*((X12-Y12*(O12^0.5)-Z12*(L12^0.5)))^2,\"N/A\")","v":1327.8042525805561},{"$f":"IF(H12=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O12)/(((1+'User Page'!$C$19)^O12)-1),\"N/A\")","v":0.1536085592763016},{"$f":"IF(H12=\"Owned\",((N12-P12)*Q12)+(P12*'User Page'!$C$19),\"N/A\")","v":407.36381359738073},{"$f":"VLOOKUP($F12,$F$48:$V$66,12,FALSE)","v":0.35},{"$f":"IF(H12=\"Owned\",S12*M12/IF(((AB12-K12)/L12)>20,20,((AB12-K12)/L12)),0)","v":184.21052631578948},{"$f":"IF(H12=\"Owned\",$AS$3*AVERAGE(N12,P12),0)","v":13.169541694596527},{"$f":"IF(H12=\"Owned\",$AT$3*AVERAGE(N12,P12),0)","v":17.958465947177082},{"$f":"IF(H12=\"Owned\",(R12+T12+U12+V12)/L12,\"N/A\")","v":1.2454046951098876},{"$f":"IF(H12=\"Owned\",VLOOKUP($F12,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.94299999999999995},{"$f":"IF(H12=\"Owned\",VLOOKUP($F12,$F$48:$V$66,14,FALSE),\"N/A\")","v":0.111},{"$f":"IF(H12=\"Owned\",VLOOKUP($F12,$F$48:$V$66,15,FALSE),\"N/A\")","v":0},{"$f":"VLOOKUP($F12,$F$48:$V$66,16,FALSE)","v":0},5000,null,null,null,null,null,null,null,null,false,"Miscellaneous","Loader","Owned",{"$f":"IF(H12=\"Owned\",\"N/A\",IF(H12=\"Custom\",VLOOKUP(F12,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},1,250,500,5000,{"$f":"IF(H12=\"Owned\",IF(J12>0,M12*(X12-Y12*J12^0.5-Z12*(K12/J12)^0.5)^2,M12),\"N/A\")","v":3461.12},{"$f":"IF(H12=\"Owned\",IF((IF(((AB12-K12)/L12)>20,20,((AB12-K12)/L12))-J12)<0,0,(IF(((AB12-K12)/L12)>20,20,((AB12-K12)/L12))-J12)),\"N/A\")","v":8.5},{"$f":"IF(H12=\"Owned\",N12*((X12-Y12*(O12^0.5)-Z12*(L12^0.5)))^2,\"N/A\")","v":1327.8042525805561},{"$f":"IF(H12=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O12)/(((1+'User Page'!$C$19)^O12)-1),\"N/A\")","v":0.1536085592763016},{"$f":"IF(H12=\"Owned\",((N12-P12)*Q12)+(P12*'User Page'!$C$19),\"N/A\")","v":407.36381359738073},{"$f":"VLOOKUP($F12,$F$48:$V$66,12,FALSE)","v":0.35},{"$f":"IF(H12=\"Owned\",S12*M12/IF(((AB12-K12)/L12)>20,20,((AB12-K12)/L12)),0)","v":184.21052631578948},{"$f":"IF(H12=\"Owned\",$AS$3*AVERAGE(N12,P12),0)","v":13.169541694596527},{"$f":"IF(H12=\"Owned\",$AT$3*AVERAGE(N12,P12),0)","v":17.958465947177082},{"$f":"IF(H12=\"Owned\",(R12+T12+U12+V12)/L12,\"N/A\")","v":1.2454046951098876},{"$f":"IF(H12=\"Owned\",VLOOKUP($F12,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.94299999999999995},{"$f":"IF(H12=\"Owned\",VLOOKUP($F12,$F$48:$V$66,14,FALSE),\"N/A\")","v":0.111},{"$f":"IF(H12=\"Owned\",VLOOKUP($F12,$F$48:$V$66,15,FALSE),\"N/A\")","v":0},{"$f":"VLOOKUP($F12,$F$48:$V$66,16,FALSE)","v":0},5000]
[]
[null,null,null,null,null,"    "]
[]
[]
[]
[]
[null,null,null,null,null,"Equipment Type","Name","Rent/Lease or Owned?","Rental/Lease Fee in $/hr or Custom Rate in $/acre","Age of Equipment at time of purchase (years)","Existing hours on equipment (at time of purchase)","Annual hours of usage","Default List Price (New)","Est. Purchase Price","Remaining Useful Life (Years)","Expected Salvage Value (w/o inflation)","Capital Recovery Factor","Capital Recovery","Repair Factor (% of list price over useful life)","Annual Repair & Maintenance",{"$f":"CONCATENATE(\"Insurance (\",ROUND($AS$3*100,2),\" % of avg. value)\")","v":"Insurance (0.55 % of avg. value)"},{"$f":"CONCATENATE(\"Property Tax (\",ROUND($AT$3*100,2),\" % of avg. value)\")","v":"Property Tax (0.75 % of avg. value)"},"Ownership Cost per hour","C1","C2","C3","Min HP","Useful Life in hours"]
[null,null,null,null,null,{"$f":"+F6","v":"MFWD55"},{"$f":"VLOOKUP($F20,$F$48:$V$66,2,FALSE)","v":"John Deere 5055e 4wd"},"Owned",{"$f":"IF(H20=\"Owned\",\"N/A\",IF(H20=\"Custom\",VLOOKUP(F20,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H20=\"Owned\",VLOOKUP($F20,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H20=\"Owned\",VLOOKUP($F20,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H20=\"Owned\",VLOOKUP($F20,$F$48:$V$66,7,FALSE),\"N/A\")","v":600},{"$f":"IF(H20=\"Owned\",VLOOKUP($F20,$F$48:$V$66,8,FALSE),\"N/A\")","v":33000},{"$f":"IF(H20=\"Owned\",IF(J20>0,M20*(X20-Y20*J20^0.5-Z20*(K20/J20)^0.5)^2,M20),\"N/A\")","v":33000},{"$f":"IF(H20=\"Owned\",IF((IF(((AB20-K20)/L20)>20,20,((AB20-K20)/L20))-J20)<0,0,(IF(((AB20-K20)/L20)>20,20,((AB20-K20)/L20))-J20)),\"N/A\")","v":20},{"$f":"IF(H20=\"Owned\",N20*((X20-Y20*(O20^0.5)-Z20*(L20^0.5)))^2,\"N/A\")","v":5905.241927396024},{"$f":"IF(H20=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O20)/(((1+'User Page'!$C$19)^O20)-1),\"N/A\")","v":8.7184556976851402E-2},{"$f":"IF(H20=\"Owned\",((N20-P20)*Q20)+(P20*'User Page'!$C$19),\"N/A\")","v":2716.5589945987072},{"$f":"VLOOKUP($F20,$F$48:$V$66,12,FALSE)","v":0.8},{"$f":"IF(H20=\"Owned\",S20*M20/IF(((AB20-K20)/L20)>20,20,((AB20-K20)/L20)),0)","v":1320},{"$f":"IF(H20=\"Owned\",$AS$3*AVERAGE(N20,P20),0)","v":106.98941530033906},{"$f":"IF(H20=\"Owned\",$AT$3*AVERAGE(N20,P20),0)","v":145.89465722773508},{"$f":"IF(H20=\"Owned\",(R20+T20+U20+V20)/L20,\"N/A\")","v":7.1490717785446369},{"$f":"IF(H20=\"Owned\",VLOOKUP($F20,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.98099999999999998},{"$f":"IF(H20=\"Owned\",VLOOKUP($F20,$F$48:$V$66,14,FALSE),\"N/A\")","v":9.2999999999999999E-2},{"$f":"IF(H20=\"Owned\",VLOOKUP($F20,$F$48:$V$66,15,FALSE),\"N/A\")","v":5.7999999999999996E-3},{"$f":"VLOOKUP($F20,$F$48:$V$66,16,FALSE)","v":"-"},{"$f":"VLOOKUP($F20,$F$48:$V$66,17,FALSE)","v":16000}]
[null,null,null,null,null,{"$f":"+F7","v":"MFWD110"},{"$f":"VLOOKUP($F21,$F$48:$V$66,2,FALSE)","v":"John Deere 6110M 4wd"},"Owned",{"$f":"IF(H21=\"Owned\",\"N/A\",IF(H21=\"Custom\",VLOOKUP(F21,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":"N/A"},{"$f":"IF(H21=\"Owned\",VLOOKUP($F21,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H21=\"Owned\",VLOOKUP($F21,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H21=\"Owned\",VLOOKUP($F21,$F$48:$V$66,7,FALSE),\"N/A\")","v":850},{"$f":"IF(H21=\"Owned\",VLOOKUP($F21,$F$48:$V$66,8,FALSE),\"N/A\")","v":110000},{"$f":"IF(H21=\"Owned\",IF(J21>0,M21*(X21-Y21*J21^0.5-Z21*(K21/J21)^0.5)^2,M21),\"N/A\")","v":110000},{"$f":"IF(H21=\"Owned\",IF((IF(((AB21-K21)/L21)>20,20,((AB21-K21)/L21))-J21)<0,0,(IF(((AB21-K21)/L21)>20,20,((AB21-K21)/L21))-J21)),\"N/A\")","v":18.823529411764707},{"$f":"IF(H21=\"Owned\",N21*((X21-Y21*(O21^0.5)-Z21*(L21^0.5)))^2,\"N/A\")","v":25855.043786272145},{"$f":"IF(H21=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O21)/(((1+'User Page'!$C$19)^O21)-1),\"N/A\")","v":9.0080503967433306E-2},{"$f":"IF(H21=\"Owned\",((N21-P21)*Q21)+(P21*'User Page'!$C$19),\"N/A\")","v":9131.1226892265422},{"$f":"VLOOKUP($F21,$F$48:$V$66,12,FALSE)","v":0.8},{"$f":"IF(H21=\"Owned\",S21*M21/IF(((AB21-K21)/L21)>20,20,((AB21-K21)/L21)),0)","v":4675},{"$f":"IF(H21=\"Owned\",$AS$3*AVERAGE(N21,P21),0)","v":373.6013704122484},{"$f":"IF(H21=\"Owned\",$AT$3*AVERAGE(N21,P21),0)","v":509.45641419852052},{"$f":"IF(H21=\"Owned\",(R21+T21+U21+V21)/L21,\"N/A\")","v":17.28138879274978},{"$f":"IF(H21=\"Owned\",VLOOKUP($F21,$F$48:$V$66,13,FALSE),\"N/A\")","v":0.94199999999999995},{"$f":"IF(H21=\"Owned\",VLOOKUP($F21,$F$48:$V$66,14,FALSE),\"N/A\")","v":0.1},{"$f":"IF(H21=\"Owned\",VLOOKUP($F21,$F$48:$V$66,15,FALSE),\"N/A\")","v":8.0000000000000004E-4},{"$f":"VLOOKUP($F21,$F$48:$V$66,16,FALSE)","v":"-"},{"$f":"VLOOKUP($F21,$F$48:$V$66,17,FALSE)","v":16000}]
[null,null,null,null,null,{"$f":"+F8","v":"Litter Drill (5 ton)"},{"$f":"VLOOKUP($F22,$F$48:$V$66,2,FALSE)","v":"Litter Drill"},"Owned","N/A",{"$f":"IF(H22=\"Owned\",VLOOKUP($F22,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H22=\"Owned\",VLOOKUP($F22,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H22=\"Owned\",VLOOKUP($F22,$F$48:$V$66,7,FALSE),\"N/A\")","v":50},{"$f":"IF(H22=\"Owned\",VLOOKUP($F22,$F$48:$V$66,8,FALSE),\"N/A\")","v":65000},{"$f":"IF(H22=\"Owned\",IF(J22>0,M22*(X22-Y22*J22^0.5-Z22*(K22/J22)^0.5)^2,M22),\"N/A\")","v":65000},{"$f":"IF(H22=\"Owned\",IF((IF(((AB22-K22)/L22)>20,20,((AB22-K22)/L22))-J22)<0,0,(IF(((AB22-K22)/L22)>20,20,((AB22-K22)/L22))-J22)),\"N/A\")","v":20},{"$f":"IF(H22=\"Owned\",N22*((X22-Y22*(O22^0.5)-Z22*(L22^0.5)))^2,\"N/A\")","v":18547.17907059666},{"$f":"IF(H22=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O22)/(((1+'User Page'!$C$19)^O22)-1),\"N/A\")","v":8.7184556976851402E-2},{"$f":"IF(H22=\"Owned\",((N22-P22)*Q22)+(P22*'User Page'!$C$19),\"N/A\")","v":5162.7993572908408},{"$f":"VLOOKUP($F22,$F$48:$V$66,12,FALSE)","v":0.5},{"$f":"IF(H22=\"Owned\",S22*M22/IF(((AB22-K22)/L22)>20,20,((AB22-K22)/L22)),0)","v":1625},229.75474244414079,313.30192151473744,146.6171204249944,0.88300000000000001,7.8E-2,0,100,2500]
[null,null,null,null,null,{"$f":"+F9","v":"Fertilzer Spreader (4 ton)"},{"$f":"VLOOKUP($F23,$F$48:$V$66,2,FALSE)","v":"BBI Spreader"},"Owned","N/A",{"$f":"IF(H23=\"Owned\",VLOOKUP($F23,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H23=\"Owned\",VLOOKUP($F23,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H23=\"Owned\",VLOOKUP($F23,$F$48:$V$66,7,FALSE),\"N/A\")","v":100},{"$f":"IF(H23=\"Owned\",VLOOKUP($F23,$F$48:$V$66,8,FALSE),\"N/A\")","v":35000},{"$f":"IF(H23=\"Owned\",IF(J23>0,M23*(X23-Y23*J23^0.5-Z23*(K23/J23)^0.5)^2,M23),\"N/A\")","v":35000},{"$f":"IF(H23=\"Owned\",IF((IF(((AB23-K23)/L23)>20,20,((AB23-K23)/L23))-J23)<0,0,(IF(((AB23-K23)/L23)>20,20,((AB23-K23)/L23))-J23)),\"N/A\")","v":15},{"$f":"IF(H23=\"Owned\",N23*((X23-Y23*(O23^0.5)-Z23*(L23^0.5)))^2,\"N/A\")","v":9214.4649941701718},{"$f":"IF(H23=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O23)/(((1+'User Page'!$C$19)^O23)-1),\"N/A\")","v":0.10296276395531262},{"$f":"IF(H23=\"Owned\",((N23-P23)*Q23)+(P23*'User Page'!$C$19),\"N/A\")","v":3207.8178539169176},{"$f":"VLOOKUP($F23,$F$48:$V$66,12,FALSE)","v":0.35},{"$f":"IF(H23=\"Owned\",S23*M23/IF(((AB23-K23)/L23)>20,20,((AB23-K23)/L23)),0)","v":816.66666666666663},121.58977873396796,165.80424372813815,43.118785430456903,0.94299999999999995,0.111,0,45,1500]
[]
[null,null,null,null,null,{"$f":"+F11","v":"Custom spread fertilizer"},{"$f":"VLOOKUP($F25,$F$48:$V$66,2,FALSE)","v":"Custom spread fertilizer"},"Custom",{"$f":"IF(H25=\"Owned\",\"N/A\",IF(H25=\"Custom\",VLOOKUP(F25,$F$48:$I$66,4,FALSE),\"Enter Fee\"))","v":7},{"$f":"IF(H25=\"Owned\",VLOOKUP($F25,$F$48:$V$66,5,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",VLOOKUP($F25,$F$48:$V$66,6,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",VLOOKUP($F25,$F$48:$V$66,7,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",VLOOKUP($F25,$F$48:$V$66,8,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",IF(J25>0,M25*(X25-Y25*J25^0.5-Z25*(K25/J25)^0.5)^2,M25),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",IF((IF(((AB25-K25)/L25)>20,20,((AB25-K25)/L25))-J25)<0,0,(IF(((AB25-K25)/L25)>20,20,((AB25-K25)/L25))-J25)),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",N25*((X25-Y25*(O25^0.5)-Z25*(L25^0.5)))^2,\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O25)/(((1+'User Page'!$C$19)^O25)-1),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",((N25-P25)*Q25)+(P25*'User Page'!$C$19),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F25,$F$48:$V$66,12,FALSE)","v":"N/A"},{"$f":"IF(H25=\"Owned\",S25*M25/IF(((AB25-K25)/L25)>20,20,((AB25-K25)/L25)),0)","v":0},{"$f":"IF(H25=\"Owned\",$AS$3*AVERAGE(N25,P25),0)","v":0},{"$f":"IF(H25=\"Owned\",$AT$3*AVERAGE(N25,P25),0)","v":0},{"$f":"IF(H25=\"Owned\",(R25+T25+U25+V25)/L25,\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",VLOOKUP($F25,$F$48:$V$66,13,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",VLOOKUP($F25,$F$48:$V$66,14,FALSE),\"N/A\")","v":"N/A"},{"$f":"IF(H25=\"Owned\",VLOOKUP($F25,$F$48:$V$66,15,FALSE),\"N/A\")","v":"N/A"},{"$f":"VLOOKUP($F25,$F$48:$V$66,16,FALSE)","v":"N/A"},{"$f":"VLOOKUP($F25,$F$48:$V$66,17,FALSE)","v":"N/A"}]
[null,null,null,null,null,{"$f":"+F12","v":"Miscellaneous"},{"$f":"VLOOKUP($F26,$F$48:$V$66,2,FALSE)","v":"Miscellaneous equipment"},"Owned","N/A",{"$f":"IF(H26=\"Owned\",VLOOKUP($F26,$F$48:$V$66,5,FALSE),\"N/A\")","v":0},{"$f":"IF(H26=\"Owned\",VLOOKUP($F26,$F$48:$V$66,6,FALSE),\"N/A\")","v":0},{"$f":"IF(H26=\"Owned\",VLOOKUP($F26,$F$48:$V$66,7,FALSE),\"N/A\")","v":50},{"$f":"IF(H26=\"Owned\",VLOOKUP($F26,$F$48:$V$66,8,FALSE),\"N/A\")","v":500},{"$f":"IF(H26=\"Owned\",IF(J26>0,M26*(X26-Y26*J26^0.5-Z26*(K26/J26)^0.5)^2,M26),\"N/A\")","v":500},{"$f":"IF(H26=\"Owned\",IF((IF(((AB26-K26)/L26)>20,20,((AB26-K26)/L26))-J26)<0,0,(IF(((AB26-K26)/L26)>20,20,((AB26-K26)/L26))-J26)),\"N/A\")","v":20},{"$f":"IF(H26=\"Owned\",N26*((X26-Y26*(O26^0.5)-Z26*(L26^0.5)))^2,\"N/A\")","v":99.722613182328985},{"$f":"IF(H26=\"Owned\",('User Page'!$C$19*(1+'User Page'!$C$19)^O26)/(((1+'User Page'!$C$19)^O26)-1),\"N/A\")","v":8.7184556976851402E-2},{"$f":"IF(H26=\"Owned\",((N26-P26)*Q26)+(P26*'User Page'!$C$19),\"N/A\")","v":40.881363428490161},{"$f":"VLOOKUP($F26,$F$48:$V$66,12,FALSE)","v":0.35},{"$f":"IF(H26=\"Owned\",S26*M26/IF(((AB26-K26)/L26)>20,20,((AB26-K26)/L26)),0)","v":8.75},1.6492371862514048,2.248959799433734,1.0705912082835061,0.94299999999999995,0.111,0,0,1500]
[]
[]
["Owned"]
["Rent/Lease"]
["Custom"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://abe-research.illinois.edu/Faculty/grift/TSM262_2017/Standards/ASAE_EP496_3.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,"https://www.tractorhouse.com/listings/farm-equipment/for-sale/17671109/2014-dm-machinery-galva-5800-us",null,null,null,null,null,null,null,null,null,null,"http://abe-research.illinois.edu/Faculty/grift/TSM262_2017/Standards/ASAE_D497_7.pdf"]
[]
[]
[null,null,null,null,null,"Equipment Type","Name","Rent/Lease or Owned?","Rental/Lease Fee in $/hr or Custom Rate in $/acre","Age of Equipment (years)","Existing hours on equipment (at time of purchase)","Annual hours of usage","Purchase Price","Original Cost","Useful Life (Years)","Expected Salvage Value","RF1","C1","C2","C3","Min HP","Useful Life in hours"]
[null,null,null,null,null,"2WD55","John Deere 5055e","Owned",{"$f":"IF(H48=\"Owned\",\"N/A\",\"Enter cost\")","v":"N/A"},0,0,600,27000,{"$f":"IF(H48=\"Rent/Lease\",0,M48)","v":27000},{"$f":"IF((IF(((V48-K48)/L48)>20,20,((V48-K48)/L48))-J48)<0,0,(IF(((V48-K48)/L48)>20,20,((V48-K48)/L48))-J48))","v":20},{"$f":"IF(H48=\"Rent/Lease\",0,M48*((R48-S48*(O48^0.5)-T48*(L48^0.5)))^2)","v":4831.5615769603828},0.6,0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3,"-",12000,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,null,null,null,"http://abe-research.illinois.edu/Faculty/grift/TSM262_2017/Standards/ASAE_EP496_3.pdf"]
[null,null,null,null,null,"MFWD55","John Deere 5055e 4wd","Owned",{"$f":"IF(H49=\"Owned\",\"N/A\",\"Enter cost\")","v":"N/A"},0,0,600,33000,33000,20,5905.241927396024,0.8,0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3,"-",16000,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,null,null,null,"http://abe-research.illinois.edu/Faculty/grift/TSM262_2017/Standards/ASAE_D497_7.pdf"]
[null,null,null,null,null,"2WD90","John Deere 5090M","Owned","N/A",0,0,600,57500,57500,20,12983.844914613441,0.6,0.94199999999999995,0.1,8.0000000000000004E-4,"-",12000]
[null,null,null,null,null,"MFWD90","John Deere 5090M 4wd","Owned","N/A",0,0,600,64500,64500,20,14564.486904218556,0.8,0.94199999999999995,0.1,8.0000000000000004E-4,"-",16000]
[null,null,null,null,null,"2WD110","John Deere 6110M","Owned","N/A",0,0,850,98000,98000,14.117647058823529,28888.988830006947,0.6,0.94199999999999995,0.1,8.0000000000000004E-4,"-",12000]
[null,null,null,null,null,"MFWD110","John Deere 6110M 4wd","Owned","N/A",0,0,850,110000,110000,18.823529411764707,25855.043786272145,0.8,0.94199999999999995,0.1,8.0000000000000004E-4,"-",16000]
[null,null,null,null,null,"MFWD150","John Deere 6155M","Owned","N/A",0,0,1000,155000,155000,16,29996.642290804124,0.7,0.97599999999999998,0.11899999999999999,1.9E-3,"-",16000]
[null,null,null,null,null,"MFWD195","John Deere 6195M","Owned","N/A",0,0,1000,182000,182000,16,35221.863851137743,0.7,0.97599999999999998,0.11899999999999999,1.9E-3,"-",16000]
[null,null,null,null,null,"Manure Spreader (175 bushel) ","Frontier MS1117","Owned","N/A",0,0,200,15000,15000,10,5256.7323143158565,0.5,0.94299999999999995,0.111,0,50,2000]
[null,null,null,null,null,"Manure Spreader (310 bushel)","Frontier MS1231","Owned","N/A",0,0,250,27500,27500,10,9637.3425762457373,0.5,0.94299999999999995,0.111,0,100,2500]
[null,null,null,null,null,"Manure Spreader (550 bushel)","Frontier MS1455","Owned","N/A",0,0,250,52500,52500,10,18398.563100105497,0.5,0.94299999999999995,0.111,0,150,2500]
[null,null,null,null,null,"Slurry Spreader (3750 gallon)","Calumet 3750","Owned","N/A",0,0,300,52000,52000,8.3333333333333339,20154.895942019426,0.5,0.94299999999999995,0.111,0,150,2500]
[null,null,null,null,null,"Litter Drill (5 ton)","Litter Drill","Owned","N/A",0,0,{"$f":"IF(Litter!H54/Litter!B14=0,50,Litter!H54/Litter!B14)","v":50},65000,65000,20,18547.17907059666,0.5,0.88300000000000001,7.8E-2,0,100,2500]
[null,null,null,null,null,"Fertilzer Spreader (4 ton)","BBI Spreader","Owned","N/A",0,0,100,35000,35000,15,9214.4649941701718,0.35,0.94299999999999995,0.111,0,45,1500]
[null,null,null,null,null,"Custom spread liquid",{"$f":"F62","v":"Custom spread liquid"},"Custom",7,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,null,null,null,"Custom spread fertilizer",{"$f":"F63","v":"Custom spread fertilizer"},"Custom",7,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,null,null,null,"Custom spread manure","Custom spread manure","Custom",15,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,null,null,null,"Custom drill litter","Custom drill litter","Custom",40,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,null,null,null,null,"Miscellaneous","Miscellaneous equipment","Owned",{"$f":"IF(H66=\"Owned\",\"N/A\",\"Enter cost\")","v":"N/A"},0,0,50,500,500,5,{"$f":"IF(H66=\"Rent/Lease\",0,M66*((R66-S66*(O66^0.5)-T66*(L66^0.5)))^2)","v":241.37105659116446},0.35,0.94299999999999995,0.111,0,0,1500]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"type","hp"]
[null,null,null,null,null,null,"2WD55",55]
[null,null,null,null,null,null,"MFWD55",55,null,"Equipment Type","Useful hours","R&M"]
[null,null,null,null,null,null,"2WD90",90,null,"2 wheel drive tractor",12000,1]
[null,null,null,null,null,null,"MFWD90",90,null,"4 wheel drive tractor",16000,0.8]
[null,null,null,null,null,null,"2WD110",110,null,"Implement",2500,0.6]
[null,null,null,null,null,null,"MFWD110",110,null,"Misc.",2000,0.5]
[null,null,null,null,null,null,"MFWD150",150]
[null,null,null,null,null,null,"MFWD195",195,null,"Equipment Type","C1","C2","C3"]
[null,null,null,null,null,null,{"$f":"F56","v":"Manure Spreader (175 bushel) "},50,null,"Small tractor (80hp>)",0.98099999999999998,9.2999999999999999E-2,5.7999999999999996E-3]
[null,null,null,null,null,null,"Manure Spreader (310 bushel)",100,null,"Medium tractor (80-150hp)",0.94199999999999995,0.1,8.0000000000000004E-4]
[null,null,null,null,null,null,"Manure Spreader (550 bushel)",145,null,"Large tractor (150hp+)",0.97599999999999998,0.11899999999999999,1.9E-3]
[null,null,null,null,null,null,"Slurry Spreader (3750 gallon)",190,null,"Implement (150hp>)",0.89100000000000001,0.11,0]
[null,null,null,null,null,null,"Litter Drill (5 ton)",100,null,"Implement (150hp<)",0.73799999999999999,5.0999999999999997E-2,0]
[null,null,null,null,null,null,"Fertilzer Spreader (4 ton)",45]
[null,null,null,null,null,null,"Custom spread liquid",0,null,null,"List of equipment pieces w/ cost per hour"]
[null,null,null,null,null,null,"Custom spread fertilizer",0,null,{"$f":"F6","v":"MFWD55"},"John Deere 5055e 4wd",{"$f":"IF(H6=\"Owned\",W6,I6)","v":7.1490717785446369}]
[null,null,null,null,null,null,"Custom spread manure",0,null,"MFWD110","John Deere 6110M 4wd",{"$f":"IF(H7=\"Owned\",W7,I7)","v":17.28138879274978}]
[null,null,null,null,null,null,"Custom drill litter",0,null,"Litter Drill (5 ton)","Litter Drill",146.6171204249944]
[null,null,null,null,null,null,"Miscellaneous",0,null,"Fertilzer Spreader (4 ton)","BBI Spreader",0]
[null,null,null,null,null,null,null,null,null,{"$f":"F11","v":"Custom spread fertilizer"},{"$f":"G11","v":"Custom spread fertilizer"},{"$f":"IF(H11=\"Owned\",W11,I11)","v":7}]
[null,null,null,null,null,null,null,null,null,{"$f":"F12","v":"Miscellaneous"},{"$f":"G12","v":"Loader"},{"$f":"IF(H12=\"Owned\",W12,I12)","v":1.2454046951098876}]
[null,null,null,null,null,null,null,null,null,"None","None",0]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"F6","v":"MFWD55"},{"$f":"G6","v":"John Deere 5055e 4wd"},{"$f":"VLOOKUP(G102,$G$76:$H$94,2,FALSE)","v":55}]
[null,null,null,null,null,null,{"$f":"F7","v":"MFWD110"},{"$f":"G7","v":"John Deere 6110M 4wd"},110]
[null,null,null,null,null,null,"Litter Drill (5 ton)","Litter Drill",100]
[null,null,null,null,null,null,"Fertilzer Spreader (4 ton)","BBI Spreader",45]
[]
[null,null,null,null,null,null,"Custom spread fertilizer","Custom spread fertilizer",0]
[null,null,null,null,null,null,"Miscellaneous","Loader",0]

{"sheet":"Litter","index":4,"n_rows":192,"n_cols":56,"rows_kept":192,"cut":false,"hidden":false,"merged":[[5,9,5,11],[28,10,28,12],[16,4,16,5],[33,8,34,8],[35,8,36,8],[8,6,8,7],[9,6,9,7],[14,10,14,11],[184,1,187,1],[127,6,127,7],[157,5,157,7],[172,1,174,1],[177,1,180,1],[3,1,3,12],[152,8,153,8],[154,8,155,8],[66,1,69,1],[53,1,55,1],[17,6,17,7],[18,6,18,7],[41,5,41,7],[19,6,19,7],[128,6,128,7],[136,6,136,7],[137,6,137,7],[37,8,38,8],[13,10,13,11],[85,8,86,8],[87,5,87,7],[12,13,13,13],[50,14,54,14],[56,14,57,14],[122,1,122,5],[101,1,104,1],[15,13,16,13],[26,13,28,13],[36,13,37,13],[12,14,13,14],[20,13,25,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tractor List","hp","Implement List","hp",null,"Tractor list filtered",null,null,null,"Implement",null,null,null,null,"Tractor Asset costs",null,"implement asset costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D54","v":"John Deere 6110M 4wd"},{"$f":"IFERROR(VLOOKUP(P2,Equipment!$H$102:$I$108,2,FALSE),0)","v":110},{"$f":"E54","v":"Litter Drill"},{"$f":"IFERROR(VLOOKUP(R2,Equipment!$H$102:$I$108,2,FALSE),0)","v":100},null,{"$f":"P2","v":"John Deere 6110M 4wd"},{"$f":"IFERROR(VLOOKUP(U2,Equipment!$G$6:$N$12,7,FALSE),0)","v":110000},null,null,{"$f":"R2","v":"Litter Drill"},{"$f":"IFERROR(VLOOKUP(Y2,Equipment!$G$6:$N$12,7,FALSE),0)","v":65000},null,null,null,{"$f":"SUM(V2:V8)","v":143000},null,{"$f":"SUM(Z2:Z8)","v":70000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D55","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(P3,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E55","v":"Loader"},{"$f":"IFERROR(VLOOKUP(R3,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,{"$f":"P3","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(U3,Equipment!$G$6:$N$12,7,FALSE),0)","v":33000},null,null,{"$f":"R3","v":"Loader"},{"$f":"IFERROR(VLOOKUP(Y3,Equipment!$G$6:$N$12,7,FALSE),0)","v":5000}]
[null,"Litter & Fertilizer Application Details",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D59","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(P4,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E59","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(R4,Equipment!$H$102:$I$108,2,FALSE),0)","v":45},null,null,null,null,null,{"$f":"R4","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(Y4,Equipment!$G$6:$N$12,7,FALSE),0)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Probabilty of suitable days"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D67","v":"None"},{"$f":"IFERROR(VLOOKUP(P5,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E67","v":"None"},{"$f":"IFERROR(VLOOKUP(R5,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},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,null,null,null,"Month",0.15,0.35,0.5,0.65,0.85]
[null,"Acres fertilized","Cost of Litter / Ton","Tons of litter needed","Truckloads",null,"Refill time (minutes) (1)","Refills needed",null,"Litter",null,null,null,"Broadcast Litter Applied in Tons",null,{"$f":"D68","v":"None"},{"$f":"IFERROR(VLOOKUP(P6,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E68","v":"None"},{"$f":"IFERROR(VLOOKUP(R6,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},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,null,null,null,"April",{"$f":"(AVERAGE(AZ17:AZ19)+AVERAGE(AZ48:AZ50))/2","v":3.1666666666666665},{"$f":"(AVERAGE(BA17:BA19)+AVERAGE(BA48:BA50))/2","v":4.0333333333333332},{"$f":"(AVERAGE(BB17:BB19)+AVERAGE(BB48:BB50))/2","v":4.6333333333333329},{"$f":"(AVERAGE(BC17:BC19)+AVERAGE(BC48:BC50))/2","v":5.2},{"$f":"(AVERAGE(BD17:BD19)+AVERAGE(BD48:BD50))/2","v":6}]
[null,{"$f":"+'User Page'!C5","v":300},{"$f":"'User Page'!C7","v":45},{"$f":"B16*B7","v":400},{"$f":"ROUNDUP(D7/25,0)","v":16},null,15,{"$f":"ROUNDUP(B7*B16/B18,0)","v":80},null,null,null,null,null,{"$f":"+B7*N15","v":400},null,{"$f":"D69","v":"None"},{"$f":"IFERROR(VLOOKUP(P7,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E69","v":"None"},{"$f":"IFERROR(VLOOKUP(R7,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,"Annualized Equipment Cost (Dep., Opp. Cost, Ins., Taxes)","Repair & Maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May",{"$f":"SUM(AZ20:AZ24)","v":15.7},{"$f":"SUM(BA20:BA24)","v":20.300000000000004},{"$f":"SUM(BB20:BB24)","v":23.2},{"$f":"SUM(BC20:BC24)","v":26.2},{"$f":"SUM(BD20:BD24)","v":30.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D70","v":"None"},{"$f":"IFERROR(VLOOKUP(P8,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E70","v":"None"},{"$f":"IFERROR(VLOOKUP(R8,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"U2","v":"John Deere 6110M 4wd"},{"$f":"IFERROR(VLOOKUP(AC8,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC8,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC8,Equipment!$G$6:$AB$12,16,FALSE)+VLOOKUP(AC8,Equipment!$G$6:$AB$12,17,FALSE),0)","v":10031.461862630062},{"$f":"IFERROR(VLOOKUP(AC8,Equipment!$G$6:$AB$12,14,FALSE),0)","v":4675},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June",{"$f":"SUM(AZ25:AZ28)","v":14.899999999999999},{"$f":"SUM(BA25:BA28)","v":20.799999999999997},{"$f":"SUM(BB25:BB28)","v":22.5},{"$f":"SUM(BC25:BC28)","v":23.7},{"$f":"SUM(BD25:BD28)","v":26}]
[null,"Total Cost of Litter ONLY","Delivery Charge (if any for all litter)","Litter + Delivery",null,null,"Refill needed every x minutes",null,null,null,null,null,null,"Mod. Litter Cost (Delivered)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"John Deere 5055e 4wd",{"$f":"IFERROR(VLOOKUP(AC9,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC9,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC9,Equipment!$G$6:$AB$12,16,FALSE)+VLOOKUP(AC9,Equipment!$G$6:$AB$12,17,FALSE),0)","v":2976.592138905326},{"$f":"IFERROR(VLOOKUP(AC9,Equipment!$G$6:$AB$12,14,FALSE),0)","v":1320},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",{"$f":"SUM(AZ29:AZ32)","v":19.7},{"$f":"SUM(BA29:BA32)","v":22.9},{"$f":"SUM(BB29:BB32)","v":24},{"$f":"SUM(BC29:BC32)","v":25.4},{"$f":"SUM(BD29:BD32)","v":27.6}]
[null,{"$f":"D7*C7","v":18000},0,{"$f":"B10+C10","v":18000},null,null,{"$f":"B18/B16/B20*60","v":75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AC10,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC10,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC10,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC10,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC10,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC10,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",{"$f":"SUM(AZ33:AZ37)","v":25.599999999999998},{"$f":"SUM(BA33:BA37)","v":29.6},{"$f":"SUM(BB33:BB37)","v":31.3},{"$f":"SUM(BC33:BC37)","v":33.200000000000003},{"$f":"SUM(BD33:BD37)","v":35}]
[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,null,0,{"$f":"IFERROR(VLOOKUP(AC11,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC11,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC11,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC11,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC11,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC11,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",{"$f":"SUM(AZ38:AZ41)","v":18.5},{"$f":"SUM(BA38:BA41)","v":22.5},{"$f":"SUM(BB38:BB41)","v":23.8},{"$f":"SUM(BC38:BC41)","v":25.099999999999998},{"$f":"SUM(BD38:BD41)","v":27.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N7*C7+C10","v":18000},null,"Default values",null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AC12,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC12,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC12,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC12,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC12,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC12,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",{"$f":"SUM(AY42:AY46)","v":0},{"$f":"SUM(AZ42:AZ46)","v":19.899999999999999},{"$f":"SUM(BA42:BA46)","v":25.7},{"$f":"SUM(BB42:BB46)","v":28.599999999999998},{"$f":"SUM(BC42:BC46)","v":30.799999999999997}]
[null,"How many years worth? (2)",null,"Nitrogen (N)","Phosphate (P2O5)","Potash (K2O)",null,null,null,null,null,null,null,"Mod. litter application rate with broadcasting","How many years worth?",15,"litter drill refill time",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AC13,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC13,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC13,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC13,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC13,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC13,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",{"$f":"SUM(AZ47)","v":3.3},{"$f":"SUM(BA47)","v":4.3},{"$f":"SUM(BB47)","v":4.9000000000000004},{"$f":"SUM(BC47)","v":5.6},{"$f":"SUM(BD47)","v":6.3}]
[null,2,"2.3)",60,40,60,"Desired nutrient/yr in (lbs/acre)",null,null,"Total Time to apply (hours)","How many days (10 hour work days)",null,null,null,null,0,"delivery charge for litter",null,"Broadcast",null,null,null,null,null,null,null,null,null,{"$f":"Y2","v":"Litter Drill"},{"$f":"IFERROR(VLOOKUP(AC14,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC14,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC14,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC14,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC14,Equipment!$G$6:$AB$12,19,FALSE),0)","v":5540.132220159976},{"$f":"IFERROR(VLOOKUP(AC14,Equipment!$G$6:$AB$12,17,FALSE),0)","v":146.6171204249944}]
[null,"Application Rate (tons/ac.)","2.3)",3,3,2.5,"Litter nutrient analysis in %",null,null,{"$f":"(B7/B20)+(H7*(G7/60))","v":120},{"$f":"ROUNDUP(J15/10,0)","v":12},null,null,{"$f":"MIN(MIN(+E14*O15/(20*E15),D14*O15/(20*D15*MAX(C18:C19)),F14*O15/(20*F15)),D14*(1/C18)/(D16*(1-C16)),3.5)","v":1.3333333333333333},2,2,"Interval between litter applications",null,2,null,null,null,null,null,null,null,null,null,{"$f":"Y3","v":"Loader"},{"$f":"IFERROR(VLOOKUP(AC15,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC15,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC15,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC15,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC15,Equipment!$G$6:$AB$12,19,FALSE),0)","v":422.83275998708712},{"$f":"IFERROR(VLOOKUP(AC15,Equipment!$G$6:$AB$12,17,FALSE),0)","v":1.2454046951098876},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Week ending",null,"Percentile probability of days suitable"]
[null,{"$f":"MIN(MIN(+E14*B14/(20*E15),D14*B14/(20*D15*MAX(C18:C19)),F14*B14/(20*F15)),D14*(1/C18)/D16,3.5)","v":1.3333333333333333},0.4,{"$f":"D15*20","v":60},{"$f":"E15*20","v":60},{"$f":"F15*20","v":50},"Lbs of nutrient per ton",null,null,"Application Month(s)","Suitable work days (35% chance of fewer)","Can I get the litter applied this month?",null,"Mod. Supplemental N Fertilizer Needs with Broadcasting",null,5,"litter drill load capacity in tons",null,null,null,null,null,null,null,null,null,null,null,"BBI Spreader",{"$f":"IFERROR(VLOOKUP(AC16,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC16,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC16,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC16,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC16,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC16,Equipment!$G$6:$AB$12,17,FALSE),0)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.35,0.5,0.65,0.85]
[null,"Applicator Capacity (tons) (2.1)","N Timing","With sub-surfacing, surplus N (if any) is available in Yr 3","All needed P&K is applied in Yr 1",null,"Lbs of nutrient / year",null,null,"April",{"$f":"VLOOKUP(J17,AX6:$BA$13,3,FALSE)","v":4.0333333333333332},{"$f":"IF((K17*10)>=$J$15,\"Yes\",\"No\")","v":"No"},null,null,"Mod. P (Yr 1)",3,"litter drill speed (should be lower with greater litter distance from field, small/irregular field, high application rate)",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AC17,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC17,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC17,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC17,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC17,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC17,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-Apr",null,2.7,3.6,4.3,4.9000000000000004,5.9]
[null,5,0.5,{"$f":"IF((+$D$14-$D$16*$B$16*C18)<0,0,(+$D$14-$D$16*$B$16*C18))","v":20},{"$f":"+E14*$B$14-$B$16*E16","v":0},{"$f":"+F14*$B$14-$B$16*F16","v":53.333333333333343},"Supplemental Fertilizer needed (Yr 1)",null,null,"May",{"$f":"VLOOKUP(J18,AX7:$BA$13,3,FALSE)","v":20.300000000000004},{"$f":"IF((K18*10)>=$J$15,\"Yes\",\"No\")","v":"Yes"},"Year 1",{"$f":"IF(($D$14-$D$16*(1-C16)*$N$15*C18)<0,0,$D$14-$D$16*(1-C16)*$N$15*C18)","v":36},{"$f":"+E14*$O$15-$N$15*E16","v":0},60,"refill time for fertilizer buggy",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AC18,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC18,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC18,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC18,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC18,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC18,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18-Apr",null,3.2,4.0999999999999996,4.8,5.5,6.1]
[null,"Applicator Speed (acres/hr.) (2.2)",{"$f":"100%-C18","v":0.5},{"$f":"IF((+$D$14-$D$16*$B$16*C19)<0,0,(+$D$14-$D$16*$B$16*C19))","v":20},0,0,"Supplemental Fertilizer needed (Yr 2)",null,null,"June",{"$f":"VLOOKUP(J19,AX8:$BA$13,3,FALSE)","v":20.799999999999997},{"$f":"IF((K19*10)>=$J$15,\"Yes\",\"No\")","v":"Yes"},"Year 2",{"$f":"IF(($D$14-$D$16*(1-C16)*$N$15*C19)<0,0,($D$14-$D$16*(1-C16)*$N$15*C19))","v":36},"Mod. K (Yr 1)",4,"fertilizer buggy load capacity in tons",null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AC19,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC19,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC19,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC19,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC19,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC19,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-Apr",null,3.6,4.4000000000000004,4.8,5.2,6]
[null,3,null,{"$f":"IF((+$D$14-$D$16*$B$16*C20)<0,0,+$D$14-$D$16*$B$16*C20)+IF((+$D$14-$D$16*$B$16*C19)<0,(+$D$14-$D$16*$B$16*C19),0)*0.9+IF((+$D$14-$D$16*$B$16*C18)<0,(+$D$14-$D$16*$B$16*C18),0)*0.8","v":60},0,0,{"$f":"IF($B$14=2,\"\",\"Supplemental Fertilizer needed (Yr 3)\")","v":""},null,null,"Total Annual\nSuitable Days",{"$f":"SUM(AZ6:AZ13)","v":144.33333333333334},null,{"$f":"IF($O$15=2,\"\",\"Year 3\")","v":""},{"$f":"IF($D$14-$D$16*(1-C16)*$N$15*C20<0,0,D14-D16*(1-C16)*N15*C20)+IF(+$D$14-$D$16*(1-C16)*$N$15*C19<0,(D14-$D$16*(1-C16)*$N$15*C19),0)*0.9+IF((+$D$14-$D$16*(1-C16)*$N$15*C18)<0,(D14-$D$16*(1-C16)*$N$15*C18),0)*0.8","v":60},{"$f":"+F14*$O$15-$N$15*F16","v":53.333333333333343},10,"fertilizer application speed (acres/hr)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y8","v":0},{"$f":"IFERROR(VLOOKUP(AC20,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AC20,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AC20,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AC20,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AC20,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AC20,Equipment!$G$6:$AB$12,18,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-May",null,2.6,3.5,4.0999999999999996,4.7,5.8]
[null,null,null,"Labor Cost","Pay /hr.",null,null,null,null,null,null,null,null,"Exp. Yearly\nN Loss/acre",null,7,"custom fertilizer app fee ($/acre)",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,null,null,null,null,null,"9-May",null,3,3.9,4.4000000000000004,5.0999999999999996,6.1]
[null,null,null,"Operator 1",{"$f":"'User Page'!F14*1.1","v":22},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-May",null,3.2,4.2,4.8,5.4,6.4]
[null,null,null,"Operator 2",{"$f":"'User Page'!F15*1.1","v":16.5},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23-May",null,3.6,4.5999999999999996,5.0999999999999996,5.8,6.6]
[null,null,null,"Operator 3",{"$f":"'User Page'!F16*1.1","v":11},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-May",null,3.3,4.0999999999999996,4.8,5.2,6]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-Jun",null,3,4.8,5.2,5.7,6.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N15/O15*D15*20*C16","v":16},6,"custom litter app fee ($/acre)",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,null,null,null,null,null,"13-Jun",null,3.7,5.4,5.8,6,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mod. Total Fertilizer",null,0.4,"default N loss rate for broadcast fertilizer",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,null,null,null,null,null,"20-Jun",null,3.9,5.0999999999999996,5.6,6,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"custom litter drill rate is in the Equipment tab in row 65",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,null,null,null,null,null,"27-Jun",null,4.3,5.5,5.9,6,6.7]
[null,"Acres applying","Tons of fertilizer needed","Refill time (minutes)",null,"Total cost of fertilizer","Added Charge ($)","Fertilizer + Added Charge",null,null,"Supplemental Fertilizer",null,null,null,null,0.5,"N Timing `1st year",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,null,null,null,null,null,"4-Jul",null,4.2,5.2,5.8,6.2,6.7]
[null,{"$f":"+'User Page'!C5","v":300},{"$f":"SUM(F34:H34,F36:H36,F38:H38)","v":26.376811594202906},60,null,{"$f":"SUM(F35:H35)","v":8919.7549407114639},{"$f":"IF(F30>0,'User Page'!$F$10,0)","v":0},{"$f":"F30+G30","v":8919.7549407114639},"Year 1",null,null,null,null,{"$f":"+IF(N18>D45,N18/0.46*B30/2000*L44,0)+G30+O18*B30/0.46/2000*L45+O20*B30/0.6/2000*L46","v":11010.03162055336},"Year 1",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,null,null,null,null,null,null,null,"11-Jul",null,5,5.9,6,6.1,6.9]
[null,null,null,null,null,{"$f":"SUM(F37:H37)","v":2612.8458498023715},{"$f":"IF(F31>0,'User Page'!$F$10,0)","v":0},{"$f":"F31+G31","v":2612.8458498023715},"Year 2",null,null,null,null,{"$f":"+IF(N19>D45,N19*B30/0.46/2000*L44+G30,0)","v":4703.1225296442672},"Year 2",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,null,null,null,null,null,null,null,"18-Jul",null,5.5,5.9,6.1,6.6,7]
[null,null,null,null,null,{"$f":"IF($B$14=2,0,SUM(F39:H39))","v":0},{"$f":"IF(F32>0,'User Page'!$F$10,0)","v":0},{"$f":"F32+G32","v":0},{"$f":"IF($B$14=2,\"\",\"Year 3\")","v":""},null,null,null,null,{"$f":"IF($O$15=2,0,IF(N20>D45,N20*B30/0.46/2000*L44+G30,0))","v":0},{"$f":"IF($O$15=2,\"\",\"Year 3\")","v":""},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,null,null,null,null,null,null,null,"25-Jul",null,5,5.9,6.1,6.5,7]
[null,"Fertilizer Spreader Capacity (tons)","Implement Speed (acres/hr.)","Refill needed every x hours",null,"Urea needed\n(tons & $)","Phosphate needed (tons & $)","Muriate of Potash needed (tons & $)",null,null,null,null,null,"Mod. Tons Applied",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,null,null,null,null,null,null,null,null,"1-Aug",null,4.8,5.8,6.1,6.5,7]
[null,4,10,{"$f":"IFERROR(+$B$34/(SUM(F34:H34)/$B$30)/$C$34,\"N/A\")","v":6.0437956204379537},"Year 1",{"$f":"(F44/0.46)*$B$30/2000","v":6.5217391304347831},{"$f":"(G44/0.46)*$B$30/2000","v":0},{"$f":"(H44/0.6)*$B$30/2000","v":13.333333333333337},"Year 1",null,null,null,null,{"$f":"+IF(N18>D45,N18/0.46*B30/2000,0)+O18*B30/0.46/2000+O20*B30/0.6/2000","v":25.072463768115945},"Year 1",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,null,null,null,null,null,null,null,"8-Aug",null,5.4,5.9,6.1,6.5,7]
[null,null,null,{"$f":"IFERROR(+$B$34/(SUM(F36:H36)/$B$30)/$C$34,\"N/A\")","v":18.399999999999999},"Year 2",{"$f":"L44*F34","v":2612.8458498023715},{"$f":"L45*G34","v":0},{"$f":"L46*H34","v":6306.9090909090928},null,null,null,null,null,{"$f":"+IF(N19>D45,N19*B30/0.46/2000,0)","v":11.739130434782608},"Year 2",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,null,null,null,null,null,null,null,"15-Aug",null,5.0999999999999996,6,6.3,6.8,7]
[null,null,null,{"$f":"IFERROR(+$B$34/(SUM(F38:H38)/$B$30)/$C$34,\"N/A\")","v":"N/A"},{"$f":"IF($B$14=2,\"\",\"Year 3\")","v":""},{"$f":"(F45/0.46)*$B$30/2000","v":6.5217391304347831},{"$f":"(G45/0.46)*$B$30/2000","v":0},{"$f":"(H45/0.6)*$B$30/2000","v":0},"Year 2",null,null,null,null,{"$f":"IF($O$15=2,0,IF(N20>D45,N20*B30/0.46/2000,0))","v":0},{"$f":"IF($O$15=2,\"\",\"Year 3\")","v":""},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,null,null,null,null,null,null,null,"22-Aug",null,5,6,6.6,6.8,7]
[null,null,null,null,null,{"$f":"L44*F36","v":2612.8458498023715},{"$f":"L45*G36","v":0},{"$f":"L46*H36","v":0},null,null,null,null,null,"Mod. Time to Apply",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,null,null,null,null,null,null,null,null,"29-Aug",null,5.3,5.9,6.2,6.6,7]
[null,"Total Time to apply (hours)","How many days (10 hr/day)","Refills needed",null,{"$f":"IF($B$14=2,0,+F46/0.46*$B$30/2000)","v":0},{"$f":"IF($B$14=2,0,+G46/0.46*$B$30/2000)","v":0},{"$f":"IF($B$14=2,0,+H46/0.6*$B$30/2000)","v":0},{"$f":"IF($B$14=2,\"\",\"Year 3\")","v":""},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,null,null,null,null,null,null,null,null,null,null,null,null,null,"5-Sep",null,4.7,5.8,6.1,6.5,7]
[null,{"$f":"IF(SUM(F34:H34)>0,($B$30/$C$34)+(D39*($D$30/60)),0)","v":35},{"$f":"ROUNDUP(B39/10,0)","v":4},{"$f":"IFERROR(ROUNDUP(SUM(F34:H34)*1/$B$34,0),0)","v":5},"Year 1",{"$f":"+F38*L44","v":0},{"$f":"+G38*L45","v":0},{"$f":"+H38*L46","v":0},null,null,null,null,null,{"$f":"IF(N34>0,($B$30/$C$34)+(IFERROR(ROUNDUP(N34*1/$B$34,0),0)*($D$30/60)),0)","v":37},"Year 1",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,null,null,null,null,null,null,null,"12-Sep",null,4.8,5.7,6,6.2,6.9]
[null,{"$f":"IF(SUM(F36:H36)>0,($B$30/$C$34)+(D40*($D$30/60)),0)","v":32},{"$f":"ROUNDUP(B40/10,0)","v":4},{"$f":"IFERROR(ROUNDUP(SUM(F36:H36)*1/$B$34,0),0)","v":2},"Year 2",null,null,null,null,null,"Diesel Fuel Price",{"$f":"'User Page'!$F$18","v":2},null,{"$f":"IF(N35>0,($B$30/$C$34)+(IFERROR(ROUNDUP(N35*1/$B$34,0),0)*($D$30/60)),0)","v":33},"Year 2",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,null,null,null,null,null,null,null,"19-Sep",null,4,5.2,5.7,6.2,6.9]
[null,{"$f":"IF($B$14=2,0,IF(SUM(F38:H38)>0,($B$30/$C$34)+(D41*($D$30/60)),0))","v":0},0,{"$f":"IFERROR(ROUNDUP(SUM(F38:H38)*1/$B$34,0),0)","v":0},{"$f":"IF($B$14=2,\"\",\"Year 3\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(N36>0,($B$30/$C$34)+(IFERROR(ROUNDUP(N36*1/$B$34,0),0)*($D$30/60)),0)","v":0},{"$f":"IF($O$15=2,\"\",\"Year 3\")","v":""},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,null,null,null,null,null,null,null,"26-Sep",null,5,5.8,6,6.2,6.8]
[null,null,null,null,null,"Fertilizer needed (lbs./acre)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-Oct",null,5,5.9,6.1,6.5,7]
[null,null,null,null,null,"Nitrogen","Phosphate","Potash",null,null,null,"$/ton",null,null,null,null,null,null,null,"Labor Cost","Pay /hr.",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,null,"10-Oct",null,4.3,5.4,6,6.5,7]
[null,null,null,null,null,{"$f":"IF(D18<$D$45,0,D18)","v":20},{"$f":"E18","v":0},{"$f":"F18","v":53.333333333333343},"Year 1",null,"Price of Urea (46 - 0 - 0)",{"$f":"Fertilizer!$K$12","v":400.63636363636357},null,null,null,null,null,null,null,{"$f":"D22","v":"Operator 1"},22,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,null,"17-Oct",null,4,5.2,5.8,6,6.8]
[null,null,"Apply no N if needs are less than",5," lbs./acre",{"$f":"IF(D19<$D$45,0,D19)","v":20},{"$f":"E19","v":0},{"$f":"F19","v":0},"Year 2",null,"Price of TSP (0 - 46 - 0)",{"$f":"Fertilizer!$K$13","v":456.94545454545454},null,null,null,null,null,null,null,"Operator 2",16.5,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,null,"24-Oct",null,3.4,4.5,5.4,5.9,6.4]
[null,null,null,null,null,{"$f":"IF($B$14=2,0,IF(D20<$D$45,0,D20))","v":0},{"$f":"IF($B$14=2,0,E20)","v":0},{"$f":"IF($B$14=2,0,F20)","v":0},{"$f":"IF($B$14=2,\"\",\"Year 3\")","v":""},null,"Price of Muriate of Potash (0 - 0 - 60)",{"$f":"Fertilizer!$K$14","v":473.0181818181818},null,null,null,null,null,null,null,"Operator 3",11,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,null,"31-Oct",null,3.2,4.7,5.3,5.9,6.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Activity",0,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,null,"7-Nov",null,3.3,4.3,4.9000000000000004,5.6,6.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"custom litter or owner applied litter",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,null,"11-Apr",null,2.7,3.6,4.3,4.9000000000000004,5.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"custom fertilizer or owner applied for supplmental fertilizer",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,null,"18-Apr",null,3.2,4.0999999999999996,4.8,5.5,6.1]
[null,"Category","Description","Tractor Used","Implement Used","Fuel Consumption (GPH)","Operator","Time Cost (Hours)","Equipment Cost","Fuel Cost","Labor Cost","Cost / Acre","Total Cost","Mod. Cost",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,null,null,null,null,null,null,null,null,"25-Apr",null,3.6,4.4000000000000004,4.8,5.2,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Broadcasting ($/ton)",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,null,null,null,null,null,null,null,"2-May",null,2.6,3.5,4.0999999999999996,4.7,5.8]
[null,"Purchase","Litter Purchased",null,null,null,"Operator 1",2,0,0,{"$f":"VLOOKUP(G52,$T$44:$U$47,2,FALSE)*H52","v":44},{"$f":"M52/$B$7","v":0.14666666666666667},{"$f":"J52+I52+K52","v":44},{"$f":"+M52","v":44}]
[]
[null,{"$f":"CONCATENATE(B14,\"-yr Litter Application Cost\")","v":"2-yr Litter Application Cost"},"Litter Application","John Deere 6110M 4wd",{"$f":"+Equipment!G8","v":"Litter Drill"},6,"Operator 2",{"$f":"IF(T48,0,B7/B20)","v":100},{"$f":"(VLOOKUP(D54,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E54,Equipment!$K$91:$L$97,2,FALSE))*H54","v":16389.850921774418},{"$f":"F54*H54*$L$40","v":1200},{"$f":"VLOOKUP(G54,$T$44:$U$47,2,FALSE)*H54","v":1650},{"$f":"M54/$B$7","v":64.13283640591473},{"$f":"J54+I54+K54","v":19239.850921774418},{"$f":"IF(T48,0,+O56*N7)","v":2400}]
[null,null,"Load Litter (idle during application)","John Deere 5055e 4wd","Loader",2,"Operator 2",{"$f":"IF(T48,0,J15-H54)","v":20},{"$f":"(VLOOKUP(D55,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E55,Equipment!$K$91:$L$97,2,FALSE))*H55","v":167.88952947309048},{"$f":"F55*H55*$L$40","v":80},{"$f":"VLOOKUP(G55,$T$44:$U$47,2,FALSE)*H55","v":330},1.9262984315769685,{"$f":"J55+I55+K55","v":577.88952947309053},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD2+AF2","v":213000}]
[null,null,{"$f":"IF(T48,\"Litter & Custom application charge\",\"Litter\")","v":"Litter"},null,{"$f":"IF(T48,\"Please specify  the custom charge for litter application:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"M56/$B$7","v":60},{"$f":"D10+IF($T$48,$B$7*$F$57,0)","v":18000},{"$f":"+N12+IF(T48,N7*O56)","v":18000},6]
[null,null,null,null,null,40,"$/acre",null,null,null,null,null,null,null,"Mod. Equip. Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mod. Fuel","Mod. Labor"]
[null,null,"Broadcast Fertilizer\n(Yr 1)","John Deere 5055e 4wd",{"$f":"+Equipment!G9","v":"BBI Spreader"},3,"Operator 1",{"$f":"IF(T49,0,B39)","v":35},{"$f":"(VLOOKUP(D59,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E59,Equipment!$K$91:$L$97,2,FALSE))*H59","v":250.21751224906228},{"$f":"F59*H59*$L$40","v":210},{"$f":"VLOOKUP(G59,$T$44:$U$47,2,FALSE)*H59","v":770},{"$f":"M59/$B$7","v":4.1007250408302074},{"$f":"IF(T49,0,J59+I59+K59)","v":1230.2175122490623},{"$f":"IF($T$49,0,N39)*((VLOOKUP(D59,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E59,Equipment!$K$91:$L$97,2,FALSE))+F59*$L$40+VLOOKUP(G59,$T$44:$U$47,2,FALSE))","v":1300.5156558061517},{"$f":"IF($T$49,0,N39)*(VLOOKUP(D59,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E59,Equipment!$K$91:$L$97,2,FALSE))","v":264.51565580615159},{"$f":"F59*N39*$L$40","v":222},{"$f":"IF($T$49,0,N39)*VLOOKUP(G59,T44:U47,2,FALSE)","v":814}]
[null,null,"Broadcast Fertilizer\n(Yr 2)",{"$f":"D59","v":"John Deere 5055e 4wd"},{"$f":"E59","v":"BBI Spreader"},3,"Operator 1",{"$f":"IF(T49,0,B40)","v":32},{"$f":"(VLOOKUP(D60,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E60,Equipment!$K$91:$L$97,2,FALSE))*H60","v":228.77029691342838},{"$f":"F60*H60*$L$40","v":192},{"$f":"VLOOKUP(G60,$T$44:$U$47,2,FALSE)*H60","v":704},3.7492343230447616,{"$f":"IF(T49,0,J60+I60+K60)","v":1124.7702969134284},{"$f":"IF($T$49,0,N40)*((VLOOKUP(D60,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E60,Equipment!$K$91:$L$97,2,FALSE))+F60*$L$40+VLOOKUP(G60,$T$44:$U$47,2,FALSE))","v":1159.919368691973},{"$f":"IF($T$49,0,N40)*(VLOOKUP(D60,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E60,Equipment!$K$91:$L$97,2,FALSE))","v":235.91936869197301},{"$f":"F60*N40*$L$40","v":198},{"$f":"IF($T$49,0,N40)*VLOOKUP(G60,T44:U47,2,FALSE)","v":726}]
[null,{"$f":"IF(T49,\"Custom Fertilizer\",\"\")","v":""},{"$f":"IF($B$14=2,\"\",\"Broadcast Fertilizer\n(Yr 3)\")","v":""},{"$f":"D60","v":"John Deere 5055e 4wd"},"BBI Spreader",3,"Operator 1",{"$f":"IF(T49,0,B41)","v":0},{"$f":"(VLOOKUP(D61,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E61,Equipment!$K$91:$L$97,2,FALSE))*H61","v":0},{"$f":"F61*H61*$L$40","v":0},{"$f":"VLOOKUP(G61,$T$44:$U$47,2,FALSE)*H61","v":0},{"$f":"M61/$B$7","v":0},{"$f":"IF(T49,0,J61+I61+K61)","v":0},{"$f":"IF($T$49,0,N41)*((VLOOKUP(D61,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E61,Equipment!$K$91:$L$97,2,FALSE))+F61*$L$40+VLOOKUP(G61,$T$44:$U$47,2,FALSE))","v":0},{"$f":"IF($T$49,0,N41)*(VLOOKUP(D61,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E61,Equipment!$K$91:$L$97,2,FALSE))","v":0},{"$f":"F61*N41*$L$40","v":0},{"$f":"IF($T$49,0,N41)*VLOOKUP(G61,T44:U47,2,FALSE)","v":0}]
[null,"Supplemental Fertilizer ",{"$f":"IF($T$49,\"Fertilizer & Custom application charge (Yr 1)\",\"Fertilizer (Yr 1)\")","v":"Fertilizer (Yr 1)"},null,{"$f":"IF(T49,\"Please specify  the custom charge for fertilizer application:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"M62/$B$7","v":29.732516469038213},{"$f":"H30+IF(AND(D34<>\"N/A\",$T$49),$B$7*$F$63,0)","v":8919.7549407114639},{"$f":"N30+IF(AND(D34<>\"N/A\",$T$49),$B$7*$F$63,0)","v":11010.03162055336},"Mod. Fuel Cost"]
[null,null,{"$f":"IF($T$49,\"Fertilizer & Custom application charge (Yr 2)\",\"Fertilizer (Yr 2)\")","v":"Fertilizer (Yr 2)"},null,null,7,"$/acre",null,null,null,null,{"$f":"M63/$B$7","v":8.7094861660079044},{"$f":"H31+IF(AND(D35<>\"N/A\",$T$49),$B$7*$F$63,0)","v":2612.8458498023715},{"$f":"N31+IF(AND(D35<>\"N/A\",$T$49),$B$7*$F$63,0)","v":4703.1225296442672},{"$f":"SUM(P59:P61)","v":420}]
[null,null,{"$f":"IF($B$14=2,\"\",IF($T$49,\"Fertilizer & Custom application charge (Yr 3)\",\"Fertilizer (Yr 3)\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($B$14=2,\"\",M64/$B$7)","v":""},{"$f":"IF($B$14=2,0,+H32+IF(AND(D36<>\"N/A\",$T$49),$B$7*$F$63,0))","v":0},{"$f":"IF($O$15=2,0,N32+IF(AND(D36<>\"N/A\",$T$49),$B$7*$F$63,0))","v":0},"Mod. Labor Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q59:Q61)+N52","v":1584}]
[null,null,null,"Tractor Used"]
[null,"Additional user added activities",null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D67,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E67,Equipment!$K$91:$L$97,2,FALSE))*H67,\"Add equipment\")","v":0},{"$f":"F67*H67*$L$40","v":0},{"$f":"VLOOKUP(G67,$T$44:$U$47,2,FALSE)*H67","v":0},{"$f":"M67/$B$7","v":0},{"$f":"I67+K67","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D68,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E68,Equipment!$K$91:$L$97,2,FALSE))*H68,\"Add equipment\")","v":0},{"$f":"F68*H68*$L$40","v":0},0,{"$f":"M68/$B$7","v":0},{"$f":"I68+K68","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D69,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E69,Equipment!$K$91:$L$97,2,FALSE))*H69,\"Add equipment\")","v":0},{"$f":"F69*H69*$L$40","v":0},0,0,{"$f":"I69+K69","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D70,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E70,Equipment!$K$91:$L$97,2,FALSE))*H70,\"Add equipment\")","v":0},{"$f":"F70*H70*$L$40","v":0},0,0,{"$f":"I70+K70","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"H50","v":"Time Cost (Hours)"},{"$f":"I50","v":"Equipment Cost"},"Fuel Cost",{"$f":"K50","v":"Labor Cost"},{"$f":"L50","v":"Cost / Acre"},{"$f":"M50","v":"Total Cost"},"Mod. Total Cost"]
[null,null,null,"TOTAL",{"$f":"CONCATENATE(\"over \",B14,\" years\")","v":"over 2 years"},null,null,{"$f":"SUM(H52:H70)","v":189},{"$f":"SUMIF(I52:I70,\"<>#N/A\")","v":17036.72826041},1682,3498,172.49776350307945,51749.329050923821,{"$f":"SUMIF(N52:N70,\"<>#N/A\")","v":38617.589174695742}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Commercial Fertilizer Only"]
[null,"Acres applying","Tons of fertilizer needed annually","Refill time (minutes)",null,"Total cost of fertilizer","Added Charge ($)","Fertilizer + Application"]
[null,{"$f":"+'User Page'!C5","v":300},{"$f":"SUM(F83:H83)","v":47.608695652173914},{"$f":"+D30","v":60},null,{"$f":"SUM(F84:H84)","v":20893.96837944664},{"$f":"IF(F80>0,'User Page'!$F$10,0)","v":0},{"$f":"F80+G80","v":20893.96837944664},"Annually"]
[]
[null,"Fertilizer Spreader Capacity (tons)","Implement Speed (acres/hr.)","Refill needed every x hours",null,"Urea needed \n(tons & $)","Phosphate needed\n(tons & $)","Muriate of Potash needed (tons & $)"]
[null,{"$f":"B34","v":4},{"$f":"+C34","v":10},{"$f":"IFERROR(+$B$34/(SUM(F83:H83)/$B$30)/$C$34,\"N/A\")","v":2.5205479452054798},null,{"$f":"+D14/0.46*B80/2000","v":19.565217391304348},{"$f":"+E14/0.46*B80/2000","v":13.043478260869566},{"$f":"+F14/0.6*B80/2000","v":15},"Annually"]
[null,null,null,null,null,{"$f":"L88*F83","v":7838.5375494071131},{"$f":"L89*G83","v":5960.1581027667989},{"$f":"L90*H83","v":7095.272727272727}]
[null,"Time reqrd. (hours)","How many days (10 hr/day)","Refills needed",null,null,null,null,null,null,"Diesel Fuel Price",{"$f":"'User Page'!$F$18","v":2}]
[null,{"$f":"IF(SUM(F83:H83)>0,($B$30/$C$34)+(D86*($D$30/60)),0)","v":42},{"$f":"ROUNDUP(B86/10,0)","v":5},{"$f":"IFERROR(ROUNDUP(SUM(F83:H83)*1/$B$34,0),0)","v":12},"Annually"]
[null,null,null,null,null,null,null,null,null,null,null,"$/ton"]
[null,null,null,null,null,"Fertilizer needed (lbs./acre)",null,null,null,null,"Price of Urea (46 - 0 - 0)",{"$f":"Fertilizer!$K$12","v":400.63636363636357}]
[null,null,null,null,null,"Nitrogen","Phosphate","Potash",null,null,"Price of TSP (0 - 46 - 0)",{"$f":"Fertilizer!$K$13","v":456.94545454545454}]
[null,null,"Apply no N if needs <=",{"$f":"+D45","v":5}," lbs./acre",{"$f":"IF(D14<$D$90,0,D14)","v":60},{"$f":"IF(E14<$D$90,0,E14)","v":40},{"$f":"IF(F14<$D$90,0,F14)","v":60},"Annually",null,"Price of Muriate of Potash (0 - 0 - 60)",{"$f":"Fertilizer!$K$14","v":473.0181818181818}]
[]
[]
[]
[]
[]
[]
[null,null,"Broadcast Fertilizer",{"$f":"+D59","v":"John Deere 5055e 4wd"},{"$f":"+Equipment!G9","v":"BBI Spreader"},{"$f":"+F59","v":3},{"$f":"+G59","v":"Operator 1"},{"$f":"IF(T49,0,B86)","v":42},{"$f":"(VLOOKUP(D97,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E97,Equipment!$K$91:$L$97,2,FALSE))*H97","v":300.26101469887476},{"$f":"F97*H97*$L$40","v":252},{"$f":"VLOOKUP(G97,$T$44:$U$47,2,FALSE)*H97","v":924},{"$f":"M97/$B$7","v":4.9208700489962496},{"$f":"IF(T84,0,J97+I97+K97)","v":1476.2610146988748}]
[null,"Commercial Fertilizer ",{"$f":"IF(T49,\"Fertilizer & Custom charge (annual)\",\"Fertilizer (annual)\")","v":"Fertilizer (annual)"},null,{"$f":"IF(T99,\"Custom charge for fertilizer application:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"M98/$B$7","v":69.646561264822139},{"$f":"H80+IF(AND(D83<>\"N/A\",T49),$B$7*$F$99,0)","v":20893.96837944664}]
[null,null,null,null,null,{"$f":"+F63","v":7}]
[]
[null,null,null,"Tractor Used"]
[null,"Additional user added activities",null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D102,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E102,Equipment!$K$91:$L$97,2,FALSE))*H102,\"Add equipment\")","v":0},{"$f":"F102*H102*$L$40","v":0},{"$f":"VLOOKUP(G102,$T$44:$U$47,2,FALSE)*H102","v":0},{"$f":"M102/$B$7","v":0},{"$f":"I102+K102","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D103,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E103,Equipment!$K$91:$L$97,2,FALSE))*H103,\"Add equipment\")","v":0},{"$f":"F103*H103*$L$40","v":0},0,{"$f":"M103/$B$7","v":0},{"$f":"I103+K103","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D104,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E104,Equipment!$K$91:$L$97,2,FALSE))*H104,\"Add equipment\")","v":0},{"$f":"F104*H104*$L$40","v":0},0,0,{"$f":"I104+K104","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D105,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E105,Equipment!$K$91:$L$97,2,FALSE))*H105,\"Add equipment\")","v":0},{"$f":"F105*H105*$L$40","v":0},0,0,{"$f":"I105+K105","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"H50","v":"Time Cost (Hours)"},{"$f":"I50","v":"Equipment Cost"},"Fuel Cost",{"$f":"K50","v":"Labor Cost"},{"$f":"L50","v":"Cost / Acre"},{"$f":"M50","v":"Total Cost"}]
[null,null,null,"TOTAL",{"$f":"CONCATENATE(\"over \",B14,\" years\")","v":"over 2 years"},null,null,{"$f":"SUM(H97:H105)*B14","v":84},{"$f":"SUMIF(I97:I105,\"<>#N/A\")*B14","v":600.52202939774952},{"$f":"SUMIF(J97:J105,\"<>#N/A\")*B14","v":504},{"$f":"SUMIF(K97:K105,\"<>#N/A\")*B14","v":1848},{"$f":"SUMIF(L97:L105,\"<>#N/A\")*B14","v":149.13486262763678},{"$f":"SUMIF(M97:M105,\"<>#N/A\")*B14","v":44740.458788291027}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D68","v":"None"},{"$f":"IFERROR(VLOOKUP(O121,Equipment!#REF!,2,FALSE),0)","v":0},{"$f":"E68","v":"None"},{"$f":"IFERROR(VLOOKUP(Q121,Equipment!#REF!,2,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D69","v":"None"},{"$f":"IFERROR(VLOOKUP(O122,Equipment!#REF!,2,FALSE),0)","v":0},{"$f":"E69","v":"None"},{"$f":"IFERROR(VLOOKUP(Q122,Equipment!#REF!,2,FALSE),0)","v":0}]
[null,"Subsurfaced Poultry Litter Cost Analysis",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Probabilty of suitable days"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month",0.15,0.35,0.5,0.65,0.85]
[null,"Acres applied","Cost of Litter / Ton","Tons of litter needed","Truckloads",null,"Refill time (minutes)","Refills needed",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April",{"$f":"(AVERAGE(AZ136:AZ138)+AVERAGE(AZ167:AZ169))/2","v":3.1666666666666665},{"$f":"(AVERAGE(BA136:BA138)+AVERAGE(BA167:BA169))/2","v":4.0333333333333332},{"$f":"(AVERAGE(BB136:BB138)+AVERAGE(BB167:BB169))/2","v":4.6333333333333329},{"$f":"(AVERAGE(BC136:BC138)+AVERAGE(BC167:BC169))/2","v":5.2},{"$f":"(AVERAGE(BD136:BD138)+AVERAGE(BD167:BD169))/2","v":6}]
[null,{"$f":"'User Page'!C76","v":0},{"$f":"'User Page'!C78","v":0},{"$f":"B136*B126","v":{"$error":"#DIV/0!"}},{"$f":"ROUNDUP(D126/25,0)","v":{"$error":"#DIV/0!"}},null,15,{"$f":"B126*B136/B139","v":{"$error":"#DIV/0!"}},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May",{"$f":"SUM(AZ139:AZ143)","v":15.7},{"$f":"SUM(BA139:BA143)","v":20.300000000000004},{"$f":"SUM(BB139:BB143)","v":23.2},{"$f":"SUM(BC139:BC143)","v":26.2},{"$f":"SUM(BD139:BD143)","v":30.9}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June",{"$f":"SUM(AZ144:AZ147)","v":14.899999999999999},{"$f":"SUM(BA144:BA147)","v":20.799999999999997},{"$f":"SUM(BB144:BB147)","v":22.5},{"$f":"SUM(BC144:BC147)","v":23.7},{"$f":"SUM(BD144:BD147)","v":26}]
[null,"Total Cost of Litter ONLY","Delivery Charge (if any)","Litter + Delivery",null,null,"Refill needed every x minutes",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",{"$f":"SUM(AZ148:AZ151)","v":19.7},{"$f":"SUM(BA148:BA151)","v":22.9},{"$f":"SUM(BB148:BB151)","v":24},{"$f":"SUM(BC148:BC151)","v":25.4},{"$f":"SUM(BD148:BD151)","v":27.6}]
[null,{"$f":"D126*C126","v":{"$error":"#DIV/0!"}},{"$f":"'User Page'!C79","v":0},{"$f":"B129+C129","v":{"$error":"#DIV/0!"}},null,null,{"$f":"B139/B136/B142*60","v":{"$error":"#DIV/0!"}},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",{"$f":"SUM(AZ152:AZ156)","v":25.599999999999998},{"$f":"SUM(BA152:BA156)","v":29.6},{"$f":"SUM(BB152:BB156)","v":31.3},{"$f":"SUM(BC152:BC156)","v":33.200000000000003},{"$f":"SUM(BD152:BD156)","v":35}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",{"$f":"SUM(AZ157:AZ160)","v":18.5},{"$f":"SUM(BA157:BA160)","v":22.5},{"$f":"SUM(BB157:BB160)","v":23.8},{"$f":"SUM(BC157:BC160)","v":25.099999999999998},{"$f":"SUM(BD157:BD160)","v":27.6}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",{"$f":"SUM(AY161:AY165)","v":0},{"$f":"SUM(AZ161:AZ165)","v":19.899999999999999},{"$f":"SUM(BA161:BA165)","v":25.7},{"$f":"SUM(BB161:BB165)","v":28.599999999999998},{"$f":"SUM(BC161:BC165)","v":30.799999999999997}]
[null,"How many years worth?",null,"N","P2O5","K2O",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",{"$f":"SUM(AZ166)","v":3.3},{"$f":"SUM(BA166)","v":4.3},{"$f":"SUM(BB166)","v":4.9000000000000004},{"$f":"SUM(BC166)","v":5.6},{"$f":"SUM(BD166)","v":6.3}]
[null,2,null,{"$f":"'User Page'!C87","v":0},{"$f":"'User Page'!C88","v":0},{"$f":"'User Page'!C89","v":0},"Desired nutrient/yr in (lbs/acre)"]
[null,null,null,3,{"$f":"'User Page'!C83","v":0},{"$f":"'User Page'!C84","v":0},"Litter nutrient analysis in %",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Week ending",null,"Percentile probability of days suitable"]
[null,"Application Rate (tons/ac.)",null,{"$f":"D134*20","v":60},{"$f":"E134*20","v":0},{"$f":"F134*20","v":0},"Lbs of nutrient per ton",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,0.35,0.5,0.65,0.85]
[null,{"$f":"MIN(+E133*B133/(20*E134),D133*B133/(20*D134),F133*B133/(20*F134))","v":{"$error":"#DIV/0!"}},null,{"$f":"+D135*$B$16/B133","v":40},{"$f":"+E135*$B$16/B133","v":0},{"$f":"+F135*$B$16/B133","v":0},"Lbs of nutrient applied / year",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-Apr",null,2.7,3.6,4.3,4.9000000000000004,5.9]
[null,null,null,{"$f":"(+D133-D136)*(1+0.36)","v":-54.399999999999991},{"$f":"+E133-E136","v":0},{"$f":"+F133-F136","v":0},"Supplemental Fertilizer needed (year 1)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18-Apr",null,3.2,4.0999999999999996,4.8,5.5,6.1]
[null,"Implement Capacity (tons)",null,{"$f":"(D133-D136)*(1-0.36)","v":-25.6},{"$f":"+E133-E136","v":0},{"$f":"F137","v":0},"Supplemental Fertilizer needed (year 2)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-Apr",null,3.6,4.4000000000000004,4.8,5.2,6]
[null,5,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-May",null,2.6,3.5,4.0999999999999996,4.7,5.8]
[null,null,null,"Labor Cost","Pay /hr.",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-May",null,3,3.9,4.4000000000000004,5.0999999999999996,6.1]
[null,"Implement Speed (acres/hr.)",null,"Operator 1",{"$f":"'User Page'!F89*1.1","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-May",null,3.2,4.2,4.8,5.4,6.4]
[null,3,null,"Operator 2",{"$f":"'User Page'!F90*1.1","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23-May",null,3.6,4.5999999999999996,5.0999999999999996,5.8,6.6]
[null,null,null,"Operator 3",{"$f":"'User Page'!F91*1.1","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30-May",null,3.3,4.0999999999999996,4.8,5.2,6]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-Jun",null,3,4.8,5.2,5.7,6.3]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-Jun",null,3.7,5.4,5.8,6,6.5]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20-Jun",null,3.9,5.0999999999999996,5.6,6,6.5]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27-Jun",null,4.3,5.5,5.9,6,6.7]
[null,"Acres applying","Tons of fertilizer needed","Refill time (minutes)",null,"Total cost of fertilizer","Fees","Fertilizer + Application",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Jul",null,4.2,5.2,5.8,6.2,6.7]
[null,{"$f":"IF((D137+E137+F137)=0,0,B126)","v":0},{"$f":"(F160+G160+H160)*B149/2000","v":0},10,null,{"$f":"SUM(F154:H154)","v":-7106.9407114624482},{"$f":"'User Page'!F84","v":0},{"$f":"F149+G149","v":-7106.9407114624482},"Year 1",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-Jul",null,5,5.9,6,6.1,6.9]
[null,null,null,null,null,{"$f":"SUM(F156:H156)","v":-3344.4426877470351},{"$f":"G149","v":0},{"$f":"F150+G150","v":-3344.4426877470351},"Year 2",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"18-Jul",null,5.5,5.9,6.1,6.6,7]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25-Jul",null,5,5.9,6.1,6.5,7]
[null,"Implement Capacity (tons)","Implement Speed (acres/hr.)","Refill needed every x minutes",null,"Urea needed (tons)","Phosphorus needed (tons)","Muriate of Potash needed (tons)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-Aug",null,4.8,5.8,6.1,6.5,7]
[null,6,10,{"$f":"B153/1/C153*60","v":36},null,{"$f":"(F160/0.46)*$B$30/2000","v":-17.739130434782606},{"$f":"(G160/0.46)*$B$30/2000","v":0},{"$f":"(H160/0.6)*$B$30/2000","v":0},"Year 1",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"8-Aug",null,5.4,5.9,6.1,6.5,7]
[null,null,null,null,null,{"$f":"D164*F153","v":-7106.9407114624482},{"$f":"D165*G153","v":0},{"$f":"D166*H153","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15-Aug",null,5.0999999999999996,6,6.3,6.8,7]
[null,"Total Time to apply (hours)","How many days (10 hour work days)","Refills needed",null,{"$f":"(F161/0.46)*$B$30/2000","v":-8.3478260869565215},{"$f":"(G161/0.46)*$B$30/2000","v":0},{"$f":"(H161/0.6)*$B$30/2000","v":0},"Year 2",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"22-Aug",null,5,6,6.6,6.8,7]
[null,{"$f":"(B149/C153)+(D156*(D149/60))","v":0},{"$f":"ROUNDUP(B156/10,0)","v":0},{"$f":"B149*1/B153","v":0},null,{"$f":"D164*F155","v":-3344.4426877470351},{"$f":"D165*G155","v":0},{"$f":"D166*H155","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29-Aug",null,5.3,5.9,6.2,6.6,7]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5-Sep",null,4.7,5.8,6.1,6.5,7]
[null,null,"Diesel Fuel Price",{"$f":"'User Page'!$F$18","v":2},null,"Fertilizer mix (lbs./acre)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-Sep",null,4.8,5.7,6,6.2,6.9]
[null,null,"N price per lb.",{"$f":"Fertilizer!$K$7","v":0.43547430830039519},null,"N","P","K",null,null,"Total Time to apply (hours)","How many days (10 hour work days)",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,null,null,null,null,null,null,null,null,null,null,"19-Sep",null,4,5.2,5.7,6.2,6.9]
[null,null,"P price per lb.",{"$f":"Fertilizer!$K$8","v":0.49667984189723319},"Nutrient level desired",{"$f":"D137","v":-54.399999999999991},{"$f":"E137","v":0},{"$f":"F137","v":0},"Year 1",null,{"$f":"(B126/B142)+(H126*(G126/60))","v":{"$error":"#DIV/0!"}},{"$f":"ROUNDUP(K160/10,0)","v":{"$error":"#DIV/0!"}},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,null,null,null,null,null,null,null,null,null,null,"26-Sep",null,5,5.8,6,6.2,6.8]
[null,null,"K price per lb.",{"$f":"Fertilizer!$K$9","v":0.39418181818181819},null,{"$f":"D138","v":-25.6},{"$f":"E138","v":0},{"$f":"F138","v":0},"Year 2",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,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-Oct",null,5,5.9,6.1,6.5,7]
[null,null,null,null,null,null,null,null,null,null,"Application Month(s)","Suitable work days (35% probability)","Can I sub surface this month?",null,null,null,null,null,null,"Labor Cost","Pay /hr.",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,null,"10-Oct",null,4.3,5.4,6,6.5,7]
[null,null,null,{"$f":"Fertilizer!$K$11","v":"$/ton"},null,null,null,null,null,null,"April",{"$f":"VLOOKUP(K163,AX$13:$BA125,3,FALSE)","v":4.0333333333333332},{"$f":"IF((L163*10)>=$J$15,\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,{"$f":"D141","v":"Operator 1"},{"$f":"E141","v":0},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,null,"17-Oct",null,4,5.2,5.8,6,6.8]
[null,null,"Price of Urea (46 - 0 - 0)",{"$f":"Fertilizer!$K$12","v":400.63636363636357},null,null,null,null,null,null,"June",{"$f":"VLOOKUP(K164,AX$13:$BA126,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((L164*10)>=$J$15,\"Yes\",\"No\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"D142","v":"Operator 2"},{"$f":"E142","v":0},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,null,"24-Oct",null,3.4,4.5,5.4,5.9,6.4]
[null,null,"Price of Phosphorus (0 - 46 - 0)",{"$f":"Fertilizer!$K$13","v":456.94545454545454},null,null,null,null,null,null,"July",{"$f":"VLOOKUP(K165,AX$13:$BA127,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF((L165*10)>=$J$15,\"Yes\",\"No\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Operator 3",0,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,null,"31-Oct",null,3.2,4.7,5.3,5.9,6.7]
[null,null,"Price of Muriate of Potash (0 - 0 - 60)",{"$f":"Fertilizer!$K$14","v":473.0181818181818},null,null,null,null,null,null,"Total Suitable Days",{"$f":"SUM(AZ125:AZ132)","v":144.33333333333334},null,null,null,null,null,null,null,"Custom Activity",0,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,null,"7-Nov",null,3.3,4.3,4.9000000000000004,5.6,6.3]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-Apr",null,2.7,3.6,4.3,4.9000000000000004,5.9]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18-Apr",null,3.2,4.0999999999999996,4.8,5.5,6.1]
[null,"Category","Description","Tractor Used","Implement Used","Fuel Consumption (GPH)","Operator","Time Cost (Hours)","Equipment Operating Cost","Fuel Cost","Labor Cost","Cost / Acre","Total Cost",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,null,null,null,null,null,null,null,null,null,"25-Apr",null,3.6,4.4000000000000004,4.8,5.2,6]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-May",null,2.6,3.5,4.0999999999999996,4.7,5.8]
[null,"Purchase","Litter Purchased",null,null,null,"Operator 1",2,0,0,{"$f":"VLOOKUP(G171,$T$44:$U$47,2,FALSE)*H171","v":44},{"$f":"M171/$B$7","v":0.14666666666666667},{"$f":"J171+I171+K171","v":44}]
[]
[null,"Application","Application","John Deere 6110M 4wd","Litter Drill",6,"Operator 1",{"$f":"K160","v":{"$error":"#DIV/0!"}},{"$f":"(VLOOKUP(D173,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E173,Equipment!$K$91:$L$97,2,FALSE))*H173","v":{"$error":"#DIV/0!"}},{"$f":"F173*H173*$L$40","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(G173,$T$44:$U$47,2,FALSE)*H173","v":{"$error":"#DIV/0!"}},{"$f":"M173/$B$7","v":{"$error":"#DIV/0!"}},{"$f":"J173+I173+K173","v":{"$error":"#DIV/0!"}},null,"Tractor List","hp","Implement List","hp",null,"Tractor list filtered",null,null,null,"Implement",null,null,null,null,"Tractor Asset costs",null,"implement asset costs"]
[null,null,"Load Litter (idle during application)","John Deere 5055e 4wd","None",2,"Operator 1",{"$f":"K160","v":{"$error":"#DIV/0!"}},{"$f":"(VLOOKUP(D174,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E174,Equipment!$K$91:$L$97,2,FALSE))*H174","v":{"$error":"#DIV/0!"}},{"$f":"F174*H174*$L$40","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(G174,$T$44:$U$47,2,FALSE)*H174","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"J174+I174+K174","v":{"$error":"#DIV/0!"}},null,{"$f":"D173","v":"John Deere 6110M 4wd"},{"$f":"IFERROR(VLOOKUP(O174,Equipment!$H$102:$I$108,2,FALSE),0)","v":110},{"$f":"E173","v":"Litter Drill"},{"$f":"IFERROR(VLOOKUP(Q174,Equipment!$H$102:$I$108,2,FALSE),0)","v":100},null,{"$f":"O174","v":"John Deere 6110M 4wd"},{"$f":"IFERROR(VLOOKUP(T174,Equipment!$G$6:$N$12,7,FALSE),0)","v":110000},null,null,{"$f":"Q174","v":"Litter Drill"},{"$f":"IFERROR(VLOOKUP(X174,Equipment!$G$6:$N$12,7,FALSE),0)","v":65000},null,null,null,{"$f":"SUM(U174:U180)","v":176000},null,{"$f":"SUM(Y174:Y180)","v":65000},null,null,{"$f":"AC174+AE174","v":241000}]
[null,null,"Litter material",null,null,null,null,0,0,0,0,{"$f":"M175/$B$7","v":60},{"$f":"$D$10","v":18000},null,{"$f":"D174","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(O175,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E174","v":"None"},{"$f":"IFERROR(VLOOKUP(Q175,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"John Deere 5055e 4wd",{"$f":"IFERROR(VLOOKUP(T175,Equipment!$G$6:$N$12,7,FALSE),0)","v":33000},null,null,"None",{"$f":"IFERROR(VLOOKUP(X175,Equipment!$G$6:$N$12,7,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D178","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(O176,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E178","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(Q176,Equipment!$H$102:$I$108,2,FALSE),0)","v":45},null,"John Deere 5055e 4wd",{"$f":"IFERROR(VLOOKUP(T176,Equipment!$G$6:$N$12,7,FALSE),0)","v":33000},null,null,"BBI Spreader",{"$f":"IFERROR(VLOOKUP(X176,Equipment!$G$6:$N$12,7,FALSE),0)","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D185","v":"None"},{"$f":"IFERROR(VLOOKUP(O177,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E185","v":"None"},{"$f":"IFERROR(VLOOKUP(Q177,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(T177,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,null,"None",{"$f":"IFERROR(VLOOKUP(X177,Equipment!$G$6:$N$12,7,FALSE),0)","v":0}]
[null,"Supplemental Fertilizer ","Broadcast Supplement (Year 1)","John Deere 5055e 4wd","BBI Spreader",4,"Operator 1",{"$f":"B156","v":0},{"$f":"(VLOOKUP(D178,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E178,Equipment!$K$91:$L$97,2,FALSE))*H178","v":0},{"$f":"F178*H178*$L$40","v":0},{"$f":"VLOOKUP(G178,$T$44:$U$47,2,FALSE)*H178","v":0},{"$f":"M178/$B$7","v":0},{"$f":"J178+I178+K178","v":0},null,{"$f":"D186","v":"None"},{"$f":"IFERROR(VLOOKUP(O178,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E186","v":"None"},{"$f":"IFERROR(VLOOKUP(Q178,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(T178,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,null,"None",{"$f":"IFERROR(VLOOKUP(X178,Equipment!$G$6:$N$12,7,FALSE),0)","v":0}]
[null,null,"Broadcast Supplement (Year 2)",{"$f":"D178","v":"John Deere 5055e 4wd"},{"$f":"E178","v":"BBI Spreader"},4,"Operator 1",{"$f":"H178","v":0},{"$f":"(VLOOKUP(D179,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E179,Equipment!$K$91:$L$97,2,FALSE))*H179","v":0},{"$f":"F179*H179*$L$40","v":0},{"$f":"VLOOKUP(G179,$T$44:$U$47,2,FALSE)*H179","v":0},0,{"$f":"J179+I179+K179","v":0},null,{"$f":"D187","v":"None"},{"$f":"IFERROR(VLOOKUP(O179,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E187","v":"None"},{"$f":"IFERROR(VLOOKUP(Q179,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(T179,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,null,"None",{"$f":"IFERROR(VLOOKUP(X179,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,null,null,"Annualized Equipment Cost (Dep., Opp. Cost, Ins., Taxes)","Repair & Maintenance"]
[null,null,"Fertilizer material (Year 1)",null,null,null,null,0,0,0,0,{"$f":"M180/$B$7","v":29.732516469038213},{"$f":"$H$30","v":8919.7549407114639},null,{"$f":"D188","v":"None"},{"$f":"IFERROR(VLOOKUP(O180,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E188","v":"None"},{"$f":"IFERROR(VLOOKUP(Q180,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(T180,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,null,"None",{"$f":"IFERROR(VLOOKUP(X180,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,null,{"$f":"T174","v":"John Deere 6110M 4wd"},{"$f":"IFERROR(VLOOKUP(AB180,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB180,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB180,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB180,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB180,Equipment!$G$6:$AB$12,19,FALSE),0)","v":9523.04744843154},{"$f":"IFERROR(VLOOKUP(AB180,Equipment!$G$6:$AB$12,17,FALSE),0)","v":17.28138879274978}]
[null,null,"Fertilizer material (Year 2)",null,null,null,null,0,0,0,0,{"$f":"M181/$B$7","v":8.7094861660079044},{"$f":"$H$31","v":2612.8458498023715},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"John Deere 5055e 4wd",{"$f":"IFERROR(VLOOKUP(AB181,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB181,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB181,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB181,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB181,Equipment!$G$6:$AB$12,19,FALSE),0)","v":2831.7714816775911},{"$f":"IFERROR(VLOOKUP(AB181,Equipment!$G$6:$AB$12,17,FALSE),0)","v":7.1490717785446369}]
[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,"John Deere 5055e 4wd",{"$f":"IFERROR(VLOOKUP(AB182,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB182,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB182,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB182,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB182,Equipment!$G$6:$AB$12,19,FALSE),0)","v":2831.7714816775911},{"$f":"IFERROR(VLOOKUP(AB182,Equipment!$G$6:$AB$12,17,FALSE),0)","v":7.1490717785446369}]
[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,"None",{"$f":"IFERROR(VLOOKUP(AB183,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB183,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB183,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB183,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB183,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB183,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]
[null,null,null,"Tractor Used",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(AB184,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB184,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB184,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB184,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB184,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB184,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]
[null,"Additional user added activities",null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D185,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E185,Equipment!$K$91:$L$97,2,FALSE))*H185,\"Add equipment\")","v":0},{"$f":"F185*H185*$L$40","v":0},{"$f":"VLOOKUP(G185,$T$44:$U$47,2,FALSE)*H185","v":0},{"$f":"M185/$B$7","v":0},{"$f":"I185+K185","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(AB185,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB185,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB185,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB185,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB185,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB185,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D186,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E186,Equipment!$K$91:$L$97,2,FALSE))*H186,\"Add equipment\")","v":0},{"$f":"F186*H186*$L$40","v":0},0,{"$f":"M186/$B$7","v":0},{"$f":"I186+K186","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X174","v":"Litter Drill"},{"$f":"IFERROR(VLOOKUP(AB186,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB186,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB186,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB186,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB186,Equipment!$G$6:$AB$12,19,FALSE),0)","v":5540.132220159976},{"$f":"IFERROR(VLOOKUP(AB186,Equipment!$G$6:$AB$12,17,FALSE),0)","v":146.6171204249944}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D187,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E187,Equipment!$K$91:$L$97,2,FALSE))*H187,\"Add equipment\")","v":0},{"$f":"F187*H187*$L$40","v":0},0,0,{"$f":"I187+K187","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X175","v":"None"},{"$f":"IFERROR(VLOOKUP(AB187,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB187,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB187,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB187,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB187,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB187,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D188,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(Litter!E188,Equipment!$K$91:$L$97,2,FALSE))*H188,\"Add equipment\")","v":0},{"$f":"F188*H188*$L$40","v":0},0,0,{"$f":"I188+K188","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BBI Spreader",{"$f":"IFERROR(VLOOKUP(AB188,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB188,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB188,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB188,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB188,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB188,Equipment!$G$6:$AB$12,17,FALSE),0)","v":"N/A"}]
[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,"None",{"$f":"IFERROR(VLOOKUP(AB189,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB189,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB189,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB189,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB189,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB189,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"H169","v":"Time Cost (Hours)"},{"$f":"I169","v":"Equipment Operating Cost"},"Fuel Cost",{"$f":"K169","v":"Labor Cost"},{"$f":"L169","v":"Cost / Acre"},{"$f":"M169","v":"Total Cost"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(AB190,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB190,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB190,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB190,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB190,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB190,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]
[null,null,null,"TOTAL","Activity Costs",null,null,{"$f":"SUM(H171:H188)","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(I171:I188,\"<>#N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(J171:J188,\"<>#N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(K171:K188,\"<>#N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(L171:L188,\"<>#N/A\")","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(M171:M188,\"<>#N/A\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(AB191,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB191,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB191,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB191,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB191,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB191,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]
[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,{"$f":"X180","v":"None"},{"$f":"IFERROR(VLOOKUP(AB192,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AB192,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AB192,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AB192,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AB192,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AB192,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]

{"sheet":"Fertilizer","index":5,"n_rows":96,"n_cols":49,"rows_kept":96,"cut":false,"hidden":true,"merged":[[37,1,40,1],[3,1,3,5],[30,1,33,1],[28,44,28,45],[29,44,29,45],[26,43,26,45],[88,1,91,1],[54,1,54,5],[77,43,77,45],[79,44,79,45],[80,44,80,45],[81,1,84,1]]}
[]
[]
[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,null,null,null,null,null,null,null,null,"Acreage Numbers",null,"Cost of Litter Prices"]
[null,"Commerical Fertilizer cost analysis",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,null,null,null,"List of parameters",null,null,10,null,25]
[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,null,null,null,null,null,null,null,null,25,null,35]
[null,"Acres applying","Tons of fertilizer needed","Truckloads",null,"Total cost of fertilizer","Added Charge","Fertilizer + Application",null,"Diesel Fuel Price ($/gal)",{"$f":"Litter!$L$40","v":2},null,null,null,null,null,null,null,null,null,null,"Labor Cost","Pay /hr.",null,null,null,null,null,null,null,null,null,null,null,null,50,null,45]
[null,{"$f":"+Litter!B7","v":300},{"$f":"(F14+G14+H14)*B7/2000","v":24},{"$f":"ROUNDUP(C7/35,0)","v":1},null,{"$f":"SUM(F11:H11)","v":20893.96837944664},{"$f":"'User Page'!F10","v":0},{"$f":"F7+G7*B7","v":20893.96837944664},null,"N price per lb.",{"$f":"K12/2000/0.46","v":0.43547430830039519},null,null,null,null,null,null,null,null,null,null,{"$f":"J17","v":"Operator 1"},{"$f":"K17","v":22},null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,"P price per lb.",{"$f":"K13/2000/0.46","v":0.49667984189723319},null,null,null,null,null,null,null,null,null,null,{"$f":"J18","v":"Operator 2"},{"$f":"K18","v":16.5},null,null,null,null,null,null,null,null,null,null,null,null,200]
[null,"Application Rate (tons/ac.)","Implement Capacity (tons)","Implement Speed (acres/hr.)",null,"Urea needed (tons)","Phosphorus needed (tons)","Muriate of Potash needed (tons)",null,"K price per lb.",{"$f":"K14/2000/0.6","v":0.39418181818181819},null,null,null,null,null,null,null,null,null,null,"Operator 3",11,null,null,null,null,null,null,null,null,null,null,null,null,300]
[null,{"$f":"SUM(F10:H10)/B7","v":0.15869565217391304},{"$f":"+Litter!B34","v":4},{"$f":"+Litter!C34","v":10},null,{"$f":"(F14/0.46)*$B$7/2000","v":19.565217391304348},{"$f":"(G14/0.46)*$B$7/2000","v":13.043478260869566},{"$f":"(H14/0.6)*$B$7/2000","v":15},null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Activity",0,null,null,null,null,null,null,null,null,null,null,null,null,400]
[null,null,null,null,null,{"$f":"K12*F10","v":7838.5375494071131},{"$f":"K13*G10","v":5960.1581027667989},{"$f":"K14*H10","v":7095.272727272727},null,null,"$/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500]
[null,"Refill needed every x minutes","Refills needed","Refill time (minutes)",null,null,null,null,null,"Price of Urea (46 - 0 - 0)",{"$f":"'User Page'!F6","v":400.63636363636357},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
[null,{"$f":"C10/B10/D10*60","v":151.23287671232879},{"$f":"ROUNDUP(B7*B10/C10,0)","v":12},{"$f":"+Litter!D30","v":60},null,"N (lbs/acre)","P (lbs/acre)","K (lbs/acre)",null,"Price of Phosphorus (0 - 46 - 0)",{"$f":"'User Page'!F7","v":456.94545454545454},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000]
[null,null,null,null,null,{"$f":"+Litter!D14","v":60},{"$f":"+Litter!E14","v":40},{"$f":"+Litter!F14","v":60},null,"Price of Muriate of Potash (0 - 0 - 60)",{"$f":"'User Page'!F8","v":473.0181818181818},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,null,null,null,null,null,null,null,null,"N","P","K"]
[null,"Application Month(s)","Suitable work days (35% probability of fewer days)","Can I apply this month?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Probabilty of suitable days",null,null,null,null,null,null,null,null,null,null,null,null,null,"Week ending",null,"Percentile probability of days suitable",null,null,null,null,null,null,"Prices in $/cwt",null,"Urea (46% N)","Phosphorus (46% P2O5)","Potash (60% K2O)"]
[null,{"$f":"Litter!$J$17","v":"April"},{"$f":"Litter!$K$17","v":4.0333333333333332},{"$f":"IF($F$17<=C16*10,\"Yes\",\"No\")","v":"No"},null,"Total Time to apply (hours)","How many days (10 hour days)",null,null,"Labor Cost","Pay /hr.",null,null,null,null,null,null,null,null,null,"Month",0.15,0.35,0.5,0.65,0.85,null,null,null,null,null,null,null,null,null,null,null,0.15,0.35,0.5,0.65,0.85,null,null,null,2009,16.29,15.35,26.1]
[null,{"$f":"Litter!$J$18","v":"May"},{"$f":"Litter!$K$18","v":20.300000000000004},{"$f":"IF($F$17<=C17*10,\"Yes\",\"No\")","v":"Yes"},null,{"$f":"(B7/D10)+(C13*(D13/60))","v":42},{"$f":"ROUNDUP(F17/10,0)","v":5},null,null,"Operator 1",{"$f":"Litter!E22","v":22},null,null,null,null,null,null,null,null,null,"April",{"$f":"Litter!AY6","v":3.1666666666666665},{"$f":"Litter!AZ6","v":4.0333333333333332},{"$f":"Litter!BA6","v":4.6333333333333329},{"$f":"Litter!BB6","v":5.2},{"$f":"Litter!BC6","v":6},null,null,null,null,null,null,null,null,null,"11-Apr",null,2.7,3.6,4.3,4.9000000000000004,5.9,null,null,null,{"$f":"AT16+1","v":2010},19,22,23]
[null,{"$f":"Litter!$J$19","v":"June"},{"$f":"Litter!$K$19","v":20.799999999999997},"Yes",null,null,null,null,null,"Operator 2",{"$f":"Litter!E23","v":16.5},null,null,null,null,null,null,null,null,null,"May",{"$f":"Litter!AY7","v":15.7},{"$f":"Litter!AZ7","v":20.300000000000004},{"$f":"Litter!BA7","v":23.2},{"$f":"Litter!BB7","v":26.2},{"$f":"Litter!BC7","v":30.9},null,null,null,null,null,null,null,null,null,"18-Apr",null,3.2,4.0999999999999996,4.8,5.5,6.1,null,null,null,{"$f":"AT17+1","v":2011},22.29,28.65,29.19]
[null,{"$f":"Litter!$J$20","v":"Total Annual\nSuitable Days"},{"$f":"Litter!$K$20","v":144.33333333333334},null,null,null,null,null,null,"Operator 3",{"$f":"Litter!E24","v":11},null,null,null,null,null,null,null,null,null,"June",{"$f":"Litter!AY8","v":14.899999999999999},{"$f":"Litter!AZ8","v":20.799999999999997},{"$f":"Litter!BA8","v":22.5},{"$f":"Litter!BB8","v":23.7},{"$f":"Litter!BC8","v":26},null,null,null,null,null,null,null,null,null,"25-Apr",null,3.6,4.4000000000000004,4.8,5.2,6,null,null,null,{"$f":"AT18+1","v":2012},28.4,29.3,29.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",{"$f":"Litter!AY9","v":19.7},{"$f":"Litter!AZ9","v":22.9},{"$f":"Litter!BA9","v":24},{"$f":"Litter!BB9","v":25.4},{"$f":"Litter!BC9","v":27.6},null,null,null,null,null,null,null,null,null,"2-May",null,2.6,3.5,4.0999999999999996,4.7,5.8,null,null,null,2013,22.6,24,23.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",{"$f":"Litter!AY10","v":25.599999999999998},{"$f":"Litter!AZ10","v":29.6},{"$f":"Litter!BA10","v":31.3},{"$f":"Litter!BB10","v":33.200000000000003},{"$f":"Litter!BC10","v":35},null,null,null,null,null,null,null,null,null,"9-May",null,3,3.9,4.4000000000000004,5.0999999999999996,6.1,null,null,null,2014,25.25,24.5,23.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",{"$f":"Litter!AY11","v":18.5},{"$f":"Litter!AZ11","v":22.5},{"$f":"Litter!BA11","v":23.8},{"$f":"Litter!BB11","v":25.099999999999998},{"$f":"Litter!BC11","v":27.6},null,null,null,null,null,null,null,null,null,"16-May",null,3.2,4.2,4.8,5.4,6.4,null,null,null,2015,20.83,25,21.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",{"$f":"Litter!AY12","v":0},{"$f":"Litter!AZ12","v":19.899999999999999},{"$f":"Litter!BA12","v":25.7},{"$f":"Litter!BB12","v":28.599999999999998},{"$f":"Litter!BC12","v":30.799999999999997},null,null,null,null,null,null,null,null,null,"23-May",null,3.6,4.5999999999999996,5.0999999999999996,5.8,6.6,null,null,null,2016,16.78,21.88,16.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",{"$f":"Litter!AY13","v":3.3},{"$f":"Litter!AZ13","v":4.3},{"$f":"Litter!BA13","v":4.9000000000000004},{"$f":"Litter!BB13","v":5.6},{"$f":"Litter!BC13","v":6.3},null,null,null,null,null,null,null,null,null,"30-May",null,3.3,4.0999999999999996,4.8,5.2,6,null,null,null,2017,14.19,18.78,18.98]
[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,null,null,null,null,null,null,null,null,"6-Jun",null,3,4.8,5.2,5.7,6.3,null,null,null,2018,14.5,23.75,20]
[null,"Category","Description","Tractor Used","Implement Used","Fuel Consumption (GPH)","Operator","Time Cost (Hours)","Equipment Operating Cost","Fuel Cost","Labor Cost","Cost / Acre","Total Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-Jun",null,3.7,5.4,5.8,6,6.5,null,null,null,2019,20.22,18.11,27.5]
[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,"Tractor Asset costs",null,"implement asset costs",null,null,"TOTAL",null,null,null,"20-Jun",null,3.9,5.0999999999999996,5.6,6,6.5,null,"10 yr avg. (converted to tons)",null,null,{"$f":"AVERAGE(AU16:AU26)*20","v":400.63636363636357},{"$f":"AVERAGE(AV16:AV26)*20","v":456.94545454545454},473.0181818181818]
[null,"Purchase","Fertilizer Purchased",null,null,null,"Operator 1",2,0,0,{"$f":"VLOOKUP(G28,$V$7:$W$10,2,FALSE)*H28","v":44},{"$f":"M28/$B$7","v":0.14666666666666667},{"$f":"J28+I28+K28","v":44},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V32:V37)","v":33000},null,{"$f":"SUM(Y32:Y37)","v":0},null,null,{"$f":"AA28+AC28","v":33000},null,null,null,"27-Jun",null,4.3,5.5,5.9,6,6.7]
[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,null,null,null,null,null,null,null,null,"4-Jul",null,4.2,5.2,5.8,6.2,6.7,null,null,"Price per lb.",null,{"$f":"AU27/100","v":4.0063636363636359},{"$f":"AV27/100","v":4.569454545454545},4.7301818181818183]
[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,null,null,null,null,null,null,null,null,"11-Jul",null,5,5.9,6,6.1,6.9,null,null,"Price of element per lb.",null,{"$f":"AU29/0.46","v":8.7094861660079044},{"$f":"AV29/0.46","v":9.9335968379446626},{"$f":"AW29/0.6","v":7.8836363636363638}]
[null,"Fertilizer","Broadcast Supplement","John Deere 5055e 4wd","BBI Spreader",4,"Operator 2",{"$f":"F17","v":42},{"$f":"(VLOOKUP(D31,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E31,Equipment!$K$91:$L$97,2,FALSE))*H31","v":300.26101469887476},{"$f":"F31*H31*$K$6","v":336},{"$f":"VLOOKUP(G31,$V$7:$W$10,2,FALSE)*H31","v":693},{"$f":"M31/$B$7","v":4.4308700489962494},{"$f":"J31+I31+K31","v":1329.2610146988748},null,null,"Tractor List","hp","Implement List","hp",null,"Tractor List filtered",null,null,"Implement List filtered",null,null,null,null,null,null,null,null,null,null,null,"18-Jul",null,5.5,5.9,6.1,6.6,7]
[null,null,"Fertilizer material",null,null,null,null,null,null,null,null,{"$f":"M32/$B$7","v":69.646561264822139},{"$f":"$H$7","v":20893.96837944664},null,null,{"$f":"D31","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(P32,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E31","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(R32,Equipment!$H$102:$I$108,2,FALSE),0)","v":45},null,{"$f":"P32","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(U32,Equipment!$G$6:$N$12,7,FALSE),0)","v":33000},null,{"$f":"R32","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(X32,Equipment!$G$6:$N$12,7,FALSE),0)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,"25-Jul",null,5,5.9,6.1,6.5,7]
[null,null,"Year 2 Supplement","John Deere 5055e 4wd","BBI Spreader",4,"Operator 2",{"$f":"H31","v":42},{"$f":"I31","v":300.26101469887476},{"$f":"J31","v":336},{"$f":"VLOOKUP(G33,$V$7:$W$10,2,FALSE)*H33","v":693},{"$f":"L31","v":4.4308700489962494},1329.2610146988748,null,null,{"$f":"D33","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(P33,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E33","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(R33,Equipment!$H$102:$I$108,2,FALSE),0)","v":45},null,null,null,null,null,null,null,null,"Annualized Equipment Cost (Dep., Opp. Cost, Ins., Taxes)","Repair & Maintenance",null,null,null,null,null,null,"1-Aug",null,4.8,5.8,6.1,6.5,7]
[null,null,"Year 2 Fertilizer cost",null,null,null,null,0,{"$f":"I32","v":0},{"$f":"J32","v":0},0,69.646561264822139,20893.96837944664,null,null,{"$f":"D38","v":"None"},{"$f":"IFERROR(VLOOKUP(P34,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E38","v":"None"},{"$f":"IFERROR(VLOOKUP(R34,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,null,null,null,null,null,null,{"$f":"U32","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(AA34,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA34,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA34,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA34,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA34,Equipment!$G$6:$AB$12,19,FALSE),0)","v":2831.7714816775911},{"$f":"IFERROR(VLOOKUP(AA34,Equipment!$G$6:$AB$12,17,FALSE),0)","v":7.1490717785446369},null,null,null,null,null,null,"8-Aug",null,5.4,5.9,6.1,6.5,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D39","v":"None"},{"$f":"IFERROR(VLOOKUP(P35,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E39","v":"None"},{"$f":"IFERROR(VLOOKUP(R35,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,null,null,null,null,null,null,{"$f":"U33","v":0},{"$f":"IFERROR(VLOOKUP(AA35,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA35,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA35,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA35,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA35,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA35,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"15-Aug",null,5.0999999999999996,6,6.3,6.8,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(P36,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},"None",{"$f":"IFERROR(VLOOKUP(R36,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AA36,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA36,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA36,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA36,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA36,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA36,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"22-Aug",null,5,6,6.6,6.8,7]
[null,null,null,"Tractor Used",null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(P37,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},"None",{"$f":"IFERROR(VLOOKUP(R37,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AA37,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA37,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA37,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA37,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA37,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA37,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"29-Aug",null,5.3,5.9,6.2,6.6,7]
[null,"Additional user added activities",null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D38,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E38,Equipment!$K$91:$L$97,2,FALSE))*H38, \"Add equipment\")","v":0},{"$f":"F38*H38*$K$6","v":0},{"$f":"VLOOKUP(G38,$V$7:$W$10,2,FALSE)*H38","v":0},{"$f":"M38/$B$7","v":0},{"$f":"I38+K38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AA38,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA38,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA38,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA38,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA38,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA38,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"5-Sep",null,4.7,5.8,6.1,6.5,7]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D39,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E39,Equipment!$K$91:$L$97,2,FALSE))*H39, \"Add equipment\")","v":0},{"$f":"F39*H39*$K$6","v":0},0,{"$f":"M39/$B$7","v":0},{"$f":"I39+K39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AA39,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA39,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA39,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA39,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA39,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA39,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"12-Sep",null,4.8,5.7,6,6.2,6.9,null,null,null,null,{"$f":"400/20","v":20}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D40,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E40,Equipment!$K$91:$L$97,2,FALSE))*H40, \"Add equipment\")","v":0},{"$f":"F40*H40*$K$6","v":0},0,{"$f":"M40/$B$7","v":0},{"$f":"I40+K40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X32","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(AA40,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA40,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA40,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA40,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA40,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA40,Equipment!$G$6:$AB$12,17,FALSE),0)","v":"N/A"},null,null,null,null,null,null,"19-Sep",null,4,5.2,5.7,6.2,6.9]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D41,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E41,Equipment!$K$91:$L$97,2,FALSE))*H41, \"Add equipment\")","v":0},{"$f":"F41*H41*$K$6","v":0},0,{"$f":"M41/$B$7","v":0},{"$f":"I41+K41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X33","v":0},{"$f":"IFERROR(VLOOKUP(AA41,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA41,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA41,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA41,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA41,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA41,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"26-Sep",null,5,5.8,6,6.2,6.8]
[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,0,{"$f":"IFERROR(VLOOKUP(AA42,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA42,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA42,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA42,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA42,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA42,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"3-Oct",null,5,5.9,6.1,6.5,7]
[null,null,null,null,null,null,null,{"$f":"H26","v":"Time Cost (Hours)"},{"$f":"I26","v":"Equipment Operating Cost"},"Fuel Cost",{"$f":"K26","v":"Labor Cost"},{"$f":"L26","v":"Cost / Acre"},{"$f":"M26","v":"Total Cost"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(VLOOKUP(AA43,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA43,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA43,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA43,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA43,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA43,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"10-Oct",null,4.3,5.4,6,6.5,7]
[null,null,null,"TOTAL","Activity Costs",null,null,{"$f":"SUM(H28:H41)","v":86},{"$f":"SUMIF(I28:I41,\"<>#N/A\")","v":600.52202939774952},{"$f":"SUMIF(J28:J41,\"<>#N/A\")","v":672},{"$f":"SUMIF(K28:K41,\"<>#N/A\")","v":1430},{"$f":"SUMIF(L28:L41,\"<>#N/A\")","v":148.30152929430346},{"$f":"SUMIF(M28:M41,\"<>#N/A\")","v":44490.458788291027},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X36","v":0},{"$f":"IFERROR(VLOOKUP(AA44,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA44,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA44,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA44,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA44,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA44,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"17-Oct",null,4,5.2,5.8,6,6.8]
[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":"X37","v":0},{"$f":"IFERROR(VLOOKUP(AA45,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA45,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA45,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA45,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA45,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA45,Equipment!$G$6:$AB$12,18,FALSE),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Commerical Fertilizer cost analysis",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,null,null,null,"List of parameters",null,null,10,null,25]
[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,null,null,null,null,null,null,null,null,25,null,35]
[null,"Acres applying","Tons of fertilizer needed","Truckloads",null,"Total cost of fertilizer","Misc. Fees","Fertilizer + Application",null,"Diesel Fuel Price ($/gal)",{"$f":"Litter!$L$40","v":2},null,null,null,null,null,null,null,null,null,null,"Labor Cost","Pay /hr.",null,null,null,null,null,null,null,null,null,null,null,null,50,null,45]
[null,{"$f":"+Litter!B58","v":0},{"$f":"(F65+G65+H65)*B58/2000","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP(C58/35,0)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(F62:H62)","v":{"$error":"#VALUE!"}},{"$f":"'User Page'!F60","v":0},{"$f":"F58+G58","v":{"$error":"#VALUE!"}},null,"N price per lb.",{"$f":"K63/2000/0.46","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"J68","v":"Operator 1"},{"$f":"K68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,"P price per lb.",{"$f":"K64/2000/0.46","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"J69","v":"Operator 2"},{"$f":"K69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,200]
[null,"Application Rate (tons/ac.)","Implement Capacity (tons)","Implement Speed (acres/hr.)",null,"Urea needed (tons)","Phosphorus needed (tons)","Muriate of Potash needed (tons)",null,"K price per lb.",{"$f":"K65/2000/0.6","v":0},null,null,null,null,null,null,null,null,null,null,"Operator 3",0,null,null,null,null,null,null,null,null,null,null,null,null,300]
[null,1,4,10,null,{"$f":"(F65/0.46)*$B$7/2000","v":{"$error":"#VALUE!"}},{"$f":"(G65/0.46)*$B$7/2000","v":0},{"$f":"(H65/0.6)*$B$7/2000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Activity",0,null,null,null,null,null,null,null,null,null,null,null,null,400]
[null,null,null,null,null,{"$f":"K63*F61","v":{"$error":"#VALUE!"}},{"$f":"K64*G61","v":0},{"$f":"K65*H61","v":0},null,null,"$/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500]
[null,"Refill needed every x minutes","Refills needed","Refill time (minutes)",null,null,null,null,null,"Price of Urea (46 - 0 - 0)",{"$f":"'User Page'!F55","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
[null,{"$f":"C61/B61/D61*60","v":24},{"$f":"B58*B61/C61","v":0},10,null,"N (lbs/acre)","P (lbs/acre)","K (lbs/acre)",null,"Price of Phosphorus (0 - 46 - 0)",{"$f":"'User Page'!F56","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000]
[null,null,null,null,null,{"$f":"+Litter!D66","v":"Tractor Used"},{"$f":"+Litter!E66","v":0},{"$f":"+Litter!F66","v":0},null,"Price of Muriate of Potash (0 - 0 - 60)",{"$f":"'User Page'!F57","v":0},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,null,null,null,null,null,null,null,null,"N","P","K"]
[null,"Application Month(s)","Suitable work days (35% probability)","Can I apply this month?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Probabilty of suitable days",null,null,null,null,null,null,null,null,null,null,null,null,null,"Week ending",null,"Percentile probability of days suitable",null,null,null,null,null,null,"Prices in $/cwt",null,"Urea (46% N)","Phosphorus (46% P2O5)","Potash (60% K2O)"]
[null,{"$f":"Litter!$J$17","v":"April"},{"$f":"Litter!$K$17","v":4.0333333333333332},{"$f":"Litter!$L$17","v":"No"},null,"Total Time to apply (hours)","How many days (10 hour work days)",null,null,"Labor Cost","Pay /hr.",null,null,null,null,null,null,null,null,null,"Month",0.15,0.35,0.5,0.65,0.85,null,null,null,null,null,null,null,null,null,null,null,0.15,0.35,0.5,0.65,0.85,null,null,null,2009,16.29,15.35,26.1]
[null,{"$f":"Litter!$J$18","v":"May"},{"$f":"Litter!$K$18","v":20.300000000000004},{"$f":"Litter!$L$18","v":"Yes"},null,{"$f":"(B58/D61)+(C64*(D64/60))","v":0},{"$f":"ROUNDUP(F68/10,0)","v":0},null,null,"Operator 1",{"$f":"Litter!E74","v":0},null,null,null,null,null,null,null,null,null,"April",{"$f":"Litter!AY57","v":0},{"$f":"Litter!AZ57","v":0},{"$f":"Litter!BA57","v":0},{"$f":"Litter!BB57","v":0},{"$f":"Litter!BC57","v":0},null,null,null,null,null,null,null,null,null,"11-Apr",null,2.7,3.6,4.3,4.9000000000000004,5.9,null,null,null,{"$f":"AT67+1","v":2010},19,22,23]
[null,{"$f":"Litter!$J$19","v":"June"},{"$f":"Litter!$K$19","v":20.799999999999997},{"$f":"Litter!$L$19","v":"Yes"},null,null,null,null,null,"Operator 2",{"$f":"Litter!E75","v":0},null,null,null,null,null,null,null,null,null,"May",{"$f":"Litter!AY58","v":0},{"$f":"Litter!AZ58","v":0},{"$f":"Litter!BA58","v":0},{"$f":"Litter!BB58","v":0},{"$f":"Litter!BC58","v":0},null,null,null,null,null,null,null,null,null,"18-Apr",null,3.2,4.0999999999999996,4.8,5.5,6.1,null,null,null,{"$f":"AT68+1","v":2011},22.29,28.65,29.19]
[null,{"$f":"Litter!$J$20","v":"Total Annual\nSuitable Days"},{"$f":"Litter!$K$20","v":144.33333333333334},{"$f":"Litter!$L$20","v":0},null,null,null,null,null,"Operator 3",{"$f":"Litter!E76","v":0},null,null,null,null,null,null,null,null,null,"June",{"$f":"Litter!AY59","v":0},{"$f":"Litter!AZ59","v":0},{"$f":"Litter!BA59","v":0},{"$f":"Litter!BB59","v":0},{"$f":"Litter!BC59","v":0},null,null,null,null,null,null,null,null,null,"25-Apr",null,3.6,4.4000000000000004,4.8,5.2,6,null,null,null,{"$f":"AT69+1","v":2012},28.4,29.3,29.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",{"$f":"Litter!AY60","v":0},{"$f":"Litter!AZ60","v":0},{"$f":"Litter!BA60","v":0},{"$f":"Litter!BB60","v":0},{"$f":"Litter!BC60","v":0},null,null,null,null,null,null,null,null,null,"2-May",null,2.6,3.5,4.0999999999999996,4.7,5.8,null,null,null,2013,22.6,24,23.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",{"$f":"Litter!AY61","v":0},{"$f":"Litter!AZ61","v":0},{"$f":"Litter!BA61","v":0},{"$f":"Litter!BB61","v":0},{"$f":"Litter!BC61","v":0},null,null,null,null,null,null,null,null,null,"9-May",null,3,3.9,4.4000000000000004,5.0999999999999996,6.1,null,null,null,2014,25.25,24.5,23.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",{"$f":"Litter!AY62","v":0},{"$f":"Litter!AZ62","v":0},{"$f":"Litter!BA62","v":0},{"$f":"Litter!BB62","v":0},{"$f":"Litter!BC62","v":0},null,null,null,null,null,null,null,null,null,"16-May",null,3.2,4.2,4.8,5.4,6.4,null,null,null,2015,20.83,25,21.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",{"$f":"Litter!AY63","v":0},{"$f":"Litter!AZ63","v":0},{"$f":"Litter!BA63","v":0},{"$f":"Litter!BB63","v":0},{"$f":"Litter!BC63","v":0},null,null,null,null,null,null,null,null,null,"23-May",null,3.6,4.5999999999999996,5.0999999999999996,5.8,6.6,null,null,null,2016,16.78,21.88,16.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",{"$f":"Litter!AY65","v":0},{"$f":"Litter!AZ65","v":0},{"$f":"Litter!BA65","v":0},{"$f":"Litter!BB65","v":0},{"$f":"Litter!BC65","v":0},null,null,null,null,null,null,null,null,null,"30-May",null,3.3,4.0999999999999996,4.8,5.2,6,null,null,null,2017,14.19,18.78,18.98]
[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,null,null,null,null,null,null,null,null,"6-Jun",null,3,4.8,5.2,5.7,6.3,null,null,null,2018,14.5,23.75,20]
[null,"Category","Description","Tractor Used","Implement Used","Fuel Consumption (GPH)","Operator","Time Cost (Hours)","Equipment Operating Cost","Fuel Cost","Labor Cost","Cost / Acre","Total Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-Jun",null,3.7,5.4,5.8,6,6.5,null,null,null,2019,20.22,18.11,27.5]
[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,"Tractor Asset costs",null,"implement asset costs",null,null,"TOTAL",null,null,null,"20-Jun",null,3.9,5.0999999999999996,5.6,6,6.5,null,"10 yr avg. (converted to tons)",null,null,{"$f":"AVERAGE(AU67:AU77)*20","v":400.63636363636357},{"$f":"AVERAGE(AV67:AV77)*20","v":456.94545454545454},473.0181818181818]
[null,"Purchase","Fertilizer Purchased",null,null,null,"Operator 1",2,0,0,{"$f":"VLOOKUP(G79,$V$7:$W$10,2,FALSE)*H79","v":44},{"$f":"M79/$B$7","v":0.14666666666666667},{"$f":"J79+I79+K79","v":44},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V83:V88)","v":66000},null,{"$f":"SUM(Y83:Y88)","v":0},null,null,{"$f":"AA79+AC79","v":66000},null,null,null,"27-Jun",null,4.3,5.5,5.9,6,6.7]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M80/$B$7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Jul",null,4.2,5.2,5.8,6.2,6.7,null,null,"Price per lb.",null,{"$f":"AU78/100","v":4.0063636363636359},{"$f":"AV78/100","v":4.569454545454545},4.7301818181818183]
[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,null,null,null,null,null,null,null,null,"11-Jul",null,5,5.9,6,6.1,6.9,null,null,"Price of element per lb.",null,{"$f":"AU80/0.46","v":8.7094861660079044},{"$f":"AV80/0.46","v":9.9335968379446626},{"$f":"AW80/0.6","v":7.8836363636363638}]
[null,"Supplemental Fertilizer Cost","Broadcast Supplement","John Deere 5055e 4wd","BBI Spreader",4,"Operator 2",{"$f":"F68","v":0},{"$f":"(VLOOKUP(D82,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E82,Equipment!$K$91:$L$97,2,FALSE))*H82","v":0},{"$f":"F82*H82*$K$6","v":0},{"$f":"VLOOKUP(G82,$V$7:$W$10,2,FALSE)*H82","v":0},{"$f":"M82/$B$7","v":0},{"$f":"J82+I82+K82","v":0},null,null,"Tractor List","hp","Implement List","hp",null,"Tractor List filtered",null,null,"Implement List filtered",null,null,null,null,null,null,null,null,null,null,null,"18-Jul",null,5.5,5.9,6.1,6.6,7]
[null,null,"Fertilizer material",null,null,null,null,0,0,0,0,{"$f":"M83/$B$7","v":69.646561264822139},{"$f":"$H$7","v":20893.96837944664},null,null,{"$f":"D82","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(P83,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E82","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(R83,Equipment!$H$102:$I$108,2,FALSE),0)","v":45},null,{"$f":"P83","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(U83,Equipment!$G$6:$N$12,7,FALSE),0)","v":33000},null,{"$f":"R83","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(X83,Equipment!$G$6:$N$12,7,FALSE),0)","v":"N/A"},null,null,null,null,null,null,null,null,null,null,"25-Jul",null,5,5.9,6.1,6.5,7]
[null,null,"Year 2 Supplement","John Deere 5055e 4wd","BBI Spreader",4,"Operator 2",{"$f":"H82","v":0},{"$f":"I82","v":0},{"$f":"J82","v":0},{"$f":"VLOOKUP(G84,$V$7:$W$10,2,FALSE)*H84","v":0},{"$f":"L82","v":0},0,null,null,{"$f":"D84","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(P84,Equipment!$H$102:$I$108,2,FALSE),0)","v":55},{"$f":"E84","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(R84,Equipment!$H$102:$I$108,2,FALSE),0)","v":45},null,{"$f":"P84","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(U84,Equipment!$G$6:$N$12,7,FALSE),0)","v":33000},null,{"$f":"R84","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(X84,Equipment!$G$6:$N$12,7,FALSE),0)","v":"N/A"},null,null,"Annualized Equipment Cost (Dep., Opp. Cost, Ins., Taxes)","Repair & Maintenance",null,null,null,null,null,null,"1-Aug",null,4.8,5.8,6.1,6.5,7]
[null,null,"Year 2 Fertilizer cost",null,null,null,null,0,{"$f":"I83","v":0},{"$f":"J83","v":0},0,69.646561264822139,20893.96837944664,null,null,{"$f":"D89","v":"None"},{"$f":"IFERROR(VLOOKUP(P85,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E89","v":"None"},{"$f":"IFERROR(VLOOKUP(R85,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(U85,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(X85,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,{"$f":"U83","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(AA85,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA85,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA85,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA85,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA85,Equipment!$G$6:$AB$12,19,FALSE),0)","v":2831.7714816775911},{"$f":"IFERROR(VLOOKUP(AA85,Equipment!$G$6:$AB$12,17,FALSE),0)","v":7.1490717785446369},null,null,null,null,null,null,"8-Aug",null,5.4,5.9,6.1,6.5,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D90","v":"None"},{"$f":"IFERROR(VLOOKUP(P86,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},{"$f":"E90","v":"None"},{"$f":"IFERROR(VLOOKUP(R86,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(U86,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(X86,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,{"$f":"U84","v":"John Deere 5055e 4wd"},{"$f":"IFERROR(VLOOKUP(AA86,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA86,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA86,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA86,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA86,Equipment!$G$6:$AB$12,19,FALSE),0)","v":2831.7714816775911},{"$f":"IFERROR(VLOOKUP(AA86,Equipment!$G$6:$AB$12,17,FALSE),0)","v":7.1490717785446369},null,null,null,null,null,null,"15-Aug",null,5.0999999999999996,6,6.3,6.8,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(P87,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},"None",{"$f":"IFERROR(VLOOKUP(R87,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(U87,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(X87,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(AA87,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA87,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA87,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA87,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA87,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA87,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"22-Aug",null,5,6,6.6,6.8,7]
[null,null,null,"Tractor Used",null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(P88,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},"None",{"$f":"IFERROR(VLOOKUP(R88,Equipment!$H$102:$I$108,2,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(U88,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(X88,Equipment!$G$6:$N$12,7,FALSE),0)","v":0},null,"None",{"$f":"IFERROR(VLOOKUP(AA88,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA88,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA88,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA88,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA88,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA88,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"29-Aug",null,5.3,5.9,6.2,6.6,7]
[null,"Additional user added activities",null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D89,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E89,Equipment!$K$91:$L$97,2,FALSE))*H89, \"Add equipment\")","v":0},{"$f":"F89*H89*$K$6","v":0},{"$f":"VLOOKUP(G89,$V$7:$W$10,2,FALSE)*H89","v":0},{"$f":"M89/$B$7","v":0},{"$f":"I89+K89","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(AA89,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA89,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA89,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA89,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA89,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA89,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"5-Sep",null,4.7,5.8,6.1,6.5,7]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D90,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E90,Equipment!$K$91:$L$97,2,FALSE))*H90, \"Add equipment\")","v":0},{"$f":"F90*H90*$K$6","v":0},0,{"$f":"M90/$B$7","v":0},{"$f":"I90+K90","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(AA90,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA90,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA90,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA90,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA90,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA90,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"12-Sep",null,4.8,5.7,6,6.2,6.9,null,null,null,null,{"$f":"400/20","v":20}]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D91,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E91,Equipment!$K$91:$L$97,2,FALSE))*H91, \"Add equipment\")","v":0},{"$f":"F91*H91*$K$6","v":0},0,{"$f":"M91/$B$7","v":0},{"$f":"I91+K91","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X83","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(AA91,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA91,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA91,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA91,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA91,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA91,Equipment!$G$6:$AB$12,17,FALSE),0)","v":"N/A"},null,null,null,null,null,null,"19-Sep",null,4,5.2,5.7,6.2,6.9]
[null,null,null,"None","None",0,"Operator 1",0,{"$f":"IFERROR((VLOOKUP(D92,Equipment!$K$91:$L$97,2,FALSE)+VLOOKUP(E92,Equipment!$K$91:$L$97,2,FALSE))*H92, \"Add equipment\")","v":0},{"$f":"F92*H92*$K$6","v":0},0,{"$f":"M92/$B$7","v":0},{"$f":"I92+K92","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X84","v":"BBI Spreader"},{"$f":"IFERROR(VLOOKUP(AA92,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA92,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA92,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA92,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA92,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA92,Equipment!$G$6:$AB$12,17,FALSE),0)","v":"N/A"},null,null,null,null,null,null,"26-Sep",null,5,5.8,6,6.2,6.8]
[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,"None",{"$f":"IFERROR(VLOOKUP(AA93,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA93,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA93,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA93,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA93,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA93,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"3-Oct",null,5,5.9,6.1,6.5,7]
[null,null,null,null,null,null,null,{"$f":"H77","v":"Time Cost (Hours)"},{"$f":"I77","v":"Equipment Operating Cost"},"Fuel Cost",{"$f":"K77","v":"Labor Cost"},{"$f":"L77","v":"Cost / Acre"},{"$f":"M77","v":"Total Cost"},null,null,null,null,null,null,null,null,null,null,null,null,null,"None",{"$f":"IFERROR(VLOOKUP(AA94,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA94,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA94,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA94,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA94,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA94,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"10-Oct",null,4.3,5.4,6,6.5,7]
[null,null,null,"TOTAL","Activity Costs",null,null,{"$f":"SUM(H79:H92)","v":2},{"$f":"SUMIF(I79:I92,\"<>#N/A\")","v":0},{"$f":"SUMIF(J79:J92,\"<>#N/A\")","v":0},{"$f":"SUMIF(K79:K92,\"<>#N/A\")","v":44},{"$f":"SUMIF(L79:L92,\"<>#N/A\")","v":139.43978919631093},{"$f":"SUMIF(M79:M92,\"<>#N/A\")","v":41831.93675889328},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X87","v":"None"},{"$f":"IFERROR(VLOOKUP(AA95,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA95,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA95,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA95,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA95,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA95,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0},null,null,null,null,null,null,"17-Oct",null,4,5.2,5.8,6,6.8]
[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":"X88","v":"None"},{"$f":"IFERROR(VLOOKUP(AA96,Equipment!$G$6:$AB$12,12,FALSE)+VLOOKUP(AA96,Equipment!$G$6:$AB$12,15,FALSE)+VLOOKUP(AA96,Equipment!$G$6:$AB$12,17,FALSE)+VLOOKUP(AA96,Equipment!$G$6:$AB$12,18,FALSE)+VLOOKUP(AA96,Equipment!$G$6:$AB$12,19,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(AA96,Equipment!$G$6:$AB$12,17,FALSE),0)","v":0}]

{"sheet":"Comparison","index":6,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,1,2,8],[17,7,17,8],[18,7,18,8],[10,7,10,8],[5,4,5,5],[10,1,10,2]]}
[]
[]
[null,"Summary for Comparison"]
[]
[]
[null,"Acres Fertilized",{"$f":"'User Page'!C5","v":300},null,"Desired Nutrient Content (per year in lbs./acre)",null,null,"Custom Fertilzer Fee",{"$f":"IF(Litter!T49,Litter!F63,\"N/A\")","v":"N/A"}]
[null,null,null,null,"N",{"$f":"+Litter!D14","v":60},null,"Other fees per order",{"$f":"+'User Page'!F10","v":0}]
[null,"Cost of Litter per ton",{"$f":"'User Page'!C7","v":45},null,"P",{"$f":"+Litter!E14","v":40}]
[null,"Delivery Charge (if any)",{"$f":"Litter!C10","v":0},null,"K",{"$f":"+Litter!F14","v":60},null,"Diesel Fuel Price",{"$f":"'User Page'!F18","v":2}]
[]
[null,"Litter Nutrient Analysis in %",null,null,null,"$/ton",null,"Operator Pay"]
[null,"N",{"$f":"+Litter!D15","v":3},null,"Price of Urea (46 - 0 - 0)",{"$f":"'User Page'!F6","v":400.63636363636357},null,"Operator 1",{"$f":"'User Page'!F14","v":20}]
[null,"P",{"$f":"+Litter!E15","v":3},null,"Price of Phosphate (0 - 46 - 0)",{"$f":"'User Page'!F7","v":456.94545454545454},null,"Operator 2",{"$f":"'User Page'!F15","v":15},null,null,null,null,null,null,null,"Pro rated"]
[null,"K",{"$f":"+Litter!F15","v":2.5},null,"Price of Muriate of Potash (0 - 0 - 60)",{"$f":"'User Page'!F8","v":473.0181818181818},null,"Operator 3",{"$f":"'User Page'!F16","v":10},null,null,null,null,null,null,null,"Cost of Nutrients",{"$f":"((Litter!M56/2)+Litter!M62+Litter!M63)","v":20532.600790513836}]
[null,null,null,null,null,null,null,"Custom Litter Applicator Fee ($/acre)",{"$f":"IF(Litter!T48,Litter!F57,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,"Equipment Operating Cost",{"$f":"(((Litter!I54+Litter!I55)/2)+Litter!I59+Litter!I60+Litter!I67+Litter!I68+Litter!I69+Litter!I70)","v":8757.8580347862444}]
[null,null,"Subsurface Litter","Commercial Fertilizer","Custom Broadcast Litter",null,null,"Custom Broadcast Fee ($/ton)",{"$f":"+Litter!O56","v":6},null,null,null,null,null,null,null,"Fuel Cost",{"$f":"((Litter!J54+Litter!J55)/2)+(Litter!J59+Litter!J60+Litter!J67+Litter!J68+Litter!J69+Litter!J70)","v":1042}]
[null,"Application Interval",{"$f":"+Litter!B14","v":2},1,{"$f":"+Litter!O15","v":2},null,null,null,null,null,null,null,null,null,null,null,"Labor Cost",{"$f":"((Litter!K52+Litter!K54+Litter!K55)/2)+(Litter!K59+Litter!K60+Litter!K67+Litter!K68+Litter!K69+Litter!K70)","v":2486}]
[null,"Cost of Nutrients / Yr",{"$f":"(Litter!M56+SUM(Litter!M62:'Litter'!M64))/C17","v":14766.300395256918},{"$f":"+Litter!M98","v":20893.96837944664},{"$f":"(Litter!N54+Litter!N56+SUM(Litter!N62:'Litter'!N64))/E17","v":18056.577075098816},null,null,"Litter N Loss with Broadcast vs. Subsurface"]
[null,"Equipment Cost / Yr",{"$f":"Litter!I73/C17","v":8518.364130205},{"$f":"+Litter!I108/C17","v":300.26101469887476},{"$f":"SUM(Litter!O59:'Litter'!O61)/E17","v":250.21751224906228},null,null,{"$f":"+Litter!C16","v":0.4},null,null,null,null,null,null,null,null,"Pro rated cost per acre litter","Hours total litter (machinery)","Pro rated for litter activity only","percentage","Pro rated costs plus non pro rated standard costs"]
[null,"Fuel Cost / Yr",{"$f":"Litter!J73/C17","v":841},{"$f":"Litter!J108/C17","v":252},{"$f":"+Litter!O63/E17","v":210},null,null,null,null,null,null,null,null,null,null,null,{"$f":"((Litter!L52+Litter!L54+Litter!L55+Litter!L56)/2)+Litter!L59+Litter!L60+Litter!L62+Litter!L63+Litter!L67+Litter!L68+Litter!L69+Litter!L70","v":109.39486275100028},{"$f":"Litter!H73-Litter!H52","v":187},{"$f":"R20-Litter!H59-Litter!H60","v":120},{"$f":"S20/R20","v":0.64171122994652408},{"$f":"(T20*#REF!/2)+(1-T20)*#REF!","v":{"$error":"#REF!"}}]
[null,"Labor Cost / Yr",{"$f":"Litter!K73/C17","v":1749},{"$f":"Litter!K108/C17","v":924},{"$f":"+Litter!O65/E17","v":792}]
[null,"TOTAL Cost / Acre / Yr",{"$f":"Litter!L73/C17","v":86.248881751539727},{"$f":"Litter!L108/C17","v":74.567431313818389},{"$f":"SUM(E18:E21)/C6","v":64.362648624492934},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repair and maintenance adjusted"]
[null,"Field hours / Yr",{"$f":"Litter!H73/Comparison!C17","v":94.5},{"$f":"+Litter!H97","v":42},{"$f":"(Litter!H52+IF(Litter!T49,0,SUM(Litter!N39:N41)))/E17","v":36},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(T20*#REF!/2)+(1-T20)*#REF!","v":{"$error":"#REF!"}}]
[null,"Annualized PV of Cost / Acre",{"$f":"(IF(C25=2,((Litter!M52+Litter!J54+Litter!K54+Litter!J55+Litter!K55+Litter!M56+Litter!J59+Litter!K59+Litter!M62)+(Litter!J60+Litter!K60+Litter!M63)/(1+'User Page'!#REF!)),IF(C25=3,((Litter!M52+Litter!J54+Litter!K54+Litter!J55+Litter!K55+Litter!M56+Litter!J59+Litter!K59+Litter!M62)+(Litter!J60+Litter!K60+Litter!M63)/(1+'User Page'!#REF!)+(Litter!J61+Litter!K61+Litter!M64)/((1+'User Page'!#REF!)^2)),IF(C25=4,((Litter!M52+Litter!J54+Litter!K54+Litter!J55+Litter!K55+Litter!M56+Litter!J59+Litter!K59+Litter!M62)+(Litter!J60+Litter!K60+Litter!M63)/(1+'User Page'!#REF!)+(Litter!M52+Litter!J54+Litter!K54+Litter!J55+Litter!K55+Litter!M56+Litter!J59+Litter!K59+Litter!M62)/((1+'User Page'!#REF!)^2)+(Litter!J60+Litter!K60+Litter!M63)/((1+'User Page'!#REF!)^3)+(Litter!M52+Litter!J54+Litter!K54+Litter!J55+Litter!K55+Litter!M56+Litter!J59+Litter!K59+Litter!M62)/((1+'User Page'!#REF!)^4)+(Litter!J60+Litter!K60+Litter!M63)/((1+'User Page'!#REF!)^5)),(Litter!M52+Litter!J54+Litter!K54+Litter!J55+Litter!K55+Litter!M56+Litter!J59+Litter!K59+Litter!M62)+(Litter!J60+Litter!K60+Litter!M63)/(1+'User Page'!#REF!)+(Litter!J61+Litter!K61+Litter!M64)/((1+'User Page'!#REF!)^2)+(Litter!M52+Litter!J54+Litter!K54+Litter!J55+Litter!K55+Litter!M56+Litter!J59+Litter!K59+Litter!M62)/((1+'User Page'!#REF!)^3)+(Litter!J60+Litter!K60+Litter!M63)/((1+'User Page'!#REF!)^4)+(Litter!J61+Litter!K61+Litter!M64)/((1+'User Page'!#REF!)^5))))/IF(C17*E17=4,2,IF(C17*E17=9,3,6))+C19)/C6","v":{"$error":"#REF!"}},{"$f":"(SUM(Litter!J97:K97,Litter!M98)*((1-(1+'User Page'!#REF!)^-D25)/'User Page'!#REF!)*(1+'User Page'!#REF!)/D25+D19)/C6","v":{"$error":"#REF!"}},{"$f":"(IF(E25=2,((Litter!N52+Litter!N54+Litter!N56+Litter!P59+Litter!Q59+Litter!N62)+(Litter!P60+Litter!Q60+Litter!N63)/(1+'User Page'!#REF!)),IF(E25=3,((Litter!N52+Litter!N54+Litter!N56+Litter!P59+Litter!Q59+Litter!N62)+(Litter!P60+Litter!Q60+Litter!N63)/(1+'User Page'!#REF!)+(Litter!P61+Litter!Q61+Litter!N64)/((1+'User Page'!#REF!)^2)),IF(E25=4,((Litter!N52+Litter!N54+Litter!N56+Litter!P59+Litter!Q59+Litter!N62)+(Litter!P60+Litter!Q60+Litter!N63)/(1+'User Page'!#REF!)+(Litter!N52+Litter!N54+Litter!N56+Litter!P59+Litter!Q59+Litter!N62)/((1+'User Page'!#REF!)^2)+(Litter!P60+Litter!Q60+Litter!N63)/((1+'User Page'!#REF!)^3)+(Litter!N52+Litter!N54+Litter!N56+Litter!P59+Litter!Q59+Litter!N62)/((1+'User Page'!#REF!)^4)+(Litter!P60+Litter!Q60+Litter!N63)/((1+'User Page'!#REF!)^5)),(Litter!N52+Litter!N54+Litter!N56+Litter!P59+Litter!Q59+Litter!N62)+(Litter!P60+Litter!Q60+Litter!N63)/(1+'User Page'!#REF!)+(Litter!P61+Litter!Q61+Litter!N64)/((1+'User Page'!#REF!)^2)+(Litter!N52+Litter!N54+Litter!N56+Litter!P59+Litter!Q59+Litter!N62)/((1+'User Page'!#REF!)^3)+(Litter!P60+Litter!Q60+Litter!N63)/((1+'User Page'!#REF!)^4)+(Litter!P61+Litter!Q61+Litter!N64)/((1+'User Page'!#REF!)^5))))/IF(C17*E17=4,2,IF(C17*E17=9,3,6))+E19)/C6","v":{"$error":"#REF!"}}]
[null,null,{"$f":"IF(C17*E17=4,2,IF(C17*E17=9,3,IF(C17=2,4,5)))","v":2},{"$f":"IF(C17*E17=4,2,IF(C17*E17=9,3,6))","v":2},{"$f":"IF(C17*E17=4,2,IF(C17*E17=9,3,IF(E17=2,4,5)))","v":2}]