{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intro","Cow Herd Efficiency Calculator"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Intro","index":0,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Beef Cow Herd Efficiency Calculator"]
[null,"Xiurui 'Iris' Cui"]
[null,"Area Specialist"]
[null,"Email: xcui10@utk.edu"]
[null,"This Beef Cow Herd Efficiency Calculator was developed to assist Tennessee cow-calf producers in improving cow herd genetics. The calculator will assist producers in identifying the higher-performing and lower-performing cows in the herd. It can also be served as a tool for selecting replacement heifers. "]
[null,"Cow Efficiency is measured by dividing the calf's adjusted 205-day weaning weight over the dam's body weight and multiplying by 100 to get a percentage. The percentage represents the production cost-return ratio of each individual cow. With fixed capital, producers can realize higher gains by increasing the average cow herd efficiency. As average cow herd efficiency improves, it indicates a potential increase of capital return. Body Condition Score (BCS) provides a visual check on the efficiency calculation. The breeding animals need to maintain a body condition score that permits timely rebreeding and satisfactory reproductive performance. To make the most effective selection of breeding animals, producers need to take consideration of both measurements.   "]
[null,"To begin using the calculator, start by inputting calf and dam information. Any cells from column 'Cow ID' to 'Dam Wt.' can be modified by users. The calculator will automatically generate the results shown in cells from column 'Weaning Age' to 'Cow Efficiency' . Formulas are protected and can't be modified. Note that the weights of the calves and the dams and dam Body Condition Score need to be identified at weaning. "]
[null,"Disclaimer: Users of this tool should compare bulls, steers and heifers separately.  'Calf Birth Date' and 'Wean Date' need to be entered correctly for calculating efficiency. "]
[null,"Color of each row shows the level of efficiency. Red indicates the cow has a low efficiency. Orange indicates the cow has a moderate efficiency. Green indicates a high efficiency.  See the reference tables below."]
[]
[]
[]
[]
[null,"Cell color of 'Dam Body Condition Score at Weaning' indicates the level of cow body condition. Red indicates the cow has thin or fat body condition. Orange indicates the cow has borderline body condition. Green indicates an optimum or moderate body condition. See the reference tables below."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sources: 'Guidelines For Uniform Beef Improvement Programs Ninth Edition', Revised March, 2018; Tom Troxel, University of Arkansas, 'Cow Herd Performance Testing';  Agriculture and Horticulture Development Board (AHDB), 'Beef & Lamb Calf-weight-output-per-cow-calculator'. "]
[]
[]
[null,"Programs in agriculture and natural resources, 4-H youth development, family and consumer sciences, and resource development."]
[null,"University of Tennessee Institute of Agriculture, U.S. Department of Agriculture and country governments cooperating."]
[null,"UT Extension provide equal opportunities in programs and employment."]

{"sheet":"Cow Herd Efficiency Calculator","index":1,"n_rows":301,"n_cols":16,"rows_kept":301,"cut":false,"hidden":false,"merged":[[0,12,0,13],[0,0,3,11]]}
["Beef Cow Herd Efficiency Calculator",null,null,null,null,null,null,null,null,null,null,null,"Cow Efficiency (%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"<40","Low"]
[null,null,null,null,null,null,null,null,null,null,null,null,"40-50","Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,">50","High"]
["Cow ID","Calf ID","Cow Age   (Years)","Calf Birth Date","Calf Birth Wt.","Sex","Wean Date","Calf Wean Wt.","Dam Wt.        at        Weaning","Weaning Age (Days)","Age of Dam Adj.","Adj. 205-day Wean Wt.","Avg. Wt. Gain per Day","Cow Efficiency (%)",null,"Dam Body Condition Score at Weaning"]
["Herd Average",null,{"$f":"AVERAGE(C7:C301)","v":3.3333333333333335},null,{"$f":"AVERAGE(E7:E301)","v":75},null,null,{"$f":"AVERAGE(H7:H301)","v":528.33333333333337},1320.3333333333333,214.33333333333334,32,541.15343359316546,2.117821627283734,42.198671275551469,null,{"$f":"AVERAGE(P7:P301)","v":4}]
[631,801,2,"2019-03-15",85,"B","2019-10-15",550,1102,{"$f":"IF(H7=\"\",\"\",IFERROR(DATEDIF(D7,G7,\"D\"),\"\"))","v":214},{"$f":"IF(F7=\"\", \"\", IF(C7=\"\",\"\",IF(AND(C7=2,F7=\"B\"),60,IF(AND(C7=2,F7=\"S\"),60,IF(AND(C7=2,F7=\"H\"),54,IF(AND(C7=3,F7=\"B\"),40,IF(AND(C7=3,F7=\"S\"),40,IF(AND(C7=3,F7=\"H\"),36,IF(AND(C7=4,F7=\"B\"),20,IF(AND(C7=4,F7=\"S\"),20,IF(AND(C7=4,F7=\"H\"),18,IF(AND(C7>=5,C7<=10),0,IF(AND(C7>=11,F7=\"B\"),20,IF(AND(C7>=11,F7=\"S\"),20,18))))))))))))))","v":60},{"$f":"IF(E7=\"\",\"\",IFERROR((((($H7-E7)/$J7)*205)+E7+K7),\"\"))","v":590.4439252336449},{"$f":"IF(H7=\"\",\"\",IFERROR((H7-E7)/(G7-D7),\"\"))","v":2.1728971962616823},{"$f":"IF(I7=\"\",\"\",IFERROR((L7/(I7/100)),\"\"))","v":53.579303560221859},null,5]
[632,802,3,"2019-03-26",70,"H","2019-10-12",500,1320,200,36,546.75,2.15,41.420454545454547,null,4]
[633,804,5,"2019-03-31",70,"S","2019-11-15",535,1539,229,0,486.26637554585159,2.0305676855895198,31.596255720978011,null,3]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H71=\"\",\"\",IFERROR(DATEDIF(D71,G71,\"D\"),\"\"))","v":""},{"$f":"IF(F71=\"\", \"\", IF(C71=\"\",\"\",IF(AND(C71=2,F71=\"B\"),60,IF(AND(C71=2,F71=\"S\"),60,IF(AND(C71=2,F71=\"H\"),54,IF(AND(C71=3,F71=\"B\"),40,IF(AND(C71=3,F71=\"S\"),40,IF(AND(C71=3,F71=\"H\"),36,IF(AND(C71=4,F71=\"B\"),20,IF(AND(C71=4,F71=\"S\"),20,IF(AND(C71=4,F71=\"H\"),18,IF(AND(C71>=5,C71<=10),0,IF(AND(C71>=11,F71=\"B\"),20,IF(AND(C71>=11,F71=\"S\"),20,18))))))))))))))","v":""},{"$f":"IF(E71=\"\",\"\",IFERROR((((($H71-E71)/$J71)*205)+E71+K71),\"\"))","v":""},{"$f":"IF(H71=\"\",\"\",IFERROR((H71-E71)/(G71-D71),\"\"))","v":""},{"$f":"IF(I71=\"\",\"\",IFERROR((L71/(I71/100)),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H135=\"\",\"\",IFERROR(DATEDIF(D135,G135,\"D\"),\"\"))","v":""},{"$f":"IF(F135=\"\", \"\", IF(C135=\"\",\"\",IF(AND(C135=2,F135=\"B\"),60,IF(AND(C135=2,F135=\"S\"),60,IF(AND(C135=2,F135=\"H\"),54,IF(AND(C135=3,F135=\"B\"),40,IF(AND(C135=3,F135=\"S\"),40,IF(AND(C135=3,F135=\"H\"),36,IF(AND(C135=4,F135=\"B\"),20,IF(AND(C135=4,F135=\"S\"),20,IF(AND(C135=4,F135=\"H\"),18,IF(AND(C135>=5,C135<=10),0,IF(AND(C135>=11,F135=\"B\"),20,IF(AND(C135>=11,F135=\"S\"),20,18))))))))))))))","v":""},{"$f":"IF(E135=\"\",\"\",IFERROR((((($H135-E135)/$J135)*205)+E135+K135),\"\"))","v":""},{"$f":"IF(H135=\"\",\"\",IFERROR((H135-E135)/(G135-D135),\"\"))","v":""},{"$f":"IF(I135=\"\",\"\",IFERROR((L135/(I135/100)),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H199=\"\",\"\",IFERROR(DATEDIF(D199,G199,\"D\"),\"\"))","v":""},{"$f":"IF(F199=\"\", \"\", IF(C199=\"\",\"\",IF(AND(C199=2,F199=\"B\"),60,IF(AND(C199=2,F199=\"S\"),60,IF(AND(C199=2,F199=\"H\"),54,IF(AND(C199=3,F199=\"B\"),40,IF(AND(C199=3,F199=\"S\"),40,IF(AND(C199=3,F199=\"H\"),36,IF(AND(C199=4,F199=\"B\"),20,IF(AND(C199=4,F199=\"S\"),20,IF(AND(C199=4,F199=\"H\"),18,IF(AND(C199>=5,C199<=10),0,IF(AND(C199>=11,F199=\"B\"),20,IF(AND(C199>=11,F199=\"S\"),20,18))))))))))))))","v":""},{"$f":"IF(E199=\"\",\"\",IFERROR((((($H199-E199)/$J199)*205)+E199+K199),\"\"))","v":""},{"$f":"IF(H199=\"\",\"\",IFERROR((H199-E199)/(G199-D199),\"\"))","v":""},{"$f":"IF(I199=\"\",\"\",IFERROR((L199/(I199/100)),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H263=\"\",\"\",IFERROR(DATEDIF(D263,G263,\"D\"),\"\"))","v":""},{"$f":"IF(F263=\"\", \"\", IF(C263=\"\",\"\",IF(AND(C263=2,F263=\"B\"),60,IF(AND(C263=2,F263=\"S\"),60,IF(AND(C263=2,F263=\"H\"),54,IF(AND(C263=3,F263=\"B\"),40,IF(AND(C263=3,F263=\"S\"),40,IF(AND(C263=3,F263=\"H\"),36,IF(AND(C263=4,F263=\"B\"),20,IF(AND(C263=4,F263=\"S\"),20,IF(AND(C263=4,F263=\"H\"),18,IF(AND(C263>=5,C263<=10),0,IF(AND(C263>=11,F263=\"B\"),20,IF(AND(C263>=11,F263=\"S\"),20,18))))))))))))))","v":""},{"$f":"IF(E263=\"\",\"\",IFERROR((((($H263-E263)/$J263)*205)+E263+K263),\"\"))","v":""},{"$f":"IF(H263=\"\",\"\",IFERROR((H263-E263)/(G263-D263),\"\"))","v":""},{"$f":"IF(I263=\"\",\"\",IFERROR((L263/(I263/100)),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","",""]