CustomExcel.com

Macros and Worksheets for the Sciences

Examples of macros

The following are screen shots of worksheets for various purposes. 

1. LCMS Input File

2. LCMS Combichem Data Analysis

3. siRNA Thermodynamics

4. gene sequences Search for siRNA target sequences

1. Creation of input files for HPLC and LCMS  (return to top)

This is a generic example in which one area is designated for the input of sample info and another region is designated for the final list. This was a rather simple job.

One button click creates the required input to the right (or on a separate page).

Numerous variations exist, as many as there are users. The most desirable result requires no manipulation by the user for input. Directly import (or cut and paste) input and designer code parses information and creates output. 

Results can be put into a separate worksheet, workbook, or text file.

This process can be scaled up to create multiple text files from multiple 96-well plates-worth of files for semi-automated processes.

2. Post-processing of LCMS data for combichem libraries  (return to top)

Results output from an LCMS package can be converted to a more useful format. This example shows the conversion of MicroMass data for a combichem library analysis from the standard output to a plate format, showing results that are based on the user's specifications:

Data are pasted or imported into Excel, then easily converted to a plate format for easy viewing. Additional information about the results can be added, such as data summaries by plate. This was also a fairly quick job.

3. Batch calculation of siRNA thermodynamics  (return to top)

    This spreadsheet uses the most recent model for accurate RNA stability calculations. This was a more involved task, due to the complexities of the algorithm, creation of complement, and extensive testing for accuracy and robustness. 

In this example, the calculations for a user-specified core region of 19 nucleotides within a longer sequence are performed. Calculations  included base composition, thermodynamic parameters, and stability of end fragments. 

    'Run Calculation' creates the core sequence and complement as well as performing the desired calculations

    (Results continued past column E)

4. Searching Gene Sequences for Target siRNA  (return to top)

This spreadsheet searches for target siRNA sequences within a list of gene sequences. 

The result is the list of genes and the respective target matches. The 'core' sequence found includes a user-specified number of bases upstream and downstream of the target. (There is also a results sheet for targets not found in any gene.)

__________________________________________________________