Endy:Victor3 Excel macro to hasten data processing

Also see: Victor3 plate reader

Introduction

This macro can be used to rearrange the results file from a plate reader experiment. It only works on a mac. A similar PC version can be obtained from Heather Keller or Jason Kelly. This 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.

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.

The macro should now be installed for use whenever you open Excel.

1. 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. Rename the worksheet with all your data "Raw Data".
2. Go to Tools>