{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Entry","Equipment","Ventilation","Metric","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":[[16,7,17,7],[2,7,2,8],[4,7,5,7],[7,7,8,7],[10,7,11,7],[13,7,13,8],[0,1,0,2],[4,2,4,3],[2,1,2,3],[18,2,18,3],[12,2,12,3],[5,2,5,3]]}
[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 m³/hr"]
[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 (m)"]
[null,"Width (m)",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 (cm)",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 meter 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 (cm)"]
[null,"Length of track (m)"]
[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":[[8,12,8,13],[15,12,16,13],[7,1,8,1],[10,1,11,1],[16,1,17,1],[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]]}
[null,"Pen Setup",{"$f":"IF('Data Entry'!C5<'Data Entry'!C6,\"Rearing\",\"Production\")","v":"Production"}]
[]
[null,"Pen Area (m2)",{"$f":"IF($C$1=\"Production\",\"House\",\"Males\")","v":"House"},{"$f":"'Data Entry'!C10*'Data Entry'!C11","v":0},null,null,"Age (weeks)",{"$f":"'Data Entry'!C5","v":0}]
[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 (birds/m2)",{"$f":"IF($C$1=\"Production\",\"House\",\"Males\")","v":"House"},{"$f":"IFERROR(IF('Data Entry'!$C$5<'Data Entry'!$C$6,(('Data Entry'!$C$7)/Equipment!$D$3),(('Data Entry'!$C$7+'Data Entry'!$D$7)/Equipment!$D$3)),\"\")","v":""},{"$f":"LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$B$3:$B$73)","v":40},{"$f":"LOOKUP($H$3,Tables!$A$3:$A$73,Tables!$F$3:$F$73)","v":40}]
[null,null,{"$f":"IF($C$1=\"Production\",\"\",\"Females\")","v":""},{"$f":"IFERROR(IF('Data Entry'!$C$5<'Data Entry'!$C$6,(('Data Entry'!$D$7)/Equipment!$D$4),\"\"),\"\")","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 (m)",{"$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 (m)*",{"$f":"IF('Data Entry'!I17=\"\",\"\",'Data Entry'!D7/40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Recommended based on 40 birds per meter. 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(Metric!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 (cm/bird)","Males",{"$f":"IF('Data Entry'!C21=\"\",\"\",('Data Entry'!C21*200)/'Data Entry'!C7)","v":""},null,{"$f":"IF(D23=\"\",\"\",LOOKUP(H3,Tables!Q3:Q73,Tables!R3:R73))","v":""},null,"Track feeder length (m)","Males",{"$f":"IF('Data Entry'!C21=\"\",\"\",'Data Entry'!C21)","v":""},{"$f":"IF(J23=\"\",\"\",('Data Entry'!C7*(Equipment!F23/200)))","v":""}]
[null,null,"Females",{"$f":"IF('Data Entry'!D21=\"\",\"\",('Data Entry'!D21*200)/'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/200)))","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 (kg)","Minimum House Air requirements (m3/h)","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.05,{"$f":"Metric!E19","v":0},{"$f":"Metric!H19","v":""},{"$f":"Metric!F19","v":""},{"$f":"Metric!G19","v":""},{"$f":"Metric!I19","v":0},{"$f":"Metric!J19","v":""},{"$f":"Metric!K19","v":""},null,"If Time On / Time off values are in red"]
[null,0.1,{"$f":"Metric!E20","v":0},{"$f":"Metric!H20","v":""},{"$f":"Metric!F20","v":""},{"$f":"Metric!G20","v":""},{"$f":"Metric!I20","v":0},{"$f":"Metric!J20","v":""},{"$f":"Metric!K20","v":""},null,"there is insufficient ventilation, consider:"]
[null,0.2,{"$f":"Metric!E21","v":0},{"$f":"Metric!H21","v":""},{"$f":"Metric!F21","v":""},{"$f":"Metric!G21","v":""},{"$f":"Metric!I21","v":0},{"$f":"Metric!J21","v":""},{"$f":"Metric!K21","v":""},null,"1. Increase number of minimum ventilation fans or fan capacity"]
[null,0.3,{"$f":"Metric!E22","v":0},{"$f":"Metric!H22","v":""},{"$f":"Metric!F22","v":""},{"$f":"Metric!G22","v":""},{"$f":"Metric!I22","v":0},{"$f":"Metric!J22","v":""},{"$f":"Metric!K22","v":""},null,"2. Lock a fan on and use a second fan on a timer"]
[null,0.4,{"$f":"Metric!E23","v":0},{"$f":"Metric!H23","v":""},{"$f":"Metric!F23","v":""},{"$f":"Metric!G23","v":""},{"$f":"Metric!I23","v":0},{"$f":"Metric!J23","v":""},{"$f":"Metric!K23","v":""}]
[null,0.5,{"$f":"Metric!E24","v":0},{"$f":"Metric!H24","v":""},{"$f":"Metric!F24","v":""},{"$f":"Metric!G24","v":""},{"$f":"Metric!I24","v":0},{"$f":"Metric!J24","v":""},{"$f":"Metric!K24","v":""}]
[null,0.6,{"$f":"Metric!E25","v":0},{"$f":"Metric!H25","v":""},{"$f":"Metric!F25","v":""},{"$f":"Metric!G25","v":""},{"$f":"Metric!I25","v":0},{"$f":"Metric!J25","v":""},{"$f":"Metric!K25","v":""}]
[null,0.7,{"$f":"Metric!E26","v":0},{"$f":"Metric!H26","v":""},{"$f":"Metric!F26","v":""},{"$f":"Metric!G26","v":""},{"$f":"Metric!I26","v":0},{"$f":"Metric!J26","v":""},{"$f":"Metric!K26","v":""}]
[null,0.8,{"$f":"Metric!E27","v":0},{"$f":"Metric!H27","v":""},{"$f":"Metric!F27","v":""},{"$f":"Metric!G27","v":""},{"$f":"Metric!I27","v":0},{"$f":"Metric!J27","v":""},{"$f":"Metric!K27","v":""}]
[null,0.9,{"$f":"Metric!E28","v":0},{"$f":"Metric!H28","v":""},{"$f":"Metric!F28","v":""},{"$f":"Metric!G28","v":""},{"$f":"Metric!I28","v":0},{"$f":"Metric!J28","v":""},{"$f":"Metric!K28","v":""}]
[null,1,{"$f":"Metric!E29","v":0},{"$f":"Metric!H29","v":""},{"$f":"Metric!F29","v":""},{"$f":"Metric!G29","v":""},{"$f":"Metric!I29","v":0},{"$f":"Metric!J29","v":""},{"$f":"Metric!K29","v":""}]
[null,1.2,{"$f":"Metric!E30","v":0},{"$f":"Metric!H30","v":""},{"$f":"Metric!F30","v":""},{"$f":"Metric!G30","v":""},{"$f":"Metric!I30","v":0},{"$f":"Metric!J30","v":""},{"$f":"Metric!K30","v":""}]
[null,1.4,{"$f":"Metric!E31","v":0},{"$f":"Metric!H31","v":""},{"$f":"Metric!F31","v":""},{"$f":"Metric!G31","v":""},{"$f":"Metric!I31","v":0},{"$f":"Metric!J31","v":""},{"$f":"Metric!K31","v":""}]
[null,1.6,{"$f":"Metric!E32","v":0},{"$f":"Metric!H32","v":""},{"$f":"Metric!F32","v":""},{"$f":"Metric!G32","v":""},{"$f":"Metric!I32","v":0},{"$f":"Metric!J32","v":""},{"$f":"Metric!K32","v":""}]
[null,1.8,{"$f":"Metric!E33","v":0},{"$f":"Metric!H33","v":""},{"$f":"Metric!F33","v":""},{"$f":"Metric!G33","v":""},{"$f":"Metric!I33","v":0},{"$f":"Metric!J33","v":""},{"$f":"Metric!K33","v":""}]
[null,2,{"$f":"Metric!E34","v":0},{"$f":"Metric!H34","v":""},{"$f":"Metric!F34","v":""},{"$f":"Metric!G34","v":""},{"$f":"Metric!I34","v":0},{"$f":"Metric!J34","v":""},{"$f":"Metric!K34","v":""}]
[null,2.2000000000000002,{"$f":"Metric!E35","v":0},{"$f":"Metric!H35","v":""},{"$f":"Metric!F35","v":""},{"$f":"Metric!G35","v":""},{"$f":"Metric!I35","v":0},{"$f":"Metric!J35","v":""},{"$f":"Metric!K35","v":""}]
[null,2.4,{"$f":"Metric!E36","v":0},{"$f":"Metric!H36","v":""},{"$f":"Metric!F36","v":""},{"$f":"Metric!G36","v":""},{"$f":"Metric!I36","v":0},{"$f":"Metric!J36","v":""},{"$f":"Metric!K36","v":""}]
[null,2.6,{"$f":"Metric!E37","v":0},{"$f":"Metric!H37","v":""},{"$f":"Metric!F37","v":""},{"$f":"Metric!G37","v":""},{"$f":"Metric!I37","v":0},{"$f":"Metric!J37","v":""},{"$f":"Metric!K37","v":""}]
[null,2.8,{"$f":"Metric!E38","v":0},{"$f":"Metric!H38","v":""},{"$f":"Metric!F38","v":""},{"$f":"Metric!G38","v":""},{"$f":"Metric!I38","v":0},{"$f":"Metric!J38","v":""},{"$f":"Metric!K38","v":""}]
[null,3,{"$f":"Metric!E39","v":0},{"$f":"Metric!H39","v":""},{"$f":"Metric!F39","v":""},{"$f":"Metric!G39","v":""},{"$f":"Metric!I39","v":0},{"$f":"Metric!J39","v":""},{"$f":"Metric!K39","v":""}]
[null,3.2,{"$f":"Metric!E40","v":0},{"$f":"Metric!H40","v":""},{"$f":"Metric!F40","v":""},{"$f":"Metric!G40","v":""},{"$f":"Metric!I40","v":0},{"$f":"Metric!J40","v":""},{"$f":"Metric!K40","v":""}]
[null,3.4,{"$f":"Metric!E41","v":0},{"$f":"Metric!H41","v":""},{"$f":"Metric!F41","v":""},{"$f":"Metric!G41","v":""},{"$f":"Metric!I41","v":0},{"$f":"Metric!J41","v":""},{"$f":"Metric!K41","v":""}]
[null,3.6,{"$f":"Metric!E42","v":0},{"$f":"Metric!H42","v":""},{"$f":"Metric!F42","v":""},{"$f":"Metric!G42","v":""},{"$f":"Metric!I42","v":0},{"$f":"Metric!J42","v":""},{"$f":"Metric!K42","v":""}]
[null,3.8,{"$f":"Metric!E43","v":0},{"$f":"Metric!H43","v":""},{"$f":"Metric!F43","v":""},{"$f":"Metric!G43","v":""},{"$f":"Metric!I43","v":0},{"$f":"Metric!J43","v":""},{"$f":"Metric!K43","v":""}]
[null,4,{"$f":"Metric!E44","v":0},{"$f":"Metric!H44","v":""},{"$f":"Metric!F44","v":""},{"$f":"Metric!G44","v":""},{"$f":"Metric!I44","v":0},{"$f":"Metric!J44","v":""},{"$f":"Metric!K44","v":""}]
[null,4.2,{"$f":"Metric!E45","v":0},{"$f":"Metric!H45","v":""},{"$f":"Metric!F45","v":""},{"$f":"Metric!G45","v":""},{"$f":"Metric!I45","v":0},{"$f":"Metric!J45","v":""},{"$f":"Metric!K45","v":""}]
[null,4.4000000000000004,{"$f":"Metric!E46","v":0},{"$f":"Metric!H46","v":""},{"$f":"Metric!F46","v":""},{"$f":"Metric!G46","v":""},{"$f":"Metric!I46","v":0},{"$f":"Metric!J46","v":""},{"$f":"Metric!K46","v":""}]

{"sheet":"Metric","index":3,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":true,"merged":[[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],[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]]}
[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":40},{"$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":40},{"$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":1.5}]
[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 m³/hr",{"$f":"'Data Entry'!I8","v":0},null,"Cycle timer Length (Seconds)",{"$f":"'Data Entry'!I11","v":0}]
[]
[null,null,"Weight","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.05,9.1356877161264741E-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.1,0.15364334102736293,{"$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.2,0.25839626939502697,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.3,0.35023108012598325,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.4,0.43456899329842258,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,0.5,0.51373747368117539,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,0.6,0.5890161195767516,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,0.7,0.66120674090431564,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,0.8,0.73085501729011793,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,0.9,0.79835421871207313,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1,0.86399999999999999,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1.2,0.99060308695748756,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1.4,1.1120127563360613,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1.6,1.2291467282189035,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,1.8,1.3426664012353249,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,2,1.4530690055584188,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,2.2000000000000002,1.5607406903653487,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,2.4,1.6659891695236297,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,2.6,1.7690648499245059,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,2.8,1.8701750810387927,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,3,1.9694940972089279,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,3.2,2.0671701551602153,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,3.4,2.1633307838262028,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,3.6,2.2580867273607805,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,3.8,2.351534961111382,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,4,2.443761035780708,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,4.2,2.5348409254917859,0,"","","",0,"","",{"$error":"#DIV/0!"},""]
[null,null,4.4000000000000004,2.6248425033376583,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,40,40,0,40,40,40,40,null,0,"8 to 12",12,"20 to 30",30,1.5,null,0,5,5,5,4]
[1,40,40,1,40,40,40,40,null,1,"8 to 12",12,"20 to 30",30,1.5,null,1,5,5,5,4]
[2,"3 to 4","4 to 7",2,3,4,4,7,null,2,"8 to 12",12,"20 to 30",30,1.5,null,2,5,5,5,4]
[3,"3 to 4","4 to 7",3,3,4,4,7,null,3,"8 to 12",12,"20 to 30",30,1.5,null,3,5,5,5,4]
[{"$f":"A6+1","v":4},"3 to 4","4 to 7",4,3,4,4,7,null,4,"8 to 12",12,"20 to 30",30,1.5,null,4,5,5,5,4]
[{"$f":"A7+1","v":5},"3 to 4","4 to 7",5,3,4,4,7,null,5,"8 to 12",12,"20 to 30",30,1.5,null,5,5,5,5,4]
[6,"3 to 4","4 to 7",6,3,4,4,7,null,6,"8 to 12",12,"20 to 30",30,1.5,null,6,10,10,9,8]
[7,"3 to 4","4 to 7",7,3,4,4,7,null,7,"8 to 12",12,"20 to 30",30,1.5,null,7,10,10,9,8]
[8,"3 to 4","4 to 7",8,3,4,4,7,null,8,"8 to 12",12,"20 to 30",30,1.5,null,8,10,10,9,8]
[9,"3 to 4","4 to 7",9,3,4,4,7,null,9,"8 to 12",12,"20 to 30",30,1.5,null,9,10,10,9,8]
[10,"3 to 4","4 to 7",10,3,4,4,7,null,10,"8 to 12",12,"20 to 30",30,1.5,null,10,10,10,9,8]
[11,"3 to 4","4 to 7",11,3,4,4,7,null,11,"8 to 12",12,"20 to 30",30,1.5,null,11,15,15,11,10]
[12,"3 to 4","4 to 7",12,3,4,4,7,null,12,"8 to 12",12,"20 to 30",30,1.5,null,12,15,15,11,10]
[13,"3 to 4","4 to 7",13,3,4,4,7,null,13,"8 to 12",12,"20 to 30",30,1.5,null,13,15,15,11,10]
[14,"3 to 4","4 to 7",14,3,4,4,7,null,14,"8 to 12",12,"20 to 30",30,1.5,null,14,15,15,11,10]
[15,"3 to 4","4 to 7",15,3,4,4,7,null,15,"8 to 12",12,"20 to 30",30,1.5,null,15,15,15,11,10]
[16,"3 to 4","4 to 7",16,3,4,4,7,null,16,"8 to 12",12,"20 to 30",30,1.5,null,16,15,15,11,10]
[17,"3 to 4","4 to 7",17,3,4,4,7,null,17,"8 to 12",12,"20 to 30",30,1.5,null,17,15,15,11,10]
[18,"3 to 4","4 to 7",18,3,4,4,7,null,18,"8 to 12",12,"20 to 30",30,1.5,null,18,15,15,11,10]
[19,"3 to 4","4 to 7",19,3,4,4,7,null,19,"8 to 12",12,"20 to 30",30,1.5,null,19,15,15,11,10]
[20,"3.5 to 5.5","3.5 to 5.5",20,3.5,5.5,3.5,5.5,null,20,"8 to 12",12,"20 to 30",30,1.5,null,20,15,15,11,10]
[21,"3.5 to 5.5","3.5 to 5.5",21,3.5,5.5,3.5,5.5,null,21,"6 to 10",10,"15 to 20",20,2.5,null,21,20,15,13,10]
[22,"3.5 to 5.5","3.5 to 5.5",22,3.5,5.5,3.5,5.5,null,22,"6 to 10",10,"15 to 20",20,2.5,null,22,20,15,13,10]
[23,"3.5 to 5.5","3.5 to 5.5",23,3.5,5.5,3.5,5.5,null,23,"6 to 10",10,"15 to 20",20,2.5,null,23,20,15,13,10]
[24,"3.5 to 5.5","3.5 to 5.5",24,3.5,5.5,3.5,5.5,null,24,"6 to 10",10,"15 to 20",20,2.5,null,24,20,15,13,10]
[25,"3.5 to 5.5","3.5 to 5.5",25,3.5,5.5,3.5,5.5,null,25,"6 to 10",10,"15 to 20",20,2.5,null,25,20,15,13,10]
[26,"3.5 to 5.5","3.5 to 5.5",26,3.5,5.5,3.5,5.5,null,26,"6 to 10",10,"15 to 20",20,2.5,null,26,20,15,13,10]
[27,"3.5 to 5.5","3.5 to 5.5",27,3.5,5.5,3.5,5.5,null,27,"6 to 10",10,"15 to 20",20,2.5,null,27,20,15,13,10]
[28,"3.5 to 5.5","3.5 to 5.5",28,3.5,5.5,3.5,5.5,null,28,"6 to 10",10,"15 to 20",20,2.5,null,28,20,15,13,10]
[29,"3.5 to 5.5","3.5 to 5.5",29,3.5,5.5,3.5,5.5,null,29,"6 to 10",10,"15 to 20",20,2.5,null,29,20,15,13,10]
[30,"3.5 to 5.5","3.5 to 5.5",30,3.5,5.5,3.5,5.5,null,30,"6 to 10",10,"15 to 20",20,2.5,null,30,20,15,13,10]
[31,"3.5 to 5.5","3.5 to 5.5",31,3.5,5.5,3.5,5.5,null,31,"6 to 10",10,"15 to 20",20,2.5,null,31,20,15,13,10]
[32,"3.5 to 5.5","3.5 to 5.5",32,3.5,5.5,3.5,5.5,null,32,"6 to 10",10,"15 to 20",20,2.5,null,32,20,15,13,10]
[33,"3.5 to 5.5","3.5 to 5.5",33,3.5,5.5,3.5,5.5,null,33,"6 to 10",10,"15 to 20",20,2.5,null,33,20,15,13,10]
[34,"3.5 to 5.5","3.5 to 5.5",34,3.5,5.5,3.5,5.5,null,34,"6 to 10",10,"15 to 20",20,2.5,null,34,20,15,13,10]
[35,"3.5 to 5.5","3.5 to 5.5",35,3.5,5.5,3.5,5.5,null,35,"6 to 10",10,"15 to 20",20,2.5,null,35,20,15,13,10]
[36,"3.5 to 5.5","3.5 to 5.5",36,3.5,5.5,3.5,5.5,null,36,"6 to 10",10,"15 to 20",20,2.5,null,36,20,15,13,10]
[37,"3.5 to 5.5","3.5 to 5.5",37,3.5,5.5,3.5,5.5,null,37,"6 to 10",10,"15 to 20",20,2.5,null,37,20,15,13,10]
[38,"3.5 to 5.5","3.5 to 5.5",38,3.5,5.5,3.5,5.5,null,38,"6 to 10",10,"15 to 20",20,2.5,null,38,20,15,13,10]
[39,"3.5 to 5.5","3.5 to 5.5",39,3.5,5.5,3.5,5.5,null,39,"6 to 10",10,"15 to 20",20,2.5,null,39,20,15,13,10]
[40,"3.5 to 5.5","3.5 to 5.5",40,3.5,5.5,3.5,5.5,null,40,"6 to 10",10,"15 to 20",20,2.5,null,40,20,15,13,10]
[41,"3.5 to 5.5","3.5 to 5.5",41,3.5,5.5,3.5,5.5,null,41,"6 to 10",10,"15 to 20",20,2.5,null,41,20,15,13,10]
[42,"3.5 to 5.5","3.5 to 5.5",42,3.5,5.5,3.5,5.5,null,42,"6 to 10",10,"15 to 20",20,2.5,null,42,20,15,13,10]
[43,"3.5 to 5.5","3.5 to 5.5",43,3.5,5.5,3.5,5.5,null,43,"6 to 10",10,"15 to 20",20,2.5,null,43,20,15,13,10]
[44,"3.5 to 5.5","3.5 to 5.5",44,3.5,5.5,3.5,5.5,null,44,"6 to 10",10,"15 to 20",20,2.5,null,44,20,15,13,10]
[45,"3.5 to 5.5","3.5 to 5.5",45,3.5,5.5,3.5,5.5,null,45,"6 to 10",10,"15 to 20",20,2.5,null,45,20,15,13,10]
[46,"3.5 to 5.5","3.5 to 5.5",46,3.5,5.5,3.5,5.5,null,46,"6 to 10",10,"15 to 20",20,2.5,null,46,20,15,13,10]
[47,"3.5 to 5.5","3.5 to 5.5",47,3.5,5.5,3.5,5.5,null,47,"6 to 10",10,"15 to 20",20,2.5,null,47,20,15,13,10]
[48,"3.5 to 5.5","3.5 to 5.5",48,3.5,5.5,3.5,5.5,null,48,"6 to 10",10,"15 to 20",20,2.5,null,48,20,15,13,10]
[49,"3.5 to 5.5","3.5 to 5.5",49,3.5,5.5,3.5,5.5,null,49,"6 to 10",10,"15 to 20",20,2.5,null,49,20,15,13,10]
[50,"3.5 to 5.5","3.5 to 5.5",50,3.5,5.5,3.5,5.5,null,50,"6 to 10",10,"15 to 20",20,2.5,null,50,20,15,13,10]
[51,"3.5 to 5.5","3.5 to 5.5",51,3.5,5.5,3.5,5.5,null,51,"6 to 10",10,"15 to 20",20,2.5,null,51,20,15,13,10]
[52,"3.5 to 5.5","3.5 to 5.5",52,3.5,5.5,3.5,5.5,null,52,"6 to 10",10,"15 to 20",20,2.5,null,52,20,15,13,10]
[53,"3.5 to 5.5","3.5 to 5.5",53,3.5,5.5,3.5,5.5,null,53,"6 to 10",10,"15 to 20",20,2.5,null,53,20,15,13,10]
[54,"3.5 to 5.5","3.5 to 5.5",54,3.5,5.5,3.5,5.5,null,54,"6 to 10",10,"15 to 20",20,2.5,null,54,20,15,13,10]
[55,"3.5 to 5.5","3.5 to 5.5",55,3.5,5.5,3.5,5.5,null,55,"6 to 10",10,"15 to 20",20,2.5,null,55,20,15,13,10]
[56,"3.5 to 5.5","3.5 to 5.5",56,3.5,5.5,3.5,5.5,null,56,"6 to 10",10,"15 to 20",20,2.5,null,56,20,15,13,10]
[57,"3.5 to 5.5","3.5 to 5.5",57,3.5,5.5,3.5,5.5,null,57,"6 to 10",10,"15 to 20",20,2.5,null,57,20,15,13,10]
[58,"3.5 to 5.5","3.5 to 5.5",58,3.5,5.5,3.5,5.5,null,58,"6 to 10",10,"15 to 20",20,2.5,null,58,20,15,13,10]
[59,"3.5 to 5.5","3.5 to 5.5",59,3.5,5.5,3.5,5.5,null,59,"6 to 10",10,"15 to 20",20,2.5,null,59,20,15,13,10]
[60,"3.5 to 5.5","3.5 to 5.5",60,3.5,5.5,3.5,5.5,null,60,"6 to 10",10,"15 to 20",20,2.5,null,60,20,15,13,10]
[61,"3.5 to 5.5","3.5 to 5.5",61,3.5,5.5,3.5,5.5,null,61,"6 to 10",10,"15 to 20",20,2.5,null,61,20,15,13,10]
[62,"3.5 to 5.5","3.5 to 5.5",62,3.5,5.5,3.5,5.5,null,62,"6 to 10",10,"15 to 20",20,2.5,null,62,20,15,13,10]
[63,"3.5 to 5.5","3.5 to 5.5",63,3.5,5.5,3.5,5.5,null,63,"6 to 10",10,"15 to 20",20,2.5,null,63,20,15,13,10]
[64,"3.5 to 5.5","3.5 to 5.5",64,3.5,5.5,3.5,5.5,null,64,"6 to 10",10,"15 to 20",20,2.5,null,64,20,15,13,10]
[65,"3.5 to 5.5","3.5 to 5.5",65,3.5,5.5,3.5,5.5,null,65,"6 to 10",10,"15 to 20",20,2.5,null,65,20,15,13,10]
[66,"3.5 to 5.5","3.5 to 5.5",66,3.5,5.5,3.5,5.5,null,66,"6 to 10",10,"15 to 20",20,2.5,null,66,20,15,13,10]
[67,"3.5 to 5.5","3.5 to 5.5",67,3.5,5.5,3.5,5.5,null,67,"6 to 10",10,"15 to 20",20,2.5,null,67,20,15,13,10]
[68,"3.5 to 5.5","3.5 to 5.5",68,3.5,5.5,3.5,5.5,null,68,"6 to 10",10,"15 to 20",20,2.5,null,68,20,15,13,10]
[{"$f":"A71+1","v":69},"3.5 to 5.5","3.5 to 5.5",69,3.5,5.5,3.5,5.5,null,69,"6 to 10",10,"15 to 20",20,2.5,null,69,20,15,13,10]
[70,"3.5 to 5.5","3.5 to 5.5",70,3.5,5.5,3.5,5.5,null,70,"6 to 10",10,"15 to 20",20,2.5,null,70,20,15,13,10]

{"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}]