Excel VBA script for analysis of telomere length from telomere restriction fragmentation (TRF) Southern blot gel.
This Excel script calculates the mean telomere length from a telomeric restriction fragmentation (TRF) Southern blot image. Currently, the maximum number of lanes it can process is 20.
Evenly partition each lane on the gel image to 30 parts, and measure the color / shade intensity from any gel image software.
Determine the position of the size ladders / markers in terms of the partition. Set the position of each ladder / marker band in the “Ladders” input region.
Combine all the intensity data into one column, and copy to the “Volumn” input region.
Setup the sample information in the next input region.
Run the script by clicking the button in the fourth section.
After running the script, three result sheets will be generated.
An overview of the ladder and sample information you have setup in Section I.
The detailed information about the telomere length calculation for each lane.
A summary of the sample telomere length.
This Excel VBA script program was developed while I was working in laboratory of Dr. David Gilley in Indiana University, School of Medicine, Indianapolis. It was improved based on the algorithm from the script TeloRun developed in the laboratory of Dr. Jerry Shay and Dr. Woodring Wrigth in University of Texas Southwestern Medical Center. Please consult these two institutions about their policy for intellectual properties.
Please email any question or suggestion to tuliren.git@outlook.com">me.