{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Entry","Equipment","Ventilation","Imperial","Tables","Circumference"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Data Entry","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,2],[4,2,4,3],[2,1,2,3],[18,2,18,3],[12,2,12,3],[5,2,5,3],[16,7,17,7],[2,7,2,8],[4,7,5,7],[7,7,8,7],[10,7,11,7],[13,7,13,8]]}
[null,"Data Entry"]
[]
[null,"Pen Details",null,null,null,null,null,"Ventilation Information"]
[null,"Birds","Males","Females"]
[null,"Current Age (week)",null,null,null,null,null,"Number of minimum ventilation fans available to be used"]
[null,"Age Transferred"]
[null,"Number Birds"]
[null,null,null,null,null,null,null,"Minimum ventilation fan capacity ft³/min"]
[null,"Pen Dimensions",{"$f":"IF($C$5<$C$6,\"\",\"Whole House\")","v":"Whole House"},{"$f":"IF($C$5<$C$6,\"\",\"Leave Blank\")","v":"Leave Blank"}]
[null,"Length (ft)"]
[null,"Width (ft)",null,null,null,null,null,"Cycle timer Length (Seconds)"]
[]
[null,"Actual Pen Drinkers","Enter either nipple, cup or bell field only"]
[null,"Number of nipples",null,null,null,null,null,"Nest Boxes"]
[null,"Number of cups"]
[null,"Number of bell drinkers",null,null,"Bell diameter (in)",null,null,"Manual (no of holes)"]
[null,null,{"$f":"IF((COUNT(C14:C16)>1),\"Error\",\"\")","v":""},{"$f":"IF((COUNT(D14:D16)>1),\"Error\",\"\")","v":""},null,null,null,"Automatic (Linear feet of nest space)"]
[null,null,null,null,null,null,null,null,{"$f":"IF((COUNT(I15:I17)>1),\"Error\",\"\")","v":""}]
[null,"Actual Pen Feeders","Enter either pan or track field only"]
[null,"Number of pans",null,null,"Pan diameter (in)"]
[null,"Length of track (ft)"]
[null,null,{"$f":"IF((COUNT(C19:C21)>1),\"Error\",\"\")","v":""},{"$f":"IF((COUNT(D19:D21)>1),\"Error\",\"\")","v":""}]
[]
[]
[null,"Go to:"]

{"sheet":"Equipment","index":1,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,1,23,1],[19,1,20,1],[13,1,14,1],[19,7,20,7],[5,4,5,5],[10,7,11,7],[16,7,17,7],[13,7,14,7],[22,7,23,7],[8,12,8,13],[15,12,16,13],[7,1,8,1],[10,1,11,1],[16,1,17,1]]}
[null,"Pen Setup",{"$f":"IF('Data Entry'!C5<'Data Entry'!C6,\"Rearing\",\"Production\")","v":"Production"}]
[]
[null,"Pen Area (ft2)",{"$f":"IF($C$1=\"Production\",\"House\",\"Males\")","v":"House"},{"$f":"'Data Entry'!C10*'Data Entry'!C11","v":0},null,null,"Age (weeks)",{"$f":"IF('Data Entry'!C5=\"\",\"\",'Data Entry'!C5)","v":""}]
[null,null,{"$f":"IF($C$1=\"Production\",\"\",\"Females\")","v":""},{"$f":"IF('Data Entry'!C5<'Data Entry'!C6,'Data Entry'!D10*'Data Entry'!D11,\"\")","v":""}]
[]
[null,null,null,"Actual","Recommended",null,null,null,null,"Actual","Recommended"]
[null,null,null,null,"Range","Maximum",null,null,null,null,"Minimum"]
[null,"Stocking Density (ft2/bird)",{"$f":"IF($C$1=\"Production\",\"House\",\"Males\")","v":"House"},{"$f":"IFERROR(IF('Data Entry'!$C$5<'Data Entry'!$C$6,(Equipment!$D$3/'Data Entry'!C7),(Equipment!$D$3/('Data Entry'!C7+'Data Entry'!D7))),\"\")","v":""},{"$f":"IF(H3=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$B$3:$B$73))","v":""},{"$f":"IF(H3=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$F$3:$F$73))","v":""}]
[null,null,{"$f":"IF($C$1=\"Production\",\"\",\"Females\")","v":""},{"$f":"IFERROR(IF('Data Entry'!$C$5<'Data Entry'!$C$6,('Data Entry'!D7/Equipment!$D$3),\"\"),\"\")","v":""},{"$f":"IF(D9=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$C$3:$C$73))","v":""},{"$f":"IF(D9=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$H$3:$H$73))","v":""},null,null,null,null,null,null,"Nest boxes"]
[]
[null,"Birds per nipple drinker","Males",{"$f":"IF('Data Entry'!C14=\"\",\"\",'Data Entry'!C7/'Data Entry'!C14)","v":""},{"$f":"IF(D11=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$K$3:$K$73))","v":""},{"$f":"IF(D11=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$L$3:$L$73))","v":""},null,"Nipples drinkers per pen","Males",{"$f":"IF('Data Entry'!C14=\"\",\"\",'Data Entry'!C14)","v":""},{"$f":"IF(J11=\"\",\"\",ROUNDUP('Data Entry'!C7/Equipment!F11,0))","v":""},null,"Manual (holes)",{"$f":"IF('Data Entry'!I16=\"\",\"\",'Data Entry'!I16)","v":""}]
[null,null,"Females",{"$f":"IF('Data Entry'!D14=\"\",\"\",'Data Entry'!D7/'Data Entry'!D14)","v":""},{"$f":"IF(D12=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$K$3:$K$73))","v":""},{"$f":"IF(D12=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$L$3:$L$73))","v":""},null,null,"Females",{"$f":"IF('Data Entry'!D14=\"\",\"\",'Data Entry'!D14)","v":""},{"$f":"IF(J12=\"\",\"\",ROUNDUP('Data Entry'!D7/Equipment!F12,0))","v":""},null,"Recommended",{"$f":"IF('Data Entry'!I16=\"\",\"\",'Data Entry'!D7/4)","v":""}]
[]
[null,"Birds per cup drinker","Males",{"$f":"IF('Data Entry'!C15=\"\",\"\",('Data Entry'!C7/'Data Entry'!C15))","v":""},{"$f":"IF(D14=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$M$3:$M$73))","v":""},{"$f":"IF(D14=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$N$3:$N$73))","v":""},null,"Cup drinkers per pen","Males",{"$f":"IF('Data Entry'!C15=\"\",\"\",'Data Entry'!C15)","v":""},{"$f":"IF(J14=\"\",\"\",'Data Entry'!C$7/(LOOKUP(Equipment!$H$3,Tables!$J$3:$J$73,Tables!$N$3:$N$73)))","v":""},null,"Automatic (ft)",{"$f":"IF('Data Entry'!I17=\"\",\"\",'Data Entry'!I17)","v":""}]
[null,null,"Females",{"$f":"IF('Data Entry'!D15=\"\",\"\",('Data Entry'!D7/'Data Entry'!D15))","v":""},{"$f":"IF(D15=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$M$3:$M$73))","v":""},{"$f":"IF(D15=\"\",\"\",LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$N$3:$N$73))","v":""},null,null,"Females",{"$f":"IF('Data Entry'!D15=\"\",\"\",'Data Entry'!D15)","v":""},{"$f":"IF(J15=\"\",\"\",'Data Entry'!D$7/(LOOKUP(Equipment!$H$3,Tables!$J$3:$J$73,Tables!$N$3:$N$73)))","v":""},null,"Recommended (ft)*",{"$f":"IF('Data Entry'!I17=\"\",\"\",'Data Entry'!D7/12.2)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Recommended based on 12.2 birds per ft. Equipment may vary"]
[null,"Birds per bell drinker","Males",{"$f":"IF('Data Entry'!C16=\"\",\"\",'Data Entry'!C7/'Data Entry'!C16)","v":""},null,{"$f":"IF(D17=\"\",\"\",ROUNDDOWN(Circumference!$F$2/(LOOKUP($H$3,Tables!$J$3:$J$73,Tables!$O$3:$O$73)),0))","v":""},null,"Bell drinkers per pen","Males",{"$f":"IF('Data Entry'!C16=\"\",\"\",'Data Entry'!C16)","v":""},{"$f":"IF('Data Entry'!C16=\"\",\"\",ROUNDUP('Data Entry'!C7/F17,0))","v":""}]
[null,null,"Females",{"$f":"IF('Data Entry'!D16=\"\",\"\",'Data Entry'!D7/'Data Entry'!D16)","v":""},null,{"$f":"IF(D18=\"\",\"\",ROUNDDOWN(Circumference!$F$2/(LOOKUP($H$3,Tables!$J$3:$J$73,Tables!$O$3:$O$73)),0))","v":""},null,null,"Females",{"$f":"IF('Data Entry'!D16=\"\",\"\",'Data Entry'!D16)","v":""},{"$f":"IF('Data Entry'!D16=\"\",\"\",ROUNDUP('Data Entry'!D7/F18,0))","v":""}]
[]
[null,"Birds per pan feeder","Males",{"$f":"IF('Data Entry'!C20=\"\",\"\",'Data Entry'!C7/'Data Entry'!C20)","v":""},null,{"$f":"IF(D20=\"\",\"\",ROUNDDOWN((Circumference!F3/LOOKUP('Data Entry'!C5,Tables!Q$3:Q$73,Tables!T$3:T$73)),0))","v":""},null,"Pan feeders per pen","Males",{"$f":"IF('Data Entry'!C20=\"\",\"\",'Data Entry'!C20)","v":""},{"$f":"IF(J20=\"\",\"\",ROUNDUP('Data Entry'!C7/Equipment!F20,0))","v":""}]
[null,null,"Females",{"$f":"IF('Data Entry'!D20=\"\",\"\",'Data Entry'!D7/'Data Entry'!D20)","v":""},null,{"$f":"IF(D21=\"\",\"\",ROUNDDOWN((Circumference!F3/LOOKUP(Imperial!F6,Tables!Q$3:Q$73,Tables!U$3:U$73)),0))","v":""},null,null,"Females",{"$f":"IF('Data Entry'!D20=\"\",\"\",'Data Entry'!D20)","v":""},{"$f":"IF(J21=\"\",\"\",ROUNDUP('Data Entry'!D7/Equipment!F21,0))","v":""}]
[]
[null,"Track feeder (in/bird)","Males",{"$f":"IF('Data Entry'!C21=\"\",\"\",('Data Entry'!C21*24)/'Data Entry'!C7)","v":""},null,{"$f":"IF(D23=\"\",\"\",LOOKUP(H3,Tables!Q3:Q73,Tables!R3:R73))","v":""},null,"Track feeder length (ft)","Males",{"$f":"IF('Data Entry'!C21=\"\",\"\",'Data Entry'!C21)","v":""},{"$f":"IF(J23=\"\",\"\",('Data Entry'!C7*(Equipment!F23/24)))","v":""}]
[null,null,"Females",{"$f":"IF('Data Entry'!D21=\"\",\"\",('Data Entry'!D21*24)/'Data Entry'!D7)","v":""},null,{"$f":"IF(D24=\"\",\"\",LOOKUP(H3,Tables!Q3:Q73,Tables!S3:S73))","v":""},null,null,"Females",{"$f":"IF('Data Entry'!D21=\"\",\"\",'Data Entry'!D21)","v":""},{"$f":"IF(J24=\"\",\"\",('Data Entry'!D7*(Equipment!F24/24)))","v":""}]
[]
[null,null,null,"Values in red exceed recommended maximum",null,null,null,null,null,"Values in red below recommended minimum"]

{"sheet":"Ventilation","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ventilation"]
[]
[null,"Bird Body Weight (lb)","Minimum House Air requirements (ft3/min)","Ideal Number of Minimum Ventilation Fans Required","Time on (s)","Time off (s)","Actual number of Minimum Ventilation Fans","Time on (s)","Time off (s)"]
[]
[null,0.1,{"$f":"Imperial!E19","v":0},{"$f":"Imperial!H19","v":""},{"$f":"Imperial!F19","v":""},{"$f":"Imperial!G19","v":""},{"$f":"Imperial!I19","v":0},{"$f":"Imperial!J19","v":""},{"$f":"Imperial!K19","v":""},null,"If Time On / Time off values are in red"]
[null,0.2,{"$f":"Imperial!E20","v":0},{"$f":"Imperial!H20","v":""},{"$f":"Imperial!F20","v":""},{"$f":"Imperial!G20","v":""},{"$f":"Imperial!I20","v":0},{"$f":"Imperial!J20","v":""},{"$f":"Imperial!K20","v":""},null,"there is insufficient ventilation, consider:"]
[null,0.4,{"$f":"Imperial!E21","v":0},{"$f":"Imperial!H21","v":""},{"$f":"Imperial!F21","v":""},{"$f":"Imperial!G21","v":""},{"$f":"Imperial!I21","v":0},{"$f":"Imperial!J21","v":""},{"$f":"Imperial!K21","v":""},null,"1. Increase number of minimum ventilation fans or fan capacity"]
[null,0.6,{"$f":"Imperial!E22","v":0},{"$f":"Imperial!H22","v":""},{"$f":"Imperial!F22","v":""},{"$f":"Imperial!G22","v":""},{"$f":"Imperial!I22","v":0},{"$f":"Imperial!J22","v":""},{"$f":"Imperial!K22","v":""},null,"2. Lock a fan on and use a second fan on a timer"]
[null,0.8,{"$f":"Imperial!E23","v":0},{"$f":"Imperial!H23","v":""},{"$f":"Imperial!F23","v":""},{"$f":"Imperial!G23","v":""},{"$f":"Imperial!I23","v":0},{"$f":"Imperial!J23","v":""},{"$f":"Imperial!K23","v":""}]
[null,1,{"$f":"Imperial!E24","v":0},{"$f":"Imperial!H24","v":""},{"$f":"Imperial!F24","v":""},{"$f":"Imperial!G24","v":""},{"$f":"Imperial!I24","v":0},{"$f":"Imperial!J24","v":""},{"$f":"Imperial!K24","v":""}]
[null,1.4,{"$f":"Imperial!E25","v":0},{"$f":"Imperial!H25","v":""},{"$f":"Imperial!F25","v":""},{"$f":"Imperial!G25","v":""},{"$f":"Imperial!I25","v":0},{"$f":"Imperial!J25","v":""},{"$f":"Imperial!K25","v":""}]
[null,1.8,{"$f":"Imperial!E26","v":0},{"$f":"Imperial!H26","v":""},{"$f":"Imperial!F26","v":""},{"$f":"Imperial!G26","v":""},{"$f":"Imperial!I26","v":0},{"$f":"Imperial!J26","v":""},{"$f":"Imperial!K26","v":""}]
[null,2.2000000000000002,{"$f":"Imperial!E27","v":0},{"$f":"Imperial!H27","v":""},{"$f":"Imperial!F27","v":""},{"$f":"Imperial!G27","v":""},{"$f":"Imperial!I27","v":0},{"$f":"Imperial!J27","v":""},{"$f":"Imperial!K27","v":""}]
[null,2.6,{"$f":"Imperial!E28","v":0},{"$f":"Imperial!H28","v":""},{"$f":"Imperial!F28","v":""},{"$f":"Imperial!G28","v":""},{"$f":"Imperial!I28","v":0},{"$f":"Imperial!J28","v":""},{"$f":"Imperial!K28","v":""}]
[null,3,{"$f":"Imperial!E29","v":0},{"$f":"Imperial!H29","v":""},{"$f":"Imperial!F29","v":""},{"$f":"Imperial!G29","v":""},{"$f":"Imperial!I29","v":0},{"$f":"Imperial!J29","v":""},{"$f":"Imperial!K29","v":""}]
[null,3.4,{"$f":"Imperial!E30","v":0},{"$f":"Imperial!H30","v":""},{"$f":"Imperial!F30","v":""},{"$f":"Imperial!G30","v":""},{"$f":"Imperial!I30","v":0},{"$f":"Imperial!J30","v":""},{"$f":"Imperial!K30","v":""}]
[null,3.8,{"$f":"Imperial!E31","v":0},{"$f":"Imperial!H31","v":""},{"$f":"Imperial!F31","v":""},{"$f":"Imperial!G31","v":""},{"$f":"Imperial!I31","v":0},{"$f":"Imperial!J31","v":""},{"$f":"Imperial!K31","v":""}]
[null,4.2,{"$f":"Imperial!E32","v":0},{"$f":"Imperial!H32","v":""},{"$f":"Imperial!F32","v":""},{"$f":"Imperial!G32","v":""},{"$f":"Imperial!I32","v":0},{"$f":"Imperial!J32","v":""},{"$f":"Imperial!K32","v":""}]
[null,4.5999999999999996,{"$f":"Imperial!E33","v":0},{"$f":"Imperial!H33","v":""},{"$f":"Imperial!F33","v":""},{"$f":"Imperial!G33","v":""},{"$f":"Imperial!I33","v":0},{"$f":"Imperial!J33","v":""},{"$f":"Imperial!K33","v":""}]
[null,5,{"$f":"Imperial!E34","v":0},{"$f":"Imperial!H34","v":""},{"$f":"Imperial!F34","v":""},{"$f":"Imperial!G34","v":""},{"$f":"Imperial!I34","v":0},{"$f":"Imperial!J34","v":""},{"$f":"Imperial!K34","v":""}]
[null,5.4,{"$f":"Imperial!E35","v":0},{"$f":"Imperial!H35","v":""},{"$f":"Imperial!F35","v":""},{"$f":"Imperial!G35","v":""},{"$f":"Imperial!I35","v":0},{"$f":"Imperial!J35","v":""},{"$f":"Imperial!K35","v":""}]
[null,5.8,{"$f":"Imperial!E36","v":0},{"$f":"Imperial!H36","v":""},{"$f":"Imperial!F36","v":""},{"$f":"Imperial!G36","v":""},{"$f":"Imperial!I36","v":0},{"$f":"Imperial!J36","v":""},{"$f":"Imperial!K36","v":""}]
[null,6.2,{"$f":"Imperial!E37","v":0},{"$f":"Imperial!H37","v":""},{"$f":"Imperial!F37","v":""},{"$f":"Imperial!G37","v":""},{"$f":"Imperial!I37","v":0},{"$f":"Imperial!J37","v":""},{"$f":"Imperial!K37","v":""}]
[null,6.6,{"$f":"Imperial!E38","v":0},{"$f":"Imperial!H38","v":""},{"$f":"Imperial!F38","v":""},{"$f":"Imperial!G38","v":""},{"$f":"Imperial!I38","v":0},{"$f":"Imperial!J38","v":""},{"$f":"Imperial!K38","v":""}]
[null,7,{"$f":"Imperial!E39","v":0},{"$f":"Imperial!H39","v":""},{"$f":"Imperial!F39","v":""},{"$f":"Imperial!G39","v":""},{"$f":"Imperial!I39","v":0},{"$f":"Imperial!J39","v":""},{"$f":"Imperial!K39","v":""}]
[null,7.4,{"$f":"Imperial!E40","v":0},{"$f":"Imperial!H40","v":""},{"$f":"Imperial!F40","v":""},{"$f":"Imperial!G40","v":""},{"$f":"Imperial!I40","v":0},{"$f":"Imperial!J40","v":""},{"$f":"Imperial!K40","v":""}]
[null,7.8,{"$f":"Imperial!E41","v":0},{"$f":"Imperial!H41","v":""},{"$f":"Imperial!F41","v":""},{"$f":"Imperial!G41","v":""},{"$f":"Imperial!I41","v":0},{"$f":"Imperial!J41","v":""},{"$f":"Imperial!K41","v":""}]
[null,8.1999999999999993,{"$f":"Imperial!E42","v":0},{"$f":"Imperial!H42","v":""},{"$f":"Imperial!F42","v":""},{"$f":"Imperial!G42","v":""},{"$f":"Imperial!I42","v":0},{"$f":"Imperial!J42","v":""},{"$f":"Imperial!K42","v":""}]
[null,8.6,{"$f":"Imperial!E43","v":0},{"$f":"Imperial!H43","v":""},{"$f":"Imperial!F43","v":""},{"$f":"Imperial!G43","v":""},{"$f":"Imperial!I43","v":0},{"$f":"Imperial!J43","v":""},{"$f":"Imperial!K43","v":""}]
[null,9,{"$f":"Imperial!E44","v":0},{"$f":"Imperial!H44","v":""},{"$f":"Imperial!F44","v":""},{"$f":"Imperial!G44","v":""},{"$f":"Imperial!I44","v":0},{"$f":"Imperial!J44","v":""},{"$f":"Imperial!K44","v":""}]
[null,9.4,{"$f":"Imperial!E45","v":0},{"$f":"Imperial!H45","v":""},{"$f":"Imperial!F45","v":""},{"$f":"Imperial!G45","v":""},{"$f":"Imperial!I45","v":0},{"$f":"Imperial!J45","v":""},{"$f":"Imperial!K45","v":""}]
[null,9.8000000000000007,{"$f":"Imperial!E46","v":0},{"$f":"Imperial!H46","v":""},{"$f":"Imperial!F46","v":""},{"$f":"Imperial!G46","v":""},{"$f":"Imperial!I46","v":0},{"$f":"Imperial!J46","v":""},{"$f":"Imperial!K46","v":""}]

{"sheet":"Imperial","index":3,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":true,"merged":[[13,1,13,9],[6,16,6,18],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,16,10],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,19,6,20],[0,15,0,20],[1,4,1,7],[1,12,1,14],[1,8,1,11],[0,1,0,14],[1,1,1,3],[6,8,6,11],[6,12,6,14],[2,7,2,8],[2,4,3,4],[2,1,3,1],[2,2,3,2],[1,17,1,19]]}
[null,"H O U S E     E Q  U I P M E N T    S P E C I F I C A T I O N / R E Q  U I R E M E N T S."]
[null,"House Size",null,null,"Bird Number and Stocking Densities",null,null,null,"Recommended Number of Feeders/ Feeder space per bird",null,null,null,"Recommended Number of drinkers/ Drinker space per bird",null,null,null,null,"Recommended Nest Box Space"]
[null,"Width","Length","Actual Area (m²)","Actual Number of Birds Placed","Current Age of Flock (to nearest week)","Actual Stocking Density (birds/m²)","Recommended maximum Stocking Density For Age (birds/m²)",null,"Pans","Total Track length required (m)*",null,"Nipples",null,"Bells",null,null,"Manual Collect Nests (4 birds per nest hole)","*Mechanical Collect (Based on 40 birds per linear meter nest space)"]
[null,null,null,null,null,{"$f":"'Data Entry'!C5","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"F6/4","v":0},{"$f":"SUM(F6/40)/2","v":0},"meters","* Equiment may vary"]
["Male",{"$f":"'Data Entry'!C11","v":0},{"$f":"'Data Entry'!C10","v":0},{"$f":"B5*C5","v":0},"Male",{"$f":"'Data Entry'!C7","v":0},{"$f":"IFERROR(SUM(F5/D5),\"\")","v":""},"Male",{"$f":"LOOKUP(F4,Tables!D3:D73,Tables!F3:F73)","v":4},{"$f":"F5/10","v":0},{"$f":"F5*0.18/2","v":0},null,{"$f":"F5/10","v":0},null,{"$f":"F5*1.5/40","v":0},"* Maximum length given"]
["Female",{"$f":"'Data Entry'!D11","v":0},{"$f":"'Data Entry'!D10","v":0},{"$f":"B6*C6","v":0},"Female",{"$f":"'Data Entry'!D7","v":0},{"$f":"IFERROR(SUM(F6/D6),\"\")","v":""},"Female",{"$f":"LOOKUP(F4,Tables!D3:D73,Tables!H3:H73)","v":4},{"$f":"F6/12","v":0},{"$f":"F6*0.15/2","v":0},null,{"$f":"F6/10","v":0},null,{"$f":"F6*1.5/40","v":0},"* Maximum length given"]
[null,null,"Actual Number of nipples in House","Actual number of Bells in house","Actual Number of Pans in House","Actual Length of track in House (m)",null,null,"Actual Number of birds per feeder / Feed Space per bird",null,null,null,"Actual number of birds per drinker / space per bird",null,null,null,"Recommended feeder space",null,null,"Recommended birds per drinker"]
[null,null,null,null,null,null,null,null,"Birds / pan","cm track / bird",null,null,"Birds / Nipple",null,"Birds / Bell",null,"Birds / pan*","cm track / bird*",null,"Birds / Nipple*","cm / bird / Bell*"]
[null,"Male",{"$f":"'Data Entry'!C14","v":0},{"$f":"'Data Entry'!C16","v":0},{"$f":"'Data Entry'!C20","v":0},{"$f":"'Data Entry'!C21","v":0},null,"Male",{"$f":"IFERROR(SUM($F$5/$E$9),\"\")","v":""},{"$f":"IFERROR(SUM($F$9/$F$5)*100,\"\")","v":""},null,null,{"$f":"IFERROR(SUM($F$5/$C$9),\"\")","v":""},null,{"$f":"IF('Data Entry'!C16=\"\",\"\",ROUNDUP(F5/D9,0))","v":""},null,"10-12","5-18",null,"6-12",{"$f":"LOOKUP(F4,Tables!J3:J73,Tables!O3:O73)","v":0.6}]
[null,"Female",{"$f":"'Data Entry'!D14","v":0},{"$f":"'Data Entry'!D16","v":0},{"$f":"'Data Entry'!D20","v":0},{"$f":"'Data Entry'!D21","v":0},null,"Female",{"$f":"IFERROR(SUM($F$6/$E$10),\"\")","v":""},{"$f":"IFERROR(SUM($F$10/$F$6)*100,\"\")","v":""},null,null,{"$f":"IFERROR(SUM($F$6/$C$10),\"\")","v":""},null,{"$f":"IF('Data Entry'!D16=\"\",\"\",ROUNDUP(F6/D10,0))","v":""},null,"* Depending on age of flock"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caution – Not enough ventilation:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Increase number of minimum ventilation fans or fan capacity"]
[null,"V E N T I L A T I O N ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Lock a fan on and use a second fan on a timer"]
[null,null,null,"Number of Minimum Ventilation fans to be used",{"$f":"'Data Entry'!I5","v":0},"Minimum ventilation fan capacity ft³/min",{"$f":"'Data Entry'!I8","v":0},null,"Cycle timer Length (Seconds)",{"$f":"'Data Entry'!I11","v":0}]
[]
[null,null,"Weight (lb)","Minimum Air requirements / bird","Minimum Air requirements / house","Cycle timer requirements"]
[null,null,null,null,null,"Time on (s)","Time off (s)","Suggested Ideal Number of Fans To Use with Simple step up programme","Fans in Use based on Number Available","Time on (s)","Time off (s)"]
[null,null,0.1,7.1004102900000005E-2,{"$f":"SUM($F$5:$F$6)*D19","v":0},{"$f":"IFERROR(SUM(L19/H19),\"\")","v":""},{"$f":"IFERROR(SUM($J$15-F19),\"\")","v":""},{"$f":"IFERROR(IF(L19<SUM($J$15/4),1,IF(L19>SUM($J$15/1),4,IF(L19>SUM($J$15/2),3,2))),\"\")","v":""},{"$f":"$E$15","v":0},{"$f":"IFERROR(SUM(L19/I19),\"\")","v":""},{"$f":"IFERROR(SUM($J$15-J19),\"\")","v":""},{"$f":"SUM($E19/$G$15)*SUM($J$15/$E$15)","v":{"$error":"#DIV/0!"}},{"$f":"IF(K19<0,IF(K18=$K$18,$R$12,\"\"),\"\")","v":""}]
[null,null,0.2,9.4487923200000004E-2,{"$f":"SUM($F$5:$F$6)*D20","v":0},{"$f":"IFERROR(SUM(L20/H20),\"\")","v":""},{"$f":"IFERROR(SUM($J$15-F20),\"\")","v":""},{"$f":"IFERROR(IF(L20<SUM($J$15/4),1,IF(L20>SUM($J$15/1),4,IF(L20>SUM($J$15/2),3,2))),\"\")","v":""},{"$f":"$E$15","v":0},{"$f":"IFERROR(SUM(L20/I20),\"\")","v":""},{"$f":"IFERROR(SUM($J$15-J20),\"\")","v":""},{"$error":"#DIV/0!"},{"$f":"IF(K20<0,IF(K19>=0,$R$12,$R$13),\"\")","v":""}]
[null,null,0.4,0.1405553856,0,"","","",0,"","",{"$error":"#DIV/0!"},{"$f":"IF(K21<0,IF(K20>=0,$R$12,IF(K19>=0,$R$13,$R$14)),\"\")","v":""}]
[null,null,0.6,0.18545072639999999,0,"","","",0,"","",{"$error":"#DIV/0!"},{"$f":"IF(K22<0,IF(K21>=0,$R$12,IF(K20>=0,$R$13,IF(K19>=0,$R$14,\"\"))),\"\")","v":""}]
[null,null,0.8,0.22920768479999998,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1,0.27185999999999999,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1.4,0.35398565759999995,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1.8,0.43209761280000003,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,2.2000000000000002,0.50646577920000002,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,2.6,0.57736007039999993,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,3,0.64505040000000002,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,3.4,0.70980668159999993,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,3.8,0.77189882879999994,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,4.2,0.83159675519999998,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,4.5999999999999996,0.88917037439999991,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,5,0.9448896,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,5.4,0.99902434559999997,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,5.8,1.0518445247999999,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,6.2,1.1036200512000001,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,6.6,1.1546208383999998,0,"","","",0,"","",{"$error":"#DIV/0!"},{"$f":"IF(K38<0,IF(K37>=0,$R$12,IF(K36>=0,$R$13,IF(K35>=0,$R$14,\"\"))),\"\")","v":""}]
[null,null,7,1.2051168000000001,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,7.4,1.2553778496000001,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,7.8,1.3056739007999998,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,8.1999999999999993,1.3562748672,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,8.6,1.4074506623999998,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,9,1.4594711999999999,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,9.4,1.5126063935999998,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,9.8000000000000007,1.5671261568000001,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K47=\"\",IF(K46<0,IF(K45>=0,$R$13,IF(K44>=0,$R$14,\"\")),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K48=\"\",IF(K47=\"\",IF(K46<0,IF(K45>=0,$R$14,\"\"),\"\"),\"\"),\"\")","v":""}]

{"sheet":"Tables","index":4,"n_rows":73,"n_cols":21,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,6,0,7],[0,17,0,18],[0,19,0,20]]}
["Stocking Densities",null,null,null,"Male",null,"Female",null,null,null,"Nipple Drinkers",null,"Cup Drinkers",null,"Bell Drinkers",null,null,"Track Feeder",null,"Pan Feeder"]
["Age","Male","Female","Age","Min","Max","Min","Max",null,"Age","Range","Max","Range","Max","Max",null,"Age","Male","Female","Male","Female"]
[0,4,4,0,4,4,4,4,null,0,"8 to 12",12,"20 to 30",30,0.6,null,0,2,2,2,2]
[1,4,4,1,4,4,4,4,null,1,"8 to 12",12,"20 to 30",30,0.6,null,1,2,2,2,2]
[2,"2.7 to 3.6","1.5 to 2.7",2,3.6,2.7,2.7,1.5,null,2,"8 to 12",12,"20 to 30",30,0.6,null,2,2,2,2,2]
[3,"2.7 to 3.6","1.5 to 2.7",3,3.6,2.7,2.7,1.5,null,3,"8 to 12",12,"20 to 30",30,0.6,null,3,2,2,2,2]
[{"$f":"A6+1","v":4},"2.7 to 3.6","1.5 to 2.7",4,3.6,2.7,2.7,1.5,null,4,"8 to 12",12,"20 to 30",30,0.6,null,4,2,2,2,2]
[{"$f":"A7+1","v":5},"2.7 to 3.6","1.5 to 2.7",5,3.6,2.7,2.7,1.5,null,5,"8 to 12",12,"20 to 30",30,0.6,null,5,2,2,2,2]
[6,"2.7 to 3.6","1.5 to 2.7",6,3.6,2.7,2.7,1.5,null,6,"8 to 12",12,"20 to 30",30,0.6,null,6,4,4,3.5,3]
[7,"2.7 to 3.6","1.5 to 2.7",7,3.6,2.7,2.7,1.5,null,7,"8 to 12",12,"20 to 30",30,0.6,null,7,4,4,3.5,3]
[8,"2.7 to 3.6","1.5 to 2.7",8,3.6,2.7,2.7,1.5,null,8,"8 to 12",12,"20 to 30",30,0.6,null,8,4,4,3.5,3]
[9,"2.7 to 3.6","1.5 to 2.7",9,3.6,2.7,2.7,1.5,null,9,"8 to 12",12,"20 to 30",30,0.6,null,9,4,4,3.5,3]
[10,"2.7 to 3.6","1.5 to 2.7",10,3.6,2.7,2.7,1.5,null,10,"8 to 12",12,"20 to 30",30,0.6,null,10,4,4,3.5,3]
[11,"2.7 to 3.6","1.5 to 2.7",11,3.6,2.7,2.7,1.5,null,11,"8 to 12",12,"20 to 30",30,0.6,null,11,6,6,4,4]
[12,"2.7 to 3.6","1.5 to 2.7",12,3.6,2.7,2.7,1.5,null,12,"8 to 12",12,"20 to 30",30,0.6,null,12,6,6,4,4]
[13,"2.7 to 3.6","1.5 to 2.7",13,3.6,2.7,2.7,1.5,null,13,"8 to 12",12,"20 to 30",30,0.6,null,13,6,6,4,4]
[14,"2.7 to 3.6","1.5 to 2.7",14,3.6,2.7,2.7,1.5,null,14,"8 to 12",12,"20 to 30",30,0.6,null,14,6,6,4,4]
[15,"2.7 to 3.6","1.5 to 2.7",15,3.6,2.7,2.7,1.5,null,15,"8 to 12",12,"20 to 30",30,0.6,null,15,6,6,4,4]
[16,"2.7 to 3.6","1.5 to 2.7",16,3.6,2.7,2.7,1.5,null,16,"8 to 12",12,"20 to 30",30,0.6,null,16,6,6,4,4]
[17,"2.7 to 3.6","1.5 to 2.7",17,3.6,2.7,2.7,1.5,null,17,"8 to 12",12,"20 to 30",30,0.6,null,17,6,6,4,4]
[18,"2.7 to 3.6","1.5 to 2.7",18,3.6,2.7,2.7,1.5,null,18,"8 to 12",12,"20 to 30",30,0.6,null,18,6,6,4,4]
[19,"2.7 to 3.6","1.5 to 2.7",19,3.6,2.7,2.7,1.5,null,19,"8 to 12",12,"20 to 30",30,0.6,null,19,6,6,4,4]
[20,"2.0 to 3.1","2.0 to 3.1",20,3.1,2,3.1,2,null,20,"8 to 12",12,"20 to 30",30,0.6,null,20,6,6,4,4]
[21,"2.0 to 3.1","2.0 to 3.1",21,3.1,2,3.1,2,null,21,"6 to 10",10,"15 to 20",20,1,null,21,8,6,6,4]
[22,"2.0 to 3.1","2.0 to 3.1",22,3.1,2,3.1,2,null,22,"6 to 10",10,"15 to 20",20,1,null,22,8,6,6,4]
[23,"2.0 to 3.1","2.0 to 3.1",23,3.1,2,3.1,2,null,23,"6 to 10",10,"15 to 20",20,1,null,23,8,6,6,4]
[24,"2.0 to 3.1","2.0 to 3.1",24,3.1,2,3.1,2,null,24,"6 to 10",10,"15 to 20",20,1,null,24,8,6,6,4]
[25,"2.0 to 3.1","2.0 to 3.1",25,3.1,2,3.1,2,null,25,"6 to 10",10,"15 to 20",20,1,null,25,8,6,6,4]
[26,"2.0 to 3.1","2.0 to 3.1",26,3.1,2,3.1,2,null,26,"6 to 10",10,"15 to 20",20,1,null,26,8,6,6,4]
[27,"2.0 to 3.1","2.0 to 3.1",27,3.1,2,3.1,2,null,27,"6 to 10",10,"15 to 20",20,1,null,27,8,6,6,4]
[28,"2.0 to 3.1","2.0 to 3.1",28,3.1,2,3.1,2,null,28,"6 to 10",10,"15 to 20",20,1,null,28,8,6,6,4]
[29,"2.0 to 3.1","2.0 to 3.1",29,3.1,2,3.1,2,null,29,"6 to 10",10,"15 to 20",20,1,null,29,8,6,6,4]
[30,"2.0 to 3.1","2.0 to 3.1",30,3.1,2,3.1,2,null,30,"6 to 10",10,"15 to 20",20,1,null,30,8,6,6,4]
[31,"2.0 to 3.1","2.0 to 3.1",31,3.1,2,3.1,2,null,31,"6 to 10",10,"15 to 20",20,1,null,31,8,6,6,4]
[32,"2.0 to 3.1","2.0 to 3.1",32,3.1,2,3.1,2,null,32,"6 to 10",10,"15 to 20",20,1,null,32,8,6,6,4]
[33,"2.0 to 3.1","2.0 to 3.1",33,3.1,2,3.1,2,null,33,"6 to 10",10,"15 to 20",20,1,null,33,8,6,6,4]
[34,"2.0 to 3.1","2.0 to 3.1",34,3.1,2,3.1,2,null,34,"6 to 10",10,"15 to 20",20,1,null,34,8,6,6,4]
[35,"2.0 to 3.1","2.0 to 3.1",35,3.1,2,3.1,2,null,35,"6 to 10",10,"15 to 20",20,1,null,35,8,6,6,4]
[36,"2.0 to 3.1","2.0 to 3.1",36,3.1,2,3.1,2,null,36,"6 to 10",10,"15 to 20",20,1,null,36,8,6,6,4]
[37,"2.0 to 3.1","2.0 to 3.1",37,3.1,2,3.1,2,null,37,"6 to 10",10,"15 to 20",20,1,null,37,8,6,6,4]
[38,"2.0 to 3.1","2.0 to 3.1",38,3.1,2,3.1,2,null,38,"6 to 10",10,"15 to 20",20,1,null,38,8,6,6,4]
[39,"2.0 to 3.1","2.0 to 3.1",39,3.1,2,3.1,2,null,39,"6 to 10",10,"15 to 20",20,1,null,39,8,6,6,4]
[40,"2.0 to 3.1","2.0 to 3.1",40,3.1,2,3.1,2,null,40,"6 to 10",10,"15 to 20",20,1,null,40,8,6,6,4]
[41,"2.0 to 3.1","2.0 to 3.1",41,3.1,2,3.1,2,null,41,"6 to 10",10,"15 to 20",20,1,null,41,8,6,6,4]
[42,"2.0 to 3.1","2.0 to 3.1",42,3.1,2,3.1,2,null,42,"6 to 10",10,"15 to 20",20,1,null,42,8,6,6,4]
[43,"2.0 to 3.1","2.0 to 3.1",43,3.1,2,3.1,2,null,43,"6 to 10",10,"15 to 20",20,1,null,43,8,6,6,4]
[44,"2.0 to 3.1","2.0 to 3.1",44,3.1,2,3.1,2,null,44,"6 to 10",10,"15 to 20",20,1,null,44,8,6,6,4]
[45,"2.0 to 3.1","2.0 to 3.1",45,3.1,2,3.1,2,null,45,"6 to 10",10,"15 to 20",20,1,null,45,8,6,6,4]
[46,"2.0 to 3.1","2.0 to 3.1",46,3.1,2,3.1,2,null,46,"6 to 10",10,"15 to 20",20,1,null,46,8,6,6,4]
[47,"2.0 to 3.1","2.0 to 3.1",47,3.1,2,3.1,2,null,47,"6 to 10",10,"15 to 20",20,1,null,47,8,6,6,4]
[48,"2.0 to 3.1","2.0 to 3.1",48,3.1,2,3.1,2,null,48,"6 to 10",10,"15 to 20",20,1,null,48,8,6,6,4]
[49,"2.0 to 3.1","2.0 to 3.1",49,3.1,2,3.1,2,null,49,"6 to 10",10,"15 to 20",20,1,null,49,8,6,6,4]
[50,"2.0 to 3.1","2.0 to 3.1",50,3.1,2,3.1,2,null,50,"6 to 10",10,"15 to 20",20,1,null,50,8,6,6,4]
[51,"2.0 to 3.1","2.0 to 3.1",51,3.1,2,3.1,2,null,51,"6 to 10",10,"15 to 20",20,1,null,51,8,6,6,4]
[52,"2.0 to 3.1","2.0 to 3.1",52,3.1,2,3.1,2,null,52,"6 to 10",10,"15 to 20",20,1,null,52,8,6,6,4]
[53,"2.0 to 3.1","2.0 to 3.1",53,3.1,2,3.1,2,null,53,"6 to 10",10,"15 to 20",20,1,null,53,8,6,6,4]
[54,"2.0 to 3.1","2.0 to 3.1",54,3.1,2,3.1,2,null,54,"6 to 10",10,"15 to 20",20,1,null,54,8,6,6,4]
[55,"2.0 to 3.1","2.0 to 3.1",55,3.1,2,3.1,2,null,55,"6 to 10",10,"15 to 20",20,1,null,55,8,6,6,4]
[56,"2.0 to 3.1","2.0 to 3.1",56,3.1,2,3.1,2,null,56,"6 to 10",10,"15 to 20",20,1,null,56,8,6,6,4]
[57,"2.0 to 3.1","2.0 to 3.1",57,3.1,2,3.1,2,null,57,"6 to 10",10,"15 to 20",20,1,null,57,8,6,6,4]
[58,"2.0 to 3.1","2.0 to 3.1",58,3.1,2,3.1,2,null,58,"6 to 10",10,"15 to 20",20,1,null,58,8,6,6,4]
[59,"2.0 to 3.1","2.0 to 3.1",59,3.1,2,3.1,2,null,59,"6 to 10",10,"15 to 20",20,1,null,59,8,6,6,4]
[60,"2.0 to 3.1","2.0 to 3.1",60,3.1,2,3.1,2,null,60,"6 to 10",10,"15 to 20",20,1,null,60,8,6,6,4]
[61,"2.0 to 3.1","2.0 to 3.1",61,3.1,2,3.1,2,null,61,"6 to 10",10,"15 to 20",20,1,null,61,8,6,6,4]
[62,"2.0 to 3.1","2.0 to 3.1",62,3.1,2,3.1,2,null,62,"6 to 10",10,"15 to 20",20,1,null,62,8,6,6,4]
[63,"2.0 to 3.1","2.0 to 3.1",63,3.1,2,3.1,2,null,63,"6 to 10",10,"15 to 20",20,1,null,63,8,6,6,4]
[64,"2.0 to 3.1","2.0 to 3.1",64,3.1,2,3.1,2,null,64,"6 to 10",10,"15 to 20",20,1,null,64,8,6,6,4]
[65,"2.0 to 3.1","2.0 to 3.1",65,3.1,2,3.1,2,null,65,"6 to 10",10,"15 to 20",20,1,null,65,8,6,6,4]
[66,"2.0 to 3.1","2.0 to 3.1",66,3.1,2,3.1,2,null,66,"6 to 10",10,"15 to 20",20,1,null,66,8,6,6,4]
[67,"2.0 to 3.1","2.0 to 3.1",67,3.1,2,3.1,2,null,67,"6 to 10",10,"15 to 20",20,1,null,67,8,6,6,4]
[68,"2.0 to 3.1","2.0 to 3.1",68,3.1,2,3.1,2,null,68,"6 to 10",10,"15 to 20",20,1,null,68,8,6,6,4]
[{"$f":"A71+1","v":69},"2.0 to 3.1","2.0 to 3.1",69,3.1,2,3.1,2,null,69,"6 to 10",10,"15 to 20",20,1,null,69,8,6,6,4]
[70,"2.0 to 3.1","2.0 to 3.1",70,3.1,2,3.1,2,null,70,"6 to 10",10,"15 to 20",20,1,null,70,8,6,6,4]

{"sheet":"Circumference","index":5,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Diameter","Circumference"]
[null,"Drinker circumference",null,null,{"$f":"'Data Entry'!F16","v":0},{"$f":"3.1416*E2","v":0}]
[null,"Feeder circumference",null,null,{"$f":"'Data Entry'!F20","v":0},{"$f":"3.1416*E3","v":0}]