Enron email

Algorithmic Indexing

15 Jun 2001, 15:14 UTC

Implementation of Revised Spreadsheet Format

From
Sue Vasan sue.vasan@enron.com
To
Brian Gillis, marco.smith@enron.com, jason.harding@enron.com, Joel Bennett, stanton.brown@enron.com, keynan.dutton@enron.com, stewart.range@enron.com, matthew.condon@enron.com, Israel Estrada, Hai Chen, Anne Bike, Errol McLaughlin
and 9 more Ryan O'Rourke, Elizabeth Shim, George Huan, Kristen Clause, j.smith@enron.com, Patricia Rivera, Carole Frank, Gary Stadler, John Best
Cc
Burton McIntyre, d..powell@enron.com, Wei Hu, Debbie R. Brackett, Beth Apollo
Bcc
Burton McIntyre, d..powell@enron.com, Wei Hu, Debbie R. Brackett, Beth Apollo
Date
Fri, 15 Jun 2001 08:14:21 -0700 (PDT)
Thanks to everyone for your help and support this past week as we worked through the process of taking the new spreadsheet format (requiring the use of the Counterparty ID instead of the ERMS Short Name) into production.  The credit for a successful implementation goes to each and everyone of you!

Going forward, please bear the following points in mind:
1) There is a minor change to the manner in which the spreadsheets will load into RisktRAC:  If the new validation routine does not find any errors in your spreadsheet, it will immediately load the positions into RisktRAC without prompting you to confirm and insert the spreadsheet into our tables.  When you see the final confirmation message, the position has already been loaded into our deal tables.

2) Please make sure that you have only numeric values, i.e., valid counteparty ID's, in column F (external_cp_ID) and column G (internal_cp_ID).  Any alpha values in these two colums will produce a fatal error and the system will not accept your spreadsheet until you input a valid counterparty ID.  

3) Please obtain access to the Global Counterparty system to look up valid Counterparty ID's for any new counterparties that you might add to your spreadsheet in the future.

If you have any questions or concerns, please feel free to call me: 5-7069.

Thank you.

Sue Vasan.