Endy:Victor3 Excel macro to hasten data processing

From OpenWetWare

Revision as of 15:07, 2 October 2006 by Hkeller (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search
Add to My Links

Also see: Victor3 plate reader

Introduction

This macro can be used to rearrange the results file from a plate reader experiment. The macro can be downloaded here for either a Mac or a PC. The macro creates a separate sheet for Absorbance and Fluorescence data. It then gives each well its own column on each sheet and puts the time points in the first column. It finally converts the time points to minutes format. The original version of this code was written by Heather. There are further enhancements that could be made to the macro so please feel free to contribute to the code. An updated version of this file which accomodates multiple fluorophore reads will be posted when available (hkeller 15:07, 2 October 2006 (EDT)).

Installation

  1. Download the macro linked to above
  2. If necessary change the file extension to .xla (some browsers will add a .txt to the end of the file).
  3. Optimally, save it in your Office directory in the applications folder. If your office folder is call MSOffice, for example, save it here MSOffice/Office/Add-Ins
  4. Open Excel, go to Tools>Add-Ins>Select.
  5. Browse to and select PlateReader.xla. Hit open.
  6. Make sure the blue tick box beside PlateReader.xla is ticked. Hit ok.
  7. Go to Tools>Customize>Commands.
  8. Under Categories, browse to macros.
  9. You should see on smiley face button in the field on the right.
  10. Click and drag this button up to one of your toolbars and release the mouse button.
  11. Hit Ok.
  12. Control-click on the smiley face and select "Assign macro".
  13. Under Macro Name, enter "RAW_SORT" without the exclamation marks.
  14. Hit Ok.
  15. The macro should now be installed for use whenever you open Excel.
  16. If you open Excel, try to use the macro and receive a message saying the macro can't be found, go to the Add-Ins window and tick the box beside PlateReader.xla, this has fixed problems in the past.

Usage

  1. Click on the tab of the worksheet with your data in it to make it the "active" sheet.
  2. Hit the smiley face macro button
  3. The macro will operate and may take several minutes to run depending on the size of the results file.
    • Since the macro executes many copy and paste commands, you won't be able to perform copy and paste commands in other applications either.
    • This highlights the need for orthogonality of sub-system function in a complex system.
  4. Two sheets will be created - Absorbance Data and Fluorescence data.
  5. Each sheet will have time in the first column, converted into minutes.
  6. Each well will get a column of its own on both sheets.
Personal tools