RE: Post id's for request

Thank you so much for this query. At this time, I am not sure what happened to the numbers in our spreadsheet. The data was pulled from AdHoc by calculating East, West, Eastbank, & Westbank. However, the total we retrieved from AdHoc did not match the total Portcalc value. I do not want you to spend time trying to figure out what happened to our spreadsheet because it could have been anything from using the wrong code to calc the books to simple user error. There are too many variables that are unknown.

The good thing is, it works now.

Thanks,
Stacey

-----Original Message-----
From: Yang, Zhiyun
Sent: Thursday, January 17, 2002 1:36 PM
To: White, Stacey W.; Evans, Casey
Cc: Lee, Norman
Subject: RE: Post id's for request

Hi Stacey:

We were able to pull out the P&L vs Counter Party for the four Post IDs, and the total matched the $986,414,195 you gave, it seems that there are more counterparties than what you included in the spreadsheet. Please see the attached spreadsheet for details.

<< File: PL_11_30_2001recalc.xls <<

Could you let us know how the number in your spreadsheet was generated? Was it from DPR or some other spreadsheet? Maybe we can take a look at the query to see if something is missed.

Thanks,

- Zhiyun

-----Original Message-----
From: White, Stacey W.
Sent: Thursday, January 17, 2002 12:24 PM
To: Yang, Zhiyun
Cc: Lee, Norman
Subject: Post id's for request

The following post-id's represent the re-calcs for 11-30:
15785 - total P&L $48,108,223
15786 - total P&L $(128,887,942)
15788 - total P&L $1,168,735,362
15789 - total P&L $(101,541,449)

The total forward P&L for these post-id's should be $986,414,195

The following spreadsheets represents the final product from our request. Please see if you can pull by the parameters we chose from AdHoc.

<< File: 11-30-01 MTM.xls << << File: 11-30-01 Positions.xls <<

Stacey