Excel Workbooks
Laboratory Faculty & Staff | R&D Lab Publications | Excel Workbooks | mitoSAVE | STRait Razor |Visiting Scientists | Notable Former Students
Forensic STRs
GeneMapper Genotype Conversion Tool
The Transposer is a small workbook designed to transpose the vertical output of GeneMapper and GeneMapper-IDx into a horizontal table with samples listed vertically (one row/sample) with markers listed horizontally.
Stutter Calculator
The Stutter Calculator determines true allele calls** and analyzes peak intensities/heights to determine the stutter ratio of Forensic STR kits. It supports most commonly used STR kits.
Stutter Calculator (Small, 100 Samples Current version is v1.2)
PHASTR
PHASTR is a workbook developed to analyze peak height data of commonly used Forensic STR kits. It computes numerous values (e.g. Peak Height Ratios, Average Peak Heights, Dye Channel Evaluations, etc.)
PHASTR (Peak Height Analysis of STRs, Current Version is v2.0)
4N6 Amplification Workbook
4N6 Amplification Workbook takes the sample(s) post-extraction thru STR
analysis. It generates plate layouts and upload files*** for ABI 7500,
3130 and 3500.
4N6 Amplification Workbook, Current Version is v1.0
4N6 Amplification Workbook Manual (Currently Outdated)
RMP Calculator
RMP Calculator is a workbook developed to generate Random Match Probabilities for a large number of samples.
RMP Calculator (Medium, 1000 Individuals)
RMP Calculator (Small, 100 Individuals)
Massively Parallel Sequencing (MPS) Solutions
mitoSAVE
mitoSAVE was developed for haplotype evaluation and conversion of VCF files into a standardized forensic format haplotype.
HSD Generator
HSD Generator converts mitoSAVE haplotypes into a text file for haplogroup generation.
HSD Generator
STRait Razor v2.0
Files for the conversion of STRait Razor output can be found under the STRait Razor homepage
*These workbooks are freely available. However, these downloads are trials intended to evaluate the utility of the workbooks for widespread release. To the best of my knowledge, all workbooks linked to perform as
intended. If any calculation errors or other bugs are observed, please let me know.
**True allele call assignments based on peak heights/intensities. If a peak at stutter position is larger than the true sister allele it will be assigned as a true allele. Please check data prior to analysis to determine if any stutter peaks are larger than the true alleles within a locus. Alternatively, true allele calls (if known) can now be included prior to analysis to ensure proper stutter calculations.
***Upload files are generated using the identifiers (e.g. Results Group, Instrument Protocol) used within our lab. These can easily be changed to suit other instruments/labs.
Social media