{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Cover","Production Data","Depreciable Items","Summary","Egg Production, Feed Intake","NEW","Drop Box Names","Production Q's","Formatting","Feed Intake","Feed Intake Data"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":5,"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":"Cover","index":0,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,1,17,11],[23,1,23,11],[14,1,14,2],[14,3,14,11],[15,1,15,2],[15,3,15,11],[1,1,1,11],[9,1,9,2],[9,3,9,11],[10,1,10,2],[10,3,10,11],[11,1,11,2],[11,3,11,11],[12,1,12,11],[13,1,13,2],[13,3,13,11]]}
[]
[null,"Pastured Based Laying Hens Decision Aid"]
[]
[]
[]
[]
[]
[]
[]
[null,"Purpose:",null,"This decision tool was developed to assist current and potential producers with estimating their costs and returns for a small scale layer enterprise."]
[null,"Options Evaluated:",null,"The management style options are broken down into two categories: stationary and mobile housing. Beyond that the user has control over production data such as breed, mortality rate, feed intake, forage replacement, etc. The user can enter their own data or use the estimates provided by the budget. "]
[null,"General Instructions:",null,"Cells with blue font can be changed by the user. The sheets are linked internally, when a change is made in one sheet, it will automatically update the others. Be sure to read notes provided to the right of each chart. Cells with red triangles in the upper right hand corner contain comments with more information. "]
[null,"Notes for Specific Sheets"]
[null,"Production Data:",null,"Carefully consider each of the questions provided on this sheet, and select the answer from the drop down list options that best describe your layer enterprise. Be sure to utilize the tables at the bottom of the sheet if you are unsure of what data to enter. "]
[null,"Depreciable Items:",null,"Enter the initial cost for depreciable items, number of items, useful life, and interest rate. If there is an item on the list that you do not utilize, simply enter $0.00 under the Initial Cost. Do not be concerned by rows without any information. These have been appropriately updated depending on the answers provided on the Production Data sheet."]
[null,"Mobile/Stationary:",null,"This sheet combines all of the data from the previous sheets into a summary that includes the production data, as well as estimated costs and returns. Few changes can be made to this sheet. "]
[]
[null,"For more information, contact:"]
[null,null,null,"Samantha Kindred",null,null,null,null,"Greg Halich"]
[null,null,null,"Extension Associate",null,null,null,null,"Associate Extension Professor"]
[null,null,null,"Samantha.Kindred@uky.edu",null,null,null,null,"Greg.Halich@uky.edu"]
[null,null,null,"859-257-2996",null,null,null,null,"859-257-8841"]
[]
[null,"Last Updated 6/10/17"]

{"sheet":"Production Data","index":1,"n_rows":169,"n_cols":16,"rows_kept":169,"cut":false,"hidden":false,"merged":[[14,1,14,3],[20,1,20,3],[19,1,19,8],[31,1,31,8],[4,1,4,8],[30,1,30,6],[29,1,29,6],[12,1,12,6],[11,1,11,6],[10,1,10,6],[9,1,9,6],[8,1,8,6],[26,7,26,8],[26,1,26,6],[27,7,27,8],[2,1,2,8],[1,1,1,8],[35,1,35,6],[60,1,60,6],[36,1,36,6],[27,1,27,6],[3,1,3,6],[38,1,38,6],[33,1,33,6],[59,7,59,8],[57,7,57,8],[57,1,57,6],[58,1,58,8],[17,1,17,3],[16,1,16,3],[15,1,15,3],[13,1,13,8],[7,1,7,6],[6,1,6,6],[5,1,5,6],[18,1,18,3],[3,7,3,8],[38,7,38,8],[36,7,36,8],[49,1,49,6],[48,1,48,6],[46,1,46,6],[47,1,47,6],[59,1,59,6],[44,1,44,6],[50,1,50,6],[82,7,84,10],[88,1,88,10],[78,1,78,2],[79,1,79,2],[83,1,83,2],[82,1,82,2],[81,1,81,2],[78,9,78,10],[80,1,80,2],[85,1,85,5],[64,1,64,6],[45,1,45,8],[22,1,22,3],[21,1,21,3],[34,1,34,8],[32,1,32,6],[35,7,35,8],[23,1,23,3],[24,1,24,3],[40,1,40,6],[46,7,46,8],[25,1,25,8],[39,1,39,8],[37,1,37,8],[40,7,40,8],[42,1,42,6],[41,1,41,6],[53,7,53,8],[77,12,77,15],[67,7,67,8],[77,7,77,10],[81,9,81,10],[80,9,80,10],[79,9,79,10],[68,1,68,6],[169,1,169,4],[89,5,89,7],[89,8,89,10],[89,2,89,4],[164,2,165,2],[163,1,163,4],[100,1,101,4],[164,3,164,4],[93,1,93,10],[118,2,118,4],[118,5,118,7],[117,2,117,7],[96,1,96,4],[84,1,84,2],[81,12,82,15],[62,1,62,8],[72,1,72,8],[56,1,56,8],[66,1,66,8],[63,7,63,8],[63,1,63,6],[54,7,54,8],[69,1,69,6],[77,1,77,5],[54,1,54,6],[61,1,61,6],[65,1,65,6],[67,1,67,6],[55,1,55,6],[53,1,53,6],[73,1,73,6],[74,1,74,6],[71,1,71,6],[70,1,70,6]]}
[]
[null,"Layer Flock Production Data and Questions"]
[null,null,null,null,null,null,null,null,null,null,"Notes:"]
[null,"Choose a breed of laying hen for your enterprise. (Select one)",null,null,null,null,null,"Red Sex Linked",null,null,"Breed can have an effect on egg production, feed intake, mortality rate, forage replacement, etc. "]
[]
[null,"Productive Years per Bird",null,null,null,null,null,1,null,null,"This is the number of years the bird is kept for egg laying. If purchased as a chick, this does not include the first few months. "]
[null,"Eggs per Bird, 1st year",null,null,null,null,null,250,null,null,"See Table 1 below for estimates on annual egg production. "]
[null,"Average Eggs per Bird per Productive Year",null,null,null,null,null,{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!H11,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!H12,IF(H6='Drop Box Names'!B6,'Egg Production, Feed Intake'!H13,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!H14,IF(H6='Drop Box Names'!B8,'Egg Production, Feed Intake'!H15)))))","v":250}]
[null,"Adult Live Weight (lbs)",null,null,null,null,null,6,null,null,"See Table 1 below for estimates on adult live weight. "]
[null,"Enter the weeks to productive age:",null,null,null,null,null,18]
[null,"Enter the months a bird is kept once it reaches productive age",null,null,null,null,null,14]
[null,"Final age of the bird when culled, in months",null,null,null,null,null,{"$f":"H11+(H10*7/30)","v":18.2}]
[null,"% of potential egg production…",null,null,null,null,null,0.85]
[]
[null,null,null,null,"% of Eggs","Eggs/Year","Dozens/ Year","Sale Price $/Dozen"]
[null,"Eggs through Wholesale",null,null,0.7,{"$f":"G16*12","v":9725.625},{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!J11*E16,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!M12*E16,IF(H6='Drop Box Names'!B6,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13)*E16,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!M14*E16,IF(H6='Drop Box Names'!B8,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13,'Egg Production, Feed Intake'!J15)*E16)))))","v":810.46875},4]
[null,"Eggs through Retail",null,null,0.25,{"$f":"G17*12","v":3473.4375},{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!J11*E17,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!M12*E17,IF(H6='Drop Box Names'!B6,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13)*E17,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!M14*E17,IF(H6='Drop Box Names'!B8,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13,'Egg Production, Feed Intake'!J15)*E17)))))","v":289.453125},5]
[null,"Eggs NOT Sold",null,null,{"$f":"1-E16-E17","v":5.0000000000000044E-2},{"$f":"G18*12","v":694.68750000000057},{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!J11*E18,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!M12*E18,IF(H6='Drop Box Names'!B6,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13)*E18,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!M14*E18,IF(H6='Drop Box Names'!B8,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13,'Egg Production, Feed Intake'!J15)*E18)))))","v":57.89062500000005},null,null,null,"It is recommended to have a small percentage of eggs not sold for eggs that may be cracked, too dirty, or too small, etc."]
[null,"Total",null,null,{"$f":"SUM(E16:E18)","v":1},{"$f":"SUM(F16:F18)","v":13893.75},{"$f":"SUM(G16:G18)","v":1157.8125}]
[]
[null,null,null,null,"% of Culls","Birds/Year","Packaged Pounds/Year","$/Live Bird","$/Packaged Pound"]
[null,"Culls Sold Live",null,null,0.6,{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!N11*E22/H6,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!N12*E22/H6,IF(H6='Drop Box Names'!B6,'Egg Production, Feed Intake'!N13*E22/H6,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!N14*E22/H6,'Egg Production, Feed Intake'!N15*E22/H6))))","v":32.489999999999995},null,5.5,null,null,"Culls are undesirable birds removed from the flock and processed, maybe due to age or lack of productivity. "]
[null,"Culls Sold Packaged",null,null,0.3,{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!N11*E23/H6,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!N12*E23/H6,IF(H6='Drop Box Names'!B6,'Egg Production, Feed Intake'!N13*E23/H6,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!N14*E23/H6,'Egg Production, Feed Intake'!N15*E23/H6))))","v":16.244999999999997},{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!N11*Summary!J8*E23/H6,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!N12*Summary!J8*E23/H6,IF(H6='Drop Box Names'!B6,'Egg Production, Feed Intake'!N13*Summary!J8*E23/H6,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!N14*Summary!J8*E23/H6,'Egg Production, Feed Intake'!N15*Summary!J8*E23/H6))))","v":68.228999999999985},null,3.5,null,"This is the cost per packaged pound. "]
[null,"Culls NOT Sold",null,null,{"$f":"1-E22-E23","v":0.10000000000000003},{"$f":"IF(H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!N11*E24/H6,IF(H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!N12*E24/H6,IF(H6='Drop Box Names'!B6,'Egg Production, Feed Intake'!N13*E24/H6,IF(H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!N14*E24/H6,'Egg Production, Feed Intake'!N15*E24/H6))))","v":5.4150000000000018},null,null,null,null,"These may be culls that are given away as samples, consumed by family, etc.. "]
[null,"Total",null,null,{"$f":"SUM(E22:E24)","v":1},{"$f":"SUM(F22:F24)","v":54.149999999999991}]
[]
[null,{"$f":"IF(H28='Drop Box Names'!B29,\"How would you like to enter the purchasing and shipping cost of chicks?\",\"How would you like to enter the purchasing and shipping cost of started pullets?\")","v":"How would you like to enter the purchasing and shipping cost of chicks?"},null,null,null,null,null,"Enter Total Cost per Chick"]
[null,"How do you purchase your laying hens? (Select one)",null,null,null,null,null,"Day Old Chicks",null,null,"The initial price of chicks is less, however they require more management, infrastructure, and supplies, and are likely to have a higher death rate while taking longer to reach maturity. It is important to weigh the costs and benefits of chicks and pullets depending on the size of your operation. "]
[]
[null,{"$f":"IF(H28='Drop Box Names'!B29,\"Number of chicks purchased:\",\"Number of started pullets purchased:\")","v":"Number of chicks purchased:"},null,null,null,null,null,60]
[null,"     Number of layers to reach productivity:",null,null,null,null,null,{"$f":"IF(H28='Drop Box Names'!B29,H30-H62,H30)","v":57},null,null,"This is the number of birds expected to be laying at the start of the first productive year based on mortality rates entered below. "]
[]
[null,{"$f":"IF(H28='Drop Box Names'!B29,\"Enter the total purchasing and shipping cost for \"&H30&\" chicks:\",\"Enter the total purchasing and shipping cost for \"&H30&\" pullets:\")","v":"Enter the total purchasing and shipping cost for 60 chicks:"},null,null,null,null,null,150,850,null,"Chicks and pullets can be ordered from www.moyerschicks.com, www.mcmurrayhatchery.com, www.cacklehatchery.com, www.meyerhatchery.com, and other catalogs."]
[null,{"$f":"IF(H28='Drop Box Names'!B29,\"     Total cost per chick:\",\"     Total cost per pullet:\")","v":"     Total cost per chick:"},null,null,null,null,null,{"$f":"H33/H30","v":2.5},{"$f":"I33/H30","v":14.166666666666666},null,"Shipping cost varies greatly depending on distance, as well as the number and size of the birds. Some hatcheries do not ship, but allow for pick up. "]
[]
[null,"Choose a housing type for your layer enterprise. (Select one)",null,null,null,null,null,"Mobile",null,null,"Select the type of housing that best describes your style of management. Stationary housing is less expensive in terms of management inputs, but less flexible with regard to rotation. Mobile housing provides more flexibility with the location, rotation, and forage replacement, but requires more management. "]
[null,"     If \"Mobile,\" which housing type is provided? (Select one)",null,null,null,null,null,"Hoop Houses",null,null,{"$f":"IF(H37='Drop Box Names'!B13,\"A hoop house is typically made from a wooden frame and cattle panels.\", \"A chicken tractor is a coop like structure built onto an axle. \")","v":"A hoop house is typically made from a wooden frame and cattle panels."}]
[]
[null,"What type of fencing is provided for the hens? (Select one)",null,null,null,null,null,"Poly Netting"]
[]
[null,"How do you purchase your feed? (Select one)",null,null,null,null,null,"Ton"]
[null,{"$f":"IF(H41='Drop Box Names'!B41,\"     Enter the price of feed per bag:\",\"     Enter the price of feed per ton:\")","v":"     Enter the price of feed per ton:"},null,null,null,null,null,13.5,600,{"$f":"IF(H41='Drop Box Names'!B41,H42/H43,I42/2000)","v":0.3},"Because of the volatility of the price of feed and its impact on production costs, please be sure to update this cost. "]
[null,"     Enter the pounds per bag:",null,null,null,null,null,50]
[]
[null,"Enter the total other feed costs and supplements per flock:",null,null,null,null,null,200]
[]
[null,"Use estimated feed consumption or enter your own? (Select one)",null,null,null,null,null,"Estimated"]
[null,null,null,null,null,null,null,"Entered","Estimated"]
[null,"     How many pounds of feed per bird does it take to reach maturity?",null,null,null,null,null,16,{"$f":"'Egg Production, Feed Intake'!E32/'Egg Production, Feed Intake'!E27","v":14.368421052631579},null,"Suggested amount of feed to maturity accounts for the excess birds purchased to reach production goal, as well as death loss. "]
[null,"     How many pounds of feed will each bird eat per productive year?",null,null,null,null,null,90,{"$f":"'Egg Production, Feed Intake'!I39/'Egg Production, Feed Intake'!E39","v":83.037499999999994},null,"Suggested amount of feed per bird per productive year accounts for mortality rate, and is for the first year only. "]
[null,{"$f":"IF(H41='Drop Box Names'!B41,\"     Total bags of feed consumed per flock:\",\"     Total tons of feed consumed per flock:\")","v":"     Total tons of feed consumed per flock:"},null,null,null,null,null,{"$f":"IF(H41='Drop Box Names'!B41,(H49+H50)*H31/H43,(H49+H50)*H31/2000)","v":3.0209999999999999},null,null,"This will be slightly different in the Summary, because the feed intake accounts for forage replacement and mortality rates, entered below. "]
[]
[]
[null,"Use the estimated forage replacement or enter your own? (Select one)",null,null,null,null,null,"Estimated",null,null,"Forage replacement is the amount of concentrated feed replaced by pasture, including grasses, legumes, insects, etc."]
[null,"     How often does the flock have access to fresh pasture?",null,null,null,null,null,"Weekly",null,null,"The more frequently birds are given access to fresh pasture, the higher percentage of diet replacement. "]
[null,{"$f":"IF(H54='Drop Box Names'!B32,\"     Based on breed type and access to fresh pasture, forage replacement is:\",\"     Enter the forage replacement as a percentage of the diet:\")","v":"     Based on breed type and access to fresh pasture, forage replacement is:"},null,null,null,null,null,0.1,{"$f":"IF(H55='Drop Box Names'!B46,IF(C114='Drop Box Names'!B58,C100,C99),IF(H55='Drop Box Names'!B47,IF(C114='Drop Box Names'!B58,D100,D99),IF(H55='Drop Box Names'!B48,IF(C114='Drop Box Names'!B58,'Production Data'!E100,'Production Data'!E99),0)))","v":0.05},null,"See Table 5 for more information."]
[]
[null,"How experienced do you consider yourself as a producer? (Select one)",null,null,null,null,null,"Intermediate",null,null,"This has the most impact on the mortality rate for chicks and adult birds.  "]
[]
[null,"Use estimated mortality rate for pre production age or enter your own? (Select one)",null,null,null,null,null,"Estimated",null,null,"This mortality rate is the percentage of the chicks originally purchased."]
[null,{"$f":"IF(H60='Drop Box Names'!B32,\"     Based on experience level and breed the estimated mortality rate is:\",\"     Enter the mortality rate here:\")","v":"     Based on experience level and breed the estimated mortality rate is:"},null,null,null,null,null,0.1,{"$f":"IF(H58='Drop Box Names'!B36,IF(C114='Drop Box Names'!B58,N81,N80),IF(H58='Drop Box Names'!B37,IF(C114='Drop Box Names'!B58,O81,O80),IF(H58='Drop Box Names'!B38,IF(C114='Drop Box Names'!B58,P81,P80))))","v":0.05},null,"See Table 3 for more information."]
[null,"     Number of chicks lost in the brooder:",null,null,null,null,null,{"$f":"IF(H60='Drop Box Names'!B33,H30*H61,H30*I61)","v":3}]
[]
[null,"Use estimated adult mortality rate or enter your own? (Select one)",null,null,null,null,null,"Estimated",null,null,"This mortality rate is the percentage of the birds that survived the brooder. "]
[null,{"$f":"IF(H64='Drop Box Names'!B32,\"     Based on expereince and breed the estimated mortality rate for Year 1 is:\",\"     Enter the mortality rate for Year 1:\")","v":"     Based on expereince and breed the estimated mortality rate for Year 1 is:"},null,null,null,null,null,0.05,{"$f":"IF(C114='Drop Box Names'!B59,IF(H58='Drop Box Names'!B36,C92,IF(H58='Drop Box Names'!B37,F92,I92)),IF(C114='Drop Box Names'!B58,IF(H58='Drop Box Names'!B36,C93,IF(H58='Drop Box Names'!B37,F93,I93))))","v":0.05},null,"See Table 4 for more information."]
[null,"     Number of birds lost in Year 1:",null,null,null,null,null,{"$f":"IF(H64='Drop Box Names'!B33,H31*H65,H31*I65)","v":2.85}]
[]
[null,"Would you like to include labor costs in the budget? (Select one)",null,null,null,null,null,"Yes"]
[null,{"$f":"\"     If you answered \"&'Drop Box Names'!B43&\" please enter your hourly wage:\"","v":"     If you answered Yes please enter your hourly wage:"},null,null,null,null,null,10,null,null,"Chicks and pullets can be ordered from www.moyerschicks.com, www.mcmurrayhatchery.com, www.cacklehatchery.com, www.meyerhatchery.com, and other catalogs."]
[null,"     Enter the minutes per day of labor spent with the chicks, until production age:",null,null,null,null,null,20,"minutes/day"]
[null,"     Enter the minutes per day of labor spent with the production flock:",null,null,null,null,null,20,"minutes/day"]
[null,"     Enter the total hours per year spent on marketing:",null,null,null,null,null,10,"hours/year"]
[]
[null,{"$f":"\"Enter the cost per carton here (\"&C129&\" dozen):\"","v":"Enter the cost per carton here (1100 dozen):"},null,null,null,null,null,0.4,{"$f":"H74*Summary!$E$16","v":439.96875},null,"You can find the labeling regulations for Kentucky here, http://www.kyagr.com/consumer/documents/RI_EGG_SmallProducerGuide.pdf. If you are not located in KY, please check with your Department of Agriculture. "]
[null,{"$f":"\"Enter the cost per label here (\"&C129&\" dozen):\"","v":"Enter the cost per label here (1100 dozen):"},null,null,null,null,null,0.03,{"$f":"H75*Summary!$E$16","v":32.997656249999999},null,"There are many places online to order cartons, including www.eggcartonstore.com. If your cartons are printed, enter $0.00 for labeling cost. "]
[]
[]
[null,"Table 1: Production Data by Breed",null,null,null,null,null,"Table 2: Egg Production",null,null,null,null,"Table 3: Mortality Rates (%) Pre-Production Age"]
[null,"Breed",null,"Weeks to Laying Age","First Year Production","Adult Weight (lb)",null,"Years of Production","% of 1st Year's Production","Eggs per Year",null,null,null,"Novice","Intermediate","Expert"]
[null,"Australorp",null,"20-22","250-300",6.5,null,"Year 1",1,{"$f":"H7","v":250},null,null,"Production",0.15,0.1,0.05]
[null,"Barred Plymouth Rock",null,"22-24","200-250",7.5,null,"Year 2",0.85,{"$f":"J80*I81","v":212.5},null,null,"Dual Purpose",0.1,0.05,2.5000000000000001E-2]
[null,"Black Sex Linked",null,"18-20","250-300",6,null,"Year 3",0.68,{"$f":"J80*I82","v":170},null,null,"White Leghorn and ISA Brown are considered production types, and other breeds are dual purpose. "]
[null,"ISA Brown",null,"18-20","300+",4.4000000000000004,null,"These percentages come from: https://edis.ifas.ufl.edu/PS029#IMAGE PS:PS029F2"]
[null,"Red Sex Linked",null,"20-22","250-300",6]
[null,"White Leghorn",null,"17-18","280-320",4.5]
[]
[]
[]
[null,"Table 4: Mortality Rates (%) Post-Production Age"]
[null,null,"Novice",null,null,"Intermediate",null,null,"Expert"]
[null,null,"Year 1","Year 2","Year 3","Year 1","Year 2","Year 3","Year 1","Year 2","Year 3"]
[null,"Production",0.1,0.15,0.2,7.4999999999999997E-2,0.1,0.15,0.05,7.4999999999999997E-2,0.1]
[null,"Dual Purpose",7.4999999999999997E-2,0.1,0.15,0.05,7.4999999999999997E-2,0.125,2.5000000000000001E-2,0.05,7.4999999999999997E-2]
[null,"White Leghorn and ISA Brown are considered production types, and the other breeds are dual purpose. "]
[]
[]
[null,"Table 5: Forage Replacement (%)"]
[null,null,"Daily","Biweekly","Weekly"]
[null,"Production",7.4999999999999997E-2,0.05,2.5000000000000001E-2]
[null,"Dual Purpose",0.15,0.1,0.05]
[null,"White Leghorn and ISA Brown are considered production types, and other breeds are dual purpose. "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"have them enter the months until productive age"]
[null,null,null,null,null,null,null,null,null,null,"have them enter the total number of months kept after that"]
[]
[]
[null,null,{"$f":"IF(H4='Drop Box Names'!B21,'Drop Box Names'!B58,IF(H4='Drop Box Names'!B22,'Drop Box Names'!B58,IF(H4='Drop Box Names'!B23,'Drop Box Names'!B58,IF(H4='Drop Box Names'!B24,'Drop Box Names'!B59,IF(H4='Drop Box Names'!B25,'Drop Box Names'!B58,IF(H4='Drop Box Names'!B26,'Drop Box Names'!B59,0))))))","v":"Dual Purpose"}]
[null,null,{"$f":"IF(H4='Drop Box Names'!B26,'Drop Box Names'!B55,'Drop Box Names'!B54)","v":"Brown Eggs"}]
[]
[]
[null,null,"Mortality Rate per Year"]
[null,null,{"$f":"'Drop Box Names'!B32","v":"Estimated"},null,null,{"$f":"'Drop Box Names'!B33","v":"My Own"}]
[null,null,"YEAR 1","YEAR 2","YEAR 3","YEAR 1","YEAR 2","YEAR 3"]
[null,null,{"$f":"I65","v":0.05},{"$f":"IF(C114='Drop Box Names'!B59,IF(H58='Drop Box Names'!B36,D92,IF(H58='Drop Box Names'!B37,G92,J92)),IF(C114='Drop Box Names'!B58,IF(H58='Drop Box Names'!B36,D93,IF(H58='Drop Box Names'!B37,G93,J93))))","v":7.4999999999999997E-2},{"$f":"IF(C114='Drop Box Names'!B59,IF(H58='Drop Box Names'!B36,E92,IF(H58='Drop Box Names'!B37,H92,K92)),IF(C114='Drop Box Names'!B58,IF(H58='Drop Box Names'!B36,E93,IF(H58='Drop Box Names'!B37,H93,K93))))","v":0.125},{"$f":"H65","v":0.05},{"$f":"IF(H58='Drop Box Names'!B36,F121*G124,IF(H58='Drop Box Names'!B37,F121*G125,F121*G126))","v":6.9999999999999993E-2},{"$f":"IF(H58='Drop Box Names'!B36,G121*G124,IF(H58='Drop Box Names'!B37,G121*G125,G121*G126))","v":9.799999999999999E-2},null,"Should we have a place eventually to have them enter the mortality rate for years past year 1"]
[null,null,null,null,null,null,null,null,null,"there is a potential for error here, just because we are making assumptions on the mortality rate for years 2 and 3"]
[null,null,null,null,null,"Multiplier for mortality rate per year"]
[null,null,null,null,null,"Novice",1.5]
[null,null,null,null,null,"Intermediate",1.4]
[null,null,null,null,null,"Expert",1.3]
[]
[]
[null,null,{"$f":"ROUND(Summary!E16,0)","v":1100},"dozens per year. This cell is used for the egg cartons and labels above, I needed it to round the total dozens, because otherwise a ton of decimal places appeared. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Forage Replacement (%)"]
[null,null,null,null,null,null,null,"Pastured"]
[null,null,null,null,null,null,null,"Not Often"]
[null,null,null,null,null,null,"Production",2.5000000000000001E-2,"Often","Very Often"]
[null,null,null,null,null,null,"Dual Purpose",0.05,0.05,7.4999999999999997E-2]
[null,null,null,null,null,null,null,null,7.4999999999999997E-2,0.1]
[]
[null,"Labor (Minutes per Day)"]
[null,null,"Coop","Pastured"]
[null,null,null,"Hoop Houses","Ch. Tractor"]
[null,"Novice",25,45,35]
[null,"Intermediate",20,35,25]
[null,"Expert",15,25,20]

