{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Forage analysis","Supplemental feeds","Nutrient requirements","Lists"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"FORAGE ANALYSIS INTERPRETER"]
[null,null,"Beef Breeding Female Basic Version 1.0"]
[]
[null,null,"Jason Smith"]
[null,null,"Assistant Professor and Extension Beef Cattle Specialist"]
[null,null,"Department of Animal Science"]
[null,null,"University of Tennessee Institute of Agriculture"]
[]
[null,null,"Overview: The purpose of this calculator is to aid in the interpretation of forage analysis results for beef cattle and to simplify supplementation decisions. In order to do so, the calculator automatically applies nutrient requirement information to the forage analysis results and cattle information that has been entered by the user. This specific calculator is intended only for use toward breeding females and is not applicable for use toward bulls or growing and/or finishing cattle.  "]
[]
[null,null,"Precautions and disclaimers: This calculator is intended for use for beef breeding females primarily of British and Continental (Bos taurus) breed influence, and may not be accurate when applied to cattle of substantial (> 25 %) Brahman or Zebu (Bos indicus) breed influence. Additionally, this calculator does not factor in extreme temperature humidity indices, hair coat, pen conditions or any other factors that may affect nutrient requirements. Thus, it is not intended to replace the recommendations of your nutritionist and/or Extension personnel, and is intended to provide an estimate of forage quality and supplementation requirements for breeding females. Finally, this calculator does not take into account the associative effects of some supplemental feedstuffs and their effects on voluntary forage intake and/or nutrient availability to the animal, and thus may over or underestimate voluntary forage intake at high levels of supplementation.   "]
[]
[null,null,"CLICK HERE TO GO TO THE CALCULATOR"]
[]
[null,null,"Instructions: This calculator can be operated by following the proceeding guidelines:"]
[]
[null,null,"Step 1 - Acquire forage analysis results for the forage to be evaluated. This calculator is intended to evaluate a single forage option. The nutrient information relevant to this calculator includes dry matter (DM), ash, crude protein (CP), total digestible nutrients (TDN), and net energy for maintenance (NEM), however, DM, CP and NEm are absolutely necessary for its operation. Enter this information from the forage analysis results into cells C6 through C10. These cells are light gray in color. The value entered for DM will be on an as-fed basis, while all other values (ash, CP, TDN and NEM) must be on a DM-basis. "]
[]
[null,null,"Step 2 - Specify the relevant information for the productive age of the breeding females to which the forage will be fed by selecting the most appropriate option from the drop-down menu in cell C13. Then select the most appropriate option for mature weight from the drop-down menu in cell C14. *Note - this is expected or actual mature weight, which may differ from current weight.  "]
[]
[null,null,"Step 3 - After completing steps 1 and 2, evaluate the values that have been automatically calculated and provided in cells F4 through H20 (orange cells). The section titled Forage intake (forage only) provides the per-head amounts of DM, as-fed (actual forage), CP and NEM that the cattle are expected to voluntarily consume from the forage without supplementation. The section titled Nutrient requirements outlines the average amount of CP and NEM required by the cattle that were previously described. The section titled Nutrient status describes the net amount of each of these consumed nutrients relative to the animal’s requirements. A positive value indicates the amount consumed in excess or surplus of requirements. A negative value indicates the amount of deficiency that remains, and thus must be supplemented in order to meet requirements.   "]
[]
[null,null,"Step 4 - If the forage option results in a CP and/or NEM deficiency, select a supplemental feedstuff option in cell C17 and/or cell C19. This calculator allows for the addition of up to two supplemental feedstuff options, and the cells have been prepopulated with drop-down menus that contain common supplemental feedstuff options linked to their typical nutrient composition, which can be found on the tab titled \"Supplemental feeds.\" While these values cannot be changed, custom entries may be entered on the \"Supplemental feeds\" sheet in cells A43 through D47 (light gray cells). Once this information has been entered, it will automatically appear in the drop-down lists in cells C17 and C19, and will be linked to its respective nutrient values, which will then be available for use by the calculator. Adjust the amounts fed in cells C18 and C20 until there are no longer CP and/or NEM deficiencies. These amounts are the amounts of the respective supplemental feed(s) necessary to correct the deficiencies of the forage relative to the requirements of the cattle that were described.  In order to determine the most economical sources of supplemental protein and/or energy, use the Supplemental Feedstuff Value Calculator W 373, which can be accessed by clicking the appropriate link below.     "]
[]
[null,null,"CLICK HERE TO GO TO THE SUPPLEMENTAL FEEDS SHEET IN ORDER TO ENTER A CUSTOM SUPPLEMENT"]
[]
[null,null,"CLICK HERE TO ACCESS SUPPLEMENTAL FEEDSTUFF VALUE CALCULATOR W373 (requires download)"]
[]
[null,null,"*Note* - Only enter information in the light gray-colored cells. All other cells will either be automatically populated or calculated based upon entry of information in other cells.  The calculator will not allow the user to enter information in other cells. \"INVALID ENTRY\" indicates that information has not been selected or entered in one or more cells that are required for calculation. Clicking on a light  gray-colored cell will prompt an instruction dialog box to appear. In order to make the instruction dialog box disappear after clicking the cell, hit the escape key.  "]

{"sheet":"Forage analysis","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[19,2,19,3],[15,1,15,3],[16,2,16,3],[17,2,17,3],[3,1,3,3],[12,2,12,3],[13,2,13,3],[11,1,11,3],[0,1,0,7],[1,1,1,7],[3,5,3,7],[18,2,18,3],[2,4,2,8],[2,2,2,3]]}
[null,"FORAGE ANALYSIS INTERPRETER"]
[null,"Beef Breeding Female Basic Version 1.0"]
[]
[null,"Forage analysis information",null,null,null,"Forage analysis interpretation"]
[null,"Nutrient","Analysis results","Unit",null,"Forage intake (forage only)","Amount","Unit"]
[null,"     Dry matter (DM)",88,"% as-fed",null,"     Dry matter",{"$f":"C37","v":23.358142960180004},"lbs per day"]
[null,"     Ash",5,"% of DM",null,"     As-fed",{"$f":"G6/(C6/100)","v":26.543344272931822},"lbs per day"]
[null,"     Crude protein (CP)",10.5,"% of DM",null,"     Crude protein",{"$f":"G6*(C8/100)","v":2.4526050108189001},"lbs per day"]
[null,"     Total digestible nutrients (TDN)",64,"% of DM",null,"     Net energy for maintenance",{"$f":"G6*C10","v":14.482048635311603},"Mcal per day"]
[null,"     Net energy for maintenance (NEm)",0.62,"Mcal/lb of DM",null,"Forage + supplement intake","Amount","Unit"]
[null,null,null,null,null,"     Dry matter",{"$f":"G6+C27+C30","v":23.358142960180004},"lbs per day"]
[null,"Cattle information",null,null,null,"     As-fed",{"$f":"G7+C18+C20","v":26.543344272931822},"lbs per day"]
[null,"Productive age","Primiparous cows (First-calf heifers; 1st calving to 2nd calving)",null,null,"     Crude protein",{"$f":"G11*(C35/100)","v":2.4526050108189001},"lbs per day"]
[null,"Mature body weight, lbs",1300,null,null,"     Net energy for maintenance",{"$f":"G11*C34","v":14.482048635311603},"Mcal per day"]
[null,null,null,null,null,"Nutrient requirements","Amount","Unit"]
[null,"Protein and energy supplementation information",null,null,null,"     Crude protein",{"$f":"IF(AND('Forage analysis'!C14=1000,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C3, IF(AND('Forage analysis'!C14=1050,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C4, IF(AND('Forage analysis'!C14=1100,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C5, IF(AND('Forage analysis'!C14=1150,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C6, IF(AND('Forage analysis'!C14=1200,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C7, IF(AND('Forage analysis'!C14=1250,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C8, IF(AND('Forage analysis'!C14=1300,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C9, IF(AND('Forage analysis'!C14=1350,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C10, IF(AND('Forage analysis'!C14=1400,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C11, IF(AND('Forage analysis'!C14=1450,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C12, IF(AND('Forage analysis'!C14=1500,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C13, IF(AND('Forage analysis'!C14=1550,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C14, IF(AND('Forage analysis'!C14=1600,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!C15,IF(AND('Forage analysis'!C14=1000,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C19, IF(AND('Forage analysis'!C14=1050,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C20, IF(AND('Forage analysis'!C14=1100,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C21, IF(AND('Forage analysis'!C14=1150,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C22, IF(AND('Forage analysis'!C14=1200,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C23, IF(AND('Forage analysis'!C14=1250,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C24, IF(AND('Forage analysis'!C14=1300,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C25, IF(AND('Forage analysis'!C14=1350,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C26, IF(AND('Forage analysis'!C14=1400,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C27, IF(AND('Forage analysis'!C14=1450,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C28, IF(AND('Forage analysis'!C14=1500,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C29, IF(AND('Forage analysis'!C14=1550,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C30, IF(AND('Forage analysis'!C14=1600,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!C31,IF(AND('Forage analysis'!C14=1000,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C35, IF(AND('Forage analysis'!C14=1050,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C36, IF(AND('Forage analysis'!C14=1100,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C37, IF(AND('Forage analysis'!C14=1150,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C38, IF(AND('Forage analysis'!C14=1200,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C39, IF(AND('Forage analysis'!C14=1250,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C40, IF(AND('Forage analysis'!C14=1300,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C41, IF(AND('Forage analysis'!C14=1350,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C42, IF(AND('Forage analysis'!C14=1400,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C43, IF(AND('Forage analysis'!C14=1450,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C44, IF(AND('Forage analysis'!C14=1500,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C45, IF(AND('Forage analysis'!C14=1550,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C46, IF(AND('Forage analysis'!C14=1600,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!C47,\"INVALID ENTRY IN CELL A11 AND/OR A12\")))))))))))))))))))))))))))))))))))))))","v":2.4500000000000002},"lbs per day"]
[null,"Supplemental feedstuff","Distiller's grains - dried",null,null,"     Net energy for maintenance",{"$f":"IF(AND('Forage analysis'!C14=1000,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B3, IF(AND('Forage analysis'!C14=1050,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B4, IF(AND('Forage analysis'!C14=1100,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B5, IF(AND('Forage analysis'!C14=1150,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B6, IF(AND('Forage analysis'!C14=1200,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B7, IF(AND('Forage analysis'!C14=1250,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B8, IF(AND('Forage analysis'!C14=1300,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B9, IF(AND('Forage analysis'!C14=1350,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B10, IF(AND('Forage analysis'!C14=1400,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B11, IF(AND('Forage analysis'!C14=1450,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B12, IF(AND('Forage analysis'!C14=1500,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B13, IF(AND('Forage analysis'!C14=1550,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B14, IF(AND('Forage analysis'!C14=1600,'Forage analysis'!C13=\"Replacement heifers (1st breeding to 1st calving)\"),'Nutrient requirements'!B15,IF(AND('Forage analysis'!C14=1000,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B19, IF(AND('Forage analysis'!C14=1050,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B20, IF(AND('Forage analysis'!C14=1100,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B21, IF(AND('Forage analysis'!C14=1150,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B22, IF(AND('Forage analysis'!C14=1200,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B23, IF(AND('Forage analysis'!C14=1250,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B24, IF(AND('Forage analysis'!C14=1300,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B25, IF(AND('Forage analysis'!C14=1350,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B26, IF(AND('Forage analysis'!C14=1400,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B27, IF(AND('Forage analysis'!C14=1450,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B28, IF(AND('Forage analysis'!C14=1500,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B29, IF(AND('Forage analysis'!C14=1550,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B30, IF(AND('Forage analysis'!C14=1600,'Forage analysis'!C13=\"Primiparous cows (First-calf heifers; 1st calving to 2nd calving)\"),'Nutrient requirements'!B31,IF(AND('Forage analysis'!C14=1000,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B35, IF(AND('Forage analysis'!C14=1050,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B36, IF(AND('Forage analysis'!C14=1100,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B37, IF(AND('Forage analysis'!C14=1150,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B38, IF(AND('Forage analysis'!C14=1200,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B39, IF(AND('Forage analysis'!C14=1250,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B40, IF(AND('Forage analysis'!C14=1300,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B41, IF(AND('Forage analysis'!C14=1350,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B42, IF(AND('Forage analysis'!C14=1400,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B43, IF(AND('Forage analysis'!C14=1450,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B44, IF(AND('Forage analysis'!C14=1500,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B45, IF(AND('Forage analysis'!C14=1550,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B46, IF(AND('Forage analysis'!C14=1600,'Forage analysis'!C13=\"Multiparous cows (Mature cows; 2nd calving and beyond)\"),'Nutrient requirements'!B47,\"INVALID ENTRY IN CELL A11 AND/OR A12\")))))))))))))))))))))))))))))))))))))))","v":14.4},"Mcal per day"]
[null,"     Amount fed, lbs (as-fed) per head per day",0,null,null,"Nutrient status","Amount","Unit"]
[null,"Additional supplemental feedstuff","Corn - cracked, ground, or whole shelled",null,null,"     Crude protein",{"$f":"G13-G16","v":2.6050108188999666E-3},"lbs per day"]
[null,"     Amount fed, lbs (as-fed) per head per day",0,null,null,"     Net energy for maintenance",{"$f":"G14-G17","v":8.204863531160278E-2},"Mcal per day"]
[]
[]
[]
[null,"DM from forage",{"$f":"-12.18150501+(0.0130822802*'Forage analysis'!C14)+(29.891425339*'Forage analysis'!C10)+(('Forage analysis'!C14-1300)*(('Forage analysis'!C10-0.575)*0.0177509373))","v":23.358142960180004}]
[null,"NEm content of forage, Mcal/lb of DM",{"$f":"C10","v":0.62}]
[null,"CP content of forage, % of DM",{"$f":"C8","v":10.5}]
[null,"DM from primary supplemental feed",{"$f":"IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17=\"No supplement\",0, IF('Forage analysis'!C17=\"Barley - whole grain\",('Supplemental feeds'!B5/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Brewer's grains - dried\",('Supplemental feeds'!B6/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Brewer's grains - wet\",('Supplemental feeds'!B7/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Commodity blend feed - 12 % pellet (generic formulation)\",('Supplemental feeds'!B8/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Commodity blend feed - 14 % pellet (generic formulation)\",('Supplemental feeds'!B9/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Commodity blend feed - 16 % pellet (generic formulation)\",('Supplemental feeds'!B10/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn - cracked, ground, or whole shelled\",('Supplemental feeds'!B11/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn cob meal\",('Supplemental feeds'!B12/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn - earlage (~63 % dry matter)\",('Supplemental feeds'!B13/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn - ground whole ear\",('Supplemental feeds'!B14/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn - high-moisture (~70 % dry matter)\",('Supplemental feeds'!B15/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn - snaplage (~60 % dry matter)\",('Supplemental feeds'!B16/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn - steam-flaked (~80 % dry matter)\",('Supplemental feeds'!B17/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn gluten feed - dried\",('Supplemental feeds'!B18/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Corn gluten feed - wet (~45 % dry matter)\",('Supplemental feeds'!B19/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Cottonseed hulls\",('Supplemental feeds'!B20/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Cottonseed meal\",('Supplemental feeds'!B21/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Cottonseed - whole\",('Supplemental feeds'!B22/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Distiller's grains - dried\",('Supplemental feeds'!B23/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Distiller's grains - modified (~50 % dry matter)\",('Supplemental feeds'!B24/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Distiller's grains - wet (~30 % dry matter)\",('Supplemental feeds'!B25/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Liquid feed - 16 % (generic formulation)\",('Supplemental feeds'!B26/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Liquid feed - 24 % (generic formulation)\",('Supplemental feeds'!B27/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Liquid feed - 32 % (generic formulation)\",('Supplemental feeds'!B28/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Oats - whole grain\",('Supplemental feeds'!B29/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Peanut hulls\",('Supplemental feeds'!B30/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Protein tub - 25 % cooked (generic formulation)\",('Supplemental feeds'!B31/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Protein tub - 30 % cooked (generic formulation)\",('Supplemental feeds'!B32/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Protein tub - 35 % cooked (generic formulation)\",('Supplemental feeds'!B33/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Sorghum - high-moisture (~70 % dry matter)\",('Supplemental feeds'!B34/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Sorghum - steam-flaked (~80 % dry matter)\",('Supplemental feeds'!B35/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Sorghum - whole grain\",('Supplemental feeds'!B36/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Soybean hulls\",('Supplemental feeds'!B37/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Soybean meal\",('Supplemental feeds'!B38/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Soybeans - whole roasted\",('Supplemental feeds'!B39/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Wheat middlings\",('Supplemental feeds'!B40/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"Wheat - whole grain\",('Supplemental feeds'!B41/100)*'Forage analysis'!C18, IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17='Supplemental feeds'!A43,('Supplemental feeds'!B43/100)*'Forage analysis'!C18, IF('Forage analysis'!C17='Supplemental feeds'!A44,('Supplemental feeds'!B44/100)*'Forage analysis'!C18, IF('Forage analysis'!C17='Supplemental feeds'!A45,('Supplemental feeds'!B45/100)*'Forage analysis'!C18, IF('Forage analysis'!C17='Supplemental feeds'!A46,('Supplemental feeds'!B46/100)*'Forage analysis'!C18, IF('Forage analysis'!C17='Supplemental feeds'!A47,('Supplemental feeds'!B47/100)*'Forage analysis'!C18,\"INVALID ENTRY IN CELL C15 AND/OR C16\")))))))))))))))))))))))))))))))))))))))))))))","v":0}]
[null,"NEm content of primary supplemental feed, Mcal/lb of DM",{"$f":"IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17=\"No supplement\",0, IF('Forage analysis'!C17=\"Barley - whole grain\",('Supplemental feeds'!D5/('Supplemental feeds'!B5/100)), IF('Forage analysis'!C17=\"Brewer's grains - dried\",('Supplemental feeds'!D6/('Supplemental feeds'!B6/100)), IF('Forage analysis'!C17=\"Brewer's grains - wet\",('Supplemental feeds'!D7/('Supplemental feeds'!B7/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 12 % pellet (generic formulation)\",('Supplemental feeds'!D8/('Supplemental feeds'!B8/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 14 % pellet (generic formulation)\",('Supplemental feeds'!D9/('Supplemental feeds'!B9/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 16 % pellet (generic formulation)\",('Supplemental feeds'!D10/('Supplemental feeds'!B10/100)), IF('Forage analysis'!C17=\"Corn - cracked, ground, or whole shelled\",('Supplemental feeds'!D11/('Supplemental feeds'!B11/100)), IF('Forage analysis'!C17=\"Corn cob meal\",('Supplemental feeds'!D12/('Supplemental feeds'!B12/100)), IF('Forage analysis'!C17=\"Corn - earlage (~63 % dry matter)\", ('Supplemental feeds'!D13/('Supplemental feeds'!B13/100)), IF('Forage analysis'!C17=\"Corn - ground whole ear\",('Supplemental feeds'!D14/('Supplemental feeds'!B14/100)), IF('Forage analysis'!C17=\"Corn - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!D15/('Supplemental feeds'!B15/100)), IF('Forage analysis'!C17=\"Corn - snaplage (~60 % dry matter)\", ('Supplemental feeds'!D16/('Supplemental feeds'!B16/100)), IF('Forage analysis'!C17=\"Corn - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!D17/('Supplemental feeds'!B17/100)), IF('Forage analysis'!C17=\"Corn gluten feed - dried\",('Supplemental feeds'!D18/('Supplemental feeds'!B18/100)), IF('Forage analysis'!C17=\"Corn gluten feed - wet (~45 % dry matter)\", ('Supplemental feeds'!D19/('Supplemental feeds'!B19/100)), IF('Forage analysis'!C17=\"Cottonseed hulls\",('Supplemental feeds'!D20/('Supplemental feeds'!B20/100)), IF('Forage analysis'!C17=\"Cottonseed meal\",('Supplemental feeds'!D21/('Supplemental feeds'!B21/100)), IF('Forage analysis'!C17=\"Cottonseed - whole\",('Supplemental feeds'!D22/('Supplemental feeds'!B22/100)), IF('Forage analysis'!C17=\"Distiller's grains - dried\",('Supplemental feeds'!D23/('Supplemental feeds'!B23/100)), IF('Forage analysis'!C17=\"Distiller's grains - modified (~50 % dry matter)\", ('Supplemental feeds'!D24/('Supplemental feeds'!B24/100)), IF('Forage analysis'!C17=\"Distiller's grains - wet (~30 % dry matter)\", ('Supplemental feeds'!D25/('Supplemental feeds'!B25/100)), IF('Forage analysis'!C17=\"Liquid feed - 16 % (generic formulation)\", ('Supplemental feeds'!D26/('Supplemental feeds'!B26/100)), IF('Forage analysis'!C17=\"Liquid feed - 24 % (generic formulation)\", ('Supplemental feeds'!D27/('Supplemental feeds'!B27/100)), IF('Forage analysis'!C17=\"Liquid feed - 32 % (generic formulation)\", ('Supplemental feeds'!D28/('Supplemental feeds'!B28/100)), IF('Forage analysis'!C17=\"Oats - whole grain\",('Supplemental feeds'!D29/('Supplemental feeds'!B29/100)), IF('Forage analysis'!C17=\"Peanut hulls\",('Supplemental feeds'!D30/('Supplemental feeds'!B30/100)), IF('Forage analysis'!C17=\"Protein tub - 25 % cooked (generic formulation)\", ('Supplemental feeds'!D31/('Supplemental feeds'!B31/100)), IF('Forage analysis'!C17=\"Protein tub - 30 % cooked (generic formulation)\", ('Supplemental feeds'!D32/('Supplemental feeds'!B32/100)), IF('Forage analysis'!C17=\"Protein tub - 35 % cooked (generic formulation)\", ('Supplemental feeds'!D33/('Supplemental feeds'!B33/100)), IF('Forage analysis'!C17=\"Sorghum - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!D34/('Supplemental feeds'!B34/100)), IF('Forage analysis'!C17=\"Sorghum - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!D35/('Supplemental feeds'!B35/100)), IF('Forage analysis'!C17=\"Sorghum - whole grain\",('Supplemental feeds'!D36/('Supplemental feeds'!B36/100)), IF('Forage analysis'!C17=\"Soybean hulls\",('Supplemental feeds'!D37/('Supplemental feeds'!B37/100)), IF('Forage analysis'!C17=\"Soybean meal\",('Supplemental feeds'!D38/('Supplemental feeds'!B38/100)), IF('Forage analysis'!C17=\"Soybeans - whole roasted\",('Supplemental feeds'!D39/('Supplemental feeds'!B39/100)), IF('Forage analysis'!C17=\"Wheat middlings\",('Supplemental feeds'!D40/('Supplemental feeds'!B40/100)), IF('Forage analysis'!C17=\"Wheat - whole grain\",('Supplemental feeds'!D41/('Supplemental feeds'!B41/100)), IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17='Supplemental feeds'!A43,('Supplemental feeds'!D43/('Supplemental feeds'!B43/100)), IF('Forage analysis'!C17='Supplemental feeds'!A44,('Supplemental feeds'!D44/('Supplemental feeds'!B44/100)), IF('Forage analysis'!C17='Supplemental feeds'!A45,('Supplemental feeds'!D45/('Supplemental feeds'!B45/100)), IF('Forage analysis'!C17='Supplemental feeds'!A46,('Supplemental feeds'!D46/('Supplemental feeds'!B46/100)), IF('Forage analysis'!C17='Supplemental feeds'!A47,('Supplemental feeds'!D47/('Supplemental feeds'!B47/100)),\"INVALID ENTRY IN CELL C15 AND/OR C16\")))))))))))))))))))))))))))))))))))))))))))))","v":1}]
[null,"CP content of primary supplemental feed, % of DM",{"$f":"IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17=\"No supplement\",0, IF('Forage analysis'!C17=\"Barley - whole grain\",('Supplemental feeds'!C5/('Supplemental feeds'!B5/100)), IF('Forage analysis'!C17=\"Brewer's grains - dried\",('Supplemental feeds'!C6/('Supplemental feeds'!B6/100)), IF('Forage analysis'!C17=\"Brewer's grains - wet\",('Supplemental feeds'!C7/('Supplemental feeds'!B7/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 12 % pellet (generic formulation)\",('Supplemental feeds'!C8/('Supplemental feeds'!B8/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 14 % pellet (generic formulation)\",('Supplemental feeds'!C9/('Supplemental feeds'!B9/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 16 % pellet (generic formulation)\",('Supplemental feeds'!C10/('Supplemental feeds'!B10/100)), IF('Forage analysis'!C17=\"Corn - cracked, ground, or whole shelled\",('Supplemental feeds'!C11/('Supplemental feeds'!B11/100)), IF('Forage analysis'!C17=\"Corn cob meal\",('Supplemental feeds'!C12/('Supplemental feeds'!B12/100)), IF('Forage analysis'!C17=\"Corn - earlage (~63 % dry matter)\", ('Supplemental feeds'!C13/('Supplemental feeds'!B13/100)), IF('Forage analysis'!C17=\"Corn - ground whole ear\",('Supplemental feeds'!C14/('Supplemental feeds'!B14/100)), IF('Forage analysis'!C17=\"Corn - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!C15/('Supplemental feeds'!B15/100)), IF('Forage analysis'!C17=\"Corn - snaplage (~60 % dry matter)\", ('Supplemental feeds'!C16/('Supplemental feeds'!B16/100)), IF('Forage analysis'!C17=\"Corn - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!C17/('Supplemental feeds'!B17/100)), IF('Forage analysis'!C17=\"Corn gluten feed - dried\",('Supplemental feeds'!C18/('Supplemental feeds'!B18/100)), IF('Forage analysis'!C17=\"Corn gluten feed - wet (~45 % dry matter)\", ('Supplemental feeds'!C19/('Supplemental feeds'!B19/100)), IF('Forage analysis'!C17=\"Cottonseed hulls\",('Supplemental feeds'!C20/('Supplemental feeds'!B20/100)), IF('Forage analysis'!C17=\"Cottonseed meal\",('Supplemental feeds'!C21/('Supplemental feeds'!B21/100)), IF('Forage analysis'!C17=\"Cottonseed - whole\",('Supplemental feeds'!C22/('Supplemental feeds'!B22/100)), IF('Forage analysis'!C17=\"Distiller's grains - dried\",('Supplemental feeds'!C23/('Supplemental feeds'!B23/100)), IF('Forage analysis'!C17=\"Distiller's grains - modified (~50 % dry matter)\", ('Supplemental feeds'!C24/('Supplemental feeds'!B24/100)), IF('Forage analysis'!C17=\"Distiller's grains - wet (~30 % dry matter)\", ('Supplemental feeds'!C25/('Supplemental feeds'!B25/100)), IF('Forage analysis'!C17=\"Liquid feed - 16 % (generic formulation)\", ('Supplemental feeds'!C26/('Supplemental feeds'!B26/100)), IF('Forage analysis'!C17=\"Liquid feed - 24 % (generic formulation)\", ('Supplemental feeds'!C27/('Supplemental feeds'!B27/100)), IF('Forage analysis'!C17=\"Liquid feed - 32 % (generic formulation)\", ('Supplemental feeds'!C28/('Supplemental feeds'!B28/100)), IF('Forage analysis'!C17=\"Oats - whole grain\",('Supplemental feeds'!C29/('Supplemental feeds'!B29/100)), IF('Forage analysis'!C17=\"Peanut hulls\",('Supplemental feeds'!C30/('Supplemental feeds'!B30/100)), IF('Forage analysis'!C17=\"Protein tub - 25 % cooked (generic formulation)\", ('Supplemental feeds'!C31/('Supplemental feeds'!B31/100)), IF('Forage analysis'!C17=\"Protein tub - 30 % cooked (generic formulation)\", ('Supplemental feeds'!C32/('Supplemental feeds'!B32/100)), IF('Forage analysis'!C17=\"Protein tub - 35 % cooked (generic formulation)\", ('Supplemental feeds'!C33/('Supplemental feeds'!B33/100)), IF('Forage analysis'!C17=\"Sorghum - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!C34/('Supplemental feeds'!B34/100)), IF('Forage analysis'!C17=\"Sorghum - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!C35/('Supplemental feeds'!B35/100)), IF('Forage analysis'!C17=\"Sorghum - whole grain\",('Supplemental feeds'!C36/('Supplemental feeds'!B36/100)), IF('Forage analysis'!C17=\"Soybean hulls\",('Supplemental feeds'!C37/('Supplemental feeds'!B37/100)), IF('Forage analysis'!C17=\"Soybean meal\",('Supplemental feeds'!C38/('Supplemental feeds'!B38/100)), IF('Forage analysis'!C17=\"Soybeans - whole roasted\",('Supplemental feeds'!C39/('Supplemental feeds'!B39/100)), IF('Forage analysis'!C17=\"Wheat middlings\",('Supplemental feeds'!C40/('Supplemental feeds'!B40/100)), IF('Forage analysis'!C17=\"Wheat - whole grain\",('Supplemental feeds'!C41/('Supplemental feeds'!B41/100)), IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17='Supplemental feeds'!A43,('Supplemental feeds'!C43/('Supplemental feeds'!B43/100)), IF('Forage analysis'!C17='Supplemental feeds'!A44,('Supplemental feeds'!C44/('Supplemental feeds'!B44/100)), IF('Forage analysis'!C17='Supplemental feeds'!A45,('Supplemental feeds'!C45/('Supplemental feeds'!B45/100)), IF('Forage analysis'!C17='Supplemental feeds'!A46,('Supplemental feeds'!C46/('Supplemental feeds'!B46/100)), IF('Forage analysis'!C17='Supplemental feeds'!A47,('Supplemental feeds'!C47/('Supplemental feeds'!B47/100)),\"INVALID ENTRY IN CELL C15 AND/OR C16\")))))))))))))))))))))))))))))))))))))))))))))","v":30.777777777777775}]
[null,"DM from additional supplemental feed",{"$f":"IF('Forage analysis'!C19=\"--\",0, IF('Forage analysis'!C19=\"No supplement\",0, IF('Forage analysis'!C19=\"Barley - whole grain\",('Supplemental feeds'!B5/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Brewer's grains - dried\",('Supplemental feeds'!B6/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Brewer's grains - wet\",('Supplemental feeds'!B7/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Commodity blend feed - 12 % pellet (generic formulation)\",('Supplemental feeds'!B8/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Commodity blend feed - 14 % pellet (generic formulation)\",('Supplemental feeds'!B9/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Commodity blend feed - 16 % pellet (generic formulation)\",('Supplemental feeds'!B10/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn - cracked, ground, or whole shelled\",('Supplemental feeds'!B11/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn cob meal\",('Supplemental feeds'!B12/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn - earlage (~63 % dry matter)\",('Supplemental feeds'!B13/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn - ground whole ear\",('Supplemental feeds'!B14/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn - high-moisture (~70 % dry matter)\",('Supplemental feeds'!B15/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn - snaplage (~60 % dry matter)\",('Supplemental feeds'!B16/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn - steam-flaked (~80 % dry matter)\",('Supplemental feeds'!B17/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn gluten feed - dried\",('Supplemental feeds'!B18/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Corn gluten feed - wet (~45 % dry matter)\",('Supplemental feeds'!B19/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Cottonseed hulls\",('Supplemental feeds'!B20/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Cottonseed meal\",('Supplemental feeds'!B21/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Cottonseed - whole\",('Supplemental feeds'!B22/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Distiller's grains - dried\",('Supplemental feeds'!B23/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Distiller's grains - modified (~50 % dry matter)\",('Supplemental feeds'!B24/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Distiller's grains - wet (~30 % dry matter)\",('Supplemental feeds'!B25/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Liquid feed - 16 % (generic formulation)\",('Supplemental feeds'!B26/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Liquid feed - 24 % (generic formulation)\",('Supplemental feeds'!B27/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Liquid feed - 32 % (generic formulation)\",('Supplemental feeds'!B28/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Oats - whole grain\",('Supplemental feeds'!B29/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Peanut hulls\",('Supplemental feeds'!B30/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Protein tub - 25 % cooked (generic formulation)\",('Supplemental feeds'!B31/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Protein tub - 30 % cooked (generic formulation)\",('Supplemental feeds'!B32/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Protein tub - 35 % cooked (generic formulation)\",('Supplemental feeds'!B33/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Sorghum - high-moisture (~70 % dry matter)\",('Supplemental feeds'!B34/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Sorghum - steam-flaked (~80 % dry matter)\",('Supplemental feeds'!B35/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Sorghum - whole grain\",('Supplemental feeds'!B36/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Soybean hulls\",('Supplemental feeds'!B37/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Soybean meal\",('Supplemental feeds'!B38/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Soybeans - whole roasted\",('Supplemental feeds'!B39/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Wheat middlings\",('Supplemental feeds'!B40/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"Wheat - whole grain\",('Supplemental feeds'!B41/100)*'Forage analysis'!C20, IF('Forage analysis'!C19=\"--\",0, IF('Forage analysis'!C17='Supplemental feeds'!A43,('Supplemental feeds'!B43/100)*'Forage analysis'!C20, IF('Forage analysis'!C19='Supplemental feeds'!A44,('Supplemental feeds'!B44/100)*'Forage analysis'!C20, IF('Forage analysis'!C19='Supplemental feeds'!A45,('Supplemental feeds'!B45/100)*'Forage analysis'!C20, IF('Forage analysis'!C19='Supplemental feeds'!A46,('Supplemental feeds'!B46/100)*'Forage analysis'!C20, IF('Forage analysis'!C19='Supplemental feeds'!A47,('Supplemental feeds'!B47/100)*'Forage analysis'!C20,\"INVALID ENTRY IN CELL C17 AND/OR C18\")))))))))))))))))))))))))))))))))))))))))))))","v":0}]
[null,"NEm content of additional supplemental feed, Mcal/lb of DM",{"$f":"IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17=\"No supplement\",0, IF('Forage analysis'!C17=\"Barley - whole grain\",('Supplemental feeds'!D5/('Supplemental feeds'!B5/100)), IF('Forage analysis'!C17=\"Brewer's grains - dried\",('Supplemental feeds'!D6/('Supplemental feeds'!B6/100)), IF('Forage analysis'!C17=\"Brewer's grains - wet\",('Supplemental feeds'!D7/('Supplemental feeds'!B7/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 12 % pellet (generic formulation)\",('Supplemental feeds'!D8/('Supplemental feeds'!B8/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 14 % pellet (generic formulation)\",('Supplemental feeds'!D9/('Supplemental feeds'!B9/100)), IF('Forage analysis'!C17=\"Commodity blend feed - 16 % pellet (generic formulation)\",('Supplemental feeds'!D10/('Supplemental feeds'!B10/100)), IF('Forage analysis'!C17=\"Corn - cracked, ground, or whole shelled\",('Supplemental feeds'!D11/('Supplemental feeds'!B11/100)), IF('Forage analysis'!C17=\"Corn cob meal\",('Supplemental feeds'!D12/('Supplemental feeds'!B12/100)), IF('Forage analysis'!C17=\"Corn - earlage (~63 % dry matter)\", ('Supplemental feeds'!D13/('Supplemental feeds'!B13/100)), IF('Forage analysis'!C17=\"Corn - ground whole ear\",('Supplemental feeds'!D14/('Supplemental feeds'!B14/100)), IF('Forage analysis'!C17=\"Corn - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!D15/('Supplemental feeds'!B15/100)), IF('Forage analysis'!C17=\"Corn - snaplage (~60 % dry matter)\", ('Supplemental feeds'!D16/('Supplemental feeds'!B16/100)), IF('Forage analysis'!C17=\"Corn - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!D17/('Supplemental feeds'!B17/100)), IF('Forage analysis'!C17=\"Corn gluten feed - dried\",('Supplemental feeds'!D18/('Supplemental feeds'!B18/100)), IF('Forage analysis'!C17=\"Corn gluten feed - wet (~45 % dry matter)\", ('Supplemental feeds'!D19/('Supplemental feeds'!B19/100)), IF('Forage analysis'!C17=\"Cottonseed hulls\",('Supplemental feeds'!D20/('Supplemental feeds'!B20/100)), IF('Forage analysis'!C17=\"Cottonseed meal\",('Supplemental feeds'!D21/('Supplemental feeds'!B21/100)), IF('Forage analysis'!C17=\"Cottonseed - whole\",('Supplemental feeds'!D22/('Supplemental feeds'!B22/100)), IF('Forage analysis'!C17=\"Distiller's grains - dried\",('Supplemental feeds'!D23/('Supplemental feeds'!B23/100)), IF('Forage analysis'!C17=\"Distiller's grains - modified (~50 % dry matter)\", ('Supplemental feeds'!D24/('Supplemental feeds'!B24/100)), IF('Forage analysis'!C17=\"Distiller's grains - wet (~30 % dry matter)\", ('Supplemental feeds'!D25/('Supplemental feeds'!B25/100)), IF('Forage analysis'!C17=\"Liquid feed - 16 % (generic formulation)\", ('Supplemental feeds'!D26/('Supplemental feeds'!B26/100)), IF('Forage analysis'!C17=\"Liquid feed - 24 % (generic formulation)\", ('Supplemental feeds'!D27/('Supplemental feeds'!B27/100)), IF('Forage analysis'!C17=\"Liquid feed - 32 % (generic formulation)\", ('Supplemental feeds'!D28/('Supplemental feeds'!B28/100)), IF('Forage analysis'!C17=\"Oats - whole grain\",('Supplemental feeds'!D29/('Supplemental feeds'!B29/100)), IF('Forage analysis'!C17=\"Peanut hulls\",('Supplemental feeds'!D30/('Supplemental feeds'!B30/100)), IF('Forage analysis'!C17=\"Protein tub - 25 % cooked (generic formulation)\", ('Supplemental feeds'!D31/('Supplemental feeds'!B31/100)), IF('Forage analysis'!C17=\"Protein tub - 30 % cooked (generic formulation)\", ('Supplemental feeds'!D32/('Supplemental feeds'!B32/100)), IF('Forage analysis'!C17=\"Protein tub - 35 % cooked (generic formulation)\", ('Supplemental feeds'!D33/('Supplemental feeds'!B33/100)), IF('Forage analysis'!C17=\"Sorghum - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!D34/('Supplemental feeds'!B34/100)), IF('Forage analysis'!C17=\"Sorghum - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!D35/('Supplemental feeds'!B35/100)), IF('Forage analysis'!C17=\"Sorghum - whole grain\",('Supplemental feeds'!D36/('Supplemental feeds'!B36/100)), IF('Forage analysis'!C17=\"Soybean hulls\",('Supplemental feeds'!D37/('Supplemental feeds'!B37/100)), IF('Forage analysis'!C17=\"Soybean meal\",('Supplemental feeds'!D38/('Supplemental feeds'!B38/100)), IF('Forage analysis'!C17=\"Soybeans - whole roasted\",('Supplemental feeds'!D39/('Supplemental feeds'!B39/100)), IF('Forage analysis'!C17=\"Wheat middlings\",('Supplemental feeds'!D40/('Supplemental feeds'!B40/100)), IF('Forage analysis'!C17=\"Wheat - whole grain\",('Supplemental feeds'!D41/('Supplemental feeds'!B41/100)), IF('Forage analysis'!C17=\"--\",0, IF('Forage analysis'!C17='Supplemental feeds'!A43,('Supplemental feeds'!D43/('Supplemental feeds'!B43/100)), IF('Forage analysis'!C17='Supplemental feeds'!A44,('Supplemental feeds'!D44/('Supplemental feeds'!B44/100)), IF('Forage analysis'!C17='Supplemental feeds'!A45,('Supplemental feeds'!D45/('Supplemental feeds'!B45/100)), IF('Forage analysis'!C17='Supplemental feeds'!A46,('Supplemental feeds'!D46/('Supplemental feeds'!B46/100)), IF('Forage analysis'!C17='Supplemental feeds'!A47,('Supplemental feeds'!D47/('Supplemental feeds'!B47/100)),\"INVALID ENTRY IN CELL C17 AND/OR C18\")))))))))))))))))))))))))))))))))))))))))))))","v":1}]
[null,"CP content of additional supplemental feed, % of DM",{"$f":"IF('Forage analysis'!C19=\"--\",0, IF('Forage analysis'!C19=\"No supplement\",0, IF('Forage analysis'!C19=\"Barley - whole grain\",('Supplemental feeds'!C5/('Supplemental feeds'!B5/100)), IF('Forage analysis'!C19=\"Brewer's grains - dried\",('Supplemental feeds'!C6/('Supplemental feeds'!B6/100)), IF('Forage analysis'!C19=\"Brewer's grains - wet\",('Supplemental feeds'!C7/('Supplemental feeds'!B7/100)), IF('Forage analysis'!C19=\"Commodity blend feed - 12 % pellet (generic formulation)\",('Supplemental feeds'!C8/('Supplemental feeds'!B8/100)), IF('Forage analysis'!C19=\"Commodity blend feed - 14 % pellet (generic formulation)\",('Supplemental feeds'!C9/('Supplemental feeds'!B9/100)), IF('Forage analysis'!C19=\"Commodity blend feed - 16 % pellet (generic formulation)\",('Supplemental feeds'!C10/('Supplemental feeds'!B10/100)), IF('Forage analysis'!C19=\"Corn - cracked, ground, or whole shelled\",('Supplemental feeds'!C11/('Supplemental feeds'!B11/100)), IF('Forage analysis'!C19=\"Corn cob meal\",('Supplemental feeds'!C12/('Supplemental feeds'!B12/100)), IF('Forage analysis'!C19=\"Corn - earlage (~63 % dry matter)\", ('Supplemental feeds'!C13/('Supplemental feeds'!B13/100)), IF('Forage analysis'!C19=\"Corn - ground whole ear\",('Supplemental feeds'!C14/('Supplemental feeds'!B14/100)), IF('Forage analysis'!C19=\"Corn - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!C15/('Supplemental feeds'!B15/100)), IF('Forage analysis'!C19=\"Corn - snaplage (~60 % dry matter)\", ('Supplemental feeds'!C16/('Supplemental feeds'!B16/100)), IF('Forage analysis'!C19=\"Corn - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!C17/('Supplemental feeds'!B17/100)), IF('Forage analysis'!C19=\"Corn gluten feed - dried\",('Supplemental feeds'!C18/('Supplemental feeds'!B18/100)), IF('Forage analysis'!C19=\"Corn gluten feed - wet (~45 % dry matter)\", ('Supplemental feeds'!C19/('Supplemental feeds'!B19/100)), IF('Forage analysis'!C19=\"Cottonseed hulls\",('Supplemental feeds'!C20/('Supplemental feeds'!B20/100)), IF('Forage analysis'!C19=\"Cottonseed meal\",('Supplemental feeds'!C21/('Supplemental feeds'!B21/100)), IF('Forage analysis'!C19=\"Cottonseed - whole\",('Supplemental feeds'!C22/('Supplemental feeds'!B22/100)), IF('Forage analysis'!C19=\"Distiller's grains - dried\",('Supplemental feeds'!C23/('Supplemental feeds'!B23/100)), IF('Forage analysis'!C19=\"Distiller's grains - modified (~50 % dry matter)\", ('Supplemental feeds'!C24/('Supplemental feeds'!B24/100)), IF('Forage analysis'!C19=\"Distiller's grains - wet (~30 % dry matter)\", ('Supplemental feeds'!C25/('Supplemental feeds'!B25/100)), IF('Forage analysis'!C19=\"Liquid feed - 16 % (generic formulation)\", ('Supplemental feeds'!C26/('Supplemental feeds'!B26/100)), IF('Forage analysis'!C19=\"Liquid feed - 24 % (generic formulation)\", ('Supplemental feeds'!C27/('Supplemental feeds'!B27/100)), IF('Forage analysis'!C19=\"Liquid feed - 32 % (generic formulation)\", ('Supplemental feeds'!C28/('Supplemental feeds'!B28/100)), IF('Forage analysis'!C19=\"Oats - whole grain\",('Supplemental feeds'!C29/('Supplemental feeds'!B29/100)), IF('Forage analysis'!C19=\"Peanut hulls\",('Supplemental feeds'!C30/('Supplemental feeds'!B30/100)), IF('Forage analysis'!C19=\"Protein tub - 25 % cooked (generic formulation)\", ('Supplemental feeds'!C31/('Supplemental feeds'!B31/100)), IF('Forage analysis'!C19=\"Protein tub - 30 % cooked (generic formulation)\", ('Supplemental feeds'!C32/('Supplemental feeds'!B32/100)), IF('Forage analysis'!C19=\"Protein tub - 35 % cooked (generic formulation)\", ('Supplemental feeds'!C33/('Supplemental feeds'!B33/100)), IF('Forage analysis'!C19=\"Sorghum - high-moisture (~70 % dry matter)\", ('Supplemental feeds'!C34/('Supplemental feeds'!B34/100)), IF('Forage analysis'!C19=\"Sorghum - steam-flaked (~80 % dry matter)\", ('Supplemental feeds'!C35/('Supplemental feeds'!B35/100)), IF('Forage analysis'!C19=\"Sorghum - whole grain\",('Supplemental feeds'!C36/('Supplemental feeds'!B36/100)), IF('Forage analysis'!C19=\"Soybean hulls\",('Supplemental feeds'!C37/('Supplemental feeds'!B37/100)), IF('Forage analysis'!C19=\"Soybean meal\",('Supplemental feeds'!C38/('Supplemental feeds'!B38/100)), IF('Forage analysis'!C19=\"Soybeans - whole roasted\",('Supplemental feeds'!C39/('Supplemental feeds'!B39/100)), IF('Forage analysis'!C19=\"Wheat middlings\",('Supplemental feeds'!C40/('Supplemental feeds'!B40/100)), IF('Forage analysis'!C19=\"Wheat - whole grain\",('Supplemental feeds'!C41/('Supplemental feeds'!B41/100)), IF('Forage analysis'!C19=\"--\",0, IF('Forage analysis'!C17='Supplemental feeds'!A43,('Supplemental feeds'!C43/('Supplemental feeds'!B43/100)), IF('Forage analysis'!C19='Supplemental feeds'!A44,('Supplemental feeds'!C44/('Supplemental feeds'!B44/100)), IF('Forage analysis'!C19='Supplemental feeds'!A45,('Supplemental feeds'!C45/('Supplemental feeds'!B45/100)), IF('Forage analysis'!C19='Supplemental feeds'!A46,('Supplemental feeds'!C46/('Supplemental feeds'!B46/100)), IF('Forage analysis'!C19='Supplemental feeds'!A47,('Supplemental feeds'!C47/('Supplemental feeds'!B47/100)),\"INVALID ENTRY IN CELL C17 AND/OR C18\")))))))))))))))))))))))))))))))))))))))))))))","v":8.8302752293577988}]
[null,"Total intake, lbs of DM",{"$f":"C36+C27+C30","v":23.358142960180004}]
[null,"Average NEm content of diet, Mcal/lb of DM",{"$f":"(((C24/C33)*C25)+ ((C27/C33)*C28)+ ((C30/C33)*C31))","v":0.62}]
[null,"Average CP content of diet, % of DM",{"$f":"(((C24/C33)*(C26/100))+((C27/C33)*(C29/100))+((C30/C33)*(C32/100)))*100","v":10.5}]
[null,"Initital forage only intake, lb of DM",{"$f":"-12.18150501+(0.0130822802*'Forage analysis'!C14)+(29.891425339*'Forage analysis'!C10)+(('Forage analysis'!C14-1300)*(('Forage analysis'!C10-0.575)*0.0177509373))","v":23.358142960180004}]
[null,"Back-calculated forage intake, lb of DM",{"$f":"(-12.18150501+(0.0130822802*'Forage analysis'!C14)+(29.891425339*'Forage analysis'!C34)+(('Forage analysis'!C14-1300)*(('Forage analysis'!C34-0.575)*0.0177509373)))-(C27+C30)","v":23.358142960180004}]

{"sheet":"Supplemental feeds","index":2,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[[47,0,47,3],[48,0,48,3],[49,0,49,3],[50,0,50,3]]}
["Feedstuff","Dry matter (DM), % as-fed","Crude protein (CP), % as-fed","Net energy for maintenance (NEM), Mcal/lb as-fed"]
["--","--","--","--"]
["No supplement",0,0,0]
["--","--","--","--"]
["Barley - whole grain",89.7,11.5,0.76]
["Brewer's grains - dried",93.2,23.3,0.72]
["Brewer's grains - wet",26,7.4,0.21]
["Commodity blend feed - 12 % pellet (generic formulation)",89.9,12,0.85]
["Commodity blend feed - 14 % pellet (generic formulation)",89.9,14,0.84]
["Commodity blend feed - 16 % pellet (generic formulation)",89.9,16,0.83]
["Corn - cracked, ground, or whole shelled",87.2,7.7,0.86]
["Corn cob meal",89.3,3.7,0.51]
["Corn - earlage (~63 % dry matter)",63,5.0999999999999996,0.59]
["Corn - ground whole ear",86.7,6.9,0.79]
["Corn - high-moisture (~70 % dry matter)",70,6.2,0.72]
["Corn - snaplage (~60 % dry matter)",60,4.8,0.53]
["Corn - steam-flaked (~80 % dry matter)",80,6.8,0.87]
["Corn gluten feed - dried",88.9,20.100000000000001,0.78]
["Corn gluten feed - wet (~45 % dry matter)",45,9.5,0.42]
["Cottonseed hulls",91.4,6.1,0.28000000000000003]
["Cottonseed meal",88.6,39.9,0.65]
["Cottonseed - whole",92.6,21.2,0.98]
["Distiller's grains - dried",90,27.7,0.9]
["Distiller's grains - modified (~50 % dry matter)",50,13.9,0.51]
["Distiller's grains - wet (~30 % dry matter)",30,9.6,0.35]
["Liquid feed - 16 % (generic formulation)",45,16,0.55000000000000004]
["Liquid feed - 24 % (generic formulation)",45,24,0.53]
["Liquid feed - 32 % (generic formulation)",45,32,0.5]
["Oats - whole grain",89.9,11.3,0.83]
["Peanut hulls",93.4,8.8000000000000007,0.3]
["Protein tub - 25 % cooked (generic formulation)",95,25,0.8]
["Protein tub - 30 % cooked (generic formulation)",95,30,0.75]
["Protein tub - 35 % cooked (generic formulation)",95,35,0.7]
["Sorghum - high-moisture (~70 % dry matter)",70,7.28,0.67]
["Sorghum - steam-flaked (~80 % dry matter)",80,8.17,0.86]
["Sorghum - whole grain",88.7,10.32,0.85]
["Soybean hulls",90,11.1,0.57999999999999996]
["Soybean meal",91.7,42.7,0.83]
["Soybeans - whole roasted",93.3,37.1,0.96]
["Wheat middlings",88.9,16.5,0.69]
["Wheat - whole grain",88.9,12.3,0.87]
["--","--","--","--"]
["Custom entry 1"]
["Custom entry 2"]
["Custom entry 3"]
["Custom entry 4"]
["Custom entry 5"]
[]
["CLICK HERE TO RETURN TO THE CALCULATOR"]
[]
["CLICK HERE TO RETURN TO THE INSTRUCTIONS"]

{"sheet":"Nutrient requirements","index":3,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Replacement heifers (1st breeding to 1st calving)"]
["Mature BW, lbs","NEm req, Mcal/d","CP req, lbs/d"]
[1000,8.9,1.6]
[1050,9.1999999999999993,1.655]
[1100,9.5,1.71]
[1150,9.8000000000000007,1.7649999999999999]
[1200,10.1,1.82]
[1250,10.4,1.87]
[1300,10.7,1.92]
[1350,11,1.9750000000000001]
[1400,11.3,2.0299999999999998]
[1450,11.6,2.08]
[1500,11.9,2.13]
[1550,12.25,2.1850000000000001]
[1600,12.6,2.2400000000000002]
[]
["Primiparous cows (1st calving to 2nd calving)"]
["Mature BW, lbs","NEm req, Mcal/d","CP req, lbs/d"]
[1000,12.5,2.16]
[1050,12.8,2.21]
[1100,13.1,2.2599999999999998]
[1150,13.45,2.31]
[1200,13.8,2.36]
[1250,14.1,2.4049999999999998]
[1300,14.4,2.4500000000000002]
[1350,14.7,2.5]
[1400,15,2.5499999999999998]
[1450,15.3,2.5950000000000002]
[1500,15.6,2.64]
[1550,15.9,2.6850000000000001]
[1600,16.2,2.73]
[]
["Multiparous cows (2nd calving and beyond)"]
["Mature BW, lbs","NEm req, Mcal/d","CP req, lbs/d"]
[1000,12.8,2.25]
[1050,13.15,2.2999999999999998]
[1100,13.5,2.35]
[1150,13.8,2.4]
[1200,14.1,2.4500000000000002]
[1250,14.4,2.4950000000000001]
[1300,14.7,2.54]
[1350,15,2.59]
[1400,15.3,2.64]
[1450,15.6,2.6850000000000001]
[1500,15.9,2.73]
[1550,16.2,2.7749999999999999]
[1600,16.5,2.82]

{"sheet":"Lists","index":4,"n_rows":201,"n_cols":3,"rows_kept":201,"cut":false,"hidden":true,"merged":[]}
["Replacement heifers (1st breeding to 1st calving)",null,0]
["Primiparous cows (First-calf heifers; 1st calving to 2nd calving)",null,0.5]
["Multiparous cows (Mature cows; 2nd calving and beyond)",null,1]
[null,null,1.5]
[null,null,2]
[null,null,2.5]
[null,null,3]
[null,null,3.5]
[null,null,4]
[null,null,4.5]
[null,null,5]
[null,null,5.5]
[null,null,6]
[null,null,6.5]
[null,null,7]
[null,null,7.5]
[null,null,8]
[null,null,8.5]
[null,null,9]
[null,null,9.5]
[null,null,10]
[null,null,10.5]
[null,null,11]
[null,null,11.5]
[null,null,12]
[null,null,12.5]
[null,null,13]
[null,null,13.5]
[null,null,14]
[null,null,14.5]
[null,null,15]
[null,null,15.5]
[null,null,16]
[null,null,16.5]
[null,null,17]
[null,null,17.5]
[null,null,18]
[null,null,18.5]
[null,null,19]
[null,null,19.5]
[null,null,20]
[null,null,20.5]
[null,null,21]
[null,null,21.5]
[null,null,22]
[null,null,22.5]
[null,null,23]
[null,null,23.5]
[null,null,24]
[null,null,24.5]
[null,null,25]
[null,null,25.5]
[null,null,26]
[null,null,26.6]
[null,null,27]
[null,null,27.5]
[null,null,28]
[null,null,28.5]
[null,null,29]
[null,null,29.5]
[null,null,30]
[null,null,30.5]
[null,null,31]
[null,null,31.5]
[null,null,32]
[null,null,32.5]
[null,null,33]
[null,null,33.5]
[null,null,34]
[null,null,34.5]
[null,null,35]
[null,null,35.5]
[null,null,36]
[null,null,36.5]
[null,null,37]
[null,null,37.5]
[null,null,38]
[null,null,38.5]
[null,null,39]
[null,null,39.5]
[null,null,40]
[null,null,40.5]
[null,null,41]
[null,null,41.5]
[null,null,42]
[null,null,42.5]
[null,null,43]
[null,null,43.5]
[null,null,44]
[null,null,44.5]
[null,null,45]
[null,null,45.5]
[null,null,46]
[null,null,46.5]
[null,null,47]
[null,null,47.5]
[null,null,48]
[null,null,48.5]
[null,null,49]
[null,null,49.5]
[null,null,50]
[null,null,50.5]
[null,null,51]
[null,null,51.5]
[null,null,52]
[null,null,52.5]
[null,null,53]
[null,null,53.5]
[null,null,54]
[null,null,54.5]
[null,null,55]
[null,null,55.5]
[null,null,56]
[null,null,56.5]
[null,null,57]
[null,null,57.5]
[null,null,58]
[null,null,58.5]
[null,null,59]
[null,null,59.5]
[null,null,60]
[null,null,60.5]
[null,null,61]
[null,null,61.5]
[null,null,62]
[null,null,62.5]
[null,null,63]
[null,null,63.5]
[null,null,64]
[null,null,64.5]
[null,null,65]
[null,null,65.5]
[null,null,66]
[null,null,66.5]
[null,null,67]
[null,null,67.5]
[null,null,68]
[null,null,68.8]
[null,null,69]
[null,null,69.5]
[null,null,70]
[null,null,70.5]
[null,null,71]
[null,null,71.5]
[null,null,72]
[null,null,72.5]
[null,null,73]
[null,null,73.5]
[null,null,74]
[null,null,74.5]
[null,null,75]
[null,null,75.5]
[null,null,76]
[null,null,76.5]
[null,null,77]
[null,null,77.5]
[null,null,78]
[null,null,78.5]
[null,null,79]
[null,null,79.5]
[null,null,80]
[null,null,80.5]
[null,null,81]
[null,null,81.5]
[null,null,82]
[null,null,82.5]
[null,null,83]
[null,null,83.5]
[null,null,84]
[null,null,84.5]
[null,null,85]
[null,null,85.5]
[null,null,86]
[null,null,86.5]
[null,null,87]
[null,null,87.5]
[null,null,88]
[null,null,88.5]
[null,null,89]
[null,null,89.5]
[null,null,90]
[null,null,90.5]
[null,null,91]
[null,null,91.5]
[null,null,92]
[null,null,92.5]
[null,null,93]
[null,null,93.5]
[null,null,94]
[null,null,94.5]
[null,null,95]
[null,null,95.5]
[null,null,96]
[null,null,96.5]
[null,null,97]
[null,null,97.5]
[null,null,98]
[null,null,98.5]
[null,null,99]
[null,null,99.5]
[null,null,100]