{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data Entry","House Set Up - Adjustable","House Set Up - Fixed","Pick list","Standards","statistical calculations","Help"],"not_rendered":{"charts":0,"images":2,"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":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,10,16,10],[21,6,21,10],[3,9,4,9],[15,6,16,6],[15,7,16,7],[15,9,16,9]]}
[]
[null,"House Details",null,null,null,null,"Bird Details",null,null,null,null,"Equipment"]
[]
[null,"House Length (ft)",null,null,"House Area (ft2)",null,"Sex",null,null,"Stocking Density (ft2/bird)",null,"Feeder Type"]
[null,"House width (ft)",null,null,{"$f":"IF(C4=\"\",\"\",C4*C5)","v":""},null,"Age (w)"]
[null,"Number of pens",null,null,{"$f":"IF(H14=\"3-way Grade\",IF(C6<3,\"Error 3 pens required\",\"\"),\"\")","v":""},null,"Number of birds",null,null,{"$f":"IF(H6=\"\",\"\",E5/H6)","v":""}]
[null,"Fixed or adjustable pens",null,null,null,null,"Sample wt (lb)",null,null,"Target",null,"Drinker Type"]
[null,null,null,null,null,null,"Sample %CV",null,null,{"$f":"IF(H4=\"\",\"\",IF(H4=\"Female\",\"1.5 - 2.7 ft2 / bird\",\"2.7 - 3.6 ft2 / bird\"))","v":""}]
[null,null,null,null,{"$f":"IF(C7=\"Fixed\",\"Pen Area (ft2)\",\"\")","v":""}]
[null,{"$f":"IF(C$7=\"Fixed\",\"Pen 1 Length (ft)\",\"\")","v":""},null,null,{"$f":"IF(B10=\"\",\"\",C10*C$5)","v":""},null,"Or enter:"]
[null,{"$f":"IF(C$7=\"Fixed\",\"Pen 2 Length (ft)\",\"\")","v":""},null,null,{"$f":"IF(B11=\"\",\"\",C11*C$5)","v":""},null,"Uniformity (10%)"]
[null,{"$f":"IF(C$7=\"Fixed\",IF(C$6>2,\"Pen 3 Length (ft)\",\"\"),\"\")","v":""},null,null,""]
[null,{"$f":"IF(C$7=\"Fixed\",IF(C$6>3,\"Pen 4 Length (ft)\",\"\"),\"\")","v":""},null,null,""]
[null,{"$f":"IF(C$7=\"Fixed\",IF(C$6>4,\"Pen 5 Length (ft)\",\"\"),\"\")","v":""},null,null,"",null,"Grading Requirement",{"$f":"IFERROR(IF(H11=\"\",(IF('statistical calculations'!C4<10,\"No Grade\",IF('statistical calculations'!C4<12,\"2-way Grade\",IF('statistical calculations'!C4>17,\"Check Data\",\"3-way Grade\")))),(IF(H11>80,\"No Grade\",(IF(H11<65,\"3-way Grade\",\"2-way Grade\"))))),\"\")","v":""}]
[null,{"$f":"IF(C$7=\"Fixed\",IF(C$6>5,\"Pen 6 Length (ft)\",\"\"),\"\")","v":""},null,null,""]
[null,{"$f":"IF(C$7=\"Fixed\",IF(C$6>6,\"Pen 7 Length (ft)\",\"\"),\"\")","v":""},null,null,"",null,"Ideal Grading Population","%",null,"Number of birds","Minimum Pen Area (ft2) 1"]
[null,{"$f":"IF(C$7=\"Fixed\",IF(C$6>7,\"Pen 8 Length (ft)\",\"\"),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,"Light",{"$f":"IFERROR(IF($H$11=\"\",(IF($H$8<10,\"\",IF($H$8<12,20,IF($H$8<14,24,29)))),(IF($H$11>80,\"\",IF($H$11<65,(100-$H$11)/2,(100-$H$11)/2)))),\"\")","v":""},null,{"$f":"IF(H18=\"\",\"\",$H$6*(H18/100))","v":""},{"$f":"IF(H18=\"\",\"\",J18*1.54)","v":""}]
[null,{"$f":"IF(C$7=\"Fixed\",\"Total\",\"\")","v":""},{"$f":"IF(C10=\"\",\"\",SUM(C10:C17))","v":""},null,{"$f":"IF(E10=\"\",\"\",SUM(E10:E17))","v":""},null,"Normal",{"$f":"IFERROR(IF($H$11=\"\",(IF($H$8<10,\"\",IF($H$8<12,80,IF($H$8<14,70,58)))),(IF($H$11>80,\"\",IF($H$11<65,$H$11,($H$11+((100-H11)/2)))))),\"\")","v":""},null,{"$f":"IF(H19=\"\",\"\",$H$6*(H19/100))","v":""},{"$f":"IF(H19=\"\",\"\",J19*1.54)","v":""}]
[null,null,null,null,null,null,"Heavy",{"$f":"IFERROR(IF($H$11=\"\",(IF($H$8<10,\"\",IF($H$8<12,\"\",IF($H$8<14,6,13)))),(IF($H$11>80,\"\",IF($H$11<65,(100-$H$11)/2,\"\")))),\"\")","v":""},null,{"$f":"IF(H20=\"\",\"\",$H$6*(H20/100))","v":""},{"$f":"IF(H20=\"\",\"\",J20*1.54)","v":""}]
[]
[null,null,null,null,null,null,"1. Minimum pen area based on 1.54 ft2 / bird.  The actual number of birds for each pen will also be determined by the number of feeders and drinkers - see house set up sheet."]

{"sheet":"House Set Up - Adjustable","index":1,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,5,14,6],[2,11,2,13],[2,8,2,10]]}
[]
[null,"Pen Type:",{"$f":"'Data Entry'!C7","v":0},null,"Grading Type",{"$f":"'Data Entry'!H14","v":""}]
[null,null,null,null,null,null,null,null,"Feeders Required",null,null,"Drinkers Required"]
[null,null,"Weight Allocation","Pen Floor Area (ft2)","Pen Length (ft)","Number of Birds","% of Birds","Stocking Density (ft2 / bird)",{"$f":"CONCATENATE(\"Track length (ft) required at \",'Data Entry'!H5,\"w \",\"at \",'Pick list'!C18,\" in/b\")","v":"Track length (ft) required at w at 2 in/b"},{"$f":"CONCATENATE(\"Track length (ft) required at 20w at \",'Pick list'!C27,\" in/b\")","v":"Track length (ft) required at 20w at 6 in/b"},"Pans","Nipples","Cups","Bells"]
[null,{"$f":"IF(C$2=\"Adjustable\",\"Pen 1\",\"\")","v":""},{"$f":"IF(B5=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,3),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,3)))","v":""},{"$f":"IF($B5=\"\",\"\",(VLOOKUP($C5,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C5)))","v":""},{"$f":"IF(B5=\"\",\"\",D5/'Data Entry'!$C$5)","v":""},{"$f":"IF($B5=\"\",\"\",(VLOOKUP($C5,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C5)))","v":""},{"$f":"IF(B5=\"\",\"\",(F5/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B5=\"\",\"\",D5/F5)","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F5=\"\",\"\",(ROUNDUP($F5*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F5=\"\",\"\",(ROUNDUP($F5*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F5=\"\",\"\",(ROUNDUP((F5/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F5=\"\",\"\",(ROUNDUP((F5/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F5=\"\",\"\",(ROUNDUP((F5/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F5=\"\",\"\",(ROUNDUP((F5/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF(C$2=\"Adjustable\",\"Pen 2\",\"\")","v":""},{"$f":"IF(B6=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,4),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,4)))","v":""},{"$f":"IF($B6=\"\",\"\",(VLOOKUP($C6,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C6)))","v":""},{"$f":"IF(B6=\"\",\"\",D6/'Data Entry'!$C$5)","v":""},{"$f":"IF($B6=\"\",\"\",(VLOOKUP($C6,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C6)))","v":""},{"$f":"IF(B6=\"\",\"\",(F6/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B6=\"\",\"\",D6/F6)","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F6=\"\",\"\",(ROUNDUP($F6*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F6=\"\",\"\",(ROUNDUP($F6*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F6=\"\",\"\",(ROUNDUP((F6/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F6=\"\",\"\",(ROUNDUP((F6/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F6=\"\",\"\",(ROUNDUP((F6/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F6=\"\",\"\",(ROUNDUP((F6/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF(C$2=\"Adjustable\",IF('Data Entry'!C$6>2,\"Pen 3\",\"\"),\"\")","v":""},{"$f":"IF(B7=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,5),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,5)))","v":""},{"$f":"IF($B7=\"\",\"\",(VLOOKUP($C7,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C7)))","v":""},{"$f":"IF(B7=\"\",\"\",D7/'Data Entry'!$C$5)","v":""},{"$f":"IF($B7=\"\",\"\",(VLOOKUP($C7,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C7)))","v":""},{"$f":"IF(B7=\"\",\"\",(F7/'Data Entry'!$H$6)*100)","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F7=\"\",\"\",(ROUNDUP($F7*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F7=\"\",\"\",(ROUNDUP($F7*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F7=\"\",\"\",(ROUNDUP((F7/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F7=\"\",\"\",(ROUNDUP((F7/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F7=\"\",\"\",(ROUNDUP((F7/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F7=\"\",\"\",(ROUNDUP((F7/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF(C$2=\"Adjustable\",IF('Data Entry'!C$6>3,\"Pen 4\",\"\"),\"\")","v":""},{"$f":"IF(B8=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,6),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,6)))","v":""},{"$f":"IF($B8=\"\",\"\",(VLOOKUP($C8,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C8)))","v":""},{"$f":"IF(B8=\"\",\"\",D8/'Data Entry'!$C$5)","v":""},{"$f":"IF($B8=\"\",\"\",(VLOOKUP($C8,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C8)))","v":""},{"$f":"IF(B8=\"\",\"\",(F8/'Data Entry'!$H$6)*100)","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F8=\"\",\"\",(ROUNDUP($F8*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F8=\"\",\"\",(ROUNDUP($F8*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F8=\"\",\"\",(ROUNDUP((F8/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F8=\"\",\"\",(ROUNDUP((F8/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F8=\"\",\"\",(ROUNDUP((F8/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F8=\"\",\"\",(ROUNDUP((F8/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF(C$2=\"Adjustable\",IF('Data Entry'!C$6>4,\"Pen 5\",\"\"),\"\")","v":""},{"$f":"IF(B9=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,7),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,7)))","v":""},{"$f":"IF($B9=\"\",\"\",(VLOOKUP($C9,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C9)))","v":""},{"$f":"IF(B9=\"\",\"\",D9/'Data Entry'!$C$5)","v":""},{"$f":"IF($B9=\"\",\"\",(VLOOKUP($C9,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C9)))","v":""},{"$f":"IF(B9=\"\",\"\",(F9/'Data Entry'!$H$6)*100)","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F9=\"\",\"\",(ROUNDUP($F9*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F9=\"\",\"\",(ROUNDUP($F9*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F9=\"\",\"\",(ROUNDUP((F9/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F9=\"\",\"\",(ROUNDUP((F9/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F9=\"\",\"\",(ROUNDUP((F9/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F9=\"\",\"\",(ROUNDUP((F9/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF(C$2=\"Adjustable\",IF('Data Entry'!C$6>5,\"Pen 6\",\"\"),\"\")","v":""},{"$f":"IF(B10=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,8),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,8)))","v":""},{"$f":"IF($B10=\"\",\"\",(VLOOKUP($C10,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C10)))","v":""},{"$f":"IF(B10=\"\",\"\",D10/'Data Entry'!$C$5)","v":""},{"$f":"IF($B10=\"\",\"\",(VLOOKUP($C10,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C10)))","v":""},{"$f":"IF(B10=\"\",\"\",(F10/'Data Entry'!$H$6)*100)","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F10=\"\",\"\",(ROUNDUP($F10*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F10=\"\",\"\",(ROUNDUP($F10*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F10=\"\",\"\",(ROUNDUP((F10/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F10=\"\",\"\",(ROUNDUP((F10/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F10=\"\",\"\",(ROUNDUP((F10/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F10=\"\",\"\",(ROUNDUP((F10/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF(C$2=\"Adjustable\",IF('Data Entry'!C$6>6,\"Pen 7\",\"\"),\"\")","v":""},{"$f":"IF(B11=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,9),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,9)))","v":""},{"$f":"IF($B11=\"\",\"\",(VLOOKUP($C11,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C11)))","v":""},{"$f":"IF(B11=\"\",\"\",D11/'Data Entry'!$C$5)","v":""},{"$f":"IF($B11=\"\",\"\",(VLOOKUP($C11,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C11)))","v":""},{"$f":"IF(B11=\"\",\"\",(F11/'Data Entry'!$H$6)*100)","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F11=\"\",\"\",(ROUNDUP($F11*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F11=\"\",\"\",(ROUNDUP($F11*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F11=\"\",\"\",(ROUNDUP((F11/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F11=\"\",\"\",(ROUNDUP((F11/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F11=\"\",\"\",(ROUNDUP((F11/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F11=\"\",\"\",(ROUNDUP((F11/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF(C$2=\"Adjustable\",IF('Data Entry'!C$6>7,\"Pen 8\",\"\"),\"\")","v":""},{"$f":"IF(B12=\"\",\"\",IF($F$2=\"2-way Grade\",VLOOKUP('Data Entry'!C$6,'Pick list'!$K$19:$T$25,10),VLOOKUP('Data Entry'!C$6,'Pick list'!$K$10:$U$16,10)))","v":""},{"$f":"IF($B12=\"\",\"\",(VLOOKUP($C12,'Pick list'!$B$11:$F$13,5))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C12)))","v":""},{"$f":"IF(B12=\"\",\"\",D12/'Data Entry'!$C$5)","v":""},{"$f":"IF($B12=\"\",\"\",(VLOOKUP($C12,'Pick list'!$B$11:$F$13,2))/(COUNTIF('House Set Up - Adjustable'!$C$5:$C$12,$C12)))","v":""},{"$f":"IF(B12=\"\",\"\",(F12/'Data Entry'!$H$6)*100)","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F12=\"\",\"\",(ROUNDUP($F12*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($F12=\"\",\"\",(ROUNDUP($F12*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(F12=\"\",\"\",(ROUNDUP((F12/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(F12=\"\",\"\",(ROUNDUP((F12/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(F12=\"\",\"\",(ROUNDUP((F12/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(F12=\"\",\"\",(ROUNDUP((F12/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B18=\"\",\"\",\"Pen 1\")","v":""},null,null,null,null,{"$f":"IF(B13=\"\",\"\",(F13/'Data Entry'!$H$6)*100)","v":""}]
[]
[null,null,null,null,null,{"$f":"IF(B5=\"\",\"\",\"Cut-off Weights\")","v":""}]
[null,null,null,{"$f":"IF(B5=\"\",\"\",\"Actual % of Birds\")","v":""},{"$f":"IF(B5=\"\",\"\",\"Ideal % of Birds\")","v":""},{"$f":"IF(B5=\"\",\"\",\"Minimum Wt (lb)\")","v":""},{"$f":"IF(B5=\"\",\"\",\"Maximum Wt (lb)\")","v":""}]
[null,null,{"$f":"IF(B5=\"\",\"\",\"Light\")","v":""},{"$f":"IF(B5=\"\",\"\",SUMIF(C$5:F$12,C17,G$5:G$12))","v":""},{"$f":"IF(B5=\"\",\"\",'Data Entry'!H18)","v":""},null,{"$f":"IF(B5=\"\",\"\",'statistical calculations'!E12)","v":""}]
[null,null,{"$f":"IF(B5=\"\",\"\",\"Normal\")","v":""},{"$f":"IF(B6=\"\",\"\",SUMIF(C$5:F$12,C18,G$5:G$12))","v":""},{"$f":"IF(B6=\"\",\"\",'Data Entry'!H19)","v":""},{"$f":"IF(B5=\"\",\"\",'statistical calculations'!E12+0.001)","v":""},{"$f":"IF(B5=\"\",\"\",IF(F2=\"2-way Grade\",\"\",'statistical calculations'!E13-0.001))","v":""}]
[null,null,{"$f":"IF(B5=\"\",\"\",IF('Data Entry'!H20=\"\",\"\",\"Heavy\"))","v":""},{"$f":"IF(C19=\"\",\"\",SUMIF(C$5:F$12,C19,G$5:G$12))","v":""},{"$f":"IF(B7=\"\",\"\",'Data Entry'!H20)","v":""},{"$f":"IF(B5=\"\",\"\",IF(F2=\"2-way Grade\",\"\",'statistical calculations'!E13))","v":""}]

{"sheet":"House Set Up - Fixed","index":2,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,5,14,6],[2,11,2,13],[2,8,2,10]]}
[]
[null,"Pen Type:",{"$f":"'Data Entry'!C7","v":0},null,"Grading Type",{"$f":"'Data Entry'!H14","v":""}]
[null,null,null,null,null,null,null,null,"Feeders Required",null,null,"Drinkers Required"]
[null,null,"Weight Allocation","Pen Floor Area (ft2)","Number of Birds","% of the Total Birds","Ideal % of Birds","Stocking Density (ft2/bird)",{"$f":"CONCATENATE(\"Track length (ft) required at \",'Data Entry'!H5,\"w \",\"at \",'Pick list'!C18,\"in/b\")","v":"Track length (ft) required at w at 2in/b"},{"$f":"CONCATENATE(\"Track length (ft) required at 20w at \",'Pick list'!C27,\"in/b\")","v":"Track length (ft) required at 20w at 6in/b"},"Pans","Nipples","Cups","Bells"]
[null,{"$f":"IF('Data Entry'!B10=\"\",\"\",\"Pen 1\")","v":""},null,{"$f":"IF(B5=\"\",\"\",'Data Entry'!E10)","v":""},{"$f":"IF(B5=\"\",\"\",D5/'Data Entry'!$J$6)","v":""},{"$f":"IF(E5=\"\",\"\",(E5/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B5=\"\",\"\",(VLOOKUP(C5,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C5,'Pick list'!$B$11:$E$13,3))/D5))","v":""},{"$f":"IF(B5=\"\",\"\",D5/E5)","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E5=\"\",\"\",(ROUNDUP($E5*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E5=\"\",\"\",(ROUNDUP($E5*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E5=\"\",\"\",(ROUNDUP((E5/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E5=\"\",\"\",(ROUNDUP((E5/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E5=\"\",\"\",(ROUNDUP((E5/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E5=\"\",\"\",(ROUNDUP((E5/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B11=\"\",\"\",\"Pen 2\")","v":""},null,{"$f":"IF(B6=\"\",\"\",'Data Entry'!E11)","v":""},{"$f":"IF(B6=\"\",\"\",D6/'Data Entry'!$J$6)","v":""},{"$f":"IF(E6=\"\",\"\",(E6/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B6=\"\",\"\",(VLOOKUP(C6,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C6,'Pick list'!$B$11:$E$13,3))/D6))","v":""},{"$f":"IF(B6=\"\",\"\",D6/E6)","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E6=\"\",\"\",(ROUNDUP($E6*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E6=\"\",\"\",(ROUNDUP($E6*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E6=\"\",\"\",(ROUNDUP((E6/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E6=\"\",\"\",(ROUNDUP((E6/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E6=\"\",\"\",(ROUNDUP((E6/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E6=\"\",\"\",(ROUNDUP((E6/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B12=\"\",\"\",\"Pen 3\")","v":""},null,{"$f":"IF(B7=\"\",\"\",'Data Entry'!E12)","v":""},{"$f":"IF(B7=\"\",\"\",D7/'Data Entry'!$J$6)","v":""},{"$f":"IF(E7=\"\",\"\",(E7/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B7=\"\",\"\",(VLOOKUP(C7,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C7,'Pick list'!$B$11:$E$13,3))/D7))","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E7=\"\",\"\",(ROUNDUP($E7*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E7=\"\",\"\",(ROUNDUP($E7*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E7=\"\",\"\",(ROUNDUP((E7/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E7=\"\",\"\",(ROUNDUP((E7/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E7=\"\",\"\",(ROUNDUP((E7/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E7=\"\",\"\",(ROUNDUP((E7/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B13=\"\",\"\",\"Pen 4\")","v":""},null,{"$f":"IF(B8=\"\",\"\",'Data Entry'!E13)","v":""},{"$f":"IF(B8=\"\",\"\",D8/'Data Entry'!$J$6)","v":""},{"$f":"IF(E8=\"\",\"\",(E8/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B8=\"\",\"\",(VLOOKUP(C8,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C8,'Pick list'!$B$11:$E$13,3))/D8))","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E8=\"\",\"\",(ROUNDUP($E8*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E8=\"\",\"\",(ROUNDUP($E8*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E8=\"\",\"\",(ROUNDUP((E8/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E8=\"\",\"\",(ROUNDUP((E8/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E8=\"\",\"\",(ROUNDUP((E8/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E8=\"\",\"\",(ROUNDUP((E8/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B14=\"\",\"\",\"Pen 5\")","v":""},null,{"$f":"IF(B9=\"\",\"\",'Data Entry'!E14)","v":""},{"$f":"IF(B9=\"\",\"\",D9/'Data Entry'!$J$6)","v":""},{"$f":"IF(E9=\"\",\"\",(E9/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B9=\"\",\"\",(VLOOKUP(C9,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C9,'Pick list'!$B$11:$E$13,3))/D9))","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E9=\"\",\"\",(ROUNDUP($E9*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E9=\"\",\"\",(ROUNDUP($E9*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E9=\"\",\"\",(ROUNDUP((E9/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E9=\"\",\"\",(ROUNDUP((E9/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E9=\"\",\"\",(ROUNDUP((E9/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E9=\"\",\"\",(ROUNDUP((E9/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B15=\"\",\"\",\"Pen6\")","v":""},null,{"$f":"IF(B10=\"\",\"\",'Data Entry'!E15)","v":""},{"$f":"IF(B10=\"\",\"\",D10/'Data Entry'!$J$6)","v":""},{"$f":"IF(E10=\"\",\"\",(E10/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B10=\"\",\"\",(VLOOKUP(C10,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C10,'Pick list'!$B$11:$E$13,3))/D10))","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E10=\"\",\"\",(ROUNDUP($E10*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E10=\"\",\"\",(ROUNDUP($E10*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E10=\"\",\"\",(ROUNDUP((E10/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E10=\"\",\"\",(ROUNDUP((E10/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E10=\"\",\"\",(ROUNDUP((E10/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E10=\"\",\"\",(ROUNDUP((E10/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B16=\"\",\"\",\"Pen 7\")","v":""},null,{"$f":"IF(B11=\"\",\"\",'Data Entry'!E16)","v":""},{"$f":"IF(B11=\"\",\"\",D11/'Data Entry'!$J$6)","v":""},{"$f":"IF(E11=\"\",\"\",(E11/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B11=\"\",\"\",(VLOOKUP(C11,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C11,'Pick list'!$B$11:$E$13,3))/D11))","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E11=\"\",\"\",(ROUNDUP($E11*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E11=\"\",\"\",(ROUNDUP($E11*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E11=\"\",\"\",(ROUNDUP((E11/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E11=\"\",\"\",(ROUNDUP((E11/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E11=\"\",\"\",(ROUNDUP((E11/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E11=\"\",\"\",(ROUNDUP((E11/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B17=\"\",\"\",\"Pen 8\")","v":""},null,{"$f":"IF(B12=\"\",\"\",'Data Entry'!E17)","v":""},{"$f":"IF(B12=\"\",\"\",D12/'Data Entry'!$J$6)","v":""},{"$f":"IF(E12=\"\",\"\",(E12/'Data Entry'!$H$6)*100)","v":""},{"$f":"IF(B12=\"\",\"\",(VLOOKUP(C12,'Pick list'!$B$11:$E$13,4))/((VLOOKUP(C12,'Pick list'!$B$11:$E$13,3))/D12))","v":""},"",{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E12=\"\",\"\",(ROUNDUP($E12*('Pick list'!$C$18/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Track\",IF($E12=\"\",\"\",(ROUNDUP($E12*('Pick list'!$C$27/24),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$5=\"Pans\",IF(E12=\"\",\"\",(ROUNDUP((E12/'Pick list'!$C$19),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Nipples\",IF(E12=\"\",\"\",(ROUNDUP((E12/'Pick list'!$C$21),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Cups\",IF(E12=\"\",\"\",(ROUNDUP((E12/'Pick list'!$C$22),0))),\"\")","v":""},{"$f":"IF('Data Entry'!$L$8=\"Bells\",IF(E12=\"\",\"\",(ROUNDUP((E12/'Pick list'!$C$20),0))),\"\")","v":""}]
[null,{"$f":"IF('Data Entry'!B18=\"\",\"\",\"Pen 1\")","v":""},{"$f":"IF(B5=\"\",\"\",IF('Data Entry'!H20=\"\",\"\",IF((COUNTIF('House Set Up - Fixed'!C5:C12,\"Heavy\"))=0,\"Heavy pen not selected\",\"\")))","v":""},null,null,null,{"$f":"IF(E13=\"\",\"\",E13*('Pick list'!$C$18/100))","v":""}]
[]
[null,null,null,null,null,{"$f":"IF(B5=\"\",\"\",\"Cut-off Weights\")","v":""}]
[null,null,null,{"$f":"IF(B5=\"\",\"\",\"Actual % of Birds\")","v":""},{"$f":"IF(B5=\"\",\"\",\"Ideal % of Birds\")","v":""},{"$f":"IF(B5=\"\",\"\",\"Minimum Wt (lb)\")","v":""},{"$f":"IF(B5=\"\",\"\",\"Maximum Wt (lb)\")","v":""}]
[null,null,{"$f":"IF(B5=\"\",\"\",\"Light\")","v":""},{"$f":"IF(B5=\"\",\"\",SUMIF(C$5:F$12,C17,F$5:F$12))","v":""},{"$f":"IF(B5=\"\",\"\",'Data Entry'!H18)","v":""},null,{"$f":"IF(B5=\"\",\"\",'statistical calculations'!E8)","v":""}]
[null,null,{"$f":"IF(B5=\"\",\"\",\"Normal\")","v":""},{"$f":"IF(B6=\"\",\"\",SUMIF(C$5:F$12,C18,F$5:F$12))","v":""},{"$f":"IF(B6=\"\",\"\",'Data Entry'!H19)","v":""},{"$f":"IF(B5=\"\",\"\",'statistical calculations'!E8+0.001)","v":""},{"$f":"IF(B5=\"\",\"\",IF(F2=\"2-way Grade\",\"\",'statistical calculations'!E9-0.001))","v":""}]
[null,null,{"$f":"IF(B5=\"\",\"\",IF('Data Entry'!H20=\"\",\"\",\"Heavy\"))","v":""},{"$f":"IF(B7=\"\",\"\",IF(F2=\"2-way Grade\",\"\",SUMIF(C$5:F$12,C19,F$5:F$12)))","v":""},{"$f":"IF(B7=\"\",\"\",'Data Entry'!H20)","v":""},{"$f":"IF(B5=\"\",\"\",IF(F2=\"2-way Grade\",\"\",'statistical calculations'!E9))","v":""}]