{"sheet":"Depreciable Items","index":2,"n_rows":40,"n_cols":35,"rows_kept":40,"cut":false,"hidden":false,"merged":[[40,1,40,11],[39,1,39,10],[2,1,2,11],[7,1,7,11],[22,1,22,11],[24,2,24,11],[9,2,9,11],[38,1,38,11],[6,1,6,3],[5,1,5,3],[37,1,37,8],[21,1,21,8],[6,4,6,5],[5,4,5,5],[1,1,1,11],[4,1,4,3],[3,1,3,3],[4,4,4,5],[3,4,3,5]]}
[]
[null,"Depreciable Items for Layers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes:"]
[null,"Use the suggested number of items or enter below?",null,null,"Enter Below"]
[null,"Use the suggested depreciable life or enter below?",null,null,"Enter Below"]
[null,"Include an interest rate for the depreciable items?",null,null,"Yes"]
[null,"Interest rate:",null,null,0.03]
[]
[null,null,"Cost per Unit","Suggested # of Items","Entered # of Items","% of Use","Total Cost","Suggested Useful Life","Entered Useful Life","Depreciation per Year","Interest Cost per Year","Total Depreciation and Interest per Flock per Year"]
[null,"Larger Depreciable Items",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest","Birds per Item"]
[null,"Brooder",200,{"$f":"ROUNDUP(Summary!$E$5/AI11,0)","v":1},1,1,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$4='Drop Box Names'!$B$51,C11*D11*F11,C11*E11*F11))","v":200},5,10,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$5='Drop Box Names'!$B$51,G11/H11,G11/I11))","v":20},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I11,G11,0)-J11,-PMT($E$7,H11,G11,0)-J11),0)","v":3.446101321031918},{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,J11+K11)","v":23.446101321031918},null,"The recommended stocking density for a brooder is 0.25 square feet per chicks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Coop ",1000,{"$f":"ROUNDUP(Summary!$E$5/AI12,0)","v":1},1,1,{"$f":"IF('Production Data'!H36='Drop Box Names'!B11,0,IF($E$4='Drop Box Names'!$B$51,C12*D12*F12,C12*E12*F12))","v":0},15,15,{"$f":"IF('Production Data'!H33='Drop Box Names'!E9,0,IF($E$5='Drop Box Names'!$B$51,G12/H12,G12/I12))","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I12,G12,0)-J12,-PMT($E$7,H12,G12,0)-J12),0)","v":0},{"$f":"IF('Production Data'!H36='Drop Box Names'!B11,0,J12+K12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Hoop House",350,{"$f":"ROUNDUP(Summary!$E$5/AI13,0)","v":3},2,1,{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,IF('Production Data'!H37='Drop Box Names'!B14,0,IF($E$4='Drop Box Names'!$B$51,C13*D13*F13,C13*E13*F13)))","v":700},10,10,{"$f":"IF('Production Data'!H37='Drop Box Names'!B14,0,IF($E$5='Drop Box Names'!$B$51,G13/H13,G13/I13))","v":70},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I13,G13,0)-J13,-PMT($E$7,H13,G13,0)-J13),0)","v":12.061354623611706},{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,IF('Production Data'!H37='Drop Box Names'!B14,0,J13+K13))","v":82.061354623611706},null,{"$f":"\"Stocking rate of \"&AI13&\" layers per hoop house. Construction and details can be found here: http://www2.ca.uky.edu/agc/pubs/ASC/ASC189/ASC189.pdf\"","v":"Stocking rate of 20 layers per hoop house. Construction and details can be found here: http://www2.ca.uky.edu/agc/pubs/ASC/ASC189/ASC189.pdf"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,"Chicken Tractor",1500,{"$f":"ROUNDUP(Summary!$E$5/AI14,0)","v":1},1,1,{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,IF('Production Data'!H37='Drop Box Names'!B13,0,IF($E$4='Drop Box Names'!$B$51,C14*D14*F14,C14*E14*F14)))","v":0},10,15,{"$f":"IF('Production Data'!H37='Drop Box Names'!B13,0,IF($E$5='Drop Box Names'!$B$51,G14/H14,G14/I14))","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I14,G14,0)-J14,-PMT($E$7,H14,G14,0)-J14),0)","v":0},{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,IF('Production Data'!H37='Drop Box Names'!B13,0,J14+K14))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Fencing, Wire",200,{"$f":"ROUNDUP(Summary!$E$5/AI15,0)","v":1},1,1,{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF('Production Data'!H39='Drop Box Names'!B17,0,IF($E$4='Drop Box Names'!$B$51,C15*D15*F15,C15*E15*F15)))","v":0},10,10,{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF($E$5='Drop Box Names'!$B$51,G15/H15,G15/I15))","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I15,G15,0)-J15,-PMT($E$7,H15,G15,0)-J15),0)","v":0},{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF('Production Data'!H39='Drop Box Names'!B17,0,J15+K15))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Fencing, Poly Netting Rolls",170,{"$f":"ROUNDUP(Summary!$E$5/AI16,0)","v":1},1,1,{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF('Production Data'!H39='Drop Box Names'!B18,0,IF($E$4='Drop Box Names'!$B$51,C16*D16*F16,C16*E16*F16)))","v":170},7,7,{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF($E$5='Drop Box Names'!$B$51,G16/H16,G16/I16))","v":24.285714285714285},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I16,G16,0)-J16,-PMT($E$7,H16,G16,0)-J16),0)","v":3.0003658525119477},{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF('Production Data'!H39='Drop Box Names'!B18,0,J16+K16))","v":27.286080138226232},null,{"$f":"\"This is strictly for the rolls of poly netting. The stocking rate for a 164 ft roll has been suggested to be \"&AI16&\" birds per roll. \"","v":"This is strictly for the rolls of poly netting. The stocking rate for a 164 ft roll has been suggested to be 75 birds per roll. "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,"Fencing Supplies",150,{"$f":"ROUNDUP(Summary!$E$5/AI17,0)","v":1},1,1,{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF($E$4='Drop Box Names'!$B$51,C17*D17*F17,C17*E17*F17))","v":150},7,7,{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,IF($E$5='Drop Box Names'!$B$51,G17/H17,G17/I17))","v":21.428571428571427},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I17,G17,0)-J17,-PMT($E$7,H17,G17,0)-J17),0)","v":2.647381634569367},{"$f":"IF('Production Data'!H39='Drop Box Names'!B16,0,J17+K17)","v":24.075953063140794},null,"This category includes miscellaneous supplies needed for fencing, other than the actual poly netting or chicken wire, such as a charger.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Feed Bin",600,{"$f":"ROUNDUP(Summary!$E$5/AI18,0)","v":1},1,1,{"$f":"IF('Production Data'!H41='Drop Box Names'!B41,0,IF($E$4='Drop Box Names'!$B$51,C18*D18*F18,C18*E18*F18))","v":600},15,15,{"$f":"IF('Production Data'!H41='Drop Box Names'!B41,0,IF($E$5='Drop Box Names'!$B$51,G18/H18,G18/I18))","v":40},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I18,G18,0)-J18,-PMT($E$7,H18,G18,0)-J18),0)","v":10.259948277372814},{"$f":"IF('Production Data'!H41='Drop Box Names'!B41,0,J18+K18)","v":50.259948277372814},null,"As an example, Southern States requires a 3 ton minimum purchase for the feed to be bulk ordered, otherwise it comes in 50 pounds bags.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Refrigerator",500,{"$f":"ROUNDUP(Summary!$E$5/AI19,0)","v":1},0,0.5,{"$f":"IF('Production Data'!H31<'Drop Box Names'!B66,0,IF($E$4='Drop Box Names'!$B$51,C19*D19*F19,C19*E19*F19))","v":0},15,15,{"$f":"IF($E$5='Drop Box Names'!$B$51,G19/H19,G19/I19)","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I19,G19,0)-J19,-PMT($E$7,H19,G19,0)-J19),0)","v":0},{"$f":"IF('Production Data'!H31<'Drop Box Names'!B66,0,J19+K19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Guardian Dog",350,{"$f":"ROUNDUP(Summary!$E$5/AI20,0)","v":1},0,0.3,{"$f":"IF('Production Data'!H31<'Drop Box Names'!B66,0,IF($E$4='Drop Box Names'!$B$51,C20*D20*F20,C20*E20*F20))","v":0},7,7,{"$f":"IF($E$5='Drop Box Names'!$B$51,G20/H20,G20/I20)","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I20,G20,0)-J20,-PMT($E$7,H20,G20,0)-J20),0)","v":0},{"$f":"IF('Production Data'!H31<'Drop Box Names'!B66,0,J20+K20)","v":0},null,"If you use the dog for other livestock or recreational purposes, you may not want to account for the full cost here. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Other",50,1,0,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C21*D21*F21,C21*E21*F21)","v":0},7,7,{"$f":"IF($E$5='Drop Box Names'!$B$51,G21/H21,G21/I21)","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I21,G21,0)-J21,-PMT($E$7,H21,G21,0)-J21),0)","v":0},{"$f":"J21+K21","v":0}]
[null,"Total Larger Depreciable Items Cost",null,null,null,null,null,null,null,{"$f":"SUM(J11:J21)","v":175.71428571428569},{"$f":"SUM(K11:K21)","v":31.415151709097753},{"$f":"SUM(L11:L21)","v":207.12943742338345}]
[]
[null,null,"Cost per Unit","Suggested # of Items","Entered # of Items","% of Use","Total Cost","Suggested Useful Life","Entered Useful Life","Depreciation per Year","Interest Cost per Year","Total Depreciation and Interest per Flock per Year"]
[null,"Smaller Depreciable Items",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest","Birds per Item"]
[null,"Heat Lamps",15,{"$f":"ROUNDUP(Summary!$E$5/AI26,0)","v":1},1,1,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$4='Drop Box Names'!$B$51,C26*D26*F26,C26*E26*F26))","v":15},5,5,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$5='Drop Box Names'!$B$51,G26/H26,G26/I26))","v":3},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I26*12,G26,0),-PMT($E$7,H26*12,G26,0)),0)","v":0.54199438107065867},{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,J26+K26)","v":3.5419943810706584},null,{"$f":"\"Assuming a stocking rate of \"&AI26&\" chicks.\"","v":"Assuming a stocking rate of 75 chicks."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,"Chick Feeder",3.1,{"$f":"ROUNDUP(Summary!$E$5/AI27,0)","v":3},2,1,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$4='Drop Box Names'!$B$51,C27*D27*F27,C27*E27*F27))","v":6.2},3,5,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$5='Drop Box Names'!$B$51,G27/H27,G27/I27))","v":1.24},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I27*12,G27,0),-PMT($E$7,H27*12,G27,0)),0)","v":0.22402434417587222},{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,J27+K27)","v":1.4640243441758722},null,{"$f":"\"Assuming a stocking rate of \"&AI27&\" chicks.\"","v":"Assuming a stocking rate of 25 chicks."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,"Chick Waterer",6.1,{"$f":"ROUNDUP(Summary!$E$5/AI28,0)","v":3},2,1,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$4='Drop Box Names'!$B$51,C28*D28*F28,C28*E28*F28))","v":12.2},3,5,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,IF($E$5='Drop Box Names'!$B$51,G28/H28,G28/I28))","v":2.44},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I28*12,G28,0),-PMT($E$7,H28*12,G28,0)),0)","v":0.44082209660413563},{"$f":"IF('Production Data'!H28='Drop Box Names'!B30,0,J28+K28)","v":2.8808220966041356},null,"Assuming a stocking rate of 25 chicks.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,"Adult Feeder",20,{"$f":"ROUNDUP(Summary!$E$5/AI29,0)","v":2},1,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C29*D29*F29,C29*E29*F29)","v":20},3,5,{"$f":"IF($E$5='Drop Box Names'!$B$51,G29/H29,G29/I29)","v":4},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I29*12,G29,0),-PMT($E$7,H29*12,G29,0)),0)","v":0.72265917476087815},{"$f":"J29+K29","v":4.7226591747608779},null,{"$f":"\"Assuming a stocking rate of \"&AI29&\" birds.\"","v":"Assuming a stocking rate of 50 birds."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,"Adult Waterer",13,{"$f":"ROUNDUP(Summary!$E$5/AI30,0)","v":2},2,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C30*D30*F30,C30*E30*F30)","v":26},3,5,{"$f":"IF($E$5='Drop Box Names'!$B$51,G30/H30,G30/I30)","v":5.2},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I30*12,G30,0),-PMT($E$7,H30*12,G30,0)),0)","v":0.93945692718914153},6.1394569271891415,null,{"$f":"\"Assuming a stocking rate of \"&AI30&\" birds.\"","v":"Assuming a stocking rate of 40 birds."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,"Cart",50,{"$f":"ROUNDUP(Summary!$E$5/AI31,0)","v":1},1,1,{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,IF($E$4='Drop Box Names'!$B$51,C31*D31*F31,C31*E31*F31))","v":50},5,7,{"$f":"IF($E$5='Drop Box Names'!$B$51,G31/H31,G31/I31)","v":7.1428571428571432},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I31*12,G31,0),-PMT($E$7,H31*12,G31,0)),0)","v":1.6366566273339662},{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,J31+K31)","v":8.7795137701911088},null,"The cart is for taking feed out to birds, moving fencing supplies, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Dolly",75,{"$f":"ROUNDUP(Summary!$E$5/AI32,0)","v":1},0,1,{"$f":"IF('Production Data'!H39='Drop Box Names'!B10,0,IF('Production Data'!$H$37='Drop Box Names'!B14,0,IF($E$4='Drop Box Names'!$B$51,C32*D32*F32,C32*E32*F32)))","v":0},5,5,{"$f":"IF('Production Data'!$H$37='Drop Box Names'!B14,0,IF($E$5='Drop Box Names'!$B$51,G32/H32,G32/I32))","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I32*12,G32,0),-PMT($E$7,H32*12,G32,0)),0)","v":0},{"$f":"IF('Production Data'!H39='Drop Box Names'!B10,0,IF('Production Data'!$H$37='Drop Box Names'!B14,0,J32+K32))","v":0},null,"A dolly is a common method of moving hoop houses. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Egg Basket",13,{"$f":"ROUNDUP(Summary!$E$5/AI33,0)","v":2},1,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C33*D33*F33,C33*E33*F33)","v":13},3,5,{"$f":"IF($E$5='Drop Box Names'!$B$51,G33/H33,G33/I33)","v":2.6},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I33*12,G33,0),-PMT($E$7,H33*12,G33,0)),0)","v":0.46972846359457077},3.0697284635945707,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,"Egg Washing Equipment",12,{"$f":"ROUNDUP(Summary!$E$5/AI34,0)","v":1},1,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C34*D34*F34,C34*E34*F34)","v":12},5,5,{"$f":"IF($E$5='Drop Box Names'!$B$51,G34/H34,G34/I34)","v":2.4},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I34*12,G34,0),-PMT($E$7,H34*12,G34,0)),0)","v":0.43359550485652693},2.8335955048565267,null,"You can find a list of egg handling guidelines for Kentucky here, http://www.kyagr.com/consumer/documents/RI_EGG_SmallProducerGuide.pdf. If you are not located in KY, double check with your Department of Agriculture. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Scale",20,{"$f":"ROUNDUP(Summary!$E$5/AI35,0)","v":1},0,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C35*D35*F35,C35*E35*F35)","v":0},5,5,{"$f":"IF($E$5='Drop Box Names'!$B$51,G35/H35,G35/I35)","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I35*12,G35,0),-PMT($E$7,H35*12,G35,0)),0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Marketing Supplies",100,{"$f":"ROUNDUP(Summary!$E$5/AI36,0)","v":1},1,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C36*D36*F36,C36*E36*F36)","v":100},5,5,{"$f":"IF($E$5='Drop Box Names'!$B$51,G36/H36,G36/I36)","v":20},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I36*12,G36,0),-PMT($E$7,H36*12,G36,0)),0)","v":3.6132958738043905},23.61329587380439,null,"This category includes promotional items such as signage, car decals, bags, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Summary!$E$5","v":57}]
[null,"Other",50,1,0,1,{"$f":"IF($E$4='Drop Box Names'!$B$51,C37*D37*F37,C37*E37*F37)","v":0},5,5,{"$f":"IF($E$5='Drop Box Names'!$B$51,G37/H37,G37/I37)","v":0},{"$f":"IF($E$6='Drop Box Names'!$B$43,IF($E$5='Drop Box Names'!$B$52,-PMT($E$7,I37*12,G37,0),-PMT($E$7,H37*12,G37,0)),0)","v":0},{"$f":"J37+K37","v":0}]
[null,"Total Smaller Depreciable Items Cost",null,null,null,null,null,null,null,{"$f":"SUM(J26:J37)","v":48.022857142857141},{"$f":"SUM(K26:K37)","v":9.0222333933901417},{"$f":"SUM(L26:L37)","v":57.04509053624728}]
[]
[null,"Total Depreciable Costs",null,null,null,null,null,null,null,null,null,{"$f":"L22+L38","v":264.17452795963072}]

