Hi Chris,

Please see the example module I have attached to this message. This is a hacked down version of some code I used to define the layout of media across a 96-well microtiter plate. The Excel input file contains well names ('A1', 'A2'... 'H12') that get transformed into integers (1-96) via the js based transform. Please note that the 'Media Name' column in the Excel file actually just contains integers as I left out a foreign key relationship from this example.

Of course, you can do much more complex stuff in the transformation. I often query other Labkey tables using the js API and save rows in other Labkey tables also using the js API.

-Will