{"sheet":"Pick list","index":3,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Pick Lists"]
[null,"Fixed",2,"Female",2,"Light",null,"Track",null,"Nipples"]
[null,"Adjustable",3,"Male",3,"Normal",null,"Pans",null,"Cups"]
[null,null,4,null,4,"Heavy",null,null,null,"Bells"]
[null,null,5,null,5]
[null,null,6,null,6]
[null,null,7,null,7]
[null,null,8]
[null,null,null,"Fixed",null,"Adj",null,null,null,null,null,null,1,2,3,4,5,6,7,8]
["Calculations",null,"Number of birds","Pen floor area","Ideal %","Pen Floor area",null,null,null,null,2,{"$f":"'Data Entry'!$E$5/'Pick list'!K10","v":{"$error":"#VALUE!"}},"Light","Normal"]
[null,"Heavy",{"$f":"'Data Entry'!J20","v":""},{"$f":"SUMIF('House Set Up - Fixed'!C$5:D$12,B11,'House Set Up - Fixed'!D$5:D$12)","v":0},{"$f":"'Data Entry'!H20","v":""},{"$f":"(E11/100)*'Data Entry'!$E$5","v":{"$error":"#VALUE!"}},null,null,null,null,3,{"$f":"'Data Entry'!$E$5/'Pick list'!K11","v":{"$error":"#VALUE!"}},"Light","Normal","Heavy"]
[null,"Light",{"$f":"'Data Entry'!J18","v":""},{"$f":"SUMIF('House Set Up - Fixed'!C$5:D$12,B12,'House Set Up - Fixed'!D$5:D$12)","v":0},{"$f":"'Data Entry'!H18","v":""},{"$f":"(E12/100)*'Data Entry'!$E$5","v":{"$error":"#VALUE!"}},null,null,null,null,4,{"$f":"'Data Entry'!$E$5/'Pick list'!K12","v":{"$error":"#VALUE!"}},"Light","Normal","Normal","Heavy"]
[null,"Normal",{"$f":"'Data Entry'!J19","v":""},{"$f":"SUMIF('House Set Up - Fixed'!C$5:D$12,B13,'House Set Up - Fixed'!D$5:D$12)","v":0},{"$f":"'Data Entry'!H19","v":""},{"$f":"(E13/100)*'Data Entry'!$E$5","v":{"$error":"#VALUE!"}},null,null,null,null,5,{"$f":"'Data Entry'!$E$5/'Pick list'!K13","v":{"$error":"#VALUE!"}},"Light","Normal","Normal","Normal","Heavy"]
[null,null,null,null,null,null,null,null,null,null,6,{"$f":"'Data Entry'!$E$5/'Pick list'!K14","v":{"$error":"#VALUE!"}},"Light","Light","Normal","Normal","Normal","Heavy"]
[null,null,null,null,null,null,null,null,null,null,7,{"$f":"'Data Entry'!$E$5/'Pick list'!K15","v":{"$error":"#VALUE!"}},"Light","Light","Normal","Normal","Normal","Normal","Heavy"]
["Feeder and Drinkers Required",null,null,null,null,null,null,null,null,null,8,{"$f":"'Data Entry'!$E$5/'Pick list'!K16","v":{"$error":"#VALUE!"}},"Light","Light","Normal","Normal","Normal","Normal","Normal","Heavy"]
[]
[null,"Track / bird",{"$f":"IF('Data Entry'!H5<5,(IF('Data Entry'!$H$4=\"Female\",'Pick list'!C25,'Pick list'!D25)),(IF('Data Entry'!H5<10,(IF('Data Entry'!$H$4=\"Female\",'Pick list'!C26,'Pick list'!D26)),IF('Data Entry'!$H$4=\"Female\",'Pick list'!C27,'Pick list'!D27))))","v":2},null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8]
[null,"Birds / pan",{"$f":"IF('Data Entry'!$H$4=\"Female\",'Pick list'!C28,'Pick list'!D28)","v":11},null,null,null,null,null,null,null,2,{"$f":"'Data Entry'!$E$5/'Pick list'!K19","v":{"$error":"#VALUE!"}},"Light","Normal"]
[null,"Bell drinkers",{"$f":"IF('Data Entry'!$H$4=\"Female\",'Pick list'!C29,'Pick list'!D29)","v":26},null,null,null,null,null,null,null,3,{"$f":"'Data Entry'!$E$5/'Pick list'!K20","v":{"$error":"#VALUE!"}},"Light","Normal","Normal"]
[null,"Nipples",{"$f":"IF('Data Entry'!$H$4=\"Female\",'Pick list'!C30,'Pick list'!D30)","v":12},null,null,null,null,null,null,null,4,{"$f":"'Data Entry'!$E$5/'Pick list'!K21","v":{"$error":"#VALUE!"}},"Light","Normal","Normal","Normal"]
[null,"Cups",{"$f":"IF('Data Entry'!$H$4=\"Female\",'Pick list'!C31,'Pick list'!D31)","v":30},null,null,null,null,null,null,null,5,{"$f":"'Data Entry'!$E$5/'Pick list'!K22","v":{"$error":"#VALUE!"}},"Light","Normal","Normal","Normal","Normal"]
[null,null,null,null,null,null,null,null,null,null,6,{"$f":"'Data Entry'!$E$5/'Pick list'!K23","v":{"$error":"#VALUE!"}},"Light","Light","Normal","Normal","Normal","Normal"]
[null,null,"Female","Male",null,null,null,null,null,null,7,{"$f":"'Data Entry'!$E$5/'Pick list'!K24","v":{"$error":"#VALUE!"}},"Light","Light","Normal","Normal","Normal","Normal","Normal"]
["Track / bird","<5w",2,2,null,null,null,null,null,null,8,{"$f":"'Data Entry'!$E$5/'Pick list'!K25","v":{"$error":"#VALUE!"}},"Light","Light","Normal","Normal","Normal","Normal","Normal","Normal"]
[null,"5 - 10w",4,4]
[null,">10w",6,6]
["Birds / pan",null,10,11]
["Bell drinkers",null,26,26]
["Nipples",null,12,12]
["Cups",null,30,30]

{"sheet":"Standards","index":4,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[]
["Age (w)","Ross 308","Ross 708","Ross PM3","Ross 308AP","Ross 408","Ross 308FF"]
[0,40,40,null,null,null,40]
[1,115,110,null,null,null,115]
[2,215,215,null,null,null,215]
[3,335,310,null,null,null,335]
[4,450,400,null,null,null,450]
[5,560,490,null,null,null,560]
[6,660,580,null,null,null,660]
[7,760,670,null,null,null,760]
[8,860,760,null,null,null,860]
[9,960,850,null,null,null,960]
[10,1060,940,null,null,null,1060]
[11,1160,1030,null,null,null,1160]
[12,1260,1120,null,null,null,1260]
[13,1360,1210,null,null,null,1360]
[14,1460,1300,null,null,null,1460]
[15,1560,1390,null,null,null,1560]
[16,1670,1480,null,null,null,1670]
[17,1790,1585,null,null,null,1790]
[18,1915,1700,null,null,null,1915]
[19,2050,1825,null,null,null,2050]
[20,2195,1960,null,null,null,2195]
[21,2345,2100,null,null,null,2345]
[22,2500,2245,null,null,null,2500]
[23,2660,2395,null,null,null,2660]
[24,2820,2545,null,null,null,2820]
[25,2975,2690,null,null,null,2975]
[26,3120,2825,null,null,null,3120]
[27,3245,2955,null,null,null,3245]
[28,3340,3055,null,null,null,3340]
[29,3395,3145,null,null,null,3395]
[30,3435,3230,null,null,null,3435]
[31,3465,3285,null,null,null,3465]
[32,3490,3330,null,null,null,3490]
[33,3510,3370,null,null,null,3510]
[34,3530,3400,null,null,null,3530]
[35,3550,3430,null,null,null,3550]
[36,3570,3450,null,null,null,3570]
[37,3590,3470,null,null,null,3590]
[38,3610,3485,null,null,null,3610]
[39,3630,3500,null,null,null,3630]
[40,3650,3515,null,null,null,3650]
[41,3670,3530,null,null,null,3670]
[42,3690,3545,null,null,null,3690]
[43,3710,3560,null,null,null,3710]
[44,3730,3575,null,null,null,3730]
[45,3750,3590,null,null,null,3750]
[46,3770,3605,null,null,null,3770]
[47,3790,3620,null,null,null,3790]
[48,3810,3635,null,null,null,3810]
[49,3830,3650,null,null,null,3830]
[50,3850,3665,null,null,null,3850]
[51,3870,3680,null,null,null,3870]
[52,3890,3695,null,null,null,3890]
[53,3910,3710,null,null,null,3910]
[54,3930,3725,null,null,null,3930]
[55,3950,3740,null,null,null,3950]
[56,3970,3755,null,null,null,3970]
[57,3990,3770,null,null,null,3990]
[58,4010,3785,null,null,null,4010]
[59,4030,3800,null,null,null,4030]
[60,4050,3815,null,null,null,4050]
[61,4070,3830,null,null,null,4070]
[62,4090,3845,null,null,null,4090]
[63,4110,3860,null,null,null,4110]
[64,4130,3875,null,null,null,4130]

{"sheet":"statistical calculations","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Mean wt",{"$f":"'Data Entry'!H7","v":0}]
[null,"CV",{"$f":"IF(F4>0,F4,G25)","v":{"$error":"#DIV/0!"}},null,"CV",{"$f":"'Data Entry'!H8","v":0}]
[null,"Sd",{"$f":"C3*(C4/100)","v":{"$error":"#DIV/0!"}},null,"Uniformity",{"$f":"'Data Entry'!H11","v":0}]
[]
[null,null,"%","Function"]
[null,"Light",{"$f":"'House Set Up - Fixed'!D17","v":""},{"$f":"1-(C8/100)","v":{"$error":"#VALUE!"}},{"$f":"C3-(NORMINV(D8,C$3,C$5)-C3)","v":{"$error":"#VALUE!"}},{"$f":"C3-E8","v":{"$error":"#VALUE!"}}]
[null,"Heavy",{"$f":"'House Set Up - Fixed'!D19","v":""},{"$f":"1-(C9/100)","v":{"$error":"#VALUE!"}},{"$f":"NORMINV(D9,C$3,C$5)","v":{"$error":"#VALUE!"}},{"$f":"C3-E9","v":{"$error":"#VALUE!"}}]
[]
[null,null,"%","Function"]
[null,"Light",{"$f":"'House Set Up - Adjustable'!D17","v":""},{"$f":"1-(C12/100)","v":{"$error":"#VALUE!"}},{"$f":"C3-(NORMINV(D12,C$3,C$5)-C3)","v":{"$error":"#VALUE!"}},{"$f":"E12-C3","v":{"$error":"#VALUE!"}}]
[null,"Heavy",{"$f":"'House Set Up - Adjustable'!D19","v":""},{"$f":"1-(C13/100)","v":{"$error":"#VALUE!"}},{"$f":"(NORMINV(D13,C$3,C$5))","v":{"$error":"#VALUE!"}},{"$f":"E13-C3","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Uniformity from CV"]
[null,"% from mean","Stand dev"]
[null,-10,{"$f":"(($C$3*(B18/100))/$C$5)","v":{"$error":"#DIV/0!"}},{"$f":"NORMSDIST(C18)","v":{"$error":"#DIV/0!"}}]
[null,10,{"$f":"(($C$3*(B19/100))/$C$5)","v":{"$error":"#DIV/0!"}},{"$f":"NORMSDIST(C19)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"IF(F4>0,(D19-D18)*100,\"\")","v":""}]
[]
[null,"CV from uniformity"]
[null,"% from mean","% of pop","St Dev",null,"1 SD","CV%"]
[null,-10,{"$f":"0.5-(F5/200)","v":0.5},{"$f":"NORMSINV(C24)","v":0}]
[null,10,{"$f":"0.5+(F5/200)","v":0.5},{"$f":"NORMSINV(C25)","v":0},{"$f":"C3*(B25/100)","v":0},{"$f":"E25/D25","v":{"$error":"#DIV/0!"}},{"$f":"(F25/C3)*100","v":{"$error":"#DIV/0!"}}]

{"sheet":"Help","index":6,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["Grading Calculator Instructions"]
["1.       The spreadsheet has been written in Excel 2010 and may not function correctly in earlier versions of Excel."]
["2.       Macros must be enabled to use this spreadsheet.  Save the spreadsheet to your computer and then when asked enable editing and enable Macros.  Please check with your local IT department if you have any problem running Macros on your computer."]
["3.       White cells are used for data input either by drop down list or actual numerical data entry when required."]
["4.       Enter data in:"]
["a.       Cell C4 – House length in meters"]
["b.      Cell C5 – House width in meters"]
["c.       Cell C6 – Number of pens in house to be graded from drop down list"]
["d.      Cell C7 – Grading pens are adjustable or fixed from drop down list"]
["e.      Cells C10 to C17 -If fixed penning selected in Cell C7 enter pen lengths as indicated"]
["f.        Cell H4 – Sex of birds to be graded, from drop down list"]
["g.       Cell H5 – Age in weeks of birds to be graded"]
["h.      Cell H6 – Number of birds in the house to be graded"]
["i.         Cell H7 – Average bird weight from sample weighing prior to grading"]
["j.        Cell H8 – If grading using CV%, enter sample weighing CV%"]
["k.       Cell H11 - If grading using uniformity, enter sample weighing uniformity"]
["l.         Cells L5 and L8 – Enter drinker and feeder type in house from drop down list."]
["5.       Stocking density and grading requirements are calculated automatically on the data input sheet using the data supplied."]
["6.       If using fixed penning click on the blue “Fixed pens” button which will take you to the grading sheet."]
["7.       If using adjustable penning click on the blue “Adjustable pens” button which will take you to the grading sheet."]
["8.       Fixed Pens button:"]
["a.       Cells C5 to C12 - Enter the weight allocation to be placed in each pen according to grading preference from the drop down list – Light, Normal or Heavy and the number of fixed pens in the house."]
["b.      All other areas of the sheet will be populated automatically from the data supplied in the data entry sheet showing:"]
["                                                               i.      Type of penning"]
["                                                             ii.      Number of pens"]
["                                                            iii.      Pen area"]
["                                                           iv.      Pen length"]
["                                                             v.      Number of birds per pen"]
["                                                           vi.      % of total bird population per pen"]
["                                                          vii.      Stocking density per pen"]
["                                                        viii.      Feeder and drinker requirements per pen"]
["                                                           ix.      Minimum and maximum bird weight per pen."]
["c.       Press the blue “Print Sheet” button and select the printer to be used. This will print the current sheet for use in the house during the grading process."]
["d.      Press the blue “Data Entry” button to return to the data entry sheet."]
["9.       Adjustable Pens button:"]
["a.       All areas of the sheet will be populated automatically from the data supplied in the data entry sheet showing:"]
["                                                               i.      Type of penning"]
["                                                             ii.      Number of pens"]
["                                                            iii.      Weight allocation per pen"]
["                                                           iv.      Pen area"]
["                                                             v.      Pen length"]
["                                                           vi.      Number of birds per pen"]
["                                                          vii.      % of total bird population per pen"]
["                                                        viii.      Stocking density per pen"]
["                                                           ix.      Feeder and drinker requirements per pen"]
["                                                             x.      Minimum and maximum bird weight per pen."]
["b.      Press the blue “Print Sheet” button and select the printer to be used. This will print the current sheet for use in the house during the grading process."]
["c.       Press the blue “Data Entry” button to return to the data entry sheet."]