{"sheet":"Summary","index":3,"n_rows":85,"n_cols":21,"rows_kept":85,"cut":false,"hidden":false,"merged":[[16,1,16,9],[12,4,12,9],[8,6,8,8],[7,6,7,8],[6,6,6,8],[6,2,6,3],[5,6,5,8],[4,6,4,8],[73,11,73,12],[73,16,73,17],[74,11,74,12],[74,16,74,20],[67,4,67,7],[68,11,68,14],[68,16,68,20],[69,11,69,12],[69,16,69,17],[22,1,22,9],[20,1,20,9],[23,1,23,3],[21,1,21,8],[45,1,45,3],[75,11,75,13],[75,16,75,17],[70,11,70,14],[70,16,70,17],[71,11,71,12],[71,16,71,17],[72,11,72,12],[72,16,72,17],[24,4,24,9],[44,1,44,9],[26,2,26,3],[25,2,25,3],[42,1,42,9],[43,1,43,7],[39,2,39,3],[32,2,32,3],[27,2,27,3],[31,2,31,3],[38,2,38,3],[40,2,40,3],[36,2,36,3],[46,4,46,9],[11,1,11,3],[9,2,9,3],[8,2,8,3],[7,2,7,3],[10,1,10,9],[13,2,13,3],[12,1,12,3],[15,2,15,3],[14,2,14,3],[33,2,33,3],[18,2,18,3],[19,2,19,3],[17,2,17,3],[24,1,24,3],[35,2,35,3],[60,1,60,9],[57,1,57,9],[52,1,52,9],[53,1,53,6],[56,1,56,6],[55,1,55,6],[54,1,54,9],[59,1,59,8],[58,1,58,8],[4,11,4,14],[1,1,1,9],[2,1,2,9],[3,1,3,3],[3,4,3,9],[5,2,5,3],[4,2,4,3],[9,11,12,14],[9,6,9,8],[51,1,51,6],[30,2,30,3],[29,2,29,3],[28,2,28,3],[46,1,46,3],[50,2,50,3],[48,2,48,3],[49,2,49,3],[47,2,47,3],[41,1,41,6],[37,2,37,3],[34,2,34,3]]}
[]
[null,{"$f":"\"Layer Production Costs and Returns, weighted average for \"&E9&\" years\"","v":"Layer Production Costs and Returns, weighted average for 1 years"}]
[]
[null,"Projected Costs and Returns"]
[null,null,"Number of Mature Layers",null,{"$f":"'Production Data'!H31","v":57},null,"Forage Replacement",null,null,{"$f":"IF('Production Data'!H54='Drop Box Names'!B32,'Production Data'!I56,'Production Data'!H56)","v":0.05},null,"Yearly Egg Production and Profits (in dozens)"]
[null,null,"Mortality Rate (pre-production)",null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,IF('Production Data'!H60='Drop Box Names'!B32,'Production Data'!I61,'Production Data'!H61),0)","v":0.05},null,"Finished Live Weight (lb)",null,null,{"$f":"'Production Data'!H9","v":6},null,null,"Year 1","Year 2","Year 3"]
[null,null,"Mortality Rate, Year 1 (adult)",null,{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!I65,'Production Data'!H65)","v":0.05},null,"Dressing %",null,null,0.7,null,"Dozens of Eggs",{"$f":"'Egg Production, Feed Intake'!J11*(1-J10)","v":1099.921875},{"$f":"'Egg Production, Feed Intake'!J13*(1-J10)","v":876.79990234374998},{"$f":"'Egg Production, Feed Intake'!J15*(1-J10)","v":631.97915039062502}]
[null,null,"Total Eggs per Bird, Year 1",null,{"$f":"'Production Data'!J80","v":250},null,"Packaging Weight (lb)",null,null,{"$f":"J6*J7","v":4.1999999999999993},null,"Revenue",{"$f":"(M7*$G$16)+J20","v":5106.6371250000002},{"$f":"(N7*$G$16)+J20","v":4155.4329257812506},{"$f":"(O7*$G$16)+J20","v":3111.7234042968753}]
[null,null,"Productive Years per Bird",null,{"$f":"'Production Data'!H6","v":1},null,"% of Culls NOT Sold",null,null,{"$f":"'Production Data'!E24","v":0.10000000000000003},null,"Net Profit",{"$f":"M8-$J$54","v":334.75533662370253},{"$f":"N8-$J$54","v":-616.4488625950471},{"$f":"O8-$J$54","v":-1660.1583840794224}]
[null,null,"Avg Eggs per Bird per Year",null,{"$f":"IF($E$9='Drop Box Names'!B4,'Egg Production, Feed Intake'!H11,IF($E$9='Drop Box Names'!B5,'Egg Production, Feed Intake'!H12,IF($E$9='Drop Box Names'!B6,'Egg Production, Feed Intake'!H13,IF($E$9='Drop Box Names'!B7,'Egg Production, Feed Intake'!H14,IF($E$9='Drop Box Names'!B8,'Egg Production, Feed Intake'!H15)))))","v":250},null,"% of Eggs NOT Sold",null,null,{"$f":"'Production Data'!E18","v":5.0000000000000044E-2},null,"This chart shows the significant effects of decreased egg production and mortality rate on the net profit for each year the hen is kept. See the \"comment\" above (by hovering your mouse over the title of the table) for more details.  "]
[]
[null,null,null,null,"Amount","Unit","Sale Price","% of Product",null,"Revenue/ Flock"]
[null,"Expected Gross Returns per Year"]
[null,null,"Eggs Sold Wholesale:",null,{"$f":"IF(E9='Drop Box Names'!B4,'Egg Production, Feed Intake'!J11*H14,IF(E9='Drop Box Names'!B5,'Egg Production, Feed Intake'!M12*H14,IF(E9='Drop Box Names'!B6,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13)*H14,IF(E9='Drop Box Names'!B7,'Egg Production, Feed Intake'!M14*H14,IF(E9='Drop Box Names'!B8,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13,'Egg Production, Feed Intake'!J15)*H14)))))","v":810.46875},"Dozen",{"$f":"'Production Data'!H16","v":4},{"$f":"'Production Data'!E16","v":0.7},null,{"$f":"E14*G14","v":3241.875}]
[null,null,"Eggs Sold Retail:",null,{"$f":"IF(E9='Drop Box Names'!B4,'Egg Production, Feed Intake'!J11*H15,IF(E9='Drop Box Names'!B5,'Egg Production, Feed Intake'!M12*H15,IF(E9='Drop Box Names'!B6,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13)*H15,IF(E9='Drop Box Names'!B7,'Egg Production, Feed Intake'!M14*H15,IF(E9='Drop Box Names'!B8,AVERAGE('Egg Production, Feed Intake'!J11,'Egg Production, Feed Intake'!J13,'Egg Production, Feed Intake'!J15)*H15)))))","v":289.453125},"Dozen",{"$f":"'Production Data'!H17","v":5},{"$f":"'Production Data'!E17","v":0.25},null,{"$f":"E15*G15","v":1447.265625}]
[null,null,"Total Eggs Sold:",null,{"$f":"SUM(E14:E15)","v":1099.921875},"Dozen",{"$f":"((G14*E14)+(G15*E15))/E16","v":4.2631578947368425},{"$f":"SUM(H14:H15)","v":0.95},null,{"$f":"SUM(J14:J15)","v":4689.140625}]
[]
[null,null,"Cull Birds Sold Live:",null,{"$f":"IF(E9='Drop Box Names'!B4,'Egg Production, Feed Intake'!N11*H18/E9,IF(E9='Drop Box Names'!B5,'Egg Production, Feed Intake'!N12*H18/E9,IF(E9='Drop Box Names'!B6,'Egg Production, Feed Intake'!N13*H18/E9,IF(E9='Drop Box Names'!B7,'Egg Production, Feed Intake'!N14*H18/E9,'Egg Production, Feed Intake'!N15*H18/E9))))","v":32.489999999999995},"Bird",{"$f":"'Production Data'!H22","v":5.5},{"$f":"'Production Data'!E22","v":0.6},null,{"$f":"E18*G18","v":178.69499999999996}]
[null,null,"Cull Birds Sold Packaged:",null,{"$f":"IF(E9='Drop Box Names'!B4,'Egg Production, Feed Intake'!N11*J8*H19/E9,IF(E9='Drop Box Names'!B5,'Egg Production, Feed Intake'!N12*J8*H19/E9,IF(E9='Drop Box Names'!B6,'Egg Production, Feed Intake'!N13*J8*H19/E9,IF(E9='Drop Box Names'!B7,'Egg Production, Feed Intake'!N14*J8*H19/E9,'Egg Production, Feed Intake'!N15*J8*H19/E9))))","v":68.228999999999985},"Pound",{"$f":"'Production Data'!I23","v":3.5},{"$f":"'Production Data'!E23","v":0.3},null,{"$f":"E19*G19","v":238.80149999999995}]
[null,null,"Total Culls:",null,{"$f":"SUM(H18:H19)","v":0.89999999999999991},{"$f":"(E18*J6)+E19","v":263.16899999999998},"Pound",{"$f":"SUM(H18:H19)","v":0.89999999999999991},null,{"$f":"SUM(J18:J19)","v":417.49649999999991},null,{"$f":"\"This shows the average income from cull birds over \"&E9&\" years of production. Total revenue will not be availble until the birds are culled.\"","v":"This shows the average income from cull birds over 1 years of production. Total revenue will not be availble until the birds are culled."}]
[]
[null,"Total Expected Gross Returns per Year",null,null,null,null,null,null,null,{"$f":"J16+J20","v":5106.6371250000002}]
[]
[null,null,null,null,"Amount","Unit","Cost / Unit","Cost / Dozen Eggs","Cost / Layer","Cost / Flock"]
[null,"Variable Costs per Year"]
[null,null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B30, 'Drop Box Names'!B30, 'Drop Box Names'!B29)","v":"Day Old Chicks"},null,{"$f":"'Production Data'!H30","v":60},{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,\"chicks\",\"pullets\")","v":"chicks"},{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,'Production Data'!H34,'Production Data'!I34)","v":2.5},{"$f":"E26*G26/$E$16","v":0.13637332196888985},{"$f":"E26*G26/$E$5","v":2.6315789473684212},{"$f":"G26*E26","v":150},null,"Accounts for shipping cost, death loss in the brooder if applicable, and the number of productive years. "]
[null,null,"Feed",null,{"$f":"IF('Production Data'!H41='Drop Box Names'!B40,C84/2000,C84/'Production Data'!H43)","v":2.6372653124999998},{"$f":"IF('Production Data'!H41='Drop Box Names'!B40,\"tons/flock\",\"bags/flock\")","v":"tons/flock"},{"$f":"IF('Production Data'!H41='Drop Box Names'!B40,'Production Data'!I42,'Production Data'!H42)","v":600},{"$f":"E27*G27/$E$16","v":1.4386105263157893},27.7606875,{"$f":"G27*E27","v":1582.3591875},null,"Accounts for forage replacement, death loss, and feeding the bird to maturity if applicable. "]
[null,null,"Other Feed/Supplements",null,1,"flock",{"$f":"'Production Data'!H45","v":200},{"$f":"E28*G28/$E$16","v":0.18183109595851979},3.5087719298245612,{"$f":"E28*G28","v":200}]
[null,null,"Bedding",null,2,"bales/flock",7,1.2728176717096385E-2,0.24561403508771928,{"$f":"G29*E29","v":14}]
[null,null,"Pasture Management",null,1,"flock",20,{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,E30*G30/$E$16)","v":1.8183109595851978E-2},0.35087719298245612,{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,0,G30*E30)","v":20}]
[null,null,"Cartons & Labels",null,1,"flock",{"$f":"SUM('Production Data'!I74:I75)","v":472.96640624999998},{"$f":"E31*G31/$E$16","v":0.43},8.2976562499999993,{"$f":"G31*E31","v":472.96640624999998}]
[null,null,"Transportation",null,1,"flock",150,{"$f":"E32*G32/$E$16","v":0.13637332196888985},2.6315789473684212,150,null,"Account for transportation costs related to marketing and processing here. Remember fuel, maintenance, and other costs. "]
[null,null,"Processing Culls",null,{"$f":"'Production Data'!F23","v":16.244999999999997},"culls/flock",7,{"$f":"E33*G33/$E$16","v":0.10338461538461537},1.9949999999999997,{"$f":"G33*E33","v":113.71499999999997}]
[null,null,"Dog Maintenance",null,{"$f":"IF('Depreciable Items'!E4='Drop Box Names'!B51,'Depreciable Items'!D20,'Depreciable Items'!E20)","v":0},"flock",0,0,{"$f":"E34*G34/$E$5","v":0},{"$f":"IF('Production Data'!H31<'Drop Box Names'!B66,0,G34*E34)","v":0},null,"Enter the variable costs per year per Livestock Guardian Dog, such as the feed and vet bills. "]
[null,null,"Maintenance & Repair",null,1,"flock",15,{"$f":"E35*G35/$E$16","v":1.3637332196888983E-2},0.26315789473684209,{"$f":"G35*E35","v":15}]
[null,null,"Marketing (not labor)",null,1,"flock",20,1.8183109595851978E-2,0.35087719298245612,20,null,"This may include costs such as farmer market or website fees, etc. that are paid on an annual basis. "]
[null,null,"Chick Labor (hrs)",null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,IF('Egg Production, Feed Intake'!E23='Drop Box Names'!B61,('Egg Production, Feed Intake'!F19*'Production Data'!H10*7)/60,IF('Egg Production, Feed Intake'!E23='Drop Box Names'!B62,('Egg Production, Feed Intake'!F21*'Production Data'!H10*7)/60,('Egg Production, Feed Intake'!F20*'Production Data'!H10*7)/60)),0)","v":37.799999999999997},"hours/flock",{"$f":"IF('Production Data'!H68='Drop Box Names'!B43,'Production Data'!H69,0)","v":10},0.34366077136160239,6.6315789473684212,378,null,{"$f":"IF('Production Data'!H68='Drop Box Names'!B44,\"Labor is not included. Change in Production Data sheet.\",\"\")","v":""}]
[null,null,"Production Labor (hrs)",null,{"$f":"'Production Data'!H71*365/60","v":121.66666666666667},"hours/flock",{"$f":"IF('Production Data'!H68='Drop Box Names'!B43,'Production Data'!H69,0)","v":10},1.1061391670809955,21.345029239766085,{"$f":"G38*E38","v":1216.6666666666667},null,{"$f":"IF('Production Data'!H68='Drop Box Names'!B44,\"Labor is not included. Change in Production Data sheet.\",\"\")","v":""}]
[null,null,"Marketing (hrs)",null,{"$f":"'Production Data'!H72","v":10},"hours/flock",{"$f":"IF('Production Data'!H68='Drop Box Names'!B43,'Production Data'!H69,0)","v":10},{"$f":"E39*G39/$E$16","v":9.0915547979259895E-2},1.7543859649122806,{"$f":"G39*E39","v":100},null,{"$f":"IF('Production Data'!H68='Drop Box Names'!B44,\"Labor is not included. Change in Production Data sheet.\",\"\")","v":""}]
[null,null,"Transportation Labor (hrs)",null,null,"hours/flock",null,null,0]
[null,null,"Other ",null,1,"flock",50,4.5457773989629947E-2,{"$f":"E41*G41/$E$5","v":0.8771929824561403},{"$f":"G41*E41","v":50}]
[null,"Total Variable Costs per Year",null,null,null,null,null,{"$f":"SUM(H26:H41)","v":4.0754778701138807},{"$f":"SUM(I26:I41)","v":78.6439870248538},{"$f":"SUM(J26:J41)","v":4482.7072604166669}]
[]
[null,"Return over Variable Costs",null,null,null,null,null,null,{"$f":"(J22/E5)-I42","v":10.9461379751462},{"$f":"J22-J42","v":623.92986458333326}]
[]
[null,null,null,null,"Amount","Unit","Cost / Unit","Cost / Dozen Eggs","Cost / Layer","Cost / Flock"]
[null,"Fixed Costs per Year"]
[null,null,"Larger Depr Items - Facilities",null,1,"flock",{"$f":"SUM('Depreciable Items'!L11:L18)","v":207.12943742338345},{"$f":"(E48*G48)/$E$16","v":0.18831286305982728},{"$f":"E48*G48/$E$5","v":3.6338497793576043},{"$f":"G48*E48","v":207.12943742338345},null,"Includes housing and fencing; also includes the initial cost of the feed bin if applicable. "]
[null,null,"Larger Depr Items - Equipment",null,1,"flock",{"$f":"SUM('Depreciable Items'!L19:L21)","v":0},{"$f":"(E49*G49)/$E$16","v":0},{"$f":"E49*G49/$E$5","v":0},{"$f":"G49*E49","v":0},null,"Refrigerator and initial cost of the Guardian Dog if applicable. "]
[null,null,"Smaller Depr Items",null,1,"flock",{"$f":"SUM('Depreciable Items'!L26:L37)","v":57.04509053624728},{"$f":"(E50*G50)/$E$16","v":5.1862856656294136E-2},{"$f":"E50*G50/$E$5","v":1.000791062039426},{"$f":"G50*E50","v":57.04509053624728},null,"Heat lamps, waterers, feeders, marketing supplies, egg washing equipment, cart, and dolly if applicable."]
[null,null,"Other",null,1,"flock",25,2.2728886994814974E-2,{"$f":"E51*G51/$E$5","v":0.43859649122807015},25,null,"Land costs, insurances, and utilities charges. Check with your state Department of Agriculture to determine the guidelines for being licensed to sell eggs. "]
[null,"Total Fixed Costs per Year",null,null,null,null,null,{"$f":"SUM(H48:H51)","v":0.26290460671093641},{"$f":"SUM(I48:I51)","v":5.0732373326251006},{"$f":"SUM(J48:J51)","v":289.17452795963072}]
[]
[null,"Total Fixed and Variable Costs per Year",null,null,null,null,null,{"$f":"H42+H52","v":4.3383824768248171},{"$f":"I42+I52","v":83.717224357478898},{"$f":"J42+J52","v":4771.8817883762977}]
[]
[null,null,null,null,null,null,null,"Per Dozen","Per Layer","Per Flock"]
[null,{"$f":"IF('Production Data'!H68='Drop Box Names'!B43,\"NET PROFIT PER YEAR (including labor)\",\"NET PROFIT PER YEAR (not including labor)\")","v":"NET PROFIT PER YEAR (including labor)"},null,null,null,null,null,{"$f":"J57/E16","v":0.30434464868125521},{"$f":"J57/E5","v":5.8729006425210972},{"$f":"J22-J54","v":334.75533662370253},null,"This net profit includes the revenue from the cull birds."]
[]
[null,{"$f":"IF('Production Data'!H68='Drop Box Names'!B43,\"Breakeven Price per Dozen over Variable Costs (including labor)\",\"Breakeven Price per Dozen over Variable Costs (not including labor)\")","v":"Breakeven Price per Dozen over Variable Costs (including labor)"},null,null,null,null,null,null,null,{"$f":"(J42-J20)/E16","v":3.6959086393446507},null,"This includes income from cull birds."]
[null,{"$f":"IF('Production Data'!H68='Drop Box Names'!B43,\"Breakeven Price per Dozen over All Costs (including labor)\",\"Breakeven Price per Dozen over All Costs (not including labor)\")","v":"Breakeven Price per Dozen over All Costs (including labor)"},null,null,null,null,null,null,null,{"$f":"(J54-J20)/E16","v":3.9588132460555867},null,"This includes income from cull birds."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Quant.","Unit","Price","Total"]
[null,"Annual Marketing Transportation Costs"]
[null,null,"Fuel Economy",null,18.5,"mpg",null,null,null,null,null,"Calculated \"Other\" Costs",null,null,null,null,"Cents per Mile of \"Other\" Transportation Costs (2015)"]
[null,null,"Fuel Economy",null,1,"gal",2.75,null,null,null,null,"Annual mileage:",null,15000,null,null,null,null,"High","Medium","Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance, Repairs",null,{"$f":"T71-(T71*S76)","v":0.04},0.05,{"$f":"T71+(T71*S76)","v":6.0000000000000005E-2}]
[null,null,"Total Miles for Marketing",null,1500,"miles/year",null,null,null,null,null,null,null,"Annual Cost","$/Mile",null,"Tires",null,{"$f":"T72-(T72*S76)","v":8.0000000000000002E-3},0.01,{"$f":"T72+(T72*S76)","v":1.2E-2}]
[null,null,"Transportation Labor",null,50,"hours/year",{"$f":"IF('Production Data'!H68='Drop Box Names'!B43,'Production Data'!H69,0)","v":10},{"$f":"E73*G73","v":500},null,null,null,"Maintenance, Repairs",null,750,{"$f":"N73/N70","v":0.05},null,"Depreciation",null,{"$f":"T73-(T73*S76)","v":7.1999999999999995E-2},0.09,{"$f":"T73+(T73*S76)","v":0.108}]
[null,null,"Eggs & Culls % of Annual Sales",null,0.3,null,null,null,null,null,null,"Tires",null,500,{"$f":"N74/N70","v":3.3333333333333333E-2},null,"Total",null,{"$f":"SUM(S71:S73)","v":0.12},{"$f":"SUM(T71:T73)","v":0.15},{"$f":"SUM(U71:U73)","v":0.18}]
[null,"Costs ($/mile), Annual Marketing Transportation",null,null,null,null,null,null,null,null,null,"Depreciation",null,1000,{"$f":"N75/N70","v":6.6666666666666666E-2},null,"Source: http://www.lrrb.org/media/reports/200319.pdf, adjusted for 2015 using CPI calculator"]
[null,null,"Fuel",null,{"$f":"E72*E74","v":450},"mile",{"$f":"G70/E69","v":0.14864864864864866},{"$f":"E76*G76","v":66.891891891891902},null,null,null,"Total",null,null,{"$f":"SUM(O73:O75)","v":0.15000000000000002},null,"Change by:",null,0.2]
[null,null,"Labor",null,{"$f":"E72*E74","v":450},"mile",{"$f":"H73/E72","v":0.33333333333333331},{"$f":"E77*G77","v":150}]
[null,null,"Other","Enter",{"$f":"E72*E74","v":450},"mile",0.17,{"$f":"IF(D78='Drop Box Names'!B68,E78*G78,E78*O76)","v":76.5}]
[null,"Total Annual Marketing Transportation Cost",null,null,null,null,null,{"$f":"SUM(H76:H78)","v":293.39189189189187}]
[]
[]
[]
[null,null,{"$f":"(('Production Data'!H11/2*31*'Production Data'!H71)+('Production Data'!H11/2*30*'Production Data'!H71))/60","v":142.33333333333334},"production labor hours if we use the \"enter months until culled\"system"]
[null,null,{"$f":"IF('Production Data'!H6='Drop Box Names'!B4,'Egg Production, Feed Intake'!K51*(1-J5),IF('Production Data'!H6='Drop Box Names'!B5,'Egg Production, Feed Intake'!K52*(1-J5),IF('Production Data'!H6='Drop Box Names'!B6,'Egg Production, Feed Intake'!K53*(1-J5),IF('Production Data'!H6='Drop Box Names'!B7,'Egg Production, Feed Intake'!K54*(1-J5),'Egg Production, Feed Intake'!K55*(1-J5)))))","v":5274.5306249999994},"pounds per flock of feed intake, accounting for mortality and forage replacement"]
[null,null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,('Production Data'!H70*'Production Data'!H10*7)/60,0)","v":42},"chick labor - once I add in the cell where they enter the weeks to productive age"]

{"sheet":"Egg Production, Feed Intake","index":4,"n_rows":65,"n_cols":20,"rows_kept":65,"cut":false,"hidden":true,"merged":[[9,1,9,3],[8,1,8,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[1,1,1,9],[3,6,3,9],[3,1,3,4],[6,7,6,8],[5,7,5,8],[4,7,4,8],[14,2,14,3],[13,2,13,3],[12,2,12,3],[11,2,11,3],[10,2,10,3],[17,4,17,7],[22,4,22,6],[22,2,22,3],[20,2,20,3],[19,2,19,3],[18,2,18,3],[16,1,16,3],[17,1,17,3],[49,4,49,11],[43,4,43,11],[37,4,37,11],[49,1,49,3],[47,2,47,3],[48,2,48,3],[44,2,44,3],[43,1,43,3],[45,2,45,3],[46,2,46,3],[37,1,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[24,1,24,3],[26,2,26,3],[25,2,25,3],[36,1,36,3],[31,2,31,3],[30,2,30,3],[29,2,29,3],[27,2,27,3],[28,2,28,3]]}
[]
[null,"Egg Production and Feed Consumption"]
[]
[null,"If Buying Chicks",null,null,null,null,"If Buying Started Pullets"]
[null,null,"Chicks Purchased",null,{"$f":"'Production Data'!H30","v":60},null,null,"Pullet purchased",null,{"$f":"'Production Data'!H30","v":60}]
[null,null,"Mortality Rate, preproduction",null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,IF('Production Data'!H60='Drop Box Names'!B32,'Production Data'!I61,'Production Data'!H61),0)","v":0.05},null,null,"Mortality Rate, preproduction",null,0,null,"Mortality rate for pullets is 0.0% because birds are purchased within a few weeks of produciton age"]
[null,null,"Birds at productive age",null,{"$f":"ROUNDUP((E5*(1-E6)),0)","v":57},null,null,"Birds at productive age",null,{"$f":"ROUNDUP((J5*(1-J6)),0)","v":60}]
[]
[null,null,null,null,"Number of Layers","Mortality Rate","% of 1st Year Production","Eggs per Bird","Total Eggs","Total Dozens","Eggs 1/2 Year","Dozens 1/2 Year","Average Dozens","Cull Birds"]
[null,"Egg Production"]
[null,null,"1 year",null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,E7,J7)","v":57},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!I65,'Production Data'!H65)","v":0.05},1,{"$f":"'Production Data'!H7","v":250},{"$f":"(E11*H11)-((E11*H11)*(F11/2))","v":13893.75},{"$f":"I11/12","v":1157.8125},null,null,null,{"$f":"E11*(1-F11)","v":54.15}]
[null,null,"1.5 years",null,{"$f":"E11*(1-F11/2)","v":55.574999999999996},null,null,{"$f":"((H11*2)+H13)/3","v":237.5},null,null,{"$f":"E12*H12/2","v":6599.5312499999991},{"$f":"K12/12","v":549.96093749999989},{"$f":"((J11*2)+J13)/3","v":1079.5240885416667},{"$f":"N11*(1-F11/2)","v":52.796250000000001}]
[null,null,"2 years",null,{"$f":"E11*(1-F11)","v":54.15},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!D121,'Production Data'!G121)","v":7.4999999999999997E-2},{"$f":"'Production Data'!I81","v":0.85},{"$f":"H11*G13","v":212.5},{"$f":"(E13*H13)-(E13*H13*F13/2)","v":11075.3671875},{"$f":"I13/12","v":922.947265625},null,null,{"$f":"AVERAGE(J11,J13)","v":1040.3798828125},{"$f":"E13*(1-F13)","v":50.088750000000005}]
[null,null,"2.5 years",null,{"$f":"E13*(1-F13/2)","v":52.119374999999998},null,null,{"$f":"(H11+H13+(H15/2))/3","v":182.5},null,null,{"$f":"E14*H14/2","v":4755.8929687499995},{"$f":"K14/12","v":396.32441406249995},{"$f":"(J11+J13+(J15/2))/3","v":804.46012369791663},{"$f":"N13*(1-F13/2)","v":48.210421875000009}]
[null,null,"3 years",null,{"$f":"E13*(1-F13)","v":50.088750000000005},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!E121,'Production Data'!H121)","v":0.125},{"$f":"'Production Data'!I82","v":0.68},{"$f":"H11*G15","v":170},{"$f":"(E15*H15)-(E15*H15*F15/2)","v":7982.8945312500018},{"$f":"I15/12","v":665.24121093750011},null,null,{"$f":"AVERAGE(J11,J13,J15)","v":915.33365885416663},{"$f":"E15*(1-F15)","v":43.827656250000004}]
[]
[null,null,null,null,"Lbs of Feed per Bird to Maturity","To X Weeks","Lbs of Feed per Day per Adult","Lbs of Feed per Bird per Productive Year"]
[null,"Feed Consumption (J. Jacobs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3*50)/(30*25)","v":0.2},{"$f":"(3.5*50)/(30*25)","v":0.23333333333333334},"pounds per day"]
[null,null,"Commercial White Egg Layer",null,{"$f":"(7*50)/25","v":14},18,{"$f":"AVERAGE(R18:S18)","v":0.21666666666666667},{"$f":"G19*365","v":79.083333333333343},null,"http://www2.ca.uky.edu/agcomm/pubs/asc/asc191/asc191.pdf",null,null,null,null,null,null,null,{"$f":"(4*50)/(30*25)","v":0.26666666666666666},{"$f":"(4.5*50)/(30*25)","v":0.3},"pounds per day"]
[null,null,"Dual Purpose Egg Layer",null,{"$f":"(50*9)/25","v":18},20,{"$f":"AVERAGE(R19:S19)","v":0.28333333333333333},{"$f":"G20*365","v":103.41666666666666},null,null,null,null,null,null,null,null,null,{"$f":"(3*50)/(30*25)","v":0.2},{"$f":"(4*50)/(30*25)","v":0.26666666666666666},"pounds per day"]
[null,null,"Commercial Brown Egg Layer",null,{"$f":"(7*50)/25","v":14},18,{"$f":"AVERAGE(R20:S20)","v":0.23333333333333334},85.166666666666671]
[]
[null,null,"Type of Layer Chosen:",null,{"$f":"IF('Production Data'!H4='Drop Box Names'!B21,'Drop Box Names'!B63,IF('Production Data'!H4='Drop Box Names'!B22,'Drop Box Names'!B63, IF('Production Data'!H4='Drop Box Names'!B23,'Drop Box Names'!B62,IF('Production Data'!H4='Drop Box Names'!B24,'Drop Box Names'!B62,IF('Production Data'!H4='Drop Box Names'!B25,'Drop Box Names'!B62,IF('Production Data'!H4='Drop Box Names'!B26,'Drop Box Names'!B61))))))","v":"Commerial Brown Egg Layer"},null,null,null,"this is based off of the breed chosen on the Production Data sheet"]
[]
[null,"Feed Consumption (Chicks)",null,null,"Suggested","Entered"]
[null,null,"Number of Chicks",null,{"$f":"E5","v":60},{"$f":"E5","v":60}]
[null,null,"Birds 1st \"Productive Year\"",null,{"$f":"E11","v":57},{"$f":"E11","v":57}]
[null,null,"Feed to Maturity (lbs)",null,{"$f":"IF(E23='Drop Box Names'!B61,E19,IF(E23='Drop Box Names'!B62,E21,E20))","v":14},{"$f":"'Production Data'!H49","v":16},null,"pounds of feed it takes to reach laying age"]
[]
[null,null,"Total Feed/Live Birds",null,{"$f":"E27*E28","v":798},{"$f":"F27*F28","v":912},"lbs"]
[null,null,"Total Feed/Dead Birds",null,{"$f":"(E26-E27)*E28/2","v":21},{"$f":"(F26-F27)*F28/2","v":24},"lbs","assuming birds die halfway through, most will die sooner. "]
[null,null,"Total Feed to Maturity",null,{"$f":"E30+E31","v":819},{"$f":"F30+F31","v":936},"lbs","to get the birds to 6 months of age"]
[]
[]
[]
[]
[null,null,null,null,"# of Layers","Mortality Rate","Lbs of Feed per Bird per Day (Suggested)","Lbs of Feed per Flock per 1/2 Year","Lbs of Feed per Flock per Year",null,"Avg Lbs of Feed per Flock per Year","Avg Lbs of Feed per Bird per Year"]
[null,"Suggested Feed Consumption"]
[null,null,"1 year",null,{"$f":"E27","v":57},{"$f":"F11","v":0.05},{"$f":"IF(E23='Drop Box Names'!B61,G19,IF(E23='Drop Box Names'!B62,G21,G20))","v":0.23333333333333334},null,{"$f":"E39*G39*365*(1-F39/2)","v":4733.1374999999998},null,{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,I39+($E$32/'Production Data'!$H$6),I39)","v":5552.1374999999998},{"$f":"K39/E39","v":97.40592105263157}]
[null,null,"1.5 years",null,{"$f":"E39*(1-F39/2)","v":55.574999999999996},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!D121,'Production Data'!G121)","v":7.4999999999999997E-2},{"$f":"G39","v":0.23333333333333334},{"$f":"E40*G40*(365/2)*(1-F40/2)","v":2277.8224218750001},null,{"$f":"(I39+H40)/1.5","v":4673.9732812499997},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J40+($E$32/'Production Data'!$H$6),J40)","v":5492.9732812499997},{"$f":"K40/E40","v":98.83892543859649}]
[null,null,"2 years",null,{"$f":"E39*(1-F39)","v":54.15},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!D121,'Production Data'!G121)","v":7.4999999999999997E-2},{"$f":"G39","v":0.23333333333333334},null,{"$f":"E41*G41*365*(1-F41/2)","v":4438.8334374999995},{"$f":"AVERAGE(I39,I41)","v":4585.9854687499992},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J41+($E$32/'Production Data'!$H$6),J41)","v":5404.9854687499992},99.815059441366557]
[null,null,"2.5 years",null,{"$f":"E41*(1-F41/2)","v":52.119374999999998},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!E121,'Production Data'!H121)","v":0.125},{"$f":"G39","v":0.23333333333333334},{"$f":"E42*G42*(365/2)*(1-F42/2)","v":2080.7031738281253},null,{"$f":"(I39+I41+H42)/2.5","v":4501.0696445312497},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J42+($E$32/'Production Data'!$H$6),J42)","v":5320.0696445312497},{"$f":"K42/E42","v":102.07470148157475}]
[null,null,"3 years",null,{"$f":"E41*(1-F41)","v":50.088750000000005},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!E121,'Production Data'!H121)","v":0.125},{"$f":"G39","v":0.23333333333333334},null,{"$f":"E43*G43*365*(1-F43/2)","v":3999.2736328125002},{"$f":"AVERAGE(I39,I41,I43)","v":4390.4148567708326},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J43+($E$32/'Production Data'!$H$6),J43)","v":5209.4148567708326},{"$f":"K43/E43","v":104.00369058462893}]
[null,"Entered Feed Consumption"]
[null,null,"1 year",null,{"$f":"E39","v":57},{"$f":"F39","v":0.05},{"$f":"'Production Data'!H50/365","v":0.24657534246575341},null,{"$f":"E45*G45*365*(1-F45/2)","v":5001.7499999999991},null,{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,I45+($E$32/'Production Data'!$H$6),I45)","v":5820.7499999999991},{"$f":"K45/E45","v":102.11842105263156}]
[null,null,"1.5 years",null,{"$f":"E40","v":55.574999999999996},7.4999999999999997E-2,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},{"$f":"E46*G46*(365/2)*(1-F46/2)","v":2407.0921874999995},null,{"$f":"(I45+H46)/1.5","v":4939.2281249999987},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J46+($E$32/'Production Data'!$H$6),J46)","v":5758.2281249999987},{"$f":"K46/E46","v":103.61184210526314}]
[null,null,"2 years",null,{"$f":"E41","v":54.15},7.4999999999999997E-2,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},null,{"$f":"E47*G47*365*(1-F47/2)","v":4690.7437499999996},{"$f":"AVERAGE(I45,I47)","v":4846.2468749999989},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J47+($E$32/'Production Data'!$H$6),J47)","v":5665.2468749999989},104.62136426592797]
[null,null,"2.5 years",null,{"$f":"E42","v":52.119374999999998},0.125,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},{"$f":"E48*G48*(365/2)*(1-F48/2)","v":2198.7861328125},null,{"$f":"(I45+I47+H48)/2.5","v":4756.5119531249993},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J48+($E$32/'Production Data'!$H$6),J48)","v":5575.5119531249993},106.97580224484656]
[null,null,"3 years",null,{"$f":"E43","v":50.088750000000005},0.125,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},null,{"$f":"E49*G49*365*(1-F49/2)","v":4226.23828125},{"$f":"AVERAGE(I45,I47,I49)","v":4639.5773437499993},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J49+($E$32/'Production Data'!$H$6),J49)","v":5458.5773437499993},108.97811072845697]
[null,"For Summary Sheet"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K39,K45)","v":5552.1374999999998},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L39,L45)","v":97.40592105263157}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K40,K46)","v":5492.9732812499997},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L40,L46)","v":98.83892543859649}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K41,K47)","v":5404.9854687499992},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L41,L47)","v":99.815059441366557}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K42,K48)","v":5320.0696445312497},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L42,L48)","v":102.07470148157475}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K43,K49)","v":5209.4148567708326},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L43,L49)","v":104.00369058462893}]
[]
[]
[]
[]
[null,null,"Australorp",null,"5/wk","250-300","200-250","20-22",20,"250-300",{"$f":"5*52","v":260}]
[null,null,"Barred Plymouth Rock",null,"3/wk","200-280","4/wk",20,"200-250",{"$f":"3*52","v":156},{"$f":"4*52","v":208},null,"http://www.eggzy.net/breeds/index/page:6"]
[null,null,"Black Sex Linked",null,"6/wk","200-280","250+","22-24",18,"250+","250-300"]
[null,null,"ISA Brown",null,"6/wk","300+","20-22",{"$f":"6*52","v":312}]
[null,null,"Red Sex Linked",null,"6/wk","250+","18-20",18,null,"250+","250-300"]
[null,null,"White Leghorn"]

