Computational Biology Demo Spreadsheets

Sequence Analysis Unit
DemoA1.xls (Pattern matching)
DemoA2.xls (Mononuc and dinuc frequencies)
DemoA3.xls (Enriched seq probabilities)
DemoA4.xls (Frequency matrix)
DemoA5.xls (Searching with a Profile)
DemoA6.xls (Simple dot matrix)
DemoA7.xls (Dot matrix with window)
DemoA8.xls (Simple Dynamic Programming)
DemoA9.xls (Dynamic Programming with PAM250)
DemoA10.xls (Hashing table)
DemoA11.xls (Markov chains)
DemoA12.xls (Dynamic Programming with PAM & gap penalty)
DemoA13.xls (Comparison of PAM250 and BLOSUM62)
DemoA14.xls (Dynamic Programming ala Fig 3-9)
DemoA15.xls (Viterbi Algorithm)
Graphics and Transforms
DemoC1.xls (Graphics Transformations)
DemoC2.xls (XY vs Categorical Plots)
DemoC3.xls (Smoothing data using Fourier transforms)
Biological Modeling Unit
DemoD1.xls (Spreadsheet Functions List)
DemoD2.xls (Net Charge on Protein)
DemoD3.xls (Net Charge vs. pH using tabulation)
DemoD4.xls (Net Charge vs. pH using copies)
DemoD5.xls (Net Charge vs. pH using reorganization)
DemoD6.xls (Population Dynamics)
DemoD7.xls (Population Genetics)
DemoD8.xls (Euler's Method)
DemoD9.xls (Midpoint Method)
DemoD10.xls (Midpoint Method for exponential)