CustomExcel.com

Macros and Worksheets for the Sciences

Home Examples Rates Biography Related Links Contact

Home
Examples
Rates
Biography
Related Links
Contact

 

Custom Excel Programming for analytical science applications

 

I specialize in creating Excel macros and worksheets to automate processes, specifically applied to HPLC, LCMS, siRNA and other drug-discovery applications. I work on non-science-related projects as well.

 

Automate repetitive tasks

    Create custom lists for data input and output

    Perform calculations such as calibrations and results analysis

    Reduce data to summarize results or remove unwanted output from software

 

Excel: Simple, Yet Powerful

    Days to solutions, not weeks

    flexible for changing needs

    Upgraded easily: start with minimal needs and add functionality

 

Examples

    Creation of input files for HPLC and LCMS

    Post-processing of LCMS data for combichem libraries

    Batch calculation of siRNA thermodynamics   

    Search gene sequences for siRNA targets

 

Other Previous Macro Applications

    Gene sequence and siRNA target manipulations

    Input files for Perkin-Elmer Sciex MS-directed HPLC purification of drug candidates

    Conversion of output from PE-Sciex to input for MicroMass MUX analytical LC/MS

    Automatic Quantitation of ELSD results from MicroMass analytical LC/MS

    Input files for Thermo-Finnigan LCQ LC/MS and Agilent Chemstation HPLC

    Optimizing worksheets for database input and general usefulness

 

Why use This service?

 

    I understand the science behind the applications (see Bio).

    You can allow your personnel to spend more time at their specialties.

    All code is well documented and easy to follow.

    Macro code will be yours to modify as needed in the future.

 

 

Frequently Asked Questions

 

Q. How long does a typical job take?

A.  Simpler jobs like creating a long LCMS input list might take 3 hours or less. Longer jobs that require complex manipulations and calculations might take 8 hours or more.

 

Q. What if I am on a limited budget?

A.  I will tell you up front whether I can deliver a product that will meet your needs and your budget. My goal is to give you a product that you are happy with at a reasonable cost.

 

Q. How can I try out the service?

A.  I suggest a small initial project. Many projects start with a basic useable function that can be completed rather quickly and serves an important purpose. Further features such as broader applicability and ease of use are then added as desired. 

_____________________________________________________

 

Hit Counter have visited this site

 

Last updated 12-3-2008