Abstract: By calculating the individual inbreeding coefficient within the herd, the genetic effect of an existing herd can be grasped, which has important guiding significance for the selection of livestock and is effective to prevent the phenomenon of breeding deterioration caused by inbreeding. This paper calculates the frequency of common ancestor appearing in pedigree information by Excel function, which can estimate the inbreeding coefficient between individuals simply and quickly, and realize the intuitive estimation of inbreeding coefficient. It is not necessary for the users to master computer programming knowledge, and can be used for reference by the technical personnel of grass-roots animal husbandry industry, also can quickly estimate pedigree individuals. The inbreeding situation makes it easy to assess the genetic effects of the herd.