The Lab Hot Sheet enables you to identify problem SCC cows in the herd. As soon as your lab runs your milk samples, this hot sheet is available so you can immediately know which cows are contributing the most to your bulk tank SCC. This can help you decide which cows may need to be moved to a new group, need treatment or some other management decision.
First, the Herd Average is listed for Milk, Fat %, Protein %, MUN (Milk Urea Nitrogen), SCS (Somatic Cell Score), Weighted Average SCC (Somatic Cell Count), and DIM (Days in Milk). A Bulk Tank Summary is provided if a herd uses more than one bulk tank.
Cows are listed in descending order of their SCC contribution to the bulk tank (%). Current test day milk lbs., Fat%, Protein%, DIM, and Lact (Lactation number) are listed for each cow, as well as the following:
SCS – Linear Somatic Cell Score for the current test
Conditions Affecting Record (CAR) Codes A - Abnormal, weights were recorded E - Estimated, no weights were recorded F - Fat % and Protein % Estimated, no sample collected by the technician H - In Heat on Test Day I - Injected Prior or During Milking L - Fat % and Protein % Estimated, lab unable to get results from sample
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARW/O% 1409140988.53.22.68.6485179614012.7 1521152180.33.43.08.54526185412310.8 1884188482.34.43.47.5226316021155.5 1758175870.05.13.47.1171517931093.6 1695169580.33.83.46.9149327931043.6 2150215050.34.03.97.4211131A993.2 2016201680.33.23.16.410563301952.5 1999199990.63.43.16.1857132922.3 1969196992.33.72.85.9746272A892.0 1418141890.24.13.45.97462415A862.0 1643164378.24.23.06.18571714832.0 1653165361.83.93.16.410562503801.9 200002000070.03.12.86.29191953771.9 1737173769.23.83.36.29192573741.9 1622162290.62.92.75.66062544721.6 1961196196.83.42.95.55661272691.6 199971999794.73.22.75.55661403671.6 1757175786.53.52.95.55661693641.5 1988198898.83.62.85.3492282621.4 1702170294.73.53.15.34922363601.4 1843184365.94.93.75.86962962581.4 2077207746.13.23.36.39851061A561.4 1844184492.63.22.75.3492413541.4 1617161790.63.73.25.34922654521.3 1605160578.24.33.45.45282534501.2 1446144696.83.43.14.93732255481.1 15191519103.03.82.74.73251385461.0 *******HOTSHEET*******Page1of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARB# 1354135476.23.62.93.4132258698 1403140386.52.42.83.110734751 1409140988.53.22.68.648517961 1418141890.24.13.45.97462415A99 14381438107.13.43.10.11310751 1446144696.83.43.14.937322551 14681468109.12.32.63.514113741 1470147061.83.73.21.84430751 1475147557.64.03.03.615223051 1481148167.93.22.60.82224851 14991499111.23.52.60.1138951 15011501107.15.33.02.46619751 1509150937.04.23.63.8174347598 15191519103.03.82.74.732513851 1521152180.33.43.08.54526185498 15271527111.23.32.80.11322551 1541154159.74.43.52.78131441 1552155298.83.62.90.11319251 15641564115.32.52.63.312312551 1570157074.13.12.71.331124598 1576157678.24.12.72.2571255 1588158867.94.23.10.82229641 1594159488.53.92.80.1139551 1600160084.43.73.00.11321841 1605160578.24.33.45.4528253498 1606160676.23.83.42.15429741 1616161698.83.22.60.7209631 1617161790.63.73.25.349226541 1618161888.53.83.32.67622541 1622162290.62.92.75.6606254498 1623162386.53.73.11.02516341 1633163370.04.93.61.84441531 1643164378.24.23.06.185717141 1644164498.83.22.80.4179141 1648164894.74.43.70.11316641 1651165178.23.73.23.514123241 1653165361.83.93.16.4105625031 16561656109.14.32.71.22989498 16581658103.03.63.02.25715641 *******HOTSHEET*******Page2of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARB# 1664166480.34.33.61.43325831 1673167382.34.02.92.0501245 1677167786.53.02.91.84419031 1679167967.94.33.32.15429631 1688168856.63.73.14.12141044A99 1691169174.14.03.42.67627631 1695169580.33.83.46.91493279398 1701170172.04.53.20.61925631 1702170294.73.53.15.349223631 1704170474.14.33.32.99336331 1708170894.73.53.11.22911231 1711171161.84.43.43.010014498 1723172361.85.33.60.72030331 17241724111.24.72.70.1132841 1731173167.13.63.12.050104A99 1732173278.24.63.42.15419931 1737173769.23.83.36.2919257399 1738173892.63.22.91.33116231 1739173976.23.72.71.22916631 1753175357.65.63.43.211534531 1754175494.75.32.81.84414731 1755175590.64.13.12.25729531 1757175786.53.52.95.556616931 1758175870.05.13.47.1171517931 1759175980.33.32.92.67626431 1762176274.14.33.14.732514631 1774177488.54.53.21.74119431 1779177961.83.03.11.84423398 1781178194.74.53.00.11312731 1784178498.83.22.80.11316531 17941794107.13.72.50.1135731 17961796105.03.93.10.72011731 1799179965.96.03.05.1429835 1800180082.33.32.90.11311531 1808180890.63.72.62.57110731 1812181296.84.33.00.51813031 1819181953.54.53.42.67627821 1822182245.36.62.43.817415398 18281828113.32.62.60.1134531 *******HOTSHEET*******Page3of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARB# 1830183076.24.53.61.229635 1831183184.43.72.70.1134131 1833183349.44.93.64.121427621 1835183557.64.83.50.11328921 1843184365.94.93.75.869629622 1844184492.63.22.75.34924131 1845184590.63.72.91.2295031 18481848109.13.22.80.2149631 1849184982.34.43.43.716231121 1850185090.24.02.70.417143A99 18521852119.43.42.92.9931535 1856185665.93.73.61.94738521 1858185878.23.73.02.78133221 1863186378.24.33.00.51833021 1864186461.85.23.81.74116621 1869186949.45.13.03.010027121 1870187059.74.33.52.15432921 1873187398.82.92.50.1138221 1874187496.83.23.23.4132835 1875187582.33.83.00.51818221 18761876109.14.33.00.11315722 1879187976.23.83.10.11318721 1880188076.23.52.80.11320721 1882188257.63.73.11.22929022 1883188353.54.13.74.732526121 1884188482.34.43.47.5226316022 1887188776.24.73.30.11321822 1888188890.63.93.20.21421121 1889188967.94.43.82.46619422 1891189192.63.03.11.33111221 1894189494.73.63.10.61916022 1895189594.72.92.90.11318521 1896189684.44.03.34.223019921 1897189782.32.92.80.11319322 1899189994.74.73.20.11313521 1900190055.63.13.13.211526521 1901190165.94.23.42.466157298 1902190270.04.63.60.11324321 1906190682.34.23.30.72020622 *******HOTSHEET*******Page4of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARB# 1911191161.84.93.30.11327122 1913191390.62.53.10.11323622 1917191792.63.63.02.2571025 19181918107.13.52.64.02004121 1920192065.93.83.41.33116122 1922192278.24.53.80.11318022 1925192598.82.72.32.46643298 1931193190.64.23.00.11312021 1934193461.85.43.32.466525 1935193586.53.53.12.46616021 1937193780.33.33.10.1139822 1938193884.43.02.61.2297021 19411941105.03.42.91.84414822 1943194382.33.33.01.84411921 1947194796.83.03.00.11312821 1952195286.54.22.91.43311521 19541954103.03.02.83.01006921 19581958107.13.82.70.1135721 1960196060.84.13.61.638132A99 1961196196.83.42.95.556612722 19621962105.02.92.72.6767121 1966196696.83.93.00.3152521 1968196886.53.32.90.11328012 1969196992.33.72.85.9746272A99 1974197496.83.22.72.3627021 19751975103.03.62.90.1133921 1976197659.74.93.72.05038212 1977197784.43.13.00.1139121 1979197994.73.42.50.1133421 1981198188.53.23.00.1134521 1983198382.34.42.60.5182621 1985198588.53.72.92.6763421 1988198898.83.62.85.349228298 1989198963.84.93.61.12729012 1993199386.54.33.71.94728312 1995199570.03.83.20.11330512 1996199682.34.73.60.11340512 1997199780.32.92.81.2291625 1999199990.63.43.16.18571325 *******HOTSHEET*******Page5of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARB# 2000200084.43.52.91.5351525 2001200172.03.83.50.11329012 2002200290.63.23.20.1131425 2003200378.23.23.00.11328812 2010201082.33.53.10.41723912 2012201276.23.93.12.36227112 2013201384.43.63.00.61910412 2014201484.43.42.90.11329512 2015201572.03.53.11.22924712 2016201680.33.23.16.4105633012 2017201770.04.73.60.11333012 2019201982.32.93.13.413231912 2020202078.23.53.20.11326012 2022202284.43.43.21.12723712 2023202374.14.23.60.11328412 2024202478.23.33.12.05010712 2026202682.34.03.41.94724712 2027202770.03.43.03.413226412 2028202888.53.83.10.11328712 2029202972.04.93.50.11323212 2030203076.23.63.12.57119112 2032203267.93.73.50.11328712 2033203370.03.93.13.817417412 2034203480.33.03.00.92317412 2036203657.63.63.20.31526712 2037203770.03.93.11.6388412 2038203865.94.73.50.11321812 2039203949.44.63.50.11325712 2040204061.82.93.30.11326312 2041204153.53.53.10.11311512 2043204370.04.13.61.43324312 2044204490.63.13.10.11322112 2045204565.94.13.60.11317712 2046204678.23.73.10.92317512 2047204786.54.02.91.2297512 2048204890.63.12.70.1134712 2051205167.93.63.32.67615912 2052205278.24.13.41.84417812 2053205372.04.63.52.57120112 *******HOTSHEET*******Page6of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARB# 2054205474.14.23.34.732517912 2055205594.73.53.01.2298012 2057205763.83.73.30.72017212 2058205870.05.03.30.72014012 2059205970.03.63.20.11311812 2062206270.02.92.90.11311112 2064206472.03.83.10.1139212 2065206572.03.52.70.82214812 2066206674.13.82.90.11314812 2067206765.94.13.20.31514012 2068206886.53.62.80.1137412 2069206976.23.73.30.11311512 2070207086.53.43.22.99316812 2071207178.23.42.90.8228912 2072207282.33.32.80.1135412 2073207365.94.23.21.53516912 2074207465.94.03.30.72012612 2075207561.83.82.91.33111212 2076207684.43.62.83.31239312 2077207746.13.23.36.39851061A99 2078207874.14.02.90.1137112 2079207988.52.82.50.1135612 2081208167.93.93.40.11310912 2082208270.04.33.00.1137012 2083208378.24.13.10.1137312 2085208574.12.93.10.11311312 2086208670.04.03.10.1136912 2087208782.33.62.60.7204412 2088208878.23.32.81.2293812 2090209080.33.42.90.1133312 2091209182.33.62.90.7208912 2092209272.03.33.10.2147612 2093209376.23.12.70.5188312 2094209459.73.02.90.1133312 2095209570.03.53.02.7817812 2096209674.13.52.90.6193312 2097209792.62.82.60.6194712 2098209870.03.73.00.4179112 2100210065.94.12.91.7415212 *******HOTSHEET*******Page7of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3
IndexBarnMilkFat%Pro%SCSCountMUNDIMLactCARB# 2101210172.04.13.20.1137512 2102210267.94.12.92.57169198 2103210365.93.92.72.2573012 2106210676.24.52.72.4662015 2107210759.74.42.90.7202612 2109210990.63.62.90.5185312 2110211074.13.32.82.0505912 2113211365.93.43.10.11310112 2117211772.03.53.00.1133612 2118211835.04.13.74.42641212 2122212253.54.93.01.5355112 2123212359.74.93.10.7202712 2125212570.03.12.90.2145112 2128212870.02.72.80.8223915 2132213265.94.02.90.1133512 2133213361.84.83.41.8441712 2134213457.63.42.80.9235212 2135213561.83.92.80.3153012 2136213676.23.22.70.4175312 2138213849.43.93.34.52831615 2139213961.85.12.72.5713012 2143214374.13.92.92.4664812 2144214461.83.42.80.7201415 2145214547.34.12.92.887915 2146214674.13.02.82.2574512 2148214867.94.23.22.781815 2149214970.03.42.91.9473415 2150215050.34.03.97.4211131A99 2152215254.52.82.83.8174151A99 199971999794.73.22.75.556614031 1999919999100.93.82.80.11321531 200002000070.03.12.86.2919195398 *******HOTSHEET*******Page8of8 266SamplesCollected: Tested: 06-16-23 06-15-23 NumberAverages CowsMilkFat%Pro%MUNSCSWt.Avg.SCCDIM 26678.73.83.11.8161149 TankFat%Pro%MUNSCSSCC BulkTankSummary 1 2 3