[Spreadsheets of a conventional application software for calculation of plausibility of paternity: application to parentage testing with highly polymorphic markers in deceased party].

We designed a spreadsheet package for the computation of plausibility of paternity, that can cope with highly polymorphic genetic markers and cases of deceased parties. The application program is Microsoft EXCEL, which is one of the best-selling spreadsheet software running on both Microsoft Windows and Macintosh OS. Komatsu's formula for paternity testing was mainly employed in the spreadsheet package. Probability of the mother-child-alleged father combination was calculated using "IF" function to compare the members' genotypes, whereas "VLOOKUP (or HLOOKUP)" function was employed to refer to a list of genes and their frequencies. In case of a phenotype consisting of several genotypes, the list of phenotypes versus genotypes was also given, to which the function referred. To extend these spreadsheets available for the test of deceased party, additional sheets were also created to estimate frequencies of alleged father's possible genotypes. These probabilities were calculated on the basis of types of his parents and siblings, those of his wife and their biological children, and those of both. This package would be cut out to compute the probability of paternity with extremely polymorphic loci with gentle user interface. Calculation time is satisfactorily short, although it requires considerably large disk space in some extremely complicated cases. Japanese version of this package is freely available at anonymous FTP site of the Department of Forensic Medicine, Tohoku University School of Medicine.