Excel can play a critical role in data capture, manipulation, and analysis. The possibilities are limitless.

Why should you choose me for your Excel development?

I am a scientist (PhD Microbiology) with many years laboratory experience; your scientific staff and I speak the same language. I can seamlessly translate their needs into functionality to facilitate your efforts.

I have worked in the bioscience field for more than twenty years and with Excel a majority of that time. I have created applications and macros in Excel that have:

  • allowed laboratory and business staff to capture, manipulate and analyze data from a variety of laboratory instruments;
  • provided ad hoc graphing capability for FDA review of drug manufacture QC tests;
  • printed more than a thousand assay trending graphs at the click of a button;
  • filtered signal from noise in mass screenings of hybridoma specificity;
  • mapped tissue locations in -80° C freezers;

…and much more. View my past projects for more examples.

Did you know?

  • The coding language of Excel is Visual Basic for Applications (VBA), which allows developers to easily build custom solutions within Excel.
  • VBA is a compiled language —so it runs fast.
  • VBA can be used to create forms, custom menus and any other feature of a rich, user-friendly interface.
  • An Excel application can be coded so that a user won’t recognize the application as Excel.
  • Excel can retrieve, insert, delete, and update data in Oracle, SQL Server, Access, MySQL, Filemaker Pro and any other database for which there is an ODBC driver.

Your laboratory and business can run more efficiently. I can help your organization harness the power of Excel. Contact me today to find out how.

Testimonials

“Paul created an exceptional Excel program for us that solved our problem of extracting and graphing data from our LIMS system for FDA audits while maintaining data integrity and without requiring coding of reports using the LIMS’s proprietary report generator. I especially appreciate that he was willing to listen to our input on the structure of the data retrieval parameters and that he worked closely with the users to refine the program so it not only worked well, but was user-friendly.”

Carole Genovesi
Senior Manager, Environmental QC at Genentech, Inc

“Paul’s wizardry with Excel greatly increased our group’s productivity. He rapidly built tools ranging from a graphical database interface for tracking biological samples, to a simple pivot-table macro that saved hours of labor in the first week. His efficient and highly useable Excel applications saved our organization a huge amount of time that would otherwise have been spent in repetitious, error prone labor, or in developing less effective solutions in other programming languages.”

Jeremy Gollub
Senior Bioinformatics Scientist at Iconix Biosciences, Inc.

View all testimonials