Custom Excel Programming

for analytical science applications

I specialize in creating Excel macros and worksheets to automate processes and remove error caused by laborious manual tasks, specifically applied to HPLC, LCMS, and other drug-discovery applications.

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

    Upgradable: 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 oligonucleotide thermodynamics   

Other Previous Macro Applications

    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

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. Final cost will not go over the original estimate (see Rates). 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. 

_____________________________________________________

 have visited this site

Last updated 3-15-2007