{"sheet":"NEW","index":5,"n_rows":78,"n_cols":20,"rows_kept":78,"cut":false,"hidden":true,"merged":[[62,4,62,11],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,1,56,3],[56,4,56,11],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,1,62,3],[22,4,22,6],[52,2,52,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[49,1,49,3],[50,1,50,3],[50,4,50,11],[51,2,51,3],[26,1,26,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[16,1,16,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[16,4,16,5],[17,1,17,3],[17,4,17,7],[6,2,6,3],[6,7,6,8],[8,1,8,3],[9,1,9,3],[10,2,10,3],[11,2,11,3],[5,2,5,3],[5,7,5,8],[1,1,1,9],[3,1,3,4],[3,6,3,9],[4,2,4,3],[4,7,4,8]]}
[]
[null,"Egg Production and Feed Consumption"]
[]
[null,"If Buying Chicks",null,null,null,null,"If Buying Started Pullets"]
[null,null,"Chicks Purchased",null,{"$f":"'Production Data'!H30","v":60},null,null,"Pullet purchased",null,{"$f":"'Production Data'!H30","v":60}]
[null,null,"Mortality Rate, preproduction",null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,IF('Production Data'!H60='Drop Box Names'!B32,'Production Data'!I61,'Production Data'!H61),0)","v":0.05},null,null,"Mortality Rate, preproduction",null,0,null,"Mortality rate for pullets is 0.0% because birds are purchased within a few weeks of produciton age"]
[null,null,"Birds at productive age",null,{"$f":"ROUNDUP((E5*(1-E6)),0)","v":57},null,null,"Birds at productive age",null,{"$f":"ROUNDUP((J5*(1-J6)),0)","v":60}]
[]
[null,null,null,null,"Number of Layers","Mortality Rate","% of 1st Year Production","Eggs per Bird","Total Eggs","Total Dozens","Eggs 1/2 Year","Dozens 1/2 Year","Average Dozens","Cull Birds"]
[null,"Egg Production"]
[null,null,"1 year",null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,E7,J7)","v":57},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!I65,'Production Data'!H65)","v":0.05},1,{"$f":"'Production Data'!H7","v":250},{"$f":"(E11*H11)-((E11*H11)*(F11/2))","v":13893.75},{"$f":"I11/12","v":1157.8125},null,null,null,{"$f":"E11*(1-F11)","v":54.15}]
[null,null,"1.5 years",null,{"$f":"E11*(1-F11/2)","v":55.574999999999996},null,null,{"$f":"((H11*2)+H13)/3","v":237.5},null,null,{"$f":"E12*H12/2","v":6599.5312499999991},{"$f":"K12/12","v":549.96093749999989},{"$f":"((J11*2)+J13)/3","v":1079.5240885416667},{"$f":"N11*(1-F11/2)","v":52.796250000000001}]
[null,null,"2 years",null,{"$f":"E11*(1-F11)","v":54.15},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!D121,'Production Data'!G121)","v":7.4999999999999997E-2},{"$f":"'Production Data'!I81","v":0.85},{"$f":"H11*G13","v":212.5},{"$f":"(E13*H13)-(E13*H13*F13/2)","v":11075.3671875},{"$f":"I13/12","v":922.947265625},null,null,{"$f":"AVERAGE(J11,J13)","v":1040.3798828125},{"$f":"E13*(1-F13)","v":50.088750000000005}]
[null,null,"2.5 years",null,{"$f":"E13*(1-F13/2)","v":52.119374999999998},null,null,{"$f":"(H11+H13+(H15/2))/3","v":182.5},null,null,{"$f":"E14*H14/2","v":4755.8929687499995},{"$f":"K14/12","v":396.32441406249995},{"$f":"(J11+J13+(J15/2))/3","v":804.46012369791663},{"$f":"N13*(1-F13/2)","v":48.210421875000009}]
[null,null,"3 years",null,{"$f":"E13*(1-F13)","v":50.088750000000005},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!E121,'Production Data'!H121)","v":0.125},{"$f":"'Production Data'!I82","v":0.68},{"$f":"H11*G15","v":170},{"$f":"(E15*H15)-(E15*H15*F15/2)","v":7982.8945312500018},{"$f":"I15/12","v":665.24121093750011},null,null,{"$f":"AVERAGE(J11,J13,J15)","v":915.33365885416663},{"$f":"E15*(1-F15)","v":43.827656250000004}]
[]
[null,null,null,null,"Lbs of Feed per Bird to Maturity",null,"Lbs of Feed per Day per Adult","Lbs of Feed per Bird per Productive Year"]
[null,"Feed Consumption (J. Jacobs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3*50)/(30*25)","v":0.2},{"$f":"(3.5*50)/(30*25)","v":0.23333333333333334},"pounds per day"]
[null,null,"Commercial White Egg Layer",null,{"$f":"(7*50)/25","v":14},"to 18 weeks",{"$f":"AVERAGE(R18:S18)","v":0.21666666666666667},{"$f":"G19*365","v":79.083333333333343},null,"http://www2.ca.uky.edu/agcomm/pubs/asc/asc191/asc191.pdf",null,null,null,null,null,null,null,{"$f":"(4*50)/(30*25)","v":0.26666666666666666},{"$f":"(4.5*50)/(30*25)","v":0.3},"pounds per day"]
[null,null,"Dual Purpose Egg Layer",null,{"$f":"(50*9)/25","v":18},"to 20 weeks",{"$f":"AVERAGE(R19:S19)","v":0.28333333333333333},{"$f":"G20*365","v":103.41666666666666},null,null,null,null,null,null,null,null,null,{"$f":"(3*50)/(30*25)","v":0.2},{"$f":"(4*50)/(30*25)","v":0.26666666666666666},"pounds per day"]
[null,null,"Commercial Brown Egg Layer",null,{"$f":"(7*50)/25","v":14},"to 18 weeks",{"$f":"AVERAGE(R20:S20)","v":0.23333333333333334},85.166666666666671]
[]
[null,null,"Type of Layer Chosen:",null,{"$f":"IF('Production Data'!H4='Drop Box Names'!B21,'Drop Box Names'!B63,IF('Production Data'!H4='Drop Box Names'!B22,'Drop Box Names'!B63, IF('Production Data'!H4='Drop Box Names'!B23,'Drop Box Names'!B62,IF('Production Data'!H4='Drop Box Names'!B24,'Drop Box Names'!B62,IF('Production Data'!H4='Drop Box Names'!B25,'Drop Box Names'!B62,IF('Production Data'!H4='Drop Box Names'!B26,'Drop Box Names'!B61))))))","v":"Commerial Brown Egg Layer"},null,null,null,"this is based off of the breed chosen on the Production Data sheet"]
[]
[]
[]
[null,"Feed Consumption (Chicks)",null,null,"Suggested","Entered"]
[null,null,"Number of Chicks",null,{"$f":"E5","v":60},{"$f":"E5","v":60}]
[null,null,"Birds 1st \"Productive Year\"",null,{"$f":"E11","v":57},{"$f":"E11","v":57}]
[null,null,"Feed to Maturity (lbs)",null,{"$f":"IF(E23='Drop Box Names'!B61,E19,IF(E23='Drop Box Names'!B62,E21,E20))","v":14},{"$f":"'Production Data'!H49","v":16},null,"pounds of feed it takes to reach laying age"]
[]
[null,null,"Total Feed/Live Birds",null,{"$f":"E29*E30","v":798},{"$f":"F29*F30","v":912},"lbs"]
[null,null,"Total Feed/Dead Birds",null,{"$f":"(E28-E29)*E30/2","v":21},{"$f":"(F28-F29)*F30/2","v":24},"lbs","assuming birds die halfway through, most will die sooner. "]
[null,null,"Total Feed to Maturity",null,{"$f":"E32+E33","v":819},{"$f":"F32+F33","v":936},"lbs","to get the birds to 6 months of age"]
[]
[null,"Feed Consumption (Adults)",null,null,"Suggested","Entered"]
[null,null,"Number of Birds",null,{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,E7,J7)","v":57},{"$f":"IF('Production Data'!H28='Drop Box Names'!B29,E7,J7)","v":57}]
[null,null,"Months Kept Laying",null,{"$f":"'Production Data'!H11","v":14},{"$f":"'Production Data'!H11","v":14}]
[null,null,"Lbs of Feed per Day",null,{"$f":"IF(E23='Drop Box Names'!B61,G19,IF(E23='Drop Box Names'!B62,G21,G20))","v":0.23333333333333334},{"$f":"'Production Data'!H50/(('Production Data'!H9/2*31)+('Production Data'!H9/2*30))","v":0.49180327868852458}]
[null,null,"Pounds Intake per Bird",null,{"$f":"(E38/2*30*E39)+(E38/2*31*E39)","v":99.633333333333326},{"$f":"'Production Data'!H50","v":90}]
[null,null,null,null,null,null,"mortality"]
[null,null,"Mortality Rate",null,{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!I65,'Production Data'!H65)","v":0.05}]
[]
[]
[null,null,"Pounds Intake per Flock",null,{"$f":"E40*E37","v":5679.0999999999995},{"$f":"F40*F37","v":5130}]
[null,null,{"$f":"IF('Production Data'!H41='Drop Box Names'!B40,\"Tons per Flock\",\"Bags per Flock\")","v":"Tons per Flock"},null,{"$f":"IF('Production Data'!H41='Drop Box Names'!B40,E45/2000,E45/'Production Data'!H43)","v":2.8395499999999996},{"$f":"IF('Production Data'!H41='Drop Box Names'!B40,F45/2000,F45/'Production Data'!H43)","v":2.5649999999999999}]
[]
[]
[]
[null,null,null,null,"# of Layers","Mortality Rate","Lbs of Feed per Bird per Day (Suggested)","Lbs of Feed per Flock per 1/2 Year","Lbs of Feed per Flock per Year",null,"Avg Lbs of Feed per Flock per Year","Avg Lbs of Feed per Bird per Year"]
[null,"Suggested Feed Consumption"]
[null,null,"1 year",null,{"$f":"E29","v":57},{"$f":"F11","v":0.05},{"$f":"IF(E23='Drop Box Names'!B61,G19,IF(E23='Drop Box Names'!B62,G21,G20))","v":0.23333333333333334},null,{"$f":"E52*G52*365*(1-F52/2)","v":4733.1374999999998},null,{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,I52+($E$34/'Production Data'!$H$6),I52)","v":5552.1374999999998},{"$f":"K52/E52","v":97.40592105263157}]
[null,null,"1.5 years",null,{"$f":"E52*(1-F52/2)","v":55.574999999999996},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!D121,'Production Data'!G121)","v":7.4999999999999997E-2},{"$f":"G52","v":0.23333333333333334},{"$f":"E53*G53*(365/2)*(1-F53/2)","v":2277.8224218750001},null,{"$f":"(I52+H53)/1.5","v":4673.9732812499997},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J53+($E$34/'Production Data'!$H$6),J53)","v":5492.9732812499997},{"$f":"K53/E53","v":98.83892543859649}]
[null,null,"2 years",null,{"$f":"E52*(1-F52)","v":54.15},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!D121,'Production Data'!G121)","v":7.4999999999999997E-2},{"$f":"G52","v":0.23333333333333334},null,{"$f":"E54*G54*365*(1-F54/2)","v":4438.8334374999995},{"$f":"AVERAGE(I52,I54)","v":4585.9854687499992},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J54+($E$34/'Production Data'!$H$6),J54)","v":5404.9854687499992},99.815059441366557]
[null,null,"2.5 years",null,{"$f":"E54*(1-F54/2)","v":52.119374999999998},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!E121,'Production Data'!H121)","v":0.125},{"$f":"G52","v":0.23333333333333334},{"$f":"E55*G55*(365/2)*(1-F55/2)","v":2080.7031738281253},null,{"$f":"(I52+I54+H55)/2.5","v":4501.0696445312497},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J55+($E$34/'Production Data'!$H$6),J55)","v":5320.0696445312497},{"$f":"K55/E55","v":102.07470148157475}]
[null,null,"3 years",null,{"$f":"E54*(1-F54)","v":50.088750000000005},{"$f":"IF('Production Data'!H64='Drop Box Names'!B32,'Production Data'!E121,'Production Data'!H121)","v":0.125},{"$f":"G52","v":0.23333333333333334},null,{"$f":"E56*G56*365*(1-F56/2)","v":3999.2736328125002},{"$f":"AVERAGE(I52,I54,I56)","v":4390.4148567708326},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J56+($E$34/'Production Data'!$H$6),J56)","v":5209.4148567708326},{"$f":"K56/E56","v":104.00369058462893}]
[null,"Entered Feed Consumption"]
[null,null,"1 year",null,{"$f":"E52","v":57},{"$f":"F52","v":0.05},{"$f":"'Production Data'!H50/365","v":0.24657534246575341},null,{"$f":"E58*G58*365*(1-F58/2)","v":5001.7499999999991},null,{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,I58+($E$34/'Production Data'!$H$6),I58)","v":5820.7499999999991},{"$f":"K58/E58","v":102.11842105263156}]
[null,null,"1.5 years",null,{"$f":"E53","v":55.574999999999996},7.4999999999999997E-2,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},{"$f":"E59*G59*(365/2)*(1-F59/2)","v":2407.0921874999995},null,{"$f":"(I58+H59)/1.5","v":4939.2281249999987},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J59+($E$34/'Production Data'!$H$6),J59)","v":5758.2281249999987},{"$f":"K59/E59","v":103.61184210526314}]
[null,null,"2 years",null,54.15,7.4999999999999997E-2,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},null,{"$f":"E60*G60*365*(1-F60/2)","v":4690.7437499999996},{"$f":"AVERAGE(I58,I60)","v":4846.2468749999989},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J60+($E$34/'Production Data'!$H$6),J60)","v":5665.2468749999989},104.62136426592797]
[null,null,"2.5 years",null,52.119374999999998,0.125,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},{"$f":"E61*G61*(365/2)*(1-F61/2)","v":2198.7861328125},null,{"$f":"(I58+I60+H61)/2.5","v":4756.5119531249993},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J61+($E$34/'Production Data'!$H$6),J61)","v":5575.5119531249993},106.97580224484656]
[null,null,"3 years",null,50.088750000000005,0.125,{"$f":"'Production Data'!H50/365","v":0.24657534246575341},null,{"$f":"E62*G62*365*(1-F62/2)","v":4226.23828125},{"$f":"AVERAGE(I58,I60,I62)","v":4639.5773437499993},{"$f":"IF('Production Data'!$H$28='Drop Box Names'!$B$29,J62+($E$34/'Production Data'!$H$6),J62)","v":5458.5773437499993},108.97811072845697]
[null,"For Summary Sheet"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K52,K58)","v":5552.1374999999998},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L52,L58)","v":97.40592105263157}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K53,K59)","v":5492.9732812499997},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L53,L59)","v":98.83892543859649}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K54,K60)","v":5404.9854687499992},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L54,L60)","v":99.815059441366557}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K55,K61)","v":5320.0696445312497},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L55,L61)","v":102.07470148157475}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,K56,K62)","v":5209.4148567708326},{"$f":"IF('Production Data'!$H$47='Drop Box Names'!$B$32,L56,L62)","v":104.00369058462893}]
[]
[]
[]
[]
[null,null,"Australorp",null,"5/wk","250-300","200-250","20-22",20,"250-300",{"$f":"5*52","v":260}]
[null,null,"Barred Plymouth Rock",null,"3/wk","200-280","4/wk",20,"200-250",{"$f":"3*52","v":156},{"$f":"4*52","v":208},null,"http://www.eggzy.net/breeds/index/page:6"]
[null,null,"Black Sex Linked",null,"6/wk","200-280","250+","22-24",18,"250+","250-300"]
[null,null,"ISA Brown",null,"6/wk","300+","20-22",{"$f":"6*52","v":312}]
[null,null,"Red Sex Linked",null,"6/wk","250+","18-20",18,null,"250+","250-300"]
[null,null,"White Leghorn"]

