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)

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)