{"sheet":"Drop Box Names","index":6,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Drop Down List Option","Sheets","Location/Cell","Notes, Reasoning"]
[]
[null,1,"Production Data","E5"]
[null,1.5]
[null,2]
[null,2.5]
[null,3]
[]
[null,"Stationary","Production data","H21"]
[null,"Mobile"]
[]
[null,"Hoop Houses","Production Data","H22"]
[null,"Chicken Tractor"]
[]
[null,"None",null,null,"If \"Mobile\" the user only gets the option for ply netting or No fencing"]
[null,"Poly Netting","Production Data","H24","If \"Stationary\" the user gets all option of fencing"]
[null,{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,E18,\"-\")","v":"-"},null,null,"Chicken Wire"]
[null,{"$f":"IF('Production Data'!H36='Drop Box Names'!B10,E19,\"-\")","v":"-"},null,null,"Wire and Netting"]
[]
[null,"Australorp","Production Data","H26"]
[null,"Barred Plymouth Rock"]
[null,"Black Sex Linked"]
[null,"ISA Brown"]
[null,"Red Sex Linked"]
[null,"White Leghorn"]
[null,"Other"]
[]
[null,"Day Old Chicks","Production Data","H28"]
[null,"Started Pullets"]
[]
[null,"Estimated","Production Data","H32"]
[null,"My Own","Production Data","H39"]
[null,null,"Production Data","H42"]
[]
[null,"Novice","Production Data","H37"]
[null,"Intermediate"]
[null,"Expert"]
[]
[null,"Ton","Production Data","H45"]
[null,"Bag"]
[]
[null,"Yes","Production Data","H53"]
[null,"No","Depreciable Items","E6"]
[]
[null,"Daily","Production Data","H50"]
[null,"Twice per Week"]
[null,"Weekly"]
[null,"Less Frequently"]
[]
[null,"Use Suggested","Depreciable Items","E4"]
[null,"Enter Below","Depreciable Items","E5"]
[]
[null,"Brown Eggs","Production Data","C100"]
[null,"White Eggs"]
[]
[]
[null,"Dual Purpose","Production Data","C99","This determines the mortality rate pre and post production age, and the forage replacement rate. "]
[null,"Production Type"]
[]
[null,"Commercial White Egg Layer"]
[null,"Commerial Brown Egg Layer"]
[null,"Dual Purpose Layer"]
[]
[null,"Minimum number of birds for refrigerator and guardian","Depreciable Items"]
[null,50]
[]
[null,"Enter"]
[null,"Calculate"]
[]
[]
[null,"Enter Separate Costs"]
[null,{"$f":"IF('Production Data'!H4='Drop Box Names'!B29,\"Enter Total Cost per Chick\",\"Enter Total Cost per Pullet\")","v":"Enter Total Cost per Pullet"}]
[null,"Enter Total Cost per Flock"]

{"sheet":"Production Q's","index":7,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Need costs for"]
[null,"   - Marketing"]
[null,"   - Maintenance and repair"]
[null,"   - Other, which includes utilites, insurance, interest, etc.. "]
[null,"   - Pasture Management"]
[]
[null,"What are good estimates for labor?"]
[null,"   - Need to include daily chores, egg washing, marketing, maybe transportation?"]
[]
[null,"Do we need to include a transportation category?"]
[null,"   - Probably yes… But is it likely that eggs will be transported with another product?"]
[]
[]
[null,"  - Get realistic estimates for forage replacement"]
[null,"  - Evaluate the best way to apply the forage replacement percentage : Does it affect the feed intake or the ADG more?"]
[null,null,null," - Todd's birds ate the same amount of concentrate, but weighed more at harvest day, with short forage"]

{"sheet":"Formatting","index":8,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[null,"To Do "]
[]
[null,"Give users the ability to change the number (%) of birds culled per year. Right now we are assuming all in, all out. "]
[null,"Include the cost per bird to the summary sheets and depreciable items sheets, if people think it would be helpful. "]
[]
[]
[null,"When Making Changes"]
[]
[null," If you change the name of any of the options in the drop down boxes, it is CRUCIAL to check all of the related equations."]
[null,"Sometimes an error message does NOT show up, but if we don't change the cooresponding cells/equations, there will be errors in calculation."]
[]
[null,"Hidden rows on the production data sheet for forage replacement and labor. Check row 129"]
[]
[null,"Things to include on (future/possible) the egg sheet"]
[]
[null,"The chart about eggs produced 1st year and following years"]
[null,"the labort for harvest, cleaning, packaging and marketing"]
[null,"Do we need in clude transportation?"]
[null,"Include the supplies for eggs, like washing equipment, cartons, labels"]
[null,"Maybe completely show the dozens per year for the whole flock (like in the years sheet)"]

{"sheet":"Feed Intake","index":9,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":true,"merged":[[2,0,2,3]]}
["Feed consumption for leghorns, production type breed"]
[null,null,null,null,null,"25 Replacements",null,"50 lb bags","Total lbs","Per bird","Per Day"]
["FEED INTAKE CHART",null,null,null,null,"Commercial White (18)",null,4,{"$f":"H3*50","v":200},{"$f":"I3/25","v":8},{"$f":"7/(18*7)","v":5.5555555555555552E-2}]
["Age (weeks)","Body Weight","Total Feed Intake","F:G",null,"Commercial Brown (18)",null,4,{"$f":"H4*50","v":200},{"$f":"I4/25","v":8},{"$f":"8/(18*7)","v":6.3492063492063489E-2}]
[0,0.08,0.11,{"$f":"C5/B5","v":1.375},null,"Dual purpose (20 wks)",null,5,{"$f":"H5*50","v":250},{"$f":"I5/25","v":10},{"$f":"9/(20*7)","v":6.4285714285714279E-2}]
[2,0.22,0.42,1.9090909090909089]
[4,0.56999999999999995,0.99,1.736842105263158,null,"25 Laying Hens",null,"50 lb bags","Total lbs","Bird/month","Per Day"]
[6,0.99,1.74,1.7575757575757576,null,"Commercial White",null,3.5,{"$f":"H8*50","v":175},{"$f":"I8/25","v":7},{"$f":"7/30","v":0.23333333333333334}]
[8,1.46,2.54,1.7397260273972603,null,"Commercial Brown",null,4,{"$f":"H9*50","v":200},{"$f":"I9/25","v":8},{"$f":"8/30","v":0.26666666666666666}]
[10,1.65,3.37,2.0424242424242425,null,"Dual purpose",null,4.25,{"$f":"H10*50","v":212.5},{"$f":"I10/25","v":8.5},{"$f":"8.5/30","v":0.28333333333333333}]
[12,2.16,4.25,1.9675925925925926]
[14,2.4300000000000002,5.18,2.1316872427983538]
[16,2.69,6.13,2.2788104089219332]
[18,3.03,7.12,2.3498349834983498]
[20,3.25,8.2200000000000006,{"$f":"C15/B15","v":2.5292307692307694}]
[]
["Age (weeks)","Body Weight",null,"Total Feed Intake"]
[null,"X","X^2",null,null,"http://cccfeeds.com/assets/files/Resources/Poultry/Layer_Low_Res_%20RGB_Sept_2009.pdf"]
[0,0.08,{"$f":"B19^2","v":6.4000000000000003E-3},0.11,null,"week","weeks ^2","Weight","weight X^2","Lbs per week","Total lbs","FC"]
[1,0.15,{"$f":"B20^2","v":2.2499999999999999E-2},0.26500000000000001,null,1,{"$f":"F20^2","v":1},0.17,{"$f":"H20^2","v":2.8900000000000006E-2},0.22,{"$f":"J20","v":0.22},{"$f":"K20/H20","v":1.2941176470588234}]
[2,0.22,4.8399999999999999E-2,0.42,null,2,{"$f":"F21^2","v":4},0.28999999999999998,{"$f":"H21^2","v":8.4099999999999994E-2},0.26,{"$f":"SUM($J$20:J21)","v":0.48},1.6551724137931034]
[3,0.39499999999999996,0.15602499999999997,0.70499999999999996,null,3,9,0.45,0.20250000000000001,0.33,{"$f":"SUM($J$20:J22)","v":0.81},1.8,"to pound of meat. "]
[4,0.56999999999999995,0.32489999999999997,0.99,null,4,16,0.65,0.42250000000000004,0.44,{"$f":"SUM($J$20:J23)","v":1.25},1.9230769230769229,"other FCR for layers use eggs laid"]
[5,0.78,0.60840000000000005,1.365,null,5,25,0.88,0.77439999999999998,0.6,{"$f":"SUM($J$20:J24)","v":1.85},2.1022727272727275,"should I change that?"]
[6,0.99,0.98009999999999997,1.74,null,6,36,1.1000000000000001,1.2100000000000002,0.66,{"$f":"SUM($J$20:J25)","v":2.5100000000000002},2.2818181818181817,"I think it should be based on age"]
[7,1.2250000000000001,1.5006250000000003,2.14,null,7,49,1.34,1.7956000000000003,0.71,{"$f":"SUM($J$20:J26)","v":3.22},2.4029850746268657,"birds could reach 200 weeks easy"]
[8,1.46,2.1315999999999997,2.54,null,8,64,1.58,2.4964000000000004,0.75,{"$f":"SUM($J$20:J27)","v":3.97},2.5126582278481013]
[9,1.5549999999999999,2.4180249999999996,2.9550000000000001,null,9,81,1.82,3.3124000000000002,0.82,{"$f":"SUM($J$20:J28)","v":4.79},2.6318681318681318]
[10,1.65,2.7224999999999997,3.37,null,10,100,1.98,3.9203999999999999,0.84,{"$f":"SUM($J$20:J29)","v":5.63},2.8434343434343434]
[11,1.905,3.6290249999999999,3.81,null,11,121,2.17,4.7088999999999999,0.86,{"$f":"SUM($J$20:J30)","v":6.49},2.9907834101382491]
[12,2.16,4.6656000000000004,4.25,null,12,144,2.37,5.6169000000000002,0.88,{"$f":"SUM($J$20:J31)","v":7.37},3.109704641350211]
[13,2.2949999999999999,5.2670249999999994,4.7149999999999999,null,13,169,2.54,6.4516,0.9,{"$f":"SUM($J$20:J32)","v":8.27},3.2559055118110236]
[14,2.4300000000000002,5.9049000000000005,5.18,null,14,196,2.64,6.9696000000000007,0.93,{"$f":"SUM($J$20:J33)","v":9.1999999999999993},3.4848484848484844]
[15,2.56,6.5536000000000003,5.6549999999999994,null,15,225,2.75,7.5625,0.95,{"$f":"SUM($J$20:J34)","v":10.149999999999999},3.6909090909090905]
[16,2.69,7.2360999999999995,6.13,null,16,256,2.82,7.952399999999999,0.97,{"$f":"SUM($J$20:J35)","v":11.12},3.9432624113475176]
[17,2.86,8.1795999999999989,6.625,null,17,289,2.89,8.3521000000000001,0.99,{"$f":"SUM($J$20:J36)","v":12.11},4.1903114186851207]
[18,3.03,9.1808999999999994,7.12,null,18,324,2.95,8.7025000000000006,1.01,{"$f":"SUM($J$20:J37)","v":13.12},4.4474576271186432]
[19,3.1399999999999997,9.8595999999999986,7.67,null,20,400,3.45,11.902500000000002,{"$f":"O39*4","v":4.8},{"$f":"SUM($J$20:J38)","v":17.919999999999998},5.1942028985507243,null,"per day","per week"]
[20,3.25,10.5625,8.2200000000000006,null,24,576,3.66,13.395600000000002,5.88,{"$f":"SUM($J$20:J39)","v":23.799999999999997},6.5027322404371573,null,null,1.2]
[null,null,null,null,null,28,784,3.7,13.690000000000001,5.88,{"$f":"SUM($J$20:J40)","v":29.679999999999996},8.0216216216216196,null,0.21,{"$f":"N40*7","v":1.47}]
[null,null,null,null,null,32,1024,3.7,13.690000000000001,5.88,{"$f":"SUM($J$20:J41)","v":35.559999999999995},9.6108108108108095,null,0.21,1.47]
[null,null,null,null,null,36,1296,3.74,13.987600000000002,5.6000000000000005,{"$f":"SUM($J$20:J42)","v":41.16},11.005347593582886,null,0.21,1.47]
[null,null,null,null,null,40,1600,3.8,14.44,5.6000000000000005,{"$f":"SUM($J$20:J43)","v":46.76},12.305263157894737,null,0.2,1.4000000000000001]
[null,null,null,null,null,44,1936,4,16,6.16,{"$f":"SUM($J$20:J44)","v":52.92},13.23,null,0.2,1.4000000000000001]
[null,null,null,null,null,48,2304,4.08,16.6464,6.16,{"$f":"SUM($J$20:J45)","v":59.08},14.480392156862745,null,0.22,1.54]
[null,null,null,null,null,52,2704,4.12,16.974399999999999,6.44,{"$f":"SUM($J$20:J46)","v":65.52},15.902912621359222,null,0.22,1.54]
[null,null,null,null,null,56,3136,4.17,17.3889,6.72,{"$f":"SUM($J$20:J47)","v":72.239999999999995},17.323741007194243,null,0.23,1.61]
[null,null,null,null,null,60,3600,4.16,17.305600000000002,7.28,{"$f":"SUM($J$20:J48)","v":79.52},19.115384615384613,null,0.24,1.68]
[null,null,null,null,null,64,4096,4.16,17.305600000000002,7.5600000000000005,{"$f":"SUM($J$20:J49)","v":87.08},20.932692307692307,null,0.26,1.82]
[null,null,null,null,null,68,4624,4.16,17.305600000000002,7.8400000000000007,{"$f":"SUM($J$20:J50)","v":94.92},22.817307692307693,null,0.27,1.8900000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003,1.9600000000000002]

{"sheet":"Feed Intake Data","index":10,"n_rows":98,"n_cols":17,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Body weights and associated feed consumption for a brown-egg laying breed during the growing period"]
[null,"Age (wk)","Body weight (g)","Feed consumption (g/bird/day)",null,null,null,"Age (wk)","Body weight (lb)","Feed consumption (lb/bird/day)","Feed cons. per week"]
[null,1,70,13,null,"grams to pounds",null,1,{"$f":"C5*$F$6","v":0.1543234},{"$f":"D5*$F$6","v":2.8660060000000001E-2},{"$f":"J5*7","v":0.20062042000000002}]
[null,2,115,20,null,2.20462E-3,null,2,0.25353130000000001,4.4092400000000004E-2,{"$f":"J6*7","v":0.3086468}]
[null,3,190,25,null,null,null,3,0.41887780000000002,5.5115499999999998E-2,0.3858085]
[null,4,280,29,null,null,null,4,0.6172936,6.3933980000000001E-2,0.44753786000000001]
[null,5,385,33,null,null,null,5,0.8487787,7.2752460000000005E-2,0.50926722000000002]
[null,6,490,37,null,null,null,6,1.0802638,8.1570939999999995E-2,0.57099657999999998]
[null,7,600,41,null,null,null,7,1.3227720000000001,9.0389419999999998E-2,0.63272594000000004]
[null,8,710,46,null,null,null,8,1.5652802000000001,0.10141252000000001,0.70988764000000004]
[null,9,810,51,null,null,null,9,1.7857422000000001,0.11243562,0.78704934000000004]
[null,10,"870-970",56,null,null,null,10,{"$f":"AVERAGE(O68:P68)","v":2.0282504000000001},{"$f":"D14*$F$6","v":0.12345871999999999},0.86421103999999993]
[null,11,"960-1080",61,null,null,null,11,2.2487124000000001,0.13448182,0.94137274000000004]
[null,12,"1050-1117",66,null,null,null,12,2.3887057700000001,0.14550492000000001,1.01853444]
[null,13,"1130-1250",70,null,null,null,13,2.6234978,0.1543234,1.0802638]
[null,14,"1210-1310",73,null,null,null,14,2.7778212,0.16093726,1.1265608199999999]
[null,15,"1290-1370",75,null,null,null,15,2.9321446,0.16534650000000001,1.1574255]
[null,16,"1360-1430",77,null,null,null,16,3.0754448999999999,0.16975573999999999,1.1882901799999999]
[null,17,"1500-1540",80,null,null,null,17,3.3510223999999997,0.17636960000000002,1.2345872]
[]
[null,"http://www.poultryhub.org/nutrition/nutrient-requirements/nutrient-requirements-of-egg-laying-chickens/",null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K21)","v":13.16378602},"Total feed consumption at 17 weeks"]
[]
[]
[null,{"$f":"144/7","v":20.571428571428573},"weeks to production age (laying 50% of capacity)"]
[null,0.24,"lbs/day food consumption",null,"as an adult, for commercial type birds"]
[]
[null,"http://www.isapoultry.com/en/products/"]
[]
[]
[null,null,"Leghorns, white egg layers",null,null,null,null,"Dual purpose, brown egg layers"]
[null,"Age","Body Weight (lbs)","Feed (lbs)","Cumulative Feed (lbs)",null,"Age","Body Weight (lbs)","Feed (lbs)","Cumulative Feed (lbs)"]
[null,0,0.08,0.22,0.22,null,0,0.08,0.3,0.3,null,"25 Replacements",null,"50 lb bags","Total lbs","Per bird","Per Day"]
[null,2,0.22,0.62,0.84,null,2,0.26,0.7,1,null,"Commercial White (18)",null,4,{"$f":"N35*50","v":200},{"$f":"O35/25","v":8},{"$f":"7/(18*7)","v":5.5555555555555552E-2}]
[null,4,0.56999999999999995,1.1399999999999999,1.98,null,4,0.72,1.24,2.2400000000000002,null,"Commercial Brown (18)",null,4,{"$f":"N36*50","v":200},{"$f":"O36/25","v":8},{"$f":"8/(18*7)","v":6.3492063492063489E-2}]
[null,6,0.99,1.5,3.48,null,6,1.1000000000000001,1.54,3.78,null,"Dual purpose (20 wks)",null,5,{"$f":"N37*50","v":250},{"$f":"O37/25","v":10},{"$f":"9/(20*7)","v":6.4285714285714279E-2}]
[null,8,1.46,1.58,5.0599999999999996,null,8,1.65,1.68,5.46]
[null,10,1.65,1.68,6.74,null,10,1.98,1.76,7.22,null,"25 Laying Hens",null,"50 lb bags","Total lbs","Bird/month","Per Day"]
[null,12,2.16,1.76,8.5,null,12,2.4300000000000002,1.86,9.08,null,"Commercial White",null,3.5,{"$f":"N40*50","v":175},{"$f":"O40/25","v":7},{"$f":"7/30","v":0.23333333333333334}]
[null,14,2.4300000000000002,1.86,10.36,null,14,2.73,1.98,11.06,null,"Commercial Brown",null,4,{"$f":"N41*50","v":200},{"$f":"O41/25","v":8},{"$f":"8/30","v":0.26666666666666666}]
[null,16,2.69,1.9,12.26,null,16,3.04,2.08,13.14,null,"Dual purpose",null,4.25,{"$f":"N42*50","v":212.5},{"$f":"O42/25","v":8.5},{"$f":"8.5/30","v":0.28333333333333333}]
[null,18,3.03,1.98,14.24,null,18,3.31,2.2000000000000002,15.34]
[null,20,3.25,2.2000000000000002,16.440000000000001,null,20,3.53,2.42,17.760000000000002]
[]
[null,"http://www2.ca.uky.edu/agc/pubs/ASC/ASC191/ASC191.pdf"]
[]
[]
[null,0.25,"per day or",null,{"$f":"0.25*7","v":1.75},"week"]
[null,0.3,"per day",null,{"$f":"0.25*31","v":7.75},"month"]
[null,1.5,"per week"]
[null,null,null,null,{"$f":"0.25*365","v":91.25},"year"]
[null,null,null,null,{"$f":"E52/12","v":7.604166666666667},"month"]
[]
[null,"http://animals.mom.me/many-pounds-food-laying-hen-eat-day-5860.html"]
[]
[]
[null,"FEED","PROTEIN LEVEL (%)","AGE OF BIRDS","FEED INTAKE/10 BIRDS/ AGE PERIOD"]
[null,"Chick starter","20-22","0-6 weeks","20-29 lbs",null,24.5,{"$f":"G59/10","v":2.4500000000000002},{"$f":"G59/(10*6)","v":0.40833333333333333},"per bird per week",{"$f":"I59/7","v":5.8333333333333334E-2},"per bird per day for time period"]
[null,"Pullet grower","14-16","6-20 weeks","120-130 lbs",null,125,{"$f":"G60/10","v":12.5},{"$f":"G60/(10*6)","v":2.0833333333333335},null,{"$f":"I60/7","v":0.29761904761904762}]
[null,"Layer","15-18","20 weeks on","18-24 lbs/week",null,22,{"$f":"G61/10","v":2.2000000000000002},{"$f":"G61/10","v":2.2000000000000002},null,{"$f":"I61/7","v":0.31428571428571433},"per bird per day"]
[null,"All purpose*",16,"All ages",null,null,null,{"$f":"SUM(H59:H61)","v":17.149999999999999},"total feed consumption for bird for 20 weeks"]
[null,null,null,null,null,"on the LOW side - ",null,15.8]
[null,null,null,null,null,"on the HIGH side - ",null,18.3]
[]
[null,"http://www.extension.org/pages/69065/feeding-chickens-for-egg-production#.VjpnyrerTIU"]
[]
[null,null,null,null,null,870,970,null,null,null,null,null,null,null,{"$f":"F68*$F$6","v":1.9180193999999999},{"$f":"G68*$F$6","v":2.1384813999999999}]
[null,null,null,null,null,960,1080,null,null,null,null,null,null,null,2.1164352000000002,2.3809895999999999]
[null,null,null,null,null,1050,1117,null,null,null,null,null,null,null,2.314851,2.4625605400000001]
[null,null,null,null,null,1130,1250,null,null,null,null,null,null,null,2.4912206000000001,2.7557749999999999]
[null,null,null,null,null,1210,1310,null,null,null,null,null,null,null,2.6675901999999998,2.8880522000000002]
[null,null,null,null,null,1290,1370,null,null,null,null,null,null,null,2.8439597999999999,3.0203294000000001]
[null,null,null,null,null,1360,1430,null,null,null,null,null,null,null,2.9982831999999999,3.1526065999999999]
[null,null,null,null,null,1500,1540,null,null,null,null,null,null,null,3.3069299999999999,3.3951148]
[]
[null,null,"Pullet weights, large egg size birds",null,null,null,null,null,null,"expected and measure performance of HyLine W-98"]
[null,"age in weeks","Weight in lbs","Lbs per week","Total consumption lbs","FC",null,null,"age in weeks","Weight in lbs","Lbs per week","Total consumption lbs","FC"]
[null,1,0.17,0.22046199999999999,0.22046199999999999,1.2968352941176469,null,null,20,3.2,1.2,14.284419700000001,4.4638811562500003]
[null,2,0.28999999999999998,0.26455439999999997,0.48501639999999996,1.6724703448275862,null,null,24,3.44,1.4707020020000001,15.755121702,4.5799772389534885]
[null,3,0.45,0.31966989999999995,0.80468629999999997,1.7881917777777776,null,null,28,3.52,1.4753317039999998,17.230453405999999,4.8950151721590904]
[null,4,0.65,0.44092399999999998,1.2456103000000001,1.9163235384615385,null,null,32,3.55,1.4367508539999998,18.667204259999998,5.2583673971830986]
[null,5,0.88,0.59524739999999998,1.8408576999999999,2.09188375,null,null,36,3.57,1.4336643860000002,20.100868645999999,5.6304954190476186]
[null,6,1.1000000000000001,0.66138599999999992,2.5022436999999997,2.2747669999999998,null,null,40,3.59,1.430577918,21.531446563999999,5.9976174272980503]
[null,7,1.34,0.70547839999999995,3.2077220999999998,2.393822462686567,null,null,44,3.61,1.5602095739999999,23.091656137999998,6.396580647645429]
[null,8,1.58,0.74957079999999998,3.9572928999999997,2.5046157594936704,null,null,48,3.63,1.561752808,24.653408945999999,6.791572712396694]
[null,9,1.82,0.80468629999999985,4.7619791999999999,2.6164720879120877,null,null,52,3.64,1.6265686360000002,26.279977582000001,7.2197740609890113]
[null,10,1.98,0.83775559999999993,5.5997348000000002,2.8281488888888888,null,null,56,3.65,1.7145329739999999,27.994510556000002,7.669728919452055]
[null,11,2.17,0.8487787,6.4485135000000007,2.9716652073732721,null,null,60,3.66,1.8364484599999999,29.830959016000001,8.150535250273224]
[null,12,2.37,0.88184799999999997,7.3303615000000004,3.0929795358649788,null,null,64,3.67,1.887375182,31.718334198000001,8.6425978741144416]
[null,13,2.54,0.90389419999999987,8.2342557000000003,3.2418329527559058,null,null,68,3.68,1.9305857339999999,33.648919931999998,9.1437282423913029]
[null,14,2.64,0.92594039999999989,9.1601961000000003,3.46977125]
[null,15,2.75,0.9479865999999999,10.1081827,3.6757028000000003,null,"these are definitely commercial type birds, not sure on the exact mix"]
[null,16,2.82,0.97003279999999992,11.078215500000001,3.9284452127659577]
[null,17,2.89,0.99207899999999993,12.070294500000001,4.1765724913494813]
[null,18,2.95,1.0141252000000001,13.084419700000002,4.4353965084745761]
[]
[null,"http://www.cccfeeds.com/assets/files/Resources/Poultry/Layer_Low_Res_%20RGB_Sept_2009.pdf"]